ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where cases = 5404 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Kentucky 18
- Ohio 14
- Georgia 11
- Texas 9
- North Carolina 4
- Indiana 3
- Michigan 3
- Illinois 2
- Minnesota 2
- Missouri 2
- Montana 2
- New York 2
- Tennessee 2
- Alabama 1
- Arkansas 1
- Maine 1
- Maryland 1
- Pennsylvania 1
- South Carolina 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487236 | 2487236 | 2022-05-09 | Union | Illinois | 17181 | 5404 | 68 |
2459949 | 2459949 | 2022-04-30 | Gillespie | Texas | 48171 | 5404 | 109 |
2405585 | 2405585 | 2022-04-14 | Franklin | Georgia | 13119 | 5404 | 101 |
2393168 | 2393168 | 2022-04-10 | Hart | Kentucky | 21099 | 5404 | 97 |
2389912 | 2389912 | 2022-04-09 | Hart | Kentucky | 21099 | 5404 | 97 |
2386656 | 2386656 | 2022-04-08 | Hart | Kentucky | 21099 | 5404 | 97 |
2383401 | 2383401 | 2022-04-07 | Hart | Kentucky | 21099 | 5404 | 97 |
2380146 | 2380146 | 2022-04-06 | Hart | Kentucky | 21099 | 5404 | 97 |
2376891 | 2376891 | 2022-04-05 | Hart | Kentucky | 21099 | 5404 | 97 |
2373639 | 2373639 | 2022-04-04 | Hart | Kentucky | 21099 | 5404 | 97 |
2370386 | 2370386 | 2022-04-03 | Hart | Kentucky | 21099 | 5404 | 97 |
2367133 | 2367133 | 2022-04-02 | Hart | Kentucky | 21099 | 5404 | 97 |
2363880 | 2363880 | 2022-04-01 | Hart | Kentucky | 21099 | 5404 | 97 |
2360626 | 2360626 | 2022-03-31 | Hart | Kentucky | 21099 | 5404 | 97 |
2357372 | 2357372 | 2022-03-30 | Hart | Kentucky | 21099 | 5404 | 97 |
2358476 | 2358476 | 2022-03-30 | Wyandot | Ohio | 39175 | 5404 | 103 |
2353795 | 2353795 | 2022-03-29 | Fountain | Indiana | 18045 | 5404 | 101 |
2354119 | 2354119 | 2022-03-29 | Hart | Kentucky | 21099 | 5404 | 97 |
2355222 | 2355222 | 2022-03-29 | Wyandot | Ohio | 39175 | 5404 | 103 |
2350867 | 2350867 | 2022-03-28 | Hart | Kentucky | 21099 | 5404 | 97 |
2351969 | 2351969 | 2022-03-28 | Wyandot | Ohio | 39175 | 5404 | 103 |
2348717 | 2348717 | 2022-03-27 | Wyandot | Ohio | 39175 | 5404 | 103 |
2345464 | 2345464 | 2022-03-26 | Wyandot | Ohio | 39175 | 5404 | 103 |
2342211 | 2342211 | 2022-03-25 | Wyandot | Ohio | 39175 | 5404 | 103 |
2338958 | 2338958 | 2022-03-24 | Wyandot | Ohio | 39175 | 5404 | 103 |
2260153 | 2260153 | 2022-02-28 | Waseca | Minnesota | 27161 | 5404 | 39 |
2246201 | 2246201 | 2022-02-24 | Haralson | Georgia | 13143 | 5404 | 157 |
2248862 | 2248862 | 2022-02-24 | Lincoln | West Virginia | 54043 | 5404 | 69 |
2219189 | 2219189 | 2022-02-15 | Frio | Texas | 48163 | 5404 | 86 |
2198277 | 2198277 | 2022-02-09 | Otsego | Michigan | 26137 | 5404 | 92 |
2195023 | 2195023 | 2022-02-08 | Otsego | Michigan | 26137 | 5404 | 92 |
2038993 | 2038993 | 2021-12-22 | Nobles | Minnesota | 27105 | 5404 | 56 |
2012680 | 2012680 | 2021-12-14 | Logan | Kentucky | 21141 | 5404 | 96 |
2004494 | 2004494 | 2021-12-11 | Bee | Texas | 48025 | 5404 | 135 |
1977051 | 1977051 | 2021-12-03 | Somerset | Maine | 23025 | 5404 | 62 |
1971008 | 1971008 | 2021-12-01 | Ravalli | Montana | 30081 | 5404 | 116 |
1869650 | 1869650 | 2021-10-31 | Harlan | Kentucky | 21095 | 5404 | 129 |
1866401 | 1866401 | 2021-10-30 | Harlan | Kentucky | 21095 | 5404 | 129 |
1863152 | 1863152 | 2021-10-29 | Harlan | Kentucky | 21095 | 5404 | 129 |
1859643 | 1859643 | 2021-10-28 | Wabash | Indiana | 18169 | 5404 | 105 |
1833387 | 1833387 | 2021-10-20 | Toombs | Georgia | 13279 | 5404 | 167 |
1833395 | 1833395 | 2021-10-20 | Upson | Georgia | 13293 | 5404 | 168 |
1804145 | 1804145 | 2021-10-11 | Toombs | Georgia | 13279 | 5404 | 162 |
1800896 | 1800896 | 2021-10-10 | Toombs | Georgia | 13279 | 5404 | 162 |
1797647 | 1797647 | 2021-10-09 | Toombs | Georgia | 13279 | 5404 | 162 |
1794398 | 1794398 | 2021-10-08 | Toombs | Georgia | 13279 | 5404 | 162 |
1724458 | 1724458 | 2021-09-16 | Brown | Ohio | 39015 | 5404 | 67 |
1690050 | 1690050 | 2021-09-06 | Independence | Arkansas | 5063 | 5404 | 144 |
1642761 | 1642761 | 2021-08-22 | Phelps | Missouri | 29161 | 5404 | 159 |
1630108 | 1630108 | 2021-08-18 | Chatham | North Carolina | 37037 | 5404 | 89 |
1588093 | 1588093 | 2021-08-05 | Seneca | Ohio | 39147 | 5404 | 128 |
1514339 | 1514339 | 2021-07-13 | Lewis | Washington | 53041 | 5404 | 79 |
1389997 | 1389997 | 2021-06-05 | Darke | Ohio | 39037 | 5404 | 128 |
1390225 | 1390225 | 2021-06-05 | Mifflin | Pennsylvania | 42087 | 5404 | 178 |
1363560 | 1363560 | 2021-05-28 | Taney | Missouri | 29213 | 5404 | 96 |
1350834 | 1350834 | 2021-05-24 | Genesee | New York | 36037 | 5404 | 123 |
1347588 | 1347588 | 2021-05-23 | Genesee | New York | 36037 | 5404 | 123 |
1340483 | 1340483 | 2021-05-21 | Cass | Michigan | 26027 | 5404 | 76 |
1305489 | 1305489 | 2021-05-10 | Pender | North Carolina | 37141 | 5404 | 69 |
1270352 | 1270352 | 2021-04-29 | Dyer | Tennessee | 47045 | 5404 | 105 |
1215861 | 1215861 | 2021-04-13 | Coffee | Alabama | 1031 | 5404 | 112 |
1188715 | 1188715 | 2021-04-04 | Lawrence | Ohio | 39087 | 5404 | 98 |
1185468 | 1185468 | 2021-04-03 | Lawrence | Ohio | 39087 | 5404 | 98 |
1088589 | 1088589 | 2021-03-04 | Atascosa | Texas | 48013 | 5404 | 141 |
1020564 | 1020564 | 2021-02-11 | Lamar | Texas | 48277 | 5404 | 136 |
1021009 | 1021009 | 2021-02-11 | Sauk | Wisconsin | 55111 | 5404 | 44 |
1017319 | 1017319 | 2021-02-10 | Lamar | Texas | 48277 | 5404 | 135 |
1006756 | 1006756 | 2021-02-07 | Duplin | North Carolina | 37061 | 5404 | 119 |
956648 | 956648 | 2021-01-23 | Rockdale | Georgia | 13247 | 5404 | 101 |
947098 | 947098 | 2021-01-20 | Whiteside | Illinois | 17195 | 5404 | 174 |
945702 | 945702 | 2021-01-19 | Dickson | Tennessee | 47043 | 5404 | 79 |
941999 | 941999 | 2021-01-18 | Hancock | Ohio | 39063 | 5404 | 90 |
882221 | 882221 | 2020-12-31 | Grant | Indiana | 18053 | 5404 | 102 |
882695 | 882695 | 2020-12-31 | Allegany | Maryland | 24001 | 5404 | 153 |
832281 | 832281 | 2020-12-15 | Grayson | Texas | 48181 | 5404 | 135 |
811737 | 811737 | 2020-12-09 | Missoula | Montana | 30063 | 5404 | 45 |
787058 | 787058 | 2020-12-01 | Alexandria city | Virginia | 51510 | 5404 | 77 |
782858 | 782858 | 2020-11-30 | Onslow | North Carolina | 37133 | 5404 | 42 |
715156 | 715156 | 2020-11-09 | Aiken | South Carolina | 45003 | 5404 | 90 |
569431 | 569431 | 2020-09-25 | Bell | Texas | 48027 | 5404 | 84 |
566190 | 566190 | 2020-09-24 | Bell | Texas | 48027 | 5404 | 84 |
486307 | 486307 | 2020-08-31 | Bibb | Georgia | 13021 | 5404 | 121 |
278064 | 278064 | 2020-06-27 | DeKalb | Georgia | 13089 | 5404 | 171 |
251455 | 251455 | 2020-06-18 | Cuyahoga | Ohio | 39035 | 5404 | 327 |
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);