ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Washington" and fips = 48477 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637742 | 637742 | 2020-10-16 | Washington | Texas | 48477 | 673 | 48 |
634497 | 634497 | 2020-10-15 | Washington | Texas | 48477 | 671 | 48 |
631252 | 631252 | 2020-10-14 | Washington | Texas | 48477 | 667 | 48 |
628008 | 628008 | 2020-10-13 | Washington | Texas | 48477 | 664 | 48 |
624765 | 624765 | 2020-10-12 | Washington | Texas | 48477 | 657 | 48 |
621522 | 621522 | 2020-10-11 | Washington | Texas | 48477 | 657 | 48 |
618279 | 618279 | 2020-10-10 | Washington | Texas | 48477 | 657 | 48 |
615037 | 615037 | 2020-10-09 | Washington | Texas | 48477 | 655 | 48 |
611796 | 611796 | 2020-10-08 | Washington | Texas | 48477 | 655 | 48 |
608554 | 608554 | 2020-10-07 | Washington | Texas | 48477 | 653 | 48 |
605311 | 605311 | 2020-10-06 | Washington | Texas | 48477 | 652 | 48 |
602069 | 602069 | 2020-10-05 | Washington | Texas | 48477 | 646 | 48 |
598826 | 598826 | 2020-10-04 | Washington | Texas | 48477 | 646 | 48 |
595583 | 595583 | 2020-10-03 | Washington | Texas | 48477 | 646 | 48 |
592341 | 592341 | 2020-10-02 | Washington | Texas | 48477 | 642 | 48 |
589101 | 589101 | 2020-10-01 | Washington | Texas | 48477 | 641 | 48 |
585860 | 585860 | 2020-09-30 | Washington | Texas | 48477 | 641 | 48 |
582620 | 582620 | 2020-09-29 | Washington | Texas | 48477 | 641 | 48 |
579381 | 579381 | 2020-09-28 | Washington | Texas | 48477 | 640 | 48 |
576140 | 576140 | 2020-09-27 | Washington | Texas | 48477 | 640 | 48 |
572896 | 572896 | 2020-09-26 | Washington | Texas | 48477 | 638 | 48 |
569654 | 569654 | 2020-09-25 | Washington | Texas | 48477 | 636 | 48 |
566413 | 566413 | 2020-09-24 | Washington | Texas | 48477 | 636 | 48 |
563172 | 563172 | 2020-09-23 | Washington | Texas | 48477 | 633 | 48 |
559933 | 559933 | 2020-09-22 | Washington | Texas | 48477 | 628 | 48 |
556697 | 556697 | 2020-09-21 | Washington | Texas | 48477 | 627 | 48 |
553460 | 553460 | 2020-09-20 | Washington | Texas | 48477 | 625 | 48 |
550221 | 550221 | 2020-09-19 | Washington | Texas | 48477 | 625 | 48 |
546982 | 546982 | 2020-09-18 | Washington | Texas | 48477 | 624 | 48 |
543745 | 543745 | 2020-09-17 | Washington | Texas | 48477 | 621 | 48 |
540509 | 540509 | 2020-09-16 | Washington | Texas | 48477 | 616 | 48 |
537272 | 537272 | 2020-09-15 | Washington | Texas | 48477 | 613 | 47 |
534036 | 534036 | 2020-09-14 | Washington | Texas | 48477 | 594 | 47 |
530801 | 530801 | 2020-09-13 | Washington | Texas | 48477 | 594 | 47 |
527564 | 527564 | 2020-09-12 | Washington | Texas | 48477 | 594 | 47 |
524328 | 524328 | 2020-09-11 | Washington | Texas | 48477 | 593 | 47 |
521092 | 521092 | 2020-09-10 | Washington | Texas | 48477 | 582 | 46 |
517856 | 517856 | 2020-09-09 | Washington | Texas | 48477 | 582 | 46 |
514621 | 514621 | 2020-09-08 | Washington | Texas | 48477 | 579 | 46 |
511388 | 511388 | 2020-09-07 | Washington | Texas | 48477 | 579 | 45 |
508155 | 508155 | 2020-09-06 | Washington | Texas | 48477 | 579 | 45 |
504923 | 504923 | 2020-09-05 | Washington | Texas | 48477 | 579 | 45 |
501689 | 501689 | 2020-09-04 | Washington | Texas | 48477 | 576 | 45 |
498455 | 498455 | 2020-09-03 | Washington | Texas | 48477 | 575 | 45 |
495222 | 495222 | 2020-09-02 | Washington | Texas | 48477 | 573 | 45 |
491988 | 491988 | 2020-09-01 | Washington | Texas | 48477 | 565 | 45 |
488755 | 488755 | 2020-08-31 | Washington | Texas | 48477 | 565 | 45 |
485522 | 485522 | 2020-08-30 | Washington | Texas | 48477 | 564 | 45 |
482287 | 482287 | 2020-08-29 | Washington | Texas | 48477 | 564 | 45 |
479053 | 479053 | 2020-08-28 | Washington | Texas | 48477 | 560 | 45 |
475820 | 475820 | 2020-08-27 | Washington | Texas | 48477 | 560 | 44 |
472587 | 472587 | 2020-08-26 | Washington | Texas | 48477 | 560 | 44 |
469355 | 469355 | 2020-08-25 | Washington | Texas | 48477 | 561 | 44 |
466126 | 466126 | 2020-08-24 | Washington | Texas | 48477 | 560 | 43 |
462897 | 462897 | 2020-08-23 | Washington | Texas | 48477 | 559 | 43 |
459668 | 459668 | 2020-08-22 | Washington | Texas | 48477 | 559 | 43 |
456441 | 456441 | 2020-08-21 | Washington | Texas | 48477 | 553 | 43 |
453213 | 453213 | 2020-08-20 | Washington | Texas | 48477 | 549 | 42 |
449985 | 449985 | 2020-08-19 | Washington | Texas | 48477 | 548 | 41 |
446757 | 446757 | 2020-08-18 | Washington | Texas | 48477 | 534 | 41 |
443530 | 443530 | 2020-08-17 | Washington | Texas | 48477 | 526 | 41 |
440304 | 440304 | 2020-08-16 | Washington | Texas | 48477 | 526 | 41 |
437078 | 437078 | 2020-08-15 | Washington | Texas | 48477 | 526 | 41 |
433852 | 433852 | 2020-08-14 | Washington | Texas | 48477 | 523 | 40 |
430627 | 430627 | 2020-08-13 | Washington | Texas | 48477 | 523 | 40 |
427399 | 427399 | 2020-08-12 | Washington | Texas | 48477 | 520 | 39 |
424175 | 424175 | 2020-08-11 | Washington | Texas | 48477 | 515 | 39 |
420954 | 420954 | 2020-08-10 | Washington | Texas | 48477 | 515 | 39 |
417733 | 417733 | 2020-08-09 | Washington | Texas | 48477 | 515 | 39 |
414512 | 414512 | 2020-08-08 | Washington | Texas | 48477 | 515 | 39 |
411292 | 411292 | 2020-08-07 | Washington | Texas | 48477 | 499 | 39 |
408073 | 408073 | 2020-08-06 | Washington | Texas | 48477 | 498 | 39 |
404853 | 404853 | 2020-08-05 | Washington | Texas | 48477 | 498 | 38 |
401635 | 401635 | 2020-08-04 | Washington | Texas | 48477 | 498 | 38 |
398419 | 398419 | 2020-08-03 | Washington | Texas | 48477 | 497 | 38 |
395203 | 395203 | 2020-08-02 | Washington | Texas | 48477 | 489 | 38 |
391987 | 391987 | 2020-08-01 | Washington | Texas | 48477 | 477 | 38 |
388770 | 388770 | 2020-07-31 | Washington | Texas | 48477 | 465 | 38 |
385553 | 385553 | 2020-07-30 | Washington | Texas | 48477 | 452 | 37 |
382335 | 382335 | 2020-07-29 | Washington | Texas | 48477 | 452 | 38 |
379118 | 379118 | 2020-07-28 | Washington | Texas | 48477 | 450 | 37 |
375902 | 375902 | 2020-07-27 | Washington | Texas | 48477 | 441 | 35 |
372689 | 372689 | 2020-07-26 | Washington | Texas | 48477 | 441 | 34 |
369477 | 369477 | 2020-07-25 | Washington | Texas | 48477 | 441 | 34 |
366268 | 366268 | 2020-07-24 | Washington | Texas | 48477 | 439 | 34 |
363062 | 363062 | 2020-07-23 | Washington | Texas | 48477 | 439 | 34 |
359855 | 359855 | 2020-07-22 | Washington | Texas | 48477 | 426 | 34 |
356650 | 356650 | 2020-07-21 | Washington | Texas | 48477 | 400 | 34 |
353447 | 353447 | 2020-07-20 | Washington | Texas | 48477 | 400 | 34 |
350245 | 350245 | 2020-07-19 | Washington | Texas | 48477 | 391 | 34 |
347045 | 347045 | 2020-07-18 | Washington | Texas | 48477 | 391 | 33 |
343844 | 343844 | 2020-07-17 | Washington | Texas | 48477 | 391 | 33 |
340645 | 340645 | 2020-07-16 | Washington | Texas | 48477 | 373 | 33 |
337449 | 337449 | 2020-07-15 | Washington | Texas | 48477 | 373 | 33 |
334254 | 334254 | 2020-07-14 | Washington | Texas | 48477 | 365 | 33 |
331061 | 331061 | 2020-07-13 | Washington | Texas | 48477 | 365 | 33 |
327875 | 327875 | 2020-07-12 | Washington | Texas | 48477 | 351 | 33 |
324690 | 324690 | 2020-07-11 | Washington | Texas | 48477 | 351 | 33 |
321509 | 321509 | 2020-07-10 | Washington | Texas | 48477 | 349 | 32 |
318330 | 318330 | 2020-07-09 | Washington | Texas | 48477 | 337 | 32 |
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);