ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
304 rows where deaths = 62 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471756 | 2471756 | 2022-05-04 | Adair | Missouri | 29001 | 6095 | 62 |
2468500 | 2468500 | 2022-05-03 | Adair | Missouri | 29001 | 6095 | 62 |
2465244 | 2465244 | 2022-05-02 | Adair | Missouri | 29001 | 6095 | 62 |
2461989 | 2461989 | 2022-05-01 | Adair | Missouri | 29001 | 6095 | 62 |
2458733 | 2458733 | 2022-04-30 | Adair | Missouri | 29001 | 6095 | 62 |
2455477 | 2455477 | 2022-04-29 | Adair | Missouri | 29001 | 6095 | 62 |
2452221 | 2452221 | 2022-04-28 | Adair | Missouri | 29001 | 6095 | 62 |
2448965 | 2448965 | 2022-04-27 | Adair | Missouri | 29001 | 6095 | 62 |
2445708 | 2445708 | 2022-04-26 | Adair | Missouri | 29001 | 6095 | 62 |
2442453 | 2442453 | 2022-04-25 | Adair | Missouri | 29001 | 6086 | 62 |
2439197 | 2439197 | 2022-04-24 | Adair | Missouri | 29001 | 6086 | 62 |
2435941 | 2435941 | 2022-04-23 | Adair | Missouri | 29001 | 6086 | 62 |
2432685 | 2432685 | 2022-04-22 | Adair | Missouri | 29001 | 6086 | 62 |
2429429 | 2429429 | 2022-04-21 | Adair | Missouri | 29001 | 6086 | 62 |
2426173 | 2426173 | 2022-04-20 | Adair | Missouri | 29001 | 6086 | 62 |
2422917 | 2422917 | 2022-04-19 | Adair | Missouri | 29001 | 6086 | 62 |
2419660 | 2419660 | 2022-04-18 | Adair | Missouri | 29001 | 6071 | 62 |
2416405 | 2416405 | 2022-04-17 | Adair | Missouri | 29001 | 6071 | 62 |
2413149 | 2413149 | 2022-04-16 | Adair | Missouri | 29001 | 6071 | 62 |
2409893 | 2409893 | 2022-04-15 | Adair | Missouri | 29001 | 6071 | 62 |
2406637 | 2406637 | 2022-04-14 | Adair | Missouri | 29001 | 6071 | 62 |
2403381 | 2403381 | 2022-04-13 | Adair | Missouri | 29001 | 6071 | 62 |
2400126 | 2400126 | 2022-04-12 | Adair | Missouri | 29001 | 6071 | 62 |
2396871 | 2396871 | 2022-04-11 | Adair | Missouri | 29001 | 6071 | 62 |
2393616 | 2393616 | 2022-04-10 | Adair | Missouri | 29001 | 6062 | 62 |
2390360 | 2390360 | 2022-04-09 | Adair | Missouri | 29001 | 6062 | 62 |
2387104 | 2387104 | 2022-04-08 | Adair | Missouri | 29001 | 6062 | 62 |
2383849 | 2383849 | 2022-04-07 | Adair | Missouri | 29001 | 6062 | 62 |
2380594 | 2380594 | 2022-04-06 | Adair | Missouri | 29001 | 6062 | 62 |
2377339 | 2377339 | 2022-04-05 | Adair | Missouri | 29001 | 6054 | 62 |
2374086 | 2374086 | 2022-04-04 | Adair | Missouri | 29001 | 6054 | 62 |
2370834 | 2370834 | 2022-04-03 | Adair | Missouri | 29001 | 6054 | 62 |
2367581 | 2367581 | 2022-04-02 | Adair | Missouri | 29001 | 6054 | 62 |
2364328 | 2364328 | 2022-04-01 | Adair | Missouri | 29001 | 6054 | 62 |
2361074 | 2361074 | 2022-03-31 | Adair | Missouri | 29001 | 6054 | 62 |
2357820 | 2357820 | 2022-03-30 | Adair | Missouri | 29001 | 6054 | 62 |
2354567 | 2354567 | 2022-03-29 | Adair | Missouri | 29001 | 6054 | 62 |
2351314 | 2351314 | 2022-03-28 | Adair | Missouri | 29001 | 6047 | 62 |
2348062 | 2348062 | 2022-03-27 | Adair | Missouri | 29001 | 6047 | 62 |
2344809 | 2344809 | 2022-03-26 | Adair | Missouri | 29001 | 6047 | 62 |
2341556 | 2341556 | 2022-03-25 | Adair | Missouri | 29001 | 6047 | 62 |
2338303 | 2338303 | 2022-03-24 | Adair | Missouri | 29001 | 6047 | 62 |
2335049 | 2335049 | 2022-03-23 | Adair | Missouri | 29001 | 6047 | 62 |
2331795 | 2331795 | 2022-03-22 | Adair | Missouri | 29001 | 6047 | 62 |
2305830 | 2305830 | 2022-03-14 | Linn | Missouri | 29115 | 2537 | 62 |
2302579 | 2302579 | 2022-03-13 | Linn | Missouri | 29115 | 2537 | 62 |
2299327 | 2299327 | 2022-03-12 | Linn | Missouri | 29115 | 2537 | 62 |
2296075 | 2296075 | 2022-03-11 | Linn | Missouri | 29115 | 2537 | 62 |
2292823 | 2292823 | 2022-03-10 | Linn | Missouri | 29115 | 2534 | 62 |
2289571 | 2289571 | 2022-03-09 | Linn | Missouri | 29115 | 2530 | 62 |
2286319 | 2286319 | 2022-03-08 | Linn | Missouri | 29115 | 2523 | 62 |
2283067 | 2283067 | 2022-03-07 | Linn | Missouri | 29115 | 2521 | 62 |
2279814 | 2279814 | 2022-03-06 | Linn | Missouri | 29115 | 2514 | 62 |
2276561 | 2276561 | 2022-03-05 | Linn | Missouri | 29115 | 2514 | 62 |
2273308 | 2273308 | 2022-03-04 | Linn | Missouri | 29115 | 2514 | 62 |
2270056 | 2270056 | 2022-03-03 | Linn | Missouri | 29115 | 2510 | 62 |
2266803 | 2266803 | 2022-03-02 | Linn | Missouri | 29115 | 2501 | 62 |
2263552 | 2263552 | 2022-03-01 | Linn | Missouri | 29115 | 2498 | 62 |
2260301 | 2260301 | 2022-02-28 | Linn | Missouri | 29115 | 2496 | 62 |
2257050 | 2257050 | 2022-02-27 | Linn | Missouri | 29115 | 2494 | 62 |
2253799 | 2253799 | 2022-02-26 | Linn | Missouri | 29115 | 2494 | 62 |
2250548 | 2250548 | 2022-02-25 | Linn | Missouri | 29115 | 2494 | 62 |
2247297 | 2247297 | 2022-02-24 | Linn | Missouri | 29115 | 2498 | 62 |
2244046 | 2244046 | 2022-02-23 | Linn | Missouri | 29115 | 2349 | 62 |
2240795 | 2240795 | 2022-02-22 | Linn | Missouri | 29115 | 2345 | 62 |
2237544 | 2237544 | 2022-02-21 | Linn | Missouri | 29115 | 2336 | 62 |
2234293 | 2234293 | 2022-02-20 | Linn | Missouri | 29115 | 2336 | 62 |
2231042 | 2231042 | 2022-02-19 | Linn | Missouri | 29115 | 2336 | 62 |
2227791 | 2227791 | 2022-02-18 | Linn | Missouri | 29115 | 2336 | 62 |
2224540 | 2224540 | 2022-02-17 | Linn | Missouri | 29115 | 2333 | 62 |
2221289 | 2221289 | 2022-02-16 | Linn | Missouri | 29115 | 2332 | 62 |
2218038 | 2218038 | 2022-02-15 | Linn | Missouri | 29115 | 2331 | 62 |
2214767 | 2214767 | 2022-02-14 | Grundy | Missouri | 29079 | 2316 | 62 |
2211515 | 2211515 | 2022-02-13 | Grundy | Missouri | 29079 | 2289 | 62 |
2208262 | 2208262 | 2022-02-12 | Grundy | Missouri | 29079 | 2289 | 62 |
2205009 | 2205009 | 2022-02-11 | Grundy | Missouri | 29079 | 2289 | 62 |
2201756 | 2201756 | 2022-02-10 | Grundy | Missouri | 29079 | 2289 | 62 |
2198502 | 2198502 | 2022-02-09 | Grundy | Missouri | 29079 | 2280 | 62 |
2195248 | 2195248 | 2022-02-08 | Grundy | Missouri | 29079 | 2265 | 62 |
2191994 | 2191994 | 2022-02-07 | Grundy | Missouri | 29079 | 2257 | 62 |
2188741 | 2188741 | 2022-02-06 | Grundy | Missouri | 29079 | 2255 | 62 |
2185488 | 2185488 | 2022-02-05 | Grundy | Missouri | 29079 | 2248 | 62 |
2182236 | 2182236 | 2022-02-04 | Grundy | Missouri | 29079 | 2237 | 62 |
2178984 | 2178984 | 2022-02-03 | Grundy | Missouri | 29079 | 2223 | 62 |
2169266 | 2169266 | 2022-01-31 | Pemiscot | Missouri | 29155 | 2824 | 62 |
2133422 | 2133422 | 2022-01-20 | Dallas | Missouri | 29059 | 3201 | 62 |
2130169 | 2130169 | 2022-01-19 | Dallas | Missouri | 29059 | 3138 | 62 |
2126915 | 2126915 | 2022-01-18 | Dallas | Missouri | 29059 | 3074 | 62 |
2123663 | 2123663 | 2022-01-17 | Dallas | Missouri | 29059 | 3024 | 62 |
2120411 | 2120411 | 2022-01-16 | Dallas | Missouri | 29059 | 3024 | 62 |
2117159 | 2117159 | 2022-01-15 | Dallas | Missouri | 29059 | 3024 | 62 |
2113908 | 2113908 | 2022-01-14 | Dallas | Missouri | 29059 | 2981 | 62 |
2110656 | 2110656 | 2022-01-13 | Dallas | Missouri | 29059 | 2948 | 62 |
2107405 | 2107405 | 2022-01-12 | Dallas | Missouri | 29059 | 2912 | 62 |
2104154 | 2104154 | 2022-01-11 | Dallas | Missouri | 29059 | 2883 | 62 |
2100903 | 2100903 | 2022-01-10 | Dallas | Missouri | 29059 | 2864 | 62 |
2097652 | 2097652 | 2022-01-09 | Dallas | Missouri | 29059 | 2860 | 62 |
2094400 | 2094400 | 2022-01-08 | Dallas | Missouri | 29059 | 2852 | 62 |
2091148 | 2091148 | 2022-01-07 | Dallas | Missouri | 29059 | 2826 | 62 |
2087897 | 2087897 | 2022-01-06 | Dallas | Missouri | 29059 | 2799 | 62 |
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);