Data source: Big Local News · About: Big Local

90,079 rows where state = "NY" and year = 2021 sorted by district_state_id descending

View and edit SQL

year

  • 2021 · 90,079
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
1447283 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_1 52.0   0.0         0.0     2.0   32.0 22.0             18     6   54 52   0         0     2   32 22         18   6   54
1447284 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_10 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447285 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_11 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447286 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_12 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447287 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_2 61.0   0.0         0.0     2.0   32.0 31.0             24     6   63 61   0         0     2   32 31         24   6   63
1447288 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_3 50.0   0.0         0.0     0.0   31.0 19.0             19     *   50 50   0         0     0   31 19         19       50
1447289 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_4 52.0   1.0         0.0     1.0   25.0 29.0             21     7   54 52   1         0     1   25 29         21   7   54
1447290 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_5 57.0   1.0         0.0     1.0   27.0 32.0             20     12   59 57   1         0     1   27 32         20   12   59
1447291 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_6 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447292 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447293 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_8 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447294 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_9 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447295 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 55.0   1.0         1.0     1.0   32.0 26.0             20     9   58 55   1         1     1   32 26         20   9   58
1447296 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_half_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447297 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pk_12_total 365.0   4.0         1.0     8.0   196.0 182.0             133     49   378 365   4         1     8   196 182         133   49   378
1447298 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pre_kindergarten_full_day 38.0   1.0         0.0     1.0   17.0 23.0             11     *   40 38   1         0     1   17 23         11       40
1447299 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pre_kindergarten_half_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447300 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   ungraded_elementary 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447301 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   ungraded_secondary 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447302 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_1 45.0   0.0   0.0           2.0   27.0 20.0             13     *   47 45   0   0           2   27 20         13       47
1447303 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_10 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1447304 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_11 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1447305 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_12 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1447306 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_2 51.0   1.0   0.0           2.0   34.0 20.0             21     *   54 51   1   0           2   34 20         21       54
1447307 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_3 50.0   0.0   1.0           1.0   27.0 25.0             17     *   52 50   0   1           1   27 25         17       52
1447308 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_4 63.0   0.0   0.0           0.0   22.0 41.0             22     13   63 63   0   0           0   22 41         22   13   63
1447309 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_5 66.0   0.0   0.0           1.0   28.0 39.0             40     13   67 66   0   0           1   28 39         40   13   67
1447310 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_6 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1447311 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_7 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1447312 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_8 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1447313 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_9 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1447314 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_full_day 56.0   0.0   0.0           2.0   36.0 22.0             18     5   58 56   0   0           2   36 22         18   5   58
1447315 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   kindergarten_half_day 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1447316 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pk_12_total 354.0   1.0   1.0           8.0   186.0 178.0             139     43   364 354   1   1           8   186 178         139   43   364
1447317 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pre_kindergarten_full_day 20.0   0.0   0.0           0.0   10.0 10.0             *     *   20 20   0   0           0   10 10                 20
1447318 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   pre_kindergarten_half_day 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1447319 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   ungraded_elementary 3.0   0.0   0.0           0.0   2.0 1.0             *     *   3 3   0   0           0   2 1                 3
1447320 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   ungraded_secondary 0.0   0.0   0.0           0.0   0.0 0.0             0     0   0 0   0   0           0   0 0         0   0   0
1447321 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447322 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_10 92.0 0.0 1.0         0.0     0.0   51.0 42.0             *     16   93 92 0 1         0     0   51 42             16   93
1447323 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_11 92.0 0.0 1.0         0.0     0.0   49.0 44.0             39     14   93 92 0 1         0     0   49 44         39   14   93
1447324 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_12 96.0 2.0 2.0         0.0     0.0   48.0 52.0             35     *   100 96 2 2         0     0   48 52         35       100
1447325 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447326 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_3 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447327 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447328 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447329 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447330 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447331 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447332 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   grade_9 104.0 0.0 1.0         1.0     3.0   54.0 55.0             37     14   109 104 0 1         1     3   54 55         37   14   109
1447333 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447334 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447335 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   pk_12_total 388.0 2.0 5.0         1.0     3.0   205.0 194.0             150     58   399 388 2 5         1     3   205 194         150   58   399
1447336 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   pre_kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447337 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   pre_kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447338 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1447339 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   ungraded_secondary 4.0 0.0 0.0         0.0     0.0   3.0 1.0             *     *   4 4 0 0         0     0   3 1                 4
1447340 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_1 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447341 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_10 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447342 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_11 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447343 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_12 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447344 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_2 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447345 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_3 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447346 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_4 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447347 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_5 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447348 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_6 111.0   1.0         0.0     5.0   58.0 59.0             54     19   117 111   1         0     5   58 59         54   19   117
1447349 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_7 101.0   2.0         1.0     2.0   62.0 44.0             *     *   106 101   2         1     2   62 44                 106
1447350 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_8 114.0   1.0         0.0     2.0   58.0 59.0             51     21   117 114   1         0     2   58 59         51   21   117
1447351 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_9 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447352 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   kindergarten_full_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447353 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   kindergarten_half_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447354 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   pk_12_total 327.0   4.0         1.0     9.0   178.0 163.0             149     59   341 327   4         1     9   178 163         149   59   341
1447355 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   pre_kindergarten_full_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447356 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   pre_kindergarten_half_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447357 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   ungraded_elementary 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1447358 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   ungraded_secondary 1.0   0.0         0.0     0.0   0.0 1.0             *     *   1 1   0         0     0   0 1                 1
1447188 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_1 52.0 3.0 0.0         5.0     2.0   31.0 31.0     *       *     8   62 52 3 0         5     2   31 31             8   62
1447189 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_10 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447190 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_11 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447191 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_12 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447192 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_2 54.0 8.0 1.0         0.0     2.0   39.0 26.0     *       34     18   65 54 8 1         0     2   39 26         34   18   65
1447193 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_3 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447194 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447195 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447196 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447197 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447198 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447199 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447200 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   kindergarten_full_day 59.0 4.0 0.0         3.0     1.0   31.0 36.0     *       29     *   67 59 4 0         3     1   31 36         29       67
1447201 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447202 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   pk_12_total 180.0 15.0 1.0         8.0     5.0   111.0 98.0     *       93     35   209 180 15 1         8     5   111 98         93   35   209
1447203 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   pre_kindergarten_full_day 15.0 0.0 0.0         0.0     0.0   10.0 5.0     *       *     *   15 15 0 0         0     0   10 5                 15
1447204 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   pre_kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447205 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447206 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 THOMAS E GLASGOW ELEMENTARY public Regular School No Elementary PK 02 2021   ungraded_secondary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
1447207 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_1 52.0 6.0 4.0   0.0     1.0     5.0   33.0 35.0     *       32     *   68 52 6 4   0     1     5   33 35         32       68
1447208 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_10 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1447209 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_11 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1447210 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_12 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1447211 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_2 40.0 4.0 2.0   0.0     0.0     8.0   30.0 24.0     *       34     11   54 40 4 2   0     0     8   30 24         34   11   54

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