enrollments

Data source: Big Local News · About: Big Local

505 rows where grade = "grade_7", state = "IN" and year = 2016 sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 505 ✖

grade ✖

  • grade_7 · 505 ✖
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
1281029 1281029 IN     school 1808250 225   Northwest Allen County Schools 180825002160 145 Allen Co Youth Services Center   Alternative Education School No 4.0 01 10 2016   grade_7                         1.0 0.0                       1.0                         1 0                 1
1282084 1282084 IN     school 1803940 1010   Greater Clark County Schools 180394000832 886 Old Corden Porter School   Special Education School No 4.0 05 12 2016   grade_7                         3.0 0.0                       3.0                         3 0                 3
1284648 1284648 IN     school 1807440 3445   New Castle Community Sch Corp 180744001290 2825 New Castle High School   Regular School No 3.0 07 12 2016   grade_7                         1.0 0.0                       1.0                         1 0                 1
1286136 1286136 IN     school 1803870 4690   Gary Community School Corp 180387000617 4081 Dr Bernard C Watson Acad for Boys   Regular School No 1.0 KG 08 2016   grade_7                         9.0 0.0                       9.0                         9 0                 9
1288970 1288970 IN     school 1802970 6060   East Noble School Corp 180297000389 6458 East Noble High School   Regular School No 3.0 07 12 2016   grade_7                         1.0 0.0                       1.0                         1 0                 1
1290082 1290082 IN     school 1806840 7200   School City of Mishawaka 180684000531 7467 Joint Service Campus Program   Special Education School No 4.0 04 12 2016   grade_7                         4.0 0.0                       4.0                         4 0                 4
1290337 1290337 IN     school 1810290 7205   South Bend Community Sch Corp 181029000898 7632 Juvenile Justice Center   Alternative Education School No 3.0 07 12 2016   grade_7                         1.0 0.0                       1.0                         1 0                 1
1291561 1291561 IN     school 1812180 8050   M S D Wabash County Schools 181218001951 8673 White's Jr-Sr High School   Regular School No 3.0 07 12 2016   grade_7                         3.0 0.0                       3.0                         3 0                 3
1292139 1292139 IN     school 1800006 9100   IN Department of Correction 180000601935 5055 Pendleton Juv Correctional Fac   Regular School No 3.0 07 12 2016   grade_7                         3.0 0.0                       3.0                         3 0                 3
1292609 1292609 IN     school 1800128 9745   Tindley Preparatory Academy 180012802545 5336 Tindley Preparatory Academy   Regular School Yes 2.0 05 08 2016   grade_7                         62.0 0.0                       62.0                         62 0                 62
1292633 1292633 IN     school 1800131 9760   Smith Academy for Excellence 180013102539 242 Smith Academy for Excellence   Regular School Yes 4.0 02 12 2016   grade_7                         13.0 0.0                       13.0                         13 0                 13
1282943 1282943 IN     school 1802400 2270   Concord Community Schools 180240002484 1718 Concord Intermediate School   Regular School No 2.0 04 07 2016   grade_7                         2.0 1.0                       3.0                         2 1                 3
1283100 1283100 IN     school 1803270 2305   Elkhart Community Schools 180327002585 1752 Elkhart Alternative Education   Regular School No 4.0 01 12 2016   grade_7                         7.0 1.0                       8.0                         7 1                 8
1284792 1284792 IN     school 1804470 3490   Western School Corp 180447002224 2923 Western Intermediate School   Regular School No 1.0 02 08 2016   grade_7                         0.0 1.0                       1.0                         0 1                 1
1287641 1287641 IN     school   5375   M S D Wayne Township   5271 Sanders School             2016   grade_7                         5.0 1.0                       6.0                         5 1                 6
1288963 1288963 IN     school 1802970 6060   East Noble School Corp 180297000387 6457 Avilla Elementary School   Regular School No 1.0 PK 07 2016   grade_7                         1.0 1.0                       2.0                         1 1                 2
1291507 1291507 IN     school 1812090 8030   Vigo County School Corp 181209000926 8612 McLean Education Center (Alt)   Regular School No 4.0 06 12 2016   grade_7                         5.0 1.0                       6.0                         5 1                 6
1291556 1291556 IN     school 1812180 8050   M S D Wabash County Schools 181218002178 8657 Sharp Creek Elementary School   Regular School No 1.0 01 07 2016   grade_7                         0.0 1.0                       1.0                         0 1                 1
1291904 1291904 IN     school 1809510 8385   Richmond Community Schools 180951000366 9056 Community Youth Services   Special Education School No 4.0 KG 12 2016   grade_7                         6.0 1.0                       7.0                         6 1                 7
1292832 1292832 IN     school 1800160 9915   Marion Academy 180016002588 5903 Marion Academy   Regular School Yes 3.0 07 12 2016   grade_7                         5.0 1.0                       6.0                         5 1                 6
1287912 1287912 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2016   grade_7                         14.0 10.0                       24.0                         14 10                 24
1288031 1288031 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2016   grade_7                         10.0 10.0                       20.0                         10 10                 20
1284296 1284296 IN     school 1800690 3180   North Harrison Com School Corp 180069000145 2625 North Harrison Middle School   Regular School No 2.0 06 08 2016   grade_7                         80.0 100.0                       180.0                         80 100                 180
1290957 1290957 IN     school 1811340 7865   Tippecanoe School Corp 181134001920 8049 Wea Ridge Middle School   Regular School No 2.0 06 08 2016   grade_7                         111.0 101.0                       212.0                         111 101                 212
1285499 1285499 IN     school 1812120 4335   Vincennes Community Sch Corp 181212001928 3557 George Rogers Clark School   Regular School No 2.0 06 08 2016   grade_7                         107.0 102.0                       209.0                         107 102                 209
1281080 1281080 IN     school 1803630 235   Fort Wayne Community Schools 180363000539 126 Lane Middle School   Regular School No 2.0 06 08 2016   grade_7                         104.0 103.0                       207.0                         104 103                 207
1289024 1289024 IN     school 1812900 6065   West Noble School Corporation 181290002059 6509 West Noble Middle School   Regular School No 2.0 05 08 2016   grade_7                         73.0 103.0                       176.0                         73 103                 176
1292028 1292028 IN     school 1811580 8565   Twin Lakes School Corp 181158001862 9153 Roosevelt Middle School   Regular School No 2.0 06 08 2016   grade_7                         99.0 103.0                       202.0                         99 103                 202
1282339 1282339 IN     school 1812450 1405   Washington Com Schools 181245002007 1123 Washington Junior High School   Regular School No 2.0 07 08 2016   grade_7                         106.0 104.0                       210.0                         106 104                 210
1286262 1286262 IN     school 1804320 4710   School City of Hammond 180432000734 4413 Donald E Gavit Middle/High School   Regular School No 4.0 06 12 2016   grade_7                         126.0 104.0                       230.0                         126 104                 230
1286535 1286535 IN     school 1807560 4805   New Prairie United School Corp 180756001299 7345 New Prairie Middle School   Regular School No 2.0 06 08 2016   grade_7                         112.0 105.0                       217.0                         112 105                 217
1281288 1281288 IN     school 1803630 235   Fort Wayne Community Schools 180363000560 240 Shawnee Middle School   Regular School No 2.0 06 08 2016   grade_7                         133.0 106.0                       239.0                         133 106                 239
1285883 1285883 IN     school 1805450 4615   Lake Central School Corp 180545000982 3841 Kahler Middle School   Regular School No 2.0 05 08 2016   grade_7                         130.0 106.0                       236.0                         130 106                 236
1288087 1288087 IN     school 1804770 5385   Indianapolis Public Schools 180477000844 5601 H L Harshman Middle School   Regular School No 2.0 07 08 2016   grade_7                         189.0 106.0                       295.0                         189 106                 295
1282663 1282663 IN     school 1807230 1910   Yorktown Community Schools 180723001218 1387 Yorktown Middle School   Regular School No 2.0 06 08 2016   grade_7                         100.0 107.0                       207.0                         100 107                 207
1285701 1285701 IN     school 1813110 4525   Westview School Corporation 181311002079 3697 Westview Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_7                         83.0 107.0                       190.0                         83 107                 190
1286253 1286253 IN     school 1804320 4710   School City of Hammond 180432000735 4411 George Rogers Clark Md/HS   Regular School No 4.0 06 12 2016   grade_7                         110.0 109.0                       219.0                         110 109                 219
1285018 1285018 IN     school 1812060 3710   Crothersville Community Schools 181206001893 3121 Crothersville Jr-Sr High School   Regular School No 4.0 06 12 2016   grade_7                         19.0 11.0                       30.0                         19 11                 30
1288207 1288207 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry III   Regular School No 1.0 PK 08 2016   grade_7                         26.0 11.0                       37.0                         26 11                 37
1292688 1292688 IN     school 1800072 9805   Hoosier Academy - Indianapolis 180007202422 2527 Hoosier Academy - Indianapolis   Regular School Yes 4.0 KG 12 2016   grade_7                         10.0 11.0                       21.0                         10 11                 21
1284878 1284878 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000790 3025 Riverview School   Regular School No 2.0 06 08 2016   grade_7                         115.0 110.0                       225.0                         115 110                 225
1284903 1284903 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471000784 3061 Crestview Middle School   Regular School No 2.0 06 08 2016   grade_7                         93.0 110.0                       203.0                         93 110                 203
1280926 1280926 IN     school 1800030 125   M S D Southwest Allen County Schls 180003000116 63 Summit Middle School   Regular School No 2.0 06 08 2016   grade_7                         120.0 111.0                       231.0                         120 111                 231
1291684 1291684 IN     school 1812390 8130   Warrick County School Corp 181239001976 8793 Boonville Middle School   Regular School No 2.0 06 08 2016   grade_7                         139.0 111.0                       250.0                         139 111                 250
1281657 1281657 IN     school 1802830 630   Zionsville Community Schools 180283002046 510 Zionsville West Middle School   Regular School No 2.0 04 08 2016   grade_7                         118.0 112.0                       230.0                         118 112                 230
1290188 1290188 IN     school 1810290 7205   South Bend Community Sch Corp 181029001709 7512 LaSalle Intermediate Academy   Regular School No 2.0 05 08 2016   grade_7                         124.0 112.0                       236.0                         124 112                 236
1291228 1291228 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000481 8349 Plaza Park International Prep Acad   Regular School No 2.0 06 08 2016   grade_7                         99.0 112.0                       211.0                         99 112                 211
1282708 1282708 IN     school 1807320 1970   Muncie Community Schools 180732002320 1431 Northside Middle School   Regular School No 2.0 06 08 2016   grade_7                         111.0 113.0                       224.0                         111 113                 224
1285930 1285930 IN     school 1811460 4645   Tri-Creek School Corporation 181146001851 3851 Lowell Middle School   Regular School No 2.0 05 08 2016   grade_7                         142.0 114.0                       256.0                         142 114                 256
1290679 1290679 IN     school 1811100 7615   M S D Steuben County 181110001798 7895 Angola Middle School   Regular School No 2.0 06 08 2016   grade_7                         108.0 115.0                       223.0                         108 115                 223
1281907 1281907 IN     school 1809370 940   West Clark Community Schools 180937001537 781 Silver Creek Middle School   Regular School No 2.0 06 08 2016   grade_7                         119.0 116.0                       235.0                         119 116                 235
1282028 1282028 IN     school 1803940 1010   Greater Clark County Schools 180394000674 853 Parkview Middle School   Regular School No 2.0 06 08 2016   grade_7                         115.0 116.0                       231.0                         115 116                 231
1291335 1291335 IN     school 1812090 8030   Vigo County School Corp 181209001907 8445 Honey Creek Middle School   Regular School No 2.0 06 08 2016   grade_7                         149.0 116.0                       265.0                         149 116                 265
1287683 1287683 IN     school 1800450 5380   Beech Grove City Schools 180045000092 5453 Beech Grove Middle School   Regular School No 2.0 07 08 2016   grade_7                         129.0 117.0                       246.0                         129 117                 246
1281084 1281084 IN     school 1803630 235   Fort Wayne Community Schools 180363000546 127 Memorial Park Middle School   Regular School No 2.0 06 08 2016   grade_7                         91.0 118.0                       209.0                         91 118                 209
1285848 1285848 IN     school 1805450 4615   Lake Central School Corp 180545000985 3831 Michael Grimmer Middle School   Regular School No 2.0 05 08 2016   grade_7                         131.0 118.0                       249.0                         131 118                 249
1286400 1286400 IN     school 1804560 4720   School Town of Highland 180456000764 4283 Highland Middle School   Regular School No 2.0 06 08 2016   grade_7                         133.0 118.0                       251.0                         133 118                 251
1287351 1287351 IN     school 1808910 5350   M S D Pike Township 180891001488 5355 Lincoln Middle School   Regular School No 2.0 06 08 2016   grade_7                         133.0 118.0                       251.0                         133 118                 251
1287540 1287540 IN     school 1812720 5370   M S D Washington Township 181272002022 5445 Northview Middle School   Regular School No 2.0 06 08 2016   grade_7                         150.0 118.0                       268.0                         150 118                 268
1287756 1287756 IN     school 1804770 5385   Indianapolis Public Schools 180477002530 5509 Broad Ripple Mgnt Jr HS-Prfm Arts   Regular School No 2.0 06 08 2016   grade_7                         82.0 118.0                       200.0                         82 118                 200
1288563 1288563 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000130 6172 Lora L Batchelor Middle School   Regular School No 2.0 07 08 2016   grade_7                         141.0 119.0                       260.0                         141 119                 260
1286572 1286572 IN     school 1800107 4915   Tri-Township Cons School Corp 180010702520 4696 Wanatah School   Regular School No 1.0 KG 08 2016   grade_7                         10.0 12.0                       22.0                         10 12                 22
1289184 1289184 IN     school 1801170 6340   Cannelton City Schools 180117000191 6733 Cannelton Elem & High School   Regular School No 4.0 PK 12 2016   grade_7                         8.0 12.0                       20.0                         8 12                 20
1292520 1292520 IN     school 1800061 9665   Geist Montessori Academy 180006102387 2572 Geist Montessori Academy   Regular School Yes 1.0 KG 08 2016   grade_7                         11.0 12.0                       23.0                         11 12                 23
1292705 1292705 IN     school 1800083 9835   The Bloomington Project School 180008302446 6215 The Bloomington Project School   Regular School Yes 1.0 KG 08 2016   grade_7                         17.0 12.0                       29.0                         17 12                 29
1285598 1285598 IN     school 1812420 4415   Warsaw Community Schools 181242002000 3653 Edgewood Middle School   Regular School No 2.0 07 08 2016   grade_7                         123.0 120.0                       243.0                         123 120                 243
1291192 1291192 IN     school 1803450 7995   Evansville Vanderburgh Sch Corp 180345000486 8323 Thompkins Middle School   Regular School No 2.0 06 08 2016   grade_7                         123.0 120.0                       243.0                         123 120                 243
1281068 1281068 IN     school 1803630 235   Fort Wayne Community Schools 180363000534 119 Jefferson Middle School   Regular School No 2.0 06 08 2016   grade_7                         127.0 121.0                       248.0                         127 121                 248
1281720 1281720 IN     school 1805790 665   Lebanon Community School Corp 180579001040 557 Lebanon Middle School   Regular School No 2.0 06 08 2016   grade_7                         134.0 121.0                       255.0                         134 121                 255
1283333 1283333 IN     school 1807410 2400   New Albany-Floyd Co Con Sch 180741001271 1933 Hazelwood Middle School   Regular School No 2.0 05 08 2016   grade_7                         114.0 121.0                       235.0                         114 121                 235
1292818 1292818 IN     school 1800098 9905   Indiana Connections Academy 180009802474 7944 Indiana Connections Academy   Regular School Yes 4.0 KG 12 2016   grade_7                         131.0 121.0                       252.0                         131 121                 252
1286287 1286287 IN     school 1804320 4710   School City of Hammond 180432000738 4425 Henry W Eggers Elem/Middle School   Regular School No 2.0 06 08 2016   grade_7                         108.0 122.0                       230.0                         108 122                 230
1292075 1292075 IN     school 1802280 8665   Whitley Co Cons Schools 180228000824 9180 Indian Springs Middle School   Regular School No 2.0 06 08 2016   grade_7                         143.0 122.0                       265.0                         143 122                 265
1287536 1287536 IN     school 1812720 5370   M S D Washington Township 181272002013 5442 Eastwood Middle School   Regular School No 2.0 06 08 2016   grade_7                         153.0 123.0                       276.0                         153 123                 276
1289492 1289492 IN     school 1811970 6560   Valparaiso Community Schools 181197001881 6885 Benjamin Franklin Mid Sch   Regular School No 2.0 06 08 2016   grade_7                         131.0 123.0                       254.0                         131 123                 254
1281663 1281663 IN     school 1802830 630   Zionsville Community Schools 180283000342 511 Zionsville Middle School   Regular School No 2.0 05 08 2016   grade_7                         150.0 124.0                       274.0                         150 124                 274
1282863 1282863 IN     school 1803960 2120   Greater Jasper Con Schs 180396000686 1575 Jasper Middle School   Regular School No 2.0 06 08 2016   grade_7                         137.0 124.0                       261.0                         137 124                 261
1283110 1283110 IN     school 1803270 2305   Elkhart Community Schools 180327000440 1763 Pierre Moran Middle School   Regular School No 2.0 07 08 2016   grade_7                         129.0 124.0                       253.0                         129 124                 253
1283676 1283676 IN     school 1806390 2865   Marion Community Schools 180639001112 2357 John L McCulloch Junior High Sch   Regular School No 2.0 07 08 2016   grade_7                         127.0 124.0                       251.0                         127 124                 251
1291361 1291361 IN     school 1812090 8030   Vigo County School Corp 181209001925 8485 Woodrow Wilson Middle School   Regular School No 2.0 06 08 2016   grade_7                         110.0 124.0                       234.0                         110 124                 234
1282076 1282076 IN     school 1803940 1010   Greater Clark County Schools 180394002131 883 River Valley Middle School   Regular School No 2.0 06 08 2016   grade_7                         145.0 125.0                       270.0                         145 125                 270
1287414 1287414 IN     school 1812360 5360   M S D Warren Township 181236001970 5367 Stonybrook Middle School   Regular School No 2.0 07 08 2016   grade_7                         153.0 125.0                       278.0                         153 125                 278
1289430 1289430 IN     school 1809150 6550   Portage Township Schools 180915001519 6859 William Fegely Middle School   Regular School No 2.0 06 08 2016   grade_7                         104.0 126.0                       230.0                         104 126                 230
1282204 1282204 IN     school 1803660 1170   Community Schools of Frankfort 180366000573 999 Frankfort Middle School   Regular School No 2.0 06 08 2016   grade_7                         130.0 127.0                       257.0                         130 127                 257
1283880 1283880 IN     school 1810650 3005   Hamilton Southeastern Schools 181065000133 2489 Hamilton SE Int and Jr High Sch   Regular School No 2.0 05 08 2016   grade_7                         144.0 127.0                       271.0                         144 127                 271
1284652 1284652 IN     school 1807440 3445   New Castle Community Sch Corp 180744001288 2829 New Castle Middle School   Regular School No 2.0 07 08 2016   grade_7                         128.0 127.0                       255.0                         128 127                 255
1285565 1285565 IN     school 1812420 4415   Warsaw Community Schools 181242002364 3607 Lakeview Middle School   Regular School No 2.0 07 08 2016   grade_7                         146.0 127.0                       273.0                         146 127                 273
1287403 1287403 IN     school 1808910 5350   M S D Pike Township 180891000513 5380 New Augusta Public Academy-North   Regular School No 2.0 06 08 2016   grade_7                         148.0 127.0                       275.0                         148 127                 275
1283262 1283262 IN     school 1803510 2395   Fayette County School Corp 180351000496 1895 Connersville Middle School   Regular School No 2.0 07 08 2016   grade_7                         138.0 128.0                       266.0                         138 128                 266
1291660 1291660 IN     school 1812390 8130   Warrick County School Corp 181239001978 8775 Castle North Middle School   Regular School No 2.0 06 08 2016   grade_7                         127.0 129.0                       256.0                         127 129                 256
1292258 1292258 IN     school 1800143 9375   IN Math & Science Academy - South 180014302561 5671 IN Math & Science Academy - South   Regular School Yes 1.0 KG 08 2016   grade_7                         15.0 13.0                       28.0                         15 13                 28
1285865 1285865 IN     school 1805450 4615   Lake Central School Corp 180545002420 3838 Hal E Clark Middle School   Regular School No 2.0 05 08 2016   grade_7                         146.0 131.0                       277.0                         146 131                 277
1281055 1281055 IN     school 1803630 235   Fort Wayne Community Schools 180363000516 107 Blackhawk Middle School   Regular School No 2.0 06 08 2016   grade_7                         137.0 133.0                       270.0                         137 133                 270
1288324 1288324 IN     school 1809060 5485   Plymouth Community School Corp 180906001499 5949 Lincoln Junior High School   Regular School No 2.0 06 08 2016   grade_7                         135.0 134.0                       269.0                         135 134                 269
1282373 1282373 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119002300 1190 Sunman-Dearborn Middle School   Regular School No 2.0 06 08 2016   grade_7                         170.0 135.0                       305.0                         170 135                 305
1291353 1291353 IN     school 1812090 8030   Vigo County School Corp 181209001911 8477 Otter Creek Middle School   Regular School No 2.0 06 08 2016   grade_7                         152.0 136.0                       288.0                         152 136                 288
1285240 1285240 IN     school 1805190 4015   Jennings County School Corporation 180519000925 3393 Jennings County Middle School   Regular School No 2.0 07 08 2016   grade_7                         159.0 137.0                       296.0                         159 137                 296
1285328 1285328 IN     school 1801440 4205   Center Grove Com Sch Corp 180144001912 3443 Center Grove Middle School North   Regular School No 2.0 06 08 2016   grade_7                         176.0 138.0                       314.0                         176 138                 314
1286291 1286291 IN     school 1804320 4710   School City of Hammond 180432000732 4433 Charles N Scott Middle School   Regular School No 2.0 06 08 2016   grade_7                         154.0 139.0                       293.0                         154 139                 293
1286472 1286472 IN     school 1807350 4740   School Town of Munster 180735001259 4333 Wilbur Wright Middle School   Regular School No 2.0 06 08 2016   grade_7                         153.0 139.0                       292.0                         153 139                 292

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