⚖️ law

The legal corpus, one source per group of tables. It currently holds the United States Code (codified general and permanent federal statutes) from the Office of the Law Revision Counsel's USLM XML release points at uscode.house.gov, one row per section (about 60,500 at release point 119-111), covering Titles 1-52 and 54 and the appendices to Titles 5 and 18. This is the current in-force text at the latest release point (release_point column, e.g. 119-111 = current through Public Law 119-111), replaced wholesale on each run — it is not a history of prior versions. is_positive_law separates titles Congress has enacted as law itself (e.g. Titles 5, 18, 28) from titles that are only prima facie evidence of the law (e.g. Titles 26 and 42). Regulations (CFR) and private or temporary laws are not in this schema; the Federal Register lives in the fedregister schema. Tables: usc_sections (section_text holds the operative text of each whole section for reading; source_credit holds the enactment history citing each Public Law and Statutes at Large page); usc_subsections (the same text cut at subsection, paragraph and clause boundaries into units of at most 2,000 characters, the field embedded for semantic search); and bills with its child tables, covering every bill and resolution introduced in Congress from the GovInfo Bill Status bulk data — status and sponsor in bills; action history, cosponsors, committee referrals and their activity, subject terms, published text, related bills, amendments and their actions and cosponsors, roll-call votes, titles, CRS summaries, CBO estimates, committee reports and editorial notes in bill_actions, bill_cosponsors, bill_committees, bill_committee_activities, bill_subjects, bill_text_versions, bill_related_bills, bill_amendments, bill_amendment_actions, bill_amendment_cosponsors, bill_action_committees, bill_recorded_votes, bill_titles, bill_summaries, bill_cbo_cost_estimates, bill_committee_reports and bill_notes; and federal lobbying disclosures from LDA.gov — lobbying_filings (LD-1 registrations and LD-2 quarterly reports: who lobbied for whom and for how much) with lobbying_activities (the issues, in free text that names bills), lobbying_activity_lobbyists, lobbying_activity_government_entities, lobbying_activity_bills (the bills each activity names, extracted from that text), lobbying_foreign_entities, lobbying_affiliated_organizations and lobbying_conviction_disclosures; LD-203 political-contribution reports in lobbying_contribution_reports, lobbying_contribution_items and lobbying_contribution_pacs; the registries lobbyists, lobbying_registrants and lobbying_clients; and the code lists lobbying_issue_codes, lobbying_government_entity_codes, lobbying_filing_types and lobbying_contribution_item_types. The Senate Office of Public Records cannot vouch for the lobbying data or analyses derived from it after retrieval from LDA.gov.

54 datasets · 719 columns

usc_sections · table

One row per section of the U.S. Code at the current OLRC release point. The operative text of the section is in section_text (statutory notes, tables of contents and editorial footnotes are excluded); the Public Law and Statutes at Large citations that enacted and amended it are in source_credit. Sections that were repealed, omitted or transferred keep their row (status says which) but have a null section_text because no operative text remains. Filter on is_positive_law for titles enacted as law, and on title_number/chapter_number for a subject area (e.g. title 26 = Internal Revenue Code, 42 = Public Health and Welfare, 15 = Commerce and Trade).

Column	Type	Null	Description
title_number	string	no	U.S. Code title number as OLRC publishes it (e.g. 5, 26, 42; 5a for the Title 5 Appendix)
title_name	string	no	Title heading (e.g. GOVERNMENT ORGANIZATION AND EMPLOYEES)
is_positive_law	boolean	no	True when Congress has enacted the whole title into positive law (e.g. Titles 5, 18, 28); false when the title is only prima facie evidence of the law (e.g. Titles 26 and 42) and for every appendix
release_point	string	no	OLRC release point this row was read from, {congress}-{public law number} (e.g. 119-111 = current through Public Law 119-111)
section_number	string	no	Section number as printed, including letter suffixes and ranges for grouped repealed sections (e.g. 101, 1395w-4, 2 to 15)
section_seq	integer	no	1 for the first occurrence of section_number within the title, 2 for a second section the Code numbers identically (e.g. the two 5 U.S.C. 3598 sections)
usc_identifier	string	yes	USLM identifier (e.g. /us/usc/t5/s101); null for appendix titles, which carry none; a range of grouped repealed sections lists each identifier space-separated
citation	string	no	Standard citation, e.g. 5 U.S.C. § 101; appendix sections are cited 5A U.S.C. App. § 1
heading	string	yes	Section heading (e.g. Executive departments); Repealed, Omitted or Transferred for sections in those states
status	string	yes	OLRC section status when the section carries no current operative text under its own number: repealed, omitted, transferred, renumbered, reserved, vacant or unknown; null for a current section
hierarchy	string	yes	Path of enclosing divisions below the title, outermost first (e.g. Subtitle II — Civil Service > Part III — Employees > Chapter 33 — Examination, Selection, and Placement)
chapter_number	string	yes	Number of the enclosing chapter; null for sections that sit directly under the title or an appendix
chapter_heading	string	yes	Heading of the enclosing chapter
section_text	string	yes	Operative text of the section — its citation and heading on the first line, then every subsection, paragraph and clause on its own line, excluding statutory notes; null when nothing operative remains (repealed, omitted or transferred sections, and the few whose only content is a pointer in a note: the Title 18 "(Rule)" entries that refer to the Federal Rules of Criminal Procedure, and 19 U.S.C. 1202). Kept whole for reading; the copy embedded for semantic search is usc_subsections.unit_text
source_credit	string	yes	Enactment history in the Code's own words — each Public Law, date and Statutes at Large page that enacted or amended the section

usc_subsections · table

One row per unit of a U.S. Code section: the section's operative text cut at its own subsection, paragraph and clause boundaries into pieces of at most 2,000 characters, in document order. Join to usc_sections on (title_number, section_number, section_seq) for the section's heading, hierarchy, status and enactment history. Sections with no operative text (repealed, omitted, transferred, or pointer-only) have no rows here. unit_path says which divisions a row covers, so a hit can be cited to the subsection, for example 5 U.S.C. 552(a)(1) to (a)(2).

Column	Type	Null	Description
title_number	string	no	U.S. Code title number as OLRC publishes it (for example 5, 26, 42; 5a for the Title 5 Appendix); with section_number and section_seq it identifies the parent usc_sections row
section_number	string	no	Section number as printed, including letter suffixes (for example 101, 1395w-4)
section_seq	integer	no	1 for the first occurrence of section_number within the title, 2 for a second section the Code numbers identically
unit_seq	integer	no	1-based order of this unit within its section; with the three columns above it is the primary key
unit_path	string	yes	The divisions this unit covers, from the section down: (a)(1) for one division, (a) to (a)(2) for a run of adjacent ones, lead-in to (a) when the run starts with the section's own opening text; null when the whole section is one unit
citation	string	no	Citation of the unit, for example 5 U.S.C. § 552(a)(1) or 5 U.S.C. § 552(a) to (b); appendix sections are cited 5A U.S.C. App. § 1
unit_text	string	no	The unit's text, one division per line, excluding statutory notes; at most 2,000 characters unless a single unbroken run (one long paragraph, or a table) is longer. Text blob embedded into ref.vectorized_chunks as source_type usc_subsection

bills · table

Every bill and resolution introduced in the U.S. Congress, one row per bill, from the GovInfo Bill Status bulk data (the same data the Congress.gov API serves). Partitioned by congress (e.g. 119 = 2025-2026) and bill_type: hr (House bill), s (Senate bill), hjres / sjres (joint resolutions), hconres / sconres (concurrent resolutions), hres / sres (simple resolutions). bill_number is unique only within (congress, bill_type). latest_action_text / latest_action_date are the best single status signal (e.g. "Became Public Law No: 119-21.", "Referred to the House Committee on the Judiciary."); law_type and law_number are populated only once a bill is enacted. Sponsor columns carry the first listed sponsor. action_count and cosponsor_count count the rows in bill_actions and bill_cosponsors for the same bill; committee referrals, subjects, text, related bills, amendments, votes, titles, summaries, CBO estimates, committee reports and notes are in the other bill_* tables (bill_committees, bill_subjects, bill_text_versions, bill_related_bills, bill_amendments, bill_recorded_votes, bill_titles, bill_summaries, bill_cbo_cost_estimates, bill_committee_reports, bill_notes, ...). The current Congress changes daily at the source and is re-pulled monthly; completed Congresses are static. The source publishes the 108th Congress onward; the default GOVDATA_START_YEAR (2010) starts at the 111th.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type (H.R. 1 -> 1)
origin_chamber	string	yes	Chamber the bill was introduced in (House or Senate)
introduced_date	string	yes	Date introduced (YYYY-MM-DD)
title	string	yes	Official title as introduced (e.g. "An act to provide for reconciliation ...")
policy_area	string	yes	Congressional Research Service policy area (e.g. "Economics and Public Finance"); one per bill, assigned some time after introduction so early rows can be NULL
sponsor_bioguide_id	string	yes	Bioguide ID of the first listed sponsor; joins to officials.members
sponsor_full_name	string	yes	Sponsor display name with party and state, e.g. "Rep. Arrington, Jodey C. [R-TX-19]"
sponsor_party	string	yes	Sponsor party code (R, D, I)
sponsor_state	string	yes	Sponsor two-letter state code
sponsor_district	string	yes	Sponsor House district number; NULL for senators
latest_action_date	string	yes	Date of the most recent action (YYYY-MM-DD)
latest_action_text	string	yes	Text of the most recent action — the primary status signal
law_type	string	yes	Public Law or Private Law; NULL unless the bill was enacted
law_number	string	yes	Law number, e.g. 119-21; NULL unless the bill was enacted
action_count	integer	no	Number of actions recorded for the bill (rows in bill_actions)
cosponsor_count	integer	no	Number of cosponsors currently listed (rows in bill_cosponsors)
update_date	string	yes	Last update timestamp on Congress.gov
legislation_url	string	yes	Congress.gov page for the bill
latest_action_time	string	yes	Time of the latest action when recorded (HH:MM:SS); usually NULL
update_date_including_text	string	yes	Last update including text changes (UTC timestamp); NULL in a few older files
constitutional_authority_statement	string	yes	Constitutional authority statement as printed in the Congressional Record (text with markup); present for most recent bills
sponsor_is_by_request	boolean	yes	True when the sponsor introduced the bill by request
on_behalf_of_bioguide_id	string	yes	Bioguide ID of the member the bill was introduced on behalf of; rare, mostly older files
on_behalf_of_full_name	string	yes	Name of the member the bill was introduced on behalf of
on_behalf_of_type	string	yes	Relationship, e.g. "Introduced on behalf of"

bill_actions · table

Every recorded action on every bill in bills, one row per action, from the same GovInfo Bill Status XML — introduction, committee referral, markup, floor votes, passage, presentment, signing. Join to bills on (congress, bill_type, bill_number). action_seq numbers actions oldest-first starting at 1, so it stays fixed when later actions are added. action_type is the source's coarse category (observed in the 119th: IntroReferral, Committee, Floor, Calendars, Discharge, ResolvingDifferences, President, Veto, BecameLaw, NotUsed) and action_code its code (e.g. E40000). Only about a fifth of actions carry an action_time.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
action_seq	integer	no	Position of the action, 1 = oldest
action_date	string	yes	Date of the action (YYYY-MM-DD)
action_time	string	yes	Time of day when the source records one (HH:MM:SS), otherwise NULL
text	string	yes	Action text as recorded, e.g. "Referred to the House Committee on the Judiciary."
action_type	string	yes	Source's coarse action category
action_code	string	yes	Source action code
source_system	string	yes	Where the action was recorded — House floor actions, House committee actions, Senate, or Library of Congress
calendar_number	string	yes	Calendar code when the action placed the bill on a calendar (e.g. H00243); NULL otherwise

bill_cosponsors · table

Cosponsors of every bill in bills, one row per (bill, cosponsor), from the same GovInfo Bill Status XML. Join to bills on (congress, bill_type, bill_number) and to officials.members on bioguide_id. is_original_cosponsor is true for members who signed on at introduction; withdrawn_date is set when a cosponsor later withdrew. Bills with no cosponsors have no rows here. A member who withdrew and later re-signed appears twice, with different sponsorship_date; a few identical repeats also exist upstream (2 in the 108th-119th).

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
bioguide_id	string	no	Bioguide ID of the cosponsor; joins to officials.members
full_name	string	yes	Cosponsor display name with party and state
party	string	yes	Party code (R, D, I)
state	string	yes	Two-letter state code
district	string	yes	House district number; NULL for senators
sponsorship_date	string	yes	Date the member became a cosponsor (YYYY-MM-DD)
is_original_cosponsor	boolean	yes	True if the member cosponsored at introduction
withdrawn_date	string	yes	Date the member withdrew as cosponsor; NULL if still a cosponsor

bill_committees · table

Committees and subcommittees a bill was referred to, one row per committee or subcommittee, from the same GovInfo Bill Status XML. Join to bills on (congress, bill_type, bill_number). committee_system_code is the Congress.gov committee code (e.g. hsju00 = House Judiciary). A subcommittee row (e.g. hsvr10) has parent_committee_system_code set to its full committee's code and NULL chamber and committee_type, which the source records only on the full committee. committee_type is Standing, Select, Special or Other. What each committee did with the bill (referred, markup, reported, hearings) is in bill_committee_activities.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
committee_system_code	string	no	Congress.gov committee code, e.g. hsju00 (House Judiciary)
committee_id	string	no	committee_system_code in the form officials.committees uses: upper case, with the 00 that marks a full committee removed (hsju00 becomes HSJU, hsif14 becomes HSIF14). Joins to officials.committees.committee_id
committee_name	string	yes	Committee or subcommittee name, e.g. "Judiciary Committee"
chamber	string	yes	House, Senate or Joint; NULL on subcommittee rows
committee_type	string	yes	Standing, Select, Special or Other; NULL on subcommittee rows
parent_committee_system_code	string	yes	Full committee code when this row is a subcommittee; NULL on full-committee rows
parent_committee_id	string	yes	parent_committee_system_code in the form officials.committees uses: upper case, with the 00 that marks a full committee removed (hsju00 becomes HSJU, hsif14 becomes HSIF14). Joins to officials.committees.committee_id; NULL on full-committee rows

bill_committee_activities · table

Every recorded committee activity on a bill, one row per (committee or subcommittee, activity), from the same GovInfo Bill Status XML. Join to bill_committees on (congress, bill_type, bill_number, committee_system_code). activity_name values include Referred To, Markup By, Reported By, Hearings By (full committee), Discharged From, Reported Original Measure and Bills of Interest - Exchange of Letters, spelled as the source publishes them — capitalization is not consistent (Referred To / Referred to). activity_date is a UTC timestamp. The source occasionally repeats an identical activity, so the rows have no unique key.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
committee_system_code	string	no	Committee or subcommittee code; joins to bill_committees
committee_id	string	no	committee_system_code in the form officials.committees uses: upper case, with the 00 that marks a full committee removed (hsju00 becomes HSJU, hsif14 becomes HSIF14). Joins to officials.committees.committee_id
activity_name	string	yes	Activity as published, e.g. "Referred To", "Markup By", "Reported By"
activity_date	string	yes	UTC timestamp of the activity (YYYY-MM-DDTHH:MM:SSZ); NULL for a few activities

bill_subjects · table

Congressional Research Service legislative subject terms assigned to a bill, one row per (bill, subject), from the same GovInfo Bill Status XML — e.g. "Abortion", "Accounting and auditing". A bill can carry hundreds (H.R. 1 in the 119th has 239). The single broader policy area is bills.policy_area, not repeated here. Subjects are assigned some time after introduction, so a new bill may have none yet.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
subject_name	string	no	CRS legislative subject term
update_date	string	yes	When the term was last updated on Congress.gov (UTC timestamp)

bill_text_versions · table

Every published text version of a bill, one row per (version, format), from the same GovInfo Bill Status XML; the url points at the text on govinfo.gov. version_type follows the bill through Congress using GPO's stage names — Introduced in House/Senate, Referred in Senate, Reported in House, Reported to Senate, Placed on Calendar Senate, Engrossed in House/Senate, Engrossed Amendment House/Senate, Considered and Passed House/Senate, Agreed to House/Senate, Enrolled Bill, Public Law, and older stage names such as Additional Sponsors House and Committee Discharged Senate. format_type is set only for the "United States Legislative Markup" (USLM) file; the plain XML row has NULL format_type. A version whose text is not yet published has one row with NULL url, and some versions (e.g. Enrolled Bill) have NULL version_date. The source occasionally lists an identical version twice.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
version_type	string	yes	Stage of the bill this text belongs to, e.g. "Introduced in House"
version_date	string	yes	UTC timestamp of the version; NULL when the source gives none
format_type	string	yes	"United States Legislative Markup" for the USLM file; NULL for the plain XML
url	string	yes	govinfo.gov URL of the text; NULL when no format is published yet

bill_related_bills · table

Bills the Congressional Research Service, the House or GPO link to a bill, one row per (bill, related bill, relationship), from the same GovInfo Bill Status XML. relationship_type is one of Related bill, Identical bill, Companion bill, Cross-Congress related bill, Contained in public law, Public law contains the text, Procedurally related (also spelled Procedurally-related in older files), Related document, Text similarities, PrimaryCompanionBillBecameLaw, SecondaryCompanionBillBecameLaw; identified_by says who made the link (CRS, House, Senate, U.S. Government Publishing Office). related_bill_type uses the same lowercase slugs as bill_type (hr, s, hres, ...), so (related_congress, related_bill_type, related_bill_number) joins straight back to bills. The related_latest_action_* columns are the related bill's latest action as of this bill's last update and can lag bills for that bill. The source occasionally repeats an identical relationship, so the rows have no unique key.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
related_congress	integer	yes	Congress of the related bill (differs for a Cross-Congress relationship)
related_bill_type	string	yes	Bill type slug of the related bill (hr, s, hres, ...); joins to bills.bill_type
related_bill_number	integer	yes	Bill number of the related bill
related_title	string	yes	Title of the related bill
related_latest_action_date	string	yes	Related bill latest action date (YYYY-MM-DD)
related_latest_action_time	string	yes	Related bill latest action time when recorded; usually NULL
related_latest_action_text	string	yes	Related bill latest action text
relationship_type	string	yes	How the bills are related, e.g. "Identical bill", "Related bill"
identified_by	string	yes	Who identified the relationship: CRS, House, Senate, or U.S. Government Publishing Office

bill_amendments · table

Amendments offered to a bill, one row per amendment, from the same GovInfo Bill Status XML. amendment_type is SAMDT (Senate) or HAMDT (House); amendment_number is unique within (congress, amendment_type). Sponsor columns hold a member's bioguide ID and name; when a committee sponsored the amendment (e.g. the Rules Committee) only sponsor_name is set. amended_amendment_* is set when the amendment amends another amendment. purpose and description are usually NULL. action_count and cosponsor_count count the amendment's own actions and cosponsors, which are the rows of bill_amendment_actions and bill_amendment_cosponsors; roll-call votes on amendment actions are in bill_recorded_votes.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
amendment_type	string	no	SAMDT (Senate amendment) or HAMDT (House amendment)
amendment_number	integer	no	Amendment number within the Congress and amendment type
chamber	string	yes	Senate or House of Representatives
sponsor_bioguide_id	string	yes	Bioguide ID of the first listed sponsor; NULL for a committee sponsor
sponsor_full_name	string	yes	Sponsor display name with party and state
sponsor_name	string	yes	Sponsor name when a committee sponsored (e.g. "Rules Committee"); NULL for members
sponsor_party	string	yes	Sponsor party code
sponsor_state	string	yes	Sponsor two-letter state code
sponsor_district	string	yes	Sponsor House district; NULL for senators and committees
description	string	yes	Amendment description text; usually NULL
purpose	string	yes	Statement of purpose, e.g. "To apply the prohibition ..."; usually NULL
submitted_date	string	yes	UTC timestamp the amendment was submitted
proposed_date	string	yes	UTC timestamp the amendment was proposed; usually NULL
latest_action_date	string	yes	Date of the amendment's latest action; NULL when none recorded
latest_action_text	string	yes	Text of the amendment's latest action; NULL when none recorded
update_date	string	yes	Last update timestamp on Congress.gov
amended_amendment_type	string	yes	Type of the amendment this one amends; NULL unless it amends an amendment
amended_amendment_number	integer	yes	Number of the amendment this one amends; NULL unless it amends an amendment
action_count	integer	no	Number of actions recorded on this amendment
cosponsor_count	integer	no	Number of cosponsors listed on this amendment
on_behalf_of_bioguide_id	string	yes	Bioguide ID of the member the amendment was offered on behalf of; NULL if not on behalf of anyone
on_behalf_of_full_name	string	yes	Name of the member the amendment was offered on behalf of
on_behalf_of_type	string	yes	Relationship: "Submitted on behalf of" or "Proposed on behalf of"
latest_action_time	string	yes	Time of the latest action when recorded; usually NULL
amendments_to_amendment_count	integer	yes	Number of amendments offered to this amendment; NULL when none are listed

bill_amendment_actions · table

Every recorded action on every amendment in bill_amendments, one row per action, from the same GovInfo Bill Status XML (introduction, submission, agreed to, not agreed to, withdrawn, ...). Join to bill_amendments on (congress, bill_type, bill_number, amendment_type, amendment_number). There is no sequence number: the source does not list amendment actions in date order. Roll-call votes on amendment actions are in bill_recorded_votes. action_type values seen: Floor, Committee, IntroReferral, ResolvingDifferences, NotUsed.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
amendment_type	string	no	SAMDT or HAMDT; with amendment_number identifies the amendment
amendment_number	integer	no	Amendment number within the Congress and amendment type
action_date	string	yes	Date of the action (YYYY-MM-DD)
action_time	string	yes	Time of day when the source records one (HH:MM:SS), otherwise NULL
text	string	yes	Action text as recorded; NULL for some actions
action_type	string	yes	Source coarse action category (Floor, Committee, IntroReferral, ...)
action_code	string	yes	Source action code
source_system	string	yes	Where the action was recorded — House floor actions, Senate, or Library of Congress

bill_amendment_cosponsors · table

Cosponsors of the amendments in bill_amendments, one row per (amendment, cosponsor), from the same GovInfo Bill Status XML. Only Senate amendments (SAMDT) carry cosponsors in the source; House amendments (HAMDT) have none. Join to bill_amendments on (congress, bill_type, bill_number, amendment_type, amendment_number) and to officials.members on bioguide_id. withdrawn_date is set when a cosponsor later withdrew.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
amendment_type	string	no	SAMDT (only Senate amendments have cosponsors)
amendment_number	integer	no	Amendment number within the Congress and amendment type
bioguide_id	string	no	Bioguide ID of the cosponsor; joins to officials.members
full_name	string	yes	Cosponsor display name with party and state
party	string	yes	Party code
state	string	yes	Two-letter state code
sponsorship_date	string	yes	Date the member became a cosponsor (YYYY-MM-DD)
is_original_cosponsor	boolean	yes	True if the member cosponsored when the amendment was offered
withdrawn_date	string	yes	Date the member withdrew as cosponsor; NULL if still a cosponsor

bill_action_committees · table

The committee named on a bill action, one row per (action, committee), from the same GovInfo Bill Status XML — e.g. the action "Read twice and referred to the Committee on Finance." names ssfi00. Join to bill_actions on (congress, bill_type, bill_number, action_seq) and to bill_committees on committee_system_code. Only actions that involve a committee have a row here.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
action_seq	integer	no	Position of the action in bill_actions, 1 = oldest
committee_system_code	string	no	Congress.gov committee code, e.g. ssfi00
committee_id	string	no	committee_system_code in the form officials.committees uses: upper case, with the 00 that marks a full committee removed (hsju00 becomes HSJU, hsif14 becomes HSIF14). Joins to officials.committees.committee_id
committee_name	string	yes	Committee name, e.g. "Finance Committee"

bill_recorded_votes · table

Roll-call votes recorded against a bill or one of its amendments, one row per vote, from the same GovInfo Bill Status XML. url is the House Clerk or Senate roll-call XML that holds the member-by-member result. A vote on an amendment has amendment_type and amendment_number set; a vote on the bill itself has them NULL. action_date and action_text are those of the bill or amendment action that recorded the vote (for example "Passed/agreed to in House: On passage Passed by the Yeas and Nays: 220 - 213"). full_action_name (e.g. "Passage of a Measure") appears only on votes listed directly on the bill in a few older files, which then have NULL action fields. One roll call can be cited by several actions on the same bill, so there is one row per citation and no unique key.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
amendment_type	string	yes	SAMDT or HAMDT when the vote was on an amendment; NULL for a vote on the bill
amendment_number	integer	yes	Amendment number when the vote was on an amendment; NULL otherwise
action_date	string	yes	Date of the action that recorded the vote (YYYY-MM-DD); NULL for legacy bill-level votes
action_text	string	yes	Text of the action that recorded the vote; NULL for legacy bill-level votes
vote_chamber	string	yes	House or Senate
vote_congress	integer	yes	Congress the vote was taken in
session_number	integer	yes	Session of that Congress (1 or 2)
roll_number	integer	yes	Roll-call number within the chamber and session
vote_date	string	yes	UTC timestamp of the vote
url	string	yes	House Clerk or Senate roll-call XML with the individual votes
full_action_name	string	yes	Name of the vote (e.g. "Passage of a Measure"); only on legacy bill-level votes

bill_titles · table

Every title recorded for a bill, one row per title, from the same GovInfo Bill Status XML — the Display Title, the Official Title as Introduced, short titles as introduced, reported or passed, and the official title as amended or enacted. A bill typically has about three. title_type is the source category and title_type_code its numeric code. bill_text_version_code / bill_text_version_name say which text version the title belongs to, and chamber_code / chamber_name (H, S, J) which chamber it applies to; both are NULL on most rows. bills.title is the current official title.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
title_type	string	yes	Title category, e.g. "Display Title", "Official Title as Introduced"
title_type_code	string	yes	Numeric code of the title category; NULL in older files
title	string	yes	The title text
bill_text_version_code	string	yes	Code of the text version the title belongs to; usually NULL
bill_text_version_name	string	yes	Name of the text version the title belongs to; usually NULL
chamber_code	string	yes	H, S or J when the title applies to one chamber; usually NULL
chamber_name	string	yes	House, Senate or Joint when the title applies to one chamber; usually NULL
parent_title_type	string	yes	Parent category for a nested short title (e.g. "Short Titles House of Representatives"); rare
source_system	string	yes	Recording system when given (Library of Congress); usually NULL
update_date	string	yes	When the title was last updated (UTC timestamp); NULL in older files

bill_summaries · table

CRS summaries of a bill, one row per summary version, from the same GovInfo Bill Status XML. summary_text is CRS-written HTML. version_code numbers the stage the summary covers (00 = as introduced; later codes mark later stages such as passed one chamber or enacted) and action_description names it (e.g. "Introduced in Senate", "Passed House without amendment"). CRS writes summaries after introduction and not for every bill, so many bills have none. summary_name and last_summary_update_date exist only in a few older files.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
version_code	string	yes	Stage code of the summary; 00 = as introduced
action_date	string	yes	Date of the action the summary covers (YYYY-MM-DD)
action_description	string	yes	Stage the summary covers, e.g. "Introduced in Senate"
summary_name	string	yes	Summary name; only in a few older files
update_date	string	yes	When the summary was last updated (UTC timestamp)
last_summary_update_date	string	yes	Last summary update; only in a few older files
summary_text	string	yes	CRS summary text, as HTML

bill_cbo_cost_estimates · table

Congressional Budget Office cost estimates linked to a bill, one row per estimate, from the same GovInfo Bill Status XML. title names the estimate and the stage it covers (e.g. "H.R. 3111, Faster FOIA Act of 2010"), url is the CBO publication page, and description says what version of the bill it covers ("Cost estimate for the bill as reported by ..."); older rows can hold HTML markup there. The same estimate can appear twice, once with mis-encoded characters in the title, exactly as published.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
pub_date	string	yes	When CBO published the estimate (UTC timestamp)
title	string	yes	Estimate title
url	string	yes	CBO publication page
description	string	yes	What version of the bill the estimate covers; can contain HTML in older rows

bill_committee_reports · table

House and Senate committee reports filed on a bill, one row per report, from the same GovInfo Bill Status XML. citation is exactly as published (e.g. "H. Rept. 108-753", sometimes with a book suffix such as "H. Rept. 119-106,Book 1"). A report is occasionally cited twice on the same bill, as published.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
citation	string	no	Report citation as published, e.g. "H. Rept. 108-753"

bill_notes · table

Congress.gov editorial notes attached to a bill, from the same GovInfo Bill Status XML — for example "For further action, see H.R.366, which became Public Law 112-1". One row per (note, link); a note with no links has one row with NULL link_name and link_url. note_text can contain HTML anchors.

Column	Type	Null	Description
congress	INTEGER	yes
bill_type	VARCHAR	yes
bill_number	integer	no	Bill number within its Congress and bill type
note_text	string	yes	Note text; can contain HTML
link_name	string	yes	Link label, e.g. "H.R.366"; NULL when the note has no link
link_url	string	yes	Link target; NULL when the note has no link

scotus_reports_cases · table

Every case decided by the U.S. Supreme Court and printed in the bound United States Reports on GovInfo: volumes 2 through 583, Court terms 1781 through 2017, about 30,800 cases. One row per case, partitioned by year, the term in which the volume's cases were decided (the first year of GovInfo's courtTerm; the earliest reporters span several years and count under their first). Terms from 2018 are in scotus_slip_opinions; scotus_cases combines the two. Outcome columns (disposition, party_winning, votes_majority, votes_minority, chief_justice, opinion_writer, case_origin, cert_reason, scdb_issue_areas and the rest of GovInfo's curated fields) come from GovInfo's MODS record, which takes them from the Supreme Court Database, and are present for volumes through 582 only; volume 583 (term 2017) has none, so disposition is derived from the opinion text and disposition_source says which. disposition uses one vocabulary either way: Affirmed (includes modified), Reversed, Reversed and remanded, Vacated and remanded, Affirmed and reversed (or vacated) in part [and remanded], Dismissed as improvidently granted. Text-derived values agree with the curated ones for about 96% of cases; the exceptions are how a remand is coded. docket_numbers are the Court's docket numbers read from the opinion (a consolidated case lists every docket whose number the text gives), not the SCDB-format govinfo_docket_id. opinion_text is the full text of the opinion PDF as extracted, in which the "fi" ligature loses its "i" (e.g. "affrmed", "fnal"). Original-jurisdiction cases have no disposition.

Column	Type	Null	Description
volume	integer	no	United States Reports volume number (e.g. 583 in 583 U.S. 17)
granule_id	string	no	GovInfo granule ID of the case, e.g. USREPORTS-583-17; joins to the case's govinfo.gov page and API records
case_title	string	no	Case name with citation and year as GovInfo prints it, e.g. Hamer v. Neighborhood Housing Services of Chicago, 583 U.S. 17 (2017)
us_citation	string	no	Official citation, e.g. 583 U.S. 17
full_citation	string	yes	Citation with the decision year, e.g. 583 U.S. 17 (2017)
first_page	integer	no	Page of the volume on which the case begins
sequence_number	integer	yes	GovInfo's order of the case within the volume
court_term	string	yes	GovInfo's courtTerm for the case as MODS gives it (the year the term began); null where the MODS record carries none, which is volume 583
decision_year	integer	no	Year of decision as GovInfo dates it; for volume 583 this is the year only, since GovInfo gives no day or month there
decision_date	string	yes	Date of decision (YYYY-MM-DD); null when GovInfo gives only the year
argument_date	string	yes	Date the case was argued (YYYY-MM-DD); null for cases decided without argument and where the MODS record carries none
docket_numbers	array	yes	The Court's docket numbers, lead docket first, normalised with a hyphen (23-583; 24A910 for an application; 137-Orig for an original case). A consolidated case lists every docket the opinion's footnote numbers; empty where the opinion text carries none
govinfo_docket_id	string	yes	Supreme Court Database docket ID as GovInfo carries it (e.g. 2000-031-01); an SCDB identifier, not the Court's docket number, and absent for volume 583
disposition	string	yes	What the Court did with the judgment below, in one vocabulary — Affirmed (includes modified), Reversed, Reversed and remanded, Vacated, Vacated and remanded, Affirmed and reversed (or vacated) in part [and remanded], Petition denied or appeal dismissed, Dismissed as improvidently granted; null when none was recorded or derivable, as for original-jurisdiction cases
disposition_source	string	yes	govinfo_mods when disposition is GovInfo's curated Supreme Court Database value; opinion_text when it was derived from the opinion. Null when disposition is null
party_winning	string	yes	Whether the petitioning party received a favorable disposition (Petitioning party received a favorable disposition, or No favorable disposition for petitioning party apparent); curated, so null for volume 583 and any case without an outcome
decision_type	string	yes	Kind of decision, e.g. Opinion of the court (orally argued), Per curiam (no oral argument), Equally divided vote
jurisdiction	string	yes	How the case reached the Court, e.g. Cert, Appeal, Original
case_origin	string	yes	Court in which the case originated, e.g. Michigan Eastern U.S. District Court
case_source	string	yes	Court whose decision was reviewed, e.g. U.S. Court of Appeals, Sixth Circuit
cert_reason	string	yes	Reason the Court took the case, e.g. Federal court conflict
chief_justice	string	yes	Chief Justice at the time, as a full name (e.g. William H. Rehnquist)
opinion_writer	string	yes	Justice who wrote the majority opinion, as a full name; null for some per curiam and unsigned decisions
opinion_assigner	string	yes	Justice who assigned the majority opinion
votes_majority	integer	yes	Number of justices in the majority
votes_minority	integer	yes	Number of justices in the minority
authority_decision	string	yes	Basis of the decision, e.g. Statutory construction, Constitutional interpretation
unconstitutionality	string	yes	Whether the Court declared a law unconstitutional, e.g. No declaration of unconstitutionality
petitioner_type	string	yes	Category of the petitioner, e.g. Manufacturer, State, Federal government
respondent_type	string	yes	Category of the respondent
lc_topics	array	yes	Subject topics assigned by the Library of Congress Law Library; present on fewer than half of cases
scdb_issue_areas	array	yes	Issue areas from the Supreme Court Database (e.g. Patents and Copyrights: Copyright)
law_types	array	yes	Type of law at issue, from the Supreme Court Database
legal_provisions	array	yes	Legal provisions at issue, from the Supreme Court Database
page_count	integer	no	Pages in the case's PDF
pdf_url	string	no	GovInfo URL of the case PDF the opinion text was read from
opinion_text	string	yes	Full text of the case as extracted from the PDF — syllabus, opinion of the Court, concurrences and dissents. The "fi" ligature loses its "i" in the source encoding ("affrmed", "fnal"). Text blob

lobbying_filings · table

Every lobbying filing made under the Lobbying Disclosure Act, one row per filing: LD-1 registrations (a lobbyist or firm registering to lobby for a client) and LD-2 quarterly activity reports, with their amendments and terminations. filing_type says which (decoded in lobbying_filing_types: RR = Registration, Q1 = 1st Quarter Report, and so on). The registrant is the lobbying firm or organization; the client is who it lobbies for (often the same when an organization lobbies for itself). income is what a lobbying firm reports receiving from the client and expenses is what an organization reports spending on in-house lobbying; each is set on only some filings, as reported (rounded by the filer). filing_year/filing_period is the reporting period the filing covers. What was lobbied on is in lobbying_activities and the people involved in lobbying_activity_lobbyists. Registrant contact names and telephone numbers and the name of whoever posted a filing are deliberately not carried. Partitioned by year and quarter: the calendar quarter in which the filing was POSTED (Eastern time), not the period it reports on. A filing keeps its posting date, so a past partition never changes, and an amendment is a new filing in a later partition. The current quarter is re-read on each daily run. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
year	INTEGER	yes
quarter	VARCHAR	yes
filing_uuid	string	no	LDA.gov's unique ID for the filing; joins every lobbying_* filing table
filing_type	string	yes	Filing type code, e.g. RR (registration), Q1-Q4 (quarterly reports), and amendment/termination variants; decoded in lobbying_filing_types
filing_type_name	string	yes	Filing type in words, e.g. Registration, 1st Quarter Report
filing_year	integer	yes	Calendar year of the period the filing covers
filing_period	string	yes	Period the filing covers: first_quarter, second_quarter, third_quarter or fourth_quarter (mid_year and year_end appear on contribution reports only)
filing_document_url	string	yes	LDA.gov page of the filing itself
income	double	yes	Income the registrant reports from the client for the period; set on some LD-2 filings
expenses	double	yes	Expenses an organization reports for its own in-house lobbying; set on some LD-2 filings
expenses_method	string	yes	Expense-reporting method code: a, b or c
expenses_method_name	string	yes	Expense-reporting method in words, e.g. Method A - Reporting amounts using LDA definitions only
dt_posted	string	yes	When the filing was posted (ISO-8601 with Eastern-time offset); decides the year/quarter partition
termination_date	string	yes	Date the registration terminated (YYYY-MM-DD); set on termination filings
registrant_id	long	yes	Registrant ID; joins to lobbying_registrants
registrant_name	string	yes	Registrant (lobbying firm or self-filing organization) name
registrant_house_id	integer	yes	The registrant's ID in the House Lobbying Disclosure system, when it has one
registrant_description	string	yes	Registrant's own description of its business
registrant_address_1	string	yes	Registrant street address on this filing (a business address)
registrant_address_2	string	yes	Registrant address line 2
registrant_city	string	yes	Registrant city on this filing
registrant_state	string	yes	Registrant state on this filing
registrant_zip	string	yes	Registrant ZIP on this filing
registrant_country	string	yes	Registrant country on this filing, as published
registrant_ppb_country	string	yes	Registrant principal-place-of-business country when it differs from the address
registrant_different_address	boolean	yes	True when the registrant's principal place of business differs from its address
client_id	long	yes	Client ID; joins to lobbying_clients
client_name	string	yes	Client name
client_general_description	string	yes	Client's line of business, e.g. Health benefit plan company
client_state	string	yes	Client state code
client_country	string	yes	Client country code
client_ppb_state	string	yes	Client principal-place-of-business state code
client_ppb_country	string	yes	Client principal-place-of-business country code
client_government_entity	boolean	yes	True when the client is itself a government entity
client_self_select	boolean	yes	True when the client is the registrant (an organization lobbying for itself)
client_effective_date	string	yes	Date the client relationship took effect (YYYY-MM-DD)
activity_count	integer	yes	Number of lobbying activities on the filing (rows in lobbying_activities)
foreign_entity_count	integer	yes	Number of foreign entities disclosed (rows in lobbying_foreign_entities)
affiliated_organization_count	integer	yes	Number of affiliated organizations disclosed (rows in lobbying_affiliated_organizations)
conviction_disclosure_count	integer	yes	Number of lobbyist convictions disclosed (rows in lobbying_conviction_disclosures)

lobbying_activities · table

What each filing says was lobbied on, one row per lobbying activity within a filing (usually one to a handful, one per general issue area). general_issue_code is one of the 79 issue areas in lobbying_issue_codes (e.g. DEF = Defense, HCR = Health Issues). description is the filer's free-text statement of the specific issues, and is where particular bills, regulations and programs are named (for example "H.R. 1" or "FY26 defense appropriations") — there is no structured bill identifier, so matching to the bill_* tables means reading that text. activity_seq numbers the activities within the filing from 1 in the order the API lists them. Join to lobbying_filings on filing_uuid. Partitioned by year and quarter: the calendar quarter in which the filing was POSTED (Eastern time), not the period it reports on. A filing keeps its posting date, so a past partition never changes, and an amendment is a new filing in a later partition. The current quarter is re-read on each daily run. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
year	INTEGER	yes
quarter	VARCHAR	yes
filing_uuid	string	no	LDA.gov's unique ID for the filing; joins every lobbying_* filing table
activity_seq	integer	no	Position of the activity within its filing, from 1
general_issue_code	string	yes	General issue area code; decoded in lobbying_issue_codes
general_issue_name	string	yes	General issue area in words, e.g. Defense, Budget/Appropriations
description	string	yes	Filer's free-text statement of the specific lobbying issues; names bills and programs
foreign_entity_issues	string	yes	Issues lobbied on that concern a foreign entity, when stated
lobbyist_count	integer	yes	Number of lobbyists listed on the activity
government_entity_count	integer	yes	Number of government entities contacted on the activity

lobbying_activity_lobbyists · table

The individual lobbyists named on each lobbying activity, one row per (activity, lobbyist). covered_position is any covered executive or legislative branch position the lobbyist held in the previous 20 years, as the filer wrote it (e.g. "Principal", "National President"); is_new is true when the lobbyist was added on this filing. lobbyist_id joins to the lobbyists registry. Join to lobbying_activities on (filing_uuid, activity_seq). Partitioned by year and quarter: the calendar quarter in which the filing was POSTED (Eastern time), not the period it reports on. A filing keeps its posting date, so a past partition never changes, and an amendment is a new filing in a later partition. The current quarter is re-read on each daily run. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
year	INTEGER	yes
quarter	VARCHAR	yes
filing_uuid	string	no	LDA.gov's unique ID for the filing; joins every lobbying_* filing table
activity_seq	integer	no	Position of the activity within its filing, from 1
lobbyist_id	long	yes	Lobbyist ID; the same person keeps one ID across filings
lobbyist_prefix	string	yes	Name prefix as published, e.g. MR., MS., HON.
lobbyist_first_name	string	yes	First name
lobbyist_nickname	string	yes	Nickname when given
lobbyist_middle_name	string	yes	Middle name or initial
lobbyist_last_name	string	yes	Last name
lobbyist_suffix	string	yes	Name suffix as published, e.g. JR., III
covered_position	string	yes	Covered government position held in the past, as the filer wrote it; NULL when none
is_new	boolean	yes	True when the lobbyist is new to this filing

lobbying_activity_government_entities · table

The federal bodies each lobbying activity contacted, one row per (activity, government entity): House of Representatives, Senate, and executive agencies such as "Army, Dept of (Other)". government_entity_id decodes in lobbying_government_entity_codes. Join to lobbying_activities on (filing_uuid, activity_seq). Partitioned by year and quarter: the calendar quarter in which the filing was POSTED (Eastern time), not the period it reports on. A filing keeps its posting date, so a past partition never changes, and an amendment is a new filing in a later partition. The current quarter is re-read on each daily run. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
year	INTEGER	yes
quarter	VARCHAR	yes
filing_uuid	string	no	LDA.gov's unique ID for the filing; joins every lobbying_* filing table
activity_seq	integer	no	Position of the activity within its filing, from 1
government_entity_id	integer	yes	Government entity ID; decoded in lobbying_government_entity_codes
government_entity_name	string	yes	Government entity name, e.g. HOUSE OF REPRESENTATIVES

lobbying_activity_bills · table

The federal bills each lobbying activity names, one row per (activity, Congress, bill type, bill number), derived from the free-text description in lobbying_activities by fixed rules, so a join to the bill_* tables does not need each user to parse text. bill_type uses the bills table's values (hr, s, hjres, sjres, hconres, sconres, hres, sres) and bill_number is unique only within (congress, bill_type): join to bills on all three. Recognised forms: "H.R. 1", "HR 1", "HR1", "S. 123", "S123", "H.J.Res. 5", "S.J.Res. 5", "H.Con.Res. 5", "S.Con.Res. 5", "H.Res. 5", "S.Res. 5", with an optional "No.". congress comes from an explicit tag next to the reference ("H.R. 1 (118th)", "H.R. 1, 118th Congress", "118th Congress: H.R. 1") and match_basis is explicit_congress_tag; with no tag it is the Congress in session on the filing's posting date and match_basis is inferred_from_posted_date — drop those rows for a strict analysis, since an untagged number may name an older Congress's bill with the same number. A tag naming a Congress later than the one in session at posting cannot be right: that row has a null congress and match_basis unresolved_tag, and is kept rather than guessed. Not captured: numbers that only follow a list ("H.R. 1, 2 and 3" yields H.R. 1) and spelled-out names ("House Bill 1"). The same bill and Congress is one row per activity, with an explicit tag winning over an inferred one. This table does not judge whether a reference is the sponsor's bill or an older bill of the same number beyond what the tag and posting date allow. Precision, hand-checked against the description text in a 2026 Q1-Q3 sample (12 explicit, 40 inferred rows): every row was a real bill reference; the 2 explicit rows with a wrong or missed tag were fixed by the rules above, and 1 of the 40 inferred rows named an older Congress's bill (the Congress is only as good as the posting-date inference, so treat inferred rows as probable, not certain). reference_text is the matched text. Join to lobbying_activities on (filing_uuid, activity_seq). Partitioned by year and quarter like lobbying_activities: the calendar quarter in which the filing was POSTED (Eastern time). A past partition never changes; the current quarter is re-read on each daily run. Source: LDA.gov (Senate Office of Public Records); the extraction is this project's. The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
year	INTEGER	yes
quarter	VARCHAR	yes
filing_uuid	string	no	LDA.gov's unique ID for the filing; joins every lobbying_* filing table
activity_seq	integer	no	Position of the activity within its filing, from 1
congress	integer	yes	Congress the bill belongs to (e.g. 118); null only when match_basis is unresolved_tag
bill_type	string	no	Bill type as in the bills table: hr, s, hjres, sjres, hconres, sconres, hres, sres
bill_number	integer	no	Bill number, unique only within (congress, bill_type)
match_basis	string	no	explicit_congress_tag (a tag next to the reference), inferred_from_posted_date (no tag; Congress in session when the filing was posted) or unresolved_tag (tag later than the posting Congress; congress is null)
reference_text	string	no	The text matched in the description, e.g. "H.R. 1"

lobbying_foreign_entities · table

Foreign entities disclosed on a filing because they own or control the client or contribute to the lobbying, one row per (filing, entity). ownership_percentage is the share the entity holds in the client and contribution the amount it contributed toward the lobbying. Join to lobbying_filings on filing_uuid. Partitioned by year and quarter: the calendar quarter in which the filing was POSTED (Eastern time), not the period it reports on. A filing keeps its posting date, so a past partition never changes, and an amendment is a new filing in a later partition. The current quarter is re-read on each daily run. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
year	INTEGER	yes
quarter	VARCHAR	yes
filing_uuid	string	no	LDA.gov's unique ID for the filing; joins every lobbying_* filing table
entity_seq	integer	no	Position of the entity within its filing, from 1
name	string	yes	Foreign entity name, e.g. AIRBUS SE
contribution	double	yes	Amount the entity contributed to the lobbying
ownership_percentage	double	yes	Percent of the client the entity owns
address	string	yes	Entity address as one line
city	string	yes	Entity city
state	string	yes	Entity state or province
country	string	yes	Entity country code, e.g. NL
country_name	string	yes	Entity country name, e.g. Netherlands
ppb_city	string	yes	Principal-place-of-business city
ppb_state	string	yes	Principal-place-of-business state or province
ppb_country	string	yes	Principal-place-of-business country code

lobbying_affiliated_organizations · table

Organizations affiliated with the client that take part in planning, supervising or controlling its lobbying, one row per (filing, organization). Join to lobbying_filings on filing_uuid. Partitioned by year and quarter: the calendar quarter in which the filing was POSTED (Eastern time), not the period it reports on. A filing keeps its posting date, so a past partition never changes, and an amendment is a new filing in a later partition. The current quarter is re-read on each daily run. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
year	INTEGER	yes
quarter	VARCHAR	yes
filing_uuid	string	no	LDA.gov's unique ID for the filing; joins every lobbying_* filing table
organization_seq	integer	no	Position of the organization within its filing, from 1
name	string	yes	Affiliated organization name
url	string	yes	Organization web address when given
address_1	string	yes	Organization street address
address_2	string	yes	Organization address line 2
city	string	yes	Organization city
state	string	yes	Organization state
zip	string	yes	Organization ZIP
country	string	yes	Organization country code
ppb_city	string	yes	Principal-place-of-business city
ppb_state	string	yes	Principal-place-of-business state
ppb_country	string	yes	Principal-place-of-business country code

lobbying_conviction_disclosures · table

Convictions of lobbyists disclosed on a filing, one row per (filing, disclosure): the lobbyist, the date and a free-text description. Rare (roughly one filing in a thousand). Join to lobbying_filings on filing_uuid. Partitioned by year and quarter: the calendar quarter in which the filing was POSTED (Eastern time), not the period it reports on. A filing keeps its posting date, so a past partition never changes, and an amendment is a new filing in a later partition. The current quarter is re-read on each daily run. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
year	INTEGER	yes
quarter	VARCHAR	yes
filing_uuid	string	no	LDA.gov's unique ID for the filing; joins every lobbying_* filing table
disclosure_seq	integer	no	Position of the disclosure within its filing, from 1
lobbyist_id	long	yes	Lobbyist ID; the same person keeps one ID across filings
lobbyist_prefix	string	yes	Name prefix as published, e.g. MR., MS., HON.
lobbyist_first_name	string	yes	First name
lobbyist_nickname	string	yes	Nickname when given
lobbyist_middle_name	string	yes	Middle name or initial
lobbyist_last_name	string	yes	Last name
lobbyist_suffix	string	yes	Name suffix as published, e.g. JR., III
conviction_date	string	yes	Date of the conviction (YYYY-MM-DD)
description	string	yes	Free-text description of the conviction as disclosed

lobbying_contribution_reports · table

Semiannual reports of political contributions filed by registrants and by individual lobbyists (form LD-203), one row per report: the Mid-Year Report (period Jan 1 - Jun 30, filing_period mid_year) and the Year-End Report (Jul 1 - Dec 31, year_end). filer_type is lobbyist when an individual files (the lobbyist_* columns are then set) or organization when a registrant files (they are NULL). no_contributions is true when the filer certifies it made none. The individual contributions are in lobbying_contribution_items and any PACs the filer controls in lobbying_contribution_pacs. The report's own address is not carried — for an individual it is a home address — only the filer's state and country. Partitioned by year and quarter: the calendar quarter in which the filing was POSTED (Eastern time), not the period it reports on. A filing keeps its posting date, so a past partition never changes, and an amendment is a new filing in a later partition. The current quarter is re-read on each daily run. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
year	INTEGER	yes
quarter	VARCHAR	yes
filing_uuid	string	no	LDA.gov's unique ID for the filing; joins every lobbying_* filing table
filing_type	string	yes	Report type code, e.g. MM (mid-year), YY (year-end), and amendment variants; decoded in lobbying_filing_types
filing_type_name	string	yes	Report type in words, e.g. Mid-Year Report
filing_year	integer	yes	Calendar year of the period the report covers
filing_period	string	yes	mid_year or year_end
filing_document_url	string	yes	LDA.gov page of the report itself
filer_type	string	yes	lobbyist (an individual) or organization (a registrant)
dt_posted	string	yes	When the report was posted (ISO-8601 with Eastern-time offset); decides the year/quarter partition
comments	string	yes	Filer's free-text comments on the report
filer_state	string	yes	State of the filer's address
filer_country	string	yes	Country of the filer's address
registrant_id	long	yes	Registrant ID; joins to lobbying_registrants
registrant_name	string	yes	Registrant name
registrant_house_id	integer	yes	The registrant's ID in the House Lobbying Disclosure system, when it has one
registrant_description	string	yes	Registrant's own description of its business
lobbyist_id	long	yes	Filing lobbyist (NULL for an organization filer) ID; the same person keeps one ID across filings
lobbyist_prefix	string	yes	Name prefix as published, e.g. MR., MS., HON.
lobbyist_first_name	string	yes	First name
lobbyist_nickname	string	yes	Nickname when given
lobbyist_middle_name	string	yes	Middle name or initial
lobbyist_last_name	string	yes	Last name
lobbyist_suffix	string	yes	Name suffix as published, e.g. JR., III
no_contributions	boolean	yes	True when the filer reports no contributions
item_count	integer	yes	Number of contribution items (rows in lobbying_contribution_items)
pac_count	integer	yes	Number of PACs listed (rows in lobbying_contribution_pacs)

lobbying_contribution_items · table

The individual contributions listed on LD-203 reports, one row per item: who gave (contributor_name, often SELF for an individual lobbyist), who received it (payee_name, typically a campaign committee or PAC) and in whose honor (honoree_name). contribution_type is feca (contribution to a federal candidate, committee or party), he (honorary expenses) and so on, decoded in lobbying_contribution_item_types. Join to lobbying_contribution_reports on filing_uuid. Partitioned by year and quarter: the calendar quarter in which the filing was POSTED (Eastern time), not the period it reports on. A filing keeps its posting date, so a past partition never changes, and an amendment is a new filing in a later partition. The current quarter is re-read on each daily run. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
year	INTEGER	yes
quarter	VARCHAR	yes
filing_uuid	string	no	LDA.gov's unique ID for the filing; joins every lobbying_* filing table
item_seq	integer	no	Position of the item within its report, from 1
contribution_type	string	yes	Contribution type code, e.g. feca; decoded in lobbying_contribution_item_types
contribution_type_name	string	yes	Contribution type in words, e.g. FECA
contributor_name	string	yes	Who made the contribution; SELF when the filing lobbyist did
payee_name	string	yes	Who received it, e.g. FRENCH HILL FOR ARKANSAS
honoree_name	string	yes	Person honored, e.g. The Honorable French Hill
amount	double	yes	Amount in dollars
contribution_date	string	yes	Date of the contribution (YYYY-MM-DD)

lobbying_contribution_pacs · table

Political action committees that a registrant or lobbyist reports controlling, one row per (report, PAC) — the API gives only the PAC's name. Join to lobbying_contribution_reports on filing_uuid. Partitioned by year and quarter: the calendar quarter in which the filing was POSTED (Eastern time), not the period it reports on. A filing keeps its posting date, so a past partition never changes, and an amendment is a new filing in a later partition. The current quarter is re-read on each daily run. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
year	INTEGER	yes
quarter	VARCHAR	yes
filing_uuid	string	no	LDA.gov's unique ID for the filing; joins every lobbying_* filing table
pac_seq	integer	no	Position of the PAC within its report, from 1
pac_name	string	yes	PAC name, e.g. Kidney Care Council PAC

lobbyists · table

The registry of lobbyists on LDA.gov: every individual who has been listed as a lobbyist on a registration or report (about 88,800 records), one row per lobbyist record with the registrant (lobbying firm or organization) it is filed under. lobbyist_id is the same ID used in lobbying_activity_lobbyists and lobbying_conviction_disclosures. This is the full list as of the last monthly refresh, replaced wholesale each month, not a history. Registrant contact names and telephone numbers are deliberately not carried. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
lobbyist_id	long	no	Lobbyist ID
prefix	string	yes	Name prefix as published
first_name	string	yes	First name
nickname	string	yes	Nickname when given
middle_name	string	yes	Middle name or initial
last_name	string	yes	Last name
suffix	string	yes	Name suffix as published
registrant_id	long	yes	ID of the registrant the lobbyist is filed under; joins to lobbying_registrants
registrant_name	string	yes	Registrant name
registrant_house_id	integer	yes	The registrant's ID in the House Lobbying Disclosure system, when it has one
registrant_city	string	yes	Registrant city
registrant_state	string	yes	Registrant state
registrant_country	string	yes	Registrant country code

lobbying_registrants · table

Every registrant on LDA.gov (about 17,500): the lobbying firms and the organizations that lobby for themselves, one row per registrant, replaced wholesale each month. registrant_id is the ID used across every lobbying_* table. Contact names and telephone numbers are deliberately not carried. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
registrant_id	long	no	Registrant ID
house_registrant_id	integer	yes	The registrant's ID in the House Lobbying Disclosure system, when it has one
name	string	yes	Registrant name
description	string	yes	Registrant's description of its business (older records sometimes hold a date or note)
address_1	string	yes	Street address (a business address)
address_2	string	yes	Address line 2
address_3	string	yes	Address line 3
address_4	string	yes	Address line 4
city	string	yes	City
state	string	yes	State code
zip	string	yes	ZIP
country	string	yes	Country code
ppb_country	string	yes	Principal-place-of-business country code
dt_updated	string	yes	When LDA.gov last updated the record (ISO-8601)

lobbying_clients · table

Every client on LDA.gov (about 136,700 records), one row per client record with the registrant that represents it, replaced wholesale each month. client_id is the ID used in lobbying_filings. self_select is true when the client is the registrant itself, and government_entity when the client is a government body. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
client_id	long	no	Client ID
name	string	yes	Client name
general_description	string	yes	Client's line of business
government_entity	boolean	yes	True when the client is a government entity
self_select	boolean	yes	True when the client is the registrant itself
state	string	yes	Client state code
country	string	yes	Client country code
ppb_state	string	yes	Principal-place-of-business state code
ppb_country	string	yes	Principal-place-of-business country code
effective_date	string	yes	Date the client relationship took effect (YYYY-MM-DD)
registrant_id	long	yes	ID of the representing registrant; joins to lobbying_registrants
registrant_name	string	yes	Representing registrant's name

lobbying_issue_codes · table

The 79 general issue area codes a lobbying activity is filed under (ACC = Accounting, DEF = Defense, HCR = Health Issues, ...). Decodes lobbying_activities.general_issue_code. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
issue_code	string	no	Three-letter issue area code
issue_name	string	yes	Issue area name

lobbying_government_entity_codes · table

The 257 federal bodies a lobbying activity can report contacting: the House, the Senate and executive agencies. Decodes lobbying_activity_government_entities.government_entity_id. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
government_entity_id	integer	no	Government entity ID
government_entity_name	string	yes	Government entity name

lobbying_filing_types · table

The 50 filing type codes (RR = Registration, RA = Registration - Amendment, Q1 = 1st Quarter Report, MM = Mid-Year Report, ...) with their variants for amendments and terminations. Decodes filing_type on lobbying_filings and lobbying_contribution_reports. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
filing_type	string	no	Filing type code
filing_type_name	string	yes	Filing type name

lobbying_contribution_item_types · table

The five contribution type codes on an LD-203 item (feca = FECA, he = Honorary Expenses, ...). Decodes lobbying_contribution_items.contribution_type. Source: LDA.gov (Senate Office of Public Records). The Senate Office of Public Records cannot vouch for the data or analyses derived from these data after they have been retrieved from LDA.gov.

Column	Type	Null	Description
contribution_type	string	no	Contribution type code
contribution_type_name	string	yes	Contribution type name

scotus_slip_opinions · table

Every opinion of the U.S. Supreme Court in the "Opinions of the Court" listing on supremecourt.gov, Court terms 2017 to the current term: the cases the bound volumes in scotus_reports_cases do not cover (term 2017's opinions before March 21, 2018 are in volume 583 there). One row per case, partitioned by year, the term (October of year to the following summer). holding_summary is the Court's own one-line statement of the holding from the listing. docket_numbers are read from the opinion (a consolidated case lists every docket its footnote numbers; listing_docket is the one the listing gives). disposition is derived from the opinion's syllabus, so disposition_source is always opinion_text; it uses the vocabulary of scotus_reports_cases (Affirmed (includes modified), Reversed, Reversed and remanded, Vacated and remanded, Affirmed and reversed (or vacated) in part [and remanded], Dismissed as improvidently granted) and can also be Reversed in part and remanded, Reversed in part, vacated in part, and remanded, Vacated in part and remanded or Reversed in part and remanded in part where the Court affirmed no part, or Application granted / Application denied for an order on an emergency application (a docket such as 24A884). It is null for an original-jurisdiction decree. us_citation is null while the listing shows only a volume and print part (609/2) and has no page yet. opinion_text is the full text as extracted from the PDF, in which the "fi" ligature loses its "i" (e.g. "affrmed", "fnal"). author_initials is PC for a per curiam and otherwise the justice's initials as the listing prints them.

Column	Type	Null	Description
release	string	no	The opinion's release number within the term (e.g. 67), or a label such as D1 for a decree in an original-jurisdiction case
decision_date	string	no	Date of decision (YYYY-MM-DD)
listing_docket	string	no	Docket number as the listing prints it (23-583; 24A884 for an application; 141, Orig. for an original case)
docket_numbers	array	yes	The Court's docket numbers read from the opinion, lead docket first, normalised with a hyphen (23-583; 24A910; 137-Orig). A consolidated case lists every docket the opinion's footnote numbers; empty where the text carries none
case_name	string	no	Case name as the listing prints it, e.g. Goldey v. Fields
holding_summary	string	yes	The Court's own one-line statement of the holding, from the listing; null where the listing gives none
author_initials	string	no	PC for a per curiam, otherwise the initials of the justice who wrote the opinion (e.g. NG, KJ, B) as the listing prints them; D for a decree
volume	integer	yes	United States Reports volume, from the listing's citation; null when the listing gives none
first_page	integer	yes	Page on which the case begins in the United States Reports; null until the page is assigned (the listing then shows only volume and print part, e.g. 609/2)
us_citation	string	yes	Official citation, e.g. 606 U.S. 942; null while no page is assigned
disposition	string	yes	What the Court did with the judgment below, derived from the opinion's syllabus, in the vocabulary of scotus_reports_cases plus Reversed in part and remanded, Reversed in part vacated in part and remanded, Vacated in part and remanded, Reversed in part and remanded in part, Application granted and Application denied; null for an original-jurisdiction decree and where no syllabus disposition line is found
disposition_source	string	yes	opinion_text whenever disposition is set (there is no curated outcome for these terms); null when disposition is null
decision_type	string	yes	Equally divided vote when the Court affirmed by an equally divided vote; null otherwise
pdf_url	string	no	supremecourt.gov URL of the PDF the opinion text was read from; for terms whose opinions share a volume PDF it is the volume's file and pdf_page locates the case
pdf_page	integer	yes	Page of pdf_url on which the case begins when the PDF is a volume holding many cases; null for a per-opinion PDF
page_count	integer	no	Pages of the case in the PDF
opinion_text	string	yes	Full text of the case as extracted from the PDF — syllabus, opinion of the Court, concurrences and dissents. The "fi" ligature loses its "i" in the source encoding ("affrmed", "fnal"). Text blob

scotus_dockets · table

The Supreme Court docket of each case it decided in Court terms 2017 to the current term (the same cases as scotus_slip_opinions): one row per docket, partitioned by year, the term the case was decided in. Header fields are the docket's own — title, when it was docketed, the court below and its case numbers and decision date, any application it is linked with, and the Questions Presented. granted_date, argued_date and judgment_issued_date are the dates of the docket entries "Petition GRANTED", "Argued." and "Judgment Issued." and are null where the docket has none (a summary reversal is not argued; a docket in which the Court's own entry is misspelt has no judgment date). entry_count and document_count count the docket's entries and the filings linked from them; the entries are in scotus_docket_entries. Join to scotus_slip_opinions on docket_number = listing_docket. Not included: dockets of cases decided before term 2017 (the docket pages before 2016 use an older layout that is not read), original-jurisdiction cases (their page address cannot be derived from the listing), and, for a consolidated case, the companion dockets — only the lead docket the listing names is fetched. No petitions the Court declined to hear are here.

Column	Type	Null	Description
docket_number	string	no	The Court's docket number (23-583; an application is 24A910)
title	string	no	Caption as the docket prints it, e.g. Amina Bouarfa, Petitioner v. Alejandro Mayorkas, Secretary of Homeland Security, et al.
docketed	string	no	Date the case was docketed (YYYY-MM-DD)
linked_with	string	yes	Application docket number or numbers linked to this case (e.g. an extension of time, 23A348), comma-separated; null when none
lower_court	string	yes	Court whose decision was reviewed, e.g. United States Court of Appeals for the Eleventh Circuit; null for a case with no court below
lower_court_case_numbers	string	yes	The lower court's case number or numbers as the docket prints them, without the parentheses (22-12429)
lower_court_decision_date	string	yes	Date the lower court decided (YYYY-MM-DD)
lower_court_decision_note	string	yes	Annotation the docket prints after the lower-court decision date, e.g. Rule 12.4 (the petition was filed under Supreme Court Rule 12.4); null when there is none
discretionary_court_decision_date	string	yes	Date a state court of discretionary review decided (YYYY-MM-DD), for a case that came from a state court that could decline review; lower_court_decision_date is the earlier decision below it
rehearing_denied	string	yes	Date rehearing was denied (YYYY-MM-DD), when the docket records one
questions_presented_url	string	yes	URL of the Questions Presented PDF; null when the Court did not take the case up for full review
granted_date	string	yes	Date of the docket entry "Petition GRANTED" (YYYY-MM-DD); null when there is none
argued_date	string	yes	Date of the docket entry "Argued." (YYYY-MM-DD); null for a case decided without argument
judgment_issued_date	string	yes	Date of the docket entry "Judgment Issued." (YYYY-MM-DD); null when none has issued
entry_count	integer	no	Number of entries in the docket's proceedings and orders (rows in scotus_docket_entries)
document_count	integer	no	Number of filings linked from the docket's entries

scotus_docket_entries · table

Every entry in the "Proceedings and Orders" of the dockets in scotus_dockets, one row per entry in the order the docket lists them (sequence from 1), partitioned by year, the term the case was decided in. Extensions of time, briefs including those of amici, the distribution of the petition for conference, the grant, the argument and the judgment all appear here as the Court's own text in entry_text, with the filings linked from the entry in document_labels and document_urls (parallel lists). Join to scotus_dockets on docket_number. Same coverage as scotus_dockets: decided cases from term 2017, lead docket of a consolidated case, no original-jurisdiction cases.

Column	Type	Null	Description
docket_number	string	no	The Court's docket number the entry belongs to; joins to scotus_dockets
sequence	integer	no	Position of the entry in the docket, from 1, in the order the docket lists them
entry_date	string	no	Date of the entry (YYYY-MM-DD)
entry_text	string	no	The entry's text as the Court prints it, e.g. Petition GRANTED. or Brief of respondent ... in opposition filed.
document_labels	array	yes	Labels of the filings linked from the entry (Petition, Main Document, Appendix); parallel to document_urls; null when the entry links none
document_urls	array	yes	URLs of the filings linked from the entry; parallel to document_labels; null when the entry links none

member_stock_transactions · table

House members' (and their spouses' and dependent children's) STOCK Act Periodic Transaction Reports — stock, option and fund trades disclosed within 30-45 days of the transaction, from the Clerk of the House's own bulk financial-disclosure system. Not annual financial disclosures (outside income, asset/liability ranges, gifts) and not the Senate's parallel eFD filings, which are in fd_transactions (PTRs and annual-report transactions) and the other fd_* tables. filing_id groups the one or more transaction rows a single PTR lists; row_seq (from 1) is their order in the filing. owner_code is blank for the member's own holding, SP for a spouse, JT for a joint holding, DC for a dependent child. asset_type_code is the source's own abbreviation (ST, OP, OT, ...; see https://fd.house.gov/reference/asset-type-codes.aspx) with ticker parsed out of it separately when the source prints one; a private holding, fund or real property has no ticker. asset_type_code is null for 2015-2017 filings — that PTR template predates the asset-type-code column entirely (see member_stock_transactions_year_range comment). amount_min/amount_max are the disclosed bracket's bounds in dollars (amount_max null for the open-ended top bracket); the source never discloses an exact amount. Coverage starts in 2015, the earliest year the source's own filing-type coding distinguishes PTRs from other disclosure types; filings before 2015 exist but aren't identifiable as PTRs in the index.

Column	Type	Null	Description
year	INTEGER	yes
chamber	string	no	Always "house" — the Senate's eFD filings are in fd_transactions, with chamber "senate"
filer_last_name	string	no	Filer's last name, as the source index prints it
filer_first_name	string	yes	Filer's first (and middle) name, as the source index prints it
state	string	yes	Two-letter state/territory postal code the filer represents
district	string	yes	House district number as the source prints it (e.g. "04"; "00" for an at-large seat)
filing_id	string	no	The Clerk's own document ID for this PTR; source of pdf_url and the natural key with row_seq
filing_date	string	no	Date the PTR was filed (YYYY-MM-DD), from the source index
row_seq	integer	no	1-based order of this transaction within its filing, as the PDF lists them
owner_code	string	yes	SP (spouse), JT (joint) or DC (dependent child); null for the member's own holding
asset_name	string	no	Asset name as the filing prints it, with the ticker (if any) and asset-type code removed
ticker	string	yes	Ticker symbol parsed out of the asset name; null for a holding with none (a private company, fund or real property)
asset_type_code	string	yes	The source's own asset-type abbreviation (ST, OP, OT, ...); see https://fd.house.gov/reference/asset-type-codes.aspx. Null for 2015-2017 filings, whose PTR template has no such column.
transaction_type	string	no	P (purchase), S (sale), "S (partial)" or E (exchange), as the filing prints it
transaction_date	string	no	Date of the transaction (YYYY-MM-DD)
notification_date	string	no	Date the filer notified the Clerk of the transaction (YYYY-MM-DD)
amount_range	string	no	Disclosed amount as the filing prints it: a bracket ("$1,001 - $15,000"), an open-ended top bracket ("Over $50,000,000"), or, rarely, one exact figure (e.g. an IRA transaction below the disclosure threshold)
amount_min	bigint	yes	Lower bound of amount_range in dollars; equal to amount_max when amount_range is one exact figure rather than a bracket
amount_max	bigint	yes	Upper bound of amount_range in dollars; null for the open-ended top bracket
filing_status	string	yes	New or Amended, when the source's per-transaction status is found; null when not found
pdf_url	string	no	disclosures-clerk.house.gov URL of the PTR PDF this row was read from

fd_filings · table

Every non-paper U.S. Senate financial-disclosure filing in the Senate eFD system (efdsearch.senate.gov), one row per filing: annual reports (Ethics in Government Act Parts 1-10), candidate and new-filer reports, STOCK Act periodic transaction reports (PTRs) and due-date-extension notices, for senators, former senators and candidates, by the year the report was filed. The detail of each filing is in fd_assets, fd_income, fd_transactions, fd_liabilities, fd_gifts, fd_travel, fd_positions, fd_agreements and fd_compensation (join on filing_id). report_kind is annual (annual, candidate and new-filer reports), ptr or extension_notice; report_type is the report's own type name. view_status is parsed when the report page was read, extension_notice when the filing is a notice with no report to read, and unavailable when the Senate no longer serves the page (candidate reports expire a year after the candidacy ends) — such filings are listed here but have no detail rows. Scanned paper filings (eFD's /search/view/paper/ pages, all of 2012-2013 and a few percent of later years) have no machine-readable text and are excluded; each year's count is logged by the ETL. state is the state eFD's per-state listing places the filer in; it is null for candidates and for the few senators that listing omits. Senate filings only: House annual reports are not sourced, and PTRs of the House are in member_stock_transactions. Use of these reports is restricted by 5 U.S.C. § 13107(c): not for credit rating, not for soliciting money, and commercial use only by news and communications media.

Column	Type	Null	Description
year	INTEGER	yes
chamber	string	no	Always "senate" — the Senate eFD system; the House's own disclosures are in member_stock_transactions
filing_id	string	no	The eFD report UUID (the last path segment of filing_url); with the row keys of each table it identifies one row
filer_first_name	string	yes	Filer's first (and middle) name as the eFD listing prints it; "Candidate" filers are listed without a name
filer_last_name	string	no	Filer's last name as the eFD listing prints it, suffixes included (e.g. "McConnell, Jr."); "Candidate" for candidate filers, whom eFD lists anonymously
report_title	string	no	The report title as eFD lists it, e.g. "Annual Report for CY 2024", "Periodic Transaction Report for 12/19/2025", "Candidate Report (Amendment 1)"
filing_date	string	no	Date the report was filed with the Senate (YYYY-MM-DD); the year dimension is this date's year
calendar_year	integer	yes	Calendar year the report covers (the "CY 2024" of an annual report); null for PTRs and extension notices, which cover no calendar year
filing_url	string	no	efdsearch.senate.gov URL of the report page (the Senate's terms-of-use agreement must be accepted to open it)
filer_type	string	no	Senator, Former Senator or Candidate, as eFD lists the filer
state	string	yes	Two-letter state code from eFD's per-state listing; null for candidates and for senators that listing omits
report_kind	string	no	annual (annual, candidate and new-filer reports), ptr or extension_notice
report_type	string	no	Report type name with the date, calendar year and amendment suffix removed, e.g. "Annual Report", "Candidate Report", "Periodic Transaction Report", "Due Date Extension"
is_amendment	boolean	no	True when the title carries an "(Amendment)" suffix
amendment_number	integer	yes	N of "(Amendment N)"; null for originals and for amendments the title does not number
view_status	string	no	parsed, extension_notice or unavailable (the Senate no longer serves the report page)

fd_assets · table

Part 3 (Assets and Unearned Income) of Senate annual, candidate and new-filer financial-disclosure reports: one row per reported asset line, with the value bracket and the income it produced. Assets held inside a trust, fund or similar are listed under their parent as sub-items (item_no "6.1" under "6"; parent_item_no names the parent), so a count of top-level assets is the rows with a null parent_item_no. owner is Self, Spouse, Joint or Child. asset_type and asset_type_detail are eFD's own category and sub-category (e.g. Trust / General Trust, Bank Deposit); asset_detail is the location and description notes eFD prints under the asset name. value_* bounds the asset's value bracket and income_* the income bracket; income_range can carry an exact "Other $N" figure after the bracket, in which case the bounds are the bracket's. Senate only; see fd_filings for coverage.

Column	Type	Null	Description
year	INTEGER	yes
chamber	string	no	Always "senate" — the Senate eFD system; the House's own disclosures are in member_stock_transactions
filing_id	string	no	The eFD report UUID (the last path segment of filing_url); with the row keys of each table it identifies one row
filer_first_name	string	yes	Filer's first (and middle) name as the eFD listing prints it; "Candidate" filers are listed without a name
filer_last_name	string	no	Filer's last name as the eFD listing prints it, suffixes included (e.g. "McConnell, Jr."); "Candidate" for candidate filers, whom eFD lists anonymously
report_title	string	no	The report title as eFD lists it, e.g. "Annual Report for CY 2024", "Periodic Transaction Report for 12/19/2025", "Candidate Report (Amendment 1)"
filing_date	string	no	Date the report was filed with the Senate (YYYY-MM-DD); the year dimension is this date's year
calendar_year	integer	yes	Calendar year the report covers (the "CY 2024" of an annual report); null for PTRs and extension notices, which cover no calendar year
filing_url	string	no	efdsearch.senate.gov URL of the report page (the Senate's terms-of-use agreement must be accepted to open it)
item_no	string	no	The report's own row number within the part; a trust's underlying holdings are "6.1", "6.2", ... under asset 6
row_seq	integer	no	1-based position of the row within its part of the report page; eFD's own item numbers repeat within some filings, so this is the row key
parent_item_no	string	yes	item_no of the parent asset for a sub-item ("6" for "6.1"); null for a top-level asset
asset_name	string	yes	Asset name as printed in bold, with any ticker the filer typed in; null where the filing leaves it blank (two 2014 rows)
asset_detail	string	yes	Location, "Type:" and "Description:" notes eFD prints under the asset name
asset_type	string	no	eFD asset category (Bank Deposit, Trust, Real Estate, Business Entity, ...)
asset_type_detail	string	yes	eFD asset sub-category (General Trust, Commercial, ...); null when none
owner	string	no	Self, Spouse, Joint or Child
value_range	string	yes	Asset value as eFD prints it: a bracket ("$1,001 - $15,000"), an open-ended top bracket ("Over $5,000,000"), an exact figure ("$2,148.46") or a note ("None (or less than $201)"); null when the cell is blank
value_min	bigint	yes	Lower bound of value_range in whole dollars; equal to value_max for an exact figure; null when the range states no figure
value_max	bigint	yes	Upper bound of value_range in whole dollars; null for an open-ended top bracket or a range with no figure
income_type	string	yes	Kind of income the asset produced (Interest, Dividends, Rent/Royalties, ...), as printed; null when blank
income_range	string	yes	Income from the asset as eFD prints it: a bracket ("$1,001 - $15,000"), an open-ended top bracket ("Over $5,000,000"), an exact figure ("$2,148.46") or a note ("None (or less than $201)"); null when the cell is blank
income_min	bigint	yes	Lower bound of income_range in whole dollars; equal to income_max for an exact figure; null when the range states no figure
income_max	bigint	yes	Upper bound of income_range in whole dollars; null for an open-ended top bracket or a range with no figure

fd_income · table

Earned and non-investment income of Senate financial-disclosure filers, from Part 2 (Earned and Non-Investment Income: salary, board compensation, retirement distributions, ...) and Part 1 (Honoraria Payments or Payments to Charity in Lieu of Honoraria), one row per reported payment. source_part is "2" or "1": Part 2 rows have no activity_date and name the payer (payer) and who was paid (recipient is Self or Spouse); Part 1 rows have the activity's date and name the payer and the recipient of the payment. amount_range is the amount as printed: an exact figure, or a threshold such as "> $1,000" for spouse income eFD only requires as a threshold. Investment income is on the asset it came from, in fd_assets.

Column	Type	Null	Description
year	INTEGER	yes
chamber	string	no	Always "senate" — the Senate eFD system; the House's own disclosures are in member_stock_transactions
filing_id	string	no	The eFD report UUID (the last path segment of filing_url); with the row keys of each table it identifies one row
filer_first_name	string	yes	Filer's first (and middle) name as the eFD listing prints it; "Candidate" filers are listed without a name
filer_last_name	string	no	Filer's last name as the eFD listing prints it, suffixes included (e.g. "McConnell, Jr."); "Candidate" for candidate filers, whom eFD lists anonymously
report_title	string	no	The report title as eFD lists it, e.g. "Annual Report for CY 2024", "Periodic Transaction Report for 12/19/2025", "Candidate Report (Amendment 1)"
filing_date	string	no	Date the report was filed with the Senate (YYYY-MM-DD); the year dimension is this date's year
calendar_year	integer	yes	Calendar year the report covers (the "CY 2024" of an annual report); null for PTRs and extension notices, which cover no calendar year
filing_url	string	no	efdsearch.senate.gov URL of the report page (the Senate's terms-of-use agreement must be accepted to open it)
source_part	string	no	2 for Part 2 earned and non-investment income, 1 for Part 1 honoraria
item_no	string	no	The report's own row number within the part; a trust's underlying holdings are "6.1", "6.2", ... under asset 6
row_seq	integer	no	1-based position of the row within its part of the report page; eFD's own item numbers repeat within some filings, so this is the row key
activity_date	string	yes	Part 1 only: the date of the article, speech or appearance, as printed (MM/DD/YYYY); null for Part 2
recipient	string	yes	Who was paid: Self or Spouse (Part 2), or the person or charity that received the payment (Part 1)
income_type	string	no	Part 2 income type (Salary, Board Compensation, Other (...) ...) or the Part 1 activity
payer	string	yes	Who paid, with their city and state as printed
amount_range	string	yes	Amount paid as eFD prints it: a bracket ("$1,001 - $15,000"), an open-ended top bracket ("Over $5,000,000"), an exact figure ("$2,148.46") or a note ("None (or less than $201)"); null when the cell is blank
amount_min	bigint	yes	Lower bound of amount_range in whole dollars; equal to amount_max for an exact figure; null when the range states no figure
amount_max	bigint	yes	Upper bound of amount_range in whole dollars; null for an open-ended top bracket or a range with no figure
comments	string	yes	Filer's comment as printed ("n/a" when the filer wrote none)

fd_transactions · table

Securities and property transactions disclosed by U.S. Senators, former senators and candidates, in the shape of member_stock_transactions: one row per transaction, from the STOCK Act periodic transaction reports (source_part = ptr) and from Part 4b of annual reports (source_part = annual_4b — transactions the annual report lists that were not reported on a PTR). Part 4a of an annual report, which only repeats already-filed PTRs, is not read, so a PTR transaction appears once. owner is Self, Spouse, Joint or Child and owner_code is the same in member_stock_transactions' convention (null for Self, SP, JT, DC). asset_type is eFD's asset category on PTRs (Stock, Corporate Bond, ...) and null for Part 4b rows, which have none. transaction_type is as eFD prints it (Purchase, Sale (Full), Sale (Partial), Exchange). row_seq is the row's 1-based position within its part of the report page (eFD's own # repeats in some 2014-2015 PTRs; it is kept in item_no). amount_* bounds the disclosed bracket; eFD never discloses an exact amount. The filing's dates and filer are in fd_filings.

Column	Type	Null	Description
year	INTEGER	yes
chamber	string	no	Always "senate" — the Senate eFD system; the House's own disclosures are in member_stock_transactions
filing_id	string	no	The eFD report UUID (the last path segment of filing_url); with the row keys of each table it identifies one row
filer_first_name	string	yes	Filer's first (and middle) name as the eFD listing prints it; "Candidate" filers are listed without a name
filer_last_name	string	no	Filer's last name as the eFD listing prints it, suffixes included (e.g. "McConnell, Jr."); "Candidate" for candidate filers, whom eFD lists anonymously
report_title	string	no	The report title as eFD lists it, e.g. "Annual Report for CY 2024", "Periodic Transaction Report for 12/19/2025", "Candidate Report (Amendment 1)"
filing_date	string	no	Date the report was filed with the Senate (YYYY-MM-DD); the year dimension is this date's year
calendar_year	integer	yes	Calendar year the report covers (the "CY 2024" of an annual report); null for PTRs and extension notices, which cover no calendar year
filing_url	string	no	efdsearch.senate.gov URL of the report page (the Senate's terms-of-use agreement must be accepted to open it)
source_part	string	no	ptr for a periodic transaction report, annual_4b for Part 4b of an annual report
item_no	string	no	The report's own row number within the part; a trust's underlying holdings are "6.1", "6.2", ... under asset 6
row_seq	integer	no	1-based position of the row within its part of the report page; eFD's own item numbers repeat within some filings, so this is the row key
owner	string	no	Self, Spouse, Joint or Child
owner_code	string	yes	SP (spouse), JT (joint) or DC (dependent child); null for the filer's own holding
ticker	string	yes	Ticker as printed; "--" when eFD prints none; null when blank
asset_name	string	no	Asset name as printed
asset_type	string	yes	eFD asset category on a PTR (Stock, Corporate Bond, ...); null for annual-report Part 4b rows
transaction_type	string	no	Purchase, Sale (Full), Sale (Partial) or Exchange, as printed
transaction_date	string	no	Date of the transaction (YYYY-MM-DD)
amount_range	string	yes	Transaction amount as eFD prints it: a bracket ("$1,001 - $15,000"), an open-ended top bracket ("Over $5,000,000"), an exact figure ("$2,148.46") or a note ("None (or less than $201)"); null when the cell is blank
amount_min	bigint	yes	Lower bound of amount_range in whole dollars; equal to amount_max for an exact figure; null when the range states no figure
amount_max	bigint	yes	Upper bound of amount_range in whole dollars; null for an open-ended top bracket or a range with no figure
comment	string	yes	Filer's comment as printed (e.g. Dividend Reinvestment)

fd_liabilities · table

Part 7 (Liabilities) of Senate annual, candidate and new-filer financial-disclosure reports: one row per reportable liability of the filer, spouse or dependent child — mortgages, loans and lines of credit, with the creditor and the amount bracket. incurred is the date or month the liability was incurred as printed (e.g. "Mar 2019"), item_type its kind (Mortgage on ..., Loan, ...), points and rate_term the interest points and the rate and term as printed. A report with no liabilities has no rows.

Column	Type	Null	Description
year	INTEGER	yes
chamber	string	no	Always "senate" — the Senate eFD system; the House's own disclosures are in member_stock_transactions
filing_id	string	no	The eFD report UUID (the last path segment of filing_url); with the row keys of each table it identifies one row
filer_first_name	string	yes	Filer's first (and middle) name as the eFD listing prints it; "Candidate" filers are listed without a name
filer_last_name	string	no	Filer's last name as the eFD listing prints it, suffixes included (e.g. "McConnell, Jr."); "Candidate" for candidate filers, whom eFD lists anonymously
report_title	string	no	The report title as eFD lists it, e.g. "Annual Report for CY 2024", "Periodic Transaction Report for 12/19/2025", "Candidate Report (Amendment 1)"
filing_date	string	no	Date the report was filed with the Senate (YYYY-MM-DD); the year dimension is this date's year
calendar_year	integer	yes	Calendar year the report covers (the "CY 2024" of an annual report); null for PTRs and extension notices, which cover no calendar year
filing_url	string	no	efdsearch.senate.gov URL of the report page (the Senate's terms-of-use agreement must be accepted to open it)
item_no	string	no	The report's own row number within the part; a trust's underlying holdings are "6.1", "6.2", ... under asset 6
row_seq	integer	no	1-based position of the row within its part of the report page; eFD's own item numbers repeat within some filings, so this is the row key
incurred	string	yes	When the liability was incurred, as printed
debtor	string	yes	Who owes it: Self, Spouse, Joint or Child
item_type	string	yes	Kind of liability as printed
points	string	yes	Points as printed
rate_term	string	yes	Interest rate and term as printed
amount_range	string	yes	Liability amount as eFD prints it: a bracket ("$1,001 - $15,000"), an open-ended top bracket ("Over $5,000,000"), an exact figure ("$2,148.46") or a note ("None (or less than $201)"); null when the cell is blank
amount_min	bigint	yes	Lower bound of amount_range in whole dollars; equal to amount_max for an exact figure; null when the range states no figure
amount_max	bigint	yes	Upper bound of amount_range in whole dollars; null for an open-ended top bracket or a range with no figure
creditor	string	yes	Who is owed, with city and state as printed
comments	string	yes	Filer's comment as printed

fd_gifts · table

Part 5 (Gifts) of Senate annual, candidate and new-filer financial-disclosure reports: one row per reportable gift received by the filer, spouse or dependent child, with the donor and the value. event_date is the gift date as printed (MM/DD/YYYY), recipient Self, Spouse or Child, and value_range the value as printed (usually an exact figure).

Column	Type	Null	Description
year	INTEGER	yes
chamber	string	no	Always "senate" — the Senate eFD system; the House's own disclosures are in member_stock_transactions
filing_id	string	no	The eFD report UUID (the last path segment of filing_url); with the row keys of each table it identifies one row
filer_first_name	string	yes	Filer's first (and middle) name as the eFD listing prints it; "Candidate" filers are listed without a name
filer_last_name	string	no	Filer's last name as the eFD listing prints it, suffixes included (e.g. "McConnell, Jr."); "Candidate" for candidate filers, whom eFD lists anonymously
report_title	string	no	The report title as eFD lists it, e.g. "Annual Report for CY 2024", "Periodic Transaction Report for 12/19/2025", "Candidate Report (Amendment 1)"
filing_date	string	no	Date the report was filed with the Senate (YYYY-MM-DD); the year dimension is this date's year
calendar_year	integer	yes	Calendar year the report covers (the "CY 2024" of an annual report); null for PTRs and extension notices, which cover no calendar year
filing_url	string	no	efdsearch.senate.gov URL of the report page (the Senate's terms-of-use agreement must be accepted to open it)
item_no	string	no	The report's own row number within the part; a trust's underlying holdings are "6.1", "6.2", ... under asset 6
row_seq	integer	no	1-based position of the row within its part of the report page; eFD's own item numbers repeat within some filings, so this is the row key
event_date	string	yes	Date of the gift as printed (MM/DD/YYYY)
recipient	string	yes	Who received the gift: Self, Spouse or Child
gift	string	yes	Description of the gift
value_range	string	yes	Gift value as eFD prints it: a bracket ("$1,001 - $15,000"), an open-ended top bracket ("Over $5,000,000"), an exact figure ("$2,148.46") or a note ("None (or less than $201)"); null when the cell is blank
value_min	bigint	yes	Lower bound of value_range in whole dollars; equal to value_max for an exact figure; null when the range states no figure
value_max	bigint	yes	Upper bound of value_range in whole dollars; null for an open-ended top bracket or a range with no figure
gift_from	string	yes	Donor, with city and state as printed
comments	string	yes	Filer's comment as printed

fd_travel · table

Part 6 (Travel) of Senate annual, candidate and new-filer financial-disclosure reports: one row per reportable trip paid for or reimbursed by an outside sponsor. event_date holds the trip dates as printed, travelers who traveled, travel_type the trip kind, itinerary the places, reimbursed_for what the sponsor covered and who_paid the sponsor. Most reports have no travel and so no rows.

Column	Type	Null	Description
year	INTEGER	yes
chamber	string	no	Always "senate" — the Senate eFD system; the House's own disclosures are in member_stock_transactions
filing_id	string	no	The eFD report UUID (the last path segment of filing_url); with the row keys of each table it identifies one row
filer_first_name	string	yes	Filer's first (and middle) name as the eFD listing prints it; "Candidate" filers are listed without a name
filer_last_name	string	no	Filer's last name as the eFD listing prints it, suffixes included (e.g. "McConnell, Jr."); "Candidate" for candidate filers, whom eFD lists anonymously
report_title	string	no	The report title as eFD lists it, e.g. "Annual Report for CY 2024", "Periodic Transaction Report for 12/19/2025", "Candidate Report (Amendment 1)"
filing_date	string	no	Date the report was filed with the Senate (YYYY-MM-DD); the year dimension is this date's year
calendar_year	integer	yes	Calendar year the report covers (the "CY 2024" of an annual report); null for PTRs and extension notices, which cover no calendar year
filing_url	string	no	efdsearch.senate.gov URL of the report page (the Senate's terms-of-use agreement must be accepted to open it)
item_no	string	no	The report's own row number within the part; a trust's underlying holdings are "6.1", "6.2", ... under asset 6
row_seq	integer	no	1-based position of the row within its part of the report page; eFD's own item numbers repeat within some filings, so this is the row key
event_date	string	yes	Trip date(s) as printed
travelers	string	yes	Who traveled
travel_type	string	yes	Kind of trip as printed
itinerary	string	yes	Itinerary as printed
reimbursed_for	string	yes	What the sponsor paid for (e.g. Lodging, Meals)
who_paid	string	yes	Sponsor that paid, with city and state as printed
comments	string	yes	Filer's comment as printed

fd_positions · table

Part 8 (Positions) of Senate annual, candidate and new-filer financial-disclosure reports: one row per reportable outside position — board seats, trusteeships, officer and advisory roles, paid or unpaid — with the entity. position_dates is the span as printed (e.g. "Jun 1994 to present"), position_held the title with its qualifier (e.g. "Other (Member, Visiting Committee (Uncompensated))"), entity the organization with city and state, and entity_type the organization's category.

Column	Type	Null	Description
year	INTEGER	yes
chamber	string	no	Always "senate" — the Senate eFD system; the House's own disclosures are in member_stock_transactions
filing_id	string	no	The eFD report UUID (the last path segment of filing_url); with the row keys of each table it identifies one row
filer_first_name	string	yes	Filer's first (and middle) name as the eFD listing prints it; "Candidate" filers are listed without a name
filer_last_name	string	no	Filer's last name as the eFD listing prints it, suffixes included (e.g. "McConnell, Jr."); "Candidate" for candidate filers, whom eFD lists anonymously
report_title	string	no	The report title as eFD lists it, e.g. "Annual Report for CY 2024", "Periodic Transaction Report for 12/19/2025", "Candidate Report (Amendment 1)"
filing_date	string	no	Date the report was filed with the Senate (YYYY-MM-DD); the year dimension is this date's year
calendar_year	integer	yes	Calendar year the report covers (the "CY 2024" of an annual report); null for PTRs and extension notices, which cover no calendar year
filing_url	string	no	efdsearch.senate.gov URL of the report page (the Senate's terms-of-use agreement must be accepted to open it)
item_no	string	no	The report's own row number within the part; a trust's underlying holdings are "6.1", "6.2", ... under asset 6
row_seq	integer	no	1-based position of the row within its part of the report page; eFD's own item numbers repeat within some filings, so this is the row key
position_dates	string	yes	Dates held as printed (e.g. "Jun 1994 to present")
position_held	string	yes	Position title as printed
entity	string	yes	Organization, with city and state as printed
entity_type	string	yes	Organization category as printed
comments	string	yes	Filer's comment as printed

fd_agreements · table

Part 9 (Agreements) of Senate annual, candidate and new-filer financial-disclosure reports: one row per reportable agreement or arrangement with an outside entity — future employment, leaves of absence, continuing payments from a former employer, book contracts. event_date is the agreement date as printed (e.g. "Oct 2015"), parties who is party to it, item_type its kind and status_and_terms the filer's description of its status and terms.

Column	Type	Null	Description
year	INTEGER	yes
chamber	string	no	Always "senate" — the Senate eFD system; the House's own disclosures are in member_stock_transactions
filing_id	string	no	The eFD report UUID (the last path segment of filing_url); with the row keys of each table it identifies one row
filer_first_name	string	yes	Filer's first (and middle) name as the eFD listing prints it; "Candidate" filers are listed without a name
filer_last_name	string	no	Filer's last name as the eFD listing prints it, suffixes included (e.g. "McConnell, Jr."); "Candidate" for candidate filers, whom eFD lists anonymously
report_title	string	no	The report title as eFD lists it, e.g. "Annual Report for CY 2024", "Periodic Transaction Report for 12/19/2025", "Candidate Report (Amendment 1)"
filing_date	string	no	Date the report was filed with the Senate (YYYY-MM-DD); the year dimension is this date's year
calendar_year	integer	yes	Calendar year the report covers (the "CY 2024" of an annual report); null for PTRs and extension notices, which cover no calendar year
filing_url	string	no	efdsearch.senate.gov URL of the report page (the Senate's terms-of-use agreement must be accepted to open it)
item_no	string	no	The report's own row number within the part; a trust's underlying holdings are "6.1", "6.2", ... under asset 6
row_seq	integer	no	1-based position of the row within its part of the report page; eFD's own item numbers repeat within some filings, so this is the row key
event_date	string	yes	Date of the agreement as printed (e.g. "Oct 2015")
parties	string	yes	Parties involved as printed
item_type	string	yes	Kind of agreement as printed
status_and_terms	string	yes	Status and terms as the filer describes them
comments	string	yes	Filer's comment as printed

fd_compensation · table

Part 10 (Compensation) of Senate candidate and new-filer financial-disclosure reports, which alone must list any person or entity that paid the filer more than $5,000 for services: one row per source, with the duties performed. Annual reports of sitting senators answer "This is not my first report" and have no rows, so the table is small and holds candidates and first reports.

Column	Type	Null	Description
year	INTEGER	yes
chamber	string	no	Always "senate" — the Senate eFD system; the House's own disclosures are in member_stock_transactions
filing_id	string	no	The eFD report UUID (the last path segment of filing_url); with the row keys of each table it identifies one row
filer_first_name	string	yes	Filer's first (and middle) name as the eFD listing prints it; "Candidate" filers are listed without a name
filer_last_name	string	no	Filer's last name as the eFD listing prints it, suffixes included (e.g. "McConnell, Jr."); "Candidate" for candidate filers, whom eFD lists anonymously
report_title	string	no	The report title as eFD lists it, e.g. "Annual Report for CY 2024", "Periodic Transaction Report for 12/19/2025", "Candidate Report (Amendment 1)"
filing_date	string	no	Date the report was filed with the Senate (YYYY-MM-DD); the year dimension is this date's year
calendar_year	integer	yes	Calendar year the report covers (the "CY 2024" of an annual report); null for PTRs and extension notices, which cover no calendar year
filing_url	string	no	efdsearch.senate.gov URL of the report page (the Senate's terms-of-use agreement must be accepted to open it)
item_no	string	no	The report's own row number within the part; a trust's underlying holdings are "6.1", "6.2", ... under asset 6
row_seq	integer	no	1-based position of the row within its part of the report page; eFD's own item numbers repeat within some filings, so this is the row key
source	string	yes	Who paid more than $5,000, as printed
duties	string	yes	Duties performed as printed
comments	string	yes	Filer's comment as printed

scotus_cases · view

Every decided U.S. Supreme Court case from the bound United States Reports and from supremecourt.gov, in one table with one row per case: the rows of scotus_reports_cases (Court terms 1781 through 2017, volumes 2-583) and of scotus_slip_opinions (terms 2017 onward). The two sources do not overlap — the term 2017 opinions before March 21, 2018 are in volume 583 and the rest are slip opinions. source says which table a row is from (govinfo_reports or supremecourt_slip) and so which columns are populated: the curated outcome columns (party_winning, chief_justice, opinion_writer, votes, case_origin, case_source, cert_reason, jurisdiction) are present for govinfo_reports rows through volume 582 only, and holding_summary and author_initials only for supremecourt_slip rows. term is the Court term (the year its October term began). case_name is the name without its citation. disposition uses one vocabulary in both sources, and disposition_source says whether it is GovInfo's curated value or was derived from the opinion text. docket_numbers are the Court's docket numbers read from the opinion. decision_date is null for a volume 583 case, where GovInfo dates only the year; decision_year is always present.

View — columns are resolved by the query engine at runtime.