ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lamar" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174231 | 2174231 | 2022-02-02 | Lamar | Alabama | 1075 | 3430 | 61 |
2170979 | 2170979 | 2022-02-01 | Lamar | Alabama | 1075 | 3421 | 60 |
2167726 | 2167726 | 2022-01-31 | Lamar | Alabama | 1075 | 3412 | 60 |
2164471 | 2164471 | 2022-01-30 | Lamar | Alabama | 1075 | 3403 | 60 |
2161216 | 2161216 | 2022-01-29 | Lamar | Alabama | 1075 | 3382 | 60 |
2157960 | 2157960 | 2022-01-28 | Lamar | Alabama | 1075 | 3222 | 60 |
2154707 | 2154707 | 2022-01-27 | Lamar | Alabama | 1075 | 3222 | 60 |
2151454 | 2151454 | 2022-01-26 | Lamar | Alabama | 1075 | 3222 | 60 |
2148202 | 2148202 | 2022-01-25 | Lamar | Alabama | 1075 | 3222 | 60 |
2144950 | 2144950 | 2022-01-24 | Lamar | Alabama | 1075 | 3222 | 60 |
2141695 | 2141695 | 2022-01-23 | Lamar | Alabama | 1075 | 3210 | 60 |
2138439 | 2138439 | 2022-01-22 | Lamar | Alabama | 1075 | 3177 | 60 |
2135184 | 2135184 | 2022-01-21 | Lamar | Alabama | 1075 | 3050 | 60 |
2131932 | 2131932 | 2022-01-20 | Lamar | Alabama | 1075 | 2997 | 60 |
2128678 | 2128678 | 2022-01-19 | Lamar | Alabama | 1075 | 2933 | 60 |
2125425 | 2125425 | 2022-01-18 | Lamar | Alabama | 1075 | 2885 | 60 |
2122173 | 2122173 | 2022-01-17 | Lamar | Alabama | 1075 | 2874 | 60 |
2118921 | 2118921 | 2022-01-16 | Lamar | Alabama | 1075 | 2859 | 60 |
2115669 | 2115669 | 2022-01-15 | Lamar | Alabama | 1075 | 2756 | 60 |
2112417 | 2112417 | 2022-01-14 | Lamar | Alabama | 1075 | 2756 | 60 |
2109165 | 2109165 | 2022-01-13 | Lamar | Alabama | 1075 | 2756 | 60 |
2105914 | 2105914 | 2022-01-12 | Lamar | Alabama | 1075 | 2756 | 60 |
2102663 | 2102663 | 2022-01-11 | Lamar | Alabama | 1075 | 2727 | 60 |
2099412 | 2099412 | 2022-01-10 | Lamar | Alabama | 1075 | 2698 | 60 |
2096161 | 2096161 | 2022-01-09 | Lamar | Alabama | 1075 | 2690 | 60 |
2092909 | 2092909 | 2022-01-08 | Lamar | Alabama | 1075 | 2674 | 60 |
2089657 | 2089657 | 2022-01-07 | Lamar | Alabama | 1075 | 2661 | 60 |
2086406 | 2086406 | 2022-01-06 | Lamar | Alabama | 1075 | 2650 | 60 |
2083154 | 2083154 | 2022-01-05 | Lamar | Alabama | 1075 | 2634 | 60 |
2079902 | 2079902 | 2022-01-04 | Lamar | Alabama | 1075 | 2625 | 60 |
2076650 | 2076650 | 2022-01-03 | Lamar | Alabama | 1075 | 2624 | 59 |
2073399 | 2073399 | 2022-01-02 | Lamar | Alabama | 1075 | 2617 | 59 |
2070148 | 2070148 | 2022-01-01 | Lamar | Alabama | 1075 | 2613 | 59 |
2066897 | 2066897 | 2021-12-31 | Lamar | Alabama | 1075 | 2613 | 59 |
2063647 | 2063647 | 2021-12-30 | Lamar | Alabama | 1075 | 2603 | 59 |
2060397 | 2060397 | 2021-12-29 | Lamar | Alabama | 1075 | 2595 | 59 |
2057148 | 2057148 | 2021-12-28 | Lamar | Alabama | 1075 | 2586 | 58 |
2053899 | 2053899 | 2021-12-27 | Lamar | Alabama | 1075 | 2583 | 57 |
2050649 | 2050649 | 2021-12-26 | Lamar | Alabama | 1075 | 2579 | 57 |
2047399 | 2047399 | 2021-12-25 | Lamar | Alabama | 1075 | 2577 | 57 |
2044149 | 2044149 | 2021-12-24 | Lamar | Alabama | 1075 | 2573 | 57 |
2040900 | 2040900 | 2021-12-23 | Lamar | Alabama | 1075 | 2572 | 57 |
2037650 | 2037650 | 2021-12-22 | Lamar | Alabama | 1075 | 2569 | 56 |
2034400 | 2034400 | 2021-12-21 | Lamar | Alabama | 1075 | 2560 | 56 |
2031150 | 2031150 | 2021-12-20 | Lamar | Alabama | 1075 | 2560 | 55 |
2027899 | 2027899 | 2021-12-19 | Lamar | Alabama | 1075 | 2560 | 55 |
2024648 | 2024648 | 2021-12-18 | Lamar | Alabama | 1075 | 2558 | 55 |
2021397 | 2021397 | 2021-12-17 | Lamar | Alabama | 1075 | 2557 | 55 |
2018146 | 2018146 | 2021-12-16 | Lamar | Alabama | 1075 | 2553 | 55 |
2014896 | 2014896 | 2021-12-15 | Lamar | Alabama | 1075 | 2551 | 55 |
2011645 | 2011645 | 2021-12-14 | Lamar | Alabama | 1075 | 2549 | 55 |
2008394 | 2008394 | 2021-12-13 | Lamar | Alabama | 1075 | 2547 | 55 |
2005143 | 2005143 | 2021-12-12 | Lamar | Alabama | 1075 | 2547 | 55 |
2001892 | 2001892 | 2021-12-11 | Lamar | Alabama | 1075 | 2547 | 55 |
1998642 | 1998642 | 2021-12-10 | Lamar | Alabama | 1075 | 2542 | 55 |
1995391 | 1995391 | 2021-12-09 | Lamar | Alabama | 1075 | 2542 | 55 |
1992140 | 1992140 | 2021-12-08 | Lamar | Alabama | 1075 | 2542 | 55 |
1988889 | 1988889 | 2021-12-07 | Lamar | Alabama | 1075 | 2537 | 55 |
1985639 | 1985639 | 2021-12-06 | Lamar | Alabama | 1075 | 2535 | 55 |
1982389 | 1982389 | 2021-12-05 | Lamar | Alabama | 1075 | 2535 | 55 |
1979139 | 1979139 | 2021-12-04 | Lamar | Alabama | 1075 | 2535 | 55 |
1975889 | 1975889 | 2021-12-03 | Lamar | Alabama | 1075 | 2535 | 55 |
1972640 | 1972640 | 2021-12-02 | Lamar | Alabama | 1075 | 2533 | 55 |
1969390 | 1969390 | 2021-12-01 | Lamar | Alabama | 1075 | 2531 | 54 |
1966140 | 1966140 | 2021-11-30 | Lamar | Alabama | 1075 | 2519 | 53 |
1962888 | 1962888 | 2021-11-29 | Lamar | Alabama | 1075 | 2514 | 53 |
1959637 | 1959637 | 2021-11-28 | Lamar | Alabama | 1075 | 2514 | 53 |
1956386 | 1956386 | 2021-11-27 | Lamar | Alabama | 1075 | 2512 | 53 |
1953135 | 1953135 | 2021-11-26 | Lamar | Alabama | 1075 | 2512 | 53 |
1949884 | 1949884 | 2021-11-25 | Lamar | Alabama | 1075 | 2512 | 53 |
1946633 | 1946633 | 2021-11-24 | Lamar | Alabama | 1075 | 2506 | 53 |
1943382 | 1943382 | 2021-11-23 | Lamar | Alabama | 1075 | 2503 | 53 |
1940132 | 1940132 | 2021-11-22 | Lamar | Alabama | 1075 | 2496 | 53 |
1936882 | 1936882 | 2021-11-21 | Lamar | Alabama | 1075 | 2494 | 53 |
1933632 | 1933632 | 2021-11-20 | Lamar | Alabama | 1075 | 2493 | 53 |
1930380 | 1930380 | 2021-11-19 | Lamar | Alabama | 1075 | 2486 | 53 |
1927130 | 1927130 | 2021-11-18 | Lamar | Alabama | 1075 | 2477 | 52 |
1923880 | 1923880 | 2021-11-17 | Lamar | Alabama | 1075 | 2474 | 52 |
1920631 | 1920631 | 2021-11-16 | Lamar | Alabama | 1075 | 2458 | 52 |
1917381 | 1917381 | 2021-11-15 | Lamar | Alabama | 1075 | 2452 | 52 |
1914131 | 1914131 | 2021-11-14 | Lamar | Alabama | 1075 | 2449 | 52 |
1910881 | 1910881 | 2021-11-13 | Lamar | Alabama | 1075 | 2448 | 52 |
1907632 | 1907632 | 2021-11-12 | Lamar | Alabama | 1075 | 2431 | 51 |
1904383 | 1904383 | 2021-11-11 | Lamar | Alabama | 1075 | 2418 | 51 |
1901133 | 1901133 | 2021-11-10 | Lamar | Alabama | 1075 | 2414 | 51 |
1897883 | 1897883 | 2021-11-09 | Lamar | Alabama | 1075 | 2409 | 51 |
1894633 | 1894633 | 2021-11-08 | Lamar | Alabama | 1075 | 2399 | 51 |
1891383 | 1891383 | 2021-11-07 | Lamar | Alabama | 1075 | 2399 | 51 |
1888133 | 1888133 | 2021-11-06 | Lamar | Alabama | 1075 | 2395 | 51 |
1884883 | 1884883 | 2021-11-05 | Lamar | Alabama | 1075 | 2377 | 51 |
1881634 | 1881634 | 2021-11-04 | Lamar | Alabama | 1075 | 2371 | 51 |
1878385 | 1878385 | 2021-11-03 | Lamar | Alabama | 1075 | 2356 | 51 |
1875136 | 1875136 | 2021-11-02 | Lamar | Alabama | 1075 | 2347 | 49 |
1871887 | 1871887 | 2021-11-01 | Lamar | Alabama | 1075 | 2325 | 49 |
1868638 | 1868638 | 2021-10-31 | Lamar | Alabama | 1075 | 2324 | 49 |
1865389 | 1865389 | 2021-10-30 | Lamar | Alabama | 1075 | 2323 | 49 |
1862140 | 1862140 | 2021-10-29 | Lamar | Alabama | 1075 | 2321 | 48 |
1858891 | 1858891 | 2021-10-28 | Lamar | Alabama | 1075 | 2310 | 48 |
1855642 | 1855642 | 2021-10-27 | Lamar | Alabama | 1075 | 2296 | 47 |
1852393 | 1852393 | 2021-10-26 | Lamar | Alabama | 1075 | 2257 | 47 |
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);