ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
824 rows where fips = 6073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053728 | 1053728 | 2021-02-22 | San Diego | California | 6073 | 257414 | 3190 |
1050481 | 1050481 | 2021-02-21 | San Diego | California | 6073 | 257093 | 3190 |
1047234 | 1047234 | 2021-02-20 | San Diego | California | 6073 | 256576 | 3188 |
1043989 | 1043989 | 2021-02-19 | San Diego | California | 6073 | 255865 | 3169 |
1040744 | 1040744 | 2021-02-18 | San Diego | California | 6073 | 255053 | 3135 |
1037499 | 1037499 | 2021-02-17 | San Diego | California | 6073 | 254243 | 3099 |
1034254 | 1034254 | 2021-02-16 | San Diego | California | 6073 | 253704 | 3042 |
1031008 | 1031008 | 2021-02-15 | San Diego | California | 6073 | 252313 | 3037 |
1027761 | 1027761 | 2021-02-14 | San Diego | California | 6073 | 252313 | 3037 |
1024516 | 1024516 | 2021-02-13 | San Diego | California | 6073 | 251745 | 3009 |
1021271 | 1021271 | 2021-02-12 | San Diego | California | 6073 | 250854 | 2979 |
1018026 | 1018026 | 2021-02-11 | San Diego | California | 6073 | 250037 | 2955 |
1014781 | 1014781 | 2021-02-10 | San Diego | California | 6073 | 248924 | 2904 |
1011536 | 1011536 | 2021-02-09 | San Diego | California | 6073 | 248114 | 2853 |
1008290 | 1008290 | 2021-02-08 | San Diego | California | 6073 | 247525 | 2821 |
1005044 | 1005044 | 2021-02-07 | San Diego | California | 6073 | 246627 | 2821 |
1001798 | 1001798 | 2021-02-06 | San Diego | California | 6073 | 245397 | 2812 |
998552 | 998552 | 2021-02-05 | San Diego | California | 6073 | 244132 | 2777 |
995306 | 995306 | 2021-02-04 | San Diego | California | 6073 | 242679 | 2738 |
992060 | 992060 | 2021-02-03 | San Diego | California | 6073 | 241081 | 2683 |
988814 | 988814 | 2021-02-02 | San Diego | California | 6073 | 240113 | 2629 |
985567 | 985567 | 2021-02-01 | San Diego | California | 6073 | 239205 | 2619 |
982320 | 982320 | 2021-01-31 | San Diego | California | 6073 | 238105 | 2619 |
979074 | 979074 | 2021-01-30 | San Diego | California | 6073 | 236831 | 2603 |
975829 | 975829 | 2021-01-29 | San Diego | California | 6073 | 234703 | 2571 |
972584 | 972584 | 2021-01-28 | San Diego | California | 6073 | 233033 | 2534 |
969339 | 969339 | 2021-01-27 | San Diego | California | 6073 | 231544 | 2465 |
966095 | 966095 | 2021-01-26 | San Diego | California | 6073 | 230129 | 2421 |
962850 | 962850 | 2021-01-25 | San Diego | California | 6073 | 228695 | 2375 |
959605 | 959605 | 2021-01-24 | San Diego | California | 6073 | 227258 | 2375 |
956359 | 956359 | 2021-01-23 | San Diego | California | 6073 | 225621 | 2344 |
953114 | 953114 | 2021-01-22 | San Diego | California | 6073 | 222641 | 2301 |
949869 | 949869 | 2021-01-21 | San Diego | California | 6073 | 219794 | 2222 |
946623 | 946623 | 2021-01-20 | San Diego | California | 6073 | 218618 | 2174 |
943376 | 943376 | 2021-01-19 | San Diego | California | 6073 | 216898 | 2109 |
940131 | 940131 | 2021-01-18 | San Diego | California | 6073 | 211850 | 2103 |
936886 | 936886 | 2021-01-17 | San Diego | California | 6073 | 211850 | 2103 |
933641 | 933641 | 2021-01-16 | San Diego | California | 6073 | 209960 | 2065 |
930396 | 930396 | 2021-01-15 | San Diego | California | 6073 | 206933 | 2037 |
927151 | 927151 | 2021-01-14 | San Diego | California | 6073 | 204238 | 2005 |
923905 | 923905 | 2021-01-13 | San Diego | California | 6073 | 201643 | 1952 |
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 |
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);