ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where fips = 22107 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 |
---|---|---|---|---|---|---|---|
49450 | 49450 | 2020-04-11 | Tensas | Louisiana | 22107 | 1 | 0 |
52120 | 52120 | 2020-04-12 | Tensas | Louisiana | 22107 | 1 | 0 |
54801 | 54801 | 2020-04-13 | Tensas | Louisiana | 22107 | 1 | 0 |
57499 | 57499 | 2020-04-14 | Tensas | Louisiana | 22107 | 1 | 0 |
60207 | 60207 | 2020-04-15 | Tensas | Louisiana | 22107 | 1 | 0 |
62928 | 62928 | 2020-04-16 | Tensas | Louisiana | 22107 | 1 | 0 |
65667 | 65667 | 2020-04-17 | Tensas | Louisiana | 22107 | 1 | 0 |
68416 | 68416 | 2020-04-18 | Tensas | Louisiana | 22107 | 1 | 0 |
71179 | 71179 | 2020-04-19 | Tensas | Louisiana | 22107 | 1 | 0 |
73951 | 73951 | 2020-04-20 | Tensas | Louisiana | 22107 | 1 | 0 |
76731 | 76731 | 2020-04-21 | Tensas | Louisiana | 22107 | 1 | 0 |
79517 | 79517 | 2020-04-22 | Tensas | Louisiana | 22107 | 1 | 0 |
82313 | 82313 | 2020-04-23 | Tensas | Louisiana | 22107 | 1 | 0 |
85117 | 85117 | 2020-04-24 | Tensas | Louisiana | 22107 | 1 | 0 |
87926 | 87926 | 2020-04-25 | Tensas | Louisiana | 22107 | 1 | 0 |
90742 | 90742 | 2020-04-26 | Tensas | Louisiana | 22107 | 1 | 0 |
93563 | 93563 | 2020-04-27 | Tensas | Louisiana | 22107 | 1 | 0 |
96398 | 96398 | 2020-04-28 | Tensas | Louisiana | 22107 | 1 | 0 |
99244 | 99244 | 2020-04-29 | Tensas | Louisiana | 22107 | 1 | 0 |
102096 | 102096 | 2020-04-30 | Tensas | Louisiana | 22107 | 1 | 0 |
104957 | 104957 | 2020-05-01 | Tensas | Louisiana | 22107 | 1 | 0 |
107821 | 107821 | 2020-05-02 | Tensas | Louisiana | 22107 | 2 | 0 |
110693 | 110693 | 2020-05-03 | Tensas | Louisiana | 22107 | 2 | 0 |
113570 | 113570 | 2020-05-04 | Tensas | Louisiana | 22107 | 2 | 0 |
116452 | 116452 | 2020-05-05 | Tensas | Louisiana | 22107 | 2 | 0 |
119413 | 119413 | 2020-05-06 | Tensas | Louisiana | 22107 | 2 | 0 |
122384 | 122384 | 2020-05-07 | Tensas | Louisiana | 22107 | 3 | 0 |
125366 | 125366 | 2020-05-08 | Tensas | Louisiana | 22107 | 3 | 0 |
128353 | 128353 | 2020-05-09 | Tensas | Louisiana | 22107 | 6 | 0 |
131343 | 131343 | 2020-05-10 | Tensas | Louisiana | 22107 | 6 | 0 |
134334 | 134334 | 2020-05-11 | Tensas | Louisiana | 22107 | 6 | 0 |
137324 | 137324 | 2020-05-12 | Tensas | Louisiana | 22107 | 6 | 0 |
140318 | 140318 | 2020-05-13 | Tensas | Louisiana | 22107 | 6 | 0 |
143313 | 143313 | 2020-05-14 | Tensas | Louisiana | 22107 | 6 | 0 |
146313 | 146313 | 2020-05-15 | Tensas | Louisiana | 22107 | 6 | 0 |
149318 | 149318 | 2020-05-16 | Tensas | Louisiana | 22107 | 5 | 0 |
152329 | 152329 | 2020-05-17 | Tensas | Louisiana | 22107 | 5 | 0 |
155343 | 155343 | 2020-05-18 | Tensas | Louisiana | 22107 | 5 | 0 |
158361 | 158361 | 2020-05-19 | Tensas | Louisiana | 22107 | 5 | 0 |
161387 | 161387 | 2020-05-20 | Tensas | Louisiana | 22107 | 5 | 0 |
164416 | 164416 | 2020-05-21 | Tensas | Louisiana | 22107 | 10 | 0 |
167452 | 167452 | 2020-05-22 | Tensas | Louisiana | 22107 | 10 | 0 |
170490 | 170490 | 2020-05-23 | Tensas | Louisiana | 22107 | 10 | 0 |
173531 | 173531 | 2020-05-24 | Tensas | Louisiana | 22107 | 10 | 0 |
176575 | 176575 | 2020-05-25 | Tensas | Louisiana | 22107 | 10 | 0 |
179619 | 179619 | 2020-05-26 | Tensas | Louisiana | 22107 | 10 | 0 |
182664 | 182664 | 2020-05-27 | Tensas | Louisiana | 22107 | 10 | 0 |
185719 | 185719 | 2020-05-28 | Tensas | Louisiana | 22107 | 10 | 0 |
188777 | 188777 | 2020-05-29 | Tensas | Louisiana | 22107 | 10 | 0 |
191841 | 191841 | 2020-05-30 | Tensas | Louisiana | 22107 | 11 | 0 |
194909 | 194909 | 2020-05-31 | Tensas | Louisiana | 22107 | 11 | 0 |
197980 | 197980 | 2020-06-01 | Tensas | Louisiana | 22107 | 12 | 0 |
201052 | 201052 | 2020-06-02 | Tensas | Louisiana | 22107 | 12 | 0 |
204129 | 204129 | 2020-06-03 | Tensas | Louisiana | 22107 | 16 | 0 |
207210 | 207210 | 2020-06-04 | Tensas | Louisiana | 22107 | 16 | 0 |
210291 | 210291 | 2020-06-05 | Tensas | Louisiana | 22107 | 20 | 0 |
213376 | 213376 | 2020-06-06 | Tensas | Louisiana | 22107 | 21 | 0 |
216463 | 216463 | 2020-06-07 | Tensas | Louisiana | 22107 | 21 | 0 |
219555 | 219555 | 2020-06-08 | Tensas | Louisiana | 22107 | 21 | 0 |
222650 | 222650 | 2020-06-09 | Tensas | Louisiana | 22107 | 21 | 0 |
225746 | 225746 | 2020-06-10 | Tensas | Louisiana | 22107 | 21 | 0 |
228848 | 228848 | 2020-06-11 | Tensas | Louisiana | 22107 | 21 | 0 |
231952 | 231952 | 2020-06-12 | Tensas | Louisiana | 22107 | 21 | 0 |
235057 | 235057 | 2020-06-13 | Tensas | Louisiana | 22107 | 22 | 0 |
238164 | 238164 | 2020-06-14 | Tensas | Louisiana | 22107 | 22 | 0 |
241273 | 241273 | 2020-06-15 | Tensas | Louisiana | 22107 | 22 | 0 |
244384 | 244384 | 2020-06-16 | Tensas | Louisiana | 22107 | 22 | 0 |
247497 | 247497 | 2020-06-17 | Tensas | Louisiana | 22107 | 22 | 0 |
250609 | 250609 | 2020-06-18 | Tensas | Louisiana | 22107 | 22 | 0 |
253724 | 253724 | 2020-06-19 | Tensas | Louisiana | 22107 | 24 | 0 |
256844 | 256844 | 2020-06-20 | Tensas | Louisiana | 22107 | 24 | 0 |
259970 | 259970 | 2020-06-21 | Tensas | Louisiana | 22107 | 24 | 0 |
263099 | 263099 | 2020-06-22 | Tensas | Louisiana | 22107 | 24 | 0 |
266226 | 266226 | 2020-06-23 | Tensas | Louisiana | 22107 | 24 | 0 |
269359 | 269359 | 2020-06-24 | Tensas | Louisiana | 22107 | 24 | 0 |
272495 | 272495 | 2020-06-25 | Tensas | Louisiana | 22107 | 24 | 0 |
275638 | 275638 | 2020-06-26 | Tensas | Louisiana | 22107 | 24 | 0 |
278786 | 278786 | 2020-06-27 | Tensas | Louisiana | 22107 | 24 | 0 |
281934 | 281934 | 2020-06-28 | Tensas | Louisiana | 22107 | 24 | 0 |
285080 | 285080 | 2020-06-29 | Tensas | Louisiana | 22107 | 24 | 0 |
288229 | 288229 | 2020-06-30 | Tensas | Louisiana | 22107 | 26 | 0 |
291380 | 291380 | 2020-07-01 | Tensas | Louisiana | 22107 | 26 | 0 |
294534 | 294534 | 2020-07-02 | Tensas | Louisiana | 22107 | 26 | 0 |
297692 | 297692 | 2020-07-03 | Tensas | Louisiana | 22107 | 26 | 0 |
300854 | 300854 | 2020-07-04 | Tensas | Louisiana | 22107 | 26 | 0 |
304018 | 304018 | 2020-07-05 | Tensas | Louisiana | 22107 | 26 | 0 |
307185 | 307185 | 2020-07-06 | Tensas | Louisiana | 22107 | 27 | 0 |
310353 | 310353 | 2020-07-07 | Tensas | Louisiana | 22107 | 28 | 0 |
313523 | 313523 | 2020-07-08 | Tensas | Louisiana | 22107 | 30 | 0 |
316697 | 316697 | 2020-07-09 | Tensas | Louisiana | 22107 | 30 | 0 |
319872 | 319872 | 2020-07-10 | Tensas | Louisiana | 22107 | 32 | 0 |
323051 | 323051 | 2020-07-11 | Tensas | Louisiana | 22107 | 32 | 0 |
326234 | 326234 | 2020-07-12 | Tensas | Louisiana | 22107 | 32 | 0 |
329420 | 329420 | 2020-07-13 | Tensas | Louisiana | 22107 | 35 | 0 |
332607 | 332607 | 2020-07-14 | Tensas | Louisiana | 22107 | 35 | 0 |
335800 | 335800 | 2020-07-15 | Tensas | Louisiana | 22107 | 37 | 0 |
338996 | 338996 | 2020-07-16 | Tensas | Louisiana | 22107 | 38 | 0 |
342192 | 342192 | 2020-07-17 | Tensas | Louisiana | 22107 | 38 | 0 |
345392 | 345392 | 2020-07-18 | Tensas | Louisiana | 22107 | 38 | 0 |
348593 | 348593 | 2020-07-19 | Tensas | Louisiana | 22107 | 40 | 0 |
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);