ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
741 rows where county = "Lawrence" and fips = 29109 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
422887 | 422887 | 2020-08-11 | Lawrence | Missouri | 29109 | 233 | 2 |
426109 | 426109 | 2020-08-12 | Lawrence | Missouri | 29109 | 240 | 2 |
429333 | 429333 | 2020-08-13 | Lawrence | Missouri | 29109 | 246 | 2 |
432560 | 432560 | 2020-08-14 | Lawrence | Missouri | 29109 | 247 | 2 |
435786 | 435786 | 2020-08-15 | Lawrence | Missouri | 29109 | 252 | 2 |
439011 | 439011 | 2020-08-16 | Lawrence | Missouri | 29109 | 264 | 2 |
442238 | 442238 | 2020-08-17 | Lawrence | Missouri | 29109 | 271 | 2 |
445464 | 445464 | 2020-08-18 | Lawrence | Missouri | 29109 | 275 | 2 |
448690 | 448690 | 2020-08-19 | Lawrence | Missouri | 29109 | 288 | 2 |
451918 | 451918 | 2020-08-20 | Lawrence | Missouri | 29109 | 293 | 2 |
455146 | 455146 | 2020-08-21 | Lawrence | Missouri | 29109 | 296 | 2 |
458374 | 458374 | 2020-08-22 | Lawrence | Missouri | 29109 | 301 | 2 |
461601 | 461601 | 2020-08-23 | Lawrence | Missouri | 29109 | 310 | 2 |
464832 | 464832 | 2020-08-24 | Lawrence | Missouri | 29109 | 317 | 2 |
468061 | 468061 | 2020-08-25 | Lawrence | Missouri | 29109 | 319 | 2 |
471291 | 471291 | 2020-08-26 | Lawrence | Missouri | 29109 | 323 | 2 |
474523 | 474523 | 2020-08-27 | Lawrence | Missouri | 29109 | 335 | 2 |
477756 | 477756 | 2020-08-28 | Lawrence | Missouri | 29109 | 342 | 2 |
480988 | 480988 | 2020-08-29 | Lawrence | Missouri | 29109 | 351 | 2 |
484223 | 484223 | 2020-08-30 | Lawrence | Missouri | 29109 | 352 | 2 |
487457 | 487457 | 2020-08-31 | Lawrence | Missouri | 29109 | 354 | 2 |
490690 | 490690 | 2020-09-01 | Lawrence | Missouri | 29109 | 356 | 2 |
493924 | 493924 | 2020-09-02 | Lawrence | Missouri | 29109 | 363 | 2 |
497157 | 497157 | 2020-09-03 | Lawrence | Missouri | 29109 | 370 | 2 |
500391 | 500391 | 2020-09-04 | Lawrence | Missouri | 29109 | 378 | 2 |
503625 | 503625 | 2020-09-05 | Lawrence | Missouri | 29109 | 389 | 2 |
506858 | 506858 | 2020-09-06 | Lawrence | Missouri | 29109 | 393 | 2 |
510091 | 510091 | 2020-09-07 | Lawrence | Missouri | 29109 | 393 | 2 |
513323 | 513323 | 2020-09-08 | Lawrence | Missouri | 29109 | 399 | 2 |
516557 | 516557 | 2020-09-09 | Lawrence | Missouri | 29109 | 408 | 2 |
519792 | 519792 | 2020-09-10 | Lawrence | Missouri | 29109 | 419 | 2 |
523029 | 523029 | 2020-09-11 | Lawrence | Missouri | 29109 | 422 | 2 |
526265 | 526265 | 2020-09-12 | Lawrence | Missouri | 29109 | 434 | 2 |
529501 | 529501 | 2020-09-13 | Lawrence | Missouri | 29109 | 441 | 2 |
532737 | 532737 | 2020-09-14 | Lawrence | Missouri | 29109 | 448 | 2 |
535972 | 535972 | 2020-09-15 | Lawrence | Missouri | 29109 | 454 | 2 |
539209 | 539209 | 2020-09-16 | Lawrence | Missouri | 29109 | 462 | 2 |
542445 | 542445 | 2020-09-17 | Lawrence | Missouri | 29109 | 475 | 2 |
545682 | 545682 | 2020-09-18 | Lawrence | Missouri | 29109 | 494 | 2 |
548920 | 548920 | 2020-09-19 | Lawrence | Missouri | 29109 | 507 | 2 |
552159 | 552159 | 2020-09-20 | Lawrence | Missouri | 29109 | 524 | 2 |
555397 | 555397 | 2020-09-21 | Lawrence | Missouri | 29109 | 532 | 2 |
558634 | 558634 | 2020-09-22 | Lawrence | Missouri | 29109 | 555 | 2 |
561871 | 561871 | 2020-09-23 | Lawrence | Missouri | 29109 | 571 | 2 |
565111 | 565111 | 2020-09-24 | Lawrence | Missouri | 29109 | 584 | 2 |
568351 | 568351 | 2020-09-25 | Lawrence | Missouri | 29109 | 611 | 2 |
571593 | 571593 | 2020-09-26 | Lawrence | Missouri | 29109 | 619 | 4 |
574836 | 574836 | 2020-09-27 | Lawrence | Missouri | 29109 | 624 | 4 |
578077 | 578077 | 2020-09-28 | Lawrence | Missouri | 29109 | 635 | 4 |
581318 | 581318 | 2020-09-29 | Lawrence | Missouri | 29109 | 635 | 4 |
584559 | 584559 | 2020-09-30 | Lawrence | Missouri | 29109 | 670 | 4 |
587799 | 587799 | 2020-10-01 | Lawrence | Missouri | 29109 | 692 | 3 |
591040 | 591040 | 2020-10-02 | Lawrence | Missouri | 29109 | 698 | 4 |
594281 | 594281 | 2020-10-03 | Lawrence | Missouri | 29109 | 716 | 4 |
597522 | 597522 | 2020-10-04 | Lawrence | Missouri | 29109 | 731 | 4 |
600765 | 600765 | 2020-10-05 | Lawrence | Missouri | 29109 | 738 | 4 |
604007 | 604007 | 2020-10-06 | Lawrence | Missouri | 29109 | 747 | 4 |
607250 | 607250 | 2020-10-07 | Lawrence | Missouri | 29109 | 755 | 3 |
610492 | 610492 | 2020-10-08 | Lawrence | Missouri | 29109 | 772 | 13 |
613734 | 613734 | 2020-10-09 | Lawrence | Missouri | 29109 | 786 | 13 |
616975 | 616975 | 2020-10-10 | Lawrence | Missouri | 29109 | 823 | 13 |
620217 | 620217 | 2020-10-11 | Lawrence | Missouri | 29109 | 823 | 13 |
623460 | 623460 | 2020-10-12 | Lawrence | Missouri | 29109 | 823 | 13 |
626702 | 626702 | 2020-10-13 | Lawrence | Missouri | 29109 | 823 | 13 |
629946 | 629946 | 2020-10-14 | Lawrence | Missouri | 29109 | 880 | 14 |
633191 | 633191 | 2020-10-15 | Lawrence | Missouri | 29109 | 907 | 13 |
636437 | 636437 | 2020-10-16 | Lawrence | Missouri | 29109 | 928 | 13 |
639683 | 639683 | 2020-10-17 | Lawrence | Missouri | 29109 | 944 | 14 |
642931 | 642931 | 2020-10-18 | Lawrence | Missouri | 29109 | 957 | 14 |
646177 | 646177 | 2020-10-19 | Lawrence | Missouri | 29109 | 974 | 14 |
649421 | 649421 | 2020-10-20 | Lawrence | Missouri | 29109 | 974 | 14 |
652666 | 652666 | 2020-10-21 | Lawrence | Missouri | 29109 | 1006 | 14 |
655911 | 655911 | 2020-10-22 | Lawrence | Missouri | 29109 | 1018 | 14 |
659156 | 659156 | 2020-10-23 | Lawrence | Missouri | 29109 | 1034 | 14 |
662400 | 662400 | 2020-10-24 | Lawrence | Missouri | 29109 | 1062 | 20 |
665645 | 665645 | 2020-10-25 | Lawrence | Missouri | 29109 | 1089 | 20 |
668889 | 668889 | 2020-10-26 | Lawrence | Missouri | 29109 | 1096 | 20 |
672131 | 672131 | 2020-10-27 | Lawrence | Missouri | 29109 | 1105 | 21 |
675374 | 675374 | 2020-10-28 | Lawrence | Missouri | 29109 | 1126 | 21 |
678616 | 678616 | 2020-10-29 | Lawrence | Missouri | 29109 | 1139 | 21 |
681860 | 681860 | 2020-10-30 | Lawrence | Missouri | 29109 | 1156 | 21 |
685103 | 685103 | 2020-10-31 | Lawrence | Missouri | 29109 | 1177 | 24 |
688347 | 688347 | 2020-11-01 | Lawrence | Missouri | 29109 | 1193 | 24 |
691592 | 691592 | 2020-11-02 | Lawrence | Missouri | 29109 | 1222 | 24 |
694834 | 694834 | 2020-11-03 | Lawrence | Missouri | 29109 | 1239 | 24 |
698077 | 698077 | 2020-11-04 | Lawrence | Missouri | 29109 | 1256 | 24 |
701321 | 701321 | 2020-11-05 | Lawrence | Missouri | 29109 | 1284 | 25 |
704563 | 704563 | 2020-11-06 | Lawrence | Missouri | 29109 | 1324 | 26 |
707806 | 707806 | 2020-11-07 | Lawrence | Missouri | 29109 | 1351 | 26 |
711050 | 711050 | 2020-11-08 | Lawrence | Missouri | 29109 | 1381 | 26 |
714294 | 714294 | 2020-11-09 | Lawrence | Missouri | 29109 | 1410 | 26 |
717538 | 717538 | 2020-11-10 | Lawrence | Missouri | 29109 | 1440 | 32 |
720781 | 720781 | 2020-11-11 | Lawrence | Missouri | 29109 | 1459 | 32 |
724024 | 724024 | 2020-11-12 | Lawrence | Missouri | 29109 | 1489 | 32 |
727267 | 727267 | 2020-11-13 | Lawrence | Missouri | 29109 | 1517 | 32 |
730510 | 730510 | 2020-11-14 | Lawrence | Missouri | 29109 | 1585 | 32 |
733755 | 733755 | 2020-11-15 | Lawrence | Missouri | 29109 | 1585 | 32 |
737001 | 737001 | 2020-11-16 | Lawrence | Missouri | 29109 | 1618 | 32 |
740245 | 740245 | 2020-11-17 | Lawrence | Missouri | 29109 | 1657 | 33 |
743492 | 743492 | 2020-11-18 | Lawrence | Missouri | 29109 | 1679 | 33 |
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);