ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lincoln" and fips = 29113 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
304397 | 304397 | 2020-07-05 | Lincoln | Missouri | 29113 | 98 | 1 |
307564 | 307564 | 2020-07-06 | Lincoln | Missouri | 29113 | 102 | 1 |
310732 | 310732 | 2020-07-07 | Lincoln | Missouri | 29113 | 105 | 1 |
313903 | 313903 | 2020-07-08 | Lincoln | Missouri | 29113 | 106 | 1 |
317077 | 317077 | 2020-07-09 | Lincoln | Missouri | 29113 | 110 | 1 |
320252 | 320252 | 2020-07-10 | Lincoln | Missouri | 29113 | 110 | 1 |
323431 | 323431 | 2020-07-11 | Lincoln | Missouri | 29113 | 112 | 1 |
326614 | 326614 | 2020-07-12 | Lincoln | Missouri | 29113 | 119 | 1 |
329800 | 329800 | 2020-07-13 | Lincoln | Missouri | 29113 | 120 | 1 |
332987 | 332987 | 2020-07-14 | Lincoln | Missouri | 29113 | 122 | 1 |
336180 | 336180 | 2020-07-15 | Lincoln | Missouri | 29113 | 127 | 1 |
339376 | 339376 | 2020-07-16 | Lincoln | Missouri | 29113 | 128 | 1 |
342572 | 342572 | 2020-07-17 | Lincoln | Missouri | 29113 | 133 | 1 |
345772 | 345772 | 2020-07-18 | Lincoln | Missouri | 29113 | 144 | 1 |
348973 | 348973 | 2020-07-19 | Lincoln | Missouri | 29113 | 153 | 1 |
352173 | 352173 | 2020-07-20 | Lincoln | Missouri | 29113 | 153 | 1 |
355375 | 355375 | 2020-07-21 | Lincoln | Missouri | 29113 | 160 | 1 |
358578 | 358578 | 2020-07-22 | Lincoln | Missouri | 29113 | 172 | 1 |
361783 | 361783 | 2020-07-23 | Lincoln | Missouri | 29113 | 185 | 1 |
364990 | 364990 | 2020-07-24 | Lincoln | Missouri | 29113 | 202 | 1 |
368198 | 368198 | 2020-07-25 | Lincoln | Missouri | 29113 | 212 | 1 |
371409 | 371409 | 2020-07-26 | Lincoln | Missouri | 29113 | 221 | 1 |
374621 | 374621 | 2020-07-27 | Lincoln | Missouri | 29113 | 228 | 1 |
377836 | 377836 | 2020-07-28 | Lincoln | Missouri | 29113 | 242 | 1 |
381053 | 381053 | 2020-07-29 | Lincoln | Missouri | 29113 | 258 | 1 |
384269 | 384269 | 2020-07-30 | Lincoln | Missouri | 29113 | 272 | 1 |
387487 | 387487 | 2020-07-31 | Lincoln | Missouri | 29113 | 288 | 1 |
390704 | 390704 | 2020-08-01 | Lincoln | Missouri | 29113 | 293 | 1 |
393921 | 393921 | 2020-08-02 | Lincoln | Missouri | 29113 | 301 | 1 |
397137 | 397137 | 2020-08-03 | Lincoln | Missouri | 29113 | 314 | 1 |
400351 | 400351 | 2020-08-04 | Lincoln | Missouri | 29113 | 331 | 1 |
403568 | 403568 | 2020-08-05 | Lincoln | Missouri | 29113 | 343 | 1 |
406786 | 406786 | 2020-08-06 | Lincoln | Missouri | 29113 | 352 | 1 |
410006 | 410006 | 2020-08-07 | Lincoln | Missouri | 29113 | 360 | 1 |
413226 | 413226 | 2020-08-08 | Lincoln | Missouri | 29113 | 360 | 1 |
416446 | 416446 | 2020-08-09 | Lincoln | Missouri | 29113 | 374 | 1 |
419667 | 419667 | 2020-08-10 | Lincoln | Missouri | 29113 | 382 | 1 |
422889 | 422889 | 2020-08-11 | Lincoln | Missouri | 29113 | 398 | 1 |
426111 | 426111 | 2020-08-12 | Lincoln | Missouri | 29113 | 412 | 1 |
429335 | 429335 | 2020-08-13 | Lincoln | Missouri | 29113 | 416 | 1 |
432562 | 432562 | 2020-08-14 | Lincoln | Missouri | 29113 | 421 | 1 |
435788 | 435788 | 2020-08-15 | Lincoln | Missouri | 29113 | 430 | 1 |
439013 | 439013 | 2020-08-16 | Lincoln | Missouri | 29113 | 439 | 1 |
442240 | 442240 | 2020-08-17 | Lincoln | Missouri | 29113 | 449 | 1 |
445466 | 445466 | 2020-08-18 | Lincoln | Missouri | 29113 | 454 | 1 |
448692 | 448692 | 2020-08-19 | Lincoln | Missouri | 29113 | 461 | 1 |
451920 | 451920 | 2020-08-20 | Lincoln | Missouri | 29113 | 468 | 1 |
455148 | 455148 | 2020-08-21 | Lincoln | Missouri | 29113 | 474 | 1 |
458376 | 458376 | 2020-08-22 | Lincoln | Missouri | 29113 | 488 | 1 |
461603 | 461603 | 2020-08-23 | Lincoln | Missouri | 29113 | 497 | 1 |
464834 | 464834 | 2020-08-24 | Lincoln | Missouri | 29113 | 505 | 1 |
468063 | 468063 | 2020-08-25 | Lincoln | Missouri | 29113 | 510 | 1 |
471293 | 471293 | 2020-08-26 | Lincoln | Missouri | 29113 | 514 | 1 |
474525 | 474525 | 2020-08-27 | Lincoln | Missouri | 29113 | 525 | 1 |
477758 | 477758 | 2020-08-28 | Lincoln | Missouri | 29113 | 537 | 1 |
480990 | 480990 | 2020-08-29 | Lincoln | Missouri | 29113 | 551 | 1 |
484225 | 484225 | 2020-08-30 | Lincoln | Missouri | 29113 | 559 | 1 |
487459 | 487459 | 2020-08-31 | Lincoln | Missouri | 29113 | 564 | 1 |
490692 | 490692 | 2020-09-01 | Lincoln | Missouri | 29113 | 574 | 1 |
493926 | 493926 | 2020-09-02 | Lincoln | Missouri | 29113 | 586 | 1 |
497159 | 497159 | 2020-09-03 | Lincoln | Missouri | 29113 | 598 | 1 |
500393 | 500393 | 2020-09-04 | Lincoln | Missouri | 29113 | 602 | 1 |
503627 | 503627 | 2020-09-05 | Lincoln | Missouri | 29113 | 614 | 1 |
506860 | 506860 | 2020-09-06 | Lincoln | Missouri | 29113 | 621 | 1 |
510093 | 510093 | 2020-09-07 | Lincoln | Missouri | 29113 | 625 | 1 |
513325 | 513325 | 2020-09-08 | Lincoln | Missouri | 29113 | 626 | 1 |
516559 | 516559 | 2020-09-09 | Lincoln | Missouri | 29113 | 630 | 2 |
519794 | 519794 | 2020-09-10 | Lincoln | Missouri | 29113 | 637 | 2 |
523031 | 523031 | 2020-09-11 | Lincoln | Missouri | 29113 | 641 | 2 |
526267 | 526267 | 2020-09-12 | Lincoln | Missouri | 29113 | 650 | 2 |
529503 | 529503 | 2020-09-13 | Lincoln | Missouri | 29113 | 666 | 2 |
532739 | 532739 | 2020-09-14 | Lincoln | Missouri | 29113 | 675 | 2 |
535974 | 535974 | 2020-09-15 | Lincoln | Missouri | 29113 | 682 | 2 |
539211 | 539211 | 2020-09-16 | Lincoln | Missouri | 29113 | 686 | 2 |
542447 | 542447 | 2020-09-17 | Lincoln | Missouri | 29113 | 694 | 3 |
545684 | 545684 | 2020-09-18 | Lincoln | Missouri | 29113 | 700 | 3 |
548922 | 548922 | 2020-09-19 | Lincoln | Missouri | 29113 | 704 | 3 |
552161 | 552161 | 2020-09-20 | Lincoln | Missouri | 29113 | 711 | 3 |
555399 | 555399 | 2020-09-21 | Lincoln | Missouri | 29113 | 719 | 3 |
558636 | 558636 | 2020-09-22 | Lincoln | Missouri | 29113 | 722 | 3 |
561873 | 561873 | 2020-09-23 | Lincoln | Missouri | 29113 | 733 | 3 |
565113 | 565113 | 2020-09-24 | Lincoln | Missouri | 29113 | 738 | 3 |
568353 | 568353 | 2020-09-25 | Lincoln | Missouri | 29113 | 748 | 3 |
571595 | 571595 | 2020-09-26 | Lincoln | Missouri | 29113 | 762 | 3 |
574838 | 574838 | 2020-09-27 | Lincoln | Missouri | 29113 | 776 | 3 |
578079 | 578079 | 2020-09-28 | Lincoln | Missouri | 29113 | 787 | 3 |
581320 | 581320 | 2020-09-29 | Lincoln | Missouri | 29113 | 787 | 3 |
584561 | 584561 | 2020-09-30 | Lincoln | Missouri | 29113 | 812 | 3 |
587801 | 587801 | 2020-10-01 | Lincoln | Missouri | 29113 | 825 | 3 |
591042 | 591042 | 2020-10-02 | Lincoln | Missouri | 29113 | 833 | 3 |
594283 | 594283 | 2020-10-03 | Lincoln | Missouri | 29113 | 858 | 3 |
597524 | 597524 | 2020-10-04 | Lincoln | Missouri | 29113 | 876 | 3 |
600767 | 600767 | 2020-10-05 | Lincoln | Missouri | 29113 | 884 | 3 |
604009 | 604009 | 2020-10-06 | Lincoln | Missouri | 29113 | 893 | 3 |
607252 | 607252 | 2020-10-07 | Lincoln | Missouri | 29113 | 901 | 3 |
610494 | 610494 | 2020-10-08 | Lincoln | Missouri | 29113 | 915 | 3 |
613736 | 613736 | 2020-10-09 | Lincoln | Missouri | 29113 | 938 | 3 |
616977 | 616977 | 2020-10-10 | Lincoln | Missouri | 29113 | 948 | 3 |
620219 | 620219 | 2020-10-11 | Lincoln | Missouri | 29113 | 948 | 3 |
623462 | 623462 | 2020-10-12 | Lincoln | Missouri | 29113 | 948 | 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);