# database_metadata

key: created_from
value:
reports.csv, operational_metrics.csv, regional_metrics.csv, resolution_metrics.csv, financial_metrics.csv, staffing_metrics.csv, app_type_dictionary.csv, app_type_metrics.csv, member_counts_by_file.csv


# operational_metrics

report_id: 1998_1999
metric_id: total_unresolved
unit: applications
notes:
"The Tribunal has been quite successful in resolving applications and not creating a backlog during our first year of operations."


# member_counts_by_file

file: 1999_00_text.txt
names_found:
Andreas Von Cramon; Beverly Moore; Braham T. Kapal; Brian Rodenhurst; Catherine Skinner; Charles Gascoyne; Chisanga Puta-Chekwe; Chris Braney; Connie Holmes; Cynthia Summers; David Braund; David G. Timms; David Gregory; David Horrox; David Wright; Diane Tinker; Donald Macvicar; Donna McGavin; Edward Lee; Gilles Guénette; Ian MacInnis; J. Steven McCutcheon; Janet Davies; Jeffrey Rogers; Jim Brown; John Goodchild; Julius Suraski; Karol Wronecki; Knox Henry; Laurie Koch; Linda Joss; Lola Fabowalé; Mary Lee; Murray Wm. Graham; Nancy Fahlgren; Nancy Savage; Patricia Greenside; Paul Lummiss; Richard Feldman; Richard Ittleman; Romuald Kwolek; Shawn Hayman; Shehnaz Alidina; Sherry Senis; Sonia Light; Stanley Chapman; Stephan M. Kozak; Steven J. Faughnan; Steven McCutcheon; Tom McDermott


file: 2002_03_text.txt
names_found:
Alan Mervin; Andreas Von Cramon; Ashis Basu; Beverly Moore; Brian Nicholson; Brian Rodenhurst; Catherine Keleher; Catherine Skinner; Charles Gascoyne; Chisanga Puta-Chekwe; Christina Budweth Mingay; Christopher Trueman; Connie Holmes; Cynthia Summers; David Gregory; David Hutcheon; Dennis McKaig; Diane Tinker; Donald Macvicar; Donna McGavin; Edward Lee; Elizabeth Beckett; Elizabeth Brown; George Taylor; Gerald Taylor; Gilles Guénette; Guy Savoie; Harry Fine; Ian MacInnis; Janice MacGuigan; Jeffrey Rogers; Jim Brown; John Goodchild; Julius Suraski; Knox Henry; Linda Joss; Mary Lee; Michael van Dusen; Murray Wm. Graham; Nancy Fahlgren; Nicholas Pustina; Paul Lummiss; Peter Spadzinski; Pina Sauro; Richard Feldman; Robert Côté; Robert Gleeson; Sherry Senis; Sonia Light; Stanley Chapman; Steven McCutcheon; Susan Ellacott


file: 2008_09_names.txt
names_found:
Alan Mervin; Andi Shi; Bittu George; Brad Wallace; Brenna Homeniuk; Brian Cormier; Brian McKee; Caroline King; Cathryn Forbes; Christina Budweth Mingay; Christopher Trueman; Claudette Leslie; Dan Helsberg; Debra Mattina; Egya Sangmuah; Eli Fellman; Elizabeth Beckett; Elizabeth Brown; Elizabeth Usprich; Elke Homsi; Enza Buffa; Freda Shamatutu; Gerald Naud; Gerald Taylor; Greg Joy; Guy Savoie; Ieva Martin; Ina Maher; Jana Rozehnal; Jean-Paul Pilon; Jeanie Theoharis; Jessica Kowalski; Jim McMaster; John Nolan; Jonelle Van Delft; Joseph A. Berkovits; Judy Ireland; Karen Wallace; Karol Wronecki; Kenneth Jepson; Kim Bugby; Lilian Ma; Lloyd Phillipps; Louis Bourgon; Lynn Neil; Michael Soo; Mike Welsh; Murray Wm. Graham; Nancy Fahlgren; Nina Stanwick; Olga Luftig; Patrice C. Noé; Pearl Gréwal; Rosa Votta; Ruth Carey; Régent Gagnon; Sean Henry; Suparna Ghosh; Vincent Ching; Wayne MacKinnon; William Burke; William Weissglas; Yasmeen Siddiqui


file: 2009_10_names.txt
names_found:
Alan Mervin; Anita Louse Horton; Bittu George; Brad Wallace; Brenna Homeniuk; Brian Cormier; Brian McKee; Caroline King; Christina Budweth Mingay; Christopher Trueman; Claudette Leslie; Dan Helsberg; Debra Mattina; Egya Sangmuah; Eli Fellman; Elizabeth Beckett; Elizabeth Usprich; Elke Homsi; Freda Shamatutu; Gerald Naud; Gerald Taylor; Greg Joy; Guy Savoie; Ieva Martin; Ina Maher; Jana Rozehnal; Jean-Paul Pilon; Jeanie Theoharis; Jonelle Van Delft; Joseph A. Berkovits; Judy Ireland; Karen Wallace; Karol Wronecki; Kenneth Jepson; Kim Bugby; Lilian Ma; Lisa M. Stevens; Lloyd Phillipps; Louis Bourgon; Lynn Neil; Michael Soo; Mike Welsh; Murray Wm. Graham; Nancy Fahlgren; Nina Stanwick; Petar Guzina; Rosa Votta; Ruth Carey; Régent Gagnon; Sean Henry; Shirley Jean Collins; Suparna Ghosh; Sylvia Nancy Watson; Vincent Ching; Wayne MacKinnon; William Burke


file: 1998_99_names.txt
names_found:
Andreas Von Cramon; Beverly Moore; Brian Rodenhurst; Catherine Skinner; Charles Gascoyne; Chisanga Puta-Chekwe; Chris Braney; Connie Holmes; Cynthia Summers; David Braund; David G. Timms; David Gregory; David Horrox; David Wright; Diane Tinker; Donald Macvicar; Donna McGavin; Edward Lee; Gilles Guénette; Ian MacInnis; J. Steven McCutcheon; Janet Davies; Jeffrey Rogers; John Goodchild; Laurie Koch; Linda Joss; Lola Fabowalé; Mary Lee; Murray Wm. Graham; Nancy Fahlgren; Nancy Savage; Richard Feldman; Richard Ittleman; Romuald Kwolek; Scott N.F. Mcneil; Shawn Hayman; Sherry Senis; Stanley Chapman; Steven J. Faughnan; Steven McCutcheon; Tom McDermott


file: 2006_07_text.txt
names_found:
Alan Mervin; Andi Shi; Babatunde Olokun; Beatrice Metzler; Brad Wallace; Brenna Homeniuk; Brian Cormier; Brian McKee; Caroline King; Cathryn Forbes; Charles Gascoyne; Christina Budweth Mingay; Christopher Trueman; Claudette Leslie; Dan Helsberg; Debra Mattina; Egya Sangmuah; Eli Fellman; Elizabeth Beckett; Elizabeth Brown; Elizabeth Leighton; Elizabeth Usprich; Elke Homsi; Enza Buffa; Freda Shamatutu; Gerald Naud; Gerald Taylor; Greg Joy; Guy Savoie; Ieva Martin; Ina Maher; Jana Rozehnal; Jean-Paul Pilon; Jeanie Theoharis; Jessica Kowalski; Jim McMaster; John Nolan; Jonelle Van Delft; Joseph A. Berkovits; Judy Ireland; Karen Wallace; Karol Wronecki; Kim Bugby; Lilian Ma; Linda Joss; Lloyd Phillipps; Louis Bourgon; Lynn Neil; Michael Soo; Michelle M. Lomazzo; Mike Welsh; Murray Wm. Graham; Najib Tahiri; Nancy Fahlgren; Nina Stanwick; Olga Luftig; Patrice C. Noé; Pearl Gréwal; Rosa Votta; Ruth Carey; Régent Gagnon; Sean Henry; Susan Ellacott; Suzy Franklyn; Valarie Steele; Vincent Ching; Wayne MacKinnon; William Burke; William Weissglas; Yasmeen Siddiqui


file: 2005_06_text.txt
names_found:
Alan Mervin; Andi Shi; Angela McReelis; Babatunde Olokun; Beatrice Metzler; Beverly Moore; Brad Wallace; Brian McKee; Caroline King; Charles Gascoyne; Christina Budweth Mingay; Christopher Trueman; Dan Helsberg; David Hutcheon; Debra Mattina; Dennis McKaig; Donna McGavin; Eli Fellman; Elizabeth Beckett; Elizabeth Brown; Elizabeth Leighton; Elizabeth Usprich; Elke Homsi; Enza Buffa; Freda Shamatutu; Gerald Naud; Gerald Taylor; Greg Joy; Guy Savoie; Ieva Martin; Janice MacGuigan; Jim McMaster; Jonelle Van Delft; Joseph A. Berkovits; Julius Suraski; Kim Bugby; Lilian Ma; Linda Joss; Lynn Neil; Mike Welsh; Murray Wm. Graham; Najib Tahiri; Nancy Fahlgren; Patrice C. Noé; Paul De Buono; Pina Sauro; Richard Corcelli; Rosa Votta; Régent Gagnon; Sean Henry; Sherry Senis; Sonia Light; Susan Ellacott; Suzy Franklyn; Valarie Steele; Wayne MacKinnon; William Burke


file: 2001_02_text.txt
names_found:
Alan Mervin; Andreas Von Cramon; Ashis Basu; Beverly Moore; Brian Rodenhurst; Catherine Keleher; Catherine Skinner; Charles Gascoyne; Chisanga Puta-Chekwe; Connie Holmes; Cynthia Summers; David Gregory; Dennis McKaig; Diane Tinker; Donald Macvicar; Donna McGavin; Edward Lee; Elizabeth Beckett; Elizabeth Brown; George Taylor; Gilles Guénette; Guy Savoie; Harry Fine; Ian MacInnis; Jeffrey Rogers; Jim Brown; John Goodchild; Julius Suraski; Knox Henry; Linda Joss; Mary Lee; Michael van Dusen; Murray Wm. Graham; Nancy Fahlgren; Nancy Savage; Nicholas Pustina; Paul Lummiss; Peter Spadzinski; Richard Feldman; Robert Côté; Romuald Kwolek; Sherry Senis; Sonia Light; Stanley Chapman; Steven McCutcheon; Susan Ellacott


file: 2004_05_text.txt
names_found:
Alan Mervin; Angela McReelis; Babatunde Olokun; Beatrice Metzler; Beverly Moore; Brian McKee; Caroline King; Catherine Keleher; Catherine Skinner; Charles Gascoyne; Chisanga Puta-Chekwe; Christina Budweth Mingay; Christopher Trueman; Connie Holmes; Cynthia Summers; David Gregory; David Hutcheon; Dennis McKaig; Donald Macvicar; Donna McGavin; Edward Lee; Eli Fellman; Elizabeth Beckett; Elizabeth Brown; Elizabeth Leighton; Enza Buffa; Freda Shamatutu; George Taylor; Gerald Naud; Gerald Taylor; Gilles Guénette; Guy Savoie; Harry Fine; Ian MacInnis; Ieva Martin; Janice MacGuigan; Jeffrey Rogers; John Goodchild; Jonelle Van Delft; Julius Suraski; Kim Bugby; Linda Joss; Lynn Neil; Mary Lee; Michael van Dusen; Murray Wm. Graham; Najib Tahiri; Nancy Fahlgren; Paul De Buono; Peter Spadzinski; Pina Sauro; Richard Cantin; Richard Corcelli; Richard Feldman; Robert Côté; Robert Gleeson; Rosa Votta; Régent Gagnon; Sean Henry; Sherry Senis; Sonia Light; Stanley Chapman; Steven McCutcheon; Susan Ellacott; Valarie Steele; Wayne MacKinnon


file: 2000_01_text.txt
names_found:
Andreas Von Cramon; Ashis Basu; Beverley J. Reade; Beverly Moore; Brian Rodenhurst; Catherine Keleher; Catherine Skinner; Charles Gascoyne; Chisanga Puta-Chekwe; Chris Braney; Connie Holmes; Cynthia Summers; David Braund; David G. Timms; David Gregory; David Horrox; David Wright; Diane Tinker; Donald Macvicar; Donna McGavin; Edward Lee; Elizabeth Beckett; George Taylor; Gilles Guénette; Ian MacInnis; Jeffrey Rogers; Jim Brown; John Goodchild; Julius Suraski; Knox Henry; Laurie Koch; Linda Joss; Lola Fabowalé; Mary Lee; Michael van Dusen; Murray Wm. Graham; Nancy Fahlgren; Nancy Savage; Paul Lummiss; Peter Spadzinski; Richard Feldman; Richard Ittleman; Romuald Kwolek; Shawn Hayman; Shehnaz Alidina; Sherry Senis; Sonia Light; Stanley Chapman; Steven J. Faughnan; Steven McCutcheon; Susan Ellacott; Tom McDermott


file: 2007_08_names.txt
names_found:
Alan Mervin; Andi Shi; Babatunde Olokun; Beatrice Metzler; Bittu George; Brad Wallace; Brenna Homeniuk; Brian Cormier; Brian McKee; Caroline King; Cathryn Forbes; Charles Gascoyne; Christina Budweth Mingay; Christopher Trueman; Claudette Leslie; Dan Helsberg; Debra Mattina; Egya Sangmuah; Eli Fellman; Elizabeth Beckett; Elizabeth Brown; Elizabeth Usprich; Elke Homsi; Enza Buffa; Freda Shamatutu; Gerald Naud; Gerald Taylor; Greg Joy; Guy Savoie; Ieva Martin; Ina Maher; Jana Rozehnal; Jean-Paul Pilon; Jeanie Theoharis; Jessica Kowalski; Jim McMaster; John Nolan; Jonelle Van Delft; Joseph A. Berkovits; Judy Ireland; Karen Wallace; Karol Wronecki; Kenneth Jepson; Kim Bugby; Lilian Ma; Linda Joss; Lloyd Phillipps; Louis Bourgon; Lynn Neil; Michael Soo; Mike Welsh; Murray Wm. Graham; Nancy Fahlgren; Nina Stanwick; Olga Luftig; Patrice C. Noé; Pearl Gréwal; Rosa Votta; Ruth Carey; Régent Gagnon; Sean Henry; Suparna Ghosh; Susan Ellacott; Valarie Steele; Vincent Ching; Wayne MacKinnon; William Burke; William Weissglas; Yasmeen Siddiqui


file: 2003_04_text.txt
names_found:
Alan Mervin; Andreas Von Cramon; Ashis Basu; Beatrice Metzler; Beverly Moore; Brian McKee; Brian Nicholson; Brian Rodenhurst; Catherine Keleher; Catherine Skinner; Charles Gascoyne; Chisanga Puta-Chekwe; Christina Budweth Mingay; Christopher Trueman; Connie Holmes; Cynthia Summers; David Gregory; David Hutcheon; Dennis McKaig; Diane Tinker; Donald Macvicar; Donna McGavin; Edward Lee; Elizabeth Beckett; Elizabeth Brown; George Taylor; Gerald Taylor; Gilles Guénette; Guy Savoie; Harry Fine; Ian MacInnis; Janice MacGuigan; Jeffrey Rogers; Jim Brown; John Goodchild; Julius Suraski; Knox Henry; Linda Joss; Mary Lee; Michael van Dusen; Murray Wm. Graham; Nancy Fahlgren; Peter Spadzinski; Pina Sauro; Richard Cantin; Richard Feldman; Robert Côté; Robert Gleeson; Rosa Votta; Sherry Senis; Sonia Light; Stanley Chapman; Steven McCutcheon; Susan Ellacott


# days_to_first_hearing_count

report_id: 2022_2023_q1
region_id: region_central
office_code: CE
app_combo: A1
app_type: A1_L
source_file:
22 35 2022-04-01_2022-06-30 LTBAvgDayFirstHearing Q1 2022-2023 (Other applications) - CMORE&TOP.xlsx


report_id: 2022_2023_q2
region_id: region_central
office_code: CE
app_combo: L3
app_type: L3
source_file:
22 37 2022-07-01_2022-09-30 LTBAvgDayFirstHearing Q2 2022-2023 (Other applications) - CMORE&TOP.xlsx


# documentation

document_name: metric_dictionary
markdown_content:
| metric_id                    | display_name                                                                           | notes                               |
| ---------------------------- | -------------------------------------------------------------------------------------- | ----------------------------------- |
| total_received               | Applications received                                                                  |                                     |
| total_resolved               | Applications resolved                                                                  |                                     |
| total_unresolved             | Unresolved applications                                                                |                                     |
| cost_filing                  | Cost of filing                                                                         |                                     |
| cost_filing_tenant           | Cost of filing for the tenant                                                          |                                     |
| budget_expenditures          | Budget expenditures                                                                    |                                     |
| salaries_wages               | Salaries and wages                                                                     |                                     |
| other_expenses               | Other direct operating expenses                                                        |                                     |
| benefits                     | Benefits (paid to employees)                                                           |                                     |
| revenue                      | Revenue                                                                                |                                     |
| adjudicators_FT              | Full time adjudicators                                                                 |                                     |
| adjudicators_PT              | Part time adjudicators                                                                 |                                     |
| staff                        | Staff (assuming administrative and customer service)                                   |                                     |
| adjudicators_FTE             | Full time equivalent number of adjudicators                                            |                                     |
| staff_FTE                    | Full time equivalent number of staff                                                   |                                     |
| region_central               | Central region (see map)                                                               |                                     |
| region_eastern               | Eastern region (see map)                                                               |                                     |
| region_northern              | Northern region                                                                        |                                     |
| region_southern              | Southern region                                                                        |                                     |
| region_southwestern          | Southwestern region                                                                    |                                     |
| region_torontoNorth          | Toronto North region                                                                   |                                     |
| region_torontoEast           | Toronto East region                                                                    |                                     |
| region_torontoSouth          | Toronto South region                                                                   |                                     |
| landlord_received            | Applications received from landlords                                                   |                                     |
| tenant_received              | Applications received from tenants                                                     |                                     |
| resolved_abandoned           | Ordered by hearing abandoned                                                           |                                     |
| resolved_mediation           | Mediated; ordered by hearing mediated                                                  |                                     |
| resolved_hearing             | Ordered by hearing contested or uncontested; ordered by review                         |                                     |
| resolved_wo_hearing          | Ordered ex parte; ordered by section 206 agreement                                     |                                     |
| review_submitted             | Case submitted for review                                                              |                                     |
| review_denied                | Case review denied                                                                     |                                     |
| review_sentHearing           | Review sent to a hearing                                                               |                                     |
| resolved_withdrawn           | Case resolved through withdrawal                                                       |                                     |
| resolved_other               | Discontinued; order voided; ordered amended; amendment denied                          |                                     |
| mediation_attempted          | Attempted mediation                                                                    |                                     |
| mediation_rate               | Portion of cases resolved through mediation                                            |                                     |
| resolved_withdrawn_mediation | Number of cases withdrawn due to mediation                                             |                                     |
| additional_staff             | Additional staff members                                                               |                                     |
| canonical_names_found        | Number of canonical adjudicator names found in report                                  | Check Methodology_notes for process |
| part_time_names_found        | Number of canonical adjudicator names followed by “(Part Time member)” or some variant | As above                            |


