The IUROPA CJEU Database

One row per judgment. Includes additional information about the court formation, panel composition, the Judge-Rapporteur, the Advocate-General, and procedure types and outcomes

One row per decision. Includes additional information about the proceeding.

One row per proceeding. Includes additional information on cases, transfers, and joins.

One row per appointment per judge or Advocate-General. Includes appointment dates and biographical information.

One row per party per judgment. Includes additional information about lawyers.

One row per case. Records the court, year, case number, and status flags for every case that appears in the Registry or should exist based on the Court's case numbering.

One row per proceeding. Includes proceeding ID, case ID, court, proceeding name, and suffix (e.g. P for appeal, DEP for costs). The central linking table for case-level analysis.

One row per decision. Records IUROPA decision ID, ECLI, CELEX, decision type, date, court, and the lead proceeding. The central linking table for all decision-level detail tables.

One row per joining relationship between proceedings. Records the joined proceeding and the lead proceeding to which it was joined.

One row per transfer of a proceeding to a different court. Links the original proceeding ID to the new proceeding ID at the receiving court.

One row per appeal relationship between proceedings. Links first-instance proceedings to their corresponding appeal proceedings at a higher court.

One row per lawyer per proceeding suffix. Records possible suffix in CJEU proceeding numbers and what the suffix means.

One row per hearing date per decision. Records the date of each oral hearing associated with a decision. Not all decisions include a hearing.

One row per outcome per legal procedure per decision. Records procedure type and outcome (successful, unfounded, inadmissible, etc.). A decision can have multiple procedures and multiple outcomes per procedure.

One row per referring national court per preliminary ruling decision. Records referring court name, standardized court ID, member state, referral date, and reception date.

One row per EUR-Lex directory code per decision. Records the section, major, and minor codes and labels used by the Commission to classify CJEU case law by subject matter.

One row per keyword per decision. Records the subject-matter keywords assigned by EUR-Lex.

One row per headnote per decision. Records the brief summaries of legal propositions assigned by EUR-Lex to each decision.

One row per citation between CJEU decisions. Records directed citation pairs (citing decision ID, cited decision ID) for constructing legal citation networks.

One row per individual judge or Advocate-General. Records name (with ASCII variant), member state, birth year, and gender. The primary key table for all judicial personnel joins.

One row per appointment per individual. Records court, position (judge, AG, President, Vice-President), start and end dates, and whether the appointment is currently active.

One row per biographical entry per individual. Records professional positions, memberships, degrees, and distinctions from official Court biographies, with position type classification.

One row per judge per decision. Records which judges sat on the panel for each decision and which judge served as the Judge-Rapporteur.

One row per Advocate-General per decision. Records which AG was assigned to each Court of Justice decision.

One row per chamber per decision. Records the chamber (e.g. Grand Chamber, Fifth Chamber) that issues each decision.

One row per party per decision. Records the name of the party as it appears in the text, a standardized party ID, party type (EU institution, EU agency, EU member state, company, organization, etc.), and party role (applicant, defendant, intervener, etc.).

One row per observer per decision. Records actors that submitted a written observation in a proceeding concerning a reference for a preliminary ruling.

One row per lawyer per client per decision. Records the lawyer's name and the client they represented in the proceeding assocated with the decision. Not all decisions include information on legal representation.