ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "McDonald" and fips = 29119 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501141 | 2501141 | 2022-05-13 | McDonald | Missouri | 29119 | 5813 | 73 |
2497883 | 2497883 | 2022-05-12 | McDonald | Missouri | 29119 | 5809 | 73 |
2494625 | 2494625 | 2022-05-11 | McDonald | Missouri | 29119 | 5809 | 73 |
2491367 | 2491367 | 2022-05-10 | McDonald | Missouri | 29119 | 5809 | 73 |
2488109 | 2488109 | 2022-05-09 | McDonald | Missouri | 29119 | 5809 | 73 |
2484852 | 2484852 | 2022-05-08 | McDonald | Missouri | 29119 | 5809 | 73 |
2481594 | 2481594 | 2022-05-07 | McDonald | Missouri | 29119 | 5809 | 73 |
2478336 | 2478336 | 2022-05-06 | McDonald | Missouri | 29119 | 5809 | 73 |
2475078 | 2475078 | 2022-05-05 | McDonald | Missouri | 29119 | 5806 | 73 |
2471821 | 2471821 | 2022-05-04 | McDonald | Missouri | 29119 | 5806 | 71 |
2468565 | 2468565 | 2022-05-03 | McDonald | Missouri | 29119 | 5806 | 71 |
2465309 | 2465309 | 2022-05-02 | McDonald | Missouri | 29119 | 5806 | 71 |
2462054 | 2462054 | 2022-05-01 | McDonald | Missouri | 29119 | 5806 | 71 |
2458798 | 2458798 | 2022-04-30 | McDonald | Missouri | 29119 | 5806 | 71 |
2455542 | 2455542 | 2022-04-29 | McDonald | Missouri | 29119 | 5796 | 71 |
2452286 | 2452286 | 2022-04-28 | McDonald | Missouri | 29119 | 5796 | 71 |
2449030 | 2449030 | 2022-04-27 | McDonald | Missouri | 29119 | 5796 | 71 |
2445773 | 2445773 | 2022-04-26 | McDonald | Missouri | 29119 | 5796 | 71 |
2442518 | 2442518 | 2022-04-25 | McDonald | Missouri | 29119 | 5796 | 71 |
2439262 | 2439262 | 2022-04-24 | McDonald | Missouri | 29119 | 5796 | 71 |
2436006 | 2436006 | 2022-04-23 | McDonald | Missouri | 29119 | 5796 | 71 |
2432750 | 2432750 | 2022-04-22 | McDonald | Missouri | 29119 | 5796 | 71 |
2429494 | 2429494 | 2022-04-21 | McDonald | Missouri | 29119 | 5795 | 71 |
2426238 | 2426238 | 2022-04-20 | McDonald | Missouri | 29119 | 5795 | 71 |
2422982 | 2422982 | 2022-04-19 | McDonald | Missouri | 29119 | 5795 | 71 |
2419725 | 2419725 | 2022-04-18 | McDonald | Missouri | 29119 | 5795 | 71 |
2416470 | 2416470 | 2022-04-17 | McDonald | Missouri | 29119 | 5795 | 71 |
2413214 | 2413214 | 2022-04-16 | McDonald | Missouri | 29119 | 5795 | 71 |
2409958 | 2409958 | 2022-04-15 | McDonald | Missouri | 29119 | 5795 | 71 |
2406702 | 2406702 | 2022-04-14 | McDonald | Missouri | 29119 | 5795 | 71 |
2403446 | 2403446 | 2022-04-13 | McDonald | Missouri | 29119 | 5795 | 71 |
2400191 | 2400191 | 2022-04-12 | McDonald | Missouri | 29119 | 5795 | 71 |
2396936 | 2396936 | 2022-04-11 | McDonald | Missouri | 29119 | 5795 | 71 |
2393681 | 2393681 | 2022-04-10 | McDonald | Missouri | 29119 | 5795 | 71 |
2390425 | 2390425 | 2022-04-09 | McDonald | Missouri | 29119 | 5795 | 71 |
2387169 | 2387169 | 2022-04-08 | McDonald | Missouri | 29119 | 5795 | 71 |
2383914 | 2383914 | 2022-04-07 | McDonald | Missouri | 29119 | 5790 | 67 |
2380659 | 2380659 | 2022-04-06 | McDonald | Missouri | 29119 | 5790 | 67 |
2377404 | 2377404 | 2022-04-05 | McDonald | Missouri | 29119 | 5790 | 67 |
2374151 | 2374151 | 2022-04-04 | McDonald | Missouri | 29119 | 5790 | 67 |
2370899 | 2370899 | 2022-04-03 | McDonald | Missouri | 29119 | 5790 | 67 |
2367646 | 2367646 | 2022-04-02 | McDonald | Missouri | 29119 | 5790 | 67 |
2364393 | 2364393 | 2022-04-01 | McDonald | Missouri | 29119 | 5790 | 67 |
2361139 | 2361139 | 2022-03-31 | McDonald | Missouri | 29119 | 5790 | 67 |
2357885 | 2357885 | 2022-03-30 | McDonald | Missouri | 29119 | 5790 | 67 |
2354632 | 2354632 | 2022-03-29 | McDonald | Missouri | 29119 | 5790 | 67 |
2351379 | 2351379 | 2022-03-28 | McDonald | Missouri | 29119 | 5790 | 67 |
2348127 | 2348127 | 2022-03-27 | McDonald | Missouri | 29119 | 5790 | 67 |
2344874 | 2344874 | 2022-03-26 | McDonald | Missouri | 29119 | 5790 | 67 |
2341621 | 2341621 | 2022-03-25 | McDonald | Missouri | 29119 | 5790 | 67 |
2338368 | 2338368 | 2022-03-24 | McDonald | Missouri | 29119 | 5790 | 67 |
2335114 | 2335114 | 2022-03-23 | McDonald | Missouri | 29119 | 5790 | 67 |
2331860 | 2331860 | 2022-03-22 | McDonald | Missouri | 29119 | 5787 | 67 |
2328607 | 2328607 | 2022-03-21 | McDonald | Missouri | 29119 | 5782 | 66 |
2325355 | 2325355 | 2022-03-20 | McDonald | Missouri | 29119 | 5782 | 66 |
2322101 | 2322101 | 2022-03-19 | McDonald | Missouri | 29119 | 5782 | 66 |
2318847 | 2318847 | 2022-03-18 | McDonald | Missouri | 29119 | 5782 | 66 |
2315594 | 2315594 | 2022-03-17 | McDonald | Missouri | 29119 | 5781 | 66 |
2312341 | 2312341 | 2022-03-16 | McDonald | Missouri | 29119 | 5781 | 66 |
2309088 | 2309088 | 2022-03-15 | McDonald | Missouri | 29119 | 5781 | 66 |
2305836 | 2305836 | 2022-03-14 | McDonald | Missouri | 29119 | 5781 | 66 |
2302585 | 2302585 | 2022-03-13 | McDonald | Missouri | 29119 | 5779 | 66 |
2299333 | 2299333 | 2022-03-12 | McDonald | Missouri | 29119 | 5779 | 66 |
2296081 | 2296081 | 2022-03-11 | McDonald | Missouri | 29119 | 5779 | 66 |
2292829 | 2292829 | 2022-03-10 | McDonald | Missouri | 29119 | 5779 | 66 |
2289577 | 2289577 | 2022-03-09 | McDonald | Missouri | 29119 | 5775 | 66 |
2286325 | 2286325 | 2022-03-08 | McDonald | Missouri | 29119 | 5774 | 66 |
2283073 | 2283073 | 2022-03-07 | McDonald | Missouri | 29119 | 5772 | 66 |
2279820 | 2279820 | 2022-03-06 | McDonald | Missouri | 29119 | 5772 | 66 |
2276567 | 2276567 | 2022-03-05 | McDonald | Missouri | 29119 | 5772 | 66 |
2273314 | 2273314 | 2022-03-04 | McDonald | Missouri | 29119 | 5772 | 66 |
2270062 | 2270062 | 2022-03-03 | McDonald | Missouri | 29119 | 5770 | 66 |
2266809 | 2266809 | 2022-03-02 | McDonald | Missouri | 29119 | 5768 | 66 |
2263558 | 2263558 | 2022-03-01 | McDonald | Missouri | 29119 | 5765 | 66 |
2260307 | 2260307 | 2022-02-28 | McDonald | Missouri | 29119 | 5765 | 66 |
2257056 | 2257056 | 2022-02-27 | McDonald | Missouri | 29119 | 5761 | 66 |
2253805 | 2253805 | 2022-02-26 | McDonald | Missouri | 29119 | 5761 | 66 |
2250554 | 2250554 | 2022-02-25 | McDonald | Missouri | 29119 | 5761 | 66 |
2247303 | 2247303 | 2022-02-24 | McDonald | Missouri | 29119 | 5751 | 66 |
2244052 | 2244052 | 2022-02-23 | McDonald | Missouri | 29119 | 5751 | 64 |
2240801 | 2240801 | 2022-02-22 | McDonald | Missouri | 29119 | 5751 | 64 |
2237550 | 2237550 | 2022-02-21 | McDonald | Missouri | 29119 | 5738 | 64 |
2234299 | 2234299 | 2022-02-20 | McDonald | Missouri | 29119 | 5738 | 64 |
2231048 | 2231048 | 2022-02-19 | McDonald | Missouri | 29119 | 5738 | 64 |
2227797 | 2227797 | 2022-02-18 | McDonald | Missouri | 29119 | 5738 | 64 |
2224546 | 2224546 | 2022-02-17 | McDonald | Missouri | 29119 | 5733 | 64 |
2221295 | 2221295 | 2022-02-16 | McDonald | Missouri | 29119 | 5730 | 64 |
2218044 | 2218044 | 2022-02-15 | McDonald | Missouri | 29119 | 5724 | 64 |
2214793 | 2214793 | 2022-02-14 | McDonald | Missouri | 29119 | 5710 | 64 |
2211541 | 2211541 | 2022-02-13 | McDonald | Missouri | 29119 | 5592 | 64 |
2208288 | 2208288 | 2022-02-12 | McDonald | Missouri | 29119 | 5592 | 64 |
2205035 | 2205035 | 2022-02-11 | McDonald | Missouri | 29119 | 5592 | 64 |
2201782 | 2201782 | 2022-02-10 | McDonald | Missouri | 29119 | 5592 | 64 |
2198528 | 2198528 | 2022-02-09 | McDonald | Missouri | 29119 | 5592 | 64 |
2195274 | 2195274 | 2022-02-08 | McDonald | Missouri | 29119 | 5558 | 64 |
2192020 | 2192020 | 2022-02-07 | McDonald | Missouri | 29119 | 5543 | 64 |
2188767 | 2188767 | 2022-02-06 | McDonald | Missouri | 29119 | 5524 | 64 |
2185514 | 2185514 | 2022-02-05 | McDonald | Missouri | 29119 | 5524 | 64 |
2182262 | 2182262 | 2022-02-04 | McDonald | Missouri | 29119 | 5524 | 64 |
2179010 | 2179010 | 2022-02-03 | McDonald | Missouri | 29119 | 5497 | 64 |
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);