Zum Hauptinhalt springen

Chapter 1: A first notebook

1 How many people wrote to or from Pirckheimer?

The register letters_resolved of the Pirckheimer edition lists one letter per row, with the sender and the recipient as entity ids. Every letter has Pirckheimer on one side. The other side is his correspondent.

How many correspondents did Pirckheimer have between 1520 and 1530, and how many letters do they share?

Partitur
---
id: first-count
display: kennzahl
duckdb:
  - alias: main
    path: $PDAI_COLLECTIONS/pirckheimer/pirckheimer.duckdb
    read_only: true
partiturs:
  - id: duckdb-read
    input:
      sql: |
        WITH l AS (
          SELECT CASE WHEN sender_id = 'ent_pirckheimer'
                      THEN recipient_id ELSE sender_id END AS partner,
                 TRY_CAST(left(date_when, 4) AS INTEGER) AS year
          FROM letters_resolved
        )
        SELECT count(DISTINCT partner) AS n_correspondents,
               count(*) AS n_letters
        FROM l
        WHERE year BETWEEN 1520 AND 1530
artefacts:
  - name: count
    kind: table
    file: count.json
---
How many correspondents did Pirckheimer have between 1520 and 1530,
and how many letters do they share?

77 Briefpartner, 354 Briefe.

ohne Erwartung
77.0Briefpartner
354.0Briefe

2 Who were they?

List Pirckheimer's correspondents between 1520 and 1530 with the number of letters each shares with him, the most frequent first.

Partitur
---
id: first-list
depends_on: [first-count]
display: tabelle
duckdb:
  - alias: main
    path: $PDAI_COLLECTIONS/pirckheimer/pirckheimer.duckdb
    read_only: true
partiturs:
  - id: duckdb-read
    input:
      sql: |
        WITH l AS (
          SELECT CASE WHEN sender_id = 'ent_pirckheimer'
                      THEN recipient_id ELSE sender_id END AS partner,
                 TRY_CAST(left(date_when, 4) AS INTEGER) AS year
          FROM letters_resolved
        )
        SELECT e.canonical AS name, count(*) AS count
        FROM l JOIN ent_canonical AS e ON e.ent_id = l.partner
        WHERE year BETWEEN 1520 AND 1530
        GROUP BY e.canonical
        ORDER BY count DESC, name
artefacts:
  - name: partners
    kind: table
    file: partners.json
---
List Pirckheimer's correspondents between 1520 and 1530 with the number of
letters each shares with him, the most frequent first.

ohne Erwartung
  • Donauwörth, Bürgermeister und Rat von127.0
  • Erasmus, Desiderius21.0
  • Pirckheimer, Klara20.0
  • (unbekannt)19.0
  • Schöner, Johann11.0
  • Pirckheimer, Sabina10.0
  • Grieninger, Johann9.0
  • Pirckheimer, Katharina d. J.9.0
  • Spalatin, Georg9.0
  • Kreber, Leonhard8.0
  • Montanus, Jakob7.0
  • Pirckheimer, Caritas d. J.6.0
  • Huttich, Johann5.0
  • Bild, Veit4.0
  • Savorgnanus, Petrus4.0
  • Hohenlohe, Graf Albrecht von3.0
  • Tannberg, Wolfgang von3.0
  • Zinner, Nikolaus3.0
  • ?, Johann2.0
  • Capito, Wolfgang2.0
  • Cochlaeus, Johannes2.0
  • Gabriel, Bischof von2.0
  • Geuder, Georg2.0
  • Glareanus, Heinrich2.0
  • Imhoff, Hans2.0
  • Mosham, Rupert von2.0
  • Neuenahr, Graf Hermann von2.0
  • Oecolampadius, Johannes2.0
  • Phrygio, Paulus2.0
  • Pirckheimer, Eufemia2.0
  • Pöll, Johann2.0
  • Straub, Hans2.0
  • Sturio, Johannes2.0
  • Tschertte, Johann2.0
  • Venningen, Florenz von2.0
  • Adelmann von Adelmansfelden, Bernhard1.0
  • Adelmann von Adelmansfelden, Konrad1.0
  • Banissis, Jakob de1.0
  • Campeggio, Kardinal Lorenzo1.0
  • Campi, Johannes Baptista de1.0