names

21 rows where place_id = 618240

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3723539 1933632 1933632 defendant Grace Richard laborer 618240 618240 Grace, Richard, of Newporte Ponde, laborer 2
3760966 1945435 1945435 defendant Core Richard husbandman 618240 618240 Core, Richard, of Newporte Ponde, husbandman 3
3776858 1950501 1950501 defendant Boultell Richard laborer 618240 618240 Boultell, Richard, of Newporte Ponde, laborer 0
3796387 1956736 1956736 defendant Scotte William glover 618240 618240 Scotte, William, of Newporte Ponde, glover 0
3796390 1956737 1956737 defendant Scotte William glover 618240 618240 Scotte, William, of Newporte Ponde, glover 1
3807473 1960242 1960242 defendant Cole Thomas haberdasher 618240 618240 Cole, Thomas, of Newporte Ponde, haberdasher 0
3807862 1960344 1960344 defendant Maryffe Richard husbandman 618240 618240 Maryffe, Richard, of Newporte Ponde, husbandman 2
3886016 1985574 1985574 defendant Sedcole Thomas yeoman 618240 618240 Sedcole, Thomas, of Newporte Ponde, yeoman 0
3886017 1985574 1985574 defendant Sedcole Richard butcher 618240 618240 Sedcole, Richard, of Newporte Ponde, butcher 1
3892818 1987847 1987847 defendant Brande Henry yeoman 618240 618240 Brande, Henry, of Newporte Ponde, yeoman 0
3923345 1998115 1998115 defendant Bronde Henry, senior glover 618240 618240 Bronde, Henry, senior, of Newporte Ponde, glover 0
3923347 1998116 1998116 defendant Proude Henry, senior glover 618240 618240 Proude, Henry, senior, of Newporte Ponde, glover 0
4094124 2058230 2058230 defendant Robson Henry yeoman 618240 618240 Robson, Henry, of Newporte Ponde, yeoman 0
4203538 2096789 2096789 defendant Nithingall Stephen glover 618240 618240 Nithingall, Stephen, of Newporte Ponde, glover 0
4203539 2096789 2096789 defendant Harvye Robert glover 618240 618240 Harvye, Robert, of Newporte Ponde, glover 1
4276582 2121744 2121744 defendant Marchall Samuel carpenter 618240 618240 Marchall, Samuel, of Newporte Ponde, carpenter 3
4277143 2121939 2121939 defendant Hamond James yeoman 618240 618240 Hamond, James, of Newporte Ponde, yeoman 0
4277144 2121939 2121939 defendant Martyn Nicholas butcher 618240 618240 Martyn, Nicholas, of Newporte Ponde, butcher 1
4277145 2121939 2121939 defendant Skott William butcher 618240 618240 Skott, William, of Newporte Ponde, butcher 2
4277146 2121939 2121939 defendant Skott Martin glover 618240 618240 Skott, Martin, of Newporte Ponde, glover 3
4410372 2168067 2168067 defendant Brand John butcher 618240 618240 Brand, John, of Newporte Ponde, butcher 2

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