Data source: Big Local News · About: Big Local

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

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
1799341 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_2 7 2 30   0 0     0   2   28 13                       41 7 2 30   0 0     0   2   28 13                 41
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
1799386 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Elementary   Regular School No Elementary PK 06 2020   grade_2 12 1 35   0 0     1   4   31 22                       53 12 1 35   0 0     1   4   31 22                 53
1799395 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_2 6 1 33   0 0     0   1   15 26                       41 6 1 33   0 0     0   1   15 26                 41
1799422 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   grade_2 35 2 21   1 0     0   4   36 27                       63 35 2 21   1 0     0   4   36 27                 63
1799439 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2020   grade_2 4 1 47   0 0     0   2   25 29                       54 4 1 47   0 0     0   2   25 29                 54
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
1799497 CO     school 806900 20   Adams 12 Five Star Schools 80690001173 1388 Centennial Elementary School   Regular School No Elementary PK 05 2020   grade_2 29 1 42   0 0     0   1   46 27                       73 29 1 42   0 0     0   1   46 27                 73
1799598 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2020   grade_2 3 0 64   0 0     0   1   33 35                       68 3 0 64   0 0     0   1   33 35                 68
1799698 CO     school 806900 20   Adams 12 Five Star Schools 80690001185 6376 North Star Elementary School   Regular School No Elementary PK 05 2020   grade_2 7 3 44   1 0     0   3   31 27                       58 7 3 44   1 0     0   3   31 27                 58
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
1799862 CO     school 801950 30   Adams County 14 80195000011 186 Alsup Elementary School   Regular School No Elementary KG 05 2020   grade_2 3 1 52   0 0     1   1   33 25                       58 3 1 52   0 0     1   1   33 25                 58
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
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
1799993 CO     school 802580 40   School District 27J 80258001949 5615 Mary E Pennock Elementary School   Regular School No Elementary PK 05 2020   grade_2 45 0 46   0 0     0   2   53 40                       93 45 0 46   0 0     0   2   53 40                 93
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
1800076 CO     school 802580 40   School District 27J 80258000151 8130 Southeast Elementary School   Regular School No Elementary PK 05 2020   grade_2 22 0 43   0 0     0   1   38 28                       66 22 0 43   0 0     0   1   38 28                 66
1800110 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2020   grade_2 37 0 27   0 0     1   4   36 33                       69 37 0 27   0 0     1   4   36 33                 69
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
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
1800267 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2020   grade_2 6 0 28   0 0     0   3   16 21                       37 6 0 28   0 0     0   3   16 21                 37
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
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
1800330 CO     school 803780 120   Englewood 1 80378000486 1514 Charles Hay World School   Regular School No Elementary KG 06 2020   grade_2 35 4 13   0 0     0   3   26 29                       55 35 4 13   0 0     0   3   26 29                 55
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
1800856 CO     school 805310 140   Littleton 6 80531000878 752 Franklin Elementary School   Regular School No Elementary KG 05 2020   grade_2 77 1 9   0 0     1   2   45 45                       90 77 1 9   0 0     1   2   45 45                 90
1800863 CO     school 805310 140   Littleton 6 80531000874 1382 Centennial Academy of Fine Arts Education   Regular School No Elementary KG 05 2020   grade_2 48 0 27   0 0     0   9   46 38                       84 48 0 27   0 0     0   9   46 38                 84
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
1800928 CO     school 805310 140   Littleton 6 80531001626 5233 Littleton Prep Charter School   Regular School Yes Elementary PK 08 2020   grade_2 41 0 15   0 0     0   2   30 28                       58 41 0 15   0 0     0   2   30 28                 58
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
1801026 CO     school 802340 180   Adams-Arapahoe 28J 80234006771 122 Aurora Community School   Regular School Yes Elementary KG 06 2020   grade_2 2 9 7   0 0     0   2   7 13                       20 2 9 7   0 0     0   2   7 13                 20
1801045 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_2 9 7 20   0 0     2   4   23 19                       42 9 7 20   0 0     2   4   23 19                 42
1801121 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2020   grade_2 7 4 28   0 0     0   3   21 21                       42 7 4 28   0 0     0   3   21 21                 42
1801187 CO     school 802340 180   Adams-Arapahoe 28J 80234000062 3272 Fulton Academy of Excellence   Regular School No Elementary PK 05 2020   grade_2 4 8 41   2 0     0   3   30 28                       58 4 8 41   2 0     0   3   30 28                 58
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
1801469 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_2 10 34 24   0 0     0   3   30 41                       71 10 34 24   0 0     0   3   30 41                 71
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
1801619 CO     school 806630 250   Springfield RE-4 80663001141 8160 Springfield Elementary School   Regular School No Elementary PK 05 2020   grade_2 21 0 3   0 0     0   1   16 9                       25 21 0 3   0 0     0   1   16 9                 25
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
1801651 CO     school 802760 270   Campo RE-6 80276000169 1248 Campo Elementary School   Regular School No Elementary PK 05 2020   grade_2 1 0 1   0 0     0   2   2 2                       4 1 0 1   0 0     0   2   2 2                 4
1801674 CO     school 805250 290   Las Animas RE-1 80525000866 1812 Las Animas Elementary School   Regular School No Elementary KG 06 2020   grade_2 16 0 10   0 0     0   2   10 18                       28 16 0 10   0 0     0   2   10 18                 28
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
1801745 CO     school 805370 470   St Vrain Valley RE1J 80537006539 120 Apex Home School Enrichment Program   Regular School No Other KG 12 2020   grade_2 67 1 6   0 0     0   4   41 37                       78 67 1 6   0 0     0   4   41 37                 78
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
1801802 CO     school 805370 470   St Vrain Valley RE1J 80537000897 1434 Central Elementary School   Regular School No Elementary PK 05 2020   grade_2 42 1 8   0 0     0   2   24 29                       53 42 1 8   0 0     0   2   24 29                 53
1801810 CO     school 805370 470   St Vrain Valley RE1J 80537001373 1844 Columbine Elementary School   Regular School No Elementary PK 05 2020   grade_2 10 0 38   0 0     0   1   28 21                       49 10 0 38   0 0     0   1   28 21                 49
1801843 CO     school 805370 470   St Vrain Valley RE1J 80537001737 2912 Fall River Elementary School   Regular School No Elementary PK 05 2020   grade_2 63 0 19   0 0     0   2   44 40                       84 63 0 19   0 0     0   2   44 40                 84
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
1801991 CO     school 805370 470   St Vrain Valley RE1J 80537000916 6156 Mountain View Elementary School   Regular School No Elementary PK 04 2020   grade_2 18 0 29   0 0     0   1   25 23                       48 18 0 29   0 0     0   1   25 23                 48
1801998 CO     school 805370 470   St Vrain Valley RE1J 80537000917 6274 Niwot Elementary School   Regular School No Elementary PK 05 2020   grade_2 64 0 2   1 0     0   2   36 33                       69 64 0 2   1 0     0   2   36 33                 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
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
1802040 CO     school 805370 470   St Vrain Valley RE1J 80537006430 7565 St. Vrain Community Montessori School   Regular School Yes Elementary PK 08 2020   grade_2 25 0 2   0 0     0   2   16 13                       29 25 0 2   0 0     0   2   16 13                 29
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
1802221 CO     school 802490 480   Boulder Valley Re 2 80249000111 2240 Douglass Elementary School   Regular School No Elementary PK 05 2020   grade_2 58 0 3   1 0     0   6   38 30                       68 58 0 3   1 0     0   6   38 30                 68
1802293 CO     school 802490 480   Boulder Valley Re 2 80249000117 3488 Gold Hill Elementary School   Regular School No Elementary KG 05 2020   grade_2 3 0 0   0 0     0   1   3 1                       4 3 0 0   0 0     0   1   3 1                 4
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
1802329 CO     school 802490 480   Boulder Valley Re 2 80249000120 4792 Kohl Elementary School   Regular School No Elementary PK 05 2020   grade_2 46 0 6   0 0     0   2   29 25                       54 46 0 6   0 0     0   2   29 25                 54
1802398 CO     school 802490 480   Boulder Valley Re 2 80249000130 6208 Nederland Elementary School   Regular School No Elementary PK 05 2020   grade_2 36 0 3   0 0     0   2   16 25                       41 36 0 3   0 0     0   2   16 25                 41
1802442 CO     school 802490 480   Boulder Valley Re 2 80249006200 6962 Pioneer Bilingual Elementary School   Regular School No Elementary PK 05 2020   grade_2 26 1 43   0 0     0   2   31 41                       72 26 1 43   0 0     0   2   31 41                 72
1802481 CO     school 802490 480   Boulder Valley Re 2 80249000135 8978 University Hill Elementary School   Regular School No Elementary PK 05 2020   grade_2 22 1 46   1 0     0   2   36 36                       72 22 1 46   1 0     0   2   36 36                 72
1802512 CO     school 802640 490   Buena Vista R-31 80264000159 4306 Avery/Parsons Elementary School   Regular School No Elementary KG 05 2020   grade_2 64 2 12   0 0     0   1   35 44                       79 64 2 12   0 0     0   1   35 44                 79
1802534 CO     school 806330 500   Salida R-32 80633001108 5268 Longfellow Elementary School   Regular School No Elementary KG 04 2020   grade_2 68 0 8   0 0     0   3   39 40                       79 68 0 8   0 0     0   3   39 40                 79
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
1802708 CO     school 803210 770   Crowley County RE-1-J 80321001519 2054 Crowley County Elementary K-6   Regular School No Elementary KG 06 2020   grade_2 17 0 19   0 0     0   1   16 21                       37 17 0 19   0 0     0   1   16 21                 37
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
1802782 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2020   grade_2 27 0 3   0 0     0   3   16 17                       33 27 0 3   0 0     0   3   16 17                 33
1802801 CO     school 803330 870   Delta County 50(J) 80333000299 4124 Hotchkiss Elementary School   Regular School No Elementary PK 08 2020   grade_2 21 0 3   0 0     0   1   12 13                       25 21 0 3   0 0     0   1   12 13                 25
1802817 CO     school 803330 870   Delta County 50(J) 80333000293 4182 Cedaredge Elementary School   Regular School No Elementary PK 05 2020   grade_2 43 0 9   0 0     0   3   34 21                       55 43 0 9   0 0     0   3   34 21                 55
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
1802840 CO     school 803330 870   Delta County 50(J) 80333001337 6700 Paonia Elementary School   Regular School No Elementary PK 06 2020   grade_2 20 0 4   0 0     0   2   14 12                       26 20 0 4   0 0     0   2   14 12                 26
1802872 CO     school 803360 880   Denver County 1 80336006592 99 Academy 360   Regular School Yes Elementary PK 05 2020   grade_2 5 9 14   1 0     0   1   16 14                       30 5 9 14   1 0     0   1   16 14                 30
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
1802888 CO     school 803360 880   Denver County 1 80336000307 388 Asbury Elementary School   Regular School No Elementary KG 05 2020   grade_2 38 2 13   0 0     0   2   32 23                       55 38 2 13   0 0     0   2   32 23                 55
1802895 CO     school 803360 880   Denver County 1 80336000420 408 Valdez Elementary School   Regular School No Elementary PK 05 2020   grade_2 15 0 38   0 0     0   1   28 26                       54 15 0 38   0 0     0   1   28 26                 54
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
1802911 CO     school 803360 880   Denver County 1 80336000311 520 Barnum Elementary School   Regular School No Elementary PK 05 2020   grade_2 2 0 61   1 0     0   1   36 29                       65 2 0 61   1 0     0   1   36 29                 65
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

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