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_all

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          
1104 48269 King County, Texas 277 13 24 26 11 11 17 14 23 7 19 22 17 24 14 9 8 13 5          
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
576 31005 Arthur County, Nebraska 465 24 37 35 35 30 22 29 22 32 22 23 23 29 34 20 21 20 7          
794 31009 Blaine County, Nebraska 476 26 29 25 22 27 36 16 21 15 24 33 45 36 43 21 28 15 14          
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
1202 30069 Petroleum County, Montana 513 19 31 25 30 29 15 26 21 22 29 40 44 54 31 23 39 19 16          
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          
1254 31115 Loup County, Nebraska 618 30 31 31 36 33 23 30 26 23 26 30 58 76 51 46 35 21 12          
1098 48033 Borden County, Texas 648 33 35 38 35 29 20 27 34 33 65 48 47 44 42 35 25 31 27          
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          
728 31075 Grant County, Nebraska 660 56 47 37 33 22 30 42 40 37 19 35 64 49 53 35 34 21 6          
1131 30103 Treasure County, Montana 679 55 41 25 29 26 28 38 38 22 17 40 54 72 53 55 33 30 23          
1089 31091 Hooker County, Nebraska 682 42 35 50 40 23 33 25 34 39 30 26 35 62 56 41 38 22 51          
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          
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
187 48311 McMullen County, Texas 749 33 36 47 38 40 56 39 35 32 51 58 44 60 40 43 36 32 29          
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
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          
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          
515 8079 Mineral County, Colorado 776 33 36 18 34 21 34 52 33 37 41 43 77 75 94 67 40 19 22          
834 31183 Wheeler County, Nebraska 805 47 48 43 33 42 32 38 33 41 37 47 67 89 57 46 37 36 32          
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          
681 8053 Hinsdale County, Colorado 811 32 36 34 47 39 32 42 29 45 32 54 60 83 72 88 43 21 22          
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          
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
122 16033 Clark County, Idaho 852 47 50 61 78 56 40 57 52 55 49 47 48 61 48 35 24 25 19          
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          
1231 48393 Roberts County, Texas 903 58 52 75 58 29 48 50 75 45 47 47 70 60 59 57 33 25 15          
580 31085 Hayes County, Nebraska 916 68 62 46 39 55 45 40 45 35 24 39 80 86 69 55 38 43 47          
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          
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          
795 49009 Daggett County, Utah 980 48 59 66 66 38 29 44 52 50 60 56 87 74 86 74 38 18 35          
553 30109 Wibaux County, Montana 1034 64 65 55 62 50 40 48 69 49 45 71 81 84 85 51 43 39 33          
1301 30079 Prairie County, Montana 1087 49 55 50 49 43 41 49 46 59 63 50 78 109 110 100 50 32 54          
529 6003 Alpine County, California 1101 44 36 69 70 60 55 54 36 47 63 70 114 103 115 78 36 28 23          
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
1326 2230 Skagway Municipality, Alaska 1148 61 56 43 31 39 100 115 130 94 81 79 68 84 71 37 32 18 9          
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
446 48155 Foard County, Texas 1200 45 77 70 75 63 50 59 57 47 69 97 97 78 79 73 68 49 47          
183 20071 Greeley County, Kansas 1227 72 106 96 73 45 58 86 86 58 37 70 97 89 70 49 40 36 59          
471 48345 Motley County, Texas 1234 58 56 84 76 59 55 65 48 50 77 52 96 84 123 84 75 46 46          
265 30011 Carter County, Montana 1238 91 76 54 50 54 67 80 63 46 40 73 107 118 98 64 59 46 52          
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          
204 30033 Garfield County, Montana 1268 74 85 78 64 68 59 57 103 64 69 66 78 108 99 70 64 40 22          
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          
128 28055 Issaquena County, Mississippi 1308 36 42 31 94 120 153 62 103 63 78 98 107 103 58 46 43 38 33          
568 48431 Sterling County, Texas 1311 109 96 101 96 71 65 86 90 89 78 69 80 92 48 44 30 30 37          
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          
542 31149 Rock County, Nebraska 1360 81 65 90 56 62 48 76 74 68 55 45 122 155 133 71 53 43 63          
185 48433 Stonewall County, Texas 1362 79 72 90 89 52 75 43 85 55 75 88 96 102 93 94 62 46 66          
409 41069 Wheeler County, Oregon 1366 67 50 54 64 43 54 60 56 55 65 81 100 142 135 108 113 60 59          
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          
1167 8061 Kiowa County, Colorado 1383 109 78 72 75 86 71 64 68 70 64 66 131 105 100 65 55 48 56          
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
812 48101 Cottle County, Texas 1389 75 84 89 97 56 60 75 84 68 63 79 115 106 96 83 75 42 42          
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
1006 8057 Jackson County, Colorado 1399 69 62 67 61 55 85 79 76 97 81 99 117 140 111 71 61 35 33          
689 49031 Piute County, Utah 1445 47 75 133 109 62 58 50 68 83 68 70 90 115 135 105 86 45 46          
93 20199 Wallace County, Kansas 1503 119 94 97 107 74 71 81 74 62 59 87 117 111 99 84 48 47 72          
903 48447 Throckmorton County, Texas 1515 73 82 93 82 62 67 61 87 67 75 108 121 112 116 99 86 69 55          
212 48045 Briscoe County, Texas 1516 65 85 90 82 76 69 92 82 96 84 97 111 90 102 112 74 62 47          
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
109 20101 Lane County, Kansas 1560 89 102 98 87 73 75 88 59 76 99 98 117 132 98 94 53 66 56          
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          
88 13265 Taliaferro County, Georgia 1608 66 91 73 65 81 89 84 80 95 84 123 130 124 130 110 70 44 69          
968 30055 McCone County, Montana 1675 94 88 104 83 92 75 91 74 85 75 84 146 146 140 94 84 69 51          
923 41055 Sherman County, Oregon 1708 91 77 86 93 56 78 97 93 99 98 102 147 138 128 105 85 69 66          
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          
1284 30019 Daniels County, Montana 1747 90 117 100 90 65 87 100 94 83 81 89 125 163 132 98 68 71 94          
493 20033 Comanche County, Kansas 1748 85 141 114 114 72 79 82 92 83 100 91 126 122 131 118 85 53 60          
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          
165 31057 Dundy County, Nebraska 1770 86 99 93 97 115 64 87 92 93 116 86 147 148 139 97 71 58 82          
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          
1157 20083 Hodgeman County, Kansas 1818 117 96 121 112 87 78 98 91 77 92 109 159 145 119 76 87 86 68          
1232 31049 Deuel County, Nebraska 1825 97 100 132 94 67 77 91 100 95 99 123 168 153 126 104 87 62 50          
89 30059 Meagher County, Montana 1866 98 112 96 84 71 78 81 88 89 99 90 135 172 202 157 89 54 71          
51 8017 Cheyenne County, Colorado 1876 131 155 124 113 81 89 106 118 90 91 113 147 133 142 73 65 39 66          
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
687 41021 Gilliam County, Oregon 1894 86 121 100 96 85 62 84 118 81 92 102 149 191 155 133 85 65 89          
1030 31069 Garden County, Nebraska 1897 88 112 114 90 83 81 113 81 70 101 107 169 158 140 113 114 90 73          
320 38047 Logan County, North Dakota 1903 127 116 124 107 101 81 82 79 89 98 106 157 142 117 111 99 80 87          
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          
428 46055 Haakon County, South Dakota 1918 115 126 137 114 88 86 89 118 85 85 73 158 176 125 105 94 73 71          
375 48137 Edwards County, Texas 1928 125 135 114 99 77 97 75 98 80 96 103 128 140 181 159 106 59 56          
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          
2846 38065 Oliver County, North Dakota 1952 128 141 146 114 63 82 111 107 93 92 131 143 168 168 114 62 36 53 13900 Outlying Oliver County   North Dakota
46 31015 Boyd County, Nebraska 1955 88 107 100 114 105 73 77 85 84 89 107 176 152 177 131 110 69 111          
258 20187 Stanton County, Kansas 1987 138 151 139 162 109 97 111 119 124 117 109 123 138 95 83 56 55 61          
438 31071 Garfield County, Nebraska 1987 95 79 111 122 119 77 92 77 105 84 106 163 186 144 132 93 100 102          
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
2157 32011 Eureka County, Nevada 2003 100 145 169 102 82 89 122 114 127 145 142 192 148 115 87 63 31 30 21220 Outlying Eureka County   Nevada
942 20025 Clark County, Kansas 2005 107 142 155 125 118 112 100 125 109 97 111 130 134 108 85 91 65 91          
925 46017 Buffalo County, South Dakota 2036 248 214 219 175 133 158 120 122 120 93 88 79 107 50 50 29 18 13          
629 29227 Worth County, Missouri 2040 108 119 107 125 97 106 106 96 93 95 136 170 177 132 109 93 79 92          
926 46095 Mellette County, South Dakota 2042 210 139 200 140 134 144 99 81 95 91 122 137 134 109 82 49 40 36          
173 46073 Jerauld County, South Dakota 2043 131 138 137 100 73 83 116 129 107 91 100 138 150 174 118 88 68 102          

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