ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
735 rows where fips = 51580 and state = "Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
129959 | 129959 | 2020-05-09 | Covington city | Virginia | 51580 | 1 | 0 |
132949 | 132949 | 2020-05-10 | Covington city | Virginia | 51580 | 1 | 0 |
135939 | 135939 | 2020-05-11 | Covington city | Virginia | 51580 | 1 | 0 |
138930 | 138930 | 2020-05-12 | Covington city | Virginia | 51580 | 1 | 0 |
141926 | 141926 | 2020-05-13 | Covington city | Virginia | 51580 | 1 | 0 |
144923 | 144923 | 2020-05-14 | Covington city | Virginia | 51580 | 2 | 0 |
147926 | 147926 | 2020-05-15 | Covington city | Virginia | 51580 | 2 | 0 |
150935 | 150935 | 2020-05-16 | Covington city | Virginia | 51580 | 2 | 0 |
153946 | 153946 | 2020-05-17 | Covington city | Virginia | 51580 | 2 | 0 |
156963 | 156963 | 2020-05-18 | Covington city | Virginia | 51580 | 2 | 0 |
159987 | 159987 | 2020-05-19 | Covington city | Virginia | 51580 | 2 | 0 |
163015 | 163015 | 2020-05-20 | Covington city | Virginia | 51580 | 3 | 0 |
166044 | 166044 | 2020-05-21 | Covington city | Virginia | 51580 | 3 | 0 |
169080 | 169080 | 2020-05-22 | Covington city | Virginia | 51580 | 3 | 0 |
172121 | 172121 | 2020-05-23 | Covington city | Virginia | 51580 | 3 | 0 |
175164 | 175164 | 2020-05-24 | Covington city | Virginia | 51580 | 3 | 0 |
178209 | 178209 | 2020-05-25 | Covington city | Virginia | 51580 | 3 | 0 |
181253 | 181253 | 2020-05-26 | Covington city | Virginia | 51580 | 3 | 0 |
184304 | 184304 | 2020-05-27 | Covington city | Virginia | 51580 | 3 | 0 |
187361 | 187361 | 2020-05-28 | Covington city | Virginia | 51580 | 3 | 0 |
190425 | 190425 | 2020-05-29 | Covington city | Virginia | 51580 | 3 | 0 |
193491 | 193491 | 2020-05-30 | Covington city | Virginia | 51580 | 4 | 0 |
196561 | 196561 | 2020-05-31 | Covington city | Virginia | 51580 | 4 | 0 |
199634 | 199634 | 2020-06-01 | Covington city | Virginia | 51580 | 4 | 0 |
202710 | 202710 | 2020-06-02 | Covington city | Virginia | 51580 | 4 | 0 |
205789 | 205789 | 2020-06-03 | Covington city | Virginia | 51580 | 4 | 0 |
208871 | 208871 | 2020-06-04 | Covington city | Virginia | 51580 | 4 | 0 |
211956 | 211956 | 2020-06-05 | Covington city | Virginia | 51580 | 4 | 0 |
215043 | 215043 | 2020-06-06 | Covington city | Virginia | 51580 | 4 | 0 |
218133 | 218133 | 2020-06-07 | Covington city | Virginia | 51580 | 4 | 0 |
221225 | 221225 | 2020-06-08 | Covington city | Virginia | 51580 | 4 | 0 |
224321 | 224321 | 2020-06-09 | Covington city | Virginia | 51580 | 4 | 0 |
227421 | 227421 | 2020-06-10 | Covington city | Virginia | 51580 | 4 | 0 |
230525 | 230525 | 2020-06-11 | Covington city | Virginia | 51580 | 4 | 0 |
233630 | 233630 | 2020-06-12 | Covington city | Virginia | 51580 | 4 | 0 |
236737 | 236737 | 2020-06-13 | Covington city | Virginia | 51580 | 4 | 0 |
239845 | 239845 | 2020-06-14 | Covington city | Virginia | 51580 | 4 | 0 |
242956 | 242956 | 2020-06-15 | Covington city | Virginia | 51580 | 4 | 0 |
246068 | 246068 | 2020-06-16 | Covington city | Virginia | 51580 | 4 | 0 |
249180 | 249180 | 2020-06-17 | Covington city | Virginia | 51580 | 4 | 0 |
252295 | 252295 | 2020-06-18 | Covington city | Virginia | 51580 | 4 | 0 |
255414 | 255414 | 2020-06-19 | Covington city | Virginia | 51580 | 4 | 0 |
258541 | 258541 | 2020-06-20 | Covington city | Virginia | 51580 | 4 | 0 |
261668 | 261668 | 2020-06-21 | Covington city | Virginia | 51580 | 4 | 0 |
264797 | 264797 | 2020-06-22 | Covington city | Virginia | 51580 | 4 | 0 |
267926 | 267926 | 2020-06-23 | Covington city | Virginia | 51580 | 4 | 0 |
271060 | 271060 | 2020-06-24 | Covington city | Virginia | 51580 | 4 | 0 |
274200 | 274200 | 2020-06-25 | Covington city | Virginia | 51580 | 3 | 0 |
277348 | 277348 | 2020-06-26 | Covington city | Virginia | 51580 | 3 | 0 |
280496 | 280496 | 2020-06-27 | Covington city | Virginia | 51580 | 3 | 0 |
283642 | 283642 | 2020-06-28 | Covington city | Virginia | 51580 | 3 | 0 |
286788 | 286788 | 2020-06-29 | Covington city | Virginia | 51580 | 3 | 0 |
289938 | 289938 | 2020-06-30 | Covington city | Virginia | 51580 | 5 | 0 |
293091 | 293091 | 2020-07-01 | Covington city | Virginia | 51580 | 5 | 0 |
296246 | 296246 | 2020-07-02 | Covington city | Virginia | 51580 | 5 | 0 |
299408 | 299408 | 2020-07-03 | Covington city | Virginia | 51580 | 5 | 0 |
302572 | 302572 | 2020-07-04 | Covington city | Virginia | 51580 | 5 | 0 |
305736 | 305736 | 2020-07-05 | Covington city | Virginia | 51580 | 5 | 0 |
308904 | 308904 | 2020-07-06 | Covington city | Virginia | 51580 | 5 | 0 |
312073 | 312073 | 2020-07-07 | Covington city | Virginia | 51580 | 5 | 0 |
315248 | 315248 | 2020-07-08 | Covington city | Virginia | 51580 | 5 | 0 |
318421 | 318421 | 2020-07-09 | Covington city | Virginia | 51580 | 5 | 0 |
321600 | 321600 | 2020-07-10 | Covington city | Virginia | 51580 | 5 | 0 |
324781 | 324781 | 2020-07-11 | Covington city | Virginia | 51580 | 5 | 0 |
327966 | 327966 | 2020-07-12 | Covington city | Virginia | 51580 | 5 | 0 |
331152 | 331152 | 2020-07-13 | Covington city | Virginia | 51580 | 5 | 0 |
334345 | 334345 | 2020-07-14 | Covington city | Virginia | 51580 | 5 | 0 |
337540 | 337540 | 2020-07-15 | Covington city | Virginia | 51580 | 5 | 0 |
340736 | 340736 | 2020-07-16 | Covington city | Virginia | 51580 | 5 | 0 |
343935 | 343935 | 2020-07-17 | Covington city | Virginia | 51580 | 6 | 0 |
347135 | 347135 | 2020-07-18 | Covington city | Virginia | 51580 | 6 | 0 |
350336 | 350336 | 2020-07-19 | Covington city | Virginia | 51580 | 7 | 0 |
353538 | 353538 | 2020-07-20 | Covington city | Virginia | 51580 | 7 | 0 |
356741 | 356741 | 2020-07-21 | Covington city | Virginia | 51580 | 7 | 0 |
359946 | 359946 | 2020-07-22 | Covington city | Virginia | 51580 | 7 | 0 |
363152 | 363152 | 2020-07-23 | Covington city | Virginia | 51580 | 7 | 0 |
366358 | 366358 | 2020-07-24 | Covington city | Virginia | 51580 | 8 | 0 |
369567 | 369567 | 2020-07-25 | Covington city | Virginia | 51580 | 8 | 0 |
372779 | 372779 | 2020-07-26 | Covington city | Virginia | 51580 | 9 | 0 |
375993 | 375993 | 2020-07-27 | Covington city | Virginia | 51580 | 10 | 0 |
379209 | 379209 | 2020-07-28 | Covington city | Virginia | 51580 | 10 | 0 |
382426 | 382426 | 2020-07-29 | Covington city | Virginia | 51580 | 11 | 0 |
385644 | 385644 | 2020-07-30 | Covington city | Virginia | 51580 | 11 | 0 |
388861 | 388861 | 2020-07-31 | Covington city | Virginia | 51580 | 12 | 0 |
392078 | 392078 | 2020-08-01 | Covington city | Virginia | 51580 | 12 | 0 |
395294 | 395294 | 2020-08-02 | Covington city | Virginia | 51580 | 12 | 0 |
398510 | 398510 | 2020-08-03 | Covington city | Virginia | 51580 | 12 | 0 |
401726 | 401726 | 2020-08-04 | Covington city | Virginia | 51580 | 12 | 0 |
404944 | 404944 | 2020-08-05 | Covington city | Virginia | 51580 | 12 | 0 |
408164 | 408164 | 2020-08-06 | Covington city | Virginia | 51580 | 13 | 0 |
411383 | 411383 | 2020-08-07 | Covington city | Virginia | 51580 | 13 | 0 |
414603 | 414603 | 2020-08-08 | Covington city | Virginia | 51580 | 13 | 0 |
417824 | 417824 | 2020-08-09 | Covington city | Virginia | 51580 | 13 | 0 |
421045 | 421045 | 2020-08-10 | Covington city | Virginia | 51580 | 13 | 0 |
424266 | 424266 | 2020-08-11 | Covington city | Virginia | 51580 | 13 | 0 |
427490 | 427490 | 2020-08-12 | Covington city | Virginia | 51580 | 13 | 0 |
430718 | 430718 | 2020-08-13 | Covington city | Virginia | 51580 | 13 | 0 |
433943 | 433943 | 2020-08-14 | Covington city | Virginia | 51580 | 13 | 0 |
437169 | 437169 | 2020-08-15 | Covington city | Virginia | 51580 | 13 | 0 |
440395 | 440395 | 2020-08-16 | Covington city | Virginia | 51580 | 13 | 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);