Controlpanel / Database
Database Explorer
Read-only SQL/JSON werkbank. Open een databron, kies een tabel, zoek in echte rijen en inspecteer data als ruwe JSON. Geen vrije SQL, geen writes, geen export.
6 bronnen66 tabellen/stores257.140 rijen/items22 domeincontainers
Zoeken
Tabelzoeker zoekt in de gekozen tabel; dossierzoeker zoekt klant/dossierlocaties over bekende dossierstores.
Rijen: boekhouding-sqlite.loonpost
Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.
Read-only query
SELECT * FROM "loonpost" LIMIT 50 OFFSET 50
| id | bv_code | periode | werknemer | werknemer_nr | brutoloon_cents | loonheffing_cents | netto_cents | bron | imported_at |
|---|---|---|---|---|---|---|---|---|---|
| 51 | HOLDING | 2024-11-M | Rogier Zwarthoff | 1 | 343118 | -131450 | 211668 | pdf:Loonstrook Rogier Zwarthoff 2024-11.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 52 | UZ | 2024-12-M | Rogier Zwarthoff | 2 | 2008117 | -992388 | 1142008 | pdf:Loonstrook Rogier Zwarthoff 2024-12.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 53 | UZ | 2025-01-M | Rogier Zwarthoff | 2 | 538950 | -235971 | 315646 | pdf:Loonstrook Rogier Zwarthoff 2025-01.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 54 | UZ | 2025-02-M | Rogier Zwarthoff | 2 | 538950 | -235971 | 315646 | pdf:Loonstrook Rogier Zwarthoff 2025-02.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 55 | UZ | 2025-03-M | Rogier Zwarthoff | 2 | 538950 | -235971 | 315646 | pdf:Loonstrook Rogier Zwarthoff 2025-03.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 56 | UZ | 2025-04-M | Rogier Zwarthoff | 2 | 538950 | -235971 | 315646 | pdf:Loonstrook Rogier Zwarthoff 2025-04.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 57 | UZ | 2025-05-M | Rogier Zwarthoff | 2 | 538950 | -235971 | 315646 | pdf:Loonstrook Rogier Zwarthoff 2025-05.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 58 | UZ | 2025-06-M | Rogier Zwarthoff | 2 | 538950 | -235971 | 315646 | pdf:Loonstrook Rogier Zwarthoff 2025-06.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 59 | UZ | 2025-07-M | Rogier Zwarthoff | 2 | 538950 | -235971 | 315646 | pdf:Loonstrook Rogier Zwarthoff 2025-07.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 60 | UZ | 2025-08-M | Rogier Zwarthoff | 2 | 538950 | -235971 | 315646 | pdf:Loonstrook Rogier Zwarthoff 2025-08.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 61 | UZ | 2025-09-M | Rogier Zwarthoff | 2 | 538950 | -235971 | 315646 | pdf:Loonstrook Rogier Zwarthoff 2025-09.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 62 | UZ | 2025-10-M | Rogier Zwarthoff | 2 | 538950 | -235971 | 315646 | pdf:Loonstrook Rogier Zwarthoff 2025-10.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 63 | UZ | 2025-11-M | Rogier Zwarthoff | 2 | 538950 | -235971 | 315646 | pdf:Loonstrook Rogier Zwarthoff 2025-11.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 64 | UZ | 2026-01-M | Rogier Zwarthoff | 2 | 538950 | -231705 | 319962 | pdf:Loonstrook Rogier Zwarthoff 2026-01.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 65 | UZ | 2026-02-M | Rogier Zwarthoff | 2 | 538950 | -231705 | 319962 | pdf:Loonstrook Rogier Zwarthoff 2026-02.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 66 | UZ | 2026-04-M | Rogier Zwarthoff | 2 | 538950 | -231705 | 319962 | pdf:Loonstrook Rogier Zwarthoff 2026-04.pdf | 2026-06-11T19:08:49.642421+00:00 |
| 67 | UZ | 2026-05-M | Rogier Zwarthoff | 2 | 538950 | -231705 | 319962 | pdf:Loonstrook Rogier Zwarthoff 2026-05.pdf | 2026-06-11T19:08:49.642421+00:00 |
Raw JSON details
Rij 51
{
"id": 51,
"bv_code": "HOLDING",
"periode": "2024-11-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "1",
"brutoloon_cents": 343118,
"loonheffing_cents": -131450,
"netto_cents": 211668,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2024-11.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 52
{
"id": 52,
"bv_code": "UZ",
"periode": "2024-12-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 2008117,
"loonheffing_cents": -992388,
"netto_cents": 1142008,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2024-12.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 53
{
"id": 53,
"bv_code": "UZ",
"periode": "2025-01-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -235971,
"netto_cents": 315646,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2025-01.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 54
{
"id": 54,
"bv_code": "UZ",
"periode": "2025-02-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -235971,
"netto_cents": 315646,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2025-02.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 55
{
"id": 55,
"bv_code": "UZ",
"periode": "2025-03-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -235971,
"netto_cents": 315646,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2025-03.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 56
{
"id": 56,
"bv_code": "UZ",
"periode": "2025-04-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -235971,
"netto_cents": 315646,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2025-04.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 57
{
"id": 57,
"bv_code": "UZ",
"periode": "2025-05-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -235971,
"netto_cents": 315646,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2025-05.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 58
{
"id": 58,
"bv_code": "UZ",
"periode": "2025-06-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -235971,
"netto_cents": 315646,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2025-06.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 59
{
"id": 59,
"bv_code": "UZ",
"periode": "2025-07-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -235971,
"netto_cents": 315646,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2025-07.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 60
{
"id": 60,
"bv_code": "UZ",
"periode": "2025-08-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -235971,
"netto_cents": 315646,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2025-08.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 61
{
"id": 61,
"bv_code": "UZ",
"periode": "2025-09-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -235971,
"netto_cents": 315646,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2025-09.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 62
{
"id": 62,
"bv_code": "UZ",
"periode": "2025-10-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -235971,
"netto_cents": 315646,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2025-10.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 63
{
"id": 63,
"bv_code": "UZ",
"periode": "2025-11-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -235971,
"netto_cents": 315646,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2025-11.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 64
{
"id": 64,
"bv_code": "UZ",
"periode": "2026-01-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -231705,
"netto_cents": 319962,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2026-01.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 65
{
"id": 65,
"bv_code": "UZ",
"periode": "2026-02-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -231705,
"netto_cents": 319962,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2026-02.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 66
{
"id": 66,
"bv_code": "UZ",
"periode": "2026-04-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -231705,
"netto_cents": 319962,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2026-04.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Rij 67
{
"id": 67,
"bv_code": "UZ",
"periode": "2026-05-M",
"werknemer": "Rogier Zwarthoff",
"werknemer_nr": "2",
"brutoloon_cents": 538950,
"loonheffing_cents": -231705,
"netto_cents": 319962,
"bron": "pdf:Loonstrook Rogier Zwarthoff 2026-05.pdf",
"imported_at": "2026-06-11T19:08:49.642421+00:00"
}Andere domeindatabases
Gefilterde containerinventaris. Niet alle containers hebben al een veilige connector.
| Container | Image | Status |
|---|---|---|
| adviestool-web | adviestool-web:latest | Up 9 minutes |
| adviestool-whatsapp | adviestool-whatsapp:latest | Up About an hour |
| adviestool-ocr | adviestool-ocr:latest | Up About an hour (healthy) |
| adviestool-web-preview | adviestool-web-preview:latest | Up 3 days |
| adviestool-preview-ocr | 9e5e9933f3ab | Up 3 days (healthy) |
| adviestool-postgres-test | postgres:17-alpine | Up 3 days (healthy) |
| adviestool-postgres | postgres:17-alpine | Up 5 days (healthy) |
| boekhouding-uw-zekerheid-mssql-1 | mcr.microsoft.com/mssql/server:2022-latest | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-arq-worker-1 | boekhouding-uw-zekerheid-arq-worker | Up 6 days |
| boekhouding-uw-zekerheid-api-1 | boekhouding-uw-zekerheid-api | Up 6 days |
| boekhouding-uw-zekerheid-web-1 | boekhouding-uw-zekerheid-web | Up 6 days |
| boekhouding-uw-zekerheid-caddy-1 | caddy:2-alpine | Up 6 days |
| boekhouding-uw-zekerheid-otel-collector-1 | otel/opentelemetry-collector:0.136.0 | Up 6 days |
| boekhouding-uw-zekerheid-redis-1 | redis:7-alpine | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-postgres-1 | pgvector/pgvector:pg16 | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-minio-1 | minio/minio:RELEASE.2025-09-07T16-13-09Z | Up 6 days |
| adviseursite | adviseursite-adviseursite | Up 7 days (healthy) |
| hypotheek-gate | hypotheek-gate:latest | Up 7 days (healthy) |
| dash | dash-uw-zekerheid:latest | Up 7 days (healthy) |
| adviesbox-windows | dockurr/windows | Up 7 days |
| klantportaal | klantportaal:latest | Up 7 days (healthy) |
| uwpaleis-test | uwpaleis-website:latest | Up 7 days (healthy) |