ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,756 rows where deaths = 64 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 50
- Texas 602
- Georgia 583
- Kentucky 423
- Missouri 381
- Tennessee 371
- Virginia 332
- Mississippi 316
- Ohio 303
- Alabama 290
- North Carolina 286
- Indiana 282
- Michigan 246
- Louisiana 237
- Arkansas 222
- Minnesota 219
- South Carolina 194
- Illinois 191
- Iowa 188
- West Virginia 178
- Oklahoma 172
- New York 161
- Wisconsin 161
- Washington 152
- California 142
- Florida 127
- Oregon 123
- Pennsylvania 101
- Kansas 92
- New Mexico 88
- Colorado 82
- Maryland 80
- Nebraska 64
- Idaho 58
- South Dakota 52
- Montana 47
- Utah 29
- Arizona 27
- Connecticut 25
- New Hampshire 21
- Wyoming 20
- Maine 18
- North Dakota 17
- Rhode Island 15
- Nevada 11
- New Jersey 10
- Massachusetts 5
- Alaska 4
- Guam 3
- Vermont 3
- Hawaii 2
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500166 | 2500166 | 2022-05-13 | Minidoka | Idaho | 16067 | 4235 | 64 |
2500638 | 2500638 | 2022-05-13 | Knott | Kentucky | 21119 | 4233 | 64 |
2500663 | 2500663 | 2022-05-13 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2500763 | 2500763 | 2022-05-13 | Winn | Louisiana | 22127 | 4452 | 64 |
2501048 | 2501048 | 2022-05-13 | Perry | Mississippi | 28111 | 3048 | 64 |
2501560 | 2501560 | 2022-05-13 | Polk | North Carolina | 37149 | 3918 | 64 |
2501744 | 2501744 | 2022-05-13 | Choctaw | Oklahoma | 40023 | 4056 | 64 |
2501839 | 2501839 | 2022-05-13 | Tillamook | Oregon | 41057 | 3827 | 64 |
2502090 | 2502090 | 2022-05-13 | Meade | South Dakota | 46093 | 7042 | 64 |
2502251 | 2502251 | 2022-05-13 | Colorado | Texas | 48089 | 3808 | 64 |
2502761 | 2502761 | 2022-05-13 | Green Lake | Wisconsin | 55047 | 5268 | 64 |
2496908 | 2496908 | 2022-05-12 | Minidoka | Idaho | 16067 | 4234 | 64 |
2497380 | 2497380 | 2022-05-12 | Knott | Kentucky | 21119 | 4233 | 64 |
2497405 | 2497405 | 2022-05-12 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2497505 | 2497505 | 2022-05-12 | Winn | Louisiana | 22127 | 4450 | 64 |
2497790 | 2497790 | 2022-05-12 | Perry | Mississippi | 28111 | 3048 | 64 |
2497877 | 2497877 | 2022-05-12 | Linn | Missouri | 29115 | 2554 | 64 |
2498302 | 2498302 | 2022-05-12 | Polk | North Carolina | 37149 | 3918 | 64 |
2498486 | 2498486 | 2022-05-12 | Choctaw | Oklahoma | 40023 | 4056 | 64 |
2498581 | 2498581 | 2022-05-12 | Tillamook | Oregon | 41057 | 3819 | 64 |
2498832 | 2498832 | 2022-05-12 | Meade | South Dakota | 46093 | 7042 | 64 |
2498993 | 2498993 | 2022-05-12 | Colorado | Texas | 48089 | 3807 | 64 |
2499338 | 2499338 | 2022-05-12 | Northampton | Virginia | 51131 | 2182 | 64 |
2499503 | 2499503 | 2022-05-12 | Green Lake | Wisconsin | 55047 | 5260 | 64 |
2493650 | 2493650 | 2022-05-11 | Minidoka | Idaho | 16067 | 4234 | 64 |
2494122 | 2494122 | 2022-05-11 | Knott | Kentucky | 21119 | 4233 | 64 |
2494147 | 2494147 | 2022-05-11 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2494247 | 2494247 | 2022-05-11 | Winn | Louisiana | 22127 | 4447 | 64 |
2494433 | 2494433 | 2022-05-11 | Martin | Minnesota | 27091 | 5671 | 64 |
2494532 | 2494532 | 2022-05-11 | Perry | Mississippi | 28111 | 3048 | 64 |
2494619 | 2494619 | 2022-05-11 | Linn | Missouri | 29115 | 2554 | 64 |
2495044 | 2495044 | 2022-05-11 | Polk | North Carolina | 37149 | 3918 | 64 |
2495228 | 2495228 | 2022-05-11 | Choctaw | Oklahoma | 40023 | 4056 | 64 |
2495323 | 2495323 | 2022-05-11 | Tillamook | Oregon | 41057 | 3811 | 64 |
2495574 | 2495574 | 2022-05-11 | Meade | South Dakota | 46093 | 7042 | 64 |
2495735 | 2495735 | 2022-05-11 | Colorado | Texas | 48089 | 3806 | 64 |
2496080 | 2496080 | 2022-05-11 | Northampton | Virginia | 51131 | 2182 | 64 |
2496245 | 2496245 | 2022-05-11 | Green Lake | Wisconsin | 55047 | 5248 | 64 |
2490392 | 2490392 | 2022-05-10 | Minidoka | Idaho | 16067 | 4233 | 64 |
2490864 | 2490864 | 2022-05-10 | Knott | Kentucky | 21119 | 4233 | 64 |
2490889 | 2490889 | 2022-05-10 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2490989 | 2490989 | 2022-05-10 | Winn | Louisiana | 22127 | 4445 | 64 |
2491175 | 2491175 | 2022-05-10 | Martin | Minnesota | 27091 | 5670 | 64 |
2491274 | 2491274 | 2022-05-10 | Perry | Mississippi | 28111 | 3048 | 64 |
2491361 | 2491361 | 2022-05-10 | Linn | Missouri | 29115 | 2554 | 64 |
2491786 | 2491786 | 2022-05-10 | Polk | North Carolina | 37149 | 3906 | 64 |
2491970 | 2491970 | 2022-05-10 | Choctaw | Oklahoma | 40023 | 4056 | 64 |
2492065 | 2492065 | 2022-05-10 | Tillamook | Oregon | 41057 | 3805 | 64 |
2492316 | 2492316 | 2022-05-10 | Meade | South Dakota | 46093 | 7027 | 64 |
2492477 | 2492477 | 2022-05-10 | Colorado | Texas | 48089 | 3806 | 64 |
2492822 | 2492822 | 2022-05-10 | Northampton | Virginia | 51131 | 2181 | 64 |
2493025 | 2493025 | 2022-05-10 | Trempealeau | Wisconsin | 55121 | 8517 | 64 |
2487135 | 2487135 | 2022-05-09 | Minidoka | Idaho | 16067 | 4233 | 64 |
2487607 | 2487607 | 2022-05-09 | Knott | Kentucky | 21119 | 4233 | 64 |
2487632 | 2487632 | 2022-05-09 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2487732 | 2487732 | 2022-05-09 | Winn | Louisiana | 22127 | 4444 | 64 |
2487918 | 2487918 | 2022-05-09 | Martin | Minnesota | 27091 | 5659 | 64 |
2488017 | 2488017 | 2022-05-09 | Perry | Mississippi | 28111 | 3048 | 64 |
2488103 | 2488103 | 2022-05-09 | Linn | Missouri | 29115 | 2554 | 64 |
2488528 | 2488528 | 2022-05-09 | Polk | North Carolina | 37149 | 3906 | 64 |
2488712 | 2488712 | 2022-05-09 | Choctaw | Oklahoma | 40023 | 4056 | 64 |
2488807 | 2488807 | 2022-05-09 | Tillamook | Oregon | 41057 | 3800 | 64 |
2489058 | 2489058 | 2022-05-09 | Meade | South Dakota | 46093 | 7027 | 64 |
2489219 | 2489219 | 2022-05-09 | Colorado | Texas | 48089 | 3806 | 64 |
2489564 | 2489564 | 2022-05-09 | Northampton | Virginia | 51131 | 2181 | 64 |
2489767 | 2489767 | 2022-05-09 | Trempealeau | Wisconsin | 55121 | 8513 | 64 |
2484349 | 2484349 | 2022-05-08 | Knott | Kentucky | 21119 | 4229 | 64 |
2484374 | 2484374 | 2022-05-08 | Metcalfe | Kentucky | 21169 | 2872 | 64 |
2484474 | 2484474 | 2022-05-08 | Winn | Louisiana | 22127 | 4444 | 64 |
2484660 | 2484660 | 2022-05-08 | Martin | Minnesota | 27091 | 5657 | 64 |
2484759 | 2484759 | 2022-05-08 | Perry | Mississippi | 28111 | 3043 | 64 |
2484846 | 2484846 | 2022-05-08 | Linn | Missouri | 29115 | 2554 | 64 |
2485271 | 2485271 | 2022-05-08 | Polk | North Carolina | 37149 | 3906 | 64 |
2485455 | 2485455 | 2022-05-08 | Choctaw | Oklahoma | 40023 | 4056 | 64 |
2485550 | 2485550 | 2022-05-08 | Tillamook | Oregon | 41057 | 3792 | 64 |
2485801 | 2485801 | 2022-05-08 | Meade | South Dakota | 46093 | 7027 | 64 |
2485962 | 2485962 | 2022-05-08 | Colorado | Texas | 48089 | 3806 | 64 |
2486307 | 2486307 | 2022-05-08 | Northampton | Virginia | 51131 | 2172 | 64 |
2486510 | 2486510 | 2022-05-08 | Trempealeau | Wisconsin | 55121 | 8500 | 64 |
2481091 | 2481091 | 2022-05-07 | Knott | Kentucky | 21119 | 4229 | 64 |
2481116 | 2481116 | 2022-05-07 | Metcalfe | Kentucky | 21169 | 2872 | 64 |
2481216 | 2481216 | 2022-05-07 | Winn | Louisiana | 22127 | 4444 | 64 |
2481402 | 2481402 | 2022-05-07 | Martin | Minnesota | 27091 | 5657 | 64 |
2481501 | 2481501 | 2022-05-07 | Perry | Mississippi | 28111 | 3043 | 64 |
2481588 | 2481588 | 2022-05-07 | Linn | Missouri | 29115 | 2554 | 64 |
2481851 | 2481851 | 2022-05-07 | Colfax | New Mexico | 35007 | 2707 | 64 |
2482013 | 2482013 | 2022-05-07 | Polk | North Carolina | 37149 | 3906 | 64 |
2482197 | 2482197 | 2022-05-07 | Choctaw | Oklahoma | 40023 | 4056 | 64 |
2482292 | 2482292 | 2022-05-07 | Tillamook | Oregon | 41057 | 3792 | 64 |
2482543 | 2482543 | 2022-05-07 | Meade | South Dakota | 46093 | 7027 | 64 |
2482704 | 2482704 | 2022-05-07 | Colorado | Texas | 48089 | 3805 | 64 |
2483049 | 2483049 | 2022-05-07 | Northampton | Virginia | 51131 | 2172 | 64 |
2483252 | 2483252 | 2022-05-07 | Trempealeau | Wisconsin | 55121 | 8500 | 64 |
2477833 | 2477833 | 2022-05-06 | Knott | Kentucky | 21119 | 4229 | 64 |
2477858 | 2477858 | 2022-05-06 | Metcalfe | Kentucky | 21169 | 2872 | 64 |
2477958 | 2477958 | 2022-05-06 | Winn | Louisiana | 22127 | 4444 | 64 |
2478144 | 2478144 | 2022-05-06 | Martin | Minnesota | 27091 | 5657 | 64 |
2478243 | 2478243 | 2022-05-06 | Perry | Mississippi | 28111 | 3043 | 64 |
2478330 | 2478330 | 2022-05-06 | Linn | Missouri | 29115 | 2554 | 64 |
2478593 | 2478593 | 2022-05-06 | Colfax | New Mexico | 35007 | 2707 | 64 |
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);