enrollments

Data source: Big Local News · About: Big Local

442 rows where grade = "elementary_spec_ed", state = "MS" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 342 ✖

grade ✖

  • elementary_spec_ed · 342 ✖
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
2241298 2241298 MS     school 2801530 1900   FRANKLIN CO SCHOOL DIST 280153001110 1900006 FRANKLIN UPPER ELEMENTARY   Regular School No Middle 04 06 2021   elementary_spec_ed                                                   *                                              
2241303 2241303 MS     school 2801530 1900   FRANKLIN CO SCHOOL DIST 280153001111 1900008 FRANKLIN COUNTY MIDDLE SCHOOL   Regular School No Middle 07 08 2021   elementary_spec_ed                                                   *                                              
2241316 2241316 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000226 2000004 AGRICOLA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   elementary_spec_ed                                                   *                                              
2241326 2241326 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000981 2000006 BENNDALE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   elementary_spec_ed                                                   *                                              
2241338 2241338 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000227 2000008 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   elementary_spec_ed                                                   13                                             13
2241360 2241360 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000229 2000016 LC HATCHER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   elementary_spec_ed                                                   *                                              
2241364 2241364 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000870 2000018 LT TAYLOR INTERMEDIATE SCHOOL   Regular School No Middle 03 07 2021   elementary_spec_ed                                                   11                                             11
2241373 2241373 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000231 2000024 ROCKY CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   elementary_spec_ed                                                   *                                              
2241383 2241383 MS     school 2801590 2100   GREENE COUNTY SCHOOL DISTRICT 280159001031 2100002 LEAKESVILLE ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   elementary_spec_ed                                                   *                                              
2241389 2241389 MS     school 2801590 2100   GREENE COUNTY SCHOOL DISTRICT 280159001134 2100004 LEAKESVILLE JR HIGH SCHOOL   Regular School No Middle 05 08 2021   elementary_spec_ed                                                   *                                              
2241406 2241406 MS     school 2801590 2100   GREENE COUNTY SCHOOL DISTRICT 280159000234 2100012 SAND HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2021   elementary_spec_ed                                                   *                                              
2241429 2241429 MS     school 2801680 2220   GRENADA SCHOOL DIST 280168000264 2220012 GRENADA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   12                                             12
2241438 2241438 MS     school 2801680 2220   GRENADA SCHOOL DIST 280168000900 2220032 GRENADA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   32                                             32
2241487 2241487 MS     school 2800570 2320   BAY ST LOUIS WAVELAND SCHOOL DIST 280057001233 2320007 Bay Waveland Middle School   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   *                                              
2241498 2241498 MS     school 2800570 2320   BAY ST LOUIS WAVELAND SCHOOL DIST 280057000046 2320012 NORTH BAY ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2021   elementary_spec_ed                                                   *                                              
2241505 2241505 MS     school 2800570 2320   BAY ST LOUIS WAVELAND SCHOOL DIST 280057001376 2320016 WAVELAND ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   elementary_spec_ed                                                   *                                              
2241553 2241553 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000289 2400020 HARRISON CO CHILD DEVELOPMENT CEN   Regular School No Ungraded UG UG 2021   elementary_spec_ed                                                   *                                              
2241654 2241654 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063001478 2420010 BILOXI UPPER ELEMENTARY   Regular School No Middle 05 06 2021   elementary_spec_ed                                                   22                                             22
2241670 2241670 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063000058 2420024 GORENFLO ELEMENTARY SCHOOL   Regular School No Elementary 02 04 2021   elementary_spec_ed                                                   13                                             13
2241678 2241678 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063001263 2420042 NICHOLS ELEMENTARY SCHOOL   Regular School No Elementary PK 01 2021   elementary_spec_ed                                                   *                                              
2241682 2241682 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063000063 2420044 POPPS FERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   elementary_spec_ed                                                   *                                              
2241696 2241696 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000269 2421008 BAYOU VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   elementary_spec_ed                                                   *                                              
2241715 2241715 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000272 2421016 GULFPORT CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   19                                             19
2241736 2241736 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000279 2421064 WEST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2241751 2241751 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000517 2422004 HARPER MC CAUGHAN ELEM SCHOOL   Regular School No Middle 04 06 2021   elementary_spec_ed                                                   *                                              
2241757 2241757 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000518 2422008 THOMAS L REEVES ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   elementary_spec_ed                                                   *                                              
2241762 2241762 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000519 2422012 LONG BEACH MIDDLE SCHOOL   Regular School No Middle 07 08 2021   elementary_spec_ed                                                   *                                              
2241773 2241773 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000521 2422020 WJ QUARLES ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   elementary_spec_ed                                                   *                                              
2241780 2241780 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000682 2423004 DELISLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2241789 2241789 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000683 2423008 PASS CHRISTIAN ELEM   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2241803 2241803 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000685 2423016 PASS CHRISTIAN MIDDLE   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   *                                              
2241816 2241816 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000321 2500008 BYRAM MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   *                                              
2241821 2241821 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000322 2500012 CARVER MIDDLE SCHOOL   Regular School No Middle 07 08 2021   elementary_spec_ed                                                   *                                              
2241827 2241827 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186001036 2500020 GARY ROAD ELEMENTARY   Regular School No Elementary PK 02 2021   elementary_spec_ed                                                   *                                              
2241831 2241831 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000983 2500024 GARY ROAD INTERMEDIATE SCHOOL   Regular School No Elementary 03 05 2021   elementary_spec_ed                                                   *                                              
2241838 2241838 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000326 2500028 UTICA ELEM. / MIDDLE SCHOOL   Regular School No Elementary PK 08 2021   elementary_spec_ed                                                   *                                              
2241863 2241863 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000961 2500042 RAYMOND ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   elementary_spec_ed                                                   *                                              
2241873 2241873 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000984 2500044 BOLTON-EDWARDS ELEM./MIDDLE SCHOOL   Regular School No Elementary PK 08 2021   elementary_spec_ed                                                   *                                              
2241888 2241888 MS     school 2800188 2515   REIMAGINE PREP 280018801442 2515004 REIMAGINE PREP   Regular School Yes Middle 05 08 2021   elementary_spec_ed                                                   *                                              
2241913 2241913 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000372 2520010 BLACKBURN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   21                                             21
2241919 2241919 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   elementary_spec_ed                                                   *                                              
2241926 2241926 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000375 2520014 BRINKLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   13                                             13
2241938 2241938 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   elementary_spec_ed                                                   *                                              
2241945 2241945 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000380 2520023 CHASTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   12                                             12
2241952 2241952 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2241975 2241975 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2241999 2241999 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000392 2520040 JOHN HOPKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2242007 2242007 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000391 2520041 ISABLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2242016 2242016 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000393 2520042 JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2242024 2242024 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001364 2520043 BATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   16                                             16
2242074 2242074 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000399 2520053 MARSHALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2242081 2242081 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001365 2520055 KIRKSEY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   *                                              
2242089 2242089 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000400 2520056 MC LEOD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   elementary_spec_ed                                                   *                                              
2242106 2242106 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001054 2520058 NORTH JACKSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2242126 2242126 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000405 2520062 PEEPLES MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   *                                              
2242131 2242131 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000407 2520065 POWELL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   *                                              
2242147 2242147 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000410 2520069 RAINES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2242156 2242156 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000413 2520077 SMITH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2242164 2242164 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000414 2520078 SPANN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   elementary_spec_ed                                                   *                                              
2242180 2242180 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000415 2520080 SYKES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   elementary_spec_ed                                                   *                                              
2242189 2242189 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000418 2520081 WALTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2242208 2242208 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000420 2520084 PECAN PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2242215 2242215 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001370 2520085 CARDOZO MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   22                                             22
2242220 2242220 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000421 2520086 WHITTEN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   *                                              
2242227 2242227 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000422 2520087 WILKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   elementary_spec_ed                                                   *                                              
2242245 2242245 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000132 2521008 CLINTON JR HI SCHOOL   Regular School No Middle 07 08 2021   elementary_spec_ed                                                   *                                              
2242254 2242254 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000135 2521014 EASTSIDE ELEM   Regular School No Elementary 04 05 2021   elementary_spec_ed                                                   *                                              
2242258 2242258 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109001028 2521015 LOVETT ELEM SCHOOL   Regular School No Middle 06 06 2021   elementary_spec_ed                                                   *                                              
2242261 2242261 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000136 2521016 NORTHSIDE ELEM   Regular School No Elementary 02 03 2021   elementary_spec_ed                                                   *                                              
2242273 2242273 MS     school 2800192 2535   SMILOW PREP 280019201471 2535004 JOEL E. SMILOW PREP   Regular School Yes Middle 05 08 2021   elementary_spec_ed                                                   *                                              
2242285 2242285 MS     school 2801189 2560   MS SCH FOR THE BLIND AND DEAF 280118901504 2560002 MS SCHOOL FOR THE DEAF   Special Education School No Other PK 12 2021   elementary_spec_ed                                                   *                                              
2242367 2242367 MS     school 2802040 2700   HUMPHREYS CO SCHOOL DIST 280204001039 2700006 O M MC NAIR MIDDLE SCHOOL   Regular School No Middle 05 08 2021   elementary_spec_ed                                                   16                                             16
2242398 2242398 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000358 2900012 ITAWAMBA ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   elementary_spec_ed                                                   *                                              
2242409 2242409 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2021   elementary_spec_ed                                                   *                                              
2242446 2242446 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001044 3000002 EAST CENTRAL UPPER ELEMENTARY   Regular School No Elementary 03 05 2021   elementary_spec_ed                                                   *                                              
2242466 2242466 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000366 3000010 ST MARTIN N ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   elementary_spec_ed                                                   *                                              
2242477 2242477 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001047 3000013 ST MARTIN UPPER ELEMENTARY   Regular School No Elementary 04 05 2021   elementary_spec_ed                                                   *                                              
2242485 2242485 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001048 3000014 ST MARTIN EAST ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   elementary_spec_ed                                                   *                                              
2242490 2242490 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000368 3000016 VANCLEAVE UPPER ELEMENTARY   Regular School No Elementary 03 05 2021   elementary_spec_ed                                                   *                                              
2242495 2242495 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001049 3000018 VANCLEAVE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   *                                              
2242510 2242510 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000962 3000022 EAST CENTRAL LOWER ELEMENTARY   Regular School No Elementary PK 02 2021   elementary_spec_ed                                                   *                                              
2242514 2242514 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000963 3000024 ST. MARTIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   *                                              
2242524 2242524 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000964 3000026 VANCLEAVE LOWER ELEMENTARY   Regular School No Elementary PK 02 2021   elementary_spec_ed                                                   *                                              
2242534 2242534 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000589 3020012 MOSS POINT ESCATAWPA UPPER ELEM   Regular School No Elementary 03 05 2021   elementary_spec_ed                                                   *                                              
2242541 2242541 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000591 3020020 MOSS POINT KREOLE PRIMARY SCHOOL   Regular School No Elementary PK 02 2021   elementary_spec_ed                                                   *                                              
2242553 2242553 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000647 3021004 OAK PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   elementary_spec_ed                                                   *                                              
2242558 2242558 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336001392 3021006 OCEAN SPRINGS UPPER ELEMENTARY SCHO   Regular School No Middle 04 06 2021   elementary_spec_ed                                                   15                                             15
2242565 2242565 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000648 3021008 MAGNOLIA PARK ELEMENTARY   Regular School No Elementary KG 03 2021   elementary_spec_ed                                                   *                                              
2242582 2242582 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000652 3021024 PECAN PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   elementary_spec_ed                                                   *                                              
2242603 2242603 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000668 3022012 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   elementary_spec_ed                                                   22                                             22
2242619 2242619 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000670 3022020 COLLEGE PARK ELEM   Regular School No Elementary PK 04 2021   elementary_spec_ed                                                   19                                             19
2242643 2242643 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000675 3022040 GAUTIER MIDDLE SCHOOL   Regular School No Middle 07 08 2021   elementary_spec_ed                                                   *                                              
2242678 2242678 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000679 3022056 TRENT LOTT ACADEMY   Regular School No Middle 05 06 2021   elementary_spec_ed                                                   *                                              
2242682 2242682 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000680 3022058 SINGING RIVER ACADEMY   Regular School No Middle 05 06 2021   elementary_spec_ed                                                   *                                              
2242687 2242687 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348001161 3022062 EXCEPTIONAL SCHOOL   Regular School No Ungraded UG UG 2021   elementary_spec_ed                                                   *                                              
2242710 2242710 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000858 3112004 BAY SPRINGS ELEM SCH   Regular School No Elementary KG 05 2021   elementary_spec_ed                                                   *                                              
2242723 2242723 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000899 3112010 BAY SPRINGS MIDDLE SCH   Regular School No Middle 06 08 2021   elementary_spec_ed                                                   *                                              
2242745 2242745 MS     school 2802220 3200   JEFFERSON CO SCHOOL DIST 280222000426 3200004 JEFFERSON CO ELEM SCHOOL   Regular School No Elementary PK 04 2021   elementary_spec_ed                                                   14                                             14
2242760 2242760 MS     school 2802220 3200   JEFFERSON CO SCHOOL DIST 280222001292 3200012 JEFFERSON CO JR HI   Regular School No Middle 07 08 2021   elementary_spec_ed                                                   *                                              
2242781 2242781 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000432 3300012 J E JOHNSON ELEMENTARY   Regular School No Elementary KG 08 2021   elementary_spec_ed                                                   *                                              

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