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

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Polk · 6,924 ✖
Link rowid date ▲ county state fips cases deaths
1842774 1842774 2021-10-23 Polk Arkansas 5113 2978 109
1842982 1842982 2021-10-23 Polk Florida 12105 128010 2381
1843112 1843112 2021-10-23 Polk Georgia 13233 8474 151
1843480 1843480 2021-10-23 Polk Iowa 19153 74707 729
1843994 1843994 2021-10-23 Polk Minnesota 27119 5128 79
1844190 1844190 2021-10-23 Polk Missouri 29167 5100 52
1844349 1844349 2021-10-23 Polk Nebraska 31143 759 18
1844587 1844587 2021-10-23 Polk North Carolina 37149 2308 44
1844862 1844862 2021-10-23 Polk Oregon 41053 7373 81
1845205 1845205 2021-10-23 Polk Tennessee 47139 3178 29
1845418 1845418 2021-10-23 Polk Texas 48373 5900 197
1845809 1845809 2021-10-23 Polk Wisconsin 55095 6749 84
1839524 1839524 2021-10-22 Polk Arkansas 5113 2978 109
1839732 1839732 2021-10-22 Polk Florida 12105 128010 2381
1839862 1839862 2021-10-22 Polk Georgia 13233 8474 151
1840230 1840230 2021-10-22 Polk Iowa 19153 74707 729
1840744 1840744 2021-10-22 Polk Minnesota 27119 5128 79
1840940 1840940 2021-10-22 Polk Missouri 29167 5097 52
1841099 1841099 2021-10-22 Polk Nebraska 31143 759 18
1841337 1841337 2021-10-22 Polk North Carolina 37149 2308 44
1841612 1841612 2021-10-22 Polk Oregon 41053 7373 81
1841955 1841955 2021-10-22 Polk Tennessee 47139 3178 29
1842168 1842168 2021-10-22 Polk Texas 48373 5900 197
1842559 1842559 2021-10-22 Polk Wisconsin 55095 6749 84
1836275 1836275 2021-10-21 Polk Arkansas 5113 2978 109
1836483 1836483 2021-10-21 Polk Florida 12105 127470 2381
1836613 1836613 2021-10-21 Polk Georgia 13233 8471 151
1836981 1836981 2021-10-21 Polk Iowa 19153 74707 729
1837495 1837495 2021-10-21 Polk Minnesota 27119 5107 78
1837691 1837691 2021-10-21 Polk Missouri 29167 5097 52
1837850 1837850 2021-10-21 Polk Nebraska 31143 759 18
1838088 1838088 2021-10-21 Polk North Carolina 37149 2305 44
1838363 1838363 2021-10-21 Polk Oregon 41053 7336 81
1838706 1838706 2021-10-21 Polk Tennessee 47139 3171 29
1838919 1838919 2021-10-21 Polk Texas 48373 5900 196
1839310 1839310 2021-10-21 Polk Wisconsin 55095 6722 81
1833026 1833026 2021-10-20 Polk Arkansas 5113 2975 109
1833234 1833234 2021-10-20 Polk Florida 12105 127470 2381
1833364 1833364 2021-10-20 Polk Georgia 13233 8461 149
1833732 1833732 2021-10-20 Polk Iowa 19153 74707 729
1834246 1834246 2021-10-20 Polk Minnesota 27119 5086 77
1834442 1834442 2021-10-20 Polk Missouri 29167 5094 52
1834601 1834601 2021-10-20 Polk Nebraska 31143 758 18
1834839 1834839 2021-10-20 Polk North Carolina 37149 2297 44
1835114 1835114 2021-10-20 Polk Oregon 41053 7299 81
1835457 1835457 2021-10-20 Polk Tennessee 47139 3169 29
1835670 1835670 2021-10-20 Polk Texas 48373 5900 196
1836061 1836061 2021-10-20 Polk Wisconsin 55095 6668 81
1829777 1829777 2021-10-19 Polk Arkansas 5113 2972 109
1829985 1829985 2021-10-19 Polk Florida 12105 127470 2381
1830115 1830115 2021-10-19 Polk Georgia 13233 8451 148
1830483 1830483 2021-10-19 Polk Iowa 19153 73744 716
1830997 1830997 2021-10-19 Polk Minnesota 27119 5063 77
1831193 1831193 2021-10-19 Polk Missouri 29167 5094 52
1831352 1831352 2021-10-19 Polk Nebraska 31143 757 18
1831590 1831590 2021-10-19 Polk North Carolina 37149 2290 44
1831865 1831865 2021-10-19 Polk Oregon 41053 7248 81
1832208 1832208 2021-10-19 Polk Tennessee 47139 3164 29
1832421 1832421 2021-10-19 Polk Texas 48373 5885 196
1832812 1832812 2021-10-19 Polk Wisconsin 55095 6656 81
1826528 1826528 2021-10-18 Polk Arkansas 5113 2970 109
1826736 1826736 2021-10-18 Polk Florida 12105 127470 2381
1826866 1826866 2021-10-18 Polk Georgia 13233 8448 148
1827234 1827234 2021-10-18 Polk Iowa 19153 73744 716
1827748 1827748 2021-10-18 Polk Minnesota 27119 5034 77
1827944 1827944 2021-10-18 Polk Missouri 29167 5088 52
1828103 1828103 2021-10-18 Polk Nebraska 31143 750 18
1828341 1828341 2021-10-18 Polk North Carolina 37149 2285 44
1828616 1828616 2021-10-18 Polk Oregon 41053 7196 80
1828959 1828959 2021-10-18 Polk Tennessee 47139 3164 29
1829172 1829172 2021-10-18 Polk Texas 48373 5885 196
1829563 1829563 2021-10-18 Polk Wisconsin 55095 6646 80
1823279 1823279 2021-10-17 Polk Arkansas 5113 2969 109
1823487 1823487 2021-10-17 Polk Florida 12105 127470 2334
1823617 1823617 2021-10-17 Polk Georgia 13233 8430 146
1823985 1823985 2021-10-17 Polk Iowa 19153 73744 716
1824499 1824499 2021-10-17 Polk Minnesota 27119 5025 77
1824695 1824695 2021-10-17 Polk Missouri 29167 5087 52
1824854 1824854 2021-10-17 Polk Nebraska 31143 748 18
1825092 1825092 2021-10-17 Polk North Carolina 37149 2273 44
1825367 1825367 2021-10-17 Polk Oregon 41053 7153 80
1825710 1825710 2021-10-17 Polk Tennessee 47139 3150 29
1825923 1825923 2021-10-17 Polk Texas 48373 5885 195
1826314 1826314 2021-10-17 Polk Wisconsin 55095 6613 80
1820030 1820030 2021-10-16 Polk Arkansas 5113 2967 108
1820238 1820238 2021-10-16 Polk Florida 12105 127470 2334
1820368 1820368 2021-10-16 Polk Georgia 13233 8430 146
1820736 1820736 2021-10-16 Polk Iowa 19153 73744 716
1821250 1821250 2021-10-16 Polk Minnesota 27119 5025 77
1821446 1821446 2021-10-16 Polk Missouri 29167 5086 52
1821605 1821605 2021-10-16 Polk Nebraska 31143 748 18
1821843 1821843 2021-10-16 Polk North Carolina 37149 2273 44
1822118 1822118 2021-10-16 Polk Oregon 41053 7153 80
1822461 1822461 2021-10-16 Polk Tennessee 47139 3150 29
1822674 1822674 2021-10-16 Polk Texas 48373 5885 193
1823065 1823065 2021-10-16 Polk Wisconsin 55095 6578 79
1816781 1816781 2021-10-15 Polk Arkansas 5113 2961 108
1816989 1816989 2021-10-15 Polk Florida 12105 127470 2334
1817119 1817119 2021-10-15 Polk Georgia 13233 8430 146
1817487 1817487 2021-10-15 Polk Iowa 19153 73744 716

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