ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where cases = 5369 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 6
- Michigan 6
- Missouri 6
- Texas 6
- Georgia 5
- Illinois 5
- Tennessee 5
- Virginia 4
- Wisconsin 4
- Indiana 3
- Nebraska 3
- Pennsylvania 3
- Vermont 3
- Arkansas 2
- Iowa 2
- Minnesota 2
- New York 2
- North Carolina 2
- Ohio 2
- Utah 2
- California 1
- Colorado 1
- Florida 1
- Louisiana 1
- Mississippi 1
- Nevada 1
- North Dakota 1
- Oregon 1
- Puerto Rico 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453688 | 2453688 | 2022-04-28 | Dinwiddie | Virginia | 51053 | 5369 | 93 |
2396063 | 2396063 | 2022-04-11 | Union | Illinois | 17181 | 5369 | 68 |
2392807 | 2392807 | 2022-04-10 | Union | Illinois | 17181 | 5369 | 68 |
2389551 | 2389551 | 2022-04-09 | Union | Illinois | 17181 | 5369 | 68 |
2386296 | 2386296 | 2022-04-08 | Union | Illinois | 17181 | 5369 | 68 |
2385065 | 2385065 | 2022-04-07 | Gillespie | Texas | 48171 | 5369 | 109 |
2326704 | 2326704 | 2022-03-20 | Addison | Vermont | 50001 | 5369 | 15 |
2323451 | 2323451 | 2022-03-19 | Addison | Vermont | 50001 | 5369 | 15 |
2320197 | 2320197 | 2022-03-18 | Addison | Vermont | 50001 | 5369 | 15 |
2302547 | 2302547 | 2022-03-13 | Crawford | Missouri | 29055 | 5369 | 97 |
2299295 | 2299295 | 2022-03-12 | Crawford | Missouri | 29055 | 5369 | 97 |
2300600 | 2300600 | 2022-03-12 | San Jacinto | Texas | 48407 | 5369 | 100 |
2296043 | 2296043 | 2022-03-11 | Crawford | Missouri | 29055 | 5369 | 97 |
2292791 | 2292791 | 2022-03-10 | Crawford | Missouri | 29055 | 5369 | 97 |
2278984 | 2278984 | 2022-03-06 | Fountain | Indiana | 18045 | 5369 | 97 |
2275731 | 2275731 | 2022-03-05 | Fountain | Indiana | 18045 | 5369 | 97 |
2272478 | 2272478 | 2022-03-04 | Fountain | Indiana | 18045 | 5369 | 97 |
2242938 | 2242938 | 2022-02-23 | Franklin | Georgia | 13119 | 5369 | 94 |
2228096 | 2228096 | 2022-02-18 | Essex | New York | 36031 | 5369 | 55 |
2194819 | 2194819 | 2022-02-08 | Simpson | Kentucky | 21213 | 5369 | 79 |
2195009 | 2195009 | 2022-02-08 | Menominee | Michigan | 26109 | 5369 | 68 |
2191755 | 2191755 | 2022-02-07 | Menominee | Michigan | 26109 | 5369 | 68 |
2191769 | 2191769 | 2022-02-07 | Otsego | Michigan | 26137 | 5369 | 91 |
2188473 | 2188473 | 2022-02-06 | Gladwin | Michigan | 26051 | 5369 | 105 |
2185220 | 2185220 | 2022-02-05 | Gladwin | Michigan | 26051 | 5369 | 105 |
2181968 | 2181968 | 2022-02-04 | Gladwin | Michigan | 26051 | 5369 | 105 |
2178458 | 2178458 | 2022-02-03 | Bourbon | Kentucky | 21017 | 5369 | 46 |
2157094 | 2157094 | 2022-01-27 | Barnwell | South Carolina | 45011 | 5369 | 88 |
2154545 | 2154545 | 2022-01-26 | Mason | West Virginia | 54053 | 5369 | 76 |
2101309 | 2101309 | 2022-01-10 | Dare | North Carolina | 37055 | 5369 | 18 |
2080274 | 2080274 | 2022-01-04 | Butts | Georgia | 13035 | 5369 | 125 |
2072401 | 2072401 | 2022-01-01 | Elk | Pennsylvania | 42047 | 5369 | 76 |
2059784 | 2059784 | 2021-12-28 | Cooke | Texas | 48097 | 5369 | 107 |
2027330 | 2027330 | 2021-12-18 | Grimes | Texas | 48185 | 5369 | 109 |
2019489 | 2019489 | 2021-12-16 | Nobles | Minnesota | 27105 | 5369 | 55 |
1996426 | 1996426 | 2021-12-09 | Logan | Kentucky | 21141 | 5369 | 93 |
1983371 | 1983371 | 2021-12-05 | Calloway | Kentucky | 21035 | 5369 | 64 |
1980121 | 1980121 | 2021-12-04 | Calloway | Kentucky | 21035 | 5369 | 64 |
1976871 | 1976871 | 2021-12-03 | Calloway | Kentucky | 21035 | 5369 | 64 |
1971331 | 1971331 | 2021-12-01 | Person | North Carolina | 37145 | 5369 | 89 |
1940061 | 1940061 | 2021-11-21 | Trempealeau | Wisconsin | 55121 | 5369 | 52 |
1936811 | 1936811 | 2021-11-20 | Trempealeau | Wisconsin | 55121 | 5369 | 52 |
1933561 | 1933561 | 2021-11-19 | Trempealeau | Wisconsin | 55121 | 5369 | 52 |
1806200 | 1806200 | 2021-10-11 | Macon | Tennessee | 47111 | 5369 | 88 |
1772997 | 1772997 | 2021-10-01 | Livingston | New York | 36051 | 5369 | 67 |
1757418 | 1757418 | 2021-09-26 | Carroll | Tennessee | 47017 | 5369 | 94 |
1754170 | 1754170 | 2021-09-25 | Carroll | Tennessee | 47017 | 5369 | 94 |
1750922 | 1750922 | 2021-09-24 | Carroll | Tennessee | 47017 | 5369 | 94 |
1745633 | 1745633 | 2021-09-23 | Oconee | Georgia | 13219 | 5369 | 78 |
1717435 | 1717435 | 2021-09-14 | Howell | Missouri | 29091 | 5369 | 66 |
1658932 | 1658932 | 2021-08-27 | Butler | Missouri | 29023 | 5369 | 59 |
1552261 | 1552261 | 2021-07-25 | Morton | North Dakota | 38059 | 5369 | 102 |
1540470 | 1540470 | 2021-07-21 | Fremont | Wyoming | 56013 | 5369 | 87 |
1469198 | 1469198 | 2021-06-30 | Hot Spring | Arkansas | 5059 | 5369 | 77 |
1380431 | 1380431 | 2021-06-02 | Linn | Oregon | 41043 | 5369 | 77 |
1318633 | 1318633 | 2021-05-14 | Sandusky | Ohio | 39143 | 5369 | 122 |
1312086 | 1312086 | 2021-05-12 | Darke | Ohio | 39037 | 5369 | 123 |
1294587 | 1294587 | 2021-05-07 | Cerro Gordo | Iowa | 19033 | 5369 | 89 |
1293407 | 1293407 | 2021-05-06 | Box Elder | Utah | 49003 | 5369 | 50 |
1217525 | 1217525 | 2021-04-13 | Buffalo | Nebraska | 31019 | 5369 | 57 |
1202626 | 1202626 | 2021-04-08 | Pittsylvania | Virginia | 51143 | 5369 | 77 |
1168015 | 1168015 | 2021-03-29 | Warren | Iowa | 19181 | 5369 | 80 |
1145011 | 1145011 | 2021-03-22 | Coles | Illinois | 17029 | 5369 | 95 |
1146719 | 1146719 | 2021-03-22 | Union | Pennsylvania | 42119 | 5369 | 84 |
1143472 | 1143472 | 2021-03-21 | Union | Pennsylvania | 42119 | 5369 | 84 |
1105365 | 1105365 | 2021-03-09 | Grant | Wisconsin | 55043 | 5369 | 86 |
1091794 | 1091794 | 2021-03-05 | Monroe | Tennessee | 47123 | 5369 | 90 |
1037689 | 1037689 | 2021-02-17 | Catoosa | Georgia | 13047 | 5369 | 57 |
997425 | 997425 | 2021-02-04 | Caguas | Puerto Rico | 72025 | 5369 | |
982463 | 982463 | 2021-01-31 | Monroe | Florida | 12087 | 5369 | 40 |
977056 | 977056 | 2021-01-29 | Lafayette | Mississippi | 28071 | 5369 | 103 |
939660 | 939660 | 2021-01-17 | Lynchburg city | Virginia | 51680 | 5369 | 60 |
879607 | 879607 | 2020-12-30 | Kandiyohi | Minnesota | 27067 | 5369 | 64 |
862158 | 862158 | 2020-12-25 | Garland | Arkansas | 5051 | 5369 | 141 |
836298 | 836298 | 2020-12-17 | Sutter | California | 6101 | 5369 | 42 |
831277 | 831277 | 2020-12-15 | Hall | Nebraska | 31079 | 5369 | 88 |
828031 | 828031 | 2020-12-14 | Hall | Nebraska | 31079 | 5369 | 88 |
673584 | 673584 | 2020-10-27 | Norfolk city | Virginia | 51710 | 5369 | 84 |
470895 | 470895 | 2020-08-26 | Ouachita | Louisiana | 22073 | 5369 | 125 |
447652 | 447652 | 2020-08-19 | Richmond | Georgia | 13245 | 5369 | 103 |
397346 | 397346 | 2020-08-03 | Washoe | Nevada | 32031 | 5369 | 115 |
385440 | 385440 | 2020-07-30 | Jefferson | Texas | 48245 | 5369 | 64 |
327915 | 327915 | 2020-07-12 | Utah | Utah | 49049 | 5369 | 28 |
306271 | 306271 | 2020-07-06 | Arapahoe | Colorado | 8005 | 5369 | 346 |
126731 | 126731 | 2020-05-08 | Dallas | Texas | 48113 | 5369 | 135 |
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);