names

17 rows where place_id = 630842

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3796936 1956921 1956921 defendant Crowche John husbandman 630842 630842 Crowche, John, of Warden, husbandman 0
4302697 2131060 2131060 defendant Sockling Richard yeoman 630842 630842 Sockling, Richard, of Warden, yeoman 1
4348173 2146608 2146608 defendant Heyward William yeoman 630842 630842 Heyward, William, of Warden, yeoman 0
4440069 2181820 2181820 defendant Roger Reginald   630842 630842 Roger, Reginald, of Warden 2
4460726 2188413 2188413 defendant Sharp John   630842 630842 Sharp, John, of Warden 1
4460727 2188413 2188413 defendant Wycham Thomas   630842 630842 Wycham, Thomas, of Warden 2
4460728 2188413 2188413 defendant Rattlele John   630842 630842 Rattlele, John, of Warden 3
4460732 2188414 2188414 defendant Talls Giles   630842 630842 Talls, Giles, of Warden 0
4460741 2188415 2188415 defendant Colyns John   630842 630842 Colyns, John, of Warden 2
4467186 2190409 2190409 plaintiff atte Halle Robert   630842 630842 atte Halle, Robert, of Warden, on his own account 0
4835493 2307096 2307096 defendant Pegge John husbandman 630842 630842 Pegge, John, of Warden, husbandman 2
4880075 2320677 2320677 defendant Fille Richard husbandman 630842 630842 Fille, Richard, of Warden, husbandman 2
4885753 2322417 2322417 defendant Fylle Richard yeoman 630842 630842 Fylle, Richard, of Warden, yeoman 1
5021615 2363221 2363221 defendant Beton William husbandman 630842 630842 Beton, William, of Warden, husbandman 0
5021616 2363221 2363221 defendant Beton John laborer 630842 630842 Beton, John, of Warden, laborer 1
5043454 2369665 2369665 defendant Fraunceys John   630842 630842 Fraunceys, John, of Warden, abbot 0
5392599 2472952 2472952 defendant Margyt William glasier 630842 630842 Margyt, William, of Warden, glasier 1

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