Data source: Big Local News · About: Big Local

4,722 rows where grade = "pk_12_total", state = "NY" and year = 2017

View and edit SQL

year

  • 2017 · 4,722

grade

  • pk_12_total · 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
942049 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 185.0 55.0 39.0   1.0     19.0     25.0   166.0 158.0     20       85     23   324 185 55 39   1     19     25   166 158     20   85   23   324
942068 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   pk_12_total 89.0 169.0 98.0   1.0     41.0     44.0   222.0 220.0     49       232     51   442 89 169 98   1     41     44   222 220     49   232   51   442
942087 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 69.0 111.0 192.0   1.0     58.0     27.0   225.0 233.0     116       266     42   458 69 111 192   1     58     27   225 233     116   266   42   458
942106 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 242.0 103.0 64.0   2.0     38.0     35.0   268.0 216.0     26       147     78   484 242 103 64   2     38     35   268 216     26   147   78   484
942125 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 08 2017   pk_12_total 47.0 247.0 74.0         15.0     19.0   220.0 182.0     64       267     56   402 47 247 74         15     19   220 182     64   267   56   402
942144 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary KG 06 2017   pk_12_total 95.0 282.0 90.0   3.0     46.0     35.0   267.0 284.0     36       262     80   551 95 282 90   3     46     35   267 284     36   262   80   551
942163 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   pk_12_total 160.0 95.0 35.0   2.0     37.0     16.0   193.0 152.0     49       157     51   345 160 95 35   2     37     16   193 152     49   157   51   345
942182 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2017   pk_12_total 54.0 214.0 74.0   2.0     108.0     27.0   280.0 199.0     58       298     43   479 54 214 74   2     108     27   280 199     58   298   43   479
942201 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   pk_12_total 42.0 300.0 121.0   2.0     54.0     41.0   308.0 252.0     72       430     65   560 42 300 121   2     54     41   308 252     72   430   65   560
942220 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 152.0 262.0 107.0   4.0     57.0     21.0   279.0 324.0     68       342     94   603 152 262 107   4     57     21   279 324     68   342   94   603
942239 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 505.0 1339.0 382.0   9.0     227.0     67.0   1234.0 1295.0     271       1379     369   2529 505 1339 382   9     227     67   1234 1295     271   1379   369   2529
942258 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   pk_12_total 21.0 263.0 71.0   1.0     7.0     19.0   206.0 176.0     21       305     56   382 21 263 71   1     7     19   206 176     21   305   56   382
942277 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2017   pk_12_total 26.0 142.0 53.0   3.0     13.0     41.0   148.0 130.0     41       216     64   278 26 142 53   3     13     41   148 130     41   216   64   278
942296 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2017   pk_12_total 42.0 234.0 60.0   1.0     17.0     36.0   192.0 198.0     49       290     24   390 42 234 60   1     17     36   192 198     49   290   24   390
942315 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 124.0 395.0 92.0   2.0     60.0     25.0   349.0 349.0     66       429     79   698 124 395 92   2     60     25   349 349     66   429   79   698
942334 NY Albany   school 3602460 10100010000   ALBANY 360246006538 10100010046 WEST HILL MIDDLE SCHOOL public Regular School No Middle 07 08 2017   pk_12_total 10.0 131.0 28.0         1.0     8.0   99.0 79.0             128     25   178 10 131 28         1     8   99 79         128   25   178
942353 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2017   pk_12_total 7.0 248.0 47.0         6.0     3.0   311.0       8       283     6   311 7 248 47         6     3   311       8   283   6   311
942372 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2017   pk_12_total 5.0 223.0 58.0         10.0     21.0   1.0 316.0     5       275     6   317 5 223 58         10     21   1 316     5   275   6   317
942391 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   pk_12_total 16.0 344.0 37.0   4.0     8.0     6.0   186.0 229.0             214         415 16 344 37   4     8     6   186 229         214       415
942410 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   pk_12_total 2.0 332.0 43.0   2.0     1.0         192.0 188.0     7       335         380 2 332 43   2     1         192 188     7   335       380
942429 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   pk_12_total 9.0 639.0 27.0         7.0         338.0 344.0     8       595     16   682 9 639 27         7         338 344     8   595   16   682
942448 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 09 12 2017   pk_12_total 10.0 270.0 49.0   1.0     2.0     21.0   353.0               212     18   353 10 270 49   1     2     21   353           212   18   353
942467 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2017   pk_12_total 31.0 287.0 47.0   3.0     15.0     11.0     394.0     26       287     22   394 31 287 47   3     15     11     394     26   287   22   394
942486 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   pk_12_total 359.0 3.0 5.0   1.0     3.0         195.0 176.0             138     57   371 359 3 5   1     3         195 176         138   57   371
942505 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary KG 06 2017   pk_12_total 378.0   7.0         2.0     4.0   216.0 175.0             165     44   391 378   7         2     4   216 175         165   44   391
942524 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 246.0 8.0 6.0         8.0     18.0   138.0 148.0             50     39   286 246 8 6         8     18   138 148         50   39   286
942543 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 303.0 5.0 14.0         37.0     6.0   183.0 182.0     15       47     56   365 303 5 14         37     6   183 182     15   47   56   365
942562 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 284.0 9.0 6.0         14.0     10.0   171.0 152.0             38     59   323 284 9 6         14     10   171 152         38   59   323
942581 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 410.0 13.0 11.0         52.0     13.0   276.0 223.0     27       73     55   499 410 13 11         52     13   276 223     27   73   55   499
942600 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 929.0 25.0 35.0         72.0     9.0   504.0 566.0     10       155     132   1070 929 25 35         72     9   504 566     10   155   132   1070
942619 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 1398.0 45.0 59.0         118.0     10.0   816.0 814.0     12       212     144   1630 1398 45 59         118     10   816 814     12   212   144   1630
942638 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 356.0 9.0 9.0   1.0     26.0     9.0   232.0 178.0             57     68   410 356 9 9   1     26     9   232 178         57   68   410
942657 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2017   pk_12_total 464.0 28.0 33.0         6.0     11.0   271.0 271.0     *       230     87   542 464 28 33         6     11   271 271         230   87   542
942676 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 356.0 7.0 25.0         8.0     18.0   206.0 208.0     *       158     65   414 356 7 25         8     18   206 208         158   65   414
942695 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 353.0 26.0 49.0   1.0     1.0     34.0   234.0 230.0     8       215     62   464 353 26 49   1     1     34   234 230     8   215   62   464
942714 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2017   pk_12_total 345.0 20.0 27.0         2.0     24.0   229.0 189.0             192     71   418 345 20 27         2     24   229 189         192   71   418
942733 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 289.0 27.0 35.0   1.0     1.0     25.0   202.0 176.0             264     39   378 289 27 35   1     1     25   202 176         264   39   378
942752 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 94.0 12.0 16.0         4.0     16.0   70.0 72.0             88     33   142 94 12 16         4     16   70 72         88   33   142
942771 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 420.0 55.0 32.0   2.0     4.0     17.0   257.0 273.0     *       339     83   530 420 55 32   2     4     17   257 273         339   83   530
942790 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 321.0 34.0 36.0   2.0     7.0     17.0   220.0 197.0     5       292     72   417 321 34 36   2     7     17   220 197     5   292   72   417
942809 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 321.0 40.0 34.0         8.0     28.0   226.0 205.0     18       253     77   431 321 40 34         8     28   226 205     18   253   77   431
942828 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2017   pk_12_total 279.0 31.0 36.0         46.0     47.0   207.0 232.0             139     63   439 279 31 36         46     47   207 232         139   63   439
942847 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   pk_12_total 280.0 19.0 27.0         31.0     31.0   188.0 200.0             75     40   388 280 19 27         31     31   188 200         75   40   388
942866 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   pk_12_total 242.0 8.0 18.0         65.0     17.0   174.0 176.0     70       102     28   350 242 8 18         65     17   174 176     70   102   28   350
942885 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 1081.0 128.0 117.0   1.0     145.0     85.0   786.0 771.0     28       453     273   1557 1081 128 117   1     145     85   786 771     28   453   273   1557
942904 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   pk_12_total 205.0 21.0 18.0         34.0     16.0   145.0 149.0             94     72   294 205 21 18         34     16   145 149         94   72   294
942923 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   pk_12_total 303.0 25.0 45.0         22.0     44.0   221.0 218.0             105     53   439 303 25 45         22     44   221 218         105   53   439
942942 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2017   pk_12_total 539.0 64.0 55.0   1.0     85.0     60.0   401.0 403.0     26       296     134   804 539 64 55   1     85     60   401 403     26   296   134   804
942961 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2017   pk_12_total 458.0 37.0 36.0   1.0     54.0     32.0   320.0 298.0             154     83   618 458 37 36   1     54     32   320 298         154   83   618
942980 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2017   pk_12_total 74.0 55.0 11.0   2.0     95.0     17.0   122.0 132.0     33       80     16   254 74 55 11   2     95     17   122 132     33   80   16   254
942999 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2017   pk_12_total 322.0 31.0 24.0         90.0     32.0   253.0 246.0     34       143     89   499 322 31 24         90     32   253 246     34   143   89   499
943018 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2017   pk_12_total 328.0 16.0 30.0   1.0     130.0     17.0   281.0 241.0     25       77     47   522 328 16 30   1     130     17   281 241     25   77   47   522
943037 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2017   pk_12_total 329.0 18.0 30.0         79.0     37.0   246.0 247.0     46       136     56   493 329 18 30         79     37   246 247     46   136   56   493
943056 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2017   pk_12_total 340.0 11.0 13.0   1.0     99.0     28.0   228.0 264.0     38       127     58   492 340 11 13   1     99     28   228 264     38   127   58   492
943075 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2017   pk_12_total 235.0 6.0 29.0   3.0     23.0     13.0   141.0 168.0     9       31     27   309 235 6 29   3     23     13   141 168     9   31   27   309
943094 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2017   pk_12_total 267.0 24.0 19.0   2.0     60.0     26.0   223.0 175.0     26       91     78   398 267 24 19   2     60     26   223 175     26   91   78   398
943113 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2017   pk_12_total 638.0 46.0 41.0   2.0     121.0     27.0   453.0 422.0     18       190     134   875 638 46 41   2     121     27   453 422     18   190   134   875
943132 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 1362.0 126.0 104.0   4.0     318.0     42.0   948.0 1008.0     28       406     246   1956 1362 126 104   4     318     42   948 1008     28   406   246   1956
943151 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   pk_12_total 273.0 15.0 16.0         5.0     21.0   149.0 181.0     *       225     61   330 273 15 16         5     21   149 181         225   61   330
943170 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 254.0 5.0 9.0         9.0     10.0   146.0 141.0     *       89     43   287 254 5 9         9     10   146 141         89   43   287
943189 NY Albany   school 3613080 10802060000   GUILDERLAND 361308004589 10802060003 GUILDERLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 331.0 16.0 23.0         136.0     20.0   270.0 256.0     70       104     53   526 331 16 23         136     20   270 256     70   104   53   526
943208 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 313.0 22.0 18.0   1.0     101.0     23.0   236.0 242.0     79       100     44   478 313 22 18   1     101     23   236 242     79   100   44   478
943227 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 1233.0 69.0 50.0   1.0     171.0     46.0   814.0 756.0     12       269     225   1570 1233 69 50   1     171     46   814 756     12   269   225   1570
943246 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 304.0 15.0 17.0   1.0     42.0     18.0   214.0 183.0     10       60     47   397 304 15 17   1     42     18   214 183     10   60   47   397
943265 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 882.0 44.0 51.0   1.0     156.0     33.0   573.0 594.0     14       218     184   1167 882 44 51   1     156     33   573 594     14   218   184   1167
943284 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 304.0 7.0 10.0         57.0     11.0   198.0 191.0     11       38     32   389 304 7 10         57     11   198 191     11   38   32   389
943303 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 460.0 2.0 15.0         14.0     20.0   242.0 269.0     *       54     54   511 460 2 15         14     20   242 269         54   54   511
943322 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 364.0 6.0 5.0   1.0     15.0     5.0   204.0 192.0     *       32     50   396 364 6 5   1     15     5   204 192         32   50   396
943341 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 249.0 1.0 6.0   1.0     8.0     4.0   142.0 127.0             24     29   269 249 1 6   1     8     4   142 127         24   29   269
943360 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   pk_12_total 324.0 98.0 94.0         47.0     96.0   350.0 309.0     29       503     93   659 324 98 94         47     96   350 309     29   503   93   659
943379 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2017   pk_12_total 330.0 114.0 63.0   2.0     52.0     29.0   309.0 281.0     25       413     88   590 330 114 63   2     52     29   309 281     25   413   88   590
943398 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   pk_12_total 300.0 1.0 7.0         13.0     11.0   173.0 159.0             143     42   332 300 1 7         13     11   173 159         143   42   332
943417 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   pk_12_total 283.0   2.0         11.0     2.0   156.0 142.0             124     39   298 283   2         11     2   156 142         124   39   298
943436 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   pk_12_total 312.0 3.0           1.0         145.0 171.0             171     35   316 312 3           1         145 171         171   35   316
943455 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   pk_12_total 517.0 11.0 2.0   7.0     4.0     2.0   289.0 254.0             302     91   543 517 11 2   7     4     2   289 254         302   91   543
943474 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   pk_12_total 345.0   3.0               4.0   193.0 159.0             231     55   352 345   3               4   193 159         231   55   352
943493 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   pk_12_total 242.0 1.0 7.0         1.0         108.0 143.0             143     34   251 242 1 7         1         108 143         143   34   251
943512 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2017   pk_12_total 304.0 1.0 9.0               12.0   162.0 164.0             234     61   326 304 1 9               12   162 164         234   61   326
943531 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2017   pk_12_total 638.0 2.0 8.0   3.0     3.0         331.0 323.0             345     94   654 638 2 8   3     3         331 323         345   94   654
943550 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2017   pk_12_total 229.0   3.0                   109.0 123.0             133     32   232 229   3                   109 123         133   32   232
943569 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 235.0 6.0 8.0   1.0     4.0     1.0   130.0 125.0     *       132     46   255 235 6 8   1     4     1   130 125         132   46   255
943588 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 362.0 9.0 3.0         1.0     1.0   191.0 185.0             236     58   376 362 9 3         1     1   191 185         236   58   376
943607 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 169.0 2.0 5.0   1.0     1.0         106.0 72.0     *       110     25   178 169 2 5   1     1         106 72         110   25   178
943626 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2017   pk_12_total 322.0 2.0 2.0   3.0     1.0     6.0   174.0 162.0             231     41   336 322 2 2   3     1     6   174 162         231   41   336
943645 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SECONDARY SCHOOL public Regular School No Other 06 12 2017   pk_12_total 643.0 14.0 7.0   3.0     11.0     6.0   326.0 358.0             353     93   684 643 14 7   3     11     6   326 358         353   93   684
943664 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 555.0 8.0 8.0   1.0     3.0     6.0   277.0 304.0     *       365     86   581 555 8 8   1     3     6   277 304         365   86   581
943683 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No Other 06 12 2017   pk_12_total 396.0 2.0 7.0   1.0     1.0     6.0   217.0 196.0             254     59   413 396 2 7   1     1     6   217 196         254   59   413
943702 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2017   pk_12_total 354.0   2.0   1.0           5.0   183.0 179.0             215     60   362 354   2   1           5   183 179         215   60   362
943721 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402043 320700010001 PS 1 COURTLANDT SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 14.0 133.0 462.0   1.0     1.0     1.0   312.0 300.0     169       606     132   612 14 133 462   1     1     1   312 300     169   606   132   612
943740 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402056 320700010005 PS 5 PORT MORRIS public Regular School No Elementary PK 08 2017   pk_12_total 11.0 203.0 500.0   5.0     2.0     4.0   366.0 359.0     170       695     173   725 11 203 500   5     2     4   366 359     170   695   173   725
943759 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402098 320700010018 PS 18 JOHN PETER ZENGER public Regular School No Elementary PK 05 2017   pk_12_total 17.0 161.0 385.0   5.0     13.0     3.0   319.0 265.0     167       572     165   584 17 161 385   5     13     3   319 265     167   572   165   584
943778 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 4.0 51.0 420.0   1.0     8.0     2.0   270.0 216.0     77       471     138   486 4 51 420   1     8     2   270 216     77   471   138   486
943797 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402138 320700010029 PS/MS 29 MELROSE SCHOOL public Regular School No Elementary PK 08 2017   pk_12_total 9.0 220.0 512.0   4.0     19.0     4.0   395.0 373.0     108       699     183   768 9 220 512   4     19     4   395 373     108   699   183   768
943816 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402143 320700010030 PS 30 WILTON public Regular School No Elementary PK 05 2017   pk_12_total 17.0 118.0 435.0   3.0     7.0     2.0   282.0 300.0     104       532     135   582 17 118 435   3     7     2   282 300     104   532   135   582
943835 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402147 320700010031 PS/MS 31 WILLIAM LLOYD GARRISON public Regular School No Elementary PK 08 2017   pk_12_total 14.0 195.0 499.0   5.0     17.0     1.0   393.0 338.0     95       680     189   731 14 195 499   5     17     1   393 338     95   680   189   731
943854 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No Elementary PK 05 2017   pk_12_total 5.0 128.0 328.0   2.0     3.0         221.0 245.0     56       455     124   466 5 128 328   2     3         221 245     56   455   124   466
943873 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402218 320700010049 PS 49 WILLIS AVENUE public Regular School No Elementary PK 05 2017   pk_12_total 6.0 186.0 466.0   1.0     2.0     5.0   344.0 322.0     110       656     185   666 6 186 466   1     2     5   344 322     110   656   185   666
943892 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402269 320700010065 PS 65 MOTHER HALE ACADEMY public Regular School No Elementary PK 05 2017   pk_12_total 6.0 152.0 257.0   1.0     7.0     2.0   208.0 217.0     52       423     96   425 6 152 257   1     7     2   208 217     52   423   96   425
943911 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401983 320700010151 JHS 151 LOU GEHRIG public Regular School No Middle 06 08 2017   pk_12_total 4.0 67.0 163.0                   122.0 112.0     68       228     73   234 4 67 163                   122 112     68   228   73   234
943930 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402556 320700010154 PS 154 JONATHAN D HYATT public Regular School No Elementary PK 05 2017   pk_12_total 7.0 154.0 213.0   3.0     2.0     2.0   204.0 177.0     41       374     89   381 7 154 213   3     2     2   204 177     41   374   89   381

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