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 |
---|---|---|---|---|---|---|---|
636608 | 636608 | 2020-10-16 | Lancaster | Nebraska | 31109 | 7912 | 35 |
633362 | 633362 | 2020-10-15 | Lancaster | Nebraska | 31109 | 7825 | 33 |
630117 | 630117 | 2020-10-14 | Lancaster | Nebraska | 31109 | 7714 | 32 |
626873 | 626873 | 2020-10-13 | Lancaster | Nebraska | 31109 | 7620 | 32 |
623631 | 623631 | 2020-10-12 | Lancaster | Nebraska | 31109 | 7534 | 32 |
620388 | 620388 | 2020-10-11 | Lancaster | Nebraska | 31109 | 7481 | 31 |
617146 | 617146 | 2020-10-10 | Lancaster | Nebraska | 31109 | 7411 | 31 |
613905 | 613905 | 2020-10-09 | Lancaster | Nebraska | 31109 | 7289 | 30 |
610663 | 610663 | 2020-10-08 | Lancaster | Nebraska | 31109 | 7177 | 30 |
607421 | 607421 | 2020-10-07 | Lancaster | Nebraska | 31109 | 7075 | 30 |
604178 | 604178 | 2020-10-06 | Lancaster | Nebraska | 31109 | 6925 | 26 |
600936 | 600936 | 2020-10-05 | Lancaster | Nebraska | 31109 | 6925 | 26 |
597692 | 597692 | 2020-10-04 | Lancaster | Nebraska | 31109 | 6876 | 24 |
594450 | 594450 | 2020-10-03 | Lancaster | Nebraska | 31109 | 6830 | 24 |
591209 | 591209 | 2020-10-02 | Lancaster | Nebraska | 31109 | 6746 | 24 |
587968 | 587968 | 2020-10-01 | Lancaster | Nebraska | 31109 | 6641 | 24 |
584728 | 584728 | 2020-09-30 | Lancaster | Nebraska | 31109 | 6532 | 24 |
581487 | 581487 | 2020-09-29 | Lancaster | Nebraska | 31109 | 6425 | 24 |
578246 | 578246 | 2020-09-28 | Lancaster | Nebraska | 31109 | 6346 | 24 |
575005 | 575005 | 2020-09-27 | Lancaster | Nebraska | 31109 | 6294 | 24 |
571762 | 571762 | 2020-09-26 | Lancaster | Nebraska | 31109 | 6233 | 24 |
568520 | 568520 | 2020-09-25 | Lancaster | Nebraska | 31109 | 6137 | 24 |
565279 | 565279 | 2020-09-24 | Lancaster | Nebraska | 31109 | 6018 | 24 |
562038 | 562038 | 2020-09-23 | Lancaster | Nebraska | 31109 | 5938 | 24 |
558801 | 558801 | 2020-09-22 | Lancaster | Nebraska | 31109 | 5850 | 24 |
555564 | 555564 | 2020-09-21 | Lancaster | Nebraska | 31109 | 5774 | 24 |
552326 | 552326 | 2020-09-20 | Lancaster | Nebraska | 31109 | 5698 | 24 |
549087 | 549087 | 2020-09-19 | Lancaster | Nebraska | 31109 | 5630 | 24 |
545849 | 545849 | 2020-09-18 | Lancaster | Nebraska | 31109 | 5540 | 24 |
542612 | 542612 | 2020-09-17 | Lancaster | Nebraska | 31109 | 5468 | 24 |
539376 | 539376 | 2020-09-16 | Lancaster | Nebraska | 31109 | 5388 | 23 |
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 |
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);