ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Union" and fips = 5139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
78616 | 78616 | 2020-04-22 | Union | Arkansas | 5139 | 28 | 0 |
75832 | 75832 | 2020-04-21 | Union | Arkansas | 5139 | 26 | 0 |
73056 | 73056 | 2020-04-20 | Union | Arkansas | 5139 | 26 | 0 |
70287 | 70287 | 2020-04-19 | Union | Arkansas | 5139 | 24 | 0 |
67525 | 67525 | 2020-04-18 | Union | Arkansas | 5139 | 24 | 0 |
64777 | 64777 | 2020-04-17 | Union | Arkansas | 5139 | 20 | 0 |
62044 | 62044 | 2020-04-16 | Union | Arkansas | 5139 | 19 | 0 |
59325 | 59325 | 2020-04-15 | Union | Arkansas | 5139 | 18 | 0 |
56617 | 56617 | 2020-04-14 | Union | Arkansas | 5139 | 17 | 0 |
53925 | 53925 | 2020-04-13 | Union | Arkansas | 5139 | 17 | 0 |
51246 | 51246 | 2020-04-12 | Union | Arkansas | 5139 | 18 | 0 |
48584 | 48584 | 2020-04-11 | Union | Arkansas | 5139 | 18 | 0 |
45954 | 45954 | 2020-04-10 | Union | Arkansas | 5139 | 17 | 0 |
43354 | 43354 | 2020-04-09 | Union | Arkansas | 5139 | 16 | 0 |
40782 | 40782 | 2020-04-08 | Union | Arkansas | 5139 | 15 | 0 |
38238 | 38238 | 2020-04-07 | Union | Arkansas | 5139 | 13 | 0 |
35749 | 35749 | 2020-04-06 | Union | Arkansas | 5139 | 13 | 0 |
33305 | 33305 | 2020-04-05 | Union | Arkansas | 5139 | 12 | 0 |
30900 | 30900 | 2020-04-04 | Union | Arkansas | 5139 | 10 | 0 |
28542 | 28542 | 2020-04-03 | Union | Arkansas | 5139 | 10 | 0 |
26243 | 26243 | 2020-04-02 | Union | Arkansas | 5139 | 10 | 0 |
24015 | 24015 | 2020-04-01 | Union | Arkansas | 5139 | 9 | 0 |
21857 | 21857 | 2020-03-31 | Union | Arkansas | 5139 | 8 | 0 |
19783 | 19783 | 2020-03-30 | Union | Arkansas | 5139 | 8 | 0 |
17807 | 17807 | 2020-03-29 | Union | Arkansas | 5139 | 6 | 0 |
15918 | 15918 | 2020-03-28 | Union | Arkansas | 5139 | 5 | 0 |
14137 | 14137 | 2020-03-27 | Union | Arkansas | 5139 | 2 | 0 |
12473 | 12473 | 2020-03-26 | Union | Arkansas | 5139 | 2 | 0 |
10928 | 10928 | 2020-03-25 | Union | Arkansas | 5139 | 2 | 0 |
9557 | 9557 | 2020-03-24 | Union | Arkansas | 5139 | 1 | 0 |
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);