ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where cases = 4085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 21
- Minnesota 15
- Tennessee 12
- Alabama 11
- Virginia 11
- Mississippi 10
- Iowa 8
- Kentucky 8
- Texas 8
- Michigan 7
- New York 7
- Indiana 5
- Missouri 5
- Illinois 4
- Pennsylvania 4
- West Virginia 4
- Louisiana 3
- Montana 3
- North Carolina 3
- Ohio 3
- Wyoming 3
- Colorado 2
- Nebraska 2
- Arkansas 1
- Idaho 1
- North Dakota 1
- Oregon 1
- Puerto Rico 1
- Utah 1
- Washington 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486269 | 2486269 | 2022-05-08 | Giles | Virginia | 51071 | 4085 | 50 |
2483011 | 2483011 | 2022-05-07 | Giles | Virginia | 51071 | 4085 | 50 |
2479753 | 2479753 | 2022-05-06 | Giles | Virginia | 51071 | 4085 | 50 |
2474183 | 2474183 | 2022-05-05 | Moultrie | Illinois | 17139 | 4085 | 52 |
2470926 | 2470926 | 2022-05-04 | Moultrie | Illinois | 17139 | 4085 | 52 |
2473239 | 2473239 | 2022-05-04 | Goochland | Virginia | 51075 | 4085 | 53 |
2450733 | 2450733 | 2022-04-28 | Clay | Alabama | 1027 | 4085 | 82 |
2447477 | 2447477 | 2022-04-27 | Clay | Alabama | 1027 | 4085 | 82 |
2444221 | 2444221 | 2022-04-26 | Clay | Alabama | 1027 | 4085 | 82 |
2442451 | 2442451 | 2022-04-25 | Yalobusha | Mississippi | 28161 | 4085 | 57 |
2437709 | 2437709 | 2022-04-24 | Clay | Alabama | 1027 | 4085 | 82 |
2439195 | 2439195 | 2022-04-24 | Yalobusha | Mississippi | 28161 | 4085 | 57 |
2434453 | 2434453 | 2022-04-23 | Clay | Alabama | 1027 | 4085 | 82 |
2435939 | 2435939 | 2022-04-23 | Yalobusha | Mississippi | 28161 | 4085 | 57 |
2431197 | 2431197 | 2022-04-22 | Clay | Alabama | 1027 | 4085 | 82 |
2432683 | 2432683 | 2022-04-22 | Yalobusha | Mississippi | 28161 | 4085 | 57 |
2429427 | 2429427 | 2022-04-21 | Yalobusha | Mississippi | 28161 | 4085 | 57 |
2426171 | 2426171 | 2022-04-20 | Yalobusha | Mississippi | 28161 | 4085 | 57 |
2422915 | 2422915 | 2022-04-19 | Yalobusha | Mississippi | 28161 | 4085 | 57 |
2419658 | 2419658 | 2022-04-18 | Yalobusha | Mississippi | 28161 | 4085 | 57 |
2352447 | 2352447 | 2022-03-28 | Aransas | Texas | 48007 | 4085 | 81 |
2346576 | 2346576 | 2022-03-27 | Clay | Alabama | 1027 | 4085 | 81 |
2349195 | 2349195 | 2022-03-27 | Aransas | Texas | 48007 | 4085 | 81 |
2343323 | 2343323 | 2022-03-26 | Clay | Alabama | 1027 | 4085 | 81 |
2345942 | 2345942 | 2022-03-26 | Aransas | Texas | 48007 | 4085 | 81 |
2340070 | 2340070 | 2022-03-25 | Clay | Alabama | 1027 | 4085 | 81 |
2342689 | 2342689 | 2022-03-25 | Aransas | Texas | 48007 | 4085 | 81 |
2310790 | 2310790 | 2022-03-16 | Clay | Alabama | 1027 | 4085 | 81 |
2270794 | 2270794 | 2022-03-03 | Fulton | Pennsylvania | 42057 | 4085 | 64 |
2262807 | 2262807 | 2022-03-01 | Cedar | Iowa | 19031 | 4085 | 32 |
2259556 | 2259556 | 2022-02-28 | Cedar | Iowa | 19031 | 4085 | 32 |
2256305 | 2256305 | 2022-02-27 | Cedar | Iowa | 19031 | 4085 | 32 |
2253054 | 2253054 | 2022-02-26 | Cedar | Iowa | 19031 | 4085 | 32 |
2249803 | 2249803 | 2022-02-25 | Cedar | Iowa | 19031 | 4085 | 32 |
2246552 | 2246552 | 2022-02-24 | Cedar | Iowa | 19031 | 4085 | 32 |
2243301 | 2243301 | 2022-02-23 | Cedar | Iowa | 19031 | 4085 | 32 |
2206590 | 2206590 | 2022-02-11 | Hardy | West Virginia | 54031 | 4085 | 47 |
2203337 | 2203337 | 2022-02-10 | Hardy | West Virginia | 54031 | 4085 | 45 |
2189890 | 2189890 | 2022-02-06 | Deaf Smith | Texas | 48117 | 4085 | 105 |
2173542 | 2173542 | 2022-02-01 | Polk | Tennessee | 47139 | 4085 | 52 |
2170290 | 2170290 | 2022-01-31 | Polk | Tennessee | 47139 | 4085 | 52 |
2167036 | 2167036 | 2022-01-30 | Polk | Tennessee | 47139 | 4085 | 52 |
2163781 | 2163781 | 2022-01-29 | Polk | Tennessee | 47139 | 4085 | 52 |
2160526 | 2160526 | 2022-01-28 | Polk | Tennessee | 47139 | 4085 | 52 |
2157270 | 2157270 | 2022-01-27 | Polk | Tennessee | 47139 | 4085 | 52 |
2154017 | 2154017 | 2022-01-26 | Polk | Tennessee | 47139 | 4085 | 52 |
2133314 | 2133314 | 2022-01-20 | Attala | Mississippi | 28007 | 4085 | 91 |
2115744 | 2115744 | 2022-01-15 | Ashley | Arkansas | 5003 | 4085 | 56 |
2099940 | 2099940 | 2022-01-10 | Blaine | Idaho | 16013 | 4085 | 27 |
2100378 | 2100378 | 2022-01-10 | Adair | Kentucky | 21001 | 4085 | 91 |
2080916 | 2080916 | 2022-01-04 | Harrison | Kentucky | 21097 | 4085 | 57 |
2066827 | 2066827 | 2021-12-30 | Vernon | Wisconsin | 55123 | 4085 | 74 |
2036519 | 2036519 | 2021-12-21 | Beckham | Oklahoma | 40009 | 4085 | 81 |
2033269 | 2033269 | 2021-12-20 | Beckham | Oklahoma | 40009 | 4085 | 81 |
2030019 | 2030019 | 2021-12-19 | Beckham | Oklahoma | 40009 | 4085 | 81 |
2026768 | 2026768 | 2021-12-18 | Beckham | Oklahoma | 40009 | 4085 | 81 |
2023517 | 2023517 | 2021-12-17 | Beckham | Oklahoma | 40009 | 4085 | 81 |
2019407 | 2019407 | 2021-12-16 | Menominee | Michigan | 26109 | 4085 | 58 |
2020266 | 2020266 | 2021-12-16 | Beckham | Oklahoma | 40009 | 4085 | 81 |
2016157 | 2016157 | 2021-12-15 | Menominee | Michigan | 26109 | 4085 | 58 |
2017015 | 2017015 | 2021-12-15 | Beckham | Oklahoma | 40009 | 4085 | 81 |
1985094 | 1985094 | 2021-12-05 | Hutchinson | Texas | 48233 | 4085 | 98 |
1967604 | 1967604 | 2021-11-30 | Audrain | Missouri | 29007 | 4085 | 77 |
1952886 | 1952886 | 2021-11-25 | Russell | Virginia | 51167 | 4085 | 68 |
1944421 | 1944421 | 2021-11-23 | Marion | Kentucky | 21155 | 4085 | 51 |
1928703 | 1928703 | 2021-11-18 | Washington | Missouri | 29221 | 4085 | 94 |
1921771 | 1921771 | 2021-11-16 | Union | Louisiana | 22111 | 4085 | 106 |
1892911 | 1892911 | 2021-11-07 | Miller | Missouri | 29131 | 4085 | 79 |
1781607 | 1781607 | 2021-10-04 | Greene | Indiana | 18055 | 4085 | 98 |
1782779 | 1782779 | 2021-10-04 | Wyoming | New York | 36121 | 4085 | 55 |
1767691 | 1767691 | 2021-09-29 | Clallam | Washington | 53009 | 4085 | 46 |
1755926 | 1755926 | 2021-09-26 | Grayson | Kentucky | 21085 | 4085 | 74 |
1758008 | 1758008 | 2021-09-26 | Mineral | West Virginia | 54057 | 4085 | 101 |
1751637 | 1751637 | 2021-09-25 | Bibb | Alabama | 1007 | 4085 | 81 |
1752678 | 1752678 | 2021-09-25 | Grayson | Kentucky | 21085 | 4085 | 74 |
1749429 | 1749429 | 2021-09-24 | Grayson | Kentucky | 21085 | 4085 | 74 |
1722191 | 1722191 | 2021-09-15 | Warren | Virginia | 51187 | 4085 | 65 |
1697569 | 1697569 | 2021-09-08 | Sabine | Louisiana | 22085 | 4085 | 67 |
1698496 | 1698496 | 2021-09-08 | Guernsey | Ohio | 39059 | 4085 | 55 |
1669063 | 1669063 | 2021-08-30 | Tioga | New York | 36107 | 4085 | 65 |
1643764 | 1643764 | 2021-08-22 | Macon | Tennessee | 47111 | 4085 | 79 |
1640514 | 1640514 | 2021-08-21 | Macon | Tennessee | 47111 | 4085 | 79 |
1637264 | 1637264 | 2021-08-20 | Macon | Tennessee | 47111 | 4085 | 79 |
1609440 | 1609440 | 2021-08-12 | Jasper | Indiana | 18073 | 4085 | 59 |
1569182 | 1569182 | 2021-07-30 | Grimes | Texas | 48185 | 4085 | 74 |
1564480 | 1564480 | 2021-07-29 | Delta | Michigan | 26041 | 4085 | 95 |
1561232 | 1561232 | 2021-07-28 | Delta | Michigan | 26041 | 4085 | 95 |
1557984 | 1557984 | 2021-07-27 | Delta | Michigan | 26041 | 4085 | 95 |
1534620 | 1534620 | 2021-07-20 | Fulton | Illinois | 17057 | 4085 | 67 |
1512639 | 1512639 | 2021-07-13 | Nobles | Minnesota | 27105 | 4085 | 50 |
1509392 | 1509392 | 2021-07-12 | Nobles | Minnesota | 27105 | 4085 | 50 |
1509869 | 1509869 | 2021-07-12 | Columbia | New York | 36021 | 4085 | 104 |
1506146 | 1506146 | 2021-07-11 | Nobles | Minnesota | 27105 | 4085 | 50 |
1506622 | 1506622 | 2021-07-11 | Columbia | New York | 36021 | 4085 | 104 |
1502900 | 1502900 | 2021-07-10 | Nobles | Minnesota | 27105 | 4085 | 50 |
1503376 | 1503376 | 2021-07-10 | Columbia | New York | 36021 | 4085 | 104 |
1499654 | 1499654 | 2021-07-09 | Nobles | Minnesota | 27105 | 4085 | 50 |
1500130 | 1500130 | 2021-07-09 | Columbia | New York | 36021 | 4085 | 104 |
1496359 | 1496359 | 2021-07-08 | Beltrami | Minnesota | 27007 | 4085 | 63 |
1492578 | 1492578 | 2021-07-07 | Whitley | Indiana | 18183 | 4085 | 44 |
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);