Data source: Big Local News · About: Big Local

4,741 rows where grade = "grade_2", state = "NY" and year = 2021 sorted by total_int descending

View and edit SQL

year

  • 2021 · 4,741

grade

  • grade_2 · 4,741
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 ▲
1520589 NY Westchester   school 3622020 661401030000   OSSINING 362202003119 661401030001 BROOKSIDE SCHOOL public Regular School No Elementary 01 03 2021   grade_2 52.0 23.0 216.0         17.0     15.0   167.0 156.0     47       199     33   323 52 23 216         17     15   167 156     47   199   33   323
1493989 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No Elementary PK 05 2021   grade_2 3.0 0.0 296.0         13.0     0.0   160.0 152.0     199       277     77   312 3 0 296         13     0   160 152     199   277   77   312
1490607 NY Ontario   school 3629640 431701060000   VICTOR 362964003995 431701060003 VICTOR PRIMARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 237.0 4.0 26.0   0.0     7.0     15.0   149.0 140.0     12       72     29   289 237 4 26   0     7     15   149 140     12   72   29   289
1520779 NY Westchester   school 3622650 661500010000   PEEKSKILL 362265003180 661500010002 OAKSIDE SCHOOL public Regular School No Elementary 02 03 2021   grade_2 19.0 38.0 180.0         1.0     3.0   124.0 117.0     77       186     20   241 19 38 180         1     3   124 117     77   186   20   241
1499062 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102362 342900010095 PS 95 EASTWOOD public Regular School No Elementary KG 05 2021   grade_2 3.0 29.0 86.0   10.0     108.0     0.0   121.0 115.0     49       177     33   236 3 29 86   10     108     0   121 115     49   177   33   236
1472234 NY Nassau   school 3600997 280201860934   ACADEMY CHARTER SCHOOL 360099706131 280201860934 ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_2 1.0 72.0 159.0   1.0     1.0     0.0   113.0 121.0     73       212     10   234 1 72 159   1     1     0   113 121     73   212   10   234
1494217 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2021   grade_2 5.0 0.0 174.0   1.0     53.0     0.0   120.0 113.0     116       192     *   233 5 0 174   1     53     0   120 113     116   192       233
1463741 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102679 332000010200 PS 200 BENSON SCHOOL public Regular School No Elementary PK 05 2021   grade_2 96.0 1.0 61.0   0.0     73.0     0.0   111.0 120.0     63       200     41   231 96 1 61   0     73     0   111 120     63   200   41   231
1494388 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802521 342400010143 PS 143 LOUIS ARMSTRONG public Regular School No Elementary KG 05 2021   grade_2 0.0 3.0 213.0   1.0     3.0         110.0 110.0     151       209     *   220 0 3 213   1     3         110 110     151   209       220
1459010 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202818 331500010321 PS 321 WILLIAM PENN public Regular School No Elementary KG 05 2021   grade_2 159.0 6.0 12.0   3.0     20.0     19.0   104.0 115.0     *       11     32   219 159 6 12   3     20     19   104 115         11   32   219
1486332 NY Niagara   school 3628050 401001060000   STARPOINT 362805004790 401001060003 FRICANO PRIMARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 201.0 1.0 3.0   0.0     5.0     9.0   123.0 96.0     8       36     27   219 201 1 3   0     5     9   123 96     8   36   27   219
1516656 NY Warren   school 3624030 630902030000   QUEENSBURY 362403003316 630902030001 QUEENSBURY ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 198.0 3.0 6.0         2.0     10.0   110.0 109.0     *       94     24   219 198 3 6         2     10   110 109         94   24   219
1491253 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932006448 441000010018 PRESIDENTIAL PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_2 24.0 26.0 147.0   1.0     6.0     13.0   109.0 108.0     58       173     23   217 24 26 147   1     6     13   109 108     58   173   23   217
1508714 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No Elementary PK 02 2021   grade_2 3.0 73.0 138.0   0.0     0.0     2.0   108.0 108.0     *       199     24   216 3 73 138   0     0     2   108 108         199   24   216
1508486 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 9.0 66.0 127.0   0.0     3.0     10.0   105.0 110.0     39       162     27   215 9 66 127   0     3     10   105 110     39   162   27   215
1463437 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102385 332000010102 PS 102 BAYVIEW (THE) public Regular School No Elementary KG 05 2021   grade_2 91.0 3.0 69.0   0.0     42.0     9.0   116.0 98.0     31       130     48   214 91 3 69   0     42     9   116 98     31   130   48   214
1468320 NY Monroe   school 3605460 260101060000   BRIGHTON 360546000274 260101060001 COUNCIL ROCK PRIMARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 144.0 11.0 16.0         25.0     17.0   98.0 115.0     25       36     27   213 144 11 16         25     17   98 115     25   36   27   213
1490094 NY Ontario   school 3606330 430300050000   CANANDAIGUA 360633000415 430300050001 CANANDAIGUA PRIMARY-ELEMENTARY public Regular School No Elementary PK 05 2021   grade_2 174.0 1.0 19.0   0.0     1.0     15.0   116.0 94.0     *       85     32   210 174 1 19   0     1     15   116 94         85   32   210
1471341 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No Elementary 02 03 2021   grade_2 153.0 6.0 27.0   0.0     2.0     20.0   113.0 95.0     *       *     *   208 153 6 27   0     2     20   113 95                 208
1493932 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802081 342400010013 PS 13 CLEMENT C MOORE public Regular School No Elementary KG 05 2021   grade_2 7.0 14.0 116.0   3.0     68.0     0.0   92.0 116.0     65       162     37   208 7 14 116   3     68     0   92 116     65   162   37   208
1503622 NY Rockland   school 3627450 500301060000   SOUTH ORANGETOWN 362745004427 500301060006 WILLIAM O SCHAEFER ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 122.0 5.0 49.0         17.0     15.0   104.0 104.0     24       41     *   208 122 5 49         17     15   104 104     24   41       208
1496934 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302405 342700010108 PS 108 CAPTAIN VINCENT G FOWLER public Regular School No Elementary PK 05 2021   grade_2 12.0 17.0 110.0   2.0     65.0     1.0   104.0 103.0     14       166     35   207 12 17 110   2     65     1   104 103     14   166   35   207
1493837 NY Putnam   school 3605310 480601060000   BREWSTER 360531000267 480601060004 JOHN F KENNEDY ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 83.0 5.0 107.0         3.0     7.0   125.0 80.0     48       88     13   205 83 5 107         3     7   125 80     48   88   13   205
1439231 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702357 321000010094 PS 94 KINGS COLLEGE SCHOOL public Regular School No Elementary KG 05 2021   grade_2 13.0 19.0 148.0   3.0     21.0     0.0   106.0 98.0     40       185     49   204 13 19 148   3     21     0   106 98     40   185   49   204
1439193 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702332 321000010086 PS 86 KINGSBRIDGE HEIGHTS public Regular School No Elementary PK 06 2021   grade_2 4.0 18.0 173.0   3.0     3.0     2.0   111.0 92.0     60       184     61   203 4 18 173   3     3     2   111 92     60   184   61   203
1509512 NY Suffolk   school 3624840 580209020000   ROCKY POINT 362484003436 580209020003 FRANK J CARASITI ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 147.0 3.0 45.0         1.0     7.0   105.0 98.0     17       74     33   203 147 3 45         1     7   105 98     17   74   33   203
1511583 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003727 580413030003 OAKWOOD PRIMARY CENTER public Regular School No Elementary PK 02 2021   grade_2 77.0 8.0 98.0         9.0     8.0   103.0 97.0     58       117     24   200 77 8 98         9     8   103 97     58   117   24   200
1511640 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003723 580413030009 COUNTRYWOOD PRIMARY CENTER public Regular School No Elementary KG 02 2021   grade_2 80.0 10.0 94.0   2.0     11.0     3.0   112.0 88.0     48       104     28   200 80 10 94   2     11     3   112 88     48   104   28   200
1504040 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003771 500402060002 GRANDVIEW ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 10.0 53.0 130.0   1.0     3.0     1.0   103.0 95.0     83       159     23   198 10 53 130   1     3     1   103 95     83   159   23   198
1491044 NY Orange   school 3612330 440601040000   GOSHEN 361233000998 440601040003 SCOTCHTOWN AVENUE SCHOOL public Regular School No Elementary KG 02 2021   grade_2 151.0 6.0 36.0         1.0     3.0   94.0 103.0     12       54     28   197 151 6 36         1     3   94 103     12   54   28   197
1463475 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102396 332000010105 PS 105 BLYTHEBOURNE (THE) public Regular School No Elementary KG 05 2021   grade_2 4.0 0.0 8.0   1.0     182.0         109.0 86.0     96       174     26   195 4 0 8   1     182         109 86     96   174   26   195
1458744 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No Elementary KG 05 2021   grade_2 4.0 1.0 39.0   1.0     146.0     1.0   104.0 88.0     97       190     *   192 4 1 39   1     146     1   104 88     97   190       192
1493951 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2021   grade_2 2.0 2.0 173.0   0.0     11.0     3.0   91.0 100.0     99       147     40   191 2 2 173   0     11     3   91 100     99   147   40   191
1498359 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002667 342800010196 PS 196 GRAND CENTRAL PARKWAY public Regular School No Elementary PK 05 2021   grade_2 68.0 4.0 24.0   0.0     85.0     10.0   96.0 95.0     9       41     31   191 68 4 24   0     85     10   96 95     9   41   31   191
1512780 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_2 3.0 13.0 174.0   0.0     1.0     0.0   91.0 100.0     92       177     12   191 3 13 174   0     1     0   91 100     92   177   12   191
1518537 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No Elementary 01 02 2021   grade_2 59.0 4.0 106.0         6.0     16.0   96.0 95.0     50       99     *   191 59 4 106         6     16   96 95     50   99       191
1503584 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001148 500201060012 WEST HAVERSTRAW ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 17.0 21.0 145.0         3.0     4.0   91.0 99.0     45       78     15   190 17 21 145         3     4   91 99     45   78   15   190
1511355 NY Suffolk   school 3613620 580406060000   HARBORFIELDS 361362001450 580406060001 WASHINGTON DRIVE PRIM SCH public Regular School No Elementary KG 02 2021   grade_2 139.0 6.0 32.0         10.0     3.0   104.0 86.0     11       20     25   190 139 6 32         10     3   104 86     11   20   25   190
1503565 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001147 500201060011 THIELLS ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 37.0 15.0 128.0   0.0     6.0     3.0   112.0 77.0     41       84     27   189 37 15 128   0     6     3   112 77     41   84   27   189
1453614 NY Erie   school 3600025 142601860031   CHARTER SCHOOL FOR APPLIED TE 360002504349 142601860031 CHARTER SCHOOL FOR APPLIED TECHNOLOG charter Regular School Yes Other KG 12 2021   grade_2 20.0 79.0 49.0   4.0     21.0     15.0   82.0 106.0     10       167     20   188 20 79 49   4     21     15   82 106     10   167   20   188
1465299 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302695 332200010206 PS 206 JOSEPH F LAMB public Regular School No Elementary KG 08 2021   grade_2 87.0 6.0 18.0   2.0     72.0     3.0   85.0 103.0     71       144     23   188 87 6 18   2     72     3   85 103     71   144   23   188
1463798 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102692 332000010205 PS 205 CLARION public Regular School No Elementary PK 05 2021   grade_2 35.0 2.0 39.0   3.0     106.0     1.0   88.0 98.0     39       116     36   186 35 2 39   3     106     1   88 98     39   116   36   186
1493894 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801406 342400010007 PS 7 LOUIS F SIMEONE public Regular School No Elementary PK 05 2021   grade_2 4.0 0.0 70.0   0.0     111.0     1.0   96.0 90.0     85       161     26   186 4 0 70   0     111     1   96 90     85   161   26   186
1506339 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 138.0 7.0 19.0   0.0     8.0     12.0   96.0 88.0     *       77     33   184 138 7 19   0     8     12   96 88         77   33   184
1458915 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202602 331500010169 PS 169 SUNSET PARK public Regular School No Elementary KG 05 2021   grade_2 3.0 1.0 52.0   2.0     123.0     2.0   107.0 76.0     106       171     46   183 3 1 52   2     123     2   107 76     106   171   46   183
1469726 NY Monroe   school 3610890 261301060000   FAIRPORT 361089000859 261301060010 DUDLEY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 149.0 5.0 16.0         2.0     11.0   95.0 88.0             43     15   183 149 5 16         2     11   95 88         43   15   183
1491367 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001797 441201060001 PINE TREE ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2021   grade_2 73.0 21.0 72.0   0.0     11.0     6.0   95.0 88.0     11       73     39   183 73 21 72   0     11     6   95 88     11   73   39   183
1495053 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202109 342500010021 PS 21 EDWARD HART public Regular School No Elementary PK 05 2021   grade_2 7.0 4.0 54.0   0.0     113.0     3.0   98.0 83.0     64       149     27   181 7 4 54   0     113     3   98 83     64   149   27   181
1495167 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202314 342500010079 PS 79 FRANCIS LEWIS public Regular School No Elementary PK 05 2021   grade_2 23.0 3.0 42.0   1.0     109.0     3.0   102.0 79.0     38       93     20   181 23 3 42   1     109     3   102 79     38   93   20   181
1463532 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102575 332000010160 PS 160 WILLIAM T SAMPSON public Regular School No Elementary KG 05 2021   grade_2 5.0 0.0 8.0   0.0     167.0     0.0   94.0 86.0     138       160     24   180 5 0 8   0     167     0   94 86     138   160   24   180
1463684 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 2021   grade_2 59.0 1.0 41.0   1.0     77.0     1.0   97.0 83.0     67       126     21   180 59 1 41   1     77     1   97 83     67   126   21   180
1491234 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932003199 441000010015 MAPLE HILL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_2 21.0 51.0 98.0         4.0     6.0   89.0 91.0     22       137     21   180 21 51 98         4     6   89 91     22   137   21   180
1509835 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001752 580212060002 CORAM ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_2 60.0 48.0 56.0   2.0     6.0     7.0   94.0 85.0     18       95     25   179 60 48 56   2     6     7   94 85     18   95   25   179
1521482 NY Westchester   school 3627180 662101060000   SOMERS 362718003700 662101060002 PRIMROSE SCHOOL public Regular School No Elementary KG 02 2021   grade_2 141.0 2.0 27.0         5.0     4.0   96.0 83.0     *       16     24   179 141 2 27         5     4   96 83         16   24   179
1454773 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   grade_2 117.0 25.0 23.0   1.0     1.0     10.0   91.0 86.0     *       119     *   177 117 25 23   1     1     10   91 86         119       177
1493913 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No Elementary KG 05 2021   grade_2 8.0 0.0 69.0   0.0     96.0     3.0   99.0 77.0     74       157     27   176 8 0 69   0     96     3   99 77     74   157   27   176
1494464 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802739 342400010229 PS 229 EMANUEL KAPLAN public Regular School No Elementary PK 05 2021   grade_2 29.0 3.0 66.0   1.0     75.0     0.0   94.0 80.0     9       121     28   174 29 3 66   1     75     0   94 80     9   121   28   174
1495224 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202476 342500010129 PS 129 PATRICIA LARKIN public Regular School No Elementary PK 05 2021   grade_2 13.0 1.0 98.0   1.0     60.0     1.0   89.0 85.0     41       142     34   174 13 1 98   1     60     1   89 85     41   142   34   174
1514547 NY Sullivan   school 3619740 591401060000   MONTICELLO 361974001808 591401060003 GEORGE L COOKE SCHOOL public Regular School No Elementary KG 02 2021   grade_2 57.0 22.0 72.0         3.0     20.0   92.0 82.0     9       151     32   174 57 22 72         3     20   92 82     9   151   32   174
1463608 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102618 332000010176 PS 176 OVINGTON public Regular School No Elementary KG 05 2021   grade_2 23.0 1.0 29.0   2.0     116.0     2.0   85.0 88.0     *       155     30   173 23 1 29   2     116     2   85 88         155   30   173
1495091 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202119 342500010024 PS 24 ANDREW JACKSON public Regular School No Elementary PK 05 2021   grade_2 1.0 1.0 21.0   1.0     148.0     1.0   90.0 83.0     82       125     17   173 1 1 21   1     148     1   90 83     82   125   17   173
1501171 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001496 490601060008 TURNPIKE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2021   grade_2 93.0 32.0 30.0         1.0     16.0   91.0 81.0     8       126     23   172 93 32 30         1     16   91 81     8   126   23   172
1518841 NY Westchester   school 3603180 660405030000   ARDSLEY 360318000082 660405030003 CONCORD ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_2 93.0 4.0 24.0   1.0     33.0     15.0   85.0 85.0     13       16     8   170 93 4 24   1     33     15   85 85     13   16   8   170
1463779 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102689 332000010204 PS 204 VINCE LOMBARDI public Regular School No Elementary PK 05 2021   grade_2 59.0 0.0 33.0   0.0     74.0     1.0   80.0 87.0     20       125     45   167 59 0 33   0     74     1   80 87     20   125   45   167
1451828 NY Erie   school 3618600 140702030000   MARYVALE 361860001679 140702030003 MARYVALE PRIMARY SCHOOL public Regular School No Elementary PK 02 2021   grade_2 117.0 19.0 14.0   0.0     8.0     8.0   89.0 77.0     26       79     16   166 117 19 14   0     8     8   89 77     26   79   16   166
1473868 NY Nassau   school 3616830 280215030000   LAWRENCE 361683001500 280215030002 LAWRENCE PRIMARY SCHOOL-#2 SCHOOL public Regular School No Elementary KG 03 2021   grade_2 21.0 21.0 117.0   0.0     7.0         84.0 82.0     55       143     26   166 21 21 117   0     7         84 82     55   143   26   166
1465242 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302669 332200010197 PS 197 KINGS HIGHWAY ACADEMY (THE) public Regular School No Elementary PK 05 2021   grade_2 106.0 17.0 12.0   1.0     27.0     1.0   79.0 85.0     60       109     18   164 106 17 12   1     27     1   79 85     60   109   18   164
1474210 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000946 280218030005 STEWART SCHOOL public Regular School No Elementary 02 05 2021   grade_2 121.0 1.0 12.0         29.0     1.0   93.0 71.0     9       9     *   164 121 1 12         29     1   93 71     9   9       164
1493970 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_2 1.0 0.0 157.0   0.0     6.0     0.0   93.0 71.0     95       143     31   164 1 0 157   0     6     0   93 71     95   143   31   164
1495148 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202148 342500010032 PS 32 STATE STREET public Regular School No Elementary KG 05 2021   grade_2 16.0 0.0 29.0   2.0     112.0     5.0   85.0 79.0     27       99     22   164 16 0 29   2     112     5   85 79     27   99   22   164
1504135 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781004569 500402060010 SUMMIT PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 4.0 33.0 122.0   0.0     5.0         89.0 75.0     72       148     18   164 4 33 122   0     5         89 75     72   148   18   164
1519487 NY Westchester   school 3620160 660801060000   MT PLEASANT CENT 362016001847 660801060003 HAWTHORNE ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 125.0 1.0 22.0   1.0     9.0     3.0   78.0 83.0     *       16     26   161 125 1 22   1     9     3   78 83         16   26   161
1500088 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202451 343000010122 PS 122 MAMIE FAY public Regular School No Elementary PK 08 2021   grade_2 90.0 2.0 29.0   1.0     31.0     7.0   92.0 68.0     20       68     18   160 90 2 29   1     31     7   92 68     20   68   18   160
1509417 NY Suffolk   school 3619410 580208020000   MILLER PLACE 361941001774 580208020002 ANDREW MULLER PRIMARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 127.0 6.0 18.0   0.0     3.0     6.0   82.0 78.0     *       24     30   160 127 6 18   0     3     6   82 78         24   30   160
1458953 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202740 331500010230 PS 230 DORIS L COHEN public Regular School No Elementary PK 05 2021   grade_2 21.0 3.0 59.0   0.0     75.0     1.0   87.0 72.0     54       110     40   159 21 3 59   0     75     1   87 72     54   110   40   159
1503489 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001146 500201060004 STONY POINT ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 47.0 10.0 96.0   0.0     3.0     3.0   84.0 75.0     18       66     37   159 47 10 96   0     3     3   84 75     18   66   37   159
1440770 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802323 321100010083 PS 83 DONALD HERTZ public Regular School No Elementary KG 08 2021   grade_2 56.0 10.0 72.0   1.0     19.0     0.0   72.0 86.0     28       122     29   158 56 10 72   1     19     0   72 86     28   122   29   158
1442081 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002209 321200010047 PS 47 JOHN RANDOLPH public Regular School No Elementary KG 05 2021   grade_2 3.0 28.0 98.0   5.0     21.0     2.0   78.0 79.0     44       148     28   157 3 28 98   5     21     2   78 79     44   148   28   157
1458706 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202251 331500010058 PS 58 CARROLL (THE) public Regular School No Elementary PK 05 2021   grade_2 116.0 4.0 14.0   1.0     3.0     19.0   77.0 80.0     8       14     19   157 116 4 14   1     3     19   77 80     8   14   19   157
1494293 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806323 342400010110 PS 110 public Regular School No Elementary KG 05 2021   grade_2 1.0 0.0 139.0   0.0     17.0         77.0 80.0     73       145     22   157 1 0 139   0     17         77 80     73   145   22   157
1496725 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302268 342700010063 PS 63 OLD SOUTH public Regular School No Elementary PK 05 2021   grade_2 11.0 9.0 62.0   5.0     68.0     2.0   78.0 79.0     23       132     24   157 11 9 62   5     68     2   78 79     23   132   24   157
1512856 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_2 3.0 6.0 146.0         2.0     0.0   81.0 76.0     72       136     14   157 3 6 146         2     0   81 76     72   136   14   157
1517093 NY Washington   school 3614970 641301060000   HUDSON FALLS 361497001252 641301060005 HUDSON FALLS PRIMARY SCHOOL public Regular School No Elementary KG 04 2021   grade_2 145.0 1.0 0.0         1.0     10.0   87.0 70.0     *       77     30   157 145 1 0         1     10   87 70         77   30   157
1440903 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802397 321100010106 PS 106 PARKCHESTER public Regular School No Elementary PK 05 2021   grade_2 6.0 37.0 45.0   3.0     62.0     3.0   81.0 75.0     22       121     39   156 6 37 45   3     62     3   81 75     22   121   39   156
1458535 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202041 331500010001 PS 1 BERGEN (THE) public Regular School No Elementary PK 05 2021   grade_2 2.0 2.0 141.0   0.0     11.0     0.0   77.0 79.0     59       123     33   156 2 2 141   0     11     0   77 79     59   123   33   156
1462088 NY Kings   school 3600966 331800860916   BROOKLYN ASCEND CHARTER SCHO 360096606069 331800860916 BROOKLYN ASCEND CHARTER SCHOOL charter Regular School Yes Other KG 12 2021   grade_2 0.0 148.0 5.0   2.0     0.0     1.0   70.0 86.0     5       138     16   156 0 148 5   2     0     1   70 86     5   138   16   156
1494445 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806430 342400010211 ELM TREE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_2 4.0 8.0 127.0   1.0     15.0     1.0   80.0 76.0     68       140     42   156 4 8 127   1     15     1   80 76     68   140   42   156
1495034 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202105 342500010020 PS 20 JOHN BOWNE public Regular School No Elementary PK 05 2021   grade_2 3.0 12.0 26.0   1.0     113.0     1.0   82.0 74.0     73       134     19   156 3 12 26   1     113     1   82 74     73   134   19   156
1504021 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003770 500402060001 FLEETWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 4.0 22.0 124.0   2.0     3.0     1.0   74.0 82.0     103       138     16   156 4 22 124   2     3     1   74 82     103   138   16   156
1509341 NY Suffolk   school 3620040 580207020000   MOUNT SINAI 362004001829 580207020001 MT SINAI ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_2 130.0 1.0 16.0         6.0     3.0   75.0 81.0     *       17     28   156 130 1 16         6     3   75 81         17   28   156
1490227 NY Ontario   school 3611970 430700010000   GENEVA 361197000965 430700010002 NORTH STREET ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2021   grade_2 66.0 15.0 47.0         3.0     24.0   62.0 93.0     18       110     18   155 66 15 47         3     24   62 93     18   110   18   155
1502235 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302189 353100010042 PS 42 ELTINGVILLE public Regular School No Elementary PK 05 2021   grade_2 113.0 3.0 16.0   0.0     22.0     1.0   84.0 71.0     11       47     *   155 113 3 16   0     22     1   84 71     11   47       155
1509854 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001755 580212060003 RIDGE ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_2 81.0 25.0 33.0   2.0     8.0     6.0   85.0 70.0     6       61     23   155 81 25 33   2     8     6   85 70     6   61   23   155
1520380 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049004400 661100010009 WILLIAM B WARD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2021   grade_2 61.0 42.0 41.0   1.0     8.0     2.0   81.0 74.0     14       47     14   155 61 42 41   1     8     2   81 74     14   47   14   155
1498207 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002523 342800010144 PS 144 COL JEROMUS REMSEN public Regular School No Elementary PK 05 2021   grade_2 57.0 0.0 27.0   0.0     50.0     20.0   82.0 72.0     8       27     24   154 57 0 27   0     50     20   82 72     8   27   24   154
1500278 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202594 343000010166 PS 166 HENRY GRADSTEIN public Regular School No Elementary PK 05 2021   grade_2 52.0 7.0 49.0   3.0     38.0     5.0   70.0 84.0     19       79     19   154 52 7 49   3     38     5   70 84     19   79   19   154
1511754 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000170 580501030003 MARY G CLARKSON SCHOOL public Regular School No Elementary KG 02 2021   grade_2 44.0 21.0 71.0   0.0     10.0     8.0   70.0 84.0     16       78     22   154 44 21 71   0     10     8   70 84     16   78   22   154
1503394 NY Rockland   school 3620190 500108030000   NANUET 362019001852 500108030002 GEORGE W MILLER ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 67.0 10.0 49.0         18.0     9.0   82.0 71.0     15       38     10   153 67 10 49         18     9   82 71     15   38   10   153
1512761 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_2 4.0 10.0 135.0   0.0     3.0     1.0   76.0 77.0     78       140     20   153 4 10 135   0     3     1   76 77     78   140   20   153
1492032 NY Orange   school 3629970 442101060000   WARWICK VALLEY 362997004836 442101060007 SANFORDVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_2 117.0 4.0 20.0         1.0     10.0   81.0 71.0     *       18     31   152 117 4 20         1     10   81 71         18   31   152

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