« FichierBGdF » : différence entre les versions

Dernière version du 16 septembre 2019 à 09:59

FICHIER DES ENREGISTREMENTS DES CARTES DE SÛRETÉ 1792-1795

Relevés de la Bibliothèque Généalogique de France

Invalid caracter : <0x0b> >> Encoding: UTF8

Remove leading and trailing spaces: value.trim() Collapse consecutive white space: value.replace(/\s+/,' ') Text to Number: value.toNumber()

carton

Common transforms
- Remove leading and trailing spaces: n=0
- Collapse consecutive white space: n=1
- Column renamed: S_carton

S_carton

Text facet: 29 choices

R_carton

column R_carton is based on S_carton: (value)

Common transform
- Clustering and merging: Text facet: 29 to 25 choices

no

Common transforms
- Remove leading and trailing spaces: n=0
- Collapse consecutive white space: n=0
- Column renamed: S_no

S_no

Text facet: 8962 choices

R_no

Column R_no is based on S_no: (value)

Common transforms
- Text to Number: (number), n=179392 ; blanck, n=2820 ; others, n=10

date

Common transforms
- Remove leading and trailing spaces: n=1
- Collapse consecutive white space: n=0

nom

Common transforms
- Remove leading and trailing spaces: n=4
- Collapse consecutive white space: n=16

prenom

Common transforms
- Remove leading and trailing spaces: n=0
- Collapse consecutive white space: n=51
- Column renamed: S_prenom

S_prenom

Text facet: 23286 choices

R_prenom

Column R_prenom is based on S_prenom: (value)

C_prenom

Column C_prenom is based on R_prenom: (value)

CC_prenoms

Text facet: 19557 choices

signe

Common transforms
- Remove leading and trailing spaces: n=1
- Collapse consecutive white space: n=1

age

Common transforms
- Remove leading and trailing spaces: n=0
- Collapse consecutive white space: n=0

profession

Common transforms
- Remove leading and trailing spaces: n=1
- Collapse consecutive white space: n=64

domicile_actuel

Common transforms
- Remove leading and trailing spaces: n=1
- Collapse consecutive white space: n=1446
- Column renamed: S_domicile_actuel

S_domicile_actuel

domicile_precedent

Common transforms
- Remove leading and trailing spaces: n=2
- Collapse consecutive white space: n=377

insee_domicile_precedent

Common transforms
- Remove leading and trailing spaces: n=1
- Collapse consecutive white space: n=1

date_arrivee_paris

Common transforms
- Remove leading and trailing spaces: n=1
- Collapse consecutive white space: n=198

ville_nais

Common transforms
- Remove leading and trailing spaces: n=1
- Collapse consecutive white space: n=184

ville_nais_lu

Common transforms
- Remove leading and trailing spaces: n=3
- Collapse consecutive white space: n=180

insee_ville_naissance

Common transforms
- Remove leading and trailing spaces: n=2
- Collapse consecutive white space: n=6

departement

Common transforms
- Remove leading and trailing spaces: n=1
- Collapse consecutive white space: n=17

signature

Common transforms
- Remove leading and trailing spaces: n=1
- Collapse consecutive white space: n=0

obs

Common transforms
- Remove leading and trailing spaces: n=482
- Collapse consecutive white space: n=938

domicile_ville

column removed

filiatif

column removed

type

column merged with "id" and then removed

id

column merged with "type" and then removed

C_Releve

Merge: cells["type"].value + "-" + cells["id"].value

Remove leading and trailing spaces: n=
Collapse consecutive white space: n=

Croisements de sources

Almanachs et Annuaires avec numérotations sectionnaires

@@ Ligne 9 : / Ligne 9 : @@
 [[Fichier:RegistreCartesSurete.png|vignette|centré]]
-== Codebook ==
+Invalid caracter : <0x0b>
-* cote (agrégé à "type") = Relevé
+>> Encoding: UTF8
-* carton
-* no
+Remove leading and trailing spaces: value.trim()
-* date
+Collapse consecutive white space: value.replace(/\s+/,' ')
-* nom
+Text to Number: value.toNumber()
-* prenom
-* signe
+=== carton ===
-* age
-* profession
+* Common transforms
-* domicile_actuel
+** Remove leading and trailing spaces: n=0
-* domicile_precedent
+** Collapse consecutive white space: n=1
-* insee_domicile_precedent
+** Column renamed: S_carton
-* date_arrivee_paris
-* ville_nais
+==== S_carton ====
-* ville_nais_lu
+Text facet: 29 choices
-* insee_ville_naissance
-* departement
+==== R_carton ====
-* signature
+column R_carton is based on S_carton: (value)
-* obs
-* domicile_ville
+* Common transform
-* type (agrégé à "cote") = Relevé
+** Clustering and merging: Text facet: 29 to 25 choices
-* filiatif (supprimé)
-* id (supprimé)
+=== no  ===
+* Common transforms
+** Remove leading and trailing spaces: n=0
+** Collapse consecutive white space: n=0
+** Column renamed: S_no
+==== S_no ====
+Text facet: 8962 choices
+==== R_no ====
+Column R_no is based on S_no: (value)
+* Common transforms
+** Text to Number: (number), n=179392 ; blanck, n=2820 ; others, n=10
+=== date  ===
+* Common transforms
+** Remove leading and trailing spaces: n=1
+** Collapse consecutive white space: n=0
+=== nom  ===
+* Common transforms
+** Remove leading and trailing spaces: n=4
+** Collapse consecutive white space: n=16
+=== prenom  ===
+* Common transforms
+** Remove leading and trailing spaces: n=0
+** Collapse consecutive white space: n=51
+** Column renamed: S_prenom
+==== S_prenom ====
+Text facet: 23286 choices
+==== R_prenom  ====
+Column R_prenom is based on S_prenom: (value)
+==== C_prenom  ====
+Column C_prenom is based on R_prenom: (value)
+==== CC_prenoms  ====
+Text facet: 19557 choices
+=== signe  ===
+* Common transforms
+** Remove leading and trailing spaces: n=1
+** Collapse consecutive white space: n=1
+=== age  ===
+* Common transforms
+** Remove leading and trailing spaces: n=0
+** Collapse consecutive white space: n=0
+=== profession  ===
+* Common transforms
+** Remove leading and trailing spaces: n=1
+** Collapse consecutive white space: n=64
+=== domicile_actuel  ===
+* Common transforms
+** Remove leading and trailing spaces: n=1
+** Collapse consecutive white space: n=1446
+** Column renamed: S_domicile_actuel
+==== S_domicile_actuel ====
+=== domicile_precedent  ===
+* Common transforms
+** Remove leading and trailing spaces: n=2
+** Collapse consecutive white space: n=377
+=== insee_domicile_precedent  ===
+* Common transforms
+** Remove leading and trailing spaces: n=1
+** Collapse consecutive white space: n=1
+=== date_arrivee_paris ===
+* Common transforms
+** Remove leading and trailing spaces: n=1
+** Collapse consecutive white space: n=198
+=== ville_nais  ===
+* Common transforms
+** Remove leading and trailing spaces: n=1
+** Collapse consecutive white space: n=184
+=== ville_nais_lu  ===
+* Common transforms
+** Remove leading and trailing spaces: n=3
+** Collapse consecutive white space: n=180
+=== insee_ville_naissance  ===
+* Common transforms
+** Remove leading and trailing spaces: n=2
+** Collapse consecutive white space: n=6
+=== departement  ===
+* Common transforms
+** Remove leading and trailing spaces: n=1
+** Collapse consecutive white space: n=17
+=== signature  ===
+* Common transforms
+** Remove leading and trailing spaces: n=1
+** Collapse consecutive white space: n=0
+=== obs  ===
+* Common transforms
+** Remove leading and trailing spaces: n=482
+** Collapse consecutive white space: n=938
+=== domicile_ville  ===
+column removed
+=== filiatif  ===
+column removed
+=== type ===
+column merged with "id" and then removed
+=== id  ===
+column merged with "type" and then removed
+=== C_Releve ===
+Merge: cells["type"].value + "-" + cells["id"].value
+* Remove leading and trailing spaces: n=
+* Collapse consecutive white space: n=
+== Croisements de sources ==
+=== Almanachs et Annuaires avec numérotations sectionnaires ===