Data source: Big Local News · About: Big Local

419 rows where grade = "pre_kindergarten", state = "IN" and year = 2016 sorted by district

View and edit SQL

year

  • 2016 · 319

grade

  • pre_kindergarten · 319
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
1281229 IN     school 1803630 235   Fort Wayne Community Schools 180363000541 197 Lindley Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         16.0 15.0                       31.0                         16 15                 31
1281237 IN     school 1803630 235   Fort Wayne Community Schools 180363000544 205 Maplewood Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         17.0 12.0                       29.0                         17 12                 29
1281259 IN     school 1803630 235   Fort Wayne Community Schools 180363000551 217 Northcrest Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         18.0 26.0                       44.0                         18 26                 44
1281272 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         9.0 7.0                       16.0                         9 7                 16
1281293 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No 1.0 PK KG 2016   pre_kindergarten                         65.0 57.0                       122.0                         65 57                 122
1281301 IN     school 1803630 235   Fort Wayne Community Schools 180363000564 249 Levan R Scott Academy   Regular School No 1.0 PK 05 2016   pre_kindergarten                         17.0 15.0                       32.0                         17 15                 32
1281309 IN     school 1803630 235   Fort Wayne Community Schools 180363000563 253 South Wayne Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         15.0 11.0                       26.0                         15 11                 26
1281317 IN     school 1803630 235   Fort Wayne Community Schools 180363000948 257 Study Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         10.0 16.0                       26.0                         10 16                 26
1281325 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         9.0 19.0                       28.0                         9 19                 28
1281333 IN     school 1803630 235   Fort Wayne Community Schools 180363000566 269 Washington Center Elementary Sch   Regular School No 1.0 PK 05 2016   pre_kindergarten                         10.0 4.0                       14.0                         10 4                 14
1281348 IN     school 1803630 235   Fort Wayne Community Schools 180363000569 273 Waynedale Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         13.0 11.0                       24.0                         13 11                 24
1285384 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No 1.0 PK 04 2016   pre_kindergarten                         27.0 5.0                       32.0                         27 5                 32
1283449 IN     school 1803700 2475   Franklin County Com Sch Corp 180370002221 2082 Laurel School   Regular School No 1.0 PK 08 2016   pre_kindergarten                         22.0 16.0                       38.0                         22 16                 38
1283466 IN     school 1803700 2475   Franklin County Com Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No 1.0 PK 04 2016   pre_kindergarten                         8.0 4.0                       12.0                         8 4                 12
1287107 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                         44.0 16.0                       60.0                         44 16                 60
1286865 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002049 5009 Frankton Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         33.0 31.0                       64.0                         33 31                 64
1286882 IN     school 1812880 5245   Frankton-Lapel Community Schs 181288002052 5025 Lapel Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         33.0 24.0                       57.0                         33 24                 57
1286121 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No 1.0 PK PK 2016   pre_kindergarten                         280.0 253.0                       533.0                         280 253                 533
1283241 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         32.0 36.0                       68.0                         32 36                 68
1281960 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                         13.0 13.0                       26.0                         13 13                 26
1281968 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         7.0 11.0                       18.0                         7 11                 18
1281976 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         12.0 14.0                       26.0                         12 14                 26
1281984 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         10.0 8.0                       18.0                         10 8                 18
1281992 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1282013 IN     school 1803940 1010   Greater Clark County Schools 180394000667 825 Jonathan Jennings Elementary Sch   Regular School No 1.0 PK 05 2016   pre_kindergarten                         10.0 3.0                       13.0                         10 3                 13
1282021 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         12.0 9.0                       21.0                         12 9                 21
1282042 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         13.0 9.0                       22.0                         13 9                 22
1282050 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         12.0 9.0                       21.0                         12 9                 21
1282058 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         17.0 9.0                       26.0                         17 9                 26
1282066 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         9.0 6.0                       15.0                         9 6                 15
1282074 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         17.0 13.0                       30.0                         17 13                 30
1282861 IN     school 1803960 2120   Greater Jasper Con Schs 180396000684 1569 Ireland Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         4.0 2.0                       6.0                         4 2                 6
1282876 IN     school 1803960 2120   Greater Jasper Con Schs 180396000683 1597 Fifth Street Elementary School   Regular School No 1.0 PK 02 2016   pre_kindergarten                         16.0 11.0                       27.0                         16 11                 27
1289733 IN     school 1803990 6755   Greencastle Community Sch Corp 180399001625 7107 Deer Meadow Primary School   Regular School No 1.0 PK 02 2016   pre_kindergarten                         32.0 23.0                       55.0                         32 23                 55
1284206 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 J B Stephens Elementary School   Regular School No 1.0 PK 03 2016   pre_kindergarten                         22.0 4.0                       26.0                         22 4                 26
1282506 IN     school 1804080 1730   Greensburg Community Schools 180408002056 1270 Greensburg Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                         14.0 4.0                       18.0                         14 4                 18
1285421 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000670 3479 Westwood Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         21.0 7.0                       28.0                         21 7                 28
1286247 IN     school 1804170 4700   Griffith Public Schools 180417000719 4189 Elsie Wadsworth Elem Sch   Regular School No 1.0 PK 06 2016   pre_kindergarten                         32.0 5.0                       37.0                         32 5                 37
1283917 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No 1.0 PK 02 2016   pre_kindergarten                         31.0 27.0                       58.0                         31 27                 58
1283800 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                         163.0 102.0                       265.0                         163 102                 265
1284926 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471002598 3078 Huntington Schools Preschool   Regular School No 1.0 PK PK 2016   pre_kindergarten                         36.0 32.0                       68.0                         36 32                 68
1292443 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 Indiana School For The Blind   Alternative Education School No 4.0 PK 12 2016   pre_kindergarten                         3.0 4.0                       7.0                         3 4                 7
1292458 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Alternative Education School No 4.0 PK 12 2016   pre_kindergarten                         19.0 21.0                       40.0                         19 21                 40
1287774 IN     school 1804770 5385   Indianapolis Public Schools 180477000897 5514 Washington Irving School 14   Regular School No 1.0 PK 06 2016   pre_kindergarten                         28.0 23.0                       51.0                         28 23                 51
1287783 IN     school 1804770 5385   Indianapolis Public Schools 180477000896 5515 Thomas D Gregg School 15   Regular School No 1.0 PK 06 2016   pre_kindergarten                         5.0 5.0                       10.0                         5 5                 10
1287815 IN     school 1804770 5385   Indianapolis Public Schools 180477000821 5534 Eleanor Skillen School 34   Regular School No 1.0 PK 06 2016   pre_kindergarten                         18.0 19.0                       37.0                         18 19                 37
1287824 IN     school 1804770 5385   Indianapolis Public Schools 180477000903 5539 William McKinley School 39   Regular School No 1.0 PK 06 2016   pre_kindergarten                         20.0 20.0                       40.0                         20 20                 40
1287833 IN     school 1804770 5385   Indianapolis Public Schools 180477000820 5542 Elder W Diggs School 42   Regular School No 1.0 PK 06 2016   pre_kindergarten                         11.0 5.0                       16.0                         11 5                 16
1287842 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley School 43   Regular School No 1.0 PK 06 2016   pre_kindergarten                         6.0 13.0                       19.0                         6 13                 19
1287851 IN     school 1804770 5385   Indianapolis Public Schools 180477000885 5544 Riverside School 44   Regular School No 1.0 PK 06 2016   pre_kindergarten                         22.0 29.0                       51.0                         22 29                 51
1287870 IN     school 1804770 5385   Indianapolis Public Schools 180477000867 5548 Louis B Russell Jr School 48   Regular School No 1.0 PK 06 2016   pre_kindergarten                         13.0 12.0                       25.0                         13 12                 25
1287879 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No 1.0 PK 06 2016   pre_kindergarten                         6.0 4.0                       10.0                         6 4                 10
1287888 IN     school 1804770 5385   Indianapolis Public Schools 180477002404 5551 James Russell Lowell School 51   Regular School No 1.0 PK 06 2016   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1287905 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 Eliza A Blaker School 55   Regular School No 1.0 PK 06 2016   pre_kindergarten                         15.0 12.0                       27.0                         15 12                 27
1287916 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No 1.0 PK 08 2016   pre_kindergarten                         20.0 11.0                       31.0                         20 11                 31
1287933 IN     school 1804770 5385   Indianapolis Public Schools 180477000883 5558 Ralph Waldo Emerson School 58   Regular School No 1.0 PK 06 2016   pre_kindergarten                         8.0 12.0                       20.0                         8 12                 20
1287941 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 William A Bell Reggio Acad Sch 60   Regular School No 1.0 PK 05 2016   pre_kindergarten                         16.0 24.0                       40.0                         16 24                 40
1287950 IN     school 1804770 5385   Indianapolis Public Schools 180477002394 5563 Wendell Phillips School 63   Regular School No 1.0 PK 06 2016   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1287959 IN     school 1804770 5385   Indianapolis Public Schools 180477000884 5565 Raymond F Brandes School 65   Regular School No 1.0 PK 06 2016   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1287968 IN     school 1804770 5385   Indianapolis Public Schools 180477000890 5567 Stephen Collins Foster Sch 67   Regular School No 1.0 PK 06 2016   pre_kindergarten                         23.0 17.0                       40.0                         23 17                 40
1288024 IN     school 1804770 5385   Indianapolis Public Schools 180477000829 5583 Floro Torrence School 83   Regular School No 1.0 PK 06 2016   pre_kindergarten                         20.0 10.0                       30.0                         20 10                 30
1288035 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George W Carver School 87   Regular School No 1.0 PK 08 2016   pre_kindergarten                         19.0 12.0                       31.0                         19 12                 31
1288044 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No 1.0 PK 06 2016   pre_kindergarten                         8.0 2.0                       10.0                         8 2                 10
1288091 IN     school 1804770 5385   Indianapolis Public Schools 180477000833 5602 Francis Bellamy Pre-School Center   Regular School No 1.0 PK PK 2016   pre_kindergarten                         64.0 28.0                       92.0                         64 28                 92
1288100 IN     school 1804770 5385   Indianapolis Public Schools 180477000834 5603 Phalen at Francis Scott Key 103   Regular School No 1.0 PK 06 2016   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1288117 IN     school 1804770 5385   Indianapolis Public Schools 180477000887 5606 Robert Lee Frost School 106   Regular School No 1.0 PK 06 2016   pre_kindergarten                         12.0 6.0                       18.0                         12 6                 18
1288126 IN     school 1804770 5385   Indianapolis Public Schools 180477000864 5607 Lew Wallace School 107   Regular School No 1.0 PK 06 2016   pre_kindergarten                         17.0 25.0                       42.0                         17 25                 42
1288143 IN     school 1804770 5385   Indianapolis Public Schools 180477000882 5614 Paul I Miller School 114   Regular School No 1.0 PK 06 2016   pre_kindergarten                         8.0 4.0                       12.0                         8 4                 12
1288160 IN     school 1804770 5385   Indianapolis Public Schools 180477001427 5623 Arlington Woods Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         7.0 13.0                       20.0                         7 13                 20
1288200 IN     school 1804770 5385   Indianapolis Public Schools 180477002393 5662 Clarence Farrington School 61   Regular School No 1.0 PK 06 2016   pre_kindergarten                         5.0 15.0                       20.0                         5 15                 20
1288211 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry III   Regular School No 1.0 PK 08 2016   pre_kindergarten                         48.0 26.0                       74.0                         48 26                 74
1288222 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No 1.0 PK 08 2016   pre_kindergarten                         11.0 3.0                       14.0                         11 3                 14
1285207 IN     school 1805190 4015   Jennings County School Corporation 180519001417 3349 Sand Creek Elementary Sch   Regular School No 1.0 PK 06 2016   pre_kindergarten                         26.0 14.0                       40.0                         26 14                 40
1289957 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No 1.0 PK 06 2016   pre_kindergarten                         30.0 23.0                       53.0                         30 23                 53
1285044 IN     school 1805280 3785   Kankakee Valley School Corp 180528000932 3184 DeMotte Elementary School   Regular School No 1.0 PK 03 2016   pre_kindergarten                         24.0 5.0                       29.0                         24 5                 29
1290640 IN     school 1805340 7525   Knox Community School Corp 180534000940 7845 Knox Community Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         33.0 21.0                       54.0                         33 21                 54
1284820 IN     school 1805370 3500   Kokomo School Corporation 180537000943 2947 Boulevard Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         15.0 18.0                       33.0                         15 18                 33
1284836 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         181.0 213.0                       394.0                         181 213                 394
1284848 IN     school 1805370 3500   Kokomo School Corporation 180537000950 2969 Lafayette Park Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         32.0 26.0                       58.0                         32 26                 58
1284856 IN     school 1805370 3500   Kokomo School Corporation 180537000956 2993 Pettit Park School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         17.0 21.0                       38.0                         17 21                 38
1286677 IN     school 1805580 4945   LaPorte Community School Corp 180558002338 4707 Indian Trail Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         19.0 21.0                       40.0                         19 21                 40
1286689 IN     school 1805580 4945   LaPorte Community School Corp 180558001014 4721 Kingsford Heights Elementary Sch   Regular School No 1.0 PK 05 2016   pre_kindergarten                         11.0 13.0                       24.0                         11 13                 24
1286697 IN     school 1805580 4945   LaPorte Community School Corp 180558001013 4727 Kingsbury Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         7.0 20.0                       27.0                         7 20                 27
1286703 IN     school 1805580 4945   LaPorte Community School Corp 180558001015 4741 LaPorte High School   Regular School No 3.0 09 12 2016   pre_kindergarten                         72.0 76.0                       148.0                         72 76                 148
1286715 IN     school 1805580 4945   LaPorte Community School Corp 180558001010 4749 Hailmann Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         19.0 19.0                       38.0                         19 19                 38
1286723 IN     school 1805580 4945   LaPorte Community School Corp 180558001009 4753 F Willard Crichfield Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                         12.0 24.0                       36.0                         12 24                 36
1286731 IN     school 1805580 4945   LaPorte Community School Corp 180558001016 4757 Lincoln Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         20.0 12.0                       32.0                         20 12                 32
1286739 IN     school 1805580 4945   LaPorte Community School Corp 180558001020 4767 Riley Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         18.0 19.0                       37.0                         18 19                 37
1286747 IN     school 1805580 4945   LaPorte Community School Corp 180558001011 4773 Handley Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         1.0 0.0                       1.0                         1 0                 1
1290855 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No 1.0 PK PK 2016   pre_kindergarten                         194.0 75.0                       269.0                         194 75                 269
1285880 IN     school 1805450 4615   Lake Central School Corp 180545000981 3840 James H Watson Elem Sch   Regular School No 1.0 PK 04 2016   pre_kindergarten                         60.0 35.0                       95.0                         60 35                 95
1285892 IN     school 1805450 4615   Lake Central School Corp 180545000987 3843 Protsman Elementary School   Regular School No 1.0 PK 04 2016   pre_kindergarten                         14.0 17.0                       31.0                         14 17                 31
1285899 IN     school 1805450 4615   Lake Central School Corp 180545002143 4349 Homan Elementary School   Regular School No 1.0 PK 04 2016   pre_kindergarten                         9.0 1.0                       10.0                         9 1                 10
1285906 IN     school 1805450 4615   Lake Central School Corp 180545000986 4351 Peifer Elementary School   Regular School No 1.0 PK 04 2016   pre_kindergarten                         15.0 11.0                       26.0                         15 11                 26
1282453 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No 1.0 PK 02 2016   pre_kindergarten                         22.0 7.0                       29.0                         22 7                 29
1281864 IN     school 1806030 875   Logansport Community Sch Corp 180603001055 709 Fairview Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         31.0 27.0                       58.0                         31 27                 58
1281872 IN     school 1806030 875   Logansport Community Sch Corp 180603002366 711 Landis Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         19.0 24.0                       43.0                         19 24                 43
1287057 IN     school 1802640 5300   M S D Decatur Township 180264001065 5192 Liberty Early Elementary School   Regular School No 1.0 PK 01 2016   pre_kindergarten                         76.0 55.0                       131.0                         76 55                 131
1287144 IN     school 1805670 5330   M S D Lawrence Township 180567002205 5284 Early Learning Center   Regular School No 1.0 PK KG 2016   pre_kindergarten                         191.0 162.0                       353.0                         191 162                 353
1288774 IN     school 1806510 5925   M S D Martinsville Schools 180651001132 6309 Green Township Elementary School   Regular School No 1.0 PK 05 2016   pre_kindergarten                         3.0 2.0                       5.0                         3 2                 5

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