ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where cases = 16692 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Tennessee 7
- Georgia 2
- California 1
- Florida 1
- Maryland 1
- Minnesota 1
- New Mexico 1
- North Carolina 1
- Ohio 1
- Pennsylvania 1
- South Carolina 1
- Texas 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469593 | 2469593 | 2022-05-03 | McMinn | Tennessee | 47107 | 16692 | 260 |
2466337 | 2466337 | 2022-05-02 | McMinn | Tennessee | 47107 | 16692 | 260 |
2463082 | 2463082 | 2022-05-01 | McMinn | Tennessee | 47107 | 16692 | 260 |
2459826 | 2459826 | 2022-04-30 | McMinn | Tennessee | 47107 | 16692 | 260 |
2456570 | 2456570 | 2022-04-29 | McMinn | Tennessee | 47107 | 16692 | 260 |
2453314 | 2453314 | 2022-04-28 | McMinn | Tennessee | 47107 | 16692 | 260 |
2450058 | 2450058 | 2022-04-27 | McMinn | Tennessee | 47107 | 16692 | 260 |
2198788 | 2198788 | 2022-02-09 | Eddy | New Mexico | 35015 | 16692 | 245 |
1966515 | 1966515 | 2021-11-30 | Carroll | Georgia | 13045 | 16692 | 351 |
1686865 | 1686865 | 2021-09-05 | Marin | California | 6041 | 16692 | 242 |
1471161 | 1471161 | 2021-06-30 | Licking | Ohio | 39089 | 16692 | 225 |
1276718 | 1276718 | 2021-05-01 | Beaufort | South Carolina | 45013 | 16692 | 204 |
1269197 | 1269197 | 2021-04-29 | Scott | Minnesota | 27139 | 16692 | 122 |
1261734 | 1261734 | 2021-04-27 | Columbia | Georgia | 13073 | 16692 | 201 |
1264339 | 1264339 | 2021-04-27 | Richmond city | Virginia | 51760 | 16692 | 257 |
1224639 | 1224639 | 2021-04-15 | Lackawanna | Pennsylvania | 42069 | 16692 | 445 |
997000 | 997000 | 2021-02-04 | Cabarrus | North Carolina | 37025 | 16692 | 206 |
725330 | 725330 | 2020-11-12 | Webb | Texas | 48479 | 16692 | 371 |
476579 | 476579 | 2020-08-28 | Polk | Florida | 12105 | 16692 | 429 |
361447 | 361447 | 2020-07-23 | Montgomery | Maryland | 24031 | 16692 | 781 |
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);