ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Franklin" and state = "Washington" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
274315 | 274315 | 2020-06-25 | Franklin | Washington | 53021 | 1587 | 32 |
277463 | 277463 | 2020-06-26 | Franklin | Washington | 53021 | 1627 | 32 |
280611 | 280611 | 2020-06-27 | Franklin | Washington | 53021 | 1692 | 32 |
283757 | 283757 | 2020-06-28 | Franklin | Washington | 53021 | 1715 | 32 |
286903 | 286903 | 2020-06-29 | Franklin | Washington | 53021 | 1750 | 33 |
290053 | 290053 | 2020-06-30 | Franklin | Washington | 53021 | 1777 | 33 |
293206 | 293206 | 2020-07-01 | Franklin | Washington | 53021 | 1842 | 33 |
296361 | 296361 | 2020-07-02 | Franklin | Washington | 53021 | 1887 | 33 |
299523 | 299523 | 2020-07-03 | Franklin | Washington | 53021 | 1930 | 33 |
302687 | 302687 | 2020-07-04 | Franklin | Washington | 53021 | 1977 | 33 |
305851 | 305851 | 2020-07-05 | Franklin | Washington | 53021 | 2035 | 33 |
309019 | 309019 | 2020-07-06 | Franklin | Washington | 53021 | 2175 | 33 |
312188 | 312188 | 2020-07-07 | Franklin | Washington | 53021 | 2250 | 34 |
315363 | 315363 | 2020-07-08 | Franklin | Washington | 53021 | 2276 | 34 |
318536 | 318536 | 2020-07-09 | Franklin | Washington | 53021 | 2344 | 35 |
321715 | 321715 | 2020-07-10 | Franklin | Washington | 53021 | 2409 | 36 |
324896 | 324896 | 2020-07-11 | Franklin | Washington | 53021 | 2409 | 36 |
328081 | 328081 | 2020-07-12 | Franklin | Washington | 53021 | 2409 | 36 |
331267 | 331267 | 2020-07-13 | Franklin | Washington | 53021 | 2600 | 38 |
334460 | 334460 | 2020-07-14 | Franklin | Washington | 53021 | 2642 | 39 |
337655 | 337655 | 2020-07-15 | Franklin | Washington | 53021 | 2690 | 42 |
340851 | 340851 | 2020-07-16 | Franklin | Washington | 53021 | 2710 | 42 |
344050 | 344050 | 2020-07-17 | Franklin | Washington | 53021 | 2784 | 41 |
347250 | 347250 | 2020-07-18 | Franklin | Washington | 53021 | 2784 | 42 |
350451 | 350451 | 2020-07-19 | Franklin | Washington | 53021 | 2784 | 42 |
353653 | 353653 | 2020-07-20 | Franklin | Washington | 53021 | 2930 | 42 |
356856 | 356856 | 2020-07-21 | Franklin | Washington | 53021 | 2982 | 43 |
360061 | 360061 | 2020-07-22 | Franklin | Washington | 53021 | 3019 | 44 |
363267 | 363267 | 2020-07-23 | Franklin | Washington | 53021 | 3043 | 44 |
366473 | 366473 | 2020-07-24 | Franklin | Washington | 53021 | 3090 | 45 |
369682 | 369682 | 2020-07-25 | Franklin | Washington | 53021 | 3129 | 45 |
372894 | 372894 | 2020-07-26 | Franklin | Washington | 53021 | 3163 | 45 |
376108 | 376108 | 2020-07-27 | Franklin | Washington | 53021 | 3187 | 46 |
379324 | 379324 | 2020-07-28 | Franklin | Washington | 53021 | 3260 | 46 |
382541 | 382541 | 2020-07-29 | Franklin | Washington | 53021 | 3311 | 46 |
385759 | 385759 | 2020-07-30 | Franklin | Washington | 53021 | 3347 | 47 |
388976 | 388976 | 2020-07-31 | Franklin | Washington | 53021 | 3386 | 47 |
392193 | 392193 | 2020-08-01 | Franklin | Washington | 53021 | 3418 | 48 |
395409 | 395409 | 2020-08-02 | Franklin | Washington | 53021 | 3446 | 48 |
398625 | 398625 | 2020-08-03 | Franklin | Washington | 53021 | 3462 | 48 |
401841 | 401841 | 2020-08-04 | Franklin | Washington | 53021 | 3512 | 48 |
405059 | 405059 | 2020-08-05 | Franklin | Washington | 53021 | 3528 | 48 |
408279 | 408279 | 2020-08-06 | Franklin | Washington | 53021 | 3549 | 48 |
411498 | 411498 | 2020-08-07 | Franklin | Washington | 53021 | 3584 | 49 |
414718 | 414718 | 2020-08-08 | Franklin | Washington | 53021 | 3584 | 49 |
417939 | 417939 | 2020-08-09 | Franklin | Washington | 53021 | 3623 | 50 |
421160 | 421160 | 2020-08-10 | Franklin | Washington | 53021 | 3679 | 50 |
424381 | 424381 | 2020-08-11 | Franklin | Washington | 53021 | 3696 | 50 |
427605 | 427605 | 2020-08-12 | Franklin | Washington | 53021 | 3712 | 50 |
430833 | 430833 | 2020-08-13 | Franklin | Washington | 53021 | 3742 | 52 |
434058 | 434058 | 2020-08-14 | Franklin | Washington | 53021 | 3742 | 52 |
437284 | 437284 | 2020-08-15 | Franklin | Washington | 53021 | 3804 | 52 |
440510 | 440510 | 2020-08-16 | Franklin | Washington | 53021 | 3850 | 54 |
443736 | 443736 | 2020-08-17 | Franklin | Washington | 53021 | 3872 | 55 |
446963 | 446963 | 2020-08-18 | Franklin | Washington | 53021 | 3895 | 56 |
450191 | 450191 | 2020-08-19 | Franklin | Washington | 53021 | 3895 | 56 |
453419 | 453419 | 2020-08-20 | Franklin | Washington | 53021 | 3913 | 56 |
456647 | 456647 | 2020-08-21 | Franklin | Washington | 53021 | 3940 | 56 |
459874 | 459874 | 2020-08-22 | Franklin | Washington | 53021 | 3962 | 56 |
463103 | 463103 | 2020-08-23 | Franklin | Washington | 53021 | 3971 | 56 |
466332 | 466332 | 2020-08-24 | Franklin | Washington | 53021 | 3980 | 56 |
469561 | 469561 | 2020-08-25 | Franklin | Washington | 53021 | 3987 | 56 |
472793 | 472793 | 2020-08-26 | Franklin | Washington | 53021 | 4001 | 56 |
476026 | 476026 | 2020-08-27 | Franklin | Washington | 53021 | 4011 | 57 |
479259 | 479259 | 2020-08-28 | Franklin | Washington | 53021 | 4036 | 58 |
482493 | 482493 | 2020-08-29 | Franklin | Washington | 53021 | 4051 | 58 |
485728 | 485728 | 2020-08-30 | Franklin | Washington | 53021 | 4067 | 58 |
488961 | 488961 | 2020-08-31 | Franklin | Washington | 53021 | 4081 | 58 |
492194 | 492194 | 2020-09-01 | Franklin | Washington | 53021 | 4101 | 59 |
495428 | 495428 | 2020-09-02 | Franklin | Washington | 53021 | 4110 | 59 |
498661 | 498661 | 2020-09-03 | Franklin | Washington | 53021 | 4125 | 59 |
501895 | 501895 | 2020-09-04 | Franklin | Washington | 53021 | 4144 | 59 |
505129 | 505129 | 2020-09-05 | Franklin | Washington | 53021 | 4144 | 59 |
508361 | 508361 | 2020-09-06 | Franklin | Washington | 53021 | 4169 | 59 |
511594 | 511594 | 2020-09-07 | Franklin | Washington | 53021 | 4169 | 59 |
514827 | 514827 | 2020-09-08 | Franklin | Washington | 53021 | 4172 | 59 |
518062 | 518062 | 2020-09-09 | Franklin | Washington | 53021 | 4196 | 59 |
521299 | 521299 | 2020-09-10 | Franklin | Washington | 53021 | 4210 | 60 |
524535 | 524535 | 2020-09-11 | Franklin | Washington | 53021 | 4219 | 60 |
527771 | 527771 | 2020-09-12 | Franklin | Washington | 53021 | 4238 | 60 |
531008 | 531008 | 2020-09-13 | Franklin | Washington | 53021 | 4250 | 60 |
534243 | 534243 | 2020-09-14 | Franklin | Washington | 53021 | 4268 | 60 |
537479 | 537479 | 2020-09-15 | Franklin | Washington | 53021 | 4272 | 62 |
540716 | 540716 | 2020-09-16 | Franklin | Washington | 53021 | 4278 | 63 |
543952 | 543952 | 2020-09-17 | Franklin | Washington | 53021 | 4284 | 63 |
547189 | 547189 | 2020-09-18 | Franklin | Washington | 53021 | 4291 | 64 |
550428 | 550428 | 2020-09-19 | Franklin | Washington | 53021 | 4313 | 64 |
553667 | 553667 | 2020-09-20 | Franklin | Washington | 53021 | 4324 | 64 |
556904 | 556904 | 2020-09-21 | Franklin | Washington | 53021 | 4324 | 64 |
560140 | 560140 | 2020-09-22 | Franklin | Washington | 53021 | 4336 | 65 |
563379 | 563379 | 2020-09-23 | Franklin | Washington | 53021 | 4355 | 66 |
566620 | 566620 | 2020-09-24 | Franklin | Washington | 53021 | 4367 | 67 |
569861 | 569861 | 2020-09-25 | Franklin | Washington | 53021 | 4379 | 67 |
573103 | 573103 | 2020-09-26 | Franklin | Washington | 53021 | 4402 | 67 |
576347 | 576347 | 2020-09-27 | Franklin | Washington | 53021 | 4419 | 67 |
579588 | 579588 | 2020-09-28 | Franklin | Washington | 53021 | 4434 | 67 |
582827 | 582827 | 2020-09-29 | Franklin | Washington | 53021 | 4447 | 67 |
586067 | 586067 | 2020-09-30 | Franklin | Washington | 53021 | 4469 | 67 |
589308 | 589308 | 2020-10-01 | Franklin | Washington | 53021 | 4481 | 67 |
592548 | 592548 | 2020-10-02 | Franklin | Washington | 53021 | 4488 | 67 |
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);