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 date descending
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 |
---|---|---|---|---|---|---|---|
1197619 | 1197619 | 2021-04-07 | Crawford | Michigan | 26039 | 804 | 6 |
1194370 | 1194370 | 2021-04-06 | Crawford | Michigan | 26039 | 791 | 6 |
1191121 | 1191121 | 2021-04-05 | Crawford | Michigan | 26039 | 779 | 6 |
1187873 | 1187873 | 2021-04-04 | Crawford | Michigan | 26039 | 761 | 6 |
1184626 | 1184626 | 2021-04-03 | Crawford | Michigan | 26039 | 761 | 6 |
1181380 | 1181380 | 2021-04-02 | Crawford | Michigan | 26039 | 749 | 6 |
1178133 | 1178133 | 2021-04-01 | Crawford | Michigan | 26039 | 740 | 6 |
1174886 | 1174886 | 2021-03-31 | Crawford | Michigan | 26039 | 729 | 6 |
885999 | 885999 | 2021-01-01 | Crawford | Michigan | 26039 | 457 | 6 |
882754 | 882754 | 2020-12-31 | Crawford | Michigan | 26039 | 457 | 6 |
879509 | 879509 | 2020-12-30 | Crawford | Michigan | 26039 | 457 | 6 |
876264 | 876264 | 2020-12-29 | Crawford | Michigan | 26039 | 455 | 6 |
873019 | 873019 | 2020-12-28 | Crawford | Michigan | 26039 | 452 | 6 |
869774 | 869774 | 2020-12-27 | Crawford | Michigan | 26039 | 448 | 6 |
866529 | 866529 | 2020-12-26 | Crawford | Michigan | 26039 | 448 | 6 |
863284 | 863284 | 2020-12-25 | Crawford | Michigan | 26039 | 446 | 6 |
860039 | 860039 | 2020-12-24 | Crawford | Michigan | 26039 | 446 | 6 |
856794 | 856794 | 2020-12-23 | Crawford | Michigan | 26039 | 446 | 6 |
853549 | 853549 | 2020-12-22 | Crawford | Michigan | 26039 | 444 | 6 |
850304 | 850304 | 2020-12-21 | Crawford | Michigan | 26039 | 441 | 6 |
847059 | 847059 | 2020-12-20 | Crawford | Michigan | 26039 | 444 | 6 |
843813 | 843813 | 2020-12-19 | Crawford | Michigan | 26039 | 444 | 6 |
761846 | 761846 | 2020-11-24 | Crawford | Georgia | 13079 | 242 | 6 |
758601 | 758601 | 2020-11-23 | Crawford | Georgia | 13079 | 242 | 6 |
761334 | 761334 | 2020-11-23 | Crawford | Wisconsin | 55023 | 853 | 6 |
755354 | 755354 | 2020-11-22 | Crawford | Georgia | 13079 | 242 | 6 |
752108 | 752108 | 2020-11-21 | Crawford | Georgia | 13079 | 242 | 6 |
748862 | 748862 | 2020-11-20 | Crawford | Georgia | 13079 | 238 | 6 |
745616 | 745616 | 2020-11-19 | Crawford | Georgia | 13079 | 236 | 6 |
742369 | 742369 | 2020-11-18 | Crawford | Georgia | 13079 | 234 | 6 |
739122 | 739122 | 2020-11-17 | Crawford | Georgia | 13079 | 232 | 6 |
740975 | 740975 | 2020-11-17 | Crawford | Pennsylvania | 42039 | 1178 | 6 |
735878 | 735878 | 2020-11-16 | Crawford | Georgia | 13079 | 231 | 6 |
732632 | 732632 | 2020-11-15 | Crawford | Georgia | 13079 | 231 | 6 |
729387 | 729387 | 2020-11-14 | Crawford | Georgia | 13079 | 230 | 6 |
726144 | 726144 | 2020-11-13 | Crawford | Georgia | 13079 | 226 | 6 |
722901 | 722901 | 2020-11-12 | Crawford | Georgia | 13079 | 224 | 6 |
719658 | 719658 | 2020-11-11 | Crawford | Georgia | 13079 | 224 | 6 |
716415 | 716415 | 2020-11-10 | Crawford | Georgia | 13079 | 224 | 6 |
716602 | 716602 | 2020-11-10 | Crawford | Illinois | 17033 | 776 | 6 |
713171 | 713171 | 2020-11-09 | Crawford | Georgia | 13079 | 222 | 6 |
713358 | 713358 | 2020-11-09 | Crawford | Illinois | 17033 | 748 | 6 |
709927 | 709927 | 2020-11-08 | Crawford | Georgia | 13079 | 222 | 6 |
710114 | 710114 | 2020-11-08 | Crawford | Illinois | 17033 | 744 | 6 |
706683 | 706683 | 2020-11-07 | Crawford | Georgia | 13079 | 221 | 6 |
706870 | 706870 | 2020-11-07 | Crawford | Illinois | 17033 | 739 | 6 |
703440 | 703440 | 2020-11-06 | Crawford | Georgia | 13079 | 215 | 6 |
703627 | 703627 | 2020-11-06 | Crawford | Illinois | 17033 | 730 | 6 |
700197 | 700197 | 2020-11-05 | Crawford | Georgia | 13079 | 214 | 6 |
700384 | 700384 | 2020-11-05 | Crawford | Illinois | 17033 | 700 | 6 |
696953 | 696953 | 2020-11-04 | Crawford | Georgia | 13079 | 214 | 6 |
697140 | 697140 | 2020-11-04 | Crawford | Illinois | 17033 | 690 | 6 |
693711 | 693711 | 2020-11-03 | Crawford | Georgia | 13079 | 214 | 6 |
693898 | 693898 | 2020-11-03 | Crawford | Illinois | 17033 | 689 | 6 |
690468 | 690468 | 2020-11-02 | Crawford | Georgia | 13079 | 214 | 6 |
690655 | 690655 | 2020-11-02 | Crawford | Illinois | 17033 | 686 | 6 |
687223 | 687223 | 2020-11-01 | Crawford | Georgia | 13079 | 213 | 6 |
687410 | 687410 | 2020-11-01 | Crawford | Illinois | 17033 | 684 | 6 |
683979 | 683979 | 2020-10-31 | Crawford | Georgia | 13079 | 213 | 6 |
684166 | 684166 | 2020-10-31 | Crawford | Illinois | 17033 | 676 | 6 |
680736 | 680736 | 2020-10-30 | Crawford | Georgia | 13079 | 213 | 6 |
680923 | 680923 | 2020-10-30 | Crawford | Illinois | 17033 | 676 | 6 |
677493 | 677493 | 2020-10-29 | Crawford | Georgia | 13079 | 213 | 6 |
677680 | 677680 | 2020-10-29 | Crawford | Illinois | 17033 | 668 | 6 |
674250 | 674250 | 2020-10-28 | Crawford | Georgia | 13079 | 213 | 6 |
674437 | 674437 | 2020-10-28 | Crawford | Illinois | 17033 | 663 | 6 |
671008 | 671008 | 2020-10-27 | Crawford | Georgia | 13079 | 213 | 6 |
671195 | 671195 | 2020-10-27 | Crawford | Illinois | 17033 | 653 | 6 |
667765 | 667765 | 2020-10-26 | Crawford | Georgia | 13079 | 212 | 6 |
667952 | 667952 | 2020-10-26 | Crawford | Illinois | 17033 | 651 | 6 |
664520 | 664520 | 2020-10-25 | Crawford | Georgia | 13079 | 212 | 6 |
664708 | 664708 | 2020-10-25 | Crawford | Illinois | 17033 | 647 | 6 |
661276 | 661276 | 2020-10-24 | Crawford | Georgia | 13079 | 211 | 6 |
661463 | 661463 | 2020-10-24 | Crawford | Illinois | 17033 | 644 | 6 |
658032 | 658032 | 2020-10-23 | Crawford | Georgia | 13079 | 210 | 6 |
658219 | 658219 | 2020-10-23 | Crawford | Illinois | 17033 | 645 | 6 |
654787 | 654787 | 2020-10-22 | Crawford | Georgia | 13079 | 208 | 6 |
654974 | 654974 | 2020-10-22 | Crawford | Illinois | 17033 | 639 | 6 |
651542 | 651542 | 2020-10-21 | Crawford | Georgia | 13079 | 207 | 6 |
651729 | 651729 | 2020-10-21 | Crawford | Illinois | 17033 | 636 | 6 |
648298 | 648298 | 2020-10-20 | Crawford | Georgia | 13079 | 206 | 6 |
648485 | 648485 | 2020-10-20 | Crawford | Illinois | 17033 | 630 | 6 |
645053 | 645053 | 2020-10-19 | Crawford | Georgia | 13079 | 206 | 6 |
645240 | 645240 | 2020-10-19 | Crawford | Illinois | 17033 | 624 | 6 |
641805 | 641805 | 2020-10-18 | Crawford | Georgia | 13079 | 206 | 6 |
641993 | 641993 | 2020-10-18 | Crawford | Illinois | 17033 | 615 | 6 |
638558 | 638558 | 2020-10-17 | Crawford | Georgia | 13079 | 206 | 6 |
638746 | 638746 | 2020-10-17 | Crawford | Illinois | 17033 | 609 | 6 |
635313 | 635313 | 2020-10-16 | Crawford | Georgia | 13079 | 205 | 6 |
635500 | 635500 | 2020-10-16 | Crawford | Illinois | 17033 | 608 | 6 |
636408 | 636408 | 2020-10-16 | Crawford | Missouri | 29055 | 518 | 6 |
632067 | 632067 | 2020-10-15 | Crawford | Georgia | 13079 | 203 | 6 |
632254 | 632254 | 2020-10-15 | Crawford | Illinois | 17033 | 604 | 6 |
633162 | 633162 | 2020-10-15 | Crawford | Missouri | 29055 | 511 | 6 |
628823 | 628823 | 2020-10-14 | Crawford | Georgia | 13079 | 202 | 6 |
629010 | 629010 | 2020-10-14 | Crawford | Illinois | 17033 | 589 | 6 |
629917 | 629917 | 2020-10-14 | Crawford | Missouri | 29055 | 500 | 6 |
625580 | 625580 | 2020-10-13 | Crawford | Georgia | 13079 | 200 | 6 |
625767 | 625767 | 2020-10-13 | Crawford | Illinois | 17033 | 576 | 6 |
627225 | 627225 | 2020-10-13 | Crawford | Ohio | 39033 | 330 | 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);