enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2037642 2037642 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   kindergarten                                                   100                                             100
2037643 2037643 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   elementary_spec_ed                                                   *                                              
2037644 2037644 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_1                                                   *                                              
2037645 2037645 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_2                                                   78                                             78
2037646 2037646 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary KG 03 2020   grade_3                                                   80                                             80
2037647 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
2037648 2037648 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   98                                             98
2037649 2037649 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   116                                             116
2037650 2037650 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   *                                              
2037651 2037651 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   50                                             50
2037652 2037652 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   *                                              
2037653 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
2037654 2037654 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2020   elementary_spec_ed                                                   11                                             11
2037655 2037655 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2020   grade_4                                                   79                                             79
2037656 2037656 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2020   grade_5                                                   77                                             77
2037657 2037657 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2020   grade_6                                                   101                                             101
2037658 2037658 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2020   grade_7                                                   106                                             106
2037659 2037659 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2020   grade_8                                                   100                                             100
2037660 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
2244131 2244131 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   kindergarten                                                   *                                              
2244132 2244132 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   elementary_spec_ed                                                   *                                              
2244133 2244133 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_1                                                   91                                             91
2244134 2244134 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_2                                                   72                                             72
2244135 2244135 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   grade_3                                                   76                                             76
2244136 2244136 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001372 4820006 ABERDEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 03 2021   pk_12_total * 291       *         *   169 138                       307   291                     169 138                 307
2244137 2244137 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2021   grade_9                                                   100                                             100
2244138 2244138 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2021   grade_10                                                   96                                             96
2244139 2244139 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   100                                             100
2244140 2244140 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2244141 2244141 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2244142 2244142 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036000009 4820008 ABERDEEN HIGH SCHOOL   Regular School No High 09 12 2021   pk_12_total * 331 *     *         *   175 168                       343   331                     175 168                 343
2244143 2244143 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2021   elementary_spec_ed                                                   11                                             11
2244144 2244144 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_4                                                   79                                             79
2244145 2244145 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_5                                                   70                                             70
2244146 2244146 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_6                                                   77                                             77
2244147 2244147 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_7                                                   95                                             95
2244148 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
2244149 2244149 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2021   pk_12_total * 410       *         12   204 227                       431   410                 12   204 227                 431
2033532 2033532 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   20                                             20
2033533 2033533 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   kindergarten                                                   36                                             36
2033534 2033534 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   kindergarten_spec_ed                                                   *                                              
2033535 2033535 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   elementary_spec_ed                                                   *                                              
2033536 2033536 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_1                                                   44                                             44
2033537 2033537 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2                                                   32                                             32
2033538 2033538 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_3                                                   36                                             36
2033539 2033539 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_4                                                   34                                             34
2033540 2033540 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_5                                                   42                                             42
2033541 2033541 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_6                                                   37                                             37
2033542 2033542 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   pk_12_total 217 39       *         *   151.0 133.0                       284 217 39                     151 133                 284
2033543 2033543 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_7                                                   36                                             36
2033544 2033544 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_8                                                   29                                             29
2033545 2033545 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   41                                             41
2033546 2033546 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_10                                                   27                                             27
2033547 2033547 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   33                                             33
2033548 2033548 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_12                                                   *                                              
2033549 2033549 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   secondary_spec_ed                                                   *                                              
2033550 2033550 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   pk_12_total 144 36 *     *         *   105.0 85.0                       190 144 36                     105 85                 190
2033551 2033551 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   60                                             60
2033552 2033552 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   pre_kindergarten_spec_ed                                                   *                                              
2033553 2033553 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   kindergarten                                                   89                                             89
2033554 2033554 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   kindergarten_spec_ed                                                   *                                              
2033555 2033555 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   elementary_spec_ed                                                   *                                              
2033556 2033556 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_1                                                   93                                             93
2033557 2033557 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_2                                                   88                                             88
2033558 2033558 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_3                                                   82                                             82
2033559 2033559 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_4                                                   89                                             89
2033560 2033560 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   pk_12_total 481 * *   * *         16   265.0 247.0                       512 481                   16   265 247                 512
2033561 2033561 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   105                                             105
2033562 2033562 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   95                                             95
2033563 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
2033564 2033564 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   *                                              
2033565 2033565 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   *                                              
2033566 2033566 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 354 * *   * *         11   177.0 204.0                       381 354                   11   177 204                 381
2033567 2033567 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001188 200010 ALCORN CENTRAL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   elementary_spec_ed                                                   *                                              
2033568 2033568 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001188 200010 ALCORN CENTRAL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5                                                   88                                             88
2033569 2033569 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001188 200010 ALCORN CENTRAL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_6                                                   89                                             89
2033570 2033570 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001188 200010 ALCORN CENTRAL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7                                                   106                                             106
2033571 2033571 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001188 200010 ALCORN CENTRAL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   109                                             109
2033572 2033572 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001188 200010 ALCORN CENTRAL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   secondary_spec_ed                                                   *                                              
2033573 2033573 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001188 200010 ALCORN CENTRAL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   pk_12_total 377 * *   *           12   226.0 175.0                       401 377                   12   226 175                 401
2033574 2033574 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   66                                             66
2033575 2033575 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   pre_kindergarten_spec_ed                                                   *                                              
2033576 2033576 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   kindergarten                                                   114                                             114
2033577 2033577 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   kindergarten_spec_ed                                                   *                                              
2033578 2033578 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   elementary_spec_ed                                                   16                                             16
2033579 2033579 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_1                                                   104                                             104
2033580 2033580 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_2                                                   72                                             72
2033581 2033581 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_3                                                   106                                             106
2033582 2033582 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_4                                                   97                                             97
2033583 2033583 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   pk_12_total 565 * *               *   296.0 284.0                       580 565                       296 284                 580
2033584 2033584 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   elementary_spec_ed                                                   *                                              
2033585 2033585 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5                                                   97                                             97
2033586 2033586 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_6                                                   99                                             99
2033587 2033587 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7                                                   116                                             116
2033588 2033588 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   122                                             122
2033589 2033589 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   secondary_spec_ed                                                   *                                              
2033590 2033590 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001566 200023 KOSSUTH MIDDLE SCHOOL   Regular School No Middle 05 08 2020   pk_12_total 428 * *               *   207.0 236.0                       443 428                       207 236                 443
2033591 2033591 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   101                                             101
2033592 2033592 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   *                                              
2033593 2033593 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000020 200024 KOSSUTH HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   104                                             104

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