Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2017 sorted by disability

View and edit SQL

year

  • 2017 · 89,718
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability ▼ section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
942377 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942378 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_10 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942379 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_11 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942380 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_12 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942381 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942382 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_3 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942383 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942384 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_5 4.0 90.0 3.0   0.0     2.0     0.0   43.0 56.0             74         99 4 90 3   0     2     0   43 56         74       99
942385 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_6 3.0 87.0 9.0   1.0     1.0     1.0   47.0 55.0             76         102 3 87 9   1     1     1   47 55         76       102
942386 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_7 4.0 51.0 6.0   1.0     1.0     1.0   31.0 33.0             41         64 4 51 6   1     1     1   31 33         41       64
942387 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_8 1.0 38.0 6.0   2.0     0.0     1.0   17.0 31.0             23         48 1 38 6   2     0     1   17 31         23       48
942388 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942389 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   kindergarten_full_day 3.0 69.0 12.0   0.0     4.0     3.0   41.0 50.0             0         91 3 69 12   0     4     3   41 50         0       91
942390 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942391 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   pk_12_total 16.0 344.0 37.0   4.0     8.0     6.0   186.0 229.0             214         415 16 344 37   4     8     6   186 229         214       415
942392 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942393 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942394 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   ungraded_elementary 1.0 9.0 1.0   0.0     0.0     0.0   7.0 4.0             0         11 1 9 1   0     0     0   7 4         0       11
942395 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   ungraded_secondary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
942396 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_1 0.0 72.0 9.0   1.0     0.0         44.0 38.0     *       76         82 0 72 9   1     0         44 38         76       82
942397 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_10 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942398 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_11 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942399 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_12 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942400 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_2 1.0 76.0 6.0   0.0     0.0         45.0 38.0     *       73         83 1 76 6   0     0         45 38         73       83
942401 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_3 0.0 75.0 9.0   1.0     1.0         37.0 49.0     0       78         86 0 75 9   1     1         37 49     0   78       86
942402 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_4 1.0 62.0 6.0   0.0     0.0         31.0 38.0     *       57         69 1 62 6   0     0         31 38         57       69
942403 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_5 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942404 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_6 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942405 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_7 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942406 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_8 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942407 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942408 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   kindergarten_full_day 0.0 47.0 13.0   0.0     0.0         35.0 25.0     *       51         60 0 47 13   0     0         35 25         51       60
942409 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942410 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   pk_12_total 2.0 332.0 43.0   2.0     1.0         192.0 188.0     7       335         380 2 332 43   2     1         192 188     7   335       380
942411 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942412 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942413 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   ungraded_elementary 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
942414 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   ungraded_secondary 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989801 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989802 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 11.0 9.0 29.0   1.0     47.0         61.0 36.0     84       90         97 11 9 29   1     47         61 36     84   90       97
989803 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_11 4.0 2.0 6.0   1.0     47.0         29.0 31.0     *       56         60 4 2 6   1     47         29 31         56       60
989804 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_12 1.0 3.0 0.0   0.0     7.0         5.0 6.0     *       11         11 1 3 0   0     7         5 6         11       11
989805 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989806 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_3 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989807 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989808 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_5 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989809 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_6 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989810 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989811 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_8 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989812 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 5.0 6.0 52.0   2.0     42.0         61.0 46.0     106       104         107 5 6 52   2     42         61 46     106   104       107
989813 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989814 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989815 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 21.0 20.0 87.0   4.0     143.0         156.0 119.0     223       261         275 21 20 87   4     143         156 119     223   261       275
989816 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989817 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989818 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   ungraded_elementary 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
989819 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No High 09 12 2017   ungraded_secondary 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1000783 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_1 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000784 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_10 2.0 6.0 14.0                   14.0 8.0     *                 22 2 6 14                   14 8                 22
1000785 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_11 3.0 3.0 5.0                   3.0 8.0     *                 11 3 3 5                   3 8                 11
1000786 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_12 5.0 10.0 8.0                   14.0 9.0     *                 23 5 10 8                   14 9                 23
1000787 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_2 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000788 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_3 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000789 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_4 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000790 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_5 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000791 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_6 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000792 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_7 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000793 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_8 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000794 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_9 0.0 4.0 5.0                   5.0 4.0     *                 9 0 4 5                   5 4                 9
1000795 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   kindergarten_full_day 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000796 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   kindergarten_half_day 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000797 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   pk_12_total 10.0 23.0 32.0                   36.0 29.0     *                 65 10 23 32                   36 29                 65
1000798 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   pre_kindergarten_full_day 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000799 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   pre_kindergarten_half_day 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000800 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   ungraded_elementary 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1000801 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   ungraded_secondary 0.0 0.0 0.0                   0.0 0.0     *                 0 0 0 0                   0 0                 0
1009219 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009220 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_10 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009221 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_11 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009222 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_12 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009223 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009224 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_3 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009225 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009226 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_5 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009227 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_6 5.0 0.0 16.0   0.0     6.0         13.0 14.0     27       25         27 5 0 16   0     6         13 14     27   25       27
1009228 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_7 7.0 1.0 27.0   0.0     10.0         25.0 20.0     45       44         45 7 1 27   0     10         25 20     45   44       45
1009229 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_8 11.0 0.0 49.0   1.0     7.0         30.0 38.0     67       64         68 11 0 49   1     7         30 38     67   64       68
1009230 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009231 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009232 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009233 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   pk_12_total 23.0 1.0 92.0   1.0     23.0         68.0 72.0     139       133         140 23 1 92   1     23         68 72     139   133       140
1009234 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009235 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009236 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1009237 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202535 343000010235 ACADEMY FOR NEW AMERICANS public Regular School No Middle 06 08 2017   ungraded_secondary 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
1016249 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2017   grade_1 0.0 0.0                     0.0 0.0             0         0 0 0                     0 0         0       0
1016250 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2017   grade_10 0.0 0.0                     0.0 0.0             0         0 0 0                     0 0         0       0
1016251 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2017   grade_11 2.0 0.0                     2.0 0.0             *         2 2 0                     2 0                 2
1016252 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2017   grade_12 24.0 2.0                     8.0 18.0             *         26 24 2                     8 18                 26
1016253 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2017   grade_2 0.0 0.0                     0.0 0.0             0         0 0 0                     0 0         0       0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);