Data source: Big Local News · About: Big Local

5,859 rows where grade = "k_12_total" and state = "OR" sorted by district

View and edit SQL

year

grade

  • k_12_total · 5,859
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
656780 OR     school 4100990 2063   Adel SD 21 410099000524 498 Adel Elementary School   Regular School No Middle 04 08 2021   k_12_total 11 0 0   1 0     0   0                               11 0 0   1 0     0   0                        
916638 OR     school 4100990 2063   Adel SD 21 410099000524 498 Adel Elementary School   Regular School No Middle 04 08 2020   k_12_total 5 0 0   2 0     0   0                               5 0 0   2 0     0   0                        
1190473 OR     school 4100990 2063   Adel SD 21 410099000524 498 Adel Elementary School   Regular School No Middle 04 08 2018   k_12_total 6.0 0.0 1.0   1.0 0.0     0.0   0.0                               6 0 1   1 0     0   0                        
1705288 OR     school 4100990 2063   Adel SD 21 410099000524 498 Adel Elementary School   Regular School No Elementary 04 08 2017   k_12_total 8.0 0.0 0.0     0.0     0.0   0.0                               8 0 0     0     0   0                        
656781 OR     school 4101020 2113   Adrian SD 61 410102000755 707 Adrian Elementary School   Regular School No Elementary KG 08 2021   k_12_total 132 0 38   0 0     0   1                               132 0 38   0 0     0   1                        
656782 OR     school 4101020 2113   Adrian SD 61 410102000756 708 Adrian High School   Regular School No High 09 12 2021   k_12_total 62 0 19   0 1     0   1                               62 0 19   0 1     0   1                        
916639 OR     school 4101020 2113   Adrian SD 61 410102000755 707 Adrian Elementary School   Regular School No Elementary KG 08 2020   k_12_total 157 0 45   0 0     0   1                               157 0 45   0 0     0   1                        
916640 OR     school 4101020 2113   Adrian SD 61 410102000756 708 Adrian High School   Regular School No High 09 12 2020   k_12_total 70 0 15   1 1     0   2                               70 0 15   1 1     0   2                        
1190474 OR     school 4101020 2113   Adrian SD 61 410102000755 707 Adrian Elementary School   Regular School No Elementary KG 08 2018   k_12_total 164.0 0.0 42.0   0.0 0.0     0.0   1.0                               164 0 42   0 0     0   1                        
1190475 OR     school 4101020 2113   Adrian SD 61 410102000756 708 Adrian High School   Regular School No High 09 12 2018   k_12_total 70.0 0.0 19.0   1.0 2.0     0.0   2.0                               70 0 19   1 2     0   2                        
1705289 OR     school 4101020 2113   Adrian SD 61 410102000755 707 Adrian Elementary School   Regular School No Elementary KG 08 2017   k_12_total 152.0 0.0 46.0     0.0     0.0   2.0                               152 0 46     0     0   2                        
1705290 OR     school 4101020 2113   Adrian SD 61 410102000756 708 Adrian High School   Regular School No High 09 12 2017   k_12_total 61.0 0.0 19.0     1.0     0.0   3.0                               61 0 19     1     0   3                        
656783 OR     school 4101200 1899   Alsea SD 7J 410120000019 17 Alsea Charter School   Regular School Yes Other KG 12 2021   k_12_total 350 1 55   6 2     2   44                               350 1 55   6 2     2   44                        
916641 OR     school 4101200 1899   Alsea SD 7J 410120000019 17 Alsea Charter School   Regular School Yes Other KG 12 2020   k_12_total 253 2 28   5 18     0   15                               253 2 28   5 18     0   15                        
1190476 OR     school 4101200 1899   Alsea SD 7J 410120000019 17 Alsea Charter School   Regular School Yes Other KG 12 2018   k_12_total 129.0 1.0 19.0   1.0 0.0     0.0   8.0                               129 1 19   1 0     0   8                        
1190477 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1705291 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Elementary KG 06 2017   k_12_total 63.0 0.0 7.0     0.0     0.0   3.0                               63 0 7     0     0   3                        
1705292 OR     school 4101200 1899   Alsea SD 7J 410120000019 17 Alsea High School   Regular School No High 07 12 2017   k_12_total 59.0 0.0 6.0     0.0     0.0   0.0                               59 0 6     0     0   0                        
656784 OR     school 4101230 2252   Amity SD 4J 410123001260 1208 Amity Elementary School   Regular School No Elementary KG 05 2021   k_12_total 216 1 43   6 0     0   15                               216 1 43   6 0     0   15                        
656785 OR     school 4101230 2252   Amity SD 4J 410123001263 1210 Amity High School   Regular School No High 09 12 2021   k_12_total 190 2 32   1 3     0   11                               190 2 32   1 3     0   11                        
656786 OR     school 4101230 2252   Amity SD 4J 410123001320 1209 Amity Middle School   Regular School No Middle 06 08 2021   k_12_total 154 0 27   1 2     0   8                               154 0 27   1 2     0   8                        
656787 OR     school 4101230 2252   Amity SD 4J 410123001653 4505 Eola Hills Charter School   Regular School Yes Other 01 12 2021   k_12_total 17 0 1   0 0     0   3                               17 0 1   0 0     0   3                        
916642 OR     school 4101230 2252   Amity SD 4J 410123001260 1208 Amity Elementary School   Regular School No Elementary KG 05 2020   k_12_total 255 2 48   8 0     0   20                               255 2 48   8 0     0   20                        
916643 OR     school 4101230 2252   Amity SD 4J 410123001263 1210 Amity High School   Regular School No High 09 12 2020   k_12_total 201 0 34   2 3     0   12                               201 0 34   2 3     0   12                        
916644 OR     school 4101230 2252   Amity SD 4J 410123001320 1209 Amity Middle School   Regular School No Middle 06 08 2020   k_12_total 172 0 23   1 3     0   7                               172 0 23   1 3     0   7                        
916645 OR     school 4101230 2252   Amity SD 4J 410123001653 4505 Eola Hills Charter School   Regular School Yes Other 01 12 2020   k_12_total 24 1 5   1 0     0   2                               24 1 5   1 0     0   2                        
1190478 OR     school 4101230 2252   Amity SD 4J 410123001260 1208 Amity Elementary School   Regular School No Elementary KG 05 2018   k_12_total 287.0 1.0 46.0   5.0 1.0     0.0   20.0                               287 1 46   5 1     0   20                        
1190479 OR     school 4101230 2252   Amity SD 4J 410123001263 1210 Amity High School   Regular School No High 09 12 2018   k_12_total 226.0 0.0 37.0   2.0 2.0     0.0   14.0                               226 0 37   2 2     0   14                        
1190480 OR     school 4101230 2252   Amity SD 4J 410123001320 1209 Amity Middle School   Regular School No Middle 06 08 2018   k_12_total 161.0 1.0 29.0   1.0 2.0     1.0   5.0                               161 1 29   1 2     1   5                        
1190481 OR     school 4101230 2252   Amity SD 4J 410123001653 4505 Eola Hills Charter School   Regular School Yes Other 01 12 2018   k_12_total 24.0 1.0 5.0   2.0 1.0     0.0   4.0                               24 1 5   2 1     0   4                        
1705293 OR     school 4101230 2252   Amity SD 4J 410123001260 1208 Amity Elementary School   Regular School No Elementary KG 05 2017   k_12_total 278.0 2.0 49.0     1.0     0.0   15.0                               278 2 49     1     0   15                        
1705294 OR     school 4101230 2252   Amity SD 4J 410123001263 1210 Amity High School   Regular School No High 09 12 2017   k_12_total 223.0 2.0 39.0     0.0     0.0   15.0                               223 2 39     0     0   15                        
1705295 OR     school 4101230 2252   Amity SD 4J 410123001320 1209 Amity Middle School   Regular School No Middle 06 08 2017   k_12_total 147.0 0.0 29.0     2.0     1.0   7.0                               147 0 29     2     1   7                        
1705296 OR     school 4101230 2252   Amity SD 4J 410123001653 4505 Eola Hills Charter School   Regular School Yes Other KG 12 2017   k_12_total 30.0 1.0 9.0     1.0     0.0   5.0                               30 1 9     1     0   5                        
656788 OR     school 4101350 2111   Annex SD 29 410135000753 705 Annex Charter School   Regular School Yes Elementary KG 08 2021   k_12_total 48 0 10   0 0     0   3                               48 0 10   0 0     0   3                        
656789 OR     school 4101350 2111   Annex SD 29   2111 Annex SD 29             2021   k_12_total 17 0 4   0 0     0   0                               17 0 4   0 0     0   0                        
916646 OR     school 4101350 2111   Annex SD 29 410135000753 705 Annex Charter School   Regular School Yes Elementary KG 08 2020   k_12_total 52 0 22   0 0     0   4                               52 0 22   0 0     0   4                        
916647 OR     school 4101350 2111   Annex SD 29   2111 Annex SD 29             2020   k_12_total 13 0 3   0 0     0   0                               13 0 3   0 0     0   0                        
1190482 OR     school 4101350 2111   Annex SD 29 410135000753 705 Annex Charter School   Regular School Yes Elementary KG 08 2018   k_12_total 58.0 0.0 25.0   0.0 0.0     0.0   4.0                               58 0 25   0 0     0   4                        
1190483 OR     school 4101350 2111   Annex SD 29   2111 Annex SD 29             2018   k_12_total 9.0 0.0 6.0   0.0 0.0     0.0   1.0                               9 0 6   0 0     0   1                        
1705297 OR     school 4101350 2111   Annex SD 29 410135000753 705 Annex Charter School   Regular School Yes Elementary KG 08 2017   k_12_total 41.0 0.0 27.0     0.0     0.0   5.0                               41 0 27     0     0   5                        
1705298 OR     school 4101350 2111   Annex SD 29   2111 Annex SD 29             2017   k_12_total 10.0 0.0 4.0     0.0     0.0   1.0                               10 0 4     0     0   1                        
656790 OR     school 4101470 2005   Arlington SD 3 410147000343 323 Arlington Community Charter School   Regular School Yes Other KG 12 2021   k_12_total 129 0 22   6 0     3   2                               129 0 22   6 0     3   2                        
916648 OR     school 4101470 2005   Arlington SD 3 410147000343 323 Arlington Community Charter School   Regular School Yes Other KG 12 2020   k_12_total 131 0 26   8 0     3   4                               131 0 26   8 0     3   4                        
1190484 OR     school 4101470 2005   Arlington SD 3 410147000343 323 Arlington Community Charter School   Regular School Yes Other KG 12 2018   k_12_total 121.0 0.0 21.0   7.0 0.0     1.0   5.0                               121 0 21   7 0     1   5                        
1705299 OR     school 4101470 2005   Arlington SD 3 410147000343 323 Arlington Community Charter School   Regular School Yes Other KG 12 2017   k_12_total 128.0 0.0 25.0     0.0     0.0   7.0                               128 0 25     0     0   7                        
656791 OR     school 4101500 2115   Arock SD 81 410150000759 711 W W Jones Elementary School   Regular School No Elementary KG 08 2021   k_12_total 13 0 3   0 0     0   0                               13 0 3   0 0     0   0                        
916649 OR     school 4101500 2115   Arock SD 81 410150000759 711 W W Jones Elementary School   Regular School No Elementary KG 08 2020   k_12_total 15 0 2   0 0     0   0                               15 0 2   0 0     0   0                        
1190485 OR     school 4101500 2115   Arock SD 81 410150000759 711 W W Jones Elementary School   Regular School No Elementary KG 08 2018   k_12_total 14.0 0.0 1.0   0.0 0.0     0.0   0.0                               14 0 1   0 0     0   0                        
1705300 OR     school 4101500 2115   Arock SD 81 410150000759 711 W W Jones Elementary School   Regular School No Elementary KG 08 2017   k_12_total 14.0 0.0 1.0     0.0     0.0   0.0                               14 0 1     0     0   0                        
656792 OR     school 4101560 2041   Ashland SD 5 410156000401 381 Ashland High School   Regular School No High 09 12 2021   k_12_total 695 6 108   2 15     0   112                               695 6 108   2 15     0   112                        
656793 OR     school 4101560 2041   Ashland SD 5 410156000400 380 Ashland Middle School   Regular School No Middle 06 08 2021   k_12_total 363 2 71   3 7     0   57                               363 2 71   3 7     0   57                        
656794 OR     school 4101560 2041   Ashland SD 5   2041 Ashland SD 5             2021   k_12_total 130 0 12   0 2     0   21                               130 0 12   0 2     0   21                        
656795 OR     school 4101560 2041   Ashland SD 5 410156000395 375 Bellview Elementary School   Regular School No Elementary KG 05 2021   k_12_total 206 0 30   3 3     0   29                               206 0 30   3 3     0   29                        
656796 OR     school 4101560 2041   Ashland SD 5 410156000397 377 Helman Elementary School   Regular School No Elementary KG 05 2021   k_12_total 220 2 36   1 2     2   30                               220 2 36   1 2     2   30                        
656797 OR     school 4101560 2041   Ashland SD 5 410156001654 4476 John Muir Outdoor School   Regular School No Elementary KG 08 2021   k_12_total 91 1 7   0 1     0   7                               91 1 7   0 1     0   7                        
656798 OR     school 4101560 2041   Ashland SD 5 410156000399 379 Walker Elementary School   Regular School No Elementary KG 05 2021   k_12_total 185 9 43   2 7     0   28                               185 9 43   2 7     0   28                        
916650 OR     school 4101560 2041   Ashland SD 5 410156000401 381 Ashland High School   Regular School No High 09 12 2020   k_12_total 745 8 99   1 10     1   129                               745 8 99   1 10     1   129                        
916651 OR     school 4101560 2041   Ashland SD 5 410156000400 380 Ashland Middle School   Regular School No Middle 06 08 2020   k_12_total 369 3 69   4 9     0   69                               369 3 69   4 9     0   69                        
916652 OR     school 4101560 2041   Ashland SD 5   2041 Ashland SD 5             2020   k_12_total 147 0 25   0 3     0   22                               147 0 25   0 3     0   22                        
916653 OR     school 4101560 2041   Ashland SD 5 410156000395 375 Bellview Elementary School   Regular School No Elementary KG 05 2020   k_12_total 240 5 34   2 4     0   33                               240 5 34   2 4     0   33                        
916654 OR     school 4101560 2041   Ashland SD 5 410156000397 377 Helman Elementary School   Regular School No Elementary KG 05 2020   k_12_total 260 2 36   1 1     1   40                               260 2 36   1 1     1   40                        
916655 OR     school 4101560 2041   Ashland SD 5 410156001654 4476 John Muir Outdoor School   Regular School No Elementary KG 08 2020   k_12_total 102 2 10   0 3     0   9                               102 2 10   0 3     0   9                        
916656 OR     school 4101560 2041   Ashland SD 5 410156000399 379 Walker Elementary School   Regular School No Elementary KG 05 2020   k_12_total 237 6 56   3 6     0   37                               237 6 56   3 6     0   37                        
1190486 OR     school 4101560 2041   Ashland SD 5 410156000401 381 Ashland High School   Regular School No High 09 12 2018   k_12_total 764.0 21.0 106.0   2.0 19.0     1.0   114.0                               764 21 106   2 19     1   114                        
1190487 OR     school 4101560 2041   Ashland SD 5 410156000400 380 Ashland Middle School   Regular School No Middle 06 08 2018   k_12_total 416.0 5.0 54.0   4.0 7.0     1.0   82.0                               416 5 54   4 7     1   82                        
1190488 OR     school 4101560 2041   Ashland SD 5   2041 Ashland SD 5             2018   k_12_total 161.0 1.0 34.0   0.0 5.0     1.0   21.0                               161 1 34   0 5     1   21                        
1190489 OR     school 4101560 2041   Ashland SD 5 410156000395 375 Bellview Elementary School   Regular School No Elementary KG 05 2018   k_12_total 248.0 3.0 30.0   3.0 2.0     0.0   36.0                               248 3 30   3 2     0   36                        
1190490 OR     school 4101560 2041   Ashland SD 5 410156000397 377 Helman Elementary School   Regular School No Elementary KG 05 2018   k_12_total 270.0 1.0 28.0   1.0 2.0     0.0   42.0                               270 1 28   1 2     0   42                        
1190491 OR     school 4101560 2041   Ashland SD 5 410156001654 4476 John Muir Elementary School   Regular School No Elementary KG 08 2018   k_12_total 95.0 2.0 9.0   0.0 2.0     0.0   13.0                               95 2 9   0 2     0   13                        
1190492 OR     school 4101560 2041   Ashland SD 5 410156000399 379 Walker Elementary School   Regular School No Elementary KG 05 2018   k_12_total 234.0 8.0 51.0   4.0 6.0     1.0   40.0                               234 8 51   4 6     1   40                        
1705301 OR     school 4101560 2041   Ashland SD 5 410156000401 381 Ashland High School   Regular School No High 09 12 2017   k_12_total 843.0 24.0 76.0     27.0     3.0   81.0                               843 24 76     27     3   81                        
1705302 OR     school 4101560 2041   Ashland SD 5 410156000400 380 Ashland Middle School   Regular School No Middle 06 08 2017   k_12_total 457.0 12.0 48.0     8.0     1.0   51.0                               457 12 48     8     1   51                        
1705303 OR     school 4101560 2041   Ashland SD 5   2041 Ashland SD 5             2017   k_12_total 151.0 0.0 25.0     5.0     1.0   17.0                               151 0 25     5     1   17                        
1705304 OR     school 4101560 2041   Ashland SD 5 410156000395 375 Bellview Elementary School   Regular School No Elementary KG 05 2017   k_12_total 262.0 5.0 20.0     2.0     2.0   16.0                               262 5 20     2     2   16                        
1705305 OR     school 4101560 2041   Ashland SD 5 410156000397 377 Helman Elementary School   Regular School No Elementary KG 05 2017   k_12_total 255.0 2.0 17.0     3.0     0.0   34.0                               255 2 17     3     0   34                        
1705306 OR     school 4101560 2041   Ashland SD 5 410156001654 4476 John Muir Elementary School   Regular School No Elementary KG 08 2017   k_12_total 93.0 3.0 10.0     3.0     0.0   16.0                               93 3 10     3     0   16                        
1705307 OR     school 4101560 2041   Ashland SD 5 410156000399 379 Walker Elementary School   Regular School No Elementary KG 05 2017   k_12_total 236.0 9.0 48.0     6.0     2.0   28.0                               236 9 48     6     2   28                        
656799 OR     school 4101590 2051   Ashwood SD 8 410159000448 427 Ashwood Elementary School   Regular School No Elementary KG 08 2021   k_12_total 10 0 0   0 0     0   0                               10 0 0   0 0     0   0                        
916657 OR     school 4101590 2051   Ashwood SD 8 410159000448 427 Ashwood Elementary School   Regular School No Elementary KG 08 2020   k_12_total 5 0 0   0 0     0   0                               5 0 0   0 0     0   0                        
1190493 OR     school 4101590 2051   Ashwood SD 8 410159000448 427 Ashwood Elementary School   Regular School No Elementary KG 08 2018   k_12_total 6.0 0.0 0.0   0.0 0.0     0.0   0.0                               6 0 0   0 0     0   0                        
1705308 OR     school 4101590 2051   Ashwood SD 8 410159000448 427 Ashwood Elementary School   Regular School No Elementary KG 06 2017   k_12_total 3.0 0.0 0.0     0.0     0.0   0.0                               3 0 0     0     0   0                        
656800 OR     school 4101620 1933   Astoria SD 1 410162000152 143 Astor Elementary School   Regular School No Elementary KG 02 2021   k_12_total 274 3 72   0 2     3   8                               274 3 72   0 2     3   8                        
656801 OR     school 4101620 1933   Astoria SD 1 410162000153 144 Astoria Middle School   Regular School No Middle 06 08 2021   k_12_total 309 3 99   1 1     6   16                               309 3 99   1 1     6   16                        
656802 OR     school 4101620 1933   Astoria SD 1   1933 Astoria SD 1             2021   k_12_total 9 0 0   0 0     0   0                               9 0 0   0 0     0   0                        
656803 OR     school 4101620 1933   Astoria SD 1 410162000155 146 Astoria Senior High School   Regular School No High 09 12 2021   k_12_total 441 1 89   6 6     6   30                               441 1 89   6 6     6   30                        
656804 OR     school 4101620 1933   Astoria SD 1 410162000156 147 Lewis & Clark Elementary School   Regular School No Elementary 03 05 2021   k_12_total 311 1 84   5 1     4   18                               311 1 84   5 1     4   18                        
916658 OR     school 4101620 1933   Astoria SD 1 410162000152 143 Astor Elementary School   Regular School No Elementary KG 02 2020   k_12_total 336 4 79   2 0     1   16                               336 4 79   2 0     1   16                        
916659 OR     school 4101620 1933   Astoria SD 1 410162000153 144 Astoria Middle School   Regular School No Middle 06 08 2020   k_12_total 336 4 91   4 4     3   21                               336 4 91   4 4     3   21                        
916660 OR     school 4101620 1933   Astoria SD 1   1933 Astoria SD 1             2020   k_12_total 4 0 0   0 1     0   0                               4 0 0   0 1     0   0                        
916661 OR     school 4101620 1933   Astoria SD 1 410162000155 146 Astoria Senior High School   Regular School No High 09 12 2020   k_12_total 429 0 94   3 8     2   34                               429 0 94   3 8     2   34                        
916662 OR     school 4101620 1933   Astoria SD 1 410162000156 147 Lewis & Clark Elementary School   Regular School No Elementary 03 05 2020   k_12_total 315 2 85   2 2     1   13                               315 2 85   2 2     1   13                        
1190494 OR     school 4101620 1933   Astoria SD 1 410162000152 143 Astor Elementary School   Regular School No Elementary KG 02 2018   k_12_total 321.0 1.0 80.0   3.0 4.0     3.0   14.0                               321 1 80   3 4     3   14                        
1190495 OR     school 4101620 1933   Astoria SD 1 410162000153 144 Astoria Middle School   Regular School No Middle 06 08 2018   k_12_total 334.0 3.0 62.0   2.0 7.0     3.0   13.0                               334 3 62   2 7     3   13                        
1190496 OR     school 4101620 1933   Astoria SD 1   1933 Astoria SD 1             2018   k_12_total 9.0 0.0 1.0   0.0 1.0     0.0   1.0                               9 0 1   0 1     0   1                        
1190497 OR     school 4101620 1933   Astoria SD 1 410162000155 146 Astoria Senior High School   Regular School No High 09 12 2018   k_12_total 488.0 1.0 89.0   5.0 10.0     3.0   24.0                               488 1 89   5 10     3   24                        
1190498 OR     school 4101620 1933   Astoria SD 1 410162000156 147 Lewis & Clark Elementary School   Regular School No Elementary 03 05 2018   k_12_total 315.0 3.0 82.0   10.0 4.0     4.0   14.0                               315 3 82   10 4     4   14                        
1705309 OR     school 4101620 1933   Astoria SD 1 410162000152 143 Astor Elementary School   Regular School No Elementary KG 02 2017   k_12_total 308.0 1.0 79.0     2.0     5.0   13.0                               308 1 79     2     5   13                        
1705310 OR     school 4101620 1933   Astoria SD 1 410162000153 144 Astoria Middle School   Regular School No Middle 06 08 2017   k_12_total 313.0 1.0 64.0     8.0     2.0   15.0                               313 1 64     8     2   15                        
1705311 OR     school 4101620 1933   Astoria SD 1   1933 Astoria SD 1             2017   k_12_total 7.0 0.0 3.0     0.0     0.0   0.0                               7 0 3     0     0   0                        

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