names

31 rows where place_id = 590775

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602294 1868383 1868383 defendant Bolle Thomas husbandman 590775 590775 Bolle, Thomas, of Lopham, Norf, husbandman 1
3607563 1870023 1870023 defendant Revet Robert yeoman 590775 590775 Revet, Robert, of Lopham, Norf, yeoman 1
3626126 1903032 1903032 defendant Mosse Robert tailor 590775 590775 Mosse, Robert, of Lopham, Norf, tailor 1
3626129 1903033 1903033 defendant Mosse Robert tailor 590775 590775 Mosse, Robert, of Lopham, Norf, tailor 1
3752618 1942749 1942749 defendant Cokerell alias Godfrey William husbandman 590775 590775 Cokerell alias Godfrey, William, of Lopham, Norf, husbandman 1
3752623 1942750 1942750 defendant Cokerell alias Godfrey William husbandman 590775 590775 Cokerell alias Godfrey, William, of Lopham, Norf, husbandman 2
3763302 1946154 1946154 defendant Underwode Robert yeoman 590775 590775 Underwode, Robert, of Lopham, Norf, yeoman 0
3780417 1951609 1951609 defendant Underwood John yeoman 590775 590775 Underwood, John, of Lopham,Norf, yeoman 4
3780452 1951618 1951618 defendant Underwoode John yeoman 590775 590775 Underwoode, John, of Lopham, Norf, yeoman 4
3787240 1953802 1953802 defendant Brooke William husbandman 590775 590775 Brooke, William, of Lopham, Norf, husbandman 2
3822171 1964832 1964832 defendant Byrlyngham Robert butcher 590775 590775 Byrlyngham, Robert, of Lopham, Norf, butcher 1
4104897 2062027 2062027 defendant Seman Robert yeoman 590775 590775 Seman, Robert, of Lopham, Norf, yeoman 0
4261709 2116870 2116870 defendant Seaman Robert yeoman 590775 590775 (Seaman, Robert, of Lopham, Norf, yeoman 1
4272892 2120496 2120496 defendant Seaman Robert yeoman 590775 590775 (Seaman, Robert, of Lopham, Norf, yeoman 1
4329232 2140089 2140089 defendant Rudd Thomas gent 590775 590775 Rudd, Thomas, of Lopham, Norf, gent 2
4387224 2160375 2160375 defendant Seaman Robert yeoman 590775 590775 (Seaman, Robert, of Lopham, Norf, yeoman 4
5001810 2357428 2357428 defendant Smyth John smith 590775 590775 Smyth, John, of Lopham, Norf, smith 0
5059526 2374420 2374420 defendant Baldry Robert husbandman 590775 590775 Baldry, Robert, of Lopham, Norf, husbandman 4
5103419 2387427 2387427 defendant Baldry Robert yeoman 590775 590775 Baldry, Robert, of Lopham, Norf, yeoman 0
5109362 2389167 2389167 defendant Baldry Robert husbandman 590775 590775 Baldry, Robert, of Lopham, Norf, husbandman 0
5162856 2404856 2404856 defendant Daff John yeoman 590775 590775 Daff, John, of Lopham, Norf, yeoman 0
5176748 2408884 2408884 defendant Baff John yeoman 590775 590775 Baff, John, of Lopham, Norf, yeoman 0
5199086 2415484 2415484 defendant Baff John yeoman 590775 590775 Baff, John, of Lopham, Norf, yeoman 0
5262932 2434150 2434150 defendant Rammesbury John esq 590775 590775 Rammesbury, John, of Lopham, Norf, esq 0
5275890 2438019 2438019 defendant Rammesbury John gent 590775 590775 Rammesbury, John, of Lopham, Norf, gent 0
5275893 2438020 2438020 defendant Raunnesbury John gent 590775 590775 Raunnesbury, John, of Lopham, Norf, gent 0
5289594 2441956 2441956 defendant Rammesbury John gent 590775 590775 Rammesbury, John, of Lopham, Norf, gent 2
5462403 2493656 2493656 defendant Raumesbury John esq 590775 590775 Raumesbury, John, of Lopham, Norf, esq 1
5473919 2497171 2497171 defendant Raymesbury John esq 590775 590775 Raymesbury, John, of Lopham, Norf, esq 0
5473924 2497172 2497172 defendant Raumesbury John esq 590775 590775 Raumesbury, John, of Lopham, Norf, esq 1
5499273 2504725 2504725 defendant Rammesbury John esq 590775 590775 Rammesbury, John, of Lopham, Norf, esq 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);