Data source: Big Local News · About: Big Local

3,050 rows where grade = "pre_kindergarten" and state = "IN"

View and edit SQL

year

grade

  • pre_kindergarten · 2,850
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
1165048 IN     school 1804590 4730   School City of Hobart 180459000772 4311 The Early Lrn Cntr at George Earle   Regular School No 1.0 PK KG 2015   pre_kindergarten                         24.0 5.0                       29.0                         24 5                 29
1165101 IN     school 1807350 4740   School Town of Munster 180735001254 4343 Frank H Hammond Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         24.0 13.0                       37.0                         24 13                 37
1165118 IN     school 1813200 4760   Whiting School City 181320002081 4361 Nathan Hale Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         34.0 22.0                       56.0                         34 22                 56
1165138 IN     school 1807560 4805   New Prairie United School Corp 180756001301 4693 Rolling Prairie Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         3.0 0.0                       3.0                         3 0                 3
1165150 IN     school 1807560 4805   New Prairie United School Corp 180756001300 7349 Olive Township Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1165233 IN     school 1806570 4925   Michigan City Area Schools 180657001150 4821 Joy Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1165242 IN     school 1806570 4925   Michigan City Area Schools 180657001151 4825 Knapp Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         9.0 4.0                       13.0                         9 4                 13
1165259 IN     school 1806570 4925   Michigan City Area Schools 180657001158 6829 Pine Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         13.0 3.0                       16.0                         13 3                 16
1165282 IN     school 1805580 4945   LaPorte Community School Corp 180558002338 4707 Indian Trail Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         13.0 24.0                       37.0                         13 24                 37
1165294 IN     school 1805580 4945   LaPorte Community School Corp 180558001014 4721 Kingsford Heights Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         20.0 20.0                       40.0                         20 20                 40
1165302 IN     school 1805580 4945   LaPorte Community School Corp 180558001013 4727 Kingsbury Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         9.0 14.0                       23.0                         9 14                 23
1165308 IN     school 1805580 4945   LaPorte Community School Corp 180558001015 4741 LaPorte High School   Regular School No 3.0 09 12 2015   pre_kindergarten                         91.0 58.0                       149.0                         91 58                 149
1165320 IN     school 1805580 4945   LaPorte Community School Corp 180558001010 4749 Hailmann Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         22.0 16.0                       38.0                         22 16                 38
1165328 IN     school 1805580 4945   LaPorte Community School Corp 180558001009 4753 F Willard Crichfield Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         15.0 14.0                       29.0                         15 14                 29
1165336 IN     school 1805580 4945   LaPorte Community School Corp 180558001016 4757 Lincoln Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         20.0 16.0                       36.0                         20 16                 36
1165344 IN     school 1805580 4945   LaPorte Community School Corp 180558001020 4767 Riley Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         18.0 17.0                       35.0                         18 17                 35
1165352 IN     school 1805580 4945   LaPorte Community School Corp 180558001011 4773 Handley Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1165424 IN     school 1807860 5075   North Lawrence Com Schools 180786001345 4917 Parkview Primary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         31.0 15.0                       46.0                         31 15                 46
1165444 IN     school 1806900 5085   Mitchell Community Schools 180690001196 4863 Hatfield Elementary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         16.0 12.0                       28.0                         16 12                 28
1165469 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002049 5009 Frankton Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         22.0 29.0                       51.0                         22 29                 51
1165486 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002052 5025 Lapel Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         30.0 29.0                       59.0                         30 29                 59
1165511 IN     school 1810440 5255   South Madison Com Sch Corp 181044001713 5061 Pendleton Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         14.0 6.0                       20.0                         14 6                 20
1165537 IN     school 1800120 5265   Alexandria Com School Corp 180012000009 5069 Alexandria-Monroe Elementary   Regular School No 1.0 PK 03 2015   pre_kindergarten                         1.0 1.0                       2.0                         1 1                 2
1165558 IN     school 1800150 5275   Anderson Community School Corp 180015002557 5023 Southview Preschool Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                         195.0 118.0                       313.0                         195 118                 313
1165607 IN     school 1803300 5280   Elwood Community School Corp 180330000448 5157 Elwood Elementary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         53.0 44.0                       97.0                         53 44                 97
1165709 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                         42.0 13.0                       55.0                         42 13                 55
1165748 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No 1.0 PK KG 2015   pre_kindergarten                         188.0 158.0                       346.0                         188 158                 346
1165852 IN     school 1808820 5340   Perry Township Schools 180882002280 5322 Mary Bryan Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         6.0 6.0                       12.0                         6 6                 12
1165860 IN     school 1808820 5340   Perry Township Schools 180882001456 5325 Clinton Young Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         1.0 1.0                       2.0                         1 1                 2
1165868 IN     school 1808820 5340   Perry Township Schools 180882001459 5333 Glenns Valley Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1165904 IN     school 1808820 5340   Perry Township Schools 180882001470 5351 Winchester Village Elementary   Regular School No 1.0 PK 05 2015   pre_kindergarten                         3.0 2.0                       5.0                         3 2                 5
1165912 IN     school 1808820 5340   Perry Township Schools 180882001687 5366 Jeremiah Gray-Edison Elem   Regular School No 1.0 PK 05 2015   pre_kindergarten                         22.0 15.0                       37.0                         22 15                 37
1165920 IN     school 1808820 5340   Perry Township Schools 180882001809 5372 Rosa Parks-Edison Elem   Regular School No 1.0 PK 05 2015   pre_kindergarten                         1.0 1.0                       2.0                         1 1                 2
1165928 IN     school 1808910 5350   M S D Pike Township 180891001099 5349 Fishback Creek Public Aca   Regular School No 1.0 PK 05 2015   pre_kindergarten                         20.0 12.0                       32.0                         20 12                 32
1165977 IN     school 1808910 5350   M S D Pike Township 180891001485 5359 Eastbrook Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1165992 IN     school 1808910 5350   M S D Pike Township 180891001598 5363 Snacks Crossing Elem Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         57.0 24.0                       81.0                         57 24                 81
1166067 IN     school 1812360 5360   M S D Warren Township 181236000726 5395 Warren Early Childhood Ctr   Regular School No 1.0 PK PK 2015   pre_kindergarten                         149.0 112.0                       261.0                         149 112                 261
1166125 IN     school 1812720 5370   M S D Washington Township 181272002444 5434 Hilltop School   Regular School No 1.0 PK PK 2015   pre_kindergarten                         92.0 32.0                       124.0                         92 32                 124
1166170 IN     school 1812810 5375   M S D Wayne Township 181281002034 5223 Maplewood Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         9.0 11.0                       20.0                         9 11                 20
1166187 IN     school 1812810 5375   M S D Wayne Township 181281002033 5241 Garden City Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1166204 IN     school 1812810 5375   M S D Wayne Township 181281002036 5261 Rhoades Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1166229 IN     school 1812810 5375   M S D Wayne Township 181281002040 5270 Stout Field Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         14.0 6.0                       20.0                         14 6                 20
1166295 IN     school 1800450 5380   Beech Grove City Schools 180045000881 5463 Hornet Park Elementary School   Regular School No 1.0 PK 01 2015   pre_kindergarten                         14.0 8.0                       22.0                         14 8                 22
1166366 IN     school 1804770 5385   Indianapolis Public Schools 180477000897 5514 Washington Irving School 14   Regular School No 1.0 PK 06 2015   pre_kindergarten                         27.0 20.0                       47.0                         27 20                 47
1166375 IN     school 1804770 5385   Indianapolis Public Schools 180477000896 5515 Thomas D Gregg School 15   Regular School No 1.0 PK 06 2015   pre_kindergarten                         6.0 9.0                       15.0                         6 9                 15
1166407 IN     school 1804770 5385   Indianapolis Public Schools 180477000821 5534 Eleanor Skillen School 34   Regular School No 1.0 PK 06 2015   pre_kindergarten                         7.0 12.0                       19.0                         7 12                 19
1166416 IN     school 1804770 5385   Indianapolis Public Schools 180477000903 5539 William McKinley School 39   Regular School No 1.0 PK 06 2015   pre_kindergarten                         26.0 11.0                       37.0                         26 11                 37
1166425 IN     school 1804770 5385   Indianapolis Public Schools 180477000820 5542 Elder W Diggs School 42   Regular School No 1.0 PK 06 2015   pre_kindergarten                         20.0 6.0                       26.0                         20 6                 26
1166444 IN     school 1804770 5385   Indianapolis Public Schools 180477000885 5544 Riverside School 44   Regular School No 1.0 PK 06 2015   pre_kindergarten                         35.0 20.0                       55.0                         35 20                 55
1166463 IN     school 1804770 5385   Indianapolis Public Schools 180477000867 5548 Louis B Russell Jr School 48   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 4.0                       14.0                         10 4                 14
1166480 IN     school 1804770 5385   Indianapolis Public Schools 180477002404 5551 James Russell Lowell School 51   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 8.0                       18.0                         10 8                 18
1166497 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 Eliza A Blaker School 55   Regular School No 1.0 PK 06 2015   pre_kindergarten                         20.0 17.0                       37.0                         20 17                 37
1166508 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2015   pre_kindergarten                         15.0 14.0                       29.0                         15 14                 29
1166531 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 William A Bell Sch 60 Reggio Acad   Regular School No 1.0 PK 04 2015   pre_kindergarten                         18.0 22.0                       40.0                         18 22                 40
1166540 IN     school 1804770 5385   Indianapolis Public Schools 180477002394 5563 Wendell Phillips School 63   Regular School No 1.0 PK 06 2015   pre_kindergarten                         9.0 7.0                       16.0                         9 7                 16
1166549 IN     school 1804770 5385   Indianapolis Public Schools 180477000884 5565 Raymond F Brandes School 65   Regular School No 1.0 PK 06 2015   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1166558 IN     school 1804770 5385   Indianapolis Public Schools 180477000890 5567 Stephen Collins Foster Sch 67   Regular School No 1.0 PK 06 2015   pre_kindergarten                         13.0 12.0                       25.0                         13 12                 25
1166624 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2015   pre_kindergarten                         24.0 28.0                       52.0                         24 28                 52
1166633 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No 1.0 PK 06 2015   pre_kindergarten                         8.0 7.0                       15.0                         8 7                 15
1166642 IN     school 1804770 5385   Indianapolis Public Schools 180477000826 5590 Ernie Pyle School 90   Regular School No 1.0 PK 06 2015   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1166673 IN     school 1804770 5385   Indianapolis Public Schools 180477000833 5602 Francis Bellamy Pre-School Center   Regular School No 1.0 PK PK 2015   pre_kindergarten                         67.0 59.0                       126.0                         67 59                 126
1166682 IN     school 1804770 5385   Indianapolis Public Schools 180477000834 5603 Francis Scott Key School 103   Regular School No 1.0 PK 06 2015   pre_kindergarten                         14.0 10.0                       24.0                         14 10                 24
1166709 IN     school 1804770 5385   Indianapolis Public Schools 180477000864 5607 Lew Wallace School 107   Regular School No 1.0 PK 06 2015   pre_kindergarten                         40.0 29.0                       69.0                         40 29                 69
1166726 IN     school 1804770 5385   Indianapolis Public Schools 180477000882 5614 Paul I Miller School 114   Regular School No 1.0 PK 06 2015   pre_kindergarten                         6.0 8.0                       14.0                         6 8                 14
1166792 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry III   Regular School No 1.0 PK 08 2015   pre_kindergarten                         37.0 21.0                       58.0                         37 21                 58
1166803 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No 1.0 PK 08 2015   pre_kindergarten                         12.0 4.0                       16.0                         12 4                 16
1166847 IN     school 1810920 5400   School Town of Speedway 181092001781 5897 Carl G Fisher Elem School 1   Regular School No 1.0 PK 06 2015   pre_kindergarten                         15.0 3.0                       18.0                         15 3                 18
1166877 IN     school 1802520 5455   Culver Community Schools Corp 180252000302 5928 Culver Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         5.0 2.0                       7.0                         5 2                 7
1166937 IN     school 1809060 5485   Plymouth Community School Corp 180906001498 5961 Jefferson Elementary School   Regular School No 1.0 PK 04 2015   pre_kindergarten                         23.0 16.0                       39.0                         23 16                 39
1166981 IN     school 1810170 5520   Shoals Community School Corp 181017001634 5989 Shoals Community Elem School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         3.0 2.0                       5.0                         3 2                 5
1167002 IN     school 1806090 5615   Maconaquah School Corp 180609002318 6012 Pipe Creek Elementary School   Regular School No 1.0 PK 01 2015   pre_kindergarten                         41.0 43.0                       84.0                         41 43                 84
1167032 IN     school 1807890 5620   North Miami Community Schools 180789001350 6051 North Miami Elem School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         11.0 17.0                       28.0                         11 17                 28
1167049 IN     school 1808340 5625   Oak Hill United School Corp 180834001428 6073 Converse Elementary School   Regular School No 1.0 PK 02 2015   pre_kindergarten                         9.0 6.0                       15.0                         9 6                 15
1167078 IN     school 1808850 5635   Peru Community Schools 180885001472 6097 Elmwood Primary Learning Center   Regular School No 1.0 PK 02 2015   pre_kindergarten                         23.0 20.0                       43.0                         23 20                 43
1167087 IN     school 1809480 5705   Richland-Bean Blossom C S C 180948000261 6144 Edgewood Early Childhood Cntr   Regular School No 1.0 PK PK 2015   pre_kindergarten                         57.0 46.0                       103.0                         57 46                 103
1167122 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000129 6134 Lakeview Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         5.0 7.0                       12.0                         5 7                 12
1167131 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000128 6157 Grandview Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         10.0 8.0                       18.0                         10 8                 18
1167140 IN     school 1800630 5740   Monroe County Com Sch Corp 180063002347 6162 Highland Park Elem Sch   Regular School No 1.0 PK 06 2015   pre_kindergarten                         20.0 11.0                       31.0                         20 11                 31
1167149 IN     school 1800630 5740   Monroe County Com Sch Corp 180063002127 6164 Summit Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         15.0 5.0                       20.0                         15 5                 20
1167173 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000118 6173 Binford Elementary School   Regular School No 1.0 03 06 2015   pre_kindergarten                         11.0 4.0                       15.0                         11 4                 15
1167190 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000123 6187 Childs Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         11.0 7.0                       18.0                         11 7                 18
1167199 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000124 6189 Clear Creek Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         16.0 7.0                       23.0                         16 7                 23
1167208 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000127 6197 Fairview Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         8.0 10.0                       18.0                         8 10                 18
1167242 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000135 6225 Templeton Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         19.0 17.0                       36.0                         19 17                 36
1167251 IN     school 1800630 5740   Monroe County Com Sch Corp 180063000138 6226 University Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         20.0 15.0                       35.0                         20 15                 35
1167259 IN     school 1807900 5835   North Montgomery Com Sch Corp 180790002321 6240 Pleasant Hill Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         29.0 20.0                       49.0                         29 20                 49
1167335 IN     school   5855   Crawfordsville Com Schools   6305 Anna Willson School             2015   pre_kindergarten                         86.0 51.0                       137.0                         86 51                 137
1167352 IN     school 1804140 5900   Monroe-Gregg School District 180414000715 6323 Monrovia Elementary School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         3.0 6.0                       9.0                         3 6                 9
1167416 IN     school 1806510 5925   M S D Martinsville Schools 180651001131 6349 Charles L Smith Elem School   Regular School No 1.0 PK 05 2015   pre_kindergarten                         18.0 14.0                       32.0                         18 14                 32
1167486 IN     school 1807140 5930   Mooresville Con School Corp 180714001213 6393 Waverly Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         39.0 12.0                       51.0                         39 12                 51
1167531 IN     school 1810470 5995   South Newton School Corp 181047000768 6431 South Newton Elementary Sch   Regular School No 1.0 PK 05 2015   pre_kindergarten                         16.0 12.0                       28.0                         16 12                 28
1167568 IN     school 1802970 6060   East Noble School Corp 180297000387 6457 Avilla Elementary School   Regular School No 1.0 PK 07 2015   pre_kindergarten                         3.0 2.0                       5.0                         3 2                 5
1167586 IN     school 1802970 6060   East Noble School Corp 180297000393 6465 Rome City Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         12.0 11.0                       23.0                         12 11                 23
1167603 IN     school 1802970 6060   East Noble School Corp 180297000888 6478 South Side Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         5.0 3.0                       8.0                         5 3                 8
1167613 IN     school 1802970 6060   East Noble School Corp 180297000394 6485 Wayne Center Elem Sch   Regular School No 1.0 PK 07 2015   pre_kindergarten                         6.0 5.0                       11.0                         6 5                 11
1167623 IN     school 1812900 6065   West Noble School Corporation 181290002055 6491 West Noble Primary School   Regular School No 1.0 PK 01 2015   pre_kindergarten                         13.0 1.0                       14.0                         13 1                 14
1167663 IN     school 1808490 6145   Orleans Community Schools 180849001436 6577 Orleans Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         3.0 4.0                       7.0                         3 4                 7
1167679 IN     school 1808640 6155   Paoli Community School Corp 180864001439 6587 Throop Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         14.0 4.0                       18.0                         14 4                 18
1167727 IN     school 1810950 6195   Spencer-Owen Community Schools 181095001794 6617 Spencer Elementary School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         62.0 32.0                       94.0                         62 32                 94
1167768 IN     school 1801740 6325   Perry Central Com Schools Corp 180174000232 6705 Perry Central Elem School   Regular School No 1.0 PK 06 2015   pre_kindergarten                         21.0 21.0                       42.0                         21 21                 42

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