ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,019 rows where county = "Lawrence" and deaths = 0 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 11
- Kentucky 225
- Illinois 162
- Ohio 141
- South Dakota 141
- Alabama 133
- Tennessee 75
- Mississippi 63
- Missouri 56
- Arkansas 11
- Indiana 8
- Pennsylvania 4
fips 11
county 1
- Lawrence · 1,019 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
717049 | 717049 | 2020-11-10 | Lawrence | Kentucky | 21127 | 216 | 0 |
713805 | 713805 | 2020-11-09 | Lawrence | Kentucky | 21127 | 208 | 0 |
710561 | 710561 | 2020-11-08 | Lawrence | Kentucky | 21127 | 195 | 0 |
707317 | 707317 | 2020-11-07 | Lawrence | Kentucky | 21127 | 192 | 0 |
704074 | 704074 | 2020-11-06 | Lawrence | Kentucky | 21127 | 188 | 0 |
700832 | 700832 | 2020-11-05 | Lawrence | Kentucky | 21127 | 179 | 0 |
697588 | 697588 | 2020-11-04 | Lawrence | Kentucky | 21127 | 179 | 0 |
694345 | 694345 | 2020-11-03 | Lawrence | Kentucky | 21127 | 178 | 0 |
691103 | 691103 | 2020-11-02 | Lawrence | Kentucky | 21127 | 175 | 0 |
687858 | 687858 | 2020-11-01 | Lawrence | Kentucky | 21127 | 175 | 0 |
684614 | 684614 | 2020-10-31 | Lawrence | Kentucky | 21127 | 171 | 0 |
681371 | 681371 | 2020-10-30 | Lawrence | Kentucky | 21127 | 161 | 0 |
678127 | 678127 | 2020-10-29 | Lawrence | Kentucky | 21127 | 157 | 0 |
674885 | 674885 | 2020-10-28 | Lawrence | Kentucky | 21127 | 157 | 0 |
671642 | 671642 | 2020-10-27 | Lawrence | Kentucky | 21127 | 153 | 0 |
668400 | 668400 | 2020-10-26 | Lawrence | Kentucky | 21127 | 147 | 0 |
665156 | 665156 | 2020-10-25 | Lawrence | Kentucky | 21127 | 144 | 0 |
661911 | 661911 | 2020-10-24 | Lawrence | Kentucky | 21127 | 141 | 0 |
658667 | 658667 | 2020-10-23 | Lawrence | Kentucky | 21127 | 137 | 0 |
655422 | 655422 | 2020-10-22 | Lawrence | Kentucky | 21127 | 137 | 0 |
652177 | 652177 | 2020-10-21 | Lawrence | Kentucky | 21127 | 131 | 0 |
648932 | 648932 | 2020-10-20 | Lawrence | Kentucky | 21127 | 126 | 0 |
645688 | 645688 | 2020-10-19 | Lawrence | Kentucky | 21127 | 119 | 0 |
642441 | 642441 | 2020-10-18 | Lawrence | Kentucky | 21127 | 119 | 0 |
639194 | 639194 | 2020-10-17 | Lawrence | Kentucky | 21127 | 116 | 0 |
635948 | 635948 | 2020-10-16 | Lawrence | Kentucky | 21127 | 115 | 0 |
632702 | 632702 | 2020-10-15 | Lawrence | Kentucky | 21127 | 110 | 0 |
629458 | 629458 | 2020-10-14 | Lawrence | Kentucky | 21127 | 108 | 0 |
626214 | 626214 | 2020-10-13 | Lawrence | Kentucky | 21127 | 90 | 0 |
622972 | 622972 | 2020-10-12 | Lawrence | Kentucky | 21127 | 88 | 0 |
619728 | 619728 | 2020-10-11 | Lawrence | Kentucky | 21127 | 86 | 0 |
616486 | 616486 | 2020-10-10 | Lawrence | Kentucky | 21127 | 80 | 0 |
613245 | 613245 | 2020-10-09 | Lawrence | Kentucky | 21127 | 78 | 0 |
610003 | 610003 | 2020-10-08 | Lawrence | Kentucky | 21127 | 77 | 0 |
606761 | 606761 | 2020-10-07 | Lawrence | Kentucky | 21127 | 73 | 0 |
603519 | 603519 | 2020-10-06 | Lawrence | Kentucky | 21127 | 70 | 0 |
600276 | 600276 | 2020-10-05 | Lawrence | Kentucky | 21127 | 67 | 0 |
597034 | 597034 | 2020-10-04 | Lawrence | Kentucky | 21127 | 62 | 0 |
593792 | 593792 | 2020-10-03 | Lawrence | Kentucky | 21127 | 62 | 0 |
590551 | 590551 | 2020-10-02 | Lawrence | Kentucky | 21127 | 60 | 0 |
587310 | 587310 | 2020-10-01 | Lawrence | Kentucky | 21127 | 58 | 0 |
584070 | 584070 | 2020-09-30 | Lawrence | Kentucky | 21127 | 57 | 0 |
580830 | 580830 | 2020-09-29 | Lawrence | Kentucky | 21127 | 57 | 0 |
577589 | 577589 | 2020-09-28 | Lawrence | Kentucky | 21127 | 57 | 0 |
574347 | 574347 | 2020-09-27 | Lawrence | Kentucky | 21127 | 57 | 0 |
571104 | 571104 | 2020-09-26 | Lawrence | Kentucky | 21127 | 56 | 0 |
567862 | 567862 | 2020-09-25 | Lawrence | Kentucky | 21127 | 56 | 0 |
564622 | 564622 | 2020-09-24 | Lawrence | Kentucky | 21127 | 56 | 0 |
561382 | 561382 | 2020-09-23 | Lawrence | Kentucky | 21127 | 55 | 0 |
558146 | 558146 | 2020-09-22 | Lawrence | Kentucky | 21127 | 55 | 0 |
554909 | 554909 | 2020-09-21 | Lawrence | Kentucky | 21127 | 55 | 0 |
551670 | 551670 | 2020-09-20 | Lawrence | Kentucky | 21127 | 55 | 0 |
548431 | 548431 | 2020-09-19 | Lawrence | Kentucky | 21127 | 54 | 0 |
545193 | 545193 | 2020-09-18 | Lawrence | Kentucky | 21127 | 52 | 0 |
541957 | 541957 | 2020-09-17 | Lawrence | Kentucky | 21127 | 51 | 0 |
538721 | 538721 | 2020-09-16 | Lawrence | Kentucky | 21127 | 52 | 0 |
535071 | 535071 | 2020-09-15 | Lawrence | Illinois | 17101 | 235 | 0 |
535484 | 535484 | 2020-09-15 | Lawrence | Kentucky | 21127 | 52 | 0 |
531836 | 531836 | 2020-09-14 | Lawrence | Illinois | 17101 | 235 | 0 |
532249 | 532249 | 2020-09-14 | Lawrence | Kentucky | 21127 | 53 | 0 |
528599 | 528599 | 2020-09-13 | Lawrence | Illinois | 17101 | 233 | 0 |
529012 | 529012 | 2020-09-13 | Lawrence | Kentucky | 21127 | 53 | 0 |
525363 | 525363 | 2020-09-12 | Lawrence | Illinois | 17101 | 225 | 0 |
525776 | 525776 | 2020-09-12 | Lawrence | Kentucky | 21127 | 53 | 0 |
522127 | 522127 | 2020-09-11 | Lawrence | Illinois | 17101 | 210 | 0 |
522540 | 522540 | 2020-09-11 | Lawrence | Kentucky | 21127 | 53 | 0 |
518890 | 518890 | 2020-09-10 | Lawrence | Illinois | 17101 | 207 | 0 |
519303 | 519303 | 2020-09-10 | Lawrence | Kentucky | 21127 | 51 | 0 |
515655 | 515655 | 2020-09-09 | Lawrence | Illinois | 17101 | 206 | 0 |
516068 | 516068 | 2020-09-09 | Lawrence | Kentucky | 21127 | 47 | 0 |
512422 | 512422 | 2020-09-08 | Lawrence | Illinois | 17101 | 205 | 0 |
512835 | 512835 | 2020-09-08 | Lawrence | Kentucky | 21127 | 47 | 0 |
509189 | 509189 | 2020-09-07 | Lawrence | Illinois | 17101 | 199 | 0 |
509603 | 509603 | 2020-09-07 | Lawrence | Kentucky | 21127 | 47 | 0 |
505957 | 505957 | 2020-09-06 | Lawrence | Illinois | 17101 | 196 | 0 |
506370 | 506370 | 2020-09-06 | Lawrence | Kentucky | 21127 | 47 | 0 |
502723 | 502723 | 2020-09-05 | Lawrence | Illinois | 17101 | 193 | 0 |
503136 | 503136 | 2020-09-05 | Lawrence | Kentucky | 21127 | 47 | 0 |
499489 | 499489 | 2020-09-04 | Lawrence | Illinois | 17101 | 175 | 0 |
499903 | 499903 | 2020-09-04 | Lawrence | Kentucky | 21127 | 46 | 0 |
496256 | 496256 | 2020-09-03 | Lawrence | Illinois | 17101 | 142 | 0 |
496669 | 496669 | 2020-09-03 | Lawrence | Kentucky | 21127 | 46 | 0 |
493022 | 493022 | 2020-09-02 | Lawrence | Illinois | 17101 | 142 | 0 |
493436 | 493436 | 2020-09-02 | Lawrence | Kentucky | 21127 | 46 | 0 |
489789 | 489789 | 2020-09-01 | Lawrence | Illinois | 17101 | 136 | 0 |
490202 | 490202 | 2020-09-01 | Lawrence | Kentucky | 21127 | 44 | 0 |
486556 | 486556 | 2020-08-31 | Lawrence | Illinois | 17101 | 137 | 0 |
486969 | 486969 | 2020-08-31 | Lawrence | Kentucky | 21127 | 43 | 0 |
483321 | 483321 | 2020-08-30 | Lawrence | Illinois | 17101 | 135 | 0 |
483734 | 483734 | 2020-08-30 | Lawrence | Kentucky | 21127 | 43 | 0 |
480087 | 480087 | 2020-08-29 | Lawrence | Illinois | 17101 | 111 | 0 |
480500 | 480500 | 2020-08-29 | Lawrence | Kentucky | 21127 | 43 | 0 |
476854 | 476854 | 2020-08-28 | Lawrence | Illinois | 17101 | 96 | 0 |
477267 | 477267 | 2020-08-28 | Lawrence | Kentucky | 21127 | 44 | 0 |
473621 | 473621 | 2020-08-27 | Lawrence | Illinois | 17101 | 93 | 0 |
474034 | 474034 | 2020-08-27 | Lawrence | Kentucky | 21127 | 43 | 0 |
470389 | 470389 | 2020-08-26 | Lawrence | Illinois | 17101 | 89 | 0 |
470802 | 470802 | 2020-08-26 | Lawrence | Kentucky | 21127 | 40 | 0 |
467160 | 467160 | 2020-08-25 | Lawrence | Illinois | 17101 | 89 | 0 |
467573 | 467573 | 2020-08-25 | Lawrence | Kentucky | 21127 | 40 | 0 |
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);