Data source: Big Local News · About: Big Local

13,321 rows where state = "CO" and year = 2020 sorted by rowid descending

View and edit SQL

year

  • 2020 · 13,321
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
1812626 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   pk_12_total 79 39 119   3 8     0   13   219 42                       261 79 39 119   3 8     0   13   219 42                 261
1812625 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_9 15 6 17   0 2     0   7   41 6                       47 15 6 17   0 2     0   7   41 6                 47
1812624 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_8 3 1 7   0 0     0   0   9 2                       11 3 1 7   0 0     0   0   9 2                 11
1812623 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_7 1 1 2   0 0     0   0   4 0                       4 1 1 2   0 0     0   0   4 0                 4
1812622 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_12 29 10 33   0 2     0   2   61 15                       76 29 10 33   0 2     0   2   61 15                 76
1812621 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_11 20 12 35   2 1     0   3   61 12                       73 20 12 35   2 1     0   3   61 12                 73
1812620 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_10 11 9 25   1 3     0   1   43 7                       50 11 9 25   1 3     0   1   43 7                 50
1812619 CO     school 800292 9175   Colorado River BOCES 80029201503 6134 Yampah Mountain School   Alternative School No High 06 12 2020   pk_12_total 80 1 81   4 0     1   1   81 87                       168 80 1 81   4 0     1   1   81 87                 168
1812618 CO     school 800292 9175   Colorado River BOCES 80029201503 6134 Yampah Mountain School   Alternative School No High 06 12 2020   grade_9 4 1 5   0 0     0   0   4 6                       10 4 1 5   0 0     0   0   4 6                 10
1812617 CO     school 800292 9175   Colorado River BOCES 80029201503 6134 Yampah Mountain School   Alternative School No High 06 12 2020   grade_12 34 0 46   3 0     0   0   41 42                       83 34 0 46   3 0     0   0   41 42                 83
1812616 CO     school 800292 9175   Colorado River BOCES 80029201503 6134 Yampah Mountain School   Alternative School No High 06 12 2020   grade_11 24 0 20   0 0     1   1   24 22                       46 24 0 20   0 0     1   1   24 22                 46
1812615 CO     school 800292 9175   Colorado River BOCES 80029201503 6134 Yampah Mountain School   Alternative School No High 06 12 2020   grade_10 18 0 10   1 0     0   0   12 17                       29 18 0 10   1 0     0   0   12 17                 29
1812614 CO     school 800282 9170   Education reEnvisioned BOCES 80028206664 6971 Pikes Peak Online School   Alternative School No High 09 12 2020   pk_12_total 442 49 248   7 9     1   22   399 379                       778 442 49 248   7 9     1   22   399 379                 778
1812613 CO     school 800282 9170   Education reEnvisioned BOCES 80028206664 6971 Pikes Peak Online School   Alternative School No High 09 12 2020   grade_9 29 4 15   0 0     0   4   24 28                       52 29 4 15   0 0     0   4   24 28                 52
1812612 CO     school 800282 9170   Education reEnvisioned BOCES 80028206664 6971 Pikes Peak Online School   Alternative School No High 09 12 2020   grade_12 189 21 109   5 4     1   7   168 168                       336 189 21 109   5 4     1   7   168 168                 336
1812611 CO     school 800282 9170   Education reEnvisioned BOCES 80028206664 6971 Pikes Peak Online School   Alternative School No High 09 12 2020   grade_11 142 16 63   1 3     0   6   120 111                       231 142 16 63   1 3     0   6   120 111                 231
1812610 CO     school 800282 9170   Education reEnvisioned BOCES 80028206664 6971 Pikes Peak Online School   Alternative School No High 09 12 2020   grade_10 82 8 61   1 2     0   5   87 72                       159 82 8 61   1 2     0   5   87 72                 159
1812609 CO     school 800282 9170   Education reEnvisioned BOCES 80028206600 1550 Colorado Preparatory Academy High School   Regular School No High 09 12 2020   pk_12_total 381 43 201   7 9     2   16   266 393                       659 381 43 201   7 9     2   16   266 393                 659
1812608 CO     school 800282 9170   Education reEnvisioned BOCES 80028206600 1550 Colorado Preparatory Academy High School   Regular School No High 09 12 2020   grade_9 100 10 64   2 4     1   4   92 93                       185 100 10 64   2 4     1   4   92 93                 185
1812607 CO     school 800282 9170   Education reEnvisioned BOCES 80028206600 1550 Colorado Preparatory Academy High School   Regular School No High 09 12 2020   grade_12 72 9 29   1 3     1   6   39 82                       121 72 9 29   1 3     1   6   39 82                 121
1812606 CO     school 800282 9170   Education reEnvisioned BOCES 80028206600 1550 Colorado Preparatory Academy High School   Regular School No High 09 12 2020   grade_11 101 15 40   1 1     0   4   55 107                       162 101 15 40   1 1     0   4   55 107                 162
1812605 CO     school 800282 9170   Education reEnvisioned BOCES 80028206600 1550 Colorado Preparatory Academy High School   Regular School No High 09 12 2020   grade_10 108 9 68   3 1     0   2   80 111                       191 108 9 68   3 1     0   2   80 111                 191
1812604 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2020   pk_12_total 392 32 215   8 6     2   30   309 376                       685 392 32 215   8 6     2   30   309 376                 685
1812603 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2020   grade_8 159 17 77   2 2     1   9   102 165                       267 159 17 77   2 2     1   9   102 165                 267
1812602 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2020   grade_7 139 11 80   2 3     1   8   113 131                       244 139 11 80   2 3     1   8   113 131                 244
1812601 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2020   grade_6 94 4 58   4 1     0   13   94 80                       174 94 4 58   4 1     0   13   94 80                 174
1812600 CO     school 800282 9170   Education reEnvisioned BOCES 80028206752 1448 Colorado Preparatory Academy Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 357 61 233   8 9     4   42   377 337                       714 357 61 233   8 9     4   42   377 337                 714
1812599 CO     school 800282 9170   Education reEnvisioned BOCES 80028206752 1448 Colorado Preparatory Academy Elementary School   Regular School No Elementary KG 05 2020   kindergarten_half_day 1 0 2   0 0     0   0   1 2                       3 1 0 2   0 0     0   0   1 2                 3
1812598 CO     school 800282 9170   Education reEnvisioned BOCES 80028206752 1448 Colorado Preparatory Academy Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 55 3 48   0 1     0   8   50 65                       115 55 3 48   0 1     0   8   50 65                 115
1812597 CO     school 800282 9170   Education reEnvisioned BOCES 80028206752 1448 Colorado Preparatory Academy Elementary School   Regular School No Elementary KG 05 2020   grade_5 78 16 48   2 1     1   10   86 70                       156 78 16 48   2 1     1   10   86 70                 156
1812596 CO     school 800282 9170   Education reEnvisioned BOCES 80028206752 1448 Colorado Preparatory Academy Elementary School   Regular School No Elementary KG 05 2020   grade_4 72 5 39   2 2     0   9   62 67                       129 72 5 39   2 2     0   9   62 67                 129
1812595 CO     school 800282 9170   Education reEnvisioned BOCES 80028206752 1448 Colorado Preparatory Academy Elementary School   Regular School No Elementary KG 05 2020   grade_3 54 15 32   2 1     2   4   64 46                       110 54 15 32   2 1     2   4   64 46                 110
1812594 CO     school 800282 9170   Education reEnvisioned BOCES 80028206752 1448 Colorado Preparatory Academy Elementary School   Regular School No Elementary KG 05 2020   grade_2 46 10 34   1 2     0   2   57 38                       95 46 10 34   1 2     0   2   57 38                 95
1812593 CO     school 800282 9170   Education reEnvisioned BOCES 80028206752 1448 Colorado Preparatory Academy Elementary School   Regular School No Elementary KG 05 2020   grade_1 51 12 30   1 2     1   9   57 49                       106 51 12 30   1 2     1   9   57 49                 106
1812592 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   pk_12_total 275 8 43   0 6     0   36   195 173                       368 275 8 43   0 6     0   36   195 173                 368
1812591 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   kindergarten_full_day 19 0 4   0 0     0   3   10 16                       26 19 0 4   0 0     0   3   10 16                 26
1812590 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_9 17 1 1   0 0     0   0   11 8                       19 17 1 1   0 0     0   0   11 8                 19
1812589 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_8 32 0 8   0 0     0   8   25 23                       48 32 0 8   0 0     0   8   25 23                 48
1812588 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_7 35 1 5   0 2     0   7   30 20                       50 35 1 5   0 2     0   7   30 20                 50
1812587 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_6 36 1 8   0 1     0   6   33 19                       52 36 1 8   0 1     0   6   33 19                 52
1812586 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_5 19 1 3   0 0     0   3   13 13                       26 19 1 3   0 0     0   3   13 13                 26
1812585 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_4 22 0 1   0 1     0   2   13 13                       26 22 0 1   0 1     0   2   13 13                 26
1812584 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_3 19 3 1   0 0     0   3   13 13                       26 19 3 1   0 0     0   3   13 13                 26
1812583 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_2 20 0 4   0 1     0   1   12 14                       26 20 0 4   0 1     0   1   12 14                 26
1812582 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_12 17 0 1   0 1     0   0   14 5                       19 17 0 1   0 1     0   0   14 5                 19
1812581 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_11 3 0 3   0 0     0   1   6 1                       7 3 0 3   0 0     0   1   6 1                 7
1812580 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_10 12 1 3   0 0     0   1   5 12                       17 12 1 3   0 0     0   1   5 12                 17
1812579 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_1 24 0 1   0 0     0   1   10 16                       26 24 0 1   0 0     0   1   10 16                 26
1812578 CO     school 899300 9050   San Juan BOCES 89930006497 8121 Southwest Colorado eSchool   Regular School No High 06 12 2020   pk_12_total 53 1 7   0 0     0   0   29 32                       61 53 1 7   0 0     0   0   29 32                 61
1812577 CO     school 899300 9050   San Juan BOCES 89930006497 8121 Southwest Colorado eSchool   Regular School No High 06 12 2020   grade_9 10 0 0   0 0     0   0   6 4                       10 10 0 0   0 0     0   0   6 4                 10
1812576 CO     school 899300 9050   San Juan BOCES 89930006497 8121 Southwest Colorado eSchool   Regular School No High 06 12 2020   grade_8 9 0 3   0 0     0   0   7 5                       12 9 0 3   0 0     0   0   7 5                 12
1812575 CO     school 899300 9050   San Juan BOCES 89930006497 8121 Southwest Colorado eSchool   Regular School No High 06 12 2020   grade_7 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1812574 CO     school 899300 9050   San Juan BOCES 89930006497 8121 Southwest Colorado eSchool   Regular School No High 06 12 2020   grade_6 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1812573 CO     school 899300 9050   San Juan BOCES 89930006497 8121 Southwest Colorado eSchool   Regular School No High 06 12 2020   grade_12 11 0 2   0 0     0   0   8 5                       13 11 0 2   0 0     0   0   8 5                 13
1812572 CO     school 899300 9050   San Juan BOCES 89930006497 8121 Southwest Colorado eSchool   Regular School No High 06 12 2020   grade_11 10 1 1   0 0     0   0   3 9                       12 10 1 1   0 0     0   0   3 9                 12
1812571 CO     school 899300 9050   San Juan BOCES 89930006497 8121 Southwest Colorado eSchool   Regular School No High 06 12 2020   grade_10 8 0 1   0 0     0   0   3 6                       9 8 0 1   0 0     0   0   3 6                 9
1812570 CO     school 899200 9035   Centennial BOCES 89920006560 3997 Innovative Connections High School   Career and Technical School No High 10 12 2020   pk_12_total 15 0 20   1 0     0   0   19 17                       36 15 0 20   1 0     0   0   19 17                 36
1812569 CO     school 899200 9035   Centennial BOCES 89920006560 3997 Innovative Connections High School   Career and Technical School No High 10 12 2020   grade_12 6 0 9   1 0     0   0   6 10                       16 6 0 9   1 0     0   0   6 10                 16
1812568 CO     school 899200 9035   Centennial BOCES 89920006560 3997 Innovative Connections High School   Career and Technical School No High 10 12 2020   grade_11 9 0 11   0 0     0   0   13 7                       20 9 0 11   0 0     0   0   13 7                 20
1812567 CO     school 899200 9035   Centennial BOCES 89920006526 1607 Centennial BOCES High School   Alternative School No High 11 12 2020   pk_12_total 41 1 58   1 1     0   1   58 45                       103 41 1 58   1 1     0   1   58 45                 103
1812566 CO     school 899200 9035   Centennial BOCES 89920006526 1607 Centennial BOCES High School   Alternative School No High 11 12 2020   grade_12 41 1 58   1 1     0   1   58 45                       103 41 1 58   1 1     0   1   58 45                 103
1812565 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   pre_kindergarten 3 0 2   0 0     0   0   2 3                       5 3 0 2   0 0     0   0   2 3                 5
1812564 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   pk_12_total 74 12 84   0 14     0   5   105 84                       189 74 12 84   0 14     0   5   105 84                 189
1812563 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   kindergarten_full_day 5 0 1   0 0     0   0   1 5                       6 5 0 1   0 0     0   0   1 5                 6
1812562 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_9 3 1 5   0 0     0   1   2 8                       10 3 1 5   0 0     0   1   2 8                 10
1812561 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_8 3 0 5   0 0     0   0   3 5                       8 3 0 5   0 0     0   0   3 5                 8
1812560 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_7 5 1 8   0 0     0   0   9 5                       14 5 1 8   0 0     0   0   9 5                 14
1812559 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_6 4 0 6   0 1     0   1   4 8                       12 4 0 6   0 1     0   1   4 8                 12
1812558 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_5 3 1 4   0 3     0   1   8 4                       12 3 1 4   0 3     0   1   8 4                 12
1812557 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_4 3 0 7   0 1     0   0   4 7                       11 3 0 7   0 1     0   0   4 7                 11
1812556 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_3 4 3 5   0 2     0   0   8 6                       14 4 3 5   0 2     0   0   8 6                 14
1812555 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_2 5 3 5   0 0     0   0   7 6                       13 5 3 5   0 0     0   0   7 6                 13
1812554 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_12 17 1 18   0 2     0   2   31 9                       40 17 1 18   0 2     0   2   31 9                 40
1812553 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_11 8 1 4   0 3     0   0   10 6                       16 8 1 4   0 3     0   0   10 6                 16
1812552 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_10 8 1 9   0 2     0   0   13 7                       20 8 1 9   0 2     0   0   13 7                 20
1812551 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_1 3 0 5   0 0     0   0   3 5                       8 3 0 5   0 0     0   0   3 5                 8
1812550 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2020   pk_12_total 10 3 188   0 0     0   3   95 109                       204 10 3 188   0 0     0   3   95 109                 204
1812549 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2020   grade_8 2 1 57   0 0     0   0   27 33                       60 2 1 57   0 0     0   0   27 33                 60
1812548 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2020   grade_7 5 1 70   0 0     0   1   41 36                       77 5 1 70   0 0     0   1   41 36                 77
1812547 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2020   grade_6 3 1 61   0 0     0   2   27 40                       67 3 1 61   0 0     0   2   27 40                 67
1812546 CO     school 800020 8001   Charter School Institute 80002006585 9037 Victory Preparatory Academy High State Charter School   Regular School Yes High 09 12 2020   pk_12_total 5 1 117   0 0     0   0   52 71                       123 5 1 117   0 0     0   0   52 71                 123
1812545 CO     school 800020 8001   Charter School Institute 80002006585 9037 Victory Preparatory Academy High State Charter School   Regular School Yes High 09 12 2020   grade_9 1 1 47   0 0     0   0   21 28                       49 1 1 47   0 0     0   0   21 28                 49
1812544 CO     school 800020 8001   Charter School Institute 80002006585 9037 Victory Preparatory Academy High State Charter School   Regular School Yes High 09 12 2020   grade_12 2 0 15   0 0     0   0   5 12                       17 2 0 15   0 0     0   0   5 12                 17
1812543 CO     school 800020 8001   Charter School Institute 80002006585 9037 Victory Preparatory Academy High State Charter School   Regular School Yes High 09 12 2020   grade_11 2 0 28   0 0     0   0   15 15                       30 2 0 28   0 0     0   0   15 15                 30
1812542 CO     school 800020 8001   Charter School Institute 80002006585 9037 Victory Preparatory Academy High State Charter School   Regular School Yes High 09 12 2020   grade_10 0 0 27   0 0     0   0   11 16                       27 0 0 27   0 0     0   0   11 16                 27
1812541 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   pk_12_total 573 11 189   2 22     0   70   414 453                       867 573 11 189   2 22     0   70   414 453                 867
1812540 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   kindergarten_half_day 24 0 5   0 1     0   3   17 16                       33 24 0 5   0 1     0   3   17 16                 33
1812539 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   kindergarten_full_day 13 0 7   0 1     0   3   13 11                       24 13 0 7   0 1     0   3   13 11                 24
1812538 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_9 56 0 10   0 2     0   5   38 35                       73 56 0 10   0 2     0   5   38 35                 73
1812537 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_8 58 3 18   0 2     0   3   41 43                       84 58 3 18   0 2     0   3   41 43                 84
1812536 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_7 60 1 21   0 4     0   7   47 46                       93 60 1 21   0 4     0   7   47 46                 93
1812535 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_6 63 3 21   1 2     0   9   49 50                       99 63 3 21   1 2     0   9   49 50                 99
1812534 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_5 30 0 14   0 1     0   9   32 22                       54 30 0 14   0 1     0   9   32 22                 54
1812533 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_4 57 1 15   0 1     0   6   33 47                       80 57 1 15   0 1     0   6   33 47                 80
1812532 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_3 32 1 17   0 2     0   3   23 32                       55 32 1 17   0 2     0   3   23 32                 55
1812531 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_2 37 0 14   0 0     0   3   25 29                       54 37 0 14   0 0     0   3   25 29                 54
1812530 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_12 27 0 7   0 3     0   8   17 28                       45 27 0 7   0 3     0   8   17 28                 45
1812529 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_11 41 1 16   0 0     0   3   30 31                       61 41 1 16   0 0     0   3   30 31                 61
1812528 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_10 42 0 10   0 3     0   3   24 34                       58 42 0 10   0 3     0   3   24 34                 58
1812527 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_1 33 1 14   1 0     0   5   25 29                       54 33 1 14   1 0     0   5   25 29                 54

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