Data Input: Difference between revisions

From FactGrid
Jump to navigation Jump to search
No edit summary
 
(59 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This page is gathering the data-sets for the first FactGrid data import. We aim to also create input forms so that researchers can eventually create new data sets when working over individual documents in an archive.
 
* [[https://www.wikidata.org/wiki/Help:QuickStatements Wikidata zu QuickStatements]
== Help ==
* [[Anleitung]]
* [https://www.wikidata.org/wiki/Help:QuickStatements Wikidata zu QuickStatements]
* [https://www.wikidata.org/wiki/Help:Data_type/de Data type]
* [https://www.wikidata.org/wiki/Help:Data_type/de Data type]
* [[Specific FactGrid Manual]]
* [[Specific FactGrid Manual]]
* [http://openrefine.org/ http://openrefine.org/] Former Google refine, tool to transform information for a data input


== To Do ==
== Places ==
=== Subsets klären ===
* [https://database.factgrid.de/query/#SELECT%20%3FOrt%20%3FOrtLabel%20%3FGeokoordinaten%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3FOrt%20wdt%3AP2%20wd%3AQ8.%0A%20%20OPTIONAL%20%7B%20%3FOrt%20wdt%3AP48%20%3FGeokoordinaten.%20%7D%0A%7D FactGrid search: a place and its geo-coordinate]
Q10671-75 sind ineinander verschachtelt und alle Teil von Q2, das muss noch vermerkt werden. P3 Property
 
== Google Spreadsheets of the ongoing Data Input ==


We have presently (Oct. 2018) some 840 places in the FactGrid not all of which have a geo-coordinate. We probably made the mistake not to begin with one single massive place input...


{| class="wikitable sortable" width="100%"
== Copy&Paste Script-Fragments with [https://database.factgrid.de/quickstatements/#/batch QuickStatements] and CSV-Input ==
|+ style="padding-bottom:1em" | Google Spreadsheets and Illuminati Project Data
|-
! Dataset Google Spreadsheet !! Content !! What could be visualised? !! Web Form 
|-
| [https://docs.google.com/spreadsheets/d/1gd7bx9n-3pRC4VPHcVdHPEf9cFpZbZxr3WM_RBjXLgk/edit?usp=sharing Documents] || Mostly ''Schwedenkiste'', Illuminati materials from various archives, documents published in the late 1780s  || Network information. Caution: We are operating with fragmented data - early information published by the Bavarian State in 1787/88 and the ''Schwedenkiste'', the archive of the last operating province. || [[Erfassung von Akten|Describe an archival document]]
|-
| [https://docs.google.com/spreadsheets/d/1AmiTIOP7kTjw61q4YJCCSbNHqS6sRU1ZFQq82RQTn7E/edit?usp=sharing People] || A list of the 1350-something members of the order (plus some others who belong into the wider context) Mainly Research stated in col. AJ: Hermann Schüttler (2016). Members, when and where they entered the Order, titles, occupations, related memberships ||
* The geographical spread of the Order on the Central European map: col. AB to be matched with col. AG
* Already existing Wikidata and GND data sets linked in cols. M and N.
* Age structure of the members col. AC
* Percentage of aristocracy cols. J-L
|| [[Erfassung biographischer Information|Writing a CV]]
|-
| || The order had a complex grade system that created careers within the order, people could also get into different official positions  ||  || [[Erfassung von Mitgliedschaft im Illuminatenorden|Give information about an Illuminati career]]
|-
| [https://docs.google.com/spreadsheets/d/1PkUXuVwbQH9bMJoaGWd3TvkTQqHdY8AbW05FjeyAyY8/edit?usp=sharing Events] || Mostly protocols of gatherings of the "Minerval Churches" under Bode's supervision. (Missing: Hermann Schüttler's information about gatherings of the Minerval Church in Frankfurt/Main) ||  || [[Sitzung, Konferenz|Give information about a session (as type of an event)]]
|-
| [https://docs.google.com/spreadsheets/d/1gZEyHOePPWoQssIzxgtExwBGx61TL1qGbGVspv9_sAQ/edit?usp=sharing Organisations] ||  ||  ||
|-
| [https://docs.google.com/spreadsheets/d/12-bO44oNKUBw61e1kO-lFJEvcedTs63_oTwigr8GJQw/edit?usp=sharing Publications] ||  ||  || 
|}


== Places ==
=== Create a family name ===
Presently 223, some without Geo-ref, some not real places, some double
qid,Lde,Len,Lfr,Dde,Den,Dfr,P2<br>
,"#","#","#","Familienname","family name","nom de familie",Q24499


SELECT ?Ort ?OrtLabel ?Geokoordinaten WHERE {
=== Create a person ===
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
qid,Lde,Len,Dde,Den,P2,P154<br>
  ?Ort wdt:P2 wd:Q8.
,"#","#","$","$",Q7,Q18
  OPTIONAL { ?Ort wdt:P48 ?Geokoordinaten. }
}


== Strange Items ==
::legt eine Person an, # gegen Label austauschen, $ eine Kurzbiographie etwa: "~1808, Gotha" für eine Person, die laut einem Dokument 1808 in Gotha auftaucht. Q18 identifiziert die Person als Mann. Bei einer Frau Q17 einsetzen.
* Bibliothek (Q11249)
* Archiv (Q11)
* Minervalkirche (Q11213)
* Organisationsform (Q11214)
* Mitgliedschaftsstatus (Q11210)
* Aufsatz (Q10514)
* Bericht (Q10515)
* nicht aufgelöstes Pseudonym (Q11186)
* Original (Q11177)
* Abschrift (Q11178)
* Durchschlag (Q11179)
* Photokopie (Q11180)
* Entwurfsfassung (Q11181)
* Extrakt (Q11182)
* Abdruck (Q11183)
* Katalogeintrag (Q11184)
* Not the author's handwriting (Q11148)
* English (Q11149)
* German (Q11150)
* Latin (Q11151)
* French (Q11152)
* Spanish (Q11153)
* Dutch (Q11154)
* Italian (Q11155)
* Russian (Q11156)
* Danish (Q11157)
<hr>
* Order of the Illuminati (Q10677)
* Ingolstadt (Q10285) muss raus
* Calendar (Freemasonic) (Q11175)
* Geography (Order of the Illuminati) (Q11174)
* Calendar (Order of the Illuminati) (Q11173)
* not resolved in FactGrid (Q11172)
* document (Q10671)
* file (Q10672)
* archival corpus (Q10673)
* section in a document (Q10674)
* archival collection (Q10675)
* nicht nachgewiesenes Dokument (Q11176)


== Strange Questions ==
== Werkverträge ==
I inserted statements as "SK13-070" as alias statements, but cannot use these statements in searches.
* [[Werkverträge]]

Latest revision as of 10:29, 13 May 2019

Help

Places

We have presently (Oct. 2018) some 840 places in the FactGrid not all of which have a geo-coordinate. We probably made the mistake not to begin with one single massive place input...

Copy&Paste Script-Fragments with QuickStatements and CSV-Input

Create a family name

qid,Lde,Len,Lfr,Dde,Den,Dfr,P2
,"#","#","#","Familienname","family name","nom de familie",Q24499

Create a person

qid,Lde,Len,Dde,Den,P2,P154
,"#","#","$","$",Q7,Q18

legt eine Person an, # gegen Label austauschen, $ eine Kurzbiographie etwa: "~1808, Gotha" für eine Person, die laut einem Dokument 1808 in Gotha auftaucht. Q18 identifiziert die Person als Mann. Bei einer Frau Q17 einsetzen.

Werkverträge