Mayor’s Office of Operations: Demographic Survey

tap2-dwrwCity Government11 columns

Pursuant to Local Laws 126, 127, and 128 of 2016, certain demographic data is collected voluntarily and anonymously by persons voluntarily seeking social services. This data can be used by agencies and the public to better understand the demographic makeup of client populations and to better understand and serve residents of all backgrounds and identities. The data presented here has been collected through either electronic form or paper surveys offered at the point of application for services. These surveys are anonymous. Each record represents an anonymized demographic profile of an individual applicant for social services, disaggregated by response option, agency, and program. Response options include information regarding ancestry, race, primary and secondary languages, English proficiency, gender identity, and sexual orientation. Idiosyncrasies or Limitations: Note that while the dataset contains the total number of individuals who have identified their ancestry or languages spoke, because such data is collected anonymously, there may be instances of a single individual completing multiple voluntary surveys. Additionally, the survey being both voluntary and anonymous has advantages as well as disadvantages: it increases the likelihood of full and honest answers, but since it is not connected to the individual case, it does not directly inform delivery of services to the applicant. The paper and online versions of the survey ask the same questions but free-form text is handled differently. Free-form text fields are expected to be entered in English although the form is available in several languages. Surveys are presented in 11 languages. Paper Surveys 1. Are optional 2. Survey taker is expected to specify agency that provides service 2. Survey taker can skip or elect not to answer questions 3. Invalid/unreadable data may be entered for survey date or date may be skipped 4. OCRing of free-form tet fields may fail. 5. Analytical value of free-form text answers is unclear Online Survey 1. Are optional 2. Agency is defaulted based on the URL 3. Some questions must be answered 4. Date of survey is automated

View on NYC Open Data

Quality

A91.3 / 100

From a 500-row sample across 11 columns.

completeness98/ 25% weight

consistency77/ 20% weight

accuracy97/ 20% weight

timeliness99/ 15% weight

usability85/ 20% weight

· No obvious temporal column — limits time-series joins

Related datasets

NYC Permitted Event Information0.28
Civil Service List (Terminated)0.28
DSNY Monthly Tonnage Data0.28
NYC Civil Service Titles0.28
2020 Census Tracts0.28
2020 Neighborhood Tabulation Areas (NTAs)0.27
Self Hauler Registrants0.27
Film Permits0.27

Sample rows

id	survey_number	survey_instance_id	survey_status	survey_language	dt_submitted	question	answer	answer_is_optional	data_source	create_dt
86483	55	90002903	Complete	English	2019-01-23T00:00:00.000	How would you describe your gender?	Female	false	Paper	2019-01-23T00:00:00.000
128139	50003666	3472

Columns

11 queryable · 11 profiled

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

Field	Type	Description	Null	Values
`id`	integer	Primary Key	0%	`120711120721120704`
`survey_number`	integer	A number unique to each version of a survey; When analyzing the results, consider that rows with different survey_numbers may have different sets of questions and answers.	0%	`50003666101121`
`survey_instance_id`	integer	A number that links all rows of a returned survey.; Results are stored in a columnar fashion. Group by survey_instance_id to get all the Q/A pairs for a given instance of a survey.	0%	`40241517227725`
`survey_status`	categorical	Indicates that on-line survey has been finalized. ; Complete or Incomplete	0%

Query this from your own app

GET /api/datasets/tap2-dwrw
GET /api/datasets/tap2-dwrw/quality
GET /api/datasets/tap2-dwrw/related
GET /api/columns?dataset=tap2-dwrw