ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
574 rows where cases = 828 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 87
- Texas 42
- Georgia 34
- Iowa 34
- Oklahoma 26
- Kansas 25
- Virginia 25
- Arkansas 24
- Missouri 20
- Montana 18
- Nebraska 17
- Idaho 16
- Mississippi 14
- South Dakota 13
- Colorado 12
- Puerto Rico 12
- Kentucky 11
- Minnesota 11
- Illinois 10
- Tennessee 10
- Ohio 9
- Louisiana 8
- Michigan 8
- West Virginia 8
- Indiana 7
- South Carolina 7
- Nevada 6
- New Jersey 6
- New York 6
- North Carolina 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501591 | 2501591 | 2022-05-13 | Bowman | North Dakota | 38011 | 828 | 9 |
2501606 | 2501606 | 2022-05-13 | Hettinger | North Dakota | 38041 | 828 | 8 |
2498333 | 2498333 | 2022-05-12 | Bowman | North Dakota | 38011 | 828 | 9 |
2498348 | 2498348 | 2022-05-12 | Hettinger | North Dakota | 38041 | 828 | 8 |
2495075 | 2495075 | 2022-05-11 | Bowman | North Dakota | 38011 | 828 | 9 |
2495090 | 2495090 | 2022-05-11 | Hettinger | North Dakota | 38041 | 828 | 8 |
2491817 | 2491817 | 2022-05-10 | Bowman | North Dakota | 38011 | 828 | 9 |
2491832 | 2491832 | 2022-05-10 | Hettinger | North Dakota | 38041 | 828 | 8 |
2488559 | 2488559 | 2022-05-09 | Bowman | North Dakota | 38011 | 828 | 9 |
2488574 | 2488574 | 2022-05-09 | Hettinger | North Dakota | 38041 | 828 | 8 |
2485302 | 2485302 | 2022-05-08 | Bowman | North Dakota | 38011 | 828 | 9 |
2485317 | 2485317 | 2022-05-08 | Hettinger | North Dakota | 38041 | 828 | 8 |
2482044 | 2482044 | 2022-05-07 | Bowman | North Dakota | 38011 | 828 | 9 |
2482059 | 2482059 | 2022-05-07 | Hettinger | North Dakota | 38041 | 828 | 8 |
2478786 | 2478786 | 2022-05-06 | Bowman | North Dakota | 38011 | 828 | 9 |
2478801 | 2478801 | 2022-05-06 | Hettinger | North Dakota | 38041 | 828 | 8 |
2475528 | 2475528 | 2022-05-05 | Bowman | North Dakota | 38011 | 828 | 9 |
2475543 | 2475543 | 2022-05-05 | Hettinger | North Dakota | 38041 | 828 | 8 |
2472271 | 2472271 | 2022-05-04 | Bowman | North Dakota | 38011 | 828 | 9 |
2472286 | 2472286 | 2022-05-04 | Hettinger | North Dakota | 38041 | 828 | 8 |
2469015 | 2469015 | 2022-05-03 | Bowman | North Dakota | 38011 | 828 | 9 |
2469030 | 2469030 | 2022-05-03 | Hettinger | North Dakota | 38041 | 828 | 8 |
2465759 | 2465759 | 2022-05-02 | Bowman | North Dakota | 38011 | 828 | 9 |
2465774 | 2465774 | 2022-05-02 | Hettinger | North Dakota | 38041 | 828 | 8 |
2462504 | 2462504 | 2022-05-01 | Bowman | North Dakota | 38011 | 828 | 9 |
2462519 | 2462519 | 2022-05-01 | Hettinger | North Dakota | 38041 | 828 | 8 |
2459248 | 2459248 | 2022-04-30 | Bowman | North Dakota | 38011 | 828 | 9 |
2459263 | 2459263 | 2022-04-30 | Hettinger | North Dakota | 38041 | 828 | 8 |
2455992 | 2455992 | 2022-04-29 | Bowman | North Dakota | 38011 | 828 | 9 |
2456007 | 2456007 | 2022-04-29 | Hettinger | North Dakota | 38041 | 828 | 8 |
2452736 | 2452736 | 2022-04-28 | Bowman | North Dakota | 38011 | 828 | 9 |
2449480 | 2449480 | 2022-04-27 | Bowman | North Dakota | 38011 | 828 | 9 |
2446223 | 2446223 | 2022-04-26 | Bowman | North Dakota | 38011 | 828 | 9 |
2442968 | 2442968 | 2022-04-25 | Bowman | North Dakota | 38011 | 828 | 9 |
2439712 | 2439712 | 2022-04-24 | Bowman | North Dakota | 38011 | 828 | 9 |
2436456 | 2436456 | 2022-04-23 | Bowman | North Dakota | 38011 | 828 | 9 |
2433200 | 2433200 | 2022-04-22 | Bowman | North Dakota | 38011 | 828 | 9 |
2429944 | 2429944 | 2022-04-21 | Bowman | North Dakota | 38011 | 828 | 9 |
2426688 | 2426688 | 2022-04-20 | Bowman | North Dakota | 38011 | 828 | 9 |
2423432 | 2423432 | 2022-04-19 | Bowman | North Dakota | 38011 | 828 | 9 |
2420175 | 2420175 | 2022-04-18 | Bowman | North Dakota | 38011 | 828 | 9 |
2416920 | 2416920 | 2022-04-17 | Bowman | North Dakota | 38011 | 828 | 9 |
2413664 | 2413664 | 2022-04-16 | Bowman | North Dakota | 38011 | 828 | 9 |
2410408 | 2410408 | 2022-04-15 | Bowman | North Dakota | 38011 | 828 | 9 |
2407152 | 2407152 | 2022-04-14 | Bowman | North Dakota | 38011 | 828 | 9 |
2407167 | 2407167 | 2022-04-14 | Hettinger | North Dakota | 38041 | 828 | 8 |
2403896 | 2403896 | 2022-04-13 | Bowman | North Dakota | 38011 | 828 | 9 |
2403911 | 2403911 | 2022-04-13 | Hettinger | North Dakota | 38041 | 828 | 8 |
2400641 | 2400641 | 2022-04-12 | Bowman | North Dakota | 38011 | 828 | 9 |
2400656 | 2400656 | 2022-04-12 | Hettinger | North Dakota | 38041 | 828 | 8 |
2397386 | 2397386 | 2022-04-11 | Bowman | North Dakota | 38011 | 828 | 9 |
2397401 | 2397401 | 2022-04-11 | Hettinger | North Dakota | 38041 | 828 | 8 |
2394131 | 2394131 | 2022-04-10 | Bowman | North Dakota | 38011 | 828 | 9 |
2394146 | 2394146 | 2022-04-10 | Hettinger | North Dakota | 38041 | 828 | 8 |
2390875 | 2390875 | 2022-04-09 | Bowman | North Dakota | 38011 | 828 | 9 |
2390890 | 2390890 | 2022-04-09 | Hettinger | North Dakota | 38041 | 828 | 8 |
2387619 | 2387619 | 2022-04-08 | Bowman | North Dakota | 38011 | 828 | 9 |
2387634 | 2387634 | 2022-04-08 | Hettinger | North Dakota | 38041 | 828 | 8 |
2384364 | 2384364 | 2022-04-07 | Bowman | North Dakota | 38011 | 828 | 9 |
2384379 | 2384379 | 2022-04-07 | Hettinger | North Dakota | 38041 | 828 | 8 |
2381109 | 2381109 | 2022-04-06 | Bowman | North Dakota | 38011 | 828 | 9 |
2381124 | 2381124 | 2022-04-06 | Hettinger | North Dakota | 38041 | 828 | 8 |
2377854 | 2377854 | 2022-04-05 | Bowman | North Dakota | 38011 | 828 | 9 |
2377869 | 2377869 | 2022-04-05 | Hettinger | North Dakota | 38041 | 828 | 8 |
2374601 | 2374601 | 2022-04-04 | Bowman | North Dakota | 38011 | 828 | 9 |
2374616 | 2374616 | 2022-04-04 | Hettinger | North Dakota | 38041 | 828 | 8 |
2371349 | 2371349 | 2022-04-03 | Bowman | North Dakota | 38011 | 828 | 9 |
2371364 | 2371364 | 2022-04-03 | Hettinger | North Dakota | 38041 | 828 | 8 |
2368096 | 2368096 | 2022-04-02 | Bowman | North Dakota | 38011 | 828 | 9 |
2368111 | 2368111 | 2022-04-02 | Hettinger | North Dakota | 38041 | 828 | 8 |
2364843 | 2364843 | 2022-04-01 | Bowman | North Dakota | 38011 | 828 | 9 |
2364858 | 2364858 | 2022-04-01 | Hettinger | North Dakota | 38041 | 828 | 8 |
2312790 | 2312790 | 2022-03-16 | Bowman | North Dakota | 38011 | 828 | 9 |
2309537 | 2309537 | 2022-03-15 | Bowman | North Dakota | 38011 | 828 | 9 |
2306284 | 2306284 | 2022-03-14 | Bowman | North Dakota | 38011 | 828 | 9 |
2303033 | 2303033 | 2022-03-13 | Bowman | North Dakota | 38011 | 828 | 9 |
2299781 | 2299781 | 2022-03-12 | Bowman | North Dakota | 38011 | 828 | 9 |
2296529 | 2296529 | 2022-03-11 | Bowman | North Dakota | 38011 | 828 | 9 |
2289418 | 2289418 | 2022-03-09 | Traverse | Minnesota | 27155 | 828 | 10 |
2286167 | 2286167 | 2022-03-08 | Traverse | Minnesota | 27155 | 828 | 10 |
2282915 | 2282915 | 2022-03-07 | Traverse | Minnesota | 27155 | 828 | 10 |
2260755 | 2260755 | 2022-02-28 | Bowman | North Dakota | 38011 | 828 | 9 |
2257504 | 2257504 | 2022-02-27 | Bowman | North Dakota | 38011 | 828 | 9 |
2254253 | 2254253 | 2022-02-26 | Bowman | North Dakota | 38011 | 828 | 9 |
2244356 | 2244356 | 2022-02-23 | Hamilton | New York | 36041 | 828 | 5 |
2238654 | 2238654 | 2022-02-21 | Coke | Texas | 48081 | 828 | 19 |
2233642 | 2233642 | 2022-02-20 | Chautauqua | Kansas | 20019 | 828 | 17 |
2235403 | 2235403 | 2022-02-20 | Coke | Texas | 48081 | 828 | 19 |
2230391 | 2230391 | 2022-02-19 | Chautauqua | Kansas | 20019 | 828 | 17 |
2232152 | 2232152 | 2022-02-19 | Coke | Texas | 48081 | 828 | 19 |
2227140 | 2227140 | 2022-02-18 | Chautauqua | Kansas | 20019 | 828 | 17 |
2223889 | 2223889 | 2022-02-17 | Chautauqua | Kansas | 20019 | 828 | 17 |
2220638 | 2220638 | 2022-02-16 | Chautauqua | Kansas | 20019 | 828 | 17 |
2216772 | 2216772 | 2022-02-15 | Ouray | Colorado | 8091 | 828 | 6 |
2217387 | 2217387 | 2022-02-15 | Chautauqua | Kansas | 20019 | 828 | 17 |
2214136 | 2214136 | 2022-02-14 | Chautauqua | Kansas | 20019 | 828 | 17 |
2164551 | 2164551 | 2022-01-30 | Calhoun | Arkansas | 5013 | 828 | 9 |
2161296 | 2161296 | 2022-01-29 | Calhoun | Arkansas | 5013 | 828 | 9 |
2158040 | 2158040 | 2022-01-28 | Calhoun | Arkansas | 5013 | 828 | 9 |
2146391 | 2146391 | 2022-01-24 | Sharkey | Mississippi | 28125 | 828 | 21 |
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);