Data source: Big Local News · About: Big Local

1,102 rows where grade = "grade_1", state = "CO" and year = 2020 sorted by white

View and edit SQL

year

  • 2020 · 1,102

grade

  • grade_1 · 1,102
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
1802677 CO     school 806360 640   Centennial R-1 80636001416 1398 Centennial School   Regular School No Other PK 12 2020   grade_1 0 0 12   0 0     0   0   4 8                       12 0 0 12   0 0     0   0   4 8                 12
1803676 CO     school 803360 880   Denver County 1 80336001635 5644 Maxwell Elementary School   Regular School No Elementary PK 05 2020   grade_1 0 21 93   1 1     0   0   60 56                       116 0 21 93   1 1     0   0   60 56                 116
1805062 CO     school 803540 910   Eagle County RE 50 80354006366 4838 June Creek Elementary School   Regular School No Elementary PK 05 2020   grade_1 0 0 34   0 0     0   0   18 16                       34 0 0 34   0 0     0   0   18 16                 34
1799903 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2020   grade_1 1 1 37   0 0     0   0   23 16                       39 1 1 37   0 0     0   0   23 16                 39
1801337 CO     school 802340 180   Adams-Arapahoe 28J 80234001927 6869 Peoria Elementary School   Regular School No Elementary PK 05 2020   grade_1 1 7 36   0 2     0   1   20 27                       47 1 7 36   0 2     0   1   20 27                 47
1802910 CO     school 803360 880   Denver County 1 80336000311 520 Barnum Elementary School   Regular School No Elementary PK 05 2020   grade_1 1 2 44   1 0     0   0   19 29                       48 1 2 44   1 0     0   0   19 29                 48
1802918 CO     school 803360 880   Denver County 1 80336000313 650 Beach Court Elementary School   Regular School No Elementary PK 05 2020   grade_1 1 1 39   1 0     0   0   21 21                       42 1 1 39   1 0     0   0   21 21                 42
1803004 CO     school 803360 880   Denver County 1 80336000325 1528 Cheltenham Elementary School   Regular School No Elementary PK 05 2020   grade_1 1 6 33   1 1     2   1   24 21                       45 1 6 33   1 1     2   1   24 21                 45
1803258 CO     school 803360 880   Denver County 1 80336000337 2364 Eagleton Elementary School   Regular School No Elementary PK 05 2020   grade_1 1 3 30   2 0     0   2   18 20                       38 1 3 30   2 0     0   2   18 20                 38
1803486 CO     school 803360 880   Denver County 1 80336001928 4140 Farrell B. Howell ECE-8 School   Regular School No Elementary PK 08 2020   grade_1 1 6 42   2 0     2   0   29 24                       53 1 6 42   2 0     2   0   29 24                 53
1803581 CO     school 803360 880   Denver County 1 80336000371 4762 Knapp Elementary School   Regular School No Elementary PK 05 2020   grade_1 1 5 62   0 0     0   0   37 31                       68 1 5 62   0 0     0   0   37 31                 68
1803589 CO     school 803360 880   Denver County 1 80336000372 4782 Hallett Academy   Regular School No Elementary PK 05 2020   grade_1 1 37 6   0 0     0   4   26 22                       48 1 37 6   0 0     0   4   26 22                 48
1803611 CO     school 803360 880   Denver County 1 80336006748 4850 KIPP Sunshine Peak Elementary   Regular School Yes Elementary PK 01 2020   grade_1 1 0 23   0 0     0   0   11 13                       24 1 0 23   0 0     0   0   11 13                 24
1803662 CO     school 803360 880   Denver County 1 80336006445 5608 Mathematics and Science Leadership Academy   Regular School No Elementary KG 05 2020   grade_1 1 3 27   0 0     0   1   10 22                       32 1 3 27   0 0     0   1   10 22                 32
1803751 CO     school 803360 880   Denver County 1 80336000387 6188 Munroe Elementary School   Regular School No Elementary PK 05 2020   grade_1 1 2 57   0 0     1   2   23 40                       63 1 2 57   0 0     1   2   23 40                 63
1803916 CO     school 803360 880   Denver County 1 80336006646 7471 Rocky Mountain Prep: Southwest   Regular School Yes Elementary PK 05 2020   grade_1 1 4 68   0 1     0   2   40 36                       76 1 4 68   0 1     0   2   40 36                 76
1804002 CO     school 803360 880   Denver County 1 80336006525 8131 Oakland Elementary   Regular School No Elementary PK 05 2020   grade_1 1 7 22   0 2     0   0   16 16                       32 1 7 22   0 2     0   0   16 16                 32
1804137 CO     school 803360 880   Denver County 1 80336000421 9050 Valverde Elementary School   Regular School No Elementary PK 05 2020   grade_1 1 0 34   0 0     0   0   12 23                       35 1 0 34   0 0     0   0   12 23                 35
1808151 CO     school 804800 1420   Jefferson County R-1 80480006307 8036 Sobesky Academy   Special Education School No Other KG 12 2020   grade_1 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1808503 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2020   grade_1 1 0 2   0 1     0   0   3 1                       4 1 0 2   0 1     0   0   3 1                 4
1809431 CO     school 802520 1750   Branson Reorganized 82 80252000141 978 Branson School   Regular School No Other PK 12 2020   grade_1 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1809490 CO     school 804890 1810   Karval RE-23 80489000814 4502 Karval Elementary School   Regular School No Elementary PK 06 2020   grade_1 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1809749 CO     school 804350 2000   Mesa County Valley 51 80435000611 3350 Gateway School   Regular School No Other PK 12 2020   grade_1 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1810454 CO     school 803840 2610   Park County RE-2 80384001695 3681 Guffey Charter School   Regular School Yes Elementary PK 08 2020   grade_1 1 1 0   0 0     0   0   2 0                       2 1 1 0   0 0     0   0   2 0                 2
1812486 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2020   grade_1 1 1 22   0 0     0   0   12 12                       24 1 1 22   0 0     0   0   12 12                 24
1799340 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_1 10 0 37   0 4     0   1   29 23                       52 10 0 37   0 4     0   1   29 23                 52
1799403 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_1 10 1 24   0 2     0   1   23 15                       38 10 1 24   0 2     0   1   23 15                 38
1799861 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2020   grade_1 10 0 54   0 0     0   0   37 27                       64 10 0 54   0 0     0   0   37 27                 64
1800000 CO     school 802580 40   School District 27J 80258000148 6294 North Elementary School   Regular School No Elementary PK 05 2020   grade_1 10 0 28   0 0     0   0   19 19                       38 10 0 28   0 0     0   0   19 19                 38
1800266 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2020   grade_1 10 1 23   1 0     0   0   17 18                       35 10 1 23   1 0     0   0   17 18                 35
1800337 CO     school 803780 120   Englewood 1 80378000488 1556 Cherrelyn Elementary School   Regular School No Elementary KG 06 2020   grade_1 10 0 18   0 0     0   4   14 18                       32 10 0 18   0 0     0   4   14 18                 32
1801063 CO     school 802340 180   Adams-Arapahoe 28J 80234001296 310 Arkansas Elementary School   Regular School No Elementary PK 05 2020   grade_1 10 12 22   0 2     2   7   30 25                       55 10 12 22   0 2     2   7   30 25                 55
1801071 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_1 10 40 17   0 3     1   4   44 31                       75 10 40 17   0 3     1   4   44 31                 75
1801199 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2020   grade_1 10 25 58   0 7     1   11   56 56                       112 10 25 58   0 7     1   11   56 56                 112
1801224 CO     school 802340 180   Adams-Arapahoe 28J 80234000066 4426 Jewell Elementary School   Regular School No Elementary PK 05 2020   grade_1 10 13 32   0 4     1   5   35 30                       65 10 13 32   0 4     1   5   35 30                 65
1802581 CO     school 803000 540   Clear Creek RE-1 80300001999 3385 Georgetown Community School   Regular School Yes Elementary PK 06 2020   grade_1 10 0 0   0 0     0   0   8 2                       10 10 0 0   0 0     0   0   8 2                 10
1802983 CO     school 803360 880   Denver County 1 80336006449 1345 Rocky Mountain Prep: Berkeley   Regular School Yes Elementary PK 05 2020   grade_1 10 6 29   1 0     0   0   23 23                       46 10 6 29   1 0     0   0   23 23                 46
1803139 CO     school 803360 880   Denver County 1 80336001522 2174 Denison Montessori School   Regular School No Elementary PK 06 2020   grade_1 10 0 31   1 5     0   0   22 25                       47 10 0 31   1 5     0   0   22 25                 47
1803550 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2020   grade_1 10 26 49   0 4     2   6   45 52                       97 10 26 49   0 4     2   6   45 52                 97
1804099 CO     school 803360 880   Denver County 1 80336000418 8888 Traylor Academy   Regular School No Elementary PK 05 2020   grade_1 10 2 46   1 3     0   2   34 30                       64 10 2 46   1 3     0   2   34 30                 64
1805044 CO     school 803540 910   Eagle County RE 50 80354006221 2530 Edwards Elementary School   Regular School No Elementary PK 05 2020   grade_1 10 0 29   0 0     0   2   21 20                       41 10 0 29   0 0     0   2   21 20                 41
1805345 CO     school 804530 980   Harrison 2 80453000670 6936 Pikes Peak Elementary School   Regular School No Elementary PK 05 2020   grade_1 10 6 35   1 0     0   7   32 27                       59 10 6 35   1 0     0   7   32 27                 59
1805880 CO     school 803060 1010   Colorado Springs 11 80306000262 7482 Roosevelt Charter Academy   Regular School Yes Elementary KG 05 2020   grade_1 10 10 70   1 0     0   5   55 41                       96 10 10 70   1 0     0   5   55 41                 96
1810036 CO     school 803090 2035   Montezuma-Cortez RE-1 80309000838 5436 Manaugh Elementary School   Regular School No Elementary KG 05 2020   grade_1 10 0 8   23 0     0   2   17 26                       43 10 0 8   23 0     0   2   17 26                 43
1810276 CO     school 807140 2505   Weldon Valley RE-20(J) 80714001217 9352 Weldon Valley Elementary School   Regular School No Elementary PK 06 2020   grade_1 10 0 2   0 0     0   0   6 6                       12 10 0 2   0 0     0   0   6 6                 12
1810615 CO     school 807320 2680   Wiley RE-13 Jt 80732001260 9604 Wiley Elementary School   Regular School No Elementary PK 05 2020   grade_1 10 0 7   0 0     0   1   10 8                       18 10 0 7   0 0     0   1   10 8                 18
1810650 CO     school 806120 2690   Pueblo City 60 80612001031 822 Bessemer Elementary School   Regular School No Elementary PK 05 2020   grade_1 10 1 35   1 1     0   1   23 26                       49 10 1 35   1 1     0   1   23 26                 49
1812082 CO     school 802550 3146   Briggsdale RE-10 80255000142 1008 Briggsdale Elementary School   Regular School No Elementary PK 05 2020   grade_1 10 0 1   0 2     0   0   6 7                       13 10 0 1   0 2     0   0   6 7                 13
1812279 CO     school 800020 8001   Charter School Institute 80002006779 1387 Colorado Early Colleges Windsor   Regular School Yes Other KG 12 2020   grade_1 10 0 1   0 0     0   2   5 8                       13 10 0 1   0 0     0   2   5 8                 13
1808353 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_1 100 2 14   0 2     0   3   72 49                       121 100 2 14   0 2     0   3   72 49                 121
1811718 CO     school 807350 3100   Windsor RE-4 80735001815 9665 Windsor Charter Academy Elementary School   Regular School Yes Elementary KG 05 2020   grade_1 101 2 14   0 0     0   3   53 67                       120 101 2 14   0 0     0   3   53 67                 120
1811825 CO     school 804410 3120   Greeley 6 80441001614 1875 Frontier Charter Academy   Regular School Yes Other KG 12 2020   grade_1 102 1 30   1 1     1   3   73 66                       139 102 1 30   1 1     1   3   73 66                 139
1809506 CO     school 806690 1828   Valley RE-1 80669006339 515 Ayres Elementary School   Regular School No Elementary KG 02 2020   grade_1 106 2 41   1 0     0   3   73 80                       153 106 2 41   1 0     0   3   73 80                 153
1801699 CO     school 805580 310   McClave Re-2 80558000962 5666 McClave Elementary School   Regular School No Elementary PK 06 2020   grade_1 11 0 0   0 0     0   0   3 8                       11 11 0 0   0 0     0   0   3 8                 11
1801979 CO     school 805370 470   St Vrain Valley RE1J 80537006594 6010 Timberline PK-8   Regular School No Elementary PK 08 2020   grade_1 11 0 63   0 0     0   0   37 37                       74 11 0 63   0 0     0   0   37 37                 74
1803891 CO     school 803360 880   Denver County 1 80336006545 7241 Rocky Mountain Prep: Creekside   Regular School Yes Elementary PK 05 2020   grade_1 11 39 31   0 8     0   3   52 40                       92 11 39 31   0 8     0   3   52 40                 92
1806733 CO     school 805670 1130   Miami/Yoder 60 JT 80567000971 5850 Miami/Yoder Elementary School   Regular School No Elementary PK 05 2020   grade_1 11 0 5   0 0     0   1   9 8                       17 11 0 5   0 0     0   1   9 8                 17
1807737 CO     school 804800 1420   Jefferson County R-1 80480000748 5004 Lasley Elementary School   Regular School No Elementary KG 06 2020   grade_1 11 0 39   1 3     0   1   35 20                       55 11 0 39   1 3     0   1   35 20                 55
1809947 CO     school 803150 2010   Creede School District 80315000279 1966 Creede School   Regular School No Other PK 12 2020   grade_1 11 0 1   0 0     0   0   6 6                       12 11 0 1   0 0     0   0   6 6                 12
1810190 CO     school 805850 2190   West End RE-2 80585001398 6196 Naturita Elementary School   Regular School No Elementary PK 06 2020   grade_1 11 0 1   0 0     0   0   2 10                       12 11 0 1   0 0     0   0   2 10                 12
1810464 CO     school 803840 2610   Park County RE-2 80384000501 4908 Lake George Charter School   Regular School Yes Elementary PK 08 2020   grade_1 11 0 3   0 0     0   4   8 10                       18 11 0 3   0 0     0   4   8 10                 18
1810600 CO     school 804680 2670   Holly RE-3 80468000681 4058 Holly School   Regular School No Other PK 12 2020   grade_1 11 0 9   0 0     0   0   9 11                       20 11 0 9   0 0     0   0   9 11                 20
1810666 CO     school 806120 2690   Pueblo City 60 80612001033 954 Bradford Elementary School   Regular School No Elementary PK 05 2020   grade_1 11 1 43   0 0     0   0   32 23                       55 11 1 43   0 0     0   0   32 23                 55
1810845 CO     school 806120 2690   Pueblo City 60 80612001063 8116 South Park Elementary School   Regular School No Elementary PK 05 2020   grade_1 11 0 37   0 0     0   2   22 28                       50 11 0 37   0 0     0   2   22 28                 50
1811209 CO     school 806300 2790   Mountain Valley RE 1 80630001415 6146 Mountain Valley School   Regular School No Other PK 12 2020   grade_1 11 1 1   1 0     0   1   5 10                       15 11 1 1   1 0     0   1   5 10                 15
1811512 CO     school 805940 3050   Otis R-3 80594001016 6582 Otis Elementary School   Regular School No Elementary PK 05 2020   grade_1 11 1 2   0 0     0   0   7 7                       14 11 1 2   0 0     0   0   7 7                 14
1804643 CO     school 803450 900   Douglas County Re 1 80345006765 5225 Leman Classical Academy   Regular School Yes Elementary KG 08 2020   grade_1 111 0 9   1 3     0   7   68 63                       131 111 0 9   1 3     0   7   68 63                 131
1811703 CO     school 807350 3100   Windsor RE-4 80735001263 8886 Tozer Elementary School   Regular School No Elementary PK 02 2020   grade_1 113 1 38   1 3     0   2   69 89                       158 113 1 38   1 3     0   2   69 89                 158
1799641 CO     school 806900 20   Adams 12 Five Star Schools 80690001306 5058 Leroy Drive Elementary School   Regular School No Elementary KG 05 2020   grade_1 12 3 43   1 0     0   4   30 33                       63 12 3 43   1 0     0   4   30 33                 63
1799775 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_1 12 0 52   0 1     0   2   39 28                       67 12 0 52   0 1     0   2   39 28                 67
1799803 CO     school 806900 20   Adams 12 Five Star Schools 80690001191 8842 Thornton Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 1 44   1 1     0   1   31 29                       60 12 1 44   1 1     0   1   31 29                 60
1801465 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_1 12 37 18   0 3     0   4   41 33                       74 12 37 18   0 3     0   4   41 33                 74
1801495 CO     school 802340 180   Adams-Arapahoe 28J 80234000085 9756 Yale Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 12 27   1 4     0   10   35 31                       66 12 12 27   1 4     0   10   35 31                 66
1802629 CO     school 805100 550   North Conejos RE-1J 80510000845 5422 Manassa Elementary School   Regular School No Elementary KG 05 2020   grade_1 12 0 15   0 0     0   0   17 10                       27 12 0 15   0 0     0   0   17 10                 27
1803728 CO     school 803360 880   Denver County 1 80336000384 6002 Montclair School of Academics and Enrichment   Regular School No Elementary PK 05 2020   grade_1 12 34 15   0 4     0   1   43 23                       66 12 34 15   0 4     0   1   43 23                 66
1804973 CO     school 803540 910   Eagle County RE 50 80354001721 37 Red Hill Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 0 28   0 0     0   1   23 18                       41 12 0 28   0 0     0   1   23 18                 41
1805168 CO     school 806600 940   Big Sandy 100J 80660001138 7914 Simla Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 0 2   0 0     0   0   4 10                       14 12 0 2   0 0     0   0   4 10                 14
1806837 CO     school 803120 1160   Cotopaxi RE-3 80312000276 3220 Cotopaxi Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 0 2   0 0     0   0   7 7                       14 12 0 2   0 0     0   0   7 7                 14
1808423 CO     school 803510 1430   Eads RE-1 80351000458 2328 Eads Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 0 0   0 0     0   0   10 2                       12 12 0 0   0 0     0   0   10 2                 12
1808456 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2020   grade_1 12 0 0   0 0     0   0   8 4                       12 12 0 0   0 0     0   0   8 4                 12
1809387 CO     school 804650 1600   Hoehne Reorganized 3 80465000680 4048 Hoehne Schools   Regular School No Other PK 12 2020   grade_1 12 0 17   0 0     0   0   19 10                       29 12 0 17   0 0     0   0   19 10                 29
1809572 CO     school 806030 1870   Plateau RE-5 80603001022 6834 Peetz Elementary School   Regular School No Elementary PK 06 2020   grade_1 12 0 0   1 0     0   0   6 7                       13 12 0 0   1 0     0   0   6 7                 13
1810235 CO     school 804050 2405   Fort Morgan Re-3 80405006698 1009 Baker Elementary School   Regular School No Elementary 01 05 2020   grade_1 12 3 32   0 0     0   0   24 23                       47 12 3 32   0 0     0   0   24 23                 47
1810267 CO     school 804050 2405   Fort Morgan Re-3 80405006298 6954 Pioneer Elementary School   Regular School No Elementary 01 05 2020   grade_1 12 5 35   0 0     0   0   26 26                       52 12 5 35   0 0     0   0   26 26                 52
1810529 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2020   grade_1 12 0 1   0 2     0   0   8 7                       15 12 0 1   0 2     0   0   8 7                 15
1810749 CO     school 806120 2690   Pueblo City 60 80612001047 3724 Haaff Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 2 33   0 0     0   1   19 29                       48 12 2 33   0 0     0   1   19 29                 48
1810788 CO     school 806120 2690   Pueblo City 60 80612001057 5916 Minnequa Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 1 36   1 0     0   2   25 27                       52 12 1 36   1 0     0   2   25 27                 52
1811070 CO     school 803300 2730   Upper Rio Grande School District C-7 80330000289 2148 Del Norte Elementary School   Regular School No Elementary KG 06 2020   grade_1 12 0 12   0 0     0   0   14 10                       24 12 0 12   0 0     0   0   14 10                 24
1811314 CO     school 805880 2840   Norwood R-2J 80588001012 6422 Norwood Public Schools   Regular School No Other PK 12 2020   grade_1 12 0 0   0 0     0   1   6 7                       13 12 0 0   0 0     0   1   6 7                 13
1811614 CO     school 803600 3085   Eaton RE-2 80360000477 3286 Galeton Elementary School   Regular School No Elementary KG 05 2020   grade_1 12 0 8   0 0     0   1   8 13                       21 12 0 8   0 0     0   1   8 13                 21
1812057 CO     school 804020 3140   Weld Re-8 Schools 80402001366 8930 Twombly Elementary School   Regular School No Elementary PK 05 2020   grade_1 12 0 57   0 0     0   0   36 33                       69 12 0 57   0 0     0   0   36 33                 69
1799974 CO     school 802580 40   School District 27J 80258000146 3900 Henderson Elementary School   Regular School No Elementary PK 05 2020   grade_1 13 0 31   0 0     1   1   30 16                       46 13 0 31   0 0     1   1   30 16                 46
1800067 CO     school 802580 40   School District 27J 80258000150 8060 South Elementary School   Regular School No Elementary PK 05 2020   grade_1 13 0 48   0 0     0   3   28 36                       64 13 0 48   0 0     0   3   28 36                 64
1800209 CO     school 807230 70   Westminster Public Schools 80723001242 5834 Mesa Elementary School   Regular School No Elementary PK 05 2020   grade_1 13 0 34   2 2     0   0   27 24                       51 13 0 34   2 2     0   0   27 24                 51
1800221 CO     school 807230 70   Westminster Public Schools 80723001363 7810 John E. Flynn A Marzano Academy   Regular School No Elementary PK 06 2020   grade_1 13 1 25   0 6     0   1   28 18                       46 13 1 25   0 6     0   1   28 18                 46
1800308 CO     school 806420 110   Sangre De Cristo Re-22J 80642001115 7626 Sangre de Cristo Elementary School   Regular School No Elementary PK 05 2020   grade_1 13 0 6   0 0     0   1   12 8                       20 13 0 6   0 0     0   1   12 8                 20
1802457 CO     school 802490 480   Boulder Valley Re 2 80249001403 7592 Alicia Sanchez International School   Regular School No Elementary PK 05 2020   grade_1 13 0 26   0 2     0   1   24 18                       42 13 0 26   0 2     0   1   24 18                 42
1802750 CO     school 803330 870   Delta County 50(J) 80333000295 1952 North Fork Montessori @ Crawford   Regular School No Elementary PK 06 2020   grade_1 13 0 2   0 0     0   1   11 5                       16 13 0 2   0 0     0   1   11 5                 16
1803119 CO     school 803360 880   Denver County 1 80336006574 2129 Denver Center for International Studies at Fairmont   Regular School No Elementary PK 05 2020   grade_1 13 1 27   2 1     1   3   28 20                       48 13 1 27   2 1     1   3   28 20                 48
1803390 CO     school 803360 880   Denver County 1 80336001776 3641 Green Valley Elementary School   Regular School No Elementary PK 05 2020   grade_1 13 22 43   1 9     1   3   56 36                       92 13 22 43   1 9     1   3   56 36                 92

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