ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
719 rows where fips = 16009 and state = "Idaho" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
175995 | 175995 | 2020-05-25 | Benewah | Idaho | 16009 | 1 | 0 |
179039 | 179039 | 2020-05-26 | Benewah | Idaho | 16009 | 3 | 0 |
182083 | 182083 | 2020-05-27 | Benewah | Idaho | 16009 | 7 | 0 |
185137 | 185137 | 2020-05-28 | Benewah | Idaho | 16009 | 9 | 0 |
188193 | 188193 | 2020-05-29 | Benewah | Idaho | 16009 | 8 | 0 |
191258 | 191258 | 2020-05-30 | Benewah | Idaho | 16009 | 8 | 0 |
194325 | 194325 | 2020-05-31 | Benewah | Idaho | 16009 | 8 | 0 |
197395 | 197395 | 2020-06-01 | Benewah | Idaho | 16009 | 12 | 0 |
200468 | 200468 | 2020-06-02 | Benewah | Idaho | 16009 | 12 | 0 |
203544 | 203544 | 2020-06-03 | Benewah | Idaho | 16009 | 14 | 0 |
206624 | 206624 | 2020-06-04 | Benewah | Idaho | 16009 | 17 | 0 |
209705 | 209705 | 2020-06-05 | Benewah | Idaho | 16009 | 17 | 0 |
212790 | 212790 | 2020-06-06 | Benewah | Idaho | 16009 | 18 | 0 |
215877 | 215877 | 2020-06-07 | Benewah | Idaho | 16009 | 18 | 0 |
218968 | 218968 | 2020-06-08 | Benewah | Idaho | 16009 | 18 | 0 |
222063 | 222063 | 2020-06-09 | Benewah | Idaho | 16009 | 17 | 0 |
225158 | 225158 | 2020-06-10 | Benewah | Idaho | 16009 | 19 | 0 |
228260 | 228260 | 2020-06-11 | Benewah | Idaho | 16009 | 19 | 0 |
231363 | 231363 | 2020-06-12 | Benewah | Idaho | 16009 | 19 | 0 |
234469 | 234469 | 2020-06-13 | Benewah | Idaho | 16009 | 19 | 0 |
237576 | 237576 | 2020-06-14 | Benewah | Idaho | 16009 | 19 | 0 |
240684 | 240684 | 2020-06-15 | Benewah | Idaho | 16009 | 18 | 0 |
243795 | 243795 | 2020-06-16 | Benewah | Idaho | 16009 | 19 | 0 |
246908 | 246908 | 2020-06-17 | Benewah | Idaho | 16009 | 20 | 0 |
250020 | 250020 | 2020-06-18 | Benewah | Idaho | 16009 | 20 | 0 |
253135 | 253135 | 2020-06-19 | Benewah | Idaho | 16009 | 21 | 0 |
256254 | 256254 | 2020-06-20 | Benewah | Idaho | 16009 | 21 | 0 |
259381 | 259381 | 2020-06-21 | Benewah | Idaho | 16009 | 21 | 0 |
262508 | 262508 | 2020-06-22 | Benewah | Idaho | 16009 | 21 | 0 |
265636 | 265636 | 2020-06-23 | Benewah | Idaho | 16009 | 21 | 0 |
268766 | 268766 | 2020-06-24 | Benewah | Idaho | 16009 | 21 | 0 |
271902 | 271902 | 2020-06-25 | Benewah | Idaho | 16009 | 21 | 0 |
275042 | 275042 | 2020-06-26 | Benewah | Idaho | 16009 | 21 | 0 |
278190 | 278190 | 2020-06-27 | Benewah | Idaho | 16009 | 21 | 0 |
281337 | 281337 | 2020-06-28 | Benewah | Idaho | 16009 | 21 | 0 |
284483 | 284483 | 2020-06-29 | Benewah | Idaho | 16009 | 21 | 0 |
287631 | 287631 | 2020-06-30 | Benewah | Idaho | 16009 | 21 | 0 |
290781 | 290781 | 2020-07-01 | Benewah | Idaho | 16009 | 21 | 0 |
293935 | 293935 | 2020-07-02 | Benewah | Idaho | 16009 | 21 | 0 |
297091 | 297091 | 2020-07-03 | Benewah | Idaho | 16009 | 21 | 0 |
300253 | 300253 | 2020-07-04 | Benewah | Idaho | 16009 | 23 | 0 |
303417 | 303417 | 2020-07-05 | Benewah | Idaho | 16009 | 23 | 0 |
306581 | 306581 | 2020-07-06 | Benewah | Idaho | 16009 | 23 | 0 |
309749 | 309749 | 2020-07-07 | Benewah | Idaho | 16009 | 23 | 0 |
312919 | 312919 | 2020-07-08 | Benewah | Idaho | 16009 | 23 | 0 |
316094 | 316094 | 2020-07-09 | Benewah | Idaho | 16009 | 23 | 0 |
319267 | 319267 | 2020-07-10 | Benewah | Idaho | 16009 | 24 | 0 |
322446 | 322446 | 2020-07-11 | Benewah | Idaho | 16009 | 29 | 0 |
325627 | 325627 | 2020-07-12 | Benewah | Idaho | 16009 | 29 | 0 |
328813 | 328813 | 2020-07-13 | Benewah | Idaho | 16009 | 29 | 0 |
332000 | 332000 | 2020-07-14 | Benewah | Idaho | 16009 | 29 | 0 |
335193 | 335193 | 2020-07-15 | Benewah | Idaho | 16009 | 29 | 0 |
338389 | 338389 | 2020-07-16 | Benewah | Idaho | 16009 | 34 | 0 |
341585 | 341585 | 2020-07-17 | Benewah | Idaho | 16009 | 34 | 0 |
344785 | 344785 | 2020-07-18 | Benewah | Idaho | 16009 | 35 | 0 |
347985 | 347985 | 2020-07-19 | Benewah | Idaho | 16009 | 36 | 0 |
351185 | 351185 | 2020-07-20 | Benewah | Idaho | 16009 | 36 | 0 |
354387 | 354387 | 2020-07-21 | Benewah | Idaho | 16009 | 37 | 0 |
357590 | 357590 | 2020-07-22 | Benewah | Idaho | 16009 | 37 | 0 |
360795 | 360795 | 2020-07-23 | Benewah | Idaho | 16009 | 38 | 0 |
364002 | 364002 | 2020-07-24 | Benewah | Idaho | 16009 | 39 | 0 |
367209 | 367209 | 2020-07-25 | Benewah | Idaho | 16009 | 41 | 0 |
370419 | 370419 | 2020-07-26 | Benewah | Idaho | 16009 | 42 | 0 |
373631 | 373631 | 2020-07-27 | Benewah | Idaho | 16009 | 42 | 0 |
376845 | 376845 | 2020-07-28 | Benewah | Idaho | 16009 | 48 | 0 |
380062 | 380062 | 2020-07-29 | Benewah | Idaho | 16009 | 49 | 0 |
383279 | 383279 | 2020-07-30 | Benewah | Idaho | 16009 | 49 | 0 |
386497 | 386497 | 2020-07-31 | Benewah | Idaho | 16009 | 50 | 0 |
389714 | 389714 | 2020-08-01 | Benewah | Idaho | 16009 | 51 | 0 |
392931 | 392931 | 2020-08-02 | Benewah | Idaho | 16009 | 51 | 0 |
396147 | 396147 | 2020-08-03 | Benewah | Idaho | 16009 | 57 | 0 |
399363 | 399363 | 2020-08-04 | Benewah | Idaho | 16009 | 58 | 0 |
402579 | 402579 | 2020-08-05 | Benewah | Idaho | 16009 | 59 | 0 |
405797 | 405797 | 2020-08-06 | Benewah | Idaho | 16009 | 60 | 0 |
409017 | 409017 | 2020-08-07 | Benewah | Idaho | 16009 | 63 | 0 |
412236 | 412236 | 2020-08-08 | Benewah | Idaho | 16009 | 64 | 0 |
415456 | 415456 | 2020-08-09 | Benewah | Idaho | 16009 | 64 | 0 |
418677 | 418677 | 2020-08-10 | Benewah | Idaho | 16009 | 64 | 0 |
421899 | 421899 | 2020-08-11 | Benewah | Idaho | 16009 | 72 | 1 |
425119 | 425119 | 2020-08-12 | Benewah | Idaho | 16009 | 77 | 1 |
428343 | 428343 | 2020-08-13 | Benewah | Idaho | 16009 | 80 | 1 |
431571 | 431571 | 2020-08-14 | Benewah | Idaho | 16009 | 80 | 1 |
434796 | 434796 | 2020-08-15 | Benewah | Idaho | 16009 | 80 | 1 |
438022 | 438022 | 2020-08-16 | Benewah | Idaho | 16009 | 80 | 1 |
441248 | 441248 | 2020-08-17 | Benewah | Idaho | 16009 | 80 | 1 |
444474 | 444474 | 2020-08-18 | Benewah | Idaho | 16009 | 86 | 1 |
447701 | 447701 | 2020-08-19 | Benewah | Idaho | 16009 | 90 | 1 |
450929 | 450929 | 2020-08-20 | Benewah | Idaho | 16009 | 92 | 1 |
454157 | 454157 | 2020-08-21 | Benewah | Idaho | 16009 | 93 | 1 |
457385 | 457385 | 2020-08-22 | Benewah | Idaho | 16009 | 95 | 1 |
460612 | 460612 | 2020-08-23 | Benewah | Idaho | 16009 | 95 | 1 |
463841 | 463841 | 2020-08-24 | Benewah | Idaho | 16009 | 95 | 1 |
467070 | 467070 | 2020-08-25 | Benewah | Idaho | 16009 | 103 | 1 |
470299 | 470299 | 2020-08-26 | Benewah | Idaho | 16009 | 103 | 1 |
473531 | 473531 | 2020-08-27 | Benewah | Idaho | 16009 | 109 | 1 |
476764 | 476764 | 2020-08-28 | Benewah | Idaho | 16009 | 109 | 1 |
479997 | 479997 | 2020-08-29 | Benewah | Idaho | 16009 | 110 | 1 |
483231 | 483231 | 2020-08-30 | Benewah | Idaho | 16009 | 110 | 1 |
486466 | 486466 | 2020-08-31 | Benewah | Idaho | 16009 | 113 | 1 |
489699 | 489699 | 2020-09-01 | Benewah | Idaho | 16009 | 116 | 2 |
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);