ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Bates" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175699 | 2175699 | 2022-02-02 | Bates | Missouri | 29013 | 3606 | 73 |
2172446 | 2172446 | 2022-02-01 | Bates | Missouri | 29013 | 3578 | 73 |
2169193 | 2169193 | 2022-01-31 | Bates | Missouri | 29013 | 3565 | 70 |
2165938 | 2165938 | 2022-01-30 | Bates | Missouri | 29013 | 3557 | 70 |
2162683 | 2162683 | 2022-01-29 | Bates | Missouri | 29013 | 3549 | 70 |
2159428 | 2159428 | 2022-01-28 | Bates | Missouri | 29013 | 3513 | 70 |
2156174 | 2156174 | 2022-01-27 | Bates | Missouri | 29013 | 3489 | 70 |
2152921 | 2152921 | 2022-01-26 | Bates | Missouri | 29013 | 3454 | 70 |
2149669 | 2149669 | 2022-01-25 | Bates | Missouri | 29013 | 3430 | 70 |
2146417 | 2146417 | 2022-01-24 | Bates | Missouri | 29013 | 3418 | 70 |
2143162 | 2143162 | 2022-01-23 | Bates | Missouri | 29013 | 3402 | 70 |
2139907 | 2139907 | 2022-01-22 | Bates | Missouri | 29013 | 3370 | 70 |
2136651 | 2136651 | 2022-01-21 | Bates | Missouri | 29013 | 3341 | 70 |
2133399 | 2133399 | 2022-01-20 | Bates | Missouri | 29013 | 3295 | 69 |
2130146 | 2130146 | 2022-01-19 | Bates | Missouri | 29013 | 3244 | 69 |
2126892 | 2126892 | 2022-01-18 | Bates | Missouri | 29013 | 3169 | 67 |
2123640 | 2123640 | 2022-01-17 | Bates | Missouri | 29013 | 3140 | 67 |
2120388 | 2120388 | 2022-01-16 | Bates | Missouri | 29013 | 3140 | 67 |
2117136 | 2117136 | 2022-01-15 | Bates | Missouri | 29013 | 3140 | 67 |
2113885 | 2113885 | 2022-01-14 | Bates | Missouri | 29013 | 3085 | 67 |
2110633 | 2110633 | 2022-01-13 | Bates | Missouri | 29013 | 3057 | 67 |
2107382 | 2107382 | 2022-01-12 | Bates | Missouri | 29013 | 2998 | 67 |
2104131 | 2104131 | 2022-01-11 | Bates | Missouri | 29013 | 2951 | 67 |
2100880 | 2100880 | 2022-01-10 | Bates | Missouri | 29013 | 2921 | 65 |
2097629 | 2097629 | 2022-01-09 | Bates | Missouri | 29013 | 2918 | 65 |
2094377 | 2094377 | 2022-01-08 | Bates | Missouri | 29013 | 2918 | 65 |
2091125 | 2091125 | 2022-01-07 | Bates | Missouri | 29013 | 2891 | 65 |
2087874 | 2087874 | 2022-01-06 | Bates | Missouri | 29013 | 2864 | 65 |
2084622 | 2084622 | 2022-01-05 | Bates | Missouri | 29013 | 2851 | 65 |
2081370 | 2081370 | 2022-01-04 | Bates | Missouri | 29013 | 2822 | 65 |
2078118 | 2078118 | 2022-01-03 | Bates | Missouri | 29013 | 2805 | 63 |
2074867 | 2074867 | 2022-01-02 | Bates | Missouri | 29013 | 2764 | 63 |
2071616 | 2071616 | 2022-01-01 | Bates | Missouri | 29013 | 2764 | 63 |
2068365 | 2068365 | 2021-12-31 | Bates | Missouri | 29013 | 2764 | 63 |
2065114 | 2065114 | 2021-12-30 | Bates | Missouri | 29013 | 2764 | 63 |
2061864 | 2061864 | 2021-12-29 | Bates | Missouri | 29013 | 2731 | 63 |
2058615 | 2058615 | 2021-12-28 | Bates | Missouri | 29013 | 2724 | 63 |
2055366 | 2055366 | 2021-12-27 | Bates | Missouri | 29013 | 2708 | 62 |
2052116 | 2052116 | 2021-12-26 | Bates | Missouri | 29013 | 2674 | 62 |
2048866 | 2048866 | 2021-12-25 | Bates | Missouri | 29013 | 2674 | 62 |
2045616 | 2045616 | 2021-12-24 | Bates | Missouri | 29013 | 2674 | 62 |
2042366 | 2042366 | 2021-12-23 | Bates | Missouri | 29013 | 2674 | 62 |
2039117 | 2039117 | 2021-12-22 | Bates | Missouri | 29013 | 2660 | 62 |
2035867 | 2035867 | 2021-12-21 | Bates | Missouri | 29013 | 2650 | 62 |
2032617 | 2032617 | 2021-12-20 | Bates | Missouri | 29013 | 2637 | 60 |
2029366 | 2029366 | 2021-12-19 | Bates | Missouri | 29013 | 2634 | 60 |
2026115 | 2026115 | 2021-12-18 | Bates | Missouri | 29013 | 2633 | 60 |
2022864 | 2022864 | 2021-12-17 | Bates | Missouri | 29013 | 2621 | 60 |
2019613 | 2019613 | 2021-12-16 | Bates | Missouri | 29013 | 2604 | 59 |
2016363 | 2016363 | 2021-12-15 | Bates | Missouri | 29013 | 2600 | 59 |
2013112 | 2013112 | 2021-12-14 | Bates | Missouri | 29013 | 2592 | 59 |
2009861 | 2009861 | 2021-12-13 | Bates | Missouri | 29013 | 2575 | 59 |
2006610 | 2006610 | 2021-12-12 | Bates | Missouri | 29013 | 2575 | 59 |
2003359 | 2003359 | 2021-12-11 | Bates | Missouri | 29013 | 2574 | 59 |
2000109 | 2000109 | 2021-12-10 | Bates | Missouri | 29013 | 2568 | 59 |
1996858 | 1996858 | 2021-12-09 | Bates | Missouri | 29013 | 2561 | 59 |
1993607 | 1993607 | 2021-12-08 | Bates | Missouri | 29013 | 2558 | 59 |
1990356 | 1990356 | 2021-12-07 | Bates | Missouri | 29013 | 2555 | 59 |
1987106 | 1987106 | 2021-12-06 | Bates | Missouri | 29013 | 2545 | 58 |
1983856 | 1983856 | 2021-12-05 | Bates | Missouri | 29013 | 2538 | 58 |
1980606 | 1980606 | 2021-12-04 | Bates | Missouri | 29013 | 2535 | 58 |
1977356 | 1977356 | 2021-12-03 | Bates | Missouri | 29013 | 2511 | 58 |
1974106 | 1974106 | 2021-12-02 | Bates | Missouri | 29013 | 2511 | 58 |
1970857 | 1970857 | 2021-12-01 | Bates | Missouri | 29013 | 2508 | 58 |
1967607 | 1967607 | 2021-11-30 | Bates | Missouri | 29013 | 2507 | 57 |
1964355 | 1964355 | 2021-11-29 | Bates | Missouri | 29013 | 2493 | 56 |
1961104 | 1961104 | 2021-11-28 | Bates | Missouri | 29013 | 2474 | 56 |
1957853 | 1957853 | 2021-11-27 | Bates | Missouri | 29013 | 2474 | 56 |
1954602 | 1954602 | 2021-11-26 | Bates | Missouri | 29013 | 2474 | 56 |
1951351 | 1951351 | 2021-11-25 | Bates | Missouri | 29013 | 2474 | 56 |
1948100 | 1948100 | 2021-11-24 | Bates | Missouri | 29013 | 2474 | 56 |
1944849 | 1944849 | 2021-11-23 | Bates | Missouri | 29013 | 2469 | 56 |
1941598 | 1941598 | 2021-11-22 | Bates | Missouri | 29013 | 2456 | 56 |
1938348 | 1938348 | 2021-11-21 | Bates | Missouri | 29013 | 2455 | 57 |
1935098 | 1935098 | 2021-11-20 | Bates | Missouri | 29013 | 2453 | 57 |
1931848 | 1931848 | 2021-11-19 | Bates | Missouri | 29013 | 2445 | 56 |
1928597 | 1928597 | 2021-11-18 | Bates | Missouri | 29013 | 2439 | 55 |
1925347 | 1925347 | 2021-11-17 | Bates | Missouri | 29013 | 2404 | 43 |
1922098 | 1922098 | 2021-11-16 | Bates | Missouri | 29013 | 2400 | 43 |
1918848 | 1918848 | 2021-11-15 | Bates | Missouri | 29013 | 2387 | 43 |
1915598 | 1915598 | 2021-11-14 | Bates | Missouri | 29013 | 2384 | 43 |
1912348 | 1912348 | 2021-11-13 | Bates | Missouri | 29013 | 2382 | 43 |
1909098 | 1909098 | 2021-11-12 | Bates | Missouri | 29013 | 2374 | 43 |
1905849 | 1905849 | 2021-11-11 | Bates | Missouri | 29013 | 2362 | 43 |
1902600 | 1902600 | 2021-11-10 | Bates | Missouri | 29013 | 2362 | 43 |
1899350 | 1899350 | 2021-11-09 | Bates | Missouri | 29013 | 2354 | 43 |
1896100 | 1896100 | 2021-11-08 | Bates | Missouri | 29013 | 2352 | 43 |
1892850 | 1892850 | 2021-11-07 | Bates | Missouri | 29013 | 2349 | 43 |
1889600 | 1889600 | 2021-11-06 | Bates | Missouri | 29013 | 2346 | 43 |
1886350 | 1886350 | 2021-11-05 | Bates | Missouri | 29013 | 2339 | 43 |
1883101 | 1883101 | 2021-11-04 | Bates | Missouri | 29013 | 2331 | 43 |
1879852 | 1879852 | 2021-11-03 | Bates | Missouri | 29013 | 2327 | 43 |
1876603 | 1876603 | 2021-11-02 | Bates | Missouri | 29013 | 2322 | 43 |
1873354 | 1873354 | 2021-11-01 | Bates | Missouri | 29013 | 2322 | 43 |
1870105 | 1870105 | 2021-10-31 | Bates | Missouri | 29013 | 2322 | 43 |
1866856 | 1866856 | 2021-10-30 | Bates | Missouri | 29013 | 2321 | 43 |
1863607 | 1863607 | 2021-10-29 | Bates | Missouri | 29013 | 2315 | 43 |
1860358 | 1860358 | 2021-10-28 | Bates | Missouri | 29013 | 2312 | 43 |
1857109 | 1857109 | 2021-10-27 | Bates | Missouri | 29013 | 2310 | 43 |
1853860 | 1853860 | 2021-10-26 | Bates | Missouri | 29013 | 2309 | 43 |
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);