ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Washington" and state = "Virginia" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13922 | 13922 | 2020-03-26 | Washington | Virginia | 51191 | 1 | 0 |
15690 | 15690 | 2020-03-27 | Washington | Virginia | 51191 | 1 | 0 |
17570 | 17570 | 2020-03-28 | Washington | Virginia | 51191 | 1 | 0 |
19533 | 19533 | 2020-03-29 | Washington | Virginia | 51191 | 2 | 0 |
21600 | 21600 | 2020-03-30 | Washington | Virginia | 51191 | 2 | 0 |
23748 | 23748 | 2020-03-31 | Washington | Virginia | 51191 | 2 | 0 |
25966 | 25966 | 2020-04-01 | Washington | Virginia | 51191 | 2 | 0 |
28256 | 28256 | 2020-04-02 | Washington | Virginia | 51191 | 2 | 0 |
30606 | 30606 | 2020-04-03 | Washington | Virginia | 51191 | 3 | 0 |
33006 | 33006 | 2020-04-04 | Washington | Virginia | 51191 | 3 | 0 |
35444 | 35444 | 2020-04-05 | Washington | Virginia | 51191 | 5 | 0 |
37928 | 37928 | 2020-04-06 | Washington | Virginia | 51191 | 5 | 0 |
40463 | 40463 | 2020-04-07 | Washington | Virginia | 51191 | 10 | 0 |
43032 | 43032 | 2020-04-08 | Washington | Virginia | 51191 | 12 | 0 |
45628 | 45628 | 2020-04-09 | Washington | Virginia | 51191 | 15 | 0 |
48255 | 48255 | 2020-04-10 | Washington | Virginia | 51191 | 17 | 0 |
50913 | 50913 | 2020-04-11 | Washington | Virginia | 51191 | 24 | 0 |
53588 | 53588 | 2020-04-12 | Washington | Virginia | 51191 | 24 | 0 |
56278 | 56278 | 2020-04-13 | Washington | Virginia | 51191 | 28 | 0 |
58984 | 58984 | 2020-04-14 | Washington | Virginia | 51191 | 27 | 0 |
61703 | 61703 | 2020-04-15 | Washington | Virginia | 51191 | 27 | 0 |
64436 | 64436 | 2020-04-16 | Washington | Virginia | 51191 | 27 | 0 |
67184 | 67184 | 2020-04-17 | Washington | Virginia | 51191 | 28 | 0 |
69946 | 69946 | 2020-04-18 | Washington | Virginia | 51191 | 27 | 0 |
72716 | 72716 | 2020-04-19 | Washington | Virginia | 51191 | 29 | 0 |
75492 | 75492 | 2020-04-20 | Washington | Virginia | 51191 | 29 | 0 |
78275 | 78275 | 2020-04-21 | Washington | Virginia | 51191 | 29 | 3 |
81068 | 81068 | 2020-04-22 | Washington | Virginia | 51191 | 29 | 3 |
83869 | 83869 | 2020-04-23 | Washington | Virginia | 51191 | 30 | 3 |
86676 | 86676 | 2020-04-24 | Washington | Virginia | 51191 | 30 | 3 |
89491 | 89491 | 2020-04-25 | Washington | Virginia | 51191 | 30 | 3 |
92308 | 92308 | 2020-04-26 | Washington | Virginia | 51191 | 34 | 3 |
95137 | 95137 | 2020-04-27 | Washington | Virginia | 51191 | 34 | 3 |
97982 | 97982 | 2020-04-28 | Washington | Virginia | 51191 | 34 | 3 |
100832 | 100832 | 2020-04-29 | Washington | Virginia | 51191 | 36 | 3 |
103687 | 103687 | 2020-04-30 | Washington | Virginia | 51191 | 36 | 3 |
106551 | 106551 | 2020-05-01 | Washington | Virginia | 51191 | 38 | 3 |
109420 | 109420 | 2020-05-02 | Washington | Virginia | 51191 | 39 | 3 |
112294 | 112294 | 2020-05-03 | Washington | Virginia | 51191 | 39 | 3 |
115177 | 115177 | 2020-05-04 | Washington | Virginia | 51191 | 39 | 3 |
118136 | 118136 | 2020-05-05 | Washington | Virginia | 51191 | 40 | 3 |
121100 | 121100 | 2020-05-06 | Washington | Virginia | 51191 | 40 | 3 |
124080 | 124080 | 2020-05-07 | Washington | Virginia | 51191 | 41 | 3 |
127065 | 127065 | 2020-05-08 | Washington | Virginia | 51191 | 42 | 3 |
130055 | 130055 | 2020-05-09 | Washington | Virginia | 51191 | 42 | 3 |
133045 | 133045 | 2020-05-10 | Washington | Virginia | 51191 | 49 | 3 |
136035 | 136035 | 2020-05-11 | Washington | Virginia | 51191 | 49 | 3 |
139026 | 139026 | 2020-05-12 | Washington | Virginia | 51191 | 48 | 3 |
142022 | 142022 | 2020-05-13 | Washington | Virginia | 51191 | 49 | 3 |
145019 | 145019 | 2020-05-14 | Washington | Virginia | 51191 | 49 | 3 |
148022 | 148022 | 2020-05-15 | Washington | Virginia | 51191 | 49 | 3 |
151031 | 151031 | 2020-05-16 | Washington | Virginia | 51191 | 49 | 3 |
154042 | 154042 | 2020-05-17 | Washington | Virginia | 51191 | 49 | 3 |
157059 | 157059 | 2020-05-18 | Washington | Virginia | 51191 | 49 | 3 |
160083 | 160083 | 2020-05-19 | Washington | Virginia | 51191 | 50 | 4 |
163111 | 163111 | 2020-05-20 | Washington | Virginia | 51191 | 50 | 4 |
166140 | 166140 | 2020-05-21 | Washington | Virginia | 51191 | 51 | 4 |
169176 | 169176 | 2020-05-22 | Washington | Virginia | 51191 | 51 | 4 |
172217 | 172217 | 2020-05-23 | Washington | Virginia | 51191 | 51 | 4 |
175260 | 175260 | 2020-05-24 | Washington | Virginia | 51191 | 51 | 4 |
178305 | 178305 | 2020-05-25 | Washington | Virginia | 51191 | 51 | 4 |
181349 | 181349 | 2020-05-26 | Washington | Virginia | 51191 | 51 | 4 |
184400 | 184400 | 2020-05-27 | Washington | Virginia | 51191 | 51 | 4 |
187457 | 187457 | 2020-05-28 | Washington | Virginia | 51191 | 51 | 4 |
190521 | 190521 | 2020-05-29 | Washington | Virginia | 51191 | 51 | 4 |
193587 | 193587 | 2020-05-30 | Washington | Virginia | 51191 | 51 | 4 |
196657 | 196657 | 2020-05-31 | Washington | Virginia | 51191 | 51 | 4 |
199730 | 199730 | 2020-06-01 | Washington | Virginia | 51191 | 51 | 4 |
202806 | 202806 | 2020-06-02 | Washington | Virginia | 51191 | 52 | 4 |
205885 | 205885 | 2020-06-03 | Washington | Virginia | 51191 | 53 | 4 |
208967 | 208967 | 2020-06-04 | Washington | Virginia | 51191 | 53 | 4 |
212052 | 212052 | 2020-06-05 | Washington | Virginia | 51191 | 53 | 4 |
215139 | 215139 | 2020-06-06 | Washington | Virginia | 51191 | 53 | 4 |
218229 | 218229 | 2020-06-07 | Washington | Virginia | 51191 | 57 | 4 |
221321 | 221321 | 2020-06-08 | Washington | Virginia | 51191 | 57 | 4 |
224417 | 224417 | 2020-06-09 | Washington | Virginia | 51191 | 57 | 4 |
227517 | 227517 | 2020-06-10 | Washington | Virginia | 51191 | 58 | 4 |
230621 | 230621 | 2020-06-11 | Washington | Virginia | 51191 | 58 | 4 |
233726 | 233726 | 2020-06-12 | Washington | Virginia | 51191 | 58 | 4 |
236833 | 236833 | 2020-06-13 | Washington | Virginia | 51191 | 58 | 4 |
239941 | 239941 | 2020-06-14 | Washington | Virginia | 51191 | 58 | 4 |
243052 | 243052 | 2020-06-15 | Washington | Virginia | 51191 | 58 | 4 |
246165 | 246165 | 2020-06-16 | Washington | Virginia | 51191 | 58 | 4 |
249277 | 249277 | 2020-06-17 | Washington | Virginia | 51191 | 58 | 4 |
252392 | 252392 | 2020-06-18 | Washington | Virginia | 51191 | 58 | 4 |
255511 | 255511 | 2020-06-19 | Washington | Virginia | 51191 | 58 | 4 |
258638 | 258638 | 2020-06-20 | Washington | Virginia | 51191 | 59 | 4 |
261765 | 261765 | 2020-06-21 | Washington | Virginia | 51191 | 60 | 4 |
264894 | 264894 | 2020-06-22 | Washington | Virginia | 51191 | 60 | 4 |
268023 | 268023 | 2020-06-23 | Washington | Virginia | 51191 | 60 | 4 |
271157 | 271157 | 2020-06-24 | Washington | Virginia | 51191 | 60 | 4 |
274297 | 274297 | 2020-06-25 | Washington | Virginia | 51191 | 60 | 4 |
277445 | 277445 | 2020-06-26 | Washington | Virginia | 51191 | 62 | 4 |
280593 | 280593 | 2020-06-27 | Washington | Virginia | 51191 | 63 | 4 |
283739 | 283739 | 2020-06-28 | Washington | Virginia | 51191 | 63 | 4 |
286885 | 286885 | 2020-06-29 | Washington | Virginia | 51191 | 63 | 4 |
290035 | 290035 | 2020-06-30 | Washington | Virginia | 51191 | 64 | 4 |
293188 | 293188 | 2020-07-01 | Washington | Virginia | 51191 | 64 | 4 |
296343 | 296343 | 2020-07-02 | Washington | Virginia | 51191 | 65 | 4 |
299505 | 299505 | 2020-07-03 | Washington | Virginia | 51191 | 65 | 4 |
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);