Data source: Big Local News · About: Big Local

12,592 rows where state = "MS" sorted by grade

View and edit SQL

year

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
2034738 MS     school 2803530 1821   PETAL SCHOOL DIST 280353000005 1821004 PETAL MIDDLE SCHOOL   Regular School No Middle 07 08 2020   elementary_spec_ed                                                   *                                              
2034749 MS     school 2803530 1821   PETAL SCHOOL DIST 280353000007 1821012 PETAL UPPER ELEMENTARY SCHOOL   Regular School No Middle 05 06 2020   elementary_spec_ed                                                   *                                              
2034753 MS     school 2803530 1821   PETAL SCHOOL DIST 280353001330 1821014 PETAL ELEMENTARY   Regular School No Elementary 03 04 2020   elementary_spec_ed                                                   *                                              
2034761 MS     school 2801530 1900   FRANKLIN CO SCHOOL DIST 280153000223 1900004 FRANKLIN LOWER ELEMENTARY   Regular School No Elementary PK 03 2020   elementary_spec_ed                                                   *                                              
2034766 MS     school 2801530 1900   FRANKLIN CO SCHOOL DIST 280153001110 1900006 FRANKLIN UPPER ELEMENTARY   Regular School No Middle 04 06 2020   elementary_spec_ed                                                   *                                              
2034771 MS     school 2801530 1900   FRANKLIN CO SCHOOL DIST 280153001111 1900008 FRANKLIN COUNTY MIDDLE SCHOOL   Regular School No Middle 07 08 2020   elementary_spec_ed                                                   *                                              
2034785 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000226 2000004 AGRICOLA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   elementary_spec_ed                                                   *                                              
2034794 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000981 2000006 BENNDALE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   elementary_spec_ed                                                   *                                              
2034805 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000227 2000008 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   elementary_spec_ed                                                   *                                              
2034827 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000229 2000016 LC HATCHER ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   elementary_spec_ed                                                   *                                              
2034833 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000870 2000018 LT TAYLOR INTERMEDIATE SCHOOL   Regular School No Middle 03 07 2020   elementary_spec_ed                                                   10                                             10
2034842 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000231 2000024 ROCKY CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   elementary_spec_ed                                                   *                                              
2034852 MS     school 2801590 2100   GREENE COUNTY SCHOOL DISTRICT 280159001031 2100002 LEAKESVILLE ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   elementary_spec_ed                                                   *                                              
2034858 MS     school 2801590 2100   GREENE COUNTY SCHOOL DISTRICT 280159001134 2100004 LEAKESVILLE JR HIGH SCHOOL   Regular School No Middle 05 08 2020   elementary_spec_ed                                                   *                                              
2034875 MS     school 2801590 2100   GREENE COUNTY SCHOOL DISTRICT 280159000234 2100012 SAND HILL ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2020   elementary_spec_ed                                                   *                                              
2034898 MS     school 2801680 2220   GRENADA SCHOOL DIST 280168000264 2220012 GRENADA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   19                                             19
2034908 MS     school 2801680 2220   GRENADA SCHOOL DIST 280168000900 2220032 GRENADA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   36                                             36
2034918 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174000280 2300004 SOUTH HANCOCK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   18                                             18
2034927 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174000982 2300005 EAST HANCOCK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   10                                             10
2034937 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174000281 2300006 HANCOCK NORTH CENTRAL ELEMENTARY   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   *                                              
2034950 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174001232 2300009 HANCOCK MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2034957 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174001338 2300014 WEST HANCOCK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   *                                              
2034964 MS     school 2800570 2320   BAY ST LOUIS WAVELAND SCHOOL DIST 280057001233 2320007 Bay Waveland Middle School   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2034975 MS     school 2800570 2320   BAY ST LOUIS WAVELAND SCHOOL DIST 280057000046 2320012 NORTH BAY ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   elementary_spec_ed                                                   *                                              
2034981 MS     school 2800570 2320   BAY ST LOUIS WAVELAND SCHOOL DIST 280057001376 2320016 WAVELAND ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   elementary_spec_ed                                                   *                                              
2035029 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000289 2400020 HARRISON CO CHILD DEVELOPMENT CEN   Regular School No Ungraded UG UG 2020   elementary_spec_ed                                                   *                                              
2035130 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063001478 2420010 BILOXI UPPER ELEMENTARY   Regular School No Middle 05 06 2020   elementary_spec_ed                                                   20                                             20
2035146 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063000058 2420024 GORENFLO ELEMENTARY SCHOOL   Regular School No Elementary 02 04 2020   elementary_spec_ed                                                   17                                             17
2035154 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063001263 2420042 NICHOLS ELEMENTARY SCHOOL   Regular School No Elementary PK 01 2020   elementary_spec_ed                                                   *                                              
2035159 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063000063 2420044 POPPS FERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   elementary_spec_ed                                                   *                                              
2035173 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000269 2421008 BAYOU VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   *                                              
2035185 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000271 2421014 CENTRAL ELEM   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   *                                              
2035192 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000272 2421016 GULFPORT CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   13                                             13
2035212 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000279 2421064 WEST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   15                                             15
2035227 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000517 2422004 HARPER MC CAUGHAN ELEM SCHOOL   Regular School No Middle 04 06 2020   elementary_spec_ed                                                   *                                              
2035233 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000518 2422008 THOMAS L REEVES ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   elementary_spec_ed                                                   *                                              
2035238 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000519 2422012 LONG BEACH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   elementary_spec_ed                                                   *                                              
2035249 MS     school 2802670 2422   LONG BEACH SCHOOL DIST 280267000521 2422020 WJ QUARLES ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   elementary_spec_ed                                                   *                                              
2035256 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000682 2423004 DELISLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035265 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000683 2423008 PASS CHRISTIAN ELEM   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035279 MS     school 2803510 2423   PASS CHRISTIAN PUBLIC SCHOOL DIST 280351000685 2423016 PASS CHRISTIAN MIDDLE   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   11                                             11
2035288 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000322 2500012 CARVER MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035294 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186001036 2500020 GARY ROAD ELEMENTARY   Regular School No Elementary PK 02 2020   elementary_spec_ed                                                   *                                              
2035298 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000983 2500024 GARY ROAD INTERMEDIATE SCHOOL   Regular School No Elementary 03 05 2020   elementary_spec_ed                                                   *                                              
2035305 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000326 2500028 UTICA ELEM. / MIDDLE SCHOOL   Regular School No Elementary PK 08 2020   elementary_spec_ed                                                   *                                              
2035330 MS     school 2801860 2500   HINDS CO SCHOOL DIST 280186000961 2500042 RAYMOND ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   elementary_spec_ed                                                   *                                              
2035353 MS     school 2800188 2515   REIMAGINE PREP 280018801442 2515004 REIMAGINE PREP   Regular School Yes Middle 05 08 2020   elementary_spec_ed                                                   *                                              
2035386 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000372 2520010 BLACKBURN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035391 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   elementary_spec_ed                                                   *                                              
2035398 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000375 2520014 BRINKLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035410 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   12                                             12
2035417 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000380 2520023 CHASTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   14                                             14
2035432 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035447 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035462 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000389 2520038 HARDY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035476 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000392 2520040 JOHN HOPKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035493 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000393 2520042 JOHNSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035501 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001364 2520043 BATES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   16                                             16
2035520 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000395 2520047 LAKE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035554 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000399 2520053 MARSHALL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   10                                             10
2035561 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001365 2520055 KIRKSEY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035568 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000400 2520056 MC LEOD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   *                                              
2035586 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001054 2520058 NORTH JACKSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035606 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000405 2520062 PEEPLES MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035611 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000407 2520065 POWELL MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035633 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000412 2520076 SIWELL MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035640 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000413 2520077 SMITH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035648 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000414 2520078 SPANN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   *                                              
2035664 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000415 2520080 SYKES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   *                                              
2035673 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000418 2520081 WALTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035682 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000417 2520082 VAN WINKLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035699 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000420 2520084 PECAN PARK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035706 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001370 2520085 CARDOZO MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035711 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000421 2520086 WHITTEN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   15                                             15
2035735 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000132 2521008 CLINTON JR HI SCHOOL   Regular School No Middle 07 08 2020   elementary_spec_ed                                                   10                                             10
2035745 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000135 2521014 EASTSIDE ELEM   Regular School No Elementary 04 05 2020   elementary_spec_ed                                                   *                                              
2035749 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109001028 2521015 LOVETT ELEM SCHOOL   Regular School No Middle 06 06 2020   elementary_spec_ed                                                   *                                              
2035752 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000136 2521016 NORTHSIDE ELEM   Regular School No Elementary 02 03 2020   elementary_spec_ed                                                   *                                              
2035763 MS     school 2800192 2535   SMILOW PREP 280019201471 2535004 JOEL E. SMILOW PREP   Regular School Yes Middle 05 08 2020   elementary_spec_ed                                                   *                                              
2035773 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   elementary_spec_ed                                                   *                                              
2035844 MS     school 2802040 2700   HUMPHREYS CO SCHOOL DIST 280204000349 2700004 IDA GREENE LOWER ELEMENTARY   Regular School No Elementary KG 04 2020   elementary_spec_ed                                                   *                                              
2035850 MS     school 2802040 2700   HUMPHREYS CO SCHOOL DIST 280204001039 2700006 O M MC NAIR MIDDLE SCHOOL   Regular School No Middle 05 08 2020   elementary_spec_ed                                                   18                                             18
2035864 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000356 2900004 DORSEY ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   elementary_spec_ed                                                   *                                              
2035886 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000358 2900012 ITAWAMBA ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   elementary_spec_ed                                                   15                                             15
2035897 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2020   elementary_spec_ed                                                   *                                              
2035935 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001044 3000002 EAST CENTRAL UPPER ELEMENTARY   Regular School No Elementary 03 05 2020   elementary_spec_ed                                                   *                                              
2035940 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000364 3000004 EAST CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035956 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000366 3000010 ST MARTIN N ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   elementary_spec_ed                                                   11                                             11
2035967 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001047 3000013 ST MARTIN UPPER ELEMENTARY   Regular School No Elementary 04 05 2020   elementary_spec_ed                                                   *                                              
2035974 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001048 3000014 ST MARTIN EAST ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2020   elementary_spec_ed                                                   *                                              
2035979 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000368 3000016 VANCLEAVE UPPER ELEMENTARY   Regular School No Elementary 03 05 2020   elementary_spec_ed                                                   *                                              
2035984 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001049 3000018 VANCLEAVE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035999 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000962 3000022 EAST CENTRAL LOWER ELEMENTARY   Regular School No Elementary PK 02 2020   elementary_spec_ed                                                   *                                              
2036003 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000963 3000024 ST. MARTIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2036013 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000964 3000026 VANCLEAVE LOWER ELEMENTARY   Regular School No Elementary PK 02 2020   elementary_spec_ed                                                   *                                              
2036023 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000589 3020012 MOSS POINT ESCATAWPA UPPER ELEM   Regular School No Elementary 03 05 2020   elementary_spec_ed                                                   *                                              
2036032 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000591 3020020 MOSS POINT KREOLE PRIMARY SCHOOL   Regular School No Elementary PK 02 2020   elementary_spec_ed                                                   *                                              
2036044 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000647 3021004 OAK PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   elementary_spec_ed                                                   *                                              
2036049 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336001392 3021006 OCEAN SPRINGS UPPER ELEMENTARY SCHO   Regular School No Middle 04 06 2020   elementary_spec_ed                                                   17                                             17
2036056 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000648 3021008 MAGNOLIA PARK ELEMENTARY   Regular School No Elementary KG 03 2020   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]);