ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where cases = 4892 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 12
- Michigan 12
- Georgia 11
- Ohio 7
- Tennessee 6
- Virginia 5
- Alabama 4
- Washington 4
- West Virginia 4
- Arkansas 3
- California 3
- Illinois 3
- North Carolina 3
- Texas 3
- Indiana 2
- Kentucky 2
- Minnesota 2
- Mississippi 2
- Missouri 2
- Nevada 2
- New York 2
- Puerto Rico 2
- Florida 1
- Idaho 1
- Kansas 1
- Louisiana 1
- Maine 1
- Maryland 1
- Nebraska 1
- Oregon 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483749 | 2483749 | 2022-05-08 | Hart | Georgia | 13147 | 4892 | 100 |
2480491 | 2480491 | 2022-05-07 | Hart | Georgia | 13147 | 4892 | 100 |
2477233 | 2477233 | 2022-05-06 | Hart | Georgia | 13147 | 4892 | 100 |
2473975 | 2473975 | 2022-05-05 | Hart | Georgia | 13147 | 4892 | 100 |
2470718 | 2470718 | 2022-05-04 | Hart | Georgia | 13147 | 4892 | 100 |
2399485 | 2399485 | 2022-04-12 | Mahaska | Iowa | 19123 | 4892 | 87 |
2396229 | 2396229 | 2022-04-11 | Mahaska | Iowa | 19123 | 4892 | 87 |
2392974 | 2392974 | 2022-04-10 | Mahaska | Iowa | 19123 | 4892 | 87 |
2389718 | 2389718 | 2022-04-09 | Mahaska | Iowa | 19123 | 4892 | 87 |
2386462 | 2386462 | 2022-04-08 | Mahaska | Iowa | 19123 | 4892 | 87 |
2383208 | 2383208 | 2022-04-07 | Mahaska | Iowa | 19123 | 4892 | 87 |
2379953 | 2379953 | 2022-04-06 | Mahaska | Iowa | 19123 | 4892 | 87 |
2375616 | 2375616 | 2022-04-04 | Prince Edward | Virginia | 51147 | 4892 | 69 |
2360002 | 2360002 | 2022-03-31 | Cook | Georgia | 13075 | 4892 | 72 |
2356748 | 2356748 | 2022-03-30 | Cook | Georgia | 13075 | 4892 | 72 |
2310557 | 2310557 | 2022-03-15 | Radford city | Virginia | 51750 | 4892 | 47 |
2305531 | 2305531 | 2022-03-14 | Charlevoix | Michigan | 26029 | 4892 | 59 |
2302279 | 2302279 | 2022-03-13 | Charlevoix | Michigan | 26029 | 4892 | 59 |
2299027 | 2299027 | 2022-03-12 | Charlevoix | Michigan | 26029 | 4892 | 59 |
2295775 | 2295775 | 2022-03-11 | Charlevoix | Michigan | 26029 | 4892 | 59 |
2291994 | 2291994 | 2022-03-10 | Fulton | Indiana | 18049 | 4892 | 102 |
2292523 | 2292523 | 2022-03-10 | Charlevoix | Michigan | 26029 | 4892 | 59 |
2288586 | 2288586 | 2022-03-09 | Cassia | Idaho | 16031 | 4892 | 52 |
2272949 | 2272949 | 2022-03-04 | Sagadahoc | Maine | 23023 | 4892 | 28 |
2265417 | 2265417 | 2022-03-02 | Randolph | Arkansas | 5121 | 4892 | 80 |
2222119 | 2222119 | 2022-02-16 | Naranjito | Puerto Rico | 72105 | 4892 | |
2147621 | 2147621 | 2022-01-24 | Frio | Texas | 48163 | 4892 | 80 |
2127639 | 2127639 | 2022-01-18 | Lincoln | Oregon | 41041 | 4892 | 60 |
2095991 | 2095991 | 2022-01-08 | Jackson | West Virginia | 54035 | 4892 | 111 |
2085777 | 2085777 | 2022-01-05 | Cass | Texas | 48067 | 4892 | 163 |
2059492 | 2059492 | 2021-12-28 | Mayaguez | Puerto Rico | 72097 | 4892 | |
2031591 | 2031591 | 2021-12-20 | Lee | Georgia | 13177 | 4892 | 83 |
2019436 | 2019436 | 2021-12-16 | Wexford | Michigan | 26165 | 4892 | 80 |
2016186 | 2016186 | 2021-12-15 | Wexford | Michigan | 26165 | 4892 | 80 |
2011647 | 2011647 | 2021-12-14 | Lawrence | Alabama | 1079 | 4892 | 130 |
1991912 | 1991912 | 2021-12-07 | Wythe | Virginia | 51197 | 4892 | 112 |
1972781 | 1972781 | 2021-12-02 | St. Francis | Arkansas | 5123 | 4892 | 69 |
1962196 | 1962196 | 2021-11-28 | Overton | Tennessee | 47133 | 4892 | 83 |
1958945 | 1958945 | 2021-11-27 | Overton | Tennessee | 47133 | 4892 | 83 |
1955694 | 1955694 | 2021-11-26 | Overton | Tennessee | 47133 | 4892 | 83 |
1952443 | 1952443 | 2021-11-25 | Overton | Tennessee | 47133 | 4892 | 83 |
1949192 | 1949192 | 2021-11-24 | Overton | Tennessee | 47133 | 4892 | 83 |
1927576 | 1927576 | 2021-11-18 | Lumpkin | Georgia | 13187 | 4892 | 109 |
1899215 | 1899215 | 2021-11-09 | Lyon | Minnesota | 27083 | 4892 | 57 |
1839523 | 1839523 | 2021-10-22 | Poinsett | Arkansas | 5111 | 4892 | 98 |
1839186 | 1839186 | 2021-10-21 | Kittitas | Washington | 53037 | 4892 | 54 |
1832636 | 1832636 | 2021-10-19 | Prince George | Virginia | 51149 | 4892 | 40 |
1789686 | 1789686 | 2021-10-06 | Perry | Pennsylvania | 42099 | 4892 | 110 |
1783878 | 1783878 | 2021-10-04 | Manassas city | Virginia | 51683 | 4892 | 51 |
1740363 | 1740363 | 2021-09-21 | Lincoln | Nebraska | 31111 | 4892 | 80 |
1668638 | 1668638 | 2021-08-30 | Pike | Mississippi | 28113 | 4892 | 123 |
1665791 | 1665791 | 2021-08-29 | Madison | New York | 36053 | 4892 | 90 |
1654855 | 1654855 | 2021-08-26 | Randolph | Illinois | 17157 | 4892 | 97 |
1621566 | 1621566 | 2021-08-15 | Marion | West Virginia | 54049 | 4892 | 55 |
1618318 | 1618318 | 2021-08-14 | Marion | West Virginia | 54049 | 4892 | 55 |
1615070 | 1615070 | 2021-08-13 | Marion | West Virginia | 54049 | 4892 | 55 |
1610136 | 1610136 | 2021-08-12 | Hancock | Mississippi | 28045 | 4892 | 88 |
1600901 | 1600901 | 2021-08-09 | Haywood | North Carolina | 37087 | 4892 | 100 |
1595913 | 1595913 | 2021-08-08 | Mendocino | California | 6045 | 4892 | 52 |
1592664 | 1592664 | 2021-08-07 | Mendocino | California | 6045 | 4892 | 52 |
1589415 | 1589415 | 2021-08-06 | Mendocino | California | 6045 | 4892 | 52 |
1591956 | 1591956 | 2021-08-06 | Jim Wells | Texas | 48249 | 4892 | 111 |
1583833 | 1583833 | 2021-08-04 | Avoyelles | Louisiana | 22009 | 4892 | 128 |
1529611 | 1529611 | 2021-07-18 | Mercer | Ohio | 39107 | 4892 | 85 |
1526364 | 1526364 | 2021-07-17 | Mercer | Ohio | 39107 | 4892 | 85 |
1523117 | 1523117 | 2021-07-16 | Mercer | Ohio | 39107 | 4892 | 85 |
1519869 | 1519869 | 2021-07-15 | Mercer | Ohio | 39107 | 4892 | 85 |
1516621 | 1516621 | 2021-07-14 | Mercer | Ohio | 39107 | 4892 | 85 |
1509994 | 1509994 | 2021-07-12 | Richmond | North Carolina | 37153 | 4892 | 98 |
1492208 | 1492208 | 2021-07-07 | Colquitt | Georgia | 13071 | 4892 | 131 |
1486154 | 1486154 | 2021-07-05 | Muscatine | Iowa | 19139 | 4892 | 106 |
1482908 | 1482908 | 2021-07-04 | Muscatine | Iowa | 19139 | 4892 | 106 |
1479661 | 1479661 | 2021-07-03 | Muscatine | Iowa | 19139 | 4892 | 106 |
1476415 | 1476415 | 2021-07-02 | Muscatine | Iowa | 19139 | 4892 | 106 |
1473169 | 1473169 | 2021-07-01 | Muscatine | Iowa | 19139 | 4892 | 106 |
1460626 | 1460626 | 2021-06-27 | Newaygo | Michigan | 26123 | 4892 | 69 |
1457381 | 1457381 | 2021-06-26 | Newaygo | Michigan | 26123 | 4892 | 69 |
1454136 | 1454136 | 2021-06-25 | Newaygo | Michigan | 26123 | 4892 | 69 |
1401555 | 1401555 | 2021-06-09 | Livingston | Illinois | 17105 | 4892 | 102 |
1374770 | 1374770 | 2021-05-31 | Lewis | Washington | 53041 | 4892 | 69 |
1371525 | 1371525 | 2021-05-30 | Lewis | Washington | 53041 | 4892 | 69 |
1368279 | 1368279 | 2021-05-29 | Lewis | Washington | 53041 | 4892 | 69 |
1348994 | 1348994 | 2021-05-24 | Dale | Alabama | 1045 | 4892 | 114 |
1331254 | 1331254 | 2021-05-18 | Elko | Nevada | 32007 | 4892 | 56 |
1287810 | 1287810 | 2021-05-05 | Tift | Georgia | 13277 | 4892 | 125 |
1275401 | 1275401 | 2021-05-01 | Scott | Kentucky | 21209 | 4892 | 32 |
1268812 | 1268812 | 2021-04-29 | Boyd | Kentucky | 21019 | 4892 | 73 |
1203592 | 1203592 | 2021-04-09 | Jackson | Indiana | 18071 | 4892 | 70 |
1200885 | 1200885 | 2021-04-08 | Isabella | Michigan | 26073 | 4892 | 78 |
1165391 | 1165391 | 2021-03-28 | Callaway | Missouri | 29027 | 4892 | 46 |
1162143 | 1162143 | 2021-03-27 | Callaway | Missouri | 29027 | 4892 | 46 |
1156271 | 1156271 | 2021-03-25 | Seneca | Ohio | 39147 | 4892 | 113 |
1105070 | 1105070 | 2021-03-09 | Box Elder | Utah | 49003 | 4892 | 46 |
1015768 | 1015768 | 2021-02-10 | Cecil | Maryland | 24015 | 4892 | 113 |
939835 | 939835 | 2021-01-17 | Grant | Wisconsin | 55043 | 4892 | 82 |
913237 | 913237 | 2021-01-09 | Carter | Tennessee | 47019 | 4892 | 101 |
876765 | 876765 | 2020-12-29 | Carson City | Nevada | 32510 | 4892 | 49 |
862626 | 862626 | 2020-12-25 | Boone | Illinois | 17007 | 4892 | 64 |
817828 | 817828 | 2020-12-11 | Allegan | Michigan | 26005 | 4892 | 43 |
814697 | 814697 | 2020-12-10 | Kandiyohi | Minnesota | 27067 | 4892 | 39 |
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);