From a 500-row sample across 46 columns.
c_codeadjtypecdintstrnm+43c_codeadjtypecdintstrnm+45c_codeempnameempstate+21Has zip codes (`zip`) — joinable, but needs boundary shapes to draw.
| election | officecd | candid | canclass | candlast | candfirst | candmi | committee | filing | schedule | refno | date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2017 | 1 | AU | P | Albanese | Sal | F | J | 6 | ABC | R0000145 | 2016-12-24T00:00:00.000 |
| 2017 | 1 | AU | P |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
election | categorical | — | 0% | 202520172021of 5 |
officecd | categorical | — | 0% | 514of 11 |
candid | text | — | 0% | 11643112063 |
canclass | categorical | — | 0% | PNPUNof 3 |
candlast | text | — |
GET /api/datasets/fbkk-n4e3 GET /api/datasets/fbkk-n4e3/quality GET /api/datasets/fbkk-n4e3/related GET /api/columns?dataset=fbkk-n4e3
c_codepay_methodcommittee+21c_codepay_methodcommittee+21c_codeempnameempstate+21name| Albanese |
| Sal |
| F |
| J |
| 6 |
| ABC |
| R0000148 |
| 2017-01-03T00:00:00.000 |
| 2017 | 1 | AU | P | Albanese | Sal | F | J | 6 | ABC | R0000154 | 2016-12-24T00:00:00.000 |
| 2017 | 1 | AU | P | Albanese | Sal | F | J | 6 | ABC | R0000170 | 2017-01-09T00:00:00.000 |
| 2017 | 1 | AU | P | Albanese | Sal | F | J | 6 | ABC | R0000187 | 2016-12-28T00:00:00.000 |
| 2017 | 1 | AU | P | Albanese | Sal | F | J | 6 | ABC | R0000214 | 2017-01-10T00:00:00.000 |
| 2017 | 1 | AU | P | Albanese | Sal | F | J | 7 | ABC | R0001189 | 2017-02-15T00:00:00.000 |
| 2017 | 1 | AU | P | Albanese | Sal | F | J | 8 | ABC | R0001753 | 2017-03-24T00:00:00.000 |
| 2017 | 1 | AU | P | Albanese | Sal | F | J | 8 | ABC | R0001804 | 2017-05-10T00:00:00.000 |
| 2017 | 1 | AU | P | Albanese | Sal | F | J | 9 | ABC | R0002241 | 2017-06-08T00:00:00.000 |
Showing 12 of 32 columns. All of them are listed below.
| 0% |
AdamsLanderLevine |
candfirst | text | — | 0% | BradMarkEric |
candmi | text | — | 59% | LMD |
committee | categorical | — | 0% | HLNof 12 |
filing | categorical | — | 0% | 583of 16 |
schedule | categorical | — | 0% | ABCMG1of 5 |
refno | text | — | 0% | R0000014R0000027R0000024 |
date | datetime | — | 11% | 2025-03-13T00:00:00.0002025-05-19T00:00:00.0002020-07-11T00:00:00.000 |
refunddate | datetime | — | 89% | 2020-02-20T00:00:00.0002024-08-16T00:00:00.0002017-02-13T00:00:00.000 |
name | text | — | 0% | Gonzalez, TeresaDaly, SamaraKline, Julian |
c_code | categorical | — | 0% | INDFAMof 2 |
strno | text | — | 100% | — |
strname | text | — | 100% | — |
apartment | text | — | 100% | — |
city | text | — | 0% | BrooklynNew YorkBronx |
boroughcd | categorical | — | 0% | MKZof 6 |
state | text | — | 0% | NYNJCT |
zip | text | — | 0% | 112151120110025 |
db_entity_name | text | — | 15% | BOLTON-ST. JOHNS LLCCONSTANTINOPLE & VALLONE…JAMES F. CAPALINO & ASSO… |
db_entity_start | text | — | 15% | 5/16/2009" "12\:00\:00 …2/2/2008" "12\:00\:00 A…12/3/2008" "12\:00\:00 … |
occupation | text | — | 13% | ConsultantExecutive DirectorCEO |
empname | text | — | 16% | Self-EmployedNot EmployedSelf Employed |
empstrno | text | — | 18% | 2331120 |
empstrname | text | — | 18% | Broadway5th AvenuePark Avenue |
empcity | text | — | 18% | New YorkBrooklynBronx |
empstate | text | — | 18% | NYNJCA |
amnt | integer | — | 0% | 250.00100.0050.00 |
matchamnt | integer | — | 0% | 0.00175.00100.00 |
prevamnt | integer | — | 0% | 0.00100.00250.00 |
pay_method | categorical | — | 12% | 421of 5 |
intermno | integer | — | 96% | 123 |
intermname | text | — | 96% | Constantinople, AnthonySinacori, StevenKriegel, Jay |
intstrno | categorical | — | 100% | 16003497-08of 3 |
intstrnm | categorical | — | 100% | 69th AvenueDorchester AvenueElberta Roadof 3 |
intaptno | text | — | 100% | — |
intcity | text | — | 96% | New YorkBrooklynFlushing |
intst | categorical | — | 96% | NYNJCTof 6 |
intzip | text | — | 96% | 100241002511357 |
intempname | text | — | 97% | SelfSelf-EmployedGreenberg Traurig |
intempstno | text | — | 97% | 233160 |
intempstnm | text | — | 97% | BroadwayMadison AvenueColumbus Circle |
intempcity | text | — | 97% | New YorkBrooklynAlbany |
intempst | categorical | — | 97% | NYCTNJof 6 |
intoccupa | text | — | 96% | AttorneyGovernment RelationsPartner |
int_c_code | categorical | — | 96% | INDCORPLLCof 5 |
adjtypecd | categorical | — | 89% | 251of 3 |
rr_ind | text | — | 0% | Nof 1 |
seg_ind | text | — | 0% | Nof 1 |