ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
543 rows where fips = 48301 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923209 | 923209 | 2021-01-12 | Loving | Texas | 48301 | 1 | 0 |
919964 | 919964 | 2021-01-11 | Loving | Texas | 48301 | 1 | 0 |
916719 | 916719 | 2021-01-10 | Loving | Texas | 48301 | 1 | 0 |
913474 | 913474 | 2021-01-09 | Loving | Texas | 48301 | 1 | 0 |
910229 | 910229 | 2021-01-08 | Loving | Texas | 48301 | 1 | 0 |
906984 | 906984 | 2021-01-07 | Loving | Texas | 48301 | 1 | 0 |
903738 | 903738 | 2021-01-06 | Loving | Texas | 48301 | 1 | 0 |
900493 | 900493 | 2021-01-05 | Loving | Texas | 48301 | 1 | 0 |
897248 | 897248 | 2021-01-04 | Loving | Texas | 48301 | 1 | 0 |
894002 | 894002 | 2021-01-03 | Loving | Texas | 48301 | 1 | 0 |
890756 | 890756 | 2021-01-02 | Loving | Texas | 48301 | 1 | 0 |
887509 | 887509 | 2021-01-01 | Loving | Texas | 48301 | 1 | 0 |
884264 | 884264 | 2020-12-31 | Loving | Texas | 48301 | 1 | 0 |
881019 | 881019 | 2020-12-30 | Loving | Texas | 48301 | 1 | 0 |
877774 | 877774 | 2020-12-29 | Loving | Texas | 48301 | 1 | 0 |
874529 | 874529 | 2020-12-28 | Loving | Texas | 48301 | 1 | 0 |
871284 | 871284 | 2020-12-27 | Loving | Texas | 48301 | 1 | 0 |
868039 | 868039 | 2020-12-26 | Loving | Texas | 48301 | 1 | 0 |
864794 | 864794 | 2020-12-25 | Loving | Texas | 48301 | 1 | 0 |
861549 | 861549 | 2020-12-24 | Loving | Texas | 48301 | 1 | 0 |
858304 | 858304 | 2020-12-23 | Loving | Texas | 48301 | 1 | 0 |
855059 | 855059 | 2020-12-22 | Loving | Texas | 48301 | 1 | 0 |
851814 | 851814 | 2020-12-21 | Loving | Texas | 48301 | 1 | 0 |
848569 | 848569 | 2020-12-20 | Loving | Texas | 48301 | 1 | 0 |
845324 | 845324 | 2020-12-19 | Loving | Texas | 48301 | 1 | 0 |
842078 | 842078 | 2020-12-18 | Loving | Texas | 48301 | 1 | 0 |
838833 | 838833 | 2020-12-17 | Loving | Texas | 48301 | 1 | 0 |
835587 | 835587 | 2020-12-16 | Loving | Texas | 48301 | 1 | 0 |
832341 | 832341 | 2020-12-15 | Loving | Texas | 48301 | 1 | 0 |
829094 | 829094 | 2020-12-14 | Loving | Texas | 48301 | 1 | 0 |
825848 | 825848 | 2020-12-13 | Loving | Texas | 48301 | 1 | 0 |
822601 | 822601 | 2020-12-12 | Loving | Texas | 48301 | 1 | 0 |
819355 | 819355 | 2020-12-11 | Loving | Texas | 48301 | 1 | 0 |
816109 | 816109 | 2020-12-10 | Loving | Texas | 48301 | 1 | 0 |
812863 | 812863 | 2020-12-09 | Loving | Texas | 48301 | 1 | 0 |
809619 | 809619 | 2020-12-08 | Loving | Texas | 48301 | 1 | 0 |
806374 | 806374 | 2020-12-07 | Loving | Texas | 48301 | 1 | 0 |
803129 | 803129 | 2020-12-06 | Loving | Texas | 48301 | 1 | 0 |
799884 | 799884 | 2020-12-05 | Loving | Texas | 48301 | 1 | 0 |
796639 | 796639 | 2020-12-04 | Loving | Texas | 48301 | 1 | 0 |
793394 | 793394 | 2020-12-03 | Loving | Texas | 48301 | 1 | 0 |
790149 | 790149 | 2020-12-02 | Loving | Texas | 48301 | 1 | 0 |
786904 | 786904 | 2020-12-01 | Loving | Texas | 48301 | 1 | 0 |
783660 | 783660 | 2020-11-30 | Loving | Texas | 48301 | 1 | 0 |
780415 | 780415 | 2020-11-29 | Loving | Texas | 48301 | 1 | 0 |
777169 | 777169 | 2020-11-28 | Loving | Texas | 48301 | 1 | 0 |
773924 | 773924 | 2020-11-27 | Loving | Texas | 48301 | 1 | 0 |
770679 | 770679 | 2020-11-26 | Loving | Texas | 48301 | 1 | 0 |
767433 | 767433 | 2020-11-25 | Loving | Texas | 48301 | 1 | 0 |
764188 | 764188 | 2020-11-24 | Loving | Texas | 48301 | 1 | 0 |
760943 | 760943 | 2020-11-23 | Loving | Texas | 48301 | 1 | 0 |
757698 | 757698 | 2020-11-22 | Loving | Texas | 48301 | 1 | 0 |
754451 | 754451 | 2020-11-21 | Loving | Texas | 48301 | 1 | 0 |
751205 | 751205 | 2020-11-20 | Loving | Texas | 48301 | 1 | 0 |
747959 | 747959 | 2020-11-19 | Loving | Texas | 48301 | 1 | 0 |
744713 | 744713 | 2020-11-18 | Loving | Texas | 48301 | 1 | 0 |
741466 | 741466 | 2020-11-17 | Loving | Texas | 48301 | 1 | 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);