Data source: Big Local News · About: Big Local

4,742 rows where grade = "pk_12_total", state = "NY" and year = 2020 sorted by district_state_id

View and edit SQL

year

  • 2020 · 4,742

grade

  • pk_12_total · 4,742
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
1537357 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2020   pk_12_total 9.0 22.0 9.0                   38.0 2.0             31     33   40 9 22 9                   38 2         31   33   40
1537376 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2020   pk_12_total 23.0 8.0 6.0               6.0   34.0 9.0             20     21   43 23 8 6               6   34 9         20   21   43
1537395 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2020   pk_12_total 494.0 10.0 71.0   1.0     3.0     29.0   311.0 297.0     9       205     93   608 494 10 71   1     3     29   311 297     9   205   93   608
1537414 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pk_12_total 503.0 15.0 67.0   1.0     2.0     47.0   321.0 314.0     23       241     59   635 503 15 67   1     2     47   321 314     23   241   59   635
1537433 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pk_12_total 224.0 1.0 22.0         2.0     15.0   131.0 133.0     6       123     40   264 224 1 22         2     15   131 133     6   123   40   264
1537452 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   pk_12_total 219.0 1.0 23.0         4.0     9.0   146.0 110.0     *       105     45   256 219 1 23         4     9   146 110         105   45   256
1523031 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2020   pk_12_total 161.0 73.0 38.0         25.0     39.0   189.0 147.0     10       103     39   336 161 73 38         25     39   189 147     10   103   39   336
1523050 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   pk_12_total 80.0 166.0 77.0   1.0     25.0     35.0   197.0 187.0     47       258     47   384 80 166 77   1     25     35   197 187     47   258   47   384
1523069 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2020   pk_12_total 58.0 94.0 191.0         38.0     31.0   221.0 191.0     108       281     29   412 58 94 191         38     31   221 191     108   281   29   412
1523088 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   pk_12_total 202.0 126.0 68.0   1.0     47.0     39.0   260.0 223.0     33       211     97   483 202 126 68   1     47     39   260 223     33   211   97   483
1523107 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2020   pk_12_total 67.0 234.0 96.0   2.0     33.0     52.0   244.0 240.0     26       290     77   484 67 234 96   2     33     52   244 240     26   290   77   484
1523126 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pk_12_total 144.0 88.0 40.0   1.0     28.0     17.0   178.0 140.0     28       133     63   318 144 88 40   1     28     17   178 140     28   133   63   318
1523145 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2020   pk_12_total 60.0 184.0 60.0   1.0     103.0     36.0   233.0 211.0     58       284     44   444 60 184 60   1     103     36   233 211     58   284   44   444
1523164 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pk_12_total 38.0 261.0 108.0   3.0     41.0     34.0   256.0 229.0     51       417     105   485 38 261 108   3     41     34   256 229     51   417   105   485
1523183 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 165.0 215.0 140.0   1.0     88.0     47.0   349.0 307.0     60       422     126   656 165 215 140   1     88     47   349 307     60   422   126   656
1523202 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 530.0 1319.0 415.0   11.0     213.0     86.0   1287.0 1287.0     292       1610     362   2574 530 1319 415   11     213     86   1287 1287     292   1610   362   2574
1523221 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   pk_12_total 11.0 211.0 58.0         10.0     23.0   171.0 142.0     16       254     63   313 11 211 58         10     23   171 142     16   254   63   313
1523240 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2020   pk_12_total 21.0 145.0 60.0         30.0     27.0   141.0 142.0     59       249     54   283 21 145 60         30     27   141 142     59   249   54   283
1523259 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2020   pk_12_total 21.0 194.0 64.0   2.0     22.0     30.0   156.0 177.0     30       265     43   333 21 194 64   2     22     30   156 177     30   265   43   333
1523278 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 128.0 289.0 115.0   2.0     37.0     49.0   307.0 313.0     52       408     110   620 128 289 115   2     37     49   307 313     52   408   110   620
1523297 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2020   pk_12_total 35.0 296.0 76.0   2.0     16.0     28.0   225.0 228.0     36       384     55   453 35 296 76   2     16     28   225 228     36   384   55   453
1523316 NY Albany   school 3602460 10100010000   ALBANY 360246006700 10100010051 NORTH ALBANY ACADEMY MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 10.0 48.0 13.0         6.0     11.0   56.0 32.0     21       71     16   88 10 48 13         6     11   56 32     21   71   16   88
1537471 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   pk_12_total 363.0 4.0 29.0   1.0           22.0   210.0 209.0     11       186     55   419 363 4 29   1           22   210 209     11   186   55   419
1537490 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 277.0 6.0 24.0         3.0     11.0   164.0 157.0     *       121     67   321 277 6 24         3     11   164 157         121   67   321
1537509 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 214.0 1.0 12.0         3.0     13.0   124.0 119.0     *       109     43   243 214 1 12         3     13   124 119         109   43   243
1523335 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2020   pk_12_total 16.0 193.0 56.0         17.0     23.0   305.0       21       294     19   305 16 193 56         17     23   305       21   294   19   305
1523354 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2020   pk_12_total 10.0 212.0 64.0   1.0     28.0     13.0     328.0     35       285     9   328 10 212 64   1     28     13     328     35   285   9   328
1523373 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   pk_12_total 8.0 614.0 91.0   2.0     5.0     20.0   343.0 397.0     18       549     30   740 8 614 91   2     5     20   343 397     18   549   30   740
1523392 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   pk_12_total 8.0 269.0 63.0               23.0   173.0 190.0     11       321     *   363 8 269 63               23   173 190     11   321       363
1523411 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   pk_12_total 3.0 581.0 48.0         3.0     10.0   275.0 370.0     5       587     7   645 3 581 48         3     10   275 370     5   587   7   645
1523430 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 06 12 2020   pk_12_total 9.0 244.0 61.0   1.0     2.0     41.0   358.0               246     10   358 9 244 61   1     2     41   358           246   10   358
1523449 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2020   pk_12_total 42.0 190.0 42.0   3.0     16.0     16.0     309.0     33       261     16   309 42 190 42   3     16     16     309     33   261   16   309
1537528 NY Columbia   school 3614940 101300010000   HUDSON 361494001249 101300010001 HUDSON HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 183.0 102.0 65.0         86.0     16.0   227.0 225.0     38       314     71   452 183 102 65         86     16   227 225     38   314   71   452
1537547 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH ELEMENTARY public Regular School No Elementary PK 05 2020   pk_12_total 321.0 148.0 133.0   1.0     85.0     113.0   409.0 392.0     89       564     115   801 321 148 133   1     85     113   409 392     89   564   115   801
1537566 NY Columbia   school 3614940 101300010000   HUDSON 361494006579 101300010004 HUDSON JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 155.0 76.0 71.0   1.0     52.0     44.0   190.0 209.0     33       303     80   399 155 76 71   1     52     44   190 209     33   303   80   399
1537585 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   pk_12_total 401.0 5.0 72.0   1.0     5.0     28.0   249.0 263.0     47       223     64   512 401 5 72   1     5     28   249 263     47   223   64   512
1537604 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001279 101401040005 ICHABOD CRANE SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 449.0 16.0 28.0         15.0     4.0   262.0 250.0     11       133     73   512 449 16 28         15     4   262 250     11   133   73   512
1537623 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No Middle 04 08 2020   pk_12_total 572.0 13.0 54.0         5.0     15.0   347.0 312.0     21       242     95   659 572 13 54         5     15   347 312     21   242   95   659
1537642 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   pk_12_total 217.0 2.0 5.0               11.0   120.0 115.0             126     41   235 217 2 5               11   120 115         126   41   235
1537661 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   pk_12_total 178.0 2.0 6.0         1.0     5.0   94.0 98.0             80     22   192 178 2 6         1     5   94 98         80   22   192
1523468 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2020   pk_12_total 323.0 4.0 8.0   1.0     3.0     5.0   176.0 168.0             141     55   344 323 4 8   1     3     5   176 168         141   55   344
1523487 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2020   pk_12_total 384.0 1.0 11.0         1.0     11.0   207.0 201.0     *       160     47   408 384 1 11         1     11   207 201         160   47   408
1523506 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 212.0 13.0 10.0         9.0     17.0   140.0 121.0             47     46   261 212 13 10         9     17   140 121         47   46   261
1523525 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 278.0 13.0 12.0   1.0     23.0     15.0   155.0 187.0     8       45     65   342 278 13 12   1     23     15   155 187     8   45   65   342
1523544 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 269.0 5.0 11.0         15.0     26.0   188.0 138.0     *       36     77   326 269 5 11         15     26   188 138         36   77   326
1523563 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 388.0 4.0 18.0         23.0     22.0   250.0 205.0     21       52     65   455 388 4 18         23     22   250 205     21   52   65   455
1523582 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 856.0 32.0 26.0         93.0     18.0   542.0 483.0     11       155     133   1025 856 32 26         93     18   542 483     11   155   133   1025
1523601 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 1277.0 39.0 61.0         103.0     21.0   699.0 802.0     6       213     119   1501 1277 39 61         103     21   699 802     6   213   119   1501
1523620 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 364.0 6.0 17.0   1.0     24.0     14.0   231.0 195.0     8       60     75   426 364 6 17   1     24     14   231 195     8   60   75   426
1523639 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2020   pk_12_total 432.0 24.0 38.0         4.0     26.0   283.0 241.0     5       220     92   524 432 24 38         4     26   283 241     5   220   92   524
1523658 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2020   pk_12_total 366.0 10.0 30.0         4.0     18.0   209.0 219.0             157     81   428 366 10 30         4     18   209 219         157   81   428
1523677 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2020   pk_12_total 363.0 18.0 44.0   1.0     1.0     32.0   222.0 237.0     8       221     74   459 363 18 44   1     1     32   222 237     8   221   74   459
1523696 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2020   pk_12_total 338.0 22.0 41.0         5.0     22.0   216.0 212.0             196     83   428 338 22 41         5     22   216 212         196   83   428
1523715 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 270.0 33.0 28.0   2.0     1.0     39.0   195.0 178.0             222     46   373 270 33 28   2     1     39   195 178         222   46   373
1523734 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 102.0 21.0 25.0         2.0     19.0   96.0 73.0             101     59   169 102 21 25         2     19   96 73         101   59   169
1523753 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 406.0 55.0 45.0   2.0     13.0     24.0   264.0 281.0     *       349     92   545 406 55 45   2     13     24   264 281         349   92   545
1523772 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 313.0 43.0 31.0   1.0     5.0     33.0   220.0 206.0     *       306     82   426 313 43 31   1     5     33   220 206         306   82   426
1523791 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 241.0 39.0 36.0   1.0     11.0     32.0   168.0 192.0     19       179     55   360 241 39 36   1     11     32   168 192     19   179   55   360
1523810 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2020   pk_12_total 220.0 37.0 42.0         34.0     52.0   194.0 191.0     *       146     54   385 220 37 42         34     52   194 191         146   54   385
1523829 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   pk_12_total 296.0 20.0 27.0   2.0     48.0     26.0   210.0 209.0     42       125     51   419 296 20 27   2     48     26   210 209     42   125   51   419
1523848 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   pk_12_total 217.0 15.0 43.0   1.0     52.0     29.0   188.0 169.0     64       132     38   357 217 15 43   1     52     29   188 169     64   132   38   357
1523867 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 979.0 152.0 125.0   2.0     158.0     110.0   762.0 764.0     39       573     243   1526 979 152 125   2     158     110   762 764     39   573   243   1526
1523886 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   pk_12_total 181.0 16.0 18.0         31.0     23.0   129.0 140.0     *       93     57   269 181 16 18         31     23   129 140         93   57   269
1523905 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   pk_12_total 278.0 34.0 33.0   1.0     29.0     37.0   213.0 199.0     *       129     55   412 278 34 33   1     29     37   213 199         129   55   412
1523924 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2020   pk_12_total 520.0 66.0 83.0         90.0     56.0   395.0 420.0     33       352     139   815 520 66 83         90     56   395 420     33   352   139   815
1523943 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2020   pk_12_total 410.0 54.0 53.0         57.0     56.0   323.0 307.0             184     99   630 410 54 53         57     56   323 307         184   99   630
1523962 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2020   pk_12_total 78.0 105.0 16.0   3.0     95.0     8.0   162.0 143.0     39       113     47   305 78 105 16   3     95     8   162 143     39   113   47   305
1523981 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2020   pk_12_total 310.0 44.0 32.0   1.0     93.0     47.0   262.0 265.0     45       151     75   527 310 44 32   1     93     47   262 265     45   151   75   527
1524000 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2020   pk_12_total 345.0 26.0 28.0   1.0     166.0     25.0   282.0 309.0     45       102     69   591 345 26 28   1     166     25   282 309     45   102   69   591
1524019 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2020   pk_12_total 330.0 27.0 30.0   1.0     91.0     40.0   246.0 273.0     47       142     59   519 330 27 30   1     91     40   246 273     47   142   59   519
1524038 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2020   pk_12_total 351.0 15.0 17.0   1.0     114.0     31.0   266.0 263.0     50       143     61   529 351 15 17   1     114     31   266 263     50   143   61   529
1524057 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2020   pk_12_total 237.0 4.0 27.0   1.0     33.0     20.0   156.0 166.0     17       41     36   322 237 4 27   1     33     20   156 166     17   41   36   322
1524076 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2020   pk_12_total 285.0 40.0 28.0   2.0     106.0     41.0   290.0 212.0     49       134     94   502 285 40 28   2     106     41   290 212     49   134   94   502
1524095 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2020   pk_12_total 535.0 42.0 61.0   4.0     168.0     49.0   456.0 403.0     29       224     115   859 535 42 61   4     168     49   456 403     29   224   115   859
1524114 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 1309.0 185.0 111.0   5.0     350.0     78.0   1016.0 1022.0     31       542     308   2038 1309 185 111   5     350     78   1016 1022     31   542   308   2038
1524133 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2020   pk_12_total 213.0 29.0 8.0               13.0   117.0 146.0             154     57   263 213 29 8               13   117 146         154   57   263
1524152 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 255.0 9.0 13.0   1.0     14.0     13.0   159.0 146.0     5       98     56   305 255 9 13   1     14     13   159 146     5   98   56   305
1524171 NY Albany   school 3613080 10802060000   GUILDERLAND 361308004589 10802060003 GUILDERLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 330.0 23.0 24.0   1.0     121.0     18.0   266.0 251.0     70       95     50   517 330 23 24   1     121     18   266 251     70   95   50   517
1524190 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 329.0 31.0 28.0   1.0     106.0     30.0   266.0 259.0     71       131     48   525 329 31 28   1     106     30   266 259     71   131   48   525
1524209 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 1145.0 77.0 57.0   2.0     198.0     53.0   769.0 763.0     21       325     231   1532 1145 77 57   2     198     53   769 763     21   325   231   1532
1524228 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 336.0 5.0 17.0   1.0     45.0     11.0   221.0 194.0     20       69     31   415 336 5 17   1     45     11   221 194     20   69   31   415
1524247 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 783.0 45.0 42.0   1.0     158.0     43.0   539.0 533.0     25       242     152   1072 783 45 42   1     158     43   539 533     25   242   152   1072
1524266 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 378.0 13.0 6.0         67.0     11.0   231.0 244.0     16       62     37   475 378 13 6         67     11   231 244     16   62   37   475
1524285 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   pk_12_total 506.0 4.0 20.0         10.0     29.0   288.0 281.0     *       43     71   569 506 4 20         10     29   288 281         43   71   569
1524304 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 328.0 2.0 10.0   1.0     11.0     7.0   181.0 178.0             40     33   359 328 2 10   1     11     7   181 178         40   33   359
1524323 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 228.0 2.0 10.0         6.0     6.0   112.0 140.0             33     28   252 228 2 10         6     6   112 140         33   28   252
1537680 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000539 110101040001 CINCINNATUS ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   pk_12_total 189.0 1.0 5.0               1.0   98.0 98.0             123     24   196 189 1 5               1   98 98         123   24   196
1537699 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000540 110101040002 CINCINNATUS HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 154.0 1.0 1.0               2.0   74.0 84.0             78     40   158 154 1 1               2   74 84         78   40   158
1537718 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2020   pk_12_total 183.0                   1.0   81.0 103.0             111     34   184 183                   1   81 103         111   34   184
1537737 NY Cortland   school 3608460 110200010000   CORTLAND 360846000648 110200010003 FRANKLYN S BARRY PRIMARY SCHOOL public Regular School No Elementary KG 02 2020   pk_12_total 384.0 18.0 20.0   1.0     5.0     25.0   248.0 205.0     5       320     66   453 384 18 20   1     5     25   248 205     5   320   66   453
1537756 NY Cortland   school 3608460 110200010000   CORTLAND 360846000650 110200010009 RANDALL MIDDLE SCHOOL public Regular School No Middle 05 06 2020   pk_12_total 296.0 12.0 16.0         3.0     23.0   185.0 165.0             199     62   350 296 12 16         3     23   185 165         199   62   350
1537775 NY Cortland   school 3608460 110200010000   CORTLAND 360846000647 110200010010 FE SMITH INTERMEDIATE SCHOOL public Regular School No Elementary 03 04 2020   pk_12_total 261.0 9.0 14.0         1.0     24.0   154.0 155.0     *       203     41   309 261 9 14         1     24   154 155         203   41   309
1537794 NY Cortland   school 3608460 110200010000   CORTLAND 360846000646 110200010011 CORTLAND HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 565.0 29.0 29.0         8.0     35.0   322.0 344.0     *       330     81   666 565 29 29         8     35   322 344         330   81   666
1537813 NY Cortland   school 3608460 110200010000   CORTLAND 360846006612 110200010012 CORTLAND JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2020   pk_12_total 305.0 7.0 15.0         1.0     26.0   183.0 171.0     *       197     57   354 305 7 15         1     26   183 171         197   57   354
1537832 NY Cortland   school 3618840 110304040000   MCGRAW 361884001710 110304040001 MCGRAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   pk_12_total 243.0   2.0               7.0   127.0 125.0             161     42   252 243   2               7   127 125         161   42   252
1537851 NY Cortland   school 3618840 110304040000   MCGRAW 361884001711 110304040002 MCGRAW SECONDARY SCHOOL public Regular School No High 06 12 2020   pk_12_total 278.0 1.0 7.0         2.0     5.0   137.0 156.0             158     61   293 278 1 7         2     5   137 156         158   61   293
1537870 NY Cortland   school 3614640 110701060000   HOMER 361464001217 110701060001 HOMER SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   pk_12_total 560.0 4.0 10.0         3.0     13.0   318.0 272.0     5       233     79   590 560 4 10         3     13   318 272     5   233   79   590
1537889 NY Cortland   school 3614640 110701060000   HOMER 361464001214 110701060002 HOMER ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2020   pk_12_total 409.0   11.0         3.0     11.0   224.0 210.0     8       201     31   434 409   11         3     11   224 210     8   201   31   434
1537908 NY Cortland   school 3614640 110701060000   HOMER 361464001215 110701060003 HOMER INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2020   pk_12_total 363.0 2.0 14.0         3.0     17.0   206.0 193.0     5       196     35   399 363 2 14         3     17   206 193     5   196   35   399
1537927 NY Cortland   school 3614640 110701060000   HOMER 361464003477 110701060006 HOMER JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2020   pk_12_total 441.0 2.0 20.0         2.0     9.0   231.0 243.0     5       220     62   474 441 2 20         2     9   231 243     5   220   62   474

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