Gauquelin LERRCP - file D10

D10 was published in 1982 by Gauquelin. It contains birth dates of successful U.S. persons. Sportsmen contained in this file were used for a replication of "mars effect".
Inclusion of these data in g5 database is done using page 902gdD10.html from cura.free.fr.
Cura web page is almost perfect : it contains name, legal birth time, timezone offset, birth place, so importing it is just a matter of formatting.

About D10

Number of records

The number of records of this group could not be determined :
  • In the original LERRCP booklet, Gauquelin announces 1400 birth dates.
  • Accoding to cura.free.fr : D10 contains 1398 data of successful Americans.
  • G5 code finds only 1396 records in Cura web page. Records nb 355 and 902 are missing.
    Record 355 (Marcel Rozier) could be restored thanks to Ertel's file (num 3615).
    Record 902 could not be identified without access to the original document.

Profession codes

For sportspersons, precise sport codes are not specified. Some codes could be computed thanks to Ertel's file.

G5 integration

Importing raw file in database is done with following commands: 
php run-g5.php gauq D10 raw2tmp
php run-g5.php gauq D10 tmp2db
Step raw2tmp contains only minor fixes.

Small errors

There is one record without birth time: 
1098!	Rose Peter		SP	14	4	1941	-----	5h	39N6	84W31	Cincinnati, OH
Two lines miss longitude and latitude: 
493	Good Robert		AC	21	5	1922	06:00	6h			Grosby, MN
658	Jeter Robert		SP	9	5	1937	08:00	5h			Union, SC
These lines were fixed in the code of raw2tmp and included in the resulting file.

13 lines had to be fixed because of bad formatting (contain white spaces instead of tabs) : 
112	Blanton Leonard		PO	10	4	1930	21:30	6h	35N11   88W10	Hardin County, TN	
192	Caldwell Philip		EX	27	1	1920	08:00	5h	39N16   83W09	Bourneville, OH	
409	Faver Dudley		MI	17	8	1916	15:00	6h	32N28   100W24	Sweatwater, TX	
568	Hayes Elvin		SP	11	11	1945	22:00	6h	32N28   91W45	Rayville, LA	
817!	Malden Karl		AC	22	3	1912	17:00	6h	41N35   87W20	Gary, IN
935	Murphy William		EX	17	6	1907	10:00	6h	44N15   88W24   Appleton, WI		
945	Neal Patricia		AC	20	1	1926	04:30	6h	36N40   84W03	Packard, KY	
1033	Pitts William		MI	27	11	1919	06:00	8h	33N54   117W15  March Field, CA		
1058	Ramsey Lloyd		MI	29	5	1918	07:00	5h	37N05   84W36   Somerset, KY		
1066!	Reeves Steve		AC	21	1	1926	08:00	7h	48N11   106W38  Glasgow, MT
1158	Shaffer Raymond		EX	6	4	1912	22:30	6h	37N59   94W49   Harding, KS		
1218	Staiger John		EX	20	3	1910	19:00	6h	44N43   88W09   Chase, WI		
1250	Sweeney Walter		SP	18	4	1941	09:20	5h	42N14   70W48   Cohasset, MA
These lines were fixed in the code of raw2tmp and included in the resulting file.