names

30 rows where place_id = 598427

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3632420 1904957 1904957 defendant Daunser John husbandman or innholder 598427 598427 Daunser, John, of Hagley, husbandman or innholder 0
3646026 1909153 1909153 defendant Daunser John, junior yeoman 598427 598427 Daunser, John, junior, of Hagley, yeoman 0
3681088 1920165 1920165 defendant Penne Ellizabeth widow 598427 598427 Penne, Ellizabeth, of Hagley, widow 0
3681089 1920165 1920165 defendant Grove John husbandman 598427 598427 Grove, John, of Hagley, husbandman 1
3681090 1920165 1920165 defendant Daunser John, junior husbandman 598427 598427 Daunser, John, junior, of Hagley, husbandman 2
3683611 1921005 1921005 defendant Penne William yeoman 598427 598427 Penne, William, of Hagley, yeoman 0
3685897 1921746 1921746 defendant Daunser John, senior husbandman 598427 598427 Daunser, John, senior, of Hagley, husbandman 1
3693122 1924058 1924058 defendant Hill Richard husbandman 598427 598427 Hill, Richard, of Hagley, husbandman 0
3710338 1929551 1929551 defendant Penne Elizabeth widow 598427 598427 Penne, Elizabeth, of Hagley, widow 1
3802561 1958697 1958697 defendant Pen Elizabeth widow 598427 598427 Pen, Elizabeth, of Hagley, widow 0
3802562 1958697 1958697 defendant Tyrar Thomas husbandman 598427 598427 Tyrar, Thomas, of Hagley, husbandman 1
3802564 1958698 1958698 defendant Pen Elizabeth widow 598427 598427 Pen, Elizabeth, of Hagley, widow 0
3802565 1958698 1958698 defendant Tyrar Thomas husbandman 598427 598427 Tyrar, Thomas, of Hagley, husbandman 1
3831820 1967849 1967849 defendant Colyns John husbandman 598427 598427 (Colyns, John, of Hagley, husbandman 6
3900806 1990499 1990499 defendant Collyns John husbandman 598427 598427 Collyns, John, of Hagley, husbandman 3
3935117 2002056 2002056 defendant Hagley John husbandman 598427 598427 Hagley, John, of Hagley, husbandman 0
3935118 2002056 2002056 defendant Hagley Matilda William widow 598427 598427 Hagley, Matilda William, of Hagley, widow 1
3935119 2002056 2002056 defendant Hagley William husbandman 598427 598427 Hagley, William, of Hagley, husbandman 2
3964867 2012318 2012318 defendant Grove Margery widow 598427 598427 Grove, Margery, of Hagley, widow 1
3964876 2012319 2012319 defendant Grove Margery widow 598427 598427 Grove, Margery, of Hagley, widow 1
3970307 2014212 2014212 plaintiff Daunser John, senior   598427 598427 Daunser, John, senior, of Hagley 0
4217482 2101608 2101608 defendant Holt John, senior yeoman 598427 598427 Holt, John, senior, of Hagley, yeoman 0
4217483 2101608 2101608 defendant Holt John, junior yeoman 598427 598427 Holt, John, junior, of Hagley, yeoman 1
4236684 2108405 2108405 defendant Penne Roger gent 598427 598427 Penne, Roger, of Hagley, gent 0
4254244 2114418 2114418 defendant Holte John, senior yeoman 598427 598427 Holte, John, senior, of Hagley, yeoman 0
4254245 2114418 2114418 defendant Holte John, junior yeoman 598427 598427 Holte, John, junior, of Hagley, yeoman 1
4267870 2118889 2118889 defendant Grove John yeoman 598427 598427 Grove, John, of Hagley, yeoman 0
4356506 2149507 2149507 defendant Penne Richard yeoman 598427 598427 Penne, Richard, of Hagley, yeoman 0
5085764 2382233 2382233 defendant Taillour John clerk 598427 598427 Taillour, John, of Hagley, clerk 0
5278057 2438670 2438670 defendant Wyght John yeoman 598427 598427 Wyght, John, of Hagley, yeoman 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);