How do you match up tables in the bulk data?

[mlissner]

A client writes:

I have a quick question about the case law that can be downloaded freely from your site.

I understand it comes in two dumps - one has the full text and the other holds the metadata including titles etc.?

If this is the case, how do you match these two dumps?

[mlissner]

Thanks for the question. You can see the full schema for the data here:

https://www.courtlistener.com/help/api/rest/

At the most basic level, you'll want to match up courts, dockets, opinions, and clusters:

• In opinions, you'll have a cluster_id field that links to the ID column in the cluster table.
• In clusters, you'll have a docket_id field that links to the ID column in the docket table.
• In dockets, you'll have a court_id field that links to the ID column in the court table.

And so forth, according to the schema diagram in the documentation.