Data source: Big Local News · About: Big Local

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

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
1738276 CO     school 805550 10   Mapleton 1 80555001860 263 Global Leadership Academy   Regular School No High 09 12 2021   grade_12 0 1 35   0 0     0   1   13 24                       37 0 1 35   0 0     0   1   13 24                 37
1738333 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Pk-8   Regular School No Elementary PK 08 2021   grade_7 0 0 12   2 1     0   0   7 8                       15 0 0 12   2 1     0   0   7 8                 15
1738427 CO     school 806900 20   Adams 12 Five Star Schools 80690001172 210 Vantage Point   Alternative School No High 06 12 2021   grade_9 0 0 1   0 0     1   0   1 1                       2 0 0 1   0 0     1   0   1 1                 2
1738790 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_10 0 0 12   0 0     0   0   6 6                       12 0 0 12   0 0     0   0   6 6                 12
1738793 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1739140 CO     school 807230 70   Westminster Public Schools 80723001241 5388 Colorado Sports Leadership Academy   Regular School No Elementary KG 08 2021   grade_4 0 0 33   0 0     0   0   17 16                       33 0 0 33   0 0     0   0   17 16                 33
1739208 CO     school 807230 70   Westminster Public Schools 80723001249 8798 Tennyson Knolls Preparatory School   Regular School No Elementary PK 08 2021   pre_kindergarten 0 0 12   0 0     0   0   2 10                       12 0 0 12   0 0     0   0   2 10                 12
1739969 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_11 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
1739971 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_3 0 0 3   0 0     0   0   2 1                       3 0 0 3   0 0     0   0   2 1                 3
1739972 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_4 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
1739974 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_7 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1739975 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_8 0 1 3   0 0     0   0   2 2                       4 0 1 3   0 0     0   0   2 2                 4
1740009 CO     school 802340 180   Adams-Arapahoe 28J 80234000052 214 Altura Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 0 5 57   0 2     0   1   29 36                       65 0 5 57   0 2     0   1   29 36                 65
1740055 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2021   pre_kindergarten 0 4 17   0 4     0   0   12 13                       25 0 4 17   0 4     0   0   12 13                 25
1740127 CO     school 802340 180   Adams-Arapahoe 28J 80234000061 2618 Elkhart Elementary School   Regular School No Elementary PK 05 2021   grade_5 0 10 72   0 3     0   6   46 45                       91 0 10 72   0 3     0   6   46 45                 91
1740197 CO     school 802340 180   Adams-Arapahoe 28J 80234000067 4646 Kenton Elementary School   Regular School No Elementary PK 05 2021   grade_5 0 5 70   0 3     0   3   46 35                       81 0 5 70   0 3     0   3   46 35                 81
1740216 CO     school 802340 180   Adams-Arapahoe 28J 80234000069 4973 Laredo Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 0 1 9   0 1     0   1   7 5                       12 0 1 9   0 1     0   1   7 5                 12
1740235 CO     school 802340 180   Adams-Arapahoe 28J 80234000070 5361 Lyn Knoll Elementary School   Regular School No Elementary PK 05 2021   grade_5 0 12 23   0 0     0   2   22 15                       37 0 12 23   0 0     0   2   22 15                 37
1740248 CO     school 802340 180   Adams-Arapahoe 28J 80234000072 6068 Montview Math & Health Sciences Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 0 2 16   1 1     0   1   14 7                       21 0 2 16   1 1     0   1   14 7                 21
1740285 CO     school 802340 180   Adams-Arapahoe 28J 80234000075 6728 Paris Elementary School   Regular School No Elementary PK 05 2021   grade_4 0 6 31   1 1     0   1   19 21                       40 0 6 31   1 1     0   1   19 21                 40
1740289 CO     school 802340 180   Adams-Arapahoe 28J 80234000075 6728 Paris Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 0 4 14   0 2     0   0   13 7                       20 0 4 14   0 2     0   0   13 7                 20
1740290 CO     school 802340 180   Adams-Arapahoe 28J 80234000076 6758 Park Lane Elementary School   Regular School No Elementary PK 05 2021   grade_1 0 3 26   1 3     2   5   19 21                       40 0 3 26   1 3     2   5   19 21                 40
1740295 CO     school 802340 180   Adams-Arapahoe 28J 80234000076 6758 Park Lane Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 0 5 27   0 3     2   1   18 20                       38 0 5 27   0 3     2   1   18 20                 38
1740301 CO     school 802340 180   Adams-Arapahoe 28J 80234001927 6869 Peoria Elementary School   Regular School No Elementary PK 05 2021   grade_4 0 5 51   0 4     2   2   37 27                       64 0 5 51   0 4     2   2   37 27                 64
1740305 CO     school 802340 180   Adams-Arapahoe 28J 80234001927 6869 Peoria Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 0 1 21   0 3     0   2   13 14                       27 0 1 21   0 3     0   2   13 14                 27
1740352 CO     school 802340 180   Adams-Arapahoe 28J 80234000078 7932 Sixth Avenue Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 0 7 18   0 0     0   1   16 10                       26 0 7 18   0 0     0   1   16 10                 26
1740372 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 08 2021   grade_5 0 1 22   0 7     0   1   12 19                       31 0 1 22   0 7     0   1   12 19                 31
1740373 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 08 2021   grade_6 0 5 27   0 5     1   0   20 18                       38 0 5 27   0 5     1   0   20 18                 38
1740573 CO     school 806090 240   Pritchett RE-3 80609001026 7174 Pritchett Elementary School   Regular School No Elementary PK 05 2021   grade_4 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1740784 CO     school 805370 470   St Vrain Valley RE1J 80537001373 1844 Columbine Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 0 0 18   0 0     0   0   9 9                       18 0 0 18   0 0     0   0   9 9                 18
1741608 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_10 0 0 4   1 0     0   0   2 3                       5 0 0 4   1 0     0   0   2 3                 5
1741612 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_5 0 0 0   1 0     0   0   1 0                       1 0 0 0   1 0     0   0   1 0                 1
1741613 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_6 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1741615 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_8 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
1741634 CO     school 802130 580   South Conejos RE-10 80213000033 248 Guadalupe Elementary School   Regular School No Elementary PK 06 2021   grade_1 0 0 10   0 0     0   0   6 4                       10 0 0 10   0 0     0   0   6 4                 10
1741639 CO     school 802130 580   South Conejos RE-10 80213000033 248 Guadalupe Elementary School   Regular School No Elementary PK 06 2021   grade_6 0 0 9   0 0     0   0   6 3                       9 0 0 9   0 0     0   0   6 3                 9
1741642 CO     school 802130 580   South Conejos RE-10 80213000033 248 Guadalupe Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten 0 0 11   0 0     0   0   4 7                       11 0 0 11   0 0     0   0   4 7                 11
1741644 CO     school 802130 580   South Conejos RE-10 80213001464 250 Antonito Middle School   Regular School No Middle 07 08 2021   grade_8 0 0 8   0 0     0   0   5 3                       8 0 0 8   0 0     0   0   5 3                 8
1741647 CO     school 802130 580   South Conejos RE-10 80213000035 252 Antonito High School   Regular School No High 09 12 2021   grade_11 0 0 13   0 0     0   0   4 9                       13 0 0 13   0 0     0   0   4 9                 13
1741648 CO     school 802130 580   South Conejos RE-10 80213000035 252 Antonito High School   Regular School No High 09 12 2021   grade_12 0 0 9   0 0     0   0   6 3                       9 0 0 9   0 0     0   0   6 3                 9
1741653 CO     school 806360 640   Centennial R-1 80636001416 1398 Centennial School   Regular School No Other PK 12 2021   grade_11 0 1 8   0 0     0   0   5 4                       9 0 1 8   0 0     0   0   5 4                 9
1741657 CO     school 806360 640   Centennial R-1 80636001416 1398 Centennial School   Regular School No Other PK 12 2021   grade_4 0 1 14   0 0     0   0   11 4                       15 0 1 14   0 0     0   0   11 4                 15
1741851 CO     school 803360 880   Denver County 1 80336000306 220 John H. Amesse Elementary   Regular School No Elementary PK 05 2021   grade_1 0 8 40   0 1     0   1   27 23                       50 0 8 40   0 1     0   1   27 23                 50
1741852 CO     school 803360 880   Denver County 1 80336000306 220 John H. Amesse Elementary   Regular School No Elementary PK 05 2021   grade_2 0 9 47   0 0     0   0   34 22                       56 0 9 47   0 0     0   0   34 22                 56
1741853 CO     school 803360 880   Denver County 1 80336000306 220 John H. Amesse Elementary   Regular School No Elementary PK 05 2021   grade_3 0 10 44   0 0     0   0   31 23                       54 0 10 44   0 0     0   0   31 23                 54
1741854 CO     school 803360 880   Denver County 1 80336000306 220 John H. Amesse Elementary   Regular School No Elementary PK 05 2021   grade_4 0 8 51   0 0     0   0   28 31                       59 0 8 51   0 0     0   0   28 31                 59
1741856 CO     school 803360 880   Denver County 1 80336000306 220 John H. Amesse Elementary   Regular School No Elementary PK 05 2021   kindergarten_full_day 0 1 47   0 0     0   0   26 22                       48 0 1 47   0 0     0   0   26 22                 48
1741883 CO     school 803360 880   Denver County 1 80336000311 520 Barnum Elementary School   Regular School No Elementary PK 05 2021   grade_2 0 2 37   1 0     0   0   15 25                       40 0 2 37   1 0     0   0   15 25                 40
1741908 CO     school 803360 880   Denver County 1 80336006797 1010 American Indian Academy of Denver   Regular School Yes Middle 06 08 2021   grade_8 0 0 13   9 0     0   2   14 10                       24 0 0 13   9 0     0   2   14 10                 24
1741985 CO     school 803360 880   Denver County 1 80336000325 1528 Cheltenham Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 0 7 20   0 1     0   1   13 16                       29 0 7 20   0 1     0   1   13 16                 29
1742000 CO     school 803360 880   Denver County 1 80336001862 1748 Colorado High School Charter   Alternative School Yes High 09 12 2021   grade_12 0 4 24   0 0     1   0   16 13                       29 0 4 24   0 0     1   0   16 13                 29
1742164 CO     school 803360 880   Denver County 1 80336006516 2188 Denver Center for 21st-Century Learning at Wyman   Alternative School No High 06 12 2021   grade_6 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
1742165 CO     school 803360 880   Denver County 1 80336006516 2188 Denver Center for 21st-Century Learning at Wyman   Alternative School No High 06 12 2021   grade_7 0 2 6   0 0     0   0   5 3                       8 0 2 6   0 0     0   0   5 3                 8
1742192 CO     school 803360 880   Denver County 1 80336006528 2209 DCIS at Montbello   Regular School No High 06 12 2021   grade_11 0 3 126   0 1     0   0   70 60                       130 0 3 126   0 1     0   0   70 60                 130
1742193 CO     school 803360 880   Denver County 1 80336006528 2209 DCIS at Montbello   Regular School No High 06 12 2021   grade_12 0 6 103   0 6     1   3   49 70                       119 0 6 103   0 6     1   3   49 70                 119
1742231 CO     school 803360 880   Denver County 1 80336000336 2258 Doull Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 0 1 49   0 2     0   0   27 25                       52 0 1 49   0 2     0   0   27 25                 52
1742240 CO     school 803360 880   Denver County 1 80336000337 2364 Eagleton Elementary School   Regular School No Elementary PK 05 2021   grade_4 0 4 45   2 1     0   1   27 26                       53 0 4 45   2 1     0   1   27 26                 53
1742299 CO     school 803360 880   Denver County 1 80336001575 3000 Florence Crittenton High School   Alternative School No High 09 12 2021   grade_9 0 5 23   0 0     0   0   0 28                       28 0 5 23   0 0     0   0   0 28                 28
1742301 CO     school 803360 880   Denver County 1 80336000349 3032 Force Elementary School   Regular School No Elementary PK 05 2021   grade_1 0 1 50   2 2     1   0   29 27                       56 0 1 50   2 2     1   0   29 27                 56
1742311 CO     school 803360 880   Denver County 1 80336000351 3296 Garden Place Academy   Regular School No Elementary PK 06 2021   grade_3 0 1 41   1 0     0   1   25 19                       44 0 1 41   1 0     0   1   25 19                 44
1742314 CO     school 803360 880   Denver County 1 80336000351 3296 Garden Place Academy   Regular School No Elementary PK 06 2021   grade_6 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
1742342 CO     school 803360 880   Denver County 1 80336000355 3512 Goldrick Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 0 3 39   0 1     0   0   22 21                       43 0 3 39   0 1     0   0   22 21                 43
1742378 CO     school 803360 880   Denver County 1 80336001739 3647 Marie L. Greenwood Academy   Regular School No Elementary KG 08 2021   grade_2 0 4 44   1 0     0   0   28 21                       49 0 4 44   1 0     0   0   28 21                 49
1742381 CO     school 803360 880   Denver County 1 80336001739 3647 Marie L. Greenwood Academy   Regular School No Elementary KG 08 2021   grade_5 0 6 51   0 0     0   0   30 27                       57 0 6 51   0 0     0   0   30 27                 57
1742385 CO     school 803360 880   Denver County 1 80336001739 3647 Marie L. Greenwood Academy   Regular School No Elementary KG 08 2021   kindergarten_full_day 0 6 15   2 0     0   1   12 12                       24 0 6 15   2 0     0   1   12 12                 24
1742420 CO     school 803360 880   Denver County 1 80336000362 3778 International Academy of Denver at Harrington   Regular School No Elementary PK 05 2021   grade_2 0 6 17   1 0     0   0   10 14                       24 0 6 17   1 0     0   0   10 14                 24
1742422 CO     school 803360 880   Denver County 1 80336000362 3778 International Academy of Denver at Harrington   Regular School No Elementary PK 05 2021   grade_4 0 2 18   1 0     0   1   14 8                       22 0 2 18   1 0     0   1   14 8                 22
1742423 CO     school 803360 880   Denver County 1 80336000362 3778 International Academy of Denver at Harrington   Regular School No Elementary PK 05 2021   grade_5 0 6 11   0 0     0   1   9 9                       18 0 6 11   0 0     0   1   9 9                 18
1742426 CO     school 803360 880   Denver County 1 80336000362 3778 International Academy of Denver at Harrington   Regular School No Elementary PK 05 2021   pre_kindergarten 0 2 13   0 0     0   0   6 9                       15 0 2 13   0 0     0   0   6 9                 15
1742465 CO     school 803360 880   Denver County 1 80336001928 4140 Farrell B. Howell ECE-8 School   Regular School No Elementary PK 08 2021   grade_1 0 8 40   0 0     0   0   19 29                       48 0 8 40   0 0     0   0   19 29                 48
1742467 CO     school 803360 880   Denver County 1 80336001928 4140 Farrell B. Howell ECE-8 School   Regular School No Elementary PK 08 2021   grade_3 0 9 46   0 0     1   1   27 30                       57 0 9 46   0 0     1   1   27 30                 57
1742468 CO     school 803360 880   Denver County 1 80336001928 4140 Farrell B. Howell ECE-8 School   Regular School No Elementary PK 08 2021   grade_4 0 14 48   0 1     1   2   31 35                       66 0 14 48   0 1     1   2   31 35                 66
1742470 CO     school 803360 880   Denver County 1 80336001928 4140 Farrell B. Howell ECE-8 School   Regular School No Elementary PK 08 2021   grade_6 0 12 66   0 0     2   0   42 38                       80 0 12 66   0 0     2   0   42 38                 80
1742475 CO     school 803360 880   Denver County 1 80336001928 4140 Farrell B. Howell ECE-8 School   Regular School No Elementary PK 08 2021   pre_kindergarten 0 1 20   0 0     0   0   11 10                       21 0 1 20   0 0     0   0   11 10                 21
1742509 CO     school 803360 880   Denver County 1 80336000368 4450 Johnson Elementary School   Regular School No Elementary PK 05 2021   grade_1 0 1 39   0 1     0   0   17 24                       41 0 1 39   0 1     0   0   17 24                 41
1742516 CO     school 803360 880   Denver County 1 80336000368 4450 Johnson Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 0 0 17   0 0     0   0   7 10                       17 0 0 17   0 0     0   0   7 10                 17
1742553 CO     school 803360 880   Denver County 1 80336006448 4730 KIPP Denver Collegiate High School   Regular School Yes High 09 12 2021   grade_12 0 0 100   0 3     1   0   52 52                       104 0 0 100   0 3     1   0   52 52                 104
1742554 CO     school 803360 880   Denver County 1 80336006448 4730 KIPP Denver Collegiate High School   Regular School Yes High 09 12 2021   grade_9 0 2 133   1 0     0   0   64 72                       136 0 2 133   1 0     0   0   64 72                 136
1742562 CO     school 803360 880   Denver County 1 80336000371 4762 Knapp Elementary School   Regular School No Elementary PK 05 2021   grade_2 0 2 61   1 0     0   0   33 31                       64 0 2 61   1 0     0   0   33 31                 64
1742566 CO     school 803360 880   Denver County 1 80336000371 4762 Knapp Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 0 2 42   1 0     0   0   29 16                       45 0 2 42   1 0     0   0   29 16                 45
1742570 CO     school 803360 880   Denver County 1 80336000372 4782 Hallett Academy   Regular School No Elementary PK 05 2021   grade_2 0 37 4   0 0     0   4   23 22                       45 0 37 4   0 0     0   4   23 22                 45
1742596 CO     school 803360 880   Denver County 1 80336006669 5044 Legacy Options High School   Alternative School No High 09 12 2021   grade_10 0 12 26   0 0     0   1   24 15                       39 0 12 26   0 0     0   1   24 15                 39
1742645 CO     school 803360 880   Denver County 1 80336006445 5608 Mathematics and Science Leadership Academy   Regular School No Elementary KG 05 2021   grade_3 0 0 25   0 1     0   1   14 13                       27 0 0 25   0 1     0   1   14 13                 27
1742646 CO     school 803360 880   Denver County 1 80336006445 5608 Mathematics and Science Leadership Academy   Regular School No Elementary KG 05 2021   grade_4 0 3 30   0 0     0   0   15 18                       33 0 3 30   0 0     0   0   15 18                 33
1742647 CO     school 803360 880   Denver County 1 80336006445 5608 Mathematics and Science Leadership Academy   Regular School No Elementary KG 05 2021   grade_5 0 2 18   0 0     0   0   12 8                       20 0 2 18   0 0     0   0   12 8                 20
1742658 CO     school 803360 880   Denver County 1 80336001635 5644 Maxwell Elementary School   Regular School No Elementary PK 05 2021   grade_2 0 17 91   1 1     0   0   62 48                       110 0 17 91   1 1     0   0   62 48                 110
1742670 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2021   grade_6 0 5 59   0 0     4   0   39 29                       68 0 5 59   0 0     4   0   39 29                 68
1742672 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2021   grade_8 0 9 45   1 0     3   1   28 31                       59 0 9 45   1 0     3   1   28 31                 59
1742748 CO     school 803360 880   Denver County 1 80336000388 6254 Newlon Elementary School   Regular School No Elementary PK 05 2021   grade_1 0 0 49   0 2     0   2   31 22                       53 0 0 49   0 2     0   2   31 22                 53
1742755 CO     school 803360 880   Denver County 1 80336000388 6254 Newlon Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 0 1 15   0 0     0   0   6 10                       16 0 1 15   0 0     0   0   6 10                 16
1742757 CO     school 803360 880   Denver County 1 80336006569 6308 North High School Engagement Center   Alternative School No High 09 12 2021   grade_11 0 0 34   0 0     0   0   20 14                       34 0 0 34   0 0     0   0   20 14                 34
1742758 CO     school 803360 880   Denver County 1 80336006569 6308 North High School Engagement Center   Alternative School No High 09 12 2021   grade_12 0 1 20   0 0     0   1   15 7                       22 0 1 20   0 0     0   1   15 7                 22
1742768 CO     school 803360 880   Denver County 1 80336001869 6350 Bruce Randolph School   Regular School No High 06 12 2021   grade_12 0 4 81   0 0     0   2   40 47                       87 0 4 81   0 0     0   2   40 47                 87
1742771 CO     school 803360 880   Denver County 1 80336001869 6350 Bruce Randolph School   Regular School No High 06 12 2021   grade_8 0 15 93   1 1     0   2   52 60                       112 0 15 93   1 1     0   2   52 60                 112
1742859 CO     school 803360 880   Denver County 1 80336001795 7163 Prep Academy   Alternative School No High 06 12 2021   grade_11 0 4 4   0 0     0   1   4 5                       9 0 4 4   0 0     0   1   4 5                 9
1742861 CO     school 803360 880   Denver County 1 80336001795 7163 Prep Academy   Alternative School No High 06 12 2021   grade_6 0 1 1   0 0     0   0   2 0                       2 0 1 1   0 0     0   0   2 0                 2
1742862 CO     school 803360 880   Denver County 1 80336001795 7163 Prep Academy   Alternative School No High 06 12 2021   grade_7 0 0 3   0 0     0   0   2 1                       3 0 0 3   0 0     0   0   2 1                 3
1742863 CO     school 803360 880   Denver County 1 80336001795 7163 Prep Academy   Alternative School No High 06 12 2021   grade_8 0 3 3   0 0     0   1   5 2                       7 0 3 3   0 0     0   1   5 2                 7
1742864 CO     school 803360 880   Denver County 1 80336001795 7163 Prep Academy   Alternative School No High 06 12 2021   grade_9 0 9 11   0 0     0   1   17 4                       21 0 9 11   0 0     0   1   17 4                 21
1742866 CO     school 803360 880   Denver County 1 80336006591 7188 Montbello Career and Technical High School   Alternative School No High 09 12 2021   grade_10 0 1 4   0 0     1   1   4 3                       7 0 1 4   0 0     1   1   4 3                 7

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