ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Lawrence" and fips = 21127 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
316587 | 316587 | 2020-07-09 | Lawrence | Kentucky | 21127 | 11 | 0 |
319762 | 319762 | 2020-07-10 | Lawrence | Kentucky | 21127 | 11 | 0 |
322941 | 322941 | 2020-07-11 | Lawrence | Kentucky | 21127 | 11 | 0 |
326124 | 326124 | 2020-07-12 | Lawrence | Kentucky | 21127 | 11 | 0 |
329310 | 329310 | 2020-07-13 | Lawrence | Kentucky | 21127 | 11 | 0 |
332497 | 332497 | 2020-07-14 | Lawrence | Kentucky | 21127 | 13 | 0 |
335690 | 335690 | 2020-07-15 | Lawrence | Kentucky | 21127 | 14 | 0 |
338886 | 338886 | 2020-07-16 | Lawrence | Kentucky | 21127 | 14 | 0 |
342082 | 342082 | 2020-07-17 | Lawrence | Kentucky | 21127 | 14 | 0 |
345282 | 345282 | 2020-07-18 | Lawrence | Kentucky | 21127 | 14 | 0 |
348483 | 348483 | 2020-07-19 | Lawrence | Kentucky | 21127 | 15 | 0 |
351683 | 351683 | 2020-07-20 | Lawrence | Kentucky | 21127 | 16 | 0 |
354885 | 354885 | 2020-07-21 | Lawrence | Kentucky | 21127 | 20 | 0 |
358088 | 358088 | 2020-07-22 | Lawrence | Kentucky | 21127 | 21 | 0 |
361293 | 361293 | 2020-07-23 | Lawrence | Kentucky | 21127 | 22 | 0 |
364500 | 364500 | 2020-07-24 | Lawrence | Kentucky | 21127 | 22 | 0 |
367707 | 367707 | 2020-07-25 | Lawrence | Kentucky | 21127 | 25 | 0 |
370917 | 370917 | 2020-07-26 | Lawrence | Kentucky | 21127 | 27 | 0 |
374129 | 374129 | 2020-07-27 | Lawrence | Kentucky | 21127 | 27 | 0 |
377344 | 377344 | 2020-07-28 | Lawrence | Kentucky | 21127 | 31 | 0 |
380561 | 380561 | 2020-07-29 | Lawrence | Kentucky | 21127 | 32 | 0 |
383778 | 383778 | 2020-07-30 | Lawrence | Kentucky | 21127 | 32 | 0 |
386996 | 386996 | 2020-07-31 | Lawrence | Kentucky | 21127 | 32 | 0 |
390213 | 390213 | 2020-08-01 | Lawrence | Kentucky | 21127 | 33 | 0 |
393430 | 393430 | 2020-08-02 | Lawrence | Kentucky | 21127 | 33 | 0 |
396646 | 396646 | 2020-08-03 | Lawrence | Kentucky | 21127 | 33 | 0 |
399861 | 399861 | 2020-08-04 | Lawrence | Kentucky | 21127 | 34 | 0 |
403078 | 403078 | 2020-08-05 | Lawrence | Kentucky | 21127 | 36 | 0 |
406296 | 406296 | 2020-08-06 | Lawrence | Kentucky | 21127 | 36 | 0 |
409516 | 409516 | 2020-08-07 | Lawrence | Kentucky | 21127 | 36 | 0 |
412736 | 412736 | 2020-08-08 | Lawrence | Kentucky | 21127 | 36 | 0 |
415956 | 415956 | 2020-08-09 | Lawrence | Kentucky | 21127 | 36 | 0 |
419177 | 419177 | 2020-08-10 | Lawrence | Kentucky | 21127 | 36 | 0 |
422399 | 422399 | 2020-08-11 | Lawrence | Kentucky | 21127 | 36 | 0 |
425620 | 425620 | 2020-08-12 | Lawrence | Kentucky | 21127 | 37 | 0 |
428844 | 428844 | 2020-08-13 | Lawrence | Kentucky | 21127 | 37 | 0 |
432072 | 432072 | 2020-08-14 | Lawrence | Kentucky | 21127 | 37 | 0 |
435297 | 435297 | 2020-08-15 | Lawrence | Kentucky | 21127 | 38 | 0 |
438522 | 438522 | 2020-08-16 | Lawrence | Kentucky | 21127 | 38 | 0 |
441749 | 441749 | 2020-08-17 | Lawrence | Kentucky | 21127 | 38 | 0 |
444975 | 444975 | 2020-08-18 | Lawrence | Kentucky | 21127 | 39 | 0 |
448202 | 448202 | 2020-08-19 | Lawrence | Kentucky | 21127 | 39 | 0 |
451430 | 451430 | 2020-08-20 | Lawrence | Kentucky | 21127 | 39 | 0 |
454658 | 454658 | 2020-08-21 | Lawrence | Kentucky | 21127 | 39 | 0 |
457886 | 457886 | 2020-08-22 | Lawrence | Kentucky | 21127 | 40 | 0 |
461113 | 461113 | 2020-08-23 | Lawrence | Kentucky | 21127 | 40 | 0 |
464344 | 464344 | 2020-08-24 | Lawrence | Kentucky | 21127 | 40 | 0 |
467573 | 467573 | 2020-08-25 | Lawrence | Kentucky | 21127 | 40 | 0 |
470802 | 470802 | 2020-08-26 | Lawrence | Kentucky | 21127 | 40 | 0 |
474034 | 474034 | 2020-08-27 | Lawrence | Kentucky | 21127 | 43 | 0 |
477267 | 477267 | 2020-08-28 | Lawrence | Kentucky | 21127 | 44 | 0 |
480500 | 480500 | 2020-08-29 | Lawrence | Kentucky | 21127 | 43 | 0 |
483734 | 483734 | 2020-08-30 | Lawrence | Kentucky | 21127 | 43 | 0 |
486969 | 486969 | 2020-08-31 | Lawrence | Kentucky | 21127 | 43 | 0 |
490202 | 490202 | 2020-09-01 | Lawrence | Kentucky | 21127 | 44 | 0 |
493436 | 493436 | 2020-09-02 | Lawrence | Kentucky | 21127 | 46 | 0 |
496669 | 496669 | 2020-09-03 | Lawrence | Kentucky | 21127 | 46 | 0 |
499903 | 499903 | 2020-09-04 | Lawrence | Kentucky | 21127 | 46 | 0 |
503136 | 503136 | 2020-09-05 | Lawrence | Kentucky | 21127 | 47 | 0 |
506370 | 506370 | 2020-09-06 | Lawrence | Kentucky | 21127 | 47 | 0 |
509603 | 509603 | 2020-09-07 | Lawrence | Kentucky | 21127 | 47 | 0 |
512835 | 512835 | 2020-09-08 | Lawrence | Kentucky | 21127 | 47 | 0 |
516068 | 516068 | 2020-09-09 | Lawrence | Kentucky | 21127 | 47 | 0 |
519303 | 519303 | 2020-09-10 | Lawrence | Kentucky | 21127 | 51 | 0 |
522540 | 522540 | 2020-09-11 | Lawrence | Kentucky | 21127 | 53 | 0 |
525776 | 525776 | 2020-09-12 | Lawrence | Kentucky | 21127 | 53 | 0 |
529012 | 529012 | 2020-09-13 | Lawrence | Kentucky | 21127 | 53 | 0 |
532249 | 532249 | 2020-09-14 | Lawrence | Kentucky | 21127 | 53 | 0 |
535484 | 535484 | 2020-09-15 | Lawrence | Kentucky | 21127 | 52 | 0 |
538721 | 538721 | 2020-09-16 | Lawrence | Kentucky | 21127 | 52 | 0 |
541957 | 541957 | 2020-09-17 | Lawrence | Kentucky | 21127 | 51 | 0 |
545193 | 545193 | 2020-09-18 | Lawrence | Kentucky | 21127 | 52 | 0 |
548431 | 548431 | 2020-09-19 | Lawrence | Kentucky | 21127 | 54 | 0 |
551670 | 551670 | 2020-09-20 | Lawrence | Kentucky | 21127 | 55 | 0 |
554909 | 554909 | 2020-09-21 | Lawrence | Kentucky | 21127 | 55 | 0 |
558146 | 558146 | 2020-09-22 | Lawrence | Kentucky | 21127 | 55 | 0 |
561382 | 561382 | 2020-09-23 | Lawrence | Kentucky | 21127 | 55 | 0 |
564622 | 564622 | 2020-09-24 | Lawrence | Kentucky | 21127 | 56 | 0 |
567862 | 567862 | 2020-09-25 | Lawrence | Kentucky | 21127 | 56 | 0 |
571104 | 571104 | 2020-09-26 | Lawrence | Kentucky | 21127 | 56 | 0 |
574347 | 574347 | 2020-09-27 | Lawrence | Kentucky | 21127 | 57 | 0 |
577589 | 577589 | 2020-09-28 | Lawrence | Kentucky | 21127 | 57 | 0 |
580830 | 580830 | 2020-09-29 | Lawrence | Kentucky | 21127 | 57 | 0 |
584070 | 584070 | 2020-09-30 | Lawrence | Kentucky | 21127 | 57 | 0 |
587310 | 587310 | 2020-10-01 | Lawrence | Kentucky | 21127 | 58 | 0 |
590551 | 590551 | 2020-10-02 | Lawrence | Kentucky | 21127 | 60 | 0 |
593792 | 593792 | 2020-10-03 | Lawrence | Kentucky | 21127 | 62 | 0 |
597034 | 597034 | 2020-10-04 | Lawrence | Kentucky | 21127 | 62 | 0 |
600276 | 600276 | 2020-10-05 | Lawrence | Kentucky | 21127 | 67 | 0 |
603519 | 603519 | 2020-10-06 | Lawrence | Kentucky | 21127 | 70 | 0 |
606761 | 606761 | 2020-10-07 | Lawrence | Kentucky | 21127 | 73 | 0 |
610003 | 610003 | 2020-10-08 | Lawrence | Kentucky | 21127 | 77 | 0 |
613245 | 613245 | 2020-10-09 | Lawrence | Kentucky | 21127 | 78 | 0 |
616486 | 616486 | 2020-10-10 | Lawrence | Kentucky | 21127 | 80 | 0 |
619728 | 619728 | 2020-10-11 | Lawrence | Kentucky | 21127 | 86 | 0 |
622972 | 622972 | 2020-10-12 | Lawrence | Kentucky | 21127 | 88 | 0 |
626214 | 626214 | 2020-10-13 | Lawrence | Kentucky | 21127 | 90 | 0 |
629458 | 629458 | 2020-10-14 | Lawrence | Kentucky | 21127 | 108 | 0 |
632702 | 632702 | 2020-10-15 | Lawrence | Kentucky | 21127 | 110 | 0 |
635948 | 635948 | 2020-10-16 | Lawrence | Kentucky | 21127 | 115 | 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);