ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 7520 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Virginia 5
- Georgia 4
- Illinois 4
- Texas 3
- Arizona 2
- New York 2
- Oklahoma 2
- Tennessee 2
- Alabama 1
- Colorado 1
- Florida 1
- Indiana 1
- Iowa 1
- North Carolina 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
- South Dakota 1
- Vermont 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2252308 | 2252308 | 2022-02-26 | Winston | Alabama | 1133 | 7520 | 120 |
2241097 | 2241097 | 2022-02-22 | Delaware | New York | 36025 | 7520 | 68 |
2232341 | 2232341 | 2022-02-19 | Upshur | Texas | 48459 | 7520 | 173 |
2187740 | 2187740 | 2022-02-06 | Upson | Georgia | 13293 | 7520 | 209 |
2184487 | 2184487 | 2022-02-05 | Upson | Georgia | 13293 | 7520 | 209 |
2181235 | 2181235 | 2022-02-04 | Upson | Georgia | 13293 | 7520 | 209 |
2117931 | 2117931 | 2022-01-15 | Jefferson | Pennsylvania | 42065 | 7520 | 195 |
2080170 | 2080170 | 2022-01-04 | Summit | Colorado | 8117 | 7520 | 12 |
2053599 | 2053599 | 2021-12-26 | Henry | Virginia | 51089 | 7520 | 199 |
2050349 | 2050349 | 2021-12-25 | Henry | Virginia | 51089 | 7520 | 199 |
2047099 | 2047099 | 2021-12-24 | Henry | Virginia | 51089 | 7520 | 199 |
2033582 | 2033582 | 2021-12-20 | Brown | South Dakota | 46013 | 7520 | 107 |
1988155 | 1988155 | 2021-12-06 | Fayette | Tennessee | 47047 | 7520 | 112 |
1740901 | 1740901 | 2021-09-21 | Yamhill | Oregon | 41071 | 7520 | 99 |
1723029 | 1723029 | 2021-09-16 | Jackson | Illinois | 17077 | 7520 | 90 |
1678803 | 1678803 | 2021-09-02 | Steuben | New York | 36101 | 7520 | 148 |
1641882 | 1641882 | 2021-08-22 | Whiteside | Illinois | 17195 | 7520 | 216 |
1638632 | 1638632 | 2021-08-21 | Whiteside | Illinois | 17195 | 7520 | 216 |
1635382 | 1635382 | 2021-08-20 | Whiteside | Illinois | 17195 | 7520 | 216 |
1602300 | 1602300 | 2021-08-10 | Gila | Arizona | 4007 | 7520 | 239 |
1520754 | 1520754 | 2021-07-15 | Lynchburg city | Virginia | 51680 | 7520 | 147 |
1429776 | 1429776 | 2021-06-17 | Chittenden | Vermont | 50007 | 7520 | 104 |
1403345 | 1403345 | 2021-06-09 | Laurens | South Carolina | 45059 | 7520 | 171 |
1261060 | 1261060 | 2021-04-26 | Lynchburg city | Virginia | 51680 | 7520 | 146 |
1218615 | 1218615 | 2021-04-13 | Liberty | Texas | 48291 | 7520 | 174 |
1060450 | 1060450 | 2021-02-24 | Glynn | Georgia | 13127 | 7520 | 159 |
1052431 | 1052431 | 2021-02-21 | Garfield | Oklahoma | 40047 | 7520 | 71 |
961589 | 961589 | 2021-01-24 | Payne | Oklahoma | 40119 | 7520 | 39 |
917143 | 917143 | 2021-01-10 | Ozaukee | Wisconsin | 55089 | 7520 | 62 |
841220 | 841220 | 2020-12-18 | Buncombe | North Carolina | 37021 | 7520 | 149 |
838592 | 838592 | 2020-12-17 | Bradley | Tennessee | 47011 | 7520 | 56 |
833694 | 833694 | 2020-12-16 | Story | Iowa | 19169 | 7520 | 23 |
780987 | 780987 | 2020-11-30 | Coconino | Arizona | 4005 | 7520 | 171 |
609716 | 609716 | 2020-10-08 | St. Joseph | Indiana | 18141 | 7520 | 140 |
553382 | 553382 | 2020-09-20 | McLennan | Texas | 48309 | 7520 | 97 |
363804 | 363804 | 2020-07-24 | Manatee | Florida | 12081 | 7520 | 153 |
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);