ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Washington" and fips = 1129 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174258 | 2174258 | 2022-02-02 | Washington | Alabama | 1129 | 3462 | 53 |
2171006 | 2171006 | 2022-02-01 | Washington | Alabama | 1129 | 3455 | 53 |
2167753 | 2167753 | 2022-01-31 | Washington | Alabama | 1129 | 3447 | 53 |
2164498 | 2164498 | 2022-01-30 | Washington | Alabama | 1129 | 3444 | 53 |
2161243 | 2161243 | 2022-01-29 | Washington | Alabama | 1129 | 3430 | 53 |
2157987 | 2157987 | 2022-01-28 | Washington | Alabama | 1129 | 3303 | 52 |
2154734 | 2154734 | 2022-01-27 | Washington | Alabama | 1129 | 3303 | 52 |
2151481 | 2151481 | 2022-01-26 | Washington | Alabama | 1129 | 3303 | 52 |
2148229 | 2148229 | 2022-01-25 | Washington | Alabama | 1129 | 3303 | 52 |
2144977 | 2144977 | 2022-01-24 | Washington | Alabama | 1129 | 3303 | 52 |
2141722 | 2141722 | 2022-01-23 | Washington | Alabama | 1129 | 3299 | 52 |
2138466 | 2138466 | 2022-01-22 | Washington | Alabama | 1129 | 3280 | 52 |
2135211 | 2135211 | 2022-01-21 | Washington | Alabama | 1129 | 3171 | 52 |
2131959 | 2131959 | 2022-01-20 | Washington | Alabama | 1129 | 3089 | 52 |
2128705 | 2128705 | 2022-01-19 | Washington | Alabama | 1129 | 3055 | 52 |
2125452 | 2125452 | 2022-01-18 | Washington | Alabama | 1129 | 3005 | 52 |
2122200 | 2122200 | 2022-01-17 | Washington | Alabama | 1129 | 2988 | 52 |
2118948 | 2118948 | 2022-01-16 | Washington | Alabama | 1129 | 2968 | 52 |
2115696 | 2115696 | 2022-01-15 | Washington | Alabama | 1129 | 2823 | 52 |
2112444 | 2112444 | 2022-01-14 | Washington | Alabama | 1129 | 2823 | 52 |
2109192 | 2109192 | 2022-01-13 | Washington | Alabama | 1129 | 2823 | 52 |
2105941 | 2105941 | 2022-01-12 | Washington | Alabama | 1129 | 2823 | 52 |
2102690 | 2102690 | 2022-01-11 | Washington | Alabama | 1129 | 2791 | 52 |
2099439 | 2099439 | 2022-01-10 | Washington | Alabama | 1129 | 2770 | 52 |
2096188 | 2096188 | 2022-01-09 | Washington | Alabama | 1129 | 2761 | 52 |
2092936 | 2092936 | 2022-01-08 | Washington | Alabama | 1129 | 2746 | 52 |
2089684 | 2089684 | 2022-01-07 | Washington | Alabama | 1129 | 2741 | 52 |
2086433 | 2086433 | 2022-01-06 | Washington | Alabama | 1129 | 2707 | 51 |
2083181 | 2083181 | 2022-01-05 | Washington | Alabama | 1129 | 2683 | 51 |
2079929 | 2079929 | 2022-01-04 | Washington | Alabama | 1129 | 2652 | 51 |
2076677 | 2076677 | 2022-01-03 | Washington | Alabama | 1129 | 2637 | 51 |
2073426 | 2073426 | 2022-01-02 | Washington | Alabama | 1129 | 2632 | 51 |
2070175 | 2070175 | 2022-01-01 | Washington | Alabama | 1129 | 2616 | 51 |
2066924 | 2066924 | 2021-12-31 | Washington | Alabama | 1129 | 2616 | 51 |
2063674 | 2063674 | 2021-12-30 | Washington | Alabama | 1129 | 2607 | 51 |
2060424 | 2060424 | 2021-12-29 | Washington | Alabama | 1129 | 2601 | 51 |
2057175 | 2057175 | 2021-12-28 | Washington | Alabama | 1129 | 2595 | 51 |
2053926 | 2053926 | 2021-12-27 | Washington | Alabama | 1129 | 2592 | 51 |
2050676 | 2050676 | 2021-12-26 | Washington | Alabama | 1129 | 2587 | 51 |
2047426 | 2047426 | 2021-12-25 | Washington | Alabama | 1129 | 2585 | 51 |
2044176 | 2044176 | 2021-12-24 | Washington | Alabama | 1129 | 2584 | 51 |
2040927 | 2040927 | 2021-12-23 | Washington | Alabama | 1129 | 2583 | 51 |
2037677 | 2037677 | 2021-12-22 | Washington | Alabama | 1129 | 2581 | 51 |
2034427 | 2034427 | 2021-12-21 | Washington | Alabama | 1129 | 2578 | 51 |
2031177 | 2031177 | 2021-12-20 | Washington | Alabama | 1129 | 2576 | 51 |
2027926 | 2027926 | 2021-12-19 | Washington | Alabama | 1129 | 2576 | 51 |
2024675 | 2024675 | 2021-12-18 | Washington | Alabama | 1129 | 2576 | 51 |
2021424 | 2021424 | 2021-12-17 | Washington | Alabama | 1129 | 2576 | 51 |
2018173 | 2018173 | 2021-12-16 | Washington | Alabama | 1129 | 2576 | 51 |
2014923 | 2014923 | 2021-12-15 | Washington | Alabama | 1129 | 2575 | 51 |
2011672 | 2011672 | 2021-12-14 | Washington | Alabama | 1129 | 2575 | 51 |
2008421 | 2008421 | 2021-12-13 | Washington | Alabama | 1129 | 2575 | 51 |
2005170 | 2005170 | 2021-12-12 | Washington | Alabama | 1129 | 2575 | 51 |
2001919 | 2001919 | 2021-12-11 | Washington | Alabama | 1129 | 2575 | 51 |
1998669 | 1998669 | 2021-12-10 | Washington | Alabama | 1129 | 2575 | 51 |
1995418 | 1995418 | 2021-12-09 | Washington | Alabama | 1129 | 2576 | 52 |
1992167 | 1992167 | 2021-12-08 | Washington | Alabama | 1129 | 2575 | 52 |
1988916 | 1988916 | 2021-12-07 | Washington | Alabama | 1129 | 2569 | 52 |
1985666 | 1985666 | 2021-12-06 | Washington | Alabama | 1129 | 2568 | 52 |
1982416 | 1982416 | 2021-12-05 | Washington | Alabama | 1129 | 2568 | 52 |
1979166 | 1979166 | 2021-12-04 | Washington | Alabama | 1129 | 2568 | 52 |
1975916 | 1975916 | 2021-12-03 | Washington | Alabama | 1129 | 2568 | 52 |
1972667 | 1972667 | 2021-12-02 | Washington | Alabama | 1129 | 2568 | 52 |
1969417 | 1969417 | 2021-12-01 | Washington | Alabama | 1129 | 2569 | 52 |
1966167 | 1966167 | 2021-11-30 | Washington | Alabama | 1129 | 2569 | 52 |
1962915 | 1962915 | 2021-11-29 | Washington | Alabama | 1129 | 2570 | 52 |
1959664 | 1959664 | 2021-11-28 | Washington | Alabama | 1129 | 2570 | 52 |
1956413 | 1956413 | 2021-11-27 | Washington | Alabama | 1129 | 2569 | 52 |
1953162 | 1953162 | 2021-11-26 | Washington | Alabama | 1129 | 2569 | 52 |
1949911 | 1949911 | 2021-11-25 | Washington | Alabama | 1129 | 2569 | 52 |
1946660 | 1946660 | 2021-11-24 | Washington | Alabama | 1129 | 2564 | 52 |
1943409 | 1943409 | 2021-11-23 | Washington | Alabama | 1129 | 2563 | 52 |
1940159 | 1940159 | 2021-11-22 | Washington | Alabama | 1129 | 2563 | 52 |
1936909 | 1936909 | 2021-11-21 | Washington | Alabama | 1129 | 2562 | 52 |
1933659 | 1933659 | 2021-11-20 | Washington | Alabama | 1129 | 2561 | 52 |
1930407 | 1930407 | 2021-11-19 | Washington | Alabama | 1129 | 2558 | 52 |
1927157 | 1927157 | 2021-11-18 | Washington | Alabama | 1129 | 2556 | 52 |
1923907 | 1923907 | 2021-11-17 | Washington | Alabama | 1129 | 2555 | 52 |
1920658 | 1920658 | 2021-11-16 | Washington | Alabama | 1129 | 2552 | 52 |
1917408 | 1917408 | 2021-11-15 | Washington | Alabama | 1129 | 2551 | 52 |
1914158 | 1914158 | 2021-11-14 | Washington | Alabama | 1129 | 2551 | 52 |
1910908 | 1910908 | 2021-11-13 | Washington | Alabama | 1129 | 2551 | 52 |
1907659 | 1907659 | 2021-11-12 | Washington | Alabama | 1129 | 2550 | 52 |
1904410 | 1904410 | 2021-11-11 | Washington | Alabama | 1129 | 2550 | 52 |
1901160 | 1901160 | 2021-11-10 | Washington | Alabama | 1129 | 2548 | 52 |
1897910 | 1897910 | 2021-11-09 | Washington | Alabama | 1129 | 2547 | 52 |
1894660 | 1894660 | 2021-11-08 | Washington | Alabama | 1129 | 2548 | 52 |
1891410 | 1891410 | 2021-11-07 | Washington | Alabama | 1129 | 2548 | 52 |
1888160 | 1888160 | 2021-11-06 | Washington | Alabama | 1129 | 2548 | 52 |
1884910 | 1884910 | 2021-11-05 | Washington | Alabama | 1129 | 2546 | 52 |
1881661 | 1881661 | 2021-11-04 | Washington | Alabama | 1129 | 2544 | 52 |
1878412 | 1878412 | 2021-11-03 | Washington | Alabama | 1129 | 2531 | 52 |
1875163 | 1875163 | 2021-11-02 | Washington | Alabama | 1129 | 2528 | 52 |
1871914 | 1871914 | 2021-11-01 | Washington | Alabama | 1129 | 2526 | 52 |
1868665 | 1868665 | 2021-10-31 | Washington | Alabama | 1129 | 2526 | 52 |
1865416 | 1865416 | 2021-10-30 | Washington | Alabama | 1129 | 2525 | 52 |
1862167 | 1862167 | 2021-10-29 | Washington | Alabama | 1129 | 2522 | 52 |
1858918 | 1858918 | 2021-10-28 | Washington | Alabama | 1129 | 2520 | 51 |
1855669 | 1855669 | 2021-10-27 | Washington | Alabama | 1129 | 2519 | 51 |
1852420 | 1852420 | 2021-10-26 | Washington | Alabama | 1129 | 2516 | 51 |
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);