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

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Carroll · 3,866 ✖
Link rowid date ▲ county state fips cases deaths
933616 933616 2021-01-16 Carroll Arkansas 5015 2400 34
933910 933910 2021-01-16 Carroll Georgia 13045 8699 142
934106 934106 2021-01-16 Carroll Illinois 17015 1422 33
934208 934208 2021-01-16 Carroll Indiana 18015 1514 16
934306 934306 2021-01-16 Carroll Iowa 19027 2530 34
934519 934519 2021-01-16 Carroll Kentucky 21041 734 8
934707 934707 2021-01-16 Carroll Maryland 24013 6260 180
934920 934920 2021-01-16 Carroll Mississippi 28015 1041 21
935011 935011 2021-01-16 Carroll Missouri 29033 730 18
935279 935279 2021-01-16 Carroll New Hampshire 33003 1175 4
935567 935567 2021-01-16 Carroll Ohio 39019 1480 16
936032 936032 2021-01-16 Carroll Tennessee 47017 3061 59
936442 936442 2021-01-16 Carroll Virginia 51035 1818 43
930371 930371 2021-01-15 Carroll Arkansas 5015 2380 34
930665 930665 2021-01-15 Carroll Georgia 13045 8630 141
930861 930861 2021-01-15 Carroll Illinois 17015 1418 32
930963 930963 2021-01-15 Carroll Indiana 18015 1506 16
931061 931061 2021-01-15 Carroll Iowa 19027 2527 33
931274 931274 2021-01-15 Carroll Kentucky 21041 726 8
931462 931462 2021-01-15 Carroll Maryland 24013 6215 180
931675 931675 2021-01-15 Carroll Mississippi 28015 1037 21
931766 931766 2021-01-15 Carroll Missouri 29033 728 18
932034 932034 2021-01-15 Carroll New Hampshire 33003 1168 4
932322 932322 2021-01-15 Carroll Ohio 39019 1448 16
932787 932787 2021-01-15 Carroll Tennessee 47017 3044 59
933197 933197 2021-01-15 Carroll Virginia 51035 1793 43
927126 927126 2021-01-14 Carroll Arkansas 5015 2358 33
927420 927420 2021-01-14 Carroll Georgia 13045 8516 141
927616 927616 2021-01-14 Carroll Illinois 17015 1415 32
927718 927718 2021-01-14 Carroll Indiana 18015 1502 16
927816 927816 2021-01-14 Carroll Iowa 19027 2524 33
928029 928029 2021-01-14 Carroll Kentucky 21041 717 8
928217 928217 2021-01-14 Carroll Maryland 24013 6144 179
928430 928430 2021-01-14 Carroll Mississippi 28015 1023 20
928521 928521 2021-01-14 Carroll Missouri 29033 726 18
928789 928789 2021-01-14 Carroll New Hampshire 33003 1142 4
929077 929077 2021-01-14 Carroll Ohio 39019 1432 16
929542 929542 2021-01-14 Carroll Tennessee 47017 3001 59
929952 929952 2021-01-14 Carroll Virginia 51035 1785 43
923880 923880 2021-01-13 Carroll Arkansas 5015 2335 33
924174 924174 2021-01-13 Carroll Georgia 13045 8453 138
924370 924370 2021-01-13 Carroll Illinois 17015 1407 32
924472 924472 2021-01-13 Carroll Indiana 18015 1495 16
924570 924570 2021-01-13 Carroll Iowa 19027 2514 33
924783 924783 2021-01-13 Carroll Kentucky 21041 706 7
924971 924971 2021-01-13 Carroll Maryland 24013 6066 179
925184 925184 2021-01-13 Carroll Mississippi 28015 1018 20
925275 925275 2021-01-13 Carroll Missouri 29033 718 18
925543 925543 2021-01-13 Carroll New Hampshire 33003 1121 4
925832 925832 2021-01-13 Carroll Ohio 39019 1418 15
926297 926297 2021-01-13 Carroll Tennessee 47017 2998 59
926707 926707 2021-01-13 Carroll Virginia 51035 1767 43
920635 920635 2021-01-12 Carroll Arkansas 5015 2310 33
920929 920929 2021-01-12 Carroll Georgia 13045 8399 137
921125 921125 2021-01-12 Carroll Illinois 17015 1399 32
921227 921227 2021-01-12 Carroll Indiana 18015 1486 16
921325 921325 2021-01-12 Carroll Iowa 19027 2507 33
921538 921538 2021-01-12 Carroll Kentucky 21041 692 7
921726 921726 2021-01-12 Carroll Maryland 24013 6020 178
921939 921939 2021-01-12 Carroll Mississippi 28015 1016 20
922030 922030 2021-01-12 Carroll Missouri 29033 717 18
922298 922298 2021-01-12 Carroll New Hampshire 33003 1097 4
922586 922586 2021-01-12 Carroll Ohio 39019 1406 15
923051 923051 2021-01-12 Carroll Tennessee 47017 2984 58
923461 923461 2021-01-12 Carroll Virginia 51035 1743 42
917390 917390 2021-01-11 Carroll Arkansas 5015 2287 33
917684 917684 2021-01-11 Carroll Georgia 13045 8349 133
917880 917880 2021-01-11 Carroll Illinois 17015 1387 32
917982 917982 2021-01-11 Carroll Indiana 18015 1483 16
918080 918080 2021-01-11 Carroll Iowa 19027 2499 32
918293 918293 2021-01-11 Carroll Kentucky 21041 679 7
918481 918481 2021-01-11 Carroll Maryland 24013 5958 178
918694 918694 2021-01-11 Carroll Mississippi 28015 1011 20
918785 918785 2021-01-11 Carroll Missouri 29033 715 18
919053 919053 2021-01-11 Carroll New Hampshire 33003 1079 4
919341 919341 2021-01-11 Carroll Ohio 39019 1385 14
919806 919806 2021-01-11 Carroll Tennessee 47017 2967 57
920216 920216 2021-01-11 Carroll Virginia 51035 1733 40
914145 914145 2021-01-10 Carroll Arkansas 5015 2281 33
914439 914439 2021-01-10 Carroll Georgia 13045 8279 133
914635 914635 2021-01-10 Carroll Illinois 17015 1381 32
914737 914737 2021-01-10 Carroll Indiana 18015 1474 16
914835 914835 2021-01-10 Carroll Iowa 19027 2484 32
915048 915048 2021-01-10 Carroll Kentucky 21041 676 7
915236 915236 2021-01-10 Carroll Maryland 24013 5900 177
915449 915449 2021-01-10 Carroll Mississippi 28015 1011 20
915540 915540 2021-01-10 Carroll Missouri 29033 709 18
915808 915808 2021-01-10 Carroll New Hampshire 33003 1057 4
916096 916096 2021-01-10 Carroll Ohio 39019 1333 14
916561 916561 2021-01-10 Carroll Tennessee 47017 2943 56
916971 916971 2021-01-10 Carroll Virginia 51035 1722 40
910900 910900 2021-01-09 Carroll Arkansas 5015 2255 31
911194 911194 2021-01-09 Carroll Georgia 13045 8217 133
911390 911390 2021-01-09 Carroll Illinois 17015 1380 32
911492 911492 2021-01-09 Carroll Indiana 18015 1462 16
911590 911590 2021-01-09 Carroll Iowa 19027 2481 32
911803 911803 2021-01-09 Carroll Kentucky 21041 664 7
911991 911991 2021-01-09 Carroll Maryland 24013 5846 177
912204 912204 2021-01-09 Carroll Mississippi 28015 1003 18
912295 912295 2021-01-09 Carroll Missouri 29033 704 18

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