2020-21 Guidance Counselor/Social Worker Data - Demographic, Post Secondary

yphg-6fugEducation25 columns

New York City Department of Education 2020-21 Guidance Counselor and Social Workers data by district, borough, school number, school name, and school level, providing statistics for full time, part time, bilingual guidance counselors and social workers and whether they are serving more than one location.

View on NYC Open Data

Quality

B81.1 / 100

From a 500-row sample across 25 columns.

completeness100/ 25% weight

consistency70/ 20% weight

accuracy97/ 20% weight

timeliness37/ 15% weight

usability85/ 20% weight

· No obvious temporal column — limits time-series joins

Related datasets

2020 DOE Gifted and Talented Admissions Guide0.38
joins ondbn
2018-2019 School Demographic Snapshot0.37
joins ondbn
2020 DOE Kindergarten Admissions Guide0.35
joins ondbn
2021 DOE Kindergarten Admissions Guide0.35
joins ondbn
2014-15 to 2017-19 NYC Regents Exam Results - Public0.35
Borough Enrollment Offices0.34

Sample rows

dbn	school_information_school	location_type	total_guidance_counselors	total_gc	total_sw	counts_by_role_specificaiton	counts_by_role_specification	count_by_role_specification	count_by_role_specification_1	additional_role_specifications	additional_role_specifications_1
01M015	P.S. 015 Roberto Clemente	ELEMENTARY	1.0	0.0	1.0	0.0	1.0	0.0	0.0	0.0

Columns

25 queryable · 25 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`dbn`	text	—	0%	`28Q17526Q49517K705`
`school_information_school`	text	—	0%	`P.S. 253P.S. 376P.S. 360`
`location_type`	categorical	—	0%	`ELEMENTARYHIGH SCHOOLJUNIOR HIGH-INTERMEDIATE…`of 10
`total_guidance_counselors`	coordinate	—	0%	`2.01.03.0`

Query this from your own app

GET /api/datasets/yphg-6fug
GET /api/datasets/yphg-6fug/quality
GET /api/datasets/yphg-6fug/related
GET /api/columns?dataset=yphg-6fug