ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where cases = 5386 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Iowa 8
- Texas 8
- New York 6
- Ohio 6
- South Dakota 6
- Tennessee 6
- Georgia 4
- Puerto Rico 4
- Minnesota 3
- Utah 3
- Arkansas 2
- Illinois 2
- Michigan 2
- Missouri 2
- Nebraska 2
- Virginia 2
- West Virginia 2
- Alabama 1
- California 1
- Colorado 1
- Idaho 1
- Maryland 1
- Montana 1
- North Carolina 1
- Oklahoma 1
- Pennsylvania 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474204 | 2474204 | 2022-05-05 | Union | Illinois | 17181 | 5386 | 68 |
2470947 | 2470947 | 2022-05-04 | Union | Illinois | 17181 | 5386 | 68 |
2469967 | 2469967 | 2022-05-03 | Dinwiddie | Virginia | 51053 | 5386 | 93 |
2351341 | 2351341 | 2022-03-28 | Crawford | Missouri | 29055 | 5386 | 101 |
2268661 | 2268661 | 2022-03-03 | Ouachita | Arkansas | 5103 | 5386 | 95 |
2268948 | 2268948 | 2022-03-03 | Franklin | Georgia | 13119 | 5386 | 94 |
2242614 | 2242614 | 2022-02-23 | Conway | Arkansas | 5029 | 5386 | 56 |
2244641 | 2244641 | 2022-02-23 | Wyandot | Ohio | 39175 | 5386 | 100 |
2245611 | 2245611 | 2022-02-23 | Lincoln | West Virginia | 54043 | 5386 | 68 |
2240087 | 2240087 | 2022-02-22 | Jones | Iowa | 19105 | 5386 | 70 |
2240647 | 2240647 | 2022-02-22 | Waseca | Minnesota | 27161 | 5386 | 39 |
2236836 | 2236836 | 2022-02-21 | Jones | Iowa | 19105 | 5386 | 70 |
2233585 | 2233585 | 2022-02-20 | Jones | Iowa | 19105 | 5386 | 70 |
2234598 | 2234598 | 2022-02-20 | Essex | New York | 36031 | 5386 | 55 |
2230334 | 2230334 | 2022-02-19 | Jones | Iowa | 19105 | 5386 | 70 |
2227083 | 2227083 | 2022-02-18 | Jones | Iowa | 19105 | 5386 | 70 |
2223832 | 2223832 | 2022-02-17 | Jones | Iowa | 19105 | 5386 | 70 |
2220581 | 2220581 | 2022-02-16 | Jones | Iowa | 19105 | 5386 | 70 |
2150128 | 2150128 | 2022-01-25 | Martin | North Carolina | 37117 | 5386 | 78 |
2098634 | 2098634 | 2022-01-09 | Meade | South Dakota | 46093 | 5386 | 56 |
2095382 | 2095382 | 2022-01-08 | Meade | South Dakota | 46093 | 5386 | 56 |
2092130 | 2092130 | 2022-01-07 | Meade | South Dakota | 46093 | 5386 | 56 |
2063664 | 2063664 | 2021-12-30 | Pike | Alabama | 1109 | 5386 | 111 |
2066799 | 2066799 | 2021-12-30 | Lincoln | Wisconsin | 55069 | 5386 | 125 |
2059674 | 2059674 | 2021-12-28 | Hardeman | Tennessee | 47069 | 5386 | 96 |
1964715 | 1964715 | 2021-11-29 | Franklin | New York | 36033 | 5386 | 26 |
1926746 | 1926746 | 2021-11-17 | Uintah | Utah | 49047 | 5386 | 52 |
1923496 | 1923496 | 2021-11-16 | Uintah | Utah | 49047 | 5386 | 52 |
1894484 | 1894484 | 2021-11-07 | Preston | West Virginia | 54077 | 5386 | 87 |
1874586 | 1874586 | 2021-11-01 | Hopkins | Texas | 48223 | 5386 | 146 |
1871337 | 1871337 | 2021-10-31 | Hopkins | Texas | 48223 | 5386 | 146 |
1867078 | 1867078 | 2021-10-30 | Lincoln | Nebraska | 31111 | 5386 | 80 |
1868088 | 1868088 | 2021-10-30 | Hopkins | Texas | 48223 | 5386 | 146 |
1863829 | 1863829 | 2021-10-29 | Lincoln | Nebraska | 31111 | 5386 | 80 |
1861257 | 1861257 | 2021-10-28 | Unknown | Puerto Rico | 5386 | 3228 | |
1858008 | 1858008 | 2021-10-27 | Unknown | Puerto Rico | 5386 | 3227 | |
1828261 | 1828261 | 2021-10-18 | Warren | New York | 36113 | 5386 | 82 |
1825515 | 1825515 | 2021-10-17 | Unknown | Puerto Rico | 5386 | 3207 | |
1825588 | 1825588 | 2021-10-17 | Codington | South Dakota | 46029 | 5386 | 83 |
1822266 | 1822266 | 2021-10-16 | Unknown | Puerto Rico | 5386 | 3207 | |
1822339 | 1822339 | 2021-10-16 | Codington | South Dakota | 46029 | 5386 | 83 |
1819090 | 1819090 | 2021-10-15 | Codington | South Dakota | 46029 | 5386 | 83 |
1758546 | 1758546 | 2021-09-27 | Chattahoochee | Georgia | 13053 | 5386 | 17 |
1740509 | 1740509 | 2021-09-21 | Madison | New York | 36053 | 5386 | 97 |
1698541 | 1698541 | 2021-09-08 | Shelby | Ohio | 39149 | 5386 | 98 |
1624743 | 1624743 | 2021-08-16 | Washington | Virginia | 51191 | 5386 | 115 |
1575096 | 1575096 | 2021-08-01 | Seneca | Ohio | 39147 | 5386 | 128 |
1344555 | 1344555 | 2021-05-22 | Darke | Ohio | 39037 | 5386 | 126 |
1310819 | 1310819 | 2021-05-12 | Cerro Gordo | Iowa | 19033 | 5386 | 89 |
1236591 | 1236591 | 2021-04-19 | Chippewa | Michigan | 26033 | 5386 | 48 |
1202505 | 1202505 | 2021-04-08 | Summit | Utah | 49043 | 5386 | 11 |
1182840 | 1182840 | 2021-04-02 | Hardin | Texas | 48199 | 5386 | 108 |
1175727 | 1175727 | 2021-03-31 | Lawrence | Ohio | 39087 | 5386 | 98 |
1164148 | 1164148 | 2021-03-28 | Garfield | Colorado | 8045 | 5386 | 38 |
1143766 | 1143766 | 2021-03-21 | Warren | Tennessee | 47177 | 5386 | 79 |
1140519 | 1140519 | 2021-03-20 | Warren | Tennessee | 47177 | 5386 | 79 |
1137273 | 1137273 | 2021-03-19 | Warren | Tennessee | 47177 | 5386 | 79 |
1081320 | 1081320 | 2021-03-02 | Cayuga | New York | 36011 | 5386 | 88 |
1073455 | 1073455 | 2021-02-28 | Laurens | Georgia | 13175 | 5386 | 155 |
1036759 | 1036759 | 2021-02-16 | Henderson | Texas | 48213 | 5386 | 147 |
997619 | 997619 | 2021-02-04 | Carter | Tennessee | 47019 | 5386 | 137 |
979072 | 979072 | 2021-01-30 | San Benito | California | 6069 | 5386 | 52 |
952173 | 952173 | 2021-01-21 | Bedford | Tennessee | 47003 | 5386 | 90 |
921663 | 921663 | 2021-01-12 | Wicomico | Maryland | 24045 | 5386 | 94 |
916801 | 916801 | 2021-01-10 | Val Verde | Texas | 48465 | 5386 | 155 |
913556 | 913556 | 2021-01-09 | Val Verde | Texas | 48465 | 5386 | 155 |
904800 | 904800 | 2021-01-07 | Madison | Idaho | 16065 | 5386 | 21 |
873967 | 873967 | 2020-12-28 | Pottawatomie | Oklahoma | 40125 | 5386 | 33 |
838199 | 838199 | 2020-12-17 | Tuscarawas | Ohio | 39157 | 5386 | 107 |
795487 | 795487 | 2020-12-04 | Cascade | Montana | 30013 | 5386 | 75 |
787878 | 787878 | 2020-12-02 | Paulding | Georgia | 13223 | 5386 | 85 |
786431 | 786431 | 2020-12-01 | Lebanon | Pennsylvania | 42075 | 5386 | 112 |
769303 | 769303 | 2020-11-26 | Sherburne | Minnesota | 27141 | 5386 | 40 |
766057 | 766057 | 2020-11-25 | Sherburne | Minnesota | 27141 | 5386 | 40 |
702612 | 702612 | 2020-11-05 | Tom Green | Texas | 48451 | 5386 | 84 |
480979 | 480979 | 2020-08-29 | Jackson | Missouri | 29095 | 5386 | 77 |
474835 | 474835 | 2020-08-27 | Monroe | New York | 36055 | 5386 | 256 |
310462 | 310462 | 2020-07-07 | Kent | Michigan | 26081 | 5386 | 139 |
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);