enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2034301 2034301 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000177 1600008 COLLINS HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   49                                             49
2034302 2034302 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000177 1600008 COLLINS HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   43                                             43
2034303 2034303 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000177 1600008 COLLINS HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   35                                             35
2034304 2034304 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000177 1600008 COLLINS HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   11                                             11
2034305 2034305 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000177 1600008 COLLINS HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 30 159 *               *   104.0 100.0                       204 30 159                     104 100                 204
2240836 2240836 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000177 1600008 COLLINS HIGH SCHOOL   Regular School No High 09 12 2021   grade_9                                                   95                                             95
2240837 2240837 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000177 1600008 COLLINS HIGH SCHOOL   Regular School No High 09 12 2021   grade_10                                                   54                                             54
2240838 2240838 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000177 1600008 COLLINS HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   39                                             39
2240839 2240839 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000177 1600008 COLLINS HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   *                                              
2240840 2240840 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000177 1600008 COLLINS HIGH SCHOOL   Regular School No High 09 12 2021   secondary_spec_ed                                                   *                                              
2240841 2240841 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000177 1600008 COLLINS HIGH SCHOOL   Regular School No High 09 12 2021   pk_12_total 44 170 16     *         *   122 113                       235 44 170 16                   122 113                 235
2034306 2034306 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2020   elementary_spec_ed                                                   *                                              
2034307 2034307 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5                                                   69                                             69
2034308 2034308 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_6                                                   58                                             58
2034309 2034309 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7                                                   75                                             75
2034310 2034310 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8                                                   77                                             77
2034311 2034311 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2020   secondary_spec_ed                                                   *                                              
2034312 2034312 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2020   pk_12_total 54 199 26     *     *   11   155.0 137.0                       292 54 199 26               11   155 137                 292
2240842 2240842 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2021   elementary_spec_ed                                                   *                                              
2240843 2240843 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_5                                                   54                                             54
2240844 2240844 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_6                                                   66                                             66
2240845 2240845 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   63                                             63
2240846 2240846 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_8                                                   79                                             79
2240847 2240847 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2021   secondary_spec_ed                                                   *                                              
2240848 2240848 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000178 1600012 CARVER MIDDLE SCHOOL   Regular School No Middle 05 08 2021   pk_12_total 53 183 24           *   *   138 139                       277 53 183 24                   138 139                 277
2034313 2034313 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   kindergarten                                                   41                                             41
2034314 2034314 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   elementary_spec_ed                                                   *                                              
2034315 2034315 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_1                                                   34                                             34
2034316 2034316 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_2                                                   37                                             37
2034317 2034317 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_3                                                   41                                             41
2034318 2034318 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_4                                                   37                                             37
2034319 2034319 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_5                                                   34                                             34
2034320 2034320 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   grade_6                                                   *                                              
2034321 2034321 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   pk_12_total * 241                 *   132.0 126.0                       258   241                     132 126                 258
2240849 2240849 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   kindergarten                                                   32                                             32
2240850 2240850 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_1                                                   37                                             37
2240851 2240851 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_2                                                   30                                             30
2240852 2240852 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_3                                                   35                                             35
2240853 2240853 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_4                                                   34                                             34
2240854 2240854 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_5                                                   34                                             34
2240855 2240855 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   grade_6                                                   36                                             36
2240856 2240856 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000180 1600016 HOPEWELL ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2021   pk_12_total * 222                 *   116 122                       238   222                     116 122                 238
2034322 2034322 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   kindergarten                                                   25                                             25
2034323 2034323 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   elementary_spec_ed                                                   *                                              
2034324 2034324 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_1                                                   29                                             29
2034325 2034325 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_2                                                   30                                             30
2034326 2034326 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_3                                                   23                                             23
2034327 2034327 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_4                                                   25                                             25
2034328 2034328 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_5                                                   31                                             31
2034329 2034329 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_6                                                   28                                             28
2034330 2034330 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_7                                                   30                                             30
2034331 2034331 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_8                                                   35                                             35
2034332 2034332 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_9                                                   20                                             20
2034333 2034333 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_10                                                   34                                             34
2034334 2034334 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_11                                                   28                                             28
2034335 2034335 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   grade_12                                                   23                                             23
2034336 2034336 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   secondary_spec_ed                                                   *                                              
2034337 2034337 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2020   pk_12_total 133 220 *     *         *   205.0 164.0                       369 133 220                     205 164                 369
2240857 2240857 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   kindergarten                                                   30                                             30
2240858 2240858 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   elementary_spec_ed                                                   *                                              
2240859 2240859 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_1                                                   24                                             24
2240860 2240860 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_2                                                   26                                             26
2240861 2240861 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_3                                                   32                                             32
2240862 2240862 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_4                                                   24                                             24
2240863 2240863 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_5                                                   29                                             29
2240864 2240864 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_6                                                   29                                             29
2240865 2240865 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_7                                                   28                                             28
2240866 2240866 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_8                                                   29                                             29
2240867 2240867 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_9                                                   32                                             32
2240868 2240868 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_10                                                   19                                             19
2240869 2240869 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_11                                                   30                                             30
2240870 2240870 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_12                                                   23                                             23
2240871 2240871 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   secondary_spec_ed                                                   *                                              
2240872 2240872 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000181 1600020 MOUNT OLIVE ATTENDANCE CENTER   Regular School No Other KG 12 2021   pk_12_total 121 231 *     *         *   197 168                       365 121 231                     197 168                 365
2034338 2034338 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2020   grade_9                                                   109                                             109
2034339 2034339 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2020   grade_10                                                   96                                             96
2034340 2034340 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2020   grade_11                                                   93                                             93
2034341 2034341 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2020   grade_12                                                   *                                              
2034342 2034342 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2020   secondary_spec_ed                                                   *                                              
2034343 2034343 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2020   pk_12_total 253 129 *               *   189.0 205.0                       394 253 129                     189 205                 394
2240873 2240873 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2021   grade_9                                                   119                                             119
2240874 2240874 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2021   grade_10                                                   102                                             102
2240875 2240875 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2021   grade_11                                                   89                                             89
2240876 2240876 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2021   grade_12                                                   68                                             68
2240877 2240877 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129000182 1600024 SEMINARY HIGH SCHOOL   Regular School No High 09 12 2021   pk_12_total 234 128 *               *   185 193                       378 234 128                     185 193                 378
2034344 2034344 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   kindergarten                                                   93                                             93
2034345 2034345 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_1                                                   98                                             98
2034346 2034346 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_2                                                   71                                             71
2034347 2034347 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_3                                                   92                                             92
2034348 2034348 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   grade_4                                                   72                                             72
2034349 2034349 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2020   pk_12_total 337 58 16               15   223.0 203.0                       426 337 58 16               15   223 203                 426
2240878 2240878 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   kindergarten                                                   78                                             78
2240879 2240879 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_1                                                   80                                             80
2240880 2240880 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_2                                                   90                                             90
2240881 2240881 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_3                                                   65                                             65
2240882 2240882 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   grade_4                                                   89                                             89
2240883 2240883 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001334 1600025 SEMINARY ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2021   pk_12_total 312 59 19               12   195 207                       402 312 59 19               12   195 207                 402
2034350 2034350 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001337 1600026 SEMINARY MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5                                                   *                                              
2034351 2034351 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001337 1600026 SEMINARY MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_6                                                   101                                             101
2034352 2034352 MS     school 2801290 1600   COVINGTON CO SCHOOLS 280129001337 1600026 SEMINARY MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_7                                                   123                                             123

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