ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 22109 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535595 | 535595 | 2020-09-15 | Terrebonne | Louisiana | 22109 | 3512 | 107 |
532360 | 532360 | 2020-09-14 | Terrebonne | Louisiana | 22109 | 3519 | 106 |
529123 | 529123 | 2020-09-13 | Terrebonne | Louisiana | 22109 | 3511 | 106 |
525887 | 525887 | 2020-09-12 | Terrebonne | Louisiana | 22109 | 3485 | 106 |
522651 | 522651 | 2020-09-11 | Terrebonne | Louisiana | 22109 | 3485 | 106 |
519414 | 519414 | 2020-09-10 | Terrebonne | Louisiana | 22109 | 3472 | 104 |
516179 | 516179 | 2020-09-09 | Terrebonne | Louisiana | 22109 | 3459 | 104 |
512946 | 512946 | 2020-09-08 | Terrebonne | Louisiana | 22109 | 3445 | 103 |
509714 | 509714 | 2020-09-07 | Terrebonne | Louisiana | 22109 | 3433 | 102 |
506481 | 506481 | 2020-09-06 | Terrebonne | Louisiana | 22109 | 3421 | 102 |
503247 | 503247 | 2020-09-05 | Terrebonne | Louisiana | 22109 | 3385 | 99 |
500014 | 500014 | 2020-09-04 | Terrebonne | Louisiana | 22109 | 3385 | 99 |
496780 | 496780 | 2020-09-03 | Terrebonne | Louisiana | 22109 | 3372 | 99 |
493547 | 493547 | 2020-09-02 | Terrebonne | Louisiana | 22109 | 3366 | 99 |
490313 | 490313 | 2020-09-01 | Terrebonne | Louisiana | 22109 | 3347 | 99 |
487080 | 487080 | 2020-08-31 | Terrebonne | Louisiana | 22109 | 3343 | 99 |
483845 | 483845 | 2020-08-30 | Terrebonne | Louisiana | 22109 | 3333 | 98 |
480611 | 480611 | 2020-08-29 | Terrebonne | Louisiana | 22109 | 3294 | 97 |
477378 | 477378 | 2020-08-28 | Terrebonne | Louisiana | 22109 | 3294 | 97 |
474145 | 474145 | 2020-08-27 | Terrebonne | Louisiana | 22109 | 3296 | 96 |
470913 | 470913 | 2020-08-26 | Terrebonne | Louisiana | 22109 | 3285 | 95 |
467684 | 467684 | 2020-08-25 | Terrebonne | Louisiana | 22109 | 3259 | 94 |
464455 | 464455 | 2020-08-24 | Terrebonne | Louisiana | 22109 | 3333 | 94 |
461224 | 461224 | 2020-08-23 | Terrebonne | Louisiana | 22109 | 3315 | 94 |
457997 | 457997 | 2020-08-22 | Terrebonne | Louisiana | 22109 | 3285 | 93 |
454769 | 454769 | 2020-08-21 | Terrebonne | Louisiana | 22109 | 3285 | 93 |
451541 | 451541 | 2020-08-20 | Terrebonne | Louisiana | 22109 | 3258 | 90 |
448313 | 448313 | 2020-08-19 | Terrebonne | Louisiana | 22109 | 3239 | 90 |
445086 | 445086 | 2020-08-18 | Terrebonne | Louisiana | 22109 | 3227 | 90 |
441860 | 441860 | 2020-08-17 | Terrebonne | Louisiana | 22109 | 3212 | 90 |
438633 | 438633 | 2020-08-16 | Terrebonne | Louisiana | 22109 | 3196 | 90 |
435408 | 435408 | 2020-08-15 | Terrebonne | Louisiana | 22109 | 3160 | 86 |
432183 | 432183 | 2020-08-14 | Terrebonne | Louisiana | 22109 | 3160 | 86 |
428955 | 428955 | 2020-08-13 | Terrebonne | Louisiana | 22109 | 3115 | 86 |
425731 | 425731 | 2020-08-12 | Terrebonne | Louisiana | 22109 | 3095 | 86 |
422510 | 422510 | 2020-08-11 | Terrebonne | Louisiana | 22109 | 3072 | 85 |
419288 | 419288 | 2020-08-10 | Terrebonne | Louisiana | 22109 | 3057 | 85 |
416067 | 416067 | 2020-08-09 | Terrebonne | Louisiana | 22109 | 3035 | 85 |
412847 | 412847 | 2020-08-08 | Terrebonne | Louisiana | 22109 | 2986 | 85 |
409627 | 409627 | 2020-08-07 | Terrebonne | Louisiana | 22109 | 2986 | 85 |
406407 | 406407 | 2020-08-06 | Terrebonne | Louisiana | 22109 | 2941 | 84 |
403189 | 403189 | 2020-08-05 | Terrebonne | Louisiana | 22109 | 2899 | 80 |
399972 | 399972 | 2020-08-04 | Terrebonne | Louisiana | 22109 | 2866 | 80 |
396757 | 396757 | 2020-08-03 | Terrebonne | Louisiana | 22109 | 2800 | 78 |
393541 | 393541 | 2020-08-02 | Terrebonne | Louisiana | 22109 | 2781 | 78 |
390324 | 390324 | 2020-08-01 | Terrebonne | Louisiana | 22109 | 2693 | 74 |
387107 | 387107 | 2020-07-31 | Terrebonne | Louisiana | 22109 | 2693 | 74 |
383889 | 383889 | 2020-07-30 | Terrebonne | Louisiana | 22109 | 2653 | 73 |
380672 | 380672 | 2020-07-29 | Terrebonne | Louisiana | 22109 | 2601 | 73 |
377455 | 377455 | 2020-07-28 | Terrebonne | Louisiana | 22109 | 2546 | 72 |
374240 | 374240 | 2020-07-27 | Terrebonne | Louisiana | 22109 | 2519 | 72 |
371028 | 371028 | 2020-07-26 | Terrebonne | Louisiana | 22109 | 2453 | 72 |
367818 | 367818 | 2020-07-25 | Terrebonne | Louisiana | 22109 | 2332 | 69 |
364611 | 364611 | 2020-07-24 | Terrebonne | Louisiana | 22109 | 2332 | 69 |
361404 | 361404 | 2020-07-23 | Terrebonne | Louisiana | 22109 | 2254 | 69 |
358199 | 358199 | 2020-07-22 | Terrebonne | Louisiana | 22109 | 2173 | 69 |
354996 | 354996 | 2020-07-21 | Terrebonne | Louisiana | 22109 | 2136 | 69 |
351794 | 351794 | 2020-07-20 | Terrebonne | Louisiana | 22109 | 2124 | 68 |
348594 | 348594 | 2020-07-19 | Terrebonne | Louisiana | 22109 | 2071 | 68 |
345393 | 345393 | 2020-07-18 | Terrebonne | Louisiana | 22109 | 1963 | 68 |
342193 | 342193 | 2020-07-17 | Terrebonne | Louisiana | 22109 | 1963 | 68 |
338997 | 338997 | 2020-07-16 | Terrebonne | Louisiana | 22109 | 1901 | 67 |
335801 | 335801 | 2020-07-15 | Terrebonne | Louisiana | 22109 | 1824 | 67 |
332608 | 332608 | 2020-07-14 | Terrebonne | Louisiana | 22109 | 1750 | 67 |
329421 | 329421 | 2020-07-13 | Terrebonne | Louisiana | 22109 | 1734 | 67 |
326235 | 326235 | 2020-07-12 | Terrebonne | Louisiana | 22109 | 1661 | 66 |
323052 | 323052 | 2020-07-11 | Terrebonne | Louisiana | 22109 | 1588 | 66 |
319873 | 319873 | 2020-07-10 | Terrebonne | Louisiana | 22109 | 1535 | 65 |
316698 | 316698 | 2020-07-09 | Terrebonne | Louisiana | 22109 | 1415 | 63 |
313524 | 313524 | 2020-07-08 | Terrebonne | Louisiana | 22109 | 1372 | 63 |
310354 | 310354 | 2020-07-07 | Terrebonne | Louisiana | 22109 | 1309 | 63 |
307186 | 307186 | 2020-07-06 | Terrebonne | Louisiana | 22109 | 1277 | 61 |
304019 | 304019 | 2020-07-05 | Terrebonne | Louisiana | 22109 | 1228 | 61 |
300855 | 300855 | 2020-07-04 | Terrebonne | Louisiana | 22109 | 1147 | 61 |
297693 | 297693 | 2020-07-03 | Terrebonne | Louisiana | 22109 | 1147 | 61 |
294535 | 294535 | 2020-07-02 | Terrebonne | Louisiana | 22109 | 1094 | 61 |
291381 | 291381 | 2020-07-01 | Terrebonne | Louisiana | 22109 | 1068 | 61 |
288230 | 288230 | 2020-06-30 | Terrebonne | Louisiana | 22109 | 1030 | 61 |
285081 | 285081 | 2020-06-29 | Terrebonne | Louisiana | 22109 | 1011 | 61 |
281935 | 281935 | 2020-06-28 | Terrebonne | Louisiana | 22109 | 988 | 61 |
278787 | 278787 | 2020-06-27 | Terrebonne | Louisiana | 22109 | 931 | 60 |
275639 | 275639 | 2020-06-26 | Terrebonne | Louisiana | 22109 | 931 | 60 |
272496 | 272496 | 2020-06-25 | Terrebonne | Louisiana | 22109 | 884 | 60 |
269360 | 269360 | 2020-06-24 | Terrebonne | Louisiana | 22109 | 874 | 60 |
266227 | 266227 | 2020-06-23 | Terrebonne | Louisiana | 22109 | 866 | 60 |
263100 | 263100 | 2020-06-22 | Terrebonne | Louisiana | 22109 | 857 | 60 |
259971 | 259971 | 2020-06-21 | Terrebonne | Louisiana | 22109 | 848 | 60 |
256845 | 256845 | 2020-06-20 | Terrebonne | Louisiana | 22109 | 839 | 60 |
253725 | 253725 | 2020-06-19 | Terrebonne | Louisiana | 22109 | 826 | 59 |
250610 | 250610 | 2020-06-18 | Terrebonne | Louisiana | 22109 | 826 | 58 |
247498 | 247498 | 2020-06-17 | Terrebonne | Louisiana | 22109 | 826 | 58 |
244385 | 244385 | 2020-06-16 | Terrebonne | Louisiana | 22109 | 818 | 58 |
241274 | 241274 | 2020-06-15 | Terrebonne | Louisiana | 22109 | 812 | 57 |
238165 | 238165 | 2020-06-14 | Terrebonne | Louisiana | 22109 | 801 | 57 |
235058 | 235058 | 2020-06-13 | Terrebonne | Louisiana | 22109 | 792 | 57 |
231953 | 231953 | 2020-06-12 | Terrebonne | Louisiana | 22109 | 780 | 57 |
228849 | 228849 | 2020-06-11 | Terrebonne | Louisiana | 22109 | 771 | 56 |
225747 | 225747 | 2020-06-10 | Terrebonne | Louisiana | 22109 | 761 | 56 |
222651 | 222651 | 2020-06-09 | Terrebonne | Louisiana | 22109 | 756 | 55 |
219556 | 219556 | 2020-06-08 | Terrebonne | Louisiana | 22109 | 748 | 55 |
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);