ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
673 rows where cases = 570 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 97
- Texas 51
- North Dakota 37
- Georgia 32
- Oklahoma 29
- North Carolina 24
- Missouri 22
- South Dakota 22
- Virginia 22
- Alabama 20
- Kentucky 19
- Minnesota 18
- Nebraska 18
- Michigan 17
- Illinois 16
- Puerto Rico 16
- Colorado 14
- Mississippi 14
- Indiana 13
- Ohio 13
- Idaho 12
- California 11
- Montana 11
- Wisconsin 11
- Arkansas 10
- New Mexico 10
- Iowa 9
- Tennessee 8
- West Virginia 8
- Arizona 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474434 | 2474434 | 2022-05-05 | Elk | Kansas | 20049 | 570 | 10 |
2471177 | 2471177 | 2022-05-04 | Elk | Kansas | 20049 | 570 | 10 |
2467921 | 2467921 | 2022-05-03 | Elk | Kansas | 20049 | 570 | 10 |
2464666 | 2464666 | 2022-05-02 | Elk | Kansas | 20049 | 570 | 10 |
2461410 | 2461410 | 2022-05-01 | Elk | Kansas | 20049 | 570 | 10 |
2458154 | 2458154 | 2022-04-30 | Elk | Kansas | 20049 | 570 | 10 |
2454898 | 2454898 | 2022-04-29 | Elk | Kansas | 20049 | 570 | 10 |
2452065 | 2452065 | 2022-04-28 | Cook | Minnesota | 27031 | 570 | 4 |
2406058 | 2406058 | 2022-04-14 | Elk | Kansas | 20049 | 570 | 10 |
2402802 | 2402802 | 2022-04-13 | Elk | Kansas | 20049 | 570 | 10 |
2399548 | 2399548 | 2022-04-12 | Elk | Kansas | 20049 | 570 | 10 |
2396292 | 2396292 | 2022-04-11 | Elk | Kansas | 20049 | 570 | 10 |
2393037 | 2393037 | 2022-04-10 | Elk | Kansas | 20049 | 570 | 10 |
2389781 | 2389781 | 2022-04-09 | Elk | Kansas | 20049 | 570 | 10 |
2386525 | 2386525 | 2022-04-08 | Elk | Kansas | 20049 | 570 | 10 |
2383271 | 2383271 | 2022-04-07 | Elk | Kansas | 20049 | 570 | 10 |
2384378 | 2384378 | 2022-04-07 | Griggs | North Dakota | 38039 | 570 | 2 |
2380016 | 2380016 | 2022-04-06 | Elk | Kansas | 20049 | 570 | 10 |
2381123 | 2381123 | 2022-04-06 | Griggs | North Dakota | 38039 | 570 | 2 |
2381263 | 2381263 | 2022-04-06 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2376761 | 2376761 | 2022-04-05 | Elk | Kansas | 20049 | 570 | 10 |
2377868 | 2377868 | 2022-04-05 | Griggs | North Dakota | 38039 | 570 | 2 |
2378008 | 2378008 | 2022-04-05 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2373509 | 2373509 | 2022-04-04 | Elk | Kansas | 20049 | 570 | 10 |
2374615 | 2374615 | 2022-04-04 | Griggs | North Dakota | 38039 | 570 | 2 |
2374754 | 2374754 | 2022-04-04 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2370256 | 2370256 | 2022-04-03 | Elk | Kansas | 20049 | 570 | 10 |
2371363 | 2371363 | 2022-04-03 | Griggs | North Dakota | 38039 | 570 | 2 |
2371502 | 2371502 | 2022-04-03 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2367003 | 2367003 | 2022-04-02 | Elk | Kansas | 20049 | 570 | 10 |
2368110 | 2368110 | 2022-04-02 | Griggs | North Dakota | 38039 | 570 | 2 |
2368249 | 2368249 | 2022-04-02 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2363750 | 2363750 | 2022-04-01 | Elk | Kansas | 20049 | 570 | 10 |
2364857 | 2364857 | 2022-04-01 | Griggs | North Dakota | 38039 | 570 | 2 |
2364996 | 2364996 | 2022-04-01 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2360496 | 2360496 | 2022-03-31 | Elk | Kansas | 20049 | 570 | 9 |
2361603 | 2361603 | 2022-03-31 | Griggs | North Dakota | 38039 | 570 | 2 |
2361743 | 2361743 | 2022-03-31 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2357242 | 2357242 | 2022-03-30 | Elk | Kansas | 20049 | 570 | 9 |
2358349 | 2358349 | 2022-03-30 | Griggs | North Dakota | 38039 | 570 | 2 |
2353989 | 2353989 | 2022-03-29 | Elk | Kansas | 20049 | 570 | 9 |
2355095 | 2355095 | 2022-03-29 | Griggs | North Dakota | 38039 | 570 | 2 |
2350737 | 2350737 | 2022-03-28 | Elk | Kansas | 20049 | 570 | 9 |
2351842 | 2351842 | 2022-03-28 | Griggs | North Dakota | 38039 | 570 | 2 |
2347484 | 2347484 | 2022-03-27 | Elk | Kansas | 20049 | 570 | 9 |
2348590 | 2348590 | 2022-03-27 | Griggs | North Dakota | 38039 | 570 | 2 |
2344231 | 2344231 | 2022-03-26 | Elk | Kansas | 20049 | 570 | 9 |
2345337 | 2345337 | 2022-03-26 | Griggs | North Dakota | 38039 | 570 | 2 |
2340978 | 2340978 | 2022-03-25 | Elk | Kansas | 20049 | 570 | 9 |
2342084 | 2342084 | 2022-03-25 | Griggs | North Dakota | 38039 | 570 | 2 |
2337725 | 2337725 | 2022-03-24 | Elk | Kansas | 20049 | 570 | 9 |
2334471 | 2334471 | 2022-03-23 | Elk | Kansas | 20049 | 570 | 9 |
2335717 | 2335717 | 2022-03-23 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2331217 | 2331217 | 2022-03-22 | Elk | Kansas | 20049 | 570 | 8 |
2332463 | 2332463 | 2022-03-22 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2327965 | 2327965 | 2022-03-21 | Elk | Kansas | 20049 | 570 | 8 |
2329210 | 2329210 | 2022-03-21 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2324712 | 2324712 | 2022-03-20 | Elk | Kansas | 20049 | 570 | 8 |
2325614 | 2325614 | 2022-03-20 | De Baca | New Mexico | 35011 | 570 | 5 |
2325958 | 2325958 | 2022-03-20 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2321458 | 2321458 | 2022-03-19 | Elk | Kansas | 20049 | 570 | 8 |
2322360 | 2322360 | 2022-03-19 | De Baca | New Mexico | 35011 | 570 | 5 |
2322705 | 2322705 | 2022-03-19 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2318204 | 2318204 | 2022-03-18 | Elk | Kansas | 20049 | 570 | 8 |
2319106 | 2319106 | 2022-03-18 | De Baca | New Mexico | 35011 | 570 | 5 |
2319451 | 2319451 | 2022-03-18 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2315853 | 2315853 | 2022-03-17 | De Baca | New Mexico | 35011 | 570 | 5 |
2316197 | 2316197 | 2022-03-17 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2312600 | 2312600 | 2022-03-16 | De Baca | New Mexico | 35011 | 570 | 5 |
2309347 | 2309347 | 2022-03-15 | De Baca | New Mexico | 35011 | 570 | 5 |
2306094 | 2306094 | 2022-03-14 | De Baca | New Mexico | 35011 | 570 | 5 |
2269420 | 2269420 | 2022-03-03 | Elk | Kansas | 20049 | 570 | 8 |
2266167 | 2266167 | 2022-03-02 | Elk | Kansas | 20049 | 570 | 8 |
2218487 | 2218487 | 2022-02-15 | Adams | North Dakota | 38001 | 570 | 9 |
2196781 | 2196781 | 2022-02-08 | Columbia | Washington | 53013 | 570 | 13 |
2193526 | 2193526 | 2022-02-07 | Columbia | Washington | 53013 | 570 | 13 |
2178550 | 2178550 | 2022-02-03 | Robertson | Kentucky | 21201 | 570 | 21 |
2124168 | 2124168 | 2022-01-17 | McIntosh | North Dakota | 38051 | 570 | 9 |
2120916 | 2120916 | 2022-01-16 | McIntosh | North Dakota | 38051 | 570 | 9 |
2117664 | 2117664 | 2022-01-15 | McIntosh | North Dakota | 38051 | 570 | 9 |
2118041 | 2118041 | 2022-01-15 | Vieques | Puerto Rico | 72147 | 570 | |
2118406 | 2118406 | 2022-01-15 | Lipscomb | Texas | 48295 | 570 | 13 |
2115155 | 2115155 | 2022-01-14 | Lipscomb | Texas | 48295 | 570 | 13 |
2111161 | 2111161 | 2022-01-13 | McIntosh | North Dakota | 38051 | 570 | 9 |
2086440 | 2086440 | 2022-01-06 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 570 | 1 |
2086929 | 2086929 | 2022-01-06 | Adams | Idaho | 16003 | 570 | 14 |
2087962 | 2087962 | 2022-01-06 | Schuyler | Missouri | 29197 | 570 | 22 |
2085144 | 2085144 | 2022-01-05 | Hettinger | North Dakota | 38041 | 570 | 7 |
2080860 | 2080860 | 2022-01-04 | Trego | Kansas | 20195 | 570 | 9 |
2077608 | 2077608 | 2022-01-03 | Trego | Kansas | 20195 | 570 | 9 |
2075869 | 2075869 | 2022-01-02 | Marshall | South Dakota | 46091 | 570 | 8 |
2072618 | 2072618 | 2022-01-01 | Marshall | South Dakota | 46091 | 570 | 8 |
2069367 | 2069367 | 2021-12-31 | Marshall | South Dakota | 46091 | 570 | 8 |
2066116 | 2066116 | 2021-12-30 | Marshall | South Dakota | 46091 | 570 | 8 |
2057402 | 2057402 | 2021-12-28 | Ouray | Colorado | 8091 | 570 | 6 |
2040447 | 2040447 | 2021-12-22 | Shackelford | Texas | 48417 | 570 | 8 |
2037197 | 2037197 | 2021-12-21 | Shackelford | Texas | 48417 | 570 | 8 |
2023701 | 2023701 | 2021-12-17 | Arroyo | Puerto Rico | 72015 | 570 | |
2013367 | 2013367 | 2021-12-14 | Valley | Nebraska | 31175 | 570 | 5 |
2010833 | 2010833 | 2021-12-13 | Clark | South Dakota | 46025 | 570 | 5 |
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);