names

16 rows where place_id = 606276

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3664684 1914906 1914906 defendant Parteryche Thomas yeoman 606276 606276 Parteryche, Thomas, of Rayneham, yeoman 0
3873329 1981298 1981298 defendant Fuller Robert yeoman 606276 606276 Fuller, Robert, of Rayneham, yeoman 2
3913888 1994991 1994991 defendant Adams William mercer 606276 606276 Adams, William, of Rayneham, mercer 0
4010380 2028481 2028481 defendant Wychenden Richard butcher 606276 606276 Wychenden, Richard, of Rayneham, butcher 0
4015789 2030331 2030331 defendant Mawn alias Barsam Thomas yeoman 606276 606276 Mawn alias Barsam, Thomas, of Rayneham, yeoman 1
4046214 2041087 2041087 defendant Wylkyns David gent 606276 606276 Wylkyns, David, of Rayneham, gent 1
4046217 2041088 2041088 defendant Wylkyns David gent 606276 606276 Wylkyns, David, of Rayneham, gent 1
4083962 2054540 2054540 defendant Laurence Thomas laborer 606276 606276 Laurence, Thomas, of Rayneham, laborer 0
4091800 2057360 2057360 defendant Harvye Edmund gent 606276 606276 Harvye, Edmund, of Rayneham, gent 3
4091942 2057415 2057415 defendant Harvye Edmund gent 606276 606276 Harvye, Edmund, of Rayneham, gent 3
4102621 2061237 2061237 defendant Parker Richard husbandman 606276 606276 Parker, Richard, of Rayneham, husbandman 0
4114581 2065504 2065504 plaintiff Towneshend Roger Norf, esq 606276 606276 Towneshend Roger, of Rayneham, Norf, esq 0
4147144 2077142 2077142 defendant Addamson William clerk 606276 606276 Addamson, William, of Rayneham, clerk 0
4284048 2124339 2124339 defendant Anderson Alice widow 606276 606276 Anderson, Alice, of Rayneham, widow 0
4370245 2154418 2154418 defendant Jones George mercer 606276 606276 Jones, George, of Rayneham, mercer 0
4765677 2285259 2285259 defendant Lely Robert husbandman 606276 606276 Lely, Robert, of Rayneham, husbandman 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);