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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5520 | 5520 | 2020-03-20 | Tangipahoa | Louisiana | 22105 | 1 | 0 |
6475 | 6475 | 2020-03-21 | Tangipahoa | Louisiana | 22105 | 3 | 0 |
7550 | 7550 | 2020-03-22 | Tangipahoa | Louisiana | 22105 | 3 | 0 |
8719 | 8719 | 2020-03-23 | Tangipahoa | Louisiana | 22105 | 3 | 0 |
10007 | 10007 | 2020-03-24 | Tangipahoa | Louisiana | 22105 | 4 | 0 |
11414 | 11414 | 2020-03-25 | Tangipahoa | Louisiana | 22105 | 5 | 0 |
12993 | 12993 | 2020-03-26 | Tangipahoa | Louisiana | 22105 | 7 | 0 |
14700 | 14700 | 2020-03-27 | Tangipahoa | Louisiana | 22105 | 7 | 0 |
16520 | 16520 | 2020-03-28 | Tangipahoa | Louisiana | 22105 | 10 | 0 |
18434 | 18434 | 2020-03-29 | Tangipahoa | Louisiana | 22105 | 10 | 0 |
20450 | 20450 | 2020-03-30 | Tangipahoa | Louisiana | 22105 | 18 | 0 |
22559 | 22559 | 2020-03-31 | Tangipahoa | Louisiana | 22105 | 25 | 0 |
24735 | 24735 | 2020-04-01 | Tangipahoa | Louisiana | 22105 | 33 | 2 |
26986 | 26986 | 2020-04-02 | Tangipahoa | Louisiana | 22105 | 42 | 1 |
29303 | 29303 | 2020-04-03 | Tangipahoa | Louisiana | 22105 | 55 | 1 |
31681 | 31681 | 2020-04-04 | Tangipahoa | Louisiana | 22105 | 131 | 2 |
34106 | 34106 | 2020-04-05 | Tangipahoa | Louisiana | 22105 | 171 | 2 |
36564 | 36564 | 2020-04-06 | Tangipahoa | Louisiana | 22105 | 186 | 2 |
39072 | 39072 | 2020-04-07 | Tangipahoa | Louisiana | 22105 | 238 | 3 |
41624 | 41624 | 2020-04-08 | Tangipahoa | Louisiana | 22105 | 269 | 4 |
44200 | 44200 | 2020-04-09 | Tangipahoa | Louisiana | 22105 | 283 | 5 |
46808 | 46808 | 2020-04-10 | Tangipahoa | Louisiana | 22105 | 305 | 6 |
49449 | 49449 | 2020-04-11 | Tangipahoa | Louisiana | 22105 | 318 | 7 |
52119 | 52119 | 2020-04-12 | Tangipahoa | Louisiana | 22105 | 344 | 8 |
54800 | 54800 | 2020-04-13 | Tangipahoa | Louisiana | 22105 | 352 | 11 |
57498 | 57498 | 2020-04-14 | Tangipahoa | Louisiana | 22105 | 391 | 11 |
60206 | 60206 | 2020-04-15 | Tangipahoa | Louisiana | 22105 | 418 | 15 |
62927 | 62927 | 2020-04-16 | Tangipahoa | Louisiana | 22105 | 422 | 16 |
65666 | 65666 | 2020-04-17 | Tangipahoa | Louisiana | 22105 | 435 | 18 |
68415 | 68415 | 2020-04-18 | Tangipahoa | Louisiana | 22105 | 440 | 18 |
71178 | 71178 | 2020-04-19 | Tangipahoa | Louisiana | 22105 | 442 | 18 |
73950 | 73950 | 2020-04-20 | Tangipahoa | Louisiana | 22105 | 452 | 19 |
76730 | 76730 | 2020-04-21 | Tangipahoa | Louisiana | 22105 | 489 | 19 |
79516 | 79516 | 2020-04-22 | Tangipahoa | Louisiana | 22105 | 494 | 18 |
82312 | 82312 | 2020-04-23 | Tangipahoa | Louisiana | 22105 | 501 | 18 |
85116 | 85116 | 2020-04-24 | Tangipahoa | Louisiana | 22105 | 508 | 21 |
87925 | 87925 | 2020-04-25 | Tangipahoa | Louisiana | 22105 | 526 | 21 |
90741 | 90741 | 2020-04-26 | Tangipahoa | Louisiana | 22105 | 528 | 21 |
93562 | 93562 | 2020-04-27 | Tangipahoa | Louisiana | 22105 | 535 | 21 |
96397 | 96397 | 2020-04-28 | Tangipahoa | Louisiana | 22105 | 540 | 21 |
99243 | 99243 | 2020-04-29 | Tangipahoa | Louisiana | 22105 | 549 | 21 |
102095 | 102095 | 2020-04-30 | Tangipahoa | Louisiana | 22105 | 553 | 22 |
104956 | 104956 | 2020-05-01 | Tangipahoa | Louisiana | 22105 | 565 | 23 |
107820 | 107820 | 2020-05-02 | Tangipahoa | Louisiana | 22105 | 584 | 23 |
110692 | 110692 | 2020-05-03 | Tangipahoa | Louisiana | 22105 | 584 | 23 |
113569 | 113569 | 2020-05-04 | Tangipahoa | Louisiana | 22105 | 588 | 23 |
116451 | 116451 | 2020-05-05 | Tangipahoa | Louisiana | 22105 | 605 | 23 |
119412 | 119412 | 2020-05-06 | Tangipahoa | Louisiana | 22105 | 631 | 25 |
122383 | 122383 | 2020-05-07 | Tangipahoa | Louisiana | 22105 | 635 | 26 |
125365 | 125365 | 2020-05-08 | Tangipahoa | Louisiana | 22105 | 645 | 27 |
128352 | 128352 | 2020-05-09 | Tangipahoa | Louisiana | 22105 | 652 | 27 |
131342 | 131342 | 2020-05-10 | Tangipahoa | Louisiana | 22105 | 654 | 28 |
134333 | 134333 | 2020-05-11 | Tangipahoa | Louisiana | 22105 | 670 | 28 |
137323 | 137323 | 2020-05-12 | Tangipahoa | Louisiana | 22105 | 679 | 29 |
140317 | 140317 | 2020-05-13 | Tangipahoa | Louisiana | 22105 | 687 | 30 |
143312 | 143312 | 2020-05-14 | Tangipahoa | Louisiana | 22105 | 696 | 30 |
146312 | 146312 | 2020-05-15 | Tangipahoa | Louisiana | 22105 | 707 | 30 |
149317 | 149317 | 2020-05-16 | Tangipahoa | Louisiana | 22105 | 719 | 31 |
152328 | 152328 | 2020-05-17 | Tangipahoa | Louisiana | 22105 | 729 | 30 |
155342 | 155342 | 2020-05-18 | Tangipahoa | Louisiana | 22105 | 732 | 30 |
158360 | 158360 | 2020-05-19 | Tangipahoa | Louisiana | 22105 | 742 | 30 |
161386 | 161386 | 2020-05-20 | Tangipahoa | Louisiana | 22105 | 752 | 30 |
164415 | 164415 | 2020-05-21 | Tangipahoa | Louisiana | 22105 | 767 | 31 |
167451 | 167451 | 2020-05-22 | Tangipahoa | Louisiana | 22105 | 782 | 32 |
170489 | 170489 | 2020-05-23 | Tangipahoa | Louisiana | 22105 | 784 | 32 |
173530 | 173530 | 2020-05-24 | Tangipahoa | Louisiana | 22105 | 784 | 32 |
176574 | 176574 | 2020-05-25 | Tangipahoa | Louisiana | 22105 | 802 | 32 |
179618 | 179618 | 2020-05-26 | Tangipahoa | Louisiana | 22105 | 810 | 33 |
182663 | 182663 | 2020-05-27 | Tangipahoa | Louisiana | 22105 | 826 | 33 |
185718 | 185718 | 2020-05-28 | Tangipahoa | Louisiana | 22105 | 831 | 34 |
188776 | 188776 | 2020-05-29 | Tangipahoa | Louisiana | 22105 | 831 | 34 |
191840 | 191840 | 2020-05-30 | Tangipahoa | Louisiana | 22105 | 854 | 35 |
194908 | 194908 | 2020-05-31 | Tangipahoa | Louisiana | 22105 | 858 | 35 |
197979 | 197979 | 2020-06-01 | Tangipahoa | Louisiana | 22105 | 868 | 35 |
201051 | 201051 | 2020-06-02 | Tangipahoa | Louisiana | 22105 | 883 | 37 |
204128 | 204128 | 2020-06-03 | Tangipahoa | Louisiana | 22105 | 891 | 39 |
207209 | 207209 | 2020-06-04 | Tangipahoa | Louisiana | 22105 | 898 | 39 |
210290 | 210290 | 2020-06-05 | Tangipahoa | Louisiana | 22105 | 916 | 39 |
213375 | 213375 | 2020-06-06 | Tangipahoa | Louisiana | 22105 | 935 | 39 |
216462 | 216462 | 2020-06-07 | Tangipahoa | Louisiana | 22105 | 944 | 39 |
219554 | 219554 | 2020-06-08 | Tangipahoa | Louisiana | 22105 | 944 | 39 |
222649 | 222649 | 2020-06-09 | Tangipahoa | Louisiana | 22105 | 965 | 39 |
225745 | 225745 | 2020-06-10 | Tangipahoa | Louisiana | 22105 | 973 | 41 |
228847 | 228847 | 2020-06-11 | Tangipahoa | Louisiana | 22105 | 984 | 42 |
231951 | 231951 | 2020-06-12 | Tangipahoa | Louisiana | 22105 | 1001 | 42 |
235056 | 235056 | 2020-06-13 | Tangipahoa | Louisiana | 22105 | 1039 | 42 |
238163 | 238163 | 2020-06-14 | Tangipahoa | Louisiana | 22105 | 1042 | 42 |
241272 | 241272 | 2020-06-15 | Tangipahoa | Louisiana | 22105 | 1048 | 42 |
244383 | 244383 | 2020-06-16 | Tangipahoa | Louisiana | 22105 | 1062 | 42 |
253723 | 253723 | 2020-06-19 | Tangipahoa | Louisiana | 22105 | 1078 | 42 |
247496 | 247496 | 2020-06-17 | Tangipahoa | Louisiana | 22105 | 1082 | 42 |
250608 | 250608 | 2020-06-18 | Tangipahoa | Louisiana | 22105 | 1082 | 42 |
256843 | 256843 | 2020-06-20 | Tangipahoa | Louisiana | 22105 | 1112 | 42 |
259969 | 259969 | 2020-06-21 | Tangipahoa | Louisiana | 22105 | 1120 | 42 |
263098 | 263098 | 2020-06-22 | Tangipahoa | Louisiana | 22105 | 1123 | 42 |
266225 | 266225 | 2020-06-23 | Tangipahoa | Louisiana | 22105 | 1163 | 42 |
269358 | 269358 | 2020-06-24 | Tangipahoa | Louisiana | 22105 | 1184 | 43 |
272494 | 272494 | 2020-06-25 | Tangipahoa | Louisiana | 22105 | 1218 | 43 |
275637 | 275637 | 2020-06-26 | Tangipahoa | Louisiana | 22105 | 1248 | 43 |
278785 | 278785 | 2020-06-27 | Tangipahoa | Louisiana | 22105 | 1248 | 43 |
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);