Data source: Big Local News · About: Big Local

462 rows where grade = "pre_kindergarten", state = "IN" and year = 2019 sorted by district

View and edit SQL

year

  • 2019 · 362

grade

  • pre_kindergarten · 362
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
1751825 IN     school 1803630 235   Fort Wayne Community Schools 180363000519 151 Bunche Elementary School   Regular School No Elementary PK KG 2019   pre_kindergarten                         74.0 84.0                       158.0                         74 84                 158
1751833 IN     school 1803630 235   Fort Wayne Community Schools 180363000518 153 Brentwood Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         35.0 17.0                       52.0                         35 17                 52
1751848 IN     school 1803630 235   Fort Wayne Community Schools 180363000522 157 Forest Park Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         25.0 20.0                       45.0                         25 20                 45
1751856 IN     school 1803630 235   Fort Wayne Community Schools 180363000525 161 Franke Park Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         21.0 13.0                       34.0                         21 13                 34
1751871 IN     school 1803630 235   Fort Wayne Community Schools 180363000533 164 J Wilbur Haley Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         8.0 2.0                       10.0                         8 2                 10
1751884 IN     school 1803630 235   Fort Wayne Community Schools 180363000530 178 Harrison Hill Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         26.0 21.0                       47.0                         26 21                 47
1751892 IN     school 1803630 235   Fort Wayne Community Schools 180363000543 186 Mabel K Holland Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         27.0 8.0                       35.0                         27 8                 35
1751900 IN     school 1803630 235   Fort Wayne Community Schools 180363000532 189 Indian Village Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         19.0 13.0                       32.0                         19 13                 32
1751915 IN     school 1803630 235   Fort Wayne Community Schools 180363000541 197 Lindley Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         16.0 12.0                       28.0                         16 12                 28
1751923 IN     school 1803630 235   Fort Wayne Community Schools 180363000544 205 Maplewood Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         28.0 14.0                       42.0                         28 14                 42
1751938 IN     school 1803630 235   Fort Wayne Community Schools 180363000551 217 Northcrest Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         22.0 22.0                       44.0                         22 22                 44
1751951 IN     school 1803630 235   Fort Wayne Community Schools 180363000524 221 Francis M Price Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 5.0                       16.0                         11 5                 16
1751972 IN     school 1803630 235   Fort Wayne Community Schools 180363001541 241 Whitney M Young Early Childhood   Regular School No Elementary PK KG 2019   pre_kindergarten                         42.0 58.0                       100.0                         42 58                 100
1751980 IN     school 1803630 235   Fort Wayne Community Schools 180363000564 249 Levan R Scott Academy   Regular School No Elementary PK 05 2019   pre_kindergarten                         17.0 14.0                       31.0                         17 14                 31
1751988 IN     school 1803630 235   Fort Wayne Community Schools 180363000563 253 South Wayne Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         18.0 14.0                       32.0                         18 14                 32
1751996 IN     school 1803630 235   Fort Wayne Community Schools 180363000948 257 Study Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 10.0                       20.0                         10 10                 20
1752004 IN     school 1803630 235   Fort Wayne Community Schools 180363000567 265 Washington Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         20.0 11.0                       31.0                         20 11                 31
1752026 IN     school 1803630 235   Fort Wayne Community Schools 180363000569 273 Waynedale Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         17.0 16.0                       33.0                         17 16                 33
1756026 IN     school 1803690 4225   Franklin Community School Corp 180369000584 3461 Northwood Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         32.0 11.0                       43.0                         32 11                 43
1754100 IN     school 1803700 2475   Franklin County Community Sch Corp 180370002221 2082 Laurel School   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 13.0                       22.0                         9 13                 22
1754117 IN     school 1803700 2475   Franklin County Community Sch Corp 180370000587 2125 Brookville Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         8.0 8.0                       16.0                         8 8                 16
1757640 IN     school 1803750 5310   Franklin Township Com Sch Corp 180375002409 5194 South Creek Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         52.0 29.0                       81.0                         52 29                 81
1757430 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002049 5009 Frankton Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         28.0 38.0                       66.0                         28 38                 66
1757447 IN     school 1812880 5245   Frankton-Lapel Community Schools 181288002052 5025 Lapel Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         42.0 31.0                       73.0                         42 31                 73
1762553 IN     school 1803810 8525   Frontier School Corporation 180381000604 9113 Frontier Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                         8.0 0.0                       8.0                         8 0                 8
1756739 IN     school 1803870 4690   Gary Community School Corp 180387000640 4057 Mary M Bethune Early Child Dev Ctr   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         156.0 183.0                       339.0                         156 183                 339
1753891 IN     school 1803930 2315   Goshen Community Schools 180393002180 1847 Prairie View Elementary School   Regular School No Elementary PK 07 2019   pre_kindergarten                         34.0 35.0                       69.0                         34 35                 69
1752645 IN     school 1803940 1010   Greater Clark County Schools 180394000682 755 W E Wilson Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         19.0 11.0                       30.0                         19 11                 30
1752653 IN     school 1803940 1010   Greater Clark County Schools 180394000680 761 Thomas Jefferson Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         12.0 15.0                       27.0                         12 15                 27
1752661 IN     school 1803940 1010   Greater Clark County Schools 180394000673 801 Northaven Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         18.0 7.0                       25.0                         18 7                 25
1752669 IN     school 1803940 1010   Greater Clark County Schools 180394000681 805 Utica Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         12.0 13.0                       25.0                         12 13                 25
1752677 IN     school 1803940 1010   Greater Clark County Schools 180394000671 807 New Washington Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         19.0 8.0                       27.0                         19 8                 27
1752699 IN     school 1803940 1010   Greater Clark County Schools 180394000676 829 Pleasant Ridge Elementary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         23.0 18.0                       41.0                         23 18                 41
1752720 IN     school 1803940 1010   Greater Clark County Schools 180394000665 865 Bridgepoint Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         16.0 10.0                       26.0                         16 10                 26
1752735 IN     school 1803940 1010   Greater Clark County Schools 180394000677 871 Riverside Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         16.0 13.0                       29.0                         16 13                 29
1752743 IN     school 1803940 1010   Greater Clark County Schools 180394000679 877 Spring Hill Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         10.0 11.0                       21.0                         10 11                 21
1752751 IN     school 1803940 1010   Greater Clark County Schools 180394000675 879 Parkwood Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         16.0 13.0                       29.0                         16 13                 29
1753517 IN     school 1803960 2120   Greater Jasper Consolidated Schs 180396000683 1597 Fifth Street Elementary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         12.0 11.0                       23.0                         12 11                 23
1760246 IN     school 1803990 6755   Greencastle Community School Corp 180399001625 7107 Deer Meadow Primary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         32.0 27.0                       59.0                         32 27                 59
1753159 IN     school 1804080 1730   Greensburg Community Schools 180408002056 1270 Greensburg Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         24.0 7.0                       31.0                         24 7                 31
1756063 IN     school 1804110 4245   Greenwood Community Sch Corp 180411000670 3479 Westwood Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         30.0 16.0                       46.0                         30 16                 46
1756808 IN     school 1804170 4700   Griffith Public Schools 180417000718 4185 Eldon Ready Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         26.0 14.0                       40.0                         26 14                 40
1754561 IN     school 1804260 3025   Hamilton Heights School Corp 180426001653 2502 Hamilton Heights Primary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         50.0 31.0                       81.0                         50 31                 81
1756410 IN     school 1804350 4580   Hanover Community School Corp 180435000754 3781 Jane Ball Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         24.0 4.0                       28.0                         24 4                 28
1755566 IN     school 1804710 3625   Huntington Co Com Sch Corp 180471002598 3078 Huntington Schools Preschool   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         72.0 51.0                       123.0                         72 51                 123
1763088 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 2019   pre_kindergarten                         0.0 5.0                       5.0                         0 5                 5
1763103 IN     school 1800024 9610   Indiana School For The Deaf 180002402258 C695 Indiana School For The Deaf   Special Education School No Other PK 12 2019   pre_kindergarten                         12.0 14.0                       26.0                         12 14                 26
1758327 IN     school 1804770 5385   Indianapolis Public Schools 180477000896 5515 Thomas D Gregg School 15   Regular School No Elementary PK 06 2019   pre_kindergarten                         13.0 4.0                       17.0                         13 4                 17
1758349 IN     school 1804770 5385   Indianapolis Public Schools 180477000821 5534 Eleanor Skillen School 34   Regular School No Elementary PK 06 2019   pre_kindergarten                         20.0 18.0                       38.0                         20 18                 38
1758367 IN     school 1804770 5385   Indianapolis Public Schools 180477000903 5539 William McKinley School 39   Regular School No Elementary PK 06 2019   pre_kindergarten                         17.0 21.0                       38.0                         17 21                 38
1758378 IN     school 1804770 5385   Indianapolis Public Schools 180477000854 5543 James Whitcomb Riley School 43   Regular School No Elementary PK 08 2019   pre_kindergarten                         15.0 10.0                       25.0                         15 10                 25
1758382 IN     school 1804770 5385   Indianapolis Public Schools 180477000885 5544 Riverside School 44   Regular School No Middle 05 06 2019   pre_kindergarten                         25.0 22.0                       47.0                         25 22                 47
1758401 IN     school 1804770 5385   Indianapolis Public Schools 180477000867 5548 Louis B Russell Jr School 48   Regular School No Elementary PK 06 2019   pre_kindergarten                         17.0 14.0                       31.0                         17 14                 31
1758412 IN     school 1804770 5385   Indianapolis Public Schools 180477000904 5549 William Penn School 49   Regular School No Elementary PK 08 2019   pre_kindergarten                         12.0 7.0                       19.0                         12 7                 19
1758421 IN     school 1804770 5385   Indianapolis Public Schools 180477002404 5551 James Russell Lowell School 51   Regular School No Elementary PK 06 2019   pre_kindergarten                         12.0 8.0                       20.0                         12 8                 20
1758438 IN     school 1804770 5385   Indianapolis Public Schools 180477000822 5555 IPS/ Butler Eliza Blaker School 55   Regular School No Elementary PK 06 2019   pre_kindergarten                         8.0 9.0                       17.0                         8 9                 17
1758449 IN     school 1804770 5385   Indianapolis Public Schools 180477000831 5556 Francis W Parker School 56   Regular School No Elementary PK 08 2019   pre_kindergarten                         16.0 15.0                       31.0                         16 15                 31
1758468 IN     school 1804770 5385   Indianapolis Public Schools 180477000883 5558 Ralph Waldo Emerson School 58   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 6.0                       15.0                         9 6                 15
1758479 IN     school 1804770 5385   Indianapolis Public Schools 180477000901 5560 IPS/ Butler Lab @ William Bell 60   Regular School No Elementary PK 08 2019   pre_kindergarten                         11.0 10.0                       21.0                         11 10                 21
1758488 IN     school 1804770 5385   Indianapolis Public Schools 180477000884 5565 Raymond F Brandes School 65   Regular School No Elementary PK 06 2019   pre_kindergarten                         8.0 14.0                       22.0                         8 14                 22
1758499 IN     school 1804770 5385   Indianapolis Public Schools 180477000890 5567 Stephen Foster School 67   Regular School No Elementary PK 08 2019   pre_kindergarten                         33.0 19.0                       52.0                         33 19                 52
1758553 IN     school 1804770 5385   Indianapolis Public Schools 180477000829 5583 Floro Torrence School 83   Regular School No Elementary PK 06 2019   pre_kindergarten                         22.0 10.0                       32.0                         22 10                 32
1758564 IN     school 1804770 5385   Indianapolis Public Schools 180477002555 5587 George Washington Carver School 87   Regular School No Elementary PK 08 2019   pre_kindergarten                         26.0 35.0                       61.0                         26 35                 61
1758573 IN     school 1804770 5385   Indianapolis Public Schools 180477000797 5588 Anna Brochhausen School 88   Regular School No Elementary PK 06 2019   pre_kindergarten                         8.0 5.0                       13.0                         8 5                 13
1758582 IN     school 1804770 5385   Indianapolis Public Schools 180477000826 5590 Ernie Pyle School 90   Regular School No Elementary PK 06 2019   pre_kindergarten                         7.0 13.0                       20.0                         7 13                 20
1758593 IN     school 1804770 5385   Indianapolis Public Schools 180477002277 5591 Rousseau McClellan School 91   Regular School No Elementary PK 08 2019   pre_kindergarten                         8.0 11.0                       19.0                         8 11                 19
1758610 IN     school 1804770 5385   Indianapolis Public Schools 180477000873 5596 Meredith Nicholson School 96   Regular School No Elementary PK 06 2019   pre_kindergarten                         12.0 29.0                       41.0                         12 29                 41
1758623 IN     school 1804770 5385   Indianapolis Public Schools 180477000833 5602 Francis Bellamy Pre-School Center   Regular School No Prekindergarten PK PK 2019   pre_kindergarten                         70.0 66.0                       136.0                         70 66                 136
1758648 IN     school 1804770 5385   Indianapolis Public Schools 180477000887 5606 Robert Lee Frost School 106   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 9.0                       18.0                         9 9                 18
1758657 IN     school 1804770 5385   Indianapolis Public Schools 180477000864 5607 Lew Wallace School 107   Regular School No Elementary PK 06 2019   pre_kindergarten                         2.0 3.0                       5.0                         2 3                 5
1758666 IN     school 1804770 5385   Indianapolis Public Schools 180477000858 5609 Jonathan Jennings School 109   Regular School No Elementary PK 06 2019   pre_kindergarten                         2.0 0.0                       2.0                         2 0                 2
1758675 IN     school 1804770 5385   Indianapolis Public Schools 180477000882 5614 Paul I Miller School 114   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 1.0                       10.0                         9 1                 10
1758692 IN     school 1804770 5385   Indianapolis Public Schools 180477001427 5623 Arlington Woods School 99   Regular School No Elementary PK 06 2019   pre_kindergarten                         9.0 8.0                       17.0                         9 8                 17
1758726 IN     school 1804770 5385   Indianapolis Public Schools 180477002393 5662 Clarence Farrington School 61   Regular School No Elementary PK 06 2019   pre_kindergarten                         18.0 43.0                       61.0                         18 43                 61
1758737 IN     school 1804770 5385   Indianapolis Public Schools 180477002510 5668 Center for Inquiry School 27   Regular School No Elementary PK 08 2019   pre_kindergarten                         59.0 35.0                       94.0                         59 35                 94
1758748 IN     school 1804770 5385   Indianapolis Public Schools 180477002395 5674 Frederick Douglass School 19   Regular School No Elementary PK 08 2019   pre_kindergarten                         4.0 4.0                       8.0                         4 4                 8
1760407 IN     school 1804800 6900   Jac-Cen-Del Community Sch Corp 180480002353 7203 Jac-Cen-Del Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         14.0 5.0                       19.0                         14 5                 19
1755838 IN     school 1805190 4015   Jennings County School Corporation 180519001417 3349 Sand Creek Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         20.0 8.0                       28.0                         20 8                 28
1760492 IN     school 1809120 7150   John Glenn School Corporation 180912001506 7457 Walkerton Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten                         24.0 23.0                       47.0                         24 23                 47
1755690 IN     school 1805280 3785   Kankakee Valley School Corp 180528000932 3184 DeMotte Elementary School   Regular School No Elementary PK 03 2019   pre_kindergarten                         16.0 10.0                       26.0                         16 10                 26
1761167 IN     school 1805340 7525   Knox Community School Corp 180534000940 7845 Knox Community Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         44.0 20.0                       64.0                         44 20                 64
1755458 IN     school 1805370 3500   Kokomo School Corporation 180537000959 2943 Sycamore Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         16.0 20.0                       36.0                         16 20                 36
1755466 IN     school 1805370 3500   Kokomo School Corporation 180537000942 2945 Bon Air Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         20.0 19.0                       39.0                         20 19                 39
1755474 IN     school 1805370 3500   Kokomo School Corporation 180537000943 2947 Boulevard Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         27.0 29.0                       56.0                         27 29                 56
1755490 IN     school 1805370 3500   Kokomo School Corporation 180537000946 2961 Elwood Haynes Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         150.0 138.0                       288.0                         150 138                 288
1755502 IN     school 1805370 3500   Kokomo School Corporation 180537000950 2969 Lafayette Park Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         26.0 25.0                       51.0                         26 25                 51
1755510 IN     school 1805370 3500   Kokomo School Corporation 180537000956 2993 Pettit Park School   Regular School No Elementary PK 05 2019   pre_kindergarten                         26.0 21.0                       47.0                         26 21                 47
1757243 IN     school 1805580 4945   LaPorte Community School Corp 180558002338 4707 Indian Trail Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         25.0 14.0                       39.0                         25 14                 39
1757255 IN     school 1805580 4945   LaPorte Community School Corp 180558001014 4721 Kingsford Heights Elementary Sch   Regular School No Elementary PK 05 2019   pre_kindergarten                         7.0 16.0                       23.0                         7 16                 23
1757263 IN     school 1805580 4945   LaPorte Community School Corp 180558001013 4727 Kingsbury Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         13.0 26.0                       39.0                         13 26                 39
1757270 IN     school 1805580 4945   LaPorte Community School Corp 180558001015 4741 LaPorte High School   Regular School No High 09 12 2019   pre_kindergarten                         65.0 54.0                       119.0                         65 54                 119
1757282 IN     school 1805580 4945   LaPorte Community School Corp 180558001010 4749 Hailmann Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         16.0 19.0                       35.0                         16 19                 35
1757290 IN     school 1805580 4945   LaPorte Community School Corp 180558001009 4753 F Willard Crichfield Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten                         22.0 20.0                       42.0                         22 20                 42
1757298 IN     school 1805580 4945   LaPorte Community School Corp 180558001016 4757 Lincoln Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         11.0 16.0                       27.0                         11 16                 27
1757306 IN     school 1805580 4945   LaPorte Community School Corp 180558001020 4767 Riley Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten                         19.0 14.0                       33.0                         19 14                 33
1761383 IN     school 1805400 7855   Lafayette School Corporation 180540000966 8125 Greater Lafayette Area SE   Special Education School No Prekindergarten PK PK 2019   pre_kindergarten                         164.0 79.0                       243.0                         164 79                 243
1756521 IN     school 1805450 4615   Lake Central School Corporation 180545000980 3839 George Bibich Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         37.0 15.0                       52.0                         37 15                 52
1756528 IN     school 1805450 4615   Lake Central School Corporation 180545000981 3840 James H Watson Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         73.0 31.0                       104.0                         73 31                 104
1756546 IN     school 1805450 4615   Lake Central School Corporation 180545002143 4349 Homan Elementary School   Regular School No Elementary PK 04 2019   pre_kindergarten                         9.0 3.0                       12.0                         9 3                 12
1753106 IN     school 1805700 1620   Lawrenceburg Community School Corp 180570001695 1210 Lawrenceburg Primary School   Regular School No Elementary PK 02 2019   pre_kindergarten                         29.0 8.0                       37.0                         29 8                 37

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