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

300 rows where cases = 1749 sorted by date descending

✎ View and edit SQL

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

These facets timed out: county, fips

Link rowid date ▲ county state fips cases deaths
2500200 2500200 2022-05-13 Edwards Illinois 17047 1749 29
2496942 2496942 2022-05-12 Edwards Illinois 17047 1749 29
2376695 2376695 2022-04-05 Lucas Iowa 19117 1749 32
2373443 2373443 2022-04-04 Lucas Iowa 19117 1749 32
2374510 2374510 2022-04-04 Camden North Carolina 37029 1749 9
2370190 2370190 2022-04-03 Lucas Iowa 19117 1749 32
2366937 2366937 2022-04-02 Lucas Iowa 19117 1749 32
2363684 2363684 2022-04-01 Lucas Iowa 19117 1749 32
2360430 2360430 2022-03-31 Lucas Iowa 19117 1749 32
2360893 2360893 2022-03-31 Schoolcraft Michigan 26153 1749 17
2362635 2362635 2022-03-31 Williamsburg city Virginia 51830 1749 22
2357176 2357176 2022-03-30 Lucas Iowa 19117 1749 32
2357639 2357639 2022-03-30 Schoolcraft Michigan 26153 1749 17
2338122 2338122 2022-03-24 Schoolcraft Michigan 26153 1749 17
2334868 2334868 2022-03-23 Schoolcraft Michigan 26153 1749 17
2331614 2331614 2022-03-22 Schoolcraft Michigan 26153 1749 17
2328362 2328362 2022-03-21 Schoolcraft Michigan 26153 1749 17
2325109 2325109 2022-03-20 Schoolcraft Michigan 26153 1749 17
2321855 2321855 2022-03-19 Schoolcraft Michigan 26153 1749 17
2318601 2318601 2022-03-18 Schoolcraft Michigan 26153 1749 17
2308842 2308842 2022-03-15 Schoolcraft Michigan 26153 1749 16
2305591 2305591 2022-03-14 Schoolcraft Michigan 26153 1749 16
2291890 2291890 2022-03-10 Edwards Illinois 17047 1749 28
2268069 2268069 2022-03-02 Refugio Texas 48391 1749 31
2247430 2247430 2022-02-24 Cuming Nebraska 31039 1749 15
2244179 2244179 2022-02-23 Cuming Nebraska 31039 1749 15
2237677 2237677 2022-02-21 Cuming Nebraska 31039 1749 15
2234426 2234426 2022-02-20 Cuming Nebraska 31039 1749 15
2235732 2235732 2022-02-20 Lancaster Virginia 51103 1749 27
2231175 2231175 2022-02-19 Cuming Nebraska 31039 1749 15
2232481 2232481 2022-02-19 Lancaster Virginia 51103 1749 27
2227924 2227924 2022-02-18 Cuming Nebraska 31039 1749 15
2229230 2229230 2022-02-18 Lancaster Virginia 51103 1749 27
2200648 2200648 2022-02-10 Crawford Georgia 13079 1749 50
2197590 2197590 2022-02-09 Edwards Illinois 17047 1749 26
2192099 2192099 2022-02-07 Madison Montana 30057 1749 20
2192945 2192945 2022-02-07 Fall River South Dakota 46047 1749 37
2190045 2190045 2022-02-06 Stephens Texas 48429 1749 39
2179064 2179064 2022-02-03 Blaine Montana 30005 1749 28
2164319 2164319 2022-01-29 Pendleton West Virginia 54071 1749 16
2132908 2132908 2022-01-20 Bracken Kentucky 21023 1749 22
2134644 2134644 2022-01-20 Jim Hogg Texas 48247 1749 20
2123562 2123562 2022-01-17 Claiborne Mississippi 28021 1749 41
2120310 2120310 2022-01-16 Claiborne Mississippi 28021 1749 41
2117058 2117058 2022-01-15 Claiborne Mississippi 28021 1749 41
2113807 2113807 2022-01-14 Claiborne Mississippi 28021 1749 41
2091156 2091156 2022-01-07 Gentry Missouri 29075 1749 28
2084213 2084213 2022-01-05 Owen Kentucky 21187 1749 29
2082953 2082953 2022-01-04 Pend Oreille Washington 53051 1749 26
2073942 2073942 2022-01-02 Fremont Idaho 16043 1749 19
2070691 2070691 2022-01-01 Fremont Idaho 16043 1749 19
2067440 2067440 2021-12-31 Fremont Idaho 16043 1749 19
2064189 2064189 2021-12-30 Fremont Idaho 16043 1749 19
2057686 2057686 2021-12-28 Clearwater Idaho 16035 1749 28
2054437 2054437 2021-12-27 Clearwater Idaho 16035 1749 28
2040410 2040410 2021-12-22 Morris Texas 48343 1749 58
2035339 2035339 2021-12-21 Rice Kansas 20159 1749 16
2036591 2036591 2021-12-21 Woods Oklahoma 40151 1749 30
2032089 2032089 2021-12-20 Rice Kansas 20159 1749 16
2032252 2032252 2021-12-20 East Carroll Louisiana 22035 1749 33
2033341 2033341 2021-12-20 Woods Oklahoma 40151 1749 30
2030091 2030091 2021-12-19 Woods Oklahoma 40151 1749 30
2026840 2026840 2021-12-18 Woods Oklahoma 40151 1749 30
2023589 2023589 2021-12-17 Woods Oklahoma 40151 1749 30
2020338 2020338 2021-12-16 Woods Oklahoma 40151 1749 30
2017087 2017087 2021-12-15 Woods Oklahoma 40151 1749 30
1989450 1989450 2021-12-07 Teton Idaho 16081 1749 7
1983631 1983631 2021-12-05 Iron Michigan 26071 1749 68
1983675 1983675 2021-12-05 Unknown Michigan   1749 18
1984819 1984819 2021-12-05 Bon Homme South Dakota 46009 1749 30
1985177 1985177 2021-12-05 Runnels Texas 48399 1749 55
1980381 1980381 2021-12-04 Iron Michigan 26071 1749 68
1981569 1981569 2021-12-04 Bon Homme South Dakota 46009 1749 30
1981927 1981927 2021-12-04 Runnels Texas 48399 1749 55
1977131 1977131 2021-12-03 Iron Michigan 26071 1749 68
1978319 1978319 2021-12-03 Bon Homme South Dakota 46009 1749 30
1967526 1967526 2021-11-30 Carroll Mississippi 28015 1749 41
1965515 1965515 2021-11-29 Childress Texas 48075 1749 21
1956514 1956514 2021-11-27 Pike Arkansas 5109 1749 37
1944160 1944160 2021-11-23 Chickasaw Iowa 19037 1749 21
1940910 1940910 2021-11-22 Chickasaw Iowa 19037 1749 21
1937018 1937018 2021-11-21 Scott Arkansas 5127 1749 30
1937143 1937143 2021-11-21 Rio Grande Colorado 8105 1749 26
1937660 1937660 2021-11-21 Chickasaw Iowa 19037 1749 21
1933893 1933893 2021-11-20 Rio Grande Colorado 8105 1749 26
1934410 1934410 2021-11-20 Chickasaw Iowa 19037 1749 21
1930641 1930641 2021-11-19 Rio Grande Colorado 8105 1749 26
1931159 1931159 2021-11-19 Chickasaw Iowa 19037 1749 21
1927341 1927341 2021-11-18 Archuleta Colorado 8007 1749 6
1927908 1927908 2021-11-18 Chickasaw Iowa 19037 1749 21
1924658 1924658 2021-11-17 Chickasaw Iowa 19037 1749 21
1919235 1919235 2021-11-15 Schuyler New York 36097 1749 19
1896151 1896151 2021-11-08 Lewis Missouri 29111 1749 22
1892901 1892901 2021-11-07 Lewis Missouri 29111 1749 22
1893820 1893820 2021-11-07 Charles Mix South Dakota 46023 1749 27
1890570 1890570 2021-11-06 Charles Mix South Dakota 46023 1749 27
1887320 1887320 2021-11-05 Charles Mix South Dakota 46023 1749 27
1881892 1881892 2021-11-04 Prowers Colorado 8099 1749 30
1880773 1880773 2021-11-03 Calhoun South Carolina 45017 1749 52
1870635 1870635 2021-10-31 Mercer North Dakota 38057 1749 15

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