ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where deaths = 1378 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Tennessee 9
- Pennsylvania 6
- Connecticut 4
- Florida 4
- New Jersey 4
- Colorado 2
- Texas 2
- California 1
- Maryland 1
- Massachusetts 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501911 | 2501911 | 2022-05-13 | Westmoreland | Pennsylvania | 42129 | 81006 | 1378 |
2502674 | 2502674 | 2022-05-13 | Spokane | Washington | 53063 | 126131 | 1378 |
2498653 | 2498653 | 2022-05-12 | Westmoreland | Pennsylvania | 42129 | 81006 | 1378 |
2493304 | 2493304 | 2022-05-11 | Adams | Colorado | 8001 | 137428 | 1378 |
2495395 | 2495395 | 2022-05-11 | Westmoreland | Pennsylvania | 42129 | 81006 | 1378 |
2490046 | 2490046 | 2022-05-10 | Adams | Colorado | 8001 | 137373 | 1378 |
2469581 | 2469581 | 2022-05-03 | Knox | Tennessee | 47093 | 128199 | 1378 |
2466325 | 2466325 | 2022-05-02 | Knox | Tennessee | 47093 | 128199 | 1378 |
2463070 | 2463070 | 2022-05-01 | Knox | Tennessee | 47093 | 128199 | 1378 |
2459814 | 2459814 | 2022-04-30 | Knox | Tennessee | 47093 | 128199 | 1378 |
2456558 | 2456558 | 2022-04-29 | Knox | Tennessee | 47093 | 128199 | 1378 |
2453302 | 2453302 | 2022-04-28 | Knox | Tennessee | 47093 | 128199 | 1378 |
2450046 | 2450046 | 2022-04-27 | Knox | Tennessee | 47093 | 128199 | 1378 |
2268213 | 2268213 | 2022-03-02 | Fairfax | Virginia | 51059 | 172919 | 1378 |
2173746 | 2173746 | 2022-02-01 | Nueces | Texas | 48355 | 87265 | 1378 |
1894832 | 1894832 | 2021-11-08 | Stanislaus | California | 6099 | 89222 | 1378 |
1783148 | 1783148 | 2021-10-04 | Bucks | Pennsylvania | 42017 | 69730 | 1378 |
1779899 | 1779899 | 2021-10-03 | Bucks | Pennsylvania | 42017 | 69502 | 1378 |
1776649 | 1776649 | 2021-10-02 | Bucks | Pennsylvania | 42017 | 69330 | 1378 |
1717688 | 1717688 | 2021-09-14 | Camden | New Jersey | 34007 | 62340 | 1378 |
1372068 | 1372068 | 2021-05-31 | Polk | Florida | 12105 | 70908 | 1378 |
1368823 | 1368823 | 2021-05-30 | Polk | Florida | 12105 | 70908 | 1378 |
1365577 | 1365577 | 2021-05-29 | Polk | Florida | 12105 | 70908 | 1378 |
1362331 | 1362331 | 2021-05-28 | Polk | Florida | 12105 | 70908 | 1378 |
1155357 | 1155357 | 2021-03-25 | Prince George's | Maryland | 24033 | 76979 | 1378 |
1007426 | 1007426 | 2021-02-07 | Shelby | Tennessee | 47157 | 84798 | 1378 |
1002805 | 1002805 | 2021-02-06 | Bristol | Massachusetts | 25005 | 52258 | 1378 |
1004180 | 1004180 | 2021-02-06 | Shelby | Tennessee | 47157 | 84798 | 1378 |
855128 | 855128 | 2020-12-22 | Tarrant | Texas | 48439 | 134091 | 1378 |
831374 | 831374 | 2020-12-15 | Passaic | New Jersey | 34031 | 36140 | 1378 |
711307 | 711307 | 2020-11-08 | Union | New Jersey | 34039 | 22222 | 1378 |
708063 | 708063 | 2020-11-07 | Union | New Jersey | 34039 | 22067 | 1378 |
312668 | 312668 | 2020-07-08 | Fairfield | Connecticut | 9001 | 16859 | 1378 |
303167 | 303167 | 2020-07-05 | Hartford | Connecticut | 9003 | 11728 | 1378 |
300003 | 300003 | 2020-07-04 | Hartford | Connecticut | 9003 | 11728 | 1378 |
296841 | 296841 | 2020-07-03 | Hartford | Connecticut | 9003 | 11728 | 1378 |
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);