ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Lincoln" and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386088 | 386088 | 2020-07-31 | Lincoln | Arkansas | 5079 | 1165 | 11 |
382870 | 382870 | 2020-07-30 | Lincoln | Arkansas | 5079 | 1161 | 11 |
379653 | 379653 | 2020-07-29 | Lincoln | Arkansas | 5079 | 1155 | 11 |
376437 | 376437 | 2020-07-28 | Lincoln | Arkansas | 5079 | 1155 | 11 |
373223 | 373223 | 2020-07-27 | Lincoln | Arkansas | 5079 | 1152 | 11 |
370011 | 370011 | 2020-07-26 | Lincoln | Arkansas | 5079 | 1148 | 11 |
366801 | 366801 | 2020-07-25 | Lincoln | Arkansas | 5079 | 1143 | 11 |
363594 | 363594 | 2020-07-24 | Lincoln | Arkansas | 5079 | 1141 | 11 |
360387 | 360387 | 2020-07-23 | Lincoln | Arkansas | 5079 | 1138 | 11 |
357182 | 357182 | 2020-07-22 | Lincoln | Arkansas | 5079 | 1132 | 11 |
353979 | 353979 | 2020-07-21 | Lincoln | Arkansas | 5079 | 1132 | 11 |
350777 | 350777 | 2020-07-20 | Lincoln | Arkansas | 5079 | 1121 | 11 |
347576 | 347576 | 2020-07-19 | Lincoln | Arkansas | 5079 | 1119 | 11 |
344376 | 344376 | 2020-07-18 | Lincoln | Arkansas | 5079 | 1118 | 11 |
341177 | 341177 | 2020-07-17 | Lincoln | Arkansas | 5079 | 1115 | 11 |
337981 | 337981 | 2020-07-16 | Lincoln | Arkansas | 5079 | 1105 | 11 |
334786 | 334786 | 2020-07-15 | Lincoln | Arkansas | 5079 | 1052 | 11 |
331593 | 331593 | 2020-07-14 | Lincoln | Arkansas | 5079 | 1052 | 11 |
328407 | 328407 | 2020-07-13 | Lincoln | Arkansas | 5079 | 1048 | 11 |
325221 | 325221 | 2020-07-12 | Lincoln | Arkansas | 5079 | 1048 | 11 |
322040 | 322040 | 2020-07-11 | Lincoln | Arkansas | 5079 | 1048 | 11 |
318861 | 318861 | 2020-07-10 | Lincoln | Arkansas | 5079 | 1048 | 11 |
315688 | 315688 | 2020-07-09 | Lincoln | Arkansas | 5079 | 1046 | 11 |
312513 | 312513 | 2020-07-08 | Lincoln | Arkansas | 5079 | 1044 | 11 |
309343 | 309343 | 2020-07-07 | Lincoln | Arkansas | 5079 | 1044 | 11 |
306175 | 306175 | 2020-07-06 | Lincoln | Arkansas | 5079 | 1043 | 11 |
303011 | 303011 | 2020-07-05 | Lincoln | Arkansas | 5079 | 1043 | 11 |
299847 | 299847 | 2020-07-04 | Lincoln | Arkansas | 5079 | 1041 | 11 |
296685 | 296685 | 2020-07-03 | Lincoln | Arkansas | 5079 | 1041 | 11 |
293529 | 293529 | 2020-07-02 | Lincoln | Arkansas | 5079 | 1041 | 11 |
290375 | 290375 | 2020-07-01 | Lincoln | Arkansas | 5079 | 1040 | 11 |
287224 | 287224 | 2020-06-30 | Lincoln | Arkansas | 5079 | 1038 | 11 |
284078 | 284078 | 2020-06-29 | Lincoln | Arkansas | 5079 | 1038 | 11 |
280932 | 280932 | 2020-06-28 | Lincoln | Arkansas | 5079 | 1037 | 11 |
277785 | 277785 | 2020-06-27 | Lincoln | Arkansas | 5079 | 1036 | 11 |
274637 | 274637 | 2020-06-26 | Lincoln | Arkansas | 5079 | 1036 | 11 |
271497 | 271497 | 2020-06-25 | Lincoln | Arkansas | 5079 | 1036 | 11 |
268362 | 268362 | 2020-06-24 | Lincoln | Arkansas | 5079 | 1036 | 11 |
265232 | 265232 | 2020-06-23 | Lincoln | Arkansas | 5079 | 1036 | 11 |
262104 | 262104 | 2020-06-22 | Lincoln | Arkansas | 5079 | 1036 | 11 |
258977 | 258977 | 2020-06-21 | Lincoln | Arkansas | 5079 | 1036 | 11 |
255850 | 255850 | 2020-06-20 | Lincoln | Arkansas | 5079 | 1036 | 11 |
252731 | 252731 | 2020-06-19 | Lincoln | Arkansas | 5079 | 1023 | 11 |
249616 | 249616 | 2020-06-18 | Lincoln | Arkansas | 5079 | 995 | 11 |
246504 | 246504 | 2020-06-17 | Lincoln | Arkansas | 5079 | 995 | 11 |
243391 | 243391 | 2020-06-16 | Lincoln | Arkansas | 5079 | 995 | 11 |
240280 | 240280 | 2020-06-15 | Lincoln | Arkansas | 5079 | 995 | 11 |
237172 | 237172 | 2020-06-14 | Lincoln | Arkansas | 5079 | 995 | 11 |
234065 | 234065 | 2020-06-13 | Lincoln | Arkansas | 5079 | 987 | 11 |
230959 | 230959 | 2020-06-12 | Lincoln | Arkansas | 5079 | 986 | 11 |
227856 | 227856 | 2020-06-11 | Lincoln | Arkansas | 5079 | 986 | 11 |
224754 | 224754 | 2020-06-10 | Lincoln | Arkansas | 5079 | 985 | 11 |
221659 | 221659 | 2020-06-09 | Lincoln | Arkansas | 5079 | 985 | 11 |
218564 | 218564 | 2020-06-08 | Lincoln | Arkansas | 5079 | 985 | 11 |
215473 | 215473 | 2020-06-07 | Lincoln | Arkansas | 5079 | 985 | 11 |
212386 | 212386 | 2020-06-06 | Lincoln | Arkansas | 5079 | 985 | 11 |
209301 | 209301 | 2020-06-05 | Lincoln | Arkansas | 5079 | 985 | 11 |
206220 | 206220 | 2020-06-04 | Lincoln | Arkansas | 5079 | 985 | 10 |
203140 | 203140 | 2020-06-03 | Lincoln | Arkansas | 5079 | 984 | 10 |
200064 | 200064 | 2020-06-02 | Lincoln | Arkansas | 5079 | 983 | 9 |
196991 | 196991 | 2020-06-01 | Lincoln | Arkansas | 5079 | 983 | 9 |
193921 | 193921 | 2020-05-31 | Lincoln | Arkansas | 5079 | 982 | 9 |
190854 | 190854 | 2020-05-30 | Lincoln | Arkansas | 5079 | 978 | 9 |
187789 | 187789 | 2020-05-29 | Lincoln | Arkansas | 5079 | 975 | 9 |
184733 | 184733 | 2020-05-28 | Lincoln | Arkansas | 5079 | 975 | 9 |
181679 | 181679 | 2020-05-27 | Lincoln | Arkansas | 5079 | 975 | 8 |
178635 | 178635 | 2020-05-26 | Lincoln | Arkansas | 5079 | 975 | 8 |
175591 | 175591 | 2020-05-25 | Lincoln | Arkansas | 5079 | 975 | 8 |
172547 | 172547 | 2020-05-24 | Lincoln | Arkansas | 5079 | 974 | 8 |
169506 | 169506 | 2020-05-23 | Lincoln | Arkansas | 5079 | 970 | 8 |
166470 | 166470 | 2020-05-22 | Lincoln | Arkansas | 5079 | 966 | 8 |
163438 | 163438 | 2020-05-21 | Lincoln | Arkansas | 5079 | 966 | 8 |
160410 | 160410 | 2020-05-20 | Lincoln | Arkansas | 5079 | 966 | 8 |
157384 | 157384 | 2020-05-19 | Lincoln | Arkansas | 5079 | 965 | 8 |
154368 | 154368 | 2020-05-18 | Lincoln | Arkansas | 5079 | 965 | 8 |
151356 | 151356 | 2020-05-17 | Lincoln | Arkansas | 5079 | 955 | 8 |
148347 | 148347 | 2020-05-16 | Lincoln | Arkansas | 5079 | 955 | 8 |
145344 | 145344 | 2020-05-15 | Lincoln | Arkansas | 5079 | 952 | 8 |
142345 | 142345 | 2020-05-14 | Lincoln | Arkansas | 5079 | 949 | 8 |
139349 | 139349 | 2020-05-13 | Lincoln | Arkansas | 5079 | 942 | 7 |
136358 | 136358 | 2020-05-12 | Lincoln | Arkansas | 5079 | 942 | 7 |
133368 | 133368 | 2020-05-11 | Lincoln | Arkansas | 5079 | 941 | 7 |
130378 | 130378 | 2020-05-10 | Lincoln | Arkansas | 5079 | 937 | 7 |
127388 | 127388 | 2020-05-09 | Lincoln | Arkansas | 5079 | 907 | 6 |
124403 | 124403 | 2020-05-08 | Lincoln | Arkansas | 5079 | 907 | 6 |
121423 | 121423 | 2020-05-07 | Lincoln | Arkansas | 5079 | 899 | 6 |
118456 | 118456 | 2020-05-06 | Lincoln | Arkansas | 5079 | 883 | 6 |
115497 | 115497 | 2020-05-05 | Lincoln | Arkansas | 5079 | 853 | 5 |
112614 | 112614 | 2020-05-04 | Lincoln | Arkansas | 5079 | 842 | 4 |
109739 | 109739 | 2020-05-03 | Lincoln | Arkansas | 5079 | 822 | 4 |
106870 | 106870 | 2020-05-02 | Lincoln | Arkansas | 5079 | 817 | 2 |
104005 | 104005 | 2020-05-01 | Lincoln | Arkansas | 5079 | 815 | 0 |
101150 | 101150 | 2020-04-30 | Lincoln | Arkansas | 5079 | 814 | 0 |
98300 | 98300 | 2020-04-29 | Lincoln | Arkansas | 5079 | 814 | 0 |
95455 | 95455 | 2020-04-28 | Lincoln | Arkansas | 5079 | 755 | 0 |
92625 | 92625 | 2020-04-27 | Lincoln | Arkansas | 5079 | 754 | 0 |
89807 | 89807 | 2020-04-26 | Lincoln | Arkansas | 5079 | 727 | 0 |
86990 | 86990 | 2020-04-25 | Lincoln | Arkansas | 5079 | 721 | 0 |
84182 | 84182 | 2020-04-24 | Lincoln | Arkansas | 5079 | 707 | 0 |
81382 | 81382 | 2020-04-23 | Lincoln | Arkansas | 5079 | 630 | 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);