Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

3,142 rows sorted by est2018_10to14

View and edit SQL

Suggested facets: centraloutlyingcounty

Link rowid statecountyfips geo_display est2018_all est2018_0to4 est2018_5to9 est2018_10to14 ▼ est2018_15to19 est2018_20to24 est2018_25to29 est2018_30to34 est2018_35to39 est2018_40to44 est2018_45to49 est2018_50to54 est2018_55to59 est2018_60to64 est2018_65to69 est2018_70to74 est2018_75to79 est2018_80to84 est2018_85plus cbsacode centraloutlyingcounty countyequivalent csatitle statename
2511 15005 Kalawao County, Hawaii 88 0 0 0 0 0 0 7 4 3 6 10 8 13 11 2 4 6 14 27980 Outlying Kalawao County   Hawaii
1031 48301 Loving County, Texas 152 11 17 11 17 10 14 13 13 2 2 7 7 13 7 5 3 0 0          
515 8079 Mineral County, Colorado 776 33 36 18 34 21 34 52 33 37 41 43 77 75 94 67 40 19 22          
444 35021 Harding County, New Mexico 655 25 27 20 22 20 24 30 33 23 20 38 53 73 68 63 29 32 55          
1039 2282 Yakutat City and Borough, Alaska 604 33 32 23 29 32 45 35 35 35 41 61 39 46 42 33 17 13 13          
794 31009 Blaine County, Nebraska 476 26 29 25 22 27 36 16 21 15 24 33 45 36 43 21 28 15 14          
1131 30103 Treasure County, Montana 679 55 41 25 29 26 28 38 38 22 17 40 54 72 53 55 33 30 23          
1202 30069 Petroleum County, Montana 513 19 31 25 30 29 15 26 21 22 29 40 44 54 31 23 39 19 16          
1104 48269 King County, Texas 277 13 24 26 11 11 17 14 23 7 19 22 17 24 14 9 8 13 5          
751 48243 Jeff Davis County, Texas 2252 35 27 29 109 78 101 112 94 112 150 137 213 270 257 225 145 69 89          
99 8111 San Juan County, Colorado 762 28 25 31 21 27 54 44 53 57 49 51 62 82 57 61 30 18 12          
128 28055 Issaquena County, Mississippi 1308 36 42 31 94 120 153 62 103 63 78 98 107 103 58 46 43 38 33          
1254 31115 Loup County, Nebraska 618 30 31 31 36 33 23 30 26 23 26 30 58 76 51 46 35 21 12          
688 2060 Bristol Bay Borough, Alaska 877 56 55 33 43 56 67 71 48 48 55 53 98 67 54 29 19 20 5          
681 8053 Hinsdale County, Colorado 811 32 36 34 47 39 32 42 29 45 32 54 60 83 72 88 43 21 22          
2107 31117 McPherson County, Nebraska 492 16 14 34 43 26 14 15 21 27 34 39 46 44 34 31 20 16 18 35820 Outlying McPherson County   Nebraska
576 31005 Arthur County, Nebraska 465 24 37 35 35 30 22 29 22 32 22 23 23 29 34 20 21 20 7          
728 31075 Grant County, Nebraska 660 56 47 37 33 22 30 42 40 37 19 35 64 49 53 35 34 21 6          
1098 48033 Borden County, Texas 648 33 35 38 35 29 20 27 34 33 65 48 47 44 42 35 25 31 27          
2843 48261 Kenedy County, Texas 442 17 37 39 49 23 18 32 27 17 30 28 24 32 11 27 11 7 13 28780 Outlying Kenedy County Corpus Christi-Kingsville-Alice, TX Texas
436 38087 Slope County, North Dakota 763 43 48 40 41 33 36 33 45 31 33 47 78 80 53 49 17 28 28          
877 48443 Terrell County, Texas 823 42 58 42 40 41 30 42 43 52 45 46 42 56 73 67 41 22 41          
1135 32009 Esmeralda County, Nevada 826 27 38 42 27 23 35 44 46 41 45 32 71 51 84 89 54 35 42          
834 31183 Wheeler County, Nebraska 805 47 48 43 33 42 32 38 33 41 37 47 67 89 57 46 37 36 32          
1326 2230 Skagway Municipality, Alaska 1148 61 56 43 31 39 100 115 130 94 81 79 68 84 71 37 32 18 9          
1492 31007 Banner County, Nebraska 730 49 51 43 39 38 41 29 50 24 25 41 60 66 63 51 25 18 17 42420 Outlying Banner County   Nebraska
573 38007 Billings County, North Dakota 919 69 45 46 37 35 51 71 69 47 46 63 66 68 65 48 28 32 33          
580 31085 Hayes County, Nebraska 916 68 62 46 39 55 45 40 45 35 24 39 80 86 69 55 38 43 47          
187 48311 McMullen County, Texas 749 33 36 47 38 40 56 39 35 32 51 58 44 60 40 43 36 32 29          
78 31171 Thomas County, Nebraska 720 43 50 48 42 26 33 44 28 39 43 39 36 62 71 41 33 21 21          
1028 48263 Kent County, Texas 726 37 42 49 41 25 21 38 44 23 42 49 52 66 40 50 43 34 30          
1089 31091 Hooker County, Nebraska 682 42 35 50 40 23 33 25 34 39 30 26 35 62 56 41 38 22 51          
1301 30079 Prairie County, Montana 1087 49 55 50 49 43 41 49 46 59 63 50 78 109 110 100 50 32 54          
2425 30037 Golden Valley County, Montana 826 43 46 52 56 31 36 32 52 37 35 51 66 65 87 47 38 26 26 13740 Outlying Golden Valley County   Montana
112 31103 Keya Paha County, Nebraska 810 33 45 53 36 34 33 22 44 37 29 42 76 75 55 63 41 52 40          
636 46021 Campbell County, South Dakota 1377 59 63 53 71 62 47 61 61 55 54 104 154 143 87 85 73 77 68          
265 30011 Carter County, Montana 1238 91 76 54 50 54 67 80 63 46 40 73 107 118 98 64 59 46 52          
409 41069 Wheeler County, Oregon 1366 67 50 54 64 43 54 60 56 55 65 81 100 142 135 108 113 60 59          
553 30109 Wibaux County, Montana 1034 64 65 55 62 50 40 48 69 49 45 71 81 84 85 51 43 39 33          
570 46075 Jones County, South Dakota 928 57 63 59 40 37 40 52 43 33 61 54 89 84 68 51 34 30 33          
122 16033 Clark County, Idaho 852 47 50 61 78 56 40 57 52 55 49 47 48 61 48 35 24 25 19          
366 38083 Sheridan County, North Dakota 1349 76 66 61 71 50 49 65 54 39 73 88 107 113 96 95 87 70 89          
1247 51091 Highland County, Virginia 2210 100 67 65 85 66 108 83 72 98 103 110 230 263 242 218 136 92 72          
637 46063 Harding County, South Dakota 1249 82 78 66 87 60 76 76 71 63 75 76 109 108 82 49 33 24 34          
795 49009 Daggett County, Utah 980 48 59 66 66 38 29 44 52 50 60 56 87 74 86 74 38 18 35          
1006 8057 Jackson County, Colorado 1399 69 62 67 61 55 85 79 76 97 81 99 117 140 111 71 61 35 33          
2268 31113 Logan County, Nebraska 749 48 43 68 49 26 27 30 50 51 36 35 59 58 59 36 35 17 22 35820 Outlying Logan County   Nebraska
529 6003 Alpine County, California 1101 44 36 69 70 60 55 54 36 47 63 70 114 103 115 78 36 28 23          
446 48155 Foard County, Texas 1200 45 77 70 75 63 50 59 57 47 69 97 97 78 79 73 68 49 47          
841 2013 Aleutians East Borough, Alaska 3515 83 85 70 88 289 309 255 296 448 377 399 288 204 107 119 47 23 28          
2225 31165 Sioux County, Nebraska 1187 45 54 70 74 65 39 45 61 60 50 65 110 110 109 63 57 48 62 42420 Outlying Sioux County   Nebraska
1167 8061 Kiowa County, Colorado 1383 109 78 72 75 86 71 64 68 70 64 66 131 105 100 65 55 48 56          
88 13265 Taliaferro County, Georgia 1608 66 91 73 65 81 89 84 80 95 84 123 130 124 130 110 70 44 69          
1231 48393 Roberts County, Texas 903 58 52 75 58 29 48 50 75 45 47 47 70 60 59 57 33 25 15          
204 30033 Garfield County, Montana 1268 74 85 78 64 68 59 57 103 64 69 66 78 108 99 70 64 40 22          
471 48345 Motley County, Texas 1234 58 56 84 76 59 55 65 48 50 77 52 96 84 123 84 75 46 46          
993 46069 Hyde County, South Dakota 1282 78 60 84 68 52 82 58 66 69 44 84 83 130 81 57 60 63 63          
1679 46119 Sully County, South Dakota 1392 78 83 84 71 53 65 74 75 72 63 90 112 124 124 76 55 40 53 38180 Outlying Sully County   South Dakota
923 41055 Sherman County, Oregon 1708 91 77 86 93 56 78 97 93 99 98 102 147 138 128 105 85 69 66          
812 48101 Cottle County, Texas 1389 75 84 89 97 56 60 75 84 68 63 79 115 106 96 83 75 42 42          
185 48433 Stonewall County, Texas 1362 79 72 90 89 52 75 43 85 55 75 88 96 102 93 94 62 46 66          
212 48045 Briscoe County, Texas 1516 65 85 90 82 76 69 92 82 96 84 97 111 90 102 112 74 62 47          
542 31149 Rock County, Nebraska 1360 81 65 90 56 62 48 76 74 68 55 45 122 155 133 71 53 43 63          
1067 30075 Powder River County, Montana 1716 76 66 90 92 86 94 65 85 80 78 113 161 164 157 112 71 56 70          
165 31057 Dundy County, Nebraska 1770 86 99 93 97 115 64 87 92 93 116 86 147 148 139 97 71 58 82          
903 48447 Throckmorton County, Texas 1515 73 82 93 82 62 67 61 87 67 75 108 121 112 116 99 86 69 55          
3055 16025 Camas County, Idaho 1127 55 77 93 57 37 35 49 76 78 67 61 88 101 91 76 43 14 29 25200 Outlying Camas County   Idaho
2900 26083 Keweenaw County, Michigan 2113 89 68 94 96 65 83 62 85 89 104 104 183 214 244 221 158 90 64 26340 Outlying Keweenaw County   Michigan
2341 48235 Irion County, Texas 1522 84 94 95 93 74 92 95 67 80 95 86 124 116 95 87 76 28 41 41660 Outlying Irion County   Texas
89 30059 Meagher County, Montana 1866 98 112 96 84 71 78 81 88 89 99 90 135 172 202 157 89 54 71          
183 20071 Greeley County, Kansas 1227 72 106 96 73 45 58 86 86 58 37 70 97 89 70 49 40 36 59          
93 20199 Wallace County, Kansas 1503 119 94 97 107 74 71 81 74 62 59 87 117 111 99 84 48 47 72          
109 20101 Lane County, Kansas 1560 89 102 98 87 73 75 88 59 76 99 98 117 132 98 94 53 66 56          
1077 56027 Niobrara County, Wyoming 2388 133 116 98 119 134 153 163 159 135 154 117 141 226 179 118 93 98 52          
46 31015 Boyd County, Nebraska 1955 88 107 100 114 105 73 77 85 84 89 107 176 152 177 131 110 69 111          
687 41021 Gilliam County, Oregon 1894 86 121 100 96 85 62 84 118 81 92 102 149 191 155 133 85 65 89          
1284 30019 Daniels County, Montana 1747 90 117 100 90 65 87 100 94 83 81 89 125 163 132 98 68 71 94          
568 48431 Sterling County, Texas 1311 109 96 101 96 71 65 86 90 89 78 69 80 92 48 44 30 30 37          
2197 48173 Glasscock County, Texas 1388 90 104 101 104 88 83 84 97 88 95 77 88 78 73 47 40 32 19 13700 Outlying Glasscock County   Texas
968 30055 McCone County, Montana 1675 94 88 104 83 92 75 91 74 85 75 84 146 146 140 94 84 69 51          
417 38091 Steele County, North Dakota 1903 136 109 105 96 103 107 84 90 86 101 106 162 159 150 112 87 63 47          
1076 38033 Golden Valley County, North Dakota 1769 107 87 105 121 75 81 79 115 109 81 100 123 154 152 77 62 55 86          
629 29227 Worth County, Missouri 2040 108 119 107 125 97 106 106 96 93 95 136 170 177 132 109 93 79 92          
893 13239 Quitman County, Georgia 2279 118 96 107 130 80 93 109 80 97 120 148 156 234 212 198 135 92 74          
856 30045 Judith Basin County, Montana 1952 88 104 108 103 71 81 77 102 96 95 133 196 169 165 130 116 60 58          
7 35011 De Baca County, New Mexico 1781 86 130 109 115 75 68 86 107 68 82 90 144 124 156 131 80 57 73          
517 2068 Denali Borough, Alaska 2059 114 105 109 81 105 170 153 150 141 189 174 182 141 136 47 34 20 8          
438 31071 Garfield County, Nebraska 1987 95 79 111 122 119 77 92 77 105 84 106 163 186 144 132 93 100 102          
375 48137 Edwards County, Texas 1928 125 135 114 99 77 97 75 98 80 96 103 128 140 181 159 106 59 56          
493 20033 Comanche County, Kansas 1748 85 141 114 114 72 79 82 92 83 100 91 126 122 131 118 85 53 60          
1030 31069 Garden County, Nebraska 1897 88 112 114 90 83 81 113 81 70 101 107 169 158 140 113 114 90 73          
658 2164 Lake and Peninsula Borough, Alaska 1587 161 113 115 100 89 137 97 110 97 92 99 124 91 66 46 22 15 13          
488 38001 Adams County, North Dakota 2294 117 128 117 117 82 98 149 120 110 106 130 185 196 173 139 103 101 123          
1327 2105 Hoonah-Angoon Census Area, Alaska 2151 102 115 119 95 87 100 112 119 106 152 168 202 191 202 121 90 46 24          
2113 31073 Gosper County, Nebraska 1996 117 113 119 134 86 79 111 117 81 115 114 171 162 132 118 71 76 80 30420 Outlying Gosper County   Nebraska
9 48327 Menard County, Texas 2139 91 107 120 103 87 103 81 97 87 106 113 183 182 170 181 139 81 108          
815 38037 Grant County, North Dakota 2374 148 158 121 96 94 103 113 106 105 119 129 192 180 210 170 132 91 107          
1157 20083 Hodgeman County, Kansas 1818 117 96 121 112 87 78 98 91 77 92 109 159 145 119 76 87 86 68          
1389 48011 Armstrong County, Texas 1892 108 142 121 102 77 89 87 113 111 112 82 146 149 135 122 84 68 44 11100 Outlying Armstrong County Amarillo-Borger, TX Texas
1047 48125 Dickens County, Texas 2249 116 106 122 145 124 162 147 133 158 122 97 148 156 136 132 119 70 56          

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [2018_county_census] (
   [statecountyfips] INTEGER,
   [geo_display] TEXT,
   [est2018_all] INTEGER,
   [est2018_0to4] INTEGER,
   [est2018_5to9] INTEGER,
   [est2018_10to14] INTEGER,
   [est2018_15to19] INTEGER,
   [est2018_20to24] INTEGER,
   [est2018_25to29] INTEGER,
   [est2018_30to34] INTEGER,
   [est2018_35to39] INTEGER,
   [est2018_40to44] INTEGER,
   [est2018_45to49] INTEGER,
   [est2018_50to54] INTEGER,
   [est2018_55to59] INTEGER,
   [est2018_60to64] INTEGER,
   [est2018_65to69] INTEGER,
   [est2018_70to74] INTEGER,
   [est2018_75to79] INTEGER,
   [est2018_80to84] INTEGER,
   [est2018_85plus] INTEGER,
   [cbsacode] TEXT,
   [centraloutlyingcounty] TEXT,
   [countyequivalent] TEXT,
   [csatitle] TEXT,
   [statename] TEXT
);