ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where county = "Robertson", deaths = 40 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1283611 | 1283611 | 2021-05-03 | Robertson | Texas | 48395 | 2121 | 40 |
1280364 | 1280364 | 2021-05-02 | Robertson | Texas | 48395 | 2117 | 40 |
1277117 | 1277117 | 2021-05-01 | Robertson | Texas | 48395 | 2117 | 40 |
1273870 | 1273870 | 2021-04-30 | Robertson | Texas | 48395 | 2114 | 40 |
1270623 | 1270623 | 2021-04-29 | Robertson | Texas | 48395 | 2111 | 40 |
1267376 | 1267376 | 2021-04-28 | Robertson | Texas | 48395 | 2107 | 40 |
1264129 | 1264129 | 2021-04-27 | Robertson | Texas | 48395 | 2102 | 40 |
1260882 | 1260882 | 2021-04-26 | Robertson | Texas | 48395 | 2100 | 40 |
1257635 | 1257635 | 2021-04-25 | Robertson | Texas | 48395 | 2097 | 40 |
1254388 | 1254388 | 2021-04-24 | Robertson | Texas | 48395 | 2097 | 40 |
1251141 | 1251141 | 2021-04-23 | Robertson | Texas | 48395 | 2096 | 40 |
1247894 | 1247894 | 2021-04-22 | Robertson | Texas | 48395 | 2091 | 40 |
1244647 | 1244647 | 2021-04-21 | Robertson | Texas | 48395 | 2089 | 40 |
1241400 | 1241400 | 2021-04-20 | Robertson | Texas | 48395 | 2086 | 40 |
1238153 | 1238153 | 2021-04-19 | Robertson | Texas | 48395 | 2079 | 40 |
1234906 | 1234906 | 2021-04-18 | Robertson | Texas | 48395 | 2075 | 40 |
1231658 | 1231658 | 2021-04-17 | Robertson | Texas | 48395 | 2075 | 40 |
1228410 | 1228410 | 2021-04-16 | Robertson | Texas | 48395 | 2075 | 40 |
1225162 | 1225162 | 2021-04-15 | Robertson | Texas | 48395 | 2075 | 40 |
1221915 | 1221915 | 2021-04-14 | Robertson | Texas | 48395 | 2074 | 40 |
1218667 | 1218667 | 2021-04-13 | Robertson | Texas | 48395 | 2073 | 40 |
1215419 | 1215419 | 2021-04-12 | Robertson | Texas | 48395 | 2072 | 40 |
1212172 | 1212172 | 2021-04-11 | Robertson | Texas | 48395 | 2069 | 40 |
1208923 | 1208923 | 2021-04-10 | Robertson | Texas | 48395 | 2069 | 40 |
1205675 | 1205675 | 2021-04-09 | Robertson | Texas | 48395 | 2067 | 40 |
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);