ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
159 rows where cases = 3029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 12
- Puerto Rico 11
- Georgia 10
- Tennessee 10
- Colorado 8
- Michigan 7
- Utah 7
- Arkansas 6
- Indiana 6
- Louisiana 6
- Minnesota 6
- Virginia 6
- Mississippi 5
- New York 5
- Virgin Islands 5
- California 4
- Illinois 4
- North Carolina 4
- Wisconsin 4
- Florida 3
- Kentucky 3
- Nevada 3
- Ohio 3
- Alabama 2
- North Dakota 2
- South Carolina 2
- Texas 2
- Alaska 1
- Arizona 1
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489932 | 2489932 | 2022-05-10 | Desha | Arkansas | 5041 | 3029 | 41 |
2486675 | 2486675 | 2022-05-09 | Desha | Arkansas | 5041 | 3029 | 41 |
2483417 | 2483417 | 2022-05-08 | Desha | Arkansas | 5041 | 3029 | 41 |
2480159 | 2480159 | 2022-05-07 | Desha | Arkansas | 5041 | 3029 | 41 |
2437982 | 2437982 | 2022-04-24 | Moffat | Colorado | 8081 | 3029 | 51 |
2434726 | 2434726 | 2022-04-23 | Moffat | Colorado | 8081 | 3029 | 51 |
2431470 | 2431470 | 2022-04-22 | Moffat | Colorado | 8081 | 3029 | 51 |
2404072 | 2404072 | 2022-04-13 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2400817 | 2400817 | 2022-04-12 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2395579 | 2395579 | 2022-04-11 | Mariposa | California | 6043 | 3029 | 34 |
2397562 | 2397562 | 2022-04-11 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2394307 | 2394307 | 2022-04-10 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2391051 | 2391051 | 2022-04-09 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2387795 | 2387795 | 2022-04-08 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2384540 | 2384540 | 2022-04-07 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2285980 | 2285980 | 2022-03-08 | Kent | Maryland | 24029 | 3029 | 66 |
2262213 | 2262213 | 2022-03-01 | Plumas | California | 6063 | 3029 | 13 |
2264937 | 2264937 | 2022-03-01 | Brunswick | Virginia | 51025 | 3029 | 42 |
2258962 | 2258962 | 2022-02-28 | Plumas | California | 6063 | 3029 | 13 |
2260083 | 2260083 | 2022-02-28 | Chippewa | Minnesota | 27023 | 3029 | 47 |
2201969 | 2201969 | 2022-02-10 | Seward | Nebraska | 31159 | 3029 | 41 |
2190715 | 2190715 | 2022-02-07 | Crowley | Colorado | 8025 | 3029 | 28 |
2178696 | 2178696 | 2022-02-03 | Arenac | Michigan | 26011 | 3029 | 60 |
2175444 | 2175444 | 2022-02-02 | Arenac | Michigan | 26011 | 3029 | 60 |
2172286 | 2172286 | 2022-02-01 | Cottonwood | Minnesota | 27033 | 3029 | 38 |
2170848 | 2170848 | 2022-01-31 | Ashland | Wisconsin | 55003 | 3029 | 30 |
2151572 | 2151572 | 2022-01-26 | Marion | Arkansas | 5089 | 3029 | 76 |
2151688 | 2151688 | 2022-01-26 | Gunnison | Colorado | 8051 | 3029 | 13 |
2129035 | 2129035 | 2022-01-19 | Bacon | Georgia | 13005 | 3029 | 65 |
2103288 | 2103288 | 2022-01-11 | Mason | Illinois | 17125 | 3029 | 57 |
2078658 | 2078658 | 2022-01-03 | Richland | North Dakota | 38077 | 3029 | 21 |
2075407 | 2075407 | 2022-01-02 | Richland | North Dakota | 38077 | 3029 | 21 |
2040833 | 2040833 | 2021-12-22 | Washburn | Wisconsin | 55129 | 3029 | 34 |
2024045 | 2024045 | 2021-12-17 | DeWitt | Texas | 48123 | 3029 | 86 |
2019536 | 2019536 | 2021-12-16 | Clarke | Mississippi | 28023 | 3029 | 95 |
2007639 | 2007639 | 2021-12-12 | Benton | Tennessee | 47005 | 3029 | 60 |
2004388 | 2004388 | 2021-12-11 | Benton | Tennessee | 47005 | 3029 | 60 |
2001137 | 2001137 | 2021-12-10 | Benton | Tennessee | 47005 | 3029 | 60 |
1995129 | 1995129 | 2021-12-08 | Powhatan | Virginia | 51145 | 3029 | 31 |
1990146 | 1990146 | 2021-12-07 | Manistee | Michigan | 26101 | 3029 | 50 |
1986896 | 1986896 | 2021-12-06 | Manistee | Michigan | 26101 | 3029 | 50 |
1970761 | 1970761 | 2021-12-01 | Wadena | Minnesota | 27159 | 3029 | 40 |
1963340 | 1963340 | 2021-11-29 | Meriwether | Georgia | 13199 | 3029 | 120 |
1963486 | 1963486 | 2021-11-29 | Hancock | Illinois | 17067 | 3029 | 45 |
1961972 | 1961972 | 2021-11-28 | Juncos | Puerto Rico | 72077 | 3029 | |
1952878 | 1952878 | 2021-11-25 | Radford city | Virginia | 51750 | 3029 | 36 |
1947151 | 1947151 | 2021-11-24 | Kauai | Hawaii | 15007 | 3029 | 13 |
1940776 | 1940776 | 2021-11-22 | Richland | Illinois | 17159 | 3029 | 68 |
1924020 | 1924020 | 2021-11-17 | Sharp | Arkansas | 5135 | 3029 | 71 |
1894901 | 1894901 | 2021-11-08 | Teller | Colorado | 8119 | 3029 | 37 |
1892109 | 1892109 | 2021-11-07 | Orange | Indiana | 18117 | 3029 | 70 |
1888859 | 1888859 | 2021-11-06 | Orange | Indiana | 18117 | 3029 | 70 |
1885609 | 1885609 | 2021-11-05 | Orange | Indiana | 18117 | 3029 | 70 |
1855238 | 1855238 | 2021-10-26 | Carbon | Utah | 49007 | 3029 | 28 |
1849115 | 1849115 | 2021-10-25 | Cherokee | Alabama | 1019 | 3029 | 60 |
1847928 | 1847928 | 2021-10-24 | Carroll | Ohio | 39019 | 3029 | 65 |
1839081 | 1839081 | 2021-10-21 | Fredericksburg city | Virginia | 51630 | 3029 | 25 |
1825727 | 1825727 | 2021-10-17 | Union | Tennessee | 47173 | 3029 | 45 |
1826036 | 1826036 | 2021-10-17 | St. Croix | Virgin Islands | 78010 | 3029 | 27 |
1822478 | 1822478 | 2021-10-16 | Union | Tennessee | 47173 | 3029 | 45 |
1822787 | 1822787 | 2021-10-16 | St. Croix | Virgin Islands | 78010 | 3029 | 27 |
1819229 | 1819229 | 2021-10-15 | Union | Tennessee | 47173 | 3029 | 45 |
1819538 | 1819538 | 2021-10-15 | St. Croix | Virgin Islands | 78010 | 3029 | 27 |
1813957 | 1813957 | 2021-10-14 | Minidoka | Idaho | 16067 | 3029 | 44 |
1816289 | 1816289 | 2021-10-14 | St. Croix | Virgin Islands | 78010 | 3029 | 27 |
1813041 | 1813041 | 2021-10-13 | St. Croix | Virgin Islands | 78010 | 3029 | 27 |
1808446 | 1808446 | 2021-10-12 | Perry | Missouri | 29157 | 3029 | 32 |
1792049 | 1792049 | 2021-10-07 | Clay | Mississippi | 28025 | 3029 | 75 |
1792955 | 1792955 | 2021-10-07 | Aguadilla | Puerto Rico | 72005 | 3029 | |
1789706 | 1789706 | 2021-10-06 | Aguadilla | Puerto Rico | 72005 | 3029 | |
1779990 | 1779990 | 2021-10-03 | Gurabo | Puerto Rico | 72063 | 3029 | |
1776740 | 1776740 | 2021-10-02 | Gurabo | Puerto Rico | 72063 | 3029 | |
1773490 | 1773490 | 2021-10-01 | Gurabo | Puerto Rico | 72063 | 3029 | |
1770240 | 1770240 | 2021-09-30 | Gurabo | Puerto Rico | 72063 | 3029 | |
1763724 | 1763724 | 2021-09-28 | Canovanas | Puerto Rico | 72029 | 3029 | |
1760475 | 1760475 | 2021-09-27 | Canovanas | Puerto Rico | 72029 | 3029 | |
1743003 | 1743003 | 2021-09-22 | Wayne | Kentucky | 21231 | 3029 | 57 |
1739741 | 1739741 | 2021-09-21 | Rowan | Kentucky | 21205 | 3029 | 25 |
1732632 | 1732632 | 2021-09-19 | Morgan | Georgia | 13211 | 3029 | 34 |
1729382 | 1729382 | 2021-09-18 | Morgan | Georgia | 13211 | 3029 | 34 |
1726132 | 1726132 | 2021-09-17 | Morgan | Georgia | 13211 | 3029 | 34 |
1710725 | 1710725 | 2021-09-12 | Wexford | Michigan | 26165 | 3029 | 50 |
1707478 | 1707478 | 2021-09-11 | Wexford | Michigan | 26165 | 3029 | 50 |
1704231 | 1704231 | 2021-09-10 | Wexford | Michigan | 26165 | 3029 | 50 |
1698945 | 1698945 | 2021-09-08 | Chester | Tennessee | 47023 | 3029 | 57 |
1673853 | 1673853 | 2021-09-01 | Calaveras | California | 6009 | 3029 | 61 |
1672702 | 1672702 | 2021-08-31 | Elk | Pennsylvania | 42047 | 3029 | 42 |
1625382 | 1625382 | 2021-08-17 | Emanuel | Georgia | 13107 | 3029 | 85 |
1584073 | 1584073 | 2021-08-04 | Le Sueur | Minnesota | 27079 | 3029 | 28 |
1515670 | 1515670 | 2021-07-14 | Sabine | Louisiana | 22085 | 3029 | 64 |
1511521 | 1511521 | 2021-07-13 | Delta | Colorado | 8029 | 3029 | 67 |
1395825 | 1395825 | 2021-06-07 | Adams | Mississippi | 28001 | 3029 | 84 |
1379273 | 1379273 | 2021-06-02 | Muhlenberg | Kentucky | 21177 | 3029 | 67 |
1371496 | 1371496 | 2021-05-30 | Warren | Virginia | 51187 | 3029 | 58 |
1355946 | 1355946 | 2021-05-26 | Lumpkin | Georgia | 13187 | 3029 | 76 |
1348318 | 1348318 | 2021-05-23 | Overton | Tennessee | 47133 | 3029 | 61 |
1345070 | 1345070 | 2021-05-22 | Overton | Tennessee | 47133 | 3029 | 61 |
1341822 | 1341822 | 2021-05-21 | Overton | Tennessee | 47133 | 3029 | 61 |
1342278 | 1342278 | 2021-05-21 | Warren | Virginia | 51187 | 3029 | 58 |
1326878 | 1326878 | 2021-05-17 | Iroquois | Illinois | 17075 | 3029 | 68 |
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);