ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,847 rows where deaths = 106 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 354
- Georgia 322
- Illinois 303
- Ohio 260
- Mississippi 256
- Texas 227
- Indiana 211
- Michigan 208
- Tennessee 199
- Alabama 161
- North Carolina 161
- Louisiana 156
- Kentucky 147
- Arkansas 142
- Missouri 137
- Virginia 136
- Iowa 133
- Pennsylvania 125
- Maryland 124
- Wisconsin 112
- Florida 82
- South Carolina 75
- Kansas 74
- New York 74
- California 72
- Minnesota 69
- West Virginia 65
- Colorado 56
- Nevada 55
- Washington 54
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499607 | 2499607 | 2022-05-13 | Hale | Alabama | 1065 | 4741 | 106 |
2499761 | 2499761 | 2022-05-13 | Yell | Arkansas | 5149 | 6859 | 106 |
2500073 | 2500073 | 2022-05-13 | Oconee | Georgia | 13219 | 8820 | 106 |
2500082 | 2500082 | 2022-05-13 | Putnam | Georgia | 13237 | 4528 | 106 |
2500249 | 2500249 | 2022-05-13 | Perry | Illinois | 17145 | 7509 | 106 |
2500350 | 2500350 | 2022-05-13 | Scott | Indiana | 18143 | 7943 | 106 |
2500662 | 2500662 | 2022-05-13 | Mercer | Kentucky | 21167 | 7401 | 106 |
2500885 | 2500885 | 2022-05-13 | Ogemaw | Michigan | 26129 | 4372 | 106 |
2501678 | 2501678 | 2022-05-13 | Henry | Ohio | 39069 | 6485 | 106 |
2501737 | 2501737 | 2022-05-13 | Beckham | Oklahoma | 40009 | 5983 | 106 |
2501800 | 2501800 | 2022-05-13 | Sequoyah | Oklahoma | 40135 | 10639 | 106 |
2501912 | 2501912 | 2022-05-13 | Wyoming | Pennsylvania | 42131 | 5257 | 106 |
2502159 | 2502159 | 2022-05-13 | Lauderdale | Tennessee | 47097 | 7764 | 106 |
2502510 | 2502510 | 2022-05-13 | Accomack | Virginia | 51001 | 7054 | 106 |
2496349 | 2496349 | 2022-05-12 | Hale | Alabama | 1065 | 4741 | 106 |
2496503 | 2496503 | 2022-05-12 | Yell | Arkansas | 5149 | 6859 | 106 |
2496815 | 2496815 | 2022-05-12 | Oconee | Georgia | 13219 | 8820 | 106 |
2496824 | 2496824 | 2022-05-12 | Putnam | Georgia | 13237 | 4528 | 106 |
2496991 | 2496991 | 2022-05-12 | Perry | Illinois | 17145 | 7506 | 106 |
2497092 | 2497092 | 2022-05-12 | Scott | Indiana | 18143 | 7929 | 106 |
2497404 | 2497404 | 2022-05-12 | Mercer | Kentucky | 21167 | 7401 | 106 |
2497627 | 2497627 | 2022-05-12 | Ogemaw | Michigan | 26129 | 4372 | 106 |
2498420 | 2498420 | 2022-05-12 | Henry | Ohio | 39069 | 6485 | 106 |
2498479 | 2498479 | 2022-05-12 | Beckham | Oklahoma | 40009 | 5983 | 106 |
2498542 | 2498542 | 2022-05-12 | Sequoyah | Oklahoma | 40135 | 10639 | 106 |
2498654 | 2498654 | 2022-05-12 | Wyoming | Pennsylvania | 42131 | 5257 | 106 |
2498901 | 2498901 | 2022-05-12 | Lauderdale | Tennessee | 47097 | 7764 | 106 |
2499252 | 2499252 | 2022-05-12 | Accomack | Virginia | 51001 | 7046 | 106 |
2493091 | 2493091 | 2022-05-11 | Hale | Alabama | 1065 | 4741 | 106 |
2493245 | 2493245 | 2022-05-11 | Yell | Arkansas | 5149 | 6858 | 106 |
2493557 | 2493557 | 2022-05-11 | Oconee | Georgia | 13219 | 8820 | 106 |
2493566 | 2493566 | 2022-05-11 | Putnam | Georgia | 13237 | 4528 | 106 |
2493733 | 2493733 | 2022-05-11 | Perry | Illinois | 17145 | 7505 | 106 |
2493834 | 2493834 | 2022-05-11 | Scott | Indiana | 18143 | 7929 | 106 |
2494146 | 2494146 | 2022-05-11 | Mercer | Kentucky | 21167 | 7401 | 106 |
2494369 | 2494369 | 2022-05-11 | Ogemaw | Michigan | 26129 | 4372 | 106 |
2495162 | 2495162 | 2022-05-11 | Henry | Ohio | 39069 | 6466 | 106 |
2495221 | 2495221 | 2022-05-11 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2495284 | 2495284 | 2022-05-11 | Sequoyah | Oklahoma | 40135 | 10633 | 106 |
2495396 | 2495396 | 2022-05-11 | Wyoming | Pennsylvania | 42131 | 5257 | 106 |
2495643 | 2495643 | 2022-05-11 | Lauderdale | Tennessee | 47097 | 7764 | 106 |
2495994 | 2495994 | 2022-05-11 | Accomack | Virginia | 51001 | 7037 | 106 |
2489833 | 2489833 | 2022-05-10 | Hale | Alabama | 1065 | 4733 | 106 |
2489987 | 2489987 | 2022-05-10 | Yell | Arkansas | 5149 | 6858 | 106 |
2490308 | 2490308 | 2022-05-10 | Putnam | Georgia | 13237 | 4509 | 106 |
2490475 | 2490475 | 2022-05-10 | Perry | Illinois | 17145 | 7502 | 106 |
2490576 | 2490576 | 2022-05-10 | Scott | Indiana | 18143 | 7914 | 106 |
2490888 | 2490888 | 2022-05-10 | Mercer | Kentucky | 21167 | 7401 | 106 |
2491111 | 2491111 | 2022-05-10 | Ogemaw | Michigan | 26129 | 4343 | 106 |
2491904 | 2491904 | 2022-05-10 | Henry | Ohio | 39069 | 6466 | 106 |
2491963 | 2491963 | 2022-05-10 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2492026 | 2492026 | 2022-05-10 | Sequoyah | Oklahoma | 40135 | 10633 | 106 |
2492138 | 2492138 | 2022-05-10 | Wyoming | Pennsylvania | 42131 | 5208 | 106 |
2492385 | 2492385 | 2022-05-10 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2492736 | 2492736 | 2022-05-10 | Accomack | Virginia | 51001 | 7032 | 106 |
2486576 | 2486576 | 2022-05-09 | Hale | Alabama | 1065 | 4733 | 106 |
2486730 | 2486730 | 2022-05-09 | Yell | Arkansas | 5149 | 6858 | 106 |
2487051 | 2487051 | 2022-05-09 | Putnam | Georgia | 13237 | 4509 | 106 |
2487218 | 2487218 | 2022-05-09 | Perry | Illinois | 17145 | 7498 | 106 |
2487319 | 2487319 | 2022-05-09 | Scott | Indiana | 18143 | 7914 | 106 |
2487631 | 2487631 | 2022-05-09 | Mercer | Kentucky | 21167 | 7401 | 106 |
2487854 | 2487854 | 2022-05-09 | Ogemaw | Michigan | 26129 | 4343 | 106 |
2488646 | 2488646 | 2022-05-09 | Henry | Ohio | 39069 | 6466 | 106 |
2488705 | 2488705 | 2022-05-09 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2488768 | 2488768 | 2022-05-09 | Sequoyah | Oklahoma | 40135 | 10633 | 106 |
2488880 | 2488880 | 2022-05-09 | Wyoming | Pennsylvania | 42131 | 5208 | 106 |
2489127 | 2489127 | 2022-05-09 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2489478 | 2489478 | 2022-05-09 | Accomack | Virginia | 51001 | 7026 | 106 |
2483318 | 2483318 | 2022-05-08 | Hale | Alabama | 1065 | 4731 | 106 |
2483472 | 2483472 | 2022-05-08 | Yell | Arkansas | 5149 | 6858 | 106 |
2483793 | 2483793 | 2022-05-08 | Putnam | Georgia | 13237 | 4509 | 106 |
2483960 | 2483960 | 2022-05-08 | Perry | Illinois | 17145 | 7494 | 106 |
2484061 | 2484061 | 2022-05-08 | Scott | Indiana | 18143 | 7885 | 106 |
2484365 | 2484365 | 2022-05-08 | Marshall | Kentucky | 21157 | 8416 | 106 |
2484376 | 2484376 | 2022-05-08 | Montgomery | Kentucky | 21173 | 8031 | 106 |
2484596 | 2484596 | 2022-05-08 | Ogemaw | Michigan | 26129 | 4343 | 106 |
2485389 | 2485389 | 2022-05-08 | Henry | Ohio | 39069 | 6466 | 106 |
2485448 | 2485448 | 2022-05-08 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2485511 | 2485511 | 2022-05-08 | Sequoyah | Oklahoma | 40135 | 10633 | 106 |
2485623 | 2485623 | 2022-05-08 | Wyoming | Pennsylvania | 42131 | 5208 | 106 |
2485870 | 2485870 | 2022-05-08 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2486221 | 2486221 | 2022-05-08 | Accomack | Virginia | 51001 | 7007 | 106 |
2480060 | 2480060 | 2022-05-07 | Hale | Alabama | 1065 | 4731 | 106 |
2480214 | 2480214 | 2022-05-07 | Yell | Arkansas | 5149 | 6858 | 106 |
2480535 | 2480535 | 2022-05-07 | Putnam | Georgia | 13237 | 4509 | 106 |
2480702 | 2480702 | 2022-05-07 | Perry | Illinois | 17145 | 7494 | 106 |
2480803 | 2480803 | 2022-05-07 | Scott | Indiana | 18143 | 7885 | 106 |
2481107 | 2481107 | 2022-05-07 | Marshall | Kentucky | 21157 | 8416 | 106 |
2481118 | 2481118 | 2022-05-07 | Montgomery | Kentucky | 21173 | 8031 | 106 |
2481338 | 2481338 | 2022-05-07 | Ogemaw | Michigan | 26129 | 4343 | 106 |
2482131 | 2482131 | 2022-05-07 | Henry | Ohio | 39069 | 6466 | 106 |
2482190 | 2482190 | 2022-05-07 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2482253 | 2482253 | 2022-05-07 | Sequoyah | Oklahoma | 40135 | 10633 | 106 |
2482365 | 2482365 | 2022-05-07 | Wyoming | Pennsylvania | 42131 | 5208 | 106 |
2482612 | 2482612 | 2022-05-07 | Lauderdale | Tennessee | 47097 | 7752 | 106 |
2482963 | 2482963 | 2022-05-07 | Accomack | Virginia | 51001 | 7007 | 106 |
2476802 | 2476802 | 2022-05-06 | Hale | Alabama | 1065 | 4731 | 106 |
2476956 | 2476956 | 2022-05-06 | Yell | Arkansas | 5149 | 6858 | 106 |
2477277 | 2477277 | 2022-05-06 | Putnam | Georgia | 13237 | 4509 | 106 |
2477444 | 2477444 | 2022-05-06 | Perry | Illinois | 17145 | 7494 | 106 |
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);