ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Lafayette" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535569 | 535569 | 2020-09-15 | Lafayette | Louisiana | 22055 | 8709 | 122 |
532334 | 532334 | 2020-09-14 | Lafayette | Louisiana | 22055 | 8706 | 121 |
529097 | 529097 | 2020-09-13 | Lafayette | Louisiana | 22055 | 8687 | 116 |
525861 | 525861 | 2020-09-12 | Lafayette | Louisiana | 22055 | 8612 | 116 |
522625 | 522625 | 2020-09-11 | Lafayette | Louisiana | 22055 | 8612 | 116 |
519388 | 519388 | 2020-09-10 | Lafayette | Louisiana | 22055 | 8586 | 116 |
516153 | 516153 | 2020-09-09 | Lafayette | Louisiana | 22055 | 8570 | 116 |
512920 | 512920 | 2020-09-08 | Lafayette | Louisiana | 22055 | 8460 | 116 |
509688 | 509688 | 2020-09-07 | Lafayette | Louisiana | 22055 | 8449 | 115 |
506455 | 506455 | 2020-09-06 | Lafayette | Louisiana | 22055 | 8447 | 115 |
503221 | 503221 | 2020-09-05 | Lafayette | Louisiana | 22055 | 8402 | 113 |
499988 | 499988 | 2020-09-04 | Lafayette | Louisiana | 22055 | 8402 | 113 |
496754 | 496754 | 2020-09-03 | Lafayette | Louisiana | 22055 | 8365 | 112 |
493521 | 493521 | 2020-09-02 | Lafayette | Louisiana | 22055 | 8339 | 111 |
490287 | 490287 | 2020-09-01 | Lafayette | Louisiana | 22055 | 8275 | 111 |
487054 | 487054 | 2020-08-31 | Lafayette | Louisiana | 22055 | 8275 | 111 |
483819 | 483819 | 2020-08-30 | Lafayette | Louisiana | 22055 | 8251 | 110 |
480585 | 480585 | 2020-08-29 | Lafayette | Louisiana | 22055 | 8216 | 110 |
477352 | 477352 | 2020-08-28 | Lafayette | Louisiana | 22055 | 8216 | 110 |
474119 | 474119 | 2020-08-27 | Lafayette | Louisiana | 22055 | 8205 | 110 |
470887 | 470887 | 2020-08-26 | Lafayette | Louisiana | 22055 | 8183 | 110 |
467658 | 467658 | 2020-08-25 | Lafayette | Louisiana | 22055 | 8136 | 109 |
464429 | 464429 | 2020-08-24 | Lafayette | Louisiana | 22055 | 8168 | 106 |
461198 | 461198 | 2020-08-23 | Lafayette | Louisiana | 22055 | 8148 | 106 |
457971 | 457971 | 2020-08-22 | Lafayette | Louisiana | 22055 | 8103 | 103 |
454743 | 454743 | 2020-08-21 | Lafayette | Louisiana | 22055 | 8103 | 103 |
451515 | 451515 | 2020-08-20 | Lafayette | Louisiana | 22055 | 8074 | 104 |
448287 | 448287 | 2020-08-19 | Lafayette | Louisiana | 22055 | 8038 | 104 |
445060 | 445060 | 2020-08-18 | Lafayette | Louisiana | 22055 | 8005 | 102 |
441834 | 441834 | 2020-08-17 | Lafayette | Louisiana | 22055 | 7976 | 101 |
438607 | 438607 | 2020-08-16 | Lafayette | Louisiana | 22055 | 7947 | 101 |
435382 | 435382 | 2020-08-15 | Lafayette | Louisiana | 22055 | 7916 | 100 |
432157 | 432157 | 2020-08-14 | Lafayette | Louisiana | 22055 | 7916 | 100 |
428929 | 428929 | 2020-08-13 | Lafayette | Louisiana | 22055 | 7846 | 100 |
425705 | 425705 | 2020-08-12 | Lafayette | Louisiana | 22055 | 7793 | 100 |
422484 | 422484 | 2020-08-11 | Lafayette | Louisiana | 22055 | 7723 | 96 |
419262 | 419262 | 2020-08-10 | Lafayette | Louisiana | 22055 | 7643 | 96 |
416041 | 416041 | 2020-08-09 | Lafayette | Louisiana | 22055 | 7628 | 93 |
412821 | 412821 | 2020-08-08 | Lafayette | Louisiana | 22055 | 7468 | 91 |
409601 | 409601 | 2020-08-07 | Lafayette | Louisiana | 22055 | 7468 | 91 |
406381 | 406381 | 2020-08-06 | Lafayette | Louisiana | 22055 | 7424 | 91 |
403163 | 403163 | 2020-08-05 | Lafayette | Louisiana | 22055 | 7344 | 89 |
399946 | 399946 | 2020-08-04 | Lafayette | Louisiana | 22055 | 7280 | 89 |
396731 | 396731 | 2020-08-03 | Lafayette | Louisiana | 22055 | 6423 | 87 |
393515 | 393515 | 2020-08-02 | Lafayette | Louisiana | 22055 | 6350 | 86 |
390298 | 390298 | 2020-08-01 | Lafayette | Louisiana | 22055 | 6155 | 84 |
387081 | 387081 | 2020-07-31 | Lafayette | Louisiana | 22055 | 6155 | 84 |
383863 | 383863 | 2020-07-30 | Lafayette | Louisiana | 22055 | 6096 | 83 |
380646 | 380646 | 2020-07-29 | Lafayette | Louisiana | 22055 | 6023 | 80 |
377429 | 377429 | 2020-07-28 | Lafayette | Louisiana | 22055 | 5944 | 79 |
374214 | 374214 | 2020-07-27 | Lafayette | Louisiana | 22055 | 5888 | 78 |
371002 | 371002 | 2020-07-26 | Lafayette | Louisiana | 22055 | 5769 | 75 |
367792 | 367792 | 2020-07-25 | Lafayette | Louisiana | 22055 | 5519 | 73 |
364585 | 364585 | 2020-07-24 | Lafayette | Louisiana | 22055 | 5519 | 73 |
361378 | 361378 | 2020-07-23 | Lafayette | Louisiana | 22055 | 5458 | 71 |
358173 | 358173 | 2020-07-22 | Lafayette | Louisiana | 22055 | 5339 | 67 |
354970 | 354970 | 2020-07-21 | Lafayette | Louisiana | 22055 | 5125 | 61 |
351768 | 351768 | 2020-07-20 | Lafayette | Louisiana | 22055 | 5001 | 59 |
348568 | 348568 | 2020-07-19 | Lafayette | Louisiana | 22055 | 4848 | 59 |
345367 | 345367 | 2020-07-18 | Lafayette | Louisiana | 22055 | 4644 | 57 |
342167 | 342167 | 2020-07-17 | Lafayette | Louisiana | 22055 | 4644 | 57 |
338971 | 338971 | 2020-07-16 | Lafayette | Louisiana | 22055 | 4520 | 57 |
335775 | 335775 | 2020-07-15 | Lafayette | Louisiana | 22055 | 4352 | 55 |
332582 | 332582 | 2020-07-14 | Lafayette | Louisiana | 22055 | 4216 | 55 |
329395 | 329395 | 2020-07-13 | Lafayette | Louisiana | 22055 | 3988 | 54 |
326209 | 326209 | 2020-07-12 | Lafayette | Louisiana | 22055 | 3834 | 54 |
323026 | 323026 | 2020-07-11 | Lafayette | Louisiana | 22055 | 3707 | 52 |
319847 | 319847 | 2020-07-10 | Lafayette | Louisiana | 22055 | 3493 | 51 |
316672 | 316672 | 2020-07-09 | Lafayette | Louisiana | 22055 | 3293 | 50 |
313498 | 313498 | 2020-07-08 | Lafayette | Louisiana | 22055 | 3127 | 50 |
310328 | 310328 | 2020-07-07 | Lafayette | Louisiana | 22055 | 3000 | 48 |
307160 | 307160 | 2020-07-06 | Lafayette | Louisiana | 22055 | 2917 | 48 |
303993 | 303993 | 2020-07-05 | Lafayette | Louisiana | 22055 | 2800 | 48 |
300829 | 300829 | 2020-07-04 | Lafayette | Louisiana | 22055 | 2645 | 47 |
297667 | 297667 | 2020-07-03 | Lafayette | Louisiana | 22055 | 2645 | 47 |
294509 | 294509 | 2020-07-02 | Lafayette | Louisiana | 22055 | 2472 | 46 |
291355 | 291355 | 2020-07-01 | Lafayette | Louisiana | 22055 | 2359 | 45 |
288204 | 288204 | 2020-06-30 | Lafayette | Louisiana | 22055 | 2158 | 42 |
285055 | 285055 | 2020-06-29 | Lafayette | Louisiana | 22055 | 2058 | 41 |
281909 | 281909 | 2020-06-28 | Lafayette | Louisiana | 22055 | 1972 | 41 |
278761 | 278761 | 2020-06-27 | Lafayette | Louisiana | 22055 | 1862 | 41 |
275613 | 275613 | 2020-06-26 | Lafayette | Louisiana | 22055 | 1862 | 41 |
272470 | 272470 | 2020-06-25 | Lafayette | Louisiana | 22055 | 1723 | 37 |
269334 | 269334 | 2020-06-24 | Lafayette | Louisiana | 22055 | 1654 | 36 |
266201 | 266201 | 2020-06-23 | Lafayette | Louisiana | 22055 | 1574 | 36 |
263074 | 263074 | 2020-06-22 | Lafayette | Louisiana | 22055 | 1440 | 33 |
259945 | 259945 | 2020-06-21 | Lafayette | Louisiana | 22055 | 1396 | 33 |
256819 | 256819 | 2020-06-20 | Lafayette | Louisiana | 22055 | 1364 | 33 |
253699 | 253699 | 2020-06-19 | Lafayette | Louisiana | 22055 | 1310 | 32 |
250584 | 250584 | 2020-06-18 | Lafayette | Louisiana | 22055 | 1302 | 32 |
247472 | 247472 | 2020-06-17 | Lafayette | Louisiana | 22055 | 1302 | 32 |
244359 | 244359 | 2020-06-16 | Lafayette | Louisiana | 22055 | 1243 | 32 |
241248 | 241248 | 2020-06-15 | Lafayette | Louisiana | 22055 | 1202 | 32 |
238139 | 238139 | 2020-06-14 | Lafayette | Louisiana | 22055 | 1148 | 32 |
235032 | 235032 | 2020-06-13 | Lafayette | Louisiana | 22055 | 1140 | 32 |
231927 | 231927 | 2020-06-12 | Lafayette | Louisiana | 22055 | 988 | 32 |
228823 | 228823 | 2020-06-11 | Lafayette | Louisiana | 22055 | 957 | 33 |
225721 | 225721 | 2020-06-10 | Lafayette | Louisiana | 22055 | 931 | 30 |
222625 | 222625 | 2020-06-09 | Lafayette | Louisiana | 22055 | 908 | 30 |
219530 | 219530 | 2020-06-08 | Lafayette | Louisiana | 22055 | 897 | 30 |
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);