ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
476 rows where cases = 927 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 39
- Virginia 33
- Iowa 28
- Michigan 27
- Texas 26
- Arkansas 22
- Missouri 21
- Minnesota 19
- Nebraska 19
- Kansas 17
- Alabama 16
- Puerto Rico 16
- Indiana 14
- Mississippi 14
- Idaho 12
- West Virginia 12
- Colorado 11
- Kentucky 11
- Ohio 10
- North Carolina 9
- Utah 9
- Illinois 8
- Louisiana 8
- North Dakota 8
- South Dakota 8
- Alaska 7
- Wisconsin 7
- Washington 5
- Arizona 4
- Oregon 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467560 | 2467560 | 2022-05-03 | Bear Lake | Idaho | 16007 | 927 | 16 |
2464305 | 2464305 | 2022-05-02 | Bear Lake | Idaho | 16007 | 927 | 16 |
2461049 | 2461049 | 2022-05-01 | Bear Lake | Idaho | 16007 | 927 | 16 |
2457793 | 2457793 | 2022-04-30 | Bear Lake | Idaho | 16007 | 927 | 16 |
2454537 | 2454537 | 2022-04-29 | Bear Lake | Idaho | 16007 | 927 | 16 |
2451281 | 2451281 | 2022-04-28 | Bear Lake | Idaho | 16007 | 927 | 16 |
2448025 | 2448025 | 2022-04-27 | Bear Lake | Idaho | 16007 | 927 | 16 |
2440590 | 2440590 | 2022-04-24 | Garfield | Utah | 49017 | 927 | 16 |
2437334 | 2437334 | 2022-04-23 | Garfield | Utah | 49017 | 927 | 16 |
2434078 | 2434078 | 2022-04-22 | Garfield | Utah | 49017 | 927 | 16 |
2430822 | 2430822 | 2022-04-21 | Garfield | Utah | 49017 | 927 | 16 |
2395932 | 2395932 | 2022-04-11 | Bear Lake | Idaho | 16007 | 927 | 15 |
2336584 | 2336584 | 2022-03-23 | Rappahannock | Virginia | 51157 | 927 | 9 |
2289403 | 2289403 | 2022-03-09 | Red Lake | Minnesota | 27125 | 927 | 13 |
2286152 | 2286152 | 2022-03-08 | Red Lake | Minnesota | 27125 | 927 | 13 |
2281779 | 2281779 | 2022-03-07 | Gilpin | Colorado | 8047 | 927 | 4 |
2278526 | 2278526 | 2022-03-06 | Gilpin | Colorado | 8047 | 927 | 4 |
2279647 | 2279647 | 2022-03-06 | Red Lake | Minnesota | 27125 | 927 | 13 |
2275273 | 2275273 | 2022-03-05 | Gilpin | Colorado | 8047 | 927 | 4 |
2276394 | 2276394 | 2022-03-05 | Red Lake | Minnesota | 27125 | 927 | 13 |
2272020 | 2272020 | 2022-03-04 | Gilpin | Colorado | 8047 | 927 | 4 |
2273141 | 2273141 | 2022-03-04 | Red Lake | Minnesota | 27125 | 927 | 13 |
2269889 | 2269889 | 2022-03-03 | Red Lake | Minnesota | 27125 | 927 | 13 |
2271421 | 2271421 | 2022-03-03 | Unknown | Vermont | 927 | 2 | |
2233176 | 2233176 | 2022-02-20 | Echols | Georgia | 13101 | 927 | 11 |
2229925 | 2229925 | 2022-02-19 | Echols | Georgia | 13101 | 927 | 11 |
2226674 | 2226674 | 2022-02-18 | Echols | Georgia | 13101 | 927 | 11 |
2223423 | 2223423 | 2022-02-17 | Echols | Georgia | 13101 | 927 | 11 |
2200430 | 2200430 | 2022-02-10 | Modoc | California | 6049 | 927 | 6 |
2198587 | 2198587 | 2022-02-09 | Chouteau | Montana | 30015 | 927 | 14 |
2195189 | 2195189 | 2022-02-08 | Sharkey | Mississippi | 28125 | 927 | 22 |
2191134 | 2191134 | 2022-02-07 | Pope | Illinois | 17151 | 927 | 7 |
2170381 | 2170381 | 2022-01-31 | Donley | Texas | 48129 | 927 | 20 |
2149810 | 2149810 | 2022-01-25 | Mineral | Montana | 30061 | 927 | 15 |
2150211 | 2150211 | 2022-01-25 | Sargent | North Dakota | 38081 | 927 | 9 |
2137524 | 2137524 | 2022-01-21 | Las Marias | Puerto Rico | 72083 | 927 | |
2133913 | 2133913 | 2022-01-20 | Dunn | North Dakota | 38025 | 927 | 8 |
2130701 | 2130701 | 2022-01-19 | Wells | North Dakota | 38103 | 927 | 11 |
2128217 | 2128217 | 2022-01-18 | San Augustine | Texas | 48405 | 927 | 38 |
2121558 | 2121558 | 2022-01-16 | Concho | Texas | 48095 | 927 | 10 |
2109222 | 2109222 | 2022-01-13 | Yukon-Koyukuk Census Area | Alaska | 2290 | 927 | 8 |
2105971 | 2105971 | 2022-01-12 | Yukon-Koyukuk Census Area | Alaska | 2290 | 927 | 8 |
2101118 | 2101118 | 2022-01-10 | Polk | Nebraska | 31143 | 927 | 18 |
2098078 | 2098078 | 2022-01-09 | Hyde | North Carolina | 37095 | 927 | 13 |
2094826 | 2094826 | 2022-01-08 | Hyde | North Carolina | 37095 | 927 | 13 |
2091574 | 2091574 | 2022-01-07 | Hyde | North Carolina | 37095 | 927 | 13 |
2088720 | 2088720 | 2022-01-06 | Ceiba | Puerto Rico | 72037 | 927 | |
2040427 | 2040427 | 2021-12-22 | Presidio | Texas | 48377 | 927 | 28 |
2037177 | 2037177 | 2021-12-21 | Presidio | Texas | 48377 | 927 | 28 |
1964569 | 1964569 | 2021-11-29 | Jefferson | Nebraska | 31095 | 927 | 3 |
1944320 | 1944320 | 2021-11-23 | Republic | Kansas | 20157 | 927 | 14 |
1944678 | 1944678 | 2021-11-23 | Big Stone | Minnesota | 27011 | 927 | 5 |
1941070 | 1941070 | 2021-11-22 | Republic | Kansas | 20157 | 927 | 14 |
1937432 | 1937432 | 2021-11-21 | Lemhi | Idaho | 16059 | 927 | 20 |
1934182 | 1934182 | 2021-11-20 | Lemhi | Idaho | 16059 | 927 | 20 |
1927104 | 1927104 | 2021-11-18 | Choctaw | Alabama | 1023 | 927 | 28 |
1923916 | 1923916 | 2021-11-17 | Dillingham Census Area | Alaska | 2070 | 927 | 7 |
1904276 | 1904276 | 2021-11-10 | Iron | Wisconsin | 55051 | 927 | 42 |
1897103 | 1897103 | 2021-11-08 | McCook | South Dakota | 46087 | 927 | 25 |
1882592 | 1882592 | 2021-11-04 | Wabaunsee | Kansas | 20197 | 927 | 18 |
1879343 | 1879343 | 2021-11-03 | Wabaunsee | Kansas | 20197 | 927 | 18 |
1876034 | 1876034 | 2021-11-02 | Harper | Kansas | 20077 | 927 | 22 |
1877141 | 1877141 | 2021-11-02 | Ransom | North Dakota | 38073 | 927 | 20 |
1872785 | 1872785 | 2021-11-01 | Harper | Kansas | 20077 | 927 | 22 |
1873231 | 1873231 | 2021-11-01 | Norman | Minnesota | 27107 | 927 | 9 |
1864895 | 1864895 | 2021-10-29 | Mitchell | Texas | 48335 | 927 | 39 |
1861646 | 1861646 | 2021-10-28 | Mitchell | Texas | 48335 | 927 | 39 |
1858397 | 1858397 | 2021-10-27 | Mitchell | Texas | 48335 | 927 | 39 |
1858710 | 1858710 | 2021-10-27 | Calhoun | West Virginia | 54013 | 927 | 4 |
1845924 | 1845924 | 2021-10-24 | Aleutians West Census Area | Alaska | 2016 | 927 | 0 |
1842674 | 1842674 | 2021-10-23 | Aleutians West Census Area | Alaska | 2016 | 927 | 0 |
1845391 | 1845391 | 2021-10-23 | McCulloch | Texas | 48307 | 927 | 36 |
1839425 | 1839425 | 2021-10-22 | Aleutians West Census Area | Alaska | 2016 | 927 | 0 |
1840953 | 1840953 | 2021-10-22 | Shelby | Missouri | 29205 | 927 | 9 |
1836176 | 1836176 | 2021-10-21 | Aleutians West Census Area | Alaska | 2016 | 927 | 0 |
1826658 | 1826658 | 2021-10-18 | Rio Blanco | Colorado | 8103 | 927 | 8 |
1816372 | 1816372 | 2021-10-14 | Middlesex | Virginia | 51119 | 927 | 27 |
1810061 | 1810061 | 2021-10-12 | Menominee | Wisconsin | 55078 | 927 | 11 |
1791985 | 1791985 | 2021-10-07 | Lac qui Parle | Minnesota | 27073 | 927 | 24 |
1786364 | 1786364 | 2021-10-05 | Grant | Oregon | 41023 | 927 | 10 |
1786950 | 1786950 | 2021-10-05 | Sabine | Texas | 48403 | 927 | 67 |
1779356 | 1779356 | 2021-10-03 | Merrick | Nebraska | 31121 | 927 | 15 |
1776106 | 1776106 | 2021-10-02 | Merrick | Nebraska | 31121 | 927 | 15 |
1772856 | 1772856 | 2021-10-01 | Merrick | Nebraska | 31121 | 927 | 15 |
1769668 | 1769668 | 2021-09-30 | Unknown | New Hampshire | 927 | 1 | |
1758231 | 1758231 | 2021-09-27 | Greenlee | Arizona | 4011 | 927 | 15 |
1757956 | 1757956 | 2021-09-26 | Jefferson | Washington | 53031 | 927 | 12 |
1754708 | 1754708 | 2021-09-25 | Jefferson | Washington | 53031 | 927 | 12 |
1751460 | 1751460 | 2021-09-24 | Jefferson | Washington | 53031 | 927 | 12 |
1745679 | 1745679 | 2021-09-23 | Wheeler | Georgia | 13309 | 927 | 32 |
1746068 | 1746068 | 2021-09-23 | Greenwood | Kansas | 20073 | 927 | 11 |
1742430 | 1742430 | 2021-09-22 | Wheeler | Georgia | 13309 | 927 | 32 |
1742819 | 1742819 | 2021-09-22 | Greenwood | Kansas | 20073 | 927 | 11 |
1739181 | 1739181 | 2021-09-21 | Wheeler | Georgia | 13309 | 927 | 32 |
1728775 | 1728775 | 2021-09-17 | Pocahontas | West Virginia | 54075 | 927 | 15 |
1724331 | 1724331 | 2021-09-16 | Gates | North Carolina | 37073 | 927 | 14 |
1725067 | 1725067 | 2021-09-16 | Crosby | Texas | 48107 | 927 | 32 |
1718411 | 1718411 | 2021-09-14 | Spink | South Dakota | 46115 | 927 | 26 |
1715643 | 1715643 | 2021-09-13 | Lunenburg | Virginia | 51111 | 927 | 18 |
1700339 | 1700339 | 2021-09-09 | Schuyler | Illinois | 17169 | 927 | 19 |
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);