ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Columbia" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637945 | 637945 | 2020-10-16 | Columbia | Washington | 53013 | 14 | 1 |
634700 | 634700 | 2020-10-15 | Columbia | Washington | 53013 | 14 | 1 |
631455 | 631455 | 2020-10-14 | Columbia | Washington | 53013 | 14 | 1 |
628211 | 628211 | 2020-10-13 | Columbia | Washington | 53013 | 14 | 1 |
624968 | 624968 | 2020-10-12 | Columbia | Washington | 53013 | 14 | 1 |
621725 | 621725 | 2020-10-11 | Columbia | Washington | 53013 | 14 | 1 |
618482 | 618482 | 2020-10-10 | Columbia | Washington | 53013 | 14 | 1 |
615240 | 615240 | 2020-10-09 | Columbia | Washington | 53013 | 14 | 1 |
611999 | 611999 | 2020-10-08 | Columbia | Washington | 53013 | 14 | 1 |
608757 | 608757 | 2020-10-07 | Columbia | Washington | 53013 | 14 | 1 |
605514 | 605514 | 2020-10-06 | Columbia | Washington | 53013 | 14 | 1 |
602272 | 602272 | 2020-10-05 | Columbia | Washington | 53013 | 14 | 1 |
599029 | 599029 | 2020-10-04 | Columbia | Washington | 53013 | 14 | 1 |
595786 | 595786 | 2020-10-03 | Columbia | Washington | 53013 | 14 | 1 |
592544 | 592544 | 2020-10-02 | Columbia | Washington | 53013 | 14 | 1 |
589304 | 589304 | 2020-10-01 | Columbia | Washington | 53013 | 14 | 1 |
586063 | 586063 | 2020-09-30 | Columbia | Washington | 53013 | 14 | 1 |
582823 | 582823 | 2020-09-29 | Columbia | Washington | 53013 | 14 | 1 |
579584 | 579584 | 2020-09-28 | Columbia | Washington | 53013 | 14 | 1 |
576343 | 576343 | 2020-09-27 | Columbia | Washington | 53013 | 14 | 1 |
573099 | 573099 | 2020-09-26 | Columbia | Washington | 53013 | 14 | 1 |
569857 | 569857 | 2020-09-25 | Columbia | Washington | 53013 | 14 | 1 |
566616 | 566616 | 2020-09-24 | Columbia | Washington | 53013 | 14 | 1 |
563375 | 563375 | 2020-09-23 | Columbia | Washington | 53013 | 14 | 1 |
560136 | 560136 | 2020-09-22 | Columbia | Washington | 53013 | 14 | 1 |
556900 | 556900 | 2020-09-21 | Columbia | Washington | 53013 | 14 | 1 |
553663 | 553663 | 2020-09-20 | Columbia | Washington | 53013 | 14 | 1 |
550424 | 550424 | 2020-09-19 | Columbia | Washington | 53013 | 14 | 1 |
547185 | 547185 | 2020-09-18 | Columbia | Washington | 53013 | 14 | 1 |
543948 | 543948 | 2020-09-17 | Columbia | Washington | 53013 | 14 | 1 |
540712 | 540712 | 2020-09-16 | Columbia | Washington | 53013 | 14 | 1 |
537475 | 537475 | 2020-09-15 | Columbia | Washington | 53013 | 14 | 1 |
534239 | 534239 | 2020-09-14 | Columbia | Washington | 53013 | 14 | 1 |
531004 | 531004 | 2020-09-13 | Columbia | Washington | 53013 | 14 | 1 |
527767 | 527767 | 2020-09-12 | Columbia | Washington | 53013 | 14 | 1 |
524531 | 524531 | 2020-09-11 | Columbia | Washington | 53013 | 14 | 1 |
521295 | 521295 | 2020-09-10 | Columbia | Washington | 53013 | 14 | 1 |
518058 | 518058 | 2020-09-09 | Columbia | Washington | 53013 | 14 | 1 |
514823 | 514823 | 2020-09-08 | Columbia | Washington | 53013 | 15 | 1 |
511590 | 511590 | 2020-09-07 | Columbia | Washington | 53013 | 15 | 1 |
508357 | 508357 | 2020-09-06 | Columbia | Washington | 53013 | 15 | 1 |
505125 | 505125 | 2020-09-05 | Columbia | Washington | 53013 | 15 | 1 |
501891 | 501891 | 2020-09-04 | Columbia | Washington | 53013 | 15 | 1 |
498657 | 498657 | 2020-09-03 | Columbia | Washington | 53013 | 15 | 1 |
495424 | 495424 | 2020-09-02 | Columbia | Washington | 53013 | 14 | 1 |
492190 | 492190 | 2020-09-01 | Columbia | Washington | 53013 | 13 | 1 |
488957 | 488957 | 2020-08-31 | Columbia | Washington | 53013 | 13 | 1 |
485724 | 485724 | 2020-08-30 | Columbia | Washington | 53013 | 13 | 1 |
482489 | 482489 | 2020-08-29 | Columbia | Washington | 53013 | 13 | 1 |
479255 | 479255 | 2020-08-28 | Columbia | Washington | 53013 | 13 | 1 |
476022 | 476022 | 2020-08-27 | Columbia | Washington | 53013 | 13 | 1 |
472789 | 472789 | 2020-08-26 | Columbia | Washington | 53013 | 13 | 1 |
469557 | 469557 | 2020-08-25 | Columbia | Washington | 53013 | 13 | 1 |
466328 | 466328 | 2020-08-24 | Columbia | Washington | 53013 | 13 | 1 |
463099 | 463099 | 2020-08-23 | Columbia | Washington | 53013 | 13 | 1 |
459870 | 459870 | 2020-08-22 | Columbia | Washington | 53013 | 13 | 1 |
456643 | 456643 | 2020-08-21 | Columbia | Washington | 53013 | 13 | 1 |
453415 | 453415 | 2020-08-20 | Columbia | Washington | 53013 | 13 | 1 |
450187 | 450187 | 2020-08-19 | Columbia | Washington | 53013 | 13 | 1 |
446959 | 446959 | 2020-08-18 | Columbia | Washington | 53013 | 13 | 1 |
443732 | 443732 | 2020-08-17 | Columbia | Washington | 53013 | 13 | 1 |
440506 | 440506 | 2020-08-16 | Columbia | Washington | 53013 | 13 | 1 |
437280 | 437280 | 2020-08-15 | Columbia | Washington | 53013 | 13 | 1 |
434054 | 434054 | 2020-08-14 | Columbia | Washington | 53013 | 13 | 1 |
430829 | 430829 | 2020-08-13 | Columbia | Washington | 53013 | 13 | 1 |
427601 | 427601 | 2020-08-12 | Columbia | Washington | 53013 | 13 | 1 |
424377 | 424377 | 2020-08-11 | Columbia | Washington | 53013 | 13 | 1 |
421156 | 421156 | 2020-08-10 | Columbia | Washington | 53013 | 13 | 1 |
417935 | 417935 | 2020-08-09 | Columbia | Washington | 53013 | 13 | 1 |
414714 | 414714 | 2020-08-08 | Columbia | Washington | 53013 | 13 | 1 |
411494 | 411494 | 2020-08-07 | Columbia | Washington | 53013 | 13 | 1 |
408275 | 408275 | 2020-08-06 | Columbia | Washington | 53013 | 13 | 1 |
405055 | 405055 | 2020-08-05 | Columbia | Washington | 53013 | 13 | 1 |
401837 | 401837 | 2020-08-04 | Columbia | Washington | 53013 | 13 | 1 |
398621 | 398621 | 2020-08-03 | Columbia | Washington | 53013 | 13 | 1 |
395405 | 395405 | 2020-08-02 | Columbia | Washington | 53013 | 13 | 1 |
392189 | 392189 | 2020-08-01 | Columbia | Washington | 53013 | 13 | 0 |
388972 | 388972 | 2020-07-31 | Columbia | Washington | 53013 | 13 | 0 |
385755 | 385755 | 2020-07-30 | Columbia | Washington | 53013 | 13 | 0 |
382537 | 382537 | 2020-07-29 | Columbia | Washington | 53013 | 13 | 0 |
379320 | 379320 | 2020-07-28 | Columbia | Washington | 53013 | 13 | 0 |
376104 | 376104 | 2020-07-27 | Columbia | Washington | 53013 | 12 | 0 |
372890 | 372890 | 2020-07-26 | Columbia | Washington | 53013 | 12 | 0 |
369678 | 369678 | 2020-07-25 | Columbia | Washington | 53013 | 12 | 0 |
366469 | 366469 | 2020-07-24 | Columbia | Washington | 53013 | 10 | 0 |
363263 | 363263 | 2020-07-23 | Columbia | Washington | 53013 | 10 | 0 |
360057 | 360057 | 2020-07-22 | Columbia | Washington | 53013 | 10 | 0 |
356852 | 356852 | 2020-07-21 | Columbia | Washington | 53013 | 10 | 0 |
353649 | 353649 | 2020-07-20 | Columbia | Washington | 53013 | 9 | 0 |
350447 | 350447 | 2020-07-19 | Columbia | Washington | 53013 | 9 | 0 |
347246 | 347246 | 2020-07-18 | Columbia | Washington | 53013 | 9 | 0 |
344046 | 344046 | 2020-07-17 | Columbia | Washington | 53013 | 9 | 0 |
340847 | 340847 | 2020-07-16 | Columbia | Washington | 53013 | 9 | 0 |
337651 | 337651 | 2020-07-15 | Columbia | Washington | 53013 | 9 | 0 |
334456 | 334456 | 2020-07-14 | Columbia | Washington | 53013 | 9 | 0 |
331263 | 331263 | 2020-07-13 | Columbia | Washington | 53013 | 9 | 0 |
328077 | 328077 | 2020-07-12 | Columbia | Washington | 53013 | 9 | 0 |
324892 | 324892 | 2020-07-11 | Columbia | Washington | 53013 | 8 | 0 |
321711 | 321711 | 2020-07-10 | Columbia | Washington | 53013 | 8 | 0 |
318532 | 318532 | 2020-07-09 | Columbia | Washington | 53013 | 8 | 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);