l_c_goals
15 rows
Suggested facets: goal, first_effective, category, number_of_days, first_effective (date), last_effective (date)
| goal | first_effective | category | number_of_days | last_effective | active |
|---|---|---|---|---|---|
| Clos1 | 1935-01-01T00:00:00 | 1 | 147 | 0 | |
| Clos2 | 1935-01-01T00:00:00 | 2 | 119 | 0 | |
| Clos3 | 1935-01-01T00:00:00 | 3 | 91 | 0 | |
| Detr1 | 1935-01-01T00:00:00 | 1 | 91 | 2000-09-30T00:00:00 | 0 |
| Detr1 | 2000-10-01T00:00:00 | 1 | 70 | 0 | |
| Detr2 | 1935-01-01T00:00:00 | 2 | 63 | 2000-09-30T00:00:00 | 0 |
| Detr2 | 2000-10-01T00:00:00 | 2 | 49 | 0 | |
| Detr3 | 1935-01-01T00:00:00 | 3 | 35 | 0 | |
| Disp1 | 1935-01-01T00:00:00 | 1 | 105 | 2000-09-30T00:00:00 | 0 |
| Disp1 | 2000-10-01T00:00:00 | 1 | 84 | 0 | |
| Disp2 | 1935-01-01T00:00:00 | 2 | 77 | 2000-09-30T00:00:00 | 0 |
| Disp2 | 2000-10-01T00:00:00 | 2 | 63 | 0 | |
| Disp3 | 1935-01-01T00:00:00 | 3 | 49 | 0 | |
| Post | 1935-01-01T00:00:00 | 28 | 0 | ||
| Reins | 1935-01-01T00:00:00 | 14 | 0 |
Table schema
CREATE TABLE l_c_goals(goal VARCHAR, first_effective VARCHAR, category BIGINT, number_of_days BIGINT, last_effective VARCHAR, active BIGINT);