Data source: Big Local News · About: Big Local

89,661 rows where state = "NY" and year = 2019 sorted by asian_pacific_islander descending

View and edit SQL

year

  • 2019 · 89,661
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
2169482 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102626 332000010180 SEEALL ACADEMY (THE) public Regular School No Elementary PK 08 2019   grade_6 38.0 4.0 37.0   0.0     99.0     0.0   84.0 94.0     13       150     17   178 38 4 37   0     99     0   84 94     13   150   17   178
2169607 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102689 332000010204 PS 204 VINCE LOMBARDI public Regular School No Elementary PK 05 2019   grade_1 49.0 0.0 34.0   0.0     99.0     1.0   103.0 80.0     19       140     33   183 49 0 34   0     99     1   103 80     19   140   33   183
2171095 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302695 332200010206 PS 206 JOSEPH F LAMB public Regular School No Elementary KG 08 2019   grade_4 83.0 4.0 32.0   3.0     99.0     1.0   106.0 116.0     43       154     27   222 83 4 32   3     99     1   106 116     43   154   27   222
2183111 NY Nassau   school 3614340 280517030000   HICKSVILLE 361434001181 280517030001 BURNS AVENUE SCHOOL public Regular School No Elementary PK 05 2019   pk_12_total 49.0 21.0 134.0         99.0     7.0   167.0 143.0     52       149     44   310 49 21 134         99     7   167 143     52   149   44   310
2185814 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702458 310200010124 PS 124 YUNG WING public Regular School No Elementary PK 05 2019   grade_1 2.0   2.0         99.0     3.0   51.0 55.0     49       58     14   106 2   2         99     3   51 55     49   58   14   106
2187449 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705532 310200011545 HS-DUAL LANGUAGE & ASIAN STUDIES public Regular School No High 09 12 2019   grade_10 3.0 1.0 0.0         99.0     1.0   41.0 63.0     *       98     *   104 3 1 0         99     1   41 63         98       104
2188830 NY New York   school 3601039 310300861008   SUCCESS ACADEMY -UPPER WEST 360103906260 310300861008 SUCCESS ACAD CHARTER SCH-UPPER WEST charter Regular School Yes Elementary KG 08 2019   pk_12_total 200.0 160.0 298.0   4.0     99.0     29.0   391.0 399.0     23       377     152   790 200 160 298   4     99     29   391 399     23   377   152   790
2204159 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002653 342800010190 JHS 190 RUSSELL SAGE public Regular School No Middle 06 08 2019   grade_8 110.0 23.0 96.0   4.0     99.0     7.0   195.0 144.0     33       *     *   339 110 23 96   4     99     7   195 144     33           339
2204951 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102483 342900010131 PS 131 ABIGAIL ADAMS public Regular School No Elementary KG 05 2019   grade_2 13.0 6.0 12.0   1.0     99.0     1.0   65.0 67.0     20       123     16   132 13 6 12   1     99     1   65 67     20   123   16   132
2185819 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702458 310200010124 PS 124 YUNG WING public Regular School No Elementary PK 05 2019   grade_3 1.0   2.0         98.0     4.0   55.0 50.0     27       52     15   105 1   2         98     4   55 50     27   52   15   105
2189292 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007904518 310400011435 MANHATTAN CENTER-SCIENCE & MATH public Regular School No High 09 12 2019   grade_10 18.0 85.0 234.0   5.0     98.0     3.0   214.0 229.0     36       362     61   443 18 85 234   5     98     3   214 229     36   362   61   443
2201000 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202314 342500010079 PS 79 FRANCIS LEWIS public Regular School No Elementary PK 05 2019   grade_3 41.0 0.0 40.0   0.0     98.0     1.0   96.0 84.0     17       100     30   180 41 0 40   0     98     1   96 84     17   100   30   180
2201121 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202586 342500010163 PS 163 FLUSHING HEIGHTS public Regular School No Elementary PK 05 2019   kindergarten_full_day 1.0 0.0 20.0   1.0     98.0     2.0   67.0 55.0     81       101     10   122 1 0 20   1     98     2   67 55     81   101   10   122
2201598 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012205869 342500011285 WORLD JOURNALISM PREPARATORY public Regular School No High 06 12 2019   pk_12_total 226.0 23.0 224.0   2.0     98.0     15.0   243.0 345.0     11       358     112   588 226 23 224   2     98     15   243 345     11   358   112   588
2202140 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902687 342600010203 PS 203 OAKLAND GARDENS public Regular School No Elementary PK 05 2019   grade_3 15.0 2.0 15.0         98.0     5.0   64.0 71.0     25       60     14   135 15 2 15         98     5   64 71     25   60   14   135
2206500 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010204894 343000011501 FRANK SINATRA SCHOOL OF THE ARTS HS public Regular School No High 09 12 2019   pk_12_total 307.0 113.0 284.0   7.0     98.0     49.0   265.0 593.0     7       335     165   858 307 113 284   7     98     49   265 593     7   335   165   858
2208020 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302186 353100010041 STEPHANIE A VIERNO SCHOOL (THE) public Regular School No Elementary PK 05 2019   pk_12_total 327.0 22.0 233.0   2.0     98.0     15.0   356.0 341.0     101       465     165   697 327 22 233   2     98     15   356 341     101   465   165   697
2225063 NY Westchester   school 3613740 660501060000   HARRISON 361374001122 660501060004 HARRISON HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 745.0 28.0 212.0         98.0     12.0   543.0 552.0     53       241     139   1095 745 28 212         98     12   543 552     53   241   139   1095
2140167 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   grade_8 276.0 29.0 22.0   1.0     97.0     21.0   235.0 211.0     *       116     57   446 276 29 22   1     97     21   235 211         116   57   446
2171133 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302717 332200010217 PS 217 COL DAVID MARCUS SCHOOL public Regular School No Elementary PK 05 2019   grade_4 41.0 17.0 47.0   0.0     97.0     6.0   107.0 101.0     70       169     34   208 41 17 47   0     97     6   107 101     70   169   34   208
2193257 NY Oneida   school 3629370 412300010000   UTICA 362937003948 412300010006 GENERAL HERKIMER ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 237.0 165.0 182.0   3.0     97.0     77.0   365.0 396.0     114       656     101   761 237 165 182   3     97     77   365 396     114   656   101   761
2199888 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802103 342400010019 PS 19 MARINO JEANTET public Regular School No Elementary KG 05 2019   pk_12_total 11.0 8.0 1771.0   4.0     97.0     2.0   965.0 928.0     1039       1690     431   1893 11 8 1771   4     97     2   965 928     1039   1690   431   1893
2200617 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802038 342400011455 NEWTOWN HIGH SCHOOL public Regular School No High 09 12 2019   grade_11 24.0 17.0 209.0   3.0     97.0     8.0   221.0 137.0     64       278     28   358 24 17 209   3     97     8   221 137     64   278   28   358
2201116 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202586 342500010163 PS 163 FLUSHING HEIGHTS public Regular School No Elementary PK 05 2019   grade_5 0.0 1.0 22.0   0.0     97.0     1.0   64.0 57.0     27       95     22   121 0 1 22   0     97     1   64 57     27   95   22   121
2202768 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 2019   grade_4 14.0 8.0 142.0   0.0     97.0     0.0   145.0 116.0     20       221     50   261 14 8 142   0     97     0   145 116     20   221   50   261
2204875 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102362 342900010095 PS 95 EASTWOOD public Regular School No Elementary KG 05 2019   grade_2 2.0 20.0 107.0   8.0     97.0     1.0   118.0 117.0     66       170     25   235 2 20 107   8     97     1   118 117     66   170   25   235
2205732 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202287 343000010069 PS 69 JACKSON HEIGHTS public Regular School No Elementary PK 05 2019   grade_4 14.0 2.0 75.0   1.0     97.0     2.0   84.0 107.0     24       117     23   191 14 2 75   1     97     2   84 107     24   117   23   191
2225120 NY Westchester   school 3613740 660501060000   HARRISON 361374001123 660501060009 LOUIS M KLEIN MIDDLE SCHOOL public Regular School No Middle 06 11 2019   pk_12_total 529.0 19.0 154.0   1.0     97.0     13.0   387.0 426.0     59       167     119   813 529 19 154   1     97     13   387 426     59   167   119   813
2140038 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2019   pk_12_total 76.0 94.0 14.0   4.0     96.0     12.0   153.0 143.0     45       111     46   296 76 94 14   4     96     12   153 143     45   111   46   296
2200905 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202115 342500010022 PS 22 THOMAS JEFFERSON public Regular School No Elementary PK 05 2019   grade_3 3.0 3.0 45.0   0.0     96.0     2.0   78.0 71.0     65       138     17   149 3 3 45   0     96     2   78 71     65   138   17   149
2201762 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902099 342600010018 PS 18 WINCHESTER public Regular School No Elementary PK 05 2019   grade_5 14.0 21.0 10.0   1.0     96.0     1.0   73.0 70.0     6       76     21   143 14 21 10   1     96     1   73 70     6   76   21   143
2207051 NY Rensselaer   school 3624450 491200010000   RENSSELAER 362445003342 491200010006 VAN RENSSELAER ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 331.0 89.0 79.0   1.0     96.0     72.0   357.0 311.0     55       433     133   668 331 89 79   1     96     72   357 311     55   433   133   668
2171134 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302717 332200010217 PS 217 COL DAVID MARCUS SCHOOL public Regular School No Elementary PK 05 2019   grade_5 25.0 18.0 32.0   1.0     95.0     5.0   91.0 85.0     *       147     31   176 25 18 32   1     95     5   91 85         147   31   176
2179995 NY Nassau   school 3611460 280217020000   FRANKLIN SQUARE 361146000902 280217020003 POLK STREET SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 403.0 19.0 176.0   3.0     95.0     16.0   367.0 345.0     19       137     63   712 403 19 176   3     95     16   367 345     19   137   63   712
2185624 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702187 310200010042 PS 42 BENJAMIN ALTMAN public Regular School No Elementary PK 05 2019   grade_1 0.0 0.0 9.0   1.0     95.0     1.0   53.0 53.0     49       71     18   106 0 0 9   1     95     1   53 53     49   71   18   106
2185820 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702458 310200010124 PS 124 YUNG WING public Regular School No Elementary PK 05 2019   grade_4 2.0   2.0         95.0     0.0   51.0 48.0     8       52     14   99 2   2         95     0   51 48     8   52   14   99
2200165 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802386 342400010102 PS 102 BAYVIEW public Regular School No Elementary PK 08 2019   grade_4 8.0 4.0 43.0   1.0     95.0     2.0   84.0 69.0     26       124     26   153 8 4 43   1     95     2   84 69     26   124   26   153
2200167 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802386 342400010102 PS 102 BAYVIEW public Regular School No Elementary PK 08 2019   grade_6 4.0 5.0 43.0   2.0     95.0     0.0   73.0 76.0     9       123     12   149 4 5 43   2     95     0   73 76     9   123   12   149
2200904 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202115 342500010022 PS 22 THOMAS JEFFERSON public Regular School No Elementary PK 05 2019   grade_2 4.0 0.0 50.0   2.0     95.0     2.0   84.0 69.0     94       140     22   153 4 0 50   2     95     2   84 69     94   140   22   153
2201573 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012205879 342500011281 EAST-WEST SCHOOL OF INTERNATION STUD public Regular School No High 06 12 2019   grade_6 1.0 0.0 10.0   0.0     95.0     0.0   49.0 57.0     18       86     15   106 1 0 10   0     95     0   49 57     18   86   15   106
2203571 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305899 342700011650 HS FOR CON, TRADES, ENGINEER AND ARC public Career and Technical School No High 09 12 2019   grade_9 35.0 17.0 112.0   16.0     95.0     17.0   181.0 111.0     *       167     50   292 35 17 112   16     95     17   181 111         167   50   292
2203890 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002333 342800010086 PS 86 public Regular School No Elementary PK 05 2019   grade_5 0.0 14.0 66.0   3.0     95.0     1.0   80.0 99.0     42       150     35   179 0 14 66   3     95     1   80 99     42   150   35   179
2206074 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202548 343000010152 PS 152 GWENDOLINE N ALLEYNE public Regular School No Elementary PK 05 2019   grade_4 9.0 0.0 79.0   0.0     95.0     0.0   94.0 89.0     32       146     23   183 9 0 79   0     95     0   94 89     32   146   23   183
2210889 NY Saratoga   school 3626670 520302060000   SHENENDEHOWA 362667003633 520302060003 ARONGEN ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 430.0 9.0 81.0         95.0     43.0   321.0 337.0     48       188     85   658 430 9 81         95     43   321 337     48   188   85   658
2140266 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 330.0 33.0 20.0   1.0     94.0     27.0   261.0 244.0     67       139     48   505 330 33 20   1     94     27   261 244     67   139   48   505
2149785 NY Broome   school 3629610 31601060000   VESTAL 362961003985 31601060041 VESTAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   pk_12_total 587.0 23.0 36.0   1.0     94.0     24.0   401.0 364.0     14       227     95   765 587 23 36   1     94     24   401 364     14   227   95   765
2155751 NY Erie   school 3602920 140201060000   AMHERST 360292004289 140201060006 WINDERMERE BLVD SCHOOL public Regular School No Elementary PK 05 2019   pk_12_total 389.0 179.0 39.0   2.0     94.0     45.0   379.0 369.0     94       390     99   748 389 179 39   2     94     45   379 369     94   390   99   748
2156473 NY Erie   school 3605850 140600010000   BUFFALO 360585000348 140600010056 FREDERICK OLMSTED #156 public Regular School No High 05 12 2019   pk_12_total 286.0 311.0 104.0   7.0     94.0     46.0   403.0 445.0     7       426     133   848 286 311 104   7     94     46   403 445     7   426   133   848
2164035 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902816 331400010318 IS 318 EUGENIO MARIA DE HOSTOS public Regular School No Middle 06 08 2019   pk_12_total 214.0 202.0 688.0   4.0     94.0     6.0   617.0 591.0     66       774     239   1208 214 202 688   4     94     6   617 591     66   774   239   1208
2164733 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009204474 331500010088 JHS 88 PETER ROUGET public Regular School No Middle 06 08 2019   grade_7 45.0 59.0 227.0   2.0     94.0     1.0   223.0 205.0     56       344     99   428 45 59 227   2     94     1   223 205     56   344   99   428
2169422 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102603 332000010170 RALPH A FABRIZIO SCHOOL public Regular School No Elementary KG 05 2019   grade_3 36.0 0.0 21.0   0.0     94.0     0.0   80.0 71.0     *       135     22   151 36 0 21   0     94     0   80 71         135   22   151
2185856 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 2019   grade_2 6.0 0.0 9.0   0.0     94.0     6.0   60.0 55.0     30       57     *   115 6 0 9   0     94     6   60 55     30   57       115
2185956 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 2019   grade_7 242.0 28.0 63.0   2.0     94.0     15.0   235.0 209.0     *       *     *   444 242 28 63   2     94     15   235 209                 444
2186433 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705085 310200010418 MILLENNIUM HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 73.0 3.0 26.0   1.0     94.0     14.0   90.0 121.0     0       95     29   211 73 3 26   1     94     14   90 121     0   95   29   211
2202008 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902580 342600010162 PS 162 JOHN GOLDEN public Regular School No Elementary PK 05 2019   grade_4 17.0 5.0 9.0   0.0     94.0     3.0   73.0 55.0     20       79     24   128 17 5 9   0     94     3   73 55     20   79   24   128
2203019 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012301995 342700010226 JHS 226 VIRGIL I GRISSOM public Regular School No Middle 06 08 2019   grade_8 8.0 110.0 59.0   56.0     94.0     2.0   182.0 147.0     26       271     66   329 8 110 59   56     94     2   182 147     26   271   66   329
2214518 NY Suffolk   school 3628200 580201060000   THREE VILLAGE 362820003804 580201060004 NASSAKEAG ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 342.0 12.0 28.0         94.0     7.0   235.0 248.0             28     50   483 342 12 28         94     7   235 248         28   50   483
2214632 NY Suffolk   school 3628200 580201060000   THREE VILLAGE 362820003807 580201060010 ROBERT CUSHMAN MURPHY JR HIGH SCHOOL public Regular School No Middle 07 09 2019   pk_12_total 560.0 13.0 46.0   2.0     94.0     5.0   387.0 333.0     13       114     111   720 560 13 46   2     94     5   387 333     13   114   111   720
2219382 NY Suffolk   school 3627060 580801060000   SMITHTOWN 362706000327 580801060022 SMITHTOWN HIGH SCHOOL-WEST public Regular School No High 09 12 2019   pk_12_total 1302.0 25.0 142.0   3.0     94.0     7.0   808.0 765.0     38       173     260   1573 1302 25 142   3     94     7   808 765     38   173   260   1573
2163187 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009101928 331300011430 BROOKLYN TECHNICAL HIGH SCHOOL public Regular School No High 09 12 2019   grade_11 360.0 94.0 117.0   11.0     936.0     10.0   913.0 615.0     *       950     16   1528 360 94 117   11     936     10   913 615         950   16   1528
2169697 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102735 332000010227 JHS 227 EDWARD B SHALLOW public Regular School No Middle 06 08 2019   pk_12_total 189.0 10.0 479.0   7.0     933.0     2.0   889.0 731.0     453       1471     253   1620 189 10 479   7     933     2   889 731     453   1471   253   1620
2180014 NY Nassau   school 3611460 280217020000   FRANKLIN SQUARE 361146000903 280217020004 WASHINGTON STREET SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 514.0 18.0 201.0   4.0     93.0     11.0   448.0 393.0     30       167     144   841 514 18 201   4     93     11   448 393     30   167   144   841
2182192 NY Nassau   school 3614280 280409030000   HERRICKS 361428001175 280409030002 DENTON AVENUE SCHOOL public Regular School No Elementary KG 05 2019   grade_5 21.0 1.0 7.0         93.0     1.0   66.0 57.0     *       9     10   123 21 1 7         93     1   66 57         9   10   123
2182670 NY Nassau   school 3628560 280502060000   SYOSSET 362856003841 280502060012 SOUTH WOODS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 130.0 1.0 18.0         93.0     4.0   131.0 115.0     *       16     26   246 130 1 18         93     4   131 115         16   26   246
2193404 NY Oneida   school 3629370 412300010000   UTICA 362937003962 412300010023 SENATOR JAMES H DONOVAN MIDDLE SCH public Regular School No Middle 07 08 2019   grade_7 74.0 99.0 79.0   1.0     93.0     28.0   175.0 199.0     73       373     65   374 74 99 79   1     93     28   175 199     73   373   65   374
2200401 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009806223 342400010290 ACE ACADEMY FOR SCHOLARS public Regular School No Elementary PK 05 2019   pk_12_total 170.0 17.0 289.0   3.0     93.0     17.0   302.0 287.0     55       380     65   589 170 17 289   3     93     17   302 287     55   380   65   589
2206025 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202536 343000010149 PS 149 CHRISTA MCAULIFFE public Regular School No Elementary KG 05 2019   pk_12_total 27.0 12.0 832.0   6.0     93.0     1.0   472.0 499.0     366       744     197   971 27 12 832   6     93     1   472 499     366   744   197   971
2206075 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202548 343000010152 PS 152 GWENDOLINE N ALLEYNE public Regular School No Elementary PK 05 2019   grade_5 7.0 1.0 71.0   5.0     93.0     0.0   82.0 95.0     *       145     24   177 7 1 71   5     93     0   82 95         145   24   177
2208616 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302035 353100011440 NEW DORP HIGH SCHOOL public Regular School No High 09 12 2019   grade_11 467.0 83.0 258.0   5.0     93.0     5.0   503.0 408.0     52       571     298   911 467 83 258   5     93     5   503 408     52   571   298   911
2170647 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015201943 332100011525 EDWARD R MURROW HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 1114.0 817.0 712.0   15.0     923.0     132.0   1555.0 2158.0     327       2492     707   3713 1114 817 712   15     923     132   1555 2158     327   2492   707   3713
2140095 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 354.0 22.0 29.0   2.0     92.0     35.0   252.0 282.0     57       161     63   534 354 22 29   2     92     35   252 282     57   161   63   534
2171089 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302695 332200010206 PS 206 JOSEPH F LAMB public Regular School No Elementary KG 08 2019   grade_1 73.0 0.0 13.0   1.0     92.0     4.0   87.0 96.0     64       115     26   183 73 0 13   1     92     4   87 96     64   115   26   183
2171616 NY Kings   school 3601015 332200860978   BROOKLYN DREAMS CHARTER SCHO 360101506206 332200860978 BROOKLYN DREAMS CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   pk_12_total 15.0 402.0 98.0   10.0     92.0     4.0   322.0 299.0     72       510     116   621 15 402 98   10     92     4   322 299     72   510   116   621
2181287 NY Nassau   school 3619020 280253070000   BELLMORE-MERRICK 361902001725 280253070006 WELLINGTON C MEPHAM HIGH SCH public Regular School No High 09 12 2019   pk_12_total 966.0 21.0 143.0   5.0     92.0     22.0   622.0 627.0     7       188     170   1249 966 21 143   5     92     22   622 627     7   188   170   1249
2184555 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502070 307500014009 PS 9 public Special Education School No Elementary KG 08 2019   pk_12_total 73.0 201.0 269.0   7.0     92.0     4.0   462.0 184.0     186       539     646   646 73 201 269   7     92     4   462 184     186   539   646   646
2186113 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007704410 310200010260 CLINTON SCHOOL (THE) public Regular School No High 06 12 2019   pk_12_total 459.0 28.0 89.0   5.0     92.0     48.0   229.0 492.0     *       124     127   721 459 28 89   5     92     48   229 492         124   127   721
2195708 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003883 421800010043 WEBSTER ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   pk_12_total 198.0 202.0 66.0   2.0     92.0     71.0   346.0 285.0     127       560     142   631 198 202 66   2     92     71   346 285     127   560   142   631
2199802 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009804563 342400010012 PS 12 JAMES B COLGATE public Regular School No Elementary KG 05 2019   grade_2 10.0 0.0 86.0   0.0     92.0     1.0   102.0 87.0     53       166     36   189 10 0 86   0     92     1   102 87     53   166   36   189
2199850 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802084 342400010014 PS 14 FAIRVIEW public Regular School No Elementary KG 05 2019   pk_12_total 27.0 35.0 1411.0   4.0     92.0     6.0   767.0 808.0     533       1315     303   1575 27 35 1411   4     92     6   767 808     533   1315   303   1575
2202040 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902610 342600010173 PS 173 FRESH MEADOWS public Regular School No Elementary PK 05 2019   grade_1 32.0 0.0 15.0   1.0     92.0     2.0   79.0 63.0     20       81     24   142 32 0 15   1     92     2   79 63     20   81   24   142
2202047 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009902610 342600010173 PS 173 FRESH MEADOWS public Regular School No Elementary PK 05 2019   grade_5 35.0 2.0 21.0   1.0     92.0     3.0   87.0 67.0     *       88     27   154 35 2 21   1     92     3   87 67         88   27   154
2203966 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002448 342800010121 PS 121 public Regular School No Elementary PK 05 2019   grade_5 2.0 31.0 22.0   13.0     92.0     2.0   93.0 69.0     9       125     23   162 2 31 22   13     92     2   93 69     9   125   23   162
2206120 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202606 343000010171 PS 171 PETER G VAN ALST public Regular School No Elementary PK 05 2019   pk_12_total 31.0 129.0 207.0   5.0     92.0     2.0   242.0 224.0     89       432     108   466 31 129 207   5     92     2   242 224     89   432   108   466
2206671 NY Queens   school 3601053 343000860998   ACADEMY OF THE CITY CHARTER 360105306289 343000860998 ACADEMY OF THE CITY CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2019   pk_12_total 67.0 33.0 218.0   1.0     92.0         190.0 221.0     40       291     51   411 67 33 218   1     92         190 221     40   291   51   411
2209080 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034005897 500101060022 FELIX FESTA DETERMINATION MIDDLE SCH public Regular School No Middle 08 08 2019   grade_8 389.0 36.0 107.0         92.0     18.0   335.0 307.0     13       *     106   642 389 36 107         92     18   335 307     13       106   642
2209084 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034005897 500101060022 FELIX FESTA DETERMINATION MIDDLE SCH public Regular School No Middle 08 08 2019   pk_12_total 392.0 36.0 109.0         92.0     18.0   337.0 310.0     13       98     111   647 392 36 109         92     18   337 310     13   98   111   647
2209407 NY Rockland   school 3627450 500301060000   SOUTH ORANGETOWN 362745003741 500301060007 TAPPAN ZEE HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 747.0 20.0 181.0   2.0     92.0     13.0   521.0 534.0     48       184     130   1055 747 20 181   2     92     13   521 534     48   184   130   1055
2210984 NY Saratoga   school 3626670 520302060000   SHENENDEHOWA 362667003637 520302060008 KODA MIDDLE SCHOOL public Regular School No Middle 06 08 2019   pk_12_total 551.0 18.0 77.0         92.0     32.0   412.0 358.0     23       189     89   770 551 18 77         92     32   412 358     23   189   89   770
2217064 NY Suffolk   school 3613290 580405060000   HALF HOLLOW HILLS 361329001090 580405060013 SIGNAL HILL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 407.0 62.0 78.0         92.0     37.0   347.0 329.0     37       139     113   676 407 62 78         92     37   347 329     37   139   113   676
2163186 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009101928 331300011430 BROOKLYN TECHNICAL HIGH SCHOOL public Regular School No High 09 12 2019   grade_10 396.0 79.0 97.0   7.0     915.0     27.0   911.0 610.0     *       889     28   1521 396 79 97   7     915     27   911 610         889   28   1521
2146308 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705190 321000011696 HS AMER STUDIES AT LEHMAN COLL public Regular School No High 09 12 2019   pk_12_total 241.0 16.0 43.0   3.0     91.0     18.0   198.0 214.0             105     13   412 241 16 43   3     91     18   198 214         105   13   412
2155447 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004022 132101060011 ROY C KETCHAM SENIOR HIGH SCH public Regular School No High 09 12 2019   pk_12_total 1066.0 157.0 340.0   2.0     91.0     28.0   852.0 832.0     29       561     243   1684 1066 157 340   2     91     28   852 832     29   561   243   1684
2169423 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102603 332000010170 RALPH A FABRIZIO SCHOOL public Regular School No Elementary KG 05 2019   grade_4 49.0 1.0 34.0   2.0     91.0     0.0   89.0 88.0     47       159     31   177 49 1 34   2     91     0   89 88     47   159   31   177
2169424 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015102603 332000010170 RALPH A FABRIZIO SCHOOL public Regular School No Elementary KG 05 2019   grade_5 36.0 1.0 31.0   1.0     91.0     0.0   103.0 57.0     46       148     35   160 36 1 31   1     91     0   103 57     46   148   35   160
2169849 NY Kings   school 3600151 332000010000   NYC GEOG DIST #20 - BROOKLYN 360015106120 332000010682 ACADEMY OF TALENTED SCHOLARS (THE) public Regular School No Elementary KG 05 2019   pk_12_total 229.0 16.0 45.0         91.0     7.0   213.0 175.0     30       165     119   388 229 16 45         91     7   213 175     30   165   119   388
2182018 NY Nassau   school 3612510 280407030000   GREAT NECK 361251001021 280407030008 LAKEVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_2 23.0 2.0 20.0   0.0     91.0     8.0   80.0 64.0     13       32     17   144 23 2 20   0     91     8   80 64     13   32   17   144
2184631 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502858 307500014224 PS 224 public Special Education School No Elementary PK 08 2019   pk_12_total 37.0 75.0 117.0   70.0     91.0     7.0   295.0 102.0     85       282     397   397 37 75 117   70     91     7   295 102     85   282   397   397
2185826 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702458 310200010124 PS 124 YUNG WING public Regular School No Elementary PK 05 2019   kindergarten_full_day 2.0   1.0         91.0     1.0   51.0 44.0     43       51     10   95 2   1         91     1   51 44     43   51   10   95
2186341 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706130 310200010397 SPRUCE STREET SCHOOL public Regular School No Elementary PK 08 2019   pk_12_total 296.0 22.0 90.0   7.0     91.0     52.0   283.0 275.0     13       101     119   558 296 22 90   7     91     52   283 275     13   101   119   558
2195518 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003860 421800010022 FRAZER K-8 SCHOOL public Regular School No Elementary PK 08 2019   pk_12_total 241.0 337.0 148.0   10.0     91.0     68.0   469.0 426.0     217       845     193   895 241 337 148   10     91     68   469 426     217   845   193   895

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