ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Jefferson" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535566 | 535566 | 2020-09-15 | Jefferson | Louisiana | 22051 | 17077 | 563 |
532331 | 532331 | 2020-09-14 | Jefferson | Louisiana | 22051 | 17048 | 560 |
529094 | 529094 | 2020-09-13 | Jefferson | Louisiana | 22051 | 17023 | 559 |
525858 | 525858 | 2020-09-12 | Jefferson | Louisiana | 22051 | 16974 | 559 |
522622 | 522622 | 2020-09-11 | Jefferson | Louisiana | 22051 | 16974 | 559 |
519385 | 519385 | 2020-09-10 | Jefferson | Louisiana | 22051 | 16920 | 558 |
516150 | 516150 | 2020-09-09 | Jefferson | Louisiana | 22051 | 16871 | 557 |
512917 | 512917 | 2020-09-08 | Jefferson | Louisiana | 22051 | 16825 | 556 |
509685 | 509685 | 2020-09-07 | Jefferson | Louisiana | 22051 | 16802 | 556 |
506452 | 506452 | 2020-09-06 | Jefferson | Louisiana | 22051 | 16764 | 556 |
503218 | 503218 | 2020-09-05 | Jefferson | Louisiana | 22051 | 16678 | 553 |
499985 | 499985 | 2020-09-04 | Jefferson | Louisiana | 22051 | 16678 | 553 |
496751 | 496751 | 2020-09-03 | Jefferson | Louisiana | 22051 | 16629 | 552 |
493518 | 493518 | 2020-09-02 | Jefferson | Louisiana | 22051 | 16575 | 549 |
490284 | 490284 | 2020-09-01 | Jefferson | Louisiana | 22051 | 16526 | 549 |
487051 | 487051 | 2020-08-31 | Jefferson | Louisiana | 22051 | 16461 | 546 |
483816 | 483816 | 2020-08-30 | Jefferson | Louisiana | 22051 | 16438 | 545 |
480582 | 480582 | 2020-08-29 | Jefferson | Louisiana | 22051 | 16315 | 543 |
477349 | 477349 | 2020-08-28 | Jefferson | Louisiana | 22051 | 16315 | 543 |
474116 | 474116 | 2020-08-27 | Jefferson | Louisiana | 22051 | 16269 | 541 |
470884 | 470884 | 2020-08-26 | Jefferson | Louisiana | 22051 | 16227 | 541 |
467655 | 467655 | 2020-08-25 | Jefferson | Louisiana | 22051 | 16159 | 539 |
464426 | 464426 | 2020-08-24 | Jefferson | Louisiana | 22051 | 16171 | 538 |
461195 | 461195 | 2020-08-23 | Jefferson | Louisiana | 22051 | 16131 | 537 |
457968 | 457968 | 2020-08-22 | Jefferson | Louisiana | 22051 | 16006 | 537 |
454740 | 454740 | 2020-08-21 | Jefferson | Louisiana | 22051 | 16006 | 537 |
451512 | 451512 | 2020-08-20 | Jefferson | Louisiana | 22051 | 15964 | 534 |
448284 | 448284 | 2020-08-19 | Jefferson | Louisiana | 22051 | 15905 | 532 |
445057 | 445057 | 2020-08-18 | Jefferson | Louisiana | 22051 | 15865 | 532 |
441831 | 441831 | 2020-08-17 | Jefferson | Louisiana | 22051 | 15815 | 531 |
438604 | 438604 | 2020-08-16 | Jefferson | Louisiana | 22051 | 15789 | 531 |
435379 | 435379 | 2020-08-15 | Jefferson | Louisiana | 22051 | 15703 | 530 |
432154 | 432154 | 2020-08-14 | Jefferson | Louisiana | 22051 | 15703 | 530 |
428926 | 428926 | 2020-08-13 | Jefferson | Louisiana | 22051 | 15597 | 529 |
425702 | 425702 | 2020-08-12 | Jefferson | Louisiana | 22051 | 15509 | 529 |
422481 | 422481 | 2020-08-11 | Jefferson | Louisiana | 22051 | 15452 | 529 |
419259 | 419259 | 2020-08-10 | Jefferson | Louisiana | 22051 | 15350 | 529 |
416038 | 416038 | 2020-08-09 | Jefferson | Louisiana | 22051 | 15279 | 529 |
412818 | 412818 | 2020-08-08 | Jefferson | Louisiana | 22051 | 15103 | 523 |
409598 | 409598 | 2020-08-07 | Jefferson | Louisiana | 22051 | 15103 | 523 |
406378 | 406378 | 2020-08-06 | Jefferson | Louisiana | 22051 | 15002 | 521 |
403160 | 403160 | 2020-08-05 | Jefferson | Louisiana | 22051 | 14914 | 520 |
399943 | 399943 | 2020-08-04 | Jefferson | Louisiana | 22051 | 14795 | 518 |
396728 | 396728 | 2020-08-03 | Jefferson | Louisiana | 22051 | 14533 | 518 |
393512 | 393512 | 2020-08-02 | Jefferson | Louisiana | 22051 | 14453 | 518 |
390295 | 390295 | 2020-08-01 | Jefferson | Louisiana | 22051 | 14155 | 513 |
387078 | 387078 | 2020-07-31 | Jefferson | Louisiana | 22051 | 14155 | 513 |
383860 | 383860 | 2020-07-30 | Jefferson | Louisiana | 22051 | 14026 | 513 |
380643 | 380643 | 2020-07-29 | Jefferson | Louisiana | 22051 | 13872 | 510 |
377426 | 377426 | 2020-07-28 | Jefferson | Louisiana | 22051 | 13780 | 510 |
374211 | 374211 | 2020-07-27 | Jefferson | Louisiana | 22051 | 13680 | 510 |
370999 | 370999 | 2020-07-26 | Jefferson | Louisiana | 22051 | 13448 | 510 |
367789 | 367789 | 2020-07-25 | Jefferson | Louisiana | 22051 | 13128 | 507 |
364582 | 364582 | 2020-07-24 | Jefferson | Louisiana | 22051 | 13128 | 507 |
361375 | 361375 | 2020-07-23 | Jefferson | Louisiana | 22051 | 12945 | 507 |
358170 | 358170 | 2020-07-22 | Jefferson | Louisiana | 22051 | 12812 | 507 |
354967 | 354967 | 2020-07-21 | Jefferson | Louisiana | 22051 | 12637 | 504 |
351765 | 351765 | 2020-07-20 | Jefferson | Louisiana | 22051 | 12486 | 501 |
348565 | 348565 | 2020-07-19 | Jefferson | Louisiana | 22051 | 12254 | 500 |
345364 | 345364 | 2020-07-18 | Jefferson | Louisiana | 22051 | 12030 | 498 |
342164 | 342164 | 2020-07-17 | Jefferson | Louisiana | 22051 | 12030 | 498 |
338968 | 338968 | 2020-07-16 | Jefferson | Louisiana | 22051 | 11836 | 497 |
335772 | 335772 | 2020-07-15 | Jefferson | Louisiana | 22051 | 11614 | 495 |
332579 | 332579 | 2020-07-14 | Jefferson | Louisiana | 22051 | 11450 | 495 |
329392 | 329392 | 2020-07-13 | Jefferson | Louisiana | 22051 | 11256 | 495 |
326206 | 326206 | 2020-07-12 | Jefferson | Louisiana | 22051 | 11100 | 493 |
323023 | 323023 | 2020-07-11 | Jefferson | Louisiana | 22051 | 10995 | 491 |
319844 | 319844 | 2020-07-10 | Jefferson | Louisiana | 22051 | 10812 | 490 |
316669 | 316669 | 2020-07-09 | Jefferson | Louisiana | 22051 | 10544 | 489 |
313495 | 313495 | 2020-07-08 | Jefferson | Louisiana | 22051 | 10452 | 488 |
310325 | 310325 | 2020-07-07 | Jefferson | Louisiana | 22051 | 10272 | 488 |
307157 | 307157 | 2020-07-06 | Jefferson | Louisiana | 22051 | 10097 | 487 |
303990 | 303990 | 2020-07-05 | Jefferson | Louisiana | 22051 | 10024 | 487 |
300826 | 300826 | 2020-07-04 | Jefferson | Louisiana | 22051 | 9874 | 486 |
297664 | 297664 | 2020-07-03 | Jefferson | Louisiana | 22051 | 9874 | 486 |
294506 | 294506 | 2020-07-02 | Jefferson | Louisiana | 22051 | 9712 | 486 |
291352 | 291352 | 2020-07-01 | Jefferson | Louisiana | 22051 | 9637 | 485 |
288201 | 288201 | 2020-06-30 | Jefferson | Louisiana | 22051 | 9489 | 484 |
285052 | 285052 | 2020-06-29 | Jefferson | Louisiana | 22051 | 9403 | 483 |
281906 | 281906 | 2020-06-28 | Jefferson | Louisiana | 22051 | 9342 | 483 |
278758 | 278758 | 2020-06-27 | Jefferson | Louisiana | 22051 | 9169 | 481 |
275610 | 275610 | 2020-06-26 | Jefferson | Louisiana | 22051 | 9169 | 481 |
272467 | 272467 | 2020-06-25 | Jefferson | Louisiana | 22051 | 9074 | 480 |
269331 | 269331 | 2020-06-24 | Jefferson | Louisiana | 22051 | 9003 | 479 |
266198 | 266198 | 2020-06-23 | Jefferson | Louisiana | 22051 | 8888 | 479 |
263071 | 263071 | 2020-06-22 | Jefferson | Louisiana | 22051 | 8741 | 477 |
259942 | 259942 | 2020-06-21 | Jefferson | Louisiana | 22051 | 8681 | 477 |
256816 | 256816 | 2020-06-20 | Jefferson | Louisiana | 22051 | 8647 | 477 |
253696 | 253696 | 2020-06-19 | Jefferson | Louisiana | 22051 | 8542 | 474 |
250581 | 250581 | 2020-06-18 | Jefferson | Louisiana | 22051 | 8507 | 472 |
247469 | 247469 | 2020-06-17 | Jefferson | Louisiana | 22051 | 8507 | 472 |
244356 | 244356 | 2020-06-16 | Jefferson | Louisiana | 22051 | 8468 | 471 |
241245 | 241245 | 2020-06-15 | Jefferson | Louisiana | 22051 | 8416 | 467 |
238136 | 238136 | 2020-06-14 | Jefferson | Louisiana | 22051 | 8379 | 466 |
235029 | 235029 | 2020-06-13 | Jefferson | Louisiana | 22051 | 8339 | 465 |
231924 | 231924 | 2020-06-12 | Jefferson | Louisiana | 22051 | 8091 | 465 |
228820 | 228820 | 2020-06-11 | Jefferson | Louisiana | 22051 | 8032 | 464 |
225718 | 225718 | 2020-06-10 | Jefferson | Louisiana | 22051 | 7971 | 463 |
222622 | 222622 | 2020-06-09 | Jefferson | Louisiana | 22051 | 7940 | 462 |
219527 | 219527 | 2020-06-08 | Jefferson | Louisiana | 22051 | 7885 | 462 |
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);