ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,579 rows where county = "St. Charles" 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 |
---|---|---|---|---|---|---|---|
2500743 | 2500743 | 2022-05-13 | St. Charles | Louisiana | 22089 | 13920 | 145 |
2501175 | 2501175 | 2022-05-13 | St. Charles | Missouri | 29183 | 103932 | 938 |
2497485 | 2497485 | 2022-05-12 | St. Charles | Louisiana | 22089 | 13909 | 145 |
2497917 | 2497917 | 2022-05-12 | St. Charles | Missouri | 29183 | 103835 | 937 |
2494227 | 2494227 | 2022-05-11 | St. Charles | Louisiana | 22089 | 13897 | 145 |
2494659 | 2494659 | 2022-05-11 | St. Charles | Missouri | 29183 | 103716 | 937 |
2490969 | 2490969 | 2022-05-10 | St. Charles | Louisiana | 22089 | 13886 | 145 |
2491401 | 2491401 | 2022-05-10 | St. Charles | Missouri | 29183 | 103598 | 937 |
2487712 | 2487712 | 2022-05-09 | St. Charles | Louisiana | 22089 | 13880 | 145 |
2488143 | 2488143 | 2022-05-09 | St. Charles | Missouri | 29183 | 103460 | 937 |
2484454 | 2484454 | 2022-05-08 | St. Charles | Louisiana | 22089 | 13867 | 145 |
2484886 | 2484886 | 2022-05-08 | St. Charles | Missouri | 29183 | 103236 | 937 |
2481196 | 2481196 | 2022-05-07 | St. Charles | Louisiana | 22089 | 13867 | 145 |
2481628 | 2481628 | 2022-05-07 | St. Charles | Missouri | 29183 | 103236 | 937 |
2477938 | 2477938 | 2022-05-06 | St. Charles | Louisiana | 22089 | 13867 | 145 |
2478370 | 2478370 | 2022-05-06 | St. Charles | Missouri | 29183 | 103236 | 937 |
2474680 | 2474680 | 2022-05-05 | St. Charles | Louisiana | 22089 | 13864 | 145 |
2475112 | 2475112 | 2022-05-05 | St. Charles | Missouri | 29183 | 103144 | 935 |
2471423 | 2471423 | 2022-05-04 | St. Charles | Louisiana | 22089 | 13861 | 145 |
2471855 | 2471855 | 2022-05-04 | St. Charles | Missouri | 29183 | 103068 | 934 |
2468167 | 2468167 | 2022-05-03 | St. Charles | Louisiana | 22089 | 13858 | 145 |
2468599 | 2468599 | 2022-05-03 | St. Charles | Missouri | 29183 | 102962 | 924 |
2464912 | 2464912 | 2022-05-02 | St. Charles | Louisiana | 22089 | 13848 | 145 |
2465343 | 2465343 | 2022-05-02 | St. Charles | Missouri | 29183 | 102835 | 924 |
2461656 | 2461656 | 2022-05-01 | St. Charles | Louisiana | 22089 | 13842 | 145 |
2462088 | 2462088 | 2022-05-01 | St. Charles | Missouri | 29183 | 102726 | 924 |
2458400 | 2458400 | 2022-04-30 | St. Charles | Louisiana | 22089 | 13842 | 145 |
2458832 | 2458832 | 2022-04-30 | St. Charles | Missouri | 29183 | 102726 | 924 |
2455144 | 2455144 | 2022-04-29 | St. Charles | Louisiana | 22089 | 13842 | 145 |
2455576 | 2455576 | 2022-04-29 | St. Charles | Missouri | 29183 | 102725 | 924 |
2451888 | 2451888 | 2022-04-28 | St. Charles | Louisiana | 22089 | 13836 | 145 |
2452320 | 2452320 | 2022-04-28 | St. Charles | Missouri | 29183 | 102666 | 924 |
2448632 | 2448632 | 2022-04-27 | St. Charles | Louisiana | 22089 | 13833 | 145 |
2449064 | 2449064 | 2022-04-27 | St. Charles | Missouri | 29183 | 102603 | 924 |
2445376 | 2445376 | 2022-04-26 | St. Charles | Louisiana | 22089 | 13832 | 145 |
2445807 | 2445807 | 2022-04-26 | St. Charles | Missouri | 29183 | 102534 | 924 |
2442120 | 2442120 | 2022-04-25 | St. Charles | Louisiana | 22089 | 13831 | 145 |
2442552 | 2442552 | 2022-04-25 | St. Charles | Missouri | 29183 | 102474 | 924 |
2438864 | 2438864 | 2022-04-24 | St. Charles | Louisiana | 22089 | 13824 | 145 |
2439296 | 2439296 | 2022-04-24 | St. Charles | Missouri | 29183 | 102346 | 924 |
2435608 | 2435608 | 2022-04-23 | St. Charles | Louisiana | 22089 | 13824 | 145 |
2436040 | 2436040 | 2022-04-23 | St. Charles | Missouri | 29183 | 102346 | 924 |
2432352 | 2432352 | 2022-04-22 | St. Charles | Louisiana | 22089 | 13824 | 145 |
2432784 | 2432784 | 2022-04-22 | St. Charles | Missouri | 29183 | 102346 | 924 |
2429096 | 2429096 | 2022-04-21 | St. Charles | Louisiana | 22089 | 13823 | 145 |
2429528 | 2429528 | 2022-04-21 | St. Charles | Missouri | 29183 | 102285 | 924 |
2425840 | 2425840 | 2022-04-20 | St. Charles | Louisiana | 22089 | 13823 | 144 |
2426272 | 2426272 | 2022-04-20 | St. Charles | Missouri | 29183 | 102219 | 924 |
2422584 | 2422584 | 2022-04-19 | St. Charles | Louisiana | 22089 | 13819 | 144 |
2423016 | 2423016 | 2022-04-19 | St. Charles | Missouri | 29183 | 102169 | 924 |
2419328 | 2419328 | 2022-04-18 | St. Charles | Louisiana | 22089 | 13816 | 144 |
2419759 | 2419759 | 2022-04-18 | St. Charles | Missouri | 29183 | 102126 | 924 |
2416072 | 2416072 | 2022-04-17 | St. Charles | Louisiana | 22089 | 13812 | 144 |
2416504 | 2416504 | 2022-04-17 | St. Charles | Missouri | 29183 | 102039 | 924 |
2412816 | 2412816 | 2022-04-16 | St. Charles | Louisiana | 22089 | 13812 | 144 |
2413248 | 2413248 | 2022-04-16 | St. Charles | Missouri | 29183 | 102039 | 924 |
2409560 | 2409560 | 2022-04-15 | St. Charles | Louisiana | 22089 | 13812 | 144 |
2409992 | 2409992 | 2022-04-15 | St. Charles | Missouri | 29183 | 102039 | 924 |
2406304 | 2406304 | 2022-04-14 | St. Charles | Louisiana | 22089 | 13812 | 144 |
2406736 | 2406736 | 2022-04-14 | St. Charles | Missouri | 29183 | 101993 | 924 |
2403048 | 2403048 | 2022-04-13 | St. Charles | Louisiana | 22089 | 13810 | 144 |
2403480 | 2403480 | 2022-04-13 | St. Charles | Missouri | 29183 | 101966 | 924 |
2399794 | 2399794 | 2022-04-12 | St. Charles | Louisiana | 22089 | 13809 | 144 |
2400225 | 2400225 | 2022-04-12 | St. Charles | Missouri | 29183 | 101931 | 924 |
2396538 | 2396538 | 2022-04-11 | St. Charles | Louisiana | 22089 | 13806 | 144 |
2396970 | 2396970 | 2022-04-11 | St. Charles | Missouri | 29183 | 101898 | 924 |
2393283 | 2393283 | 2022-04-10 | St. Charles | Louisiana | 22089 | 13802 | 144 |
2393715 | 2393715 | 2022-04-10 | St. Charles | Missouri | 29183 | 101846 | 924 |
2390027 | 2390027 | 2022-04-09 | St. Charles | Louisiana | 22089 | 13802 | 144 |
2390459 | 2390459 | 2022-04-09 | St. Charles | Missouri | 29183 | 101846 | 924 |
2386771 | 2386771 | 2022-04-08 | St. Charles | Louisiana | 22089 | 13802 | 144 |
2387203 | 2387203 | 2022-04-08 | St. Charles | Missouri | 29183 | 101847 | 924 |
2383516 | 2383516 | 2022-04-07 | St. Charles | Louisiana | 22089 | 13799 | 144 |
2383948 | 2383948 | 2022-04-07 | St. Charles | Missouri | 29183 | 101839 | 924 |
2380261 | 2380261 | 2022-04-06 | St. Charles | Louisiana | 22089 | 13799 | 144 |
2380693 | 2380693 | 2022-04-06 | St. Charles | Missouri | 29183 | 101783 | 924 |
2377006 | 2377006 | 2022-04-05 | St. Charles | Louisiana | 22089 | 13799 | 144 |
2377438 | 2377438 | 2022-04-05 | St. Charles | Missouri | 29183 | 101754 | 924 |
2373754 | 2373754 | 2022-04-04 | St. Charles | Louisiana | 22089 | 13797 | 144 |
2374185 | 2374185 | 2022-04-04 | St. Charles | Missouri | 29183 | 101728 | 923 |
2370501 | 2370501 | 2022-04-03 | St. Charles | Louisiana | 22089 | 13795 | 144 |
2370933 | 2370933 | 2022-04-03 | St. Charles | Missouri | 29183 | 101684 | 923 |
2367248 | 2367248 | 2022-04-02 | St. Charles | Louisiana | 22089 | 13795 | 144 |
2367680 | 2367680 | 2022-04-02 | St. Charles | Missouri | 29183 | 101684 | 923 |
2363995 | 2363995 | 2022-04-01 | St. Charles | Louisiana | 22089 | 13795 | 144 |
2364427 | 2364427 | 2022-04-01 | St. Charles | Missouri | 29183 | 101686 | 923 |
2360741 | 2360741 | 2022-03-31 | St. Charles | Louisiana | 22089 | 13792 | 144 |
2361173 | 2361173 | 2022-03-31 | St. Charles | Missouri | 29183 | 101663 | 923 |
2357487 | 2357487 | 2022-03-30 | St. Charles | Louisiana | 22089 | 13788 | 144 |
2357919 | 2357919 | 2022-03-30 | St. Charles | Missouri | 29183 | 101647 | 923 |
2354234 | 2354234 | 2022-03-29 | St. Charles | Louisiana | 22089 | 13787 | 144 |
2354666 | 2354666 | 2022-03-29 | St. Charles | Missouri | 29183 | 101614 | 918 |
2350982 | 2350982 | 2022-03-28 | St. Charles | Louisiana | 22089 | 13785 | 143 |
2351413 | 2351413 | 2022-03-28 | St. Charles | Missouri | 29183 | 101590 | 913 |
2347729 | 2347729 | 2022-03-27 | St. Charles | Louisiana | 22089 | 13785 | 143 |
2348161 | 2348161 | 2022-03-27 | St. Charles | Missouri | 29183 | 101538 | 913 |
2344476 | 2344476 | 2022-03-26 | St. Charles | Louisiana | 22089 | 13785 | 143 |
2344908 | 2344908 | 2022-03-26 | St. Charles | Missouri | 29183 | 101538 | 913 |
2341223 | 2341223 | 2022-03-25 | St. Charles | Louisiana | 22089 | 13785 | 143 |
2341655 | 2341655 | 2022-03-25 | St. Charles | Missouri | 29183 | 101539 | 913 |
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);