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.ib_aangifte
Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.
Read-only query
SELECT * FROM "ib_aangifte" LIMIT 50 OFFSET 0
| jaar | verzamelinkomen_cents | box1_cents | box2_cents | box3_cents | saldo_cents | loon_json | dividend_cents | dividendbelasting_cents | eigen_woning_cents | status | original_filename | storage_path | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2023 | 3843700 | 3843700 | 0 | 0 | -281600 | [{"werkgever": "R.D. Zwarthoff Holding B.V.", "loon_cents": 4500000}] | 0 | 0 | -498700 | definitief ingediend 24-06-2024 | Aangifte_inkomstenbelasting_2023_24-06-2024_11.28u.pdf | /data/boekhouding-docs/PRIVE/6e/6e1d74a1c5d397a9041caabd0658afd584caae015fbe813aa1f40e0ab6235eae | 2026-06-12T03:18:41.756858+00:00 |
| 2024 | 12965800 | 6265800 | 6700000 | 0 | 484100 | [{"werkgever": "Uw Zekerheid B.V.", "loon_cents": 2100000}, {"werkgever": "R.D. Zwarthoff Holding B.V.", "loon_cents": 4477000}] | 6700000 | 1005000 | -311200 | ingediend 16-07-2025 | Aangifte_inkomstenbelasting_2024_16-07-2025_16.19u (1).pdf | /data/boekhouding-docs/PRIVE/2e/2ead67b8c1f2b25f0841c930090d8b97888693cec4fee9d013d736baae233c63 | 2026-06-12T03:18:41.756858+00:00 |
Raw JSON details
Rij 1
{
"jaar": 2023,
"verzamelinkomen_cents": 3843700,
"box1_cents": 3843700,
"box2_cents": 0,
"box3_cents": 0,
"saldo_cents": -281600,
"loon_json": "[{\"werkgever\": \"R.D. Zwarthoff Holding B.V.\", \"loon_cents\": 4500000}]",
"dividend_cents": 0,
"dividendbelasting_cents": 0,
"eigen_woning_cents": -498700,
"status": "definitief ingediend 24-06-2024",
"original_filename": "Aangifte_inkomstenbelasting_2023_24-06-2024_11.28u.pdf",
"storage_path": "/data/boekhouding-docs/PRIVE/6e/6e1d74a1c5d397a9041caabd0658afd584caae015fbe813aa1f40e0ab6235eae",
"updated_at": "2026-06-12T03:18:41.756858+00:00"
}Rij 2
{
"jaar": 2024,
"verzamelinkomen_cents": 12965800,
"box1_cents": 6265800,
"box2_cents": 6700000,
"box3_cents": 0,
"saldo_cents": 484100,
"loon_json": "[{\"werkgever\": \"Uw Zekerheid B.V.\", \"loon_cents\": 2100000}, {\"werkgever\": \"R.D. Zwarthoff Holding B.V.\", \"loon_cents\": 4477000}]",
"dividend_cents": 6700000,
"dividendbelasting_cents": 1005000,
"eigen_woning_cents": -311200,
"status": "ingediend 16-07-2025",
"original_filename": "Aangifte_inkomstenbelasting_2024_16-07-2025_16.19u (1).pdf",
"storage_path": "/data/boekhouding-docs/PRIVE/2e/2ead67b8c1f2b25f0841c930090d8b97888693cec4fee9d013d736baae233c63",
"updated_at": "2026-06-12T03:18:41.756858+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) |