ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
131 rows where deaths = 103 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501165 | 2501165 | 2022-05-13 | Randolph | Missouri | 29175 | 6058 | 103 |
2497907 | 2497907 | 2022-05-12 | Randolph | Missouri | 29175 | 6049 | 103 |
2494649 | 2494649 | 2022-05-11 | Randolph | Missouri | 29175 | 6049 | 103 |
2491391 | 2491391 | 2022-05-10 | Randolph | Missouri | 29175 | 6049 | 103 |
2488133 | 2488133 | 2022-05-09 | Randolph | Missouri | 29175 | 6049 | 103 |
2484876 | 2484876 | 2022-05-08 | Randolph | Missouri | 29175 | 6049 | 103 |
2481618 | 2481618 | 2022-05-07 | Randolph | Missouri | 29175 | 6049 | 103 |
2478360 | 2478360 | 2022-05-06 | Randolph | Missouri | 29175 | 6049 | 103 |
2475102 | 2475102 | 2022-05-05 | Randolph | Missouri | 29175 | 6033 | 103 |
2471763 | 2471763 | 2022-05-04 | Benton | Missouri | 29015 | 4179 | 103 |
2468507 | 2468507 | 2022-05-03 | Benton | Missouri | 29015 | 4179 | 103 |
2465251 | 2465251 | 2022-05-02 | Benton | Missouri | 29015 | 4179 | 103 |
2461996 | 2461996 | 2022-05-01 | Benton | Missouri | 29015 | 4179 | 103 |
2458740 | 2458740 | 2022-04-30 | Benton | Missouri | 29015 | 4179 | 103 |
2455484 | 2455484 | 2022-04-29 | Benton | Missouri | 29015 | 4179 | 103 |
2452228 | 2452228 | 2022-04-28 | Benton | Missouri | 29015 | 4179 | 103 |
2448972 | 2448972 | 2022-04-27 | Benton | Missouri | 29015 | 4179 | 103 |
2445715 | 2445715 | 2022-04-26 | Benton | Missouri | 29015 | 4179 | 103 |
2442460 | 2442460 | 2022-04-25 | Benton | Missouri | 29015 | 4179 | 103 |
2439204 | 2439204 | 2022-04-24 | Benton | Missouri | 29015 | 4179 | 103 |
2435948 | 2435948 | 2022-04-23 | Benton | Missouri | 29015 | 4179 | 103 |
2432692 | 2432692 | 2022-04-22 | Benton | Missouri | 29015 | 4179 | 103 |
2429436 | 2429436 | 2022-04-21 | Benton | Missouri | 29015 | 4179 | 103 |
2426180 | 2426180 | 2022-04-20 | Benton | Missouri | 29015 | 4179 | 103 |
2422924 | 2422924 | 2022-04-19 | Benton | Missouri | 29015 | 4179 | 103 |
2419667 | 2419667 | 2022-04-18 | Benton | Missouri | 29015 | 4179 | 103 |
2416412 | 2416412 | 2022-04-17 | Benton | Missouri | 29015 | 4179 | 103 |
2413156 | 2413156 | 2022-04-16 | Benton | Missouri | 29015 | 4179 | 103 |
2409900 | 2409900 | 2022-04-15 | Benton | Missouri | 29015 | 4179 | 103 |
2406644 | 2406644 | 2022-04-14 | Benton | Missouri | 29015 | 4179 | 103 |
2403388 | 2403388 | 2022-04-13 | Benton | Missouri | 29015 | 4179 | 103 |
2400133 | 2400133 | 2022-04-12 | Benton | Missouri | 29015 | 4179 | 103 |
2396878 | 2396878 | 2022-04-11 | Benton | Missouri | 29015 | 4179 | 103 |
2393623 | 2393623 | 2022-04-10 | Benton | Missouri | 29015 | 4179 | 103 |
2390367 | 2390367 | 2022-04-09 | Benton | Missouri | 29015 | 4179 | 103 |
2387111 | 2387111 | 2022-04-08 | Benton | Missouri | 29015 | 4179 | 103 |
2383856 | 2383856 | 2022-04-07 | Benton | Missouri | 29015 | 4179 | 103 |
2380601 | 2380601 | 2022-04-06 | Benton | Missouri | 29015 | 4179 | 103 |
2377346 | 2377346 | 2022-04-05 | Benton | Missouri | 29015 | 4179 | 103 |
2374093 | 2374093 | 2022-04-04 | Benton | Missouri | 29015 | 4179 | 103 |
2370841 | 2370841 | 2022-04-03 | Benton | Missouri | 29015 | 4179 | 103 |
2367588 | 2367588 | 2022-04-02 | Benton | Missouri | 29015 | 4179 | 103 |
2364335 | 2364335 | 2022-04-01 | Benton | Missouri | 29015 | 4179 | 103 |
2361081 | 2361081 | 2022-03-31 | Benton | Missouri | 29015 | 4179 | 103 |
2357827 | 2357827 | 2022-03-30 | Benton | Missouri | 29015 | 4180 | 103 |
2354574 | 2354574 | 2022-03-29 | Benton | Missouri | 29015 | 4177 | 103 |
2305856 | 2305856 | 2022-03-14 | Polk | Missouri | 29167 | 8009 | 103 |
2305881 | 2305881 | 2022-03-14 | Vernon | Missouri | 29217 | 5039 | 103 |
2302605 | 2302605 | 2022-03-13 | Polk | Missouri | 29167 | 8007 | 103 |
2302630 | 2302630 | 2022-03-13 | Vernon | Missouri | 29217 | 5037 | 103 |
2299353 | 2299353 | 2022-03-12 | Polk | Missouri | 29167 | 8007 | 103 |
2299378 | 2299378 | 2022-03-12 | Vernon | Missouri | 29217 | 5037 | 103 |
2296101 | 2296101 | 2022-03-11 | Polk | Missouri | 29167 | 8007 | 103 |
2296126 | 2296126 | 2022-03-11 | Vernon | Missouri | 29217 | 5037 | 103 |
2292849 | 2292849 | 2022-03-10 | Polk | Missouri | 29167 | 8006 | 103 |
2289597 | 2289597 | 2022-03-09 | Polk | Missouri | 29167 | 8005 | 103 |
2286345 | 2286345 | 2022-03-08 | Polk | Missouri | 29167 | 8005 | 103 |
2283093 | 2283093 | 2022-03-07 | Polk | Missouri | 29167 | 8001 | 103 |
2279840 | 2279840 | 2022-03-06 | Polk | Missouri | 29167 | 7998 | 103 |
2276587 | 2276587 | 2022-03-05 | Polk | Missouri | 29167 | 7998 | 103 |
2273334 | 2273334 | 2022-03-04 | Polk | Missouri | 29167 | 7998 | 103 |
2270082 | 2270082 | 2022-03-03 | Polk | Missouri | 29167 | 7998 | 103 |
2266829 | 2266829 | 2022-03-02 | Polk | Missouri | 29167 | 7997 | 103 |
2263578 | 2263578 | 2022-03-01 | Polk | Missouri | 29167 | 7995 | 103 |
2260327 | 2260327 | 2022-02-28 | Polk | Missouri | 29167 | 7995 | 103 |
2130195 | 2130195 | 2022-01-19 | Lafayette | Missouri | 29107 | 6724 | 103 |
1873404 | 1873404 | 2021-11-01 | Lawrence | Missouri | 29109 | 5201 | 103 |
1870155 | 1870155 | 2021-10-31 | Lawrence | Missouri | 29109 | 5200 | 103 |
1866906 | 1866906 | 2021-10-30 | Lawrence | Missouri | 29109 | 5200 | 103 |
1863682 | 1863682 | 2021-10-29 | Pettis | Missouri | 29159 | 7363 | 103 |
1860433 | 1860433 | 2021-10-28 | Pettis | Missouri | 29159 | 7343 | 103 |
1857184 | 1857184 | 2021-10-27 | Pettis | Missouri | 29159 | 7331 | 103 |
1853935 | 1853935 | 2021-10-26 | Pettis | Missouri | 29159 | 7323 | 103 |
1850686 | 1850686 | 2021-10-25 | Pettis | Missouri | 29159 | 7298 | 103 |
1847436 | 1847436 | 2021-10-24 | Pettis | Missouri | 29159 | 7294 | 103 |
1844186 | 1844186 | 2021-10-23 | Pettis | Missouri | 29159 | 7294 | 103 |
1840936 | 1840936 | 2021-10-22 | Pettis | Missouri | 29159 | 7290 | 103 |
1837687 | 1837687 | 2021-10-21 | Pettis | Missouri | 29159 | 7284 | 103 |
1834438 | 1834438 | 2021-10-20 | Pettis | Missouri | 29159 | 7266 | 103 |
1831189 | 1831189 | 2021-10-19 | Pettis | Missouri | 29159 | 7264 | 103 |
1743480 | 1743480 | 2021-09-22 | Scott | Missouri | 29201 | 6757 | 103 |
1740231 | 1740231 | 2021-09-21 | Scott | Missouri | 29201 | 6732 | 103 |
1554992 | 1554992 | 2021-07-26 | Christian | Missouri | 29043 | 11158 | 103 |
1551745 | 1551745 | 2021-07-25 | Christian | Missouri | 29043 | 11158 | 103 |
1548498 | 1548498 | 2021-07-24 | Christian | Missouri | 29043 | 11158 | 103 |
1545251 | 1545251 | 2021-07-23 | Christian | Missouri | 29043 | 11158 | 103 |
1542003 | 1542003 | 2021-07-22 | Christian | Missouri | 29043 | 10676 | 103 |
1538756 | 1538756 | 2021-07-21 | Christian | Missouri | 29043 | 10676 | 103 |
1535509 | 1535509 | 2021-07-20 | Christian | Missouri | 29043 | 10676 | 103 |
1499880 | 1499880 | 2021-07-09 | Taney | Missouri | 29213 | 6392 | 103 |
1496634 | 1496634 | 2021-07-08 | Taney | Missouri | 29213 | 6322 | 103 |
1493387 | 1493387 | 2021-07-07 | Taney | Missouri | 29213 | 6290 | 103 |
1162181 | 1162181 | 2021-03-27 | Joplin | Missouri | 5946 | 103 | |
1158933 | 1158933 | 2021-03-26 | Joplin | Missouri | 5942 | 103 | |
1155686 | 1155686 | 2021-03-25 | Joplin | Missouri | 5941 | 103 | |
1152439 | 1152439 | 2021-03-24 | Joplin | Missouri | 5939 | 103 | |
1149192 | 1149192 | 2021-03-23 | Joplin | Missouri | 5935 | 103 | |
1145945 | 1145945 | 2021-03-22 | Joplin | Missouri | 5929 | 103 | |
1142698 | 1142698 | 2021-03-21 | Joplin | Missouri | 5927 | 103 | |
1139451 | 1139451 | 2021-03-20 | Joplin | Missouri | 5928 | 103 |
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);