enrollments

Data source: Big Local News · About: Big Local

89,661 rows where state = "NY" and year = 2019 sorted by ccd_school_lvl descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 89,661 ✖
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
2156364 2156364 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156365 2156365 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156366 2156366 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156367 2156367 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156368 2156368 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156369 2156369 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156370 2156370 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156371 2156371 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156372 2156372 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156373 2156373 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156374 2156374 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156375 2156375 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156376 2156376 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156377 2156377 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156378 2156378 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   pk_12_total 11.0 40.0 20.0   1.0     4.0     1.0   48.0 29.0     *       *     *   77 11 40 20   1     4     1   48 29                 77
2156379 2156379 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156380 2156380 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156381 2156381 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   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
2156382 2156382 NY Erie   school 3605850 140600010000   BUFFALO 360585000338 140600010042 PS 42 OCCUPATIONAL TRAINING CTR public Special Education School No Ungraded UG UG 2019   ungraded_secondary 11.0 40.0 20.0   1.0     4.0     1.0   48.0 29.0     *       *     *   77 11 40 20   1     4     1   48 29                 77
2141905 2141905 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141906 2141906 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   grade_10 0.0 38.0 66.0   0.0           1.0   52.0 53.0     10       83     29   105 0 38 66   0           1   52 53     10   83   29   105
2141907 2141907 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   grade_11 0.0 34.0 68.0   0.0           1.0   48.0 55.0     7       82     *   103 0 34 68   0           1   48 55     7   82       103
2141908 2141908 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141909 2141909 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141910 2141910 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141911 2141911 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141912 2141912 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141913 2141913 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141914 2141914 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141915 2141915 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141916 2141916 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   grade_9 3.0 31.0 45.0   1.0           0.0   38.0 42.0     6       *     24   80 3 31 45   1           0   38 42     6       24   80
2141917 2141917 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141918 2141918 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141919 2141919 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   pk_12_total 3.0 103.0 180.0   1.0           2.0   138.0 151.0     23       233     68   289 3 103 180   1           2   138 151     23   233   68   289
2141920 2141920 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141921 2141921 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141922 2141922 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   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
2141923 2141923 NY Bronx   school 3601147 320700861100   SOUTH BRONX COMMUNITY CHARTE 360114706595 320700861100 SOUTH BRONX COMMUNITY CHARTER HIGH S charter Regular School Yes Secondary 09 11 2019   ungraded_secondary 0.0 0.0 1.0   0.0           0.0   0.0 1.0     0       *     *   1 0 0 1   0           0   0 1     0           1
2148859 2148859 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148860 2148860 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148861 2148861 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148862 2148862 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148863 2148863 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148864 2148864 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148865 2148865 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148866 2148866 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148867 2148867 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148868 2148868 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148869 2148869 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148870 2148870 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   grade_9 1.0 38.0 65.0   2.0     4.0     2.0   67.0 45.0     10       102     29   112 1 38 65   2     4     2   67 45     10   102   29   112
2148871 2148871 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148872 2148872 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148873 2148873 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   pk_12_total 1.0 38.0 65.0   2.0     4.0     2.0   67.0 45.0     10       102     29   112 1 38 65   2     4     2   67 45     10   102   29   112
2148874 2148874 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148875 2148875 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148876 2148876 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2148877 2148877 NY Bronx   school 3601182 321200861107   URBAN ASSEMBLY CS - COMPUTER 360118206634 321200861107 URBAN ASSEMBLY CS - COMPUTER SCIENCE charter Regular School Yes Secondary 09 09 2019   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
2151994 2151994 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2151995 2151995 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2151996 2151996 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2151997 2151997 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2151998 2151998 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2151999 2151999 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2152000 2152000 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2152001 2152001 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2152002 2152002 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2152003 2152003 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2152004 2152004 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   grade_8 324.0 72.0 13.0         2.0     36.0   227.0 220.0             273     57   447 324 72 13         2     36   227 220         273   57   447
2152005 2152005 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   grade_9 291.0 64.0 14.0         3.0     26.0   208.0 190.0             *     *   398 291 64 14         3     26   208 190                 398
2152006 2152006 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2152007 2152007 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2152008 2152008 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   pk_12_total 616.0 136.0 27.0         5.0     62.0   436.0 410.0             531     94   846 616 136 27         5     62   436 410         531   94   846
2152009 2152009 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2152010 2152010 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2152011 2152011 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   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
2152012 2152012 NY Chemung   school 3610560 70600010000   ELMIRA 361056000814 70600010021 ERNIE DAVIS ACADEMY public Regular School No Secondary 08 09 2019   ungraded_secondary 1.0 0.0 0.0         0.0     0.0   1.0 0.0             *     *   1 1 0 0         0     0   1 0                 1
2157105 2157105 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157106 2157106 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   grade_10 10.0 68.0 9.0   3.0     8.0     3.0   46.0 55.0     *       91     *   101 10 68 9   3     8     3   46 55         91       101
2157107 2157107 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   grade_11 4.0 25.0 3.0   0.0     3.0     0.0   19.0 16.0     *       30     *   35 4 25 3   0     3     0   19 16         30       35
2157108 2157108 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157109 2157109 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157110 2157110 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157111 2157111 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157112 2157112 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157113 2157113 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157114 2157114 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157115 2157115 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157116 2157116 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   grade_9 10.0 71.0 20.0   3.0     6.0     0.0   58.0 52.0     17       99     20   110 10 71 20   3     6     0   58 52     17   99   20   110
2157117 2157117 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157118 2157118 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157119 2157119 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   pk_12_total 24.0 164.0 32.0   6.0     17.0     3.0   123.0 123.0     31       220     38   246 24 164 32   6     17     3   123 123     31   220   38   246
2157120 2157120 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157121 2157121 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157122 2157122 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157123 2157123 NY Erie   school 3605850 140600010000   BUFFALO 360585006594 140600010140 EAST COMMUNITY SCHOOL public Regular School No Secondary 09 11 2019   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
2157124 2157124 NY Erie   school 3605850 140600010000   BUFFALO 360585006593 140600010141 LAFAYETTE INTERNATIONAL SCHOOL public Regular School No Secondary 09 11 2019   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
2157125 2157125 NY Erie   school 3605850 140600010000   BUFFALO 360585006593 140600010141 LAFAYETTE INTERNATIONAL SCHOOL public Regular School No Secondary 09 11 2019   grade_10 11.0 27.0 39.0         14.0         43.0 48.0     91       87     *   91 11 27 39         14         43 48     91   87       91
2157126 2157126 NY Erie   school 3605850 140600010000   BUFFALO 360585006593 140600010141 LAFAYETTE INTERNATIONAL SCHOOL public Regular School No Secondary 09 11 2019   grade_11 6.0 22.0 32.0         28.0         54.0 34.0     *       *     12   88 6 22 32         28         54 34             12   88
2157127 2157127 NY Erie   school 3605850 140600010000   BUFFALO 360585006593 140600010141 LAFAYETTE INTERNATIONAL SCHOOL public Regular School No Secondary 09 11 2019   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
2157128 2157128 NY Erie   school 3605850 140600010000   BUFFALO 360585006593 140600010141 LAFAYETTE INTERNATIONAL SCHOOL public Regular School No Secondary 09 11 2019   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

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]);