ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 41053 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419381 | 1419381 | 2021-06-14 | Polk | Oregon | 41053 | 3937 | 55 |
1416136 | 1416136 | 2021-06-13 | Polk | Oregon | 41053 | 3937 | 55 |
1412890 | 1412890 | 2021-06-12 | Polk | Oregon | 41053 | 3933 | 55 |
1409645 | 1409645 | 2021-06-11 | Polk | Oregon | 41053 | 3930 | 55 |
1406400 | 1406400 | 2021-06-10 | Polk | Oregon | 41053 | 3924 | 55 |
1403154 | 1403154 | 2021-06-09 | Polk | Oregon | 41053 | 3918 | 55 |
1399909 | 1399909 | 2021-06-08 | Polk | Oregon | 41053 | 3911 | 55 |
1396664 | 1396664 | 2021-06-07 | Polk | Oregon | 41053 | 3909 | 55 |
1393417 | 1393417 | 2021-06-06 | Polk | Oregon | 41053 | 3907 | 55 |
1390172 | 1390172 | 2021-06-05 | Polk | Oregon | 41053 | 3900 | 55 |
1386927 | 1386927 | 2021-06-04 | Polk | Oregon | 41053 | 3898 | 55 |
1383682 | 1383682 | 2021-06-03 | Polk | Oregon | 41053 | 3890 | 55 |
1380436 | 1380436 | 2021-06-02 | Polk | Oregon | 41053 | 3889 | 53 |
1377191 | 1377191 | 2021-06-01 | Polk | Oregon | 41053 | 3879 | 53 |
1373945 | 1373945 | 2021-05-31 | Polk | Oregon | 41053 | 3878 | 53 |
1370700 | 1370700 | 2021-05-30 | Polk | Oregon | 41053 | 3873 | 53 |
1367454 | 1367454 | 2021-05-29 | Polk | Oregon | 41053 | 3872 | 53 |
1364208 | 1364208 | 2021-05-28 | Polk | Oregon | 41053 | 3866 | 53 |
1360962 | 1360962 | 2021-05-27 | Polk | Oregon | 41053 | 3853 | 53 |
1357716 | 1357716 | 2021-05-26 | Polk | Oregon | 41053 | 3849 | 53 |
1354470 | 1354470 | 2021-05-25 | Polk | Oregon | 41053 | 3849 | 53 |
1351224 | 1351224 | 2021-05-24 | Polk | Oregon | 41053 | 3845 | 53 |
1347978 | 1347978 | 2021-05-23 | Polk | Oregon | 41053 | 3836 | 53 |
1344730 | 1344730 | 2021-05-22 | Polk | Oregon | 41053 | 3832 | 53 |
1341482 | 1341482 | 2021-05-21 | Polk | Oregon | 41053 | 3822 | 53 |
1338234 | 1338234 | 2021-05-20 | Polk | Oregon | 41053 | 3818 | 53 |
1334987 | 1334987 | 2021-05-19 | Polk | Oregon | 41053 | 3808 | 53 |
1331740 | 1331740 | 2021-05-18 | Polk | Oregon | 41053 | 3800 | 53 |
1328493 | 1328493 | 2021-05-17 | Polk | Oregon | 41053 | 3794 | 53 |
1325247 | 1325247 | 2021-05-16 | Polk | Oregon | 41053 | 3788 | 53 |
1322001 | 1322001 | 2021-05-15 | Polk | Oregon | 41053 | 3779 | 53 |
1318755 | 1318755 | 2021-05-14 | Polk | Oregon | 41053 | 3772 | 53 |
1315507 | 1315507 | 2021-05-13 | Polk | Oregon | 41053 | 3757 | 52 |
1312261 | 1312261 | 2021-05-12 | Polk | Oregon | 41053 | 3733 | 52 |
1309014 | 1309014 | 2021-05-11 | Polk | Oregon | 41053 | 3722 | 52 |
1305768 | 1305768 | 2021-05-10 | Polk | Oregon | 41053 | 3713 | 52 |
1302522 | 1302522 | 2021-05-09 | Polk | Oregon | 41053 | 3710 | 52 |
1299274 | 1299274 | 2021-05-08 | Polk | Oregon | 41053 | 3699 | 52 |
1296028 | 1296028 | 2021-05-07 | Polk | Oregon | 41053 | 3691 | 52 |
1292782 | 1292782 | 2021-05-06 | Polk | Oregon | 41053 | 3678 | 52 |
1289536 | 1289536 | 2021-05-05 | Polk | Oregon | 41053 | 3657 | 52 |
1286290 | 1286290 | 2021-05-04 | Polk | Oregon | 41053 | 3642 | 52 |
1283044 | 1283044 | 2021-05-03 | Polk | Oregon | 41053 | 3625 | 52 |
1279797 | 1279797 | 2021-05-02 | Polk | Oregon | 41053 | 3612 | 52 |
1276550 | 1276550 | 2021-05-01 | Polk | Oregon | 41053 | 3600 | 52 |
1273303 | 1273303 | 2021-04-30 | Polk | Oregon | 41053 | 3595 | 52 |
1270056 | 1270056 | 2021-04-29 | Polk | Oregon | 41053 | 3582 | 52 |
1266809 | 1266809 | 2021-04-28 | Polk | Oregon | 41053 | 3567 | 52 |
1263562 | 1263562 | 2021-04-27 | Polk | Oregon | 41053 | 3553 | 52 |
1260315 | 1260315 | 2021-04-26 | Polk | Oregon | 41053 | 3544 | 52 |
1257068 | 1257068 | 2021-04-25 | Polk | Oregon | 41053 | 3534 | 52 |
1253821 | 1253821 | 2021-04-24 | Polk | Oregon | 41053 | 3527 | 52 |
1250574 | 1250574 | 2021-04-23 | Polk | Oregon | 41053 | 3517 | 52 |
1247327 | 1247327 | 2021-04-22 | Polk | Oregon | 41053 | 3503 | 52 |
1244080 | 1244080 | 2021-04-21 | Polk | Oregon | 41053 | 3484 | 52 |
1240833 | 1240833 | 2021-04-20 | Polk | Oregon | 41053 | 3464 | 52 |
1237586 | 1237586 | 2021-04-19 | Polk | Oregon | 41053 | 3457 | 52 |
1234339 | 1234339 | 2021-04-18 | Polk | Oregon | 41053 | 3442 | 52 |
1231091 | 1231091 | 2021-04-17 | Polk | Oregon | 41053 | 3429 | 52 |
1227843 | 1227843 | 2021-04-16 | Polk | Oregon | 41053 | 3417 | 52 |
1224595 | 1224595 | 2021-04-15 | Polk | Oregon | 41053 | 3404 | 52 |
1221348 | 1221348 | 2021-04-14 | Polk | Oregon | 41053 | 3383 | 51 |
1218100 | 1218100 | 2021-04-13 | Polk | Oregon | 41053 | 3363 | 51 |
1214852 | 1214852 | 2021-04-12 | Polk | Oregon | 41053 | 3357 | 51 |
1211605 | 1211605 | 2021-04-11 | Polk | Oregon | 41053 | 3354 | 51 |
1208356 | 1208356 | 2021-04-10 | Polk | Oregon | 41053 | 3343 | 51 |
1205108 | 1205108 | 2021-04-09 | Polk | Oregon | 41053 | 3332 | 51 |
1201860 | 1201860 | 2021-04-08 | Polk | Oregon | 41053 | 3321 | 51 |
1198611 | 1198611 | 2021-04-07 | Polk | Oregon | 41053 | 3307 | 50 |
1195362 | 1195362 | 2021-04-06 | Polk | Oregon | 41053 | 3298 | 49 |
1192114 | 1192114 | 2021-04-05 | Polk | Oregon | 41053 | 3289 | 48 |
1188865 | 1188865 | 2021-04-04 | Polk | Oregon | 41053 | 3275 | 48 |
1185618 | 1185618 | 2021-04-03 | Polk | Oregon | 41053 | 3262 | 48 |
1182371 | 1182371 | 2021-04-02 | Polk | Oregon | 41053 | 3251 | 48 |
1179124 | 1179124 | 2021-04-01 | Polk | Oregon | 41053 | 3235 | 48 |
1175877 | 1175877 | 2021-03-31 | Polk | Oregon | 41053 | 3223 | 48 |
1172630 | 1172630 | 2021-03-30 | Polk | Oregon | 41053 | 3214 | 48 |
1169383 | 1169383 | 2021-03-29 | Polk | Oregon | 41053 | 3202 | 48 |
1166135 | 1166135 | 2021-03-28 | Polk | Oregon | 41053 | 3196 | 48 |
1162887 | 1162887 | 2021-03-27 | Polk | Oregon | 41053 | 3194 | 48 |
1159638 | 1159638 | 2021-03-26 | Polk | Oregon | 41053 | 3189 | 48 |
1156391 | 1156391 | 2021-03-25 | Polk | Oregon | 41053 | 3175 | 48 |
1153144 | 1153144 | 2021-03-24 | Polk | Oregon | 41053 | 3167 | 48 |
1149897 | 1149897 | 2021-03-23 | Polk | Oregon | 41053 | 3162 | 48 |
1146650 | 1146650 | 2021-03-22 | Polk | Oregon | 41053 | 3156 | 48 |
1143403 | 1143403 | 2021-03-21 | Polk | Oregon | 41053 | 3155 | 48 |
1140156 | 1140156 | 2021-03-20 | Polk | Oregon | 41053 | 3152 | 48 |
1136910 | 1136910 | 2021-03-19 | Polk | Oregon | 41053 | 3150 | 48 |
1133664 | 1133664 | 2021-03-18 | Polk | Oregon | 41053 | 3145 | 48 |
1130416 | 1130416 | 2021-03-17 | Polk | Oregon | 41053 | 3141 | 48 |
1127169 | 1127169 | 2021-03-16 | Polk | Oregon | 41053 | 3140 | 48 |
1123923 | 1123923 | 2021-03-15 | Polk | Oregon | 41053 | 3135 | 46 |
1120677 | 1120677 | 2021-03-14 | Polk | Oregon | 41053 | 3128 | 46 |
1117430 | 1117430 | 2021-03-13 | Polk | Oregon | 41053 | 3125 | 46 |
1114183 | 1114183 | 2021-03-12 | Polk | Oregon | 41053 | 3121 | 46 |
1110937 | 1110937 | 2021-03-11 | Polk | Oregon | 41053 | 3114 | 46 |
1107691 | 1107691 | 2021-03-10 | Polk | Oregon | 41053 | 3107 | 45 |
1104445 | 1104445 | 2021-03-09 | Polk | Oregon | 41053 | 3107 | 45 |
1101199 | 1101199 | 2021-03-08 | Polk | Oregon | 41053 | 3099 | 45 |
1097953 | 1097953 | 2021-03-07 | Polk | Oregon | 41053 | 3096 | 45 |
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);