ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
697 rows where fips = 51051 and state = "Virginia" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
246073 | 246073 | 2020-06-16 | Dickenson | Virginia | 51051 | 1 | 0 |
249185 | 249185 | 2020-06-17 | Dickenson | Virginia | 51051 | 1 | 0 |
252300 | 252300 | 2020-06-18 | Dickenson | Virginia | 51051 | 1 | 0 |
255419 | 255419 | 2020-06-19 | Dickenson | Virginia | 51051 | 1 | 0 |
258546 | 258546 | 2020-06-20 | Dickenson | Virginia | 51051 | 1 | 0 |
261673 | 261673 | 2020-06-21 | Dickenson | Virginia | 51051 | 1 | 0 |
264802 | 264802 | 2020-06-22 | Dickenson | Virginia | 51051 | 1 | 0 |
267931 | 267931 | 2020-06-23 | Dickenson | Virginia | 51051 | 1 | 0 |
271065 | 271065 | 2020-06-24 | Dickenson | Virginia | 51051 | 1 | 0 |
274205 | 274205 | 2020-06-25 | Dickenson | Virginia | 51051 | 1 | 0 |
277353 | 277353 | 2020-06-26 | Dickenson | Virginia | 51051 | 1 | 0 |
280501 | 280501 | 2020-06-27 | Dickenson | Virginia | 51051 | 3 | 0 |
283647 | 283647 | 2020-06-28 | Dickenson | Virginia | 51051 | 3 | 0 |
286793 | 286793 | 2020-06-29 | Dickenson | Virginia | 51051 | 4 | 0 |
289943 | 289943 | 2020-06-30 | Dickenson | Virginia | 51051 | 4 | 0 |
293096 | 293096 | 2020-07-01 | Dickenson | Virginia | 51051 | 4 | 0 |
296251 | 296251 | 2020-07-02 | Dickenson | Virginia | 51051 | 5 | 0 |
299413 | 299413 | 2020-07-03 | Dickenson | Virginia | 51051 | 5 | 0 |
302577 | 302577 | 2020-07-04 | Dickenson | Virginia | 51051 | 5 | 0 |
305741 | 305741 | 2020-07-05 | Dickenson | Virginia | 51051 | 5 | 0 |
308909 | 308909 | 2020-07-06 | Dickenson | Virginia | 51051 | 5 | 0 |
312078 | 312078 | 2020-07-07 | Dickenson | Virginia | 51051 | 5 | 0 |
315253 | 315253 | 2020-07-08 | Dickenson | Virginia | 51051 | 5 | 0 |
318426 | 318426 | 2020-07-09 | Dickenson | Virginia | 51051 | 5 | 0 |
321605 | 321605 | 2020-07-10 | Dickenson | Virginia | 51051 | 5 | 0 |
324786 | 324786 | 2020-07-11 | Dickenson | Virginia | 51051 | 5 | 0 |
327971 | 327971 | 2020-07-12 | Dickenson | Virginia | 51051 | 6 | 0 |
331157 | 331157 | 2020-07-13 | Dickenson | Virginia | 51051 | 6 | 0 |
334350 | 334350 | 2020-07-14 | Dickenson | Virginia | 51051 | 6 | 0 |
337545 | 337545 | 2020-07-15 | Dickenson | Virginia | 51051 | 7 | 0 |
340741 | 340741 | 2020-07-16 | Dickenson | Virginia | 51051 | 8 | 0 |
343940 | 343940 | 2020-07-17 | Dickenson | Virginia | 51051 | 9 | 0 |
347140 | 347140 | 2020-07-18 | Dickenson | Virginia | 51051 | 9 | 0 |
350341 | 350341 | 2020-07-19 | Dickenson | Virginia | 51051 | 10 | 0 |
353543 | 353543 | 2020-07-20 | Dickenson | Virginia | 51051 | 10 | 0 |
356746 | 356746 | 2020-07-21 | Dickenson | Virginia | 51051 | 10 | 0 |
359951 | 359951 | 2020-07-22 | Dickenson | Virginia | 51051 | 10 | 0 |
363157 | 363157 | 2020-07-23 | Dickenson | Virginia | 51051 | 11 | 0 |
366363 | 366363 | 2020-07-24 | Dickenson | Virginia | 51051 | 12 | 0 |
369572 | 369572 | 2020-07-25 | Dickenson | Virginia | 51051 | 12 | 0 |
372784 | 372784 | 2020-07-26 | Dickenson | Virginia | 51051 | 13 | 0 |
375998 | 375998 | 2020-07-27 | Dickenson | Virginia | 51051 | 16 | 0 |
379214 | 379214 | 2020-07-28 | Dickenson | Virginia | 51051 | 16 | 0 |
382431 | 382431 | 2020-07-29 | Dickenson | Virginia | 51051 | 18 | 0 |
385649 | 385649 | 2020-07-30 | Dickenson | Virginia | 51051 | 21 | 0 |
388866 | 388866 | 2020-07-31 | Dickenson | Virginia | 51051 | 22 | 0 |
392083 | 392083 | 2020-08-01 | Dickenson | Virginia | 51051 | 23 | 0 |
395299 | 395299 | 2020-08-02 | Dickenson | Virginia | 51051 | 24 | 0 |
398515 | 398515 | 2020-08-03 | Dickenson | Virginia | 51051 | 29 | 0 |
401731 | 401731 | 2020-08-04 | Dickenson | Virginia | 51051 | 29 | 0 |
404949 | 404949 | 2020-08-05 | Dickenson | Virginia | 51051 | 33 | 1 |
408169 | 408169 | 2020-08-06 | Dickenson | Virginia | 51051 | 38 | 1 |
411388 | 411388 | 2020-08-07 | Dickenson | Virginia | 51051 | 38 | 1 |
414608 | 414608 | 2020-08-08 | Dickenson | Virginia | 51051 | 40 | 1 |
417829 | 417829 | 2020-08-09 | Dickenson | Virginia | 51051 | 41 | 1 |
421050 | 421050 | 2020-08-10 | Dickenson | Virginia | 51051 | 43 | 1 |
424271 | 424271 | 2020-08-11 | Dickenson | Virginia | 51051 | 48 | 1 |
427495 | 427495 | 2020-08-12 | Dickenson | Virginia | 51051 | 49 | 1 |
430723 | 430723 | 2020-08-13 | Dickenson | Virginia | 51051 | 49 | 1 |
433948 | 433948 | 2020-08-14 | Dickenson | Virginia | 51051 | 49 | 1 |
437174 | 437174 | 2020-08-15 | Dickenson | Virginia | 51051 | 52 | 1 |
440400 | 440400 | 2020-08-16 | Dickenson | Virginia | 51051 | 52 | 1 |
443626 | 443626 | 2020-08-17 | Dickenson | Virginia | 51051 | 52 | 1 |
446853 | 446853 | 2020-08-18 | Dickenson | Virginia | 51051 | 54 | 1 |
450081 | 450081 | 2020-08-19 | Dickenson | Virginia | 51051 | 54 | 1 |
453309 | 453309 | 2020-08-20 | Dickenson | Virginia | 51051 | 55 | 1 |
456537 | 456537 | 2020-08-21 | Dickenson | Virginia | 51051 | 55 | 1 |
459764 | 459764 | 2020-08-22 | Dickenson | Virginia | 51051 | 55 | 1 |
462993 | 462993 | 2020-08-23 | Dickenson | Virginia | 51051 | 55 | 1 |
466222 | 466222 | 2020-08-24 | Dickenson | Virginia | 51051 | 55 | 1 |
469451 | 469451 | 2020-08-25 | Dickenson | Virginia | 51051 | 56 | 1 |
472683 | 472683 | 2020-08-26 | Dickenson | Virginia | 51051 | 58 | 1 |
475916 | 475916 | 2020-08-27 | Dickenson | Virginia | 51051 | 59 | 1 |
479149 | 479149 | 2020-08-28 | Dickenson | Virginia | 51051 | 63 | 1 |
482383 | 482383 | 2020-08-29 | Dickenson | Virginia | 51051 | 64 | 1 |
485618 | 485618 | 2020-08-30 | Dickenson | Virginia | 51051 | 65 | 1 |
488851 | 488851 | 2020-08-31 | Dickenson | Virginia | 51051 | 67 | 1 |
492084 | 492084 | 2020-09-01 | Dickenson | Virginia | 51051 | 67 | 1 |
495318 | 495318 | 2020-09-02 | Dickenson | Virginia | 51051 | 68 | 1 |
498551 | 498551 | 2020-09-03 | Dickenson | Virginia | 51051 | 68 | 1 |
501785 | 501785 | 2020-09-04 | Dickenson | Virginia | 51051 | 69 | 1 |
505019 | 505019 | 2020-09-05 | Dickenson | Virginia | 51051 | 69 | 1 |
508251 | 508251 | 2020-09-06 | Dickenson | Virginia | 51051 | 71 | 1 |
511484 | 511484 | 2020-09-07 | Dickenson | Virginia | 51051 | 71 | 1 |
514717 | 514717 | 2020-09-08 | Dickenson | Virginia | 51051 | 71 | 1 |
517952 | 517952 | 2020-09-09 | Dickenson | Virginia | 51051 | 74 | 1 |
521189 | 521189 | 2020-09-10 | Dickenson | Virginia | 51051 | 75 | 1 |
524425 | 524425 | 2020-09-11 | Dickenson | Virginia | 51051 | 76 | 1 |
527661 | 527661 | 2020-09-12 | Dickenson | Virginia | 51051 | 79 | 1 |
530898 | 530898 | 2020-09-13 | Dickenson | Virginia | 51051 | 79 | 1 |
534133 | 534133 | 2020-09-14 | Dickenson | Virginia | 51051 | 79 | 1 |
537369 | 537369 | 2020-09-15 | Dickenson | Virginia | 51051 | 79 | 1 |
540606 | 540606 | 2020-09-16 | Dickenson | Virginia | 51051 | 79 | 1 |
543842 | 543842 | 2020-09-17 | Dickenson | Virginia | 51051 | 81 | 1 |
547079 | 547079 | 2020-09-18 | Dickenson | Virginia | 51051 | 85 | 1 |
550318 | 550318 | 2020-09-19 | Dickenson | Virginia | 51051 | 87 | 1 |
553557 | 553557 | 2020-09-20 | Dickenson | Virginia | 51051 | 88 | 1 |
556794 | 556794 | 2020-09-21 | Dickenson | Virginia | 51051 | 89 | 1 |
560030 | 560030 | 2020-09-22 | Dickenson | Virginia | 51051 | 91 | 1 |
563269 | 563269 | 2020-09-23 | Dickenson | Virginia | 51051 | 93 | 1 |
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);