ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where cases = 7787 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Ohio 8
- Oklahoma 7
- Georgia 4
- Connecticut 3
- Indiana 3
- South Carolina 3
- Florida 2
- Kansas 2
- New York 2
- Arizona 1
- Guam 1
- Illinois 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Nebraska 1
- Nevada 1
- New Mexico 1
- Pennsylvania 1
- Tennessee 1
- Texas 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490337 | 2490337 | 2022-05-10 | Upson | Georgia | 13293 | 7787 | 234 |
2487080 | 2487080 | 2022-05-09 | Upson | Georgia | 13293 | 7787 | 234 |
2472382 | 2472382 | 2022-05-04 | Morrow | Ohio | 39117 | 7787 | 103 |
2469126 | 2469126 | 2022-05-03 | Morrow | Ohio | 39117 | 7787 | 103 |
2465870 | 2465870 | 2022-05-02 | Morrow | Ohio | 39117 | 7787 | 103 |
2462615 | 2462615 | 2022-05-01 | Morrow | Ohio | 39117 | 7787 | 103 |
2459359 | 2459359 | 2022-04-30 | Morrow | Ohio | 39117 | 7787 | 103 |
2456103 | 2456103 | 2022-04-29 | Morrow | Ohio | 39117 | 7787 | 103 |
2452847 | 2452847 | 2022-04-28 | Morrow | Ohio | 39117 | 7787 | 103 |
2354622 | 2354622 | 2022-03-29 | Lafayette | Missouri | 29107 | 7787 | 128 |
2166868 | 2166868 | 2022-01-30 | Clarendon | South Carolina | 45027 | 7787 | 141 |
2163613 | 2163613 | 2022-01-29 | Clarendon | South Carolina | 45027 | 7787 | 141 |
2160358 | 2160358 | 2022-01-28 | Clarendon | South Carolina | 45027 | 7787 | 141 |
2156396 | 2156396 | 2022-01-27 | Lincoln | Nebraska | 31111 | 7787 | 87 |
2152558 | 2152558 | 2022-01-26 | Evangeline | Louisiana | 22039 | 7787 | 146 |
2151383 | 2151383 | 2022-01-25 | Trempealeau | Wisconsin | 55121 | 7787 | 58 |
2126809 | 2126809 | 2022-01-18 | Bolivar | Mississippi | 28011 | 7787 | 155 |
2121168 | 2121168 | 2022-01-16 | Clinton | Pennsylvania | 42035 | 7787 | 115 |
2100777 | 2100777 | 2022-01-10 | Steele | Minnesota | 27147 | 7787 | 43 |
2091697 | 2091697 | 2022-01-07 | Clinton | Ohio | 39027 | 7787 | 118 |
2033657 | 2033657 | 2021-12-20 | Cocke | Tennessee | 47029 | 7787 | 125 |
1945565 | 1945565 | 2021-11-23 | Stephens | Oklahoma | 40137 | 7787 | 144 |
1941914 | 1941914 | 2021-11-22 | Curry | New Mexico | 35009 | 7787 | 126 |
1942314 | 1942314 | 2021-11-22 | Stephens | Oklahoma | 40137 | 7787 | 144 |
1939064 | 1939064 | 2021-11-21 | Stephens | Oklahoma | 40137 | 7787 | 144 |
1935814 | 1935814 | 2021-11-20 | Stephens | Oklahoma | 40137 | 7787 | 144 |
1932564 | 1932564 | 2021-11-19 | Stephens | Oklahoma | 40137 | 7787 | 144 |
1929313 | 1929313 | 2021-11-18 | Stephens | Oklahoma | 40137 | 7787 | 144 |
1926063 | 1926063 | 2021-11-17 | Stephens | Oklahoma | 40137 | 7787 | 144 |
1881697 | 1881697 | 2021-11-04 | Graham | Arizona | 4009 | 7787 | 119 |
1852882 | 1852882 | 2021-10-26 | Thomas | Georgia | 13275 | 7787 | 178 |
1849633 | 1849633 | 2021-10-25 | Thomas | Georgia | 13275 | 7787 | 178 |
1762115 | 1762115 | 2021-09-28 | Henry | Indiana | 18065 | 7787 | 142 |
1746116 | 1746116 | 2021-09-23 | Saline | Kansas | 20169 | 7787 | 165 |
1742867 | 1742867 | 2021-09-22 | Saline | Kansas | 20169 | 7787 | 165 |
1740533 | 1740533 | 2021-09-21 | Sullivan | New York | 36105 | 7787 | 81 |
1490387 | 1490387 | 2021-07-06 | Chemung | New York | 36015 | 7787 | 136 |
1424347 | 1424347 | 2021-06-16 | Floyd | Indiana | 18043 | 7787 | 185 |
1307551 | 1307551 | 2021-05-11 | Warrick | Indiana | 18173 | 7787 | 158 |
1154127 | 1154127 | 2021-03-24 | Natrona | Wyoming | 56025 | 7787 | 133 |
1073293 | 1073293 | 2021-02-28 | Tolland | Connecticut | 9013 | 7787 | 163 |
1070047 | 1070047 | 2021-02-27 | Tolland | Connecticut | 9013 | 7787 | 163 |
1066802 | 1066802 | 2021-02-26 | Tolland | Connecticut | 9013 | 7787 | 163 |
970327 | 970327 | 2021-01-27 | Charles | Maryland | 24017 | 7787 | 144 |
958972 | 958972 | 2021-01-23 | Starr | Texas | 48427 | 7787 | 219 |
865922 | 865922 | 2020-12-26 | Macon | Illinois | 17115 | 7787 | 165 |
778194 | 778194 | 2020-11-29 | Unknown | Guam | 7787 | 113 | |
547749 | 547749 | 2020-09-19 | St. Lucie | Florida | 12111 | 7787 | 263 |
518567 | 518567 | 2020-09-10 | Brevard | Florida | 12009 | 7787 | 245 |
513543 | 513543 | 2020-09-08 | Washoe | Nevada | 32031 | 7787 | 147 |
454827 | 454827 | 2020-08-21 | Hampden | Massachusetts | 25013 | 7787 | 732 |
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);