France under German occupation. The German and French administration 1940-1945 – full data

At www.adresses-france-occupee.fr, the GHIP provides an interactive map showing the German and French authorities in France during the German occupation of France between 1940 and 1945. In addition to the historical and current address, the website provides information about the tasks, responsibilities and the structure of each department of the authorities, as well as photos if available. Depending on the type and scope of the query, it gives an impression of everyday life, the presence of the German occupation administration and forces and, last but not least, their cooperation with the French authorities. The information is based on a systematic evaluation of the telephone books of the German authorities and French administration directories from the time of the war. They were completed by research in German and French archives, in particular the Archives municipales, as well as press media, historical map collections and research works.

With this entry we give access to the data of this database in four different tables (csv UTF-8 and excel).

1)    The table "services" relates to the departments (German: Dienststellen). The data is maintained in the state closest to that of the phone directories and address books: a department is valid in a hierarchy at a given address and at a given time. The table contains:

·         the ID number (id), its linking to its superior department (parent_service_id)

·         the name of the department (name),

·         the ID number of the source from which the information originates (source_id),

·         the ID number of the place where the departments office is located (place_id),

·         the status on the website (status: visible, pending, deleted),

·         the display of the hierarchy (d_breadcrumb) and

·         the last edit of the entry by the project team (last_edit_date).

There are 68,044 entries in total.

2)    The table "service_bridge" is a cross table, relating the departments to each other by showing their hierarchy. IT contains the parent_service_id, the child_service_id, and the breadcrumb, that indicates the department's position in the hierarchy. There are 28,162 entries in total

3)    The table "places" is used to localise the departments. A place is a geographical point identified by its latitude and longitude. The address (in text format) of this place may have changed over time. The database contains both old and new names. The table contains the ID number of the place (id), the name of the building/accommodation (name), the status of the entry on the website (status: visible, pending, deleted), the current address (current_country, current_zip, current_city, current_street, current_house_number), former address (fromer_street, former_house_number) as well as the longitude and latitude of the place. There are 15,454 entries in total.

4)     The table "sources_details" relates to the sources used to build the database. By source we understand ‘data source’, i.e. any source used to obtain information on the German and French authorities of the time. We mostly used German and French telephone directories of the years 1940–1944. The table contains:

·         the ID number of the source (id),

·         the name of the source in short (name),

·         the country of publication or origin of the source (country),

·         the full edition date (edition_date) if available, otherwise approximate,

·         the year of the publication or year of the source (d_edition_year),

·         the month of the publication or month of the source (d_edition_month) and

·         the full bibliographical citation and/or explanations (source_name_complete).

There are 57 entries in total.

You can get in touch with us via the mail dh [at] dhi-paris.fr