ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "St. Landry" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535589 | 535589 | 2020-09-15 | St. Landry | Louisiana | 22097 | 3230 | 120 |
532354 | 532354 | 2020-09-14 | St. Landry | Louisiana | 22097 | 3232 | 120 |
529117 | 529117 | 2020-09-13 | St. Landry | Louisiana | 22097 | 3230 | 120 |
525881 | 525881 | 2020-09-12 | St. Landry | Louisiana | 22097 | 3220 | 116 |
522645 | 522645 | 2020-09-11 | St. Landry | Louisiana | 22097 | 3220 | 116 |
519408 | 519408 | 2020-09-10 | St. Landry | Louisiana | 22097 | 3205 | 116 |
516173 | 516173 | 2020-09-09 | St. Landry | Louisiana | 22097 | 3209 | 116 |
512940 | 512940 | 2020-09-08 | St. Landry | Louisiana | 22097 | 3160 | 116 |
509708 | 509708 | 2020-09-07 | St. Landry | Louisiana | 22097 | 3156 | 116 |
506475 | 506475 | 2020-09-06 | St. Landry | Louisiana | 22097 | 3161 | 116 |
503241 | 503241 | 2020-09-05 | St. Landry | Louisiana | 22097 | 3141 | 115 |
500008 | 500008 | 2020-09-04 | St. Landry | Louisiana | 22097 | 3141 | 115 |
496774 | 496774 | 2020-09-03 | St. Landry | Louisiana | 22097 | 3139 | 115 |
493541 | 493541 | 2020-09-02 | St. Landry | Louisiana | 22097 | 3130 | 114 |
490307 | 490307 | 2020-09-01 | St. Landry | Louisiana | 22097 | 3110 | 115 |
487074 | 487074 | 2020-08-31 | St. Landry | Louisiana | 22097 | 3098 | 113 |
483839 | 483839 | 2020-08-30 | St. Landry | Louisiana | 22097 | 3096 | 112 |
480605 | 480605 | 2020-08-29 | St. Landry | Louisiana | 22097 | 3032 | 110 |
477372 | 477372 | 2020-08-28 | St. Landry | Louisiana | 22097 | 3032 | 110 |
474139 | 474139 | 2020-08-27 | St. Landry | Louisiana | 22097 | 3026 | 110 |
470907 | 470907 | 2020-08-26 | St. Landry | Louisiana | 22097 | 3021 | 110 |
467678 | 467678 | 2020-08-25 | St. Landry | Louisiana | 22097 | 3006 | 109 |
464449 | 464449 | 2020-08-24 | St. Landry | Louisiana | 22097 | 3001 | 108 |
461218 | 461218 | 2020-08-23 | St. Landry | Louisiana | 22097 | 3000 | 107 |
457991 | 457991 | 2020-08-22 | St. Landry | Louisiana | 22097 | 2976 | 105 |
454763 | 454763 | 2020-08-21 | St. Landry | Louisiana | 22097 | 2976 | 105 |
451535 | 451535 | 2020-08-20 | St. Landry | Louisiana | 22097 | 2968 | 102 |
448307 | 448307 | 2020-08-19 | St. Landry | Louisiana | 22097 | 2950 | 102 |
445080 | 445080 | 2020-08-18 | St. Landry | Louisiana | 22097 | 2925 | 98 |
441854 | 441854 | 2020-08-17 | St. Landry | Louisiana | 22097 | 2908 | 96 |
438627 | 438627 | 2020-08-16 | St. Landry | Louisiana | 22097 | 2895 | 96 |
435402 | 435402 | 2020-08-15 | St. Landry | Louisiana | 22097 | 2866 | 93 |
432177 | 432177 | 2020-08-14 | St. Landry | Louisiana | 22097 | 2866 | 93 |
428949 | 428949 | 2020-08-13 | St. Landry | Louisiana | 22097 | 2841 | 92 |
425725 | 425725 | 2020-08-12 | St. Landry | Louisiana | 22097 | 2824 | 92 |
422504 | 422504 | 2020-08-11 | St. Landry | Louisiana | 22097 | 2778 | 91 |
419282 | 419282 | 2020-08-10 | St. Landry | Louisiana | 22097 | 2735 | 90 |
416061 | 416061 | 2020-08-09 | St. Landry | Louisiana | 22097 | 2727 | 86 |
412841 | 412841 | 2020-08-08 | St. Landry | Louisiana | 22097 | 2631 | 85 |
409621 | 409621 | 2020-08-07 | St. Landry | Louisiana | 22097 | 2631 | 85 |
406401 | 406401 | 2020-08-06 | St. Landry | Louisiana | 22097 | 2583 | 83 |
403183 | 403183 | 2020-08-05 | St. Landry | Louisiana | 22097 | 2556 | 81 |
399966 | 399966 | 2020-08-04 | St. Landry | Louisiana | 22097 | 2530 | 78 |
396751 | 396751 | 2020-08-03 | St. Landry | Louisiana | 22097 | 2226 | 75 |
393535 | 393535 | 2020-08-02 | St. Landry | Louisiana | 22097 | 2183 | 74 |
390318 | 390318 | 2020-08-01 | St. Landry | Louisiana | 22097 | 2082 | 72 |
387101 | 387101 | 2020-07-31 | St. Landry | Louisiana | 22097 | 2082 | 72 |
383883 | 383883 | 2020-07-30 | St. Landry | Louisiana | 22097 | 2054 | 70 |
380666 | 380666 | 2020-07-29 | St. Landry | Louisiana | 22097 | 2034 | 70 |
377449 | 377449 | 2020-07-28 | St. Landry | Louisiana | 22097 | 1981 | 69 |
374234 | 374234 | 2020-07-27 | St. Landry | Louisiana | 22097 | 1927 | 69 |
371022 | 371022 | 2020-07-26 | St. Landry | Louisiana | 22097 | 1880 | 69 |
367812 | 367812 | 2020-07-25 | St. Landry | Louisiana | 22097 | 1774 | 69 |
364605 | 364605 | 2020-07-24 | St. Landry | Louisiana | 22097 | 1774 | 69 |
361398 | 361398 | 2020-07-23 | St. Landry | Louisiana | 22097 | 1737 | 68 |
358193 | 358193 | 2020-07-22 | St. Landry | Louisiana | 22097 | 1655 | 67 |
354990 | 354990 | 2020-07-21 | St. Landry | Louisiana | 22097 | 1552 | 66 |
351788 | 351788 | 2020-07-20 | St. Landry | Louisiana | 22097 | 1527 | 65 |
348588 | 348588 | 2020-07-19 | St. Landry | Louisiana | 22097 | 1437 | 63 |
345387 | 345387 | 2020-07-18 | St. Landry | Louisiana | 22097 | 1345 | 63 |
342187 | 342187 | 2020-07-17 | St. Landry | Louisiana | 22097 | 1345 | 63 |
338991 | 338991 | 2020-07-16 | St. Landry | Louisiana | 22097 | 1308 | 60 |
335795 | 335795 | 2020-07-15 | St. Landry | Louisiana | 22097 | 1243 | 60 |
332602 | 332602 | 2020-07-14 | St. Landry | Louisiana | 22097 | 1198 | 60 |
329415 | 329415 | 2020-07-13 | St. Landry | Louisiana | 22097 | 1159 | 60 |
326229 | 326229 | 2020-07-12 | St. Landry | Louisiana | 22097 | 1128 | 59 |
323046 | 323046 | 2020-07-11 | St. Landry | Louisiana | 22097 | 1080 | 59 |
319867 | 319867 | 2020-07-10 | St. Landry | Louisiana | 22097 | 1023 | 59 |
316692 | 316692 | 2020-07-09 | St. Landry | Louisiana | 22097 | 944 | 59 |
313518 | 313518 | 2020-07-08 | St. Landry | Louisiana | 22097 | 887 | 59 |
310348 | 310348 | 2020-07-07 | St. Landry | Louisiana | 22097 | 850 | 57 |
307180 | 307180 | 2020-07-06 | St. Landry | Louisiana | 22097 | 797 | 57 |
304013 | 304013 | 2020-07-05 | St. Landry | Louisiana | 22097 | 763 | 57 |
300849 | 300849 | 2020-07-04 | St. Landry | Louisiana | 22097 | 716 | 57 |
297687 | 297687 | 2020-07-03 | St. Landry | Louisiana | 22097 | 716 | 57 |
294529 | 294529 | 2020-07-02 | St. Landry | Louisiana | 22097 | 672 | 57 |
291375 | 291375 | 2020-07-01 | St. Landry | Louisiana | 22097 | 653 | 57 |
288224 | 288224 | 2020-06-30 | St. Landry | Louisiana | 22097 | 626 | 57 |
285075 | 285075 | 2020-06-29 | St. Landry | Louisiana | 22097 | 619 | 57 |
281929 | 281929 | 2020-06-28 | St. Landry | Louisiana | 22097 | 605 | 57 |
278781 | 278781 | 2020-06-27 | St. Landry | Louisiana | 22097 | 578 | 57 |
275633 | 275633 | 2020-06-26 | St. Landry | Louisiana | 22097 | 578 | 57 |
272490 | 272490 | 2020-06-25 | St. Landry | Louisiana | 22097 | 540 | 57 |
269354 | 269354 | 2020-06-24 | St. Landry | Louisiana | 22097 | 530 | 57 |
266221 | 266221 | 2020-06-23 | St. Landry | Louisiana | 22097 | 517 | 57 |
263094 | 263094 | 2020-06-22 | St. Landry | Louisiana | 22097 | 484 | 55 |
259965 | 259965 | 2020-06-21 | St. Landry | Louisiana | 22097 | 465 | 55 |
256839 | 256839 | 2020-06-20 | St. Landry | Louisiana | 22097 | 462 | 55 |
253719 | 253719 | 2020-06-19 | St. Landry | Louisiana | 22097 | 453 | 55 |
250604 | 250604 | 2020-06-18 | St. Landry | Louisiana | 22097 | 393 | 55 |
247492 | 247492 | 2020-06-17 | St. Landry | Louisiana | 22097 | 393 | 55 |
244379 | 244379 | 2020-06-16 | St. Landry | Louisiana | 22097 | 379 | 55 |
241268 | 241268 | 2020-06-15 | St. Landry | Louisiana | 22097 | 370 | 55 |
238159 | 238159 | 2020-06-14 | St. Landry | Louisiana | 22097 | 360 | 55 |
235052 | 235052 | 2020-06-13 | St. Landry | Louisiana | 22097 | 358 | 55 |
231947 | 231947 | 2020-06-12 | St. Landry | Louisiana | 22097 | 326 | 55 |
228843 | 228843 | 2020-06-11 | St. Landry | Louisiana | 22097 | 324 | 55 |
225741 | 225741 | 2020-06-10 | St. Landry | Louisiana | 22097 | 323 | 54 |
222645 | 222645 | 2020-06-09 | St. Landry | Louisiana | 22097 | 316 | 54 |
219550 | 219550 | 2020-06-08 | St. Landry | Louisiana | 22097 | 311 | 54 |
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);