ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,315 rows where deaths = 214 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 134
- Texas 98
- Tennessee 72
- Virginia 72
- Georgia 70
- Alabama 63
- Wisconsin 51
- Indiana 47
- North Carolina 47
- South Carolina 44
- Pennsylvania 42
- Michigan 39
- Missouri 38
- Illinois 36
- Oklahoma 36
- California 35
- New Jersey 35
- Maryland 34
- Utah 29
- Louisiana 27
- Kentucky 25
- Oregon 24
- Washington 23
- Arizona 19
- Iowa 18
- Arkansas 16
- Florida 16
- Mississippi 15
- New Mexico 13
- Montana 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502448 | 2502448 | 2022-05-13 | Wharton | Texas | 48481 | 9175 | 214 |
2502653 | 2502653 | 2022-05-13 | Franklin | Washington | 53021 | 32668 | 214 |
2497863 | 2497863 | 2022-05-12 | Howell | Missouri | 29091 | 9165 | 214 |
2499190 | 2499190 | 2022-05-12 | Wharton | Texas | 48481 | 9171 | 214 |
2499395 | 2499395 | 2022-05-12 | Franklin | Washington | 53021 | 32654 | 214 |
2494605 | 2494605 | 2022-05-11 | Howell | Missouri | 29091 | 9165 | 214 |
2495144 | 2495144 | 2022-05-11 | Crawford | Ohio | 39033 | 11224 | 214 |
2495932 | 2495932 | 2022-05-11 | Wharton | Texas | 48481 | 9170 | 214 |
2496137 | 2496137 | 2022-05-11 | Franklin | Washington | 53021 | 32654 | 214 |
2491347 | 2491347 | 2022-05-10 | Howell | Missouri | 29091 | 9165 | 214 |
2491886 | 2491886 | 2022-05-10 | Crawford | Ohio | 39033 | 11224 | 214 |
2492674 | 2492674 | 2022-05-10 | Wharton | Texas | 48481 | 9165 | 214 |
2492879 | 2492879 | 2022-05-10 | Franklin | Washington | 53021 | 32645 | 214 |
2488089 | 2488089 | 2022-05-09 | Howell | Missouri | 29091 | 9165 | 214 |
2488628 | 2488628 | 2022-05-09 | Crawford | Ohio | 39033 | 11224 | 214 |
2489416 | 2489416 | 2022-05-09 | Wharton | Texas | 48481 | 9163 | 214 |
2489621 | 2489621 | 2022-05-09 | Franklin | Washington | 53021 | 32645 | 214 |
2484832 | 2484832 | 2022-05-08 | Howell | Missouri | 29091 | 9165 | 214 |
2485371 | 2485371 | 2022-05-08 | Crawford | Ohio | 39033 | 11224 | 214 |
2486158 | 2486158 | 2022-05-08 | Wharton | Texas | 48481 | 9163 | 214 |
2481574 | 2481574 | 2022-05-07 | Howell | Missouri | 29091 | 9165 | 214 |
2482113 | 2482113 | 2022-05-07 | Crawford | Ohio | 39033 | 11224 | 214 |
2482900 | 2482900 | 2022-05-07 | Wharton | Texas | 48481 | 9160 | 214 |
2478316 | 2478316 | 2022-05-06 | Howell | Missouri | 29091 | 9165 | 214 |
2478855 | 2478855 | 2022-05-06 | Crawford | Ohio | 39033 | 11224 | 214 |
2479642 | 2479642 | 2022-05-06 | Wharton | Texas | 48481 | 9156 | 214 |
2475058 | 2475058 | 2022-05-05 | Howell | Missouri | 29091 | 9145 | 214 |
2475597 | 2475597 | 2022-05-05 | Crawford | Ohio | 39033 | 11224 | 214 |
2476384 | 2476384 | 2022-05-05 | Wharton | Texas | 48481 | 9155 | 214 |
2472340 | 2472340 | 2022-05-04 | Crawford | Ohio | 39033 | 11204 | 214 |
2473127 | 2473127 | 2022-05-04 | Wharton | Texas | 48481 | 9150 | 214 |
2469084 | 2469084 | 2022-05-03 | Crawford | Ohio | 39033 | 11204 | 214 |
2469871 | 2469871 | 2022-05-03 | Wharton | Texas | 48481 | 9147 | 214 |
2464969 | 2464969 | 2022-05-02 | St. Mary's | Maryland | 24037 | 19081 | 214 |
2465828 | 2465828 | 2022-05-02 | Crawford | Ohio | 39033 | 11204 | 214 |
2466615 | 2466615 | 2022-05-02 | Wharton | Texas | 48481 | 9147 | 214 |
2466802 | 2466802 | 2022-05-02 | Washington | Virginia | 51191 | 13852 | 214 |
2461713 | 2461713 | 2022-05-01 | St. Mary's | Maryland | 24037 | 19066 | 214 |
2462573 | 2462573 | 2022-05-01 | Crawford | Ohio | 39033 | 11204 | 214 |
2463360 | 2463360 | 2022-05-01 | Wharton | Texas | 48481 | 9147 | 214 |
2463440 | 2463440 | 2022-05-01 | Campbell | Virginia | 51031 | 12635 | 214 |
2463547 | 2463547 | 2022-05-01 | Washington | Virginia | 51191 | 13830 | 214 |
2458457 | 2458457 | 2022-04-30 | St. Mary's | Maryland | 24037 | 19066 | 214 |
2459317 | 2459317 | 2022-04-30 | Crawford | Ohio | 39033 | 11204 | 214 |
2460104 | 2460104 | 2022-04-30 | Wharton | Texas | 48481 | 9147 | 214 |
2460184 | 2460184 | 2022-04-30 | Campbell | Virginia | 51031 | 12635 | 214 |
2460291 | 2460291 | 2022-04-30 | Washington | Virginia | 51191 | 13830 | 214 |
2455201 | 2455201 | 2022-04-29 | St. Mary's | Maryland | 24037 | 19066 | 214 |
2456061 | 2456061 | 2022-04-29 | Crawford | Ohio | 39033 | 11204 | 214 |
2456848 | 2456848 | 2022-04-29 | Wharton | Texas | 48481 | 9147 | 214 |
2456928 | 2456928 | 2022-04-29 | Campbell | Virginia | 51031 | 12635 | 214 |
2457035 | 2457035 | 2022-04-29 | Washington | Virginia | 51191 | 13830 | 214 |
2451945 | 2451945 | 2022-04-28 | St. Mary's | Maryland | 24037 | 19045 | 214 |
2452805 | 2452805 | 2022-04-28 | Crawford | Ohio | 39033 | 11204 | 214 |
2453592 | 2453592 | 2022-04-28 | Wharton | Texas | 48481 | 9144 | 214 |
2453672 | 2453672 | 2022-04-28 | Campbell | Virginia | 51031 | 12572 | 214 |
2453779 | 2453779 | 2022-04-28 | Washington | Virginia | 51191 | 13824 | 214 |
2453797 | 2453797 | 2022-04-28 | Franklin | Washington | 53021 | 32554 | 214 |
2449549 | 2449549 | 2022-04-27 | Crawford | Ohio | 39033 | 11186 | 214 |
2450336 | 2450336 | 2022-04-27 | Wharton | Texas | 48481 | 9139 | 214 |
2450416 | 2450416 | 2022-04-27 | Campbell | Virginia | 51031 | 12565 | 214 |
2450523 | 2450523 | 2022-04-27 | Washington | Virginia | 51191 | 13824 | 214 |
2450541 | 2450541 | 2022-04-27 | Franklin | Washington | 53021 | 32554 | 214 |
2446292 | 2446292 | 2022-04-26 | Crawford | Ohio | 39033 | 11186 | 214 |
2447079 | 2447079 | 2022-04-26 | Wharton | Texas | 48481 | 9139 | 214 |
2447159 | 2447159 | 2022-04-26 | Campbell | Virginia | 51031 | 12520 | 214 |
2447267 | 2447267 | 2022-04-26 | Washington | Virginia | 51191 | 13814 | 214 |
2447285 | 2447285 | 2022-04-26 | Franklin | Washington | 53021 | 32537 | 214 |
2443037 | 2443037 | 2022-04-25 | Crawford | Ohio | 39033 | 11186 | 214 |
2444011 | 2444011 | 2022-04-25 | Washington | Virginia | 51191 | 13799 | 214 |
2444029 | 2444029 | 2022-04-25 | Franklin | Washington | 53021 | 32537 | 214 |
2439781 | 2439781 | 2022-04-24 | Crawford | Ohio | 39033 | 11186 | 214 |
2440755 | 2440755 | 2022-04-24 | Washington | Virginia | 51191 | 13793 | 214 |
2440773 | 2440773 | 2022-04-24 | Franklin | Washington | 53021 | 32519 | 214 |
2436525 | 2436525 | 2022-04-23 | Crawford | Ohio | 39033 | 11186 | 214 |
2437499 | 2437499 | 2022-04-23 | Washington | Virginia | 51191 | 13793 | 214 |
2437517 | 2437517 | 2022-04-23 | Franklin | Washington | 53021 | 32519 | 214 |
2433269 | 2433269 | 2022-04-22 | Crawford | Ohio | 39033 | 11186 | 214 |
2434243 | 2434243 | 2022-04-22 | Washington | Virginia | 51191 | 13793 | 214 |
2434261 | 2434261 | 2022-04-22 | Franklin | Washington | 53021 | 32519 | 214 |
2430013 | 2430013 | 2022-04-21 | Crawford | Ohio | 39033 | 11186 | 214 |
2430987 | 2430987 | 2022-04-21 | Washington | Virginia | 51191 | 13787 | 214 |
2431005 | 2431005 | 2022-04-21 | Franklin | Washington | 53021 | 32511 | 214 |
2426757 | 2426757 | 2022-04-20 | Crawford | Ohio | 39033 | 11181 | 214 |
2427731 | 2427731 | 2022-04-20 | Washington | Virginia | 51191 | 13783 | 214 |
2427749 | 2427749 | 2022-04-20 | Franklin | Washington | 53021 | 32511 | 214 |
2423501 | 2423501 | 2022-04-19 | Crawford | Ohio | 39033 | 11181 | 214 |
2423681 | 2423681 | 2022-04-19 | Umatilla | Oregon | 41059 | 22383 | 214 |
2423966 | 2423966 | 2022-04-19 | Cocke | Tennessee | 47029 | 11579 | 214 |
2424475 | 2424475 | 2022-04-19 | Washington | Virginia | 51191 | 13774 | 214 |
2418160 | 2418160 | 2022-04-18 | Autauga | Alabama | 1001 | 15752 | 214 |
2420244 | 2420244 | 2022-04-18 | Crawford | Ohio | 39033 | 11181 | 214 |
2420424 | 2420424 | 2022-04-18 | Umatilla | Oregon | 41059 | 22369 | 214 |
2420710 | 2420710 | 2022-04-18 | Cocke | Tennessee | 47029 | 11579 | 214 |
2421219 | 2421219 | 2022-04-18 | Washington | Virginia | 51191 | 13764 | 214 |
2414904 | 2414904 | 2022-04-17 | Autauga | Alabama | 1001 | 15752 | 214 |
2416989 | 2416989 | 2022-04-17 | Crawford | Ohio | 39033 | 11181 | 214 |
2417169 | 2417169 | 2022-04-17 | Umatilla | Oregon | 41059 | 22369 | 214 |
2417454 | 2417454 | 2022-04-17 | Cocke | Tennessee | 47029 | 11579 | 214 |
2417846 | 2417846 | 2022-04-17 | Augusta | Virginia | 51015 | 19035 | 214 |
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);