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

7,506 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 · 7,506 ✖
Link rowid date ▲ county state fips cases deaths
1842725 1842725 2021-10-23 Carroll Arkansas 5015 4291 74
1843019 1843019 2021-10-23 Carroll Georgia 13045 16350 301
1843216 1843216 2021-10-23 Carroll Illinois 17015 2371 39
1843319 1843319 2021-10-23 Carroll Indiana 18015 2621 36
1843417 1843417 2021-10-23 Carroll Iowa 19027 3463 53
1843629 1843629 2021-10-23 Carroll Kentucky 21041 1862 26
1843817 1843817 2021-10-23 Carroll Maryland 24013 11654 287
1844030 1844030 2021-10-23 Carroll Mississippi 28015 1691 38
1844121 1844121 2021-10-23 Carroll Missouri 29033 1373 27
1844390 1844390 2021-10-23 Carroll New Hampshire 33003 3727 19
1844678 1844678 2021-10-23 Carroll Ohio 39019 3023 65
1845144 1845144 2021-10-23 Carroll Tennessee 47017 5712 102
1845554 1845554 2021-10-23 Carroll Virginia 51035 3884 92
1839475 1839475 2021-10-22 Carroll Arkansas 5015 4286 74
1839769 1839769 2021-10-22 Carroll Georgia 13045 16350 301
1839966 1839966 2021-10-22 Carroll Illinois 17015 2371 39
1840069 1840069 2021-10-22 Carroll Indiana 18015 2621 36
1840167 1840167 2021-10-22 Carroll Iowa 19027 3463 53
1840379 1840379 2021-10-22 Carroll Kentucky 21041 1862 26
1840567 1840567 2021-10-22 Carroll Maryland 24013 11641 287
1840780 1840780 2021-10-22 Carroll Mississippi 28015 1691 38
1840871 1840871 2021-10-22 Carroll Missouri 29033 1373 27
1841140 1841140 2021-10-22 Carroll New Hampshire 33003 3727 19
1841428 1841428 2021-10-22 Carroll Ohio 39019 3017 65
1841894 1841894 2021-10-22 Carroll Tennessee 47017 5712 102
1842304 1842304 2021-10-22 Carroll Virginia 51035 3884 92
1836226 1836226 2021-10-21 Carroll Arkansas 5015 4284 74
1836520 1836520 2021-10-21 Carroll Georgia 13045 16337 300
1836717 1836717 2021-10-21 Carroll Illinois 17015 2368 39
1836820 1836820 2021-10-21 Carroll Indiana 18015 2613 35
1836918 1836918 2021-10-21 Carroll Iowa 19027 3463 53
1837130 1837130 2021-10-21 Carroll Kentucky 21041 1858 26
1837318 1837318 2021-10-21 Carroll Maryland 24013 11621 287
1837531 1837531 2021-10-21 Carroll Mississippi 28015 1688 38
1837622 1837622 2021-10-21 Carroll Missouri 29033 1373 27
1837891 1837891 2021-10-21 Carroll New Hampshire 33003 3689 19
1838179 1838179 2021-10-21 Carroll Ohio 39019 3006 59
1838645 1838645 2021-10-21 Carroll Tennessee 47017 5704 102
1839055 1839055 2021-10-21 Carroll Virginia 51035 3871 92
1832977 1832977 2021-10-20 Carroll Arkansas 5015 4279 74
1833271 1833271 2021-10-20 Carroll Georgia 13045 16319 300
1833468 1833468 2021-10-20 Carroll Illinois 17015 2364 39
1833571 1833571 2021-10-20 Carroll Indiana 18015 2608 35
1833669 1833669 2021-10-20 Carroll Iowa 19027 3463 53
1833881 1833881 2021-10-20 Carroll Kentucky 21041 1854 26
1834069 1834069 2021-10-20 Carroll Maryland 24013 11602 286
1834282 1834282 2021-10-20 Carroll Mississippi 28015 1687 38
1834373 1834373 2021-10-20 Carroll Missouri 29033 1372 27
1834642 1834642 2021-10-20 Carroll New Hampshire 33003 3651 19
1834930 1834930 2021-10-20 Carroll Ohio 39019 2995 59
1835396 1835396 2021-10-20 Carroll Tennessee 47017 5699 102
1835806 1835806 2021-10-20 Carroll Virginia 51035 3859 91
1829728 1829728 2021-10-19 Carroll Arkansas 5015 4267 73
1830022 1830022 2021-10-19 Carroll Georgia 13045 16311 300
1830219 1830219 2021-10-19 Carroll Illinois 17015 2363 39
1830322 1830322 2021-10-19 Carroll Indiana 18015 2600 34
1830420 1830420 2021-10-19 Carroll Iowa 19027 3420 53
1830632 1830632 2021-10-19 Carroll Kentucky 21041 1841 26
1830820 1830820 2021-10-19 Carroll Maryland 24013 11577 286
1831033 1831033 2021-10-19 Carroll Mississippi 28015 1685 38
1831124 1831124 2021-10-19 Carroll Missouri 29033 1371 27
1831393 1831393 2021-10-19 Carroll New Hampshire 33003 3625 19
1831681 1831681 2021-10-19 Carroll Ohio 39019 2985 59
1832147 1832147 2021-10-19 Carroll Tennessee 47017 5685 100
1832557 1832557 2021-10-19 Carroll Virginia 51035 3842 91
1826479 1826479 2021-10-18 Carroll Arkansas 5015 4257 73
1826773 1826773 2021-10-18 Carroll Georgia 13045 16297 299
1826970 1826970 2021-10-18 Carroll Illinois 17015 2360 39
1827073 1827073 2021-10-18 Carroll Indiana 18015 2593 34
1827171 1827171 2021-10-18 Carroll Iowa 19027 3420 53
1827383 1827383 2021-10-18 Carroll Kentucky 21041 1836 26
1827571 1827571 2021-10-18 Carroll Maryland 24013 11566 287
1827784 1827784 2021-10-18 Carroll Mississippi 28015 1682 38
1827875 1827875 2021-10-18 Carroll Missouri 29033 1368 26
1828144 1828144 2021-10-18 Carroll New Hampshire 33003 3617 19
1828432 1828432 2021-10-18 Carroll Ohio 39019 2970 59
1828898 1828898 2021-10-18 Carroll Tennessee 47017 5674 100
1829308 1829308 2021-10-18 Carroll Virginia 51035 3832 91
1823230 1823230 2021-10-17 Carroll Arkansas 5015 4257 73
1823524 1823524 2021-10-17 Carroll Georgia 13045 16278 296
1823721 1823721 2021-10-17 Carroll Illinois 17015 2356 39
1823824 1823824 2021-10-17 Carroll Indiana 18015 2584 34
1823922 1823922 2021-10-17 Carroll Iowa 19027 3420 53
1824134 1824134 2021-10-17 Carroll Kentucky 21041 1827 26
1824322 1824322 2021-10-17 Carroll Maryland 24013 11553 287
1824535 1824535 2021-10-17 Carroll Mississippi 28015 1674 38
1824626 1824626 2021-10-17 Carroll Missouri 29033 1368 26
1824895 1824895 2021-10-17 Carroll New Hampshire 33003 3544 19
1825183 1825183 2021-10-17 Carroll Ohio 39019 2959 59
1825649 1825649 2021-10-17 Carroll Tennessee 47017 5660 100
1826059 1826059 2021-10-17 Carroll Virginia 51035 3795 90
1819981 1819981 2021-10-16 Carroll Arkansas 5015 4255 73
1820275 1820275 2021-10-16 Carroll Georgia 13045 16278 296
1820472 1820472 2021-10-16 Carroll Illinois 17015 2356 39
1820575 1820575 2021-10-16 Carroll Indiana 18015 2584 34
1820673 1820673 2021-10-16 Carroll Iowa 19027 3420 53
1820885 1820885 2021-10-16 Carroll Kentucky 21041 1827 26
1821073 1821073 2021-10-16 Carroll Maryland 24013 11538 286
1821286 1821286 2021-10-16 Carroll Mississippi 28015 1674 38
1821377 1821377 2021-10-16 Carroll Missouri 29033 1368 26

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