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: cases, date (date)
deaths 306 ✖
- 637 17
- 704 14
- 439 13
- 51 12
- 706 12
- 1 11
- 230 11
- 705 11
- 40 8
- 59 8
- 396 8
- 464 8
- 641 8
- 231 7
- 456 7
- 622 7
- 698 7
- 701 7
- 702 7
- 49 6
- 54 6
- 221 6
- 450 6
- 461 6
- 610 6
- 613 6
- 0 5
- 146 5
- 210 5
- 217 5
- 312 5
- 346 5
- 354 5
- 442 5
- 447 5
- 452 5
- 465 5
- 510 5
- 518 5
- 556 5
- 623 5
- 624 5
- 685 5
- 3 4
- 37 4
- 43 4
- 53 4
- 92 4
- 127 4
- 182 4
- 212 4
- 238 4
- 241 4
- 296 4
- 378 4
- 421 4
- 426 4
- 431 4
- 438 4
- 457 4
- 571 4
- 595 4
- 614 4
- 633 4
- 639 4
- 640 4
- 644 4
- 655 4
- 663 4
- 688 4
- 696 4
- 29 3
- 31 3
- 52 3
- 75 3
- 154 3
- 178 3
- 194 3
- 213 3
- 224 3
- 239 3
- 245 3
- 252 3
- 259 3
- 260 3
- 278 3
- 285 3
- 298 3
- 332 3
- 340 3
- 390 3
- 401 3
- 414 3
- 437 3
- 469 3
- 478 3
- 495 3
- 537 3
- 585 3
- 602 3
- 626 3
- 627 3
- 628 3
- 654 3
- 671 3
- 678 3
- 4 2
- 15 2
- 19 2
- 26 2
- 27 2
- 42 2
- 44 2
- 63 2
- 71 2
- 107 2
- 121 2
- 157 2
- 166 2
- 192 2
- 193 2
- 198 2
- 207 2
- 209 2
- 219 2
- 220 2
- 222 2
- 243 2
- 249 2
- 256 2
- 270 2
- 277 2
- 280 2
- 291 2
- 294 2
- 295 2
- 310 2
- 321 2
- 326 2
- 329 2
- 336 2
- 339 2
- 351 2
- 362 2
- 364 2
- 372 2
- 374 2
- 387 2
- 394 2
- 416 2
- 432 2
- 448 2
- 467 2
- 477 2
- 529 2
- 601 2
- 612 2
- 619 2
- 635 2
- 659 2
- 670 2
- 682 2
- 690 2
- 693 2
- 703 2
- 5 1
- 8 1
- 12 1
- 13 1
- 14 1
- 16 1
- 18 1
- 20 1
- 23 1
- 24 1
- 28 1
- 34 1
- 35 1
- 38 1
- 45 1
- 46 1
- 62 1
- 70 1
- 72 1
- 74 1
- 80 1
- 84 1
- 91 1
- 96 1
- 116 1
- 117 1
- 130 1
- 147 1
- 156 1
- 158 1
- 160 1
- 179 1
- 181 1
- 190 1
- 196 1
- 197 1
- 200 1
- 202 1
- 203 1
- 205 1
- 206 1
- 223 1
- 233 1
- 242 1
- 246 1
- 261 1
- 263 1
- 264 1
- 268 1
- 273 1
- 275 1
- 281 1
- 283 1
- 292 1
- 303 1
- 307 1
- 314 1
- 316 1
- 319 1
- 323 1
- 327 1
- 328 1
- 345 1
- 355 1
- 358 1
- 359 1
- 365 1
- 368 1
- 369 1
- 375 1
- 377 1
- 381 1
- 382 1
- 400 1
- 409 1
- 411 1
- 412 1
- 413 1
- 415 1
- 418 1
- 422 1
- 424 1
- 425 1
- 427 1
- 428 1
- 429 1
- 433 1
- 440 1
- 443 1
- 444 1
- 451 1
- 453 1
- 455 1
- 458 1
- 460 1
- 463 1
- 473 1
- 475 1
- 481 1
- 488 1
- 490 1
- 493 1
- 499 1
- 502 1
- 505 1
- 507 1
- 516 1
- 519 1
- 538 1
- 545 1
- 551 1
- 562 1
- 568 1
- 573 1
- 574 1
- 581 1
- 582 1
- 586 1
- 587 1
- 589 1
- 592 1
- 598 1
- 605 1
- 606 1
- 609 1
- 616 1
- 618 1
- 625 1
- 631 1
- 636 1
- 643 1
- 645 1
- 664 1
- 667 1
- 672 1
- 675 1
- 676 1
- 677 1
- 679 1
- 684 1
- 687 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);