The splits
The working dir
Intermediate files manipulated by the application are stored invar/studies/death-fr
var
└── studies
├── death-fr
│ ├── control
│ ├── split-all
│ │ ├── data
│ │ └── distrib-aspects
│ ├── split-death-age
│ │ ├── data
│ │ └── distrib-aspects
│ └──death-fr.sqlite3
└── planets.sqlite3
Execution
Build sqlite database
Text files downloaded fromdata.gouv.fr are first loaded in a local sqlite database, death-fr.sqlite3 (with an index on birth days).
It contains one table,
person with this structure:
create table person(
fname varchar(80),
gname varchar(80),
sex character(1),
bday character(8),
bcode character(5),
bname character(30),
bcountry varchar(80),
dday character(8),
dcode character(5),
dact character(9)
);
create index idx_bday ON person(bday);
This is done by another program, g5: https://github.com/tig12/g5.
php run-g5.php enrich deathfr raw2sqlite 1970-2025 > data/tmp/enrich/death-fr/sqlite-build-report.log
------------------------------------------------------- Total Execution time: 547.3 s - 00:12:07 ------------------------------------------------------- 28 917 511 lines parsed 28 803 832 lines inserted ----------------------- ERRORS ------------------------ ERR_NAME: 67 incorrect name - inserted anyway ERR_BDAY: 112 808 incorrect birth day - not inserted ERR_DDAY: 798 incorrect death day - not inserted ERR_POSTERIOR: 71 birth posterior to death - not inserted ERR_EXCEPTION: 2 exception => skipped 113 677 lines because of date problem
Compute planets
A local sqlite database,planets.sqlite3 contains the positions of planets computed at 12:00, for each day between 1700 and 2030.
Generated by:
php run-observe.php prepare planets 1700-2030
Compute splits
php run-observe.php death-fr/death-fr split-all php run-observe.php death-fr/death-fr split-age