ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Pend Oreille" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420211 | 1420211 | 2021-06-14 | Pend Oreille | Washington | 53051 | 819 | 9 |
1416966 | 1416966 | 2021-06-13 | Pend Oreille | Washington | 53051 | 817 | 9 |
1413720 | 1413720 | 2021-06-12 | Pend Oreille | Washington | 53051 | 817 | 9 |
1410475 | 1410475 | 2021-06-11 | Pend Oreille | Washington | 53051 | 815 | 9 |
1407230 | 1407230 | 2021-06-10 | Pend Oreille | Washington | 53051 | 810 | 9 |
1403984 | 1403984 | 2021-06-09 | Pend Oreille | Washington | 53051 | 810 | 9 |
1400739 | 1400739 | 2021-06-08 | Pend Oreille | Washington | 53051 | 809 | 9 |
1397494 | 1397494 | 2021-06-07 | Pend Oreille | Washington | 53051 | 809 | 9 |
1394247 | 1394247 | 2021-06-06 | Pend Oreille | Washington | 53051 | 806 | 9 |
1391002 | 1391002 | 2021-06-05 | Pend Oreille | Washington | 53051 | 806 | 9 |
1387757 | 1387757 | 2021-06-04 | Pend Oreille | Washington | 53051 | 804 | 9 |
1384512 | 1384512 | 2021-06-03 | Pend Oreille | Washington | 53051 | 804 | 9 |
1381266 | 1381266 | 2021-06-02 | Pend Oreille | Washington | 53051 | 803 | 9 |
1378021 | 1378021 | 2021-06-01 | Pend Oreille | Washington | 53051 | 801 | 9 |
1374775 | 1374775 | 2021-05-31 | Pend Oreille | Washington | 53051 | 800 | 9 |
1371530 | 1371530 | 2021-05-30 | Pend Oreille | Washington | 53051 | 800 | 9 |
1368284 | 1368284 | 2021-05-29 | Pend Oreille | Washington | 53051 | 800 | 9 |
1365038 | 1365038 | 2021-05-28 | Pend Oreille | Washington | 53051 | 791 | 9 |
1361792 | 1361792 | 2021-05-27 | Pend Oreille | Washington | 53051 | 789 | 9 |
1358546 | 1358546 | 2021-05-26 | Pend Oreille | Washington | 53051 | 784 | 9 |
1355300 | 1355300 | 2021-05-25 | Pend Oreille | Washington | 53051 | 782 | 9 |
1352054 | 1352054 | 2021-05-24 | Pend Oreille | Washington | 53051 | 781 | 9 |
1348808 | 1348808 | 2021-05-23 | Pend Oreille | Washington | 53051 | 777 | 9 |
1345560 | 1345560 | 2021-05-22 | Pend Oreille | Washington | 53051 | 777 | 9 |
1342312 | 1342312 | 2021-05-21 | Pend Oreille | Washington | 53051 | 777 | 9 |
1339064 | 1339064 | 2021-05-20 | Pend Oreille | Washington | 53051 | 774 | 9 |
1335817 | 1335817 | 2021-05-19 | Pend Oreille | Washington | 53051 | 769 | 9 |
1332570 | 1332570 | 2021-05-18 | Pend Oreille | Washington | 53051 | 766 | 9 |
1329323 | 1329323 | 2021-05-17 | Pend Oreille | Washington | 53051 | 764 | 9 |
1326077 | 1326077 | 2021-05-16 | Pend Oreille | Washington | 53051 | 763 | 9 |
1322831 | 1322831 | 2021-05-15 | Pend Oreille | Washington | 53051 | 763 | 9 |
1319585 | 1319585 | 2021-05-14 | Pend Oreille | Washington | 53051 | 757 | 9 |
1316337 | 1316337 | 2021-05-13 | Pend Oreille | Washington | 53051 | 754 | 9 |
1313091 | 1313091 | 2021-05-12 | Pend Oreille | Washington | 53051 | 751 | 9 |
1309844 | 1309844 | 2021-05-11 | Pend Oreille | Washington | 53051 | 751 | 9 |
1306598 | 1306598 | 2021-05-10 | Pend Oreille | Washington | 53051 | 750 | 9 |
1303352 | 1303352 | 2021-05-09 | Pend Oreille | Washington | 53051 | 745 | 8 |
1300105 | 1300105 | 2021-05-08 | Pend Oreille | Washington | 53051 | 745 | 8 |
1296858 | 1296858 | 2021-05-07 | Pend Oreille | Washington | 53051 | 735 | 8 |
1293612 | 1293612 | 2021-05-06 | Pend Oreille | Washington | 53051 | 731 | 7 |
1290366 | 1290366 | 2021-05-05 | Pend Oreille | Washington | 53051 | 729 | 7 |
1287120 | 1287120 | 2021-05-04 | Pend Oreille | Washington | 53051 | 729 | 7 |
1283874 | 1283874 | 2021-05-03 | Pend Oreille | Washington | 53051 | 729 | 7 |
1280627 | 1280627 | 2021-05-02 | Pend Oreille | Washington | 53051 | 723 | 7 |
1277380 | 1277380 | 2021-05-01 | Pend Oreille | Washington | 53051 | 723 | 7 |
1274133 | 1274133 | 2021-04-30 | Pend Oreille | Washington | 53051 | 720 | 7 |
1270886 | 1270886 | 2021-04-29 | Pend Oreille | Washington | 53051 | 718 | 7 |
1267639 | 1267639 | 2021-04-28 | Pend Oreille | Washington | 53051 | 717 | 7 |
1264392 | 1264392 | 2021-04-27 | Pend Oreille | Washington | 53051 | 715 | 7 |
1261145 | 1261145 | 2021-04-26 | Pend Oreille | Washington | 53051 | 713 | 7 |
1257898 | 1257898 | 2021-04-25 | Pend Oreille | Washington | 53051 | 708 | 7 |
1254651 | 1254651 | 2021-04-24 | Pend Oreille | Washington | 53051 | 708 | 7 |
1251404 | 1251404 | 2021-04-23 | Pend Oreille | Washington | 53051 | 708 | 7 |
1248157 | 1248157 | 2021-04-22 | Pend Oreille | Washington | 53051 | 705 | 7 |
1244910 | 1244910 | 2021-04-21 | Pend Oreille | Washington | 53051 | 701 | 7 |
1241663 | 1241663 | 2021-04-20 | Pend Oreille | Washington | 53051 | 701 | 7 |
1238416 | 1238416 | 2021-04-19 | Pend Oreille | Washington | 53051 | 699 | 7 |
1235169 | 1235169 | 2021-04-18 | Pend Oreille | Washington | 53051 | 692 | 7 |
1231921 | 1231921 | 2021-04-17 | Pend Oreille | Washington | 53051 | 692 | 7 |
1228673 | 1228673 | 2021-04-16 | Pend Oreille | Washington | 53051 | 691 | 7 |
1225425 | 1225425 | 2021-04-15 | Pend Oreille | Washington | 53051 | 689 | 7 |
1222178 | 1222178 | 2021-04-14 | Pend Oreille | Washington | 53051 | 689 | 7 |
1218930 | 1218930 | 2021-04-13 | Pend Oreille | Washington | 53051 | 687 | 7 |
1215682 | 1215682 | 2021-04-12 | Pend Oreille | Washington | 53051 | 687 | 7 |
1212435 | 1212435 | 2021-04-11 | Pend Oreille | Washington | 53051 | 688 | 7 |
1209186 | 1209186 | 2021-04-10 | Pend Oreille | Washington | 53051 | 688 | 7 |
1205938 | 1205938 | 2021-04-09 | Pend Oreille | Washington | 53051 | 685 | 7 |
1202690 | 1202690 | 2021-04-08 | Pend Oreille | Washington | 53051 | 683 | 7 |
1199442 | 1199442 | 2021-04-07 | Pend Oreille | Washington | 53051 | 683 | 7 |
1196193 | 1196193 | 2021-04-06 | Pend Oreille | Washington | 53051 | 680 | 7 |
1192945 | 1192945 | 2021-04-05 | Pend Oreille | Washington | 53051 | 679 | 7 |
1189695 | 1189695 | 2021-04-04 | Pend Oreille | Washington | 53051 | 679 | 7 |
1186448 | 1186448 | 2021-04-03 | Pend Oreille | Washington | 53051 | 679 | 7 |
1183201 | 1183201 | 2021-04-02 | Pend Oreille | Washington | 53051 | 679 | 7 |
1179954 | 1179954 | 2021-04-01 | Pend Oreille | Washington | 53051 | 678 | 7 |
1176707 | 1176707 | 2021-03-31 | Pend Oreille | Washington | 53051 | 676 | 7 |
1173460 | 1173460 | 2021-03-30 | Pend Oreille | Washington | 53051 | 673 | 7 |
1170213 | 1170213 | 2021-03-29 | Pend Oreille | Washington | 53051 | 671 | 7 |
1166965 | 1166965 | 2021-03-28 | Pend Oreille | Washington | 53051 | 671 | 7 |
1163717 | 1163717 | 2021-03-27 | Pend Oreille | Washington | 53051 | 671 | 7 |
1160469 | 1160469 | 2021-03-26 | Pend Oreille | Washington | 53051 | 670 | 7 |
1157221 | 1157221 | 2021-03-25 | Pend Oreille | Washington | 53051 | 667 | 7 |
1153974 | 1153974 | 2021-03-24 | Pend Oreille | Washington | 53051 | 664 | 7 |
1150727 | 1150727 | 2021-03-23 | Pend Oreille | Washington | 53051 | 664 | 7 |
1147480 | 1147480 | 2021-03-22 | Pend Oreille | Washington | 53051 | 662 | 7 |
1144233 | 1144233 | 2021-03-21 | Pend Oreille | Washington | 53051 | 657 | 7 |
1140986 | 1140986 | 2021-03-20 | Pend Oreille | Washington | 53051 | 657 | 7 |
1137740 | 1137740 | 2021-03-19 | Pend Oreille | Washington | 53051 | 656 | 7 |
1134494 | 1134494 | 2021-03-18 | Pend Oreille | Washington | 53051 | 654 | 7 |
1131246 | 1131246 | 2021-03-17 | Pend Oreille | Washington | 53051 | 652 | 7 |
1127999 | 1127999 | 2021-03-16 | Pend Oreille | Washington | 53051 | 650 | 7 |
1124753 | 1124753 | 2021-03-15 | Pend Oreille | Washington | 53051 | 648 | 7 |
1121507 | 1121507 | 2021-03-14 | Pend Oreille | Washington | 53051 | 647 | 7 |
1118260 | 1118260 | 2021-03-13 | Pend Oreille | Washington | 53051 | 647 | 7 |
1115013 | 1115013 | 2021-03-12 | Pend Oreille | Washington | 53051 | 647 | 7 |
1111767 | 1111767 | 2021-03-11 | Pend Oreille | Washington | 53051 | 646 | 7 |
1108521 | 1108521 | 2021-03-10 | Pend Oreille | Washington | 53051 | 642 | 7 |
1105275 | 1105275 | 2021-03-09 | Pend Oreille | Washington | 53051 | 642 | 7 |
1102029 | 1102029 | 2021-03-08 | Pend Oreille | Washington | 53051 | 641 | 7 |
1098783 | 1098783 | 2021-03-07 | Pend Oreille | Washington | 53051 | 639 | 7 |
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);