ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
832 rows where fips = 6075 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053729 | 1053729 | 2021-02-22 | San Francisco | California | 6075 | 33894 | 394 |
1050482 | 1050482 | 2021-02-21 | San Francisco | California | 6075 | 33823 | 394 |
1047235 | 1047235 | 2021-02-20 | San Francisco | California | 6075 | 33749 | 394 |
1043990 | 1043990 | 2021-02-19 | San Francisco | California | 6075 | 33653 | 387 |
1040745 | 1040745 | 2021-02-18 | San Francisco | California | 6075 | 33561 | 376 |
1037500 | 1037500 | 2021-02-17 | San Francisco | California | 6075 | 33494 | 376 |
1034255 | 1034255 | 2021-02-16 | San Francisco | California | 6075 | 33457 | 372 |
1031009 | 1031009 | 2021-02-15 | San Francisco | California | 6075 | 33377 | 366 |
1027762 | 1027762 | 2021-02-14 | San Francisco | California | 6075 | 33294 | 366 |
1024517 | 1024517 | 2021-02-13 | San Francisco | California | 6075 | 33182 | 366 |
1021272 | 1021272 | 2021-02-12 | San Francisco | California | 6075 | 33079 | 359 |
1018027 | 1018027 | 2021-02-11 | San Francisco | California | 6075 | 32958 | 351 |
1014782 | 1014782 | 2021-02-10 | San Francisco | California | 6075 | 32785 | 351 |
1011537 | 1011537 | 2021-02-09 | San Francisco | California | 6075 | 32682 | 346 |
1008291 | 1008291 | 2021-02-08 | San Francisco | California | 6075 | 32612 | 346 |
1005045 | 1005045 | 2021-02-07 | San Francisco | California | 6075 | 32440 | 346 |
1001799 | 1001799 | 2021-02-06 | San Francisco | California | 6075 | 32232 | 345 |
998553 | 998553 | 2021-02-05 | San Francisco | California | 6075 | 32119 | 345 |
995307 | 995307 | 2021-02-04 | San Francisco | California | 6075 | 31986 | 328 |
992061 | 992061 | 2021-02-03 | San Francisco | California | 6075 | 31791 | 328 |
988815 | 988815 | 2021-02-02 | San Francisco | California | 6075 | 31706 | 324 |
985568 | 985568 | 2021-02-01 | San Francisco | California | 6075 | 31566 | 324 |
982321 | 982321 | 2021-01-31 | San Francisco | California | 6075 | 31430 | 324 |
979075 | 979075 | 2021-01-30 | San Francisco | California | 6075 | 31297 | 323 |
975830 | 975830 | 2021-01-29 | San Francisco | California | 6075 | 31196 | 317 |
972585 | 972585 | 2021-01-28 | San Francisco | California | 6075 | 31085 | 308 |
969340 | 969340 | 2021-01-27 | San Francisco | California | 6075 | 30877 | 297 |
966096 | 966096 | 2021-01-26 | San Francisco | California | 6075 | 30737 | 293 |
962851 | 962851 | 2021-01-25 | San Francisco | California | 6075 | 30562 | 293 |
959606 | 959606 | 2021-01-24 | San Francisco | California | 6075 | 30311 | 293 |
956360 | 956360 | 2021-01-23 | San Francisco | California | 6075 | 30030 | 278 |
953115 | 953115 | 2021-01-22 | San Francisco | California | 6075 | 29804 | 275 |
949870 | 949870 | 2021-01-21 | San Francisco | California | 6075 | 29668 | 274 |
946624 | 946624 | 2021-01-20 | San Francisco | California | 6075 | 29505 | 266 |
943377 | 943377 | 2021-01-19 | San Francisco | California | 6075 | 29324 | 262 |
940132 | 940132 | 2021-01-18 | San Francisco | California | 6075 | 29142 | 262 |
936887 | 936887 | 2021-01-17 | San Francisco | California | 6075 | 28856 | 254 |
933642 | 933642 | 2021-01-16 | San Francisco | California | 6075 | 28577 | 254 |
930397 | 930397 | 2021-01-15 | San Francisco | California | 6075 | 28203 | 241 |
927152 | 927152 | 2021-01-14 | San Francisco | California | 6075 | 27866 | 237 |
923906 | 923906 | 2021-01-13 | San Francisco | California | 6075 | 27534 | 235 |
920661 | 920661 | 2021-01-12 | San Francisco | California | 6075 | 27267 | 235 |
917416 | 917416 | 2021-01-11 | San Francisco | California | 6075 | 27057 | 234 |
914171 | 914171 | 2021-01-10 | San Francisco | California | 6075 | 26711 | 233 |
910926 | 910926 | 2021-01-09 | San Francisco | California | 6075 | 26381 | 233 |
907681 | 907681 | 2021-01-08 | San Francisco | California | 6075 | 25888 | 218 |
904435 | 904435 | 2021-01-07 | San Francisco | California | 6075 | 25427 | 205 |
901190 | 901190 | 2021-01-06 | San Francisco | California | 6075 | 24992 | 203 |
897945 | 897945 | 2021-01-05 | San Francisco | California | 6075 | 24756 | 198 |
894700 | 894700 | 2021-01-04 | San Francisco | California | 6075 | 24591 | 194 |
891453 | 891453 | 2021-01-03 | San Francisco | California | 6075 | 24417 | 194 |
888206 | 888206 | 2021-01-02 | San Francisco | California | 6075 | 24148 | 194 |
884961 | 884961 | 2021-01-01 | San Francisco | California | 6075 | 23743 | 189 |
881716 | 881716 | 2020-12-31 | San Francisco | California | 6075 | 23227 | 186 |
878471 | 878471 | 2020-12-30 | San Francisco | California | 6075 | 22999 | 184 |
875226 | 875226 | 2020-12-29 | San Francisco | California | 6075 | 22729 | 182 |
871981 | 871981 | 2020-12-28 | San Francisco | California | 6075 | 22517 | 182 |
868736 | 868736 | 2020-12-27 | San Francisco | California | 6075 | 22322 | 182 |
865491 | 865491 | 2020-12-26 | San Francisco | California | 6075 | 22133 | 181 |
862246 | 862246 | 2020-12-25 | San Francisco | California | 6075 | 21833 | 181 |
859001 | 859001 | 2020-12-24 | San Francisco | California | 6075 | 21501 | 178 |
855756 | 855756 | 2020-12-23 | San Francisco | California | 6075 | 21235 | 178 |
852511 | 852511 | 2020-12-22 | San Francisco | California | 6075 | 21089 | 176 |
849266 | 849266 | 2020-12-21 | San Francisco | California | 6075 | 20940 | 176 |
846021 | 846021 | 2020-12-20 | San Francisco | California | 6075 | 20646 | 176 |
842775 | 842775 | 2020-12-19 | San Francisco | California | 6075 | 20318 | 176 |
839530 | 839530 | 2020-12-18 | San Francisco | California | 6075 | 19942 | 173 |
836285 | 836285 | 2020-12-17 | San Francisco | California | 6075 | 19627 | 172 |
833039 | 833039 | 2020-12-16 | San Francisco | California | 6075 | 19286 | 172 |
829792 | 829792 | 2020-12-15 | San Francisco | California | 6075 | 18907 | 167 |
826546 | 826546 | 2020-12-14 | San Francisco | California | 6075 | 18689 | 167 |
823299 | 823299 | 2020-12-13 | San Francisco | California | 6075 | 18416 | 167 |
820053 | 820053 | 2020-12-12 | San Francisco | California | 6075 | 18249 | 167 |
816807 | 816807 | 2020-12-11 | San Francisco | California | 6075 | 17948 | 167 |
813561 | 813561 | 2020-12-10 | San Francisco | California | 6075 | 17631 | 165 |
810317 | 810317 | 2020-12-09 | San Francisco | California | 6075 | 17387 | 164 |
807072 | 807072 | 2020-12-08 | San Francisco | California | 6075 | 17223 | 164 |
803827 | 803827 | 2020-12-07 | San Francisco | California | 6075 | 17110 | 164 |
800582 | 800582 | 2020-12-06 | San Francisco | California | 6075 | 16789 | 164 |
797337 | 797337 | 2020-12-05 | San Francisco | California | 6075 | 16502 | 164 |
794092 | 794092 | 2020-12-04 | San Francisco | California | 6075 | 16239 | 162 |
790847 | 790847 | 2020-12-03 | San Francisco | California | 6075 | 16061 | 161 |
787602 | 787602 | 2020-12-02 | San Francisco | California | 6075 | 15800 | 160 |
784358 | 784358 | 2020-12-01 | San Francisco | California | 6075 | 15642 | 160 |
781113 | 781113 | 2020-11-30 | San Francisco | California | 6075 | 15574 | 160 |
777867 | 777867 | 2020-11-29 | San Francisco | California | 6075 | 15453 | 160 |
774622 | 774622 | 2020-11-28 | San Francisco | California | 6075 | 15380 | 160 |
771377 | 771377 | 2020-11-27 | San Francisco | California | 6075 | 15159 | 160 |
768132 | 768132 | 2020-11-26 | San Francisco | California | 6075 | 15056 | 160 |
764886 | 764886 | 2020-11-25 | San Francisco | California | 6075 | 14877 | 160 |
761641 | 761641 | 2020-11-24 | San Francisco | California | 6075 | 14665 | 158 |
758396 | 758396 | 2020-11-23 | San Francisco | California | 6075 | 14545 | 158 |
755149 | 755149 | 2020-11-22 | San Francisco | California | 6075 | 14448 | 158 |
751903 | 751903 | 2020-11-21 | San Francisco | California | 6075 | 14330 | 158 |
748657 | 748657 | 2020-11-20 | San Francisco | California | 6075 | 14254 | 156 |
745411 | 745411 | 2020-11-19 | San Francisco | California | 6075 | 14060 | 156 |
742164 | 742164 | 2020-11-18 | San Francisco | California | 6075 | 13955 | 156 |
738917 | 738917 | 2020-11-17 | San Francisco | California | 6075 | 13850 | 156 |
735673 | 735673 | 2020-11-16 | San Francisco | California | 6075 | 13760 | 156 |
732427 | 732427 | 2020-11-15 | San Francisco | California | 6075 | 13668 | 156 |
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);