BETA

Dumps

Parltrack publishes complete dumps of its database on a daily basis. These dumps are in JSON format, and they are compressed with the lzip[1] tool.

Due to most of the dumps being between 400 and 800 megabytes (at the time of writing in mid 2019) they might not be suitable to load all at once since when loaded into RAM they might use significantly more memory. To facilitate a record-by-record stream processing of these dumps, they are formatted in the following way, each line is one record, each prefixed either with:

  • '[' for the first record,
  • ',' for the other records,
  • ']' on its own for the last line
This means you can read the uncompressed JSON line-by-line, strip of the first character and process the rest of the line as JSON, you can stop processing if after stripping the first character an empty string remains, this means the end of the JSON stream.

All data is available under the Open Database License v1.0 (ODBL) license.

TableDescriptionDumpSizeLast UpdatedSchemaPrevious dumps
Scraper Log This contains all the logs from the last scraping. 2024-10-15.log.lz (summary) 197.9 KiB 2024-10-15
MEPs This dump contains all the basic information about the MEPs ep_meps.json.lz 6.4 MiB 2024-10-15
Dossiers This dump contains all the basic information about the dossiers in the EP ep_dossiers.json.lz 44.9 MiB 2024-10-15
MEP Activities This dump contains most of the activities of MEPs (such as plenary speeches, questions, interpellations, etc) ep_mep_activities.json.lz 33.6 MiB 2024-10-15 schema
MEP Plenary Amendments This dump contains most of the plenary amendments ep_plenary_amendments.json.lz 6.0 MiB 2024-10-15 schema
MEP Plenary Votes This dump contains most of the plenary roll-call votes ep_votes.json.lz 8.8 MiB 2024-10-14 schema
Committee Amendments This dump contains most of the committee amendments ep_amendments.json.lz 92.8 MiB 2024-10-15 schema
MEP Committee Votes This dump contains most of the committee roll-call votes ep_com_votes.json.lz 112.4 KiB 2024-10-15 schema
Committee Agendas This dump contains most of the committee agendas ep_comagendas.json.lz 977.8 KiB 2024-10-15 schema

[1] previously parltrack used xz, but due to claims xz being inadequate for long-term archiving we switched to lzip.