Open Gauquelin Database Downloads

Most downloadable files are in CSV format, which contain only part of the information of the database.
The only file containing the full information is the postgresql dump (see below).
If you need a specific format or different extracts, contact me.

Download full database

Postgresql dump - to run opengauquelin on your local machine, see page INSTALL
CSV export - Timed data
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.
Click on the download icon

of the corresponding list.

Download CSV lists by occupation

See page Lists by occupation and click on the download icon

of the corresponding list.

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
OGDBID	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 `S-326` ; concerns only sportspersons. See the definition of Ertel unique id.
CSID	CSICOP unique id Looks like `153` ; concerns only sportspersons. See The definition of CSICOP 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/gauquelin5/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.