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