ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where cases = 8656 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Texas 5
- California 4
- Idaho 4
- Michigan 4
- Ohio 4
- Nevada 3
- North Carolina 3
- Vermont 3
- Wyoming 3
- Pennsylvania 2
- Puerto Rico 2
- Colorado 1
- Delaware 1
- Illinois 1
- Indiana 1
- Massachusetts 1
- Minnesota 1
- Mississippi 1
- Nebraska 1
- New York 1
- North Dakota 1
- Tennessee 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501974 | 2501974 | 2022-05-13 | Rio Grande | Puerto Rico | 72119 | 8656 | |
2430961 | 2430961 | 2022-04-21 | Prince George | Virginia | 51149 | 8656 | 77 |
2360892 | 2360892 | 2022-03-31 | Sanilac | Michigan | 26151 | 8656 | 189 |
2357638 | 2357638 | 2022-03-30 | Sanilac | Michigan | 26151 | 8656 | 189 |
2352515 | 2352515 | 2022-03-28 | Erath | Texas | 48143 | 8656 | 123 |
2349490 | 2349490 | 2022-03-27 | Windsor | Vermont | 50027 | 8656 | 50 |
2346237 | 2346237 | 2022-03-26 | Windsor | Vermont | 50027 | 8656 | 50 |
2342984 | 2342984 | 2022-03-25 | Windsor | Vermont | 50027 | 8656 | 50 |
2338121 | 2338121 | 2022-03-24 | Sanilac | Michigan | 26151 | 8656 | 189 |
2334867 | 2334867 | 2022-03-23 | Sanilac | Michigan | 26151 | 8656 | 189 |
2257567 | 2257567 | 2022-02-27 | Champaign | Ohio | 39021 | 8656 | 140 |
2173808 | 2173808 | 2022-02-01 | Washington | Texas | 48477 | 8656 | 138 |
2133268 | 2133268 | 2022-01-20 | McLeod | Minnesota | 27085 | 8656 | 97 |
2133802 | 2133802 | 2022-01-20 | Alexander | North Carolina | 37003 | 8656 | 120 |
2111189 | 2111189 | 2022-01-13 | Williams | North Dakota | 38105 | 8656 | 64 |
2075765 | 2075765 | 2022-01-02 | Toa Baja | Puerto Rico | 72137 | 8656 | |
2014262 | 2014262 | 2021-12-14 | Caldwell | Texas | 48055 | 8656 | 156 |
2008997 | 2008997 | 2021-12-13 | Jackson | Illinois | 17077 | 8656 | 110 |
1924604 | 1924604 | 2021-11-17 | Noble | Indiana | 18113 | 8656 | 122 |
1869191 | 1869191 | 2021-10-31 | Madison | Idaho | 16065 | 8656 | 38 |
1865942 | 1865942 | 2021-10-30 | Madison | Idaho | 16065 | 8656 | 38 |
1862693 | 1862693 | 2021-10-29 | Madison | Idaho | 16065 | 8656 | 38 |
1837338 | 1837338 | 2021-10-21 | Berkshire | Massachusetts | 25003 | 8656 | 320 |
1832409 | 1832409 | 2021-10-19 | Navarro | Texas | 48349 | 8656 | 181 |
1824877 | 1824877 | 2021-10-17 | Carson City | Nevada | 32510 | 8656 | 149 |
1821628 | 1821628 | 2021-10-16 | Carson City | Nevada | 32510 | 8656 | 149 |
1818379 | 1818379 | 2021-10-15 | Carson City | Nevada | 32510 | 8656 | 149 |
1808957 | 1808957 | 2021-10-12 | Geauga | Ohio | 39055 | 8656 | 158 |
1760659 | 1760659 | 2021-09-27 | Bedford | Tennessee | 47003 | 8656 | 147 |
1494062 | 1494062 | 2021-07-07 | Clearfield | Pennsylvania | 42033 | 8656 | 156 |
1282642 | 1282642 | 2021-05-03 | Chautauqua | New York | 36013 | 8656 | 138 |
1256960 | 1256960 | 2021-04-25 | Wayne | Ohio | 39169 | 8656 | 209 |
1214718 | 1214718 | 2021-04-12 | Muskingum | Ohio | 39119 | 8656 | 127 |
1189846 | 1189846 | 2021-04-04 | Laramie | Wyoming | 56021 | 8656 | 110 |
1186599 | 1186599 | 2021-04-03 | Laramie | Wyoming | 56021 | 8656 | 110 |
1183352 | 1183352 | 2021-04-02 | Laramie | Wyoming | 56021 | 8656 | 110 |
1130796 | 1130796 | 2021-03-17 | Bastrop | Texas | 48021 | 8656 | 86 |
1031022 | 1031022 | 2021-02-15 | Sutter | California | 6101 | 8656 | 93 |
1027775 | 1027775 | 2021-02-14 | Sutter | California | 6101 | 8656 | 93 |
1024530 | 1024530 | 2021-02-13 | Sutter | California | 6101 | 8656 | 93 |
1021285 | 1021285 | 2021-02-12 | Sutter | California | 6101 | 8656 | 93 |
993805 | 993805 | 2021-02-03 | Nash | North Carolina | 37127 | 8656 | 143 |
807413 | 807413 | 2020-12-08 | Bonneville | Idaho | 16019 | 8656 | 79 |
802350 | 802350 | 2020-12-06 | Union | North Carolina | 37179 | 8656 | 76 |
733948 | 733948 | 2020-11-15 | Sarpy | Nebraska | 31153 | 8656 | 46 |
727145 | 727145 | 2020-11-13 | DeSoto | Mississippi | 28033 | 8656 | 86 |
528197 | 528197 | 2020-09-13 | Arapahoe | Colorado | 8005 | 8656 | 370 |
508858 | 508858 | 2020-09-07 | New Castle | Delaware | 10003 | 8656 | 303 |
384982 | 384982 | 2020-07-30 | Delaware | Pennsylvania | 42045 | 8656 | 730 |
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);