ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 4, county = "Jim Hogg" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
248989 | 248989 | 2020-06-17 | Jim Hogg | Texas | 48247 | 4 | 0 |
245876 | 245876 | 2020-06-16 | Jim Hogg | Texas | 48247 | 4 | 0 |
242764 | 242764 | 2020-06-15 | Jim Hogg | Texas | 48247 | 4 | 0 |
239654 | 239654 | 2020-06-14 | Jim Hogg | Texas | 48247 | 4 | 0 |
236546 | 236546 | 2020-06-13 | Jim Hogg | Texas | 48247 | 4 | 0 |
233440 | 233440 | 2020-06-12 | Jim Hogg | Texas | 48247 | 4 | 0 |
230336 | 230336 | 2020-06-11 | Jim Hogg | Texas | 48247 | 4 | 0 |
227232 | 227232 | 2020-06-10 | Jim Hogg | Texas | 48247 | 4 | 0 |
224132 | 224132 | 2020-06-09 | Jim Hogg | Texas | 48247 | 4 | 0 |
221037 | 221037 | 2020-06-08 | Jim Hogg | Texas | 48247 | 4 | 0 |
217945 | 217945 | 2020-06-07 | Jim Hogg | Texas | 48247 | 4 | 0 |
214855 | 214855 | 2020-06-06 | Jim Hogg | Texas | 48247 | 4 | 0 |
211768 | 211768 | 2020-06-05 | Jim Hogg | Texas | 48247 | 4 | 0 |
208684 | 208684 | 2020-06-04 | Jim Hogg | Texas | 48247 | 4 | 0 |
205602 | 205602 | 2020-06-03 | Jim Hogg | Texas | 48247 | 4 | 0 |
202523 | 202523 | 2020-06-02 | Jim Hogg | Texas | 48247 | 4 | 0 |
199447 | 199447 | 2020-06-01 | Jim Hogg | Texas | 48247 | 4 | 0 |
196374 | 196374 | 2020-05-31 | Jim Hogg | Texas | 48247 | 4 | 0 |
193304 | 193304 | 2020-05-30 | Jim Hogg | Texas | 48247 | 4 | 0 |
190239 | 190239 | 2020-05-29 | Jim Hogg | Texas | 48247 | 4 | 0 |
187175 | 187175 | 2020-05-28 | Jim Hogg | Texas | 48247 | 4 | 0 |
184118 | 184118 | 2020-05-27 | Jim Hogg | Texas | 48247 | 4 | 0 |
181068 | 181068 | 2020-05-26 | Jim Hogg | Texas | 48247 | 4 | 0 |
178024 | 178024 | 2020-05-25 | Jim Hogg | Texas | 48247 | 4 | 0 |
174980 | 174980 | 2020-05-24 | Jim Hogg | Texas | 48247 | 4 | 0 |
171937 | 171937 | 2020-05-23 | Jim Hogg | Texas | 48247 | 4 | 0 |
168897 | 168897 | 2020-05-22 | Jim Hogg | Texas | 48247 | 4 | 0 |
165861 | 165861 | 2020-05-21 | Jim Hogg | Texas | 48247 | 4 | 0 |
162832 | 162832 | 2020-05-20 | Jim Hogg | Texas | 48247 | 4 | 0 |
159804 | 159804 | 2020-05-19 | Jim Hogg | Texas | 48247 | 4 | 0 |
156782 | 156782 | 2020-05-18 | Jim Hogg | Texas | 48247 | 4 | 0 |
153765 | 153765 | 2020-05-17 | Jim Hogg | Texas | 48247 | 4 | 0 |
150754 | 150754 | 2020-05-16 | Jim Hogg | Texas | 48247 | 4 | 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);