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 bronnen73 tabellen/stores299.864 rijen/items22 domeincontainers

Zoeken

Tabelzoeker zoekt in de gekozen tabel; dossierzoeker zoekt klant/dossierlocaties over bekende dossierstores.

Rijen: postgres-main.dossier_data

Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.

Read-only query

WITH _statement_timeout AS (SELECT set_config('statement_timeout', '1500ms', true)) SELECT t.* FROM public."dossier_data" t CROSS JOIN _statement_timeout ORDER BY updated_at DESC LIMIT 50 OFFSET 1250

50 matchende rijen · offset 1250 · limiet 50Vorige Volgende

dossier_id	key	value_json	updated_at
9d8d8028-f234-41d1-81c2-52c6e8ca0825	inventarisatie	{ "a1": { "naam": "Moet, Edwin (E.G.)", "adres": "Tammingecamp 15", "email": "[email]", "postcode": "7824 GN", "woonplaats": "Emmen", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Tammingecamp 15", "postcode": "7824 GN", "woonplaats": "Emmen" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2016-09-20" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "97445.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2021-02-05" }, ... [afgekapt: 1018 tekens]	1778230486535
1b7f327c-2dbe-4fc3-b1a6-bb6f9511d65f	base_import	{ "adres": "Het Erf 92", "klant": "Andel, Bastiaan Jan van (BJ), Andel, Emma de (EME)", "plaats": "Biddinghuizen", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8256 DH", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "251880.00", "status": "Lopend", "artikel": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)", "tekendatum": "25569", "productnaam": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)", "maatschappij": "AEGON", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "7583489", "passeeringangsdatum": "2021-01-18" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "251880.00", "status": "Lopend", "artikel": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)", "t ... [afgekapt: 10454 tekens]	1778230486535
e77401c7-2551-4a41-86b7-c966f05fe826	base_import	{ "adres": "Blauwe Slenk 12", "klant": "Kotter, Onitia Georgetina (OG)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8223 XN", "products": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Inkomensbeschermer", "tekendatum": "25569", "productnaam": "Inkomensbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-9152E36A-DA78-4DC1-990D-5DE75DF42428\|1024(1)", "passeeringangsdatum": "2020-09-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-04-22" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Inkomensbeschermer", "tekendatum": "25569", "productnaam": "Inkomensbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedr ... [afgekapt: 2187 tekens]	1778230486535
e77401c7-2551-4a41-86b7-c966f05fe826	inventarisatie	{ "a1": { "naam": "Kotter, Onitia Georgetina (OG)", "adres": "Blauwe Slenk 12", "email": "[email]", "postcode": "8223 XN", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Blauwe Slenk 12", "email": "[email]", "postcode": "8223 XN", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Inkomensbeschermer", "tekendatum": "25569", "productnaam": "Inkomensbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-9152E36A-DA78-4DC1-990D-5DE75DF42428\|1024(1)", "passeeringangsdatum": "2020-09-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-04-22" }, { "norm": "", "type": "Ink ... [afgekapt: 1579 tekens]	1778230486535
6b73936a-587c-491f-afa7-ef13cecc7e09	base_import	{ "adres": "J.T.P. Bijhouwerstraat 3", "klant": "Sharro (A.G.)", "plaats": "Almere", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "1333 JT", "products": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-08-04", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-08-04" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-08-04" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "215863", "Sharro (A.G.)", "J.T.P. Bijhouwerstraat 3", "1333 JT", "Almere", "[email]", "[telefoon]", "Eigen kantoor", "Dienst", "Advies nieuwe hypotheek starter/Aankoop", "Dienst ... [afgekapt: 305 tekens]	1778230486535
6b73936a-587c-491f-afa7-ef13cecc7e09	inventarisatie	{ "a1": { "naam": "Sharro (A.G.)", "adres": "J.T.P. Bijhouwerstraat 3", "email": "[email]", "postcode": "1333 JT", "woonplaats": "Almere", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "J.T.P. Bijhouwerstraat 3", "postcode": "1333 JT", "woonplaats": "Almere" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-08-04", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-08-04" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-08-04" } ], "crmdossier_id": "215863", "dossiernummer": "215863", "doss ... [afgekapt: 39 tekens]	1778230486535
21f82986-03d9-4fa3-94a5-61d4f72a95dd	base_import	{ "adres": "Punter 39 43", "klant": "Burer, Jeffrey (J), Verbeek, Claudia (C.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 EW", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "maatschappij": "TAF", "productsoort": "Overlijdensrisicoverzekering", "factuurbedrag": "", "offertenummer": "2757921", "passeeringangsdatum": "2020-03-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "191264.00", "status": "Lopend", "artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)", "tekendatum": "25569", "productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3159460-01", "passeeringangsdatum": "2020-07-03" }, { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", ... [afgekapt: 2316 tekens]	1778230486535
10b2c088-2130-49cd-ad7c-5a36b134e1b4	inventarisatie	{ "a1": { "naam": "Kalloe (S.)", "adres": "Kempenaar 01 16", "email": "[email]", "postcode": "8242 BA", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Kempenaar 01 16", "postcode": "8242 BA", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-12", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" } ], "crmdossier_id": "213447", "dossiernummer": "213447", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
21f82986-03d9-4fa3-94a5-61d4f72a95dd	inventarisatie	{ "a1": { "naam": "Burer, Jeffrey (J)", "adres": "Punter 39 43", "email": "[email]", "postcode": "8242 EW", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Verbeek, Claudia (C.)", "adres": "Punter 39 43", "postcode": "8242 EW", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "maatschappij": "TAF", "productsoort": "Overlijdensrisicoverzekering", "factuurbedrag": "", "offertenummer": "2757921", "passeeringangsdatum": "2020-03-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "191264.00", "status": "Lopend", "artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)", "tekendatum": "25569", "productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)", "maatschappij": "Hypotrust", "pr ... [afgekapt: 1610 tekens]	1778230486535
e6717098-2c09-41fb-852b-924dd7e33403	base_import	{ "adres": "Rijnland 26", "klant": "Algera, Melanie (M), Nolles, Dennis (D)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8245 CV", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "maatschappij": "TAF", "productsoort": "Overlijdensrisicoverzekering", "factuurbedrag": "", "offertenummer": "2729759", "passeeringangsdatum": "2019-11-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-09-07" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Maandlastbeschermer", "tekendatum": "25569", "productnaam": "Maandlastbeschermer", "maatschappij": "TAF", "products ... [afgekapt: 2024 tekens]	1778230486535
e6717098-2c09-41fb-852b-924dd7e33403	inventarisatie	{ "a1": { "naam": "Algera, Melanie (M)", "adres": "Rijnland 26", "email": "[email]", "postcode": "8245 CV", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Nolles, Dennis (D)", "adres": "Rijnland 26", "postcode": "8245 CV", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "maatschappij": "TAF", "productsoort": "Overlijdensrisicoverzekering", "factuurbedrag": "", "offertenummer": "2729759", "passeeringangsdatum": "2019-11-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-09-07" }, ... [afgekapt: 1498 tekens]	1778230486535
bd1e37d6-6948-40ca-a38b-98902294907a	base_import	{ "adres": "Wijngaard 76", "klant": "Encarnacion Montas, Junior (J.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8212 CE", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-12-04" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "152382.00", "status": "Lopend", "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "tekendatum": "25569", "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3148094-01", "passeeringangsdatum": "2020-01-06" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "200053", "Encarnacion Montas, Junior (J.)", "Wijngaard 76", "8212 CE", "Lelystad", "[email]", "[telefoon]", "Eigen kantoor", "Hypotheekadvies", ... [afgekapt: 405 tekens]	1778230486535
bd1e37d6-6948-40ca-a38b-98902294907a	inventarisatie	{ "a1": { "naam": "Encarnacion Montas, Junior (J.)", "adres": "Wijngaard 76", "email": "[email]", "postcode": "8212 CE", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Wijngaard 76", "postcode": "8212 CE", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-12-04" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "152382.00", "status": "Lopend", "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "tekendatum": "25569", "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3148094-01", "passeeringangsdatum": "2020-01-06" } ], "crmdossier_id": "200053", "dossi ... [afgekapt: 66 tekens]	1778230486535
ee0a6758-f99f-4562-ad38-c29bd212fade	base_import	{ "adres": "Horst 29 42", "klant": "Jonge, Hendrik Jan de (HJ)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8225 MV", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-05-28" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-05-28" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "149989.00", "status": "Lopend", "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "tekendatum": "25569", "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3193518-01", ... [afgekapt: 2210 tekens]	1778230486535
db46b3e9-6a02-46b3-89d2-955f281ef755	base_import	{ "adres": "Rozengaard 11 38", "klant": "Kolodziej, Bob (BJ), Sztura, Kamila (K)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8212 DB", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "207000.00", "status": "Lopend", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1873452", "passeeringangsdatum": "2020-12-15" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-22" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": ... [afgekapt: 2717 tekens]	1778230486535
db46b3e9-6a02-46b3-89d2-955f281ef755	inventarisatie	{ "a1": { "naam": "Kolodziej, Bob (BJ)", "adres": "Rozengaard 11 38", "email": "[email]", "postcode": "8212 DB", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Sztura, Kamila (K)", "adres": "Rozengaard 11 38", "postcode": "8212 DB", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "207000.00", "status": "Lopend", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1873452", "passeeringangsdatum": "2020-12-15" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": ... [afgekapt: 2106 tekens]	1778230486535
7daae1ec-0ec0-44e2-bc8b-faf549585905	base_import	{ "adres": "", "klant": "Marel, van der (M.), Mikkers, Geert (G)", "plaats": "LELYSTAD", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "413741.00", "status": "Lopend", "artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek", "tekendatum": "25569", "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "1822482", "passeeringangsdatum": "2020-05-01" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "42100.00", "status": "Lopend", "artikel": "Munt Annuïteiten Hypotheek", "tekendatum": "25569", "productnaam": "Munt Annuïteiten Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1822482", "passeeringangsdatum": "2022-06-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekenda ... [afgekapt: 1633 tekens]	1778230486535
7daae1ec-0ec0-44e2-bc8b-faf549585905	inventarisatie	{ "a1": { "naam": "Marel, van der (M.)", "email": "[email]", "woonplaats": "LELYSTAD", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Mikkers, Geert (G)", "woonplaats": "LELYSTAD" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "413741.00", "status": "Lopend", "artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek", "tekendatum": "25569", "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "1822482", "passeeringangsdatum": "2020-05-01" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "42100.00", "status": "Lopend", "artikel": "Munt Annuïteiten Hypotheek", "tekendatum": "25569", "productnaam": "Munt Annuïteiten Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1822482", "passeeringangsdatum" ... [afgekapt: 1044 tekens]	1778230486535
32c01726-52ab-4a79-8222-57b5b67ff66f	base_import	{ "adres": "Zilverschoonlaan 203", "klant": "Driouech, Anouar", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8245 KE", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-07-06" }, { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-07-06", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-07-06" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "214619", "Driouech, Anouar", "Zilverschoonlaan 203", "8245 KE", "Lelystad", "[email]", "[telefoon]", "Eigen kantoor", "Hypotheekadvies", "Dienst", "Advies nieuwe hypotheek start ... [afgekapt: 307 tekens]	1778230486535
32c01726-52ab-4a79-8222-57b5b67ff66f	inventarisatie	{ "a1": { "naam": "Driouech, Anouar", "adres": "Zilverschoonlaan 203", "email": "[email]", "postcode": "8245 KE", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Zilverschoonlaan 203", "postcode": "8245 KE", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-07-06" }, { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-07-06", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-07-06" } ], "crmdossier_id": "214619", "dossiernummer": "214619", "dossi ... [afgekapt: 38 tekens]	1778230486535
656d3981-42a3-479f-ac53-179afc987d57	base_import	{ "adres": "Botter 36 44", "klant": "Mahabier (P.), Sewberath Misser (A.G.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 KT", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "325000.00", "status": "Lopend", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "2095590", "passeeringangsdatum": "2022-10-07" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "251779", "Mahabier (P.), Sewberath Misser (A.G.)", "Botter 36 44", "8243 KT", "Lelystad", "[email]", "[email]", "[telefoon]", "2095590", "Lloyds Bank", "Hypotheek", "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "Annuitair" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "251779", " ... [afgekapt: 113 tekens]	1778230486535
656d3981-42a3-479f-ac53-179afc987d57	inventarisatie	{ "a1": { "naam": "Mahabier (P.)", "adres": "Botter 36 44", "email": "[email]", "postcode": "8243 KT", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Sewberath Misser (A.G.)", "adres": "Botter 36 44", "email": "[email]", "postcode": "8243 KT", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "325000.00", "status": "Lopend", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "2095590", "passeeringangsdatum": "2022-10-07" } ], "crmdossier_id": "251779", "dossiernummer": "251779", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
8c825e61-048c-4ca0-9b90-994b36c01bed	base_import	{ "adres": "Woudlaar 71", "klant": "Weverling, Leslie (LG), Weverling-Gerezgiher, H (HK)", "plaats": "Almere", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "1359 KM", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-07-05" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-04-24" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "253703.00", "status": "Lopend", "artikel": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)", "tekendatum": "25569", "productnaam": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annui ... [afgekapt: 2336 tekens]	1778230486535
8c825e61-048c-4ca0-9b90-994b36c01bed	inventarisatie	{ "a1": { "naam": "Weverling, Leslie (LG)", "adres": "Woudlaar 71", "email": "[email]", "postcode": "1359 KM", "woonplaats": "Almere", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Weverling-Gerezgiher, H (HK)", "adres": "Woudlaar 71", "postcode": "1359 KM", "woonplaats": "Almere" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-07-05" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-04-24" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "253703.00", "status": "Lopend", "artikel": "Argenta ... [afgekapt: 1721 tekens]	1778230486535
479d116b-3b72-40a3-bb24-0ae34626cc9e	base_import	{ "adres": "Schoener 45 9", "klant": "Marciniec , Piotr Antoni (PA)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 XG", "products": [ { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren", "tekendatum": "25569", "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren", "maatschappij": "Voogd & Voogd", "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand", "factuurbedrag": "", "offertenummer": "156722505385", "passeeringangsdatum": "2017-05-10" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "214380.00", "status": "Lopend", "artikel": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek", "tekendatum": "25569", "productnaam": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek", "maatschappij": "IQWOON", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3202655-01", ... [afgekapt: 3230 tekens]	1778230486535
479d116b-3b72-40a3-bb24-0ae34626cc9e	inventarisatie	{ "a1": { "naam": "Marciniec , Piotr Antoni (PA)", "adres": "Schoener 45 9", "email": "[email]", "postcode": "8243 XG", "woonplaats": "Lelystad", "telefoon_prive": "*********" }, "a2": { "adres": "Schoener 45 9", "email": "[email]", "postcode": "8243 XG", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren", "tekendatum": "25569", "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren", "maatschappij": "Voogd & Voogd", "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand", "factuurbedrag": "", "offertenummer": "156722505385", "passeeringangsdatum": "2017-05-10" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "214380.00", "status": "Lopend", "artikel": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek", "tek ... [afgekapt: 2466 tekens]	1778230486535
ec738fcd-419c-40e4-8c8e-de96b50d4b4b	base_import	{ "adres": "Karveel 59 82", "klant": "Eijk, Melvin van (M.J.), Grondhuis (A)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 WG", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "16066.00", "status": "Lopend", "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "tekendatum": "25569", "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "maatschappij": "Centraal Beheer", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3172756-01", "passeeringangsdatum": "2022-07-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "229790.00", "status": "Lopend", "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "tekendatum": "25569", "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "maatschappij": "Centraal Beheer", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3172756-01", "passeeringangsdatum": "2020-08-03" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "sta ... [afgekapt: 1723 tekens]	1778230486535
ec738fcd-419c-40e4-8c8e-de96b50d4b4b	inventarisatie	{ "a1": { "naam": "Eijk, Melvin van (M.J.)", "adres": "Karveel 59 82", "email": "[email]", "postcode": "8242 WG", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Grondhuis (A)", "adres": "Karveel 59 82", "postcode": "8242 WG", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "16066.00", "status": "Lopend", "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "tekendatum": "25569", "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "maatschappij": "Centraal Beheer", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3172756-01", "passeeringangsdatum": "2022-07-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "229790.00", "status": "Lopend", "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "tekendatum": "25569", "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "maatschappij": ... [afgekapt: 1182 tekens]	1778230486535
5ed6688b-c9da-4a4e-8248-bd1b1f6ffc9e	base_import	{ "adres": "Lagune 29", "klant": "Duztas, Cemil (C.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8224 CR", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-22" }, { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-22", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-22" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "213931", "Duztas, Cemil (C.)", "Lagune 29", "8224 CR", "Lelystad", "[email]", "[telefoon]", "Eigen kantoor", "Hypotheekadvies", "Dienst", "Advies nieuwe Hypotheek/Doorstromer", "Dienst BTW v ... [afgekapt: 277 tekens]	1778230486535
5ed6688b-c9da-4a4e-8248-bd1b1f6ffc9e	inventarisatie	{ "a1": { "naam": "Duztas, Cemil (C.)", "adres": "Lagune 29", "email": "[email]", "postcode": "8224 CR", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Lagune 29", "postcode": "8224 CR", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-22" }, { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-22", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-22" } ], "crmdossier_id": "213931", "dossiernummer": "213931", "dossierstatus": "Vervallen", ... [afgekapt: 10 tekens]	1778230486535
e8442c1c-3339-4419-8a50-fc3ae4180fcf	base_import	{ "adres": "Punter 41 41", "klant": "Verhoef (C.W.E.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 GC", "products": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-06-23", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-23" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-23" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "214031", "Verhoef (C.W.E.)", "Punter 41 41", "8242 GC", "Lelystad", "[email]", "[telefoon]", "Eigen kantoor", "Dienst", "Advies nieuwe hypotheek starter/Aankoop", "Dienst BTW vrij", ... [afgekapt: 291 tekens]	1778230486535
e8442c1c-3339-4419-8a50-fc3ae4180fcf	inventarisatie	{ "a1": { "naam": "Verhoef (C.W.E.)", "adres": "Punter 41 41", "email": "[email]", "postcode": "8242 GC", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Punter 41 41", "postcode": "8242 GC", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-06-23", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-23" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-23" } ], "crmdossier_id": "214031", "dossiernummer": "214031", "dossierstatus": "Verv ... [afgekapt: 22 tekens]	1778230486535
f235c68d-5854-465b-9477-058cd70d172c	inventarisatie	{ "a1": { "naam": "Jankowski (J.)", "adres": "Oostzeestraat 113", "email": "[email]", "postcode": "8226 BH", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Oostzeestraat 113", "postcode": "8226 BH", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Offerte/renteaanbod ontvangen", "artikel": "Cardif Aflos Verzekering", "tekendatum": "25569", "productnaam": "Cardif Aflos Verzekering", "maatschappij": "Cardif", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "HAV00150650", "passeeringangsdatum": "2019-11-01" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Scherp & Slim ORV annuïtair dalend", "tekendatum": "25569", "productnaam": "Scherp & Slim ORV annuïtair dalend", "maatschappij": "Hera Life", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "HL0061798", "passeeringangsdatum": "2019- ... [afgekapt: 1819 tekens]	1778230486535
7065b590-ff03-4134-b2f2-40610817b5b7	base_import	{ "adres": "Bergumermeerstraat 1", "klant": "Honing, Raymon (R), Kist, Mariska (MA)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8226 JK", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "334325.00", "status": "Lopend", "artikel": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair", "tekendatum": "25569", "productnaam": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair", "maatschappij": "Centraal Beheer", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3298974-01", "passeeringangsdatum": "2022-01-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-05-12" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "211912", ... [afgekapt: 664 tekens]	1778230486535
7065b590-ff03-4134-b2f2-40610817b5b7	inventarisatie	{ "a1": { "naam": "Honing, Raymon (R)", "adres": "Bergumermeerstraat 1", "email": "[email]", "postcode": "8226 JK", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Kist, Mariska (MA)", "adres": "Bergumermeerstraat 1", "postcode": "8226 JK", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "334325.00", "status": "Lopend", "artikel": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair", "tekendatum": "25569", "productnaam": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair", "maatschappij": "Centraal Beheer", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3298974-01", "passeeringangsdatum": "2022-01-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", ... [afgekapt: 253 tekens]	1778230486535
b075d90a-53d2-407a-80a9-89f1ae8fec96	base_import	{ "adres": "Zeepkruidstraat 131", "klant": "Raven, Jacqueline (J.M.C.), Reekers, Frans (F.M.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8245 LH", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "500000.00", "status": "Lopend", "artikel": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair", "tekendatum": "25569", "productnaam": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair", "maatschappij": "Woonnu", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3216244-01", "passeeringangsdatum": "2020-11-23" }, { "norm": "", "type": "Consumptief krediet", "inhoud": "0.00", "status": "Lopend", "artikel": "Doorlopend krediet", "tekendatum": "25569", "productnaam": "Doorlopend krediet", "maatschappij": "Nationale-Nederlanden Leven", "productsoort": "Doorlopend krediet", "factuurbedrag": "", "offertenummer": "2000121909", "passeeringangsdatum": "2015-11-17" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekenda ... [afgekapt: 1736 tekens]	1778230486535
b075d90a-53d2-407a-80a9-89f1ae8fec96	inventarisatie	{ "a1": { "naam": "Raven, Jacqueline (J.M.C.)", "adres": "Zeepkruidstraat 131", "email": "[email]", "postcode": "8245 LH", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Reekers, Frans (F.M.)", "adres": "Zeepkruidstraat 131", "postcode": "8245 LH", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "500000.00", "status": "Lopend", "artikel": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair", "tekendatum": "25569", "productnaam": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair", "maatschappij": "Woonnu", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3216244-01", "passeeringangsdatum": "2020-11-23" }, { "norm": "", "type": "Consumptief krediet", "inhoud": "0.00", "status": "Lopend", "artikel": "Doorlopend krediet", "tekendatum": "25569", "productnaam": "Doorlopend krediet", "maatschappij": "Nationale-Nederlanden Leven", "productsoort": "Doorlopend ... [afgekapt: 1146 tekens]	1778230486535
f235c68d-5854-465b-9477-058cd70d172c	base_import	{ "adres": "Oostzeestraat 113", "klant": "Jankowski (J.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8226 BH", "products": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Offerte/renteaanbod ontvangen", "artikel": "Cardif Aflos Verzekering", "tekendatum": "25569", "productnaam": "Cardif Aflos Verzekering", "maatschappij": "Cardif", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "HAV00150650", "passeeringangsdatum": "2019-11-01" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Scherp & Slim ORV annuïtair dalend", "tekendatum": "25569", "productnaam": "Scherp & Slim ORV annuïtair dalend", "maatschappij": "Hera Life", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "HL0061798", "passeeringangsdatum": "2019-11-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "produc ... [afgekapt: 2654 tekens]	1778230486535
c930b574-88c3-4631-8b83-b23f579b8753	base_import	{ "adres": "Tijm 14", "klant": "Habekotte, Melissa (M), Rolleman, Thijs (T.S.K.)", "plaats": "Dronten", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8252 CP", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "175291.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*******", "passeeringangsdatum": "2020-11-22" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "175291.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*******", "passeeringangsdatum": "2020-11-22" }, { "norm": "", ... [afgekapt: 3480 tekens]	1778230486535
c930b574-88c3-4631-8b83-b23f579b8753	inventarisatie	{ "a1": { "naam": "Habekotte, Melissa (M)", "adres": "Tijm 14", "email": "[email]", "postcode": "8252 CP", "woonplaats": "Dronten", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Rolleman, Thijs (T.S.K.)", "adres": "Tijm 14", "email": "[email]", "postcode": "8252 CP", "woonplaats": "Dronten" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "175291.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2020-11-22" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "175291.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Regu ... [afgekapt: 3025 tekens]	1778230486535
1d24720c-9b97-49c9-b0d8-0073a147115c	base_import	{ "adres": "Jol 18 16", "klant": "Kooiman, Gemma (G.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 GG", "products": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-12", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "213438", "Kooiman, Gemma (G.)", "Jol 18 16", "8243 GG", "Lelystad", "[email]", "[telefoon]", "Eigen kantoor", "Dienst", "Advies nieuwe Hypotheek/Doorstromer", "Dienst BTW vrij", "Hypotheeka ... [afgekapt: 279 tekens]	1778230486535
1d24720c-9b97-49c9-b0d8-0073a147115c	inventarisatie	{ "a1": { "naam": "Kooiman, Gemma (G.)", "adres": "Jol 18 16", "email": "[email]", "postcode": "8243 GG", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Jol 18 16", "postcode": "8243 GG", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-12", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" } ], "crmdossier_id": "213438", "dossiernummer": "213438", "dossierstatus": "Vervallen", ... [afgekapt: 11 tekens]	1778230486535
10b2c088-2130-49cd-ad7c-5a36b134e1b4	base_import	{ "adres": "Kempenaar 01 16", "klant": "Kalloe (S.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 BA", "products": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-12", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "213447", "Kalloe (S.)", "Kempenaar 01 16", "8242 BA", "Lelystad", "[email]", "[telefoon]", "Eigen kantoor", "Dienst", "Advies nieuwe Hypotheek/Doorstromer", "Dienst BTW vrij" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "213447", "dossiernummer": "213447", "dossierstatus": "Vervallen", "email_partner": "", "telefoonnummer": "[telefoon]", "email_aanvrager": "[email]" }	1778230486535
444a8ad7-21a2-44f5-a241-fb61c4454f50	inventarisatie	{ "a1": { "naam": "Wilpen, Berendina van (B)", "adres": "Hofstede 51", "email": "[email]", "postcode": "8212 WD", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Wilpen, John van (J)", "adres": "Hofstede 51", "postcode": "8212 WD", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-10-27" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "212590.00", "status": "Lopend", "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek", "tekendatum": "25569", "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek", "maatschappij": "IQWOON", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3220087-01", ... [afgekapt: 163 tekens]	1778230486535
fe467b1b-4567-4add-8487-22c9e3f97e13	inventarisatie	{ "a1": { "naam": "Broek, Lisa van den (LWS)", "adres": "P.C. Hooftplein 29", "email": "[email]", "postcode": "3842 HC", "woonplaats": "Harderwijk", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "P.C. Hooftplein 29", "postcode": "3842 HC", "woonplaats": "Harderwijk" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2021-11-02" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "175600.00", "status": "Lopend", "artikel": "Hypotrust Comfort Annuiteit (Hypotrust Standaard)", "tekendatum": "25569", "productnaam": "Hypotrust Comfort Annuiteit (Hypotrust Standaard)", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3196406-01", "passeeringangsdatum": "2020-07-30" }, { "norm": "", "type": "Inkomensver ... [afgekapt: 544 tekens]	1778230486535
93210e0e-4e20-4e82-8c44-97c044d58598	base_import	{ "adres": "Bouwen Ewoutstraat 35", "klant": "Gyebi, Nigel (NNA)", "plaats": "Vlissingen", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "4381 PP", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "147500.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*******", "passeeringangsdatum": "2021-01-18" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-09-17" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "222986", "Gyebi, Nigel (NNA)", "Bouwen Ewoutstraat 35", "4381 PP", "Vlissingen", "[email]", "[telefoon]", "*******", "ING Bank", "Hypotheek", "ING Annuiteitenhypotheek (Reg ... [afgekapt: 349 tekens]	1778230486535
93210e0e-4e20-4e82-8c44-97c044d58598	inventarisatie	{ "a1": { "naam": "Gyebi, Nigel (NNA)", "adres": "Bouwen Ewoutstraat 35", "email": "[email]", "postcode": "4381 PP", "woonplaats": "Vlissingen", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Bouwen Ewoutstraat 35", "postcode": "4381 PP", "woonplaats": "Vlissingen" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "147500.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2021-01-18" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-09-17" } ], "crmdossier_id": "222986", "dossiernummer": "222986", ... [afgekapt: 41 tekens]	1778230486535
30fc24b1-abc3-4bad-a892-51fa5cbfad01	base_import	{ "adres": "Gentenerf 10", "klant": "Bioniarz, Gabriela Barbara (G)", "plaats": "Ermelo", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "3852 LX", "products": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "TAF Woonlasten beschermer", "tekendatum": "25569", "productnaam": "TAF Woonlasten beschermer", "maatschappij": "TAF", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "ISW-3A9DFBD7-73D1-4AEC-9110-7BD3EF138367\|1015(1)", "passeeringangsdatum": "2020-10-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Inkomensbeschermer", "tekendatum": "25569", "productnaam": "Inkomensbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-571E896E-DCF2-407A-AD95-BDD7C366D626\|1015(1)", "passeeringangsdatum": "2020-10-01" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Scherp & Slim ORV annuïtair dalend", "tekendatum": "25569", "productnaam": "Scherp ... [afgekapt: 3080 tekens]	1778230486535
30fc24b1-abc3-4bad-a892-51fa5cbfad01	inventarisatie	{ "a1": { "naam": "Bioniarz, Gabriela Barbara (G)", "adres": "Gentenerf 10", "email": "[email]", "postcode": "3852 LX", "woonplaats": "Ermelo", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Gentenerf 10", "postcode": "3852 LX", "woonplaats": "Ermelo" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "TAF Woonlasten beschermer", "tekendatum": "25569", "productnaam": "TAF Woonlasten beschermer", "maatschappij": "TAF", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "ISW-3A9DFBD7-73D1-4AEC-9110-7BD3EF138367\|1015(1)", "passeeringangsdatum": "2020-10-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Inkomensbeschermer", "tekendatum": "25569", "productnaam": "Inkomensbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-571E896E-DCF2-407A-AD95-BDD7C366D626\|1015(1)", "passeeringangs ... [afgekapt: 2169 tekens]	1778230486535
c9723cec-4644-4e4f-af2b-313b14b8b856	base_import	{ "adres": "De Oeverloper 451", "klant": "Dijk, Danielle van (DM), Dijk, Olaf van (O.F.J.)", "plaats": "Dronten", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8251 HS", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-04-21" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "240000.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2020-08-10" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ ... [afgekapt: 705 tekens]	1778230486535

Raw JSON details

Rij 1251

{
  "dossier_id": "9d8d8028-f234-41d1-81c2-52c6e8ca0825",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Moet, Edwin (E.G.)",
      "adres": "Tammingecamp 15",
      "email": "[email]",
      "postcode": "7824 GN",
      "woonplaats": "Emmen",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Tammingecamp 15",
      "postcode": "7824 GN",
      "woonplaats": "Emmen"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2016-09-20"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "97445.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2021-02-05"
        },
        {
          "norm": "",
          "type": "Verkoopdienst",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen makelaardij",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-07-21"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Beeindigd",
          "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GEWI.614237",
          "passeeringangsdatum": "2016-11-01"
        }
      ],
      "crmdossier_id": "131986",
      "dossiernummer": "131986",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1252

{
  "dossier_id": "1b7f327c-2dbe-4fc3-b1a6-bb6f9511d65f",
  "key": "base_import",
  "value_json": {
    "adres": "Het Erf 92",
    "klant": "Andel, Bastiaan Jan van (BJ), Andel, Emma de (EME)",
    "plaats": "Biddinghuizen",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8256 DH",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "251880.00",
        "status": "Lopend",
        "artikel": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
        "maatschappij": "AEGON",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "7583489",
        "passeeringangsdatum": "2021-01-18"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "251880.00",
        "status": "Lopend",
        "artikel": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
        "maatschappij": "AEGON",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "7583489",
        "passeeringangsdatum": "2021-01-18"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "251880.00",
        "status": "Lopend",
        "artikel": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
        "maatschappij": "AEGON",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "7583489",
        "passeeringangsdatum": "2021-01-18"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "251880.00",
        "status": "Lopend",
        "artikel": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
        "maatschappij": "AEGON",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "7583489",
        "passeeringangsdatum": "2021-01-18"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "2020-06-10",
        "productnaam": "",
        "maatschappij": "Uw Hypotheek",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-10"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "2020-06-10",
        "productnaam": "",
        "maatschappij": "Uw Hypotheek",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-10"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "2020-06-10",
        "productnaam": "",
        "maatschappij": "Uw Hypotheek",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-10"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "2020-06-10",
        "productnaam": "",
        "maatschappij": "Uw Hypotheek",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-10"
      },
      {
        "norm": "",
        "type": "Verkoopdienst",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen makelaardij",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-07-21"
      },
      {
        "norm": "",
        "type": "Verkoopdienst",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen makelaardij",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-07-21"
      },
      {
        "norm": "",
        "type": "Verkoopdienst",
        "inhoud": "0.00", ... [afgekapt: 6741 tekens]

Rij 1253

{
  "dossier_id": "e77401c7-2551-4a41-86b7-c966f05fe826",
  "key": "base_import",
  "value_json": {
    "adres": "Blauwe Slenk 12",
    "klant": "Kotter, Onitia Georgetina (OG)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8223 XN",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Inkomensbeschermer",
        "tekendatum": "25569",
        "productnaam": "Inkomensbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-9152E36A-DA78-4DC1-990D-5DE75DF42428|1024(1)",
        "passeeringangsdatum": "2020-09-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-04-22"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Inkomensbeschermer",
        "tekendatum": "25569",
        "productnaam": "Inkomensbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-AB51D8A8-1D66-46CF-BF04-9303C5691DEE|1024(1)",
        "passeeringangsdatum": "2020-09-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2788281",
        "passeeringangsdatum": "2020-08-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "200000.00",
        "status": "Lopend",
        "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3181186-01",
        "passeeringangsdatum": "2020-12-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "211111",
      "Kotter, Onitia Georgetina (OG)",
      "Blauwe Slenk 12",
      "8223 XN",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "ISW-9152E36A-DA78-4DC1-990D-5DE75DF42428|1024(1)",
      "TAF",
      "Inkomensverzekering",
      "Inkomensbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "Eigen kantoor",
      "Hypotheekadvies",
      "ISW-AB51D8A8-1D66-46CF-BF04-9303C5691DEE|1024(1)",
      "2788281",
      "Levensverzekering",
      "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
      "Overlijdensrisicoverzekering",
      "3181186-01",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Annuiteit (Argenta Special Line Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "211111",
    "dossiernummer": "211111",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1254

{
  "dossier_id": "e77401c7-2551-4a41-86b7-c966f05fe826",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kotter, Onitia Georgetina (OG)",
      "adres": "Blauwe Slenk 12",
      "email": "[email]",
      "postcode": "8223 XN",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Blauwe Slenk 12",
      "email": "[email]",
      "postcode": "8223 XN",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Inkomensbeschermer",
          "tekendatum": "25569",
          "productnaam": "Inkomensbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-9152E36A-DA78-4DC1-990D-5DE75DF42428|1024(1)",
          "passeeringangsdatum": "2020-09-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-04-22"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Inkomensbeschermer",
          "tekendatum": "25569",
          "productnaam": "Inkomensbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-AB51D8A8-1D66-46CF-BF04-9303C5691DEE|1024(1)",
          "passeeringangsdatum": "2020-09-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2788281",
          "passeeringangsdatum": "2020-08-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "200000.00",
          "status": "Lopend",
          "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3181186-01",
          "passeeringangsdatum": "2020-12-15"
        }
      ],
      "crmdossier_id": "211111",
      "dossiernummer": "211111",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1255

{
  "dossier_id": "6b73936a-587c-491f-afa7-ef13cecc7e09",
  "key": "base_import",
  "value_json": {
    "adres": "J.T.P. Bijhouwerstraat 3",
    "klant": "Sharro (A.G.)",
    "plaats": "Almere",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1333 JT",
    "products": [
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe hypotheek starter/Aankoop",
        "tekendatum": "2020-08-04",
        "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-08-04"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-08-04"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "215863",
      "Sharro (A.G.)",
      "J.T.P. Bijhouwerstraat 3",
      "1333 JT",
      "Almere",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Dienst",
      "Advies nieuwe hypotheek starter/Aankoop",
      "Dienst BTW vrij",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "215863",
    "dossiernummer": "215863",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1256

{
  "dossier_id": "6b73936a-587c-491f-afa7-ef13cecc7e09",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Sharro (A.G.)",
      "adres": "J.T.P. Bijhouwerstraat 3",
      "email": "[email]",
      "postcode": "1333 JT",
      "woonplaats": "Almere",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "J.T.P. Bijhouwerstraat 3",
      "postcode": "1333 JT",
      "woonplaats": "Almere"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe hypotheek starter/Aankoop",
          "tekendatum": "2020-08-04",
          "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-08-04"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-08-04"
        }
      ],
      "crmdossier_id": "215863",
      "dossiernummer": "215863",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1257

{
  "dossier_id": "21f82986-03d9-4fa3-94a5-61d4f72a95dd",
  "key": "base_import",
  "value_json": {
    "adres": "Punter 39 43",
    "klant": "Burer, Jeffrey (J), Verbeek, Claudia (C.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 EW",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2757921",
        "passeeringangsdatum": "2020-03-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "191264.00",
        "status": "Lopend",
        "artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3159460-01",
        "passeeringangsdatum": "2020-07-03"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-06-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Cardif Aflos Verzekering",
        "tekendatum": "25569",
        "productnaam": "Cardif Aflos Verzekering",
        "maatschappij": "Cardif",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "HAV00160709",
        "passeeringangsdatum": "2020-06-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-02-07"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "207925",
      "Burer, Jeffrey (J), Verbeek, Claudia (C.)",
      "Punter 39 43",
      "8242 EW",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "2757921",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "3159460-01",
      "Hypotrust",
      "Hypotheek",
      "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
      "Annuitair",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal",
      "HAV00160709",
      "Cardif",
      "Inkomensverzekering",
      "Cardif Aflos Verzekering",
      "Woonlastenverzekering",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "207925",
    "dossiernummer": "207925",
    "dossierstatus": "Geroyeerd",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1258

{
  "dossier_id": "10b2c088-2130-49cd-ad7c-5a36b134e1b4",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kalloe (S.)",
      "adres": "Kempenaar 01 16",
      "email": "[email]",
      "postcode": "8242 BA",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Kempenaar 01 16",
      "postcode": "8242 BA",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2020-06-12",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-12"
        }
      ],
      "crmdossier_id": "213447",
      "dossiernummer": "213447",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1259

{
  "dossier_id": "21f82986-03d9-4fa3-94a5-61d4f72a95dd",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Burer, Jeffrey (J)",
      "adres": "Punter 39 43",
      "email": "[email]",
      "postcode": "8242 EW",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Verbeek, Claudia (C.)",
      "adres": "Punter 39 43",
      "postcode": "8242 EW",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2757921",
          "passeeringangsdatum": "2020-03-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "191264.00",
          "status": "Lopend",
          "artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3159460-01",
          "passeeringangsdatum": "2020-07-03"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-06-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Cardif Aflos Verzekering",
          "tekendatum": "25569",
          "productnaam": "Cardif Aflos Verzekering",
          "maatschappij": "Cardif",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "HAV00160709",
          "passeeringangsdatum": "2020-06-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-02-07"
        }
      ],
      "crmdossier_id": "207925",
      "dossiernummer": "207925",
      "dossierstatus": "Geroyeerd",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1260

{
  "dossier_id": "e6717098-2c09-41fb-852b-924dd7e33403",
  "key": "base_import",
  "value_json": {
    "adres": "Rijnland 26",
    "klant": "Algera, Melanie (M), Nolles, Dennis (D)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8245 CV",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2729759",
        "passeeringangsdatum": "2019-11-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-09-07"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "40035633",
        "passeeringangsdatum": "2019-11-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "40035631",
        "passeeringangsdatum": "2019-11-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "246000.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2019-11-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "200375",
      "Algera, Melanie (M), Nolles, Dennis (D)",
      "Rijnland 26",
      "8245 CV",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "2729759",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "Eigen kantoor",
      "Hypotheekadvies",
      "40035633",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "40035631",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "200375",
    "dossiernummer": "200375",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1261

{
  "dossier_id": "e6717098-2c09-41fb-852b-924dd7e33403",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Algera, Melanie (M)",
      "adres": "Rijnland 26",
      "email": "[email]",
      "postcode": "8245 CV",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Nolles, Dennis (D)",
      "adres": "Rijnland 26",
      "postcode": "8245 CV",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2729759",
          "passeeringangsdatum": "2019-11-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-09-07"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "40035633",
          "passeeringangsdatum": "2019-11-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "40035631",
          "passeeringangsdatum": "2019-11-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "246000.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2019-11-15"
        }
      ],
      "crmdossier_id": "200375",
      "dossiernummer": "200375",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1262

{
  "dossier_id": "bd1e37d6-6948-40ca-a38b-98902294907a",
  "key": "base_import",
  "value_json": {
    "adres": "Wijngaard 76",
    "klant": "Encarnacion Montas, Junior (J.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8212 CE",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-12-04"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "152382.00",
        "status": "Lopend",
        "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3148094-01",
        "passeeringangsdatum": "2020-01-06"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "200053",
      "Encarnacion Montas, Junior (J.)",
      "Wijngaard 76",
      "8212 CE",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3148094-01",
      "Hypotrust",
      "Hypotheek",
      "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "200053",
    "dossiernummer": "200053",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1263

{
  "dossier_id": "bd1e37d6-6948-40ca-a38b-98902294907a",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Encarnacion Montas, Junior (J.)",
      "adres": "Wijngaard 76",
      "email": "[email]",
      "postcode": "8212 CE",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Wijngaard 76",
      "postcode": "8212 CE",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-12-04"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "152382.00",
          "status": "Lopend",
          "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3148094-01",
          "passeeringangsdatum": "2020-01-06"
        }
      ],
      "crmdossier_id": "200053",
      "dossiernummer": "200053",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1264

{
  "dossier_id": "ee0a6758-f99f-4562-ad38-c29bd212fade",
  "key": "base_import",
  "value_json": {
    "adres": "Horst 29 42",
    "klant": "Jonge, Hendrik Jan de (HJ)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 MV",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-05-28"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-05-28"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "149989.00",
        "status": "Lopend",
        "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3193518-01",
        "passeeringangsdatum": "2020-06-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "149989.00",
        "status": "Lopend",
        "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3193518-01",
        "passeeringangsdatum": "2020-06-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Cardif Aflos Verzekering",
        "tekendatum": "25569",
        "productnaam": "Cardif Aflos Verzekering",
        "maatschappij": "Cardif",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "HAV00161466",
        "passeeringangsdatum": "2020-06-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Cardif Aflos Verzekering",
        "tekendatum": "25569",
        "productnaam": "Cardif Aflos Verzekering",
        "maatschappij": "Cardif",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "HAV00161466",
        "passeeringangsdatum": "2020-06-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "212691",
      "Jonge, Hendrik Jan de (HJ)",
      "Horst 29 42",
      "8225 MV",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3193518-01",
      "Hypotrust",
      "Hypotheek",
      "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
      "Annuitair",
      "HAV00161466",
      "Cardif",
      "Inkomensverzekering",
      "Cardif Aflos Verzekering",
      "Woonlastenverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "212691",
    "dossiernummer": "212691",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1265

{
  "dossier_id": "db46b3e9-6a02-46b3-89d2-955f281ef755",
  "key": "base_import",
  "value_json": {
    "adres": "Rozengaard 11 38",
    "klant": "Kolodziej, Bob (BJ), Sztura, Kamila (K)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8212 DB",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "207000.00",
        "status": "Lopend",
        "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1873452",
        "passeeringangsdatum": "2020-12-15"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-22"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2025-03-04"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-06-18",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-18"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GEWI.615920",
        "passeeringangsdatum": "2017-01-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "2788667",
        "passeeringangsdatum": "2020-12-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "213781",
      "Kolodziej, Bob (BJ), Sztura, Kamila (K)",
      "Rozengaard 11 38",
      "8212 DB",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "1873452",
      "Lloyds Bank",
      "Hypotheek",
      "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "Dienst",
      "Advies nieuwe Hypotheek/Doorstromer",
      "Dienst BTW vrij",
      "GEWI.615920",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen",
      "2788667",
      "TAF",
      "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "213781",
    "dossiernummer": "213781",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1266

{
  "dossier_id": "db46b3e9-6a02-46b3-89d2-955f281ef755",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kolodziej, Bob (BJ)",
      "adres": "Rozengaard 11 38",
      "email": "[email]",
      "postcode": "8212 DB",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Sztura, Kamila (K)",
      "adres": "Rozengaard 11 38",
      "postcode": "8212 DB",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "207000.00",
          "status": "Lopend",
          "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1873452",
          "passeeringangsdatum": "2020-12-15"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-22"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2025-03-04"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2020-06-18",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-18"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GEWI.615920",
          "passeeringangsdatum": "2017-01-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "2788667",
          "passeeringangsdatum": "2020-12-01"
        }
      ],
      "crmdossier_id": "213781",
      "dossiernummer": "213781",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1267

{
  "dossier_id": "7daae1ec-0ec0-44e2-bc8b-faf549585905",
  "key": "base_import",
  "value_json": {
    "adres": "",
    "klant": "Marel, van der (M.), Mikkers, Geert (G)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "413741.00",
        "status": "Lopend",
        "artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
        "tekendatum": "25569",
        "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
        "maatschappij": "Munt Hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1822482",
        "passeeringangsdatum": "2020-05-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "42100.00",
        "status": "Lopend",
        "artikel": "Munt Annuïteiten Hypotheek",
        "tekendatum": "25569",
        "productnaam": "Munt Annuïteiten Hypotheek",
        "maatschappij": "Munt Hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1822482",
        "passeeringangsdatum": "2022-06-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-02-18"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2746171",
        "passeeringangsdatum": "2020-01-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "199284",
      "Marel, van der (M.), Mikkers, Geert (G)",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "1822482",
      "Munt Hypotheken",
      "Hypotheek",
      "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
      "Aflossingsvrij, Annuitair",
      "Munt Annuïteiten Hypotheek",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2746171",
      "TAF",
      "Levensverzekering",
      "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
      "Overlijdensrisicoverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "199284",
    "dossiernummer": "199284",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1268

{
  "dossier_id": "7daae1ec-0ec0-44e2-bc8b-faf549585905",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Marel, van der (M.)",
      "email": "[email]",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Mikkers, Geert (G)",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "413741.00",
          "status": "Lopend",
          "artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
          "tekendatum": "25569",
          "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
          "maatschappij": "Munt Hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1822482",
          "passeeringangsdatum": "2020-05-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "42100.00",
          "status": "Lopend",
          "artikel": "Munt Annuïteiten Hypotheek",
          "tekendatum": "25569",
          "productnaam": "Munt Annuïteiten Hypotheek",
          "maatschappij": "Munt Hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1822482",
          "passeeringangsdatum": "2022-06-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-02-18"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2746171",
          "passeeringangsdatum": "2020-01-01"
        }
      ],
      "crmdossier_id": "199284",
      "dossiernummer": "199284",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1269

{
  "dossier_id": "32c01726-52ab-4a79-8222-57b5b67ff66f",
  "key": "base_import",
  "value_json": {
    "adres": "Zilverschoonlaan 203",
    "klant": "Driouech, Anouar",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8245 KE",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-07-06"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe hypotheek starter/Aankoop",
        "tekendatum": "2020-07-06",
        "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-07-06"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "214619",
      "Driouech, Anouar",
      "Zilverschoonlaan 203",
      "8245 KE",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "Dienst",
      "Advies nieuwe hypotheek starter/Aankoop",
      "Dienst BTW vrij"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "214619",
    "dossiernummer": "214619",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1270

{
  "dossier_id": "32c01726-52ab-4a79-8222-57b5b67ff66f",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Driouech, Anouar",
      "adres": "Zilverschoonlaan 203",
      "email": "[email]",
      "postcode": "8245 KE",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Zilverschoonlaan 203",
      "postcode": "8245 KE",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-07-06"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe hypotheek starter/Aankoop",
          "tekendatum": "2020-07-06",
          "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-07-06"
        }
      ],
      "crmdossier_id": "214619",
      "dossiernummer": "214619",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1271

{
  "dossier_id": "656d3981-42a3-479f-ac53-179afc987d57",
  "key": "base_import",
  "value_json": {
    "adres": "Botter 36 44",
    "klant": "Mahabier (P.), Sewberath Misser (A.G.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 KT",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "325000.00",
        "status": "Lopend",
        "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2095590",
        "passeeringangsdatum": "2022-10-07"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "251779",
      "Mahabier (P.), Sewberath Misser (A.G.)",
      "Botter 36 44",
      "8243 KT",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "2095590",
      "Lloyds Bank",
      "Hypotheek",
      "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "251779",
    "dossiernummer": "251779",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1272

{
  "dossier_id": "656d3981-42a3-479f-ac53-179afc987d57",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Mahabier (P.)",
      "adres": "Botter 36 44",
      "email": "[email]",
      "postcode": "8243 KT",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Sewberath Misser (A.G.)",
      "adres": "Botter 36 44",
      "email": "[email]",
      "postcode": "8243 KT",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "325000.00",
          "status": "Lopend",
          "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2095590",
          "passeeringangsdatum": "2022-10-07"
        }
      ],
      "crmdossier_id": "251779",
      "dossiernummer": "251779",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1273

{
  "dossier_id": "8c825e61-048c-4ca0-9b90-994b36c01bed",
  "key": "base_import",
  "value_json": {
    "adres": "Woudlaar 71",
    "klant": "Weverling, Leslie (LG), Weverling-Gerezgiher, H (HK)",
    "plaats": "Almere",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1359 KM",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-07-05"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-04-24"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "253703.00",
        "status": "Lopend",
        "artikel": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3074930-01",
        "passeeringangsdatum": "2018-09-28"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "ORV Annuitair dalend",
        "tekendatum": "25569",
        "productnaam": "ORV Annuitair dalend",
        "maatschappij": "Reaal schadeverzekeringen",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "1300306239",
        "passeeringangsdatum": "2018-08-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "6425.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3074930-01",
        "passeeringangsdatum": "2020-09-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "211202",
      "Weverling, Leslie (LG), Weverling-Gerezgiher, H (HK)",
      "Woudlaar 71",
      "1359 KM",
      "Almere",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3074930-01",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
      "Aflossingsvrij, Annuitair",
      "1300306239",
      "Reaal schadeverzekeringen",
      "Levensverzekering",
      "ORV Annuitair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "Argenta Annuiteit (Argenta Special Line Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "211202",
    "dossiernummer": "211202",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1274

{
  "dossier_id": "8c825e61-048c-4ca0-9b90-994b36c01bed",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Weverling, Leslie (LG)",
      "adres": "Woudlaar 71",
      "email": "[email]",
      "postcode": "1359 KM",
      "woonplaats": "Almere",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Weverling-Gerezgiher, H (HK)",
      "adres": "Woudlaar 71",
      "postcode": "1359 KM",
      "woonplaats": "Almere"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-07-05"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-04-24"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "253703.00",
          "status": "Lopend",
          "artikel": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3074930-01",
          "passeeringangsdatum": "2018-09-28"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "ORV Annuitair dalend",
          "tekendatum": "25569",
          "productnaam": "ORV Annuitair dalend",
          "maatschappij": "Reaal schadeverzekeringen",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "1300306239",
          "passeeringangsdatum": "2018-08-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "6425.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3074930-01",
          "passeeringangsdatum": "2020-09-01"
        }
      ],
      "crmdossier_id": "211202",
      "dossiernummer": "211202",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1275

{
  "dossier_id": "479d116b-3b72-40a3-bb24-0ae34626cc9e",
  "key": "base_import",
  "value_json": {
    "adres": "Schoener 45 9",
    "klant": "Marciniec , Piotr Antoni (PA)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 XG",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
        "tekendatum": "25569",
        "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "156722505385",
        "passeeringangsdatum": "2017-05-10"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "214380.00",
        "status": "Lopend",
        "artikel": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
        "maatschappij": "IQWOON",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3202655-01",
        "passeeringangsdatum": "2020-09-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-05-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-05-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2386746",
        "passeeringangsdatum": "2017-05-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-03-13"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "149171",
      "Marciniec , Piotr Antoni (PA)",
      "Schoener 45 9",
      "8243 XG",
      "Lelystad",
      "[email]",
      "[email]",
      "*********",
      "156722505385",
      "Voogd & Voogd",
      "Schadeverzekering",
      "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
      "3202655-01",
      "IQWOON",
      "Hypotheek",
      "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
      "Annuitair",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
      "2386746",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "149171",
    "dossiernummer": "149171",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "*********",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1276

{
  "dossier_id": "479d116b-3b72-40a3-bb24-0ae34626cc9e",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Marciniec , Piotr Antoni (PA)",
      "adres": "Schoener 45 9",
      "email": "[email]",
      "postcode": "8243 XG",
      "woonplaats": "Lelystad",
      "telefoon_prive": "*********"
    },
    "a2": {
      "adres": "Schoener 45 9",
      "email": "[email]",
      "postcode": "8243 XG",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
          "tekendatum": "25569",
          "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "156722505385",
          "passeeringangsdatum": "2017-05-10"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "214380.00",
          "status": "Lopend",
          "artikel": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
          "maatschappij": "IQWOON",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3202655-01",
          "passeeringangsdatum": "2020-09-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-05-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-05-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2386746",
          "passeeringangsdatum": "2017-05-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-03-13"
        }
      ],
      "crmdossier_id": "149171",
      "dossiernummer": "149171",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1277

{
  "dossier_id": "ec738fcd-419c-40e4-8c8e-de96b50d4b4b",
  "key": "base_import",
  "value_json": {
    "adres": "Karveel 59 82",
    "klant": "Eijk, Melvin van (M.J.), Grondhuis (A)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 WG",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "16066.00",
        "status": "Lopend",
        "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
        "maatschappij": "Centraal Beheer",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3172756-01",
        "passeeringangsdatum": "2022-07-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "229790.00",
        "status": "Lopend",
        "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
        "maatschappij": "Centraal Beheer",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3172756-01",
        "passeeringangsdatum": "2020-08-03"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-04-02"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GEWI.613444",
        "passeeringangsdatum": "2016-09-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "129443",
      "Eijk, Melvin van (M.J.), Grondhuis (A)",
      "Karveel 59 82",
      "8242 WG",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "3172756-01",
      "Centraal Beheer",
      "Hypotheek",
      "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
      "Annuitair",
      "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
      "Eigen kantoor",
      "Hypotheekadvies",
      "GEWI.613444",
      "Dazure",
      "Levensverzekering",
      "GewoonIdee Nabestaandenverzekering - Annuitair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "129443",
    "dossiernummer": "129443",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1278

{
  "dossier_id": "ec738fcd-419c-40e4-8c8e-de96b50d4b4b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Eijk, Melvin van (M.J.)",
      "adres": "Karveel 59 82",
      "email": "[email]",
      "postcode": "8242 WG",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Grondhuis (A)",
      "adres": "Karveel 59 82",
      "postcode": "8242 WG",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "16066.00",
          "status": "Lopend",
          "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
          "maatschappij": "Centraal Beheer",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3172756-01",
          "passeeringangsdatum": "2022-07-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "229790.00",
          "status": "Lopend",
          "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
          "maatschappij": "Centraal Beheer",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3172756-01",
          "passeeringangsdatum": "2020-08-03"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-04-02"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GEWI.613444",
          "passeeringangsdatum": "2016-09-01"
        }
      ],
      "crmdossier_id": "129443",
      "dossiernummer": "129443",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1279

{
  "dossier_id": "5ed6688b-c9da-4a4e-8248-bd1b1f6ffc9e",
  "key": "base_import",
  "value_json": {
    "adres": "Lagune 29",
    "klant": "Duztas, Cemil (C.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8224 CR",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-22"
      },
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-06-22",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-22"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "213931",
      "Duztas, Cemil (C.)",
      "Lagune 29",
      "8224 CR",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "Dienst",
      "Advies nieuwe Hypotheek/Doorstromer",
      "Dienst BTW vrij"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "213931",
    "dossiernummer": "213931",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1280

{
  "dossier_id": "5ed6688b-c9da-4a4e-8248-bd1b1f6ffc9e",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Duztas, Cemil (C.)",
      "adres": "Lagune 29",
      "email": "[email]",
      "postcode": "8224 CR",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Lagune 29",
      "postcode": "8224 CR",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-22"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2020-06-22",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-22"
        }
      ],
      "crmdossier_id": "213931",
      "dossiernummer": "213931",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1281

{
  "dossier_id": "e8442c1c-3339-4419-8a50-fc3ae4180fcf",
  "key": "base_import",
  "value_json": {
    "adres": "Punter 41 41",
    "klant": "Verhoef (C.W.E.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 GC",
    "products": [
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe hypotheek starter/Aankoop",
        "tekendatum": "2020-06-23",
        "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-23"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-23"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "214031",
      "Verhoef (C.W.E.)",
      "Punter 41 41",
      "8242 GC",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Dienst",
      "Advies nieuwe hypotheek starter/Aankoop",
      "Dienst BTW vrij",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "214031",
    "dossiernummer": "214031",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1282

{
  "dossier_id": "e8442c1c-3339-4419-8a50-fc3ae4180fcf",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Verhoef (C.W.E.)",
      "adres": "Punter 41 41",
      "email": "[email]",
      "postcode": "8242 GC",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Punter 41 41",
      "postcode": "8242 GC",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe hypotheek starter/Aankoop",
          "tekendatum": "2020-06-23",
          "productnaam": "Advies nieuwe hypotheek starter/Aankoop",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-23"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-23"
        }
      ],
      "crmdossier_id": "214031",
      "dossiernummer": "214031",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1283

{
  "dossier_id": "f235c68d-5854-465b-9477-058cd70d172c",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Jankowski (J.)",
      "adres": "Oostzeestraat 113",
      "email": "[email]",
      "postcode": "8226 BH",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Oostzeestraat 113",
      "postcode": "8226 BH",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "Cardif Aflos Verzekering",
          "tekendatum": "25569",
          "productnaam": "Cardif Aflos Verzekering",
          "maatschappij": "Cardif",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "HAV00150650",
          "passeeringangsdatum": "2019-11-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Scherp & Slim ORV annuïtair dalend",
          "tekendatum": "25569",
          "productnaam": "Scherp & Slim ORV annuïtair dalend",
          "maatschappij": "Hera Life",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "HL0061798",
          "passeeringangsdatum": "2019-11-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-09-07"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "173000.00",
          "status": "Lopend",
          "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "maatschappij": "Obvion",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "611756",
          "passeeringangsdatum": "2019-11-28"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-11-01"
        }
      ],
      "crmdossier_id": "200376",
      "dossiernummer": "200376",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1284

{
  "dossier_id": "7065b590-ff03-4134-b2f2-40610817b5b7",
  "key": "base_import",
  "value_json": {
    "adres": "Bergumermeerstraat 1",
    "klant": "Honing, Raymon (R), Kist, Mariska (MA)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8226 JK",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "334325.00",
        "status": "Lopend",
        "artikel": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair",
        "maatschappij": "Centraal Beheer",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3298974-01",
        "passeeringangsdatum": "2022-01-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-05-12"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "211912",
      "Honing, Raymon (R), Kist, Mariska (MA)",
      "Bergumermeerstraat 1",
      "8226 JK",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "3298974-01",
      "Centraal Beheer",
      "Hypotheek",
      "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "211912",
    "dossiernummer": "211912",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1285

{
  "dossier_id": "7065b590-ff03-4134-b2f2-40610817b5b7",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Honing, Raymon (R)",
      "adres": "Bergumermeerstraat 1",
      "email": "[email]",
      "postcode": "8226 JK",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Kist, Mariska (MA)",
      "adres": "Bergumermeerstraat 1",
      "postcode": "8226 JK",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "334325.00",
          "status": "Lopend",
          "artikel": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair",
          "maatschappij": "Centraal Beheer",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3298974-01",
          "passeeringangsdatum": "2022-01-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-05-12"
        }
      ],
      "crmdossier_id": "211912",
      "dossiernummer": "211912",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1286

{
  "dossier_id": "b075d90a-53d2-407a-80a9-89f1ae8fec96",
  "key": "base_import",
  "value_json": {
    "adres": "Zeepkruidstraat 131",
    "klant": "Raven, Jacqueline (J.M.C.), Reekers, Frans (F.M.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8245 LH",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "500000.00",
        "status": "Lopend",
        "artikel": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
        "tekendatum": "25569",
        "productnaam": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
        "maatschappij": "Woonnu",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3216244-01",
        "passeeringangsdatum": "2020-11-23"
      },
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Doorlopend krediet",
        "tekendatum": "25569",
        "productnaam": "Doorlopend krediet",
        "maatschappij": "Nationale-Nederlanden Leven",
        "productsoort": "Doorlopend krediet",
        "factuurbedrag": "",
        "offertenummer": "2000121909",
        "passeeringangsdatum": "2015-11-17"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-03-13"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
        "maatschappij": "Credit Life",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "7001218289",
        "passeeringangsdatum": "2020-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95164",
      "Raven, Jacqueline (J.M.C.), Reekers, Frans (F.M.)",
      "Zeepkruidstraat 131",
      "8245 LH",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "3216244-01",
      "Woonnu",
      "Hypotheek",
      "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
      "Aflossingsvrij, Annuitair",
      "2000121909",
      "Nationale-Nederlanden Leven",
      "Consumptief krediet",
      "Doorlopend krediet",
      "Eigen kantoor",
      "Hypotheekadvies",
      "7001218289",
      "Credit Life",
      "Levensverzekering",
      "Credit Life Overlijdensrisicoverzekering Annuitair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "95164",
    "dossiernummer": "95164",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1287

{
  "dossier_id": "b075d90a-53d2-407a-80a9-89f1ae8fec96",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Raven, Jacqueline (J.M.C.)",
      "adres": "Zeepkruidstraat 131",
      "email": "[email]",
      "postcode": "8245 LH",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Reekers, Frans (F.M.)",
      "adres": "Zeepkruidstraat 131",
      "postcode": "8245 LH",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "500000.00",
          "status": "Lopend",
          "artikel": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
          "maatschappij": "Woonnu",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3216244-01",
          "passeeringangsdatum": "2020-11-23"
        },
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Doorlopend krediet",
          "tekendatum": "25569",
          "productnaam": "Doorlopend krediet",
          "maatschappij": "Nationale-Nederlanden Leven",
          "productsoort": "Doorlopend krediet",
          "factuurbedrag": "",
          "offertenummer": "2000121909",
          "passeeringangsdatum": "2015-11-17"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-03-13"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
          "maatschappij": "Credit Life",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "7001218289",
          "passeeringangsdatum": "2020-05-01"
        }
      ],
      "crmdossier_id": "95164",
      "dossiernummer": "95164",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1288

{
  "dossier_id": "f235c68d-5854-465b-9477-058cd70d172c",
  "key": "base_import",
  "value_json": {
    "adres": "Oostzeestraat 113",
    "klant": "Jankowski (J.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8226 BH",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "Cardif Aflos Verzekering",
        "tekendatum": "25569",
        "productnaam": "Cardif Aflos Verzekering",
        "maatschappij": "Cardif",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "HAV00150650",
        "passeeringangsdatum": "2019-11-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Scherp & Slim ORV annuïtair dalend",
        "tekendatum": "25569",
        "productnaam": "Scherp & Slim ORV annuïtair dalend",
        "maatschappij": "Hera Life",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "HL0061798",
        "passeeringangsdatum": "2019-11-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-09-07"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "173000.00",
        "status": "Lopend",
        "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "maatschappij": "Obvion",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "611756",
        "passeeringangsdatum": "2019-11-28"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-11-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "200376",
      "Jankowski (J.)",
      "Oostzeestraat 113",
      "8226 BH",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "HAV00150650",
      "Cardif",
      "Inkomensverzekering",
      "Cardif Aflos Verzekering",
      "Woonlastenverzekering",
      "HL0061798",
      "Hera Life",
      "Levensverzekering",
      "Scherp & Slim ORV annuïtair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "Eigen kantoor",
      "Hypotheekadvies",
      "611756",
      "Obvion",
      "Hypotheek",
      "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
      "Annuitair",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "200376",
    "dossiernummer": "200376",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1289

{
  "dossier_id": "c930b574-88c3-4631-8b83-b23f579b8753",
  "key": "base_import",
  "value_json": {
    "adres": "Tijm 14",
    "klant": "Habekotte, Melissa (M), Rolleman, Thijs (T.S.K.)",
    "plaats": "Dronten",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8252 CP",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "175291.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2020-11-22"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "175291.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2020-11-22"
      },
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Persoonlijke lening",
        "tekendatum": "25569",
        "productnaam": "Persoonlijke lening",
        "maatschappij": "Qander Consumer Finance",
        "productsoort": "Persoonlijke lening",
        "factuurbedrag": "",
        "offertenummer": "3080621",
        "passeeringangsdatum": "2017-11-15"
      },
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Persoonlijke lening",
        "tekendatum": "25569",
        "productnaam": "Persoonlijke lening",
        "maatschappij": "Qander Consumer Finance",
        "productsoort": "Persoonlijke lening",
        "factuurbedrag": "",
        "offertenummer": "3080621",
        "passeeringangsdatum": "2017-11-15"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-01-10"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-01-10"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-90",
        "passeeringangsdatum": "2015-08-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-90",
        "passeeringangsdatum": "2015-08-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 8,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "104582",
      "Habekotte, Melissa (M), Rolleman, Thijs (T.S.K.)",
      "Tijm 14",
      "8252 CP",
      "Dronten",
      "[email]",
      "[email]",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "3080621",
      "Qander Consumer Finance",
      "Consumptief krediet",
      "Persoonlijke lening",
      "Eigen kantoor",
      "Hypotheekadvies",
      "[telefoon]-90",
      "Argenta hypotheken",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "104582",
    "dossiernummer": "104582",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1290

{
  "dossier_id": "c930b574-88c3-4631-8b83-b23f579b8753",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Habekotte, Melissa (M)",
      "adres": "Tijm 14",
      "email": "[email]",
      "postcode": "8252 CP",
      "woonplaats": "Dronten",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Rolleman, Thijs (T.S.K.)",
      "adres": "Tijm 14",
      "email": "[email]",
      "postcode": "8252 CP",
      "woonplaats": "Dronten"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "175291.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2020-11-22"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "175291.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2020-11-22"
        },
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Persoonlijke lening",
          "tekendatum": "25569",
          "productnaam": "Persoonlijke lening",
          "maatschappij": "Qander Consumer Finance",
          "productsoort": "Persoonlijke lening",
          "factuurbedrag": "",
          "offertenummer": "3080621",
          "passeeringangsdatum": "2017-11-15"
        },
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Persoonlijke lening",
          "tekendatum": "25569",
          "productnaam": "Persoonlijke lening",
          "maatschappij": "Qander Consumer Finance",
          "productsoort": "Persoonlijke lening",
          "factuurbedrag": "",
          "offertenummer": "3080621",
          "passeeringangsdatum": "2017-11-15"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-01-10"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-01-10"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]-90",
          "passeeringangsdatum": "2015-08-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]-90",
          "passeeringangsdatum": "2015-08-01"
        }
      ],
      "crmdossier_id": "104582",
      "dossiernummer": "104582",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1291

{
  "dossier_id": "1d24720c-9b97-49c9-b0d8-0073a147115c",
  "key": "base_import",
  "value_json": {
    "adres": "Jol 18 16",
    "klant": "Kooiman, Gemma (G.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 GG",
    "products": [
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-06-12",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-12"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-12"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "213438",
      "Kooiman, Gemma (G.)",
      "Jol 18 16",
      "8243 GG",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Dienst",
      "Advies nieuwe Hypotheek/Doorstromer",
      "Dienst BTW vrij",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "213438",
    "dossiernummer": "213438",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1292

{
  "dossier_id": "1d24720c-9b97-49c9-b0d8-0073a147115c",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kooiman, Gemma (G.)",
      "adres": "Jol 18 16",
      "email": "[email]",
      "postcode": "8243 GG",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Jol 18 16",
      "postcode": "8243 GG",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2020-06-12",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-12"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-06-12"
        }
      ],
      "crmdossier_id": "213438",
      "dossiernummer": "213438",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1293

{
  "dossier_id": "10b2c088-2130-49cd-ad7c-5a36b134e1b4",
  "key": "base_import",
  "value_json": {
    "adres": "Kempenaar 01 16",
    "klant": "Kalloe (S.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 BA",
    "products": [
      {
        "norm": "",
        "type": "Dienst",
        "inhoud": "0.00",
        "status": "Nieuw adviestraject",
        "artikel": "Advies nieuwe Hypotheek/Doorstromer",
        "tekendatum": "2020-06-12",
        "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
        "maatschappij": "Eigen kantoor",
        "productsoort": "Dienst BTW vrij",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-06-12"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "213447",
      "Kalloe (S.)",
      "Kempenaar 01 16",
      "8242 BA",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Dienst",
      "Advies nieuwe Hypotheek/Doorstromer",
      "Dienst BTW vrij"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "213447",
    "dossiernummer": "213447",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1294

{
  "dossier_id": "444a8ad7-21a2-44f5-a241-fb61c4454f50",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Wilpen, Berendina van (B)",
      "adres": "Hofstede 51",
      "email": "[email]",
      "postcode": "8212 WD",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Wilpen, John van (J)",
      "adres": "Hofstede 51",
      "postcode": "8212 WD",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-10-27"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "212590.00",
          "status": "Lopend",
          "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
          "maatschappij": "IQWOON",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3220087-01",
          "passeeringangsdatum": "2021-04-02"
        }
      ],
      "crmdossier_id": "222949",
      "dossiernummer": "222949",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1295

{
  "dossier_id": "fe467b1b-4567-4add-8487-22c9e3f97e13",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Broek, Lisa van den (LWS)",
      "adres": "P.C. Hooftplein 29",
      "email": "[email]",
      "postcode": "3842 HC",
      "woonplaats": "Harderwijk",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "P.C. Hooftplein 29",
      "postcode": "3842 HC",
      "woonplaats": "Harderwijk"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-11-02"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "175600.00",
          "status": "Lopend",
          "artikel": "Hypotrust Comfort Annuiteit (Hypotrust Standaard)",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Comfort Annuiteit (Hypotrust Standaard)",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3196406-01",
          "passeeringangsdatum": "2020-07-30"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life Woonlastenverzekering - AO",
          "tekendatum": "25569",
          "productnaam": "Credit Life Woonlastenverzekering - AO",
          "maatschappij": "Credit Life",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "5001227953",
          "passeeringangsdatum": "2020-08-01"
        }
      ],
      "crmdossier_id": "213332",
      "dossiernummer": "213332",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1296

{
  "dossier_id": "93210e0e-4e20-4e82-8c44-97c044d58598",
  "key": "base_import",
  "value_json": {
    "adres": "Bouwen Ewoutstraat 35",
    "klant": "Gyebi, Nigel (NNA)",
    "plaats": "Vlissingen",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "4381 PP",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "147500.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2021-01-18"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-09-17"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "222986",
      "Gyebi, Nigel (NNA)",
      "Bouwen Ewoutstraat 35",
      "4381 PP",
      "Vlissingen",
      "[email]",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "222986",
    "dossiernummer": "222986",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1297

{
  "dossier_id": "93210e0e-4e20-4e82-8c44-97c044d58598",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Gyebi, Nigel (NNA)",
      "adres": "Bouwen Ewoutstraat 35",
      "email": "[email]",
      "postcode": "4381 PP",
      "woonplaats": "Vlissingen",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Bouwen Ewoutstraat 35",
      "postcode": "4381 PP",
      "woonplaats": "Vlissingen"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "147500.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2021-01-18"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-09-17"
        }
      ],
      "crmdossier_id": "222986",
      "dossiernummer": "222986",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1298

{
  "dossier_id": "30fc24b1-abc3-4bad-a892-51fa5cbfad01",
  "key": "base_import",
  "value_json": {
    "adres": "Gentenerf 10",
    "klant": "Bioniarz, Gabriela Barbara (G)",
    "plaats": "Ermelo",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "3852 LX",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-3A9DFBD7-73D1-4AEC-9110-7BD3EF138367|1015(1)",
        "passeeringangsdatum": "2020-10-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Inkomensbeschermer",
        "tekendatum": "25569",
        "productnaam": "Inkomensbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-571E896E-DCF2-407A-AD95-BDD7C366D626|1015(1)",
        "passeeringangsdatum": "2020-10-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Scherp & Slim ORV annuïtair dalend",
        "tekendatum": "25569",
        "productnaam": "Scherp & Slim ORV annuïtair dalend",
        "maatschappij": "Hera Life",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "HL0088891",
        "passeeringangsdatum": "2020-10-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-09-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "200000.00",
        "status": "Lopend",
        "artikel": "Hypotrust Annuiteit (Woon Bewust)",
        "tekendatum": "25569",
        "productnaam": "Hypotrust Annuiteit (Woon Bewust)",
        "maatschappij": "Hypotrust",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3186715-01",
        "passeeringangsdatum": "2020-09-15"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-05-05"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "211611",
      "Bioniarz, Gabriela Barbara (G)",
      "Gentenerf 10",
      "3852 LX",
      "Ermelo",
      "[email]",
      "[telefoon]",
      "ISW-3A9DFBD7-73D1-4AEC-9110-7BD3EF138367|1015(1)",
      "TAF",
      "Inkomensverzekering",
      "TAF Woonlasten beschermer",
      "Woonlastenverzekering",
      "ISW-571E896E-DCF2-407A-AD95-BDD7C366D626|1015(1)",
      "Inkomensbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "HL0088891",
      "Hera Life",
      "Levensverzekering",
      "Scherp & Slim ORV annuïtair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
      "3186715-01",
      "Hypotrust",
      "Hypotheek",
      "Hypotrust Annuiteit (Woon Bewust)",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "211611",
    "dossiernummer": "211611",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1299

{
  "dossier_id": "30fc24b1-abc3-4bad-a892-51fa5cbfad01",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Bioniarz, Gabriela Barbara (G)",
      "adres": "Gentenerf 10",
      "email": "[email]",
      "postcode": "3852 LX",
      "woonplaats": "Ermelo",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Gentenerf 10",
      "postcode": "3852 LX",
      "woonplaats": "Ermelo"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-3A9DFBD7-73D1-4AEC-9110-7BD3EF138367|1015(1)",
          "passeeringangsdatum": "2020-10-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Inkomensbeschermer",
          "tekendatum": "25569",
          "productnaam": "Inkomensbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-571E896E-DCF2-407A-AD95-BDD7C366D626|1015(1)",
          "passeeringangsdatum": "2020-10-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Scherp & Slim ORV annuïtair dalend",
          "tekendatum": "25569",
          "productnaam": "Scherp & Slim ORV annuïtair dalend",
          "maatschappij": "Hera Life",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "HL0088891",
          "passeeringangsdatum": "2020-10-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-09-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "200000.00",
          "status": "Lopend",
          "artikel": "Hypotrust Annuiteit (Woon Bewust)",
          "tekendatum": "25569",
          "productnaam": "Hypotrust Annuiteit (Woon Bewust)",
          "maatschappij": "Hypotrust",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3186715-01",
          "passeeringangsdatum": "2020-09-15"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-05-05"
        }
      ],
      "crmdossier_id": "211611",
      "dossiernummer": "211611",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1300

{
  "dossier_id": "c9723cec-4644-4e4f-af2b-313b14b8b856",
  "key": "base_import",
  "value_json": {
    "adres": "De Oeverloper 451",
    "klant": "Dijk, Danielle van (DM), Dijk, Olaf van (O.F.J.)",
    "plaats": "Dronten",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8251 HS",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-04-21"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "240000.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2020-08-10"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "205544",
      "Dijk, Danielle van (DM), Dijk, Olaf van (O.F.J.)",
      "De Oeverloper 451",
      "8251 HS",
      "Dronten",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "205544",
    "dossiernummer": "205544",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

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)