Car contracts, September 2026
1–13 of 13 · by contract date
13 shown
More columns
| Lead | Canton | Broker | Status | Contract |
|---|---|---|---|---|
| 3201 | VD | Alpenblick Broker GmbH | Held | 02.09.2026 |
| 3346 | FR | Alpenblick Broker GmbH | Held | 03.09.2026 |
| 3392 | LU | Rheinfall Assekuranz | Held | 06.09.2026 |
| 3333 | ZH | Uetliberg Broker | Held | 10.09.2026 |
| 3990 | ZH | Alpenblick Broker GmbH | Held | 17.09.2026 |
| 3881 | AG | Uetliberg Broker | Held | 19.09.2026 |
| 3757 | FR | Uetliberg Broker | Held | 21.09.2026 |
| 4029 | FR | Rheinfall Assekuranz | Held | 23.09.2026 |
| 4306 | FR | Aare Vorsorge AG | Held | 23.09.2026 |
| 3802 | TI | Rheinfall Assekuranz | Held | 26.09.2026 |
| 3852 | AG | Alpenblick Broker GmbH | Held | 26.09.2026 |
| 3924 | BE | Rheinfall Assekuranz | Held | 28.09.2026 |
| 4070 | ZH | Alpenblick Broker GmbH | Held | 29.09.2026 |
How it's calculated
These rows
select lead_id, created_at, channel, canton, product, broker, appointment_at, appointment_status, contract_signed_at, invoiced_at, invoice_amount_chf
from leads
where contract_signed_at >= timestamp '2026-09-01 00:00:00' at time zone 'Europe/Zurich'
and contract_signed_at < timestamp '2026-10-01 00:00:00' at time zone 'Europe/Zurich'
and product = 'Car'
order by contract_signed_at, lead_id
limit 50 offset 0The row count
select count(*) as total
from leads
where contract_signed_at >= timestamp '2026-09-01 00:00:00' at time zone 'Europe/Zurich'
and contract_signed_at < timestamp '2026-10-01 00:00:00' at time zone 'Europe/Zurich'
and product = 'Car'The app runs these queries with parameters; here the values are written in, so they can be read or pasted into psql.