search

regardscitoyens / the-law-factory

Track the french law-making process
https://www.lafabriquedelaloi.fr
GNU Affero General Public License v3.0
76 stars 15 forks source link

Senator group shown is not the one at the time but the current one #214

Closed mdamien closed 6 years ago

mdamien commented 6 years ago

Adding to known issue but this should be fixed at the level of nossenateurs.fr when we have time for that.

EDIT: Here's how to get them (via @RouxRC)

wget http://data.senat.fr/data/senateurs/export_sens.zip -O
senateurs-opendata.zip
unzip senateurs-opendata.zip
sudo su - postgres
  dropdb senateurs-opendata
  createdb senateurs-opendata
  exit
cat export_sens.sql | grep -v 'OWNER.*opendata' | psql senateurs-opendata
echo "SELECT s.senmat, s.sennomuse, s.senprenomuse, g.grppolcod,
mg.memgrppoldatdeb, mg.memgrppoldatfin, f.fongrppollic,
fmg.fonmemgrppoldatdeb, fmg.fonmemgrppoldatfin
      FROM sen s, grppol g, memgrppol mg, fonmemgrppol fmg, fongrppol f
      WHERE s.senmat = mg.senmat AND mg.memgrppolid = fmg.memgrppolid
AND g.grppolcod = mg.grppolcod AND fmg.fongrppolcod = f.fongrppolcod
      ORDER BY s.sennomtec, mg.memgrppoldatdeb, fmg.fonmemgrppoldatdeb" |
  psql -A -F "," --pset footer senateurs-opendata | sed 's/
00:00:00//g' | sed 's/,AUCUN,/,NI,/' > senateurs-groupes.csv

EDIT 2: Now available in data.senat.fr:

http://data.senat.fr/data/senateurs/ODSEN_HISTOGROUPES.csv http://data.senat.fr/data/senateurs/ODSEN_HISTOGROUPES.json http://data.senat.fr/data/senateurs/ODSEN_HISTOGROUPES.xls

boogheta commented 6 years ago

Fixed with https://github.com/regardscitoyens/the-law-factory-parser/commit/0d5dc8fa0f273e47bb554ad429e2f96442664bfd