ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
327 rows where fips = 6055 sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
936957 | 936957 | 2021-01-17 | Napa | California | 6055 | 7357 | 39 |
933712 | 933712 | 2021-01-16 | Napa | California | 6055 | 7232 | 39 |
930467 | 930467 | 2021-01-15 | Napa | California | 6055 | 7158 | 38 |
927222 | 927222 | 2021-01-14 | Napa | California | 6055 | 7040 | 38 |
923976 | 923976 | 2021-01-13 | Napa | California | 6055 | 6943 | 37 |
920731 | 920731 | 2021-01-12 | Napa | California | 6055 | 6881 | 36 |
917486 | 917486 | 2021-01-11 | Napa | California | 6055 | 6702 | 36 |
914241 | 914241 | 2021-01-10 | Napa | California | 6055 | 6595 | 36 |
910996 | 910996 | 2021-01-09 | Napa | California | 6055 | 6545 | 36 |
907751 | 907751 | 2021-01-08 | Napa | California | 6055 | 6477 | 35 |
904505 | 904505 | 2021-01-07 | Napa | California | 6055 | 6343 | 33 |
901260 | 901260 | 2021-01-06 | Napa | California | 6055 | 6283 | 32 |
898015 | 898015 | 2021-01-05 | Napa | California | 6055 | 6199 | 30 |
894770 | 894770 | 2021-01-04 | Napa | California | 6055 | 6095 | 29 |
891523 | 891523 | 2021-01-03 | Napa | California | 6055 | 5995 | 29 |
888276 | 888276 | 2021-01-02 | Napa | California | 6055 | 5900 | 29 |
885031 | 885031 | 2021-01-01 | Napa | California | 6055 | 5802 | 29 |
881786 | 881786 | 2020-12-31 | Napa | California | 6055 | 5742 | 28 |
878541 | 878541 | 2020-12-30 | Napa | California | 6055 | 5665 | 27 |
875296 | 875296 | 2020-12-29 | Napa | California | 6055 | 5616 | 27 |
872051 | 872051 | 2020-12-28 | Napa | California | 6055 | 5497 | 27 |
868806 | 868806 | 2020-12-27 | Napa | California | 6055 | 5428 | 27 |
865561 | 865561 | 2020-12-26 | Napa | California | 6055 | 5352 | 27 |
862316 | 862316 | 2020-12-25 | Napa | California | 6055 | 5266 | 27 |
859071 | 859071 | 2020-12-24 | Napa | California | 6055 | 5173 | 27 |
855826 | 855826 | 2020-12-23 | Napa | California | 6055 | 5092 | 26 |
852581 | 852581 | 2020-12-22 | Napa | California | 6055 | 4966 | 25 |
849336 | 849336 | 2020-12-21 | Napa | California | 6055 | 4866 | 24 |
846091 | 846091 | 2020-12-20 | Napa | California | 6055 | 4773 | 24 |
842845 | 842845 | 2020-12-19 | Napa | California | 6055 | 4689 | 24 |
839600 | 839600 | 2020-12-18 | Napa | California | 6055 | 4647 | 24 |
836355 | 836355 | 2020-12-17 | Napa | California | 6055 | 4545 | 24 |
833109 | 833109 | 2020-12-16 | Napa | California | 6055 | 4456 | 24 |
829862 | 829862 | 2020-12-15 | Napa | California | 6055 | 4384 | 24 |
826616 | 826616 | 2020-12-14 | Napa | California | 6055 | 4248 | 23 |
823369 | 823369 | 2020-12-13 | Napa | California | 6055 | 4114 | 23 |
820123 | 820123 | 2020-12-12 | Napa | California | 6055 | 4055 | 23 |
816877 | 816877 | 2020-12-11 | Napa | California | 6055 | 4014 | 23 |
813631 | 813631 | 2020-12-10 | Napa | California | 6055 | 3936 | 23 |
810387 | 810387 | 2020-12-09 | Napa | California | 6055 | 3814 | 22 |
807142 | 807142 | 2020-12-08 | Napa | California | 6055 | 3734 | 21 |
803897 | 803897 | 2020-12-07 | Napa | California | 6055 | 3651 | 20 |
800651 | 800651 | 2020-12-06 | Napa | California | 6055 | 3566 | 19 |
797405 | 797405 | 2020-12-05 | Napa | California | 6055 | 3433 | 19 |
794160 | 794160 | 2020-12-04 | Napa | California | 6055 | 3389 | 18 |
790914 | 790914 | 2020-12-03 | Napa | California | 6055 | 3299 | 18 |
787668 | 787668 | 2020-12-02 | Napa | California | 6055 | 3227 | 18 |
784424 | 784424 | 2020-12-01 | Napa | California | 6055 | 3096 | 18 |
781179 | 781179 | 2020-11-30 | Napa | California | 6055 | 3091 | 17 |
777933 | 777933 | 2020-11-29 | Napa | California | 6055 | 3034 | 17 |
774687 | 774687 | 2020-11-28 | Napa | California | 6055 | 2989 | 17 |
771442 | 771442 | 2020-11-27 | Napa | California | 6055 | 2989 | 17 |
768196 | 768196 | 2020-11-26 | Napa | California | 6055 | 2946 | 17 |
764949 | 764949 | 2020-11-25 | Napa | California | 6055 | 2932 | 17 |
761703 | 761703 | 2020-11-24 | Napa | California | 6055 | 2885 | 17 |
758457 | 758457 | 2020-11-23 | Napa | California | 6055 | 2788 | 17 |
755210 | 755210 | 2020-11-22 | Napa | California | 6055 | 2758 | 17 |
751963 | 751963 | 2020-11-21 | Napa | California | 6055 | 2719 | 17 |
748716 | 748716 | 2020-11-20 | Napa | California | 6055 | 2696 | 17 |
745469 | 745469 | 2020-11-19 | Napa | California | 6055 | 2624 | 17 |
742222 | 742222 | 2020-11-18 | Napa | California | 6055 | 2591 | 17 |
738975 | 738975 | 2020-11-17 | Napa | California | 6055 | 2554 | 17 |
735730 | 735730 | 2020-11-16 | Napa | California | 6055 | 2522 | 17 |
732484 | 732484 | 2020-11-15 | Napa | California | 6055 | 2474 | 17 |
729239 | 729239 | 2020-11-14 | Napa | California | 6055 | 2441 | 17 |
725995 | 725995 | 2020-11-13 | Napa | California | 6055 | 2433 | 17 |
722751 | 722751 | 2020-11-12 | Napa | California | 6055 | 2386 | 17 |
719507 | 719507 | 2020-11-11 | Napa | California | 6055 | 2342 | 17 |
716263 | 716263 | 2020-11-10 | Napa | California | 6055 | 2332 | 16 |
713019 | 713019 | 2020-11-09 | Napa | California | 6055 | 2300 | 16 |
709775 | 709775 | 2020-11-08 | Napa | California | 6055 | 2243 | 16 |
706531 | 706531 | 2020-11-07 | Napa | California | 6055 | 2190 | 16 |
703288 | 703288 | 2020-11-06 | Napa | California | 6055 | 2182 | 16 |
700044 | 700044 | 2020-11-05 | Napa | California | 6055 | 2150 | 16 |
696799 | 696799 | 2020-11-04 | Napa | California | 6055 | 2131 | 16 |
693556 | 693556 | 2020-11-03 | Napa | California | 6055 | 2109 | 16 |
690313 | 690313 | 2020-11-02 | Napa | California | 6055 | 2076 | 16 |
687068 | 687068 | 2020-11-01 | Napa | California | 6055 | 2041 | 16 |
683823 | 683823 | 2020-10-31 | Napa | California | 6055 | 2029 | 16 |
680579 | 680579 | 2020-10-30 | Napa | California | 6055 | 2022 | 16 |
677336 | 677336 | 2020-10-29 | Napa | California | 6055 | 2003 | 16 |
674092 | 674092 | 2020-10-28 | Napa | California | 6055 | 1993 | 16 |
670850 | 670850 | 2020-10-27 | Napa | California | 6055 | 1976 | 16 |
667607 | 667607 | 2020-10-26 | Napa | California | 6055 | 1963 | 15 |
664361 | 664361 | 2020-10-25 | Napa | California | 6055 | 1958 | 15 |
661116 | 661116 | 2020-10-24 | Napa | California | 6055 | 1943 | 15 |
657872 | 657872 | 2020-10-23 | Napa | California | 6055 | 1938 | 15 |
654627 | 654627 | 2020-10-22 | Napa | California | 6055 | 1924 | 15 |
651382 | 651382 | 2020-10-21 | Napa | California | 6055 | 1914 | 14 |
648138 | 648138 | 2020-10-20 | Napa | California | 6055 | 1909 | 14 |
644893 | 644893 | 2020-10-19 | Napa | California | 6055 | 1889 | 14 |
641645 | 641645 | 2020-10-18 | Napa | California | 6055 | 1867 | 14 |
638398 | 638398 | 2020-10-17 | Napa | California | 6055 | 1856 | 14 |
635153 | 635153 | 2020-10-16 | Napa | California | 6055 | 1852 | 14 |
631907 | 631907 | 2020-10-15 | Napa | California | 6055 | 1841 | 14 |
628663 | 628663 | 2020-10-14 | Napa | California | 6055 | 1833 | 14 |
625420 | 625420 | 2020-10-13 | Napa | California | 6055 | 1824 | 14 |
622177 | 622177 | 2020-10-12 | Napa | California | 6055 | 1818 | 13 |
618934 | 618934 | 2020-10-11 | Napa | California | 6055 | 1805 | 13 |
615692 | 615692 | 2020-10-10 | Napa | California | 6055 | 1796 | 13 |
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]);