ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
810 rows where fips = 6095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
758406 | 758406 | 2020-11-23 | Solano | California | 6095 | 9750 | 81 |
755159 | 755159 | 2020-11-22 | Solano | California | 6095 | 9354 | 80 |
751913 | 751913 | 2020-11-21 | Solano | California | 6095 | 9354 | 80 |
748667 | 748667 | 2020-11-20 | Solano | California | 6095 | 9354 | 80 |
745421 | 745421 | 2020-11-19 | Solano | California | 6095 | 9296 | 80 |
742174 | 742174 | 2020-11-18 | Solano | California | 6095 | 9166 | 80 |
738927 | 738927 | 2020-11-17 | Solano | California | 6095 | 9093 | 80 |
735683 | 735683 | 2020-11-16 | Solano | California | 6095 | 8964 | 79 |
732437 | 732437 | 2020-11-15 | Solano | California | 6095 | 8734 | 79 |
729192 | 729192 | 2020-11-14 | Solano | California | 6095 | 8734 | 79 |
725949 | 725949 | 2020-11-13 | Solano | California | 6095 | 8734 | 79 |
722706 | 722706 | 2020-11-12 | Solano | California | 6095 | 8601 | 79 |
719463 | 719463 | 2020-11-11 | Solano | California | 6095 | 8435 | 79 |
716220 | 716220 | 2020-11-10 | Solano | California | 6095 | 8435 | 79 |
712976 | 712976 | 2020-11-09 | Solano | California | 6095 | 8371 | 79 |
709732 | 709732 | 2020-11-08 | Solano | California | 6095 | 8137 | 79 |
706488 | 706488 | 2020-11-07 | Solano | California | 6095 | 8137 | 79 |
703245 | 703245 | 2020-11-06 | Solano | California | 6095 | 8137 | 79 |
700002 | 700002 | 2020-11-05 | Solano | California | 6095 | 8001 | 76 |
696758 | 696758 | 2020-11-04 | Solano | California | 6095 | 7945 | 76 |
693516 | 693516 | 2020-11-03 | Solano | California | 6095 | 7854 | 76 |
690273 | 690273 | 2020-11-02 | Solano | California | 6095 | 7806 | 76 |
687028 | 687028 | 2020-11-01 | Solano | California | 6095 | 7639 | 76 |
683784 | 683784 | 2020-10-31 | Solano | California | 6095 | 7639 | 76 |
680541 | 680541 | 2020-10-30 | Solano | California | 6095 | 7639 | 76 |
677298 | 677298 | 2020-10-29 | Solano | California | 6095 | 7591 | 76 |
674055 | 674055 | 2020-10-28 | Solano | California | 6095 | 7485 | 76 |
670813 | 670813 | 2020-10-27 | Solano | California | 6095 | 7450 | 76 |
667570 | 667570 | 2020-10-26 | Solano | California | 6095 | 7389 | 76 |
664325 | 664325 | 2020-10-25 | Solano | California | 6095 | 7291 | 74 |
661081 | 661081 | 2020-10-24 | Solano | California | 6095 | 7291 | 74 |
657837 | 657837 | 2020-10-23 | Solano | California | 6095 | 7291 | 74 |
654592 | 654592 | 2020-10-22 | Solano | California | 6095 | 7254 | 74 |
651347 | 651347 | 2020-10-21 | Solano | California | 6095 | 7210 | 74 |
648103 | 648103 | 2020-10-20 | Solano | California | 6095 | 7176 | 74 |
644858 | 644858 | 2020-10-19 | Solano | California | 6095 | 7122 | 74 |
641610 | 641610 | 2020-10-18 | Solano | California | 6095 | 7014 | 74 |
638363 | 638363 | 2020-10-17 | Solano | California | 6095 | 7014 | 74 |
635118 | 635118 | 2020-10-16 | Solano | California | 6095 | 7014 | 74 |
631872 | 631872 | 2020-10-15 | Solano | California | 6095 | 6956 | 74 |
628628 | 628628 | 2020-10-14 | Solano | California | 6095 | 6913 | 74 |
625385 | 625385 | 2020-10-13 | Solano | California | 6095 | 6881 | 74 |
622142 | 622142 | 2020-10-12 | Solano | California | 6095 | 6755 | 74 |
618899 | 618899 | 2020-10-11 | Solano | California | 6095 | 6755 | 74 |
615657 | 615657 | 2020-10-10 | Solano | California | 6095 | 6755 | 74 |
612416 | 612416 | 2020-10-09 | Solano | California | 6095 | 6755 | 74 |
609174 | 609174 | 2020-10-08 | Solano | California | 6095 | 6713 | 74 |
605931 | 605931 | 2020-10-07 | Solano | California | 6095 | 6663 | 74 |
602689 | 602689 | 2020-10-06 | Solano | California | 6095 | 6629 | 72 |
599446 | 599446 | 2020-10-05 | Solano | California | 6095 | 6606 | 72 |
596203 | 596203 | 2020-10-04 | Solano | California | 6095 | 6525 | 71 |
592961 | 592961 | 2020-10-03 | Solano | California | 6095 | 6525 | 71 |
589721 | 589721 | 2020-10-02 | Solano | California | 6095 | 6525 | 71 |
586480 | 586480 | 2020-10-01 | Solano | California | 6095 | 6480 | 71 |
583240 | 583240 | 2020-09-30 | Solano | California | 6095 | 6450 | 71 |
580001 | 580001 | 2020-09-29 | Solano | California | 6095 | 6424 | 69 |
576760 | 576760 | 2020-09-28 | Solano | California | 6095 | 6405 | 65 |
573517 | 573517 | 2020-09-27 | Solano | California | 6095 | 6314 | 63 |
570275 | 570275 | 2020-09-26 | Solano | California | 6095 | 6314 | 63 |
567033 | 567033 | 2020-09-25 | Solano | California | 6095 | 6314 | 63 |
563793 | 563793 | 2020-09-24 | Solano | California | 6095 | 6283 | 63 |
560554 | 560554 | 2020-09-23 | Solano | California | 6095 | 6237 | 60 |
557318 | 557318 | 2020-09-22 | Solano | California | 6095 | 6199 | 57 |
554081 | 554081 | 2020-09-21 | Solano | California | 6095 | 6180 | 55 |
550842 | 550842 | 2020-09-20 | Solano | California | 6095 | 6090 | 55 |
547603 | 547603 | 2020-09-19 | Solano | California | 6095 | 6090 | 55 |
544365 | 544365 | 2020-09-18 | Solano | California | 6095 | 6090 | 55 |
541129 | 541129 | 2020-09-17 | Solano | California | 6095 | 6059 | 55 |
537892 | 537892 | 2020-09-16 | Solano | California | 6095 | 6012 | 52 |
534656 | 534656 | 2020-09-15 | Solano | California | 6095 | 5992 | 52 |
531421 | 531421 | 2020-09-14 | Solano | California | 6095 | 5942 | 50 |
528184 | 528184 | 2020-09-13 | Solano | California | 6095 | 5825 | 48 |
524948 | 524948 | 2020-09-12 | Solano | California | 6095 | 5825 | 48 |
521712 | 521712 | 2020-09-11 | Solano | California | 6095 | 5825 | 48 |
518475 | 518475 | 2020-09-10 | Solano | California | 6095 | 5810 | 48 |
515240 | 515240 | 2020-09-09 | Solano | California | 6095 | 5783 | 48 |
512007 | 512007 | 2020-09-08 | Solano | California | 6095 | 5767 | 48 |
508774 | 508774 | 2020-09-07 | Solano | California | 6095 | 5676 | 48 |
505542 | 505542 | 2020-09-06 | Solano | California | 6095 | 5676 | 48 |
502308 | 502308 | 2020-09-05 | Solano | California | 6095 | 5676 | 48 |
499074 | 499074 | 2020-09-04 | Solano | California | 6095 | 5676 | 48 |
495841 | 495841 | 2020-09-03 | Solano | California | 6095 | 5636 | 47 |
492607 | 492607 | 2020-09-02 | Solano | California | 6095 | 5593 | 47 |
489374 | 489374 | 2020-09-01 | Solano | California | 6095 | 5552 | 47 |
486141 | 486141 | 2020-08-31 | Solano | California | 6095 | 5517 | 47 |
482906 | 482906 | 2020-08-30 | Solano | California | 6095 | 5393 | 46 |
479672 | 479672 | 2020-08-29 | Solano | California | 6095 | 5393 | 46 |
476439 | 476439 | 2020-08-28 | Solano | California | 6095 | 5393 | 46 |
473206 | 473206 | 2020-08-27 | Solano | California | 6095 | 5333 | 46 |
469974 | 469974 | 2020-08-26 | Solano | California | 6095 | 5285 | 46 |
466745 | 466745 | 2020-08-25 | Solano | California | 6095 | 5236 | 46 |
463516 | 463516 | 2020-08-24 | Solano | California | 6095 | 5211 | 46 |
460287 | 460287 | 2020-08-23 | Solano | California | 6095 | 5053 | 44 |
457060 | 457060 | 2020-08-22 | Solano | California | 6095 | 5053 | 44 |
453832 | 453832 | 2020-08-21 | Solano | California | 6095 | 5053 | 44 |
450604 | 450604 | 2020-08-20 | Solano | California | 6095 | 5011 | 44 |
447376 | 447376 | 2020-08-19 | Solano | California | 6095 | 4948 | 44 |
444149 | 444149 | 2020-08-18 | Solano | California | 6095 | 4876 | 43 |
440923 | 440923 | 2020-08-17 | Solano | California | 6095 | 4772 | 41 |
437697 | 437697 | 2020-08-16 | Solano | California | 6095 | 4601 | 41 |
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);