ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
621 rows where cases = 492 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 71
- Georgia 38
- Mississippi 33
- Nebraska 32
- Kentucky 27
- Illinois 25
- Montana 24
- Virginia 24
- Minnesota 20
- South Dakota 20
- Kansas 19
- Missouri 17
- Arkansas 16
- Michigan 16
- North Carolina 16
- Puerto Rico 15
- Iowa 14
- Nevada 13
- Oregon 13
- Colorado 12
- Pennsylvania 12
- California 11
- North Dakota 11
- West Virginia 11
- Indiana 10
- Idaho 9
- New York 9
- Tennessee 9
- Ohio 8
- Oklahoma 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502344 | 2502344 | 2022-05-13 | Knox | Texas | 48275 | 492 | 25 |
2499086 | 2499086 | 2022-05-12 | Knox | Texas | 48275 | 492 | 25 |
2495828 | 2495828 | 2022-05-11 | Knox | Texas | 48275 | 492 | 25 |
2492570 | 2492570 | 2022-05-10 | Knox | Texas | 48275 | 492 | 25 |
2489312 | 2489312 | 2022-05-09 | Knox | Texas | 48275 | 492 | 25 |
2486055 | 2486055 | 2022-05-08 | Knox | Texas | 48275 | 492 | 25 |
2482797 | 2482797 | 2022-05-07 | Knox | Texas | 48275 | 492 | 25 |
2479539 | 2479539 | 2022-05-06 | Knox | Texas | 48275 | 492 | 25 |
2476281 | 2476281 | 2022-05-05 | Knox | Texas | 48275 | 492 | 25 |
2473024 | 2473024 | 2022-05-04 | Knox | Texas | 48275 | 492 | 25 |
2469768 | 2469768 | 2022-05-03 | Knox | Texas | 48275 | 492 | 25 |
2466512 | 2466512 | 2022-05-02 | Knox | Texas | 48275 | 492 | 25 |
2463257 | 2463257 | 2022-05-01 | Knox | Texas | 48275 | 492 | 25 |
2460001 | 2460001 | 2022-04-30 | Knox | Texas | 48275 | 492 | 25 |
2456745 | 2456745 | 2022-04-29 | Knox | Texas | 48275 | 492 | 25 |
2453489 | 2453489 | 2022-04-28 | Knox | Texas | 48275 | 492 | 25 |
2450233 | 2450233 | 2022-04-27 | Knox | Texas | 48275 | 492 | 25 |
2446976 | 2446976 | 2022-04-26 | Knox | Texas | 48275 | 492 | 25 |
2443721 | 2443721 | 2022-04-25 | Knox | Texas | 48275 | 492 | 25 |
2440465 | 2440465 | 2022-04-24 | Knox | Texas | 48275 | 492 | 25 |
2437209 | 2437209 | 2022-04-23 | Knox | Texas | 48275 | 492 | 25 |
2433953 | 2433953 | 2022-04-22 | Knox | Texas | 48275 | 492 | 25 |
2430697 | 2430697 | 2022-04-21 | Knox | Texas | 48275 | 492 | 25 |
2427441 | 2427441 | 2022-04-20 | Knox | Texas | 48275 | 492 | 25 |
2424185 | 2424185 | 2022-04-19 | Knox | Texas | 48275 | 492 | 25 |
2420929 | 2420929 | 2022-04-18 | Knox | Texas | 48275 | 492 | 25 |
2287599 | 2287599 | 2022-03-08 | Sherman | Texas | 48421 | 492 | 16 |
2240236 | 2240236 | 2022-02-22 | Wichita | Kansas | 20203 | 492 | 8 |
2236985 | 2236985 | 2022-02-21 | Wichita | Kansas | 20203 | 492 | 8 |
2233734 | 2233734 | 2022-02-20 | Wichita | Kansas | 20203 | 492 | 8 |
2230483 | 2230483 | 2022-02-19 | Wichita | Kansas | 20203 | 492 | 8 |
2227232 | 2227232 | 2022-02-18 | Wichita | Kansas | 20203 | 492 | 8 |
2228866 | 2228866 | 2022-02-18 | Armstrong | Texas | 48011 | 492 | 8 |
2225615 | 2225615 | 2022-02-17 | Armstrong | Texas | 48011 | 492 | 8 |
2218508 | 2218508 | 2022-02-15 | Kidder | North Dakota | 38043 | 492 | 13 |
2214909 | 2214909 | 2022-02-14 | Brown | Nebraska | 31017 | 492 | 4 |
2201898 | 2201898 | 2022-02-10 | Brown | Nebraska | 31017 | 492 | 4 |
2198644 | 2198644 | 2022-02-09 | Brown | Nebraska | 31017 | 492 | 4 |
2194996 | 2194996 | 2022-02-08 | Keweenaw | Michigan | 26083 | 492 | 12 |
2191742 | 2191742 | 2022-02-07 | Keweenaw | Michigan | 26083 | 492 | 12 |
2175829 | 2175829 | 2022-02-02 | Granite | Montana | 30039 | 492 | 6 |
2133581 | 2133581 | 2022-01-20 | Cherry | Nebraska | 31031 | 492 | 8 |
2124942 | 2124942 | 2022-01-17 | Oldham | Texas | 48359 | 492 | 6 |
2109581 | 2109581 | 2022-01-13 | Glascock | Georgia | 13125 | 492 | 21 |
2111628 | 2111628 | 2022-01-13 | Jackson | South Dakota | 46071 | 492 | 19 |
2107903 | 2107903 | 2022-01-12 | Griggs | North Dakota | 38039 | 492 | 2 |
2108397 | 2108397 | 2022-01-12 | Sanborn | South Dakota | 46111 | 492 | 4 |
2091674 | 2091674 | 2022-01-07 | Towner | North Dakota | 38095 | 492 | 11 |
2088898 | 2088898 | 2022-01-06 | Ziebach | South Dakota | 46137 | 492 | 11 |
2033474 | 2033474 | 2021-12-20 | Guanica | Puerto Rico | 72055 | 492 | |
2017352 | 2017352 | 2021-12-15 | Hanson | South Dakota | 46061 | 492 | 5 |
1975267 | 1975267 | 2021-12-02 | Cochran | Texas | 48079 | 492 | 19 |
1900783 | 1900783 | 2021-11-09 | Bath | Virginia | 51017 | 492 | 15 |
1893100 | 1893100 | 2021-11-07 | Stanton | Nebraska | 31167 | 492 | 11 |
1889850 | 1889850 | 2021-11-06 | Stanton | Nebraska | 31167 | 492 | 11 |
1886600 | 1886600 | 2021-11-05 | Stanton | Nebraska | 31167 | 492 | 11 |
1883351 | 1883351 | 2021-11-04 | Stanton | Nebraska | 31167 | 492 | 11 |
1880102 | 1880102 | 2021-11-03 | Stanton | Nebraska | 31167 | 492 | 11 |
1868672 | 1868672 | 2021-10-31 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 492 | 0 |
1865423 | 1865423 | 2021-10-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 492 | 0 |
1862174 | 1862174 | 2021-10-29 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 492 | 0 |
1846843 | 1846843 | 2021-10-24 | Sheridan | Kansas | 20179 | 492 | 14 |
1843593 | 1843593 | 2021-10-23 | Sheridan | Kansas | 20179 | 492 | 14 |
1840343 | 1840343 | 2021-10-22 | Sheridan | Kansas | 20179 | 492 | 14 |
1828021 | 1828021 | 2021-10-18 | Sheridan | Montana | 30091 | 492 | 7 |
1824772 | 1824772 | 2021-10-17 | Sheridan | Montana | 30091 | 492 | 7 |
1821523 | 1821523 | 2021-10-16 | Sheridan | Montana | 30091 | 492 | 7 |
1817173 | 1817173 | 2021-10-15 | Adams | Idaho | 16003 | 492 | 9 |
1818274 | 1818274 | 2021-10-15 | Sheridan | Montana | 30091 | 492 | 7 |
1815025 | 1815025 | 2021-10-14 | Sheridan | Montana | 30091 | 492 | 7 |
1790328 | 1790328 | 2021-10-06 | Craig | Virginia | 51045 | 492 | 6 |
1785898 | 1785898 | 2021-10-05 | Lincoln | Nevada | 32017 | 492 | 5 |
1786884 | 1786884 | 2021-10-05 | Kinney | Texas | 48271 | 492 | 8 |
1786941 | 1786941 | 2021-10-05 | Real | Texas | 48385 | 492 | 17 |
1782649 | 1782649 | 2021-10-04 | Lincoln | Nevada | 32017 | 492 | 5 |
1783349 | 1783349 | 2021-10-04 | Clark | South Dakota | 46025 | 492 | 5 |
1783635 | 1783635 | 2021-10-04 | Kinney | Texas | 48271 | 492 | 8 |
1783692 | 1783692 | 2021-10-04 | Real | Texas | 48385 | 492 | 16 |
1779399 | 1779399 | 2021-10-03 | Lincoln | Nevada | 32017 | 492 | 4 |
1780386 | 1780386 | 2021-10-03 | Kinney | Texas | 48271 | 492 | 8 |
1780443 | 1780443 | 2021-10-03 | Real | Texas | 48385 | 492 | 16 |
1776149 | 1776149 | 2021-10-02 | Lincoln | Nevada | 32017 | 492 | 4 |
1777136 | 1777136 | 2021-10-02 | Kinney | Texas | 48271 | 492 | 8 |
1777193 | 1777193 | 2021-10-02 | Real | Texas | 48385 | 492 | 16 |
1772899 | 1772899 | 2021-10-01 | Lincoln | Nevada | 32017 | 492 | 4 |
1773137 | 1773137 | 2021-10-01 | Bowman | North Dakota | 38011 | 492 | 6 |
1773886 | 1773886 | 2021-10-01 | Kinney | Texas | 48271 | 492 | 8 |
1773943 | 1773943 | 2021-10-01 | Real | Texas | 48385 | 492 | 16 |
1769650 | 1769650 | 2021-09-30 | Lincoln | Nevada | 32017 | 492 | 4 |
1770636 | 1770636 | 2021-09-30 | Kinney | Texas | 48271 | 492 | 8 |
1770693 | 1770693 | 2021-09-30 | Real | Texas | 48385 | 492 | 16 |
1766401 | 1766401 | 2021-09-29 | Lincoln | Nevada | 32017 | 492 | 4 |
1763152 | 1763152 | 2021-09-28 | Lincoln | Nevada | 32017 | 492 | 4 |
1759903 | 1759903 | 2021-09-27 | Lincoln | Nevada | 32017 | 492 | 4 |
1756616 | 1756616 | 2021-09-26 | Nuckolls | Nebraska | 31129 | 492 | 12 |
1756655 | 1756655 | 2021-09-26 | Lincoln | Nevada | 32017 | 492 | 4 |
1753368 | 1753368 | 2021-09-25 | Nuckolls | Nebraska | 31129 | 492 | 12 |
1753407 | 1753407 | 2021-09-25 | Lincoln | Nevada | 32017 | 492 | 4 |
1750120 | 1750120 | 2021-09-24 | Nuckolls | Nebraska | 31129 | 492 | 12 |
1750159 | 1750159 | 2021-09-24 | Lincoln | Nevada | 32017 | 492 | 4 |
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);