ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Unknown" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636061 | 636061 | 2020-10-16 | Unknown | Louisiana | 3330 | 200 | |
632815 | 632815 | 2020-10-15 | Unknown | Louisiana | 3327 | 200 | |
629571 | 629571 | 2020-10-14 | Unknown | Louisiana | 3331 | 200 | |
626327 | 626327 | 2020-10-13 | Unknown | Louisiana | 2769 | 193 | |
623085 | 623085 | 2020-10-12 | Unknown | Louisiana | 2775 | 193 | |
619841 | 619841 | 2020-10-11 | Unknown | Louisiana | 2775 | 193 | |
616599 | 616599 | 2020-10-10 | Unknown | Louisiana | 2773 | 193 | |
613358 | 613358 | 2020-10-09 | Unknown | Louisiana | 2773 | 193 | |
610116 | 610116 | 2020-10-08 | Unknown | Louisiana | 2773 | 193 | |
606874 | 606874 | 2020-10-07 | Unknown | Louisiana | 2774 | 193 | |
603632 | 603632 | 2020-10-06 | Unknown | Louisiana | 1620 | 190 | |
600389 | 600389 | 2020-10-05 | Unknown | Louisiana | 1625 | 190 | |
597147 | 597147 | 2020-10-04 | Unknown | Louisiana | 1623 | 190 | |
593905 | 593905 | 2020-10-03 | Unknown | Louisiana | 1624 | 190 | |
590664 | 590664 | 2020-10-02 | Unknown | Louisiana | 1624 | 190 | |
587423 | 587423 | 2020-10-01 | Unknown | Louisiana | 1619 | 190 | |
584183 | 584183 | 2020-09-30 | Unknown | Louisiana | 1619 | 190 | |
580943 | 580943 | 2020-09-29 | Unknown | Louisiana | 1420 | 182 | |
577702 | 577702 | 2020-09-28 | Unknown | Louisiana | 1417 | 182 | |
574460 | 574460 | 2020-09-27 | Unknown | Louisiana | 1420 | 182 | |
571217 | 571217 | 2020-09-26 | Unknown | Louisiana | 1420 | 182 | |
567975 | 567975 | 2020-09-25 | Unknown | Louisiana | 1420 | 182 | |
564735 | 564735 | 2020-09-24 | Unknown | Louisiana | 1418 | 182 | |
561495 | 561495 | 2020-09-23 | Unknown | Louisiana | 1417 | 182 | |
558259 | 558259 | 2020-09-22 | Unknown | Louisiana | 1232 | 168 | |
555022 | 555022 | 2020-09-21 | Unknown | Louisiana | 1235 | 168 | |
551783 | 551783 | 2020-09-20 | Unknown | Louisiana | 1234 | 168 | |
548544 | 548544 | 2020-09-19 | Unknown | Louisiana | 1229 | 168 | |
545306 | 545306 | 2020-09-18 | Unknown | Louisiana | 1229 | 168 | |
542070 | 542070 | 2020-09-17 | Unknown | Louisiana | 1232 | 168 | |
538834 | 538834 | 2020-09-16 | Unknown | Louisiana | 1231 | 168 | |
535597 | 535597 | 2020-09-15 | Unknown | Louisiana | 1129 | 170 | |
532362 | 532362 | 2020-09-14 | Unknown | Louisiana | 1131 | 170 | |
529125 | 529125 | 2020-09-13 | Unknown | Louisiana | 1131 | 170 | |
525889 | 525889 | 2020-09-12 | Unknown | Louisiana | 1125 | 170 | |
522653 | 522653 | 2020-09-11 | Unknown | Louisiana | 1125 | 170 | |
519416 | 519416 | 2020-09-10 | Unknown | Louisiana | 1126 | 170 | |
516181 | 516181 | 2020-09-09 | Unknown | Louisiana | 1128 | 170 | |
512948 | 512948 | 2020-09-08 | Unknown | Louisiana | 1087 | 163 | |
509716 | 509716 | 2020-09-07 | Unknown | Louisiana | 1089 | 163 | |
506483 | 506483 | 2020-09-06 | Unknown | Louisiana | 1088 | 163 | |
503249 | 503249 | 2020-09-05 | Unknown | Louisiana | 1087 | 163 | |
500016 | 500016 | 2020-09-04 | Unknown | Louisiana | 1087 | 163 | |
496782 | 496782 | 2020-09-03 | Unknown | Louisiana | 1086 | 163 | |
493549 | 493549 | 2020-09-02 | Unknown | Louisiana | 1087 | 163 | |
490315 | 490315 | 2020-09-01 | Unknown | Louisiana | 887 | 163 | |
487082 | 487082 | 2020-08-31 | Unknown | Louisiana | 891 | 163 | |
483847 | 483847 | 2020-08-30 | Unknown | Louisiana | 889 | 163 | |
480613 | 480613 | 2020-08-29 | Unknown | Louisiana | 888 | 163 | |
477380 | 477380 | 2020-08-28 | Unknown | Louisiana | 888 | 163 | |
474147 | 474147 | 2020-08-27 | Unknown | Louisiana | 888 | 163 | |
470915 | 470915 | 2020-08-26 | Unknown | Louisiana | 891 | 163 | |
467686 | 467686 | 2020-08-25 | Unknown | Louisiana | 331 | 141 | |
464457 | 464457 | 2020-08-24 | Unknown | Louisiana | 388 | 141 | |
461226 | 461226 | 2020-08-23 | Unknown | Louisiana | 391 | 141 | |
457999 | 457999 | 2020-08-22 | Unknown | Louisiana | 382 | 141 | |
454771 | 454771 | 2020-08-21 | Unknown | Louisiana | 382 | 141 | |
451543 | 451543 | 2020-08-20 | Unknown | Louisiana | 389 | 141 | |
448315 | 448315 | 2020-08-19 | Unknown | Louisiana | 389 | 141 | |
445088 | 445088 | 2020-08-18 | Unknown | Louisiana | 363 | 123 | |
441862 | 441862 | 2020-08-17 | Unknown | Louisiana | 359 | 123 | |
438635 | 438635 | 2020-08-16 | Unknown | Louisiana | 358 | 123 | |
435410 | 435410 | 2020-08-15 | Unknown | Louisiana | 361 | 123 | |
432185 | 432185 | 2020-08-14 | Unknown | Louisiana | 361 | 123 | |
428957 | 428957 | 2020-08-13 | Unknown | Louisiana | 363 | 123 | |
425733 | 425733 | 2020-08-12 | Unknown | Louisiana | 359 | 123 | |
422512 | 422512 | 2020-08-11 | Unknown | Louisiana | 373 | 118 | |
419290 | 419290 | 2020-08-10 | Unknown | Louisiana | 372 | 118 | |
416069 | 416069 | 2020-08-09 | Unknown | Louisiana | 371 | 118 | |
412849 | 412849 | 2020-08-08 | Unknown | Louisiana | 331 | 118 | |
409629 | 409629 | 2020-08-07 | Unknown | Louisiana | 331 | 118 | |
406409 | 406409 | 2020-08-06 | Unknown | Louisiana | 330 | 118 | |
403191 | 403191 | 2020-08-05 | Unknown | Louisiana | 335 | 118 | |
399974 | 399974 | 2020-08-04 | Unknown | Louisiana | 332 | 114 | |
396759 | 396759 | 2020-08-03 | Unknown | Louisiana | 125 | 114 | |
393543 | 393543 | 2020-08-02 | Unknown | Louisiana | 125 | 114 | |
390326 | 390326 | 2020-08-01 | Unknown | Louisiana | 124 | 114 | |
387109 | 387109 | 2020-07-31 | Unknown | Louisiana | 124 | 114 | |
383891 | 383891 | 2020-07-30 | Unknown | Louisiana | 124 | 114 | |
380674 | 380674 | 2020-07-29 | Unknown | Louisiana | 124 | 114 | |
377457 | 377457 | 2020-07-28 | Unknown | Louisiana | 122 | 112 | |
374242 | 374242 | 2020-07-27 | Unknown | Louisiana | 122 | 112 | |
371030 | 371030 | 2020-07-26 | Unknown | Louisiana | 122 | 112 | |
367820 | 367820 | 2020-07-25 | Unknown | Louisiana | 122 | 112 | |
364613 | 364613 | 2020-07-24 | Unknown | Louisiana | 122 | 112 | |
361406 | 361406 | 2020-07-23 | Unknown | Louisiana | 121 | 112 | |
358201 | 358201 | 2020-07-22 | Unknown | Louisiana | 121 | 112 | |
354998 | 354998 | 2020-07-21 | Unknown | Louisiana | 116 | 110 | |
351796 | 351796 | 2020-07-20 | Unknown | Louisiana | 118 | 110 | |
348596 | 348596 | 2020-07-19 | Unknown | Louisiana | 115 | 110 | |
345395 | 345395 | 2020-07-18 | Unknown | Louisiana | 114 | 110 | |
342195 | 342195 | 2020-07-17 | Unknown | Louisiana | 114 | 110 | |
338999 | 338999 | 2020-07-16 | Unknown | Louisiana | 113 | 110 | |
335803 | 335803 | 2020-07-15 | Unknown | Louisiana | 112 | 110 | |
332610 | 332610 | 2020-07-14 | Unknown | Louisiana | 108 | 108 | |
329423 | 329423 | 2020-07-13 | Unknown | Louisiana | 115 | 108 | |
326237 | 326237 | 2020-07-12 | Unknown | Louisiana | 112 | 108 | |
323054 | 323054 | 2020-07-11 | Unknown | Louisiana | 112 | 108 | |
319875 | 319875 | 2020-07-10 | Unknown | Louisiana | 110 | 108 | |
316700 | 316700 | 2020-07-09 | Unknown | Louisiana | 108 | 108 |
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);