ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73,151 rows where deaths = 2 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 6,641
- Nebraska 3,901
- Georgia 3,211
- Virginia 3,055
- Kentucky 3,051
- North Dakota 2,733
- Montana 2,671
- Missouri 2,655
- Michigan 2,450
- Kansas 2,309
- Colorado 2,285
- Indiana 2,136
- Iowa 2,037
- Oklahoma 1,979
- Minnesota 1,824
- North Carolina 1,819
- Tennessee 1,717
- South Dakota 1,702
- Alaska 1,676
- Illinois 1,536
- Idaho 1,497
- Wisconsin 1,484
- Arkansas 1,420
- Ohio 1,409
- Vermont 1,339
- Pennsylvania 1,114
- West Virginia 1,114
- Utah 1,045
- New York 961
- Washington 950
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470534 | 2470534 | 2022-05-04 | Lake | Colorado | 8065 | 1819 | 2 |
2470540 | 2470540 | 2022-05-04 | Mineral | Colorado | 8079 | 233 | 2 |
2470825 | 2470825 | 2022-05-04 | Camas | Idaho | 16025 | 158 | 2 |
2471932 | 2471932 | 2022-05-04 | Banner | Nebraska | 31007 | 94 | 2 |
2471953 | 2471953 | 2022-05-04 | Deuel | Nebraska | 31049 | 323 | 2 |
2471964 | 2471964 | 2022-05-04 | Garfield | Nebraska | 31071 | 396 | 2 |
2471967 | 2471967 | 2022-05-04 | Greeley | Nebraska | 31077 | 416 | 2 |
2472003 | 2472003 | 2022-05-04 | Rock | Nebraska | 31149 | 176 | 2 |
2472021 | 2472021 | 2022-05-04 | Wheeler | Nebraska | 31183 | 127 | 2 |
2472029 | 2472029 | 2022-05-04 | Eureka | Nevada | 32011 | 165 | 2 |
2472051 | 2472051 | 2022-05-04 | Unknown | New Hampshire | 5109 | 2 | |
2472285 | 2472285 | 2022-05-04 | Griggs | North Dakota | 38039 | 572 | 2 |
2472311 | 2472311 | 2022-05-04 | Steele | North Dakota | 38091 | 384 | 2 |
2472761 | 2472761 | 2022-05-04 | Jones | South Dakota | 46075 | 177 | 2 |
2472903 | 2472903 | 2022-05-04 | Borden | Texas | 48033 | 98 | 2 |
2473017 | 2473017 | 2022-05-04 | Kenedy | Texas | 48261 | 85 | 2 |
2473083 | 2473083 | 2022-05-04 | Roberts | Texas | 48393 | 175 | 2 |
2473349 | 2473349 | 2022-05-04 | San Juan | Washington | 53055 | 1307 | 2 |
2467278 | 2467278 | 2022-05-03 | Lake | Colorado | 8065 | 1820 | 2 |
2467284 | 2467284 | 2022-05-03 | Mineral | Colorado | 8079 | 233 | 2 |
2467569 | 2467569 | 2022-05-03 | Camas | Idaho | 16025 | 158 | 2 |
2468676 | 2468676 | 2022-05-03 | Banner | Nebraska | 31007 | 94 | 2 |
2468697 | 2468697 | 2022-05-03 | Deuel | Nebraska | 31049 | 322 | 2 |
2468708 | 2468708 | 2022-05-03 | Garfield | Nebraska | 31071 | 397 | 2 |
2468711 | 2468711 | 2022-05-03 | Greeley | Nebraska | 31077 | 415 | 2 |
2468747 | 2468747 | 2022-05-03 | Rock | Nebraska | 31149 | 176 | 2 |
2468765 | 2468765 | 2022-05-03 | Wheeler | Nebraska | 31183 | 126 | 2 |
2468773 | 2468773 | 2022-05-03 | Eureka | Nevada | 32011 | 165 | 2 |
2468795 | 2468795 | 2022-05-03 | Unknown | New Hampshire | 5148 | 2 | |
2469029 | 2469029 | 2022-05-03 | Griggs | North Dakota | 38039 | 572 | 2 |
2469055 | 2469055 | 2022-05-03 | Steele | North Dakota | 38091 | 384 | 2 |
2469505 | 2469505 | 2022-05-03 | Jones | South Dakota | 46075 | 177 | 2 |
2469647 | 2469647 | 2022-05-03 | Borden | Texas | 48033 | 98 | 2 |
2469761 | 2469761 | 2022-05-03 | Kenedy | Texas | 48261 | 85 | 2 |
2469827 | 2469827 | 2022-05-03 | Roberts | Texas | 48393 | 175 | 2 |
2470093 | 2470093 | 2022-05-03 | San Juan | Washington | 53055 | 1276 | 2 |
2464023 | 2464023 | 2022-05-02 | Lake | Colorado | 8065 | 1818 | 2 |
2464029 | 2464029 | 2022-05-02 | Mineral | Colorado | 8079 | 233 | 2 |
2464060 | 2464060 | 2022-05-02 | Unknown | Connecticut | 2291 | 2 | |
2464314 | 2464314 | 2022-05-02 | Camas | Idaho | 16025 | 158 | 2 |
2465420 | 2465420 | 2022-05-02 | Banner | Nebraska | 31007 | 94 | 2 |
2465441 | 2465441 | 2022-05-02 | Deuel | Nebraska | 31049 | 322 | 2 |
2465452 | 2465452 | 2022-05-02 | Garfield | Nebraska | 31071 | 397 | 2 |
2465455 | 2465455 | 2022-05-02 | Greeley | Nebraska | 31077 | 415 | 2 |
2465491 | 2465491 | 2022-05-02 | Rock | Nebraska | 31149 | 176 | 2 |
2465509 | 2465509 | 2022-05-02 | Wheeler | Nebraska | 31183 | 126 | 2 |
2465517 | 2465517 | 2022-05-02 | Eureka | Nevada | 32011 | 165 | 2 |
2465539 | 2465539 | 2022-05-02 | Unknown | New Hampshire | 5165 | 2 | |
2465773 | 2465773 | 2022-05-02 | Griggs | North Dakota | 38039 | 572 | 2 |
2465799 | 2465799 | 2022-05-02 | Steele | North Dakota | 38091 | 384 | 2 |
2466249 | 2466249 | 2022-05-02 | Jones | South Dakota | 46075 | 177 | 2 |
2466391 | 2466391 | 2022-05-02 | Borden | Texas | 48033 | 98 | 2 |
2466505 | 2466505 | 2022-05-02 | Kenedy | Texas | 48261 | 85 | 2 |
2466571 | 2466571 | 2022-05-02 | Roberts | Texas | 48393 | 175 | 2 |
2466837 | 2466837 | 2022-05-02 | San Juan | Washington | 53055 | 1276 | 2 |
2460767 | 2460767 | 2022-05-01 | Lake | Colorado | 8065 | 1817 | 2 |
2460773 | 2460773 | 2022-05-01 | Mineral | Colorado | 8079 | 233 | 2 |
2460804 | 2460804 | 2022-05-01 | Unknown | Connecticut | 2277 | 2 | |
2461058 | 2461058 | 2022-05-01 | Camas | Idaho | 16025 | 158 | 2 |
2462165 | 2462165 | 2022-05-01 | Banner | Nebraska | 31007 | 94 | 2 |
2462186 | 2462186 | 2022-05-01 | Deuel | Nebraska | 31049 | 322 | 2 |
2462197 | 2462197 | 2022-05-01 | Garfield | Nebraska | 31071 | 397 | 2 |
2462200 | 2462200 | 2022-05-01 | Greeley | Nebraska | 31077 | 415 | 2 |
2462236 | 2462236 | 2022-05-01 | Rock | Nebraska | 31149 | 176 | 2 |
2462254 | 2462254 | 2022-05-01 | Wheeler | Nebraska | 31183 | 126 | 2 |
2462262 | 2462262 | 2022-05-01 | Eureka | Nevada | 32011 | 165 | 2 |
2462284 | 2462284 | 2022-05-01 | Unknown | New Hampshire | 5137 | 2 | |
2462518 | 2462518 | 2022-05-01 | Griggs | North Dakota | 38039 | 572 | 2 |
2462544 | 2462544 | 2022-05-01 | Steele | North Dakota | 38091 | 384 | 2 |
2462994 | 2462994 | 2022-05-01 | Jones | South Dakota | 46075 | 177 | 2 |
2463136 | 2463136 | 2022-05-01 | Borden | Texas | 48033 | 98 | 2 |
2463250 | 2463250 | 2022-05-01 | Kenedy | Texas | 48261 | 85 | 2 |
2463316 | 2463316 | 2022-05-01 | Roberts | Texas | 48393 | 175 | 2 |
2463582 | 2463582 | 2022-05-01 | San Juan | Washington | 53055 | 1266 | 2 |
2457511 | 2457511 | 2022-04-30 | Lake | Colorado | 8065 | 1817 | 2 |
2457517 | 2457517 | 2022-04-30 | Mineral | Colorado | 8079 | 233 | 2 |
2457548 | 2457548 | 2022-04-30 | Unknown | Connecticut | 2277 | 2 | |
2457802 | 2457802 | 2022-04-30 | Camas | Idaho | 16025 | 158 | 2 |
2458909 | 2458909 | 2022-04-30 | Banner | Nebraska | 31007 | 94 | 2 |
2458930 | 2458930 | 2022-04-30 | Deuel | Nebraska | 31049 | 322 | 2 |
2458941 | 2458941 | 2022-04-30 | Garfield | Nebraska | 31071 | 397 | 2 |
2458944 | 2458944 | 2022-04-30 | Greeley | Nebraska | 31077 | 415 | 2 |
2458980 | 2458980 | 2022-04-30 | Rock | Nebraska | 31149 | 176 | 2 |
2458998 | 2458998 | 2022-04-30 | Wheeler | Nebraska | 31183 | 126 | 2 |
2459006 | 2459006 | 2022-04-30 | Eureka | Nevada | 32011 | 165 | 2 |
2459028 | 2459028 | 2022-04-30 | Unknown | New Hampshire | 5137 | 2 | |
2459262 | 2459262 | 2022-04-30 | Griggs | North Dakota | 38039 | 572 | 2 |
2459288 | 2459288 | 2022-04-30 | Steele | North Dakota | 38091 | 384 | 2 |
2459738 | 2459738 | 2022-04-30 | Jones | South Dakota | 46075 | 177 | 2 |
2459880 | 2459880 | 2022-04-30 | Borden | Texas | 48033 | 98 | 2 |
2459994 | 2459994 | 2022-04-30 | Kenedy | Texas | 48261 | 85 | 2 |
2460060 | 2460060 | 2022-04-30 | Roberts | Texas | 48393 | 175 | 2 |
2460326 | 2460326 | 2022-04-30 | San Juan | Washington | 53055 | 1266 | 2 |
2454255 | 2454255 | 2022-04-29 | Lake | Colorado | 8065 | 1817 | 2 |
2454261 | 2454261 | 2022-04-29 | Mineral | Colorado | 8079 | 233 | 2 |
2454292 | 2454292 | 2022-04-29 | Unknown | Connecticut | 2277 | 2 | |
2454546 | 2454546 | 2022-04-29 | Camas | Idaho | 16025 | 158 | 2 |
2455653 | 2455653 | 2022-04-29 | Banner | Nebraska | 31007 | 94 | 2 |
2455674 | 2455674 | 2022-04-29 | Deuel | Nebraska | 31049 | 322 | 2 |
2455685 | 2455685 | 2022-04-29 | Garfield | Nebraska | 31071 | 397 | 2 |
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);