ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where county = "Lake", deaths = 7 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419373 | 1419373 | 2021-06-14 | Lake | Oregon | 41037 | 466 | 7 |
1416128 | 1416128 | 2021-06-13 | Lake | Oregon | 41037 | 466 | 7 |
1412882 | 1412882 | 2021-06-12 | Lake | Oregon | 41037 | 466 | 7 |
1409637 | 1409637 | 2021-06-11 | Lake | Oregon | 41037 | 466 | 7 |
1406392 | 1406392 | 2021-06-10 | Lake | Oregon | 41037 | 465 | 7 |
1403146 | 1403146 | 2021-06-09 | Lake | Oregon | 41037 | 465 | 7 |
1399901 | 1399901 | 2021-06-08 | Lake | Oregon | 41037 | 464 | 7 |
1396656 | 1396656 | 2021-06-07 | Lake | Oregon | 41037 | 464 | 7 |
1393409 | 1393409 | 2021-06-06 | Lake | Oregon | 41037 | 464 | 7 |
1390164 | 1390164 | 2021-06-05 | Lake | Oregon | 41037 | 464 | 7 |
1386919 | 1386919 | 2021-06-04 | Lake | Oregon | 41037 | 463 | 7 |
1383674 | 1383674 | 2021-06-03 | Lake | Oregon | 41037 | 463 | 7 |
1380428 | 1380428 | 2021-06-02 | Lake | Oregon | 41037 | 463 | 7 |
1377183 | 1377183 | 2021-06-01 | Lake | Oregon | 41037 | 462 | 7 |
1373937 | 1373937 | 2021-05-31 | Lake | Oregon | 41037 | 462 | 7 |
1370692 | 1370692 | 2021-05-30 | Lake | Oregon | 41037 | 462 | 7 |
1367446 | 1367446 | 2021-05-29 | Lake | Oregon | 41037 | 462 | 7 |
1364200 | 1364200 | 2021-05-28 | Lake | Oregon | 41037 | 462 | 7 |
1360954 | 1360954 | 2021-05-27 | Lake | Oregon | 41037 | 462 | 7 |
1357708 | 1357708 | 2021-05-26 | Lake | Oregon | 41037 | 462 | 7 |
1354462 | 1354462 | 2021-05-25 | Lake | Oregon | 41037 | 461 | 7 |
1351216 | 1351216 | 2021-05-24 | Lake | Oregon | 41037 | 461 | 7 |
1347970 | 1347970 | 2021-05-23 | Lake | Oregon | 41037 | 461 | 7 |
1344722 | 1344722 | 2021-05-22 | Lake | Oregon | 41037 | 461 | 7 |
1341474 | 1341474 | 2021-05-21 | Lake | Oregon | 41037 | 459 | 7 |
1338226 | 1338226 | 2021-05-20 | Lake | Oregon | 41037 | 459 | 7 |
1334979 | 1334979 | 2021-05-19 | Lake | Oregon | 41037 | 459 | 7 |
1331732 | 1331732 | 2021-05-18 | Lake | Oregon | 41037 | 458 | 7 |
1328485 | 1328485 | 2021-05-17 | Lake | Oregon | 41037 | 455 | 7 |
1325239 | 1325239 | 2021-05-16 | Lake | Oregon | 41037 | 455 | 7 |
1321993 | 1321993 | 2021-05-15 | Lake | Oregon | 41037 | 455 | 7 |
1318747 | 1318747 | 2021-05-14 | Lake | Oregon | 41037 | 454 | 7 |
1315499 | 1315499 | 2021-05-13 | Lake | Oregon | 41037 | 451 | 7 |
1312253 | 1312253 | 2021-05-12 | Lake | Oregon | 41037 | 450 | 7 |
1309006 | 1309006 | 2021-05-11 | Lake | Oregon | 41037 | 448 | 7 |
1305760 | 1305760 | 2021-05-10 | Lake | Oregon | 41037 | 444 | 7 |
1302514 | 1302514 | 2021-05-09 | Lake | Oregon | 41037 | 444 | 7 |
1299266 | 1299266 | 2021-05-08 | Lake | Oregon | 41037 | 444 | 7 |
1296020 | 1296020 | 2021-05-07 | Lake | Oregon | 41037 | 444 | 7 |
1292774 | 1292774 | 2021-05-06 | Lake | Oregon | 41037 | 443 | 7 |
1289528 | 1289528 | 2021-05-05 | Lake | Oregon | 41037 | 442 | 7 |
1286282 | 1286282 | 2021-05-04 | Lake | Oregon | 41037 | 439 | 7 |
1283036 | 1283036 | 2021-05-03 | Lake | Oregon | 41037 | 437 | 7 |
1279789 | 1279789 | 2021-05-02 | Lake | Oregon | 41037 | 437 | 7 |
1276542 | 1276542 | 2021-05-01 | Lake | Oregon | 41037 | 437 | 7 |
1273295 | 1273295 | 2021-04-30 | Lake | Oregon | 41037 | 435 | 7 |
1270048 | 1270048 | 2021-04-29 | Lake | Oregon | 41037 | 433 | 7 |
1266801 | 1266801 | 2021-04-28 | Lake | Oregon | 41037 | 429 | 7 |
1263554 | 1263554 | 2021-04-27 | Lake | Oregon | 41037 | 425 | 7 |
1260307 | 1260307 | 2021-04-26 | Lake | Oregon | 41037 | 421 | 7 |
1257060 | 1257060 | 2021-04-25 | Lake | Oregon | 41037 | 421 | 7 |
1253813 | 1253813 | 2021-04-24 | Lake | Oregon | 41037 | 420 | 7 |
1250566 | 1250566 | 2021-04-23 | Lake | Oregon | 41037 | 419 | 7 |
1247319 | 1247319 | 2021-04-22 | Lake | Oregon | 41037 | 419 | 7 |
1244072 | 1244072 | 2021-04-21 | Lake | Oregon | 41037 | 417 | 7 |
1240825 | 1240825 | 2021-04-20 | Lake | Oregon | 41037 | 414 | 7 |
1237578 | 1237578 | 2021-04-19 | Lake | Oregon | 41037 | 413 | 7 |
1234331 | 1234331 | 2021-04-18 | Lake | Oregon | 41037 | 413 | 7 |
1231083 | 1231083 | 2021-04-17 | Lake | Oregon | 41037 | 413 | 7 |
1227835 | 1227835 | 2021-04-16 | Lake | Oregon | 41037 | 413 | 7 |
1224587 | 1224587 | 2021-04-15 | Lake | Oregon | 41037 | 412 | 7 |
1221340 | 1221340 | 2021-04-14 | Lake | Oregon | 41037 | 412 | 7 |
1218092 | 1218092 | 2021-04-13 | Lake | Oregon | 41037 | 412 | 7 |
1214844 | 1214844 | 2021-04-12 | Lake | Oregon | 41037 | 409 | 7 |
1211597 | 1211597 | 2021-04-11 | Lake | Oregon | 41037 | 409 | 7 |
1208348 | 1208348 | 2021-04-10 | Lake | Oregon | 41037 | 409 | 7 |
1205100 | 1205100 | 2021-04-09 | Lake | Oregon | 41037 | 409 | 7 |
1201852 | 1201852 | 2021-04-08 | Lake | Oregon | 41037 | 407 | 7 |
1198603 | 1198603 | 2021-04-07 | Lake | Oregon | 41037 | 408 | 7 |
1195354 | 1195354 | 2021-04-06 | Lake | Oregon | 41037 | 406 | 7 |
1192106 | 1192106 | 2021-04-05 | Lake | Oregon | 41037 | 406 | 7 |
1188857 | 1188857 | 2021-04-04 | Lake | Oregon | 41037 | 406 | 7 |
1185610 | 1185610 | 2021-04-03 | Lake | Oregon | 41037 | 406 | 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);