ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Hot Spring" and state = "Arkansas" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9542 | 9542 | 2020-03-24 | Hot Spring | Arkansas | 5059 | 1 | 0 |
10913 | 10913 | 2020-03-25 | Hot Spring | Arkansas | 5059 | 1 | 0 |
12455 | 12455 | 2020-03-26 | Hot Spring | Arkansas | 5059 | 1 | 0 |
14119 | 14119 | 2020-03-27 | Hot Spring | Arkansas | 5059 | 2 | 0 |
15899 | 15899 | 2020-03-28 | Hot Spring | Arkansas | 5059 | 1 | 0 |
17786 | 17786 | 2020-03-29 | Hot Spring | Arkansas | 5059 | 3 | 0 |
19760 | 19760 | 2020-03-30 | Hot Spring | Arkansas | 5059 | 4 | 0 |
21832 | 21832 | 2020-03-31 | Hot Spring | Arkansas | 5059 | 4 | 0 |
23989 | 23989 | 2020-04-01 | Hot Spring | Arkansas | 5059 | 4 | 0 |
26213 | 26213 | 2020-04-02 | Hot Spring | Arkansas | 5059 | 5 | 0 |
28510 | 28510 | 2020-04-03 | Hot Spring | Arkansas | 5059 | 5 | 0 |
30868 | 30868 | 2020-04-04 | Hot Spring | Arkansas | 5059 | 5 | 0 |
33272 | 33272 | 2020-04-05 | Hot Spring | Arkansas | 5059 | 7 | 0 |
35714 | 35714 | 2020-04-06 | Hot Spring | Arkansas | 5059 | 7 | 0 |
38203 | 38203 | 2020-04-07 | Hot Spring | Arkansas | 5059 | 7 | 0 |
40746 | 40746 | 2020-04-08 | Hot Spring | Arkansas | 5059 | 7 | 0 |
43318 | 43318 | 2020-04-09 | Hot Spring | Arkansas | 5059 | 8 | 0 |
45917 | 45917 | 2020-04-10 | Hot Spring | Arkansas | 5059 | 8 | 0 |
48547 | 48547 | 2020-04-11 | Hot Spring | Arkansas | 5059 | 8 | 0 |
51209 | 51209 | 2020-04-12 | Hot Spring | Arkansas | 5059 | 8 | 0 |
53887 | 53887 | 2020-04-13 | Hot Spring | Arkansas | 5059 | 8 | 0 |
56579 | 56579 | 2020-04-14 | Hot Spring | Arkansas | 5059 | 8 | 0 |
59287 | 59287 | 2020-04-15 | Hot Spring | Arkansas | 5059 | 8 | 0 |
62006 | 62006 | 2020-04-16 | Hot Spring | Arkansas | 5059 | 8 | 0 |
64739 | 64739 | 2020-04-17 | Hot Spring | Arkansas | 5059 | 8 | 0 |
67487 | 67487 | 2020-04-18 | Hot Spring | Arkansas | 5059 | 8 | 0 |
70249 | 70249 | 2020-04-19 | Hot Spring | Arkansas | 5059 | 8 | 0 |
73018 | 73018 | 2020-04-20 | Hot Spring | Arkansas | 5059 | 8 | 0 |
75794 | 75794 | 2020-04-21 | Hot Spring | Arkansas | 5059 | 8 | 0 |
78578 | 78578 | 2020-04-22 | Hot Spring | Arkansas | 5059 | 8 | 0 |
81372 | 81372 | 2020-04-23 | Hot Spring | Arkansas | 5059 | 9 | 0 |
84172 | 84172 | 2020-04-24 | Hot Spring | Arkansas | 5059 | 9 | 0 |
86980 | 86980 | 2020-04-25 | Hot Spring | Arkansas | 5059 | 9 | 0 |
89797 | 89797 | 2020-04-26 | Hot Spring | Arkansas | 5059 | 10 | 0 |
92615 | 92615 | 2020-04-27 | Hot Spring | Arkansas | 5059 | 10 | 0 |
95445 | 95445 | 2020-04-28 | Hot Spring | Arkansas | 5059 | 15 | 0 |
98290 | 98290 | 2020-04-29 | Hot Spring | Arkansas | 5059 | 17 | 0 |
101140 | 101140 | 2020-04-30 | Hot Spring | Arkansas | 5059 | 19 | 0 |
103995 | 103995 | 2020-05-01 | Hot Spring | Arkansas | 5059 | 19 | 0 |
106860 | 106860 | 2020-05-02 | Hot Spring | Arkansas | 5059 | 19 | 0 |
109729 | 109729 | 2020-05-03 | Hot Spring | Arkansas | 5059 | 20 | 0 |
112604 | 112604 | 2020-05-04 | Hot Spring | Arkansas | 5059 | 20 | 0 |
115487 | 115487 | 2020-05-05 | Hot Spring | Arkansas | 5059 | 20 | 0 |
118446 | 118446 | 2020-05-06 | Hot Spring | Arkansas | 5059 | 22 | 0 |
121413 | 121413 | 2020-05-07 | Hot Spring | Arkansas | 5059 | 22 | 0 |
124393 | 124393 | 2020-05-08 | Hot Spring | Arkansas | 5059 | 22 | 0 |
127378 | 127378 | 2020-05-09 | Hot Spring | Arkansas | 5059 | 22 | 0 |
130368 | 130368 | 2020-05-10 | Hot Spring | Arkansas | 5059 | 26 | 0 |
133358 | 133358 | 2020-05-11 | Hot Spring | Arkansas | 5059 | 26 | 0 |
136348 | 136348 | 2020-05-12 | Hot Spring | Arkansas | 5059 | 27 | 0 |
139339 | 139339 | 2020-05-13 | Hot Spring | Arkansas | 5059 | 28 | 0 |
142335 | 142335 | 2020-05-14 | Hot Spring | Arkansas | 5059 | 29 | 0 |
145334 | 145334 | 2020-05-15 | Hot Spring | Arkansas | 5059 | 29 | 0 |
148337 | 148337 | 2020-05-16 | Hot Spring | Arkansas | 5059 | 29 | 0 |
151346 | 151346 | 2020-05-17 | Hot Spring | Arkansas | 5059 | 29 | 0 |
154358 | 154358 | 2020-05-18 | Hot Spring | Arkansas | 5059 | 29 | 0 |
157374 | 157374 | 2020-05-19 | Hot Spring | Arkansas | 5059 | 29 | 0 |
160400 | 160400 | 2020-05-20 | Hot Spring | Arkansas | 5059 | 29 | 0 |
163428 | 163428 | 2020-05-21 | Hot Spring | Arkansas | 5059 | 29 | 0 |
166460 | 166460 | 2020-05-22 | Hot Spring | Arkansas | 5059 | 29 | 0 |
169496 | 169496 | 2020-05-23 | Hot Spring | Arkansas | 5059 | 29 | 0 |
172537 | 172537 | 2020-05-24 | Hot Spring | Arkansas | 5059 | 30 | 0 |
175581 | 175581 | 2020-05-25 | Hot Spring | Arkansas | 5059 | 30 | 0 |
178625 | 178625 | 2020-05-26 | Hot Spring | Arkansas | 5059 | 30 | 0 |
181669 | 181669 | 2020-05-27 | Hot Spring | Arkansas | 5059 | 30 | 0 |
184723 | 184723 | 2020-05-28 | Hot Spring | Arkansas | 5059 | 31 | 0 |
187779 | 187779 | 2020-05-29 | Hot Spring | Arkansas | 5059 | 32 | 0 |
190844 | 190844 | 2020-05-30 | Hot Spring | Arkansas | 5059 | 32 | 0 |
193911 | 193911 | 2020-05-31 | Hot Spring | Arkansas | 5059 | 32 | 0 |
196981 | 196981 | 2020-06-01 | Hot Spring | Arkansas | 5059 | 32 | 0 |
200054 | 200054 | 2020-06-02 | Hot Spring | Arkansas | 5059 | 32 | 0 |
203130 | 203130 | 2020-06-03 | Hot Spring | Arkansas | 5059 | 33 | 0 |
206210 | 206210 | 2020-06-04 | Hot Spring | Arkansas | 5059 | 34 | 0 |
209291 | 209291 | 2020-06-05 | Hot Spring | Arkansas | 5059 | 34 | 0 |
212376 | 212376 | 2020-06-06 | Hot Spring | Arkansas | 5059 | 34 | 0 |
215463 | 215463 | 2020-06-07 | Hot Spring | Arkansas | 5059 | 34 | 0 |
218554 | 218554 | 2020-06-08 | Hot Spring | Arkansas | 5059 | 34 | 0 |
221649 | 221649 | 2020-06-09 | Hot Spring | Arkansas | 5059 | 34 | 0 |
224744 | 224744 | 2020-06-10 | Hot Spring | Arkansas | 5059 | 34 | 0 |
227846 | 227846 | 2020-06-11 | Hot Spring | Arkansas | 5059 | 37 | 0 |
230949 | 230949 | 2020-06-12 | Hot Spring | Arkansas | 5059 | 37 | 0 |
234055 | 234055 | 2020-06-13 | Hot Spring | Arkansas | 5059 | 38 | 0 |
237162 | 237162 | 2020-06-14 | Hot Spring | Arkansas | 5059 | 42 | 0 |
240270 | 240270 | 2020-06-15 | Hot Spring | Arkansas | 5059 | 42 | 0 |
243381 | 243381 | 2020-06-16 | Hot Spring | Arkansas | 5059 | 43 | 0 |
246494 | 246494 | 2020-06-17 | Hot Spring | Arkansas | 5059 | 44 | 0 |
249606 | 249606 | 2020-06-18 | Hot Spring | Arkansas | 5059 | 46 | 0 |
252721 | 252721 | 2020-06-19 | Hot Spring | Arkansas | 5059 | 46 | 0 |
255840 | 255840 | 2020-06-20 | Hot Spring | Arkansas | 5059 | 53 | 0 |
258967 | 258967 | 2020-06-21 | Hot Spring | Arkansas | 5059 | 53 | 0 |
262094 | 262094 | 2020-06-22 | Hot Spring | Arkansas | 5059 | 138 | 0 |
265222 | 265222 | 2020-06-23 | Hot Spring | Arkansas | 5059 | 226 | 0 |
268352 | 268352 | 2020-06-24 | Hot Spring | Arkansas | 5059 | 396 | 0 |
271487 | 271487 | 2020-06-25 | Hot Spring | Arkansas | 5059 | 396 | 0 |
274627 | 274627 | 2020-06-26 | Hot Spring | Arkansas | 5059 | 415 | 0 |
277775 | 277775 | 2020-06-27 | Hot Spring | Arkansas | 5059 | 420 | 0 |
280922 | 280922 | 2020-06-28 | Hot Spring | Arkansas | 5059 | 423 | 0 |
284068 | 284068 | 2020-06-29 | Hot Spring | Arkansas | 5059 | 428 | 0 |
287214 | 287214 | 2020-06-30 | Hot Spring | Arkansas | 5059 | 426 | 0 |
290365 | 290365 | 2020-07-01 | Hot Spring | Arkansas | 5059 | 429 | 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);