ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
658 rows where county = "Clark" and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534993 | 534993 | 2020-09-15 | Clark | Idaho | 16033 | 27 | 0 |
531758 | 531758 | 2020-09-14 | Clark | Idaho | 16033 | 25 | 0 |
528521 | 528521 | 2020-09-13 | Clark | Idaho | 16033 | 24 | 0 |
525285 | 525285 | 2020-09-12 | Clark | Idaho | 16033 | 24 | 0 |
522049 | 522049 | 2020-09-11 | Clark | Idaho | 16033 | 24 | 0 |
518812 | 518812 | 2020-09-10 | Clark | Idaho | 16033 | 23 | 0 |
515577 | 515577 | 2020-09-09 | Clark | Idaho | 16033 | 23 | 0 |
512344 | 512344 | 2020-09-08 | Clark | Idaho | 16033 | 22 | 0 |
509111 | 509111 | 2020-09-07 | Clark | Idaho | 16033 | 22 | 0 |
505879 | 505879 | 2020-09-06 | Clark | Idaho | 16033 | 22 | 0 |
502645 | 502645 | 2020-09-05 | Clark | Idaho | 16033 | 22 | 0 |
499411 | 499411 | 2020-09-04 | Clark | Idaho | 16033 | 21 | 0 |
496178 | 496178 | 2020-09-03 | Clark | Idaho | 16033 | 21 | 0 |
492944 | 492944 | 2020-09-02 | Clark | Idaho | 16033 | 21 | 0 |
489711 | 489711 | 2020-09-01 | Clark | Idaho | 16033 | 21 | 0 |
486478 | 486478 | 2020-08-31 | Clark | Idaho | 16033 | 21 | 0 |
483243 | 483243 | 2020-08-30 | Clark | Idaho | 16033 | 21 | 0 |
480009 | 480009 | 2020-08-29 | Clark | Idaho | 16033 | 21 | 0 |
476776 | 476776 | 2020-08-28 | Clark | Idaho | 16033 | 18 | 0 |
473543 | 473543 | 2020-08-27 | Clark | Idaho | 16033 | 18 | 0 |
470311 | 470311 | 2020-08-26 | Clark | Idaho | 16033 | 18 | 0 |
467082 | 467082 | 2020-08-25 | Clark | Idaho | 16033 | 18 | 0 |
463853 | 463853 | 2020-08-24 | Clark | Idaho | 16033 | 16 | 0 |
460624 | 460624 | 2020-08-23 | Clark | Idaho | 16033 | 16 | 0 |
457397 | 457397 | 2020-08-22 | Clark | Idaho | 16033 | 16 | 0 |
454169 | 454169 | 2020-08-21 | Clark | Idaho | 16033 | 16 | 0 |
450941 | 450941 | 2020-08-20 | Clark | Idaho | 16033 | 16 | 0 |
447713 | 447713 | 2020-08-19 | Clark | Idaho | 16033 | 16 | 0 |
444486 | 444486 | 2020-08-18 | Clark | Idaho | 16033 | 16 | 0 |
441260 | 441260 | 2020-08-17 | Clark | Idaho | 16033 | 16 | 0 |
438034 | 438034 | 2020-08-16 | Clark | Idaho | 16033 | 15 | 0 |
434808 | 434808 | 2020-08-15 | Clark | Idaho | 16033 | 15 | 0 |
431583 | 431583 | 2020-08-14 | Clark | Idaho | 16033 | 15 | 0 |
428355 | 428355 | 2020-08-13 | Clark | Idaho | 16033 | 15 | 0 |
425131 | 425131 | 2020-08-12 | Clark | Idaho | 16033 | 10 | 0 |
421911 | 421911 | 2020-08-11 | Clark | Idaho | 16033 | 10 | 0 |
418688 | 418688 | 2020-08-10 | Clark | Idaho | 16033 | 9 | 0 |
415467 | 415467 | 2020-08-09 | Clark | Idaho | 16033 | 9 | 0 |
412247 | 412247 | 2020-08-08 | Clark | Idaho | 16033 | 9 | 0 |
409028 | 409028 | 2020-08-07 | Clark | Idaho | 16033 | 9 | 0 |
405808 | 405808 | 2020-08-06 | Clark | Idaho | 16033 | 9 | 0 |
402590 | 402590 | 2020-08-05 | Clark | Idaho | 16033 | 7 | 0 |
399374 | 399374 | 2020-08-04 | Clark | Idaho | 16033 | 5 | 0 |
396158 | 396158 | 2020-08-03 | Clark | Idaho | 16033 | 3 | 0 |
392942 | 392942 | 2020-08-02 | Clark | Idaho | 16033 | 3 | 0 |
389725 | 389725 | 2020-08-01 | Clark | Idaho | 16033 | 2 | 0 |
386508 | 386508 | 2020-07-31 | Clark | Idaho | 16033 | 2 | 0 |
383290 | 383290 | 2020-07-30 | Clark | Idaho | 16033 | 2 | 0 |
380073 | 380073 | 2020-07-29 | Clark | Idaho | 16033 | 2 | 0 |
376856 | 376856 | 2020-07-28 | Clark | Idaho | 16033 | 1 | 0 |
354398 | 354398 | 2020-07-21 | Clark | Idaho | 16033 | 1 | 0 |
351196 | 351196 | 2020-07-20 | Clark | Idaho | 16033 | 1 | 0 |
347996 | 347996 | 2020-07-19 | Clark | Idaho | 16033 | 1 | 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);