ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where county = "San Saba", deaths = 17 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 |
---|---|---|---|---|---|---|---|
1017385 | 1017385 | 2021-02-10 | San Saba | Texas | 48411 | 823 | 17 |
1014140 | 1014140 | 2021-02-09 | San Saba | Texas | 48411 | 827 | 17 |
1010895 | 1010895 | 2021-02-08 | San Saba | Texas | 48411 | 782 | 17 |
1007649 | 1007649 | 2021-02-07 | San Saba | Texas | 48411 | 761 | 17 |
1004403 | 1004403 | 2021-02-06 | San Saba | Texas | 48411 | 761 | 17 |
1001157 | 1001157 | 2021-02-05 | San Saba | Texas | 48411 | 746 | 17 |
997911 | 997911 | 2021-02-04 | San Saba | Texas | 48411 | 742 | 17 |
994665 | 994665 | 2021-02-03 | San Saba | Texas | 48411 | 731 | 17 |
991419 | 991419 | 2021-02-02 | San Saba | Texas | 48411 | 723 | 17 |
988173 | 988173 | 2021-02-01 | San Saba | Texas | 48411 | 704 | 17 |
984926 | 984926 | 2021-01-31 | San Saba | Texas | 48411 | 575 | 17 |
981679 | 981679 | 2021-01-30 | San Saba | Texas | 48411 | 572 | 17 |
978433 | 978433 | 2021-01-29 | San Saba | Texas | 48411 | 551 | 17 |
975188 | 975188 | 2021-01-28 | San Saba | Texas | 48411 | 538 | 17 |
971943 | 971943 | 2021-01-27 | San Saba | Texas | 48411 | 530 | 17 |
968698 | 968698 | 2021-01-26 | San Saba | Texas | 48411 | 515 | 17 |
965454 | 965454 | 2021-01-25 | San Saba | Texas | 48411 | 508 | 17 |
962209 | 962209 | 2021-01-24 | San Saba | Texas | 48411 | 508 | 17 |
958964 | 958964 | 2021-01-23 | San Saba | Texas | 48411 | 508 | 17 |
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);