ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,840 rows where deaths = 185 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 169
- Georgia 120
- Tennessee 112
- North Carolina 107
- Indiana 96
- Wisconsin 92
- Oklahoma 89
- Pennsylvania 85
- Virginia 82
- Alabama 70
- Ohio 68
- New York 60
- North Dakota 51
- Louisiana 48
- Michigan 45
- Missouri 45
- New Jersey 45
- New Mexico 44
- California 39
- South Carolina 39
- Kentucky 35
- Oregon 32
- Arkansas 31
- Mississippi 25
- Maine 23
- Florida 20
- Montana 19
- Maryland 17
- Illinois 16
- Arizona 15
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500959 | 2500959 | 2022-05-13 | Olmsted | Minnesota | 27109 | 43593 | 185 |
2501217 | 2501217 | 2022-05-13 | Lewis and Clark | Montana | 30049 | 17709 | 185 |
2501896 | 2501896 | 2022-05-13 | Perry | Pennsylvania | 42099 | 8873 | 185 |
2497959 | 2497959 | 2022-05-12 | Lewis and Clark | Montana | 30049 | 17686 | 185 |
2498638 | 2498638 | 2022-05-12 | Perry | Pennsylvania | 42099 | 8873 | 185 |
2494701 | 2494701 | 2022-05-11 | Lewis and Clark | Montana | 30049 | 17686 | 185 |
2495380 | 2495380 | 2022-05-11 | Perry | Pennsylvania | 42099 | 8873 | 185 |
2490511 | 2490511 | 2022-05-10 | Boone | Indiana | 18011 | 15404 | 185 |
2491443 | 2491443 | 2022-05-10 | Lewis and Clark | Montana | 30049 | 17686 | 185 |
2492360 | 2492360 | 2022-05-10 | Fayette | Tennessee | 47047 | 11455 | 185 |
2487254 | 2487254 | 2022-05-09 | Boone | Indiana | 18011 | 15404 | 185 |
2488185 | 2488185 | 2022-05-09 | Lewis and Clark | Montana | 30049 | 17686 | 185 |
2489102 | 2489102 | 2022-05-09 | Fayette | Tennessee | 47047 | 11455 | 185 |
2484928 | 2484928 | 2022-05-08 | Lewis and Clark | Montana | 30049 | 17686 | 185 |
2485845 | 2485845 | 2022-05-08 | Fayette | Tennessee | 47047 | 11455 | 185 |
2486480 | 2486480 | 2022-05-08 | La Crosse | Wisconsin | 55063 | 35605 | 185 |
2481670 | 2481670 | 2022-05-07 | Lewis and Clark | Montana | 30049 | 17686 | 185 |
2482587 | 2482587 | 2022-05-07 | Fayette | Tennessee | 47047 | 11455 | 185 |
2483222 | 2483222 | 2022-05-07 | La Crosse | Wisconsin | 55063 | 35605 | 185 |
2478412 | 2478412 | 2022-05-06 | Lewis and Clark | Montana | 30049 | 17686 | 185 |
2479329 | 2479329 | 2022-05-06 | Fayette | Tennessee | 47047 | 11455 | 185 |
2479964 | 2479964 | 2022-05-06 | La Crosse | Wisconsin | 55063 | 35605 | 185 |
2475154 | 2475154 | 2022-05-05 | Lewis and Clark | Montana | 30049 | 17680 | 185 |
2476071 | 2476071 | 2022-05-05 | Fayette | Tennessee | 47047 | 11455 | 185 |
2471897 | 2471897 | 2022-05-04 | Lewis and Clark | Montana | 30049 | 17677 | 185 |
2472814 | 2472814 | 2022-05-04 | Fayette | Tennessee | 47047 | 11455 | 185 |
2473425 | 2473425 | 2022-05-04 | Chippewa | Wisconsin | 55017 | 18923 | 185 |
2468641 | 2468641 | 2022-05-03 | Lewis and Clark | Montana | 30049 | 17665 | 185 |
2468986 | 2468986 | 2022-05-03 | Richmond | North Carolina | 37153 | 12829 | 185 |
2469558 | 2469558 | 2022-05-03 | Fayette | Tennessee | 47047 | 11437 | 185 |
2470168 | 2470168 | 2022-05-03 | Chippewa | Wisconsin | 55017 | 18908 | 185 |
2470177 | 2470177 | 2022-05-03 | Eau Claire | Wisconsin | 55035 | 30781 | 185 |
2465385 | 2465385 | 2022-05-02 | Lewis and Clark | Montana | 30049 | 17660 | 185 |
2465730 | 2465730 | 2022-05-02 | Richmond | North Carolina | 37153 | 12829 | 185 |
2466302 | 2466302 | 2022-05-02 | Fayette | Tennessee | 47047 | 11437 | 185 |
2466871 | 2466871 | 2022-05-02 | Logan | West Virginia | 54045 | 9663 | 185 |
2466921 | 2466921 | 2022-05-02 | Eau Claire | Wisconsin | 55035 | 30729 | 185 |
2462130 | 2462130 | 2022-05-01 | Lewis and Clark | Montana | 30049 | 17651 | 185 |
2462475 | 2462475 | 2022-05-01 | Richmond | North Carolina | 37153 | 12829 | 185 |
2463047 | 2463047 | 2022-05-01 | Fayette | Tennessee | 47047 | 11437 | 185 |
2463616 | 2463616 | 2022-05-01 | Logan | West Virginia | 54045 | 9642 | 185 |
2463666 | 2463666 | 2022-05-01 | Eau Claire | Wisconsin | 55035 | 30643 | 185 |
2458874 | 2458874 | 2022-04-30 | Lewis and Clark | Montana | 30049 | 17651 | 185 |
2459219 | 2459219 | 2022-04-30 | Richmond | North Carolina | 37153 | 12829 | 185 |
2459791 | 2459791 | 2022-04-30 | Fayette | Tennessee | 47047 | 11437 | 185 |
2460360 | 2460360 | 2022-04-30 | Logan | West Virginia | 54045 | 9642 | 185 |
2460410 | 2460410 | 2022-04-30 | Eau Claire | Wisconsin | 55035 | 30643 | 185 |
2455618 | 2455618 | 2022-04-29 | Lewis and Clark | Montana | 30049 | 17651 | 185 |
2455963 | 2455963 | 2022-04-29 | Richmond | North Carolina | 37153 | 12829 | 185 |
2456535 | 2456535 | 2022-04-29 | Fayette | Tennessee | 47047 | 11437 | 185 |
2457104 | 2457104 | 2022-04-29 | Logan | West Virginia | 54045 | 9642 | 185 |
2457154 | 2457154 | 2022-04-29 | Eau Claire | Wisconsin | 55035 | 30643 | 185 |
2452362 | 2452362 | 2022-04-28 | Lewis and Clark | Montana | 30049 | 17647 | 185 |
2452707 | 2452707 | 2022-04-28 | Richmond | North Carolina | 37153 | 12829 | 185 |
2453279 | 2453279 | 2022-04-28 | Fayette | Tennessee | 47047 | 11437 | 185 |
2453848 | 2453848 | 2022-04-28 | Logan | West Virginia | 54045 | 9637 | 185 |
2453898 | 2453898 | 2022-04-28 | Eau Claire | Wisconsin | 55035 | 30590 | 185 |
2449106 | 2449106 | 2022-04-27 | Lewis and Clark | Montana | 30049 | 17642 | 185 |
2449286 | 2449286 | 2022-04-27 | Cibola | New Mexico | 35006 | 7930 | 185 |
2449302 | 2449302 | 2022-04-27 | Otero | New Mexico | 35035 | 15555 | 185 |
2449334 | 2449334 | 2022-04-27 | Genesee | New York | 36037 | 14001 | 185 |
2449451 | 2449451 | 2022-04-27 | Richmond | North Carolina | 37153 | 12829 | 185 |
2450023 | 2450023 | 2022-04-27 | Fayette | Tennessee | 47047 | 11437 | 185 |
2450325 | 2450325 | 2022-04-27 | Upshur | Texas | 48459 | 7899 | 185 |
2450592 | 2450592 | 2022-04-27 | Logan | West Virginia | 54045 | 9626 | 185 |
2450642 | 2450642 | 2022-04-27 | Eau Claire | Wisconsin | 55035 | 30551 | 185 |
2444760 | 2444760 | 2022-04-26 | Hawaii | Hawaii | 15001 | 26651 | 185 |
2445392 | 2445392 | 2022-04-26 | Webster | Louisiana | 22119 | 11105 | 185 |
2445849 | 2445849 | 2022-04-26 | Lewis and Clark | Montana | 30049 | 17631 | 185 |
2446029 | 2446029 | 2022-04-26 | Cibola | New Mexico | 35006 | 7930 | 185 |
2446045 | 2446045 | 2022-04-26 | Otero | New Mexico | 35035 | 15555 | 185 |
2446077 | 2446077 | 2022-04-26 | Genesee | New York | 36037 | 13972 | 185 |
2446194 | 2446194 | 2022-04-26 | Richmond | North Carolina | 37153 | 12800 | 185 |
2446766 | 2446766 | 2022-04-26 | Fayette | Tennessee | 47047 | 11430 | 185 |
2447068 | 2447068 | 2022-04-26 | Upshur | Texas | 48459 | 7898 | 185 |
2447336 | 2447336 | 2022-04-26 | Logan | West Virginia | 54045 | 9616 | 185 |
2447386 | 2447386 | 2022-04-26 | Eau Claire | Wisconsin | 55035 | 30499 | 185 |
2441504 | 2441504 | 2022-04-25 | Hawaii | Hawaii | 15001 | 26651 | 185 |
2442136 | 2442136 | 2022-04-25 | Webster | Louisiana | 22119 | 11104 | 185 |
2442774 | 2442774 | 2022-04-25 | Cibola | New Mexico | 35006 | 7930 | 185 |
2442790 | 2442790 | 2022-04-25 | Otero | New Mexico | 35035 | 15555 | 185 |
2442822 | 2442822 | 2022-04-25 | Genesee | New York | 36037 | 13950 | 185 |
2442939 | 2442939 | 2022-04-25 | Richmond | North Carolina | 37153 | 12800 | 185 |
2443511 | 2443511 | 2022-04-25 | Fayette | Tennessee | 47047 | 11430 | 185 |
2443813 | 2443813 | 2022-04-25 | Upshur | Texas | 48459 | 7897 | 185 |
2444130 | 2444130 | 2022-04-25 | Eau Claire | Wisconsin | 55035 | 30461 | 185 |
2438248 | 2438248 | 2022-04-24 | Hawaii | Hawaii | 15001 | 26651 | 185 |
2439518 | 2439518 | 2022-04-24 | Cibola | New Mexico | 35006 | 7914 | 185 |
2439534 | 2439534 | 2022-04-24 | Otero | New Mexico | 35035 | 15549 | 185 |
2439566 | 2439566 | 2022-04-24 | Genesee | New York | 36037 | 13929 | 185 |
2439683 | 2439683 | 2022-04-24 | Richmond | North Carolina | 37153 | 12800 | 185 |
2440255 | 2440255 | 2022-04-24 | Fayette | Tennessee | 47047 | 11430 | 185 |
2440557 | 2440557 | 2022-04-24 | Upshur | Texas | 48459 | 7897 | 185 |
2440874 | 2440874 | 2022-04-24 | Eau Claire | Wisconsin | 55035 | 30413 | 185 |
2434992 | 2434992 | 2022-04-23 | Hawaii | Hawaii | 15001 | 26651 | 185 |
2436262 | 2436262 | 2022-04-23 | Cibola | New Mexico | 35006 | 7914 | 185 |
2436278 | 2436278 | 2022-04-23 | Otero | New Mexico | 35035 | 15549 | 185 |
2436310 | 2436310 | 2022-04-23 | Genesee | New York | 36037 | 13894 | 185 |
2436427 | 2436427 | 2022-04-23 | Richmond | North Carolina | 37153 | 12800 | 185 |
2436999 | 2436999 | 2022-04-23 | Fayette | Tennessee | 47047 | 11430 | 185 |
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);