ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

3,296 rows where county = "Crawford" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Crawford · 3,296 ✖
Link rowid date ▲ county state fips cases deaths
949853 949853 2021-01-21 Crawford Arkansas 5033 5808 79
950155 950155 2021-01-21 Crawford Georgia 13079 525 10
950343 950343 2021-01-21 Crawford Illinois 17033 1794 34
950441 950441 2021-01-21 Crawford Indiana 18025 785 10
950544 950544 2021-01-21 Crawford Iowa 19047 2330 24
950639 950639 2021-01-21 Crawford Kansas 20037 4026 35
950988 950988 2021-01-21 Crawford Michigan 26039 527 5
951250 951250 2021-01-21 Crawford Missouri 29055 1928 23
951802 951802 2021-01-21 Crawford Ohio 39033 3194 72
952007 952007 2021-01-21 Crawford Pennsylvania 42039 5664 117
952888 952888 2021-01-21 Crawford Wisconsin 55023 1668 14
946607 946607 2021-01-20 Crawford Arkansas 5033 5708 79
946909 946909 2021-01-20 Crawford Georgia 13079 518 10
947097 947097 2021-01-20 Crawford Illinois 17033 1778 34
947195 947195 2021-01-20 Crawford Indiana 18025 778 10
947298 947298 2021-01-20 Crawford Iowa 19047 2323 24
947393 947393 2021-01-20 Crawford Kansas 20037 4026 35
947742 947742 2021-01-20 Crawford Michigan 26039 526 5
948004 948004 2021-01-20 Crawford Missouri 29055 1922 23
948557 948557 2021-01-20 Crawford Ohio 39033 3180 72
948762 948762 2021-01-20 Crawford Pennsylvania 42039 5648 115
949643 949643 2021-01-20 Crawford Wisconsin 55023 1667 14
943360 943360 2021-01-19 Crawford Arkansas 5033 5639 76
943662 943662 2021-01-19 Crawford Georgia 13079 516 10
943850 943850 2021-01-19 Crawford Illinois 17033 1761 34
943948 943948 2021-01-19 Crawford Indiana 18025 773 10
944051 944051 2021-01-19 Crawford Iowa 19047 2310 22
944146 944146 2021-01-19 Crawford Kansas 20037 3966 35
944495 944495 2021-01-19 Crawford Michigan 26039 525 5
944757 944757 2021-01-19 Crawford Missouri 29055 1916 21
945311 945311 2021-01-19 Crawford Ohio 39033 3163 71
945516 945516 2021-01-19 Crawford Pennsylvania 42039 5620 115
946397 946397 2021-01-19 Crawford Wisconsin 55023 1664 14
940115 940115 2021-01-18 Crawford Arkansas 5033 5610 75
940417 940417 2021-01-18 Crawford Georgia 13079 511 10
940605 940605 2021-01-18 Crawford Illinois 17033 1755 34
940703 940703 2021-01-18 Crawford Indiana 18025 768 10
940806 940806 2021-01-18 Crawford Iowa 19047 2295 22
940901 940901 2021-01-18 Crawford Kansas 20037 3966 35
941250 941250 2021-01-18 Crawford Michigan 26039 522 5
941512 941512 2021-01-18 Crawford Missouri 29055 1914 21
942064 942064 2021-01-18 Crawford Ohio 39033 3151 69
942269 942269 2021-01-18 Crawford Pennsylvania 42039 5596 114
943150 943150 2021-01-18 Crawford Wisconsin 55023 1663 13
936870 936870 2021-01-17 Crawford Arkansas 5033 5571 74
937172 937172 2021-01-17 Crawford Georgia 13079 510 10
937360 937360 2021-01-17 Crawford Illinois 17033 1753 34
937458 937458 2021-01-17 Crawford Indiana 18025 759 10
937561 937561 2021-01-17 Crawford Iowa 19047 2283 22
937656 937656 2021-01-17 Crawford Kansas 20037 3927 35
938005 938005 2021-01-17 Crawford Michigan 26039 513 5
938267 938267 2021-01-17 Crawford Missouri 29055 1908 21
938819 938819 2021-01-17 Crawford Ohio 39033 3132 68
939024 939024 2021-01-17 Crawford Pennsylvania 42039 5565 113
939905 939905 2021-01-17 Crawford Wisconsin 55023 1665 13
933625 933625 2021-01-16 Crawford Arkansas 5033 5543 74
933927 933927 2021-01-16 Crawford Georgia 13079 505 10
934115 934115 2021-01-16 Crawford Illinois 17033 1749 34
934213 934213 2021-01-16 Crawford Indiana 18025 749 10
934316 934316 2021-01-16 Crawford Iowa 19047 2283 22
934411 934411 2021-01-16 Crawford Kansas 20037 3927 35
934760 934760 2021-01-16 Crawford Michigan 26039 513 5
935022 935022 2021-01-16 Crawford Missouri 29055 1906 21
935574 935574 2021-01-16 Crawford Ohio 39033 3119 68
935779 935779 2021-01-16 Crawford Pennsylvania 42039 5539 111
936660 936660 2021-01-16 Crawford Wisconsin 55023 1662 13
930380 930380 2021-01-15 Crawford Arkansas 5033 5509 74
930682 930682 2021-01-15 Crawford Georgia 13079 498 10
930870 930870 2021-01-15 Crawford Illinois 17033 1734 34
930968 930968 2021-01-15 Crawford Indiana 18025 741 10
931071 931071 2021-01-15 Crawford Iowa 19047 2277 22
931166 931166 2021-01-15 Crawford Kansas 20037 3927 35
931515 931515 2021-01-15 Crawford Michigan 26039 512 5
931777 931777 2021-01-15 Crawford Missouri 29055 1898 21
932329 932329 2021-01-15 Crawford Ohio 39033 3091 68
932534 932534 2021-01-15 Crawford Pennsylvania 42039 5509 109
933415 933415 2021-01-15 Crawford Wisconsin 55023 1660 13
927135 927135 2021-01-14 Crawford Arkansas 5033 5427 73
927437 927437 2021-01-14 Crawford Georgia 13079 491 10
927625 927625 2021-01-14 Crawford Illinois 17033 1727 34
927723 927723 2021-01-14 Crawford Indiana 18025 724 10
927826 927826 2021-01-14 Crawford Iowa 19047 2274 22
927921 927921 2021-01-14 Crawford Kansas 20037 3882 35
928270 928270 2021-01-14 Crawford Michigan 26039 512 5
928532 928532 2021-01-14 Crawford Missouri 29055 1887 21
929084 929084 2021-01-14 Crawford Ohio 39033 3067 69
929289 929289 2021-01-14 Crawford Pennsylvania 42039 5473 108
930170 930170 2021-01-14 Crawford Wisconsin 55023 1659 13
923889 923889 2021-01-13 Crawford Arkansas 5033 5385 73
924191 924191 2021-01-13 Crawford Georgia 13079 489 10
924379 924379 2021-01-13 Crawford Illinois 17033 1719 32
924477 924477 2021-01-13 Crawford Indiana 18025 713 10
924580 924580 2021-01-13 Crawford Iowa 19047 2266 22
924675 924675 2021-01-13 Crawford Kansas 20037 3882 35
925024 925024 2021-01-13 Crawford Michigan 26039 509 5
925286 925286 2021-01-13 Crawford Missouri 29055 1869 21
925839 925839 2021-01-13 Crawford Ohio 39033 3030 67
926044 926044 2021-01-13 Crawford Pennsylvania 42039 5425 107
926925 926925 2021-01-13 Crawford Wisconsin 55023 1656 13
920644 920644 2021-01-12 Crawford Arkansas 5033 5320 69

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);