ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 14129 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Rhode Island 7
- Tennessee 3
- Alabama 2
- Ohio 2
- Texas 2
- Arizona 1
- Delaware 1
- Indiana 1
- Mississippi 1
- New Mexico 1
- New York 1
- North Carolina 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2323194 | 2323194 | 2022-03-19 | Caldwell | Texas | 48055 | 14129 | 175 |
2225051 | 2225051 | 2022-02-17 | Athens | Ohio | 39009 | 14129 | 116 |
2151105 | 2151105 | 2022-01-25 | Bedford | Virginia | 51019 | 14129 | 181 |
1967552 | 1967552 | 2021-11-30 | Jones | Mississippi | 28067 | 14129 | 247 |
1927153 | 1927153 | 2021-11-18 | Talladega | Alabama | 1121 | 14129 | 299 |
1877246 | 1877246 | 2021-11-02 | Wayne | Ohio | 39169 | 14129 | 282 |
1831540 | 1831540 | 2021-10-19 | Craven | North Carolina | 37049 | 14129 | 153 |
1815193 | 1815193 | 2021-10-14 | Lea | New Mexico | 35025 | 14129 | 263 |
1754979 | 1754979 | 2021-09-26 | Cochise | Arizona | 4003 | 14129 | 324 |
1728929 | 1728929 | 2021-09-18 | Limestone | Alabama | 1083 | 14129 | 180 |
1606202 | 1606202 | 2021-08-11 | Madison | Indiana | 18095 | 14129 | 371 |
1234703 | 1234703 | 2021-04-18 | Washington | Tennessee | 47179 | 14129 | 242 |
1231455 | 1231455 | 2021-04-17 | Washington | Tennessee | 47179 | 14129 | 242 |
1228207 | 1228207 | 2021-04-16 | Washington | Tennessee | 47179 | 14129 | 242 |
1023798 | 1023798 | 2021-02-12 | Kaufman | Texas | 48257 | 14129 | 202 |
1013722 | 1013722 | 2021-02-09 | Kent | Rhode Island | 44003 | 14129 | 256 |
1010477 | 1010477 | 2021-02-08 | Kent | Rhode Island | 44003 | 14129 | 256 |
1007231 | 1007231 | 2021-02-07 | Kent | Rhode Island | 44003 | 14129 | 256 |
1003985 | 1003985 | 2021-02-06 | Kent | Rhode Island | 44003 | 14129 | 256 |
1000739 | 1000739 | 2021-02-05 | Kent | Rhode Island | 44003 | 14129 | 256 |
997493 | 997493 | 2021-02-04 | Kent | Rhode Island | 44003 | 14129 | 256 |
994247 | 994247 | 2021-02-03 | Kent | Rhode Island | 44003 | 14129 | 256 |
943095 | 943095 | 2021-01-18 | Marathon | Wisconsin | 55073 | 14129 | 194 |
862342 | 862342 | 2020-12-25 | Sussex | Delaware | 10005 | 14129 | 289 |
461926 | 461926 | 2020-08-23 | Rockland | New York | 36087 | 14129 | 508 |
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);