From a 442-row sample across 48 columns.
Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| id | borough | precinct | date | v_race | v_gender | v_age | p_gender | p_age | relationship | method | news |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 201301 | 2 | 63 | 2013-01-01T00:00:00.000 | 2 | 1 | 42 | 0 | 36 | 4 | 2 | 1 |
| 201305 | 2 | 61 | 2013-01-12T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
id | integer | — | 0% | 201606201403201601 |
borough | categorical | — | 0% | 452of 5 |
precinct | integer | — | 0% | 121122102 |
date | datetime | — | 0% | 2016-02-10T00:00:00.0002014-01-19T00:00:00.0002016-01-01T00:00:00.000 |
v_race | categorical |
GET /api/datasets/36qa-cicj GET /api/datasets/36qa-cicj/quality GET /api/datasets/36qa-cicj/related GET /api/columns?dataset=36qa-cicj
date| 2 |
| 1 |
| 51 |
| 0 |
| 55 |
| 1 |
| 1 |
| 2 |
| 201305 | 2 | 61 | 2013-01-12T00:00:00.000 | 2 | 1 | 51 | 0 | 55 | 1 | 1 | 1 |
| 201305 | 2 | 61 | 2013-01-12T00:00:00.000 | 2 | 1 | 51 | 0 | 55 | 1 | 1 | 1 |
| 201307 | 2 | 69 | 2013-02-17T00:00:00.000 | 2 | 1 | 51 | 0 | 58 | 3 | 1 | 3 |
| 201307 | 2 | 69 | 2013-02-17T00:00:00.000 | 2 | 1 | 51 | 0 | 58 | 3 | 1 | 1 |
| 201307 | 2 | 69 | 2013-02-17T00:00:00.000 | 2 | 1 | 51 | 0 | 58 | 3 | 1 | 4 |
| 201307 | 2 | 69 | 2013-02-17T00:00:00.000 | 2 | 1 | 51 | 0 | 58 | 3 | 1 | 3 |
| 201307 | 2 | 69 | 2013-02-17T00:00:00.000 | 2 | 1 | 51 | 0 | 58 | 3 | 1 | 2 |
| 201307 | 2 | 69 | 2013-02-17T00:00:00.000 | 2 | 1 | 51 | 0 | 58 | 3 | 1 | 1 |
Showing 12 of 48 columns. All of them are listed below.
| — |
| 0% |
234of 5 |
v_gender | categorical | — | 0% | 10of 2 |
v_age | integer | — | 0% | 263319 |
p_gender | categorical | — | 0% | 01of 2 |
p_age | integer | — | 0% | 254330 |
relationship | categorical | — | 0% | 136of 5 |
method | categorical | — | 0% | 134of 4 |
news | categorical | — | 0% | 125of 8 |
word_count | integer | — | 0% | 291151113 |
pub_date | datetime | — | 0% | 2014-01-30T00:00:00.0002016-02-14T00:00:00.0002016-01-04T00:00:00.000 |
mos | categorical | — | 0% | 01of 2 |
s_puboff | categorical | — | 0% | 01of 2 |
s_puboff_no | categorical | — | 0% | 99912of 5 |
s_puboff_cat | categorical | — | 0% | 99921of 19 |
s_neigh | categorical | — | 0% | 01of 2 |
s_neigh_no | categorical | — | 0% | 99912of 4 |
s_neigh_cat | categorical | — | 0% | 99931of 4 |
s_fam | categorical | — | 0% | 01of 2 |
s_fam_no | categorical | — | 0% | 99912of 5 |
s_fam_cat | categorical | — | 0% | 99921of 6 |
s_dv | categorical | — | 0% | 01of 2 |
s_dv_no | categorical | — | 0% | 99912of 3 |
s_dv_cat | categorical | — | 0% | 99952.3of 6 |
s_add | categorical | — | 0% | 01of 2 |
s_add_no | categorical | — | 0% | 99912of 5 |
s_add_cat | categorical | — | 0% | 99912of 15 |
no_s | categorical | — | 0% | 01of 2 |
c_dv | categorical | — | 0% | 01of 2 |
c_dv_hom | categorical | — | 0% | 01of 2 |
c_relation | categorical | — | 0% | 10of 2 |
c_policeframe | categorical | — | 0% | 01of 2 |
c_history | categorical | — | 0% | 01of 2 |
c_highrisk | categorical | — | 0% | 10of 2 |
c_broaddv | categorical | — | 0% | 01of 2 |
c_solution | categorical | — | 0% | 01of 2 |
c_dvresource | categorical | — | 0% | 01of 2 |
c_dvresource_cat | categorical | — | 0% | 99912of 4 |
l_vicblam | categorical | — | 0% | 01of 2 |
l_sexual | categorical | — | 0% | 01of 2 |
l_normal | categorical | — | 0% | 01of 2 |
l_other | categorical | — | 0% | 01of 2 |
l_sensation | categorical | — | 0% | 01of 2 |
l_minimize | categorical | — | 0% | 01of 2 |
k_isolate | categorical | — | 0% | 01of 2 |