enrollments

Data source: Big Local News · About: Big Local

12,592 rows where state = "MS"

✎ View and edit SQL

This data as json, CSV (advanced)

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
2035367 2035367 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001385 2520006 BAILEY MIDDLE APAC SCHOOL   Regular School No Middle 06 08 2020   grade_7                                                   123                                             123
2035368 2035368 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001385 2520006 BAILEY MIDDLE APAC SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   119                                             119
2035369 2035369 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001385 2520006 BAILEY MIDDLE APAC SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 13 359 *               *   152.0 229.0                       381 13 359                     152 229                 381
2035370 2035370 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000370 2520007 BAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   13                                             13
2035371 2035371 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000370 2520007 BAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten                                                   51                                             51
2035372 2035372 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000370 2520007 BAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1                                                   39                                             39
2035373 2035373 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000370 2520007 BAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   51                                             51
2035374 2035374 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000370 2520007 BAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   37                                             37
2035375 2035375 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000370 2520007 BAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4                                                   21                                             21
2035376 2035376 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000370 2520007 BAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5                                                   38                                             38
2035377 2035377 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000370 2520007 BAKER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total * 236 *               *   143.0 107.0                       250   236                     143 107                 250
2035378 2035378 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000371 2520008 BARR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   20                                             20
2035379 2035379 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000371 2520008 BARR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten                                                   20                                             20
2035380 2035380 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000371 2520008 BARR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1                                                   19                                             19
2035381 2035381 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000371 2520008 BARR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   28                                             28
2035382 2035382 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000371 2520008 BARR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   28                                             28
2035383 2035383 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000371 2520008 BARR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4                                                   29                                             29
2035384 2035384 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000371 2520008 BARR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5                                                   22                                             22
2035385 2035385 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000371 2520008 BARR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total * *                     84.0 82.0                       166                         84 82                 166
2035386 2035386 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000372 2520010 BLACKBURN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035387 2035387 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000372 2520010 BLACKBURN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6                                                   *                                              
2035388 2035388 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000372 2520010 BLACKBURN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7                                                   126                                             126
2035389 2035389 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000372 2520010 BLACKBURN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   120                                             120
2035390 2035390 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000372 2520010 BLACKBURN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total   * *                   180.0 189.0                       369                         180 189                 369
2035391 2035391 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   elementary_spec_ed                                                   *                                              
2035392 2035392 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_1                                                   86                                             86
2035393 2035393 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_2                                                   87                                             87
2035394 2035394 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_3                                                   113                                             113
2035395 2035395 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_4                                                   77                                             77
2035396 2035396 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   grade_5                                                   *                                              
2035397 2035397 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000373 2520011 BOYD ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2020   pk_12_total * 415 21               *   233.0 208.0                       441   415 21                   233 208                 441
2035398 2035398 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000375 2520014 BRINKLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035399 2035399 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000375 2520014 BRINKLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6                                                   146                                             146
2035400 2035400 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000375 2520014 BRINKLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7                                                   159                                             159
2035401 2035401 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000375 2520014 BRINKLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   *                                              
2035402 2035402 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000375 2520014 BRINKLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total   424 *               *   226.0 200.0                       426   424                     226 200                 426
2035403 2035403 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000377 2520018 CALLAWAY HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   232                                             232
2035404 2035404 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000377 2520018 CALLAWAY HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   274                                             274
2035405 2035405 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000377 2520018 CALLAWAY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   222                                             222
2035406 2035406 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000377 2520018 CALLAWAY HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   219                                             219
2035407 2035407 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000377 2520018 CALLAWAY HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   18                                             18
2035408 2035408 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000377 2520018 CALLAWAY HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total * 930 27     *         *   483.0 482.0                       965   930 27                   483 482                 965
2035409 2035409 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   kindergarten                                                   56                                             56
2035410 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
2035411 2035411 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_1                                                   70                                             70
2035412 2035412 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2                                                   67                                             67
2035413 2035413 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   65                                             65
2035414 2035414 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_4                                                   61                                             61
2035415 2035415 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_5                                                   66                                             66
2035416 2035416 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000379 2520020 CASEY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   pk_12_total 24 360 *     *         *   191.0 206.0                       397 24 360                     191 206                 397
2035417 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
2035418 2035418 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000380 2520023 CHASTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6                                                   174                                             174
2035419 2035419 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000380 2520023 CHASTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7                                                   218                                             218
2035420 2035420 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000380 2520023 CHASTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   189                                             189
2035421 2035421 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000380 2520023 CHASTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total * 557 26           *   *   330.0 265.0                       595   557 26                   330 265                 595
2035422 2035422 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   19                                             19
2035423 2035423 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten                                                   57                                             57
2035424 2035424 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1                                                   53                                             53
2035425 2035425 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   48                                             48
2035426 2035426 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   45                                             45
2035427 2035427 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4                                                   39                                             39
2035428 2035428 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5                                                   44                                             44
2035429 2035429 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000381 2520024 CLAUSELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total * 302                 *   153.0 152.0                       305   302                     153 152                 305
2035430 2035430 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   *                                              
2035431 2035431 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten                                                   54                                             54
2035432 2035432 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035433 2035433 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1                                                   36                                             36
2035434 2035434 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   46                                             46
2035435 2035435 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   50                                             50
2035436 2035436 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4                                                   39                                             39
2035437 2035437 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5                                                   42                                             42
2035438 2035438 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000382 2520027 DAWSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total * *                     162.0 119.0                       281                         162 119                 281
2035439 2035439 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000384 2520031 FOREST HILL HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   283                                             283
2035440 2035440 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000384 2520031 FOREST HILL HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   282                                             282
2035441 2035441 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000384 2520031 FOREST HILL HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   239                                             239
2035442 2035442 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000384 2520031 FOREST HILL HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   199                                             199
2035443 2035443 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000384 2520031 FOREST HILL HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   27                                             27
2035444 2035444 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000384 2520031 FOREST HILL HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total * 1005 12               *   506.0 524.0                       1030   1005 12                   506 524                 1030
2035445 2035445 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   *                                              
2035446 2035446 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten                                                   69                                             69
2035447 2035447 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   *                                              
2035448 2035448 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1                                                   55                                             55
2035449 2035449 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   59                                             59
2035450 2035450 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   92                                             92
2035451 2035451 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4                                                   44                                             44
2035452 2035452 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5                                                   59                                             59
2035453 2035453 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000386 2520033 GALLOWAY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total * 400 *               *   207.0 201.0                       408   400                     207 201                 408
2035454 2035454 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   20                                             20
2035455 2035455 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten                                                   49                                             49
2035456 2035456 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1                                                   48                                             48
2035457 2035457 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   47                                             47
2035458 2035458 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   86                                             86
2035459 2035459 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4                                                   50                                             50
2035460 2035460 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5                                                   51                                             51
2035461 2035461 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000388 2520036 GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total * 341                 *   188.0 163.0                       351   341                     188 163                 351
2035462 2035462 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000389 2520038 HARDY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2035463 2035463 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000389 2520038 HARDY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_6                                                   144                                             144
2035464 2035464 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000389 2520038 HARDY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_7                                                   *                                              
2035465 2035465 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000389 2520038 HARDY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   127                                             127
2035466 2035466 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000389 2520038 HARDY MIDDLE SCHOOL   Regular School No Middle 06 08 2020   pk_12_total   * *                   183.0 198.0                       381                         183 198                 381

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