Data source: Big Local News · About: Big Local

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

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
1808155 CO     school 804800 1420   Jefferson County R-1 80480006307 8036 Sobesky Academy   Special Education School No Other KG 12 2020   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1809975 CO     school 805730 2020   Moffat County RE: No 1 80573000980 5656 Maybell School   Regular School No Elementary KG 06 2020   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1810907 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_2 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
1807129 CO     school 804620 1380   Hinsdale County RE 1 80462001969 4899 Lake City Community School   Regular School No Other PK 12 2020   grade_2 7 1 0   1 0     0   1   7 3                       10 7 1 0   1 0     0   1   7 3                 10
1808424 CO     school 803510 1430   Eads RE-1 80351000458 2328 Eads Elementary School   Regular School No Elementary PK 05 2020   grade_2 8 0 1   0 0     0   1   7 3                       10 8 0 1   0 0     0   1   7 3                 10
1808475 CO     school 806510 1460   Hi-Plains R-23 80651001130 7746 Hi-Plains School District R-23   Regular School No Other PK 12 2020   grade_2 9 0 1   0 0     0   0   4 6                       10 9 0 1   0 0     0   0   4 6                 10
1808487 CO     school 806780 1480   Stratton R-4 80678001162 8342 Stratton Elementary School   Regular School No Elementary PK 05 2020   grade_2 8 0 2   0 0     0   0   4 6                       10 8 0 2   0 0     0   0   4 6                 10
1809402 CO     school 802010 1620   Aguilar Reorganized 6 80201000022 58 Aguilar Elementary School   Regular School No Elementary PK 05 2020   grade_2 4 0 6   0 0     0   0   7 3                       10 4 0 6   0 0     0   0   7 3                 10
1810001 CO     school 803090 2035   Montezuma-Cortez RE-1 80309001093 609 Battle Rock Charter School   Regular School Yes Elementary KG 06 2020   grade_2 3 0 1   4 0     0   2   6 4                       10 3 0 1   4 0     0   2   6 4                 10
1811154 CO     school 806660 2770   Steamboat Springs RE-2 80666001749 6363 North Routt Charter School   Regular School Yes Elementary KG 08 2020   grade_2 10 0 0   0 0     0   0   5 5                       10 10 0 0   0 0     0   0   5 5                 10
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
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
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
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
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
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
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
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
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
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
1802605 CO     school 803000 540   Clear Creek RE-1 80300001332 4700 King-Murphy Elementary School   Regular School No Elementary PK 06 2020   grade_2 9 0 2   0 0     0   0   6 5                       11 9 0 2   0 0     0   0   6 5                 11
1811318 CO     school 805880 2840   Norwood R-2J 80588001012 6422 Norwood Public Schools   Regular School No Other PK 12 2020   grade_2 10 0 1   0 0     0   0   5 6                       11 10 0 1   0 0     0   0   5 6                 11
1812283 CO     school 800020 8001   Charter School Institute 80002006779 1387 Colorado Early Colleges Windsor   Regular School Yes Other KG 12 2020   grade_2 5 1 3   0 0     0   2   8 3                       11 5 1 3   0 0     0   2   8 3                 11
1812507 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2020   grade_2 10 0 0   0 0     0   1   5 6                       11 10 0 0   0 0     0   1   5 6                 11
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
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
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
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
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
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
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
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
1801000 CO     school 803270 170   Deer Trail 26J 80327000287 2136 Deer Trail Elementary School   Regular School No Elementary PK 05 2020   grade_2 7 0 5   0 0     0   0   8 4                       12 7 0 5   0 0     0   0   8 4                 12
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
1802582 CO     school 803000 540   Clear Creek RE-1 80300001999 3385 Georgetown Community School   Regular School Yes Elementary PK 06 2020   grade_2 12 0 0   0 0     0   0   5 7                       12 12 0 0   0 0     0   0   5 7                 12
1802661 CO     school 802130 580   South Conejos RE-10 80213000033 248 Guadalupe Elementary School   Regular School No Elementary PK 06 2020   grade_2 2 0 10   0 0     0   0   10 2                       12 2 0 10   0 0     0   0   10 2                 12
1805152 CO     school 805010 930   Kiowa C-2 80501000824 4724 Kiowa Elementary School   Regular School No Elementary PK 05 2020   grade_2 11 0 1   0 0     0   0   4 8                       12 11 0 1   0 0     0   0   4 8                 12
1807152 CO     school 807080 1390   Huerfano Re-1 80708001211 3306 Gardner Elementary School   Regular School No Elementary PK 08 2020   grade_2 8 0 4   0 0     0   0   5 7                       12 8 0 4   0 0     0   0   5 7                 12
1808460 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2020   grade_2 11 0 1   0 0     0   0   5 7                       12 11 0 1   0 0     0   0   5 7                 12
1808717 CO     school 803990 1550   Poudre R-1 80399006776 473 PSD Mountain Schools   Regular School No Elementary KG 05 2020   grade_2 12 0 0   0 0     0   0   6 6                       12 12 0 0   0 0     0   0   6 6                 12
1810404 CO     school 805970 2580   Ouray R-1 80597001018 6596 Ouray Elementary School   Regular School No Elementary PK 06 2020   grade_2 8 0 4   0 0     0   0   6 6                       12 8 0 4   0 0     0   0   6 6                 12
1812165 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2020   grade_2 9 0 3   0 0     0   0   4 8                       12 9 0 3   0 0     0   0   4 8                 12
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
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
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
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
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
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
1808997 CO     school 803990 1550   Poudre R-1 80399006431 7198 PSD Global Academy   Regular School No Other KG 12 2020   grade_2 12 0 1   0 0     0   0   7 6                       13 12 0 1   0 0     0   0   7 6                 13
1809608 CO     school 803030 1990   Plateau Valley 50 80303000219 7024 Plateau Valley Elementary School   Regular School No Elementary PK 05 2020   grade_2 13 0 0   0 0     0   0   4 9                       13 13 0 0   0 0     0   0   4 9                 13
1811354 CO     school 806000 2865   Revere School District 80600001020 7050 Revere Elementary   Regular School No Elementary KG 06 2020   grade_2 10 0 3   0 0     0   0   7 6                       13 10 0 3   0 0     0   0   7 6                 13
1812555 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_2 5 3 5   0 0     0   0   7 6                       13 5 3 5   0 0     0   0   7 6                 13

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