ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 5123 and state = "Arkansas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19781 | 19781 | 2020-03-30 | St. Francis | Arkansas | 5123 | 1 | 0 |
21855 | 21855 | 2020-03-31 | St. Francis | Arkansas | 5123 | 2 | 0 |
24013 | 24013 | 2020-04-01 | St. Francis | Arkansas | 5123 | 2 | 0 |
26241 | 26241 | 2020-04-02 | St. Francis | Arkansas | 5123 | 2 | 0 |
28540 | 28540 | 2020-04-03 | St. Francis | Arkansas | 5123 | 2 | 0 |
30898 | 30898 | 2020-04-04 | St. Francis | Arkansas | 5123 | 3 | 0 |
33303 | 33303 | 2020-04-05 | St. Francis | Arkansas | 5123 | 11 | 0 |
35747 | 35747 | 2020-04-06 | St. Francis | Arkansas | 5123 | 17 | 0 |
38236 | 38236 | 2020-04-07 | St. Francis | Arkansas | 5123 | 28 | 0 |
40780 | 40780 | 2020-04-08 | St. Francis | Arkansas | 5123 | 31 | 0 |
43352 | 43352 | 2020-04-09 | St. Francis | Arkansas | 5123 | 31 | 0 |
45952 | 45952 | 2020-04-10 | St. Francis | Arkansas | 5123 | 31 | 0 |
48582 | 48582 | 2020-04-11 | St. Francis | Arkansas | 5123 | 31 | 0 |
51244 | 51244 | 2020-04-12 | St. Francis | Arkansas | 5123 | 32 | 0 |
53923 | 53923 | 2020-04-13 | St. Francis | Arkansas | 5123 | 45 | 0 |
56615 | 56615 | 2020-04-14 | St. Francis | Arkansas | 5123 | 45 | 0 |
59323 | 59323 | 2020-04-15 | St. Francis | Arkansas | 5123 | 45 | 0 |
62042 | 62042 | 2020-04-16 | St. Francis | Arkansas | 5123 | 63 | 0 |
64775 | 64775 | 2020-04-17 | St. Francis | Arkansas | 5123 | 63 | 0 |
67523 | 67523 | 2020-04-18 | St. Francis | Arkansas | 5123 | 64 | 0 |
70285 | 70285 | 2020-04-19 | St. Francis | Arkansas | 5123 | 64 | 0 |
73054 | 73054 | 2020-04-20 | St. Francis | Arkansas | 5123 | 65 | 0 |
75830 | 75830 | 2020-04-21 | St. Francis | Arkansas | 5123 | 66 | 0 |
78614 | 78614 | 2020-04-22 | St. Francis | Arkansas | 5123 | 66 | 0 |
81408 | 81408 | 2020-04-23 | St. Francis | Arkansas | 5123 | 69 | 0 |
84208 | 84208 | 2020-04-24 | St. Francis | Arkansas | 5123 | 74 | 0 |
87016 | 87016 | 2020-04-25 | St. Francis | Arkansas | 5123 | 75 | 0 |
89833 | 89833 | 2020-04-26 | St. Francis | Arkansas | 5123 | 80 | 0 |
92651 | 92651 | 2020-04-27 | St. Francis | Arkansas | 5123 | 81 | 0 |
95482 | 95482 | 2020-04-28 | St. Francis | Arkansas | 5123 | 82 | 0 |
98327 | 98327 | 2020-04-29 | St. Francis | Arkansas | 5123 | 83 | 0 |
101177 | 101177 | 2020-04-30 | St. Francis | Arkansas | 5123 | 83 | 0 |
104032 | 104032 | 2020-05-01 | St. Francis | Arkansas | 5123 | 84 | 0 |
106897 | 106897 | 2020-05-02 | St. Francis | Arkansas | 5123 | 87 | 0 |
109766 | 109766 | 2020-05-03 | St. Francis | Arkansas | 5123 | 93 | 0 |
112641 | 112641 | 2020-05-04 | St. Francis | Arkansas | 5123 | 95 | 0 |
115524 | 115524 | 2020-05-05 | St. Francis | Arkansas | 5123 | 95 | 0 |
118483 | 118483 | 2020-05-06 | St. Francis | Arkansas | 5123 | 98 | 0 |
121450 | 121450 | 2020-05-07 | St. Francis | Arkansas | 5123 | 104 | 0 |
124430 | 124430 | 2020-05-08 | St. Francis | Arkansas | 5123 | 108 | 0 |
127415 | 127415 | 2020-05-09 | St. Francis | Arkansas | 5123 | 108 | 0 |
130405 | 130405 | 2020-05-10 | St. Francis | Arkansas | 5123 | 278 | 0 |
133395 | 133395 | 2020-05-11 | St. Francis | Arkansas | 5123 | 279 | 0 |
136385 | 136385 | 2020-05-12 | St. Francis | Arkansas | 5123 | 305 | 0 |
139376 | 139376 | 2020-05-13 | St. Francis | Arkansas | 5123 | 310 | 0 |
142372 | 142372 | 2020-05-14 | St. Francis | Arkansas | 5123 | 316 | 0 |
145371 | 145371 | 2020-05-15 | St. Francis | Arkansas | 5123 | 333 | 0 |
148375 | 148375 | 2020-05-16 | St. Francis | Arkansas | 5123 | 335 | 0 |
151384 | 151384 | 2020-05-17 | St. Francis | Arkansas | 5123 | 341 | 0 |
154396 | 154396 | 2020-05-18 | St. Francis | Arkansas | 5123 | 349 | 0 |
157412 | 157412 | 2020-05-19 | St. Francis | Arkansas | 5123 | 362 | 0 |
160438 | 160438 | 2020-05-20 | St. Francis | Arkansas | 5123 | 365 | 0 |
163466 | 163466 | 2020-05-21 | St. Francis | Arkansas | 5123 | 600 | 0 |
166498 | 166498 | 2020-05-22 | St. Francis | Arkansas | 5123 | 621 | 1 |
169534 | 169534 | 2020-05-23 | St. Francis | Arkansas | 5123 | 628 | 1 |
172575 | 172575 | 2020-05-24 | St. Francis | Arkansas | 5123 | 634 | 1 |
175619 | 175619 | 2020-05-25 | St. Francis | Arkansas | 5123 | 639 | 1 |
178663 | 178663 | 2020-05-26 | St. Francis | Arkansas | 5123 | 651 | 1 |
181707 | 181707 | 2020-05-27 | St. Francis | Arkansas | 5123 | 655 | 1 |
184761 | 184761 | 2020-05-28 | St. Francis | Arkansas | 5123 | 660 | 1 |
187817 | 187817 | 2020-05-29 | St. Francis | Arkansas | 5123 | 664 | 1 |
190882 | 190882 | 2020-05-30 | St. Francis | Arkansas | 5123 | 672 | 1 |
193949 | 193949 | 2020-05-31 | St. Francis | Arkansas | 5123 | 672 | 1 |
197019 | 197019 | 2020-06-01 | St. Francis | Arkansas | 5123 | 676 | 1 |
200092 | 200092 | 2020-06-02 | St. Francis | Arkansas | 5123 | 682 | 1 |
203168 | 203168 | 2020-06-03 | St. Francis | Arkansas | 5123 | 687 | 1 |
206248 | 206248 | 2020-06-04 | St. Francis | Arkansas | 5123 | 691 | 1 |
209329 | 209329 | 2020-06-05 | St. Francis | Arkansas | 5123 | 694 | 1 |
212414 | 212414 | 2020-06-06 | St. Francis | Arkansas | 5123 | 744 | 1 |
215501 | 215501 | 2020-06-07 | St. Francis | Arkansas | 5123 | 753 | 1 |
218592 | 218592 | 2020-06-08 | St. Francis | Arkansas | 5123 | 755 | 1 |
221687 | 221687 | 2020-06-09 | St. Francis | Arkansas | 5123 | 761 | 1 |
224782 | 224782 | 2020-06-10 | St. Francis | Arkansas | 5123 | 764 | 1 |
227884 | 227884 | 2020-06-11 | St. Francis | Arkansas | 5123 | 768 | 1 |
230987 | 230987 | 2020-06-12 | St. Francis | Arkansas | 5123 | 767 | 2 |
234093 | 234093 | 2020-06-13 | St. Francis | Arkansas | 5123 | 771 | 2 |
237200 | 237200 | 2020-06-14 | St. Francis | Arkansas | 5123 | 775 | 2 |
240308 | 240308 | 2020-06-15 | St. Francis | Arkansas | 5123 | 778 | 2 |
243419 | 243419 | 2020-06-16 | St. Francis | Arkansas | 5123 | 779 | 3 |
246532 | 246532 | 2020-06-17 | St. Francis | Arkansas | 5123 | 779 | 3 |
249644 | 249644 | 2020-06-18 | St. Francis | Arkansas | 5123 | 781 | 3 |
252759 | 252759 | 2020-06-19 | St. Francis | Arkansas | 5123 | 783 | 3 |
255878 | 255878 | 2020-06-20 | St. Francis | Arkansas | 5123 | 791 | 3 |
259005 | 259005 | 2020-06-21 | St. Francis | Arkansas | 5123 | 791 | 3 |
262132 | 262132 | 2020-06-22 | St. Francis | Arkansas | 5123 | 792 | 3 |
265260 | 265260 | 2020-06-23 | St. Francis | Arkansas | 5123 | 793 | 3 |
268390 | 268390 | 2020-06-24 | St. Francis | Arkansas | 5123 | 795 | 3 |
271525 | 271525 | 2020-06-25 | St. Francis | Arkansas | 5123 | 801 | 3 |
274665 | 274665 | 2020-06-26 | St. Francis | Arkansas | 5123 | 804 | 3 |
277813 | 277813 | 2020-06-27 | St. Francis | Arkansas | 5123 | 809 | 3 |
280960 | 280960 | 2020-06-28 | St. Francis | Arkansas | 5123 | 810 | 3 |
284106 | 284106 | 2020-06-29 | St. Francis | Arkansas | 5123 | 811 | 3 |
287252 | 287252 | 2020-06-30 | St. Francis | Arkansas | 5123 | 812 | 3 |
290403 | 290403 | 2020-07-01 | St. Francis | Arkansas | 5123 | 814 | 3 |
293557 | 293557 | 2020-07-02 | St. Francis | Arkansas | 5123 | 818 | 3 |
296713 | 296713 | 2020-07-03 | St. Francis | Arkansas | 5123 | 863 | 3 |
299875 | 299875 | 2020-07-04 | St. Francis | Arkansas | 5123 | 881 | 3 |
303039 | 303039 | 2020-07-05 | St. Francis | Arkansas | 5123 | 883 | 3 |
306203 | 306203 | 2020-07-06 | St. Francis | Arkansas | 5123 | 892 | 3 |
309371 | 309371 | 2020-07-07 | St. Francis | Arkansas | 5123 | 893 | 3 |
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);