ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Assumption" and state = "Louisiana" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
278736 | 278736 | 2020-06-27 | Assumption | Louisiana | 22007 | 338 | 14 |
281884 | 281884 | 2020-06-28 | Assumption | Louisiana | 22007 | 343 | 14 |
285030 | 285030 | 2020-06-29 | Assumption | Louisiana | 22007 | 351 | 14 |
288179 | 288179 | 2020-06-30 | Assumption | Louisiana | 22007 | 352 | 14 |
291330 | 291330 | 2020-07-01 | Assumption | Louisiana | 22007 | 357 | 15 |
294484 | 294484 | 2020-07-02 | Assumption | Louisiana | 22007 | 364 | 15 |
297642 | 297642 | 2020-07-03 | Assumption | Louisiana | 22007 | 373 | 15 |
300804 | 300804 | 2020-07-04 | Assumption | Louisiana | 22007 | 373 | 15 |
303968 | 303968 | 2020-07-05 | Assumption | Louisiana | 22007 | 381 | 15 |
307135 | 307135 | 2020-07-06 | Assumption | Louisiana | 22007 | 383 | 15 |
310303 | 310303 | 2020-07-07 | Assumption | Louisiana | 22007 | 390 | 15 |
313473 | 313473 | 2020-07-08 | Assumption | Louisiana | 22007 | 399 | 15 |
316647 | 316647 | 2020-07-09 | Assumption | Louisiana | 22007 | 404 | 16 |
319822 | 319822 | 2020-07-10 | Assumption | Louisiana | 22007 | 410 | 16 |
323001 | 323001 | 2020-07-11 | Assumption | Louisiana | 22007 | 415 | 16 |
326184 | 326184 | 2020-07-12 | Assumption | Louisiana | 22007 | 424 | 16 |
329370 | 329370 | 2020-07-13 | Assumption | Louisiana | 22007 | 430 | 16 |
332557 | 332557 | 2020-07-14 | Assumption | Louisiana | 22007 | 432 | 17 |
335750 | 335750 | 2020-07-15 | Assumption | Louisiana | 22007 | 435 | 17 |
338946 | 338946 | 2020-07-16 | Assumption | Louisiana | 22007 | 439 | 17 |
342142 | 342142 | 2020-07-17 | Assumption | Louisiana | 22007 | 445 | 17 |
345342 | 345342 | 2020-07-18 | Assumption | Louisiana | 22007 | 445 | 17 |
348543 | 348543 | 2020-07-19 | Assumption | Louisiana | 22007 | 449 | 17 |
351743 | 351743 | 2020-07-20 | Assumption | Louisiana | 22007 | 452 | 17 |
354945 | 354945 | 2020-07-21 | Assumption | Louisiana | 22007 | 462 | 17 |
358148 | 358148 | 2020-07-22 | Assumption | Louisiana | 22007 | 463 | 18 |
361353 | 361353 | 2020-07-23 | Assumption | Louisiana | 22007 | 477 | 18 |
364560 | 364560 | 2020-07-24 | Assumption | Louisiana | 22007 | 484 | 18 |
367767 | 367767 | 2020-07-25 | Assumption | Louisiana | 22007 | 484 | 18 |
370977 | 370977 | 2020-07-26 | Assumption | Louisiana | 22007 | 493 | 18 |
374189 | 374189 | 2020-07-27 | Assumption | Louisiana | 22007 | 509 | 18 |
377404 | 377404 | 2020-07-28 | Assumption | Louisiana | 22007 | 515 | 18 |
380621 | 380621 | 2020-07-29 | Assumption | Louisiana | 22007 | 521 | 19 |
383838 | 383838 | 2020-07-30 | Assumption | Louisiana | 22007 | 531 | 19 |
387056 | 387056 | 2020-07-31 | Assumption | Louisiana | 22007 | 537 | 19 |
390273 | 390273 | 2020-08-01 | Assumption | Louisiana | 22007 | 537 | 19 |
393490 | 393490 | 2020-08-02 | Assumption | Louisiana | 22007 | 552 | 19 |
396706 | 396706 | 2020-08-03 | Assumption | Louisiana | 22007 | 555 | 20 |
399921 | 399921 | 2020-08-04 | Assumption | Louisiana | 22007 | 557 | 20 |
403138 | 403138 | 2020-08-05 | Assumption | Louisiana | 22007 | 561 | 20 |
406356 | 406356 | 2020-08-06 | Assumption | Louisiana | 22007 | 569 | 20 |
409576 | 409576 | 2020-08-07 | Assumption | Louisiana | 22007 | 577 | 20 |
412796 | 412796 | 2020-08-08 | Assumption | Louisiana | 22007 | 577 | 20 |
416016 | 416016 | 2020-08-09 | Assumption | Louisiana | 22007 | 584 | 20 |
419237 | 419237 | 2020-08-10 | Assumption | Louisiana | 22007 | 588 | 20 |
422459 | 422459 | 2020-08-11 | Assumption | Louisiana | 22007 | 591 | 20 |
425680 | 425680 | 2020-08-12 | Assumption | Louisiana | 22007 | 598 | 20 |
428904 | 428904 | 2020-08-13 | Assumption | Louisiana | 22007 | 600 | 20 |
432132 | 432132 | 2020-08-14 | Assumption | Louisiana | 22007 | 606 | 20 |
435357 | 435357 | 2020-08-15 | Assumption | Louisiana | 22007 | 606 | 20 |
438582 | 438582 | 2020-08-16 | Assumption | Louisiana | 22007 | 613 | 20 |
441809 | 441809 | 2020-08-17 | Assumption | Louisiana | 22007 | 616 | 20 |
445035 | 445035 | 2020-08-18 | Assumption | Louisiana | 22007 | 617 | 20 |
448262 | 448262 | 2020-08-19 | Assumption | Louisiana | 22007 | 623 | 20 |
451490 | 451490 | 2020-08-20 | Assumption | Louisiana | 22007 | 626 | 20 |
454718 | 454718 | 2020-08-21 | Assumption | Louisiana | 22007 | 628 | 20 |
457946 | 457946 | 2020-08-22 | Assumption | Louisiana | 22007 | 628 | 20 |
461173 | 461173 | 2020-08-23 | Assumption | Louisiana | 22007 | 631 | 21 |
464404 | 464404 | 2020-08-24 | Assumption | Louisiana | 22007 | 631 | 21 |
470862 | 470862 | 2020-08-26 | Assumption | Louisiana | 22007 | 649 | 22 |
467633 | 467633 | 2020-08-25 | Assumption | Louisiana | 22007 | 651 | 21 |
477327 | 477327 | 2020-08-28 | Assumption | Louisiana | 22007 | 653 | 22 |
480560 | 480560 | 2020-08-29 | Assumption | Louisiana | 22007 | 653 | 22 |
474094 | 474094 | 2020-08-27 | Assumption | Louisiana | 22007 | 654 | 22 |
483794 | 483794 | 2020-08-30 | Assumption | Louisiana | 22007 | 664 | 22 |
487029 | 487029 | 2020-08-31 | Assumption | Louisiana | 22007 | 667 | 22 |
490262 | 490262 | 2020-09-01 | Assumption | Louisiana | 22007 | 669 | 22 |
496729 | 496729 | 2020-09-03 | Assumption | Louisiana | 22007 | 669 | 22 |
493496 | 493496 | 2020-09-02 | Assumption | Louisiana | 22007 | 670 | 22 |
499963 | 499963 | 2020-09-04 | Assumption | Louisiana | 22007 | 675 | 22 |
503196 | 503196 | 2020-09-05 | Assumption | Louisiana | 22007 | 675 | 22 |
506430 | 506430 | 2020-09-06 | Assumption | Louisiana | 22007 | 680 | 22 |
509663 | 509663 | 2020-09-07 | Assumption | Louisiana | 22007 | 683 | 22 |
512895 | 512895 | 2020-09-08 | Assumption | Louisiana | 22007 | 692 | 22 |
516128 | 516128 | 2020-09-09 | Assumption | Louisiana | 22007 | 699 | 23 |
519363 | 519363 | 2020-09-10 | Assumption | Louisiana | 22007 | 699 | 23 |
522600 | 522600 | 2020-09-11 | Assumption | Louisiana | 22007 | 710 | 23 |
525836 | 525836 | 2020-09-12 | Assumption | Louisiana | 22007 | 710 | 23 |
529072 | 529072 | 2020-09-13 | Assumption | Louisiana | 22007 | 721 | 23 |
532309 | 532309 | 2020-09-14 | Assumption | Louisiana | 22007 | 729 | 23 |
535544 | 535544 | 2020-09-15 | Assumption | Louisiana | 22007 | 734 | 24 |
538781 | 538781 | 2020-09-16 | Assumption | Louisiana | 22007 | 735 | 24 |
542017 | 542017 | 2020-09-17 | Assumption | Louisiana | 22007 | 735 | 24 |
545253 | 545253 | 2020-09-18 | Assumption | Louisiana | 22007 | 740 | 24 |
548491 | 548491 | 2020-09-19 | Assumption | Louisiana | 22007 | 740 | 24 |
551730 | 551730 | 2020-09-20 | Assumption | Louisiana | 22007 | 750 | 24 |
554969 | 554969 | 2020-09-21 | Assumption | Louisiana | 22007 | 753 | 24 |
564682 | 564682 | 2020-09-24 | Assumption | Louisiana | 22007 | 755 | 24 |
558206 | 558206 | 2020-09-22 | Assumption | Louisiana | 22007 | 758 | 24 |
561442 | 561442 | 2020-09-23 | Assumption | Louisiana | 22007 | 758 | 24 |
567922 | 567922 | 2020-09-25 | Assumption | Louisiana | 22007 | 758 | 24 |
571164 | 571164 | 2020-09-26 | Assumption | Louisiana | 22007 | 758 | 24 |
577649 | 577649 | 2020-09-28 | Assumption | Louisiana | 22007 | 760 | 24 |
574407 | 574407 | 2020-09-27 | Assumption | Louisiana | 22007 | 761 | 24 |
580890 | 580890 | 2020-09-29 | Assumption | Louisiana | 22007 | 763 | 24 |
584130 | 584130 | 2020-09-30 | Assumption | Louisiana | 22007 | 764 | 24 |
587370 | 587370 | 2020-10-01 | Assumption | Louisiana | 22007 | 765 | 24 |
590611 | 590611 | 2020-10-02 | Assumption | Louisiana | 22007 | 766 | 24 |
593852 | 593852 | 2020-10-03 | Assumption | Louisiana | 22007 | 766 | 24 |
597094 | 597094 | 2020-10-04 | Assumption | Louisiana | 22007 | 766 | 24 |
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);