Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_2 · 33,045
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
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
772848 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502763 331700010249 PS 249 CATON (THE) public Regular School No 1 PK 5 2015   grade_2 7.0 69.0 91.0   0.0     11.0     0.0   94.0 84.0             133     41   178 7 69 91   0     11     0   94 84         133   41   178
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
826333 NY Suffolk   school 3613530 580905020000   HAMPTON BAYS 361353001107 580905020002 HAMPTON BAYS ELEMENTARY SCHOOL public Regular School No 1 KG 04 2015   grade_2 71.0 2.0 89.0   2.0     2.0     3.0   94.0 75.0             99     13   169 71 2 89   2     2     3   94 75         99   13   169
951045 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003369 321200010196 PS 196 public Regular School No Elementary PK 05 2017   grade_2 2.0 31.0 129.0   7.0     2.0         94.0 77.0     77       133     35   171 2 31 129   7     2         94 77     77   133   35   171
974149 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302695 332200010206 PS 206 JOSEPH F LAMB public Regular School No Elementary PK 8 2017   grade_2 80.0 4.0 27.0   2.0     89.0     2.0   94.0 110.0     59       138     28   204 80 4 27   2     89     2   94 110     59   138   28   204
1004150 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202476 342500010129 PS 129 PATRICIA LARKIN public Regular School No Elementary PK 05 2017   grade_2 32.0 5.0 87.0   2.0     58.0     0.0   94.0 90.0     46       145     27   184 32 5 87   2     58     0   94 90     46   145   27   184
1009071 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202594 343000010166 PS 166 HENRY GRADSTEIN public Regular School No Elementary PK 05 2017   grade_2 42.0 9.0 88.0   1.0     33.0     2.0   94.0 81.0     48       128     27   175 42 9 88   1     33     2   94 81     48   128   27   175
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
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
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
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
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
1584087 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No Elementary KG 05 2020   grade_2 5.0 0.0 62.0   2.0     107.0     1.0   94.0 83.0     60       150     28   177 5 0 62   2     107     1   94 83     60   150   28   177
2055155 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702121 321000010024 PS 24 SPUYTEN DUYVIL public Regular School No Elementary KG 05 2018   grade_2 51.0 17.0 70.0   0.0     20.0     5.0   94.0 69.0     8       46     *   163 51 17 70   0     20     5   94 69     8   46       163
2111319 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202105 342500010020 PS 20 JOHN BOWNE public Regular School No Elementary PK 05 2018   grade_2 1.0 9.0 46.0   1.0     114.0     1.0   94.0 78.0     67       159     34   172 1 9 46   1     114     1   94 78     67   159   34   172
2111509 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202476 342500010129 PS 129 PATRICIA LARKIN public Regular School No Elementary KG 05 2018   grade_2 31.0 3.0 85.0   4.0     55.0     0.0   94.0 84.0     40       137     34   178 31 3 85   4     55     0   94 84     40   137   34   178
2115119 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102153 342900010033 PS 33 EDWARD M FUNK public Regular School No Elementary KG 05 2018   grade_2 6.0 24.0 54.0   7.0     81.0     4.0   94.0 82.0     47       145     21   176 6 24 54   7     81     4   94 82     47   145   21   176
2127697 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003727 580413030003 OAKWOOD PRIMARY CENTER public Regular School No Elementary KG 02 2018   grade_2 67.0 10.0 106.0         8.0     6.0   94.0 103.0     60       116     20   197 67 10 106         8     6   94 103     60   116   20   197
2127868 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000170 580501030003 MARY G CLARKSON SCHOOL public Regular School No Elementary KG 02 2018   grade_2 39.0 28.0 86.0   2.0     13.0     8.0   94.0 82.0     20       *     24   176 39 28 86   2     13     8   94 82     20       24   176
2135582 NY Westchester   school 3620160 660801060000   MT PLEASANT CENT 362016001847 660801060003 HAWTHORNE ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2018   grade_2 129.0 2.0 24.0         12.0     2.0   94.0 75.0     7       11     21   169 129 2 24         12     2   94 75     7   11   21   169
812501 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202451 343000010122 PS 122 MAMIE FAY public Regular School No 1 PK 08 2015   grade_2 61.0 21.0 40.0   0.0     46.0     9.0   93.0 84.0             95     31   177 61 21 40   0     46     9   93 84         95   31   177
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
1078858 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702480 310200010130 PS 130 HERNANDO DE SOTO public Regular School No 1.0 PK 05 2016   grade_2 12.0 4.0 15.0   0.0     143.0     5.0   93.0 86.0             80     23   179 12 4 15   0     143     5   93 86         80   23   179
1085280 NY Niagara   school 3628050 401001060000   STARPOINT 362805004790 401001060003 FRICANO PRIMARY SCHOOL public Regular School No 1.0 KG 02 2016   grade_2 169.0 2.0 4.0         2.0     4.0   93.0 88.0             *     17   181 169 2 4         2     4   93 88             17   181
1099112 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202594 343000010166 PS 166 HENRY GRADSTEIN public Regular School No 1.0 PK 05 2016   grade_2 52.0 9.0 75.0   2.0     62.0     0.0   93.0 107.0             133     16   200 52 9 75   2     62     0   93 107         133   16   200
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
1541793 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   grade_2 57.0 60.0 15.0   0.0     12.0     26.0   93.0 77.0     14       122     25   170 57 60 15   0     12     26   93 77     14   122   25   170
1555416 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 2020   grade_2 27.0 8.0 27.0   2.0     98.0     3.0   93.0 72.0     42       127     19   165 27 8 27   2     98     3   93 72     42   127   19   165
1581389 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932003199 441000010015 MAPLE HILL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_2 14.0 48.0 105.0         2.0     8.0   93.0 84.0     17       136     27   177 14 48 105         2     8   93 84     17   136   27   177
1609623 NY Westchester   school 3620160 660801060000   MT PLEASANT CENT 362016001847 660801060003 HAWTHORNE ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   grade_2 129.0   19.0   0.0     7.0     5.0   93.0 67.0     7       13     27   160 129   19   0     7     5   93 67     7   13   27   160
2075238 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202740 331500010230 PS 230 DORIS L COHEN public Regular School No Elementary PK 05 2018   grade_2 27.0 3.0 61.0   0.0     80.0     1.0   93.0 79.0     65       128     34   172 27 3 61   0     80     1   93 79     65   128   34   172
2079950 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102692 332000010205 PS 205 CLARION public Regular School No Elementary PK 05 2018   grade_2 45.0 1.0 36.0   1.0     121.0         93.0 111.0     67       144     33   204 45 1 36   1     121         93 111     67   144   33   204
2081413 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302695 332200010206 PS 206 JOSEPH F LAMB public Regular School No Elementary PK 08 2018   grade_2 67.0 5.0 17.0   0.0     71.0     1.0   93.0 68.0     68       126     26   161 67 5 17   0     71     1   93 68     68   126   26   161
2128780 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000260 580512030001 SOUTHWEST ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 8.0 24.0 125.0   1.0     8.0     1.0   93.0 74.0     65       154     36   167 8 24 125   1     8     1   93 74     65   154   36   167
2128894 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000255 580512030007 NORTHEAST ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 2.0 15.0 174.0   0.0     1.0     1.0   93.0 100.0     68       182     18   193 2 15 174   0     1     1   93 100     68   182   18   193
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
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
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
748528 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502632 320800010182 PS 182 public Regular School No 1.0 PK 05 2015   grade_2 2.0 51.0 109.0   0.0     12.0     1.0   92.0 83.0             153     39   175 2 51 109   0     12     1   92 83         153   39   175
807808 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202402 342500010107 PS 107 THOMAS A DOOLEY public Regular School No 1 PK 05 2015   grade_2 20.0 2.0 50.0   0.0     81.0     1.0   92.0 62.0             118     36   154 20 2 50   0     81     1   92 62         118   36   154
814040 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302051 353100010003 PS 3 MARGARET GIOIOSA SCHOOL (THE) public Regular School No 1 PK 05 2015   grade_2 126.0 0.0 18.0   0.0     11.0     4.0   92.0 67.0             44     33   159 126 0 18   0     11     4   92 67         44   33   159
815712 NY Rockland   school 3620190 500108030000   NANUET 362019001852 500108030002 GEORGE W MILLER ELEMENTARY SCHOOL public Regular School No 1 KG 02 2015   grade_2 93.0 7.0 36.0         31.0     3.0   92.0 78.0             41     24   170 93 7 36         31     3   92 78         41   24   170
949506 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802306 321100010076 PS 76 BENNINGTON SCHOOL (THE) public Regular School No Elementary KG 05 2017   grade_2 15.0 84.0 64.0   0.0     2.0     0.0   92.0 73.0     15       98     30   165 15 84 64   0     2     0   92 73     15   98   30   165
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
1062670 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102689 332000010204 PS 204 VINCE LOMBARDI public Regular School No 1.0 PK 5 2016   grade_2 59.0 0.0 37.0   1.0     97.0     0.0   92.0 102.0             157     29   194 59 0 37   1     97     0   92 102         157   29   194
1094153 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202314 342500010079 PS 79 FRANCIS LEWIS public Regular School No 1.0 PK 05 2016   grade_2 73.0 1.0 32.0   1.0     77.0     1.0   92.0 93.0             88     35   185 73 1 32   1     77     1   92 93         88   35   185
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
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
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
1527429 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602288 320900010070 PS 70 MAX SCHOENFELD public Regular School No Elementary PK 05 2020   grade_2 1.0 36.0 140.0   0.0     0.0         92.0 85.0     53       173     46   177 1 36 140   0     0         92 85     53   173   46   177
1585208 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202119 342500010024 PS 24 ANDREW JACKSON public Regular School No Elementary PK 05 2020   grade_2 2.0 1.0 20.0   2.0     135.0     4.0   92.0 72.0     62       125     21   164 2 1 20   2     135     4   92 72     62   125   21   164
1594157 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003770 500402060001 FLEETWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_2 2.0 28.0 146.0   0.0     1.0     0.0   92.0 85.0     105       164     17   177 2 28 146   0     1     0   92 85     105   164   17   177
1611599 NY Westchester   school 3627180 662101060000   SOMERS 362718003700 662101060002 PRIMROSE SCHOOL public Regular School No Elementary KG 02 2020   grade_2 136.0 2.0 31.0         2.0     9.0   92.0 88.0     *       25     30   180 136 2 31         2     9   92 88         25   30   180
2069139 NY Erie   school 3616440 141800010000   LACKAWANNA 361644005578 141800010011 MARTIN ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 83.0 31.0 25.0   0.0     6.0     10.0   92.0 63.0     40       145     28   155 83 31 25   0     6     10   92 63     40   145   28   155
2110730 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802551 342400010153 PS 153 MASPETH ELEMENTARY public Regular School No Elementary PK 06 2018   grade_2 90.0 0.0 56.0   1.0     18.0     1.0   92.0 74.0     11       121     39   166 90 0 56   1     18     1   92 74     11   121   39   166
2116297 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202451 343000010122 PS 122 MAMIE FAY public Regular School No Elementary PK 08 2018   grade_2 86.0 9.0 38.0   4.0     30.0     10.0   92.0 85.0     19       95     16   177 86 9 38   4     30     10   92 85     19   95   16   177
2133188 NY Washington   school 3614970 641301060000   HUDSON FALLS 361497001252 641301060005 HUDSON FALLS PRIMARY SCHOOL public Regular School No Elementary 01 03 2018   grade_2 149.0 4.0 8.0   1.0     1.0     12.0   92.0 83.0     *       105     39   175 149 4 8   1     1     12   92 83         105   39   175
2145082 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705139 321000010085 PS 85 GREAT EXPECTATIONS public Regular School No Elementary PK 05 2019   grade_2 0.0 38.0 103.0   0.0     4.0     1.0   92.0 54.0     58       141     35   146 0 38 103   0     4     1   92 54     58   141   35   146
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
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
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
759586 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE PRIMARYSCHOOL public Regular School No 1.0 KG 03 2015   grade_2 154.0 4.0 1.0         3.0     0.0   91.0 71.0             50     20   162 154 4 1         3     0   91 71         50   20   162
811608 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102494 342900010135 BELLAIRE SCHOOL (THE) public Regular School No 1 PK 05 2015   grade_2 5.0 44.0 36.0   14.0     53.0     3.0   91.0 64.0             91     21   155 5 44 36   14     53     3   91 64         91   21   155
812748 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010204785 343000010212 PS 212 public Regular School No 1 KG 05 2015   grade_2 15.0 2.0 98.0   1.0     34.0     0.0   91.0 59.0             77     25   150 15 2 98   1     34     0   91 59         77   25   150
831159 NY Westchester   school 3615450 660402020000   IRVINGTON 361545004903 660402020004 DOWS LANE (K-3) SCHOOL public Regular School No 1 KG 03 2015   grade_2 91.0 7.0 17.0         24.0     7.0   91.0 55.0             9     14   146 91 7 17         24     7   91 55         9   14   146
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
1003181 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802340 342400010088 PS 88 SENECA public Regular School No Elementary PK 05 2017   grade_2 67.0 4.0 94.0   0.0     7.0     2.0   91.0 83.0     33       118     25   174 67 4 94   0     7     2   91 83     33   118   25   174
1003390 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802551 342400010153 PS 153 MASPETH ELEMENTARY public Regular School No Elementary PK 06 2017   grade_2 84.0 3.0 73.0   1.0     18.0     1.0   91.0 89.0     14       124     37   180 84 3 73   1     18     1   91 89     14   124   37   180
1021801 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000471 580513030007 ANDREW T MORROW SCHOOL public Regular School No Elementary 01 05 2017   grade_2 13.0 33.0 142.0   0.0     7.0     0.0   91.0 104.0     76       147     28   195 13 33 142   0     7     0   91 104     76   147   28   195
1098713 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202077 343000010011 PS 11 KATHRYN PHELAN public Regular School No 1.0 KG 06 2016   grade_2 15.0 3.0 82.0   1.0     58.0     5.0   91.0 73.0             81     27   164 15 3 82   1     58     5   91 73         81   27   164
1101088 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302196 353100010044 PS 44 THOMAS C BROWN public Regular School No 1.0 PK 05 2016   grade_2 3.0 57.0 96.0   1.0     4.0     5.0   91.0 75.0             159     58   166 3 57 96   1     4     5   91 75         159   58   166
1101468 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302286 353100010069 PS 69 DANIEL D TOMPKINS public Regular School No 1.0 PK 05 2016   grade_2 92.0 4.0 38.0   1.0     29.0     3.0   91.0 76.0             79     49   167 92 4 38   1     29     3   91 76         79   49   167
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
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
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
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
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
1585284 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202314 342500010079 PS 79 FRANCIS LEWIS public Regular School No Elementary PK 05 2020   grade_2 44.0 1.0 29.0   0.0     103.0     2.0   91.0 88.0     32       96     29   179 44 1 29   0     103     2   91 88     32   96   29   179
1594271 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781004569 500402060010 SUMMIT PARK ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2020   grade_2 2.0 45.0 128.0         7.0     0.0   91.0 91.0     77       167     30   182 2 45 128         7     0   91 91     77   167   30   182
1599990 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001755 580212060003 RIDGE ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_2 81.0 24.0 31.0   0.0     4.0     9.0   91.0 58.0     *       66     30   149 81 24 31   0     4     9   91 58         66   30   149
2128970 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000261 580512030013 TWIN PINES ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 3.0 10.0 165.0   0.0     0.0     1.0   91.0 88.0     75       167     19   179 3 10 165   0     0     1   91 88     75   167   19   179
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
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
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
803894 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932003199 441000010015 MAPLE HILL ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 30.0 42.0 114.0   0.0     4.0     11.0   90.0 111.0             163     28   201 30 42 114   0     4     11   90 111         163   28   201
807105 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802678 342400010199 PS 199 MAURICE A FITZGERALD public Regular School No 1 KG 05 2015   grade_2 16.0 2.0 113.0   2.0     67.0     1.0   90.0 111.0             117     29   201 16 2 113   2     67     1   90 111         117   29   201
807789 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202314 342500010079 PS 79 FRANCIS LEWIS public Regular School No 1 PK 05 2015   grade_2 62.0 0.0 29.0   1.0     86.0     1.0   90.0 89.0             95     23   179 62 0 29   1     86     1   90 89         95   23   179
813546 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001496 490601060008 TURNPIKE ELEMENTARY SCHOOL public Regular School No 1 PK 02 2015   grade_2 107.0 21.0 25.0         1.0     13.0   90.0 77.0             123     29   167 107 21 25         1     13   90 77         123   29   167
967917 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202740 331500010230 PS 230 DORIS L COHEN public Regular School No Elementary PK 5 2017   grade_2 29.0 5.0 62.0   0.0     82.0     3.0   90.0 91.0     63       103     27   181 29 5 62   0     82     3   90 91     63   103   27   181
999970 NY Orange   school 3612330 440601040000   GOSHEN 361233000998 440601040003 SCOTCHTOWN AVENUE SCHOOL public Regular School No Elementary KG 02 2017   grade_2 121.0 9.0 48.0   0.0     6.0     6.0   90.0 100.0     *       63     26   190 121 9 48   0     6     6   90 100         63   26   190
1018609 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001756 580212060004 WEST MIDDLE ISLAND SCHOOL public Regular School No Elementary KG 04 2017   grade_2 86.0 22.0 41.0   0.0     7.0     7.0   90.0 73.0     9       80     24   163 86 22 41   0     7     7   90 73     9   80   24   163
1092956 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No 1.0 KG 05 2016   grade_2 7.0 1.0 74.0   0.0     113.0         90.0 105.0             177     32   195 7 1 74   0     113         90 105         177   32   195
1096965 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002448 342800010121 PS 121 public Regular School No 1.0 PK 05 2016   grade_2 1.0 36.0 21.0   17.0     100.0     3.0   90.0 88.0             146     21   178 1 36 21   17     100     3   90 88         146   21   178
1097706 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102153 342900010033 PS 33 EDWARD M FUNK public Regular School No 1.0 KG 05 2016   grade_2 5.0 34.0 41.0   22.0     72.0     2.0   90.0 86.0             143     26   176 5 34 41   22     72     2   90 86         143   26   176
1102798 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003770 500402060001 FLEETWOOD ELEMENTARY SCHOOL public Regular School No 1.0 KG 03 2016   grade_2 9.0 41.0 117.0   0.0     6.0     0.0   90.0 83.0             157     25   173 9 41 117   0     6     0   90 83         157   25   173
1111557 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000260 580512030001 SOUTHWEST ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 12.0 16.0 146.0   1.0     4.0     4.0   90.0 93.0             153     32   183 12 16 146   1     4     4   90 93         153   32   183
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
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

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