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)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337970 | 2337970 | 2022-03-24 | St. Charles | Louisiana | 22089 | 13783 | 143 |
2338402 | 2338402 | 2022-03-24 | St. Charles | Missouri | 29183 | 101512 | 913 |
2334716 | 2334716 | 2022-03-23 | St. Charles | Louisiana | 22089 | 13782 | 143 |
2335148 | 2335148 | 2022-03-23 | St. Charles | Missouri | 29183 | 101496 | 913 |
2331462 | 2331462 | 2022-03-22 | St. Charles | Louisiana | 22089 | 13779 | 143 |
2331894 | 2331894 | 2022-03-22 | St. Charles | Missouri | 29183 | 101477 | 913 |
2328210 | 2328210 | 2022-03-21 | St. Charles | Louisiana | 22089 | 13779 | 143 |
2328641 | 2328641 | 2022-03-21 | St. Charles | Missouri | 29183 | 101443 | 913 |
2324957 | 2324957 | 2022-03-20 | St. Charles | Louisiana | 22089 | 13778 | 143 |
2325389 | 2325389 | 2022-03-20 | St. Charles | Missouri | 29183 | 101393 | 906 |
2321703 | 2321703 | 2022-03-19 | St. Charles | Louisiana | 22089 | 13778 | 143 |
2322135 | 2322135 | 2022-03-19 | St. Charles | Missouri | 29183 | 101393 | 906 |
2318449 | 2318449 | 2022-03-18 | St. Charles | Louisiana | 22089 | 13778 | 143 |
2318881 | 2318881 | 2022-03-18 | St. Charles | Missouri | 29183 | 101390 | 906 |
2315196 | 2315196 | 2022-03-17 | St. Charles | Louisiana | 22089 | 13777 | 143 |
2315628 | 2315628 | 2022-03-17 | St. Charles | Missouri | 29183 | 101368 | 906 |
2311943 | 2311943 | 2022-03-16 | St. Charles | Louisiana | 22089 | 13772 | 143 |
2312375 | 2312375 | 2022-03-16 | St. Charles | Missouri | 29183 | 101348 | 906 |
2308690 | 2308690 | 2022-03-15 | St. Charles | Louisiana | 22089 | 13772 | 143 |
2309122 | 2309122 | 2022-03-15 | St. Charles | Missouri | 29183 | 101323 | 904 |
2305439 | 2305439 | 2022-03-14 | St. Charles | Louisiana | 22089 | 13771 | 143 |
2305870 | 2305870 | 2022-03-14 | St. Charles | Missouri | 29183 | 101286 | 896 |
2302187 | 2302187 | 2022-03-13 | St. Charles | Louisiana | 22089 | 13771 | 142 |
2302619 | 2302619 | 2022-03-13 | St. Charles | Missouri | 29183 | 101246 | 896 |
2298935 | 2298935 | 2022-03-12 | St. Charles | Louisiana | 22089 | 13771 | 142 |
2299367 | 2299367 | 2022-03-12 | St. Charles | Missouri | 29183 | 101246 | 896 |
2295683 | 2295683 | 2022-03-11 | St. Charles | Louisiana | 22089 | 13771 | 142 |
2296115 | 2296115 | 2022-03-11 | St. Charles | Missouri | 29183 | 101247 | 896 |
2292431 | 2292431 | 2022-03-10 | St. Charles | Louisiana | 22089 | 13771 | 142 |
2292863 | 2292863 | 2022-03-10 | St. Charles | Missouri | 29183 | 101229 | 890 |
2289179 | 2289179 | 2022-03-09 | St. Charles | Louisiana | 22089 | 13768 | 142 |
2289611 | 2289611 | 2022-03-09 | St. Charles | Missouri | 29183 | 101202 | 890 |
2285928 | 2285928 | 2022-03-08 | St. Charles | Louisiana | 22089 | 13768 | 142 |
2286359 | 2286359 | 2022-03-08 | St. Charles | Missouri | 29183 | 101180 | 890 |
2282676 | 2282676 | 2022-03-07 | St. Charles | Louisiana | 22089 | 13764 | 142 |
2283107 | 2283107 | 2022-03-07 | St. Charles | Missouri | 29183 | 101140 | 886 |
2279423 | 2279423 | 2022-03-06 | St. Charles | Louisiana | 22089 | 13759 | 142 |
2279854 | 2279854 | 2022-03-06 | St. Charles | Missouri | 29183 | 101084 | 886 |
2276170 | 2276170 | 2022-03-05 | St. Charles | Louisiana | 22089 | 13759 | 142 |
2276601 | 2276601 | 2022-03-05 | St. Charles | Missouri | 29183 | 101084 | 886 |
2272917 | 2272917 | 2022-03-04 | St. Charles | Louisiana | 22089 | 13759 | 142 |
2273348 | 2273348 | 2022-03-04 | St. Charles | Missouri | 29183 | 101085 | 886 |
2269665 | 2269665 | 2022-03-03 | St. Charles | Louisiana | 22089 | 13756 | 142 |
2270096 | 2270096 | 2022-03-03 | St. Charles | Missouri | 29183 | 101054 | 887 |
2266412 | 2266412 | 2022-03-02 | St. Charles | Louisiana | 22089 | 13756 | 142 |
2266843 | 2266843 | 2022-03-02 | St. Charles | Missouri | 29183 | 101022 | 887 |
2263161 | 2263161 | 2022-03-01 | St. Charles | Louisiana | 22089 | 13738 | 141 |
2263592 | 2263592 | 2022-03-01 | St. Charles | Missouri | 29183 | 100974 | 888 |
2259910 | 2259910 | 2022-02-28 | St. Charles | Louisiana | 22089 | 13738 | 141 |
2260341 | 2260341 | 2022-02-28 | St. Charles | Missouri | 29183 | 100923 | 883 |
2256659 | 2256659 | 2022-02-27 | St. Charles | Louisiana | 22089 | 13738 | 141 |
2257090 | 2257090 | 2022-02-27 | St. Charles | Missouri | 29183 | 100836 | 882 |
2253408 | 2253408 | 2022-02-26 | St. Charles | Louisiana | 22089 | 13738 | 141 |
2253839 | 2253839 | 2022-02-26 | St. Charles | Missouri | 29183 | 100836 | 882 |
2250157 | 2250157 | 2022-02-25 | St. Charles | Louisiana | 22089 | 13738 | 141 |
2250588 | 2250588 | 2022-02-25 | St. Charles | Missouri | 29183 | 100832 | 882 |
2246906 | 2246906 | 2022-02-24 | St. Charles | Louisiana | 22089 | 13729 | 141 |
2247337 | 2247337 | 2022-02-24 | St. Charles | Missouri | 29183 | 100780 | 880 |
2243655 | 2243655 | 2022-02-23 | St. Charles | Louisiana | 22089 | 13722 | 141 |
2244086 | 2244086 | 2022-02-23 | St. Charles | Missouri | 29183 | 100708 | 859 |
2240404 | 2240404 | 2022-02-22 | St. Charles | Louisiana | 22089 | 13713 | 141 |
2240835 | 2240835 | 2022-02-22 | St. Charles | Missouri | 29183 | 100629 | 859 |
2237153 | 2237153 | 2022-02-21 | St. Charles | Louisiana | 22089 | 13700 | 140 |
2237584 | 2237584 | 2022-02-21 | St. Charles | Missouri | 29183 | 100432 | 860 |
2233902 | 2233902 | 2022-02-20 | St. Charles | Louisiana | 22089 | 13690 | 140 |
2234333 | 2234333 | 2022-02-20 | St. Charles | Missouri | 29183 | 100431 | 860 |
2230651 | 2230651 | 2022-02-19 | St. Charles | Louisiana | 22089 | 13690 | 140 |
2231082 | 2231082 | 2022-02-19 | St. Charles | Missouri | 29183 | 100431 | 860 |
2227400 | 2227400 | 2022-02-18 | St. Charles | Louisiana | 22089 | 13690 | 140 |
2227831 | 2227831 | 2022-02-18 | St. Charles | Missouri | 29183 | 100428 | 860 |
2224149 | 2224149 | 2022-02-17 | St. Charles | Louisiana | 22089 | 13672 | 139 |
2224580 | 2224580 | 2022-02-17 | St. Charles | Missouri | 29183 | 100417 | 860 |
2220898 | 2220898 | 2022-02-16 | St. Charles | Louisiana | 22089 | 13661 | 139 |
2221329 | 2221329 | 2022-02-16 | St. Charles | Missouri | 29183 | 100329 | 860 |
2217647 | 2217647 | 2022-02-15 | St. Charles | Louisiana | 22089 | 13648 | 139 |
2218078 | 2218078 | 2022-02-15 | St. Charles | Missouri | 29183 | 100271 | 859 |
2214396 | 2214396 | 2022-02-14 | St. Charles | Louisiana | 22089 | 13636 | 139 |
2214827 | 2214827 | 2022-02-14 | St. Charles | Missouri | 29183 | 100149 | 834 |
2211144 | 2211144 | 2022-02-13 | St. Charles | Louisiana | 22089 | 13610 | 138 |
2211575 | 2211575 | 2022-02-13 | St. Charles | Missouri | 29183 | 99984 | 834 |
2207891 | 2207891 | 2022-02-12 | St. Charles | Louisiana | 22089 | 13610 | 138 |
2208322 | 2208322 | 2022-02-12 | St. Charles | Missouri | 29183 | 99984 | 834 |
2204638 | 2204638 | 2022-02-11 | St. Charles | Louisiana | 22089 | 13610 | 138 |
2205069 | 2205069 | 2022-02-11 | St. Charles | Missouri | 29183 | 99985 | 834 |
2201385 | 2201385 | 2022-02-10 | St. Charles | Louisiana | 22089 | 13586 | 138 |
2201816 | 2201816 | 2022-02-10 | St. Charles | Missouri | 29183 | 99876 | 831 |
2198131 | 2198131 | 2022-02-09 | St. Charles | Louisiana | 22089 | 13570 | 138 |
2198562 | 2198562 | 2022-02-09 | St. Charles | Missouri | 29183 | 99689 | 829 |
2194877 | 2194877 | 2022-02-08 | St. Charles | Louisiana | 22089 | 13545 | 137 |
2195308 | 2195308 | 2022-02-08 | St. Charles | Missouri | 29183 | 99557 | 823 |
2191623 | 2191623 | 2022-02-07 | St. Charles | Louisiana | 22089 | 13522 | 135 |
2192054 | 2192054 | 2022-02-07 | St. Charles | Missouri | 29183 | 99326 | 819 |
2188370 | 2188370 | 2022-02-06 | St. Charles | Louisiana | 22089 | 13475 | 135 |
2188801 | 2188801 | 2022-02-06 | St. Charles | Missouri | 29183 | 98943 | 819 |
2185117 | 2185117 | 2022-02-05 | St. Charles | Louisiana | 22089 | 13475 | 135 |
2185548 | 2185548 | 2022-02-05 | St. Charles | Missouri | 29183 | 98943 | 819 |
2181865 | 2181865 | 2022-02-04 | St. Charles | Louisiana | 22089 | 13475 | 135 |
2182296 | 2182296 | 2022-02-04 | St. Charles | Missouri | 29183 | 98941 | 819 |
2178614 | 2178614 | 2022-02-03 | St. Charles | Louisiana | 22089 | 13451 | 135 |
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);