ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22019 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 593 ✖
- 30036 5
- 34894 5
- 54375 5
- 21287 4
- 22828 4
- 22956 4
- 23292 4
- 30939 4
- 35616 4
- 36906 4
- 43421 4
- 54662 4
- 4 3
- 13043 3
- 13933 3
- 20689 3
- 21011 3
- 21664 3
- 21956 3
- 22167 3
- 22340 3
- 22484 3
- 22615 3
- 22710 3
- 22849 3
- 23069 3
- 23181 3
- 23426 3
- 23638 3
- 24068 3
- 24824 3
- 25775 3
- 27372 3
- 28778 3
- 32113 3
- 32730 3
- 33184 3
- 33542 3
- 33838 3
- 34107 3
- 34331 3
- 34467 3
- 34556 3
- 34666 3
- 34803 3
- 35010 3
- 35137 3
- 35297 3
- 39813 3
- 41198 3
- 45999 3
- 50008 3
- 53008 3
- 53791 3
- 54131 3
- 54447 3
- 54515 3
- 54573 3
- 54588 3
- 54610 3
- 54639 3
- 54689 3
- 54731 3
- 54780 3
- 309 2
- 496 2
- 521 2
- 568 2
- 588 2
- 824 2
- 1138 2
- 2000 2
- 4028 2
- 5127 2
- 6278 2
- 6752 2
- 6815 2
- 7013 2
- 7235 2
- 7298 2
- 7465 2
- 7592 2
- 7632 2
- 7708 2
- 7831 2
- 7907 2
- 7947 2
- 8028 2
- 8044 2
- 8138 2
- 8302 2
- 8461 2
- 8643 2
- 8736 2
- 9353 2
- 9924 2
- 10254 2
- 10393 2
- 10939 2
- 11677 2
- 12400 2
- 15076 2
- 15949 2
- 16736 2
- 17614 2
- 18186 2
- 18656 2
- 18725 2
- 18778 2
- 19299 2
- 19723 2
- 20232 2
- 21441 2
- 34644 2
- 1 1
- 3 1
- 5 1
- 11 1
- 15 1
- 22 1
- 28 1
- 35 1
- 42 1
- 65 1
- 90 1
- 108 1
- 119 1
- 135 1
- 139 1
- 159 1
- 186 1
- 191 1
- 209 1
- 228 1
- 248 1
- 259 1
- 268 1
- 273 1
- 282 1
- 300 1
- 323 1
- 324 1
- 334 1
- 341 1
- 352 1
- 356 1
- 360 1
- 363 1
- 369 1
- 377 1
- 386 1
- 389 1
- 437 1
- 449 1
- 455 1
- 464 1
- 470 1
- 475 1
- 478 1
- 481 1
- 490 1
- 493 1
- 505 1
- 507 1
- 513 1
- 514 1
- 517 1
- 520 1
- 548 1
- 567 1
- 572 1
- 578 1
- 581 1
- 596 1
- 599 1
- 608 1
- 611 1
- 613 1
- 621 1
- 625 1
- 632 1
- 637 1
- 642 1
- 661 1
- 673 1
- 684 1
- 701 1
- 741 1
- 755 1
- 772 1
- 789 1
- 831 1
- 876 1
- 888 1
- 921 1
- 971 1
- 1010 1
- 1061 1
- 1205 1
- 1257 1
- 1300 1
- 1729 1
- 1852 1
- 2153 1
- 2289 1
- 2408 1
- 2701 1
- 2797 1
- 2975 1
- 3061 1
- 3127 1
- 3236 1
- 3435 1
- 3705 1
- 3864 1
- 4231 1
- 4481 1
- 4578 1
- 4742 1
- 4995 1
- 5459 1
- 5626 1
- 5709 1
- 5810 1
- 5913 1
- 6440 1
- 6527 1
- 6594 1
- 6641 1
- 6695 1
- 6862 1
- 6924 1
- 6960 1
- 7044 1
- 7045 1
- 7093 1
- 7154 1
- 7194 1
- 7256 1
- 7269 1
- 7277 1
- 7284 1
- 7285 1
- 7438 1
- 7439 1
- 7441 1
- 7442 1
- 7445 1
- 7474 1
- 7476 1
- 7487 1
- 7549 1
- 7580 1
- 7623 1
- 7645 1
- 7698 1
- 7744 1
- 7745 1
- 7773 1
- 7794 1
- 7812 1
- 7854 1
- 7856 1
- 7869 1
- 7892 1
- 7899 1
- 7954 1
- 7986 1
- 8005 1
- 8068 1
- 8095 1
- 8106 1
- 8185 1
- 8187 1
- 8198 1
- 8256 1
- 8284 1
- 8353 1
- 8366 1
- 8402 1
- 8419 1
- 8441 1
- 8530 1
- 8531 1
- 8544 1
- 8549 1
- 8605 1
- 8700 1
- 8713 1
- 8806 1
- 9520 1
- 9542 1
- 9664 1
- 9743 1
- 9826 1
- 10032 1
- 10058 1
- 10200 1
- 10449 1
- 10460 1
- 10730 1
- 10764 1
- 10856 1
- 11056 1
- 11087 1
- 11183 1
- 11447 1
- 11532 1
- 11822 1
- 11868 1
- 11934 1
- 12121 1
- 12244 1
- 12562 1
- 12586 1
- 12812 1
- 12959 1
- 13092 1
- 13105 1
- 13305 1
- 13766 1
- 14096 1
- 14106 1
- 14161 1
- 14772 1
- 14955 1
- 15260 1
- 15294 1
- 15528 1
- 15641 1
- 15809 1
- 16156 1
- 16176 1
- 16266 1
- 16456 1
- 16676 1
- 16928 1
- 16970 1
- 17076 1
- 17385 1
- 17525 1
- 17786 1
- 17809 1
- 18004 1
- 18094 1
- 18169 1
- 18292 1
- 18327 1
- 18436 1
- 18443 1
- 18589 1
- 18710 1
- 18718 1
- 18748 1
- 18919 1
- 18923 1
- 19096 1
- 19137 1
- 19181 1
- 19459 1
- 19491 1
- 19584 1
- 19640 1
- 19697 1
- 19822 1
- 19882 1
- 20060 1
- 20126 1
- 20174 1
- 20299 1
- 20323 1
- 20480 1
- 20551 1
- 20654 1
- 20857 1
- 20919 1
- 20945 1
- 20955 1
- 21120 1
- 21161 1
- 21220 1
- 21512 1
- 21564 1
- 21764 1
- 21792 1
- 21823 1
- 21911 1
- 22033 1
- 22057 1
- 22111 1
- 22138 1
- 22230 1
- 22263 1
- 22265 1
- 22300 1
- 22372 1
- 22422 1
- 22449 1
- 22466 1
- 22538 1
- 22582 1
- 22592 1
- 22607 1
- 22645 1
- 22665 1
- 22681 1
- 22702 1
- 22743 1
- 22780 1
- 22790 1
- 22807 1
- 22836 1
- 22837 1
- 22851 1
- 22859 1
- 22899 1
- 22925 1
- 22991 1
- 23015 1
- 23037 1
- 23054 1
- 23122 1
- 23131 1
- 23154 1
- 23175 1
- 23232 1
- 23239 1
- 23263 1
- 23279 1
- 23348 1
- 23387 1
- 23409 1
- 23476 1
- 23497 1
- 23546 1
- 23580 1
- 23727 1
- 23743 1
- 23910 1
- 23981 1
- 24210 1
- 24471 1
- 24580 1
- 24679 1
- 25148 1
- 25289 1
- 25458 1
- 25602 1
- 26427 1
- 26647 1
- 26830 1
- 26953 1
- 27919 1
- 28019 1
- 28286 1
- 28495 1
- 29288 1
- 29369 1
- 29738 1
- 29890 1
- 30685 1
- 30815 1
- 31201 1
- 31581 1
- 32009 1
- 32317 1
- 32466 1
- 32554 1
- 32612 1
- 32888 1
- 32917 1
- 33073 1
- 33142 1
- 33326 1
- 33403 1
- 33445 1
- 33479 1
- 33622 1
- 33685 1
- 33742 1
- 33791 1
- 33914 1
- 33968 1
- 34011 1
- 34061 1
- 34170 1
- 34222 1
- 34252 1
- 34290 1
- 34378 1
- 34395 1
- 34439 1
- 34454 1
- 34494 1
- 34507 1
- 34520 1
- 34548 1
- 34598 1
- 34620 1
- 34709 1
- 34732 1
- 34759 1
- 34780 1
- 34846 1
- 34875 1
- 34942 1
- 34953 1
- 34981 1
- 34988 1
- 35045 1
- 35068 1
- 35106 1
- 35128 1
- 35182 1
- 35203 1
- 35232 1
- 35261 1
- 35400 1
- 35468 1
- 35540 1
- 36008 1
- 36180 1
- 36490 1
- 37985 1
- 38363 1
- 38741 1
- 39312 1
- 40822 1
- 44686 1
- 45121 1
- 45635 1
- 46676 1
- 46983 1
- 49466 1
- 49746 1
- 50378 1
- 50596 1
- 50804 1
- 51013 1
- 53342 1
- 53421 1
- 53509 1
- 53607 1
- 53894 1
- 53970 1
- 54030 1
- 54072 1
- 54183 1
- 54298 1
- 54333 1
- 54354 1
- 54410 1
- 54436 1
- 54466 1
- 54479 1
- 54502 1
- 54508 1
- 54532 1
- 54539 1
- 54545 1
- 54564 1
- 54576 1
- 54577 1
- 54579 1
- 54584 1
- 54590 1
- 54592 1
- 54596 1
- 54605 1
- 54617 1
- 54618 1
- 54628 1
- 54635 1
- 54645 1
- 54653 1
- 54658 1
- 54670 1
- 54675 1
- 54679 1
- 54683 1
- 54701 1
- 54707 1
- 54713 1
- 54726 1
- 54745 1
- 54754 1
- 54764 1
- 54774 1
- 54799 1
- 54816 1
- 54825 1
- 54851 1
- 54862 1
state 1
- Louisiana 786
fips 1
- 22019 · 786 ✖
county 1
- Calcasieu 786
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500708 | 2500708 | 2022-05-13 | Calcasieu | Louisiana | 22019 | 54862 | 706 |
2497450 | 2497450 | 2022-05-12 | Calcasieu | Louisiana | 22019 | 54851 | 706 |
2494192 | 2494192 | 2022-05-11 | Calcasieu | Louisiana | 22019 | 54825 | 706 |
2490934 | 2490934 | 2022-05-10 | Calcasieu | Louisiana | 22019 | 54816 | 706 |
2487677 | 2487677 | 2022-05-09 | Calcasieu | Louisiana | 22019 | 54799 | 706 |
2484419 | 2484419 | 2022-05-08 | Calcasieu | Louisiana | 22019 | 54780 | 706 |
2481161 | 2481161 | 2022-05-07 | Calcasieu | Louisiana | 22019 | 54780 | 706 |
2477903 | 2477903 | 2022-05-06 | Calcasieu | Louisiana | 22019 | 54780 | 706 |
2474645 | 2474645 | 2022-05-05 | Calcasieu | Louisiana | 22019 | 54774 | 706 |
2471388 | 2471388 | 2022-05-04 | Calcasieu | Louisiana | 22019 | 54764 | 706 |
2468132 | 2468132 | 2022-05-03 | Calcasieu | Louisiana | 22019 | 54754 | 706 |
2464877 | 2464877 | 2022-05-02 | Calcasieu | Louisiana | 22019 | 54745 | 706 |
2461621 | 2461621 | 2022-05-01 | Calcasieu | Louisiana | 22019 | 54731 | 705 |
2458365 | 2458365 | 2022-04-30 | Calcasieu | Louisiana | 22019 | 54731 | 705 |
2455109 | 2455109 | 2022-04-29 | Calcasieu | Louisiana | 22019 | 54731 | 705 |
2451853 | 2451853 | 2022-04-28 | Calcasieu | Louisiana | 22019 | 54726 | 705 |
2448597 | 2448597 | 2022-04-27 | Calcasieu | Louisiana | 22019 | 54713 | 705 |
2445341 | 2445341 | 2022-04-26 | Calcasieu | Louisiana | 22019 | 54707 | 705 |
2442085 | 2442085 | 2022-04-25 | Calcasieu | Louisiana | 22019 | 54701 | 705 |
2438829 | 2438829 | 2022-04-24 | Calcasieu | Louisiana | 22019 | 54689 | 705 |
2435573 | 2435573 | 2022-04-23 | Calcasieu | Louisiana | 22019 | 54689 | 705 |
2432317 | 2432317 | 2022-04-22 | Calcasieu | Louisiana | 22019 | 54689 | 705 |
2429061 | 2429061 | 2022-04-21 | Calcasieu | Louisiana | 22019 | 54683 | 705 |
2425805 | 2425805 | 2022-04-20 | Calcasieu | Louisiana | 22019 | 54679 | 704 |
2422549 | 2422549 | 2022-04-19 | Calcasieu | Louisiana | 22019 | 54675 | 704 |
2419293 | 2419293 | 2022-04-18 | Calcasieu | Louisiana | 22019 | 54670 | 704 |
2416037 | 2416037 | 2022-04-17 | Calcasieu | Louisiana | 22019 | 54662 | 704 |
2412781 | 2412781 | 2022-04-16 | Calcasieu | Louisiana | 22019 | 54662 | 704 |
2409525 | 2409525 | 2022-04-15 | Calcasieu | Louisiana | 22019 | 54662 | 704 |
2406269 | 2406269 | 2022-04-14 | Calcasieu | Louisiana | 22019 | 54662 | 704 |
2403013 | 2403013 | 2022-04-13 | Calcasieu | Louisiana | 22019 | 54658 | 704 |
2399759 | 2399759 | 2022-04-12 | Calcasieu | Louisiana | 22019 | 54653 | 704 |
2396503 | 2396503 | 2022-04-11 | Calcasieu | Louisiana | 22019 | 54645 | 704 |
2393248 | 2393248 | 2022-04-10 | Calcasieu | Louisiana | 22019 | 54639 | 704 |
2389992 | 2389992 | 2022-04-09 | Calcasieu | Louisiana | 22019 | 54639 | 704 |
2386736 | 2386736 | 2022-04-08 | Calcasieu | Louisiana | 22019 | 54639 | 704 |
2383481 | 2383481 | 2022-04-07 | Calcasieu | Louisiana | 22019 | 54635 | 704 |
2380226 | 2380226 | 2022-04-06 | Calcasieu | Louisiana | 22019 | 54628 | 703 |
2376971 | 2376971 | 2022-04-05 | Calcasieu | Louisiana | 22019 | 54618 | 703 |
2373719 | 2373719 | 2022-04-04 | Calcasieu | Louisiana | 22019 | 54617 | 702 |
2370466 | 2370466 | 2022-04-03 | Calcasieu | Louisiana | 22019 | 54610 | 702 |
2367213 | 2367213 | 2022-04-02 | Calcasieu | Louisiana | 22019 | 54610 | 702 |
2363960 | 2363960 | 2022-04-01 | Calcasieu | Louisiana | 22019 | 54610 | 702 |
2360706 | 2360706 | 2022-03-31 | Calcasieu | Louisiana | 22019 | 54605 | 702 |
2357452 | 2357452 | 2022-03-30 | Calcasieu | Louisiana | 22019 | 54596 | 702 |
2354199 | 2354199 | 2022-03-29 | Calcasieu | Louisiana | 22019 | 54592 | 702 |
2350947 | 2350947 | 2022-03-28 | Calcasieu | Louisiana | 22019 | 54590 | 701 |
2347694 | 2347694 | 2022-03-27 | Calcasieu | Louisiana | 22019 | 54588 | 701 |
2344441 | 2344441 | 2022-03-26 | Calcasieu | Louisiana | 22019 | 54588 | 701 |
2341188 | 2341188 | 2022-03-25 | Calcasieu | Louisiana | 22019 | 54588 | 701 |
2337935 | 2337935 | 2022-03-24 | Calcasieu | Louisiana | 22019 | 54584 | 701 |
2334681 | 2334681 | 2022-03-23 | Calcasieu | Louisiana | 22019 | 54579 | 701 |
2331427 | 2331427 | 2022-03-22 | Calcasieu | Louisiana | 22019 | 54577 | 701 |
2328175 | 2328175 | 2022-03-21 | Calcasieu | Louisiana | 22019 | 54576 | 698 |
2324922 | 2324922 | 2022-03-20 | Calcasieu | Louisiana | 22019 | 54573 | 698 |
2321668 | 2321668 | 2022-03-19 | Calcasieu | Louisiana | 22019 | 54573 | 698 |
2318414 | 2318414 | 2022-03-18 | Calcasieu | Louisiana | 22019 | 54573 | 698 |
2315161 | 2315161 | 2022-03-17 | Calcasieu | Louisiana | 22019 | 54564 | 698 |
2311908 | 2311908 | 2022-03-16 | Calcasieu | Louisiana | 22019 | 54545 | 698 |
2308655 | 2308655 | 2022-03-15 | Calcasieu | Louisiana | 22019 | 54539 | 698 |
2305404 | 2305404 | 2022-03-14 | Calcasieu | Louisiana | 22019 | 54532 | 696 |
2302152 | 2302152 | 2022-03-13 | Calcasieu | Louisiana | 22019 | 54515 | 696 |
2298900 | 2298900 | 2022-03-12 | Calcasieu | Louisiana | 22019 | 54515 | 696 |
2295648 | 2295648 | 2022-03-11 | Calcasieu | Louisiana | 22019 | 54515 | 696 |
2292396 | 2292396 | 2022-03-10 | Calcasieu | Louisiana | 22019 | 54508 | 693 |
2289144 | 2289144 | 2022-03-09 | Calcasieu | Louisiana | 22019 | 54502 | 693 |
2285893 | 2285893 | 2022-03-08 | Calcasieu | Louisiana | 22019 | 54479 | 690 |
2282641 | 2282641 | 2022-03-07 | Calcasieu | Louisiana | 22019 | 54466 | 690 |
2279388 | 2279388 | 2022-03-06 | Calcasieu | Louisiana | 22019 | 54447 | 688 |
2276135 | 2276135 | 2022-03-05 | Calcasieu | Louisiana | 22019 | 54447 | 688 |
2272882 | 2272882 | 2022-03-04 | Calcasieu | Louisiana | 22019 | 54447 | 688 |
2269630 | 2269630 | 2022-03-03 | Calcasieu | Louisiana | 22019 | 54436 | 688 |
2266377 | 2266377 | 2022-03-02 | Calcasieu | Louisiana | 22019 | 54410 | 687 |
2263126 | 2263126 | 2022-03-01 | Calcasieu | Louisiana | 22019 | 54375 | 685 |
2259875 | 2259875 | 2022-02-28 | Calcasieu | Louisiana | 22019 | 54375 | 685 |
2256624 | 2256624 | 2022-02-27 | Calcasieu | Louisiana | 22019 | 54375 | 685 |
2253373 | 2253373 | 2022-02-26 | Calcasieu | Louisiana | 22019 | 54375 | 685 |
2250122 | 2250122 | 2022-02-25 | Calcasieu | Louisiana | 22019 | 54375 | 685 |
2246871 | 2246871 | 2022-02-24 | Calcasieu | Louisiana | 22019 | 54354 | 684 |
2243620 | 2243620 | 2022-02-23 | Calcasieu | Louisiana | 22019 | 54333 | 682 |
2240369 | 2240369 | 2022-02-22 | Calcasieu | Louisiana | 22019 | 54298 | 682 |
2237118 | 2237118 | 2022-02-21 | Calcasieu | Louisiana | 22019 | 54183 | 679 |
2233867 | 2233867 | 2022-02-20 | Calcasieu | Louisiana | 22019 | 54131 | 678 |
2230616 | 2230616 | 2022-02-19 | Calcasieu | Louisiana | 22019 | 54131 | 678 |
2227365 | 2227365 | 2022-02-18 | Calcasieu | Louisiana | 22019 | 54131 | 678 |
2224114 | 2224114 | 2022-02-17 | Calcasieu | Louisiana | 22019 | 54072 | 677 |
2220863 | 2220863 | 2022-02-16 | Calcasieu | Louisiana | 22019 | 54030 | 676 |
2217612 | 2217612 | 2022-02-15 | Calcasieu | Louisiana | 22019 | 53970 | 675 |
2214361 | 2214361 | 2022-02-14 | Calcasieu | Louisiana | 22019 | 53894 | 672 |
2211109 | 2211109 | 2022-02-13 | Calcasieu | Louisiana | 22019 | 53791 | 671 |
2207856 | 2207856 | 2022-02-12 | Calcasieu | Louisiana | 22019 | 53791 | 671 |
2204603 | 2204603 | 2022-02-11 | Calcasieu | Louisiana | 22019 | 53791 | 671 |
2201350 | 2201350 | 2022-02-10 | Calcasieu | Louisiana | 22019 | 53607 | 670 |
2198096 | 2198096 | 2022-02-09 | Calcasieu | Louisiana | 22019 | 53509 | 670 |
2194842 | 2194842 | 2022-02-08 | Calcasieu | Louisiana | 22019 | 53421 | 667 |
2191588 | 2191588 | 2022-02-07 | Calcasieu | Louisiana | 22019 | 53342 | 664 |
2188335 | 2188335 | 2022-02-06 | Calcasieu | Louisiana | 22019 | 53008 | 663 |
2185082 | 2185082 | 2022-02-05 | Calcasieu | Louisiana | 22019 | 53008 | 663 |
2181830 | 2181830 | 2022-02-04 | Calcasieu | Louisiana | 22019 | 53008 | 663 |
2178579 | 2178579 | 2022-02-03 | Calcasieu | Louisiana | 22019 | 51013 | 663 |
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);