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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388959 | 388959 | 2020-07-31 | Waynesboro city | Virginia | 51820 | 166 | 2 |
385742 | 385742 | 2020-07-30 | Waynesboro city | Virginia | 51820 | 165 | 2 |
382524 | 382524 | 2020-07-29 | Waynesboro city | Virginia | 51820 | 165 | 2 |
379307 | 379307 | 2020-07-28 | Waynesboro city | Virginia | 51820 | 164 | 2 |
376091 | 376091 | 2020-07-27 | Waynesboro city | Virginia | 51820 | 164 | 2 |
372877 | 372877 | 2020-07-26 | Waynesboro city | Virginia | 51820 | 163 | 2 |
369665 | 369665 | 2020-07-25 | Waynesboro city | Virginia | 51820 | 163 | 2 |
366456 | 366456 | 2020-07-24 | Waynesboro city | Virginia | 51820 | 160 | 2 |
363250 | 363250 | 2020-07-23 | Waynesboro city | Virginia | 51820 | 154 | 2 |
360044 | 360044 | 2020-07-22 | Waynesboro city | Virginia | 51820 | 150 | 2 |
356839 | 356839 | 2020-07-21 | Waynesboro city | Virginia | 51820 | 149 | 2 |
353636 | 353636 | 2020-07-20 | Waynesboro city | Virginia | 51820 | 142 | 1 |
350434 | 350434 | 2020-07-19 | Waynesboro city | Virginia | 51820 | 142 | 1 |
347233 | 347233 | 2020-07-18 | Waynesboro city | Virginia | 51820 | 142 | 1 |
344033 | 344033 | 2020-07-17 | Waynesboro city | Virginia | 51820 | 137 | 0 |
340834 | 340834 | 2020-07-16 | Waynesboro city | Virginia | 51820 | 133 | 0 |
337638 | 337638 | 2020-07-15 | Waynesboro city | Virginia | 51820 | 129 | 0 |
334443 | 334443 | 2020-07-14 | Waynesboro city | Virginia | 51820 | 126 | 0 |
331250 | 331250 | 2020-07-13 | Waynesboro city | Virginia | 51820 | 125 | 0 |
328064 | 328064 | 2020-07-12 | Waynesboro city | Virginia | 51820 | 123 | 0 |
324879 | 324879 | 2020-07-11 | Waynesboro city | Virginia | 51820 | 121 | 0 |
321698 | 321698 | 2020-07-10 | Waynesboro city | Virginia | 51820 | 117 | 0 |
318519 | 318519 | 2020-07-09 | Waynesboro city | Virginia | 51820 | 114 | 0 |
315346 | 315346 | 2020-07-08 | Waynesboro city | Virginia | 51820 | 113 | 0 |
312171 | 312171 | 2020-07-07 | Waynesboro city | Virginia | 51820 | 102 | 0 |
309002 | 309002 | 2020-07-06 | Waynesboro city | Virginia | 51820 | 94 | 0 |
305834 | 305834 | 2020-07-05 | Waynesboro city | Virginia | 51820 | 92 | 0 |
302670 | 302670 | 2020-07-04 | Waynesboro city | Virginia | 51820 | 91 | 0 |
299506 | 299506 | 2020-07-03 | Waynesboro city | Virginia | 51820 | 89 | 0 |
296344 | 296344 | 2020-07-02 | Waynesboro city | Virginia | 51820 | 86 | 0 |
293189 | 293189 | 2020-07-01 | Waynesboro city | Virginia | 51820 | 84 | 0 |
290036 | 290036 | 2020-06-30 | Waynesboro city | Virginia | 51820 | 82 | 0 |
286886 | 286886 | 2020-06-29 | Waynesboro city | Virginia | 51820 | 81 | 0 |
283740 | 283740 | 2020-06-28 | Waynesboro city | Virginia | 51820 | 77 | 0 |
280594 | 280594 | 2020-06-27 | Waynesboro city | Virginia | 51820 | 74 | 0 |
277446 | 277446 | 2020-06-26 | Waynesboro city | Virginia | 51820 | 73 | 0 |
274298 | 274298 | 2020-06-25 | Waynesboro city | Virginia | 51820 | 70 | 0 |
271158 | 271158 | 2020-06-24 | Waynesboro city | Virginia | 51820 | 67 | 0 |
268024 | 268024 | 2020-06-23 | Waynesboro city | Virginia | 51820 | 66 | 0 |
264895 | 264895 | 2020-06-22 | Waynesboro city | Virginia | 51820 | 63 | 0 |
261766 | 261766 | 2020-06-21 | Waynesboro city | Virginia | 51820 | 63 | 0 |
258639 | 258639 | 2020-06-20 | Waynesboro city | Virginia | 51820 | 60 | 0 |
255512 | 255512 | 2020-06-19 | Waynesboro city | Virginia | 51820 | 61 | 0 |
252393 | 252393 | 2020-06-18 | Waynesboro city | Virginia | 51820 | 61 | 0 |
249278 | 249278 | 2020-06-17 | Waynesboro city | Virginia | 51820 | 58 | 0 |
246166 | 246166 | 2020-06-16 | Waynesboro city | Virginia | 51820 | 55 | 0 |
243053 | 243053 | 2020-06-15 | Waynesboro city | Virginia | 51820 | 54 | 0 |
239942 | 239942 | 2020-06-14 | Waynesboro city | Virginia | 51820 | 53 | 0 |
236834 | 236834 | 2020-06-13 | Waynesboro city | Virginia | 51820 | 53 | 0 |
233727 | 233727 | 2020-06-12 | Waynesboro city | Virginia | 51820 | 53 | 0 |
230622 | 230622 | 2020-06-11 | Waynesboro city | Virginia | 51820 | 53 | 0 |
227518 | 227518 | 2020-06-10 | Waynesboro city | Virginia | 51820 | 51 | 0 |
224418 | 224418 | 2020-06-09 | Waynesboro city | Virginia | 51820 | 50 | 0 |
221322 | 221322 | 2020-06-08 | Waynesboro city | Virginia | 51820 | 49 | 0 |
218230 | 218230 | 2020-06-07 | Waynesboro city | Virginia | 51820 | 49 | 0 |
215140 | 215140 | 2020-06-06 | Waynesboro city | Virginia | 51820 | 49 | 0 |
212053 | 212053 | 2020-06-05 | Waynesboro city | Virginia | 51820 | 48 | 0 |
208968 | 208968 | 2020-06-04 | Waynesboro city | Virginia | 51820 | 47 | 0 |
205886 | 205886 | 2020-06-03 | Waynesboro city | Virginia | 51820 | 47 | 0 |
202807 | 202807 | 2020-06-02 | Waynesboro city | Virginia | 51820 | 47 | 0 |
199731 | 199731 | 2020-06-01 | Waynesboro city | Virginia | 51820 | 47 | 0 |
196658 | 196658 | 2020-05-31 | Waynesboro city | Virginia | 51820 | 46 | 0 |
193588 | 193588 | 2020-05-30 | Waynesboro city | Virginia | 51820 | 43 | 0 |
190522 | 190522 | 2020-05-29 | Waynesboro city | Virginia | 51820 | 41 | 0 |
187458 | 187458 | 2020-05-28 | Waynesboro city | Virginia | 51820 | 41 | 0 |
184401 | 184401 | 2020-05-27 | Waynesboro city | Virginia | 51820 | 41 | 0 |
181350 | 181350 | 2020-05-26 | Waynesboro city | Virginia | 51820 | 41 | 0 |
178306 | 178306 | 2020-05-25 | Waynesboro city | Virginia | 51820 | 39 | 0 |
175261 | 175261 | 2020-05-24 | Waynesboro city | Virginia | 51820 | 38 | 0 |
172218 | 172218 | 2020-05-23 | Waynesboro city | Virginia | 51820 | 38 | 0 |
169177 | 169177 | 2020-05-22 | Waynesboro city | Virginia | 51820 | 36 | 0 |
166141 | 166141 | 2020-05-21 | Waynesboro city | Virginia | 51820 | 33 | 0 |
163112 | 163112 | 2020-05-20 | Waynesboro city | Virginia | 51820 | 29 | 0 |
160084 | 160084 | 2020-05-19 | Waynesboro city | Virginia | 51820 | 28 | 0 |
157060 | 157060 | 2020-05-18 | Waynesboro city | Virginia | 51820 | 24 | 0 |
154043 | 154043 | 2020-05-17 | Waynesboro city | Virginia | 51820 | 22 | 0 |
151032 | 151032 | 2020-05-16 | Waynesboro city | Virginia | 51820 | 22 | 0 |
148023 | 148023 | 2020-05-15 | Waynesboro city | Virginia | 51820 | 22 | 0 |
145020 | 145020 | 2020-05-14 | Waynesboro city | Virginia | 51820 | 21 | 0 |
142023 | 142023 | 2020-05-13 | Waynesboro city | Virginia | 51820 | 21 | 0 |
139027 | 139027 | 2020-05-12 | Waynesboro city | Virginia | 51820 | 21 | 0 |
136036 | 136036 | 2020-05-11 | Waynesboro city | Virginia | 51820 | 21 | 0 |
133046 | 133046 | 2020-05-10 | Waynesboro city | Virginia | 51820 | 21 | 0 |
130056 | 130056 | 2020-05-09 | Waynesboro city | Virginia | 51820 | 21 | 0 |
127066 | 127066 | 2020-05-08 | Waynesboro city | Virginia | 51820 | 20 | 0 |
124081 | 124081 | 2020-05-07 | Waynesboro city | Virginia | 51820 | 20 | 0 |
121101 | 121101 | 2020-05-06 | Waynesboro city | Virginia | 51820 | 16 | 0 |
118137 | 118137 | 2020-05-05 | Waynesboro city | Virginia | 51820 | 16 | 0 |
115178 | 115178 | 2020-05-04 | Waynesboro city | Virginia | 51820 | 14 | 0 |
112295 | 112295 | 2020-05-03 | Waynesboro city | Virginia | 51820 | 14 | 0 |
109421 | 109421 | 2020-05-02 | Waynesboro city | Virginia | 51820 | 14 | 0 |
106552 | 106552 | 2020-05-01 | Waynesboro city | Virginia | 51820 | 13 | 0 |
103688 | 103688 | 2020-04-30 | Waynesboro city | Virginia | 51820 | 11 | 0 |
100833 | 100833 | 2020-04-29 | Waynesboro city | Virginia | 51820 | 11 | 0 |
97983 | 97983 | 2020-04-28 | Waynesboro city | Virginia | 51820 | 11 | 0 |
95138 | 95138 | 2020-04-27 | Waynesboro city | Virginia | 51820 | 11 | 0 |
92309 | 92309 | 2020-04-26 | Waynesboro city | Virginia | 51820 | 10 | 0 |
89492 | 89492 | 2020-04-25 | Waynesboro city | Virginia | 51820 | 10 | 0 |
86677 | 86677 | 2020-04-24 | Waynesboro city | Virginia | 51820 | 10 | 0 |
83870 | 83870 | 2020-04-23 | Waynesboro city | Virginia | 51820 | 9 | 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);