Data source: Big Local News · About: Big Local

1,101 rows where grade = "grade_3", state = "CO" and year = 2020 sorted by black

View and edit SQL

year

  • 2020 · 1,101

grade

  • grade_3 · 1,101
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
1799356 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_3 4 0 47   0 1     0   2   30 24                       54 4 0 47   0 1     0   2   30 24                 54
1799367 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_3 11 0 27   0 1     0   0   20 19                       39 11 0 27   0 1     0   0   20 19                 39
1799376 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_3 8 0 36   0 2     0   0   21 25                       46 8 0 36   0 2     0   0   21 25                 46
1799396 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_3 8 0 47   0 0     0   3   28 30                       58 8 0 47   0 0     0   3   28 30                 58
1799405 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_3 6 0 46   0 1     0   0   23 30                       53 6 0 46   0 1     0   0   23 30                 53
1799440 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2020   grade_3 3 0 44   0 0     0   2   26 23                       49 3 0 44   0 0     0   2   26 23                 49
1799474 CO     school 806900 20   Adams 12 Five Star Schools 80690001733 59 Meridian Elementary School   Regular School No Elementary KG 05 2020   grade_3 75 0 14   0 8     0   9   58 48                       106 75 0 14   0 8     0   9   58 48                 106
1799490 CO     school 806900 20   Adams 12 Five Star Schools 80690001619 301 Arapahoe Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_3 37 0 38   0 3     0   3   39 42                       81 37 0 38   0 3     0   3   39 42                 81
1799498 CO     school 806900 20   Adams 12 Five Star Schools 80690001173 1388 Centennial Elementary School   Regular School No Elementary PK 05 2020   grade_3 26 0 38   0 2     0   0   28 38                       66 26 0 38   0 2     0   0   28 38                 66
1799513 CO     school 806900 20   Adams 12 Five Star Schools 80690000728 1519 Stargate Charter School   Regular School Yes Other KG 12 2020   grade_3 58 0 11   0 26     0   5   49 51                       100 58 0 11   0 26     0   5   49 51                 100
1799524 CO     school 806900 20   Adams 12 Five Star Schools 80690001174 1878 Coronado Hills Elementary School   Regular School No Elementary PK 05 2020   grade_3 8 0 68   0 1     0   2   42 37                       79 8 0 68   0 1     0   2   42 37                 79
1799539 CO     school 806900 20   Adams 12 Five Star Schools 80690001668 1937 Coyote Ridge Elementary School   Regular School No Elementary KG 05 2020   grade_3 52 0 9   0 5     0   4   36 34                       70 52 0 9   0 5     0   4   36 34                 70
1799561 CO     school 806900 20   Adams 12 Five Star Schools 80690001290 2576 Cherry Drive Elementary School   Regular School No Elementary PK 05 2020   grade_3 25 0 22   0 0     0   0   28 19                       47 25 0 22   0 0     0   0   28 19                 47
1799569 CO     school 806900 20   Adams 12 Five Star Schools 80690001401 2578 Skyview Elementary School   Regular School No Elementary KG 05 2020   grade_3 46 0 32   1 3     0   1   47 36                       83 46 0 32   1 3     0   1   47 36                 83
1799599 CO     school 806900 20   Adams 12 Five Star Schools 80690001176 2918 Federal Heights Elementary School   Regular School No Elementary PK 05 2020   grade_3 4 0 70   0 0     0   1   36 39                       75 4 0 70   0 0     0   1   36 39                 75
1799679 CO     school 806900 20   Adams 12 Five Star Schools 80690001362 6150 Mountain View Elementary School   Regular School No Elementary PK 05 2020   grade_3 60 0 22   1 7     0   8   62 36                       98 60 0 22   1 7     0   8   62 36                 98
1799691 CO     school 806900 20   Adams 12 Five Star Schools 80690001184 6355 North Mor Elementary School   Regular School No Elementary PK 05 2020   grade_3 20 0 38   0 3     1   1   31 32                       63 20 0 38   0 3     1   1   31 32                 63
1799745 CO     school 806900 20   Adams 12 Five Star Schools 80690002028 7795 Silver Creek Elementary   Regular School No Elementary KG 05 2020   grade_3 64 0 23   0 14     0   2   51 52                       103 64 0 23   0 14     0   2   51 52                 103
1799794 CO     school 806900 20   Adams 12 Five Star Schools 80690006740 8814 Thunder Vista P-8   Regular School No Elementary PK 08 2020   grade_3 62 0 10   0 3     0   3   35 43                       78 62 0 10   0 3     0   3   35 43                 78
1799816 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   grade_3 25 0 11   0 1     0   3   21 19                       40 25 0 11   0 1     0   3   21 19                 40
1799839 CO     school 806900 20   Adams 12 Five Star Schools 80690001196 9682 Woodglen Elementary School   Regular School No Elementary PK 05 2020   grade_3 40 0 27   1 1     1   5   38 37                       75 40 0 27   1 1     1   5   38 37                 75
1799877 CO     school 801950 30   Adams County 14 80195000013 2308 Dupont Elementary School   Regular School No Elementary KG 05 2020   grade_3 7 0 66   0 0     0   1   44 30                       74 7 0 66   0 0     0   1   44 30                 74
1799905 CO     school 801950 30   Adams County 14 80195000018 6534 Hanson Elementary School   Regular School No Elementary PK 05 2020   grade_3 1 0 33   0 0     0   0   17 17                       34 1 0 33   0 0     0   0   17 17                 34
1799913 CO     school 801950 30   Adams County 14 80195000019 7500 Rose Hill Elementary School   Regular School No Elementary PK 05 2020   grade_3 5 0 41   0 0     0   0   25 21                       46 5 0 41   0 0     0   0   25 21                 46
1799931 CO     school 802580 40   School District 27J 80258006549 1013 Brantner Elementary School   Regular School No Elementary PK 05 2020   grade_3 62 0 32   1 10     0   4   52 57                       109 62 0 32   1 10     0   4   52 57                 109
1799951 CO     school 802580 40   School District 27J 80258001729 1052 Bromley East Charter School   Regular School Yes Elementary PK 08 2020   grade_3 68 0 51   1 2     0   5   64 63                       127 68 0 51   1 2     0   5   64 63                 127
1799966 CO     school 802580 40   School District 27J 80258006465 2945 Foundations Academy   Regular School Yes Elementary KG 08 2020   grade_3 58 0 22   1 1     1   3   39 47                       86 58 0 22   1 1     1   3   39 47                 86
1800002 CO     school 802580 40   School District 27J 80258000148 6294 North Elementary School   Regular School No Elementary PK 05 2020   grade_3 7 0 28   1 2     0   1   22 17                       39 7 0 28   1 2     0   1   22 17                 39
1800111 CO     school 802430 50   Bennett 29J 80243000091 770 Bennett Elementary School   Regular School No Elementary KG 03 2020   grade_3 44 0 19   0 0     0   6   37 32                       69 44 0 19   0 0     0   6   37 32                 69
1800147 CO     school 807230 70   Westminster Public Schools 80723001232 1622 Metropolitan Arts Academy   Regular School No Elementary PK 06 2020   grade_3 1 0 27   0 1     2   0   14 17                       31 1 0 27   0 1     2   0   14 17                 31
1800156 CO     school 807230 70   Westminster Public Schools 80723001235 2876 Fairview Elementary School   Regular School No Elementary PK 05 2020   grade_3 4 0 52   0 4     0   1   27 34                       61 4 0 52   0 4     0   1   27 34                 61
1800164 CO     school 807230 70   Westminster Public Schools 80723001236 3144 Francis M. Day Elementary School   Regular School No Elementary PK 05 2020   grade_3 2 0 40   0 0     0   0   23 19                       42 2 0 40   0 0     0   0   23 19                 42
1800187 CO     school 807230 70   Westminster Public Schools 80723006567 4334 Colorado STEM Academy   Regular School No Elementary PK 08 2020   grade_3 13 0 21   0 2     0   0   19 17                       36 13 0 21   0 2     0   0   19 17                 36
1800223 CO     school 807230 70   Westminster Public Schools 80723001363 7810 John E. Flynn A Marzano Academy   Regular School No Elementary PK 06 2020   grade_3 9 0 27   0 2     0   1   18 21                       39 9 0 27   0 2     0   1   18 21                 39
1800236 CO     school 807230 70   Westminster Public Schools 80723001246 7860 Sherrelwood Elementary School   Regular School No Elementary PK 05 2020   grade_3 3 0 37   0 0     0   1   19 22                       41 3 0 37   0 0     0   1   19 22                 41
1800244 CO     school 807230 70   Westminster Public Schools 80723001247 7952 Skyline Vista Elementary School   Regular School No Elementary PK 05 2020   grade_3 6 0 40   0 3     0   0   19 30                       49 6 0 40   0 3     0   0   19 30                 49
1800252 CO     school 807230 70   Westminster Public Schools 80723001248 8406 Sunset Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_3 9 0 32   1 1     1   1   21 24                       45 9 0 32   1 1     1   1   21 24                 45
1800310 CO     school 806420 110   Sangre De Cristo Re-22J 80642001115 7626 Sangre de Cristo Elementary School   Regular School No Elementary PK 05 2020   grade_3 18 0 2   1 0     0   0   11 10                       21 18 0 2   1 0     0   0   11 10                 21
1800339 CO     school 803780 120   Englewood 1 80378000488 1556 Cherrelyn Elementary School   Regular School No Elementary KG 06 2020   grade_3 18 0 10   0 2     0   2   19 13                       32 18 0 10   0 2     0   2   19 13                 32
1800522 CO     school 802910 130   Cherry Creek 5 80291001273 1572 High Plains Elementary School   Regular School No Elementary PK 05 2020   grade_3 69 0 16   0 10     1   6   51 51                       102 69 0 16   0 10     1   6   51 51                 102
1800529 CO     school 802910 130   Cherry Creek 5 80291000187 1574 Cherry Hills Village Elementary School   Regular School No Elementary PK 05 2020   grade_3 81 0 4   0 3     0   7   56 39                       95 81 0 4   0 3     0   7   56 39                 95
1800631 CO     school 802910 130   Cherry Creek 5 80291000195 4078 Homestead Elementary School   Regular School No Elementary PK 05 2020   grade_3 55 0 12   1 6     0   10   42 42                       84 55 0 12   1 6     0   10   42 42                 84
1800710 CO     school 802910 130   Cherry Creek 5 80291006563 6367 Options School   Alternative School No Other KG 12 2020   grade_3 45 0 9   0 1     0   6   33 28                       61 45 0 9   0 1     0   6   33 28                 61
1800857 CO     school 805310 140   Littleton 6 80531000878 752 Franklin Elementary School   Regular School No Elementary KG 05 2020   grade_3 84 0 17   0 1     0   5   56 51                       107 84 0 17   0 1     0   5   56 51                 107
1800871 CO     school 805310 140   Littleton 6 80531000875 2382 East Elementary School   Regular School No Elementary KG 05 2020   grade_3 11 0 22   0 3     0   2   15 23                       38 11 0 22   0 3     0   2   15 23                 38
1800929 CO     school 805310 140   Littleton 6 80531001626 5233 Littleton Prep Charter School   Regular School Yes Elementary PK 08 2020   grade_3 50 0 10   0 0     0   4   29 35                       64 50 0 10   0 0     0   4   29 35                 64
1800940 CO     school 805310 140   Littleton 6 80531001300 5236 Lois Lenski Elementary School   Regular School No Elementary KG 05 2020   grade_3 85 0 5   0 2     0   5   49 48                       97 85 0 5   0 2     0   5   49 48                 97
1800947 CO     school 805310 140   Littleton 6 80531000883 5572 Hopkins Elementary School   Regular School No Elementary PK 05 2020   grade_3 36 0 10   0 1     0   2   22 27                       49 36 0 10   0 1     0   2   22 27                 49
1800964 CO     school 805310 140   Littleton 6 80531000887 6814 Peabody Elementary School   Regular School No Elementary PK 05 2020   grade_3 57 0 8   0 3     0   4   49 23                       72 57 0 8   0 3     0   4   49 23                 72
1800978 CO     school 805310 140   Littleton 6 80531000889 7606 Sandburg Elementary School   Regular School No Elementary KG 05 2020   grade_3 64 0 3   0 4     0   4   40 35                       75 64 0 3   0 4     0   4   40 35                 75
1800985 CO     school 805310 140   Littleton 6 80531000890 8064 Moody Elementary School   Regular School No Elementary PK 05 2020   grade_3 35 0 11   0 1     0   2   27 22                       49 35 0 11   0 1     0   2   27 22                 49
1801001 CO     school 803270 170   Deer Trail 26J 80327000287 2136 Deer Trail Elementary School   Regular School No Elementary PK 05 2020   grade_3 13 0 8   0 0     0   0   13 8                       21 13 0 8   0 0     0   0   13 8                 21
1801019 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2020   grade_3 0 0 1   0 1     0   0   1 1                       2 0 0 1   0 1     0   0   1 1                 2
1801505 CO     school 802700 190   Byers 32J 80270000163 1168 Byers Elementary School   Regular School No Elementary PK 06 2020   grade_3 28 0 6   0 0     0   0   20 14                       34 28 0 6   0 0     0   0   20 14                 34
1801579 CO     school 802190 220   Archuleta County 50 Jt 80219006717 6679 Pagosa Peak Open School   Regular School Yes Elementary KG 06 2020   grade_3 7 0 1   0 1     0   2   7 4                       11 7 0 1   0 1     0   2   7 4                 11
1801587 CO     school 807110 230   Walsh RE-1 80711001215 9222 Walsh Elementary School   Regular School No Elementary PK 06 2020   grade_3 7 0 1   0 0     0   2   5 5                       10 7 0 1   0 0     0   2   5 5                 10
1801603 CO     school 806090 240   Pritchett RE-3 80609001026 7174 Pritchett Elementary School   Regular School No Elementary PK 05 2020   grade_3 1 0 1   0 0     0   0   1 1                       2 1 0 1   0 0     0   0   1 1                 2
1801620 CO     school 806630 250   Springfield RE-4 80663001141 8160 Springfield Elementary School   Regular School No Elementary PK 05 2020   grade_3 14 0 5   0 0     0   1   13 7                       20 14 0 5   0 0     0   1   13 7                 20
1801636 CO     school 806990 260   Vilas RE-5 80699001206 9090 Vilas Elementary School   Regular School No Elementary PK 06 2020   grade_3 5 0 2   0 0     0   1   1 7                       8 5 0 2   0 0     0   1   1 7                 8
1801652 CO     school 802760 270   Campo RE-6 80276000169 1248 Campo Elementary School   Regular School No Elementary PK 05 2020   grade_3 2 0 0   0 0     0   1   2 1                       3 2 0 0   0 0     0   1   2 1                 3
1801675 CO     school 805250 290   Las Animas RE-1 80525000866 1812 Las Animas Elementary School   Regular School No Elementary KG 06 2020   grade_3 16 0 13   3 0     0   0   12 20                       32 16 0 13   3 0     0   0   12 20                 32
1801732 CO     school 805370 470   St Vrain Valley RE1J 80537006530 71 Aspen Ridge Preparatory School   Regular School Yes Elementary KG 08 2020   grade_3 46 0 4   0 6     0   0   30 26                       56 46 0 4   0 6     0   0   30 26                 56
1801746 CO     school 805370 470   St Vrain Valley RE1J 80537006539 120 Apex Home School Enrichment Program   Regular School No Other KG 12 2020   grade_3 76 0 12   1 2     0   3   47 47                       94 76 0 12   1 2     0   3   47 47                 94
1801769 CO     school 805370 470   St Vrain Valley RE1J 80537006381 878 Blue Mountain Elementary   Regular School No Elementary PK 05 2020   grade_3 85 0 4   0 9     0   6   58 46                       104 85 0 4   0 9     0   6   58 46                 104
1801785 CO     school 805370 470   St Vrain Valley RE1J 80537006397 1245 Centennial Elementary   Regular School No Elementary PK 05 2020   grade_3 65 0 26   0 5     1   4   54 47                       101 65 0 26   0 5     1   4   54 47                 101
1801803 CO     school 805370 470   St Vrain Valley RE1J 80537000897 1434 Central Elementary School   Regular School No Elementary PK 05 2020   grade_3 56 0 12   0 0     0   3   37 34                       71 56 0 12   0 0     0   3   37 34                 71
1801819 CO     school 805370 470   St Vrain Valley RE1J 80537001675 2343 Eagle Crest Elementary School   Regular School No Elementary PK 05 2020   grade_3 59 0 20   1 6     0   3   37 52                       89 59 0 20   1 6     0   3   37 52                 89
1801827 CO     school 805370 470   St Vrain Valley RE1J 80537000899 2758 Erie Elementary School   Regular School No Elementary PK 05 2020   grade_3 41 0 10   1 0     0   2   32 22                       54 41 0 10   1 0     0   2   32 22                 54
1801864 CO     school 805370 470   St Vrain Valley RE1J 80537000901 3192 Thunder Valley PK-8   Regular School No Elementary PK 08 2020   grade_3 35 0 42   0 0     0   5   34 48                       82 35 0 42   0 0     0   5   34 48                 82
1801883 CO     school 805370 470   St Vrain Valley RE1J 80537006757 3473 Grand View Elementary   Regular School No Elementary PK 05 2020   grade_3 30 0 13   0 5     0   3   28 23                       51 30 0 13   0 5     0   3   28 23                 51
1801891 CO     school 805370 470   St Vrain Valley RE1J 80537000903 4202 Hygiene Elementary School   Regular School No Elementary PK 05 2020   grade_3 38 0 8   0 0     0   0   26 20                       46 38 0 8   0 0     0   0   26 20                 46
1801899 CO     school 805370 470   St Vrain Valley RE1J 80537000904 4278 Indian Peaks Elementary School   Regular School No Elementary PK 05 2020   grade_3 7 0 35   0 1     0   0   25 18                       43 7 0 35   0 1     0   0   25 18                 43
1801907 CO     school 805370 470   St Vrain Valley RE1J 80537006388 4333 Imagine Charter   Regular School Yes Elementary PK 08 2020   grade_3 58 0 17   0 0     0   1   36 40                       76 58 0 17   0 0     0   1   36 40                 76
1801931 CO     school 805370 470   St Vrain Valley RE1J 80537000907 5284 Longmont Estates Elementary School   Regular School No Elementary PK 05 2020   grade_3 33 0 12   1 2     0   0   27 21                       48 33 0 12   1 2     0   0   27 21                 48
1801948 CO     school 805370 470   St Vrain Valley RE1J 80537000911 5364 Lyons Elementary School   Regular School No Elementary PK 05 2020   grade_3 42 0 3   0 1     0   2   23 25                       48 42 0 3   0 1     0   2   23 25                 48
1801969 CO     school 805370 470   St Vrain Valley RE1J 80537000914 5726 Mead Elementary School   Regular School No Elementary PK 05 2020   grade_3 68 0 18   2 1     0   5   46 48                       94 68 0 18   2 1     0   5   46 48                 94
1801992 CO     school 805370 470   St Vrain Valley RE1J 80537000916 6156 Mountain View Elementary School   Regular School No Elementary PK 04 2020   grade_3 22 0 28   1 0     0   3   30 24                       54 22 0 28   1 0     0   3   30 24                 54
1801999 CO     school 805370 470   St Vrain Valley RE1J 80537000917 6274 Niwot Elementary School   Regular School No Elementary PK 05 2020   grade_3 70 0 3   0 1     0   2   38 38                       76 70 0 3   0 1     0   2   38 38                 76
1802012 CO     school 805370 470   St Vrain Valley RE1J 80537000920 6404 Northridge Elementary School   Regular School No Elementary PK 05 2020   grade_3 2 0 50   0 0     0   1   26 27                       53 2 0 50   0 0     0   1   26 27                 53
1802024 CO     school 805370 470   St Vrain Valley RE1J 80537001794 7157 Prairie Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_3 54 0 21   0 4     0   6   44 41                       85 54 0 21   0 4     0   6   44 41                 85
1802031 CO     school 805370 470   St Vrain Valley RE1J 80537000921 7464 Rocky Mountain Elementary School   Regular School No Elementary PK 05 2020   grade_3 4 0 47   0 0     0   0   30 21                       51 4 0 47   0 0     0   0   30 21                 51
1802041 CO     school 805370 470   St Vrain Valley RE1J 80537006430 7565 St. Vrain Community Montessori School   Regular School Yes Elementary PK 08 2020   grade_3 28 0 1   0 0     0   1   16 14                       30 28 0 1   0 0     0   1   16 14                 30
1802053 CO     school 805370 470   St Vrain Valley RE1J 80537001396 7584 Sanborn Elementary School   Regular School No Elementary PK 05 2020   grade_3 32 0 20   0 2     0   2   34 22                       56 32 0 20   0 2     0   2   34 22                 56
1802125 CO     school 802490 480   Boulder Valley Re 2 80249000099 652 Bear Creek Elementary School   Regular School No Elementary KG 05 2020   grade_3 52 0 5   0 7     0   5   38 31                       69 52 0 5   0 7     0   5   38 31                 69
1802132 CO     school 802490 480   Boulder Valley Re 2 80249000100 872 Birch Elementary School   Regular School No Elementary PK 05 2020   grade_3 46 0 7   0 3     0   1   25 32                       57 46 0 7   0 3     0   1   25 32                 57
1802140 CO     school 802490 480   Boulder Valley Re 2 80249001630 919 Boulder Community School/Integrated Studies   Regular School No Elementary KG 05 2020   grade_3 44 0 2   0 1     0   5   26 26                       52 44 0 2   0 1     0   5   26 26                 52
1802192 CO     school 802490 480   Boulder Valley Re 2 80249001376 1725 Coal Creek Elementary School   Regular School No Elementary KG 05 2020   grade_3 56 0 8   0 4     0   4   31 41                       72 56 0 8   0 4     0   4   31 41                 72
1802199 CO     school 802490 480   Boulder Valley Re 2 80249000109 1842 Columbine Elementary School   Regular School No Elementary PK 05 2020   grade_3 36 0 36   0 0     0   8   38 42                       80 36 0 36   0 0     0   8   38 42                 80
1802230 CO     school 802490 480   Boulder Valley Re 2 80249000112 2552 Eisenhower Elementary School   Regular School No Elementary KG 05 2020   grade_3 63 0 10   0 4     0   4   40 41                       81 63 0 10   0 4     0   4   40 41                 81
1802237 CO     school 802490 480   Boulder Valley Re 2 80249001771 2589 Eldorado K-8 School   Regular School No Elementary PK 08 2020   grade_3 46 0 6   0 8     0   3   34 29                       63 46 0 6   0 8     0   3   34 29                 63
1802272 CO     school 802490 480   Boulder Valley Re 2 80249006154 2940 Fireside Elementary School   Regular School No Elementary PK 05 2020   grade_3 63 0 7   0 3     0   5   32 46                       78 63 0 7   0 3     0   5   32 46                 78
1802287 CO     school 802490 480   Boulder Valley Re 2 80249000116 3022 Foothill Elementary School   Regular School No Elementary KG 05 2020   grade_3 71 0 11   0 2     0   5   43 46                       89 71 0 11   0 2     0   5   43 46                 89
1802294 CO     school 802490 480   Boulder Valley Re 2 80249000117 3488 Gold Hill Elementary School   Regular School No Elementary KG 05 2020   grade_3 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
1802315 CO     school 802490 480   Boulder Valley Re 2 80249000119 4386 Jamestown Elementary School   Regular School No Elementary KG 05 2020   grade_3 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
1802338 CO     school 802490 480   Boulder Valley Re 2 80249000121 4874 Lafayette Elementary School   Regular School No Elementary PK 05 2020   grade_3 69 0 8   0 6     0   6   50 39                       89 69 0 8   0 6     0   6   50 39                 89
1802350 CO     school 802490 480   Boulder Valley Re 2 80249000124 5302 Louisville Elementary School   Regular School No Elementary KG 05 2020   grade_3 75 0 12   0 2     0   5   49 45                       94 75 0 12   0 2     0   5   49 45                 94
1802361 CO     school 802490 480   Boulder Valley Re 2 80249000128 5606 Creekside Elementary School at Martin Park   Regular School No Elementary PK 05 2020   grade_3 30 0 9   1 7     0   6   28 25                       53 30 0 9   1 7     0   6   28 25                 53
1802371 CO     school 802490 480   Boulder Valley Re 2 80249000129 5838 Mesa Elementary School   Regular School No Elementary KG 05 2020   grade_3 38 0 4   0 1     0   1   20 24                       44 38 0 4   0 1     0   1   20 24                 44
1802399 CO     school 802490 480   Boulder Valley Re 2 80249000130 6208 Nederland Elementary School   Regular School No Elementary PK 05 2020   grade_3 41 0 1   0 0     0   2   26 18                       44 41 0 1   0 0     0   2   26 18                 44
1802419 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2020   grade_3 31 0 4   0 0     0   3   17 21                       38 31 0 4   0 0     0   3   17 21                 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]);