ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lancaster" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387645 | 387645 | 2020-07-31 | Lancaster | Nebraska | 31109 | 3028 | 15 |
384427 | 384427 | 2020-07-30 | Lancaster | Nebraska | 31109 | 2992 | 15 |
381211 | 381211 | 2020-07-29 | Lancaster | Nebraska | 31109 | 2945 | 15 |
377993 | 377993 | 2020-07-28 | Lancaster | Nebraska | 31109 | 2895 | 14 |
374777 | 374777 | 2020-07-27 | Lancaster | Nebraska | 31109 | 2837 | 14 |
371565 | 371565 | 2020-07-26 | Lancaster | Nebraska | 31109 | 2802 | 14 |
368354 | 368354 | 2020-07-25 | Lancaster | Nebraska | 31109 | 2758 | 14 |
365145 | 365145 | 2020-07-24 | Lancaster | Nebraska | 31109 | 2718 | 14 |
361939 | 361939 | 2020-07-23 | Lancaster | Nebraska | 31109 | 2669 | 14 |
358733 | 358733 | 2020-07-22 | Lancaster | Nebraska | 31109 | 2605 | 14 |
355529 | 355529 | 2020-07-21 | Lancaster | Nebraska | 31109 | 2541 | 14 |
352326 | 352326 | 2020-07-20 | Lancaster | Nebraska | 31109 | 2482 | 14 |
349125 | 349125 | 2020-07-19 | Lancaster | Nebraska | 31109 | 2430 | 14 |
345924 | 345924 | 2020-07-18 | Lancaster | Nebraska | 31109 | 2401 | 14 |
342724 | 342724 | 2020-07-17 | Lancaster | Nebraska | 31109 | 2363 | 14 |
339527 | 339527 | 2020-07-16 | Lancaster | Nebraska | 31109 | 2316 | 13 |
336330 | 336330 | 2020-07-15 | Lancaster | Nebraska | 31109 | 2266 | 13 |
333136 | 333136 | 2020-07-14 | Lancaster | Nebraska | 31109 | 2226 | 13 |
329946 | 329946 | 2020-07-13 | Lancaster | Nebraska | 31109 | 2182 | 13 |
326759 | 326759 | 2020-07-12 | Lancaster | Nebraska | 31109 | 2129 | 13 |
323575 | 323575 | 2020-07-11 | Lancaster | Nebraska | 31109 | 2076 | 13 |
320396 | 320396 | 2020-07-10 | Lancaster | Nebraska | 31109 | 2028 | 13 |
317221 | 317221 | 2020-07-09 | Lancaster | Nebraska | 31109 | 1998 | 13 |
314047 | 314047 | 2020-07-08 | Lancaster | Nebraska | 31109 | 1963 | 13 |
310876 | 310876 | 2020-07-07 | Lancaster | Nebraska | 31109 | 1909 | 13 |
307708 | 307708 | 2020-07-06 | Lancaster | Nebraska | 31109 | 1882 | 13 |
304541 | 304541 | 2020-07-05 | Lancaster | Nebraska | 31109 | 1866 | 13 |
301377 | 301377 | 2020-07-04 | Lancaster | Nebraska | 31109 | 1838 | 13 |
298214 | 298214 | 2020-07-03 | Lancaster | Nebraska | 31109 | 1791 | 13 |
295055 | 295055 | 2020-07-02 | Lancaster | Nebraska | 31109 | 1766 | 13 |
291900 | 291900 | 2020-07-01 | Lancaster | Nebraska | 31109 | 1751 | 13 |
288748 | 288748 | 2020-06-30 | Lancaster | Nebraska | 31109 | 1728 | 12 |
285598 | 285598 | 2020-06-29 | Lancaster | Nebraska | 31109 | 1718 | 12 |
282453 | 282453 | 2020-06-28 | Lancaster | Nebraska | 31109 | 1697 | 12 |
279305 | 279305 | 2020-06-27 | Lancaster | Nebraska | 31109 | 1688 | 12 |
276157 | 276157 | 2020-06-26 | Lancaster | Nebraska | 31109 | 1670 | 12 |
273014 | 273014 | 2020-06-25 | Lancaster | Nebraska | 31109 | 1660 | 12 |
269875 | 269875 | 2020-06-24 | Lancaster | Nebraska | 31109 | 1649 | 11 |
266741 | 266741 | 2020-06-23 | Lancaster | Nebraska | 31109 | 1634 | 11 |
263614 | 263614 | 2020-06-22 | Lancaster | Nebraska | 31109 | 1623 | 10 |
260485 | 260485 | 2020-06-21 | Lancaster | Nebraska | 31109 | 1611 | 10 |
257359 | 257359 | 2020-06-20 | Lancaster | Nebraska | 31109 | 1603 | 10 |
254236 | 254236 | 2020-06-19 | Lancaster | Nebraska | 31109 | 1588 | 10 |
251121 | 251121 | 2020-06-18 | Lancaster | Nebraska | 31109 | 1569 | 10 |
248006 | 248006 | 2020-06-17 | Lancaster | Nebraska | 31109 | 1545 | 10 |
244893 | 244893 | 2020-06-16 | Lancaster | Nebraska | 31109 | 1521 | 10 |
241782 | 241782 | 2020-06-15 | Lancaster | Nebraska | 31109 | 1487 | 10 |
238672 | 238672 | 2020-06-14 | Lancaster | Nebraska | 31109 | 1472 | 10 |
235565 | 235565 | 2020-06-13 | Lancaster | Nebraska | 31109 | 1464 | 10 |
232459 | 232459 | 2020-06-12 | Lancaster | Nebraska | 31109 | 1445 | 10 |
229354 | 229354 | 2020-06-11 | Lancaster | Nebraska | 31109 | 1429 | 10 |
226251 | 226251 | 2020-06-10 | Lancaster | Nebraska | 31109 | 1397 | 10 |
223152 | 223152 | 2020-06-09 | Lancaster | Nebraska | 31109 | 1376 | 10 |
220056 | 220056 | 2020-06-08 | Lancaster | Nebraska | 31109 | 1372 | 10 |
216964 | 216964 | 2020-06-07 | Lancaster | Nebraska | 31109 | 1356 | 10 |
213875 | 213875 | 2020-06-06 | Lancaster | Nebraska | 31109 | 1340 | 10 |
210791 | 210791 | 2020-06-05 | Lancaster | Nebraska | 31109 | 1310 | 10 |
207709 | 207709 | 2020-06-04 | Lancaster | Nebraska | 31109 | 1278 | 10 |
204628 | 204628 | 2020-06-03 | Lancaster | Nebraska | 31109 | 1263 | 9 |
201551 | 201551 | 2020-06-02 | Lancaster | Nebraska | 31109 | 1245 | 9 |
198477 | 198477 | 2020-06-01 | Lancaster | Nebraska | 31109 | 1228 | 9 |
195404 | 195404 | 2020-05-31 | Lancaster | Nebraska | 31109 | 1212 | 9 |
192334 | 192334 | 2020-05-30 | Lancaster | Nebraska | 31109 | 1195 | 9 |
189270 | 189270 | 2020-05-29 | Lancaster | Nebraska | 31109 | 1176 | 9 |
186211 | 186211 | 2020-05-28 | Lancaster | Nebraska | 31109 | 1140 | 9 |
183155 | 183155 | 2020-05-27 | Lancaster | Nebraska | 31109 | 1120 | 9 |
180107 | 180107 | 2020-05-26 | Lancaster | Nebraska | 31109 | 1098 | 9 |
177063 | 177063 | 2020-05-25 | Lancaster | Nebraska | 31109 | 1090 | 8 |
174020 | 174020 | 2020-05-24 | Lancaster | Nebraska | 31109 | 1056 | 8 |
170977 | 170977 | 2020-05-23 | Lancaster | Nebraska | 31109 | 1033 | 8 |
167938 | 167938 | 2020-05-22 | Lancaster | Nebraska | 31109 | 1005 | 8 |
164902 | 164902 | 2020-05-21 | Lancaster | Nebraska | 31109 | 995 | 7 |
161873 | 161873 | 2020-05-20 | Lancaster | Nebraska | 31109 | 934 | 7 |
158847 | 158847 | 2020-05-19 | Lancaster | Nebraska | 31109 | 912 | 7 |
155829 | 155829 | 2020-05-18 | Lancaster | Nebraska | 31109 | 892 | 6 |
152815 | 152815 | 2020-05-17 | Lancaster | Nebraska | 31109 | 800 | 5 |
149804 | 149804 | 2020-05-16 | Lancaster | Nebraska | 31109 | 791 | 5 |
146798 | 146798 | 2020-05-15 | Lancaster | Nebraska | 31109 | 735 | 5 |
143797 | 143797 | 2020-05-14 | Lancaster | Nebraska | 31109 | 701 | 5 |
140802 | 140802 | 2020-05-13 | Lancaster | Nebraska | 31109 | 687 | 3 |
137808 | 137808 | 2020-05-12 | Lancaster | Nebraska | 31109 | 665 | 3 |
134818 | 134818 | 2020-05-11 | Lancaster | Nebraska | 31109 | 647 | 2 |
131827 | 131827 | 2020-05-10 | Lancaster | Nebraska | 31109 | 607 | 2 |
128837 | 128837 | 2020-05-09 | Lancaster | Nebraska | 31109 | 606 | 2 |
125848 | 125848 | 2020-05-08 | Lancaster | Nebraska | 31109 | 547 | 2 |
122866 | 122866 | 2020-05-07 | Lancaster | Nebraska | 31109 | 509 | 2 |
119892 | 119892 | 2020-05-06 | Lancaster | Nebraska | 31109 | 462 | 1 |
116932 | 116932 | 2020-05-05 | Lancaster | Nebraska | 31109 | 441 | 1 |
114050 | 114050 | 2020-05-04 | Lancaster | Nebraska | 31109 | 394 | 1 |
111170 | 111170 | 2020-05-03 | Lancaster | Nebraska | 31109 | 330 | 1 |
108297 | 108297 | 2020-05-02 | Lancaster | Nebraska | 31109 | 299 | 1 |
105430 | 105430 | 2020-05-01 | Lancaster | Nebraska | 31109 | 281 | 1 |
102569 | 102569 | 2020-04-30 | Lancaster | Nebraska | 31109 | 240 | 1 |
99716 | 99716 | 2020-04-29 | Lancaster | Nebraska | 31109 | 204 | 1 |
96869 | 96869 | 2020-04-28 | Lancaster | Nebraska | 31109 | 158 | 1 |
94033 | 94033 | 2020-04-27 | Lancaster | Nebraska | 31109 | 157 | 1 |
91211 | 91211 | 2020-04-26 | Lancaster | Nebraska | 31109 | 140 | 1 |
88395 | 88395 | 2020-04-25 | Lancaster | Nebraska | 31109 | 120 | 1 |
85585 | 85585 | 2020-04-24 | Lancaster | Nebraska | 31109 | 114 | 1 |
82780 | 82780 | 2020-04-23 | Lancaster | Nebraska | 31109 | 106 | 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);