ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where county = "Gaines", deaths = 36 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 |
---|---|---|---|---|---|---|---|
991296 | 991296 | 2021-02-02 | Gaines | Texas | 48165 | 1382 | 36 |
988050 | 988050 | 2021-02-01 | Gaines | Texas | 48165 | 1382 | 36 |
984803 | 984803 | 2021-01-31 | Gaines | Texas | 48165 | 1382 | 36 |
981556 | 981556 | 2021-01-30 | Gaines | Texas | 48165 | 1379 | 36 |
978310 | 978310 | 2021-01-29 | Gaines | Texas | 48165 | 1379 | 36 |
975065 | 975065 | 2021-01-28 | Gaines | Texas | 48165 | 1379 | 36 |
971820 | 971820 | 2021-01-27 | Gaines | Texas | 48165 | 1376 | 36 |
968575 | 968575 | 2021-01-26 | Gaines | Texas | 48165 | 1354 | 36 |
965331 | 965331 | 2021-01-25 | Gaines | Texas | 48165 | 1354 | 36 |
962086 | 962086 | 2021-01-24 | Gaines | Texas | 48165 | 1354 | 36 |
958841 | 958841 | 2021-01-23 | Gaines | Texas | 48165 | 1354 | 36 |
955595 | 955595 | 2021-01-22 | Gaines | Texas | 48165 | 1346 | 36 |
952350 | 952350 | 2021-01-21 | Gaines | Texas | 48165 | 1310 | 36 |
949105 | 949105 | 2021-01-20 | Gaines | Texas | 48165 | 1302 | 36 |
945859 | 945859 | 2021-01-19 | Gaines | Texas | 48165 | 1302 | 36 |
942612 | 942612 | 2021-01-18 | Gaines | Texas | 48165 | 1302 | 36 |
939367 | 939367 | 2021-01-17 | Gaines | Texas | 48165 | 1302 | 36 |
936122 | 936122 | 2021-01-16 | Gaines | Texas | 48165 | 1295 | 36 |
932877 | 932877 | 2021-01-15 | Gaines | Texas | 48165 | 1295 | 36 |
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);