ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 7185 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Mississippi 10
- Tennessee 5
- Michigan 3
- North Carolina 3
- Texas 3
- Idaho 2
- Indiana 2
- New Jersey 2
- Ohio 2
- Oregon 2
- South Carolina 2
- Washington 2
- Alabama 1
- Arizona 1
- Arkansas 1
- Georgia 1
- Illinois 1
- Kentucky 1
- Minnesota 1
- Missouri 1
- Montana 1
- New Mexico 1
- New York 1
- North Dakota 1
- Pennsylvania 1
- Vermont 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442384 | 2442384 | 2022-04-25 | Copiah | Mississippi | 28029 | 7185 | 121 |
2439128 | 2439128 | 2022-04-24 | Copiah | Mississippi | 28029 | 7185 | 121 |
2435872 | 2435872 | 2022-04-23 | Copiah | Mississippi | 28029 | 7185 | 121 |
2432616 | 2432616 | 2022-04-22 | Copiah | Mississippi | 28029 | 7185 | 121 |
2429360 | 2429360 | 2022-04-21 | Copiah | Mississippi | 28029 | 7185 | 121 |
2426104 | 2426104 | 2022-04-20 | Copiah | Mississippi | 28029 | 7185 | 121 |
2422848 | 2422848 | 2022-04-19 | Copiah | Mississippi | 28029 | 7185 | 121 |
2419592 | 2419592 | 2022-04-18 | Copiah | Mississippi | 28029 | 7185 | 121 |
2373165 | 2373165 | 2022-04-04 | Elmore | Idaho | 16039 | 7185 | 70 |
2332958 | 2332958 | 2022-03-22 | Cass | Texas | 48067 | 7185 | 194 |
2313025 | 2313025 | 2022-03-16 | Jefferson | Oregon | 41031 | 7185 | 86 |
2309772 | 2309772 | 2022-03-15 | Jefferson | Oregon | 41031 | 7185 | 86 |
2220210 | 2220210 | 2022-02-16 | Lee | Georgia | 13177 | 7185 | 95 |
2218571 | 2218571 | 2022-02-15 | Gallia | Ohio | 39053 | 7185 | 106 |
2176658 | 2176658 | 2022-02-02 | Union | South Carolina | 45087 | 7185 | 130 |
2138072 | 2138072 | 2022-01-21 | Washington | Vermont | 50023 | 7185 | 40 |
2132668 | 2132668 | 2022-01-20 | Ripley | Indiana | 18137 | 7185 | 117 |
2029961 | 2029961 | 2021-12-19 | Highland | Ohio | 39071 | 7185 | 128 |
1953661 | 1953661 | 2021-11-26 | Bingham | Idaho | 16011 | 7185 | 126 |
1918812 | 1918812 | 2021-11-15 | Oktibbeha | Mississippi | 28105 | 7185 | 138 |
1906404 | 1906404 | 2021-11-11 | Williams | North Dakota | 38105 | 7185 | 54 |
1903846 | 1903846 | 2021-11-10 | Jim Wells | Texas | 48249 | 7185 | 178 |
1897907 | 1897907 | 2021-11-09 | Tallapoosa | Alabama | 1123 | 7185 | 202 |
1900596 | 1900596 | 2021-11-09 | Jim Wells | Texas | 48249 | 7185 | 178 |
1875714 | 1875714 | 2021-11-02 | Clinton | Illinois | 17027 | 7185 | 112 |
1736446 | 1736446 | 2021-09-20 | Jessamine | Kentucky | 21113 | 7185 | 83 |
1643755 | 1643755 | 2021-08-22 | Jefferson | Tennessee | 47089 | 7185 | 132 |
1640505 | 1640505 | 2021-08-21 | Jefferson | Tennessee | 47089 | 7185 | 132 |
1637255 | 1637255 | 2021-08-20 | Jefferson | Tennessee | 47089 | 7185 | 132 |
1627875 | 1627875 | 2021-08-17 | Bedford | Virginia | 51019 | 7185 | 111 |
1597633 | 1597633 | 2021-08-08 | Columbus | North Carolina | 37047 | 7185 | 161 |
1594384 | 1594384 | 2021-08-07 | Columbus | North Carolina | 37047 | 7185 | 161 |
1591135 | 1591135 | 2021-08-06 | Columbus | North Carolina | 37047 | 7185 | 161 |
1582004 | 1582004 | 2021-08-03 | Cumberland | Tennessee | 47035 | 7185 | 143 |
1541808 | 1541808 | 2021-07-22 | Van Buren | Michigan | 26159 | 7185 | 133 |
1538561 | 1538561 | 2021-07-21 | Van Buren | Michigan | 26159 | 7185 | 133 |
1535314 | 1535314 | 2021-07-20 | Van Buren | Michigan | 26159 | 7185 | 133 |
1514322 | 1514322 | 2021-07-13 | Chelan | Washington | 53007 | 7185 | 73 |
1511076 | 1511076 | 2021-07-12 | Chelan | Washington | 53007 | 7185 | 72 |
1420501 | 1420501 | 2021-06-15 | Crawford | Arkansas | 5033 | 7185 | 120 |
1262641 | 1262641 | 2021-04-27 | Blue Earth | Minnesota | 27013 | 7185 | 40 |
1207554 | 1207554 | 2021-04-10 | Lauderdale | Mississippi | 28075 | 7185 | 237 |
1180909 | 1180909 | 2021-04-02 | Wayne | Indiana | 18177 | 7185 | 200 |
1058267 | 1058267 | 2021-02-23 | Cass | Missouri | 29037 | 7185 | 89 |
1052111 | 1052111 | 2021-02-21 | Chautauqua | New York | 36013 | 7185 | 121 |
1000759 | 1000759 | 2021-02-05 | Darlington | South Carolina | 45031 | 7185 | 141 |
954700 | 954700 | 2021-01-22 | Sussex | New Jersey | 34037 | 7185 | 248 |
948020 | 948020 | 2021-01-20 | Cascade | Montana | 30013 | 7185 | 122 |
764760 | 764760 | 2020-11-25 | Coconino | Arizona | 4005 | 7185 | 169 |
607510 | 607510 | 2020-10-07 | Bernalillo | New Mexico | 35001 | 7185 | 180 |
544041 | 544041 | 2020-09-17 | Brown | Wisconsin | 55009 | 7185 | 59 |
520532 | 520532 | 2020-09-10 | Lancaster | Pennsylvania | 42071 | 7185 | 443 |
269937 | 269937 | 2020-06-24 | Camden | New Jersey | 34007 | 7185 | 425 |
242569 | 242569 | 2020-06-15 | Davidson | Tennessee | 47037 | 7185 | 88 |
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);