Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 4,742

grade

  • grade_7 · 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
1575694 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_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
1525933 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_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
1558955 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_7 13.0 46.0 9.0   0.0     0.0     0.0     68.0     *       51     8   68 13 46 9   0     0     0     68         51   8   68
1612725 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2020   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
1612744 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 205.0 9.0 45.0   1.0     22.0     7.0   144.0 145.0     *       32     42   289 205 9 45   1     22     7   144 145         32   42   289
1612763 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary KG 03 2020   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
1612782 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2020   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
1612801 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2020   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
1534540 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000684 43501060001 DELEVAN ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   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
1534559 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000685 43501060004 PIONEER MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 162.0 1.0 5.0         2.0     0.0   85.0 85.0             106     38   170 162 1 5         2     0   85 85         106   38   170
1534578 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   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
1534597 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000686 43501060006 PIONEER SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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
1557891 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1557910 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   grade_7 54.0   1.0         0.0     1.0   25.0 31.0     *       25     13   56 54   1         0     1   25 31         25   13   56
1611794 NY Westchester   school 3631920 662300010000   YONKERS 363192000452 662300010001 ROBERT C DODSON SCHOOL public Regular School No Elementary PK 08 2020   grade_7 3.0 4.0 78.0   1.0     4.0     0.0   42.0 48.0     36       85     6   90 3 4 78   1     4     0   42 48     36   85   6   90
1611813 NY Westchester   school 3631920 662300010000   YONKERS 363192001077 662300010002 FAMILY SCHOOL 32 public Regular School No Elementary PK 08 2020   grade_7 15.0 9.0 48.0   0.0     3.0     1.0   46.0 30.0     14       63     36   76 15 9 48   0     3     1   46 30     14   63   36   76
1611832 NY Westchester   school 3631920 662300010000   YONKERS 363192001527 662300010004 MONTESSORI SCHOOL 31 public Regular School No Elementary PK 06 2020   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
1611851 NY Westchester   school 3631920 662300010000   YONKERS 363192004252 662300010005 SCHOOL 5 public Regular School No Elementary PK 08 2020   grade_7 13.0 8.0 35.0   0.0     4.0     0.0   26.0 34.0     *       53     *   60 13 8 35   0     4     0   26 34         53       60
1611870 NY Westchester   school 3631920 662300010000   YONKERS 363192001920 662300010007 WILLIAM BOYCE THOMPSON SCHOOL public Regular School No Elementary PK 08 2020   grade_7 6.0 13.0 34.0   0.0     1.0     0.0   29.0 25.0     5       49     23   54 6 13 34   0     1     0   29 25     5   49   23   54
1611889 NY Westchester   school 3631920 662300010000   YONKERS 363192004254 662300010008 PATRICIA A DICHIARO SCHOOL public Regular School No Elementary PK 08 2020   grade_7 33.0 8.0 19.0   0.0     1.0     0.0   26.0 35.0     *       31     15   61 33 8 19   0     1     0   26 35         31   15   61
1611908 NY Westchester   school 3631920 662300010000   YONKERS 363192004255 662300010009 SCHOOL 9 public Regular School No Elementary PK 06 2020   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
1611927 NY Westchester   school 3631920 662300010000   YONKERS 363192004258 662300010013 SCHOOL 13 public Regular School No Elementary PK 08 2020   grade_7 6.0 6.0 41.0   1.0     2.0     1.0   28.0 29.0     10       56     *   57 6 6 41   1     2     1   28 29     10   56       57
1611946 NY Westchester   school 3631920 662300010000   YONKERS 363192004259 662300010014 ROSEMARIE ANN SIRAGUSA SCHOOL public Regular School No Elementary PK 06 2020   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
1611965 NY Westchester   school 3631920 662300010000   YONKERS 363192003452 662300010015 PAIDEIA SCHOOL 15 public Regular School No Elementary PK 08 2020   grade_7 39.0 8.0 24.0   1.0     1.0     3.0   43.0 33.0     *       38     34   76 39 8 24   1     1     3   43 33         38   34   76
1611984 NY Westchester   school 3631920 662300010000   YONKERS 363192004260 662300010016 SCHOOL 16 public Regular School No Elementary PK 08 2020   grade_7 6.0 17.0 53.0         7.0     0.0   39.0 44.0     8       77     6   83 6 17 53         7     0   39 44     8   77   6   83
1612003 NY Westchester   school 3631920 662300010000   YONKERS 363192004261 662300010017 SCHOOL 17 public Regular School No Elementary PK 06 2020   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
1612022 NY Westchester   school 3631920 662300010000   YONKERS 363192004262 662300010018 SCHOLASTIC ACAD FOR ACAD EXCELLENCE public Regular School No Elementary PK 08 2020   grade_7 3.0 11.0 44.0   0.0     1.0     1.0   31.0 29.0     12       59     6   60 3 11 44   0     1     1   31 29     12   59   6   60
1612041 NY Westchester   school 3631920 662300010000   YONKERS 363192004263 662300010019 EUGENIO MARIA DE HOSTOS MICROSOCIETY public Regular School No Elementary PK 08 2020   grade_7 5.0 8.0 43.0   1.0     0.0     0.0   32.0 25.0     10       56     *   57 5 8 43   1     0     0   32 25     10   56       57
1612060 NY Westchester   school 3631920 662300010000   YONKERS 363192004264 662300010021 SCHOOL 21 public Regular School No Elementary PK 06 2020   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
1612079 NY Westchester   school 3631920 662300010000   YONKERS 363192004265 662300010022 SCHOOL 22 public Regular School No Elementary PK 06 2020   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
1612098 NY Westchester   school 3631920 662300010000   YONKERS 363192004266 662300010023 SCHOOL 23 public Regular School No Elementary PK 08 2020   grade_7 8.0 14.0 36.0   0.0     1.0     0.0   26.0 33.0     10       57     *   59 8 14 36   0     1     0   26 33     10   57       59
1612117 NY Westchester   school 3631920 662300010000   YONKERS 363192002802 662300010024 PAIDEIA SCHOOL 24 public Regular School No Elementary PK 06 2020   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
1612136 NY Westchester   school 3631920 662300010000   YONKERS 363192004267 662300010025 MUSEUM SCHOOL 25 public Regular School No Elementary PK 06 2020   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
1612155 NY Westchester   school 3631920 662300010000   YONKERS 363192004268 662300010026 CASIMIR PULASKI SCHOOL public Regular School No Elementary PK 08 2020   grade_7 30.0 4.0 17.0         6.0     1.0   32.0 26.0     *       26     *   58 30 4 17         6     1   32 26         26       58
1612174 NY Westchester   school 3631920 662300010000   YONKERS 363192004269 662300010027 MONTESSORI SCHOOL 27 public Regular School No Elementary PK 06 2020   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
1612193 NY Westchester   school 3631920 662300010000   YONKERS 363192004270 662300010028 KAHLIL GIBRAN SCHOOL public Regular School No Elementary PK 08 2020   grade_7 19.0 16.0 36.0   0.0     4.0     1.0   42.0 34.0     9       58     21   76 19 16 36   0     4     1   42 34     9   58   21   76
1612212 NY Westchester   school 3631920 662300010000   YONKERS 363192004271 662300010029 SCHOOL 29 public Regular School No Elementary PK 08 2020   grade_7 7.0 16.0 24.0   0.0     7.0     2.0   35.0 21.0     6       45     *   56 7 16 24   0     7     2   35 21     6   45       56
1612231 NY Westchester   school 3631920 662300010000   YONKERS 363192004272 662300010030 SCHOOL 30 public Regular School No Elementary PK 08 2020   grade_7 17.0 9.0 24.0         7.0     3.0   34.0 26.0     *       41     *   60 17 9 24         7     3   34 26         41       60
1612250 NY Westchester   school 3631920 662300010000   YONKERS 363192004242 662300010033 ENRICO FERMI SCHOOL-PERF ARTS public Regular School No Elementary PK 08 2020   grade_7 1.0 6.0 110.0   4.0     2.0     0.0   77.0 46.0     55       117     6   123 1 6 110   4     2     0   77 46     55   117   6   123
1612269 NY Westchester   school 3631920 662300010000   YONKERS 363192004249 662300010036 CROSS HILL ACADEMY public Regular School No Middle 03 08 2020   grade_7 6.0 16.0 28.0   0.0     2.0     1.0   28.0 25.0     *       47     *   53 6 16 28   0     2     1   28 25         47       53
1612288 NY Westchester   school 3631920 662300010000   YONKERS 363192004243 662300010037 GORTON HIGH SCHOOL public Regular School No High 09 12 2020   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
1612307 NY Westchester   school 3631920 662300010000   YONKERS 363192004245 662300010038 LINCOLN HIGH SCHOOL public Regular School No High 09 12 2020   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
1612326 NY Westchester   school 3631920 662300010000   YONKERS 363192004251 662300010040 SAUNDERS TRADES & TECH SR HIGH SCH public Regular School No High 09 12 2020   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
1612345 NY Westchester   school 3631920 662300010000   YONKERS 363192004250 662300010043 ROOSEVELT HIGH SCHOOL - EARLY COLLEG public Regular School No High 09 12 2020   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
1612364 NY Westchester   school 3631920 662300010000   YONKERS 363192004247 662300010044 YONKERS MONTESSORI ACADEMY public Regular School No Other PK 12 2020   grade_7 52.0 14.0 56.0   2.0     4.0     1.0   65.0 64.0     7       89     30   129 52 14 56   2     4     1   65 64     7   89   30   129
1612383 NY Westchester   school 3631920 662300010000   YONKERS 363192004853 662300010045 CESAR E CHAVEZ SCHOOL public Regular School No Elementary PK 08 2020   grade_7 6.0 15.0 66.0   1.0     0.0     1.0   48.0 41.0     10       85     17   89 6 15 66   1     0     1   48 41     10   85   17   89
1612402 NY Westchester   school 3631920 662300010000   YONKERS 363192004248 662300010046 MLK JR HIGH TECH & COMPUTER MAGNE public Regular School No Elementary PK 08 2020   grade_7 1.0 23.0 35.0   0.0     0.0     1.0   37.0 23.0     5       57     14   60 1 23 35   0     0     1   37 23     5   57   14   60
1612421 NY Westchester   school 3631920 662300010000   YONKERS 363192004539 662300010047 PEARLS HAWTHORNE SCHOOL public Regular School No Elementary PK 08 2020   grade_7 22.0 12.0 39.0   0.0     22.0     3.0   46.0 52.0     *       58     5   98 22 12 39   0     22     3   46 52         58   5   98
1612440 NY Westchester   school 3631920 662300010000   YONKERS 363192004574 662300010048 YONKERS HIGH SCHOOL public Regular School No High 09 12 2020   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
1612459 NY Westchester   school 3631920 662300010000   YONKERS 363192000448 662300010050 RIVERSIDE HIGH SCHOOL public Regular School No High 09 12 2020   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
1612478 NY Westchester   school 3631920 662300010000   YONKERS 363192005591 662300010055 YONKERS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 43.0 75.0 172.0   0.0     13.0     5.0   170.0 138.0     37       273     99   308 43 75 172   0     13     5   170 138     37   273   99   308
1612497 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No High 07 12 2020   grade_7 12.0 42.0 107.0   2.0     5.0     3.0   84.0 87.0     31       158     32   171 12 42 107   2     5     3   84 87     31   158   32   171
1612516 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY public Regular School No Elementary PK 06 2020   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
1612535 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No Elementary PK 02 2020   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
1612934 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2020   grade_7 12.0 0.0 0.0   0.0               6.0 6.0             6     *   12 12 0 0   0               6 6         6       12
1591369 NY Rensselaer   school 3631830 490804020000   WYNANTSKILL 363183004238 490804020002 GARDNER-DICKINSON SCHOOL public Regular School No Elementary PK 08 2020   grade_7 38.0 0.0 1.0         0.0     1.0   16.0 24.0     *       14     5   40 38 0 1         0     1   16 24         14   5   40
1598798 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004234 580109020001 MARTIN LUTHER KING ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   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
1598817 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004237 580109020003 WYANDANCH MEMORIAL HIGH SCHOOL public Regular School No High 09 12 2020   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
1598836 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004235 580109020004 MILTON L OLIVE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 2.0 60.0 129.0   0.0     1.0     0.0   102.0 90.0     39       182     38   192 2 60 129   0     1     0   102 90     39   182   38   192
1598855 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No Elementary PK 02 2020   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
1583617 NY Otsego   school 3631740 472506040000   WORCESTER 363174004232 472506040001 WORCESTER SCHOOL public Regular School No Other PK 12 2020   grade_7 34.0 0.0 0.0                   15.0 19.0             21     9   34 34 0 0                   15 19         21   9   34
1533932 NY Broome   school 3602730 31701060000   WINDSOR 360273004334 31701060002 FLOYD BELL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1533951 NY Broome   school 3602730 31701060000   WINDSOR 360273000047 31701060003 C R WEEKS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1533970 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2020   grade_7 109.0 3.0 2.0         0.0     6.0   59.0 61.0     0       67     19   120 109 3 2         0     6   59 61     0   67   19   120
1533989 NY Broome   school 3602730 31701060000   WINDSOR 360273004430 31701060007 WINDSOR CENTRAL HIGH SCHOOL public Regular School No High 09 12 2020   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
1545503 NY Greene   school 3631590 191401040000   WINDHAM ASHLAND 363159004225 191401040001 WINDHAM ASHLAND CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 20.0 1.0 1.0         1.0     0.0   10.0 13.0     0       13     *   23 20 1 1         1     0   10 13     0   13       23
1576625 NY Niagara   school 3631560 401501060000   WILSON 363156004221 401501060002 WILSON ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1576644 NY Niagara   school 3631560 401501060000   WILSON 363156004223 401501060003 WILSON MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   grade_7 87.0 1.0 4.0   1.0           2.0   42.0 53.0     *       45     18   95 87 1 4   1           2   42 53         45   18   95
1544059 NY Essex   school 3631500 151701040000   WILLSBORO 363150004220 151701040001 WILLSBORO CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 12.0   0.0   0.0           2.0   11.0 3.0             9     5   14 12   0   0           2   11 3         9   5   14
1539917 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004216 140203060001 MILL MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 153.0 6.0 9.0         14.0     8.0   93.0 97.0     *       52     21   190 153 6 9         14     8   93 97         52   21   190
1539936 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004210 140203060002 DODGE ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1539955 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004214 140203060003 MAPLE EAST ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1539974 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004219 140203060004 WILLIAMSVILLE SOUTH HIGH SCHOOL public Regular School No High 09 12 2020   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
1539993 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004212 140203060005 HEIM ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1540012 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004211 140203060007 FOREST ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1540031 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004215 140203060008 MAPLE WEST ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1540050 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004213 140203060009 HEIM MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 134.0 5.0 6.0   1.0     26.0     8.0   79.0 101.0     *       28     12   180 134 5 6   1     26     8   79 101         28   12   180
1540069 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004218 140203060010 WILLIAMSVILLE NORTH HIGH SCHOOL public Regular School No High 09 12 2020   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
1540088 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004209 140203060011 COUNTRY PARKWAY ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   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
1540107 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004756 140203060012 CASEY MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 121.0 10.0 5.0   1.0     25.0     11.0   89.0 84.0     *       29     27   173 121 10 5   1     25     11   89 84         29   27   173
1540126 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004217 140203060013 WILLIAMSVILLE EAST HIGH SCHOOL public Regular School No High 09 12 2020   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
1540145 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147000457 140203060015 TRANSIT MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 161.0 16.0 9.0   0.0     45.0     5.0   114.0 122.0     *       30     28   236 161 16 9   0     45     5   114 122         30   28   236
1607899 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004204 651402040001 WILLIAMSON MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 55.0 3.0 7.0         1.0     2.0   35.0 33.0     *       31     10   68 55 3 7         1     2   35 33         31   10   68
1607918 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004206 651402040002 WILLIAMSON SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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
1607937 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004205 651402040003 WILLIAMSON ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1548581 NY Kings   school 3600145 331400860885   WILLIAMSBURG COLLEGIATE CHRT 360014505814 331400860885 WILLIAMSBURG COLLEGIATE CHRTR SCH charter Regular School Yes Middle 05 08 2020   grade_7 0.0 21.0 58.0   0.0     0.0     0.0   37.0 42.0     *       70     17   79 0 21 58   0     0     0   37 42         70   17   79
1548562 NY Kings   school 3600115 331400860865   WILLIAMSBURG CHARTER HIGH SCH 360011505705 331400860865 WILLIAMSBURG CHARTER HIGH SCHOOL charter Regular School Yes High 09 12 2020   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
1600299 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004672 580232030002 WILLIAM FLOYD HIGH SCHOOL public Regular School No High 09 12 2020   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
1600318 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004673 580232030004 WILLIAM FLOYD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1600337 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004674 580232030005 TANGIER SMITH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1600356 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004675 580232030006 MORICHES ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1600375 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004677 580232030008 JOHN S HOBART ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1600394 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005579 580232030010 WILLIAM FLOYD MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 157.0 42.0 175.0   1.0     14.0     15.0   190.0 214.0     25       254     40   404 157 42 175   1     14     15   190 214     25   254   40   404
1600413 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005743 580232030011 NATHANIEL WOODHULL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1600432 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005744 580232030012 WILLIAM PACA MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 128.0 59.0 113.0   2.0     8.0     30.0   181.0 159.0     19       235     50   340 128 59 113   2     8     30   181 159     19   235   50   340
1600451 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869006627 580232030014 WILLIAM FLOYD LEARNING CENTER public Special Education School No Elementary KG 06 2020   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
1533533 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No Middle 04 08 2020   grade_7 77.0 1.0 2.0   0.0     0.0     4.0   43.0 41.0     *       55     11   84 77 1 2   0     0     4   43 41         55   11   84
1533552 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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
1533571 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004199 31401060005 CARYL E ADAMS PRIMARY SCHOOL public Regular School No Elementary PK 03 2020   grade_7 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
1524527 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 12.0 0.0 1.0                   8.0 5.0     *       8     0   13 12 0 1                   8 5         8   0   13

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