ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Webster" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717074 | 1717074 | 2021-09-14 | Webster | Louisiana | 22119 | 6063 | 136 |
1713827 | 1713827 | 2021-09-13 | Webster | Louisiana | 22119 | 6057 | 135 |
1710581 | 1710581 | 2021-09-12 | Webster | Louisiana | 22119 | 6001 | 133 |
1707334 | 1707334 | 2021-09-11 | Webster | Louisiana | 22119 | 6001 | 133 |
1704086 | 1704086 | 2021-09-10 | Webster | Louisiana | 22119 | 6001 | 133 |
1700836 | 1700836 | 2021-09-09 | Webster | Louisiana | 22119 | 5984 | 132 |
1697587 | 1697587 | 2021-09-08 | Webster | Louisiana | 22119 | 5965 | 132 |
1694339 | 1694339 | 2021-09-07 | Webster | Louisiana | 22119 | 5922 | 131 |
1691090 | 1691090 | 2021-09-06 | Webster | Louisiana | 22119 | 5867 | 131 |
1687840 | 1687840 | 2021-09-05 | Webster | Louisiana | 22119 | 5867 | 131 |
1684590 | 1684590 | 2021-09-04 | Webster | Louisiana | 22119 | 5867 | 131 |
1681339 | 1681339 | 2021-09-03 | Webster | Louisiana | 22119 | 5867 | 131 |
1678091 | 1678091 | 2021-09-02 | Webster | Louisiana | 22119 | 5833 | 130 |
1674844 | 1674844 | 2021-09-01 | Webster | Louisiana | 22119 | 5814 | 129 |
1671595 | 1671595 | 2021-08-31 | Webster | Louisiana | 22119 | 5648 | 123 |
1668348 | 1668348 | 2021-08-30 | Webster | Louisiana | 22119 | 5648 | 123 |
1665101 | 1665101 | 2021-08-29 | Webster | Louisiana | 22119 | 5648 | 123 |
1661853 | 1661853 | 2021-08-28 | Webster | Louisiana | 22119 | 5648 | 123 |
1658605 | 1658605 | 2021-08-27 | Webster | Louisiana | 22119 | 5648 | 123 |
1655357 | 1655357 | 2021-08-26 | Webster | Louisiana | 22119 | 5632 | 123 |
1652110 | 1652110 | 2021-08-25 | Webster | Louisiana | 22119 | 5577 | 123 |
1648861 | 1648861 | 2021-08-24 | Webster | Louisiana | 22119 | 5535 | 123 |
1645613 | 1645613 | 2021-08-23 | Webster | Louisiana | 22119 | 5474 | 120 |
1642364 | 1642364 | 2021-08-22 | Webster | Louisiana | 22119 | 5384 | 119 |
1639114 | 1639114 | 2021-08-21 | Webster | Louisiana | 22119 | 5384 | 119 |
1635864 | 1635864 | 2021-08-20 | Webster | Louisiana | 22119 | 5384 | 119 |
1632614 | 1632614 | 2021-08-19 | Webster | Louisiana | 22119 | 5347 | 119 |
1629367 | 1629367 | 2021-08-18 | Webster | Louisiana | 22119 | 5286 | 120 |
1626120 | 1626120 | 2021-08-17 | Webster | Louisiana | 22119 | 5209 | 119 |
1622873 | 1622873 | 2021-08-16 | Webster | Louisiana | 22119 | 5186 | 119 |
1619626 | 1619626 | 2021-08-15 | Webster | Louisiana | 22119 | 5086 | 119 |
1616378 | 1616378 | 2021-08-14 | Webster | Louisiana | 22119 | 5086 | 119 |
1613129 | 1613129 | 2021-08-13 | Webster | Louisiana | 22119 | 5086 | 119 |
1609881 | 1609881 | 2021-08-12 | Webster | Louisiana | 22119 | 5058 | 119 |
1606632 | 1606632 | 2021-08-11 | Webster | Louisiana | 22119 | 4995 | 119 |
1603383 | 1603383 | 2021-08-10 | Webster | Louisiana | 22119 | 4951 | 119 |
1600134 | 1600134 | 2021-08-09 | Webster | Louisiana | 22119 | 4895 | 119 |
1596886 | 1596886 | 2021-08-08 | Webster | Louisiana | 22119 | 4805 | 119 |
1593637 | 1593637 | 2021-08-07 | Webster | Louisiana | 22119 | 4805 | 119 |
1590388 | 1590388 | 2021-08-06 | Webster | Louisiana | 22119 | 4805 | 119 |
1587139 | 1587139 | 2021-08-05 | Webster | Louisiana | 22119 | 4743 | 119 |
1583889 | 1583889 | 2021-08-04 | Webster | Louisiana | 22119 | 4725 | 116 |
1580639 | 1580639 | 2021-08-03 | Webster | Louisiana | 22119 | 4702 | 116 |
1577390 | 1577390 | 2021-08-02 | Webster | Louisiana | 22119 | 4659 | 116 |
1574142 | 1574142 | 2021-08-01 | Webster | Louisiana | 22119 | 4607 | 116 |
1570894 | 1570894 | 2021-07-31 | Webster | Louisiana | 22119 | 4607 | 116 |
1567646 | 1567646 | 2021-07-30 | Webster | Louisiana | 22119 | 4607 | 116 |
1564398 | 1564398 | 2021-07-29 | Webster | Louisiana | 22119 | 4568 | 116 |
1561150 | 1561150 | 2021-07-28 | Webster | Louisiana | 22119 | 4549 | 116 |
1557903 | 1557903 | 2021-07-27 | Webster | Louisiana | 22119 | 4505 | 116 |
1554656 | 1554656 | 2021-07-26 | Webster | Louisiana | 22119 | 4483 | 116 |
1551409 | 1551409 | 2021-07-25 | Webster | Louisiana | 22119 | 4452 | 116 |
1548162 | 1548162 | 2021-07-24 | Webster | Louisiana | 22119 | 4452 | 116 |
1544915 | 1544915 | 2021-07-23 | Webster | Louisiana | 22119 | 4452 | 116 |
1541667 | 1541667 | 2021-07-22 | Webster | Louisiana | 22119 | 4441 | 116 |
1538420 | 1538420 | 2021-07-21 | Webster | Louisiana | 22119 | 4431 | 116 |
1535172 | 1535172 | 2021-07-20 | Webster | Louisiana | 22119 | 4411 | 116 |
1531925 | 1531925 | 2021-07-19 | Webster | Louisiana | 22119 | 4399 | 116 |
1528678 | 1528678 | 2021-07-18 | Webster | Louisiana | 22119 | 4371 | 115 |
1525431 | 1525431 | 2021-07-17 | Webster | Louisiana | 22119 | 4371 | 115 |
1522183 | 1522183 | 2021-07-16 | Webster | Louisiana | 22119 | 4371 | 115 |
1518935 | 1518935 | 2021-07-15 | Webster | Louisiana | 22119 | 4359 | 115 |
1515688 | 1515688 | 2021-07-14 | Webster | Louisiana | 22119 | 4343 | 115 |
1512442 | 1512442 | 2021-07-13 | Webster | Louisiana | 22119 | 4338 | 115 |
1509195 | 1509195 | 2021-07-12 | Webster | Louisiana | 22119 | 4337 | 115 |
1505949 | 1505949 | 2021-07-11 | Webster | Louisiana | 22119 | 4313 | 115 |
1502703 | 1502703 | 2021-07-10 | Webster | Louisiana | 22119 | 4313 | 115 |
1499457 | 1499457 | 2021-07-09 | Webster | Louisiana | 22119 | 4313 | 115 |
1496210 | 1496210 | 2021-07-08 | Webster | Louisiana | 22119 | 4305 | 115 |
1492964 | 1492964 | 2021-07-07 | Webster | Louisiana | 22119 | 4300 | 115 |
1489717 | 1489717 | 2021-07-06 | Webster | Louisiana | 22119 | 4284 | 115 |
1486470 | 1486470 | 2021-07-05 | Webster | Louisiana | 22119 | 4273 | 114 |
1483224 | 1483224 | 2021-07-04 | Webster | Louisiana | 22119 | 4273 | 114 |
1479977 | 1479977 | 2021-07-03 | Webster | Louisiana | 22119 | 4273 | 114 |
1476731 | 1476731 | 2021-07-02 | Webster | Louisiana | 22119 | 4273 | 114 |
1473485 | 1473485 | 2021-07-01 | Webster | Louisiana | 22119 | 4275 | 114 |
1470239 | 1470239 | 2021-06-30 | Webster | Louisiana | 22119 | 4259 | 114 |
1466994 | 1466994 | 2021-06-29 | Webster | Louisiana | 22119 | 4262 | 114 |
1463749 | 1463749 | 2021-06-28 | Webster | Louisiana | 22119 | 4260 | 114 |
1460504 | 1460504 | 2021-06-27 | Webster | Louisiana | 22119 | 4256 | 114 |
1457259 | 1457259 | 2021-06-26 | Webster | Louisiana | 22119 | 4256 | 114 |
1454014 | 1454014 | 2021-06-25 | Webster | Louisiana | 22119 | 4256 | 114 |
1450768 | 1450768 | 2021-06-24 | Webster | Louisiana | 22119 | 4252 | 114 |
1447523 | 1447523 | 2021-06-23 | Webster | Louisiana | 22119 | 4252 | 113 |
1444278 | 1444278 | 2021-06-22 | Webster | Louisiana | 22119 | 4250 | 113 |
1441033 | 1441033 | 2021-06-21 | Webster | Louisiana | 22119 | 4250 | 113 |
1437786 | 1437786 | 2021-06-20 | Webster | Louisiana | 22119 | 4241 | 113 |
1434539 | 1434539 | 2021-06-19 | Webster | Louisiana | 22119 | 4241 | 113 |
1431293 | 1431293 | 2021-06-18 | Webster | Louisiana | 22119 | 4241 | 113 |
1428048 | 1428048 | 2021-06-17 | Webster | Louisiana | 22119 | 4236 | 113 |
1424803 | 1424803 | 2021-06-16 | Webster | Louisiana | 22119 | 4229 | 113 |
1421555 | 1421555 | 2021-06-15 | Webster | Louisiana | 22119 | 4227 | 113 |
1418310 | 1418310 | 2021-06-14 | Webster | Louisiana | 22119 | 4220 | 113 |
1415064 | 1415064 | 2021-06-13 | Webster | Louisiana | 22119 | 4215 | 113 |
1411819 | 1411819 | 2021-06-12 | Webster | Louisiana | 22119 | 4215 | 113 |
1408574 | 1408574 | 2021-06-11 | Webster | Louisiana | 22119 | 4215 | 113 |
1405328 | 1405328 | 2021-06-10 | Webster | Louisiana | 22119 | 4210 | 113 |
1402083 | 1402083 | 2021-06-09 | Webster | Louisiana | 22119 | 4204 | 113 |
1398838 | 1398838 | 2021-06-08 | Webster | Louisiana | 22119 | 4200 | 113 |
1395591 | 1395591 | 2021-06-07 | Webster | Louisiana | 22119 | 4194 | 113 |
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);