ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 48321 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176980 | 2176980 | 2022-02-02 | Matagorda | Texas | 48321 | 7814 | 170 |
2173726 | 2173726 | 2022-02-01 | Matagorda | Texas | 48321 | 7780 | 170 |
2170474 | 2170474 | 2022-01-31 | Matagorda | Texas | 48321 | 7756 | 170 |
2167220 | 2167220 | 2022-01-30 | Matagorda | Texas | 48321 | 7740 | 170 |
2163965 | 2163965 | 2022-01-29 | Matagorda | Texas | 48321 | 7713 | 170 |
2160710 | 2160710 | 2022-01-28 | Matagorda | Texas | 48321 | 7698 | 170 |
2157454 | 2157454 | 2022-01-27 | Matagorda | Texas | 48321 | 7664 | 170 |
2154201 | 2154201 | 2022-01-26 | Matagorda | Texas | 48321 | 7637 | 170 |
2150949 | 2150949 | 2022-01-25 | Matagorda | Texas | 48321 | 7623 | 168 |
2147697 | 2147697 | 2022-01-24 | Matagorda | Texas | 48321 | 7562 | 168 |
2144443 | 2144443 | 2022-01-23 | Matagorda | Texas | 48321 | 7515 | 168 |
2141188 | 2141188 | 2022-01-22 | Matagorda | Texas | 48321 | 7480 | 168 |
2137932 | 2137932 | 2022-01-21 | Matagorda | Texas | 48321 | 7443 | 168 |
2134678 | 2134678 | 2022-01-20 | Matagorda | Texas | 48321 | 7394 | 167 |
2131426 | 2131426 | 2022-01-19 | Matagorda | Texas | 48321 | 7369 | 167 |
2128172 | 2128172 | 2022-01-18 | Matagorda | Texas | 48321 | 7342 | 167 |
2124920 | 2124920 | 2022-01-17 | Matagorda | Texas | 48321 | 7300 | 166 |
2121668 | 2121668 | 2022-01-16 | Matagorda | Texas | 48321 | 7248 | 166 |
2118416 | 2118416 | 2022-01-15 | Matagorda | Texas | 48321 | 7224 | 166 |
2115165 | 2115165 | 2022-01-14 | Matagorda | Texas | 48321 | 7142 | 165 |
2111913 | 2111913 | 2022-01-13 | Matagorda | Texas | 48321 | 7001 | 164 |
2108661 | 2108661 | 2022-01-12 | Matagorda | Texas | 48321 | 6940 | 164 |
2105410 | 2105410 | 2022-01-11 | Matagorda | Texas | 48321 | 6876 | 164 |
2102159 | 2102159 | 2022-01-10 | Matagorda | Texas | 48321 | 6825 | 164 |
2098908 | 2098908 | 2022-01-09 | Matagorda | Texas | 48321 | 6789 | 164 |
2095656 | 2095656 | 2022-01-08 | Matagorda | Texas | 48321 | 6761 | 164 |
2092404 | 2092404 | 2022-01-07 | Matagorda | Texas | 48321 | 6728 | 164 |
2089152 | 2089152 | 2022-01-06 | Matagorda | Texas | 48321 | 6664 | 163 |
2085901 | 2085901 | 2022-01-05 | Matagorda | Texas | 48321 | 6637 | 162 |
2082649 | 2082649 | 2022-01-04 | Matagorda | Texas | 48321 | 6603 | 162 |
2079397 | 2079397 | 2022-01-03 | Matagorda | Texas | 48321 | 6560 | 162 |
2076146 | 2076146 | 2022-01-02 | Matagorda | Texas | 48321 | 6310 | 162 |
2072895 | 2072895 | 2022-01-01 | Matagorda | Texas | 48321 | 6310 | 162 |
2069644 | 2069644 | 2021-12-31 | Matagorda | Texas | 48321 | 6310 | 162 |
2066393 | 2066393 | 2021-12-30 | Matagorda | Texas | 48321 | 6310 | 162 |
2063143 | 2063143 | 2021-12-29 | Matagorda | Texas | 48321 | 6298 | 162 |
2059893 | 2059893 | 2021-12-28 | Matagorda | Texas | 48321 | 6290 | 162 |
2056644 | 2056644 | 2021-12-27 | Matagorda | Texas | 48321 | 6278 | 162 |
2053395 | 2053395 | 2021-12-26 | Matagorda | Texas | 48321 | 6227 | 162 |
2050145 | 2050145 | 2021-12-25 | Matagorda | Texas | 48321 | 6227 | 162 |
2046895 | 2046895 | 2021-12-24 | Matagorda | Texas | 48321 | 6227 | 162 |
2043645 | 2043645 | 2021-12-23 | Matagorda | Texas | 48321 | 6227 | 162 |
2040396 | 2040396 | 2021-12-22 | Matagorda | Texas | 48321 | 6221 | 162 |
2037146 | 2037146 | 2021-12-21 | Matagorda | Texas | 48321 | 6218 | 162 |
2033896 | 2033896 | 2021-12-20 | Matagorda | Texas | 48321 | 6208 | 162 |
2030646 | 2030646 | 2021-12-19 | Matagorda | Texas | 48321 | 6204 | 162 |
2027395 | 2027395 | 2021-12-18 | Matagorda | Texas | 48321 | 6195 | 162 |
2024144 | 2024144 | 2021-12-17 | Matagorda | Texas | 48321 | 6187 | 162 |
2020893 | 2020893 | 2021-12-16 | Matagorda | Texas | 48321 | 6182 | 162 |
2017642 | 2017642 | 2021-12-15 | Matagorda | Texas | 48321 | 6169 | 162 |
2014392 | 2014392 | 2021-12-14 | Matagorda | Texas | 48321 | 6167 | 162 |
2011141 | 2011141 | 2021-12-13 | Matagorda | Texas | 48321 | 6164 | 161 |
2007890 | 2007890 | 2021-12-12 | Matagorda | Texas | 48321 | 6163 | 161 |
2004639 | 2004639 | 2021-12-11 | Matagorda | Texas | 48321 | 6163 | 161 |
2001388 | 2001388 | 2021-12-10 | Matagorda | Texas | 48321 | 6157 | 161 |
1998138 | 1998138 | 2021-12-09 | Matagorda | Texas | 48321 | 6146 | 161 |
1994887 | 1994887 | 2021-12-08 | Matagorda | Texas | 48321 | 6144 | 161 |
1991636 | 1991636 | 2021-12-07 | Matagorda | Texas | 48321 | 6140 | 161 |
1988385 | 1988385 | 2021-12-06 | Matagorda | Texas | 48321 | 6136 | 161 |
1985135 | 1985135 | 2021-12-05 | Matagorda | Texas | 48321 | 6135 | 161 |
1981885 | 1981885 | 2021-12-04 | Matagorda | Texas | 48321 | 6133 | 161 |
1978635 | 1978635 | 2021-12-03 | Matagorda | Texas | 48321 | 6129 | 161 |
1975385 | 1975385 | 2021-12-02 | Matagorda | Texas | 48321 | 6127 | 161 |
1972136 | 1972136 | 2021-12-01 | Matagorda | Texas | 48321 | 6123 | 161 |
1968886 | 1968886 | 2021-11-30 | Matagorda | Texas | 48321 | 6121 | 161 |
1965635 | 1965635 | 2021-11-29 | Matagorda | Texas | 48321 | 6117 | 161 |
1962383 | 1962383 | 2021-11-28 | Matagorda | Texas | 48321 | 6113 | 160 |
1959132 | 1959132 | 2021-11-27 | Matagorda | Texas | 48321 | 6113 | 160 |
1955881 | 1955881 | 2021-11-26 | Matagorda | Texas | 48321 | 6113 | 160 |
1952630 | 1952630 | 2021-11-25 | Matagorda | Texas | 48321 | 6113 | 160 |
1949379 | 1949379 | 2021-11-24 | Matagorda | Texas | 48321 | 6113 | 160 |
1946128 | 1946128 | 2021-11-23 | Matagorda | Texas | 48321 | 6109 | 160 |
1942877 | 1942877 | 2021-11-22 | Matagorda | Texas | 48321 | 6107 | 160 |
1939627 | 1939627 | 2021-11-21 | Matagorda | Texas | 48321 | 6107 | 159 |
1936377 | 1936377 | 2021-11-20 | Matagorda | Texas | 48321 | 6106 | 159 |
1933127 | 1933127 | 2021-11-19 | Matagorda | Texas | 48321 | 6123 | 159 |
1929876 | 1929876 | 2021-11-18 | Matagorda | Texas | 48321 | 6114 | 159 |
1926626 | 1926626 | 2021-11-17 | Matagorda | Texas | 48321 | 6112 | 158 |
1923376 | 1923376 | 2021-11-16 | Matagorda | Texas | 48321 | 6111 | 158 |
1920127 | 1920127 | 2021-11-15 | Matagorda | Texas | 48321 | 6108 | 158 |
1916877 | 1916877 | 2021-11-14 | Matagorda | Texas | 48321 | 6108 | 158 |
1913627 | 1913627 | 2021-11-13 | Matagorda | Texas | 48321 | 6106 | 158 |
1910377 | 1910377 | 2021-11-12 | Matagorda | Texas | 48321 | 6101 | 158 |
1907128 | 1907128 | 2021-11-11 | Matagorda | Texas | 48321 | 6100 | 158 |
1903879 | 1903879 | 2021-11-10 | Matagorda | Texas | 48321 | 6097 | 158 |
1900629 | 1900629 | 2021-11-09 | Matagorda | Texas | 48321 | 6097 | 158 |
1897379 | 1897379 | 2021-11-08 | Matagorda | Texas | 48321 | 6094 | 157 |
1894129 | 1894129 | 2021-11-07 | Matagorda | Texas | 48321 | 6092 | 157 |
1890879 | 1890879 | 2021-11-06 | Matagorda | Texas | 48321 | 6090 | 157 |
1887629 | 1887629 | 2021-11-05 | Matagorda | Texas | 48321 | 6089 | 157 |
1884379 | 1884379 | 2021-11-04 | Matagorda | Texas | 48321 | 6072 | 156 |
1881130 | 1881130 | 2021-11-03 | Matagorda | Texas | 48321 | 6070 | 156 |
1877881 | 1877881 | 2021-11-02 | Matagorda | Texas | 48321 | 6068 | 156 |
1874632 | 1874632 | 2021-11-01 | Matagorda | Texas | 48321 | 6065 | 156 |
1871383 | 1871383 | 2021-10-31 | Matagorda | Texas | 48321 | 6065 | 156 |
1868134 | 1868134 | 2021-10-30 | Matagorda | Texas | 48321 | 6064 | 156 |
1864885 | 1864885 | 2021-10-29 | Matagorda | Texas | 48321 | 6064 | 156 |
1861636 | 1861636 | 2021-10-28 | Matagorda | Texas | 48321 | 6063 | 156 |
1858387 | 1858387 | 2021-10-27 | Matagorda | Texas | 48321 | 6058 | 156 |
1855138 | 1855138 | 2021-10-26 | Matagorda | Texas | 48321 | 6056 | 156 |
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);