ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28,566 rows where deaths = 12 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: state, county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499654 | 2499654 | 2022-05-13 | Kodiak Island Borough | Alaska | 2150 | 4992 | 12 |
2499830 | 2499830 | 2022-05-13 | Clear Creek | Colorado | 8019 | 1601 | 12 |
2499875 | 2499875 | 2022-05-13 | Saguache | Colorado | 8109 | 1203 | 12 |
2500015 | 2500015 | 2022-05-13 | Echols | Georgia | 13101 | 937 | 12 |
2500261 | 2500261 | 2022-05-13 | Scott | Illinois | 17171 | 1276 | 12 |
2500523 | 2500523 | 2022-05-13 | Lane | Kansas | 20101 | 296 | 12 |
2500930 | 2500930 | 2022-05-13 | Grant | Minnesota | 27051 | 1506 | 12 |
2501279 | 2501279 | 2022-05-13 | Franklin | Nebraska | 31061 | 413 | 12 |
2501311 | 2501311 | 2022-05-13 | Nance | Nebraska | 31125 | 775 | 12 |
2501316 | 2501316 | 2022-05-13 | Perkins | Nebraska | 31135 | 527 | 12 |
2501324 | 2501324 | 2022-05-13 | Saline | Nebraska | 31151 | 3781 | 12 |
2501609 | 2501609 | 2022-05-13 | Logan | North Dakota | 38047 | 435 | 12 |
2501633 | 2501633 | 2022-05-13 | Towner | North Dakota | 38095 | 641 | 12 |
2501638 | 2501638 | 2022-05-13 | Wells | North Dakota | 38103 | 1018 | 12 |
2501761 | 2501761 | 2022-05-13 | Harmon | Oklahoma | 40057 | 522 | 12 |
2501762 | 2501762 | 2022-05-13 | Harper | Oklahoma | 40059 | 714 | 12 |
2502063 | 2502063 | 2022-05-13 | Deuel | South Dakota | 46039 | 1043 | 12 |
2502071 | 2502071 | 2022-05-13 | Haakon | South Dakota | 46055 | 452 | 12 |
2502073 | 2502073 | 2022-05-13 | Hand | South Dakota | 46059 | 562 | 12 |
2502086 | 2502086 | 2022-05-13 | Lyman | South Dakota | 46085 | 1205 | 12 |
2502363 | 2502363 | 2022-05-13 | Mason | Texas | 48319 | 787 | 12 |
2502370 | 2502370 | 2022-05-13 | Menard | Texas | 48327 | 513 | 12 |
2502416 | 2502416 | 2022-05-13 | Shackelford | Texas | 48417 | 691 | 12 |
2502425 | 2502425 | 2022-05-13 | Sutton | Texas | 48435 | 848 | 12 |
2502576 | 2502576 | 2022-05-13 | King and Queen | Virginia | 51097 | 1146 | 12 |
2502672 | 2502672 | 2022-05-13 | Skamania | Washington | 53059 | 1531 | 12 |
2502743 | 2502743 | 2022-05-13 | Buffalo | Wisconsin | 55011 | 3608 | 12 |
2496396 | 2496396 | 2022-05-12 | Kodiak Island Borough | Alaska | 2150 | 4992 | 12 |
2496572 | 2496572 | 2022-05-12 | Clear Creek | Colorado | 8019 | 1599 | 12 |
2496617 | 2496617 | 2022-05-12 | Saguache | Colorado | 8109 | 1202 | 12 |
2496757 | 2496757 | 2022-05-12 | Echols | Georgia | 13101 | 937 | 12 |
2497003 | 2497003 | 2022-05-12 | Scott | Illinois | 17171 | 1275 | 12 |
2497265 | 2497265 | 2022-05-12 | Lane | Kansas | 20101 | 296 | 12 |
2497672 | 2497672 | 2022-05-12 | Grant | Minnesota | 27051 | 1502 | 12 |
2498021 | 2498021 | 2022-05-12 | Franklin | Nebraska | 31061 | 413 | 12 |
2498053 | 2498053 | 2022-05-12 | Nance | Nebraska | 31125 | 775 | 12 |
2498058 | 2498058 | 2022-05-12 | Perkins | Nebraska | 31135 | 527 | 12 |
2498066 | 2498066 | 2022-05-12 | Saline | Nebraska | 31151 | 3773 | 12 |
2498351 | 2498351 | 2022-05-12 | Logan | North Dakota | 38047 | 436 | 12 |
2498375 | 2498375 | 2022-05-12 | Towner | North Dakota | 38095 | 636 | 12 |
2498380 | 2498380 | 2022-05-12 | Wells | North Dakota | 38103 | 1016 | 12 |
2498503 | 2498503 | 2022-05-12 | Harmon | Oklahoma | 40057 | 522 | 12 |
2498504 | 2498504 | 2022-05-12 | Harper | Oklahoma | 40059 | 714 | 12 |
2498805 | 2498805 | 2022-05-12 | Deuel | South Dakota | 46039 | 1043 | 12 |
2498813 | 2498813 | 2022-05-12 | Haakon | South Dakota | 46055 | 452 | 12 |
2498815 | 2498815 | 2022-05-12 | Hand | South Dakota | 46059 | 562 | 12 |
2498828 | 2498828 | 2022-05-12 | Lyman | South Dakota | 46085 | 1205 | 12 |
2499105 | 2499105 | 2022-05-12 | Mason | Texas | 48319 | 787 | 12 |
2499112 | 2499112 | 2022-05-12 | Menard | Texas | 48327 | 513 | 12 |
2499158 | 2499158 | 2022-05-12 | Shackelford | Texas | 48417 | 691 | 12 |
2499167 | 2499167 | 2022-05-12 | Sutton | Texas | 48435 | 848 | 12 |
2499318 | 2499318 | 2022-05-12 | King and Queen | Virginia | 51097 | 1144 | 12 |
2499485 | 2499485 | 2022-05-12 | Buffalo | Wisconsin | 55011 | 3604 | 12 |
2493138 | 2493138 | 2022-05-11 | Kodiak Island Borough | Alaska | 2150 | 4992 | 12 |
2493314 | 2493314 | 2022-05-11 | Clear Creek | Colorado | 8019 | 1588 | 12 |
2493359 | 2493359 | 2022-05-11 | Saguache | Colorado | 8109 | 1200 | 12 |
2493499 | 2493499 | 2022-05-11 | Echols | Georgia | 13101 | 937 | 12 |
2493745 | 2493745 | 2022-05-11 | Scott | Illinois | 17171 | 1275 | 12 |
2494007 | 2494007 | 2022-05-11 | Lane | Kansas | 20101 | 296 | 12 |
2494414 | 2494414 | 2022-05-11 | Grant | Minnesota | 27051 | 1502 | 12 |
2494763 | 2494763 | 2022-05-11 | Franklin | Nebraska | 31061 | 413 | 12 |
2494795 | 2494795 | 2022-05-11 | Nance | Nebraska | 31125 | 775 | 12 |
2494800 | 2494800 | 2022-05-11 | Perkins | Nebraska | 31135 | 527 | 12 |
2494808 | 2494808 | 2022-05-11 | Saline | Nebraska | 31151 | 3773 | 12 |
2495093 | 2495093 | 2022-05-11 | Logan | North Dakota | 38047 | 436 | 12 |
2495117 | 2495117 | 2022-05-11 | Towner | North Dakota | 38095 | 636 | 12 |
2495122 | 2495122 | 2022-05-11 | Wells | North Dakota | 38103 | 1016 | 12 |
2495245 | 2495245 | 2022-05-11 | Harmon | Oklahoma | 40057 | 522 | 12 |
2495246 | 2495246 | 2022-05-11 | Harper | Oklahoma | 40059 | 714 | 12 |
2495547 | 2495547 | 2022-05-11 | Deuel | South Dakota | 46039 | 1043 | 12 |
2495555 | 2495555 | 2022-05-11 | Haakon | South Dakota | 46055 | 452 | 12 |
2495557 | 2495557 | 2022-05-11 | Hand | South Dakota | 46059 | 562 | 12 |
2495570 | 2495570 | 2022-05-11 | Lyman | South Dakota | 46085 | 1205 | 12 |
2495847 | 2495847 | 2022-05-11 | Mason | Texas | 48319 | 787 | 12 |
2495854 | 2495854 | 2022-05-11 | Menard | Texas | 48327 | 513 | 12 |
2495900 | 2495900 | 2022-05-11 | Shackelford | Texas | 48417 | 690 | 12 |
2495909 | 2495909 | 2022-05-11 | Sutton | Texas | 48435 | 847 | 12 |
2496060 | 2496060 | 2022-05-11 | King and Queen | Virginia | 51097 | 1142 | 12 |
2496227 | 2496227 | 2022-05-11 | Buffalo | Wisconsin | 55011 | 3598 | 12 |
2489880 | 2489880 | 2022-05-10 | Kodiak Island Borough | Alaska | 2150 | 4983 | 12 |
2489881 | 2489881 | 2022-05-10 | Kusilvak Census Area | Alaska | 2158 | 4073 | 12 |
2490056 | 2490056 | 2022-05-10 | Clear Creek | Colorado | 8019 | 1587 | 12 |
2490101 | 2490101 | 2022-05-10 | Saguache | Colorado | 8109 | 1200 | 12 |
2490241 | 2490241 | 2022-05-10 | Echols | Georgia | 13101 | 936 | 12 |
2490487 | 2490487 | 2022-05-10 | Scott | Illinois | 17171 | 1275 | 12 |
2490749 | 2490749 | 2022-05-10 | Lane | Kansas | 20101 | 296 | 12 |
2491156 | 2491156 | 2022-05-10 | Grant | Minnesota | 27051 | 1500 | 12 |
2491505 | 2491505 | 2022-05-10 | Franklin | Nebraska | 31061 | 421 | 12 |
2491537 | 2491537 | 2022-05-10 | Nance | Nebraska | 31125 | 818 | 12 |
2491542 | 2491542 | 2022-05-10 | Perkins | Nebraska | 31135 | 541 | 12 |
2491550 | 2491550 | 2022-05-10 | Saline | Nebraska | 31151 | 3812 | 12 |
2491835 | 2491835 | 2022-05-10 | Logan | North Dakota | 38047 | 436 | 12 |
2491859 | 2491859 | 2022-05-10 | Towner | North Dakota | 38095 | 636 | 12 |
2491864 | 2491864 | 2022-05-10 | Wells | North Dakota | 38103 | 1016 | 12 |
2491987 | 2491987 | 2022-05-10 | Harmon | Oklahoma | 40057 | 522 | 12 |
2491988 | 2491988 | 2022-05-10 | Harper | Oklahoma | 40059 | 714 | 12 |
2492223 | 2492223 | 2022-05-10 | Unknown | Rhode Island | 32675 | 12 | |
2492289 | 2492289 | 2022-05-10 | Deuel | South Dakota | 46039 | 1042 | 12 |
2492297 | 2492297 | 2022-05-10 | Haakon | South Dakota | 46055 | 452 | 12 |
2492299 | 2492299 | 2022-05-10 | Hand | South Dakota | 46059 | 562 | 12 |
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);