ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 16153 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Kentucky 7
- Colorado 3
- Pennsylvania 3
- Alabama 2
- Georgia 2
- Arizona 1
- Arkansas 1
- Connecticut 1
- Florida 1
- Louisiana 1
- North Carolina 1
- Puerto Rico 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2460752 | 2460752 | 2022-05-01 | Eagle | Colorado | 8037 | 16153 | 35 |
2457496 | 2457496 | 2022-04-30 | Eagle | Colorado | 8037 | 16153 | 35 |
2454240 | 2454240 | 2022-04-29 | Eagle | Colorado | 8037 | 16153 | 35 |
2324802 | 2324802 | 2022-03-20 | Boyd | Kentucky | 21019 | 16153 | 167 |
2321548 | 2321548 | 2022-03-19 | Boyd | Kentucky | 21019 | 16153 | 167 |
2318294 | 2318294 | 2022-03-18 | Boyd | Kentucky | 21019 | 16153 | 167 |
2315041 | 2315041 | 2022-03-17 | Boyd | Kentucky | 21019 | 16153 | 167 |
2311788 | 2311788 | 2022-03-16 | Boyd | Kentucky | 21019 | 16153 | 167 |
2308535 | 2308535 | 2022-03-15 | Boyd | Kentucky | 21019 | 16153 | 167 |
2305284 | 2305284 | 2022-03-14 | Boyd | Kentucky | 21019 | 16153 | 167 |
2223520 | 2223520 | 2022-02-17 | Walker | Georgia | 13295 | 16153 | 215 |
2166841 | 2166841 | 2022-01-30 | Unknown | Puerto Rico | 16153 | 3854 | |
1966144 | 1966144 | 2021-11-30 | Limestone | Alabama | 1083 | 16153 | 219 |
1943481 | 1943481 | 2021-11-23 | Garland | Arkansas | 5051 | 16153 | 399 |
1851412 | 1851412 | 2021-10-25 | Lycoming | Pennsylvania | 42081 | 16153 | 352 |
1722700 | 1722700 | 2021-09-16 | Litchfield | Connecticut | 9005 | 16153 | 302 |
1587086 | 1587086 | 2021-08-05 | Bossier | Louisiana | 22015 | 16153 | 317 |
1420775 | 1420775 | 2021-06-15 | Bibb | Georgia | 13021 | 16153 | 460 |
1403201 | 1403201 | 2021-06-09 | Lebanon | Pennsylvania | 42075 | 16153 | 292 |
1378225 | 1378225 | 2021-06-02 | Lee | Alabama | 1081 | 16153 | 173 |
1261413 | 1261413 | 2021-04-27 | Navajo | Arizona | 4017 | 16153 | 527 |
1263290 | 1263290 | 2021-04-27 | Robeson | North Carolina | 37155 | 16153 | 228 |
1227862 | 1227862 | 2021-04-16 | Butler | Pennsylvania | 42019 | 16153 | 398 |
1134616 | 1134616 | 2021-03-18 | Rock | Wisconsin | 55105 | 16153 | 176 |
800731 | 800731 | 2020-12-06 | Pasco | Florida | 12101 | 16153 | 301 |
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);