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)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 6,668
- Nebraska 3,955
- Georgia 3,211
- Virginia 3,055
- Kentucky 3,051
- North Dakota 2,751
- Montana 2,671
- Missouri 2,655
- Michigan 2,450
- Kansas 2,309
- Colorado 2,303
- Indiana 2,136
- Iowa 2,037
- Oklahoma 1,979
- Minnesota 1,824
- North Carolina 1,819
- Tennessee 1,717
- South Dakota 1,711
- Alaska 1,676
- Illinois 1,536
- Idaho 1,506
- Wisconsin 1,484
- Arkansas 1,420
- Ohio 1,409
- Vermont 1,348
- Pennsylvania 1,114
- West Virginia 1,114
- Utah 1,045
- New York 961
- Washington 959
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499854 | 2499854 | 2022-05-13 | Lake | Colorado | 8065 | 1843 | 2 |
2499860 | 2499860 | 2022-05-13 | Mineral | Colorado | 8079 | 241 | 2 |
2500145 | 2500145 | 2022-05-13 | Camas | Idaho | 16025 | 158 | 2 |
2501252 | 2501252 | 2022-05-13 | Banner | Nebraska | 31007 | 87 | 2 |
2501273 | 2501273 | 2022-05-13 | Deuel | Nebraska | 31049 | 317 | 2 |
2501284 | 2501284 | 2022-05-13 | Garfield | Nebraska | 31071 | 403 | 2 |
2501287 | 2501287 | 2022-05-13 | Greeley | Nebraska | 31077 | 418 | 2 |
2501323 | 2501323 | 2022-05-13 | Rock | Nebraska | 31149 | 179 | 2 |
2501341 | 2501341 | 2022-05-13 | Wheeler | Nebraska | 31183 | 123 | 2 |
2501349 | 2501349 | 2022-05-13 | Eureka | Nevada | 32011 | 165 | 2 |
2501371 | 2501371 | 2022-05-13 | Unknown | New Hampshire | 4382 | 2 | |
2501605 | 2501605 | 2022-05-13 | Griggs | North Dakota | 38039 | 583 | 2 |
2501631 | 2501631 | 2022-05-13 | Steele | North Dakota | 38091 | 388 | 2 |
2502081 | 2502081 | 2022-05-13 | Jones | South Dakota | 46075 | 177 | 2 |
2502223 | 2502223 | 2022-05-13 | Borden | Texas | 48033 | 100 | 2 |
2502337 | 2502337 | 2022-05-13 | Kenedy | Texas | 48261 | 86 | 2 |
2502404 | 2502404 | 2022-05-13 | Roberts | Texas | 48393 | 175 | 2 |
2502503 | 2502503 | 2022-05-13 | Unknown | Vermont | 1496 | 2 | |
2502670 | 2502670 | 2022-05-13 | San Juan | Washington | 53055 | 1450 | 2 |
2496596 | 2496596 | 2022-05-12 | Lake | Colorado | 8065 | 1842 | 2 |
2496602 | 2496602 | 2022-05-12 | Mineral | Colorado | 8079 | 238 | 2 |
2496887 | 2496887 | 2022-05-12 | Camas | Idaho | 16025 | 158 | 2 |
2497994 | 2497994 | 2022-05-12 | Banner | Nebraska | 31007 | 87 | 2 |
2498015 | 2498015 | 2022-05-12 | Deuel | Nebraska | 31049 | 316 | 2 |
2498026 | 2498026 | 2022-05-12 | Garfield | Nebraska | 31071 | 401 | 2 |
2498029 | 2498029 | 2022-05-12 | Greeley | Nebraska | 31077 | 418 | 2 |
2498065 | 2498065 | 2022-05-12 | Rock | Nebraska | 31149 | 179 | 2 |
2498083 | 2498083 | 2022-05-12 | Wheeler | Nebraska | 31183 | 123 | 2 |
2498091 | 2498091 | 2022-05-12 | Eureka | Nevada | 32011 | 165 | 2 |
2498113 | 2498113 | 2022-05-12 | Unknown | New Hampshire | 4416 | 2 | |
2498347 | 2498347 | 2022-05-12 | Griggs | North Dakota | 38039 | 577 | 2 |
2498373 | 2498373 | 2022-05-12 | Steele | North Dakota | 38091 | 385 | 2 |
2498823 | 2498823 | 2022-05-12 | Jones | South Dakota | 46075 | 177 | 2 |
2498965 | 2498965 | 2022-05-12 | Borden | Texas | 48033 | 100 | 2 |
2499079 | 2499079 | 2022-05-12 | Kenedy | Texas | 48261 | 86 | 2 |
2499146 | 2499146 | 2022-05-12 | Roberts | Texas | 48393 | 175 | 2 |
2499245 | 2499245 | 2022-05-12 | Unknown | Vermont | 1463 | 2 | |
2499412 | 2499412 | 2022-05-12 | San Juan | Washington | 53055 | 1403 | 2 |
2493338 | 2493338 | 2022-05-11 | Lake | Colorado | 8065 | 1826 | 2 |
2493344 | 2493344 | 2022-05-11 | Mineral | Colorado | 8079 | 237 | 2 |
2493629 | 2493629 | 2022-05-11 | Camas | Idaho | 16025 | 158 | 2 |
2494550 | 2494550 | 2022-05-11 | Unknown | Mississippi | 633 | 2 | |
2494736 | 2494736 | 2022-05-11 | Banner | Nebraska | 31007 | 87 | 2 |
2494757 | 2494757 | 2022-05-11 | Deuel | Nebraska | 31049 | 316 | 2 |
2494768 | 2494768 | 2022-05-11 | Garfield | Nebraska | 31071 | 401 | 2 |
2494771 | 2494771 | 2022-05-11 | Greeley | Nebraska | 31077 | 418 | 2 |
2494807 | 2494807 | 2022-05-11 | Rock | Nebraska | 31149 | 179 | 2 |
2494825 | 2494825 | 2022-05-11 | Wheeler | Nebraska | 31183 | 123 | 2 |
2494833 | 2494833 | 2022-05-11 | Eureka | Nevada | 32011 | 165 | 2 |
2494855 | 2494855 | 2022-05-11 | Unknown | New Hampshire | 4387 | 2 | |
2495089 | 2495089 | 2022-05-11 | Griggs | North Dakota | 38039 | 577 | 2 |
2495115 | 2495115 | 2022-05-11 | Steele | North Dakota | 38091 | 385 | 2 |
2495565 | 2495565 | 2022-05-11 | Jones | South Dakota | 46075 | 177 | 2 |
2495707 | 2495707 | 2022-05-11 | Borden | Texas | 48033 | 100 | 2 |
2495821 | 2495821 | 2022-05-11 | Kenedy | Texas | 48261 | 86 | 2 |
2495888 | 2495888 | 2022-05-11 | Roberts | Texas | 48393 | 175 | 2 |
2495987 | 2495987 | 2022-05-11 | Unknown | Vermont | 1442 | 2 | |
2496154 | 2496154 | 2022-05-11 | San Juan | Washington | 53055 | 1403 | 2 |
2490080 | 2490080 | 2022-05-10 | Lake | Colorado | 8065 | 1825 | 2 |
2490086 | 2490086 | 2022-05-10 | Mineral | Colorado | 8079 | 237 | 2 |
2490371 | 2490371 | 2022-05-10 | Camas | Idaho | 16025 | 158 | 2 |
2491292 | 2491292 | 2022-05-10 | Unknown | Mississippi | 267 | 2 | |
2491478 | 2491478 | 2022-05-10 | Banner | Nebraska | 31007 | 94 | 2 |
2491499 | 2491499 | 2022-05-10 | Deuel | Nebraska | 31049 | 324 | 2 |
2491510 | 2491510 | 2022-05-10 | Garfield | Nebraska | 31071 | 396 | 2 |
2491513 | 2491513 | 2022-05-10 | Greeley | Nebraska | 31077 | 417 | 2 |
2491549 | 2491549 | 2022-05-10 | Rock | Nebraska | 31149 | 176 | 2 |
2491567 | 2491567 | 2022-05-10 | Wheeler | Nebraska | 31183 | 127 | 2 |
2491575 | 2491575 | 2022-05-10 | Eureka | Nevada | 32011 | 165 | 2 |
2491597 | 2491597 | 2022-05-10 | Unknown | New Hampshire | 4428 | 2 | |
2491831 | 2491831 | 2022-05-10 | Griggs | North Dakota | 38039 | 577 | 2 |
2491857 | 2491857 | 2022-05-10 | Steele | North Dakota | 38091 | 385 | 2 |
2492307 | 2492307 | 2022-05-10 | Jones | South Dakota | 46075 | 177 | 2 |
2492449 | 2492449 | 2022-05-10 | Borden | Texas | 48033 | 99 | 2 |
2492563 | 2492563 | 2022-05-10 | Kenedy | Texas | 48261 | 86 | 2 |
2492630 | 2492630 | 2022-05-10 | Roberts | Texas | 48393 | 175 | 2 |
2492729 | 2492729 | 2022-05-10 | Unknown | Vermont | 1432 | 2 | |
2492896 | 2492896 | 2022-05-10 | San Juan | Washington | 53055 | 1372 | 2 |
2486823 | 2486823 | 2022-05-09 | Lake | Colorado | 8065 | 1824 | 2 |
2486829 | 2486829 | 2022-05-09 | Mineral | Colorado | 8079 | 233 | 2 |
2487114 | 2487114 | 2022-05-09 | Camas | Idaho | 16025 | 158 | 2 |
2488220 | 2488220 | 2022-05-09 | Banner | Nebraska | 31007 | 94 | 2 |
2488241 | 2488241 | 2022-05-09 | Deuel | Nebraska | 31049 | 324 | 2 |
2488252 | 2488252 | 2022-05-09 | Garfield | Nebraska | 31071 | 396 | 2 |
2488255 | 2488255 | 2022-05-09 | Greeley | Nebraska | 31077 | 417 | 2 |
2488291 | 2488291 | 2022-05-09 | Rock | Nebraska | 31149 | 176 | 2 |
2488309 | 2488309 | 2022-05-09 | Wheeler | Nebraska | 31183 | 127 | 2 |
2488317 | 2488317 | 2022-05-09 | Eureka | Nevada | 32011 | 165 | 2 |
2488339 | 2488339 | 2022-05-09 | Unknown | New Hampshire | 4471 | 2 | |
2488573 | 2488573 | 2022-05-09 | Griggs | North Dakota | 38039 | 577 | 2 |
2488599 | 2488599 | 2022-05-09 | Steele | North Dakota | 38091 | 385 | 2 |
2489049 | 2489049 | 2022-05-09 | Jones | South Dakota | 46075 | 177 | 2 |
2489191 | 2489191 | 2022-05-09 | Borden | Texas | 48033 | 99 | 2 |
2489305 | 2489305 | 2022-05-09 | Kenedy | Texas | 48261 | 86 | 2 |
2489372 | 2489372 | 2022-05-09 | Roberts | Texas | 48393 | 175 | 2 |
2489471 | 2489471 | 2022-05-09 | Unknown | Vermont | 1413 | 2 | |
2489638 | 2489638 | 2022-05-09 | San Juan | Washington | 53055 | 1372 | 2 |
2483565 | 2483565 | 2022-05-08 | Lake | Colorado | 8065 | 1820 | 2 |
2483571 | 2483571 | 2022-05-08 | Mineral | Colorado | 8079 | 233 | 2 |
2483856 | 2483856 | 2022-05-08 | Camas | Idaho | 16025 | 158 | 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);