ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where cases = 5973 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Tennessee 17
- South Carolina 9
- Texas 8
- Ohio 5
- Puerto Rico 5
- Virginia 5
- Michigan 4
- Nebraska 3
- North Carolina 3
- Pennsylvania 3
- Alabama 2
- Florida 2
- Georgia 2
- Kentucky 2
- Louisiana 2
- New York 2
- Wisconsin 2
- Arkansas 1
- Guam 1
- Indiana 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Nevada 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501935 | 2501935 | 2022-05-13 | Coamo | Puerto Rico | 72043 | 5973 | |
2482396 | 2482396 | 2022-05-07 | Guayama | Puerto Rico | 72057 | 5973 | |
2449907 | 2449907 | 2022-04-27 | Fairfield | South Carolina | 45039 | 5973 | 107 |
2446650 | 2446650 | 2022-04-26 | Fairfield | South Carolina | 45039 | 5973 | 107 |
2447268 | 2447268 | 2022-04-26 | Waynesboro city | Virginia | 51820 | 5973 | 69 |
2443395 | 2443395 | 2022-04-25 | Fairfield | South Carolina | 45039 | 5973 | 107 |
2444012 | 2444012 | 2022-04-25 | Waynesboro city | Virginia | 51820 | 5973 | 69 |
2440139 | 2440139 | 2022-04-24 | Fairfield | South Carolina | 45039 | 5973 | 107 |
2436883 | 2436883 | 2022-04-23 | Fairfield | South Carolina | 45039 | 5973 | 107 |
2433627 | 2433627 | 2022-04-22 | Fairfield | South Carolina | 45039 | 5973 | 107 |
2430371 | 2430371 | 2022-04-21 | Fairfield | South Carolina | 45039 | 5973 | 107 |
2427115 | 2427115 | 2022-04-20 | Fairfield | South Carolina | 45039 | 5973 | 107 |
2423859 | 2423859 | 2022-04-19 | Fairfield | South Carolina | 45039 | 5973 | 107 |
2313152 | 2313152 | 2022-03-16 | Juncos | Puerto Rico | 72077 | 5973 | |
2287770 | 2287770 | 2022-03-08 | Mecklenburg | Virginia | 51117 | 5973 | 109 |
2274087 | 2274087 | 2022-03-04 | Aguada | Puerto Rico | 72003 | 5973 | |
2266712 | 2266712 | 2022-03-02 | Newton | Mississippi | 28101 | 5973 | 96 |
2218881 | 2218881 | 2022-02-15 | San Sebastian | Puerto Rico | 72131 | 5973 | |
2219049 | 2219049 | 2022-02-15 | Haywood | Tennessee | 47075 | 5973 | 88 |
2215798 | 2215798 | 2022-02-14 | Haywood | Tennessee | 47075 | 5973 | 88 |
2212547 | 2212547 | 2022-02-13 | Haywood | Tennessee | 47075 | 5973 | 88 |
2209294 | 2209294 | 2022-02-12 | Haywood | Tennessee | 47075 | 5973 | 88 |
2206041 | 2206041 | 2022-02-11 | Haywood | Tennessee | 47075 | 5973 | 88 |
2202788 | 2202788 | 2022-02-10 | Haywood | Tennessee | 47075 | 5973 | 88 |
2199534 | 2199534 | 2022-02-09 | Haywood | Tennessee | 47075 | 5973 | 88 |
2141276 | 2141276 | 2022-01-22 | Willacy | Texas | 48489 | 5973 | 117 |
2030405 | 2030405 | 2021-12-19 | Claiborne | Tennessee | 47025 | 5973 | 120 |
2027154 | 2027154 | 2021-12-18 | Claiborne | Tennessee | 47025 | 5973 | 120 |
2023903 | 2023903 | 2021-12-17 | Claiborne | Tennessee | 47025 | 5973 | 120 |
1984093 | 1984093 | 2021-12-05 | Platte | Nebraska | 31141 | 5973 | 60 |
1980843 | 1980843 | 2021-12-04 | Platte | Nebraska | 31141 | 5973 | 60 |
1977593 | 1977593 | 2021-12-03 | Platte | Nebraska | 31141 | 5973 | 60 |
1978664 | 1978664 | 2021-12-03 | Polk | Texas | 48373 | 5973 | 217 |
1948894 | 1948894 | 2021-11-24 | Jefferson | Pennsylvania | 42065 | 5973 | 142 |
1860436 | 1860436 | 2021-10-28 | Platte | Missouri | 29165 | 5973 | 61 |
1854466 | 1854466 | 2021-10-26 | Madison | Ohio | 39097 | 5973 | 80 |
1851111 | 1851111 | 2021-10-25 | Yadkin | North Carolina | 37197 | 5973 | 73 |
1795734 | 1795734 | 2021-10-08 | Fulton | New York | 36035 | 5973 | 100 |
1769651 | 1769651 | 2021-09-30 | Lyon | Nevada | 32019 | 5973 | 92 |
1765807 | 1765807 | 2021-09-29 | Vernon | Louisiana | 22115 | 5973 | 156 |
1766763 | 1766763 | 2021-09-29 | Shelby | Ohio | 39149 | 5973 | 105 |
1724389 | 1724389 | 2021-09-16 | Watauga | North Carolina | 37189 | 5973 | 34 |
1694326 | 1694326 | 2021-09-07 | St. John the Baptist | Louisiana | 22095 | 5973 | 153 |
1676486 | 1676486 | 2021-09-01 | Rusk | Texas | 48401 | 5973 | 123 |
1643032 | 1643032 | 2021-08-22 | Cattaraugus | New York | 36009 | 5973 | 94 |
1604139 | 1604139 | 2021-08-10 | Edgecombe | North Carolina | 37065 | 5973 | 115 |
1588099 | 1588099 | 2021-08-05 | Union | Ohio | 39159 | 5973 | 49 |
1560705 | 1560705 | 2021-07-28 | Henry | Indiana | 18065 | 5973 | 113 |
1556638 | 1556638 | 2021-07-26 | Columbia | Wisconsin | 55021 | 5973 | 73 |
1515605 | 1515605 | 2021-07-14 | Pike | Kentucky | 21195 | 5973 | 110 |
1509263 | 1509263 | 2021-07-12 | Barry | Michigan | 26015 | 5973 | 69 |
1506017 | 1506017 | 2021-07-11 | Barry | Michigan | 26015 | 5973 | 69 |
1507530 | 1507530 | 2021-07-11 | Lamar | Texas | 48277 | 5973 | 158 |
1502771 | 1502771 | 2021-07-10 | Barry | Michigan | 26015 | 5973 | 69 |
1504284 | 1504284 | 2021-07-10 | Lamar | Texas | 48277 | 5973 | 157 |
1499525 | 1499525 | 2021-07-09 | Barry | Michigan | 26015 | 5973 | 69 |
1501038 | 1501038 | 2021-07-09 | Lamar | Texas | 48277 | 5973 | 157 |
1497792 | 1497792 | 2021-07-08 | Lamar | Texas | 48277 | 5973 | 157 |
1494545 | 1494545 | 2021-07-07 | Lamar | Texas | 48277 | 5973 | 157 |
1439194 | 1439194 | 2021-06-20 | Monroe | Tennessee | 47123 | 5973 | 96 |
1435947 | 1435947 | 2021-06-19 | Monroe | Tennessee | 47123 | 5973 | 96 |
1432700 | 1432700 | 2021-06-18 | Monroe | Tennessee | 47123 | 5973 | 96 |
1361822 | 1361822 | 2021-05-27 | Harrison | West Virginia | 54033 | 5973 | 77 |
1292851 | 1292851 | 2021-05-06 | Union | Pennsylvania | 42119 | 5973 | 86 |
1280107 | 1280107 | 2021-05-02 | Hawkins | Tennessee | 47073 | 5973 | 107 |
1276860 | 1276860 | 2021-05-01 | Hawkins | Tennessee | 47073 | 5973 | 107 |
1273613 | 1273613 | 2021-04-30 | Hawkins | Tennessee | 47073 | 5973 | 107 |
1262518 | 1262518 | 2021-04-27 | Cecil | Maryland | 24015 | 5973 | 128 |
1261282 | 1261282 | 2021-04-26 | Waupaca | Wisconsin | 55135 | 5973 | 161 |
1131548 | 1131548 | 2021-03-18 | Greene | Arkansas | 5055 | 5973 | 74 |
1071824 | 1071824 | 2021-02-27 | Hancock | Ohio | 39063 | 5973 | 112 |
1056768 | 1056768 | 2021-02-23 | Colbert | Alabama | 1033 | 5973 | 118 |
1030790 | 1030790 | 2021-02-15 | Blount | Alabama | 1009 | 5973 | 121 |
1017110 | 1017110 | 2021-02-10 | Gibson | Tennessee | 47053 | 5973 | 130 |
1012338 | 1012338 | 2021-02-09 | Christian | Kentucky | 21047 | 5973 | 78 |
998064 | 998064 | 2021-02-04 | Hanover | Virginia | 51085 | 5973 | 102 |
952736 | 952736 | 2021-01-21 | Thurston | Washington | 53067 | 5973 | 65 |
905439 | 905439 | 2021-01-07 | Barnstable | Massachusetts | 25001 | 5973 | 269 |
884500 | 884500 | 2020-12-31 | Newport News city | Virginia | 51700 | 5973 | 69 |
797560 | 797560 | 2020-12-05 | Floyd | Georgia | 13115 | 5973 | 92 |
796149 | 796149 | 2020-12-04 | Cumberland | Pennsylvania | 42041 | 5973 | 161 |
773232 | 773232 | 2020-11-27 | Delaware | Ohio | 39041 | 5973 | 37 |
700319 | 700319 | 2020-11-05 | Unknown | Guam | 5973 | 84 | |
567295 | 567295 | 2020-09-25 | Muscogee | Georgia | 13215 | 5973 | 168 |
490482 | 490482 | 2020-09-01 | Dakota | Minnesota | 27037 | 5973 | 111 |
262299 | 262299 | 2020-06-22 | Hillsborough | Florida | 12057 | 5973 | 115 |
136529 | 136529 | 2020-05-12 | Broward | Florida | 12011 | 5973 | 258 |
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);