ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
180 rows where county = "Unknown" and state = "Washington" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
10780 | 10780 | 2020-03-24 | Unknown | Washington | 77 | 0 | |
13954 | 13954 | 2020-03-26 | Unknown | Washington | 65 | 0 | |
15723 | 15723 | 2020-03-27 | Unknown | Washington | 43 | 0 | |
17603 | 17603 | 2020-03-28 | Unknown | Washington | 158 | 0 | |
19568 | 19568 | 2020-03-29 | Unknown | Washington | 262 | 0 | |
21635 | 21635 | 2020-03-30 | Unknown | Washington | 243 | 0 | |
23784 | 23784 | 2020-03-31 | Unknown | Washington | 231 | 0 | |
28293 | 28293 | 2020-04-02 | Unknown | Washington | 510 | 0 | |
30646 | 30646 | 2020-04-03 | Unknown | Washington | 476 | 0 | |
33046 | 33046 | 2020-04-04 | Unknown | Washington | 710 | 0 | |
35484 | 35484 | 2020-04-05 | Unknown | Washington | 615 | 0 | |
37968 | 37968 | 2020-04-06 | Unknown | Washington | 653 | 0 | |
40503 | 40503 | 2020-04-07 | Unknown | Washington | 601 | 0 | |
43072 | 43072 | 2020-04-08 | Unknown | Washington | 705 | 0 | |
45668 | 45668 | 2020-04-09 | Unknown | Washington | 815 | 0 | |
48296 | 48296 | 2020-04-10 | Unknown | Washington | 627 | 0 | |
50954 | 50954 | 2020-04-11 | Unknown | Washington | 583 | 0 | |
53629 | 53629 | 2020-04-12 | Unknown | Washington | 499 | 0 | |
56319 | 56319 | 2020-04-13 | Unknown | Washington | 329 | 0 | |
59025 | 59025 | 2020-04-14 | Unknown | Washington | 220 | 0 | |
61744 | 61744 | 2020-04-15 | Unknown | Washington | 77 | 0 | |
64477 | 64477 | 2020-04-16 | Unknown | Washington | 154 | 0 | |
67225 | 67225 | 2020-04-17 | Unknown | Washington | 174 | 0 | |
69987 | 69987 | 2020-04-18 | Unknown | Washington | 233 | 0 | |
366497 | 366497 | 2020-07-24 | Unknown | Washington | 2 | 2 | |
369706 | 369706 | 2020-07-25 | Unknown | Washington | 2 | 2 | |
372918 | 372918 | 2020-07-26 | Unknown | Washington | 2 | 2 | |
376132 | 376132 | 2020-07-27 | Unknown | Washington | 2 | 2 | |
379348 | 379348 | 2020-07-28 | Unknown | Washington | 2 | 2 | |
382565 | 382565 | 2020-07-29 | Unknown | Washington | 2 | 2 | |
385783 | 385783 | 2020-07-30 | Unknown | Washington | 2 | 2 | |
389000 | 389000 | 2020-07-31 | Unknown | Washington | 2 | 2 | |
392217 | 392217 | 2020-08-01 | Unknown | Washington | 2 | 2 | |
395433 | 395433 | 2020-08-02 | Unknown | Washington | 2 | 2 | |
398649 | 398649 | 2020-08-03 | Unknown | Washington | 2 | 2 | |
401865 | 401865 | 2020-08-04 | Unknown | Washington | 2 | 2 | |
405083 | 405083 | 2020-08-05 | Unknown | Washington | 2 | 2 | |
408303 | 408303 | 2020-08-06 | Unknown | Washington | 2 | 2 | |
411522 | 411522 | 2020-08-07 | Unknown | Washington | 2 | 2 | |
414742 | 414742 | 2020-08-08 | Unknown | Washington | 2 | 2 | |
417963 | 417963 | 2020-08-09 | Unknown | Washington | 2 | 2 | |
421184 | 421184 | 2020-08-10 | Unknown | Washington | 2 | 2 | |
424405 | 424405 | 2020-08-11 | Unknown | Washington | 2 | 2 | |
427629 | 427629 | 2020-08-12 | Unknown | Washington | 2 | 2 | |
430857 | 430857 | 2020-08-13 | Unknown | Washington | 2 | 2 | |
434082 | 434082 | 2020-08-14 | Unknown | Washington | 2 | 2 | |
437308 | 437308 | 2020-08-15 | Unknown | Washington | 2 | 2 | |
440534 | 440534 | 2020-08-16 | Unknown | Washington | 2 | 2 | |
443760 | 443760 | 2020-08-17 | Unknown | Washington | 2 | 2 | |
446987 | 446987 | 2020-08-18 | Unknown | Washington | 2 | 2 | |
450215 | 450215 | 2020-08-19 | Unknown | Washington | 2 | 2 | |
453443 | 453443 | 2020-08-20 | Unknown | Washington | 2 | 2 | |
456671 | 456671 | 2020-08-21 | Unknown | Washington | 2 | 2 | |
459898 | 459898 | 2020-08-22 | Unknown | Washington | 2 | 2 | |
463127 | 463127 | 2020-08-23 | Unknown | Washington | 2 | 2 | |
466356 | 466356 | 2020-08-24 | Unknown | Washington | 2 | 2 | |
469585 | 469585 | 2020-08-25 | Unknown | Washington | 2 | 2 | |
472817 | 472817 | 2020-08-26 | Unknown | Washington | 2 | 2 | |
476050 | 476050 | 2020-08-27 | Unknown | Washington | 2 | 2 | |
479283 | 479283 | 2020-08-28 | Unknown | Washington | 2 | 2 | |
482517 | 482517 | 2020-08-29 | Unknown | Washington | 2 | 2 | |
485752 | 485752 | 2020-08-30 | Unknown | Washington | 2 | 2 | |
488985 | 488985 | 2020-08-31 | Unknown | Washington | 2 | 2 | |
492218 | 492218 | 2020-09-01 | Unknown | Washington | 2 | 2 | |
495452 | 495452 | 2020-09-02 | Unknown | Washington | 2 | 2 | |
498685 | 498685 | 2020-09-03 | Unknown | Washington | 2 | 2 | |
501919 | 501919 | 2020-09-04 | Unknown | Washington | 2 | 2 | |
505153 | 505153 | 2020-09-05 | Unknown | Washington | 2 | 2 | |
508385 | 508385 | 2020-09-06 | Unknown | Washington | 2 | 2 | |
511618 | 511618 | 2020-09-07 | Unknown | Washington | 2 | 2 | |
514851 | 514851 | 2020-09-08 | Unknown | Washington | 2 | 2 | |
518086 | 518086 | 2020-09-09 | Unknown | Washington | 2 | 2 | |
521323 | 521323 | 2020-09-10 | Unknown | Washington | 2 | 2 | |
524559 | 524559 | 2020-09-11 | Unknown | Washington | 2 | 2 | |
527795 | 527795 | 2020-09-12 | Unknown | Washington | 2 | 2 | |
531032 | 531032 | 2020-09-13 | Unknown | Washington | 2 | 2 | |
534267 | 534267 | 2020-09-14 | Unknown | Washington | 2 | 2 | |
537503 | 537503 | 2020-09-15 | Unknown | Washington | 2 | 2 | |
540740 | 540740 | 2020-09-16 | Unknown | Washington | 2 | 2 | |
543976 | 543976 | 2020-09-17 | Unknown | Washington | 2 | 2 | |
547213 | 547213 | 2020-09-18 | Unknown | Washington | 2 | 2 | |
550452 | 550452 | 2020-09-19 | Unknown | Washington | 2 | 2 | |
553691 | 553691 | 2020-09-20 | Unknown | Washington | 2 | 2 | |
556928 | 556928 | 2020-09-21 | Unknown | Washington | 2 | 2 | |
560164 | 560164 | 2020-09-22 | Unknown | Washington | 2 | 2 | |
563403 | 563403 | 2020-09-23 | Unknown | Washington | 2 | 2 | |
566644 | 566644 | 2020-09-24 | Unknown | Washington | 2 | 2 | |
569885 | 569885 | 2020-09-25 | Unknown | Washington | 2 | 2 | |
573127 | 573127 | 2020-09-26 | Unknown | Washington | 2 | 2 | |
576371 | 576371 | 2020-09-27 | Unknown | Washington | 2 | 2 | |
579612 | 579612 | 2020-09-28 | Unknown | Washington | 2 | 2 | |
582851 | 582851 | 2020-09-29 | Unknown | Washington | 2 | 2 | |
586091 | 586091 | 2020-09-30 | Unknown | Washington | 2 | 2 | |
589332 | 589332 | 2020-10-01 | Unknown | Washington | 2 | 2 | |
592572 | 592572 | 2020-10-02 | Unknown | Washington | 2 | 2 | |
595814 | 595814 | 2020-10-03 | Unknown | Washington | 2 | 2 | |
599057 | 599057 | 2020-10-04 | Unknown | Washington | 2 | 2 | |
602300 | 602300 | 2020-10-05 | Unknown | Washington | 2 | 2 | |
605542 | 605542 | 2020-10-06 | Unknown | Washington | 2 | 2 | |
608785 | 608785 | 2020-10-07 | Unknown | Washington | 2 | 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);