Ashgrove Chambers · Legal services
Look at a Lagos law firm's workload and cash: open matters by practice area, how often hearings are adjourned, and overdue invoices.
Ashgrove Chambers is a Lagos law firm working for companies and individuals across property, corporate, employment, family, intellectual property and commercial litigation matters.
The managing partner feels the lawyers are stretched, that too many hearings are adjourned, and that clients are slow to pay, but has no figures to prove it.
Build the evidence for the partners' meeting: workload by practice area and lawyer, how often hearings go ahead, and which clients owe the firm money.
Ashgrove Chambers (legal). A Lagos law firm's clients, matters, court hearings and invoices from 2024 to August 2026.
4 files · 1,009 rows in total · 52 kB. Download everything as a ZIP.
50 rows · 4 columns · 2 kB
Ashgrove Chambers' clients.
| Column | Type | Description | Values | Missing |
|---|---|---|---|---|
| client_id | Number | Unique client number. | 1 to 50 | None |
| client_name | Text | Client's name. | 46 distinct | None |
| client_type | Text | Company or Individual. | 2 distinct | None |
| onboarded_date | Date | Date they became a client. | 2022-02-24 to 2025-05-09 | None |
399 rows · 5 columns · 21 kB
Court hearings for each matter.
| Column | Type | Description | Values | Missing |
|---|---|---|---|---|
| hearing_id | Number | Unique hearing number. | 1 to 399 | None |
| matter_id | Number | Links to matters.matter_id. | 2,001 to 2,150 | None |
| hearing_date | Date | Date of the hearing. | 2024-05-15 to 2026-11-17 | None |
| court | Text | Court where it took place. | 5 distinct | None |
| outcome | Text | Heard, Adjourned, Judgment delivered, Struck out, or Scheduled if it hasn't happened yet. | 5 distinct | None |
410 rows · 6 columns · 18 kB
Invoices issued to clients.
| Column | Type | Description | Values | Missing |
|---|---|---|---|---|
| invoice_id | Number | Unique invoice number. | 7,001 to 7,410 | None |
| matter_id | Number | Links to matters.matter_id. | 2,001 to 2,150 | None |
| issued_date | Date | Date the invoice was issued. | 2024-01-30 to 2026-08-28 | None |
| amount_ngn | Number | Invoice amount in naira. | 300,000 to 6,000,000 | None |
| status | Text | Paid, Outstanding or Overdue. | 3 distinct | None |
| paid_date | Date | Date it was paid. Blank if unpaid. | 2024-04-08 to 2026-08-27 | 83 |
150 rows · 8 columns · 12 kB
Legal matters (cases and pieces of work) the firm has handled.
| Column | Type | Description | Values | Missing |
|---|---|---|---|---|
| matter_id | Number | Unique matter number. | 2,001 to 2,150 | None |
| client_id | Number | Links to clients.client_id. | 1 to 50 | None |
| matter_title | Text | Short description, such as Tenancy recovery. | 20 distinct | None |
| practice_area | Text | Property, Corporate, Employment, Family, Intellectual property or Commercial litigation. | 6 distinct | None |
| responsible_lawyer | Text | Lawyer in charge of the matter. | 8 distinct | None |
| opened_date | Date | Date the matter was opened. | 2024-01-21 to 2026-08-05 | None |
| closed_date | Date | Date it was closed. Blank if still open or on hold. | 2024-03-02 to 2026-08-31 | 47 |
| status | Text | Open, Closed or On hold. | 3 distinct | None |
Starter code to get you going. The Python runs as it is in Google Colab: it loads the data straight from this site. For SQL, import each CSV as a table with the same name as the file.
SQLAdjournment rate by court
SELECT court,
COUNT(*) AS hearings,
SUM(outcome = 'Adjourned') AS adjourned,
ROUND(100.0 * SUM(outcome = 'Adjourned') / COUNT(*), 1) AS adjourned_pct
FROM hearings
WHERE outcome <> 'Scheduled'
GROUP BY court
ORDER BY adjourned_pct DESC;Power BIIn Power BI
Put your work on GitHub with a short README, add it to your portfolio, and share what you found. The Git & GitHub and Student Portfolio courses show you how.