ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
132 rows where cases = 3906 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 14
- North Carolina 12
- Iowa 11
- Georgia 9
- South Carolina 9
- Nebraska 7
- Tennessee 6
- Illinois 5
- Alaska 4
- Indiana 4
- Louisiana 4
- Puerto Rico 4
- Kentucky 3
- Maine 3
- Minnesota 3
- Missouri 3
- Ohio 3
- Utah 3
- Arkansas 2
- California 2
- Florida 2
- Kansas 2
- New Jersey 2
- Pennsylvania 2
- Virginia 2
- West Virginia 2
- Wisconsin 2
- Maryland 1
- Michigan 1
- Montana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499718 | 2499718 | 2022-05-13 | Izard | Arkansas | 5065 | 3906 | 70 |
2500469 | 2500469 | 2022-05-13 | Winneshiek | Iowa | 19191 | 3906 | 50 |
2497211 | 2497211 | 2022-05-12 | Winneshiek | Iowa | 19191 | 3906 | 50 |
2493953 | 2493953 | 2022-05-11 | Winneshiek | Iowa | 19191 | 3906 | 50 |
2491786 | 2491786 | 2022-05-10 | Polk | North Carolina | 37149 | 3906 | 64 |
2488528 | 2488528 | 2022-05-09 | Polk | North Carolina | 37149 | 3906 | 64 |
2485271 | 2485271 | 2022-05-08 | Polk | North Carolina | 37149 | 3906 | 64 |
2482013 | 2482013 | 2022-05-07 | Polk | North Carolina | 37149 | 3906 | 64 |
2478755 | 2478755 | 2022-05-06 | Polk | North Carolina | 37149 | 3906 | 64 |
2475497 | 2475497 | 2022-05-05 | Polk | North Carolina | 37149 | 3906 | 64 |
2472240 | 2472240 | 2022-05-04 | Polk | North Carolina | 37149 | 3906 | 64 |
2467882 | 2467882 | 2022-05-03 | Tama | Iowa | 19171 | 3906 | 90 |
2464627 | 2464627 | 2022-05-02 | Tama | Iowa | 19171 | 3906 | 90 |
2461371 | 2461371 | 2022-05-01 | Tama | Iowa | 19171 | 3906 | 90 |
2458115 | 2458115 | 2022-04-30 | Tama | Iowa | 19171 | 3906 | 90 |
2454859 | 2454859 | 2022-04-29 | Tama | Iowa | 19171 | 3906 | 90 |
2451603 | 2451603 | 2022-04-28 | Tama | Iowa | 19171 | 3906 | 90 |
2448347 | 2448347 | 2022-04-27 | Tama | Iowa | 19171 | 3906 | 90 |
2446988 | 2446988 | 2022-04-26 | Llano | Texas | 48299 | 3906 | 97 |
2355407 | 2355407 | 2022-03-29 | Aguas Buenas | Puerto Rico | 72007 | 3906 | |
2352154 | 2352154 | 2022-03-28 | Aguas Buenas | Puerto Rico | 72007 | 3906 | |
2324247 | 2324247 | 2022-03-20 | Greene | Georgia | 13133 | 3906 | 83 |
2320993 | 2320993 | 2022-03-19 | Greene | Georgia | 13133 | 3906 | 83 |
2317739 | 2317739 | 2022-03-18 | Greene | Georgia | 13133 | 3906 | 83 |
2314426 | 2314426 | 2022-03-17 | Banks | Georgia | 13011 | 3906 | 85 |
2314486 | 2314486 | 2022-03-17 | Greene | Georgia | 13133 | 3906 | 83 |
2311173 | 2311173 | 2022-03-16 | Banks | Georgia | 13011 | 3906 | 85 |
2304427 | 2304427 | 2022-03-14 | Madison | Arkansas | 5087 | 3906 | 60 |
2242400 | 2242400 | 2022-02-22 | Burnett | Wisconsin | 55013 | 3906 | 41 |
2223067 | 2223067 | 2022-02-17 | Northwest Arctic Borough | Alaska | 2188 | 3906 | 11 |
2219816 | 2219816 | 2022-02-16 | Northwest Arctic Borough | Alaska | 2188 | 3906 | 11 |
2222643 | 2222643 | 2022-02-16 | Addison | Vermont | 50001 | 3906 | 15 |
2214428 | 2214428 | 2022-02-14 | Sagadahoc | Maine | 23023 | 3906 | 25 |
2211176 | 2211176 | 2022-02-13 | Sagadahoc | Maine | 23023 | 3906 | 25 |
2212609 | 2212609 | 2022-02-13 | Aransas | Texas | 48007 | 3906 | 73 |
2207923 | 2207923 | 2022-02-12 | Sagadahoc | Maine | 23023 | 3906 | 25 |
2163531 | 2163531 | 2022-01-29 | Catano | Puerto Rico | 72033 | 3906 | |
2152603 | 2152603 | 2022-01-26 | Winn | Louisiana | 22127 | 3906 | 58 |
2127029 | 2127029 | 2022-01-18 | Lincoln | Montana | 30053 | 3906 | 75 |
2100052 | 2100052 | 2022-01-10 | Pike | Illinois | 17149 | 3906 | 62 |
2028324 | 2028324 | 2021-12-19 | Harris | Georgia | 13145 | 3906 | 96 |
2025073 | 2025073 | 2021-12-18 | Harris | Georgia | 13145 | 3906 | 96 |
2021822 | 2021822 | 2021-12-17 | Harris | Georgia | 13145 | 3906 | 96 |
1973746 | 1973746 | 2021-12-02 | Grant | Louisiana | 22043 | 3906 | 79 |
1962167 | 1962167 | 2021-11-28 | Haywood | Tennessee | 47075 | 3906 | 77 |
1958916 | 1958916 | 2021-11-27 | Haywood | Tennessee | 47075 | 3906 | 77 |
1955665 | 1955665 | 2021-11-26 | Haywood | Tennessee | 47075 | 3906 | 77 |
1952414 | 1952414 | 2021-11-25 | Haywood | Tennessee | 47075 | 3906 | 77 |
1949163 | 1949163 | 2021-11-24 | Haywood | Tennessee | 47075 | 3906 | 77 |
1939262 | 1939262 | 2021-11-21 | Abbeville | South Carolina | 45001 | 3906 | 50 |
1936012 | 1936012 | 2021-11-20 | Abbeville | South Carolina | 45001 | 3906 | 50 |
1932762 | 1932762 | 2021-11-19 | Abbeville | South Carolina | 45001 | 3906 | 50 |
1907383 | 1907383 | 2021-11-11 | Russell | Virginia | 51167 | 3906 | 66 |
1897019 | 1897019 | 2021-11-08 | Barnwell | South Carolina | 45011 | 3906 | 85 |
1893769 | 1893769 | 2021-11-07 | Barnwell | South Carolina | 45011 | 3906 | 84 |
1890519 | 1890519 | 2021-11-06 | Barnwell | South Carolina | 45011 | 3906 | 84 |
1887269 | 1887269 | 2021-11-05 | Barnwell | South Carolina | 45011 | 3906 | 84 |
1879453 | 1879453 | 2021-11-03 | Russell | Kentucky | 21207 | 3906 | 61 |
1851760 | 1851760 | 2021-10-25 | Calhoun | Texas | 48057 | 3906 | 36 |
1848510 | 1848510 | 2021-10-24 | Calhoun | Texas | 48057 | 3906 | 36 |
1845260 | 1845260 | 2021-10-23 | Calhoun | Texas | 48057 | 3906 | 36 |
1845723 | 1845723 | 2021-10-23 | Jackson | West Virginia | 54035 | 3906 | 83 |
1842010 | 1842010 | 2021-10-22 | Calhoun | Texas | 48057 | 3906 | 36 |
1791834 | 1791834 | 2021-10-07 | Dorchester | Maryland | 24019 | 3906 | 77 |
1720509 | 1720509 | 2021-09-15 | Lyon | Minnesota | 27083 | 3906 | 54 |
1711323 | 1711323 | 2021-09-12 | Cherokee | North Carolina | 37039 | 3906 | 54 |
1708076 | 1708076 | 2021-09-11 | Cherokee | North Carolina | 37039 | 3906 | 54 |
1704829 | 1704829 | 2021-09-10 | Cherokee | North Carolina | 37039 | 3906 | 54 |
1688543 | 1688543 | 2021-09-05 | Otsego | New York | 36077 | 3906 | 49 |
1675163 | 1675163 | 2021-09-01 | Barry | Missouri | 29009 | 3906 | 56 |
1659571 | 1659571 | 2021-08-27 | Williams | Ohio | 39171 | 3906 | 79 |
1640238 | 1640238 | 2021-08-21 | McKean | Pennsylvania | 42083 | 3906 | 75 |
1630162 | 1630162 | 2021-08-18 | Person | North Carolina | 37145 | 3906 | 76 |
1598107 | 1598107 | 2021-08-08 | Trujillo Alto | Puerto Rico | 72139 | 3906 | |
1583376 | 1583376 | 2021-08-04 | Montgomery | Illinois | 17135 | 3906 | 80 |
1563962 | 1563962 | 2021-07-29 | Knox | Indiana | 18083 | 3906 | 91 |
1538624 | 1538624 | 2021-07-21 | Polk | Minnesota | 27119 | 3906 | 72 |
1534602 | 1534602 | 2021-07-20 | Christian | Illinois | 17021 | 3906 | 93 |
1466553 | 1466553 | 2021-06-29 | Jasper | Indiana | 18073 | 3906 | 57 |
1465463 | 1465463 | 2021-06-28 | Sanpete | Utah | 49039 | 3906 | 23 |
1462218 | 1462218 | 2021-06-27 | Sanpete | Utah | 49039 | 3906 | 23 |
1452434 | 1452434 | 2021-06-24 | Titus | Texas | 48449 | 3906 | 84 |
1448577 | 1448577 | 2021-06-23 | Douglas | Oregon | 41019 | 3906 | 83 |
1426938 | 1426938 | 2021-06-17 | Bethel Census Area | Alaska | 2050 | 3906 | 22 |
1423692 | 1423692 | 2021-06-16 | Bethel Census Area | Alaska | 2050 | 3906 | 22 |
1392743 | 1392743 | 2021-06-06 | Phelps | Missouri | 29161 | 3906 | 130 |
1389498 | 1389498 | 2021-06-05 | Phelps | Missouri | 29161 | 3906 | 130 |
1336635 | 1336635 | 2021-05-20 | Logan | Illinois | 17107 | 3906 | 73 |
1317280 | 1317280 | 2021-05-14 | Steuben | Indiana | 18151 | 3906 | 59 |
1279611 | 1279611 | 2021-05-02 | Brown | Ohio | 39015 | 3906 | 57 |
1276364 | 1276364 | 2021-05-01 | Brown | Ohio | 39015 | 3906 | 57 |
1252923 | 1252923 | 2021-04-24 | Isanti | Minnesota | 27059 | 3906 | 60 |
1235701 | 1235701 | 2021-04-19 | Okeechobee | Florida | 12093 | 3906 | 87 |
1212213 | 1212213 | 2021-04-11 | Washington | Texas | 48477 | 3906 | 90 |
1208964 | 1208964 | 2021-04-10 | Washington | Texas | 48477 | 3906 | 90 |
1163497 | 1163497 | 2021-03-27 | Wharton | Texas | 48481 | 3906 | 111 |
1143576 | 1143576 | 2021-03-21 | Chester | South Carolina | 45023 | 3906 | 69 |
1138112 | 1138112 | 2021-03-20 | Mendocino | California | 6045 | 3906 | 46 |
1120114 | 1120114 | 2021-03-14 | Dakota | Nebraska | 31043 | 3906 | 67 |
1115894 | 1115894 | 2021-03-13 | DeKalb | Indiana | 18033 | 3906 | 83 |
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);