Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_2", state = "NY" and year = 2019 sorted by total_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 ▲
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
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
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
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
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
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
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
2165013 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202818 331500010321 PS 321 WILLIAM PENN public Regular School No Elementary KG 05 2019   grade_2 194.0 8.0 10.0   1.0     12.0     14.0   105.0 134.0     *       15     32   239 194 8 10   1     12     14   105 134         15   32   239
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
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
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
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
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
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
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
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
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
2192183 NY Niagara   school 3628050 401001060000   STARPOINT 362805004790 401001060003 FRICANO PRIMARY SCHOOL public Regular School No Elementary KG 02 2019   grade_2 201.0 1.0 4.0   0.0     2.0     17.0   124.0 101.0     *       40     21   225 201 1 4   0     2     17   124 101         40   21   225
2195983 NY Ontario   school 3606330 430300050000   CANANDAIGUA 360633000415 430300050001 CANANDAIGUA PRIMARY-ELEMENTARY public Regular School No Elementary PK 05 2019   grade_2 200.0 1.0 12.0   0.0     3.0     9.0   124.0 101.0     *       94     35   225 200 1 12   0     3     9   124 101         94   35   225
2177230 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 173.0 5.0 28.0   0.0     2.0     13.0   101.0 120.0     7       *     *   221 173 5 28   0     2     13   101 120     7           221
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
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
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
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
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
2222412 NY Warren   school 3624030 630902030000   QUEENSBURY 362403003316 630902030001 QUEENSBURY ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 206.0 2.0 5.0         2.0     3.0   111.0 107.0     *       *     39   218 206 2 5         2     3   111 107             39   218
2175558 NY Monroe   school 3610890 261301060000   FAIRPORT 361089000859 261301060010 DUDLEY SCHOOL public Regular School No Elementary KG 02 2019   grade_2 182.0 4.0 12.0         0.0     14.0   111.0 101.0             54     17   212 182 4 12         0     14   111 101         54   17   212
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
2212095 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2019   grade_2 159.0 10.0 19.0   0.0     10.0     14.0   112.0 100.0     *       97     36   212 159 10 19   0     10     14   112 100         97   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
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
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
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
2215268 NY Suffolk   school 3624840 580209020000   ROCKY POINT 362484003436 580209020003 FRANK J CARASITI ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2019   grade_2 150.0 3.0 43.0   0.0     5.0     4.0   104.0 101.0     12       73     32   205 150 3 43   0     5     4   104 101     12   73   32   205
2217111 NY Suffolk   school 3613620 580406060000   HARBORFIELDS 361362001450 580406060001 WASHINGTON DRIVE PRIM SCH public Regular School No Elementary KG 02 2019   grade_2 143.0 7.0 34.0   0.0     8.0     13.0   103.0 102.0     15       42     32   205 143 7 34   0     8     13   103 102     15   42   32   205
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
2199726 NY Putnam   school 3605310 480601060000   BREWSTER 360531000267 480601060004 JOHN F KENNEDY ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2019   grade_2 109.0 1.0 79.0   1.0     3.0     10.0   108.0 95.0     25       79     22   203 109 1 79   1     3     10   108 95     25   79   22   203
2197256 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001797 441201060001 PINE TREE ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 86.0 19.0 74.0   0.0     10.0     13.0   101.0 101.0     5       60     41   202 86 19 74   0     10     13   101 101     5   60   41   202
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
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
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
2200277 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802521 342400010143 PS 143 LOUIS ARMSTRONG public Regular School No Elementary KG 05 2019   grade_2 3.0 2.0 183.0   1.0     5.0     0.0   90.0 104.0     136       *     54   194 3 2 183   1     5     0   90 104     136       54   194
2217339 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003727 580413030003 OAKWOOD PRIMARY CENTER public Regular School No Elementary KG 02 2019   grade_2 65.0 9.0 100.0   1.0     9.0     7.0   95.0 96.0     62       119     29   191 65 9 100   1     9     7   95 96     62   119   29   191
2209321 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001147 500201060011 THIELLS ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 35.0 25.0 120.0   0.0     3.0     7.0   106.0 84.0     31       118     31   190 35 25 120   0     3     7   106 84     31   118   31   190
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
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
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
2217396 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003723 580413030009 COUNTRYWOOD PRIMARY CENTER public Regular School No Elementary KG 02 2019   grade_2 66.0 10.0 93.0   0.0     10.0     10.0   100.0 89.0     49       105     34   189 66 10 93   0     10     10   100 89     49   105   34   189
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
2196933 NY Orange   school 3612330 440601040000   GOSHEN 361233000998 440601040003 SCOTCHTOWN AVENUE SCHOOL public Regular School No Elementary KG 02 2019   grade_2 119.0 4.0 53.0         7.0     2.0   88.0 97.0     6       60     31   185 119 4 53         7     2   88 97     6   60   31   185
2217510 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000170 580501030003 MARY G CLARKSON SCHOOL public Regular School No Elementary KG 02 2019   grade_2 51.0 26.0 97.0         6.0     5.0   103.0 82.0     28       113     29   185 51 26 97         6     5   103 82     28   113   29   185
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
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
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
2209378 NY Rockland   school 3627450 500301060000   SOUTH ORANGETOWN 362745004427 500301060006 WILLIAM O SCHAEFER ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2019   grade_2 125.0 3.0 37.0         12.0     7.0   93.0 91.0     16       30     14   184 125 3 37         12     7   93 91     16   30   14   184
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
2222849 NY Washington   school 3614970 641301060000   HUDSON FALLS 361497001252 641301060005 HUDSON FALLS PRIMARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 163.0 3.0 2.0   0.0     1.0     14.0   98.0 85.0     *       80     *   183 163 3 2   0     1     14   98 85         80       183
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
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
2226136 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049004400 661100010009 WILLIAM B WARD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 78.0 34.0 57.0   0.0     9.0     3.0   88.0 93.0     18       52     14   181 78 34 57   0     9     3   88 93     18   52   14   181
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
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
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
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
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
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
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
2200999 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202314 342500010079 PS 79 FRANCIS LEWIS public Regular School No Elementary PK 05 2019   grade_2 40.0 1.0 31.0   0.0     102.0     3.0   85.0 92.0     21       96     23   177 40 1 31   0     102     3   85 92     21   96   23   177
2205901 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202451 343000010122 PS 122 MAMIE FAY public Regular School No Elementary PK 08 2019   grade_2 88.0 7.0 33.0   1.0     39.0     8.0   99.0 77.0     26       95     28   176 88 7 33   1     39     8   99 77     26   95   28   176
2215534 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2019   grade_2 88.0 14.0 52.0   0.0     13.0     8.0   90.0 85.0     12       77     27   175 88 14 52   0     13     8   90 85     12   77   27   175
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
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
2200980 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202148 342500010032 PS 32 STATE STREET public Regular School No Elementary PK 05 2019   grade_2 14.0 1.0 35.0   2.0     118.0     3.0   89.0 84.0     35       115     23   173 14 1 35   2     118     3   89 84     35   115   23   173
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
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
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
2208029 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302189 353100010042 PS 42 ELTINGVILLE public Regular School No Elementary PK 05 2019   grade_2 116.0 6.0 20.0   1.0     24.0     3.0   83.0 87.0     6       54     40   170 116 6 20   1     24     3   83 87     6   54   40   170
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
2215173 NY Suffolk   school 3619410 580208020000   MILLER PLACE 361941001774 580208020002 ANDREW MULLER PRIMARY SCHOOL public Regular School No Elementary KG 02 2019   grade_2 144.0 3.0 13.0         3.0     6.0   86.0 83.0     *       32     28   169 144 3 13         3     6   86 83         32   28   169
2215572 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001751 580212060001 C E WALTERS SCHOOL public Regular School No Elementary KG 04 2019   grade_2 83.0 29.0 41.0   0.0     6.0     9.0   88.0 80.0     13       98     29   168 83 29 41   0     6     9   88 80     13   98   29   168
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
2204172 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002667 342800010196 PS 196 GRAND CENTRAL PARKWAY public Regular School No Elementary PK 05 2019   grade_2 77.0 3.0 18.0   0.0     61.0     7.0   79.0 87.0     7       47     30   166 77 3 18   0     61     7   79 87     7   47   30   166
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
2203944 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002437 342800010117 PS 117 J KELD/BRIARWOOD SCHOOL public Regular School No Elementary PK 05 2019   grade_2 32.0 17.0 54.0   4.0     52.0     6.0   95.0 70.0     20       104     35   165 32 17 54   4     52     6   95 70     20   104   35   165
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
2180745 NY Nassau   school 3615510 280226030000   ISLAND TREES 361551001322 280226030003 MICHAEL F STOKES SCHOOL public Regular School No Elementary 02 04 2019   grade_2 104.0 4.0 32.0   0.0     22.0     2.0   75.0 89.0     6       *     16   164 104 4 32   0     22     2   75 89     6       16   164
2227238 NY Westchester   school 3627180 662101060000   SOMERS 362718003700 662101060002 PRIMROSE SCHOOL public Regular School No Elementary KG 02 2019   grade_2 136.0 1.0 19.0         5.0     3.0   71.0 93.0     *       12     28   164 136 1 19         5     3   71 93         12   28   164
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
2167483 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602750 331800010235 PS 235 JANICE MARIE KNIGHT SCHOOL public Regular School No Elementary PK 08 2019   grade_2 1.0 155.0 4.0   0.0     0.0     2.0   77.0 85.0     *       107     13   162 1 155 4   0     0     2   77 85         107   13   162
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
2196116 NY Ontario   school 3611970 430700010000   GENEVA 361197000965 430700010002 NORTH STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2019   grade_2 62.0 19.0 57.0         5.0     19.0   83.0 79.0     13       117     25   162 62 19 57         5     19   83 79     13   117   25   162
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
2164709 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202251 331500010058 PS 58 CARROLL (THE) public Regular School No Elementary PK 05 2019   grade_2 118.0 1.0 19.0   0.0     7.0     16.0   84.0 77.0     9       20     31   161 118 1 19   0     7     16   84 77     9   20   31   161
2202690 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302379 342700010100 PS 100 GLEN MORRIS public Regular School No Elementary PK 05 2019   grade_2 9.0 15.0 27.0   50.0     58.0     2.0   91.0 70.0     17       98     40   161 9 15 27   50     58     2   91 70     17   98   40   161
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
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
2224597 NY Westchester   school 3603180 660405030000   ARDSLEY 360318000082 660405030003 CONCORD ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   grade_2 91.0 3.0 13.0   0.0     36.0     17.0   87.0 73.0     6       9     15   160 91 3 13   0     36     17   87 73     6   9   15   160
2157717 NY Erie   school 3618600 140702030000   MARYVALE 361860001679 140702030003 MARYVALE PRIMARY SCHOOL public Regular School No Elementary PK 02 2019   grade_2 129.0 10.0 4.0         13.0     3.0   83.0 76.0     20       84     20   159 129 10 4         13     3   83 76     20   84   20   159
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

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