ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Calcasieu" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636014 | 636014 | 2020-10-16 | Calcasieu | Louisiana | 22019 | 8138 | 221 |
632768 | 632768 | 2020-10-15 | Calcasieu | Louisiana | 22019 | 8106 | 221 |
629524 | 629524 | 2020-10-14 | Calcasieu | Louisiana | 22019 | 8095 | 221 |
626280 | 626280 | 2020-10-13 | Calcasieu | Louisiana | 22019 | 8068 | 221 |
623038 | 623038 | 2020-10-12 | Calcasieu | Louisiana | 22019 | 8044 | 220 |
619794 | 619794 | 2020-10-11 | Calcasieu | Louisiana | 22019 | 8044 | 220 |
616552 | 616552 | 2020-10-10 | Calcasieu | Louisiana | 22019 | 8028 | 219 |
613311 | 613311 | 2020-10-09 | Calcasieu | Louisiana | 22019 | 8028 | 219 |
610069 | 610069 | 2020-10-08 | Calcasieu | Louisiana | 22019 | 8005 | 217 |
606827 | 606827 | 2020-10-07 | Calcasieu | Louisiana | 22019 | 7986 | 217 |
603585 | 603585 | 2020-10-06 | Calcasieu | Louisiana | 22019 | 7954 | 217 |
600342 | 600342 | 2020-10-05 | Calcasieu | Louisiana | 22019 | 7947 | 217 |
597100 | 597100 | 2020-10-04 | Calcasieu | Louisiana | 22019 | 7947 | 217 |
593858 | 593858 | 2020-10-03 | Calcasieu | Louisiana | 22019 | 7907 | 213 |
590617 | 590617 | 2020-10-02 | Calcasieu | Louisiana | 22019 | 7907 | 213 |
587376 | 587376 | 2020-10-01 | Calcasieu | Louisiana | 22019 | 7899 | 213 |
584136 | 584136 | 2020-09-30 | Calcasieu | Louisiana | 22019 | 7892 | 212 |
580896 | 580896 | 2020-09-29 | Calcasieu | Louisiana | 22019 | 7869 | 212 |
577655 | 577655 | 2020-09-28 | Calcasieu | Louisiana | 22019 | 7854 | 212 |
574413 | 574413 | 2020-09-27 | Calcasieu | Louisiana | 22019 | 7856 | 212 |
571170 | 571170 | 2020-09-26 | Calcasieu | Louisiana | 22019 | 7831 | 210 |
567928 | 567928 | 2020-09-25 | Calcasieu | Louisiana | 22019 | 7831 | 210 |
564688 | 564688 | 2020-09-24 | Calcasieu | Louisiana | 22019 | 7812 | 210 |
561448 | 561448 | 2020-09-23 | Calcasieu | Louisiana | 22019 | 7794 | 210 |
558212 | 558212 | 2020-09-22 | Calcasieu | Louisiana | 22019 | 7773 | 210 |
554975 | 554975 | 2020-09-21 | Calcasieu | Louisiana | 22019 | 7745 | 209 |
551736 | 551736 | 2020-09-20 | Calcasieu | Louisiana | 22019 | 7744 | 209 |
548497 | 548497 | 2020-09-19 | Calcasieu | Louisiana | 22019 | 7708 | 207 |
545259 | 545259 | 2020-09-18 | Calcasieu | Louisiana | 22019 | 7708 | 207 |
542023 | 542023 | 2020-09-17 | Calcasieu | Louisiana | 22019 | 7698 | 206 |
538787 | 538787 | 2020-09-16 | Calcasieu | Louisiana | 22019 | 7645 | 205 |
535550 | 535550 | 2020-09-15 | Calcasieu | Louisiana | 22019 | 7632 | 203 |
532315 | 532315 | 2020-09-14 | Calcasieu | Louisiana | 22019 | 7632 | 202 |
529078 | 529078 | 2020-09-13 | Calcasieu | Louisiana | 22019 | 7623 | 200 |
525842 | 525842 | 2020-09-12 | Calcasieu | Louisiana | 22019 | 7592 | 198 |
522606 | 522606 | 2020-09-11 | Calcasieu | Louisiana | 22019 | 7592 | 198 |
519369 | 519369 | 2020-09-10 | Calcasieu | Louisiana | 22019 | 7580 | 197 |
516134 | 516134 | 2020-09-09 | Calcasieu | Louisiana | 22019 | 7549 | 196 |
512901 | 512901 | 2020-09-08 | Calcasieu | Louisiana | 22019 | 7487 | 194 |
509669 | 509669 | 2020-09-07 | Calcasieu | Louisiana | 22019 | 7476 | 194 |
506436 | 506436 | 2020-09-06 | Calcasieu | Louisiana | 22019 | 7474 | 194 |
503202 | 503202 | 2020-09-05 | Calcasieu | Louisiana | 22019 | 7465 | 193 |
499969 | 499969 | 2020-09-04 | Calcasieu | Louisiana | 22019 | 7465 | 193 |
496735 | 496735 | 2020-09-03 | Calcasieu | Louisiana | 22019 | 7438 | 192 |
493502 | 493502 | 2020-09-02 | Calcasieu | Louisiana | 22019 | 7442 | 192 |
490268 | 490268 | 2020-09-01 | Calcasieu | Louisiana | 22019 | 7445 | 190 |
487035 | 487035 | 2020-08-31 | Calcasieu | Louisiana | 22019 | 7441 | 182 |
483800 | 483800 | 2020-08-30 | Calcasieu | Louisiana | 22019 | 7439 | 182 |
480566 | 480566 | 2020-08-29 | Calcasieu | Louisiana | 22019 | 7298 | 182 |
477333 | 477333 | 2020-08-28 | Calcasieu | Louisiana | 22019 | 7298 | 182 |
474100 | 474100 | 2020-08-27 | Calcasieu | Louisiana | 22019 | 7285 | 181 |
470868 | 470868 | 2020-08-26 | Calcasieu | Louisiana | 22019 | 7269 | 179 |
467639 | 467639 | 2020-08-25 | Calcasieu | Louisiana | 22019 | 7256 | 178 |
464410 | 464410 | 2020-08-24 | Calcasieu | Louisiana | 22019 | 7284 | 178 |
461179 | 461179 | 2020-08-23 | Calcasieu | Louisiana | 22019 | 7277 | 178 |
457952 | 457952 | 2020-08-22 | Calcasieu | Louisiana | 22019 | 7235 | 166 |
454724 | 454724 | 2020-08-21 | Calcasieu | Louisiana | 22019 | 7235 | 166 |
451496 | 451496 | 2020-08-20 | Calcasieu | Louisiana | 22019 | 7194 | 160 |
448268 | 448268 | 2020-08-19 | Calcasieu | Louisiana | 22019 | 7154 | 158 |
445041 | 445041 | 2020-08-18 | Calcasieu | Louisiana | 22019 | 7093 | 157 |
441815 | 441815 | 2020-08-17 | Calcasieu | Louisiana | 22019 | 7045 | 157 |
438588 | 438588 | 2020-08-16 | Calcasieu | Louisiana | 22019 | 7044 | 156 |
435363 | 435363 | 2020-08-15 | Calcasieu | Louisiana | 22019 | 7013 | 154 |
432138 | 432138 | 2020-08-14 | Calcasieu | Louisiana | 22019 | 7013 | 154 |
428910 | 428910 | 2020-08-13 | Calcasieu | Louisiana | 22019 | 6960 | 154 |
425686 | 425686 | 2020-08-12 | Calcasieu | Louisiana | 22019 | 6924 | 147 |
422465 | 422465 | 2020-08-11 | Calcasieu | Louisiana | 22019 | 6862 | 146 |
419243 | 419243 | 2020-08-10 | Calcasieu | Louisiana | 22019 | 6815 | 146 |
416022 | 416022 | 2020-08-09 | Calcasieu | Louisiana | 22019 | 6815 | 146 |
412802 | 412802 | 2020-08-08 | Calcasieu | Louisiana | 22019 | 6752 | 146 |
409582 | 409582 | 2020-08-07 | Calcasieu | Louisiana | 22019 | 6752 | 146 |
406362 | 406362 | 2020-08-06 | Calcasieu | Louisiana | 22019 | 6695 | 130 |
403144 | 403144 | 2020-08-05 | Calcasieu | Louisiana | 22019 | 6641 | 127 |
399927 | 399927 | 2020-08-04 | Calcasieu | Louisiana | 22019 | 6594 | 127 |
396712 | 396712 | 2020-08-03 | Calcasieu | Louisiana | 22019 | 6527 | 127 |
393496 | 393496 | 2020-08-02 | Calcasieu | Louisiana | 22019 | 6440 | 127 |
390279 | 390279 | 2020-08-01 | Calcasieu | Louisiana | 22019 | 6278 | 121 |
387062 | 387062 | 2020-07-31 | Calcasieu | Louisiana | 22019 | 6278 | 121 |
383844 | 383844 | 2020-07-30 | Calcasieu | Louisiana | 22019 | 5913 | 117 |
380627 | 380627 | 2020-07-29 | Calcasieu | Louisiana | 22019 | 5810 | 116 |
377410 | 377410 | 2020-07-28 | Calcasieu | Louisiana | 22019 | 5709 | 107 |
374195 | 374195 | 2020-07-27 | Calcasieu | Louisiana | 22019 | 5626 | 107 |
370983 | 370983 | 2020-07-26 | Calcasieu | Louisiana | 22019 | 5459 | 96 |
367773 | 367773 | 2020-07-25 | Calcasieu | Louisiana | 22019 | 5127 | 92 |
364566 | 364566 | 2020-07-24 | Calcasieu | Louisiana | 22019 | 5127 | 92 |
361359 | 361359 | 2020-07-23 | Calcasieu | Louisiana | 22019 | 4995 | 92 |
358154 | 358154 | 2020-07-22 | Calcasieu | Louisiana | 22019 | 4742 | 92 |
354951 | 354951 | 2020-07-21 | Calcasieu | Louisiana | 22019 | 4578 | 91 |
351749 | 351749 | 2020-07-20 | Calcasieu | Louisiana | 22019 | 4481 | 84 |
348549 | 348549 | 2020-07-19 | Calcasieu | Louisiana | 22019 | 4231 | 80 |
345348 | 345348 | 2020-07-18 | Calcasieu | Louisiana | 22019 | 4028 | 75 |
342148 | 342148 | 2020-07-17 | Calcasieu | Louisiana | 22019 | 4028 | 75 |
338952 | 338952 | 2020-07-16 | Calcasieu | Louisiana | 22019 | 3864 | 75 |
335756 | 335756 | 2020-07-15 | Calcasieu | Louisiana | 22019 | 3705 | 74 |
332563 | 332563 | 2020-07-14 | Calcasieu | Louisiana | 22019 | 3435 | 72 |
329376 | 329376 | 2020-07-13 | Calcasieu | Louisiana | 22019 | 3236 | 71 |
326190 | 326190 | 2020-07-12 | Calcasieu | Louisiana | 22019 | 3127 | 71 |
323007 | 323007 | 2020-07-11 | Calcasieu | Louisiana | 22019 | 3061 | 70 |
319828 | 319828 | 2020-07-10 | Calcasieu | Louisiana | 22019 | 2975 | 63 |
316653 | 316653 | 2020-07-09 | Calcasieu | Louisiana | 22019 | 2797 | 63 |
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);