ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 10387 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Georgia 5
- Illinois 5
- South Carolina 5
- Kansas 3
- California 2
- Montana 2
- New York 2
- Texas 2
- North Carolina 1
- North Dakota 1
- Ohio 1
- Pennsylvania 1
- Puerto Rico 1
- Tennessee 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2482893 | 2482893 | 2022-05-07 | Van Zandt | Texas | 48467 | 10387 | 280 |
2257552 | 2257552 | 2022-02-27 | Williams | North Dakota | 38105 | 10387 | 68 |
2197389 | 2197389 | 2022-02-09 | Coffee | Georgia | 13069 | 10387 | 250 |
2179382 | 2179382 | 2022-02-03 | Davie | North Carolina | 37059 | 10387 | 82 |
2142582 | 2142582 | 2022-01-23 | Finney | Kansas | 20055 | 10387 | 105 |
2139327 | 2139327 | 2022-01-22 | Finney | Kansas | 20055 | 10387 | 105 |
2136071 | 2136071 | 2022-01-21 | Finney | Kansas | 20055 | 10387 | 105 |
2133769 | 2133769 | 2022-01-20 | Montgomery | New York | 36057 | 10387 | 182 |
2122793 | 2122793 | 2022-01-17 | Macoupin | Illinois | 17117 | 10387 | 154 |
2119325 | 2119325 | 2022-01-16 | Effingham | Georgia | 13103 | 10387 | 177 |
2119541 | 2119541 | 2022-01-16 | Macoupin | Illinois | 17117 | 10387 | 154 |
2116073 | 2116073 | 2022-01-15 | Effingham | Georgia | 13103 | 10387 | 177 |
2116289 | 2116289 | 2022-01-15 | Macoupin | Illinois | 17117 | 10387 | 154 |
2112822 | 2112822 | 2022-01-14 | Effingham | Georgia | 13103 | 10387 | 177 |
2113038 | 2113038 | 2022-01-14 | Macoupin | Illinois | 17117 | 10387 | 154 |
2020211 | 2020211 | 2021-12-16 | Huron | Ohio | 39077 | 10387 | 166 |
2011846 | 2011846 | 2021-12-14 | Tehama | California | 6103 | 10387 | 134 |
1922463 | 1922463 | 2021-11-16 | Jefferson | New York | 36045 | 10387 | 99 |
1828948 | 1828948 | 2021-10-18 | McMinn | Tennessee | 47107 | 10387 | 127 |
1792902 | 1792902 | 2021-10-07 | Clearfield | Pennsylvania | 42033 | 10387 | 181 |
1784014 | 1784014 | 2021-10-04 | Raleigh | West Virginia | 54081 | 10387 | 142 |
1711842 | 1711842 | 2021-09-12 | Kershaw | South Carolina | 45055 | 10387 | 166 |
1708595 | 1708595 | 2021-09-11 | Kershaw | South Carolina | 45055 | 10387 | 166 |
1705348 | 1705348 | 2021-09-10 | Kershaw | South Carolina | 45055 | 10387 | 166 |
1646076 | 1646076 | 2021-08-23 | Missoula | Montana | 30063 | 10387 | 105 |
1629805 | 1629805 | 2021-08-18 | Cascade | Montana | 30013 | 10387 | 194 |
1466433 | 1466433 | 2021-06-29 | DeKalb | Illinois | 17037 | 10387 | 126 |
1218628 | 1218628 | 2021-04-13 | Maverick | Texas | 48323 | 10387 | 346 |
1153231 | 1153231 | 2021-03-24 | Bayamon | Puerto Rico | 72021 | 10387 | |
878473 | 878473 | 2020-12-30 | San Luis Obispo | California | 6079 | 10387 | 82 |
796326 | 796326 | 2020-12-04 | York | South Carolina | 45091 | 10387 | 140 |
781400 | 781400 | 2020-11-30 | Richmond | Georgia | 13245 | 10387 | 220 |
767708 | 767708 | 2020-11-25 | Virginia Beach city | Virginia | 51810 | 10387 | 113 |
582202 | 582202 | 2020-09-29 | Horry | South Carolina | 45051 | 10387 | 197 |
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);