Cura data

Gauquelin5 program handles a subset of the data published on cura.free.fr : only persons with known names (famous persons).
This gives 21 249 persons (A1 -> A6, D6, D10, E1, E3).
They form the departure point of g5 database ; Gauquelin data are imported first, then Müller and skeptics and other complete the database.

Restoration is still incomplete (eg miss some names in serie A, miss birth place in D6, timezone offset computation...), further work is needed ; see generated files.

Cura data with names

Details on Gauquelin publications can be found on page 902gdG.html of cura.free.fr. Part of these informations were included in g5 code for documentation purpose.

The command
php run-g5.php cura look count
generates a comparison between numbers claimed on Cura web site and numbers found by g5 :
FileDateTitleN CuraN g5ΔExplanation
A11970-042088 sports champions2 0882 0871Y, see Cura web site
A21970-053644 scientists and medical doctors3 6443 6431Y, see Cura web site
A31970-073047 military men3 0473 0461N
A41970-111473 painters and 1249 French musicians2 7222 7202N
A51970-121409 actors and 1003 politicians2 4122 4102N
A61971-032027 writers and journalists2 0272 0261N
D61979-09450 New famous European Sports Champions4504491N
D101982-011398 data of successful Americans1 3981 3962N
E119842154 French Physicians, Military Men and Executives2 1542 1531N
E319841540 New French Writers, Artists, Actors, Politicians and Journalists1 5401 5391N
TOTAL21 48221 469
Δ = N Cura - N g5, difference between number of records claimed by Cura and and numbers found by g5.
Most of these differences have no known explanation, either a bug in g5 or a mistake on Cura web site or a mistake from Gauquelin.

Cura.free.fr contain two other pages with birth dates : Données de Naissance du CURA 1 (455 Birth Data) and Données de Naissance du CURA 2 (41 Birth Data), not yet included in g5 database.

Gauquelin unique id

Each person in g5 database has a unique id formed by its "slug", and several local ids, only unique within a source (see page on database).
Applied to Cura data, each person is at least related to 2 sources : one source called "cura" and one source related to its file of origin (ex "A1").
This gives at least 2 local ids for each person :
  • One id referring to its file of origin, using its field NUM of Cura file.
  • One id referring to "cura" source. This one is called the "Gauquelin unique id" (abbreviated GQID).
    It is built concatenating the id of its file of origin and its NUM within this file.
    Ex : for the first record of file A1 (Pierre Alard 1937-09-17), its GQID is A1-1.

For duplicate values (listed in several Cura files), the file where it was first published is retained to build its GQID - this corresponds to the alphabetical order of file names (A1 was published before A2 etc. - see Cura web site).

Example :
Louis Geraud 1902-07-06 is NUM 2054 in file A1 and NUM 1008 in file A2.
Its g5 unique id (slug) is geraud-louis-1902-07-06
Its local ids are :
Source Id
cura A1-2054
A1 2054
A2 1008
The GQID of this person is A1-2054.

Similarily a Müller unique id was defined.

Working on cura data

If you type :
php run-g5.php cura
the program tells you the possible values of datafiles for cura dataset :
Possible datafiles for dataset cura : all, A, A1, A2, A3, A4, A5, A6, D6, D10, E1, E3
  • all will operate on all cura files.
  • A will operate on all files of serie A.
  • Other values will operate on a single file.

The precise list of transformations depends on the concerned file, but for all files,
- the first transformation is raw2tmp,
- the second transformation is tweak2tmp
- the last transformation is tmp2db.

raw2tmp

For all cura datafiles, the first transformation is raw2tmp
It extracts data from html files located in data/raw/cura.free.fr and produces csv files located by default in data/tmp/cura (tmp dir can be modified in config.yml).

This is done for example with the command :
php run-g5.php cura D6 raw2tmp
During this step, some corrections are applied to the data.
Some corrections are common to all files :
  • Country codes are converted to ISO 3166.
  • Dates and times are merged to be stored in ISO 8601 format YYYY-MM-DD HH:MM:SS.
    In this step, dates are not modified ; if needed, legal time restoration (for A files) is done in a separate step.
  • Longitudes and latitudes are expressed in decimal degrees.
  • Occupation codes are computed.
  • Family and given names are computed when possible.

tweak2tmp

This is done after raw2tmp, see page tweak2tmp.

Other transformations

Other transformations (between tweak2tmp and tmp2db) may modify the files located in data/tmp/cura.

Precise transformations are described in the following pages :

Export to csv

Done with
php run-g5.php cura <datafile> export
where <datafile> can be any value understood by cura (A, A1 ... E3)

Duplicates

Analysis of the database shows that
  • 212 persons appear twice
  • 4 persons appear 3 times
This explains the difference 21 469 - 21 249 = 220 = 212 + (4 * 2)

Full restoration of names in A files may show more duplicates.

The command
php run-g5.php cura look dup
generates the following table containing the duplicates.
IdsPerson
A2-241
A6-282
Dumas Georges 1866-03-06
A1-2054
A2-1008
Geraud Louis 1902-07-06
A2-1098
E3-927
Le Gorgeu Victor 1881-05-05
A2-2766
A3-693
Laussedat Aimé 1819-04-15
A2-2580
A3-231
Binger Louis 1856-10-14
A2-2681
A3-527
Fave Ildephonse 1812-02-28
A2-2685
A3-534
Ferrie Gustave 1868-11-19
A2-2689
A3-539
Foch Ferdinand 1851-10-02
A2-2697
A3-560
Gallieni Joseph 1849-04-24
A2-2747
A3-645
Jonquieres Ernest 1820-07-03
A2-2765
A3-689
Laubeuf Maxime 1864-11-23
A2-2817
A3-777
Menabrea Louis 1809-09-04
A2-2841
A3-863
Perrier François 1833-04-18
A2-2886
A3-950
Sebert Hippolyte 1839-01-31
A2-2904
A3-979
Tilho Jean 1875-05-01
A3-1344
A5-1689
Graziani Rodolfo 1882-08-11
A2-3134
A3-1600
Sacco Luigi 1883-08-01
A2-3168
A3-1683
Toraldo Francia Orazio 1884-09-09
A2-2213
A3-2177
Tillmanns Hermann 1844-10-04
A3-2309
A6-1052
Collin J 1878-11-25
A2-3432
A3-2315
Cornet Jules 1865-03-04
A2-3442
A3-2363
Denis Hector 1842-10-29
A3-2371
A5-2168
Destree Jules 1863-08-21
A2-2346
A3-2410
Firket Charles 1852-09-02
A3-2566
A5-2237
Neuss Hubert 1839-12-10
A3-2653
A5-2275
Tibbaut Emile 1862-06-12
A2-3551
A3-2941
Tilly Joseph 1837-08-16
A5-132
A6-144
Brasseur Pierre 1905-12-22
A4-443
A5-359
Geffroy Edmond 1804-07-30
A4-1957
A5-422
Herve Florimond 1825-06-30
A4-753
A5-541
Melingue Etienne 1807-04-16
A5-1312
A6-1069
Delacre Jules 1883-02-21
A1-153
A5-1432
Corniglion-Molinier Edward 1898-01-23
A1-258
A5-1567
Badoglio Pietro 1871-09-28
A1-260
A5-1568
Balbo Italo 1896-06-05
A3-1087
A5-1572
Bencivenga Roberto 1872-10-02
A1-282
A5-1588
Bonzani Alberto 1872-02-01
A3-1168
A5-1617
Cavallero Ugo 1880-09-20
A3-1191
A5-1624
Clerici Ambrogio 1868-11-18
A2-3002
A5-1632
Corbino Mario 1876-04-30
A3-1224
A5-1641
De Bono Emilio 1866-03-19
A3-1288
A5-1673
Ferretti Lando 1895-05-02
A3-1306
A5-1680
Gabba Melchiade 1874-08-20
A3-1323
A5-1684
Gazzera Pietro 1879-12-11
A3-1342
A5-1688
Grandi Dino 1895-06-04
A2-1491
A5-1723
Martino Gaetano 1900-11-25
A2-3089
A5-1753
Nobile Umberto 1885-01-21
A3-1505
A5-1767
Piacentini Pietro 1898-11-26
A1-459
A5-1773
Pricolo Francesco 1891-01-30
A3-1561
A5-1781
Ricci Renato 1896-06-01
A3-1630
A5-1808
Sechi Giovanni 1871-01-18
A3-1881
A5-1906
Göring Hermann 1893-01-12
A3-2120
A5-2046
Schleich Eduard 1888-08-09
A3-2240
A5-2126
Banning Emile 1836-10-12
A3-2241
A5-2127
Bara Jules 1835-08-23
A3-2249
A5-2130
Bethune Léon 1864-07-07
A3-2274
A5-2133
Brassine Jacques 1830-10-12
A3-2286
A5-2139
Burlet Jules 1844-04-10
A3-2291
A5-2143
Camus Camille 1883-05-09
A3-2311
A5-2148
Cooreman Gérard 1852-03-25
A3-2755
A5-2150
Cousebant D'Alkemade Alexandre 1840-04-26
A3-2337
A5-2152
Davignon Henri 1854-12-03
A3-2350
A5-2158
Delbeke Auguste 1853-08-12
A3-2777
A5-2164
Denis Henri 1877-09-10
A3-2367
A5-2166
Descamps Edouard 1847-08-27
A3-2375
A5-2170
Devolder Joseph 1842-07-07
A3-2389
A5-2174
Droogmans Hubert 1858-09-06
A3-2418
A5-2182
Franck Louis 1868-11-28
A3-2435
A5-2187
Goblet Alviella Eugene 1846-08-10
A3-2440
A5-2191
Graux Charles 1837-01-04
A3-2824
A5-2196
Heenen Gaston 1880-02-20
A3-2463
A5-2199
Heuvel Jules 1854-11-16
A3-2842
A5-2216
Kestens P 1867-12-29
A3-2493
A5-2218
Lantsheere Th 1833-11-04
A2-3499
A3-2853
A5-2219
Liagre Jean 1815-02-18
A3-2515
A5-2220
Liebaert Julien 1848-06-22
A3-2534
A5-2224
Magnette Charles 1863-02-03
A3-2537
A5-2226
Malou Jules 1810-10-19
A3-2542
A5-2228
Masson Fulgence 1854-02-16
A3-2565
A5-2235
Neujean Xavier 1840-01-23
A2-2422
A5-2238
Noef Pierre 1873-07-26
A3-2588
A5-2247
Pirmez Eudore 1830-09-14
A3-2909
A5-2252
Renard Bruno 1804-04-16
A3-2601
A5-2253
Renkin Jules 1862-12-03
A3-2609
A5-2257
Rolin-Jaequemyns Gustave 1835-01-31
A3-2616
A5-2258
Rubbens Edmond 1894-01-15
A3-2629
A5-2260
Schollaert François 1851-08-19
A3-2636
A5-2264
Smet Nayer Paul 1843-05-13
A3-2650
A5-2273
Thibaut Xavier 1817-10-27
A3-2666
A5-2283
Vandenpeereboom Jules 1843-03-18
A3-2667
A5-2284
Vandervelde Emile 1866-01-25
A3-2706
A5-2293
Woeste Charles 1837-02-26
A3-2965
A5-2310
Bos Hendrik 1907-04-26
A3-2974
A5-2315
Casembroot Eduard 1812-06-20
A3-2999
A5-2346
Jonge Bonifacius 1875-01-22
A5-4
A6-5
Adam Alfred 1908-04-04
A4-62
A6-62
Bataille Henry 1872-04-04
A5-84
A6-85
Berat Frédéric 1801-03-13
A5-115
A6-125
Botrel Theodore 1868-09-14
A5-131
A6-143
Brassens Georges 1921-10-22
A5-144
A6-156
Bruant Aristide 1851-05-06
A4-237
A6-208
Cocteau Jean 1889-07-05
A5-261
A6-262
Dorin René 1891-11-13
A2-2667
A6-279
Duhem Pierre 1861-06-10
A3-524
A6-306
Farrere Claude 1876-04-27
A4-425
A6-341
Fromentin Eugène 1820-10-24
A5-360
A6-359
Gelin Daniel 1921-05-19
A5-378
A6-373
Glatigny Joseph 1839-05-21
A4-536
A6-423
Hugo Victor 1802-02-26
A4-543
A6-430
Jacob Max 1876-07-12
A4-570
A6-443
Klingsor Tristan 1874-08-08
A3-736
A6-517
Loti Pierre 1850-01-14
A6-578
E3-1090
Mistler Jean 1897-09-01
A5-580
A6-594
Nadaud Charles 1820-02-20
A2-2853
A6-642
Poincare Henri 1854-04-29
A5-685
A6-699
Rollinat Maurice 1846-12-29
A5-694
A6-709
Roussin André 1911-01-22
A1-224
A6-712
Roy Jules 1907-10-22
A2-2898
A6-763
Teilhard De Chardin Pierre 1881-05-01
A5-740
A6-778
Trenet Charles 1913-05-18
A4-1094
A6-784
Valery Paul 1871-10-30
A5-761
A6-798
Vian Boris 1920-03-10
A5-1636
A6-862
Croce Benedetto 1866-02-25
A3-1239
A6-866
Delcroix Carlo 1896-08-22
A5-1828
A6-982
Tieri Vincenzo 1895-11-28
A2-2310
A6-1038
Candeze Ernest 1827-02-22
A5-1310
A6-1044
Cauwenberghe César 1870-05-14
A3-2298
A6-1045
Chaudoir Georges 1873-10-05
A5-1311
A6-1058
Cortvrient Alfons 1850-06-24
A3-2567
A6-1162
Neve Paul 1851-12-19
A5-1316
A6-1195
Schepens Adolphe 1819-04-13
A5-1317
A6-1219
Vandevelde Antonius 1895-07-08
A5-1366
A6-1279
Kan Willem 1911-01-15
A5-2398
A6-1341
Vissering Simon 1818-06-23
A5-835
D6-91
Carnera Primo 1906-10-25
A5-1418
E1-147
Bidault Georges 1899-10-05
A4-1597
E1-189
Bondeville Emmanuel 1898-10-29
A4-1615
E1-223
Boulez Pierre 1925-03-26
A3-444
E1-493
Cousteau Jacques 1910-06-11
A1-33
A5-283
E1-660
Duhour Clément 1911-12-11
A1-170
E1-782
Frantz Joseph 1890-08-07
A2-1022
E1-908
Grasset Jacques 1905-03-15
A5-1475
E1-1098
July Pierre 1906-09-09
A1-2062
E1-1126
Lacoste René 1904-07-02
A2-1097
E1-1252
Leger Lucien 1912-08-29
A4-684
E1-1322
Lorjou Bernard 1908-09-09
A1-1955
E1-1459
Mias Lucien 1930-09-28
A5-1513
E1-1534
Moynet André 1921-07-19
A1-1970
E1-1682
Pomathios Michel 1924-03-18
A3-902
E1-1744
Reilinger Alfred 1900-11-15
A5-667
E1-1772
Richard Jean 1921-04-18
A6-708
E1-1847
Rousset David 1912-01-18
A6-722
E1-1875
Salacrou Armand 1899-08-09
A6-730
E1-1894
Sauvy Alfred 1898-10-31
A5-1538
E1-1908
Secretain Roger 1902-08-25
A1-72
E1-1936
Skawinski Pierre 1912-12-23
A6-59
E3-65
Barres Maurice 1862-08-17
E1-97
E3-74
Bayrou Maurice 1905-03-02
A3-208
E3-117
Besnard Armand 1833-10-11
A2-817
E3-141
Bodin Jean 1899-08-28
A2-2587
E3-164
Borel Emile 1871-01-07
A3-350
E3-188
Boulanger Georges 1837-04-29
A2-2601
E3-211
Breton Jules 1872-04-01
E1-270
E3-231
Brun Jean 1849-04-24
E1-357
E3-291
Chaban-delmas Jacques 1915-03-07
A4-212
E3-309
Charbonnier Pierre 1897-08-24
D6-104
E3-362
Colas Alain 1943-09-16
A6-232
E3-441
Daudet Léon 1867-11-16
A5-1440
E3-454
Defferre Gaston 1910-09-14
A6-248
E3-482
Deroulede Paul 1846-09-02
E1-607
E3-498
Devay Jean-François 1925-10-15
A6-272
E3-538
Drumont Edouard 1844-05-03
E1-804
E3-678
Galley Robert 1921-01-11
A6-347
E3-685
Garaudy Roger 1913-07-17
A6-372
E3-716
Giraudoux Jean 1882-10-29
A2-1028
E3-736
Grinda Edouard 1866-12-20
D6-207
E3-787
Herzog Maurice 1919-01-15
E1-1031
E3-802
Husson Albert 1912-08-03
A1-182
E3-804
Hymans Max 1900-03-02
A4-1981
E3-812
Jacob Maxime 1906-01-13
E1-1059
E3-822
Jarrot André 1909-12-13
A6-436
E3-824
Jaures Jean 1859-09-03
E1-1329
E3-971
Louis Roger 1925-01-29
A6-534
E1-1368
E3-988
Malraux André 1901-11-03
A1-59
E3-999
Marcillac Raymond 1917-04-11
A6-562
E3-1038
Maurras Charles 1868-04-20
A3-783
E3-1069
Messimy Adolphe 1869-01-31
A6-580
E1-1477
E3-1092
Moinot Pierre 1920-03-29
A2-2830
E3-1162
Painleve Paul 1863-12-05
E1-1602
E3-1175
Paris Henri de 1908-07-05
A4-2176
E3-1182
Passani Emile 1905-02-07
A2-1181
E3-1191
Pechin Charles 1871-06-21
A2-2844
E3-1210
Perrin Jean 1870-09-30
A3-869
E3-1216
Peyron Alexandre 1823-06-21
A2-2849
E3-1225
Picard Alfred 1844-12-21
E1-1696
E3-1260
Poujade Pierre 1920-12-01
A6-659
E3-1273
Prouteau Gilbert 1917-06-14
E1-1703
E3-1274
Prouvost Jean 1885-04-24
E1-1709
E3-1280
Pujo Bertrand 1878-08-21
E1-1848
E3-1346
Roussin Albert 1821-08-02
E1-1989
E3-1452
Tesson Philippe 1928-03-01
A6-813
E3-1540
Zola Emile 1840-04-02
A2-130
A6-172
Carrel Alexis 1873-06-28
A2-162
E3-351
Clemenceau Georges 1841-09-28
A2-193
E1-550
Delaby Raymond 1891-09-20
A2-198
A6-240
Delay Jean 1907-11-14
A2-239
A6-278
Duhamel Georges 1884-06-30
A2-309
E3-721
Godart Justin 1871-11-26
A2-503
E3-1070
Mesureur Gustave 1847-04-02
A2-526
E3-1120
Mourier Louis 1873-10-08
A2-604
A6-663
Quatrefages de Bréau Jean Louis Armand 1810-02-10
A2-687
E3-1435
Strauss Paul 1852-09-23
A5-1685
A6-894
Giannini Guglielmo 1891-10-14
A5-1739
A6-919
Morandi Rodolfo 1902-07-30
A4-1266
A6-972
Soffici Ardengo 1879-04-07
A5-1832
A6-988
Treves Paolo 1908-07-27