Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2018 sorted by asian_pacific_islander descending

View and edit SQL

year

  • 2018 · 89,718
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
2055127 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   pk_12_total 57.0 112.0 779.0   21.0     99.0     1.0   556.0 513.0     258       1015     294   1069 57 112 779   21     99     1   556 513     258   1015   294   1069
2079737 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_1 41.0 1.0 34.0   1.0     99.0     1.0   101.0 76.0     90       167     28   177 41 1 34   1     99     1   101 76     90   167   28   177
2080028 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102738 332000010229 PS 229 DYKER public Regular School No Elementary PK 08 2018   grade_4 40.0 2.0 11.0   0.0     99.0     1.0   69.0 84.0     21       82     26   153 40 2 11   0     99     1   69 84     21   82   26   153
2080034 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102738 332000010229 PS 229 DYKER public Regular School No Elementary PK 08 2018   kindergarten_full_day 27.0 0.0 16.0   1.0     99.0     1.0   80.0 64.0     30       86     14   144 27 0 16   1     99     1   80 64     30   86   14   144
2111455 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_5 58.0 0.0 39.0   1.0     99.0     0.0   106.0 91.0     12       110     25   197 58 0 39   1     99     0   106 91     12   110   25   197
2112462 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902610 342600010173 PS 173 FRESH MEADOWS public Regular School No Elementary PK 05 2018   grade_5 44.0 3.0 20.0   0.0     99.0     4.0   87.0 83.0     10       118     26   170 44 3 20   0     99     4   87 83     10   118   26   170
2113609 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012306525 342700010316 QUEENS EXPLORERS ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2018   pk_12_total 45.0 26.0 186.0   14.0     99.0     8.0   179.0 199.0     15       286     46   378 45 26 186   14     99     8   179 199     15   286   46   378
2116127 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202287 343000010069 PS 69 JACKSON HEIGHTS public Regular School No Elementary PK 05 2018   grade_3 14.0 2.0 80.0   1.0     99.0     2.0   83.0 115.0     47       132     24   198 14 2 80   1     99     2   83 115     47   132   24   198
2127384 NY Suffolk   school 3613290 580405060000   HALF HOLLOW HILLS 361329001093 580405060011 VANDERBILT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   pk_12_total 349.0 102.0 85.0         99.0     41.0   351.0 325.0     21       128     104   676 349 102 85         99     41   351 325     21   128   104   676
2134471 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000784 660301030005 EASTCHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2018   pk_12_total 590.0 20.0 84.0   2.0     99.0     24.0   425.0 394.0     26       10     125   819 590 20 84   2     99     24   425 394     26   10   125   819
2135459 NY Westchester   school 3613740 660501060000   HARRISON 361374001123 660501060009 LOUIS M KLEIN MIDDLE SCHOOL public Regular School No Middle 06 10 2018   pk_12_total 565.0 12.0 144.0   1.0     99.0     13.0   397.0 437.0     61       165     127   834 565 12 144   1     99     13   397 437     61   165   127   834
2050396 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2018   pk_12_total 350.0 9.0 17.0   1.0     98.0     39.0   238.0 276.0     33       146     63   514 350 9 17   1     98     39   238 276     33   146   63   514
2092971 NY Nassau   school 3628560 280502060000   SYOSSET 362856003838 280502060011 H B THOMPSON MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 192.0 1.0 9.0   0.0     98.0     3.0   145.0 158.0     *       34     45   303 192 1 9   0     98     3   145 158         34   45   303
2096101 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702458 310200010124 PS 124 YUNG WING public Regular School No Elementary PK 05 2018   grade_3 3.0   2.0         98.0     0.0   52.0 51.0     33       55     15   103 3   2         98     0   52 51     33   55   15   103
2096281 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702635 310200010183 PS 183 ROBERT L STEVENSON public Regular School No Elementary PK 05 2018   pk_12_total 401.0 14.0 52.0         98.0     24.0   302.0 287.0     28       66     102   589 401 14 52         98     24   302 287     28   66   102   589
2110588 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802355 342400010093 IS 93 RIDGEWOOD public Regular School No Middle 06 08 2018   pk_12_total 189.0 21.0 781.0   3.0     98.0     2.0   575.0 519.0     160       1036     251   1094 189 21 781   3     98     2   575 519     160   1036   251   1094
2111357 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202115 342500010022 PS 22 THOMAS JEFFERSON public Regular School No Elementary PK 05 2018   grade_2 3.0 2.0 43.0   0.0     98.0     1.0   74.0 73.0     92       136     11   147 3 2 43   0     98     1   74 73     92   136   11   147
2111460 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202314 342500010079 PS 79 FRANCIS LEWIS public Regular School No Elementary PK 05 2018   kindergarten_full_day 47.0 1.0 29.0   0.0     98.0     2.0   90.0 87.0     32       95     25   177 47 1 29   0     98     2   90 87     32   95   25   177
2115343 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102483 342900010131 PS 131 ABIGAIL ADAMS public Regular School No Elementary KG 05 2018   grade_1 8.0 5.0 13.0   3.0     98.0     1.0   58.0 70.0     25       115     11   128 8 5 13   3     98     1   58 70     25   115   11   128
2118549 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302220 353100010050 PS 50 FRANK HANKINSON public Regular School No Elementary PK 05 2018   pk_12_total 523.0 17.0 118.0   2.0     98.0     15.0   369.0 404.0     37       315     159   773 523 17 118   2     98     15   369 404     37   315   159   773
2050339 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2018   pk_12_total 301.0 39.0 29.0   1.0     97.0     32.0   243.0 256.0     51       150     78   499 301 39 29   1     97     32   243 256     51   150   78   499
2073481 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009101371 331300011439 BROOKLYN INTNTL HIGH SCHOOL public Regular School No High 09 12 2018   pk_12_total 46.0 73.0 139.0         97.0         189.0 166.0     274       289     12   355 46 73 139         97         189 166     274   289   12   355
2080891 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015205826 332100011344 RACHEL CARSON HS FOR COASTAL STUDIES public Regular School No High 09 12 2018   pk_12_total 281.0 110.0 137.0   2.0     97.0     8.0   349.0 286.0     91       435     129   635 281 110 137   2     97     8   349 286     91   435   129   635
2093393 NY Nassau   school 3614340 280517030000   HICKSVILLE 361434001181 280517030001 BURNS AVENUE SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 40.0 23.0 143.0         97.0     5.0   162.0 146.0     50       147     40   308 40 23 143         97     5   162 146     50   147   40   308
2095780 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702047 310200010002 PS 2 MEYER LONDON public Regular School No Elementary PK 05 2018   grade_5 1.0 7.0 15.0   0.0     97.0     0.0   62.0 58.0     13       116     32   120 1 7 15   0     97     0   62 58     13   116   32   120
2097934 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701949 310200011600 HIGH SCH OF FASHION INDUSTRIES (THE) public Career and Technical School No High 09 12 2018   pk_12_total 75.0 530.0 888.0   4.0     97.0     5.0   127.0 1472.0     51       1336     275   1599 75 530 888   4     97     5   127 1472     51   1336   275   1599
2103710 NY Oneida   school 3629370 412300010000   UTICA 362937003957 412300010011 MARTIN LUTHER KING JR ELEM SCH public Regular School No Elementary KG 06 2018   pk_12_total 44.0 125.0 83.0         97.0     18.0   177.0 190.0     96       348     54   367 44 125 83         97     18   177 190     96   348   54   367
2103786 NY Oneida   school 3629370 412300010000   UTICA 362937003954 412300010018 KERNAN ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   pk_12_total 148.0 213.0 135.0         97.0     79.0   314.0 358.0     121       609     61   672 148 213 135         97     79   314 358     121   609   61   672
2111453 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_3 44.0 0.0 44.0   0.0     97.0     2.0   97.0 90.0     16       100     20   187 44 0 44   0     97     2   97 90     16   100   20   187
2112554 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902687 342600010203 PS 203 OAKLAND GARDENS public Regular School No Elementary PK 05 2018   grade_2 18.0 2.0 19.0         97.0     5.0   67.0 74.0     26       62     17   141 18 2 19         97     5   67 74     26   62   17   141
2112562 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902687 342600010203 PS 203 OAKLAND GARDENS public Regular School No Elementary PK 05 2018   kindergarten_full_day 14.0 1.0 13.0         97.0     3.0   71.0 57.0     35       58     13   128 14 1 13         97     3   71 57     35   58   13   128
2115347 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102483 342900010131 PS 131 ABIGAIL ADAMS public Regular School No Elementary KG 05 2018   grade_2 8.0 9.0 14.0   5.0     97.0     1.0   75.0 59.0     22       125     27   134 8 9 14   5     97     1   75 59     22   125   27   134
2111329 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202105 342500010020 PS 20 JOHN BOWNE public Regular School No Elementary PK 05 2018   pk_12_total 20.0 57.0 255.0   8.0     964.0     7.0   676.0 635.0     448       1229     176   1311 20 57 255   8     964     7   676 635     448   1229   176   1311
2112621 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902716 342600010216 JHS 216 GEORGE J RYAN public Regular School No Middle 06 08 2018   pk_12_total 202.0 72.0 195.0   10.0     960.0     19.0   758.0 700.0     91       1000     197   1458 202 72 195   10     960     19   758 700     91   1000   197   1458
2050548 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   pk_12_total 326.0 26.0 22.0   1.0     96.0     24.0   248.0 247.0     68       118     44   495 326 26 22   1     96     24   248 247     68   118   44   495
2079744 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_5 56.0 2.0 35.0   0.0     96.0     4.0   96.0 97.0     *       177     27   193 56 2 35   0     96     4   96 97         177   27   193
2081453 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_4 26.0 18.0 31.0   0.0     96.0     5.0   88.0 88.0     34       142     29   176 26 18 31   0     96     5   88 88     34   142   29   176
2092990 NY Nassau   school 3628560 280502060000   SYOSSET 362856003841 280502060012 SOUTH WOODS MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_8 144.0 1.0 9.0   1.0     96.0     4.0   141.0 114.0     9       26     31   255 144 1 9   1     96     4   141 114     9   26   31   255
2094989 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502859 307500014721 JOHN F KENNEDY JR SCHOOL public Special Education School No High 09 12 2018   pk_12_total 86.0 89.0 219.0   5.0     96.0     2.0   335.0 162.0     232       437     497   497 86 89 219   5     96     2   335 162     232   437   497   497
2096237 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702597 310200010167 JHS 167 ROBERT F WAGNER public Regular School No Middle 06 08 2018   grade_6 245.0 23.0 63.0   2.0     96.0     18.0   233.0 214.0     *       134     *   447 245 23 63   2     96     18   233 214         134       447
2096300 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702675 310200010198 PS 198 ISADOR E IDA STRAUS public Regular School No Elementary PK 05 2018   pk_12_total 197.0 47.0 107.0   3.0     96.0     11.0   242.0 219.0     27       179     107   461 197 47 107   3     96     11   242 219     27   179   107   461
2096642 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702857 310200010412 NYC LAB HS-COLLABORATIVE STUDIES public Regular School No High 09 12 2018   pk_12_total 276.0 22.0 65.0   4.0     96.0     32.0   241.0 254.0     *       151     104   495 276 22 65   4     96     32   241 254         151   104   495
2110258 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_5 14.0 15.0 135.0   0.0     96.0     0.0   135.0 125.0     *       198     *   260 14 15 135   0     96     0   135 125         198       260
2111448 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_1 39.0 1.0 31.0   0.0     96.0     3.0   84.0 86.0     16       93     24   170 39 1 31   0     96     3   84 86     16   93   24   170
2111568 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202586 342500010163 PS 163 FLUSHING HEIGHTS public Regular School No Elementary PK 05 2018   grade_4 0.0 1.0 23.0   0.0     96.0     1.0   67.0 54.0     38       98     23   121 0 1 23   0     96     1   67 54     38   98   23   121
2112177 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902099 342600010018 PS 18 WINCHESTER public Regular School No Elementary PK 05 2018   grade_5 5.0 9.0 11.0   1.0     96.0     0.0   52.0 70.0     10       76     9   122 5 9 11   1     96     0   52 70     10   76   9   122
2112961 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   kindergarten_full_day 2.0 4.0 50.0   14.0     96.0     2.0   89.0 79.0     40       120     22   168 2 4 50   14     96     2   89 79     40   120   22   168
2114285 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002333 342800010086 PS 86 public Regular School No Elementary PK 05 2018   grade_4 2.0 17.0 65.0   3.0     96.0     1.0   86.0 98.0     56       158     36   184 2 17 65   3     96     1   86 98     56   158   36   184
2115002 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010005297 342800011687 QUEENS HIGH SCHOOL SCI AT YORK COLL public Regular School No High 09 12 2018   grade_10 2.0 8.0 6.0   0.0     96.0     7.0   67.0 52.0             78     *   119 2 8 6   0     96     7   67 52         78       119
2116421 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202536 343000010149 PS 149 CHRISTA MCAULIFFE public Regular School No Elementary KG 05 2018   pk_12_total 34.0 15.0 905.0   4.0     96.0     2.0   532.0 524.0     385       822     183   1056 34 15 905   4     96     2   532 524     385   822   183   1056
2122805 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601006573 530600010035 ONEIDA MIDDLE SCHOOL public Regular School No Middle 06 08 2018   pk_12_total 178.0 246.0 148.0   2.0     96.0     23.0   357.0 336.0     24       596     168   693 178 246 148   2     96     23   357 336     24   596   168   693
2128543 NY Suffolk   school 3608160 580507060000   CONNETQUOT 360816000597 580507060006 CONNETQUOT HIGH SCHOOL public Regular School No High 09 12 2018   pk_12_total 1638.0 42.0 193.0         96.0     9.0   1012.0 966.0     24       456     271   1978 1638 42 193         96     9   1012 966     24   456   271   1978
2134490 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000785 660301030006 EASTCHESTER SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   pk_12_total 691.0 21.0 112.0   2.0     96.0     25.0   497.0 450.0     14       11     141   947 691 21 112   2     96     25   497 450     14   11   141   947
2073449 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009101928 331300011430 BROOKLYN TECH HIGH SCHOOL public Career and Technical School No High 09 12 2018   grade_10 363.0 98.0 118.0   11.0     955.0     10.0   929.0 626.0             980     21   1555 363 98 118   11     955     10   929 626         980   21   1555
2094993 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502859 307500014721 JOHN F KENNEDY JR SCHOOL public Special Education School No High 09 12 2018   ungraded_secondary 86.0 89.0 215.0   5.0     95.0     2.0   331.0 161.0     *       *     492   492 86 89 215   5     95     2   331 161             492   492
2096108 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702458 310200010124 PS 124 YUNG WING public Regular School No Elementary PK 05 2018   kindergarten_full_day 2.0   1.0         95.0     2.0   44.0 56.0     57       53     16   100 2   1         95     2   44 56     57   53   16   100
2096134 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702480 310200010130 PS 130 HERNANDO DE SOTO public Regular School No Elementary PK 05 2018   grade_1 6.0 0.0 9.0   0.0     95.0     6.0   62.0 54.0     31       60     *   116 6 0 9   0     95     6   62 54     31   60       116
2105173 NY Onondaga   school 3618330 421001060000   FAYETTVLLE-MANLIUS 361833001653 421001060005 EAGLE HILL MIDDLE SCHOOL public Regular School No Middle 05 08 2018   pk_12_total 509.0 22.0 20.0   1.0     95.0     13.0   333.0 327.0     *       66     59   660 509 22 20   1     95     13   333 327         66   59   660
2111353 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202115 342500010022 PS 22 THOMAS JEFFERSON public Regular School No Elementary PK 05 2018   grade_1 7.0 0.0 51.0   2.0     95.0     1.0   89.0 67.0     103       144     21   156 7 0 51   2     95     1   89 67     103   144   21   156
2111360 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202115 342500010022 PS 22 THOMAS JEFFERSON public Regular School No Elementary PK 05 2018   grade_5 3.0 0.0 53.0   0.0     95.0     0.0   83.0 68.0     50       138     33   151 3 0 53   0     95     0   83 68     50   138   33   151
2111859 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012204892 342500010242 PS 242 LP STAVISKY EARLY CHILDHOOD public Regular School No Elementary PK 03 2018   kindergarten_full_day 6.0 3.0 11.0   1.0     95.0     1.0   57.0 60.0     54       69     9   117 6 3 11   1     95     1   57 60     54   69   9   117
2111866 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012206032 342500010244 ACTIVE LEARNING ELEMENTARY SCH (THE) public Regular School No Elementary PK 03 2018   grade_1 4.0 2.0 9.0   0.0     95.0     1.0   61.0 50.0     74       84     17   111 4 2 9   0     95     1   61 50     74   84   17   111
2112176 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902099 342600010018 PS 18 WINCHESTER public Regular School No Elementary PK 05 2018   grade_4 14.0 21.0 10.0   1.0     95.0     1.0   71.0 71.0     8       77     21   142 14 21 10   1     95     1   71 71     8   77   21   142
2112467 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902610 342600010173 PS 173 FRESH MEADOWS public Regular School No Elementary PK 05 2018   kindergarten_full_day 35.0 0.0 14.0   1.0     95.0     2.0   84.0 63.0     27       85     16   147 35 0 14   1     95     2   84 63     27   85   16   147
2114361 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002448 342800010121 PS 121 public Regular School No Elementary PK 05 2018   grade_4 2.0 32.0 21.0   15.0     95.0     3.0   91.0 77.0     13       139     23   168 2 32 21   15     95     3   91 77     13   139   23   168
2116470 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_4 7.0 1.0 76.0   5.0     95.0     0.0   87.0 97.0     44       154     22   184 7 1 76   5     95     0   87 97     44   154   22   184
2116476 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   kindergarten_full_day 2.0 0.0 60.0   2.0     95.0     1.0   92.0 68.0     74       112     21   160 2 0 60   2     95     1   92 68     74   112   21   160
2127308 NY Suffolk   school 3613290 580405060000   HALF HOLLOW HILLS 361329001088 580405060001 OTSEGO ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   pk_12_total 275.0 77.0 93.0   1.0     95.0     26.0   307.0 260.0     39       149     127   567 275 77 93   1     95     26   307 260     39   149   127   567
2080967 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015201943 332100011525 EDWARD R MURROW HIGH SCHOOL public Regular School No High 09 12 2018   pk_12_total 1037.0 858.0 790.0   14.0     946.0     130.0   1569.0 2206.0     319       2678     729   3775 1037 858 790   14     946     130   1569 2206     319   2678   729   3775
2050448 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2018   grade_7 277.0 28.0 21.0   1.0     94.0     23.0   231.0 213.0     12       113     61   444 277 28 21   1     94     23   231 213     12   113   61   444
2066071 NY Erie   school 3602920 140201060000   AMHERST 360292004289 140201060006 WINDERMERE BLVD SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 401.0 156.0 35.0   2.0     94.0     53.0   398.0 343.0     105       369     94   741 401 156 35   2     94     53   398 343     105   369   94   741
2075241 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_5 37.0 4.0 64.0   0.0     94.0     1.0   105.0 95.0     48       143     46   200 37 4 64   0     94     1   105 95     48   143   46   200
2078744 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002800 331900010292 JHS 292 MARGARET S DOUGLAS public Regular School No Middle 06 08 2018   pk_12_total 17.0 275.0 166.0   9.0     94.0     1.0   293.0 269.0     81       528     145   562 17 275 166   9     94     1   293 269     81   528   145   562
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
2079743 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_4 40.0 1.0 31.0   2.0     94.0     0.0   106.0 62.0     57       156     36   168 40 1 31   2     94     0   106 62     57   156   36   168
2079804 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102626 332000010180 SEEALL ACADEMY (THE) public Regular School No Elementary PK 08 2018   grade_8 46.0 0.0 34.0   1.0     94.0     0.0   99.0 76.0     *       146     17   175 46 0 34   1     94     0   99 76         146   17   175
2080022 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102738 332000010229 PS 229 DYKER public Regular School No Elementary PK 08 2018   grade_1 25.0 3.0 24.0   0.0     94.0     1.0   73.0 74.0     28       102     25   147 25 3 24   0     94     1   73 74     28   102   25   147
2081414 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_3 85.0 3.0 29.0   3.0     94.0     2.0   99.0 117.0     60       154     28   216 85 3 29   3     94     2   99 117     60   154   28   216
2092880 NY Nassau   school 3628560 280502060000   SYOSSET 362856003837 280502060003 BERRY HILL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   pk_12_total 278.0   11.0         94.0     11.0   201.0 193.0     16       16     36   394 278   11         94     11   201 193     16   16   36   394
2094799 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504699 307500014004 PS Q004 public Special Education School No Elementary PK 05 2018   pk_12_total 47.0 100.0 127.0   10.0     94.0     9.0   313.0 74.0     53       299     386   387 47 100 127   10     94     9   313 74     53   299   386   387
2098162 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802235 310300010054 JHS 54 BOOKER T WASHINGTON public Regular School No Middle 06 08 2018   pk_12_total 491.0 73.0 126.0   2.0     94.0     65.0   429.0 422.0     9       202     109   851 491 73 126   2     94     65   429 422     9   202   109   851
2110795 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802739 342400010229 PS 229 EMANUEL KAPLAN public Regular School No Elementary PK 05 2018   kindergarten_full_day 43.0 7.0 88.0   0.0     94.0     0.0   133.0 99.0     20       170     41   232 43 7 88   0     94     0   133 99     20   170   41   232
2113457 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302743 342700010232 PS 232 LINDENWOOD public Regular School No Elementary KG 08 2018   pk_12_total 320.0 80.0 455.0   4.0     94.0     14.0   490.0 477.0     44       604     197   967 320 80 455   4     94     14   490 477     44   604   197   967
2113894 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012306528 342700011334 EPIC HIGH SCHOOL NORTH public Regular School No High 09 12 2018   pk_12_total 22.0 62.0 164.0   10.0     94.0     33.0   199.0 186.0     24       290     56   385 22 62 164   10     94     33   199 186     24   290   56   385
2116358 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202514 343000010141 IS 141 STEINWAY (THE) public Regular School No Middle 06 08 2018   grade_6 123.0 11.0 145.0   4.0     94.0     8.0   213.0 172.0     28       252     62   385 123 11 145   4     94     8   213 172     28   252   62   385
2127935 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000166 580501030006 BAY SHORE SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   pk_12_total 598.0 411.0 840.0   3.0     94.0     16.0   1028.0 934.0     181       1066     296   1962 598 411 840   3     94     16   1028 934     181   1066   296   1962
2075039 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202359 331500010094 PS 94 HENRY LONGFELLOW (THE) public Regular School No Elementary KG 05 2018   pk_12_total 24.0 7.0 413.0   1.0     938.0         697.0 686.0     715       1361     124   1383 24 7 413   1     938         697 686     715   1361   124   1383
2050377 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2018   pk_12_total 334.0 26.0 24.0   1.0     93.0     33.0   239.0 272.0     61       139     45   511 334 26 24   1     93     33   239 272     61   139   45   511
2089042 NY Nassau   school 3617160 280205030000   LEVITTOWN 361716001529 280205030011 NORTHSIDE SCHOOL public Regular School No Elementary KG 05 2018   pk_12_total 289.0 7.0 138.0   1.0     93.0     11.0   279.0 260.0     38       116     63   539 289 7 138   1     93     11   279 260     38   116   63   539
2092339 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001021 280407030008 LAKEVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_3 42.0 4.0 12.0         93.0     8.0   74.0 85.0     13       25     20   159 42 4 12         93     8   74 85     13   25   20   159
2092989 NY Nassau   school 3628560 280502060000   SYOSSET 362856003841 280502060012 SOUTH WOODS MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_7 130.0 1.0 17.0   0.0     93.0     4.0   129.0 116.0     6       16     25   245 130 1 17   0     93     4   129 116     6   16   25   245
2093469 NY Nassau   school 3614340 280517030000   HICKSVILLE 361434001188 280517030006 OLD COUNTRY ROAD SCHOOL public Regular School No Elementary KG 05 2018   pk_12_total 44.0 1.0 179.0         93.0     7.0   176.0 148.0     87       193     30   324 44 1 179         93     7   176 148     87   193   30   324
2094894 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502858 307500014224 PS 224 public Special Education School No Elementary PK 08 2018   pk_12_total 40.0 80.0 122.0   58.0     93.0     10.0   290.0 113.0     84       290     403   403 40 80 122   58     93     10   290 113     84   290   403   403
2103672 NY Oneida   school 3629370 412300010000   UTICA 362937003948 412300010006 GENERAL HERKIMER ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   pk_12_total 225.0 161.0 169.0   3.0     93.0     70.0   348.0 373.0     125       597     72   721 225 161 169   3     93     70   348 373     125   597   72   721
2110474 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804609 342400010077 IS 77 public Regular School No Middle 06 08 2018   pk_12_total 103.0 23.0 789.0   2.0     93.0     2.0   535.0 477.0     218       940     292   1012 103 23 789   2     93     2   535 477     218   940   292   1012
2112424 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902580 342600010162 PS 162 JOHN GOLDEN public Regular School No Elementary PK 05 2018   grade_5 19.0 2.0 13.0   0.0     93.0     1.0   68.0 60.0     5       81     21   128 19 2 13   0     93     1   68 60     5   81   21   128
2113108 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012302379 342700010100 PS 100 GLEN MORRIS public Regular School No Elementary PK 05 2018   grade_5 3.0 16.0 23.0   18.0     93.0     0.0   77.0 76.0     *       107     34   153 3 16 23   18     93     0   77 76         107   34   153
2116782 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206443 343000011258 ENERGY TECH HIGH SCHOOL public Regular School No High 09 12 2018   pk_12_total 68.0 49.0 279.0   4.0     93.0     19.0   385.0 127.0     15       389     95   512 68 49 279   4     93     19   385 127     15   389   95   512
2129740 NY Suffolk   school 3627060 580801060000   SMITHTOWN 362706000327 580801060022 SMITHTOWN HIGH SCHOOL-WEST public Regular School No High 09 12 2018   pk_12_total 1388.0 22.0 142.0   4.0     93.0     13.0   842.0 820.0     32       156     284   1662 1388 22 142   4     93     13   842 820     32   156   284   1662
2055754 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   pk_12_total 52.0 73.0 665.0   4.0     92.0     1.0   465.0 422.0     153       852     263   887 52 73 665   4     92     1   465 422     153   852   263   887

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