Data source: Big Local News · About: Big Local

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

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
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
1799366 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_2 9 0 29   1 1     0   0   18 22                       40 9 0 29   1 1     0   0   18 22                 40
1799375 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_2 5 1 40   0 0     0   0   19 27                       46 5 1 40   0 0     0   0   19 27                 46
1799447 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_2 9 0 18   0 0     0   0   16 11                       27 9 0 18   0 0     0   0   16 11                 27
1799523 CO     school 806900 20   Adams 12 Five Star Schools 80690001174 1878 Coronado Hills Elementary School   Regular School No Elementary PK 05 2020   grade_2 16 3 65   0 3     0   0   49 38                       87 16 3 65   0 3     0   0   49 38                 87
1799575 CO     school 806900 20   Adams 12 Five Star Schools 80690001419 2580 Hunters Glen Elementary School   Regular School No Elementary PK 05 2020   grade_2 40 1 15   1 2     0   0   29 30                       59 40 1 15   1 2     0   0   29 30                 59
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
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
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
1799869 CO     school 801950 30   Adams County 14 80195000012 1426 Central Elementary School   Regular School No Elementary PK 05 2020   grade_2 9 5 53   1 0     1   0   44 25                       69 9 5 53   1 0     1   0   44 25                 69
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
1799887 CO     school 801950 30   Adams County 14 80195000016 4536 Kemp Elementary School   Regular School No Elementary PK 05 2020   grade_2 11 3 66   0 0     0   0   43 37                       80 11 3 66   0 0     0   0   43 37                 80
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
1799904 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2020   grade_2 3 0 41   0 0     0   0   25 19                       44 3 0 41   0 0     0   0   25 19                 44
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
1799975 CO     school 802580 40   School District 27J 80258000146 3900 Henderson Elementary School   Regular School No Elementary PK 05 2020   grade_2 22 1 24   0 1     0   0   25 23                       48 22 1 24   0 1     0   0   25 23                 48
1800001 CO     school 802580 40   School District 27J 80258000148 6294 North Elementary School   Regular School No Elementary PK 05 2020   grade_2 12 0 28   0 0     0   0   21 19                       40 12 0 28   0 0     0   0   21 19                 40
1800163 CO     school 807230 70   Westminster Public Schools 80723001236 3144 Francis M. Day Elementary School   Regular School No Elementary PK 05 2020   grade_2 2 0 45   0 0     0   0   25 22                       47 2 0 45   0 0     0   0   25 22                 47
1800197 CO     school 807230 70   Westminster Public Schools 80723006373 4465 Josephine Hodgkins Leadership Academy   Regular School No Elementary PK 06 2020   grade_2 10 0 74   0 1     0   0   44 41                       85 10 0 74   0 1     0   0   44 41                 85
1800210 CO     school 807230 70   Westminster Public Schools 80723001242 5834 Mesa Elementary School   Regular School No Elementary PK 05 2020   grade_2 11 1 29   0 0     3   0   22 22                       44 11 1 29   0 0     3   0   22 22                 44
1800235 CO     school 807230 70   Westminster Public Schools 80723001246 7860 Sherrelwood Elementary School   Regular School No Elementary PK 05 2020   grade_2 4 0 38   0 1     0   0   21 22                       43 4 0 38   0 1     0   0   21 22                 43
1800243 CO     school 807230 70   Westminster Public Schools 80723001247 7952 Skyline Vista Elementary School   Regular School No Elementary PK 05 2020   grade_2 3 2 40   0 1     0   0   27 19                       46 3 2 40   0 1     0   0   27 19                 46
1800251 CO     school 807230 70   Westminster Public Schools 80723001248 8406 Sunset Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_2 8 0 34   0 1     0   0   28 15                       43 8 0 34   0 1     0   0   28 15                 43
1800259 CO     school 807230 70   Westminster Public Schools 80723001249 8798 Tennyson Knolls Elementary School   Regular School No Elementary PK 05 2020   grade_2 8 0 41   1 9     0   0   31 28                       59 8 0 41   1 9     0   0   31 28                 59
1800309 CO     school 806420 110   Sangre De Cristo Re-22J 80642001115 7626 Sangre de Cristo Elementary School   Regular School No Elementary PK 05 2020   grade_2 15 0 5   0 0     0   0   13 7                       20 15 0 5   0 0     0   0   13 7                 20
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
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
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
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
1801097 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2020   grade_2 2 5 46   0 1     0   0   25 29                       54 2 5 46   0 1     0   0   25 29                 54
1801281 CO     school 802340 180   Adams-Arapahoe 28J 80234000072 6068 Montview Math & Health Sciences Elementary School   Regular School No Elementary PK 05 2020   grade_2 7 4 38   0 0     1   0   22 28                       50 7 4 38   0 0     1   0   22 28                 50
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
1801504 CO     school 802700 190   Byers 32J 80270000163 1168 Byers Elementary School   Regular School No Elementary PK 06 2020   grade_2 24 0 6   1 0     0   0   17 14                       31 24 0 6   1 0     0   0   17 14                 31
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
1801550 CO     school 802700 190   Byers 32J 80270006749 8994 Astravo Online Academy Elementary School   Regular School Yes Elementary PK 05 2020   grade_2 8 0 8   0 0     0   0   8 8                       16 8 0 8   0 0     0   0   8 8                 16
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
1801586 CO     school 807110 230   Walsh RE-1 80711001215 9222 Walsh Elementary School   Regular School No Elementary PK 06 2020   grade_2 15 0 4   0 0     0   0   12 7                       19 15 0 4   0 0     0   0   12 7                 19
1801602 CO     school 806090 240   Pritchett RE-3 80609001026 7174 Pritchett Elementary School   Regular School No Elementary PK 05 2020   grade_2 4 0 1   0 0     0   0   3 2                       5 4 0 1   0 0     0   0   3 2                 5
1801635 CO     school 806990 260   Vilas RE-5 80699001206 9090 Vilas Elementary School   Regular School No Elementary PK 06 2020   grade_2 8 0 0   0 0     0   0   4 4                       8 8 0 0   0 0     0   0   4 4                 8
1801700 CO     school 805580 310   McClave Re-2 80558000962 5666 McClave Elementary School   Regular School No Elementary PK 06 2020   grade_2 15 1 0   0 0     0   0   7 9                       16 15 1 0   0 0     0   0   7 9                 16
1801723 CO     school 805370 470   St Vrain Valley RE1J 80537001832 61 Alpine Elementary School   Regular School No Elementary PK 05 2020   grade_2 34 0 32   1 1     0   0   41 27                       68 34 0 32   1 1     0   0   41 27                 68
1801791 CO     school 805370 470   St Vrain Valley RE1J 80537001887 1284 Carbon Valley Academy   Regular School Yes Elementary PK 08 2020   grade_2 15 0 8   0 0     0   0   11 12                       23 15 0 8   0 0     0   0   11 12                 23
1801898 CO     school 805370 470   St Vrain Valley RE1J 80537000904 4278 Indian Peaks Elementary School   Regular School No Elementary PK 05 2020   grade_2 6 0 40   0 1     1   0   31 17                       48 6 0 40   0 1     1   0   31 17                 48
1801906 CO     school 805370 470   St Vrain Valley RE1J 80537006388 4333 Imagine Charter   Regular School Yes Elementary PK 08 2020   grade_2 50 1 6   0 2     0   0   32 27                       59 50 1 6   0 2     0   0   32 27                 59
1801930 CO     school 805370 470   St Vrain Valley RE1J 80537000907 5284 Longmont Estates Elementary School   Regular School No Elementary PK 05 2020   grade_2 35 1 12   0 0     0   0   16 32                       48 35 1 12   0 0     0   0   16 32                 48
1801980 CO     school 805370 470   St Vrain Valley RE1J 80537006594 6010 Timberline PK-8   Regular School No Elementary PK 08 2020   grade_2 6 1 62   0 0     0   0   37 32                       69 6 1 62   0 0     0   0   37 32                 69
1802011 CO     school 805370 470   St Vrain Valley RE1J 80537000920 6404 Northridge Elementary School   Regular School No Elementary PK 05 2020   grade_2 7 0 35   0 0     0   0   24 18                       42 7 0 35   0 0     0   0   24 18                 42
1802023 CO     school 805370 470   St Vrain Valley RE1J 80537001794 7157 Prairie Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_2 61 0 16   0 3     0   0   48 32                       80 61 0 16   0 3     0   0   48 32                 80
1802030 CO     school 805370 470   St Vrain Valley RE1J 80537000921 7464 Rocky Mountain Elementary School   Regular School No Elementary PK 05 2020   grade_2 4 1 51   0 0     0   0   30 26                       56 4 1 51   0 0     0   0   30 26                 56
1802052 CO     school 805370 470   St Vrain Valley RE1J 80537001396 7584 Sanborn Elementary School   Regular School No Elementary PK 05 2020   grade_2 31 0 18   0 0     0   0   23 26                       49 31 0 18   0 0     0   0   23 26                 49
1802271 CO     school 802490 480   Boulder Valley Re 2 80249006154 2940 Fireside Elementary School   Regular School No Elementary PK 05 2020   grade_2 61 0 9   0 4     0   0   35 39                       74 61 0 9   0 4     0   0   35 39                 74
1802299 CO     school 802490 480   Boulder Valley Re 2 80249000118 3882 Heatherwood Elementary School   Regular School No Elementary PK 05 2020   grade_2 42 1 2   0 1     0   0   23 23                       46 42 1 2   0 1     0   0   23 23                 46
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
1802547 CO     school 805040 510   Kit Carson R-1 80504000827 4738 Kit Carson Elementary School   Regular School No Elementary PK 05 2020   grade_2 4 1 3   0 0     0   0   2 6                       8 4 1 3   0 0     0   0   2 6                 8
1802563 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2020   grade_2 20 0 2   0 0     0   0   11 11                       22 20 0 2   0 0     0   0   11 11                 22
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
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
1802623 CO     school 805100 550   North Conejos RE-1J 80510000844 4836 La Jara Elementary School   Regular School No Elementary PK 05 2020   grade_2 27 0 22   0 0     0   0   21 28                       49 27 0 22   0 0     0   0   21 28                 49
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
1802645 CO     school 806390 560   Sanford 6J 80639001113 7612 Sanford Elementary School   Regular School No Elementary PK 06 2020   grade_2 25 0 6   0 0     0   0   12 19                       31 25 0 6   0 0     0   0   12 19                 31
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
1802681 CO     school 806360 640   Centennial R-1 80636001416 1398 Centennial School   Regular School No Other PK 12 2020   grade_2 0 0 15   0 0     0   0   6 9                       15 0 0 15   0 0     0   0   6 9                 15
1802696 CO     school 804140 740   Sierra Grande R-30 80414000572 7880 Sierra Grande K-12 School   Regular School No Other PK 12 2020   grade_2 2 0 15   0 0     0   0   11 6                       17 2 0 15   0 0     0   0   11 6                 17
1802723 CO     school 807200 860   Custer County School District C-1 80720001226 2088 Custer County Elementary School   Regular School No Elementary PK 05 2020   grade_2 32 0 1   0 0     0   0   12 21                       33 32 0 1   0 0     0   0   12 21                 33
1802751 CO     school 803330 870   Delta County 50(J) 80333000295 1952 North Fork Montessori @ Crawford   Regular School No Elementary PK 06 2020   grade_2 14 0 3   0 0     0   0   8 9                       17 14 0 3   0 0     0   0   8 9                 17
1802832 CO     school 803330 870   Delta County 50(J) 80333006667 6295 North Fork School of Integrated Studies   Regular School No Elementary KG 06 2020   grade_2 7 0 0   0 0     0   0   3 4                       7 7 0 0   0 0     0   0   3 4                 7
1802880 CO     school 803360 880   Denver County 1 80336000306 220 John H. Amesse Elementary   Regular School No Elementary PK 05 2020   grade_2 0 8 47   0 0     0   0   32 23                       55 0 8 47   0 0     0   0   32 23                 55
1802903 CO     school 803360 880   Denver County 1 80336000309 418 Ashley Elementary School   Regular School No Elementary PK 05 2020   grade_2 5 12 27   1 0     0   0   20 25                       45 5 12 27   1 0     0   0   20 25                 45
1802919 CO     school 803360 880   Denver County 1 80336000313 650 Beach Court Elementary School   Regular School No Elementary PK 05 2020   grade_2 2 0 36   0 0     0   0   22 16                       38 2 0 36   0 0     0   0   22 16                 38
1803005 CO     school 803360 880   Denver County 1 80336000325 1528 Cheltenham Elementary School   Regular School No Elementary PK 05 2020   grade_2 1 6 39   0 2     0   0   22 26                       48 1 6 39   0 2     0   0   22 26                 48
1803027 CO     school 803360 880   Denver County 1 80336000327 1774 Colfax Elementary School   Regular School No Elementary PK 05 2020   grade_2 6 3 25   0 0     0   0   19 15                       34 6 3 25   0 0     0   0   19 15                 34
1803043 CO     school 803360 880   Denver County 1 80336000328 1788 College View Elementary School   Regular School No Elementary PK 05 2020   grade_2 2 3 47   1 4     0   0   32 25                       57 2 3 47   1 4     0   0   32 25                 57
1803051 CO     school 803360 880   Denver County 1 80336000329 1816 Columbian Elementary School   Regular School No Elementary PK 05 2020   grade_2 5 3 24   0 0     0   0   19 13                       32 5 3 24   0 0     0   0   19 13                 32
1803351 CO     school 803360 880   Denver County 1 80336000354 3478 Godsman Elementary School   Regular School No Elementary PK 05 2020   grade_2 1 0 40   1 2     0   0   27 17                       44 1 0 40   1 2     0   0   27 17                 44
1803399 CO     school 803360 880   Denver County 1 80336001739 3647 Marie L. Greenwood Academy   Regular School No Elementary KG 08 2020   grade_2 1 5 48   0 0     0   0   32 22                       54 1 5 48   0 0     0   0   32 22                 54
1803441 CO     school 803360 880   Denver County 1 80336000362 3778 International Academy of Denver at Harrington   Regular School No Elementary PK 05 2020   grade_2 1 5 18   1 0     0   0   7 18                       25 1 5 18   1 0     0   0   7 18                 25
1803663 CO     school 803360 880   Denver County 1 80336006445 5608 Mathematics and Science Leadership Academy   Regular School No Elementary KG 05 2020   grade_2 0 0 21   0 1     0   0   12 10                       22 0 0 21   0 1     0   0   12 10                 22
1803752 CO     school 803360 880   Denver County 1 80336000387 6188 Munroe Elementary School   Regular School No Elementary PK 05 2020   grade_2 2 6 54   0 0     1   0   32 31                       63 2 6 54   0 0     1   0   32 31                 63
1803768 CO     school 803360 880   Denver County 1 80336000388 6254 Newlon Elementary School   Regular School No Elementary PK 05 2020   grade_2 3 1 46   0 1     0   0   26 25                       51 3 1 46   0 1     0   0   26 25                 51
1803799 CO     school 803360 880   Denver County 1 80336001750 6397 Academia Ana Marie Sandoval   Regular School No Elementary PK 06 2020   grade_2 18 0 35   2 0     0   0   26 29                       55 18 0 35   2 0     0   0   26 29                 55
1803900 CO     school 803360 880   Denver County 1 80336006641 7243 Reach Charter School   Regular School Yes Elementary PK 05 2020   grade_2 8 4 6   0 0     0   0   11 7                       18 8 4 6   0 0     0   0   11 7                 18
1803941 CO     school 803360 880   Denver County 1 80336000400 7694 Charles M. Schenck (CMS) Community School   Regular School No Elementary KG 05 2020   grade_2 1 1 51   0 1     0   0   26 28                       54 1 1 51   0 1     0   0   26 28                 54
1804166 CO     school 803360 880   Denver County 1 80336000424 9496 Castro Elementary School   Regular School No Elementary KG 05 2020   grade_2 6 4 43   0 3     0   0   29 27                       56 6 4 43   0 3     0   0   29 27                 56
1804224 CO     school 803360 880   Denver County 1 80336001637 9739 Wyatt Academy   Regular School Yes Elementary KG 05 2020   grade_2 3 6 17   0 0     0   0   10 16                       26 3 6 17   0 0     0   0   10 16                 26
1804239 CO     school 803420 890   Dolores County RE No.2 80342000435 7764 Seventh Street Elementary School   Regular School No Elementary PK 05 2020   grade_2 15 0 1   0 0     0   0   10 6                       16 15 0 1   0 0     0   0   10 6                 16
1804444 CO     school 803450 900   Douglas County Re 1 80345001526 1925 Cougar Run Elementary School   Regular School No Elementary KG 06 2020   grade_2 44 0 8   1 2     0   0   32 23                       55 44 0 8   1 2     0   0   32 23                 55
1804627 CO     school 803450 900   Douglas County Re 1 80345000441 4980 Larkspur Elementary School   Regular School No Elementary KG 06 2020   grade_2 24 0 4   0 0     0   0   12 16                       28 24 0 4   0 0     0   0   12 16                 28
1804938 CO     school 803450 900   Douglas County Re 1 80345001963 8853 Timber Trail Elementary School   Regular School No Elementary PK 05 2020   grade_2 44 0 6   0 0     0   0   28 22                       50 44 0 6   0 0     0   0   28 22                 50
1805018 CO     school 803540 910   Eagle County RE 50 80354000851 2340 Eagle County Charter Academy   Regular School Yes Elementary KG 08 2020   grade_2 34 0 3   0 1     0   0   20 18                       38 34 0 3   0 1     0   0   20 18                 38
1805063 CO     school 803540 910   Eagle County RE 50 80354006366 4838 June Creek Elementary School   Regular School No Elementary PK 05 2020   grade_2 3 0 23   0 0     0   0   14 12                       26 3 0 23   0 0     0   0   14 12                 26
1805072 CO     school 803540 910   Eagle County RE 50 80354001478 5742 Homestake Peak School   Regular School No Elementary PK 08 2020   grade_2 15 0 25   0 0     0   0   20 20                       40 15 0 25   0 0     0   0   20 20                 40
1805083 CO     school 803540 910   Eagle County RE 50 80354000468 7296 Red Sandstone Elementary School   Regular School No Elementary PK 05 2020   grade_2 35 0 6   0 0     0   0   21 20                       41 35 0 6   0 0     0   0   21 20                 41
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
1805186 CO     school 803690 950   Elbert 200 80369000480 2570 Elbert Elementary School   Regular School No Elementary PK 05 2020   grade_2 7 1 0   0 0     1   0   5 4                       9 7 1 0   0 0     1   0   5 4                 9
1805202 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   grade_2 3 0 1   0 0     0   0   4 0                       4 3 0 1   0 0     0   0   4 0                 4
1805216 CO     school 802730 970   Calhan RJ-1 80273000167 1210 Calhan Elementary School   Regular School No Elementary PK 05 2020   grade_2 17 4 4   0 0     0   0   13 12                       25 17 4 4   0 0     0   0   13 12                 25
1805300 CO     school 804530 980   Harrison 2 80453006663 5763 Mountain Vista Homeschool Academy   Regular School No Other KG 12 2020   grade_2 19 0 2   0 0     0   0   11 10                       21 19 0 2   0 0     0   0   11 10                 21
1805318 CO     school 804530 980   Harrison 2 80453001903 6162 Mountain Vista Community School   Regular School No Elementary PK 08 2020   grade_2 11 6 28   0 2     0   0   17 30                       47 11 6 28   0 2     0   0   17 30                 47
1805626 CO     school 803060 1010   Colorado Springs 11 80306000225 1126 Buena Vista Elementary School   Regular School No Elementary PK 08 2020   grade_2 23 0 10   0 0     0   0   15 18                       33 23 0 10   0 0     0   0   15 18                 33
1805888 CO     school 803060 1010   Colorado Springs 11 80306001274 7513 Rudy Elementary School   Regular School No Elementary PK 05 2020   grade_2 27 2 11   1 1     1   0   21 22                       43 27 2 11   1 1     1   0   21 22                 43

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