ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where deaths = 382 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 5
state 1
- Virginia · 26 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453724 | 2453724 | 2022-04-28 | Loudoun | Virginia | 51107 | 69639 | 382 |
2450468 | 2450468 | 2022-04-27 | Loudoun | Virginia | 51107 | 69527 | 382 |
2447211 | 2447211 | 2022-04-26 | Loudoun | Virginia | 51107 | 69428 | 382 |
2443956 | 2443956 | 2022-04-25 | Loudoun | Virginia | 51107 | 69344 | 382 |
2440700 | 2440700 | 2022-04-24 | Loudoun | Virginia | 51107 | 69110 | 382 |
2437444 | 2437444 | 2022-04-23 | Loudoun | Virginia | 51107 | 69110 | 382 |
2434188 | 2434188 | 2022-04-22 | Loudoun | Virginia | 51107 | 69110 | 382 |
2307286 | 2307286 | 2022-03-14 | Newport News city | Virginia | 51700 | 35972 | 382 |
2108830 | 2108830 | 2022-01-12 | Chesapeake city | Virginia | 51550 | 39893 | 382 |
2105579 | 2105579 | 2022-01-11 | Chesapeake city | Virginia | 51550 | 39308 | 382 |
2102328 | 2102328 | 2022-01-10 | Chesapeake city | Virginia | 51550 | 38664 | 382 |
2099077 | 2099077 | 2022-01-09 | Chesapeake city | Virginia | 51550 | 36815 | 382 |
2095826 | 2095826 | 2022-01-08 | Chesapeake city | Virginia | 51550 | 36815 | 382 |
2092574 | 2092574 | 2022-01-07 | Chesapeake city | Virginia | 51550 | 36815 | 382 |
2089322 | 2089322 | 2022-01-06 | Chesapeake city | Virginia | 51550 | 36130 | 382 |
2086071 | 2086071 | 2022-01-05 | Chesapeake city | Virginia | 51550 | 35511 | 382 |
2082819 | 2082819 | 2022-01-04 | Chesapeake city | Virginia | 51550 | 35027 | 382 |
2079567 | 2079567 | 2022-01-03 | Chesapeake city | Virginia | 51550 | 34564 | 382 |
2053645 | 2053645 | 2021-12-26 | Richmond city | Virginia | 51760 | 27319 | 382 |
2050395 | 2050395 | 2021-12-25 | Richmond city | Virginia | 51760 | 27319 | 382 |
2047145 | 2047145 | 2021-12-24 | Richmond city | Virginia | 51760 | 27319 | 382 |
2043895 | 2043895 | 2021-12-23 | Richmond city | Virginia | 51760 | 26973 | 382 |
2040646 | 2040646 | 2021-12-22 | Richmond city | Virginia | 51760 | 26779 | 382 |
1257863 | 1257863 | 2021-04-25 | Virginia Beach city | Virginia | 51810 | 35069 | 382 |
1254616 | 1254616 | 2021-04-24 | Virginia Beach city | Virginia | 51810 | 35003 | 382 |
1251369 | 1251369 | 2021-04-23 | Virginia Beach city | Virginia | 51810 | 34939 | 382 |
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);