ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where county = "Buckingham", deaths = 8 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537352 | 537352 | 2020-09-15 | Buckingham | Virginia | 51029 | 670 | 8 |
534116 | 534116 | 2020-09-14 | Buckingham | Virginia | 51029 | 665 | 8 |
530881 | 530881 | 2020-09-13 | Buckingham | Virginia | 51029 | 665 | 8 |
527644 | 527644 | 2020-09-12 | Buckingham | Virginia | 51029 | 665 | 8 |
524408 | 524408 | 2020-09-11 | Buckingham | Virginia | 51029 | 665 | 8 |
521172 | 521172 | 2020-09-10 | Buckingham | Virginia | 51029 | 663 | 8 |
517935 | 517935 | 2020-09-09 | Buckingham | Virginia | 51029 | 657 | 8 |
514700 | 514700 | 2020-09-08 | Buckingham | Virginia | 51029 | 656 | 8 |
511467 | 511467 | 2020-09-07 | Buckingham | Virginia | 51029 | 656 | 8 |
508234 | 508234 | 2020-09-06 | Buckingham | Virginia | 51029 | 655 | 8 |
505002 | 505002 | 2020-09-05 | Buckingham | Virginia | 51029 | 655 | 8 |
501768 | 501768 | 2020-09-04 | Buckingham | Virginia | 51029 | 654 | 8 |
498534 | 498534 | 2020-09-03 | Buckingham | Virginia | 51029 | 651 | 8 |
495301 | 495301 | 2020-09-02 | Buckingham | Virginia | 51029 | 649 | 8 |
492067 | 492067 | 2020-09-01 | Buckingham | Virginia | 51029 | 648 | 8 |
488834 | 488834 | 2020-08-31 | Buckingham | Virginia | 51029 | 644 | 8 |
485601 | 485601 | 2020-08-30 | Buckingham | Virginia | 51029 | 644 | 8 |
482366 | 482366 | 2020-08-29 | Buckingham | Virginia | 51029 | 644 | 8 |
479132 | 479132 | 2020-08-28 | Buckingham | Virginia | 51029 | 644 | 8 |
475899 | 475899 | 2020-08-27 | Buckingham | Virginia | 51029 | 644 | 8 |
472666 | 472666 | 2020-08-26 | Buckingham | Virginia | 51029 | 640 | 8 |
469434 | 469434 | 2020-08-25 | Buckingham | Virginia | 51029 | 637 | 8 |
466205 | 466205 | 2020-08-24 | Buckingham | Virginia | 51029 | 634 | 8 |
462976 | 462976 | 2020-08-23 | Buckingham | Virginia | 51029 | 634 | 8 |
459747 | 459747 | 2020-08-22 | Buckingham | Virginia | 51029 | 634 | 8 |
456520 | 456520 | 2020-08-21 | Buckingham | Virginia | 51029 | 631 | 8 |
453292 | 453292 | 2020-08-20 | Buckingham | Virginia | 51029 | 629 | 8 |
450064 | 450064 | 2020-08-19 | Buckingham | Virginia | 51029 | 622 | 8 |
446836 | 446836 | 2020-08-18 | Buckingham | Virginia | 51029 | 622 | 8 |
443609 | 443609 | 2020-08-17 | Buckingham | Virginia | 51029 | 620 | 8 |
440383 | 440383 | 2020-08-16 | Buckingham | Virginia | 51029 | 617 | 8 |
437157 | 437157 | 2020-08-15 | Buckingham | Virginia | 51029 | 616 | 8 |
433931 | 433931 | 2020-08-14 | Buckingham | Virginia | 51029 | 613 | 8 |
430706 | 430706 | 2020-08-13 | Buckingham | Virginia | 51029 | 612 | 8 |
427478 | 427478 | 2020-08-12 | Buckingham | Virginia | 51029 | 611 | 8 |
424254 | 424254 | 2020-08-11 | Buckingham | Virginia | 51029 | 610 | 8 |
421033 | 421033 | 2020-08-10 | Buckingham | Virginia | 51029 | 605 | 8 |
417812 | 417812 | 2020-08-09 | Buckingham | Virginia | 51029 | 605 | 8 |
414591 | 414591 | 2020-08-08 | Buckingham | Virginia | 51029 | 605 | 8 |
411371 | 411371 | 2020-08-07 | Buckingham | Virginia | 51029 | 601 | 8 |
408152 | 408152 | 2020-08-06 | Buckingham | Virginia | 51029 | 598 | 8 |
404932 | 404932 | 2020-08-05 | Buckingham | Virginia | 51029 | 597 | 8 |
401714 | 401714 | 2020-08-04 | Buckingham | Virginia | 51029 | 596 | 8 |
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);