ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where cases = 463 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424070 | 2424070 | 2022-04-19 | Briscoe | Texas | 48045 | 463 | 8 |
2420814 | 2420814 | 2022-04-18 | Briscoe | Texas | 48045 | 463 | 8 |
2417558 | 2417558 | 2022-04-17 | Briscoe | Texas | 48045 | 463 | 8 |
2414302 | 2414302 | 2022-04-16 | Briscoe | Texas | 48045 | 463 | 8 |
2411046 | 2411046 | 2022-04-15 | Briscoe | Texas | 48045 | 463 | 8 |
2407790 | 2407790 | 2022-04-14 | Briscoe | Texas | 48045 | 463 | 8 |
2404534 | 2404534 | 2022-04-13 | Briscoe | Texas | 48045 | 463 | 8 |
2261439 | 2261439 | 2022-02-28 | Edwards | Texas | 48137 | 463 | 11 |
2258188 | 2258188 | 2022-02-27 | Edwards | Texas | 48137 | 463 | 11 |
2254937 | 2254937 | 2022-02-26 | Edwards | Texas | 48137 | 463 | 11 |
2160716 | 2160716 | 2022-01-28 | Menard | Texas | 48327 | 463 | 12 |
2154181 | 2154181 | 2022-01-26 | Knox | Texas | 48275 | 463 | 22 |
2150929 | 2150929 | 2022-01-25 | Knox | Texas | 48275 | 463 | 22 |
2079373 | 2079373 | 2022-01-03 | Kimble | Texas | 48267 | 463 | 11 |
2076087 | 2076087 | 2022-01-02 | Hardeman | Texas | 48197 | 463 | 14 |
2072836 | 2072836 | 2022-01-01 | Hardeman | Texas | 48197 | 463 | 14 |
2069585 | 2069585 | 2021-12-31 | Hardeman | Texas | 48197 | 463 | 14 |
2066334 | 2066334 | 2021-12-30 | Hardeman | Texas | 48197 | 463 | 14 |
1715280 | 1715280 | 2021-09-13 | Baylor | Texas | 48023 | 463 | 14 |
1712034 | 1712034 | 2021-09-12 | Baylor | Texas | 48023 | 463 | 14 |
1708787 | 1708787 | 2021-09-11 | Baylor | Texas | 48023 | 463 | 14 |
1523730 | 1523730 | 2021-07-16 | Haskell | Texas | 48207 | 463 | 27 |
1520482 | 1520482 | 2021-07-15 | Haskell | Texas | 48207 | 463 | 27 |
1517234 | 1517234 | 2021-07-14 | Haskell | Texas | 48207 | 463 | 27 |
1513987 | 1513987 | 2021-07-13 | Haskell | Texas | 48207 | 463 | 27 |
1510741 | 1510741 | 2021-07-12 | Haskell | Texas | 48207 | 463 | 27 |
1507494 | 1507494 | 2021-07-11 | Haskell | Texas | 48207 | 463 | 27 |
1504248 | 1504248 | 2021-07-10 | Haskell | Texas | 48207 | 463 | 27 |
1293192 | 1293192 | 2021-05-06 | Coke | Texas | 48081 | 463 | 12 |
1273713 | 1273713 | 2021-04-30 | Coke | Texas | 48081 | 463 | 12 |
997860 | 997860 | 2021-02-04 | Marion | Texas | 48315 | 463 | 24 |
968694 | 968694 | 2021-01-26 | Sabine | Texas | 48403 | 463 | 30 |
965450 | 965450 | 2021-01-25 | Sabine | Texas | 48403 | 463 | 30 |
962205 | 962205 | 2021-01-24 | Sabine | Texas | 48403 | 463 | 30 |
958960 | 958960 | 2021-01-23 | Sabine | Texas | 48403 | 463 | 29 |
939444 | 939444 | 2021-01-17 | McCulloch | Texas | 48307 | 463 | 12 |
926532 | 926532 | 2021-01-13 | Trinity | Texas | 48455 | 463 | 11 |
900398 | 900398 | 2021-01-05 | Dallam | Texas | 48111 | 463 | 19 |
881071 | 881071 | 2020-12-30 | San Augustine | Texas | 48405 | 463 | 23 |
842083 | 842083 | 2020-12-18 | Martin | Texas | 48317 | 463 | 12 |
748006 | 748006 | 2020-11-19 | Robertson | Texas | 48395 | 463 | 6 |
692739 | 692739 | 2020-11-02 | Freestone | Texas | 48161 | 463 | 4 |
689495 | 689495 | 2020-11-01 | Freestone | Texas | 48161 | 463 | 4 |
686250 | 686250 | 2020-10-31 | Freestone | Texas | 48161 | 463 | 4 |
650718 | 650718 | 2020-10-20 | Upshur | Texas | 48459 | 463 | 12 |
608383 | 608383 | 2020-10-07 | Duval | Texas | 48131 | 463 | 17 |
592153 | 592153 | 2020-10-02 | Cooke | Texas | 48097 | 463 | 6 |
559904 | 559904 | 2020-09-22 | Shelby | Texas | 48419 | 463 | 25 |
540317 | 540317 | 2020-09-16 | Colorado | Texas | 48089 | 463 | 4 |
537199 | 537199 | 2020-09-15 | Milam | Texas | 48331 | 463 | 5 |
533963 | 533963 | 2020-09-14 | Milam | Texas | 48331 | 463 | 5 |
530728 | 530728 | 2020-09-13 | Milam | Texas | 48331 | 463 | 5 |
527491 | 527491 | 2020-09-12 | Milam | Texas | 48331 | 463 | 5 |
453096 | 453096 | 2020-08-20 | Jackson | Texas | 48239 | 463 | 13 |
446752 | 446752 | 2020-08-18 | Van Zandt | Texas | 48467 | 463 | 8 |
187078 | 187078 | 2020-05-28 | Brazos | Texas | 48041 | 463 | 19 |
156781 | 156781 | 2020-05-18 | Jefferson | Texas | 48245 | 463 | 26 |
150855 | 150855 | 2020-05-16 | Williamson | Texas | 48491 | 463 | 19 |
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);