1083 physicians (Arno Müller vol. 5)

Generalities

This group was built by Arno Müller and Suitbert Ertel in 1994.
Data were published by Arno Müller in "1083 members of the French Académie de Médecine", Astro-Forschungs-Daten 5, Waldmohr, 1994, 92 pp.
Data available in an electronic format on newalchemypress.com web site, through file 5muller_medics.txt.

Newalchemypress says that this file concerns one of the two independant replications of a Gauquelin planetary effect by Arno Müller. So this file has a particular historical interest.

An other interest of this file is the good quality of its data : full copy of birth certificate name with accents (not always), separation of family and given names, legal hour, timezone offset indications.

Integration to g5

The raw input file, versioned with g5, is data/raw/muller/5-medics/5a_muller-medics-utf8.txt

The full set of transformations can be executed with the command :

php run-g5.php muller m5medics all

This is equivalent to :

php run-g5.php muller m5medics raw2tmp
php run-g5.php muller m5medics tweak2tmp
php run-g5.php muller m5medics fixGnr update

Generate temporary file

The first step is to generate the file data/tmp/muller/5-medics/muller5-1083-medics.csv :

php run-g5.php muller m5medics raw2tmp

This step includes minor corrections in given names (some accents are missing).

tweak2tmp

This step applies human corrections stored in file data/db/init/newalch-tweaked/muller5-1083-medics.yml.
Used to fix errors in the names of noble persons (see below).

Fix GNR

GNR seems to mean "Gauquelin Number Record".

GNR value	Meaning
Starting by SA2	From Gauquelin file A2 (SA may mean "Serie A") ex: SA232 corresponds to Gauquelin id A2-32.
Starting by ND1	From Gauquelin file E1 (ND1 may mean "New Data 1") ex: ND1204 corresponds to Gauquelin id E1-204.

This command counts the records associated to Gauquelin files :

php run-g5.php muller m5medics look gnr

EMPTY 	: 224
A2 	: 765
E1 	: 94
A2 + E1 : 859
Total 	: 1083

First executions of

php run-g5.php muller m5medics look

showed abnormal differences for some names. This led to identify errors on GNR.

The command

php run-g5.php muller m5medics fixGnr report

lists the GNRs to fix with the corresponding values of dates and names in A2 and E1.
This step is necessary, to manually check that the fix does not introduce wrong associations (this is not the case).

Show details

For each GNR > 99, the code builds a list af possible matches in Gauquelin files (for example, A code 103 in Müller's file could correspond to 103, 1030, 1031 ... 1039.
To choose the right match, the code uses field DATE (in fact, it uses only the day).
But cura files contain errors in DATE field.
The improbable situation could have occured : among the 11 candidates, the good one contains an error in DATE, and an other candidate has Müller's date.
In this case, the code would have generated a mistake. So report with human check is necessary.

Conclusions:
- Column GNR is truncated, so GNRs superior to 99 are possibly erroneous.
- 87 records have a wrong GNR.

Finally, the command

php run-g5.php muller m5medics fixGnr update

fixes GNR in 87 records of data/tmp/muller/5-medics/muller5-1083-medics.csv.

Following steps are not part of Müller 1083MED restoration process, but are included in the processes of A2 and E1.
Prequisites:

php run-g5.php gauq A2 raw2tmp
php run-g5.php gauq A2 tweak2tmp

php run-g5.php gauq E1 raw2tmp
php run-g5.php gauq E1 tweak2tmp

php run-g5.php muller m5medics raw2tmp
php run-g5.php muller m5medics tweak2tmp
php run-g5.php muller m5medics fixGnr update

Fix Gauquelin birth days

The command

php run-g5.php muller m5medics look gauqdays

displays the differences between Müller's birth days and A2 and E1.

Müller NR 31   1904-04-06	| Aubry	| Maurice Charles Louis
E1    NUM 45   1899-04-06	| AUBRY Maurice Charles	| 

Müller NR 107  1808-02-04	| Blondlot	| Nicolas
A2    NUM 80   1808-02-05	| Blondlot	| Nicolas

(... displays 39 differences ...)

Compare Müller / A2 E1 birth days
        | Equal         | Different  | Total
--------------------------------------------
A2      | 730 (95.42 %) | 35 (4.58 %)| 765
E1      | 90  (95.74 %) | 4  (4.26 %)| 94
A2 + E1 | 820 (95.46 %) | 39 (4.54 %)| 859

So among the 859 common records, 39 have different birth days (4.54 %).

Note: birth times were not compared because Gauquelin dates (coming from Cura A2) are converted to UTC, and Müller dates are legal times.

The only way to find out which day is correct is to check on birth certificates.
French registries are available online, so checking is possible, but this is a long process.
Very few records were really checked, and all of them showed that the error was coming from Gauquelin file.

Müller NR 107	Blondot Nicolas	1880-02-04
Gauquelin A2-80	Blondot Nicolas	1880-02-05
Checking online civil registry seems to indicate that the error comes from file A2. Not a firm conclusion because the birth certificate is hard to understand. But the declaration date (1808-02-05 16:00) correponds to the birth date in A2. The declaration cannot be simultaneous with birth date, so A2 date is erroneous. To check : Archives des Vosges, commune de Charmes, registre 4E92/7, p 14 / 22. Birth certificate permits to check that Müller's hour is correct (16:00 - quatre heures du soir).
Müller NR 342	Fabre Jean	1864-06-08
Gauquelin A2-255	Fabre Jean	1874-06-08
Checking online civil registry permits to conclude that the error comes from file A2. Jean Fabre is born in 1864, in Lyon, 4th arrondissement. See Table décennale and birth certificate : Lyon 4e Naissances - 2E10360 - p 56 / 129. Birth certificate also permits to check that Müller's hour is correct (04:00).
Müller NR 484	Heuyer Georges Jean-baptiste	1884-01-30
Gauquelin A2-1051	Heuyer Georges	1884-07-30
Checking online civil registry permits to conclude that the error comes from file A2. Heuyer Georges Jean-baptiste is born 1884-01-30. See birth certificate on registry 8 Mi 4969 (NMD 1883-1892) , Pacy-sur-Eure, p 55 / 585. Birth certificate also permits to check that Müller's hour is correct (20:30).
Müller NR 743	Morice André Marie Gustave Emile Etienne	1890-07-31
Gauquelin E1-1520	MORICE André	1891-07-31
Checking online civil registry permits to conclude that the error comes from file E1. Morice André Marie Gustave Emile Etienne is born 1890-07-31. See birth certificate on registry Etat-civil de Caen, Naissances 1890, p 141 / 251. Birth certificate also permits to check that Müller's hour is correct (15:00).
Müller NR 914	Rocher Henri Gaston Louis	1876-05-28
Gauquelin E1-1806	ROCHER Louis	1876-05-27
Checking online civil registry permits to conclude that the error comes from file E1. Morice André Marie Gustave Emile Etienne is born 1876-05-28. See birth certificate on registry 4 E 1548, p 99 / 274. Birth certificate also permits to check that Müller's hour is correct (16:00).

The supposition was made that Müller's days are globally more exact than Gauquelin's, which lead to inject Müller's days in A2 and E1.

Warning: This may lead to introduce errors in Gauquelin data
(cases where Gauquelin is correct and Müller erroneous).

Note : extrapolating the error rate of 4.54 % to all Gauquelin data used in g5 program (21 249) leads to 964 erroneous dates in Gauquelin files. This does not permit to suppose that this error rate was the same in Gauquelin's original data, because errors may have been introduced in the editing process of cura.free.fr.

Execution for A2 :

php run-g5.php muller m5medics fixGauq A2 days update

33 records modified in data/tmp/gauq/lerrcp/A2.csv

for E1 :

php run-g5.php muller m5medics fixGauq E1 days update

2 records modified in data/tmp/gauq/lerrcp/E1.csv

Fix Gauquelin names

The command :

php run-g5.php muller m5medics look gauqnames

prints side by side family and given names of records present both in Müller's file and file A2.

This shows that Müller's names are better - They sometimes contain second and third given names, as written in civil registry. It also shows that spelling of name contain mistakes for noble persons (see above).
Step fixGauquelin copies Müller's names in corresponding Gauquelin records.

php run-g5.php muller m5medics fixGauq

PARAMETER MISSING - This function needs 3 parameters :
  Param 1 can be : 'A2', 'E1'
  Param 2 can be : 'names', 'days'
  Param 3 can be : 'report', 'update'

To restore the names :

php run-g5.php muller m5medics fixGauq A2 names update

739 records modified in data/tmp/gauq/lerrcp/A2.csv
12 unknown names restored in A2

php run-g5.php muller m5medics fixGauq E1 names update

82 records modified in data/tmp/gauq/lerrcp/E1.csv
0 unknown names restored in E1

This permits to restore (only) 12 unknown names from A2.

Fix Paris

The file contains 110 persons born in Paris, which need to be checked (see Newalchemypress indication below, sections SAMPLE and GAUQ_NUR).

Fix arrondissement

All people in Müller's file are noted Paris 1er arrondissement, which is not correct. There is a way to find the arrondissement : check in Gauquelin file A2 and find the corresponding person, using birth date ; the arrondissement is noted in A2.
Once the arrondissement is found, it's possible to check in the online registries.

Check dates and times

Checking is possible using online archives, but there is one important restriction : part of the Paris archives were destroyed in 1871 (events known as "La commune de Paris", some acts and their backups were burnt), and acts prior to 1860 were lost. Partial reconstitutions of the acts could be done. Online data prior to 1860 contain birth day but no time. There may exist other reconstitutions containing birth times, but I don't know where (maybe present on sites demanding registration and / or pay, like familysearch.org or filae.com).

So I don't know where Gauquelin found the birth times of persons born in Paris before 1860.

php run-g5.php muller m5medics look paris

Shows that there are 70 persons born before 1860 ; only possible to check 110 - 70 = 40 persons.
7 have been checked so far, one error was found :

Balthazard Victor 1872-01-01 09:00
NR 47
A2-32
Paris 11
ERROR IN BIRTH TIME : 21:00 ("neuf heures du soir"), not 09:00

TODO

Include these corrections in data/db/init/newalch-tweak/muller5-1083-medics.yml to be processed by step tweak2tmp.
Check the remaining records.

Fix nobilities

Listing names shows small errors in columns FNAME and GNAME of noble persons.

Sometimes the nobility is included in the given name (it should be part of the family name).
The nobility is uppercased (it should be lowercased).

To list the noble persons of the file.

php run-g5.php muller m5medics look nobilities simple

61 de Barthez| Antoine Charles Ernest
152 de Brun| Hippolyte Marie Antoine
(...)
1044 de Vernejoul| Robert
16 records concern noble persons.

The command :

php run-g5.php muller m5medics look nobilities yaml

prints the same list in a YAML format.

This was used to copy the output in file data/db/init/newalch-tweak/muller5-1083-medics.yml.
Nobilities are then all fixed by step tweak2tmp.

Looking at the file

The rest of this page concerns preparatory code
and is not part of any data transformation process.

With class src/commands/newalch/muller1083/look.php :

php run-g5.php muller m5medics look

PARAMETER MISSING
Possible values for parameter : gauqdates, gauqnames, fields, gnr, nobilities, paris, sample

Fields

php run-g5.php muller m5medics look fields

Partial comprehension so far.

Field	Meaning
NR	Müller id, from 1 to 1083
SAMPLE	Origin of the record
GNR	Gauquelin NUM in A2 or E1
CODE
NAME	Family and given name
GEBDATUM	Birth day
JAHR	Birth year
GEBZEIT
GEBORT
LAENGE
BREITE
MODE
KORR
ELECTDAT	Date of election in Académie de médecine
ELECTAGE	Age of election
STBDATUM
SONNE
MOND
VENUS
MARS
JUPITER
SATURN
SO_
MO_
VE_
MA_
JU_
SA_
PHAS_
AUFAB
NIENMO
NIENVE
NIENMA

Column SAMPLE

This column seems to indicate the origin of the record.
There is a one to one mapping between SAMPLE and CODE.

php run-g5.php muller m5medics look sample

to generate a html table :

php run-g5.php muller m5medics look sample table

SAMPLE	CODE	Nb	GNR ?
MUER_NUR	1	224	N
MUERGAUQ-d	2	79	Y
MUERGAUQ	3	612	Y
GAUQ_NUR	4	168	Y

Indications from newalchemypress.com :

Only for those in Michel's original group born in Paris (168) was Müller unable to re-check their birth data (...) This new total of Academie members had 224 not in MG's original sample.

GAUQ_NUR

Newalchemypress indication about Paris could designate GAUQ_NUR, but it doesn't match :

GAUQ_NUR total	168
GAUQ_NUR not born in Paris	59
GAUQ_NUR born in Paris	109
Total born in Paris	110 (1 marked MUER_NUR)

MUER_NUR

All MUER_NUR records have GNR empty, unknown in Gauquelin data => corresponds to Newalchemypress indication.