ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8 rows where cases = 688 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 8
- Boone 1
- Carroll 1
- Cleveland 1
- Little River 1
- Monroe 1
- Montgomery 1
- Polk 1
- Woodruff 1
state 1
- Arkansas · 8 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1563402 | 1563402 | 2021-07-29 | Woodruff | Arkansas | 5147 | 688 | 14 |
1004980 | 1004980 | 2021-02-07 | Montgomery | Arkansas | 5097 | 688 | 27 |
969274 | 969274 | 2021-01-27 | Monroe | Arkansas | 5095 | 688 | 14 |
940031 | 940031 | 2021-01-18 | Cleveland | Arkansas | 5025 | 688 | 23 |
813488 | 813488 | 2020-12-10 | Little River | Arkansas | 5081 | 688 | 37 |
751846 | 751846 | 2020-11-21 | Polk | Arkansas | 5113 | 688 | 7 |
579885 | 579885 | 2020-09-29 | Carroll | Arkansas | 5015 | 688 | 10 |
563674 | 563674 | 2020-09-24 | Boone | Arkansas | 5009 | 688 | 10 |
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);