ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 9983 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Alabama 9
- Georgia 4
- Maine 2
- New York 2
- Pennsylvania 2
- Virginia 2
- Arizona 1
- Arkansas 1
- Iowa 1
- Michigan 1
- Minnesota 1
- Nebraska 1
- New Jersey 1
- North Carolina 1
- Ohio 1
- South Carolina 1
- Tennessee 1
- Texas 1
- Utah 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2464945 | 2464945 | 2022-05-02 | Somerset | Maine | 23025 | 9983 | 104 |
2353094 | 2353094 | 2022-03-29 | Escambia | Alabama | 1053 | 9983 | 169 |
2349842 | 2349842 | 2022-03-28 | Escambia | Alabama | 1053 | 9983 | 169 |
2346589 | 2346589 | 2022-03-27 | Escambia | Alabama | 1053 | 9983 | 168 |
2343336 | 2343336 | 2022-03-26 | Escambia | Alabama | 1053 | 9983 | 168 |
2340083 | 2340083 | 2022-03-25 | Escambia | Alabama | 1053 | 9983 | 168 |
2336830 | 2336830 | 2022-03-24 | Escambia | Alabama | 1053 | 9983 | 167 |
2332046 | 2332046 | 2022-03-22 | Scotts Bluff | Nebraska | 31157 | 9983 | 102 |
2313097 | 2313097 | 2022-03-16 | Pike | Pennsylvania | 42103 | 9983 | 93 |
2164040 | 2164040 | 2022-01-29 | Uvalde | Texas | 48463 | 9983 | 121 |
2151073 | 2151073 | 2022-01-25 | Wasatch | Utah | 49051 | 9983 | 33 |
2117701 | 2117701 | 2022-01-15 | Auglaize | Ohio | 39011 | 9983 | 141 |
2040192 | 2040192 | 2021-12-22 | Lawrence | Tennessee | 47099 | 9983 | 135 |
2034336 | 2034336 | 2021-12-20 | Waupaca | Wisconsin | 55135 | 9983 | 209 |
1967954 | 1967954 | 2021-11-30 | Cattaraugus | New York | 36009 | 9983 | 157 |
1878036 | 1878036 | 2021-11-02 | Bedford | Virginia | 51019 | 9983 | 153 |
1858685 | 1858685 | 2021-10-27 | Lewis | Washington | 53041 | 9983 | 152 |
1760012 | 1760012 | 2021-09-27 | Oswego | New York | 36075 | 9983 | 103 |
1725765 | 1725765 | 2021-09-17 | Crawford | Arkansas | 5033 | 9983 | 157 |
1602648 | 1602648 | 2021-08-10 | Fayette | Georgia | 13113 | 9983 | 179 |
1392976 | 1392976 | 2021-06-06 | Warren | New Jersey | 34041 | 9983 | 237 |
1345782 | 1345782 | 2021-05-23 | St. Clair | Alabama | 1115 | 9983 | 246 |
1330751 | 1330751 | 2021-05-18 | Eaton | Michigan | 26045 | 9983 | 203 |
1315169 | 1315169 | 2021-05-13 | Burke | North Carolina | 37023 | 9983 | 153 |
1251593 | 1251593 | 2021-04-24 | Elmore | Alabama | 1051 | 9983 | 204 |
1153334 | 1153334 | 2021-03-24 | Lancaster | South Carolina | 45057 | 9983 | 156 |
1122872 | 1122872 | 2021-03-15 | York | Maine | 23031 | 9983 | 125 |
1116049 | 1116049 | 2021-03-13 | Pottawattamie | Iowa | 19155 | 9983 | 149 |
998092 | 998092 | 2021-02-04 | Newport News city | Virginia | 51700 | 9983 | 101 |
985791 | 985791 | 2021-02-01 | Floyd | Georgia | 13115 | 9983 | 163 |
911202 | 911202 | 2021-01-09 | Paulding | Georgia | 13223 | 9983 | 120 |
798510 | 798510 | 2020-12-05 | St. Louis | Minnesota | 27137 | 9983 | 131 |
716401 | 716401 | 2020-11-10 | Chatham | Georgia | 13051 | 9983 | 196 |
644687 | 644687 | 2020-10-19 | Tuscaloosa | Alabama | 1125 | 9983 | 132 |
511880 | 511880 | 2020-09-08 | Pinal | Arizona | 4021 | 9983 | 190 |
407524 | 407524 | 2020-08-06 | Montgomery | Pennsylvania | 42091 | 9983 | 855 |
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);