Data source: Big Local News · About: Big Local

33,145 rows where grade = "pk_12_total" and state = "NY" sorted by district_state_id

View and edit SQL

year

grade

  • pk_12_total · 33,045
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
1433199 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2021   pk_12_total 122.0 302.0 133.0   2.0     42.0     45.0   328.0 318.0     72       443     111   646 122 302 133   2     42     45   328 318     72   443   111   646
1433218 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2021   pk_12_total 15.0 175.0 50.0   1.0     7.0     15.0   131.0 132.0     *       235     46   263 15 175 50   1     7     15   131 132         235   46   263
1433237 NY Albany   school 3602460 10100010000   ALBANY 360246006700 10100010051 NORTH ALBANY ACADEMY MIDDLE SCHOOL public Regular School No Middle 06 07 2021   pk_12_total 17.0 121.0 27.0         14.0     21.0   104.0 96.0     32       183     27   200 17 121 27         14     21   104 96     32   183   27   200
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
2049389 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 182.0 58.0 37.0   1.0     24.0     27.0   187.0 142.0     18       115     27   329 182 58 37   1     24     27   187 142     18   115   27   329
2049408 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 74.0 143.0 77.0   1.0     35.0     46.0   188.0 188.0     43       271     46   376 74 143 77   1     35     46   188 188     43   271   46   376
2049427 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 53.0 102.0 186.0   2.0     51.0     24.0   216.0 202.0     109       318     28   418 53 102 186   2     51     24   216 202     109   318   28   418
2049446 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 234.0 98.0 75.0   2.0     48.0     44.0   267.0 234.0     30       219     73   501 234 98 75   2     48     44   267 234     30   219   73   501
2049465 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2018   pk_12_total 29.0 184.0 41.0         12.0     23.0   165.0 124.0     40       252     58   289 29 184 41         12     23   165 124     40   252   58   289
2049484 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2018   pk_12_total 77.0 252.0 94.0   2.0     42.0     37.0   239.0 265.0     32       305     75   504 77 252 94   2     42     37   239 265     32   305   75   504
2049503 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pk_12_total 156.0 76.0 39.0   1.0     34.0     19.0   184.0 141.0     41       154     45   325 156 76 39   1     34     19   184 141     41   154   45   325
2049522 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2018   pk_12_total 43.0 172.0 74.0   2.0     115.0     31.0   240.0 197.0     58       320     27   437 43 172 74   2     115     31   240 197     58   320   27   437
2049541 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   pk_12_total 52.0 259.0 112.0   2.0     50.0     39.0   286.0 228.0     82       464     71   514 52 259 112   2     50     39   286 228     82   464   71   514
2049560 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2018   pk_12_total 167.0 295.0 111.0   3.0     71.0     29.0   348.0 328.0     90       458     109   676 167 295 111   3     71     29   348 328     90   458   109   676
2049579 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2018   pk_12_total 565.0 1339.0 404.0   11.0     228.0     74.0   1277.0 1344.0     301       1679     345   2621 565 1339 404   11     228     74   1277 1344     301   1679   345   2621
2049598 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 15.0 217.0 59.0   1.0     4.0     18.0   180.0 134.0     15       291     55   314 15 217 59   1     4     18   180 134     15   291   55   314
2049617 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2018   pk_12_total 20.0 151.0 49.0   1.0     17.0     40.0   153.0 125.0     47       249     64   278 20 151 49   1     17     40   153 125     47   249   64   278
2049636 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2018   pk_12_total 32.0 205.0 82.0   1.0     24.0     35.0   184.0 195.0     52       337     29   379 32 205 82   1     24     35   184 195     52   337   29   379
2049655 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2018   pk_12_total 131.0 353.0 113.0   1.0     51.0     29.0   327.0 351.0     67       482     97   678 131 353 113   1     51     29   327 351     67   482   97   678
2049674 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2018   pk_12_total 45.0 311.0 71.0   1.0     19.0     26.0   247.0 226.0     53       429     59   473 45 311 71   1     19     26   247 226     53   429   59   473
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
759482 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   pk_12_total 423.0 8.0 28.0   1.0     3.0     20.0   254.0 229.0             221     80   483 423 8 28   1     3     20   254 229         221   80   483
759501 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No 3.0 09 12 2015   pk_12_total 342.0 13.0 15.0         4.0     20.0   190.0 204.0             141     42   394 342 13 15         4     20   190 204         141   42   394
759520 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   pk_12_total 225.0 7.0 13.0         4.0     9.0   123.0 135.0             97     48   258 225 7 13         4     9   123 135         97   48   258
956242 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   pk_12_total 411.0 3.0 24.0   1.0     4.0     22.0   246.0 219.0     9       221     93   465 411 3 24   1     4     22   246 219     9   221   93   465
956261 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 289.0 7.0 16.0         5.0     17.0   164.0 170.0     5       133     52   334 289 7 16         5     17   164 170     5   133   52   334
956280 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 223.0 2.0 15.0         2.0     5.0   121.0 126.0     *       92     54   247 223 2 15         2     5   121 126         92   54   247
1046112 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   pk_12_total 425.0 4.0 24.0   1.0     3.0     24.0   259.0 222.0             227     86   481 425 4 24   1     3     24   259 222         227   86   481
1046131 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No 3.0 09 12 2016   pk_12_total 303.0 12.0 11.0         6.0     23.0   173.0 182.0             136     45   355 303 12 11         6     23   173 182         136   45   355
1046150 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   pk_12_total 203.0 4.0 14.0         3.0     7.0   109.0 122.0             82     47   231 203 4 14         3     7   109 122         82   47   231
1447449 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pk_12_total 333.0 2.0 27.0   1.0     1.0     13.0   192.0 185.0     7       162     50   377 333 2 27   1     1     13   192 185     7   162   50   377
1447468 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2021   pk_12_total 275.0 7.0 24.0         4.0     9.0   161.0 158.0     *       115     53   319 275 7 24         4     9   161 158         115   53   319
1447487 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2021   pk_12_total 192.0 1.0 11.0         1.0     17.0   114.0 108.0     *       91     39   222 192 1 11         1     17   114 108         91   39   222
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
2063582 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   pk_12_total 415.0 3.0 26.0   1.0     1.0     20.0   247.0 219.0     11       228     89   466 415 3 26   1     1     20   247 219     11   228   89   466
2063601 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2018   pk_12_total 290.0 7.0 18.0         5.0     14.0   167.0 167.0     5       126     55   334 290 7 18         5     14   167 167     5   126   55   334
2063620 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2018   pk_12_total 229.0 4.0 12.0         4.0     8.0   132.0 125.0     *       110     50   257 229 4 12         4     8   132 125         110   50   257
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
745498 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes 1.0 KG 04 2015   pk_12_total 4.0 239.0 39.0         4.0     2.0   288.0               287     10   288 4 239 39         4     2   288           287   10   288
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
1032071 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes 1.0 KG 04 2016   pk_12_total 8.0 240.0 36.0         4.0     1.0   289.0               206     9   289 8 240 36         4     1   289           206   9   289
1433256 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2021   pk_12_total 13.0 160.0 47.0         21.0     17.0   258.0       23       211     22   258 13 160 47         21     17   258       23   211   22   258
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
2049693 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2018   pk_12_total 7.0 234.0 56.0         7.0     15.0   319.0       13       297     13   319 7 234 56         7     15   319       13   297   13   319
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
745517 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes 1.0 KG 04 2015   pk_12_total 6.0 207.0 49.0         11.0     1.0     274.0             274     6   274 6 207 49         11     1     274         274   6   274
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
1032090 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes 1.0 KG 04 2016   pk_12_total 3.0 201.0 54.0         10.0     16.0   2.0 282.0             215     *   284 3 201 54         10     16   2 282         215       284
1433275 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2021   pk_12_total 10.0 178.0 47.0   1.0     32.0     13.0     281.0     38       240     9   281 10 178 47   1     32     13     281     38   240   9   281
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
2049712 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2018   pk_12_total 8.0 235.0 60.0         14.0     21.0     338.0     18       302     *   338 8 235 60         14     21     338     18   302       338
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
745536 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes 2.0 05 08 2015   pk_12_total 10.0 244.0 28.0   2.0     2.0     3.0   116.0 173.0             231         289 10 244 28   2     2     3   116 173         231       289
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
1032109 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes 2.0 05 08 2016   pk_12_total 12.0 254.0 30.0   5.0     1.0     3.0   128.0 177.0             205     15   305 12 254 30   5     1     3   128 177         205   15   305
1433294 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   pk_12_total 8.0 717.0 101.0   3.0     5.0     24.0   412.0 446.0     10       630     33   858 8 717 101   3     5     24   412 446     10   630   33   858
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
2049731 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle KG 08 2018   pk_12_total 14.0 412.0 43.0   1.0     11.0     10.0   225.0 266.0             438     11   491 14 412 43   1     11     10   225 266         438   11   491
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
745555 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2015   pk_12_total 4.0 287.0 63.0   1.0     1.0     33.0   186.0 203.0             368     9   389 4 287 63   1     1     33   186 203         368   9   389
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
1032128 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   pk_12_total 7.0 344.0 39.0   3.0     2.0         200.0 195.0             359     13   395 7 344 39   3     2         200 195         359   13   395
1433313 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2021   pk_12_total 14.0 271.0 63.0   2.0           25.0   169.0 206.0     10       321     7   375 14 271 63   2           25   169 206     10   321   7   375
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
2049750 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2018   pk_12_total 3.0 292.0 54.0         2.0     14.0   176.0 189.0     9       335         365 3 292 54         2     14   176 189     9   335       365
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

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