ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 22057 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535570 | 535570 | 2020-09-15 | Lafourche | Louisiana | 22057 | 3467 | 118 |
532335 | 532335 | 2020-09-14 | Lafourche | Louisiana | 22057 | 3447 | 118 |
529098 | 529098 | 2020-09-13 | Lafourche | Louisiana | 22057 | 3435 | 118 |
525862 | 525862 | 2020-09-12 | Lafourche | Louisiana | 22057 | 3404 | 118 |
522626 | 522626 | 2020-09-11 | Lafourche | Louisiana | 22057 | 3404 | 118 |
519389 | 519389 | 2020-09-10 | Lafourche | Louisiana | 22057 | 3400 | 115 |
516154 | 516154 | 2020-09-09 | Lafourche | Louisiana | 22057 | 3387 | 115 |
512921 | 512921 | 2020-09-08 | Lafourche | Louisiana | 22057 | 3360 | 115 |
509689 | 509689 | 2020-09-07 | Lafourche | Louisiana | 22057 | 3350 | 114 |
506456 | 506456 | 2020-09-06 | Lafourche | Louisiana | 22057 | 3341 | 112 |
503222 | 503222 | 2020-09-05 | Lafourche | Louisiana | 22057 | 3326 | 111 |
499989 | 499989 | 2020-09-04 | Lafourche | Louisiana | 22057 | 3326 | 111 |
496755 | 496755 | 2020-09-03 | Lafourche | Louisiana | 22057 | 3312 | 110 |
493522 | 493522 | 2020-09-02 | Lafourche | Louisiana | 22057 | 3298 | 110 |
490288 | 490288 | 2020-09-01 | Lafourche | Louisiana | 22057 | 3284 | 109 |
487055 | 487055 | 2020-08-31 | Lafourche | Louisiana | 22057 | 3268 | 108 |
483820 | 483820 | 2020-08-30 | Lafourche | Louisiana | 22057 | 3263 | 108 |
480586 | 480586 | 2020-08-29 | Lafourche | Louisiana | 22057 | 3245 | 108 |
477353 | 477353 | 2020-08-28 | Lafourche | Louisiana | 22057 | 3245 | 108 |
474120 | 474120 | 2020-08-27 | Lafourche | Louisiana | 22057 | 3236 | 107 |
470888 | 470888 | 2020-08-26 | Lafourche | Louisiana | 22057 | 3216 | 107 |
467659 | 467659 | 2020-08-25 | Lafourche | Louisiana | 22057 | 3211 | 107 |
464430 | 464430 | 2020-08-24 | Lafourche | Louisiana | 22057 | 3111 | 107 |
461199 | 461199 | 2020-08-23 | Lafourche | Louisiana | 22057 | 3101 | 107 |
457972 | 457972 | 2020-08-22 | Lafourche | Louisiana | 22057 | 3073 | 107 |
454744 | 454744 | 2020-08-21 | Lafourche | Louisiana | 22057 | 3073 | 107 |
451516 | 451516 | 2020-08-20 | Lafourche | Louisiana | 22057 | 3061 | 107 |
448288 | 448288 | 2020-08-19 | Lafourche | Louisiana | 22057 | 3044 | 106 |
445061 | 445061 | 2020-08-18 | Lafourche | Louisiana | 22057 | 3030 | 105 |
441835 | 441835 | 2020-08-17 | Lafourche | Louisiana | 22057 | 3014 | 105 |
438608 | 438608 | 2020-08-16 | Lafourche | Louisiana | 22057 | 2985 | 104 |
435383 | 435383 | 2020-08-15 | Lafourche | Louisiana | 22057 | 2949 | 104 |
432158 | 432158 | 2020-08-14 | Lafourche | Louisiana | 22057 | 2949 | 104 |
428930 | 428930 | 2020-08-13 | Lafourche | Louisiana | 22057 | 2916 | 102 |
425706 | 425706 | 2020-08-12 | Lafourche | Louisiana | 22057 | 2895 | 100 |
422485 | 422485 | 2020-08-11 | Lafourche | Louisiana | 22057 | 2863 | 99 |
419263 | 419263 | 2020-08-10 | Lafourche | Louisiana | 22057 | 2839 | 99 |
416042 | 416042 | 2020-08-09 | Lafourche | Louisiana | 22057 | 2800 | 99 |
412822 | 412822 | 2020-08-08 | Lafourche | Louisiana | 22057 | 2759 | 97 |
409602 | 409602 | 2020-08-07 | Lafourche | Louisiana | 22057 | 2759 | 97 |
406382 | 406382 | 2020-08-06 | Lafourche | Louisiana | 22057 | 2719 | 96 |
403164 | 403164 | 2020-08-05 | Lafourche | Louisiana | 22057 | 2684 | 96 |
399947 | 399947 | 2020-08-04 | Lafourche | Louisiana | 22057 | 2656 | 96 |
396732 | 396732 | 2020-08-03 | Lafourche | Louisiana | 22057 | 2589 | 96 |
393516 | 393516 | 2020-08-02 | Lafourche | Louisiana | 22057 | 2572 | 96 |
390299 | 390299 | 2020-08-01 | Lafourche | Louisiana | 22057 | 2516 | 96 |
387082 | 387082 | 2020-07-31 | Lafourche | Louisiana | 22057 | 2516 | 96 |
383864 | 383864 | 2020-07-30 | Lafourche | Louisiana | 22057 | 2468 | 96 |
380647 | 380647 | 2020-07-29 | Lafourche | Louisiana | 22057 | 2446 | 96 |
377430 | 377430 | 2020-07-28 | Lafourche | Louisiana | 22057 | 2404 | 95 |
374215 | 374215 | 2020-07-27 | Lafourche | Louisiana | 22057 | 2393 | 95 |
371003 | 371003 | 2020-07-26 | Lafourche | Louisiana | 22057 | 2319 | 95 |
367793 | 367793 | 2020-07-25 | Lafourche | Louisiana | 22057 | 2237 | 94 |
364586 | 364586 | 2020-07-24 | Lafourche | Louisiana | 22057 | 2237 | 94 |
361379 | 361379 | 2020-07-23 | Lafourche | Louisiana | 22057 | 2194 | 94 |
358174 | 358174 | 2020-07-22 | Lafourche | Louisiana | 22057 | 2140 | 95 |
354971 | 354971 | 2020-07-21 | Lafourche | Louisiana | 22057 | 2095 | 92 |
351769 | 351769 | 2020-07-20 | Lafourche | Louisiana | 22057 | 2045 | 92 |
348569 | 348569 | 2020-07-19 | Lafourche | Louisiana | 22057 | 1928 | 92 |
345368 | 345368 | 2020-07-18 | Lafourche | Louisiana | 22057 | 1842 | 91 |
342168 | 342168 | 2020-07-17 | Lafourche | Louisiana | 22057 | 1842 | 91 |
338972 | 338972 | 2020-07-16 | Lafourche | Louisiana | 22057 | 1795 | 91 |
335776 | 335776 | 2020-07-15 | Lafourche | Louisiana | 22057 | 1721 | 91 |
332583 | 332583 | 2020-07-14 | Lafourche | Louisiana | 22057 | 1677 | 91 |
329396 | 329396 | 2020-07-13 | Lafourche | Louisiana | 22057 | 1612 | 91 |
326210 | 326210 | 2020-07-12 | Lafourche | Louisiana | 22057 | 1567 | 91 |
323027 | 323027 | 2020-07-11 | Lafourche | Louisiana | 22057 | 1531 | 91 |
319848 | 319848 | 2020-07-10 | Lafourche | Louisiana | 22057 | 1479 | 90 |
316673 | 316673 | 2020-07-09 | Lafourche | Louisiana | 22057 | 1422 | 90 |
313499 | 313499 | 2020-07-08 | Lafourche | Louisiana | 22057 | 1386 | 90 |
310329 | 310329 | 2020-07-07 | Lafourche | Louisiana | 22057 | 1339 | 90 |
307161 | 307161 | 2020-07-06 | Lafourche | Louisiana | 22057 | 1304 | 90 |
303994 | 303994 | 2020-07-05 | Lafourche | Louisiana | 22057 | 1284 | 90 |
300830 | 300830 | 2020-07-04 | Lafourche | Louisiana | 22057 | 1248 | 89 |
297668 | 297668 | 2020-07-03 | Lafourche | Louisiana | 22057 | 1248 | 89 |
294510 | 294510 | 2020-07-02 | Lafourche | Louisiana | 22057 | 1201 | 89 |
291356 | 291356 | 2020-07-01 | Lafourche | Louisiana | 22057 | 1177 | 89 |
288205 | 288205 | 2020-06-30 | Lafourche | Louisiana | 22057 | 1149 | 87 |
285056 | 285056 | 2020-06-29 | Lafourche | Louisiana | 22057 | 1119 | 86 |
281910 | 281910 | 2020-06-28 | Lafourche | Louisiana | 22057 | 1097 | 86 |
278762 | 278762 | 2020-06-27 | Lafourche | Louisiana | 22057 | 1071 | 85 |
275614 | 275614 | 2020-06-26 | Lafourche | Louisiana | 22057 | 1071 | 85 |
272471 | 272471 | 2020-06-25 | Lafourche | Louisiana | 22057 | 1064 | 85 |
269335 | 269335 | 2020-06-24 | Lafourche | Louisiana | 22057 | 1056 | 83 |
266202 | 266202 | 2020-06-23 | Lafourche | Louisiana | 22057 | 1034 | 83 |
263075 | 263075 | 2020-06-22 | Lafourche | Louisiana | 22057 | 1027 | 83 |
259946 | 259946 | 2020-06-21 | Lafourche | Louisiana | 22057 | 1010 | 83 |
256820 | 256820 | 2020-06-20 | Lafourche | Louisiana | 22057 | 1005 | 83 |
253700 | 253700 | 2020-06-19 | Lafourche | Louisiana | 22057 | 998 | 83 |
250585 | 250585 | 2020-06-18 | Lafourche | Louisiana | 22057 | 1013 | 78 |
247473 | 247473 | 2020-06-17 | Lafourche | Louisiana | 22057 | 1013 | 78 |
244360 | 244360 | 2020-06-16 | Lafourche | Louisiana | 22057 | 999 | 77 |
241249 | 241249 | 2020-06-15 | Lafourche | Louisiana | 22057 | 983 | 77 |
238140 | 238140 | 2020-06-14 | Lafourche | Louisiana | 22057 | 973 | 77 |
235033 | 235033 | 2020-06-13 | Lafourche | Louisiana | 22057 | 968 | 77 |
231928 | 231928 | 2020-06-12 | Lafourche | Louisiana | 22057 | 945 | 77 |
228824 | 228824 | 2020-06-11 | Lafourche | Louisiana | 22057 | 937 | 77 |
225722 | 225722 | 2020-06-10 | Lafourche | Louisiana | 22057 | 928 | 76 |
222626 | 222626 | 2020-06-09 | Lafourche | Louisiana | 22057 | 922 | 76 |
219531 | 219531 | 2020-06-08 | Lafourche | Louisiana | 22057 | 909 | 75 |
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);