From a 500-row sample across 18 columns.
community_school_cbo_partnernotessingle_shepherd+8total_gcdbnlocation_typedbntotal_gcdbnlocation+4| dbn | location | location_type | total_guidance_counselor | total_gc | atr_total_gc_sw | atr_total_gc | full_time_gc | part_time_gc | bilingual_gc | serving_more_than_one_location | single_shepherd |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 01M015 | 01M015 - P.S. 015 ROBERTO CLEMENTE | Elementary | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | NA |
| 01M019 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
dbn | text | — | 0% | 28Q17526Q49517K705 |
location | text | — | 0% | 02M126 - P.S. 126 JACOB …75Q009 - P.S. 00922K119 - P.S. 119 AMERSF… |
location_type | categorical | — | 0% | ElementaryHigh schoolJunior High-Intermediate…of 12 |
total_guidance_counselor | text | — | 0% | 213 |
GET /api/datasets/khci-nhn2 GET /api/datasets/khci-nhn2/quality GET /api/datasets/khci-nhn2/related GET /api/columns?dataset=khci-nhn2
total_gcdbnlocation_type+3dbndbntotal_gcdbnlocation+4| 01M019 - P.S. 019 ASHER LEVY |
| Elementary |
| 2 |
| 1 |
| 0 |
| 0 |
| 1 |
| 0 |
| 0 |
| 0 |
| NA |
| 01M020 | 01M020 - P.S. 020 ANNA SILVER | Elementary | 1.6 | 0.6 | 0 | 0 | 0 | 0.6 | 0 | 0.6 | NA |
| 01M034 | 01M034 - P.S. 034 FRANKLIN D. ROOSEVELT | K-8 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | NA |
| 01M063 | 01M063 - THE STAR ACADEMY - P.S.63 | Elementary | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | NA |
| 01M064 | 01M064 - P.S. 064 ROBERT SIMON | Elementary | 1.6 | 0.6 | 0 | 0 | 0 | 0.6 | 0 | 0.6 | NA |
| 01M110 | 01M110 - P.S. 110 FLORENCE NIGHTINGALE | Elementary | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | NA |
| 01M134 | 01M134 - P.S. 134 HENRIETTA SZOLD | Elementary | 3 | 2 | 1 | 1 | 2 | 0 | 0 | 0 | NA |
| 01M140 | 01M140 - P.S. 140 NATHAN STRAUS | K-8 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | NA |
| 01M142 | 01M142 - P.S. 142 AMALIA CASTRO | Elementary | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NA |
Showing 12 of 17 columns. All of them are listed below.
total_gc |
| float |
| — |
| 0% |
123 |
atr_total_gc_sw | categorical | — | 0% | 012of 5 |
atr_total_gc | categorical | — | 0% | 012of 4 |
full_time_gc | integer | — | 0% | 120 |
part_time_gc | categorical | — | 0% | 00.60.4of 17 |
bilingual_gc | categorical | — | 0% | 012of 7 |
serving_more_than_one_location | categorical | — | 0% | 00.60.4of 11 |
notes | categorical | — | 99% | Has counseling service (…In process (interviewing…Has counseling service (…of 9 |
single_shepherd | categorical | — | 0% | NASingle Shepherdof 2 |
learning_to_work_program | categorical | — | 0% | NALearning to Workof 2 |
community_school_cbo_partner | text | — | 0% | NANew York City Community …The Leadership Program |
_2017_18_sy_enrollment | integer | — | 0% | 395439457 |
ratio_gc_sw | integer | — | 1% | 229101170 |
ratio_gc_only | integer | — | 7% | 165239201 |