FichierBGdF

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

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=