( g5 )

This program builds a database of famous persons with birth times and timezone offset, called ogdb (Open Gauquelin Database),
Browsable on

Departure points are data used to perform statistical tests on astrology, gathered by Michel and Françoise Gauquelin, Arno Müller, Suitbert Ertel and 3 groups of skeptics: Comité Para - Belgium 1976, CSICOP - U.S. 1979, CFEPP - France 1996.
Data are corrected and imported in a postgresql database, currently containing
  • 24 170 persons with birth time
  • 1 328 persons without birth time, with days.
The main orientations of g5 program are :
  1. Gather the historical data, merge them in a single database, check and correct them.
  2. Connect the historical data to standard datasets like Wikidata and complete birth times to build larger groups.
  3. Build new eminence indicators and sort famous persons by eminence.
One of the purpose of g5 is to permit a precise reconstitution of Suitbert Ertel's analysis of both Gauquelin and groups of skeptics - exposed in the book The Tenacious Mars Effect. This is possible thanks to the availability of Ertel's list of subsamples.

Note that g5 is not concerned by data analysis (performing statistical tests), it deals with data documentation and restoration.

Brief history

These tests, initiated in the 1950s by Michel Gauquelin, followed 3 directions :
  • tests on professional groups,
  • tests on heredity,
  • tests on character traits.
This program deals with the data used to build professional groups.

The assertions of Gauquelin and followers are :
  • we can observe anomalies in the distributions of some planets in the births of famous people ;
  • the anomalies are more important for very eminent people ;
  • these statistical anomalies can be observed only for natural births, the effect disappear for induced deliveries. For this reason, studies are limited to births before 1950.
One particular effect - the repartition of Mars in the births of sportsmen, called "the mars effect" - gave rise to very long polemics without any consensual conclusion. Very few members of the academic world studied the question, most notably Suitbert Ertel and Arno Müller. Ertel introduced citation count, providing an objective measure of eminence, and analyzed Gauquelin and skeptic tests.

The story ended in 1996 with the publication of the CFEPP test and "The Tenacious Mars Effect". Following debates between Suitbert Ertel and skeptics (mainly Jan Wilhem Nienhuys) lead to a disagreement, no consensus was found.

Why Gauquelin5 ?

There are several reasons to care about the data used to perform statistical tests on astrology :
  • Scientific
    History is so confused that the question to know if these statistical anomalies exist out of human bias is still open.
    We today have the means to reproduce these tests with better and more reliable data, and see if a consensus can emerge.
    This is possible for two reasons :
    • The availability of online civil registries permits to check birth times and correct historical data.
    • Internet provides many ways to rank famous persons by eminence.
  • Historical
    History of science is concerned, to study the attitude of the scientific community towards the claims of Gauquelin.
  • Technical
    These data are interesting because they contain birth time. And birth times are generally neglected in the web. Take for example wikidata : birth times are set to 00:00:00. There is no way to make the difference between "this is a date with no time information" and "this is a date with time = 00:00:00" (maybe there is a way, but I didn't find it).
    Birth times of persons better the web, give it more precision and can be useful for other disciplines studying human activity.

About this program

The name "Gauquelin5" comes from the initial source of information, "Archives Gauquelin version 5", from

The software, current documentation and all files containing corrections or informations are released under the following licences :
Related repositories
G5,, is related to 3 other repositories:
Alpha stage
The code is structured enough to be manageable but there are a lot of imprecise and unfinished points, both in code and doc.
Most code already developed concerns step 1 of g5 (restoration of historical data).
See also pages Organisation and Installation.

This documentation is written in a globish as close as possible to english, but uses french conventions for capitalization, spaces and large numbers :
  • Names of months, weekdays, languages etc. are not capitalized.
  • The characters ; ? ! are preceeded and followed by a white space.
  • White space is used as separator for large numbers (for example one million is written 1 000 000).
  • Marriage is written mariage, address is written adress.

This software has a slow development pace because I do it on my spare time.

Repository created by Thierry Graff, 2017-04-28.


  • 2020 : Covid 19
  • 2017 - 2019 : Pôle Emploi

Current status : g5 development in pause, busy to work.