ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where county = "Randolph", deaths = 48 and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1595875 | 1595875 | 2021-08-08 | Randolph | Arkansas | 5121 | 2391 | 48 |
1592626 | 1592626 | 2021-08-07 | Randolph | Arkansas | 5121 | 2389 | 48 |
1589377 | 1589377 | 2021-08-06 | Randolph | Arkansas | 5121 | 2383 | 48 |
1586128 | 1586128 | 2021-08-05 | Randolph | Arkansas | 5121 | 2374 | 48 |
1582878 | 1582878 | 2021-08-04 | Randolph | Arkansas | 5121 | 2372 | 48 |
1579628 | 1579628 | 2021-08-03 | Randolph | Arkansas | 5121 | 2361 | 48 |
1576380 | 1576380 | 2021-08-02 | Randolph | Arkansas | 5121 | 2349 | 48 |
1573132 | 1573132 | 2021-08-01 | Randolph | Arkansas | 5121 | 2346 | 48 |
1569884 | 1569884 | 2021-07-31 | Randolph | Arkansas | 5121 | 2343 | 48 |
1566636 | 1566636 | 2021-07-30 | Randolph | Arkansas | 5121 | 2335 | 48 |
1563388 | 1563388 | 2021-07-29 | Randolph | Arkansas | 5121 | 2326 | 48 |
1560140 | 1560140 | 2021-07-28 | Randolph | Arkansas | 5121 | 2316 | 48 |
1556893 | 1556893 | 2021-07-27 | Randolph | Arkansas | 5121 | 2311 | 48 |
1553646 | 1553646 | 2021-07-26 | Randolph | Arkansas | 5121 | 2303 | 48 |
1550399 | 1550399 | 2021-07-25 | Randolph | Arkansas | 5121 | 2302 | 48 |
1547152 | 1547152 | 2021-07-24 | Randolph | Arkansas | 5121 | 2300 | 48 |
1543905 | 1543905 | 2021-07-23 | Randolph | Arkansas | 5121 | 2294 | 48 |
1540657 | 1540657 | 2021-07-22 | Randolph | Arkansas | 5121 | 2291 | 48 |
1537410 | 1537410 | 2021-07-21 | Randolph | Arkansas | 5121 | 2285 | 48 |
1534162 | 1534162 | 2021-07-20 | Randolph | Arkansas | 5121 | 2277 | 48 |
1530915 | 1530915 | 2021-07-19 | Randolph | Arkansas | 5121 | 2271 | 48 |
1527668 | 1527668 | 2021-07-18 | Randolph | Arkansas | 5121 | 2266 | 48 |
1524421 | 1524421 | 2021-07-17 | Randolph | Arkansas | 5121 | 2266 | 48 |
1521173 | 1521173 | 2021-07-16 | Randolph | Arkansas | 5121 | 2266 | 48 |
1517925 | 1517925 | 2021-07-15 | Randolph | Arkansas | 5121 | 2262 | 48 |
1514678 | 1514678 | 2021-07-14 | Randolph | Arkansas | 5121 | 2259 | 48 |
1511432 | 1511432 | 2021-07-13 | Randolph | Arkansas | 5121 | 2253 | 48 |
1508185 | 1508185 | 2021-07-12 | Randolph | Arkansas | 5121 | 2249 | 48 |
1504939 | 1504939 | 2021-07-11 | Randolph | Arkansas | 5121 | 2242 | 48 |
1501693 | 1501693 | 2021-07-10 | Randolph | Arkansas | 5121 | 2242 | 48 |
1498447 | 1498447 | 2021-07-09 | Randolph | Arkansas | 5121 | 2242 | 48 |
1495200 | 1495200 | 2021-07-08 | Randolph | Arkansas | 5121 | 2237 | 48 |
1491953 | 1491953 | 2021-07-07 | Randolph | Arkansas | 5121 | 2223 | 48 |
1488706 | 1488706 | 2021-07-06 | Randolph | Arkansas | 5121 | 2222 | 48 |
1485459 | 1485459 | 2021-07-05 | Randolph | Arkansas | 5121 | 2220 | 48 |
1482213 | 1482213 | 2021-07-04 | Randolph | Arkansas | 5121 | 2218 | 48 |
1478966 | 1478966 | 2021-07-03 | Randolph | Arkansas | 5121 | 2218 | 48 |
1475720 | 1475720 | 2021-07-02 | Randolph | Arkansas | 5121 | 2218 | 48 |
1472474 | 1472474 | 2021-07-01 | Randolph | Arkansas | 5121 | 2218 | 48 |
1469229 | 1469229 | 2021-06-30 | Randolph | Arkansas | 5121 | 2213 | 48 |
1465984 | 1465984 | 2021-06-29 | Randolph | Arkansas | 5121 | 2212 | 48 |
1462739 | 1462739 | 2021-06-28 | Randolph | Arkansas | 5121 | 2211 | 48 |
1459494 | 1459494 | 2021-06-27 | Randolph | Arkansas | 5121 | 2209 | 48 |
1456249 | 1456249 | 2021-06-26 | Randolph | Arkansas | 5121 | 2209 | 48 |
1453004 | 1453004 | 2021-06-25 | Randolph | Arkansas | 5121 | 2209 | 48 |
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);