ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 22071 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
247479 | 247479 | 2020-06-17 | Orleans | Louisiana | 22071 | 7459 | 523 |
250591 | 250591 | 2020-06-18 | Orleans | Louisiana | 22071 | 7459 | 523 |
256826 | 256826 | 2020-06-20 | Orleans | Louisiana | 22071 | 7491 | 529 |
259952 | 259952 | 2020-06-21 | Orleans | Louisiana | 22071 | 7518 | 529 |
263081 | 263081 | 2020-06-22 | Orleans | Louisiana | 22071 | 7536 | 529 |
266208 | 266208 | 2020-06-23 | Orleans | Louisiana | 22071 | 7571 | 529 |
269341 | 269341 | 2020-06-24 | Orleans | Louisiana | 22071 | 7610 | 529 |
272477 | 272477 | 2020-06-25 | Orleans | Louisiana | 22071 | 7638 | 529 |
275620 | 275620 | 2020-06-26 | Orleans | Louisiana | 22071 | 7681 | 530 |
278768 | 278768 | 2020-06-27 | Orleans | Louisiana | 22071 | 7681 | 530 |
281916 | 281916 | 2020-06-28 | Orleans | Louisiana | 22071 | 7760 | 531 |
285062 | 285062 | 2020-06-29 | Orleans | Louisiana | 22071 | 7796 | 532 |
288211 | 288211 | 2020-06-30 | Orleans | Louisiana | 22071 | 7851 | 534 |
291362 | 291362 | 2020-07-01 | Orleans | Louisiana | 22071 | 7919 | 534 |
294516 | 294516 | 2020-07-02 | Orleans | Louisiana | 22071 | 7960 | 534 |
297674 | 297674 | 2020-07-03 | Orleans | Louisiana | 22071 | 8031 | 534 |
300836 | 300836 | 2020-07-04 | Orleans | Louisiana | 22071 | 8031 | 534 |
304000 | 304000 | 2020-07-05 | Orleans | Louisiana | 22071 | 8107 | 534 |
307167 | 307167 | 2020-07-06 | Orleans | Louisiana | 22071 | 8143 | 534 |
310335 | 310335 | 2020-07-07 | Orleans | Louisiana | 22071 | 8206 | 536 |
313505 | 313505 | 2020-07-08 | Orleans | Louisiana | 22071 | 8287 | 536 |
316679 | 316679 | 2020-07-09 | Orleans | Louisiana | 22071 | 8344 | 539 |
319854 | 319854 | 2020-07-10 | Orleans | Louisiana | 22071 | 8476 | 541 |
323033 | 323033 | 2020-07-11 | Orleans | Louisiana | 22071 | 8598 | 540 |
326216 | 326216 | 2020-07-12 | Orleans | Louisiana | 22071 | 8665 | 540 |
329402 | 329402 | 2020-07-13 | Orleans | Louisiana | 22071 | 8745 | 540 |
332589 | 332589 | 2020-07-14 | Orleans | Louisiana | 22071 | 8846 | 542 |
335782 | 335782 | 2020-07-15 | Orleans | Louisiana | 22071 | 8946 | 543 |
338978 | 338978 | 2020-07-16 | Orleans | Louisiana | 22071 | 9052 | 543 |
342174 | 342174 | 2020-07-17 | Orleans | Louisiana | 22071 | 9160 | 544 |
345374 | 345374 | 2020-07-18 | Orleans | Louisiana | 22071 | 9160 | 544 |
348575 | 348575 | 2020-07-19 | Orleans | Louisiana | 22071 | 9265 | 545 |
351775 | 351775 | 2020-07-20 | Orleans | Louisiana | 22071 | 9379 | 546 |
354977 | 354977 | 2020-07-21 | Orleans | Louisiana | 22071 | 9451 | 546 |
358180 | 358180 | 2020-07-22 | Orleans | Louisiana | 22071 | 9586 | 546 |
361385 | 361385 | 2020-07-23 | Orleans | Louisiana | 22071 | 9649 | 546 |
364592 | 364592 | 2020-07-24 | Orleans | Louisiana | 22071 | 9752 | 548 |
367799 | 367799 | 2020-07-25 | Orleans | Louisiana | 22071 | 9752 | 548 |
371009 | 371009 | 2020-07-26 | Orleans | Louisiana | 22071 | 9898 | 552 |
374221 | 374221 | 2020-07-27 | Orleans | Louisiana | 22071 | 10011 | 552 |
377436 | 377436 | 2020-07-28 | Orleans | Louisiana | 22071 | 10071 | 553 |
380653 | 380653 | 2020-07-29 | Orleans | Louisiana | 22071 | 10120 | 559 |
383870 | 383870 | 2020-07-30 | Orleans | Louisiana | 22071 | 10204 | 560 |
387088 | 387088 | 2020-07-31 | Orleans | Louisiana | 22071 | 10255 | 560 |
390305 | 390305 | 2020-08-01 | Orleans | Louisiana | 22071 | 10255 | 560 |
393522 | 393522 | 2020-08-02 | Orleans | Louisiana | 22071 | 10384 | 560 |
396738 | 396738 | 2020-08-03 | Orleans | Louisiana | 22071 | 10426 | 560 |
399953 | 399953 | 2020-08-04 | Orleans | Louisiana | 22071 | 10487 | 560 |
403170 | 403170 | 2020-08-05 | Orleans | Louisiana | 22071 | 10526 | 560 |
406388 | 406388 | 2020-08-06 | Orleans | Louisiana | 22071 | 10573 | 561 |
409608 | 409608 | 2020-08-07 | Orleans | Louisiana | 22071 | 10637 | 562 |
412828 | 412828 | 2020-08-08 | Orleans | Louisiana | 22071 | 10637 | 562 |
416048 | 416048 | 2020-08-09 | Orleans | Louisiana | 22071 | 10735 | 562 |
419269 | 419269 | 2020-08-10 | Orleans | Louisiana | 22071 | 10768 | 562 |
422491 | 422491 | 2020-08-11 | Orleans | Louisiana | 22071 | 10805 | 562 |
425712 | 425712 | 2020-08-12 | Orleans | Louisiana | 22071 | 10851 | 564 |
428936 | 428936 | 2020-08-13 | Orleans | Louisiana | 22071 | 10899 | 565 |
432164 | 432164 | 2020-08-14 | Orleans | Louisiana | 22071 | 10939 | 566 |
435389 | 435389 | 2020-08-15 | Orleans | Louisiana | 22071 | 10939 | 566 |
438614 | 438614 | 2020-08-16 | Orleans | Louisiana | 22071 | 10992 | 568 |
441841 | 441841 | 2020-08-17 | Orleans | Louisiana | 22071 | 11027 | 568 |
445067 | 445067 | 2020-08-18 | Orleans | Louisiana | 22071 | 11039 | 568 |
448294 | 448294 | 2020-08-19 | Orleans | Louisiana | 22071 | 11064 | 568 |
451522 | 451522 | 2020-08-20 | Orleans | Louisiana | 22071 | 11104 | 569 |
454750 | 454750 | 2020-08-21 | Orleans | Louisiana | 22071 | 11134 | 569 |
457978 | 457978 | 2020-08-22 | Orleans | Louisiana | 22071 | 11134 | 569 |
461205 | 461205 | 2020-08-23 | Orleans | Louisiana | 22071 | 11191 | 570 |
464436 | 464436 | 2020-08-24 | Orleans | Louisiana | 22071 | 11214 | 570 |
467665 | 467665 | 2020-08-25 | Orleans | Louisiana | 22071 | 11229 | 572 |
470894 | 470894 | 2020-08-26 | Orleans | Louisiana | 22071 | 11269 | 573 |
474126 | 474126 | 2020-08-27 | Orleans | Louisiana | 22071 | 11279 | 574 |
477359 | 477359 | 2020-08-28 | Orleans | Louisiana | 22071 | 11326 | 576 |
480592 | 480592 | 2020-08-29 | Orleans | Louisiana | 22071 | 11326 | 576 |
483826 | 483826 | 2020-08-30 | Orleans | Louisiana | 22071 | 11494 | 577 |
487061 | 487061 | 2020-08-31 | Orleans | Louisiana | 22071 | 11514 | 577 |
490294 | 490294 | 2020-09-01 | Orleans | Louisiana | 22071 | 11573 | 577 |
493528 | 493528 | 2020-09-02 | Orleans | Louisiana | 22071 | 11687 | 578 |
496761 | 496761 | 2020-09-03 | Orleans | Louisiana | 22071 | 11727 | 578 |
499995 | 499995 | 2020-09-04 | Orleans | Louisiana | 22071 | 11816 | 578 |
503228 | 503228 | 2020-09-05 | Orleans | Louisiana | 22071 | 11816 | 578 |
506462 | 506462 | 2020-09-06 | Orleans | Louisiana | 22071 | 11926 | 579 |
509695 | 509695 | 2020-09-07 | Orleans | Louisiana | 22071 | 11932 | 581 |
512927 | 512927 | 2020-09-08 | Orleans | Louisiana | 22071 | 11975 | 581 |
516160 | 516160 | 2020-09-09 | Orleans | Louisiana | 22071 | 12048 | 583 |
519395 | 519395 | 2020-09-10 | Orleans | Louisiana | 22071 | 12063 | 584 |
522632 | 522632 | 2020-09-11 | Orleans | Louisiana | 22071 | 12125 | 584 |
525868 | 525868 | 2020-09-12 | Orleans | Louisiana | 22071 | 12125 | 584 |
529104 | 529104 | 2020-09-13 | Orleans | Louisiana | 22071 | 12169 | 584 |
532341 | 532341 | 2020-09-14 | Orleans | Louisiana | 22071 | 12184 | 584 |
535576 | 535576 | 2020-09-15 | Orleans | Louisiana | 22071 | 12235 | 584 |
538813 | 538813 | 2020-09-16 | Orleans | Louisiana | 22071 | 12260 | 585 |
542049 | 542049 | 2020-09-17 | Orleans | Louisiana | 22071 | 12268 | 585 |
545285 | 545285 | 2020-09-18 | Orleans | Louisiana | 22071 | 12287 | 585 |
548523 | 548523 | 2020-09-19 | Orleans | Louisiana | 22071 | 12287 | 585 |
551762 | 551762 | 2020-09-20 | Orleans | Louisiana | 22071 | 12343 | 587 |
555001 | 555001 | 2020-09-21 | Orleans | Louisiana | 22071 | 12345 | 587 |
558238 | 558238 | 2020-09-22 | Orleans | Louisiana | 22071 | 12407 | 587 |
561474 | 561474 | 2020-09-23 | Orleans | Louisiana | 22071 | 12436 | 587 |
564714 | 564714 | 2020-09-24 | Orleans | Louisiana | 22071 | 12514 | 587 |
567954 | 567954 | 2020-09-25 | Orleans | Louisiana | 22071 | 12524 | 587 |
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);