ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,504 rows where county = "Trinity" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
130463 | 130463 | 2020-05-10 | Trinity | California | 6105 | 1 | 0 |
133453 | 133453 | 2020-05-11 | Trinity | California | 6105 | 1 | 0 |
136443 | 136443 | 2020-05-12 | Trinity | California | 6105 | 2 | 0 |
139434 | 139434 | 2020-05-13 | Trinity | California | 6105 | 2 | 0 |
142430 | 142430 | 2020-05-14 | Trinity | California | 6105 | 2 | 0 |
145429 | 145429 | 2020-05-15 | Trinity | California | 6105 | 2 | 0 |
148433 | 148433 | 2020-05-16 | Trinity | California | 6105 | 2 | 0 |
151442 | 151442 | 2020-05-17 | Trinity | California | 6105 | 2 | 0 |
154454 | 154454 | 2020-05-18 | Trinity | California | 6105 | 2 | 0 |
157470 | 157470 | 2020-05-19 | Trinity | California | 6105 | 2 | 0 |
160496 | 160496 | 2020-05-20 | Trinity | California | 6105 | 2 | 0 |
163524 | 163524 | 2020-05-21 | Trinity | California | 6105 | 2 | 0 |
166557 | 166557 | 2020-05-22 | Trinity | California | 6105 | 2 | 0 |
169594 | 169594 | 2020-05-23 | Trinity | California | 6105 | 2 | 0 |
172635 | 172635 | 2020-05-24 | Trinity | California | 6105 | 2 | 0 |
175679 | 175679 | 2020-05-25 | Trinity | California | 6105 | 2 | 0 |
178723 | 178723 | 2020-05-26 | Trinity | California | 6105 | 2 | 0 |
181767 | 181767 | 2020-05-27 | Trinity | California | 6105 | 2 | 0 |
184821 | 184821 | 2020-05-28 | Trinity | California | 6105 | 2 | 0 |
187877 | 187877 | 2020-05-29 | Trinity | California | 6105 | 2 | 0 |
190942 | 190942 | 2020-05-30 | Trinity | California | 6105 | 2 | 0 |
194009 | 194009 | 2020-05-31 | Trinity | California | 6105 | 2 | 0 |
197079 | 197079 | 2020-06-01 | Trinity | California | 6105 | 2 | 0 |
200152 | 200152 | 2020-06-02 | Trinity | California | 6105 | 2 | 0 |
203228 | 203228 | 2020-06-03 | Trinity | California | 6105 | 2 | 0 |
206308 | 206308 | 2020-06-04 | Trinity | California | 6105 | 2 | 0 |
209389 | 209389 | 2020-06-05 | Trinity | California | 6105 | 3 | 0 |
212474 | 212474 | 2020-06-06 | Trinity | California | 6105 | 3 | 0 |
215561 | 215561 | 2020-06-07 | Trinity | California | 6105 | 3 | 0 |
218652 | 218652 | 2020-06-08 | Trinity | California | 6105 | 3 | 0 |
221747 | 221747 | 2020-06-09 | Trinity | California | 6105 | 3 | 0 |
224842 | 224842 | 2020-06-10 | Trinity | California | 6105 | 3 | 0 |
227944 | 227944 | 2020-06-11 | Trinity | California | 6105 | 3 | 0 |
231047 | 231047 | 2020-06-12 | Trinity | California | 6105 | 3 | 0 |
234153 | 234153 | 2020-06-13 | Trinity | California | 6105 | 3 | 0 |
237260 | 237260 | 2020-06-14 | Trinity | California | 6105 | 3 | 0 |
240368 | 240368 | 2020-06-15 | Trinity | California | 6105 | 3 | 0 |
243479 | 243479 | 2020-06-16 | Trinity | California | 6105 | 3 | 0 |
246592 | 246592 | 2020-06-17 | Trinity | California | 6105 | 3 | 0 |
249704 | 249704 | 2020-06-18 | Trinity | California | 6105 | 3 | 0 |
252819 | 252819 | 2020-06-19 | Trinity | California | 6105 | 3 | 0 |
255938 | 255938 | 2020-06-20 | Trinity | California | 6105 | 3 | 0 |
259065 | 259065 | 2020-06-21 | Trinity | California | 6105 | 3 | 0 |
262192 | 262192 | 2020-06-22 | Trinity | California | 6105 | 3 | 0 |
265320 | 265320 | 2020-06-23 | Trinity | California | 6105 | 3 | 0 |
268450 | 268450 | 2020-06-24 | Trinity | California | 6105 | 3 | 0 |
271585 | 271585 | 2020-06-25 | Trinity | California | 6105 | 3 | 0 |
274725 | 274725 | 2020-06-26 | Trinity | California | 6105 | 3 | 0 |
277873 | 277873 | 2020-06-27 | Trinity | California | 6105 | 3 | 0 |
281020 | 281020 | 2020-06-28 | Trinity | California | 6105 | 3 | 0 |
284166 | 284166 | 2020-06-29 | Trinity | California | 6105 | 3 | 0 |
287312 | 287312 | 2020-06-30 | Trinity | California | 6105 | 3 | 0 |
290463 | 290463 | 2020-07-01 | Trinity | California | 6105 | 3 | 0 |
293617 | 293617 | 2020-07-02 | Trinity | California | 6105 | 3 | 0 |
296773 | 296773 | 2020-07-03 | Trinity | California | 6105 | 3 | 0 |
299935 | 299935 | 2020-07-04 | Trinity | California | 6105 | 3 | 0 |
303099 | 303099 | 2020-07-05 | Trinity | California | 6105 | 3 | 0 |
306263 | 306263 | 2020-07-06 | Trinity | California | 6105 | 3 | 0 |
309431 | 309431 | 2020-07-07 | Trinity | California | 6105 | 3 | 0 |
312601 | 312601 | 2020-07-08 | Trinity | California | 6105 | 3 | 0 |
315776 | 315776 | 2020-07-09 | Trinity | California | 6105 | 3 | 0 |
318949 | 318949 | 2020-07-10 | Trinity | California | 6105 | 3 | 0 |
322128 | 322128 | 2020-07-11 | Trinity | California | 6105 | 3 | 0 |
325309 | 325309 | 2020-07-12 | Trinity | California | 6105 | 3 | 0 |
328495 | 328495 | 2020-07-13 | Trinity | California | 6105 | 3 | 0 |
331681 | 331681 | 2020-07-14 | Trinity | California | 6105 | 3 | 0 |
334874 | 334874 | 2020-07-15 | Trinity | California | 6105 | 3 | 0 |
338069 | 338069 | 2020-07-16 | Trinity | California | 6105 | 3 | 0 |
341265 | 341265 | 2020-07-17 | Trinity | California | 6105 | 3 | 0 |
344464 | 344464 | 2020-07-18 | Trinity | California | 6105 | 3 | 0 |
347664 | 347664 | 2020-07-19 | Trinity | California | 6105 | 3 | 0 |
350865 | 350865 | 2020-07-20 | Trinity | California | 6105 | 3 | 0 |
354067 | 354067 | 2020-07-21 | Trinity | California | 6105 | 3 | 0 |
357270 | 357270 | 2020-07-22 | Trinity | California | 6105 | 3 | 0 |
360475 | 360475 | 2020-07-23 | Trinity | California | 6105 | 4 | 0 |
363682 | 363682 | 2020-07-24 | Trinity | California | 6105 | 4 | 0 |
366889 | 366889 | 2020-07-25 | Trinity | California | 6105 | 4 | 0 |
370099 | 370099 | 2020-07-26 | Trinity | California | 6105 | 4 | 0 |
373311 | 373311 | 2020-07-27 | Trinity | California | 6105 | 4 | 0 |
376525 | 376525 | 2020-07-28 | Trinity | California | 6105 | 4 | 0 |
379742 | 379742 | 2020-07-29 | Trinity | California | 6105 | 4 | 0 |
382959 | 382959 | 2020-07-30 | Trinity | California | 6105 | 5 | 0 |
386177 | 386177 | 2020-07-31 | Trinity | California | 6105 | 5 | 0 |
389394 | 389394 | 2020-08-01 | Trinity | California | 6105 | 6 | 0 |
392611 | 392611 | 2020-08-02 | Trinity | California | 6105 | 6 | 0 |
395827 | 395827 | 2020-08-03 | Trinity | California | 6105 | 6 | 0 |
399043 | 399043 | 2020-08-04 | Trinity | California | 6105 | 6 | 0 |
402259 | 402259 | 2020-08-05 | Trinity | California | 6105 | 6 | 0 |
405477 | 405477 | 2020-08-06 | Trinity | California | 6105 | 6 | 0 |
408697 | 408697 | 2020-08-07 | Trinity | California | 6105 | 6 | 0 |
411916 | 411916 | 2020-08-08 | Trinity | California | 6105 | 6 | 0 |
415136 | 415136 | 2020-08-09 | Trinity | California | 6105 | 6 | 0 |
418357 | 418357 | 2020-08-10 | Trinity | California | 6105 | 6 | 0 |
421578 | 421578 | 2020-08-11 | Trinity | California | 6105 | 6 | 0 |
424799 | 424799 | 2020-08-12 | Trinity | California | 6105 | 6 | 0 |
428023 | 428023 | 2020-08-13 | Trinity | California | 6105 | 7 | 0 |
431251 | 431251 | 2020-08-14 | Trinity | California | 6105 | 7 | 0 |
434476 | 434476 | 2020-08-15 | Trinity | California | 6105 | 7 | 0 |
437702 | 437702 | 2020-08-16 | Trinity | California | 6105 | 7 | 0 |
440928 | 440928 | 2020-08-17 | Trinity | California | 6105 | 9 | 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);