Zum Hauptinhalt springen

Chapter 3: Results and their display

1 A table: letters per year

How many letters does the register date to each year, and in which direction did they travel?

Partitur
---
id: letters-by-year
display: tabelle
duckdb:
  - alias: main
    path: $PDAI_COLLECTIONS/pirckheimer/pirckheimer.duckdb
    read_only: true
partiturs:
  - id: duckdb-read
    input:
      sql: |
        SELECT TRY_CAST(left(date_when, 4) AS INTEGER) AS year,
               count(*) AS letters,
               count(*) FILTER (WHERE direction = 'X_to_P') AS to_pirckheimer,
               count(*) FILTER (WHERE direction = 'P_to_X') AS from_pirckheimer
        FROM letters_resolved
        GROUP BY year
        ORDER BY year
artefacts:
  - name: years
    kind: table
    file: years.json
---
How many letters does the register date to each year, and in which direction
did they travel?

ohne Erwartung

2 A figure: the busiest year

A one-row result is a set of figures. Each numeric column becomes a measured value that the display shows and an oracle can check.

Which year has the most letters in {{ref:letters-by-year.years}}?

Partitur
---
id: peak-year
depends_on: [letters-by-year]
display: kennzahl
partiturs:
  - id: duckdb-read
    input:
      sql: |
        SELECT r.year AS peak_year, r.letters AS peak_letters
        FROM read_json_auto('{{ref:letters-by-year.years}}') AS f,
             unnest(f.data.data.rows) AS t(r)
        ORDER BY r.letters DESC
        LIMIT 1
artefacts:
  - name: peak
    kind: table
    file: peak.json
---
Which year has the most letters in {{ref:letters-by-year.years}}?

1525 peak_year, 105 peak_letters.

ohne Erwartung
1525.0peak_year
105.0peak_letters

3 A grouped table: places by direction

From which places were letters written, grouped by the direction of the letter? Places with fewer than five letters are left out.

Partitur
---
id: places
display:
  format: hierarchische-tabelle
  gruppe: kind
  spalten:
    - {feld: name, label: Place}
    - {feld: count, label: Letters, art: zahl}
  zeilen_sichtbar: 12
duckdb:
  - alias: main
    path: $PDAI_COLLECTIONS/pirckheimer/pirckheimer.duckdb
    read_only: true
partiturs:
  - id: duckdb-read
    input:
      sql: |
        SELECT CASE direction WHEN 'X_to_P' THEN 'to Pirckheimer'
                              ELSE 'from Pirckheimer' END AS kind,
               coalesce(place, 'unknown') AS name,
               count(*) AS count
        FROM letters_resolved
        GROUP BY kind, name
        HAVING count(*) >= 5
        ORDER BY kind, count DESC
artefacts:
  - name: places
    kind: table
    file: places.json
---
From which places were letters written, grouped by the direction of the
letter? Places with fewer than five letters are left out.

ohne Erwartung
from Pirckheimer · 1
Nürnberg44.0
to Pirckheimer · 13
Nürnberg69.0
Kloster45.0
Basel26.0
Herford14.0
Augsburg12.0
Kirchehrenbach11.0
Leipzig10.0
Bamberg9.0
Straßburg9.0
Wien7.0
Innsbruck7.0
Stuttgart5.0
Eichstätt5.0

4 A network: the correspondents as a star

The block reads the roster of the Pirckheimer project through the short name pirck, which famulus.yml imports.

Draw Pirckheimer's correspondents from {{ref:pirck/briefpartner-roster.roster}} as a star. Pirckheimer stands in the centre; the weight of an edge is the number of letters.

Partitur
---
id: star
display: netz
partiturs:
  - id: artifact:d3-graph
    input:
      center: Pirckheimer
      roster:
        ref: pirck/briefpartner-roster.roster
    artefact: star
artefacts:
  - name: star
    kind: d3-graph
    file: star.json
---
Draw Pirckheimer's correspondents from {{ref:pirck/briefpartner-roster.roster}}
as a star. Pirckheimer stands in the centre; the weight of an edge is the
number of letters.

60 von 75 Briefpartnern. Stern um Pirckheimer. Die Kantenstärke ist die Briefzahl. 60 Briefpartner.

ohne Erwartung

Das Netz steht im Viewer. Die Knoten sind die Briefpartner.

  • Pirckheimer
  • Donauwörth, Bürgermeister und Rat von (127)
  • Erasmus, Desiderius (21)
  • Pirckheimer, Klara (20)
  • Schöner, Johann (11)
  • Pirckheimer, Sabina (10)
  • Grieninger, Johann (9)
  • Pirckheimer, Katharina d. J. (9)
  • Spalatin, Georg (9)
  • Kreber, Leonhard (8)
  • Montanus, Jakob (7)
  • Pirckheimer, Caritas d. J. (6)
  • Huttich, Johann (5)
  • Bild, Veit (4)
  • Savorgnanus, Petrus (4)
  • Hohenlohe, Graf Albrecht von (3)
  • Tannberg, Wolfgang von (3)
  • Zinner, Nikolaus (3)
  • ?, Johann (2)
  • Capito, Wolfgang (2)
  • Cochlaeus, Johannes (2)
  • Gabriel, Bischof von (2)
  • Geuder, Georg (2)
  • Glareanus, Heinrich (2)
  • Imhoff, Hans (2)
  • Mosham, Rupert von (2)
  • Neuenahr, Graf Hermann von (2)
  • Oecolampadius, Johannes (2)
  • Phrygio, Paulus (2)
  • Pirckheimer, Eufemia (2)
  • Pöll, Johann (2)
  • Straub, Hans (2)
  • Sturio, Johannes (2)
  • Tschertte, Johann (2)
  • Venningen, Florenz von (2)
  • Adelmann von Adelmansfelden, Bernhard (1)
  • Adelmann von Adelmansfelden, Konrad (1)
  • Banissis, Jakob de (1)
  • Campeggio, Kardinal Lorenzo (1)
  • Campi, Johannes Baptista de (1)

5 An evidence list: sentences from Kepler

Show the first three Latin sentences in which Kepler uses lex and natura together, from {{ref:kepler/lex-natura-gegenprobe.gegenprobe}}.

Partitur
---
id: kepler-evidence
collections: [kepler-prim]
display: belegliste
partiturs:
  - id: duckdb-read
    input:
      sql: |
        SELECT r.doc_id, r.pidx, r.sent_idx, r.text
        FROM read_json_auto('{{ref:kepler/lex-natura-gegenprobe.gegenprobe}}') AS f,
             unnest(f.data.data.rows) AS t(r)
        ORDER BY r.doc_id, r.pidx, r.sent_idx
        LIMIT 3
artefacts:
  - name: evidence
    kind: kwic
    file: evidence.json
---
Show the first three Latin sentences in which Kepler uses lex and natura
together, from {{ref:kepler/lex-natura-gegenprobe.gegenprobe}}.

ohne Erwartung
kgw-01 · 190.0 · 0.0illam facio, quàm par est; nec si primi authores legem quandam suis ratiocinijs arbitrarijs à rerum natura sunt mutuati, propterea vicissim tota reliqua coelestium natura sese subjecit his eorum ratiocinijs; ut hortulanus ad quinarium numerum floribus familiarem respiciens, si pulvillos struat quinquangulos; non ideò efficit, ut foeliciùs in ijs proveniant rosae: quia natura floris, etsi ratiocinantem hortulanum admonet de quinquangulo, non tamen ab expresso quinquangulo reciprocam capit utilitatem.
kgw-01 · 263.0 · 4.0Qui hoc affirmant, pars naturae coelorum consulentes, lege circulari hoc factum esse pronunciant: ut ita causa sit, cur ex descensu, nexus, et quodammodo prognatus fuerit contrarius ascensus.
kgw-01 · 288.0 · 6.0Moderator itaque totius naturae non in hoc Solem et Lunam ciet, ut deliquium jungat aequinoctio; sed ne Solem Lunamque non cieat, suâ quemlibet lege: non refugit deliquium jungere aequinoctio.