ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 693 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2134738 | 2134738 | 2022-01-20 | Sutton | Texas | 48435 | 693 | 11 |
2079343 | 2079343 | 2022-01-03 | Haskell | Texas | 48207 | 693 | 37 |
1998021 | 1998021 | 2021-12-09 | Coke | Texas | 48081 | 693 | 18 |
1994770 | 1994770 | 2021-12-08 | Coke | Texas | 48081 | 693 | 18 |
1835589 | 1835589 | 2021-10-20 | Hemphill | Texas | 48211 | 693 | 3 |
1832340 | 1832340 | 2021-10-19 | Hemphill | Texas | 48211 | 693 | 3 |
1728504 | 1728504 | 2021-09-17 | Wheeler | Texas | 48483 | 693 | 12 |
1663455 | 1663455 | 2021-08-28 | McCulloch | Texas | 48307 | 693 | 21 |
1608242 | 1608242 | 2021-08-11 | Mills | Texas | 48333 | 693 | 22 |
1543306 | 1543306 | 2021-07-22 | Refugio | Texas | 48391 | 693 | 23 |
1296591 | 1296591 | 2021-05-07 | Red River | Texas | 48387 | 693 | 37 |
1293345 | 1293345 | 2021-05-06 | Red River | Texas | 48387 | 693 | 37 |
1127554 | 1127554 | 2021-03-16 | Blanco | Texas | 48031 | 693 | 18 |
1124308 | 1124308 | 2021-03-15 | Blanco | Texas | 48031 | 693 | 18 |
903737 | 903737 | 2021-01-06 | Llano | Texas | 48299 | 693 | 16 |
851812 | 851812 | 2020-12-21 | Live Oak | Texas | 48297 | 693 | 10 |
848567 | 848567 | 2020-12-20 | Live Oak | Texas | 48297 | 693 | 10 |
845318 | 845318 | 2020-12-19 | Leon | Texas | 48289 | 693 | 21 |
845322 | 845322 | 2020-12-19 | Live Oak | Texas | 48297 | 693 | 10 |
842076 | 842076 | 2020-12-18 | Live Oak | Texas | 48297 | 693 | 10 |
838749 | 838749 | 2020-12-17 | Eastland | Texas | 48133 | 693 | 12 |
838831 | 838831 | 2020-12-17 | Live Oak | Texas | 48297 | 693 | 10 |
832199 | 832199 | 2020-12-15 | Bailey | Texas | 48017 | 693 | 11 |
793360 | 793360 | 2020-12-03 | Hutchinson | Texas | 48233 | 693 | 28 |
786948 | 786948 | 2020-12-01 | Reeves | Texas | 48389 | 693 | 13 |
783704 | 783704 | 2020-11-30 | Reeves | Texas | 48389 | 693 | 13 |
725211 | 725211 | 2020-11-12 | Jackson | Texas | 48239 | 693 | 16 |
721968 | 721968 | 2020-11-11 | Jackson | Texas | 48239 | 693 | 16 |
705852 | 705852 | 2020-11-06 | Terry | Texas | 48445 | 693 | 11 |
702636 | 702636 | 2020-11-05 | Wood | Texas | 48499 | 693 | 42 |
689526 | 689526 | 2020-11-01 | Hopkins | Texas | 48223 | 693 | 36 |
686281 | 686281 | 2020-10-31 | Hopkins | Texas | 48223 | 693 | 35 |
666845 | 666845 | 2020-10-25 | Kerr | Texas | 48265 | 693 | 13 |
663600 | 663600 | 2020-10-24 | Kerr | Texas | 48265 | 693 | 13 |
650727 | 650727 | 2020-10-20 | Washington | Texas | 48477 | 693 | 48 |
540299 | 540299 | 2020-09-16 | Burnet | Texas | 48053 | 693 | 12 |
501604 | 501604 | 2020-09-04 | Madison | Texas | 48313 | 693 | 5 |
491823 | 491823 | 2020-09-01 | Erath | Texas | 48143 | 693 | 9 |
449876 | 449876 | 2020-08-19 | Karnes | Texas | 48255 | 693 | 10 |
420777 | 420777 | 2020-08-10 | DeWitt | Texas | 48123 | 693 | 19 |
420820 | 420820 | 2020-08-10 | Harrison | Texas | 48203 | 693 | 35 |
417556 | 417556 | 2020-08-09 | DeWitt | Texas | 48123 | 693 | 19 |
417599 | 417599 | 2020-08-09 | Harrison | Texas | 48203 | 693 | 35 |
417739 | 417739 | 2020-08-09 | Willacy | Texas | 48489 | 693 | 29 |
414335 | 414335 | 2020-08-08 | DeWitt | Texas | 48123 | 693 | 18 |
414378 | 414378 | 2020-08-08 | Harrison | Texas | 48203 | 693 | 35 |
404802 | 404802 | 2020-08-05 | Polk | Texas | 48373 | 693 | 11 |
401584 | 401584 | 2020-08-04 | Polk | Texas | 48373 | 693 | 11 |
388553 | 388553 | 2020-07-31 | Bowie | Texas | 48037 | 693 | 38 |
385336 | 385336 | 2020-07-30 | Bowie | Texas | 48037 | 693 | 37 |
382118 | 382118 | 2020-07-29 | Bowie | Texas | 48037 | 693 | 37 |
144708 | 144708 | 2020-05-14 | Galveston | Texas | 48167 | 693 | 30 |
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);