ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
929 rows where deaths = 265 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 127
- Ohio 76
- Georgia 72
- North Carolina 54
- Virginia 46
- Tennessee 41
- Illinois 35
- Pennsylvania 35
- Indiana 32
- West Virginia 31
- California 26
- Mississippi 26
- Maryland 23
- Missouri 23
- Alabama 22
- New Mexico 22
- South Carolina 19
- Arkansas 18
- Colorado 16
- Washington 15
- Florida 14
- Wyoming 14
- Maine 13
- Michigan 12
- Iowa 11
- Montana 10
- Louisiana 9
- New York 9
- Wisconsin 9
- Arizona 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501671 | 2501671 | 2022-05-13 | Geauga | Ohio | 39055 | 16413 | 265 |
2502155 | 2502155 | 2022-05-13 | Jefferson | Tennessee | 47089 | 15804 | 265 |
2498413 | 2498413 | 2022-05-12 | Geauga | Ohio | 39055 | 16413 | 265 |
2498897 | 2498897 | 2022-05-12 | Jefferson | Tennessee | 47089 | 15804 | 265 |
2495639 | 2495639 | 2022-05-11 | Jefferson | Tennessee | 47089 | 15804 | 265 |
2495890 | 2495890 | 2022-05-11 | Rockwall | Texas | 48397 | 26753 | 265 |
2496194 | 2496194 | 2022-05-11 | Mercer | West Virginia | 54055 | 17154 | 265 |
2492381 | 2492381 | 2022-05-10 | Jefferson | Tennessee | 47089 | 15775 | 265 |
2492632 | 2492632 | 2022-05-10 | Rockwall | Texas | 48397 | 26742 | 265 |
2492936 | 2492936 | 2022-05-10 | Mercer | West Virginia | 54055 | 17142 | 265 |
2489123 | 2489123 | 2022-05-09 | Jefferson | Tennessee | 47089 | 15775 | 265 |
2489374 | 2489374 | 2022-05-09 | Rockwall | Texas | 48397 | 26732 | 265 |
2489537 | 2489537 | 2022-05-09 | Henry | Virginia | 51089 | 12146 | 265 |
2489678 | 2489678 | 2022-05-09 | Mercer | West Virginia | 54055 | 17142 | 265 |
2485866 | 2485866 | 2022-05-08 | Jefferson | Tennessee | 47089 | 15775 | 265 |
2486116 | 2486116 | 2022-05-08 | Rockwall | Texas | 48397 | 26727 | 265 |
2486280 | 2486280 | 2022-05-08 | Henry | Virginia | 51089 | 12127 | 265 |
2486421 | 2486421 | 2022-05-08 | Mercer | West Virginia | 54055 | 17112 | 265 |
2482608 | 2482608 | 2022-05-07 | Jefferson | Tennessee | 47089 | 15775 | 265 |
2482858 | 2482858 | 2022-05-07 | Rockwall | Texas | 48397 | 26726 | 265 |
2483022 | 2483022 | 2022-05-07 | Henry | Virginia | 51089 | 12127 | 265 |
2483163 | 2483163 | 2022-05-07 | Mercer | West Virginia | 54055 | 17112 | 265 |
2479350 | 2479350 | 2022-05-06 | Jefferson | Tennessee | 47089 | 15775 | 265 |
2479600 | 2479600 | 2022-05-06 | Rockwall | Texas | 48397 | 26721 | 265 |
2479764 | 2479764 | 2022-05-06 | Henry | Virginia | 51089 | 12127 | 265 |
2479905 | 2479905 | 2022-05-06 | Mercer | West Virginia | 54055 | 17112 | 265 |
2476092 | 2476092 | 2022-05-05 | Jefferson | Tennessee | 47089 | 15775 | 265 |
2476342 | 2476342 | 2022-05-05 | Rockwall | Texas | 48397 | 26710 | 265 |
2476506 | 2476506 | 2022-05-05 | Henry | Virginia | 51089 | 12107 | 265 |
2476647 | 2476647 | 2022-05-05 | Mercer | West Virginia | 54055 | 17108 | 265 |
2472835 | 2472835 | 2022-05-04 | Jefferson | Tennessee | 47089 | 15775 | 265 |
2473085 | 2473085 | 2022-05-04 | Rockwall | Texas | 48397 | 26701 | 265 |
2473248 | 2473248 | 2022-05-04 | Henry | Virginia | 51089 | 12093 | 265 |
2473389 | 2473389 | 2022-05-04 | Mercer | West Virginia | 54055 | 17098 | 265 |
2469579 | 2469579 | 2022-05-03 | Jefferson | Tennessee | 47089 | 15734 | 265 |
2469829 | 2469829 | 2022-05-03 | Rockwall | Texas | 48397 | 26701 | 265 |
2469992 | 2469992 | 2022-05-03 | Henry | Virginia | 51089 | 12074 | 265 |
2470132 | 2470132 | 2022-05-03 | Mercer | West Virginia | 54055 | 17093 | 265 |
2466323 | 2466323 | 2022-05-02 | Jefferson | Tennessee | 47089 | 15734 | 265 |
2466573 | 2466573 | 2022-05-02 | Rockwall | Texas | 48397 | 26696 | 265 |
2466876 | 2466876 | 2022-05-02 | Mercer | West Virginia | 54055 | 17090 | 265 |
2463068 | 2463068 | 2022-05-01 | Jefferson | Tennessee | 47089 | 15734 | 265 |
2463318 | 2463318 | 2022-05-01 | Rockwall | Texas | 48397 | 26692 | 265 |
2463621 | 2463621 | 2022-05-01 | Mercer | West Virginia | 54055 | 17070 | 265 |
2459812 | 2459812 | 2022-04-30 | Jefferson | Tennessee | 47089 | 15734 | 265 |
2460062 | 2460062 | 2022-04-30 | Rockwall | Texas | 48397 | 26691 | 265 |
2460365 | 2460365 | 2022-04-30 | Mercer | West Virginia | 54055 | 17070 | 265 |
2456556 | 2456556 | 2022-04-29 | Jefferson | Tennessee | 47089 | 15734 | 265 |
2456806 | 2456806 | 2022-04-29 | Rockwall | Texas | 48397 | 26667 | 265 |
2457109 | 2457109 | 2022-04-29 | Mercer | West Virginia | 54055 | 17070 | 265 |
2453300 | 2453300 | 2022-04-28 | Jefferson | Tennessee | 47089 | 15734 | 265 |
2453550 | 2453550 | 2022-04-28 | Rockwall | Texas | 48397 | 26655 | 265 |
2453853 | 2453853 | 2022-04-28 | Mercer | West Virginia | 54055 | 17060 | 265 |
2450044 | 2450044 | 2022-04-27 | Jefferson | Tennessee | 47089 | 15734 | 265 |
2450294 | 2450294 | 2022-04-27 | Rockwall | Texas | 48397 | 26651 | 265 |
2450597 | 2450597 | 2022-04-27 | Mercer | West Virginia | 54055 | 17051 | 265 |
2447037 | 2447037 | 2022-04-26 | Rockwall | Texas | 48397 | 26628 | 265 |
2447341 | 2447341 | 2022-04-26 | Mercer | West Virginia | 54055 | 17049 | 265 |
2443782 | 2443782 | 2022-04-25 | Rockwall | Texas | 48397 | 26621 | 265 |
2444085 | 2444085 | 2022-04-25 | Mercer | West Virginia | 54055 | 17047 | 265 |
2440526 | 2440526 | 2022-04-24 | Rockwall | Texas | 48397 | 26616 | 265 |
2440829 | 2440829 | 2022-04-24 | Mercer | West Virginia | 54055 | 17038 | 265 |
2437270 | 2437270 | 2022-04-23 | Rockwall | Texas | 48397 | 26613 | 265 |
2437573 | 2437573 | 2022-04-23 | Mercer | West Virginia | 54055 | 17038 | 265 |
2434014 | 2434014 | 2022-04-22 | Rockwall | Texas | 48397 | 26609 | 265 |
2434317 | 2434317 | 2022-04-22 | Mercer | West Virginia | 54055 | 17038 | 265 |
2430758 | 2430758 | 2022-04-21 | Rockwall | Texas | 48397 | 26608 | 265 |
2431061 | 2431061 | 2022-04-21 | Mercer | West Virginia | 54055 | 17033 | 265 |
2427502 | 2427502 | 2022-04-20 | Rockwall | Texas | 48397 | 26604 | 265 |
2427805 | 2427805 | 2022-04-20 | Mercer | West Virginia | 54055 | 17027 | 265 |
2424246 | 2424246 | 2022-04-19 | Rockwall | Texas | 48397 | 26597 | 265 |
2424549 | 2424549 | 2022-04-19 | Mercer | West Virginia | 54055 | 17025 | 265 |
2420990 | 2420990 | 2022-04-18 | Rockwall | Texas | 48397 | 26590 | 265 |
2421293 | 2421293 | 2022-04-18 | Mercer | West Virginia | 54055 | 17023 | 265 |
2417734 | 2417734 | 2022-04-17 | Rockwall | Texas | 48397 | 26567 | 265 |
2418037 | 2418037 | 2022-04-17 | Mercer | West Virginia | 54055 | 17007 | 265 |
2414478 | 2414478 | 2022-04-16 | Rockwall | Texas | 48397 | 26567 | 265 |
2414781 | 2414781 | 2022-04-16 | Mercer | West Virginia | 54055 | 17007 | 265 |
2411222 | 2411222 | 2022-04-15 | Rockwall | Texas | 48397 | 26567 | 265 |
2411525 | 2411525 | 2022-04-15 | Mercer | West Virginia | 54055 | 17007 | 265 |
2407966 | 2407966 | 2022-04-14 | Rockwall | Texas | 48397 | 26567 | 265 |
2408143 | 2408143 | 2022-04-14 | Lynchburg city | Virginia | 51680 | 20082 | 265 |
2408269 | 2408269 | 2022-04-14 | Mercer | West Virginia | 54055 | 17000 | 265 |
2403970 | 2403970 | 2022-04-13 | Erie | Ohio | 39043 | 19434 | 265 |
2404710 | 2404710 | 2022-04-13 | Rockwall | Texas | 48397 | 26559 | 265 |
2404887 | 2404887 | 2022-04-13 | Lynchburg city | Virginia | 51680 | 20080 | 265 |
2400715 | 2400715 | 2022-04-12 | Erie | Ohio | 39043 | 19434 | 265 |
2401455 | 2401455 | 2022-04-12 | Rockwall | Texas | 48397 | 26555 | 265 |
2401632 | 2401632 | 2022-04-12 | Lynchburg city | Virginia | 51680 | 20075 | 265 |
2397460 | 2397460 | 2022-04-11 | Erie | Ohio | 39043 | 19434 | 265 |
2398200 | 2398200 | 2022-04-11 | Rockwall | Texas | 48397 | 26551 | 265 |
2398377 | 2398377 | 2022-04-11 | Lynchburg city | Virginia | 51680 | 20071 | 265 |
2393967 | 2393967 | 2022-04-10 | Valencia | New Mexico | 35061 | 19039 | 265 |
2394205 | 2394205 | 2022-04-10 | Erie | Ohio | 39043 | 19434 | 265 |
2394945 | 2394945 | 2022-04-10 | Rockwall | Texas | 48397 | 26548 | 265 |
2395122 | 2395122 | 2022-04-10 | Lynchburg city | Virginia | 51680 | 20061 | 265 |
2390711 | 2390711 | 2022-04-09 | Valencia | New Mexico | 35061 | 19039 | 265 |
2390949 | 2390949 | 2022-04-09 | Erie | Ohio | 39043 | 19434 | 265 |
2391689 | 2391689 | 2022-04-09 | Rockwall | Texas | 48397 | 26545 | 265 |
2391866 | 2391866 | 2022-04-09 | Lynchburg city | Virginia | 51680 | 20061 | 265 |
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);