home / cats / c_settlement

c_settlement

29,253 rows

✎ View and edit SQL

Suggested facets: action_sequence, inf_settle_participation, inf_settle_scope, fs_settlement_sent_ops, fs_determination_date, determination_rcvd_reg, proposal_letter_sent_date (date), proposed_approval__date (date), inf_settle_approved (date), inf_settle_revoked (date), fs_settlement_sent_ops (date), fs_determination_date (date), determination_rcvd_reg (date)

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
01-CA-19958-001 0 0 1983-02-18 1983-02-25 1983-03-21 Unil Full                
01-CA-21943-001 0 0     2001-05-08 Bilat Full                
01-CA-22040-002 1 0     2001-05-08 Bilat Full                
01-CA-22769-001 0 0     1986-10-29 Bilat Full                
01-CA-23307-001 1 0     2001-05-08 Bilat Full                
01-CA-23748-001 1 0     2001-05-08 Bilat Full                
01-CA-24161-001 0 0     2001-05-08 Bilat Full                
01-CA-24390-002 0 0     2001-05-08 Bilat Full                
01-CA-24528-001 0 0     2001-05-08 Bilat Full                
01-CA-24863-001 0 0     1988-08-16 Bilat Full                
01-CA-24883-001 0 0     1988-08-16 Bilat Full                
01-CA-24921-001 0 0     2001-05-08 Bilat Full                
01-CA-24967-001 0 0     2001-05-08 Bilat Full                
01-CA-25033-001 0 0     2001-05-08 Bilat Full                
01-CA-25237-001 0 0     2001-05-08 Bilat Full                
01-CA-25237-002 0 0     2001-05-08 Bilat Full                
01-CA-25341-001 0 0     2001-05-08 Bilat Full                
01-CA-25867-001 0 0     2001-05-08 Bilat Full                
01-CA-26098-001 0 0 1989-05-11 1989-05-18 1989-05-19 Unil Full                
01-CA-26232-001 0 0     1992-01-09 Bilat Full                
01-CA-26237-001 0 0     1992-01-09 Bilat Full                
01-CA-27197-001 0 0     1990-06-28 Bilat Full                
01-CA-27335-001 0 0     1993-03-29 Bilat Full                
01-CA-27356-001 0 0     1990-11-26 Bilat Full                
01-CA-27417-001 0 0     1990-11-26 Bilat Full                
01-CA-27421-001 0 0 1991-11-19 1991-11-26 1991-11-27 Unil Full                
01-CA-27491-001 0 0     1991-11-12 Bilat Full                
01-CA-27659-001 0 0     1991-11-12 Bilat Full                
01-CA-27732-001 0 0     1991-11-12 Bilat Full                
01-CA-27732-002 0 0     1991-11-12 Bilat Full                
01-CA-27766-001 0 0 1991-11-13 1991-11-20 1991-12-19 Unil Full                
01-CA-27937-001 0 0 1991-11-19 1991-11-26 1991-11-27 Unil Full                
01-CA-28064-001 0 0     1991-11-19 Bilat Full                
01-CA-28297-001 0 0     1995-04-07 Unil Full                
01-CA-28298-001 0 0     1995-04-07 Unil Full                
01-CA-28348-001 0 0     1993-02-19 Bilat Full                
01-CA-28375-001 0 0     1991-12-11 Bilat Full                
01-CA-28376-001 0 0     1992-08-28 Bilat Full                
01-CA-28466-001 0 0     1993-05-19 Bilat Full                
01-CA-28481-001 0 0     1992-08-28 Bilat Full                
01-CA-28493-001 0 0     1991-11-19 Bilat Full                
01-CA-28518-001 0 0 1993-06-08   1993-06-17 Unil Full                
01-CA-28558-001 0 0     1993-08-12 Bilat Full                
01-CA-28617-001 0 0     1992-08-28 Bilat Full                
01-CA-28767-001 0 0     1993-02-19 Bilat Full                
01-CA-28818-001 0 0     1993-02-19 Bilat Full                
01-CA-28892-001 0 0     1992-01-07 Bilat Full                
01-CA-29137-001 0 0     1993-08-12 Bilat Full                
01-CA-29145-001 0 0     1993-08-12 Bilat Full                
01-CA-29179-001 0 0 1993-03-17 1993-03-31                      
01-CA-29179-001 1 0 1993-05-12 1993-05-26 1993-05-28 Unil Part                
01-CA-29217-001 0 0     1993-04-15 Bilat Full                
01-CA-29500-001 0 0     1993-08-05 Bilat Full                
01-CA-29550-001 0 0     1992-09-23 Bilat Full                
01-CA-29582-001 0 0     1993-08-12 Bilat Full                
01-CA-29602-001 0 0     1993-05-13 Bilat Full                
01-CA-29631-001 0 0     1993-03-16 Bilat Full                
01-CA-29690-001 0 0     1992-11-20 Bilat Full                
01-CA-29757-001 0 0     1993-03-16 Bilat Full                
01-CA-29869-001 0 0 1993-11-08 1993-11-15 1993-12-09 Unil Full                
01-CA-29875-001 0 0     1993-08-06 Bilat Full                
01-CA-29891-001 0 0     1993-08-12 Bilat Full                
01-CA-30009-001 0 0     1993-08-02 Bilat Full                
01-CA-30013-001 0 0     1993-03-16 Bilat Full                
01-CA-30060-001 0 0     1993-06-23 Bilat Full                
01-CA-30110-001 0 0     1993-03-16 Bilat Full                
01-CA-30121-001 0 0     1993-08-02 Bilat Full                
01-CA-30139-001 0 0 1995-09-22 1995-09-29 1995-10-05 Unil Full                
01-CA-30176-001 0 0     1993-04-26 Bilat Full                
01-CA-30218-001 0 0 1995-09-22 1995-09-29 1995-10-05 Unil Full                
01-CA-30228-001 0 0 1995-09-22 1995-09-29 1995-10-05 Unil Full                
01-CA-30267-001 0 0 1995-09-22 1995-09-29 1995-10-05 Unil Full                
01-CA-30283-001 0 0 1995-06-23 1995-06-30 1995-07-31 Unil Full                
01-CA-30292-001 0 0     1996-11-26 Bilat Full                
01-CA-30374-001 0 0     1993-09-28 Bilat Full                
01-CA-30379-001 0 0     1994-06-28 Bilat Full                
01-CA-30402-001 0 0     1994-06-08 Bilat Full                
01-CA-30407-001 0 0     1993-07-20 Bilat Full                
01-CA-30438-001 0 0     1994-01-25 Bilat Full                
01-CA-30509-001 0 0     1993-08-02 Bilat Full                
01-CA-30578-001 0 0     1996-12-23 Bilat Full                
01-CA-30630-001 0 0     1993-09-28 Bilat Full                
01-CA-30631-001 0 0 1994-10-18 1994-10-25 1994-10-28 Unil Full                
01-CA-30655-002 0 0 1995-09-22 1995-09-29 1995-10-05 Unil Full                
01-CA-30655-004 0 0 1995-09-22 1995-09-29 1995-10-05 Unil Full                
01-CA-30671-001 0 0     1996-05-15 Bilat Full                
01-CA-30693-001 0 0     1993-08-31 Bilat Full                
01-CA-30716-001 0 0     1994-01-25 Bilat Full                
01-CA-30726-001 0 0     1997-03-25 Bilat Full                
01-CA-30739-001 0 0 1995-09-22 1995-09-29 1995-10-05 Unil Full                
01-CA-30827-001 0 0 1994-10-18 1994-10-25 1994-10-28 Unil Full                
01-CA-30830-001 0 0     1995-04-25 Bilat Full                
01-CA-30941-001 0 0     1994-06-09 Unil Full                
01-CA-30989-001 0 0     1994-07-12 Bilat Full                
01-CA-30999-001 0 0     1994-08-30 Bilat Full                
01-CA-31028-001 0 0     1996-11-26 Bilat Full                
01-CA-31066-001 0 0 1995-09-22 1995-09-29 1995-10-05 Unil Full                
01-CA-31211-001 0 0     1997-03-25 Bilat Full                
01-CA-31218-001 0 0 1995-09-22 1995-09-29 1995-10-05 Unil Full                
01-CA-31242-001 0 0     1994-07-12 Bilat Full                

Next page

Download this data

CSV · JSON

Table schema
CREATE TABLE c_settlement(c_case_number VARCHAR, action_sequence BIGINT, recurrence BIGINT, proposal_letter_sent_date DATE, proposed_approval__date DATE, inf_settle_approved DATE, inf_settle_participation VARCHAR, inf_settle_scope VARCHAR, inf_settle_revoked DATE, fs_settlement_sent_ops DATE, fs_submitted_to BIGINT, formal_scope VARCHAR, fs_board_determination VARCHAR, fs_determination_date DATE, determination_rcvd_reg DATE, formal_participation VARCHAR);

Queries took 1.2ms

A project of Forest Gregg. Read about project updates on Notes on Labor Data.