names

18 rows where case_id = 2261561

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4687064 2261561 2261561 plaintiff St Amando Eleanor formerly wife of Almaric de St Amando, knight   St Amando, Eleanor, formerly wife of Almaric de St Amando, knight 0
4687065 2261561 2261561 defendant Yonge John husbandman 784428 784428 Yonge, John, of Fyffyde, husbandman 0
4687066 2261561 2261561 defendant Mason Henry husbandman 587914 587914 Mason, Henry, of Compton, husbandman 1
4687067 2261561 2261561 defendant Irysshe John   588038 588038 Irysshe, John, of Newebury, shepherd 2
4687068 2261561 2261561 defendant Hulle William husbandman 784430 784430 Hulle, William, of Haselwyke by Inkepenne, husbandman 3
4687069 2261561 2261561 defendant Towegy Roger laborer 784431 784431 Towegy, Roger, of Haselwyke, laborer 4
4687070 2261561 2261561 defendant Cleerke William parich clerk 767341 767341 Cleerke William, of Kentebury, parich clerk 5
4687071 2261561 2261561 defendant Northecote John husbandman 784432 784432 Northecote, John, of Hampstede Ferrers, husbandman 6
4687072 2261561 2261561 defendant Bron John husbandman 784432 784432 Bron, John, of Hampstede Ferrers, husbandman 7
4687073 2261561 2261561 defendant Croucheman John tanner 600176 600176 Croucheman, John, of Andover, Hants, tanner 8
4687074 2261561 2261561 defendant Fort John shoemaker 756295 756295 Fort, John, of Andevere, shoemaker 9
4687075 2261561 2261561 defendant Danyell John carpenter 756295 756295 Danyell, John, of Andevere, carpenter 10
4687076 2261561 2261561 defendant Forster William forester 784433 784433 Forster, William, of Fynkeley, Hants, forester 11
4687077 2261561 2261561 defendant Coroner John smith 784434 784434 Coroner, John, of Penyton, Hants, smith 12
4687078 2261561 2261561 defendant Sclattere John husbandman 784435 784435 Sclattere, John, of Wanytynge, Berks, husbandman 13
4687079 2261561 2261561 defendant Clerk John husbandman 589060 589060 Clerk, John, of Wantynge, husbandman 14
4687080 2261561 2261561 defendant Trussehare John husbandman 784436 784436 Trussehare, John, of Dudecote, Berks, husbandman 15
4687081 2261561 2261561 defendant Wasere John husbandman 784437 784437 Wasere, John, of Henrethe, Berks, husbandman 16

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);