Data source: Big Local News · About: Big Local

4,742 rows where grade = "grade_9", state = "NY" and year = 2020 sorted by district descending

View and edit SQL

year

  • 2020 · 4,742

grade

  • grade_9 · 4,742
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
1575696 NY New York   school 3601171 310600861140   ZETA CHARTER SCHOOL - INWOOD 360117106637 310600861140 ZETA CHARTER SCHOOL - INWOOD 1 charter Regular School Yes Elementary KG 02 2020   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
1525935 NY Bronx   school 3601177 320700861141   ZETA CHARTER SCHOOL - BRONX 1 360117706638 320700861141 ZETA CHARTER SCHOOL - BRONX 1 charter Regular School Yes Elementary KG 02 2020   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
1558957 NY Monroe   school 3601080 260501861020   YOUNG WOMEN'S COLLEGE PRE 360108006316 260501861020 YOUNG WOMEN'S COLLEGE PREP CHARTER charter Regular School Yes High 07 12 2020   grade_9 4.0 39.0 13.0   1.0     1.0     1.0     59.0     8       52     9   59 4 39 13   1     1     1     59     8   52   9   59
1612727 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 212.0 9.0 51.0   1.0     14.0     4.0   157.0 134.0     *       39     50   291 212 9 51   1     14     4   157 134         39   50   291
1612746 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1612765 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary KG 03 2020   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
1612784 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2020   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
1612803 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2020   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
1534542 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000684 43501060001 DELEVAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   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
1534561 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000685 43501060004 PIONEER MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
1534580 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   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
1534599 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 154.0 0.0 3.0   0.0     0.0     0.0   75.0 82.0     *       74     23   157 154 0 3   0     0     0   75 82         74   23   157
1557893 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1557912 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   grade_9 55.0   1.0         0.0     0.0   23.0 33.0     *       19     14   56 55   1         0     0   23 33         19   14   56
1611796 NY Westchester   school 3631920 662300010000   YONKERS 363192000452 662300010001 ROBERT C DODSON SCHOOL public Regular School No Elementary PK 08 2020   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
1611815 NY Westchester   school 3631920 662300010000   YONKERS 363192001077 662300010002 FAMILY SCHOOL 32 public Regular School No Elementary PK 08 2020   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
1611834 NY Westchester   school 3631920 662300010000   YONKERS 363192001527 662300010004 MONTESSORI SCHOOL 31 public Regular School No Elementary PK 06 2020   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
1611853 NY Westchester   school 3631920 662300010000   YONKERS 363192004252 662300010005 SCHOOL 5 public Regular School No Elementary PK 08 2020   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
1611872 NY Westchester   school 3631920 662300010000   YONKERS 363192001920 662300010007 WILLIAM BOYCE THOMPSON SCHOOL public Regular School No Elementary PK 08 2020   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
1611891 NY Westchester   school 3631920 662300010000   YONKERS 363192004254 662300010008 PATRICIA A DICHIARO SCHOOL public Regular School No Elementary PK 08 2020   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
1611910 NY Westchester   school 3631920 662300010000   YONKERS 363192004255 662300010009 SCHOOL 9 public Regular School No Elementary PK 06 2020   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
1611929 NY Westchester   school 3631920 662300010000   YONKERS 363192004258 662300010013 SCHOOL 13 public Regular School No Elementary PK 08 2020   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
1611948 NY Westchester   school 3631920 662300010000   YONKERS 363192004259 662300010014 ROSEMARIE ANN SIRAGUSA SCHOOL public Regular School No Elementary PK 06 2020   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
1611967 NY Westchester   school 3631920 662300010000   YONKERS 363192003452 662300010015 PAIDEIA SCHOOL 15 public Regular School No Elementary PK 08 2020   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
1611986 NY Westchester   school 3631920 662300010000   YONKERS 363192004260 662300010016 SCHOOL 16 public Regular School No Elementary PK 08 2020   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
1612005 NY Westchester   school 3631920 662300010000   YONKERS 363192004261 662300010017 SCHOOL 17 public Regular School No Elementary PK 06 2020   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
1612024 NY Westchester   school 3631920 662300010000   YONKERS 363192004262 662300010018 SCHOLASTIC ACAD FOR ACAD EXCELLENCE public Regular School No Elementary PK 08 2020   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
1612043 NY Westchester   school 3631920 662300010000   YONKERS 363192004263 662300010019 EUGENIO MARIA DE HOSTOS MICROSOCIETY public Regular School No Elementary PK 08 2020   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
1612062 NY Westchester   school 3631920 662300010000   YONKERS 363192004264 662300010021 SCHOOL 21 public Regular School No Elementary PK 06 2020   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
1612081 NY Westchester   school 3631920 662300010000   YONKERS 363192004265 662300010022 SCHOOL 22 public Regular School No Elementary PK 06 2020   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
1612100 NY Westchester   school 3631920 662300010000   YONKERS 363192004266 662300010023 SCHOOL 23 public Regular School No Elementary PK 08 2020   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
1612119 NY Westchester   school 3631920 662300010000   YONKERS 363192002802 662300010024 PAIDEIA SCHOOL 24 public Regular School No Elementary PK 06 2020   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
1612138 NY Westchester   school 3631920 662300010000   YONKERS 363192004267 662300010025 MUSEUM SCHOOL 25 public Regular School No Elementary PK 06 2020   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
1612157 NY Westchester   school 3631920 662300010000   YONKERS 363192004268 662300010026 CASIMIR PULASKI SCHOOL public Regular School No Elementary PK 08 2020   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
1612176 NY Westchester   school 3631920 662300010000   YONKERS 363192004269 662300010027 MONTESSORI SCHOOL 27 public Regular School No Elementary PK 06 2020   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
1612195 NY Westchester   school 3631920 662300010000   YONKERS 363192004270 662300010028 KAHLIL GIBRAN SCHOOL public Regular School No Elementary PK 08 2020   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
1612214 NY Westchester   school 3631920 662300010000   YONKERS 363192004271 662300010029 SCHOOL 29 public Regular School No Elementary PK 08 2020   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
1612233 NY Westchester   school 3631920 662300010000   YONKERS 363192004272 662300010030 SCHOOL 30 public Regular School No Elementary PK 08 2020   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
1612252 NY Westchester   school 3631920 662300010000   YONKERS 363192004242 662300010033 ENRICO FERMI SCHOOL-PERF ARTS public Regular School No Elementary PK 08 2020   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
1612271 NY Westchester   school 3631920 662300010000   YONKERS 363192004249 662300010036 CROSS HILL ACADEMY public Regular School No Middle 03 08 2020   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
1612290 NY Westchester   school 3631920 662300010000   YONKERS 363192004243 662300010037 GORTON HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 18.0 57.0 162.0   0.0     7.0     1.0   99.0 146.0     43       223     43   245 18 57 162   0     7     1   99 146     43   223   43   245
1612309 NY Westchester   school 3631920 662300010000   YONKERS 363192004245 662300010038 LINCOLN HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 24.0 29.0 232.0   1.0     5.0     1.0   148.0 144.0     46       264     59   292 24 29 232   1     5     1   148 144     46   264   59   292
1612328 NY Westchester   school 3631920 662300010000   YONKERS 363192004251 662300010040 SAUNDERS TRADES & TECH SR HIGH SCH public Regular School No High 09 12 2020   grade_9 57.0 35.0 165.0   1.0     13.0     4.0   119.0 156.0     15       222     46   275 57 35 165   1     13     4   119 156     15   222   46   275
1612347 NY Westchester   school 3631920 662300010000   YONKERS 363192004250 662300010043 ROOSEVELT HIGH SCHOOL - EARLY COLLEG public Regular School No High 09 12 2020   grade_9 20.0 68.0 149.0   1.0     11.0     4.0   136.0 117.0     *       219     52   253 20 68 149   1     11     4   136 117         219   52   253
1612366 NY Westchester   school 3631920 662300010000   YONKERS 363192004247 662300010044 YONKERS MONTESSORI ACADEMY public Regular School No Other PK 12 2020   grade_9 34.0 8.0 33.0   0.0     5.0     2.0   41.0 41.0     0       61     9   82 34 8 33   0     5     2   41 41     0   61   9   82
1612385 NY Westchester   school 3631920 662300010000   YONKERS 363192004853 662300010045 CESAR E CHAVEZ SCHOOL public Regular School No Elementary PK 08 2020   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
1612404 NY Westchester   school 3631920 662300010000   YONKERS 363192004248 662300010046 MLK JR HIGH TECH & COMPUTER MAGNE public Regular School No Elementary PK 08 2020   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
1612423 NY Westchester   school 3631920 662300010000   YONKERS 363192004539 662300010047 PEARLS HAWTHORNE SCHOOL public Regular School No Elementary PK 08 2020   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
1612442 NY Westchester   school 3631920 662300010000   YONKERS 363192004574 662300010048 YONKERS HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 39.0 24.0 97.0   3.0     48.0     6.0   86.0 131.0     *       *     31   217 39 24 97   3     48     6   86 131             31   217
1612461 NY Westchester   school 3631920 662300010000   YONKERS 363192000448 662300010050 RIVERSIDE HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 15.0 43.0 142.0   3.0     8.0     3.0   138.0 76.0     33       197     35   214 15 43 142   3     8     3   138 76     33   197   35   214
1612480 NY Westchester   school 3631920 662300010000   YONKERS 363192005591 662300010055 YONKERS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1612499 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No High 07 12 2020   grade_9 7.0 29.0 62.0   1.0     4.0     3.0   57.0 49.0     15       97     10   106 7 29 62   1     4     3   57 49     15   97   10   106
1612518 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY public Regular School No Elementary PK 06 2020   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
1612537 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No Elementary PK 02 2020   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
1612936 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2020   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
1591371 NY Rensselaer   school 3631830 490804020000   WYNANTSKILL 363183004238 490804020002 GARDNER-DICKINSON SCHOOL public Regular School No Elementary PK 08 2020   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
1598800 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004234 580109020001 MARTIN LUTHER KING ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   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
1598819 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004237 580109020003 WYANDANCH MEMORIAL HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 1.0 99.0 102.0         1.0     0.0   99.0 104.0     42       184     32   203 1 99 102         1     0   99 104     42   184   32   203
1598838 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004235 580109020004 MILTON L OLIVE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1598857 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No Elementary PK 02 2020   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
1583619 NY Otsego   school 3631740 472506040000   WORCESTER 363174004232 472506040001 WORCESTER SCHOOL public Regular School No Other PK 12 2020   grade_9 23.0 0.0 0.0                   8.0 15.0             10     5   23 23 0 0                   8 15         10   5   23
1533934 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1533953 NY Broome   school 3602730 31701060000   WINDSOR 360273000047 31701060003 C R WEEKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1533972 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2020   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
1533991 NY Broome   school 3602730 31701060000   WINDSOR 360273004430 31701060007 WINDSOR CENTRAL HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 125.0 6.0 4.0         1.0     5.0   74.0 67.0     *       75     26   141 125 6 4         1     5   74 67         75   26   141
1545505 NY Greene   school 3631590 191401040000   WINDHAM ASHLAND 363159004225 191401040001 WINDHAM ASHLAND CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_9 17.0 0.0 2.0         2.0     1.0   13.0 9.0     0       10     5   22 17 0 2         2     1   13 9     0   10   5   22
1576627 NY Niagara   school 3631560 401501060000   WILSON 363156004221 401501060002 WILSON ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1576646 NY Niagara   school 3631560 401501060000   WILSON 363156004223 401501060003 WILSON MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   grade_9 81.0 1.0 1.0   1.0           0.0   42.0 42.0     0       36     7   84 81 1 1   1           0   42 42     0   36   7   84
1544061 NY Essex   school 3631500 151701040000   WILLSBORO 363150004220 151701040001 WILLSBORO CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_9 13.0   1.0   0.0           2.0   6.0 10.0             8     *   16 13   1   0           2   6 10         8       16
1539919 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004216 140203060001 MILL MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
1539938 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004210 140203060002 DODGE ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1539957 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004214 140203060003 MAPLE EAST ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1539976 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004219 140203060004 WILLIAMSVILLE SOUTH HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 202.0 10.0 15.0   1.0     11.0     6.0   109.0 136.0     *       54     28   245 202 10 15   1     11     6   109 136         54   28   245
1539995 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004212 140203060005 HEIM ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1540014 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004211 140203060007 FOREST ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1540033 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004215 140203060008 MAPLE WEST ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1540052 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004213 140203060009 HEIM MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
1540071 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004218 140203060010 WILLIAMSVILLE NORTH HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 264.0 20.0 14.0   0.0     31.0     14.0   178.0 165.0     5       50     33   343 264 20 14   0     31     14   178 165     5   50   33   343
1540090 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004209 140203060011 COUNTRY PARKWAY ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1540109 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004756 140203060012 CASEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
1540128 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004217 140203060013 WILLIAMSVILLE EAST HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 172.0 11.0 8.0   2.0     44.0     11.0   121.0 127.0     *       43     22   248 172 11 8   2     44     11   121 127         43   22   248
1540147 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147000457 140203060015 TRANSIT MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
1607901 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004204 651402040001 WILLIAMSON MIDDLE SCHOOL public Regular School No Middle 05 08 2020   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
1607920 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004206 651402040002 WILLIAMSON SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 56.0 1.0 11.0   0.0     1.0     6.0   41.0 34.0     *       38     11   75 56 1 11   0     1     6   41 34         38   11   75
1607939 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004205 651402040003 WILLIAMSON ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1548583 NY Kings   school 3600145 331400860885   WILLIAMSBURG COLLEGIATE CHRT 360014505814 331400860885 WILLIAMSBURG COLLEGIATE CHRTR SCH charter Regular School Yes Middle 05 08 2020   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
1548564 NY Kings   school 3600115 331400860865   WILLIAMSBURG CHARTER HIGH SCH 360011505705 331400860865 WILLIAMSBURG CHARTER HIGH SCHOOL charter Regular School Yes High 09 12 2020   grade_9 1.0 86.0 148.0   1.0     1.0     4.0   111.0 130.0     24       205     44   241 1 86 148   1     1     4   111 130     24   205   44   241
1600301 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004672 580232030002 WILLIAM FLOYD HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 284.0 94.0 241.0   4.0     21.0     37.0   343.0 338.0     *       411     91   681 284 94 241   4     21     37   343 338         411   91   681
1600320 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004673 580232030004 WILLIAM FLOYD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1600339 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004674 580232030005 TANGIER SMITH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1600358 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004675 580232030006 MORICHES ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1600377 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004677 580232030008 JOHN S HOBART ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1600396 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005579 580232030010 WILLIAM FLOYD MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1600415 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005743 580232030011 NATHANIEL WOODHULL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1600434 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005744 580232030012 WILLIAM PACA MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1600453 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869006627 580232030014 WILLIAM FLOYD LEARNING CENTER public Special Education School No Elementary KG 06 2020   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
1533535 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No Middle 04 08 2020   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
1533554 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 109.0 0.0 2.0         1.0     0.0   51.0 61.0     *       68     27   112 109 0 2         1     0   51 61         68   27   112
1533573 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004199 31401060005 CARYL E ADAMS PRIMARY SCHOOL public Regular School No Elementary PK 03 2020   grade_9 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
1524529 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_9 15.0 0.0 0.0                   6.0 9.0     *       11     *   15 15 0 0                   6 9         11       15

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