ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,034 rows where date = "2020-03-21" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state >30
- Georgia 56
- Mississippi 45
- Texas 44
- New York 43
- Florida 41
- California 39
- Louisiana 36
- Tennessee 34
- Indiana 33
- Ohio 33
- North Carolina 32
- South Carolina 31
- Virginia 31
- Colorado 29
- Wisconsin 29
- Michigan 28
- Pennsylvania 28
- Washington 28
- Arkansas 27
- Minnesota 27
- Illinois 25
- Alabama 21
- Kentucky 21
- New Jersey 21
- Missouri 18
- Iowa 17
- Maryland 17
- Oregon 17
- Massachusetts 14
- Oklahoma 14
- …
fips >30
county >30
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6083 | 6083 | 2020-03-21 | Baldwin | Alabama | 1003 | 2 | 0 |
6084 | 6084 | 2020-03-21 | Calhoun | Alabama | 1015 | 1 | 0 |
6085 | 6085 | 2020-03-21 | Chambers | Alabama | 1017 | 1 | 0 |
6086 | 6086 | 2020-03-21 | Cullman | Alabama | 1043 | 2 | 0 |
6087 | 6087 | 2020-03-21 | Elmore | Alabama | 1051 | 6 | 0 |
6088 | 6088 | 2020-03-21 | Jackson | Alabama | 1071 | 1 | 0 |
6089 | 6089 | 2020-03-21 | Jefferson | Alabama | 1073 | 61 | 0 |
6090 | 6090 | 2020-03-21 | Lamar | Alabama | 1075 | 1 | 0 |
6091 | 6091 | 2020-03-21 | Lauderdale | Alabama | 1077 | 2 | 0 |
6092 | 6092 | 2020-03-21 | Lee | Alabama | 1081 | 12 | 0 |
6093 | 6093 | 2020-03-21 | Limestone | Alabama | 1083 | 1 | 0 |
6094 | 6094 | 2020-03-21 | Madison | Alabama | 1089 | 9 | 0 |
6095 | 6095 | 2020-03-21 | Marion | Alabama | 1093 | 1 | 0 |
6096 | 6096 | 2020-03-21 | Mobile | Alabama | 1097 | 2 | 0 |
6097 | 6097 | 2020-03-21 | Montgomery | Alabama | 1101 | 3 | 0 |
6098 | 6098 | 2020-03-21 | Shelby | Alabama | 1117 | 16 | 0 |
6099 | 6099 | 2020-03-21 | St. Clair | Alabama | 1115 | 1 | 0 |
6100 | 6100 | 2020-03-21 | Talladega | Alabama | 1121 | 1 | 0 |
6101 | 6101 | 2020-03-21 | Tuscaloosa | Alabama | 1125 | 6 | 0 |
6102 | 6102 | 2020-03-21 | Walker | Alabama | 1127 | 1 | 0 |
6103 | 6103 | 2020-03-21 | Washington | Alabama | 1129 | 1 | 0 |
6104 | 6104 | 2020-03-21 | Anchorage | Alaska | 2020 | 5 | 0 |
6105 | 6105 | 2020-03-21 | Fairbanks North Star Borough | Alaska | 2090 | 7 | 0 |
6106 | 6106 | 2020-03-21 | Kenai Peninsula Borough | Alaska | 2122 | 3 | 0 |
6107 | 6107 | 2020-03-21 | Ketchikan Gateway Borough | Alaska | 2130 | 6 | 0 |
6108 | 6108 | 2020-03-21 | Apache | Arizona | 4001 | 3 | 0 |
6109 | 6109 | 2020-03-21 | Cochise | Arizona | 4003 | 1 | 0 |
6110 | 6110 | 2020-03-21 | Coconino | Arizona | 4005 | 11 | 0 |
6111 | 6111 | 2020-03-21 | Graham | Arizona | 4009 | 1 | 0 |
6112 | 6112 | 2020-03-21 | Maricopa | Arizona | 4013 | 49 | 1 |
6113 | 6113 | 2020-03-21 | Navajo | Arizona | 4017 | 10 | 0 |
6114 | 6114 | 2020-03-21 | Pima | Arizona | 4019 | 12 | 0 |
6115 | 6115 | 2020-03-21 | Pinal | Arizona | 4021 | 14 | 0 |
6116 | 6116 | 2020-03-21 | Santa Cruz | Arizona | 4023 | 1 | 0 |
6117 | 6117 | 2020-03-21 | Yavapai | Arizona | 4025 | 1 | 0 |
6118 | 6118 | 2020-03-21 | Yuma | Arizona | 4027 | 1 | 0 |
6119 | 6119 | 2020-03-21 | Benton | Arkansas | 5007 | 1 | 0 |
6120 | 6120 | 2020-03-21 | Boone | Arkansas | 5009 | 1 | 0 |
6121 | 6121 | 2020-03-21 | Bradley | Arkansas | 5011 | 1 | 0 |
6122 | 6122 | 2020-03-21 | Clark | Arkansas | 5019 | 1 | 0 |
6123 | 6123 | 2020-03-21 | Cleburne | Arkansas | 5023 | 22 | 0 |
6124 | 6124 | 2020-03-21 | Cleveland | Arkansas | 5025 | 1 | 0 |
6125 | 6125 | 2020-03-21 | Craighead | Arkansas | 5031 | 1 | 0 |
6126 | 6126 | 2020-03-21 | Crittenden | Arkansas | 5035 | 1 | 0 |
6127 | 6127 | 2020-03-21 | Desha | Arkansas | 5041 | 1 | 0 |
6128 | 6128 | 2020-03-21 | Faulkner | Arkansas | 5045 | 1 | 0 |
6129 | 6129 | 2020-03-21 | Garland | Arkansas | 5051 | 6 | 0 |
6130 | 6130 | 2020-03-21 | Grant | Arkansas | 5053 | 1 | 0 |
6131 | 6131 | 2020-03-21 | Greene | Arkansas | 5055 | 1 | 0 |
6132 | 6132 | 2020-03-21 | Independence | Arkansas | 5063 | 1 | 0 |
6133 | 6133 | 2020-03-21 | Jefferson | Arkansas | 5069 | 19 | 0 |
6134 | 6134 | 2020-03-21 | Lincoln | Arkansas | 5079 | 1 | 0 |
6135 | 6135 | 2020-03-21 | Poinsett | Arkansas | 5111 | 1 | 0 |
6136 | 6136 | 2020-03-21 | Polk | Arkansas | 5113 | 1 | 0 |
6137 | 6137 | 2020-03-21 | Pope | Arkansas | 5115 | 1 | 0 |
6138 | 6138 | 2020-03-21 | Pulaski | Arkansas | 5119 | 28 | 0 |
6139 | 6139 | 2020-03-21 | Saline | Arkansas | 5125 | 1 | 0 |
6140 | 6140 | 2020-03-21 | Searcy | Arkansas | 5129 | 1 | 0 |
6141 | 6141 | 2020-03-21 | Sebastian | Arkansas | 5131 | 1 | 0 |
6142 | 6142 | 2020-03-21 | Sevier | Arkansas | 5133 | 1 | 0 |
6143 | 6143 | 2020-03-21 | Unknown | Arkansas | 21 | 0 | |
6144 | 6144 | 2020-03-21 | Van Buren | Arkansas | 5141 | 1 | 0 |
6145 | 6145 | 2020-03-21 | Washington | Arkansas | 5143 | 1 | 0 |
6146 | 6146 | 2020-03-21 | Alameda | California | 6001 | 87 | 0 |
6147 | 6147 | 2020-03-21 | Amador | California | 6005 | 1 | 0 |
6148 | 6148 | 2020-03-21 | Butte | California | 6007 | 1 | 0 |
6149 | 6149 | 2020-03-21 | Contra Costa | California | 6013 | 51 | 1 |
6150 | 6150 | 2020-03-21 | El Dorado | California | 6017 | 2 | 0 |
6151 | 6151 | 2020-03-21 | Fresno | California | 6019 | 10 | 0 |
6152 | 6152 | 2020-03-21 | Humboldt | California | 6023 | 2 | 0 |
6153 | 6153 | 2020-03-21 | Imperial | California | 6025 | 4 | 0 |
6154 | 6154 | 2020-03-21 | Kern | California | 6029 | 4 | 0 |
6155 | 6155 | 2020-03-21 | Los Angeles | California | 6037 | 351 | 4 |
6156 | 6156 | 2020-03-21 | Madera | California | 6039 | 3 | 0 |
6157 | 6157 | 2020-03-21 | Marin | California | 6041 | 38 | 0 |
6158 | 6158 | 2020-03-21 | Mendocino | California | 6045 | 1 | 0 |
6159 | 6159 | 2020-03-21 | Monterey | California | 6053 | 11 | 1 |
6160 | 6160 | 2020-03-21 | Napa | California | 6055 | 1 | 0 |
6161 | 6161 | 2020-03-21 | Nevada | California | 6057 | 1 | 0 |
6162 | 6162 | 2020-03-21 | Orange | California | 6059 | 78 | 0 |
6163 | 6163 | 2020-03-21 | Placer | California | 6061 | 12 | 1 |
6164 | 6164 | 2020-03-21 | Riverside | California | 6065 | 30 | 5 |
6165 | 6165 | 2020-03-21 | Sacramento | California | 6067 | 52 | 3 |
6166 | 6166 | 2020-03-21 | San Benito | California | 6069 | 5 | 1 |
6167 | 6167 | 2020-03-21 | San Bernardino | California | 6071 | 9 | 0 |
6168 | 6168 | 2020-03-21 | San Diego | California | 6073 | 159 | 0 |
6169 | 6169 | 2020-03-21 | San Francisco | California | 6075 | 84 | 0 |
6170 | 6170 | 2020-03-21 | San Joaquin | California | 6077 | 31 | 2 |
6171 | 6171 | 2020-03-21 | San Luis Obispo | California | 6079 | 27 | 0 |
6172 | 6172 | 2020-03-21 | San Mateo | California | 6081 | 110 | 1 |
6173 | 6173 | 2020-03-21 | Santa Barbara | California | 6083 | 17 | 0 |
6174 | 6174 | 2020-03-21 | Santa Clara | California | 6085 | 263 | 8 |
6175 | 6175 | 2020-03-21 | Santa Cruz | California | 6087 | 15 | 0 |
6176 | 6176 | 2020-03-21 | Shasta | California | 6089 | 2 | 0 |
6177 | 6177 | 2020-03-21 | Siskiyou | California | 6093 | 2 | 0 |
6178 | 6178 | 2020-03-21 | Solano | California | 6095 | 19 | 0 |
6179 | 6179 | 2020-03-21 | Sonoma | California | 6097 | 11 | 1 |
6180 | 6180 | 2020-03-21 | Stanislaus | California | 6099 | 5 | 0 |
6181 | 6181 | 2020-03-21 | Tulare | California | 6107 | 11 | 0 |
6182 | 6182 | 2020-03-21 | Ventura | California | 6111 | 26 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);