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/stores300.344 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 1900

50 matchende rijen · offset 1900 · limiet 50Vorige Volgende

dossier_id	key	value_json	updated_at
c96de7a0-97e4-422a-be9b-6c3a9fca36fe	inventarisatie	{ "a1": { "naam": "Molenkamp, Trix (B.J.)", "adres": "Golfpark 140", "email": "[email]", "postcode": "8241 AG", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Pilon, Jan (J.W.)", "adres": "Golfpark 140", "postcode": "8241 AG", "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": "2019-11-12" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "296033.00", "status": "Lopend", "artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek", "tekendatum": "25569", "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "1802843", "passeeringangsdatum": "2019-12-30" ... [afgekapt: 120 tekens]	1778230486535
c96de7a0-97e4-422a-be9b-6c3a9fca36fe	base_import	{ "adres": "Golfpark 140", "klant": "Molenkamp, Trix (B.J.), Pilon, Jan (J.W.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8241 AG", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-11-12" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "296033.00", "status": "Lopend", "artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek", "tekendatum": "25569", "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "1802843", "passeeringangsdatum": "2019-12-30" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "202214", "Molenkamp, Trix (B.J.), Pilon, Jan (J.W.)", "Golfpark 140", "8241 AG", "Lelystad", "[email]", "[telefoon ... [afgekapt: 477 tekens]	1778230486535
5dace722-bc7e-4280-80d8-7c76e7583b20	inventarisatie	{ "a1": { "naam": "Groenewegen, Nicoliene (N.J.D.)", "adres": "Gondel 26 36", "email": "[email]", "postcode": "8243 CM", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Gondel 26 36", "postcode": "8243 CM", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "125083.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-03-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Offerte aangevraagd", "artikel": "Maandlastbeschermer", "tekendatum": "25569", "productnaam": "Maandlastbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbed ... [afgekapt: 2181 tekens]	1778230486535
5dace722-bc7e-4280-80d8-7c76e7583b20	base_import	{ "adres": "Gondel 26 36", "klant": "Groenewegen, Nicoliene (N.J.D.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 CM", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "125083.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-03-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Offerte aangevraagd", "artikel": "Maandlastbeschermer", "tekendatum": "25569", "productnaam": "Maandlastbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-3B734AD6-70B8-450E-960D-01E0790A95DD\|997(1)", "passeeringangsdatum": "2020-03-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", ... [afgekapt: 2578 tekens]	1778230486535
971a9aba-3aa8-4d19-ab0a-f299fe529801	inventarisatie	{ "a1": { "naam": "Siebring, Oscar (O.)", "adres": "Joachimsdaalder 5", "email": "[email]", "postcode": "8253 BV", "woonplaats": "Dronten", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Joachimsdaalder 5", "postcode": "8253 BV", "woonplaats": "Dronten" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Tijdelijke Overlijdensrisicoverzekering (Scildon)", "tekendatum": "25569", "productnaam": "Tijdelijke Overlijdensrisicoverzekering (Scildon)", "maatschappij": "Scildon", "productsoort": "Overlijdensrisicoverzekering", "factuurbedrag": "", "offertenummer": "40283738", "passeeringangsdatum": "2020-05-15" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-01-08" }, { "norm": "NHG", "type": "Hypotheek", ... [afgekapt: 566 tekens]	1778230486535
971a9aba-3aa8-4d19-ab0a-f299fe529801	base_import	{ "adres": "Joachimsdaalder 5", "klant": "Siebring, Oscar (O.)", "plaats": "Dronten", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8253 BV", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Tijdelijke Overlijdensrisicoverzekering (Scildon)", "tekendatum": "25569", "productnaam": "Tijdelijke Overlijdensrisicoverzekering (Scildon)", "maatschappij": "Scildon", "productsoort": "Overlijdensrisicoverzekering", "factuurbedrag": "", "offertenummer": "40283738", "passeeringangsdatum": "2020-05-15" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-01-08" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "186150.00", "status": "Lopend", "artikel": "bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek", "maatsch ... [afgekapt: 1012 tekens]	1778230486535
0fa132bb-baef-44fd-b4df-cf56ac8932c5	inventarisatie	{ "a1": { "naam": "Dydzik-Frankowska, Ewa (EM)", "adres": "Jan Mankesstraat 21", "email": "[email]", "postcode": "8072 ZA", "woonplaats": "Nunspeet", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Frankowski, Rafal (RP)", "adres": "Jan Mankesstraat 21", "postcode": "8072 ZA", "woonplaats": "Nunspeet" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "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": "2751034", "passeeringangsdatum": "2020-03-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Inkomensbeschermer", "tekendatum": "25569", "productnaam": "Inkomensbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offerten ... [afgekapt: 2063 tekens]	1778230486535
0fa132bb-baef-44fd-b4df-cf56ac8932c5	base_import	{ "adres": "Jan Mankesstraat 21", "klant": "Dydzik-Frankowska, Ewa (EM), Frankowski, Rafal (RP)", "plaats": "Nunspeet", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8072 ZA", "products": [ { "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": "2751034", "passeeringangsdatum": "2020-03-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Inkomensbeschermer", "tekendatum": "25569", "productnaam": "Inkomensbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-B6EF8867-03F7-416E-9530-A05E55FDB78E\|970(1)", "passeeringangsdatum": "2020-03-16" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "21903.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere ... [afgekapt: 2686 tekens]	1778230486535
ac50b3e0-d27f-4246-a759-71745c28ed9d	inventarisatie	{ "a1": { "naam": "Versteijne, P (P.A.M)", "adres": "Eaglelaan 152", "email": "[email]", "postcode": "8241 AP", "woonplaats": "LELYSTAD", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Eaglelaan 152", "postcode": "8241 AP", "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": "2017-04-11" } ], "crmdossier_id": "127252", "dossiernummer": "127252", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
46c6e49a-e9be-4764-b2f7-2ae79808ee96	inventarisatie	{ "a1": { "naam": "Stankiewicz, Bartlomiej (B)", "adres": "Waterpas 16", "email": "[email]", "postcode": "8253 LH", "woonplaats": "Dronten", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Waterpas 16", "email": "[email]", "postcode": "8253 LH", "woonplaats": "Dronten" }, "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": "2019-10-03" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "260000.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2019-12-02" }, { "norm": "", "type": "Schadeverzeke ... [afgekapt: 568 tekens]	1778230486535
46c6e49a-e9be-4764-b2f7-2ae79808ee96	base_import	{ "adres": "Waterpas 16", "klant": "Stankiewicz, Bartlomiej (B)", "plaats": "Dronten", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8253 LH", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-10-03" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "260000.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2019-12-02" }, { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "Opstal, Inboedel, Aansprakelijkheid", "tekendatum": "25569", "productnaam": "Opstal, Inboedel, Aansprakelijkheid", "maatschappij": "Risk Assuradeuren", "productsoort": "Aansp ... [afgekapt: 1015 tekens]	1778230486535
407b3541-107b-4e09-b0a0-3a1240254672	inventarisatie	{ "a1": { "naam": "Vogelzang, Ellen (E)", "adres": "Het Vledder 30", "email": "[email]", "postcode": "7941 KL", "woonplaats": "Meppel", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Voor, Michael de (M)", "adres": "Het Vledder 30", "email": "[email]", "postcode": "7941 KL", "woonplaats": "Meppel" }, "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": "2019-09-16" }, { "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": "HL0067271", "passeeringangsdatum": "2019-12-01" }, { "nor ... [afgekapt: 1640 tekens]	1778230486535
407b3541-107b-4e09-b0a0-3a1240254672	base_import	{ "adres": "Het Vledder 30", "klant": "Vogelzang, Ellen (E), Voor, Michael de (M)", "plaats": "Meppel", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "7941 KL", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-09-16" }, { "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": "HL0067271", "passeeringangsdatum": "2019-12-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Offerte aangevraagd", "artikel": "Maandlastbeschermer", "tekendatum": "25569", "productnaam": "Maandlastbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheids ... [afgekapt: 2336 tekens]	1778230486535
0e6d56da-a2e8-4afc-a907-5f6cbeb169ab	inventarisatie	{ "a1": { "naam": "Bonestroo, Wilbert (W)", "adres": "Boeier 04 40", "postcode": "8242 CK", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Dijk, Ellen May van (E)", "adres": "Boeier 04 40", "email": "[email]", "postcode": "8242 CK", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "320000.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-01" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "51601.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offe ... [afgekapt: 191 tekens]	1778230486535
0e6d56da-a2e8-4afc-a907-5f6cbeb169ab	base_import	{ "adres": "Boeier 04 40", "klant": "Bonestroo, Wilbert (W), Dijk, Ellen May van (E)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 CK", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "320000.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-01" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "51601.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*******", "passeeringangsdatum": "2021-08-01" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "201072", "Bonestroo, Wilbert (W), Dijk, Ellen May van (E)", ... [afgekapt: 487 tekens]	1778230486535
545a259b-22cc-4d90-9b60-6a787aeee03f	inventarisatie	{ "a1": { "adres": "Karveel 07 93", "email": "[email]", "postcode": "8231 AK", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Karveel 07 93", "postcode": "8231 AK", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "17650.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2024-08-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "196266.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)", "m ... [afgekapt: 3613 tekens]	1778230486535
545a259b-22cc-4d90-9b60-6a787aeee03f	base_import	{ "adres": "Karveel 07 93", "klant": "", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8231 AK", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "17650.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*******", "passeeringangsdatum": "2024-08-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "196266.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": "2019-11-18" }, { "norm": "", "type": "Schadeverzekerin ... [afgekapt: 4643 tekens]	1778230486535
29057d76-674d-49d4-acec-e765a72d6dcb	inventarisatie	{ "a1": { "naam": "Kowalski, Martin (K.M.)", "adres": "De Veste 17 18", "email": "[email]", "postcode": "8231 JN", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "De Veste 17 18", "email": "[email]", "postcode": "8231 JN", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "165000.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": "2019-11-19" }, { "norm": "", "type": "Consumptief krediet", "inhoud": "0.00", "status": "Lopend", "artikel": "Interbank Persoonlijke Lening", "tekendatum": "25569", "productnaam": "Interbank Persoonlij ... [afgekapt: 1697 tekens]	1778230486535
29057d76-674d-49d4-acec-e765a72d6dcb	base_import	{ "adres": "De Veste 17 18", "klant": "Kowalski, Martin (K.M.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8231 JN", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "165000.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": "2019-11-19" }, { "norm": "", "type": "Consumptief krediet", "inhoud": "0.00", "status": "Lopend", "artikel": "Interbank Persoonlijke Lening", "tekendatum": "25569", "productnaam": "Interbank Persoonlijke Lening", "maatschappij": "InterBank NV", "productsoort": "Persoonlijke lening", "factuurbedrag": "", "offertenummer": "*******", "passeeringangsdatum": "2016-12-13" }, { "norm": "", "type": "Levensverzekering", ... [afgekapt: 2376 tekens]	1778230486535
04225db5-f025-4bc6-b137-23e06c6e3af8	inventarisatie	{ "a1": { "naam": "Sirvania, Joyeceline (J)", "adres": "Beemster 103", "email": "[email]", "postcode": "8244 CG", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Beemster 103", "postcode": "8244 CG", "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": "2019-07-24" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "205000.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-07" } ], "crmdossier_id": "198414", "dossiernummer": "198414", "dossiers ... [afgekapt: 32 tekens]	1778230486535
b6634149-1681-445e-aebc-8ec73645ae53	base_import	{ "adres": "Jol 24 21", "klant": "Kamniski, Jaroslaw Piotr (JP)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 GN", "products": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Maandlastbeschermer", "tekendatum": "25569", "productnaam": "Maandlastbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-13B7BD91-F6B1-417D-85CB-49A15246C046\|990(1)", "passeeringangsdatum": "2020-03-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-01-22" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "179500.00", "status": "Lopend", "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)", "tekendatum": "25569", "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)", "maatschappij": "ASN (voorheen BLG Wonen)", "productsoort" ... [afgekapt: 980 tekens]	1778230486535
dec814a8-36bc-4d94-a6a4-35b8fbc8585c	inventarisatie	{ "a1": { "naam": "Nagy-Molnar (E)", "adres": "Kempenaar 15 17", "email": "[email]", "postcode": "8231 EE", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Kempenaar 15 17", "postcode": "8231 EE", "woonplaats": "Lelystad" }, "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": "40033560", "passeeringangsdatum": "2019-06-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-04-24" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "326835.00", "status": "Lop ... [afgekapt: 2651 tekens]	1778230486535
dec814a8-36bc-4d94-a6a4-35b8fbc8585c	base_import	{ "adres": "Kempenaar 15 17", "klant": "Nagy-Molnar (E)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8231 EE", "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": "40033560", "passeeringangsdatum": "2019-06-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-04-24" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "326835.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek) ... [afgekapt: 3399 tekens]	1778230486535
2d3e3d62-6c84-45d9-9d38-6f989f82d2bf	inventarisatie	{ "a1": { "naam": "Roos, de (J.C.)", "adres": "Annie M.G. Schmidtstraat 54", "email": "[email]", "postcode": "1822 MB", "woonplaats": "Alkmaar", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Annie M.G. Schmidtstraat 54", "postcode": "1822 MB", "woonplaats": "Alkmaar" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "204945.00", "status": "Lopend", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1765993", "passeeringangsdatum": "2019-11-08" }, { "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": "HL ... [afgekapt: 1495 tekens]	1778230486535
2d3e3d62-6c84-45d9-9d38-6f989f82d2bf	base_import	{ "adres": "Annie M.G. Schmidtstraat 54", "klant": "Roos, de (J.C.)", "plaats": "Alkmaar", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "1822 MB", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "204945.00", "status": "Lopend", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1765993", "passeeringangsdatum": "2019-11-08" }, { "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": "HL0039491", "passeeringangsdatum": "2019-11-05" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatsch ... [afgekapt: 2088 tekens]	1778230486535
ed6e0fe3-4116-48a0-b2dc-53f53555df78	inventarisatie	{ "a1": { "naam": "Zheng, Danny (D)", "adres": "De Koets 18", "email": "[email]", "postcode": "8256 DP", "woonplaats": "Biddinghuizen", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "De Koets 18", "postcode": "8256 DP", "woonplaats": "Biddinghuizen" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "134200.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": "612354", "passeeringangsdatum": "2019-12-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "pa ... [afgekapt: 155 tekens]	1778230486535
7b36e5f1-f149-4685-9e8f-8e935fdf42be	inventarisatie	{ "a1": { "naam": "Schouten (M.P.J.)", "adres": "Goeree 2", "email": "[email]", "postcode": "8245 GA", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Goeree 2", "postcode": "8245 GA", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "Auto", "tekendatum": "25569", "productnaam": "Auto", "maatschappij": "Risk Assuradeuren", "productsoort": "Personenauto", "factuurbedrag": "", "offertenummer": "5369PK-*********", "passeeringangsdatum": "2022-09-01" } ], "crmdossier_id": "99893", "dossiernummer": "99893", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
ed6e0fe3-4116-48a0-b2dc-53f53555df78	base_import	{ "adres": "De Koets 18", "klant": "Zheng, Danny (D)", "plaats": "Biddinghuizen", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8256 DP", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "134200.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": "612354", "passeeringangsdatum": "2019-12-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-09-06" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "200373", "Zheng, Danny (D)", "De Koets 18", "8256 DP", "Biddinghuizen", " ... [afgekapt: 520 tekens]	1778230486535
ea6a4188-2703-48d6-a8c0-1ba196495fa3	inventarisatie	{ "a1": { "naam": "Chen , Tingshi (T)", "adres": "De Koets 18", "email": "[email]", "postcode": "8256 DP", "woonplaats": "Biddinghuizen", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "De Koets 18", "email": "[email]", "postcode": "8256 DP", "woonplaats": "Biddinghuizen" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "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-07-01" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Offerte/renteaanbod ontvangen", "artikel": "Annuitair dalende overlijdensrisico", "tekendatum": "25569", "productnaam": "Annuitair dalende overlijdensrisico", "maatschappij": "Reaal schadeverzekeringen", "productsoort": "Overlijdensrisicoverzekering", "fa ... [afgekapt: 1620 tekens]	1778230486535
ea6a4188-2703-48d6-a8c0-1ba196495fa3	base_import	{ "adres": "De Koets 18", "klant": "Chen , Tingshi (T)", "plaats": "Biddinghuizen", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8256 DP", "products": [ { "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-07-01" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Offerte/renteaanbod ontvangen", "artikel": "Annuitair dalende overlijdensrisico", "tekendatum": "25569", "productnaam": "Annuitair dalende overlijdensrisico", "maatschappij": "Reaal schadeverzekeringen", "productsoort": "Overlijdensrisicoverzekering", "factuurbedrag": "", "offertenummer": "1300388304", "passeeringangsdatum": "2019-07-15" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "182500.00", "status": "Lopend", "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Won ... [afgekapt: 2325 tekens]	1778230486535
dde298d7-97c5-4e8f-b3ee-3f06377f6b4c	inventarisatie	{ "a1": { "naam": "Wekken, Wim van der (L.W.)", "adres": "Veneweg 292106", "email": "[email]", "postcode": "7946 LX", "woonplaats": "WANNEPERVEEN", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Veneweg 292106", "postcode": "7946 LX", "woonplaats": "WANNEPERVEEN" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "153260.00", "status": "Lopend", "artikel": "Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek", "tekendatum": "25569", "productnaam": "Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek", "maatschappij": "Rabobank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "28239405", "passeeringangsdatum": "2019-04-11" } ], "crmdossier_id": "180227", "dossiernummer": "180227", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
9fa3a658-0f4a-446d-8ef3-934c4ef8826f	inventarisatie	{ "a1": { "naam": "Schelvis, Bernadette (BTW)", "adres": "De Pionier 2", "postcode": "8254 BA", "woonplaats": "Dronten", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "De Pionier 2", "postcode": "8254 BA", "woonplaats": "Dronten" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "76488.00", "status": "Lopend", "artikel": "Attens Aflossingsvrije hypotheek", "tekendatum": "25569", "productnaam": "Attens Aflossingsvrije hypotheek", "maatschappij": "Attens Hypotheken", "productsoort": "Aflossingsvrij", "factuurbedrag": "", "offertenummer": "313953", "passeeringangsdatum": "2019-04-16" } ], "crmdossier_id": "186460", "dossiernummer": "186460", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
9fa3a658-0f4a-446d-8ef3-934c4ef8826f	base_import	{ "adres": "De Pionier 2", "klant": "Schelvis, Bernadette (BTW)", "plaats": "Dronten", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8254 BA", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "76488.00", "status": "Lopend", "artikel": "Attens Aflossingsvrije hypotheek", "tekendatum": "25569", "productnaam": "Attens Aflossingsvrije hypotheek", "maatschappij": "Attens Hypotheken", "productsoort": "Aflossingsvrij", "factuurbedrag": "", "offertenummer": "313953", "passeeringangsdatum": "2019-04-16" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "186460", "Schelvis, Bernadette (BTW)", "De Pionier 2", "8254 BA", "Dronten", "[telefoon]", "313953", "Attens Hypotheken", "Hypotheek", "Attens Aflossingsvrije hypotheek", "Aflossingsvrij" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "186460", "dossiernummer": "186460", "dossierstatus": "Actief", "email_partner": "", "telefoonnummer": "[telefoon]", "email_aanvrager": "" }	1778230486535
1b7bd5ec-ea6f-4be4-b7b2-3ea60d76d96b	inventarisatie	{ "a1": { "naam": "Kerkvliet, Robert (R)", "adres": "Westkaap 9", "email": "[email]", "postcode": "8224 EE", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Westkaap 9", "postcode": "8224 EE", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "67956.00", "status": "Lopend", "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), 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), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)", "maatschappij": "Obvion", "productsoort": "Annuitair", "factuurbedrag": "2250.00", "offertenummer": "596819", "passeeringangsdatum": "2019-02-28" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "A ... [afgekapt: 393 tekens]	1778230486535
1b7bd5ec-ea6f-4be4-b7b2-3ea60d76d96b	base_import	{ "adres": "Westkaap 9", "klant": "Kerkvliet, Robert (R)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8224 EE", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "67956.00", "status": "Lopend", "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), 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), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)", "maatschappij": "Obvion", "productsoort": "Annuitair", "factuurbedrag": "2250.00", "offertenummer": "596819", "passeeringangsdatum": "2019-02-28" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsda ... [afgekapt: 875 tekens]	1778230486535
f7c3d5e4-0973-4d26-b00c-684ac2dd3bd2	inventarisatie	{ "a1": { "naam": "Ootes, Wilko (W.N.)", "adres": "Tuinstraat 22", "email": "[email]", "postcode": "8315 AG", "woonplaats": "Luttelgeest", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Snijder, Petronella Hendrica (PH)", "adres": "Tuinstraat 22", "postcode": "8315 AG", "woonplaats": "Luttelgeest" }, "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-02-17" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "99283.00", "status": "Lopend", "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek", "tekendatum": "25569", "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek", "maatschappij": "IQWOON", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3242204-01", "passeeringangsdatum": "2021-0 ... [afgekapt: 128 tekens]	1778230486535
f7c3d5e4-0973-4d26-b00c-684ac2dd3bd2	base_import	{ "adres": "Tuinstraat 22", "klant": "Ootes, Wilko (W.N.), Snijder, Petronella Hendrica (PH)", "plaats": "Luttelgeest", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8315 AG", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2021-02-17" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "99283.00", "status": "Lopend", "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek", "tekendatum": "25569", "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek", "maatschappij": "IQWOON", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3242204-01", "passeeringangsdatum": "2021-03-01" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "229264", "Ootes, Wilko (W.N.), Snijder, Petronella Hendrica (PH)", "Tuinstraat 22", "8315 AG", "Luttelgeest", "[em ... [afgekapt: 495 tekens]	1778230486535
dde298d7-97c5-4e8f-b3ee-3f06377f6b4c	base_import	{ "adres": "Veneweg 292106", "klant": "Wekken, Wim van der (L.W.)", "plaats": "WANNEPERVEEN", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "7946 LX", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "153260.00", "status": "Lopend", "artikel": "Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek", "tekendatum": "25569", "productnaam": "Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek", "maatschappij": "Rabobank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "28239405", "passeeringangsdatum": "2019-04-11" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "180227", "Wekken, Wim van der (L.W.)", "Veneweg 292106", "7946 LX", "WANNEPERVEEN", "[email]", "[telefoon]", "28239405", "Rabobank", "Hypotheek", "Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek", "Annuitair" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "1802 ... [afgekapt: 114 tekens]	1778230486535
30c04ff0-941a-4bc6-83d9-6971cf176bda	inventarisatie	{ "a1": { "naam": "Lucassen, Raoul (R.)", "adres": "Punter 14 33", "email": "[email]", "postcode": "8242 DD", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Punter 14 33", "email": "[email]", "postcode": "8242 DD", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Project", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Huis & Hypotheek Nederland C.O. B.V.", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2021-01-01" }, { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies Omzetting/Verhoging/Oversluiting", "tekendatum": "2020-12-23", "productnaam": "Advies Omzetting/Verhoging/Oversluiting", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-12-23" }, { "norm": "", "type": "Hypoth ... [afgekapt: 1210 tekens]	1778230486535
a3364919-345b-45f7-9ec0-9f8506b88530	inventarisatie	{ "a1": { "naam": "Baars, Kelly (KM)", "adres": "Botter 42 20", "email": "[email]", "postcode": "8243 JA", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Botter 42 20", "email": "[email]", "postcode": "8243 JA", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Maandlastbeschermer", "tekendatum": "25569", "productnaam": "Maandlastbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-F13EFAA5-372B-4A34-9742-F65FA32B29CE\|1000(1)", "passeeringangsdatum": "2020-06-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Maandlastbeschermer", "tekendatum": "25569", "productnaam": "Maandlastbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-F13EFAA5-372B-4A34-9742-F65FA32B29CE\|1000(1)", ... [afgekapt: 3000 tekens]	1778230486535
a3364919-345b-45f7-9ec0-9f8506b88530	base_import	{ "adres": "Botter 42 20", "klant": "Baars, Kelly (KM)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 JA", "products": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Maandlastbeschermer", "tekendatum": "25569", "productnaam": "Maandlastbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-F13EFAA5-372B-4A34-9742-F65FA32B29CE\|1000(1)", "passeeringangsdatum": "2020-06-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Maandlastbeschermer", "tekendatum": "25569", "productnaam": "Maandlastbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-F13EFAA5-372B-4A34-9742-F65FA32B29CE\|1000(1)", "passeeringangsdatum": "2020-06-01" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", ... [afgekapt: 3464 tekens]	1778230486535
0f44eb28-665d-44e6-aaf4-2f906d34c56c	inventarisatie	{ "a1": { "naam": "Giskes, Henriette (H.S.)", "adres": "Schoener 18 10", "postcode": "8243 TP", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Schoener 18 10", "email": "[email]", "postcode": "8243 TP", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "190000.00", "status": "Lopend", "artikel": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek", "tekendatum": "25569", "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Aflossingsvrij", "factuurbedrag": "", "offertenummer": "1764761", "passeeringangsdatum": "2019-08-12" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-05-27" }, { "norm": ... [afgekapt: 699 tekens]	1778230486535
0f44eb28-665d-44e6-aaf4-2f906d34c56c	base_import	{ "adres": "Schoener 18 10", "klant": "Giskes, Henriette (H.S.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 TP", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "190000.00", "status": "Lopend", "artikel": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek", "tekendatum": "25569", "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Aflossingsvrij", "factuurbedrag": "", "offertenummer": "1764761", "passeeringangsdatum": "2019-08-12" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-05-27" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "232198.00", "status": "Gepasseerd", "artikel": "Aflossingsvrije hypotheek (Argenta Hypotheek), Annuïteitenhypotheek (Argenta Hypotheek)", "tekendatum": "25569", "productna ... [afgekapt: 1182 tekens]	1778230486535
79e17e2d-7a28-435b-8e7b-ebb3e3a236ee	inventarisatie	{ "a1": { "naam": "Ahmet, Sharona (S.R.)", "adres": "Majoraan 43", "email": "[email]", "postcode": "8252 BD", "woonplaats": "DRONTEN", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Majoraan 43", "postcode": "8252 BD", "woonplaats": "DRONTEN" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Arbeidsongeschiktheidsverzekering", "tekendatum": "25569", "productnaam": "Arbeidsongeschiktheidsverzekering", "maatschappij": "Cardif", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "H102769", "passeeringangsdatum": "2015-01-01" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "16675.00", "status": "Lopend", "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)", "tekendatum": "25569", "productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)", "maatschappij": "Obvion", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "606548", "passeeringangsd ... [afgekapt: 2726 tekens]	1778230486535
ced13c39-437c-433c-b260-8d3d7e8a5c39	inventarisatie	{ "a1": { "naam": "Ellerbroek (J.H.W.)", "adres": "De Veurdele 111", "email": "[email]", "postcode": "7948 DM", "woonplaats": "Nijeveen", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Wijnand", "adres": "De Veurdele 111", "email": "[email]", "postcode": "7948 DM", "woonplaats": "Nijeveen" }, "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": "2017-01-27" } ], "crmdossier_id": "97277", "dossiernummer": "97277", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
79e17e2d-7a28-435b-8e7b-ebb3e3a236ee	base_import	{ "adres": "Majoraan 43", "klant": "Ahmet, Sharona (S.R.)", "plaats": "DRONTEN", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8252 BD", "products": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Arbeidsongeschiktheidsverzekering", "tekendatum": "25569", "productnaam": "Arbeidsongeschiktheidsverzekering", "maatschappij": "Cardif", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "H102769", "passeeringangsdatum": "2015-01-01" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "16675.00", "status": "Lopend", "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)", "tekendatum": "25569", "productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)", "maatschappij": "Obvion", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "606548", "passeeringangsdatum": "2022-09-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "181078.00", "status": "Lopend", "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Com ... [afgekapt: 3581 tekens]	1778230486535
0b602929-e3e0-41b9-bd93-b1a11772cc88	inventarisatie	{ "a1": { "naam": "Zheng, Ming Gan (MG)", "adres": "De Deel 19", "email": "[email]", "postcode": "8256 EL", "woonplaats": "Biddinghuizen", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Zheng, Xiao-ju (X)", "adres": "De Deel 19", "postcode": "8256 EL", "woonplaats": "Biddinghuizen" }, "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": "2019-09-06" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "235000.00", "status": "Lopend", "artikel": "NIBC Annuiteit, NIBC Aflossingsvrij", "tekendatum": "25569", "productnaam": "NIBC Annuiteit, NIBC Aflossingsvrij", "maatschappij": "NIBC", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "1788513", "passeeringangsdatum": "2019-12-01" }, { "norm": "", "type": "Levensverzek ... [afgekapt: 558 tekens]	1778230486535
0b602929-e3e0-41b9-bd93-b1a11772cc88	base_import	{ "adres": "De Deel 19", "klant": "Zheng, Ming Gan (MG), Zheng, Xiao-ju (X)", "plaats": "Biddinghuizen", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8256 EL", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-09-06" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "235000.00", "status": "Lopend", "artikel": "NIBC Annuiteit, NIBC Aflossingsvrij", "tekendatum": "25569", "productnaam": "NIBC Annuiteit, NIBC Aflossingsvrij", "maatschappij": "NIBC", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "1788513", "passeeringangsdatum": "2019-12-01" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Offerte/renteaanbod ontvangen", "artikel": "ORV Annuitair dalend", "tekendatum": "25569", "productnaam": "ORV Annuitair dalend", "maatschappij": "Reaal schadeverzekeringen", "productsoort": "Annuit ... [afgekapt: 1001 tekens]	1778230486535
56c804de-4c8e-42dd-b7ef-02c6094e9f65	inventarisatie	{ "a1": { "naam": "Poel, Ralf van der (R)", "adres": "Rozengaard 18 7", "email": "[email]", "postcode": "8212 DP", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Rozengaard 18 7", "postcode": "8212 DP", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Offerte/renteaanbod ontvangen", "artikel": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair", "tekendatum": "25569", "productnaam": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair", "maatschappij": "TAF", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "2840037", "passeeringangsdatum": "2021-05-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "266387.00", "status": "Lopend", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "maatschapp ... [afgekapt: 1727 tekens]	1778230486535
56c804de-4c8e-42dd-b7ef-02c6094e9f65	base_import	{ "adres": "Rozengaard 18 7", "klant": "Poel, Ralf van der (R)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8212 DP", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Offerte/renteaanbod ontvangen", "artikel": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair", "tekendatum": "25569", "productnaam": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair", "maatschappij": "TAF", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "2840037", "passeeringangsdatum": "2021-05-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "266387.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": "1779823", "passeeringangsdatum": "2019-09-13" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "161600.00" ... [afgekapt: 2389 tekens]	1778230486535

Raw JSON details

Rij 1901

{
  "dossier_id": "c96de7a0-97e4-422a-be9b-6c3a9fca36fe",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Molenkamp, Trix (B.J.)",
      "adres": "Golfpark 140",
      "email": "[email]",
      "postcode": "8241 AG",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Pilon, Jan (J.W.)",
      "adres": "Golfpark 140",
      "postcode": "8241 AG",
      "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": "2019-11-12"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "296033.00",
          "status": "Lopend",
          "artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek",
          "tekendatum": "25569",
          "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek",
          "maatschappij": "Munt Hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1802843",
          "passeeringangsdatum": "2019-12-30"
        }
      ],
      "crmdossier_id": "202214",
      "dossiernummer": "202214",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1902

{
  "dossier_id": "c96de7a0-97e4-422a-be9b-6c3a9fca36fe",
  "key": "base_import",
  "value_json": {
    "adres": "Golfpark 140",
    "klant": "Molenkamp, Trix (B.J.), Pilon, Jan (J.W.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8241 AG",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-11-12"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "296033.00",
        "status": "Lopend",
        "artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek",
        "tekendatum": "25569",
        "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek",
        "maatschappij": "Munt Hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1802843",
        "passeeringangsdatum": "2019-12-30"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "202214",
      "Molenkamp, Trix (B.J.), Pilon, Jan (J.W.)",
      "Golfpark 140",
      "8241 AG",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "1802843",
      "Munt Hypotheken",
      "Hypotheek",
      "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek",
      "Aflossingsvrij, Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "202214",
    "dossiernummer": "202214",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1903

{
  "dossier_id": "5dace722-bc7e-4280-80d8-7c76e7583b20",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Groenewegen, Nicoliene (N.J.D.)",
      "adres": "Gondel 26 36",
      "email": "[email]",
      "postcode": "8243 CM",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Gondel 26 36",
      "postcode": "8243 CM",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "125083.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-03-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-3B734AD6-70B8-450E-960D-01E0790A95DD|997(1)",
          "passeeringangsdatum": "2020-03-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2024-05-23"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-12-04"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2024-05-28"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2024-05-25"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2024-05-23"
        }
      ],
      "crmdossier_id": "274672",
      "dossiernummer": "274672",
      "dossierstatus": "Nieuw",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1904

{
  "dossier_id": "5dace722-bc7e-4280-80d8-7c76e7583b20",
  "key": "base_import",
  "value_json": {
    "adres": "Gondel 26 36",
    "klant": "Groenewegen, Nicoliene (N.J.D.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 CM",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "125083.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-03-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-3B734AD6-70B8-450E-960D-01E0790A95DD|997(1)",
        "passeeringangsdatum": "2020-03-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-05-23"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-12-04"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-05-28"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-05-25"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2024-05-23"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 7,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "274672",
      "Groenewegen, Nicoliene (N.J.D.)",
      "Gondel 26 36",
      "8243 CM",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "ISW-3B734AD6-70B8-450E-960D-01E0790A95DD|997(1)",
      "TAF",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "274672",
    "dossiernummer": "274672",
    "dossierstatus": "Nieuw",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1905

{
  "dossier_id": "971a9aba-3aa8-4d19-ab0a-f299fe529801",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Siebring, Oscar (O.)",
      "adres": "Joachimsdaalder 5",
      "email": "[email]",
      "postcode": "8253 BV",
      "woonplaats": "Dronten",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Joachimsdaalder 5",
      "postcode": "8253 BV",
      "woonplaats": "Dronten"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Tijdelijke Overlijdensrisicoverzekering (Scildon)",
          "tekendatum": "25569",
          "productnaam": "Tijdelijke Overlijdensrisicoverzekering (Scildon)",
          "maatschappij": "Scildon",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "40283738",
          "passeeringangsdatum": "2020-05-15"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-01-08"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "186150.00",
          "status": "Lopend",
          "artikel": "bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek",
          "maatschappij": "bijBouwe",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3153756-01",
          "passeeringangsdatum": "2020-05-15"
        }
      ],
      "crmdossier_id": "202251",
      "dossiernummer": "202251",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1906

{
  "dossier_id": "971a9aba-3aa8-4d19-ab0a-f299fe529801",
  "key": "base_import",
  "value_json": {
    "adres": "Joachimsdaalder 5",
    "klant": "Siebring, Oscar (O.)",
    "plaats": "Dronten",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8253 BV",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Tijdelijke Overlijdensrisicoverzekering (Scildon)",
        "tekendatum": "25569",
        "productnaam": "Tijdelijke Overlijdensrisicoverzekering (Scildon)",
        "maatschappij": "Scildon",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "40283738",
        "passeeringangsdatum": "2020-05-15"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-01-08"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "186150.00",
        "status": "Lopend",
        "artikel": "bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek",
        "maatschappij": "bijBouwe",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3153756-01",
        "passeeringangsdatum": "2020-05-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "202251",
      "Siebring, Oscar (O.)",
      "Joachimsdaalder 5",
      "8253 BV",
      "Dronten",
      "[email]",
      "[telefoon]",
      "40283738",
      "Scildon",
      "Levensverzekering",
      "Tijdelijke Overlijdensrisicoverzekering (Scildon)",
      "Overlijdensrisicoverzekering",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3153756-01",
      "bijBouwe",
      "Hypotheek",
      "bijBouwe Annuiteitenhypotheek, bijBouwe Annuiteitenhypotheek",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "202251",
    "dossiernummer": "202251",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1907

{
  "dossier_id": "0fa132bb-baef-44fd-b4df-cf56ac8932c5",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Dydzik-Frankowska, Ewa (EM)",
      "adres": "Jan Mankesstraat 21",
      "email": "[email]",
      "postcode": "8072 ZA",
      "woonplaats": "Nunspeet",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Frankowski, Rafal (RP)",
      "adres": "Jan Mankesstraat 21",
      "postcode": "8072 ZA",
      "woonplaats": "Nunspeet"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "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": "2751034",
          "passeeringangsdatum": "2020-03-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Inkomensbeschermer",
          "tekendatum": "25569",
          "productnaam": "Inkomensbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-B6EF8867-03F7-416E-9530-A05E55FDB78E|970(1)",
          "passeeringangsdatum": "2020-03-16"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "21903.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2021-12-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "216000.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2020-03-16"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-12-04"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-348FB342-2C79-4696-B6C5-45A609A7DE35|970(1)",
          "passeeringangsdatum": "2020-02-01"
        }
      ],
      "crmdossier_id": "205215",
      "dossiernummer": "205215",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1908

{
  "dossier_id": "0fa132bb-baef-44fd-b4df-cf56ac8932c5",
  "key": "base_import",
  "value_json": {
    "adres": "Jan Mankesstraat 21",
    "klant": "Dydzik-Frankowska, Ewa (EM), Frankowski, Rafal (RP)",
    "plaats": "Nunspeet",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8072 ZA",
    "products": [
      {
        "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": "2751034",
        "passeeringangsdatum": "2020-03-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Inkomensbeschermer",
        "tekendatum": "25569",
        "productnaam": "Inkomensbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-B6EF8867-03F7-416E-9530-A05E55FDB78E|970(1)",
        "passeeringangsdatum": "2020-03-16"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "21903.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2021-12-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "216000.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2020-03-16"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-12-04"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-348FB342-2C79-4696-B6C5-45A609A7DE35|970(1)",
        "passeeringangsdatum": "2020-02-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "205215",
      "Dydzik-Frankowska, Ewa (EM), Frankowski, Rafal (RP)",
      "Jan Mankesstraat 21",
      "8072 ZA",
      "Nunspeet",
      "[email]",
      "[telefoon]",
      "2751034",
      "TAF",
      "Levensverzekering",
      "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
      "Overlijdensrisicoverzekering",
      "ISW-B6EF8867-03F7-416E-9530-A05E55FDB78E|970(1)",
      "Inkomensverzekering",
      "Inkomensbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "*********",
      "Eigen kantoor",
      "Hypotheekadvies",
      "ISW-348FB342-2C79-4696-B6C5-45A609A7DE35|970(1)",
      "Maandlastbeschermer"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "205215",
    "dossiernummer": "205215",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1909

{
  "dossier_id": "ac50b3e0-d27f-4246-a759-71745c28ed9d",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Versteijne, P (P.A.M)",
      "adres": "Eaglelaan 152",
      "email": "[email]",
      "postcode": "8241 AP",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Eaglelaan 152",
      "postcode": "8241 AP",
      "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": "2017-04-11"
        }
      ],
      "crmdossier_id": "127252",
      "dossiernummer": "127252",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1910

{
  "dossier_id": "46c6e49a-e9be-4764-b2f7-2ae79808ee96",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Stankiewicz, Bartlomiej (B)",
      "adres": "Waterpas 16",
      "email": "[email]",
      "postcode": "8253 LH",
      "woonplaats": "Dronten",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Waterpas 16",
      "email": "[email]",
      "postcode": "8253 LH",
      "woonplaats": "Dronten"
    },
    "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": "2019-10-03"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "260000.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2019-12-02"
        },
        {
          "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-11-01"
        }
      ],
      "crmdossier_id": "201714",
      "dossiernummer": "201714",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1911

{
  "dossier_id": "46c6e49a-e9be-4764-b2f7-2ae79808ee96",
  "key": "base_import",
  "value_json": {
    "adres": "Waterpas 16",
    "klant": "Stankiewicz, Bartlomiej (B)",
    "plaats": "Dronten",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8253 LH",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-10-03"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "260000.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2019-12-02"
      },
      {
        "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-11-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "201714",
      "Stankiewicz, Bartlomiej (B)",
      "Waterpas 16",
      "8253 LH",
      "Dronten",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "201714",
    "dossiernummer": "201714",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1912

{
  "dossier_id": "407b3541-107b-4e09-b0a0-3a1240254672",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Vogelzang, Ellen (E)",
      "adres": "Het Vledder 30",
      "email": "[email]",
      "postcode": "7941 KL",
      "woonplaats": "Meppel",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Voor, Michael de (M)",
      "adres": "Het Vledder 30",
      "email": "[email]",
      "postcode": "7941 KL",
      "woonplaats": "Meppel"
    },
    "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": "2019-09-16"
        },
        {
          "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": "HL0067271",
          "passeeringangsdatum": "2019-12-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-4FC9D6B3-E833-403A-A758-1A64969234EC|948(1)",
          "passeeringangsdatum": "2019-12-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-11-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "210222.00",
          "status": "Lopend",
          "artikel": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
          "maatschappij": "Allianz",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3134278-01",
          "passeeringangsdatum": "2019-11-15"
        }
      ],
      "crmdossier_id": "200804",
      "dossiernummer": "200804",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1913

{
  "dossier_id": "407b3541-107b-4e09-b0a0-3a1240254672",
  "key": "base_import",
  "value_json": {
    "adres": "Het Vledder 30",
    "klant": "Vogelzang, Ellen (E), Voor, Michael de (M)",
    "plaats": "Meppel",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "7941 KL",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-09-16"
      },
      {
        "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": "HL0067271",
        "passeeringangsdatum": "2019-12-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-4FC9D6B3-E833-403A-A758-1A64969234EC|948(1)",
        "passeeringangsdatum": "2019-12-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Aansprakelijkheid",
        "tekendatum": "25569",
        "productnaam": "Aansprakelijkheid",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-11-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "210222.00",
        "status": "Lopend",
        "artikel": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
        "maatschappij": "Allianz",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3134278-01",
        "passeeringangsdatum": "2019-11-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "200804",
      "Vogelzang, Ellen (E), Voor, Michael de (M)",
      "Het Vledder 30",
      "7941 KL",
      "Meppel",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "HL0067271",
      "Hera Life",
      "Levensverzekering",
      "Scherp & Slim ORV annuïtair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "ISW-4FC9D6B3-E833-403A-A758-1A64969234EC|948(1)",
      "TAF",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Aansprakelijkheid",
      "3134278-01",
      "Allianz",
      "Hypotheek",
      "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
      "Aflossingsvrij, Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "200804",
    "dossiernummer": "200804",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1914

{
  "dossier_id": "0e6d56da-a2e8-4afc-a907-5f6cbeb169ab",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Bonestroo, Wilbert (W)",
      "adres": "Boeier 04 40",
      "postcode": "8242 CK",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Dijk, Ellen May van (E)",
      "adres": "Boeier 04 40",
      "email": "[email]",
      "postcode": "8242 CK",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "320000.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-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "51601.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2021-08-01"
        }
      ],
      "crmdossier_id": "201072",
      "dossiernummer": "201072",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1915

{
  "dossier_id": "0e6d56da-a2e8-4afc-a907-5f6cbeb169ab",
  "key": "base_import",
  "value_json": {
    "adres": "Boeier 04 40",
    "klant": "Bonestroo, Wilbert (W), Dijk, Ellen May van (E)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 CK",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "320000.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-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "51601.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2021-08-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "201072",
      "Bonestroo, Wilbert (W), Dijk, Ellen May van (E)",
      "Boeier 04 40",
      "8242 CK",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "*********",
      "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": "201072",
    "dossiernummer": "201072",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

Rij 1916

{
  "dossier_id": "545a259b-22cc-4d90-9b60-6a787aeee03f",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "adres": "Karveel 07 93",
      "email": "[email]",
      "postcode": "8231 AK",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Karveel 07 93",
      "postcode": "8231 AK",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "17650.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2024-08-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "196266.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": "2019-11-18"
        },
        {
          "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-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": "134000.00",
          "status": "Gepasseerd",
          "artikel": "NIBC Annuiteit",
          "tekendatum": "25569",
          "productnaam": "NIBC Annuiteit",
          "maatschappij": "NIBC",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.467.123",
          "passeeringangsdatum": "2016-11-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "40036503",
          "passeeringangsdatum": "2019-11-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "ORV Annuitair dalend",
          "tekendatum": "25569",
          "productnaam": "ORV Annuitair dalend",
          "maatschappij": "Reaal schadeverzekeringen",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "ISW-E7009316-CB40-4340-AB2F-8C4DDC8FEAC4|949(1)",
          "passeeringangsdatum": "2019-11-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
          "tekendatum": "25569",
          "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
          "maatschappij": "Dazure",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "GIEN.700477",
          "passeeringangsdatum": "2016-09-01"
        },
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Interbank Doorlopend Krediet",
          "tekendatum": "25569",
          "productnaam": "Interbank Doorlopend Krediet",
          "maatschappij": "InterBank NV",
          "productsoort": "Doorlopend krediet",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2016-08-01"
        }
      ],
      "crmdossier_id": "200377",
      "dossiernummer": "200377",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1917

{
  "dossier_id": "545a259b-22cc-4d90-9b60-6a787aeee03f",
  "key": "base_import",
  "value_json": {
    "adres": "Karveel 07 93",
    "klant": "",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8231 AK",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "17650.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2024-08-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "196266.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": "2019-11-18"
      },
      {
        "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-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": "134000.00",
        "status": "Gepasseerd",
        "artikel": "NIBC Annuiteit",
        "tekendatum": "25569",
        "productnaam": "NIBC Annuiteit",
        "maatschappij": "NIBC",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.467.123",
        "passeeringangsdatum": "2016-11-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "40036503",
        "passeeringangsdatum": "2019-11-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "ORV Annuitair dalend",
        "tekendatum": "25569",
        "productnaam": "ORV Annuitair dalend",
        "maatschappij": "Reaal schadeverzekeringen",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "ISW-E7009316-CB40-4340-AB2F-8C4DDC8FEAC4|949(1)",
        "passeeringangsdatum": "2019-11-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
        "tekendatum": "25569",
        "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
        "maatschappij": "Dazure",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "GIEN.700477",
        "passeeringangsdatum": "2016-09-01"
      },
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Interbank Doorlopend Krediet",
        "tekendatum": "25569",
        "productnaam": "Interbank Doorlopend Krediet",
        "maatschappij": "InterBank NV",
        "productsoort": "Doorlopend krediet",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2016-08-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 9,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "200377",
      "Karveel 07 93",
      "8231 AK",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "*********",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
      "Eigen kantoor",
      "Hypotheekadvies",
      "1.467.123",
      "NIBC",
      "NIBC Annuiteit",
      "40036503",
      "TAF",
      "Inkomensverzekering",
      "TAF Woonlasten beschermer",
      "Woonlastenverzekering",
      "ISW-E7009316-CB40-4340-AB2F-8C4DDC8FEAC4|949(1)",
      "Reaal schadeverzekeringen",
      "Levensverzekering",
      "ORV Annuitair dalend",
      "Annuitair Dalende Risicoverzekeringen", ... [afgekapt: 550 tekens]

Rij 1918

{
  "dossier_id": "29057d76-674d-49d4-acec-e765a72d6dcb",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kowalski, Martin (K.M.)",
      "adres": "De Veste 17 18",
      "email": "[email]",
      "postcode": "8231 JN",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "De Veste 17 18",
      "email": "[email]",
      "postcode": "8231 JN",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "165000.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": "2019-11-19"
        },
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Interbank Persoonlijke Lening",
          "tekendatum": "25569",
          "productnaam": "Interbank Persoonlijke Lening",
          "maatschappij": "InterBank NV",
          "productsoort": "Persoonlijke lening",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2016-12-13"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]-52",
          "passeeringangsdatum": "2013-12-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": "Scherp & Slim ORV annuïtair dalend",
          "tekendatum": "25569",
          "productnaam": "Scherp & Slim ORV annuïtair dalend",
          "maatschappij": "Hera Life",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "HL0039434",
          "passeeringangsdatum": "2019-08-01"
        }
      ],
      "crmdossier_id": "96377",
      "dossiernummer": "96377",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1919

{
  "dossier_id": "29057d76-674d-49d4-acec-e765a72d6dcb",
  "key": "base_import",
  "value_json": {
    "adres": "De Veste 17 18",
    "klant": "Kowalski, Martin (K.M.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8231 JN",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "165000.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": "2019-11-19"
      },
      {
        "norm": "",
        "type": "Consumptief krediet",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Interbank Persoonlijke Lening",
        "tekendatum": "25569",
        "productnaam": "Interbank Persoonlijke Lening",
        "maatschappij": "InterBank NV",
        "productsoort": "Persoonlijke lening",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2016-12-13"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-52",
        "passeeringangsdatum": "2013-12-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": "Scherp & Slim ORV annuïtair dalend",
        "tekendatum": "25569",
        "productnaam": "Scherp & Slim ORV annuïtair dalend",
        "maatschappij": "Hera Life",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "HL0039434",
        "passeeringangsdatum": "2019-08-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "96377",
      "Kowalski, Martin (K.M.)",
      "De Veste 17 18",
      "8231 JN",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "*********",
      "InterBank NV",
      "Consumptief krediet",
      "Interbank Persoonlijke Lening",
      "Persoonlijke lening",
      "[telefoon]-52",
      "Argenta hypotheken",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen",
      "Eigen kantoor",
      "Hypotheekadvies",
      "HL0039434",
      "Hera Life",
      "Scherp & Slim ORV annuïtair dalend"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "96377",
    "dossiernummer": "96377",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1920

{
  "dossier_id": "04225db5-f025-4bc6-b137-23e06c6e3af8",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Sirvania, Joyeceline (J)",
      "adres": "Beemster 103",
      "email": "[email]",
      "postcode": "8244 CG",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Beemster 103",
      "postcode": "8244 CG",
      "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": "2019-07-24"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "205000.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-07"
        }
      ],
      "crmdossier_id": "198414",
      "dossiernummer": "198414",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1921

{
  "dossier_id": "b6634149-1681-445e-aebc-8ec73645ae53",
  "key": "base_import",
  "value_json": {
    "adres": "Jol 24 21",
    "klant": "Kamniski, Jaroslaw Piotr (JP)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 GN",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-13B7BD91-F6B1-417D-85CB-49A15246C046|990(1)",
        "passeeringangsdatum": "2020-03-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-01-22"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "179500.00",
        "status": "Lopend",
        "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "maatschappij": "ASN (voorheen BLG Wonen)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "10341974",
        "passeeringangsdatum": "2020-03-30"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "207107",
      "Kamniski, Jaroslaw Piotr (JP)",
      "Jol 24 21",
      "8243 GN",
      "Lelystad",
      "[email]",
      "06683142636",
      "ISW-13B7BD91-F6B1-417D-85CB-49A15246C046|990(1)",
      "TAF",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "Eigen kantoor",
      "Hypotheekadvies",
      "10341974",
      "ASN (voorheen BLG Wonen)",
      "Hypotheek",
      "BLG Annuïteitenhypotheek (BLG Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "207107",
    "dossiernummer": "207107",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "06683142636",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1922

{
  "dossier_id": "dec814a8-36bc-4d94-a6a4-35b8fbc8585c",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Nagy-Molnar (E)",
      "adres": "Kempenaar 15 17",
      "email": "[email]",
      "postcode": "8231 EE",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Kempenaar 15 17",
      "postcode": "8231 EE",
      "woonplaats": "Lelystad"
    },
    "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": "40033560",
          "passeeringangsdatum": "2019-06-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-04-24"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "326835.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": "2022-11-30"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "185000.00",
          "status": "Lopend",
          "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "maatschappij": "Obvion",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "604308",
          "passeeringangsdatum": "2019-08-02"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "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": "ISW-853C8915-9095-4490-B595-0A550C07D799(1)",
          "passeeringangsdatum": "2019-06-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": "HL0032274",
          "passeeringangsdatum": "2019-06-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "40033561",
          "passeeringangsdatum": "2019-06-01"
        }
      ],
      "crmdossier_id": "189187",
      "dossiernummer": "189187",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1923

{
  "dossier_id": "dec814a8-36bc-4d94-a6a4-35b8fbc8585c",
  "key": "base_import",
  "value_json": {
    "adres": "Kempenaar 15 17",
    "klant": "Nagy-Molnar (E)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8231 EE",
    "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": "40033560",
        "passeeringangsdatum": "2019-06-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-04-24"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "326835.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": "2022-11-30"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "185000.00",
        "status": "Lopend",
        "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "maatschappij": "Obvion",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "604308",
        "passeeringangsdatum": "2019-08-02"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "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": "ISW-853C8915-9095-4490-B595-0A550C07D799(1)",
        "passeeringangsdatum": "2019-06-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": "HL0032274",
        "passeeringangsdatum": "2019-06-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "40033561",
        "passeeringangsdatum": "2019-06-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 7,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "189187",
      "Nagy-Molnar (E)",
      "Kempenaar 15 17",
      "8231 EE",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "40033560",
      "TAF",
      "Inkomensverzekering",
      "TAF Woonlasten beschermer",
      "Woonlastenverzekering",
      "Eigen kantoor",
      "Hypotheekadvies",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "604308",
      "Obvion",
      "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
      "ISW-853C8915-9095-4490-B595-0A550C07D799(1)",
      "Hera Life",
      "Levensverzekering",
      "Scherp & Slim ORV annuïtair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "HL0032274",
      "40033561",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "189187",
    "dossiernummer": "189187",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1924

{
  "dossier_id": "2d3e3d62-6c84-45d9-9d38-6f989f82d2bf",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Roos, de (J.C.)",
      "adres": "Annie M.G. Schmidtstraat 54",
      "email": "[email]",
      "postcode": "1822 MB",
      "woonplaats": "Alkmaar",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Annie M.G. Schmidtstraat 54",
      "postcode": "1822 MB",
      "woonplaats": "Alkmaar"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "204945.00",
          "status": "Lopend",
          "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1765993",
          "passeeringangsdatum": "2019-11-08"
        },
        {
          "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": "HL0039491",
          "passeeringangsdatum": "2019-11-05"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-06-04"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "Inkomensbeschermer",
          "tekendatum": "25569",
          "productnaam": "Inkomensbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-5D0211D6-06CF-4905-8CC9-C184F41A759D|924(2)",
          "passeeringangsdatum": "2020-01-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "TAF",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "ISW-5D0211D6-06CF-4905-8CC9-C184F41A759D|924(1)",
          "passeeringangsdatum": "2020-01-01"
        }
      ],
      "crmdossier_id": "191679",
      "dossiernummer": "191679",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1925

{
  "dossier_id": "2d3e3d62-6c84-45d9-9d38-6f989f82d2bf",
  "key": "base_import",
  "value_json": {
    "adres": "Annie M.G. Schmidtstraat 54",
    "klant": "Roos, de (J.C.)",
    "plaats": "Alkmaar",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1822 MB",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "204945.00",
        "status": "Lopend",
        "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1765993",
        "passeeringangsdatum": "2019-11-08"
      },
      {
        "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": "HL0039491",
        "passeeringangsdatum": "2019-11-05"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-06-04"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "Inkomensbeschermer",
        "tekendatum": "25569",
        "productnaam": "Inkomensbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-5D0211D6-06CF-4905-8CC9-C184F41A759D|924(2)",
        "passeeringangsdatum": "2020-01-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "TAF",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "ISW-5D0211D6-06CF-4905-8CC9-C184F41A759D|924(1)",
        "passeeringangsdatum": "2020-01-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "191679",
      "Roos, de (J.C.)",
      "Annie M.G. Schmidtstraat 54",
      "1822 MB",
      "Alkmaar",
      "[email]",
      "[telefoon]",
      "1765993",
      "Lloyds Bank",
      "Hypotheek",
      "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
      "Annuitair",
      "HL0039491",
      "Hera Life",
      "Levensverzekering",
      "Scherp & Slim ORV annuïtair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "Eigen kantoor",
      "Hypotheekadvies",
      "ISW-5D0211D6-06CF-4905-8CC9-C184F41A759D|924(2)",
      "TAF",
      "Inkomensverzekering",
      "Inkomensbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "ISW-5D0211D6-06CF-4905-8CC9-C184F41A759D|924(1)"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "191679",
    "dossiernummer": "191679",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1926

{
  "dossier_id": "ed6e0fe3-4116-48a0-b2dc-53f53555df78",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Zheng, Danny (D)",
      "adres": "De Koets 18",
      "email": "[email]",
      "postcode": "8256 DP",
      "woonplaats": "Biddinghuizen",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "De Koets 18",
      "postcode": "8256 DP",
      "woonplaats": "Biddinghuizen"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "134200.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": "612354",
          "passeeringangsdatum": "2019-12-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-09-06"
        }
      ],
      "crmdossier_id": "200373",
      "dossiernummer": "200373",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1927

{
  "dossier_id": "7b36e5f1-f149-4685-9e8f-8e935fdf42be",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Schouten (M.P.J.)",
      "adres": "Goeree 2",
      "email": "[email]",
      "postcode": "8245 GA",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Goeree 2",
      "postcode": "8245 GA",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Auto",
          "tekendatum": "25569",
          "productnaam": "Auto",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Personenauto",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2022-09-01"
        }
      ],
      "crmdossier_id": "99893",
      "dossiernummer": "99893",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1928

{
  "dossier_id": "ed6e0fe3-4116-48a0-b2dc-53f53555df78",
  "key": "base_import",
  "value_json": {
    "adres": "De Koets 18",
    "klant": "Zheng, Danny (D)",
    "plaats": "Biddinghuizen",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8256 DP",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "134200.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": "612354",
        "passeeringangsdatum": "2019-12-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-09-06"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "200373",
      "Zheng, Danny (D)",
      "De Koets 18",
      "8256 DP",
      "Biddinghuizen",
      "[email]",
      "[telefoon]",
      "612354",
      "Obvion",
      "Hypotheek",
      "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "200373",
    "dossiernummer": "200373",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1929

{
  "dossier_id": "ea6a4188-2703-48d6-a8c0-1ba196495fa3",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Chen , Tingshi (T)",
      "adres": "De Koets 18",
      "email": "[email]",
      "postcode": "8256 DP",
      "woonplaats": "Biddinghuizen",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "De Koets 18",
      "email": "[email]",
      "postcode": "8256 DP",
      "woonplaats": "Biddinghuizen"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "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-07-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "Annuitair dalende overlijdensrisico",
          "tekendatum": "25569",
          "productnaam": "Annuitair dalende overlijdensrisico",
          "maatschappij": "Reaal schadeverzekeringen",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "1300388304",
          "passeeringangsdatum": "2019-07-15"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "182500.00",
          "status": "Lopend",
          "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Woninghypotheek)",
          "tekendatum": "25569",
          "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Woninghypotheek)",
          "maatschappij": "ABN AMRO",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2019-07-15"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-03-05"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "Cardif Aflos Verzekering",
          "tekendatum": "25569",
          "productnaam": "Cardif Aflos Verzekering",
          "maatschappij": "Cardif",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-C59651D0-BA53-4196-8C56-7519E60EB22C|874(1)",
          "passeeringangsdatum": "2019-07-01"
        }
      ],
      "crmdossier_id": "187972",
      "dossiernummer": "187972",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1930

{
  "dossier_id": "ea6a4188-2703-48d6-a8c0-1ba196495fa3",
  "key": "base_import",
  "value_json": {
    "adres": "De Koets 18",
    "klant": "Chen , Tingshi (T)",
    "plaats": "Biddinghuizen",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8256 DP",
    "products": [
      {
        "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-07-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "Annuitair dalende overlijdensrisico",
        "tekendatum": "25569",
        "productnaam": "Annuitair dalende overlijdensrisico",
        "maatschappij": "Reaal schadeverzekeringen",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "1300388304",
        "passeeringangsdatum": "2019-07-15"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "182500.00",
        "status": "Lopend",
        "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Woninghypotheek)",
        "tekendatum": "25569",
        "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Woninghypotheek)",
        "maatschappij": "ABN AMRO",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2019-07-15"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-03-05"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "Cardif Aflos Verzekering",
        "tekendatum": "25569",
        "productnaam": "Cardif Aflos Verzekering",
        "maatschappij": "Cardif",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-C59651D0-BA53-4196-8C56-7519E60EB22C|874(1)",
        "passeeringangsdatum": "2019-07-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "187972",
      "Chen , Tingshi (T)",
      "De Koets 18",
      "8256 DP",
      "Biddinghuizen",
      "[email]",
      "[email]",
      "[telefoon]",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid",
      "Aansprakelijkheid, Inboedel, Opstal",
      "1300388304",
      "Reaal schadeverzekeringen",
      "Levensverzekering",
      "Annuitair dalende overlijdensrisico",
      "Overlijdensrisicoverzekering",
      "*********",
      "ABN AMRO",
      "Hypotheek",
      "ABN AMRO Annuïteiten hypotheek (ABN AMRO Woninghypotheek)",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "ISW-C59651D0-BA53-4196-8C56-7519E60EB22C|874(1)",
      "Cardif",
      "Inkomensverzekering",
      "Cardif Aflos Verzekering",
      "Woonlastenverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "187972",
    "dossiernummer": "187972",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1931

{
  "dossier_id": "dde298d7-97c5-4e8f-b3ee-3f06377f6b4c",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Wekken, Wim van der (L.W.)",
      "adres": "Veneweg 292106",
      "email": "[email]",
      "postcode": "7946 LX",
      "woonplaats": "WANNEPERVEEN",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Veneweg 292106",
      "postcode": "7946 LX",
      "woonplaats": "WANNEPERVEEN"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "153260.00",
          "status": "Lopend",
          "artikel": "Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek",
          "tekendatum": "25569",
          "productnaam": "Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek",
          "maatschappij": "Rabobank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "28239405",
          "passeeringangsdatum": "2019-04-11"
        }
      ],
      "crmdossier_id": "180227",
      "dossiernummer": "180227",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1932

{
  "dossier_id": "9fa3a658-0f4a-446d-8ef3-934c4ef8826f",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Schelvis, Bernadette (BTW)",
      "adres": "De Pionier 2",
      "postcode": "8254 BA",
      "woonplaats": "Dronten",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "De Pionier 2",
      "postcode": "8254 BA",
      "woonplaats": "Dronten"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "76488.00",
          "status": "Lopend",
          "artikel": "Attens Aflossingsvrije hypotheek",
          "tekendatum": "25569",
          "productnaam": "Attens Aflossingsvrije hypotheek",
          "maatschappij": "Attens Hypotheken",
          "productsoort": "Aflossingsvrij",
          "factuurbedrag": "",
          "offertenummer": "313953",
          "passeeringangsdatum": "2019-04-16"
        }
      ],
      "crmdossier_id": "186460",
      "dossiernummer": "186460",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1933

{
  "dossier_id": "9fa3a658-0f4a-446d-8ef3-934c4ef8826f",
  "key": "base_import",
  "value_json": {
    "adres": "De Pionier 2",
    "klant": "Schelvis, Bernadette (BTW)",
    "plaats": "Dronten",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8254 BA",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "76488.00",
        "status": "Lopend",
        "artikel": "Attens Aflossingsvrije hypotheek",
        "tekendatum": "25569",
        "productnaam": "Attens Aflossingsvrije hypotheek",
        "maatschappij": "Attens Hypotheken",
        "productsoort": "Aflossingsvrij",
        "factuurbedrag": "",
        "offertenummer": "313953",
        "passeeringangsdatum": "2019-04-16"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "186460",
      "Schelvis, Bernadette (BTW)",
      "De Pionier 2",
      "8254 BA",
      "Dronten",
      "[telefoon]",
      "313953",
      "Attens Hypotheken",
      "Hypotheek",
      "Attens Aflossingsvrije hypotheek",
      "Aflossingsvrij"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "186460",
    "dossiernummer": "186460",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

Rij 1934

{
  "dossier_id": "1b7bd5ec-ea6f-4be4-b7b2-3ea60d76d96b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kerkvliet, Robert (R)",
      "adres": "Westkaap 9",
      "email": "[email]",
      "postcode": "8224 EE",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Westkaap 9",
      "postcode": "8224 EE",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "67956.00",
          "status": "Lopend",
          "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), 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), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "maatschappij": "Obvion",
          "productsoort": "Annuitair",
          "factuurbedrag": "2250.00",
          "offertenummer": "596819",
          "passeeringangsdatum": "2019-02-28"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-11-20"
        }
      ],
      "crmdossier_id": "181665",
      "dossiernummer": "181665",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1935

{
  "dossier_id": "1b7bd5ec-ea6f-4be4-b7b2-3ea60d76d96b",
  "key": "base_import",
  "value_json": {
    "adres": "Westkaap 9",
    "klant": "Kerkvliet, Robert (R)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8224 EE",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "67956.00",
        "status": "Lopend",
        "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), 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), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "maatschappij": "Obvion",
        "productsoort": "Annuitair",
        "factuurbedrag": "2250.00",
        "offertenummer": "596819",
        "passeeringangsdatum": "2019-02-28"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-11-20"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "181665",
      "Kerkvliet, Robert (R)",
      "Westkaap 9",
      "8224 EE",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "596819",
      "Obvion",
      "Hypotheek",
      "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "181665",
    "dossiernummer": "181665",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1936

{
  "dossier_id": "f7c3d5e4-0973-4d26-b00c-684ac2dd3bd2",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Ootes, Wilko (W.N.)",
      "adres": "Tuinstraat 22",
      "email": "[email]",
      "postcode": "8315 AG",
      "woonplaats": "Luttelgeest",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Snijder, Petronella Hendrica (PH)",
      "adres": "Tuinstraat 22",
      "postcode": "8315 AG",
      "woonplaats": "Luttelgeest"
    },
    "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-02-17"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "99283.00",
          "status": "Lopend",
          "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
          "maatschappij": "IQWOON",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3242204-01",
          "passeeringangsdatum": "2021-03-01"
        }
      ],
      "crmdossier_id": "229264",
      "dossiernummer": "229264",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1937

{
  "dossier_id": "f7c3d5e4-0973-4d26-b00c-684ac2dd3bd2",
  "key": "base_import",
  "value_json": {
    "adres": "Tuinstraat 22",
    "klant": "Ootes, Wilko (W.N.), Snijder, Petronella Hendrica (PH)",
    "plaats": "Luttelgeest",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8315 AG",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2021-02-17"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "99283.00",
        "status": "Lopend",
        "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
        "maatschappij": "IQWOON",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3242204-01",
        "passeeringangsdatum": "2021-03-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "229264",
      "Ootes, Wilko (W.N.), Snijder, Petronella Hendrica (PH)",
      "Tuinstraat 22",
      "8315 AG",
      "Luttelgeest",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3242204-01",
      "IQWOON",
      "Hypotheek",
      "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
      "Aflossingsvrij, Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "229264",
    "dossiernummer": "229264",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1938

{
  "dossier_id": "dde298d7-97c5-4e8f-b3ee-3f06377f6b4c",
  "key": "base_import",
  "value_json": {
    "adres": "Veneweg 292106",
    "klant": "Wekken, Wim van der (L.W.)",
    "plaats": "WANNEPERVEEN",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "7946 LX",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "153260.00",
        "status": "Lopend",
        "artikel": "Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek",
        "tekendatum": "25569",
        "productnaam": "Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek",
        "maatschappij": "Rabobank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "28239405",
        "passeeringangsdatum": "2019-04-11"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "180227",
      "Wekken, Wim van der (L.W.)",
      "Veneweg 292106",
      "7946 LX",
      "WANNEPERVEEN",
      "[email]",
      "[telefoon]",
      "28239405",
      "Rabobank",
      "Hypotheek",
      "Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek, Rabobank Annuiteiten Hypotheek",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "180227",
    "dossiernummer": "180227",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1939

{
  "dossier_id": "30c04ff0-941a-4bc6-83d9-6971cf176bda",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Lucassen, Raoul (R.)",
      "adres": "Punter 14 33",
      "email": "[email]",
      "postcode": "8242 DD",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Punter 14 33",
      "email": "[email]",
      "postcode": "8242 DD",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Project",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Huis & Hypotheek Nederland C.O. B.V.",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-01-01"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Nieuw adviestraject",
          "artikel": "Advies Omzetting/Verhoging/Oversluiting",
          "tekendatum": "2020-12-23",
          "productnaam": "Advies Omzetting/Verhoging/Oversluiting",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-12-23"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-12-23"
        },
        {
          "norm": "",
          "type": "Contract",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Uw Hypotheek",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-01-01"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "2020-12-23",
          "productnaam": "",
          "maatschappij": "Uw Hypotheek",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-12-23"
        }
      ],
      "crmdossier_id": "226686",
      "dossiernummer": "226686",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1940

{
  "dossier_id": "a3364919-345b-45f7-9ec0-9f8506b88530",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Baars, Kelly (KM)",
      "adres": "Botter 42 20",
      "email": "[email]",
      "postcode": "8243 JA",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Botter 42 20",
      "email": "[email]",
      "postcode": "8243 JA",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-F13EFAA5-372B-4A34-9742-F65FA32B29CE|1000(1)",
          "passeeringangsdatum": "2020-06-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-F13EFAA5-372B-4A34-9742-F65FA32B29CE|1000(1)",
          "passeeringangsdatum": "2020-06-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": "2770816",
          "passeeringangsdatum": "2020-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": "2770816",
          "passeeringangsdatum": "2020-05-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-04-17"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-04-17"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "252000.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": "3179079-01",
          "passeeringangsdatum": "2020-12-07"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "252000.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": "3179079-01",
          "passeeringangsdatum": "2020-12-07"
        }
      ],
      "crmdossier_id": "210901",
      "dossiernummer": "210901",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1941

{
  "dossier_id": "a3364919-345b-45f7-9ec0-9f8506b88530",
  "key": "base_import",
  "value_json": {
    "adres": "Botter 42 20",
    "klant": "Baars, Kelly (KM)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 JA",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-F13EFAA5-372B-4A34-9742-F65FA32B29CE|1000(1)",
        "passeeringangsdatum": "2020-06-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-F13EFAA5-372B-4A34-9742-F65FA32B29CE|1000(1)",
        "passeeringangsdatum": "2020-06-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": "2770816",
        "passeeringangsdatum": "2020-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": "2770816",
        "passeeringangsdatum": "2020-05-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-04-17"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2020-04-17"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "252000.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": "3179079-01",
        "passeeringangsdatum": "2020-12-07"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "252000.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": "3179079-01",
        "passeeringangsdatum": "2020-12-07"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 8,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "210901",
      "Baars, Kelly (KM)",
      "Botter 42 20",
      "8243 JA",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "ISW-F13EFAA5-372B-4A34-9742-F65FA32B29CE|1000(1)",
      "TAF",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering",
      "2770816",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "Eigen kantoor",
      "Hypotheekadvies",
      "3179079-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": "210901",
    "dossiernummer": "210901",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1942

{
  "dossier_id": "0f44eb28-665d-44e6-aaf4-2f906d34c56c",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Giskes, Henriette (H.S.)",
      "adres": "Schoener 18 10",
      "postcode": "8243 TP",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Schoener 18 10",
      "email": "[email]",
      "postcode": "8243 TP",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "190000.00",
          "status": "Lopend",
          "artikel": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek",
          "tekendatum": "25569",
          "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek",
          "maatschappij": "Munt Hypotheken",
          "productsoort": "Aflossingsvrij",
          "factuurbedrag": "",
          "offertenummer": "1764761",
          "passeeringangsdatum": "2019-08-12"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-05-27"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "232198.00",
          "status": "Gepasseerd",
          "artikel": "Aflossingsvrije hypotheek (Argenta Hypotheek), Annuïteitenhypotheek (Argenta Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Aflossingsvrije hypotheek (Argenta Hypotheek), Annuïteitenhypotheek (Argenta Hypotheek)",
          "maatschappij": "Argenta (via Adaxio)",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "2863639",
          "passeeringangsdatum": "2016-04-04"
        }
      ],
      "crmdossier_id": "121989",
      "dossiernummer": "121989",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1943

{
  "dossier_id": "0f44eb28-665d-44e6-aaf4-2f906d34c56c",
  "key": "base_import",
  "value_json": {
    "adres": "Schoener 18 10",
    "klant": "Giskes, Henriette (H.S.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 TP",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "190000.00",
        "status": "Lopend",
        "artikel": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek",
        "tekendatum": "25569",
        "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek",
        "maatschappij": "Munt Hypotheken",
        "productsoort": "Aflossingsvrij",
        "factuurbedrag": "",
        "offertenummer": "1764761",
        "passeeringangsdatum": "2019-08-12"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-05-27"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "232198.00",
        "status": "Gepasseerd",
        "artikel": "Aflossingsvrije hypotheek (Argenta Hypotheek), Annuïteitenhypotheek (Argenta Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Aflossingsvrije hypotheek (Argenta Hypotheek), Annuïteitenhypotheek (Argenta Hypotheek)",
        "maatschappij": "Argenta (via Adaxio)",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "2863639",
        "passeeringangsdatum": "2016-04-04"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "121989",
      "Giskes, Henriette (H.S.)",
      "Schoener 18 10",
      "8243 TP",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "1764761",
      "Munt Hypotheken",
      "Hypotheek",
      "Munt Aflossingsvrije Hypotheek, Munt Aflossingsvrije Hypotheek",
      "Aflossingsvrij",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2863639",
      "Argenta (via Adaxio)",
      "Aflossingsvrije hypotheek (Argenta Hypotheek), Annuïteitenhypotheek (Argenta Hypotheek)",
      "Aflossingsvrij, Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "121989",
    "dossiernummer": "121989",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": ""
  },
  "updated_at": 1778230486535
}

Rij 1944

{
  "dossier_id": "79e17e2d-7a28-435b-8e7b-ebb3e3a236ee",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Ahmet, Sharona (S.R.)",
      "adres": "Majoraan 43",
      "email": "[email]",
      "postcode": "8252 BD",
      "woonplaats": "DRONTEN",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Majoraan 43",
      "postcode": "8252 BD",
      "woonplaats": "DRONTEN"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Arbeidsongeschiktheidsverzekering",
          "tekendatum": "25569",
          "productnaam": "Arbeidsongeschiktheidsverzekering",
          "maatschappij": "Cardif",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "H102769",
          "passeeringangsdatum": "2015-01-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "16675.00",
          "status": "Lopend",
          "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "maatschappij": "Obvion",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "606548",
          "passeeringangsdatum": "2022-09-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "181078.00",
          "status": "Lopend",
          "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), 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), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "maatschappij": "Obvion",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "606.548",
          "passeeringangsdatum": "2019-08-31"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-05-24"
        },
        {
          "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-08-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": "HL0038355",
          "passeeringangsdatum": "2019-08-31"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "139920.00",
          "status": "Gepasseerd",
          "artikel": "NIBC Extra Annuiteit",
          "tekendatum": "25569",
          "productnaam": "NIBC Extra Annuiteit",
          "maatschappij": "NIBC",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.351.436",
          "passeeringangsdatum": "2015-02-27"
        }
      ],
      "crmdossier_id": "250929",
      "dossiernummer": "250929",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1945

{
  "dossier_id": "ced13c39-437c-433c-b260-8d3d7e8a5c39",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Ellerbroek (J.H.W.)",
      "adres": "De Veurdele 111",
      "email": "[email]",
      "postcode": "7948 DM",
      "woonplaats": "Nijeveen",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Wijnand",
      "adres": "De Veurdele 111",
      "email": "[email]",
      "postcode": "7948 DM",
      "woonplaats": "Nijeveen"
    },
    "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": "2017-01-27"
        }
      ],
      "crmdossier_id": "97277",
      "dossiernummer": "97277",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1946

{
  "dossier_id": "79e17e2d-7a28-435b-8e7b-ebb3e3a236ee",
  "key": "base_import",
  "value_json": {
    "adres": "Majoraan 43",
    "klant": "Ahmet, Sharona (S.R.)",
    "plaats": "DRONTEN",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8252 BD",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Arbeidsongeschiktheidsverzekering",
        "tekendatum": "25569",
        "productnaam": "Arbeidsongeschiktheidsverzekering",
        "maatschappij": "Cardif",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "H102769",
        "passeeringangsdatum": "2015-01-01"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "16675.00",
        "status": "Lopend",
        "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "maatschappij": "Obvion",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "606548",
        "passeeringangsdatum": "2022-09-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "181078.00",
        "status": "Lopend",
        "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), 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), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
        "maatschappij": "Obvion",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "606.548",
        "passeeringangsdatum": "2019-08-31"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-05-24"
      },
      {
        "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-08-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": "HL0038355",
        "passeeringangsdatum": "2019-08-31"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "139920.00",
        "status": "Gepasseerd",
        "artikel": "NIBC Extra Annuiteit",
        "tekendatum": "25569",
        "productnaam": "NIBC Extra Annuiteit",
        "maatschappij": "NIBC",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.351.436",
        "passeeringangsdatum": "2015-02-27"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 7,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "250929",
      "Ahmet, Sharona (S.R.)",
      "Majoraan 43",
      "8252 BD",
      "DRONTEN",
      "[email]",
      "[telefoon]",
      "H102769",
      "Cardif",
      "Inkomensverzekering",
      "Arbeidsongeschiktheidsverzekering",
      "606548",
      "Obvion",
      "Hypotheek",
      "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
      "Annuitair",
      "606.548",
      "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
      "Eigen kantoor",
      "Hypotheekadvies",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
      "HL0038355",
      "Hera Life",
      "Levensverzekering",
      "Scherp & Slim ORV annuïtair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "1.351.436",
      "NIBC",
      "NIBC Extra Annuiteit"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "250929",
    "dossiernummer": "250929",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1947

{
  "dossier_id": "0b602929-e3e0-41b9-bd93-b1a11772cc88",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Zheng, Ming Gan (MG)",
      "adres": "De Deel 19",
      "email": "[email]",
      "postcode": "8256 EL",
      "woonplaats": "Biddinghuizen",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Zheng, Xiao-ju (X)",
      "adres": "De Deel 19",
      "postcode": "8256 EL",
      "woonplaats": "Biddinghuizen"
    },
    "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": "2019-09-06"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "235000.00",
          "status": "Lopend",
          "artikel": "NIBC Annuiteit, NIBC Aflossingsvrij",
          "tekendatum": "25569",
          "productnaam": "NIBC Annuiteit, NIBC Aflossingsvrij",
          "maatschappij": "NIBC",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1788513",
          "passeeringangsdatum": "2019-12-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "ORV Annuitair dalend",
          "tekendatum": "25569",
          "productnaam": "ORV Annuitair dalend",
          "maatschappij": "Reaal schadeverzekeringen",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "1300459709",
          "passeeringangsdatum": "2019-12-01"
        }
      ],
      "crmdossier_id": "200374",
      "dossiernummer": "200374",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1948

{
  "dossier_id": "0b602929-e3e0-41b9-bd93-b1a11772cc88",
  "key": "base_import",
  "value_json": {
    "adres": "De Deel 19",
    "klant": "Zheng, Ming Gan (MG), Zheng, Xiao-ju (X)",
    "plaats": "Biddinghuizen",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8256 EL",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-09-06"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "235000.00",
        "status": "Lopend",
        "artikel": "NIBC Annuiteit, NIBC Aflossingsvrij",
        "tekendatum": "25569",
        "productnaam": "NIBC Annuiteit, NIBC Aflossingsvrij",
        "maatschappij": "NIBC",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1788513",
        "passeeringangsdatum": "2019-12-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "ORV Annuitair dalend",
        "tekendatum": "25569",
        "productnaam": "ORV Annuitair dalend",
        "maatschappij": "Reaal schadeverzekeringen",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "1300459709",
        "passeeringangsdatum": "2019-12-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "200374",
      "Zheng, Ming Gan (MG), Zheng, Xiao-ju (X)",
      "De Deel 19",
      "8256 EL",
      "Biddinghuizen",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "1788513",
      "NIBC",
      "Hypotheek",
      "NIBC Annuiteit, NIBC Aflossingsvrij",
      "Aflossingsvrij, Annuitair",
      "1300459709",
      "Reaal schadeverzekeringen",
      "Levensverzekering",
      "ORV Annuitair dalend",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "200374",
    "dossiernummer": "200374",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1949

{
  "dossier_id": "56c804de-4c8e-42dd-b7ef-02c6094e9f65",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Poel, Ralf van der (R)",
      "adres": "Rozengaard 18 7",
      "email": "[email]",
      "postcode": "8212 DP",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Rozengaard 18 7",
      "postcode": "8212 DP",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "2840037",
          "passeeringangsdatum": "2021-05-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "266387.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": "1779823",
          "passeeringangsdatum": "2019-09-13"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "161600.00",
          "status": "Gepasseerd",
          "artikel": "Merius annuiteitenhypotheek, Merius annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Merius annuiteitenhypotheek, Merius annuiteitenhypotheek",
          "maatschappij": "Merius Hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3003674",
          "passeeringangsdatum": "2017-11-21"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-07-27"
        },
        {
          "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": "2456938",
          "passeeringangsdatum": "2017-09-01"
        }
      ],
      "crmdossier_id": "155098",
      "dossiernummer": "155098",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1950

{
  "dossier_id": "56c804de-4c8e-42dd-b7ef-02c6094e9f65",
  "key": "base_import",
  "value_json": {
    "adres": "Rozengaard 18 7",
    "klant": "Poel, Ralf van der (R)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8212 DP",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Offerte/renteaanbod ontvangen",
        "artikel": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
        "tekendatum": "25569",
        "productnaam": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "2840037",
        "passeeringangsdatum": "2021-05-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "266387.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": "1779823",
        "passeeringangsdatum": "2019-09-13"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "161600.00",
        "status": "Gepasseerd",
        "artikel": "Merius annuiteitenhypotheek, Merius annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Merius annuiteitenhypotheek, Merius annuiteitenhypotheek",
        "maatschappij": "Merius Hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3003674",
        "passeeringangsdatum": "2017-11-21"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-07-27"
      },
      {
        "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": "2456938",
        "passeeringangsdatum": "2017-09-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "155098",
      "Poel, Ralf van der (R)",
      "Rozengaard 18 7",
      "8212 DP",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "2840037",
      "TAF",
      "Levensverzekering",
      "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
      "Annuitair Dalende Risicoverzekeringen",
      "1779823",
      "Lloyds Bank",
      "Hypotheek",
      "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
      "Annuitair",
      "3003674",
      "Merius Hypotheken",
      "Merius annuiteitenhypotheek, Merius annuiteitenhypotheek",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2456938",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "155098",
    "dossiernummer": "155098",
    "dossierstatus": "Actief",
    "email_partner": "",
    "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)