ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where cases = 6154 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Tennessee 12
- North Carolina 8
- Pennsylvania 6
- Puerto Rico 5
- Indiana 4
- Ohio 4
- Missouri 3
- Virginia 3
- California 2
- Georgia 2
- Illinois 2
- Kansas 2
- Michigan 2
- New York 2
- South Carolina 2
- Wisconsin 2
- Colorado 1
- Louisiana 1
- Minnesota 1
- Texas 1
- Utah 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2404258 | 2404258 | 2022-04-13 | Juncos | Puerto Rico | 72077 | 6154 | |
2384223 | 2384223 | 2022-04-07 | Lewis | New York | 36049 | 6154 | 49 |
2379595 | 2379595 | 2022-04-06 | Peach | Georgia | 13225 | 6154 | 133 |
2310971 | 2310971 | 2022-03-16 | Del Norte | California | 6015 | 6154 | 48 |
2307718 | 2307718 | 2022-03-15 | Del Norte | California | 6015 | 6154 | 48 |
2310136 | 2310136 | 2022-03-15 | Smith | Tennessee | 47159 | 6154 | 76 |
2306883 | 2306883 | 2022-03-14 | Smith | Tennessee | 47159 | 6154 | 76 |
2303632 | 2303632 | 2022-03-13 | Smith | Tennessee | 47159 | 6154 | 76 |
2300380 | 2300380 | 2022-03-12 | Smith | Tennessee | 47159 | 6154 | 76 |
2297128 | 2297128 | 2022-03-11 | Smith | Tennessee | 47159 | 6154 | 76 |
2293876 | 2293876 | 2022-03-10 | Smith | Tennessee | 47159 | 6154 | 76 |
2290624 | 2290624 | 2022-03-09 | Smith | Tennessee | 47159 | 6154 | 76 |
2259431 | 2259431 | 2022-02-28 | Shelby | Illinois | 17173 | 6154 | 75 |
2217788 | 2217788 | 2022-02-15 | Oceana | Michigan | 26127 | 6154 | 87 |
2214537 | 2214537 | 2022-02-14 | Oceana | Michigan | 26127 | 6154 | 87 |
2193561 | 2193561 | 2022-02-07 | Boone | West Virginia | 54005 | 6154 | 64 |
2166535 | 2166535 | 2022-01-30 | Hocking | Ohio | 39073 | 6154 | 107 |
2154402 | 2154402 | 2022-01-26 | Halifax | Virginia | 51083 | 6154 | 128 |
2142373 | 2142373 | 2022-01-23 | Clay | Indiana | 18021 | 6154 | 77 |
2139118 | 2139118 | 2022-01-22 | Clay | Indiana | 18021 | 6154 | 77 |
2135862 | 2135862 | 2022-01-21 | Clay | Indiana | 18021 | 6154 | 77 |
2132821 | 2132821 | 2022-01-20 | Franklin | Kansas | 20059 | 6154 | 68 |
2129568 | 2129568 | 2022-01-19 | Franklin | Kansas | 20059 | 6154 | 68 |
2128580 | 2128580 | 2022-01-18 | Lincoln | Wisconsin | 55069 | 6154 | 125 |
2062348 | 2062348 | 2021-12-29 | Scotland | North Carolina | 37165 | 6154 | 110 |
2063210 | 2063210 | 2021-12-29 | Titus | Texas | 48449 | 6154 | 105 |
1978169 | 1978169 | 2021-12-03 | Pike | Pennsylvania | 42103 | 6154 | 70 |
1904067 | 1904067 | 2021-11-10 | Franklin | Virginia | 51067 | 6154 | 107 |
1884502 | 1884502 | 2021-11-04 | Wasatch | Utah | 49051 | 6154 | 28 |
1877500 | 1877500 | 2021-11-02 | Toa Baja | Puerto Rico | 72137 | 6154 | |
1874251 | 1874251 | 2021-11-01 | Toa Baja | Puerto Rico | 72137 | 6154 | |
1870692 | 1870692 | 2021-10-31 | Guernsey | Ohio | 39059 | 6154 | 73 |
1871002 | 1871002 | 2021-10-31 | Toa Baja | Puerto Rico | 72137 | 6154 | |
1770309 | 1770309 | 2021-09-30 | Dillon | South Carolina | 45033 | 6154 | 107 |
1758772 | 1758772 | 2021-09-27 | Jefferson | Illinois | 17081 | 6154 | 137 |
1650043 | 1650043 | 2021-08-24 | Guaynabo | Puerto Rico | 72061 | 6154 | |
1546005 | 1546005 | 2021-07-23 | Bradford | Pennsylvania | 42015 | 6154 | 96 |
1487244 | 1487244 | 2021-07-05 | Lee | North Carolina | 37105 | 6154 | 82 |
1483998 | 1483998 | 2021-07-04 | Lee | North Carolina | 37105 | 6154 | 82 |
1480752 | 1480752 | 2021-07-03 | Lee | North Carolina | 37105 | 6154 | 82 |
1477505 | 1477505 | 2021-07-02 | Lee | North Carolina | 37105 | 6154 | 82 |
1471013 | 1471013 | 2021-06-30 | Lee | North Carolina | 37105 | 6154 | 82 |
1459591 | 1459591 | 2021-06-27 | Garfield | Colorado | 8045 | 6154 | 48 |
1448663 | 1448663 | 2021-06-23 | Union | Pennsylvania | 42119 | 6154 | 89 |
1445418 | 1445418 | 2021-06-22 | Union | Pennsylvania | 42119 | 6154 | 89 |
1369995 | 1369995 | 2021-05-30 | Joplin | Missouri | 6154 | 108 | |
1312587 | 1312587 | 2021-05-12 | Loudon | Tennessee | 47105 | 6154 | 69 |
1300990 | 1300990 | 2021-05-09 | Dubois | Indiana | 18037 | 6154 | 118 |
1218446 | 1218446 | 2021-04-13 | Roane | Tennessee | 47145 | 6154 | 100 |
1166467 | 1166467 | 2021-03-28 | McMinn | Tennessee | 47107 | 6154 | 94 |
1163219 | 1163219 | 2021-03-27 | McMinn | Tennessee | 47107 | 6154 | 94 |
1159970 | 1159970 | 2021-03-26 | McMinn | Tennessee | 47107 | 6154 | 94 |
1146275 | 1146275 | 2021-03-22 | Ontario | New York | 36069 | 6154 | 90 |
1123670 | 1123670 | 2021-03-15 | Wilkes | North Carolina | 37193 | 6154 | 104 |
1114964 | 1114964 | 2021-03-12 | Rockingham | Virginia | 51165 | 6154 | 102 |
1110017 | 1110017 | 2021-03-11 | Blue Earth | Minnesota | 27013 | 6154 | 37 |
1106560 | 1106560 | 2021-03-10 | Acadia | Louisiana | 22001 | 6154 | 186 |
1107525 | 1107525 | 2021-03-10 | Geauga | Ohio | 39055 | 6154 | 142 |
1094751 | 1094751 | 2021-03-06 | Lawrence | Pennsylvania | 42073 | 6154 | 185 |
990577 | 990577 | 2021-02-02 | Sampson | North Carolina | 37163 | 6154 | 80 |
918707 | 918707 | 2021-01-11 | Cass | Missouri | 29037 | 6154 | 59 |
919634 | 919634 | 2021-01-11 | Lancaster | South Carolina | 45057 | 6154 | 95 |
900943 | 900943 | 2021-01-05 | Wood | Wisconsin | 55141 | 6154 | 63 |
853885 | 853885 | 2020-12-22 | St. Francois | Missouri | 29187 | 6154 | 64 |
808993 | 808993 | 2020-12-08 | Wood | Ohio | 39173 | 6154 | 116 |
710044 | 710044 | 2020-11-08 | Whitfield | Georgia | 13313 | 6154 | 67 |
162422 | 162422 | 2020-05-20 | Montgomery | Pennsylvania | 42091 | 6154 | 596 |
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);