EU Parliament Dashboard

Total MEPs: 0

Overview of MEPs by country and political group. Use the filters above to refine the data.

MEPs per Country (Top 10)

MEPs per Role/Affiliation

Browse all Members of the European Parliament (current and historic). Click "Show More" to load additional entries. To refresh or build the MEP dataset (API + historic + group normalization), use Data → Build MEP Dataset.

All MEPs (Current & Historic)

ID	Name	Country	Role/Affiliation	Status	Speeches	Actions

Parliament Sittings

Loading…

Date	Title	Number of Speeches	Details

Descriptive Analytics

Overview of macro topics, specific focuses, and recent trends.

🔍 Topic Filter (applies to all charts)

Time: Monthly Quarterly Yearly

Range: From To

Show Smooth Averages

Monthly Trends (Top Topics)

Top MEPs (by selected topic)

Select or search a macro topic and click Load to show the top 10 speakers (MEP, Country, Group, Speeches).

Topic:

MEP	Country	Group	Speeches
Click Load to show the top 10 speakers for the topic (or for all topics if left empty).

Macro Topics × Political Groups

Macro Topics × Languages

Coverage

Loading…

Top Specific Focus

Export Speech Data

Export individual speeches to CSV format. Select the data you want to include and choose a time frame.

📊 Export Settings

Select Fields to Export:

📋 Basic Information

Speech ID Sitting ID Activity Date Activity Start Date Activity Type Speech Order Created At

👤 Speaker Information

Speaker Name MEP ID Country Political Group (Standardized) Political Group (Raw) Political Group Kind Political Group Reason

📝 Content

Title Speech Content (Text) Language Sitting HTML Content Sitting Label Document Identifier Notation ID

🏷️ Topic Classification

Topic (Original) Macro Topic Specific Focus Classification Confidence Classified By (Model) Classified At (Timestamp) Classification Cost ($)

Time Frame:

All Time Last Year Last 6 Months Last 3 Months Custom Range

Full Data Download

Download the full SQLite snapshot of the European Parliament dataset. This is the stable single-file export intended for heavy local analysis, scripting, and agent-based research workflows.

Dataset Snapshot

Checking snapshot availability...

Use this for the full database snapshot. The browser handles the file download directly.

How To Use The File

The downloaded file is a SQLite database. You can open it with DB Browser for SQLite, Datasette, DuckDB, or the `sqlite3` CLI.

Quick local check:

sqlite3 /path/to/ep_data_snapshot.db ".tables"
sqlite3 /path/to/ep_data_snapshot.db "SELECT COUNT(*) FROM individual_speeches;"
sqlite3 /path/to/ep_data_snapshot.db "SELECT activity_date, speaker_name, macro_topic FROM individual_speeches LIMIT 20;"

If you want CSVs, generate them locally from this file instead of exporting the entire dataset through the website runtime.

Prompt For Your Agent

Give your coding or research agent a prompt like this after you download the database:

You are working with a local SQLite database file at /path/to/ep_data_snapshot.db.

Use sqlite3 or a Python/Node SQLite client to inspect the schema first, identify the main tables, and summarize the key columns. Then answer my questions by querying the database directly instead of guessing.

Rules:
- Start by listing tables and row counts.
- Inspect the schema for individual_speeches, sittings, and meps.
- Prefer SQL queries over loading the entire database into memory.
- When exporting large results, write them to files in batches.
- Show me the SQL you used and briefly explain the result.

My task is: [replace this with your actual analysis request]