Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2021 · 89,979
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
1451715 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 2021   grade_3 0.0 50.0 4.0               3.0   20.0 37.0             53         57 0 50 4               3   20 37         53       57
1451716 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 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
1451717 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 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
1451718 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 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
1451719 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 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
1451720 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 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
1451721 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 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
1451722 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 2021   kindergarten_full_day 1.0 47.0 4.0               2.0   32.0 22.0             41         54 1 47 4               2   32 22         41       54
1451723 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 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
1451724 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 2021   pk_12_total 2.0 203.0 13.0               8.0   102.0 124.0             198         226 2 203 13               8   102 124         198       226
1451725 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 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
1451726 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 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
1451727 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 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
1451728 NY Erie   school 3601172 140600861134   PERSISTENCE PREP ACADEMY CHA 360117206648 140600861134 PERSISTENCE PREP ACADEMY CHARTER SCH charter Regular School Yes Elementary KG 03 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
1451729 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451730 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451731 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451732 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451733 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451734 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451735 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451736 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 2021   grade_5 1.0 28.0 4.0   1.0     0.0     2.0   14.0 22.0                       36 1 28 4   1     0     2   14 22                 36
1451737 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 2021   grade_6 3.0 21.0 3.0   0.0     1.0     2.0   15.0 15.0                       30 3 21 3   0     1     2   15 15                 30
1451738 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451739 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451740 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451741 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451742 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451743 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 2021   pk_12_total 4.0 49.0 7.0   1.0     1.0     4.0   29.0 37.0                       66 4 49 7   1     1     4   29 37                 66
1451744 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451745 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451746 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451747 NY Erie   school 3601215 140600861183   BUFFALO CREEK ACADEMY CHARTE 360121506708 140600861183 BUFFALO CREEK ACADEMY CHARTER SCHOOL charter Regular School Yes Middle 05 06 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
1451767 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_1 68.0 53.0 11.0   1.0     12.0     12.0   83.0 74.0     15       110         157 68 53 11   1     12     12   83 74     15   110       157
1451768 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1451769 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1451770 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1451771 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_2 54.0 58.0 10.0   0.0     14.0     13.0   72.0 77.0     18       111         149 54 58 10   0     14     13   72 77     18   111       149
1451772 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_3 56.0 51.0 16.0   0.0     18.0     25.0   85.0 81.0     19       117         166 56 51 16   0     18     25   85 81     19   117       166
1451773 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_4 59.0 64.0 17.0   0.0     15.0     12.0   85.0 82.0     21       127         167 59 64 17   0     15     12   85 82     21   127       167
1451774 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1451775 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1451776 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1451777 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1451778 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1451779 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   kindergarten_full_day 63.0 46.0 11.0   0.0     25.0     18.0   82.0 81.0     *       103         163 63 46 11   0     25     18   82 81         103       163
1451780 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1451781 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   pk_12_total 333.0 301.0 71.0   1.0     104.0     86.0   451.0 445.0     110       617         896 333 301 71   1     104     86   451 445     110   617       896
1451782 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   pre_kindergarten_full_day 33.0 29.0 6.0   0.0     19.0     6.0   43.0 50.0     22       *         93 33 29 6   0     19     6   43 50     22           93
1451783 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1451784 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   ungraded_elementary 0.0 0.0 0.0   0.0     1.0     0.0   1.0 0.0     *       *         1 0 0 0   0     1     0   1 0                 1
1451785 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 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
1451805 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451806 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451807 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451808 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451809 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451810 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451811 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451812 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_5 60.0 46.0 20.0   1.0     16.0     15.0   74.0 84.0     19       113         158 60 46 20   1     16     15   74 84     19   113       158
1451813 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_6 51.0 45.0 14.0   0.0     13.0     10.0   74.0 59.0     *       88         133 51 45 14   0     13     10   74 59         88       133
1451814 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_7 46.0 64.0 20.0   1.0     9.0     10.0   73.0 77.0     14       111         150 46 64 20   1     9     10   73 77     14   111       150
1451815 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 2021   grade_8 72.0 70.0 23.0   1.0     10.0     7.0   106.0 77.0     11       121         183 72 70 23   1     10     7   106 77     11   121       183
1451816 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451817 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451818 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451819 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 2021   pk_12_total 235.0 228.0 77.0   3.0     49.0     42.0   335.0 299.0     52       443         634 235 228 77   3     49     42   335 299     52   443       634
1451820 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451821 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 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
1451822 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 2021   ungraded_elementary 3.0 1.0 0.0   0.0     1.0     0.0   4.0 1.0     0       5         5 3 1 0   0     1     0   4 1     0   5       5
1451823 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723005572 140701060007 CHEEKTOWAGA MIDDLE SCHOOL public Regular School No Middle 05 08 2021   ungraded_secondary 3.0 2.0 0.0   0.0     0.0     0.0   4.0 1.0     *       5         5 3 2 0   0     0     0   4 1         5       5
1453002 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_1 53.0 12.0 7.0   0.0     0.0     0.0   35.0 37.0     12       52         72 53 12 7   0     0     0   35 37     12   52       72
1453003 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_10 47.0 23.0 4.0   0.0     0.0     2.0   31.0 45.0     *       49         76 47 23 4   0     0     2   31 45         49       76
1453004 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_11 45.0 13.0 9.0   0.0     1.0     1.0   21.0 48.0     6       45         69 45 13 9   0     1     1   21 48     6   45       69
1453005 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_12 37.0 20.0 10.0   0.0     1.0     1.0   37.0 32.0     *       48         69 37 20 10   0     1     1   37 32         48       69
1453006 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_2 55.0 10.0 7.0   1.0     2.0     0.0   39.0 36.0     12       53         75 55 10 7   1     2     0   39 36     12   53       75
1453007 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_3 56.0 15.0 0.0   0.0     2.0     1.0   38.0 36.0     9       49         74 56 15 0   0     2     1   38 36     9   49       74
1453008 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_4 56.0 11.0 8.0   0.0     0.0     0.0   45.0 30.0     14       49         75 56 11 8   0     0     0   45 30     14   49       75
1453009 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_5 49.0 20.0 4.0   1.0     0.0     0.0   37.0 37.0     10       53         74 49 20 4   1     0     0   37 37     10   53       74
1453010 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_6 51.0 14.0 6.0   0.0     0.0     0.0   34.0 37.0     5       44         71 51 14 6   0     0     0   34 37     5   44       71
1453011 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_7 54.0 13.0 7.0   0.0     1.0     0.0   31.0 44.0     13       48         75 54 13 7   0     1     0   31 44     13   48       75
1453012 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_8 47.0 17.0 6.0   0.0     2.0     1.0   32.0 41.0     7       50         73 47 17 6   0     2     1   32 41     7   50       73
1453013 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_9 51.0 19.0 3.0   0.0     0.0     1.0   39.0 35.0     9       70         74 51 19 3   0     0     1   39 35     9   70       74
1453014 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   kindergarten_full_day 51.0 13.0 5.0   1.0     0.0     0.0   33.0 37.0     *       44         70 51 13 5   1     0     0   33 37         44       70
1453015 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 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
1453016 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   pk_12_total 652.0 200.0 76.0   3.0     9.0     7.0   452.0 495.0     103       654         947 652 200 76   3     9     7   452 495     103   654       947
1453017 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 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
1453018 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 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
1453019 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 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
1453020 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 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
1454275 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2021   grade_1 18.0                       9.0 9.0             9         18 18                       9 9         9       18
1454276 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2021   grade_10 0.0                       0.0 0.0             0         0 0                       0 0         0       0
1454277 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2021   grade_11 0.0                       0.0 0.0             0         0 0                       0 0         0       0
1454278 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2021   grade_12 0.0                       0.0 0.0             0         0 0                       0 0         0       0
1454279 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2021   grade_2 12.0                       7.0 5.0             *         12 12                       7 5                 12
1454280 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2021   grade_3 16.0                       6.0 10.0             7         16 16                       6 10         7       16
1454281 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2021   grade_4 17.0                       10.0 7.0             8         17 17                       10 7         8       17
1454282 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2021   grade_5 17.0                       5.0 12.0             6         17 17                       5 12         6       17
1454283 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2021   grade_6 0.0                       0.0 0.0             0         0 0                       0 0         0       0
1454284 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2021   grade_7 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]);