ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where county = "DeWitt", deaths = 44 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 |
---|---|---|---|---|---|---|---|
767341 | 767341 | 2020-11-25 | DeWitt | Texas | 48123 | 1206 | 44 |
764096 | 764096 | 2020-11-24 | DeWitt | Texas | 48123 | 1205 | 44 |
760851 | 760851 | 2020-11-23 | DeWitt | Texas | 48123 | 1193 | 44 |
757606 | 757606 | 2020-11-22 | DeWitt | Texas | 48123 | 1190 | 44 |
754359 | 754359 | 2020-11-21 | DeWitt | Texas | 48123 | 1190 | 44 |
751113 | 751113 | 2020-11-20 | DeWitt | Texas | 48123 | 1167 | 44 |
747867 | 747867 | 2020-11-19 | DeWitt | Texas | 48123 | 1167 | 44 |
744621 | 744621 | 2020-11-18 | DeWitt | Texas | 48123 | 1167 | 44 |
741374 | 741374 | 2020-11-17 | DeWitt | Texas | 48123 | 1167 | 44 |
738128 | 738128 | 2020-11-16 | DeWitt | Texas | 48123 | 1129 | 44 |
734884 | 734884 | 2020-11-15 | DeWitt | Texas | 48123 | 1128 | 44 |
731638 | 731638 | 2020-11-14 | DeWitt | Texas | 48123 | 1128 | 44 |
728393 | 728393 | 2020-11-13 | DeWitt | Texas | 48123 | 1129 | 44 |
725150 | 725150 | 2020-11-12 | DeWitt | Texas | 48123 | 1129 | 44 |
721907 | 721907 | 2020-11-11 | DeWitt | Texas | 48123 | 1128 | 44 |
718664 | 718664 | 2020-11-10 | DeWitt | Texas | 48123 | 1112 | 44 |
715421 | 715421 | 2020-11-09 | DeWitt | Texas | 48123 | 1109 | 44 |
712177 | 712177 | 2020-11-08 | DeWitt | Texas | 48123 | 1109 | 44 |
708933 | 708933 | 2020-11-07 | DeWitt | Texas | 48123 | 1109 | 44 |
705689 | 705689 | 2020-11-06 | DeWitt | Texas | 48123 | 1110 | 44 |
702446 | 702446 | 2020-11-05 | DeWitt | Texas | 48123 | 1111 | 44 |
699203 | 699203 | 2020-11-04 | DeWitt | Texas | 48123 | 1103 | 44 |
695959 | 695959 | 2020-11-03 | DeWitt | Texas | 48123 | 1103 | 44 |
692717 | 692717 | 2020-11-02 | DeWitt | Texas | 48123 | 1103 | 44 |
689473 | 689473 | 2020-11-01 | DeWitt | Texas | 48123 | 1087 | 44 |
686228 | 686228 | 2020-10-31 | DeWitt | Texas | 48123 | 1087 | 44 |
682985 | 682985 | 2020-10-30 | DeWitt | Texas | 48123 | 1086 | 44 |
679742 | 679742 | 2020-10-29 | DeWitt | Texas | 48123 | 1086 | 44 |
676499 | 676499 | 2020-10-28 | DeWitt | Texas | 48123 | 1086 | 44 |
673256 | 673256 | 2020-10-27 | DeWitt | Texas | 48123 | 1084 | 44 |
670014 | 670014 | 2020-10-26 | DeWitt | Texas | 48123 | 1078 | 44 |
666771 | 666771 | 2020-10-25 | DeWitt | Texas | 48123 | 1078 | 44 |
663526 | 663526 | 2020-10-24 | DeWitt | Texas | 48123 | 1078 | 44 |
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);