Oudon case

[davidbgk]

Before new-start:

➜  communes grep 14624 towns.csv 
--,14624,Saint-Martin-de-Fresnay,1973-01-01,2020-01-01,NULL
<-,14624,Oudon,1973-01-01,1973-01-01,NULL

Now:

→ cat exports/towns/towns.csv | grep 14624               33ms
451551942-01-019999-01-01,45155,Gien,1942-01-01,9999-01-01,,,14624,0
146241973-01-019999-01-01,14624,Oudon,1973-01-01,9999-01-01,,146241942-01-011973-01-01;140101942-01-011973-01-01;140671942-01-011973-01-01;142341942-01-011973-01-01;142951942-01-011973-01-01;143141942-01-011973-01-01;143631942-01-011973-01-01;144471942-01-011973-01-01;144721942-01-011973-01-01;146971942-01-011973-01-01,NULL,0
146241942-01-011973-01-01,14624,Saint-Martin-de-Fresnay,1942-01-01,1973-01-01,146241973-01-019999-01-01,,NULL,110
140101942-01-011973-01-01,14010,Ammeville,1942-01-01,1973-01-01,146241973-01-019999-01-01,,NULL,330
140671942-01-011973-01-01,14067,Berville,1942-01-01,1973-01-01,146241973-01-019999-01-01,,NULL,330
142341942-01-011973-01-01,14234,Écots,1942-01-01,1973-01-01,146241973-01-019999-01-01,,NULL,330
142951942-01-011973-01-01,14295,Garnetot,1942-01-01,1973-01-01,146241973-01-019999-01-01,,NULL,330
143141942-01-011973-01-01,14314,Grandmesnil,1942-01-01,1973-01-01,146241973-01-019999-01-01,,NULL,330
143631942-01-011973-01-01,14363,Lieury,1942-01-01,1973-01-01,146241973-01-019999-01-01,,NULL,330
144471942-01-011973-01-01,14447,Montpinçon,1942-01-01,1973-01-01,146241973-01-019999-01-01,,NULL,330
144721942-01-011973-01-01,14472,Notre-Dame-de-Fresnay,1942-01-01,1973-01-01,146241973-01-019999-01-01,,NULL,330
146971942-01-011973-01-01,14697,Tôtes,1942-01-01,1973-01-01,146241973-01-019999-01-01,,NULL,330

See http://www.insee.fr/fr/methodes/nomenclatures/cog/fichecommunale.asp?codedep=14&codecom=624

[davidbgk]

Current status:

→ cat exports/towns/towns.csv | grep 14624
14010@1942-01-01,14010,Ammeville,1942-01-01 00:00:00,1972-12-31 23:59:59,14624@1973-01-01,,NULL,330
14067@1942-01-01,14067,Berville,1942-01-01 00:00:00,1972-12-31 23:59:59,14624@1973-01-01,,NULL,330
14234@1942-01-01,14234,Écots,1942-01-01 00:00:00,1972-12-31 23:59:59,14624@1973-01-01,,NULL,330
14295@1942-01-01,14295,Garnetot,1942-01-01 00:00:00,1972-12-31 23:59:59,14624@1973-01-01,,NULL,330
14314@1942-01-01,14314,Grandmesnil,1942-01-01 00:00:00,1972-12-31 23:59:59,14624@1973-01-01,,NULL,330
14363@1942-01-01,14363,Lieury,1942-01-01 00:00:00,1972-12-31 23:59:59,14624@1973-01-01,,NULL,330
14447@1942-01-01,14447,Montpinçon,1942-01-01 00:00:00,1972-12-31 23:59:59,14624@1973-01-01,,NULL,330
14472@1942-01-01,14472,Notre-Dame-de-Fresnay,1942-01-01 00:00:00,1972-12-31 23:59:59,14624@1973-01-01,,NULL,330
14624@1942-01-01,14624,Saint-Martin-de-Fresnay,1942-01-01 00:00:00,1972-12-31 23:59:59,14624@1973-01-01,,NULL,110
14697@1942-01-01,14697,Tôtes,1942-01-01 00:00:00,1972-12-31 23:59:59,14624@1973-01-01,,NULL,330
45155@1942-01-01,45155,Gien,1942-01-01 00:00:00,9999-12-31 23:59:59,,,14624,0
14624@1973-01-01,14624,Oudon,1973-01-01 00:00:00,9999-12-31 23:59:59,,14010@1942-01-01;14067@1942-01-01;14234@1942-01-01;14295@1942-01-01;14314@1942-01-01;14363@1942-01-01;14447@1942-01-01;14472@1942-01-01;14624@1942-01-01;14697@1942-01-01,NULL,0