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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2916 | 2916 | 2020-03-16 | Ascension | Louisiana | 22005 | 1 | 0 |
3412 | 3412 | 2020-03-17 | Ascension | Louisiana | 22005 | 1 | 0 |
3992 | 3992 | 2020-03-18 | Ascension | Louisiana | 22005 | 1 | 0 |
4683 | 4683 | 2020-03-19 | Ascension | Louisiana | 22005 | 2 | 0 |
5497 | 5497 | 2020-03-20 | Ascension | Louisiana | 22005 | 3 | 0 |
6445 | 6445 | 2020-03-21 | Ascension | Louisiana | 22005 | 12 | 0 |
7520 | 7520 | 2020-03-22 | Ascension | Louisiana | 22005 | 17 | 0 |
8684 | 8684 | 2020-03-23 | Ascension | Louisiana | 22005 | 26 | 1 |
9972 | 9972 | 2020-03-24 | Ascension | Louisiana | 22005 | 36 | 1 |
11376 | 11376 | 2020-03-25 | Ascension | Louisiana | 22005 | 65 | 1 |
12951 | 12951 | 2020-03-26 | Ascension | Louisiana | 22005 | 91 | 1 |
14658 | 14658 | 2020-03-27 | Ascension | Louisiana | 22005 | 90 | 1 |
16476 | 16476 | 2020-03-28 | Ascension | Louisiana | 22005 | 107 | 1 |
18388 | 18388 | 2020-03-29 | Ascension | Louisiana | 22005 | 139 | 2 |
20404 | 20404 | 2020-03-30 | Ascension | Louisiana | 22005 | 153 | 5 |
22511 | 22511 | 2020-03-31 | Ascension | Louisiana | 22005 | 161 | 6 |
24687 | 24687 | 2020-04-01 | Ascension | Louisiana | 22005 | 189 | 6 |
26937 | 26937 | 2020-04-02 | Ascension | Louisiana | 22005 | 201 | 7 |
29254 | 29254 | 2020-04-03 | Ascension | Louisiana | 22005 | 222 | 7 |
31632 | 31632 | 2020-04-04 | Ascension | Louisiana | 22005 | 284 | 7 |
34057 | 34057 | 2020-04-05 | Ascension | Louisiana | 22005 | 286 | 11 |
36515 | 36515 | 2020-04-06 | Ascension | Louisiana | 22005 | 347 | 11 |
39022 | 39022 | 2020-04-07 | Ascension | Louisiana | 22005 | 358 | 11 |
41574 | 41574 | 2020-04-08 | Ascension | Louisiana | 22005 | 366 | 15 |
44150 | 44150 | 2020-04-09 | Ascension | Louisiana | 22005 | 370 | 17 |
46758 | 46758 | 2020-04-10 | Ascension | Louisiana | 22005 | 397 | 19 |
49399 | 49399 | 2020-04-11 | Ascension | Louisiana | 22005 | 415 | 20 |
52069 | 52069 | 2020-04-12 | Ascension | Louisiana | 22005 | 428 | 23 |
54750 | 54750 | 2020-04-13 | Ascension | Louisiana | 22005 | 432 | 24 |
57448 | 57448 | 2020-04-14 | Ascension | Louisiana | 22005 | 438 | 27 |
60156 | 60156 | 2020-04-15 | Ascension | Louisiana | 22005 | 440 | 27 |
62877 | 62877 | 2020-04-16 | Ascension | Louisiana | 22005 | 451 | 29 |
65616 | 65616 | 2020-04-17 | Ascension | Louisiana | 22005 | 468 | 30 |
68365 | 68365 | 2020-04-18 | Ascension | Louisiana | 22005 | 496 | 30 |
71128 | 71128 | 2020-04-19 | Ascension | Louisiana | 22005 | 508 | 30 |
73900 | 73900 | 2020-04-20 | Ascension | Louisiana | 22005 | 512 | 31 |
76680 | 76680 | 2020-04-21 | Ascension | Louisiana | 22005 | 515 | 31 |
79466 | 79466 | 2020-04-22 | Ascension | Louisiana | 22005 | 533 | 33 |
82262 | 82262 | 2020-04-23 | Ascension | Louisiana | 22005 | 536 | 33 |
85066 | 85066 | 2020-04-24 | Ascension | Louisiana | 22005 | 551 | 34 |
87875 | 87875 | 2020-04-25 | Ascension | Louisiana | 22005 | 557 | 35 |
90691 | 90691 | 2020-04-26 | Ascension | Louisiana | 22005 | 568 | 36 |
93512 | 93512 | 2020-04-27 | Ascension | Louisiana | 22005 | 574 | 35 |
96347 | 96347 | 2020-04-28 | Ascension | Louisiana | 22005 | 576 | 36 |
99193 | 99193 | 2020-04-29 | Ascension | Louisiana | 22005 | 587 | 38 |
102045 | 102045 | 2020-04-30 | Ascension | Louisiana | 22005 | 593 | 40 |
104906 | 104906 | 2020-05-01 | Ascension | Louisiana | 22005 | 627 | 40 |
107770 | 107770 | 2020-05-02 | Ascension | Louisiana | 22005 | 636 | 40 |
110642 | 110642 | 2020-05-03 | Ascension | Louisiana | 22005 | 644 | 40 |
113519 | 113519 | 2020-05-04 | Ascension | Louisiana | 22005 | 647 | 40 |
116401 | 116401 | 2020-05-05 | Ascension | Louisiana | 22005 | 657 | 40 |
119362 | 119362 | 2020-05-06 | Ascension | Louisiana | 22005 | 664 | 44 |
122333 | 122333 | 2020-05-07 | Ascension | Louisiana | 22005 | 672 | 46 |
125315 | 125315 | 2020-05-08 | Ascension | Louisiana | 22005 | 675 | 46 |
128302 | 128302 | 2020-05-09 | Ascension | Louisiana | 22005 | 689 | 46 |
131292 | 131292 | 2020-05-10 | Ascension | Louisiana | 22005 | 694 | 46 |
134283 | 134283 | 2020-05-11 | Ascension | Louisiana | 22005 | 695 | 48 |
137273 | 137273 | 2020-05-12 | Ascension | Louisiana | 22005 | 701 | 49 |
140267 | 140267 | 2020-05-13 | Ascension | Louisiana | 22005 | 704 | 48 |
143262 | 143262 | 2020-05-14 | Ascension | Louisiana | 22005 | 745 | 48 |
146262 | 146262 | 2020-05-15 | Ascension | Louisiana | 22005 | 749 | 48 |
149267 | 149267 | 2020-05-16 | Ascension | Louisiana | 22005 | 752 | 49 |
152278 | 152278 | 2020-05-17 | Ascension | Louisiana | 22005 | 756 | 49 |
155292 | 155292 | 2020-05-18 | Ascension | Louisiana | 22005 | 760 | 50 |
158310 | 158310 | 2020-05-19 | Ascension | Louisiana | 22005 | 762 | 50 |
161336 | 161336 | 2020-05-20 | Ascension | Louisiana | 22005 | 768 | 52 |
164365 | 164365 | 2020-05-21 | Ascension | Louisiana | 22005 | 782 | 52 |
167401 | 167401 | 2020-05-22 | Ascension | Louisiana | 22005 | 785 | 54 |
170439 | 170439 | 2020-05-23 | Ascension | Louisiana | 22005 | 785 | 54 |
173480 | 173480 | 2020-05-24 | Ascension | Louisiana | 22005 | 786 | 54 |
176524 | 176524 | 2020-05-25 | Ascension | Louisiana | 22005 | 788 | 54 |
179568 | 179568 | 2020-05-26 | Ascension | Louisiana | 22005 | 792 | 55 |
182613 | 182613 | 2020-05-27 | Ascension | Louisiana | 22005 | 805 | 55 |
185668 | 185668 | 2020-05-28 | Ascension | Louisiana | 22005 | 810 | 56 |
188726 | 188726 | 2020-05-29 | Ascension | Louisiana | 22005 | 810 | 56 |
191790 | 191790 | 2020-05-30 | Ascension | Louisiana | 22005 | 817 | 56 |
194858 | 194858 | 2020-05-31 | Ascension | Louisiana | 22005 | 820 | 56 |
197929 | 197929 | 2020-06-01 | Ascension | Louisiana | 22005 | 827 | 56 |
201001 | 201001 | 2020-06-02 | Ascension | Louisiana | 22005 | 841 | 56 |
204078 | 204078 | 2020-06-03 | Ascension | Louisiana | 22005 | 852 | 57 |
207159 | 207159 | 2020-06-04 | Ascension | Louisiana | 22005 | 861 | 57 |
210240 | 210240 | 2020-06-05 | Ascension | Louisiana | 22005 | 865 | 58 |
213325 | 213325 | 2020-06-06 | Ascension | Louisiana | 22005 | 876 | 58 |
216412 | 216412 | 2020-06-07 | Ascension | Louisiana | 22005 | 882 | 58 |
219504 | 219504 | 2020-06-08 | Ascension | Louisiana | 22005 | 889 | 58 |
222599 | 222599 | 2020-06-09 | Ascension | Louisiana | 22005 | 900 | 58 |
225695 | 225695 | 2020-06-10 | Ascension | Louisiana | 22005 | 906 | 58 |
228797 | 228797 | 2020-06-11 | Ascension | Louisiana | 22005 | 912 | 58 |
231901 | 231901 | 2020-06-12 | Ascension | Louisiana | 22005 | 918 | 58 |
235006 | 235006 | 2020-06-13 | Ascension | Louisiana | 22005 | 931 | 58 |
238113 | 238113 | 2020-06-14 | Ascension | Louisiana | 22005 | 935 | 58 |
241222 | 241222 | 2020-06-15 | Ascension | Louisiana | 22005 | 948 | 58 |
244333 | 244333 | 2020-06-16 | Ascension | Louisiana | 22005 | 957 | 58 |
247446 | 247446 | 2020-06-17 | Ascension | Louisiana | 22005 | 962 | 58 |
250558 | 250558 | 2020-06-18 | Ascension | Louisiana | 22005 | 962 | 58 |
253673 | 253673 | 2020-06-19 | Ascension | Louisiana | 22005 | 961 | 58 |
256793 | 256793 | 2020-06-20 | Ascension | Louisiana | 22005 | 989 | 58 |
259919 | 259919 | 2020-06-21 | Ascension | Louisiana | 22005 | 997 | 58 |
263048 | 263048 | 2020-06-22 | Ascension | Louisiana | 22005 | 1008 | 58 |
266175 | 266175 | 2020-06-23 | Ascension | Louisiana | 22005 | 1044 | 58 |
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);