ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Lawrence" and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174343 | 2174343 | 2022-02-02 | Lawrence | Arkansas | 5075 | 4777 | 66 |
2171090 | 2171090 | 2022-02-01 | Lawrence | Arkansas | 5075 | 4762 | 65 |
2167837 | 2167837 | 2022-01-31 | Lawrence | Arkansas | 5075 | 4730 | 65 |
2164582 | 2164582 | 2022-01-30 | Lawrence | Arkansas | 5075 | 4665 | 65 |
2161327 | 2161327 | 2022-01-29 | Lawrence | Arkansas | 5075 | 4665 | 65 |
2158071 | 2158071 | 2022-01-28 | Lawrence | Arkansas | 5075 | 4665 | 65 |
2154818 | 2154818 | 2022-01-27 | Lawrence | Arkansas | 5075 | 4619 | 65 |
2151565 | 2151565 | 2022-01-26 | Lawrence | Arkansas | 5075 | 4583 | 64 |
2148313 | 2148313 | 2022-01-25 | Lawrence | Arkansas | 5075 | 4542 | 64 |
2145061 | 2145061 | 2022-01-24 | Lawrence | Arkansas | 5075 | 4498 | 64 |
2141806 | 2141806 | 2022-01-23 | Lawrence | Arkansas | 5075 | 4467 | 64 |
2138551 | 2138551 | 2022-01-22 | Lawrence | Arkansas | 5075 | 4436 | 64 |
2135295 | 2135295 | 2022-01-21 | Lawrence | Arkansas | 5075 | 4370 | 64 |
2132043 | 2132043 | 2022-01-20 | Lawrence | Arkansas | 5075 | 4323 | 64 |
2128790 | 2128790 | 2022-01-19 | Lawrence | Arkansas | 5075 | 4272 | 64 |
2125536 | 2125536 | 2022-01-18 | Lawrence | Arkansas | 5075 | 4167 | 64 |
2122284 | 2122284 | 2022-01-17 | Lawrence | Arkansas | 5075 | 4160 | 64 |
2119032 | 2119032 | 2022-01-16 | Lawrence | Arkansas | 5075 | 4141 | 64 |
2115780 | 2115780 | 2022-01-15 | Lawrence | Arkansas | 5075 | 4119 | 64 |
2112529 | 2112529 | 2022-01-14 | Lawrence | Arkansas | 5075 | 4075 | 64 |
2109277 | 2109277 | 2022-01-13 | Lawrence | Arkansas | 5075 | 4032 | 64 |
2106026 | 2106026 | 2022-01-12 | Lawrence | Arkansas | 5075 | 3988 | 64 |
2102775 | 2102775 | 2022-01-11 | Lawrence | Arkansas | 5075 | 3944 | 64 |
2099524 | 2099524 | 2022-01-10 | Lawrence | Arkansas | 5075 | 3893 | 64 |
2096273 | 2096273 | 2022-01-09 | Lawrence | Arkansas | 5075 | 3864 | 64 |
2093021 | 2093021 | 2022-01-08 | Lawrence | Arkansas | 5075 | 3864 | 64 |
2089769 | 2089769 | 2022-01-07 | Lawrence | Arkansas | 5075 | 3851 | 64 |
2086518 | 2086518 | 2022-01-06 | Lawrence | Arkansas | 5075 | 3826 | 64 |
2083266 | 2083266 | 2022-01-05 | Lawrence | Arkansas | 5075 | 3809 | 63 |
2080014 | 2080014 | 2022-01-04 | Lawrence | Arkansas | 5075 | 3775 | 63 |
2076762 | 2076762 | 2022-01-03 | Lawrence | Arkansas | 5075 | 3743 | 63 |
2073511 | 2073511 | 2022-01-02 | Lawrence | Arkansas | 5075 | 3732 | 63 |
2070260 | 2070260 | 2022-01-01 | Lawrence | Arkansas | 5075 | 3725 | 63 |
2067009 | 2067009 | 2021-12-31 | Lawrence | Arkansas | 5075 | 3706 | 63 |
2063758 | 2063758 | 2021-12-30 | Lawrence | Arkansas | 5075 | 3687 | 63 |
2060508 | 2060508 | 2021-12-29 | Lawrence | Arkansas | 5075 | 3672 | 63 |
2057259 | 2057259 | 2021-12-28 | Lawrence | Arkansas | 5075 | 3656 | 63 |
2054010 | 2054010 | 2021-12-27 | Lawrence | Arkansas | 5075 | 3638 | 62 |
2050760 | 2050760 | 2021-12-26 | Lawrence | Arkansas | 5075 | 3629 | 62 |
2047510 | 2047510 | 2021-12-25 | Lawrence | Arkansas | 5075 | 3627 | 62 |
2044260 | 2044260 | 2021-12-24 | Lawrence | Arkansas | 5075 | 3625 | 62 |
2041011 | 2041011 | 2021-12-23 | Lawrence | Arkansas | 5075 | 3622 | 62 |
2037761 | 2037761 | 2021-12-22 | Lawrence | Arkansas | 5075 | 3610 | 62 |
2034511 | 2034511 | 2021-12-21 | Lawrence | Arkansas | 5075 | 3608 | 62 |
2031261 | 2031261 | 2021-12-20 | Lawrence | Arkansas | 5075 | 3584 | 62 |
2028010 | 2028010 | 2021-12-19 | Lawrence | Arkansas | 5075 | 3582 | 62 |
2024759 | 2024759 | 2021-12-18 | Lawrence | Arkansas | 5075 | 3580 | 62 |
2021508 | 2021508 | 2021-12-17 | Lawrence | Arkansas | 5075 | 3569 | 62 |
2018257 | 2018257 | 2021-12-16 | Lawrence | Arkansas | 5075 | 3552 | 62 |
2015007 | 2015007 | 2021-12-15 | Lawrence | Arkansas | 5075 | 3546 | 62 |
2011756 | 2011756 | 2021-12-14 | Lawrence | Arkansas | 5075 | 3546 | 62 |
2008505 | 2008505 | 2021-12-13 | Lawrence | Arkansas | 5075 | 3533 | 62 |
2005254 | 2005254 | 2021-12-12 | Lawrence | Arkansas | 5075 | 3529 | 62 |
2002003 | 2002003 | 2021-12-11 | Lawrence | Arkansas | 5075 | 3527 | 62 |
1998753 | 1998753 | 2021-12-10 | Lawrence | Arkansas | 5075 | 3523 | 62 |
1995502 | 1995502 | 2021-12-09 | Lawrence | Arkansas | 5075 | 3518 | 62 |
1992251 | 1992251 | 2021-12-08 | Lawrence | Arkansas | 5075 | 3511 | 62 |
1989000 | 1989000 | 2021-12-07 | Lawrence | Arkansas | 5075 | 3508 | 62 |
1985750 | 1985750 | 2021-12-06 | Lawrence | Arkansas | 5075 | 3503 | 62 |
1982500 | 1982500 | 2021-12-05 | Lawrence | Arkansas | 5075 | 3501 | 62 |
1979250 | 1979250 | 2021-12-04 | Lawrence | Arkansas | 5075 | 3502 | 62 |
1976000 | 1976000 | 2021-12-03 | Lawrence | Arkansas | 5075 | 3497 | 62 |
1972751 | 1972751 | 2021-12-02 | Lawrence | Arkansas | 5075 | 3491 | 62 |
1969501 | 1969501 | 2021-12-01 | Lawrence | Arkansas | 5075 | 3482 | 62 |
1966251 | 1966251 | 2021-11-30 | Lawrence | Arkansas | 5075 | 3478 | 62 |
1962999 | 1962999 | 2021-11-29 | Lawrence | Arkansas | 5075 | 3474 | 62 |
1959748 | 1959748 | 2021-11-28 | Lawrence | Arkansas | 5075 | 3467 | 62 |
1956497 | 1956497 | 2021-11-27 | Lawrence | Arkansas | 5075 | 3468 | 62 |
1953246 | 1953246 | 2021-11-26 | Lawrence | Arkansas | 5075 | 3465 | 62 |
1949995 | 1949995 | 2021-11-25 | Lawrence | Arkansas | 5075 | 3464 | 62 |
1946744 | 1946744 | 2021-11-24 | Lawrence | Arkansas | 5075 | 3462 | 60 |
1943493 | 1943493 | 2021-11-23 | Lawrence | Arkansas | 5075 | 3459 | 60 |
1940243 | 1940243 | 2021-11-22 | Lawrence | Arkansas | 5075 | 3459 | 60 |
1936993 | 1936993 | 2021-11-21 | Lawrence | Arkansas | 5075 | 3456 | 60 |
1933743 | 1933743 | 2021-11-20 | Lawrence | Arkansas | 5075 | 3452 | 60 |
1930491 | 1930491 | 2021-11-19 | Lawrence | Arkansas | 5075 | 3443 | 59 |
1927241 | 1927241 | 2021-11-18 | Lawrence | Arkansas | 5075 | 3425 | 59 |
1923991 | 1923991 | 2021-11-17 | Lawrence | Arkansas | 5075 | 3417 | 59 |
1920742 | 1920742 | 2021-11-16 | Lawrence | Arkansas | 5075 | 3405 | 59 |
1917492 | 1917492 | 2021-11-15 | Lawrence | Arkansas | 5075 | 3395 | 58 |
1914242 | 1914242 | 2021-11-14 | Lawrence | Arkansas | 5075 | 3387 | 58 |
1910992 | 1910992 | 2021-11-13 | Lawrence | Arkansas | 5075 | 3376 | 58 |
1907743 | 1907743 | 2021-11-12 | Lawrence | Arkansas | 5075 | 3369 | 58 |
1904494 | 1904494 | 2021-11-11 | Lawrence | Arkansas | 5075 | 3357 | 58 |
1901244 | 1901244 | 2021-11-10 | Lawrence | Arkansas | 5075 | 3354 | 58 |
1897994 | 1897994 | 2021-11-09 | Lawrence | Arkansas | 5075 | 3343 | 58 |
1894744 | 1894744 | 2021-11-08 | Lawrence | Arkansas | 5075 | 3334 | 58 |
1891494 | 1891494 | 2021-11-07 | Lawrence | Arkansas | 5075 | 3332 | 58 |
1888244 | 1888244 | 2021-11-06 | Lawrence | Arkansas | 5075 | 3328 | 58 |
1884994 | 1884994 | 2021-11-05 | Lawrence | Arkansas | 5075 | 3321 | 58 |
1881745 | 1881745 | 2021-11-04 | Lawrence | Arkansas | 5075 | 3318 | 58 |
1878496 | 1878496 | 2021-11-03 | Lawrence | Arkansas | 5075 | 3314 | 58 |
1875247 | 1875247 | 2021-11-02 | Lawrence | Arkansas | 5075 | 3308 | 57 |
1871998 | 1871998 | 2021-11-01 | Lawrence | Arkansas | 5075 | 3305 | 57 |
1868749 | 1868749 | 2021-10-31 | Lawrence | Arkansas | 5075 | 3304 | 57 |
1865500 | 1865500 | 2021-10-30 | Lawrence | Arkansas | 5075 | 3298 | 57 |
1862251 | 1862251 | 2021-10-29 | Lawrence | Arkansas | 5075 | 3288 | 57 |
1859002 | 1859002 | 2021-10-28 | Lawrence | Arkansas | 5075 | 3282 | 57 |
1855753 | 1855753 | 2021-10-27 | Lawrence | Arkansas | 5075 | 3279 | 57 |
1852504 | 1852504 | 2021-10-26 | Lawrence | Arkansas | 5075 | 3269 | 56 |
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);