Federal lobbying reports since 1999, lobbyists’ political contribution reports since 2008, state filings from 19 states, and five city and county registries, updated weekly.
Under the Lobbying Disclosure Act, lobbying firms and organizations that lobby for themselves register with Congress and file a report every quarter (twice a year before 2008). Each report names the client, the issues and bills lobbied, the parts of Congress and the federal agencies contacted, the lobbyists who did the work, and the income or expenses for the period. Lobbyists and the organizations they work for also file a report twice a year (form LD-203) listing their political contributions. This listing carries both, from LDA.gov, the U.S. Senate’s lobbying disclosure site.
It adds 3,747,684 state lobbying rows from California, Colorado, Delaware, Florida, Georgia, Iowa, Idaho, Maryland, Minnesota, Mississippi, North Carolina, North Dakota, New Hampshire, New Mexico, Nevada, New York, Oklahoma, Oregon and Pennsylvania. Maryland covers the 2005–2017 open-data file only. It also includes the registries of Austin, Los Angeles, Cook County, Dallas and New York City, mapped into one local table. Coverage and reporting periods vary by state.
Common uses: who lobbies for a company or on an issue, which outside firms a client hires and what they report being paid, which agencies an issue is taken to, the candidates and committees lobbyists give to, and the same clients’ lobbying in state capitols and city halls.
| Fact | Detail |
|---|---|
| Source | Federal: LDA.gov, retrieved weekly. State: the public lobbying disclosure agencies of 19 states, including the Maryland State Ethics Commission for its 2005–2017 open-data file. Local: the open data portals of Austin, Los Angeles, Cook County, Dallas and New York City (the City Clerk’s eLobbyist filings) |
| Coverage | Federal filings 1999 to present. Contribution reports 2008 to present. 19 states, with Maryland limited to 2005–2017. Austin, Los Angeles, Cook County (to October 2021), Dallas and New York City |
| Refresh | Weekly. The listing gives the date federal data was last retrieved from LDA.gov |
| Free trial | 30 days, filing year 2024 in every table |
| Subscription | Every table and every year |
| Join key | REGISTRANT_ID joins FEDERAL_FILINGS and FEDERAL_CONTRIBUTIONS. The state and local tables share no id with the federal ones. Match them by name. |
| Permitted use | Not for employment, tenant, credit, insurance or licensing decisions about a person. |
Row counts checked October 27, 2026. Local registry counts checked November 15, 2026.
| Table | Rows | Covers | Free trial |
|---|---|---|---|
FEDERAL_FILINGS | 1,994,575 | Registrations and quarterly reports, 1999 to present | Filing year 2024 |
FEDERAL_CONTRIBUTIONS | 666,934 | Semiannual contribution reports (LD-203), 2008 to present | Filing year 2024 |
STATE_FILINGS | 3,747,684 | 19 states, Maryland 2005–2017 only | Rows whose period starts in 2024 |
LOCAL_FILINGS | 409,649 | Austin, Los Angeles, Cook County, Dallas and New York City | Rows whose period starts in 2024 |
| State or local government | Table | Rows | What it publishes |
|---|---|---|---|
| California | STATE_FILINGS | 1,473,827 | Registrations and reports as published. Coverage varies by state |
| Colorado | STATE_FILINGS | 164,064 | Registrations and reports as published. Coverage varies by state |
| Delaware | STATE_FILINGS | 3,636 | Registrations and reports as published. Coverage varies by state |
| Florida | STATE_FILINGS | 677,437 | Registrations and reports as published. Coverage varies by state |
| Georgia | STATE_FILINGS | 56,768 | Registrations and reports as published. Coverage varies by state |
| Iowa | STATE_FILINGS | 26,373 | Registrations and reports as published. Coverage varies by state |
| Idaho | STATE_FILINGS | 15,826 | Registrations and reports as published. Coverage varies by state |
| Maryland | STATE_FILINGS | 43,470 | 2005–2017 public-domain open-data file only. Maryland State Ethics Commission |
| Minnesota | STATE_FILINGS | 19,592 | Registrations and reports as published. Coverage varies by state |
| Mississippi | STATE_FILINGS | 19,215 | Registrations and reports as published. Coverage varies by state |
| North Carolina | STATE_FILINGS | 57,518 | Registrations and reports as published. Coverage varies by state |
| North Dakota | STATE_FILINGS | 21,653 | Registrations and reports as published. Coverage varies by state |
| New Hampshire | STATE_FILINGS | 1,772 | Registrations and reports as published. Coverage varies by state |
| New Mexico | STATE_FILINGS | 11,948 | Registrations and reports as published. Coverage varies by state |
| Nevada | STATE_FILINGS | 27,850 | Registrations and reports as published. Coverage varies by state |
| New York | STATE_FILINGS | 827,982 | Registrations and reports as published. Coverage varies by state |
| Oklahoma | STATE_FILINGS | 91,949 | Registrations and reports as published. Coverage varies by state |
| Oregon | STATE_FILINGS | 21,657 | Registrations and reports as published. Coverage varies by state |
| Pennsylvania | STATE_FILINGS | 185,147 | Registrations and reports as published. Coverage varies by state |
| Austin | LOCAL_FILINGS | 311,276 | Clients with reported pay, and the city matters lobbied, from each report |
| New York City | LOCAL_FILINGS | 82,393 | Client registrations and bimonthly reports: the registered lobbyist (usually a firm), the people who lobbied, the client, activities, agencies lobbied and compensation |
| Los Angeles | LOCAL_FILINGS | 10,810 | Lobbyist registrations: lobbyist and firm, no client |
| Cook County | LOCAL_FILINGS | 4,702 | Lobbying contacts: who lobbied which official, for which client, on what. Stops in October 2021 |
| Dallas | LOCAL_FILINGS | 468 | Registrations and quarterly reports: lobbyist and client |
Reading the data
AMOUNT in FEDERAL_FILINGS is an outside firm’s income from the client or, for an organization lobbying for itself, its own lobbying expenses. In-house expenses can include fees paid to outside firms that report the same money as income, so do not add the two kinds together. The table has no label saying which kind a row is. In-house filers usually name themselves as the client.
Amended reports are separate filings. To count a period once, keep the latest filing per registrant, client and period, as the sample queries do.
LOBBYING_ACTIVITIES, FOREIGN_ENTITIES, AFFILIATED_ORGANIZATIONS, PACS and CONTRIBUTION_ITEMS hold JSON text. Read them with PARSE_JSON and LATERAL FLATTEN.
In LOCAL_FILINGS, money stays on the row the city published it on and is never copied onto activity rows. Several lobbyists can each report the same client fee. Austin repeats its whole client list on every new, update, renewal and termination filing, so use FILING_TYPE = 'Quarterly_Activity_Report' for one pass per quarter. Austin publishes many amounts as ranges only (COMPENSATION_RANGE).
A New York City report lists all its activities and all its agencies together, so an agency and a subject on the same row are not tied to each other. The city writes N/A where a report lists none, and those are left empty. The city does not say whether a report’s compensation is for that period or a running total. For a flat retainer the same figure repeats from report to report. Check before adding periods together.
One registration can produce a row for each named lobbyist, with the same compensation repeated across those rows. Use STATE, SOURCE and SOURCE_RECORD_ID to identify the source record before adding amounts. Compensation may be a firm’s income or a client’s total lobbying spending, rather than an individual lobbyist’s pay. Read the state’s source report before comparing amounts.
Cook County’s registry stops in October 2021, so Cook County has no rows in the 2024 trial. Maryland, New Hampshire and Nevada also have no rows whose YEAR_START is 2024 in this release.
Four tables, 92 columns in total: FEDERAL_FILINGS, FEDERAL_CONTRIBUTIONS, STATE_FILINGS and LOCAL_FILINGS. The same tables serve the trial and the subscription. During the free trial they return 2024 only: FILING_YEAR = 2024 in the federal tables, YEAR_START = 2024 in STATE_FILINGS, and a PERIOD_START in 2024 in LOCAL_FILINGS. A subscription adds every other year.
FEDERAL_FILINGSOne row per filing posted on LDA.gov: registrations, quarterly reports (semiannual before 2008), amendments and terminations. 22 columns. Values are as LDA.gov publishes them, except AMOUNT.
| Column | Type | Meaning |
|---|---|---|
ID | FLOAT | Civly’s row id. |
FILING_UUID | TEXT | LDA.gov’s id for the filing. |
FILING_TYPE | TEXT | Filing type code as published, for example RR for a registration or Q1 for a first-quarter report. Amendments and terminations have their own codes. |
FILING_TYPE_DISPLAY | TEXT | The filing type in words. |
FILING_YEAR | FLOAT | Year the filing covers. The trial returns 2024. |
FILING_PERIOD | TEXT | Period code as published: a quarter, or mid-year or year-end for reports before 2008. |
FILING_PERIOD_DISPLAY | TEXT | The period in words. |
DT_POSTED | TIMESTAMP_NTZ | When LDA.gov posted the filing. |
REGISTRANT_ID | FLOAT | LDA.gov’s id for the registrant: the lobbying firm, or the organization lobbying for itself. Joins to FEDERAL_CONTRIBUTIONS. |
REGISTRANT_NAME | TEXT | Registrant name as filed. |
REGISTRANT_DESCRIPTION | TEXT | The registrant’s description of its business, as filed. |
CLIENT_ID | FLOAT | LDA.gov’s id for the client. |
CLIENT_NAME | TEXT | Client name as filed. An organization lobbying for itself usually names itself as the client. |
CLIENT_STATE | TEXT | State of the client’s address, as filed. |
CLIENT_COUNTRY | TEXT | Country of the client’s address, as filed. |
LOBBYING_ACTIVITIES | TEXT | JSON text, one entry per issue area: the general issue code, the specific issues and bills lobbied, the lobbyists who worked on it with any covered government positions they disclosed, and the government entities contacted. |
FOREIGN_ENTITIES | TEXT | JSON text: foreign entities with an interest in the lobbying, as disclosed. |
AFFILIATED_ORGANIZATIONS | TEXT | JSON text: affiliated organizations, as disclosed. |
AMOUNT | NUMBER | Civly’s column. For an outside firm, its income from this client for the period. For an organization lobbying for itself, its own lobbying expenses. Empty when the filing gives no figure, such as a registration or a report that checks the form’s “less than” box. Do not add the two kinds together (see Reading the data). |
URL | TEXT | Link to the filing on LDA.gov. |
CREATED_AT | TIMESTAMP_NTZ | When Civly first loaded the filing. |
UPDATED_AT | TIMESTAMP_NTZ | When Civly last retrieved the filing from LDA.gov. |
FEDERAL_CONTRIBUTIONSOne row per semiannual contribution report (LD-203), filed by each registered lobbyist and by each registrant. 20 columns. Values are as LDA.gov publishes them.
| Column | Type | Meaning |
|---|---|---|
ID | FLOAT | Civly’s row id. |
FILING_UUID | TEXT | LDA.gov’s id for the report. |
FILING_TYPE | TEXT | Report type code as published: a mid-year or year-end report, or an amendment to one. |
FILING_TYPE_DISPLAY | TEXT | The report type in words. |
FILING_YEAR | FLOAT | Year the report covers. The trial returns 2024. |
FILING_PERIOD | TEXT | Period code as published: mid-year or year-end. |
FILING_PERIOD_DISPLAY | TEXT | The period in words. |
DT_POSTED | TIMESTAMP_NTZ | When LDA.gov posted the report. |
REGISTRANT_ID | FLOAT | LDA.gov’s id for the registrant the lobbyist works for, or the registrant filing its own report. Joins to FEDERAL_FILINGS. |
REGISTRANT_NAME | TEXT | Registrant name as filed. |
LOBBYIST_ID | FLOAT | LDA.gov’s id for the lobbyist. Empty on a registrant’s own report. |
LOBBYIST_FIRST_NAME | TEXT | Lobbyist first name as filed. |
LOBBYIST_LAST_NAME | TEXT | Lobbyist last name as filed. |
LOBBYIST_SUFFIX | TEXT | Lobbyist name suffix as filed. |
PACS | TEXT | JSON text: political action committees the filer established or controls, as reported. |
CONTRIBUTION_ITEMS | TEXT | JSON text, one entry per contribution reported: type, contributor, payee, honoree, amount and date. |
NO_CONTRIBUTIONS | BOOLEAN | True when the filer reported no contributions for the period. |
URL | TEXT | Link to the report on LDA.gov. |
CREATED_AT | TIMESTAMP_NTZ | When Civly first loaded the report. |
UPDATED_AT | TIMESTAMP_NTZ | When Civly last retrieved the report from LDA.gov. |
STATE_FILINGSLobbying filings from 19 states, with rows expanded or grouped as each state publishes them. 24 columns. FILING_KIND separates registrations from expenditure filings.
| Column | Type | Meaning |
|---|---|---|
ID | FLOAT | Civly’s row id. |
STATE | TEXT | NY or CO. |
SOURCE | TEXT | The state dataset the row came from. |
SOURCE_RECORD_ID | TEXT | The record’s id in that dataset, when it has one. |
FILING_KIND | TEXT | registration, or expenditure for compensation and spending a lobbyist reported. |
REGISTRANT_NAME | TEXT | Lobbyist or lobbying firm, as filed. |
REGISTRANT_FIRST | TEXT | First name, when the registrant is a person. |
REGISTRANT_LAST | TEXT | Last name, when the registrant is a person. |
REGISTRANT_FIRST_NORM | TEXT | Civly’s uppercased, trimmed first name, for matching. |
REGISTRANT_LAST_NORM | TEXT | Civly’s uppercased, trimmed last name, for matching. |
REGISTRANT_FIRM | TEXT | The firm the registrant works for, when published. |
IS_INDIVIDUAL | BOOLEAN | True when the registrant is a person rather than a firm. |
CLIENT_NAME | TEXT | Client, as filed. |
CLIENT_NAME_NORM | TEXT | Civly’s normalized client name, for matching. |
PERIOD_RAW | TEXT | The period as the state printed it. |
YEAR_START | FLOAT | First year of the period, read by Civly from the state’s period. The trial returns 2024. |
YEAR_END | FLOAT | Last year of the period, read the same way. |
COMPENSATION_RAW | TEXT | Compensation as the state printed it. |
COMPENSATION_AMOUNT | FLOAT | Civly’s reading of COMPENSATION_RAW as dollars. Empty when it holds no amount. |
STATUS | TEXT | Registration status, as published. |
DESCRIPTION | TEXT | Subject or description, as published. |
RECORD_URL | TEXT | Link to the record on the state’s site, when published. |
CREATED_AT | TIMESTAMP_NTZ | When Civly loaded the row. |
UPDATED_AT | TIMESTAMP_NTZ | When Civly last changed the row. |
LOCAL_FILINGSCivly’s table: the Austin, Los Angeles, Cook County, Dallas and New York City registries mapped into one set of columns, one row per source record. A column a city or county does not publish is empty. Names are as filed. 26 columns.
| Column | Type | Meaning |
|---|---|---|
JURISDICTION | TEXT | Austin, Los Angeles, Cook County, Dallas or New York City. |
JURISDICTION_LEVEL | TEXT | city or county. |
STATE | TEXT | TX, CA, IL or NY. |
RECORD_TYPE | TEXT | activity: who lobbied on what, with no money (Austin matters lobbied, Cook County contacts). compensation: what a lobbyist reported being paid by a client (Austin). report: a periodic report naming the lobbyist and client (Dallas), or a New York City bimonthly report that also lists activities, agencies lobbied and compensation. registration: a registration (Los Angeles names the lobbyist and firm only, Dallas the lobbyist and client, New York City a client registration with no report yet). |
LOBBYIST_NAME | TEXT | The person who lobbied, as filed. New York City lists everyone who lobbied for the registered lobbyist in one value. |
LOBBYING_FIRM | TEXT | The lobbyist’s firm or employer, as filed (Austin, Los Angeles, Cook County). New York City: the registered lobbyist, usually a firm. |
CLIENT_NAME | TEXT | Client, as filed (Austin compensation rows, Cook County, Dallas, New York City). Los Angeles publishes no client. |
AGENCY_OR_OFFICIAL_LOBBIED | TEXT | The official contacted, with title (Cook County). New York City: every agency and official a report lists, together. |
SUBJECT_MATTER | TEXT | Subject or city matter lobbied (Austin activity rows, Cook County, New York City). |
COMPENSATION | NUMBER | Dollars the lobbyist reported being paid by the client (Austin, New York City). Empty, never zero, when none is published. |
COMPENSATION_RANGE | TEXT | Austin’s published pay range, for example Less than $10,000. |
PERIOD_START | DATE | Start of the period the row covers. Austin quarterly reports: worked out by Civly from the filing month and report year. Dallas: read from the report title. Los Angeles: the date the lobbyist qualified. Cook County: the date of the contact. New York City reports: worked out by Civly from the report’s period number and year (bimonthly, so period 1 is January and February). New York City registrations with no report yet: the registration’s start date. The trial returns rows starting in 2024. |
PERIOD_END | DATE | End of that period. Los Angeles: the date the registration ended. |
FILED_DATE | DATE | Date filed or registered (Austin, Los Angeles, Dallas). |
FILING_TYPE | TEXT | The filing’s type as published, for example Quarterly_Activity_Report (Austin, Dallas). |
FILING_ID | TEXT | The city’s report id (Austin, Dallas, New York City). |
IS_LATEST_FILING | BOOLEAN | Not filled for any jurisdiction now in the listing. |
LOBBYIST_SOURCE_ID | TEXT | The city’s id for the lobbyist (Austin, New York City). |
CLIENT_SOURCE_ID | TEXT | The city’s id for the client (New York City). |
SOURCE_DATASET | TEXT | Id of the open data portal dataset the row came from. |
SOURCE_TABLE | TEXT | Civly’s name for that dataset. |
SOURCE_ROW_ID | TEXT | The portal’s own key for the row, or a fingerprint of its values when the portal publishes none. |
SOURCE_URL | TEXT | Download address of the portal dataset. |
SOURCE_SHA256 | TEXT | Checksum of the downloaded file. |
SOURCE_RELEASE_DATE | DATE | Date of the portal copy the row came from. |
IMPORTED_AT | TIMESTAMP_NTZ | When Civly imported the row. |
REGISTRANT_ID joins FEDERAL_FILINGS and FEDERAL_CONTRIBUTIONS, so a firm’s clients sit beside its lobbyists’ contributions. The state and local tables share no id with the federal tables or with each other. Match them by name: CLIENT_NAME in every table (CLIENT_NAME_NORM in STATE_FILINGS), and REGISTRANT_NAME, LOBBYIST_NAME or LOBBYING_FIRM for the lobbyist side. Names are as filed, so one organization can be spelled several ways.
After installing, set your worksheet’s database selector to the installed database and these run as written.
-- Federal issue areas lobbied most often in 2024 SELECT a.value:general_issue_code::string AS issue_code, COUNT(DISTINCT f.filing_uuid) AS filings FROM US_LOBBYING.FEDERAL_FILINGS f, LATERAL FLATTEN(input => PARSE_JSON(f.lobbying_activities)) a WHERE f.filing_year = 2024 GROUP BY issue_code ORDER BY filings DESC LIMIT 25; -- One client's 2024 federal lobbying: the latest filing with a figure per registrant and period, -- with in-house expenses kept apart from outside firms' income (in-house filers usually name themselves as client) WITH latest AS ( SELECT * FROM US_LOBBYING.FEDERAL_FILINGS WHERE filing_year = 2024 AND client_name ILIKE 'pfizer%' AND amount IS NOT NULL QUALIFY ROW_NUMBER() OVER (PARTITION BY registrant_id, client_id, filing_period ORDER BY dt_posted DESC) = 1 ) SELECT IFF(UPPER(registrant_name) = UPPER(client_name), 'in-house expenses', 'outside firm income') AS kind, registrant_name, SUM(amount) AS reported_usd FROM latest GROUP BY kind, registrant_name ORDER BY reported_usd DESC NULLS LAST; -- 2024 contributions by honoree, latest report per filer and period so amendments count once WITH latest AS ( SELECT * FROM US_LOBBYING.FEDERAL_CONTRIBUTIONS WHERE filing_year = 2024 QUALIFY ROW_NUMBER() OVER (PARTITION BY registrant_id, lobbyist_id, filing_period ORDER BY dt_posted DESC) = 1 ) SELECT i.value:honoree_name::string AS honoree, COUNT(*) AS contributions, SUM(TRY_TO_NUMBER(i.value:amount::string, 18, 2)) AS total_usd FROM latest l, LATERAL FLATTEN(input => PARSE_JSON(l.contribution_items)) i GROUP BY honoree ORDER BY total_usd DESC NULLS LAST LIMIT 25; -- One client across the state and local registries SELECT 'state' AS level, state AS filed_in, registrant_name AS lobbyist, client_name, year_start AS yr FROM US_LOBBYING.STATE_FILINGS WHERE client_name ILIKE '%uber%' UNION ALL SELECT jurisdiction_level, jurisdiction, COALESCE(lobbyist_name, lobbying_firm), client_name, YEAR(period_start) FROM US_LOBBYING.LOCAL_FILINGS WHERE client_name ILIKE '%uber%' ORDER BY yr DESC; -- Austin: what lobbyists reported being paid, one pass per quarter SELECT period_start, client_name, lobbyist_name, lobbying_firm, compensation, compensation_range FROM US_LOBBYING.LOCAL_FILINGS WHERE jurisdiction = 'Austin' AND record_type = 'compensation' AND filing_type = 'Quarterly_Activity_Report' AND YEAR(period_start) = 2024 ORDER BY period_start, client_name;
Federal filings and contribution reports come from LDA.gov, retrieved every week. The listing gives the date of the latest retrieval, and each row’s UPDATED_AT is when Civly last retrieved it. LDA.gov’s content is kept as published. Two parts are Civly’s work, not the Senate’s: the AMOUNT column, where Civly takes the income figure or the expenses figure, and the LOCAL_FILINGS table, which is Civly’s mapping of five local registries into one set of columns. YEAR_START, YEAR_END, COMPENSATION_AMOUNT and the _NORM columns in STATE_FILINGS are Civly’s readings too. Lobbyists’ criminal-conviction disclosures, which LDA.gov publishes, are not included.
This product does not use the Senate seal and is not endorsed by the U.S. Senate, the House of Representatives, or any state or local government.
State sources are the public lobbying disclosure agencies of California, Colorado, Delaware, Florida, Georgia, Iowa, Idaho, Maryland, Minnesota, Mississippi, North Carolina, North Dakota, New Hampshire, New Mexico, Nevada, New York, Oklahoma, Oregon and Pennsylvania. Maryland data is credited to the Maryland State Ethics Commission and covers only its public-domain 2005–2017 open-data file. Later Maryland registration records are excluded. California rows come from the redacted Cal-Access public daily export. Local sources are the City of Austin (public domain), the City of Los Angeles (CC0) and Cook County (public domain). Cook County’s registry stops in October 2021. Dallas data is credited to the City of Dallas and used under the Open Data Commons Attribution License. New York City data is the City Clerk’s eLobbyist filings from NYC Open Data, credited to the Office of the City Clerk, New York City. NYC.gov’s terms of use say that NYC.gov and all materials on it are distributed “as is” and “as available.” Coverage is limited to the states and local governments listed above.
Permitted use: not for employment, tenant, credit, insurance or licensing decisions about a person.
For coverage or access questions: matthew@civly.ai