Controlpanel / Database

Database Explorer

Read-only SQL/JSON werkbank. Open een databron, kies een tabel, zoek in echte rijen en inspecteer data als ruwe JSON. Geen vrije SQL, geen writes, geen export.

6 bronnen73 tabellen/stores299.864 rijen/items22 domeincontainers

Zoeken

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

Rijen: postgres-main.dossier_data

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

Read-only query

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

50 matchende rijen · offset 1150 · limiet 50Vorige Volgende

dossier_id	key	value_json	updated_at
d06b3bcf-43f9-4577-985f-6781e3bba4bd	inventarisatie	{ "a1": { "naam": "Schelling, Anoushka (A.S.)", "adres": "J. Kammingastraat 115", "email": "[email]", "postcode": "9648 KL", "woonplaats": "Wildervank", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Schelling, Zobraakanya (ZIS)", "adres": "J. Kammingastraat 115", "postcode": "9648 KL", "woonplaats": "Wildervank" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "maatschappij": "TAF", "productsoort": "Overlijdensrisicoverzekering", "factuurbedrag": "", "offertenummer": "2605308", "passeeringangsdatum": "2018-01-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passe ... [afgekapt: 1220 tekens]	1778230486535
23b9f391-bfde-427a-9d45-880b890808f4	base_import	{ "adres": "Horst 26 69", "klant": "Borren, Frederik van (FJPL)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8225 PA", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "123718.00", "status": "Gepasseerd", "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)", "tekendatum": "25569", "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)", "maatschappij": "Argenta hypotheken", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3046255-01", "passeeringangsdatum": "2018-02-16" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "30200.00", "status": "Gepasseerd", "artikel": "Starterslening", "tekendatum": "25569", "productnaam": "Starterslening", "maatschappij": "SVn", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "240.830.000", "passeeringangsdatum": "2018-02-16" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedra ... [afgekapt: 1423 tekens]	1778230486535
22dcf243-cf76-4aa1-b1ab-42cc021e454a	base_import	{ "adres": "Kempenaar 20 45", "klant": "Blinova, Alla (NS), Smit, Peter (PTA)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8231 GA", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "166806.00", "status": "Gepasseerd", "artikel": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)", "tekendatum": "25569", "productnaam": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)", "maatschappij": "Allianz", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3055964", "passeeringangsdatum": "2018-05-07" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-03-03" }, { "norm": "", "type": "Consumptief krediet", "inhoud": "0.00", "status": "Lopend", "artikel": "In ... [afgekapt: 1254 tekens]	1778230486535
7f0b1780-e6d6-41af-b6ce-0b9e323ff598	inventarisatie	{ "a1": { "naam": "Soto Toppers, Raul (R)", "adres": "De Heraut 22", "email": "[email]", "postcode": "8255 EA", "woonplaats": "Swifterbant", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "De Heraut 22", "postcode": "8255 EA", "woonplaats": "Swifterbant" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "143000.00", "status": "Gepasseerd", "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)", "tekendatum": "25569", "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)", "maatschappij": "ASN (voorheen BLG Wonen)", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "10294729", "passeeringangsdatum": "2018-12-13" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-09-13" }, { "norm": "Geldverstrekker", "type": "Hypotheek" ... [afgekapt: 1082 tekens]	1778230486535
23b9f391-bfde-427a-9d45-880b890808f4	inventarisatie	{ "a1": { "naam": "Borren, Frederik van (FJPL)", "adres": "Horst 26 69", "email": "[email]", "postcode": "8225 PA", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Horst 26 69", "postcode": "8225 PA", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "123718.00", "status": "Gepasseerd", "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)", "tekendatum": "25569", "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)", "maatschappij": "Argenta hypotheken", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3046255-01", "passeeringangsdatum": "2018-02-16" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "30200.00", "status": "Gepasseerd", "artikel": "Starterslening", "tekendatum": "25569", "productnaam": "Starterslening", "maatschappij": "SVn", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "240.830.000", "passeeringangsdatum": "2018-02-16" }, { "norm" ... [afgekapt: 968 tekens]	1778230486535
9373c46f-8666-4e3e-8265-c84dde4f27fd	base_import	{ "adres": "Punter 48 19", "klant": "Kuijk, Mario van (M.L.P.A.), Valente Damasceno, Francilene (F.D.N.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 GJ", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-01-15" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "200000.00", "status": "Gepasseerd", "artikel": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)", "tekendatum": "25569", "productnaam": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)", "maatschappij": "Rabobank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "4002.885.618", "passeeringangsdatum": "2018-05-16" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair", "tekendatum": ... [afgekapt: 1237 tekens]	1778230486535
9373c46f-8666-4e3e-8265-c84dde4f27fd	inventarisatie	{ "a1": { "naam": "Kuijk, Mario van (M.L.P.A.)", "adres": "Punter 48 19", "email": "[email]", "postcode": "8242 GJ", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Valente Damasceno, Francilene (F.D.N.)", "adres": "Punter 48 19", "postcode": "8242 GJ", "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": "2018-01-15" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "200000.00", "status": "Gepasseerd", "artikel": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)", "tekendatum": "25569", "productnaam": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)", "maatschappij": "Rabobank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "4 ... [afgekapt: 705 tekens]	1778230486535
b5d3e102-f4d0-4512-8bfb-1130443ae8ff	base_import	{ "adres": "Kogge 05 8", "klant": "Straka, Marian (M), Straková, Veronika (V)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 AS", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "maatschappij": "TAF", "productsoort": "Overlijdensrisicoverzekering", "factuurbedrag": "", "offertenummer": "2613587", "passeeringangsdatum": "2018-03-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "167000.00", "status": "Gepasseerd", "artikel": "Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1.662.243", "passeeringangsdatum": "2018-03-28" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "m ... [afgekapt: 1008 tekens]	1778230486535
b5d3e102-f4d0-4512-8bfb-1130443ae8ff	inventarisatie	{ "a1": { "naam": "Straka, Marian (M)", "adres": "Kogge 05 8", "email": "[email]", "postcode": "8242 AS", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Straková, Veronika (V)", "adres": "Kogge 05 8", "postcode": "8242 AS", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "maatschappij": "TAF", "productsoort": "Overlijdensrisicoverzekering", "factuurbedrag": "", "offertenummer": "2613587", "passeeringangsdatum": "2018-03-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "167000.00", "status": "Gepasseerd", "artikel": "Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": ... [afgekapt: 566 tekens]	1778230486535
22dcf243-cf76-4aa1-b1ab-42cc021e454a	inventarisatie	{ "a1": { "naam": "Blinova, Alla (NS)", "adres": "Kempenaar 20 45", "email": "[email]", "postcode": "8231 GA", "woonplaats": "Lelystad", "telefoon_prive": "06465251227" }, "a2": { "naam": "Smit, Peter (PTA)", "adres": "Kempenaar 20 45", "email": "[email]", "postcode": "8231 GA", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "166806.00", "status": "Gepasseerd", "artikel": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)", "tekendatum": "25569", "productnaam": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)", "maatschappij": "Allianz", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3055964", "passeeringangsdatum": "2018-05-07" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatsch ... [afgekapt: 744 tekens]	1778230486535
6b5c8381-8c98-4a1b-a1a2-3744000277ce	base_import	{ "adres": "Punter 48 48", "klant": "Schroder (G.M.), Schroder (R.P.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 GL", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "105053.00", "status": "Offerte aangevraagd", "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek", "tekendatum": "25569", "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek", "maatschappij": "IQWOON", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "ISW-42D250AA-CAC2-49C5-8CCE-CD53DD8BF61E(1)", "passeeringangsdatum": "2023-05-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "105053.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": "3377363-01", "passeeringangsdatum": "2023-05-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "105053.00", "s ... [afgekapt: 1240 tekens]	1778230486535
6b5c8381-8c98-4a1b-a1a2-3744000277ce	inventarisatie	{ "a1": { "naam": "Schroder (G.M.)", "adres": "Punter 48 48", "email": "[email]", "postcode": "8242 GL", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Schroder (R.P.)", "adres": "Punter 48 48", "postcode": "8242 GL", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "105053.00", "status": "Offerte aangevraagd", "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek", "tekendatum": "25569", "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek", "maatschappij": "IQWOON", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "ISW-42D250AA-CAC2-49C5-8CCE-CD53DD8BF61E(1)", "passeeringangsdatum": "2023-05-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "105053.00", "status": "Lopend", "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek", "tekendatum": "25569", "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek", "maatschappij": "IQWOON" ... [afgekapt: 865 tekens]	1778230486535
a7593b4c-4d5f-40ba-9358-2a7de90d19c5	base_import	{ "adres": "Schermer 115", "klant": "Brian, Danny (D), Korzelius, Jenny (J)", "plaats": "LELYSTAD", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8244 AM", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "140000.00", "status": "Gepasseerd", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2018-05-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-03-07" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair", ... [afgekapt: 1074 tekens]	1778230486535
a7593b4c-4d5f-40ba-9358-2a7de90d19c5	inventarisatie	{ "a1": { "naam": "Brian, Danny (D)", "adres": "Schermer 115", "email": "[email]", "postcode": "8244 AM", "woonplaats": "LELYSTAD", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Korzelius, Jenny (J)", "adres": "Schermer 115", "email": "[email]", "postcode": "8244 AM", "woonplaats": "LELYSTAD" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "140000.00", "status": "Gepasseerd", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2018-05-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-03-07" }, { "norm": " ... [afgekapt: 629 tekens]	1778230486535
d2fa3d03-7c81-49da-ab7c-c15ac6e90f45	base_import	{ "adres": "Fjord 53", "klant": "Soy, Erdem (E)", "plaats": "LELYSTAD", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8224 DC", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2022-08-31" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "113898.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2021-06-28" }, { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand", "tekendatum": "2556 ... [afgekapt: 1405 tekens]	1778230486535
d2fa3d03-7c81-49da-ab7c-c15ac6e90f45	inventarisatie	{ "a1": { "naam": "Soy, Erdem (E)", "adres": "Fjord 53", "email": "[email]", "postcode": "8224 DC", "woonplaats": "LELYSTAD", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Fjord 53", "postcode": "8224 DC", "woonplaats": "LELYSTAD" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2022-08-31" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "113898.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2021-06-28" }, { ... [afgekapt: 799 tekens]	1778230486535
94808149-bf11-4ec5-b09a-3e8b1afed102	base_import	{ "adres": "Kamp 26 60", "klant": "Stevens (J), Visser (D.)", "plaats": "LELYSTAD", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8225 EJ", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "184335.00", "status": "Gepasseerd", "artikel": "Annuïteiten hypotheek (Allianz Hypotheek), Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)", "tekendatum": "25569", "productnaam": "Annuïteiten hypotheek (Allianz Hypotheek), Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)", "maatschappij": "Allianz", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3057614-01", "passeeringangsdatum": "2018-05-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-03-08" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life Interna ... [afgekapt: 1325 tekens]	1778230486535
94808149-bf11-4ec5-b09a-3e8b1afed102	inventarisatie	{ "a1": { "naam": "Stevens (J)", "adres": "Kamp 26 60", "email": "[email]", "postcode": "8225 EJ", "woonplaats": "LELYSTAD", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Visser (D.)", "adres": "Kamp 26 60", "email": "[email]", "postcode": "8225 EJ", "woonplaats": "LELYSTAD" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "184335.00", "status": "Gepasseerd", "artikel": "Annuïteiten hypotheek (Allianz Hypotheek), Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)", "tekendatum": "25569", "productnaam": "Annuïteiten hypotheek (Allianz Hypotheek), Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)", "maatschappij": "Allianz", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3057614-01", "passeeringangsdatum": "2018-05-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoo ... [afgekapt: 793 tekens]	1778230486535
7f0b1780-e6d6-41af-b6ce-0b9e323ff598	base_import	{ "adres": "De Heraut 22", "klant": "Soto Toppers, Raul (R)", "plaats": "Swifterbant", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8255 EA", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "143000.00", "status": "Gepasseerd", "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)", "tekendatum": "25569", "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)", "maatschappij": "ASN (voorheen BLG Wonen)", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "10294729", "passeeringangsdatum": "2018-12-13" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-09-13" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "51617.00", "status": "Beeindigd", "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)", "tekendatum": "25569", "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)", "maatschappij": "ASN (voorheen BLG Wonen)" ... [afgekapt: 1524 tekens]	1778230486535
9284d523-95cb-4791-ae51-493ed0a75f51	base_import	{ "adres": "Botter 11 02", "klant": "Abadi (M.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8232 JL", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "156847.00", "status": "Gepasseerd", "artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Aflossingsvrij, Bankspaar", "factuurbedrag": "", "offertenummer": "Z 090-859858", "passeeringangsdatum": "2010-10-25" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "100639", "Abadi (M.)", "Botter 11 02", "8232 JL", "Lelystad", "[email]", "06 - 81 63 40 37", "Z 090-859858", "ING Bank", "Hypotheek", "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)", "Aflossingsvrij, Bankspaar" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producte ... [afgekapt: 156 tekens]	1778230486535
da3a52d9-8459-4a75-9d69-4306cd572b35	base_import	{ "adres": "De Schans 10 67", "klant": "Chehaita, Mohamad (M)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8231 KG", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-10-02" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "34600.00", "status": "Gepasseerd", "artikel": "Starterslening", "tekendatum": "25569", "productnaam": "Starterslening", "maatschappij": "SVn", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "243.109.000", "passeeringangsdatum": "2018-11-30" }, { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "Aansprakelijkheidsverzekering Particulieren, Woonhuisverzekering, Inboedelverzekering", "tekendatum": "25569", "productnaam": "Aansprakelijkheidsverzekering Particulieren, Woonhuisverzekering, Inboedelverzekering", "maatschappij": "Voogd & Voogd ... [afgekapt: 2829 tekens]	1778230486535
da3a52d9-8459-4a75-9d69-4306cd572b35	inventarisatie	{ "a1": { "naam": "Chehaita, Mohamad (M)", "adres": "De Schans 10 67", "email": "[email]", "postcode": "8231 KG", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "De Schans 10 67", "postcode": "8231 KG", "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": "2018-10-02" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "34600.00", "status": "Gepasseerd", "artikel": "Starterslening", "tekendatum": "25569", "productnaam": "Starterslening", "maatschappij": "SVn", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "243.109.000", "passeeringangsdatum": "2018-11-30" }, { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artike ... [afgekapt: 2114 tekens]	1778230486535
be435c65-d804-4567-adbb-9f8360db9ed6	base_import	{ "adres": "Tjalk 13 11", "klant": "Domagala, Maciej (M)", "plaats": "LELYSTAD", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8232 KH", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "165000.00", "status": "Lopend", "artikel": "IQWOON Annuïteitenhypotheek", "tekendatum": "25569", "productnaam": "IQWOON Annuïteitenhypotheek", "maatschappij": "IQWOON", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3097480-01", "passeeringangsdatum": "2018-12-28" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-11-15" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "182292", "Domagala, Maciej (M)", "Tjalk 13 11", "8232 KH", "LELYSTAD", "[email]", "[telefoon]", "3097480-01", "IQWOON", "Hypotheek", "IQWOON Annuïteitenhypotheek", "Annuitair", "Eigen kantoor", "Hypotheek ... [afgekapt: 277 tekens]	1778230486535
be435c65-d804-4567-adbb-9f8360db9ed6	inventarisatie	{ "a1": { "naam": "Domagala, Maciej (M)", "adres": "Tjalk 13 11", "email": "[email]", "postcode": "8232 KH", "woonplaats": "LELYSTAD", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Tjalk 13 11", "postcode": "8232 KH", "woonplaats": "LELYSTAD" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "165000.00", "status": "Lopend", "artikel": "IQWOON Annuïteitenhypotheek", "tekendatum": "25569", "productnaam": "IQWOON Annuïteitenhypotheek", "maatschappij": "IQWOON", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3097480-01", "passeeringangsdatum": "2018-12-28" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-11-15" } ], "crmdossier_id": "182292", "dossiernummer": "182292", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
ad9581cd-c7a1-4632-84f9-ce2f53793fb8	inventarisatie	{ "a1": { "naam": "Ham, Nick (N.L.)", "adres": "Admiraal De Ruijterweg 4742", "email": "[email]", "postcode": "1055 NH", "woonplaats": "Amsterdam", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Kothen, Kimberley vom (K.K.)", "adres": "Admiraal De Ruijterweg 4742", "email": "[email]", "postcode": "1055 NH", "woonplaats": "Amsterdam" }, "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": "2018-11-15" } ], "crmdossier_id": "176501", "dossiernummer": "176501", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
635fbd25-6708-432a-a5ee-776707645da8	base_import	{ "adres": "Vogelwikke 18", "klant": "Bakker, Marcel (M), Wijers, Marieke (M)", "plaats": "Swifterbant", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8255 KG", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-11-14" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair", "tekendatum": "25569", "productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair", "maatschappij": "Credit Life", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "7001174480", "passeeringangsdatum": "2019-03-18" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "170687.00", "status": "Lopend", "artikel": "NIBC Annuiteit, NIBC Annuiteit, NIBC Annuiteit", "tekendatum": "25569", "productnaam": "NIBC Annuiteit, NIBC Annuiteit, NIBC Annuiteit", ... [afgekapt: 1063 tekens]	1778230486535
e575b75b-114a-4eca-b5d2-aa14dee49ca0	inventarisatie	{ "a1": { "naam": "Colenberg, Tim (T)", "adres": "Schoener 17 16", "email": "[email]", "postcode": "8243 TN", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Klijnsma, Trudy (T)", "adres": "Schoener 17 16", "postcode": "8243 TN", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "264500.00", "status": "Gepasseerd", "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)", "tekendatum": "25569", "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)", "maatschappij": "ABN AMRO", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "700.323.883", "passeeringangsdatum": "2016-01-29" } ], "crmdossier_id": "115987", "dossiernummer": "115987", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
95d2a6ba-7200-4dc3-afe0-fd413fb58e5a	base_import	{ "adres": "Schermer 40", "klant": "Bohemen, Sandra van (S), Boom, Leon (L)", "plaats": "LELYSTAD", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8244 AN", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "45171.00", "status": "Renteaanbod aan klant verzonden", "artikel": "Aegon Annuïteitenhypotheek (Aegon Annuïteitenhypotheek)", "tekendatum": "25569", "productnaam": "Aegon Annuïteitenhypotheek (Aegon Annuïteitenhypotheek)", "maatschappij": "AEGON", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1405801", "passeeringangsdatum": "2023-07-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "163268.00", "status": "Lopend", "artikel": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)", "tekendatum": "25569", "productnaam": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)", "maatschappij": "AEGON", "productsoort": "Aflossingsvrij, Annuitair ... [afgekapt: 3065 tekens]	1778230486535
95d2a6ba-7200-4dc3-afe0-fd413fb58e5a	inventarisatie	{ "a1": { "naam": "Bohemen, Sandra van (S)", "adres": "Schermer 40", "email": "[email]", "postcode": "8244 AN", "woonplaats": "LELYSTAD", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Boom, Leon (L)", "adres": "Schermer 40", "postcode": "8244 AN", "woonplaats": "LELYSTAD" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "45171.00", "status": "Renteaanbod aan klant verzonden", "artikel": "Aegon Annuïteitenhypotheek (Aegon Annuïteitenhypotheek)", "tekendatum": "25569", "productnaam": "Aegon Annuïteitenhypotheek (Aegon Annuïteitenhypotheek)", "maatschappij": "AEGON", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1405801", "passeeringangsdatum": "2023-07-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "163268.00", "status": "Lopend", "artikel": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)", "tekendatum": "25569", "productnaam": "Aegon Aflossingsv ... [afgekapt: 2257 tekens]	1778230486535
009b5118-80f0-4b2a-a476-6224e9099fd9	base_import	{ "adres": "Stadseiland 100", "klant": "Graaf, Sylvia van der (S), Jong, Peter de (P)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 HV", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "253966.00", "status": "Lopend", "artikel": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek", "maatschappij": "Merius Hypotheken", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3013205", "passeeringangsdatum": "2019-09-18" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-07-11" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair", "tekendatum": "25569", "productnaam": "Credit Life Overlijdensris ... [afgekapt: 1154 tekens]	1778230486535
e575b75b-114a-4eca-b5d2-aa14dee49ca0	base_import	{ "adres": "Schoener 17 16", "klant": "Colenberg, Tim (T), Klijnsma, Trudy (T)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 TN", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "264500.00", "status": "Gepasseerd", "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)", "tekendatum": "25569", "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)", "maatschappij": "ABN AMRO", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "700.323.883", "passeeringangsdatum": "2016-01-29" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "115987", "Colenberg, Tim (T), Klijnsma, Trudy (T)", "Schoener 17 16", "8243 TN", "Lelystad", "[email]", "[telefoon]", "700.323.883", "ABN AMRO", "Hypotheek", "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)", "Annuitair" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "115987", "dossiernummer": "115987", "dossierstatus": "Actief", "email_partner" ... [afgekapt: 34 tekens]	1778230486535
ad9581cd-c7a1-4632-84f9-ce2f53793fb8	base_import	{ "adres": "Admiraal De Ruijterweg 4742", "klant": "Ham, Nick (N.L.), Kothen, Kimberley vom (K.K.)", "plaats": "Amsterdam", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "1055 NH", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-11-15" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "176501", "Ham, Nick (N.L.), Kothen, Kimberley vom (K.K.)", "Admiraal De Ruijterweg 4742", "1055 NH", "Amsterdam", "[email]", "[email]", "[telefoon]", "Eigen kantoor", "Hypotheekadvies" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "176501", "dossiernummer": "176501", "dossierstatus": "Actief", "email_partner": "[email]", "telefoonnummer": "[telefoon]", "email_aanvrager": "[email]" }	1778230486535
a78b9b62-9c74-4ebb-be0e-dc6f9b306acc	inventarisatie	{ "a1": { "naam": "Sterken (A.)", "adres": "Rijnland 317", "email": "[email]", "postcode": "8245 EE", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Swagerman, Melis (M.)", "adres": "Rijnland 317", "postcode": "8245 EE", "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": "2018-11-23" } ], "crmdossier_id": "181851", "dossiernummer": "181851", "dossierstatus": "Geroyeerd", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
dd52c178-e610-403c-b03e-cb17087ba80f	base_import	{ "adres": "Kamp 14 5", "klant": "Lichwa, Marcin", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8225 GD", "products": [ { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "Aansprakelijkheidsverzekering Particulieren, Inboedelverzekering, Rechtsbijstand voor Particulieren, Woonhuisverzekering", "tekendatum": "25569", "productnaam": "Aansprakelijkheidsverzekering Particulieren, Inboedelverzekering, Rechtsbijstand voor Particulieren, Woonhuisverzekering", "maatschappij": "Voogd & Voogd", "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand", "factuurbedrag": "", "offertenummer": "177301625385", "passeeringangsdatum": "2018-09-04" }, { "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": "2642869", "passeeringangsdatum": "2018-07-0 ... [afgekapt: 2582 tekens]	1778230486535
dd52c178-e610-403c-b03e-cb17087ba80f	inventarisatie	{ "a1": { "naam": "Lichwa, Marcin", "adres": "Kamp 14 5", "email": "[email]", "postcode": "8225 GD", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Kamp 14 5", "postcode": "8225 GD", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "Aansprakelijkheidsverzekering Particulieren, Inboedelverzekering, Rechtsbijstand voor Particulieren, Woonhuisverzekering", "tekendatum": "25569", "productnaam": "Aansprakelijkheidsverzekering Particulieren, Inboedelverzekering, Rechtsbijstand voor Particulieren, Woonhuisverzekering", "maatschappij": "Voogd & Voogd", "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand", "factuurbedrag": "", "offertenummer": "177301625385", "passeeringangsdatum": "2018-09-04" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", "productnaam": "Credit Life In ... [afgekapt: 1824 tekens]	1778230486535
fd8dd676-5815-4108-8f3c-aa944d733597	base_import	{ "adres": "Tjalk 34 01", "klant": "Kuiper (H.W.), Zouw, van der (J.E.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8232 LV", "products": [ { "norm": "", "type": "Verkoopdienst", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen makelaardij", "productsoort": "", "factuurbedrag": "3650.00", "offertenummer": "", "passeeringangsdatum": "2019-01-17" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "177083", "Kuiper (H.W.), Zouw, van der (J.E.)", "Tjalk 34 01", "8232 LV", "Lelystad", "[email]", "[telefoon]", "Eigen makelaardij", "Verkoopdienst" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "177083", "dossiernummer": "177083", "dossierstatus": "Vervallen", "email_partner": "", "telefoonnummer": "[telefoon]", "email_aanvrager": "[email]" }	1778230486535
fd8dd676-5815-4108-8f3c-aa944d733597	inventarisatie	{ "a1": { "naam": "Kuiper (H.W.)", "adres": "Tjalk 34 01", "email": "[email]", "postcode": "8232 LV", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Zouw, van der (J.E.)", "adres": "Tjalk 34 01", "postcode": "8232 LV", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Verkoopdienst", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen makelaardij", "productsoort": "", "factuurbedrag": "3650.00", "offertenummer": "", "passeeringangsdatum": "2019-01-17" } ], "crmdossier_id": "177083", "dossiernummer": "177083", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
c7ac99b3-70f8-45da-99f3-3acd3fb730b7	base_import	{ "adres": "Merelstraat 5", "klant": "Kaupaite, Egle (E)", "plaats": "Alblasserdam", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "2953 EK", "products": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Offerte aangevraagd", "artikel": "TAF Woonlasten beschermer", "tekendatum": "25569", "productnaam": "TAF Woonlasten beschermer", "maatschappij": "TAF", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "ISW-77C43218-466B-4D3A-BB54-6981653BD6B8\|826(1)", "passeeringangsdatum": "2018-12-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Offerte aangevraagd", "artikel": "TAF Woonlasten beschermer", "tekendatum": "25569", "productnaam": "TAF Woonlasten beschermer", "maatschappij": "TAF", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "ISW-77C43218-466B-4D3A-BB54-6981653BD6B8\|826(1)", "passeeringangsdatum": "2018-12-01" }, { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand", "teke ... [afgekapt: 2512 tekens]	1778230486535
c7ac99b3-70f8-45da-99f3-3acd3fb730b7	inventarisatie	{ "a1": { "naam": "Kaupaite, Egle (E)", "adres": "Merelstraat 5", "email": "[email]", "postcode": "2953 EK", "woonplaats": "Alblasserdam", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Merelstraat 5", "email": "[email]", "postcode": "2953 EK", "woonplaats": "Alblasserdam" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Offerte aangevraagd", "artikel": "TAF Woonlasten beschermer", "tekendatum": "25569", "productnaam": "TAF Woonlasten beschermer", "maatschappij": "TAF", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "ISW-77C43218-466B-4D3A-BB54-6981653BD6B8\|826(1)", "passeeringangsdatum": "2018-12-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Offerte aangevraagd", "artikel": "TAF Woonlasten beschermer", "tekendatum": "25569", "productnaam": "TAF Woonlasten beschermer", "maatschappij": "TAF", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "ISW-77C43218-466B-4D3 ... [afgekapt: 2092 tekens]	1778230486535
662f7117-39fa-4b8c-b667-d88f956af149	inventarisatie	{ "a1": { "naam": "Frysztacki (D.A.)", "adres": "Schoener 35 24", "email": "[email]", "postcode": "8243 WJ", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Grzesik (A.A.)", "adres": "Schoener 35 24", "postcode": "8243 WJ", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Annuitair Dalende Risicoverzekering", "tekendatum": "25569", "productnaam": "Annuitair Dalende Risicoverzekering", "maatschappij": "Cardif", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "O43402", "passeeringangsdatum": "2012-04-01" } ], "crmdossier_id": "99892", "dossiernummer": "99892", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
662f7117-39fa-4b8c-b667-d88f956af149	base_import	{ "adres": "Schoener 35 24", "klant": "Frysztacki (D.A.), Grzesik (A.A.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 WJ", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Annuitair Dalende Risicoverzekering", "tekendatum": "25569", "productnaam": "Annuitair Dalende Risicoverzekering", "maatschappij": "Cardif", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "O43402", "passeeringangsdatum": "2012-04-01" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "99892", "Frysztacki (D.A.), Grzesik (A.A.)", "Schoener 35 24", "8243 WJ", "Lelystad", "[email]", "[telefoon]", "O43402", "Cardif", "Levensverzekering", "Annuitair Dalende Risicoverzekering", "Annuitair Dalende Risicoverzekeringen" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "99892", "dossiernummer": "99892", "dossierstatus": "Vervallen", "email_partner": "[email]", "telefoonnummer": "[telefoon]", "email_aanvrager": "[email]" }	1778230486535
635fbd25-6708-432a-a5ee-776707645da8	inventarisatie	{ "a1": { "naam": "Bakker, Marcel (M)", "adres": "Vogelwikke 18", "email": "[email]", "postcode": "8255 KG", "woonplaats": "Swifterbant", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Wijers, Marieke (M)", "adres": "Vogelwikke 18", "email": "[email]", "postcode": "8255 KG", "woonplaats": "Swifterbant" }, "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": "2018-11-14" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair", "tekendatum": "25569", "productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair", "maatschappij": "Credit Life", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "7001174480", "passeeringangsdatum": "2 ... [afgekapt: 619 tekens]	1778230486535
e5f43fa5-f85c-40d8-8b34-2ff0aa5655e9	base_import	{ "adres": "Bastion 155", "klant": "Ratola De Almeida, Eduardo (E.S. )", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8223 GM", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "127500.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": "595100", "passeeringangsdatum": "2018-12-07" }, { "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": "2667793", "passeeringangsdatum": "2018-11-01" }, { "norm": "", "type": "Hypotheekadv ... [afgekapt: 3765 tekens]	1778230486535
e5f43fa5-f85c-40d8-8b34-2ff0aa5655e9	inventarisatie	{ "a1": { "naam": "Ratola De Almeida, Eduardo (E.S. )", "adres": "Bastion 155", "email": "[email]", "postcode": "8223 GM", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Bastion 155", "postcode": "8223 GM", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "127500.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": "595100", "passeeringangsdatum": "2018-12-07" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair", ... [afgekapt: 2797 tekens]	1778230486535
94d1dd7b-27a3-49ea-b52b-677083b6f276	base_import	{ "adres": "Plantage 165", "klant": "Cicek (S.), Uslu, Asiye (A.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8212 VK", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "ORV Annuitair dalend", "tekendatum": "25569", "productnaam": "ORV Annuitair dalend", "maatschappij": "Reaal schadeverzekeringen", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "1300292787", "passeeringangsdatum": "2018-07-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "170000.00", "status": "Lopend", "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)", "tekendatum": "25569", "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)", "maatschappij": "Argenta hypotheken", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3062055-01", "passeeringangsdatum": "2018-10-25" } ], "dee ... [afgekapt: 905 tekens]	1778230486535
94d1dd7b-27a3-49ea-b52b-677083b6f276	inventarisatie	{ "a1": { "naam": "Cicek (S.)", "adres": "Plantage 165", "email": "[email]", "postcode": "8212 VK", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Uslu, Asiye (A.)", "adres": "Plantage 165", "postcode": "8212 VK", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "ORV Annuitair dalend", "tekendatum": "25569", "productnaam": "ORV Annuitair dalend", "maatschappij": "Reaal schadeverzekeringen", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "1300292787", "passeeringangsdatum": "2018-07-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "170000.00", "status": "Lopend", "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)", "tekendatum": "25569", "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), ... [afgekapt: 370 tekens]	1778230486535
9c787c05-9b00-4133-b13f-ea8ad3c28f4e	base_import	{ "adres": "Archipel 16 32", "klant": "Niemoller, Paul (P)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8224 GH", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "194213.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": "2442618", "passeeringangsdatum": "2013-04-26" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "95877", "Niemoller, Paul (P)", "Archipel 16 32", "8224 GH", "Lelystad", "[email]", "[email]", "[telefoon]", "2442618", "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": "95877", "dossiernummer": "95877", "dossierstatus": "Actief", "email_partner": "[email]", "telefoonnummer": "[telefoon]", "email_aanvrager": "[email]" }	1778230486535
e9b6143b-e266-4ccb-b4a7-3b97821ce9cf	inventarisatie	{ "a1": { "naam": "Broekhuis (E.J.F.)", "adres": "Langezand 59", "postcode": "8223 WE", "woonplaats": "Lelystad" }, "a2": { "naam": "Kemmer (D.B.)", "adres": "Langezand 59", "postcode": "8223 WE", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Consumptief krediet", "inhoud": "0.00", "status": "Lopend", "artikel": "DK", "tekendatum": "25569", "productnaam": "DK", "maatschappij": "Voordeelbank B.V.", "productsoort": "Doorlopend krediet", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2010-12-06" } ], "crmdossier_id": "150656", "dossiernummer": "150656", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } }	1778230486535
c54ffe5e-6127-4da0-ac1f-d7e75ef10d99	base_import	{ "adres": "Wold 24 02", "klant": "Zielonka (M.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8225 BE", "products": [ { "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": "2017-03-14" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "167912", "Zielonka (M.)", "Wold 24 02", "8225 BE", "Lelystad", "[email]", "[telefoon]", "*******", "InterBank NV", "Consumptief krediet", "Interbank Doorlopend Krediet", "Doorlopend krediet" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "167912", "dossiernummer": "167912", "dossierstatus": "Actief", "email_partner": "", "telefoonnummer": "[telefoon]", "email_aanvrager": "[email]" }	1778230486535
c54ffe5e-6127-4da0-ac1f-d7e75ef10d99	inventarisatie	{ "a1": { "naam": "Zielonka (M.)", "adres": "Wold 24 02", "email": "[email]", "postcode": "8225 BE", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Wold 24 02", "postcode": "8225 BE", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "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": "2017-03-14" } ], "crmdossier_id": "167912", "dossiernummer": "167912", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } }	1778230486535

Raw JSON details

Rij 1151

{
  "dossier_id": "d06b3bcf-43f9-4577-985f-6781e3bba4bd",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Schelling, Anoushka (A.S.)",
      "adres": "J. Kammingastraat 115",
      "email": "[email]",
      "postcode": "9648 KL",
      "woonplaats": "Wildervank",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Schelling, Zobraakanya (ZIS)",
      "adres": "J. Kammingastraat 115",
      "postcode": "9648 KL",
      "woonplaats": "Wildervank"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2605308",
          "passeeringangsdatum": "2018-01-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-12-19"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Woonhuisverzekering, Aansprakelijkheidsverzekering Particulieren",
          "tekendatum": "25569",
          "productnaam": "Woonhuisverzekering, Aansprakelijkheidsverzekering Particulieren",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Opstal",
          "factuurbedrag": "",
          "offertenummer": "168336115385",
          "passeeringangsdatum": "2018-03-16"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "103000.00",
          "status": "Gepasseerd",
          "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
          "maatschappij": "ABN AMRO",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "700.442.933",
          "passeeringangsdatum": "2018-03-16"
        }
      ],
      "crmdossier_id": "161283",
      "dossiernummer": "161283",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1152

{
  "dossier_id": "23b9f391-bfde-427a-9d45-880b890808f4",
  "key": "base_import",
  "value_json": {
    "adres": "Horst 26 69",
    "klant": "Borren, Frederik van (FJPL)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 PA",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "123718.00",
        "status": "Gepasseerd",
        "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3046255-01",
        "passeeringangsdatum": "2018-02-16"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "30200.00",
        "status": "Gepasseerd",
        "artikel": "Starterslening",
        "tekendatum": "25569",
        "productnaam": "Starterslening",
        "maatschappij": "SVn",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "240.830.000",
        "passeeringangsdatum": "2018-02-16"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2017-11-20"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Overlijdensrisicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Overlijdensrisicoverzekering",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "[telefoon]-19",
        "passeeringangsdatum": "2018-02-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "160280",
      "Borren, Frederik van (FJPL)",
      "Horst 26 69",
      "8225 PA",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "3046255-01",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Annuiteit (Argenta Special Line Hypotheek)",
      "Annuitair",
      "240.830.000",
      "SVn",
      "Starterslening",
      "Eigen kantoor",
      "Hypotheekadvies",
      "[telefoon]-19",
      "Levensverzekering",
      "Overlijdensrisicoverzekering",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "160280",
    "dossiernummer": "160280",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1153

{
  "dossier_id": "22dcf243-cf76-4aa1-b1ab-42cc021e454a",
  "key": "base_import",
  "value_json": {
    "adres": "Kempenaar 20 45",
    "klant": "Blinova, Alla (NS), Smit, Peter (PTA)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8231 GA",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "166806.00",
        "status": "Gepasseerd",
        "artikel": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
        "maatschappij": "Allianz",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3055964",
        "passeeringangsdatum": "2018-05-07"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-03-03"
      },
      {
        "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": "2018-03-20"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "164872",
      "Blinova, Alla (NS), Smit, Peter (PTA)",
      "Kempenaar 20 45",
      "8231 GA",
      "Lelystad",
      "[email]",
      "[email]",
      "06465251227",
      "3055964",
      "Allianz",
      "Hypotheek",
      "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
      "Aflossingsvrij, Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "*********",
      "InterBank NV",
      "Consumptief krediet",
      "Interbank Persoonlijke Lening",
      "Persoonlijke lening"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "164872",
    "dossiernummer": "164872",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "06465251227",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1154

{
  "dossier_id": "7f0b1780-e6d6-41af-b6ce-0b9e323ff598",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Soto Toppers, Raul (R)",
      "adres": "De Heraut 22",
      "email": "[email]",
      "postcode": "8255 EA",
      "woonplaats": "Swifterbant",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "De Heraut 22",
      "postcode": "8255 EA",
      "woonplaats": "Swifterbant"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "143000.00",
          "status": "Gepasseerd",
          "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
          "maatschappij": "ASN (voorheen BLG Wonen)",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "10294729",
          "passeeringangsdatum": "2018-12-13"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-09-13"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "51617.00",
          "status": "Beeindigd",
          "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
          "maatschappij": "ASN (voorheen BLG Wonen)",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "20156014",
          "passeeringangsdatum": "2023-10-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": "2662139",
          "passeeringangsdatum": "2018-11-01"
        }
      ],
      "crmdossier_id": "178298",
      "dossiernummer": "178298",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1155

{
  "dossier_id": "23b9f391-bfde-427a-9d45-880b890808f4",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Borren, Frederik van (FJPL)",
      "adres": "Horst 26 69",
      "email": "[email]",
      "postcode": "8225 PA",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Horst 26 69",
      "postcode": "8225 PA",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "123718.00",
          "status": "Gepasseerd",
          "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3046255-01",
          "passeeringangsdatum": "2018-02-16"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "30200.00",
          "status": "Gepasseerd",
          "artikel": "Starterslening",
          "tekendatum": "25569",
          "productnaam": "Starterslening",
          "maatschappij": "SVn",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "240.830.000",
          "passeeringangsdatum": "2018-02-16"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2017-11-20"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "[telefoon]-19",
          "passeeringangsdatum": "2018-02-01"
        }
      ],
      "crmdossier_id": "160280",
      "dossiernummer": "160280",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1156

{
  "dossier_id": "9373c46f-8666-4e3e-8265-c84dde4f27fd",
  "key": "base_import",
  "value_json": {
    "adres": "Punter 48 19",
    "klant": "Kuijk, Mario van (M.L.P.A.), Valente Damasceno, Francilene (F.D.N.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 GJ",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-01-15"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "200000.00",
        "status": "Gepasseerd",
        "artikel": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)",
        "maatschappij": "Rabobank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "4002.885.618",
        "passeeringangsdatum": "2018-05-16"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
        "maatschappij": "Credit Life",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "7001143506",
        "passeeringangsdatum": "2018-02-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "161133",
      "Kuijk, Mario van (M.L.P.A.), Valente Damasceno, Francilene (F.D.N.)",
      "Punter 48 19",
      "8242 GJ",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "4002.885.618",
      "Rabobank",
      "Hypotheek",
      "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)",
      "Annuitair",
      "7001143506",
      "Credit Life",
      "Levensverzekering",
      "Credit Life Overlijdensrisicoverzekering Annuitair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "161133",
    "dossiernummer": "161133",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1157

{
  "dossier_id": "9373c46f-8666-4e3e-8265-c84dde4f27fd",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kuijk, Mario van (M.L.P.A.)",
      "adres": "Punter 48 19",
      "email": "[email]",
      "postcode": "8242 GJ",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Valente Damasceno, Francilene (F.D.N.)",
      "adres": "Punter 48 19",
      "postcode": "8242 GJ",
      "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": "2018-01-15"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "200000.00",
          "status": "Gepasseerd",
          "artikel": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)",
          "tekendatum": "25569",
          "productnaam": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)",
          "maatschappij": "Rabobank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "4002.885.618",
          "passeeringangsdatum": "2018-05-16"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
          "maatschappij": "Credit Life",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "7001143506",
          "passeeringangsdatum": "2018-02-01"
        }
      ],
      "crmdossier_id": "161133",
      "dossiernummer": "161133",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1158

{
  "dossier_id": "b5d3e102-f4d0-4512-8bfb-1130443ae8ff",
  "key": "base_import",
  "value_json": {
    "adres": "Kogge 05 8",
    "klant": "Straka, Marian (M), Straková, Veronika (V)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 AS",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
        "maatschappij": "TAF",
        "productsoort": "Overlijdensrisicoverzekering",
        "factuurbedrag": "",
        "offertenummer": "2613587",
        "passeeringangsdatum": "2018-03-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "167000.00",
        "status": "Gepasseerd",
        "artikel": "Lloyds Annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Lloyds Annuiteitenhypotheek",
        "maatschappij": "Lloyds Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.662.243",
        "passeeringangsdatum": "2018-03-28"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-01-24"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "163163",
      "Straka, Marian (M), Straková, Veronika (V)",
      "Kogge 05 8",
      "8242 AS",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "2613587",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "1.662.243",
      "Lloyds Bank",
      "Hypotheek",
      "Lloyds Annuiteitenhypotheek",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "163163",
    "dossiernummer": "163163",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1159

{
  "dossier_id": "b5d3e102-f4d0-4512-8bfb-1130443ae8ff",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Straka, Marian (M)",
      "adres": "Kogge 05 8",
      "email": "[email]",
      "postcode": "8242 AS",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Straková, Veronika (V)",
      "adres": "Kogge 05 8",
      "postcode": "8242 AS",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2613587",
          "passeeringangsdatum": "2018-03-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "167000.00",
          "status": "Gepasseerd",
          "artikel": "Lloyds Annuiteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Annuiteitenhypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.662.243",
          "passeeringangsdatum": "2018-03-28"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-01-24"
        }
      ],
      "crmdossier_id": "163163",
      "dossiernummer": "163163",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1160

{
  "dossier_id": "22dcf243-cf76-4aa1-b1ab-42cc021e454a",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Blinova, Alla (NS)",
      "adres": "Kempenaar 20 45",
      "email": "[email]",
      "postcode": "8231 GA",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06465251227"
    },
    "a2": {
      "naam": "Smit, Peter (PTA)",
      "adres": "Kempenaar 20 45",
      "email": "[email]",
      "postcode": "8231 GA",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "166806.00",
          "status": "Gepasseerd",
          "artikel": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
          "maatschappij": "Allianz",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3055964",
          "passeeringangsdatum": "2018-05-07"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-03-03"
        },
        {
          "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": "2018-03-20"
        }
      ],
      "crmdossier_id": "164872",
      "dossiernummer": "164872",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1161

{
  "dossier_id": "6b5c8381-8c98-4a1b-a1a2-3744000277ce",
  "key": "base_import",
  "value_json": {
    "adres": "Punter 48 48",
    "klant": "Schroder (G.M.), Schroder (R.P.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8242 GL",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "105053.00",
        "status": "Offerte aangevraagd",
        "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
        "maatschappij": "IQWOON",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "ISW-42D250AA-CAC2-49C5-8CCE-CD53DD8BF61E(1)",
        "passeeringangsdatum": "2023-05-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "105053.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": "3377363-01",
        "passeeringangsdatum": "2023-05-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "105053.00",
        "status": "Offerte aangevraagd",
        "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
        "maatschappij": "IQWOON",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "ISW-D232FBAB-11E1-4B63-A927-3D2BBB6B85B6(1)",
        "passeeringangsdatum": "2023-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "259338",
      "Schroder (G.M.), Schroder (R.P.)",
      "Punter 48 48",
      "8242 GL",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "ISW-42D250AA-CAC2-49C5-8CCE-CD53DD8BF61E(1)",
      "IQWOON",
      "Hypotheek",
      "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
      "Aflossingsvrij, Annuitair",
      "3377363-01",
      "ISW-D232FBAB-11E1-4B63-A927-3D2BBB6B85B6(1)"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "259338",
    "dossiernummer": "259338",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1162

{
  "dossier_id": "6b5c8381-8c98-4a1b-a1a2-3744000277ce",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Schroder (G.M.)",
      "adres": "Punter 48 48",
      "email": "[email]",
      "postcode": "8242 GL",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Schroder (R.P.)",
      "adres": "Punter 48 48",
      "postcode": "8242 GL",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "105053.00",
          "status": "Offerte aangevraagd",
          "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
          "maatschappij": "IQWOON",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "ISW-42D250AA-CAC2-49C5-8CCE-CD53DD8BF61E(1)",
          "passeeringangsdatum": "2023-05-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "105053.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": "3377363-01",
          "passeeringangsdatum": "2023-05-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "105053.00",
          "status": "Offerte aangevraagd",
          "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek",
          "maatschappij": "IQWOON",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "ISW-D232FBAB-11E1-4B63-A927-3D2BBB6B85B6(1)",
          "passeeringangsdatum": "2023-05-01"
        }
      ],
      "crmdossier_id": "259338",
      "dossiernummer": "259338",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1163

{
  "dossier_id": "a7593b4c-4d5f-40ba-9358-2a7de90d19c5",
  "key": "base_import",
  "value_json": {
    "adres": "Schermer 115",
    "klant": "Brian, Danny (D), Korzelius, Jenny (J)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8244 AM",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "140000.00",
        "status": "Gepasseerd",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2018-05-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-03-07"
      },
      {
        "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": "2624771",
        "passeeringangsdatum": "2018-04-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "165588",
      "Brian, Danny (D), Korzelius, Jenny (J)",
      "Schermer 115",
      "8244 AM",
      "LELYSTAD",
      "[email]",
      "[email]",
      "[telefoon]",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2624771",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "165588",
    "dossiernummer": "165588",
    "dossierstatus": "Afgesloten",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1164

{
  "dossier_id": "a7593b4c-4d5f-40ba-9358-2a7de90d19c5",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Brian, Danny (D)",
      "adres": "Schermer 115",
      "email": "[email]",
      "postcode": "8244 AM",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Korzelius, Jenny (J)",
      "adres": "Schermer 115",
      "email": "[email]",
      "postcode": "8244 AM",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "140000.00",
          "status": "Gepasseerd",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2018-05-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-03-07"
        },
        {
          "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": "2624771",
          "passeeringangsdatum": "2018-04-01"
        }
      ],
      "crmdossier_id": "165588",
      "dossiernummer": "165588",
      "dossierstatus": "Afgesloten",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1165

{
  "dossier_id": "d2fa3d03-7c81-49da-ab7c-c15ac6e90f45",
  "key": "base_import",
  "value_json": {
    "adres": "Fjord 53",
    "klant": "Soy, Erdem (E)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8224 DC",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Akkoord",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2022-08-31"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "113898.00",
        "status": "Lopend",
        "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "*********",
        "passeeringangsdatum": "2021-06-28"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-08-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "233144",
      "Soy, Erdem (E)",
      "Fjord 53",
      "8224 DC",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "*********",
      "ING Bank",
      "Hypotheek",
      "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
      "Annuitair",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "233144",
    "dossiernummer": "233144",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1166

{
  "dossier_id": "d2fa3d03-7c81-49da-ab7c-c15ac6e90f45",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Soy, Erdem (E)",
      "adres": "Fjord 53",
      "email": "[email]",
      "postcode": "8224 DC",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Fjord 53",
      "postcode": "8224 DC",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2022-08-31"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "113898.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2021-06-28"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-08-01"
        }
      ],
      "crmdossier_id": "233144",
      "dossiernummer": "233144",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1167

{
  "dossier_id": "94808149-bf11-4ec5-b09a-3e8b1afed102",
  "key": "base_import",
  "value_json": {
    "adres": "Kamp 26 60",
    "klant": "Stevens (J), Visser (D.)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 EJ",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "184335.00",
        "status": "Gepasseerd",
        "artikel": "Annuïteiten hypotheek (Allianz Hypotheek), Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Annuïteiten hypotheek (Allianz Hypotheek), Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
        "maatschappij": "Allianz",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3057614-01",
        "passeeringangsdatum": "2018-05-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-03-08"
      },
      {
        "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": "2624088",
        "passeeringangsdatum": "2018-05-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "144741",
      "Stevens (J), Visser (D.)",
      "Kamp 26 60",
      "8225 EJ",
      "LELYSTAD",
      "[email]",
      "[email]",
      "[telefoon]",
      "3057614-01",
      "Allianz",
      "Hypotheek",
      "Annuïteiten hypotheek (Allianz Hypotheek), Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
      "Aflossingsvrij, Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "2624088",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "144741",
    "dossiernummer": "144741",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1168

{
  "dossier_id": "94808149-bf11-4ec5-b09a-3e8b1afed102",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Stevens (J)",
      "adres": "Kamp 26 60",
      "email": "[email]",
      "postcode": "8225 EJ",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Visser (D.)",
      "adres": "Kamp 26 60",
      "email": "[email]",
      "postcode": "8225 EJ",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "184335.00",
          "status": "Gepasseerd",
          "artikel": "Annuïteiten hypotheek (Allianz Hypotheek), Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Annuïteiten hypotheek (Allianz Hypotheek), Aflossingsvrije hypotheek (Allianz Hypotheek), Annuïteiten hypotheek (Allianz Hypotheek)",
          "maatschappij": "Allianz",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3057614-01",
          "passeeringangsdatum": "2018-05-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-03-08"
        },
        {
          "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": "2624088",
          "passeeringangsdatum": "2018-05-01"
        }
      ],
      "crmdossier_id": "144741",
      "dossiernummer": "144741",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1169

{
  "dossier_id": "7f0b1780-e6d6-41af-b6ce-0b9e323ff598",
  "key": "base_import",
  "value_json": {
    "adres": "De Heraut 22",
    "klant": "Soto Toppers, Raul (R)",
    "plaats": "Swifterbant",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8255 EA",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "143000.00",
        "status": "Gepasseerd",
        "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "maatschappij": "ASN (voorheen BLG Wonen)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "10294729",
        "passeeringangsdatum": "2018-12-13"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-09-13"
      },
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "51617.00",
        "status": "Beeindigd",
        "artikel": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "BLG Annuïteitenhypotheek (BLG Hypotheek)",
        "maatschappij": "ASN (voorheen BLG Wonen)",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "20156014",
        "passeeringangsdatum": "2023-10-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": "2662139",
        "passeeringangsdatum": "2018-11-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 4,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "178298",
      "Soto Toppers, Raul (R)",
      "De Heraut 22",
      "8255 EA",
      "Swifterbant",
      "[email]",
      "[telefoon]",
      "10294729",
      "ASN (voorheen BLG Wonen)",
      "Hypotheek",
      "BLG Annuïteitenhypotheek (BLG Hypotheek)",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "20156014",
      "2662139",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "178298",
    "dossiernummer": "178298",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1170

{
  "dossier_id": "9284d523-95cb-4791-ae51-493ed0a75f51",
  "key": "base_import",
  "value_json": {
    "adres": "Botter 11 02",
    "klant": "Abadi (M.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 JL",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "156847.00",
        "status": "Gepasseerd",
        "artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
        "maatschappij": "ING Bank",
        "productsoort": "Aflossingsvrij, Bankspaar",
        "factuurbedrag": "",
        "offertenummer": "Z 090-859858",
        "passeeringangsdatum": "2010-10-25"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "100639",
      "Abadi (M.)",
      "Botter 11 02",
      "8232 JL",
      "Lelystad",
      "[email]",
      "06 - 81 63 40 37",
      "Z 090-859858",
      "ING Bank",
      "Hypotheek",
      "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
      "Aflossingsvrij, Bankspaar"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "100639",
    "dossiernummer": "100639",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "06 - 81 63 40 37",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1171

{
  "dossier_id": "da3a52d9-8459-4a75-9d69-4306cd572b35",
  "key": "base_import",
  "value_json": {
    "adres": "De Schans 10 67",
    "klant": "Chehaita, Mohamad (M)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8231 KG",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-10-02"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "34600.00",
        "status": "Gepasseerd",
        "artikel": "Starterslening",
        "tekendatum": "25569",
        "productnaam": "Starterslening",
        "maatschappij": "SVn",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "243.109.000",
        "passeeringangsdatum": "2018-11-30"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Aansprakelijkheidsverzekering Particulieren, Woonhuisverzekering, Inboedelverzekering",
        "tekendatum": "25569",
        "productnaam": "Aansprakelijkheidsverzekering Particulieren, Woonhuisverzekering, Inboedelverzekering",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
        "factuurbedrag": "",
        "offertenummer": "180841785385",
        "passeeringangsdatum": "2018-11-30"
      },
      {
        "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": "2663805",
        "passeeringangsdatum": "2018-11-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "140000.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": "10295022",
        "passeeringangsdatum": "2018-11-30"
      },
      {
        "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": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "179078",
      "Chehaita, Mohamad (M)",
      "De Schans 10 67",
      "8231 KG",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "243.109.000",
      "SVn",
      "Hypotheek",
      "Starterslening",
      "Annuitair",
      "180841785385",
      "Voogd & Voogd",
      "Schadeverzekering",
      "Aansprakelijkheidsverzekering Particulieren, Woonhuisverzekering, Inboedelverzekering",
      "Aansprakelijkheid, Inboedel, Opstal",
      "2663805",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "10295022",
      "ASN (voorheen BLG Wonen)",
      "BLG Annuïteitenhypotheek (BLG Hypotheek)",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Opstal, Inboedel, Aansprakelijkheid"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "179078",
    "dossiernummer": "179078",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1172

{
  "dossier_id": "da3a52d9-8459-4a75-9d69-4306cd572b35",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Chehaita, Mohamad (M)",
      "adres": "De Schans 10 67",
      "email": "[email]",
      "postcode": "8231 KG",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "De Schans 10 67",
      "postcode": "8231 KG",
      "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": "2018-10-02"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "34600.00",
          "status": "Gepasseerd",
          "artikel": "Starterslening",
          "tekendatum": "25569",
          "productnaam": "Starterslening",
          "maatschappij": "SVn",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "243.109.000",
          "passeeringangsdatum": "2018-11-30"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Aansprakelijkheidsverzekering Particulieren, Woonhuisverzekering, Inboedelverzekering",
          "tekendatum": "25569",
          "productnaam": "Aansprakelijkheidsverzekering Particulieren, Woonhuisverzekering, Inboedelverzekering",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "180841785385",
          "passeeringangsdatum": "2018-11-30"
        },
        {
          "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": "2663805",
          "passeeringangsdatum": "2018-11-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "140000.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": "10295022",
          "passeeringangsdatum": "2018-11-30"
        },
        {
          "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": "179078",
      "dossiernummer": "179078",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1173

{
  "dossier_id": "be435c65-d804-4567-adbb-9f8360db9ed6",
  "key": "base_import",
  "value_json": {
    "adres": "Tjalk 13 11",
    "klant": "Domagala, Maciej (M)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 KH",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "165000.00",
        "status": "Lopend",
        "artikel": "IQWOON Annuïteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "IQWOON Annuïteitenhypotheek",
        "maatschappij": "IQWOON",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3097480-01",
        "passeeringangsdatum": "2018-12-28"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-11-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "182292",
      "Domagala, Maciej (M)",
      "Tjalk 13 11",
      "8232 KH",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "3097480-01",
      "IQWOON",
      "Hypotheek",
      "IQWOON Annuïteitenhypotheek",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "182292",
    "dossiernummer": "182292",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1174

{
  "dossier_id": "be435c65-d804-4567-adbb-9f8360db9ed6",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Domagala, Maciej (M)",
      "adres": "Tjalk 13 11",
      "email": "[email]",
      "postcode": "8232 KH",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Tjalk 13 11",
      "postcode": "8232 KH",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "165000.00",
          "status": "Lopend",
          "artikel": "IQWOON Annuïteitenhypotheek",
          "tekendatum": "25569",
          "productnaam": "IQWOON Annuïteitenhypotheek",
          "maatschappij": "IQWOON",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3097480-01",
          "passeeringangsdatum": "2018-12-28"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-11-15"
        }
      ],
      "crmdossier_id": "182292",
      "dossiernummer": "182292",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1175

{
  "dossier_id": "ad9581cd-c7a1-4632-84f9-ce2f53793fb8",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Ham, Nick (N.L.)",
      "adres": "Admiraal De Ruijterweg 4742",
      "email": "[email]",
      "postcode": "1055 NH",
      "woonplaats": "Amsterdam",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Kothen, Kimberley vom (K.K.)",
      "adres": "Admiraal De Ruijterweg 4742",
      "email": "[email]",
      "postcode": "1055 NH",
      "woonplaats": "Amsterdam"
    },
    "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": "2018-11-15"
        }
      ],
      "crmdossier_id": "176501",
      "dossiernummer": "176501",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1176

{
  "dossier_id": "635fbd25-6708-432a-a5ee-776707645da8",
  "key": "base_import",
  "value_json": {
    "adres": "Vogelwikke 18",
    "klant": "Bakker, Marcel (M), Wijers, Marieke (M)",
    "plaats": "Swifterbant",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8255 KG",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-11-14"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
        "maatschappij": "Credit Life",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "7001174480",
        "passeeringangsdatum": "2019-03-18"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "170687.00",
        "status": "Lopend",
        "artikel": "NIBC Annuiteit, NIBC Annuiteit, NIBC Annuiteit",
        "tekendatum": "25569",
        "productnaam": "NIBC Annuiteit, NIBC Annuiteit, NIBC Annuiteit",
        "maatschappij": "NIBC",
        "productsoort": "Annuitair",
        "factuurbedrag": "2250.00",
        "offertenummer": "1726815",
        "passeeringangsdatum": "2019-03-18"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "181446",
      "Bakker, Marcel (M), Wijers, Marieke (M)",
      "Vogelwikke 18",
      "8255 KG",
      "Swifterbant",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies",
      "7001174480",
      "Credit Life",
      "Levensverzekering",
      "Credit Life Overlijdensrisicoverzekering Annuitair",
      "Annuitair Dalende Risicoverzekeringen",
      "1726815",
      "NIBC",
      "Hypotheek",
      "NIBC Annuiteit, NIBC Annuiteit, NIBC Annuiteit",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "181446",
    "dossiernummer": "181446",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1177

{
  "dossier_id": "e575b75b-114a-4eca-b5d2-aa14dee49ca0",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Colenberg, Tim (T)",
      "adres": "Schoener 17 16",
      "email": "[email]",
      "postcode": "8243 TN",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Klijnsma, Trudy (T)",
      "adres": "Schoener 17 16",
      "postcode": "8243 TN",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "264500.00",
          "status": "Gepasseerd",
          "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
          "maatschappij": "ABN AMRO",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "700.323.883",
          "passeeringangsdatum": "2016-01-29"
        }
      ],
      "crmdossier_id": "115987",
      "dossiernummer": "115987",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1178

{
  "dossier_id": "95d2a6ba-7200-4dc3-afe0-fd413fb58e5a",
  "key": "base_import",
  "value_json": {
    "adres": "Schermer 40",
    "klant": "Bohemen, Sandra van (S), Boom, Leon (L)",
    "plaats": "LELYSTAD",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8244 AN",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "45171.00",
        "status": "Renteaanbod aan klant verzonden",
        "artikel": "Aegon Annuïteitenhypotheek (Aegon Annuïteitenhypotheek)",
        "tekendatum": "25569",
        "productnaam": "Aegon Annuïteitenhypotheek (Aegon Annuïteitenhypotheek)",
        "maatschappij": "AEGON",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1405801",
        "passeeringangsdatum": "2023-07-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "163268.00",
        "status": "Lopend",
        "artikel": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
        "maatschappij": "AEGON",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "2500.00",
        "offertenummer": "7548936",
        "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-29"
      },
      {
        "norm": "",
        "type": "Verkoopdienst",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen makelaardij",
        "productsoort": "",
        "factuurbedrag": "2458.67",
        "offertenummer": "",
        "passeeringangsdatum": "2019-02-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-5F93D308-829D-4851-8BD0-3701DEE66B5C|852(1)",
        "passeeringangsdatum": "2019-05-01"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Risicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Risicoverzekering",
        "maatschappij": "Reaal schadeverzekeringen",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "1300360769",
        "passeeringangsdatum": "2019-02-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "182942",
      "Bohemen, Sandra van (S), Boom, Leon (L)",
      "Schermer 40",
      "8244 AN",
      "LELYSTAD",
      "[email]",
      "[telefoon]",
      "1405801",
      "AEGON",
      "Hypotheek",
      "Aegon Annuïteitenhypotheek (Aegon Annuïteitenhypotheek)",
      "Annuitair",
      "7548936",
      "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
      "Aflossingsvrij, Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "Eigen makelaardij",
      "Verkoopdienst",
      "ISW-5F93D308-829D-4851-8BD0-3701DEE66B5C|852(1)",
      "Cardif",
      "Inkomensverzekering",
      "Cardif Aflos Verzekering",
      "Woonlastenverzekering",
      "1300360769",
      "Reaal schadeverzekeringen",
      "Levensverzekering",
      "Risicoverzekering",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "182942",
    "dossiernummer": "182942",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1179

{
  "dossier_id": "95d2a6ba-7200-4dc3-afe0-fd413fb58e5a",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Bohemen, Sandra van (S)",
      "adres": "Schermer 40",
      "email": "[email]",
      "postcode": "8244 AN",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Boom, Leon (L)",
      "adres": "Schermer 40",
      "postcode": "8244 AN",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "45171.00",
          "status": "Renteaanbod aan klant verzonden",
          "artikel": "Aegon Annuïteitenhypotheek (Aegon Annuïteitenhypotheek)",
          "tekendatum": "25569",
          "productnaam": "Aegon Annuïteitenhypotheek (Aegon Annuïteitenhypotheek)",
          "maatschappij": "AEGON",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1405801",
          "passeeringangsdatum": "2023-07-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "163268.00",
          "status": "Lopend",
          "artikel": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Aegon Aflossingsvrije hypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek), Aegon Annuïteitenhypotheek (Aegon Aflossingsvrije hypotheek)",
          "maatschappij": "AEGON",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "2500.00",
          "offertenummer": "7548936",
          "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-29"
        },
        {
          "norm": "",
          "type": "Verkoopdienst",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen makelaardij",
          "productsoort": "",
          "factuurbedrag": "2458.67",
          "offertenummer": "",
          "passeeringangsdatum": "2019-02-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-5F93D308-829D-4851-8BD0-3701DEE66B5C|852(1)",
          "passeeringangsdatum": "2019-05-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Risicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Risicoverzekering",
          "maatschappij": "Reaal schadeverzekeringen",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "1300360769",
          "passeeringangsdatum": "2019-02-01"
        }
      ],
      "crmdossier_id": "182942",
      "dossiernummer": "182942",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1180

{
  "dossier_id": "009b5118-80f0-4b2a-a476-6224e9099fd9",
  "key": "base_import",
  "value_json": {
    "adres": "Stadseiland 100",
    "klant": "Graaf, Sylvia van der (S), Jong, Peter de (P)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 HV",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "253966.00",
        "status": "Lopend",
        "artikel": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
        "tekendatum": "25569",
        "productnaam": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
        "maatschappij": "Merius Hypotheken",
        "productsoort": "Aflossingsvrij, Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3013205",
        "passeeringangsdatum": "2019-09-18"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2019-07-11"
      },
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
        "tekendatum": "25569",
        "productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
        "maatschappij": "Credit Life",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "7001195018",
        "passeeringangsdatum": "2019-09-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 3,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "197890",
      "Graaf, Sylvia van der (S), Jong, Peter de (P)",
      "Stadseiland 100",
      "8243 HV",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "3013205",
      "Merius Hypotheken",
      "Hypotheek",
      "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
      "Aflossingsvrij, Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "7001195018",
      "Credit Life",
      "Levensverzekering",
      "Credit Life Overlijdensrisicoverzekering Annuitair",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "197890",
    "dossiernummer": "197890",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1181

{
  "dossier_id": "e575b75b-114a-4eca-b5d2-aa14dee49ca0",
  "key": "base_import",
  "value_json": {
    "adres": "Schoener 17 16",
    "klant": "Colenberg, Tim (T), Klijnsma, Trudy (T)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 TN",
    "products": [
      {
        "norm": "Geldverstrekker",
        "type": "Hypotheek",
        "inhoud": "264500.00",
        "status": "Gepasseerd",
        "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
        "maatschappij": "ABN AMRO",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "700.323.883",
        "passeeringangsdatum": "2016-01-29"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "115987",
      "Colenberg, Tim (T), Klijnsma, Trudy (T)",
      "Schoener 17 16",
      "8243 TN",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "700.323.883",
      "ABN AMRO",
      "Hypotheek",
      "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
      "Annuitair"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "115987",
    "dossiernummer": "115987",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1182

{
  "dossier_id": "ad9581cd-c7a1-4632-84f9-ce2f53793fb8",
  "key": "base_import",
  "value_json": {
    "adres": "Admiraal De Ruijterweg 4742",
    "klant": "Ham, Nick (N.L.), Kothen, Kimberley vom (K.K.)",
    "plaats": "Amsterdam",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "1055 NH",
    "products": [
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-11-15"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "176501",
      "Ham, Nick (N.L.), Kothen, Kimberley vom (K.K.)",
      "Admiraal De Ruijterweg 4742",
      "1055 NH",
      "Amsterdam",
      "[email]",
      "[email]",
      "[telefoon]",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "176501",
    "dossiernummer": "176501",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1183

{
  "dossier_id": "a78b9b62-9c74-4ebb-be0e-dc6f9b306acc",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Sterken (A.)",
      "adres": "Rijnland 317",
      "email": "[email]",
      "postcode": "8245 EE",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Swagerman, Melis (M.)",
      "adres": "Rijnland 317",
      "postcode": "8245 EE",
      "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": "2018-11-23"
        }
      ],
      "crmdossier_id": "181851",
      "dossiernummer": "181851",
      "dossierstatus": "Geroyeerd",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1184

{
  "dossier_id": "dd52c178-e610-403c-b03e-cb17087ba80f",
  "key": "base_import",
  "value_json": {
    "adres": "Kamp 14 5",
    "klant": "Lichwa, Marcin",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 GD",
    "products": [
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Aansprakelijkheidsverzekering Particulieren, Inboedelverzekering, Rechtsbijstand voor Particulieren, Woonhuisverzekering",
        "tekendatum": "25569",
        "productnaam": "Aansprakelijkheidsverzekering Particulieren, Inboedelverzekering, Rechtsbijstand voor Particulieren, Woonhuisverzekering",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "177301625385",
        "passeeringangsdatum": "2018-09-04"
      },
      {
        "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": "2642869",
        "passeeringangsdatum": "2018-07-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "180000.00",
        "status": "Lopend",
        "artikel": "Annuiteit (Florius Profijt Drie+Drie (0% afsluitkosten))",
        "tekendatum": "25569",
        "productnaam": "Annuiteit (Florius Profijt Drie+Drie (0% afsluitkosten))",
        "maatschappij": "Florius",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "1.781.019",
        "passeeringangsdatum": "2018-09-04"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-07-06"
      },
      {
        "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-09-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 5,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "169700",
      "Lichwa, Marcin",
      "Kamp 14 5",
      "8225 GD",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "177301625385",
      "Voogd & Voogd",
      "Schadeverzekering",
      "Aansprakelijkheidsverzekering Particulieren, Inboedelverzekering, Rechtsbijstand voor Particulieren, Woonhuisverzekering",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
      "2642869",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "1.781.019",
      "Florius",
      "Hypotheek",
      "Annuiteit (Florius Profijt Drie+Drie (0% afsluitkosten))",
      "Annuitair",
      "Eigen kantoor",
      "Hypotheekadvies",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "169700",
    "dossiernummer": "169700",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1185

{
  "dossier_id": "dd52c178-e610-403c-b03e-cb17087ba80f",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Lichwa, Marcin",
      "adres": "Kamp 14 5",
      "email": "[email]",
      "postcode": "8225 GD",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Kamp 14 5",
      "postcode": "8225 GD",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Aansprakelijkheidsverzekering Particulieren, Inboedelverzekering, Rechtsbijstand voor Particulieren, Woonhuisverzekering",
          "tekendatum": "25569",
          "productnaam": "Aansprakelijkheidsverzekering Particulieren, Inboedelverzekering, Rechtsbijstand voor Particulieren, Woonhuisverzekering",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "177301625385",
          "passeeringangsdatum": "2018-09-04"
        },
        {
          "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": "2642869",
          "passeeringangsdatum": "2018-07-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "180000.00",
          "status": "Lopend",
          "artikel": "Annuiteit (Florius Profijt Drie+Drie (0% afsluitkosten))",
          "tekendatum": "25569",
          "productnaam": "Annuiteit (Florius Profijt Drie+Drie (0% afsluitkosten))",
          "maatschappij": "Florius",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1.781.019",
          "passeeringangsdatum": "2018-09-04"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-07-06"
        },
        {
          "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-09-01"
        }
      ],
      "crmdossier_id": "169700",
      "dossiernummer": "169700",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1186

{
  "dossier_id": "fd8dd676-5815-4108-8f3c-aa944d733597",
  "key": "base_import",
  "value_json": {
    "adres": "Tjalk 34 01",
    "klant": "Kuiper (H.W.), Zouw, van der (J.E.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8232 LV",
    "products": [
      {
        "norm": "",
        "type": "Verkoopdienst",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen makelaardij",
        "productsoort": "",
        "factuurbedrag": "3650.00",
        "offertenummer": "",
        "passeeringangsdatum": "2019-01-17"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "177083",
      "Kuiper (H.W.), Zouw, van der (J.E.)",
      "Tjalk 34 01",
      "8232 LV",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "Eigen makelaardij",
      "Verkoopdienst"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "177083",
    "dossiernummer": "177083",
    "dossierstatus": "Vervallen",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1187

{
  "dossier_id": "fd8dd676-5815-4108-8f3c-aa944d733597",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kuiper (H.W.)",
      "adres": "Tjalk 34 01",
      "email": "[email]",
      "postcode": "8232 LV",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Zouw, van der (J.E.)",
      "adres": "Tjalk 34 01",
      "postcode": "8232 LV",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Verkoopdienst",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen makelaardij",
          "productsoort": "",
          "factuurbedrag": "3650.00",
          "offertenummer": "",
          "passeeringangsdatum": "2019-01-17"
        }
      ],
      "crmdossier_id": "177083",
      "dossiernummer": "177083",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1188

{
  "dossier_id": "c7ac99b3-70f8-45da-99f3-3acd3fb730b7",
  "key": "base_import",
  "value_json": {
    "adres": "Merelstraat 5",
    "klant": "Kaupaite, Egle (E)",
    "plaats": "Alblasserdam",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "2953 EK",
    "products": [
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-77C43218-466B-4D3A-BB54-6981653BD6B8|826(1)",
        "passeeringangsdatum": "2018-12-01"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Offerte aangevraagd",
        "artikel": "TAF Woonlasten beschermer",
        "tekendatum": "25569",
        "productnaam": "TAF Woonlasten beschermer",
        "maatschappij": "TAF",
        "productsoort": "Woonlastenverzekering",
        "factuurbedrag": "",
        "offertenummer": "ISW-77C43218-466B-4D3A-BB54-6981653BD6B8|826(1)",
        "passeeringangsdatum": "2018-12-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-12-01"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-12-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-09-25"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-09-25"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 6,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "178823",
      "Kaupaite, Egle (E)",
      "Merelstraat 5",
      "2953 EK",
      "Alblasserdam",
      "[email]",
      "[email]",
      "[telefoon]",
      "ISW-77C43218-466B-4D3A-BB54-6981653BD6B8|826(1)",
      "TAF",
      "Inkomensverzekering",
      "TAF Woonlasten beschermer",
      "Woonlastenverzekering",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
      "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
      "Eigen kantoor",
      "Hypotheekadvies"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "178823",
    "dossiernummer": "178823",
    "dossierstatus": "Geroyeerd",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1189

{
  "dossier_id": "c7ac99b3-70f8-45da-99f3-3acd3fb730b7",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kaupaite, Egle (E)",
      "adres": "Merelstraat 5",
      "email": "[email]",
      "postcode": "2953 EK",
      "woonplaats": "Alblasserdam",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Merelstraat 5",
      "email": "[email]",
      "postcode": "2953 EK",
      "woonplaats": "Alblasserdam"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-77C43218-466B-4D3A-BB54-6981653BD6B8|826(1)",
          "passeeringangsdatum": "2018-12-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-77C43218-466B-4D3A-BB54-6981653BD6B8|826(1)",
          "passeeringangsdatum": "2018-12-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-12-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-12-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-09-25"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-09-25"
        }
      ],
      "crmdossier_id": "178823",
      "dossiernummer": "178823",
      "dossierstatus": "Geroyeerd",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1190

{
  "dossier_id": "662f7117-39fa-4b8c-b667-d88f956af149",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Frysztacki (D.A.)",
      "adres": "Schoener 35 24",
      "email": "[email]",
      "postcode": "8243 WJ",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Grzesik (A.A.)",
      "adres": "Schoener 35 24",
      "postcode": "8243 WJ",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Annuitair Dalende Risicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Annuitair Dalende Risicoverzekering",
          "maatschappij": "Cardif",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "O43402",
          "passeeringangsdatum": "2012-04-01"
        }
      ],
      "crmdossier_id": "99892",
      "dossiernummer": "99892",
      "dossierstatus": "Vervallen",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1191

{
  "dossier_id": "662f7117-39fa-4b8c-b667-d88f956af149",
  "key": "base_import",
  "value_json": {
    "adres": "Schoener 35 24",
    "klant": "Frysztacki (D.A.), Grzesik (A.A.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8243 WJ",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Annuitair Dalende Risicoverzekering",
        "tekendatum": "25569",
        "productnaam": "Annuitair Dalende Risicoverzekering",
        "maatschappij": "Cardif",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "O43402",
        "passeeringangsdatum": "2012-04-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "99892",
      "Frysztacki (D.A.), Grzesik (A.A.)",
      "Schoener 35 24",
      "8243 WJ",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "O43402",
      "Cardif",
      "Levensverzekering",
      "Annuitair Dalende Risicoverzekering",
      "Annuitair Dalende Risicoverzekeringen"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "99892",
    "dossiernummer": "99892",
    "dossierstatus": "Vervallen",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1192

{
  "dossier_id": "635fbd25-6708-432a-a5ee-776707645da8",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Bakker, Marcel (M)",
      "adres": "Vogelwikke 18",
      "email": "[email]",
      "postcode": "8255 KG",
      "woonplaats": "Swifterbant",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Wijers, Marieke (M)",
      "adres": "Vogelwikke 18",
      "email": "[email]",
      "postcode": "8255 KG",
      "woonplaats": "Swifterbant"
    },
    "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": "2018-11-14"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
          "maatschappij": "Credit Life",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "7001174480",
          "passeeringangsdatum": "2019-03-18"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "170687.00",
          "status": "Lopend",
          "artikel": "NIBC Annuiteit, NIBC Annuiteit, NIBC Annuiteit",
          "tekendatum": "25569",
          "productnaam": "NIBC Annuiteit, NIBC Annuiteit, NIBC Annuiteit",
          "maatschappij": "NIBC",
          "productsoort": "Annuitair",
          "factuurbedrag": "2250.00",
          "offertenummer": "1726815",
          "passeeringangsdatum": "2019-03-18"
        }
      ],
      "crmdossier_id": "181446",
      "dossiernummer": "181446",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1193

{
  "dossier_id": "e5f43fa5-f85c-40d8-8b34-2ff0aa5655e9",
  "key": "base_import",
  "value_json": {
    "adres": "Bastion 155",
    "klant": "Ratola De Almeida, Eduardo (E.S. )",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8223 GM",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "127500.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": "595100",
        "passeeringangsdatum": "2018-12-07"
      },
      {
        "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": "2667793",
        "passeeringangsdatum": "2018-11-01"
      },
      {
        "norm": "",
        "type": "Hypotheekadvies",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "",
        "tekendatum": "25569",
        "productnaam": "",
        "maatschappij": "Eigen kantoor",
        "productsoort": "",
        "factuurbedrag": "",
        "offertenummer": "",
        "passeeringangsdatum": "2018-10-24"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "tekendatum": "25569",
        "productnaam": "Inboedel, Aansprakelijkheid, Rechtsbijstand",
        "maatschappij": "Risk Assuradeuren",
        "productsoort": "Aansprakelijkheid, Inboedel, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "5369PK-*********",
        "passeeringangsdatum": "2023-12-01"
      },
      {
        "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": "7624213014",
        "passeeringangsdatum": "2018-11-02"
      },
      {
        "norm": "",
        "type": "Schadeverzekering",
        "inhoud": "0.00",
        "status": "Aanvraag nieuw",
        "artikel": "Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren, Inboedelverzekering",
        "tekendatum": "25569",
        "productnaam": "Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren, Inboedelverzekering",
        "maatschappij": "Voogd & Voogd",
        "productsoort": "Aansprakelijkheid, Inboedel, Rechtsbijstand",
        "factuurbedrag": "",
        "offertenummer": "181179335385",
        "passeeringangsdatum": "2018-12-07"
      },
      {
        "norm": "",
        "type": "Inkomensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "Maandlastbeschermer",
        "tekendatum": "25569",
        "productnaam": "Maandlastbeschermer",
        "maatschappij": "TAF",
        "productsoort": "Arbeidsongeschiktheidsverzekering",
        "factuurbedrag": "",
        "offertenummer": "40029804",
        "passeeringangsdatum": "2019-01-01"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 7,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "178758",
      "Ratola De Almeida, Eduardo (E.S. )",
      "Bastion 155",
      "8223 GM",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "595100",
      "Obvion",
      "Hypotheek",
      "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
      "Annuitair",
      "2667793",
      "TAF",
      "Levensverzekering",
      "Credit Life International Overlijdensrisicoverzekering - Annuitair",
      "Overlijdensrisicoverzekering",
      "Eigen kantoor",
      "Hypotheekadvies",
      "5369PK-*********",
      "Risk Assuradeuren",
      "Schadeverzekering",
      "Inboedel, Aansprakelijkheid, Rechtsbijstand",
      "Aansprakelijkheid, Inboedel, Rechtsbijstand",
      "7624213014",
      "InterBank NV",
      "Consumptief krediet",
      "Interbank Persoonlijke Lening",
      "Persoonlijke lening",
      "181179335385",
      "Voogd & Voogd",
      "Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren, Inboedelverzekering",
      "40029804",
      "Inkomensverzekering",
      "Maandlastbeschermer",
      "Arbeidsongeschiktheidsverzekering"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "178758",
    "dossiernummer": "178758",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1194

{
  "dossier_id": "e5f43fa5-f85c-40d8-8b34-2ff0aa5655e9",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Ratola De Almeida, Eduardo (E.S. )",
      "adres": "Bastion 155",
      "email": "[email]",
      "postcode": "8223 GM",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Bastion 155",
      "postcode": "8223 GM",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "127500.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": "595100",
          "passeeringangsdatum": "2018-12-07"
        },
        {
          "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": "2667793",
          "passeeringangsdatum": "2018-11-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-10-24"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "tekendatum": "25569",
          "productnaam": "Inboedel, Aansprakelijkheid, Rechtsbijstand",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-12-01"
        },
        {
          "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": "7624213014",
          "passeeringangsdatum": "2018-11-02"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren, Inboedelverzekering",
          "tekendatum": "25569",
          "productnaam": "Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren, Inboedelverzekering",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Inboedel, Rechtsbijstand",
          "factuurbedrag": "",
          "offertenummer": "181179335385",
          "passeeringangsdatum": "2018-12-07"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Maandlastbeschermer",
          "tekendatum": "25569",
          "productnaam": "Maandlastbeschermer",
          "maatschappij": "TAF",
          "productsoort": "Arbeidsongeschiktheidsverzekering",
          "factuurbedrag": "",
          "offertenummer": "40029804",
          "passeeringangsdatum": "2019-01-01"
        }
      ],
      "crmdossier_id": "178758",
      "dossiernummer": "178758",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1195

{
  "dossier_id": "94d1dd7b-27a3-49ea-b52b-677083b6f276",
  "key": "base_import",
  "value_json": {
    "adres": "Plantage 165",
    "klant": "Cicek (S.), Uslu, Asiye (A.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8212 VK",
    "products": [
      {
        "norm": "",
        "type": "Levensverzekering",
        "inhoud": "0.00",
        "status": "Lopend",
        "artikel": "ORV Annuitair dalend",
        "tekendatum": "25569",
        "productnaam": "ORV Annuitair dalend",
        "maatschappij": "Reaal schadeverzekeringen",
        "productsoort": "Annuitair Dalende Risicoverzekeringen",
        "factuurbedrag": "",
        "offertenummer": "1300292787",
        "passeeringangsdatum": "2018-07-01"
      },
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "170000.00",
        "status": "Lopend",
        "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "tekendatum": "25569",
        "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
        "maatschappij": "Argenta hypotheken",
        "productsoort": "Annuitair",
        "factuurbedrag": "",
        "offertenummer": "3062055-01",
        "passeeringangsdatum": "2018-10-25"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 2,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "161093",
      "Cicek (S.), Uslu, Asiye (A.)",
      "Plantage 165",
      "8212 VK",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "1300292787",
      "Reaal schadeverzekeringen",
      "Levensverzekering",
      "ORV Annuitair dalend",
      "Annuitair Dalende Risicoverzekeringen",
      "3062055-01",
      "Argenta hypotheken",
      "Hypotheek",
      "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line 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": "161093",
    "dossiernummer": "161093",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1196

{
  "dossier_id": "94d1dd7b-27a3-49ea-b52b-677083b6f276",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Cicek (S.)",
      "adres": "Plantage 165",
      "email": "[email]",
      "postcode": "8212 VK",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "naam": "Uslu, Asiye (A.)",
      "adres": "Plantage 165",
      "postcode": "8212 VK",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "ORV Annuitair dalend",
          "tekendatum": "25569",
          "productnaam": "ORV Annuitair dalend",
          "maatschappij": "Reaal schadeverzekeringen",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "1300292787",
          "passeeringangsdatum": "2018-07-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "170000.00",
          "status": "Lopend",
          "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
          "maatschappij": "Argenta hypotheken",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3062055-01",
          "passeeringangsdatum": "2018-10-25"
        }
      ],
      "crmdossier_id": "161093",
      "dossiernummer": "161093",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1197

{
  "dossier_id": "9c787c05-9b00-4133-b13f-ea8ad3c28f4e",
  "key": "base_import",
  "value_json": {
    "adres": "Archipel 16 32",
    "klant": "Niemoller, Paul (P)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8224 GH",
    "products": [
      {
        "norm": "NHG",
        "type": "Hypotheek",
        "inhoud": "194213.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": "2442618",
        "passeeringangsdatum": "2013-04-26"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "95877",
      "Niemoller, Paul (P)",
      "Archipel 16 32",
      "8224 GH",
      "Lelystad",
      "[email]",
      "[email]",
      "[telefoon]",
      "2442618",
      "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": "95877",
    "dossiernummer": "95877",
    "dossierstatus": "Actief",
    "email_partner": "[email]",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1198

{
  "dossier_id": "e9b6143b-e266-4ccb-b4a7-3b97821ce9cf",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Broekhuis (E.J.F.)",
      "adres": "Langezand 59",
      "postcode": "8223 WE",
      "woonplaats": "Lelystad"
    },
    "a2": {
      "naam": "Kemmer (D.B.)",
      "adres": "Langezand 59",
      "postcode": "8223 WE",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Consumptief krediet",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "DK",
          "tekendatum": "25569",
          "productnaam": "DK",
          "maatschappij": "Voordeelbank B.V.",
          "productsoort": "Doorlopend krediet",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2010-12-06"
        }
      ],
      "crmdossier_id": "150656",
      "dossiernummer": "150656",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1778230486535
}

Rij 1199

{
  "dossier_id": "c54ffe5e-6127-4da0-ac1f-d7e75ef10d99",
  "key": "base_import",
  "value_json": {
    "adres": "Wold 24 02",
    "klant": "Zielonka (M.)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8225 BE",
    "products": [
      {
        "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": "2017-03-14"
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-05-08T08:54:46.535Z",
    "match_terms": [
      "167912",
      "Zielonka (M.)",
      "Wold 24 02",
      "8225 BE",
      "Lelystad",
      "[email]",
      "[telefoon]",
      "*********",
      "InterBank NV",
      "Consumptief krediet",
      "Interbank Doorlopend Krediet",
      "Doorlopend krediet"
    ],
    "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
    "crmdossier_id": "167912",
    "dossiernummer": "167912",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "[telefoon]",
    "email_aanvrager": "[email]"
  },
  "updated_at": 1778230486535
}

Rij 1200

{
  "dossier_id": "c54ffe5e-6127-4da0-ac1f-d7e75ef10d99",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Zielonka (M.)",
      "adres": "Wold 24 02",
      "email": "[email]",
      "postcode": "8225 BE",
      "woonplaats": "Lelystad",
      "telefoon_prive": "[telefoon]"
    },
    "a2": {
      "adres": "Wold 24 02",
      "postcode": "8225 BE",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "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": "2017-03-14"
        }
      ],
      "crmdossier_id": "167912",
      "dossiernummer": "167912",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "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)