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 |
---|---|---|---|---|---|---|---|
1193332 | 1193332 | 2021-04-06 | San Francisco | California | 6075 | 35541 | 488 |
1190082 | 1190082 | 2021-04-05 | San Francisco | California | 6075 | 35528 | 488 |
1186835 | 1186835 | 2021-04-04 | San Francisco | California | 6075 | 35491 | 489 |
1183588 | 1183588 | 2021-04-03 | San Francisco | California | 6075 | 35454 | 488 |
1180341 | 1180341 | 2021-04-02 | San Francisco | California | 6075 | 35389 | 488 |
1177094 | 1177094 | 2021-04-01 | San Francisco | California | 6075 | 35350 | 474 |
1173847 | 1173847 | 2021-03-31 | San Francisco | California | 6075 | 35328 | 474 |
1170600 | 1170600 | 2021-03-30 | San Francisco | California | 6075 | 35294 | 474 |
1167352 | 1167352 | 2021-03-29 | San Francisco | California | 6075 | 35289 | 474 |
1164104 | 1164104 | 2021-03-28 | San Francisco | California | 6075 | 35247 | 474 |
1160856 | 1160856 | 2021-03-27 | San Francisco | California | 6075 | 35189 | 472 |
1157608 | 1157608 | 2021-03-26 | San Francisco | California | 6075 | 35157 | 468 |
1154361 | 1154361 | 2021-03-25 | San Francisco | California | 6075 | 35106 | 462 |
1151114 | 1151114 | 2021-03-24 | San Francisco | California | 6075 | 35074 | 462 |
1147867 | 1147867 | 2021-03-23 | San Francisco | California | 6075 | 35043 | 462 |
1144620 | 1144620 | 2021-03-22 | San Francisco | California | 6075 | 35015 | 460 |
1141373 | 1141373 | 2021-03-21 | San Francisco | California | 6075 | 34971 | 453 |
1138127 | 1138127 | 2021-03-20 | San Francisco | California | 6075 | 34939 | 461 |
1134881 | 1134881 | 2021-03-19 | San Francisco | California | 6075 | 34907 | 461 |
1131634 | 1131634 | 2021-03-18 | San Francisco | California | 6075 | 34876 | 457 |
1128386 | 1128386 | 2021-03-17 | San Francisco | California | 6075 | 34836 | 456 |
1125140 | 1125140 | 2021-03-16 | San Francisco | California | 6075 | 34823 | 456 |
1121894 | 1121894 | 2021-03-15 | San Francisco | California | 6075 | 34813 | 455 |
1118647 | 1118647 | 2021-03-14 | San Francisco | California | 6075 | 34787 | 455 |
1115400 | 1115400 | 2021-03-13 | San Francisco | California | 6075 | 34761 | 452 |
1112154 | 1112154 | 2021-03-12 | San Francisco | California | 6075 | 34725 | 445 |
1108908 | 1108908 | 2021-03-11 | San Francisco | California | 6075 | 34691 | 440 |
1105662 | 1105662 | 2021-03-10 | San Francisco | California | 6075 | 34657 | 440 |
1102416 | 1102416 | 2021-03-09 | San Francisco | California | 6075 | 34637 | 436 |
1099170 | 1099170 | 2021-03-08 | San Francisco | California | 6075 | 34597 | 436 |
1095922 | 1095922 | 2021-03-07 | San Francisco | California | 6075 | 34563 | 432 |
1092676 | 1092676 | 2021-03-06 | San Francisco | California | 6075 | 34529 | 432 |
1089430 | 1089430 | 2021-03-05 | San Francisco | California | 6075 | 34483 | 426 |
1086185 | 1086185 | 2021-03-04 | San Francisco | California | 6075 | 34446 | 423 |
1082939 | 1082939 | 2021-03-03 | San Francisco | California | 6075 | 34390 | 422 |
1079693 | 1079693 | 2021-03-02 | San Francisco | California | 6075 | 34321 | 422 |
1076448 | 1076448 | 2021-03-01 | San Francisco | California | 6075 | 34294 | 422 |
1073202 | 1073202 | 2021-02-28 | San Francisco | California | 6075 | 34263 | 422 |
1069956 | 1069956 | 2021-02-27 | San Francisco | California | 6075 | 34216 | 412 |
1066711 | 1066711 | 2021-02-26 | San Francisco | California | 6075 | 34141 | 410 |
1063466 | 1063466 | 2021-02-25 | San Francisco | California | 6075 | 34064 | 398 |
1060221 | 1060221 | 2021-02-24 | San Francisco | California | 6075 | 33997 | 394 |
1056975 | 1056975 | 2021-02-23 | San Francisco | California | 6075 | 33950 | 394 |
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 |
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);