ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
758 rows where county = "Marion" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176977 | 2176977 | 2022-02-02 | Marion | Texas | 48315 | 1543 | 55 |
2173723 | 2173723 | 2022-02-01 | Marion | Texas | 48315 | 1538 | 55 |
2170471 | 2170471 | 2022-01-31 | Marion | Texas | 48315 | 1532 | 55 |
2167217 | 2167217 | 2022-01-30 | Marion | Texas | 48315 | 1528 | 55 |
2163962 | 2163962 | 2022-01-29 | Marion | Texas | 48315 | 1522 | 55 |
2160707 | 2160707 | 2022-01-28 | Marion | Texas | 48315 | 1510 | 55 |
2157451 | 2157451 | 2022-01-27 | Marion | Texas | 48315 | 1499 | 55 |
2154198 | 2154198 | 2022-01-26 | Marion | Texas | 48315 | 1488 | 55 |
2150946 | 2150946 | 2022-01-25 | Marion | Texas | 48315 | 1488 | 55 |
2147694 | 2147694 | 2022-01-24 | Marion | Texas | 48315 | 1482 | 55 |
2144440 | 2144440 | 2022-01-23 | Marion | Texas | 48315 | 1469 | 55 |
2141185 | 2141185 | 2022-01-22 | Marion | Texas | 48315 | 1465 | 55 |
2137929 | 2137929 | 2022-01-21 | Marion | Texas | 48315 | 1457 | 55 |
2134675 | 2134675 | 2022-01-20 | Marion | Texas | 48315 | 1437 | 55 |
2131423 | 2131423 | 2022-01-19 | Marion | Texas | 48315 | 1430 | 55 |
2128169 | 2128169 | 2022-01-18 | Marion | Texas | 48315 | 1424 | 55 |
2124917 | 2124917 | 2022-01-17 | Marion | Texas | 48315 | 1414 | 55 |
2121665 | 2121665 | 2022-01-16 | Marion | Texas | 48315 | 1407 | 55 |
2118413 | 2118413 | 2022-01-15 | Marion | Texas | 48315 | 1396 | 55 |
2115162 | 2115162 | 2022-01-14 | Marion | Texas | 48315 | 1386 | 55 |
2111910 | 2111910 | 2022-01-13 | Marion | Texas | 48315 | 1293 | 55 |
2108658 | 2108658 | 2022-01-12 | Marion | Texas | 48315 | 1287 | 55 |
2105407 | 2105407 | 2022-01-11 | Marion | Texas | 48315 | 1276 | 55 |
2102156 | 2102156 | 2022-01-10 | Marion | Texas | 48315 | 1268 | 55 |
2098905 | 2098905 | 2022-01-09 | Marion | Texas | 48315 | 1266 | 55 |
2095653 | 2095653 | 2022-01-08 | Marion | Texas | 48315 | 1262 | 55 |
2092401 | 2092401 | 2022-01-07 | Marion | Texas | 48315 | 1259 | 55 |
2089149 | 2089149 | 2022-01-06 | Marion | Texas | 48315 | 1256 | 55 |
2085898 | 2085898 | 2022-01-05 | Marion | Texas | 48315 | 1253 | 55 |
2082646 | 2082646 | 2022-01-04 | Marion | Texas | 48315 | 1250 | 55 |
2079394 | 2079394 | 2022-01-03 | Marion | Texas | 48315 | 1245 | 55 |
2076143 | 2076143 | 2022-01-02 | Marion | Texas | 48315 | 1227 | 55 |
2072892 | 2072892 | 2022-01-01 | Marion | Texas | 48315 | 1227 | 55 |
2069641 | 2069641 | 2021-12-31 | Marion | Texas | 48315 | 1227 | 55 |
2066390 | 2066390 | 2021-12-30 | Marion | Texas | 48315 | 1227 | 55 |
2063140 | 2063140 | 2021-12-29 | Marion | Texas | 48315 | 1227 | 53 |
2059890 | 2059890 | 2021-12-28 | Marion | Texas | 48315 | 1227 | 53 |
2056641 | 2056641 | 2021-12-27 | Marion | Texas | 48315 | 1223 | 53 |
2053392 | 2053392 | 2021-12-26 | Marion | Texas | 48315 | 1218 | 53 |
2050142 | 2050142 | 2021-12-25 | Marion | Texas | 48315 | 1218 | 53 |
2046892 | 2046892 | 2021-12-24 | Marion | Texas | 48315 | 1218 | 53 |
2043642 | 2043642 | 2021-12-23 | Marion | Texas | 48315 | 1218 | 53 |
2040393 | 2040393 | 2021-12-22 | Marion | Texas | 48315 | 1218 | 53 |
2037143 | 2037143 | 2021-12-21 | Marion | Texas | 48315 | 1218 | 53 |
2033893 | 2033893 | 2021-12-20 | Marion | Texas | 48315 | 1216 | 53 |
2030643 | 2030643 | 2021-12-19 | Marion | Texas | 48315 | 1216 | 53 |
2027392 | 2027392 | 2021-12-18 | Marion | Texas | 48315 | 1216 | 53 |
2024141 | 2024141 | 2021-12-17 | Marion | Texas | 48315 | 1215 | 53 |
2020890 | 2020890 | 2021-12-16 | Marion | Texas | 48315 | 1213 | 53 |
2017639 | 2017639 | 2021-12-15 | Marion | Texas | 48315 | 1209 | 53 |
2014389 | 2014389 | 2021-12-14 | Marion | Texas | 48315 | 1203 | 53 |
2011138 | 2011138 | 2021-12-13 | Marion | Texas | 48315 | 1201 | 53 |
2007887 | 2007887 | 2021-12-12 | Marion | Texas | 48315 | 1201 | 53 |
2004636 | 2004636 | 2021-12-11 | Marion | Texas | 48315 | 1200 | 53 |
2001385 | 2001385 | 2021-12-10 | Marion | Texas | 48315 | 1200 | 53 |
1998135 | 1998135 | 2021-12-09 | Marion | Texas | 48315 | 1199 | 53 |
1994884 | 1994884 | 2021-12-08 | Marion | Texas | 48315 | 1198 | 53 |
1991633 | 1991633 | 2021-12-07 | Marion | Texas | 48315 | 1194 | 53 |
1988382 | 1988382 | 2021-12-06 | Marion | Texas | 48315 | 1192 | 53 |
1985132 | 1985132 | 2021-12-05 | Marion | Texas | 48315 | 1192 | 53 |
1981882 | 1981882 | 2021-12-04 | Marion | Texas | 48315 | 1192 | 53 |
1978632 | 1978632 | 2021-12-03 | Marion | Texas | 48315 | 1192 | 53 |
1975382 | 1975382 | 2021-12-02 | Marion | Texas | 48315 | 1192 | 53 |
1972133 | 1972133 | 2021-12-01 | Marion | Texas | 48315 | 1192 | 53 |
1968883 | 1968883 | 2021-11-30 | Marion | Texas | 48315 | 1191 | 53 |
1965632 | 1965632 | 2021-11-29 | Marion | Texas | 48315 | 1189 | 53 |
1962380 | 1962380 | 2021-11-28 | Marion | Texas | 48315 | 1188 | 53 |
1959129 | 1959129 | 2021-11-27 | Marion | Texas | 48315 | 1188 | 53 |
1955878 | 1955878 | 2021-11-26 | Marion | Texas | 48315 | 1188 | 53 |
1952627 | 1952627 | 2021-11-25 | Marion | Texas | 48315 | 1188 | 53 |
1949376 | 1949376 | 2021-11-24 | Marion | Texas | 48315 | 1188 | 53 |
1946125 | 1946125 | 2021-11-23 | Marion | Texas | 48315 | 1188 | 52 |
1942874 | 1942874 | 2021-11-22 | Marion | Texas | 48315 | 1187 | 51 |
1939624 | 1939624 | 2021-11-21 | Marion | Texas | 48315 | 1187 | 51 |
1936374 | 1936374 | 2021-11-20 | Marion | Texas | 48315 | 1187 | 51 |
1933124 | 1933124 | 2021-11-19 | Marion | Texas | 48315 | 1187 | 51 |
1929873 | 1929873 | 2021-11-18 | Marion | Texas | 48315 | 1187 | 51 |
1926623 | 1926623 | 2021-11-17 | Marion | Texas | 48315 | 1187 | 51 |
1923373 | 1923373 | 2021-11-16 | Marion | Texas | 48315 | 1187 | 51 |
1920124 | 1920124 | 2021-11-15 | Marion | Texas | 48315 | 1187 | 51 |
1916874 | 1916874 | 2021-11-14 | Marion | Texas | 48315 | 1187 | 51 |
1913624 | 1913624 | 2021-11-13 | Marion | Texas | 48315 | 1187 | 51 |
1910374 | 1910374 | 2021-11-12 | Marion | Texas | 48315 | 1187 | 51 |
1907125 | 1907125 | 2021-11-11 | Marion | Texas | 48315 | 1187 | 51 |
1903876 | 1903876 | 2021-11-10 | Marion | Texas | 48315 | 1186 | 50 |
1900626 | 1900626 | 2021-11-09 | Marion | Texas | 48315 | 1186 | 50 |
1897376 | 1897376 | 2021-11-08 | Marion | Texas | 48315 | 1184 | 50 |
1894126 | 1894126 | 2021-11-07 | Marion | Texas | 48315 | 1184 | 50 |
1890876 | 1890876 | 2021-11-06 | Marion | Texas | 48315 | 1184 | 50 |
1887626 | 1887626 | 2021-11-05 | Marion | Texas | 48315 | 1184 | 50 |
1884376 | 1884376 | 2021-11-04 | Marion | Texas | 48315 | 1183 | 50 |
1881127 | 1881127 | 2021-11-03 | Marion | Texas | 48315 | 1183 | 50 |
1877878 | 1877878 | 2021-11-02 | Marion | Texas | 48315 | 1180 | 50 |
1874629 | 1874629 | 2021-11-01 | Marion | Texas | 48315 | 1179 | 50 |
1871380 | 1871380 | 2021-10-31 | Marion | Texas | 48315 | 1179 | 50 |
1868131 | 1868131 | 2021-10-30 | Marion | Texas | 48315 | 1179 | 50 |
1864882 | 1864882 | 2021-10-29 | Marion | Texas | 48315 | 1175 | 50 |
1861633 | 1861633 | 2021-10-28 | Marion | Texas | 48315 | 1175 | 50 |
1858384 | 1858384 | 2021-10-27 | Marion | Texas | 48315 | 1173 | 50 |
1855135 | 1855135 | 2021-10-26 | Marion | Texas | 48315 | 1173 | 50 |
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);