Data source: Big Local News · About: Big Local

1,104 rows where grade = "grade_2", state = "CO" and year = 2020 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2020 · 1,104

grade

  • grade_2 · 1,104
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
1801018 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2020   grade_2 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
1803067 CO     school 803360 880   Denver County 1 80336000331 1908 Cory Elementary School   Regular School No Elementary 01 05 2020   grade_2 63 3 6   0 2     0   10   40 44                       84 63 3 6   0 2     0   10   40 44                 84
1803085 CO     school 803360 880   Denver County 1 80336001767 2027 Polaris Elementary School   Regular School No Elementary 01 05 2020   grade_2 31 0 9   2 3     0   9   29 25                       54 31 0 9   2 3     0   9   29 25                 54
1803340 CO     school 803360 880   Denver County 1 80336001864 3340 Lena Archuleta Elementary School   Regular School No Elementary 01 05 2020   grade_2 5 9 72   0 5     0   3   45 49                       94 5 9 72   0 5     0   3   45 49                 94
1810236 CO     school 804050 2405   Fort Morgan Re-3 80405006698 1009 Baker Elementary School   Regular School No Elementary 01 05 2020   grade_2 17 2 37   0 0     0   1   31 26                       57 17 2 37   0 0     0   1   31 26                 57
1810242 CO     school 804050 2405   Fort Morgan Re-3 80405000556 1850 Columbine Elementary School   Regular School No Elementary 01 05 2020   grade_2 26 1 48   1 1     0   1   39 39                       78 26 1 48   1 1     0   1   39 39                 78
1810257 CO     school 804050 2405   Fort Morgan Re-3 80405000558 3620 Green Acres Elementary School   Regular School No Elementary 01 05 2020   grade_2 28 3 28   0 0     0   3   26 36                       62 28 3 28   0 0     0   3   26 36                 62
1810268 CO     school 804050 2405   Fort Morgan Re-3 80405006298 6954 Pioneer Elementary School   Regular School No Elementary 01 05 2020   grade_2 15 11 40   0 0     0   1   35 32                       67 15 11 40   0 0     0   1   35 32                 67
1811093 CO     school 805760 2740   Monte Vista C-8 80576000985 6036 Bill Metz Elementary School   Regular School No Elementary 01 05 2020   grade_2 17 1 40   1 0     0   0   36 23                       59 17 1 40   1 0     0   0   36 23                 59
1806477 CO     school 803870 1110   District 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2020   grade_2 14 0 6   0 0     0   4   11 13                       24 14 0 6   0 0     0   4   11 13                 24
1807008 CO     school 804380 1220   Garfield 16 80438000630 3578 Bea Underwood Elementary School   Regular School No Elementary 02 05 2020   grade_2 42 2 41   0 0     0   4   48 41                       89 42 2 41   0 0     0   4   48 41                 89
1809361 CO     school 806960 1580   Trinidad 1 80696001946 2944 Fisher's Peak Elementary School   Regular School No Elementary 02 05 2020   grade_2 12 0 52   1 1     0   1   26 41                       67 12 0 52   1 1     0   1   26 41                 67
1799331 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_2 8 0 25   0 0     0   0   16 17                       33 8 0 25   0 0     0   0   16 17                 33
1799355 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_2 4 0 47   0 1     0   2   32 22                       54 4 0 47   0 1     0   2   32 22                 54
1799404 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_2 4 1 48   0 1     0   2   25 31                       56 4 1 48   0 1     0   2   25 31                 56
1799422 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   grade_2 35 2 21   1 0     0   4   36 27                       63 35 2 21   1 0     0   4   36 27                 63
1799462 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2020   grade_2 35 0 36   1 6     0   2   41 39                       80 35 0 36   1 6     0   2   41 39                 80
1799473 CO     school 806900 20   Adams 12 Five Star Schools 80690001733 59 Meridian Elementary School   Regular School No Elementary KG 05 2020   grade_2 65 0 12   0 8     1   6   48 44                       92 65 0 12   0 8     1   6   48 44                 92
1799512 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2020   grade_2 55 0 12   0 22     0   11   47 53                       100 55 0 12   0 22     0   11   47 53                 100
1799531 CO     school 806900 20   Adams 12 Five Star Schools 80690001305 1914 Cotton Creek Elementary School   Regular School No Elementary KG 05 2020   grade_2 53 2 17   0 7     0   4   38 45                       83 53 2 17   0 7     0   4   38 45                 83
1799538 CO     school 806900 20   Adams 12 Five Star Schools 80690001668 1937 Coyote Ridge Elementary School   Regular School No Elementary KG 05 2020   grade_2 52 0 10   0 8     1   2   37 36                       73 52 0 10   0 8     1   2   37 36                 73
1799545 CO     school 806900 20   Adams 12 Five Star Schools 80690001622 2361 Eagleview Elementary School   Regular School No Elementary KG 05 2020   grade_2 65 2 30   0 10     0   7   55 59                       114 65 2 30   0 10     0   7   55 59                 114
1799568 CO     school 806900 20   Adams 12 Five Star Schools 80690001401 2578 Skyview Elementary School   Regular School No Elementary KG 05 2020   grade_2 30 1 38   0 2     0   1   43 29                       72 30 1 38   0 2     0   1   43 29                 72
1799583 CO     school 806900 20   Adams 12 Five Star Schools 80690001460 2582 Rocky Mountain Elementary School   Regular School No Elementary KG 05 2020   grade_2 19 0 45   0 1     0   1   28 38                       66 19 0 45   0 1     0   1   28 38                 66
1799606 CO     school 806900 20   Adams 12 Five Star Schools 80690001177 4000 Hillcrest Elementary School   Regular School No Elementary KG 05 2020   grade_2 15 4 58   0 6     0   0   50 33                       83 15 4 58   0 6     0   0   50 33                 83
1799618 CO     school 806900 20   Adams 12 Five Star Schools 80690001178 4172 Hulstrom Options K-8 School   Regular School No Elementary KG 08 2020   grade_2 47 2 9   1 12     0   4   40 35                       75 47 2 9   1 12     0   4   40 35                 75
1799642 CO     school 806900 20   Adams 12 Five Star Schools 80690001306 5058 Leroy Drive Elementary School   Regular School No Elementary KG 05 2020   grade_2 24 3 30   0 2     0   2   32 29                       61 24 3 30   0 2     0   2   32 29                 61
1799657 CO     school 806900 20   Adams 12 Five Star Schools 80690001182 5706 McElwain Elementary School   Regular School No Elementary KG 05 2020   grade_2 11 2 52   0 7     0   0   35 37                       72 11 2 52   0 7     0   0   35 37                 72
1799718 CO     school 806900 20   Adams 12 Five Star Schools 80690006507 6802 Prospect Ridge Academy   Regular School Yes Other KG 12 2020   grade_2 72 0 11   0 12     1   4   45 55                       100 72 0 11   0 12     1   4   45 55                 100
1799737 CO     school 806900 20   Adams 12 Five Star Schools 80690001945 7155 Prairie Hills Elementary School   Regular School No Elementary KG 05 2020   grade_2 47 0 13   1 8     0   1   38 32                       70 47 0 13   1 8     0   1   38 32                 70
1799744 CO     school 806900 20   Adams 12 Five Star Schools 80690002028 7795 Silver Creek Elementary   Regular School No Elementary KG 05 2020   grade_2 67 3 25   1 5     0   6   58 49                       107 67 3 25   1 5     0   6   58 49                 107
1799751 CO     school 806900 20   Adams 12 Five Star Schools 80690006375 8211 The Studio School   Regular School No Elementary KG 05 2020   grade_2 22 1 20   0 1     0   3   13 34                       47 22 1 20   0 1     0   3   13 34                 47
1799758 CO     school 806900 20   Adams 12 Five Star Schools 80690006303 8225 Stellar Elementary School   Regular School No Elementary KG 05 2020   grade_2 29 3 37   1 4     0   6   35 45                       80 29 3 37   1 4     0   6   35 45                 80
1799776 CO     school 806900 20   Adams 12 Five Star Schools 80690006561 8310 STEM Launch   Regular School No Elementary KG 08 2020   grade_2 14 2 61   1 0     0   0   44 34                       78 14 2 61   1 0     0   0   44 34                 78
1799786 CO     school 806900 20   Adams 12 Five Star Schools 80690001190 8361 Stukey Elementary School   Regular School No Elementary KG 05 2020   grade_2 17 1 41   0 3     0   4   30 36                       66 17 1 41   0 3     0   4   30 36                 66
1799815 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   grade_2 32 1 11   0 2     0   3   22 27                       49 32 1 11   0 2     0   3   22 27                 49
1799862 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2020   grade_2 3 1 52   0 0     1   1   33 25                       58 3 1 52   0 0     1   1   33 25                 58
1799876 CO     school 801950 30   Adams County 14 80195000013 2308 Dupont Elementary School   Regular School No Elementary KG 05 2020   grade_2 6 1 69   0 0     0   0   43 33                       76 6 1 69   0 0     0   0   43 33                 76
1799897 CO     school 801950 30   Adams County 14 80195000017 5982 Monaco Elementary School   Regular School No Elementary KG 05 2020   grade_2 7 1 37   0 0     0   0   24 21                       45 7 1 37   0 0     0   0   24 21                 45
1799920 CO     school 802580 40   School District 27J 80258001948 700 Belle Creek Charter School   Regular School Yes Elementary KG 08 2020   grade_2 30 1 38   0 4     0   4   42 35                       77 30 1 38   0 4     0   4   42 35                 77
1799965 CO     school 802580 40   School District 27J 80258006465 2945 Foundations Academy   Regular School Yes Elementary KG 08 2020   grade_2 54 2 19   0 1     0   0   47 29                       76 54 2 19   0 1     0   0   47 29                 76
1799983 CO     school 802580 40   School District 27J 80258006325 4950 Landmark Academy at Reunion   Regular School Yes Elementary KG 08 2020   grade_2 62 0 17   0 4     0   2   46 39                       85 62 0 17   0 4     0   2   46 39                 85
1800110 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2020   grade_2 37 0 27   0 0     1   4   36 33                       69 37 0 27   0 0     1   4   36 33                 69
1800289 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School   Regular School No Elementary KG 05 2020   grade_2 44 2 118   2 0     0   3   103 66                       169 44 2 118   2 0     0   3   103 66                 169
1800330 CO     school 803780 120   Englewood 1 80378000486 1514 Charles Hay World School   Regular School No Elementary KG 06 2020   grade_2 35 4 13   0 0     0   3   26 29                       55 35 4 13   0 0     0   3   26 29                 55
1800338 CO     school 803780 120   Englewood 1 80378000488 1556 Cherrelyn Elementary School   Regular School No Elementary KG 06 2020   grade_2 20 1 12   0 1     0   2   22 14                       36 20 1 12   0 1     0   2   22 14                 36
1800346 CO     school 803780 120   Englewood 1 80378000489 1652 Clayton Elementary School   Regular School No Elementary KG 06 2020   grade_2 32 3 25   0 1     0   9   33 37                       70 32 3 25   0 1     0   9   33 37                 70
1800368 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   grade_2 11 2 16   0 0     0   0   17 12                       29 11 2 16   0 0     0   0   17 12                 29
1800376 CO     school 806540 123   Sheridan 2 80654001132 3054 Alice Terry Elementary School   Regular School No Elementary KG 02 2020   grade_2 8 2 60   1 3     0   3   37 40                       77 8 2 60   1 3     0   3   37 40                 77
1800511 CO     school 802910 130   Cherry Creek 5 80291001152 1571 Cherry Creek Charter Academy   Regular School Yes Elementary KG 08 2020   grade_2 28 0 3   0 18     0   3   30 22                       52 28 0 3   0 18     0   3   30 22                 52
1800641 CO     school 802910 130   Cherry Creek 5 80291006676 4189 Heritage Heights Academy   Regular School Yes Elementary KG 08 2020   grade_2 29 4 8   0 4     0   3   25 23                       48 29 4 8   0 4     0   3   25 23                 48
1800709 CO     school 802910 130   Cherry Creek 5 80291006563 6367 Options School   Alternative School No Other KG 12 2020   grade_2 51 1 5   0 1     0   4   29 33                       62 51 1 5   0 1     0   4   29 33                 62
1800856 CO     school 805310 140   Littleton 6 80531000878 752 Franklin Elementary School   Regular School No Elementary KG 05 2020   grade_2 77 1 9   0 0     1   2   45 45                       90 77 1 9   0 0     1   2   45 45                 90
1800863 CO     school 805310 140   Littleton 6 80531000874 1382 Centennial Academy of Fine Arts Education   Regular School No Elementary KG 05 2020   grade_2 48 0 27   0 0     0   9   46 38                       84 48 0 27   0 0     0   9   46 38                 84
1800870 CO     school 805310 140   Littleton 6 80531000875 2382 East Elementary School   Regular School No Elementary KG 05 2020   grade_2 14 0 28   0 1     0   2   21 24                       45 14 0 28   0 1     0   2   21 24                 45
1800881 CO     school 805310 140   Littleton 6 80531000877 2926 Field Elementary School   Regular School No Elementary KG 05 2020   grade_2 13 2 30   0 0     0   0   22 23                       45 13 2 30   0 0     0   0   22 23                 45
1800918 CO     school 805310 140   Littleton 6 80531001515 5229 Littleton Academy   Regular School Yes Elementary KG 08 2020   grade_2 42 1 5   0 5     0   1   29 25                       54 42 1 5   0 5     0   1   29 25                 54
1800939 CO     school 805310 140   Littleton 6 80531001300 5236 Lois Lenski Elementary School   Regular School No Elementary KG 05 2020   grade_2 82 1 3   0 2     0   7   53 42                       95 82 1 3   0 2     0   7   53 42                 95
1800954 CO     school 805310 140   Littleton 6 80531000891 5574 Twain Elementary School   Regular School No Elementary KG 05 2020   grade_2 37 1 5   0 4     0   4   37 14                       51 37 1 5   0 4     0   4   37 14                 51
1800970 CO     school 805310 140   Littleton 6 80531000888 7518 Runyon Elementary School   Regular School No Elementary KG 05 2020   grade_2 72 1 3   0 1     0   2   46 33                       79 72 1 3   0 1     0   2   46 33                 79
1800977 CO     school 805310 140   Littleton 6 80531000889 7606 Sandburg Elementary School   Regular School No Elementary KG 05 2020   grade_2 73 0 1   0 2     0   1   45 32                       77 73 0 1   0 2     0   1   45 32                 77
1801026 CO     school 802340 180   Adams-Arapahoe 28J 80234006771 122 Aurora Community School   Regular School Yes Elementary KG 06 2020   grade_2 2 9 7   0 0     0   2   7 13                       20 2 9 7   0 0     0   2   7 13                 20
1801031 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2020   grade_2 6 20 42   0 2     1   6   32 45                       77 6 20 42   0 2     1   6   32 45                 77
1801072 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_2 6 20 21   0 2     0   3   28 24                       52 6 20 21   0 2     0   3   28 24                 52
1801200 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2020   grade_2 14 32 49   0 1     0   4   49 51                       100 14 32 49   0 1     0   4   49 51                 100
1801260 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2020   grade_2 16 32 21   0 3     0   3   33 42                       75 16 32 21   0 3     0   3   33 42                 75
1801311 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2020   grade_2 69 5 19   0 4     0   6   54 49                       103 69 5 19   0 4     0   6   54 49                 103
1801346 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2020   grade_2 23 10 10   0 4     0   6   27 26                       53 23 10 10   0 4     0   6   27 26                 53
1801402 CO     school 802340 180   Adams-Arapahoe 28J 80234001324 8858 Tollgate Elementary School of Expeditionary Learning   Regular School No Elementary KG 05 2020   grade_2 16 18 50   1 5     4   4   46 52                       98 16 18 50   1 5     4   4   46 52                 98
1801409 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 07 2020   grade_2 4 4 19   0 12     0   0   20 19                       39 4 4 19   0 12     0   0   20 19                 39
1801416 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2020   grade_2 8 12 26   0 1     0   1   24 24                       48 8 12 26   0 1     0   1   24 24                 48
1801469 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_2 10 34 24   0 0     0   3   30 41                       71 10 34 24   0 0     0   3   30 41                 71
1801539 CO     school 802700 190   Byers 32J 80270006630 6241 Colorado Virtual Academy   Regular School Yes Elementary KG 06 2020   grade_2 24 1 12   1 0     0   0   20 18                       38 24 1 12   1 0     0   0   20 18                 38
1801561 CO     school 802190 220   Archuleta County 50 Jt 80219000038 6652 Pagosa Springs Elementary School   Regular School No Elementary KG 04 2020   grade_2 48 0 50   9 2     0   2   57 54                       111 48 0 50   9 2     0   2   57 54                 111
1801578 CO     school 802190 220   Archuleta County 50 Jt 80219006717 6679 Pagosa Peak Open School   Regular School Yes Elementary KG 06 2020   grade_2 10 0 2   0 0     0   0   5 7                       12 10 0 2   0 0     0   0   5 7                 12
1801674 CO     school 805250 290   Las Animas RE-1 80525000866 1812 Las Animas Elementary School   Regular School No Elementary KG 06 2020   grade_2 16 0 10   0 0     0   2   10 18                       28 16 0 10   0 0     0   2   10 18                 28
1801731 CO     school 805370 470   St Vrain Valley RE1J 80537006530 71 Aspen Ridge Preparatory School   Regular School Yes Elementary KG 08 2020   grade_2 44 1 4   0 5     0   5   31 28                       59 44 1 4   0 5     0   5   31 28                 59
1801745 CO     school 805370 470   St Vrain Valley RE1J 80537006539 120 Apex Home School Enrichment Program   Regular School No Other KG 12 2020   grade_2 67 1 6   0 0     0   4   41 37                       78 67 1 6   0 0     0   4   41 37                 78
1802093 CO     school 805370 470   St Vrain Valley RE1J 80537001572 8927 Twin Peaks Charter Academy   Regular School Yes Other KG 12 2020   grade_2 30 0 21   0 5     0   1   31 26                       57 30 0 21   0 5     0   1   31 26                 57
1802124 CO     school 802490 480   Boulder Valley Re 2 80249000099 652 Bear Creek Elementary School   Regular School No Elementary KG 05 2020   grade_2 60 1 6   0 4     0   8   33 46                       79 60 1 6   0 4     0   8   33 46                 79
1802139 CO     school 802490 480   Boulder Valley Re 2 80249001630 919 Boulder Community School/Integrated Studies   Regular School No Elementary KG 05 2020   grade_2 42 1 1   0 1     0   6   32 19                       51 42 1 1   0 1     0   6   32 19                 51
1802191 CO     school 802490 480   Boulder Valley Re 2 80249001376 1725 Coal Creek Elementary School   Regular School No Elementary KG 05 2020   grade_2 48 0 3   0 1     0   6   35 23                       58 48 0 3   0 1     0   6   35 23                 58
1802214 CO     school 802490 480   Boulder Valley Re 2 80249000110 1996 Crest View Elementary School   Regular School No Elementary KG 05 2020   grade_2 54 0 14   0 5     0   4   47 30                       77 54 0 14   0 5     0   4   47 30                 77
1802229 CO     school 802490 480   Boulder Valley Re 2 80249000112 2552 Eisenhower Elementary School   Regular School No Elementary KG 05 2020   grade_2 50 1 9   0 6     0   6   40 32                       72 50 1 9   0 6     0   6   40 32                 72
1802279 CO     school 802490 480   Boulder Valley Re 2 80249000115 2970 Flatirons Elementary School   Regular School No Elementary KG 05 2020   grade_2 39 0 2   0 1     0   1   23 20                       43 39 0 2   0 1     0   1   23 20                 43
1802286 CO     school 802490 480   Boulder Valley Re 2 80249000116 3022 Foothill Elementary School   Regular School No Elementary KG 05 2020   grade_2 69 0 8   0 1     0   2   38 42                       80 69 0 8   0 1     0   2   38 42                 80
1802293 CO     school 802490 480   Boulder Valley Re 2 80249000117 3488 Gold Hill Elementary School   Regular School No Elementary KG 05 2020   grade_2 3 0 0   0 0     0   1   3 1                       4 3 0 0   0 0     0   1   3 1                 4
1802307 CO     school 802490 480   Boulder Valley Re 2 80249001243 3940 High Peaks Elementary School   Regular School No Elementary KG 05 2020   grade_2 27 2 4   0 10     0   4   26 21                       47 27 2 4   0 10     0   4   26 21                 47
1802314 CO     school 802490 480   Boulder Valley Re 2 80249000119 4386 Jamestown Elementary School   Regular School No Elementary KG 05 2020   grade_2 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
1802349 CO     school 802490 480   Boulder Valley Re 2 80249000124 5302 Louisville Elementary School   Regular School No Elementary KG 05 2020   grade_2 68 1 7   0 4     0   8   41 47                       88 68 1 7   0 4     0   8   41 47                 88
1802370 CO     school 802490 480   Boulder Valley Re 2 80249000129 5838 Mesa Elementary School   Regular School No Elementary KG 05 2020   grade_2 36 0 1   0 2     0   2   21 20                       41 36 0 1   0 2     0   2   21 20                 41
1802418 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2020   grade_2 32 0 1   0 1     0   4   23 15                       38 32 0 1   0 1     0   4   23 15                 38
1802431 CO     school 802490 480   Boulder Valley Re 2 80249001792 6816 Peak to Peak Charter School   Regular School Yes Other KG 12 2020   grade_2 52 0 6   0 11     0   3   37 35                       72 52 0 6   0 11     0   3   37 35                 72
1802474 CO     school 802490 480   Boulder Valley Re 2 80249001518 8418 Superior Elementary School   Regular School No Elementary KG 05 2020   grade_2 52 0 4   0 9     0   4   33 36                       69 52 0 4   0 9     0   4   33 36                 69
1802489 CO     school 802490 480   Boulder Valley Re 2 80249000139 9544 Whittier Elementary School   Regular School No Elementary KG 05 2020   grade_2 43 0 14   0 5     0   2   36 28                       64 43 0 14   0 5     0   2   36 28                 64
1802512 CO     school 802640 490   Buena Vista R-31 80264000159 4306 Avery/Parsons Elementary School   Regular School No Elementary KG 05 2020   grade_2 64 2 12   0 0     0   1   35 44                       79 64 2 12   0 0     0   1   35 44                 79
1802534 CO     school 806330 500   Salida R-32 80633001108 5268 Longfellow Elementary School   Regular School No Elementary KG 04 2020   grade_2 68 0 8   0 0     0   3   39 40                       79 68 0 8   0 0     0   3   39 40                 79
1802630 CO     school 805100 550   North Conejos RE-1J 80510000845 5422 Manassa Elementary School   Regular School No Elementary KG 05 2020   grade_2 11 0 28   0 0     0   0   22 17                       39 11 0 28   0 0     0   0   22 17                 39
1802708 CO     school 803210 770   Crowley County RE-1-J 80321001519 2054 Crowley County Elementary K-6   Regular School No Elementary KG 06 2020   grade_2 17 0 19   0 0     0   1   16 21                       37 17 0 19   0 0     0   1   16 21                 37
1802782 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2020   grade_2 27 0 3   0 0     0   3   16 17                       33 27 0 3   0 0     0   3   16 17                 33

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