Data source: Big Local News · About: Big Local

433 rows where grade = "pre_kindergarten", state = "IN" and year = 2018 sorted by district

View and edit SQL

year

  • 2018 · 333

grade

  • pre_kindergarten · 333
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
1787667 IN     school 1803630 235   Fort Wayne Community Schools 180363000544 205 Maplewood Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         15.0 16.0                       31.0                         15 16                 31
1787682 IN     school 1803630 235   Fort Wayne Community Schools 180363000551 217 Northcrest Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         24.0 19.0                       43.0                         24 19                 43
1787695 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         5.0 2.0                       7.0                         5 2                 7
1787716 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2018   pre_kindergarten                         67.0 59.0                       126.0                         67 59                 126
1787724 IN     school 1803630 235   Fort Wayne Community Schools 180363000564 249 Levan R Scott Academy   Regular School No Elementary PK 05 2018   pre_kindergarten                         14.0 16.0                       30.0                         14 16                 30
1787732 IN     school 1803630 235   Fort Wayne Community Schools 180363000563 253 South Wayne Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         14.0 15.0                       29.0                         14 15                 29
1787740 IN     school 1803630 235   Fort Wayne Community Schools 180363000948 257 Study Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         15.0 7.0                       22.0                         15 7                 22
1787748 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         18.0 14.0                       32.0                         18 14                 32
1787756 IN     school 1803630 235   Fort Wayne Community Schools 180363000566 269 Washington Center Elementary Sch   Regular School No Elementary PK 05 2018   pre_kindergarten                         6.0 3.0                       9.0                         6 3                 9
1787771 IN     school 1803630 235   Fort Wayne Community Schools 180363000569 273 Waynedale Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         18.0 14.0                       32.0                         18 14                 32
1791786 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         20.0 6.0                       26.0                         20 6                 26
1789835 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002221 2082 Laurel School   Regular School No Elementary PK 06 2018   pre_kindergarten                         19.0 21.0                       40.0                         19 21                 40
1789852 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         14.0 5.0                       19.0                         14 5                 19
1793474 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002499 5203 Lillie Idella Kitley Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                         55.0 20.0                       75.0                         55 20                 75
1793222 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         40.0 32.0                       72.0                         40 32                 72
1793239 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         35.0 25.0                       60.0                         35 25                 60
1798335 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                         8.0 4.0                       12.0                         8 4                 12
1792509 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         241.0 269.0                       510.0                         241 269                 510
1789627 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         35.0 33.0                       68.0                         35 33                 68
1788384 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                         23.0 8.0                       31.0                         23 8                 31
1788392 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         17.0 12.0                       29.0                         17 12                 29
1788400 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         10.0 16.0                       26.0                         10 16                 26
1788408 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         16.0 11.0                       27.0                         16 11                 27
1788416 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         11.0 14.0                       25.0                         11 14                 25
1788438 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         38.0 14.0                       52.0                         38 14                 52
1788459 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         13.0 8.0                       21.0                         13 8                 21
1788467 IN     school 1803940 1010   Greater Clark County Schools 180394000668 869 Maple Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         9.0 3.0                       12.0                         9 3                 12
1788475 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         17.0 11.0                       28.0                         17 11                 28
1788483 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         11.0 3.0                       14.0                         11 3                 14
1788491 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         17.0 10.0                       27.0                         17 10                 27
1789255 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         13.0 8.0                       21.0                         13 8                 21
1796075 IN     school 1803990 6755   Greencastle Community School Corp 180399001625 7107 Deer Meadow Primary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         39.0 22.0                       61.0                         39 22                 61
1790593 IN     school 1804050 3125   Greenfield-Central Com Schools 180405001665 2588 JB Stephens Elementary School   Regular School No Elementary PK 03 2018   pre_kindergarten                         18.0 9.0                       27.0                         18 9                 27
1788898 IN     school 1804080 1730   Greensburg Community Schools 180408002056 1270 Greensburg Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                         22.0 3.0                       25.0                         22 3                 25
1791823 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000670 3479 Westwood Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         22.0 16.0                       38.0                         22 16                 38
1792584 IN     school 1804170 4700   Griffith Public Schools 180417000717 4171 Beiriger Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         28.0 10.0                       38.0                         28 10                 38
1790301 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         33.0 35.0                       68.0                         33 35                 68
1790181 IN     school 1810650 3005   Hamilton Southeastern Schools 181065001866 2466 Brooks School Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                         105.0 68.0                       173.0                         105 68                 173
1790200 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002168 2470 Cumberland Road Elem School   Regular School No Elementary PK 04 2018   pre_kindergarten                         0.0 1.0                       1.0                         0 1                 1
1790243 IN     school 1810650 3005   Hamilton Southeastern Schools 181065002061 2482 Sand Creek Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                         28.0 14.0                       42.0                         28 14                 42
1792173 IN     school 1804350 4580   Hanover Community School Corp 180435000754 3781 Jane Ball Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         19.0 3.0                       22.0                         19 3                 22
1791318 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471002598 3078 Huntington Schools Preschool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         56.0 41.0                       97.0                         56 41                 97
1798818 IN     school 1800023 9605   IN Sch for the Blind & Vis Imprd 180002302257 C460 IN Sch for the Blind & Vis Imprd   Special Education School No Other PK 12 2018   pre_kindergarten                         1.0 3.0                       4.0                         1 3                 4
1798833 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2018   pre_kindergarten                         13.0 14.0                       27.0                         13 14                 27
1794122 IN     school 1804770 5385   Indianapolis Public Schools 180477000897 5514 Washington Irving School 14   Regular School No Elementary PK 07 2018   pre_kindergarten                         31.0 19.0                       50.0                         31 19                 50
1794131 IN     school 1804770 5385   Indianapolis Public Schools 180477000896 5515 Thomas D Gregg School 15   Regular School No Elementary PK 06 2018   pre_kindergarten                         5.0 4.0                       9.0                         5 4                 9
1794155 IN     school 1804770 5385   Indianapolis Public Schools 180477000821 5534 Eleanor Skillen School 34   Regular School No Elementary PK 06 2018   pre_kindergarten                         19.0 20.0                       39.0                         19 20                 39
1794172 IN     school 1804770 5385   Indianapolis Public Schools 180477000903 5539 William McKinley School 39   Regular School No Elementary PK 06 2018   pre_kindergarten                         17.0 21.0                       38.0                         17 21                 38
1794182 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley School 43   Regular School No Elementary PK 07 2018   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1794187 IN     school 1804770 5385   Indianapolis Public Schools 180477000885 5544 Riverside School 44   Regular School No Middle 04 06 2018   pre_kindergarten                         34.0 18.0                       52.0                         34 18                 52
1794206 IN     school 1804770 5385   Indianapolis Public Schools 180477000867 5548 Louis B Russell Jr School 48   Regular School No Elementary PK 06 2018   pre_kindergarten                         22.0 11.0                       33.0                         22 11                 33
1794216 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 07 2018   pre_kindergarten                         7.0 1.0                       8.0                         7 1                 8
1794225 IN     school 1804770 5385   Indianapolis Public Schools 180477002404 5551 James Russell Lowell School 51   Regular School No Elementary PK 06 2018   pre_kindergarten                         10.0 9.0                       19.0                         10 9                 19
1794242 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 IPS/ Butler Eliza Blaker School 55   Regular School No Elementary PK 06 2018   pre_kindergarten                         8.0 8.0                       16.0                         8 8                 16
1794253 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2018   pre_kindergarten                         15.0 24.0                       39.0                         15 24                 39
1794271 IN     school 1804770 5385   Indianapolis Public Schools 180477000883 5558 Ralph Waldo Emerson School 58   Regular School No Elementary PK 06 2018   pre_kindergarten                         10.0 8.0                       18.0                         10 8                 18
1794281 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 IPS/ Butler Lab @ William Bell 60   Regular School No Elementary PK 07 2018   pre_kindergarten                         24.0 14.0                       38.0                         24 14                 38
1794291 IN     school 1804770 5385   Indianapolis Public Schools 180477002394 5563 Wendell Phillips School 63   Regular School No Elementary PK 07 2018   pre_kindergarten                         13.0 4.0                       17.0                         13 4                 17
1794300 IN     school 1804770 5385   Indianapolis Public Schools 180477000884 5565 Raymond F Brandes School 65   Regular School No Elementary PK 06 2018   pre_kindergarten                         10.0 7.0                       17.0                         10 7                 17
1794310 IN     school 1804770 5385   Indianapolis Public Schools 180477000890 5567 Stephen Foster School 67   Regular School No Elementary PK 07 2018   pre_kindergarten                         31.0 26.0                       57.0                         31 26                 57
1794349 IN     school 1804770 5385   Indianapolis Public Schools 180477000808 5579 Carl Wilde School 79   Regular School No Elementary PK 06 2018   pre_kindergarten                         2.0 2.0                       4.0                         2 2                 4
1794366 IN     school 1804770 5385   Indianapolis Public Schools 180477000829 5583 Floro Torrence School 83   Regular School No Elementary PK 06 2018   pre_kindergarten                         20.0 15.0                       35.0                         20 15                 35
1794377 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2018   pre_kindergarten                         23.0 30.0                       53.0                         23 30                 53
1794386 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2018   pre_kindergarten                         11.0 5.0                       16.0                         11 5                 16
1794405 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau McClellan School 91   Regular School No Elementary PK 08 2018   pre_kindergarten                         11.0 11.0                       22.0                         11 11                 22
1794422 IN     school 1804770 5385   Indianapolis Public Schools 180477000873 5596 Meredith Nicholson School 96   Regular School No Elementary PK 06 2018   pre_kindergarten                         6.0 14.0                       20.0                         6 14                 20
1794435 IN     school 1804770 5385   Indianapolis Public Schools 180477000833 5602 Francis Bellamy Pre-School Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         37.0 33.0                       70.0                         37 33                 70
1794460 IN     school 1804770 5385   Indianapolis Public Schools 180477000887 5606 Robert Lee Frost School 106   Regular School No Elementary PK 06 2018   pre_kindergarten                         11.0 9.0                       20.0                         11 9                 20
1794469 IN     school 1804770 5385   Indianapolis Public Schools 180477000864 5607 Lew Wallace School 107   Regular School No Elementary PK 06 2018   pre_kindergarten                         23.0 24.0                       47.0                         23 24                 47
1794486 IN     school 1804770 5385   Indianapolis Public Schools 180477000882 5614 Paul I Miller School 114   Regular School No Elementary PK 06 2018   pre_kindergarten                         4.0 2.0                       6.0                         4 2                 6
1794488 IN     school 1804770 5385   Indianapolis Public Schools 180477002611 5618 Gambold Pre-School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten                         6.0 5.0                       11.0                         6 5                 11
1794505 IN     school 1804770 5385   Indianapolis Public Schools 180477001427 5623 Arlington Woods School 99   Regular School No Elementary PK 06 2018   pre_kindergarten                         13.0 6.0                       19.0                         13 6                 19
1794540 IN     school 1804770 5385   Indianapolis Public Schools 180477002393 5662 Clarence Farrington School 61   Regular School No Elementary PK 06 2018   pre_kindergarten                         17.0 8.0                       25.0                         17 8                 25
1794551 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2018   pre_kindergarten                         51.0 30.0                       81.0                         51 30                 81
1794562 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No Elementary PK 08 2018   pre_kindergarten                         10.0 4.0                       14.0                         10 4                 14
1796215 IN     school 1804800 6900   Jac-Cen-Del Community Sch Corp 180480002353 7203 Jac-Cen-Del Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         12.0 2.0                       14.0                         12 2                 14
1791600 IN     school 1805190 4015   Jennings County School Corporation 180519001417 3349 Sand Creek Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         17.0 11.0                       28.0                         17 11                 28
1796300 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten                         21.0 26.0                       47.0                         21 26                 47
1791441 IN     school 1805280 3785   Kankakee Valley School Corp 180528000932 3184 DeMotte Elementary School   Regular School No Elementary PK 03 2018   pre_kindergarten                         14.0 9.0                       23.0                         14 9                 23
1796981 IN     school 1805340 7525   Knox Community School Corp 180534000940 7845 Knox Community Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         38.0 29.0                       67.0                         38 29                 67
1791212 IN     school 1805370 3500   Kokomo School Corporation 180537000943 2947 Boulevard Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         23.0 29.0                       52.0                         23 29                 52
1791228 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         162.0 157.0                       319.0                         162 157                 319
1791240 IN     school 1805370 3500   Kokomo School Corporation 180537000950 2969 Lafayette Park Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         31.0 29.0                       60.0                         31 29                 60
1791248 IN     school 1805370 3500   Kokomo School Corporation 180537000956 2993 Pettit Park School   Regular School No Elementary PK 05 2018   pre_kindergarten                         20.0 17.0                       37.0                         20 17                 37
1793035 IN     school 1805580 4945   LaPorte Community School Corp 180558002338 4707 Indian Trail Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         26.0 15.0                       41.0                         26 15                 41
1793047 IN     school 1805580 4945   LaPorte Community School Corp 180558001014 4721 Kingsford Heights Elementary Sch   Regular School No Elementary PK 05 2018   pre_kindergarten                         13.0 13.0                       26.0                         13 13                 26
1793055 IN     school 1805580 4945   LaPorte Community School Corp 180558001013 4727 Kingsbury Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         18.0 18.0                       36.0                         18 18                 36
1793062 IN     school 1805580 4945   LaPorte Community School Corp 180558001015 4741 LaPorte High School   Regular School No High 09 12 2018   pre_kindergarten                         101.0 66.0                       167.0                         101 66                 167
1793074 IN     school 1805580 4945   LaPorte Community School Corp 180558001010 4749 Hailmann Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         13.0 22.0                       35.0                         13 22                 35
1793082 IN     school 1805580 4945   LaPorte Community School Corp 180558001009 4753 F Willard Crichfield Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                         21.0 20.0                       41.0                         21 20                 41
1793090 IN     school 1805580 4945   LaPorte Community School Corp 180558001016 4757 Lincoln Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         15.0 17.0                       32.0                         15 17                 32
1793098 IN     school 1805580 4945   LaPorte Community School Corp 180558001020 4767 Riley Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         12.0 22.0                       34.0                         12 22                 34
1797199 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No Prekindergarten PK PK 2018   pre_kindergarten                         148.0 65.0                       213.0                         148 65                 213
1792286 IN     school 1805450 4615   Lake Central School Corporation 180545000980 3839 George Bibich Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         26.0 11.0                       37.0                         26 11                 37
1792293 IN     school 1805450 4615   Lake Central School Corporation 180545000981 3840 James H Watson Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         67.0 36.0                       103.0                         67 36                 103
1792311 IN     school 1805450 4615   Lake Central School Corporation 180545002143 4349 Homan Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten                         10.0 1.0                       11.0                         10 1                 11
1788845 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2018   pre_kindergarten                         16.0 5.0                       21.0                         16 5                 21
1788267 IN     school 1810680 815   Lewis Cass Schools 181068002169 695 Lewis Cass Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         2.0 3.0                       5.0                         2 3                 5
1788290 IN     school 1806030 875   Logansport Community Sch Corp 180603001055 709 Fairview Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         36.0 21.0                       57.0                         36 21                 57
1788298 IN     school 1806030 875   Logansport Community Sch Corp 180603002366 711 Landis Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten                         18.0 21.0                       39.0                         18 21                 39

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