ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Lafourche" and fips = 22057 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 |
---|---|---|---|---|---|---|---|
2077 | 2077 | 2020-03-14 | Lafourche | Louisiana | 22057 | 1 | 0 |
2474 | 2474 | 2020-03-15 | Lafourche | Louisiana | 22057 | 1 | 0 |
2920 | 2920 | 2020-03-16 | Lafourche | Louisiana | 22057 | 2 | 0 |
3417 | 3417 | 2020-03-17 | Lafourche | Louisiana | 22057 | 2 | 0 |
3997 | 3997 | 2020-03-18 | Lafourche | Louisiana | 22057 | 3 | 0 |
4693 | 4693 | 2020-03-19 | Lafourche | Louisiana | 22057 | 4 | 0 |
5509 | 5509 | 2020-03-20 | Lafourche | Louisiana | 22057 | 5 | 0 |
6462 | 6462 | 2020-03-21 | Lafourche | Louisiana | 22057 | 11 | 0 |
7537 | 7537 | 2020-03-22 | Lafourche | Louisiana | 22057 | 12 | 0 |
8702 | 8702 | 2020-03-23 | Lafourche | Louisiana | 22057 | 15 | 0 |
9990 | 9990 | 2020-03-24 | Lafourche | Louisiana | 22057 | 16 | 0 |
11396 | 11396 | 2020-03-25 | Lafourche | Louisiana | 22057 | 18 | 1 |
12973 | 12973 | 2020-03-26 | Lafourche | Louisiana | 22057 | 28 | 1 |
14680 | 14680 | 2020-03-27 | Lafourche | Louisiana | 22057 | 30 | 2 |
16500 | 16500 | 2020-03-28 | Lafourche | Louisiana | 22057 | 34 | 2 |
18412 | 18412 | 2020-03-29 | Lafourche | Louisiana | 22057 | 36 | 2 |
20428 | 20428 | 2020-03-30 | Lafourche | Louisiana | 22057 | 51 | 2 |
22536 | 22536 | 2020-03-31 | Lafourche | Louisiana | 22057 | 74 | 2 |
24712 | 24712 | 2020-04-01 | Lafourche | Louisiana | 22057 | 105 | 4 |
26963 | 26963 | 2020-04-02 | Lafourche | Louisiana | 22057 | 158 | 4 |
29280 | 29280 | 2020-04-03 | Lafourche | Louisiana | 22057 | 185 | 3 |
31658 | 31658 | 2020-04-04 | Lafourche | Louisiana | 22057 | 217 | 3 |
34083 | 34083 | 2020-04-05 | Lafourche | Louisiana | 22057 | 228 | 4 |
36541 | 36541 | 2020-04-06 | Lafourche | Louisiana | 22057 | 305 | 7 |
39049 | 39049 | 2020-04-07 | Lafourche | Louisiana | 22057 | 322 | 7 |
41601 | 41601 | 2020-04-08 | Lafourche | Louisiana | 22057 | 355 | 11 |
44177 | 44177 | 2020-04-09 | Lafourche | Louisiana | 22057 | 393 | 11 |
46785 | 46785 | 2020-04-10 | Lafourche | Louisiana | 22057 | 426 | 13 |
49426 | 49426 | 2020-04-11 | Lafourche | Louisiana | 22057 | 454 | 13 |
52096 | 52096 | 2020-04-12 | Lafourche | Louisiana | 22057 | 468 | 13 |
54777 | 54777 | 2020-04-13 | Lafourche | Louisiana | 22057 | 481 | 13 |
57475 | 57475 | 2020-04-14 | Lafourche | Louisiana | 22057 | 486 | 13 |
60183 | 60183 | 2020-04-15 | Lafourche | Louisiana | 22057 | 499 | 15 |
62904 | 62904 | 2020-04-16 | Lafourche | Louisiana | 22057 | 528 | 16 |
65643 | 65643 | 2020-04-17 | Lafourche | Louisiana | 22057 | 542 | 21 |
68392 | 68392 | 2020-04-18 | Lafourche | Louisiana | 22057 | 560 | 22 |
71155 | 71155 | 2020-04-19 | Lafourche | Louisiana | 22057 | 566 | 25 |
73927 | 73927 | 2020-04-20 | Lafourche | Louisiana | 22057 | 573 | 27 |
76707 | 76707 | 2020-04-21 | Lafourche | Louisiana | 22057 | 576 | 30 |
79493 | 79493 | 2020-04-22 | Lafourche | Louisiana | 22057 | 583 | 32 |
82289 | 82289 | 2020-04-23 | Lafourche | Louisiana | 22057 | 603 | 32 |
85093 | 85093 | 2020-04-24 | Lafourche | Louisiana | 22057 | 607 | 35 |
87902 | 87902 | 2020-04-25 | Lafourche | Louisiana | 22057 | 610 | 39 |
90718 | 90718 | 2020-04-26 | Lafourche | Louisiana | 22057 | 624 | 39 |
93539 | 93539 | 2020-04-27 | Lafourche | Louisiana | 22057 | 632 | 39 |
96374 | 96374 | 2020-04-28 | Lafourche | Louisiana | 22057 | 635 | 39 |
99220 | 99220 | 2020-04-29 | Lafourche | Louisiana | 22057 | 651 | 44 |
102072 | 102072 | 2020-04-30 | Lafourche | Louisiana | 22057 | 651 | 45 |
104933 | 104933 | 2020-05-01 | Lafourche | Louisiana | 22057 | 661 | 50 |
107797 | 107797 | 2020-05-02 | Lafourche | Louisiana | 22057 | 666 | 52 |
110669 | 110669 | 2020-05-03 | Lafourche | Louisiana | 22057 | 669 | 52 |
113546 | 113546 | 2020-05-04 | Lafourche | Louisiana | 22057 | 681 | 52 |
116428 | 116428 | 2020-05-05 | Lafourche | Louisiana | 22057 | 686 | 53 |
119389 | 119389 | 2020-05-06 | Lafourche | Louisiana | 22057 | 692 | 53 |
122360 | 122360 | 2020-05-07 | Lafourche | Louisiana | 22057 | 693 | 55 |
125342 | 125342 | 2020-05-08 | Lafourche | Louisiana | 22057 | 698 | 57 |
128329 | 128329 | 2020-05-09 | Lafourche | Louisiana | 22057 | 706 | 59 |
131319 | 131319 | 2020-05-10 | Lafourche | Louisiana | 22057 | 711 | 59 |
134310 | 134310 | 2020-05-11 | Lafourche | Louisiana | 22057 | 713 | 59 |
137300 | 137300 | 2020-05-12 | Lafourche | Louisiana | 22057 | 715 | 60 |
140294 | 140294 | 2020-05-13 | Lafourche | Louisiana | 22057 | 716 | 60 |
143289 | 143289 | 2020-05-14 | Lafourche | Louisiana | 22057 | 719 | 60 |
146289 | 146289 | 2020-05-15 | Lafourche | Louisiana | 22057 | 724 | 63 |
149294 | 149294 | 2020-05-16 | Lafourche | Louisiana | 22057 | 738 | 63 |
152305 | 152305 | 2020-05-17 | Lafourche | Louisiana | 22057 | 742 | 63 |
155319 | 155319 | 2020-05-18 | Lafourche | Louisiana | 22057 | 744 | 64 |
158337 | 158337 | 2020-05-19 | Lafourche | Louisiana | 22057 | 750 | 64 |
161363 | 161363 | 2020-05-20 | Lafourche | Louisiana | 22057 | 753 | 64 |
164392 | 164392 | 2020-05-21 | Lafourche | Louisiana | 22057 | 763 | 64 |
167428 | 167428 | 2020-05-22 | Lafourche | Louisiana | 22057 | 766 | 65 |
170466 | 170466 | 2020-05-23 | Lafourche | Louisiana | 22057 | 766 | 68 |
173507 | 173507 | 2020-05-24 | Lafourche | Louisiana | 22057 | 766 | 68 |
176551 | 176551 | 2020-05-25 | Lafourche | Louisiana | 22057 | 775 | 68 |
179595 | 179595 | 2020-05-26 | Lafourche | Louisiana | 22057 | 776 | 71 |
182640 | 182640 | 2020-05-27 | Lafourche | Louisiana | 22057 | 781 | 71 |
185695 | 185695 | 2020-05-28 | Lafourche | Louisiana | 22057 | 789 | 71 |
188753 | 188753 | 2020-05-29 | Lafourche | Louisiana | 22057 | 789 | 71 |
191817 | 191817 | 2020-05-30 | Lafourche | Louisiana | 22057 | 809 | 71 |
194885 | 194885 | 2020-05-31 | Lafourche | Louisiana | 22057 | 821 | 71 |
197956 | 197956 | 2020-06-01 | Lafourche | Louisiana | 22057 | 827 | 72 |
201028 | 201028 | 2020-06-02 | Lafourche | Louisiana | 22057 | 867 | 72 |
204105 | 204105 | 2020-06-03 | Lafourche | Louisiana | 22057 | 878 | 72 |
207186 | 207186 | 2020-06-04 | Lafourche | Louisiana | 22057 | 882 | 72 |
210267 | 210267 | 2020-06-05 | Lafourche | Louisiana | 22057 | 886 | 73 |
213352 | 213352 | 2020-06-06 | Lafourche | Louisiana | 22057 | 896 | 74 |
216439 | 216439 | 2020-06-07 | Lafourche | Louisiana | 22057 | 902 | 75 |
219531 | 219531 | 2020-06-08 | Lafourche | Louisiana | 22057 | 909 | 75 |
222626 | 222626 | 2020-06-09 | Lafourche | Louisiana | 22057 | 922 | 76 |
225722 | 225722 | 2020-06-10 | Lafourche | Louisiana | 22057 | 928 | 76 |
228824 | 228824 | 2020-06-11 | Lafourche | Louisiana | 22057 | 937 | 77 |
231928 | 231928 | 2020-06-12 | Lafourche | Louisiana | 22057 | 945 | 77 |
235033 | 235033 | 2020-06-13 | Lafourche | Louisiana | 22057 | 968 | 77 |
238140 | 238140 | 2020-06-14 | Lafourche | Louisiana | 22057 | 973 | 77 |
241249 | 241249 | 2020-06-15 | Lafourche | Louisiana | 22057 | 983 | 77 |
244360 | 244360 | 2020-06-16 | Lafourche | Louisiana | 22057 | 999 | 77 |
247473 | 247473 | 2020-06-17 | Lafourche | Louisiana | 22057 | 1013 | 78 |
250585 | 250585 | 2020-06-18 | Lafourche | Louisiana | 22057 | 1013 | 78 |
253700 | 253700 | 2020-06-19 | Lafourche | Louisiana | 22057 | 998 | 83 |
256820 | 256820 | 2020-06-20 | Lafourche | Louisiana | 22057 | 1005 | 83 |
259946 | 259946 | 2020-06-21 | Lafourche | Louisiana | 22057 | 1010 | 83 |
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);