Open Gauquelin Database Downloads

The downloadable CSV files are provided in two different formats :

• ISO
  The column separator is semicolon (;), and the dates are expressed using ISO 8601 format (YYYY-MM-DD HH:MM)
• SEP
  The column separator is comma (,), and the dates are expressed in separate columns: on column for year, one column for month etc.

Download full database

• Postgresql dump - to run opengauquelin on your local machine, see page INSTALL
• SEP
  ISO
  CSV export - Timed data
• SEP
  ISO
  CSV export - Timed and untimed data

Download historical datasets

Files coming from the history of statistical tests on astrology can be downloaded from page Historical datasets.

Download CSV lists by occupation

See page Lists by occupation.

Other downloads

Auxiliary files, like scans of original documents, can be downloaded from github.com/tig12/g5-aux

---

Format of the downloadable CSV files

The downloadable CSV files do not all have the same format. For example, outputs of the historical files (Gauquelin, Müller, Ertel, skeptics) sometimes contain fields coming from the original source (like Gauquelin sector position, eminence indications).

But some fields are standardized, the list below describe them.

Field name	Comments
Identifiers
OGID	Open Gauquelin Database unique id Looks like alard-pierre-1937-09-17. See the definition of OGDB unique id.
WDID	Wikidata unique id Looks like Q41390. Corresponds to the Wikidata id of an entity.
GQID	Gauquelin unique id Looks like A2-721. See the definition of Gauquelin unique id.
MUID	Müller unique id Looks like M1-325. See the definition of Müller unique id.
ERID	Ertel unique id Looks like ES-326 ; concerns only sportspersons. See the definition of Ertel unique id.
CSID	CSICOP unique id Looks like CS-153 ; concerns only sportspersons. See The definition of CSICOP unique id.
CPID	Comité Para unique id Looks like CP-153 or CP-*56 ; concerns only sportspersons. See The definition of Comit Para unique id.
CFID	CFEPP unique id Looks like CF-153 ; concerns only sportspersons. See The definition of CFEPP unique id.
Names
FNAME	Family name.
GNAME	Given name.
FAME	Fame name: scene name, pseudonym, sometimes different from the birth certificate.
NOB	Nobiliary particle.
Dates
DATE	Legal date = date and time as written in the birth certificate. Format ISO 8601 of this form : YYYY-MM-DD HH:MM. Example : 2017-05-03 09:30. Timezone offset is not included ; hour precision is minute (seconds omited).
DATE-UT	Date and time converted to universal time.
TZO	Timezone offset, see definition on page tig12.github.io/g5/time.html.
Geographical information
PLACE	Birth place name.
CY	Country code of birth place ; ISO 3166, 2 letters format.
C1	Administrative division level 1 of birth place Means "province" in Italy, or "state" in the USA. Corresponds to ADM1 in geonames.org ("first-order administrative division").
C2	Administrative division level 2 of birth place Means "département" in France. Corresponds to ADM2 in geonames.org ("second-order administrative division").
C3	Administrative division level 3 of birth place Used for "arrondissements" (Paris, Lyon, Marseille) = division of a big city in different parts. Does NOT correspond to ADM3 in geonames.org ; in geonames.org, different arrondissements are modeled as different PLACE, and have different geonames id.
GEOID	geonames.org unique identifier of birth place.
LG	Longitude of birth place in decimal degrees.
LAT	Latitude of birth place in decimal degrees.
Other fields
G	Gender F or M in general.
OCCU	Occupation codes, as listed in page listing persons by occupation. When a person has more than one occupation code, the codes are separated by "+". Ex : politician+writer means that the person is identified as a politician and a writer.
EM	Eminence ; this notion is important but not yet integrated in OGDB. The only eminence indicator currently present comes from Ertel's work on athletes published in 1988.