ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 8506 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Florida 14
- Missouri 3
- New York 3
- Wyoming 3
- South Carolina 2
- Texas 2
- Alabama 1
- Arkansas 1
- California 1
- Indiana 1
- Kentucky 1
- Mississippi 1
- North Carolina 1
- Ohio 1
- Pennsylvania 1
- Tennessee 1
- Virginia 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496325 | 2496325 | 2022-05-12 | Chambers | Alabama | 1017 | 8506 | 162 |
2319152 | 2319152 | 2022-03-18 | Greene | New York | 36039 | 8506 | 123 |
2267710 | 2267710 | 2022-03-02 | Williamsburg | South Carolina | 45089 | 8506 | 140 |
2264457 | 2264457 | 2022-03-01 | Williamsburg | South Carolina | 45089 | 8506 | 140 |
2252355 | 2252355 | 2022-02-26 | Baxter | Arkansas | 5005 | 8506 | 230 |
2245532 | 2245532 | 2022-02-23 | Smyth | Virginia | 51173 | 8506 | 158 |
2223307 | 2223307 | 2022-02-17 | Baker | Florida | 12003 | 8506 | 130 |
2223329 | 2223329 | 2022-02-17 | Hardee | Florida | 12049 | 8506 | 114 |
2220056 | 2220056 | 2022-02-16 | Baker | Florida | 12003 | 8506 | 130 |
2220078 | 2220078 | 2022-02-16 | Hardee | Florida | 12049 | 8506 | 114 |
2216805 | 2216805 | 2022-02-15 | Baker | Florida | 12003 | 8506 | 129 |
2216827 | 2216827 | 2022-02-15 | Hardee | Florida | 12049 | 8506 | 113 |
2213554 | 2213554 | 2022-02-14 | Baker | Florida | 12003 | 8506 | 129 |
2213576 | 2213576 | 2022-02-14 | Hardee | Florida | 12049 | 8506 | 113 |
2210302 | 2210302 | 2022-02-13 | Baker | Florida | 12003 | 8506 | 129 |
2210324 | 2210324 | 2022-02-13 | Hardee | Florida | 12049 | 8506 | 113 |
2207049 | 2207049 | 2022-02-12 | Baker | Florida | 12003 | 8506 | 129 |
2207071 | 2207071 | 2022-02-12 | Hardee | Florida | 12049 | 8506 | 113 |
2203796 | 2203796 | 2022-02-11 | Baker | Florida | 12003 | 8506 | 129 |
2203818 | 2203818 | 2022-02-11 | Hardee | Florida | 12049 | 8506 | 113 |
2176931 | 2176931 | 2022-02-02 | Hill | Texas | 48217 | 8506 | 184 |
2126184 | 2126184 | 2022-01-18 | Whitley | Indiana | 18183 | 8506 | 73 |
2099370 | 2099370 | 2022-01-09 | Sweetwater | Wyoming | 56037 | 8506 | 110 |
2096119 | 2096119 | 2022-01-08 | Sweetwater | Wyoming | 56037 | 8506 | 110 |
2092867 | 2092867 | 2022-01-07 | Sweetwater | Wyoming | 56037 | 8506 | 110 |
2075237 | 2075237 | 2022-01-02 | Montgomery | New York | 36057 | 8506 | 177 |
2039124 | 2039124 | 2021-12-22 | Callaway | Missouri | 29027 | 8506 | 98 |
1867254 | 1867254 | 2021-10-30 | Wayne | New York | 36117 | 8506 | 87 |
1831574 | 1831574 | 2021-10-19 | McDowell | North Carolina | 37111 | 8506 | 122 |
1759678 | 1759678 | 2021-09-27 | Joplin | Missouri | 8506 | 147 | |
1496477 | 1496477 | 2021-07-08 | Jones | Mississippi | 28067 | 8506 | 169 |
1217992 | 1217992 | 2021-04-13 | Wayne | Ohio | 39169 | 8506 | 209 |
1160573 | 1160573 | 2021-03-26 | Manitowoc | Wisconsin | 55071 | 8506 | 85 |
1147255 | 1147255 | 2021-03-22 | Walker | Texas | 48471 | 8506 | 122 |
1022570 | 1022570 | 2021-02-12 | Cole | Missouri | 29051 | 8506 | 111 |
992051 | 992051 | 2021-02-03 | Napa | California | 6055 | 8506 | 57 |
881362 | 881362 | 2020-12-30 | Kanawha | West Virginia | 54039 | 8506 | 202 |
854870 | 854870 | 2020-12-22 | Maury | Tennessee | 47119 | 8506 | 97 |
698799 | 698799 | 2020-11-04 | Chester | Pennsylvania | 42029 | 8506 | 381 |
422391 | 422391 | 2020-08-11 | Jefferson | Kentucky | 21111 | 8506 | 256 |
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);