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 |
---|---|---|---|---|---|---|---|
1492006 | 1492006 | 2021-07-07 | San Francisco | California | 6075 | 37254 | 558 |
1488759 | 1488759 | 2021-07-06 | San Francisco | California | 6075 | 37240 | 558 |
1485512 | 1485512 | 2021-07-05 | San Francisco | California | 6075 | 37110 | 558 |
1482266 | 1482266 | 2021-07-04 | San Francisco | California | 6075 | 37110 | 558 |
1479019 | 1479019 | 2021-07-03 | San Francisco | California | 6075 | 37110 | 558 |
1475773 | 1475773 | 2021-07-02 | San Francisco | California | 6075 | 37110 | 558 |
1472527 | 1472527 | 2021-07-01 | San Francisco | California | 6075 | 37068 | 558 |
1469282 | 1469282 | 2021-06-30 | San Francisco | California | 6075 | 37044 | 558 |
1466037 | 1466037 | 2021-06-29 | San Francisco | California | 6075 | 37375 | 559 |
1462792 | 1462792 | 2021-06-28 | San Francisco | California | 6075 | 37363 | 559 |
1459547 | 1459547 | 2021-06-27 | San Francisco | California | 6075 | 37351 | 559 |
1456302 | 1456302 | 2021-06-26 | San Francisco | California | 6075 | 37341 | 559 |
1453057 | 1453057 | 2021-06-25 | San Francisco | California | 6075 | 37323 | 559 |
1449811 | 1449811 | 2021-06-24 | San Francisco | California | 6075 | 37307 | 559 |
1446566 | 1446566 | 2021-06-23 | San Francisco | California | 6075 | 37290 | 556 |
1443321 | 1443321 | 2021-06-22 | San Francisco | California | 6075 | 37278 | 556 |
1440076 | 1440076 | 2021-06-21 | San Francisco | California | 6075 | 37272 | 556 |
1436829 | 1436829 | 2021-06-20 | San Francisco | California | 6075 | 37259 | 556 |
1433582 | 1433582 | 2021-06-19 | San Francisco | California | 6075 | 37249 | 556 |
1430336 | 1430336 | 2021-06-18 | San Francisco | California | 6075 | 37246 | 556 |
1427091 | 1427091 | 2021-06-17 | San Francisco | California | 6075 | 37225 | 555 |
1423846 | 1423846 | 2021-06-16 | San Francisco | California | 6075 | 37213 | 555 |
1420598 | 1420598 | 2021-06-15 | San Francisco | California | 6075 | 37209 | 555 |
1417353 | 1417353 | 2021-06-14 | San Francisco | California | 6075 | 37200 | 555 |
1414107 | 1414107 | 2021-06-13 | San Francisco | California | 6075 | 37192 | 555 |
1410862 | 1410862 | 2021-06-12 | San Francisco | California | 6075 | 37180 | 555 |
1407617 | 1407617 | 2021-06-11 | San Francisco | California | 6075 | 37162 | 552 |
1404371 | 1404371 | 2021-06-10 | San Francisco | California | 6075 | 37146 | 552 |
1401126 | 1401126 | 2021-06-09 | San Francisco | California | 6075 | 37137 | 552 |
1397881 | 1397881 | 2021-06-08 | San Francisco | California | 6075 | 37125 | 552 |
1394634 | 1394634 | 2021-06-07 | San Francisco | California | 6075 | 37121 | 552 |
1391389 | 1391389 | 2021-06-06 | San Francisco | California | 6075 | 37114 | 552 |
1388144 | 1388144 | 2021-06-05 | San Francisco | California | 6075 | 37082 | 551 |
1384899 | 1384899 | 2021-06-04 | San Francisco | California | 6075 | 37075 | 551 |
1381653 | 1381653 | 2021-06-03 | San Francisco | California | 6075 | 37053 | 550 |
1378408 | 1378408 | 2021-06-02 | San Francisco | California | 6075 | 37034 | 550 |
1375162 | 1375162 | 2021-06-01 | San Francisco | California | 6075 | 37025 | 550 |
1371917 | 1371917 | 2021-05-31 | San Francisco | California | 6075 | 37019 | 550 |
1368672 | 1368672 | 2021-05-30 | San Francisco | California | 6075 | 37011 | 550 |
1365426 | 1365426 | 2021-05-29 | San Francisco | California | 6075 | 36990 | 546 |
1362180 | 1362180 | 2021-05-28 | San Francisco | California | 6075 | 36983 | 546 |
1358933 | 1358933 | 2021-05-27 | San Francisco | California | 6075 | 36957 | 546 |
1355687 | 1355687 | 2021-05-26 | San Francisco | California | 6075 | 36942 | 546 |
1352441 | 1352441 | 2021-05-25 | San Francisco | California | 6075 | 36937 | 547 |
1349195 | 1349195 | 2021-05-24 | San Francisco | California | 6075 | 36930 | 547 |
1345948 | 1345948 | 2021-05-23 | San Francisco | California | 6075 | 36909 | 547 |
1342700 | 1342700 | 2021-05-22 | San Francisco | California | 6075 | 36882 | 546 |
1339452 | 1339452 | 2021-05-21 | San Francisco | California | 6075 | 36863 | 546 |
1336205 | 1336205 | 2021-05-20 | San Francisco | California | 6075 | 36838 | 546 |
1332958 | 1332958 | 2021-05-19 | San Francisco | California | 6075 | 36821 | 546 |
1329711 | 1329711 | 2021-05-18 | San Francisco | California | 6075 | 36819 | 546 |
1326464 | 1326464 | 2021-05-17 | San Francisco | California | 6075 | 36811 | 546 |
1323218 | 1323218 | 2021-05-16 | San Francisco | California | 6075 | 36798 | 546 |
1319972 | 1319972 | 2021-05-15 | San Francisco | California | 6075 | 36774 | 545 |
1316725 | 1316725 | 2021-05-14 | San Francisco | California | 6075 | 36744 | 544 |
1313478 | 1313478 | 2021-05-13 | San Francisco | California | 6075 | 36723 | 544 |
1310231 | 1310231 | 2021-05-12 | San Francisco | California | 6075 | 36710 | 543 |
1306985 | 1306985 | 2021-05-11 | San Francisco | California | 6075 | 36686 | 543 |
1303739 | 1303739 | 2021-05-10 | San Francisco | California | 6075 | 36672 | 543 |
1300492 | 1300492 | 2021-05-09 | San Francisco | California | 6075 | 36645 | 543 |
1297245 | 1297245 | 2021-05-08 | San Francisco | California | 6075 | 36619 | 543 |
1293999 | 1293999 | 2021-05-07 | San Francisco | California | 6075 | 36602 | 543 |
1290753 | 1290753 | 2021-05-06 | San Francisco | California | 6075 | 36580 | 543 |
1287507 | 1287507 | 2021-05-05 | San Francisco | California | 6075 | 36553 | 541 |
1284261 | 1284261 | 2021-05-04 | San Francisco | California | 6075 | 36541 | 541 |
1281014 | 1281014 | 2021-05-03 | San Francisco | California | 6075 | 36525 | 541 |
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 |
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);