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.
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

Download CSV lists by occupation
See page Lists by occupation and click on the download icon
Other downloads
Auxiliary files, like scans of original documents, can be downloaded from github.com/tig12/g5-auxFormat 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. |