ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Winn" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175381 | 2175381 | 2022-02-02 | Winn | Louisiana | 22127 | 4147 | 58 |
2172128 | 2172128 | 2022-02-01 | Winn | Louisiana | 22127 | 4108 | 58 |
2168875 | 2168875 | 2022-01-31 | Winn | Louisiana | 22127 | 4089 | 58 |
2165620 | 2165620 | 2022-01-30 | Winn | Louisiana | 22127 | 3994 | 58 |
2162365 | 2162365 | 2022-01-29 | Winn | Louisiana | 22127 | 3994 | 58 |
2159110 | 2159110 | 2022-01-28 | Winn | Louisiana | 22127 | 3994 | 58 |
2155856 | 2155856 | 2022-01-27 | Winn | Louisiana | 22127 | 3950 | 58 |
2152603 | 2152603 | 2022-01-26 | Winn | Louisiana | 22127 | 3906 | 58 |
2149351 | 2149351 | 2022-01-25 | Winn | Louisiana | 22127 | 3650 | 58 |
2146099 | 2146099 | 2022-01-24 | Winn | Louisiana | 22127 | 3608 | 58 |
2142844 | 2142844 | 2022-01-23 | Winn | Louisiana | 22127 | 3553 | 58 |
2139589 | 2139589 | 2022-01-22 | Winn | Louisiana | 22127 | 3553 | 58 |
2136333 | 2136333 | 2022-01-21 | Winn | Louisiana | 22127 | 3553 | 58 |
2133081 | 2133081 | 2022-01-20 | Winn | Louisiana | 22127 | 3497 | 58 |
2129828 | 2129828 | 2022-01-19 | Winn | Louisiana | 22127 | 3400 | 58 |
2126574 | 2126574 | 2022-01-18 | Winn | Louisiana | 22127 | 3371 | 58 |
2123322 | 2123322 | 2022-01-17 | Winn | Louisiana | 22127 | 3317 | 58 |
2120070 | 2120070 | 2022-01-16 | Winn | Louisiana | 22127 | 3317 | 58 |
2116818 | 2116818 | 2022-01-15 | Winn | Louisiana | 22127 | 3317 | 58 |
2113567 | 2113567 | 2022-01-14 | Winn | Louisiana | 22127 | 3317 | 58 |
2110315 | 2110315 | 2022-01-13 | Winn | Louisiana | 22127 | 3127 | 58 |
2107064 | 2107064 | 2022-01-12 | Winn | Louisiana | 22127 | 3127 | 58 |
2103813 | 2103813 | 2022-01-11 | Winn | Louisiana | 22127 | 3127 | 58 |
2100562 | 2100562 | 2022-01-10 | Winn | Louisiana | 22127 | 3083 | 58 |
2097311 | 2097311 | 2022-01-09 | Winn | Louisiana | 22127 | 2999 | 58 |
2094059 | 2094059 | 2022-01-08 | Winn | Louisiana | 22127 | 2999 | 58 |
2090807 | 2090807 | 2022-01-07 | Winn | Louisiana | 22127 | 2999 | 58 |
2087556 | 2087556 | 2022-01-06 | Winn | Louisiana | 22127 | 2961 | 58 |
2084304 | 2084304 | 2022-01-05 | Winn | Louisiana | 22127 | 2919 | 58 |
2081052 | 2081052 | 2022-01-04 | Winn | Louisiana | 22127 | 2887 | 58 |
2077800 | 2077800 | 2022-01-03 | Winn | Louisiana | 22127 | 2856 | 58 |
2074549 | 2074549 | 2022-01-02 | Winn | Louisiana | 22127 | 2798 | 58 |
2071298 | 2071298 | 2022-01-01 | Winn | Louisiana | 22127 | 2798 | 58 |
2068047 | 2068047 | 2021-12-31 | Winn | Louisiana | 22127 | 2798 | 58 |
2064796 | 2064796 | 2021-12-30 | Winn | Louisiana | 22127 | 2798 | 58 |
2061546 | 2061546 | 2021-12-29 | Winn | Louisiana | 22127 | 2775 | 58 |
2058297 | 2058297 | 2021-12-28 | Winn | Louisiana | 22127 | 2744 | 58 |
2055048 | 2055048 | 2021-12-27 | Winn | Louisiana | 22127 | 2735 | 58 |
2051798 | 2051798 | 2021-12-26 | Winn | Louisiana | 22127 | 2713 | 58 |
2048548 | 2048548 | 2021-12-25 | Winn | Louisiana | 22127 | 2713 | 58 |
2045298 | 2045298 | 2021-12-24 | Winn | Louisiana | 22127 | 2713 | 58 |
2042049 | 2042049 | 2021-12-23 | Winn | Louisiana | 22127 | 2713 | 58 |
2038799 | 2038799 | 2021-12-22 | Winn | Louisiana | 22127 | 2707 | 58 |
2035549 | 2035549 | 2021-12-21 | Winn | Louisiana | 22127 | 2701 | 58 |
2032299 | 2032299 | 2021-12-20 | Winn | Louisiana | 22127 | 2691 | 58 |
2029048 | 2029048 | 2021-12-19 | Winn | Louisiana | 22127 | 2687 | 58 |
2025797 | 2025797 | 2021-12-18 | Winn | Louisiana | 22127 | 2687 | 58 |
2022546 | 2022546 | 2021-12-17 | Winn | Louisiana | 22127 | 2687 | 58 |
2019295 | 2019295 | 2021-12-16 | Winn | Louisiana | 22127 | 2683 | 58 |
2016045 | 2016045 | 2021-12-15 | Winn | Louisiana | 22127 | 2673 | 58 |
2012794 | 2012794 | 2021-12-14 | Winn | Louisiana | 22127 | 2670 | 58 |
2009543 | 2009543 | 2021-12-13 | Winn | Louisiana | 22127 | 2667 | 58 |
2006292 | 2006292 | 2021-12-12 | Winn | Louisiana | 22127 | 2663 | 58 |
2003041 | 2003041 | 2021-12-11 | Winn | Louisiana | 22127 | 2663 | 58 |
1999791 | 1999791 | 2021-12-10 | Winn | Louisiana | 22127 | 2663 | 58 |
1996540 | 1996540 | 2021-12-09 | Winn | Louisiana | 22127 | 2663 | 58 |
1993289 | 1993289 | 2021-12-08 | Winn | Louisiana | 22127 | 2661 | 58 |
1990038 | 1990038 | 2021-12-07 | Winn | Louisiana | 22127 | 2660 | 58 |
1986788 | 1986788 | 2021-12-06 | Winn | Louisiana | 22127 | 2660 | 58 |
1983538 | 1983538 | 2021-12-05 | Winn | Louisiana | 22127 | 2657 | 58 |
1980288 | 1980288 | 2021-12-04 | Winn | Louisiana | 22127 | 2657 | 58 |
1977038 | 1977038 | 2021-12-03 | Winn | Louisiana | 22127 | 2657 | 58 |
1973789 | 1973789 | 2021-12-02 | Winn | Louisiana | 22127 | 2657 | 58 |
1970539 | 1970539 | 2021-12-01 | Winn | Louisiana | 22127 | 2657 | 58 |
1967289 | 1967289 | 2021-11-30 | Winn | Louisiana | 22127 | 2655 | 58 |
1964037 | 1964037 | 2021-11-29 | Winn | Louisiana | 22127 | 2655 | 58 |
1960786 | 1960786 | 2021-11-28 | Winn | Louisiana | 22127 | 2652 | 58 |
1957535 | 1957535 | 2021-11-27 | Winn | Louisiana | 22127 | 2652 | 58 |
1954284 | 1954284 | 2021-11-26 | Winn | Louisiana | 22127 | 2652 | 58 |
1951033 | 1951033 | 2021-11-25 | Winn | Louisiana | 22127 | 2652 | 58 |
1947782 | 1947782 | 2021-11-24 | Winn | Louisiana | 22127 | 2652 | 58 |
1944531 | 1944531 | 2021-11-23 | Winn | Louisiana | 22127 | 2651 | 58 |
1941281 | 1941281 | 2021-11-22 | Winn | Louisiana | 22127 | 2650 | 58 |
1938031 | 1938031 | 2021-11-21 | Winn | Louisiana | 22127 | 2647 | 58 |
1934781 | 1934781 | 2021-11-20 | Winn | Louisiana | 22127 | 2647 | 58 |
1931530 | 1931530 | 2021-11-19 | Winn | Louisiana | 22127 | 2647 | 58 |
1928279 | 1928279 | 2021-11-18 | Winn | Louisiana | 22127 | 2647 | 58 |
1925029 | 1925029 | 2021-11-17 | Winn | Louisiana | 22127 | 2644 | 58 |
1921780 | 1921780 | 2021-11-16 | Winn | Louisiana | 22127 | 2641 | 58 |
1918530 | 1918530 | 2021-11-15 | Winn | Louisiana | 22127 | 2641 | 58 |
1915280 | 1915280 | 2021-11-14 | Winn | Louisiana | 22127 | 2641 | 58 |
1912030 | 1912030 | 2021-11-13 | Winn | Louisiana | 22127 | 2641 | 58 |
1908781 | 1908781 | 2021-11-12 | Winn | Louisiana | 22127 | 2641 | 58 |
1905532 | 1905532 | 2021-11-11 | Winn | Louisiana | 22127 | 2637 | 58 |
1902282 | 1902282 | 2021-11-10 | Winn | Louisiana | 22127 | 2637 | 58 |
1899032 | 1899032 | 2021-11-09 | Winn | Louisiana | 22127 | 2637 | 58 |
1895782 | 1895782 | 2021-11-08 | Winn | Louisiana | 22127 | 2636 | 58 |
1892532 | 1892532 | 2021-11-07 | Winn | Louisiana | 22127 | 2635 | 58 |
1889282 | 1889282 | 2021-11-06 | Winn | Louisiana | 22127 | 2635 | 58 |
1886032 | 1886032 | 2021-11-05 | Winn | Louisiana | 22127 | 2635 | 58 |
1882783 | 1882783 | 2021-11-04 | Winn | Louisiana | 22127 | 2632 | 58 |
1879534 | 1879534 | 2021-11-03 | Winn | Louisiana | 22127 | 2630 | 58 |
1876285 | 1876285 | 2021-11-02 | Winn | Louisiana | 22127 | 2628 | 58 |
1873036 | 1873036 | 2021-11-01 | Winn | Louisiana | 22127 | 2626 | 58 |
1869787 | 1869787 | 2021-10-31 | Winn | Louisiana | 22127 | 2625 | 58 |
1866538 | 1866538 | 2021-10-30 | Winn | Louisiana | 22127 | 2625 | 58 |
1863289 | 1863289 | 2021-10-29 | Winn | Louisiana | 22127 | 2625 | 58 |
1860040 | 1860040 | 2021-10-28 | Winn | Louisiana | 22127 | 2624 | 58 |
1856791 | 1856791 | 2021-10-27 | Winn | Louisiana | 22127 | 2623 | 58 |
1853542 | 1853542 | 2021-10-26 | Winn | Louisiana | 22127 | 2618 | 58 |
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);