ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
738 rows where fips = 41001 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419355 | 1419355 | 2021-06-14 | Baker | Oregon | 41001 | 993 | 15 |
1416110 | 1416110 | 2021-06-13 | Baker | Oregon | 41001 | 992 | 15 |
1412864 | 1412864 | 2021-06-12 | Baker | Oregon | 41001 | 990 | 15 |
1409619 | 1409619 | 2021-06-11 | Baker | Oregon | 41001 | 988 | 15 |
1406374 | 1406374 | 2021-06-10 | Baker | Oregon | 41001 | 988 | 15 |
1403128 | 1403128 | 2021-06-09 | Baker | Oregon | 41001 | 987 | 15 |
1399883 | 1399883 | 2021-06-08 | Baker | Oregon | 41001 | 985 | 15 |
1396638 | 1396638 | 2021-06-07 | Baker | Oregon | 41001 | 983 | 15 |
1393391 | 1393391 | 2021-06-06 | Baker | Oregon | 41001 | 982 | 15 |
1390146 | 1390146 | 2021-06-05 | Baker | Oregon | 41001 | 981 | 15 |
1386901 | 1386901 | 2021-06-04 | Baker | Oregon | 41001 | 980 | 15 |
1383656 | 1383656 | 2021-06-03 | Baker | Oregon | 41001 | 977 | 15 |
1380410 | 1380410 | 2021-06-02 | Baker | Oregon | 41001 | 975 | 15 |
1377165 | 1377165 | 2021-06-01 | Baker | Oregon | 41001 | 971 | 15 |
1373919 | 1373919 | 2021-05-31 | Baker | Oregon | 41001 | 971 | 15 |
1370674 | 1370674 | 2021-05-30 | Baker | Oregon | 41001 | 971 | 15 |
1367428 | 1367428 | 2021-05-29 | Baker | Oregon | 41001 | 971 | 15 |
1364182 | 1364182 | 2021-05-28 | Baker | Oregon | 41001 | 971 | 15 |
1360936 | 1360936 | 2021-05-27 | Baker | Oregon | 41001 | 969 | 15 |
1357690 | 1357690 | 2021-05-26 | Baker | Oregon | 41001 | 967 | 15 |
1354444 | 1354444 | 2021-05-25 | Baker | Oregon | 41001 | 964 | 15 |
1351198 | 1351198 | 2021-05-24 | Baker | Oregon | 41001 | 962 | 15 |
1347952 | 1347952 | 2021-05-23 | Baker | Oregon | 41001 | 962 | 15 |
1344704 | 1344704 | 2021-05-22 | Baker | Oregon | 41001 | 962 | 15 |
1341456 | 1341456 | 2021-05-21 | Baker | Oregon | 41001 | 962 | 15 |
1338208 | 1338208 | 2021-05-20 | Baker | Oregon | 41001 | 963 | 15 |
1334961 | 1334961 | 2021-05-19 | Baker | Oregon | 41001 | 962 | 14 |
1331714 | 1331714 | 2021-05-18 | Baker | Oregon | 41001 | 961 | 14 |
1328467 | 1328467 | 2021-05-17 | Baker | Oregon | 41001 | 960 | 14 |
1325221 | 1325221 | 2021-05-16 | Baker | Oregon | 41001 | 959 | 14 |
1321975 | 1321975 | 2021-05-15 | Baker | Oregon | 41001 | 959 | 14 |
1318729 | 1318729 | 2021-05-14 | Baker | Oregon | 41001 | 958 | 14 |
1315481 | 1315481 | 2021-05-13 | Baker | Oregon | 41001 | 954 | 14 |
1312235 | 1312235 | 2021-05-12 | Baker | Oregon | 41001 | 949 | 14 |
1308988 | 1308988 | 2021-05-11 | Baker | Oregon | 41001 | 947 | 14 |
1305742 | 1305742 | 2021-05-10 | Baker | Oregon | 41001 | 947 | 14 |
1302496 | 1302496 | 2021-05-09 | Baker | Oregon | 41001 | 946 | 14 |
1299248 | 1299248 | 2021-05-08 | Baker | Oregon | 41001 | 946 | 14 |
1296002 | 1296002 | 2021-05-07 | Baker | Oregon | 41001 | 939 | 14 |
1292756 | 1292756 | 2021-05-06 | Baker | Oregon | 41001 | 938 | 14 |
1289510 | 1289510 | 2021-05-05 | Baker | Oregon | 41001 | 927 | 14 |
1286264 | 1286264 | 2021-05-04 | Baker | Oregon | 41001 | 923 | 14 |
1283018 | 1283018 | 2021-05-03 | Baker | Oregon | 41001 | 920 | 14 |
1279771 | 1279771 | 2021-05-02 | Baker | Oregon | 41001 | 919 | 14 |
1276524 | 1276524 | 2021-05-01 | Baker | Oregon | 41001 | 919 | 14 |
1273277 | 1273277 | 2021-04-30 | Baker | Oregon | 41001 | 917 | 14 |
1270030 | 1270030 | 2021-04-29 | Baker | Oregon | 41001 | 915 | 14 |
1266783 | 1266783 | 2021-04-28 | Baker | Oregon | 41001 | 911 | 14 |
1263536 | 1263536 | 2021-04-27 | Baker | Oregon | 41001 | 907 | 14 |
1260289 | 1260289 | 2021-04-26 | Baker | Oregon | 41001 | 902 | 14 |
1257042 | 1257042 | 2021-04-25 | Baker | Oregon | 41001 | 900 | 14 |
1253795 | 1253795 | 2021-04-24 | Baker | Oregon | 41001 | 898 | 14 |
1250548 | 1250548 | 2021-04-23 | Baker | Oregon | 41001 | 892 | 14 |
1247301 | 1247301 | 2021-04-22 | Baker | Oregon | 41001 | 881 | 14 |
1244054 | 1244054 | 2021-04-21 | Baker | Oregon | 41001 | 867 | 14 |
1240807 | 1240807 | 2021-04-20 | Baker | Oregon | 41001 | 861 | 14 |
1237560 | 1237560 | 2021-04-19 | Baker | Oregon | 41001 | 861 | 14 |
1234313 | 1234313 | 2021-04-18 | Baker | Oregon | 41001 | 858 | 14 |
1231065 | 1231065 | 2021-04-17 | Baker | Oregon | 41001 | 856 | 14 |
1227817 | 1227817 | 2021-04-16 | Baker | Oregon | 41001 | 851 | 14 |
1224569 | 1224569 | 2021-04-15 | Baker | Oregon | 41001 | 842 | 14 |
1221322 | 1221322 | 2021-04-14 | Baker | Oregon | 41001 | 826 | 13 |
1218074 | 1218074 | 2021-04-13 | Baker | Oregon | 41001 | 812 | 13 |
1214826 | 1214826 | 2021-04-12 | Baker | Oregon | 41001 | 807 | 13 |
1211579 | 1211579 | 2021-04-11 | Baker | Oregon | 41001 | 801 | 13 |
1208330 | 1208330 | 2021-04-10 | Baker | Oregon | 41001 | 800 | 13 |
1205082 | 1205082 | 2021-04-09 | Baker | Oregon | 41001 | 794 | 13 |
1201834 | 1201834 | 2021-04-08 | Baker | Oregon | 41001 | 790 | 13 |
1198585 | 1198585 | 2021-04-07 | Baker | Oregon | 41001 | 787 | 12 |
1195336 | 1195336 | 2021-04-06 | Baker | Oregon | 41001 | 783 | 12 |
1192088 | 1192088 | 2021-04-05 | Baker | Oregon | 41001 | 779 | 12 |
1188839 | 1188839 | 2021-04-04 | Baker | Oregon | 41001 | 779 | 12 |
1185592 | 1185592 | 2021-04-03 | Baker | Oregon | 41001 | 778 | 12 |
1182345 | 1182345 | 2021-04-02 | Baker | Oregon | 41001 | 765 | 12 |
1179098 | 1179098 | 2021-04-01 | Baker | Oregon | 41001 | 757 | 12 |
1175851 | 1175851 | 2021-03-31 | Baker | Oregon | 41001 | 750 | 12 |
1172604 | 1172604 | 2021-03-30 | Baker | Oregon | 41001 | 743 | 12 |
1169357 | 1169357 | 2021-03-29 | Baker | Oregon | 41001 | 733 | 12 |
1166109 | 1166109 | 2021-03-28 | Baker | Oregon | 41001 | 730 | 12 |
1162861 | 1162861 | 2021-03-27 | Baker | Oregon | 41001 | 728 | 12 |
1159612 | 1159612 | 2021-03-26 | Baker | Oregon | 41001 | 721 | 12 |
1156365 | 1156365 | 2021-03-25 | Baker | Oregon | 41001 | 718 | 12 |
1153118 | 1153118 | 2021-03-24 | Baker | Oregon | 41001 | 708 | 12 |
1149871 | 1149871 | 2021-03-23 | Baker | Oregon | 41001 | 702 | 12 |
1146624 | 1146624 | 2021-03-22 | Baker | Oregon | 41001 | 699 | 12 |
1143377 | 1143377 | 2021-03-21 | Baker | Oregon | 41001 | 699 | 12 |
1140130 | 1140130 | 2021-03-20 | Baker | Oregon | 41001 | 698 | 12 |
1136884 | 1136884 | 2021-03-19 | Baker | Oregon | 41001 | 697 | 12 |
1133638 | 1133638 | 2021-03-18 | Baker | Oregon | 41001 | 695 | 12 |
1130390 | 1130390 | 2021-03-17 | Baker | Oregon | 41001 | 692 | 12 |
1127143 | 1127143 | 2021-03-16 | Baker | Oregon | 41001 | 691 | 12 |
1123897 | 1123897 | 2021-03-15 | Baker | Oregon | 41001 | 691 | 11 |
1120651 | 1120651 | 2021-03-14 | Baker | Oregon | 41001 | 690 | 11 |
1117404 | 1117404 | 2021-03-13 | Baker | Oregon | 41001 | 689 | 11 |
1114157 | 1114157 | 2021-03-12 | Baker | Oregon | 41001 | 687 | 11 |
1110911 | 1110911 | 2021-03-11 | Baker | Oregon | 41001 | 684 | 11 |
1107665 | 1107665 | 2021-03-10 | Baker | Oregon | 41001 | 680 | 10 |
1104419 | 1104419 | 2021-03-09 | Baker | Oregon | 41001 | 680 | 10 |
1101173 | 1101173 | 2021-03-08 | Baker | Oregon | 41001 | 676 | 9 |
1097927 | 1097927 | 2021-03-07 | Baker | Oregon | 41001 | 676 | 9 |
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);