ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Grant" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175338 | 2175338 | 2022-02-02 | Grant | Louisiana | 22043 | 5484 | 84 |
2172085 | 2172085 | 2022-02-01 | Grant | Louisiana | 22043 | 5448 | 84 |
2168832 | 2168832 | 2022-01-31 | Grant | Louisiana | 22043 | 5433 | 84 |
2165577 | 2165577 | 2022-01-30 | Grant | Louisiana | 22043 | 5360 | 82 |
2162322 | 2162322 | 2022-01-29 | Grant | Louisiana | 22043 | 5360 | 82 |
2159067 | 2159067 | 2022-01-28 | Grant | Louisiana | 22043 | 5360 | 82 |
2155813 | 2155813 | 2022-01-27 | Grant | Louisiana | 22043 | 5291 | 82 |
2152560 | 2152560 | 2022-01-26 | Grant | Louisiana | 22043 | 5242 | 82 |
2149308 | 2149308 | 2022-01-25 | Grant | Louisiana | 22043 | 4934 | 82 |
2146056 | 2146056 | 2022-01-24 | Grant | Louisiana | 22043 | 4888 | 82 |
2142801 | 2142801 | 2022-01-23 | Grant | Louisiana | 22043 | 4782 | 81 |
2139546 | 2139546 | 2022-01-22 | Grant | Louisiana | 22043 | 4782 | 81 |
2136290 | 2136290 | 2022-01-21 | Grant | Louisiana | 22043 | 4782 | 81 |
2133038 | 2133038 | 2022-01-20 | Grant | Louisiana | 22043 | 4718 | 81 |
2129785 | 2129785 | 2022-01-19 | Grant | Louisiana | 22043 | 4656 | 81 |
2126531 | 2126531 | 2022-01-18 | Grant | Louisiana | 22043 | 4583 | 81 |
2123279 | 2123279 | 2022-01-17 | Grant | Louisiana | 22043 | 4482 | 80 |
2120027 | 2120027 | 2022-01-16 | Grant | Louisiana | 22043 | 4482 | 80 |
2116775 | 2116775 | 2022-01-15 | Grant | Louisiana | 22043 | 4482 | 80 |
2113524 | 2113524 | 2022-01-14 | Grant | Louisiana | 22043 | 4482 | 80 |
2110272 | 2110272 | 2022-01-13 | Grant | Louisiana | 22043 | 4307 | 80 |
2107021 | 2107021 | 2022-01-12 | Grant | Louisiana | 22043 | 4307 | 80 |
2103770 | 2103770 | 2022-01-11 | Grant | Louisiana | 22043 | 4307 | 80 |
2100519 | 2100519 | 2022-01-10 | Grant | Louisiana | 22043 | 4249 | 80 |
2097268 | 2097268 | 2022-01-09 | Grant | Louisiana | 22043 | 4204 | 80 |
2094016 | 2094016 | 2022-01-08 | Grant | Louisiana | 22043 | 4204 | 80 |
2090764 | 2090764 | 2022-01-07 | Grant | Louisiana | 22043 | 4204 | 80 |
2087513 | 2087513 | 2022-01-06 | Grant | Louisiana | 22043 | 4182 | 80 |
2084261 | 2084261 | 2022-01-05 | Grant | Louisiana | 22043 | 4151 | 80 |
2081009 | 2081009 | 2022-01-04 | Grant | Louisiana | 22043 | 4128 | 79 |
2077757 | 2077757 | 2022-01-03 | Grant | Louisiana | 22043 | 4088 | 79 |
2074506 | 2074506 | 2022-01-02 | Grant | Louisiana | 22043 | 4031 | 79 |
2071255 | 2071255 | 2022-01-01 | Grant | Louisiana | 22043 | 4031 | 79 |
2068004 | 2068004 | 2021-12-31 | Grant | Louisiana | 22043 | 4031 | 79 |
2064753 | 2064753 | 2021-12-30 | Grant | Louisiana | 22043 | 4031 | 79 |
2061503 | 2061503 | 2021-12-29 | Grant | Louisiana | 22043 | 4009 | 79 |
2058254 | 2058254 | 2021-12-28 | Grant | Louisiana | 22043 | 3990 | 79 |
2055005 | 2055005 | 2021-12-27 | Grant | Louisiana | 22043 | 3986 | 79 |
2051755 | 2051755 | 2021-12-26 | Grant | Louisiana | 22043 | 3973 | 79 |
2048505 | 2048505 | 2021-12-25 | Grant | Louisiana | 22043 | 3973 | 79 |
2045255 | 2045255 | 2021-12-24 | Grant | Louisiana | 22043 | 3973 | 79 |
2042006 | 2042006 | 2021-12-23 | Grant | Louisiana | 22043 | 3973 | 79 |
2038756 | 2038756 | 2021-12-22 | Grant | Louisiana | 22043 | 3971 | 79 |
2035506 | 2035506 | 2021-12-21 | Grant | Louisiana | 22043 | 3961 | 79 |
2032256 | 2032256 | 2021-12-20 | Grant | Louisiana | 22043 | 3953 | 79 |
2029005 | 2029005 | 2021-12-19 | Grant | Louisiana | 22043 | 3944 | 79 |
2025754 | 2025754 | 2021-12-18 | Grant | Louisiana | 22043 | 3944 | 79 |
2022503 | 2022503 | 2021-12-17 | Grant | Louisiana | 22043 | 3944 | 79 |
2019252 | 2019252 | 2021-12-16 | Grant | Louisiana | 22043 | 3941 | 79 |
2016002 | 2016002 | 2021-12-15 | Grant | Louisiana | 22043 | 3935 | 79 |
2012751 | 2012751 | 2021-12-14 | Grant | Louisiana | 22043 | 3930 | 79 |
2009500 | 2009500 | 2021-12-13 | Grant | Louisiana | 22043 | 3927 | 78 |
2006249 | 2006249 | 2021-12-12 | Grant | Louisiana | 22043 | 3923 | 78 |
2002998 | 2002998 | 2021-12-11 | Grant | Louisiana | 22043 | 3923 | 78 |
1999748 | 1999748 | 2021-12-10 | Grant | Louisiana | 22043 | 3923 | 78 |
1996497 | 1996497 | 2021-12-09 | Grant | Louisiana | 22043 | 3922 | 78 |
1993246 | 1993246 | 2021-12-08 | Grant | Louisiana | 22043 | 3921 | 78 |
1989995 | 1989995 | 2021-12-07 | Grant | Louisiana | 22043 | 3919 | 79 |
1986745 | 1986745 | 2021-12-06 | Grant | Louisiana | 22043 | 3917 | 79 |
1983495 | 1983495 | 2021-12-05 | Grant | Louisiana | 22043 | 3910 | 79 |
1980245 | 1980245 | 2021-12-04 | Grant | Louisiana | 22043 | 3910 | 79 |
1976995 | 1976995 | 2021-12-03 | Grant | Louisiana | 22043 | 3910 | 79 |
1973746 | 1973746 | 2021-12-02 | Grant | Louisiana | 22043 | 3906 | 79 |
1970496 | 1970496 | 2021-12-01 | Grant | Louisiana | 22043 | 3903 | 79 |
1967246 | 1967246 | 2021-11-30 | Grant | Louisiana | 22043 | 3899 | 79 |
1963994 | 1963994 | 2021-11-29 | Grant | Louisiana | 22043 | 3897 | 79 |
1960743 | 1960743 | 2021-11-28 | Grant | Louisiana | 22043 | 3891 | 78 |
1957492 | 1957492 | 2021-11-27 | Grant | Louisiana | 22043 | 3891 | 78 |
1954241 | 1954241 | 2021-11-26 | Grant | Louisiana | 22043 | 3891 | 78 |
1950990 | 1950990 | 2021-11-25 | Grant | Louisiana | 22043 | 3891 | 78 |
1947739 | 1947739 | 2021-11-24 | Grant | Louisiana | 22043 | 3891 | 78 |
1944488 | 1944488 | 2021-11-23 | Grant | Louisiana | 22043 | 3891 | 78 |
1941238 | 1941238 | 2021-11-22 | Grant | Louisiana | 22043 | 3886 | 78 |
1937988 | 1937988 | 2021-11-21 | Grant | Louisiana | 22043 | 3874 | 78 |
1934738 | 1934738 | 2021-11-20 | Grant | Louisiana | 22043 | 3874 | 78 |
1931487 | 1931487 | 2021-11-19 | Grant | Louisiana | 22043 | 3874 | 78 |
1928236 | 1928236 | 2021-11-18 | Grant | Louisiana | 22043 | 3868 | 78 |
1924986 | 1924986 | 2021-11-17 | Grant | Louisiana | 22043 | 3860 | 78 |
1921737 | 1921737 | 2021-11-16 | Grant | Louisiana | 22043 | 3849 | 78 |
1918487 | 1918487 | 2021-11-15 | Grant | Louisiana | 22043 | 3846 | 78 |
1915237 | 1915237 | 2021-11-14 | Grant | Louisiana | 22043 | 3845 | 78 |
1911987 | 1911987 | 2021-11-13 | Grant | Louisiana | 22043 | 3845 | 78 |
1908738 | 1908738 | 2021-11-12 | Grant | Louisiana | 22043 | 3845 | 78 |
1905489 | 1905489 | 2021-11-11 | Grant | Louisiana | 22043 | 3843 | 78 |
1902239 | 1902239 | 2021-11-10 | Grant | Louisiana | 22043 | 3843 | 78 |
1898989 | 1898989 | 2021-11-09 | Grant | Louisiana | 22043 | 3841 | 78 |
1895739 | 1895739 | 2021-11-08 | Grant | Louisiana | 22043 | 3838 | 78 |
1892489 | 1892489 | 2021-11-07 | Grant | Louisiana | 22043 | 3837 | 78 |
1889239 | 1889239 | 2021-11-06 | Grant | Louisiana | 22043 | 3837 | 78 |
1885989 | 1885989 | 2021-11-05 | Grant | Louisiana | 22043 | 3837 | 78 |
1882740 | 1882740 | 2021-11-04 | Grant | Louisiana | 22043 | 3835 | 77 |
1879491 | 1879491 | 2021-11-03 | Grant | Louisiana | 22043 | 3829 | 77 |
1876242 | 1876242 | 2021-11-02 | Grant | Louisiana | 22043 | 3824 | 77 |
1872993 | 1872993 | 2021-11-01 | Grant | Louisiana | 22043 | 3822 | 77 |
1869744 | 1869744 | 2021-10-31 | Grant | Louisiana | 22043 | 3821 | 77 |
1866495 | 1866495 | 2021-10-30 | Grant | Louisiana | 22043 | 3821 | 77 |
1863246 | 1863246 | 2021-10-29 | Grant | Louisiana | 22043 | 3821 | 77 |
1859997 | 1859997 | 2021-10-28 | Grant | Louisiana | 22043 | 3819 | 77 |
1856748 | 1856748 | 2021-10-27 | Grant | Louisiana | 22043 | 3819 | 77 |
1853499 | 1853499 | 2021-10-26 | Grant | Louisiana | 22043 | 3815 | 77 |
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);