Data source: Big Local News · About: Big Local

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

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 ▲
1806140 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2020   grade_2 268 5 26   2 8     1   12   178 144                       322 268 5 26   2 8     1   12   178 144                 322
1804295 CO     school 803450 900   Douglas County Re 1 80345001896 215 American Academy   Regular School Yes Elementary PK 08 2020   grade_2 207 3 13   2 53     0   23   142 159                       301 207 3 13   2 53     0   23   142 159                 301
1812476 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2020   grade_2 22 0 140   1 5     0   4   79 93                       172 22 0 140   1 5     0   4   79 93                 172
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
1811704 CO     school 807350 3100   Windsor RE-4 80735001263 8886 Tozer Elementary School   Regular School No Elementary PK 02 2020   grade_2 113 3 40   2 2     0   4   90 74                       164 113 3 40   2 2     0   4   90 74                 164
1805975 CO     school 802940 1020   Cheyenne Mountain 12 80294001326 1582 The Vanguard School (Elementary)   Regular School Yes Elementary KG 06 2020   grade_2 99 2 34   1 8     1   15   79 81                       160 99 2 34   1 8     1   15   79 81                 160
1800735 CO     school 802910 130   Cherry Creek 5 80291006452 6955 Pine Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_2 100 8 19   0 14     0   14   89 66                       155 100 8 19   0 14     0   14   89 66                 155
1809507 CO     school 806690 1828   Valley RE-1 80669006339 515 Ayres Elementary School   Regular School No Elementary KG 02 2020   grade_2 102 4 33   2 2     0   6   90 59                       149 102 4 33   2 2     0   6   90 59                 149
1811602 CO     school 803600 3085   Eaton RE-2 80360000474 2448 Eaton Elementary School   Regular School No Elementary PK 02 2020   grade_2 105 2 30   0 0     0   3   90 50                       140 105 2 30   0 0     0   3   90 50                 140
1812199 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_2 83 0 34   0 9     0   12   69 69                       138 83 0 34   0 9     0   12   69 69                 138
1806512 CO     school 803870 1110   District 49 80387002027 555 Banning Lewis Ranch Academy   Regular School Yes Other KG 11 2020   grade_2 76 7 36   1 3     0   11   74 60                       134 76 7 36   1 3     0   11   74 60                 134
1811829 CO     school 804410 3120   Greeley 6 80441001614 1875 Frontier Charter Academy   Regular School Yes Other KG 12 2020   grade_2 100 0 31   0 1     0   2   74 60                       134 100 0 31   0 1     0   2   74 60                 134
1800034 CO     school 802580 40   School District 27J 80258006718 7318 Reunion Elementary School   Regular School No Elementary PK 05 2020   grade_2 83 3 33   1 6     0   4   74 56                       130 83 3 33   1 6     0   4   74 56                 130
1800829 CO     school 802910 130   Cherry Creek 5 80291000204 9108 Village East Community Elementary School   Regular School No Elementary PK 05 2020   grade_2 27 39 48   0 9     0   6   64 65                       129 27 39 48   0 9     0   6   64 65                 129
1804587 CO     school 803450 900   Douglas County Re 1 80345006577 3863 HOPE Online Learning Academy Elementary   Regular School Yes Elementary KG 05 2020   grade_2 13 6 108   0 0     0   2   73 56                       129 13 6 108   0 0     0   2   73 56                 129
1799950 CO     school 802580 40   School District 27J 80258001729 1052 Bromley East Charter School   Regular School Yes Elementary PK 08 2020   grade_2 79 1 42   1 0     0   2   69 56                       125 79 1 42   1 0     0   2   69 56                 125
1807518 CO     school 804800 1420   Jefferson County R-1 80480000721 2866 Fairmount Elementary School   Regular School No Elementary KG 05 2020   grade_2 111 1 6   0 3     0   4   64 61                       125 111 1 6   0 3     0   4   64 61                 125
1808354 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_2 101 1 16   0 2     0   5   63 62                       125 101 1 16   0 2     0   5   63 62                 125
1802075 CO     school 805370 470   St Vrain Valley RE1J 80537006739 8055 Soaring Heights PK-8   Regular School No Elementary PK 08 2020   grade_2 100 1 18   0 1     0   4   75 49                       124 100 1 18   0 1     0   4   75 49                 124
1804319 CO     school 803450 900   Douglas County Re 1 80345006368 266 Gold Rush Elementary   Regular School No Elementary PK 05 2020   grade_2 100 1 15   1 5     0   2   63 61                       124 100 1 15   1 5     0   2   63 61                 124
1801442 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2020   grade_2 39 12 51   0 7     0   14   67 56                       123 39 12 51   0 7     0   14   67 56                 123
1803841 CO     school 803360 880   Denver County 1 80336000391 6754 Park Hill School   Regular School No Elementary PK 05 2020   grade_2 92 8 11   1 1     0   10   59 64                       123 92 8 11   1 1     0   10   59 64                 123
1811778 CO     school 804410 3120   Greeley 6 80441001988 52 Heiman Elementary School   Regular School No Elementary KG 05 2020   grade_2 50 2 67   0 2     0   2   72 51                       123 50 2 67   0 2     0   2   72 51                 123
1804310 CO     school 803450 900   Douglas County Re 1 80345006392 265 Clear Sky Elementary   Regular School No Elementary PK 06 2020   grade_2 87 3 22   0 1     0   8   61 60                       121 87 3 22   0 1     0   8   61 60                 121
1811719 CO     school 807350 3100   Windsor RE-4 80735001815 9665 Windsor Charter Academy Elementary School   Regular School Yes Elementary KG 05 2020   grade_2 103 1 13   0 1     1   1   60 60                       120 103 1 13   0 1     1   1   60 60                 120
1811795 CO     school 804410 3120   Greeley 6 80441001990 54 Bella Romero Academy of Applied Technology   Regular School No Elementary KG 08 2020   grade_2 18 11 89   1 0     0   1   63 57                       120 18 11 89   1 0     0   1   63 57                 120
1806405 CO     school 805820 1080   Lewis-Palmer 38 80582001371 3539 Bear Creek Elementary School   Regular School No Elementary PK 06 2020   grade_2 91 0 18   1 2     0   7   59 60                       119 91 0 18   1 2     0   7   59 60                 119
1812390 CO     school 800020 8001   Charter School Institute 80002006503 3439 Global Village Academy - Northglenn   Regular School Yes Elementary KG 08 2020   grade_2 41 1 72   0 3     0   2   55 64                       119 41 1 72   0 3     0   2   55 64                 119
1806665 CO     school 803870 1110   District 49 80387002000 7463 Rocky Mountain Classical Academy   Regular School Yes Elementary KG 08 2020   grade_2 79 4 23   0 2     0   10   52 66                       118 79 4 23   0 2     0   10   52 66                 118
1804158 CO     school 803360 880   Denver County 1 80336001957 9425 Westerly Creek Elementary   Regular School No Elementary PK 05 2020   grade_2 84 5 16   1 4     0   6   64 52                       116 84 5 16   1 4     0   6   64 52                 116
1805569 CO     school 804080 1000   Fountain 8 80408000565 6338 Patriot Elementary School   Regular School No Elementary KG 05 2020   grade_2 66 10 19   1 1     3   16   57 59                       116 66 10 19   1 1     3   16   57 59                 116
1803110 CO     school 803360 880   Denver County 1 80336006482 2127 Denver Language School   Regular School Yes Elementary KG 08 2020   grade_2 50 9 33   1 7     0   15   54 61                       115 50 9 33   1 7     0   15   54 61                 115
1808260 CO     school 804800 1420   Jefferson County R-1 80480006722 8856 Three Creeks K-8   Regular School No Elementary KG 08 2020   grade_2 88 2 14   0 7     0   4   52 63                       115 88 2 14   0 7     0   4   52 63                 115
1808739 CO     school 803990 1550   Poudre R-1 80399006380 498 Bethke Elementary School   Regular School No Elementary KG 05 2020   grade_2 98 0 8   1 3     0   5   56 59                       115 98 0 8   1 3     0   5   56 59                 115
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
1799930 CO     school 802580 40   School District 27J 80258006549 1013 Brantner Elementary School   Regular School No Elementary PK 05 2020   grade_2 71 3 25   1 7     0   7   52 62                       114 71 3 25   1 7     0   7   52 62                 114
1800050 CO     school 802580 40   School District 27J 80258001950 7714 Second Creek Elementary School   Regular School No Elementary PK 05 2020   grade_2 36 8 60   0 4     0   6   57 57                       114 36 8 60   0 4     0   6   57 57                 114
1800411 CO     school 802910 130   Cherry Creek 5 80291006750 102 Altitude Elementary School   Regular School No Elementary PK 05 2020   grade_2 77 4 11   1 13     0   8   69 45                       114 77 4 11   1 13     0   8   69 45                 114
1800698 CO     school 802910 130   Cherry Creek 5 80291006607 6225 Mountain Vista Elementary School   Regular School No Elementary PK 05 2020   grade_2 66 16 10   2 12     0   8   61 53                       114 66 16 10   2 12     0   8   61 53                 114
1806605 CO     school 803870 1110   District 49 80387001843 5779 Meridian Ranch Elementary School   Regular School No Elementary PK 05 2020   grade_2 77 3 17   1 6     1   9   56 58                       114 77 3 17   1 6     1   9   56 58                 114
1806649 CO     school 803870 1110   District 49 80387001537 7317 Remington Elementary School   Regular School No Elementary PK 05 2020   grade_2 53 9 30   0 5     1   16   61 53                       114 53 9 30   0 5     1   16   61 53                 114
1809047 CO     school 803990 1550   Poudre R-1 80399000547 8460 Tavelli Elementary School   Regular School No Elementary PK 05 2020   grade_2 83 2 21   1 0     0   7   59 55                       114 83 2 21   1 0     0   7   59 55                 114
1811695 CO     school 807350 3100   Windsor RE-4 80735006460 8459 Range View Elementary   Regular School No Elementary PK 05 2020   grade_2 100 1 13   0 0     0   0   53 61                       114 100 1 13   0 0     0   0   53 61                 114
1811858 CO     school 804410 3120   Greeley 6 80441001696 2850 University Schools   Regular School Yes Other KG 12 2020   grade_2 69 0 39   0 0     0   4   57 55                       112 69 0 39   0 0     0   4   57 55                 112
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
1804184 CO     school 803360 880   Denver County 1 80336006332 9623 William (Bill) Roberts ECE-8 School   Regular School No Elementary PK 08 2020   grade_2 88 8 6   0 2     0   6   54 56                       110 88 8 6   0 2     0   6   54 56                 110
1800427 CO     school 802910 130   Cherry Creek 5 80291001670 242 Antelope Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_2 72 7 15   2 6     0   7   53 56                       109 72 7 15   2 6     0   7   53 56                 109
1804713 CO     school 803450 900   Douglas County Re 1 80345006588 6019 Aspen View Academy   Regular School Yes Elementary PK 08 2020   grade_2 92 0 11   0 2     0   3   60 48                       108 92 0 11   0 2     0   3   60 48                 108
1805401 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2020   grade_2 57 13 22   0 4     0   12   60 48                       108 57 13 22   0 4     0   12   60 48                 108
1806864 CO     school 804260 1180   Roaring Fork RE-1 80426000582 560 Basalt Elementary School   Regular School No Elementary PK 04 2020   grade_2 37 1 67   1 1     0   1   57 51                       108 37 1 67   1 1     0   1   57 51                 108
1811930 CO     school 804410 3120   Greeley 6 80441001483 5660 S. Christa McAuliffe STEM Academy   Regular School No Elementary KG 08 2020   grade_2 45 0 55   0 4     0   4   45 63                       108 45 0 55   0 4     0   4   45 63                 108
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
1800542 CO     school 802910 130   Cherry Creek 5 80291000188 1916 Cottonwood Creek Elementary School   Regular School No Elementary PK 05 2020   grade_2 73 3 10   0 14     1   6   56 51                       107 73 3 10   0 14     1   6   56 51                 107
1800750 CO     school 802910 130   Cherry Creek 5 80291000200 7116 Ponderosa Elementary School   Regular School No Elementary PK 05 2020   grade_2 22 31 38   2 9     0   5   60 47                       107 22 31 38   2 9     0   5   60 47                 107
1804830 CO     school 803450 900   Douglas County Re 1 80345001809 7134 Prairie Crossing Elementary School   Regular School No Elementary PK 06 2020   grade_2 74 2 21   0 5     0   5   60 47                       107 74 2 21   0 5     0   5   60 47                 107
1800577 CO     school 802910 130   Cherry Creek 5 80291000191 2428 Eastridge Community Elementary School   Regular School No Elementary PK 05 2020   grade_2 24 34 33   0 6     0   9   60 46                       106 24 34 33   0 6     0   9   60 46                 106
1803677 CO     school 803360 880   Denver County 1 80336001635 5644 Maxwell Elementary School   Regular School No Elementary PK 05 2020   grade_2 2 18 81   0 1     2   2   51 55                       106 2 18 81   0 1     2   2   51 55                 106
1807259 CO     school 804800 1420   Jefferson County R-1 80480000696 660 Bear Creek K-8 School   Regular School No Elementary KG 08 2020   grade_2 57 1 37   1 4     0   6   56 50                       106 57 1 37   1 4     0   6   56 50                 106
1804674 CO     school 803450 900   Douglas County Re 1 80345006472 5607 Sage Canyon Elementary   Regular School No Elementary PK 06 2020   grade_2 92 0 8   0 0     0   5   60 45                       105 92 0 8   0 0     0   5   60 45                 105
1804790 CO     school 803450 900   Douglas County Re 1 80345000444 6940 Pine Lane Elementary   Regular School No Elementary PK 06 2020   grade_2 74 4 18   0 8     0   1   52 53                       105 74 4 18   0 8     0   1   52 53                 105
1805543 CO     school 804080 1000   Fountain 8 80408000564 3108 Mesa Elementary School   Regular School No Elementary KG 05 2020   grade_2 66 6 17   3 0     1   12   55 50                       105 66 6 17   3 0     1   12   55 50                 105
1807643 CO     school 804800 1420   Jefferson County R-1 80480000975 4402 Jefferson Academy Elementary   Regular School Yes Elementary KG 06 2020   grade_2 81 1 13   0 5     0   5   50 55                       105 81 1 13   0 5     0   5   50 55                 105
1808676 CO     school 802400 1530   Bayfield 10 Jt-R 80240006747 642 Bayfield Primary School   Regular School No Elementary PK 02 2020   grade_2 78 1 19   4 0     0   3   50 55                       105 78 1 19   4 0     0   3   50 55                 105
1809025 CO     school 803990 1550   Poudre R-1 80399000544 7350 Riffenburgh Elementary School   Regular School No Elementary KG 05 2020   grade_2 79 2 17   0 2     0   5   55 50                       105 79 2 17   0 2     0   5   55 50                 105
1811923 CO     school 804410 3120   Greeley 6 80441006469 5620 Maplewood Elementary School   Regular School No Elementary KG 05 2020   grade_2 16 11 63   0 14     0   1   58 47                       105 16 11 63   0 14     0   1   58 47                 105
1803925 CO     school 803360 880   Denver County 1 80336000398 7554 Sabin World School   Regular School No Elementary PK 05 2020   grade_2 25 1 71   1 2     0   4   60 44                       104 25 1 71   1 2     0   4   60 44                 104
1805408 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_2 58 8 23   0 0     2   13   50 54                       104 58 8 23   0 0     2   13   50 54                 104
1805517 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2020   grade_2 48 20 24   3 0     0   9   50 54                       104 48 20 24   3 0     0   9   50 54                 104
1806132 CO     school 801920 1040   Academy 20 80192006329 1615 Chinook Trail Elementary School   Regular School No Elementary KG 05 2020   grade_2 84 1 11   0 3     0   5   46 58                       104 84 1 11   0 3     0   5   46 58                 104
1808724 CO     school 803990 1550   Poudre R-1 80399001727 477 Zach Elementary School   Regular School No Elementary KG 05 2020   grade_2 77 2 5   0 8     0   12   60 44                       104 77 2 5   0 8     0   12   60 44                 104
1800464 CO     school 802910 130   Cherry Creek 5 80291006301 1155 Buffalo Trail Elementary School   Regular School No Elementary PK 06 2020   grade_2 51 10 19   0 9     0   14   56 47                       103 51 10 19   0 9     0   14   56 47                 103
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
1804820 CO     school 803450 900   Douglas County Re 1 80345000445 7096 Roxborough Elementary School   Regular School No Elementary PK 02 2020   grade_2 88 0 9   0 2     0   4   53 50                       103 88 0 9   0 2     0   4   53 50                 103
1806245 CO     school 801920 1040   Academy 20 80192000005 6158 Mountain View Elementary School   Regular School No Elementary KG 05 2020   grade_2 75 3 13   0 6     1   5   53 50                       103 75 3 13   0 6     1   5   53 50                 103
1810315 CO     school 805130 2520   East Otero R-1 80513001975 4843 La Junta Primary School   Regular School No Elementary KG 02 2020   grade_2 32 1 68   0 1     0   1   48 55                       103 32 1 68   0 1     0   1   48 55                 103
1805366 CO     school 804530 980   Harrison 2 80453001965 8034 Soaring Eagles Elementary School   Regular School No Elementary PK 05 2020   grade_2 20 15 51   1 3     5   7   51 51                       102 20 15 51   1 3     5   7   51 51                 102
1800096 CO     school 802580 40   School District 27J 80258006326 9426 West Ridge Elementary   Regular School No Elementary PK 05 2020   grade_2 58 1 31   0 7     0   4   48 53                       101 58 1 31   0 7     0   4   48 53                 101
1803685 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_2 3 16 70   0 2     9   1   49 52                       101 3 16 70   0 2     9   1   49 52                 101
1804280 CO     school 803450 900   Douglas County Re 1 80345006492 135 Ben Franklin Academy   Regular School Yes Elementary PK 08 2020   grade_2 77 0 12   2 7     0   3   46 55                       101 77 0 12   2 7     0   3   46 55                 101
1804740 CO     school 803450 900   Douglas County Re 1 80345006455 6365 Skyview Academy   Regular School Yes Other PK 12 2020   grade_2 55 2 11   1 23     0   9   51 50                       101 55 2 11   1 23     0   9   51 50                 101
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
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
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
1802943 CO     school 803360 880   Denver County 1 80336000319 1076 Brown International Academy   Regular School No Elementary PK 05 2020   grade_2 57 6 27   1 1     0   8   45 55                       100 57 6 27   1 1     0   8   45 55                 100
1810540 CO     school 802280 2640   Aspen 1 80228000045 428 Aspen Elementary School   Regular School No Elementary PK 04 2020   grade_2 83 0 13   0 1     2   1   53 47                       100 83 0 13   0 1     2   1   53 47                 100
1801356 CO     school 802340 180   Adams-Arapahoe 28J 80234006677 7233 Rocky Mountain Prep: Fletcher   Regular School Yes Elementary PK 05 2020   grade_2 12 18 63   0 2     0   4   55 44                       99 12 18 63   0 2     0   4   55 44                 99
1805471 CO     school 806480 990   Widefield 3 80648001418 8392 Sunrise Elementary School   Regular School No Elementary KG 05 2020   grade_2 46 4 34   0 2     3   10   44 55                       99 46 4 34   0 2     3   10   44 55                 99
1800084 CO     school 802580 40   School District 27J 80258006401 8820 Turnberry Elementary   Regular School No Elementary PK 05 2020   grade_2 46 3 43   1 3     0   2   53 45                       98 46 3 43   1 3     0   2   53 45                 98
1800992 CO     school 805310 140   Littleton 6 80531000893 9600 Wilder Elementary School   Regular School No Elementary PK 05 2020   grade_2 81 0 8   0 5     0   4   59 39                       98 81 0 8   0 5     0   4   59 39                 98
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
1805576 CO     school 804080 1000   Fountain 8 80408006481 9610 Weikel Elementary School   Regular School No Elementary PK 05 2020   grade_2 61 12 11   2 3     1   8   56 42                       98 61 12 11   2 3     1   8   56 42                 98
1806296 CO     school 801920 1040   Academy 20 80192006336 7247 Ranch Creek Elementary   Regular School No Elementary PK 05 2020   grade_2 64 3 18   0 2     1   10   46 52                       98 64 3 18   0 2     1   10   46 52                 98
1806425 CO     school 805820 1080   Lewis-Palmer 38 80582001536 5093 Monument Charter Academy   Regular School Yes Elementary PK 08 2020   grade_2 80 2 9   0 1     0   6   59 39                       98 80 2 9   0 1     0   6   59 39                 98
1806576 CO     school 803870 1110   District 49 80387006386 4251 Grand Peak Academy   Regular School Yes Elementary KG 08 2020   grade_2 58 2 18   1 7     1   11   50 48                       98 58 2 18   1 7     1   11   50 48                 98
1800399 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2020   grade_2 54 10 10   1 15     0   7   49 48                       97 54 10 10   1 15     0   7   49 48                 97
1800549 CO     school 802910 130   Cherry Creek 5 80291001404 1970 Creekside Elementary School   Regular School No Elementary PK 05 2020   grade_2 53 5 14   0 17     0   8   48 49                       97 53 5 14   0 17     0   8   48 49                 97
1801968 CO     school 805370 470   St Vrain Valley RE1J 80537000914 5726 Mead Elementary School   Regular School No Elementary PK 05 2020   grade_2 77 0 18   0 1     0   1   53 44                       97 77 0 18   0 1     0   1   53 44                 97
1804658 CO     school 803450 900   Douglas County Re 1 80345006493 5259 STEM School Highlands Ranch   Regular School Yes Other KG 12 2020   grade_2 51 2 9   0 19     0   16   58 39                       97 51 2 9   0 19     0   16   58 39                 97
1810231 CO     school 802610 2395   Brush RE-2(J) 80261000156 8832 Thomson Primary School   Regular School No Elementary PK 02 2020   grade_2 48 1 47   0 0     0   1   52 45                       97 48 1 47   0 0     0   1   52 45                 97
1810597 CO     school 805220 2660   Lamar Re-2 80522000865 9268 Washington Elementary School   Regular School No Elementary KG 02 2020   grade_2 34 0 59   0 1     0   3   58 39                       97 34 0 59   0 1     0   3   58 39                 97

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