ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
170 rows where county = "Crawford" and deaths = 6 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 10
county 1
- Crawford · 170 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
450497 | 450497 | 2020-08-20 | Crawford | Arkansas | 5033 | 790 | 6 |
453725 | 453725 | 2020-08-21 | Crawford | Arkansas | 5033 | 814 | 6 |
456953 | 456953 | 2020-08-22 | Crawford | Arkansas | 5033 | 827 | 6 |
460180 | 460180 | 2020-08-23 | Crawford | Arkansas | 5033 | 835 | 6 |
463409 | 463409 | 2020-08-24 | Crawford | Arkansas | 5033 | 839 | 6 |
466638 | 466638 | 2020-08-25 | Crawford | Arkansas | 5033 | 851 | 6 |
469867 | 469867 | 2020-08-26 | Crawford | Arkansas | 5033 | 865 | 6 |
473099 | 473099 | 2020-08-27 | Crawford | Arkansas | 5033 | 883 | 6 |
476332 | 476332 | 2020-08-28 | Crawford | Arkansas | 5033 | 896 | 6 |
612611 | 612611 | 2020-10-09 | Crawford | Georgia | 13079 | 194 | 6 |
615852 | 615852 | 2020-10-10 | Crawford | Georgia | 13079 | 196 | 6 |
619094 | 619094 | 2020-10-11 | Crawford | Georgia | 13079 | 199 | 6 |
622337 | 622337 | 2020-10-12 | Crawford | Georgia | 13079 | 200 | 6 |
625580 | 625580 | 2020-10-13 | Crawford | Georgia | 13079 | 200 | 6 |
628823 | 628823 | 2020-10-14 | Crawford | Georgia | 13079 | 202 | 6 |
632067 | 632067 | 2020-10-15 | Crawford | Georgia | 13079 | 203 | 6 |
635313 | 635313 | 2020-10-16 | Crawford | Georgia | 13079 | 205 | 6 |
638558 | 638558 | 2020-10-17 | Crawford | Georgia | 13079 | 206 | 6 |
641805 | 641805 | 2020-10-18 | Crawford | Georgia | 13079 | 206 | 6 |
645053 | 645053 | 2020-10-19 | Crawford | Georgia | 13079 | 206 | 6 |
648298 | 648298 | 2020-10-20 | Crawford | Georgia | 13079 | 206 | 6 |
651542 | 651542 | 2020-10-21 | Crawford | Georgia | 13079 | 207 | 6 |
654787 | 654787 | 2020-10-22 | Crawford | Georgia | 13079 | 208 | 6 |
658032 | 658032 | 2020-10-23 | Crawford | Georgia | 13079 | 210 | 6 |
661276 | 661276 | 2020-10-24 | Crawford | Georgia | 13079 | 211 | 6 |
664520 | 664520 | 2020-10-25 | Crawford | Georgia | 13079 | 212 | 6 |
667765 | 667765 | 2020-10-26 | Crawford | Georgia | 13079 | 212 | 6 |
671008 | 671008 | 2020-10-27 | Crawford | Georgia | 13079 | 213 | 6 |
674250 | 674250 | 2020-10-28 | Crawford | Georgia | 13079 | 213 | 6 |
677493 | 677493 | 2020-10-29 | Crawford | Georgia | 13079 | 213 | 6 |
680736 | 680736 | 2020-10-30 | Crawford | Georgia | 13079 | 213 | 6 |
683979 | 683979 | 2020-10-31 | Crawford | Georgia | 13079 | 213 | 6 |
687223 | 687223 | 2020-11-01 | Crawford | Georgia | 13079 | 213 | 6 |
690468 | 690468 | 2020-11-02 | Crawford | Georgia | 13079 | 214 | 6 |
693711 | 693711 | 2020-11-03 | Crawford | Georgia | 13079 | 214 | 6 |
696953 | 696953 | 2020-11-04 | Crawford | Georgia | 13079 | 214 | 6 |
700197 | 700197 | 2020-11-05 | Crawford | Georgia | 13079 | 214 | 6 |
703440 | 703440 | 2020-11-06 | Crawford | Georgia | 13079 | 215 | 6 |
706683 | 706683 | 2020-11-07 | Crawford | Georgia | 13079 | 221 | 6 |
709927 | 709927 | 2020-11-08 | Crawford | Georgia | 13079 | 222 | 6 |
713171 | 713171 | 2020-11-09 | Crawford | Georgia | 13079 | 222 | 6 |
716415 | 716415 | 2020-11-10 | Crawford | Georgia | 13079 | 224 | 6 |
719658 | 719658 | 2020-11-11 | Crawford | Georgia | 13079 | 224 | 6 |
722901 | 722901 | 2020-11-12 | Crawford | Georgia | 13079 | 224 | 6 |
726144 | 726144 | 2020-11-13 | Crawford | Georgia | 13079 | 226 | 6 |
729387 | 729387 | 2020-11-14 | Crawford | Georgia | 13079 | 230 | 6 |
732632 | 732632 | 2020-11-15 | Crawford | Georgia | 13079 | 231 | 6 |
735878 | 735878 | 2020-11-16 | Crawford | Georgia | 13079 | 231 | 6 |
739122 | 739122 | 2020-11-17 | Crawford | Georgia | 13079 | 232 | 6 |
742369 | 742369 | 2020-11-18 | Crawford | Georgia | 13079 | 234 | 6 |
745616 | 745616 | 2020-11-19 | Crawford | Georgia | 13079 | 236 | 6 |
748862 | 748862 | 2020-11-20 | Crawford | Georgia | 13079 | 238 | 6 |
752108 | 752108 | 2020-11-21 | Crawford | Georgia | 13079 | 242 | 6 |
755354 | 755354 | 2020-11-22 | Crawford | Georgia | 13079 | 242 | 6 |
758601 | 758601 | 2020-11-23 | Crawford | Georgia | 13079 | 242 | 6 |
761846 | 761846 | 2020-11-24 | Crawford | Georgia | 13079 | 242 | 6 |
593344 | 593344 | 2020-10-03 | Crawford | Illinois | 17033 | 478 | 6 |
596586 | 596586 | 2020-10-04 | Crawford | Illinois | 17033 | 481 | 6 |
599828 | 599828 | 2020-10-05 | Crawford | Illinois | 17033 | 491 | 6 |
603071 | 603071 | 2020-10-06 | Crawford | Illinois | 17033 | 497 | 6 |
606313 | 606313 | 2020-10-07 | Crawford | Illinois | 17033 | 505 | 6 |
609556 | 609556 | 2020-10-08 | Crawford | Illinois | 17033 | 525 | 6 |
612798 | 612798 | 2020-10-09 | Crawford | Illinois | 17033 | 539 | 6 |
616039 | 616039 | 2020-10-10 | Crawford | Illinois | 17033 | 544 | 6 |
619281 | 619281 | 2020-10-11 | Crawford | Illinois | 17033 | 561 | 6 |
622525 | 622525 | 2020-10-12 | Crawford | Illinois | 17033 | 572 | 6 |
625767 | 625767 | 2020-10-13 | Crawford | Illinois | 17033 | 576 | 6 |
629010 | 629010 | 2020-10-14 | Crawford | Illinois | 17033 | 589 | 6 |
632254 | 632254 | 2020-10-15 | Crawford | Illinois | 17033 | 604 | 6 |
635500 | 635500 | 2020-10-16 | Crawford | Illinois | 17033 | 608 | 6 |
638746 | 638746 | 2020-10-17 | Crawford | Illinois | 17033 | 609 | 6 |
641993 | 641993 | 2020-10-18 | Crawford | Illinois | 17033 | 615 | 6 |
645240 | 645240 | 2020-10-19 | Crawford | Illinois | 17033 | 624 | 6 |
648485 | 648485 | 2020-10-20 | Crawford | Illinois | 17033 | 630 | 6 |
651729 | 651729 | 2020-10-21 | Crawford | Illinois | 17033 | 636 | 6 |
654974 | 654974 | 2020-10-22 | Crawford | Illinois | 17033 | 639 | 6 |
658219 | 658219 | 2020-10-23 | Crawford | Illinois | 17033 | 645 | 6 |
661463 | 661463 | 2020-10-24 | Crawford | Illinois | 17033 | 644 | 6 |
664708 | 664708 | 2020-10-25 | Crawford | Illinois | 17033 | 647 | 6 |
667952 | 667952 | 2020-10-26 | Crawford | Illinois | 17033 | 651 | 6 |
671195 | 671195 | 2020-10-27 | Crawford | Illinois | 17033 | 653 | 6 |
674437 | 674437 | 2020-10-28 | Crawford | Illinois | 17033 | 663 | 6 |
677680 | 677680 | 2020-10-29 | Crawford | Illinois | 17033 | 668 | 6 |
680923 | 680923 | 2020-10-30 | Crawford | Illinois | 17033 | 676 | 6 |
684166 | 684166 | 2020-10-31 | Crawford | Illinois | 17033 | 676 | 6 |
687410 | 687410 | 2020-11-01 | Crawford | Illinois | 17033 | 684 | 6 |
690655 | 690655 | 2020-11-02 | Crawford | Illinois | 17033 | 686 | 6 |
693898 | 693898 | 2020-11-03 | Crawford | Illinois | 17033 | 689 | 6 |
697140 | 697140 | 2020-11-04 | Crawford | Illinois | 17033 | 690 | 6 |
700384 | 700384 | 2020-11-05 | Crawford | Illinois | 17033 | 700 | 6 |
703627 | 703627 | 2020-11-06 | Crawford | Illinois | 17033 | 730 | 6 |
706870 | 706870 | 2020-11-07 | Crawford | Illinois | 17033 | 739 | 6 |
710114 | 710114 | 2020-11-08 | Crawford | Illinois | 17033 | 744 | 6 |
713358 | 713358 | 2020-11-09 | Crawford | Illinois | 17033 | 748 | 6 |
716602 | 716602 | 2020-11-10 | Crawford | Illinois | 17033 | 776 | 6 |
580585 | 580585 | 2020-09-29 | Crawford | Iowa | 19047 | 1108 | 6 |
583824 | 583824 | 2020-09-30 | Crawford | Iowa | 19047 | 1117 | 6 |
587064 | 587064 | 2020-10-01 | Crawford | Iowa | 19047 | 1124 | 6 |
590305 | 590305 | 2020-10-02 | Crawford | Iowa | 19047 | 1137 | 6 |
545043 | 545043 | 2020-09-18 | Crawford | Kansas | 20037 | 948 | 6 |
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);