ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,474 rows where deaths = 154 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 394
- Tennessee 161
- Georgia 152
- Ohio 130
- Indiana 129
- Virginia 113
- New York 110
- Pennsylvania 96
- Alabama 79
- Michigan 75
- Missouri 72
- North Carolina 71
- South Carolina 65
- Kentucky 63
- Illinois 62
- Mississippi 62
- West Virginia 59
- Kansas 50
- Florida 49
- Maryland 48
- Louisiana 46
- Wisconsin 45
- Idaho 44
- Washington 37
- Arkansas 35
- Montana 24
- California 21
- Minnesota 20
- New Mexico 19
- Arizona 18
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500010 | 2500010 | 2022-05-13 | Dodge | Georgia | 13091 | 5244 | 154 |
2500138 | 2500138 | 2022-05-13 | Bingham | Idaho | 16011 | 9836 | 154 |
2500293 | 2500293 | 2022-05-13 | Daviess | Indiana | 18027 | 7496 | 154 |
2500535 | 2500535 | 2022-05-13 | Montgomery | Kansas | 20125 | 9448 | 154 |
2501518 | 2501518 | 2022-05-13 | Edgecombe | North Carolina | 37065 | 13616 | 154 |
2501906 | 2501906 | 2022-05-13 | Union | Pennsylvania | 42119 | 11842 | 154 |
2502388 | 2502388 | 2022-05-13 | Palo Pinto | Texas | 48363 | 7052 | 154 |
2502591 | 2502591 | 2022-05-13 | Montgomery | Virginia | 51121 | 19403 | 154 |
2496752 | 2496752 | 2022-05-12 | Dodge | Georgia | 13091 | 5244 | 154 |
2496880 | 2496880 | 2022-05-12 | Bingham | Idaho | 16011 | 9833 | 154 |
2497035 | 2497035 | 2022-05-12 | Daviess | Indiana | 18027 | 7493 | 154 |
2497277 | 2497277 | 2022-05-12 | Montgomery | Kansas | 20125 | 9435 | 154 |
2498171 | 2498171 | 2022-05-12 | Allegany | New York | 36003 | 9275 | 154 |
2498260 | 2498260 | 2022-05-12 | Edgecombe | North Carolina | 37065 | 13616 | 154 |
2498648 | 2498648 | 2022-05-12 | Union | Pennsylvania | 42119 | 11842 | 154 |
2499130 | 2499130 | 2022-05-12 | Palo Pinto | Texas | 48363 | 7050 | 154 |
2499333 | 2499333 | 2022-05-12 | Montgomery | Virginia | 51121 | 19362 | 154 |
2493494 | 2493494 | 2022-05-11 | Dodge | Georgia | 13091 | 5244 | 154 |
2493622 | 2493622 | 2022-05-11 | Bingham | Idaho | 16011 | 9831 | 154 |
2493777 | 2493777 | 2022-05-11 | Daviess | Indiana | 18027 | 7493 | 154 |
2494019 | 2494019 | 2022-05-11 | Montgomery | Kansas | 20125 | 9435 | 154 |
2494913 | 2494913 | 2022-05-11 | Allegany | New York | 36003 | 9258 | 154 |
2495002 | 2495002 | 2022-05-11 | Edgecombe | North Carolina | 37065 | 13616 | 154 |
2495390 | 2495390 | 2022-05-11 | Union | Pennsylvania | 42119 | 11842 | 154 |
2495872 | 2495872 | 2022-05-11 | Palo Pinto | Texas | 48363 | 7048 | 154 |
2496075 | 2496075 | 2022-05-11 | Montgomery | Virginia | 51121 | 19304 | 154 |
2490364 | 2490364 | 2022-05-10 | Bingham | Idaho | 16011 | 9829 | 154 |
2490519 | 2490519 | 2022-05-10 | Daviess | Indiana | 18027 | 7495 | 154 |
2490761 | 2490761 | 2022-05-10 | Montgomery | Kansas | 20125 | 9435 | 154 |
2491655 | 2491655 | 2022-05-10 | Allegany | New York | 36003 | 9243 | 154 |
2492132 | 2492132 | 2022-05-10 | Union | Pennsylvania | 42119 | 11797 | 154 |
2492614 | 2492614 | 2022-05-10 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2492817 | 2492817 | 2022-05-10 | Montgomery | Virginia | 51121 | 19256 | 154 |
2492933 | 2492933 | 2022-05-10 | Marshall | West Virginia | 54051 | 9065 | 154 |
2487107 | 2487107 | 2022-05-09 | Bingham | Idaho | 16011 | 9828 | 154 |
2487262 | 2487262 | 2022-05-09 | Daviess | Indiana | 18027 | 7495 | 154 |
2487504 | 2487504 | 2022-05-09 | Montgomery | Kansas | 20125 | 9435 | 154 |
2488397 | 2488397 | 2022-05-09 | Allegany | New York | 36003 | 9234 | 154 |
2488874 | 2488874 | 2022-05-09 | Union | Pennsylvania | 42119 | 11797 | 154 |
2489356 | 2489356 | 2022-05-09 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2489675 | 2489675 | 2022-05-09 | Marshall | West Virginia | 54051 | 9065 | 154 |
2483849 | 2483849 | 2022-05-08 | Bingham | Idaho | 16011 | 9824 | 154 |
2484004 | 2484004 | 2022-05-08 | Daviess | Indiana | 18027 | 7489 | 154 |
2484246 | 2484246 | 2022-05-08 | Montgomery | Kansas | 20125 | 9435 | 154 |
2485140 | 2485140 | 2022-05-08 | Allegany | New York | 36003 | 9226 | 154 |
2485617 | 2485617 | 2022-05-08 | Union | Pennsylvania | 42119 | 11797 | 154 |
2486099 | 2486099 | 2022-05-08 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2486418 | 2486418 | 2022-05-08 | Marshall | West Virginia | 54051 | 9050 | 154 |
2480591 | 2480591 | 2022-05-07 | Bingham | Idaho | 16011 | 9824 | 154 |
2480746 | 2480746 | 2022-05-07 | Daviess | Indiana | 18027 | 7489 | 154 |
2480988 | 2480988 | 2022-05-07 | Montgomery | Kansas | 20125 | 9435 | 154 |
2481882 | 2481882 | 2022-05-07 | Allegany | New York | 36003 | 9212 | 154 |
2482359 | 2482359 | 2022-05-07 | Union | Pennsylvania | 42119 | 11797 | 154 |
2482841 | 2482841 | 2022-05-07 | Palo Pinto | Texas | 48363 | 7047 | 154 |
2483160 | 2483160 | 2022-05-07 | Marshall | West Virginia | 54051 | 9050 | 154 |
2477333 | 2477333 | 2022-05-06 | Bingham | Idaho | 16011 | 9824 | 154 |
2477488 | 2477488 | 2022-05-06 | Daviess | Indiana | 18027 | 7489 | 154 |
2477730 | 2477730 | 2022-05-06 | Montgomery | Kansas | 20125 | 9435 | 154 |
2478624 | 2478624 | 2022-05-06 | Allegany | New York | 36003 | 9185 | 154 |
2479101 | 2479101 | 2022-05-06 | Union | Pennsylvania | 42119 | 11797 | 154 |
2479583 | 2479583 | 2022-05-06 | Palo Pinto | Texas | 48363 | 7045 | 154 |
2479902 | 2479902 | 2022-05-06 | Marshall | West Virginia | 54051 | 9050 | 154 |
2474075 | 2474075 | 2022-05-05 | Bingham | Idaho | 16011 | 9824 | 154 |
2474230 | 2474230 | 2022-05-05 | Daviess | Indiana | 18027 | 7489 | 154 |
2474472 | 2474472 | 2022-05-05 | Montgomery | Kansas | 20125 | 9428 | 154 |
2475366 | 2475366 | 2022-05-05 | Allegany | New York | 36003 | 9168 | 154 |
2475843 | 2475843 | 2022-05-05 | Union | Pennsylvania | 42119 | 11797 | 154 |
2476325 | 2476325 | 2022-05-05 | Palo Pinto | Texas | 48363 | 7045 | 154 |
2476644 | 2476644 | 2022-05-05 | Marshall | West Virginia | 54051 | 9048 | 154 |
2470818 | 2470818 | 2022-05-04 | Bingham | Idaho | 16011 | 9824 | 154 |
2470973 | 2470973 | 2022-05-04 | Daviess | Indiana | 18027 | 7489 | 154 |
2471215 | 2471215 | 2022-05-04 | Montgomery | Kansas | 20125 | 9428 | 154 |
2472109 | 2472109 | 2022-05-04 | Allegany | New York | 36003 | 9147 | 154 |
2472586 | 2472586 | 2022-05-04 | Union | Pennsylvania | 42119 | 11797 | 154 |
2473068 | 2473068 | 2022-05-04 | Palo Pinto | Texas | 48363 | 7044 | 154 |
2473386 | 2473386 | 2022-05-04 | Marshall | West Virginia | 54051 | 9043 | 154 |
2467562 | 2467562 | 2022-05-03 | Bingham | Idaho | 16011 | 9824 | 154 |
2467717 | 2467717 | 2022-05-03 | Daviess | Indiana | 18027 | 7484 | 154 |
2467959 | 2467959 | 2022-05-03 | Montgomery | Kansas | 20125 | 9428 | 154 |
2468853 | 2468853 | 2022-05-03 | Allegany | New York | 36003 | 9123 | 154 |
2469330 | 2469330 | 2022-05-03 | Union | Pennsylvania | 42119 | 11795 | 154 |
2469812 | 2469812 | 2022-05-03 | Palo Pinto | Texas | 48363 | 7044 | 154 |
2470129 | 2470129 | 2022-05-03 | Marshall | West Virginia | 54051 | 9037 | 154 |
2464307 | 2464307 | 2022-05-02 | Bingham | Idaho | 16011 | 9824 | 154 |
2464462 | 2464462 | 2022-05-02 | Daviess | Indiana | 18027 | 7484 | 154 |
2464704 | 2464704 | 2022-05-02 | Montgomery | Kansas | 20125 | 9428 | 154 |
2465597 | 2465597 | 2022-05-02 | Allegany | New York | 36003 | 9109 | 154 |
2466074 | 2466074 | 2022-05-02 | Union | Pennsylvania | 42119 | 11791 | 154 |
2466556 | 2466556 | 2022-05-02 | Palo Pinto | Texas | 48363 | 7044 | 154 |
2466873 | 2466873 | 2022-05-02 | Marshall | West Virginia | 54051 | 9031 | 154 |
2461051 | 2461051 | 2022-05-01 | Bingham | Idaho | 16011 | 9823 | 154 |
2461206 | 2461206 | 2022-05-01 | Daviess | Indiana | 18027 | 7482 | 154 |
2461448 | 2461448 | 2022-05-01 | Montgomery | Kansas | 20125 | 9428 | 154 |
2462342 | 2462342 | 2022-05-01 | Allegany | New York | 36003 | 9108 | 154 |
2462819 | 2462819 | 2022-05-01 | Union | Pennsylvania | 42119 | 11788 | 154 |
2463301 | 2463301 | 2022-05-01 | Palo Pinto | Texas | 48363 | 7044 | 154 |
2463618 | 2463618 | 2022-05-01 | Marshall | West Virginia | 54051 | 9022 | 154 |
2457795 | 2457795 | 2022-04-30 | Bingham | Idaho | 16011 | 9823 | 154 |
2457950 | 2457950 | 2022-04-30 | Daviess | Indiana | 18027 | 7482 | 154 |
2458192 | 2458192 | 2022-04-30 | Montgomery | Kansas | 20125 | 9428 | 154 |
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);