ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where county = "Kauai" and deaths = 2 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1628741 | 1628741 | 2021-08-18 | Kauai | Hawaii | 15007 | 894 | 2 |
1625494 | 1625494 | 2021-08-17 | Kauai | Hawaii | 15007 | 868 | 2 |
1622247 | 1622247 | 2021-08-16 | Kauai | Hawaii | 15007 | 853 | 2 |
1619000 | 1619000 | 2021-08-15 | Kauai | Hawaii | 15007 | 839 | 2 |
1615752 | 1615752 | 2021-08-14 | Kauai | Hawaii | 15007 | 793 | 2 |
1612503 | 1612503 | 2021-08-13 | Kauai | Hawaii | 15007 | 778 | 2 |
1609255 | 1609255 | 2021-08-12 | Kauai | Hawaii | 15007 | 732 | 2 |
1606006 | 1606006 | 2021-08-11 | Kauai | Hawaii | 15007 | 682 | 2 |
1602757 | 1602757 | 2021-08-10 | Kauai | Hawaii | 15007 | 665 | 2 |
1599508 | 1599508 | 2021-08-09 | Kauai | Hawaii | 15007 | 650 | 2 |
1596259 | 1596259 | 2021-08-08 | Kauai | Hawaii | 15007 | 634 | 2 |
1593010 | 1593010 | 2021-08-07 | Kauai | Hawaii | 15007 | 612 | 2 |
1589761 | 1589761 | 2021-08-06 | Kauai | Hawaii | 15007 | 595 | 2 |
1586512 | 1586512 | 2021-08-05 | Kauai | Hawaii | 15007 | 586 | 2 |
1583262 | 1583262 | 2021-08-04 | Kauai | Hawaii | 15007 | 579 | 2 |
1580012 | 1580012 | 2021-08-03 | Kauai | Hawaii | 15007 | 574 | 2 |
1576764 | 1576764 | 2021-08-02 | Kauai | Hawaii | 15007 | 568 | 2 |
1573516 | 1573516 | 2021-08-01 | Kauai | Hawaii | 15007 | 554 | 2 |
1570268 | 1570268 | 2021-07-31 | Kauai | Hawaii | 15007 | 548 | 2 |
1567020 | 1567020 | 2021-07-30 | Kauai | Hawaii | 15007 | 539 | 2 |
1563772 | 1563772 | 2021-07-29 | Kauai | Hawaii | 15007 | 531 | 2 |
1560524 | 1560524 | 2021-07-28 | Kauai | Hawaii | 15007 | 522 | 2 |
1557277 | 1557277 | 2021-07-27 | Kauai | Hawaii | 15007 | 519 | 2 |
1554030 | 1554030 | 2021-07-26 | Kauai | Hawaii | 15007 | 515 | 2 |
1550783 | 1550783 | 2021-07-25 | Kauai | Hawaii | 15007 | 514 | 2 |
1547536 | 1547536 | 2021-07-24 | Kauai | Hawaii | 15007 | 508 | 2 |
1544289 | 1544289 | 2021-07-23 | Kauai | Hawaii | 15007 | 500 | 2 |
1541041 | 1541041 | 2021-07-22 | Kauai | Hawaii | 15007 | 488 | 2 |
1537794 | 1537794 | 2021-07-21 | Kauai | Hawaii | 15007 | 480 | 2 |
1534546 | 1534546 | 2021-07-20 | Kauai | Hawaii | 15007 | 476 | 2 |
1531299 | 1531299 | 2021-07-19 | Kauai | Hawaii | 15007 | 475 | 2 |
1528052 | 1528052 | 2021-07-18 | Kauai | Hawaii | 15007 | 471 | 2 |
1524805 | 1524805 | 2021-07-17 | Kauai | Hawaii | 15007 | 465 | 2 |
1521557 | 1521557 | 2021-07-16 | Kauai | Hawaii | 15007 | 453 | 2 |
1518309 | 1518309 | 2021-07-15 | Kauai | Hawaii | 15007 | 444 | 2 |
1515062 | 1515062 | 2021-07-14 | Kauai | Hawaii | 15007 | 430 | 2 |
1511816 | 1511816 | 2021-07-13 | Kauai | Hawaii | 15007 | 428 | 2 |
1508569 | 1508569 | 2021-07-12 | Kauai | Hawaii | 15007 | 417 | 2 |
1505323 | 1505323 | 2021-07-11 | Kauai | Hawaii | 15007 | 417 | 2 |
1502077 | 1502077 | 2021-07-10 | Kauai | Hawaii | 15007 | 409 | 2 |
1498831 | 1498831 | 2021-07-09 | Kauai | Hawaii | 15007 | 407 | 2 |
1495584 | 1495584 | 2021-07-08 | Kauai | Hawaii | 15007 | 400 | 2 |
1492338 | 1492338 | 2021-07-07 | Kauai | Hawaii | 15007 | 394 | 2 |
1489091 | 1489091 | 2021-07-06 | Kauai | Hawaii | 15007 | 394 | 2 |
1485844 | 1485844 | 2021-07-05 | Kauai | Hawaii | 15007 | 393 | 2 |
1482598 | 1482598 | 2021-07-04 | Kauai | Hawaii | 15007 | 392 | 2 |
1479351 | 1479351 | 2021-07-03 | Kauai | Hawaii | 15007 | 388 | 2 |
1476105 | 1476105 | 2021-07-02 | Kauai | Hawaii | 15007 | 377 | 2 |
1472859 | 1472859 | 2021-07-01 | Kauai | Hawaii | 15007 | 368 | 2 |
1469613 | 1469613 | 2021-06-30 | Kauai | Hawaii | 15007 | 361 | 2 |
1466368 | 1466368 | 2021-06-29 | Kauai | Hawaii | 15007 | 361 | 2 |
1463123 | 1463123 | 2021-06-28 | Kauai | Hawaii | 15007 | 361 | 2 |
1459878 | 1459878 | 2021-06-27 | Kauai | Hawaii | 15007 | 361 | 2 |
1456633 | 1456633 | 2021-06-26 | Kauai | Hawaii | 15007 | 358 | 2 |
1453388 | 1453388 | 2021-06-25 | Kauai | Hawaii | 15007 | 358 | 2 |
1450142 | 1450142 | 2021-06-24 | Kauai | Hawaii | 15007 | 356 | 2 |
1446897 | 1446897 | 2021-06-23 | Kauai | Hawaii | 15007 | 349 | 2 |
1443652 | 1443652 | 2021-06-22 | Kauai | Hawaii | 15007 | 348 | 2 |
1440407 | 1440407 | 2021-06-21 | Kauai | Hawaii | 15007 | 347 | 2 |
1437160 | 1437160 | 2021-06-20 | Kauai | Hawaii | 15007 | 348 | 2 |
1433913 | 1433913 | 2021-06-19 | Kauai | Hawaii | 15007 | 346 | 2 |
1430667 | 1430667 | 2021-06-18 | Kauai | Hawaii | 15007 | 344 | 2 |
1427422 | 1427422 | 2021-06-17 | Kauai | Hawaii | 15007 | 343 | 2 |
1424177 | 1424177 | 2021-06-16 | Kauai | Hawaii | 15007 | 339 | 2 |
1420929 | 1420929 | 2021-06-15 | Kauai | Hawaii | 15007 | 338 | 2 |
1417684 | 1417684 | 2021-06-14 | Kauai | Hawaii | 15007 | 335 | 2 |
1414438 | 1414438 | 2021-06-13 | Kauai | Hawaii | 15007 | 328 | 2 |
1411193 | 1411193 | 2021-06-12 | Kauai | Hawaii | 15007 | 328 | 2 |
1407948 | 1407948 | 2021-06-11 | Kauai | Hawaii | 15007 | 327 | 2 |
1404702 | 1404702 | 2021-06-10 | Kauai | Hawaii | 15007 | 327 | 2 |
1401457 | 1401457 | 2021-06-09 | Kauai | Hawaii | 15007 | 325 | 2 |
1398212 | 1398212 | 2021-06-08 | Kauai | Hawaii | 15007 | 325 | 2 |
1394965 | 1394965 | 2021-06-07 | Kauai | Hawaii | 15007 | 324 | 2 |
1391720 | 1391720 | 2021-06-06 | Kauai | Hawaii | 15007 | 325 | 2 |
1388475 | 1388475 | 2021-06-05 | Kauai | Hawaii | 15007 | 325 | 2 |
1385230 | 1385230 | 2021-06-04 | Kauai | Hawaii | 15007 | 324 | 2 |
1381984 | 1381984 | 2021-06-03 | Kauai | Hawaii | 15007 | 324 | 2 |
1378739 | 1378739 | 2021-06-02 | Kauai | Hawaii | 15007 | 323 | 2 |
1375493 | 1375493 | 2021-06-01 | Kauai | Hawaii | 15007 | 324 | 2 |
1372248 | 1372248 | 2021-05-31 | Kauai | Hawaii | 15007 | 321 | 2 |
1369003 | 1369003 | 2021-05-30 | Kauai | Hawaii | 15007 | 320 | 2 |
1365757 | 1365757 | 2021-05-29 | Kauai | Hawaii | 15007 | 318 | 2 |
1362511 | 1362511 | 2021-05-28 | Kauai | Hawaii | 15007 | 318 | 2 |
1359264 | 1359264 | 2021-05-27 | Kauai | Hawaii | 15007 | 318 | 2 |
1356018 | 1356018 | 2021-05-26 | Kauai | Hawaii | 15007 | 318 | 2 |
1352772 | 1352772 | 2021-05-25 | Kauai | Hawaii | 15007 | 318 | 2 |
1349526 | 1349526 | 2021-05-24 | Kauai | Hawaii | 15007 | 317 | 2 |
1346279 | 1346279 | 2021-05-23 | Kauai | Hawaii | 15007 | 317 | 2 |
1343031 | 1343031 | 2021-05-22 | Kauai | Hawaii | 15007 | 316 | 2 |
1339783 | 1339783 | 2021-05-21 | Kauai | Hawaii | 15007 | 316 | 2 |
1336536 | 1336536 | 2021-05-20 | Kauai | Hawaii | 15007 | 313 | 2 |
1333289 | 1333289 | 2021-05-19 | Kauai | Hawaii | 15007 | 313 | 2 |
1330042 | 1330042 | 2021-05-18 | Kauai | Hawaii | 15007 | 312 | 2 |
1326795 | 1326795 | 2021-05-17 | Kauai | Hawaii | 15007 | 309 | 2 |
1323549 | 1323549 | 2021-05-16 | Kauai | Hawaii | 15007 | 309 | 2 |
1320303 | 1320303 | 2021-05-15 | Kauai | Hawaii | 15007 | 309 | 2 |
1317056 | 1317056 | 2021-05-14 | Kauai | Hawaii | 15007 | 308 | 2 |
1313809 | 1313809 | 2021-05-13 | Kauai | Hawaii | 15007 | 306 | 2 |
1310562 | 1310562 | 2021-05-12 | Kauai | Hawaii | 15007 | 306 | 2 |
1307316 | 1307316 | 2021-05-11 | Kauai | Hawaii | 15007 | 306 | 2 |
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);