ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
330 rows where cases = 1485 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 29
- North Dakota 22
- Virginia 21
- California 15
- Missouri 15
- Puerto Rico 15
- Alabama 14
- Kentucky 11
- Colorado 10
- Minnesota 10
- Nebraska 10
- Oklahoma 10
- Idaho 9
- Tennessee 9
- Wisconsin 9
- Arkansas 8
- Illinois 8
- Iowa 8
- Texas 8
- Montana 7
- North Carolina 7
- Florida 6
- Kansas 6
- Michigan 6
- Ohio 6
- Indiana 5
- Louisiana 5
- South Carolina 5
- Wyoming 5
- New York 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499814 | 2499814 | 2022-05-13 | Trinity | California | 6105 | 1485 | 20 |
2501262 | 2501262 | 2022-05-13 | Cedar | Nebraska | 31027 | 1485 | 14 |
2496556 | 2496556 | 2022-05-12 | Trinity | California | 6105 | 1485 | 20 |
2498004 | 2498004 | 2022-05-12 | Cedar | Nebraska | 31027 | 1485 | 14 |
2493298 | 2493298 | 2022-05-11 | Trinity | California | 6105 | 1485 | 20 |
2494746 | 2494746 | 2022-05-11 | Cedar | Nebraska | 31027 | 1485 | 14 |
2490040 | 2490040 | 2022-05-10 | Trinity | California | 6105 | 1485 | 20 |
2459619 | 2459619 | 2022-04-30 | Maunabo | Puerto Rico | 72095 | 1485 | |
2421926 | 2421926 | 2022-04-19 | Randolph | Georgia | 13243 | 1485 | 48 |
2418670 | 2418670 | 2022-04-18 | Randolph | Georgia | 13243 | 1485 | 48 |
2415414 | 2415414 | 2022-04-17 | Randolph | Georgia | 13243 | 1485 | 48 |
2412158 | 2412158 | 2022-04-16 | Randolph | Georgia | 13243 | 1485 | 48 |
2408902 | 2408902 | 2022-04-15 | Randolph | Georgia | 13243 | 1485 | 48 |
2405646 | 2405646 | 2022-04-14 | Randolph | Georgia | 13243 | 1485 | 48 |
2407157 | 2407157 | 2022-04-14 | Dickey | North Dakota | 38021 | 1485 | 39 |
2402391 | 2402391 | 2022-04-13 | Randolph | Georgia | 13243 | 1485 | 48 |
2403901 | 2403901 | 2022-04-13 | Dickey | North Dakota | 38021 | 1485 | 39 |
2399136 | 2399136 | 2022-04-12 | Randolph | Georgia | 13243 | 1485 | 48 |
2400646 | 2400646 | 2022-04-12 | Dickey | North Dakota | 38021 | 1485 | 39 |
2397391 | 2397391 | 2022-04-11 | Dickey | North Dakota | 38021 | 1485 | 39 |
2394136 | 2394136 | 2022-04-10 | Dickey | North Dakota | 38021 | 1485 | 39 |
2390880 | 2390880 | 2022-04-09 | Dickey | North Dakota | 38021 | 1485 | 39 |
2387624 | 2387624 | 2022-04-08 | Dickey | North Dakota | 38021 | 1485 | 39 |
2379666 | 2379666 | 2022-04-06 | Caribou | Idaho | 16029 | 1485 | 27 |
2376412 | 2376412 | 2022-04-05 | Caribou | Idaho | 16029 | 1485 | 27 |
2373160 | 2373160 | 2022-04-04 | Caribou | Idaho | 16029 | 1485 | 27 |
2354803 | 2354803 | 2022-03-29 | Nemaha | Nebraska | 31127 | 1485 | 19 |
2338848 | 2338848 | 2022-03-24 | Ransom | North Dakota | 38073 | 1485 | 28 |
2335594 | 2335594 | 2022-03-23 | Ransom | North Dakota | 38073 | 1485 | 28 |
2332340 | 2332340 | 2022-03-22 | Ransom | North Dakota | 38073 | 1485 | 28 |
2329087 | 2329087 | 2022-03-21 | Ransom | North Dakota | 38073 | 1485 | 28 |
2325835 | 2325835 | 2022-03-20 | Ransom | North Dakota | 38073 | 1485 | 28 |
2322582 | 2322582 | 2022-03-19 | Ransom | North Dakota | 38073 | 1485 | 28 |
2319328 | 2319328 | 2022-03-18 | Ransom | North Dakota | 38073 | 1485 | 28 |
2309568 | 2309568 | 2022-03-15 | Ransom | North Dakota | 38073 | 1485 | 28 |
2306315 | 2306315 | 2022-03-14 | Ransom | North Dakota | 38073 | 1485 | 28 |
2303064 | 2303064 | 2022-03-13 | Ransom | North Dakota | 38073 | 1485 | 28 |
2299812 | 2299812 | 2022-03-12 | Ransom | North Dakota | 38073 | 1485 | 28 |
2267289 | 2267289 | 2022-03-02 | Ransom | North Dakota | 38073 | 1485 | 28 |
2262591 | 2262591 | 2022-03-01 | Power | Idaho | 16077 | 1485 | 20 |
2246226 | 2246226 | 2022-02-24 | Marion | Georgia | 13197 | 1485 | 47 |
2242648 | 2242648 | 2022-02-23 | Montgomery | Arkansas | 5097 | 1485 | 54 |
2242975 | 2242975 | 2022-02-23 | Marion | Georgia | 13197 | 1485 | 47 |
2239724 | 2239724 | 2022-02-22 | Marion | Georgia | 13197 | 1485 | 47 |
2241730 | 2241730 | 2022-02-22 | Hamlin | South Dakota | 46057 | 1485 | 41 |
2220218 | 2220218 | 2022-02-16 | Marion | Georgia | 13197 | 1485 | 44 |
2221328 | 2221328 | 2022-02-16 | Shelby | Missouri | 29205 | 1485 | 14 |
2176438 | 2176438 | 2022-02-02 | Grant | Oregon | 41023 | 1485 | 18 |
2177446 | 2177446 | 2022-02-02 | Weston | Wyoming | 56045 | 1485 | 17 |
2171153 | 2171153 | 2022-02-01 | Modoc | California | 6049 | 1485 | 11 |
2167900 | 2167900 | 2022-01-31 | Modoc | California | 6049 | 1485 | 11 |
2164645 | 2164645 | 2022-01-30 | Modoc | California | 6049 | 1485 | 11 |
2161390 | 2161390 | 2022-01-29 | Modoc | California | 6049 | 1485 | 11 |
2158134 | 2158134 | 2022-01-28 | Modoc | California | 6049 | 1485 | 11 |
2145393 | 2145393 | 2022-01-24 | Lincoln | Georgia | 13181 | 1485 | 33 |
2133562 | 2133562 | 2022-01-20 | Valley | Montana | 30105 | 1485 | 32 |
2123753 | 2123753 | 2022-01-17 | Blaine | Montana | 30005 | 1485 | 28 |
2120501 | 2120501 | 2022-01-16 | Blaine | Montana | 30005 | 1485 | 28 |
2117249 | 2117249 | 2022-01-15 | Blaine | Montana | 30005 | 1485 | 28 |
2113998 | 2113998 | 2022-01-14 | Blaine | Montana | 30005 | 1485 | 28 |
2109217 | 2109217 | 2022-01-13 | Southeast Fairbanks Census Area | Alaska | 2240 | 1485 | 14 |
2105966 | 2105966 | 2022-01-12 | Southeast Fairbanks Census Area | Alaska | 2240 | 1485 | 14 |
2091994 | 2091994 | 2022-01-07 | Lajas | Puerto Rico | 72079 | 1485 | |
2081874 | 2081874 | 2022-01-04 | Benson | North Dakota | 38005 | 1485 | 22 |
2078557 | 2078557 | 2022-01-03 | Graham | North Carolina | 37075 | 1485 | 28 |
2073421 | 2073421 | 2022-01-02 | Sumter | Alabama | 1119 | 1485 | 42 |
2058144 | 2058144 | 2021-12-28 | Elliott | Kentucky | 21063 | 1485 | 13 |
2040986 | 2040986 | 2021-12-23 | Cleveland | Arkansas | 5025 | 1485 | 33 |
2036402 | 2036402 | 2021-12-21 | Pembina | North Dakota | 38067 | 1485 | 15 |
2032143 | 2032143 | 2021-12-20 | Cumberland | Kentucky | 21057 | 1485 | 22 |
2010846 | 2010846 | 2021-12-13 | Grant | South Dakota | 46051 | 1485 | 46 |
1995214 | 1995214 | 2021-12-08 | Gilmer | West Virginia | 54021 | 1485 | 14 |
1987317 | 1987317 | 2021-12-06 | Holt | Nebraska | 31089 | 1485 | 16 |
1967395 | 1967395 | 2021-11-30 | Mackinac | Michigan | 26097 | 1485 | 14 |
1968514 | 1968514 | 2021-11-30 | Yauco | Puerto Rico | 72153 | 1485 | |
1964143 | 1964143 | 2021-11-29 | Mackinac | Michigan | 26097 | 1485 | 14 |
1965263 | 1965263 | 2021-11-29 | Yauco | Puerto Rico | 72153 | 1485 | |
1962011 | 1962011 | 2021-11-28 | Yauco | Puerto Rico | 72153 | 1485 | |
1958760 | 1958760 | 2021-11-27 | Yauco | Puerto Rico | 72153 | 1485 | |
1955509 | 1955509 | 2021-11-26 | Yauco | Puerto Rico | 72153 | 1485 | |
1952258 | 1952258 | 2021-11-25 | Yauco | Puerto Rico | 72153 | 1485 | |
1946300 | 1946300 | 2021-11-23 | Clarke | Virginia | 51043 | 1485 | 28 |
1937321 | 1937321 | 2021-11-21 | Lanier | Georgia | 13173 | 1485 | 17 |
1934071 | 1934071 | 2021-11-20 | Lanier | Georgia | 13173 | 1485 | 17 |
1930819 | 1930819 | 2021-11-19 | Lanier | Georgia | 13173 | 1485 | 17 |
1928471 | 1928471 | 2021-11-18 | Murray | Minnesota | 27101 | 1485 | 11 |
1924319 | 1924319 | 2021-11-17 | Lanier | Georgia | 13173 | 1485 | 17 |
1915496 | 1915496 | 2021-11-14 | Stevens | Minnesota | 27149 | 1485 | 11 |
1912246 | 1912246 | 2021-11-13 | Stevens | Minnesota | 27149 | 1485 | 11 |
1908996 | 1908996 | 2021-11-12 | Stevens | Minnesota | 27149 | 1485 | 11 |
1904554 | 1904554 | 2021-11-11 | Mariposa | California | 6043 | 1485 | 17 |
1905257 | 1905257 | 2021-11-11 | Cloud | Kansas | 20029 | 1485 | 32 |
1901304 | 1901304 | 2021-11-10 | Mariposa | California | 6043 | 1485 | 17 |
1902007 | 1902007 | 2021-11-10 | Cloud | Kansas | 20029 | 1485 | 32 |
1892875 | 1892875 | 2021-11-07 | DeKalb | Missouri | 29063 | 1485 | 34 |
1894488 | 1894488 | 2021-11-07 | Ritchie | West Virginia | 54085 | 1485 | 20 |
1889625 | 1889625 | 2021-11-06 | DeKalb | Missouri | 29063 | 1485 | 34 |
1859454 | 1859454 | 2021-10-28 | Valley | Idaho | 16085 | 1485 | 10 |
1858442 | 1858442 | 2021-10-27 | Somervell | Texas | 48425 | 1485 | 21 |
1829535 | 1829535 | 2021-10-18 | Forest | Wisconsin | 55041 | 1485 | 31 |
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);