2018-19 Guidance Counselor Report - Social Worker

2mvk-c2haEducation18 columns

New York City Department of Education 2018 - 19 Guidance Counselor Bill Demographic Data by district, borough, school number, school name, and school level, providing statistics for full time, part time, bilingual social workers and if they are serving more than one location.

View on NYC Open Data

Quality

B82.0 / 100

From a 500-row sample across 18 columns.

completeness92/ 25% weight

consistency69/ 20% weight

accuracy97/ 20% weight

timeliness38/ 15% weight

usability100/ 20% weight

· Has geographic keys — joinable to other NYC datasets

Related datasets

2018-19 Guidance Counselor Report - Guidance Counselor0.71
joins on_2017_18_sy_enrollmentlearning_to_work_programtotal_guidance_counselor+8
2020-21 Guidance Counselor/Social Worker Data - Demographic, Post Secondary0.57
joins onlocation_typetotal_swdbn
2014 - 15 Guidance Counselor Data0.44
joins onlocation_typedbnratio_gc_sw+1
2014 - 15 Guidance Counselor Reporting - Social Worker Data0.43
joins onlocation_typetotal_swdbn

Sample rows

dbn	location	location_type	total_guidance_counselor	total_sw	atr_total_gc_sw	atr_total_sw	full_time_sw	part_time_sw	bilingual_sw	sw_serving_more_than_one	single_shepherd
01M015	01M015 - P.S. 015 ROBERTO CLEMENTE	Elementary	1	0	0	0	0	0	0	0	NA
01M019

Columns

18 queryable · 18 profiled

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%	`75Q009 - P.S. 00922K119 - P.S. 119 AMERSF…27Q323 - SCHOLARS' ACADE…`
`location_type`	categorical	—	0%	`ElementaryHigh schoolJunior High-Intermediate…`of 12
`total_guidance_counselor`	text	—	0%	`213`

Query this from your own app

GET /api/datasets/2mvk-c2ha
GET /api/datasets/2mvk-c2ha/quality
GET /api/datasets/2mvk-c2ha/related
GET /api/columns?dataset=2mvk-c2ha