ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 6593 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Tennessee 10
- Kentucky 7
- Virginia 5
- Wisconsin 5
- West Virginia 4
- Minnesota 3
- Pennsylvania 3
- California 2
- Kansas 2
- Ohio 2
- Texas 2
- Alabama 1
- Georgia 1
- Indiana 1
- Louisiana 1
- Maine 1
- Maryland 1
- Mississippi 1
- Montana 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442593 | 2442593 | 2022-04-25 | Lake | Montana | 30047 | 6593 | 100 |
2438701 | 2438701 | 2022-04-24 | Allen | Kentucky | 21003 | 6593 | 103 |
2435445 | 2435445 | 2022-04-23 | Allen | Kentucky | 21003 | 6593 | 103 |
2432189 | 2432189 | 2022-04-22 | Allen | Kentucky | 21003 | 6593 | 103 |
2428933 | 2428933 | 2022-04-21 | Allen | Kentucky | 21003 | 6593 | 103 |
2425677 | 2425677 | 2022-04-20 | Allen | Kentucky | 21003 | 6593 | 103 |
2422421 | 2422421 | 2022-04-19 | Allen | Kentucky | 21003 | 6593 | 103 |
2419165 | 2419165 | 2022-04-18 | Allen | Kentucky | 21003 | 6593 | 103 |
2303971 | 2303971 | 2022-03-13 | Carroll | Virginia | 51035 | 6593 | 138 |
2300719 | 2300719 | 2022-03-12 | Carroll | Virginia | 51035 | 6593 | 138 |
2297467 | 2297467 | 2022-03-11 | Carroll | Virginia | 51035 | 6593 | 138 |
2285708 | 2285708 | 2022-03-08 | Labette | Kansas | 20099 | 6593 | 72 |
2282456 | 2282456 | 2022-03-07 | Labette | Kansas | 20099 | 6593 | 72 |
2245638 | 2245638 | 2022-02-23 | Upshur | West Virginia | 54097 | 6593 | 80 |
2216386 | 2216386 | 2022-02-14 | Wyoming | West Virginia | 54109 | 6593 | 87 |
2209845 | 2209845 | 2022-02-12 | Jackson | West Virginia | 54035 | 6593 | 120 |
2190891 | 2190891 | 2022-02-07 | Decatur | Georgia | 13087 | 6593 | 117 |
2178832 | 2178832 | 2022-02-03 | Pine | Minnesota | 27115 | 6593 | 59 |
2173507 | 2173507 | 2022-02-01 | Hardeman | Tennessee | 47069 | 6593 | 100 |
2168837 | 2168837 | 2022-01-31 | Jefferson Davis | Louisiana | 22053 | 6593 | 138 |
2170255 | 2170255 | 2022-01-31 | Hardeman | Tennessee | 47069 | 6593 | 100 |
2167001 | 2167001 | 2022-01-30 | Hardeman | Tennessee | 47069 | 6593 | 100 |
2163746 | 2163746 | 2022-01-29 | Hardeman | Tennessee | 47069 | 6593 | 100 |
2160491 | 2160491 | 2022-01-28 | Hardeman | Tennessee | 47069 | 6593 | 100 |
2157235 | 2157235 | 2022-01-27 | Hardeman | Tennessee | 47069 | 6593 | 100 |
2153982 | 2153982 | 2022-01-26 | Hardeman | Tennessee | 47069 | 6593 | 100 |
2131547 | 2131547 | 2022-01-19 | Uintah | Utah | 49047 | 6593 | 56 |
2107956 | 2107956 | 2022-01-12 | Coshocton | Ohio | 39031 | 6593 | 136 |
2056558 | 2056558 | 2021-12-27 | Erath | Texas | 48143 | 6593 | 109 |
1946207 | 1946207 | 2021-11-23 | Waller | Texas | 48473 | 6593 | 85 |
1929201 | 1929201 | 2021-11-18 | Logan | Ohio | 39091 | 6593 | 104 |
1833062 | 1833062 | 2021-10-20 | Lake | California | 6033 | 6593 | 104 |
1706030 | 1706030 | 2021-09-10 | Mercer | West Virginia | 54055 | 6593 | 135 |
1701145 | 1701145 | 2021-09-09 | Washington | Mississippi | 28151 | 6593 | 146 |
1649019 | 1649019 | 2021-08-24 | Chisago | Minnesota | 27025 | 6593 | 55 |
1644392 | 1644392 | 2021-08-22 | Sauk | Wisconsin | 55111 | 6593 | 58 |
1641142 | 1641142 | 2021-08-21 | Sauk | Wisconsin | 55111 | 6593 | 58 |
1637892 | 1637892 | 2021-08-20 | Sauk | Wisconsin | 55111 | 6593 | 58 |
1563130 | 1563130 | 2021-07-28 | Calumet | Wisconsin | 55015 | 6593 | 56 |
1437796 | 1437796 | 2021-06-20 | Kennebec | Maine | 23011 | 6593 | 74 |
1340587 | 1340587 | 2021-05-21 | Kandiyohi | Minnesota | 27067 | 6593 | 84 |
1307519 | 1307519 | 2021-05-11 | Morgan | Indiana | 18109 | 6593 | 144 |
1200809 | 1200809 | 2021-04-08 | Allegany | Maryland | 24001 | 6593 | 204 |
1143692 | 1143692 | 2021-03-21 | Coffee | Tennessee | 47031 | 6593 | 117 |
1140445 | 1140445 | 2021-03-20 | Coffee | Tennessee | 47031 | 6593 | 117 |
1137199 | 1137199 | 2021-03-19 | Coffee | Tennessee | 47031 | 6593 | 117 |
1089270 | 1089270 | 2021-03-05 | Walker | Alabama | 1127 | 6593 | 259 |
1011073 | 1011073 | 2021-02-08 | Montgomery | Virginia | 51121 | 6593 | 69 |
978806 | 978806 | 2021-01-29 | Portage | Wisconsin | 55097 | 6593 | 62 |
962361 | 962361 | 2021-01-24 | Hampton city | Virginia | 51650 | 6593 | 60 |
835080 | 835080 | 2020-12-16 | Beaver | Pennsylvania | 42007 | 6593 | 203 |
728023 | 728023 | 2020-11-13 | Northampton | Pennsylvania | 42095 | 6593 | 322 |
676120 | 676120 | 2020-10-28 | Lehigh | Pennsylvania | 42077 | 6593 | 365 |
224825 | 224825 | 2020-06-10 | San Bernardino | California | 6071 | 6593 | 225 |
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);