ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
671 rows where fips = 53023 and state = "Washington" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
328082 | 328082 | 2020-07-12 | Garfield | Washington | 53023 | 1 | 0 |
331268 | 331268 | 2020-07-13 | Garfield | Washington | 53023 | 1 | 0 |
334461 | 334461 | 2020-07-14 | Garfield | Washington | 53023 | 2 | 0 |
337656 | 337656 | 2020-07-15 | Garfield | Washington | 53023 | 2 | 0 |
340852 | 340852 | 2020-07-16 | Garfield | Washington | 53023 | 2 | 0 |
344051 | 344051 | 2020-07-17 | Garfield | Washington | 53023 | 2 | 0 |
347251 | 347251 | 2020-07-18 | Garfield | Washington | 53023 | 2 | 0 |
350452 | 350452 | 2020-07-19 | Garfield | Washington | 53023 | 2 | 0 |
353654 | 353654 | 2020-07-20 | Garfield | Washington | 53023 | 2 | 0 |
356857 | 356857 | 2020-07-21 | Garfield | Washington | 53023 | 2 | 0 |
360062 | 360062 | 2020-07-22 | Garfield | Washington | 53023 | 2 | 0 |
363268 | 363268 | 2020-07-23 | Garfield | Washington | 53023 | 2 | 0 |
366474 | 366474 | 2020-07-24 | Garfield | Washington | 53023 | 2 | 0 |
369683 | 369683 | 2020-07-25 | Garfield | Washington | 53023 | 2 | 0 |
372895 | 372895 | 2020-07-26 | Garfield | Washington | 53023 | 2 | 0 |
376109 | 376109 | 2020-07-27 | Garfield | Washington | 53023 | 2 | 0 |
379325 | 379325 | 2020-07-28 | Garfield | Washington | 53023 | 2 | 0 |
382542 | 382542 | 2020-07-29 | Garfield | Washington | 53023 | 2 | 0 |
385760 | 385760 | 2020-07-30 | Garfield | Washington | 53023 | 2 | 0 |
388977 | 388977 | 2020-07-31 | Garfield | Washington | 53023 | 2 | 0 |
392194 | 392194 | 2020-08-01 | Garfield | Washington | 53023 | 2 | 0 |
395410 | 395410 | 2020-08-02 | Garfield | Washington | 53023 | 2 | 0 |
398626 | 398626 | 2020-08-03 | Garfield | Washington | 53023 | 2 | 0 |
401842 | 401842 | 2020-08-04 | Garfield | Washington | 53023 | 2 | 0 |
405060 | 405060 | 2020-08-05 | Garfield | Washington | 53023 | 2 | 0 |
408280 | 408280 | 2020-08-06 | Garfield | Washington | 53023 | 2 | 0 |
411499 | 411499 | 2020-08-07 | Garfield | Washington | 53023 | 2 | 0 |
414719 | 414719 | 2020-08-08 | Garfield | Washington | 53023 | 2 | 0 |
417940 | 417940 | 2020-08-09 | Garfield | Washington | 53023 | 4 | 0 |
421161 | 421161 | 2020-08-10 | Garfield | Washington | 53023 | 4 | 0 |
424382 | 424382 | 2020-08-11 | Garfield | Washington | 53023 | 4 | 0 |
427606 | 427606 | 2020-08-12 | Garfield | Washington | 53023 | 4 | 0 |
430834 | 430834 | 2020-08-13 | Garfield | Washington | 53023 | 4 | 0 |
434059 | 434059 | 2020-08-14 | Garfield | Washington | 53023 | 4 | 0 |
437285 | 437285 | 2020-08-15 | Garfield | Washington | 53023 | 4 | 0 |
440511 | 440511 | 2020-08-16 | Garfield | Washington | 53023 | 4 | 0 |
443737 | 443737 | 2020-08-17 | Garfield | Washington | 53023 | 4 | 0 |
446964 | 446964 | 2020-08-18 | Garfield | Washington | 53023 | 4 | 0 |
450192 | 450192 | 2020-08-19 | Garfield | Washington | 53023 | 4 | 0 |
453420 | 453420 | 2020-08-20 | Garfield | Washington | 53023 | 4 | 0 |
456648 | 456648 | 2020-08-21 | Garfield | Washington | 53023 | 4 | 0 |
459875 | 459875 | 2020-08-22 | Garfield | Washington | 53023 | 4 | 0 |
463104 | 463104 | 2020-08-23 | Garfield | Washington | 53023 | 4 | 0 |
466333 | 466333 | 2020-08-24 | Garfield | Washington | 53023 | 4 | 0 |
469562 | 469562 | 2020-08-25 | Garfield | Washington | 53023 | 4 | 0 |
472794 | 472794 | 2020-08-26 | Garfield | Washington | 53023 | 4 | 0 |
476027 | 476027 | 2020-08-27 | Garfield | Washington | 53023 | 4 | 0 |
479260 | 479260 | 2020-08-28 | Garfield | Washington | 53023 | 4 | 0 |
482494 | 482494 | 2020-08-29 | Garfield | Washington | 53023 | 4 | 0 |
485729 | 485729 | 2020-08-30 | Garfield | Washington | 53023 | 4 | 0 |
488962 | 488962 | 2020-08-31 | Garfield | Washington | 53023 | 4 | 0 |
492195 | 492195 | 2020-09-01 | Garfield | Washington | 53023 | 4 | 0 |
495429 | 495429 | 2020-09-02 | Garfield | Washington | 53023 | 4 | 0 |
498662 | 498662 | 2020-09-03 | Garfield | Washington | 53023 | 4 | 0 |
501896 | 501896 | 2020-09-04 | Garfield | Washington | 53023 | 4 | 0 |
505130 | 505130 | 2020-09-05 | Garfield | Washington | 53023 | 4 | 0 |
508362 | 508362 | 2020-09-06 | Garfield | Washington | 53023 | 4 | 0 |
511595 | 511595 | 2020-09-07 | Garfield | Washington | 53023 | 4 | 0 |
514828 | 514828 | 2020-09-08 | Garfield | Washington | 53023 | 4 | 0 |
518063 | 518063 | 2020-09-09 | Garfield | Washington | 53023 | 4 | 0 |
521300 | 521300 | 2020-09-10 | Garfield | Washington | 53023 | 8 | 0 |
524536 | 524536 | 2020-09-11 | Garfield | Washington | 53023 | 8 | 0 |
527772 | 527772 | 2020-09-12 | Garfield | Washington | 53023 | 9 | 0 |
531009 | 531009 | 2020-09-13 | Garfield | Washington | 53023 | 10 | 0 |
534244 | 534244 | 2020-09-14 | Garfield | Washington | 53023 | 10 | 0 |
537480 | 537480 | 2020-09-15 | Garfield | Washington | 53023 | 10 | 0 |
540717 | 540717 | 2020-09-16 | Garfield | Washington | 53023 | 11 | 0 |
543953 | 543953 | 2020-09-17 | Garfield | Washington | 53023 | 11 | 0 |
547190 | 547190 | 2020-09-18 | Garfield | Washington | 53023 | 11 | 0 |
550429 | 550429 | 2020-09-19 | Garfield | Washington | 53023 | 11 | 0 |
553668 | 553668 | 2020-09-20 | Garfield | Washington | 53023 | 11 | 0 |
556905 | 556905 | 2020-09-21 | Garfield | Washington | 53023 | 11 | 0 |
560141 | 560141 | 2020-09-22 | Garfield | Washington | 53023 | 11 | 0 |
563380 | 563380 | 2020-09-23 | Garfield | Washington | 53023 | 11 | 0 |
566621 | 566621 | 2020-09-24 | Garfield | Washington | 53023 | 11 | 0 |
569862 | 569862 | 2020-09-25 | Garfield | Washington | 53023 | 11 | 0 |
573104 | 573104 | 2020-09-26 | Garfield | Washington | 53023 | 11 | 0 |
576348 | 576348 | 2020-09-27 | Garfield | Washington | 53023 | 11 | 0 |
579589 | 579589 | 2020-09-28 | Garfield | Washington | 53023 | 11 | 0 |
582828 | 582828 | 2020-09-29 | Garfield | Washington | 53023 | 13 | 0 |
586068 | 586068 | 2020-09-30 | Garfield | Washington | 53023 | 12 | 0 |
589309 | 589309 | 2020-10-01 | Garfield | Washington | 53023 | 13 | 0 |
592549 | 592549 | 2020-10-02 | Garfield | Washington | 53023 | 13 | 0 |
595791 | 595791 | 2020-10-03 | Garfield | Washington | 53023 | 13 | 0 |
599034 | 599034 | 2020-10-04 | Garfield | Washington | 53023 | 14 | 0 |
602277 | 602277 | 2020-10-05 | Garfield | Washington | 53023 | 14 | 0 |
605519 | 605519 | 2020-10-06 | Garfield | Washington | 53023 | 14 | 0 |
608762 | 608762 | 2020-10-07 | Garfield | Washington | 53023 | 13 | 0 |
612004 | 612004 | 2020-10-08 | Garfield | Washington | 53023 | 13 | 0 |
615245 | 615245 | 2020-10-09 | Garfield | Washington | 53023 | 13 | 0 |
618487 | 618487 | 2020-10-10 | Garfield | Washington | 53023 | 13 | 0 |
621730 | 621730 | 2020-10-11 | Garfield | Washington | 53023 | 13 | 0 |
624973 | 624973 | 2020-10-12 | Garfield | Washington | 53023 | 13 | 0 |
628216 | 628216 | 2020-10-13 | Garfield | Washington | 53023 | 13 | 0 |
631460 | 631460 | 2020-10-14 | Garfield | Washington | 53023 | 13 | 0 |
634705 | 634705 | 2020-10-15 | Garfield | Washington | 53023 | 13 | 0 |
637950 | 637950 | 2020-10-16 | Garfield | Washington | 53023 | 13 | 0 |
641197 | 641197 | 2020-10-17 | Garfield | Washington | 53023 | 14 | 0 |
644445 | 644445 | 2020-10-18 | Garfield | Washington | 53023 | 14 | 0 |
647691 | 647691 | 2020-10-19 | Garfield | Washington | 53023 | 14 | 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);