names

16 rows where place_id = 661020

✎ 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
3958805 2010158 2010158 defendant Pretty alias Underhill John yeoman 661020 661020 Pretty alias Underhill, John, of Malmesburye, yeoman 0
3975250 2015911 2015911 plaintiff Hoskyns Elizabeth   661020 661020 Elizabeth his wife, formerly Elizabeth Skeye, of Malmesburye 1
4086484 2055449 2055449 defendant Archer Adam clothier 661020 661020 Archer, Adam, of Malmesburye, clothier 0
4086486 2055450 2055450 defendant Archer Adam clothier 661020 661020 Archer, Adam, of Malmesburye, clothier 0
4098445 2059771 2059771 defendant Jaques John yeoman 661020 661020 Jaques, John, of Malmesburye, yeoman 0
4216273 2101185 2101185 defendant Arnold John tailor 661020 661020 Arnold, John, of Malmesburye, tailor 1
4235608 2108023 2108023 defendant Smyth Edward yeoman 661020 661020 Smyth, Edward, of Malmesburye, yeoman 0
4235609 2108023 2108023 defendant Bedford John   661020 661020 Bedford, John, of Malmesburye, mason 1
4235611 2108024 2108024 defendant Sparkes William yeoman 661020 661020 Sparkes, William, of Malmesburye, yeoman 0
4275917 2121526 2121526 defendant Abraham John yeoman 661020 661020 Abraham, John, of Malmesburye, yeoman 0
4278951 2122572 2122572 defendant Vizer John tanner 661020 661020 Vizer, John, of Malmesburye, tanner 0
4316153 2135762 2135762 defendant Stumpe Basil gent 661020 661020 Stumpe, Basil, of Malmesburye, gent 0
4316155 2135763 2135763 defendant Stumpe John gent 661020 661020 Stumpe, John, of Malmesburye, gent 0
4316156 2135763 2135763 defendant Adeane Henry cordwainer 661020 661020 Adeane, Henry, of Malmesburye, cordwainer 1
4316289 2135812 2135812 defendant Vizer John tanner 661020 661020 Vizer, John, of Malmesburye, tanner 0
4395369 2163032 2163032 defendant Adeane Henry shoemaker 661020 661020 Adeane, Henry, of Malmesburye, shoemaker 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);