ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,638 rows where deaths = 122 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 321
- Ohio 298
- Illinois 221
- Georgia 213
- Mississippi 209
- Wisconsin 180
- Louisiana 137
- Indiana 130
- Iowa 129
- Florida 117
- North Carolina 111
- California 104
- New York 101
- Michigan 95
- Tennessee 94
- Virginia 94
- Missouri 87
- Kentucky 86
- West Virginia 85
- Arkansas 80
- Pennsylvania 74
- Oklahoma 72
- Kansas 68
- Alabama 66
- Nevada 48
- Minnesota 43
- South Carolina 43
- Montana 34
- Washington 31
- Oregon 29
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499819 | 2499819 | 2022-05-13 | Yuba | California | 6115 | 17944 | 122 |
2499974 | 2499974 | 2022-05-13 | Ben Hill | Georgia | 13017 | 4344 | 122 |
2500190 | 2500190 | 2022-05-13 | Clinton | Illinois | 17027 | 12066 | 122 |
2500528 | 2500528 | 2022-05-13 | Lyon | Kansas | 20111 | 10084 | 122 |
2501063 | 2501063 | 2022-05-13 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2501065 | 2501065 | 2022-05-13 | Union | Mississippi | 28145 | 9487 | 122 |
2501182 | 2501182 | 2022-05-13 | Stone | Missouri | 29209 | 5829 | 122 |
2501208 | 2501208 | 2022-05-13 | Gallatin | Montana | 30031 | 34972 | 122 |
2501576 | 2501576 | 2022-05-13 | Vance | North Carolina | 37181 | 11936 | 122 |
2502347 | 2502347 | 2022-05-13 | Lamb | Texas | 48279 | 4356 | 122 |
2502525 | 2502525 | 2022-05-13 | Buchanan | Virginia | 51027 | 4895 | 122 |
2502601 | 2502601 | 2022-05-13 | Page | Virginia | 51139 | 5660 | 122 |
2502747 | 2502747 | 2022-05-13 | Clark | Wisconsin | 55019 | 7694 | 122 |
2502786 | 2502786 | 2022-05-13 | Polk | Wisconsin | 55095 | 12692 | 122 |
2496561 | 2496561 | 2022-05-12 | Yuba | California | 6115 | 17944 | 122 |
2496716 | 2496716 | 2022-05-12 | Ben Hill | Georgia | 13017 | 4344 | 122 |
2496932 | 2496932 | 2022-05-12 | Clinton | Illinois | 17027 | 12053 | 122 |
2497270 | 2497270 | 2022-05-12 | Lyon | Kansas | 20111 | 10005 | 122 |
2497805 | 2497805 | 2022-05-12 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2497807 | 2497807 | 2022-05-12 | Union | Mississippi | 28145 | 9487 | 122 |
2497924 | 2497924 | 2022-05-12 | Stone | Missouri | 29209 | 5805 | 122 |
2497950 | 2497950 | 2022-05-12 | Gallatin | Montana | 30031 | 34927 | 122 |
2498318 | 2498318 | 2022-05-12 | Vance | North Carolina | 37181 | 11936 | 122 |
2499089 | 2499089 | 2022-05-12 | Lamb | Texas | 48279 | 4356 | 122 |
2499267 | 2499267 | 2022-05-12 | Buchanan | Virginia | 51027 | 4902 | 122 |
2499343 | 2499343 | 2022-05-12 | Page | Virginia | 51139 | 5653 | 122 |
2499489 | 2499489 | 2022-05-12 | Clark | Wisconsin | 55019 | 7688 | 122 |
2499528 | 2499528 | 2022-05-12 | Polk | Wisconsin | 55095 | 12677 | 122 |
2493303 | 2493303 | 2022-05-11 | Yuba | California | 6115 | 17845 | 122 |
2493458 | 2493458 | 2022-05-11 | Ben Hill | Georgia | 13017 | 4344 | 122 |
2493674 | 2493674 | 2022-05-11 | Clinton | Illinois | 17027 | 12043 | 122 |
2494012 | 2494012 | 2022-05-11 | Lyon | Kansas | 20111 | 10005 | 122 |
2494547 | 2494547 | 2022-05-11 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2494549 | 2494549 | 2022-05-11 | Union | Mississippi | 28145 | 9487 | 122 |
2494666 | 2494666 | 2022-05-11 | Stone | Missouri | 29209 | 5805 | 122 |
2494692 | 2494692 | 2022-05-11 | Gallatin | Montana | 30031 | 34880 | 122 |
2495060 | 2495060 | 2022-05-11 | Vance | North Carolina | 37181 | 11936 | 122 |
2495164 | 2495164 | 2022-05-11 | Hocking | Ohio | 39073 | 6722 | 122 |
2495831 | 2495831 | 2022-05-11 | Lamb | Texas | 48279 | 4355 | 122 |
2496009 | 2496009 | 2022-05-11 | Buchanan | Virginia | 51027 | 4900 | 122 |
2496073 | 2496073 | 2022-05-11 | Mecklenburg | Virginia | 51117 | 6207 | 122 |
2496085 | 2496085 | 2022-05-11 | Page | Virginia | 51139 | 5649 | 122 |
2496231 | 2496231 | 2022-05-11 | Clark | Wisconsin | 55019 | 7680 | 122 |
2496270 | 2496270 | 2022-05-11 | Polk | Wisconsin | 55095 | 12659 | 122 |
2490045 | 2490045 | 2022-05-10 | Yuba | California | 6115 | 17845 | 122 |
2490200 | 2490200 | 2022-05-10 | Ben Hill | Georgia | 13017 | 4343 | 122 |
2490416 | 2490416 | 2022-05-10 | Clinton | Illinois | 17027 | 12037 | 122 |
2490754 | 2490754 | 2022-05-10 | Lyon | Kansas | 20111 | 10005 | 122 |
2491289 | 2491289 | 2022-05-10 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2491291 | 2491291 | 2022-05-10 | Union | Mississippi | 28145 | 9487 | 122 |
2491408 | 2491408 | 2022-05-10 | Stone | Missouri | 29209 | 5805 | 122 |
2491434 | 2491434 | 2022-05-10 | Gallatin | Montana | 30031 | 34828 | 122 |
2491731 | 2491731 | 2022-05-10 | Cherokee | North Carolina | 37039 | 7114 | 122 |
2491802 | 2491802 | 2022-05-10 | Vance | North Carolina | 37181 | 11894 | 122 |
2491906 | 2491906 | 2022-05-10 | Hocking | Ohio | 39073 | 6722 | 122 |
2492573 | 2492573 | 2022-05-10 | Lamb | Texas | 48279 | 4355 | 122 |
2492751 | 2492751 | 2022-05-10 | Buchanan | Virginia | 51027 | 4900 | 122 |
2492815 | 2492815 | 2022-05-10 | Mecklenburg | Virginia | 51117 | 6201 | 122 |
2492973 | 2492973 | 2022-05-10 | Clark | Wisconsin | 55019 | 7678 | 122 |
2493012 | 2493012 | 2022-05-10 | Polk | Wisconsin | 55095 | 12645 | 122 |
2486788 | 2486788 | 2022-05-09 | Yuba | California | 6115 | 17845 | 122 |
2486943 | 2486943 | 2022-05-09 | Ben Hill | Georgia | 13017 | 4343 | 122 |
2487159 | 2487159 | 2022-05-09 | Clinton | Illinois | 17027 | 12028 | 122 |
2487497 | 2487497 | 2022-05-09 | Lyon | Kansas | 20111 | 10005 | 122 |
2488032 | 2488032 | 2022-05-09 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2488034 | 2488034 | 2022-05-09 | Union | Mississippi | 28145 | 9487 | 122 |
2488150 | 2488150 | 2022-05-09 | Stone | Missouri | 29209 | 5805 | 122 |
2488176 | 2488176 | 2022-05-09 | Gallatin | Montana | 30031 | 34794 | 122 |
2488473 | 2488473 | 2022-05-09 | Cherokee | North Carolina | 37039 | 7114 | 122 |
2488544 | 2488544 | 2022-05-09 | Vance | North Carolina | 37181 | 11894 | 122 |
2488648 | 2488648 | 2022-05-09 | Hocking | Ohio | 39073 | 6722 | 122 |
2489315 | 2489315 | 2022-05-09 | Lamb | Texas | 48279 | 4355 | 122 |
2489557 | 2489557 | 2022-05-09 | Mecklenburg | Virginia | 51117 | 6192 | 122 |
2489715 | 2489715 | 2022-05-09 | Clark | Wisconsin | 55019 | 7670 | 122 |
2489754 | 2489754 | 2022-05-09 | Polk | Wisconsin | 55095 | 12627 | 122 |
2483530 | 2483530 | 2022-05-08 | Yuba | California | 6115 | 17845 | 122 |
2483685 | 2483685 | 2022-05-08 | Ben Hill | Georgia | 13017 | 4343 | 122 |
2483901 | 2483901 | 2022-05-08 | Clinton | Illinois | 17027 | 12023 | 122 |
2484239 | 2484239 | 2022-05-08 | Lyon | Kansas | 20111 | 10005 | 122 |
2484398 | 2484398 | 2022-05-08 | Taylor | Kentucky | 21217 | 9483 | 122 |
2484774 | 2484774 | 2022-05-08 | Tishomingo | Mississippi | 28141 | 6162 | 122 |
2484776 | 2484776 | 2022-05-08 | Union | Mississippi | 28145 | 9480 | 122 |
2484893 | 2484893 | 2022-05-08 | Stone | Missouri | 29209 | 5805 | 122 |
2484919 | 2484919 | 2022-05-08 | Gallatin | Montana | 30031 | 34766 | 122 |
2485216 | 2485216 | 2022-05-08 | Cherokee | North Carolina | 37039 | 7114 | 122 |
2485287 | 2485287 | 2022-05-08 | Vance | North Carolina | 37181 | 11894 | 122 |
2485391 | 2485391 | 2022-05-08 | Hocking | Ohio | 39073 | 6722 | 122 |
2486058 | 2486058 | 2022-05-08 | Lamb | Texas | 48279 | 4355 | 122 |
2486300 | 2486300 | 2022-05-08 | Mecklenburg | Virginia | 51117 | 6187 | 122 |
2486458 | 2486458 | 2022-05-08 | Clark | Wisconsin | 55019 | 7667 | 122 |
2486497 | 2486497 | 2022-05-08 | Polk | Wisconsin | 55095 | 12596 | 122 |
2480272 | 2480272 | 2022-05-07 | Yuba | California | 6115 | 17845 | 122 |
2480427 | 2480427 | 2022-05-07 | Ben Hill | Georgia | 13017 | 4343 | 122 |
2480643 | 2480643 | 2022-05-07 | Clinton | Illinois | 17027 | 12023 | 122 |
2480981 | 2480981 | 2022-05-07 | Lyon | Kansas | 20111 | 10005 | 122 |
2481140 | 2481140 | 2022-05-07 | Taylor | Kentucky | 21217 | 9483 | 122 |
2481516 | 2481516 | 2022-05-07 | Tishomingo | Mississippi | 28141 | 6162 | 122 |
2481518 | 2481518 | 2022-05-07 | Union | Mississippi | 28145 | 9480 | 122 |
2481635 | 2481635 | 2022-05-07 | Stone | Missouri | 29209 | 5805 | 122 |
2481661 | 2481661 | 2022-05-07 | Gallatin | Montana | 30031 | 34766 | 122 |
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);