Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_2", state = "NY" and year = 2019 sorted by low_income_int descending

View and edit SQL

year

  • 2019 · 4,719

grade

  • grade_2 · 4,719
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
2191613 NY Niagara   school 3620760 400601060000   NEWFANE 362076001415 400601060001 NEWFANE EARLY CHLDHD CTR public Regular School No Prekindergarten PK PK 2019   grade_2 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2207003 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No Elementary KG 01 2019   grade_2 0.0 0.0 0.0         0.0         0.0 0.0     *             *   0 0 0 0         0         0 0                 0
2216370 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2019   grade_2 10.0 1.0 3.0               0.0   7.0 7.0     *                 14 10 1 3               0   7 7                 14
2216446 NY Suffolk   school 3619710 580306020000   MONTAUK 361971001805 580306020001 MONTAUK SCHOOL public Regular School No Elementary PK 08 2019   grade_2 15.0 1.0 6.0         0.0     0.0   13.0 9.0     *             *   22 15 1 6         0     0   13 9                 22
2218897 NY Suffolk   school 3621540 580514020000   FIRE ISLAND 362154003056 580514020001 WOODHULL SCHOOL public Regular School No Elementary PK 06 2019   grade_2 2.0 0.0 0.0         0.0         1.0 1.0     *             *   2 2 0 0         0         1 1                 2
2219733 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2019   grade_2 6.0   0.0                   2.0 4.0                       6 6   0                   2 4                 6
2219904 NY Suffolk   school 3611100 581004020000   FISHERS ISLAND 361110000884 581004020001 FISHERS ISLAND SCHOOL public Regular School No Other PK 12 2019   grade_2 2.0 0.0 1.0               0.0   1.0 2.0                   0   3 2 0 1               0   1 2             0   3
2220037 NY Suffolk   school 3620520 581015080000   NEW SUFFOLK 362052001905 581015080001 NEW SUFFOLK SCHOOL public Regular School No Elementary PK 06 2019   grade_2 1.0   0.0                   0.0 1.0     *             *   1 1   0                   0 1                 1
2224635 NY Westchester   school 3610200 660406030000   EDGEMONT 361020004508 660406030002 SEELY PLACE SCHOOL public Regular School No Elementary KG 06 2019   grade_2 43.0 0.0 6.0         29.0     6.0   42.0 42.0     *             7   84 43 0 6         29     6   42 42             7   84
2226763 NY Westchester   school 3625260 661800010000   RYE 362526003490 661800010002 MILTON SCHOOL public Regular School No Elementary KG 05 2019   grade_2 59.0   2.0   1.0     2.0     1.0   36.0 29.0     *             8   65 59   2   1     2     1   36 29             8   65
2227086 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003560 662001030001 EDGEWOOD SCHOOL public Regular School No Elementary KG 05 2019   grade_2 30.0 0.0 5.0         16.0     6.0   30.0 27.0     0             *   57 30 0 5         16     6   30 27     0           57
2227105 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003561 662001030002 FOX MEADOW SCHOOL public Regular School No Elementary KG 05 2019   grade_2 36.0 1.0 7.0   0.0     18.0     9.0   37.0 34.0     *             *   71 36 1 7   0     18     9   37 34                 71
2227124 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003562 662001030003 GREENACRES SCHOOL public Regular School No Elementary KG 05 2019   grade_2 40.0   0.0         12.0     3.0   27.0 28.0     *             7   55 40   0         12     3   27 28             7   55
2227143 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003563 662001030004 HEATHCOTE SCHOOL public Regular School No Elementary KG 05 2019   grade_2 43.0 0.0 5.0         22.0     5.0   40.0 35.0     *             *   75 43 0 5         22     5   40 35                 75
2227162 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003564 662001030005 QUAKER RIDGE SCHOOL public Regular School No Elementary KG 05 2019   grade_2 53.0 1.0 9.0   0.0     19.0     1.0   42.0 41.0     *             19   83 53 1 9   0     19     1   42 41             19   83
2227181 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003566 662001030010 SCARSDALE SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0             0   0 0 0 0   0     0     0   0 0     0       0   0
2227200 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003565 662001030011 SCARSDALE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
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
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
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
2218536 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 5.0 12.0 214.0   1.0     1.0     1.0   107.0 127.0     105       218     19   234 5 12 214   1     1     1   107 127     105   218   19   234
2214470 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No Elementary PK 02 2019   grade_2 2.0 95.0 121.0         1.0     0.0   104.0 115.0     91       210     28   219 2 95 121         1     0   104 115     91   210   28   219
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
2169307 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102396 332000010105 PS 105 BLYTHEBOURNE (THE) public Regular School No Elementary KG 05 2019   grade_2 6.0 1.0 13.0   0.0     211.0         117.0 114.0     95       207     21   231 6 1 13   0     211         117 114     95   207   21   231
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
2164747 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No Elementary KG 05 2019   grade_2 5.0 0.0 47.0   0.0     155.0     0.0   112.0 95.0     118       205     *   207 5 0 47   0     155     0   112 95     118   205       207
2164918 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202602 331500010169 PS 169 SUNSET PARK public Regular School No Elementary KG 05 2019   grade_2 11.0 0.0 56.0   0.0     153.0     0.0   107.0 113.0     119       203     48   220 11 0 56   0     153     0   107 113     119   203   48   220
2145101 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702332 321000010086 PS 86 KINGSBRIDGE HEIGHTS public Regular School No Elementary PK 06 2019   grade_2 2.0 10.0 208.0   1.0     10.0     0.0   108.0 123.0     74       202     47   231 2 10 208   1     10     0   108 123     74   202   47   231
2197142 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932006448 441000010018 PRESIDENTIAL PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 22.0 37.0 165.0   0.0     3.0     10.0   116.0 121.0     88       195     24   237 22 37 165   0     3     10   116 121     88   195   24   237
2200866 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202105 342500010020 PS 20 JOHN BOWNE public Regular School No Elementary PK 05 2019   grade_2 5.0 6.0 41.0   1.0     158.0     1.0   108.0 104.0     87       192     36   212 5 6 41   1     158     1   108 104     87   192   36   212
2145139 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702357 321000010094 PS 94 KINGS COLLEGE SCHOOL public Regular School No Elementary KG 05 2019   grade_2 6.0 38.0 147.0   5.0     11.0     0.0   112.0 95.0     51       190     51   207 6 38 147   5     11     0   112 95     51   190   51   207
2169573 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102679 332000010200 PS 200 BENSON SCHOOL public Regular School No Elementary PK 05 2019   grade_2 96.0 1.0 58.0   3.0     71.0     1.0   117.0 113.0     52       188     *   230 96 1 58   3     71     1   117 113     52   188       230
2199783 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801406 342400010007 PS 7 LOUIS F SIMEONE public Regular School No Elementary PK 05 2019   grade_2 8.0 1.0 73.0   0.0     136.0     0.0   115.0 103.0     119       185     25   218 8 1 73   0     136     0   115 103     119   185   25   218
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
2199859 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_2 4.0 0.0 184.0   0.0     31.0         104.0 115.0     109       183     38   219 4 0 184   0     31         104 115     109   183   38   219
2202766 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 2019   grade_2 16.0 6.0 144.0   1.0     57.0     3.0   114.0 113.0     35       180     40   227 16 6 144   1     57     3   114 113     35   180   40   227
2143353 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602288 320900010070 PS 70 MAX SCHOENFELD public Regular School No Elementary KG 05 2019   grade_2 2.0 55.0 131.0   0.0     1.0         91.0 98.0     62       179     32   189 2 55 131   0     1         91 98     62   179   32   189
2200353 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802739 342400010229 PS 229 EMANUEL KAPLAN public Regular School No Elementary PK 05 2019   grade_2 42.0 4.0 98.0   0.0     87.0     2.0   117.0 116.0     15       176     48   233 42 4 98   0     87     2   117 116     15   176   48   233
2218517 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 3.0 11.0 168.0   2.0     1.0     0.0   103.0 82.0     83       174     28   185 3 11 168   2     1     0   103 82     83   174   28   185
2169364 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102575 332000010160 PS 160 WILLIAM T SAMPSON public Regular School No Elementary KG 05 2019   grade_2 5.0 1.0 19.0   0.0     171.0     0.0   93.0 103.0     149       173     25   196 5 1 19   0     171     0   93 103     149   173   25   196
2169440 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102618 332000010176 PS 176 OVINGTON public Regular School No Elementary KG 05 2019   grade_2 23.0 2.0 43.0   0.0     132.0     0.0   100.0 100.0     59       172     28   200 23 2 43   0     132     0   100 100     59   172   28   200
2169421 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102603 332000010170 RALPH A FABRIZIO SCHOOL public Regular School No Elementary KG 05 2019   grade_2 39.0 1.0 35.0   3.0     101.0     1.0   99.0 81.0     71       171     32   180 39 1 35   3     101     1   99 81     71   171   32   180
2204875 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102362 342900010095 PS 95 EASTWOOD public Regular School No Elementary KG 05 2019   grade_2 2.0 20.0 107.0   8.0     97.0     1.0   118.0 117.0     66       170     25   235 2 20 107   8     97     1   118 117     66   170   25   235
2214242 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No Elementary 01 03 2019   grade_2 5.0 83.0 103.0   0.0     7.0     7.0   101.0 104.0     34       169     24   205 5 83 103   0     7     7   101 104     34   169   24   205
2199802 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No Elementary KG 05 2019   grade_2 10.0 0.0 86.0   0.0     92.0     1.0   102.0 87.0     53       166     36   189 10 0 86   0     92     1   102 87     53   166   36   189
2200182 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806323 342400010110 PS 110 public Regular School No Elementary KG 05 2019   grade_2 0.0 0.0 161.0   0.0     16.0         97.0 80.0     76       165     27   177 0 0 161   0     16         97 80     76   165   27   177
2200885 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202109 342500010021 PS 21 EDWARD HART public Regular School No Elementary PK 05 2019   grade_2 9.0 5.0 71.0   0.0     132.0     1.0   109.0 109.0     55       164     30   218 9 5 71   0     132     1   109 109     55   164   30   218
2143277 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602232 320900010053 PS 53 BASHEER QUISIM public Regular School No Elementary PK 05 2019   grade_2 5.0 50.0 115.0   1.0     3.0         82.0 92.0     71       162     25   174 5 50 115   1     3         82 92     71   162   25   174
2164538 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202041 331500010001 PS 1 BERGEN (THE) public Regular School No Elementary PK 05 2019   grade_2 8.0 3.0 163.0   0.0     14.0     1.0   96.0 93.0     88       162     36   189 8 3 163   0     14     1   96 93     88   162   36   189
2147913 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002209 321200010047 PS 47 JOHN RANDOLPH public Regular School No Elementary KG 05 2019   grade_2 4.0 28.0 106.0   8.0     24.0     1.0   77.0 94.0     38       160     38   171 4 28 106   8     24     1   77 94     38   160   38   171
2159503 NY Erie   school 3600025 142601860031   CHARTER SCHOOL FOR APPLIED TE 360002504349 142601860031 CHARTER SCHOOL FOR APPLIED TECHNOLOG charter Regular School Yes Other KG 12 2019   grade_2 31.0 63.0 53.0   2.0     25.0     10.0   92.0 92.0     12       160     21   184 31 63 53   2     25     10   92 92     12   160   21   184
2218422 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000260 580512030001 SOUTHWEST ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 14.0 23.0 135.0   0.0     6.0     1.0   99.0 80.0     56       160     37   179 14 23 135   0     6     1   99 80     56   160   37   179
2218612 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 3.0 10.0 153.0   0.0     2.0     0.0   93.0 75.0     84       160     17   168 3 10 153   0     2     0   93 75     84   160   17   168
2148103 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003353 321200010195 PS 195 public Regular School No Elementary PK 05 2019   grade_2 1.0 30.0 125.0   3.0     5.0     0.0   85.0 79.0     70       159     34   164 1 30 125   3     5     0   85 79     70   159   34   164
2209340 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001148 500201060012 WEST HAVERSTRAW ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 18.0 35.0 139.0   0.0     3.0     2.0   95.0 102.0     57       159     31   197 18 35 139   0     3     2   95 102     57   159   31   197
2200429 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806060 342400010307 PIONEER ACADEMY public Regular School No Elementary KG 05 2019   grade_2 3.0 0.0 147.0   1.0     4.0     0.0   76.0 79.0     72       151     38   155 3 0 147   1     4     0   76 79     72   151   38   155
2209777 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003770 500402060001 FLEETWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 4.0 28.0 131.0   1.0     2.0         89.0 77.0     93       149     7   166 4 28 131   1     2         89 77     93   149   7   166
2145215 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702691 321000010205 PS 205 FIORELLO LAGUARDIA public Regular School No Elementary KG 05 2019   grade_2 9.0 14.0 133.0   3.0     2.0     0.0   87.0 74.0     50       148     45   161 9 14 133   3     2     0   87 74     50   148   45   161
2169269 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102385 332000010102 PS 102 BAYVIEW (THE) public Regular School No Elementary KG 05 2019   grade_2 117.0 2.0 68.0   1.0     40.0     5.0   125.0 108.0     37       146     54   233 117 2 68   1     40     5   125 108     37   146   54   233
2202519 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302259 342700010060 PS 60 WOODHAVEN public Regular School No Elementary PK 05 2019   grade_2 5.0 4.0 125.0   6.0     39.0     2.0   97.0 84.0     41       146     27   181 5 4 125   6     39     2   97 84     41   146   27   181
2202557 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302268 342700010063 PS 63 OLD SOUTH public Regular School No Elementary PK 05 2019   grade_2 10.0 10.0 91.0   6.0     63.0     4.0   92.0 92.0     26       144     33   184 10 10 91   6     63     4   92 92     26   144   33   184
2145082 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705139 321000010085 PS 85 GREAT EXPECTATIONS public Regular School No Elementary PK 05 2019   grade_2 0.0 38.0 103.0   0.0     4.0     1.0   92.0 54.0     58       141     35   146 0 38 103   0     4     1   92 54     58   141   35   146
2209853 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003776 500402060005 MARGETTS ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 6.0 38.0 96.0   0.0     12.0     1.0   83.0 70.0     78       141     7   153 6 38 96   0     12     1   83 70     78   141   7   153
2209891 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781004569 500402060010 SUMMIT PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 3.0 46.0 105.0         2.0     4.0   70.0 90.0     60       141     17   160 3 46 105         2     4   70 90     60   141   17   160
2218555 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000256 580512030009 OAK PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 2.0 19.0 126.0   1.0     3.0     0.0   75.0 76.0     63       141     *   151 2 19 126   1     3     0   75 76     63   141       151
2146526 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802185 321100010041 PS 41 GUN HILL ROAD public Regular School No Elementary KG 05 2019   grade_2 4.0 61.0 75.0   1.0     3.0         73.0 71.0     14       140     30   144 4 61 75   1     3         73 71     14   140   30   144
2200904 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202115 342500010022 PS 22 THOMAS JEFFERSON public Regular School No Elementary PK 05 2019   grade_2 4.0 0.0 50.0   2.0     95.0     2.0   84.0 69.0     94       140     22   153 4 0 50   2     95     2   84 69     94   140   22   153
2176242 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003404 261600010033 SCHOOL 33-AUDUBON public Regular School No Elementary PK 06 2019   grade_2 7.0 76.0 69.0   0.0     0.0     0.0   73.0 79.0     30       139     26   152 7 76 69   0     0     0   73 79     30   139   26   152
2142365 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502547 320800010152 PS 152 EVERGREEN public Regular School No Elementary KG 05 2019   grade_2 1.0 24.0 117.0   2.0     5.0     0.0   65.0 84.0     42       137     31   149 1 24 117   2     5     0   65 84     42   137   31   149
2169820 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105877 332000010506 PS 506 JOURNALISM AND TECHNOLOGY public Regular School No Elementary KG 05 2019   grade_2 6.0 2.0 103.0   0.0     37.0     0.0   75.0 73.0     48       137     27   148 6 2 103   0     37     0   75 73     48   137   27   148
2179776 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 LAWRENCE PRIMARY SCHOOL-#2 SCHOOL public Regular School No Elementary KG 03 2019   grade_2 26.0 17.0 110.0   1.0     8.0         79.0 83.0     55       137     *   162 26 17 110   1     8         79 83     55   137       162
2218498 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000252 580512030005 LORETTA PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 2.0 15.0 122.0   0.0     1.0     2.0   71.0 71.0     49       136     13   142 2 15 122   0     1     2   71 71     49   136   13   142
2171131 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302717 332200010217 PS 217 COL DAVID MARCUS SCHOOL public Regular School No Elementary PK 05 2019   grade_2 32.0 22.0 29.0   0.0     87.0     7.0   92.0 85.0     50       135     27   177 32 22 29   0     87     7   92 85     50   135   27   177
2146697 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No Elementary KG 05 2019   grade_2 3.0 61.0 75.0   6.0     3.0     1.0   82.0 67.0     30       134     43   149 3 61 75   6     3     1   82 67     30   134   43   149
2197123 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932003199 441000010015 MAPLE HILL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 25.0 36.0 87.0   0.0     2.0     9.0   80.0 79.0     14       134     22   159 25 36 87   0     2     9   80 79     14   134   22   159
2144740 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702063 321000010008 PS 8 ISSAC VARIAN public Regular School No Elementary KG 05 2019   grade_2 5.0 11.0 120.0   3.0     7.0     1.0   81.0 66.0     47       133     32   147 5 11 120   3     7     1   81 66     47   133   32   147
2157660 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_2 68.0 65.0 15.0   0.0     11.0     14.0   97.0 76.0     12       133     25   173 68 65 15   0     11     14   97 76     12   133   25   173
2169516 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102641 332000010186 PS 186 DR IRVING A GLADSTONE public Regular School No Elementary KG 05 2019   grade_2 57.0 0.0 43.0   0.0     77.0     2.0   90.0 89.0     66       133     41   179 57 0 43   0     77     2   90 89     66   133   41   179
2201056 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202476 342500010129 PS 129 PATRICIA LARKIN public Regular School No Elementary KG 05 2019   grade_2 15.0 5.0 86.0   1.0     61.0     1.0   89.0 80.0     45       133     28   169 15 5 86   1     61     1   89 80     45   133   28   169
2206965 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001496 490601060008 TURNPIKE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   grade_2 89.0 33.0 24.0   1.0     1.0     24.0   97.0 75.0     *       131     35   172 89 33 24   1     1     24   97 75         131   35   172
2149623 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001374 31502060003 JOHNSON CITY ELEM/PRIMARY SCHOOL public Regular School No Elementary PK 02 2019   grade_2 105.0 24.0 23.0   1.0     7.0     21.0   91.0 90.0     16       130     21   181 105 24 23   1     7     21   91 90     16   130   21   181
2144873 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702155 321000010033 PS 33 TIMOTHY DWIGHT public Regular School No Elementary PK 05 2019   grade_2 1.0 18.0 119.0   0.0     0.0     0.0   65.0 73.0     38       129     31   138 1 18 119   0     0     0   65 73     38   129   31   138
2146659 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802364 321100010096 PS 96 RICHARD RODGERS public Regular School No Elementary KG 05 2019   grade_2 7.0 28.0 111.0   1.0     2.0     1.0   80.0 70.0     10       129     38   150 7 28 111   1     2     1   80 70     10   129   38   150
2146735 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802397 321100010106 PS 106 PARKCHESTER public Regular School No Elementary PK 05 2019   grade_2 6.0 37.0 62.0   3.0     54.0     0.0   81.0 81.0     23       129     46   162 6 37 62   3     54     0   81 81     23   129   46   162
2199897 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805244 342400010028 PS 28 THOMAS EMANUEL EARLY CHILD CTR public Regular School No Elementary PK 02 2019   grade_2 1.0   141.0   0.0     11.0     0.0   58.0 95.0     81       129     40   153 1   141   0     11     0   58 95     81   129   40   153
2208523 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010306362 353100010078 PS 78 public Regular School No Elementary PK 05 2019   grade_2 0.0 62.0 65.0   2.0     6.0     1.0   78.0 58.0     8       129     56   136 0 62 65   2     6     1   78 58     8   129   56   136
2169630 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102692 332000010205 PS 205 CLARION public Regular School No Elementary PK 05 2019   grade_2 35.0 1.0 40.0   0.0     110.0         97.0 89.0     57       128     37   186 35 1 40   0     110         97 89     57   128   37   186
2215591 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001752 580212060002 CORAM ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   grade_2 80.0 42.0 68.0   2.0     8.0     6.0   86.0 120.0     15       128     22   206 80 42 68   2     8     6   86 120     15   128   22   206
2169611 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102689 332000010204 PS 204 VINCE LOMBARDI public Regular School No Elementary PK 05 2019   grade_2 39.0 2.0 32.0   1.0     104.0     1.0   103.0 76.0     20       127     32   179 39 2 32   1     104     1   103 76     20   127   32   179
2170447 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202767 332100010253 PS 253 public Regular School No Elementary PK 05 2019   grade_2 32.0 1.0 66.0   1.0     52.0     1.0   83.0 70.0     39       127     25   153 32 1 66   1     52     1   83 70     39   127   25   153
2209796 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003771 500402060002 GRANDVIEW ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 1.0 27.0 102.0   0.0     2.0     2.0   74.0 60.0     72       127     24   134 1 27 102   0     2     2   74 60     72   127   24   134
2164956 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202740 331500010230 PS 230 DORIS L COHEN public Regular School No Elementary PK 05 2019   grade_2 32.0 5.0 51.0   1.0     75.0     6.0   77.0 93.0     51       126     36   170 32 5 51   1     75     6   77 93     51   126   36   170
2170941 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302507 332200010139 PS 139 ALEXINE A FENTY public Regular School No Elementary PK 05 2019   grade_2 17.0 28.0 73.0   3.0     26.0     3.0   77.0 73.0     24       126     27   150 17 28 73   3     26     3   77 73     24   126   27   150
2181429 NY Nassau   school 3630960 280401030000   WESTBURY 363096004159 280401030001 PARK AVENUE SCHOOL public Regular School No Elementary 01 05 2019   grade_2 2.0 52.0 89.0         1.0     0.0   63.0 81.0     47       126     17   144 2 52 89         1     0   63 81     47   126   17   144
2144930 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702204 321000010046 PS 46 EDGAR ALLAN POE public Regular School No Elementary KG 05 2019   grade_2 2.0 16.0 126.0   0.0     1.0     0.0   77.0 68.0     61       125     34   145 2 16 126   0     1     0   77 68     61   125   34   145
2171093 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302695 332200010206 PS 206 JOSEPH F LAMB public Regular School No Elementary KG 08 2019   grade_2 66.0 0.0 21.0   1.0     88.0     2.0   90.0 88.0     51       125     28   178 66 0 21   1     88     2   90 88     51   125   28   178
2224293 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No Elementary 01 02 2019   grade_2 63.0 4.0 128.0         4.0     5.0   99.0 105.0     60       125     18   204 63 4 128         4     5   99 105     60   125   18   204
2164842 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202482 331500010131 PS 131 public Regular School No Elementary PK 05 2019   grade_2 14.0 2.0 86.0   2.0     48.0         69.0 83.0     62       124     34   152 14 2 86   2     48         69 83     62   124   34   152
2200296 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802551 342400010153 PS 153 MASPETH ELEMENTARY public Regular School No Elementary PK 06 2019   grade_2 76.0 3.0 75.0   1.0     27.0     1.0   101.0 82.0     15       124     28   183 76 3 75   1     27     1   101 82     15   124   28   183
2204723 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102153 342900010033 PS 33 EDWARD M FUNK public Regular School No Elementary KG 05 2019   grade_2 9.0 18.0 39.0   8.0     83.0     4.0   79.0 82.0     44       123     23   161 9 18 39   8     83     4   79 82     44   123   23   161

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