ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Terrebonne" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
294535 | 294535 | 2020-07-02 | Terrebonne | Louisiana | 22109 | 1094 | 61 |
291381 | 291381 | 2020-07-01 | Terrebonne | Louisiana | 22109 | 1068 | 61 |
288230 | 288230 | 2020-06-30 | Terrebonne | Louisiana | 22109 | 1030 | 61 |
285081 | 285081 | 2020-06-29 | Terrebonne | Louisiana | 22109 | 1011 | 61 |
281935 | 281935 | 2020-06-28 | Terrebonne | Louisiana | 22109 | 988 | 61 |
278787 | 278787 | 2020-06-27 | Terrebonne | Louisiana | 22109 | 931 | 60 |
275639 | 275639 | 2020-06-26 | Terrebonne | Louisiana | 22109 | 931 | 60 |
272496 | 272496 | 2020-06-25 | Terrebonne | Louisiana | 22109 | 884 | 60 |
269360 | 269360 | 2020-06-24 | Terrebonne | Louisiana | 22109 | 874 | 60 |
266227 | 266227 | 2020-06-23 | Terrebonne | Louisiana | 22109 | 866 | 60 |
263100 | 263100 | 2020-06-22 | Terrebonne | Louisiana | 22109 | 857 | 60 |
259971 | 259971 | 2020-06-21 | Terrebonne | Louisiana | 22109 | 848 | 60 |
256845 | 256845 | 2020-06-20 | Terrebonne | Louisiana | 22109 | 839 | 60 |
253725 | 253725 | 2020-06-19 | Terrebonne | Louisiana | 22109 | 826 | 59 |
250610 | 250610 | 2020-06-18 | Terrebonne | Louisiana | 22109 | 826 | 58 |
247498 | 247498 | 2020-06-17 | Terrebonne | Louisiana | 22109 | 826 | 58 |
244385 | 244385 | 2020-06-16 | Terrebonne | Louisiana | 22109 | 818 | 58 |
241274 | 241274 | 2020-06-15 | Terrebonne | Louisiana | 22109 | 812 | 57 |
238165 | 238165 | 2020-06-14 | Terrebonne | Louisiana | 22109 | 801 | 57 |
235058 | 235058 | 2020-06-13 | Terrebonne | Louisiana | 22109 | 792 | 57 |
231953 | 231953 | 2020-06-12 | Terrebonne | Louisiana | 22109 | 780 | 57 |
228849 | 228849 | 2020-06-11 | Terrebonne | Louisiana | 22109 | 771 | 56 |
225747 | 225747 | 2020-06-10 | Terrebonne | Louisiana | 22109 | 761 | 56 |
222651 | 222651 | 2020-06-09 | Terrebonne | Louisiana | 22109 | 756 | 55 |
219556 | 219556 | 2020-06-08 | Terrebonne | Louisiana | 22109 | 748 | 55 |
216464 | 216464 | 2020-06-07 | Terrebonne | Louisiana | 22109 | 744 | 55 |
213377 | 213377 | 2020-06-06 | Terrebonne | Louisiana | 22109 | 738 | 55 |
210292 | 210292 | 2020-06-05 | Terrebonne | Louisiana | 22109 | 724 | 55 |
207211 | 207211 | 2020-06-04 | Terrebonne | Louisiana | 22109 | 719 | 55 |
204130 | 204130 | 2020-06-03 | Terrebonne | Louisiana | 22109 | 709 | 55 |
201053 | 201053 | 2020-06-02 | Terrebonne | Louisiana | 22109 | 692 | 54 |
197981 | 197981 | 2020-06-01 | Terrebonne | Louisiana | 22109 | 686 | 51 |
194910 | 194910 | 2020-05-31 | Terrebonne | Louisiana | 22109 | 679 | 52 |
191842 | 191842 | 2020-05-30 | Terrebonne | Louisiana | 22109 | 667 | 51 |
188778 | 188778 | 2020-05-29 | Terrebonne | Louisiana | 22109 | 653 | 49 |
185720 | 185720 | 2020-05-28 | Terrebonne | Louisiana | 22109 | 653 | 48 |
182665 | 182665 | 2020-05-27 | Terrebonne | Louisiana | 22109 | 647 | 48 |
179620 | 179620 | 2020-05-26 | Terrebonne | Louisiana | 22109 | 641 | 48 |
176576 | 176576 | 2020-05-25 | Terrebonne | Louisiana | 22109 | 639 | 48 |
173532 | 173532 | 2020-05-24 | Terrebonne | Louisiana | 22109 | 628 | 48 |
170491 | 170491 | 2020-05-23 | Terrebonne | Louisiana | 22109 | 626 | 48 |
167453 | 167453 | 2020-05-22 | Terrebonne | Louisiana | 22109 | 623 | 48 |
164417 | 164417 | 2020-05-21 | Terrebonne | Louisiana | 22109 | 614 | 45 |
161388 | 161388 | 2020-05-20 | Terrebonne | Louisiana | 22109 | 594 | 44 |
158362 | 158362 | 2020-05-19 | Terrebonne | Louisiana | 22109 | 591 | 44 |
155344 | 155344 | 2020-05-18 | Terrebonne | Louisiana | 22109 | 590 | 43 |
152330 | 152330 | 2020-05-17 | Terrebonne | Louisiana | 22109 | 585 | 43 |
149319 | 149319 | 2020-05-16 | Terrebonne | Louisiana | 22109 | 567 | 43 |
146314 | 146314 | 2020-05-15 | Terrebonne | Louisiana | 22109 | 557 | 43 |
143314 | 143314 | 2020-05-14 | Terrebonne | Louisiana | 22109 | 550 | 41 |
140319 | 140319 | 2020-05-13 | Terrebonne | Louisiana | 22109 | 542 | 39 |
137325 | 137325 | 2020-05-12 | Terrebonne | Louisiana | 22109 | 533 | 39 |
134335 | 134335 | 2020-05-11 | Terrebonne | Louisiana | 22109 | 528 | 39 |
131344 | 131344 | 2020-05-10 | Terrebonne | Louisiana | 22109 | 523 | 38 |
128354 | 128354 | 2020-05-09 | Terrebonne | Louisiana | 22109 | 523 | 37 |
125367 | 125367 | 2020-05-08 | Terrebonne | Louisiana | 22109 | 501 | 36 |
122385 | 122385 | 2020-05-07 | Terrebonne | Louisiana | 22109 | 499 | 35 |
119414 | 119414 | 2020-05-06 | Terrebonne | Louisiana | 22109 | 476 | 33 |
116453 | 116453 | 2020-05-05 | Terrebonne | Louisiana | 22109 | 469 | 32 |
113571 | 113571 | 2020-05-04 | Terrebonne | Louisiana | 22109 | 466 | 33 |
110694 | 110694 | 2020-05-03 | Terrebonne | Louisiana | 22109 | 459 | 33 |
107822 | 107822 | 2020-05-02 | Terrebonne | Louisiana | 22109 | 456 | 33 |
104958 | 104958 | 2020-05-01 | Terrebonne | Louisiana | 22109 | 450 | 33 |
102097 | 102097 | 2020-04-30 | Terrebonne | Louisiana | 22109 | 437 | 32 |
99245 | 99245 | 2020-04-29 | Terrebonne | Louisiana | 22109 | 389 | 31 |
96399 | 96399 | 2020-04-28 | Terrebonne | Louisiana | 22109 | 382 | 31 |
93564 | 93564 | 2020-04-27 | Terrebonne | Louisiana | 22109 | 375 | 26 |
90743 | 90743 | 2020-04-26 | Terrebonne | Louisiana | 22109 | 371 | 26 |
87927 | 87927 | 2020-04-25 | Terrebonne | Louisiana | 22109 | 366 | 26 |
85118 | 85118 | 2020-04-24 | Terrebonne | Louisiana | 22109 | 363 | 25 |
82314 | 82314 | 2020-04-23 | Terrebonne | Louisiana | 22109 | 357 | 25 |
79518 | 79518 | 2020-04-22 | Terrebonne | Louisiana | 22109 | 350 | 24 |
76732 | 76732 | 2020-04-21 | Terrebonne | Louisiana | 22109 | 346 | 25 |
73952 | 73952 | 2020-04-20 | Terrebonne | Louisiana | 22109 | 342 | 21 |
71180 | 71180 | 2020-04-19 | Terrebonne | Louisiana | 22109 | 320 | 21 |
68417 | 68417 | 2020-04-18 | Terrebonne | Louisiana | 22109 | 310 | 21 |
65668 | 65668 | 2020-04-17 | Terrebonne | Louisiana | 22109 | 293 | 18 |
62929 | 62929 | 2020-04-16 | Terrebonne | Louisiana | 22109 | 283 | 18 |
60208 | 60208 | 2020-04-15 | Terrebonne | Louisiana | 22109 | 273 | 18 |
57500 | 57500 | 2020-04-14 | Terrebonne | Louisiana | 22109 | 265 | 17 |
54802 | 54802 | 2020-04-13 | Terrebonne | Louisiana | 22109 | 260 | 14 |
52121 | 52121 | 2020-04-12 | Terrebonne | Louisiana | 22109 | 255 | 14 |
49451 | 49451 | 2020-04-11 | Terrebonne | Louisiana | 22109 | 248 | 14 |
46809 | 46809 | 2020-04-10 | Terrebonne | Louisiana | 22109 | 244 | 13 |
44201 | 44201 | 2020-04-09 | Terrebonne | Louisiana | 22109 | 233 | 13 |
41625 | 41625 | 2020-04-08 | Terrebonne | Louisiana | 22109 | 209 | 14 |
39073 | 39073 | 2020-04-07 | Terrebonne | Louisiana | 22109 | 194 | 11 |
36565 | 36565 | 2020-04-06 | Terrebonne | Louisiana | 22109 | 182 | 7 |
34107 | 34107 | 2020-04-05 | Terrebonne | Louisiana | 22109 | 148 | 8 |
31682 | 31682 | 2020-04-04 | Terrebonne | Louisiana | 22109 | 143 | 8 |
29304 | 29304 | 2020-04-03 | Terrebonne | Louisiana | 22109 | 102 | 2 |
26987 | 26987 | 2020-04-02 | Terrebonne | Louisiana | 22109 | 97 | 1 |
24736 | 24736 | 2020-04-01 | Terrebonne | Louisiana | 22109 | 55 | 1 |
22560 | 22560 | 2020-03-31 | Terrebonne | Louisiana | 22109 | 40 | 1 |
20451 | 20451 | 2020-03-30 | Terrebonne | Louisiana | 22109 | 34 | 1 |
18435 | 18435 | 2020-03-29 | Terrebonne | Louisiana | 22109 | 29 | 1 |
16521 | 16521 | 2020-03-28 | Terrebonne | Louisiana | 22109 | 26 | 1 |
14701 | 14701 | 2020-03-27 | Terrebonne | Louisiana | 22109 | 23 | 1 |
12994 | 12994 | 2020-03-26 | Terrebonne | Louisiana | 22109 | 21 | 0 |
11415 | 11415 | 2020-03-25 | Terrebonne | Louisiana | 22109 | 15 | 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);