A listing of campaign expendiures for candidates for City office during the 2005 election cycle
This dataset has the following 41 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| ELECTION | election | number | 2005 view top 100 |
| OFFICECD | officecd | number | 5 1 4 2 3 view top 100 |
| CANDID | candid | text | 605 Y2 AY 148 310 view top 100 |
| CANCLASS | canclass | text | P NP view top 100 |
| CANDLAST | candlast | text | Bloomberg Miller Ferrer Stringer Siegel view top 100 |
| CANDFIRST | candfirst | text | Michael A. Gifford Fernando Scott James view top 100 |
| CANDMI | candmi | text | R M C J S view top 100 |
| COMMITTEE | committee | text | H J I K M view top 100 |
| FILING | filing | number | 13 10 17 16 11 view top 100 |
| SCHEDULE | schedule | text | F N D L H view top 100 |
| PAGENO | pageno | text | view top 100 |
| SEQUENCENO | sequenceno | text | view top 100 |
| REFNO | refno | text | R0001341 R0001263 R0001149 R0000935 R0001029 view top 100 |
| INV_DATE | inv_date | calendar_date | 2005-09-13T00:00:00.000 2005-11-08T00:00:00.000 2005-09-12T00:00:00.000 2005-09-09T00:00:00.000 2005-08-12T00:00:00.000 view top 100 |
| DATE | date | calendar_date | 2005-09-13T00:00:00.000 2005-11-08T00:00:00.000 2005-09-15T00:00:00.000 2005-09-09T00:00:00.000 2005-11-30T00:00:00.000 view top 100 |
| NAME | name | text | Staples Verizon Squier Knapp Dunn Communicatio Gioia, Eric Petty Cash view top 100 |
| C_CODE | c_code | text | IND CORP OTHR LLC PART view top 100 |
| ORG_IND | org_ind | text | Y N view top 100 |
| NUMBER | strno | text | 225 1 345 4-74 115 view top 100 |
| STREET | strname | text | Broadway Park Avenue South Madison Avenue 48th Avenue N Street, NW view top 100 |
| UNIT | apartment | text | 450 2 2021 4 7 view top 100 |
| CITY | city | text | New York Brooklyn Queens Bronx Staten Island view top 100 |
| STATE | state | text | NY NJ CA DC AZ view top 100 |
| Postcode | postcode | text | 10003 10016 10010 11101 10007 view top 100 |
| Latitude | latitude | number | 40.74458 40.741609 40.729165 40.708631 40.738928 view top 100 |
| Longitude | longitude | number | -73.956448 -73.985316 -74.00525 -74.010997 -73.989846 view top 100 |
| Community Board | community_board | number | 105 101 107 104 102 view top 100 |
| Community Council | community_council | number | 3 1 2 4 6 view top 100 |
| Census Tract | census_tract | number | 21 33 52 1 68 view top 100 |
| BIN | bin | number | 4000019 1018102 1009758 1001030 1080760 view top 100 |
| BBL | bbl | number | 4000180001 1008810001 1005810063 1000500001 1008480015 view top 100 |
| NTA | nta | text | Midtown-Midtown South Hudson Yards-Chelsea-Flatiron-Union Square SoHo-TriBeCa-Civic Center-Little Italy Upper West Side Battery Park City-Lower Manhattan view top 100 |
| Borough | borough | text | MANHATTAN BROOKLYN QUEENS BRONX STATEN IS view top 100 |
| PAY_METHOD | pay_method | text | Final Advance Part Full Unknown view top 100 |
| AMNT | amnt | number | 100.00 500.00 200.00 150.00 1000.00 view top 100 |
| PURPOSECD | purposecd | text | WAGES OFFCE OTHER CONSL ADVAN view top 100 |
| PURPOSE | purpose | text | Campgn Wrkrs $$ Office Expenses Other: explntion Campgn Consuls. Advance Repaymnt view top 100 |
| EXPLAIN | explain | text | Advance Repayment Wages wages Salary Office Supplies view top 100 |
| EXEMPTCD | exemptcd | text | C P E view top 100 |
| RR_IND | rr_ind | text | N Y view top 100 |
| SEG_IND | seg_ind | text | N Y view top 100 |