ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,534 rows where cases = 107 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 198
- Nebraska 69
- Puerto Rico 61
- Virginia 61
- Georgia 54
- Iowa 54
- Oklahoma 48
- Kentucky 47
- Idaho 46
- Mississippi 41
- Illinois 40
- Kansas 40
- Missouri 40
- Arkansas 39
- Colorado 39
- Indiana 35
- New Mexico 35
- North Carolina 35
- Utah 35
- South Dakota 34
- Minnesota 33
- New York 33
- Pennsylvania 32
- Ohio 31
- Montana 29
- Wisconsin 28
- Tennessee 26
- Washington 26
- Michigan 24
- North Dakota 21
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491574 | 2491574 | 2022-05-10 | Esmeralda | Nevada | 32009 | 107 | 3 |
2488316 | 2488316 | 2022-05-09 | Esmeralda | Nevada | 32009 | 107 | 3 |
2485059 | 2485059 | 2022-05-08 | Esmeralda | Nevada | 32009 | 107 | 3 |
2481801 | 2481801 | 2022-05-07 | Esmeralda | Nevada | 32009 | 107 | 3 |
2478543 | 2478543 | 2022-05-06 | Esmeralda | Nevada | 32009 | 107 | 3 |
2475285 | 2475285 | 2022-05-05 | Esmeralda | Nevada | 32009 | 107 | 3 |
2472028 | 2472028 | 2022-05-04 | Esmeralda | Nevada | 32009 | 107 | 3 |
2381153 | 2381153 | 2022-04-06 | Unknown | North Dakota | 107 | 47 | |
2318992 | 2318992 | 2022-03-18 | Grant | Nebraska | 31075 | 107 | 5 |
2315739 | 2315739 | 2022-03-17 | Grant | Nebraska | 31075 | 107 | 5 |
2312486 | 2312486 | 2022-03-16 | Grant | Nebraska | 31075 | 107 | 5 |
2309233 | 2309233 | 2022-03-15 | Grant | Nebraska | 31075 | 107 | 5 |
2305981 | 2305981 | 2022-03-14 | Grant | Nebraska | 31075 | 107 | 5 |
2302730 | 2302730 | 2022-03-13 | Grant | Nebraska | 31075 | 107 | 5 |
2299478 | 2299478 | 2022-03-12 | Grant | Nebraska | 31075 | 107 | 5 |
2296226 | 2296226 | 2022-03-11 | Grant | Nebraska | 31075 | 107 | 5 |
2292974 | 2292974 | 2022-03-10 | Grant | Nebraska | 31075 | 107 | 5 |
2289722 | 2289722 | 2022-03-09 | Grant | Nebraska | 31075 | 107 | 5 |
2286470 | 2286470 | 2022-03-08 | Grant | Nebraska | 31075 | 107 | 5 |
2283218 | 2283218 | 2022-03-07 | Grant | Nebraska | 31075 | 107 | 5 |
2279965 | 2279965 | 2022-03-06 | Grant | Nebraska | 31075 | 107 | 5 |
2276712 | 2276712 | 2022-03-05 | Grant | Nebraska | 31075 | 107 | 5 |
2273459 | 2273459 | 2022-03-04 | Grant | Nebraska | 31075 | 107 | 5 |
2270207 | 2270207 | 2022-03-03 | Grant | Nebraska | 31075 | 107 | 5 |
2266954 | 2266954 | 2022-03-02 | Grant | Nebraska | 31075 | 107 | 5 |
2263703 | 2263703 | 2022-03-01 | Grant | Nebraska | 31075 | 107 | 5 |
2260452 | 2260452 | 2022-02-28 | Grant | Nebraska | 31075 | 107 | 5 |
2236561 | 2236561 | 2022-02-21 | Clark | Idaho | 16033 | 107 | 0 |
2233310 | 2233310 | 2022-02-20 | Clark | Idaho | 16033 | 107 | 0 |
2230059 | 2230059 | 2022-02-19 | Clark | Idaho | 16033 | 107 | 0 |
2226808 | 2226808 | 2022-02-18 | Clark | Idaho | 16033 | 107 | 0 |
2223557 | 2223557 | 2022-02-17 | Clark | Idaho | 16033 | 107 | 0 |
2220306 | 2220306 | 2022-02-16 | Clark | Idaho | 16033 | 107 | 0 |
2217055 | 2217055 | 2022-02-15 | Clark | Idaho | 16033 | 107 | 0 |
2213804 | 2213804 | 2022-02-14 | Clark | Idaho | 16033 | 107 | 0 |
2210552 | 2210552 | 2022-02-13 | Clark | Idaho | 16033 | 107 | 0 |
2207299 | 2207299 | 2022-02-12 | Clark | Idaho | 16033 | 107 | 0 |
2204046 | 2204046 | 2022-02-11 | Clark | Idaho | 16033 | 107 | 0 |
2200793 | 2200793 | 2022-02-10 | Clark | Idaho | 16033 | 107 | 0 |
2197539 | 2197539 | 2022-02-09 | Clark | Idaho | 16033 | 107 | 0 |
2194285 | 2194285 | 2022-02-08 | Clark | Idaho | 16033 | 107 | 0 |
2166150 | 2166150 | 2022-01-30 | Hooker | Nebraska | 31091 | 107 | 3 |
2166156 | 2166156 | 2022-01-30 | Keya Paha | Nebraska | 31103 | 107 | 0 |
2162895 | 2162895 | 2022-01-29 | Hooker | Nebraska | 31091 | 107 | 3 |
2162901 | 2162901 | 2022-01-29 | Keya Paha | Nebraska | 31103 | 107 | 0 |
2159640 | 2159640 | 2022-01-28 | Hooker | Nebraska | 31091 | 107 | 3 |
2159646 | 2159646 | 2022-01-28 | Keya Paha | Nebraska | 31103 | 107 | 0 |
1974329 | 1974329 | 2021-12-02 | Logan | Nebraska | 31113 | 107 | 0 |
1975449 | 1975449 | 2021-12-02 | Terrell | Texas | 48443 | 107 | 3 |
1971080 | 1971080 | 2021-12-01 | Logan | Nebraska | 31113 | 107 | 0 |
1972200 | 1972200 | 2021-12-01 | Terrell | Texas | 48443 | 107 | 3 |
1967830 | 1967830 | 2021-11-30 | Logan | Nebraska | 31113 | 107 | 0 |
1968950 | 1968950 | 2021-11-30 | Terrell | Texas | 48443 | 107 | 3 |
1964578 | 1964578 | 2021-11-29 | Logan | Nebraska | 31113 | 107 | 0 |
1965699 | 1965699 | 2021-11-29 | Terrell | Texas | 48443 | 107 | 3 |
1962447 | 1962447 | 2021-11-28 | Terrell | Texas | 48443 | 107 | 3 |
1959196 | 1959196 | 2021-11-27 | Terrell | Texas | 48443 | 107 | 3 |
1955945 | 1955945 | 2021-11-26 | Terrell | Texas | 48443 | 107 | 3 |
1952694 | 1952694 | 2021-11-25 | Terrell | Texas | 48443 | 107 | 3 |
1949443 | 1949443 | 2021-11-24 | Terrell | Texas | 48443 | 107 | 3 |
1946192 | 1946192 | 2021-11-23 | Terrell | Texas | 48443 | 107 | 3 |
1942941 | 1942941 | 2021-11-22 | Terrell | Texas | 48443 | 107 | 3 |
1939691 | 1939691 | 2021-11-21 | Terrell | Texas | 48443 | 107 | 3 |
1936441 | 1936441 | 2021-11-20 | Terrell | Texas | 48443 | 107 | 3 |
1933191 | 1933191 | 2021-11-19 | Terrell | Texas | 48443 | 107 | 3 |
1929940 | 1929940 | 2021-11-18 | Terrell | Texas | 48443 | 107 | 3 |
1924413 | 1924413 | 2021-11-17 | Camas | Idaho | 16025 | 107 | 1 |
1926690 | 1926690 | 2021-11-17 | Terrell | Texas | 48443 | 107 | 3 |
1921164 | 1921164 | 2021-11-16 | Camas | Idaho | 16025 | 107 | 1 |
1923440 | 1923440 | 2021-11-16 | Terrell | Texas | 48443 | 107 | 3 |
1917914 | 1917914 | 2021-11-15 | Camas | Idaho | 16025 | 107 | 1 |
1920191 | 1920191 | 2021-11-15 | Terrell | Texas | 48443 | 107 | 3 |
1914664 | 1914664 | 2021-11-14 | Camas | Idaho | 16025 | 107 | 1 |
1916941 | 1916941 | 2021-11-14 | Terrell | Texas | 48443 | 107 | 3 |
1911414 | 1911414 | 2021-11-13 | Camas | Idaho | 16025 | 107 | 1 |
1913691 | 1913691 | 2021-11-13 | Terrell | Texas | 48443 | 107 | 3 |
1908165 | 1908165 | 2021-11-12 | Camas | Idaho | 16025 | 107 | 1 |
1910441 | 1910441 | 2021-11-12 | Terrell | Texas | 48443 | 107 | 3 |
1904916 | 1904916 | 2021-11-11 | Camas | Idaho | 16025 | 107 | 1 |
1907192 | 1907192 | 2021-11-11 | Terrell | Texas | 48443 | 107 | 3 |
1907229 | 1907229 | 2021-11-11 | Daggett | Utah | 49009 | 107 | 0 |
1901666 | 1901666 | 2021-11-10 | Camas | Idaho | 16025 | 107 | 1 |
1903943 | 1903943 | 2021-11-10 | Terrell | Texas | 48443 | 107 | 3 |
1903980 | 1903980 | 2021-11-10 | Daggett | Utah | 49009 | 107 | 0 |
1898416 | 1898416 | 2021-11-09 | Camas | Idaho | 16025 | 107 | 1 |
1900693 | 1900693 | 2021-11-09 | Terrell | Texas | 48443 | 107 | 3 |
1900730 | 1900730 | 2021-11-09 | Daggett | Utah | 49009 | 107 | 0 |
1895166 | 1895166 | 2021-11-08 | Camas | Idaho | 16025 | 107 | 1 |
1897443 | 1897443 | 2021-11-08 | Terrell | Texas | 48443 | 107 | 3 |
1897480 | 1897480 | 2021-11-08 | Daggett | Utah | 49009 | 107 | 0 |
1891916 | 1891916 | 2021-11-07 | Camas | Idaho | 16025 | 107 | 1 |
1894193 | 1894193 | 2021-11-07 | Terrell | Texas | 48443 | 107 | 3 |
1894230 | 1894230 | 2021-11-07 | Daggett | Utah | 49009 | 107 | 0 |
1888666 | 1888666 | 2021-11-06 | Camas | Idaho | 16025 | 107 | 1 |
1890943 | 1890943 | 2021-11-06 | Terrell | Texas | 48443 | 107 | 3 |
1890980 | 1890980 | 2021-11-06 | Daggett | Utah | 49009 | 107 | 0 |
1885416 | 1885416 | 2021-11-05 | Camas | Idaho | 16025 | 107 | 1 |
1887693 | 1887693 | 2021-11-05 | Terrell | Texas | 48443 | 107 | 3 |
1887730 | 1887730 | 2021-11-05 | Daggett | Utah | 49009 | 107 | 0 |
1882167 | 1882167 | 2021-11-04 | Camas | Idaho | 16025 | 107 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
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);