ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
824 rows where fips = 6073 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920660 | 920660 | 2021-01-12 | San Diego | California | 6073 | 198382 | 1898 |
917415 | 917415 | 2021-01-11 | San Diego | California | 6073 | 194858 | 1857 |
914170 | 914170 | 2021-01-10 | San Diego | California | 6073 | 191951 | 1857 |
910925 | 910925 | 2021-01-09 | San Diego | California | 6073 | 188663 | 1824 |
907680 | 907680 | 2021-01-08 | San Diego | California | 6073 | 185125 | 1771 |
904434 | 904434 | 2021-01-07 | San Diego | California | 6073 | 180575 | 1738 |
901189 | 901189 | 2021-01-06 | San Diego | California | 6073 | 176725 | 1691 |
897944 | 897944 | 2021-01-05 | San Diego | California | 6073 | 172910 | 1654 |
894699 | 894699 | 2021-01-04 | San Diego | California | 6073 | 171096 | 1598 |
891452 | 891452 | 2021-01-03 | San Diego | California | 6073 | 168083 | 1592 |
888205 | 888205 | 2021-01-02 | San Diego | California | 6073 | 164563 | 1592 |
884960 | 884960 | 2021-01-01 | San Diego | California | 6073 | 155658 | 1534 |
881715 | 881715 | 2020-12-31 | San Diego | California | 6073 | 155658 | 1534 |
878470 | 878470 | 2020-12-30 | San Diego | California | 6073 | 152575 | 1472 |
875225 | 875225 | 2020-12-29 | San Diego | California | 6073 | 150127 | 1435 |
871980 | 871980 | 2020-12-28 | San Diego | California | 6073 | 147593 | 1404 |
868735 | 868735 | 2020-12-27 | San Diego | California | 6073 | 145842 | 1402 |
865490 | 865490 | 2020-12-26 | San Diego | California | 6073 | 142710 | 1402 |
862245 | 862245 | 2020-12-25 | San Diego | California | 6073 | 137018 | 1382 |
859000 | 859000 | 2020-12-24 | San Diego | California | 6073 | 137018 | 1382 |
855755 | 855755 | 2020-12-23 | San Diego | California | 6073 | 134759 | 1350 |
852510 | 852510 | 2020-12-22 | San Diego | California | 6073 | 132161 | 1311 |
849265 | 849265 | 2020-12-21 | San Diego | California | 6073 | 129780 | 1283 |
846020 | 846020 | 2020-12-20 | San Diego | California | 6073 | 126528 | 1280 |
842774 | 842774 | 2020-12-19 | San Diego | California | 6073 | 123035 | 1280 |
839529 | 839529 | 2020-12-18 | San Diego | California | 6073 | 120526 | 1253 |
836284 | 836284 | 2020-12-17 | San Diego | California | 6073 | 116915 | 1239 |
833038 | 833038 | 2020-12-16 | San Diego | California | 6073 | 114311 | 1217 |
829791 | 829791 | 2020-12-15 | San Diego | California | 6073 | 111504 | 1194 |
826545 | 826545 | 2020-12-14 | San Diego | California | 6073 | 109641 | 1162 |
823298 | 823298 | 2020-12-13 | San Diego | California | 6073 | 107435 | 1162 |
820052 | 820052 | 2020-12-12 | San Diego | California | 6073 | 102531 | 1137 |
816806 | 816806 | 2020-12-11 | San Diego | California | 6073 | 102529 | 1137 |
813560 | 813560 | 2020-12-10 | San Diego | California | 6073 | 99662 | 1114 |
810316 | 810316 | 2020-12-09 | San Diego | California | 6073 | 97612 | 1103 |
807071 | 807071 | 2020-12-08 | San Diego | California | 6073 | 95508 | 1062 |
803826 | 803826 | 2020-12-07 | San Diego | California | 6073 | 94232 | 1062 |
800581 | 800581 | 2020-12-06 | San Diego | California | 6073 | 92234 | 1062 |
797336 | 797336 | 2020-12-05 | San Diego | California | 6073 | 90531 | 1055 |
794091 | 794091 | 2020-12-04 | San Diego | California | 6073 | 88244 | 1047 |
790846 | 790846 | 2020-12-03 | San Diego | California | 6073 | 86205 | 1040 |
787601 | 787601 | 2020-12-02 | San Diego | California | 6073 | 84701 | 1035 |
784357 | 784357 | 2020-12-01 | San Diego | California | 6073 | 83484 | 1019 |
781112 | 781112 | 2020-11-30 | San Diego | California | 6073 | 82106 | 997 |
777866 | 777866 | 2020-11-29 | San Diego | California | 6073 | 80083 | 997 |
774621 | 774621 | 2020-11-28 | San Diego | California | 6073 | 80081 | 997 |
771376 | 771376 | 2020-11-27 | San Diego | California | 6073 | 78222 | 996 |
768131 | 768131 | 2020-11-26 | San Diego | California | 6073 | 75370 | 988 |
764885 | 764885 | 2020-11-25 | San Diego | California | 6073 | 75368 | 988 |
761640 | 761640 | 2020-11-24 | San Diego | California | 6073 | 74424 | 984 |
758395 | 758395 | 2020-11-23 | San Diego | California | 6073 | 72878 | 968 |
755148 | 755148 | 2020-11-22 | San Diego | California | 6073 | 71711 | 968 |
751902 | 751902 | 2020-11-21 | San Diego | California | 6073 | 70772 | 966 |
748656 | 748656 | 2020-11-20 | San Diego | California | 6073 | 69294 | 960 |
745410 | 745410 | 2020-11-19 | San Diego | California | 6073 | 68203 | 952 |
742163 | 742163 | 2020-11-18 | San Diego | California | 6073 | 67304 | 945 |
738916 | 738916 | 2020-11-17 | San Diego | California | 6073 | 66382 | 933 |
735672 | 735672 | 2020-11-16 | San Diego | California | 6073 | 65664 | 926 |
732426 | 732426 | 2020-11-15 | San Diego | California | 6073 | 64831 | 926 |
729181 | 729181 | 2020-11-14 | San Diego | California | 6073 | 63744 | 926 |
725938 | 725938 | 2020-11-13 | San Diego | California | 6073 | 63008 | 921 |
722695 | 722695 | 2020-11-12 | San Diego | California | 6073 | 62397 | 918 |
719452 | 719452 | 2020-11-11 | San Diego | California | 6073 | 61148 | 915 |
716209 | 716209 | 2020-11-10 | San Diego | California | 6073 | 61116 | 915 |
712965 | 712965 | 2020-11-09 | San Diego | California | 6073 | 60633 | 938 |
709721 | 709721 | 2020-11-08 | San Diego | California | 6073 | 60232 | 908 |
706477 | 706477 | 2020-11-07 | San Diego | California | 6073 | 59719 | 908 |
703234 | 703234 | 2020-11-06 | San Diego | California | 6073 | 59179 | 907 |
699991 | 699991 | 2020-11-05 | San Diego | California | 6073 | 58699 | 904 |
696747 | 696747 | 2020-11-04 | San Diego | California | 6073 | 58169 | 904 |
693505 | 693505 | 2020-11-03 | San Diego | California | 6073 | 57765 | 901 |
690262 | 690262 | 2020-11-02 | San Diego | California | 6073 | 57472 | 891 |
687017 | 687017 | 2020-11-01 | San Diego | California | 6073 | 57165 | 891 |
683773 | 683773 | 2020-10-31 | San Diego | California | 6073 | 56813 | 891 |
680530 | 680530 | 2020-10-30 | San Diego | California | 6073 | 56432 | 888 |
677287 | 677287 | 2020-10-29 | San Diego | California | 6073 | 55961 | 885 |
674044 | 674044 | 2020-10-28 | San Diego | California | 6073 | 55603 | 881 |
670802 | 670802 | 2020-10-27 | San Diego | California | 6073 | 55273 | 877 |
667559 | 667559 | 2020-10-26 | San Diego | California | 6073 | 55004 | 870 |
664314 | 664314 | 2020-10-25 | San Diego | California | 6073 | 54646 | 870 |
661070 | 661070 | 2020-10-24 | San Diego | California | 6073 | 54377 | 868 |
657826 | 657826 | 2020-10-23 | San Diego | California | 6073 | 53991 | 867 |
654581 | 654581 | 2020-10-22 | San Diego | California | 6073 | 53561 | 866 |
651336 | 651336 | 2020-10-21 | San Diego | California | 6073 | 53326 | 863 |
648092 | 648092 | 2020-10-20 | San Diego | California | 6073 | 53063 | 857 |
644847 | 644847 | 2020-10-19 | San Diego | California | 6073 | 52798 | 853 |
641599 | 641599 | 2020-10-18 | San Diego | California | 6073 | 52418 | 853 |
638352 | 638352 | 2020-10-17 | San Diego | California | 6073 | 52045 | 850 |
635107 | 635107 | 2020-10-16 | San Diego | California | 6073 | 51844 | 847 |
631861 | 631861 | 2020-10-15 | San Diego | California | 6073 | 51533 | 847 |
628617 | 628617 | 2020-10-14 | San Diego | California | 6073 | 51390 | 844 |
625374 | 625374 | 2020-10-13 | San Diego | California | 6073 | 51087 | 840 |
622131 | 622131 | 2020-10-12 | San Diego | California | 6073 | 50809 | 826 |
618888 | 618888 | 2020-10-11 | San Diego | California | 6073 | 50614 | 826 |
615646 | 615646 | 2020-10-10 | San Diego | California | 6073 | 50206 | 825 |
612405 | 612405 | 2020-10-09 | San Diego | California | 6073 | 49886 | 821 |
609163 | 609163 | 2020-10-08 | San Diego | California | 6073 | 49529 | 819 |
605920 | 605920 | 2020-10-07 | San Diego | California | 6073 | 49238 | 813 |
602678 | 602678 | 2020-10-06 | San Diego | California | 6073 | 48884 | 806 |
599435 | 599435 | 2020-10-05 | San Diego | California | 6073 | 48723 | 803 |
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);