Data source: Big Local News · About: Big Local

626 rows where grade = "grade_7", state = "CO" and year = 2020 sorted by ccd_school_lvl

View and edit SQL

year

  • 2020 · 626

grade

  • grade_7 · 626
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
1801022 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2020   grade_7 0 0 2   0 1     0   0   2 1                       3 0 0 2   0 1     0   0   2 1                 3
1808698 CO     school   1550   Poudre R-1   0 Not a school             2020   grade_7 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
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
1799336 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_7 4 0 35   0 1     0   1   22 19                       41 4 0 35   0 1     0   1   22 19                 41
1799346 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_7 9 0 46   0 2     0   0   36 21                       57 9 0 46   0 2     0   0   36 21                 57
1799380 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_7 5 0 51   1 1     0   3   31 30                       61 5 0 51   1 1     0   3   31 30                 61
1799409 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_7 9 0 47   0 2     0   0   31 27                       58 9 0 47   0 2     0   0   31 27                 58
1799452 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_7 2 0 58   0 0     0   1   27 34                       61 2 0 58   0 0     0   1   27 34                 61
1799623 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2020   grade_7 42 0 10   0 9     0   9   29 41                       70 42 0 10   0 9     0   9   29 41                 70
1799770 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2020   grade_7 46 0 24   0 2     0   1   43 30                       73 46 0 24   0 2     0   1   43 30                 73
1799781 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_7 20 1 106   1 2     0   2   76 56                       132 20 1 106   1 2     0   2   76 56                 132
1799798 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   grade_7 68 1 9   0 6     1   3   50 38                       88 68 1 9   0 6     1   3   50 38                 88
1799925 CO     school 802580 40   School District 27J 80258001948 700 Belle Creek Charter School   Regular School Yes Elementary KG 08 2020   grade_7 28 3 46   0 0     0   1   41 37                       78 28 3 46   0 0     0   1   41 37                 78
1799955 CO     school 802580 40   School District 27J 80258001729 1052 Bromley East Charter School   Regular School Yes Elementary PK 08 2020   grade_7 97 0 49   0 0     0   4   80 70                       150 97 0 49   0 0     0   4   80 70                 150
1799970 CO     school 802580 40   School District 27J 80258006465 2945 Foundations Academy   Regular School Yes Elementary KG 08 2020   grade_7 49 0 37   0 0     0   5   45 46                       91 49 0 37   0 0     0   5   45 46                 91
1799988 CO     school 802580 40   School District 27J 80258006325 4950 Landmark Academy at Reunion   Regular School Yes Elementary KG 08 2020   grade_7 56 5 24   0 2     0   1   46 42                       88 56 5 24   0 2     0   1   46 42                 88
1800191 CO     school 807230 70   Westminster Public Schools 80723006567 4334 Colorado STEM Academy   Regular School No Elementary PK 08 2020   grade_7 17 1 35   1 1     0   2   31 26                       57 17 1 35   1 1     0   2   31 26                 57
1800272 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2020   grade_7 2 0 17   0 2     0   0   12 9                       21 2 0 17   0 2     0   0   12 9                 21
1800488 CO     school 802910 130   Cherry Creek 5 80291000763 1510 Challenge School   Regular School No Elementary PK 08 2020   grade_7 20 11 9   0 18     0   6   28 36                       64 20 11 9   0 18     0   6   28 36                 64
1800516 CO     school 802910 130   Cherry Creek 5 80291001152 1571 Cherry Creek Charter Academy   Regular School Yes Elementary KG 08 2020   grade_7 39 10 4   0 22     0   3   35 43                       78 39 10 4   0 22     0   3   35 43                 78
1800646 CO     school 802910 130   Cherry Creek 5 80291006676 4189 Heritage Heights Academy   Regular School Yes Elementary KG 08 2020   grade_7 12 2 6   0 1     1   0   8 14                       22 12 2 6   0 1     1   0   8 14                 22
1800923 CO     school 805310 140   Littleton 6 80531001515 5229 Littleton Academy   Regular School Yes Elementary KG 08 2020   grade_7 36 3 5   0 3     0   2   21 28                       49 36 3 5   0 3     0   2   21 28                 49
1800933 CO     school 805310 140   Littleton 6 80531001626 5233 Littleton Prep Charter School   Regular School Yes Elementary PK 08 2020   grade_7 34 1 12   0 3     0   1   24 27                       51 34 1 12   0 3     0   1   24 27                 51
1801036 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2020   grade_7 6 12 59   1 0     1   6   36 49                       85 6 12 59   1 0     1   6   36 49                 85
1801050 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_7 9 14 22   0 1     1   6   31 22                       53 9 14 22   0 1     1   6   31 22                 53
1801077 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_7 13 22 20   0 3     0   0   30 28                       58 13 22 20   0 3     0   0   30 28                 58
1801091 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2020   grade_7 17 10 24   0 6     0   3   38 22                       60 17 10 24   0 6     0   3   38 22                 60
1801102 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2020   grade_7 3 3 36   0 2     0   1   23 22                       45 3 3 36   0 2     0   1   23 22                 45
1801126 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2020   grade_7 7 5 44   1 2     1   4   31 33                       64 7 5 44   1 2     1   4   31 33                 64
1801179 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2020   grade_7 14 18 69   3 4     2   4   58 56                       114 14 18 69   3 4     2   4   58 56                 114
1801205 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2020   grade_7 14 18 63   0 1     0   5   55 46                       101 14 18 63   0 1     0   5   55 46                 101
1801298 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2020   grade_7 35 13 35   0 5     0   9   42 55                       97 35 13 35   0 5     0   9   42 55                 97
1801351 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2020   grade_7 37 13 21   0 12     1   6   36 54                       90 37 13 21   0 12     1   6   36 54                 90
1801412 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 07 2020   grade_7 4 6 44   0 7     0   1   27 35                       62 4 6 44   0 7     0   1   27 35                 62
1801421 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2020   grade_7 5 4 35   0 0     0   3   25 22                       47 5 4 35   0 0     0   3   25 22                 47
1801447 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2020   grade_7 31 13 68   0 6     0   9   71 56                       127 31 13 68   0 6     0   9   71 56                 127
1801736 CO     school 805370 470   St Vrain Valley RE1J 80537006530 71 Aspen Ridge Preparatory School   Regular School Yes Elementary KG 08 2020   grade_7 25 0 3   0 1     0   3   15 17                       32 25 0 3   0 1     0   3   15 17                 32
1801796 CO     school 805370 470   St Vrain Valley RE1J 80537001887 1284 Carbon Valley Academy   Regular School Yes Elementary PK 08 2020   grade_7 2 1 9   0 0     0   0   2 10                       12 2 1 9   0 0     0   0   2 10                 12
1801856 CO     school 805370 470   St Vrain Valley RE1J 80537001890 2964 Flagstaff Charter Academy   Regular School Yes Elementary PK 08 2020   grade_7 74 1 11   0 12     0   5   53 50                       103 74 1 11   0 12     0   5   53 50                 103
1801868 CO     school 805370 470   St Vrain Valley RE1J 80537000901 3192 Thunder Valley PK-8   Regular School No Elementary PK 08 2020   grade_7 39 1 49   1 4     0   3   43 54                       97 39 1 49   1 4     0   3   43 54                 97
1801911 CO     school 805370 470   St Vrain Valley RE1J 80537006388 4333 Imagine Charter   Regular School Yes Elementary PK 08 2020   grade_7 33 1 17   0 2     0   0   27 26                       53 33 1 17   0 2     0   0   27 26                 53
1801985 CO     school 805370 470   St Vrain Valley RE1J 80537006594 6010 Timberline PK-8   Regular School No Elementary PK 08 2020   grade_7 9 1 109   3 1     1   1   58 67                       125 9 1 109   3 1     1   1   58 67                 125
1802045 CO     school 805370 470   St Vrain Valley RE1J 80537006430 7565 St. Vrain Community Montessori School   Regular School Yes Elementary PK 08 2020   grade_7 12 0 2   0 0     0   0   6 8                       14 12 0 2   0 0     0   0   6 8                 14
1802080 CO     school 805370 470   St Vrain Valley RE1J 80537006739 8055 Soaring Heights PK-8   Regular School No Elementary PK 08 2020   grade_7 124 4 25   0 7     0   2   86 76                       162 124 4 25   0 7     0   2   86 76                 162
1802118 CO     school 802490 480   Boulder Valley Re 2 80249001758 441 Aspen Creek K-8 School   Regular School No Elementary PK 08 2020   grade_7 103 3 18   1 9     0   4   85 53                       138 103 3 18   1 9     0   4   85 53                 138
1802241 CO     school 802490 480   Boulder Valley Re 2 80249001771 2589 Eldorado K-8 School   Regular School No Elementary PK 08 2020   grade_7 102 0 8   0 12     1   10   71 62                       133 102 0 8   0 12     1   10   71 62                 133
1802252 CO     school 802490 480   Boulder Valley Re 2 80249006716 2639 Meadowlark School   Regular School No Elementary PK 08 2020   grade_7 35 1 11   0 4     1   3   30 25                       55 35 1 11   0 4     1   3   30 25                 55
1802387 CO     school 802490 480   Boulder Valley Re 2 80249001573 6000 Monarch K-8 School   Regular School No Elementary PK 08 2020   grade_7 108 2 7   0 11     0   3   69 62                       131 108 2 7   0 11     0   3   69 62                 131
1802423 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2020   grade_7 34 0 4   0 1     0   2   21 20                       41 34 0 4   0 1     0   2   21 20                 41
1802806 CO     school 803330 870   Delta County 50(J) 80333000299 4124 Hotchkiss Elementary School   Regular School No Elementary PK 08 2020   grade_7 32 1 5   0 0     0   3   23 18                       41 32 1 5   0 0     0   3   23 18                 41
1802960 CO     school 803360 880   Denver County 1 80336000320 1106 Bryant Webster Dual Language ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 2 0 54   0 0     0   2   30 28                       58 2 0 54   0 0     0   2   30 28                 58
1803104 CO     school 803360 880   Denver County 1 80336006453 2125 Denver Green School Southeast   Regular School No Elementary PK 08 2020   grade_7 23 14 25   0 1     0   6   36 33                       69 23 14 25   0 1     0   6   36 33                 69
1803115 CO     school 803360 880   Denver County 1 80336006482 2127 Denver Language School   Regular School Yes Elementary KG 08 2020   grade_7 41 5 18   0 3     1   9   43 34                       77 41 5 18   0 3     1   9   43 34                 77
1803381 CO     school 803360 880   Denver County 1 80336001738 3605 Grant Ranch ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 14 4 29   0 5     0   2   24 30                       54 14 4 29   0 5     0   2   24 30                 54
1803404 CO     school 803360 880   Denver County 1 80336001739 3647 Marie L. Greenwood Academy   Regular School No Elementary KG 08 2020   grade_7 3 5 54   0 0     0   1   35 28                       63 3 5 54   0 0     0   1   35 28                 63
1803454 CO     school 803360 880   Denver County 1 80336001835 3987 Highline Academy Southeast   Regular School Yes Elementary KG 08 2020   grade_7 29 21 22   1 1     0   2   46 30                       76 29 21 22   1 1     0   2   46 30                 76
1803492 CO     school 803360 880   Denver County 1 80336001928 4140 Farrell B. Howell ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 2 13 65   1 1     2   0   35 49                       84 2 13 65   1 1     2   0   35 49                 84
1803690 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_7 0 6 51   0 0     3   2   30 32                       62 0 6 51   0 0     3   2   30 32                 62
1803742 CO     school 803360 880   Denver County 1 80336000385 6088 Dora Moore ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 5 0 9   0 1     0   0   11 4                       15 5 0 9   0 1     0   0   11 4                 15
1803813 CO     school 803360 880   Denver County 1 80336001636 6479 Odyssey School of Denver   Regular School Yes Elementary KG 08 2020   grade_7 14 5 5   0 0     1   2   14 13                       27 14 5 5   0 0     1   2   14 13                 27
1803823 CO     school 803360 880   Denver County 1 80336001838 6508 Omar D Blair Charter School   Regular School Yes Elementary KG 08 2020   grade_7 6 28 34   1 7     1   3   37 43                       80 6 28 34   1 7     1   3   37 43                 80
1803861 CO     school 803360 880   Denver County 1 80336001933 6970 Florida Pitt-Waller ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 3 32 50   0 5     4   5   44 55                       99 3 32 50   0 5     4   5   44 55                 99
1803872 CO     school 803360 880   Denver County 1 80336006398 7045 Place Bridge Academy   Regular School No Elementary PK 08 2020   grade_7 7 29 43   0 19     0   1   60 39                       99 7 29 43   0 19     0   1   60 39                 99
1803969 CO     school 803360 880   Denver County 1 80336001524 7972 Slavens K-8 School   Regular School No Elementary KG 08 2020   grade_7 71 0 7   0 1     0   5   39 45                       84 71 0 7   0 1     0   5   39 45                 84
1804178 CO     school 803360 880   Denver County 1 80336000426 9548 Whittier ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 0 8 18   0 0     0   3   12 17                       29 0 8 18   0 0     0   3   12 17                 29
1804189 CO     school 803360 880   Denver County 1 80336006332 9623 William (Bill) Roberts ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 44 7 13   0 0     0   4   40 28                       68 44 7 13   0 0     0   4   40 28                 68
1804252 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_7 64 1 10   2 3     0   3   48 35                       83 64 1 10   2 3     0   3   48 35                 83
1804285 CO     school 803450 900   Douglas County Re 1 80345006492 135 Ben Franklin Academy   Regular School Yes Elementary PK 08 2020   grade_7 74 2 14   0 8     0   6   56 48                       104 74 2 14   0 8     0   6   56 48                 104
1804300 CO     school 803450 900   Douglas County Re 1 80345001896 215 American Academy   Regular School Yes Elementary PK 08 2020   grade_7 181 5 20   0 37     0   13   119 137                       256 181 5 20   0 37     0   13   119 137                 256
1804386 CO     school 803450 900   Douglas County Re 1 80345001874 1512 Challenge to Excellence Charter School   Regular School Yes Elementary KG 08 2020   grade_7 34 0 4   1 7     0   3   29 20                       49 34 0 4   1 7     0   3   29 20                 49
1804419 CO     school 803450 900   Douglas County Re 1 80345002011 1579 North Star Academy   Regular School Yes Elementary KG 08 2020   grade_7 48 1 8   0 4     0   3   35 29                       64 48 1 8   0 4     0   3   35 29                 64
1804430 CO     school 803450 900   Douglas County Re 1 80345000812 1873 Parker Core Knowledge Charter School   Regular School Yes Elementary KG 08 2020   grade_7 55 0 9   0 11     0   3   39 39                       78 55 0 9   0 11     0   3   39 39                 78
1804649 CO     school 803450 900   Douglas County Re 1 80345006765 5225 Leman Classical Academy   Regular School Yes Elementary KG 08 2020   grade_7 47 0 7   1 2     0   1   32 26                       58 47 0 7   1 2     0   1   32 26                 58
1804707 CO     school 803450 900   Douglas County Re 1 80345001581 5997 DC Montessori Charter School   Regular School Yes Elementary PK 08 2020   grade_7 28 0 4   0 1     0   1   14 20                       34 28 0 4   0 1     0   1   14 20                 34
1804718 CO     school 803450 900   Douglas County Re 1 80345006588 6019 Aspen View Academy   Regular School Yes Elementary PK 08 2020   grade_7 64 0 8   0 1     0   3   34 42                       76 64 0 8   0 1     0   3   34 42                 76
1804768 CO     school 803450 900   Douglas County Re 1 80345006690 6719 Parker Performing Arts   Regular School Yes Elementary KG 08 2020   grade_7 49 3 14   0 4     0   10   28 52                       80 49 3 14   0 4     0   10   28 52                 80
1804814 CO     school 803450 900   Douglas County Re 1 80345001584 7047 Platte River Charter Academy   Regular School Yes Elementary KG 08 2020   grade_7 60 1 9   0 2     0   2   40 34                       74 60 1 9   0 2     0   2   40 34                 74
1804960 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_7 36 0 9   0 2     0   3   20 30                       50 36 0 9   0 2     0   3   20 30                 50
1805023 CO     school 803540 910   Eagle County RE 50 80354000851 2340 Eagle County Charter Academy   Regular School Yes Elementary KG 08 2020   grade_7 38 0 2   0 0     0   1   21 20                       41 38 0 2   0 0     0   1   21 20                 41
1805077 CO     school 803540 910   Eagle County RE 50 80354001478 5742 Homestake Peak School   Regular School No Elementary PK 08 2020   grade_7 34 1 85   2 2     0   0   53 71                       124 34 1 85   2 2     0   0   53 71                 124
1805115 CO     school 803720 920   Elizabeth School District 80372001586 2572 Legacy Academy   Regular School Yes Elementary KG 08 2020   grade_7 34 0 4   0 0     0   1   11 28                       39 34 0 4   0 0     0   1   11 28                 39
1805323 CO     school 804530 980   Harrison 2 80453001903 6162 Mountain Vista Community School   Regular School No Elementary PK 08 2020   grade_7 24 10 49   0 5     0   4   47 45                       92 24 10 49   0 5     0   4   47 45                 92
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
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
1805608 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2020   grade_7 29 0 2   1 0     0   0   23 9                       32 29 0 2   1 0     0   0   23 9                 32
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
1806258 CO     school 801920 1040   Academy 20 80192006745 6242 New Summit Charter Academy   Regular School Yes Elementary KG 08 2020   grade_7 31 3 6   0 0     1   0   19 22                       41 31 3 6   0 0     1   0   19 22                 41
1806430 CO     school 805820 1080   Lewis-Palmer 38 80582001536 5093 Monument Charter Academy   Regular School Yes Elementary PK 08 2020   grade_7 90 3 12   1 2     0   5   57 56                       113 90 3 12   1 2     0   5   57 56                 113
1806581 CO     school 803870 1110   District 49 80387006386 4251 Grand Peak Academy   Regular School Yes Elementary KG 08 2020   grade_7 39 1 11   0 1     1   9   25 37                       62 39 1 11   0 1     1   9   25 37                 62
1806644 CO     school 803870 1110   District 49 80387001844 6935 Pikes Peak School Expeditionary Learning   Regular School Yes Elementary KG 08 2020   grade_7 32 0 9   1 2     0   2   30 16                       46 32 0 9   1 2     0   2   30 16                 46
1806670 CO     school 803870 1110   District 49 80387002000 7463 Rocky Mountain Classical Academy   Regular School Yes Elementary KG 08 2020   grade_7 71 1 20   1 3     0   18   53 61                       114 71 1 20   1 3     0   18   53 61                 114
1806767 CO     school 802790 1140   Canon City RE-1 80279000173 3802 Harrison School   Regular School No Elementary KG 08 2020   grade_7 85 0 21   2 0     0   6   58 56                       114 85 0 21   2 0     0   6   58 56                 114
1806791 CO     school 802790 1140   Canon City RE-1 80279001538 6752 Mount View Core Knowledge Charter School   Regular School Yes Elementary PK 08 2020   grade_7 22 0 3   0 0     0   1   8 18                       26 22 0 3   0 0     0   1   8 18                 26
1806801 CO     school 802790 1140   Canon City RE-1 80279001433 7950 Canon Exploratory School   Regular School No Elementary KG 08 2020   grade_7 23 0 3   0 0     0   0   15 11                       26 23 0 3   0 0     0   0   15 11                 26
1806859 CO     school 804260 1180   Roaring Fork RE-1 80426001505 429 Carbondale Community Charter School   Regular School Yes Elementary KG 08 2020   grade_7 10 0 4   0 0     0   0   6 8                       14 10 0 4   0 0     0   0   6 8                 14
1806920 CO     school 804260 1180   Roaring Fork RE-1 80426006715 7298 Riverview School   Regular School No Elementary PK 08 2020   grade_7 18 1 22   0 0     0   0   25 16                       41 18 1 22   0 0     0   0   25 16                 41
1807053 CO     school 805070 1340   West Grand 1-JT 80507000829 9422 West Grand Elementary and Middle School   Regular School No Elementary KG 08 2020   grade_7 32 0 11   0 0     0   1   23 21                       44 32 0 11   0 0     0   1   23 21                 44
1807146 CO     school 807080 1390   Huerfano Re-1 80708001845 63 Peakview School   Regular School No Elementary PK 08 2020   grade_7 8 1 14   2 0     0   0   17 8                       25 8 1 14   2 0     0   0   17 8                 25
1807157 CO     school 807080 1390   Huerfano Re-1 80708001211 3306 Gardner Elementary School   Regular School No Elementary PK 08 2020   grade_7 2 1 7   0 0     0   0   3 7                       10 2 1 7   0 0     0   0   3 7                 10
1807227 CO     school 804800 1420   Jefferson County R-1 80480006489 109 Arvada K-8   Regular School No Elementary KG 08 2020   grade_7 42 7 84   0 1     1   4   78 61                       139 42 7 84   0 1     1   4   78 61                 139

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