ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,955 rows where deaths = 104 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 48
- Mississippi 355
- North Carolina 352
- Texas 338
- Illinois 298
- Tennessee 268
- Georgia 266
- Virginia 239
- Arkansas 204
- Ohio 201
- Oklahoma 198
- Kentucky 184
- Indiana 178
- New York 160
- Pennsylvania 151
- Minnesota 142
- Missouri 131
- Louisiana 122
- Florida 115
- Michigan 114
- Alabama 95
- West Virginia 81
- South Carolina 79
- California 75
- Wisconsin 74
- Kansas 65
- Iowa 42
- Montana 42
- Washington 42
- Maryland 34
- Colorado 32
- New Mexico 32
- Oregon 32
- North Dakota 29
- Vermont 27
- New Hampshire 26
- Maine 25
- Utah 15
- Nebraska 14
- Alaska 13
- Arizona 11
- Idaho 10
- Massachusetts 10
- Rhode Island 9
- Connecticut 8
- New Jersey 8
- Hawaii 4
- South Dakota 3
- Guam 2
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499726 | 2499726 | 2022-05-13 | Little River | Arkansas | 5081 | 3281 | 104 |
2499737 | 2499737 | 2022-05-13 | Ouachita | Arkansas | 5103 | 5484 | 104 |
2500024 | 2500024 | 2022-05-13 | Franklin | Georgia | 13119 | 5414 | 104 |
2500202 | 2500202 | 2022-05-13 | Fayette | Illinois | 17051 | 7155 | 104 |
2500836 | 2500836 | 2022-05-13 | Cheboygan | Michigan | 26031 | 4760 | 104 |
2501018 | 2501018 | 2022-05-13 | Holmes | Mississippi | 28051 | 4455 | 104 |
2501073 | 2501073 | 2022-05-13 | Winston | Mississippi | 28159 | 5231 | 104 |
2501103 | 2501103 | 2022-05-13 | Crawford | Missouri | 29055 | 5422 | 104 |
2501515 | 2501515 | 2022-05-13 | Davie | North Carolina | 37059 | 11315 | 104 |
2501876 | 2501876 | 2022-05-13 | Greene | Pennsylvania | 42059 | 8513 | 104 |
2502415 | 2502415 | 2022-05-13 | Scurry | Texas | 48415 | 4983 | 104 |
2502559 | 2502559 | 2022-05-13 | Gloucester | Virginia | 51073 | 7453 | 104 |
2502687 | 2502687 | 2022-05-13 | Brooke | West Virginia | 54009 | 5082 | 104 |
2496468 | 2496468 | 2022-05-12 | Little River | Arkansas | 5081 | 3280 | 104 |
2496479 | 2496479 | 2022-05-12 | Ouachita | Arkansas | 5103 | 5483 | 104 |
2496766 | 2496766 | 2022-05-12 | Franklin | Georgia | 13119 | 5414 | 104 |
2496944 | 2496944 | 2022-05-12 | Fayette | Illinois | 17051 | 7151 | 104 |
2497578 | 2497578 | 2022-05-12 | Cheboygan | Michigan | 26031 | 4760 | 104 |
2497760 | 2497760 | 2022-05-12 | Holmes | Mississippi | 28051 | 4455 | 104 |
2497815 | 2497815 | 2022-05-12 | Winston | Mississippi | 28159 | 5231 | 104 |
2498257 | 2498257 | 2022-05-12 | Davie | North Carolina | 37059 | 11315 | 104 |
2498618 | 2498618 | 2022-05-12 | Greene | Pennsylvania | 42059 | 8513 | 104 |
2499157 | 2499157 | 2022-05-12 | Scurry | Texas | 48415 | 4977 | 104 |
2499301 | 2499301 | 2022-05-12 | Gloucester | Virginia | 51073 | 7446 | 104 |
2499429 | 2499429 | 2022-05-12 | Brooke | West Virginia | 54009 | 5080 | 104 |
2493062 | 2493062 | 2022-05-11 | Bibb | Alabama | 1007 | 6453 | 104 |
2493210 | 2493210 | 2022-05-11 | Little River | Arkansas | 5081 | 3280 | 104 |
2493221 | 2493221 | 2022-05-11 | Ouachita | Arkansas | 5103 | 5481 | 104 |
2493508 | 2493508 | 2022-05-11 | Franklin | Georgia | 13119 | 5414 | 104 |
2493686 | 2493686 | 2022-05-11 | Fayette | Illinois | 17051 | 7150 | 104 |
2493722 | 2493722 | 2022-05-11 | McDonough | Illinois | 17109 | 7291 | 104 |
2494320 | 2494320 | 2022-05-11 | Cheboygan | Michigan | 26031 | 4760 | 104 |
2494502 | 2494502 | 2022-05-11 | Holmes | Mississippi | 28051 | 4455 | 104 |
2494557 | 2494557 | 2022-05-11 | Winston | Mississippi | 28159 | 5231 | 104 |
2494999 | 2494999 | 2022-05-11 | Davie | North Carolina | 37059 | 11315 | 104 |
2495360 | 2495360 | 2022-05-11 | Greene | Pennsylvania | 42059 | 8513 | 104 |
2495899 | 2495899 | 2022-05-11 | Scurry | Texas | 48415 | 4977 | 104 |
2496043 | 2496043 | 2022-05-11 | Gloucester | Virginia | 51073 | 7436 | 104 |
2496171 | 2496171 | 2022-05-11 | Brooke | West Virginia | 54009 | 5075 | 104 |
2489804 | 2489804 | 2022-05-10 | Bibb | Alabama | 1007 | 6450 | 104 |
2489952 | 2489952 | 2022-05-10 | Little River | Arkansas | 5081 | 3280 | 104 |
2489963 | 2489963 | 2022-05-10 | Ouachita | Arkansas | 5103 | 5479 | 104 |
2490428 | 2490428 | 2022-05-10 | Fayette | Illinois | 17051 | 7146 | 104 |
2490464 | 2490464 | 2022-05-10 | McDonough | Illinois | 17109 | 7281 | 104 |
2491244 | 2491244 | 2022-05-10 | Holmes | Mississippi | 28051 | 4455 | 104 |
2491299 | 2491299 | 2022-05-10 | Winston | Mississippi | 28159 | 5231 | 104 |
2491741 | 2491741 | 2022-05-10 | Davie | North Carolina | 37059 | 11252 | 104 |
2492102 | 2492102 | 2022-05-10 | Greene | Pennsylvania | 42059 | 8490 | 104 |
2492641 | 2492641 | 2022-05-10 | Scurry | Texas | 48415 | 4977 | 104 |
2492785 | 2492785 | 2022-05-10 | Gloucester | Virginia | 51073 | 7420 | 104 |
2492913 | 2492913 | 2022-05-10 | Brooke | West Virginia | 54009 | 5068 | 104 |
2486547 | 2486547 | 2022-05-09 | Bibb | Alabama | 1007 | 6447 | 104 |
2486695 | 2486695 | 2022-05-09 | Little River | Arkansas | 5081 | 3280 | 104 |
2486706 | 2486706 | 2022-05-09 | Ouachita | Arkansas | 5103 | 5478 | 104 |
2487171 | 2487171 | 2022-05-09 | Fayette | Illinois | 17051 | 7142 | 104 |
2487207 | 2487207 | 2022-05-09 | McDonough | Illinois | 17109 | 7276 | 104 |
2487987 | 2487987 | 2022-05-09 | Holmes | Mississippi | 28051 | 4455 | 104 |
2488041 | 2488041 | 2022-05-09 | Winston | Mississippi | 28159 | 5231 | 104 |
2488483 | 2488483 | 2022-05-09 | Davie | North Carolina | 37059 | 11252 | 104 |
2488844 | 2488844 | 2022-05-09 | Greene | Pennsylvania | 42059 | 8490 | 104 |
2489383 | 2489383 | 2022-05-09 | Scurry | Texas | 48415 | 4977 | 104 |
2489527 | 2489527 | 2022-05-09 | Gloucester | Virginia | 51073 | 7405 | 104 |
2489655 | 2489655 | 2022-05-09 | Brooke | West Virginia | 54009 | 5068 | 104 |
2483289 | 2483289 | 2022-05-08 | Bibb | Alabama | 1007 | 6444 | 104 |
2483437 | 2483437 | 2022-05-08 | Little River | Arkansas | 5081 | 3280 | 104 |
2483448 | 2483448 | 2022-05-08 | Ouachita | Arkansas | 5103 | 5478 | 104 |
2483913 | 2483913 | 2022-05-08 | Fayette | Illinois | 17051 | 7137 | 104 |
2483949 | 2483949 | 2022-05-08 | McDonough | Illinois | 17109 | 7274 | 104 |
2484291 | 2484291 | 2022-05-08 | Allen | Kentucky | 21003 | 6598 | 104 |
2484367 | 2484367 | 2022-05-08 | Mason | Kentucky | 21161 | 4974 | 104 |
2484729 | 2484729 | 2022-05-08 | Holmes | Mississippi | 28051 | 4447 | 104 |
2484784 | 2484784 | 2022-05-08 | Winston | Mississippi | 28159 | 5226 | 104 |
2485226 | 2485226 | 2022-05-08 | Davie | North Carolina | 37059 | 11252 | 104 |
2485587 | 2485587 | 2022-05-08 | Greene | Pennsylvania | 42059 | 8490 | 104 |
2486125 | 2486125 | 2022-05-08 | Scurry | Texas | 48415 | 4977 | 104 |
2486270 | 2486270 | 2022-05-08 | Gloucester | Virginia | 51073 | 7383 | 104 |
2486398 | 2486398 | 2022-05-08 | Brooke | West Virginia | 54009 | 5065 | 104 |
2480031 | 2480031 | 2022-05-07 | Bibb | Alabama | 1007 | 6444 | 104 |
2480179 | 2480179 | 2022-05-07 | Little River | Arkansas | 5081 | 3280 | 104 |
2480190 | 2480190 | 2022-05-07 | Ouachita | Arkansas | 5103 | 5477 | 104 |
2480655 | 2480655 | 2022-05-07 | Fayette | Illinois | 17051 | 7137 | 104 |
2480691 | 2480691 | 2022-05-07 | McDonough | Illinois | 17109 | 7274 | 104 |
2481033 | 2481033 | 2022-05-07 | Allen | Kentucky | 21003 | 6598 | 104 |
2481109 | 2481109 | 2022-05-07 | Mason | Kentucky | 21161 | 4974 | 104 |
2481471 | 2481471 | 2022-05-07 | Holmes | Mississippi | 28051 | 4447 | 104 |
2481526 | 2481526 | 2022-05-07 | Winston | Mississippi | 28159 | 5226 | 104 |
2481968 | 2481968 | 2022-05-07 | Davie | North Carolina | 37059 | 11252 | 104 |
2482329 | 2482329 | 2022-05-07 | Greene | Pennsylvania | 42059 | 8490 | 104 |
2482867 | 2482867 | 2022-05-07 | Scurry | Texas | 48415 | 4977 | 104 |
2483012 | 2483012 | 2022-05-07 | Gloucester | Virginia | 51073 | 7383 | 104 |
2483140 | 2483140 | 2022-05-07 | Brooke | West Virginia | 54009 | 5065 | 104 |
2476773 | 2476773 | 2022-05-06 | Bibb | Alabama | 1007 | 6444 | 104 |
2476921 | 2476921 | 2022-05-06 | Little River | Arkansas | 5081 | 3280 | 104 |
2476932 | 2476932 | 2022-05-06 | Ouachita | Arkansas | 5103 | 5477 | 104 |
2477397 | 2477397 | 2022-05-06 | Fayette | Illinois | 17051 | 7137 | 104 |
2477433 | 2477433 | 2022-05-06 | McDonough | Illinois | 17109 | 7274 | 104 |
2477775 | 2477775 | 2022-05-06 | Allen | Kentucky | 21003 | 6598 | 104 |
2477851 | 2477851 | 2022-05-06 | Mason | Kentucky | 21161 | 4974 | 104 |
2478213 | 2478213 | 2022-05-06 | Holmes | Mississippi | 28051 | 4447 | 104 |
2478268 | 2478268 | 2022-05-06 | Winston | Mississippi | 28159 | 5226 | 104 |
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);