ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
347 rows where fips = 6075 sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923986 | 923986 | 2021-01-13 | San Francisco | California | 6075 | 27534 | 235 |
920741 | 920741 | 2021-01-12 | San Francisco | California | 6075 | 27267 | 235 |
917496 | 917496 | 2021-01-11 | San Francisco | California | 6075 | 27057 | 234 |
914251 | 914251 | 2021-01-10 | San Francisco | California | 6075 | 26711 | 233 |
911006 | 911006 | 2021-01-09 | San Francisco | California | 6075 | 26381 | 233 |
907761 | 907761 | 2021-01-08 | San Francisco | California | 6075 | 25888 | 218 |
904515 | 904515 | 2021-01-07 | San Francisco | California | 6075 | 25427 | 205 |
901270 | 901270 | 2021-01-06 | San Francisco | California | 6075 | 24992 | 203 |
898025 | 898025 | 2021-01-05 | San Francisco | California | 6075 | 24756 | 198 |
894780 | 894780 | 2021-01-04 | San Francisco | California | 6075 | 24591 | 194 |
891533 | 891533 | 2021-01-03 | San Francisco | California | 6075 | 24417 | 194 |
888286 | 888286 | 2021-01-02 | San Francisco | California | 6075 | 24148 | 194 |
885041 | 885041 | 2021-01-01 | San Francisco | California | 6075 | 23743 | 189 |
881796 | 881796 | 2020-12-31 | San Francisco | California | 6075 | 23227 | 186 |
878551 | 878551 | 2020-12-30 | San Francisco | California | 6075 | 22999 | 184 |
875306 | 875306 | 2020-12-29 | San Francisco | California | 6075 | 22729 | 182 |
872061 | 872061 | 2020-12-28 | San Francisco | California | 6075 | 22517 | 182 |
868816 | 868816 | 2020-12-27 | San Francisco | California | 6075 | 22322 | 182 |
865571 | 865571 | 2020-12-26 | San Francisco | California | 6075 | 22133 | 181 |
862326 | 862326 | 2020-12-25 | San Francisco | California | 6075 | 21833 | 181 |
859081 | 859081 | 2020-12-24 | San Francisco | California | 6075 | 21501 | 178 |
855836 | 855836 | 2020-12-23 | San Francisco | California | 6075 | 21235 | 178 |
852591 | 852591 | 2020-12-22 | San Francisco | California | 6075 | 21089 | 176 |
849346 | 849346 | 2020-12-21 | San Francisco | California | 6075 | 20940 | 176 |
846101 | 846101 | 2020-12-20 | San Francisco | California | 6075 | 20646 | 176 |
842855 | 842855 | 2020-12-19 | San Francisco | California | 6075 | 20318 | 176 |
839610 | 839610 | 2020-12-18 | San Francisco | California | 6075 | 19942 | 173 |
836365 | 836365 | 2020-12-17 | San Francisco | California | 6075 | 19627 | 172 |
833119 | 833119 | 2020-12-16 | San Francisco | California | 6075 | 19286 | 172 |
829872 | 829872 | 2020-12-15 | San Francisco | California | 6075 | 18907 | 167 |
826626 | 826626 | 2020-12-14 | San Francisco | California | 6075 | 18689 | 167 |
823379 | 823379 | 2020-12-13 | San Francisco | California | 6075 | 18416 | 167 |
820133 | 820133 | 2020-12-12 | San Francisco | California | 6075 | 18249 | 167 |
816887 | 816887 | 2020-12-11 | San Francisco | California | 6075 | 17948 | 167 |
813641 | 813641 | 2020-12-10 | San Francisco | California | 6075 | 17631 | 165 |
810397 | 810397 | 2020-12-09 | San Francisco | California | 6075 | 17387 | 164 |
807152 | 807152 | 2020-12-08 | San Francisco | California | 6075 | 17223 | 164 |
803907 | 803907 | 2020-12-07 | San Francisco | California | 6075 | 17110 | 164 |
800661 | 800661 | 2020-12-06 | San Francisco | California | 6075 | 16789 | 164 |
797415 | 797415 | 2020-12-05 | San Francisco | California | 6075 | 16502 | 164 |
794170 | 794170 | 2020-12-04 | San Francisco | California | 6075 | 16239 | 162 |
790924 | 790924 | 2020-12-03 | San Francisco | California | 6075 | 16061 | 161 |
787678 | 787678 | 2020-12-02 | San Francisco | California | 6075 | 15800 | 160 |
784434 | 784434 | 2020-12-01 | San Francisco | California | 6075 | 15642 | 160 |
781189 | 781189 | 2020-11-30 | San Francisco | California | 6075 | 15574 | 160 |
777943 | 777943 | 2020-11-29 | San Francisco | California | 6075 | 15453 | 160 |
774697 | 774697 | 2020-11-28 | San Francisco | California | 6075 | 15380 | 160 |
771452 | 771452 | 2020-11-27 | San Francisco | California | 6075 | 15159 | 160 |
768206 | 768206 | 2020-11-26 | San Francisco | California | 6075 | 15056 | 160 |
764959 | 764959 | 2020-11-25 | San Francisco | California | 6075 | 14877 | 160 |
761713 | 761713 | 2020-11-24 | San Francisco | California | 6075 | 14665 | 158 |
758467 | 758467 | 2020-11-23 | San Francisco | California | 6075 | 14545 | 158 |
755220 | 755220 | 2020-11-22 | San Francisco | California | 6075 | 14448 | 158 |
751973 | 751973 | 2020-11-21 | San Francisco | California | 6075 | 14330 | 158 |
748726 | 748726 | 2020-11-20 | San Francisco | California | 6075 | 14254 | 156 |
745479 | 745479 | 2020-11-19 | San Francisco | California | 6075 | 14060 | 156 |
742232 | 742232 | 2020-11-18 | San Francisco | California | 6075 | 13955 | 156 |
738985 | 738985 | 2020-11-17 | San Francisco | California | 6075 | 13850 | 156 |
735740 | 735740 | 2020-11-16 | San Francisco | California | 6075 | 13760 | 156 |
732494 | 732494 | 2020-11-15 | San Francisco | California | 6075 | 13668 | 156 |
729249 | 729249 | 2020-11-14 | San Francisco | California | 6075 | 13519 | 155 |
726005 | 726005 | 2020-11-13 | San Francisco | California | 6075 | 13407 | 153 |
722761 | 722761 | 2020-11-12 | San Francisco | California | 6075 | 13311 | 153 |
719517 | 719517 | 2020-11-11 | San Francisco | California | 6075 | 13213 | 153 |
716273 | 716273 | 2020-11-10 | San Francisco | California | 6075 | 13142 | 151 |
713029 | 713029 | 2020-11-09 | San Francisco | California | 6075 | 13084 | 151 |
709785 | 709785 | 2020-11-08 | San Francisco | California | 6075 | 12983 | 151 |
706541 | 706541 | 2020-11-07 | San Francisco | California | 6075 | 12863 | 151 |
703298 | 703298 | 2020-11-06 | San Francisco | California | 6075 | 12756 | 151 |
700054 | 700054 | 2020-11-05 | San Francisco | California | 6075 | 12669 | 149 |
696809 | 696809 | 2020-11-04 | San Francisco | California | 6075 | 12602 | 149 |
693566 | 693566 | 2020-11-03 | San Francisco | California | 6075 | 12557 | 149 |
690323 | 690323 | 2020-11-02 | San Francisco | California | 6075 | 12511 | 148 |
687078 | 687078 | 2020-11-01 | San Francisco | California | 6075 | 12457 | 148 |
683833 | 683833 | 2020-10-31 | San Francisco | California | 6075 | 12402 | 148 |
680589 | 680589 | 2020-10-30 | San Francisco | California | 6075 | 12323 | 147 |
677346 | 677346 | 2020-10-29 | San Francisco | California | 6075 | 12280 | 145 |
674102 | 674102 | 2020-10-28 | San Francisco | California | 6075 | 12244 | 145 |
670860 | 670860 | 2020-10-27 | San Francisco | California | 6075 | 12192 | 140 |
667617 | 667617 | 2020-10-26 | San Francisco | California | 6075 | 12155 | 140 |
664371 | 664371 | 2020-10-25 | San Francisco | California | 6075 | 12106 | 140 |
661126 | 661126 | 2020-10-24 | San Francisco | California | 6075 | 12072 | 140 |
657882 | 657882 | 2020-10-23 | San Francisco | California | 6075 | 12035 | 140 |
654637 | 654637 | 2020-10-22 | San Francisco | California | 6075 | 12003 | 138 |
651392 | 651392 | 2020-10-21 | San Francisco | California | 6075 | 12016 | 137 |
648148 | 648148 | 2020-10-20 | San Francisco | California | 6075 | 11940 | 133 |
644903 | 644903 | 2020-10-19 | San Francisco | California | 6075 | 11904 | 133 |
641655 | 641655 | 2020-10-18 | San Francisco | California | 6075 | 11880 | 133 |
638408 | 638408 | 2020-10-17 | San Francisco | California | 6075 | 11843 | 133 |
635163 | 635163 | 2020-10-16 | San Francisco | California | 6075 | 11811 | 131 |
631917 | 631917 | 2020-10-15 | San Francisco | California | 6075 | 11786 | 126 |
628673 | 628673 | 2020-10-14 | San Francisco | California | 6075 | 11715 | 123 |
625430 | 625430 | 2020-10-13 | San Francisco | California | 6075 | 11694 | 123 |
622187 | 622187 | 2020-10-12 | San Francisco | California | 6075 | 11669 | 123 |
618944 | 618944 | 2020-10-11 | San Francisco | California | 6075 | 11666 | 123 |
615702 | 615702 | 2020-10-10 | San Francisco | California | 6075 | 11623 | 123 |
612461 | 612461 | 2020-10-09 | San Francisco | California | 6075 | 11611 | 121 |
609219 | 609219 | 2020-10-08 | San Francisco | California | 6075 | 11554 | 115 |
605976 | 605976 | 2020-10-07 | San Francisco | California | 6075 | 11536 | 114 |
602734 | 602734 | 2020-10-06 | San Francisco | California | 6075 | 11508 | 111 |
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]);