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

4,438 rows where county = "Carroll" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Carroll · 4,438 ✖
Link rowid date ▲ county state fips cases deaths
1076342 1076342 2021-03-01 Carroll Arkansas 5015 2713 42
1076636 1076636 2021-03-01 Carroll Georgia 13045 10575 213
1076832 1076832 2021-03-01 Carroll Illinois 17015 1576 35
1076935 1076935 2021-03-01 Carroll Indiana 18015 1767 20
1077033 1077033 2021-03-01 Carroll Iowa 19027 2639 48
1077246 1077246 2021-03-01 Carroll Kentucky 21041 889 10
1077433 1077433 2021-03-01 Carroll Maryland 24013 7553 214
1077646 1077646 2021-03-01 Carroll Mississippi 28015 1182 25
1077737 1077737 2021-03-01 Carroll Missouri 29033 835 23
1078005 1078005 2021-03-01 Carroll New Hampshire 33003 1716 6
1078293 1078293 2021-03-01 Carroll Ohio 39019 1808 28
1078758 1078758 2021-03-01 Carroll Tennessee 47017 3486 81
1079168 1079168 2021-03-01 Carroll Virginia 51035 2115 60
1073096 1073096 2021-02-28 Carroll Arkansas 5015 2713 41
1073390 1073390 2021-02-28 Carroll Georgia 13045 10564 213
1073586 1073586 2021-02-28 Carroll Illinois 17015 1576 35
1073689 1073689 2021-02-28 Carroll Indiana 18015 1767 20
1073787 1073787 2021-02-28 Carroll Iowa 19027 2639 48
1074000 1074000 2021-02-28 Carroll Kentucky 21041 884 10
1074187 1074187 2021-02-28 Carroll Maryland 24013 7548 214
1074400 1074400 2021-02-28 Carroll Mississippi 28015 1181 25
1074491 1074491 2021-02-28 Carroll Missouri 29033 835 23
1074759 1074759 2021-02-28 Carroll New Hampshire 33003 1711 6
1075048 1075048 2021-02-28 Carroll Ohio 39019 1803 28
1075513 1075513 2021-02-28 Carroll Tennessee 47017 3479 81
1075923 1075923 2021-02-28 Carroll Virginia 51035 2107 59
1069850 1069850 2021-02-27 Carroll Arkansas 5015 2718 41
1070144 1070144 2021-02-27 Carroll Georgia 13045 10553 213
1070340 1070340 2021-02-27 Carroll Illinois 17015 1576 35
1070443 1070443 2021-02-27 Carroll Indiana 18015 1766 20
1070541 1070541 2021-02-27 Carroll Iowa 19027 2639 48
1070754 1070754 2021-02-27 Carroll Kentucky 21041 884 10
1070941 1070941 2021-02-27 Carroll Maryland 24013 7536 213
1071154 1071154 2021-02-27 Carroll Mississippi 28015 1181 24
1071245 1071245 2021-02-27 Carroll Missouri 29033 835 23
1071513 1071513 2021-02-27 Carroll New Hampshire 33003 1705 6
1071802 1071802 2021-02-27 Carroll Ohio 39019 1802 28
1072267 1072267 2021-02-27 Carroll Tennessee 47017 3471 81
1072677 1072677 2021-02-27 Carroll Virginia 51035 2104 59
1066605 1066605 2021-02-26 Carroll Arkansas 5015 2718 41
1066899 1066899 2021-02-26 Carroll Georgia 13045 10528 210
1067095 1067095 2021-02-26 Carroll Illinois 17015 1574 35
1067198 1067198 2021-02-26 Carroll Indiana 18015 1764 20
1067296 1067296 2021-02-26 Carroll Iowa 19027 2639 48
1067509 1067509 2021-02-26 Carroll Kentucky 21041 882 10
1067696 1067696 2021-02-26 Carroll Maryland 24013 7521 212
1067909 1067909 2021-02-26 Carroll Mississippi 28015 1179 23
1068000 1068000 2021-02-26 Carroll Missouri 29033 834 23
1068268 1068268 2021-02-26 Carroll New Hampshire 33003 1700 6
1068556 1068556 2021-02-26 Carroll Ohio 39019 1798 28
1069021 1069021 2021-02-26 Carroll Tennessee 47017 3473 81
1069431 1069431 2021-02-26 Carroll Virginia 51035 2100 59
1063360 1063360 2021-02-25 Carroll Arkansas 5015 2714 41
1063654 1063654 2021-02-25 Carroll Georgia 13045 10498 210
1063850 1063850 2021-02-25 Carroll Illinois 17015 1569 35
1063953 1063953 2021-02-25 Carroll Indiana 18015 1763 20
1064051 1064051 2021-02-25 Carroll Iowa 19027 2639 48
1064264 1064264 2021-02-25 Carroll Kentucky 21041 880 10
1064451 1064451 2021-02-25 Carroll Maryland 24013 7491 212
1064664 1064664 2021-02-25 Carroll Mississippi 28015 1176 23
1064755 1064755 2021-02-25 Carroll Missouri 29033 833 23
1065023 1065023 2021-02-25 Carroll New Hampshire 33003 1695 6
1065311 1065311 2021-02-25 Carroll Ohio 39019 1795 28
1065776 1065776 2021-02-25 Carroll Tennessee 47017 3470 81
1066186 1066186 2021-02-25 Carroll Virginia 51035 2097 59
1060115 1060115 2021-02-24 Carroll Arkansas 5015 2711 41
1060409 1060409 2021-02-24 Carroll Georgia 13045 10471 205
1060605 1060605 2021-02-24 Carroll Illinois 17015 1566 35
1060708 1060708 2021-02-24 Carroll Indiana 18015 1759 20
1060806 1060806 2021-02-24 Carroll Iowa 19027 2639 48
1061019 1061019 2021-02-24 Carroll Kentucky 21041 878 10
1061207 1061207 2021-02-24 Carroll Maryland 24013 7480 211
1061420 1061420 2021-02-24 Carroll Mississippi 28015 1172 23
1061511 1061511 2021-02-24 Carroll Missouri 29033 833 23
1061779 1061779 2021-02-24 Carroll New Hampshire 33003 1684 6
1062067 1062067 2021-02-24 Carroll Ohio 39019 1789 28
1062531 1062531 2021-02-24 Carroll Tennessee 47017 3468 81
1062941 1062941 2021-02-24 Carroll Virginia 51035 2091 58
1056869 1056869 2021-02-23 Carroll Arkansas 5015 2711 41
1057163 1057163 2021-02-23 Carroll Georgia 13045 10437 204
1057359 1057359 2021-02-23 Carroll Illinois 17015 1564 35
1057462 1057462 2021-02-23 Carroll Indiana 18015 1758 20
1057560 1057560 2021-02-23 Carroll Iowa 19027 2639 48
1057773 1057773 2021-02-23 Carroll Kentucky 21041 874 10
1057961 1057961 2021-02-23 Carroll Maryland 24013 7465 210
1058174 1058174 2021-02-23 Carroll Mississippi 28015 1171 23
1058265 1058265 2021-02-23 Carroll Missouri 29033 833 23
1058533 1058533 2021-02-23 Carroll New Hampshire 33003 1668 6
1058821 1058821 2021-02-23 Carroll Ohio 39019 1788 28
1059286 1059286 2021-02-23 Carroll Tennessee 47017 3465 80
1059696 1059696 2021-02-23 Carroll Virginia 51035 2078 58
1053623 1053623 2021-02-22 Carroll Arkansas 5015 2710 41
1053917 1053917 2021-02-22 Carroll Georgia 13045 10398 203
1054113 1054113 2021-02-22 Carroll Illinois 17015 1561 35
1054216 1054216 2021-02-22 Carroll Indiana 18015 1758 20
1054314 1054314 2021-02-22 Carroll Iowa 19027 2639 48
1054527 1054527 2021-02-22 Carroll Kentucky 21041 872 10
1054715 1054715 2021-02-22 Carroll Maryland 24013 7452 208
1054928 1054928 2021-02-22 Carroll Mississippi 28015 1169 23
1055019 1055019 2021-02-22 Carroll Missouri 29033 832 22

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