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 |
---|---|---|---|---|---|---|---|
2179044 | 2179044 | 2022-02-03 | St. Charles | Missouri | 29183 | 98845 | 815 |
2175361 | 2175361 | 2022-02-02 | St. Charles | Louisiana | 22089 | 13421 | 135 |
2175792 | 2175792 | 2022-02-02 | St. Charles | Missouri | 29183 | 98715 | 813 |
2172108 | 2172108 | 2022-02-01 | St. Charles | Louisiana | 22089 | 13366 | 135 |
2172539 | 2172539 | 2022-02-01 | St. Charles | Missouri | 29183 | 98350 | 803 |
2168855 | 2168855 | 2022-01-31 | St. Charles | Louisiana | 22089 | 13318 | 135 |
2169286 | 2169286 | 2022-01-31 | St. Charles | Missouri | 29183 | 98013 | 783 |
2165600 | 2165600 | 2022-01-30 | St. Charles | Louisiana | 22089 | 13244 | 135 |
2166031 | 2166031 | 2022-01-30 | St. Charles | Missouri | 29183 | 97244 | 776 |
2162345 | 2162345 | 2022-01-29 | St. Charles | Louisiana | 22089 | 13244 | 135 |
2162776 | 2162776 | 2022-01-29 | St. Charles | Missouri | 29183 | 97244 | 776 |
2159090 | 2159090 | 2022-01-28 | St. Charles | Louisiana | 22089 | 13244 | 135 |
2159521 | 2159521 | 2022-01-28 | St. Charles | Missouri | 29183 | 97232 | 774 |
2155836 | 2155836 | 2022-01-27 | St. Charles | Louisiana | 22089 | 13199 | 133 |
2156267 | 2156267 | 2022-01-27 | St. Charles | Missouri | 29183 | 96737 | 774 |
2152583 | 2152583 | 2022-01-26 | St. Charles | Louisiana | 22089 | 13150 | 133 |
2153014 | 2153014 | 2022-01-26 | St. Charles | Missouri | 29183 | 96249 | 774 |
2149331 | 2149331 | 2022-01-25 | St. Charles | Louisiana | 22089 | 12532 | 133 |
2149762 | 2149762 | 2022-01-25 | St. Charles | Missouri | 29183 | 95694 | 774 |
2146079 | 2146079 | 2022-01-24 | St. Charles | Louisiana | 22089 | 12496 | 133 |
2146510 | 2146510 | 2022-01-24 | St. Charles | Missouri | 29183 | 95132 | 774 |
2142824 | 2142824 | 2022-01-23 | St. Charles | Louisiana | 22089 | 12367 | 132 |
2143255 | 2143255 | 2022-01-23 | St. Charles | Missouri | 29183 | 93748 | 773 |
2139569 | 2139569 | 2022-01-22 | St. Charles | Louisiana | 22089 | 12367 | 132 |
2140000 | 2140000 | 2022-01-22 | St. Charles | Missouri | 29183 | 93748 | 773 |
2136313 | 2136313 | 2022-01-21 | St. Charles | Louisiana | 22089 | 12367 | 132 |
2136744 | 2136744 | 2022-01-21 | St. Charles | Missouri | 29183 | 93724 | 777 |
2133061 | 2133061 | 2022-01-20 | St. Charles | Louisiana | 22089 | 12275 | 131 |
2133492 | 2133492 | 2022-01-20 | St. Charles | Missouri | 29183 | 92714 | 767 |
2129808 | 2129808 | 2022-01-19 | St. Charles | Louisiana | 22089 | 12210 | 131 |
2130239 | 2130239 | 2022-01-19 | St. Charles | Missouri | 29183 | 91930 | 767 |
2126554 | 2126554 | 2022-01-18 | St. Charles | Louisiana | 22089 | 12048 | 130 |
2126985 | 2126985 | 2022-01-18 | St. Charles | Missouri | 29183 | 90837 | 764 |
2123302 | 2123302 | 2022-01-17 | St. Charles | Louisiana | 22089 | 11761 | 129 |
2123733 | 2123733 | 2022-01-17 | St. Charles | Missouri | 29183 | 87630 | 764 |
2120050 | 2120050 | 2022-01-16 | St. Charles | Louisiana | 22089 | 11761 | 129 |
2120481 | 2120481 | 2022-01-16 | St. Charles | Missouri | 29183 | 87630 | 764 |
2116798 | 2116798 | 2022-01-15 | St. Charles | Louisiana | 22089 | 11761 | 129 |
2117229 | 2117229 | 2022-01-15 | St. Charles | Missouri | 29183 | 87630 | 764 |
2113547 | 2113547 | 2022-01-14 | St. Charles | Louisiana | 22089 | 11761 | 129 |
2113978 | 2113978 | 2022-01-14 | St. Charles | Missouri | 29183 | 87575 | 764 |
2110295 | 2110295 | 2022-01-13 | St. Charles | Louisiana | 22089 | 11238 | 129 |
2110726 | 2110726 | 2022-01-13 | St. Charles | Missouri | 29183 | 86715 | 764 |
2107044 | 2107044 | 2022-01-12 | St. Charles | Louisiana | 22089 | 11238 | 129 |
2107475 | 2107475 | 2022-01-12 | St. Charles | Missouri | 29183 | 85411 | 764 |
2103793 | 2103793 | 2022-01-11 | St. Charles | Louisiana | 22089 | 11238 | 129 |
2104224 | 2104224 | 2022-01-11 | St. Charles | Missouri | 29183 | 83889 | 764 |
2100542 | 2100542 | 2022-01-10 | St. Charles | Louisiana | 22089 | 11150 | 129 |
2100973 | 2100973 | 2022-01-10 | St. Charles | Missouri | 29183 | 82784 | 760 |
2097291 | 2097291 | 2022-01-09 | St. Charles | Louisiana | 22089 | 10784 | 129 |
2097722 | 2097722 | 2022-01-09 | St. Charles | Missouri | 29183 | 80357 | 760 |
2094039 | 2094039 | 2022-01-08 | St. Charles | Louisiana | 22089 | 10784 | 129 |
2094470 | 2094470 | 2022-01-08 | St. Charles | Missouri | 29183 | 80357 | 760 |
2090787 | 2090787 | 2022-01-07 | St. Charles | Louisiana | 22089 | 10784 | 129 |
2091218 | 2091218 | 2022-01-07 | St. Charles | Missouri | 29183 | 80340 | 760 |
2087536 | 2087536 | 2022-01-06 | St. Charles | Louisiana | 22089 | 10594 | 128 |
2087967 | 2087967 | 2022-01-06 | St. Charles | Missouri | 29183 | 79316 | 760 |
2084284 | 2084284 | 2022-01-05 | St. Charles | Louisiana | 22089 | 10467 | 128 |
2084715 | 2084715 | 2022-01-05 | St. Charles | Missouri | 29183 | 77648 | 760 |
2081032 | 2081032 | 2022-01-04 | St. Charles | Louisiana | 22089 | 10333 | 128 |
2081463 | 2081463 | 2022-01-04 | St. Charles | Missouri | 29183 | 75646 | 760 |
2077780 | 2077780 | 2022-01-03 | St. Charles | Louisiana | 22089 | 10210 | 128 |
2078211 | 2078211 | 2022-01-03 | St. Charles | Missouri | 29183 | 75496 | 748 |
2074529 | 2074529 | 2022-01-02 | St. Charles | Louisiana | 22089 | 9784 | 128 |
2074960 | 2074960 | 2022-01-02 | St. Charles | Missouri | 29183 | 73141 | 748 |
2071278 | 2071278 | 2022-01-01 | St. Charles | Louisiana | 22089 | 9784 | 128 |
2071709 | 2071709 | 2022-01-01 | St. Charles | Missouri | 29183 | 73141 | 748 |
2068027 | 2068027 | 2021-12-31 | St. Charles | Louisiana | 22089 | 9784 | 128 |
2068458 | 2068458 | 2021-12-31 | St. Charles | Missouri | 29183 | 73141 | 748 |
2064776 | 2064776 | 2021-12-30 | St. Charles | Louisiana | 22089 | 9784 | 128 |
2065207 | 2065207 | 2021-12-30 | St. Charles | Missouri | 29183 | 72302 | 748 |
2061526 | 2061526 | 2021-12-29 | St. Charles | Louisiana | 22089 | 9627 | 128 |
2061957 | 2061957 | 2021-12-29 | St. Charles | Missouri | 29183 | 72250 | 748 |
2058277 | 2058277 | 2021-12-28 | St. Charles | Louisiana | 22089 | 9529 | 128 |
2058708 | 2058708 | 2021-12-28 | St. Charles | Missouri | 29183 | 71547 | 748 |
2055028 | 2055028 | 2021-12-27 | St. Charles | Louisiana | 22089 | 9470 | 128 |
2055459 | 2055459 | 2021-12-27 | St. Charles | Missouri | 29183 | 70864 | 741 |
2051778 | 2051778 | 2021-12-26 | St. Charles | Louisiana | 22089 | 9294 | 128 |
2052209 | 2052209 | 2021-12-26 | St. Charles | Missouri | 29183 | 69693 | 741 |
2048528 | 2048528 | 2021-12-25 | St. Charles | Louisiana | 22089 | 9294 | 128 |
2048959 | 2048959 | 2021-12-25 | St. Charles | Missouri | 29183 | 69693 | 741 |
2045278 | 2045278 | 2021-12-24 | St. Charles | Louisiana | 22089 | 9294 | 128 |
2045709 | 2045709 | 2021-12-24 | St. Charles | Missouri | 29183 | 69693 | 741 |
2042029 | 2042029 | 2021-12-23 | St. Charles | Louisiana | 22089 | 9294 | 128 |
2042459 | 2042459 | 2021-12-23 | St. Charles | Missouri | 29183 | 69693 | 741 |
2038779 | 2038779 | 2021-12-22 | St. Charles | Louisiana | 22089 | 9240 | 128 |
2039210 | 2039210 | 2021-12-22 | St. Charles | Missouri | 29183 | 69689 | 741 |
2035529 | 2035529 | 2021-12-21 | St. Charles | Louisiana | 22089 | 9203 | 128 |
2035960 | 2035960 | 2021-12-21 | St. Charles | Missouri | 29183 | 69358 | 737 |
2032279 | 2032279 | 2021-12-20 | St. Charles | Louisiana | 22089 | 9177 | 128 |
2032710 | 2032710 | 2021-12-20 | St. Charles | Missouri | 29183 | 69059 | 732 |
2029028 | 2029028 | 2021-12-19 | St. Charles | Louisiana | 22089 | 9125 | 128 |
2029459 | 2029459 | 2021-12-19 | St. Charles | Missouri | 29183 | 68551 | 732 |
2025777 | 2025777 | 2021-12-18 | St. Charles | Louisiana | 22089 | 9125 | 128 |
2026208 | 2026208 | 2021-12-18 | St. Charles | Missouri | 29183 | 68551 | 732 |
2022526 | 2022526 | 2021-12-17 | St. Charles | Louisiana | 22089 | 9125 | 128 |
2022957 | 2022957 | 2021-12-17 | St. Charles | Missouri | 29183 | 68551 | 732 |
2019275 | 2019275 | 2021-12-16 | St. Charles | Louisiana | 22089 | 9113 | 128 |
2019706 | 2019706 | 2021-12-16 | St. Charles | Missouri | 29183 | 68263 | 732 |
2016025 | 2016025 | 2021-12-15 | St. Charles | Louisiana | 22089 | 9102 | 128 |
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);