Search Database

How to perform a Database Search

The "Search Database" menu allows several types of searches, or search results. Each menu item, e.g. "Search Persons", "Search Events", etc., returns results from different tables in the database: "Persons", "Events", etc. Furthermore, each search type includes multiple search fields.

For example, should you wish to find all persons born in Athens that have ever participated in a festival held in Olympia, the relevant search is as follows:

  • Go to the "Search Persons" menu item in "Search Database";
  • Click on "Advanced Search"
  • In "Place of Origin" type "Athens"
  • In "Festival Place" type "Olympia"
  • Click "Submit

The results will be displayed on the same page.

The "Basic Search" option allows searching the most common fields.

The "Advanced Search" option allows a more customized search of the database: you can enter any string in each field and thus make combinations; the returned results will match all fields (logical AND).

Both the Basic and Advances Searches allow you to use logical OR and AND operators to perform a search. For example, searching on Marcus AND (Koros OR Charmos) in the "Person" field, will return results for Marcus and either Koros or Charmos. The logical operators OR and AND are case sensitive, but the search terms are not. This feature is not implemented for Period.

Recent Posts

  • Added Strasser Mémoire de champions

    We have now added references to Jean-Yves Strasser's  magisterial corpus Mémoire de champions. Corpus des palmarès d'Octavien à Valentinien Ier. Athens, 2021 (École française d'Athènes). This wonderful work is available online via   >> https://books.openedition.org/efa/13782?. Blang=en <<

  • New feature: mapping who went where

    It is now possible to view the trajectories of individual athletes and performers: if you do a persons search you will get a map with registered victories.

  • New feature! Distribution map of festivals

    Take a look at the first version of our geographically and chronologically determined distribution map of festivals ((the link is also available via our homepage). The map shows cities in the ancient world where one or more festivals were organised. Sliding the bar below the map allows you to see the chronological development and popularity of the cities and their festivals. The size of the red bulb represents the number of participants in a particular period. By clicking the red bulbs you will see which festival(s) were hosted by this particular city, how many known participants it attracted, and the names of the athletes and musicians that were born in that particular city. We are working on improving the functionality of the map, i.a. by creating a map that shows the result of any query you might run. 

  • New content! Organizers and competitors in Boiotian contests centred on Rome

    The newest addition to the database includes ca. 150 competitors in and organizers of some Boiotian contests associated with the presence of Rome, that were being organized in the second and first centuries BCE: the Amphiaraia kai Rhomaia in Oropos, the Rhomaia in Thebes, and the alleged Erotideia kai Rhomaia in Thespiai. Like other contemporaries, the Boiotians seem to have used their association with Rome through these contests to claim their status in a rapidly changing world.   

  • CfP - Rooted Cities, Wandering Gods: Inter-Urban Religious Interaction

    We are proud to announce that the members of the Connecting the Greeks project are organising a conference on inter-urban religious contacts, to take place (hopefully in person!) at Groningen in the autumn of 2021. We invite anyone interested in cities, religious practices, and the ties between them to submit an abstract – you can read all about the conference theme and confirmed speakers in the full call for papers. 

Archive

2023
2022
2021
2020
2019
2018
2017

Categories

Authors

Feeds

RSS / Atom