ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "New Madrid", fips = 29143 and state = "Missouri" 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 |
---|---|---|---|---|---|---|---|
2501149 | 2501149 | 2022-05-13 | New Madrid | Missouri | 29143 | 5036 | 86 |
2497891 | 2497891 | 2022-05-12 | New Madrid | Missouri | 29143 | 5029 | 86 |
2494633 | 2494633 | 2022-05-11 | New Madrid | Missouri | 29143 | 5029 | 86 |
2491375 | 2491375 | 2022-05-10 | New Madrid | Missouri | 29143 | 5029 | 86 |
2488117 | 2488117 | 2022-05-09 | New Madrid | Missouri | 29143 | 5029 | 86 |
2484860 | 2484860 | 2022-05-08 | New Madrid | Missouri | 29143 | 5029 | 86 |
2481602 | 2481602 | 2022-05-07 | New Madrid | Missouri | 29143 | 5029 | 86 |
2478344 | 2478344 | 2022-05-06 | New Madrid | Missouri | 29143 | 5029 | 86 |
2475086 | 2475086 | 2022-05-05 | New Madrid | Missouri | 29143 | 5030 | 86 |
2471829 | 2471829 | 2022-05-04 | New Madrid | Missouri | 29143 | 5030 | 85 |
2468573 | 2468573 | 2022-05-03 | New Madrid | Missouri | 29143 | 5030 | 85 |
2465317 | 2465317 | 2022-05-02 | New Madrid | Missouri | 29143 | 5030 | 85 |
2462062 | 2462062 | 2022-05-01 | New Madrid | Missouri | 29143 | 5030 | 85 |
2458806 | 2458806 | 2022-04-30 | New Madrid | Missouri | 29143 | 5030 | 85 |
2455550 | 2455550 | 2022-04-29 | New Madrid | Missouri | 29143 | 5030 | 85 |
2452294 | 2452294 | 2022-04-28 | New Madrid | Missouri | 29143 | 5030 | 85 |
2449038 | 2449038 | 2022-04-27 | New Madrid | Missouri | 29143 | 5030 | 85 |
2445781 | 2445781 | 2022-04-26 | New Madrid | Missouri | 29143 | 5030 | 85 |
2442526 | 2442526 | 2022-04-25 | New Madrid | Missouri | 29143 | 5030 | 85 |
2439270 | 2439270 | 2022-04-24 | New Madrid | Missouri | 29143 | 5030 | 85 |
2436014 | 2436014 | 2022-04-23 | New Madrid | Missouri | 29143 | 5030 | 85 |
2432758 | 2432758 | 2022-04-22 | New Madrid | Missouri | 29143 | 5030 | 85 |
2429502 | 2429502 | 2022-04-21 | New Madrid | Missouri | 29143 | 5030 | 85 |
2426246 | 2426246 | 2022-04-20 | New Madrid | Missouri | 29143 | 5030 | 85 |
2422990 | 2422990 | 2022-04-19 | New Madrid | Missouri | 29143 | 5030 | 85 |
2419733 | 2419733 | 2022-04-18 | New Madrid | Missouri | 29143 | 5030 | 85 |
2416478 | 2416478 | 2022-04-17 | New Madrid | Missouri | 29143 | 5030 | 85 |
2413222 | 2413222 | 2022-04-16 | New Madrid | Missouri | 29143 | 5030 | 85 |
2409966 | 2409966 | 2022-04-15 | New Madrid | Missouri | 29143 | 5030 | 85 |
2406710 | 2406710 | 2022-04-14 | New Madrid | Missouri | 29143 | 5030 | 85 |
2403454 | 2403454 | 2022-04-13 | New Madrid | Missouri | 29143 | 5030 | 85 |
2400199 | 2400199 | 2022-04-12 | New Madrid | Missouri | 29143 | 5030 | 85 |
2396944 | 2396944 | 2022-04-11 | New Madrid | Missouri | 29143 | 5030 | 85 |
2393689 | 2393689 | 2022-04-10 | New Madrid | Missouri | 29143 | 5030 | 85 |
2390433 | 2390433 | 2022-04-09 | New Madrid | Missouri | 29143 | 5030 | 85 |
2387177 | 2387177 | 2022-04-08 | New Madrid | Missouri | 29143 | 5030 | 85 |
2383922 | 2383922 | 2022-04-07 | New Madrid | Missouri | 29143 | 5030 | 85 |
2380667 | 2380667 | 2022-04-06 | New Madrid | Missouri | 29143 | 5030 | 85 |
2377412 | 2377412 | 2022-04-05 | New Madrid | Missouri | 29143 | 5030 | 85 |
2374159 | 2374159 | 2022-04-04 | New Madrid | Missouri | 29143 | 5030 | 85 |
2370907 | 2370907 | 2022-04-03 | New Madrid | Missouri | 29143 | 5030 | 85 |
2367654 | 2367654 | 2022-04-02 | New Madrid | Missouri | 29143 | 5030 | 85 |
2364401 | 2364401 | 2022-04-01 | New Madrid | Missouri | 29143 | 5030 | 85 |
2361147 | 2361147 | 2022-03-31 | New Madrid | Missouri | 29143 | 5030 | 85 |
2357893 | 2357893 | 2022-03-30 | New Madrid | Missouri | 29143 | 5028 | 85 |
2354640 | 2354640 | 2022-03-29 | New Madrid | Missouri | 29143 | 5028 | 85 |
2351387 | 2351387 | 2022-03-28 | New Madrid | Missouri | 29143 | 5028 | 85 |
2348135 | 2348135 | 2022-03-27 | New Madrid | Missouri | 29143 | 5028 | 85 |
2344882 | 2344882 | 2022-03-26 | New Madrid | Missouri | 29143 | 5028 | 85 |
2341629 | 2341629 | 2022-03-25 | New Madrid | Missouri | 29143 | 5028 | 85 |
2338376 | 2338376 | 2022-03-24 | New Madrid | Missouri | 29143 | 5023 | 85 |
2335122 | 2335122 | 2022-03-23 | New Madrid | Missouri | 29143 | 5022 | 85 |
2331868 | 2331868 | 2022-03-22 | New Madrid | Missouri | 29143 | 5022 | 85 |
2328615 | 2328615 | 2022-03-21 | New Madrid | Missouri | 29143 | 5022 | 84 |
2325363 | 2325363 | 2022-03-20 | New Madrid | Missouri | 29143 | 5022 | 84 |
2322109 | 2322109 | 2022-03-19 | New Madrid | Missouri | 29143 | 5022 | 84 |
2318855 | 2318855 | 2022-03-18 | New Madrid | Missouri | 29143 | 5022 | 84 |
2315602 | 2315602 | 2022-03-17 | New Madrid | Missouri | 29143 | 5021 | 84 |
2312349 | 2312349 | 2022-03-16 | New Madrid | Missouri | 29143 | 5020 | 84 |
2309096 | 2309096 | 2022-03-15 | New Madrid | Missouri | 29143 | 5020 | 84 |
2305844 | 2305844 | 2022-03-14 | New Madrid | Missouri | 29143 | 5013 | 83 |
2302593 | 2302593 | 2022-03-13 | New Madrid | Missouri | 29143 | 5013 | 83 |
2299341 | 2299341 | 2022-03-12 | New Madrid | Missouri | 29143 | 5013 | 83 |
2296089 | 2296089 | 2022-03-11 | New Madrid | Missouri | 29143 | 5013 | 83 |
2292837 | 2292837 | 2022-03-10 | New Madrid | Missouri | 29143 | 5013 | 83 |
2289585 | 2289585 | 2022-03-09 | New Madrid | Missouri | 29143 | 5012 | 83 |
2286333 | 2286333 | 2022-03-08 | New Madrid | Missouri | 29143 | 5007 | 83 |
2283081 | 2283081 | 2022-03-07 | New Madrid | Missouri | 29143 | 5007 | 82 |
2279828 | 2279828 | 2022-03-06 | New Madrid | Missouri | 29143 | 5005 | 82 |
2276575 | 2276575 | 2022-03-05 | New Madrid | Missouri | 29143 | 5005 | 82 |
2273322 | 2273322 | 2022-03-04 | New Madrid | Missouri | 29143 | 5005 | 82 |
2270070 | 2270070 | 2022-03-03 | New Madrid | Missouri | 29143 | 5004 | 81 |
2266817 | 2266817 | 2022-03-02 | New Madrid | Missouri | 29143 | 5002 | 81 |
2263566 | 2263566 | 2022-03-01 | New Madrid | Missouri | 29143 | 5001 | 81 |
2260315 | 2260315 | 2022-02-28 | New Madrid | Missouri | 29143 | 4995 | 79 |
2257064 | 2257064 | 2022-02-27 | New Madrid | Missouri | 29143 | 4994 | 79 |
2253813 | 2253813 | 2022-02-26 | New Madrid | Missouri | 29143 | 4994 | 79 |
2250562 | 2250562 | 2022-02-25 | New Madrid | Missouri | 29143 | 4994 | 79 |
2247311 | 2247311 | 2022-02-24 | New Madrid | Missouri | 29143 | 4993 | 79 |
2244060 | 2244060 | 2022-02-23 | New Madrid | Missouri | 29143 | 4989 | 77 |
2240809 | 2240809 | 2022-02-22 | New Madrid | Missouri | 29143 | 4987 | 77 |
2237558 | 2237558 | 2022-02-21 | New Madrid | Missouri | 29143 | 4976 | 77 |
2234307 | 2234307 | 2022-02-20 | New Madrid | Missouri | 29143 | 4976 | 77 |
2231056 | 2231056 | 2022-02-19 | New Madrid | Missouri | 29143 | 4976 | 77 |
2227805 | 2227805 | 2022-02-18 | New Madrid | Missouri | 29143 | 4976 | 77 |
2224554 | 2224554 | 2022-02-17 | New Madrid | Missouri | 29143 | 4958 | 77 |
2221303 | 2221303 | 2022-02-16 | New Madrid | Missouri | 29143 | 4954 | 77 |
2218052 | 2218052 | 2022-02-15 | New Madrid | Missouri | 29143 | 4946 | 77 |
2214801 | 2214801 | 2022-02-14 | New Madrid | Missouri | 29143 | 4937 | 75 |
2211549 | 2211549 | 2022-02-13 | New Madrid | Missouri | 29143 | 4893 | 75 |
2208296 | 2208296 | 2022-02-12 | New Madrid | Missouri | 29143 | 4893 | 75 |
2205043 | 2205043 | 2022-02-11 | New Madrid | Missouri | 29143 | 4893 | 75 |
2201790 | 2201790 | 2022-02-10 | New Madrid | Missouri | 29143 | 4893 | 75 |
2198536 | 2198536 | 2022-02-09 | New Madrid | Missouri | 29143 | 4848 | 75 |
2195282 | 2195282 | 2022-02-08 | New Madrid | Missouri | 29143 | 4815 | 73 |
2192028 | 2192028 | 2022-02-07 | New Madrid | Missouri | 29143 | 4805 | 73 |
2188775 | 2188775 | 2022-02-06 | New Madrid | Missouri | 29143 | 4775 | 73 |
2185522 | 2185522 | 2022-02-05 | New Madrid | Missouri | 29143 | 4747 | 73 |
2182270 | 2182270 | 2022-02-04 | New Madrid | Missouri | 29143 | 4730 | 73 |
2179018 | 2179018 | 2022-02-03 | New Madrid | Missouri | 29143 | 4704 | 73 |
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);