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,725 rows where county = "Crawford" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Crawford · 3,725 ✖
Link rowid date ▲ county state fips cases deaths
1076351 1076351 2021-03-01 Crawford Arkansas 5033 6782 102
1076653 1076653 2021-03-01 Crawford Georgia 13079 620 16
1076841 1076841 2021-03-01 Crawford Illinois 17033 2007 39
1076940 1076940 2021-03-01 Crawford Indiana 18025 909 14
1077043 1077043 2021-03-01 Crawford Iowa 19047 2471 35
1077138 1077138 2021-03-01 Crawford Kansas 20037 4514 80
1077486 1077486 2021-03-01 Crawford Michigan 26039 595 5
1077748 1077748 2021-03-01 Crawford Missouri 29055 2052 30
1078300 1078300 2021-03-01 Crawford Ohio 39033 3574 96
1078505 1078505 2021-03-01 Crawford Pennsylvania 42039 6374 136
1079386 1079386 2021-03-01 Crawford Wisconsin 55023 1718 17
1073105 1073105 2021-02-28 Crawford Arkansas 5033 6781 102
1073407 1073407 2021-02-28 Crawford Georgia 13079 620 16
1073595 1073595 2021-02-28 Crawford Illinois 17033 2007 39
1073694 1073694 2021-02-28 Crawford Indiana 18025 908 14
1073797 1073797 2021-02-28 Crawford Iowa 19047 2471 35
1073892 1073892 2021-02-28 Crawford Kansas 20037 4502 80
1074240 1074240 2021-02-28 Crawford Michigan 26039 589 5
1074502 1074502 2021-02-28 Crawford Missouri 29055 2051 30
1075055 1075055 2021-02-28 Crawford Ohio 39033 3566 96
1075260 1075260 2021-02-28 Crawford Pennsylvania 42039 6360 136
1076141 1076141 2021-02-28 Crawford Wisconsin 55023 1718 17
1069859 1069859 2021-02-27 Crawford Arkansas 5033 6756 107
1070161 1070161 2021-02-27 Crawford Georgia 13079 620 16
1070349 1070349 2021-02-27 Crawford Illinois 17033 2007 39
1070448 1070448 2021-02-27 Crawford Indiana 18025 905 14
1070551 1070551 2021-02-27 Crawford Iowa 19047 2471 35
1070646 1070646 2021-02-27 Crawford Kansas 20037 4502 80
1070994 1070994 2021-02-27 Crawford Michigan 26039 589 5
1071256 1071256 2021-02-27 Crawford Missouri 29055 2049 30
1071809 1071809 2021-02-27 Crawford Ohio 39033 3561 96
1072014 1072014 2021-02-27 Crawford Pennsylvania 42039 6345 136
1072895 1072895 2021-02-27 Crawford Wisconsin 55023 1717 17
1066614 1066614 2021-02-26 Crawford Arkansas 5033 6740 107
1066916 1066916 2021-02-26 Crawford Georgia 13079 618 16
1067104 1067104 2021-02-26 Crawford Illinois 17033 2005 38
1067203 1067203 2021-02-26 Crawford Indiana 18025 905 14
1067306 1067306 2021-02-26 Crawford Iowa 19047 2471 35
1067401 1067401 2021-02-26 Crawford Kansas 20037 4502 80
1067749 1067749 2021-02-26 Crawford Michigan 26039 587 5
1068011 1068011 2021-02-26 Crawford Missouri 29055 2048 30
1068563 1068563 2021-02-26 Crawford Ohio 39033 3560 96
1068768 1068768 2021-02-26 Crawford Pennsylvania 42039 6334 136
1069649 1069649 2021-02-26 Crawford Wisconsin 55023 1717 17
1063369 1063369 2021-02-25 Crawford Arkansas 5033 6735 107
1063671 1063671 2021-02-25 Crawford Georgia 13079 619 16
1063859 1063859 2021-02-25 Crawford Illinois 17033 2003 37
1063958 1063958 2021-02-25 Crawford Indiana 18025 906 14
1064061 1064061 2021-02-25 Crawford Iowa 19047 2471 35
1064156 1064156 2021-02-25 Crawford Kansas 20037 4494 77
1064504 1064504 2021-02-25 Crawford Michigan 26039 584 5
1064766 1064766 2021-02-25 Crawford Missouri 29055 2047 30
1065318 1065318 2021-02-25 Crawford Ohio 39033 3557 96
1065523 1065523 2021-02-25 Crawford Pennsylvania 42039 6321 136
1066404 1066404 2021-02-25 Crawford Wisconsin 55023 1717 17
1060124 1060124 2021-02-24 Crawford Arkansas 5033 6718 105
1060426 1060426 2021-02-24 Crawford Georgia 13079 617 16
1060614 1060614 2021-02-24 Crawford Illinois 17033 2000 37
1060713 1060713 2021-02-24 Crawford Indiana 18025 903 14
1060816 1060816 2021-02-24 Crawford Iowa 19047 2471 35
1060911 1060911 2021-02-24 Crawford Kansas 20037 4494 77
1061260 1061260 2021-02-24 Crawford Michigan 26039 582 5
1061522 1061522 2021-02-24 Crawford Missouri 29055 2045 30
1062074 1062074 2021-02-24 Crawford Ohio 39033 3553 96
1062278 1062278 2021-02-24 Crawford Pennsylvania 42039 6307 136
1063159 1063159 2021-02-24 Crawford Wisconsin 55023 1714 17
1056878 1056878 2021-02-23 Crawford Arkansas 5033 6706 105
1057180 1057180 2021-02-23 Crawford Georgia 13079 617 16
1057368 1057368 2021-02-23 Crawford Illinois 17033 2000 37
1057467 1057467 2021-02-23 Crawford Indiana 18025 903 14
1057570 1057570 2021-02-23 Crawford Iowa 19047 2471 35
1057665 1057665 2021-02-23 Crawford Kansas 20037 4482 77
1058014 1058014 2021-02-23 Crawford Michigan 26039 581 5
1058276 1058276 2021-02-23 Crawford Missouri 29055 2044 30
1058828 1058828 2021-02-23 Crawford Ohio 39033 3542 96
1059033 1059033 2021-02-23 Crawford Pennsylvania 42039 6290 136
1059914 1059914 2021-02-23 Crawford Wisconsin 55023 1714 17
1053632 1053632 2021-02-22 Crawford Arkansas 5033 6698 104
1053934 1053934 2021-02-22 Crawford Georgia 13079 615 16
1054122 1054122 2021-02-22 Crawford Illinois 17033 1996 37
1054221 1054221 2021-02-22 Crawford Indiana 18025 900 14
1054324 1054324 2021-02-22 Crawford Iowa 19047 2471 35
1054419 1054419 2021-02-22 Crawford Kansas 20037 4482 77
1054768 1054768 2021-02-22 Crawford Michigan 26039 580 5
1055030 1055030 2021-02-22 Crawford Missouri 29055 2040 29
1055582 1055582 2021-02-22 Crawford Ohio 39033 3539 95
1055787 1055787 2021-02-22 Crawford Pennsylvania 42039 6282 136
1056668 1056668 2021-02-22 Crawford Wisconsin 55023 1713 17
1050385 1050385 2021-02-21 Crawford Arkansas 5033 6694 104
1050687 1050687 2021-02-21 Crawford Georgia 13079 614 16
1050875 1050875 2021-02-21 Crawford Illinois 17033 1995 37
1050974 1050974 2021-02-21 Crawford Indiana 18025 900 14
1051077 1051077 2021-02-21 Crawford Iowa 19047 2471 35
1051172 1051172 2021-02-21 Crawford Kansas 20037 4466 77
1051521 1051521 2021-02-21 Crawford Michigan 26039 579 5
1051783 1051783 2021-02-21 Crawford Missouri 29055 2039 29
1052336 1052336 2021-02-21 Crawford Ohio 39033 3532 95
1052541 1052541 2021-02-21 Crawford Pennsylvania 42039 6273 136
1053422 1053422 2021-02-21 Crawford Wisconsin 55023 1711 17
1047138 1047138 2021-02-20 Crawford Arkansas 5033 6687 104

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);