Data source: Big Local News · About: Big Local

620 rows where grade = "grade_8", state = "CO" and year = 2020 sorted by ccd_school_lvl

View and edit SQL

year

  • 2020 · 620

grade

  • grade_8 · 620
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
1801023 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2020   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1808699 CO     school   1550   Poudre R-1   0 Not a school             2020   grade_8 0 0 0   0 0     0   1   0 1                       1 0 0 0   0 0     0   1   0 1                 1
1812624 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_8 3 1 7   0 0     0   0   9 2                       11 3 1 7   0 0     0   0   9 2                 11
1799337 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_8 3 0 49   0 2     0   0   24 30                       54 3 0 49   0 2     0   0   24 30                 54
1799347 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_8 6 1 41   0 0     0   0   27 21                       48 6 1 41   0 0     0   0   27 21                 48
1799381 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_8 4 4 44   0 2     0   1   24 31                       55 4 4 44   0 2     0   1   24 31                 55
1799410 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_8 6 2 39   0 6     0   2   28 27                       55 6 2 39   0 6     0   2   28 27                 55
1799453 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_8 10 1 44   0 0     0   1   29 27                       56 10 1 44   0 0     0   1   29 27                 56
1799624 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2020   grade_8 48 2 10   0 16     0   3   41 38                       79 48 2 10   0 16     0   3   41 38                 79
1799771 CO     school 806900 20   Adams 12 Five Star Schools 80690006468 8275 STEM Lab   Regular School No Elementary PK 08 2020   grade_8 40 0 8   0 3     0   3   29 25                       54 40 0 8   0 3     0   3   29 25                 54
1799782 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_8 27 0 97   1 2     0   0   75 52                       127 27 0 97   1 2     0   0   75 52                 127
1799799 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   grade_8 56 0 7   0 1     0   5   37 32                       69 56 0 7   0 1     0   5   37 32                 69
1799926 CO     school 802580 40   School District 27J 80258001948 700 Belle Creek Charter School   Regular School Yes Elementary KG 08 2020   grade_8 23 2 36   0 2     0   1   28 36                       64 23 2 36   0 2     0   1   28 36                 64
1799956 CO     school 802580 40   School District 27J 80258001729 1052 Bromley East Charter School   Regular School Yes Elementary PK 08 2020   grade_8 91 1 41   1 1     0   6   69 72                       141 91 1 41   1 1     0   6   69 72                 141
1799971 CO     school 802580 40   School District 27J 80258006465 2945 Foundations Academy   Regular School Yes Elementary KG 08 2020   grade_8 39 1 27   0 0     0   2   33 36                       69 39 1 27   0 0     0   2   33 36                 69
1799989 CO     school 802580 40   School District 27J 80258006325 4950 Landmark Academy at Reunion   Regular School Yes Elementary KG 08 2020   grade_8 48 5 24   0 1     0   0   43 35                       78 48 5 24   0 1     0   0   43 35                 78
1800192 CO     school 807230 70   Westminster Public Schools 80723006567 4334 Colorado STEM Academy   Regular School No Elementary PK 08 2020   grade_8 12 2 21   0 1     0   1   19 18                       37 12 2 21   0 1     0   1   19 18                 37
1800273 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2020   grade_8 3 0 13   0 0     0   0   5 11                       16 3 0 13   0 0     0   0   5 11                 16
1800489 CO     school 802910 130   Cherry Creek 5 80291000763 1510 Challenge School   Regular School No Elementary PK 08 2020   grade_8 35 15 7   0 10     0   6   36 37                       73 35 15 7   0 10     0   6   36 37                 73
1800517 CO     school 802910 130   Cherry Creek 5 80291001152 1571 Cherry Creek Charter Academy   Regular School Yes Elementary KG 08 2020   grade_8 29 5 1   0 14     0   1   29 21                       50 29 5 1   0 14     0   1   29 21                 50
1800647 CO     school 802910 130   Cherry Creek 5 80291006676 4189 Heritage Heights Academy   Regular School Yes Elementary KG 08 2020   grade_8 15 0 4   0 2     0   1   11 11                       22 15 0 4   0 2     0   1   11 11                 22
1800924 CO     school 805310 140   Littleton 6 80531001515 5229 Littleton Academy   Regular School Yes Elementary KG 08 2020   grade_8 36 3 3   0 8     0   2   28 24                       52 36 3 3   0 8     0   2   28 24                 52
1800934 CO     school 805310 140   Littleton 6 80531001626 5233 Littleton Prep Charter School   Regular School Yes Elementary PK 08 2020   grade_8 42 0 14   1 2     1   1   25 36                       61 42 0 14   1 2     1   1   25 36                 61
1801037 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2020   grade_8 6 8 45   0 0     0   5   38 26                       64 6 8 45   0 0     0   5   38 26                 64
1801051 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_8 11 13 21   1 2     0   3   23 28                       51 11 13 21   1 2     0   3   23 28                 51
1801078 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_8 9 13 15   0 1     0   1   18 21                       39 9 13 15   0 1     0   1   18 21                 39
1801092 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2020   grade_8 19 13 21   1 14     0   6   44 30                       74 19 13 21   1 14     0   6   44 30                 74
1801103 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2020   grade_8 2 3 36   0 2     0   0   26 17                       43 2 3 36   0 2     0   0   26 17                 43
1801127 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2020   grade_8 2 4 38   0 1     0   5   26 24                       50 2 4 38   0 1     0   5   26 24                 50
1801180 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2020   grade_8 13 10 50   1 1     3   6   40 44                       84 13 10 50   1 1     3   6   40 44                 84
1801206 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2020   grade_8 3 13 59   0 0     0   3   42 36                       78 3 13 59   0 0     0   3   42 36                 78
1801299 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2020   grade_8 21 13 33   1 1     0   4   43 30                       73 21 13 33   1 1     0   4   43 30                 73
1801352 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2020   grade_8 33 11 26   0 12     1   2   36 49                       85 33 11 26   0 12     1   2   36 49                 85
1801422 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2020   grade_8 2 6 24   0 0     0   4   23 13                       36 2 6 24   0 0     0   4   23 13                 36
1801448 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2020   grade_8 32 21 81   2 3     0   11   86 64                       150 32 21 81   2 3     0   11   86 64                 150
1801737 CO     school 805370 470   St Vrain Valley RE1J 80537006530 71 Aspen Ridge Preparatory School   Regular School Yes Elementary KG 08 2020   grade_8 31 0 4   0 1     0   1   19 18                       37 31 0 4   0 1     0   1   19 18                 37
1801797 CO     school 805370 470   St Vrain Valley RE1J 80537001887 1284 Carbon Valley Academy   Regular School Yes Elementary PK 08 2020   grade_8 5 1 9   0 0     1   0   8 8                       16 5 1 9   0 0     1   0   8 8                 16
1801857 CO     school 805370 470   St Vrain Valley RE1J 80537001890 2964 Flagstaff Charter Academy   Regular School Yes Elementary PK 08 2020   grade_8 85 1 12   0 5     0   4   58 49                       107 85 1 12   0 5     0   4   58 49                 107
1801869 CO     school 805370 470   St Vrain Valley RE1J 80537000901 3192 Thunder Valley PK-8   Regular School No Elementary PK 08 2020   grade_8 42 1 63   0 0     0   2   47 61                       108 42 1 63   0 0     0   2   47 61                 108
1801912 CO     school 805370 470   St Vrain Valley RE1J 80537006388 4333 Imagine Charter   Regular School Yes Elementary PK 08 2020   grade_8 29 1 10   0 0     0   0   17 23                       40 29 1 10   0 0     0   0   17 23                 40
1801986 CO     school 805370 470   St Vrain Valley RE1J 80537006594 6010 Timberline PK-8   Regular School No Elementary PK 08 2020   grade_8 14 2 114   1 3     1   2   77 60                       137 14 2 114   1 3     1   2   77 60                 137
1802046 CO     school 805370 470   St Vrain Valley RE1J 80537006430 7565 St. Vrain Community Montessori School   Regular School Yes Elementary PK 08 2020   grade_8 14 0 0   0 0     0   0   6 8                       14 14 0 0   0 0     0   0   6 8                 14
1802081 CO     school 805370 470   St Vrain Valley RE1J 80537006739 8055 Soaring Heights PK-8   Regular School No Elementary PK 08 2020   grade_8 85 2 19   0 2     1   1   60 50                       110 85 2 19   0 2     1   1   60 50                 110
1802119 CO     school 802490 480   Boulder Valley Re 2 80249001758 441 Aspen Creek K-8 School   Regular School No Elementary PK 08 2020   grade_8 104 1 21   0 12     0   4   76 66                       142 104 1 21   0 12     0   4   76 66                 142
1802242 CO     school 802490 480   Boulder Valley Re 2 80249001771 2589 Eldorado K-8 School   Regular School No Elementary PK 08 2020   grade_8 124 2 9   0 13     0   10   83 75                       158 124 2 9   0 13     0   10   83 75                 158
1802253 CO     school 802490 480   Boulder Valley Re 2 80249006716 2639 Meadowlark School   Regular School No Elementary PK 08 2020   grade_8 47 1 12   0 3     0   5   40 28                       68 47 1 12   0 3     0   5   40 28                 68
1802388 CO     school 802490 480   Boulder Valley Re 2 80249001573 6000 Monarch K-8 School   Regular School No Elementary PK 08 2020   grade_8 84 0 11   1 15     0   10   58 63                       121 84 0 11   1 15     0   10   58 63                 121
1802424 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2020   grade_8 37 0 1   0 2     0   1   18 23                       41 37 0 1   0 2     0   1   18 23                 41
1802807 CO     school 803330 870   Delta County 50(J) 80333000299 4124 Hotchkiss Elementary School   Regular School No Elementary PK 08 2020   grade_8 49 0 8   0 0     0   0   34 23                       57 49 0 8   0 0     0   0   34 23                 57
1802961 CO     school 803360 880   Denver County 1 80336000320 1106 Bryant Webster Dual Language ECE-8 School   Regular School No Elementary PK 08 2020   grade_8 0 0 52   1 0     0   0   28 25                       53 0 0 52   1 0     0   0   28 25                 53
1803105 CO     school 803360 880   Denver County 1 80336006453 2125 Denver Green School Southeast   Regular School No Elementary PK 08 2020   grade_8 22 12 19   0 1     0   3   31 26                       57 22 12 19   0 1     0   3   31 26                 57
1803116 CO     school 803360 880   Denver County 1 80336006482 2127 Denver Language School   Regular School Yes Elementary KG 08 2020   grade_8 32 3 20   0 4     0   7   22 44                       66 32 3 20   0 4     0   7   22 44                 66
1803382 CO     school 803360 880   Denver County 1 80336001738 3605 Grant Ranch ECE-8 School   Regular School No Elementary PK 08 2020   grade_8 10 1 26   0 5     0   0   23 19                       42 10 1 26   0 5     0   0   23 19                 42
1803405 CO     school 803360 880   Denver County 1 80336001739 3647 Marie L. Greenwood Academy   Regular School No Elementary KG 08 2020   grade_8 0 6 65   1 0     0   0   33 39                       72 0 6 65   1 0     0   0   33 39                 72
1803455 CO     school 803360 880   Denver County 1 80336001835 3987 Highline Academy Southeast   Regular School Yes Elementary KG 08 2020   grade_8 22 12 12   1 4     0   3   31 23                       54 22 12 12   1 4     0   3   31 23                 54
1803493 CO     school 803360 880   Denver County 1 80336001928 4140 Farrell B. Howell ECE-8 School   Regular School No Elementary PK 08 2020   grade_8 1 15 71   1 1     1   0   39 51                       90 1 15 71   1 1     1   0   39 51                 90
1803691 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_8 2 12 47   0 0     5   1   42 25                       67 2 12 47   0 0     5   1   42 25                 67
1803743 CO     school 803360 880   Denver County 1 80336000385 6088 Dora Moore ECE-8 School   Regular School No Elementary PK 08 2020   grade_8 4 8 13   0 0     0   2   11 16                       27 4 8 13   0 0     0   2   11 16                 27
1803814 CO     school 803360 880   Denver County 1 80336001636 6479 Odyssey School of Denver   Regular School Yes Elementary KG 08 2020   grade_8 7 7 6   0 1     0   2   7 16                       23 7 7 6   0 1     0   2   7 16                 23
1803824 CO     school 803360 880   Denver County 1 80336001838 6508 Omar D Blair Charter School   Regular School Yes Elementary KG 08 2020   grade_8 6 32 41   0 8     1   5   55 38                       93 6 32 41   0 8     1   5   55 38                 93
1803862 CO     school 803360 880   Denver County 1 80336001933 6970 Florida Pitt-Waller ECE-8 School   Regular School No Elementary PK 08 2020   grade_8 9 19 43   0 6     3   2   36 46                       82 9 19 43   0 6     3   2   36 46                 82
1803873 CO     school 803360 880   Denver County 1 80336006398 7045 Place Bridge Academy   Regular School No Elementary PK 08 2020   grade_8 9 34 42   0 16     0   2   55 48                       103 9 34 42   0 16     0   2   55 48                 103
1803970 CO     school 803360 880   Denver County 1 80336001524 7972 Slavens K-8 School   Regular School No Elementary KG 08 2020   grade_8 65 1 7   0 1     0   5   42 37                       79 65 1 7   0 1     0   5   42 37                 79
1804179 CO     school 803360 880   Denver County 1 80336000426 9548 Whittier ECE-8 School   Regular School No Elementary PK 08 2020   grade_8 1 7 6   3 0     0   1   8 10                       18 1 7 6   3 0     0   1   8 10                 18
1804190 CO     school 803360 880   Denver County 1 80336006332 9623 William (Bill) Roberts ECE-8 School   Regular School No Elementary PK 08 2020   grade_8 50 5 11   0 2     0   0   37 31                       68 50 5 11   0 2     0   0   37 31                 68
1804253 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_8 49 1 7   0 0     0   3   18 42                       60 49 1 7   0 0     0   3   18 42                 60
1804286 CO     school 803450 900   Douglas County Re 1 80345006492 135 Ben Franklin Academy   Regular School Yes Elementary PK 08 2020   grade_8 93 2 9   0 8     1   2   55 60                       115 93 2 9   0 8     1   2   55 60                 115
1804301 CO     school 803450 900   Douglas County Re 1 80345001896 215 American Academy   Regular School Yes Elementary PK 08 2020   grade_8 175 2 16   0 26     0   11   108 122                       230 175 2 16   0 26     0   11   108 122                 230
1804387 CO     school 803450 900   Douglas County Re 1 80345001874 1512 Challenge to Excellence Charter School   Regular School Yes Elementary KG 08 2020   grade_8 44 0 6   0 13     0   6   31 38                       69 44 0 6   0 13     0   6   31 38                 69
1804420 CO     school 803450 900   Douglas County Re 1 80345002011 1579 North Star Academy   Regular School Yes Elementary KG 08 2020   grade_8 40 0 10   0 6     0   2   26 32                       58 40 0 10   0 6     0   2   26 32                 58
1804431 CO     school 803450 900   Douglas County Re 1 80345000812 1873 Parker Core Knowledge Charter School   Regular School Yes Elementary KG 08 2020   grade_8 55 1 6   0 12     0   3   41 36                       77 55 1 6   0 12     0   3   41 36                 77
1804650 CO     school 803450 900   Douglas County Re 1 80345006765 5225 Leman Classical Academy   Regular School Yes Elementary KG 08 2020   grade_8 17 0 5   0 3     0   0   12 13                       25 17 0 5   0 3     0   0   12 13                 25
1804708 CO     school 803450 900   Douglas County Re 1 80345001581 5997 DC Montessori Charter School   Regular School Yes Elementary PK 08 2020   grade_8 29 0 3   0 1     0   2   13 22                       35 29 0 3   0 1     0   2   13 22                 35
1804719 CO     school 803450 900   Douglas County Re 1 80345006588 6019 Aspen View Academy   Regular School Yes Elementary PK 08 2020   grade_8 69 0 17   1 2     0   3   37 55                       92 69 0 17   1 2     0   3   37 55                 92
1804769 CO     school 803450 900   Douglas County Re 1 80345006690 6719 Parker Performing Arts   Regular School Yes Elementary KG 08 2020   grade_8 58 4 12   0 0     0   8   22 60                       82 58 4 12   0 0     0   8   22 60                 82
1804815 CO     school 803450 900   Douglas County Re 1 80345001584 7047 Platte River Charter Academy   Regular School Yes Elementary KG 08 2020   grade_8 47 3 7   0 5     0   4   31 35                       66 47 3 7   0 5     0   4   31 35                 66
1804961 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_8 32 0 5   0 0     0   2   14 25                       39 32 0 5   0 0     0   2   14 25                 39
1805024 CO     school 803540 910   Eagle County RE 50 80354000851 2340 Eagle County Charter Academy   Regular School Yes Elementary KG 08 2020   grade_8 36 0 1   0 0     0   1   19 19                       38 36 0 1   0 0     0   1   19 19                 38
1805078 CO     school 803540 910   Eagle County RE 50 80354001478 5742 Homestake Peak School   Regular School No Elementary PK 08 2020   grade_8 36 1 63   1 1     0   3   54 51                       105 36 1 63   1 1     0   3   54 51                 105
1805116 CO     school 803720 920   Elizabeth School District 80372001586 2572 Legacy Academy   Regular School Yes Elementary KG 08 2020   grade_8 45 0 2   1 1     0   1   30 20                       50 45 0 2   1 1     0   1   30 20                 50
1805324 CO     school 804530 980   Harrison 2 80453001903 6162 Mountain Vista Community School   Regular School No Elementary PK 08 2020   grade_8 21 9 53   1 3     0   8   51 44                       95 21 9 53   1 3     0   8   51 44                 95
1805414 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_8 31 9 15   0 2     3   8   34 34                       68 31 9 15   0 2     3   8   34 34                 68
1805436 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1805609 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2020   grade_8 19 0 3   0 0     0   4   12 14                       26 19 0 3   0 0     0   4   12 14                 26
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
1806431 CO     school 805820 1080   Lewis-Palmer 38 80582001536 5093 Monument Charter Academy   Regular School Yes Elementary PK 08 2020   grade_8 98 1 13   1 3     0   2   58 60                       118 98 1 13   1 3     0   2   58 60                 118
1806582 CO     school 803870 1110   District 49 80387006386 4251 Grand Peak Academy   Regular School Yes Elementary KG 08 2020   grade_8 26 4 12   0 0     0   2   15 29                       44 26 4 12   0 0     0   2   15 29                 44
1806645 CO     school 803870 1110   District 49 80387001844 6935 Pikes Peak School Expeditionary Learning   Regular School Yes Elementary KG 08 2020   grade_8 25 2 5   0 2     0   3   21 16                       37 25 2 5   0 2     0   3   21 16                 37
1806671 CO     school 803870 1110   District 49 80387002000 7463 Rocky Mountain Classical Academy   Regular School Yes Elementary KG 08 2020   grade_8 48 4 17   0 2     1   12   42 42                       84 48 4 17   0 2     1   12   42 42                 84
1806768 CO     school 802790 1140   Canon City RE-1 80279000173 3802 Harrison School   Regular School No Elementary KG 08 2020   grade_8 86 0 13   1 0     0   2   55 47                       102 86 0 13   1 0     0   2   55 47                 102
1806792 CO     school 802790 1140   Canon City RE-1 80279001538 6752 Mount View Core Knowledge Charter School   Regular School Yes Elementary PK 08 2020   grade_8 23 0 3   0 0     0   1   12 15                       27 23 0 3   0 0     0   1   12 15                 27
1806802 CO     school 802790 1140   Canon City RE-1 80279001433 7950 Canon Exploratory School   Regular School No Elementary KG 08 2020   grade_8 12 0 8   0 0     0   2   8 14                       22 12 0 8   0 0     0   2   8 14                 22
1806860 CO     school 804260 1180   Roaring Fork RE-1 80426001505 429 Carbondale Community Charter School   Regular School Yes Elementary KG 08 2020   grade_8 11 0 1   0 0     0   1   5 8                       13 11 0 1   0 0     0   1   5 8                 13
1806921 CO     school 804260 1180   Roaring Fork RE-1 80426006715 7298 Riverview School   Regular School No Elementary PK 08 2020   grade_8 14 0 25   0 0     0   3   20 22                       42 14 0 25   0 0     0   3   20 22                 42
1807054 CO     school 805070 1340   West Grand 1-JT 80507000829 9422 West Grand Elementary and Middle School   Regular School No Elementary KG 08 2020   grade_8 16 1 13   0 0     0   0   16 14                       30 16 1 13   0 0     0   0   16 14                 30
1807147 CO     school 807080 1390   Huerfano Re-1 80708001845 63 Peakview School   Regular School No Elementary PK 08 2020   grade_8 7 0 18   1 0     0   0   16 10                       26 7 0 18   1 0     0   0   16 10                 26
1807158 CO     school 807080 1390   Huerfano Re-1 80708001211 3306 Gardner Elementary School   Regular School No Elementary PK 08 2020   grade_8 0 0 7   0 0     0   0   4 3                       7 0 0 7   0 0     0   0   4 3                 7
1807228 CO     school 804800 1420   Jefferson County R-1 80480006489 109 Arvada K-8   Regular School No Elementary KG 08 2020   grade_8 46 6 67   3 2     1   6   75 56                       131 46 6 67   3 2     1   6   75 56                 131
1807265 CO     school 804800 1420   Jefferson County R-1 80480000696 660 Bear Creek K-8 School   Regular School No Elementary KG 08 2020   grade_8 55 1 43   2 9     2   9   65 56                       121 55 1 43   2 9     2   9   65 56                 121
1807352 CO     school 804800 1420   Jefferson County R-1 80480000704 1730 Coal Creek Canyon K-8 Elementary School   Regular School No Elementary KG 08 2020   grade_8 14 1 1   0 1     0   1   10 8                       18 14 1 1   0 1     0   1   10 8                 18

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