ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 51041 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
767610 | 767610 | 2020-11-25 | Chesterfield | Virginia | 51041 | 8942 | 128 |
764365 | 764365 | 2020-11-24 | Chesterfield | Virginia | 51041 | 8827 | 127 |
761120 | 761120 | 2020-11-23 | Chesterfield | Virginia | 51041 | 8698 | 127 |
757875 | 757875 | 2020-11-22 | Chesterfield | Virginia | 51041 | 8617 | 127 |
754628 | 754628 | 2020-11-21 | Chesterfield | Virginia | 51041 | 8540 | 127 |
751382 | 751382 | 2020-11-20 | Chesterfield | Virginia | 51041 | 8451 | 124 |
748136 | 748136 | 2020-11-19 | Chesterfield | Virginia | 51041 | 8363 | 124 |
744890 | 744890 | 2020-11-18 | Chesterfield | Virginia | 51041 | 8295 | 123 |
741643 | 741643 | 2020-11-17 | Chesterfield | Virginia | 51041 | 8253 | 122 |
738396 | 738396 | 2020-11-16 | Chesterfield | Virginia | 51041 | 8169 | 121 |
735152 | 735152 | 2020-11-15 | Chesterfield | Virginia | 51041 | 8047 | 121 |
731906 | 731906 | 2020-11-14 | Chesterfield | Virginia | 51041 | 8011 | 121 |
728661 | 728661 | 2020-11-13 | Chesterfield | Virginia | 51041 | 7951 | 121 |
725418 | 725418 | 2020-11-12 | Chesterfield | Virginia | 51041 | 7924 | 121 |
722175 | 722175 | 2020-11-11 | Chesterfield | Virginia | 51041 | 7849 | 120 |
718932 | 718932 | 2020-11-10 | Chesterfield | Virginia | 51041 | 7761 | 120 |
715689 | 715689 | 2020-11-09 | Chesterfield | Virginia | 51041 | 7709 | 120 |
712445 | 712445 | 2020-11-08 | Chesterfield | Virginia | 51041 | 7619 | 120 |
709201 | 709201 | 2020-11-07 | Chesterfield | Virginia | 51041 | 7558 | 120 |
705957 | 705957 | 2020-11-06 | Chesterfield | Virginia | 51041 | 7481 | 120 |
702714 | 702714 | 2020-11-05 | Chesterfield | Virginia | 51041 | 7445 | 120 |
699471 | 699471 | 2020-11-04 | Chesterfield | Virginia | 51041 | 7407 | 120 |
696227 | 696227 | 2020-11-03 | Chesterfield | Virginia | 51041 | 7361 | 120 |
692985 | 692985 | 2020-11-02 | Chesterfield | Virginia | 51041 | 7320 | 120 |
689741 | 689741 | 2020-11-01 | Chesterfield | Virginia | 51041 | 7302 | 120 |
686496 | 686496 | 2020-10-31 | Chesterfield | Virginia | 51041 | 7274 | 120 |
683253 | 683253 | 2020-10-30 | Chesterfield | Virginia | 51041 | 7212 | 119 |
680010 | 680010 | 2020-10-29 | Chesterfield | Virginia | 51041 | 7162 | 118 |
676767 | 676767 | 2020-10-28 | Chesterfield | Virginia | 51041 | 7111 | 113 |
673524 | 673524 | 2020-10-27 | Chesterfield | Virginia | 51041 | 7058 | 106 |
670282 | 670282 | 2020-10-26 | Chesterfield | Virginia | 51041 | 7029 | 102 |
667039 | 667039 | 2020-10-25 | Chesterfield | Virginia | 51041 | 6980 | 102 |
663794 | 663794 | 2020-10-24 | Chesterfield | Virginia | 51041 | 6934 | 102 |
660550 | 660550 | 2020-10-23 | Chesterfield | Virginia | 51041 | 6869 | 101 |
657306 | 657306 | 2020-10-22 | Chesterfield | Virginia | 51041 | 6851 | 100 |
654061 | 654061 | 2020-10-21 | Chesterfield | Virginia | 51041 | 6796 | 100 |
650816 | 650816 | 2020-10-20 | Chesterfield | Virginia | 51041 | 6737 | 100 |
647572 | 647572 | 2020-10-19 | Chesterfield | Virginia | 51041 | 6695 | 99 |
644326 | 644326 | 2020-10-18 | Chesterfield | Virginia | 51041 | 6679 | 99 |
641078 | 641078 | 2020-10-17 | Chesterfield | Virginia | 51041 | 6662 | 99 |
637831 | 637831 | 2020-10-16 | Chesterfield | Virginia | 51041 | 6568 | 99 |
634586 | 634586 | 2020-10-15 | Chesterfield | Virginia | 51041 | 6546 | 98 |
631341 | 631341 | 2020-10-14 | Chesterfield | Virginia | 51041 | 6478 | 98 |
628097 | 628097 | 2020-10-13 | Chesterfield | Virginia | 51041 | 6458 | 98 |
624854 | 624854 | 2020-10-12 | Chesterfield | Virginia | 51041 | 6396 | 98 |
621611 | 621611 | 2020-10-11 | Chesterfield | Virginia | 51041 | 6364 | 98 |
618368 | 618368 | 2020-10-10 | Chesterfield | Virginia | 51041 | 6349 | 98 |
615126 | 615126 | 2020-10-09 | Chesterfield | Virginia | 51041 | 6303 | 98 |
611885 | 611885 | 2020-10-08 | Chesterfield | Virginia | 51041 | 6266 | 98 |
608643 | 608643 | 2020-10-07 | Chesterfield | Virginia | 51041 | 6207 | 98 |
605400 | 605400 | 2020-10-06 | Chesterfield | Virginia | 51041 | 6192 | 98 |
602158 | 602158 | 2020-10-05 | Chesterfield | Virginia | 51041 | 6180 | 98 |
598915 | 598915 | 2020-10-04 | Chesterfield | Virginia | 51041 | 6170 | 98 |
595672 | 595672 | 2020-10-03 | Chesterfield | Virginia | 51041 | 6132 | 98 |
592430 | 592430 | 2020-10-02 | Chesterfield | Virginia | 51041 | 6085 | 96 |
589190 | 589190 | 2020-10-01 | Chesterfield | Virginia | 51041 | 6057 | 95 |
585949 | 585949 | 2020-09-30 | Chesterfield | Virginia | 51041 | 6053 | 95 |
582709 | 582709 | 2020-09-29 | Chesterfield | Virginia | 51041 | 6036 | 95 |
579470 | 579470 | 2020-09-28 | Chesterfield | Virginia | 51041 | 6000 | 94 |
576229 | 576229 | 2020-09-27 | Chesterfield | Virginia | 51041 | 5985 | 94 |
572985 | 572985 | 2020-09-26 | Chesterfield | Virginia | 51041 | 5945 | 94 |
569743 | 569743 | 2020-09-25 | Chesterfield | Virginia | 51041 | 5916 | 94 |
566502 | 566502 | 2020-09-24 | Chesterfield | Virginia | 51041 | 5870 | 94 |
563261 | 563261 | 2020-09-23 | Chesterfield | Virginia | 51041 | 5851 | 94 |
560022 | 560022 | 2020-09-22 | Chesterfield | Virginia | 51041 | 5829 | 93 |
556786 | 556786 | 2020-09-21 | Chesterfield | Virginia | 51041 | 5797 | 91 |
553549 | 553549 | 2020-09-20 | Chesterfield | Virginia | 51041 | 5758 | 91 |
550310 | 550310 | 2020-09-19 | Chesterfield | Virginia | 51041 | 5724 | 90 |
547071 | 547071 | 2020-09-18 | Chesterfield | Virginia | 51041 | 5702 | 90 |
543834 | 543834 | 2020-09-17 | Chesterfield | Virginia | 51041 | 5656 | 91 |
540598 | 540598 | 2020-09-16 | Chesterfield | Virginia | 51041 | 5628 | 89 |
537361 | 537361 | 2020-09-15 | Chesterfield | Virginia | 51041 | 5593 | 87 |
534125 | 534125 | 2020-09-14 | Chesterfield | Virginia | 51041 | 5558 | 86 |
530890 | 530890 | 2020-09-13 | Chesterfield | Virginia | 51041 | 5540 | 85 |
527653 | 527653 | 2020-09-12 | Chesterfield | Virginia | 51041 | 5500 | 85 |
524417 | 524417 | 2020-09-11 | Chesterfield | Virginia | 51041 | 5450 | 85 |
521181 | 521181 | 2020-09-10 | Chesterfield | Virginia | 51041 | 5401 | 85 |
517944 | 517944 | 2020-09-09 | Chesterfield | Virginia | 51041 | 5347 | 85 |
514709 | 514709 | 2020-09-08 | Chesterfield | Virginia | 51041 | 5307 | 83 |
511476 | 511476 | 2020-09-07 | Chesterfield | Virginia | 51041 | 5264 | 83 |
508243 | 508243 | 2020-09-06 | Chesterfield | Virginia | 51041 | 5259 | 83 |
505011 | 505011 | 2020-09-05 | Chesterfield | Virginia | 51041 | 5251 | 83 |
501777 | 501777 | 2020-09-04 | Chesterfield | Virginia | 51041 | 5209 | 83 |
498543 | 498543 | 2020-09-03 | Chesterfield | Virginia | 51041 | 5185 | 83 |
495310 | 495310 | 2020-09-02 | Chesterfield | Virginia | 51041 | 5146 | 83 |
492076 | 492076 | 2020-09-01 | Chesterfield | Virginia | 51041 | 5106 | 83 |
488843 | 488843 | 2020-08-31 | Chesterfield | Virginia | 51041 | 5046 | 82 |
485610 | 485610 | 2020-08-30 | Chesterfield | Virginia | 51041 | 5027 | 82 |
482375 | 482375 | 2020-08-29 | Chesterfield | Virginia | 51041 | 5013 | 82 |
479141 | 479141 | 2020-08-28 | Chesterfield | Virginia | 51041 | 4974 | 82 |
475908 | 475908 | 2020-08-27 | Chesterfield | Virginia | 51041 | 4946 | 78 |
472675 | 472675 | 2020-08-26 | Chesterfield | Virginia | 51041 | 4915 | 77 |
469443 | 469443 | 2020-08-25 | Chesterfield | Virginia | 51041 | 4888 | 77 |
466214 | 466214 | 2020-08-24 | Chesterfield | Virginia | 51041 | 4867 | 76 |
462985 | 462985 | 2020-08-23 | Chesterfield | Virginia | 51041 | 4853 | 76 |
459756 | 459756 | 2020-08-22 | Chesterfield | Virginia | 51041 | 4815 | 76 |
456529 | 456529 | 2020-08-21 | Chesterfield | Virginia | 51041 | 4772 | 76 |
453301 | 453301 | 2020-08-20 | Chesterfield | Virginia | 51041 | 4747 | 76 |
450073 | 450073 | 2020-08-19 | Chesterfield | Virginia | 51041 | 4720 | 76 |
446845 | 446845 | 2020-08-18 | Chesterfield | Virginia | 51041 | 4684 | 81 |
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);