insurance-customers.csv

01 / Overview

Dataset overview

Size, completeness and the main signal to check first.

Rows: 3,000No empty rows
Columns: 34102,000 cells analyzed
Missing cells: 12.29%12,532 cells
Duplicate rows: 8Beyond the first occurrence

Derived · sum of 6 date columns

1,630

ambiguous dates, kept unresolved.

Values that match more than one configured date order. That is 10.93% of the 14,912 present date values. Tabalyst does not guess the order.

date_naissance356
date_debut335
date_fin274
date_creation299
date_modification313
date_reclamation53

See date analysis

Quality observations

warning: Duplicate rows beyond their first occurrence8
warning: Missing cells12,532
info: Cells changed by trimming surrounding whitespace0
info: Cells changed by collapsing repeated internal whitespace129
info: Values written in several ways that normalization compares as equal74
warning: Date values matching more than one day-month order1,630

Column types

Text 24
Date 6
Integer 2
Number 2

Semantic types

Enumeration 14
No semantic type 11
Date 6
Postal Code 1
Email 1
Phone 1

Mixed: fewer than 95.0% of present values agree on one type.

02 / Structure

Columns(34)

Inferred and semantic types per column. With issues: missing values or mixed type.

Column	Missing	Distinct	Inferred type	Semantic type	Error	Examples
1filiale	–	3	text	enumeration	–	principalquebecontario
2id_client	–	2,992	text	–	–	CLI-00002347CLI-00055908CLI-00090070
3civilite	–	2	text	enumeration	–	M.Mme
4prenom	0.23%7	227	text	–	–	DanielRobertSophie
5nom	0.13%4	214	text	–	–	RoyTremblayFortin
6date_naissance	0.2%6	2,889	date	date	0.1%3	1939-11-092000-12-202026-13-40
7sexe	–	2	text	enumeration	–	MF
8langue_preferee	–	2	text	enumeration	–	fren
9numero_voie	–	2,576	integer	–	–	418583989730
10type_voie	–	31	text	enumeration	–	rueavenueboulevard
11nom_voie	–	175	text	–	–	des Mélèzesdu Ruisseaudu Lac
12orientation	76.0%2,280	8	text	enumeration	–	OuestNordSud
13appartement	64.27%1,928	665	integer	–	–	791795958
14ville	–	135	text	–	–	MontréalQuébecLaval
15province_code	0.1%3	16	text	enumeration	–	QCONAB
16province_nom	–	18	text	enumeration	–	QuébecOntarioAlberta
17code_postal	–	2,962	text	postal code	–	E2L 6H3G1R 3T5G1R 7N8
18pays_code	–	2	text	enumeration	–	CAca
19courriel	–	2,992	text	email	–	aaa9999@aaaaa.aaaaaaaaaa999@aaaaa.aaaaaaaaaa99@aaaaa.aaaaaaa
20telephone	–	1,604	text	phone	–	+9-999-999-9999+9 999-999-9999
21id_contrat	0.3%9	2,983	text	–	–	CTR-1000002347CTR-1000055908CTR-1000090070
22type_contrat	0.07%2	6	text	enumeration	–	autohabitationvoyage
23date_debut	–	2,409	date	date	0.23%7	2017-10-092024-03-232026-05-02
24date_fin	16.73%502	1,177	date	date	0.12%3	2026-12-292027-01-092027-06-03
25statut_contrat	–	6	text	enumeration	–	actifexpirésuspendu
26prime_annuelle	–	2,975	number	–	–	2556.061019.341026.39
27frequence_paiement	–	6	text	enumeration	–	mensuelleannuelletrimestrielle
28mode_paiement	–	9	text	enumeration	–	prélèvementcartevirement
29agence_code	–	27	text	enumeration	–	AG-PR-001AG-PR-002AG-PR-005
30date_creation	–	2,361	date	date	0.2%6	2020-10-232017-08-192018-09-13
31date_modification	–	2,035	date	date	0.1%3	2026-09-062025-05-282026-06-27
32date_reclamation	86.0%2,580	406	date	date	0.24%1	10-12-202512-06-20262019-02-06
33montant_reclamation	88.37%2,651	344	number	–	–	0.0014731.85-63902.75
34reclamation_status	85.33%2,560	4	text	–	–	ferméen_coursouvert

04 / Cleaning

Transformations(34)

Occurrences changed by each normalization stage, and the spellings it groups. Raw preview values remain unchanged.

Column	Unicode composed	Trimmed	Whitespace collapsed	Case folded	Accents removed	Distinct	Compared distinct	Variant groups
1filiale	–	–	–	–	–	3	3	0
2id_client	–	–	–	100.0%3,000	–	2,992	2,992	0
3civilite	–	–	–	100.0%3,000	–	2	2	0
4prenom	–	–	0.2%6	99.43%2,983	17.87%536	227	213	13
5nom	–	–	0.17%5	99.33%2,980	8.67%260	214	202	12
6date_naissance	–	–	–	–	–	2,889	2,889	0
7sexe	–	–	–	100.0%3,000	–	2	2	0
8langue_preferee	–	–	–	–	–	2	2	0
9numero_voie	–	–	–	–	–	2,576	2,576	0
10type_voie	–	–	–	29.97%899	6.17%185	31	28	3
11nom_voie	–	–	0.3%9	99.57%2,987	20.37%611	175	160	20
12orientation	–	–	–	24.0%720	–	8	8	0
13appartement	–	–	–	–	–	665	665	0
14ville	–	–	0.23%7	99.53%2,986	27.07%812	135	122	13
15province_code	–	–	–	99.13%2,974	–	16	13	3
16province_nom	–	–	–	99.6%2,988	75.13%2,254	18	13	4
17code_postal	–	–	1.8%54	100.0%3,000	–	2,962	2,962	3
18pays_code	–	–	–	99.27%2,978	–	2	1	1
19courriel	–	–	0.2%6	–	–	2,992	2,992	0
20telephone	–	–	1.4%42	–	–	1,604	1,604	0
21id_contrat	–	–	–	99.7%2,991	–	2,983	2,983	0
22type_contrat	–	–	–	0.2%6	–	6	6	0
23date_debut	–	–	–	–	–	2,409	2,409	0
24date_fin	–	–	–	–	–	1,177	1,177	0
25statut_contrat	–	–	–	0.17%5	17.57%527	6	6	0
26prime_annuelle	–	–	–	–	–	2,975	2,975	0
27frequence_paiement	–	–	–	0.1%3	–	6	6	0
28mode_paiement	–	–	–	0.27%8	59.73%1,792	9	7	2
29agence_code	–	–	–	100.0%3,000	–	27	27	0
30date_creation	–	–	–	–	–	2,361	2,361	0
31date_modification	–	–	–	–	–	2,035	2,035	0
32date_reclamation	–	–	–	–	–	406	406	0
33montant_reclamation	–	–	–	–	–	344	344	0
34reclamation_status	–	–	–	–	8.23%247	4	4	0

Variant groups(74)

Raw spellings that every normalization stage compares as equal: an analytical equivalence, not proof of identity. Whitespace is shown as written.

Column	Comparison key	Occurrences	Spellings	Variants
4prenom	`daniel`	48	2	Daniel47daniel1
4prenom	`melanie`	36	2	Mélanie35melanie1
4prenom	`sylvie`	36	2	Sylvie35sylvie1
4prenom	`diane`	25	2	Diane24diane1
4prenom	`francois`	25	3	François23Francois1francois1
4prenom	`veronique`	24	2	Véronique23Veronique1
4prenom	`leo`	23	2	Léo17Leo6
4prenom	`pierre`	23	2	Pierre22pierre1
4prenom	`lucas`	20	2	Lucas19lucas1
4prenom	`florence`	19	2	Florence18florence1
4prenom	`louis-philippe`	17	2	Louis-Philippe16louis-philippe1
4prenom	`sofia`	15	2	Sofia14sofia1
4prenom	`zoe`	13	2	Zoé12Zoe1
5nom	`fortin`	68	2	Fortin67fortin1
5nom	`gagnon`	60	2	Gagnon59gagnon1
5nom	`wilson`	43	2	Wilson42wilson1
5nom	`poirier`	32	2	Poirier31poirier1
5nom	`dube`	30	2	Dubé29dube1
5nom	`cloutier`	28	2	Cloutier27cloutier1
5nom	`martel`	28	2	Martel27martel1
5nom	`baker`	23	2	Baker22baker1
5nom	`michaud`	21	2	Michaud20michaud1
5nom	`evans`	12	2	Evans11evans1
5nom	`collins`	11	2	Collins10collins1
5nom	`ho`	5	2	Ho4ho1
10type_voie	`avenue`	445	2	avenue324Avenue121
10type_voie	`boulevard`	409	2	boulevard311Boulevard98
10type_voie	`place`	116	2	place84Place32
11nom_voie	`des melezes`	79	2	des Mélèzes78des Mélèzes1
11nom_voie	`des erables`	67	2	des Érables65des erables2
11nom_voie	`du belvedere`	66	2	du Belvédère65du Belvedere1
11nom_voie	`des champs`	63	3	des Champs60des champs2des Champs1
11nom_voie	`de la riviere`	62	3	de la Rivière60de la Riviere1de la riviere1
11nom_voie	`des lilas`	62	2	des Lilas61des lilas1
11nom_voie	`des peupliers`	58	2	des Peupliers57des Peupliers1
11nom_voie	`du boise`	57	2	du Boisé56du Boisé1
11nom_voie	`des hirondelles`	54	2	des Hirondelles53des hirondelles1
11nom_voie	`de l'aube`	49	3	de l'Aube47de l'Aube1de l'aube1
11nom_voie	`des cedres`	48	2	des Cèdres47des Cedres1
11nom_voie	`de la colline`	47	2	de la Colline46de la Colline1
11nom_voie	`de la clairiere`	46	2	de la Clairière45de la Clairiere1
11nom_voie	`des vents`	39	2	des Vents38des vents1
11nom_voie	`oak`	33	2	Oak32oak1
11nom_voie	`du rocher`	29	2	du Rocher27du Rocher2
11nom_voie	`highland`	29	2	Highland28highland1
11nom_voie	`des frenes`	26	2	des Frênes25des Frenes1
11nom_voie	`forest`	20	2	Forest19forest1
11nom_voie	`des trois-lacs`	17	2	des Trois-Lacs16des Trois-Lacs1
14ville	`montreal`	321	3	Montréal318montreal2Montreal1
14ville	`quebec`	184	2	Québec183quebec1
14ville	`toronto`	102	2	Toronto101toronto1
14ville	`longueuil`	100	2	Longueuil98longueuil2
14ville	`levis`	97	2	Lévis96Levis1
14ville	`trois-rivieres`	70	2	Trois-Rivières69trois-rivieres1
14ville	`saint-jerome`	49	2	Saint-Jérôme48saint-jerome1
14ville	`chateauguay`	32	3	Châteauguay30Chateauguay1chateauguay1
14ville	`alma`	24	2	Alma23alma1
14ville	`joliette`	21	2	Joliette20joliette1
14ville	`la tuque`	20	2	La Tuque19La Tuque1
14ville	`kelowna`	8	2	Kelowna7kelowna1
14ville	`toront o`	2	2	Toront o1Toront o1
15province_code	`qc`	2,242	2	QC2,224qc18
15province_code	`on`	410	2	ON407on3
15province_code	`ab`	94	2	AB92ab2
16province_nom	`quebec`	2,244	3	Québec2,224Quebec10quebec10
16province_nom	`ontario`	410	2	Ontario409ontario1
16province_nom	`colombie-britannique`	86	2	Colombie-Britannique85colombie-britannique1
16province_nom	`nouvelle-ecosse`	24	2	Nouvelle-Écosse23Nouvelle-Ecosse1
17code_postal	`h2x 9m5`	2	2	H2X 9M51H2X 9M51
17code_postal	`h3g 1y7`	2	2	H3G 1Y71H3G 1Y71
17code_postal	`j6w 2c0`	2	2	J6W 2C01J6W 2C01
18pays_code	`ca`	3,000	2	CA2,978ca22
28mode_paiement	`prelevement`	1,649	2	prélèvement1,633prelevement16
28mode_paiement	`cheque`	157	2	chèque156cheque1

05 / Numeric

Numeric analysis(4)

Range and distribution statistics for accepted numeric values.

Column	Range	Minimum	Maximum	Mean	Median	Distinct	Examples
9numero_voie	9,988	11	9,999	4,947.492	4,858	2,576	418583989730
13appartement	997	1	998	508.1278	501	665	791795958
26prime_annuelle	8,046.12	-3,097.96	4,948.16	1,224.0938	1,101.34	2,975	2556.061019.341026.39
33montant_reclamation	243,898.63	-63,902.75	179,995.88	28,917.0332	19,513.98	344	0.0014731.85-63902.75

06 / Dates

Date analysis(6)

Strict date parsing keeps ambiguous, invalid and non-date values separate. Ambiguous values are never resolved from the other values of the column.

Column	Status	Valid	Ambiguous	Invalid	Other	Distinct	Formats
6date_naissance	mixed	88.01%2,635	11.89%356	0.1%3	–	2,889	6 variants
23date_debut	mixed	88.6%2,658	11.17%335	0.23%7	–	2,409	5 variants
24date_fin	mixed	88.91%2,221	10.97%274	0.12%3	–	1,177	6 variants
30date_creation	mixed	89.83%2,695	9.97%299	0.2%6	–	2,361	4 variants
31date_modification	mixed	89.47%2,684	10.43%313	0.1%3	–	2,035	5 variants
32date_reclamation	mixed	87.14%366	12.62%53	0.24%1	–	406	3 variants

07 / Text

String analysis(24)

Length classes, fixed widths and representative values.

Column	Class	Fixed	Min	Max	Mean	Median	Distinct	Examples
1filiale	short	–	6	9	8.27	9.0	3	principalquebecontario
2id_client	short	–	9	13	11.83	12.0	2,992	CLI-00002347ONT0011035CLI-0000043
3civilite	very short	–	2	3	2.49	2.0	2	M.Mme
4prenom	short	–	3	14	6.29	6.0	227	DanielJulieMélanie
5nom	short	–	2	10	6.22	6.0	214	FortinTremblayMorin
7sexe	very short	1	–	–	–	–	2	M
8langue_preferee	very short	2	–	–	–	–	2	fr
10type_voie	short	–	3	9	5.81	6.0	31	avenueboulevardroute
11nom_voie	short	–	3	18	9.82	10.0	175	du Moulindes Champsdes Mélèzes
12orientation	very short	–	3	5	4.01	4.0	8	OuestNordSud
14ville	medium	–	4	24	9.0	8.0	135	MontréalQuébecSherbrooke
15province_code	very short	2	–	–	–	–	16	QC
16province_nom	medium	–	5	25	7.03	6.0	18	QuébecOntarioColombie-Britannique
17code_postal	short	–	6	7	6.99	7.0	2,962	E2L 6H31K 1T8
18pays_code	very short	2	–	–	–	–	2	CA
19courriel	medium	–	17	38	25.34	25.0	2,992	aaa9999@aaaaa.aaaaaaaaaaaaa999@aaaaaaa.aaaaaaaaaa9999@aaaaaaa.aaaaaaa
20telephone	short	15	–	–	–	–	1,604	+9-999-999-9999
21id_contrat	short	–	13	15	14.0	14.0	2,983	CTR-1000002347CTR--1000004074
22type_contrat	short	–	3	12	6.06	4.0	6	autohabitationvoyage
25statut_contrat	short	–	5	8	5.42	5.0	6	actifexpirésuspendu
27frequence_paiement	short	–	8	13	9.33	9.0	6	mensuelleannuelletrimestrielle
28mode_paiement	short	–	5	13	8.81	11.0	9	prélèvementcartevirement
29agence_code	short	–	9	10	9.01	9.0	27	AG-PR-001AG--PR-001
34reclamation_status	short	–	5	8	6.08	6.0	4	ferméen_coursouvert

08 / Detectors

Detectors and formats(27)

What each detector recognized per column, with the formats it found. Primary: the interpretation shown as semantic type.

Column	Detector	Matched	Ambiguous	Invalid	Formats
1filiale	enumeration primary	100.0%3,000	0	0	–
3civilite	enumeration primary	100.0%3,000	0	0	–
6date_naissance	date	88.01%2,635	356	3	YYYY-MM-DDDD-MM-YYYYMM-DD-YYYYYYYY/MM/DDDD/MM/YYYYMM/DD/YYYY
7sexe	enumeration primary	100.0%3,000	0	0	–
8langue_preferee	enumeration primary	100.0%3,000	0	0	–
9numero_voie	number primary	100.0%3,000	0	0	0
10type_voie	enumeration primary	100.0%3,000	0	0	–
12orientation	enumeration primary	100.0%720	0	0	–
13appartement	number primary	100.0%1,072	0	0	0
15province_code	enumeration primary	100.0%2,997	0	0	–
16province_nom	enumeration primary	100.0%3,000	0	0	–
17code_postal	postal_code primary	99.3%2,979	0	0	A9A 9A9
18pays_code	enumeration primary	100.0%3,000	0	0	–
19courriel	email primary	99.6%2,988	0	12	–
20telephone	phone primary	100.0%3,000	0	0	+1-999-999-9999+1 999-999-9999
22type_contrat	enumeration primary	100.0%2,998	0	0	–
23date_debut	date	88.6%2,658	335	7	YYYY-MM-DDDD-MM-YYYYMM-DD-YYYYYYYY/MM/DDDD/MM/YYYY
24date_fin	date	88.91%2,221	274	3	YYYY-MM-DDDD-MM-YYYYMM-DD-YYYYDD/MM/YYYYYYYY/MM/DDMM/DD/YYYY
25statut_contrat	enumeration primary	100.0%3,000	0	0	–
26prime_annuelle	number primary	100.0%3,000	0	0	0.0
27frequence_paiement	enumeration primary	100.0%3,000	0	0	–
28mode_paiement	enumeration primary	100.0%3,000	0	0	–
29agence_code	enumeration primary	100.0%3,000	0	0	–
30date_creation	date	89.83%2,695	299	6	YYYY-MM-DDDD-MM-YYYYMM-DD-YYYYYYYY/MM/DD
31date_modification	date	89.47%2,684	313	3	YYYY-MM-DDDD-MM-YYYYMM-DD-YYYYYYYY/MM/DDDD/MM/YYYY
32date_reclamation	date	87.14%366	53	1	YYYY-MM-DDDD-MM-YYYYMM-DD-YYYY
33montant_reclamation	number primary	100.0%349	0	0	0.0

10 / Raw values

Data sample(20)

First 20 records with original row numbers and raw values.

Row	filialetext	id_clienttext	civilitetext	prenomtext	nomtext	date_naissancedate	sexetext	langue_prefereetext	numero_voieinteger	type_voietext	nom_voietext	orientationtext	appartementinteger	villetext	province_codetext	province_nomtext	code_postaltext	pays_codetext	courrieltext	telephonetext	id_contrattext	type_contrattext	date_debutdate	date_findate	statut_contrattext	prime_annuellenumber	frequence_paiementtext	mode_paiementtext	agence_codetext	date_creationdate	date_modificationdate	date_reclamationdate	montant_reclamationnumber	reclamation_statustext
1	principal	CLI-00000281	Mme	Lucie	Roy	1961-03-31	F	fr	4682	chemin	des Tulipes	empty	245	Montréal	QC	Québec	H4A 9M3	CA	aa9999@aaaaa.aaaaaaa	+9-999-999-9999	CTR-1000000281	auto	2020-07-16	2026-12-28	actif	1234.18	mensuelle	chèque	AG-PR-001	2020-07-08	2024-10-24	empty	empty	empty
2	principal	CLI-00000432	Mme	Suzanne	Taylor	1983-01-14	F	fr	518	rue	des Trois-Lacs	empty	405	Lévis	QC	Québec	G6V 8P2	CA	aaa9999@aaaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000000432	vie	2027-06-02	2021-11-27	actif	1123.69	mensuelle	prélèvement	AG-PR-003	2021-11-09	2021-11-22	empty	empty	empty
3	principal	CLI-00000538	Mme	Juliette	Michaud	1941-09-10	F	fr	2943	avenue	des Vents	empty	empty	Granby	QC	Québec	J2H 0H3	CA	aaa99@aaaaa.aaaaaaa	+9-999-999-9999	CTR-1000000538	voyage	2016-09-30	2022-07-20	résilié	379.29	mensuelle	prélèvement	AG-PR-001	2016-09-16	2017-04-05	empty	empty	empty
4	principal	CLI-0000072	M.	Oliivier	Landry	1936-12-13	M	fr	6132	route	des Prairies	empty	519	Repentigny	QC	Québec	J5Y 2J3	CA	aaaaaa.aaaaaaa@aaaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000000726	auto	2023-03-29	2027-05-07	actif	-744.79	mensuelle	prélèvement	AG-PR-004	2023-03-04	2024-06-01	empty	empty	empty
5	principal	CLI-00000892	Mme	Nicole	Tremblay	1943-04-16	F	fr	9307	chemin	des Ormes	empty	empty	Québec	QC	Québec	G2B 7V8	CA	aaaaaaaaaaaaaa@aaaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000000892	voyage	2017-05-26	2018-11-19	résilié	241.17	mensuelle	prélèvement	AG-PR-004	2017-05-12	2019-10-29	empty	empty	empty
6	principal	CLI-00001006	M.	Luke	Pham	1979-07-29	M	en	2174	Street	Riverside	empty	empty	Winnipeg	MB	Manitoba	R3C 4S8	CA	aaaaa@aaaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000001006	auto	2025-05-17	2026-07-30	expiré	695.97	mensuelle	prélèvement	AG-PR-008	2025-04-17	2026-06-07	2026-05-13	24940.92	rejeté
7	principal	CLI-00001095	M.	Émile	Lavoie	1996-03-27	M	fr	909	rue	du Lac	empty	358	Lévis	QC	Québec	G6V 8A4	CA	aaaaa.aaaaaa@aaaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000001095	auto	2025-03-16	2027-01-30	actif	1144.35	annuelle	prélèvement	AG-PR-005	2025-02-28	2025-10-06	empty	empty	empty
8	principal	CLI-00001384	Mme	Catherine	Gagné	1958-01-22	F	fr	6362	promenade	des Geais-Bleus	Ouest	empty	Lévis	QC	Québec	G6W 9E4	CA	aaaaaa@aaaaa.aaaaaaa	+9-999-999-9999	CTR-1000001384	voyage	2018-07-30	empty	actif	433.12	mensuelle	prélèvement	AG-PR-001	2018-07-08	2026-01-16	empty	empty	empty
9	principal	CLI-00001430	M.	Jack	Chowdhury	1987-11-05	M	en	7641	Place	Pine	empty	empty	Toronto	ON	Ontario	M6G 7M3	CA	aaaa99@aaaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000001430	habitation	2022-06-11	empty	actif	1509.17	mensuelle	prélèvement	AG-PR-001	2022-06-10	2023-02-24	empty	empty	empty
10	principal	CLI--00001642	Mme	Catherine	Caron	1981-09-04	F	fr	528	rue	de l'Aube	empty	empty	Montréal	QC	Québec	H4A 4S8	CA	aaaaaaaaaaaaaa@aaaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000001642	voyage	2022-09-27	2027-05-13	actif	405.78	mensuelle	prélèvement	AG-PR-004	2022-09-11	2023-08-08	empty	empty	empty
11	principal	CLI-00001668	Mme	sofia	baker	1942-02-06	F	en	1544	Avenue	oak	empty	557	chateauguay	QC	quebec	J6J 3K7	CA	aaaaaaaaaa@aaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000001668	vie	2024-09-11	2027-07-11	actif	1043.75	mensuelle	prélèvement	AG-PR-006	2024-08-24	2026-04-01	empty	empty	empty
12	principal	CLI-00001783	Mme	Aria	Thompson	1995-03-16	F	en	876	Avenue	School	empty	empty	Ottawg	ON	Ontario	K1A 4T0	CA	aaaaaaaa99@aaaaa.aaaaaaa	+9-999-999-9999	CTR-1000001783	auto	2017-07-01	2027-04-23	actif	672.10	annuelle	prélèvement	AG-PR-004	2017-06-04	2019-07-31	empty	empty	empty
13	principal	CLI-00001927	M.	Jean	Côté	1994-09-21	M	fr	2629	route	de la Traverse	Nord	991	Mnotréal	QC	Québec	H2X 4P4	CA	aaaaaaaa@aaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000001927	habitation	2021-02-26	2027-02-23	actif	2727.70	annuelle	chèque	AG-PR-007	2021-02-03	2022-11-27	empty	empty	empty
14	principal	CLI-00002289	M.	Maxime	Gagnon	1959-11-12	M	fr	5066	avenue	du Parc	empty	244	Québec	QC	Québec	G2B 5E5	CA	aaaaaaaaaaaa@aaaaa.aaaaaaa	+9-999-999-9999	CTR-1000002289	auto	2026-01-07	2026-12-24	actif	1428.63	mensuelle	prélèvement	AG-PR-001	2025-12-16	2026-02-28	empty	empty	empty
15	principal	CLI-00002347	M.	Émile	Rodriguez	1996-05-21	M	fr	2985	rue	des Saules	empty	283	Québec	QC	Québec	G2B 9H7	CA	aaaaa.aaaaaaaaa@aaaaa.aaaaaaa	+9-999-999-9999	CTR-1000002347	voyage	2023-02-16	empty	actif	652.13	mensuelle	prélèvement	AG-PR-004	2023-02-05	2026-02-01	empty	empty	empty
16	principal	CLI-00002991	M.	Michael	Walker	2001-11-15	M	en	9868	Way	Spring	empty	empty	Québec	QC	Québec	G2B 2E7	CA	aaaaaaa_aaaaaa@aaaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000002991	vie	2025-08-01	2027-03-08	actif	2798.92	mensuelle	prélèvement	AG-PR-005	2025-08-01	2026-01-05	empty	empty	empty
17	principal	CLI-00003000	Mme	Marie	Patel	1979-11-10	F	fr	4453	rue	du Havre	empty	868	Québec	QC	Québec	G1V 4H0	CA	aaaaa9999@aaaaa.aaaaaaa	+9-999-999-9999	CTR-1000003000	habitation	2020-01-28	2027-03-15	actif	2147.32	mensuelle	prélèvement	AG-PR-006	2020-01-16	2022-09-15	empty	empty	empty
18	principal	CLI-00003159	Mme	Anne	Paquette	1943-03-15	F	fr	2897	croissant	du Moulin	empty	empty	Montréal	QC	Québec	H4A 3C2	CA	aaaa99@aaaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000003159	auto	2024-12-20	2027-04-15	actif	1731.59	mensuelle	carte	AG-PR-007	2024-12-08	2026-02-09	empty	empty	empty
19	principal	CLI-00003200	M.	Sylvain	Silva	1966-09-14	M	fr	26	carré	des Lilas	empty	empty	Hamilton	ON	Ontario	L8S 1B2	CA	aaaaaaa_aaaaa@aaaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000003200	vie	2026-06-14	2027-05-14	actif	4319.82	mensuelle	prélèvement	AG-PR-003	2026-05-19	2026-06-08	empty	empty	empty
20	principal	CLI-00003271	M.	Jean-Philippe	Ouellet	1978-04-11	M	fr	6502	avenue	des Champs	Ouest	empty	Fredericton	NB	Nouveau-Brunswick	E3B 3G8	CA	aaaaaaaaaaaa.aaaaaaa@aaaaaaa.aaaaaaa	+9-999-999-9999	CTR-1000003271	vie	2024-02-22	2026-11-10	actif	1253.03	mensuelle	prélèvement	AG-PR-001	2024-02-04	2025-05-28	empty	empty	empty

11 / Method

Analysis settings

Rules used for this analysis, so the result can be reproduced.

Scope: All 3,000 records
Missing values: absent, null, empty, blank, marker; markers: "N/A" "NULL"
Marker comparison: Whitespace trimmed; case-sensitive
Value normalization: Unicode composition (NFC): enabled; trim: enabled; collapse internal whitespace: enabled; comparison also with case folding: enabled, accents removed: enabled. Raw preview values are preserved.
Duplicate comparison: Exact raw values across every column; up to 2,000,000 distinct records compared
Type inference: At least 95.0% agreement across present values; numbers with dot or comma decimals, configured dates and true/false. Leading-zero identifiers remain text.
Date detection: Orders: YMD, MDY, DMY; separators: "-" "/" "." ; month names: en, fr; ambiguous order: unresolved, column evidence shown but never applied
Semantic types: Dates, or the only detector matching at least 95.0% of present values
Adaptive detection: Every detector on the first 10,000 distinct values of each column; detectors that recognized none of them, or at most 0.1% of them and none of the last 5,000, then skip the others, except about 1 value in 100. Number and date detection always test every value
Enumerations: At most 49 distinct values among at least 500 present values
Sensitive values: Masked in examples and the data sample
String lengths: Very short through 5; short through 20; medium through 50; long through 255; otherwise very long. Up to 10 examples per length are retained when the maximum is 50 or less.
Value representation: Complete through 50 distinct values; otherwise a reproducible sample of 100 distinct values
Row numbering: Data records start at 1, excluding the header. Quoted multiline values count as one record.
Preview selection: First 20 records; raw values preserved
JSON format: 0.1.0a - revision 11 (experimental)

SOURCE SHA-25619a6bbb20f91125c6d212c74bfe7d9b8710f114e36042a3179dfec6f18b62389