ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where cases = 6861 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Iowa 7
- Indiana 5
- Ohio 5
- Arizona 4
- Illinois 4
- Minnesota 4
- Virginia 4
- Alabama 3
- New York 3
- North Carolina 3
- Texas 3
- Kentucky 2
- Maryland 2
- Michigan 2
- Colorado 1
- Florida 1
- Georgia 1
- Louisiana 1
- Massachusetts 1
- Montana 1
- New Jersey 1
- North Dakota 1
- Pennsylvania 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492846 | 2492846 | 2022-05-10 | Russell | Virginia | 51167 | 6861 | 114 |
2466897 | 2466897 | 2022-05-02 | Upshur | West Virginia | 54097 | 6861 | 95 |
2420865 | 2420865 | 2022-04-18 | Fannin | Texas | 48147 | 6861 | 184 |
2392911 | 2392911 | 2022-04-10 | White | Indiana | 18181 | 6861 | 95 |
2389655 | 2389655 | 2022-04-09 | White | Indiana | 18181 | 6861 | 95 |
2386399 | 2386399 | 2022-04-08 | White | Indiana | 18181 | 6861 | 95 |
2270154 | 2270154 | 2022-03-03 | Ravalli | Montana | 30081 | 6861 | 141 |
2271518 | 2271518 | 2022-03-03 | Orange | Virginia | 51137 | 6861 | 85 |
2218991 | 2218991 | 2022-02-15 | Meade | South Dakota | 46093 | 6861 | 59 |
2203150 | 2203150 | 2022-02-10 | Accomack | Virginia | 51001 | 6861 | 100 |
2103855 | 2103855 | 2022-01-11 | Worcester | Maryland | 24047 | 6861 | 133 |
2100402 | 2100402 | 2022-01-10 | Clark | Kentucky | 21049 | 6861 | 49 |
2056821 | 2056821 | 2021-12-27 | Danville city | Virginia | 51590 | 6861 | 206 |
2052461 | 2052461 | 2021-12-26 | Allegany | New York | 36003 | 6861 | 134 |
2049492 | 2049492 | 2021-12-25 | Preble | Ohio | 39135 | 6861 | 146 |
2046242 | 2046242 | 2021-12-24 | Preble | Ohio | 39135 | 6861 | 146 |
2046429 | 2046429 | 2021-12-24 | Pike | Pennsylvania | 42103 | 6861 | 71 |
2012474 | 2012474 | 2021-12-14 | Muscatine | Iowa | 19139 | 6861 | 118 |
2009223 | 2009223 | 2021-12-13 | Muscatine | Iowa | 19139 | 6861 | 118 |
2005972 | 2005972 | 2021-12-12 | Muscatine | Iowa | 19139 | 6861 | 118 |
2002721 | 2002721 | 2021-12-11 | Muscatine | Iowa | 19139 | 6861 | 118 |
1999471 | 1999471 | 2021-12-10 | Muscatine | Iowa | 19139 | 6861 | 118 |
1996220 | 1996220 | 2021-12-09 | Muscatine | Iowa | 19139 | 6861 | 118 |
1992969 | 1992969 | 2021-12-08 | Muscatine | Iowa | 19139 | 6861 | 118 |
1990760 | 1990760 | 2021-12-07 | Alexander | North Carolina | 37003 | 6861 | 118 |
1942094 | 1942094 | 2021-11-22 | Watauga | North Carolina | 37189 | 6861 | 40 |
1937487 | 1937487 | 2021-11-21 | Jefferson | Illinois | 17081 | 6861 | 148 |
1934237 | 1934237 | 2021-11-20 | Jefferson | Illinois | 17081 | 6861 | 148 |
1930986 | 1930986 | 2021-11-19 | Jefferson | Illinois | 17081 | 6861 | 148 |
1926505 | 1926505 | 2021-11-17 | Cherokee | Texas | 48073 | 6861 | 227 |
1875125 | 1875125 | 2021-11-02 | Escambia | Alabama | 1053 | 6861 | 137 |
1844475 | 1844475 | 2021-10-23 | Herkimer | New York | 36043 | 6861 | 128 |
1830775 | 1830775 | 2021-10-19 | St. Bernard | Louisiana | 22087 | 6861 | 98 |
1792656 | 1792656 | 2021-10-07 | Morton | North Dakota | 38059 | 6861 | 104 |
1693425 | 1693425 | 2021-09-07 | Garfield | Colorado | 8045 | 6861 | 57 |
1630612 | 1630612 | 2021-08-18 | Cherokee | South Carolina | 45021 | 6861 | 162 |
1606811 | 1606811 | 2021-08-11 | Kandiyohi | Minnesota | 27067 | 6861 | 86 |
1535335 | 1535335 | 2021-07-20 | Crow Wing | Minnesota | 27035 | 6861 | 98 |
1518512 | 1518512 | 2021-07-15 | Morgan | Indiana | 18109 | 6861 | 147 |
1471144 | 1471144 | 2021-06-30 | Geauga | Ohio | 39055 | 6861 | 153 |
1388326 | 1388326 | 2021-06-05 | Bulloch | Georgia | 13031 | 6861 | 120 |
1355499 | 1355499 | 2021-05-26 | Jackson | Alabama | 1071 | 6861 | 112 |
1335282 | 1335282 | 2021-05-19 | Dickson | Tennessee | 47043 | 6861 | 114 |
1315317 | 1315317 | 2021-05-13 | Ashtabula | Ohio | 39007 | 6861 | 170 |
1312138 | 1312138 | 2021-05-12 | Ross | Ohio | 39141 | 6861 | 155 |
1285239 | 1285239 | 2021-05-04 | Allegany | Maryland | 24001 | 6861 | 207 |
1259359 | 1259359 | 2021-04-26 | Midland | Michigan | 26111 | 6861 | 77 |
1238678 | 1238678 | 2021-04-20 | Gila | Arizona | 4007 | 6861 | 227 |
1235431 | 1235431 | 2021-04-19 | Gila | Arizona | 4007 | 6861 | 227 |
1232183 | 1232183 | 2021-04-18 | Gila | Arizona | 4007 | 6861 | 227 |
1228935 | 1228935 | 2021-04-17 | Gila | Arizona | 4007 | 6861 | 227 |
1203869 | 1203869 | 2021-04-09 | Bullitt | Kentucky | 21029 | 6861 | 71 |
1178723 | 1178723 | 2021-04-01 | Chemung | New York | 36015 | 6861 | 131 |
1093153 | 1093153 | 2021-03-06 | Williamson | Illinois | 17199 | 6861 | 133 |
1033876 | 1033876 | 2021-02-15 | Thurston | Washington | 53067 | 6861 | 72 |
952502 | 952502 | 2021-01-21 | Victoria | Texas | 48469 | 6861 | 138 |
780941 | 780941 | 2020-11-30 | Morgan | Alabama | 1103 | 6861 | 50 |
723752 | 723752 | 2020-11-12 | Kalamazoo | Michigan | 26077 | 6861 | 135 |
684959 | 684959 | 2020-10-31 | Washington | Minnesota | 27163 | 6861 | 74 |
487842 | 487842 | 2020-08-31 | Guilford | North Carolina | 37081 | 6861 | 170 |
393754 | 393754 | 2020-08-02 | Ramsey | Minnesota | 27123 | 6861 | 261 |
380248 | 380248 | 2020-07-29 | Lake | Indiana | 18089 | 6861 | 282 |
300914 | 300914 | 2020-07-04 | Hampden | Massachusetts | 25013 | 6861 | 664 |
290595 | 290595 | 2020-07-01 | Pinellas | Florida | 12103 | 6861 | 172 |
279379 | 279379 | 2020-06-27 | Morris | New Jersey | 34027 | 6861 | 793 |
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);