ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50,902 rows where state = "Louisiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Jefferson 796
- Orleans 795
- Caddo 794
- St. Charles 792
- St. Tammany 792
- Terrebonne 792
- Bossier 791
- Lafourche 791
- St. John the Baptist 791
- St. Bernard 790
- Ascension 789
- East Baton Rouge 788
- Washington 788
- Assumption 786
- Calcasieu 786
- Iberia 786
- Iberville 786
- Lafayette 786
- Livingston 786
- Plaquemines 786
- St. James 786
- St. Landry 786
- Unknown 786
- Webster 786
- West Baton Rouge 786
- Catahoula 785
- De Soto 785
- Rapides 785
- Tangipahoa 785
- Avoyelles 784
- …
state 1
- Louisiana · 50,802 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
288176 | 288176 | 2020-06-30 | Acadia | Louisiana | 22001 | 878 | 36 |
291327 | 291327 | 2020-07-01 | Acadia | Louisiana | 22001 | 919 | 37 |
294481 | 294481 | 2020-07-02 | Acadia | Louisiana | 22001 | 945 | 37 |
297639 | 297639 | 2020-07-03 | Acadia | Louisiana | 22001 | 968 | 39 |
300801 | 300801 | 2020-07-04 | Acadia | Louisiana | 22001 | 968 | 39 |
303965 | 303965 | 2020-07-05 | Acadia | Louisiana | 22001 | 1016 | 40 |
307132 | 307132 | 2020-07-06 | Acadia | Louisiana | 22001 | 1042 | 42 |
310300 | 310300 | 2020-07-07 | Acadia | Louisiana | 22001 | 1068 | 43 |
313470 | 313470 | 2020-07-08 | Acadia | Louisiana | 22001 | 1094 | 44 |
316644 | 316644 | 2020-07-09 | Acadia | Louisiana | 22001 | 1166 | 44 |
319819 | 319819 | 2020-07-10 | Acadia | Louisiana | 22001 | 1232 | 44 |
322998 | 322998 | 2020-07-11 | Acadia | Louisiana | 22001 | 1297 | 45 |
326181 | 326181 | 2020-07-12 | Acadia | Louisiana | 22001 | 1339 | 45 |
329367 | 329367 | 2020-07-13 | Acadia | Louisiana | 22001 | 1383 | 45 |
332554 | 332554 | 2020-07-14 | Acadia | Louisiana | 22001 | 1453 | 46 |
335747 | 335747 | 2020-07-15 | Acadia | Louisiana | 22001 | 1510 | 46 |
338943 | 338943 | 2020-07-16 | Acadia | Louisiana | 22001 | 1574 | 48 |
342139 | 342139 | 2020-07-17 | Acadia | Louisiana | 22001 | 1610 | 48 |
345339 | 345339 | 2020-07-18 | Acadia | Louisiana | 22001 | 1610 | 48 |
348540 | 348540 | 2020-07-19 | Acadia | Louisiana | 22001 | 1696 | 51 |
351740 | 351740 | 2020-07-20 | Acadia | Louisiana | 22001 | 1844 | 53 |
354942 | 354942 | 2020-07-21 | Acadia | Louisiana | 22001 | 1920 | 53 |
358145 | 358145 | 2020-07-22 | Acadia | Louisiana | 22001 | 2011 | 59 |
361350 | 361350 | 2020-07-23 | Acadia | Louisiana | 22001 | 2084 | 61 |
364557 | 364557 | 2020-07-24 | Acadia | Louisiana | 22001 | 2111 | 62 |
367764 | 367764 | 2020-07-25 | Acadia | Louisiana | 22001 | 2111 | 62 |
370974 | 370974 | 2020-07-26 | Acadia | Louisiana | 22001 | 2173 | 62 |
374186 | 374186 | 2020-07-27 | Acadia | Louisiana | 22001 | 2215 | 63 |
377401 | 377401 | 2020-07-28 | Acadia | Louisiana | 22001 | 2229 | 65 |
380618 | 380618 | 2020-07-29 | Acadia | Louisiana | 22001 | 2266 | 70 |
383835 | 383835 | 2020-07-30 | Acadia | Louisiana | 22001 | 2299 | 71 |
387053 | 387053 | 2020-07-31 | Acadia | Louisiana | 22001 | 2331 | 71 |
390270 | 390270 | 2020-08-01 | Acadia | Louisiana | 22001 | 2331 | 71 |
393487 | 393487 | 2020-08-02 | Acadia | Louisiana | 22001 | 2380 | 72 |
396703 | 396703 | 2020-08-03 | Acadia | Louisiana | 22001 | 2403 | 77 |
399918 | 399918 | 2020-08-04 | Acadia | Louisiana | 22001 | 2513 | 77 |
403135 | 403135 | 2020-08-05 | Acadia | Louisiana | 22001 | 2536 | 77 |
406353 | 406353 | 2020-08-06 | Acadia | Louisiana | 22001 | 2555 | 79 |
409573 | 409573 | 2020-08-07 | Acadia | Louisiana | 22001 | 2570 | 79 |
412793 | 412793 | 2020-08-08 | Acadia | Louisiana | 22001 | 2570 | 79 |
416013 | 416013 | 2020-08-09 | Acadia | Louisiana | 22001 | 2598 | 83 |
419234 | 419234 | 2020-08-10 | Acadia | Louisiana | 22001 | 2601 | 85 |
422456 | 422456 | 2020-08-11 | Acadia | Louisiana | 22001 | 2634 | 85 |
425677 | 425677 | 2020-08-12 | Acadia | Louisiana | 22001 | 2652 | 87 |
428901 | 428901 | 2020-08-13 | Acadia | Louisiana | 22001 | 2673 | 88 |
432129 | 432129 | 2020-08-14 | Acadia | Louisiana | 22001 | 2684 | 89 |
435354 | 435354 | 2020-08-15 | Acadia | Louisiana | 22001 | 2684 | 89 |
438579 | 438579 | 2020-08-16 | Acadia | Louisiana | 22001 | 2696 | 90 |
441806 | 441806 | 2020-08-17 | Acadia | Louisiana | 22001 | 2701 | 90 |
445032 | 445032 | 2020-08-18 | Acadia | Louisiana | 22001 | 2708 | 91 |
448259 | 448259 | 2020-08-19 | Acadia | Louisiana | 22001 | 2712 | 91 |
451487 | 451487 | 2020-08-20 | Acadia | Louisiana | 22001 | 2731 | 92 |
454715 | 454715 | 2020-08-21 | Acadia | Louisiana | 22001 | 2735 | 92 |
457943 | 457943 | 2020-08-22 | Acadia | Louisiana | 22001 | 2735 | 92 |
461170 | 461170 | 2020-08-23 | Acadia | Louisiana | 22001 | 2743 | 92 |
464401 | 464401 | 2020-08-24 | Acadia | Louisiana | 22001 | 2748 | 93 |
467630 | 467630 | 2020-08-25 | Acadia | Louisiana | 22001 | 2776 | 93 |
470859 | 470859 | 2020-08-26 | Acadia | Louisiana | 22001 | 2775 | 93 |
474091 | 474091 | 2020-08-27 | Acadia | Louisiana | 22001 | 2781 | 93 |
477324 | 477324 | 2020-08-28 | Acadia | Louisiana | 22001 | 2799 | 93 |
480557 | 480557 | 2020-08-29 | Acadia | Louisiana | 22001 | 2799 | 93 |
483791 | 483791 | 2020-08-30 | Acadia | Louisiana | 22001 | 2808 | 93 |
487026 | 487026 | 2020-08-31 | Acadia | Louisiana | 22001 | 2809 | 93 |
490259 | 490259 | 2020-09-01 | Acadia | Louisiana | 22001 | 2817 | 93 |
493493 | 493493 | 2020-09-02 | Acadia | Louisiana | 22001 | 2821 | 93 |
496726 | 496726 | 2020-09-03 | Acadia | Louisiana | 22001 | 2824 | 93 |
499960 | 499960 | 2020-09-04 | Acadia | Louisiana | 22001 | 2828 | 94 |
503193 | 503193 | 2020-09-05 | Acadia | Louisiana | 22001 | 2828 | 94 |
506427 | 506427 | 2020-09-06 | Acadia | Louisiana | 22001 | 2844 | 94 |
509660 | 509660 | 2020-09-07 | Acadia | Louisiana | 22001 | 2853 | 94 |
512892 | 512892 | 2020-09-08 | Acadia | Louisiana | 22001 | 2841 | 94 |
516125 | 516125 | 2020-09-09 | Acadia | Louisiana | 22001 | 2876 | 94 |
519360 | 519360 | 2020-09-10 | Acadia | Louisiana | 22001 | 2877 | 94 |
522597 | 522597 | 2020-09-11 | Acadia | Louisiana | 22001 | 2887 | 94 |
525833 | 525833 | 2020-09-12 | Acadia | Louisiana | 22001 | 2887 | 94 |
529069 | 529069 | 2020-09-13 | Acadia | Louisiana | 22001 | 2889 | 94 |
532306 | 532306 | 2020-09-14 | Acadia | Louisiana | 22001 | 2891 | 94 |
535541 | 535541 | 2020-09-15 | Acadia | Louisiana | 22001 | 2897 | 94 |
538778 | 538778 | 2020-09-16 | Acadia | Louisiana | 22001 | 2901 | 94 |
542014 | 542014 | 2020-09-17 | Acadia | Louisiana | 22001 | 2907 | 94 |
545250 | 545250 | 2020-09-18 | Acadia | Louisiana | 22001 | 2917 | 96 |
548488 | 548488 | 2020-09-19 | Acadia | Louisiana | 22001 | 2917 | 96 |
551727 | 551727 | 2020-09-20 | Acadia | Louisiana | 22001 | 2920 | 96 |
554966 | 554966 | 2020-09-21 | Acadia | Louisiana | 22001 | 2929 | 96 |
558203 | 558203 | 2020-09-22 | Acadia | Louisiana | 22001 | 2930 | 96 |
561439 | 561439 | 2020-09-23 | Acadia | Louisiana | 22001 | 2933 | 96 |
564679 | 564679 | 2020-09-24 | Acadia | Louisiana | 22001 | 2935 | 96 |
567919 | 567919 | 2020-09-25 | Acadia | Louisiana | 22001 | 2946 | 96 |
571161 | 571161 | 2020-09-26 | Acadia | Louisiana | 22001 | 2946 | 96 |
574404 | 574404 | 2020-09-27 | Acadia | Louisiana | 22001 | 2962 | 97 |
577646 | 577646 | 2020-09-28 | Acadia | Louisiana | 22001 | 2959 | 97 |
580887 | 580887 | 2020-09-29 | Acadia | Louisiana | 22001 | 2963 | 99 |
584127 | 584127 | 2020-09-30 | Acadia | Louisiana | 22001 | 2969 | 99 |
587367 | 587367 | 2020-10-01 | Acadia | Louisiana | 22001 | 2966 | 99 |
590608 | 590608 | 2020-10-02 | Acadia | Louisiana | 22001 | 2982 | 99 |
593849 | 593849 | 2020-10-03 | Acadia | Louisiana | 22001 | 2982 | 99 |
597091 | 597091 | 2020-10-04 | Acadia | Louisiana | 22001 | 2992 | 99 |
600333 | 600333 | 2020-10-05 | Acadia | Louisiana | 22001 | 2993 | 99 |
603576 | 603576 | 2020-10-06 | Acadia | Louisiana | 22001 | 3000 | 99 |
606818 | 606818 | 2020-10-07 | Acadia | Louisiana | 22001 | 3004 | 99 |
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);