ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where cases = 5398 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Ohio 14
- Tennessee 8
- Mississippi 7
- Missouri 4
- Wisconsin 4
- Georgia 3
- Louisiana 3
- Michigan 3
- Texas 3
- Alabama 2
- California 2
- New York 2
- Virginia 2
- West Virginia 2
- Colorado 1
- Delaware 1
- Illinois 1
- Indiana 1
- Iowa 1
- Kentucky 1
- Massachusetts 1
- Minnesota 1
- Nebraska 1
- New Jersey 1
- Pennsylvania 1
- Washington 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453437 | 2453437 | 2022-04-28 | Gillespie | Texas | 48171 | 5398 | 109 |
2424038 | 2424038 | 2022-04-19 | Union | Tennessee | 47173 | 5398 | 75 |
2420782 | 2420782 | 2022-04-18 | Union | Tennessee | 47173 | 5398 | 75 |
2416387 | 2416387 | 2022-04-17 | Stone | Mississippi | 28131 | 5398 | 71 |
2417526 | 2417526 | 2022-04-17 | Union | Tennessee | 47173 | 5398 | 75 |
2413131 | 2413131 | 2022-04-16 | Stone | Mississippi | 28131 | 5398 | 71 |
2414270 | 2414270 | 2022-04-16 | Union | Tennessee | 47173 | 5398 | 75 |
2409875 | 2409875 | 2022-04-15 | Stone | Mississippi | 28131 | 5398 | 71 |
2411014 | 2411014 | 2022-04-15 | Union | Tennessee | 47173 | 5398 | 75 |
2406619 | 2406619 | 2022-04-14 | Stone | Mississippi | 28131 | 5398 | 71 |
2407758 | 2407758 | 2022-04-14 | Union | Tennessee | 47173 | 5398 | 75 |
2403363 | 2403363 | 2022-04-13 | Stone | Mississippi | 28131 | 5398 | 71 |
2404502 | 2404502 | 2022-04-13 | Union | Tennessee | 47173 | 5398 | 75 |
2400109 | 2400109 | 2022-04-12 | Stone | Mississippi | 28131 | 5398 | 71 |
2376289 | 2376289 | 2022-04-05 | Franklin | Georgia | 13119 | 5398 | 97 |
2373037 | 2373037 | 2022-04-04 | Franklin | Georgia | 13119 | 5398 | 96 |
2312931 | 2312931 | 2022-03-16 | Wyandot | Ohio | 39175 | 5398 | 103 |
2309678 | 2309678 | 2022-03-15 | Wyandot | Ohio | 39175 | 5398 | 103 |
2306425 | 2306425 | 2022-03-14 | Wyandot | Ohio | 39175 | 5398 | 103 |
2303174 | 2303174 | 2022-03-13 | Wyandot | Ohio | 39175 | 5398 | 103 |
2299922 | 2299922 | 2022-03-12 | Wyandot | Ohio | 39175 | 5398 | 103 |
2283662 | 2283662 | 2022-03-07 | Wyandot | Ohio | 39175 | 5398 | 101 |
2280410 | 2280410 | 2022-03-06 | Wyandot | Ohio | 39175 | 5398 | 101 |
2277157 | 2277157 | 2022-03-05 | Wyandot | Ohio | 39175 | 5398 | 101 |
2273904 | 2273904 | 2022-03-04 | Wyandot | Ohio | 39175 | 5398 | 101 |
2270651 | 2270651 | 2022-03-03 | Wyandot | Ohio | 39175 | 5398 | 101 |
2267399 | 2267399 | 2022-03-02 | Wyandot | Ohio | 39175 | 5398 | 101 |
2236448 | 2236448 | 2022-02-21 | Haralson | Georgia | 13143 | 5398 | 155 |
2201517 | 2201517 | 2022-02-10 | Menominee | Michigan | 26109 | 5398 | 68 |
2202988 | 2202988 | 2022-02-10 | Lampasas | Texas | 48281 | 5398 | 79 |
2198263 | 2198263 | 2022-02-09 | Menominee | Michigan | 26109 | 5398 | 68 |
2149269 | 2149269 | 2022-01-25 | Rowan | Kentucky | 21205 | 5398 | 48 |
2125255 | 2125255 | 2022-01-17 | Jackson | West Virginia | 54035 | 5398 | 113 |
2083843 | 2083843 | 2022-01-05 | Fayette | Indiana | 18041 | 5398 | 117 |
1975848 | 1975848 | 2021-12-02 | Teton | Wyoming | 56039 | 5398 | 14 |
1945200 | 1945200 | 2021-11-23 | Chenango | New York | 36017 | 5398 | 95 |
1912970 | 1912970 | 2021-11-13 | Perry | Ohio | 39127 | 5398 | 76 |
1864419 | 1864419 | 2021-10-29 | Pike | Pennsylvania | 42103 | 5398 | 62 |
1856217 | 1856217 | 2021-10-27 | Christian | Illinois | 17021 | 5398 | 100 |
1789936 | 1789936 | 2021-10-06 | Hardin | Tennessee | 47071 | 5398 | 81 |
1751642 | 1751642 | 2021-09-25 | Chambers | Alabama | 1017 | 5398 | 134 |
1723932 | 1723932 | 2021-09-16 | Howell | Missouri | 29091 | 5398 | 66 |
1710540 | 1710540 | 2021-09-12 | Evangeline | Louisiana | 22039 | 5398 | 113 |
1707293 | 1707293 | 2021-09-11 | Evangeline | Louisiana | 22039 | 5398 | 113 |
1704045 | 1704045 | 2021-09-10 | Evangeline | Louisiana | 22039 | 5398 | 113 |
1688240 | 1688240 | 2021-09-05 | Platte | Missouri | 29165 | 5398 | 54 |
1644353 | 1644353 | 2021-08-22 | Dunn | Wisconsin | 55033 | 5398 | 35 |
1641103 | 1641103 | 2021-08-21 | Dunn | Wisconsin | 55033 | 5398 | 35 |
1637853 | 1637853 | 2021-08-20 | Dunn | Wisconsin | 55033 | 5398 | 35 |
1633025 | 1633025 | 2021-08-19 | Scott | Missouri | 29201 | 5398 | 90 |
1630251 | 1630251 | 2021-08-18 | Athens | Ohio | 39009 | 5398 | 60 |
1616707 | 1616707 | 2021-08-14 | Camden | Missouri | 29029 | 5398 | 110 |
1614735 | 1614735 | 2021-08-13 | Medina | Texas | 48325 | 5398 | 115 |
1605329 | 1605329 | 2021-08-10 | Mercer | West Virginia | 54055 | 5398 | 129 |
1246404 | 1246404 | 2021-04-22 | Benton | Minnesota | 27009 | 5398 | 97 |
1238398 | 1238398 | 2021-04-19 | Cowlitz | Washington | 53015 | 5398 | 83 |
1182221 | 1182221 | 2021-04-02 | Lawrence | Ohio | 39087 | 5398 | 98 |
1177757 | 1177757 | 2021-04-01 | Warren | Iowa | 19181 | 5398 | 80 |
1176557 | 1176557 | 2021-03-31 | Augusta | Virginia | 51015 | 5398 | 68 |
1155461 | 1155461 | 2021-03-25 | Van Buren | Michigan | 26159 | 5398 | 98 |
1121934 | 1121934 | 2021-03-15 | Eagle | Colorado | 8037 | 5398 | 22 |
1084566 | 1084566 | 2021-03-03 | Cayuga | New York | 36011 | 5398 | 89 |
1037184 | 1037184 | 2021-02-16 | Barron | Wisconsin | 55005 | 5398 | 74 |
946417 | 946417 | 2021-01-20 | Colbert | Alabama | 1033 | 5398 | 73 |
903971 | 903971 | 2021-01-06 | Montgomery | Virginia | 51121 | 5398 | 43 |
672016 | 672016 | 2020-10-27 | Harrison | Mississippi | 28047 | 5398 | 84 |
656104 | 656104 | 2020-10-22 | Sarpy | Nebraska | 31153 | 5398 | 36 |
445710 | 445710 | 2020-08-18 | Somerset | New Jersey | 34035 | 5398 | 566 |
418325 | 418325 | 2020-08-10 | Marin | California | 6041 | 5398 | 78 |
382947 | 382947 | 2020-07-30 | San Mateo | California | 6081 | 5398 | 118 |
303176 | 303176 | 2020-07-05 | New Castle | Delaware | 10003 | 5398 | 245 |
93627 | 93627 | 2020-04-27 | Norfolk | Massachusetts | 25021 | 5398 | 429 |
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);