ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
832 rows where county = "San Francisco" and fips = 6075 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277767 | 1277767 | 2021-05-02 | San Francisco | California | 6075 | 36499 | 541 |
1274520 | 1274520 | 2021-05-01 | San Francisco | California | 6075 | 36456 | 538 |
1271273 | 1271273 | 2021-04-30 | San Francisco | California | 6075 | 36415 | 537 |
1268026 | 1268026 | 2021-04-29 | San Francisco | California | 6075 | 36385 | 534 |
1264779 | 1264779 | 2021-04-28 | San Francisco | California | 6075 | 36361 | 533 |
1261532 | 1261532 | 2021-04-27 | San Francisco | California | 6075 | 36333 | 532 |
1258285 | 1258285 | 2021-04-26 | San Francisco | California | 6075 | 36313 | 532 |
1255038 | 1255038 | 2021-04-25 | San Francisco | California | 6075 | 36288 | 532 |
1251791 | 1251791 | 2021-04-24 | San Francisco | California | 6075 | 36255 | 532 |
1248544 | 1248544 | 2021-04-23 | San Francisco | California | 6075 | 36221 | 532 |
1245297 | 1245297 | 2021-04-22 | San Francisco | California | 6075 | 36197 | 529 |
1242050 | 1242050 | 2021-04-21 | San Francisco | California | 6075 | 36120 | 529 |
1238803 | 1238803 | 2021-04-20 | San Francisco | California | 6075 | 36097 | 529 |
1235556 | 1235556 | 2021-04-19 | San Francisco | California | 6075 | 36076 | 525 |
1232309 | 1232309 | 2021-04-18 | San Francisco | California | 6075 | 36035 | 523 |
1229060 | 1229060 | 2021-04-17 | San Francisco | California | 6075 | 35996 | 517 |
1225812 | 1225812 | 2021-04-16 | San Francisco | California | 6075 | 35950 | 517 |
1222565 | 1222565 | 2021-04-15 | San Francisco | California | 6075 | 35901 | 513 |
1219317 | 1219317 | 2021-04-14 | San Francisco | California | 6075 | 35872 | 507 |
1216069 | 1216069 | 2021-04-13 | San Francisco | California | 6075 | 35844 | 506 |
1212822 | 1212822 | 2021-04-12 | San Francisco | California | 6075 | 35818 | 502 |
1209574 | 1209574 | 2021-04-11 | San Francisco | California | 6075 | 35777 | 502 |
1206325 | 1206325 | 2021-04-10 | San Francisco | California | 6075 | 35719 | 497 |
1203077 | 1203077 | 2021-04-09 | San Francisco | California | 6075 | 35660 | 494 |
1199829 | 1199829 | 2021-04-08 | San Francisco | California | 6075 | 35621 | 493 |
1196580 | 1196580 | 2021-04-07 | San Francisco | California | 6075 | 35575 | 488 |
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 |
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);