Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_2", state = "NY" and year = 2018 sorted by disability_int 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
2049740 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2018   grade_2 0.0 64.0 11.0         0.0     3.0   37.0 41.0     *       72         78 0 64 11         0     3   37 41         72       78
2087132 NY Monroe   school 3601040 261600860705   TRUE NORTH ROCHESTER-WEST 360104006243 261600860705 TRUE NORTH ROCHESTER PREP-WEST CAMP charter Regular School Yes Elementary KG 08 2018   grade_2 3.0 77.0 13.0         0.0         48.0 45.0     *       81         93 3 77 13         0         48 45         81       93
2097145 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706169 310200011394 EMMA LAZARUS HIGH SCHOOL public Regular School No Secondary 09 11 2018   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     0       0         0 0 0 0   0     0         0 0     0   0       0
2102199 NY Niagara   school 3600164 400701860890   NIAGARA CHARTER SCHOOL 360016405887 400701860890 NIAGARA CHARTER SCHOOL charter Regular School Yes Elementary KG 06 2018   grade_2 8.0 24.0 5.0   2.0           13.0   27.0 25.0             50         52 8 24 5   2           13   27 25         50       52
2108165 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2018   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0         0 0 0 0         0     0   0 0     0   0       0
2130091 NY Suffolk   school 3625410 580910080000   SAGAPONACK 362541003516 580910080001 SAGAPONACK SCHOOL public Regular School No Elementary KG 03 2018   grade_2 2.0   1.0                   1.0 2.0                       3 2   1                   1 2                 3
2130395 NY Suffolk   school 3620520 581015080000   NEW SUFFOLK 362052001905 581015080001 NEW SUFFOLK SCHOOL public Regular School No Elementary PK 06 2018   grade_2 2.0   0.0                   1.0 1.0     *                 2 2   0                   1 1                 2
2110312 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No Elementary KG 05 2018   grade_2 1.0 2.0 297.0   1.0     9.0     0.0   145.0 165.0     192       294     81   310 1 2 297   1     9     0   145 165     192   294   81   310
2118444 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302196 353100010044 PS 44 THOMAS C BROWN public Regular School No Elementary PK 05 2018   grade_2 6.0 60.0 68.0   0.0     2.0     9.0   69.0 76.0     13       142     63   145 6 60 68   0     2     9   69 76     13   142   63   145
2055421 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702332 321000010086 PS 86 KINGSBRIDGE HEIGHTS public Regular School No Elementary PK 06 2018   grade_2 2.0 18.0 198.0   1.0     7.0     0.0   125.0 101.0     76       206     62   226 2 18 198   1     7     0   125 101     76   206   62   226
2095093 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013500957 307500015373 PS 373 public Special Education School No Elementary PK 07 2018   grade_2 18.0 17.0 18.0   0.0     2.0     1.0   38.0 18.0     *       51     56   56 18 17 18   0     2     1   38 18         51   56   56
2110274 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2018   grade_2 10.0 7.0 239.0   1.0     13.0     0.0   136.0 134.0     92       239     56   270 10 7 239   1     13     0   136 134     92   239   56   270
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
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
2118919 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010306362 353100010078 PS 78 public Regular School No Elementary PK 05 2018   grade_2 4.0 70.0 67.0   3.0     5.0     0.0   72.0 77.0     12       148     52   149 4 70 67   3     5     0   72 77     12   148   52   149
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
2110293 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 2018   grade_2 6.0 0.0 204.0   1.0     28.0     1.0   120.0 120.0     126       219     51   240 6 0 204   1     28     1   120 120     126   219   51   240
2053692 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602288 320900010070 PS 70 MAX SCHOENFELD public Regular School No Elementary KG 05 2018   grade_2 1.0 52.0 139.0   1.0     0.0     0.0   106.0 87.0     38       187     49   193 1 52 139   1     0     0   106 87     38   187   49   193
2055459 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702357 321000010094 PS 94 KINGS COLLEGE SCHOOL public Regular School No Elementary KG 05 2018   grade_2 5.0 42.0 144.0   11.0     26.0     1.0   108.0 121.0     70       218     49   229 5 42 144   11     26     1   108 121     70   218   49   229
2110711 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802521 342400010143 PS 143 LOUIS ARMSTRONG public Regular School No Elementary KG 05 2018   grade_2 3.0 3.0 224.0   1.0     10.0     0.0   114.0 127.0     143       231     49   241 3 3 224   1     10     0   114 127     143   231   49   241
2074820 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202041 331500010001 PS 1 BERGEN (THE) public Regular School No Elementary PK 05 2018   grade_2 14.0 0.0 174.0   1.0     5.0         105.0 89.0     115       177     48   194 14 0 174   1     5         105 89     115   177   48   194
2110540 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802343 342400010089 PS 89 ELMHURST public Regular School No Elementary KG 05 2018   grade_2 6.0 0.0 243.0   1.0     69.0     0.0   154.0 165.0     175       257     48   319 6 0 243   1     69     0   154 165     175   257   48   319
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
2110787 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802739 342400010229 PS 229 EMANUEL KAPLAN public Regular School No Elementary PK 05 2018   grade_2 52.0 4.0 109.0   1.0     79.0     2.0   128.0 119.0     16       180     47   247 52 4 109   1     79     2   128 119     16   180   47   247
2118045 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302097 353100010018 PS 18 JOHN G WHITTIER public Regular School No Elementary PK 05 2018   grade_2 3.0 42.0 37.0   0.0     3.0     1.0   48.0 38.0     *       83     47   86 3 42 37   0     3     1   48 38         83   47   86
2056998 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No Elementary KG 05 2018   grade_2 8.0 97.0 78.0   4.0     4.0     1.0   102.0 90.0     47       177     45   192 8 97 78   4     4     1   102 90     47   177   45   192
2058176 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002209 321200010047 PS 47 JOHN RANDOLPH public Regular School No Elementary KG 05 2018   grade_2 4.0 37.0 128.0   3.0     22.0     0.0   105.0 89.0     40       188     45   194 4 37 128   3     22     0   105 89     40   188   45   194
2094808 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502070 307500014009 PS 9 public Special Education School No Elementary KG 08 2018   grade_2 3.0 13.0 21.0   0.0     7.0     1.0   35.0 10.0     9       32     45   45 3 13 21   0     7     1   35 10     9   32   45   45
2110863 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806060 342400010307 PIONEER ACADEMY public Regular School No Elementary KG 05 2018   grade_2 2.0 1.0 142.0   0.0     5.0         72.0 78.0     81       147     45   150 2 1 142   0     5         72 78     81   147   45   150
2052324 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502211 320800010048 PS 48 JOSEPH R DRAKE public Regular School No Elementary PK 05 2018   grade_2 1.0 27.0 85.0   0.0     2.0         70.0 45.0     30       108     44   115 1 27 85   0     2         70 45     30   108   44   115
2055174 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702150 321000010032 PS 32 BELMONT public Regular School No Elementary PK 05 2018   grade_2 5.0 34.0 104.0   0.0     0.0     0.0   74.0 69.0     27       141     44   143 5 34 104   0     0     0   74 69     27   141   44   143
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
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
2118007 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302082 353100010013 PS 13 M L LINDEMEYER public Regular School No Elementary PK 05 2018   grade_2 28.0 16.0 64.0   4.0     36.0     3.0   77.0 74.0     37       108     43   151 28 16 64   4     36     3   77 74     37   108   43   151
2052343 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502264 320800010062 PS 62 INOCENSIO CASANOVA public Regular School No Elementary PK 05 2018   grade_2 2.0 21.0 91.0   0.0     1.0     0.0   71.0 44.0     14       113     42   115 2 21 91   0     1     0   71 44     14   113   42   115
2057074 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802417 321100010111 PS 111 SETON FALLS public Regular School No Elementary PK 05 2018   grade_2 1.0 70.0 44.0   0.0     1.0     0.0   48.0 68.0     8       110     42   116 1 70 44   0     1     0   48 68     8   110   42   116
2110255 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802081 342400010013 PS 13 CLEMENT C MOORE public Regular School No Elementary KG 05 2018   grade_2 10.0 26.0 135.0   3.0     75.0     2.0   124.0 127.0     97       *     42   251 10 26 135   3     75     2   124 127     97       42   251
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
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
2075200 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202602 331500010169 PS 169 SUNSET PARK public Regular School No Elementary KG 05 2018   grade_2 14.0 2.0 86.0   3.0     122.0     0.0   116.0 111.0     110       213     41   227 14 2 86   3     122     0   116 111     110   213   41   227
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
2107671 NY Orange   school 3619650 441201060000   MONROE WOODBURY 361965001797 441201060001 PINE TREE ELEMENTARY SCHOOL public Regular School No Elementary 02 05 2018   grade_2 109.0 14.0 54.0   0.0     18.0     11.0   103.0 103.0     *       54     41   206 109 14 54   0     18     11   103 103         54   41   206
2125132 NY Suffolk   school 3625350 580205060000   SACHEM 362535003502 580205060003 HIAWATHA SCHOOL public Regular School No Elementary KG 05 2018   grade_2 72.0 3.0 28.0   0.0     16.0     8.0   75.0 52.0     7       42     41   127 72 3 28   0     16     8   75 52     7   42   41   127
2058347 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009002541 321200010150 PS 150 CHARLES JAMES FOX public Regular School No Elementary PK 05 2018   grade_2 4.0 30.0 98.0   1.0     0.0     0.0   73.0 60.0     35       127     40   133 4 30 98   1     0     0   73 60     35   127   40   133
2079589 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102385 332000010102 PS 102 BAYVIEW (THE) public Regular School No Elementary KG 05 2018   grade_2 127.0 3.0 60.0   3.0     27.0     4.0   100.0 124.0     38       143     40   224 127 3 60   3     27     4   100 124     38   143   40   224
2118140 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302118 353100010023 PS 23 RICHMONDTOWN public Regular School No Elementary PK 05 2018   grade_2 70.0 0.0 18.0   0.0     9.0     1.0   56.0 42.0     8       38     40   98 70 0 18   0     9     1   56 42     8   38   40   98
2052666 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502547 320800010152 PS 152 EVERGREEN public Regular School No Elementary KG 05 2018   grade_2 2.0 28.0 108.0   0.0     2.0     0.0   64.0 76.0     40       128     39   140 2 28 108   0     2     0   64 76     40   128   39   140
2053521 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602073 320900010011 PS 11 HIGHBRIDGE public Regular School No Elementary KG 05 2018   grade_2 0.0 31.0 77.0   1.0               55.0 54.0     31       102     39   109 0 31 77   1               55 54     31   102   39   109
2055193 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702155 321000010033 PS 33 TIMOTHY DWIGHT public Regular School No Elementary PK 05 2018   grade_2 0.0 21.0 117.0   1.0     2.0     1.0   73.0 69.0     30       136     39   142 0 21 117   1     2     1   73 69     30   136   39   142
2094352 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013506605 307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public Regular School No Elementary KG 06 2018   grade_2 1.0 13.0 25.0         0.0     0.0   34.0 5.0     11       36     39   39 1 13 25         0     0   34 5     11   36   39   39
2099368 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902418 310400010112 PS 112 JOSE CELSO BARBOSA public Regular School No Elementary PK 02 2018   grade_2 9.0 20.0 64.0   0.0     0.0     2.0   53.0 42.0     21       78     39   95 9 20 64   0     0     2   53 42     21   78   39   95
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
2113181 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302405 342700010108 PS 108 CAPT VINCENT G FOWLER public Regular School No Elementary PK 05 2018   grade_2 14.0 14.0 150.0   2.0     42.0     1.0   106.0 117.0     29       189     39   223 14 14 150   2     42     1   106 117     29   189   39   223
2118254 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302142 353100010030 PS 30 WESTERLEIGH public Regular School No Elementary PK 05 2018   grade_2 88.0 3.0 41.0   0.0     12.0     3.0   78.0 69.0     16       50     39   147 88 3 41   0     12     3   78 69     16   50   39   147
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
2075219 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202607 331500010172 PS 172 BEACON SCHOOL OF EXCELLENCE public Regular School No Elementary PK 05 2018   grade_2 13.0 3.0 71.0   0.0     5.0     1.0   45.0 48.0     38       81     38   93 13 3 71   0     5     1   45 48     38   81   38   93
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
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
2122453 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2018   grade_2 169.0 4.0 18.0   1.0     2.0     18.0   110.0 102.0     *       90     38   212 169 4 18   1     2     18   110 102         90   38   212
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
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
2055535 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702691 321000010205 PS 205 FIORELLO LAGUARDIA public Regular School No Elementary KG 05 2018   grade_2 7.0 26.0 123.0   1.0     5.0     0.0   70.0 92.0     41       148     37   162 7 26 123   1     5     0   70 92     41   148   37   162
2106911 NY Ontario   school 3629640 431701060000   VICTOR 362964003995 431701060003 VICTOR PRIMARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 272.0 8.0 26.0   1.0     13.0     18.0   176.0 162.0     14       82     37   338 272 8 26   1     13     18   176 162     14   82   37   338
2118406 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302186 353100010041 STEPHANIE A VIERNO SCHOOL (THE) public Regular School No Elementary PK 05 2018   grade_2 60.0 1.0 37.0         10.0     5.0   61.0 52.0     20       78     37   113 60 1 37         10     5   61 52     20   78   37   113
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
2052780 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505655 320800010333 LONGWOOD ACADEMY FOR DISCOVERY public Regular School No Elementary PK 05 2018   grade_2 2.0 16.0 68.0   0.0     0.0         46.0 40.0     22       86     36   86 2 16 68   0     0         46 40     22   86   36   86
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
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
2074345 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011906350 331400010414 BROOKLYN ARBOR ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 19.0 2.0 85.0         1.0     5.0   67.0 45.0     *       77     36   112 19 2 85         1     5   67 45         77   36   112
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
2098171 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802303 310300010075 PS 75 EMILY DICKINSON public Regular School No Elementary KG 05 2018   grade_2 17.0 21.0 52.0   1.0     0.0     1.0   48.0 44.0     14       64     36   92 17 21 52   1     0     1   48 44     14   64   36   92
2117855 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302052 353100010004 PS 4 MAURICE WOLLIN public Regular School No Elementary PK 05 2018   grade_2 73.0 2.0 17.0   1.0     13.0     1.0   61.0 46.0     14       49     36   107 73 2 17   1     13     1   61 46     14   49   36   107
2118995 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010301827 353100011080 MICHAEL J PETRIDES SCHOOL (THE) public Regular School No Other PK 12 2018   grade_2 39.0 18.0 28.0   0.0     3.0     0.0   47.0 41.0     *       45     36   88 39 18 28   0     3     0   47 41         45   36   88
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
2132751 NY Warren   school 3624030 630902030000   QUEENSBURY 362403003316 630902030001 QUEENSBURY ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 213.0 3.0 5.0         6.0     9.0   135.0 101.0     *       95     36   236 213 3 5         6     9   135 101         95   36   236
2052400 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502295 320800010072 PS 72 DR WILLIAM DORNEY public Regular School No Elementary PK 05 2018   grade_2 8.0 23.0 86.0         3.0         62.0 58.0     7       110     35   120 8 23 86         3         62 58     7   110   35   120
2052685 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502632 320800010182 PS 182 public Regular School No Elementary PK 05 2018   grade_2 7.0 37.0 91.0   2.0     10.0     1.0   65.0 83.0     7       133     35   148 7 37 91   2     10     1   65 83     7   133   35   148
2055117 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702179 321000010020 PS/MS 20 PO GEORGE J WERDAN III public Regular School No Elementary PK 08 2018   grade_2 2.0 11.0 93.0   2.0     4.0     1.0   57.0 56.0     38       111     35   113 2 11 93   2     4     1   57 56     38   111   35   113
2066821 NY Erie   school 3605850 140600010000   BUFFALO 360585000350 140600010059 PS 59 DR CHARLES DREW SCI MAGNET public Regular School No Elementary PK 08 2018   grade_2 9.0 49.0 16.0         13.0     4.0   46.0 45.0     22       84     35   91 9 49 16         13     4   46 45     22   84   35   91
2067334 NY Erie   school 3605850 140600010000   BUFFALO 360585001549 140600010126 STANLEY MAKOWSKI EARLY CHLDHD CTR public Regular School No Elementary PK 04 2018   grade_2 10.0 100.0 9.0   0.0     15.0     6.0   79.0 61.0     19       128     35   140 10 100 9   0     15     6   79 61     19   128   35   140
2081736 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015303387 332200010361 PS 361 E FLATBUSH EARLY CHILDHOOD public Regular School No Elementary PK 02 2018   grade_2 6.0 92.0 20.0   0.0     4.0     0.0   58.0 64.0     29       109     35   122 6 92 20   0     4     0   58 64     29   109   35   122
2100622 NY New York   school 3600954 310500860921   SUCCESS ACAD-HARLEM 2 360095406017 310500860921 SUCCESS ACAD CHARTER SCH-HARLEM 2 charter Regular School Yes Other KG 10 2018   grade_2 2.0 77.0 31.0   0.0     2.0     1.0   57.0 56.0     *       89     35   113 2 77 31   0     2     1   57 56         89   35   113
2118672 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302247 353100010057 PS 57 HUBERT H HUMPHREY public Regular School No Elementary PK 05 2018   grade_2 5.0 58.0 36.0   2.0     6.0     3.0   53.0 57.0     12       96     35   110 5 58 36   2     6     3   53 57     12   96   35   110
2051108 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402098 320700010018 PS 18 JOHN PETER ZENGER public Regular School No Elementary PK 05 2018   grade_2 3.0 29.0 65.0   0.0     3.0     0.0   52.0 48.0     33       98     34   100 3 29 65   0     3     0   52 48     33   98   34   100
2051222 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402218 320700010049 PS 49 WILLIS AVENUE public Regular School No Elementary PK 05 2018   grade_2 2.0 24.0 73.0   0.0     0.0     1.0   47.0 53.0     24       99     34   100 2 24 73   0     0     1   47 53     24   99   34   100
2055744 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704695 321000010280 PS/MS 280 MOSHOLU PARKWAY public Regular School No Elementary KG 08 2018   grade_2 7.0 8.0 69.0   0.0     6.0     0.0   54.0 36.0     16       86     34   90 7 8 69   0     6     0   54 36     16   86   34   90
2058556 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009005807 321200010300 SCHOOL OF SCIENCE & APPLIED LRNG public Regular School No Elementary PK 05 2018   grade_2 1.0 37.0 71.0   1.0     0.0         59.0 51.0     20       101     34   110 1 37 71   1     0         59 51     20   101   34   110
2074839 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202072 331500010010 MAGNET SCH OF MATH, SCI, DESIGN public Regular School No Elementary KG 05 2018   grade_2 78.0 5.0 50.0   1.0     14.0     12.0   74.0 86.0     8       38     34   160 78 5 50   1     14     12   74 86     8   38   34   160
2075105 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202481 331500010130 PS 130 PARKSIDE (THE) public Regular School No Elementary PK 05 2018   grade_2 69.0 5.0 25.0   2.0     22.0     4.0   71.0 56.0     13       54     34   127 69 5 25   2     22     4   71 56     13   54   34   127
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
2079836 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 2018   grade_2 57.0 1.0 44.0   3.0     54.0     0.0   79.0 80.0     72       117     34   159 57 1 44   3     54     0   79 80     72   117   34   159
2086467 NY Monroe   school 3624750 261600010000   ROCHESTER 362475004423 261600010022 SCHOOL 22-LINCOLN SCHOOL public Regular School No Elementary PK 06 2018   grade_2 0.0 52.0 59.0         1.0     0.0   58.0 54.0     29       110     34   112 0 52 59         1     0   58 54     29   110   34   112
2108355 NY Orange   school 3629970 442101060000   WARWICK VALLEY 362997004836 442101060007 SANFORDVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2018   grade_2 103.0 4.0 17.0         3.0     6.0   72.0 61.0     *       30     34   133 103 4 17         3     6   72 61         30   34   133
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
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
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
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
2075162 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009204811 331500010146 BROOKLYN NEW SCHOOL public Regular School No Elementary PK 05 2018   grade_2 47.0 21.0 28.0   0.0     5.0     9.0   54.0 56.0     5       37     33   110 47 21 28   0     5     9   54 56     5   37   33   110
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

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