ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 22023 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636016 | 636016 | 2020-10-16 | Cameron | Louisiana | 22023 | 234 | 2 |
632770 | 632770 | 2020-10-15 | Cameron | Louisiana | 22023 | 236 | 2 |
629526 | 629526 | 2020-10-14 | Cameron | Louisiana | 22023 | 236 | 2 |
626282 | 626282 | 2020-10-13 | Cameron | Louisiana | 22023 | 231 | 2 |
623040 | 623040 | 2020-10-12 | Cameron | Louisiana | 22023 | 232 | 2 |
619796 | 619796 | 2020-10-11 | Cameron | Louisiana | 22023 | 229 | 2 |
616554 | 616554 | 2020-10-10 | Cameron | Louisiana | 22023 | 227 | 2 |
613313 | 613313 | 2020-10-09 | Cameron | Louisiana | 22023 | 227 | 2 |
610071 | 610071 | 2020-10-08 | Cameron | Louisiana | 22023 | 231 | 2 |
606829 | 606829 | 2020-10-07 | Cameron | Louisiana | 22023 | 235 | 2 |
603587 | 603587 | 2020-10-06 | Cameron | Louisiana | 22023 | 228 | 2 |
600344 | 600344 | 2020-10-05 | Cameron | Louisiana | 22023 | 230 | 2 |
597102 | 597102 | 2020-10-04 | Cameron | Louisiana | 22023 | 226 | 2 |
593860 | 593860 | 2020-10-03 | Cameron | Louisiana | 22023 | 231 | 2 |
590619 | 590619 | 2020-10-02 | Cameron | Louisiana | 22023 | 231 | 2 |
587378 | 587378 | 2020-10-01 | Cameron | Louisiana | 22023 | 227 | 2 |
584138 | 584138 | 2020-09-30 | Cameron | Louisiana | 22023 | 225 | 2 |
580898 | 580898 | 2020-09-29 | Cameron | Louisiana | 22023 | 225 | 2 |
577657 | 577657 | 2020-09-28 | Cameron | Louisiana | 22023 | 225 | 2 |
574415 | 574415 | 2020-09-27 | Cameron | Louisiana | 22023 | 224 | 2 |
571172 | 571172 | 2020-09-26 | Cameron | Louisiana | 22023 | 226 | 2 |
567930 | 567930 | 2020-09-25 | Cameron | Louisiana | 22023 | 226 | 2 |
564690 | 564690 | 2020-09-24 | Cameron | Louisiana | 22023 | 226 | 2 |
561450 | 561450 | 2020-09-23 | Cameron | Louisiana | 22023 | 225 | 2 |
558214 | 558214 | 2020-09-22 | Cameron | Louisiana | 22023 | 222 | 2 |
554977 | 554977 | 2020-09-21 | Cameron | Louisiana | 22023 | 223 | 2 |
551738 | 551738 | 2020-09-20 | Cameron | Louisiana | 22023 | 221 | 2 |
548499 | 548499 | 2020-09-19 | Cameron | Louisiana | 22023 | 220 | 2 |
545261 | 545261 | 2020-09-18 | Cameron | Louisiana | 22023 | 220 | 2 |
542025 | 542025 | 2020-09-17 | Cameron | Louisiana | 22023 | 218 | 2 |
538789 | 538789 | 2020-09-16 | Cameron | Louisiana | 22023 | 217 | 1 |
535552 | 535552 | 2020-09-15 | Cameron | Louisiana | 22023 | 216 | 1 |
532317 | 532317 | 2020-09-14 | Cameron | Louisiana | 22023 | 209 | 1 |
529080 | 529080 | 2020-09-13 | Cameron | Louisiana | 22023 | 208 | 1 |
525844 | 525844 | 2020-09-12 | Cameron | Louisiana | 22023 | 209 | 1 |
522608 | 522608 | 2020-09-11 | Cameron | Louisiana | 22023 | 209 | 1 |
519371 | 519371 | 2020-09-10 | Cameron | Louisiana | 22023 | 206 | 1 |
516136 | 516136 | 2020-09-09 | Cameron | Louisiana | 22023 | 205 | 1 |
512903 | 512903 | 2020-09-08 | Cameron | Louisiana | 22023 | 204 | 1 |
509671 | 509671 | 2020-09-07 | Cameron | Louisiana | 22023 | 204 | 1 |
506438 | 506438 | 2020-09-06 | Cameron | Louisiana | 22023 | 207 | 1 |
503204 | 503204 | 2020-09-05 | Cameron | Louisiana | 22023 | 206 | 1 |
499971 | 499971 | 2020-09-04 | Cameron | Louisiana | 22023 | 206 | 1 |
496737 | 496737 | 2020-09-03 | Cameron | Louisiana | 22023 | 209 | 1 |
493504 | 493504 | 2020-09-02 | Cameron | Louisiana | 22023 | 206 | 1 |
490270 | 490270 | 2020-09-01 | Cameron | Louisiana | 22023 | 208 | 1 |
487037 | 487037 | 2020-08-31 | Cameron | Louisiana | 22023 | 202 | 1 |
483802 | 483802 | 2020-08-30 | Cameron | Louisiana | 22023 | 203 | 1 |
480568 | 480568 | 2020-08-29 | Cameron | Louisiana | 22023 | 206 | 1 |
477335 | 477335 | 2020-08-28 | Cameron | Louisiana | 22023 | 206 | 1 |
474102 | 474102 | 2020-08-27 | Cameron | Louisiana | 22023 | 204 | 1 |
470870 | 470870 | 2020-08-26 | Cameron | Louisiana | 22023 | 205 | 1 |
467641 | 467641 | 2020-08-25 | Cameron | Louisiana | 22023 | 201 | 1 |
464412 | 464412 | 2020-08-24 | Cameron | Louisiana | 22023 | 175 | 1 |
461181 | 461181 | 2020-08-23 | Cameron | Louisiana | 22023 | 174 | 1 |
457954 | 457954 | 2020-08-22 | Cameron | Louisiana | 22023 | 174 | 1 |
454726 | 454726 | 2020-08-21 | Cameron | Louisiana | 22023 | 174 | 1 |
451498 | 451498 | 2020-08-20 | Cameron | Louisiana | 22023 | 174 | 1 |
448270 | 448270 | 2020-08-19 | Cameron | Louisiana | 22023 | 174 | 1 |
445043 | 445043 | 2020-08-18 | Cameron | Louisiana | 22023 | 174 | 1 |
441817 | 441817 | 2020-08-17 | Cameron | Louisiana | 22023 | 174 | 0 |
438590 | 438590 | 2020-08-16 | Cameron | Louisiana | 22023 | 174 | 0 |
435365 | 435365 | 2020-08-15 | Cameron | Louisiana | 22023 | 173 | 0 |
432140 | 432140 | 2020-08-14 | Cameron | Louisiana | 22023 | 173 | 0 |
428912 | 428912 | 2020-08-13 | Cameron | Louisiana | 22023 | 172 | 0 |
425688 | 425688 | 2020-08-12 | Cameron | Louisiana | 22023 | 171 | 0 |
422467 | 422467 | 2020-08-11 | Cameron | Louisiana | 22023 | 170 | 0 |
419245 | 419245 | 2020-08-10 | Cameron | Louisiana | 22023 | 169 | 0 |
416024 | 416024 | 2020-08-09 | Cameron | Louisiana | 22023 | 168 | 0 |
412804 | 412804 | 2020-08-08 | Cameron | Louisiana | 22023 | 167 | 0 |
409584 | 409584 | 2020-08-07 | Cameron | Louisiana | 22023 | 167 | 0 |
406364 | 406364 | 2020-08-06 | Cameron | Louisiana | 22023 | 167 | 0 |
403146 | 403146 | 2020-08-05 | Cameron | Louisiana | 22023 | 167 | 0 |
399929 | 399929 | 2020-08-04 | Cameron | Louisiana | 22023 | 167 | 0 |
396714 | 396714 | 2020-08-03 | Cameron | Louisiana | 22023 | 167 | 0 |
393498 | 393498 | 2020-08-02 | Cameron | Louisiana | 22023 | 167 | 0 |
390281 | 390281 | 2020-08-01 | Cameron | Louisiana | 22023 | 164 | 0 |
387064 | 387064 | 2020-07-31 | Cameron | Louisiana | 22023 | 164 | 0 |
383846 | 383846 | 2020-07-30 | Cameron | Louisiana | 22023 | 158 | 0 |
380629 | 380629 | 2020-07-29 | Cameron | Louisiana | 22023 | 158 | 0 |
377412 | 377412 | 2020-07-28 | Cameron | Louisiana | 22023 | 157 | 0 |
374197 | 374197 | 2020-07-27 | Cameron | Louisiana | 22023 | 157 | 0 |
370985 | 370985 | 2020-07-26 | Cameron | Louisiana | 22023 | 157 | 0 |
367775 | 367775 | 2020-07-25 | Cameron | Louisiana | 22023 | 150 | 0 |
364568 | 364568 | 2020-07-24 | Cameron | Louisiana | 22023 | 150 | 0 |
361361 | 361361 | 2020-07-23 | Cameron | Louisiana | 22023 | 150 | 0 |
358156 | 358156 | 2020-07-22 | Cameron | Louisiana | 22023 | 147 | 0 |
354953 | 354953 | 2020-07-21 | Cameron | Louisiana | 22023 | 145 | 0 |
351751 | 351751 | 2020-07-20 | Cameron | Louisiana | 22023 | 125 | 0 |
348551 | 348551 | 2020-07-19 | Cameron | Louisiana | 22023 | 123 | 0 |
345350 | 345350 | 2020-07-18 | Cameron | Louisiana | 22023 | 119 | 0 |
342150 | 342150 | 2020-07-17 | Cameron | Louisiana | 22023 | 119 | 0 |
338954 | 338954 | 2020-07-16 | Cameron | Louisiana | 22023 | 119 | 0 |
335758 | 335758 | 2020-07-15 | Cameron | Louisiana | 22023 | 117 | 0 |
332565 | 332565 | 2020-07-14 | Cameron | Louisiana | 22023 | 115 | 0 |
329378 | 329378 | 2020-07-13 | Cameron | Louisiana | 22023 | 100 | 0 |
326192 | 326192 | 2020-07-12 | Cameron | Louisiana | 22023 | 100 | 0 |
323009 | 323009 | 2020-07-11 | Cameron | Louisiana | 22023 | 97 | 0 |
319830 | 319830 | 2020-07-10 | Cameron | Louisiana | 22023 | 97 | 0 |
316655 | 316655 | 2020-07-09 | Cameron | Louisiana | 22023 | 93 | 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);