Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_2" and state = "NY" sorted by total_int descending

View and edit SQL

year

grade

  • grade_2 · 33,145
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 ▲
787991 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No 1 01 02 2015   grade_2 8.0 90.0 344.0         2.0     1.0   235.0 210.0             420     40   445 8 90 344         2     1   235 210         420   40   445
1029344 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2017   grade_2 76.0 33.0 245.0         11.0     17.0   204.0 178.0     92       251     29   382 76 33 245         11     17   204 178     92   251   29   382
833078 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No 1 01 02 2015   grade_2 87.0 32.0 217.0         23.0     22.0   194.0 187.0             236     21   381 87 32 217         23     22   194 187         236   21   381
2226345 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2019   grade_2 76.0 29.0 241.0   1.0     14.0     20.0   209.0 172.0     44       234     41   381 76 29 241   1     14     20   209 172     44   234   41   381
1610706 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2020   grade_2 73.0 24.0 237.0         11.0     8.0   176.0 177.0     59       223     28   353 73 24 237         11     8   176 177     59   223   28   353
806896 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No 1 KG 05 2015   grade_2 5.0 0.0 279.0   2.0     64.0     0.0   186.0 164.0             239     65   350 5 0 279   2     64     0   186 164         239   65   350
1093032 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No 1.0 KG 05 2016   grade_2 1.0 2.0 320.0   1.0     25.0     0.0   161.0 188.0             270     79   349 1 2 320   1     25     0   161 188         270   79   349
1119537 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No 1.0 01 03 2016   grade_2 81.0 44.0 202.0         11.0     10.0   187.0 161.0             226     26   348 81 44 202         11     10   187 161         226   26   348
1093260 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No 1.0 KG 05 2016   grade_2 3.0 0.0 263.0   3.0     69.0         161.0 177.0             206     55   338 3 0 263   3     69         161 177         206   55   338
2106911 NY Ontario   school 3629640 431701060000   VICTOR 362964003995 431701060003 VICTOR PRIMARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 272.0 8.0 26.0   1.0     13.0     18.0   176.0 162.0     14       82     37   338 272 8 26   1     13     18   176 162     14   82   37   338
771252 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202602 331500010169 PS 169 SUNSET PARK public Regular School No 1 KG 5 2015   grade_2 17.0 4.0 150.0         165.0     1.0   174.0 163.0             252     50   337 17 4 150         165     1   174 163         252   50   337
806668 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No 1 KG 05 2015   grade_2 1.0 2.0 309.0   0.0     24.0     1.0   155.0 182.0             264     77   337 1 2 309   0     24     1   155 182         264   77   337
2136684 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2018   grade_2 69.0 29.0 208.0   0.0     14.0     14.0   171.0 163.0     55       211     23   334 69 29 208   0     14     14   171 163     55   211   23   334
1002972 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No Elementary KG 05 2017   grade_2 1.0 3.0 303.0   0.0     25.0     0.0   183.0 149.0     253       253     72   332 1 3 303   0     25     0   183 149     253   253   72   332
1003200 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2017   grade_2 6.0 0.0 251.0   2.0     68.0     0.0   177.0 150.0     163       181     53   327 6 0 251   2     68     0   177 150     163   181   53   327
803248 NY Ontario   school 3629640 431701060000   VICTOR 362964003995 431701060003 VICTOR PRIMARY SCHOOL public Regular School No 1 KG 03 2015   grade_2 281.0 4.0 21.0   1.0     6.0     12.0   162.0 163.0             52     27   325 281 4 21   1     6     12   162 163         52   27   325
1520589 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2021   grade_2 52.0 23.0 216.0         17.0     15.0   167.0 156.0     47       199     33   323 52 23 216         17     15   167 156     47   199   33   323
807067 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802521 342400010143 PS 143 LOUIS ARMSTRONG public Regular School No 1 KG 05 2015   grade_2 0.0 4.0 297.0   0.0     20.0         156.0 165.0             303     54   321 0 4 297   0     20         156 165         303   54   321
999533 NY Ontario   school 3629640 431701060000   VICTOR 362964003995 431701060003 VICTOR PRIMARY SCHOOL public Regular School No Elementary KG 04 2017   grade_2 272.0 6.0 23.0   1.0     9.0     10.0   158.0 163.0     *       71     35   321 272 6 23   1     9     10   158 163         71   35   321
2110540 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2018   grade_2 6.0 0.0 243.0   1.0     69.0     0.0   154.0 165.0     175       257     48   319 6 0 243   1     69     0   154 165     175   257   48   319
1580762 NY Ontario   school 3629640 431701060000   VICTOR 362964003995 431701060003 VICTOR PRIMARY SCHOOL public Regular School No Elementary KG 04 2020   grade_2 263.0 7.0 21.0   1.0     8.0     14.0   160.0 154.0     11       78     28   314 263 7 21   1     8     14   160 154     11   78   28   314
1493989 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No Elementary PK 05 2021   grade_2 3.0 0.0 296.0         13.0     0.0   160.0 152.0     199       277     77   312 3 0 296         13     0   160 152     199   277   77   312
2110312 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No Elementary KG 05 2018   grade_2 1.0 2.0 297.0   1.0     9.0     0.0   145.0 165.0     192       294     81   310 1 2 297   1     9     0   145 165     192   294   81   310
1092994 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No 1.0 KG 05 2016   grade_2 4.0 11.0 263.0   3.0     27.0     0.0   153.0 155.0             210     51   308 4 11 263   3     27     0   153 155         210   51   308
1584163 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No Elementary PK 05 2020   grade_2 3.0 0.0 281.0         20.0     1.0   158.0 147.0     170       260     75   305 3 0 281         20     1   158 147     170   260   75   305
775850 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102396 332000010105 PS 105 BLYTHEBOURNE (THE) public Regular School No 1 KG 5 2015   grade_2 12.0 0.0 9.0   0.0     283.0         145.0 159.0             215     19   304 12 0 9   0     283         145 159         215   19   304
1089612 NY Ontario   school 3629640 431701060000   VICTOR 362964003995 431701060003 VICTOR PRIMARY SCHOOL public Regular School No 1.0 KG 03 2016   grade_2 258.0 7.0 14.0   3.0     8.0     10.0   155.0 145.0             63     29   300 258 7 14   3     8     10   155 145         63   29   300
2199878 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No Elementary KG 05 2019   grade_2 2.0 1.0 283.0   0.0     14.0     0.0   159.0 141.0     172       269     63   300 2 1 283   0     14     0   159 141     172   269   63   300
806630 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No 1 KG 05 2015   grade_2 4.0 12.0 254.0   5.0     23.0     0.0   156.0 142.0             207     48   298 4 12 254   5     23     0   156 142         207   48   298
2200106 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2019   grade_2 6.0 0.0 221.0   1.0     68.0     0.0   143.0 153.0     160       244     45   296 6 0 221   1     68     0   143 153     160   244   45   296
752936 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802394 321100010105 PS 105 SEN ABRAHAM BERNSTEIN public Regular School No 1.0 KG 05 2015   grade_2 38.0 40.0 188.0   1.0     24.0     4.0   148.0 147.0             268     63   295 38 40 188   1     24     4   148 147         268   63   295
1490607 NY Ontario   school 3629640 431701060000   VICTOR 362964003995 431701060003 VICTOR PRIMARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 237.0 4.0 26.0   0.0     7.0     15.0   149.0 140.0     12       72     29   289 237 4 26   0     7     15   149 140     12   72   29   289
1002915 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802081 342400010013 PS 13 CLEMENT C MOORE public Regular School No Elementary KG 05 2017   grade_2 7.0 22.0 177.0   1.0     78.0     2.0   149.0 138.0     127       157     38   287 7 22 177   1     78     2   149 138     127   157   38   287
1093431 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802521 342400010143 PS 143 LOUIS ARMSTRONG public Regular School No 1.0 KG 05 2016   grade_2 2.0 1.0 263.0   0.0     18.0     1.0   146.0 139.0             264     65   285 2 1 263   0     18     1   146 139         264   65   285
806611 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802081 342400010013 PS 13 CLEMENT C MOORE public Regular School No 1 KG 05 2015   grade_2 7.0 27.0 165.0   0.0     84.0     0.0   141.0 142.0             184     31   283 7 27 165   0     84     0   141 142         184   31   283
2196496 NY Ontario   school 3629640 431701060000   VICTOR 362964003995 431701060003 VICTOR PRIMARY SCHOOL public Regular School No Elementary KG 04 2019   grade_2 247.0 1.0 16.0   0.0     4.0     14.0   140.0 142.0     *       66     26   282 247 1 16   0     4     14   140 142         66   26   282
833268 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No 1 02 04 2015   grade_2 21.0 57.0 192.0   0.0     5.0     6.0   150.0 131.0             226     39   281 21 57 192   0     5     6   150 131         226   39   281
1584391 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2020   grade_2 9.0 1.0 189.0   3.0     77.0     0.0   145.0 134.0     124       232     41   279 9 1 189   3     77     0   145 134     124   232   41   279
1610896 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2020   grade_2 26.0 29.0 209.0         3.0     11.0   144.0 134.0     113       214     29   278 26 29 209         3     11   144 134     113   214   29   278
948062 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702332 321000010086 PS 86 KINGSBRIDGE HEIGHTS public Regular School No Elementary PK 06 2017   grade_2 2.0 14.0 251.0   2.0     8.0     0.0   137.0 140.0     101       225     58   277 2 14 251   2     8     0   137 140     101   225   58   277
1092975 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802081 342400010013 PS 13 CLEMENT C MOORE public Regular School No 1.0 KG 05 2016   grade_2 6.0 31.0 156.0   0.0     84.0     0.0   136.0 141.0             159     39   277 6 31 156   0     84     0   136 141         159   39   277
972439 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102575 332000010160 PS 160 WILLIAM T SAMPSON public Regular School No Elementary PK 5 2017   grade_2 15.0 0.0 18.0   0.0     243.0     0.0   152.0 124.0     229       147     34   276 15 0 18   0     243     0   152 124     229   147   34   276
1057787 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202602 331500010169 PS 169 SUNSET PARK public Regular School No 1.0 KG 5 2016   grade_2 4.0 10.0 115.0   0.0     145.0     1.0   148.0 127.0             193     54   275 4 10 115   0     145     1   148 127         193   54   275
1062423 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102575 332000010160 PS 160 WILLIAM T SAMPSON public Regular School No 1.0 KG 5 2016   grade_2 10.0 5.0 23.0   1.0     236.0     0.0   152.0 123.0             166     32   275 10 5 23   1     236     0   152 123         166   32   275
2174152 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000274 260101060001 COUNCIL ROCK PRIMARY SCHOOL public Regular School No Elementary KG 02 2019   grade_2 198.0 14.0 15.0         26.0     19.0   127.0 145.0     27       66     35   272 198 14 15         26     19   127 145     27   66   35   272
2110274 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2018   grade_2 10.0 7.0 239.0   1.0     13.0     0.0   136.0 134.0     92       239     56   270 10 7 239   1     13     0   136 134     92   239   56   270
1029534 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2017   grade_2 18.0 48.0 187.0   0.0     4.0     12.0   150.0 119.0     95       232     36   269 18 48 187   0     4     12   150 119     95   232   36   269
1002934 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2017   grade_2 3.0 14.0 236.0   0.0     15.0     0.0   142.0 126.0     90       185     52   268 3 14 236   0     15     0   142 126     90   185   52   268
1095863 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302405 342700010108 PS 108 CAPT VINCENT G FOWLER public Regular School No 1.0 PK 05 2016   grade_2 7.0 22.0 91.0   1.0     146.0     0.0   138.0 129.0             222     40   267 7 22 91   1     146     0   138 129         222   40   267
1097858 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102362 342900010095 PS 95 EASTWOOD public Regular School No 1.0 KG 05 2016   grade_2 6.0 28.0 114.0   15.0     103.0     1.0   138.0 129.0             162     39   267 6 28 114   15     103     1   138 129         162   39   267
771347 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202818 331500010321 PS 321 WILLIAM PENN public Regular School No 1 KG 5 2015   grade_2 203.0 18.0 19.0   1.0     24.0     1.0   134.0 132.0             17     48   266 203 18 19   1     24     1   134 132         17   48   266
1062366 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102396 332000010105 PS 105 BLYTHEBOURNE (THE) public Regular School No 1.0 KG 5 2016   grade_2 9.0 0.0 16.0         241.0     0.0   162.0 104.0             171     19   266 9 0 16         241     0   162 104         171   19   266
1090258 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932006448 441000010018 PRESIDENTIAL PARK ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 40.0 38.0 170.0   0.0     9.0     9.0   129.0 137.0             217     29   266 40 38 170   0     9     9   129 137         217   29   266
1553592 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102396 332000010105 PS 105 BLYTHEBOURNE (THE) public Regular School No Elementary KG 05 2020   grade_2 5.0 1.0 7.0   0.0     253.0         149.0 117.0     95       230     20   266 5 1 7   0     253         149 117     95   230   20   266
771081 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No 1 KG 5 2015   grade_2 6.0 2.0 110.0   0.0     147.0         119.0 146.0             255     20   265 6 2 110   0     147         119 146         255   20   265
1067173 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000274 260101060001 COUNCIL ROCK PRIMARY SCHOOL public Regular School No 1.0 KG 02 2016   grade_2 181.0 14.0 17.0         31.0     22.0   147.0 118.0             42     28   265 181 14 17         31     22   147 118         42   28   265
972382 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102396 332000010105 PS 105 BLYTHEBOURNE (THE) public Regular School No Elementary PK 5 2017   grade_2 9.0 0.0 8.0         247.0     0.0   127.0 137.0     141       137     14   264 9 0 8         247     0   127 137     141   137   14   264
783830 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_2 222.0 6.0 15.0         4.0     16.0   132.0 131.0             *     *   263 222 6 15         4     16   132 131                 263
811475 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102362 342900010095 PS 95 EASTWOOD public Regular School No 1 KG 05 2015   grade_2 3.0 26.0 122.0   15.0     95.0     1.0   128.0 134.0             182     37   262 3 26 122   15     95     1   128 134         182   37   262
1580249 NY Ontario   school 3606330 430300050000   CANANDAIGUA 360633000415 430300050001 CANANDAIGUA PRIMARY-ELEMENTARY public Regular School No Elementary PK 05 2020   grade_2 218.0 6.0 19.0   2.0     2.0     14.0   122.0 139.0     7       119     33   261 218 6 19   2     2     14   122 139     7   119   33   261
2136874 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2018   grade_2 25.0 39.0 184.0         4.0     9.0   146.0 115.0     98       218     25   261 25 39 184         4     9   146 115     98   218   25   261
806573 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801406 342400010007 PS 7 LOUIS F SIMEONE public Regular School No 1 KG 03 2015   grade_2 4.0 2.0 84.0         169.0     0.0   130.0 129.0             225     34   259 4 2 84         169     0   130 129         225   34   259
967708 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No Elementary KG 5 2017   grade_2 2.0 1.0 82.0   0.0     172.0     0.0   124.0 133.0     169       251     22   257 2 1 82   0     172     0   124 133     169   251   22   257
820880 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_2 17.0 80.0 148.0   2.0     1.0     7.0   129.0 126.0             206     22   255 17 80 148   2     1     7   129 126         206   22   255
972344 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102385 332000010102 PS 102 BAYVIEW (THE) public Regular School No Elementary KG 5 2017   grade_2 136.0 2.0 68.0   7.0     37.0     5.0   128.0 127.0     49       154     47   255 136 2 68   7     37     5   128 127     49   154   47   255
821963 NY Suffolk   school 3624840 580209020000   ROCKY POINT 362484003436 580209020003 FRANK J CARASITI ELEMENTARY SCHOOL public Regular School No 1 KG 02 2015   grade_2 219.0 4.0 21.0   2.0     4.0     4.0   123.0 131.0             86     35   254 219 4 21   2     4     4   123 131         86   35   254
1057616 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No 1.0 KG 5 2016   grade_2 3.0 1.0 86.0   0.0     164.0     0.0   128.0 126.0             248     17   254 3 1 86   0     164     0   128 126         248   17   254
1089099 NY Ontario   school 3606330 430300050000   CANANDAIGUA 360633000415 430300050001 CANANDAIGUA PRIMARY-ELEMENTARY public Regular School No 1.0 PK 05 2016   grade_2 223.0 2.0 12.0   1.0     5.0     11.0   142.0 112.0             101     34   254 223 2 12   1     5     11   142 112         101   34   254
1092937 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801406 342400010007 PS 7 LOUIS F SIMEONE public Regular School No 1.0 KG 03 2016   grade_2 4.0 0.0 96.0   0.0     153.0     1.0   141.0 113.0             230     39   254 4 0 96   0     153     1   141 113         230   39   254
2199821 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802081 342400010013 PS 13 CLEMENT C MOORE public Regular School No Elementary KG 05 2019   grade_2 14.0 21.0 135.0   2.0     78.0     4.0   128.0 126.0     88       184     *   254 14 21 135   2     78     4   128 126     88   184       254
1107320 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No 1.0 01 03 2016   grade_2 9.0 105.0 127.0   1.0     1.0     10.0   141.0 112.0             219     20   253 9 105 127   1     1     10   141 112         219   20   253
1561496 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2020   grade_2 196.0 12.0 25.0   1.0     4.0     14.0   136.0 116.0     *       127     *   252 196 12 25   1     4     14   136 116         127       252
967879 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202602 331500010169 PS 169 SUNSET PARK public Regular School No Elementary KG 5 2017   grade_2 13.0 2.0 95.0   0.0     139.0     2.0   112.0 139.0     162       164     32   251 13 2 95   0     139     2   112 139     162   164   32   251
967974 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202818 331500010321 PS 321 WILLIAM PENN public Regular School No Elementary PK 5 2017   grade_2 198.0 5.0 20.0   1.0     11.0     16.0   126.0 125.0     6       17     34   251 198 5 20   1     11     16   126 125     6   17   34   251
977170 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000274 260101060001 COUNCIL ROCK PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 172.0 10.0 15.0         29.0     25.0   134.0 117.0     14       26     34   251 172 10 15         29     25   134 117     14   26   34   251
2110255 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802081 342400010013 PS 13 CLEMENT C MOORE public Regular School No Elementary KG 05 2018   grade_2 10.0 26.0 135.0   3.0     75.0     2.0   124.0 127.0     97       *     42   251 10 26 135   3     75     2   124 127     97       42   251
775983 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102618 332000010176 PS 176 OVINGTON public Regular School No 1 KG 5 2015   grade_2 44.0 2.0 63.0         141.0     0.0   130.0 120.0             205     26   250 44 2 63         141     0   130 120         205   26   250
806516 NY Putnam   school 3605310 480601060000   BREWSTER 360531000267 480601060004 JOHN F KENNEDY ELEMENTARY SCHOOL public Regular School No 1 KG 02 2015   grade_2 144.0 4.0 86.0   1.0     6.0     9.0   114.0 136.0             89     24   250 144 4 86   1     6     9   114 136         89   24   250
1115566 NY Warren   school 3624030 630902030000   QUEENSBURY 362403003316 630902030001 QUEENSBURY ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_2 240.0 4.0 1.0         2.0     2.0   129.0 120.0             105     44   249 240 4 1         2     2   129 120         105   44   249
2106398 NY Ontario   school 3606330 430300050000   CANANDAIGUA 360633000415 430300050001 CANANDAIGUA PRIMARY-ELEMENTARY public Regular School No Elementary PK 05 2018   grade_2 220.0 1.0 11.0   2.0     3.0     12.0   120.0 129.0     *       111     30   249 220 1 11   2     3     12   120 129         111   30   249
1549070 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202602 331500010169 PS 169 SUNSET PARK public Regular School No Elementary KG 05 2020   grade_2 5.0 1.0 76.0   1.0     164.0     1.0   124.0 124.0     117       223     45   248 5 1 76   1     164     1   124 124     117   223   45   248
1553858 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102679 332000010200 PS 200 BENSON SCHOOL public Regular School No Elementary PK 05 2020   grade_2 105.0 0.0 49.0   0.0     89.0     5.0   133.0 115.0     53       204     35   248 105 0 49   0     89     5   133 115     53   204   35   248
824034 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003727 580413030003 OAKWOOD PRIMARY CENTER public Regular School No 1 KG 02 2015   grade_2 97.0 16.0 109.0   1.0     19.0     5.0   129.0 118.0             136     22   247 97 16 109   1     19     5   129 118         136   22   247
1002877 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801406 342400010007 PS 7 LOUIS F SIMEONE public Regular School No Elementary PK 03 2017   grade_2 2.0 0.0 85.0   0.0     160.0     0.0   130.0 117.0     153       212     34   247 2 0 85   0     160     0   130 117     153   212   34   247
1005803 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302405 342700010108 PS 108 CAPT VINCENT G FOWLER public Regular School No Elementary PK 05 2017   grade_2 12.0 7.0 125.0         103.0     0.0   135.0 112.0     25       208     36   247 12 7 125         103     0   135 112     25   208   36   247
1025373 NY Warren   school 3624030 630902030000   QUEENSBURY 362403003316 630902030001 QUEENSBURY ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2017   grade_2 234.0 1.0 3.0         3.0     6.0   125.0 122.0     *       101     36   247 234 1 3         3     6   125 122         101   36   247
2110787 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802739 342400010229 PS 229 EMANUEL KAPLAN public Regular School No Elementary PK 05 2018   grade_2 52.0 4.0 109.0   1.0     79.0     2.0   128.0 119.0     16       180     47   247 52 4 109   1     79     2   128 119     16   180   47   247
1003371 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802521 342400010143 PS 143 LOUIS ARMSTRONG public Regular School No Elementary KG 05 2017   grade_2 0.0 9.0 228.0   0.0     9.0     0.0   120.0 126.0     183       227     53   246 0 9 228   0     9     0   120 126     183   227   53   246
2199840 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2019   grade_2 5.0 7.0 218.0   0.0     15.0     1.0   113.0 133.0     66       206     41   246 5 7 218   0     15     1   113 133     66   206   41   246
775907 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102575 332000010160 PS 160 WILLIAM T SAMPSON public Regular School No 1 KG 5 2015   grade_2 9.0 1.0 23.0   0.0     212.0         124.0 121.0             158     14   245 9 1 23   0     212         124 121         158   14   245
802735 NY Ontario   school 3606330 430300050000   CANANDAIGUA 360633000415 430300050001 CANANDAIGUA PRIMARY-ELEMENTARY public Regular School No 1 PK 05 2015   grade_2 218.0 1.0 9.0   2.0     3.0     12.0   116.0 129.0             96     33   245 218 1 9   2     3     12   116 129         96   33   245
809290 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302268 342700010063 PS 63 OLD SOUTH public Regular School No 1 PK 05 2015   grade_2 26.0 6.0 135.0   5.0     69.0     4.0   126.0 119.0             203     37   245 26 6 135   5     69     4   126 119         203   37   245
809499 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302405 342700010108 PS 108 CAPT VINCENT G FOWLER public Regular School No 1 PK 05 2015   grade_2 16.0 17.0 82.0   1.0     129.0     0.0   122.0 123.0             206     39   245 16 17 82   1     129     0   122 123         206   39   245
980267 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2017   grade_2 201.0 6.0 22.0   1.0     2.0     13.0   119.0 126.0     *       126     29   245 201 6 22   1     2     13   119 126         126   29   245
1093013 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804146 342400010016 PS 16 NANCY DEBENEDITTIS SCHOOL (THE public Regular School No 1.0 KG 05 2016   grade_2 2.0 1.0 221.0   1.0     19.0     0.0   129.0 115.0             176     52   244 2 1 221   1     19     0   129 115         176   52   244
2226535 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2019   grade_2 8.0 47.0 174.0         1.0     13.0   136.0 107.0     81       208     29   243 8 47 174         1     13   136 107     81   208   29   243
806649 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804146 342400010016 PS 16 NANCY DEBENEDITTIS SCHOOL (THE public Regular School No 1 KG 05 2015   grade_2 0.0 1.0 230.0   1.0     9.0         134.0 107.0             *     46   241 0 1 230   1     9         134 107             46   241
1037875 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702332 321000010086 PS 86 KINGSBRIDGE HEIGHTS public Regular School No 1.0 PK 06 2016   grade_2 2.0 17.0 209.0   1.0     10.0     2.0   133.0 108.0             201     49   241 2 17 209   1     10     2   133 108         201   49   241
1520779 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2021   grade_2 19.0 38.0 180.0         1.0     3.0   124.0 117.0     77       186     20   241 19 38 180         1     3   124 117     77   186   20   241
1529177 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702332 321000010086 PS 86 KINGSBRIDGE HEIGHTS public Regular School No Elementary PK 06 2020   grade_2 9.0 12.0 208.0   0.0     12.0     0.0   123.0 118.0     81       216     56   241 9 12 208   0     12     0   123 118     81   216   56   241

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