ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 5085 and state = "Arkansas" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12461 | 12461 | 2020-03-26 | Lonoke | Arkansas | 5085 | 4 | 0 |
14125 | 14125 | 2020-03-27 | Lonoke | Arkansas | 5085 | 4 | 0 |
15906 | 15906 | 2020-03-28 | Lonoke | Arkansas | 5085 | 4 | 0 |
17793 | 17793 | 2020-03-29 | Lonoke | Arkansas | 5085 | 4 | 0 |
19767 | 19767 | 2020-03-30 | Lonoke | Arkansas | 5085 | 4 | 0 |
21839 | 21839 | 2020-03-31 | Lonoke | Arkansas | 5085 | 6 | 0 |
23997 | 23997 | 2020-04-01 | Lonoke | Arkansas | 5085 | 6 | 0 |
26221 | 26221 | 2020-04-02 | Lonoke | Arkansas | 5085 | 13 | 0 |
28519 | 28519 | 2020-04-03 | Lonoke | Arkansas | 5085 | 16 | 0 |
30877 | 30877 | 2020-04-04 | Lonoke | Arkansas | 5085 | 15 | 0 |
33281 | 33281 | 2020-04-05 | Lonoke | Arkansas | 5085 | 17 | 0 |
35725 | 35725 | 2020-04-06 | Lonoke | Arkansas | 5085 | 23 | 0 |
38214 | 38214 | 2020-04-07 | Lonoke | Arkansas | 5085 | 23 | 0 |
40757 | 40757 | 2020-04-08 | Lonoke | Arkansas | 5085 | 24 | 0 |
43329 | 43329 | 2020-04-09 | Lonoke | Arkansas | 5085 | 26 | 0 |
45928 | 45928 | 2020-04-10 | Lonoke | Arkansas | 5085 | 27 | 0 |
48558 | 48558 | 2020-04-11 | Lonoke | Arkansas | 5085 | 27 | 0 |
51220 | 51220 | 2020-04-12 | Lonoke | Arkansas | 5085 | 30 | 0 |
53899 | 53899 | 2020-04-13 | Lonoke | Arkansas | 5085 | 29 | 0 |
56591 | 56591 | 2020-04-14 | Lonoke | Arkansas | 5085 | 29 | 0 |
59299 | 59299 | 2020-04-15 | Lonoke | Arkansas | 5085 | 30 | 0 |
62018 | 62018 | 2020-04-16 | Lonoke | Arkansas | 5085 | 30 | 0 |
64751 | 64751 | 2020-04-17 | Lonoke | Arkansas | 5085 | 30 | 0 |
67499 | 67499 | 2020-04-18 | Lonoke | Arkansas | 5085 | 26 | 0 |
70261 | 70261 | 2020-04-19 | Lonoke | Arkansas | 5085 | 26 | 0 |
73030 | 73030 | 2020-04-20 | Lonoke | Arkansas | 5085 | 26 | 0 |
75806 | 75806 | 2020-04-21 | Lonoke | Arkansas | 5085 | 27 | 0 |
78590 | 78590 | 2020-04-22 | Lonoke | Arkansas | 5085 | 28 | 0 |
81384 | 81384 | 2020-04-23 | Lonoke | Arkansas | 5085 | 30 | 0 |
84184 | 84184 | 2020-04-24 | Lonoke | Arkansas | 5085 | 31 | 0 |
86992 | 86992 | 2020-04-25 | Lonoke | Arkansas | 5085 | 33 | 0 |
89809 | 89809 | 2020-04-26 | Lonoke | Arkansas | 5085 | 38 | 0 |
92627 | 92627 | 2020-04-27 | Lonoke | Arkansas | 5085 | 39 | 0 |
95457 | 95457 | 2020-04-28 | Lonoke | Arkansas | 5085 | 40 | 0 |
98302 | 98302 | 2020-04-29 | Lonoke | Arkansas | 5085 | 41 | 0 |
101152 | 101152 | 2020-04-30 | Lonoke | Arkansas | 5085 | 41 | 0 |
104007 | 104007 | 2020-05-01 | Lonoke | Arkansas | 5085 | 41 | 0 |
106872 | 106872 | 2020-05-02 | Lonoke | Arkansas | 5085 | 41 | 0 |
109741 | 109741 | 2020-05-03 | Lonoke | Arkansas | 5085 | 43 | 0 |
112616 | 112616 | 2020-05-04 | Lonoke | Arkansas | 5085 | 44 | 0 |
115499 | 115499 | 2020-05-05 | Lonoke | Arkansas | 5085 | 44 | 0 |
118458 | 118458 | 2020-05-06 | Lonoke | Arkansas | 5085 | 44 | 0 |
121425 | 121425 | 2020-05-07 | Lonoke | Arkansas | 5085 | 44 | 0 |
124405 | 124405 | 2020-05-08 | Lonoke | Arkansas | 5085 | 44 | 0 |
127390 | 127390 | 2020-05-09 | Lonoke | Arkansas | 5085 | 44 | 0 |
130380 | 130380 | 2020-05-10 | Lonoke | Arkansas | 5085 | 45 | 0 |
133370 | 133370 | 2020-05-11 | Lonoke | Arkansas | 5085 | 45 | 0 |
136360 | 136360 | 2020-05-12 | Lonoke | Arkansas | 5085 | 44 | 0 |
139351 | 139351 | 2020-05-13 | Lonoke | Arkansas | 5085 | 43 | 0 |
142347 | 142347 | 2020-05-14 | Lonoke | Arkansas | 5085 | 44 | 0 |
145346 | 145346 | 2020-05-15 | Lonoke | Arkansas | 5085 | 45 | 0 |
148350 | 148350 | 2020-05-16 | Lonoke | Arkansas | 5085 | 45 | 0 |
151359 | 151359 | 2020-05-17 | Lonoke | Arkansas | 5085 | 45 | 0 |
154371 | 154371 | 2020-05-18 | Lonoke | Arkansas | 5085 | 45 | 0 |
157387 | 157387 | 2020-05-19 | Lonoke | Arkansas | 5085 | 46 | 0 |
160413 | 160413 | 2020-05-20 | Lonoke | Arkansas | 5085 | 46 | 0 |
163441 | 163441 | 2020-05-21 | Lonoke | Arkansas | 5085 | 46 | 0 |
166473 | 166473 | 2020-05-22 | Lonoke | Arkansas | 5085 | 46 | 0 |
169509 | 169509 | 2020-05-23 | Lonoke | Arkansas | 5085 | 46 | 0 |
172550 | 172550 | 2020-05-24 | Lonoke | Arkansas | 5085 | 46 | 0 |
175594 | 175594 | 2020-05-25 | Lonoke | Arkansas | 5085 | 46 | 0 |
178638 | 178638 | 2020-05-26 | Lonoke | Arkansas | 5085 | 46 | 0 |
181682 | 181682 | 2020-05-27 | Lonoke | Arkansas | 5085 | 45 | 0 |
184736 | 184736 | 2020-05-28 | Lonoke | Arkansas | 5085 | 46 | 0 |
187792 | 187792 | 2020-05-29 | Lonoke | Arkansas | 5085 | 47 | 0 |
190857 | 190857 | 2020-05-30 | Lonoke | Arkansas | 5085 | 47 | 0 |
193924 | 193924 | 2020-05-31 | Lonoke | Arkansas | 5085 | 48 | 0 |
196994 | 196994 | 2020-06-01 | Lonoke | Arkansas | 5085 | 49 | 0 |
200067 | 200067 | 2020-06-02 | Lonoke | Arkansas | 5085 | 54 | 0 |
203143 | 203143 | 2020-06-03 | Lonoke | Arkansas | 5085 | 55 | 0 |
206223 | 206223 | 2020-06-04 | Lonoke | Arkansas | 5085 | 56 | 0 |
209304 | 209304 | 2020-06-05 | Lonoke | Arkansas | 5085 | 57 | 0 |
212389 | 212389 | 2020-06-06 | Lonoke | Arkansas | 5085 | 57 | 0 |
215476 | 215476 | 2020-06-07 | Lonoke | Arkansas | 5085 | 59 | 0 |
218567 | 218567 | 2020-06-08 | Lonoke | Arkansas | 5085 | 60 | 0 |
221662 | 221662 | 2020-06-09 | Lonoke | Arkansas | 5085 | 63 | 0 |
224757 | 224757 | 2020-06-10 | Lonoke | Arkansas | 5085 | 64 | 0 |
227859 | 227859 | 2020-06-11 | Lonoke | Arkansas | 5085 | 67 | 0 |
230962 | 230962 | 2020-06-12 | Lonoke | Arkansas | 5085 | 69 | 0 |
234068 | 234068 | 2020-06-13 | Lonoke | Arkansas | 5085 | 70 | 0 |
237175 | 237175 | 2020-06-14 | Lonoke | Arkansas | 5085 | 71 | 0 |
240283 | 240283 | 2020-06-15 | Lonoke | Arkansas | 5085 | 73 | 0 |
243394 | 243394 | 2020-06-16 | Lonoke | Arkansas | 5085 | 75 | 0 |
246507 | 246507 | 2020-06-17 | Lonoke | Arkansas | 5085 | 78 | 0 |
249619 | 249619 | 2020-06-18 | Lonoke | Arkansas | 5085 | 80 | 0 |
252734 | 252734 | 2020-06-19 | Lonoke | Arkansas | 5085 | 84 | 0 |
255853 | 255853 | 2020-06-20 | Lonoke | Arkansas | 5085 | 86 | 0 |
258980 | 258980 | 2020-06-21 | Lonoke | Arkansas | 5085 | 88 | 0 |
262107 | 262107 | 2020-06-22 | Lonoke | Arkansas | 5085 | 89 | 0 |
265235 | 265235 | 2020-06-23 | Lonoke | Arkansas | 5085 | 91 | 0 |
268365 | 268365 | 2020-06-24 | Lonoke | Arkansas | 5085 | 96 | 0 |
271500 | 271500 | 2020-06-25 | Lonoke | Arkansas | 5085 | 123 | 0 |
274640 | 274640 | 2020-06-26 | Lonoke | Arkansas | 5085 | 119 | 1 |
277788 | 277788 | 2020-06-27 | Lonoke | Arkansas | 5085 | 127 | 1 |
280935 | 280935 | 2020-06-28 | Lonoke | Arkansas | 5085 | 132 | 1 |
284081 | 284081 | 2020-06-29 | Lonoke | Arkansas | 5085 | 134 | 1 |
287227 | 287227 | 2020-06-30 | Lonoke | Arkansas | 5085 | 138 | 1 |
290378 | 290378 | 2020-07-01 | Lonoke | Arkansas | 5085 | 144 | 1 |
293532 | 293532 | 2020-07-02 | Lonoke | Arkansas | 5085 | 158 | 1 |
296688 | 296688 | 2020-07-03 | Lonoke | Arkansas | 5085 | 162 | 1 |
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);