ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 22005 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387055 | 387055 | 2020-07-31 | Ascension | Louisiana | 22005 | 2458 | 68 |
383837 | 383837 | 2020-07-30 | Ascension | Louisiana | 22005 | 2444 | 67 |
380620 | 380620 | 2020-07-29 | Ascension | Louisiana | 22005 | 2383 | 66 |
377403 | 377403 | 2020-07-28 | Ascension | Louisiana | 22005 | 2357 | 65 |
374188 | 374188 | 2020-07-27 | Ascension | Louisiana | 22005 | 2335 | 65 |
370976 | 370976 | 2020-07-26 | Ascension | Louisiana | 22005 | 2249 | 65 |
367766 | 367766 | 2020-07-25 | Ascension | Louisiana | 22005 | 2175 | 65 |
364559 | 364559 | 2020-07-24 | Ascension | Louisiana | 22005 | 2175 | 65 |
361352 | 361352 | 2020-07-23 | Ascension | Louisiana | 22005 | 2132 | 65 |
358147 | 358147 | 2020-07-22 | Ascension | Louisiana | 22005 | 2077 | 65 |
354944 | 354944 | 2020-07-21 | Ascension | Louisiana | 22005 | 2022 | 65 |
351742 | 351742 | 2020-07-20 | Ascension | Louisiana | 22005 | 1976 | 65 |
348542 | 348542 | 2020-07-19 | Ascension | Louisiana | 22005 | 1896 | 64 |
345341 | 345341 | 2020-07-18 | Ascension | Louisiana | 22005 | 1826 | 64 |
342141 | 342141 | 2020-07-17 | Ascension | Louisiana | 22005 | 1826 | 64 |
338945 | 338945 | 2020-07-16 | Ascension | Louisiana | 22005 | 1755 | 64 |
335749 | 335749 | 2020-07-15 | Ascension | Louisiana | 22005 | 1710 | 64 |
332556 | 332556 | 2020-07-14 | Ascension | Louisiana | 22005 | 1655 | 64 |
329369 | 329369 | 2020-07-13 | Ascension | Louisiana | 22005 | 1622 | 64 |
326183 | 326183 | 2020-07-12 | Ascension | Louisiana | 22005 | 1597 | 63 |
323000 | 323000 | 2020-07-11 | Ascension | Louisiana | 22005 | 1564 | 63 |
319821 | 319821 | 2020-07-10 | Ascension | Louisiana | 22005 | 1532 | 63 |
316646 | 316646 | 2020-07-09 | Ascension | Louisiana | 22005 | 1480 | 60 |
313472 | 313472 | 2020-07-08 | Ascension | Louisiana | 22005 | 1441 | 60 |
310302 | 310302 | 2020-07-07 | Ascension | Louisiana | 22005 | 1412 | 59 |
307134 | 307134 | 2020-07-06 | Ascension | Louisiana | 22005 | 1358 | 58 |
303967 | 303967 | 2020-07-05 | Ascension | Louisiana | 22005 | 1331 | 58 |
300803 | 300803 | 2020-07-04 | Ascension | Louisiana | 22005 | 1278 | 58 |
297641 | 297641 | 2020-07-03 | Ascension | Louisiana | 22005 | 1278 | 58 |
294483 | 294483 | 2020-07-02 | Ascension | Louisiana | 22005 | 1246 | 58 |
291329 | 291329 | 2020-07-01 | Ascension | Louisiana | 22005 | 1213 | 58 |
288178 | 288178 | 2020-06-30 | Ascension | Louisiana | 22005 | 1171 | 58 |
285029 | 285029 | 2020-06-29 | Ascension | Louisiana | 22005 | 1157 | 58 |
281883 | 281883 | 2020-06-28 | Ascension | Louisiana | 22005 | 1146 | 58 |
278735 | 278735 | 2020-06-27 | Ascension | Louisiana | 22005 | 1115 | 58 |
275587 | 275587 | 2020-06-26 | Ascension | Louisiana | 22005 | 1115 | 58 |
272444 | 272444 | 2020-06-25 | Ascension | Louisiana | 22005 | 1094 | 58 |
269308 | 269308 | 2020-06-24 | Ascension | Louisiana | 22005 | 1070 | 58 |
266175 | 266175 | 2020-06-23 | Ascension | Louisiana | 22005 | 1044 | 58 |
263048 | 263048 | 2020-06-22 | Ascension | Louisiana | 22005 | 1008 | 58 |
259919 | 259919 | 2020-06-21 | Ascension | Louisiana | 22005 | 997 | 58 |
256793 | 256793 | 2020-06-20 | Ascension | Louisiana | 22005 | 989 | 58 |
253673 | 253673 | 2020-06-19 | Ascension | Louisiana | 22005 | 961 | 58 |
250558 | 250558 | 2020-06-18 | Ascension | Louisiana | 22005 | 962 | 58 |
247446 | 247446 | 2020-06-17 | Ascension | Louisiana | 22005 | 962 | 58 |
244333 | 244333 | 2020-06-16 | Ascension | Louisiana | 22005 | 957 | 58 |
241222 | 241222 | 2020-06-15 | Ascension | Louisiana | 22005 | 948 | 58 |
238113 | 238113 | 2020-06-14 | Ascension | Louisiana | 22005 | 935 | 58 |
235006 | 235006 | 2020-06-13 | Ascension | Louisiana | 22005 | 931 | 58 |
231901 | 231901 | 2020-06-12 | Ascension | Louisiana | 22005 | 918 | 58 |
228797 | 228797 | 2020-06-11 | Ascension | Louisiana | 22005 | 912 | 58 |
225695 | 225695 | 2020-06-10 | Ascension | Louisiana | 22005 | 906 | 58 |
222599 | 222599 | 2020-06-09 | Ascension | Louisiana | 22005 | 900 | 58 |
219504 | 219504 | 2020-06-08 | Ascension | Louisiana | 22005 | 889 | 58 |
216412 | 216412 | 2020-06-07 | Ascension | Louisiana | 22005 | 882 | 58 |
213325 | 213325 | 2020-06-06 | Ascension | Louisiana | 22005 | 876 | 58 |
210240 | 210240 | 2020-06-05 | Ascension | Louisiana | 22005 | 865 | 58 |
207159 | 207159 | 2020-06-04 | Ascension | Louisiana | 22005 | 861 | 57 |
204078 | 204078 | 2020-06-03 | Ascension | Louisiana | 22005 | 852 | 57 |
201001 | 201001 | 2020-06-02 | Ascension | Louisiana | 22005 | 841 | 56 |
197929 | 197929 | 2020-06-01 | Ascension | Louisiana | 22005 | 827 | 56 |
194858 | 194858 | 2020-05-31 | Ascension | Louisiana | 22005 | 820 | 56 |
191790 | 191790 | 2020-05-30 | Ascension | Louisiana | 22005 | 817 | 56 |
188726 | 188726 | 2020-05-29 | Ascension | Louisiana | 22005 | 810 | 56 |
185668 | 185668 | 2020-05-28 | Ascension | Louisiana | 22005 | 810 | 56 |
182613 | 182613 | 2020-05-27 | Ascension | Louisiana | 22005 | 805 | 55 |
179568 | 179568 | 2020-05-26 | Ascension | Louisiana | 22005 | 792 | 55 |
176524 | 176524 | 2020-05-25 | Ascension | Louisiana | 22005 | 788 | 54 |
173480 | 173480 | 2020-05-24 | Ascension | Louisiana | 22005 | 786 | 54 |
170439 | 170439 | 2020-05-23 | Ascension | Louisiana | 22005 | 785 | 54 |
167401 | 167401 | 2020-05-22 | Ascension | Louisiana | 22005 | 785 | 54 |
164365 | 164365 | 2020-05-21 | Ascension | Louisiana | 22005 | 782 | 52 |
161336 | 161336 | 2020-05-20 | Ascension | Louisiana | 22005 | 768 | 52 |
158310 | 158310 | 2020-05-19 | Ascension | Louisiana | 22005 | 762 | 50 |
155292 | 155292 | 2020-05-18 | Ascension | Louisiana | 22005 | 760 | 50 |
152278 | 152278 | 2020-05-17 | Ascension | Louisiana | 22005 | 756 | 49 |
149267 | 149267 | 2020-05-16 | Ascension | Louisiana | 22005 | 752 | 49 |
146262 | 146262 | 2020-05-15 | Ascension | Louisiana | 22005 | 749 | 48 |
143262 | 143262 | 2020-05-14 | Ascension | Louisiana | 22005 | 745 | 48 |
140267 | 140267 | 2020-05-13 | Ascension | Louisiana | 22005 | 704 | 48 |
137273 | 137273 | 2020-05-12 | Ascension | Louisiana | 22005 | 701 | 49 |
134283 | 134283 | 2020-05-11 | Ascension | Louisiana | 22005 | 695 | 48 |
131292 | 131292 | 2020-05-10 | Ascension | Louisiana | 22005 | 694 | 46 |
128302 | 128302 | 2020-05-09 | Ascension | Louisiana | 22005 | 689 | 46 |
125315 | 125315 | 2020-05-08 | Ascension | Louisiana | 22005 | 675 | 46 |
122333 | 122333 | 2020-05-07 | Ascension | Louisiana | 22005 | 672 | 46 |
119362 | 119362 | 2020-05-06 | Ascension | Louisiana | 22005 | 664 | 44 |
116401 | 116401 | 2020-05-05 | Ascension | Louisiana | 22005 | 657 | 40 |
113519 | 113519 | 2020-05-04 | Ascension | Louisiana | 22005 | 647 | 40 |
110642 | 110642 | 2020-05-03 | Ascension | Louisiana | 22005 | 644 | 40 |
107770 | 107770 | 2020-05-02 | Ascension | Louisiana | 22005 | 636 | 40 |
104906 | 104906 | 2020-05-01 | Ascension | Louisiana | 22005 | 627 | 40 |
102045 | 102045 | 2020-04-30 | Ascension | Louisiana | 22005 | 593 | 40 |
99193 | 99193 | 2020-04-29 | Ascension | Louisiana | 22005 | 587 | 38 |
96347 | 96347 | 2020-04-28 | Ascension | Louisiana | 22005 | 576 | 36 |
93512 | 93512 | 2020-04-27 | Ascension | Louisiana | 22005 | 574 | 35 |
90691 | 90691 | 2020-04-26 | Ascension | Louisiana | 22005 | 568 | 36 |
87875 | 87875 | 2020-04-25 | Ascension | Louisiana | 22005 | 557 | 35 |
85066 | 85066 | 2020-04-24 | Ascension | Louisiana | 22005 | 551 | 34 |
82262 | 82262 | 2020-04-23 | Ascension | Louisiana | 22005 | 536 | 33 |
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);