Data source: Big Local News · About: Big Local

4,719 rows where grade = "pk_12_total", state = "NY" and year = 2019 sorted by district_state_id

View and edit SQL

year

  • 2019 · 4,719

grade

  • pk_12_total · 4,719
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
2153186 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   pk_12_total 16.0 10.0 12.0                   37.0 1.0             23     25   38 16 10 12                   37 1         23   25   38
2153205 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   pk_12_total 24.0 11.0 7.0               4.0   37.0 9.0             31     21   46 24 11 7               4   37 9         31   21   46
2153224 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   pk_12_total 521.0 6.0 75.0   1.0     2.0     29.0   329.0 305.0     15       370     104   634 521 6 75   1     2     29   329 305     15   370   104   634
2153243 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 501.0 15.0 77.0   1.0     2.0     50.0   332.0 314.0     17       435     56   646 501 15 77   1     2     50   332 314     17   435   56   646
2153262 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 229.0   20.0         3.0     11.0   138.0 125.0     5       120     46   263 229   20         3     11   138 125     5   120   46   263
2153281 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   pk_12_total 225.0 1.0 23.0   1.0     2.0     10.0   142.0 120.0     *       108     46   262 225 1 23   1     2     10   142 120         108   46   262
2139107 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   pk_12_total 157.0 61.0 38.0         25.0     36.0   182.0 135.0     15       105     28   317 157 61 38         25     36   182 135     15   105   28   317
2139126 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   pk_12_total 63.0 160.0 81.0   2.0     27.0     36.0   197.0 172.0     44       274     49   369 63 160 81   2     27     36   197 172     44   274   49   369
2139145 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2019   pk_12_total 62.0 97.0 186.0         48.0     26.0   215.0 204.0     103       326     25   419 62 97 186         48     26   215 204     103   326   25   419
2139164 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 213.0 102.0 67.0   2.0     47.0     37.0   245.0 223.0     40       203     73   468 213 102 67   2     47     37   245 223     40   203   73   468
2139183 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2019   pk_12_total 27.0 157.0 33.0         12.0     17.0   151.0 95.0     38       221     55   246 27 157 33         12     17   151 95     38   221   55   246
2139202 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   pk_12_total 65.0 256.0 95.0   1.0     35.0     48.0   243.0 257.0     21       323     75   500 65 256 95   1     35     48   243 257     21   323   75   500
2139221 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 141.0 83.0 43.0         29.0     13.0   168.0 141.0     33       141     46   309 141 83 43         29     13   168 141     33   141   46   309
2139240 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2019   pk_12_total 40.0 175.0 71.0   2.0     112.0     37.0   242.0 195.0     61       319     49   437 40 175 71   2     112     37   242 195     61   319   49   437
2139259 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 38.0 258.0 145.0   3.0     44.0     33.0   291.0 230.0     70       476     100   521 38 258 145   3     44     33   291 230     70   476   100   521
2139278 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   pk_12_total 163.0 258.0 146.0   2.0     83.0     38.0   374.0 316.0     80       460     127   690 163 258 146   2     83     38   374 316     80   460   127   690
2139297 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 559.0 1284.0 393.0   7.0     233.0     72.0   1265.0 1283.0     309       1677     355   2548 559 1284 393   7     233     72   1265 1283     309   1677   355   2548
2139316 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 12.0 185.0 59.0         6.0     21.0   173.0 110.0     11       251     61   283 12 185 59         6     21   173 110     11   251   61   283
2139335 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2019   pk_12_total 23.0 147.0 48.0   1.0     23.0     28.0   140.0 130.0     51       247     62   270 23 147 48   1     23     28   140 130     51   247   62   270
2139354 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2019   pk_12_total 23.0 184.0 70.0   1.0     18.0     28.0   156.0 168.0     37       305     39   324 23 184 70   1     18     28   156 168     37   305   39   324
2139373 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   pk_12_total 131.0 349.0 104.0   1.0     49.0     39.0   322.0 351.0     56       449     93   673 131 349 104   1     49     39   322 351     56   449   93   673
2139392 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2019   pk_12_total 49.0 317.0 80.0         23.0     31.0   245.0 255.0     57       455     62   500 49 317 80         23     31   245 255     57   455   62   500
2153300 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   pk_12_total 408.0 3.0 27.0   1.0     1.0     21.0   234.0 227.0     12       235     76   461 408 3 27   1     1     21   234 227     12   235   76   461
2153319 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 270.0 9.0 21.0         4.0     13.0   161.0 156.0     *       113     63   317 270 9 21         4     13   161 156         113   63   317
2153338 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2019   pk_12_total 213.0 2.0 13.0         3.0     11.0   128.0 114.0     *       100     40   242 213 2 13         3     11   128 114         100   40   242
2139411 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2019   pk_12_total 13.0 215.0 61.0         15.0     20.0   323.0 1.0     20       306     21   324 13 215 61         15     20   323 1     20   306   21   324
2139430 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2019   pk_12_total 11.0 206.0 70.0         19.0     16.0     322.0     23       267     9   322 11 206 70         19     16     322     23   267   9   322
2139449 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle KG 08 2019   pk_12_total 9.0 501.0 66.0   3.0     7.0     18.0   331.0 273.0     16       441     23   604 9 501 66   3     7     18   331 273     16   441   23   604
2139468 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   pk_12_total 9.0 249.0 55.0               20.0   150.0 183.0     13       282     7   333 9 249 55               20   150 183     13   282   7   333
2139487 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   pk_12_total 5.0 590.0 44.0         3.0     5.0   285.0 362.0     9       573     6   647 5 590 44         3     5   285 362     9   573   6   647
2139506 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 09 12 2019   pk_12_total 7.0 236.0 60.0   1.0     3.0     31.0   338.0               220     19   338 7 236 60   1     3     31   338           220   19   338
2139525 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2019   pk_12_total 38.0 222.0 61.0   3.0     14.0     15.0     353.0     36       304     21   353 38 222 61   3     14     15     353     36   304   21   353
2153357 NY Columbia   school 3614940 101300010000   HUDSON 361494001249 101300010001 HUDSON HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 210.0 122.0 52.0         83.0     19.0   245.0 241.0     41       326     85   486 210 122 52         83     19   245 241     41   326   85   486
2153376 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH ELEMENTARY public Regular School No Elementary PK 05 2019   pk_12_total 333.0 145.0 156.0   1.0     89.0     121.0   426.0 419.0     96       611     133   845 333 145 156   1     89     121   426 419     96   611   133   845
2153395 NY Columbia   school 3614940 101300010000   HUDSON 361494006579 101300010004 HUDSON JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2019   pk_12_total 164.0 73.0 63.0   1.0     46.0     34.0   185.0 196.0     35       284     77   381 164 73 63   1     46     34   185 196     35   284   77   381
2153414 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   pk_12_total 412.0 5.0 73.0   1.0     5.0     24.0   267.0 253.0     53       205     65   520 412 5 73   1     5     24   267 253     53   205   65   520
2153433 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001279 101401040005 ICHABOD CRANE SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 473.0 14.0 21.0         14.0     6.0   273.0 255.0     12       140     77   528 473 14 21         14     6   273 255     12   140   77   528
2153452 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No Middle 04 08 2019   pk_12_total 590.0 11.0 47.0         9.0     18.0   353.0 322.0     31       219     101   675 590 11 47         9     18   353 322     31   219   101   675
2153471 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 209.0 2.0 6.0               8.0   108.0 117.0             116     35   225 209 2 6               8   108 117         116   35   225
2153490 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2019   pk_12_total 192.0 2.0 6.0               7.0   109.0 98.0             86     26   207 192 2 6               7   109 98         86   26   207
2139544 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2019   pk_12_total 326.0 3.0 8.0   1.0     4.0     5.0   179.0 168.0             135     59   347 326 3 8   1     4     5   179 168         135   59   347
2139563 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2019   pk_12_total 388.0 3.0 8.0         2.0     7.0   216.0 192.0             168     47   408 388 3 8         2     7   216 192         168   47   408
2139582 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 233.0 11.0 10.0         8.0     17.0   148.0 131.0             52     54   279 233 11 10         8     17   148 131         52   54   279
2139601 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 292.0 16.0 11.0         31.0     16.0   182.0 184.0     17       62     66   366 292 16 11         31     16   182 184     17   62   66   366
2139620 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 262.0 6.0 7.0         19.0     20.0   179.0 135.0             37     78   314 262 6 7         19     20   179 135         37   78   314
2139639 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 394.0 4.0 16.0         34.0     21.0   250.0 219.0     18       61     59   469 394 4 16         34     21   250 219     18   61   59   469
2139658 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   pk_12_total 883.0 30.0 26.0         80.0     16.0   529.0 506.0     10       160     143   1035 883 30 26         80     16   529 506     10   160   143   1035
2139677 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 1327.0 40.0 61.0         106.0     25.0   729.0 830.0     12       205     117   1559 1327 40 61         106     25   729 830     12   205   117   1559
2139696 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 357.0 9.0 15.0   1.0     24.0     12.0   219.0 199.0     5       67     79   418 357 9 15   1     24     12   219 199     5   67   79   418
2139715 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2019   pk_12_total 469.0 30.0 35.0         5.0     18.0   283.0 274.0     5       237     96   557 469 30 35         5     18   283 274     5   237   96   557
2139734 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2019   pk_12_total 368.0 13.0 26.0         6.0     16.0   199.0 230.0             163     77   429 368 13 26         6     16   199 230         163   77   429
2139753 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   pk_12_total 361.0 21.0 50.0   1.0     2.0     33.0   233.0 235.0     *       239     84   468 361 21 50   1     2     33   233 235         239   84   468
2139772 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2019   pk_12_total 329.0 16.0 39.0         4.0     27.0   219.0 196.0             191     74   415 329 16 39         4     27   219 196         191   74   415
2139791 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 274.0 38.0 31.0         1.0     40.0   204.0 180.0             247     49   384 274 38 31         1     40   204 180         247   49   384
2139810 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 112.0 17.0 23.0         4.0     19.0   99.0 76.0             111     53   175 112 17 23         4     19   99 76         111   53   175
2139829 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 412.0 56.0 33.0   1.0     12.0     25.0   278.0 261.0     *       368     100   539 412 56 33   1     12     25   278 261         368   100   539
2139848 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   pk_12_total 297.0 45.0 25.0   2.0     4.0     34.0   200.0 207.0     *       315     76   407 297 45 25   2     4     34   200 207         315   76   407
2139867 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 261.0 31.0 39.0   1.0     10.0     28.0   189.0 181.0     14       223     60   370 261 31 39   1     10     28   189 181     14   223   60   370
2139886 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2019   pk_12_total 231.0 38.0 45.0         31.0     55.0   191.0 209.0             152     49   400 231 38 45         31     55   191 209         152   49   400
2139905 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   pk_12_total 286.0 19.0 27.0         40.0     24.0   196.0 200.0     27       102     45   396 286 19 27         40     24   196 200     27   102   45   396
2139924 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   pk_12_total 217.0 14.0 31.0   1.0     48.0     30.0   172.0 169.0     48       135     30   341 217 14 31   1     48     30   172 169     48   135   30   341
2139943 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 1008.0 139.0 117.0   2.0     146.0     98.0   754.0 756.0     29       561     227   1510 1008 139 117   2     146     98   754 756     29   561   227   1510
2139962 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   pk_12_total 196.0 26.0 23.0         31.0     22.0   153.0 145.0             116     61   298 196 26 23         31     22   153 145         116   61   298
2139981 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   pk_12_total 296.0 32.0 38.0   1.0     27.0     38.0   232.0 200.0             135     59   432 296 32 38   1     27     38   232 200         135   59   432
2140000 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 09 2019   pk_12_total 524.0 66.0 59.0   1.0     82.0     64.0   379.0 417.0     21       339     138   796 524 66 59   1     82     64   379 417     21   339   138   796
2140019 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2019   pk_12_total 406.0 41.0 46.0         63.0     51.0   307.0 300.0             182     89   607 406 41 46         63     51   307 300         182   89   607
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
2140057 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 302.0 40.0 26.0   2.0     80.0     37.0   232.0 255.0     47       148     68   487 302 40 26   2     80     37   232 255     47   148   68   487
2140076 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 329.0 20.0 36.0   1.0     168.0     25.0   293.0 286.0     44       95     60   579 329 20 36   1     168     25   293 286     44   95   60   579
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
2140114 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 357.0 18.0 16.0   1.0     113.0     36.0   263.0 278.0     48       152     66   541 357 18 16   1     113     36   263 278     48   152   66   541
2140133 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 247.0 7.0 27.0   2.0     32.0     20.0   151.0 184.0     22       43     34   335 247 7 27   2     32     20   151 184     22   43   34   335
2140152 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 271.0 32.0 19.0   2.0     86.0     36.0   242.0 204.0     40       120     87   446 271 32 19   2     86     36   242 204     40   120   87   446
2140171 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   pk_12_total 549.0 48.0 55.0   2.0     179.0     53.0   470.0 416.0     36       235     127   886 549 48 55   2     179     53   470 416     36   235   127   886
2140190 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 1361.0 162.0 112.0   5.0     330.0     53.0   994.0 1029.0     42       533     297   2023 1361 162 112   5     330     53   994 1029     42   533   297   2023
2140209 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2019   pk_12_total 225.0 17.0 7.0         2.0     16.0   116.0 151.0             157     56   267 225 17 7         2     16   116 151         157   56   267
2140228 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 243.0 8.0 6.0         16.0     11.0   146.0 138.0     7       94     55   284 243 8 6         16     11   146 138     7   94   55   284
2140247 NY Albany   school 3613080 10802060000   GUILDERLAND 361308004589 10802060003 GUILDERLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 353.0 23.0 23.0         129.0     17.0   286.0 259.0     69       96     51   545 353 23 23         129     17   286 259     69   96   51   545
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
2140285 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 1173.0 59.0 56.0   1.0     182.0     53.0   779.0 745.0     16       294     250   1524 1173 59 56   1     182     53   779 745     16   294   250   1524
2140304 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 328.0 10.0 14.0         38.0     14.0   217.0 187.0     12       68     37   404 328 10 14         38     14   217 187     12   68   37   404
2140323 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2019   pk_12_total 813.0 44.0 54.0   1.0     136.0     40.0   527.0 561.0     20       248     150   1088 813 44 54   1     136     40   527 561     20   248   150   1088
2140342 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 377.0 13.0 8.0         52.0     7.0   231.0 226.0     13       61     40   457 377 13 8         52     7   231 226     13   61   40   457
2140361 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   pk_12_total 467.0 1.0 19.0         12.0     28.0   250.0 277.0     *       42     60   527 467 1 19         12     28   250 277         42   60   527
2140380 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 334.0 2.0 6.0   2.0     13.0     3.0   186.0 174.0     *       29     36   360 334 2 6   2     13     3   186 174         29   36   360
2140399 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   pk_12_total 249.0 2.0 10.0         5.0     7.0   137.0 136.0     *       32     35   273 249 2 10         5     7   137 136         32   35   273
2153509 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000539 110101040001 CINCINNATUS ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   pk_12_total 206.0 1.0 3.0               2.0   102.0 110.0             140     33   212 206 1 3               2   102 110         140   33   212
2153528 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000540 110101040002 CINCINNATUS HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 135.0 1.0 1.0               1.0   70.0 68.0             65     29   138 135 1 1               1   70 68         65   29   138
2153547 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   pk_12_total 179.0                   1.0   75.0 105.0             104     38   180 179                   1   75 105         104   38   180
2153566 NY Cortland   school 3608460 110200010000   CORTLAND 360846000648 110200010003 FRANKLYN S BARRY SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 287.0 10.0 10.0         3.0     18.0   167.0 161.0             210     46   328 287 10 10         3     18   167 161         210   46   328
2153585 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 109.0 1.0 1.0               2.0   63.0 50.0             56     11   113 109 1 1               2   63 50         56   11   113
2153604 NY Cortland   school 3608460 110200010000   CORTLAND 360846000645 110200010008 ALTON B PARKER SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 203.0 5.0 5.0               11.0   115.0 109.0             140     29   224 203 5 5               11   115 109         140   29   224
2153623 NY Cortland   school 3608460 110200010000   CORTLAND 360846000650 110200010009 RANDALL SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 215.0 9.0 18.0         5.0     20.0   145.0 122.0     10       194     43   267 215 9 18         5     20   145 122     10   194   43   267
2153642 NY Cortland   school 3608460 110200010000   CORTLAND 360846000647 110200010010 F E SMITH SCHOOL public Regular School No Elementary KG 06 2019   pk_12_total 194.0 11.0 16.0         3.0     25.0   134.0 115.0             148     31   249 194 11 16         3     25   134 115         148   31   249
2153661 NY Cortland   school 3608460 110200010000   CORTLAND 360846000646 110200010011 CORTLAND HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 613.0 27.0 29.0   1.0     8.0     27.0   360.0 345.0     *       368     87   705 613 27 29   1     8     27   360 345         368   87   705
2153680 NY Cortland   school 3608460 110200010000   CORTLAND 360846006612 110200010012 CORTLAND JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   pk_12_total 297.0 11.0 19.0         1.0     25.0   179.0 174.0             267     47   353 297 11 19         1     25   179 174         267   47   353
2153699 NY Cortland   school 3618840 110304040000   MCGRAW 361884001710 110304040001 MCGRAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   pk_12_total 256.0   3.0               12.0   144.0 127.0             182     49   271 256   3               12   144 127         182   49   271
2153718 NY Cortland   school 3618840 110304040000   MCGRAW 361884001711 110304040002 MCGRAW SECONDARY SCHOOL public Regular School No High 06 12 2019   pk_12_total 283.0 1.0 6.0         2.0     1.0   136.0 157.0             161     60   293 283 1 6         2     1   136 157         161   60   293
2153737 NY Cortland   school 3614640 110701060000   HOMER 361464001217 110701060001 HOMER SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   pk_12_total 579.0 6.0 6.0         5.0     12.0   331.0 277.0     *       246     86   608 579 6 6         5     12   331 277         246   86   608
2153756 NY Cortland   school 3614640 110701060000   HOMER 361464001214 110701060002 HOMER ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   pk_12_total 379.0 2.0 13.0         3.0     14.0   226.0 185.0     7       184     28   411 379 2 13         3     14   226 185     7   184   28   411

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