ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,055 rows where deaths = 259 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 74
- Maryland 54
- Ohio 53
- Texas 52
- Indiana 51
- Arkansas 48
- North Carolina 47
- Tennessee 46
- Illinois 43
- Washington 43
- California 42
- Virginia 41
- Alabama 37
- Florida 33
- Pennsylvania 32
- South Carolina 30
- Louisiana 28
- New York 28
- Minnesota 27
- New Mexico 26
- Wisconsin 26
- Oregon 22
- Mississippi 21
- Arizona 15
- Connecticut 14
- Colorado 13
- Michigan 13
- Idaho 9
- Missouri 9
- New Hampshire 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500788 | 2500788 | 2022-05-13 | Cecil | Maryland | 24015 | 15906 | 259 |
2501466 | 2501466 | 2022-05-13 | Rensselaer | New York | 36083 | 33850 | 259 |
2502655 | 2502655 | 2022-05-13 | Grant | Washington | 53025 | 27251 | 259 |
2497530 | 2497530 | 2022-05-12 | Cecil | Maryland | 24015 | 15873 | 259 |
2499397 | 2499397 | 2022-05-12 | Grant | Washington | 53025 | 27251 | 259 |
2494272 | 2494272 | 2022-05-11 | Cecil | Maryland | 24015 | 15853 | 259 |
2496139 | 2496139 | 2022-05-11 | Grant | Washington | 53025 | 27146 | 259 |
2491014 | 2491014 | 2022-05-10 | Cecil | Maryland | 24015 | 15825 | 259 |
2492363 | 2492363 | 2022-05-10 | Gibson | Tennessee | 47053 | 17444 | 259 |
2492881 | 2492881 | 2022-05-10 | Grant | Washington | 53025 | 27146 | 259 |
2487757 | 2487757 | 2022-05-09 | Cecil | Maryland | 24015 | 15760 | 259 |
2489105 | 2489105 | 2022-05-09 | Gibson | Tennessee | 47053 | 17444 | 259 |
2489623 | 2489623 | 2022-05-09 | Grant | Washington | 53025 | 27146 | 259 |
2484499 | 2484499 | 2022-05-08 | Cecil | Maryland | 24015 | 15739 | 259 |
2485848 | 2485848 | 2022-05-08 | Gibson | Tennessee | 47053 | 17444 | 259 |
2486366 | 2486366 | 2022-05-08 | Grant | Washington | 53025 | 27146 | 259 |
2481241 | 2481241 | 2022-05-07 | Cecil | Maryland | 24015 | 15739 | 259 |
2482590 | 2482590 | 2022-05-07 | Gibson | Tennessee | 47053 | 17444 | 259 |
2483108 | 2483108 | 2022-05-07 | Grant | Washington | 53025 | 27146 | 259 |
2477983 | 2477983 | 2022-05-06 | Cecil | Maryland | 24015 | 15739 | 259 |
2479332 | 2479332 | 2022-05-06 | Gibson | Tennessee | 47053 | 17444 | 259 |
2479850 | 2479850 | 2022-05-06 | Grant | Washington | 53025 | 27146 | 259 |
2474725 | 2474725 | 2022-05-05 | Cecil | Maryland | 24015 | 15731 | 259 |
2476074 | 2476074 | 2022-05-05 | Gibson | Tennessee | 47053 | 17444 | 259 |
2476592 | 2476592 | 2022-05-05 | Grant | Washington | 53025 | 27146 | 259 |
2471468 | 2471468 | 2022-05-04 | Cecil | Maryland | 24015 | 15705 | 259 |
2472817 | 2472817 | 2022-05-04 | Gibson | Tennessee | 47053 | 17444 | 259 |
2473334 | 2473334 | 2022-05-04 | Grant | Washington | 53025 | 27146 | 259 |
2468212 | 2468212 | 2022-05-03 | Cecil | Maryland | 24015 | 15693 | 259 |
2469006 | 2469006 | 2022-05-03 | Wilkes | North Carolina | 37193 | 17556 | 259 |
2469561 | 2469561 | 2022-05-03 | Gibson | Tennessee | 47053 | 17426 | 259 |
2470078 | 2470078 | 2022-05-03 | Grant | Washington | 53025 | 27123 | 259 |
2464957 | 2464957 | 2022-05-02 | Cecil | Maryland | 24015 | 15667 | 259 |
2465750 | 2465750 | 2022-05-02 | Wilkes | North Carolina | 37193 | 17556 | 259 |
2466305 | 2466305 | 2022-05-02 | Gibson | Tennessee | 47053 | 17426 | 259 |
2466822 | 2466822 | 2022-05-02 | Grant | Washington | 53025 | 27123 | 259 |
2462495 | 2462495 | 2022-05-01 | Wilkes | North Carolina | 37193 | 17556 | 259 |
2463050 | 2463050 | 2022-05-01 | Gibson | Tennessee | 47053 | 17426 | 259 |
2463567 | 2463567 | 2022-05-01 | Grant | Washington | 53025 | 27123 | 259 |
2459239 | 2459239 | 2022-04-30 | Wilkes | North Carolina | 37193 | 17556 | 259 |
2459794 | 2459794 | 2022-04-30 | Gibson | Tennessee | 47053 | 17426 | 259 |
2460311 | 2460311 | 2022-04-30 | Grant | Washington | 53025 | 27123 | 259 |
2455983 | 2455983 | 2022-04-29 | Wilkes | North Carolina | 37193 | 17556 | 259 |
2456538 | 2456538 | 2022-04-29 | Gibson | Tennessee | 47053 | 17426 | 259 |
2457055 | 2457055 | 2022-04-29 | Grant | Washington | 53025 | 27123 | 259 |
2451471 | 2451471 | 2022-04-28 | Lawrence | Indiana | 18093 | 11922 | 259 |
2452727 | 2452727 | 2022-04-28 | Wilkes | North Carolina | 37193 | 17556 | 259 |
2453282 | 2453282 | 2022-04-28 | Gibson | Tennessee | 47053 | 17426 | 259 |
2453799 | 2453799 | 2022-04-28 | Grant | Washington | 53025 | 27094 | 259 |
2448215 | 2448215 | 2022-04-27 | Lawrence | Indiana | 18093 | 11922 | 259 |
2449471 | 2449471 | 2022-04-27 | Wilkes | North Carolina | 37193 | 17556 | 259 |
2450026 | 2450026 | 2022-04-27 | Gibson | Tennessee | 47053 | 17426 | 259 |
2450543 | 2450543 | 2022-04-27 | Grant | Washington | 53025 | 27094 | 259 |
2444959 | 2444959 | 2022-04-26 | Lawrence | Indiana | 18093 | 11910 | 259 |
2446769 | 2446769 | 2022-04-26 | Gibson | Tennessee | 47053 | 17415 | 259 |
2447287 | 2447287 | 2022-04-26 | Grant | Washington | 53025 | 27094 | 259 |
2441703 | 2441703 | 2022-04-25 | Lawrence | Indiana | 18093 | 11910 | 259 |
2443514 | 2443514 | 2022-04-25 | Gibson | Tennessee | 47053 | 17415 | 259 |
2444031 | 2444031 | 2022-04-25 | Grant | Washington | 53025 | 27094 | 259 |
2438447 | 2438447 | 2022-04-24 | Lawrence | Indiana | 18093 | 11885 | 259 |
2440258 | 2440258 | 2022-04-24 | Gibson | Tennessee | 47053 | 17415 | 259 |
2440775 | 2440775 | 2022-04-24 | Grant | Washington | 53025 | 27094 | 259 |
2435191 | 2435191 | 2022-04-23 | Lawrence | Indiana | 18093 | 11885 | 259 |
2437002 | 2437002 | 2022-04-23 | Gibson | Tennessee | 47053 | 17415 | 259 |
2437519 | 2437519 | 2022-04-23 | Grant | Washington | 53025 | 27094 | 259 |
2431935 | 2431935 | 2022-04-22 | Lawrence | Indiana | 18093 | 11885 | 259 |
2433746 | 2433746 | 2022-04-22 | Gibson | Tennessee | 47053 | 17415 | 259 |
2434263 | 2434263 | 2022-04-22 | Grant | Washington | 53025 | 27094 | 259 |
2428679 | 2428679 | 2022-04-21 | Lawrence | Indiana | 18093 | 11877 | 259 |
2430490 | 2430490 | 2022-04-21 | Gibson | Tennessee | 47053 | 17415 | 259 |
2431007 | 2431007 | 2022-04-21 | Grant | Washington | 53025 | 27064 | 259 |
2425423 | 2425423 | 2022-04-20 | Lawrence | Indiana | 18093 | 11877 | 259 |
2427234 | 2427234 | 2022-04-20 | Gibson | Tennessee | 47053 | 17415 | 259 |
2427751 | 2427751 | 2022-04-20 | Grant | Washington | 53025 | 27064 | 259 |
2422167 | 2422167 | 2022-04-19 | Lawrence | Indiana | 18093 | 11866 | 259 |
2424010 | 2424010 | 2022-04-19 | McMinn | Tennessee | 47107 | 16680 | 259 |
2424495 | 2424495 | 2022-04-19 | Grant | Washington | 53025 | 27064 | 259 |
2418911 | 2418911 | 2022-04-18 | Lawrence | Indiana | 18093 | 11866 | 259 |
2420754 | 2420754 | 2022-04-18 | McMinn | Tennessee | 47107 | 16680 | 259 |
2421239 | 2421239 | 2022-04-18 | Grant | Washington | 53025 | 27064 | 259 |
2415655 | 2415655 | 2022-04-17 | Lawrence | Indiana | 18093 | 11853 | 259 |
2417498 | 2417498 | 2022-04-17 | McMinn | Tennessee | 47107 | 16680 | 259 |
2417983 | 2417983 | 2022-04-17 | Grant | Washington | 53025 | 27064 | 259 |
2412399 | 2412399 | 2022-04-16 | Lawrence | Indiana | 18093 | 11853 | 259 |
2414242 | 2414242 | 2022-04-16 | McMinn | Tennessee | 47107 | 16680 | 259 |
2414727 | 2414727 | 2022-04-16 | Grant | Washington | 53025 | 27064 | 259 |
2409143 | 2409143 | 2022-04-15 | Lawrence | Indiana | 18093 | 11853 | 259 |
2410986 | 2410986 | 2022-04-15 | McMinn | Tennessee | 47107 | 16680 | 259 |
2411471 | 2411471 | 2022-04-15 | Grant | Washington | 53025 | 27064 | 259 |
2405887 | 2405887 | 2022-04-14 | Lawrence | Indiana | 18093 | 11853 | 259 |
2406534 | 2406534 | 2022-04-14 | Scott | Minnesota | 27139 | 40217 | 259 |
2407730 | 2407730 | 2022-04-14 | McMinn | Tennessee | 47107 | 16680 | 259 |
2408215 | 2408215 | 2022-04-14 | Grant | Washington | 53025 | 27064 | 259 |
2402111 | 2402111 | 2022-04-13 | Santa Cruz | California | 6087 | 49711 | 259 |
2402632 | 2402632 | 2022-04-13 | Lawrence | Indiana | 18093 | 11853 | 259 |
2403278 | 2403278 | 2022-04-13 | Scott | Minnesota | 27139 | 40190 | 259 |
2404474 | 2404474 | 2022-04-13 | McMinn | Tennessee | 47107 | 16680 | 259 |
2404959 | 2404959 | 2022-04-13 | Grant | Washington | 53025 | 27064 | 259 |
2398856 | 2398856 | 2022-04-12 | Santa Cruz | California | 6087 | 49711 | 259 |
2399377 | 2399377 | 2022-04-12 | Lawrence | Indiana | 18093 | 11849 | 259 |
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);