enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1812620 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
1812621 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
1812622 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
1812623 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
1812624 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
1812625 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
1812626 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
1805400 1805400 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2020   grade_1 43 10 25   0 2     3   10   48 45                       93 43 10 25   0 2     3   10   48 45                 93
1805401 1805401 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2020   grade_2 57 13 22   0 4     0   12   60 48                       108 57 13 22   0 4     0   12   60 48                 108
1805402 1805402 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2020   grade_3 38 12 39   1 1     1   11   53 50                       103 38 12 39   1 1     1   11   53 50                 103
1805403 1805403 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2020   grade_4 34 9 37   2 2     1   10   39 56                       95 34 9 37   2 2     1   10   39 56                 95
1805404 1805404 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2020   grade_5 47 16 31   2 2     1   8   52 55                       107 47 16 31   2 2     1   8   52 55                 107
1805405 1805405 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 45 9 28   0 2     3   12   50 49                       99 45 9 28   0 2     3   12   50 49                 99
1805406 1805406 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 264 69 182   5 13     9   63   302 303                       605 264 69 182   5 13     9   63   302 303                 605
1805407 1805407 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_1 43 12 24   1 1     1   9   42 49                       91 43 12 24   1 1     1   9   42 49                 91
1805408 1805408 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_2 58 8 23   0 0     2   13   50 54                       104 58 8 23   0 0     2   13   50 54                 104
1805409 1805409 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_3 41 10 22   1 2     2   6   40 44                       84 41 10 22   1 2     2   6   40 44                 84
1805410 1805410 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_4 42 15 39   0 0     1   15   46 66                       112 42 15 39   0 0     1   15   46 66                 112
1805411 1805411 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_5 52 9 34   1 3     3   14   67 49                       116 52 9 34   1 3     3   14   67 49                 116
1805412 1805412 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_6 55 17 26   0 3     4   17   49 73                       122 55 17 26   0 3     4   17   49 73                 122
1805413 1805413 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_7 42 10 27   2 3     4   8   52 44                       96 42 10 27   2 3     4   8   52 44                 96
1805414 1805414 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_8 31 9 15   0 2     3   8   34 34                       68 31 9 15   0 2     3   8   34 34                 68
1805415 1805415 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   kindergarten_full_day 63 16 23   0 0     0   5   60 47                       107 63 16 23   0 0     0   5   60 47                 107
1805416 1805416 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1805417 1805417 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   pk_12_total 428 106 233   5 14     20   95   441 460                       901 428 106 233   5 14     20   95   441 460                 901
1805418 1805418 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2020   grade_1 39 4 21   0 0     0   3   36 31                       67 39 4 21   0 0     0   3   36 31                 67
1805419 1805419 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2020   grade_2 47 4 22   1 1     1   7   45 38                       83 47 4 22   1 1     1   7   45 38                 83
1805420 1805420 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2020   grade_3 43 5 17   1 1     0   5   41 31                       72 43 5 17   1 1     0   5   41 31                 72
1805421 1805421 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2020   grade_4 31 5 11   1 1     0   3   21 31                       52 31 5 11   1 1     0   3   21 31                 52
1805422 1805422 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2020   grade_5 42 3 13   0 0     1   9   32 36                       68 42 3 13   0 0     1   9   32 36                 68
1805423 1805423 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2020   kindergarten_full_day 47 6 17   1 0     1   7   37 42                       79 47 6 17   1 0     1   7   37 42                 79
1805424 1805424 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2020   pk_12_total 249 27 101   4 3     3   34   212 209                       421 249 27 101   4 3     3   34   212 209                 421
1805425 1805425 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2020   grade_6 111 13 65   1 3     2   24   120 99                       219 111 13 65   1 3     2   24   120 99                 219
1805426 1805426 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2020   grade_7 86 25 83   0 1     3   34   124 108                       232 86 25 83   0 1     3   34   124 108                 232
1805427 1805427 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2020   grade_8 130 28 84   1 4     6   36   154 135                       289 130 28 84   1 4     6   36   154 135                 289
1805428 1805428 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2020   pk_12_total 327 66 232   2 8     11   94   398 342                       740 327 66 232   2 8     11   94   398 342                 740
1805429 1805429 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_1 9 2 5   0 0     2   3   7 14                       21 9 2 5   0 0     2   3   7 14                 21
1805430 1805430 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_2 9 2 2   0 0     0   4   10 7                       17 9 2 2   0 0     0   4   10 7                 17
1805431 1805431 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_3 11 2 4   0 0     0   0   8 9                       17 11 2 4   0 0     0   0   8 9                 17
1805432 1805432 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_4 6 0 1   0 0     0   1   4 4                       8 6 0 1   0 0     0   1   4 4                 8
1805433 1805433 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_5 5 1 5   0 0     0   1   3 9                       12 5 1 5   0 0     0   1   3 9                 12
1805434 1805434 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_6 4 0 3   0 0     0   0   7 0                       7 4 0 3   0 0     0   0   7 0                 7
1805435 1805435 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_7 4 1 5   0 0     1   2   11 2                       13 4 1 5   0 0     1   2   11 2                 13
1805436 1805436 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1805437 1805437 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   kindergarten_full_day 7 0 3   0 0     0   2   4 8                       12 7 0 3   0 0     0   2   4 8                 12
1805438 1805438 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   pk_12_total 56 8 28   0 0     3   13   54 54                       108 56 8 28   0 0     3   13   54 54                 108
1805439 1805439 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2020   grade_1 31 5 23   0 0     2   9   38 32                       70 31 5 23   0 0     2   9   38 32                 70
1805440 1805440 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2020   grade_2 38 5 25   0 0     0   8   41 35                       76 38 5 25   0 0     0   8   41 35                 76
1805441 1805441 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2020   grade_3 37 8 22   0 0     0   11   36 42                       78 37 8 22   0 0     0   11   36 42                 78
1805442 1805442 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2020   grade_4 44 4 20   0 0     0   8   45 31                       76 44 4 20   0 0     0   8   45 31                 76
1805443 1805443 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2020   grade_5 37 7 24   2 0     1   10   39 42                       81 37 7 24   2 0     1   10   39 42                 81
1805444 1805444 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 42 7 29   0 1     0   6   36 49                       85 42 7 29   0 1     0   6   36 49                 85
1805445 1805445 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2020   kindergarten_half_day 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
1805446 1805446 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 229 36 143   2 1     3   53   236 231                       467 229 36 143   2 1     3   53   236 231                 467
1805447 1805447 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2020   grade_10 136 32 108   2 4     3   33   188 130                       318 136 32 108   2 4     3   33   188 130                 318
1805448 1805448 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2020   grade_11 155 42 87   2 9     5   25   178 147                       325 155 42 87   2 9     5   25   178 147                 325
1805449 1805449 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2020   grade_12 144 35 99   3 4     4   27   174 142                       316 144 35 99   3 4     4   27   174 142                 316
1805450 1805450 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2020   grade_9 184 32 102   2 6     4   36   187 179                       366 184 32 102   2 6     4   36   187 179                 366
1805451 1805451 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2020   pk_12_total 619 141 396   9 23     16   121   727 598                       1325 619 141 396   9 23     16   121   727 598                 1325
1805452 1805452 CO     school 806480 990   Widefield 3 80648001123 6952 Pinello Elementary School   Regular School No Elementary KG 05 2020   grade_1 15 6 20   0 0     1   8   25 25                       50 15 6 20   0 0     1   8   25 25                 50
1805453 1805453 CO     school 806480 990   Widefield 3 80648001123 6952 Pinello Elementary School   Regular School No Elementary KG 05 2020   grade_2 23 0 23   1 1     0   8   28 28                       56 23 0 23   1 1     0   8   28 28                 56
1805454 1805454 CO     school 806480 990   Widefield 3 80648001123 6952 Pinello Elementary School   Regular School No Elementary KG 05 2020   grade_3 24 3 20   0 0     1   9   30 27                       57 24 3 20   0 0     1   9   30 27                 57
1805455 1805455 CO     school 806480 990   Widefield 3 80648001123 6952 Pinello Elementary School   Regular School No Elementary KG 05 2020   grade_4 28 1 21   0 0     1   1   23 29                       52 28 1 21   0 0     1   1   23 29                 52
1805456 1805456 CO     school 806480 990   Widefield 3 80648001123 6952 Pinello Elementary School   Regular School No Elementary KG 05 2020   grade_5 23 1 22   2 0     0   5   24 29                       53 23 1 22   2 0     0   5   24 29                 53
1805457 1805457 CO     school 806480 990   Widefield 3 80648001123 6952 Pinello Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 24 5 20   1 0     0   4   24 30                       54 24 5 20   1 0     0   4   24 30                 54
1805458 1805458 CO     school 806480 990   Widefield 3 80648001123 6952 Pinello Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 137 16 126   4 1     3   35   154 168                       322 137 16 126   4 1     3   35   154 168                 322
1805459 1805459 CO     school 806480 990   Widefield 3 80648001124 8122 Venetucci Elementary School   Regular School No Elementary KG 05 2020   grade_1 34 8 20   0 0     0   5   38 29                       67 34 8 20   0 0     0   5   38 29                 67
1805460 1805460 CO     school 806480 990   Widefield 3 80648001124 8122 Venetucci Elementary School   Regular School No Elementary KG 05 2020   grade_2 30 6 16   0 0     1   7   35 25                       60 30 6 16   0 0     1   7   35 25                 60
1805461 1805461 CO     school 806480 990   Widefield 3 80648001124 8122 Venetucci Elementary School   Regular School No Elementary KG 05 2020   grade_3 25 7 17   1 0     0   5   32 23                       55 25 7 17   1 0     0   5   32 23                 55
1805462 1805462 CO     school 806480 990   Widefield 3 80648001124 8122 Venetucci Elementary School   Regular School No Elementary KG 05 2020   grade_4 33 4 16   2 1     0   7   30 33                       63 33 4 16   2 1     0   7   30 33                 63
1805463 1805463 CO     school 806480 990   Widefield 3 80648001124 8122 Venetucci Elementary School   Regular School No Elementary KG 05 2020   grade_5 26 8 18   1 2     0   1   35 21                       56 26 8 18   1 2     0   1   35 21                 56
1805464 1805464 CO     school 806480 990   Widefield 3 80648001124 8122 Venetucci Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 27 4 18   1 0     0   0   28 22                       50 27 4 18   1 0     0   0   28 22                 50
1805465 1805465 CO     school 806480 990   Widefield 3 80648001124 8122 Venetucci Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 175 37 105   5 3     1   25   198 153                       351 175 37 105   5 3     1   25   198 153                 351
1805466 1805466 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2020   grade_6 102 12 73   1 3     4   25   108 112                       220 102 12 73   1 3     4   25   108 112                 220
1805467 1805467 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2020   grade_7 89 16 53   0 4     4   28   100 94                       194 89 16 53   0 4     4   28   100 94                 194
1805468 1805468 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2020   grade_8 98 18 70   1 2     1   23   107 106                       213 98 18 70   1 2     1   23   107 106                 213
1805469 1805469 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2020   pk_12_total 289 46 196   2 9     9   76   315 312                       627 289 46 196   2 9     9   76   315 312                 627
1805470 1805470 CO     school 806480 990   Widefield 3 80648001418 8392 Sunrise Elementary School   Regular School No Elementary KG 05 2020   grade_1 50 5 22   1 2     0   11   52 39                       91 50 5 22   1 2     0   11   52 39                 91
1805471 1805471 CO     school 806480 990   Widefield 3 80648001418 8392 Sunrise Elementary School   Regular School No Elementary KG 05 2020   grade_2 46 4 34   0 2     3   10   44 55                       99 46 4 34   0 2     3   10   44 55                 99
1805472 1805472 CO     school 806480 990   Widefield 3 80648001418 8392 Sunrise Elementary School   Regular School No Elementary KG 05 2020   grade_3 47 6 28   0 0     2   7   45 45                       90 47 6 28   0 0     2   7   45 45                 90
1805473 1805473 CO     school 806480 990   Widefield 3 80648001418 8392 Sunrise Elementary School   Regular School No Elementary KG 05 2020   grade_4 45 15 24   0 3     1   12   53 47                       100 45 15 24   0 3     1   12   53 47                 100
1805474 1805474 CO     school 806480 990   Widefield 3 80648001418 8392 Sunrise Elementary School   Regular School No Elementary KG 05 2020   grade_5 47 9 29   0 3     1   4   51 42                       93 47 9 29   0 3     1   4   51 42                 93
1805475 1805475 CO     school 806480 990   Widefield 3 80648001418 8392 Sunrise Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 59 8 29   0 2     3   12   60 53                       113 59 8 29   0 2     3   12   60 53                 113
1805476 1805476 CO     school 806480 990   Widefield 3 80648001418 8392 Sunrise Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 294 47 166   1 12     10   56   305 281                       586 294 47 166   1 12     10   56   305 281                 586
1805477 1805477 CO     school 806480 990   Widefield 3 80648001126 9294 Watson Junior High School   Regular School No Middle 06 08 2020   grade_6 83 21 66   1 3     0   22   96 100                       196 83 21 66   1 3     0   22   96 100                 196
1805478 1805478 CO     school 806480 990   Widefield 3 80648001126 9294 Watson Junior High School   Regular School No Middle 06 08 2020   grade_7 83 23 60   0 0     1   28   90 105                       195 83 23 60   0 0     1   28   90 105                 195
1805479 1805479 CO     school 806480 990   Widefield 3 80648001126 9294 Watson Junior High School   Regular School No Middle 06 08 2020   grade_8 73 18 45   7 2     0   24   89 80                       169 73 18 45   7 2     0   24   89 80                 169
1805480 1805480 CO     school 806480 990   Widefield 3 80648001126 9294 Watson Junior High School   Regular School No Middle 06 08 2020   pk_12_total 239 62 171   8 5     1   74   275 285                       560 239 62 171   8 5     1   74   275 285                 560
1805481 1805481 CO     school 806480 990   Widefield 3 80648001127 9334 Webster Elementary School   Regular School No Elementary KG 05 2020   grade_1 41 3 18   1 0     0   7   33 37                       70 41 3 18   1 0     0   7   33 37                 70
1805482 1805482 CO     school 806480 990   Widefield 3 80648001127 9334 Webster Elementary School   Regular School No Elementary KG 05 2020   grade_2 34 12 28   2 1     0   6   52 31                       83 34 12 28   2 1     0   6   52 31                 83
1805483 1805483 CO     school 806480 990   Widefield 3 80648001127 9334 Webster Elementary School   Regular School No Elementary KG 05 2020   grade_3 28 8 21   0 1     1   9   39 29                       68 28 8 21   0 1     1   9   39 29                 68
1805484 1805484 CO     school 806480 990   Widefield 3 80648001127 9334 Webster Elementary School   Regular School No Elementary KG 05 2020   grade_4 35 8 28   1 1     0   5   37 41                       78 35 8 28   1 1     0   5   37 41                 78
1805485 1805485 CO     school 806480 990   Widefield 3 80648001127 9334 Webster Elementary School   Regular School No Elementary KG 05 2020   grade_5 41 9 28   0 0     0   7   51 34                       85 41 9 28   0 0     0   7   51 34                 85
1805486 1805486 CO     school 806480 990   Widefield 3 80648001127 9334 Webster Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 49 7 23   0 1     2   13   46 49                       95 49 7 23   0 1     2   13   46 49                 95
1805487 1805487 CO     school 806480 990   Widefield 3 80648001127 9334 Webster Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 228 47 146   4 4     3   47   258 221                       479 228 47 146   4 4     3   47   258 221                 479
1805488 1805488 CO     school 806480 990   Widefield 3 80648000051 9560 Discovery High School   Alternative School No High 09 12 2020   grade_10 5 0 5   0 0     1   2   7 6                       13 5 0 5   0 0     1   2   7 6                 13
1805489 1805489 CO     school 806480 990   Widefield 3 80648000051 9560 Discovery High School   Alternative School No High 09 12 2020   grade_11 3 2 6   0 0     0   1   4 8                       12 3 2 6   0 0     0   1   4 8                 12
1805490 1805490 CO     school 806480 990   Widefield 3 80648000051 9560 Discovery High School   Alternative School No High 09 12 2020   grade_12 22 5 14   1 0     0   4   28 18                       46 22 5 14   1 0     0   4   28 18                 46
1805491 1805491 CO     school 806480 990   Widefield 3 80648000051 9560 Discovery High School   Alternative School No High 09 12 2020   pk_12_total 30 7 25   1 0     1   7   39 32                       71 30 7 25   1 0     1   7   39 32                 71
1805492 1805492 CO     school 806480 990   Widefield 3 80648001128 9562 Widefield Elementary School of the Arts   Regular School No Elementary KG 05 2020   grade_1 42 6 20   0 0     3   3   34 40                       74 42 6 20   0 0     3   3   34 40                 74

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