c_settlement

29,253 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ c_case_number action_sequence recurrence proposal_letter_sent_date proposed_approval__date inf_settle_approved inf_settle_participation inf_settle_scope inf_settle_revoked fs_settlement_sent_ops fs_submitted_to formal_scope fs_board_determination fs_determination_date determination_rcvd_reg formal_participation
1 1 01-CA-19958-001 0 0 1983-02-18T00:00:00 1983-02-25T00:00:00 1983-03-21T00:00:00 Unil Full                
2 2 01-CA-21943-001 0 0     2001-05-08T00:00:00 Bilat Full                
3 3 01-CA-22040-002 1 0     2001-05-08T00:00:00 Bilat Full                
4 4 01-CA-22769-001 0 0     1986-10-29T00:00:00 Bilat Full                
5 5 01-CA-23307-001 1 0     2001-05-08T00:00:00 Bilat Full                
6 6 01-CA-23748-001 1 0     2001-05-08T00:00:00 Bilat Full                
7 7 01-CA-24161-001 0 0     2001-05-08T00:00:00 Bilat Full                
8 8 01-CA-24390-002 0 0     2001-05-08T00:00:00 Bilat Full                
9 9 01-CA-24528-001 0 0     2001-05-08T00:00:00 Bilat Full                
10 10 01-CA-24863-001 0 0     1988-08-16T00:00:00 Bilat Full                
11 11 01-CA-24883-001 0 0     1988-08-16T00:00:00 Bilat Full                
12 12 01-CA-24921-001 0 0     2001-05-08T00:00:00 Bilat Full                
13 13 01-CA-24967-001 0 0     2001-05-08T00:00:00 Bilat Full                
14 14 01-CA-25033-001 0 0     2001-05-08T00:00:00 Bilat Full                
15 15 01-CA-25237-001 0 0     2001-05-08T00:00:00 Bilat Full                
16 16 01-CA-25237-002 0 0     2001-05-08T00:00:00 Bilat Full                
17 17 01-CA-25341-001 0 0     2001-05-08T00:00:00 Bilat Full                
18 18 01-CA-25867-001 0 0     2001-05-08T00:00:00 Bilat Full                
19 19 01-CA-26098-001 0 0 1989-05-11T00:00:00 1989-05-18T00:00:00 1989-05-19T00:00:00 Unil Full                
20 20 01-CA-26232-001 0 0     1992-01-09T00:00:00 Bilat Full                
21 21 01-CA-26237-001 0 0     1992-01-09T00:00:00 Bilat Full                
22 22 01-CA-27197-001 0 0     1990-06-28T00:00:00 Bilat Full                
23 23 01-CA-27335-001 0 0     1993-03-29T00:00:00 Bilat Full                
24 24 01-CA-27356-001 0 0     1990-11-26T00:00:00 Bilat Full                
25 25 01-CA-27417-001 0 0     1990-11-26T00:00:00 Bilat Full                
26 26 01-CA-27421-001 0 0 1991-11-19T00:00:00 1991-11-26T00:00:00 1991-11-27T00:00:00 Unil Full                
27 27 01-CA-27491-001 0 0     1991-11-12T00:00:00 Bilat Full                
28 28 01-CA-27659-001 0 0     1991-11-12T00:00:00 Bilat Full                
29 29 01-CA-27732-001 0 0     1991-11-12T00:00:00 Bilat Full                
30 30 01-CA-27732-002 0 0     1991-11-12T00:00:00 Bilat Full                
31 31 01-CA-27766-001 0 0 1991-11-13T00:00:00 1991-11-20T00:00:00 1991-12-19T00:00:00 Unil Full                
32 32 01-CA-27937-001 0 0 1991-11-19T00:00:00 1991-11-26T00:00:00 1991-11-27T00:00:00 Unil Full                
33 33 01-CA-28064-001 0 0     1991-11-19T00:00:00 Bilat Full                
34 34 01-CA-28297-001 0 0     1995-04-07T00:00:00 Unil Full                
35 35 01-CA-28298-001 0 0     1995-04-07T00:00:00 Unil Full                
36 36 01-CA-28348-001 0 0     1993-02-19T00:00:00 Bilat Full                
37 37 01-CA-28375-001 0 0     1991-12-11T00:00:00 Bilat Full                
38 38 01-CA-28376-001 0 0     1992-08-28T00:00:00 Bilat Full                
39 39 01-CA-28466-001 0 0     1993-05-19T00:00:00 Bilat Full                
40 40 01-CA-28481-001 0 0     1992-08-28T00:00:00 Bilat Full                
41 41 01-CA-28493-001 0 0     1991-11-19T00:00:00 Bilat Full                
42 42 01-CA-28518-001 0 0 1993-06-08T00:00:00   1993-06-17T00:00:00 Unil Full                
43 43 01-CA-28558-001 0 0     1993-08-12T00:00:00 Bilat Full                
44 44 01-CA-28617-001 0 0     1992-08-28T00:00:00 Bilat Full                
45 45 01-CA-28767-001 0 0     1993-02-19T00:00:00 Bilat Full                
46 46 01-CA-28818-001 0 0     1993-02-19T00:00:00 Bilat Full                
47 47 01-CA-28892-001 0 0     1992-01-07T00:00:00 Bilat Full                
48 48 01-CA-29137-001 0 0     1993-08-12T00:00:00 Bilat Full                
49 49 01-CA-29145-001 0 0     1993-08-12T00:00:00 Bilat Full                
50 50 01-CA-29179-001 0 0 1993-03-17T00:00:00 1993-03-31T00:00:00                      
51 51 01-CA-29179-001 1 0 1993-05-12T00:00:00 1993-05-26T00:00:00 1993-05-28T00:00:00 Unil Part                
52 52 01-CA-29217-001 0 0     1993-04-15T00:00:00 Bilat Full                
53 53 01-CA-29500-001 0 0     1993-08-05T00:00:00 Bilat Full                
54 54 01-CA-29550-001 0 0     1992-09-23T00:00:00 Bilat Full                
55 55 01-CA-29582-001 0 0     1993-08-12T00:00:00 Bilat Full                
56 56 01-CA-29602-001 0 0     1993-05-13T00:00:00 Bilat Full                
57 57 01-CA-29631-001 0 0     1993-03-16T00:00:00 Bilat Full                
58 58 01-CA-29690-001 0 0     1992-11-20T00:00:00 Bilat Full                
59 59 01-CA-29757-001 0 0     1993-03-16T00:00:00 Bilat Full                
60 60 01-CA-29869-001 0 0 1993-11-08T00:00:00 1993-11-15T00:00:00 1993-12-09T00:00:00 Unil Full                
61 61 01-CA-29875-001 0 0     1993-08-06T00:00:00 Bilat Full                
62 62 01-CA-29891-001 0 0     1993-08-12T00:00:00 Bilat Full                
63 63 01-CA-30009-001 0 0     1993-08-02T00:00:00 Bilat Full                
64 64 01-CA-30013-001 0 0     1993-03-16T00:00:00 Bilat Full                
65 65 01-CA-30060-001 0 0     1993-06-23T00:00:00 Bilat Full                
66 66 01-CA-30110-001 0 0     1993-03-16T00:00:00 Bilat Full                
67 67 01-CA-30121-001 0 0     1993-08-02T00:00:00 Bilat Full                
68 68 01-CA-30139-001 0 0 1995-09-22T00:00:00 1995-09-29T00:00:00 1995-10-05T00:00:00 Unil Full                
69 69 01-CA-30176-001 0 0     1993-04-26T00:00:00 Bilat Full                
70 70 01-CA-30218-001 0 0 1995-09-22T00:00:00 1995-09-29T00:00:00 1995-10-05T00:00:00 Unil Full                
71 71 01-CA-30228-001 0 0 1995-09-22T00:00:00 1995-09-29T00:00:00 1995-10-05T00:00:00 Unil Full                
72 72 01-CA-30267-001 0 0 1995-09-22T00:00:00 1995-09-29T00:00:00 1995-10-05T00:00:00 Unil Full                
73 73 01-CA-30283-001 0 0 1995-06-23T00:00:00 1995-06-30T00:00:00 1995-07-31T00:00:00 Unil Full                
74 74 01-CA-30292-001 0 0     1996-11-26T00:00:00 Bilat Full                
75 75 01-CA-30374-001 0 0     1993-09-28T00:00:00 Bilat Full                
76 76 01-CA-30379-001 0 0     1994-06-28T00:00:00 Bilat Full                
77 77 01-CA-30402-001 0 0     1994-06-08T00:00:00 Bilat Full                
78 78 01-CA-30407-001 0 0     1993-07-20T00:00:00 Bilat Full                
79 79 01-CA-30438-001 0 0     1994-01-25T00:00:00 Bilat Full                
80 80 01-CA-30509-001 0 0     1993-08-02T00:00:00 Bilat Full                
81 81 01-CA-30578-001 0 0     1996-12-23T00:00:00 Bilat Full                
82 82 01-CA-30630-001 0 0     1993-09-28T00:00:00 Bilat Full                
83 83 01-CA-30631-001 0 0 1994-10-18T00:00:00 1994-10-25T00:00:00 1994-10-28T00:00:00 Unil Full                
84 84 01-CA-30655-002 0 0 1995-09-22T00:00:00 1995-09-29T00:00:00 1995-10-05T00:00:00 Unil Full                
85 85 01-CA-30655-004 0 0 1995-09-22T00:00:00 1995-09-29T00:00:00 1995-10-05T00:00:00 Unil Full                
86 86 01-CA-30671-001 0 0     1996-05-15T00:00:00 Bilat Full                
87 87 01-CA-30693-001 0 0     1993-08-31T00:00:00 Bilat Full                
88 88 01-CA-30716-001 0 0     1994-01-25T00:00:00 Bilat Full                
89 89 01-CA-30726-001 0 0     1997-03-25T00:00:00 Bilat Full                
90 90 01-CA-30739-001 0 0 1995-09-22T00:00:00 1995-09-29T00:00:00 1995-10-05T00:00:00 Unil Full                
91 91 01-CA-30827-001 0 0 1994-10-18T00:00:00 1994-10-25T00:00:00 1994-10-28T00:00:00 Unil Full                
92 92 01-CA-30830-001 0 0     1995-04-25T00:00:00 Bilat Full                
93 93 01-CA-30941-001 0 0     1994-06-09T00:00:00 Unil Full                
94 94 01-CA-30989-001 0 0     1994-07-12T00:00:00 Bilat Full                
95 95 01-CA-30999-001 0 0     1994-08-30T00:00:00 Bilat Full                
96 96 01-CA-31028-001 0 0     1996-11-26T00:00:00 Bilat Full                
97 97 01-CA-31066-001 0 0 1995-09-22T00:00:00 1995-09-29T00:00:00 1995-10-05T00:00:00 Unil Full                
98 98 01-CA-31211-001 0 0     1997-03-25T00:00:00 Bilat Full                
99 99 01-CA-31218-001 0 0 1995-09-22T00:00:00 1995-09-29T00:00:00 1995-10-05T00:00:00 Unil Full                
100 100 01-CA-31242-001 0 0     1994-07-12T00:00:00 Bilat Full                

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "c_settlement" (
    "c_case_number" text,
    "action_sequence" integer,
    "recurrence" integer,
    "proposal_letter_sent_date" text,
    "proposed_approval__date" text,
    "inf_settle_approved" text,
    "inf_settle_participation" text,
    "inf_settle_scope" text,
    "inf_settle_revoked" text,
    "fs_settlement_sent_ops" text,
    "fs_submitted_to" integer,
    "formal_scope" text,
    "fs_board_determination" text,
    "fs_determination_date" text,
    "determination_rcvd_reg" text,
    "formal_participation" text
);