Data source: Big Local News · About: Big Local

12,592 rows where state = "MS" sorted by disability_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
2033480 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   17                                             17
2033481 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pre_kindergarten_spec_ed                                                   *                                              
2033482 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten                                                   110                                             110
2033483 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   kindergarten_spec_ed                                                   *                                              
2033484 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   elementary_spec_ed                                                   22                                             22
2033485 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_1                                                   100                                             100
2033486 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_2                                                   108                                             108
2033487 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_3                                                   75                                             75
2033488 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_4                                                   83                                             83
2033489 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   grade_5                                                   102                                             102
2033490 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000600 130020 MC LAURIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2020   pk_12_total 99 514 *     *         *   313.0 317.0                       630 99 514                     313 317                 630
2033491 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000602 130028 MORGANTOWN MIDDLE   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2033492 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000602 130028 MORGANTOWN MIDDLE   Regular School No Middle 06 08 2020   grade_6                                                   99                                             99
2033493 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000602 130028 MORGANTOWN MIDDLE   Regular School No Middle 06 08 2020   grade_7                                                   108                                             108
2033494 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000602 130028 MORGANTOWN MIDDLE   Regular School No Middle 06 08 2020   grade_8                                                   127                                             127
2033495 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000602 130028 MORGANTOWN MIDDLE   Regular School No Middle 06 08 2020   secondary_spec_ed                                                   *                                              
2033496 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000602 130028 MORGANTOWN MIDDLE   Regular School No Middle 06 08 2020   pk_12_total * 317                 *   174.0 175.0                       349   317                     174 175                 349
2033497 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000604 130036 ROBERT LEWIS MAGNET SCHOOL   Regular School No Middle 06 08 2020   elementary_spec_ed                                                   *                                              
2033498 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000604 130036 ROBERT LEWIS MAGNET SCHOOL   Regular School No Middle 06 08 2020   grade_6                                                   127                                             127
2033499 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000604 130036 ROBERT LEWIS MAGNET SCHOOL   Regular School No Middle 06 08 2020   grade_7                                                   113                                             113
2033500 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000604 130036 ROBERT LEWIS MAGNET SCHOOL   Regular School No Middle 06 08 2020   grade_8                                                   119                                             119
2033501 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000604 130036 ROBERT LEWIS MAGNET SCHOOL   Regular School No Middle 06 08 2020   secondary_spec_ed                                                   *                                              
2033502 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000604 130036 ROBERT LEWIS MAGNET SCHOOL   Regular School No Middle 06 08 2020   pk_12_total 35 328 *   * *         *   188.0 184.0                       372 35 328                     188 184                 372
2033503 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000606 130040 JOSEPH L FRAZIER ELEMENTARY   Regular School No Elementary KG 05 2020   kindergarten                                                   76                                             76
2033504 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000606 130040 JOSEPH L FRAZIER ELEMENTARY   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   12                                             12
2033505 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000606 130040 JOSEPH L FRAZIER ELEMENTARY   Regular School No Elementary KG 05 2020   grade_1                                                   77                                             77
2033506 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000606 130040 JOSEPH L FRAZIER ELEMENTARY   Regular School No Elementary KG 05 2020   grade_2                                                   76                                             76
2033507 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000606 130040 JOSEPH L FRAZIER ELEMENTARY   Regular School No Elementary KG 05 2020   grade_3                                                   88                                             88
2033508 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000606 130040 JOSEPH L FRAZIER ELEMENTARY   Regular School No Elementary KG 05 2020   grade_4                                                   61                                             61
2033509 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000606 130040 JOSEPH L FRAZIER ELEMENTARY   Regular School No Elementary KG 05 2020   grade_5                                                   79                                             79
2033510 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000606 130040 JOSEPH L FRAZIER ELEMENTARY   Regular School No Elementary KG 05 2020   pk_12_total * 449 *               *   219.0 250.0                       469   449                     219 250                 469
2033511 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001414 130043 NATCHEZ EARLY COLLEGE@CO-LIN   Regular School No High 09 12 2020   grade_9                                                   52                                             52
2033512 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001414 130043 NATCHEZ EARLY COLLEGE@CO-LIN   Regular School No High 09 12 2020   grade_10                                                   51                                             51
2033513 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001414 130043 NATCHEZ EARLY COLLEGE@CO-LIN   Regular School No High 09 12 2020   grade_11                                                   42                                             42
2033514 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001414 130043 NATCHEZ EARLY COLLEGE@CO-LIN   Regular School No High 09 12 2020   grade_12                                                   33                                             33
2033515 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001414 130043 NATCHEZ EARLY COLLEGE@CO-LIN   Regular School No High 09 12 2020   pk_12_total * 163 *                   53.0 125.0                       178   163                     53 125                 178
2033516 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000608 130044 NATCHEZ HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   171                                             171
2033517 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000608 130044 NATCHEZ HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   171                                             171
2033518 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000608 130044 NATCHEZ HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   155                                             155
2033519 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000608 130044 NATCHEZ HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   26                                             26
2033520 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000608 130044 NATCHEZ HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 26 490 *     *         *   288.0 235.0                       523 26 490                     288 235                 523
2033521 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001397 130045 NATCHEZ FRESHMAN ACADEMY   Regular School No Secondary 08 09 2020   grade_9                                                   *                                              
2033522 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001397 130045 NATCHEZ FRESHMAN ACADEMY   Regular School No Secondary 08 09 2020   secondary_spec_ed                                                   *                                              
2033523 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303001397 130045 NATCHEZ FRESHMAN ACADEMY   Regular School No Secondary 08 09 2020   pk_12_total * 186                 *   104.0 96.0                       200   186                     104 96                 200
2033524 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000610 130056 SUSIE B WEST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   kindergarten                                                   81                                             81
2033525 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000610 130056 SUSIE B WEST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   elementary_spec_ed                                                   *                                              
2033526 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000610 130056 SUSIE B WEST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_1                                                   61                                             61
2033527 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000610 130056 SUSIE B WEST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_2                                                   60                                             60
2033528 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000610 130056 SUSIE B WEST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_3                                                   69                                             69
2033529 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000610 130056 SUSIE B WEST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_4                                                   53                                             53
2033530 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000610 130056 SUSIE B WEST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   grade_5                                                   *                                              
2033531 MS     school 2803030 130   NATCHEZ-ADAMS SCHOOL DIST 280303000610 130056 SUSIE B WEST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2020   pk_12_total * 335 *                   189.0 194.0                       383   335                     189 194                 383
2033532 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   20                                             20
2033533 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   kindergarten                                                   36                                             36
2033534 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   kindergarten_spec_ed                                                   *                                              
2033535 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   elementary_spec_ed                                                   *                                              
2033536 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_1                                                   44                                             44
2033537 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_2                                                   32                                             32
2033538 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_3                                                   36                                             36
2033539 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_4                                                   34                                             34
2033540 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_5                                                   42                                             42
2033541 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000017 200002 BIGGERSVILLE ELEMENTARY   Regular School No Elementary PK 06 2020   grade_6                                                   37                                             37
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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_7                                                   36                                             36
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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_9                                                   41                                             41
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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_11                                                   33                                             33
2033548 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   grade_12                                                   *                                              
2033549 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001152 200004 BIGGERSVILLE HIGH SCHOOL   Regular School No High 07 12 2020   secondary_spec_ed                                                   *                                              
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 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 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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   kindergarten                                                   89                                             89
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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001150 200006 ALCORN CENTRAL ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   elementary_spec_ed                                                   *                                              
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 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 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 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 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 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 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 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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039000018 200008 ALCORN CENTRAL HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   *                                              
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 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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001188 200010 ALCORN CENTRAL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   elementary_spec_ed                                                   *                                              
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 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 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 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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001188 200010 ALCORN CENTRAL MIDDLE SCHOOL   Regular School No Middle 05 08 2020   secondary_spec_ed                                                   *                                              
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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   66                                             66
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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   kindergarten                                                   114                                             114
2033577 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   kindergarten_spec_ed                                                   *                                              
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 MS     school 2800390 200   ALCORN SCHOOL DIST 280039001151 200022 KOSSUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2020   grade_1                                                   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]);