ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,037 rows where deaths = 238 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 79
- Ohio 77
- North Carolina 73
- Texas 70
- Illinois 62
- Pennsylvania 57
- Tennessee 51
- South Carolina 41
- Indiana 40
- Nebraska 36
- Mississippi 34
- Florida 30
- California 27
- New Jersey 27
- Michigan 26
- Alabama 25
- Arkansas 23
- Virginia 23
- New Mexico 21
- Kentucky 20
- Missouri 17
- Louisiana 16
- Washington 16
- Oklahoma 15
- Idaho 14
- Wisconsin 12
- Iowa 11
- Oregon 11
- Arizona 10
- Maryland 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500177 | 2500177 | 2022-05-13 | Adams | Illinois | 17001 | 22525 | 238 |
2500550 | 2500550 | 2022-05-13 | Reno | Kansas | 20155 | 18632 | 238 |
2501036 | 2501036 | 2022-05-13 | Lowndes | Mississippi | 28087 | 17528 | 238 |
2501715 | 2501715 | 2022-05-13 | Sandusky | Ohio | 39143 | 14015 | 238 |
2496919 | 2496919 | 2022-05-12 | Adams | Illinois | 17001 | 22513 | 238 |
2497292 | 2497292 | 2022-05-12 | Reno | Kansas | 20155 | 18608 | 238 |
2497778 | 2497778 | 2022-05-12 | Lowndes | Mississippi | 28087 | 17528 | 238 |
2498457 | 2498457 | 2022-05-12 | Sandusky | Ohio | 39143 | 14015 | 238 |
2493661 | 2493661 | 2022-05-11 | Adams | Illinois | 17001 | 22496 | 238 |
2494034 | 2494034 | 2022-05-11 | Reno | Kansas | 20155 | 18608 | 238 |
2494520 | 2494520 | 2022-05-11 | Lowndes | Mississippi | 28087 | 17528 | 238 |
2495146 | 2495146 | 2022-05-11 | Darke | Ohio | 39037 | 12422 | 238 |
2490403 | 2490403 | 2022-05-10 | Adams | Illinois | 17001 | 22486 | 238 |
2490776 | 2490776 | 2022-05-10 | Reno | Kansas | 20155 | 18608 | 238 |
2491262 | 2491262 | 2022-05-10 | Lowndes | Mississippi | 28087 | 17528 | 238 |
2491888 | 2491888 | 2022-05-10 | Darke | Ohio | 39037 | 12422 | 238 |
2487146 | 2487146 | 2022-05-09 | Adams | Illinois | 17001 | 22479 | 238 |
2488005 | 2488005 | 2022-05-09 | Lowndes | Mississippi | 28087 | 17528 | 238 |
2488630 | 2488630 | 2022-05-09 | Darke | Ohio | 39037 | 12422 | 238 |
2483888 | 2483888 | 2022-05-08 | Adams | Illinois | 17001 | 22469 | 238 |
2485373 | 2485373 | 2022-05-08 | Darke | Ohio | 39037 | 12422 | 238 |
2480630 | 2480630 | 2022-05-07 | Adams | Illinois | 17001 | 22469 | 238 |
2482115 | 2482115 | 2022-05-07 | Darke | Ohio | 39037 | 12422 | 238 |
2477372 | 2477372 | 2022-05-06 | Adams | Illinois | 17001 | 22469 | 238 |
2478857 | 2478857 | 2022-05-06 | Darke | Ohio | 39037 | 12422 | 238 |
2474114 | 2474114 | 2022-05-05 | Adams | Illinois | 17001 | 22460 | 238 |
2474706 | 2474706 | 2022-05-05 | Kennebec | Maine | 23011 | 24259 | 238 |
2475599 | 2475599 | 2022-05-05 | Darke | Ohio | 39037 | 12422 | 238 |
2470857 | 2470857 | 2022-05-04 | Adams | Illinois | 17001 | 22456 | 238 |
2472342 | 2472342 | 2022-05-04 | Darke | Ohio | 39037 | 12405 | 238 |
2467394 | 2467394 | 2022-05-03 | Baldwin | Georgia | 13009 | 9551 | 238 |
2467601 | 2467601 | 2022-05-03 | Adams | Illinois | 17001 | 22438 | 238 |
2469086 | 2469086 | 2022-05-03 | Darke | Ohio | 39037 | 12405 | 238 |
2464139 | 2464139 | 2022-05-02 | Baldwin | Georgia | 13009 | 9551 | 238 |
2464346 | 2464346 | 2022-05-02 | Adams | Illinois | 17001 | 22424 | 238 |
2465830 | 2465830 | 2022-05-02 | Darke | Ohio | 39037 | 12405 | 238 |
2466075 | 2466075 | 2022-05-02 | Venango | Pennsylvania | 42121 | 11308 | 238 |
2460883 | 2460883 | 2022-05-01 | Baldwin | Georgia | 13009 | 9550 | 238 |
2461090 | 2461090 | 2022-05-01 | Adams | Illinois | 17001 | 22407 | 238 |
2462575 | 2462575 | 2022-05-01 | Darke | Ohio | 39037 | 12405 | 238 |
2462820 | 2462820 | 2022-05-01 | Venango | Pennsylvania | 42121 | 11303 | 238 |
2457627 | 2457627 | 2022-04-30 | Baldwin | Georgia | 13009 | 9550 | 238 |
2457834 | 2457834 | 2022-04-30 | Adams | Illinois | 17001 | 22407 | 238 |
2459319 | 2459319 | 2022-04-30 | Darke | Ohio | 39037 | 12405 | 238 |
2459564 | 2459564 | 2022-04-30 | Venango | Pennsylvania | 42121 | 11300 | 238 |
2454371 | 2454371 | 2022-04-29 | Baldwin | Georgia | 13009 | 9550 | 238 |
2454578 | 2454578 | 2022-04-29 | Adams | Illinois | 17001 | 22407 | 238 |
2456063 | 2456063 | 2022-04-29 | Darke | Ohio | 39037 | 12405 | 238 |
2456308 | 2456308 | 2022-04-29 | Venango | Pennsylvania | 42121 | 11297 | 238 |
2456618 | 2456618 | 2022-04-29 | Bastrop | Texas | 48021 | 21812 | 238 |
2451115 | 2451115 | 2022-04-28 | Baldwin | Georgia | 13009 | 9550 | 238 |
2451322 | 2451322 | 2022-04-28 | Adams | Illinois | 17001 | 22405 | 238 |
2452807 | 2452807 | 2022-04-28 | Darke | Ohio | 39037 | 12405 | 238 |
2453052 | 2453052 | 2022-04-28 | Venango | Pennsylvania | 42121 | 11292 | 238 |
2453362 | 2453362 | 2022-04-28 | Bastrop | Texas | 48021 | 21810 | 238 |
2447859 | 2447859 | 2022-04-27 | Baldwin | Georgia | 13009 | 9550 | 238 |
2448066 | 2448066 | 2022-04-27 | Adams | Illinois | 17001 | 22398 | 238 |
2449551 | 2449551 | 2022-04-27 | Darke | Ohio | 39037 | 12388 | 238 |
2449796 | 2449796 | 2022-04-27 | Venango | Pennsylvania | 42121 | 11285 | 238 |
2450106 | 2450106 | 2022-04-27 | Bastrop | Texas | 48021 | 21807 | 238 |
2444810 | 2444810 | 2022-04-26 | Adams | Illinois | 17001 | 22393 | 238 |
2446294 | 2446294 | 2022-04-26 | Darke | Ohio | 39037 | 12388 | 238 |
2446539 | 2446539 | 2022-04-26 | Venango | Pennsylvania | 42121 | 11277 | 238 |
2446849 | 2446849 | 2022-04-26 | Bastrop | Texas | 48021 | 21802 | 238 |
2441554 | 2441554 | 2022-04-25 | Adams | Illinois | 17001 | 22387 | 238 |
2443039 | 2443039 | 2022-04-25 | Darke | Ohio | 39037 | 12388 | 238 |
2443284 | 2443284 | 2022-04-25 | Venango | Pennsylvania | 42121 | 11274 | 238 |
2443594 | 2443594 | 2022-04-25 | Bastrop | Texas | 48021 | 21797 | 238 |
2438298 | 2438298 | 2022-04-24 | Adams | Illinois | 17001 | 22371 | 238 |
2439783 | 2439783 | 2022-04-24 | Darke | Ohio | 39037 | 12388 | 238 |
2440028 | 2440028 | 2022-04-24 | Venango | Pennsylvania | 42121 | 11273 | 238 |
2440338 | 2440338 | 2022-04-24 | Bastrop | Texas | 48021 | 21795 | 238 |
2435042 | 2435042 | 2022-04-23 | Adams | Illinois | 17001 | 22371 | 238 |
2436527 | 2436527 | 2022-04-23 | Darke | Ohio | 39037 | 12388 | 238 |
2436772 | 2436772 | 2022-04-23 | Venango | Pennsylvania | 42121 | 11273 | 238 |
2437072 | 2437072 | 2022-04-23 | Anderson | Texas | 48001 | 9539 | 238 |
2437082 | 2437082 | 2022-04-23 | Bastrop | Texas | 48021 | 21792 | 238 |
2431786 | 2431786 | 2022-04-22 | Adams | Illinois | 17001 | 22371 | 238 |
2433271 | 2433271 | 2022-04-22 | Darke | Ohio | 39037 | 12388 | 238 |
2433516 | 2433516 | 2022-04-22 | Venango | Pennsylvania | 42121 | 11269 | 238 |
2433816 | 2433816 | 2022-04-22 | Anderson | Texas | 48001 | 9538 | 238 |
2433826 | 2433826 | 2022-04-22 | Bastrop | Texas | 48021 | 21788 | 238 |
2428530 | 2428530 | 2022-04-21 | Adams | Illinois | 17001 | 22369 | 238 |
2428720 | 2428720 | 2022-04-21 | Warrick | Indiana | 18173 | 20285 | 238 |
2430015 | 2430015 | 2022-04-21 | Darke | Ohio | 39037 | 12388 | 238 |
2430260 | 2430260 | 2022-04-21 | Venango | Pennsylvania | 42121 | 11268 | 238 |
2430560 | 2430560 | 2022-04-21 | Anderson | Texas | 48001 | 9537 | 238 |
2430570 | 2430570 | 2022-04-21 | Bastrop | Texas | 48021 | 21787 | 238 |
2425274 | 2425274 | 2022-04-20 | Adams | Illinois | 17001 | 22360 | 238 |
2425464 | 2425464 | 2022-04-20 | Warrick | Indiana | 18173 | 20285 | 238 |
2426759 | 2426759 | 2022-04-20 | Darke | Ohio | 39037 | 12381 | 238 |
2427004 | 2427004 | 2022-04-20 | Venango | Pennsylvania | 42121 | 11262 | 238 |
2427304 | 2427304 | 2022-04-20 | Anderson | Texas | 48001 | 9537 | 238 |
2427616 | 2427616 | 2022-04-20 | Bedford | Virginia | 51019 | 16957 | 238 |
2422018 | 2422018 | 2022-04-19 | Adams | Illinois | 17001 | 22355 | 238 |
2422208 | 2422208 | 2022-04-19 | Warrick | Indiana | 18173 | 20280 | 238 |
2423503 | 2423503 | 2022-04-19 | Darke | Ohio | 39037 | 12381 | 238 |
2423748 | 2423748 | 2022-04-19 | Venango | Pennsylvania | 42121 | 11262 | 238 |
2424048 | 2424048 | 2022-04-19 | Anderson | Texas | 48001 | 9537 | 238 |
2424360 | 2424360 | 2022-04-19 | Bedford | Virginia | 51019 | 16953 | 238 |
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);