ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,543 rows where county = "Crawford" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
891846 | 891846 | 2021-01-03 | Crawford | Illinois | 17033 | 1592 | 31 |
891944 | 891944 | 2021-01-03 | Crawford | Indiana | 18025 | 622 | 8 |
892047 | 892047 | 2021-01-03 | Crawford | Iowa | 19047 | 2134 | 22 |
892142 | 892142 | 2021-01-03 | Crawford | Kansas | 20037 | 3454 | 32 |
892491 | 892491 | 2021-01-03 | Crawford | Michigan | 26039 | 483 | 5 |
892753 | 892753 | 2021-01-03 | Crawford | Missouri | 29055 | 1765 | 19 |
893306 | 893306 | 2021-01-03 | Crawford | Ohio | 39033 | 2710 | 61 |
893511 | 893511 | 2021-01-03 | Crawford | Pennsylvania | 42039 | 5021 | 84 |
894392 | 894392 | 2021-01-03 | Crawford | Wisconsin | 55023 | 1606 | 12 |
888109 | 888109 | 2021-01-02 | Crawford | Arkansas | 5033 | 4601 | 60 |
888411 | 888411 | 2021-01-02 | Crawford | Georgia | 13079 | 435 | 8 |
888599 | 888599 | 2021-01-02 | Crawford | Illinois | 17033 | 1588 | 31 |
888698 | 888698 | 2021-01-02 | Crawford | Indiana | 18025 | 614 | 8 |
888801 | 888801 | 2021-01-02 | Crawford | Iowa | 19047 | 2135 | 22 |
888896 | 888896 | 2021-01-02 | Crawford | Kansas | 20037 | 3454 | 32 |
889245 | 889245 | 2021-01-02 | Crawford | Michigan | 26039 | 483 | 5 |
889507 | 889507 | 2021-01-02 | Crawford | Missouri | 29055 | 1741 | 19 |
890060 | 890060 | 2021-01-02 | Crawford | Ohio | 39033 | 2681 | 61 |
890265 | 890265 | 2021-01-02 | Crawford | Pennsylvania | 42039 | 4982 | 84 |
891146 | 891146 | 2021-01-02 | Crawford | Wisconsin | 55023 | 1602 | 12 |
884864 | 884864 | 2021-01-01 | Crawford | Arkansas | 5033 | 4542 | 59 |
885166 | 885166 | 2021-01-01 | Crawford | Georgia | 13079 | 428 | 8 |
885354 | 885354 | 2021-01-01 | Crawford | Illinois | 17033 | 1578 | 31 |
885452 | 885452 | 2021-01-01 | Crawford | Indiana | 18025 | 604 | 8 |
885555 | 885555 | 2021-01-01 | Crawford | Iowa | 19047 | 2133 | 22 |
885650 | 885650 | 2021-01-01 | Crawford | Kansas | 20037 | 3454 | 32 |
885999 | 885999 | 2021-01-01 | Crawford | Michigan | 26039 | 457 | 6 |
886261 | 886261 | 2021-01-01 | Crawford | Missouri | 29055 | 1731 | 19 |
886813 | 886813 | 2021-01-01 | Crawford | Ohio | 39033 | 2616 | 61 |
887018 | 887018 | 2021-01-01 | Crawford | Pennsylvania | 42039 | 4947 | 84 |
887899 | 887899 | 2021-01-01 | Crawford | Wisconsin | 55023 | 1599 | 12 |
881619 | 881619 | 2020-12-31 | Crawford | Arkansas | 5033 | 4451 | 58 |
881921 | 881921 | 2020-12-31 | Crawford | Georgia | 13079 | 422 | 8 |
882109 | 882109 | 2020-12-31 | Crawford | Illinois | 17033 | 1578 | 31 |
882207 | 882207 | 2020-12-31 | Crawford | Indiana | 18025 | 592 | 8 |
882310 | 882310 | 2020-12-31 | Crawford | Iowa | 19047 | 2127 | 22 |
882405 | 882405 | 2020-12-31 | Crawford | Kansas | 20037 | 3379 | 32 |
882754 | 882754 | 2020-12-31 | Crawford | Michigan | 26039 | 457 | 6 |
883016 | 883016 | 2020-12-31 | Crawford | Missouri | 29055 | 1706 | 19 |
883568 | 883568 | 2020-12-31 | Crawford | Ohio | 39033 | 2616 | 61 |
883773 | 883773 | 2020-12-31 | Crawford | Pennsylvania | 42039 | 4859 | 84 |
884654 | 884654 | 2020-12-31 | Crawford | Wisconsin | 55023 | 1596 | 12 |
878374 | 878374 | 2020-12-30 | Crawford | Arkansas | 5033 | 4402 | 58 |
878676 | 878676 | 2020-12-30 | Crawford | Georgia | 13079 | 414 | 8 |
878864 | 878864 | 2020-12-30 | Crawford | Illinois | 17033 | 1562 | 29 |
878962 | 878962 | 2020-12-30 | Crawford | Indiana | 18025 | 584 | 8 |
879065 | 879065 | 2020-12-30 | Crawford | Iowa | 19047 | 2107 | 22 |
879160 | 879160 | 2020-12-30 | Crawford | Kansas | 20037 | 3379 | 32 |
879509 | 879509 | 2020-12-30 | Crawford | Michigan | 26039 | 457 | 6 |
879771 | 879771 | 2020-12-30 | Crawford | Missouri | 29055 | 1680 | 19 |
880323 | 880323 | 2020-12-30 | Crawford | Ohio | 39033 | 2573 | 60 |
880528 | 880528 | 2020-12-30 | Crawford | Pennsylvania | 42039 | 4809 | 76 |
881409 | 881409 | 2020-12-30 | Crawford | Wisconsin | 55023 | 1591 | 12 |
875129 | 875129 | 2020-12-29 | Crawford | Arkansas | 5033 | 4323 | 58 |
875431 | 875431 | 2020-12-29 | Crawford | Georgia | 13079 | 402 | 8 |
875619 | 875619 | 2020-12-29 | Crawford | Illinois | 17033 | 1551 | 29 |
875717 | 875717 | 2020-12-29 | Crawford | Indiana | 18025 | 579 | 8 |
875820 | 875820 | 2020-12-29 | Crawford | Iowa | 19047 | 2104 | 22 |
875915 | 875915 | 2020-12-29 | Crawford | Kansas | 20037 | 3244 | 29 |
876264 | 876264 | 2020-12-29 | Crawford | Michigan | 26039 | 455 | 6 |
876526 | 876526 | 2020-12-29 | Crawford | Missouri | 29055 | 1666 | 19 |
877078 | 877078 | 2020-12-29 | Crawford | Ohio | 39033 | 2527 | 59 |
877283 | 877283 | 2020-12-29 | Crawford | Pennsylvania | 42039 | 4760 | 74 |
878164 | 878164 | 2020-12-29 | Crawford | Wisconsin | 55023 | 1583 | 12 |
871884 | 871884 | 2020-12-28 | Crawford | Arkansas | 5033 | 4285 | 58 |
872186 | 872186 | 2020-12-28 | Crawford | Georgia | 13079 | 398 | 8 |
872374 | 872374 | 2020-12-28 | Crawford | Illinois | 17033 | 1536 | 29 |
872472 | 872472 | 2020-12-28 | Crawford | Indiana | 18025 | 572 | 8 |
872575 | 872575 | 2020-12-28 | Crawford | Iowa | 19047 | 2084 | 21 |
872670 | 872670 | 2020-12-28 | Crawford | Kansas | 20037 | 3244 | 29 |
873019 | 873019 | 2020-12-28 | Crawford | Michigan | 26039 | 452 | 6 |
873281 | 873281 | 2020-12-28 | Crawford | Missouri | 29055 | 1648 | 19 |
873833 | 873833 | 2020-12-28 | Crawford | Ohio | 39033 | 2496 | 44 |
874038 | 874038 | 2020-12-28 | Crawford | Pennsylvania | 42039 | 4702 | 72 |
874919 | 874919 | 2020-12-28 | Crawford | Wisconsin | 55023 | 1582 | 12 |
868639 | 868639 | 2020-12-27 | Crawford | Arkansas | 5033 | 4241 | 58 |
868941 | 868941 | 2020-12-27 | Crawford | Georgia | 13079 | 390 | 8 |
869129 | 869129 | 2020-12-27 | Crawford | Illinois | 17033 | 1537 | 29 |
869227 | 869227 | 2020-12-27 | Crawford | Indiana | 18025 | 570 | 8 |
869330 | 869330 | 2020-12-27 | Crawford | Iowa | 19047 | 2074 | 21 |
869425 | 869425 | 2020-12-27 | Crawford | Kansas | 20037 | 3159 | 27 |
869774 | 869774 | 2020-12-27 | Crawford | Michigan | 26039 | 448 | 6 |
870036 | 870036 | 2020-12-27 | Crawford | Missouri | 29055 | 1637 | 19 |
870588 | 870588 | 2020-12-27 | Crawford | Ohio | 39033 | 2482 | 43 |
870793 | 870793 | 2020-12-27 | Crawford | Pennsylvania | 42039 | 4690 | 70 |
871674 | 871674 | 2020-12-27 | Crawford | Wisconsin | 55023 | 1579 | 12 |
865394 | 865394 | 2020-12-26 | Crawford | Arkansas | 5033 | 4223 | 58 |
865696 | 865696 | 2020-12-26 | Crawford | Georgia | 13079 | 386 | 8 |
865884 | 865884 | 2020-12-26 | Crawford | Illinois | 17033 | 1527 | 29 |
865982 | 865982 | 2020-12-26 | Crawford | Indiana | 18025 | 570 | 8 |
866085 | 866085 | 2020-12-26 | Crawford | Iowa | 19047 | 2065 | 21 |
866180 | 866180 | 2020-12-26 | Crawford | Kansas | 20037 | 3159 | 27 |
866529 | 866529 | 2020-12-26 | Crawford | Michigan | 26039 | 448 | 6 |
866791 | 866791 | 2020-12-26 | Crawford | Missouri | 29055 | 1629 | 19 |
867343 | 867343 | 2020-12-26 | Crawford | Ohio | 39033 | 2462 | 43 |
867548 | 867548 | 2020-12-26 | Crawford | Pennsylvania | 42039 | 4665 | 70 |
868429 | 868429 | 2020-12-26 | Crawford | Wisconsin | 55023 | 1578 | 12 |
862149 | 862149 | 2020-12-25 | Crawford | Arkansas | 5033 | 4214 | 58 |
862451 | 862451 | 2020-12-25 | Crawford | Georgia | 13079 | 383 | 8 |
862639 | 862639 | 2020-12-25 | Crawford | Illinois | 17033 | 1526 | 29 |
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);