ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
148 rows where cases = 605 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2316734 | 2316734 | 2022-03-17 | Fisher | Texas | 48151 | 605 | 24 |
2313481 | 2313481 | 2022-03-16 | Fisher | Texas | 48151 | 605 | 24 |
2310228 | 2310228 | 2022-03-15 | Fisher | Texas | 48151 | 605 | 24 |
2306975 | 2306975 | 2022-03-14 | Fisher | Texas | 48151 | 605 | 24 |
2303724 | 2303724 | 2022-03-13 | Fisher | Texas | 48151 | 605 | 24 |
2300472 | 2300472 | 2022-03-12 | Fisher | Texas | 48151 | 605 | 24 |
2297220 | 2297220 | 2022-03-11 | Fisher | Texas | 48151 | 605 | 24 |
2293968 | 2293968 | 2022-03-10 | Fisher | Texas | 48151 | 605 | 24 |
2290716 | 2290716 | 2022-03-09 | Fisher | Texas | 48151 | 605 | 24 |
2287464 | 2287464 | 2022-03-08 | Fisher | Texas | 48151 | 605 | 24 |
2284212 | 2284212 | 2022-03-07 | Fisher | Texas | 48151 | 605 | 24 |
2280960 | 2280960 | 2022-03-06 | Fisher | Texas | 48151 | 605 | 24 |
2277707 | 2277707 | 2022-03-05 | Fisher | Texas | 48151 | 605 | 24 |
2183473 | 2183473 | 2022-02-04 | Lipscomb | Texas | 48295 | 605 | 12 |
2154252 | 2154252 | 2022-01-26 | Shackelford | Texas | 48417 | 605 | 11 |
2062997 | 2062997 | 2021-12-29 | Baylor | Texas | 48023 | 605 | 24 |
2059747 | 2059747 | 2021-12-28 | Baylor | Texas | 48023 | 605 | 24 |
2056498 | 2056498 | 2021-12-27 | Baylor | Texas | 48023 | 605 | 24 |
1942911 | 1942911 | 2021-11-22 | Reagan | Texas | 48383 | 605 | 10 |
1939661 | 1939661 | 2021-11-21 | Reagan | Texas | 48383 | 605 | 10 |
1936411 | 1936411 | 2021-11-20 | Reagan | Texas | 48383 | 605 | 10 |
1933161 | 1933161 | 2021-11-19 | Reagan | Texas | 48383 | 605 | 10 |
1929910 | 1929910 | 2021-11-18 | Reagan | Texas | 48383 | 605 | 10 |
1926660 | 1926660 | 2021-11-17 | Reagan | Texas | 48383 | 605 | 10 |
1923410 | 1923410 | 2021-11-16 | Reagan | Texas | 48383 | 605 | 10 |
1920161 | 1920161 | 2021-11-15 | Reagan | Texas | 48383 | 605 | 10 |
1916911 | 1916911 | 2021-11-14 | Reagan | Texas | 48383 | 605 | 10 |
1913661 | 1913661 | 2021-11-13 | Reagan | Texas | 48383 | 605 | 10 |
1910411 | 1910411 | 2021-11-12 | Reagan | Texas | 48383 | 605 | 10 |
1832338 | 1832338 | 2021-10-19 | Haskell | Texas | 48207 | 605 | 31 |
1796712 | 1796712 | 2021-10-08 | Sutton | Texas | 48435 | 605 | 11 |
1793463 | 1793463 | 2021-10-07 | Sutton | Texas | 48435 | 605 | 11 |
1790214 | 1790214 | 2021-10-06 | Sutton | Texas | 48435 | 605 | 11 |
1494438 | 1494438 | 2021-07-07 | Carson | Texas | 48065 | 605 | 14 |
1491191 | 1491191 | 2021-07-06 | Carson | Texas | 48065 | 605 | 14 |
1487944 | 1487944 | 2021-07-05 | Carson | Texas | 48065 | 605 | 14 |
1484697 | 1484697 | 2021-07-04 | Carson | Texas | 48065 | 605 | 14 |
1481451 | 1481451 | 2021-07-03 | Carson | Texas | 48065 | 605 | 14 |
1465344 | 1465344 | 2021-06-28 | Marion | Texas | 48315 | 605 | 33 |
1426362 | 1426362 | 2021-06-16 | Jack | Texas | 48237 | 605 | 16 |
1423115 | 1423115 | 2021-06-15 | Jack | Texas | 48237 | 605 | 16 |
1419869 | 1419869 | 2021-06-14 | Jack | Texas | 48237 | 605 | 16 |
1416624 | 1416624 | 2021-06-13 | Jack | Texas | 48237 | 605 | 16 |
1413378 | 1413378 | 2021-06-12 | Jack | Texas | 48237 | 605 | 16 |
1410133 | 1410133 | 2021-06-11 | Jack | Texas | 48237 | 605 | 16 |
1406888 | 1406888 | 2021-06-10 | Jack | Texas | 48237 | 605 | 16 |
1384170 | 1384170 | 2021-06-03 | Jack | Texas | 48237 | 605 | 16 |
1380924 | 1380924 | 2021-06-02 | Jack | Texas | 48237 | 605 | 16 |
1377679 | 1377679 | 2021-06-01 | Jack | Texas | 48237 | 605 | 16 |
1374433 | 1374433 | 2021-05-31 | Jack | Texas | 48237 | 605 | 16 |
1371188 | 1371188 | 2021-05-30 | Jack | Texas | 48237 | 605 | 16 |
1367942 | 1367942 | 2021-05-29 | Jack | Texas | 48237 | 605 | 16 |
1364696 | 1364696 | 2021-05-28 | Jack | Texas | 48237 | 605 | 16 |
1358204 | 1358204 | 2021-05-26 | Jack | Texas | 48237 | 605 | 16 |
1355007 | 1355007 | 2021-05-25 | Mitchell | Texas | 48335 | 605 | 31 |
1351761 | 1351761 | 2021-05-24 | Mitchell | Texas | 48335 | 605 | 31 |
1348515 | 1348515 | 2021-05-23 | Mitchell | Texas | 48335 | 605 | 31 |
1345267 | 1345267 | 2021-05-22 | Mitchell | Texas | 48335 | 605 | 31 |
1342019 | 1342019 | 2021-05-21 | Mitchell | Texas | 48335 | 605 | 31 |
1338771 | 1338771 | 2021-05-20 | Mitchell | Texas | 48335 | 605 | 31 |
1335524 | 1335524 | 2021-05-19 | Mitchell | Texas | 48335 | 605 | 31 |
1332277 | 1332277 | 2021-05-18 | Mitchell | Texas | 48335 | 605 | 31 |
1329030 | 1329030 | 2021-05-17 | Mitchell | Texas | 48335 | 605 | 31 |
1325784 | 1325784 | 2021-05-16 | Mitchell | Texas | 48335 | 605 | 31 |
1322538 | 1322538 | 2021-05-15 | Mitchell | Texas | 48335 | 605 | 31 |
1319292 | 1319292 | 2021-05-14 | Mitchell | Texas | 48335 | 605 | 31 |
1316044 | 1316044 | 2021-05-13 | Mitchell | Texas | 48335 | 605 | 31 |
1312798 | 1312798 | 2021-05-12 | Mitchell | Texas | 48335 | 605 | 31 |
1309551 | 1309551 | 2021-05-11 | Mitchell | Texas | 48335 | 605 | 30 |
1306305 | 1306305 | 2021-05-10 | Mitchell | Texas | 48335 | 605 | 30 |
1303059 | 1303059 | 2021-05-09 | Mitchell | Texas | 48335 | 605 | 30 |
1299812 | 1299812 | 2021-05-08 | Mitchell | Texas | 48335 | 605 | 30 |
1296565 | 1296565 | 2021-05-07 | Mitchell | Texas | 48335 | 605 | 30 |
1293319 | 1293319 | 2021-05-06 | Mitchell | Texas | 48335 | 605 | 30 |
1241378 | 1241378 | 2021-04-20 | Newton | Texas | 48351 | 605 | 35 |
1238131 | 1238131 | 2021-04-19 | Newton | Texas | 48351 | 605 | 35 |
1234884 | 1234884 | 2021-04-18 | Newton | Texas | 48351 | 605 | 35 |
1231636 | 1231636 | 2021-04-17 | Newton | Texas | 48351 | 605 | 35 |
1228388 | 1228388 | 2021-04-16 | Newton | Texas | 48351 | 605 | 35 |
1173123 | 1173123 | 2021-03-30 | Jim Hogg | Texas | 48247 | 605 | 16 |
1169876 | 1169876 | 2021-03-29 | Jim Hogg | Texas | 48247 | 605 | 15 |
1166628 | 1166628 | 2021-03-28 | Jim Hogg | Texas | 48247 | 605 | 15 |
1163380 | 1163380 | 2021-03-27 | Jim Hogg | Texas | 48247 | 605 | 15 |
1160131 | 1160131 | 2021-03-26 | Jim Hogg | Texas | 48247 | 605 | 15 |
1156884 | 1156884 | 2021-03-25 | Jim Hogg | Texas | 48247 | 605 | 15 |
1153637 | 1153637 | 2021-03-24 | Jim Hogg | Texas | 48247 | 605 | 15 |
1150390 | 1150390 | 2021-03-23 | Jim Hogg | Texas | 48247 | 605 | 15 |
1147122 | 1147122 | 2021-03-22 | Hartley | Texas | 48205 | 605 | 2 |
1147138 | 1147138 | 2021-03-22 | Jack | Texas | 48237 | 605 | 16 |
1147143 | 1147143 | 2021-03-22 | Jim Hogg | Texas | 48247 | 605 | 15 |
1143875 | 1143875 | 2021-03-21 | Hartley | Texas | 48205 | 605 | 2 |
1143891 | 1143891 | 2021-03-21 | Jack | Texas | 48237 | 605 | 16 |
1143896 | 1143896 | 2021-03-21 | Jim Hogg | Texas | 48247 | 605 | 15 |
1140628 | 1140628 | 2021-03-20 | Hartley | Texas | 48205 | 605 | 2 |
1140644 | 1140644 | 2021-03-20 | Jack | Texas | 48237 | 605 | 16 |
1140649 | 1140649 | 2021-03-20 | Jim Hogg | Texas | 48247 | 605 | 15 |
1137403 | 1137403 | 2021-03-19 | Jim Hogg | Texas | 48247 | 605 | 15 |
1134157 | 1134157 | 2021-03-18 | Jim Hogg | Texas | 48247 | 605 | 15 |
1130904 | 1130904 | 2021-03-17 | Jack | Texas | 48237 | 605 | 16 |
1130909 | 1130909 | 2021-03-17 | Jim Hogg | Texas | 48247 | 605 | 15 |
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);