ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
810 rows where fips = 53063 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1520845 | 1520845 | 2021-07-15 | Spokane | Washington | 53063 | 47879 | 689 |
1517597 | 1517597 | 2021-07-14 | Spokane | Washington | 53063 | 47841 | 688 |
1514350 | 1514350 | 2021-07-13 | Spokane | Washington | 53063 | 47798 | 688 |
1511104 | 1511104 | 2021-07-12 | Spokane | Washington | 53063 | 47769 | 686 |
1507857 | 1507857 | 2021-07-11 | Spokane | Washington | 53063 | 47663 | 686 |
1504611 | 1504611 | 2021-07-10 | Spokane | Washington | 53063 | 47663 | 686 |
1501365 | 1501365 | 2021-07-09 | Spokane | Washington | 53063 | 47663 | 686 |
1498119 | 1498119 | 2021-07-08 | Spokane | Washington | 53063 | 47645 | 684 |
1494872 | 1494872 | 2021-07-07 | Spokane | Washington | 53063 | 47618 | 682 |
1491625 | 1491625 | 2021-07-06 | Spokane | Washington | 53063 | 47576 | 680 |
1488378 | 1488378 | 2021-07-05 | Spokane | Washington | 53063 | 47506 | 680 |
1485131 | 1485131 | 2021-07-04 | Spokane | Washington | 53063 | 47506 | 680 |
1481885 | 1481885 | 2021-07-03 | Spokane | Washington | 53063 | 47506 | 680 |
1478638 | 1478638 | 2021-07-02 | Spokane | Washington | 53063 | 47506 | 680 |
1475392 | 1475392 | 2021-07-01 | Spokane | Washington | 53063 | 47489 | 680 |
1472146 | 1472146 | 2021-06-30 | Spokane | Washington | 53063 | 47453 | 679 |
1468901 | 1468901 | 2021-06-29 | Spokane | Washington | 53063 | 47452 | 679 |
1465656 | 1465656 | 2021-06-28 | Spokane | Washington | 53063 | 47417 | 675 |
1462411 | 1462411 | 2021-06-27 | Spokane | Washington | 53063 | 47348 | 675 |
1459166 | 1459166 | 2021-06-26 | Spokane | Washington | 53063 | 47348 | 675 |
1455921 | 1455921 | 2021-06-25 | Spokane | Washington | 53063 | 47348 | 675 |
1452676 | 1452676 | 2021-06-24 | Spokane | Washington | 53063 | 47307 | 674 |
1449430 | 1449430 | 2021-06-23 | Spokane | Washington | 53063 | 47278 | 675 |
1446185 | 1446185 | 2021-06-22 | Spokane | Washington | 53063 | 47235 | 672 |
1442940 | 1442940 | 2021-06-21 | Spokane | Washington | 53063 | 47190 | 672 |
1439695 | 1439695 | 2021-06-20 | Spokane | Washington | 53063 | 47054 | 671 |
1436448 | 1436448 | 2021-06-19 | Spokane | Washington | 53063 | 47054 | 671 |
1433201 | 1433201 | 2021-06-18 | Spokane | Washington | 53063 | 47054 | 671 |
1429955 | 1429955 | 2021-06-17 | Spokane | Washington | 53063 | 47018 | 671 |
1426710 | 1426710 | 2021-06-16 | Spokane | Washington | 53063 | 46945 | 671 |
1423464 | 1423464 | 2021-06-15 | Spokane | Washington | 53063 | 46903 | 670 |
1420217 | 1420217 | 2021-06-14 | Spokane | Washington | 53063 | 46833 | 668 |
1416972 | 1416972 | 2021-06-13 | Spokane | Washington | 53063 | 46696 | 668 |
1413726 | 1413726 | 2021-06-12 | Spokane | Washington | 53063 | 46696 | 668 |
1410481 | 1410481 | 2021-06-11 | Spokane | Washington | 53063 | 46696 | 668 |
1407236 | 1407236 | 2021-06-10 | Spokane | Washington | 53063 | 46653 | 667 |
1403990 | 1403990 | 2021-06-09 | Spokane | Washington | 53063 | 46582 | 667 |
1400745 | 1400745 | 2021-06-08 | Spokane | Washington | 53063 | 46508 | 664 |
1397500 | 1397500 | 2021-06-07 | Spokane | Washington | 53063 | 46442 | 666 |
1394253 | 1394253 | 2021-06-06 | Spokane | Washington | 53063 | 46234 | 663 |
1391008 | 1391008 | 2021-06-05 | Spokane | Washington | 53063 | 46234 | 663 |
1387763 | 1387763 | 2021-06-04 | Spokane | Washington | 53063 | 46234 | 663 |
1384518 | 1384518 | 2021-06-03 | Spokane | Washington | 53063 | 46149 | 658 |
1381272 | 1381272 | 2021-06-02 | Spokane | Washington | 53063 | 46013 | 652 |
1378027 | 1378027 | 2021-06-01 | Spokane | Washington | 53063 | 45847 | 650 |
1374781 | 1374781 | 2021-05-31 | Spokane | Washington | 53063 | 45545 | 646 |
1371536 | 1371536 | 2021-05-30 | Spokane | Washington | 53063 | 45545 | 646 |
1368290 | 1368290 | 2021-05-29 | Spokane | Washington | 53063 | 45545 | 646 |
1365044 | 1365044 | 2021-05-28 | Spokane | Washington | 53063 | 45545 | 646 |
1361798 | 1361798 | 2021-05-27 | Spokane | Washington | 53063 | 45373 | 646 |
1358552 | 1358552 | 2021-05-26 | Spokane | Washington | 53063 | 45151 | 645 |
1355306 | 1355306 | 2021-05-25 | Spokane | Washington | 53063 | 44885 | 643 |
1352060 | 1352060 | 2021-05-24 | Spokane | Washington | 53063 | 44684 | 643 |
1348814 | 1348814 | 2021-05-23 | Spokane | Washington | 53063 | 44411 | 643 |
1345566 | 1345566 | 2021-05-22 | Spokane | Washington | 53063 | 44411 | 643 |
1342318 | 1342318 | 2021-05-21 | Spokane | Washington | 53063 | 44411 | 643 |
1339070 | 1339070 | 2021-05-20 | Spokane | Washington | 53063 | 44156 | 642 |
1335823 | 1335823 | 2021-05-19 | Spokane | Washington | 53063 | 44039 | 636 |
1332576 | 1332576 | 2021-05-18 | Spokane | Washington | 53063 | 43929 | 636 |
1329329 | 1329329 | 2021-05-17 | Spokane | Washington | 53063 | 43815 | 636 |
1326083 | 1326083 | 2021-05-16 | Spokane | Washington | 53063 | 43771 | 635 |
1322837 | 1322837 | 2021-05-15 | Spokane | Washington | 53063 | 43689 | 635 |
1319591 | 1319591 | 2021-05-14 | Spokane | Washington | 53063 | 43543 | 635 |
1316343 | 1316343 | 2021-05-13 | Spokane | Washington | 53063 | 43415 | 636 |
1313097 | 1313097 | 2021-05-12 | Spokane | Washington | 53063 | 43270 | 636 |
1309850 | 1309850 | 2021-05-11 | Spokane | Washington | 53063 | 43163 | 635 |
1306604 | 1306604 | 2021-05-10 | Spokane | Washington | 53063 | 43082 | 635 |
1303358 | 1303358 | 2021-05-09 | Spokane | Washington | 53063 | 42984 | 635 |
1300111 | 1300111 | 2021-05-08 | Spokane | Washington | 53063 | 42915 | 635 |
1296864 | 1296864 | 2021-05-07 | Spokane | Washington | 53063 | 42784 | 635 |
1293618 | 1293618 | 2021-05-06 | Spokane | Washington | 53063 | 42650 | 633 |
1290372 | 1290372 | 2021-05-05 | Spokane | Washington | 53063 | 42550 | 629 |
1287126 | 1287126 | 2021-05-04 | Spokane | Washington | 53063 | 42485 | 625 |
1283880 | 1283880 | 2021-05-03 | Spokane | Washington | 53063 | 42368 | 625 |
1280633 | 1280633 | 2021-05-02 | Spokane | Washington | 53063 | 42298 | 625 |
1277386 | 1277386 | 2021-05-01 | Spokane | Washington | 53063 | 42192 | 625 |
1274139 | 1274139 | 2021-04-30 | Spokane | Washington | 53063 | 42037 | 625 |
1270892 | 1270892 | 2021-04-29 | Spokane | Washington | 53063 | 41917 | 622 |
1267645 | 1267645 | 2021-04-28 | Spokane | Washington | 53063 | 41804 | 621 |
1264398 | 1264398 | 2021-04-27 | Spokane | Washington | 53063 | 41721 | 619 |
1261151 | 1261151 | 2021-04-26 | Spokane | Washington | 53063 | 41656 | 617 |
1257904 | 1257904 | 2021-04-25 | Spokane | Washington | 53063 | 41543 | 617 |
1254657 | 1254657 | 2021-04-24 | Spokane | Washington | 53063 | 41469 | 617 |
1251410 | 1251410 | 2021-04-23 | Spokane | Washington | 53063 | 41353 | 617 |
1248163 | 1248163 | 2021-04-22 | Spokane | Washington | 53063 | 41211 | 616 |
1244916 | 1244916 | 2021-04-21 | Spokane | Washington | 53063 | 41123 | 614 |
1241669 | 1241669 | 2021-04-20 | Spokane | Washington | 53063 | 41012 | 610 |
1238422 | 1238422 | 2021-04-19 | Spokane | Washington | 53063 | 40878 | 609 |
1235175 | 1235175 | 2021-04-18 | Spokane | Washington | 53063 | 40804 | 607 |
1231927 | 1231927 | 2021-04-17 | Spokane | Washington | 53063 | 40734 | 607 |
1228679 | 1228679 | 2021-04-16 | Spokane | Washington | 53063 | 40549 | 607 |
1225431 | 1225431 | 2021-04-15 | Spokane | Washington | 53063 | 40409 | 604 |
1222184 | 1222184 | 2021-04-14 | Spokane | Washington | 53063 | 40279 | 604 |
1218936 | 1218936 | 2021-04-13 | Spokane | Washington | 53063 | 40208 | 603 |
1215688 | 1215688 | 2021-04-12 | Spokane | Washington | 53063 | 40106 | 603 |
1212441 | 1212441 | 2021-04-11 | Spokane | Washington | 53063 | 39976 | 603 |
1209192 | 1209192 | 2021-04-10 | Spokane | Washington | 53063 | 39903 | 603 |
1205944 | 1205944 | 2021-04-09 | Spokane | Washington | 53063 | 39785 | 603 |
1202696 | 1202696 | 2021-04-08 | Spokane | Washington | 53063 | 39693 | 603 |
1199448 | 1199448 | 2021-04-07 | Spokane | Washington | 53063 | 39591 | 604 |
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);