ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where county = "Stonewall", deaths = 1 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
764254 | 764254 | 2020-11-24 | Stonewall | Texas | 48433 | 24 | 1 |
761009 | 761009 | 2020-11-23 | Stonewall | Texas | 48433 | 24 | 1 |
757764 | 757764 | 2020-11-22 | Stonewall | Texas | 48433 | 24 | 1 |
754517 | 754517 | 2020-11-21 | Stonewall | Texas | 48433 | 24 | 1 |
751271 | 751271 | 2020-11-20 | Stonewall | Texas | 48433 | 24 | 1 |
748025 | 748025 | 2020-11-19 | Stonewall | Texas | 48433 | 24 | 1 |
744779 | 744779 | 2020-11-18 | Stonewall | Texas | 48433 | 24 | 1 |
741532 | 741532 | 2020-11-17 | Stonewall | Texas | 48433 | 24 | 1 |
738285 | 738285 | 2020-11-16 | Stonewall | Texas | 48433 | 24 | 1 |
735041 | 735041 | 2020-11-15 | Stonewall | Texas | 48433 | 24 | 1 |
731795 | 731795 | 2020-11-14 | Stonewall | Texas | 48433 | 24 | 1 |
728550 | 728550 | 2020-11-13 | Stonewall | Texas | 48433 | 23 | 1 |
725307 | 725307 | 2020-11-12 | Stonewall | Texas | 48433 | 22 | 1 |
722064 | 722064 | 2020-11-11 | Stonewall | Texas | 48433 | 22 | 1 |
718821 | 718821 | 2020-11-10 | Stonewall | Texas | 48433 | 21 | 1 |
715578 | 715578 | 2020-11-09 | Stonewall | Texas | 48433 | 21 | 1 |
712334 | 712334 | 2020-11-08 | Stonewall | Texas | 48433 | 21 | 1 |
709090 | 709090 | 2020-11-07 | Stonewall | Texas | 48433 | 21 | 1 |
705846 | 705846 | 2020-11-06 | Stonewall | Texas | 48433 | 21 | 1 |
702603 | 702603 | 2020-11-05 | Stonewall | Texas | 48433 | 21 | 1 |
699360 | 699360 | 2020-11-04 | Stonewall | Texas | 48433 | 21 | 1 |
696116 | 696116 | 2020-11-03 | Stonewall | Texas | 48433 | 21 | 1 |
692874 | 692874 | 2020-11-02 | Stonewall | Texas | 48433 | 21 | 1 |
689630 | 689630 | 2020-11-01 | Stonewall | Texas | 48433 | 21 | 1 |
686385 | 686385 | 2020-10-31 | Stonewall | Texas | 48433 | 21 | 1 |
683142 | 683142 | 2020-10-30 | Stonewall | Texas | 48433 | 21 | 1 |
679899 | 679899 | 2020-10-29 | Stonewall | Texas | 48433 | 19 | 1 |
676656 | 676656 | 2020-10-28 | Stonewall | Texas | 48433 | 19 | 1 |
673413 | 673413 | 2020-10-27 | Stonewall | Texas | 48433 | 19 | 1 |
670171 | 670171 | 2020-10-26 | Stonewall | Texas | 48433 | 19 | 1 |
666928 | 666928 | 2020-10-25 | Stonewall | Texas | 48433 | 19 | 1 |
663683 | 663683 | 2020-10-24 | Stonewall | Texas | 48433 | 19 | 1 |
660439 | 660439 | 2020-10-23 | Stonewall | Texas | 48433 | 18 | 1 |
657195 | 657195 | 2020-10-22 | Stonewall | Texas | 48433 | 18 | 1 |
653950 | 653950 | 2020-10-21 | Stonewall | Texas | 48433 | 18 | 1 |
650705 | 650705 | 2020-10-20 | Stonewall | Texas | 48433 | 18 | 1 |
647461 | 647461 | 2020-10-19 | Stonewall | Texas | 48433 | 18 | 1 |
644215 | 644215 | 2020-10-18 | Stonewall | Texas | 48433 | 18 | 1 |
640967 | 640967 | 2020-10-17 | Stonewall | Texas | 48433 | 18 | 1 |
637720 | 637720 | 2020-10-16 | Stonewall | Texas | 48433 | 17 | 1 |
634475 | 634475 | 2020-10-15 | Stonewall | Texas | 48433 | 17 | 1 |
631230 | 631230 | 2020-10-14 | Stonewall | Texas | 48433 | 17 | 1 |
627986 | 627986 | 2020-10-13 | Stonewall | Texas | 48433 | 17 | 1 |
624743 | 624743 | 2020-10-12 | Stonewall | Texas | 48433 | 16 | 1 |
621500 | 621500 | 2020-10-11 | Stonewall | Texas | 48433 | 16 | 1 |
618257 | 618257 | 2020-10-10 | Stonewall | Texas | 48433 | 16 | 1 |
615015 | 615015 | 2020-10-09 | Stonewall | Texas | 48433 | 16 | 1 |
611774 | 611774 | 2020-10-08 | Stonewall | Texas | 48433 | 16 | 1 |
608532 | 608532 | 2020-10-07 | Stonewall | Texas | 48433 | 16 | 1 |
605289 | 605289 | 2020-10-06 | Stonewall | Texas | 48433 | 16 | 1 |
602047 | 602047 | 2020-10-05 | Stonewall | Texas | 48433 | 16 | 1 |
598804 | 598804 | 2020-10-04 | Stonewall | Texas | 48433 | 16 | 1 |
595561 | 595561 | 2020-10-03 | Stonewall | Texas | 48433 | 16 | 1 |
592319 | 592319 | 2020-10-02 | Stonewall | Texas | 48433 | 16 | 1 |
589079 | 589079 | 2020-10-01 | Stonewall | Texas | 48433 | 16 | 1 |
585838 | 585838 | 2020-09-30 | Stonewall | Texas | 48433 | 14 | 1 |
582598 | 582598 | 2020-09-29 | Stonewall | Texas | 48433 | 14 | 1 |
579359 | 579359 | 2020-09-28 | Stonewall | Texas | 48433 | 14 | 1 |
576118 | 576118 | 2020-09-27 | Stonewall | Texas | 48433 | 14 | 1 |
572874 | 572874 | 2020-09-26 | Stonewall | Texas | 48433 | 14 | 1 |
569632 | 569632 | 2020-09-25 | Stonewall | Texas | 48433 | 14 | 1 |
566391 | 566391 | 2020-09-24 | Stonewall | Texas | 48433 | 14 | 1 |
563150 | 563150 | 2020-09-23 | Stonewall | Texas | 48433 | 14 | 1 |
559911 | 559911 | 2020-09-22 | Stonewall | Texas | 48433 | 12 | 1 |
556675 | 556675 | 2020-09-21 | Stonewall | Texas | 48433 | 11 | 1 |
553438 | 553438 | 2020-09-20 | Stonewall | Texas | 48433 | 11 | 1 |
550199 | 550199 | 2020-09-19 | Stonewall | Texas | 48433 | 11 | 1 |
546960 | 546960 | 2020-09-18 | Stonewall | Texas | 48433 | 11 | 1 |
543723 | 543723 | 2020-09-17 | Stonewall | Texas | 48433 | 11 | 1 |
540487 | 540487 | 2020-09-16 | Stonewall | Texas | 48433 | 10 | 1 |
537250 | 537250 | 2020-09-15 | Stonewall | Texas | 48433 | 10 | 1 |
534014 | 534014 | 2020-09-14 | Stonewall | Texas | 48433 | 10 | 1 |
530779 | 530779 | 2020-09-13 | Stonewall | Texas | 48433 | 10 | 1 |
527542 | 527542 | 2020-09-12 | Stonewall | Texas | 48433 | 10 | 1 |
524306 | 524306 | 2020-09-11 | Stonewall | Texas | 48433 | 9 | 1 |
521070 | 521070 | 2020-09-10 | Stonewall | Texas | 48433 | 9 | 1 |
517834 | 517834 | 2020-09-09 | Stonewall | Texas | 48433 | 9 | 1 |
514599 | 514599 | 2020-09-08 | Stonewall | Texas | 48433 | 9 | 1 |
511366 | 511366 | 2020-09-07 | Stonewall | Texas | 48433 | 9 | 1 |
508133 | 508133 | 2020-09-06 | Stonewall | Texas | 48433 | 9 | 1 |
504901 | 504901 | 2020-09-05 | Stonewall | Texas | 48433 | 9 | 1 |
501667 | 501667 | 2020-09-04 | Stonewall | Texas | 48433 | 9 | 1 |
498433 | 498433 | 2020-09-03 | Stonewall | Texas | 48433 | 10 | 1 |
495200 | 495200 | 2020-09-02 | Stonewall | Texas | 48433 | 10 | 1 |
491966 | 491966 | 2020-09-01 | Stonewall | Texas | 48433 | 10 | 1 |
488733 | 488733 | 2020-08-31 | Stonewall | Texas | 48433 | 10 | 1 |
485500 | 485500 | 2020-08-30 | Stonewall | Texas | 48433 | 10 | 1 |
482265 | 482265 | 2020-08-29 | Stonewall | Texas | 48433 | 10 | 1 |
479031 | 479031 | 2020-08-28 | Stonewall | Texas | 48433 | 10 | 1 |
475798 | 475798 | 2020-08-27 | Stonewall | Texas | 48433 | 9 | 1 |
472565 | 472565 | 2020-08-26 | Stonewall | Texas | 48433 | 9 | 1 |
469333 | 469333 | 2020-08-25 | Stonewall | Texas | 48433 | 8 | 1 |
466104 | 466104 | 2020-08-24 | Stonewall | Texas | 48433 | 7 | 1 |
462875 | 462875 | 2020-08-23 | Stonewall | Texas | 48433 | 7 | 1 |
459646 | 459646 | 2020-08-22 | Stonewall | Texas | 48433 | 7 | 1 |
456419 | 456419 | 2020-08-21 | Stonewall | Texas | 48433 | 7 | 1 |
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);