ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22055 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
216438 | 216438 | 2020-06-07 | Lafayette | Louisiana | 22055 | 880 | 29 |
213351 | 213351 | 2020-06-06 | Lafayette | Louisiana | 22055 | 866 | 29 |
210266 | 210266 | 2020-06-05 | Lafayette | Louisiana | 22055 | 854 | 29 |
207185 | 207185 | 2020-06-04 | Lafayette | Louisiana | 22055 | 834 | 28 |
204104 | 204104 | 2020-06-03 | Lafayette | Louisiana | 22055 | 821 | 27 |
201027 | 201027 | 2020-06-02 | Lafayette | Louisiana | 22055 | 803 | 27 |
197955 | 197955 | 2020-06-01 | Lafayette | Louisiana | 22055 | 793 | 26 |
194884 | 194884 | 2020-05-31 | Lafayette | Louisiana | 22055 | 768 | 26 |
191816 | 191816 | 2020-05-30 | Lafayette | Louisiana | 22055 | 763 | 26 |
188752 | 188752 | 2020-05-29 | Lafayette | Louisiana | 22055 | 695 | 26 |
185694 | 185694 | 2020-05-28 | Lafayette | Louisiana | 22055 | 695 | 25 |
182639 | 182639 | 2020-05-27 | Lafayette | Louisiana | 22055 | 689 | 23 |
179594 | 179594 | 2020-05-26 | Lafayette | Louisiana | 22055 | 678 | 23 |
176550 | 176550 | 2020-05-25 | Lafayette | Louisiana | 22055 | 674 | 23 |
173506 | 173506 | 2020-05-24 | Lafayette | Louisiana | 22055 | 659 | 23 |
170465 | 170465 | 2020-05-23 | Lafayette | Louisiana | 22055 | 659 | 23 |
167427 | 167427 | 2020-05-22 | Lafayette | Louisiana | 22055 | 637 | 23 |
164391 | 164391 | 2020-05-21 | Lafayette | Louisiana | 22055 | 631 | 23 |
161362 | 161362 | 2020-05-20 | Lafayette | Louisiana | 22055 | 607 | 23 |
158336 | 158336 | 2020-05-19 | Lafayette | Louisiana | 22055 | 605 | 23 |
155318 | 155318 | 2020-05-18 | Lafayette | Louisiana | 22055 | 598 | 23 |
152304 | 152304 | 2020-05-17 | Lafayette | Louisiana | 22055 | 590 | 23 |
149293 | 149293 | 2020-05-16 | Lafayette | Louisiana | 22055 | 578 | 23 |
146288 | 146288 | 2020-05-15 | Lafayette | Louisiana | 22055 | 543 | 23 |
143288 | 143288 | 2020-05-14 | Lafayette | Louisiana | 22055 | 541 | 23 |
140293 | 140293 | 2020-05-13 | Lafayette | Louisiana | 22055 | 537 | 22 |
137299 | 137299 | 2020-05-12 | Lafayette | Louisiana | 22055 | 512 | 22 |
134309 | 134309 | 2020-05-11 | Lafayette | Louisiana | 22055 | 508 | 22 |
131318 | 131318 | 2020-05-10 | Lafayette | Louisiana | 22055 | 501 | 22 |
128328 | 128328 | 2020-05-09 | Lafayette | Louisiana | 22055 | 498 | 22 |
125341 | 125341 | 2020-05-08 | Lafayette | Louisiana | 22055 | 481 | 21 |
122359 | 122359 | 2020-05-07 | Lafayette | Louisiana | 22055 | 479 | 21 |
119388 | 119388 | 2020-05-06 | Lafayette | Louisiana | 22055 | 477 | 21 |
116427 | 116427 | 2020-05-05 | Lafayette | Louisiana | 22055 | 473 | 20 |
113545 | 113545 | 2020-05-04 | Lafayette | Louisiana | 22055 | 468 | 20 |
110668 | 110668 | 2020-05-03 | Lafayette | Louisiana | 22055 | 466 | 20 |
107796 | 107796 | 2020-05-02 | Lafayette | Louisiana | 22055 | 464 | 20 |
104932 | 104932 | 2020-05-01 | Lafayette | Louisiana | 22055 | 463 | 20 |
102071 | 102071 | 2020-04-30 | Lafayette | Louisiana | 22055 | 455 | 20 |
99219 | 99219 | 2020-04-29 | Lafayette | Louisiana | 22055 | 451 | 20 |
96373 | 96373 | 2020-04-28 | Lafayette | Louisiana | 22055 | 446 | 21 |
93538 | 93538 | 2020-04-27 | Lafayette | Louisiana | 22055 | 443 | 18 |
90717 | 90717 | 2020-04-26 | Lafayette | Louisiana | 22055 | 443 | 17 |
87901 | 87901 | 2020-04-25 | Lafayette | Louisiana | 22055 | 442 | 17 |
85092 | 85092 | 2020-04-24 | Lafayette | Louisiana | 22055 | 440 | 17 |
82288 | 82288 | 2020-04-23 | Lafayette | Louisiana | 22055 | 439 | 17 |
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);