Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_2 · 33,145
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female ▲ non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
776173 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102692 332000010205 PS 205 CLARION public Regular School No 1 PK 5 2015   grade_2 45.0 0.0 43.0         118.0     0.0   107.0 99.0             118     23   206 45 0 43         118     0   107 99         118   23   206
803913 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932006448 441000010018 PRESIDENTIAL PARK ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 48.0 26.0 128.0   0.0     5.0     10.0   118.0 99.0             164     23   217 48 26 128   0     5     10   118 99         164   23   217
816415 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003776 500402060005 MARGETTS ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_2 13.0 51.0 120.0         8.0     1.0   94.0 99.0             181     29   193 13 51 120         8     1   94 99         181   29   193
821108 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No 1 PK 02 2015   grade_2 3.0 78.0 125.0   0.0     1.0     1.0   109.0 99.0             193     35   208 3 78 125   0     1     1   109 99         193   35   208
972876 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105908 332000010503 PS 503 SCHOOL OF DISCOVERY (THE) public Regular School No Elementary PK 5 2017   grade_2 10.0 1.0 136.0   0.0     44.0     0.0   92.0 99.0     128       186     46   191 10 1 136   0     44     0   92 99     128   186   46   191
1000160 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932003199 441000010015 MAPLE HILL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 33.0 50.0 104.0   0.0     2.0     11.0   101.0 99.0     26       156     21   200 33 50 104   0     2     11   101 99     26   156   21   200
1021573 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2017   grade_2 5.0 11.0 182.0   1.0     3.0     2.0   105.0 99.0     91       194     23   204 5 11 182   1     3     2   105 99     91   194   23   204
1036013 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602232 320900010053 PS 53 BASHEER QUISIM public Regular School No 1.0 PK 05 2016   grade_2 4.0 66.0 133.0   1.0     2.0     0.0   107.0 99.0             183     50   206 4 66 133   1     2     0   107 99         183   50   206
1096889 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002333 342800010086 PS 86 public Regular School No 1.0 PK 05 2016   grade_2 5.0 17.0 67.0   9.0     89.0     1.0   89.0 99.0             111     40   188 5 17 67   9     89     1   89 99         111   40   188
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
1584011 NY Putnam   school 3605310 480601060000   BREWSTER 360531000267 480601060004 JOHN F KENNEDY ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   grade_2 87.0 4.0 102.0         5.0     6.0   105.0 99.0     38       92     22   204 87 4 102         5     6   105 99     38   92   22   204
1593758 NY Rockland   school 3627450 500301060000   SOUTH ORANGETOWN 362745004427 500301060006 WILLIAM O SCHAEFER ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   grade_2 128.0 1.0 38.0         20.0     11.0   99.0 99.0     15       26     24   198 128 1 38         20     11   99 99     15   26   24   198
1602897 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2020   grade_2 3.0 10.0 163.0   2.0     2.0     1.0   82.0 99.0     81       172     27   181 3 10 163   2     2     1   82 99     81   172   27   181
2107348 NY Orange   school 3612330 440601040000   GOSHEN 361233000998 440601040003 SCOTCHTOWN AVENUE SCHOOL public Regular School No Elementary KG 02 2018   grade_2 149.0 4.0 34.0   1.0     7.0     4.0   100.0 99.0     *       61     27   199 149 4 34   1     7     4   100 99         61   27   199
752955 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802397 321100010106 PS 106 PARKCHESTER public Regular School No 1.0 PK 05 2015   grade_2 4.0 52.0 79.0   3.0     56.0     0.0   96.0 98.0             132     29   194 4 52 79   3     56     0   96 98         132   29   194
777655 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302717 332200010217 PS 217 COL DAVID MARCUS SCHOOL public Regular School No 1 PK 5 2015   grade_2 41.0 23.0 41.0   0.0     96.0     4.0   107.0 98.0             137     27   205 41 23 41   0     96     4   107 98         137   27   205
807086 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802551 342400010153 PS 153 MASPETH ELEMENTARY public Regular School No 1 PK 06 2015   grade_2 83.0 1.0 105.0   1.0     17.0     2.0   111.0 98.0             152     33   209 83 1 105   1     17     2   111 98         152   33   209
810544 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002333 342800010086 PS 86 public Regular School No 1 PK 05 2015   grade_2 12.0 12.0 62.0   4.0     80.0     0.0   72.0 98.0             108     37   170 12 12 62   4     80     0   72 98         108   37   170
1037989 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702691 321000010205 PS 205 FIORELLO LAGUARDIA public Regular School No 1.0 KG 05 2016   grade_2 10.0 24.0 143.0         5.0         84.0 98.0             147     42   182 10 24 143         5         84 98         147   42   182
1094039 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202109 342500010021 PS 21 EDWARD HART public Regular School No 1.0 PK 05 2016   grade_2 12.0 3.0 61.0   0.0     136.0     3.0   117.0 98.0             163     30   215 12 3 61   0     136     3   117 98         163   30   215
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
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
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
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
1584638 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802739 342400010229 PS 229 EMANUEL KAPLAN public Regular School No Elementary PK 05 2020   grade_2 40.0 6.0 86.0   0.0     90.0     0.0   124.0 98.0     20       153     47   222 40 6 86   0     90     0   124 98     20   153   47   222
1588476 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002667 342800010196 PS 196 GRAND CENTRAL PARKWAY public Regular School No Elementary PK 05 2020   grade_2 77.0 5.0 18.0   1.0     69.0     12.0   84.0 98.0     6       37     23   182 77 5 18   1     69     12   84 98     6   37   23   182
1598850 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No Elementary PK 02 2020   grade_2 5.0 77.0 120.0         0.0     0.0   104.0 98.0     97       194     34   202 5 77 120         0     0   104 98     97   194   34   202
1606792 NY Warren   school 3624030 630902030000   QUEENSBURY 362403003316 630902030001 QUEENSBURY ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_2 201.0 1.0 4.0         3.0     3.0   114.0 98.0     *       88     36   212 201 1 4         3     3   114 98         88   36   212
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
771176 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202482 331500010131 PS 131 public Regular School No 1 PK 5 2015   grade_2 14.0 5.0 102.0   0.0     71.0     0.0   95.0 97.0             125     33   192 14 5 102   0     71     0   95 97         125   33   192
773817 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602429 331800010115 PS 115 DANIEL MUCATEL SCHOOL public Regular School No 1 PK 5 2015   grade_2 2.0 157.0 12.0   2.0     7.0     1.0   84.0 97.0             97     35   181 2 157 12   2     7     1   84 97         97   35   181
798916 NY Niagara   school 3628050 401001060000   STARPOINT 362805004790 401001060003 FRICANO PRIMARY SCHOOL public Regular School No 1 KG 02 2015   grade_2 189.0 3.0 10.0         2.0     5.0   112.0 97.0             53     20   209 189 3 10         2     5   112 97         53   20   209
803685 NY Orange   school 3612330 440601040000   GOSHEN 361233000998 440601040003 SCOTCHTOWN AVENUE SCHOOL public Regular School No 1 KG 02 2015   grade_2 146.0 5.0 51.0         7.0     4.0   116.0 97.0             59     31   213 146 5 51         7     4   116 97         59   31   213
811323 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102153 342900010033 PS 33 EDWARD M FUNK public Regular School No 1 KG 05 2015   grade_2 7.0 30.0 54.0   6.0     85.0     3.0   88.0 97.0             142     21   185 7 30 54   6     85     3   88 97         142   21   185
812596 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202534 343000010148 PS 148 public Regular School No 1 PK 05 2015   grade_2 2.0 1.0 151.0   0.0     26.0         83.0 97.0             102     27   180 2 1 151   0     26         83 97         102   27   180
815788 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001146 500201060004 STONY POINT ELEMENTARY SCHOOL public Regular School No 1 KG 03 2015   grade_2 70.0 4.0 102.0   0.0     6.0     8.0   93.0 97.0             103     13   190 70 4 102   0     6     8   93 97         103   13   190
825231 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 5.0 18.0 185.0   0.0     2.0     3.0   116.0 97.0             202     13   213 5 18 185   0     2     3   116 97         202   13   213
832964 NY Westchester   school 3606060 661201060000   BYRAM HILLS 360606000390 661201060002 COMAN HILL SCHOOL public Regular School No 1 KG 02 2015   grade_2 169.0 2.0 10.0         5.0     6.0   95.0 97.0             7     26   192 169 2 10         5     6   95 97         7   26   192
972648 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102679 332000010200 PS 200 BENSON SCHOOL public Regular School No Elementary PK 5 2017   grade_2 95.0 2.0 43.0   2.0     67.0     2.0   114.0 97.0     66       170     32   211 95 2 43   2     67     2   114 97     66   170   32   211
974187 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302717 332200010217 PS 217 COL DAVID MARCUS SCHOOL public Regular School No Elementary PK 5 2017   grade_2 42.0 18.0 46.0         88.0     5.0   102.0 97.0     75       130     34   199 42 18 46         88     5   102 97     75   130   34   199
1039471 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802394 321100010105 PS 105 SEN ABRAHAM BERNSTEIN public Regular School No 1.0 KG 05 2016   grade_2 30.0 19.0 135.0   1.0     17.0     2.0   107.0 97.0             186     40   204 30 19 135   1     17     2   107 97         186   40   204
1102342 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001147 500201060011 THIELLS ELEMENTARY SCHOOL public Regular School No 1.0 KG 03 2016   grade_2 46.0 26.0 111.0   0.0     8.0         94.0 97.0             102     18   191 46 26 111   0     8         94 97         102   18   191
1111671 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No 1.0 01 05 2016   grade_2 3.0 17.0 189.0   2.0     4.0     3.0   121.0 97.0             210     30   218 3 17 189   2     4     3   121 97         210   30   218
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
1543636 NY Erie   school 3600025 142601860031   CHARTER SCHOOL FOR APPLIED TE 360002504349 142601860031 CHARTER SCHOOL FOR APPLIED TECHNOLOG charter Regular School Yes Other KG 12 2020   grade_2 34.0 76.0 46.0   1.0     12.0     17.0   89.0 97.0     8       151     20   186 34 76 46   1     12     17   89 97     8   151   20   186
1553706 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102603 332000010170 RALPH A FABRIZIO SCHOOL public Regular School No Elementary KG 05 2020   grade_2 45.0 0.0 30.0   1.0     132.0     4.0   115.0 97.0     64       189     30   212 45 0 30   1     132     4   115 97     64   189   30   212
1585170 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202109 342500010021 PS 21 EDWARD HART public Regular School No Elementary PK 05 2020   grade_2 6.0 0.0 53.0   0.0     139.0     4.0   105.0 97.0     40       158     28   202 6 0 53   0     139     4   105 97     40   158   28   202
2058404 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003369 321200010196 PS 196 public Regular School No Elementary PK 05 2018   grade_2 2.0 26.0 134.0   0.0     3.0         68.0 97.0     53       152     27   165 2 26 134   0     3         68 97     53   152   27   165
2119755 NY Rockland   school 3627450 500301060000   SOUTH ORANGETOWN 362745004427 500301060006 WILLIAM O SCHAEFER ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2018   grade_2 127.0 6.0 32.0         21.0     16.0   105.0 97.0     11       41     19   202 127 6 32         21     16   105 97     11   41   19   202
2125892 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 102.0 15.0 48.0         13.0     6.0   87.0 97.0     12       78     12   184 102 15 48         13     6   87 97     12   78   12   184
2127469 NY Suffolk   school 3613620 580406060000   HARBORFIELDS 361362001450 580406060001 WASHINGTON DRIVE PRIM SCH public Regular School No Elementary KG 02 2018   grade_2 133.0 7.0 33.0   0.0     10.0     2.0   88.0 97.0     14       30     29   185 133 7 33   0     10     2   88 97     14   30   29   185
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
771290 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202740 331500010230 PS 230 DORIS L COHEN public Regular School No 1 PK 5 2015   grade_2 40.0 5.0 68.0         92.0     1.0   110.0 96.0             135     42   206 40 5 68         92     1   110 96         135   42   206
807219 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806060 342400010307 PIONEER ACADEMY public Regular School No 1 KG 05 2015   grade_2 2.0 1.0 164.0   0.0     4.0     0.0   75.0 96.0             169     28   171 2 1 164   0     4     0   75 96         169   28   171
821868 NY Suffolk   school 3619410 580208020000   MILLER PLACE 361941001774 580208020002 ANDREW MULLER PRIMARY SCHOOL public Regular School No 1 KG 02 2015   grade_2 157.0 2.0 15.0         4.0     1.0   83.0 96.0             26     24   179 157 2 15         4     1   83 96         26   24   179
949544 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802323 321100010083 PS 83 DONALD HERTZ public Regular School No Elementary KG 08 2017   grade_2 68.0 19.0 94.0   2.0     14.0     1.0   102.0 96.0     36       91     43   198 68 19 94   2     14     1   102 96     36   91   43   198
1012339 NY Rockland   school 3627450 500301060000   SOUTH ORANGETOWN 362745004427 500301060006 WILLIAM O SCHAEFER ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 120.0 3.0 33.0         13.0     12.0   85.0 96.0     12       31     8   181 120 3 33         13     12   85 96     12   31   8   181
1105116 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No 1.0 KG 02 2016   grade_2 175.0 4.0 10.0   1.0     2.0     5.0   101.0 96.0             85     37   197 175 4 10   1     2     5   101 96         85   37   197
1111747 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No 1.0 01 05 2016   grade_2 2.0 16.0 157.0   0.0     2.0     1.0   82.0 96.0             163     10   178 2 16 157   0     2     1   82 96         163   10   178
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
2079760 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102618 332000010176 PS 176 OVINGTON public Regular School No Elementary KG 05 2018   grade_2 29.0 1.0 49.0   0.0     130.0     0.0   113.0 96.0     59       182     23   209 29 1 49   0     130     0   113 96     59   182   23   209
2102579 NY Niagara   school 3628050 401001060000   STARPOINT 362805004790 401001060003 FRICANO PRIMARY SCHOOL public Regular School No Elementary KG 02 2018   grade_2 186.0 3.0 6.0   0.0     1.0     9.0   109.0 96.0     *       43     22   205 186 3 6   0     1     9   109 96         43   22   205
2114568 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002667 342800010196 PS 196 GRAND CENTRAL PARKWAY public Regular School No Elementary PK 05 2018   grade_2 77.0 0.0 19.0   0.0     62.0     7.0   69.0 96.0     *       41     29   165 77 0 19   0     62     7   69 96         41   29   165
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
807675 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202109 342500010021 PS 21 EDWARD HART public Regular School No 1 PK 05 2015   grade_2 20.0 2.0 61.0   1.0     130.0     3.0   122.0 95.0             170     27   217 20 2 61   1     130     3   122 95         170   27   217
962369 NY Erie   school 3600025 142601860031   CHARTER SCHOOL FOR APPLIED TE 360002504349 142601860031 CHARTER SCHOOL FOR APPLIED TECHNOLOG charter Regular School Yes Other KG 12 2017   grade_2 28.0 65.0 57.0   3.0     14.0     19.0   91.0 95.0     11       169     17   186 28 65 57   3     14     19   91 95     11   169   17   186
963680 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 02 5 2017   grade_2 146.0 8.0 13.0   0.0     0.0     17.0   89.0 95.0     *       115     13   184 146 8 13   0     0     17   89 95         115   13   184
1018571 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001752 580212060002 CORAM ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   grade_2 90.0 47.0 56.0   0.0     13.0     10.0   121.0 95.0     18       122     29   216 90 47 56   0     13     10   121 95     18   122   29   216
1107396 NY Suffolk   school 3608880 580107030000   DEER PARK 360888004712 580107030001 MAY MOORE PRIMARY SCHOOL public Regular School No 1.0 PK 02 2016   grade_2 78.0 32.0 37.0         18.0     8.0   78.0 95.0             69     35   173 78 32 37         18     8   78 95         69   35   173
1108308 NY Suffolk   school 3619410 580208020000   MILLER PLACE 361941001774 580208020002 ANDREW MULLER PRIMARY SCHOOL public Regular School No 1.0 KG 02 2016   grade_2 182.0 3.0 15.0         6.0     3.0   114.0 95.0             18     34   209 182 3 15         6     3   114 95         18   34   209
1120430 NY Westchester   school 3627180 662101060000   SOMERS 362718003700 662101060002 PRIMROSE SCHOOL public Regular School No 1.0 KG 02 2016   grade_2 169.0 1.0 16.0   0.0     9.0     1.0   101.0 95.0             22     34   196 169 1 16   0     9     1   101 95         22   34   196
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
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
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
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
1546030 NY Herkimer   school 3601087 212101040000   C-V AT ILION-MOHAWK CSD 360108701282 212101040006 BARRINGER ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2020   grade_2 154.0 2.0 3.0         2.0     11.0   77.0 95.0     *       107     24   172 154 2 3         2     11   77 95         107   24   172
1555378 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302695 332200010206 PS 206 JOSEPH F LAMB public Regular School No Elementary KG 08 2020   grade_2 67.0 0.0 11.0   1.0     92.0     5.0   81.0 95.0     63       113     26   176 67 0 11   1     92     5   81 95     63   113   26   176
1581199 NY Orange   school 3612330 440601040000   GOSHEN 361233000998 440601040003 SCOTCHTOWN AVENUE SCHOOL public Regular School No Elementary KG 02 2020   grade_2 136.0 7.0 50.0         8.0     2.0   108.0 95.0     11       63     28   203 136 7 50         8     2   108 95     11   63   28   203
1593720 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001148 500201060012 WEST HAVERSTRAW ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_2 14.0 37.0 145.0   1.0     0.0     7.0   109.0 95.0     51       147     25   204 14 37 145   1     0     7   109 95     51   147   25   204
2081451 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 2018   grade_2 36.0 15.0 28.0   0.0     113.0     5.0   102.0 95.0     62       147     36   197 36 15 28   0     113     5   102 95     62   147   36   197
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
2166134 NY Kings   school 3601000 331600860938   EXCELLENCE GIRLS CHARTER 360100006112 331600860938 EXCELLENCE GIRLS CHARTER SCHOOL charter Regular School Yes Other KG 12 2019   grade_2 1.0 72.0 19.0   0.0     3.0     0.0   0.0 95.0     8       72     11   95 1 72 19   0     3     0   0 95     8   72   11   95
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
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
822229 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No 1 01 06 2015   grade_2 115.0 2.0 35.0         11.0     9.0   78.0 94.0             *     *   172 115 2 35         11     9   78 94                 172
829563 NY Washington   school 3614970 641301060000   HUDSON FALLS 361497001252 641301060005 HUDSON FALLS PRIMARY SCHOOL public Regular School No 1 KG 03 2015   grade_2 150.0 1.0 14.0   0.0     2.0     12.0   85.0 94.0             106     26   179 150 1 14   0     2     12   85 94         106   26   179
1002820 NY Putnam   school 3605310 480601060000   BREWSTER 360531000267 480601060004 JOHN F KENNEDY ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 118.0 2.0 85.0   0.0     5.0     5.0   121.0 94.0     28       78     16   215 118 2 85   0     5     5   121 94     28   78   16   215
1008710 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202287 343000010069 PS 69 JACKSON HEIGHTS public Regular School No Elementary PK 05 2017   grade_2 12.0 1.0 54.0   0.0     86.0     1.0   60.0 94.0     46       58     16   154 12 1 54   0     86     1   60 94     46   58   16   154
1116003 NY Washington   school 3614970 641301060000   HUDSON FALLS 361497001252 641301060005 HUDSON FALLS PRIMARY SCHOOL public Regular School No 1.0 KG 03 2016   grade_2 160.0 1.0 5.0   1.0     0.0     12.0   85.0 94.0             109     41   179 160 1 5   1     0     12   85 94         109   41   179
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
1587051 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 2020   grade_2 11.0 13.0 118.0   0.0     51.0     3.0   102.0 94.0     21       168     31   196 11 13 118   0     51     3   102 94     21   168   31   196
1601890 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000170 580501030003 MARY G CLARKSON SCHOOL public Regular School No Elementary KG 02 2020   grade_2 46.0 26.0 99.0         13.0     7.0   97.0 94.0     38       120     22   191 46 26 99         13     7   97 94     38   120   22   191
2110236 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No Elementary KG 05 2018   grade_2 7.0 0.0 95.0   2.0     90.0     0.0   100.0 94.0     77       177     28   194 7 0 95   2     90     0   100 94     77   177   28   194
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
776154 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102689 332000010204 PS 204 VINCE LOMBARDI public Regular School No 1 PK 5 2015   grade_2 64.0 0.0 28.0   0.0     80.0     0.0   79.0 93.0             132     27   172 64 0 28   0     80     0   79 93         132   27   172
777484 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302549 332200010152 SCHOOL OF SCIENCE AND TECHNOLOGY public Regular School No 1 PK 5 2015   grade_2 3.0 135.0 42.0   3.0     7.0     3.0   100.0 93.0             132     42   193 3 135 42   3     7     3   100 93         132   42   193
792114 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702076 310200010011 PS 11 WILLIAM T HARRIS public Regular School No 1 PK 05 2015   grade_2 91.0 13.0 42.0   0.0     28.0     7.0   88.0 93.0             48     29   181 91 13 42   0     28     7   88 93         48   29   181
797453 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008302648 310600010189 PS 189 public Regular School No 1 PK 05 2015   grade_2 0.0 1.0 173.0         0.0     0.0   81.0 93.0             163     26   174 0 1 173         0     0   81 93         163   26   174
806877 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802340 342400010088 PS 88 SENECA public Regular School No 1 PK 05 2015   grade_2 64.0 6.0 86.0   0.0     5.0     0.0   68.0 93.0             121     30   161 64 6 86   0     5     0   68 93         121   30   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]);