ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
444 rows where county = "Crawford" and deaths = 5 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 11
county 1
- Crawford · 444 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1171639 | 1171639 | 2021-03-30 | Crawford | Michigan | 26039 | 717 | 5 |
1168391 | 1168391 | 2021-03-29 | Crawford | Michigan | 26039 | 705 | 5 |
1165143 | 1165143 | 2021-03-28 | Crawford | Michigan | 26039 | 693 | 5 |
1161895 | 1161895 | 2021-03-27 | Crawford | Michigan | 26039 | 693 | 5 |
1158647 | 1158647 | 2021-03-26 | Crawford | Michigan | 26039 | 681 | 5 |
1155400 | 1155400 | 2021-03-25 | Crawford | Michigan | 26039 | 675 | 5 |
1152153 | 1152153 | 2021-03-24 | Crawford | Michigan | 26039 | 669 | 5 |
1148906 | 1148906 | 2021-03-23 | Crawford | Michigan | 26039 | 662 | 5 |
1145659 | 1145659 | 2021-03-22 | Crawford | Michigan | 26039 | 657 | 5 |
1142412 | 1142412 | 2021-03-21 | Crawford | Michigan | 26039 | 649 | 5 |
1139165 | 1139165 | 2021-03-20 | Crawford | Michigan | 26039 | 649 | 5 |
1135919 | 1135919 | 2021-03-19 | Crawford | Michigan | 26039 | 639 | 5 |
1132673 | 1132673 | 2021-03-18 | Crawford | Michigan | 26039 | 635 | 5 |
1129425 | 1129425 | 2021-03-17 | Crawford | Michigan | 26039 | 630 | 5 |
1126178 | 1126178 | 2021-03-16 | Crawford | Michigan | 26039 | 629 | 5 |
1122932 | 1122932 | 2021-03-15 | Crawford | Michigan | 26039 | 624 | 5 |
1119685 | 1119685 | 2021-03-14 | Crawford | Michigan | 26039 | 616 | 5 |
1116438 | 1116438 | 2021-03-13 | Crawford | Michigan | 26039 | 616 | 5 |
1113192 | 1113192 | 2021-03-12 | Crawford | Michigan | 26039 | 614 | 5 |
1109946 | 1109946 | 2021-03-11 | Crawford | Michigan | 26039 | 612 | 5 |
1106700 | 1106700 | 2021-03-10 | Crawford | Michigan | 26039 | 610 | 5 |
1103454 | 1103454 | 2021-03-09 | Crawford | Michigan | 26039 | 608 | 5 |
1100208 | 1100208 | 2021-03-08 | Crawford | Michigan | 26039 | 609 | 5 |
1096961 | 1096961 | 2021-03-07 | Crawford | Michigan | 26039 | 607 | 5 |
1093714 | 1093714 | 2021-03-06 | Crawford | Michigan | 26039 | 607 | 5 |
1090468 | 1090468 | 2021-03-05 | Crawford | Michigan | 26039 | 607 | 5 |
1087223 | 1087223 | 2021-03-04 | Crawford | Michigan | 26039 | 603 | 5 |
1083978 | 1083978 | 2021-03-03 | Crawford | Michigan | 26039 | 598 | 5 |
1080732 | 1080732 | 2021-03-02 | Crawford | Michigan | 26039 | 597 | 5 |
1077486 | 1077486 | 2021-03-01 | Crawford | Michigan | 26039 | 595 | 5 |
1074240 | 1074240 | 2021-02-28 | Crawford | Michigan | 26039 | 589 | 5 |
1070994 | 1070994 | 2021-02-27 | Crawford | Michigan | 26039 | 589 | 5 |
1067749 | 1067749 | 2021-02-26 | Crawford | Michigan | 26039 | 587 | 5 |
1064504 | 1064504 | 2021-02-25 | Crawford | Michigan | 26039 | 584 | 5 |
1061260 | 1061260 | 2021-02-24 | Crawford | Michigan | 26039 | 582 | 5 |
1058014 | 1058014 | 2021-02-23 | Crawford | Michigan | 26039 | 581 | 5 |
1054768 | 1054768 | 2021-02-22 | Crawford | Michigan | 26039 | 580 | 5 |
1051521 | 1051521 | 2021-02-21 | Crawford | Michigan | 26039 | 579 | 5 |
1048274 | 1048274 | 2021-02-20 | Crawford | Michigan | 26039 | 579 | 5 |
1045028 | 1045028 | 2021-02-19 | Crawford | Michigan | 26039 | 579 | 5 |
1041783 | 1041783 | 2021-02-18 | Crawford | Michigan | 26039 | 579 | 5 |
1038538 | 1038538 | 2021-02-17 | Crawford | Michigan | 26039 | 578 | 5 |
1035293 | 1035293 | 2021-02-16 | Crawford | Michigan | 26039 | 577 | 5 |
1032048 | 1032048 | 2021-02-15 | Crawford | Michigan | 26039 | 573 | 5 |
1028801 | 1028801 | 2021-02-14 | Crawford | Michigan | 26039 | 572 | 5 |
1025555 | 1025555 | 2021-02-13 | Crawford | Michigan | 26039 | 572 | 5 |
1022310 | 1022310 | 2021-02-12 | Crawford | Michigan | 26039 | 570 | 5 |
1019065 | 1019065 | 2021-02-11 | Crawford | Michigan | 26039 | 569 | 5 |
1015820 | 1015820 | 2021-02-10 | Crawford | Michigan | 26039 | 570 | 5 |
1012575 | 1012575 | 2021-02-09 | Crawford | Michigan | 26039 | 569 | 5 |
1009330 | 1009330 | 2021-02-08 | Crawford | Michigan | 26039 | 567 | 5 |
1006083 | 1006083 | 2021-02-07 | Crawford | Michigan | 26039 | 565 | 5 |
1002837 | 1002837 | 2021-02-06 | Crawford | Michigan | 26039 | 565 | 5 |
999592 | 999592 | 2021-02-05 | Crawford | Michigan | 26039 | 565 | 5 |
996346 | 996346 | 2021-02-04 | Crawford | Michigan | 26039 | 564 | 5 |
993100 | 993100 | 2021-02-03 | Crawford | Michigan | 26039 | 564 | 5 |
989854 | 989854 | 2021-02-02 | Crawford | Michigan | 26039 | 562 | 5 |
986607 | 986607 | 2021-02-01 | Crawford | Michigan | 26039 | 562 | 5 |
983360 | 983360 | 2021-01-31 | Crawford | Michigan | 26039 | 556 | 5 |
980114 | 980114 | 2021-01-30 | Crawford | Michigan | 26039 | 556 | 5 |
976868 | 976868 | 2021-01-29 | Crawford | Michigan | 26039 | 553 | 5 |
973623 | 973623 | 2021-01-28 | Crawford | Michigan | 26039 | 546 | 5 |
970378 | 970378 | 2021-01-27 | Crawford | Michigan | 26039 | 540 | 5 |
967133 | 967133 | 2021-01-26 | Crawford | Michigan | 26039 | 538 | 5 |
963889 | 963889 | 2021-01-25 | Crawford | Michigan | 26039 | 537 | 5 |
960644 | 960644 | 2021-01-24 | Crawford | Michigan | 26039 | 533 | 5 |
957398 | 957398 | 2021-01-23 | Crawford | Michigan | 26039 | 533 | 5 |
954153 | 954153 | 2021-01-22 | Crawford | Michigan | 26039 | 533 | 5 |
950908 | 950908 | 2021-01-21 | Crawford | Michigan | 26039 | 527 | 5 |
947662 | 947662 | 2021-01-20 | Crawford | Michigan | 26039 | 526 | 5 |
944415 | 944415 | 2021-01-19 | Crawford | Michigan | 26039 | 525 | 5 |
941170 | 941170 | 2021-01-18 | Crawford | Michigan | 26039 | 522 | 5 |
937925 | 937925 | 2021-01-17 | Crawford | Michigan | 26039 | 513 | 5 |
934680 | 934680 | 2021-01-16 | Crawford | Michigan | 26039 | 513 | 5 |
931435 | 931435 | 2021-01-15 | Crawford | Michigan | 26039 | 512 | 5 |
928190 | 928190 | 2021-01-14 | Crawford | Michigan | 26039 | 512 | 5 |
924944 | 924944 | 2021-01-13 | Crawford | Michigan | 26039 | 509 | 5 |
921699 | 921699 | 2021-01-12 | Crawford | Michigan | 26039 | 506 | 5 |
918454 | 918454 | 2021-01-11 | Crawford | Michigan | 26039 | 504 | 5 |
915209 | 915209 | 2021-01-10 | Crawford | Michigan | 26039 | 502 | 5 |
911964 | 911964 | 2021-01-09 | Crawford | Michigan | 26039 | 502 | 5 |
908719 | 908719 | 2021-01-08 | Crawford | Michigan | 26039 | 501 | 5 |
905473 | 905473 | 2021-01-07 | Crawford | Michigan | 26039 | 500 | 5 |
902228 | 902228 | 2021-01-06 | Crawford | Michigan | 26039 | 491 | 5 |
898983 | 898983 | 2021-01-05 | Crawford | Michigan | 26039 | 490 | 5 |
895738 | 895738 | 2021-01-04 | Crawford | Michigan | 26039 | 484 | 5 |
892491 | 892491 | 2021-01-03 | Crawford | Michigan | 26039 | 483 | 5 |
889245 | 889245 | 2021-01-02 | Crawford | Michigan | 26039 | 483 | 5 |
840568 | 840568 | 2020-12-18 | Crawford | Michigan | 26039 | 444 | 5 |
837323 | 837323 | 2020-12-17 | Crawford | Michigan | 26039 | 439 | 5 |
834077 | 834077 | 2020-12-16 | Crawford | Michigan | 26039 | 438 | 5 |
830830 | 830830 | 2020-12-15 | Crawford | Michigan | 26039 | 434 | 5 |
827584 | 827584 | 2020-12-14 | Crawford | Michigan | 26039 | 426 | 5 |
824337 | 824337 | 2020-12-13 | Crawford | Michigan | 26039 | 425 | 5 |
821091 | 821091 | 2020-12-12 | Crawford | Michigan | 26039 | 425 | 5 |
817845 | 817845 | 2020-12-11 | Crawford | Michigan | 26039 | 415 | 5 |
814599 | 814599 | 2020-12-10 | Crawford | Michigan | 26039 | 410 | 5 |
811354 | 811354 | 2020-12-09 | Crawford | Michigan | 26039 | 408 | 5 |
807562 | 807562 | 2020-12-08 | Crawford | Indiana | 18025 | 418 | 5 |
808109 | 808109 | 2020-12-08 | Crawford | Michigan | 26039 | 405 | 5 |
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);