Data source: Big Local News · About: Big Local

90,079 rows where state = "NY" and year = 2021 sorted by ccd_school_type

View and edit SQL

year

  • 2021 · 90,079
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
1456650 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   grade_1 0.0 36.0 4.0   0.0     0.0     1.0   18.0 23.0     *       27     *   41 0 36 4   0     0     1   18 23         27       41
1456651 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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     0   0   0   0
1456652 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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     0   0   0   0
1456653 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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     0   0   0   0
1456654 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   grade_2 0.0 40.0 0.0   0.0     0.0     0.0   21.0 19.0     0       33     6   40 0 40 0   0     0     0   21 19     0   33   6   40
1456655 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   grade_3 4.0 48.0 3.0   2.0     0.0     1.0   24.0 34.0     *       44     13   58 4 48 3   2     0     1   24 34         44   13   58
1456656 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   grade_4 0.0 55.0 6.0   1.0     2.0     0.0   36.0 28.0     *       52     15   64 0 55 6   1     2     0   36 28         52   15   64
1456657 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   grade_5 0.0 48.0 7.0   0.0     0.0     0.0   25.0 30.0     *       37     6   55 0 48 7   0     0     0   25 30         37   6   55
1456658 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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 0     0   0   0   0
1456659 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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 0     0   0   0   0
1456660 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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 0     0   0   0   0
1456661 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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     0   0   0   0
1456662 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   kindergarten_full_day 1.0 21.0 7.0   0.0     0.0     0.0   9.0 20.0     *       20     *   29 1 21 7   0     0     0   9 20         20       29
1456663 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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     0   0   0   0
1456664 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   pk_12_total 5.0 248.0 27.0   3.0     2.0     2.0   133.0 154.0     8       213     45   287 5 248 27   3     2     2   133 154     8   213   45   287
1456665 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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     0   0   0   0
1456666 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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     0   0   0   0
1456667 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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 0     0   0   0   0
1456668 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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     0   0   0   0
1444547 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_1         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444548 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_10         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444549 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_11         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444550 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_12         2.0           1.0   2.0 1.0             *     *   3         2           1   2 1                 3
1444551 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_2         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444552 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_3         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444553 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_4         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444554 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_5         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444555 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_6         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444556 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_7         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444557 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_8         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444558 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   grade_9         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444559 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   kindergarten_full_day         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444560 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   kindergarten_half_day         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444561 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   pk_12_total         2.0           1.0   2.0 1.0             *     *   3         2           1   2 1                 3
1444562 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   pre_kindergarten_full_day         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444563 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   pre_kindergarten_half_day         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444564 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   ungraded_elementary         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1444565 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2021   ungraded_secondary         0.0           0.0   0.0 0.0             *     *   0         0           0   0 0                 0
1449639 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449640 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   grade_10 8.0 0.0 1.0         1.0     0.0   5.0 5.0             *     6   10 8 0 1         1     0   5 5             6   10
1449641 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   grade_11 9.0 0.0 2.0         0.0     1.0   6.0 6.0             *     *   12 9 0 2         0     1   6 6                 12
1449642 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   grade_12 18.0 2.0 4.0         0.0     1.0   16.0 9.0             17     9   25 18 2 4         0     1   16 9         17   9   25
1449643 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449644 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449645 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449646 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449647 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449648 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449649 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449650 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   grade_9 5.0 0.0 1.0         0.0     0.0   2.0 4.0             *     *   6 5 0 1         0     0   2 4                 6
1449651 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449652 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449653 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   pk_12_total 40.0 2.0 8.0         1.0     2.0   29.0 24.0             27     22   53 40 2 8         1     2   29 24         27   22   53
1449654 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449655 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449656 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1449657 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2021   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
1451159 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451160 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   grade_10 1.0 23.0 2.0               1.0   13.0 14.0     *       26     12   27 1 23 2               1   13 14         26   12   27
1451161 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   grade_11 2.0 14.0 1.0               4.0   11.0 10.0     *       17     *   21 2 14 1               4   11 10         17       21
1451162 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   grade_12 1.0 15.0 3.0               1.0   12.0 8.0     *       18     8   20 1 15 3               1   12 8         18   8   20
1451163 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451164 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451165 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451166 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451167 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451168 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451169 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   grade_8 2.0 8.0 0.0               0.0   4.0 6.0     *       *     0   10 2 8 0               0   4 6             0   10
1451170 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   grade_9 3.0 33.0 15.0               2.0   29.0 24.0     *       51     13   53 3 33 15               2   29 24         51   13   53
1451171 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451172 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451173 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   pk_12_total 9.0 94.0 24.0               8.0   72.0 63.0     *       126     41   135 9 94 24               8   72 63         126   41   135
1451174 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451175 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451176 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   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
1451177 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2021   ungraded_secondary 0.0 1.0 3.0               0.0   3.0 1.0     *       *     *   4 0 1 3               0   3 1                 4
1451387 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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     0   0   0   0
1451388 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   grade_10 10.0 26.0 7.0   1.0     3.0     1.0   29.0 19.0     *       41     23   48 10 26 7   1     3     1   29 19         41   23   48
1451389 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   grade_11 5.0 23.0 8.0   1.0     1.0     2.0   21.0 19.0     *       36     13   40 5 23 8   1     1     2   21 19         36   13   40
1451390 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   grade_12 15.0 57.0 18.0   1.0     3.0     1.0   50.0 45.0     7       76     28   95 15 57 18   1     3     1   50 45     7   76   28   95
1451391 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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     0   0   0   0
1451392 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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     0   0   0   0
1451393 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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     0   0   0   0
1451394 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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 0     0   0   0   0
1451395 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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 0     0   0   0   0
1451396 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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 0     0   0   0   0
1451397 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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 0     0   0   0   0
1451398 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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     0   0   0   0
1451399 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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     0   0   0   0
1451400 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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     0   0   0   0
1451401 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   pk_12_total 30.0 106.0 33.0   3.0     7.0     4.0   100.0 83.0     13       153     64   183 30 106 33   3     7     4   100 83     13   153   64   183
1451402 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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     0   0   0   0
1451403 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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     0   0   0   0
1451404 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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 0     0   0   0   0
1451405 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2021   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     0   0   0   0
1459538 NY Kings   school 3601061 331500861016   NEW DAWN CHARTER HIGH SCHOOL 360106106343 331500861016 NEW DAWN CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2021   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   0
1459539 NY Kings   school 3601061 331500861016   NEW DAWN CHARTER HIGH SCHOOL 360106106343 331500861016 NEW DAWN CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2021   grade_10 0.0 32.0 25.0   2.0     3.0         37.0 25.0     7       51     24   62 0 32 25   2     3         37 25     7   51   24   62
1459540 NY Kings   school 3601061 331500861016   NEW DAWN CHARTER HIGH SCHOOL 360106106343 331500861016 NEW DAWN CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2021   grade_11 4.0 62.0 32.0   2.0     2.0         53.0 49.0     6       88     41   102 4 62 32   2     2         53 49     6   88   41   102
1459541 NY Kings   school 3601061 331500861016   NEW DAWN CHARTER HIGH SCHOOL 360106106343 331500861016 NEW DAWN CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2021   grade_12 1.0 33.0 13.0   0.0     0.0         31.0 16.0     *       41     22   47 1 33 13   0     0         31 16         41   22   47
1459542 NY Kings   school 3601061 331500861016   NEW DAWN CHARTER HIGH SCHOOL 360106106343 331500861016 NEW DAWN CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2021   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   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]);