Data source: Big Local News · About: Big Local

1,108 rows where grade = "grade_5", state = "CO" and year = 2020 sorted by hispanic

View and edit SQL

year

  • 2020 · 1,108

grade

  • grade_5 · 1,108
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
1801654 CO     school 802760 270   Campo RE-6 80276000169 1248 Campo Elementary School   Regular School No Elementary PK 05 2020   grade_5 2 0 0   0 0     0   1   1 2                       3 2 0 0   0 0     0   1   1 2                 3
1801703 CO     school 805580 310   McClave Re-2 80558000962 5666 McClave Elementary School   Regular School No Elementary PK 06 2020   grade_5 23 0 0   0 0     0   0   14 9                       23 23 0 0   0 0     0   0   14 9                 23
1802153 CO     school 802490 480   Boulder Valley Re 2 80249006463 930 Boulder Universal   Regular School No Other KG 12 2020   grade_5 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1802282 CO     school 802490 480   Boulder Valley Re 2 80249000115 2970 Flatirons Elementary School   Regular School No Elementary KG 05 2020   grade_5 43 0 0   0 2     0   1   30 16                       46 43 0 0   0 2     0   1   30 16                 46
1802317 CO     school 802490 480   Boulder Valley Re 2 80249000119 4386 Jamestown Elementary School   Regular School No Elementary KG 05 2020   grade_5 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1802566 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2020   grade_5 14 0 0   0 0     0   0   9 5                       14 14 0 0   0 0     0   0   9 5                 14
1802585 CO     school 803000 540   Clear Creek RE-1 80300001999 3385 Georgetown Community School   Regular School Yes Elementary PK 06 2020   grade_5 9 0 0   0 0     0   0   9 0                       9 9 0 0   0 0     0   0   9 0                 9
1802835 CO     school 803330 870   Delta County 50(J) 80333006667 6295 North Fork School of Integrated Studies   Regular School No Elementary KG 06 2020   grade_5 3 0 0   1 0     0   0   4 0                       4 3 0 0   1 0     0   0   4 0                 4
1804409 CO     school 803450 900   Douglas County Re 1 80345000439 1578 Cherry Valley Elementary School   Regular School No Elementary KG 06 2020   grade_5 4 0 0   0 0     0   1   1 4                       5 4 0 0   0 0     0   1   1 4                 5
1805103 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_5 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1805172 CO     school 806600 940   Big Sandy 100J 80660001138 7914 Simla Elementary School   Regular School No Elementary PK 05 2020   grade_5 19 0 0   0 0     0   0   8 11                       19 19 0 0   0 0     0   0   8 11                 19
1805205 CO     school 801980 960   Agate 300 80198000020 44 Agate Elementary School   Regular School No Elementary PK 05 2020   grade_5 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1806360 CO     school 806060 1060   Peyton 23 Jt 80606006692 6626 Peyton Online Academy   Regular School No High 05 12 2020   grade_5 0 1 0   0 0     0   1   0 2                       2 0 1 0   0 0     0   1   0 2                 2
1807132 CO     school 804620 1380   Hinsdale County RE 1 80462001969 4899 Lake City Community School   Regular School No Other PK 12 2020   grade_5 6 0 0   1 0     0   0   5 2                       7 6 0 0   1 0     0   0   5 2                 7
1807489 CO     school 804800 1420   Jefferson County R-1 80480001500 2616 Elk Creek Elementary School   Regular School No Elementary PK 05 2020   grade_5 56 0 0   0 0     0   1   34 23                       57 56 0 0   0 0     0   1   34 23                 57
1807854 CO     school 804800 1420   Jefferson County R-1 80480000756 5892 Miller Special Education   Special Education School No Other PK 12 2020   grade_5 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
1808444 CO     school 806930 1440   Plainview RE-2 80693001198 6992 Plainview Elementary School   Regular School No Elementary PK 05 2020   grade_5 7 0 0   0 0     0   0   4 3                       7 7 0 0   0 0     0   0   4 3                 7
1808463 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2020   grade_5 9 0 0   0 0     0   0   3 6                       9 9 0 0   0 0     0   0   3 6                 9
1808971 CO     school 803990 1550   Poudre R-1 80399006334 7104 Polaris Expeditionary Learning School   Alternative School No Other KG 12 2020   grade_5 18 0 0   0 0     0   0   8 10                       18 18 0 0   0 0     0   0   8 10                 18
1809000 CO     school 803990 1550   Poudre R-1 80399006431 7198 PSD Global Academy   Regular School No Other KG 12 2020   grade_5 12 0 0   0 0     0   0   6 6                       12 12 0 0   0 0     0   0   6 6                 12
1809330 CO     school 803810 1570   Estes Park R-3 80381006426 2788 Estes Park Options School   Alternative School No Other KG 12 2020   grade_5 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
1809467 CO     school 804740 1780   Genoa-Hugo C113 80474000686 4162 Genoa-Hugo School   Regular School No Other PK 12 2020   grade_5 11 0 0   0 0     0   0   6 5                       11 11 0 0   0 0     0   0   6 5                 11
1809494 CO     school 804890 1810   Karval RE-23 80489000814 4502 Karval Elementary School   Regular School No Elementary PK 06 2020   grade_5 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
1809514 CO     school 806690 1828   Valley RE-1 80669001361 1220 Caliche Elementary School   Regular School No Elementary PK 06 2020   grade_5 15 0 0   0 0     0   1   8 8                       16 15 0 0   0 0     0   1   8 8                 16
1809756 CO     school 804350 2000   Mesa County Valley 51 80435000611 3350 Gateway School   Regular School No Other PK 12 2020   grade_5 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1809954 CO     school 803150 2010   Creede School District 80315000279 1966 Creede School   Regular School No Other PK 12 2020   grade_5 4 0 0   0 0     0   0   1 3                       4 4 0 0   0 0     0   0   1 3                 4
1809978 CO     school 805730 2020   Moffat County RE: No 1 80573000980 5656 Maybell School   Regular School No Elementary KG 06 2020   grade_5 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
1810060 CO     school 803090 2035   Montezuma-Cortez RE-1 80309000841 7082 Pleasant View Elementary School   Regular School No Elementary KG 05 2020   grade_5 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
1810142 CO     school 805790 2180   Montrose County RE-1J 80579006499 6262 Peak Virtual Academy   Regular School No Other KG 12 2020   grade_5 4 0 0   0 0     0   0   2 2                       4 4 0 0   0 0     0   0   2 2                 4
1810407 CO     school 805970 2580   Ouray R-1 80597001018 6596 Ouray Elementary School   Regular School No Elementary PK 06 2020   grade_5 11 0 0   0 0     0   0   7 4                       11 11 0 0   0 0     0   0   7 4                 11
1810458 CO     school 803840 2610   Park County RE-2 80384001695 3681 Guffey Charter School   Regular School Yes Elementary PK 08 2020   grade_5 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
1811157 CO     school 806660 2770   Steamboat Springs RE-2 80666001749 6363 North Routt Charter School   Regular School Yes Elementary KG 08 2020   grade_5 13 0 0   0 0     0   0   7 6                       13 13 0 0   0 0     0   0   7 6                 13
1812121 CO     school 804440 3148   Pawnee RE-12 80444000653 6812 Pawnee School PK-12   Regular School No Other PK 12 2020   grade_5 7 0 0   0 0     0   0   4 3                       7 7 0 0   0 0     0   0   4 3                 7
1812286 CO     school 800020 8001   Charter School Institute 80002006779 1387 Colorado Early Colleges Windsor   Regular School Yes Other KG 12 2020   grade_5 12 0 0   0 0     0   2   9 5                       14 12 0 0   0 0     0   2   9 5                 14
1812417 CO     school 800020 8001   Charter School Institute 80002006701 5423 Mountain Village Montessori Charter School   Regular School Yes Elementary PK 05 2020   grade_5 7 0 0   0 0     0   0   6 1                       7 7 0 0   0 0     0   0   6 1                 7
1812510 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2020   grade_5 7 0 0   0 0     0   0   2 5                       7 7 0 0   0 0     0   0   2 5                 7
1801020 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2020   grade_5 1 0 1   0 0     0   1   3 0                       3 1 0 1   0 0     0   1   3 0                 3
1801605 CO     school 806090 240   Pritchett RE-3 80609001026 7174 Pritchett Elementary School   Regular School No Elementary PK 05 2020   grade_5 3 0 1   0 0     0   0   3 1                       4 3 0 1   0 0     0   0   3 1                 4
1801950 CO     school 805370 470   St Vrain Valley RE1J 80537000911 5364 Lyons Elementary School   Regular School No Elementary PK 05 2020   grade_5 53 1 1   0 0     0   0   24 31                       55 53 1 1   0 0     0   0   24 31                 55
1802043 CO     school 805370 470   St Vrain Valley RE1J 80537006430 7565 St. Vrain Community Montessori School   Regular School Yes Elementary PK 08 2020   grade_5 13 0 1   0 0     0   0   10 4                       14 13 0 1   0 0     0   0   10 4                 14
1802401 CO     school 802490 480   Boulder Valley Re 2 80249000130 6208 Nederland Elementary School   Regular School No Elementary PK 05 2020   grade_5 38 0 1   0 2     0   3   19 25                       44 38 0 1   0 2     0   3   19 25                 44
1802518 CO     school 806330 500   Salida R-32 80633006500 1554 Crest Academy   Regular School No Middle 05 08 2020   grade_5 14 0 1   0 0     0   0   5 10                       15 14 0 1   0 0     0   0   5 10                 15
1802550 CO     school 805040 510   Kit Carson R-1 80504000827 4738 Kit Carson Elementary School   Regular School No Elementary PK 05 2020   grade_5 7 0 1   0 0     0   0   5 3                       8 7 0 1   0 0     0   0   5 3                 8
1802594 CO     school 803000 540   Clear Creek RE-1 80300000218 4212 Carlson Elementary School   Regular School No Elementary PK 06 2020   grade_5 20 0 1   1 1     0   2   11 14                       25 20 0 1   1 1     0   2   11 14                 25
1802608 CO     school 803000 540   Clear Creek RE-1 80300001332 4700 King-Murphy Elementary School   Regular School No Elementary PK 06 2020   grade_5 11 0 1   0 0     0   0   5 7                       12 11 0 1   0 0     0   0   5 7                 12
1802726 CO     school 807200 860   Custer County School District C-1 80720001226 2088 Custer County Elementary School   Regular School No Elementary PK 05 2020   grade_5 34 1 1   0 0     0   1   17 20                       37 34 1 1   0 0     0   1   17 20                 37
1803420 CO     school 803360 880   Denver County 1 80336006559 3698 Creativity Challenge Community   Regular School No Elementary KG 05 2020   grade_5 44 3 1   1 1     0   0   32 18                       50 44 3 1   1 1     0   0   32 18                 50
1804242 CO     school 803420 890   Dolores County RE No.2 80342000435 7764 Seventh Street Elementary School   Regular School No Elementary PK 05 2020   grade_5 14 0 1   0 0     0   0   10 5                       15 14 0 1   0 0     0   0   10 5                 15
1804630 CO     school 803450 900   Douglas County Re 1 80345000441 4980 Larkspur Elementary School   Regular School No Elementary KG 06 2020   grade_5 32 0 1   0 0     0   1   20 14                       34 32 0 1   0 0     0   1   20 14                 34
1805021 CO     school 803540 910   Eagle County RE 50 80354000851 2340 Eagle County Charter Academy   Regular School Yes Elementary KG 08 2020   grade_5 36 0 1   0 0     0   1   19 19                       38 36 0 1   0 0     0   1   19 19                 38
1805189 CO     school 803690 950   Elbert 200 80369000480 2570 Elbert Elementary School   Regular School No Elementary PK 05 2020   grade_5 15 0 1   0 0     0   0   5 11                       16 15 0 1   0 0     0   0   5 11                 16
1806062 CO     school 805490 1030   Manitou Springs 14 80549000948 9010 Ute Pass Elementary School   Regular School No Elementary PK 06 2020   grade_5 22 0 1   0 0     0   0   6 17                       23 22 0 1   0 0     0   0   6 17                 23
1807119 CO     school 804470 1360   Gunnison Watershed RE1J 80447001507 5577 Marble Charter School   Regular School Yes Other KG 10 2020   grade_5 4 0 1   0 0     0   0   4 1                       5 4 0 1   0 0     0   0   4 1                 5
1807381 CO     school 804800 1420   Jefferson County R-1 80480001649 1869 Compass Montessori - Wheat Ridge Charter School   Regular School Yes Elementary PK 06 2020   grade_5 28 0 1   0 1     0   3   17 16                       33 28 0 1   0 1     0   3   17 16                 33
1808035 CO     school 804800 1420   Jefferson County R-1 80480000777 7238 Ralston Elementary School   Regular School No Elementary KG 05 2020   grade_5 38 0 1   0 1     0   4   22 22                       44 38 0 1   0 1     0   4   22 22                 44
1808158 CO     school 804800 1420   Jefferson County R-1 80480006307 8036 Sobesky Academy   Special Education School No Other KG 12 2020   grade_5 3 0 1   0 0     0   0   4 0                       4 3 0 1   0 0     0   0   4 0                 4
1808478 CO     school 806510 1460   Hi-Plains R-23 80651001130 7746 Hi-Plains School District R-23   Regular School No Other PK 12 2020   grade_5 11 0 1   0 0     0   0   8 4                       12 11 0 1   0 0     0   0   8 4                 12
1808606 CO     school 803480 1520   Durango 9-R 80348000450 3050 Fort Lewis Mesa Elementary School   Regular School No Elementary PK 05 2020   grade_5 11 0 1   0 0     0   0   4 8                       12 11 0 1   0 0     0   0   4 8                 12
1808820 CO     school 803990 1550   Poudre R-1 80399006613 3242 Fort Collins Montessori School   Regular School Yes Elementary PK 06 2020   grade_5 11 0 1   0 0     0   0   5 7                       12 11 0 1   0 0     0   0   5 7                 12
1808930 CO     school 803990 1550   Poudre R-1 80399006573 5917 Mountain Sage Community School   Regular School Yes Elementary KG 08 2020   grade_5 29 0 1   0 0     0   2   12 20                       32 29 0 1   0 0     0   2   12 20                 32
1808958 CO     school 803990 1550   Poudre R-1 80399006564 7043 PSD Options School   Regular School No Elementary KG 08 2020   grade_5 30 1 1   0 1     0   0   19 14                       33 30 1 1   0 1     0   0   19 14                 33
1809205 CO     school 805400 1560   Thompson R2-J 80540006558 5121 LEAP School   Regular School No Other KG 12 2020   grade_5 17 0 1   0 0     0   1   9 10                       19 17 0 1   0 0     0   1   9 10                 19
1809438 CO     school 802520 1750   Branson Reorganized 82 80252000141 978 Branson School   Regular School No Other PK 12 2020   grade_5 4 0 1   0 0     0   0   2 3                       5 4 0 1   0 0     0   0   2 3                 5
1809449 CO     school 804980 1760   Kim Reorganized 88 80498000822 4690 Kim Elementary School   Regular School No Elementary PK 05 2020   grade_5 3 0 1   0 0     0   0   1 3                       4 3 0 1   0 0     0   0   1 3                 4
1809545 CO     school 803930 1850   Frenchman RE-3 80393000511 2980 Fleming Elementary School   Regular School No Elementary PK 06 2020   grade_5 17 0 1   0 0     0   0   8 10                       18 17 0 1   0 0     0   0   8 10                 18
1809576 CO     school 806030 1870   Plateau RE-5 80603001022 6834 Peetz Elementary School   Regular School No Elementary PK 06 2020   grade_5 10 0 1   0 0     0   0   6 5                       11 10 0 1   0 0     0   0   6 5                 11
1809595 CO     school 803240 1980   De Beque 49JT 80324000286 2126 De Beque PK-12 School District 49JT   Regular School No Other PK 12 2020   grade_5 5 0 1   0 0     0   1   5 2                       7 5 0 1   0 0     0   1   5 2                 7
1809735 CO     school 804350 2000   Mesa County Valley 51 80435001552 2724 New Emerson School at Columbus   Regular School No Elementary KG 05 2020   grade_5 20 0 1   0 0     0   1   12 10                       22 20 0 1   0 0     0   1   12 10                 22
1809779 CO     school 804350 2000   Mesa County Valley 51 80435006498 3604 Grand River Academy   Regular School No Other KG 12 2020   grade_5 1 0 1   0 0     0   1   2 1                       3 1 0 1   0 0     0   1   2 1                 3
1810004 CO     school 803090 2035   Montezuma-Cortez RE-1 80309001093 609 Battle Rock Charter School   Regular School Yes Elementary KG 06 2020   grade_5 5 1 1   1 0     0   1   3 6                       9 5 1 1   1 0     0   1   3 6                 9
1810016 CO     school 803090 2035   Montezuma-Cortez RE-1 80309006622 2036 Children's Kiva Montessori School   Regular School Yes Elementary KG 08 2020   grade_5 4 0 1   1 0     0   0   4 2                       6 4 0 1   1 0     0   0   4 2                 6
1810212 CO     school 805850 2190   West End RE-2 80585001693 6718 Paradox Valley Charter School   Regular School Yes Other PK 12 2020   grade_5 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1810280 CO     school 807140 2505   Weldon Valley RE-20(J) 80714001217 9352 Weldon Valley Elementary School   Regular School No Elementary PK 06 2020   grade_5 10 1 1   0 0     0   0   5 7                       12 10 1 1   0 0     0   0   5 7                 12
1810533 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2020   grade_5 14 0 1   0 0     0   1   8 8                       16 14 0 1   0 0     0   1   8 8                 16
1810910 CO     school 806150 2700   Pueblo County 70 80615006496 5990 70 Online   Alternative School No Other KG 12 2020   grade_5 4 0 1   0 0     0   0   0 5                       5 4 0 1   0 0     0   0   0 5                 5
1811232 CO     school 805700 2800   Moffat 2 80570001511 2018 Crestone Charter School   Regular School Yes Other KG 12 2020   grade_5 5 0 1   0 0     0   0   2 4                       6 5 0 1   0 0     0   0   2 4                 6
1811246 CO     school 805700 2800   Moffat 2 80570000974 5958 Moffat Prek-12 School   Regular School No Other PK 12 2020   grade_5 6 1 1   0 1     0   0   5 4                       9 6 1 1   0 1     0   0   5 4                 9
1811284 CO     school 806570 2820   Silverton 1 80657001136 7900 Silverton Elementary School   Regular School No Elementary PK 05 2020   grade_5 3 0 1   0 0     0   0   2 2                       4 3 0 1   0 0     0   0   2 2                 4
1811321 CO     school 805880 2840   Norwood R-2J 80588001012 6422 Norwood Public Schools   Regular School No Other PK 12 2020   grade_5 19 0 1   1 0     0   0   9 12                       21 19 0 1   1 0     0   0   9 12                 21
1811380 CO     school 806810 3000   Summit RE-1 80681001166 8372 Breckenridge Elementary School   Regular School No Elementary KG 05 2020   grade_5 38 1 1   0 0     0   1   24 17                       41 38 1 1   0 0     0   1   24 17                 41
1811548 CO     school 807410 3070   Woodlin R-104 80741001270 9700 Woodlin Elementary School   Regular School No Elementary PK 05 2020   grade_5 12 0 1   0 0     0   0   8 5                       13 12 0 1   0 0     0   0   8 5                 13
1812086 CO     school 802550 3146   Briggsdale RE-10 80255000142 1008 Briggsdale Elementary School   Regular School No Elementary PK 05 2020   grade_5 11 0 1   0 0     0   0   6 6                       12 11 0 1   0 0     0   0   6 6                 12
1812102 CO     school 806720 3147   Prairie RE-11 80672001157 7154 Prairie Elementary School   Regular School No Elementary PK 05 2020   grade_5 14 0 1   0 0     1   0   10 6                       16 14 0 1   0 0     1   0   10 6                 16
1812187 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2020   grade_5 8 0 1   0 0     0   0   6 3                       9 8 0 1   0 0     0   0   6 3                 9
1801748 CO     school 805370 470   St Vrain Valley RE1J 80537006539 120 Apex Home School Enrichment Program   Regular School No Other KG 12 2020   grade_5 66 1 10   1 1     0   5   44 40                       84 66 1 10   1 1     0   5   44 40                 84
1802250 CO     school 802490 480   Boulder Valley Re 2 80249006716 2639 Meadowlark School   Regular School No Elementary PK 08 2020   grade_5 51 0 10   0 7     0   3   39 32                       71 51 0 10   0 7     0   3   39 32                 71
1802434 CO     school 802490 480   Boulder Valley Re 2 80249001792 6816 Peak to Peak Charter School   Regular School Yes Other KG 12 2020   grade_5 56 1 10   0 9     0   2   44 34                       78 56 1 10   0 9     0   2   44 34                 78
1803699 CO     school 803360 880   Denver County 1 80336000377 5702 McKinley-Thatcher Elementary School   Regular School No Elementary PK 05 2020   grade_5 6 0 10   0 0     0   2   7 11                       18 6 0 10   0 0     0   2   7 11                 18
1804016 CO     school 803360 880   Denver County 1 80336001679 8138 Southmoor Elementary School   Regular School No Elementary PK 05 2020   grade_5 50 5 10   0 0     1   2   35 33                       68 50 5 10   0 0     1   2   35 33                 68
1804250 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2020   grade_5 61 0 10   0 2     0   5   34 44                       78 61 0 10   0 2     0   5   34 44                 78
1804638 CO     school 803450 900   Douglas County Re 1 80345001960 5045 Legacy Point Elementary School   Regular School No Elementary PK 05 2020   grade_5 40 0 10   0 1     0   1   23 29                       52 40 0 10   0 1     0   1   23 29                 52
1804783 CO     school 803450 900   Douglas County Re 1 80345001279 6938 Pine Grove Elementary School   Regular School No Elementary PK 06 2020   grade_5 61 1 10   1 1     0   7   38 43                       81 61 1 10   1 1     0   7   38 43                 81
1805520 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2020   grade_5 20 9 10   1 0     2   4   26 20                       46 20 9 10   1 0     2   4   26 20                 46
1806071 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2020   grade_5 52 1 10   0 2     0   10   38 37                       75 52 1 10   0 2     0   10   38 37                 75
1806186 CO     school 801920 1040   Academy 20 80192000003 2248 Douglass Valley Elementary School   Regular School No Elementary KG 05 2020   grade_5 23 4 10   0 0     0   4   19 22                       41 23 4 10   0 0     0   4   19 22                 41
1806463 CO     school 805820 1080   Lewis-Palmer 38 80582001397 6682 Palmer Lake Elementary School   Regular School No Elementary PK 06 2020   grade_5 32 0 10   0 0     0   0   23 19                       42 32 0 10   0 0     0   0   23 19                 42
1806809 CO     school 802790 1140   Canon City RE-1 80279000176 9248 Washington Elementary School   Regular School No Elementary KG 05 2020   grade_5 40 0 10   1 0     0   3   28 26                       54 40 0 10   1 0     0   3   28 26                 54
1807204 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2020   grade_5 25 1 10   0 5     0   3   23 21                       44 25 1 10   0 5     0   3   23 21                 44
1807235 CO     school 804800 1420   Jefferson County R-1 80480000692 148 Allendale Elementary School   Regular School No Elementary PK 05 2020   grade_5 15 1 10   1 0     0   3   18 12                       30 15 1 10   1 0     0   3   18 12                 30
1807529 CO     school 804800 1420   Jefferson County R-1 80480000722 2946 Fitzmorris Elementary School   Regular School No Elementary PK 05 2020   grade_5 8 0 10   0 0     0   0   15 3                       18 8 0 10   0 0     0   0   15 3                 18

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