ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
152 rows where cases = 87 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2134537 | 2134537 | 2022-01-20 | Borden | Texas | 48033 | 87 | 2 |
1764199 | 1764199 | 2021-09-28 | Roberts | Texas | 48393 | 87 | 1 |
1760950 | 1760950 | 2021-09-27 | Roberts | Texas | 48393 | 87 | 1 |
1757702 | 1757702 | 2021-09-26 | Roberts | Texas | 48393 | 87 | 1 |
1754454 | 1754454 | 2021-09-25 | Roberts | Texas | 48393 | 87 | 1 |
1595242 | 1595242 | 2021-08-07 | McMullen | Texas | 48311 | 87 | 5 |
1591993 | 1591993 | 2021-08-06 | McMullen | Texas | 48311 | 87 | 5 |
1588744 | 1588744 | 2021-08-05 | McMullen | Texas | 48311 | 87 | 5 |
1585494 | 1585494 | 2021-08-04 | McMullen | Texas | 48311 | 87 | 5 |
1582244 | 1582244 | 2021-08-03 | McMullen | Texas | 48311 | 87 | 5 |
1578995 | 1578995 | 2021-08-02 | McMullen | Texas | 48311 | 87 | 5 |
1575747 | 1575747 | 2021-08-01 | McMullen | Texas | 48311 | 87 | 5 |
1572499 | 1572499 | 2021-07-31 | McMullen | Texas | 48311 | 87 | 5 |
1569251 | 1569251 | 2021-07-30 | McMullen | Texas | 48311 | 87 | 5 |
1150439 | 1150439 | 2021-03-23 | Motley | Texas | 48345 | 87 | 8 |
958876 | 958876 | 2021-01-23 | Irion | Texas | 48235 | 87 | 1 |
877646 | 877646 | 2020-12-29 | Briscoe | Texas | 48045 | 87 | 2 |
874401 | 874401 | 2020-12-28 | Briscoe | Texas | 48045 | 87 | 2 |
871156 | 871156 | 2020-12-27 | Briscoe | Texas | 48045 | 87 | 2 |
867911 | 867911 | 2020-12-26 | Briscoe | Texas | 48045 | 87 | 2 |
864666 | 864666 | 2020-12-25 | Briscoe | Texas | 48045 | 87 | 2 |
861421 | 861421 | 2020-12-24 | Briscoe | Texas | 48045 | 87 | 2 |
858240 | 858240 | 2020-12-23 | Glasscock | Texas | 48173 | 87 | 1 |
780400 | 780400 | 2020-11-29 | Kinney | Texas | 48271 | 87 | 2 |
777154 | 777154 | 2020-11-28 | Kinney | Texas | 48271 | 87 | 2 |
773909 | 773909 | 2020-11-27 | Kinney | Texas | 48271 | 87 | 2 |
770664 | 770664 | 2020-11-26 | Kinney | Texas | 48271 | 87 | 2 |
767418 | 767418 | 2020-11-25 | Kinney | Texas | 48271 | 87 | 2 |
760825 | 760825 | 2020-11-23 | Carson | Texas | 48065 | 87 | 2 |
757580 | 757580 | 2020-11-22 | Carson | Texas | 48065 | 87 | 2 |
754333 | 754333 | 2020-11-21 | Carson | Texas | 48065 | 87 | 2 |
748019 | 748019 | 2020-11-19 | Sherman | Texas | 48421 | 87 | 1 |
725254 | 725254 | 2020-11-12 | Menard | Texas | 48327 | 87 | 2 |
722004 | 722004 | 2020-11-11 | Mason | Texas | 48319 | 87 | 2 |
718761 | 718761 | 2020-11-10 | Mason | Texas | 48319 | 87 | 2 |
715518 | 715518 | 2020-11-09 | Mason | Texas | 48319 | 87 | 2 |
712274 | 712274 | 2020-11-08 | Mason | Texas | 48319 | 87 | 2 |
709030 | 709030 | 2020-11-07 | Mason | Texas | 48319 | 87 | 2 |
705786 | 705786 | 2020-11-06 | Mason | Texas | 48319 | 87 | 2 |
702553 | 702553 | 2020-11-05 | Mills | Texas | 48333 | 87 | 2 |
647446 | 647446 | 2020-10-19 | Sabine | Texas | 48403 | 87 | 9 |
644200 | 644200 | 2020-10-18 | Sabine | Texas | 48403 | 87 | 9 |
640952 | 640952 | 2020-10-17 | Sabine | Texas | 48403 | 87 | 9 |
637705 | 637705 | 2020-10-16 | Sabine | Texas | 48403 | 87 | 9 |
634460 | 634460 | 2020-10-15 | Sabine | Texas | 48403 | 87 | 9 |
634476 | 634476 | 2020-10-15 | Sutton | Texas | 48435 | 87 | 3 |
631052 | 631052 | 2020-10-14 | Childress | Texas | 48075 | 87 | 0 |
627809 | 627809 | 2020-10-13 | Clay | Texas | 48077 | 87 | 2 |
624567 | 624567 | 2020-10-12 | Clay | Texas | 48077 | 87 | 2 |
621324 | 621324 | 2020-10-11 | Clay | Texas | 48077 | 87 | 2 |
618081 | 618081 | 2020-10-10 | Clay | Texas | 48077 | 87 | 2 |
614839 | 614839 | 2020-10-09 | Clay | Texas | 48077 | 87 | 2 |
592109 | 592109 | 2020-10-02 | Archer | Texas | 48009 | 87 | 1 |
588869 | 588869 | 2020-10-01 | Archer | Texas | 48009 | 87 | 1 |
585628 | 585628 | 2020-09-30 | Archer | Texas | 48009 | 87 | 1 |
585813 | 585813 | 2020-09-30 | Reagan | Texas | 48383 | 87 | 6 |
582388 | 582388 | 2020-09-29 | Archer | Texas | 48009 | 87 | 1 |
582573 | 582573 | 2020-09-29 | Reagan | Texas | 48383 | 87 | 6 |
579149 | 579149 | 2020-09-28 | Archer | Texas | 48009 | 87 | 1 |
579198 | 579198 | 2020-09-28 | Crosby | Texas | 48107 | 87 | 3 |
579334 | 579334 | 2020-09-28 | Reagan | Texas | 48383 | 87 | 6 |
575908 | 575908 | 2020-09-27 | Archer | Texas | 48009 | 87 | 1 |
575957 | 575957 | 2020-09-27 | Crosby | Texas | 48107 | 87 | 3 |
576093 | 576093 | 2020-09-27 | Reagan | Texas | 48383 | 87 | 6 |
572664 | 572664 | 2020-09-26 | Archer | Texas | 48009 | 87 | 1 |
572713 | 572713 | 2020-09-26 | Crosby | Texas | 48107 | 87 | 3 |
572849 | 572849 | 2020-09-26 | Reagan | Texas | 48383 | 87 | 6 |
569447 | 569447 | 2020-09-25 | Callahan | Texas | 48059 | 87 | 3 |
569583 | 569583 | 2020-09-25 | Mitchell | Texas | 48335 | 87 | 1 |
569607 | 569607 | 2020-09-25 | Reagan | Texas | 48383 | 87 | 6 |
566206 | 566206 | 2020-09-24 | Callahan | Texas | 48059 | 87 | 3 |
566342 | 566342 | 2020-09-24 | Mitchell | Texas | 48335 | 87 | 1 |
566366 | 566366 | 2020-09-24 | Reagan | Texas | 48383 | 87 | 6 |
563125 | 563125 | 2020-09-23 | Reagan | Texas | 48383 | 87 | 6 |
559750 | 559750 | 2020-09-22 | Crosby | Texas | 48107 | 87 | 3 |
559886 | 559886 | 2020-09-22 | Reagan | Texas | 48383 | 87 | 6 |
556650 | 556650 | 2020-09-21 | Reagan | Texas | 48383 | 87 | 6 |
553413 | 553413 | 2020-09-20 | Reagan | Texas | 48383 | 87 | 6 |
550174 | 550174 | 2020-09-19 | Reagan | Texas | 48383 | 87 | 6 |
521006 | 521006 | 2020-09-10 | Lynn | Texas | 48305 | 87 | 5 |
517770 | 517770 | 2020-09-09 | Lynn | Texas | 48305 | 87 | 5 |
514535 | 514535 | 2020-09-08 | Lynn | Texas | 48305 | 87 | 5 |
511302 | 511302 | 2020-09-07 | Lynn | Texas | 48305 | 87 | 5 |
508069 | 508069 | 2020-09-06 | Lynn | Texas | 48305 | 87 | 5 |
504837 | 504837 | 2020-09-05 | Lynn | Texas | 48305 | 87 | 4 |
478846 | 478846 | 2020-08-28 | Callahan | Texas | 48059 | 87 | 3 |
453193 | 453193 | 2020-08-20 | Swisher | Texas | 48437 | 87 | 3 |
420909 | 420909 | 2020-08-10 | Real | Texas | 48385 | 87 | 1 |
417688 | 417688 | 2020-08-09 | Real | Texas | 48385 | 87 | 1 |
414467 | 414467 | 2020-08-08 | Real | Texas | 48385 | 87 | 1 |
411247 | 411247 | 2020-08-07 | Real | Texas | 48385 | 87 | 1 |
408028 | 408028 | 2020-08-06 | Real | Texas | 48385 | 87 | 1 |
401479 | 401479 | 2020-08-04 | Franklin | Texas | 48159 | 87 | 1 |
398207 | 398207 | 2020-08-03 | Brooks | Texas | 48047 | 87 | 1 |
375730 | 375730 | 2020-07-27 | Dimmit | Texas | 48127 | 87 | 0 |
372517 | 372517 | 2020-07-26 | Dimmit | Texas | 48127 | 87 | 0 |
369305 | 369305 | 2020-07-25 | Dimmit | Texas | 48127 | 87 | 0 |
343726 | 343726 | 2020-07-17 | Hutchinson | Texas | 48233 | 87 | 1 |
337352 | 337352 | 2020-07-15 | La Salle | Texas | 48283 | 87 | 0 |
334157 | 334157 | 2020-07-14 | La Salle | Texas | 48283 | 87 | 0 |
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);