Data source: Big Local News · About: Big Local

1,109 rows where grade = "grade_2", state = "CO" and year = 2021 sorted by white

View and edit SQL

year

  • 2021 · 1,109

grade

  • grade_2 · 1,109
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
1741852 CO     school 803360 880   Denver County 1 80336000306 220 John H. Amesse Elementary   Regular School No Elementary PK 05 2021   grade_2 0 9 47   0 0     0   0   34 22                       56 0 9 47   0 0     0   0   34 22                 56
1741883 CO     school 803360 880   Denver County 1 80336000311 520 Barnum Elementary School   Regular School No Elementary PK 05 2021   grade_2 0 2 37   1 0     0   0   15 25                       40 0 2 37   1 0     0   0   15 25                 40
1742378 CO     school 803360 880   Denver County 1 80336001739 3647 Marie L. Greenwood Academy   Regular School No Elementary KG 08 2021   grade_2 0 4 44   1 0     0   0   28 21                       49 0 4 44   1 0     0   0   28 21                 49
1742420 CO     school 803360 880   Denver County 1 80336000362 3778 International Academy of Denver at Harrington   Regular School No Elementary PK 05 2021   grade_2 0 6 17   1 0     0   0   10 14                       24 0 6 17   1 0     0   0   10 14                 24
1742562 CO     school 803360 880   Denver County 1 80336000371 4762 Knapp Elementary School   Regular School No Elementary PK 05 2021   grade_2 0 2 61   1 0     0   0   33 31                       64 0 2 61   1 0     0   0   33 31                 64
1742570 CO     school 803360 880   Denver County 1 80336000372 4782 Hallett Academy   Regular School No Elementary PK 05 2021   grade_2 0 37 4   0 0     0   4   23 22                       45 0 37 4   0 0     0   4   23 22                 45
1742658 CO     school 803360 880   Denver County 1 80336001635 5644 Maxwell Elementary School   Regular School No Elementary PK 05 2021   grade_2 0 17 91   1 1     0   0   62 48                       110 0 17 91   1 1     0   0   62 48                 110
1742984 CO     school 803360 880   Denver County 1 80336006525 8131 Oakland Elementary   Regular School No Elementary PK 05 2021   grade_2 0 8 22   0 2     0   0   14 18                       32 0 8 22   0 2     0   0   14 18                 32
1740046 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2021   grade_2 1 6 27   0 5     0   0   20 19                       39 1 6 27   0 5     0   0   20 19                 39
1740299 CO     school 802340 180   Adams-Arapahoe 28J 80234001927 6869 Peoria Elementary School   Regular School No Elementary PK 05 2021   grade_2 1 8 36   0 2     1   3   25 26                       51 1 8 36   0 2     1   3   25 26                 51
1741655 CO     school 806360 640   Centennial R-1 80636001416 1398 Centennial School   Regular School No Other PK 12 2021   grade_2 1 0 11   0 0     0   0   5 7                       12 1 0 11   0 0     0   0   5 7                 12
1741891 CO     school 803360 880   Denver County 1 80336000313 650 Beach Court Elementary School   Regular School No Elementary PK 05 2021   grade_2 1 1 36   1 0     0   0   18 21                       39 1 1 36   1 0     0   0   18 21                 39
1742238 CO     school 803360 880   Denver County 1 80336000337 2364 Eagleton Elementary School   Regular School No Elementary PK 05 2021   grade_2 1 2 31   2 0     0   1   19 18                       37 1 2 31   2 0     0   1   19 18                 37
1742466 CO     school 803360 880   Denver County 1 80336001928 4140 Farrell B. Howell ECE-8 School   Regular School No Elementary PK 08 2021   grade_2 1 3 42   2 0     2   0   27 23                       50 1 3 42   2 0     2   0   27 23                 50
1742592 CO     school 803360 880   Denver County 1 80336006748 4850 KIPP Sunshine Peak Elementary   Regular School Yes Elementary PK 02 2021   grade_2 1 0 28   0 0     0   0   14 15                       29 1 0 28   0 0     0   0   14 15                 29
1742644 CO     school 803360 880   Denver County 1 80336006445 5608 Mathematics and Science Leadership Academy   Regular School No Elementary KG 05 2021   grade_2 1 3 25   0 1     0   2   10 22                       32 1 3 25   0 1     0   2   10 22                 32
1742733 CO     school 803360 880   Denver County 1 80336000387 6188 Munroe Elementary School   Regular School No Elementary PK 05 2021   grade_2 1 2 50   0 0     1   1   21 34                       55 1 2 50   0 0     1   1   21 34                 55
1742898 CO     school 803360 880   Denver County 1 80336006646 7471 Rocky Mountain Prep: Southwest   Regular School Yes Elementary PK 05 2021   grade_2 1 1 61   0 0     0   2   34 31                       65 1 1 61   0 0     0   2   34 31                 65
1743108 CO     school 803360 880   Denver County 1 80336000421 9050 Valverde Elementary School   Regular School No Elementary PK 05 2021   grade_2 1 0 35   0 0     0   0   14 22                       36 1 0 35   0 0     0   0   14 22                 36
1743143 CO     school 803360 880   Denver County 1 80336000426 9548 Whittier ECE-8 School   Regular School No Elementary PK 08 2021   grade_2 1 11 8   0 0     0   1   11 10                       21 1 11 8   0 0     0   1   11 10                 21
1746041 CO     school 804620 1380   Hinsdale County RE 1 80462001969 4899 Lake City Community School   Regular School No Other PK 12 2021   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1747391 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2021   grade_2 1 0 4   0 0     0   1   3 3                       6 1 0 4   0 0     0   1   3 3                 6
1747828 CO     school 803990 1550   Poudre R-1 80399006564 7043 PSD Options School   Regular School No Elementary KG 08 2021   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1748350 CO     school 804890 1810   Karval RE-23 80489000814 4502 Karval Elementary School   Regular School No Elementary PK 06 2021   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1748610 CO     school 804350 2000   Mesa County Valley 51 80435000611 3350 Gateway School   Regular School No Other PK 12 2021   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1749426 CO     school 804290 2650   Granada RE-1 80429000592 3542 Granada Elementary School   Regular School No Elementary PK 06 2021   grade_2 1 0 6   0 0     0   1   4 4                       8 1 0 6   0 0     0   1   4 4                 8
1749779 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2021   grade_2 1 0 1   0 0     0   0   0 2                       2 1 0 1   0 0     0   0   0 2                 2
1750370 CO     school 802220 3040   Arickaree R-2 80222000041 304 Arickaree Elementary School   Regular School No Elementary PK 05 2021   grade_2 1 0 4   0 0     0   0   3 2                       5 1 0 4   0 0     0   0   3 2                 5
1750866 CO     school 804410 3120   Greeley 6 80441006638 8467 Salida del Sol Academy   Regular School Yes Elementary KG 08 2021   grade_2 1 0 46   0 0     0   0   20 27                       47 1 0 46   0 0     0   0   20 27                 47
1738298 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2021   grade_2 10 1 58   0 3     0   0   41 31                       72 10 1 58   0 3     0   0   41 31                 72
1738347 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2021   grade_2 10 1 34   0 1     0   1   21 26                       47 10 1 34   0 1     0   1   21 26                 47
1738583 CO     school 806900 20   Adams 12 Five Star Schools 80690001306 5058 Leroy Drive Elementary School   Regular School No Elementary KG 05 2021   grade_2 10 3 47   2 2     0   4   33 35                       68 10 3 47   2 2     0   4   33 35                 68
1739199 CO     school 807230 70   Westminster Public Schools 80723001249 8798 Tennyson Knolls Preparatory School   Regular School No Elementary PK 08 2021   grade_2 10 0 28   0 3     0   1   20 22                       42 10 0 28   0 3     0   1   20 22                 42
1739326 CO     school 806540 123   Sheridan 2 80654001132 3054 Alice Terry Elementary School   Regular School No Elementary KG 02 2021   grade_2 10 3 40   1 2     0   2   23 35                       58 10 3 40   1 2     0   2   23 35                 58
1739569 CO     school 802910 130   Cherry Creek 5 80291006182 3988 Highline Community Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 21 38   1 4     4   0   40 38                       78 10 21 38   1 4     4   0   40 38                 78
1739954 CO     school 803270 170   Deer Trail 26J 80327000287 2136 Deer Trail Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 0 13   0 0     0   1   14 10                       24 10 0 13   0 0     0   1   14 10                 24
1740013 CO     school 802340 180   Adams-Arapahoe 28J 80234001296 310 Arkansas Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 14 19   0 2     2   7   28 26                       54 10 14 19   0 2     2   7   28 26                 54
1740085 CO     school 802340 180   Adams-Arapahoe 28J 80234006803 1851 Harmony Ridge P-8   Regular School No Elementary PK 08 2021   grade_2 10 5 29   0 1     0   5   25 25                       50 10 5 29   0 1     0   5   25 25                 50
1740221 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2021   grade_2 10 33 27   1 1     0   1   28 45                       73 10 33 27   1 1     0   1   28 45                 73
1740459 CO     school 802340 180   Adams-Arapahoe 28J 80234000085 9756 Yale Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 13 25   1 5     1   13   34 34                       68 10 13 25   1 5     1   13   34 34                 68
1741430 CO     school 802490 480   Boulder Valley Re 2 80249001403 7592 Alicia Sanchez International School   Regular School No Elementary PK 05 2021   grade_2 10 0 22   0 3     0   0   22 13                       35 10 0 22   0 3     0   0   22 13                 35
1741960 CO     school 803360 880   Denver County 1 80336006449 1345 Rocky Mountain Prep: Berkeley   Regular School Yes Elementary PK 05 2021   grade_2 10 5 22   0 0     0   2   21 18                       39 10 5 22   0 0     0   2   21 18                 39
1742848 CO     school 803360 880   Denver County 1 80336006398 7045 Place Bridge Academy   Regular School No Elementary PK 08 2021   grade_2 10 18 21   0 12     0   1   29 33                       62 10 18 21   0 12     0   1   29 33                 62
1742881 CO     school 803360 880   Denver County 1 80336006641 7243 Reach Charter School   Regular School Yes Elementary PK 05 2021   grade_2 10 0 2   0 0     0   3   10 5                       15 10 0 2   0 0     0   3   10 5                 15
1744294 CO     school 804530 980   Harrison 2 80453000671 8337 Stratmoor Hills Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 9 11   0 0     0   4   23 11                       34 10 9 11   0 0     0   4   23 11                 34
1744308 CO     school 804530 980   Harrison 2 80453001443 8923 Turman Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 5 17   0 1     0   1   17 17                       34 10 5 17   0 1     0   1   17 17                 34
1744748 CO     school 803060 1010   Colorado Springs 11 80306000253 5878 Midland Elementary School   Regular School No Elementary KG 05 2021   grade_2 10 0 9   0 0     0   1   9 11                       20 10 0 9   0 0     0   1   9 11                 20
1744842 CO     school 803060 1010   Colorado Springs 11 80306000267 8466 Taylor Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 0 8   0 0     0   2   11 9                       20 10 0 8   0 0     0   2   11 9                 20
1745417 CO     school 803870 1110   District 49 80387006794 467 Mountain View Academy   Regular School Yes Elementary KG 08 2021   grade_2 10 0 4   0 1     0   4   10 9                       19 10 0 4   0 1     0   4   10 9                 19
1746137 CO     school 804800 1420   Jefferson County R-1 80480006489 109 Arvada K-8   Regular School No Elementary KG 08 2021   grade_2 10 0 26   2 0     0   1   23 16                       39 10 0 26   2 0     0   1   23 16                 39
1746256 CO     school 804800 1420   Jefferson County R-1 80480000704 1730 Coal Creek Canyon K-8 Elementary School   Regular School No Elementary KG 08 2021   grade_2 10 0 0   0 1     0   0   8 3                       11 10 0 0   0 1     0   0   8 3                 11
1746648 CO     school 804800 1420   Jefferson County R-1 80480000748 5004 Lasley Elementary School   Regular School No Elementary KG 06 2021   grade_2 10 1 34   1 2     0   0   30 18                       48 10 1 34   1 2     0   0   30 18                 48
1747710 CO     school 803990 1550   Poudre R-1 80399000573 3787 Harris Bilingual Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 0 38   0 0     0   1   27 22                       49 10 0 38   0 0     0   1   27 22                 49
1747880 CO     school 803990 1550   Poudre R-1 80399000542 7218 Putnam Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 3 24   0 0     0   2   17 22                       39 10 3 24   0 0     0   2   17 22                 39
1748249 CO     school 804650 1600   Hoehne Reorganized 3 80465000680 4048 Hoehne Schools   Regular School No Other PK 12 2021   grade_2 10 0 16   0 0     0   0   18 8                       26 10 0 16   0 0     0   0   18 8                 26
1749097 CO     school 804050 2405   Fort Morgan Re-3 80405006698 1009 Baker Elementary School   Regular School No Elementary 01 05 2021   grade_2 10 4 33   0 0     0   0   21 26                       47 10 4 33   0 0     0   0   21 26                 47
1749129 CO     school 804050 2405   Fort Morgan Re-3 80405006298 6954 Pioneer Elementary School   Regular School No Elementary 01 05 2021   grade_2 10 4 32   0 0     0   0   22 24                       46 10 4 32   0 0     0   0   22 24                 46
1749333 CO     school 803840 2610   Park County RE-2 80384000501 4908 Lake George Charter School   Regular School Yes Elementary PK 08 2021   grade_2 10 0 1   0 0     0   2   6 7                       13 10 0 1   0 0     0   2   6 7                 13
1749484 CO     school 807320 2680   Wiley RE-13 Jt 80732001260 9604 Wiley Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 0 10   0 0     0   2   12 10                       22 10 0 10   0 0     0   2   12 10                 22
1749529 CO     school 806120 2690   Pueblo City 60 80612001032 860 Beulah Heights Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 3 31   1 1     0   0   29 17                       46 10 3 31   1 1     0   0   29 17                 46
1749588 CO     school 806120 2690   Pueblo City 60 80612001038 1828 Columbian Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 2 23   2 0     0   0   18 19                       37 10 2 23   2 0     0   0   18 19                 37
1749628 CO     school 806120 2690   Pueblo City 60 80612000261 3924 Heritage Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 0 32   1 0     0   1   20 24                       44 10 0 32   1 0     0   1   20 24                 44
1750027 CO     school 806660 2770   Steamboat Springs RE-2 80666001749 6363 North Routt Charter School   Regular School Yes Elementary PK 08 2021   grade_2 10 0 2   0 0     0   0   7 5                       12 10 0 2   0 0     0   0   7 5                 12
1750227 CO     school 806000 2865   Revere School District 80600001020 7050 Revere Elementary   Regular School No Elementary KG 06 2021   grade_2 10 1 2   0 0     0   0   5 8                       13 10 1 2   0 0     0   0   5 8                 13
1750488 CO     school 803600 3085   Eaton RE-2 80360000477 3286 Galeton Elementary School   Regular School No Elementary KG 05 2021   grade_2 10 0 9   0 0     0   1   7 13                       20 10 0 9   0 0     0   1   7 13                 20
1750944 CO     school 804020 3140   Weld Re-8 Schools 80402001366 8930 Twombly Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 0 51   0 0     0   0   33 28                       61 10 0 51   0 0     0   0   33 28                 61
1750969 CO     school 802550 3146   Briggsdale RE-10 80255000142 1008 Briggsdale Elementary School   Regular School No Elementary PK 05 2021   grade_2 10 0 1   0 2     0   0   6 7                       13 10 0 1   0 2     0   0   6 7                 13
1751343 CO     school 800020 8001   Charter School Institute 80002006706 5845 Monument View Montessori Charter School   Regular School Yes Elementary PK 05 2021   grade_2 10 0 2   0 0     0   0   5 7                       12 10 0 2   0 0     0   0   5 7                 12
1750715 CO     school 804410 3120   Greeley 6 80441001614 1875 Frontier Charter Academy   Regular School Yes Other KG 12 2021   grade_2 100 1 34   1 1     1   5   72 71                       143 100 1 34   1 1     1   5   72 71                 143
1748366 CO     school 806690 1828   Valley RE-1 80669006339 515 Ayres Elementary School   Regular School No Elementary KG 02 2021   grade_2 102 2 39   0 0     0   3   75 71                       146 102 2 39   0 0     0   3   75 71                 146
1750592 CO     school 807350 3100   Windsor RE-4 80735001815 9665 Windsor Charter Academy Elementary School   Regular School Yes Elementary KG 05 2021   grade_2 103 1 20   0 1     0   4   53 76                       129 103 1 20   0 1     0   4   53 76                 129
1747453 CO     school 803480 1520   Durango 9-R 80348006696 1526 Colorado Connections Academy @ Durango   Regular School No Other KG 12 2021   grade_2 109 12 60   2 2     0   11   93 103                       196 109 12 60   2 2     0   11   93 103                 196
1739160 CO     school 807230 70   Westminster Public Schools 80723001363 7810 John E. Flynn A Marzano Academy   Regular School No Elementary PK 07 2021   grade_2 11 1 24   0 5     0   1   27 15                       42 11 1 24   0 5     0   1   27 15                 42
1739288 CO     school 803780 120   Englewood 1 80378000488 1556 Cherrelyn Elementary School   Regular School No Elementary KG 06 2021   grade_2 11 0 19   0 0     0   4   15 19                       34 11 0 19   0 0     0   4   15 19                 34
1740546 CO     school 802190 220   Archuleta County 50 Jt 80219006717 6679 Pagosa Peak Open School   Regular School Yes Elementary KG 07 2021   grade_2 11 0 3   2 1     0   1   7 11                       18 11 0 3   2 1     0   1   7 11                 18
1741535 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   grade_2 11 0 0   0 0     0   0   10 1                       11 11 0 0   0 0     0   0   10 1                 11
1742531 CO     school 803360 880   Denver County 1 80336006652 4500 KIPP Northeast Elementary   Regular School Yes Elementary PK 04 2021   grade_2 11 32 54   0 5     4   7   52 61                       113 11 32 54   0 5     4   7   52 61                 113
1742710 CO     school 803360 880   Denver County 1 80336000384 6002 Montclair School of Academics and Enrichment   Regular School No Elementary PK 05 2021   grade_2 11 29 12   0 1     0   2   33 22                       55 11 29 12   0 1     0   2   33 22                 55
1742780 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2021   grade_2 11 0 26   0 2     0   1   18 22                       40 11 0 26   0 2     0   1   18 22                 40
1744085 CO     school 806600 940   Big Sandy 100J 80660001138 7914 Simla Elementary School   Regular School No Elementary PK 05 2021   grade_2 11 0 4   0 0     0   0   3 12                       15 11 0 4   0 0     0   0   3 12                 15
1744231 CO     school 804530 980   Harrison 2 80453000668 6018 Monterey Elementary School   Regular School No Elementary PK 05 2021   grade_2 11 6 25   1 1     0   3   28 19                       47 11 6 25   1 1     0   3   28 19                 47
1745751 CO     school 803120 1160   Cotopaxi RE-3 80312000276 3220 Cotopaxi Elementary School   Regular School No Elementary PK 05 2021   grade_2 11 0 1   0 0     0   1   7 6                       13 11 0 1   0 0     0   1   7 6                 13
1745812 CO     school 804260 1180   Roaring Fork RE-1 80426000589 3460 Glenwood Springs Elementary School   Regular School No Elementary PK 05 2021   grade_2 11 0 47   0 0     0   1   33 26                       59 11 0 47   0 0     0   1   33 26                 59
1745830 CO     school 804260 1180   Roaring Fork RE-1 80426006715 7298 Riverview School   Regular School No Elementary PK 08 2021   grade_2 11 0 22   0 1     0   1   20 15                       35 11 0 22   0 1     0   1   20 15                 35
1747598 CO     school 803990 1550   Poudre R-1 80399006776 473 PSD Mountain Schools   Regular School No Elementary PK 05 2021   grade_2 11 0 1   0 0     0   1   6 7                       13 11 0 1   0 0     0   1   6 7                 13
1748451 CO     school 803240 1980   De Beque 49JT 80324000286 2126 De Beque PK-12 School District 49JT   Regular School No Other PK 12 2021   grade_2 11 0 5   0 1     0   0   7 10                       17 11 0 5   0 1     0   0   7 10                 17
1748891 CO     school 803090 2035   Montezuma-Cortez RE-1 80309000837 5090 Lewis-Arriola Elementary School   Regular School No Elementary KG 05 2021   grade_2 11 0 3   2 0     0   0   8 8                       16 11 0 3   2 0     0   0   8 8                 16
1749636 CO     school 806120 2690   Pueblo City 60 80612001048 3976 Highland Park Elementary School   Regular School No Elementary PK 05 2021   grade_2 11 0 54   0 0     0   2   37 30                       67 11 0 54   0 0     0   2   37 30                 67
1750211 CO     school 804860 2862   Julesburg Re-1 80486000811 4488 Julesburg Elementary School   Regular School No Elementary PK 06 2021   grade_2 11 0 7   0 0     0   0   11 7                       18 11 0 7   0 0     0   0   11 7                 18
1743584 CO     school 803450 900   Douglas County Re 1 80345006765 5225 Leman Classical Academy   Regular School Yes Elementary KG 08 2021   grade_2 110 0 13   2 3     0   9   77 60                       137 110 0 13   2 3     0   9   77 60                 137
1739007 CO     school 802580 40   School District 27J 80258000150 8060 South Elementary School   Regular School No Elementary PK 05 2021   grade_2 12 0 48   1 0     0   2   26 37                       63 12 0 48   1 0     0   2   26 37                 63
1739128 CO     school 807230 70   Westminster Public Schools 80723006373 4465 Josephine Hodgkins Leadership Academy   Regular School No Elementary PK 07 2021   grade_2 12 0 55   1 1     1   2   44 28                       72 12 0 55   1 1     1   2   44 28                 72
1739994 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2021   grade_2 12 13 10   1 1     0   3   16 24                       40 12 13 10   1 1     0   3   16 24                 40
1740555 CO     school 807110 230   Walsh RE-1 80711001215 9222 Walsh Elementary School   Regular School No Elementary PK 06 2021   grade_2 12 1 2   1 0     0   0   10 6                       16 12 1 2   1 0     0   0   10 6                 16
1740604 CO     school 806990 260   Vilas RE-5 80699001206 9090 Vilas Elementary School   Regular School No Elementary PK 06 2021   grade_2 12 1 0   0 2     0   1   8 8                       16 12 1 0   0 2     0   1   8 8                 16
1741453 CO     school 802490 480   Boulder Valley Re 2 80249000135 8978 University Hill Elementary School   Regular School No Elementary PK 05 2021   grade_2 12 0 49   0 0     0   3   37 27                       64 12 0 49   0 0     0   3   37 27                 64
1741554 CO     school 803000 540   Clear Creek RE-1 80300001999 3385 Georgetown Community School   Regular School Yes Elementary PK 06 2021   grade_2 12 0 0   0 0     0   0   9 3                       12 12 0 0   0 0     0   0   9 3                 12
1741595 CO     school 805100 550   North Conejos RE-1J 80510000844 4836 La Jara Elementary School   Regular School No Elementary PK 05 2021   grade_2 12 0 14   0 0     1   0   10 17                       27 12 0 14   0 0     1   0   10 17                 27
1741725 CO     school 803330 870   Delta County 50(J) 80333000295 1952 North Fork Montessori @ Crawford   Regular School No Elementary PK 06 2021   grade_2 12 0 1   0 0     0   0   10 3                       13 12 0 1   0 0     0   0   10 3                 13
1742370 CO     school 803360 880   Denver County 1 80336001776 3641 Green Valley Elementary School   Regular School No Elementary PK 05 2021   grade_2 12 19 43   1 10     1   2   50 38                       88 12 19 43   1 10     1   2   50 38                 88

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