Data source: Big Local News · About: Big Local

818 rows where grade = "grade_3" and state = "MS"

View and edit SQL

year

grade

  • grade_3 · 718
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
2035068 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000296 2400044 PINEVILLE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_3                                                   17                                             17
2035076 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177001431 2400046 RIVER OAKS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_3                                                   101                                             101
2035084 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000297 2400048 SAUCIER ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_3                                                   63                                             63
2035092 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000913 2400050 THREE RIVERS ELEMENTARY   Regular School No Elementary KG 06 2020   grade_3                                                   88                                             88
2035100 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000959 2400051 WEST WORTHAM ELEMENTARY AND MIDDLE   Regular School No Elementary KG 08 2020   grade_3                                                   118                                             118
2035110 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000298 2400052 WOOLMARKET ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_3                                                   48                                             48
2035137 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063001234 2420014 NORTH BAY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_3                                                   142                                             142
2035143 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063000055 2420016 JEFF DAVIS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_3                                                   124                                             124
2035148 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063000058 2420024 GORENFLO ELEMENTARY SCHOOL   Regular School No Elementary 02 04 2020   grade_3                                                   100                                             100
2035162 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063000063 2420044 POPPS FERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_3                                                   129                                             129
2035168 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000268 2421004 ANNISTON AVENUE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   106                                             106
2035176 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000269 2421008 BAYOU VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   97                                             97
2035188 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000271 2421014 CENTRAL ELEM   Regular School No Elementary KG 05 2020   grade_3                                                   85                                             85
2035206 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000277 2421060 PASS ROAD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   59                                             59
2035215 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000279 2421064 WEST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   100                                             100
2035223 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171001349 2421072 TWENTY EIGHTH ST ELEM   Regular School No Elementary PK 05 2020   grade_3                                                   65                                             65
2035236 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000518 2422008 THOMAS L REEVES ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_3                                                   111                                             111
2035252 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000521 2422020 WJ QUARLES ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_3                                                   *                                              
2035259 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000682 2423004 DELISLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   65                                             65
2035268 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000683 2423008 PASS CHRISTIAN ELEM   Regular School No Elementary PK 05 2020   grade_3                                                   60                                             60
2035299 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000983 2500024 GARY ROAD INTERMEDIATE SCHOOL   Regular School No Elementary 03 05 2020   grade_3                                                   273                                             273
2035308 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000326 2500028 UTICA ELEM. / MIDDLE SCHOOL   Regular School No Elementary PK 08 2020   grade_3                                                   33                                             33
2035333 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000961 2500042 RAYMOND ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   72                                             72
2035342 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000984 2500044 BOLTON-EDWARDS ELEM./MIDDLE SCHOOL   Regular School No Elementary PK 08 2020   grade_3                                                   48                                             48
2035362 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001052 2520004 BARACK H OBAMA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   41                                             41
2035374 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000370 2520007 BAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   37                                             37
2035382 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000371 2520008 BARR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   28                                             28
2035394 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_3                                                   113                                             113
2035413 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   65                                             65
2035426 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   45                                             45
2035435 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   50                                             50
2035450 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   92                                             92
2035458 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   86                                             86
2035479 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000392 2520040 JOHN HOPKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   63                                             63
2035486 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000391 2520041 ISABLE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   86                                             86
2035496 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000393 2520042 JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   68                                             68
2035504 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001364 2520043 BATES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   71                                             71
2035513 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000394 2520045 KEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   41                                             41
2035523 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000395 2520047 LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   58                                             58
2035537 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000397 2520050 LEE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   40                                             40
2035544 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000398 2520051 LESTER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   45                                             45
2035557 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000399 2520053 MARSHALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   50                                             50
2035571 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000400 2520056 MC LEOD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   98                                             98
2035579 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001242 2520057 MCWILLIE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   30                                             30
2035589 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001054 2520058 NORTH JACKSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   93                                             93
2035602 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000404 2520061 OAK FOREST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   71                                             71
2035629 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000410 2520069 RAINES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   59                                             59
2035643 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000413 2520077 SMITH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   59                                             59
2035651 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000414 2520078 SPANN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   75                                             75
2035659 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000416 2520079 TIMBERLAWN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   96                                             96
2035667 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000415 2520080 SYKES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   72                                             72
2035676 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000418 2520081 WALTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   55                                             55
2035685 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000417 2520082 VAN WINKLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   52                                             52
2035693 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000419 2520083 WATKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   58                                             58
2035702 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000420 2520084 PECAN PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   72                                             72
2035720 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000422 2520087 WILKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   102                                             102
2035754 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000136 2521016 NORTHSIDE ELEM   Regular School No Elementary 02 03 2020   grade_3                                                   410                                             410
2035776 MS     school 2801189 2560   MS SCH FOR THE BLIND AND DEAF 280118901504 2560002 MS SCHOOL FOR THE DEAF   Special Education School No Other KG 12 2020   grade_3                                                   *                                              
2035789 MS     school 2801189 2560   MS SCH FOR THE BLIND AND DEAF 280118901194 2560004 MS SCHOOL FOR THE BLIND   Special Education School No Other 01 12 2020   grade_3                                                   *                                              
2035804 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501495 2611004 DURANT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   58                                             58
2035815 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501503 2611008 GOODMAN PICKENS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   45                                             45
2035828 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501496 2611018 WILLIAM DEAN JR. ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   108                                             108
2035836 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501486 2611024 S V MARSHALL ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2020   grade_3                                                   55                                             55
2035847 MS     school 2802040 2700   HUMPHREYS CO SCHOOL DIST 280204000349 2700004 IDA GREENE LOWER ELEMENTARY   Regular School No Elementary KG 04 2020   grade_3                                                   127                                             127
2035867 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000356 2900004 DORSEY ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   grade_3                                                   36                                             36
2035877 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000357 2900008 FAIRVIEW ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   grade_3                                                   13                                             13
2035889 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000358 2900012 ITAWAMBA ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   grade_3                                                   112                                             112
2035900 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_3                                                   78                                             78
2035916 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000362 2900028 TREMONT ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_3                                                   18                                             18
2035936 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001044 3000002 EAST CENTRAL UPPER ELEMENTARY   Regular School No Elementary 03 05 2020   grade_3                                                   *                                              
2035959 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000366 3000010 ST MARTIN N ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_3                                                   161                                             161
2035977 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001048 3000014 ST MARTIN EAST ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   grade_3                                                   175                                             175
2035980 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000368 3000016 VANCLEAVE UPPER ELEMENTARY   Regular School No Elementary 03 05 2020   grade_3                                                   170                                             170
2036024 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000589 3020012 MOSS POINT ESCATAWPA UPPER ELEM   Regular School No Elementary 03 05 2020   grade_3                                                   135                                             135
2036047 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000647 3021004 OAK PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_3                                                   140                                             140
2036059 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000648 3021008 MAGNOLIA PARK ELEMENTARY   Regular School No Elementary KG 03 2020   grade_3                                                   137                                             137
2036076 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000652 3021024 PECAN PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_3                                                   149                                             149
2036083 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000666 3022004 ARLINGTON HEIGHTS ELEM SCHOOL   Regular School No Elementary PK 04 2020   grade_3                                                   55                                             55
2036089 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000667 3022008 BEACH ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_3                                                   18                                             18
2036098 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000668 3022012 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_3                                                   45                                             45
2036104 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000669 3022016 CHEROKEE ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_3                                                   44                                             44
2036114 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000670 3022020 COLLEGE PARK ELEM   Regular School No Elementary PK 04 2020   grade_3                                                   53                                             53
2036125 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000672 3022028 EASTLAWN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_3                                                   54                                             54
2036133 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000674 3022036 GAUTIER ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_3                                                   82                                             82
2036149 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000676 3022044 JACKSON ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_3                                                   50                                             50
2036155 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000677 3022048 LAKE ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_3                                                   24                                             24
2036162 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348001236 3022050 MARTIN BLUFF   Regular School No Elementary PK 04 2020   grade_3                                                   81                                             81
2036191 MS     school 2801380 3111   EAST JASPER CONSOLIDATED SCH DIST 280138000205 3111008 WILLIAM J BERRY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   59                                             59
2036203 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000858 3112004 BAY SPRINGS ELEM SCH   Regular School No Elementary KG 05 2020   grade_3                                                   73                                             73
2036221 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000859 3112012 STRINGER ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_3                                                   45                                             45
2036237 MS     school 2802220 3200   JEFFERSON CO SCHOOL DIST 280222000426 3200004 JEFFERSON CO ELEM SCHOOL   Regular School No Elementary PK 04 2020   grade_3                                                   85                                             85
2036256 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000430 3300004 CARVER ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2020   grade_3                                                   45                                             45
2036273 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000432 3300012 J E JOHNSON ELEMENTARY   Regular School No Elementary KG 08 2020   grade_3                                                   55                                             55
2036287 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000439 3400012 GLADE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   51                                             51
2036299 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000441 3400016 MOSELLE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   67                                             67
2036311 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000985 3400022 EAST JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   98                                             98
2036330 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228001326 3400026 NORTH JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   128                                             128
2036342 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000986 3400034 SOUTH JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_3                                                   149                                             149
2036360 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228001237 3400050 WEST JONES ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_3                                                   150                                             150
2036377 MS     school 2802460 3420   LAUREL SCHOOL DISTRICT 280246000472 3420004 LAUREL MAGNET SCHOOL OF THE ARTS   Regular School No Elementary PK 05 2020   grade_3                                                   38                                             38

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