ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Waynesboro city" and state = "Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23749 | 23749 | 2020-03-31 | Waynesboro city | Virginia | 51820 | 2 | 0 |
25967 | 25967 | 2020-04-01 | Waynesboro city | Virginia | 51820 | 2 | 0 |
28257 | 28257 | 2020-04-02 | Waynesboro city | Virginia | 51820 | 2 | 0 |
30607 | 30607 | 2020-04-03 | Waynesboro city | Virginia | 51820 | 3 | 0 |
33007 | 33007 | 2020-04-04 | Waynesboro city | Virginia | 51820 | 2 | 0 |
35445 | 35445 | 2020-04-05 | Waynesboro city | Virginia | 51820 | 2 | 0 |
37929 | 37929 | 2020-04-06 | Waynesboro city | Virginia | 51820 | 3 | 0 |
40464 | 40464 | 2020-04-07 | Waynesboro city | Virginia | 51820 | 2 | 0 |
43033 | 43033 | 2020-04-08 | Waynesboro city | Virginia | 51820 | 2 | 0 |
45629 | 45629 | 2020-04-09 | Waynesboro city | Virginia | 51820 | 3 | 0 |
48256 | 48256 | 2020-04-10 | Waynesboro city | Virginia | 51820 | 5 | 0 |
50914 | 50914 | 2020-04-11 | Waynesboro city | Virginia | 51820 | 5 | 0 |
53589 | 53589 | 2020-04-12 | Waynesboro city | Virginia | 51820 | 5 | 0 |
56279 | 56279 | 2020-04-13 | Waynesboro city | Virginia | 51820 | 6 | 0 |
58985 | 58985 | 2020-04-14 | Waynesboro city | Virginia | 51820 | 6 | 0 |
61704 | 61704 | 2020-04-15 | Waynesboro city | Virginia | 51820 | 6 | 0 |
64437 | 64437 | 2020-04-16 | Waynesboro city | Virginia | 51820 | 6 | 0 |
67185 | 67185 | 2020-04-17 | Waynesboro city | Virginia | 51820 | 7 | 0 |
69947 | 69947 | 2020-04-18 | Waynesboro city | Virginia | 51820 | 7 | 0 |
72717 | 72717 | 2020-04-19 | Waynesboro city | Virginia | 51820 | 7 | 0 |
75493 | 75493 | 2020-04-20 | Waynesboro city | Virginia | 51820 | 8 | 0 |
78276 | 78276 | 2020-04-21 | Waynesboro city | Virginia | 51820 | 8 | 0 |
81069 | 81069 | 2020-04-22 | Waynesboro city | Virginia | 51820 | 8 | 0 |
83870 | 83870 | 2020-04-23 | Waynesboro city | Virginia | 51820 | 9 | 0 |
86677 | 86677 | 2020-04-24 | Waynesboro city | Virginia | 51820 | 10 | 0 |
89492 | 89492 | 2020-04-25 | Waynesboro city | Virginia | 51820 | 10 | 0 |
92309 | 92309 | 2020-04-26 | Waynesboro city | Virginia | 51820 | 10 | 0 |
95138 | 95138 | 2020-04-27 | Waynesboro city | Virginia | 51820 | 11 | 0 |
97983 | 97983 | 2020-04-28 | Waynesboro city | Virginia | 51820 | 11 | 0 |
100833 | 100833 | 2020-04-29 | Waynesboro city | Virginia | 51820 | 11 | 0 |
103688 | 103688 | 2020-04-30 | Waynesboro city | Virginia | 51820 | 11 | 0 |
106552 | 106552 | 2020-05-01 | Waynesboro city | Virginia | 51820 | 13 | 0 |
109421 | 109421 | 2020-05-02 | Waynesboro city | Virginia | 51820 | 14 | 0 |
112295 | 112295 | 2020-05-03 | Waynesboro city | Virginia | 51820 | 14 | 0 |
115178 | 115178 | 2020-05-04 | Waynesboro city | Virginia | 51820 | 14 | 0 |
118137 | 118137 | 2020-05-05 | Waynesboro city | Virginia | 51820 | 16 | 0 |
121101 | 121101 | 2020-05-06 | Waynesboro city | Virginia | 51820 | 16 | 0 |
124081 | 124081 | 2020-05-07 | Waynesboro city | Virginia | 51820 | 20 | 0 |
127066 | 127066 | 2020-05-08 | Waynesboro city | Virginia | 51820 | 20 | 0 |
130056 | 130056 | 2020-05-09 | Waynesboro city | Virginia | 51820 | 21 | 0 |
133046 | 133046 | 2020-05-10 | Waynesboro city | Virginia | 51820 | 21 | 0 |
136036 | 136036 | 2020-05-11 | Waynesboro city | Virginia | 51820 | 21 | 0 |
139027 | 139027 | 2020-05-12 | Waynesboro city | Virginia | 51820 | 21 | 0 |
142023 | 142023 | 2020-05-13 | Waynesboro city | Virginia | 51820 | 21 | 0 |
145020 | 145020 | 2020-05-14 | Waynesboro city | Virginia | 51820 | 21 | 0 |
148023 | 148023 | 2020-05-15 | Waynesboro city | Virginia | 51820 | 22 | 0 |
151032 | 151032 | 2020-05-16 | Waynesboro city | Virginia | 51820 | 22 | 0 |
154043 | 154043 | 2020-05-17 | Waynesboro city | Virginia | 51820 | 22 | 0 |
157060 | 157060 | 2020-05-18 | Waynesboro city | Virginia | 51820 | 24 | 0 |
160084 | 160084 | 2020-05-19 | Waynesboro city | Virginia | 51820 | 28 | 0 |
163112 | 163112 | 2020-05-20 | Waynesboro city | Virginia | 51820 | 29 | 0 |
166141 | 166141 | 2020-05-21 | Waynesboro city | Virginia | 51820 | 33 | 0 |
169177 | 169177 | 2020-05-22 | Waynesboro city | Virginia | 51820 | 36 | 0 |
172218 | 172218 | 2020-05-23 | Waynesboro city | Virginia | 51820 | 38 | 0 |
175261 | 175261 | 2020-05-24 | Waynesboro city | Virginia | 51820 | 38 | 0 |
178306 | 178306 | 2020-05-25 | Waynesboro city | Virginia | 51820 | 39 | 0 |
181350 | 181350 | 2020-05-26 | Waynesboro city | Virginia | 51820 | 41 | 0 |
184401 | 184401 | 2020-05-27 | Waynesboro city | Virginia | 51820 | 41 | 0 |
187458 | 187458 | 2020-05-28 | Waynesboro city | Virginia | 51820 | 41 | 0 |
190522 | 190522 | 2020-05-29 | Waynesboro city | Virginia | 51820 | 41 | 0 |
193588 | 193588 | 2020-05-30 | Waynesboro city | Virginia | 51820 | 43 | 0 |
196658 | 196658 | 2020-05-31 | Waynesboro city | Virginia | 51820 | 46 | 0 |
199731 | 199731 | 2020-06-01 | Waynesboro city | Virginia | 51820 | 47 | 0 |
202807 | 202807 | 2020-06-02 | Waynesboro city | Virginia | 51820 | 47 | 0 |
205886 | 205886 | 2020-06-03 | Waynesboro city | Virginia | 51820 | 47 | 0 |
208968 | 208968 | 2020-06-04 | Waynesboro city | Virginia | 51820 | 47 | 0 |
212053 | 212053 | 2020-06-05 | Waynesboro city | Virginia | 51820 | 48 | 0 |
215140 | 215140 | 2020-06-06 | Waynesboro city | Virginia | 51820 | 49 | 0 |
218230 | 218230 | 2020-06-07 | Waynesboro city | Virginia | 51820 | 49 | 0 |
221322 | 221322 | 2020-06-08 | Waynesboro city | Virginia | 51820 | 49 | 0 |
224418 | 224418 | 2020-06-09 | Waynesboro city | Virginia | 51820 | 50 | 0 |
227518 | 227518 | 2020-06-10 | Waynesboro city | Virginia | 51820 | 51 | 0 |
230622 | 230622 | 2020-06-11 | Waynesboro city | Virginia | 51820 | 53 | 0 |
233727 | 233727 | 2020-06-12 | Waynesboro city | Virginia | 51820 | 53 | 0 |
236834 | 236834 | 2020-06-13 | Waynesboro city | Virginia | 51820 | 53 | 0 |
239942 | 239942 | 2020-06-14 | Waynesboro city | Virginia | 51820 | 53 | 0 |
243053 | 243053 | 2020-06-15 | Waynesboro city | Virginia | 51820 | 54 | 0 |
246166 | 246166 | 2020-06-16 | Waynesboro city | Virginia | 51820 | 55 | 0 |
249278 | 249278 | 2020-06-17 | Waynesboro city | Virginia | 51820 | 58 | 0 |
252393 | 252393 | 2020-06-18 | Waynesboro city | Virginia | 51820 | 61 | 0 |
255512 | 255512 | 2020-06-19 | Waynesboro city | Virginia | 51820 | 61 | 0 |
258639 | 258639 | 2020-06-20 | Waynesboro city | Virginia | 51820 | 60 | 0 |
261766 | 261766 | 2020-06-21 | Waynesboro city | Virginia | 51820 | 63 | 0 |
264895 | 264895 | 2020-06-22 | Waynesboro city | Virginia | 51820 | 63 | 0 |
268024 | 268024 | 2020-06-23 | Waynesboro city | Virginia | 51820 | 66 | 0 |
271158 | 271158 | 2020-06-24 | Waynesboro city | Virginia | 51820 | 67 | 0 |
274298 | 274298 | 2020-06-25 | Waynesboro city | Virginia | 51820 | 70 | 0 |
277446 | 277446 | 2020-06-26 | Waynesboro city | Virginia | 51820 | 73 | 0 |
280594 | 280594 | 2020-06-27 | Waynesboro city | Virginia | 51820 | 74 | 0 |
283740 | 283740 | 2020-06-28 | Waynesboro city | Virginia | 51820 | 77 | 0 |
286886 | 286886 | 2020-06-29 | Waynesboro city | Virginia | 51820 | 81 | 0 |
290036 | 290036 | 2020-06-30 | Waynesboro city | Virginia | 51820 | 82 | 0 |
293189 | 293189 | 2020-07-01 | Waynesboro city | Virginia | 51820 | 84 | 0 |
296344 | 296344 | 2020-07-02 | Waynesboro city | Virginia | 51820 | 86 | 0 |
299506 | 299506 | 2020-07-03 | Waynesboro city | Virginia | 51820 | 89 | 0 |
302670 | 302670 | 2020-07-04 | Waynesboro city | Virginia | 51820 | 91 | 0 |
305834 | 305834 | 2020-07-05 | Waynesboro city | Virginia | 51820 | 92 | 0 |
309002 | 309002 | 2020-07-06 | Waynesboro city | Virginia | 51820 | 94 | 0 |
312171 | 312171 | 2020-07-07 | Waynesboro city | Virginia | 51820 | 102 | 0 |
315346 | 315346 | 2020-07-08 | Waynesboro city | Virginia | 51820 | 113 | 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);