names

13 rows where place_id = 650963

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3914947 1995349 1995349 defendant Tanner Henry yeoman 650963 650963 Tanner, Henry, of Barkley, yeoman 0
3954031 2008480 2008480 defendant Machen William yeoman 650963 650963 Machen, William, of Barkley, yeoman 0
3954032 2008480 2008480 defendant Wodall Michael yeoman 650963 650963 Wodall, Michael, of Barkley, yeoman 1
3954033 2008480 2008480 defendant Boucher John yeoman 650963 650963 Boucher, John, of Barkley, yeoman 2
3991872 2021849 2021849 defendant Lewes George yeoman 650963 650963 Lewes, George, of Barkley, yeoman 0
4206913 2097962 2097962 defendant Gyles John yeoman 650963 650963 Gyles, John, of Barkley, yeoman 0
4206915 2097962 2097962 defendant Gybbyns Thomas husbandman 650963 650963 Gybbyns, Thomas, of Barkley, husbandman 2
4302535 2131005 2131005 defendant Bastyan Anthony yeoman 650963 650963 Bastyan, Anthony, of Barkley, yeoman 2
4324865 2138702 2138702 defendant Hawlle Edward yeoman 650963 650963 Hawlle, Edward, of Barkley, yeoman 0
4931757 2336320 2336320 defendant Hore Richard yeoman 650963 650963 Hore, Richard, of Barkley, yeoman 1
5523433 2512157 2512157 defendant Lippiate Richard tailor 650963 650963 Lippiate, Richard, of Barkley, tailor 0
5523434 2512157 2512157 defendant Baudwyn John tailor 650963 650963 Baudwyn, John, of Barkley, tailor 1
5523435 2512157 2512157 defendant Griggith John cordwainer 650963 650963 Griggith, John, of Barkley, cordwainer 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);