ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Tangipahoa" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636057 | 636057 | 2020-10-16 | Tangipahoa | Louisiana | 22105 | 4859 | 122 |
632811 | 632811 | 2020-10-15 | Tangipahoa | Louisiana | 22105 | 4813 | 122 |
629567 | 629567 | 2020-10-14 | Tangipahoa | Louisiana | 22105 | 4822 | 122 |
626323 | 626323 | 2020-10-13 | Tangipahoa | Louisiana | 22105 | 4816 | 122 |
623081 | 623081 | 2020-10-12 | Tangipahoa | Louisiana | 22105 | 4807 | 122 |
619837 | 619837 | 2020-10-11 | Tangipahoa | Louisiana | 22105 | 4805 | 121 |
616595 | 616595 | 2020-10-10 | Tangipahoa | Louisiana | 22105 | 4784 | 121 |
613354 | 613354 | 2020-10-09 | Tangipahoa | Louisiana | 22105 | 4784 | 121 |
610112 | 610112 | 2020-10-08 | Tangipahoa | Louisiana | 22105 | 4771 | 121 |
606870 | 606870 | 2020-10-07 | Tangipahoa | Louisiana | 22105 | 4764 | 121 |
603628 | 603628 | 2020-10-06 | Tangipahoa | Louisiana | 22105 | 4568 | 120 |
600385 | 600385 | 2020-10-05 | Tangipahoa | Louisiana | 22105 | 4570 | 120 |
597143 | 597143 | 2020-10-04 | Tangipahoa | Louisiana | 22105 | 4575 | 120 |
593901 | 593901 | 2020-10-03 | Tangipahoa | Louisiana | 22105 | 4538 | 120 |
590660 | 590660 | 2020-10-02 | Tangipahoa | Louisiana | 22105 | 4538 | 120 |
587419 | 587419 | 2020-10-01 | Tangipahoa | Louisiana | 22105 | 4531 | 120 |
584179 | 584179 | 2020-09-30 | Tangipahoa | Louisiana | 22105 | 4514 | 119 |
580939 | 580939 | 2020-09-29 | Tangipahoa | Louisiana | 22105 | 4491 | 119 |
577698 | 577698 | 2020-09-28 | Tangipahoa | Louisiana | 22105 | 4475 | 119 |
574456 | 574456 | 2020-09-27 | Tangipahoa | Louisiana | 22105 | 4471 | 119 |
571213 | 571213 | 2020-09-26 | Tangipahoa | Louisiana | 22105 | 4441 | 118 |
567971 | 567971 | 2020-09-25 | Tangipahoa | Louisiana | 22105 | 4441 | 118 |
564731 | 564731 | 2020-09-24 | Tangipahoa | Louisiana | 22105 | 4435 | 118 |
561491 | 561491 | 2020-09-23 | Tangipahoa | Louisiana | 22105 | 4416 | 117 |
558255 | 558255 | 2020-09-22 | Tangipahoa | Louisiana | 22105 | 4394 | 117 |
555018 | 555018 | 2020-09-21 | Tangipahoa | Louisiana | 22105 | 4385 | 117 |
551779 | 551779 | 2020-09-20 | Tangipahoa | Louisiana | 22105 | 4376 | 117 |
548540 | 548540 | 2020-09-19 | Tangipahoa | Louisiana | 22105 | 4365 | 116 |
545302 | 545302 | 2020-09-18 | Tangipahoa | Louisiana | 22105 | 4365 | 116 |
542066 | 542066 | 2020-09-17 | Tangipahoa | Louisiana | 22105 | 4323 | 115 |
538830 | 538830 | 2020-09-16 | Tangipahoa | Louisiana | 22105 | 4323 | 113 |
535593 | 535593 | 2020-09-15 | Tangipahoa | Louisiana | 22105 | 4307 | 111 |
532358 | 532358 | 2020-09-14 | Tangipahoa | Louisiana | 22105 | 4292 | 111 |
529121 | 529121 | 2020-09-13 | Tangipahoa | Louisiana | 22105 | 4278 | 109 |
525885 | 525885 | 2020-09-12 | Tangipahoa | Louisiana | 22105 | 4255 | 108 |
522649 | 522649 | 2020-09-11 | Tangipahoa | Louisiana | 22105 | 4255 | 108 |
519412 | 519412 | 2020-09-10 | Tangipahoa | Louisiana | 22105 | 4239 | 107 |
516177 | 516177 | 2020-09-09 | Tangipahoa | Louisiana | 22105 | 4217 | 107 |
512944 | 512944 | 2020-09-08 | Tangipahoa | Louisiana | 22105 | 4173 | 107 |
509712 | 509712 | 2020-09-07 | Tangipahoa | Louisiana | 22105 | 4181 | 107 |
506479 | 506479 | 2020-09-06 | Tangipahoa | Louisiana | 22105 | 4168 | 107 |
503245 | 503245 | 2020-09-05 | Tangipahoa | Louisiana | 22105 | 4134 | 104 |
500012 | 500012 | 2020-09-04 | Tangipahoa | Louisiana | 22105 | 4134 | 104 |
496778 | 496778 | 2020-09-03 | Tangipahoa | Louisiana | 22105 | 4098 | 103 |
493545 | 493545 | 2020-09-02 | Tangipahoa | Louisiana | 22105 | 4095 | 102 |
490311 | 490311 | 2020-09-01 | Tangipahoa | Louisiana | 22105 | 4071 | 98 |
487078 | 487078 | 2020-08-31 | Tangipahoa | Louisiana | 22105 | 4046 | 98 |
483843 | 483843 | 2020-08-30 | Tangipahoa | Louisiana | 22105 | 4030 | 97 |
480609 | 480609 | 2020-08-29 | Tangipahoa | Louisiana | 22105 | 3985 | 94 |
477376 | 477376 | 2020-08-28 | Tangipahoa | Louisiana | 22105 | 3985 | 94 |
474143 | 474143 | 2020-08-27 | Tangipahoa | Louisiana | 22105 | 3965 | 91 |
470911 | 470911 | 2020-08-26 | Tangipahoa | Louisiana | 22105 | 3956 | 90 |
467682 | 467682 | 2020-08-25 | Tangipahoa | Louisiana | 22105 | 3939 | 90 |
464453 | 464453 | 2020-08-24 | Tangipahoa | Louisiana | 22105 | 3959 | 88 |
461222 | 461222 | 2020-08-23 | Tangipahoa | Louisiana | 22105 | 3934 | 88 |
457995 | 457995 | 2020-08-22 | Tangipahoa | Louisiana | 22105 | 3899 | 88 |
454767 | 454767 | 2020-08-21 | Tangipahoa | Louisiana | 22105 | 3899 | 88 |
451539 | 451539 | 2020-08-20 | Tangipahoa | Louisiana | 22105 | 3868 | 87 |
448311 | 448311 | 2020-08-19 | Tangipahoa | Louisiana | 22105 | 3826 | 87 |
445084 | 445084 | 2020-08-18 | Tangipahoa | Louisiana | 22105 | 3798 | 85 |
441858 | 441858 | 2020-08-17 | Tangipahoa | Louisiana | 22105 | 3756 | 83 |
438631 | 438631 | 2020-08-16 | Tangipahoa | Louisiana | 22105 | 3710 | 83 |
435406 | 435406 | 2020-08-15 | Tangipahoa | Louisiana | 22105 | 3664 | 80 |
432181 | 432181 | 2020-08-14 | Tangipahoa | Louisiana | 22105 | 3664 | 80 |
428953 | 428953 | 2020-08-13 | Tangipahoa | Louisiana | 22105 | 3619 | 78 |
425729 | 425729 | 2020-08-12 | Tangipahoa | Louisiana | 22105 | 3570 | 78 |
422508 | 422508 | 2020-08-11 | Tangipahoa | Louisiana | 22105 | 3540 | 78 |
419286 | 419286 | 2020-08-10 | Tangipahoa | Louisiana | 22105 | 3498 | 77 |
416065 | 416065 | 2020-08-09 | Tangipahoa | Louisiana | 22105 | 3477 | 75 |
412845 | 412845 | 2020-08-08 | Tangipahoa | Louisiana | 22105 | 3397 | 72 |
409625 | 409625 | 2020-08-07 | Tangipahoa | Louisiana | 22105 | 3397 | 72 |
406405 | 406405 | 2020-08-06 | Tangipahoa | Louisiana | 22105 | 3332 | 69 |
403187 | 403187 | 2020-08-05 | Tangipahoa | Louisiana | 22105 | 3291 | 69 |
399970 | 399970 | 2020-08-04 | Tangipahoa | Louisiana | 22105 | 3223 | 63 |
396755 | 396755 | 2020-08-03 | Tangipahoa | Louisiana | 22105 | 3159 | 63 |
393539 | 393539 | 2020-08-02 | Tangipahoa | Louisiana | 22105 | 3137 | 63 |
390322 | 390322 | 2020-08-01 | Tangipahoa | Louisiana | 22105 | 3037 | 62 |
387105 | 387105 | 2020-07-31 | Tangipahoa | Louisiana | 22105 | 3037 | 62 |
383887 | 383887 | 2020-07-30 | Tangipahoa | Louisiana | 22105 | 3001 | 61 |
380670 | 380670 | 2020-07-29 | Tangipahoa | Louisiana | 22105 | 2955 | 58 |
377453 | 377453 | 2020-07-28 | Tangipahoa | Louisiana | 22105 | 2916 | 58 |
374238 | 374238 | 2020-07-27 | Tangipahoa | Louisiana | 22105 | 2895 | 56 |
371026 | 371026 | 2020-07-26 | Tangipahoa | Louisiana | 22105 | 2777 | 56 |
367816 | 367816 | 2020-07-25 | Tangipahoa | Louisiana | 22105 | 2692 | 54 |
364609 | 364609 | 2020-07-24 | Tangipahoa | Louisiana | 22105 | 2692 | 54 |
361402 | 361402 | 2020-07-23 | Tangipahoa | Louisiana | 22105 | 2624 | 53 |
358197 | 358197 | 2020-07-22 | Tangipahoa | Louisiana | 22105 | 2536 | 53 |
354994 | 354994 | 2020-07-21 | Tangipahoa | Louisiana | 22105 | 2464 | 47 |
351792 | 351792 | 2020-07-20 | Tangipahoa | Louisiana | 22105 | 2447 | 47 |
348592 | 348592 | 2020-07-19 | Tangipahoa | Louisiana | 22105 | 2300 | 47 |
345391 | 345391 | 2020-07-18 | Tangipahoa | Louisiana | 22105 | 2217 | 46 |
342191 | 342191 | 2020-07-17 | Tangipahoa | Louisiana | 22105 | 2217 | 46 |
338995 | 338995 | 2020-07-16 | Tangipahoa | Louisiana | 22105 | 2142 | 46 |
335799 | 335799 | 2020-07-15 | Tangipahoa | Louisiana | 22105 | 2081 | 45 |
332606 | 332606 | 2020-07-14 | Tangipahoa | Louisiana | 22105 | 2020 | 44 |
329419 | 329419 | 2020-07-13 | Tangipahoa | Louisiana | 22105 | 1914 | 44 |
326233 | 326233 | 2020-07-12 | Tangipahoa | Louisiana | 22105 | 1894 | 44 |
323050 | 323050 | 2020-07-11 | Tangipahoa | Louisiana | 22105 | 1874 | 44 |
319871 | 319871 | 2020-07-10 | Tangipahoa | Louisiana | 22105 | 1802 | 44 |
316696 | 316696 | 2020-07-09 | Tangipahoa | Louisiana | 22105 | 1742 | 43 |
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);