ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22063 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535572 | 535572 | 2020-09-15 | Livingston | Louisiana | 22063 | 3642 | 71 |
532337 | 532337 | 2020-09-14 | Livingston | Louisiana | 22063 | 3566 | 71 |
529100 | 529100 | 2020-09-13 | Livingston | Louisiana | 22063 | 3558 | 71 |
525864 | 525864 | 2020-09-12 | Livingston | Louisiana | 22063 | 3537 | 70 |
522628 | 522628 | 2020-09-11 | Livingston | Louisiana | 22063 | 3537 | 70 |
519391 | 519391 | 2020-09-10 | Livingston | Louisiana | 22063 | 3517 | 69 |
516156 | 516156 | 2020-09-09 | Livingston | Louisiana | 22063 | 3514 | 69 |
512923 | 512923 | 2020-09-08 | Livingston | Louisiana | 22063 | 3495 | 69 |
509691 | 509691 | 2020-09-07 | Livingston | Louisiana | 22063 | 3475 | 68 |
506458 | 506458 | 2020-09-06 | Livingston | Louisiana | 22063 | 3474 | 67 |
503224 | 503224 | 2020-09-05 | Livingston | Louisiana | 22063 | 3457 | 66 |
499991 | 499991 | 2020-09-04 | Livingston | Louisiana | 22063 | 3457 | 66 |
496757 | 496757 | 2020-09-03 | Livingston | Louisiana | 22063 | 3448 | 66 |
493524 | 493524 | 2020-09-02 | Livingston | Louisiana | 22063 | 3429 | 66 |
490290 | 490290 | 2020-09-01 | Livingston | Louisiana | 22063 | 3405 | 66 |
487057 | 487057 | 2020-08-31 | Livingston | Louisiana | 22063 | 3364 | 66 |
483822 | 483822 | 2020-08-30 | Livingston | Louisiana | 22063 | 3368 | 65 |
480588 | 480588 | 2020-08-29 | Livingston | Louisiana | 22063 | 3356 | 64 |
477355 | 477355 | 2020-08-28 | Livingston | Louisiana | 22063 | 3356 | 64 |
474122 | 474122 | 2020-08-27 | Livingston | Louisiana | 22063 | 3330 | 64 |
470890 | 470890 | 2020-08-26 | Livingston | Louisiana | 22063 | 3325 | 64 |
467661 | 467661 | 2020-08-25 | Livingston | Louisiana | 22063 | 3313 | 63 |
464432 | 464432 | 2020-08-24 | Livingston | Louisiana | 22063 | 3279 | 62 |
461201 | 461201 | 2020-08-23 | Livingston | Louisiana | 22063 | 3266 | 62 |
457974 | 457974 | 2020-08-22 | Livingston | Louisiana | 22063 | 3236 | 60 |
454746 | 454746 | 2020-08-21 | Livingston | Louisiana | 22063 | 3236 | 60 |
451518 | 451518 | 2020-08-20 | Livingston | Louisiana | 22063 | 3197 | 60 |
448290 | 448290 | 2020-08-19 | Livingston | Louisiana | 22063 | 3170 | 59 |
445063 | 445063 | 2020-08-18 | Livingston | Louisiana | 22063 | 3146 | 59 |
441837 | 441837 | 2020-08-17 | Livingston | Louisiana | 22063 | 3119 | 57 |
438610 | 438610 | 2020-08-16 | Livingston | Louisiana | 22063 | 3100 | 56 |
435385 | 435385 | 2020-08-15 | Livingston | Louisiana | 22063 | 3071 | 54 |
432160 | 432160 | 2020-08-14 | Livingston | Louisiana | 22063 | 3071 | 54 |
428932 | 428932 | 2020-08-13 | Livingston | Louisiana | 22063 | 3027 | 54 |
425708 | 425708 | 2020-08-12 | Livingston | Louisiana | 22063 | 2992 | 52 |
422487 | 422487 | 2020-08-11 | Livingston | Louisiana | 22063 | 2975 | 52 |
419265 | 419265 | 2020-08-10 | Livingston | Louisiana | 22063 | 2938 | 51 |
416044 | 416044 | 2020-08-09 | Livingston | Louisiana | 22063 | 2924 | 51 |
412824 | 412824 | 2020-08-08 | Livingston | Louisiana | 22063 | 2845 | 51 |
409604 | 409604 | 2020-08-07 | Livingston | Louisiana | 22063 | 2845 | 51 |
406384 | 406384 | 2020-08-06 | Livingston | Louisiana | 22063 | 2800 | 50 |
403166 | 403166 | 2020-08-05 | Livingston | Louisiana | 22063 | 2754 | 49 |
399949 | 399949 | 2020-08-04 | Livingston | Louisiana | 22063 | 2718 | 49 |
396734 | 396734 | 2020-08-03 | Livingston | Louisiana | 22063 | 2680 | 49 |
393518 | 393518 | 2020-08-02 | Livingston | Louisiana | 22063 | 2660 | 49 |
390301 | 390301 | 2020-08-01 | Livingston | Louisiana | 22063 | 2561 | 48 |
387084 | 387084 | 2020-07-31 | Livingston | Louisiana | 22063 | 2561 | 48 |
383866 | 383866 | 2020-07-30 | Livingston | Louisiana | 22063 | 2521 | 48 |
380649 | 380649 | 2020-07-29 | Livingston | Louisiana | 22063 | 2463 | 48 |
377432 | 377432 | 2020-07-28 | Livingston | Louisiana | 22063 | 2412 | 47 |
374217 | 374217 | 2020-07-27 | Livingston | Louisiana | 22063 | 2380 | 47 |
371005 | 371005 | 2020-07-26 | Livingston | Louisiana | 22063 | 2298 | 47 |
367795 | 367795 | 2020-07-25 | Livingston | Louisiana | 22063 | 2212 | 47 |
364588 | 364588 | 2020-07-24 | Livingston | Louisiana | 22063 | 2212 | 47 |
361381 | 361381 | 2020-07-23 | Livingston | Louisiana | 22063 | 2166 | 46 |
358176 | 358176 | 2020-07-22 | Livingston | Louisiana | 22063 | 2097 | 45 |
354973 | 354973 | 2020-07-21 | Livingston | Louisiana | 22063 | 2043 | 44 |
351771 | 351771 | 2020-07-20 | Livingston | Louisiana | 22063 | 1990 | 43 |
348571 | 348571 | 2020-07-19 | Livingston | Louisiana | 22063 | 1892 | 42 |
345370 | 345370 | 2020-07-18 | Livingston | Louisiana | 22063 | 1796 | 42 |
342170 | 342170 | 2020-07-17 | Livingston | Louisiana | 22063 | 1796 | 42 |
338974 | 338974 | 2020-07-16 | Livingston | Louisiana | 22063 | 1721 | 41 |
335778 | 335778 | 2020-07-15 | Livingston | Louisiana | 22063 | 1685 | 41 |
332585 | 332585 | 2020-07-14 | Livingston | Louisiana | 22063 | 1645 | 41 |
329398 | 329398 | 2020-07-13 | Livingston | Louisiana | 22063 | 1565 | 40 |
326212 | 326212 | 2020-07-12 | Livingston | Louisiana | 22063 | 1528 | 40 |
323029 | 323029 | 2020-07-11 | Livingston | Louisiana | 22063 | 1484 | 40 |
319850 | 319850 | 2020-07-10 | Livingston | Louisiana | 22063 | 1424 | 40 |
316675 | 316675 | 2020-07-09 | Livingston | Louisiana | 22063 | 1344 | 40 |
313501 | 313501 | 2020-07-08 | Livingston | Louisiana | 22063 | 1305 | 40 |
310331 | 310331 | 2020-07-07 | Livingston | Louisiana | 22063 | 1267 | 39 |
307163 | 307163 | 2020-07-06 | Livingston | Louisiana | 22063 | 1181 | 39 |
303996 | 303996 | 2020-07-05 | Livingston | Louisiana | 22063 | 1156 | 38 |
300832 | 300832 | 2020-07-04 | Livingston | Louisiana | 22063 | 1102 | 38 |
297670 | 297670 | 2020-07-03 | Livingston | Louisiana | 22063 | 1102 | 38 |
294512 | 294512 | 2020-07-02 | Livingston | Louisiana | 22063 | 1025 | 38 |
291358 | 291358 | 2020-07-01 | Livingston | Louisiana | 22063 | 983 | 38 |
288207 | 288207 | 2020-06-30 | Livingston | Louisiana | 22063 | 903 | 37 |
285058 | 285058 | 2020-06-29 | Livingston | Louisiana | 22063 | 860 | 37 |
281912 | 281912 | 2020-06-28 | Livingston | Louisiana | 22063 | 846 | 37 |
278764 | 278764 | 2020-06-27 | Livingston | Louisiana | 22063 | 814 | 37 |
275616 | 275616 | 2020-06-26 | Livingston | Louisiana | 22063 | 814 | 37 |
272473 | 272473 | 2020-06-25 | Livingston | Louisiana | 22063 | 794 | 36 |
269337 | 269337 | 2020-06-24 | Livingston | Louisiana | 22063 | 768 | 36 |
266204 | 266204 | 2020-06-23 | Livingston | Louisiana | 22063 | 751 | 36 |
263077 | 263077 | 2020-06-22 | Livingston | Louisiana | 22063 | 690 | 36 |
259948 | 259948 | 2020-06-21 | Livingston | Louisiana | 22063 | 683 | 35 |
256822 | 256822 | 2020-06-20 | Livingston | Louisiana | 22063 | 669 | 35 |
253702 | 253702 | 2020-06-19 | Livingston | Louisiana | 22063 | 638 | 34 |
250587 | 250587 | 2020-06-18 | Livingston | Louisiana | 22063 | 573 | 33 |
247475 | 247475 | 2020-06-17 | Livingston | Louisiana | 22063 | 573 | 33 |
244362 | 244362 | 2020-06-16 | Livingston | Louisiana | 22063 | 561 | 33 |
241251 | 241251 | 2020-06-15 | Livingston | Louisiana | 22063 | 546 | 32 |
238142 | 238142 | 2020-06-14 | Livingston | Louisiana | 22063 | 526 | 32 |
235035 | 235035 | 2020-06-13 | Livingston | Louisiana | 22063 | 525 | 31 |
231930 | 231930 | 2020-06-12 | Livingston | Louisiana | 22063 | 514 | 31 |
228826 | 228826 | 2020-06-11 | Livingston | Louisiana | 22063 | 495 | 31 |
225724 | 225724 | 2020-06-10 | Livingston | Louisiana | 22063 | 484 | 31 |
222628 | 222628 | 2020-06-09 | Livingston | Louisiana | 22063 | 481 | 31 |
219533 | 219533 | 2020-06-08 | Livingston | Louisiana | 22063 | 468 | 31 |
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);