enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1806067 1806067 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_1 41 1 8   0 0     0   5   31 24                       55 41 1 8   0 0     0   5   31 24                 55
1806068 1806068 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_2 48 1 7   0 4     0   7   33 34                       67 48 1 7   0 4     0   7   33 34                 67
1806069 1806069 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_3 61 2 8   0 3     0   9   35 48                       83 61 2 8   0 3     0   9   35 48                 83
1806070 1806070 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_4 60 2 7   0 0     0   3   33 39                       72 60 2 7   0 0     0   3   33 39                 72
1806071 1806071 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_5 52 1 10   0 2     0   10   38 37                       75 52 1 10   0 2     0   10   38 37                 75
1806072 1806072 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 39 1 18   1 1     0   3   29 34                       63 39 1 18   1 1     0   3   29 34                 63
1806073 1806073 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 301 8 58   1 10     0   37   199 216                       415 301 8 58   1 10     0   37   199 216                 415
1806074 1806074 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_1 45 3 7   1 11     1   9   36 41                       77 45 3 7   1 11     1   9   36 41                 77
1806075 1806075 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_2 54 1 12   1 11     2   10   48 43                       91 54 1 12   1 11     2   10   48 43                 91
1806076 1806076 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_3 59 5 14   0 13     0   10   47 54                       101 59 5 14   0 13     0   10   47 54                 101
1806077 1806077 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_4 51 2 10   0 13     0   7   37 46                       83 51 2 10   0 13     0   7   37 46                 83
1806078 1806078 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   grade_5 63 2 9   0 13     2   10   48 51                       99 63 2 9   0 13     2   10   48 51                 99
1806079 1806079 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 42 4 8   1 6     0   8   34 35                       69 42 4 8   1 6     0   8   34 35                 69
1806080 1806080 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1806081 1806081 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 315 17 60   3 67     5   54   250 271                       521 315 17 60   3 67     5   54   250 271                 521
1806082 1806082 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2020   grade_6 139 3 24   2 14     1   18   108 93                       201 139 3 24   2 14     1   18   108 93                 201
1806083 1806083 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2020   grade_7 176 6 35   0 19     1   23   131 129                       260 176 6 35   0 19     1   23   131 129                 260
1806084 1806084 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2020   grade_8 186 9 25   1 22     0   16   139 120                       259 186 9 25   1 22     0   16   139 120                 259
1806085 1806085 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2020   pk_12_total 501 18 84   3 55     2   57   378 342                       720 501 18 84   3 55     2   57   378 342                 720
1806086 1806086 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   grade_10 242 10 47   1 15     0   32   179 168                       347 242 10 47   1 15     0   32   179 168                 347
1806087 1806087 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   grade_11 253 10 47   0 8     1   22   171 170                       341 253 10 47   0 8     1   22   171 170                 341
1806088 1806088 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   grade_12 247 11 47   2 15     0   27   176 173                       349 247 11 47   2 15     0   27   176 173                 349
1806089 1806089 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   grade_9 263 15 49   1 18     0   20   189 177                       366 263 15 49   1 18     0   20   189 177                 366
1806090 1806090 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   pk_12_total 1005 46 190   4 56     1   101   715 688                       1403 1005 46 190   4 56     1   101   715 688                 1403
1806091 1806091 CO     school 801920 1040   Academy 20 80192006434 110 Village High School   Regular School No High 09 12 2020   grade_10 48 1 2   0 1     0   3   32 23                       55 48 1 2   0 1     0   3   32 23                 55
1806092 1806092 CO     school 801920 1040   Academy 20 80192006434 110 Village High School   Regular School No High 09 12 2020   grade_11 48 2 6   0 0     0   2   25 33                       58 48 2 6   0 0     0   2   25 33                 58
1806093 1806093 CO     school 801920 1040   Academy 20 80192006434 110 Village High School   Regular School No High 09 12 2020   grade_12 41 1 6   0 0     0   2   25 25                       50 41 1 6   0 0     0   2   25 25                 50
1806094 1806094 CO     school 801920 1040   Academy 20 80192006434 110 Village High School   Regular School No High 09 12 2020   grade_9 42 0 8   0 1     0   0   31 20                       51 42 0 8   0 1     0   0   31 20                 51
1806095 1806095 CO     school 801920 1040   Academy 20 80192006434 110 Village High School   Regular School No High 09 12 2020   pk_12_total 179 4 22   0 2     0   7   113 101                       214 179 4 22   0 2     0   7   113 101                 214
1806096 1806096 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   grade_10 23 1 6   0 1     0   2   19 14                       33 23 1 6   0 1     0   2   19 14                 33
1806097 1806097 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   grade_11 16 1 7   1 1     0   0   17 9                       26 16 1 7   1 1     0   0   17 9                 26
1806098 1806098 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   grade_12 21 3 4   1 0     0   0   13 16                       29 21 3 4   1 0     0   0   13 16                 29
1806099 1806099 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   grade_7 13 0 1   0 0     0   1   10 5                       15 13 0 1   0 0     0   1   10 5                 15
1806100 1806100 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   grade_8 23 0 4   0 0     0   0   15 12                       27 23 0 4   0 0     0   0   15 12                 27
1806101 1806101 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   grade_9 18 1 8   0 0     0   2   23 6                       29 18 1 8   0 0     0   2   23 6                 29
1806102 1806102 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   pk_12_total 114 6 30   2 2     0   5   97 62                       159 114 6 30   2 2     0   5   97 62                 159
1806103 1806103 CO     school 801920 1040   Academy 20 80192000123 249 Antelope Trails Elementary School   Regular School No Elementary PK 05 2020   grade_1 37 0 6   1 2     0   1   21 26                       47 37 0 6   1 2     0   1   21 26                 47
1806104 1806104 CO     school 801920 1040   Academy 20 80192000123 249 Antelope Trails Elementary School   Regular School No Elementary PK 05 2020   grade_2 50 1 8   0 0     0   6   35 30                       65 50 1 8   0 0     0   6   35 30                 65
1806105 1806105 CO     school 801920 1040   Academy 20 80192000123 249 Antelope Trails Elementary School   Regular School No Elementary PK 05 2020   grade_3 38 3 3   1 4     0   2   26 25                       51 38 3 3   1 4     0   2   26 25                 51
1806106 1806106 CO     school 801920 1040   Academy 20 80192000123 249 Antelope Trails Elementary School   Regular School No Elementary PK 05 2020   grade_4 43 3 4   0 2     0   4   27 29                       56 43 3 4   0 2     0   4   27 29                 56
1806107 1806107 CO     school 801920 1040   Academy 20 80192000123 249 Antelope Trails Elementary School   Regular School No Elementary PK 05 2020   grade_5 41 2 6   1 2     0   4   33 23                       56 41 2 6   1 2     0   4   33 23                 56
1806108 1806108 CO     school 801920 1040   Academy 20 80192000123 249 Antelope Trails Elementary School   Regular School No Elementary PK 05 2020   kindergarten_full_day 31 2 4   0 0     0   1   19 19                       38 31 2 4   0 0     0   1   19 19                 38
1806109 1806109 CO     school 801920 1040   Academy 20 80192000123 249 Antelope Trails Elementary School   Regular School No Elementary PK 05 2020   pk_12_total 255 11 36   3 14     0   18   177 160                       337 255 11 36   3 14     0   18   177 160                 337
1806110 1806110 CO     school 801920 1040   Academy 20 80192000123 249 Antelope Trails Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten 15 0 5   0 4     0   0   16 8                       24 15 0 5   0 4     0   0   16 8                 24
1806111 1806111 CO     school 801920 1040   Academy 20 80192006619 1033 Briargate Preschool   Regular School No Prekindergarten PK PK 2020   pk_12_total 73 2 21   1 9     1   9   57 59                       116 73 2 21   1 9     1   9   57 59                 116
1806112 1806112 CO     school 801920 1040   Academy 20 80192006619 1033 Briargate Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 73 2 21   1 9     1   9   57 59                       116 73 2 21   1 9     1   9   57 59                 116
1806113 1806113 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2020   grade_6 199 7 35   1 28     0   26   150 146                       296 199 7 35   1 28     0   26   150 146                 296
1806114 1806114 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2020   grade_7 80 4 16   0 4     0   13   56 61                       117 80 4 16   0 4     0   13   56 61                 117
1806115 1806115 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2020   grade_8 72 3 16   1 8     0   14   56 58                       114 72 3 16   1 8     0   14   56 58                 114
1806116 1806116 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2020   pk_12_total 351 14 67   2 40     0   53   262 265                       527 351 14 67   2 40     0   53   262 265                 527
1806117 1806117 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_1 53 1 6   0 0     0   1   34 27                       61 53 1 6   0 0     0   1   34 27                 61
1806118 1806118 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_10 2 0 1   0 0     0   1   2 2                       4 2 0 1   0 0     0   1   2 2                 4
1806119 1806119 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_11 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1806120 1806120 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_12 4 0 2   0 0     0   1   5 2                       7 4 0 2   0 0     0   1   5 2                 7
1806121 1806121 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_2 41 0 7   0 0     0   4   28 24                       52 41 0 7   0 0     0   4   28 24                 52
1806122 1806122 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_3 61 0 9   2 1     0   6   37 42                       79 61 0 9   2 1     0   6   37 42                 79
1806123 1806123 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_4 45 0 11   0 1     0   1   27 31                       58 45 0 11   0 1     0   1   27 31                 58
1806124 1806124 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_5 55 0 8   1 1     0   5   33 37                       70 55 0 8   1 1     0   5   33 37                 70
1806125 1806125 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_6 43 2 7   0 0     0   4   28 28                       56 43 2 7   0 0     0   4   28 28                 56
1806126 1806126 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_7 27 0 3   0 2     0   2   16 18                       34 27 0 3   0 2     0   2   16 18                 34
1806127 1806127 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_8 34 0 2   0 1     0   0   18 19                       37 34 0 2   0 1     0   0   18 19                 37
1806128 1806128 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_9 10 0 2   0 0     0   1   5 8                       13 10 0 2   0 0     0   1   5 8                 13
1806129 1806129 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   kindergarten_full_day 47 1 6   0 1     0   3   31 27                       58 47 1 6   0 1     0   3   31 27                 58
1806130 1806130 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   pk_12_total 424 4 64   3 7     0   29   265 266                       531 424 4 64   3 7     0   29   265 266                 531
1806131 1806131 CO     school 801920 1040   Academy 20 80192006329 1615 Chinook Trail Elementary School   Regular School No Elementary KG 05 2020   grade_1 77 3 7   0 6     1   4   49 49                       98 77 3 7   0 6     1   4   49 49                 98
1806132 1806132 CO     school 801920 1040   Academy 20 80192006329 1615 Chinook Trail Elementary School   Regular School No Elementary KG 05 2020   grade_2 84 1 11   0 3     0   5   46 58                       104 84 1 11   0 3     0   5   46 58                 104
1806133 1806133 CO     school 801920 1040   Academy 20 80192006329 1615 Chinook Trail Elementary School   Regular School No Elementary KG 05 2020   grade_3 69 2 10   0 8     0   11   52 48                       100 69 2 10   0 8     0   11   52 48                 100
1806134 1806134 CO     school 801920 1040   Academy 20 80192006329 1615 Chinook Trail Elementary School   Regular School No Elementary KG 05 2020   grade_4 86 2 10   0 8     0   9   53 62                       115 86 2 10   0 8     0   9   53 62                 115
1806135 1806135 CO     school 801920 1040   Academy 20 80192006329 1615 Chinook Trail Elementary School   Regular School No Elementary KG 05 2020   grade_5 72 5 17   0 10     0   12   51 65                       116 72 5 17   0 10     0   12   51 65                 116
1806136 1806136 CO     school 801920 1040   Academy 20 80192006329 1615 Chinook Trail Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day 66 2 12   2 3     0   9   37 57                       94 66 2 12   2 3     0   9   37 57                 94
1806137 1806137 CO     school 801920 1040   Academy 20 80192006329 1615 Chinook Trail Elementary School   Regular School No Elementary KG 05 2020   kindergarten_half_day 6 0 0   0 1     0   0   3 4                       7 6 0 0   0 1     0   0   3 4                 7
1806138 1806138 CO     school 801920 1040   Academy 20 80192006329 1615 Chinook Trail Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 460 15 67   2 39     1   50   291 343                       634 460 15 67   2 39     1   50   291 343                 634
1806139 1806139 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2020   grade_1 255 1 30   1 19     0   25   173 158                       331 255 1 30   1 19     0   25   173 158                 331
1806140 1806140 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2020   grade_2 268 5 26   2 8     1   12   178 144                       322 268 5 26   2 8     1   12   178 144                 322
1806141 1806141 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2020   grade_3 257 5 22   2 10     0   16   149 163                       312 257 5 22   2 10     0   16   149 163                 312
1806142 1806142 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2020   grade_4 249 4 33   1 6     0   14   145 162                       307 249 4 33   1 6     0   14   145 162                 307
1806143 1806143 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2020   grade_5 241 4 25   1 8     0   14   144 149                       293 241 4 25   1 8     0   14   144 149                 293
1806144 1806144 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2020   grade_6 207 8 29   0 8     1   17   131 139                       270 207 8 29   0 8     1   17   131 139                 270
1806145 1806145 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2020   kindergarten_half_day 277 3 32   0 20     0   29   204 157                       361 277 3 32   0 20     0   29   204 157                 361
1806146 1806146 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2020   pk_12_total 1754 30 197   7 79     2   127   1124 1072                       2196 1754 30 197   7 79     2   127   1124 1072                 2196
1806147 1806147 CO     school 801920 1040   Academy 20 80192001931 1629 The Classical Academy Middle School   Regular School Yes Middle 07 08 2020   grade_7 193 3 22   2 10     1   6   132 105                       237 193 3 22   2 10     1   6   132 105                 237
1806148 1806148 CO     school 801920 1040   Academy 20 80192001931 1629 The Classical Academy Middle School   Regular School Yes Middle 07 08 2020   grade_8 167 4 17   0 5     0   3   91 105                       196 167 4 17   0 5     0   3   91 105                 196
1806149 1806149 CO     school 801920 1040   Academy 20 80192001931 1629 The Classical Academy Middle School   Regular School Yes Middle 07 08 2020   pk_12_total 360 7 39   2 15     1   9   223 210                       433 360 7 39   2 15     1   9   223 210                 433
1806150 1806150 CO     school 801920 1040   Academy 20 80192001943 1630 The Classical Academy High School   Regular School Yes High 09 12 2020   grade_10 123 1 13   0 5     2   5   72 77                       149 123 1 13   0 5     2   5   72 77                 149
1806151 1806151 CO     school 801920 1040   Academy 20 80192001943 1630 The Classical Academy High School   Regular School Yes High 09 12 2020   grade_11 119 1 11   0 5     1   7   69 75                       144 119 1 11   0 5     1   7   69 75                 144
1806152 1806152 CO     school 801920 1040   Academy 20 80192001943 1630 The Classical Academy High School   Regular School Yes High 09 12 2020   grade_12 112 2 13   0 3     0   5   78 57                       135 112 2 13   0 3     0   5   78 57                 135
1806153 1806153 CO     school 801920 1040   Academy 20 80192001943 1630 The Classical Academy High School   Regular School Yes High 09 12 2020   grade_9 142 4 9   1 6     0   6   87 81                       168 142 4 9   1 6     0   6   87 81                 168
1806154 1806154 CO     school 801920 1040   Academy 20 80192001943 1630 The Classical Academy High School   Regular School Yes High 09 12 2020   pk_12_total 496 8 46   1 19     3   23   306 290                       596 496 8 46   1 19     3   23   306 290                 596
1806155 1806155 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_1 3 0 1   0 0     0   0   1 3                       4 3 0 1   0 0     0   0   1 3                 4
1806156 1806156 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_2 3 0 4   0 0     0   0   3 4                       7 3 0 4   0 0     0   0   3 4                 7
1806157 1806157 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_3 5 0 2   0 0     0   0   2 5                       7 5 0 2   0 0     0   0   2 5                 7
1806158 1806158 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_4 7 0 3   0 0     0   1   6 5                       11 7 0 3   0 0     0   1   6 5                 11
1806159 1806159 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_5 6 1 3   0 0     0   1   3 8                       11 6 1 3   0 0     0   1   3 8                 11
1806160 1806160 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_6 18 0 5   0 0     0   3   13 13                       26 18 0 5   0 0     0   3   13 13                 26
1806161 1806161 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_7 20 1 5   0 2     0   2   9 21                       30 20 1 5   0 2     0   2   9 21                 30
1806162 1806162 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_8 28 1 6   0 2     0   0   18 19                       37 28 1 6   0 2     0   0   18 19                 37
1806163 1806163 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   kindergarten_full_day 2 0 2   0 0     0   0   1 3                       4 2 0 2   0 0     0   0   1 3                 4
1806164 1806164 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   pk_12_total 92 3 31   0 4     0   7   56 81                       137 92 3 31   0 4     0   7   56 81                 137
1806165 1806165 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2020   grade_6 175 12 32   0 13     0   17   122 127                       249 175 12 32   0 13     0   17   122 127                 249
1806166 1806166 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2020   grade_7 186 8 30   0 12     0   26   134 128                       262 186 8 30   0 12     0   26   134 128                 262

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