ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where deaths = 0, fips = 51001 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
75375 | 75375 | 2020-04-20 | Accomack | Virginia | 51001 | 52 | 0 |
72599 | 72599 | 2020-04-19 | Accomack | Virginia | 51001 | 42 | 0 |
69829 | 69829 | 2020-04-18 | Accomack | Virginia | 51001 | 33 | 0 |
67067 | 67067 | 2020-04-17 | Accomack | Virginia | 51001 | 28 | 0 |
64319 | 64319 | 2020-04-16 | Accomack | Virginia | 51001 | 19 | 0 |
61587 | 61587 | 2020-04-15 | Accomack | Virginia | 51001 | 15 | 0 |
58868 | 58868 | 2020-04-14 | Accomack | Virginia | 51001 | 15 | 0 |
56162 | 56162 | 2020-04-13 | Accomack | Virginia | 51001 | 15 | 0 |
53473 | 53473 | 2020-04-12 | Accomack | Virginia | 51001 | 15 | 0 |
50798 | 50798 | 2020-04-11 | Accomack | Virginia | 51001 | 15 | 0 |
48140 | 48140 | 2020-04-10 | Accomack | Virginia | 51001 | 12 | 0 |
45516 | 45516 | 2020-04-09 | Accomack | Virginia | 51001 | 11 | 0 |
42922 | 42922 | 2020-04-08 | Accomack | Virginia | 51001 | 11 | 0 |
40353 | 40353 | 2020-04-07 | Accomack | Virginia | 51001 | 11 | 0 |
37823 | 37823 | 2020-04-06 | Accomack | Virginia | 51001 | 11 | 0 |
35342 | 35342 | 2020-04-05 | Accomack | Virginia | 51001 | 11 | 0 |
32904 | 32904 | 2020-04-04 | Accomack | Virginia | 51001 | 8 | 0 |
30506 | 30506 | 2020-04-03 | Accomack | Virginia | 51001 | 8 | 0 |
28163 | 28163 | 2020-04-02 | Accomack | Virginia | 51001 | 10 | 0 |
25874 | 25874 | 2020-04-01 | Accomack | Virginia | 51001 | 7 | 0 |
23659 | 23659 | 2020-03-31 | Accomack | Virginia | 51001 | 7 | 0 |
21520 | 21520 | 2020-03-30 | Accomack | Virginia | 51001 | 6 | 0 |
19457 | 19457 | 2020-03-29 | Accomack | Virginia | 51001 | 3 | 0 |
17498 | 17498 | 2020-03-28 | Accomack | Virginia | 51001 | 2 | 0 |
15624 | 15624 | 2020-03-27 | Accomack | Virginia | 51001 | 2 | 0 |
13858 | 13858 | 2020-03-26 | Accomack | Virginia | 51001 | 2 | 0 |
12222 | 12222 | 2020-03-25 | Accomack | Virginia | 51001 | 1 | 0 |
10710 | 10710 | 2020-03-24 | Accomack | Virginia | 51001 | 1 | 0 |
9364 | 9364 | 2020-03-23 | Accomack | Virginia | 51001 | 1 | 0 |
8143 | 8143 | 2020-03-22 | Accomack | Virginia | 51001 | 1 | 0 |
7013 | 7013 | 2020-03-21 | Accomack | Virginia | 51001 | 1 | 0 |
5988 | 5988 | 2020-03-20 | Accomack | Virginia | 51001 | 1 | 0 |
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);