ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "West Baton Rouge" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717075 | 1717075 | 2021-09-14 | West Baton Rouge | Louisiana | 22121 | 4252 | 71 |
1713828 | 1713828 | 2021-09-13 | West Baton Rouge | Louisiana | 22121 | 4243 | 71 |
1710582 | 1710582 | 2021-09-12 | West Baton Rouge | Louisiana | 22121 | 4237 | 71 |
1707335 | 1707335 | 2021-09-11 | West Baton Rouge | Louisiana | 22121 | 4237 | 71 |
1704087 | 1704087 | 2021-09-10 | West Baton Rouge | Louisiana | 22121 | 4237 | 71 |
1700837 | 1700837 | 2021-09-09 | West Baton Rouge | Louisiana | 22121 | 4233 | 71 |
1697588 | 1697588 | 2021-09-08 | West Baton Rouge | Louisiana | 22121 | 4209 | 71 |
1694340 | 1694340 | 2021-09-07 | West Baton Rouge | Louisiana | 22121 | 4198 | 69 |
1691091 | 1691091 | 2021-09-06 | West Baton Rouge | Louisiana | 22121 | 4187 | 69 |
1687841 | 1687841 | 2021-09-05 | West Baton Rouge | Louisiana | 22121 | 4187 | 69 |
1684591 | 1684591 | 2021-09-04 | West Baton Rouge | Louisiana | 22121 | 4187 | 69 |
1681340 | 1681340 | 2021-09-03 | West Baton Rouge | Louisiana | 22121 | 4187 | 69 |
1678092 | 1678092 | 2021-09-02 | West Baton Rouge | Louisiana | 22121 | 4178 | 69 |
1674845 | 1674845 | 2021-09-01 | West Baton Rouge | Louisiana | 22121 | 4171 | 69 |
1671596 | 1671596 | 2021-08-31 | West Baton Rouge | Louisiana | 22121 | 4130 | 68 |
1668349 | 1668349 | 2021-08-30 | West Baton Rouge | Louisiana | 22121 | 4130 | 68 |
1665102 | 1665102 | 2021-08-29 | West Baton Rouge | Louisiana | 22121 | 4130 | 68 |
1661854 | 1661854 | 2021-08-28 | West Baton Rouge | Louisiana | 22121 | 4130 | 68 |
1658606 | 1658606 | 2021-08-27 | West Baton Rouge | Louisiana | 22121 | 4130 | 68 |
1655358 | 1655358 | 2021-08-26 | West Baton Rouge | Louisiana | 22121 | 4125 | 68 |
1652111 | 1652111 | 2021-08-25 | West Baton Rouge | Louisiana | 22121 | 4115 | 68 |
1648862 | 1648862 | 2021-08-24 | West Baton Rouge | Louisiana | 22121 | 4082 | 67 |
1645614 | 1645614 | 2021-08-23 | West Baton Rouge | Louisiana | 22121 | 4069 | 67 |
1642365 | 1642365 | 2021-08-22 | West Baton Rouge | Louisiana | 22121 | 4008 | 67 |
1639115 | 1639115 | 2021-08-21 | West Baton Rouge | Louisiana | 22121 | 4008 | 67 |
1635865 | 1635865 | 2021-08-20 | West Baton Rouge | Louisiana | 22121 | 4008 | 67 |
1632615 | 1632615 | 2021-08-19 | West Baton Rouge | Louisiana | 22121 | 3986 | 67 |
1629368 | 1629368 | 2021-08-18 | West Baton Rouge | Louisiana | 22121 | 3961 | 67 |
1626121 | 1626121 | 2021-08-17 | West Baton Rouge | Louisiana | 22121 | 3907 | 67 |
1622874 | 1622874 | 2021-08-16 | West Baton Rouge | Louisiana | 22121 | 3894 | 67 |
1619627 | 1619627 | 2021-08-15 | West Baton Rouge | Louisiana | 22121 | 3813 | 66 |
1616379 | 1616379 | 2021-08-14 | West Baton Rouge | Louisiana | 22121 | 3813 | 66 |
1613130 | 1613130 | 2021-08-13 | West Baton Rouge | Louisiana | 22121 | 3813 | 66 |
1609882 | 1609882 | 2021-08-12 | West Baton Rouge | Louisiana | 22121 | 3763 | 66 |
1606633 | 1606633 | 2021-08-11 | West Baton Rouge | Louisiana | 22121 | 3739 | 66 |
1603384 | 1603384 | 2021-08-10 | West Baton Rouge | Louisiana | 22121 | 3702 | 66 |
1600135 | 1600135 | 2021-08-09 | West Baton Rouge | Louisiana | 22121 | 3686 | 66 |
1596887 | 1596887 | 2021-08-08 | West Baton Rouge | Louisiana | 22121 | 3564 | 66 |
1593638 | 1593638 | 2021-08-07 | West Baton Rouge | Louisiana | 22121 | 3564 | 66 |
1590389 | 1590389 | 2021-08-06 | West Baton Rouge | Louisiana | 22121 | 3564 | 66 |
1587140 | 1587140 | 2021-08-05 | West Baton Rouge | Louisiana | 22121 | 3537 | 66 |
1583890 | 1583890 | 2021-08-04 | West Baton Rouge | Louisiana | 22121 | 3502 | 66 |
1580640 | 1580640 | 2021-08-03 | West Baton Rouge | Louisiana | 22121 | 3478 | 65 |
1577391 | 1577391 | 2021-08-02 | West Baton Rouge | Louisiana | 22121 | 3451 | 64 |
1574143 | 1574143 | 2021-08-01 | West Baton Rouge | Louisiana | 22121 | 3407 | 64 |
1570895 | 1570895 | 2021-07-31 | West Baton Rouge | Louisiana | 22121 | 3407 | 64 |
1567647 | 1567647 | 2021-07-30 | West Baton Rouge | Louisiana | 22121 | 3407 | 64 |
1564399 | 1564399 | 2021-07-29 | West Baton Rouge | Louisiana | 22121 | 3376 | 64 |
1561151 | 1561151 | 2021-07-28 | West Baton Rouge | Louisiana | 22121 | 3361 | 63 |
1557904 | 1557904 | 2021-07-27 | West Baton Rouge | Louisiana | 22121 | 3320 | 63 |
1554657 | 1554657 | 2021-07-26 | West Baton Rouge | Louisiana | 22121 | 3222 | 63 |
1551410 | 1551410 | 2021-07-25 | West Baton Rouge | Louisiana | 22121 | 3177 | 63 |
1548163 | 1548163 | 2021-07-24 | West Baton Rouge | Louisiana | 22121 | 3177 | 63 |
1544916 | 1544916 | 2021-07-23 | West Baton Rouge | Louisiana | 22121 | 3177 | 63 |
1541668 | 1541668 | 2021-07-22 | West Baton Rouge | Louisiana | 22121 | 3161 | 63 |
1538421 | 1538421 | 2021-07-21 | West Baton Rouge | Louisiana | 22121 | 3151 | 63 |
1535173 | 1535173 | 2021-07-20 | West Baton Rouge | Louisiana | 22121 | 3108 | 63 |
1531926 | 1531926 | 2021-07-19 | West Baton Rouge | Louisiana | 22121 | 3100 | 63 |
1528679 | 1528679 | 2021-07-18 | West Baton Rouge | Louisiana | 22121 | 3079 | 63 |
1525432 | 1525432 | 2021-07-17 | West Baton Rouge | Louisiana | 22121 | 3079 | 63 |
1522184 | 1522184 | 2021-07-16 | West Baton Rouge | Louisiana | 22121 | 3079 | 63 |
1518936 | 1518936 | 2021-07-15 | West Baton Rouge | Louisiana | 22121 | 3071 | 63 |
1515689 | 1515689 | 2021-07-14 | West Baton Rouge | Louisiana | 22121 | 3061 | 63 |
1512443 | 1512443 | 2021-07-13 | West Baton Rouge | Louisiana | 22121 | 3050 | 63 |
1509196 | 1509196 | 2021-07-12 | West Baton Rouge | Louisiana | 22121 | 3050 | 63 |
1505950 | 1505950 | 2021-07-11 | West Baton Rouge | Louisiana | 22121 | 3040 | 63 |
1502704 | 1502704 | 2021-07-10 | West Baton Rouge | Louisiana | 22121 | 3040 | 63 |
1499458 | 1499458 | 2021-07-09 | West Baton Rouge | Louisiana | 22121 | 3040 | 63 |
1496211 | 1496211 | 2021-07-08 | West Baton Rouge | Louisiana | 22121 | 3030 | 63 |
1492965 | 1492965 | 2021-07-07 | West Baton Rouge | Louisiana | 22121 | 3027 | 63 |
1489718 | 1489718 | 2021-07-06 | West Baton Rouge | Louisiana | 22121 | 3017 | 63 |
1486471 | 1486471 | 2021-07-05 | West Baton Rouge | Louisiana | 22121 | 3007 | 63 |
1483225 | 1483225 | 2021-07-04 | West Baton Rouge | Louisiana | 22121 | 3007 | 63 |
1479978 | 1479978 | 2021-07-03 | West Baton Rouge | Louisiana | 22121 | 3007 | 63 |
1476732 | 1476732 | 2021-07-02 | West Baton Rouge | Louisiana | 22121 | 3007 | 63 |
1473486 | 1473486 | 2021-07-01 | West Baton Rouge | Louisiana | 22121 | 3009 | 63 |
1470240 | 1470240 | 2021-06-30 | West Baton Rouge | Louisiana | 22121 | 3005 | 63 |
1466995 | 1466995 | 2021-06-29 | West Baton Rouge | Louisiana | 22121 | 2995 | 62 |
1463750 | 1463750 | 2021-06-28 | West Baton Rouge | Louisiana | 22121 | 2994 | 62 |
1460505 | 1460505 | 2021-06-27 | West Baton Rouge | Louisiana | 22121 | 2986 | 62 |
1457260 | 1457260 | 2021-06-26 | West Baton Rouge | Louisiana | 22121 | 2986 | 62 |
1454015 | 1454015 | 2021-06-25 | West Baton Rouge | Louisiana | 22121 | 2986 | 62 |
1450769 | 1450769 | 2021-06-24 | West Baton Rouge | Louisiana | 22121 | 2983 | 62 |
1447524 | 1447524 | 2021-06-23 | West Baton Rouge | Louisiana | 22121 | 2981 | 62 |
1444279 | 1444279 | 2021-06-22 | West Baton Rouge | Louisiana | 22121 | 2979 | 62 |
1441034 | 1441034 | 2021-06-21 | West Baton Rouge | Louisiana | 22121 | 2976 | 62 |
1437787 | 1437787 | 2021-06-20 | West Baton Rouge | Louisiana | 22121 | 2971 | 62 |
1434540 | 1434540 | 2021-06-19 | West Baton Rouge | Louisiana | 22121 | 2971 | 62 |
1431294 | 1431294 | 2021-06-18 | West Baton Rouge | Louisiana | 22121 | 2971 | 62 |
1428049 | 1428049 | 2021-06-17 | West Baton Rouge | Louisiana | 22121 | 2969 | 62 |
1424804 | 1424804 | 2021-06-16 | West Baton Rouge | Louisiana | 22121 | 2969 | 62 |
1421556 | 1421556 | 2021-06-15 | West Baton Rouge | Louisiana | 22121 | 2966 | 62 |
1418311 | 1418311 | 2021-06-14 | West Baton Rouge | Louisiana | 22121 | 2961 | 62 |
1415065 | 1415065 | 2021-06-13 | West Baton Rouge | Louisiana | 22121 | 2961 | 62 |
1411820 | 1411820 | 2021-06-12 | West Baton Rouge | Louisiana | 22121 | 2961 | 62 |
1408575 | 1408575 | 2021-06-11 | West Baton Rouge | Louisiana | 22121 | 2961 | 62 |
1405329 | 1405329 | 2021-06-10 | West Baton Rouge | Louisiana | 22121 | 2959 | 62 |
1402084 | 1402084 | 2021-06-09 | West Baton Rouge | Louisiana | 22121 | 2952 | 62 |
1398839 | 1398839 | 2021-06-08 | West Baton Rouge | Louisiana | 22121 | 2949 | 62 |
1395592 | 1395592 | 2021-06-07 | West Baton Rouge | Louisiana | 22121 | 2942 | 62 |
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);