Data source: Big Local News · About: Big Local

12,592 rows where state = "MS" sorted by total descending

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
2039497 MS     school 2801620 7620   GREENVILLE PUBLIC SCHOOLS 280162000244 7620032 GREENVILLE HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total * 993     *           *   461.0 538.0                       999   993                     461 538                 999
2034903 MS     school 2801680 2220   GRENADA SCHOOL DIST 280168000264 2220012 GRENADA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 451 516 *   * *     *   19   515.0 483.0                       998 451 516                 19   515 483                 998
2241269 MS     school 2803530 1821   PETAL SCHOOL DIST 280353001067 1821002 PETAL PRIMARY SCHOOL   Regular School No Elementary PK 02 2021   pk_12_total 724 152 47   * *     *   69   533 465                       998 724 152 47               69   533 465                 998
2244416 MS     school 2803540 5500   PEARL RIVER CO SCHOOL DIST 280354001070 5500012 PEARL RIVER CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   pk_12_total 897 24 16   * *         56   512 486                       998 897 24 16               56   512 486                 998
2036070 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000934 3021022 OCEAN SPRINGS MIDDLE SCHOOL   Regular School No Middle 07 08 2020   pk_12_total 756 126 49   * 34     *   17   537.0 457.0                       994 756 126 49     34         17   537 457                 994
2242857 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000986 3400034 SOUTH JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2021   pk_12_total 672 194 80     *         *   498 496                       994 672 194 80                   498 496                 994
2245728 MS     school 2803120 7320   NEW ALBANY PUBLIC SCHOOLS 280312001259 7320012 NEW ALBANY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   pk_12_total 507 260 142     28         57   478 516                       994 507 260 142     28         57   478 516                 994
2241647 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063001107 2420006 BILOXI JUNIOR HIGH   Regular School No Middle 07 08 2021   pk_12_total 396 349 154   * 31     *   56   506 487                       993 396 349 154     31         56   506 487                 993
2242579 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000934 3021022 OCEAN SPRINGS MIDDLE SCHOOL   Regular School No Middle 07 08 2021   pk_12_total 736 119 64   * 36     *   25   563 427                       990 736 119 64     36         25   563 427                 990
2033492 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000602 130028 MORGANTOWN MIDDLE   Regular School No Middle 06 08 2020   grade_6                                                   99                                             99
2033563 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   99                                             99
2033586 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_6                                                   99                                             99
2034044 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   grade_3                                                   99                                             99
2034769 MS     school 2801530 1900   FRANKLIN CO SCHOOL DIST 280153001110 1900006 FRANKLIN UPPER ELEMENTARY   Regular School No Middle 04 06 2020   grade_6                                                   99                                             99
2034916 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174000280 2300004 SOUTH HANCOCK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   kindergarten                                                   99                                             99
2034919 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174000280 2300004 SOUTH HANCOCK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_1                                                   99                                             99
2034931 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174000982 2300005 EAST HANCOCK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_4                                                   99                                             99
2035099 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000959 2400051 WEST WORTHAM ELEMENTARY AND MIDDLE   Regular School No Elementary KG 08 2020   grade_2                                                   99                                             99
2035809 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501491 2611006 WILLIAMS-SULLIVAN ELEMENTARY   Regular School No Middle 06 08 2020   grade_7                                                   99                                             99
2036030 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000591 3020020 MOSS POINT KREOLE PRIMARY SCHOOL   Regular School No Elementary PK 02 2020   kindergarten                                                   99                                             99
2036309 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000985 3400022 EAST JONES ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_1                                                   99                                             99
2036642 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001573 3800011 SOUTHEAST LAUDERDALE ELEMENTARY   Regular School No Elementary KG 04 2020   grade_1                                                   99                                             99
2036884 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001325 4100027 SHANNON MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6                                                   99                                             99
2037054 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801521 4211024 THREADGILL ELEMENTARY SCHOOL   Regular School No Elementary 02 06 2020   grade_3                                                   99                                             99
2037478 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001247 4600014 WEST MARION HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   99                                             99
2037480 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001247 4600014 WEST MARION HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   99                                             99
2037591 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195000337 4720012 HOLLY SPRINGS PRIMARY SCHOOL   Regular School No Elementary PK 03 2020   grade_1                                                   99                                             99
2037593 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195000337 4720012 HOLLY SPRINGS PRIMARY SCHOOL   Regular School No Elementary PK 03 2020   grade_3                                                   99                                             99
2037692 MS     school 2800196 4911   WINONA-MONTGOMERY CONSOLIDATED SD 280019601493 4911004 WINONA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   grade_6                                                   99                                             99
2038151 MS     school 2803660 5800   PONTOTOC CO SCHOOL DIST 280366000701 5800004 North Pontotoc High School   Regular School No High 09 12 2020   grade_12                                                   99                                             99
2038426 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001077 6100034 NORTHWEST ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_6                                                   99                                             99
2038435 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001270 6100036 NORTHSHORE ELEMENTARY   Regular School No Elementary KG 06 2020   grade_5                                                   99                                             99
2039284 MS     school 2804440 7400   WALTHALL CO SCHOOL DIST 280444000835 7400012 TYLERTOWN ELEMENTARY SCHOOL   Regular School No Middle 04 06 2020   grade_6                                                   99                                             99
2039665 MS     school 2804710 7900   WILKINSON CO SCHOOL DIST 280471001580 7900012 WILLIAM WINANS MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6                                                   99                                             99
2039741 MS     school 2804500 8113   WATER VALLEY SCHOOL DISTRICT 280450000845 8113004 WATER VALLEY HIGH SCHOOL   Regular School No High 07 12 2020   grade_7                                                   99                                             99
2240135 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_1                                                   99                                             99
2241625 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000959 2400051 WEST WORTHAM ELEMENTARY AND MIDDLE   Regular School No Elementary KG 08 2021   grade_4                                                   99                                             99
2241671 MS     school 2800630 2420   BILOXI PUBLIC SCHOOL DIST 280063000058 2420024 GORENFLO ELEMENTARY SCHOOL   Regular School No Elementary 02 04 2021   grade_2                                                   99                                             99
2241693 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000268 2421004 ANNISTON AVENUE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_5                                                   99                                             99
2241738 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000279 2421064 WEST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   99                                             99
2242027 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001364 2520043 BATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_3                                                   99                                             99
2242327 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501491 2611006 WILLIAMS-SULLIVAN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_6                                                   99                                             99
2242363 MS     school 2802040 2700   HUMPHREYS CO SCHOOL DIST 280204000349 2700004 IDA GREENE LOWER ELEMENTARY   Regular School No Elementary KG 04 2021   grade_2                                                   99                                             99
2242529 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000587 3020004 MOSS POINT HIGH SCHOOL   Regular School No High 09 12 2021   grade_10                                                   99                                             99
2243556 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801521 4211024 THREADGILL ELEMENTARY SCHOOL   Regular School No Elementary 02 06 2021   grade_4                                                   99                                             99
2243811 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001290 4500018 MADISON CROSSING ELEMENTARY   Regular School No Elementary KG 05 2021   grade_2                                                   99                                             99
2244148 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_8                                                   99                                             99
2244506 MS     school 2803570 5600   PERRY CO SCHOOL DIST 280357000689 5600012 PERRY CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_8                                                   99                                             99
2244802 MS     school 2800820 5921   BOONEVILLE SCHOOL DIST 280082001025 5921016 ANDERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2021   grade_2                                                   99                                             99
2245063 MS     school 2803900 6200   SCOTT CO SCHOOL DIST 280390001184 6200012 MORTON HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   99                                             99
2245122 MS     school 2801470 6220   FOREST MUNICIPAL SCHOOL DIST 280147000213 6220008 FOREST HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   99                                             99
2245161 MS     school 2803990 6400   SIMPSON CO SCHOOL DIST 280399000755 6400008 MAGEE HIGH SCHOOL   Regular School No High 09 12 2021   grade_10                                                   99                                             99
2245167 MS     school 2803990 6400   SIMPSON CO SCHOOL DIST 280399001085 6400010 MAGEE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   99                                             99
2246233 MS     school 2804500 8113   WATER VALLEY SCHOOL DISTRICT 280450000845 8113004 WATER VALLEY HIGH SCHOOL   Regular School No High 07 12 2021   grade_8                                                   99                                             99
2035060 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000958 2400038 NORTH WOOLMARKET ELEMENTARY AND MID   Regular School No Elementary KG 08 2020   pk_12_total 765 102 68   * 10     *   39   490.0 499.0                       989 765 102 68     10         39   490 499                 989
2244322 MS     school 2800189 5321   STARKVILLE- OKTIBBEHA CONS SD 280018901438 5321007 HENDERSON/WARD-STEWART ELEMENTARY   Regular School No Elementary 02 04 2021   pk_12_total 284 648 11   * 43     *       522 466                       988 284 648 11     43             522 466                 988
2244115 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other PK 12 2021   pk_12_total 914 52 *           *   11   489 493                       982 914 52                 11   489 493                 982
2037723 MS     school 2803060 5000   NESHOBA COUNTY SCHOOL DISTRICT 280306000612 5000008 NESHOBA CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 640 161 *   131 *         35   492.0 489.0                       981 640 161     131           35   492 489                 981
2034046 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   grade_5                                                   98                                             98
2034345 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_1                                                   98                                             98
2034803 MS     school 2801560 2000   GEORGE CO SCHOOL DIST 280156000227 2000008 CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   kindergarten                                                   98                                             98
2034921 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174000280 2300004 SOUTH HANCOCK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   98                                             98
2035075 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177001431 2400046 RIVER OAKS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2                                                   98                                             98
2035098 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000959 2400051 WEST WORTHAM ELEMENTARY AND MIDDLE   Regular School No Elementary KG 08 2020   grade_1                                                   98                                             98
2035167 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000268 2421004 ANNISTON AVENUE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2                                                   98                                             98
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
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
2036655 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001174 3800014 SOUTHEAST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_6                                                   98                                             98
2037473 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001246 4600010 WEST MARION ELEMENTARY   Regular School No Middle 04 06 2020   grade_5                                                   98                                             98
2037648 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   98                                             98
2038300 MS     school 2800820 5921   BOONEVILLE SCHOOL DIST 280082001329 5921004 R.H. LONG BOONEVILLE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   98                                             98
2038387 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383000711 6100023 FLOWOOD ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_4                                                   98                                             98
2038921 MS     school 2804230 6900   TATE CO SCHOOL DIST 280423000800 6900012 INDEPENDENCE HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   98                                             98
2240142 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6                                                   98                                             98
2240143 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   98                                             98
2240776 MS     school 2801220 1500   COPIAH CO SCHOOL DIST 280122000167 1500004 CRYSTAL SPRINGS MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_5                                                   98                                             98
2241457 MS     school 2801740 2300   HANCOCK CO SCHOOL DIST 280174000982 2300005 EAST HANCOCK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2021   grade_2                                                   98                                             98
2241600 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177001431 2400046 RIVER OAKS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_3                                                   98                                             98
2241692 MS     school 2801710 2421   GULFPORT SCHOOL DIST 280171000268 2421004 ANNISTON AVENUE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_4                                                   98                                             98
2242542 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000591 3020020 MOSS POINT KREOLE PRIMARY SCHOOL   Regular School No Elementary PK 02 2021   grade_1                                                   98                                             98
2242599 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000667 3022008 BEACH ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   pk_12_total 71 16 *               *   54 44                       98 71 16                     54 44                 98
2243354 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001000 4100009 MOOREVILLE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_3                                                   98                                             98
2243497 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801512 4211004 AMANDA ELZY HIGH SCHOOL   Regular School No High 09 12 2021   grade_10                                                   98                                             98
2243813 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001290 4500018 MADISON CROSSING ELEMENTARY   Regular School No Elementary KG 05 2021   grade_4                                                   98                                             98
2244923 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001270 6100036 NORTHSHORE ELEMENTARY   Regular School No Elementary KG 06 2021   grade_5                                                   98                                             98
2244938 MS     school 2803830 6100   RANKIN CO SCHOOL DIST 280383001333 6100040 HIGHLAND BLUFF ELEMENTARY   Regular School No Elementary KG 06 2021   grade_2                                                   98                                             98
2245249 MS     school 2804170 6600   STONE CO SCHOOL DIST 280417000788 6600004 PERKINSTON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   grade_2                                                   98                                             98
2245344 MS     school 2800187 6711   SUNFLOWER CO CONSOLIDATE SCH DIST 280018701399 6711030 LOCKARD ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2021   grade_2                                                   98                                             98
2245837 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447000995 7500021 SHERMAN AVE ELEMENTARY   Regular School No Elementary PK 02 2021   kindergarten                                                   98                                             98
2245846 MS     school 2804470 7500   VICKSBURG WARREN SCHOOL DIST 280447000996 7500022 WARREN CENTRAL INTERMEDIATE   Regular School No Elementary 03 06 2021   grade_5                                                   98                                             98
2246161 MS     school 2802700 8020   LOUISVILLE MUNICIPAL SCHOOL DIST 280270001156 8020004 FAIR ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2021   kindergarten                                                   98                                             98
2243836 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000304 4500026 MADISON STATION ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2021   pk_12_total 690 142 11   * 106     *   24   503 476                       979 690 142 11     106         24   503 476                 979
2244213 MS     school 2803060 5000   NESHOBA COUNTY SCHOOL DISTRICT 280306000612 5000008 NESHOBA CENTRAL HIGH SCHOOL   Regular School No High 09 12 2021   pk_12_total 609 164 *   131 *         62   476 502                       978 609 164     131           62   476 502                 978
2036801 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252001118 4000002 LEAKE CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   pk_12_total 220 541 172   * *         25   487.0 486.0                       973 220 541 172               25   487 486                 973
2033582 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_4                                                   97                                             97
2033585 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5                                                   97                                             97
2034040 MS     school 2801020 1100   CLAIBORNE CO SCHOOL DIST 280102001213 1100002 A. W. WATSON ELEMENTARY   Regular School No Elementary PK 06 2020   kindergarten                                                   97                                             97
2034587 MS     school 2801320 1700   DESOTO CO SCHOOL DIST 280132001319 1700080 LAKE CORMORANT ELEMENTARY   Regular School No Elementary PK 05 2020   grade_4                                                   97                                             97
2034986 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000283 2400002 BEL AIRE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_1                                                   97                                             97
2035045 MS     school 2801770 2400   HARRISON CO SCHOOL DIST 280177000292 2400028 LYMAN ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_5                                                   97                                             97

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