ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "St. Martin" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636054 | 636054 | 2020-10-16 | St. Martin | Louisiana | 22099 | 2152 | 61 |
632808 | 632808 | 2020-10-15 | St. Martin | Louisiana | 22099 | 2142 | 61 |
629564 | 629564 | 2020-10-14 | St. Martin | Louisiana | 22099 | 2149 | 61 |
626320 | 626320 | 2020-10-13 | St. Martin | Louisiana | 22099 | 2140 | 61 |
623078 | 623078 | 2020-10-12 | St. Martin | Louisiana | 22099 | 2131 | 61 |
619834 | 619834 | 2020-10-11 | St. Martin | Louisiana | 22099 | 2145 | 61 |
616592 | 616592 | 2020-10-10 | St. Martin | Louisiana | 22099 | 2132 | 61 |
613351 | 613351 | 2020-10-09 | St. Martin | Louisiana | 22099 | 2132 | 61 |
610109 | 610109 | 2020-10-08 | St. Martin | Louisiana | 22099 | 2131 | 61 |
606867 | 606867 | 2020-10-07 | St. Martin | Louisiana | 22099 | 2119 | 61 |
603625 | 603625 | 2020-10-06 | St. Martin | Louisiana | 22099 | 2124 | 61 |
600382 | 600382 | 2020-10-05 | St. Martin | Louisiana | 22099 | 2116 | 61 |
597140 | 597140 | 2020-10-04 | St. Martin | Louisiana | 22099 | 2126 | 61 |
593898 | 593898 | 2020-10-03 | St. Martin | Louisiana | 22099 | 2102 | 61 |
590657 | 590657 | 2020-10-02 | St. Martin | Louisiana | 22099 | 2102 | 61 |
587416 | 587416 | 2020-10-01 | St. Martin | Louisiana | 22099 | 2103 | 61 |
584176 | 584176 | 2020-09-30 | St. Martin | Louisiana | 22099 | 2106 | 61 |
580936 | 580936 | 2020-09-29 | St. Martin | Louisiana | 22099 | 2103 | 61 |
577695 | 577695 | 2020-09-28 | St. Martin | Louisiana | 22099 | 2095 | 61 |
574453 | 574453 | 2020-09-27 | St. Martin | Louisiana | 22099 | 2094 | 61 |
571210 | 571210 | 2020-09-26 | St. Martin | Louisiana | 22099 | 2094 | 61 |
567968 | 567968 | 2020-09-25 | St. Martin | Louisiana | 22099 | 2094 | 61 |
564728 | 564728 | 2020-09-24 | St. Martin | Louisiana | 22099 | 2091 | 60 |
561488 | 561488 | 2020-09-23 | St. Martin | Louisiana | 22099 | 2081 | 60 |
558252 | 558252 | 2020-09-22 | St. Martin | Louisiana | 22099 | 2073 | 61 |
555015 | 555015 | 2020-09-21 | St. Martin | Louisiana | 22099 | 2058 | 61 |
551776 | 551776 | 2020-09-20 | St. Martin | Louisiana | 22099 | 2056 | 60 |
548537 | 548537 | 2020-09-19 | St. Martin | Louisiana | 22099 | 2062 | 60 |
545299 | 545299 | 2020-09-18 | St. Martin | Louisiana | 22099 | 2062 | 60 |
542063 | 542063 | 2020-09-17 | St. Martin | Louisiana | 22099 | 2059 | 60 |
538827 | 538827 | 2020-09-16 | St. Martin | Louisiana | 22099 | 2053 | 60 |
535590 | 535590 | 2020-09-15 | St. Martin | Louisiana | 22099 | 2051 | 59 |
532355 | 532355 | 2020-09-14 | St. Martin | Louisiana | 22099 | 2042 | 59 |
529118 | 529118 | 2020-09-13 | St. Martin | Louisiana | 22099 | 2046 | 58 |
525882 | 525882 | 2020-09-12 | St. Martin | Louisiana | 22099 | 2037 | 58 |
522646 | 522646 | 2020-09-11 | St. Martin | Louisiana | 22099 | 2037 | 58 |
519409 | 519409 | 2020-09-10 | St. Martin | Louisiana | 22099 | 2034 | 58 |
516174 | 516174 | 2020-09-09 | St. Martin | Louisiana | 22099 | 2030 | 58 |
512941 | 512941 | 2020-09-08 | St. Martin | Louisiana | 22099 | 2010 | 58 |
509709 | 509709 | 2020-09-07 | St. Martin | Louisiana | 22099 | 2005 | 58 |
506476 | 506476 | 2020-09-06 | St. Martin | Louisiana | 22099 | 1999 | 58 |
503242 | 503242 | 2020-09-05 | St. Martin | Louisiana | 22099 | 1996 | 57 |
500009 | 500009 | 2020-09-04 | St. Martin | Louisiana | 22099 | 1996 | 57 |
496775 | 496775 | 2020-09-03 | St. Martin | Louisiana | 22099 | 1983 | 57 |
493542 | 493542 | 2020-09-02 | St. Martin | Louisiana | 22099 | 1982 | 57 |
490308 | 490308 | 2020-09-01 | St. Martin | Louisiana | 22099 | 1975 | 57 |
487075 | 487075 | 2020-08-31 | St. Martin | Louisiana | 22099 | 1962 | 56 |
483840 | 483840 | 2020-08-30 | St. Martin | Louisiana | 22099 | 1964 | 56 |
480606 | 480606 | 2020-08-29 | St. Martin | Louisiana | 22099 | 1930 | 56 |
477373 | 477373 | 2020-08-28 | St. Martin | Louisiana | 22099 | 1930 | 56 |
474140 | 474140 | 2020-08-27 | St. Martin | Louisiana | 22099 | 1922 | 55 |
470908 | 470908 | 2020-08-26 | St. Martin | Louisiana | 22099 | 1920 | 55 |
467679 | 467679 | 2020-08-25 | St. Martin | Louisiana | 22099 | 1928 | 54 |
464450 | 464450 | 2020-08-24 | St. Martin | Louisiana | 22099 | 1839 | 51 |
461219 | 461219 | 2020-08-23 | St. Martin | Louisiana | 22099 | 1836 | 51 |
457992 | 457992 | 2020-08-22 | St. Martin | Louisiana | 22099 | 1827 | 50 |
454764 | 454764 | 2020-08-21 | St. Martin | Louisiana | 22099 | 1827 | 50 |
451536 | 451536 | 2020-08-20 | St. Martin | Louisiana | 22099 | 1809 | 49 |
448308 | 448308 | 2020-08-19 | St. Martin | Louisiana | 22099 | 1803 | 49 |
445081 | 445081 | 2020-08-18 | St. Martin | Louisiana | 22099 | 1795 | 49 |
441855 | 441855 | 2020-08-17 | St. Martin | Louisiana | 22099 | 1790 | 48 |
438628 | 438628 | 2020-08-16 | St. Martin | Louisiana | 22099 | 1783 | 47 |
435403 | 435403 | 2020-08-15 | St. Martin | Louisiana | 22099 | 1784 | 47 |
432178 | 432178 | 2020-08-14 | St. Martin | Louisiana | 22099 | 1784 | 47 |
428950 | 428950 | 2020-08-13 | St. Martin | Louisiana | 22099 | 1760 | 46 |
425726 | 425726 | 2020-08-12 | St. Martin | Louisiana | 22099 | 1757 | 46 |
422505 | 422505 | 2020-08-11 | St. Martin | Louisiana | 22099 | 1734 | 46 |
419283 | 419283 | 2020-08-10 | St. Martin | Louisiana | 22099 | 1714 | 46 |
416062 | 416062 | 2020-08-09 | St. Martin | Louisiana | 22099 | 1711 | 45 |
412842 | 412842 | 2020-08-08 | St. Martin | Louisiana | 22099 | 1616 | 43 |
409622 | 409622 | 2020-08-07 | St. Martin | Louisiana | 22099 | 1616 | 43 |
406402 | 406402 | 2020-08-06 | St. Martin | Louisiana | 22099 | 1609 | 43 |
403184 | 403184 | 2020-08-05 | St. Martin | Louisiana | 22099 | 1590 | 43 |
399967 | 399967 | 2020-08-04 | St. Martin | Louisiana | 22099 | 1580 | 42 |
396752 | 396752 | 2020-08-03 | St. Martin | Louisiana | 22099 | 1519 | 42 |
393536 | 393536 | 2020-08-02 | St. Martin | Louisiana | 22099 | 1501 | 42 |
390319 | 390319 | 2020-08-01 | St. Martin | Louisiana | 22099 | 1468 | 42 |
387102 | 387102 | 2020-07-31 | St. Martin | Louisiana | 22099 | 1468 | 42 |
383884 | 383884 | 2020-07-30 | St. Martin | Louisiana | 22099 | 1461 | 43 |
380667 | 380667 | 2020-07-29 | St. Martin | Louisiana | 22099 | 1453 | 40 |
377450 | 377450 | 2020-07-28 | St. Martin | Louisiana | 22099 | 1442 | 37 |
374235 | 374235 | 2020-07-27 | St. Martin | Louisiana | 22099 | 1429 | 36 |
371023 | 371023 | 2020-07-26 | St. Martin | Louisiana | 22099 | 1399 | 36 |
367813 | 367813 | 2020-07-25 | St. Martin | Louisiana | 22099 | 1358 | 34 |
364606 | 364606 | 2020-07-24 | St. Martin | Louisiana | 22099 | 1358 | 34 |
361399 | 361399 | 2020-07-23 | St. Martin | Louisiana | 22099 | 1353 | 34 |
358194 | 358194 | 2020-07-22 | St. Martin | Louisiana | 22099 | 1333 | 32 |
354991 | 354991 | 2020-07-21 | St. Martin | Louisiana | 22099 | 1287 | 31 |
351789 | 351789 | 2020-07-20 | St. Martin | Louisiana | 22099 | 1254 | 30 |
348589 | 348589 | 2020-07-19 | St. Martin | Louisiana | 22099 | 1210 | 31 |
345388 | 345388 | 2020-07-18 | St. Martin | Louisiana | 22099 | 1176 | 30 |
342188 | 342188 | 2020-07-17 | St. Martin | Louisiana | 22099 | 1176 | 30 |
338992 | 338992 | 2020-07-16 | St. Martin | Louisiana | 22099 | 1149 | 30 |
335796 | 335796 | 2020-07-15 | St. Martin | Louisiana | 22099 | 1129 | 29 |
332603 | 332603 | 2020-07-14 | St. Martin | Louisiana | 22099 | 1110 | 29 |
329416 | 329416 | 2020-07-13 | St. Martin | Louisiana | 22099 | 1050 | 27 |
326230 | 326230 | 2020-07-12 | St. Martin | Louisiana | 22099 | 1021 | 27 |
323047 | 323047 | 2020-07-11 | St. Martin | Louisiana | 22099 | 999 | 27 |
319868 | 319868 | 2020-07-10 | St. Martin | Louisiana | 22099 | 963 | 27 |
316693 | 316693 | 2020-07-09 | St. Martin | Louisiana | 22099 | 939 | 27 |
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);