From a 500-row sample across 9 columns.
| generic_qid | qtext | selected_choice | valid_submissions | option_weight | cross_qid | cross_analysis_category | cross_analysis_weight | cross_analyzed_respondent |
|---|---|---|---|---|---|---|---|---|
| 1069 | Which category best represents your household's total income over the past year?-1069 | Prefer_not_to_say | 648 | 0.0881287 | 1069 | income_group: $150,000 or more | — | — |
| 1069 | Which category best represents your household's total income over the past year?-1069 | _100_000_124_999 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
generic_qid | text | Number assigned to each different question. | 0% | 492110694918 |
qtext | text | The full text of the question respondents answered in the survey. | 0% | Which communities in %cl…Have any of the followin…Which category best repr… |
selected_choice | text | The option respondents selected per question asked. | 2% | OtherI_don_t_knowPrefer_not_to_say |
valid_submissions | integer | Total number of completed responses for the given question. |
GET /api/datasets/irna-apch GET /api/datasets/irna-apch/quality GET /api/datasets/irna-apch/related GET /api/columns?dataset=irna-apch
| 537 |
| 0.0671825 |
| 1069 |
| income_group: $150,000 or more |
| — |
| — |
| 1069 | Which category best represents your household's total income over the past year?-1069 | _125_000_149_999 | 394 | 0.0485364 | 1069 | income_group: $150,000 or more | — | — |
| 1069 | Which category best represents your household's total income over the past year?-1069 | _14_999_or_less | 1343 | 0.1534844 | 1069 | income_group: $150,000 or more | — | — |
| 1069 | Which category best represents your household's total income over the past year?-1069 | _150_000_199_999 | 349 | 0.0469562 | 1069 | income_group: $150,000 or more | 1 | 349 |
| 1069 | Which category best represents your household's total income over the past year?-1069 | _15_000_29_999 | 1078 | 0.1273302 | 1069 | income_group: $150,000 or more | — | — |
| 1069 | Which category best represents your household's total income over the past year?-1069 | _200_000_299_999 | 306 | 0.037948 | 1069 | income_group: $150,000 or more | — | — |
| 1069 | Which category best represents your household's total income over the past year?-1069 | _300_000_or_more | 216 | 0.0266508 | 1069 | income_group: $150,000 or more | — | — |
| 1069 | Which category best represents your household's total income over the past year?-1069 | _30_000_49_999 | 1139 | 0.1392359 | 1069 | income_group: $150,000 or more | — | — |
| 1069 | Which category best represents your household's total income over the past year?-1069 | _50_000_74_999 | 1276 | 0.1552609 | 1069 | income_group: $150,000 or more | — | — |
| 0% |
92861276 |
option_weight | float | A technique called "rake weighting" was used to ensure the sample of responses was representative of the New York City community. This process is a statistical safeguard to prevent any demographic group from being overrepresented or underrepresented. (See data dictionary notes for more detail)) | 0% | 0.08575190.23059570.2427475 |
cross_qid | text | Number assigned to each different question. These are the same as generic question ID. | 0% | 106949214909 |
cross_analysis_category | text | This is the question that is combined with other demographic data provided from a respondent. | 0% | polygon_College_PointWhich borough do you/did…polygon_Elmhurst |
cross_analysis_weight | float | A calculation applied to the question that balances demographics for representation comparable to the demographics of residents in New York City. | 11% | 10.15164920.171465 |
cross_analyzed_respondent | integer | The number of people within the selected demographic or comparison group who answered the question in this particular way. | 11% | 123 |