names

14 rows where place_id = 588954

✎ 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
3596097 1866408 1866408 defendant Kymbesby alias Bocher Roger husbandman 588954 588954 Kymbesby alias Bocher, Roger, of Clay juxta Mare, Norf, husbandman 2
3836616 1969354 1969354 defendant Symond Ralph merchant 588954 588954 Symond, Ralph, of Clay juxta Mare, Norf, merchant 0
3891567 1987443 1987443 defendant (not given)   mariner 588954 588954 of Clay juxta Mare, Norf, mariner 3
4036202 2037630 2037630 plaintiff Howarde Thomas   588954 588954 Howarde, Thomas, of Clay juxta Mare, Norf, ship master 0
4036204 2037631 2037631 plaintiff Howarde Thomas shipmaster 588954 588954 Howarde, Thomas, of Clay juxta Mare, norf, shipmaster 0
4073144 2050687 2050687 defendant Barker Robert mariner 588954 588954 Barker, Robert, of Clay juxta Mare, Norf, mariner 0
4074980 2051353 2051353 defendant Letle Margaret widow 588954 588954 Letle, Margaret, of Clay juxta Mare, Norf, widow 1
4350175 2147321 2147321 defendant Sutton John   588954 588954 Sutton, John, of Clay juxta Mare, Norf, rope maker 0
5085686 2382213 2382213 plaintiff Hagon Alice (legal representative) 588954 588954 Hagon, Alice, of Clay juxta Mare, Norf, widow of Hagon, Thomas, of Clay juxta Mare, executors of 0
5284363 2440444 2440444 defendant Brygge John gent 588954 588954 Brygge, John, of Clay juxta Mare, Norf, gent 0
5284365 2440445 2440445 defendant Brygge John gent 588954 588954 Brygge, John, of Clay juxta Mare, Norf, gent 0
5286916 2441176 2441176 defendant Brygge John gent 588954 588954 Brygge, John, of Clay juxta Mare, Norf, gent 0
5287290 2441303 2441303 defendant Brygg John gent 588954 588954 Brygg, John, of Clay juxta Mare, Norf, gent 0
5287292 2441304 2441304 defendant Osyg John gent 588954 588954 Osyg, John, of of Clay juxta Mare, Norf, gent 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);