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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-07-19 1
- 2020-07-20 1
- 2020-07-21 1
- 2020-07-28 1
- 2020-07-29 1
- 2020-07-30 1
- 2020-07-31 1
- 2020-08-01 1
- 2020-08-02 1
- 2020-08-03 1
- 2020-08-04 1
- 2020-08-05 1
- 2020-08-06 1
- 2020-08-07 1
- 2020-08-08 1
- 2020-08-09 1
- 2020-08-10 1
- 2020-08-11 1
- 2020-08-12 1
- 2020-08-13 1
- 2020-08-14 1
- 2020-08-15 1
- 2020-08-16 1
- 2020-08-17 1
- 2020-08-18 1
- 2020-08-19 1
- 2020-08-20 1
- 2020-08-21 1
- 2020-08-22 1
- 2020-08-23 1
- …
state 1
- Idaho · 658 ✖
fips 1
- 16033 658
county 1
- Clark · 658 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
347996 | 347996 | 2020-07-19 | Clark | Idaho | 16033 | 1 | 0 |
351196 | 351196 | 2020-07-20 | Clark | Idaho | 16033 | 1 | 0 |
354398 | 354398 | 2020-07-21 | Clark | Idaho | 16033 | 1 | 0 |
376856 | 376856 | 2020-07-28 | Clark | Idaho | 16033 | 1 | 0 |
380073 | 380073 | 2020-07-29 | Clark | Idaho | 16033 | 2 | 0 |
383290 | 383290 | 2020-07-30 | Clark | Idaho | 16033 | 2 | 0 |
386508 | 386508 | 2020-07-31 | Clark | Idaho | 16033 | 2 | 0 |
389725 | 389725 | 2020-08-01 | Clark | Idaho | 16033 | 2 | 0 |
392942 | 392942 | 2020-08-02 | Clark | Idaho | 16033 | 3 | 0 |
396158 | 396158 | 2020-08-03 | Clark | Idaho | 16033 | 3 | 0 |
399374 | 399374 | 2020-08-04 | Clark | Idaho | 16033 | 5 | 0 |
402590 | 402590 | 2020-08-05 | Clark | Idaho | 16033 | 7 | 0 |
405808 | 405808 | 2020-08-06 | Clark | Idaho | 16033 | 9 | 0 |
409028 | 409028 | 2020-08-07 | Clark | Idaho | 16033 | 9 | 0 |
412247 | 412247 | 2020-08-08 | Clark | Idaho | 16033 | 9 | 0 |
415467 | 415467 | 2020-08-09 | Clark | Idaho | 16033 | 9 | 0 |
418688 | 418688 | 2020-08-10 | Clark | Idaho | 16033 | 9 | 0 |
421911 | 421911 | 2020-08-11 | Clark | Idaho | 16033 | 10 | 0 |
425131 | 425131 | 2020-08-12 | Clark | Idaho | 16033 | 10 | 0 |
428355 | 428355 | 2020-08-13 | Clark | Idaho | 16033 | 15 | 0 |
431583 | 431583 | 2020-08-14 | Clark | Idaho | 16033 | 15 | 0 |
434808 | 434808 | 2020-08-15 | Clark | Idaho | 16033 | 15 | 0 |
438034 | 438034 | 2020-08-16 | Clark | Idaho | 16033 | 15 | 0 |
441260 | 441260 | 2020-08-17 | Clark | Idaho | 16033 | 16 | 0 |
444486 | 444486 | 2020-08-18 | Clark | Idaho | 16033 | 16 | 0 |
447713 | 447713 | 2020-08-19 | Clark | Idaho | 16033 | 16 | 0 |
450941 | 450941 | 2020-08-20 | Clark | Idaho | 16033 | 16 | 0 |
454169 | 454169 | 2020-08-21 | Clark | Idaho | 16033 | 16 | 0 |
457397 | 457397 | 2020-08-22 | Clark | Idaho | 16033 | 16 | 0 |
460624 | 460624 | 2020-08-23 | Clark | Idaho | 16033 | 16 | 0 |
463853 | 463853 | 2020-08-24 | Clark | Idaho | 16033 | 16 | 0 |
467082 | 467082 | 2020-08-25 | Clark | Idaho | 16033 | 18 | 0 |
470311 | 470311 | 2020-08-26 | Clark | Idaho | 16033 | 18 | 0 |
473543 | 473543 | 2020-08-27 | Clark | Idaho | 16033 | 18 | 0 |
476776 | 476776 | 2020-08-28 | Clark | Idaho | 16033 | 18 | 0 |
480009 | 480009 | 2020-08-29 | Clark | Idaho | 16033 | 21 | 0 |
483243 | 483243 | 2020-08-30 | Clark | Idaho | 16033 | 21 | 0 |
486478 | 486478 | 2020-08-31 | Clark | Idaho | 16033 | 21 | 0 |
489711 | 489711 | 2020-09-01 | Clark | Idaho | 16033 | 21 | 0 |
492944 | 492944 | 2020-09-02 | Clark | Idaho | 16033 | 21 | 0 |
496178 | 496178 | 2020-09-03 | Clark | Idaho | 16033 | 21 | 0 |
499411 | 499411 | 2020-09-04 | Clark | Idaho | 16033 | 21 | 0 |
502645 | 502645 | 2020-09-05 | Clark | Idaho | 16033 | 22 | 0 |
505879 | 505879 | 2020-09-06 | Clark | Idaho | 16033 | 22 | 0 |
509111 | 509111 | 2020-09-07 | Clark | Idaho | 16033 | 22 | 0 |
512344 | 512344 | 2020-09-08 | Clark | Idaho | 16033 | 22 | 0 |
515577 | 515577 | 2020-09-09 | Clark | Idaho | 16033 | 23 | 0 |
518812 | 518812 | 2020-09-10 | Clark | Idaho | 16033 | 23 | 0 |
522049 | 522049 | 2020-09-11 | Clark | Idaho | 16033 | 24 | 0 |
525285 | 525285 | 2020-09-12 | Clark | Idaho | 16033 | 24 | 0 |
528521 | 528521 | 2020-09-13 | Clark | Idaho | 16033 | 24 | 0 |
531758 | 531758 | 2020-09-14 | Clark | Idaho | 16033 | 25 | 0 |
534993 | 534993 | 2020-09-15 | Clark | Idaho | 16033 | 27 | 0 |
538229 | 538229 | 2020-09-16 | Clark | Idaho | 16033 | 28 | 0 |
541466 | 541466 | 2020-09-17 | Clark | Idaho | 16033 | 29 | 0 |
544702 | 544702 | 2020-09-18 | Clark | Idaho | 16033 | 31 | 0 |
547940 | 547940 | 2020-09-19 | Clark | Idaho | 16033 | 31 | 0 |
551179 | 551179 | 2020-09-20 | Clark | Idaho | 16033 | 31 | 0 |
554418 | 554418 | 2020-09-21 | Clark | Idaho | 16033 | 31 | 0 |
557655 | 557655 | 2020-09-22 | Clark | Idaho | 16033 | 32 | 0 |
560891 | 560891 | 2020-09-23 | Clark | Idaho | 16033 | 32 | 0 |
564131 | 564131 | 2020-09-24 | Clark | Idaho | 16033 | 32 | 0 |
567371 | 567371 | 2020-09-25 | Clark | Idaho | 16033 | 32 | 0 |
570613 | 570613 | 2020-09-26 | Clark | Idaho | 16033 | 33 | 0 |
573855 | 573855 | 2020-09-27 | Clark | Idaho | 16033 | 33 | 0 |
577098 | 577098 | 2020-09-28 | Clark | Idaho | 16033 | 33 | 0 |
580339 | 580339 | 2020-09-29 | Clark | Idaho | 16033 | 34 | 0 |
583578 | 583578 | 2020-09-30 | Clark | Idaho | 16033 | 35 | 0 |
586818 | 586818 | 2020-10-01 | Clark | Idaho | 16033 | 35 | 0 |
590059 | 590059 | 2020-10-02 | Clark | Idaho | 16033 | 36 | 0 |
593299 | 593299 | 2020-10-03 | Clark | Idaho | 16033 | 36 | 0 |
596541 | 596541 | 2020-10-04 | Clark | Idaho | 16033 | 37 | 0 |
599784 | 599784 | 2020-10-05 | Clark | Idaho | 16033 | 37 | 0 |
603027 | 603027 | 2020-10-06 | Clark | Idaho | 16033 | 38 | 0 |
606269 | 606269 | 2020-10-07 | Clark | Idaho | 16033 | 38 | 0 |
609512 | 609512 | 2020-10-08 | Clark | Idaho | 16033 | 38 | 0 |
612754 | 612754 | 2020-10-09 | Clark | Idaho | 16033 | 38 | 0 |
615995 | 615995 | 2020-10-10 | Clark | Idaho | 16033 | 38 | 0 |
619237 | 619237 | 2020-10-11 | Clark | Idaho | 16033 | 39 | 0 |
622480 | 622480 | 2020-10-12 | Clark | Idaho | 16033 | 39 | 0 |
625723 | 625723 | 2020-10-13 | Clark | Idaho | 16033 | 40 | 0 |
628966 | 628966 | 2020-10-14 | Clark | Idaho | 16033 | 40 | 0 |
632210 | 632210 | 2020-10-15 | Clark | Idaho | 16033 | 40 | 0 |
635456 | 635456 | 2020-10-16 | Clark | Idaho | 16033 | 40 | 0 |
638701 | 638701 | 2020-10-17 | Clark | Idaho | 16033 | 40 | 0 |
641948 | 641948 | 2020-10-18 | Clark | Idaho | 16033 | 40 | 0 |
645196 | 645196 | 2020-10-19 | Clark | Idaho | 16033 | 40 | 0 |
648441 | 648441 | 2020-10-20 | Clark | Idaho | 16033 | 40 | 0 |
651685 | 651685 | 2020-10-21 | Clark | Idaho | 16033 | 40 | 0 |
654930 | 654930 | 2020-10-22 | Clark | Idaho | 16033 | 40 | 0 |
658175 | 658175 | 2020-10-23 | Clark | Idaho | 16033 | 40 | 0 |
661419 | 661419 | 2020-10-24 | Clark | Idaho | 16033 | 40 | 0 |
664663 | 664663 | 2020-10-25 | Clark | Idaho | 16033 | 40 | 0 |
667908 | 667908 | 2020-10-26 | Clark | Idaho | 16033 | 40 | 0 |
671151 | 671151 | 2020-10-27 | Clark | Idaho | 16033 | 40 | 0 |
674393 | 674393 | 2020-10-28 | Clark | Idaho | 16033 | 40 | 0 |
677636 | 677636 | 2020-10-29 | Clark | Idaho | 16033 | 40 | 0 |
680879 | 680879 | 2020-10-30 | Clark | Idaho | 16033 | 40 | 0 |
684122 | 684122 | 2020-10-31 | Clark | Idaho | 16033 | 40 | 0 |
687366 | 687366 | 2020-11-01 | Clark | Idaho | 16033 | 40 | 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);