ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
560 rows where deaths = 353 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 58
- Tennessee 46
- Georgia 32
- Indiana 32
- South Carolina 32
- Pennsylvania 31
- Ohio 30
- Alabama 29
- Michigan 25
- Florida 24
- Illinois 22
- Maryland 22
- North Carolina 20
- Arizona 18
- California 13
- Wisconsin 13
- Louisiana 11
- New York 10
- Guam 9
- Utah 9
- Iowa 8
- Virginia 8
- Colorado 7
- Kentucky 7
- Minnesota 7
- Mississippi 7
- Hawaii 5
- Oregon 5
- Delaware 3
- Massachusetts 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500789 | 2500789 | 2022-05-13 | Charles | Maryland | 24017 | 28950 | 353 |
2502142 | 2502142 | 2022-05-13 | Hamblen | Tennessee | 47063 | 19740 | 353 |
2497048 | 2497048 | 2022-05-12 | Grant | Indiana | 18053 | 17369 | 353 |
2497531 | 2497531 | 2022-05-12 | Charles | Maryland | 24017 | 28860 | 353 |
2498884 | 2498884 | 2022-05-12 | Hamblen | Tennessee | 47063 | 19740 | 353 |
2493790 | 2493790 | 2022-05-11 | Grant | Indiana | 18053 | 17369 | 353 |
2494273 | 2494273 | 2022-05-11 | Charles | Maryland | 24017 | 28808 | 353 |
2495626 | 2495626 | 2022-05-11 | Hamblen | Tennessee | 47063 | 19740 | 353 |
2491015 | 2491015 | 2022-05-10 | Charles | Maryland | 24017 | 28769 | 353 |
2492368 | 2492368 | 2022-05-10 | Hamblen | Tennessee | 47063 | 19727 | 353 |
2487758 | 2487758 | 2022-05-09 | Charles | Maryland | 24017 | 28658 | 353 |
2489110 | 2489110 | 2022-05-09 | Hamblen | Tennessee | 47063 | 19727 | 353 |
2485853 | 2485853 | 2022-05-08 | Hamblen | Tennessee | 47063 | 19727 | 353 |
2482595 | 2482595 | 2022-05-07 | Hamblen | Tennessee | 47063 | 19727 | 353 |
2479337 | 2479337 | 2022-05-06 | Hamblen | Tennessee | 47063 | 19727 | 353 |
2476079 | 2476079 | 2022-05-05 | Hamblen | Tennessee | 47063 | 19727 | 353 |
2472822 | 2472822 | 2022-05-04 | Hamblen | Tennessee | 47063 | 19727 | 353 |
2469566 | 2469566 | 2022-05-03 | Hamblen | Tennessee | 47063 | 19716 | 353 |
2466310 | 2466310 | 2022-05-02 | Hamblen | Tennessee | 47063 | 19716 | 353 |
2463055 | 2463055 | 2022-05-01 | Hamblen | Tennessee | 47063 | 19716 | 353 |
2459799 | 2459799 | 2022-04-30 | Hamblen | Tennessee | 47063 | 19716 | 353 |
2456543 | 2456543 | 2022-04-29 | Hamblen | Tennessee | 47063 | 19716 | 353 |
2453287 | 2453287 | 2022-04-28 | Hamblen | Tennessee | 47063 | 19716 | 353 |
2449620 | 2449620 | 2022-04-27 | Wood | Ohio | 39173 | 31642 | 353 |
2450031 | 2450031 | 2022-04-27 | Hamblen | Tennessee | 47063 | 19716 | 353 |
2446363 | 2446363 | 2022-04-26 | Wood | Ohio | 39173 | 31642 | 353 |
2446774 | 2446774 | 2022-04-26 | Hamblen | Tennessee | 47063 | 19709 | 353 |
2443108 | 2443108 | 2022-04-25 | Wood | Ohio | 39173 | 31642 | 353 |
2443519 | 2443519 | 2022-04-25 | Hamblen | Tennessee | 47063 | 19709 | 353 |
2439852 | 2439852 | 2022-04-24 | Wood | Ohio | 39173 | 31642 | 353 |
2440263 | 2440263 | 2022-04-24 | Hamblen | Tennessee | 47063 | 19709 | 353 |
2436596 | 2436596 | 2022-04-23 | Wood | Ohio | 39173 | 31642 | 353 |
2437007 | 2437007 | 2022-04-23 | Hamblen | Tennessee | 47063 | 19709 | 353 |
2433340 | 2433340 | 2022-04-22 | Wood | Ohio | 39173 | 31642 | 353 |
2433751 | 2433751 | 2022-04-22 | Hamblen | Tennessee | 47063 | 19709 | 353 |
2430084 | 2430084 | 2022-04-21 | Wood | Ohio | 39173 | 31642 | 353 |
2430495 | 2430495 | 2022-04-21 | Hamblen | Tennessee | 47063 | 19709 | 353 |
2427239 | 2427239 | 2022-04-20 | Hamblen | Tennessee | 47063 | 19709 | 353 |
2422654 | 2422654 | 2022-04-19 | Hampshire | Massachusetts | 25015 | 28534 | 353 |
2423983 | 2423983 | 2022-04-19 | Hamblen | Tennessee | 47063 | 19704 | 353 |
2420727 | 2420727 | 2022-04-18 | Hamblen | Tennessee | 47063 | 19704 | 353 |
2417471 | 2417471 | 2022-04-17 | Hamblen | Tennessee | 47063 | 19704 | 353 |
2414215 | 2414215 | 2022-04-16 | Hamblen | Tennessee | 47063 | 19704 | 353 |
2410959 | 2410959 | 2022-04-15 | Hamblen | Tennessee | 47063 | 19704 | 353 |
2407703 | 2407703 | 2022-04-14 | Hamblen | Tennessee | 47063 | 19704 | 353 |
2402432 | 2402432 | 2022-04-13 | Unknown | Guam | 48624 | 353 | |
2404447 | 2404447 | 2022-04-13 | Hamblen | Tennessee | 47063 | 19704 | 353 |
2399177 | 2399177 | 2022-04-12 | Unknown | Guam | 48600 | 353 | |
2395922 | 2395922 | 2022-04-11 | Unknown | Guam | 48568 | 353 | |
2396027 | 2396027 | 2022-04-11 | Macon | Illinois | 17115 | 30473 | 353 |
2392666 | 2392666 | 2022-04-10 | Unknown | Guam | 48534 | 353 | |
2392771 | 2392771 | 2022-04-10 | Macon | Illinois | 17115 | 30447 | 353 |
2389410 | 2389410 | 2022-04-09 | Unknown | Guam | 48510 | 353 | |
2389515 | 2389515 | 2022-04-09 | Macon | Illinois | 17115 | 30447 | 353 |
2386155 | 2386155 | 2022-04-08 | Unknown | Guam | 48510 | 353 | |
2386260 | 2386260 | 2022-04-08 | Macon | Illinois | 17115 | 30447 | 353 |
2387906 | 2387906 | 2022-04-08 | Indiana | Pennsylvania | 42063 | 17403 | 353 |
2388415 | 2388415 | 2022-04-08 | Orange | Texas | 48361 | 14925 | 353 |
2382900 | 2382900 | 2022-04-07 | Unknown | Guam | 48483 | 353 | |
2383005 | 2383005 | 2022-04-07 | Macon | Illinois | 17115 | 30438 | 353 |
2384651 | 2384651 | 2022-04-07 | Indiana | Pennsylvania | 42063 | 17401 | 353 |
2385160 | 2385160 | 2022-04-07 | Orange | Texas | 48361 | 14924 | 353 |
2379645 | 2379645 | 2022-04-06 | Unknown | Guam | 48431 | 353 | |
2379750 | 2379750 | 2022-04-06 | Macon | Illinois | 17115 | 30427 | 353 |
2381396 | 2381396 | 2022-04-06 | Indiana | Pennsylvania | 42063 | 17390 | 353 |
2381905 | 2381905 | 2022-04-06 | Orange | Texas | 48361 | 14924 | 353 |
2376391 | 2376391 | 2022-04-05 | Unknown | Guam | 48398 | 353 | |
2376496 | 2376496 | 2022-04-05 | Macon | Illinois | 17115 | 30414 | 353 |
2358475 | 2358475 | 2022-03-30 | Wood | Ohio | 39173 | 31378 | 353 |
2355221 | 2355221 | 2022-03-29 | Wood | Ohio | 39173 | 31378 | 353 |
2351968 | 2351968 | 2022-03-28 | Wood | Ohio | 39173 | 31378 | 353 |
2348716 | 2348716 | 2022-03-27 | Wood | Ohio | 39173 | 31378 | 353 |
2345463 | 2345463 | 2022-03-26 | Wood | Ohio | 39173 | 31378 | 353 |
2342210 | 2342210 | 2022-03-25 | Wood | Ohio | 39173 | 31378 | 353 |
2338957 | 2338957 | 2022-03-24 | Wood | Ohio | 39173 | 31378 | 353 |
2315234 | 2315234 | 2022-03-17 | Allegany | Maryland | 24001 | 17070 | 353 |
2317068 | 2317068 | 2022-03-17 | Roanoke city | Virginia | 51770 | 20971 | 353 |
2311981 | 2311981 | 2022-03-16 | Allegany | Maryland | 24001 | 17066 | 353 |
2308728 | 2308728 | 2022-03-15 | Allegany | Maryland | 24001 | 17062 | 353 |
2310086 | 2310086 | 2022-03-15 | Greene | Tennessee | 47059 | 21952 | 353 |
2305477 | 2305477 | 2022-03-14 | Allegany | Maryland | 24001 | 17062 | 353 |
2306833 | 2306833 | 2022-03-14 | Greene | Tennessee | 47059 | 21952 | 353 |
2302225 | 2302225 | 2022-03-13 | Allegany | Maryland | 24001 | 17062 | 353 |
2303582 | 2303582 | 2022-03-13 | Greene | Tennessee | 47059 | 21952 | 353 |
2298973 | 2298973 | 2022-03-12 | Allegany | Maryland | 24001 | 17059 | 353 |
2300330 | 2300330 | 2022-03-12 | Greene | Tennessee | 47059 | 21952 | 353 |
2297078 | 2297078 | 2022-03-11 | Greene | Tennessee | 47059 | 21952 | 353 |
2293826 | 2293826 | 2022-03-10 | Greene | Tennessee | 47059 | 21952 | 353 |
2290574 | 2290574 | 2022-03-09 | Greene | Tennessee | 47059 | 21952 | 353 |
2278316 | 2278316 | 2022-03-06 | Talladega | Alabama | 1121 | 22132 | 353 |
2275063 | 2275063 | 2022-03-05 | Talladega | Alabama | 1121 | 22132 | 353 |
2271810 | 2271810 | 2022-03-04 | Talladega | Alabama | 1121 | 22132 | 353 |
2270766 | 2270766 | 2022-03-03 | Adams | Pennsylvania | 42001 | 24592 | 353 |
2267514 | 2267514 | 2022-03-02 | Adams | Pennsylvania | 42001 | 24578 | 353 |
2267989 | 2267989 | 2022-03-02 | Hunt | Texas | 48231 | 15666 | 353 |
2239664 | 2239664 | 2022-02-22 | Columbia | Georgia | 13073 | 35259 | 353 |
2240389 | 2240389 | 2022-02-22 | Lafourche | Louisiana | 22057 | 27540 | 353 |
2240638 | 2240638 | 2022-02-22 | Stearns | Minnesota | 27145 | 49825 | 353 |
2240691 | 2240691 | 2022-02-22 | Lauderdale | Mississippi | 28075 | 18635 | 353 |
2241663 | 2241663 | 2022-02-22 | Beaufort | South Carolina | 45013 | 42554 | 353 |
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);