ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
491 rows where cases = 984 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 46
- Georgia 38
- Kentucky 26
- Arkansas 19
- Louisiana 19
- Puerto Rico 19
- Mississippi 18
- Iowa 16
- Nebraska 16
- Virginia 16
- Montana 15
- Florida 14
- Missouri 14
- Wyoming 14
- Indiana 12
- Kansas 12
- Michigan 12
- California 11
- Minnesota 11
- North Carolina 11
- Oklahoma 11
- Colorado 10
- North Dakota 10
- South Carolina 9
- Tennessee 9
- Wisconsin 8
- Pennsylvania 7
- Idaho 6
- Illinois 6
- Alabama 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500755 | 2500755 | 2022-05-13 | Unknown | Louisiana | 984 | 0 | |
2473075 | 2473075 | 2022-05-04 | Presidio | Texas | 48377 | 984 | 38 |
2334725 | 2334725 | 2022-03-23 | Tensas | Louisiana | 22107 | 984 | 11 |
2330507 | 2330507 | 2022-03-22 | Modoc | California | 6049 | 984 | 7 |
2331471 | 2331471 | 2022-03-22 | Tensas | Louisiana | 22107 | 984 | 11 |
2327255 | 2327255 | 2022-03-21 | Modoc | California | 6049 | 984 | 7 |
2328219 | 2328219 | 2022-03-21 | Tensas | Louisiana | 22107 | 984 | 11 |
2324002 | 2324002 | 2022-03-20 | Modoc | California | 6049 | 984 | 7 |
2324966 | 2324966 | 2022-03-20 | Tensas | Louisiana | 22107 | 984 | 11 |
2326715 | 2326715 | 2022-03-20 | Unknown | Vermont | 984 | 2 | |
2320748 | 2320748 | 2022-03-19 | Modoc | California | 6049 | 984 | 7 |
2321712 | 2321712 | 2022-03-19 | Tensas | Louisiana | 22107 | 984 | 11 |
2323462 | 2323462 | 2022-03-19 | Unknown | Vermont | 984 | 2 | |
2317494 | 2317494 | 2022-03-18 | Modoc | California | 6049 | 984 | 7 |
2318458 | 2318458 | 2022-03-18 | Tensas | Louisiana | 22107 | 984 | 11 |
2320208 | 2320208 | 2022-03-18 | Unknown | Vermont | 984 | 2 | |
2314241 | 2314241 | 2022-03-17 | Modoc | California | 6049 | 984 | 7 |
2315205 | 2315205 | 2022-03-17 | Tensas | Louisiana | 22107 | 984 | 11 |
2316053 | 2316053 | 2022-03-17 | Foster | North Dakota | 38031 | 984 | 23 |
2311952 | 2311952 | 2022-03-16 | Tensas | Louisiana | 22107 | 984 | 11 |
2312800 | 2312800 | 2022-03-16 | Foster | North Dakota | 38031 | 984 | 23 |
2308699 | 2308699 | 2022-03-15 | Tensas | Louisiana | 22107 | 984 | 11 |
2309547 | 2309547 | 2022-03-15 | Foster | North Dakota | 38031 | 984 | 23 |
2305448 | 2305448 | 2022-03-14 | Tensas | Louisiana | 22107 | 984 | 11 |
2293294 | 2293294 | 2022-03-10 | LaMoure | North Dakota | 38045 | 984 | 20 |
2270084 | 2270084 | 2022-03-03 | Putnam | Missouri | 29171 | 984 | 22 |
2225705 | 2225705 | 2022-02-17 | Hall | Texas | 48191 | 984 | 21 |
2219172 | 2219172 | 2022-02-15 | Donley | Texas | 48129 | 984 | 23 |
2215921 | 2215921 | 2022-02-14 | Donley | Texas | 48129 | 984 | 23 |
2189250 | 2189250 | 2022-02-06 | Sargent | North Dakota | 38081 | 984 | 9 |
2185997 | 2185997 | 2022-02-05 | Sargent | North Dakota | 38081 | 984 | 9 |
2182745 | 2182745 | 2022-02-04 | Sargent | North Dakota | 38081 | 984 | 9 |
2172483 | 2172483 | 2022-02-01 | Holt | Missouri | 29087 | 984 | 25 |
2166084 | 2166084 | 2022-01-30 | Phillips | Montana | 30071 | 984 | 28 |
2166207 | 2166207 | 2022-01-30 | Lander | Nevada | 32015 | 984 | 16 |
2162829 | 2162829 | 2022-01-29 | Phillips | Montana | 30071 | 984 | 28 |
2162952 | 2162952 | 2022-01-29 | Lander | Nevada | 32015 | 984 | 16 |
2159574 | 2159574 | 2022-01-28 | Phillips | Montana | 30071 | 984 | 28 |
2159697 | 2159697 | 2022-01-28 | Lander | Nevada | 32015 | 984 | 16 |
2156443 | 2156443 | 2022-01-27 | Lander | Nevada | 32015 | 984 | 16 |
2149841 | 2149841 | 2022-01-25 | Boone | Nebraska | 31011 | 984 | 4 |
2125087 | 2125087 | 2022-01-17 | Charles City | Virginia | 51036 | 984 | 22 |
2115059 | 2115059 | 2022-01-14 | Crane | Texas | 48103 | 984 | 19 |
2110262 | 2110262 | 2022-01-13 | Cameron | Louisiana | 22023 | 984 | 8 |
2107011 | 2107011 | 2022-01-12 | Cameron | Louisiana | 22023 | 984 | 8 |
2103760 | 2103760 | 2022-01-11 | Cameron | Louisiana | 22023 | 984 | 8 |
2102034 | 2102034 | 2022-01-10 | Carson | Texas | 48065 | 984 | 29 |
2076330 | 2076330 | 2022-01-02 | Falls Church city | Virginia | 51610 | 984 | 14 |
2073079 | 2073079 | 2022-01-01 | Falls Church city | Virginia | 51610 | 984 | 14 |
2069828 | 2069828 | 2021-12-31 | Falls Church city | Virginia | 51610 | 984 | 14 |
2054624 | 2054624 | 2021-12-27 | Ohio | Indiana | 18115 | 984 | 14 |
2045925 | 2045925 | 2021-12-24 | Unknown | New Jersey | 984 | 0 | |
2035338 | 2035338 | 2021-12-21 | Republic | Kansas | 20157 | 984 | 14 |
2032088 | 2032088 | 2021-12-20 | Republic | Kansas | 20157 | 984 | 14 |
2029580 | 2029580 | 2021-12-19 | Jefferson | Nebraska | 31095 | 984 | 3 |
2026329 | 2026329 | 2021-12-18 | Jefferson | Nebraska | 31095 | 984 | 3 |
2023078 | 2023078 | 2021-12-17 | Jefferson | Nebraska | 31095 | 984 | 3 |
1982896 | 1982896 | 2021-12-05 | Wheeler | Georgia | 13309 | 984 | 35 |
1979646 | 1979646 | 2021-12-04 | Wheeler | Georgia | 13309 | 984 | 35 |
1976396 | 1976396 | 2021-12-03 | Wheeler | Georgia | 13309 | 984 | 35 |
1964894 | 1964894 | 2021-11-29 | Ransom | North Dakota | 38073 | 984 | 21 |
1962833 | 1962833 | 2021-11-28 | Crook | Wyoming | 56011 | 984 | 20 |
1959582 | 1959582 | 2021-11-27 | Crook | Wyoming | 56011 | 984 | 20 |
1956331 | 1956331 | 2021-11-26 | Crook | Wyoming | 56011 | 984 | 20 |
1953080 | 1953080 | 2021-11-25 | Crook | Wyoming | 56011 | 984 | 20 |
1949829 | 1949829 | 2021-11-24 | Crook | Wyoming | 56011 | 984 | 20 |
1946578 | 1946578 | 2021-11-23 | Crook | Wyoming | 56011 | 984 | 20 |
1940334 | 1940334 | 2021-11-22 | Trinity | California | 6105 | 984 | 17 |
1942838 | 1942838 | 2021-11-22 | Jack | Texas | 48237 | 984 | 21 |
1939588 | 1939588 | 2021-11-21 | Jack | Texas | 48237 | 984 | 21 |
1936338 | 1936338 | 2021-11-20 | Jack | Texas | 48237 | 984 | 21 |
1928827 | 1928827 | 2021-11-18 | Nemaha | Nebraska | 31127 | 984 | 16 |
1924054 | 1924054 | 2021-11-17 | Modoc | California | 6049 | 984 | 9 |
1924164 | 1924164 | 2021-11-17 | Unknown | Delaware | 984 | 0 | |
1927037 | 1927037 | 2021-11-17 | Menominee | Wisconsin | 55078 | 984 | 11 |
1847873 | 1847873 | 2021-10-24 | Dickey | North Dakota | 38021 | 984 | 33 |
1830706 | 1830706 | 2021-10-19 | Owsley | Kentucky | 21189 | 984 | 15 |
1830855 | 1830855 | 2021-10-19 | Alger | Michigan | 26003 | 984 | 8 |
1827606 | 1827606 | 2021-10-18 | Alger | Michigan | 26003 | 984 | 8 |
1813962 | 1813962 | 2021-10-14 | Power | Idaho | 16077 | 984 | 13 |
1811952 | 1811952 | 2021-10-13 | Quay | New Mexico | 35037 | 984 | 18 |
1809501 | 1809501 | 2021-10-12 | Bailey | Texas | 48017 | 984 | 23 |
1806251 | 1806251 | 2021-10-11 | Bailey | Texas | 48017 | 984 | 23 |
1803001 | 1803001 | 2021-10-10 | Bailey | Texas | 48017 | 984 | 23 |
1799752 | 1799752 | 2021-10-09 | Bailey | Texas | 48017 | 984 | 23 |
1796503 | 1796503 | 2021-10-08 | Bailey | Texas | 48017 | 984 | 23 |
1783116 | 1783116 | 2021-10-04 | Harney | Oregon | 41025 | 984 | 23 |
1761128 | 1761128 | 2021-09-27 | Lunenburg | Virginia | 51111 | 984 | 18 |
1755895 | 1755895 | 2021-09-26 | Bracken | Kentucky | 21023 | 984 | 8 |
1752647 | 1752647 | 2021-09-25 | Bracken | Kentucky | 21023 | 984 | 8 |
1749398 | 1749398 | 2021-09-24 | Bracken | Kentucky | 21023 | 984 | 8 |
1743083 | 1743083 | 2021-09-22 | Piscataquis | Maine | 23021 | 984 | 7 |
1736173 | 1736173 | 2021-09-20 | Union | Indiana | 18161 | 984 | 12 |
1723883 | 1723883 | 2021-09-16 | Wilkinson | Mississippi | 28157 | 984 | 35 |
1720680 | 1720680 | 2021-09-15 | Hickory | Missouri | 29085 | 984 | 17 |
1720807 | 1720807 | 2021-09-15 | Valley | Montana | 30105 | 984 | 18 |
1717432 | 1717432 | 2021-09-14 | Hickory | Missouri | 29085 | 984 | 17 |
1712641 | 1712641 | 2021-09-12 | Sublette | Wyoming | 56035 | 984 | 11 |
1709394 | 1709394 | 2021-09-11 | Sublette | Wyoming | 56035 | 984 | 11 |
1703089 | 1703089 | 2021-09-10 | Woodruff | Arkansas | 5147 | 984 | 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);