ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
440 rows where cases = 1058 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 36
- Missouri 29
- Michigan 22
- Georgia 19
- Idaho 19
- North Dakota 19
- Oklahoma 19
- Arkansas 17
- Puerto Rico 17
- Tennessee 14
- Illinois 13
- Iowa 13
- Montana 13
- South Dakota 13
- Kentucky 11
- Minnesota 11
- North Carolina 11
- Virginia 11
- Alabama 10
- Colorado 9
- Kansas 9
- Nebraska 9
- New York 9
- Ohio 8
- Vermont 8
- Mississippi 7
- Louisiana 6
- Pennsylvania 6
- Utah 6
- Florida 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497861 | 2497861 | 2022-05-12 | Holt | Missouri | 29087 | 1058 | 30 |
2494603 | 2494603 | 2022-05-11 | Holt | Missouri | 29087 | 1058 | 30 |
2491345 | 2491345 | 2022-05-10 | Holt | Missouri | 29087 | 1058 | 30 |
2488087 | 2488087 | 2022-05-09 | Holt | Missouri | 29087 | 1058 | 30 |
2484830 | 2484830 | 2022-05-08 | Holt | Missouri | 29087 | 1058 | 30 |
2481572 | 2481572 | 2022-05-07 | Holt | Missouri | 29087 | 1058 | 30 |
2478314 | 2478314 | 2022-05-06 | Holt | Missouri | 29087 | 1058 | 30 |
2449792 | 2449792 | 2022-04-27 | Sullivan | Pennsylvania | 42113 | 1058 | 36 |
2392421 | 2392421 | 2022-04-10 | Washington | Colorado | 8121 | 1058 | 27 |
2389165 | 2389165 | 2022-04-09 | Washington | Colorado | 8121 | 1058 | 27 |
2385910 | 2385910 | 2022-04-08 | Washington | Colorado | 8121 | 1058 | 27 |
2384393 | 2384393 | 2022-04-07 | Pierce | North Dakota | 38069 | 1058 | 32 |
2381138 | 2381138 | 2022-04-06 | Pierce | North Dakota | 38069 | 1058 | 32 |
2377883 | 2377883 | 2022-04-05 | Pierce | North Dakota | 38069 | 1058 | 32 |
2374630 | 2374630 | 2022-04-04 | Pierce | North Dakota | 38069 | 1058 | 32 |
2371378 | 2371378 | 2022-04-03 | Pierce | North Dakota | 38069 | 1058 | 32 |
2368125 | 2368125 | 2022-04-02 | Pierce | North Dakota | 38069 | 1058 | 32 |
2364872 | 2364872 | 2022-04-01 | Pierce | North Dakota | 38069 | 1058 | 32 |
2353608 | 2353608 | 2022-03-29 | Warren | Georgia | 13301 | 1058 | 29 |
2350356 | 2350356 | 2022-03-28 | Warren | Georgia | 13301 | 1058 | 29 |
2290054 | 2290054 | 2022-03-09 | Pierce | North Dakota | 38069 | 1058 | 32 |
2290188 | 2290188 | 2022-03-09 | Dewey | Oklahoma | 40043 | 1058 | 28 |
2286936 | 2286936 | 2022-03-08 | Dewey | Oklahoma | 40043 | 1058 | 28 |
2283684 | 2283684 | 2022-03-07 | Dewey | Oklahoma | 40043 | 1058 | 28 |
2278822 | 2278822 | 2022-03-06 | Boise | Idaho | 16015 | 1058 | 13 |
2280432 | 2280432 | 2022-03-06 | Dewey | Oklahoma | 40043 | 1058 | 28 |
2275569 | 2275569 | 2022-03-05 | Boise | Idaho | 16015 | 1058 | 13 |
2277179 | 2277179 | 2022-03-05 | Dewey | Oklahoma | 40043 | 1058 | 28 |
2272316 | 2272316 | 2022-03-04 | Boise | Idaho | 16015 | 1058 | 13 |
2273926 | 2273926 | 2022-03-04 | Dewey | Oklahoma | 40043 | 1058 | 28 |
2269064 | 2269064 | 2022-03-03 | Boise | Idaho | 16015 | 1058 | 13 |
2270673 | 2270673 | 2022-03-03 | Dewey | Oklahoma | 40043 | 1058 | 28 |
2267421 | 2267421 | 2022-03-02 | Dewey | Oklahoma | 40043 | 1058 | 28 |
2267623 | 2267623 | 2022-03-02 | Las Marias | Puerto Rico | 72083 | 1058 | |
2257972 | 2257972 | 2022-02-27 | Corson | South Dakota | 46031 | 1058 | 17 |
2254721 | 2254721 | 2022-02-26 | Corson | South Dakota | 46031 | 1058 | 17 |
2251470 | 2251470 | 2022-02-25 | Corson | South Dakota | 46031 | 1058 | 17 |
2248219 | 2248219 | 2022-02-24 | Corson | South Dakota | 46031 | 1058 | 16 |
2244968 | 2244968 | 2022-02-23 | Corson | South Dakota | 46031 | 1058 | 16 |
2245180 | 2245180 | 2022-02-23 | Donley | Texas | 48129 | 1058 | 24 |
2241728 | 2241728 | 2022-02-22 | Gregory | South Dakota | 46053 | 1058 | 33 |
2173858 | 2173858 | 2022-02-01 | Essex | Vermont | 50009 | 1058 | 3 |
2163895 | 2163895 | 2022-01-29 | Goliad | Texas | 48175 | 1058 | 28 |
2154369 | 2154369 | 2022-01-26 | Charles City | Virginia | 51036 | 1058 | 22 |
2118434 | 2118434 | 2022-01-15 | Newton | Texas | 48351 | 1058 | 56 |
2100709 | 2100709 | 2022-01-10 | Big Stone | Minnesota | 27011 | 1058 | 7 |
2101424 | 2101424 | 2022-01-10 | Sioux | North Dakota | 38085 | 1058 | 18 |
2102268 | 2102268 | 2022-01-10 | Kane | Utah | 49025 | 1058 | 13 |
2099017 | 2099017 | 2022-01-09 | Kane | Utah | 49025 | 1058 | 13 |
2099277 | 2099277 | 2022-01-09 | Wirt | West Virginia | 54105 | 1058 | 19 |
2095765 | 2095765 | 2022-01-08 | Kane | Utah | 49025 | 1058 | 13 |
2092513 | 2092513 | 2022-01-07 | Kane | Utah | 49025 | 1058 | 13 |
2089261 | 2089261 | 2022-01-06 | Kane | Utah | 49025 | 1058 | 13 |
2085645 | 2085645 | 2022-01-05 | Walworth | South Dakota | 46129 | 1058 | 19 |
2085911 | 2085911 | 2022-01-05 | Mitchell | Texas | 48335 | 1058 | 43 |
2058102 | 2058102 | 2021-12-28 | Stevens | Kansas | 20189 | 1058 | 17 |
2054853 | 2054853 | 2021-12-27 | Stevens | Kansas | 20189 | 1058 | 17 |
2053356 | 2053356 | 2021-12-26 | Jack | Texas | 48237 | 1058 | 22 |
2050106 | 2050106 | 2021-12-25 | Jack | Texas | 48237 | 1058 | 22 |
2046856 | 2046856 | 2021-12-24 | Jack | Texas | 48237 | 1058 | 22 |
2043606 | 2043606 | 2021-12-23 | Jack | Texas | 48237 | 1058 | 22 |
2020152 | 2020152 | 2021-12-16 | Ransom | North Dakota | 38073 | 1058 | 23 |
1973536 | 1973536 | 2021-12-02 | Greenwood | Kansas | 20073 | 1058 | 18 |
1974290 | 1974290 | 2021-12-02 | Clay | Nebraska | 31035 | 1058 | 17 |
1969925 | 1969925 | 2021-12-01 | Caribou | Idaho | 16029 | 1058 | 23 |
1970286 | 1970286 | 2021-12-01 | Greenwood | Kansas | 20073 | 1058 | 18 |
1967847 | 1967847 | 2021-11-30 | Richardson | Nebraska | 31147 | 1058 | 24 |
1968782 | 1968782 | 2021-11-30 | Crosby | Texas | 48107 | 1058 | 37 |
1965531 | 1965531 | 2021-11-29 | Crosby | Texas | 48107 | 1058 | 37 |
1961321 | 1961321 | 2021-11-28 | Keith | Nebraska | 31101 | 1058 | 11 |
1958070 | 1958070 | 2021-11-27 | Keith | Nebraska | 31101 | 1058 | 11 |
1954819 | 1954819 | 2021-11-26 | Keith | Nebraska | 31101 | 1058 | 11 |
1951568 | 1951568 | 2021-11-25 | Keith | Nebraska | 31101 | 1058 | 11 |
1948317 | 1948317 | 2021-11-24 | Keith | Nebraska | 31101 | 1058 | 11 |
1944940 | 1944940 | 2021-11-23 | Shannon | Missouri | 29203 | 1058 | 27 |
1945682 | 1945682 | 2021-11-23 | Aibonito | Puerto Rico | 72009 | 1058 | |
1942431 | 1942431 | 2021-11-22 | Aibonito | Puerto Rico | 72009 | 1058 | |
1938636 | 1938636 | 2021-11-21 | Unknown | New Hampshire | 1058 | 6 | |
1939181 | 1939181 | 2021-11-21 | Aibonito | Puerto Rico | 72009 | 1058 | |
1935386 | 1935386 | 2021-11-20 | Unknown | New Hampshire | 1058 | 6 | |
1932136 | 1932136 | 2021-11-19 | Unknown | New Hampshire | 1058 | 6 | |
1916614 | 1916614 | 2021-11-14 | Spink | South Dakota | 46115 | 1058 | 27 |
1913364 | 1913364 | 2021-11-13 | Spink | South Dakota | 46115 | 1058 | 27 |
1910114 | 1910114 | 2021-11-12 | Spink | South Dakota | 46115 | 1058 | 27 |
1904971 | 1904971 | 2021-11-11 | Edwards | Illinois | 17047 | 1058 | 20 |
1901721 | 1901721 | 2021-11-10 | Edwards | Illinois | 17047 | 1058 | 20 |
1898471 | 1898471 | 2021-11-09 | Edwards | Illinois | 17047 | 1058 | 20 |
1892864 | 1892864 | 2021-11-07 | Chariton | Missouri | 29041 | 1058 | 8 |
1878627 | 1878627 | 2021-11-03 | Lake | Colorado | 8065 | 1058 | 1 |
1869197 | 1869197 | 2021-10-31 | Power | Idaho | 16077 | 1058 | 14 |
1865948 | 1865948 | 2021-10-30 | Power | Idaho | 16077 | 1058 | 14 |
1862699 | 1862699 | 2021-10-29 | Power | Idaho | 16077 | 1058 | 14 |
1856283 | 1856283 | 2021-10-27 | Pulaski | Illinois | 17153 | 1058 | 12 |
1857447 | 1857447 | 2021-10-27 | Sierra | New Mexico | 35051 | 1058 | 56 |
1858599 | 1858599 | 2021-10-27 | Lancaster | Virginia | 51103 | 1058 | 21 |
1855350 | 1855350 | 2021-10-26 | Lancaster | Virginia | 51103 | 1058 | 21 |
1823718 | 1823718 | 2021-10-17 | Brown | Illinois | 17009 | 1058 | 15 |
1820469 | 1820469 | 2021-10-16 | Brown | Illinois | 17009 | 1058 | 15 |
1817220 | 1817220 | 2021-10-15 | Brown | Illinois | 17009 | 1058 | 15 |
1813972 | 1813972 | 2021-10-14 | Brown | Illinois | 17009 | 1058 | 15 |
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);