ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where deaths = 1234 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Pennsylvania 9
- Tennessee 7
- New Jersey 6
- California 4
- Alabama 3
- Florida 3
- Georgia 3
- Maryland 3
- Michigan 3
- Massachusetts 2
- New York 2
- South Carolina 2
- Texas 2
- Delaware 1
- Indiana 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2387913 | 2387913 | 2022-04-08 | Lehigh | Pennsylvania | 42077 | 89454 | 1234 |
2384658 | 2384658 | 2022-04-07 | Lehigh | Pennsylvania | 42077 | 89414 | 1234 |
2381403 | 2381403 | 2022-04-06 | Lehigh | Pennsylvania | 42077 | 89378 | 1234 |
2378148 | 2378148 | 2022-04-05 | Lehigh | Pennsylvania | 42077 | 89345 | 1234 |
2374894 | 2374894 | 2022-04-04 | Lehigh | Pennsylvania | 42077 | 89321 | 1234 |
2371642 | 2371642 | 2022-04-03 | Lehigh | Pennsylvania | 42077 | 89297 | 1234 |
2368389 | 2368389 | 2022-04-02 | Lehigh | Pennsylvania | 42077 | 89297 | 1234 |
2241815 | 2241815 | 2022-02-22 | Knox | Tennessee | 47093 | 124460 | 1234 |
2238564 | 2238564 | 2022-02-21 | Knox | Tennessee | 47093 | 124460 | 1234 |
2235313 | 2235313 | 2022-02-20 | Knox | Tennessee | 47093 | 124460 | 1234 |
2232062 | 2232062 | 2022-02-19 | Knox | Tennessee | 47093 | 124460 | 1234 |
2228811 | 2228811 | 2022-02-18 | Knox | Tennessee | 47093 | 124460 | 1234 |
2225560 | 2225560 | 2022-02-17 | Knox | Tennessee | 47093 | 124460 | 1234 |
2222309 | 2222309 | 2022-02-16 | Knox | Tennessee | 47093 | 124460 | 1234 |
2206161 | 2206161 | 2022-02-11 | Denton | Texas | 48121 | 172822 | 1234 |
2196490 | 2196490 | 2022-02-08 | Lubbock | Texas | 48303 | 96047 | 1234 |
2186257 | 2186257 | 2022-02-05 | Luzerne | Pennsylvania | 42079 | 71067 | 1234 |
2177767 | 2177767 | 2022-02-03 | New Castle | Delaware | 10003 | 141653 | 1234 |
2173909 | 2173909 | 2022-02-01 | Fairfax | Virginia | 51059 | 166375 | 1234 |
2160257 | 2160257 | 2022-01-28 | Westmoreland | Pennsylvania | 42129 | 74625 | 1234 |
2154910 | 2154910 | 2022-01-27 | Tulare | California | 6107 | 116213 | 1234 |
2125630 | 2125630 | 2022-01-18 | Ventura | California | 6111 | 148093 | 1234 |
2122378 | 2122378 | 2022-01-17 | Ventura | California | 6111 | 146738 | 1234 |
2006374 | 2006374 | 2021-12-12 | Genesee | Michigan | 26049 | 66135 | 1234 |
2003123 | 2003123 | 2021-12-11 | Genesee | Michigan | 26049 | 66135 | 1234 |
1999873 | 1999873 | 2021-12-10 | Genesee | Michigan | 26049 | 66135 | 1234 |
1968562 | 1968562 | 2021-11-30 | Spartanburg | South Carolina | 45083 | 63178 | 1234 |
1965311 | 1965311 | 2021-11-29 | Spartanburg | South Carolina | 45083 | 63146 | 1234 |
1938717 | 1938717 | 2021-11-21 | Monroe | New York | 36055 | 94311 | 1234 |
1935467 | 1935467 | 2021-11-20 | Monroe | New York | 36055 | 93822 | 1234 |
1754930 | 1754930 | 2021-09-26 | Mobile | Alabama | 1097 | 70851 | 1234 |
1751682 | 1751682 | 2021-09-25 | Mobile | Alabama | 1097 | 70816 | 1234 |
1735624 | 1735624 | 2021-09-20 | Stanislaus | California | 6099 | 80699 | 1234 |
1732561 | 1732561 | 2021-09-19 | Cobb | Georgia | 13067 | 102533 | 1234 |
1729311 | 1729311 | 2021-09-18 | Cobb | Georgia | 13067 | 102533 | 1234 |
1726061 | 1726061 | 2021-09-17 | Cobb | Georgia | 13067 | 102533 | 1234 |
1398862 | 1398862 | 2021-06-08 | Baltimore city | Maryland | 24510 | 52979 | 1234 |
1392968 | 1392968 | 2021-06-06 | Morris | New Jersey | 34027 | 50143 | 1234 |
1389723 | 1389723 | 2021-06-05 | Morris | New Jersey | 34027 | 50130 | 1234 |
1386478 | 1386478 | 2021-06-04 | Morris | New Jersey | 34027 | 50121 | 1234 |
1383233 | 1383233 | 2021-06-03 | Morris | New Jersey | 34027 | 50106 | 1234 |
1204649 | 1204649 | 2021-04-09 | Camden | New Jersey | 34007 | 50540 | 1234 |
1112267 | 1112267 | 2021-03-12 | Duval | Florida | 12031 | 90389 | 1234 |
1038481 | 1038481 | 2021-02-17 | Baltimore | Maryland | 24005 | 49687 | 1234 |
1011350 | 1011350 | 2021-02-09 | Jefferson | Alabama | 1073 | 68747 | 1234 |
941126 | 941126 | 2021-01-18 | Montgomery | Maryland | 24031 | 54569 | 1234 |
891980 | 891980 | 2021-01-03 | Marion | Indiana | 18097 | 72892 | 1234 |
772392 | 772392 | 2020-11-27 | Suffolk | Massachusetts | 25025 | 36276 | 1234 |
538029 | 538029 | 2020-09-16 | Palm Beach | Florida | 12099 | 44457 | 1234 |
512100 | 512100 | 2020-09-08 | Broward | Florida | 12011 | 73556 | 1234 |
480667 | 480667 | 2020-08-29 | Essex | Massachusetts | 25009 | 18808 | 1234 |
342801 | 342801 | 2020-07-17 | Passaic | New Jersey | 34031 | 17312 | 1234 |
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);