ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
693 rows where county = "Ozark" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497896 | 2497896 | 2022-05-12 | Ozark | Missouri | 29153 | 1732 | 57 |
2494638 | 2494638 | 2022-05-11 | Ozark | Missouri | 29153 | 1732 | 57 |
2491380 | 2491380 | 2022-05-10 | Ozark | Missouri | 29153 | 1732 | 57 |
2488122 | 2488122 | 2022-05-09 | Ozark | Missouri | 29153 | 1732 | 57 |
2484865 | 2484865 | 2022-05-08 | Ozark | Missouri | 29153 | 1732 | 57 |
2481607 | 2481607 | 2022-05-07 | Ozark | Missouri | 29153 | 1732 | 57 |
2478349 | 2478349 | 2022-05-06 | Ozark | Missouri | 29153 | 1732 | 57 |
2475091 | 2475091 | 2022-05-05 | Ozark | Missouri | 29153 | 1732 | 57 |
2471834 | 2471834 | 2022-05-04 | Ozark | Missouri | 29153 | 1710 | 55 |
2468578 | 2468578 | 2022-05-03 | Ozark | Missouri | 29153 | 1710 | 55 |
2465322 | 2465322 | 2022-05-02 | Ozark | Missouri | 29153 | 1710 | 55 |
2462067 | 2462067 | 2022-05-01 | Ozark | Missouri | 29153 | 1710 | 55 |
2458811 | 2458811 | 2022-04-30 | Ozark | Missouri | 29153 | 1710 | 55 |
2455555 | 2455555 | 2022-04-29 | Ozark | Missouri | 29153 | 1710 | 55 |
2452299 | 2452299 | 2022-04-28 | Ozark | Missouri | 29153 | 1710 | 55 |
2449043 | 2449043 | 2022-04-27 | Ozark | Missouri | 29153 | 1710 | 55 |
2445786 | 2445786 | 2022-04-26 | Ozark | Missouri | 29153 | 1710 | 55 |
2442531 | 2442531 | 2022-04-25 | Ozark | Missouri | 29153 | 1710 | 55 |
2439275 | 2439275 | 2022-04-24 | Ozark | Missouri | 29153 | 1710 | 55 |
2436019 | 2436019 | 2022-04-23 | Ozark | Missouri | 29153 | 1710 | 55 |
2432763 | 2432763 | 2022-04-22 | Ozark | Missouri | 29153 | 1710 | 55 |
2429507 | 2429507 | 2022-04-21 | Ozark | Missouri | 29153 | 1710 | 55 |
2426251 | 2426251 | 2022-04-20 | Ozark | Missouri | 29153 | 1710 | 55 |
2422995 | 2422995 | 2022-04-19 | Ozark | Missouri | 29153 | 1710 | 55 |
2419738 | 2419738 | 2022-04-18 | Ozark | Missouri | 29153 | 1710 | 55 |
2416483 | 2416483 | 2022-04-17 | Ozark | Missouri | 29153 | 1710 | 55 |
2413227 | 2413227 | 2022-04-16 | Ozark | Missouri | 29153 | 1710 | 55 |
2409971 | 2409971 | 2022-04-15 | Ozark | Missouri | 29153 | 1710 | 55 |
2406715 | 2406715 | 2022-04-14 | Ozark | Missouri | 29153 | 1710 | 55 |
2403459 | 2403459 | 2022-04-13 | Ozark | Missouri | 29153 | 1710 | 55 |
2400204 | 2400204 | 2022-04-12 | Ozark | Missouri | 29153 | 1710 | 55 |
2396949 | 2396949 | 2022-04-11 | Ozark | Missouri | 29153 | 1710 | 55 |
2393694 | 2393694 | 2022-04-10 | Ozark | Missouri | 29153 | 1710 | 55 |
2390438 | 2390438 | 2022-04-09 | Ozark | Missouri | 29153 | 1710 | 55 |
2387182 | 2387182 | 2022-04-08 | Ozark | Missouri | 29153 | 1710 | 55 |
2383927 | 2383927 | 2022-04-07 | Ozark | Missouri | 29153 | 1710 | 55 |
2380672 | 2380672 | 2022-04-06 | Ozark | Missouri | 29153 | 1710 | 55 |
2377417 | 2377417 | 2022-04-05 | Ozark | Missouri | 29153 | 1710 | 55 |
2374164 | 2374164 | 2022-04-04 | Ozark | Missouri | 29153 | 1710 | 55 |
2370912 | 2370912 | 2022-04-03 | Ozark | Missouri | 29153 | 1710 | 55 |
2367659 | 2367659 | 2022-04-02 | Ozark | Missouri | 29153 | 1710 | 55 |
2364406 | 2364406 | 2022-04-01 | Ozark | Missouri | 29153 | 1710 | 55 |
2361152 | 2361152 | 2022-03-31 | Ozark | Missouri | 29153 | 1710 | 55 |
2357898 | 2357898 | 2022-03-30 | Ozark | Missouri | 29153 | 1710 | 55 |
2354645 | 2354645 | 2022-03-29 | Ozark | Missouri | 29153 | 1710 | 55 |
2351392 | 2351392 | 2022-03-28 | Ozark | Missouri | 29153 | 1710 | 55 |
2348140 | 2348140 | 2022-03-27 | Ozark | Missouri | 29153 | 1709 | 55 |
2344887 | 2344887 | 2022-03-26 | Ozark | Missouri | 29153 | 1709 | 55 |
2341634 | 2341634 | 2022-03-25 | Ozark | Missouri | 29153 | 1709 | 55 |
2338381 | 2338381 | 2022-03-24 | Ozark | Missouri | 29153 | 1709 | 55 |
2335127 | 2335127 | 2022-03-23 | Ozark | Missouri | 29153 | 1705 | 55 |
2331873 | 2331873 | 2022-03-22 | Ozark | Missouri | 29153 | 1705 | 55 |
2328620 | 2328620 | 2022-03-21 | Ozark | Missouri | 29153 | 1701 | 55 |
2325368 | 2325368 | 2022-03-20 | Ozark | Missouri | 29153 | 1697 | 55 |
2322114 | 2322114 | 2022-03-19 | Ozark | Missouri | 29153 | 1697 | 55 |
2318860 | 2318860 | 2022-03-18 | Ozark | Missouri | 29153 | 1697 | 55 |
2315607 | 2315607 | 2022-03-17 | Ozark | Missouri | 29153 | 1697 | 55 |
2312354 | 2312354 | 2022-03-16 | Ozark | Missouri | 29153 | 1697 | 55 |
2309101 | 2309101 | 2022-03-15 | Ozark | Missouri | 29153 | 1696 | 55 |
2305849 | 2305849 | 2022-03-14 | Ozark | Missouri | 29153 | 1696 | 55 |
2302598 | 2302598 | 2022-03-13 | Ozark | Missouri | 29153 | 1697 | 55 |
2299346 | 2299346 | 2022-03-12 | Ozark | Missouri | 29153 | 1697 | 55 |
2296094 | 2296094 | 2022-03-11 | Ozark | Missouri | 29153 | 1697 | 55 |
2292842 | 2292842 | 2022-03-10 | Ozark | Missouri | 29153 | 1697 | 55 |
2289590 | 2289590 | 2022-03-09 | Ozark | Missouri | 29153 | 1697 | 55 |
2286338 | 2286338 | 2022-03-08 | Ozark | Missouri | 29153 | 1693 | 55 |
2283086 | 2283086 | 2022-03-07 | Ozark | Missouri | 29153 | 1692 | 55 |
2279833 | 2279833 | 2022-03-06 | Ozark | Missouri | 29153 | 1690 | 55 |
2276580 | 2276580 | 2022-03-05 | Ozark | Missouri | 29153 | 1690 | 55 |
2273327 | 2273327 | 2022-03-04 | Ozark | Missouri | 29153 | 1690 | 55 |
2270075 | 2270075 | 2022-03-03 | Ozark | Missouri | 29153 | 1690 | 55 |
2266822 | 2266822 | 2022-03-02 | Ozark | Missouri | 29153 | 1688 | 55 |
2263571 | 2263571 | 2022-03-01 | Ozark | Missouri | 29153 | 1684 | 55 |
2260320 | 2260320 | 2022-02-28 | Ozark | Missouri | 29153 | 1681 | 53 |
2257069 | 2257069 | 2022-02-27 | Ozark | Missouri | 29153 | 1680 | 53 |
2253818 | 2253818 | 2022-02-26 | Ozark | Missouri | 29153 | 1680 | 53 |
2250567 | 2250567 | 2022-02-25 | Ozark | Missouri | 29153 | 1680 | 53 |
2247316 | 2247316 | 2022-02-24 | Ozark | Missouri | 29153 | 1679 | 53 |
2244065 | 2244065 | 2022-02-23 | Ozark | Missouri | 29153 | 1675 | 48 |
2240814 | 2240814 | 2022-02-22 | Ozark | Missouri | 29153 | 1671 | 48 |
2237563 | 2237563 | 2022-02-21 | Ozark | Missouri | 29153 | 1664 | 48 |
2234312 | 2234312 | 2022-02-20 | Ozark | Missouri | 29153 | 1664 | 48 |
2231061 | 2231061 | 2022-02-19 | Ozark | Missouri | 29153 | 1664 | 48 |
2227810 | 2227810 | 2022-02-18 | Ozark | Missouri | 29153 | 1664 | 48 |
2224559 | 2224559 | 2022-02-17 | Ozark | Missouri | 29153 | 1663 | 48 |
2221308 | 2221308 | 2022-02-16 | Ozark | Missouri | 29153 | 1652 | 48 |
2218057 | 2218057 | 2022-02-15 | Ozark | Missouri | 29153 | 1649 | 48 |
2214806 | 2214806 | 2022-02-14 | Ozark | Missouri | 29153 | 1648 | 48 |
2211554 | 2211554 | 2022-02-13 | Ozark | Missouri | 29153 | 1643 | 48 |
2208301 | 2208301 | 2022-02-12 | Ozark | Missouri | 29153 | 1643 | 48 |
2205048 | 2205048 | 2022-02-11 | Ozark | Missouri | 29153 | 1643 | 48 |
2201795 | 2201795 | 2022-02-10 | Ozark | Missouri | 29153 | 1643 | 48 |
2198541 | 2198541 | 2022-02-09 | Ozark | Missouri | 29153 | 1637 | 48 |
2195287 | 2195287 | 2022-02-08 | Ozark | Missouri | 29153 | 1635 | 48 |
2192033 | 2192033 | 2022-02-07 | Ozark | Missouri | 29153 | 1631 | 48 |
2188780 | 2188780 | 2022-02-06 | Ozark | Missouri | 29153 | 1628 | 48 |
2185527 | 2185527 | 2022-02-05 | Ozark | Missouri | 29153 | 1626 | 48 |
2182275 | 2182275 | 2022-02-04 | Ozark | Missouri | 29153 | 1625 | 48 |
2179023 | 2179023 | 2022-02-03 | Ozark | Missouri | 29153 | 1617 | 48 |
2175771 | 2175771 | 2022-02-02 | Ozark | Missouri | 29153 | 1612 | 48 |
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);