ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24,429 rows where deaths = 15 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 2,119
- Nebraska 1,797
- Kansas 1,351
- South Dakota 1,248
- Virginia 1,079
- Georgia 1,047
- Missouri 979
- Kentucky 909
- Illinois 904
- Minnesota 678
- Indiana 674
- North Carolina 589
- Wisconsin 576
- North Dakota 545
- Iowa 534
- Idaho 509
- Ohio 498
- Michigan 489
- Mississippi 486
- Arkansas 465
- Montana 464
- Oklahoma 457
- South Carolina 416
- Colorado 385
- Vermont 383
- Tennessee 358
- Washington 357
- Oregon 353
- Utah 352
- West Virginia 343
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499969 | 2499969 | 2022-05-13 | Baker | Georgia | 13007 | 536 | 15 |
2500134 | 2500134 | 2022-05-13 | Adams | Idaho | 16003 | 704 | 15 |
2500164 | 2500164 | 2022-05-13 | Lincoln | Idaho | 16063 | 1107 | 15 |
2500178 | 2500178 | 2022-05-13 | Alexander | Illinois | 17003 | 1288 | 15 |
2500505 | 2500505 | 2022-05-13 | Graham | Kansas | 20065 | 572 | 15 |
2500577 | 2500577 | 2022-05-13 | Woodson | Kansas | 20207 | 796 | 15 |
2501174 | 2501174 | 2022-05-13 | Shelby | Missouri | 29205 | 1603 | 15 |
2501268 | 2501268 | 2022-05-13 | Cuming | Nebraska | 31039 | 1831 | 15 |
2501295 | 2501295 | 2022-05-13 | Howard | Nebraska | 31093 | 1178 | 15 |
2501406 | 2501406 | 2022-05-13 | Hidalgo | New Mexico | 35023 | 1104 | 15 |
2501623 | 2501623 | 2022-05-13 | Renville | North Dakota | 38075 | 556 | 15 |
2501734 | 2501734 | 2022-05-13 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2502340 | 2502340 | 2022-05-13 | Kimble | Texas | 48267 | 714 | 15 |
2502474 | 2502474 | 2022-05-13 | Kane | Utah | 49025 | 1355 | 15 |
2502476 | 2502476 | 2022-05-13 | Morgan | Utah | 49029 | 2903 | 15 |
2502689 | 2502689 | 2022-05-13 | Calhoun | West Virginia | 54013 | 1887 | 15 |
2496711 | 2496711 | 2022-05-12 | Baker | Georgia | 13007 | 536 | 15 |
2496876 | 2496876 | 2022-05-12 | Adams | Idaho | 16003 | 703 | 15 |
2496906 | 2496906 | 2022-05-12 | Lincoln | Idaho | 16063 | 1107 | 15 |
2496920 | 2496920 | 2022-05-12 | Alexander | Illinois | 17003 | 1288 | 15 |
2497247 | 2497247 | 2022-05-12 | Graham | Kansas | 20065 | 568 | 15 |
2497319 | 2497319 | 2022-05-12 | Woodson | Kansas | 20207 | 796 | 15 |
2497916 | 2497916 | 2022-05-12 | Shelby | Missouri | 29205 | 1598 | 15 |
2498010 | 2498010 | 2022-05-12 | Cuming | Nebraska | 31039 | 1830 | 15 |
2498037 | 2498037 | 2022-05-12 | Howard | Nebraska | 31093 | 1178 | 15 |
2498148 | 2498148 | 2022-05-12 | Hidalgo | New Mexico | 35023 | 1104 | 15 |
2498365 | 2498365 | 2022-05-12 | Renville | North Dakota | 38075 | 554 | 15 |
2498476 | 2498476 | 2022-05-12 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2499082 | 2499082 | 2022-05-12 | Kimble | Texas | 48267 | 714 | 15 |
2499216 | 2499216 | 2022-05-12 | Kane | Utah | 49025 | 1355 | 15 |
2499218 | 2499218 | 2022-05-12 | Morgan | Utah | 49029 | 2903 | 15 |
2499431 | 2499431 | 2022-05-12 | Calhoun | West Virginia | 54013 | 1885 | 15 |
2493453 | 2493453 | 2022-05-11 | Baker | Georgia | 13007 | 536 | 15 |
2493618 | 2493618 | 2022-05-11 | Adams | Idaho | 16003 | 703 | 15 |
2493648 | 2493648 | 2022-05-11 | Lincoln | Idaho | 16063 | 1107 | 15 |
2493662 | 2493662 | 2022-05-11 | Alexander | Illinois | 17003 | 1288 | 15 |
2493845 | 2493845 | 2022-05-11 | Unknown | Indiana | 0 | 15 | |
2493989 | 2493989 | 2022-05-11 | Graham | Kansas | 20065 | 568 | 15 |
2494061 | 2494061 | 2022-05-11 | Woodson | Kansas | 20207 | 796 | 15 |
2494658 | 2494658 | 2022-05-11 | Shelby | Missouri | 29205 | 1598 | 15 |
2494752 | 2494752 | 2022-05-11 | Cuming | Nebraska | 31039 | 1830 | 15 |
2494779 | 2494779 | 2022-05-11 | Howard | Nebraska | 31093 | 1178 | 15 |
2494890 | 2494890 | 2022-05-11 | Hidalgo | New Mexico | 35023 | 1103 | 15 |
2495107 | 2495107 | 2022-05-11 | Renville | North Dakota | 38075 | 554 | 15 |
2495218 | 2495218 | 2022-05-11 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2495824 | 2495824 | 2022-05-11 | Kimble | Texas | 48267 | 714 | 15 |
2495958 | 2495958 | 2022-05-11 | Kane | Utah | 49025 | 1355 | 15 |
2495960 | 2495960 | 2022-05-11 | Morgan | Utah | 49029 | 2903 | 15 |
2496173 | 2496173 | 2022-05-11 | Calhoun | West Virginia | 54013 | 1884 | 15 |
2490195 | 2490195 | 2022-05-10 | Baker | Georgia | 13007 | 536 | 15 |
2490360 | 2490360 | 2022-05-10 | Adams | Idaho | 16003 | 703 | 15 |
2490390 | 2490390 | 2022-05-10 | Lincoln | Idaho | 16063 | 1108 | 15 |
2490404 | 2490404 | 2022-05-10 | Alexander | Illinois | 17003 | 1287 | 15 |
2490731 | 2490731 | 2022-05-10 | Graham | Kansas | 20065 | 568 | 15 |
2490803 | 2490803 | 2022-05-10 | Woodson | Kansas | 20207 | 796 | 15 |
2491400 | 2491400 | 2022-05-10 | Shelby | Missouri | 29205 | 1598 | 15 |
2491494 | 2491494 | 2022-05-10 | Cuming | Nebraska | 31039 | 1834 | 15 |
2491521 | 2491521 | 2022-05-10 | Howard | Nebraska | 31093 | 1190 | 15 |
2491632 | 2491632 | 2022-05-10 | Hidalgo | New Mexico | 35023 | 1103 | 15 |
2491849 | 2491849 | 2022-05-10 | Renville | North Dakota | 38075 | 554 | 15 |
2491960 | 2491960 | 2022-05-10 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2492566 | 2492566 | 2022-05-10 | Kimble | Texas | 48267 | 714 | 15 |
2492580 | 2492580 | 2022-05-10 | Lipscomb | Texas | 48295 | 720 | 15 |
2492700 | 2492700 | 2022-05-10 | Kane | Utah | 49025 | 1355 | 15 |
2492702 | 2492702 | 2022-05-10 | Morgan | Utah | 49029 | 2901 | 15 |
2492915 | 2492915 | 2022-05-10 | Calhoun | West Virginia | 54013 | 1884 | 15 |
2486938 | 2486938 | 2022-05-09 | Baker | Georgia | 13007 | 536 | 15 |
2487103 | 2487103 | 2022-05-09 | Adams | Idaho | 16003 | 703 | 15 |
2487133 | 2487133 | 2022-05-09 | Lincoln | Idaho | 16063 | 1108 | 15 |
2487147 | 2487147 | 2022-05-09 | Alexander | Illinois | 17003 | 1287 | 15 |
2487474 | 2487474 | 2022-05-09 | Graham | Kansas | 20065 | 568 | 15 |
2487546 | 2487546 | 2022-05-09 | Woodson | Kansas | 20207 | 796 | 15 |
2488142 | 2488142 | 2022-05-09 | Shelby | Missouri | 29205 | 1598 | 15 |
2488236 | 2488236 | 2022-05-09 | Cuming | Nebraska | 31039 | 1834 | 15 |
2488263 | 2488263 | 2022-05-09 | Howard | Nebraska | 31093 | 1190 | 15 |
2488374 | 2488374 | 2022-05-09 | Hidalgo | New Mexico | 35023 | 1103 | 15 |
2488591 | 2488591 | 2022-05-09 | Renville | North Dakota | 38075 | 554 | 15 |
2488702 | 2488702 | 2022-05-09 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2489308 | 2489308 | 2022-05-09 | Kimble | Texas | 48267 | 714 | 15 |
2489322 | 2489322 | 2022-05-09 | Lipscomb | Texas | 48295 | 720 | 15 |
2489442 | 2489442 | 2022-05-09 | Kane | Utah | 49025 | 1355 | 15 |
2489444 | 2489444 | 2022-05-09 | Morgan | Utah | 49029 | 2901 | 15 |
2489657 | 2489657 | 2022-05-09 | Calhoun | West Virginia | 54013 | 1884 | 15 |
2489786 | 2489786 | 2022-05-09 | Hot Springs | Wyoming | 56017 | 1157 | 15 |
2483680 | 2483680 | 2022-05-08 | Baker | Georgia | 13007 | 536 | 15 |
2483845 | 2483845 | 2022-05-08 | Adams | Idaho | 16003 | 703 | 15 |
2483875 | 2483875 | 2022-05-08 | Lincoln | Idaho | 16063 | 1108 | 15 |
2483889 | 2483889 | 2022-05-08 | Alexander | Illinois | 17003 | 1287 | 15 |
2484216 | 2484216 | 2022-05-08 | Graham | Kansas | 20065 | 568 | 15 |
2484288 | 2484288 | 2022-05-08 | Woodson | Kansas | 20207 | 796 | 15 |
2484885 | 2484885 | 2022-05-08 | Shelby | Missouri | 29205 | 1598 | 15 |
2484979 | 2484979 | 2022-05-08 | Cuming | Nebraska | 31039 | 1834 | 15 |
2485006 | 2485006 | 2022-05-08 | Howard | Nebraska | 31093 | 1190 | 15 |
2485117 | 2485117 | 2022-05-08 | Hidalgo | New Mexico | 35023 | 1103 | 15 |
2485334 | 2485334 | 2022-05-08 | Renville | North Dakota | 38075 | 554 | 15 |
2485445 | 2485445 | 2022-05-08 | Alfalfa | Oklahoma | 40003 | 1716 | 15 |
2486051 | 2486051 | 2022-05-08 | Kimble | Texas | 48267 | 714 | 15 |
2486065 | 2486065 | 2022-05-08 | Lipscomb | Texas | 48295 | 720 | 15 |
2486184 | 2486184 | 2022-05-08 | Kane | Utah | 49025 | 1350 | 15 |
2486186 | 2486186 | 2022-05-08 | Morgan | Utah | 49029 | 2899 | 15 |
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);