ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Jefferson Davis" and state = "Louisiana" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
11394 | 11394 | 2020-03-25 | Jefferson Davis | Louisiana | 22053 | 1 | 0 |
12970 | 12970 | 2020-03-26 | Jefferson Davis | Louisiana | 22053 | 1 | 0 |
14677 | 14677 | 2020-03-27 | Jefferson Davis | Louisiana | 22053 | 1 | 0 |
16497 | 16497 | 2020-03-28 | Jefferson Davis | Louisiana | 22053 | 1 | 0 |
18409 | 18409 | 2020-03-29 | Jefferson Davis | Louisiana | 22053 | 2 | 0 |
20425 | 20425 | 2020-03-30 | Jefferson Davis | Louisiana | 22053 | 3 | 0 |
22533 | 22533 | 2020-03-31 | Jefferson Davis | Louisiana | 22053 | 5 | 0 |
24709 | 24709 | 2020-04-01 | Jefferson Davis | Louisiana | 22053 | 9 | 0 |
26960 | 26960 | 2020-04-02 | Jefferson Davis | Louisiana | 22053 | 13 | 0 |
29277 | 29277 | 2020-04-03 | Jefferson Davis | Louisiana | 22053 | 14 | 0 |
31655 | 31655 | 2020-04-04 | Jefferson Davis | Louisiana | 22053 | 9 | 0 |
34080 | 34080 | 2020-04-05 | Jefferson Davis | Louisiana | 22053 | 13 | 0 |
36538 | 36538 | 2020-04-06 | Jefferson Davis | Louisiana | 22053 | 21 | 1 |
39046 | 39046 | 2020-04-07 | Jefferson Davis | Louisiana | 22053 | 25 | 1 |
41598 | 41598 | 2020-04-08 | Jefferson Davis | Louisiana | 22053 | 28 | 1 |
44174 | 44174 | 2020-04-09 | Jefferson Davis | Louisiana | 22053 | 30 | 2 |
46782 | 46782 | 2020-04-10 | Jefferson Davis | Louisiana | 22053 | 32 | 2 |
49423 | 49423 | 2020-04-11 | Jefferson Davis | Louisiana | 22053 | 35 | 3 |
52093 | 52093 | 2020-04-12 | Jefferson Davis | Louisiana | 22053 | 44 | 3 |
54774 | 54774 | 2020-04-13 | Jefferson Davis | Louisiana | 22053 | 47 | 3 |
57472 | 57472 | 2020-04-14 | Jefferson Davis | Louisiana | 22053 | 47 | 4 |
60180 | 60180 | 2020-04-15 | Jefferson Davis | Louisiana | 22053 | 48 | 4 |
62901 | 62901 | 2020-04-16 | Jefferson Davis | Louisiana | 22053 | 48 | 5 |
65640 | 65640 | 2020-04-17 | Jefferson Davis | Louisiana | 22053 | 52 | 5 |
68389 | 68389 | 2020-04-18 | Jefferson Davis | Louisiana | 22053 | 53 | 5 |
71152 | 71152 | 2020-04-19 | Jefferson Davis | Louisiana | 22053 | 55 | 5 |
73924 | 73924 | 2020-04-20 | Jefferson Davis | Louisiana | 22053 | 55 | 5 |
76704 | 76704 | 2020-04-21 | Jefferson Davis | Louisiana | 22053 | 57 | 5 |
79490 | 79490 | 2020-04-22 | Jefferson Davis | Louisiana | 22053 | 57 | 5 |
82286 | 82286 | 2020-04-23 | Jefferson Davis | Louisiana | 22053 | 57 | 5 |
85090 | 85090 | 2020-04-24 | Jefferson Davis | Louisiana | 22053 | 57 | 5 |
87899 | 87899 | 2020-04-25 | Jefferson Davis | Louisiana | 22053 | 59 | 5 |
90715 | 90715 | 2020-04-26 | Jefferson Davis | Louisiana | 22053 | 59 | 5 |
93536 | 93536 | 2020-04-27 | Jefferson Davis | Louisiana | 22053 | 61 | 6 |
96371 | 96371 | 2020-04-28 | Jefferson Davis | Louisiana | 22053 | 61 | 6 |
99217 | 99217 | 2020-04-29 | Jefferson Davis | Louisiana | 22053 | 62 | 6 |
102069 | 102069 | 2020-04-30 | Jefferson Davis | Louisiana | 22053 | 62 | 6 |
104930 | 104930 | 2020-05-01 | Jefferson Davis | Louisiana | 22053 | 63 | 6 |
107794 | 107794 | 2020-05-02 | Jefferson Davis | Louisiana | 22053 | 64 | 6 |
110666 | 110666 | 2020-05-03 | Jefferson Davis | Louisiana | 22053 | 64 | 6 |
113543 | 113543 | 2020-05-04 | Jefferson Davis | Louisiana | 22053 | 65 | 6 |
116425 | 116425 | 2020-05-05 | Jefferson Davis | Louisiana | 22053 | 65 | 6 |
119386 | 119386 | 2020-05-06 | Jefferson Davis | Louisiana | 22053 | 66 | 6 |
122357 | 122357 | 2020-05-07 | Jefferson Davis | Louisiana | 22053 | 66 | 6 |
125339 | 125339 | 2020-05-08 | Jefferson Davis | Louisiana | 22053 | 66 | 6 |
128326 | 128326 | 2020-05-09 | Jefferson Davis | Louisiana | 22053 | 67 | 6 |
131316 | 131316 | 2020-05-10 | Jefferson Davis | Louisiana | 22053 | 67 | 6 |
134307 | 134307 | 2020-05-11 | Jefferson Davis | Louisiana | 22053 | 68 | 6 |
137297 | 137297 | 2020-05-12 | Jefferson Davis | Louisiana | 22053 | 68 | 6 |
140291 | 140291 | 2020-05-13 | Jefferson Davis | Louisiana | 22053 | 69 | 6 |
143286 | 143286 | 2020-05-14 | Jefferson Davis | Louisiana | 22053 | 69 | 6 |
146286 | 146286 | 2020-05-15 | Jefferson Davis | Louisiana | 22053 | 70 | 6 |
149291 | 149291 | 2020-05-16 | Jefferson Davis | Louisiana | 22053 | 69 | 6 |
152302 | 152302 | 2020-05-17 | Jefferson Davis | Louisiana | 22053 | 69 | 6 |
155316 | 155316 | 2020-05-18 | Jefferson Davis | Louisiana | 22053 | 70 | 6 |
158334 | 158334 | 2020-05-19 | Jefferson Davis | Louisiana | 22053 | 71 | 6 |
161360 | 161360 | 2020-05-20 | Jefferson Davis | Louisiana | 22053 | 71 | 6 |
164389 | 164389 | 2020-05-21 | Jefferson Davis | Louisiana | 22053 | 72 | 6 |
167425 | 167425 | 2020-05-22 | Jefferson Davis | Louisiana | 22053 | 73 | 7 |
170463 | 170463 | 2020-05-23 | Jefferson Davis | Louisiana | 22053 | 73 | 7 |
173504 | 173504 | 2020-05-24 | Jefferson Davis | Louisiana | 22053 | 73 | 7 |
176548 | 176548 | 2020-05-25 | Jefferson Davis | Louisiana | 22053 | 74 | 7 |
179592 | 179592 | 2020-05-26 | Jefferson Davis | Louisiana | 22053 | 74 | 7 |
182637 | 182637 | 2020-05-27 | Jefferson Davis | Louisiana | 22053 | 75 | 7 |
185692 | 185692 | 2020-05-28 | Jefferson Davis | Louisiana | 22053 | 75 | 7 |
188750 | 188750 | 2020-05-29 | Jefferson Davis | Louisiana | 22053 | 75 | 7 |
191814 | 191814 | 2020-05-30 | Jefferson Davis | Louisiana | 22053 | 76 | 7 |
194882 | 194882 | 2020-05-31 | Jefferson Davis | Louisiana | 22053 | 76 | 7 |
197953 | 197953 | 2020-06-01 | Jefferson Davis | Louisiana | 22053 | 78 | 7 |
201025 | 201025 | 2020-06-02 | Jefferson Davis | Louisiana | 22053 | 78 | 7 |
204102 | 204102 | 2020-06-03 | Jefferson Davis | Louisiana | 22053 | 78 | 7 |
207183 | 207183 | 2020-06-04 | Jefferson Davis | Louisiana | 22053 | 84 | 7 |
210264 | 210264 | 2020-06-05 | Jefferson Davis | Louisiana | 22053 | 87 | 7 |
213349 | 213349 | 2020-06-06 | Jefferson Davis | Louisiana | 22053 | 89 | 7 |
216436 | 216436 | 2020-06-07 | Jefferson Davis | Louisiana | 22053 | 91 | 7 |
219528 | 219528 | 2020-06-08 | Jefferson Davis | Louisiana | 22053 | 93 | 7 |
222623 | 222623 | 2020-06-09 | Jefferson Davis | Louisiana | 22053 | 96 | 7 |
225719 | 225719 | 2020-06-10 | Jefferson Davis | Louisiana | 22053 | 102 | 7 |
228821 | 228821 | 2020-06-11 | Jefferson Davis | Louisiana | 22053 | 106 | 7 |
231925 | 231925 | 2020-06-12 | Jefferson Davis | Louisiana | 22053 | 114 | 7 |
235030 | 235030 | 2020-06-13 | Jefferson Davis | Louisiana | 22053 | 131 | 7 |
238137 | 238137 | 2020-06-14 | Jefferson Davis | Louisiana | 22053 | 132 | 7 |
241246 | 241246 | 2020-06-15 | Jefferson Davis | Louisiana | 22053 | 133 | 7 |
244357 | 244357 | 2020-06-16 | Jefferson Davis | Louisiana | 22053 | 147 | 7 |
247470 | 247470 | 2020-06-17 | Jefferson Davis | Louisiana | 22053 | 162 | 7 |
250582 | 250582 | 2020-06-18 | Jefferson Davis | Louisiana | 22053 | 162 | 7 |
253697 | 253697 | 2020-06-19 | Jefferson Davis | Louisiana | 22053 | 189 | 7 |
256817 | 256817 | 2020-06-20 | Jefferson Davis | Louisiana | 22053 | 203 | 7 |
259943 | 259943 | 2020-06-21 | Jefferson Davis | Louisiana | 22053 | 208 | 7 |
263072 | 263072 | 2020-06-22 | Jefferson Davis | Louisiana | 22053 | 240 | 7 |
266199 | 266199 | 2020-06-23 | Jefferson Davis | Louisiana | 22053 | 247 | 7 |
269332 | 269332 | 2020-06-24 | Jefferson Davis | Louisiana | 22053 | 250 | 7 |
272468 | 272468 | 2020-06-25 | Jefferson Davis | Louisiana | 22053 | 283 | 7 |
275611 | 275611 | 2020-06-26 | Jefferson Davis | Louisiana | 22053 | 316 | 8 |
278759 | 278759 | 2020-06-27 | Jefferson Davis | Louisiana | 22053 | 316 | 8 |
281907 | 281907 | 2020-06-28 | Jefferson Davis | Louisiana | 22053 | 328 | 8 |
285053 | 285053 | 2020-06-29 | Jefferson Davis | Louisiana | 22053 | 339 | 8 |
288202 | 288202 | 2020-06-30 | Jefferson Davis | Louisiana | 22053 | 349 | 9 |
291353 | 291353 | 2020-07-01 | Jefferson Davis | Louisiana | 22053 | 370 | 9 |
294507 | 294507 | 2020-07-02 | Jefferson Davis | Louisiana | 22053 | 399 | 9 |
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);