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 |
---|---|---|---|---|---|---|---|
536138 | 536138 | 2020-09-15 | Lancaster | Nebraska | 31109 | 5302 | 22 |
532903 | 532903 | 2020-09-14 | Lancaster | Nebraska | 31109 | 5196 | 22 |
529667 | 529667 | 2020-09-13 | Lancaster | Nebraska | 31109 | 5155 | 22 |
526431 | 526431 | 2020-09-12 | Lancaster | Nebraska | 31109 | 5102 | 22 |
523195 | 523195 | 2020-09-11 | Lancaster | Nebraska | 31109 | 5000 | 22 |
519958 | 519958 | 2020-09-10 | Lancaster | Nebraska | 31109 | 4843 | 22 |
516723 | 516723 | 2020-09-09 | Lancaster | Nebraska | 31109 | 4700 | 22 |
513489 | 513489 | 2020-09-08 | Lancaster | Nebraska | 31109 | 4582 | 21 |
510257 | 510257 | 2020-09-07 | Lancaster | Nebraska | 31109 | 4498 | 21 |
507024 | 507024 | 2020-09-06 | Lancaster | Nebraska | 31109 | 4468 | 21 |
503791 | 503791 | 2020-09-05 | Lancaster | Nebraska | 31109 | 4445 | 21 |
500557 | 500557 | 2020-09-04 | Lancaster | Nebraska | 31109 | 4397 | 21 |
497323 | 497323 | 2020-09-03 | Lancaster | Nebraska | 31109 | 4313 | 21 |
494090 | 494090 | 2020-09-02 | Lancaster | Nebraska | 31109 | 4213 | 21 |
490856 | 490856 | 2020-09-01 | Lancaster | Nebraska | 31109 | 4117 | 21 |
487623 | 487623 | 2020-08-31 | Lancaster | Nebraska | 31109 | 4059 | 21 |
484389 | 484389 | 2020-08-30 | Lancaster | Nebraska | 31109 | 3990 | 21 |
481154 | 481154 | 2020-08-29 | Lancaster | Nebraska | 31109 | 3923 | 21 |
477922 | 477922 | 2020-08-28 | Lancaster | Nebraska | 31109 | 3875 | 21 |
474689 | 474689 | 2020-08-27 | Lancaster | Nebraska | 31109 | 3802 | 20 |
471457 | 471457 | 2020-08-26 | Lancaster | Nebraska | 31109 | 3741 | 20 |
468226 | 468226 | 2020-08-25 | Lancaster | Nebraska | 31109 | 3707 | 20 |
464997 | 464997 | 2020-08-24 | Lancaster | Nebraska | 31109 | 3641 | 20 |
461766 | 461766 | 2020-08-23 | Lancaster | Nebraska | 31109 | 3635 | 20 |
458539 | 458539 | 2020-08-22 | Lancaster | Nebraska | 31109 | 3618 | 20 |
455311 | 455311 | 2020-08-21 | Lancaster | Nebraska | 31109 | 3591 | 20 |
452083 | 452083 | 2020-08-20 | Lancaster | Nebraska | 31109 | 3553 | 20 |
448855 | 448855 | 2020-08-19 | Lancaster | Nebraska | 31109 | 3520 | 20 |
445630 | 445630 | 2020-08-18 | Lancaster | Nebraska | 31109 | 3501 | 20 |
442403 | 442403 | 2020-08-17 | Lancaster | Nebraska | 31109 | 3486 | 19 |
439176 | 439176 | 2020-08-16 | Lancaster | Nebraska | 31109 | 3467 | 19 |
435951 | 435951 | 2020-08-15 | Lancaster | Nebraska | 31109 | 3452 | 19 |
432725 | 432725 | 2020-08-14 | Lancaster | Nebraska | 31109 | 3431 | 19 |
429498 | 429498 | 2020-08-13 | Lancaster | Nebraska | 31109 | 3415 | 19 |
426273 | 426273 | 2020-08-12 | Lancaster | Nebraska | 31109 | 3384 | 19 |
423051 | 423051 | 2020-08-11 | Lancaster | Nebraska | 31109 | 3361 | 19 |
419828 | 419828 | 2020-08-10 | Lancaster | Nebraska | 31109 | 3337 | 17 |
416607 | 416607 | 2020-08-09 | Lancaster | Nebraska | 31109 | 3313 | 17 |
413387 | 413387 | 2020-08-08 | Lancaster | Nebraska | 31109 | 3287 | 17 |
410167 | 410167 | 2020-08-07 | Lancaster | Nebraska | 31109 | 3266 | 17 |
406947 | 406947 | 2020-08-06 | Lancaster | Nebraska | 31109 | 3244 | 17 |
403728 | 403728 | 2020-08-05 | Lancaster | Nebraska | 31109 | 3215 | 17 |
400510 | 400510 | 2020-08-04 | Lancaster | Nebraska | 31109 | 3195 | 16 |
397295 | 397295 | 2020-08-03 | Lancaster | Nebraska | 31109 | 3163 | 15 |
394079 | 394079 | 2020-08-02 | Lancaster | Nebraska | 31109 | 3118 | 15 |
390862 | 390862 | 2020-08-01 | Lancaster | Nebraska | 31109 | 3074 | 15 |
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 |
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);