ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 22105 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387105 | 387105 | 2020-07-31 | Tangipahoa | Louisiana | 22105 | 3037 | 62 |
383887 | 383887 | 2020-07-30 | Tangipahoa | Louisiana | 22105 | 3001 | 61 |
380670 | 380670 | 2020-07-29 | Tangipahoa | Louisiana | 22105 | 2955 | 58 |
377453 | 377453 | 2020-07-28 | Tangipahoa | Louisiana | 22105 | 2916 | 58 |
374238 | 374238 | 2020-07-27 | Tangipahoa | Louisiana | 22105 | 2895 | 56 |
371026 | 371026 | 2020-07-26 | Tangipahoa | Louisiana | 22105 | 2777 | 56 |
367816 | 367816 | 2020-07-25 | Tangipahoa | Louisiana | 22105 | 2692 | 54 |
364609 | 364609 | 2020-07-24 | Tangipahoa | Louisiana | 22105 | 2692 | 54 |
361402 | 361402 | 2020-07-23 | Tangipahoa | Louisiana | 22105 | 2624 | 53 |
358197 | 358197 | 2020-07-22 | Tangipahoa | Louisiana | 22105 | 2536 | 53 |
354994 | 354994 | 2020-07-21 | Tangipahoa | Louisiana | 22105 | 2464 | 47 |
351792 | 351792 | 2020-07-20 | Tangipahoa | Louisiana | 22105 | 2447 | 47 |
348592 | 348592 | 2020-07-19 | Tangipahoa | Louisiana | 22105 | 2300 | 47 |
345391 | 345391 | 2020-07-18 | Tangipahoa | Louisiana | 22105 | 2217 | 46 |
342191 | 342191 | 2020-07-17 | Tangipahoa | Louisiana | 22105 | 2217 | 46 |
338995 | 338995 | 2020-07-16 | Tangipahoa | Louisiana | 22105 | 2142 | 46 |
335799 | 335799 | 2020-07-15 | Tangipahoa | Louisiana | 22105 | 2081 | 45 |
332606 | 332606 | 2020-07-14 | Tangipahoa | Louisiana | 22105 | 2020 | 44 |
329419 | 329419 | 2020-07-13 | Tangipahoa | Louisiana | 22105 | 1914 | 44 |
326233 | 326233 | 2020-07-12 | Tangipahoa | Louisiana | 22105 | 1894 | 44 |
323050 | 323050 | 2020-07-11 | Tangipahoa | Louisiana | 22105 | 1874 | 44 |
319871 | 319871 | 2020-07-10 | Tangipahoa | Louisiana | 22105 | 1802 | 44 |
316696 | 316696 | 2020-07-09 | Tangipahoa | Louisiana | 22105 | 1742 | 43 |
313522 | 313522 | 2020-07-08 | Tangipahoa | Louisiana | 22105 | 1689 | 43 |
310352 | 310352 | 2020-07-07 | Tangipahoa | Louisiana | 22105 | 1624 | 43 |
307184 | 307184 | 2020-07-06 | Tangipahoa | Louisiana | 22105 | 1541 | 43 |
304017 | 304017 | 2020-07-05 | Tangipahoa | Louisiana | 22105 | 1513 | 43 |
300853 | 300853 | 2020-07-04 | Tangipahoa | Louisiana | 22105 | 1462 | 43 |
297691 | 297691 | 2020-07-03 | Tangipahoa | Louisiana | 22105 | 1462 | 43 |
294533 | 294533 | 2020-07-02 | Tangipahoa | Louisiana | 22105 | 1394 | 43 |
291379 | 291379 | 2020-07-01 | Tangipahoa | Louisiana | 22105 | 1353 | 43 |
288228 | 288228 | 2020-06-30 | Tangipahoa | Louisiana | 22105 | 1304 | 43 |
285079 | 285079 | 2020-06-29 | Tangipahoa | Louisiana | 22105 | 1295 | 43 |
281933 | 281933 | 2020-06-28 | Tangipahoa | Louisiana | 22105 | 1273 | 43 |
278785 | 278785 | 2020-06-27 | Tangipahoa | Louisiana | 22105 | 1248 | 43 |
275637 | 275637 | 2020-06-26 | Tangipahoa | Louisiana | 22105 | 1248 | 43 |
272494 | 272494 | 2020-06-25 | Tangipahoa | Louisiana | 22105 | 1218 | 43 |
269358 | 269358 | 2020-06-24 | Tangipahoa | Louisiana | 22105 | 1184 | 43 |
266225 | 266225 | 2020-06-23 | Tangipahoa | Louisiana | 22105 | 1163 | 42 |
263098 | 263098 | 2020-06-22 | Tangipahoa | Louisiana | 22105 | 1123 | 42 |
259969 | 259969 | 2020-06-21 | Tangipahoa | Louisiana | 22105 | 1120 | 42 |
256843 | 256843 | 2020-06-20 | Tangipahoa | Louisiana | 22105 | 1112 | 42 |
253723 | 253723 | 2020-06-19 | Tangipahoa | Louisiana | 22105 | 1078 | 42 |
250608 | 250608 | 2020-06-18 | Tangipahoa | Louisiana | 22105 | 1082 | 42 |
247496 | 247496 | 2020-06-17 | Tangipahoa | Louisiana | 22105 | 1082 | 42 |
244383 | 244383 | 2020-06-16 | Tangipahoa | Louisiana | 22105 | 1062 | 42 |
241272 | 241272 | 2020-06-15 | Tangipahoa | Louisiana | 22105 | 1048 | 42 |
238163 | 238163 | 2020-06-14 | Tangipahoa | Louisiana | 22105 | 1042 | 42 |
235056 | 235056 | 2020-06-13 | Tangipahoa | Louisiana | 22105 | 1039 | 42 |
231951 | 231951 | 2020-06-12 | Tangipahoa | Louisiana | 22105 | 1001 | 42 |
228847 | 228847 | 2020-06-11 | Tangipahoa | Louisiana | 22105 | 984 | 42 |
225745 | 225745 | 2020-06-10 | Tangipahoa | Louisiana | 22105 | 973 | 41 |
222649 | 222649 | 2020-06-09 | Tangipahoa | Louisiana | 22105 | 965 | 39 |
219554 | 219554 | 2020-06-08 | Tangipahoa | Louisiana | 22105 | 944 | 39 |
216462 | 216462 | 2020-06-07 | Tangipahoa | Louisiana | 22105 | 944 | 39 |
213375 | 213375 | 2020-06-06 | Tangipahoa | Louisiana | 22105 | 935 | 39 |
210290 | 210290 | 2020-06-05 | Tangipahoa | Louisiana | 22105 | 916 | 39 |
207209 | 207209 | 2020-06-04 | Tangipahoa | Louisiana | 22105 | 898 | 39 |
204128 | 204128 | 2020-06-03 | Tangipahoa | Louisiana | 22105 | 891 | 39 |
201051 | 201051 | 2020-06-02 | Tangipahoa | Louisiana | 22105 | 883 | 37 |
197979 | 197979 | 2020-06-01 | Tangipahoa | Louisiana | 22105 | 868 | 35 |
194908 | 194908 | 2020-05-31 | Tangipahoa | Louisiana | 22105 | 858 | 35 |
191840 | 191840 | 2020-05-30 | Tangipahoa | Louisiana | 22105 | 854 | 35 |
188776 | 188776 | 2020-05-29 | Tangipahoa | Louisiana | 22105 | 831 | 34 |
185718 | 185718 | 2020-05-28 | Tangipahoa | Louisiana | 22105 | 831 | 34 |
182663 | 182663 | 2020-05-27 | Tangipahoa | Louisiana | 22105 | 826 | 33 |
179618 | 179618 | 2020-05-26 | Tangipahoa | Louisiana | 22105 | 810 | 33 |
176574 | 176574 | 2020-05-25 | Tangipahoa | Louisiana | 22105 | 802 | 32 |
173530 | 173530 | 2020-05-24 | Tangipahoa | Louisiana | 22105 | 784 | 32 |
170489 | 170489 | 2020-05-23 | Tangipahoa | Louisiana | 22105 | 784 | 32 |
167451 | 167451 | 2020-05-22 | Tangipahoa | Louisiana | 22105 | 782 | 32 |
164415 | 164415 | 2020-05-21 | Tangipahoa | Louisiana | 22105 | 767 | 31 |
161386 | 161386 | 2020-05-20 | Tangipahoa | Louisiana | 22105 | 752 | 30 |
158360 | 158360 | 2020-05-19 | Tangipahoa | Louisiana | 22105 | 742 | 30 |
155342 | 155342 | 2020-05-18 | Tangipahoa | Louisiana | 22105 | 732 | 30 |
152328 | 152328 | 2020-05-17 | Tangipahoa | Louisiana | 22105 | 729 | 30 |
149317 | 149317 | 2020-05-16 | Tangipahoa | Louisiana | 22105 | 719 | 31 |
146312 | 146312 | 2020-05-15 | Tangipahoa | Louisiana | 22105 | 707 | 30 |
143312 | 143312 | 2020-05-14 | Tangipahoa | Louisiana | 22105 | 696 | 30 |
140317 | 140317 | 2020-05-13 | Tangipahoa | Louisiana | 22105 | 687 | 30 |
137323 | 137323 | 2020-05-12 | Tangipahoa | Louisiana | 22105 | 679 | 29 |
134333 | 134333 | 2020-05-11 | Tangipahoa | Louisiana | 22105 | 670 | 28 |
131342 | 131342 | 2020-05-10 | Tangipahoa | Louisiana | 22105 | 654 | 28 |
128352 | 128352 | 2020-05-09 | Tangipahoa | Louisiana | 22105 | 652 | 27 |
125365 | 125365 | 2020-05-08 | Tangipahoa | Louisiana | 22105 | 645 | 27 |
122383 | 122383 | 2020-05-07 | Tangipahoa | Louisiana | 22105 | 635 | 26 |
119412 | 119412 | 2020-05-06 | Tangipahoa | Louisiana | 22105 | 631 | 25 |
116451 | 116451 | 2020-05-05 | Tangipahoa | Louisiana | 22105 | 605 | 23 |
113569 | 113569 | 2020-05-04 | Tangipahoa | Louisiana | 22105 | 588 | 23 |
110692 | 110692 | 2020-05-03 | Tangipahoa | Louisiana | 22105 | 584 | 23 |
107820 | 107820 | 2020-05-02 | Tangipahoa | Louisiana | 22105 | 584 | 23 |
104956 | 104956 | 2020-05-01 | Tangipahoa | Louisiana | 22105 | 565 | 23 |
102095 | 102095 | 2020-04-30 | Tangipahoa | Louisiana | 22105 | 553 | 22 |
99243 | 99243 | 2020-04-29 | Tangipahoa | Louisiana | 22105 | 549 | 21 |
96397 | 96397 | 2020-04-28 | Tangipahoa | Louisiana | 22105 | 540 | 21 |
93562 | 93562 | 2020-04-27 | Tangipahoa | Louisiana | 22105 | 535 | 21 |
90741 | 90741 | 2020-04-26 | Tangipahoa | Louisiana | 22105 | 528 | 21 |
87925 | 87925 | 2020-04-25 | Tangipahoa | Louisiana | 22105 | 526 | 21 |
85116 | 85116 | 2020-04-24 | Tangipahoa | Louisiana | 22105 | 508 | 21 |
82312 | 82312 | 2020-04-23 | Tangipahoa | Louisiana | 22105 | 501 | 18 |
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);