From a 445-row sample across 23 columns.
lobbyist_employeeszipstatecityHas zip codes (`zip`) — joinable, but needs boundary shapes to draw.
| report_id | filing_year | filing_period | period_start_date | period_end_date | report_type | entity_name | street_address | city | state | zip | phone |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 433602 | 2020 | 4 | 2020-07-01T00:00:00.000 | 2020-08-31T00:00:00.000 | Fundraising | James F. Capalino & Associates, Inc. | 233 Broadway, Suite 710 | New York | NY | 10007 | 2126165810 |
| 577896 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
report_id | text | Number to identify the report | 0% | 455318520777610595 |
filing_year | categorical | Year the report was filed | 0% | 202120232025of 7 |
filing_period | categorical | Reporting period when the report was filed | 0% | 321of 6 |
period_start_date | datetime | — | 0% | 2021-05-01T00:00:00.0002021-01-01T00:00:00.0002021-03-01T00:00:00.000 |
GET /api/datasets/7arw-dbem GET /api/datasets/7arw-dbem/quality GET /api/datasets/7arw-dbem/related GET /api/columns?dataset=7arw-dbem
phonestatecity| 2024 |
| 5 |
| 2024-09-01T00:00:00.000 |
| 2024-10-31T00:00:00.000 |
| Fundraising |
| James F. Capalino & Associates, Inc. |
| 1255 5th avenue, apt 7c |
| New York |
| NY |
| 10029 |
| 2126165810 |
| 563607 | 2024 | 3 | 2024-05-01T00:00:00.000 | 2024-06-30T00:00:00.000 | Fundraising | James F. Capalino & Associates, Inc. | 1255 5th avenue, apt 7c | New York | NY | 10029 | 2126165810 |
| 515637 | 2022 | 6 | 2022-11-01T00:00:00.000 | 2022-12-31T00:00:00.000 | Fundraising | James F. Capalino & Associates, Inc. | 233 Broadway, Suite 710 | New York | NY | 10007 | 2126165810 |
| 500275 | 2022 | 4 | 2022-07-01T00:00:00.000 | 2022-08-31T00:00:00.000 | Fundraising | James F. Capalino & Associates, Inc. | 233 Broadway, Suite 710 | New York | NY | 10007 | 2126165810 |
| 528672 | 2022 | 4 | 2022-07-01T00:00:00.000 | 2022-08-31T00:00:00.000 | Fundraising | Kasirer LLC | 120 Broadway, Suite 1010 | New York | NY | 10271 | 2122851800 |
| 539116 | 2023 | 5 | 2023-09-01T00:00:00.000 | 2023-10-31T00:00:00.000 | Fundraising | Kasirer LLC | 120 Broadway, Suite 1010 | New York | NY | 10271 | 2122851800 |
| 539116 | 2023 | 5 | 2023-09-01T00:00:00.000 | 2023-10-31T00:00:00.000 | Fundraising | Kasirer LLC | 120 Broadway, Suite 1010 | New York | NY | 10271 | 2122851800 |
| 420723 | 2020 | 1 | 2020-01-01T00:00:00.000 | 2020-02-28T00:00:00.000 | Fundraising | James F. Capalino & Associates, Inc. | 233 Broadway, Suite 710 | New York | NY | 10007 | 2126165810 |
| 611460 | 2025 | 2 | 2025-03-01T00:00:00.000 | 2025-04-30T00:00:00.000 | Fundraising | James F. Capalino & Associates, Inc. | 1255 5th avenue, apt 7c | New York | NY | 10029 | 2126165810 |
Showing 12 of 23 columns. All of them are listed below.
period_end_date | datetime | — | 0% | 2021-06-30T00:00:00.0002021-02-28T00:00:00.0002021-04-30T00:00:00.000 |
report_type | categorical | Indicates whether the lobbyist was providing fundraising or political consulting services | 0% | FundraisingPolitical Consultingof 2 |
entity_name | text | Name of the lobbyist | 0% | Constantinople & Vallone…Robert A. Ungar Associat…Patrick B. Jenkins & Ass… |
street_address | text | Street address of the lobbying business | 0% | 233 Broadway, Suite 830150 State Street, Suite …114-35 140th Street |
city | text | City of the lobbying business | 0% | New YorkAlbanyJamaica |
state | categorical | Two character state of the lobbying business | 0% | NYTXDCof 4 |
zip | text | Zip code of the lobbying business | 0% | 102791220711436 |
phone | text | Telephone number of the lobbying business | 0% | 212393650051622724003479560320 |
principal_last_name | text | e-Lobbyist primary authorized user last name | 0% | ValloneUngarAndrews |
principal_first_name | text | e-Lobbyist primary authorized user first name | 0% | PerryRobertDwayne |
lobbyist_employees | text | Lobbyist employee(s) who either fundraised or provided political consulting | 11% | Perry Vallone;Melissa Gonzalez; Robert…Jordan Carelus; Patrick … |
target_office | text | Political Office for which fundraising or political consulting services occurred | 0% | City Council MemberBorough PresidentMayor |
candidate_last_name | text | Last name of the political candidate | 0% | AdamsRileyBrannan |
candidate_first_name | text | First name of the political candidate | 0% | KevinAdrienneEric |
candidate_type | categorical | Indicates whether or not the candidate listed is a public servant | 0% | CandidatePublic Servantof 2 |
political_committee | text | Name of the candidate's election committee—the entity responsible for the collection and disbursement of campaign funds | 0% | Adrienne for NYCRiley 2023Kevin Parker for New Yor… |
third_party | text | The name of any third party the lobbyist contracted with to provide fundraising or political consulting services | 100% | — |
compensation_owed | integer | Total compensation paid or owed to the lobbyist for the current period | 0% | 030002000 |
total_expenses | integer | Lobbyist's total reported expenses | 0% | 04111921700 |
total_raised | integer | Amount of funds raised for the candidate | 0% | 0250500 |