names

14 rows where case_id = 2428736

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5245111 2428736 2428736 plaintiff Pulvertoft Gilbert     Pulvertoft, Gilbert 0
5245112 2428736 2428736 defendant Arlyngton John husbandman 592893 592893 Arlyngton, John, of Holbech, Lincs, husbandman 0
5245113 2428736 2428736 defendant Clerk William, junior husbandman 586751 586751 Clerk, William, junior, of Holbech, husbandman 1
5245114 2428736 2428736 defendant White John goldsmith 586487 586487 White, John, of Suthwerk, goldsmith 2
5245115 2428736 2428736 defendant Thorp Thomas esq 604024 604024 Thorp, Thomas, of Dartford, Kent, esq 3
5245116 2428736 2428736 defendant Besboll John   585869 585869 Besboll, John, of London, servant 4
5245117 2428736 2428736 defendant Besboll Robert husbandman 863611 863611 Besboll, Robert, of Gosberkirk, Lincs, husbandman 5
5245118 2428736 2428736 defendant Preston Richard clerk 633267 633267 Preston, Richard, of Quadryng, Lincs, clerk 6
5245119 2428736 2428736 defendant Polvertoft William yeoman 585869 585869 Polvertoft, William, of London, yeoman 7
5245120 2428736 2428736 defendant Polvertoft Matilda widow 586751 586751 Polvertoft, Matilda, of Holbech, widow 8
5245121 2428736 2428736 defendant Halmer Richard gent 731637 731637 Halmer, Richard, of Weston, Lincs, gent 9
5245122 2428736 2428736 defendant Wreme Richard cooper 585869 585869 Wreme, Richard, of London, cooper 10
5245123 2428736 2428736 defendant Dobson Alice widow 585869 585869 Dobson, Alice, of London, widow 11
5245124 2428736 2428736 defendant Mounteny Reginald husbandman 585869 585869 Mounteny, Reginald, of London, husbandman 12

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