Data source: Big Local News · About: Big Local

7,371 rows where grade = "grade_2" and state = "IN" sorted by rowid descending

View and edit SQL

year

grade

  • grade_2 · 7,271
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
1929578 IN     school 1812390 8130   Warrick County School Corp 181239001987 8785 Tennyson Elementary School   Regular School No Elementary KG 05 2021   grade_2                         7.0 2.0                       9.0                         7 2                 9
1929569 IN     school 1812390 8130   Warrick County School Corp 181239001982 8777 Loge Elementary School   Regular School No Elementary KG 05 2021   grade_2                         26.0 27.0                       53.0                         26 27                 53
1929558 IN     school 1812390 8130   Warrick County School Corp 181239001983 8773 Lynnville Elementary School   Regular School No Elementary KG 05 2021   grade_2                         22.0 19.0                       41.0                         22 19                 41
1929542 IN     school 1812390 8130   Warrick County School Corp 181239001980 8769 Elberfeld Elementary School   Regular School No Elementary KG 05 2021   grade_2                         13.0 14.0                       27.0                         13 14                 27
1929535 IN     school 1812390 8130   Warrick County School Corp 181239001981 8764 John H Castle Elementary School   Regular School No Elementary KG 05 2021   grade_2                         79.0 71.0                       150.0                         79 71                 150
1929528 IN     school 1812390 8130   Warrick County School Corp 181239001988 8761 Yankeetown Elementary School   Regular School No Elementary KG 05 2021   grade_2                         20.0 25.0                       45.0                         20 25                 45
1929516 IN     school 1806080 8115   MSD Warren County 180608001074 8744 Warren Central Elementary School   Regular School No Elementary KG 06 2021   grade_2                         32.0 20.0                       52.0                         32 20                 52
1929501 IN     school 1806080 8115   MSD Warren County 180608001072 8733 Pine Village Elementary School   Regular School No Elementary KG 06 2021   grade_2                         8.0 7.0                       15.0                         8 7                 15
1929493 IN     school 1806080 8115   MSD Warren County 180608001075 8729 Williamsport Elementary School   Regular School No Elementary KG 06 2021   grade_2                         10.0 12.0                       22.0                         10 12                 22
1929486 IN     school 1812150 8060   Wabash City Schools 181215001937 8706 O J Neighbours Elementary School   Regular School No Elementary PK 04 2021   grade_2                         58.0 50.0                       108.0                         58 50                 108
1929470 IN     school 1812180 8050   MSD Wabash County Schools 181218001944 8677 Metro North Elementary School   Regular School No Elementary PK 03 2021   grade_2                         35.0 24.0                       59.0                         35 24                 59
1929449 IN     school 1812180 8050   MSD Wabash County Schools 181218001947 8656 Southwood Elementary School   Regular School No Elementary PK 06 2021   grade_2                         27.0 26.0                       53.0                         27 26                 53
1929423 IN     school 1806270 8045   Manchester Community Schools 180627001101 8633 Manchester Elementary School   Regular School No Elementary PK 06 2021   grade_2                         38.0 52.0                       90.0                         38 52                 90
1929401 IN     school 1812090 8030   Vigo County School Corp 181209001922 8609 West Vigo Elementary School   Regular School No Elementary KG 05 2021   grade_2                         24.0 14.0                       38.0                         24 14                 38
1929394 IN     school 1812090 8030   Vigo County School Corp 181209001919 8607 Terre Town Elementary School   Regular School No Elementary KG 05 2021   grade_2                         41.0 36.0                       77.0                         41 36                 77
1929386 IN     school 1812090 8030   Vigo County School Corp 181209001916 8605 Sugar Grove Elementary School   Regular School No Elementary PK 05 2021   grade_2                         32.0 23.0                       55.0                         32 23                 55
1929378 IN     school 1812090 8030   Vigo County School Corp 181209001913 8593 Riley Elementary School   Regular School No Elementary PK 05 2021   grade_2                         37.0 29.0                       66.0                         37 29                 66
1929371 IN     school 1812090 8030   Vigo County School Corp 181209002176 8575 Ouabache Elementary School   Regular School No Elementary KG 05 2021   grade_2                         32.0 24.0                       56.0                         32 24                 56
1929363 IN     school 1812090 8030   Vigo County School Corp 181209001910 8561 Meadows Elementary School   Regular School No Elementary PK 05 2021   grade_2                         22.0 15.0                       37.0                         22 15                 37
1929355 IN     school 1812090 8030   Vigo County School Corp 181209001909 8549 Lost Creek Elementary School   Regular School No Elementary PK 05 2021   grade_2                         57.0 52.0                       109.0                         57 52                 109
1929348 IN     school 1812090 8030   Vigo County School Corp 181209002173 8543 Hoosier Prairie Elementary School   Regular School No Elementary KG 05 2021   grade_2                         16.0 29.0                       45.0                         16 29                 45
1929340 IN     school 1812090 8030   Vigo County School Corp 181209001895 8537 Blanche E Fuqua Elementary School   Regular School No Elementary PK 05 2021   grade_2                         23.0 20.0                       43.0                         23 20                 43
1929332 IN     school 1812090 8030   Vigo County School Corp 181209001894 8533 Benjamin Franklin Elem School   Regular School No Elementary PK 05 2021   grade_2                         27.0 24.0                       51.0                         27 24                 51
1929324 IN     school 1812090 8030   Vigo County School Corp 181209001914 8525 Rio Grande Elementary School   Regular School No Elementary PK 05 2021   grade_2                         37.0 33.0                       70.0                         37 33                 70
1929317 IN     school 1812090 8030   Vigo County School Corp 181209001905 8521 Fayette Elementary School   Regular School No Elementary KG 05 2021   grade_2                         17.0 13.0                       30.0                         17 13                 30
1929309 IN     school 1812090 8030   Vigo County School Corp 181209001904 8517 Farrington Grove Elementary School   Regular School No Elementary PK 05 2021   grade_2                         38.0 30.0                       68.0                         38 30                 68
1929302 IN     school 1812090 8030   Vigo County School Corp 181209001903 8511 Dixie Bee Elementary School   Regular School No Elementary KG 05 2021   grade_2                         49.0 47.0                       96.0                         49 47                 96
1929295 IN     school 1812090 8030   Vigo County School Corp 181209002172 8510 Adelaide De Vaney Elementary Sch   Regular School No Elementary KG 05 2021   grade_2                         42.0 27.0                       69.0                         42 27                 69
1929287 IN     school 1812090 8030   Vigo County School Corp 181209001902 8509 Deming Elementary School   Regular School No Elementary PK 05 2021   grade_2                         8.0 18.0                       26.0                         8 18                 26
1929279 IN     school 1812090 8030   Vigo County School Corp 181209001901 8505 Davis Park Elementary School   Regular School No Elementary PK 05 2021   grade_2                         28.0 15.0                       43.0                         28 15                 43
1929272 IN     school 1812090 8030   Vigo County School Corp 181209001899 8497 Sugar Creek Consolidated Elem Sch   Regular School No Elementary KG 05 2021   grade_2                         32.0 29.0                       61.0                         32 29                 61
1929257 IN     school 1812090 8030   Vigo County School Corp 181209002676 8483 Vigo Virtual School Academy   Regular School No Other KG 12 2021   grade_2                         4.0 3.0                       7.0                         4 3                 7
1929214 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001741 8435 Van Duyn Elementary School   Regular School No Elementary PK 05 2021   grade_2                         16.0 26.0                       42.0                         16 26                 42
1929197 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001736 8431 Ernie Pyle Elementary School   Regular School No Elementary PK 05 2021   grade_2                         17.0 20.0                       37.0                         17 20                 37
1929190 IN     school 1810590 8020   South Vermillion Com Sch Corp 181059001735 8409 Central Elementary School   Regular School No Elementary KG 05 2021   grade_2                         28.0 19.0                       47.0                         28 19                 47
1929182 IN     school 1808070 8010   North Vermillion Com Sch Corp 180807000184 8403 North Vermillion Elementary School   Regular School No Elementary KG 06 2021   grade_2                         37.0 27.0                       64.0                         37 27                 64
1929168 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000489 8381 West Terrace Elementary School   Regular School No Elementary KG 05 2021   grade_2                         50.0 40.0                       90.0                         50 40                 90
1929160 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002275 8376 Daniel Wertz Elementary School   Regular School No Elementary PK 05 2021   grade_2                         26.0 15.0                       41.0                         26 15                 41
1929148 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000487 8365 Vogel Elementary School   Regular School No Elementary KG 06 2021   grade_2                         43.0 31.0                       74.0                         43 31                 74
1929141 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000485 8361 Tekoppel Elementary School   Regular School No Elementary KG 05 2021   grade_2                         38.0 37.0                       75.0                         38 37                 75
1929134 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000484 8357 Stringtown Elementary School   Regular School No Elementary KG 05 2021   grade_2                         19.0 24.0                       43.0                         19 24                 43
1929125 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000473 8353 Evans School   Regular School No Elementary PK 06 2021   grade_2                         22.0 27.0                       49.0                         22 27                 49
1929103 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000476 8329 Lodge Community School   Regular School No Elementary KG 08 2021   grade_2                         20.0 17.0                       37.0                         20 17                 37
1929089 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000472 8325 Highland Elementary School   Regular School No Elementary KG 05 2021   grade_2                         65.0 81.0                       146.0                         65 81                 146
1929078 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000483 8321 Stockwell Elementary School   Regular School No Elementary KG 05 2021   grade_2                         38.0 38.0                       76.0                         38 38                 76
1929066 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000470 8317 Hebron Elementary School   Regular School No Elementary PK 05 2021   grade_2                         39.0 51.0                       90.0                         39 51                 90
1929054 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000468 8309 Harper Elementary School   Regular School No Elementary KG 05 2021   grade_2                         18.0 20.0                       38.0                         18 20                 38
1929044 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000467 8301 Glenwood Leadership Academy   Regular School No Elementary KG 08 2021   grade_2                         17.0 18.0                       35.0                         17 18                 35
1929036 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000465 8293 Fairlawn Elementary School   Regular School No Elementary PK 05 2021   grade_2                         30.0 18.0                       48.0                         30 18                 48
1929028 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000463 8289 Dexter Elementary School   Regular School No Elementary PK 05 2021   grade_2                         22.0 18.0                       40.0                         22 18                 40
1929020 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000462 8285 Delaware Elementary School   Regular School No Elementary KG 06 2021   grade_2                         21.0 25.0                       46.0                         21 25                 46
1929009 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002649 8271 Harwood Career Prep High School   Regular School No Other KG 12 2021   grade_2                         99.0 91.0                       190.0                         99 91                 190
1928995 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002462 8270 Academy for Innovative Studies   Regular School No Other 02 12 2021   grade_2                         6.0 0.0                       6.0                         6 0                 6
1928982 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000458 8265 Cedar Hall Community School   Regular School No Elementary PK 08 2021   grade_2                         28.0 22.0                       50.0                         28 22                 50
1928974 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000457 8261 Caze Elementary School   Regular School No Elementary PK 05 2021   grade_2                         22.0 20.0                       42.0                         22 20                 42
1928959 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000475 8251 Lincoln School   Regular School No Elementary KG 08 2021   grade_2                         11.0 4.0                       15.0                         11 4                 15
1928945 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002627 8242 McCutchanville Elementary School   Regular School No Elementary PK 06 2021   grade_2                         58.0 55.0                       113.0                         58 55                 113
1928926 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345002507 8231 Oak Hill Elementary   Regular School No Elementary KG 06 2021   grade_2                         35.0 41.0                       76.0                         35 41                 76
1928914 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000482 8229 Scott Elementary School   Regular School No Elementary PK 06 2021   grade_2                         26.0 41.0                       67.0                         26 41                 67
1928907 IN     school 1803450 7995   Evansville Vanderburgh School Corp 180345000460 8225 Cynthia Heights Elementary School   Regular School No Elementary KG 05 2021   grade_2                         42.0 30.0                       72.0                         42 30                 72
1928900 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001870 8213 College Corner Union Elem School   Regular School No Elementary KG 05 2021   grade_2                         19.0 25.0                       44.0                         19 25                 44
1928893 IN     school 1811610 7950   Union Co/Clg Corner Joint Sch Dist 181161001867 8209 Liberty Elementary School   Regular School No Elementary KG 05 2021   grade_2                         29.0 20.0                       49.0                         29 20                 49
1928867 IN     school 1811400 7945   Tipton Community School Corp 181140001844 8163 Tipton Elementary School   Regular School No Elementary PK 05 2021   grade_2                         53.0 42.0                       95.0                         53 42                 95
1928851 IN     school 1808040 7935   Tri-Central Community Schools 180804002227 8154 Tri Central Elementary   Regular School No Elementary PK 05 2021   grade_2                         27.0 26.0                       53.0                         27 26                 53
1928846 IN     school 1812870 7875   West Lafayette Com School Corp 181287002043 8138 West Lafayette Elementary School   Regular School No Elementary KG 03 2021   grade_2                         92.0 89.0                       181.0                         92 89                 181
1928827 IN     school 1811340 7865   Tippecanoe School Corp 181134002441 8111 Woodland Elementary School   Regular School No Elementary KG 05 2021   grade_2                         56.0 48.0                       104.0                         56 48                 104
1928812 IN     school 1811340 7865   Tippecanoe School Corp 181134001827 8042 Klondike Elementary School   Regular School No Elementary KG 05 2021   grade_2                         96.0 69.0                       165.0                         96 69                 165
1928801 IN     school 1811340 7865   Tippecanoe School Corp 181134002326 8035 James Cole Elementary School   Regular School No Elementary KG 05 2021   grade_2                         27.0 23.0                       50.0                         27 23                 50
1928777 IN     school 1811340 7865   Tippecanoe School Corp 181134001821 8024 Battle Ground Elementary School   Regular School No Elementary KG 05 2021   grade_2                         55.0 38.0                       93.0                         55 38                 93
1928770 IN     school 1811340 7865   Tippecanoe School Corp 181134001305 8021 Wea Ridge Elementary School   Regular School No Elementary KG 05 2021   grade_2                         54.0 44.0                       98.0                         54 44                 98
1928763 IN     school 1811340 7865   Tippecanoe School Corp 181134001304 8019 Burnett Creek Elementary School   Regular School No Elementary KG 05 2021   grade_2                         49.0 62.0                       111.0                         49 62                 111
1928756 IN     school 1811340 7865   Tippecanoe School Corp 181134001824 8017 Dayton Elementary School   Regular School No Elementary KG 05 2021   grade_2                         27.0 34.0                       61.0                         27 34                 61
1928749 IN     school 1811340 7865   Tippecanoe School Corp 181134001831 8009 Mintonye Elementary School   Regular School No Elementary KG 05 2021   grade_2                         32.0 37.0                       69.0                         32 37                 69
1928742 IN     school 1811340 7865   Tippecanoe School Corp 181134001826 8007 Hershey Elementary School   Regular School No Elementary KG 05 2021   grade_2                         40.0 37.0                       77.0                         40 37                 77
1928735 IN     school 1811340 7865   Tippecanoe School Corp 181134002501 8006 Wyandotte Elementary   Regular School No Elementary KG 05 2021   grade_2                         43.0 48.0                       91.0                         43 48                 91
1928728 IN     school 1811340 7865   Tippecanoe School Corp 181134001829 8005 Mayflower Mill Elementary School   Regular School No Elementary KG 05 2021   grade_2                         49.0 43.0                       92.0                         49 43                 92
1928715 IN     school 1805400 7855   Lafayette School Corporation 180540000545 8119 Amelia Earhart Elementary School   Regular School No Elementary KG 04 2021   grade_2                         44.0 37.0                       81.0                         44 37                 81
1928709 IN     school 1805400 7855   Lafayette School Corporation 180540000978 8117 Vinton Elementary School   Regular School No Elementary KG 04 2021   grade_2                         46.0 48.0                       94.0                         46 48                 94
1928703 IN     school 1805400 7855   Lafayette School Corporation 180540002581 8108 Oakland Elementary School   Regular School No Elementary KG 04 2021   grade_2                         24.0 33.0                       57.0                         24 33                 57
1928697 IN     school 1805400 7855   Lafayette School Corporation 180540000972 8105 Murdock Elementary School   Regular School No Elementary KG 04 2021   grade_2                         19.0 27.0                       46.0                         19 27                 46
1928691 IN     school 1805400 7855   Lafayette School Corporation 180540000976 8104 Thomas Miller Elementary School   Regular School No Elementary KG 04 2021   grade_2                         42.0 34.0                       76.0                         42 34                 76
1928685 IN     school 1805400 7855   Lafayette School Corporation 180540000971 8103 Miami Elementary School   Regular School No Elementary KG 04 2021   grade_2                         36.0 45.0                       81.0                         36 45                 81
1928679 IN     school 1805400 7855   Lafayette School Corporation 180540000965 8091 Glen Acres Elementary School   Regular School No Elementary KG 04 2021   grade_2                         43.0 44.0                       87.0                         43 44                 87
1928673 IN     school 1805400 7855   Lafayette School Corporation 180540000963 8089 Edgelea Elementary School   Regular School No Elementary KG 04 2021   grade_2                         51.0 51.0                       102.0                         51 51                 102
1928648 IN     school 1811220 7775   Switzerland County School Corp 181122002170 7994 Switzerland Co Elementary School   Regular School No Elementary PK 06 2021   grade_2                         27.0 30.0                       57.0                         27 30                 57
1928631 IN     school 1811220 7775   Switzerland County School Corp 181122001808 7985 Jefferson-Craig Elementary School   Regular School No Elementary KG 06 2021   grade_2                         22.0 27.0                       49.0                         22 27                 49
1928624 IN     school 1810860 7715   Southwest School Corporation 181086001771 7965 Sullivan Elementary School   Regular School No Elementary KG 05 2021   grade_2                         74.0 49.0                       123.0                         74 49                 123
1928603 IN     school 1810860 7715   Southwest School Corporation 181086001770 7953 Carlisle Elementary School   Regular School No Elementary PK 05 2021   grade_2                         21.0 7.0                       28.0                         21 7                 28
1928594 IN     school 1808160 7645   Northeast School Corp 180816001401 7941 Northeast East Elementary School   Regular School No Elementary PK 06 2021   grade_2                         11.0 13.0                       24.0                         11 13                 24
1928586 IN     school 1808160 7645   Northeast School Corp 180816001400 7921 Northeast North Elementary School   Regular School No Elementary KG 06 2021   grade_2                         14.0 14.0                       28.0                         14 14                 28
1928572 IN     school 1811100 7615   MSD Steuben County 181110001801 7905 Pleasant Lake Elementary School   Regular School No Elementary KG 05 2021   grade_2                         11.0 11.0                       22.0                         11 11                 22
1928565 IN     school 1811100 7615   MSD Steuben County 181110001800 7901 Hendry Park Elementary School   Regular School No Elementary KG 05 2021   grade_2                         30.0 28.0                       58.0                         30 28                 58
1928558 IN     school 1811100 7615   MSD Steuben County 181110001629 7899 Ryan Park Elementary School   Regular School No Elementary KG 05 2021   grade_2                         40.0 27.0                       67.0                         40 27                 67
1928550 IN     school 1811100 7615   MSD Steuben County 181110001799 7897 Carlin Park Elementary School   Regular School No Elementary PK 05 2021   grade_2                         22.0 24.0                       46.0                         22 24                 46
1928533 IN     school 1804230 7610   Hamilton Community Schools 180423000723 7889 Hamilton Community Elementary Sch   Regular School No Elementary KG 05 2021   grade_2                         18.0 15.0                       33.0                         18 15                 33
1928513 IN     school 1803780 7605   Fremont Community Schools 180378000600 7881 Fremont Elementary School   Regular School No Elementary KG 04 2021   grade_2                         31.0 34.0                       65.0                         31 34                 65
1928501 IN     school 1805340 7525   Knox Community School Corp 180534000940 7845 Knox Community Elementary School   Regular School No Elementary PK 04 2021   grade_2                         62.0 59.0                       121.0                         62 59                 121
1928482 IN     school 1807800 7515   North Judson-San Pierre Sch Corp 180780001328 7851 North Judson-San Pierre Elem Sch   Regular School No Elementary KG 06 2021   grade_2                         33.0 41.0                       74.0                         33 41                 74
1928460 IN     school 1808460 7495   Oregon-Davis School Corp 180846002209 7818 Oregon-Davis Elementary School   Regular School No Elementary KG 06 2021   grade_2                         21.0 16.0                       37.0                         21 16                 37
1928452 IN     school 1810560 7445   South Spencer County Sch Corp 181056001732 7803 Rockport-Ohio Elementary School   Regular School No Elementary PK 05 2021   grade_2                         22.0 21.0                       43.0                         22 21                 43

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