ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where cases = 408 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 72
- Texas 55
- Georgia 50
- Montana 49
- Kentucky 37
- Kansas 35
- Missouri 35
- Nebraska 35
- Oklahoma 23
- South Dakota 21
- Alaska 20
- Minnesota 20
- Puerto Rico 19
- Arkansas 18
- Virginia 17
- Illinois 15
- Louisiana 15
- Michigan 15
- Tennessee 15
- Indiana 14
- Iowa 14
- North Carolina 12
- New York 11
- Pennsylvania 11
- Alabama 10
- Colorado 10
- Vermont 10
- Mississippi 9
- Ohio 9
- Washington 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2351460 | 2351460 | 2022-03-28 | Meagher | Montana | 30059 | 408 | 10 |
2348208 | 2348208 | 2022-03-27 | Meagher | Montana | 30059 | 408 | 10 |
2348273 | 2348273 | 2022-03-27 | Greeley | Nebraska | 31077 | 408 | 2 |
2344955 | 2344955 | 2022-03-26 | Meagher | Montana | 30059 | 408 | 10 |
2345020 | 2345020 | 2022-03-26 | Greeley | Nebraska | 31077 | 408 | 2 |
2341702 | 2341702 | 2022-03-25 | Meagher | Montana | 30059 | 408 | 10 |
2341767 | 2341767 | 2022-03-25 | Greeley | Nebraska | 31077 | 408 | 2 |
2338449 | 2338449 | 2022-03-24 | Meagher | Montana | 30059 | 408 | 10 |
2338514 | 2338514 | 2022-03-24 | Greeley | Nebraska | 31077 | 408 | 2 |
2335195 | 2335195 | 2022-03-23 | Meagher | Montana | 30059 | 408 | 10 |
2335260 | 2335260 | 2022-03-23 | Greeley | Nebraska | 31077 | 408 | 2 |
2331941 | 2331941 | 2022-03-22 | Meagher | Montana | 30059 | 408 | 10 |
2332006 | 2332006 | 2022-03-22 | Greeley | Nebraska | 31077 | 408 | 2 |
2328688 | 2328688 | 2022-03-21 | Meagher | Montana | 30059 | 408 | 10 |
2328753 | 2328753 | 2022-03-21 | Greeley | Nebraska | 31077 | 408 | 2 |
2325436 | 2325436 | 2022-03-20 | Meagher | Montana | 30059 | 408 | 10 |
2325501 | 2325501 | 2022-03-20 | Greeley | Nebraska | 31077 | 408 | 2 |
2322182 | 2322182 | 2022-03-19 | Meagher | Montana | 30059 | 408 | 10 |
2322247 | 2322247 | 2022-03-19 | Greeley | Nebraska | 31077 | 408 | 2 |
2318928 | 2318928 | 2022-03-18 | Meagher | Montana | 30059 | 408 | 10 |
2318993 | 2318993 | 2022-03-18 | Greeley | Nebraska | 31077 | 408 | 2 |
2315675 | 2315675 | 2022-03-17 | Meagher | Montana | 30059 | 408 | 10 |
2315740 | 2315740 | 2022-03-17 | Greeley | Nebraska | 31077 | 408 | 2 |
2312422 | 2312422 | 2022-03-16 | Meagher | Montana | 30059 | 408 | 10 |
2312487 | 2312487 | 2022-03-16 | Greeley | Nebraska | 31077 | 408 | 2 |
2309169 | 2309169 | 2022-03-15 | Meagher | Montana | 30059 | 408 | 10 |
2305917 | 2305917 | 2022-03-14 | Meagher | Montana | 30059 | 408 | 10 |
2302666 | 2302666 | 2022-03-13 | Meagher | Montana | 30059 | 408 | 10 |
2299414 | 2299414 | 2022-03-12 | Meagher | Montana | 30059 | 408 | 10 |
2296162 | 2296162 | 2022-03-11 | Meagher | Montana | 30059 | 408 | 10 |
2292910 | 2292910 | 2022-03-10 | Meagher | Montana | 30059 | 408 | 10 |
2289658 | 2289658 | 2022-03-09 | Meagher | Montana | 30059 | 408 | 10 |
2286406 | 2286406 | 2022-03-08 | Meagher | Montana | 30059 | 408 | 10 |
2283154 | 2283154 | 2022-03-07 | Meagher | Montana | 30059 | 408 | 10 |
2279901 | 2279901 | 2022-03-06 | Meagher | Montana | 30059 | 408 | 10 |
2276648 | 2276648 | 2022-03-05 | Meagher | Montana | 30059 | 408 | 10 |
2273395 | 2273395 | 2022-03-04 | Meagher | Montana | 30059 | 408 | 10 |
2269437 | 2269437 | 2022-03-03 | Hodgeman | Kansas | 20083 | 408 | 10 |
2266184 | 2266184 | 2022-03-02 | Hodgeman | Kansas | 20083 | 408 | 10 |
2262503 | 2262503 | 2022-03-01 | Quitman | Georgia | 13239 | 408 | 4 |
2259252 | 2259252 | 2022-02-28 | Quitman | Georgia | 13239 | 408 | 4 |
2260453 | 2260453 | 2022-02-28 | Greeley | Nebraska | 31077 | 408 | 2 |
2256001 | 2256001 | 2022-02-27 | Quitman | Georgia | 13239 | 408 | 4 |
2252750 | 2252750 | 2022-02-26 | Quitman | Georgia | 13239 | 408 | 4 |
2249499 | 2249499 | 2022-02-25 | Quitman | Georgia | 13239 | 408 | 4 |
2246248 | 2246248 | 2022-02-24 | Quitman | Georgia | 13239 | 408 | 4 |
2246678 | 2246678 | 2022-02-24 | Hodgeman | Kansas | 20083 | 408 | 10 |
2242997 | 2242997 | 2022-02-23 | Quitman | Georgia | 13239 | 408 | 4 |
2243427 | 2243427 | 2022-02-23 | Hodgeman | Kansas | 20083 | 408 | 10 |
2244989 | 2244989 | 2022-02-23 | Jerauld | South Dakota | 46073 | 408 | 20 |
2239746 | 2239746 | 2022-02-22 | Quitman | Georgia | 13239 | 408 | 4 |
2240176 | 2240176 | 2022-02-22 | Hodgeman | Kansas | 20083 | 408 | 10 |
2236495 | 2236495 | 2022-02-21 | Quitman | Georgia | 13239 | 408 | 4 |
2236925 | 2236925 | 2022-02-21 | Hodgeman | Kansas | 20083 | 408 | 10 |
2233674 | 2233674 | 2022-02-20 | Hodgeman | Kansas | 20083 | 408 | 10 |
2230423 | 2230423 | 2022-02-19 | Hodgeman | Kansas | 20083 | 408 | 10 |
2227172 | 2227172 | 2022-02-18 | Hodgeman | Kansas | 20083 | 408 | 10 |
2223491 | 2223491 | 2022-02-17 | Quitman | Georgia | 13239 | 408 | 4 |
2220240 | 2220240 | 2022-02-16 | Quitman | Georgia | 13239 | 408 | 4 |
2216989 | 2216989 | 2022-02-15 | Quitman | Georgia | 13239 | 408 | 4 |
2213738 | 2213738 | 2022-02-14 | Quitman | Georgia | 13239 | 408 | 4 |
2186640 | 2186640 | 2022-02-05 | Dickens | Texas | 48125 | 408 | 15 |
2166945 | 2166945 | 2022-01-30 | McPherson | South Dakota | 46089 | 408 | 9 |
2163690 | 2163690 | 2022-01-29 | McPherson | South Dakota | 46089 | 408 | 9 |
2160435 | 2160435 | 2022-01-28 | McPherson | South Dakota | 46089 | 408 | 9 |
2146925 | 2146925 | 2022-01-24 | Burke | North Dakota | 38013 | 408 | 3 |
2146930 | 2146930 | 2022-01-24 | Divide | North Dakota | 38023 | 408 | 4 |
2143671 | 2143671 | 2022-01-23 | Burke | North Dakota | 38013 | 408 | 3 |
2143676 | 2143676 | 2022-01-23 | Divide | North Dakota | 38023 | 408 | 4 |
2140421 | 2140421 | 2022-01-22 | Divide | North Dakota | 38023 | 408 | 4 |
2141053 | 2141053 | 2022-01-22 | Briscoe | Texas | 48045 | 408 | 8 |
2121717 | 2121717 | 2022-01-16 | Schleicher | Texas | 48413 | 408 | 9 |
2117655 | 2117655 | 2022-01-15 | Golden Valley | North Dakota | 38033 | 408 | 4 |
2115145 | 2115145 | 2022-01-14 | Knox | Texas | 48275 | 408 | 22 |
2108641 | 2108641 | 2022-01-12 | Knox | Texas | 48275 | 408 | 22 |
2105390 | 2105390 | 2022-01-11 | Knox | Texas | 48275 | 408 | 22 |
2081893 | 2081893 | 2022-01-04 | Kidder | North Dakota | 38043 | 408 | 13 |
2076168 | 2076168 | 2022-01-02 | Oldham | Texas | 48359 | 408 | 6 |
2072917 | 2072917 | 2022-01-01 | Oldham | Texas | 48359 | 408 | 6 |
2069666 | 2069666 | 2021-12-31 | Oldham | Texas | 48359 | 408 | 6 |
2066415 | 2066415 | 2021-12-30 | Oldham | Texas | 48359 | 408 | 6 |
2063165 | 2063165 | 2021-12-29 | Oldham | Texas | 48359 | 408 | 6 |
2059915 | 2059915 | 2021-12-28 | Oldham | Texas | 48359 | 408 | 6 |
2056666 | 2056666 | 2021-12-27 | Oldham | Texas | 48359 | 408 | 6 |
2034180 | 2034180 | 2021-12-20 | Columbia | Washington | 53013 | 408 | 9 |
2030930 | 2030930 | 2021-12-19 | Columbia | Washington | 53013 | 408 | 9 |
2027679 | 2027679 | 2021-12-18 | Columbia | Washington | 53013 | 408 | 9 |
2024428 | 2024428 | 2021-12-17 | Columbia | Washington | 53013 | 408 | 9 |
2010036 | 2010036 | 2021-12-13 | Brown | Nebraska | 31017 | 408 | 4 |
2006208 | 2006208 | 2021-12-12 | Robertson | Kentucky | 21201 | 408 | 16 |
2002957 | 2002957 | 2021-12-11 | Robertson | Kentucky | 21201 | 408 | 16 |
1999707 | 1999707 | 2021-12-10 | Robertson | Kentucky | 21201 | 408 | 16 |
1996456 | 1996456 | 2021-12-09 | Robertson | Kentucky | 21201 | 408 | 16 |
1998035 | 1998035 | 2021-12-09 | Culberson | Texas | 48109 | 408 | 11 |
1994784 | 1994784 | 2021-12-08 | Culberson | Texas | 48109 | 408 | 11 |
1990590 | 1990590 | 2021-12-07 | Perkins | Nebraska | 31135 | 408 | 12 |
1991533 | 1991533 | 2021-12-07 | Culberson | Texas | 48109 | 408 | 11 |
1987340 | 1987340 | 2021-12-06 | Perkins | Nebraska | 31135 | 408 | 12 |
1988282 | 1988282 | 2021-12-06 | Culberson | Texas | 48109 | 408 | 11 |
1983986 | 1983986 | 2021-12-05 | Granite | Montana | 30039 | 408 | 6 |
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);