Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_2", state = "NY" and year = 2018 sorted by male descending

View and edit SQL

year

  • 2018 · 4,722

grade

  • grade_2 · 4,722
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
2127754 NY Suffolk   school 3627300 580413030000   SOUTH HUNTINGTON 362730003723 580413030009 COUNTRYWOOD PRIMARY CENTER public Regular School No Elementary KG 02 2018   grade_2 76.0 28.0 82.0   3.0     10.0     6.0   99.0 106.0     50       117     28   205 76 28 82   3     10     6   99 106     50   117   28   205
2056903 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802323 321100010083 PS 83 DONALD HERTZ public Regular School No Elementary KG 08 2018   grade_2 62.0 9.0 87.0   1.0     12.0     0.0   98.0 73.0     39       116     32   171 62 9 87   1     12     0   98 73     39   116   32   171
2137577 NY Westchester   school 3627180 662101060000   SOMERS 362718003700 662101060002 PRIMROSE SCHOOL public Regular School No Elementary KG 02 2018   grade_2 141.0 1.0 25.0         7.0     5.0   98.0 81.0     *       22     30   179 141 1 25         7     5   98 81         22   30   179
2067999 NY Erie   school 3618600 140702030000   MARYVALE 361860001679 140702030003 MARYVALE PRIMARY SCHOOL public Regular School No Elementary PK 02 2018   grade_2 118.0 21.0 8.0   3.0     10.0     5.0   97.0 68.0     13       96     23   165 118 21 8   3     10     5   97 68     13   96   23   165
2118425 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302189 353100010042 PS 42 ELTINGVILLE public Regular School No Elementary PK 05 2018   grade_2 129.0 2.0 35.0   0.0     19.0     0.0   97.0 88.0     7       66     53   185 129 2 35   0     19     0   97 88     7   66   53   185
2120230 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003776 500402060005 MARGETTS ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 16.0 43.0 101.0   0.0     7.0     4.0   97.0 74.0     88       163     16   171 16 43 101   0     7     4   97 74     88   163   16   171
2128875 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000253 580512030006 NORTH ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 5.0 9.0 192.0   0.0     3.0     3.0   97.0 115.0     93       188     38   212 5 9 192   0     3     3   97 115     93   188   38   212
2056865 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802306 321100010076 PS 76 BENNINGTON SCHOOL (THE) public Regular School No Elementary KG 05 2018   grade_2 17.0 62.0 73.0   1.0     9.0     2.0   95.0 69.0     32       134     36   164 17 62 73   1     9     2   95 69     32   134   36   164
2069766 NY Erie   school 3600025 142601860031   CHARTER SCHOOL FOR APPLIED TE 360002504349 142601860031 CHARTER SCHOOL FOR APPLIED TECHNOLOG charter Regular School Yes Other KG 12 2018   grade_2 34.0 62.0 57.0   1.0     12.0     19.0   95.0 90.0     9       168     23   185 34 62 57   1     12     19   95 90     9   168   23   185
2072179 NY Herkimer   school 3601087 212101040000   C-V AT ILION-MOHAWK CSD 360108701282 212101040006 BARRINGER ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2018   grade_2 189.0 0.0 4.0         1.0     7.0   95.0 106.0     *       131     25   201 189 0 4         1     7   95 106         131   25   201
2107538 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932003199 441000010015 MAPLE HILL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 33.0 43.0 98.0   1.0     1.0     8.0   95.0 89.0     29       146     26   184 33 43 98   1     1     8   95 89     29   146   26   184
2111338 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202109 342500010021 PS 21 EDWARD HART public Regular School No Elementary PK 05 2018   grade_2 11.0 0.0 65.0   1.0     120.0     1.0   95.0 103.0     52       162     28   198 11 0 65   1     120     1   95 103     52   162   28   198
2111452 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202314 342500010079 PS 79 FRANCIS LEWIS public Regular School No Elementary PK 05 2018   grade_2 44.0 1.0 33.0   0.0     92.0     1.0   95.0 76.0     16       95     26   171 44 1 33   0     92     1   95 76     16   95   26   171
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
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
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
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
2064313 NY Delaware   school 3613560 120906040000   HANCOCK 361356001109 120906040001 HANCOCK ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_2 20.0 0.0 0.0   1.0     0.0         9.0 12.0     *       16     *   21 20 0 0   1     0         9 12         16       21
2073262 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009102796 331300010287 PS 287 BAILEY K ASHFORD public Regular School No Elementary PK 05 2018   grade_2 1.0 9.0 3.0   1.0     2.0     2.0   9.0 9.0     *       16     5   18 1 9 3   1     2     2   9 9         16   5   18
2073965 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902096 331400010018 PS 18 EDWARD BUSH public Regular School No Elementary PK 05 2018   grade_2 2.0 4.0 18.0         0.0     0.0   9.0 15.0     *       23     9   24 2 4 18         0     0   9 15         23   9   24
2085308 NY Monroe   school 3615390 260803060000   WEST IRONDEQUOIT 361539004594 260803060012 BROOKVIEW SCHOOL public Regular School No Elementary KG 03 2018   grade_2 17.0 3.0 3.0   0.0     0.0     2.0   9.0 16.0             11     0   25 17 3 3   0     0     2   9 16         11   0   25
2094086 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504780 307500011138 PS 138 public Special Education School No Other KG 12 2018   grade_2 0.0 4.0 9.0   0.0     1.0     0.0   9.0 5.0     5       14     14   14 0 4 9   0     1     0   9 5     5   14   14   14
2094618 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502826 307500013370 PS 370 public Special Education School No Other KG 12 2018   grade_2 1.0 4.0 3.0         1.0     0.0   9.0 0.0     *       8     9   9 1 4 3         1     0   9 0         8   9   9
2095283 NY New York   school 3600076 310100010000   NYC GEOG DIST # 1 - MANHATTAN 360007602511 310100010140 PS 140 NATHAN STRAUS public Regular School No Elementary PK 08 2018   grade_2 1.0 1.0 21.0   0.0     1.0         9.0 15.0     *       22     7   24 1 1 21   0     1         9 15         22   7   24
2109400 NY Otsego   school 3604757 470202040000   GLBTSVLLE-MT UPTON 360475704759 470202040002 GILBERTSVILLE-MOUNT UPTON ELEM SCH public Regular School No Elementary PK 06 2018   grade_2 20.0 0.0 0.0               1.0   9.0 12.0             14     *   21 20 0 0               1   9 12         14       21
2112858 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302208 342700010047 PS 47 CHRIS GALAS public Regular School No Elementary PK 08 2018   grade_2 12.0 0.0 7.0         0.0     0.0   9.0 10.0     *       10     10   19 12 0 7         0     0   9 10         10   10   19
2120572 NY Saint Lawrence   school 3608100 510501040000   COLTON PIERREPONT 360810000576 510501040001 COLTON-PIERREPONT CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 21.0 0.0           0.0         9.0 12.0             7     *   21 21 0           0         9 12         7       21
2130205 NY Suffolk   school 3629070 580913080000   TUCKAHOE COMMON 362907003925 580913080001 TUCKAHOE SCHOOL public Regular School No Elementary PK 08 2018   grade_2 7.0 0.0 14.0   0.0     0.0     0.0   9.0 12.0     6       15     *   21 7 0 14   0     0     0   9 12     6   15       21
2056941 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802342 321100010089 PS 89 public Regular School No Elementary PK 08 2018   grade_2 27.0 42.0 95.0   1.0     14.0     1.0   89.0 91.0     49       143     32   180 27 42 95   1     14     1   89 91     49   143   32   180
2076321 NY Kings   school 3600114 331600860860   EXCELLENCE BOYS CHAR SCH-B S 360011405700 331600860860 EXCELLENCE BOYS CHAR SCH-BED STUY charter Regular School Yes Elementary KG 08 2018   grade_2 2.0 67.0 16.0   1.0     3.0     0.0   89.0 0.0     0       72     23   89 2 67 16   1     3     0   89 0     0   72   23   89
2112934 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302259 342700010060 PS 60 WOODHAVEN public Regular School No Elementary PK 05 2018   grade_2 8.0 5.0 130.0   12.0     22.0     1.0   89.0 89.0     43       161     26   178 8 5 130   12     22     1   89 89     43   161   26   178
2119698 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001147 500201060011 THIELLS ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 48.0 18.0 111.0   1.0     9.0     2.0   88.0 101.0     31       108     23   189 48 18 111   1     9     2   88 101     31   108   23   189
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
2128837 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 3.0 7.0 145.0         0.0     0.0   88.0 67.0     72       150     37   155 3 7 145         0     0   88 67     72   150   37   155
2136570 NY Westchester   school 3606060 661201060000   BYRAM HILLS 360606000390 661201060002 COMAN HILL SCHOOL public Regular School No Elementary KG 02 2018   grade_2 132.0 0.0 13.0         8.0     8.0   88.0 73.0     *       5     18   161 132 0 13         8     8   88 73         5   18   161
2057017 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802394 321100010105 PS 105 SEN ABRAHAM BERNSTEIN public Regular School No Elementary KG 05 2018   grade_2 33.0 22.0 110.0   1.0     10.0     1.0   87.0 90.0     62       165     41   177 33 22 110   1     10     1   87 90     62   165   41   177
2071020 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2018   grade_2 109.0 13.0 14.0   0.0     1.0     21.0   87.0 71.0     *       108     11   158 109 13 14   0     1     21   87 71         108   11   158
2117342 NY Rensselaer   school 3616740 490601060000   LANSINGBURGH 361674001496 490601060008 TURNPIKE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2018   grade_2 96.0 30.0 21.0   0.0     4.0     16.0   87.0 80.0     *       133     25   167 96 30 21   0     4     16   87 80         133   25   167
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
2057036 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802397 321100010106 PS 106 PARKCHESTER public Regular School No Elementary PK 05 2018   grade_2 4.0 46.0 56.0   1.0     54.0     1.0   86.0 76.0     34       123     *   162 4 46 56   1     54     1   86 76     34   123       162
2080121 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015105908 332000010503 PS 503 SCHOOL OF DISCOVERY (THE) public Regular School No Elementary KG 05 2018   grade_2 8.0 1.0 142.0   0.0     35.0     2.0   86.0 102.0     128       180     43   188 8 1 142   0     35     2   86 102     128   180   43   188
2129198 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000471 580513030007 ANDREW T MORROW SCHOOL public Regular School No Elementary 01 05 2018   grade_2 9.0 26.0 121.0         4.0     0.0   86.0 74.0     63       133     27   160 9 26 121         4     0   86 74     63   133   27   160
2136475 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049004400 661100010009 WILLIAM B WARD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 76.0 23.0 54.0   1.0     13.0     1.0   86.0 82.0     19       59     18   168 76 23 54   1     13     1   86 82     19   59   18   168
2110616 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806323 342400010110 PS 110 public Regular School No Elementary KG 05 2018   grade_2 1.0 1.0 177.0   1.0     11.0         85.0 106.0     75       181     34   191 1 1 177   1     11         85 106     75   181   34   191
2125968 NY Suffolk   school 3619230 580212060000   LONGWOOD 361923001755 580212060003 RIDGE ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2018   grade_2 77.0 24.0 36.0   0.0     0.0     5.0   85.0 57.0     7       74     38   142 77 24 36   0     0     5   85 57     7   74   38   142
2052381 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502293 320800010071 PS 71 ROSE E SCALA public Regular School No Elementary KG 08 2018   grade_2 48.0 6.0 105.0   1.0     12.0     1.0   84.0 89.0     19       125     43   173 48 6 105   1     12     1   84 89     19   125   43   173
2055250 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702204 321000010046 PS 46 EDGAR ALLAN POE public Regular School No Elementary KG 05 2018   grade_2 5.0 20.0 122.0   2.0     4.0     0.0   84.0 69.0     59       143     36   153 5 20 122   2     4     0   84 69     59   143   36   153
2058385 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009003353 321200010195 PS 195 public Regular School No Elementary PK 05 2018   grade_2 0.0 14.0 146.0   0.0     1.0     1.0   84.0 78.0     53       149     33   162 0 14 146   0     1     1   84 78     53   149   33   162
2118843 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302286 353100010069 PS 69 DANIEL D TOMPKINS public Regular School No Elementary PK 05 2018   grade_2 81.0 7.0 30.0   0.0     23.0     5.0   84.0 62.0     18       80     34   146 81 7 30   0     23     5   84 62     18   80   34   146
2134936 NY Westchester   school 3603180 660405030000   ARDSLEY 360318000082 660405030003 CONCORD ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2018   grade_2 89.0 8.0 19.0         31.0     7.0   84.0 70.0     6       5     11   154 89 8 19         31     7   84 70     6   5   11   154
2053616 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602232 320900010053 PS 53 BASHEER QUISIM public Regular School No Elementary PK 05 2018   grade_2 3.0 55.0 107.0   0.0     1.0         83.0 83.0     63       159     24   166 3 55 107   0     1         83 83     63   159   24   166
2079931 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102689 332000010204 PS 204 VINCE LOMBARDI public Regular School No Elementary PK 05 2018   grade_2 50.0 0.0 39.0   1.0     84.0     0.0   83.0 91.0     28       126     32   174 50 0 39   1     84     0   83 91     28   126   32   174
2110331 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 2018   grade_2 1.0   151.0   0.0     13.0     1.0   83.0 83.0     97       143     47   166 1   151   0     13     1   83 83     97   143   47   166
2114511 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002614 342800010175 PS 175 LYNN GROSS DISCOVERY (THE) public Regular School No Elementary PK 05 2018   grade_2 85.0 0.0 17.0         19.0     3.0   83.0 41.0     13       75     23   124 85 0 17         19     3   83 41     13   75   23   124
2052514 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502441 320800010119 EMMETT W BASSETT SCHOOL public Regular School No Elementary PK 05 2018   grade_2 11.0 19.0 67.0   5.0     46.0     0.0   82.0 66.0     47       125     41   148 11 19 67   5     46     0   82 66     47   125   41   148
2074896 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202139 331500010029 PS 29 JOHN M HARRIGAN public Regular School No Elementary PK 05 2018   grade_2 122.0 5.0 23.0   0.0     6.0     7.0   82.0 81.0     6       21     30   163 122 5 23   0     6     7   82 81     6   21   30   163
2078297 NY Kings   school 3600966 331800860916   BROOKLYN ASCEND CHARTER SCHO 360096606069 331800860916 BROOKLYN ASCEND CHARTER SCHOOL charter Regular School Yes Other KG 11 2018   grade_2 2.0 135.0 7.0   0.0     2.0     0.0   82.0 64.0     0       118     16   146 2 135 7   0     2     0   82 64     0   118   16   146
2080045 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102761 332000010247 PS 247 public Regular School No Elementary KG 05 2018   grade_2 46.0 1.0 20.0   1.0     76.0         82.0 62.0     53       104     25   144 46 1 20   1     76         82 62     53   104   25   144
2112953 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302265 342700010062 PS 62 CHESTER PARK SCHOOL public Regular School No Elementary PK 05 2018   grade_2 2.0 7.0 45.0   21.0     82.0     0.0   82.0 75.0     24       115     19   157 2 7 45   21     82     0   82 75     24   115   19   157
2119622 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001146 500201060004 STONY POINT ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 54.0 19.0 109.0   1.0     5.0     0.0   82.0 106.0     32       113     38   188 54 19 109   1     5     0   82 106     32   113   38   188
2120154 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003770 500402060001 FLEETWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 4.0 26.0 128.0   0.0     3.0     0.0   82.0 79.0     72       151     19   161 4 26 128   0     3     0   82 79     72   151   19   161
2075257 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202778 331500010261 PS 261 PHILIP LIVINGSTON public Regular School No Elementary PK 05 2018   grade_2 54.0 43.0 24.0   0.0     5.0     9.0   81.0 54.0     *       59     33   135 54 43 24   0     5     9   81 54         59   33   135
2077670 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602429 331800010115 PS 115 DANIEL MUCATEL SCHOOL public Regular School No Elementary PK 05 2018   grade_2 5.0 126.0 11.0   4.0     4.0     0.0   81.0 69.0     13       96     25   150 5 126 11   4     4     0   81 69     13   96   25   150
2098228 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802335 310300010087 PS 87 WILLIAM SHERMAN public Regular School No Elementary PK 05 2018   grade_2 109.0 6.0 21.0   0.0     15.0     12.0   81.0 82.0     *       22     41   163 109 6 21   0     15     12   81 82         22   41   163
2101800 NY Niagara   school 3617190 400301060000   LEWISTON PORTER 361719004819 400301060002 PRIMARY EDUCATION CENTER public Regular School No Elementary PK 03 2018   grade_2 137.0 0.0 6.0   0.0     5.0     7.0   81.0 74.0     *       42     18   155 137 0 6   0     5     7   81 74         42   18   155
2111433 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202148 342500010032 PS 32 STATE STREET public Regular School No Elementary PK 05 2018   grade_2 22.0 2.0 26.0   0.0     103.0     5.0   81.0 77.0     30       96     20   158 22 2 26   0     103     5   81 77     30   96   20   158
2116468 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202548 343000010152 PS 152 GWENDOLINE N ALLEYNE public Regular School No Elementary PK 05 2018   grade_2 8.0 1.0 72.0   2.0     67.0     0.0   81.0 69.0     75       118     22   150 8 1 72   2     67     0   81 69     75   118   22   150
2118121 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302113 353100010022 PS 22 GRANITEVILLE public Regular School No Elementary PK 05 2018   grade_2 17.0 44.0 100.0   0.0     12.0     8.0   81.0 100.0     38       165     55   181 17 44 100   0     12     8   81 100     38   165   55   181
2125056 NY Suffolk   school 3615780 580203020000   BROOKHAVEN-COMSEWOGUE UFSD 361578001361 580203020005 CLINTON AVENUE SCHOOL public Regular School No Elementary KG 02 2018   grade_2 93.0 3.0 59.0   0.0     6.0     2.0   81.0 82.0     13       61     32   163 93 3 59   0     6     2   81 82     13   61   32   163
2125303 NY Suffolk   school 3625350 580205060000   SACHEM 362535003499 580205060015 CHIPPEWA ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 85.0 4.0 28.0   0.0     11.0     2.0   81.0 49.0     *       40     52   130 85 4 28   0     11     2   81 49         40   52   130
2125531 NY Suffolk   school 3619410 580208020000   MILLER PLACE 361941001774 580208020002 ANDREW MULLER PRIMARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 144.0 4.0 8.0         2.0     3.0   81.0 80.0     5       28     *   161 144 4 8         2     3   81 80     5   28       161
2136399 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049001893 661100010002 COLUMBUS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 7.0 14.0 126.0         4.0     3.0   81.0 73.0     55       128     12   154 7 14 126         4     3   81 73     55   128   12   154
2056960 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802364 321100010096 PS 96 RICHARD RODGERS public Regular School No Elementary KG 05 2018   grade_2 14.0 35.0 101.0   1.0     6.0     1.0   80.0 78.0     23       136     31   158 14 35 101   1     6     1   80 78     23   136   31   158
2079741 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102603 332000010170 RALPH A FABRIZIO SCHOOL public Regular School No Elementary KG 05 2018   grade_2 41.0 0.0 18.0   0.0     94.0     0.0   80.0 73.0     55       *     *   153 41 0 18   0     94     0   80 73     55           153
2081261 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302507 332200010139 PS 139 ALEXINE A FENTY public Regular School No Elementary PK 05 2018   grade_2 14.0 40.0 59.0   1.0     31.0     4.0   80.0 69.0     37       129     25   149 14 40 59   1     31     4   80 69     37   129   25   149
2118729 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302257 353100010060 PS 60 ALICE AUSTEN public Regular School No Elementary PK 05 2018   grade_2 70.0 13.0 36.0   0.0     18.0     6.0   80.0 63.0     9       82     38   143 70 13 36   0     18     6   80 63     9   82   38   143
2050481 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2018   grade_2 19.0 1.0 0.0         1.0     0.0   8.0 13.0             16     *   21 19 1 0         1     0   8 13         16       21
2060171 NY Cattaraugus   school 3630900 40204040000   WEST VALLEY 363090004153 40204040001 WEST VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 13.0 0.0 0.0               0.0   8.0 5.0             9     *   13 13 0 0               0   8 5         9       13
2069956 NY Essex   school 3608610 150203040000   CROWN POINT 360861000661 150203040001 CROWN POINT CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 23.0   0.0         0.0         8.0 15.0             18     5   23 23   0         0         8 15         18   5   23
2069975 NY Essex   school 3610440 150301040000   ELIZABETHTOWN 361044000804 150301040001 ELIZABETHTOWN-LEWIS CENTRAL SCHOOL public Regular School No Other KG 12 2018   grade_2 12.0 0.0 0.0   0.0     0.0         8.0 4.0             9     *   12 12 0 0   0     0         8 4         9       12
2070127 NY Essex   school 3626130 151401040000   SCHROON LAKE 362613003599 151401040001 SCHROON LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 16.0 0.0 0.0                   8.0 8.0     *       9     *   16 16 0 0                   8 8         9       16
2070450 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574004620 161401060004 BLOOMINGDALE SCHOOL public Regular School No Elementary KG 05 2018   grade_2 21.0                       8.0 13.0             8     0   21 21                       8 13         8   0   21
2072027 NY Herkimer   school 3622200 211701040000   VAN HORNSVILLE 362220003142 211701040001 OWEN D YOUNG CENTRAL SCHOOL public Regular School No Other KG 12 2018   grade_2 11.0 0.0 0.0               1.0   8.0 4.0     *       5     0   12 11 0 0               1   8 4         5   0   12
2073300 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009102809 331300010305 PS 305 DR PETER RAY public Regular School No Elementary PK 05 2018   grade_2 2.0 11.0 2.0   1.0     0.0         8.0 8.0     *       16     *   16 2 11 2   1     0         8 8         16       16
2076036 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402779 331600010262 PS 262 EL HAJJ MALIK EL SHABAZZ public Regular School No Elementary PK 05 2018   grade_2 1.0 14.0 5.0         0.0     0.0   8.0 12.0     0       18     *   20 1 14 5         0     0   8 12     0   18       20
2082154 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012102623 332300010178 PS 178 SAINT CLAIR MCKELWAY public Regular School No Elementary PK 08 2018   grade_2 0.0 23.0 5.0   0.0     0.0         8.0 20.0     *       25     *   28 0 23 5   0     0         8 20         25       28
2083978 NY Madison   school 3605670 250109040000   BROOKFIELD 360567000292 250109040001 BROOKFIELD CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_2 19.0 0.0 0.0               1.0   8.0 12.0             15     *   20 19 0 0               1   8 12         15       20

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