ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 2158 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 11
state 1
- Missouri · 46 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471793 | 2471793 | 2022-05-04 | Gentry | Missouri | 29075 | 2158 | 31 |
2468537 | 2468537 | 2022-05-03 | Gentry | Missouri | 29075 | 2158 | 31 |
2465281 | 2465281 | 2022-05-02 | Gentry | Missouri | 29075 | 2158 | 31 |
2462026 | 2462026 | 2022-05-01 | Gentry | Missouri | 29075 | 2158 | 31 |
2458770 | 2458770 | 2022-04-30 | Gentry | Missouri | 29075 | 2158 | 31 |
2455514 | 2455514 | 2022-04-29 | Gentry | Missouri | 29075 | 2158 | 31 |
2452258 | 2452258 | 2022-04-28 | Gentry | Missouri | 29075 | 2158 | 31 |
2449002 | 2449002 | 2022-04-27 | Gentry | Missouri | 29075 | 2158 | 31 |
2445745 | 2445745 | 2022-04-26 | Gentry | Missouri | 29075 | 2158 | 31 |
2442490 | 2442490 | 2022-04-25 | Gentry | Missouri | 29075 | 2158 | 31 |
2439234 | 2439234 | 2022-04-24 | Gentry | Missouri | 29075 | 2158 | 31 |
2435978 | 2435978 | 2022-04-23 | Gentry | Missouri | 29075 | 2158 | 31 |
2432722 | 2432722 | 2022-04-22 | Gentry | Missouri | 29075 | 2158 | 31 |
2429466 | 2429466 | 2022-04-21 | Gentry | Missouri | 29075 | 2158 | 31 |
2426210 | 2426210 | 2022-04-20 | Gentry | Missouri | 29075 | 2158 | 31 |
2422954 | 2422954 | 2022-04-19 | Gentry | Missouri | 29075 | 2158 | 31 |
2419697 | 2419697 | 2022-04-18 | Gentry | Missouri | 29075 | 2158 | 31 |
2416442 | 2416442 | 2022-04-17 | Gentry | Missouri | 29075 | 2158 | 31 |
2413186 | 2413186 | 2022-04-16 | Gentry | Missouri | 29075 | 2158 | 31 |
2409930 | 2409930 | 2022-04-15 | Gentry | Missouri | 29075 | 2158 | 31 |
2406674 | 2406674 | 2022-04-14 | Gentry | Missouri | 29075 | 2158 | 31 |
2403418 | 2403418 | 2022-04-13 | Gentry | Missouri | 29075 | 2158 | 31 |
2400163 | 2400163 | 2022-04-12 | Gentry | Missouri | 29075 | 2158 | 31 |
2396908 | 2396908 | 2022-04-11 | Gentry | Missouri | 29075 | 2158 | 31 |
2393653 | 2393653 | 2022-04-10 | Gentry | Missouri | 29075 | 2158 | 31 |
2390397 | 2390397 | 2022-04-09 | Gentry | Missouri | 29075 | 2158 | 31 |
2387141 | 2387141 | 2022-04-08 | Gentry | Missouri | 29075 | 2158 | 31 |
2383886 | 2383886 | 2022-04-07 | Gentry | Missouri | 29075 | 2158 | 31 |
2380631 | 2380631 | 2022-04-06 | Gentry | Missouri | 29075 | 2158 | 31 |
2377376 | 2377376 | 2022-04-05 | Gentry | Missouri | 29075 | 2158 | 31 |
2374123 | 2374123 | 2022-04-04 | Gentry | Missouri | 29075 | 2158 | 31 |
2370871 | 2370871 | 2022-04-03 | Gentry | Missouri | 29075 | 2158 | 31 |
2367618 | 2367618 | 2022-04-02 | Gentry | Missouri | 29075 | 2158 | 31 |
2364365 | 2364365 | 2022-04-01 | Gentry | Missouri | 29075 | 2158 | 31 |
2361111 | 2361111 | 2022-03-31 | Gentry | Missouri | 29075 | 2158 | 31 |
2305815 | 2305815 | 2022-03-14 | Howard | Missouri | 29089 | 2158 | 25 |
2133426 | 2133426 | 2022-01-20 | Douglas | Missouri | 29067 | 2158 | 68 |
1814899 | 1814899 | 2021-10-14 | Gasconade | Missouri | 29073 | 2158 | 49 |
1814931 | 1814931 | 2021-10-14 | Mississippi | Missouri | 29133 | 2158 | 39 |
1723916 | 1723916 | 2021-09-16 | Dallas | Missouri | 29059 | 2158 | 38 |
1590776 | 1590776 | 2021-08-06 | Morgan | Missouri | 29141 | 2158 | 46 |
1483599 | 1483599 | 2021-07-04 | Livingston | Missouri | 29117 | 2158 | 46 |
1480353 | 1480353 | 2021-07-03 | Livingston | Missouri | 29117 | 2158 | 46 |
1168706 | 1168706 | 2021-03-29 | Perry | Missouri | 29157 | 2158 | 29 |
1019304 | 1019304 | 2021-02-11 | Barry | Missouri | 29009 | 2158 | 43 |
827905 | 827905 | 2020-12-14 | Pulaski | Missouri | 29169 | 2158 | 24 |
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);