ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 29183 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 |
---|---|---|---|---|---|---|---|
2501175 | 2501175 | 2022-05-13 | St. Charles | Missouri | 29183 | 103932 | 938 |
2497917 | 2497917 | 2022-05-12 | St. Charles | Missouri | 29183 | 103835 | 937 |
2494659 | 2494659 | 2022-05-11 | St. Charles | Missouri | 29183 | 103716 | 937 |
2491401 | 2491401 | 2022-05-10 | St. Charles | Missouri | 29183 | 103598 | 937 |
2488143 | 2488143 | 2022-05-09 | St. Charles | Missouri | 29183 | 103460 | 937 |
2484886 | 2484886 | 2022-05-08 | St. Charles | Missouri | 29183 | 103236 | 937 |
2481628 | 2481628 | 2022-05-07 | St. Charles | Missouri | 29183 | 103236 | 937 |
2478370 | 2478370 | 2022-05-06 | St. Charles | Missouri | 29183 | 103236 | 937 |
2475112 | 2475112 | 2022-05-05 | St. Charles | Missouri | 29183 | 103144 | 935 |
2471855 | 2471855 | 2022-05-04 | St. Charles | Missouri | 29183 | 103068 | 934 |
2468599 | 2468599 | 2022-05-03 | St. Charles | Missouri | 29183 | 102962 | 924 |
2465343 | 2465343 | 2022-05-02 | St. Charles | Missouri | 29183 | 102835 | 924 |
2462088 | 2462088 | 2022-05-01 | St. Charles | Missouri | 29183 | 102726 | 924 |
2458832 | 2458832 | 2022-04-30 | St. Charles | Missouri | 29183 | 102726 | 924 |
2455576 | 2455576 | 2022-04-29 | St. Charles | Missouri | 29183 | 102725 | 924 |
2452320 | 2452320 | 2022-04-28 | St. Charles | Missouri | 29183 | 102666 | 924 |
2449064 | 2449064 | 2022-04-27 | St. Charles | Missouri | 29183 | 102603 | 924 |
2445807 | 2445807 | 2022-04-26 | St. Charles | Missouri | 29183 | 102534 | 924 |
2442552 | 2442552 | 2022-04-25 | St. Charles | Missouri | 29183 | 102474 | 924 |
2439296 | 2439296 | 2022-04-24 | St. Charles | Missouri | 29183 | 102346 | 924 |
2436040 | 2436040 | 2022-04-23 | St. Charles | Missouri | 29183 | 102346 | 924 |
2432784 | 2432784 | 2022-04-22 | St. Charles | Missouri | 29183 | 102346 | 924 |
2429528 | 2429528 | 2022-04-21 | St. Charles | Missouri | 29183 | 102285 | 924 |
2426272 | 2426272 | 2022-04-20 | St. Charles | Missouri | 29183 | 102219 | 924 |
2423016 | 2423016 | 2022-04-19 | St. Charles | Missouri | 29183 | 102169 | 924 |
2419759 | 2419759 | 2022-04-18 | St. Charles | Missouri | 29183 | 102126 | 924 |
2416504 | 2416504 | 2022-04-17 | St. Charles | Missouri | 29183 | 102039 | 924 |
2413248 | 2413248 | 2022-04-16 | St. Charles | Missouri | 29183 | 102039 | 924 |
2409992 | 2409992 | 2022-04-15 | St. Charles | Missouri | 29183 | 102039 | 924 |
2406736 | 2406736 | 2022-04-14 | St. Charles | Missouri | 29183 | 101993 | 924 |
2403480 | 2403480 | 2022-04-13 | St. Charles | Missouri | 29183 | 101966 | 924 |
2400225 | 2400225 | 2022-04-12 | St. Charles | Missouri | 29183 | 101931 | 924 |
2396970 | 2396970 | 2022-04-11 | St. Charles | Missouri | 29183 | 101898 | 924 |
2393715 | 2393715 | 2022-04-10 | St. Charles | Missouri | 29183 | 101846 | 924 |
2390459 | 2390459 | 2022-04-09 | St. Charles | Missouri | 29183 | 101846 | 924 |
2387203 | 2387203 | 2022-04-08 | St. Charles | Missouri | 29183 | 101847 | 924 |
2383948 | 2383948 | 2022-04-07 | St. Charles | Missouri | 29183 | 101839 | 924 |
2380693 | 2380693 | 2022-04-06 | St. Charles | Missouri | 29183 | 101783 | 924 |
2377438 | 2377438 | 2022-04-05 | St. Charles | Missouri | 29183 | 101754 | 924 |
2374185 | 2374185 | 2022-04-04 | St. Charles | Missouri | 29183 | 101728 | 923 |
2370933 | 2370933 | 2022-04-03 | St. Charles | Missouri | 29183 | 101684 | 923 |
2367680 | 2367680 | 2022-04-02 | St. Charles | Missouri | 29183 | 101684 | 923 |
2364427 | 2364427 | 2022-04-01 | St. Charles | Missouri | 29183 | 101686 | 923 |
2361173 | 2361173 | 2022-03-31 | St. Charles | Missouri | 29183 | 101663 | 923 |
2357919 | 2357919 | 2022-03-30 | St. Charles | Missouri | 29183 | 101647 | 923 |
2354666 | 2354666 | 2022-03-29 | St. Charles | Missouri | 29183 | 101614 | 918 |
2351413 | 2351413 | 2022-03-28 | St. Charles | Missouri | 29183 | 101590 | 913 |
2348161 | 2348161 | 2022-03-27 | St. Charles | Missouri | 29183 | 101538 | 913 |
2344908 | 2344908 | 2022-03-26 | St. Charles | Missouri | 29183 | 101538 | 913 |
2341655 | 2341655 | 2022-03-25 | St. Charles | Missouri | 29183 | 101539 | 913 |
2338402 | 2338402 | 2022-03-24 | St. Charles | Missouri | 29183 | 101512 | 913 |
2335148 | 2335148 | 2022-03-23 | St. Charles | Missouri | 29183 | 101496 | 913 |
2331894 | 2331894 | 2022-03-22 | St. Charles | Missouri | 29183 | 101477 | 913 |
2328641 | 2328641 | 2022-03-21 | St. Charles | Missouri | 29183 | 101443 | 913 |
2325389 | 2325389 | 2022-03-20 | St. Charles | Missouri | 29183 | 101393 | 906 |
2322135 | 2322135 | 2022-03-19 | St. Charles | Missouri | 29183 | 101393 | 906 |
2318881 | 2318881 | 2022-03-18 | St. Charles | Missouri | 29183 | 101390 | 906 |
2315628 | 2315628 | 2022-03-17 | St. Charles | Missouri | 29183 | 101368 | 906 |
2312375 | 2312375 | 2022-03-16 | St. Charles | Missouri | 29183 | 101348 | 906 |
2309122 | 2309122 | 2022-03-15 | St. Charles | Missouri | 29183 | 101323 | 904 |
2305870 | 2305870 | 2022-03-14 | St. Charles | Missouri | 29183 | 101286 | 896 |
2302619 | 2302619 | 2022-03-13 | St. Charles | Missouri | 29183 | 101246 | 896 |
2299367 | 2299367 | 2022-03-12 | St. Charles | Missouri | 29183 | 101246 | 896 |
2296115 | 2296115 | 2022-03-11 | St. Charles | Missouri | 29183 | 101247 | 896 |
2292863 | 2292863 | 2022-03-10 | St. Charles | Missouri | 29183 | 101229 | 890 |
2289611 | 2289611 | 2022-03-09 | St. Charles | Missouri | 29183 | 101202 | 890 |
2286359 | 2286359 | 2022-03-08 | St. Charles | Missouri | 29183 | 101180 | 890 |
2283107 | 2283107 | 2022-03-07 | St. Charles | Missouri | 29183 | 101140 | 886 |
2279854 | 2279854 | 2022-03-06 | St. Charles | Missouri | 29183 | 101084 | 886 |
2276601 | 2276601 | 2022-03-05 | St. Charles | Missouri | 29183 | 101084 | 886 |
2273348 | 2273348 | 2022-03-04 | St. Charles | Missouri | 29183 | 101085 | 886 |
2270096 | 2270096 | 2022-03-03 | St. Charles | Missouri | 29183 | 101054 | 887 |
2266843 | 2266843 | 2022-03-02 | St. Charles | Missouri | 29183 | 101022 | 887 |
2263592 | 2263592 | 2022-03-01 | St. Charles | Missouri | 29183 | 100974 | 888 |
2260341 | 2260341 | 2022-02-28 | St. Charles | Missouri | 29183 | 100923 | 883 |
2257090 | 2257090 | 2022-02-27 | St. Charles | Missouri | 29183 | 100836 | 882 |
2253839 | 2253839 | 2022-02-26 | St. Charles | Missouri | 29183 | 100836 | 882 |
2250588 | 2250588 | 2022-02-25 | St. Charles | Missouri | 29183 | 100832 | 882 |
2247337 | 2247337 | 2022-02-24 | St. Charles | Missouri | 29183 | 100780 | 880 |
2244086 | 2244086 | 2022-02-23 | St. Charles | Missouri | 29183 | 100708 | 859 |
2240835 | 2240835 | 2022-02-22 | St. Charles | Missouri | 29183 | 100629 | 859 |
2237584 | 2237584 | 2022-02-21 | St. Charles | Missouri | 29183 | 100432 | 860 |
2234333 | 2234333 | 2022-02-20 | St. Charles | Missouri | 29183 | 100431 | 860 |
2231082 | 2231082 | 2022-02-19 | St. Charles | Missouri | 29183 | 100431 | 860 |
2227831 | 2227831 | 2022-02-18 | St. Charles | Missouri | 29183 | 100428 | 860 |
2224580 | 2224580 | 2022-02-17 | St. Charles | Missouri | 29183 | 100417 | 860 |
2221329 | 2221329 | 2022-02-16 | St. Charles | Missouri | 29183 | 100329 | 860 |
2218078 | 2218078 | 2022-02-15 | St. Charles | Missouri | 29183 | 100271 | 859 |
2214827 | 2214827 | 2022-02-14 | St. Charles | Missouri | 29183 | 100149 | 834 |
2211575 | 2211575 | 2022-02-13 | St. Charles | Missouri | 29183 | 99984 | 834 |
2208322 | 2208322 | 2022-02-12 | St. Charles | Missouri | 29183 | 99984 | 834 |
2205069 | 2205069 | 2022-02-11 | St. Charles | Missouri | 29183 | 99985 | 834 |
2201816 | 2201816 | 2022-02-10 | St. Charles | Missouri | 29183 | 99876 | 831 |
2198562 | 2198562 | 2022-02-09 | St. Charles | Missouri | 29183 | 99689 | 829 |
2195308 | 2195308 | 2022-02-08 | St. Charles | Missouri | 29183 | 99557 | 823 |
2192054 | 2192054 | 2022-02-07 | St. Charles | Missouri | 29183 | 99326 | 819 |
2188801 | 2188801 | 2022-02-06 | St. Charles | Missouri | 29183 | 98943 | 819 |
2185548 | 2185548 | 2022-02-05 | St. Charles | Missouri | 29183 | 98943 | 819 |
2182296 | 2182296 | 2022-02-04 | St. Charles | Missouri | 29183 | 98941 | 819 |
2179044 | 2179044 | 2022-02-03 | St. Charles | Missouri | 29183 | 98845 | 815 |
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);