Table

How to analyze your data and produce a table

Create a new table

To create a new table, click on "Analysis" > + add > Table

Set your table's parameters,step by step

1. Choose your entities

In order to analyse your entities, you have to choose which entity classes you want to investigate: Persons, Geographical Place, Buildings, Human-Made Objects, Publication Exemplars, etc.

Tables can support multiple classes at once, unlike timelines and maps which are centered around a single class.

In this example, we shall be looking for a listing of all the birthplaces of the persons registered in the projet Academic Education & Careers.

Since we are looking for birthplaces, we select the class "Geographical Place".

• click on continue

• hit "run" to retrieve a list of all geographical places in your project

Since we are looking for birthplaces, we select the class "Geographical Place"

2. Build your table

Now you can start building your table.

After having chosen the class to be investigated, it is necessary to select the information which one seeks to recover in the columns of the table.

You can choose between two kind of information to be registered : "entity attributes" or "path to related entities". Entity attributes for example include its unique identifier.

The entity preview already appears by default : this column will display the list of the entities you previously selected. In this example, we will name it "Birthplaces".

To rename the column, click on the drop-down menu on the right

To add more columns containing informations linked to your selected entities, click on "add" > "Path to related entities". In this example, we will add a second column linking the geographical places with the name of the persons born in these places, and a third one indicating their birthdays.

The second column will be named "Persons". To display their names, we need to establish the path between them and the class we first selected ("Geographical place"). In this case, we will add a path segment by clicking on the " + " button and select "Is place of event" + "Birth" + "Born child" + "Person".

Path from the "Places" to the "Persons"

Add another "Path to related entities" to create a new column. This time, we will establish the path from the places to the birthdays: "Geographical Place" + "Is place of event" + "Birth" + "Andauernd während"/during + "Time Primitive".

Path from the "Places" to the "Birthdays"

3. Filter your entities

At this point, you can already run your analysis by clicking on the "--> Run" button on top of the tab. All the instances of the entities you chose in the first step should appear, as well as the informations linked to them that you add in the second step (in our example, the "Persons" and the Birthdays").

Our table after a first run

Now if you want the entities on the left column to fulfill certain conditions in order to appear on the table, you can filter them. For example, we can see on the image above that every geographical places registered in the project appear on the list, including some that aren't the birthplace of any person recorded in it (e.g. Reinfeld or Salzkotten).

We can add sub-filters on the class to narrow down our results, by clicking on the green-circled arrow under it. In this case, we will specify that the geographical places must have the property of being the place of an event (a birth). We then select the Condition "Has one of the properties" and the Property "Is place of event". To continue further, we click on the green-circled arrow and select the class "Birth".

If you run the analysis now, only the places where a Birth actually occurred will appear on the table

You can also create more complex filters by clicking the green-circled " + " button to add "and/or" conditions.

Save and download

Click on the "save" button on top of the tab to find your analysis in the "Analysis" menu on the left panel. You can name it and descriibe its purpose. Your table model is now registered in the "Analysis" panel (under "your analyses"); the results will of course be updated with the new informations you may have entered in your project every time you run it !

Note that you can download your table as an excel (CSV) of JSON file, by clicking on the "Download" menu on the bottom right of the tab.

Download your table as a CSV or a JSON file

Note that csv-exports are limited in case you want to download rich data. In any case, you can import a CSV file to Excel (in the "Data" tab, select import "From text", and make sure that the delimiter is set to "commas").

The project Academic Education & Careers is a shared project, open to all. You can use the analyses already registered by other users to learnhow they are configured, and try to create new ones !

Video recap