esgi.fr
Oct 16, 2024
Database dump from ESGI (École Supérieure de Génie Informatique), a French IT engineering school. Contains student enrollment records including full names, personal email addresses, school email addresses (myges.fr), phone numbers, home addresses, postal codes, nationalities, class/promotion details, student IDs, and academic year information for students at ESGI Paris and ESGI Lyon campuses.
Data found in this dataset
Source files
Expand any file to inspect its column headers and the LLM's field-mapping reasoning, recorded during ingestion.
esgi_scolarites__esgi_scolarites.csv10 columns26,451 rows
File structure
Format: CSV·Delimiter: Comma·Has header: yes·Quote: "
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 12 | high | [12] header 'email', values are personal email addresses (gmail.com, mailo.com) | |
| 14 | high | [14] header 'id_ad_etudiant', values are school email addresses (@myges.fr domain) | |
| 16 | lastName | high | [16] header 'nom' (French for last name), values are uppercase surnames |
| 18 | firstName | high | [18] header 'prenom' (French for first name), values are given names |
| 20 | phone | high | [20] header 'telephone_mobile', values are French mobile phone numbers |
| 21 | phone | high | [21] header 'telephone_secondaire' (secondary phone), values are phone numbers |
| 24 | address1 | high | [24] header 'adresse_de_l_etudiant__street', values are street addresses |
| 25 | city | high | [25] header 'adresse_de_l_etudiant__city', values are French city names |
| 26 | zip | high | [26] header 'adresse_de_l_etudiant__postalcode', values are French postal codes |
| 27 | country | high | [27] header 'nationalite' (nationality), values are nationalities/countries (FRANCAISE, MALIENNE) |
Notes: 30 columns total, 10 contain PII. French-language Salesforce CRM export for ESGI students. 'nom' = last name, 'prenom' = first name in French. Column 14 (id_ad_etudiant) contains school email addresses (@myges.fr). Column 27 (nationalite) mapped to country as it indicates country of origin. Columns 0, 1, 13, 15, 17, 19, 28, 29 are internal Salesforce IDs (skipped). Columns 2-11, 22-23 are academic/enrollment metadata (skipped).