Data source: Big Local News · About: Big Local

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

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
2036525 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001171 3700010 OAK GROVE HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 870 652 102     61     *   *   849.0 898.0                       1747 870 652 102     61             849 898                 1747
2036549 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001316 3700017 SUMRALL MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 443 42 12     *         *   233.0 272.0                       505 443 42 12                   233 272                 505
2036555 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001173 3700018 SUMRALL HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 512 53 *               *   318.0 264.0                       582 512 53                     318 264                 582
2036579 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001322 3700023 PURVIS UPPER ELEMENTARY   Regular School No Elementary 03 05 2020   pk_12_total 310 42 *   * *         *   184.0 180.0                       364 310 42                     184 180                 364
2036593 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001507 3700025 LUMBERTON MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 93 54 *               *   86.0 66.0                       152 93 54                     86 66                 152
2036598 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001484 3700026 LUMBERTON HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 78 64 *               *   85.0 65.0                       150 78 64                     85 65                 150
2036604 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001362 3800002 CLARKDALE ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   pk_12_total 296 40 *     *         *   181.0 167.0                       348 296 40                     181 167                 348
2036624 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001056 3800006 NORTHEAST LAUDERDALE ELEMENTARY   Regular School No Elementary KG 04 2020   pk_12_total 275 371 26     16     *   *   377.0 325.0                       702 275 371 26     16             377 325                 702
2036637 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000568 3800010 NORTHEAST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   pk_12_total 228 377 20     16     *   *   308.0 339.0                       647 228 377 20     16             308 339                 647
2036646 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001573 3800011 SOUTHEAST LAUDERDALE ELEMENTARY   Regular School No Elementary KG 04 2020   pk_12_total 316 155 14     *         *   265.0 226.0                       491 316 155 14                   265 226                 491
2036665 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000471 3800016 WEST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   pk_12_total 507 104 15     *         *   334.0 297.0                       631 507 104 15                   334 297                 631
2036674 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001241 3800018 WEST LAUDERDALE ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   pk_12_total 571 95 12   *           *   376.0 305.0                       681 571 95 12                   376 305                 681
2036693 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000560 3820008 CRESTWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total 17 265 20   *           *   160.0 152.0                       312 17 265 20                   160 152                 312
2036698 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000564 3820024 MAGNOLIA MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 19 329 *               *   198.0 160.0                       358 19 329                     198 160                 358
2036717 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000570 3820048 OAKLAND HEIGHTS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total 27 371 *               *   220.0 192.0                       412 27 371                     220 192                 412
2036726 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000571 3820052 PARKVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total * 392 *     *         *   207.0 197.0                       404   392                     207 197                 404
2036734 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000572 3820056 POPLAR SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total 115 343 34   * *         *   270.0 234.0                       504 115 343 34                   270 234                 504
2036759 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000480 3900004 ROD PAIGE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   pk_12_total 167 187 *     *     *   *   167.0 198.0                       365 167 187                     167 198                 365
2036766 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000481 3900008 MONTICELLO ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   pk_12_total 188 193 13           *   *   190.0 210.0                       400 188 193 13                   190 210                 400
2036772 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000482 3900012 LAWRENCE COUNTY HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 310 219 *     *         *   265.0 280.0                       545 310 219                     265 280                 545
2036782 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000483 3900016 NEW HEBRON ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   pk_12_total 146 177 *               *   185.0 151.0                       336 146 177                     185 151                 336
2036792 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000485 3900024 TOPEKA TILTON ATTENDANCE CENTER   Regular School No Elementary KG 08 2020   pk_12_total 324 33 *               *   203.0 178.0                       381 324 33                     203 178                 381
2036807 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000487 4000004 LEAKE CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 114 327 94   13 *         *   267.0 294.0                       561 114 327 94   13               267 294                 561
2036823 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252001120 4000014 LEAKE COUNTY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   pk_12_total 105 315 21   * *         *   229.0 225.0                       454 105 315 21                   229 225                 454
2036830 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000490 4000016 LEAKE COUNTY HIGH SCHOOL   Regular School No High 07 12 2020   pk_12_total 57 192 20   *           *   144.0 134.0                       278 57 192 20                   144 134                 278
2036841 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001276 4100007 MOOREVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 341 24 14     *         *   224.0 166.0                       390 341 24 14                   224 166                 390
2036847 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000494 4100008 MOOREVILLE HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 422 33 17     *         *   244.0 234.0                       478 422 33 17                   244 234                 478
2036861 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000495 4100016 PLANTERSVILLE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   pk_12_total 25 238 10   *           *   164.0 113.0                       277 25 238 10                   164 113                 277
2036888 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001325 4100027 SHANNON MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 77 179 *               *   129.0 141.0                       270 77 179                     129 141                 270
2036894 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000497 4100028 SHANNON HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 129 410 *               *   298.0 261.0                       559 129 410                     298 261                 559
2036899 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001266 4100030 SHANNON PRIMARY SCHOOL   Regular School No Elementary KG 02 2020   pk_12_total 103 116 *               *   127.0 110.0                       237 103 116                     127 110                 237
2036906 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000498 4100032 VERONA ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   pk_12_total 24 346 18   * *         *   201.0 199.0                       400 24 346 18                   201 199                 400
2036912 MS     school 2803090 4111   NETTLETON SCHOOL DIST 280309000613 4111004 NETTLETON HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 269 115 *               *   184.0 209.0                       393 269 115                     184 209                 393
2036921 MS     school 2803090 4111   NETTLETON SCHOOL DIST 280309000614 4111008 NETTLETON PRIMARY SCHOOL   Regular School No Elementary KG 03 2020   pk_12_total 255 110 *               *   208.0 167.0                       375 255 110                     208 167                 375
2036926 MS     school 2803090 4111   NETTLETON SCHOOL DIST 280309001160 4111010 NETTLETON UPPER ELEMENTARY SCHOOL   Regular School No Middle 04 06 2020   pk_12_total 215 96 *               *   147.0 173.0                       320 215 96                     147 173                 320
2036935 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000813 4120016 JOYNER ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   pk_12_total 140 210 30   * 10         *   198.0 204.0                       402 140 210 30     10             198 204                 402
2036949 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432001002 4120021 LAWNDALE ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   pk_12_total 138 246 32     *         *   233.0 213.0                       446 138 246 32                   233 213                 446
2036959 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432001256 4120027 PARKWAY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   pk_12_total 112 236 32     *         *   210.0 199.0                       409 112 236 32                   210 199                 409
2036974 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000818 4120036 THOMAS STREET ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2020   pk_12_total 128 210 30     *         *   179.0 210.0                       389 128 210 30                   179 210                 389
2036994 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801511 4211003 BANKSTON ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   pk_12_total 59 255 52     *         *   187.0 192.0                       379 59 255 52                   187 192                 379
2037000 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801512 4211004 AMANDA ELZY HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total * 351 19               *   188.0 187.0                       375   351 19                   188 187                 375
2037024 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801516 4211016 GREENWOOD HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 10 639 *               *   313.0 345.0                       658 10 639                     313 345                 658
2037046 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801519 4211021 LEFLORE COUNTY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2020   pk_12_total * 334 32               *   182.0 190.0                       372   334 32                   182 190                 372
2037051 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801520 4211022 CLAUDINE F BROWN ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2020   pk_12_total * 288 15               *   158.0 151.0                       309   288 15                   158 151                 309
2037062 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801522 4211032 GREENWOOD MIDDLE SCHOOL   Regular School No Middle 07 08 2020   pk_12_total * 369 *     *         *   197.0 184.0                       381   369                     197 184                 381
2037076 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other KG 12 2020   pk_12_total 559 146 *     *         *   359.0 360.0                       719 559 146                     359 360                 719
2037090 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000513 4300008 ENTERPRISE SCHOOL   Regular School No Other KG 12 2020   pk_12_total 654 67 *               *   355.0 377.0                       732 654 67                     355 377                 732
2037122 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other KG 12 2020   pk_12_total 645 88 *               *   380.0 364.0                       744 645 88                     380 364                 744
2037125 MS     school 2800031 4306   MS SCHOOL FOR THE ARTS 280003101574 4306004 MS SCHOOL FOR THE ARTS   Regular School No High 11 12 2020   pk_12_total 57 46 *   * *         *   26.0 85.0                       111 57 46                     26 85                 111
2037144 MS     school 2800840 4320   BROOKHAVEN SCHOOL DIST 280084000094 4320016 LIPSEY SCHOOL   Regular School No Middle 05 06 2020   pk_12_total 135 323 *     *         *   266.0 209.0                       475 135 323                     266 209                 475
2037166 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001125 4400004 CALEDONIA HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 445 102 11   * *     *   *   286.0 283.0                       569 445 102 11                   286 283                 569
2037171 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001460 4400005 GOLDEN TRIANGLE EARLY COLLEGE   Regular School No High 09 12 2020   pk_12_total 84 128 *     *         *   68.0 153.0                       221 84 128                     68 153                 221
2037185 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273000531 4400012 WEST LOWNDES HIGH SCHOOL   Regular School No High 07 12 2020   pk_12_total   *                 *   114.0 116.0                       230                         114 116                 230
2037200 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001127 4400016 NEW HOPE HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 418 329 11   * *     *   *   413.0 358.0                       771 418 329 11                   413 358                 771
2037218 MS     school 2801194 4406   MS SCH FOR MATH AND SC 280119401201 4406004 MS SCHOOL FOR MATH AND SCIENCE   Regular School No High 11 12 2020   pk_12_total 135 52 *     40         *   105.0 133.0                       238 135 52       40             105 133                 238
2037228 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000152 4420008 STOKES BEARD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total * 380 *               *   198.0 198.0                       396   380                     198 198                 396
2037234 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000154 4420016 COLUMBUS HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 31 856 17     *         *   466.0 453.0                       919 31 856 17                   466 453                 919
2037240 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120001380 4420018 COLUMBUS MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 37 783 11     *         *   443.0 399.0                       842 37 783 11                   443 399                 842
2037249 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000156 4420024 COOK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total 39 370 21               *   237.0 199.0                       436 39 370 21                   237 199                 436
2037257 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000158 4420032 FAIRVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total 10 253 *   * *         *   142.0 127.0                       269 10 253                     142 127                 269
2037266 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000159 4420036 FRANKLIN ACADEMY   Regular School No Elementary PK 05 2020   pk_12_total 11 269 *     *         *   145.0 148.0                       293 11 269                     145 148                 293
2037274 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120000164 4420056 SALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total 13 273 *               *   162.0 135.0                       297 13 273                     162 135                 297
2037286 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000537 4500004 LUTHER BRANSON SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total * 182 *               *   105.0 85.0                       190   182                     105 85                 190
2037296 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001006 4500006 EAST FLORA ELEMENTARY   Regular School No Elementary PK 05 2020   pk_12_total 67 194 *               *   141.0 124.0                       265 67 194                     141 124                 265
2037304 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000988 4500010 CAMDEN ELEMENTARY   Regular School No Elementary PK 05 2020   pk_12_total   *                 *   41.0 67.0                       108                         41 67                 108
2037308 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000989 4500014 SHIRLEY D. SIMMONS MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total * 152                 *   76.0 78.0                       154   152                     76 78                 154
2037334 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001081 4500024 ANN SMITH ELEMENTARY   Regular School No Elementary PK 02 2020   pk_12_total 90 437 165   * 41         *   384.0 373.0                       757 90 437 165     41             384 373                 757
2037343 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000304 4500026 MADISON STATION ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   pk_12_total 727 154 22   * 117         *   526.0 515.0                       1041 727 154 22     117             526 515                 1041
2037350 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001267 4500030 ROSA SCOTT SCHOOL   Regular School No Secondary 09 09 2020   pk_12_total 267 111 *     23         *   202.0 215.0                       417 267 111       23             202 215                 417
2037361 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001007 4500034 MADISON AVENUE UPPER ELEMENTARY   Regular School No Elementary 03 05 2020   pk_12_total 345 78 14   * 35         *   246.0 238.0                       484 345 78 14     35             246 238                 484
2037371 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000937 4500038 HIGHLAND ELEMENTARY   Regular School No Elementary 03 05 2020   pk_12_total 74 447 118     29     *   *   335.0 353.0                       688 74 447 118     29             335 353                 688
2037382 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001257 4500046 RIDGELAND HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 117 589 119     *         *   434.0 430.0                       864 117 589 119                   434 430                 864
2037399 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001381 4500066 GERMANTOWN HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 802 415 *     21         *   653.0 612.0                       1265 802 415       21             653 612                 1265
2037407 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090000100 4520004 CANTON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   pk_12_total   260 139   * *         *   206.0 197.0                       403   260 139                   206 197                 403
2037422 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090000102 4520012 MC NEAL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   pk_12_total * 435 33   *           *   224.0 250.0                       474   435 33                   224 250                 474
2037432 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090001394 4520018 HUEY L. PORTER MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total * 352 54     *         *   209.0 203.0                       412   352 54                   209 203                 412
2037442 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090001285 4520020 REUBEN B. MYERS CANTON SCHOOL OF AR   Regular School No Elementary PK 05 2020   pk_12_total * 395 20     *         *   223.0 201.0                       424   395 20                   223 201                 424
2037452 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090001396 4520022 JIMMIE M. GOODLOE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   pk_12_total * 365 53     *         *   229.0 195.0                       424   365 53                   229 195                 424
2037470 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282000545 4600008 EAST MARION HIGH SCHOOL   Regular School No High 07 12 2020   pk_12_total * 229                 *   161.0 169.0                       330   229                     161 169                 330
2037475 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001246 4600010 WEST MARION ELEMENTARY   Regular School No Middle 04 06 2020   pk_12_total 223 71 *               *   138.0 162.0                       300 223 71                     138 162                 300
2037483 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001247 4600014 WEST MARION HIGH SCHOOL   Regular School No High 07 12 2020   pk_12_total 424 146 10   *           *   306.0 278.0                       584 424 146 10                   306 278                 584
2037495 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000148 4620004 COLUMBIA ELEMENTARY SCHOOL   Regular School No Elementary 03 05 2020   pk_12_total 175 195 *     *         *   190.0 188.0                       378 175 195                     190 188                 378
2037500 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000149 4620008 COLUMBIA HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 245 210 10   * *     *   *   241.0 234.0                       475 245 210 10                   241 234                 475
2037506 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000150 4620012 COLUMBIA PRIMARY SCHOOL   Regular School No Elementary PK 02 2020   pk_12_total 216 178 13     *         *   228.0 190.0                       418 216 178 13                   228 190                 418
2037510 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000151 4620016 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 170 194 *     *         *   199.0 181.0                       380 170 194                     199 181                 380
2037516 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000548 4700004 BYHALIA HIGH SCHOOL (9-12)   Regular School No High 09 12 2020   pk_12_total 97 225 85     *         *   218.0 208.0                       426 97 225 85                   218 208                 426
2037525 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000549 4700008 GALENA ELEMENTARY SCHOOL (K-6)   Regular School No Elementary KG 06 2020   pk_12_total * 87 *               *   48.0 52.0                       100   87                     48 52                 100
2037548 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000551 4700016 POTTS CAMP HIGH SCHOOL (7-12)   Regular School No High 07 12 2020   pk_12_total 192 92 *               *   169.0 136.0                       305 192 92                     169 136                 305
2037581 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195000335 4720004 HOLLY SPRINGS HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total * 310 10               *   159.0 172.0                       331   310 10                   159 172                 331
2037584 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195001248 4720007 HOLLY SPRINGS JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2020   pk_12_total * 185 *               *   88.0 110.0                       198   185                     88 110                 198
2037588 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195000336 4720008 HOLLY SPRINGS INTERMEDIATE SCHOOL   Regular School No Middle 04 06 2020   pk_12_total 11 239 *               *   125.0 134.0                       259 11 239                     125 134                 259
2037594 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195000337 4720012 HOLLY SPRINGS PRIMARY SCHOOL   Regular School No Elementary PK 03 2020   pk_12_total 27 358 *     *         *   192.0 204.0                       396 27 358                     192 204                 396
2037626 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other KG 12 2020   pk_12_total 1021 57 *               *   543.0 544.0                       1087 1021 57                     543 544                 1087
2037647 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   pk_12_total * 315       *         *   186.0 147.0                       333   315                     186 147                 333
2037653 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total * 300 *               *   151.0 156.0                       307   300                     151 156                 307
2037660 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2020   pk_12_total 14 450       *         *   232.0 242.0                       474 14 450                     232 242                 474
2037666 MS     school 2800450 4821   AMORY SCHOOL DIST 280045000028 4821004 EAST AMORY SCHOOL   Regular School No Elementary 03 05 2020   pk_12_total 222 120 *     *         *   203.0 155.0                       358 222 120                     203 155                 358
2037672 MS     school 2800450 4821   AMORY SCHOOL DIST 280045000029 4821008 AMORY HIGH SCHOOL   Regular School No High 08 12 2020   pk_12_total 284 149 13     *         *   232.0 219.0                       451 284 149 13                   232 219                 451
2037677 MS     school 2800450 4821   AMORY SCHOOL DIST 280045000030 4821012 AMORY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 238 151 11     *         *   192.0 215.0                       407 238 151 11                   192 215                 407
2037682 MS     school 2800450 4821   AMORY SCHOOL DIST 280045000032 4821016 WEST AMORY SCHOOL   Regular School No Elementary KG 02 2020   pk_12_total 232 142 *     *         *   192.0 197.0                       389 232 142                     192 197                 389

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