ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14,968 rows where deaths = 34 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 1,217
- Georgia 897
- Missouri 857
- Iowa 854
- Kentucky 751
- Tennessee 683
- Mississippi 680
- Virginia 674
- Illinois 648
- Minnesota 560
- Kansas 526
- North Carolina 518
- Michigan 493
- Indiana 486
- Oklahoma 444
- Arkansas 387
- Alabama 375
- West Virginia 362
- Louisiana 314
- South Dakota 282
- North Dakota 220
- Wisconsin 219
- Washington 215
- Idaho 210
- New York 200
- Ohio 188
- Florida 186
- Nebraska 168
- Oregon 155
- South Carolina 148
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500209 | 2500209 | 2022-05-13 | Hamilton | Illinois | 17065 | 2181 | 34 |
2500452 | 2500452 | 2022-05-13 | Ringgold | Iowa | 19159 | 1135 | 34 |
2500475 | 2500475 | 2022-05-13 | Atchison | Kansas | 20005 | 4323 | 34 |
2500494 | 2500494 | 2022-05-13 | Doniphan | Kansas | 20043 | 2456 | 34 |
2500558 | 2500558 | 2022-05-13 | Scott | Kansas | 20171 | 1277 | 34 |
2500650 | 2500650 | 2022-05-13 | Lyon | Kentucky | 21143 | 2881 | 34 |
2500672 | 2500672 | 2022-05-13 | Owen | Kentucky | 21187 | 2370 | 34 |
2500963 | 2500963 | 2022-05-13 | Pipestone | Minnesota | 27117 | 2013 | 34 |
2500971 | 2500971 | 2022-05-13 | Rock | Minnesota | 27133 | 2348 | 34 |
2501636 | 2501636 | 2022-05-13 | Walsh | North Dakota | 38099 | 3374 | 34 |
2501835 | 2501835 | 2022-05-13 | Morrow | Oregon | 41049 | 2980 | 34 |
2502070 | 2502070 | 2022-05-13 | Gregory | South Dakota | 46053 | 1065 | 34 |
2502222 | 2502222 | 2022-05-13 | Blanco | Texas | 48031 | 2568 | 34 |
2502426 | 2502426 | 2022-05-13 | Swisher | Texas | 48437 | 2288 | 34 |
2502455 | 2502455 | 2022-05-13 | Winkler | Texas | 48495 | 1846 | 34 |
2496951 | 2496951 | 2022-05-12 | Hamilton | Illinois | 17065 | 2181 | 34 |
2497194 | 2497194 | 2022-05-12 | Ringgold | Iowa | 19159 | 1135 | 34 |
2497217 | 2497217 | 2022-05-12 | Atchison | Kansas | 20005 | 4306 | 34 |
2497236 | 2497236 | 2022-05-12 | Doniphan | Kansas | 20043 | 2451 | 34 |
2497300 | 2497300 | 2022-05-12 | Scott | Kansas | 20171 | 1275 | 34 |
2497392 | 2497392 | 2022-05-12 | Lyon | Kentucky | 21143 | 2881 | 34 |
2497414 | 2497414 | 2022-05-12 | Owen | Kentucky | 21187 | 2370 | 34 |
2497705 | 2497705 | 2022-05-12 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2497713 | 2497713 | 2022-05-12 | Rock | Minnesota | 27133 | 2346 | 34 |
2498378 | 2498378 | 2022-05-12 | Walsh | North Dakota | 38099 | 3368 | 34 |
2498577 | 2498577 | 2022-05-12 | Morrow | Oregon | 41049 | 2980 | 34 |
2498812 | 2498812 | 2022-05-12 | Gregory | South Dakota | 46053 | 1065 | 34 |
2498964 | 2498964 | 2022-05-12 | Blanco | Texas | 48031 | 2566 | 34 |
2499168 | 2499168 | 2022-05-12 | Swisher | Texas | 48437 | 2288 | 34 |
2499197 | 2499197 | 2022-05-12 | Winkler | Texas | 48495 | 1846 | 34 |
2493693 | 2493693 | 2022-05-11 | Hamilton | Illinois | 17065 | 2181 | 34 |
2493936 | 2493936 | 2022-05-11 | Ringgold | Iowa | 19159 | 1135 | 34 |
2493959 | 2493959 | 2022-05-11 | Atchison | Kansas | 20005 | 4306 | 34 |
2493978 | 2493978 | 2022-05-11 | Doniphan | Kansas | 20043 | 2451 | 34 |
2494042 | 2494042 | 2022-05-11 | Scott | Kansas | 20171 | 1275 | 34 |
2494134 | 2494134 | 2022-05-11 | Lyon | Kentucky | 21143 | 2881 | 34 |
2494156 | 2494156 | 2022-05-11 | Owen | Kentucky | 21187 | 2370 | 34 |
2494447 | 2494447 | 2022-05-11 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2494455 | 2494455 | 2022-05-11 | Rock | Minnesota | 27133 | 2344 | 34 |
2495120 | 2495120 | 2022-05-11 | Walsh | North Dakota | 38099 | 3368 | 34 |
2495319 | 2495319 | 2022-05-11 | Morrow | Oregon | 41049 | 2980 | 34 |
2495554 | 2495554 | 2022-05-11 | Gregory | South Dakota | 46053 | 1065 | 34 |
2495706 | 2495706 | 2022-05-11 | Blanco | Texas | 48031 | 2563 | 34 |
2495910 | 2495910 | 2022-05-11 | Swisher | Texas | 48437 | 2286 | 34 |
2495939 | 2495939 | 2022-05-11 | Winkler | Texas | 48495 | 1846 | 34 |
2490009 | 2490009 | 2022-05-10 | Mariposa | California | 6043 | 3126 | 34 |
2490078 | 2490078 | 2022-05-10 | Kit Carson | Colorado | 8063 | 1614 | 34 |
2490435 | 2490435 | 2022-05-10 | Hamilton | Illinois | 17065 | 2180 | 34 |
2490678 | 2490678 | 2022-05-10 | Ringgold | Iowa | 19159 | 1133 | 34 |
2490701 | 2490701 | 2022-05-10 | Atchison | Kansas | 20005 | 4306 | 34 |
2490720 | 2490720 | 2022-05-10 | Doniphan | Kansas | 20043 | 2451 | 34 |
2490784 | 2490784 | 2022-05-10 | Scott | Kansas | 20171 | 1275 | 34 |
2490876 | 2490876 | 2022-05-10 | Lyon | Kentucky | 21143 | 2881 | 34 |
2490898 | 2490898 | 2022-05-10 | Owen | Kentucky | 21187 | 2370 | 34 |
2491189 | 2491189 | 2022-05-10 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2491197 | 2491197 | 2022-05-10 | Rock | Minnesota | 27133 | 2344 | 34 |
2491862 | 2491862 | 2022-05-10 | Walsh | North Dakota | 38099 | 3368 | 34 |
2492061 | 2492061 | 2022-05-10 | Morrow | Oregon | 41049 | 2978 | 34 |
2492296 | 2492296 | 2022-05-10 | Gregory | South Dakota | 46053 | 1065 | 34 |
2492448 | 2492448 | 2022-05-10 | Blanco | Texas | 48031 | 2562 | 34 |
2492652 | 2492652 | 2022-05-10 | Swisher | Texas | 48437 | 2286 | 34 |
2492681 | 2492681 | 2022-05-10 | Winkler | Texas | 48495 | 1846 | 34 |
2486752 | 2486752 | 2022-05-09 | Mariposa | California | 6043 | 3123 | 34 |
2487178 | 2487178 | 2022-05-09 | Hamilton | Illinois | 17065 | 2181 | 34 |
2487421 | 2487421 | 2022-05-09 | Ringgold | Iowa | 19159 | 1133 | 34 |
2487444 | 2487444 | 2022-05-09 | Atchison | Kansas | 20005 | 4306 | 34 |
2487463 | 2487463 | 2022-05-09 | Doniphan | Kansas | 20043 | 2451 | 34 |
2487527 | 2487527 | 2022-05-09 | Scott | Kansas | 20171 | 1275 | 34 |
2487619 | 2487619 | 2022-05-09 | Lyon | Kentucky | 21143 | 2881 | 34 |
2487641 | 2487641 | 2022-05-09 | Owen | Kentucky | 21187 | 2370 | 34 |
2487932 | 2487932 | 2022-05-09 | Pipestone | Minnesota | 27117 | 2011 | 34 |
2487940 | 2487940 | 2022-05-09 | Rock | Minnesota | 27133 | 2343 | 34 |
2488604 | 2488604 | 2022-05-09 | Walsh | North Dakota | 38099 | 3368 | 34 |
2488803 | 2488803 | 2022-05-09 | Morrow | Oregon | 41049 | 2977 | 34 |
2489038 | 2489038 | 2022-05-09 | Gregory | South Dakota | 46053 | 1065 | 34 |
2489190 | 2489190 | 2022-05-09 | Blanco | Texas | 48031 | 2561 | 34 |
2489394 | 2489394 | 2022-05-09 | Swisher | Texas | 48437 | 2285 | 34 |
2489423 | 2489423 | 2022-05-09 | Winkler | Texas | 48495 | 1846 | 34 |
2483494 | 2483494 | 2022-05-08 | Mariposa | California | 6043 | 3101 | 34 |
2483920 | 2483920 | 2022-05-08 | Hamilton | Illinois | 17065 | 2180 | 34 |
2484163 | 2484163 | 2022-05-08 | Ringgold | Iowa | 19159 | 1133 | 34 |
2484186 | 2484186 | 2022-05-08 | Atchison | Kansas | 20005 | 4306 | 34 |
2484205 | 2484205 | 2022-05-08 | Doniphan | Kansas | 20043 | 2451 | 34 |
2484269 | 2484269 | 2022-05-08 | Scott | Kansas | 20171 | 1275 | 34 |
2484361 | 2484361 | 2022-05-08 | Lyon | Kentucky | 21143 | 2874 | 34 |
2484383 | 2484383 | 2022-05-08 | Owen | Kentucky | 21187 | 2369 | 34 |
2484674 | 2484674 | 2022-05-08 | Pipestone | Minnesota | 27117 | 2011 | 34 |
2484682 | 2484682 | 2022-05-08 | Rock | Minnesota | 27133 | 2343 | 34 |
2485347 | 2485347 | 2022-05-08 | Walsh | North Dakota | 38099 | 3368 | 34 |
2485546 | 2485546 | 2022-05-08 | Morrow | Oregon | 41049 | 2973 | 34 |
2485781 | 2485781 | 2022-05-08 | Gregory | South Dakota | 46053 | 1065 | 34 |
2485933 | 2485933 | 2022-05-08 | Blanco | Texas | 48031 | 2560 | 34 |
2486136 | 2486136 | 2022-05-08 | Swisher | Texas | 48437 | 2285 | 34 |
2486165 | 2486165 | 2022-05-08 | Winkler | Texas | 48495 | 1846 | 34 |
2480236 | 2480236 | 2022-05-07 | Mariposa | California | 6043 | 3101 | 34 |
2480662 | 2480662 | 2022-05-07 | Hamilton | Illinois | 17065 | 2180 | 34 |
2480905 | 2480905 | 2022-05-07 | Ringgold | Iowa | 19159 | 1133 | 34 |
2480928 | 2480928 | 2022-05-07 | Atchison | Kansas | 20005 | 4306 | 34 |
2480947 | 2480947 | 2022-05-07 | Doniphan | Kansas | 20043 | 2451 | 34 |
2481011 | 2481011 | 2022-05-07 | Scott | Kansas | 20171 | 1275 | 34 |
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);