ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 22009 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
623033 | 623033 | 2020-10-12 | Avoyelles | Louisiana | 22009 | 1632 | 62 |
619789 | 619789 | 2020-10-11 | Avoyelles | Louisiana | 22009 | 1628 | 61 |
616547 | 616547 | 2020-10-10 | Avoyelles | Louisiana | 22009 | 1617 | 59 |
613306 | 613306 | 2020-10-09 | Avoyelles | Louisiana | 22009 | 1617 | 59 |
610064 | 610064 | 2020-10-08 | Avoyelles | Louisiana | 22009 | 1610 | 58 |
606822 | 606822 | 2020-10-07 | Avoyelles | Louisiana | 22009 | 1599 | 58 |
603580 | 603580 | 2020-10-06 | Avoyelles | Louisiana | 22009 | 1592 | 58 |
600337 | 600337 | 2020-10-05 | Avoyelles | Louisiana | 22009 | 1572 | 58 |
597095 | 597095 | 2020-10-04 | Avoyelles | Louisiana | 22009 | 1571 | 58 |
593853 | 593853 | 2020-10-03 | Avoyelles | Louisiana | 22009 | 1564 | 57 |
590612 | 590612 | 2020-10-02 | Avoyelles | Louisiana | 22009 | 1564 | 57 |
587371 | 587371 | 2020-10-01 | Avoyelles | Louisiana | 22009 | 1536 | 57 |
584131 | 584131 | 2020-09-30 | Avoyelles | Louisiana | 22009 | 1529 | 57 |
580891 | 580891 | 2020-09-29 | Avoyelles | Louisiana | 22009 | 1528 | 55 |
577650 | 577650 | 2020-09-28 | Avoyelles | Louisiana | 22009 | 1528 | 55 |
574408 | 574408 | 2020-09-27 | Avoyelles | Louisiana | 22009 | 1526 | 55 |
571165 | 571165 | 2020-09-26 | Avoyelles | Louisiana | 22009 | 1514 | 54 |
567923 | 567923 | 2020-09-25 | Avoyelles | Louisiana | 22009 | 1514 | 54 |
564683 | 564683 | 2020-09-24 | Avoyelles | Louisiana | 22009 | 1497 | 54 |
561443 | 561443 | 2020-09-23 | Avoyelles | Louisiana | 22009 | 1491 | 53 |
558207 | 558207 | 2020-09-22 | Avoyelles | Louisiana | 22009 | 1483 | 53 |
554970 | 554970 | 2020-09-21 | Avoyelles | Louisiana | 22009 | 1469 | 53 |
551731 | 551731 | 2020-09-20 | Avoyelles | Louisiana | 22009 | 1468 | 53 |
548492 | 548492 | 2020-09-19 | Avoyelles | Louisiana | 22009 | 1461 | 53 |
545254 | 545254 | 2020-09-18 | Avoyelles | Louisiana | 22009 | 1461 | 53 |
542018 | 542018 | 2020-09-17 | Avoyelles | Louisiana | 22009 | 1441 | 52 |
538782 | 538782 | 2020-09-16 | Avoyelles | Louisiana | 22009 | 1440 | 52 |
535545 | 535545 | 2020-09-15 | Avoyelles | Louisiana | 22009 | 1431 | 49 |
532310 | 532310 | 2020-09-14 | Avoyelles | Louisiana | 22009 | 1426 | 49 |
529073 | 529073 | 2020-09-13 | Avoyelles | Louisiana | 22009 | 1419 | 49 |
525837 | 525837 | 2020-09-12 | Avoyelles | Louisiana | 22009 | 1398 | 49 |
522601 | 522601 | 2020-09-11 | Avoyelles | Louisiana | 22009 | 1398 | 49 |
519364 | 519364 | 2020-09-10 | Avoyelles | Louisiana | 22009 | 1399 | 47 |
516129 | 516129 | 2020-09-09 | Avoyelles | Louisiana | 22009 | 1396 | 47 |
512896 | 512896 | 2020-09-08 | Avoyelles | Louisiana | 22009 | 1335 | 47 |
509664 | 509664 | 2020-09-07 | Avoyelles | Louisiana | 22009 | 1331 | 47 |
506431 | 506431 | 2020-09-06 | Avoyelles | Louisiana | 22009 | 1327 | 47 |
503197 | 503197 | 2020-09-05 | Avoyelles | Louisiana | 22009 | 1320 | 46 |
499964 | 499964 | 2020-09-04 | Avoyelles | Louisiana | 22009 | 1320 | 46 |
496730 | 496730 | 2020-09-03 | Avoyelles | Louisiana | 22009 | 1305 | 46 |
493497 | 493497 | 2020-09-02 | Avoyelles | Louisiana | 22009 | 1303 | 46 |
490263 | 490263 | 2020-09-01 | Avoyelles | Louisiana | 22009 | 1294 | 45 |
487030 | 487030 | 2020-08-31 | Avoyelles | Louisiana | 22009 | 1285 | 45 |
483795 | 483795 | 2020-08-30 | Avoyelles | Louisiana | 22009 | 1279 | 44 |
480561 | 480561 | 2020-08-29 | Avoyelles | Louisiana | 22009 | 1268 | 43 |
477328 | 477328 | 2020-08-28 | Avoyelles | Louisiana | 22009 | 1268 | 43 |
474095 | 474095 | 2020-08-27 | Avoyelles | Louisiana | 22009 | 1261 | 43 |
470863 | 470863 | 2020-08-26 | Avoyelles | Louisiana | 22009 | 1255 | 43 |
467634 | 467634 | 2020-08-25 | Avoyelles | Louisiana | 22009 | 1248 | 43 |
464405 | 464405 | 2020-08-24 | Avoyelles | Louisiana | 22009 | 1218 | 43 |
461174 | 461174 | 2020-08-23 | Avoyelles | Louisiana | 22009 | 1211 | 42 |
457947 | 457947 | 2020-08-22 | Avoyelles | Louisiana | 22009 | 1196 | 40 |
454719 | 454719 | 2020-08-21 | Avoyelles | Louisiana | 22009 | 1196 | 40 |
451491 | 451491 | 2020-08-20 | Avoyelles | Louisiana | 22009 | 1178 | 40 |
448263 | 448263 | 2020-08-19 | Avoyelles | Louisiana | 22009 | 1172 | 40 |
445036 | 445036 | 2020-08-18 | Avoyelles | Louisiana | 22009 | 1157 | 38 |
441810 | 441810 | 2020-08-17 | Avoyelles | Louisiana | 22009 | 1149 | 37 |
438583 | 438583 | 2020-08-16 | Avoyelles | Louisiana | 22009 | 1143 | 37 |
435358 | 435358 | 2020-08-15 | Avoyelles | Louisiana | 22009 | 1138 | 36 |
432133 | 432133 | 2020-08-14 | Avoyelles | Louisiana | 22009 | 1138 | 36 |
428905 | 428905 | 2020-08-13 | Avoyelles | Louisiana | 22009 | 1128 | 34 |
425681 | 425681 | 2020-08-12 | Avoyelles | Louisiana | 22009 | 1107 | 34 |
422460 | 422460 | 2020-08-11 | Avoyelles | Louisiana | 22009 | 1096 | 32 |
419238 | 419238 | 2020-08-10 | Avoyelles | Louisiana | 22009 | 1070 | 32 |
416017 | 416017 | 2020-08-09 | Avoyelles | Louisiana | 22009 | 1070 | 32 |
412797 | 412797 | 2020-08-08 | Avoyelles | Louisiana | 22009 | 1021 | 31 |
409577 | 409577 | 2020-08-07 | Avoyelles | Louisiana | 22009 | 1021 | 31 |
406357 | 406357 | 2020-08-06 | Avoyelles | Louisiana | 22009 | 1002 | 29 |
403139 | 403139 | 2020-08-05 | Avoyelles | Louisiana | 22009 | 987 | 29 |
399922 | 399922 | 2020-08-04 | Avoyelles | Louisiana | 22009 | 981 | 27 |
396707 | 396707 | 2020-08-03 | Avoyelles | Louisiana | 22009 | 951 | 27 |
393491 | 393491 | 2020-08-02 | Avoyelles | Louisiana | 22009 | 939 | 27 |
390274 | 390274 | 2020-08-01 | Avoyelles | Louisiana | 22009 | 907 | 26 |
387057 | 387057 | 2020-07-31 | Avoyelles | Louisiana | 22009 | 907 | 26 |
383839 | 383839 | 2020-07-30 | Avoyelles | Louisiana | 22009 | 895 | 26 |
380622 | 380622 | 2020-07-29 | Avoyelles | Louisiana | 22009 | 867 | 26 |
377405 | 377405 | 2020-07-28 | Avoyelles | Louisiana | 22009 | 851 | 24 |
374190 | 374190 | 2020-07-27 | Avoyelles | Louisiana | 22009 | 842 | 24 |
370978 | 370978 | 2020-07-26 | Avoyelles | Louisiana | 22009 | 827 | 24 |
367768 | 367768 | 2020-07-25 | Avoyelles | Louisiana | 22009 | 781 | 23 |
364561 | 364561 | 2020-07-24 | Avoyelles | Louisiana | 22009 | 781 | 23 |
361354 | 361354 | 2020-07-23 | Avoyelles | Louisiana | 22009 | 754 | 23 |
358149 | 358149 | 2020-07-22 | Avoyelles | Louisiana | 22009 | 741 | 23 |
354946 | 354946 | 2020-07-21 | Avoyelles | Louisiana | 22009 | 699 | 20 |
351744 | 351744 | 2020-07-20 | Avoyelles | Louisiana | 22009 | 655 | 20 |
348544 | 348544 | 2020-07-19 | Avoyelles | Louisiana | 22009 | 619 | 20 |
345343 | 345343 | 2020-07-18 | Avoyelles | Louisiana | 22009 | 588 | 18 |
342143 | 342143 | 2020-07-17 | Avoyelles | Louisiana | 22009 | 588 | 18 |
338947 | 338947 | 2020-07-16 | Avoyelles | Louisiana | 22009 | 565 | 17 |
335751 | 335751 | 2020-07-15 | Avoyelles | Louisiana | 22009 | 549 | 17 |
332558 | 332558 | 2020-07-14 | Avoyelles | Louisiana | 22009 | 512 | 17 |
329371 | 329371 | 2020-07-13 | Avoyelles | Louisiana | 22009 | 489 | 17 |
326185 | 326185 | 2020-07-12 | Avoyelles | Louisiana | 22009 | 482 | 17 |
323002 | 323002 | 2020-07-11 | Avoyelles | Louisiana | 22009 | 475 | 16 |
319823 | 319823 | 2020-07-10 | Avoyelles | Louisiana | 22009 | 460 | 16 |
316648 | 316648 | 2020-07-09 | Avoyelles | Louisiana | 22009 | 447 | 16 |
313474 | 313474 | 2020-07-08 | Avoyelles | Louisiana | 22009 | 418 | 15 |
310304 | 310304 | 2020-07-07 | Avoyelles | Louisiana | 22009 | 402 | 15 |
307136 | 307136 | 2020-07-06 | Avoyelles | Louisiana | 22009 | 390 | 14 |
303969 | 303969 | 2020-07-05 | Avoyelles | Louisiana | 22009 | 386 | 14 |
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);