Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_4 · 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 ▲
1543163 NY Erie   school 3616680 141901060000   LANCASTER 361668003289 141901060010 WILLIAM STREET SCHOOL public Regular School No Middle 04 06 2020   grade_4 402.0 6.0 9.0   0.0     6.0     12.0   227.0 208.0     5       101     73   435 402 6 9   0     6     12   227 208     5   101   73   435
2069293 NY Erie   school 3616680 141901060000   LANCASTER 361668003289 141901060010 WILLIAM STREET SCHOOL public Regular School No Middle 04 06 2018   grade_4 367.0 4.0 19.0   1.0     8.0     9.0   210.0 198.0     *       119     59   408 367 4 19   1     8     9   210 198         119   59   408
961896 NY Erie   school 3616680 141901060000   LANCASTER 361668003289 141901060010 WILLIAM STREET SCHOOL public Regular School No Elementary 04 6 2017   grade_4 362.0 3.0 15.0   0.0     6.0     15.0   214.0 187.0     *       106     74   401 362 3 15   0     6     15   214 187         106   74   401
2159030 NY Erie   school 3616680 141901060000   LANCASTER 361668003289 141901060010 WILLIAM STREET SCHOOL public Regular School No Middle 04 06 2019   grade_4 361.0 8.0 14.0   0.0     7.0     11.0   190.0 211.0     *       97     56   401 361 8 14   0     7     11   190 211         97   56   401
765060 NY Erie   school 3616680 141901060000   LANCASTER 361668003289 141901060010 WILLIAM STREET SCHOOL public Regular School No 2 04 6 2015   grade_4 362.0 4.0 19.0   1.0     5.0     8.0   211.0 188.0             85     55   399 362 4 19   1     5     8   211 188         85   55   399
1051690 NY Erie   school 3616680 141901060000   LANCASTER 361668003289 141901060010 WILLIAM STREET SCHOOL public Regular School No 2.0 04 6 2016   grade_4 360.0 2.0 12.0   1.0     5.0     13.0   201.0 192.0             89     65   393 360 2 12   1     5     13   201 192         89   65   393
1453141 NY Erie   school 3616680 141901060000   LANCASTER 361668003289 141901060010 WILLIAM STREET SCHOOL public Regular School No Middle 04 06 2021   grade_4 355.0 2.0 12.0   2.0     8.0     11.0   208.0 182.0     7       92     65   390 355 2 12   2     8     11   208 182     7   92   65   390
1029365 NY Westchester   school 3622020 661401030000   OSSINING 362202003120 661401030002 CLAREMONT SCHOOL public Regular School No Elementary 03 05 2017   grade_4 84.0 33.0 226.0         18.0     17.0   197.0 181.0     24       252     37   378 84 33 226         18     17   197 181     24   252   37   378
1003202 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2017   grade_4 5.0 1.0 295.0   4.0     70.0     0.0   199.0 176.0     139       197     76   375 5 1 295   4     70     0   199 176     139   197   76   375
1119558 NY Westchester   school 3622020 661401030000   OSSINING 362202003120 661401030002 CLAREMONT SCHOOL public Regular School No 1.0 03 05 2016   grade_4 74.0 37.0 231.0         14.0     11.0   193.0 174.0             234     36   367 74 37 231         14     11   193 174         234   36   367
806651 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_4 1.0 1.0 320.0   0.0     42.0         189.0 175.0             272     62   364 1 1 320   0     42         189 175         272   62   364
833099 NY Westchester   school 3622020 661401030000   OSSINING 362202003120 661401030002 CLAREMONT SCHOOL public Regular School No 1 03 05 2015   grade_4 90.0 31.0 200.0         29.0     13.0   181.0 182.0             204     44   363 90 31 200         29     13   181 182         204   44   363
2226366 NY Westchester   school 3622020 661401030000   OSSINING 362202003120 661401030002 CLAREMONT SCHOOL public Regular School No Elementary 03 05 2019   grade_4 62.0 34.0 240.0         12.0     15.0   187.0 176.0     55       251     48   363 62 34 240         12     15   187 176     55   251   48   363
2110276 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2018   grade_4 5.0 7.0 310.0   2.0     33.0     0.0   186.0 171.0     113       307     57   357 5 7 310   2     33     0   186 171     113   307   57   357
1520610 NY Westchester   school 3622020 661401030000   OSSINING 362202003120 661401030002 CLAREMONT SCHOOL public Regular School No Elementary 03 05 2021   grade_4 64.0 29.0 235.0         8.0     16.0   185.0 167.0     *       220     45   352 64 29 235         8     16   185 167         220   45   352
2136705 NY Westchester   school 3622020 661401030000   OSSINING 362202003120 661401030002 CLAREMONT SCHOOL public Regular School No Elementary 02 05 2018   grade_4 79.0 43.0 204.0         13.0     11.0   189.0 161.0     40       216     49   350 79 43 204         13     11   189 161     40   216   49   350
965107 NY Jefferson   school 3615300 220301060000   INDIAN RIVER 361530005044 220301060010 INDIAN RIVER INTERMEDIATE SCHOOL public Regular School No Elementary 04 5 2017   grade_4 220.0 42.0 50.0   2.0     11.0     21.0   177.0 169.0     19       200     58   346 220 42 50   2     11     21   177 169     19   200   58   346
1109355 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No 2.0 04 05 2016   grade_4 156.0 58.0 110.0   3.0     10.0     9.0   193.0 153.0             209     46   346 156 58 110   3     10     9   193 153         209   46   346
2110542 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2018   grade_4 6.0 0.0 263.0   3.0     72.0     1.0   153.0 192.0     141       275     47   345 6 0 263   3     72     1   153 192     141   275   47   345
803212 NY Ontario   school 3629640 431701060000   VICTOR 362964003993 431701060001 VICTOR INTERMEDIATE SCHOOL public Regular School No 2 04 06 2015   grade_4 302.0 11.0 13.0   4.0     5.0     8.0   164.0 179.0             56     45   343 302 11 13   4     5     8   164 179         56   45   343
1093433 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_4 1.0 10.0 316.0   1.0     12.0     0.0   186.0 154.0             313     70   340 1 10 316   1     12     0   186 154         313   70   340
1584146 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804146 342400010016 PS 16 NANCY DEBENEDITTIS SCHOOL (THE public Regular School No Elementary KG 05 2020   grade_4 7.0   303.0   1.0     29.0         173.0 167.0     132       300     78   340 7   303   1     29         173 167     132   300   78   340
1002955 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804146 342400010016 PS 16 NANCY DEBENEDITTIS SCHOOL (THE public Regular School No Elementary KG 05 2017   grade_4 0.0 1.0 318.0   1.0     16.0     0.0   180.0 156.0     118       218     69   336 0 1 318   1     16     0   180 156     118   218   69   336
1610727 NY Westchester   school 3622020 661401030000   OSSINING 362202003120 661401030002 CLAREMONT SCHOOL public Regular School No Elementary 03 05 2020   grade_4 67.0 27.0 217.0         12.0     13.0   176.0 160.0     47       213     27   336 67 27 217         12     13   176 160     47   213   27   336
1093015 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_4 1.0 1.0 298.0   0.0     35.0     0.0   182.0 153.0             212     61   335 1 1 298   0     35     0   182 153         212   61   335
1093262 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_4 6.0 1.0 255.0   1.0     72.0         168.0 167.0             177     59   335 6 1 255   1     72         168 167         177   59   335
806898 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No 1 KG 05 2015   grade_4 1.0 0.0 252.0   2.0     79.0     0.0   158.0 176.0             208     56   334 1 0 252   2     79     0   158 176         208   56   334
2199880 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_4 3.0 4.0 303.0   1.0     23.0     0.0   182.0 152.0     167       293     68   334 3 4 303   1     23     0   182 152     167   293   68   334
2200108 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2019   grade_4 6.0 1.0 255.0   1.0     71.0     0.0   188.0 146.0     136       263     65   334 6 1 255   1     71     0   188 146     136   263   65   334
1003373 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_4 1.0 6.0 307.0   0.0     19.0     0.0   169.0 164.0     115       309     77   333 1 6 307   0     19     0   169 164     115   309   77   333
967881 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_4 17.0 4.0 137.0   0.0     171.0     1.0   170.0 160.0     153       238     64   330 17 4 137   0     171     1   170 160     153   238   64   330
1019200 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No Elementary 04 05 2017   grade_4 127.0 56.0 116.0   4.0     8.0     19.0   151.0 179.0     24       *     *   330 127 56 116   4     8     19   151 179     24           330
2110314 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_4 1.0 1.0 308.0   1.0     19.0     0.0   152.0 178.0     167       305     77   330 1 1 308   1     19     0   152 178     167   305   77   330
1089576 NY Ontario   school 3629640 431701060000   VICTOR 362964003993 431701060001 VICTOR INTERMEDIATE SCHOOL public Regular School No 2.0 04 06 2016   grade_4 284.0 6.0 19.0   1.0     11.0     8.0   156.0 173.0             63     37   329 284 6 19   1     11     8   156 173         63   37   329
1092996 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_4 5.0 10.0 284.0   1.0     27.0     1.0   171.0 157.0             221     60   328 5 10 284   1     27     1   171 157         221   60   328
2196460 NY Ontario   school 3629640 431701060000   VICTOR 362964003993 431701060001 VICTOR INTERMEDIATE SCHOOL public Regular School No Middle 04 06 2019   grade_4 277.0 7.0 21.0   1.0     9.0     11.0   158.0 168.0     8       81     43   326 277 7 21   1     9     11   158 168     8   81   43   326
822915 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No 2 04 05 2015   grade_4 151.0 58.0 102.0   3.0     5.0     5.0   176.0 148.0             173     33   324 151 58 102   3     5     5   176 148         173   33   324
2124735 NY Suffolk   school 3608880 580107030000   DEER PARK 360888004715 580107030008 JOHN F KENNEDY INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2018   grade_4 129.0 65.0 77.0   0.0     43.0     10.0   155.0 169.0     20       142     59   324 129 65 77   0     43     10   155 169     20   142   59   324
1580726 NY Ontario   school 3629640 431701060000   VICTOR 362964003993 431701060001 VICTOR INTERMEDIATE SCHOOL public Regular School No Middle 04 06 2020   grade_4 261.0 6.0 24.0   1.0     11.0     19.0   164.0 158.0     9       83     43   322 261 6 24   1     11     19   164 158     9   83   43   322
999497 NY Ontario   school 3629640 431701060000   VICTOR 362964003993 431701060001 VICTOR INTERMEDIATE SCHOOL public Regular School No Elementary 04 06 2017   grade_4 270.0 5.0 26.0   0.0     6.0     14.0   158.0 163.0     5       53     34   321 270 5 26   0     6     14   158 163     5   53   34   321
2110295 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804146 342400010016 PS 16 NANCY DEBENEDITTIS SCHOOL (THE public Regular School No Elementary KG 05 2018   grade_4 2.0 1.0 295.0   1.0     21.0     0.0   171.0 149.0     134       283     65   320 2 1 295   1     21     0   171 149     134   283   65   320
1584393 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2020   grade_4 6.0 0.0 253.0   1.0     59.0     0.0   146.0 173.0     121       261     68   319 6 0 253   1     59     0   146 173     121   261   68   319
2106875 NY Ontario   school 3629640 431701060000   VICTOR 362964003993 431701060001 VICTOR INTERMEDIATE SCHOOL public Regular School No Middle 04 06 2018   grade_4 272.0 8.0 15.0   4.0     10.0     10.0   160.0 159.0     *       71     *   319 272 8 15   4     10     10   160 159         71       319
806670 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_4 0.0 1.0 286.0   0.0     29.0     0.0   174.0 142.0             233     53   316 0 1 286   0     29     0   174 142         233   53   316
2126597 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No Elementary 04 05 2018   grade_4 114.0 58.0 126.0   1.0     3.0     14.0   168.0 148.0     44       192     53   316 114 58 126   1     3     14   168 148     44   192   53   316
1002936 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2017   grade_4 3.0 10.0 272.0   4.0     23.0     0.0   159.0 153.0     92       212     52   312 3 10 272   4     23     0   159 153     92   212   52   312
1002974 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_4 1.0 4.0 283.0   0.0     23.0     1.0   161.0 151.0     133       252     76   312 1 4 283   0     23     1   161 151     133   252   76   312
1054958 NY Jefferson   school 3615300 220301060000   INDIAN RIVER 361530005044 220301060010 INDIAN RIVER INTERMEDIATE SCHOOL public Regular School No 2.0 04 5 2016   grade_4 192.0 29.0 59.0   1.0     8.0     21.0   159.0 151.0             165     39   310 192 29 59   1     8     21   159 151         165   39   310
1107455 NY Suffolk   school 3608880 580107030000   DEER PARK 360888004715 580107030008 JOHN F KENNEDY INTERMEDIATE SCHOOL public Regular School No 1.0 03 05 2016   grade_4 138.0 48.0 77.0   0.0     36.0     9.0   159.0 149.0             149     40   308 138 48 77   0     36     9   159 149         149   40   308
2199861 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804146 342400010016 PS 16 NANCY DEBENEDITTIS SCHOOL (THE public Regular School No Elementary KG 05 2019   grade_4 2.0 0.0 287.0   3.0     15.0         155.0 152.0     121       269     56   307 2 0 287   3     15         155 152     121   269   56   307
768366 NY Jefferson   school 3615300 220301060000   INDIAN RIVER 361530005044 220301060010 INDIAN RIVER INTERMEDIATE SCHOOL public Regular School No 2 04 5 2015   grade_4 188.0 40.0 40.0   1.0     9.0     27.0   155.0 150.0             167     43   305 188 40 40   1     9     27   155 150         167   43   305
1067232 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000273 260101060010 FRENCH ROAD ELEMENTARY SCHOOL public Regular School No 1.0 03 05 2016   grade_4 206.0 13.0 19.0         36.0     31.0   156.0 149.0             32     29   305 206 13 19         36     31   156 149         32   29   305
1584127 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2020   grade_4 9.0 9.0 273.0   1.0     9.0     1.0   153.0 149.0     108       265     68   302 9 9 273   1     9     1   153 149     108   265   68   302
1093034 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_4 1.0 1.0 273.0   0.0     26.0     0.0   155.0 146.0             220     90   301 1 1 273   0     26     0   155 146         220   90   301
775852 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_4 7.0 0.0 15.0   1.0     277.0         147.0 153.0             222     30   300 7 0 15   1     277         147 153         222   30   300
806632 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No 1 KG 05 2015   grade_4 8.0 15.0 254.0   1.0     22.0     0.0   145.0 155.0             200     42   300 8 15 254   1     22     0   145 155         200   42   300
2072447 NY Jefferson   school 3615300 220301060000   INDIAN RIVER 361530005044 220301060010 INDIAN RIVER INTERMEDIATE SCHOOL public Regular School No Elementary 04 05 2018   grade_4 205.0 28.0 36.0   0.0     4.0     26.0   150.0 149.0     9       163     40   299 205 28 36   0     4     26   150 149     9   163   40   299
2110713 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802521 342400010143 PS 143 LOUIS ARMSTRONG public Regular School No Elementary KG 05 2018   grade_4 1.0 2.0 279.0   0.0     16.0     0.0   154.0 144.0     134       289     79   298 1 2 279   0     16     0   154 144     134   289   79   298
1584165 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_4 1.0 0.0 282.0         12.0     0.0   142.0 153.0     141       267     75   295 1 0 282         12     0   142 153     141   267   75   295
1017357 NY Suffolk   school 3608880 580107030000   DEER PARK 360888004715 580107030008 JOHN F KENNEDY INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2017   grade_4 115.0 60.0 69.0   1.0     36.0     13.0   145.0 149.0     18       150     46   294 115 60 69   1     36     13   145 149     18   150   46   294
807069 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_4 0.0 3.0 282.0   0.0     8.0         160.0 133.0             278     54   293 0 3 282   0     8         160 133         278   54   293
2162184 NY Jefferson   school 3615300 220301060000   INDIAN RIVER 361530005044 220301060010 INDIAN RIVER INTERMEDIATE SCHOOL public Regular School No Elementary 04 05 2019   grade_4 190.0 29.0 52.0   2.0     1.0     19.0   140.0 153.0     7       173     46   293 190 29 52   2     1     19   140 153     7   173   46   293
780754 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000273 260101060010 FRENCH ROAD ELEMENTARY SCHOOL public Regular School No 1 03 05 2015   grade_4 204.0 18.0 12.0         36.0     21.0   129.0 162.0             49     34   291 204 18 12         36     21   129 162         49   34   291
1062368 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_4 9.0 1.0 14.0         266.0     0.0   144.0 146.0             188     27   290 9 1 14         266     0   144 146         188   27   290
1002917 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_4 13.0 24.0 158.0   0.0     94.0     0.0   141.0 148.0     77       161     39   289 13 24 158   0     94     0   141 148     77   161   39   289
1057789 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_4 7.0 3.0 120.0   0.0     158.0     0.0   157.0 131.0             216     53   288 7 3 120   0     158     0   157 131         216   53   288
1089101 NY Ontario   school 3606330 430300050000   CANANDAIGUA 360633000415 430300050001 CANANDAIGUA PRIMARY-ELEMENTARY public Regular School No 1.0 PK 05 2016   grade_4 246.0 6.0 12.0   0.0     8.0     15.0   137.0 150.0             124     40   287 246 6 12   0     8     15   137 150         124   40   287
2110257 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_4 8.0 31.0 156.0   1.0     91.0     0.0   138.0 149.0     77       214     37   287 8 31 156   1     91     0   138 149     77   214   37   287
1546298 NY Jefferson   school 3615300 220301060000   INDIAN RIVER 361530005044 220301060010 INDIAN RIVER INTERMEDIATE SCHOOL public Regular School No Elementary 04 05 2020   grade_4 187.0 17.0 45.0   2.0     7.0     28.0   145.0 141.0     6       189     54   286 187 17 45   2     7     28   145 141     6   189   54   286
2199842 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2019   grade_4 2.0 10.0 259.0   0.0     14.0     0.0   152.0 133.0     94       238     62   285 2 10 259   0     14     0   152 133     94   238   62   285
2216239 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No Elementary 04 05 2019   grade_4 98.0 47.0 116.0   1.0     5.0     18.0   135.0 150.0     *       193     43   285 98 47 116   1     5     18   135 150         193   43   285
1494219 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2021   grade_4 4.0 1.0 214.0   1.0     64.0     0.0   141.0 143.0     128       241     53   284 4 1 214   1     64     0   141 143     128   241   53   284
1490571 NY Ontario   school 3629640 431701060000   VICTOR 362964003993 431701060001 VICTOR INTERMEDIATE SCHOOL public Regular School No Middle 04 06 2021   grade_4 239.0 4.0 22.0   0.0     3.0     15.0   144.0 139.0     6       69     28   283 239 4 22   0     3     15   144 139     6   69   28   283
2199823 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_4 9.0 25.0 171.0   1.0     75.0     2.0   145.0 138.0     79       217     40   283 9 25 171   1     75     2   145 138     79   217   40   283
806613 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_4 4.0 21.0 166.0   2.0     86.0     3.0   155.0 127.0             176     36   282 4 21 166   2     86     3   155 127         176   36   282
821015 NY Suffolk   school 3608880 580107030000   DEER PARK 360888004715 580107030008 JOHN F KENNEDY INTERMEDIATE SCHOOL public Regular School No 1 03 05 2015   grade_4 137.0 46.0 62.0   1.0     29.0     5.0   160.0 120.0             135     38   280 137 46 62   1     29     5   160 120         135   38   280
2214377 NY Suffolk   school 3608880 580107030000   DEER PARK 360888004715 580107030008 JOHN F KENNEDY INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2019   grade_4 94.0 54.0 82.0   1.0     38.0     11.0   135.0 145.0     25       153     46   280 94 54 82   1     38     11   135 145     25   153   46   280
1007857 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102362 342900010095 PS 95 EASTWOOD public Regular School No Elementary KG 05 2017   grade_4 3.0 24.0 123.0   13.0     115.0     1.0   137.0 142.0     68       170     36   279 3 24 123   13     115     1   137 142     68   170   36   279
1062501 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102618 332000010176 PS 176 OVINGTON public Regular School No 1.0 KG 5 2016   grade_4 46.0 2.0 61.0         168.0     2.0   146.0 133.0             245     42   279 46 2 61         168     2   146 133         245   42   279
2084531 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000273 260101060010 FRENCH ROAD ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2018   grade_4 192.0 15.0 17.0         33.0     22.0   158.0 121.0     14       57     37   279 192 15 17         33     22   158 121     14   57   37   279
1493972 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804146 342400010016 PS 16 NANCY DEBENEDITTIS SCHOOL (THE public Regular School No Elementary KG 05 2021   grade_4 5.0 0.0 244.0   0.0     29.0     0.0   127.0 151.0     123       244     54   278 5 0 244   0     29     0   127 151     123   244   54   278
1092977 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_4 8.0 29.0 154.0   1.0     85.0     0.0   142.0 135.0             162     *   277 8 29 154   1     85     0   142 135         162       277
1110438 NY Suffolk   school 3608130 580410030000   COMMACK 360813000577 580410030020 BURR INTERMEDIATE SCHOOL public Regular School No 1.0 03 05 2016   grade_4 240.0 0.0 18.0         17.0     2.0   137.0 140.0             15     48   277 240 0 18         17     2   137 140         15   48   277
1110628 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000169 580501030002 GARDINER MANOR SCHOOL public Regular School No 1.0 03 05 2016   grade_4 74.0 51.0 128.0   1.0     16.0     7.0   136.0 141.0             160     41   277 74 51 128   1     16     7   136 141         160   41   277
811477 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102362 342900010095 PS 95 EASTWOOD public Regular School No 1 KG 05 2015   grade_4 8.0 27.0 109.0   10.0     121.0     1.0   145.0 131.0             195     37   276 8 27 109   10     121     1   145 131         195   37   276
1598757 NY Suffolk   school 3608880 580107030000   DEER PARK 360888004715 580107030008 JOHN F KENNEDY INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2020   grade_4 96.0 61.0 77.0   0.0     35.0     7.0   130.0 146.0     17       149     41   276 96 61 77   0     35     7   130 146     17   149   41   276
1558477 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000273 260101060010 FRENCH ROAD ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2020   grade_4 184.0 21.0 19.0         27.0     22.0   134.0 139.0     19       61     37   273 184 21 19         27     22   134 139     19   61   37   273
2106400 NY Ontario   school 3606330 430300050000   CANANDAIGUA 360633000415 430300050001 CANANDAIGUA PRIMARY-ELEMENTARY public Regular School No Elementary PK 05 2018   grade_4 237.0 1.0 18.0   0.0     5.0     12.0   152.0 121.0     *       110     51   273 237 1 18   0     5     12   152 121         110   51   273
2217493 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000169 580501030002 GARDINER MANOR SCHOOL public Regular School No Elementary 03 05 2019   grade_4 61.0 48.0 142.0   0.0     10.0     12.0   138.0 135.0     31       180     44   273 61 48 142   0     10     12   138 135     31   180   44   273
1612779 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2020   grade_4 189.0 8.0 49.0   1.0     19.0     6.0   131.0 141.0     6       32     34   272 189 8 49   1     19     6   131 141     6   32   34   272
2107559 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932006448 441000010018 PRESIDENTIAL PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_4 40.0 41.0 168.0   0.0     10.0     13.0   140.0 132.0     66       221     42   272 40 41 168   0     10     13   140 132     66   221   42   272
2226518 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003179 661500010001 HILLCREST SCHOOL public Regular School No Elementary 03 05 2019   grade_4 22.0 51.0 185.0         3.0     9.0   155.0 115.0     66       230     36   270 22 51 185         3     9   155 115     66   230   36   270
980307 NY Monroe   school 3605580 261801060000   BROCKPORT 360558004579 261801060006 FRED W HILL SCHOOL public Regular School No Elementary 04 06 2017   grade_4 223.0 10.0 17.0         3.0     16.0   133.0 136.0     5       133     42   269 223 10 17         3     16   133 136     5   133   42   269
1031417 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2017   grade_4 195.0 9.0 40.0         19.0     6.0   137.0 132.0     *       28     31   269 195 9 40         19     6   137 132         28   31   269
1493991 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_4 1.0 1.0 260.0         7.0     0.0   148.0 121.0     151       236     60   269 1 1 260         7     0   148 121     151   236   60   269
1600619 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No Elementary 04 05 2020   grade_4 100.0 52.0 100.0         4.0     13.0   130.0 139.0     *       *     38   269 100 52 100         4     13   130 139             38   269
2079762 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102618 332000010176 PS 176 OVINGTON public Regular School No Elementary KG 05 2018   grade_4 28.0 0.0 58.0   0.0     182.0     1.0   132.0 137.0     65       233     33   269 28 0 58   0     182     1   132 137     65   233   33   269
972384 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_4 11.0 0.0 15.0         240.0     0.0   122.0 144.0     88       162     19   266 11 0 15         240     0   122 144     88   162   19   266
2113183 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 2018   grade_4 9.0 22.0 96.0   0.0     139.0     0.0   139.0 127.0     18       223     43   266 9 22 96   0     139     0   139 127     18   223   43   266
2197144 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932006448 441000010018 PRESIDENTIAL PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_4 31.0 49.0 168.0   0.0     6.0     12.0   127.0 139.0     63       202     32   266 31 49 168   0     6     12   127 139     63   202   32   266

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