ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
405 rows where cases = 979 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 24
- Louisiana 24
- Kansas 21
- Texas 21
- Virginia 21
- Iowa 20
- Michigan 20
- Kentucky 19
- Missouri 18
- Nebraska 16
- North Dakota 15
- Arkansas 13
- Mississippi 13
- California 11
- Indiana 11
- Minnesota 11
- South Dakota 10
- Puerto Rico 9
- Colorado 8
- North Carolina 8
- Tennessee 8
- Washington 7
- Alabama 6
- Florida 6
- Idaho 6
- New York 6
- Oklahoma 6
- Oregon 6
- Illinois 5
- Pennsylvania 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501313 | 2501313 | 2022-05-13 | Nuckolls | Nebraska | 31129 | 979 | 13 |
2471993 | 2471993 | 2022-05-04 | Nuckolls | Nebraska | 31129 | 979 | 13 |
2468737 | 2468737 | 2022-05-03 | Nuckolls | Nebraska | 31129 | 979 | 13 |
2469819 | 2469819 | 2022-05-03 | Presidio | Texas | 48377 | 979 | 38 |
2465481 | 2465481 | 2022-05-02 | Nuckolls | Nebraska | 31129 | 979 | 13 |
2462226 | 2462226 | 2022-05-01 | Nuckolls | Nebraska | 31129 | 979 | 13 |
2458970 | 2458970 | 2022-04-30 | Nuckolls | Nebraska | 31129 | 979 | 13 |
2455714 | 2455714 | 2022-04-29 | Nuckolls | Nebraska | 31129 | 979 | 13 |
2452458 | 2452458 | 2022-04-28 | Nuckolls | Nebraska | 31129 | 979 | 13 |
2449202 | 2449202 | 2022-04-27 | Nuckolls | Nebraska | 31129 | 979 | 13 |
2425852 | 2425852 | 2022-04-20 | Unknown | Louisiana | 979 | 0 | |
2422596 | 2422596 | 2022-04-19 | Unknown | Louisiana | 979 | 0 | |
2419340 | 2419340 | 2022-04-18 | Unknown | Louisiana | 979 | 0 | |
2416084 | 2416084 | 2022-04-17 | Unknown | Louisiana | 979 | 0 | |
2412828 | 2412828 | 2022-04-16 | Unknown | Louisiana | 979 | 0 | |
2409572 | 2409572 | 2022-04-15 | Unknown | Louisiana | 979 | 0 | |
2406316 | 2406316 | 2022-04-14 | Unknown | Louisiana | 979 | 0 | |
2403060 | 2403060 | 2022-04-13 | Unknown | Louisiana | 979 | 0 | |
2399806 | 2399806 | 2022-04-12 | Unknown | Louisiana | 979 | 0 | |
2396550 | 2396550 | 2022-04-11 | Unknown | Louisiana | 979 | 0 | |
2393295 | 2393295 | 2022-04-10 | Unknown | Louisiana | 979 | 0 | |
2390039 | 2390039 | 2022-04-09 | Unknown | Louisiana | 979 | 0 | |
2386783 | 2386783 | 2022-04-08 | Unknown | Louisiana | 979 | 0 | |
2383528 | 2383528 | 2022-04-07 | Unknown | Louisiana | 979 | 0 | |
2380273 | 2380273 | 2022-04-06 | Unknown | Louisiana | 979 | 0 | |
2377018 | 2377018 | 2022-04-05 | Unknown | Louisiana | 979 | 0 | |
2373766 | 2373766 | 2022-04-04 | Unknown | Louisiana | 979 | 0 | |
2316954 | 2316954 | 2022-03-17 | Unknown | Vermont | 979 | 2 | |
2301232 | 2301232 | 2022-03-13 | Modoc | California | 6049 | 979 | 7 |
2297980 | 2297980 | 2022-03-12 | Modoc | California | 6049 | 979 | 7 |
2294728 | 2294728 | 2022-03-11 | Modoc | California | 6049 | 979 | 7 |
2291476 | 2291476 | 2022-03-10 | Modoc | California | 6049 | 979 | 7 |
2288224 | 2288224 | 2022-03-09 | Modoc | California | 6049 | 979 | 7 |
2284973 | 2284973 | 2022-03-08 | Modoc | California | 6049 | 979 | 7 |
2286783 | 2286783 | 2022-03-08 | Foster | North Dakota | 38031 | 979 | 23 |
2281721 | 2281721 | 2022-03-07 | Modoc | California | 6049 | 979 | 7 |
2283531 | 2283531 | 2022-03-07 | Foster | North Dakota | 38031 | 979 | 23 |
2278468 | 2278468 | 2022-03-06 | Modoc | California | 6049 | 979 | 7 |
2275215 | 2275215 | 2022-03-05 | Modoc | California | 6049 | 979 | 7 |
2271962 | 2271962 | 2022-03-04 | Modoc | California | 6049 | 979 | 7 |
2268710 | 2268710 | 2022-03-03 | Modoc | California | 6049 | 979 | 7 |
2266421 | 2266421 | 2022-03-02 | Tensas | Louisiana | 22107 | 979 | 11 |
2176214 | 2176214 | 2022-02-02 | Dunn | North Dakota | 38025 | 979 | 8 |
2165975 | 2165975 | 2022-01-30 | Holt | Missouri | 29087 | 979 | 25 |
2162720 | 2162720 | 2022-01-29 | Holt | Missouri | 29087 | 979 | 25 |
2150844 | 2150844 | 2022-01-25 | Crockett | Texas | 48105 | 979 | 17 |
2127105 | 2127105 | 2022-01-18 | Howard | Nebraska | 31093 | 979 | 15 |
2101040 | 2101040 | 2022-01-10 | Teton | Montana | 30099 | 979 | 19 |
2087056 | 2087056 | 2022-01-06 | Scott | Illinois | 17171 | 979 | 9 |
2087352 | 2087352 | 2022-01-06 | Scott | Kansas | 20171 | 979 | 32 |
2088195 | 2088195 | 2022-01-06 | Guadalupe | New Mexico | 35019 | 979 | 15 |
2084100 | 2084100 | 2022-01-05 | Scott | Kansas | 20171 | 979 | 32 |
2085599 | 2085599 | 2022-01-05 | Day | South Dakota | 46037 | 979 | 30 |
2081547 | 2081547 | 2022-01-04 | Burt | Nebraska | 31021 | 979 | 13 |
2078114 | 2078114 | 2022-01-03 | Atchison | Missouri | 29005 | 979 | 18 |
2074323 | 2074323 | 2022-01-02 | Morris | Kansas | 20127 | 979 | 23 |
2071072 | 2071072 | 2022-01-01 | Morris | Kansas | 20127 | 979 | 23 |
2067821 | 2067821 | 2021-12-31 | Morris | Kansas | 20127 | 979 | 23 |
2064570 | 2064570 | 2021-12-30 | Morris | Kansas | 20127 | 979 | 23 |
2060615 | 2060615 | 2021-12-29 | Clear Creek | Colorado | 8019 | 979 | 7 |
2061320 | 2061320 | 2021-12-29 | Morris | Kansas | 20127 | 979 | 23 |
2062873 | 2062873 | 2021-12-29 | Moody | South Dakota | 46101 | 979 | 25 |
2063145 | 2063145 | 2021-12-29 | McCulloch | Texas | 48307 | 979 | 40 |
2059895 | 2059895 | 2021-12-28 | McCulloch | Texas | 48307 | 979 | 40 |
2051374 | 2051374 | 2021-12-26 | Ohio | Indiana | 18115 | 979 | 14 |
2053340 | 2053340 | 2021-12-26 | Hartley | Texas | 48205 | 979 | 2 |
2048124 | 2048124 | 2021-12-25 | Ohio | Indiana | 18115 | 979 | 14 |
2049410 | 2049410 | 2021-12-25 | Sioux | North Dakota | 38085 | 979 | 18 |
2050090 | 2050090 | 2021-12-25 | Hartley | Texas | 48205 | 979 | 2 |
2044874 | 2044874 | 2021-12-24 | Ohio | Indiana | 18115 | 979 | 14 |
2046840 | 2046840 | 2021-12-24 | Hartley | Texas | 48205 | 979 | 2 |
2041625 | 2041625 | 2021-12-23 | Ohio | Indiana | 18115 | 979 | 14 |
2043590 | 2043590 | 2021-12-23 | Hartley | Texas | 48205 | 979 | 2 |
2038375 | 2038375 | 2021-12-22 | Ohio | Indiana | 18115 | 979 | 14 |
2035810 | 2035810 | 2021-12-21 | Jefferson | Mississippi | 28063 | 979 | 34 |
2018798 | 2018798 | 2021-12-16 | Stark | Illinois | 17175 | 979 | 29 |
1987220 | 1987220 | 2021-12-06 | Broadwater | Montana | 30007 | 979 | 17 |
1960591 | 1960591 | 2021-11-28 | Stevens | Kansas | 20189 | 979 | 15 |
1962609 | 1962609 | 2021-11-28 | Middlesex | Virginia | 51119 | 979 | 33 |
1957340 | 1957340 | 2021-11-27 | Stevens | Kansas | 20189 | 979 | 15 |
1959358 | 1959358 | 2021-11-27 | Middlesex | Virginia | 51119 | 979 | 33 |
1954089 | 1954089 | 2021-11-26 | Stevens | Kansas | 20189 | 979 | 15 |
1955140 | 1955140 | 2021-11-26 | Ransom | North Dakota | 38073 | 979 | 21 |
1956107 | 1956107 | 2021-11-26 | Middlesex | Virginia | 51119 | 979 | 33 |
1950838 | 1950838 | 2021-11-25 | Stevens | Kansas | 20189 | 979 | 15 |
1947587 | 1947587 | 2021-11-24 | Stevens | Kansas | 20189 | 979 | 15 |
1937331 | 1937331 | 2021-11-21 | Marion | Georgia | 13197 | 979 | 40 |
1934081 | 1934081 | 2021-11-20 | Marion | Georgia | 13197 | 979 | 40 |
1930829 | 1930829 | 2021-11-19 | Marion | Georgia | 13197 | 979 | 40 |
1927579 | 1927579 | 2021-11-18 | Marion | Georgia | 13197 | 979 | 39 |
1924329 | 1924329 | 2021-11-17 | Marion | Georgia | 13197 | 979 | 39 |
1921080 | 1921080 | 2021-11-16 | Marion | Georgia | 13197 | 979 | 39 |
1922338 | 1922338 | 2021-11-16 | Richardson | Nebraska | 31147 | 979 | 24 |
1917830 | 1917830 | 2021-11-15 | Marion | Georgia | 13197 | 979 | 39 |
1918725 | 1918725 | 2021-11-15 | Norman | Minnesota | 27107 | 979 | 9 |
1912874 | 1912874 | 2021-11-13 | McHenry | North Dakota | 38049 | 979 | 24 |
1897702 | 1897702 | 2021-11-08 | Calhoun | West Virginia | 54013 | 979 | 5 |
1892279 | 1892279 | 2021-11-07 | Greenwood | Kansas | 20073 | 979 | 14 |
1889029 | 1889029 | 2021-11-06 | Greenwood | Kansas | 20073 | 979 | 14 |
1885779 | 1885779 | 2021-11-05 | Greenwood | Kansas | 20073 | 979 | 14 |
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);