ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Washington" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717073 | 1717073 | 2021-09-14 | Washington | Louisiana | 22117 | 7593 | 190 |
1713826 | 1713826 | 2021-09-13 | Washington | Louisiana | 22117 | 7576 | 186 |
1710580 | 1710580 | 2021-09-12 | Washington | Louisiana | 22117 | 7499 | 185 |
1707333 | 1707333 | 2021-09-11 | Washington | Louisiana | 22117 | 7499 | 185 |
1704085 | 1704085 | 2021-09-10 | Washington | Louisiana | 22117 | 7499 | 185 |
1700835 | 1700835 | 2021-09-09 | Washington | Louisiana | 22117 | 7457 | 183 |
1697586 | 1697586 | 2021-09-08 | Washington | Louisiana | 22117 | 7398 | 183 |
1694338 | 1694338 | 2021-09-07 | Washington | Louisiana | 22117 | 7391 | 183 |
1691089 | 1691089 | 2021-09-06 | Washington | Louisiana | 22117 | 7287 | 179 |
1687839 | 1687839 | 2021-09-05 | Washington | Louisiana | 22117 | 7287 | 179 |
1684589 | 1684589 | 2021-09-04 | Washington | Louisiana | 22117 | 7287 | 179 |
1681338 | 1681338 | 2021-09-03 | Washington | Louisiana | 22117 | 7287 | 179 |
1678090 | 1678090 | 2021-09-02 | Washington | Louisiana | 22117 | 7262 | 179 |
1674843 | 1674843 | 2021-09-01 | Washington | Louisiana | 22117 | 7249 | 178 |
1671594 | 1671594 | 2021-08-31 | Washington | Louisiana | 22117 | 7069 | 173 |
1668347 | 1668347 | 2021-08-30 | Washington | Louisiana | 22117 | 7069 | 173 |
1665100 | 1665100 | 2021-08-29 | Washington | Louisiana | 22117 | 7069 | 173 |
1661852 | 1661852 | 2021-08-28 | Washington | Louisiana | 22117 | 7069 | 173 |
1658604 | 1658604 | 2021-08-27 | Washington | Louisiana | 22117 | 7069 | 173 |
1655356 | 1655356 | 2021-08-26 | Washington | Louisiana | 22117 | 7011 | 173 |
1652109 | 1652109 | 2021-08-25 | Washington | Louisiana | 22117 | 6877 | 170 |
1648860 | 1648860 | 2021-08-24 | Washington | Louisiana | 22117 | 6796 | 161 |
1645612 | 1645612 | 2021-08-23 | Washington | Louisiana | 22117 | 6780 | 161 |
1642363 | 1642363 | 2021-08-22 | Washington | Louisiana | 22117 | 6581 | 161 |
1639113 | 1639113 | 2021-08-21 | Washington | Louisiana | 22117 | 6581 | 161 |
1635863 | 1635863 | 2021-08-20 | Washington | Louisiana | 22117 | 6581 | 161 |
1632613 | 1632613 | 2021-08-19 | Washington | Louisiana | 22117 | 6490 | 159 |
1629366 | 1629366 | 2021-08-18 | Washington | Louisiana | 22117 | 6377 | 159 |
1626119 | 1626119 | 2021-08-17 | Washington | Louisiana | 22117 | 6296 | 158 |
1622872 | 1622872 | 2021-08-16 | Washington | Louisiana | 22117 | 6250 | 156 |
1619625 | 1619625 | 2021-08-15 | Washington | Louisiana | 22117 | 6081 | 148 |
1616377 | 1616377 | 2021-08-14 | Washington | Louisiana | 22117 | 6081 | 148 |
1613128 | 1613128 | 2021-08-13 | Washington | Louisiana | 22117 | 6081 | 148 |
1609880 | 1609880 | 2021-08-12 | Washington | Louisiana | 22117 | 5998 | 147 |
1606631 | 1606631 | 2021-08-11 | Washington | Louisiana | 22117 | 5890 | 145 |
1603382 | 1603382 | 2021-08-10 | Washington | Louisiana | 22117 | 5847 | 143 |
1600133 | 1600133 | 2021-08-09 | Washington | Louisiana | 22117 | 5777 | 142 |
1596885 | 1596885 | 2021-08-08 | Washington | Louisiana | 22117 | 5602 | 141 |
1593636 | 1593636 | 2021-08-07 | Washington | Louisiana | 22117 | 5602 | 141 |
1590387 | 1590387 | 2021-08-06 | Washington | Louisiana | 22117 | 5602 | 141 |
1587138 | 1587138 | 2021-08-05 | Washington | Louisiana | 22117 | 5491 | 141 |
1583888 | 1583888 | 2021-08-04 | Washington | Louisiana | 22117 | 5441 | 141 |
1580638 | 1580638 | 2021-08-03 | Washington | Louisiana | 22117 | 5387 | 140 |
1577389 | 1577389 | 2021-08-02 | Washington | Louisiana | 22117 | 5349 | 140 |
1574141 | 1574141 | 2021-08-01 | Washington | Louisiana | 22117 | 5186 | 140 |
1570893 | 1570893 | 2021-07-31 | Washington | Louisiana | 22117 | 5186 | 140 |
1567645 | 1567645 | 2021-07-30 | Washington | Louisiana | 22117 | 5186 | 140 |
1564397 | 1564397 | 2021-07-29 | Washington | Louisiana | 22117 | 5142 | 140 |
1561149 | 1561149 | 2021-07-28 | Washington | Louisiana | 22117 | 5086 | 139 |
1557902 | 1557902 | 2021-07-27 | Washington | Louisiana | 22117 | 5046 | 139 |
1554655 | 1554655 | 2021-07-26 | Washington | Louisiana | 22117 | 5000 | 139 |
1551408 | 1551408 | 2021-07-25 | Washington | Louisiana | 22117 | 4877 | 139 |
1548161 | 1548161 | 2021-07-24 | Washington | Louisiana | 22117 | 4877 | 139 |
1544914 | 1544914 | 2021-07-23 | Washington | Louisiana | 22117 | 4877 | 139 |
1541666 | 1541666 | 2021-07-22 | Washington | Louisiana | 22117 | 4835 | 139 |
1538419 | 1538419 | 2021-07-21 | Washington | Louisiana | 22117 | 4796 | 139 |
1535171 | 1535171 | 2021-07-20 | Washington | Louisiana | 22117 | 4744 | 139 |
1531924 | 1531924 | 2021-07-19 | Washington | Louisiana | 22117 | 4728 | 138 |
1528677 | 1528677 | 2021-07-18 | Washington | Louisiana | 22117 | 4685 | 138 |
1525430 | 1525430 | 2021-07-17 | Washington | Louisiana | 22117 | 4685 | 138 |
1522182 | 1522182 | 2021-07-16 | Washington | Louisiana | 22117 | 4685 | 138 |
1518934 | 1518934 | 2021-07-15 | Washington | Louisiana | 22117 | 4677 | 138 |
1515687 | 1515687 | 2021-07-14 | Washington | Louisiana | 22117 | 4648 | 138 |
1512441 | 1512441 | 2021-07-13 | Washington | Louisiana | 22117 | 4622 | 138 |
1509194 | 1509194 | 2021-07-12 | Washington | Louisiana | 22117 | 4616 | 137 |
1505948 | 1505948 | 2021-07-11 | Washington | Louisiana | 22117 | 4574 | 136 |
1502702 | 1502702 | 2021-07-10 | Washington | Louisiana | 22117 | 4574 | 136 |
1499456 | 1499456 | 2021-07-09 | Washington | Louisiana | 22117 | 4574 | 136 |
1496209 | 1496209 | 2021-07-08 | Washington | Louisiana | 22117 | 4548 | 136 |
1492963 | 1492963 | 2021-07-07 | Washington | Louisiana | 22117 | 4540 | 134 |
1489716 | 1489716 | 2021-07-06 | Washington | Louisiana | 22117 | 4528 | 134 |
1486469 | 1486469 | 2021-07-05 | Washington | Louisiana | 22117 | 4504 | 134 |
1483223 | 1483223 | 2021-07-04 | Washington | Louisiana | 22117 | 4504 | 134 |
1479976 | 1479976 | 2021-07-03 | Washington | Louisiana | 22117 | 4504 | 134 |
1476730 | 1476730 | 2021-07-02 | Washington | Louisiana | 22117 | 4504 | 134 |
1473484 | 1473484 | 2021-07-01 | Washington | Louisiana | 22117 | 4495 | 134 |
1470238 | 1470238 | 2021-06-30 | Washington | Louisiana | 22117 | 4491 | 134 |
1466993 | 1466993 | 2021-06-29 | Washington | Louisiana | 22117 | 4484 | 134 |
1463748 | 1463748 | 2021-06-28 | Washington | Louisiana | 22117 | 4476 | 134 |
1460503 | 1460503 | 2021-06-27 | Washington | Louisiana | 22117 | 4466 | 134 |
1457258 | 1457258 | 2021-06-26 | Washington | Louisiana | 22117 | 4466 | 134 |
1454013 | 1454013 | 2021-06-25 | Washington | Louisiana | 22117 | 4466 | 134 |
1450767 | 1450767 | 2021-06-24 | Washington | Louisiana | 22117 | 4465 | 134 |
1447522 | 1447522 | 2021-06-23 | Washington | Louisiana | 22117 | 4460 | 134 |
1444277 | 1444277 | 2021-06-22 | Washington | Louisiana | 22117 | 4456 | 134 |
1441032 | 1441032 | 2021-06-21 | Washington | Louisiana | 22117 | 4449 | 134 |
1437785 | 1437785 | 2021-06-20 | Washington | Louisiana | 22117 | 4444 | 134 |
1434538 | 1434538 | 2021-06-19 | Washington | Louisiana | 22117 | 4444 | 134 |
1431292 | 1431292 | 2021-06-18 | Washington | Louisiana | 22117 | 4444 | 134 |
1428047 | 1428047 | 2021-06-17 | Washington | Louisiana | 22117 | 4444 | 134 |
1424802 | 1424802 | 2021-06-16 | Washington | Louisiana | 22117 | 4441 | 134 |
1421554 | 1421554 | 2021-06-15 | Washington | Louisiana | 22117 | 4441 | 134 |
1418309 | 1418309 | 2021-06-14 | Washington | Louisiana | 22117 | 4441 | 134 |
1415063 | 1415063 | 2021-06-13 | Washington | Louisiana | 22117 | 4434 | 134 |
1411818 | 1411818 | 2021-06-12 | Washington | Louisiana | 22117 | 4434 | 134 |
1408573 | 1408573 | 2021-06-11 | Washington | Louisiana | 22117 | 4434 | 134 |
1405327 | 1405327 | 2021-06-10 | Washington | Louisiana | 22117 | 4434 | 134 |
1402082 | 1402082 | 2021-06-09 | Washington | Louisiana | 22117 | 4431 | 134 |
1398837 | 1398837 | 2021-06-08 | Washington | Louisiana | 22117 | 4429 | 133 |
1395590 | 1395590 | 2021-06-07 | Washington | Louisiana | 22117 | 4430 | 133 |
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);