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

6,321 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 · 6,321 ✖
Link rowid date ▲ county state fips cases deaths
1842734 1842734 2021-10-23 Crawford Arkansas 5033 10676 172
1843036 1843036 2021-10-23 Crawford Georgia 13079 1130 42
1843225 1843225 2021-10-23 Crawford Illinois 17033 3337 46
1843324 1843324 2021-10-23 Crawford Indiana 18025 1600 24
1843427 1843427 2021-10-23 Crawford Iowa 19047 3393 47
1843522 1843522 2021-10-23 Crawford Kansas 20037 6694 111
1843870 1843870 2021-10-23 Crawford Michigan 26039 1323 16
1844132 1844132 2021-10-23 Crawford Missouri 29055 3602 57
1844685 1844685 2021-10-23 Crawford Ohio 39033 6274 130
1844891 1844891 2021-10-23 Crawford Pennsylvania 42039 10736 187
1845772 1845772 2021-10-23 Crawford Wisconsin 55023 2285 22
1839484 1839484 2021-10-22 Crawford Arkansas 5033 10669 172
1839786 1839786 2021-10-22 Crawford Georgia 13079 1130 42
1839975 1839975 2021-10-22 Crawford Illinois 17033 3337 46
1840074 1840074 2021-10-22 Crawford Indiana 18025 1600 24
1840177 1840177 2021-10-22 Crawford Iowa 19047 3393 47
1840272 1840272 2021-10-22 Crawford Kansas 20037 6694 111
1840620 1840620 2021-10-22 Crawford Michigan 26039 1323 16
1840882 1840882 2021-10-22 Crawford Missouri 29055 3596 57
1841435 1841435 2021-10-22 Crawford Ohio 39033 6261 130
1841641 1841641 2021-10-22 Crawford Pennsylvania 42039 10677 186
1842522 1842522 2021-10-22 Crawford Wisconsin 55023 2285 22
1836235 1836235 2021-10-21 Crawford Arkansas 5033 10650 172
1836537 1836537 2021-10-21 Crawford Georgia 13079 1130 41
1836726 1836726 2021-10-21 Crawford Illinois 17033 3332 46
1836825 1836825 2021-10-21 Crawford Indiana 18025 1594 24
1836928 1836928 2021-10-21 Crawford Iowa 19047 3393 47
1837023 1837023 2021-10-21 Crawford Kansas 20037 6676 111
1837371 1837371 2021-10-21 Crawford Michigan 26039 1299 16
1837633 1837633 2021-10-21 Crawford Missouri 29055 3587 57
1838186 1838186 2021-10-21 Crawford Ohio 39033 6245 130
1838392 1838392 2021-10-21 Crawford Pennsylvania 42039 10646 184
1839273 1839273 2021-10-21 Crawford Wisconsin 55023 2276 22
1832986 1832986 2021-10-20 Crawford Arkansas 5033 10639 172
1833288 1833288 2021-10-20 Crawford Georgia 13079 1130 41
1833477 1833477 2021-10-20 Crawford Illinois 17033 3324 46
1833576 1833576 2021-10-20 Crawford Indiana 18025 1592 24
1833679 1833679 2021-10-20 Crawford Iowa 19047 3393 47
1833774 1833774 2021-10-20 Crawford Kansas 20037 6676 111
1834122 1834122 2021-10-20 Crawford Michigan 26039 1299 16
1834384 1834384 2021-10-20 Crawford Missouri 29055 3584 57
1834937 1834937 2021-10-20 Crawford Ohio 39033 6227 130
1835143 1835143 2021-10-20 Crawford Pennsylvania 42039 10599 184
1836024 1836024 2021-10-20 Crawford Wisconsin 55023 2269 22
1829737 1829737 2021-10-19 Crawford Arkansas 5033 10626 172
1830039 1830039 2021-10-19 Crawford Georgia 13079 1125 41
1830228 1830228 2021-10-19 Crawford Illinois 17033 3319 46
1830327 1830327 2021-10-19 Crawford Indiana 18025 1590 24
1830430 1830430 2021-10-19 Crawford Iowa 19047 3374 45
1830525 1830525 2021-10-19 Crawford Kansas 20037 6668 110
1830873 1830873 2021-10-19 Crawford Michigan 26039 1261 16
1831135 1831135 2021-10-19 Crawford Missouri 29055 3577 57
1831688 1831688 2021-10-19 Crawford Ohio 39033 6201 130
1831894 1831894 2021-10-19 Crawford Pennsylvania 42039 10538 183
1832775 1832775 2021-10-19 Crawford Wisconsin 55023 2259 22
1826488 1826488 2021-10-18 Crawford Arkansas 5033 10608 172
1826790 1826790 2021-10-18 Crawford Georgia 13079 1123 41
1826979 1826979 2021-10-18 Crawford Illinois 17033 3313 46
1827078 1827078 2021-10-18 Crawford Indiana 18025 1588 24
1827181 1827181 2021-10-18 Crawford Iowa 19047 3374 45
1827276 1827276 2021-10-18 Crawford Kansas 20037 6668 113
1827624 1827624 2021-10-18 Crawford Michigan 26039 1261 16
1827886 1827886 2021-10-18 Crawford Missouri 29055 3577 56
1828439 1828439 2021-10-18 Crawford Ohio 39033 6184 130
1828645 1828645 2021-10-18 Crawford Pennsylvania 42039 10480 182
1829526 1829526 2021-10-18 Crawford Wisconsin 55023 2253 22
1823239 1823239 2021-10-17 Crawford Arkansas 5033 10602 172
1823541 1823541 2021-10-17 Crawford Georgia 13079 1121 41
1823730 1823730 2021-10-17 Crawford Illinois 17033 3308 46
1823829 1823829 2021-10-17 Crawford Indiana 18025 1583 23
1823932 1823932 2021-10-17 Crawford Iowa 19047 3374 45
1824027 1824027 2021-10-17 Crawford Kansas 20037 6656 113
1824375 1824375 2021-10-17 Crawford Michigan 26039 1242 16
1824637 1824637 2021-10-17 Crawford Missouri 29055 3575 56
1825190 1825190 2021-10-17 Crawford Ohio 39033 6169 130
1825396 1825396 2021-10-17 Crawford Pennsylvania 42039 10467 181
1826277 1826277 2021-10-17 Crawford Wisconsin 55023 2245 22
1819990 1819990 2021-10-16 Crawford Arkansas 5033 10592 171
1820292 1820292 2021-10-16 Crawford Georgia 13079 1121 41
1820481 1820481 2021-10-16 Crawford Illinois 17033 3308 46
1820580 1820580 2021-10-16 Crawford Indiana 18025 1583 23
1820683 1820683 2021-10-16 Crawford Iowa 19047 3374 45
1820778 1820778 2021-10-16 Crawford Kansas 20037 6656 113
1821126 1821126 2021-10-16 Crawford Michigan 26039 1242 16
1821388 1821388 2021-10-16 Crawford Missouri 29055 3572 56
1821941 1821941 2021-10-16 Crawford Ohio 39033 6159 130
1822147 1822147 2021-10-16 Crawford Pennsylvania 42039 10437 181
1823028 1823028 2021-10-16 Crawford Wisconsin 55023 2228 22
1816741 1816741 2021-10-15 Crawford Arkansas 5033 10584 171
1817043 1817043 2021-10-15 Crawford Georgia 13079 1121 41
1817232 1817232 2021-10-15 Crawford Illinois 17033 3308 46
1817331 1817331 2021-10-15 Crawford Indiana 18025 1583 23
1817434 1817434 2021-10-15 Crawford Iowa 19047 3374 45
1817529 1817529 2021-10-15 Crawford Kansas 20037 6656 113
1817877 1817877 2021-10-15 Crawford Michigan 26039 1242 16
1818139 1818139 2021-10-15 Crawford Missouri 29055 3567 56
1818692 1818692 2021-10-15 Crawford Ohio 39033 6147 130
1818898 1818898 2021-10-15 Crawford Pennsylvania 42039 10330 181
1819779 1819779 2021-10-15 Crawford Wisconsin 55023 2228 22
1813493 1813493 2021-10-14 Crawford Arkansas 5033 10577 171

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