Générateur de données


Cette page permet de générer automatiquement des informations concernant 100 personnes différentes dans une table.

La table contient 4 attributs :
Voici les données des 100 personnes clairement présentées sous forme de tableau :

idnomprenomsexe
1DAUXIANElsaF
2SWERTVAEGERDidierM
3BELUAUTimothéM
4MARTORAAmélieF
5DJELOUDANEAnthonyM
6RIQUIERGeorgesM
7BERNARDJulesM
8LANOERomualdM
9DABONNoémieF
10RABAHIFrédéricM
11AMANDJulieF
12BOISSEAULianeF
13LUYCKXRoseF
14DORONGisèleF
15LEHOUXSheilaF
16GALLOISBastienM
17GUERRAOUIRenéeF
18VASSEMONLudivineF
19THOMASCharlesM
20KERVADECRobinM
21PARISRémiM
22CHAMPENOISLaurentM
23HERVIEUArletteF
24BLANDETSabrinaF
25EUSTACHEMartineF
26LEGRANDSylvainM
27DURIEULucyF
28HUEPierretteF
29SEHIERAbrahamM
30MADELAINERégineF
31DELOVINAMurielF
32DELAROCHEMarieF
33BOYONStellaF
34JALONLésiaF
35RAMPNOUXGrégoryM
36CHAVANTGillesM
37COMESEnzoM
38ANTUNESMargueriteF
39MARIEJeanneF
40LE BOUCHERMathildeF
41GUITONEnoraF
42BONEÉmileM
43DUPUISSyndieF
44BAZOUDFrancisM
45NIELLEZMathieuM
46FERREIRAMélanieF
47LESOIFRaoulM
48STILOSergeM
49HAMARDBriceM
50BONNETJeanM
51HOUELHenrietteF
52BORNEÉvelineF
53LEROUXHerculeM
54LEDUFAUDBalthazarM
55SARRAZINGabrielM
56LETHIMONNIERAlphonseM
57ROULLANDBenoitM
58MANCELLénaF
59LECHAUVEAmandineF
60DOUCETGaspardM
61ELKABBADJGérardM
62HEDDIBénédicteF
63DEMMERNinaF
64BECQUETNadineF
65MATHIEUFlorianM
66CAILLIOTTimothéeM
67HEONFlorenceF
68BORRELAlexandreM
69HOSNIÉmilieF
70COUESBOTFabienneF
71LERICHELucetteF
72COLOMBDanielM
73LAZARREMarjolaineF
74LABOULAISLyneF
75SCHINKDavidM
76LEMENORELAnémoneF
77ADIBOBaptisteM
78MARTELThomasM
79LE BANNARDColetteF
80TIENERCorinneF
81COLASNicolasM
82LECOMTELéonardM
83BONHOMMEBarbaraF
84JANYMaxenceM
85DUPINLucM
86DURELCédricM
87BEUZELINAlexendraF
88FLEURYAndréeF
89TANQUEAnnaF
90VAN CAUTERBrunoM
91HUETBrigitteF
92MICHELFrédériqueF
93BELLAMYVéroniqueF
94SALLAÏAntoineM
95MORELGertrudeF
96JOUVEBlaiseM
97LAURENCEOliviaF
98POIRIERYvetteF
99VALINNolwennF
100LAZZARIRolandM

Voici les données de cette table au format CSV :
1,"DAUXIAN","Elsa","F"
2,"SWERTVAEGER","Didier","M"
3,"BELUAU","Timothé","M"
4,"MARTORA","Amélie","F"
5,"DJELOUDANE","Anthony","M"
6,"RIQUIER","Georges","M"
7,"BERNARD","Jules","M"
8,"LANOE","Romuald","M"
9,"DABON","Noémie","F"
10,"RABAHI","Frédéric","M"
11,"AMAND","Julie","F"
12,"BOISSEAU","Liane","F"
13,"LUYCKX","Rose","F"
14,"DORON","Gisèle","F"
15,"LEHOUX","Sheila","F"
16,"GALLOIS","Bastien","M"
17,"GUERRAOUI","Renée","F"
18,"VASSEMON","Ludivine","F"
19,"THOMAS","Charles","M"
20,"KERVADEC","Robin","M"
21,"PARIS","Rémi","M"
22,"CHAMPENOIS","Laurent","M"
23,"HERVIEU","Arlette","F"
24,"BLANDET","Sabrina","F"
25,"EUSTACHE","Martine","F"
26,"LEGRAND","Sylvain","M"
27,"DURIEU","Lucy","F"
28,"HUE","Pierrette","F"
29,"SEHIER","Abraham","M"
30,"MADELAINE","Régine","F"
31,"DELOVINA","Muriel","F"
32,"DELAROCHE","Marie","F"
33,"BOYON","Stella","F"
34,"JALON","Lésia","F"
35,"RAMPNOUX","Grégory","M"
36,"CHAVANT","Gilles","M"
37,"COMES","Enzo","M"
38,"ANTUNES","Marguerite","F"
39,"MARIE","Jeanne","F"
40,"LE BOUCHER","Mathilde","F"
41,"GUITON","Enora","F"
42,"BONE","Émile","M"
43,"DUPUIS","Syndie","F"
44,"BAZOUD","Francis","M"
45,"NIELLEZ","Mathieu","M"
46,"FERREIRA","Mélanie","F"
47,"LESOIF","Raoul","M"
48,"STILO","Serge","M"
49,"HAMARD","Brice","M"
50,"BONNET","Jean","M"
51,"HOUEL","Henriette","F"
52,"BORNE","Éveline","F"
53,"LEROUX","Hercule","M"
54,"LEDUFAUD","Balthazar","M"
55,"SARRAZIN","Gabriel","M"
56,"LETHIMONNIER","Alphonse","M"
57,"ROULLAND","Benoit","M"
58,"MANCEL","Léna","F"
59,"LECHAUVE","Amandine","F"
60,"DOUCET","Gaspard","M"
61,"ELKABBADJ","Gérard","M"
62,"HEDDI","Bénédicte","F"
63,"DEMMER","Nina","F"
64,"BECQUET","Nadine","F"
65,"MATHIEU","Florian","M"
66,"CAILLIOT","Timothée","M"
67,"HEON","Florence","F"
68,"BORREL","Alexandre","M"
69,"HOSNI","Émilie","F"
70,"COUESBOT","Fabienne","F"
71,"LERICHE","Lucette","F"
72,"COLOMB","Daniel","M"
73,"LAZARRE","Marjolaine","F"
74,"LABOULAIS","Lyne","F"
75,"SCHINK","David","M"
76,"LEMENOREL","Anémone","F"
77,"ADIBO","Baptiste","M"
78,"MARTEL","Thomas","M"
79,"LE BANNARD","Colette","F"
80,"TIENER","Corinne","F"
81,"COLAS","Nicolas","M"
82,"LECOMTE","Léonard","M"
83,"BONHOMME","Barbara","F"
84,"JANY","Maxence","M"
85,"DUPIN","Luc","M"
86,"DUREL","Cédric","M"
87,"BEUZELIN","Alexendra","F"
88,"FLEURY","Andrée","F"
89,"TANQUE","Anna","F"
90,"VAN CAUTER","Bruno","M"
91,"HUET","Brigitte","F"
92,"MICHEL","Frédérique","F"
93,"BELLAMY","Véronique","F"
94,"SALLAÏ","Antoine","M"
95,"MOREL","Gertrude","F"
96,"JOUVE","Blaise","M"
97,"LAURENCE","Olivia","F"
98,"POIRIER","Yvette","F"
99,"VALIN","Nolwenn","F"
100,"LAZZARI","Roland","M"

Et voici ces mêmes données au format SQL :
INSERT INTO personne (id, nom, prenom, sexe) VALUES (1,"DAUXIAN","Elsa","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (2,"SWERTVAEGER","Didier","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (3,"BELUAU","Timothé","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (4,"MARTORA","Amélie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (5,"DJELOUDANE","Anthony","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (6,"RIQUIER","Georges","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (7,"BERNARD","Jules","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (8,"LANOE","Romuald","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (9,"DABON","Noémie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (10,"RABAHI","Frédéric","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (11,"AMAND","Julie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (12,"BOISSEAU","Liane","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (13,"LUYCKX","Rose","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (14,"DORON","Gisèle","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (15,"LEHOUX","Sheila","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (16,"GALLOIS","Bastien","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (17,"GUERRAOUI","Renée","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (18,"VASSEMON","Ludivine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (19,"THOMAS","Charles","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (20,"KERVADEC","Robin","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (21,"PARIS","Rémi","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (22,"CHAMPENOIS","Laurent","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (23,"HERVIEU","Arlette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (24,"BLANDET","Sabrina","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (25,"EUSTACHE","Martine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (26,"LEGRAND","Sylvain","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (27,"DURIEU","Lucy","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (28,"HUE","Pierrette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (29,"SEHIER","Abraham","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (30,"MADELAINE","Régine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (31,"DELOVINA","Muriel","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (32,"DELAROCHE","Marie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (33,"BOYON","Stella","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (34,"JALON","Lésia","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (35,"RAMPNOUX","Grégory","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (36,"CHAVANT","Gilles","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (37,"COMES","Enzo","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (38,"ANTUNES","Marguerite","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (39,"MARIE","Jeanne","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (40,"LE BOUCHER","Mathilde","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (41,"GUITON","Enora","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (42,"BONE","Émile","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (43,"DUPUIS","Syndie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (44,"BAZOUD","Francis","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (45,"NIELLEZ","Mathieu","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (46,"FERREIRA","Mélanie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (47,"LESOIF","Raoul","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (48,"STILO","Serge","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (49,"HAMARD","Brice","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (50,"BONNET","Jean","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (51,"HOUEL","Henriette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (52,"BORNE","Éveline","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (53,"LEROUX","Hercule","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (54,"LEDUFAUD","Balthazar","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (55,"SARRAZIN","Gabriel","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (56,"LETHIMONNIER","Alphonse","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (57,"ROULLAND","Benoit","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (58,"MANCEL","Léna","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (59,"LECHAUVE","Amandine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (60,"DOUCET","Gaspard","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (61,"ELKABBADJ","Gérard","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (62,"HEDDI","Bénédicte","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (63,"DEMMER","Nina","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (64,"BECQUET","Nadine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (65,"MATHIEU","Florian","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (66,"CAILLIOT","Timothée","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (67,"HEON","Florence","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (68,"BORREL","Alexandre","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (69,"HOSNI","Émilie","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (70,"COUESBOT","Fabienne","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (71,"LERICHE","Lucette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (72,"COLOMB","Daniel","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (73,"LAZARRE","Marjolaine","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (74,"LABOULAIS","Lyne","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (75,"SCHINK","David","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (76,"LEMENOREL","Anémone","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (77,"ADIBO","Baptiste","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (78,"MARTEL","Thomas","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (79,"LE BANNARD","Colette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (80,"TIENER","Corinne","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (81,"COLAS","Nicolas","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (82,"LECOMTE","Léonard","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (83,"BONHOMME","Barbara","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (84,"JANY","Maxence","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (85,"DUPIN","Luc","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (86,"DUREL","Cédric","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (87,"BEUZELIN","Alexendra","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (88,"FLEURY","Andrée","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (89,"TANQUE","Anna","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (90,"VAN CAUTER","Bruno","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (91,"HUET","Brigitte","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (92,"MICHEL","Frédérique","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (93,"BELLAMY","Véronique","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (94,"SALLAÏ","Antoine","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (95,"MOREL","Gertrude","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (96,"JOUVE","Blaise","M");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (97,"LAURENCE","Olivia","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (98,"POIRIER","Yvette","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (99,"VALIN","Nolwenn","F");
INSERT INTO personne (id, nom, prenom, sexe) VALUES (100,"LAZZARI","Roland","M");

Les données se récupèrent ci-dessus par un simple copier/coller (en sélectionnant le nombre de lignes souhaité) puis doivent être enregistrées dans un fichier texte sous l'éditeur Notepad++ avant de les insérer dans SQLite ou de lire le fichier texte avec Python.



nsi.gecif.net
© Janvier 2026