Data source: Big Local News · About: Big Local

13,286 rows where state = "CO" and year = 2021 sorted by district_nces_id

View and edit SQL

year

  • 2021 · 13,286
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
1741534 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   grade_1 15 0 2   0 0     0   0   6 11                       17 15 0 2   0 0     0   0   6 11                 17
1741535 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   grade_2 11 0 0   0 0     0   0   10 1                       11 11 0 0   0 0     0   0   10 1                 11
1741536 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   grade_3 16 0 2   0 0     0   0   9 9                       18 16 0 2   0 0     0   0   9 9                 18
1741537 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   grade_4 14 0 2   0 0     0   0   5 11                       16 14 0 2   0 0     0   0   5 11                 16
1741538 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   grade_5 7 0 3   0 0     0   0   5 5                       10 7 0 3   0 0     0   0   5 5                 10
1741539 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   grade_6 12 0 1   0 0     0   0   7 6                       13 12 0 1   0 0     0   0   7 6                 13
1741540 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   kindergarten_full_day 13 0 1   0 0     0   0   7 7                       14 13 0 1   0 0     0   0   7 7                 14
1741541 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   pk_12_total 95 0 11   0 0     0   0   53 53                       106 95 0 11   0 0     0   0   53 53                 106
1741542 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten 7 0 0   0 0     0   0   4 3                       7 7 0 0   0 0     0   0   4 3                 7
1741543 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2021   grade_10 13 0 0   0 0     0   0   7 6                       13 13 0 0   0 0     0   0   7 6                 13
1741544 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2021   grade_11 10 0 2   0 0     0   0   7 5                       12 10 0 2   0 0     0   0   7 5                 12
1741545 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2021   grade_12 5 0 2   0 0     0   0   6 1                       7 5 0 2   0 0     0   0   6 1                 7
1741546 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2021   grade_7 8 1 2   0 0     0   0   3 8                       11 8 1 2   0 0     0   0   3 8                 11
1741547 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2021   grade_8 11 0 2   0 0     0   0   8 5                       13 11 0 2   0 0     0   0   8 5                 13
1741548 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2021   grade_9 7 0 4   0 0     0   0   7 4                       11 7 0 4   0 0     0   0   7 4                 11
1741549 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2021   pk_12_total 54 1 12   0 0     0   0   38 29                       67 54 1 12   0 0     0   0   38 29                 67
1751486 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_1 21 0 3   0 0     0   3   14 13                       27 21 0 3   0 0     0   3   14 13                 27
1751487 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_10 15 1 1   0 0     0   1   11 7                       18 15 1 1   0 0     0   1   11 7                 18
1751488 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_11 10 1 3   0 0     0   1   5 10                       15 10 1 3   0 0     0   1   5 10                 15
1751489 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_12 2 0 3   0 1     0   2   8 0                       8 2 0 3   0 1     0   2   8 0                 8
1751490 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_2 22 0 2   0 0     0   2   10 16                       26 22 0 2   0 0     0   2   10 16                 26
1751491 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_3 19 0 6   0 1     0   1   11 16                       27 19 0 6   0 1     0   1   11 16                 27
1751492 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_4 19 3 2   0 0     0   3   11 16                       27 19 3 2   0 0     0   3   11 16                 27
1751493 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_5 23 0 1   0 0     0   2   13 13                       26 23 0 1   0 0     0   2   13 13                 26
1751494 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_6 40 4 4   0 1     0   3   29 23                       52 40 4 4   0 1     0   3   29 23                 52
1751495 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_7 36 1 7   0 1     0   7   32 20                       52 36 1 7   0 1     0   7   32 20                 52
1751496 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_8 36 0 7   0 2     0   7   32 20                       52 36 0 7   0 2     0   7   32 20                 52
1751497 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_9 21 0 7   0 0     0   4   19 13                       32 21 0 7   0 0     0   4   19 13                 32
1751498 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   kindergarten_full_day 17 2 4   0 0     0   3   16 10                       26 17 2 4   0 0     0   3   16 10                 26
1751499 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   pk_12_total 281 12 50   0 6     0   39   211 177                       388 281 12 50   0 6     0   39   211 177                 388
1751015 CO     school 800016 3200   Yuma 1 80001601745 5221 Little Indians Preschool   Regular School No Prekindergarten PK PK 2021   pk_12_total 20 0 42   0 0     0   0   36 26                       62 20 0 42   0 0     0   0   36 26                 62
1751016 CO     school 800016 3200   Yuma 1 80001601745 5221 Little Indians Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 20 0 42   0 0     0   0   36 26                       62 20 0 42   0 0     0   0   36 26                 62
1751017 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2021   grade_5 21 0 47   0 0     0   0   36 32                       68 21 0 47   0 0     0   0   36 32                 68
1751018 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2021   grade_6 29 0 32   0 0     0   0   32 29                       61 29 0 32   0 0     0   0   32 29                 61
1751019 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2021   grade_7 25 0 44   0 0     0   0   31 38                       69 25 0 44   0 0     0   0   31 38                 69
1751020 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2021   grade_8 34 0 31   0 0     0   0   34 31                       65 34 0 31   0 0     0   0   34 31                 65
1751021 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2021   pk_12_total 109 0 154   0 0     0   0   133 130                       263 109 0 154   0 0     0   0   133 130                 263
1751022 CO     school 800016 3200   Yuma 1 80001601820 9795 Kenneth P Morris Elementary School   Regular School No Elementary KG 04 2021   grade_1 29 0 28   0 0     0   0   29 28                       57 29 0 28   0 0     0   0   29 28                 57
1751023 CO     school 800016 3200   Yuma 1 80001601820 9795 Kenneth P Morris Elementary School   Regular School No Elementary KG 04 2021   grade_2 28 0 36   0 0     0   0   35 29                       64 28 0 36   0 0     0   0   35 29                 64
1751024 CO     school 800016 3200   Yuma 1 80001601820 9795 Kenneth P Morris Elementary School   Regular School No Elementary KG 04 2021   grade_3 23 0 36   0 0     0   0   29 30                       59 23 0 36   0 0     0   0   29 30                 59
1751025 CO     school 800016 3200   Yuma 1 80001601820 9795 Kenneth P Morris Elementary School   Regular School No Elementary KG 04 2021   grade_4 26 0 39   0 0     0   0   26 39                       65 26 0 39   0 0     0   0   26 39                 65
1751026 CO     school 800016 3200   Yuma 1 80001601820 9795 Kenneth P Morris Elementary School   Regular School No Elementary KG 04 2021   kindergarten_full_day 38 0 31   0 0     0   0   30 39                       69 38 0 31   0 0     0   0   30 39                 69
1751027 CO     school 800016 3200   Yuma 1 80001601820 9795 Kenneth P Morris Elementary School   Regular School No Elementary KG 04 2021   pk_12_total 144 0 170   0 0     0   0   149 165                       314 144 0 170   0 0     0   0   149 165                 314
1751028 CO     school 800016 3200   Yuma 1 80001601821 9799 Yuma High School   Regular School No High 09 12 2021   grade_10 27 0 39   0 0     0   1   37 30                       67 27 0 39   0 0     0   1   37 30                 67
1751029 CO     school 800016 3200   Yuma 1 80001601821 9799 Yuma High School   Regular School No High 09 12 2021   grade_11 22 1 29   0 1     0   0   22 31                       53 22 1 29   0 1     0   0   22 31                 53
1751030 CO     school 800016 3200   Yuma 1 80001601821 9799 Yuma High School   Regular School No High 09 12 2021   grade_12 39 0 35   1 0     0   0   40 35                       75 39 0 35   1 0     0   0   40 35                 75
1751031 CO     school 800016 3200   Yuma 1 80001601821 9799 Yuma High School   Regular School No High 09 12 2021   grade_9 33 0 39   0 0     0   0   35 37                       72 33 0 39   0 0     0   0   35 37                 72
1751032 CO     school 800016 3200   Yuma 1 80001601821 9799 Yuma High School   Regular School No High 09 12 2021   pk_12_total 121 1 142   1 1     0   1   134 133                       267 121 1 142   1 1     0   1   134 133                 267
1751033 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 06 2021   grade_1 35 0 14   0 0     0   2   24 27                       51 35 0 14   0 0     0   2   24 27                 51
1751034 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 06 2021   grade_2 36 0 9   0 0     0   0   23 22                       45 36 0 9   0 0     0   0   23 22                 45
1751035 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 06 2021   grade_3 34 0 19   0 0     0   0   32 21                       53 34 0 19   0 0     0   0   32 21                 53
1751036 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 06 2021   grade_4 34 0 23   0 0     0   0   27 30                       57 34 0 23   0 0     0   0   27 30                 57
1751037 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 06 2021   grade_5 41 0 17   0 0     0   0   34 24                       58 41 0 17   0 0     0   0   34 24                 58
1751038 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 06 2021   grade_6 34 0 19   0 0     0   1   24 30                       54 34 0 19   0 0     0   1   24 30                 54
1751039 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 06 2021   kindergarten_full_day 28 0 27   0 0     0   1   26 30                       56 28 0 27   0 0     0   1   26 30                 56
1751040 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 06 2021   pk_12_total 278 0 141   0 0     0   5   218 206                       424 278 0 141   0 0     0   5   218 206                 424
1751041 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten 36 0 13   0 0     0   1   28 22                       50 36 0 13   0 0     0   1   28 22                 50
1751042 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray Junior Senior High School   Regular School No High 07 12 2021   grade_10 34 0 15   1 0     0   1   28 23                       51 34 0 15   1 0     0   1   28 23                 51
1751043 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray Junior Senior High School   Regular School No High 07 12 2021   grade_11 37 0 19   0 0     0   0   24 32                       56 37 0 19   0 0     0   0   24 32                 56
1751044 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray Junior Senior High School   Regular School No High 07 12 2021   grade_12 37 0 18   0 0     0   2   31 26                       57 37 0 18   0 0     0   2   31 26                 57
1751045 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray Junior Senior High School   Regular School No High 07 12 2021   grade_7 33 0 15   0 0     0   0   22 26                       48 33 0 15   0 0     0   0   22 26                 48
1751046 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray Junior Senior High School   Regular School No High 07 12 2021   grade_8 32 0 20   1 0     0   0   27 26                       53 32 0 20   1 0     0   0   27 26                 53
1751047 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray Junior Senior High School   Regular School No High 07 12 2021   grade_9 47 0 11   0 0     0   0   21 37                       58 47 0 11   0 0     0   0   21 37                 58
1751048 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray Junior Senior High School   Regular School No High 07 12 2021   pk_12_total 220 0 98   2 0     0   3   153 170                       323 220 0 98   2 0     0   3   153 170                 323
1751049 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2021   grade_1 4 0 1   0 0     0   0   2 3                       5 4 0 1   0 0     0   0   2 3                 5
1751050 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2021   grade_2 9 0 2   0 0     0   0   3 8                       11 9 0 2   0 0     0   0   3 8                 11
1751051 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2021   grade_3 10 0 3   0 0     0   0   3 10                       13 10 0 3   0 0     0   0   3 10                 13
1751052 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2021   grade_4 13 0 2   0 0     0   0   9 6                       15 13 0 2   0 0     0   0   9 6                 15
1751053 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2021   grade_5 9 0 5   0 0     0   0   8 6                       14 9 0 5   0 0     0   0   8 6                 14
1751054 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2021   grade_6 12 0 5   0 0     0   0   6 11                       17 12 0 5   0 0     0   0   6 11                 17
1751055 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2021   kindergarten_full_day 8 0 2   0 0     0   0   1 9                       10 8 0 2   0 0     0   0   1 9                 10
1751056 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2021   pk_12_total 79 0 25   0 0     0   1   48 57                       105 79 0 25   0 0     0   1   48 57                 105
1751057 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten 14 0 5   0 0     0   1   16 4                       20 14 0 5   0 0     0   1   16 4                 20
1751058 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2021   grade_10 10 0 5   0 0     0   0   6 9                       15 10 0 5   0 0     0   0   6 9                 15
1751059 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2021   grade_11 12 0 5   1 0     0   0   6 12                       18 12 0 5   1 0     0   0   6 12                 18
1751060 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2021   grade_12 7 0 0   0 0     0   0   1 6                       7 7 0 0   0 0     0   0   1 6                 7
1751061 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2021   grade_7 14 0 3   0 0     0   0   7 10                       17 14 0 3   0 0     0   0   7 10                 17
1751062 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2021   grade_8 9 0 4   0 0     0   0   6 7                       13 9 0 4   0 0     0   0   6 7                 13
1751063 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2021   grade_9 14 0 8   0 0     0   0   12 10                       22 14 0 8   0 0     0   0   12 10                 22
1751064 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2021   pk_12_total 66 0 25   1 0     0   0   38 54                       92 66 0 25   1 0     0   0   38 54                 92
1751065 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_1 5 0 2   0 0     0   0   3 4                       7 5 0 2   0 0     0   0   3 4                 7
1751066 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_10 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3
1751067 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_11 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1751068 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_12 4 0 0   0 0     0   0   3 1                       4 4 0 0   0 0     0   0   3 1                 4
1751069 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_2 6 0 0   0 0     0   0   5 1                       6 6 0 0   0 0     0   0   5 1                 6
1751070 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_3 2 0 2   0 0     0   0   1 3                       4 2 0 2   0 0     0   0   1 3                 4
1751071 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_4 7 0 1   0 0     0   0   5 3                       8 7 0 1   0 0     0   0   5 3                 8
1751072 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_5 1 0 1   0 0     0   0   1 1                       2 1 0 1   0 0     0   0   1 1                 2
1751073 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_6 8 0 1   0 0     0   0   6 3                       9 8 0 1   0 0     0   0   6 3                 9
1751074 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_7 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
1751075 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_8 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1751076 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_9 4 0 0   0 0     0   0   3 1                       4 4 0 0   0 0     0   0   3 1                 4
1751077 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   kindergarten_full_day 5 0 0   0 0     0   0   2 3                       5 5 0 0   0 0     0   0   2 3                 5
1751078 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   pk_12_total 57 0 8   0 0     0   0   40 25                       65 57 0 8   0 0     0   0   40 25                 65
1751079 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   pre_kindergarten 8 0 1   0 0     0   0   5 4                       9 8 0 1   0 0     0   0   5 4                 9
1751080 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_1 83 1 36   0 12     0   13   74 71                       145 83 1 36   0 12     0   13   74 71                 145
1751081 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_10 70 2 48   0 15     0   4   66 73                       139 70 2 48   0 15     0   4   66 73                 139
1751082 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_11 82 1 46   1 10     0   5   71 74                       145 82 1 46   1 10     0   5   71 74                 145
1751083 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_12 76 0 40   0 13     0   6   57 78                       135 76 0 40   0 13     0   6   57 78                 135
1751084 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_2 86 1 33   0 13     0   9   64 78                       142 86 1 33   0 13     0   9   64 78                 142

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