names

32 rows where place_id = 650538

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3912648 1994564 1994564 defendant Vacham John William yeoman 650538 650538 Vacham, John William, of Christchurche, yeoman 0
4015745 2030322 2030322 defendant Langley Walter James gent 650538 650538 Langley, Walter James, of Christchurche, gent 0
4015746 2030322 2030322 defendant Powell Thomas husbandman 650538 650538 Powell, Thomas, of Christchurche, husbandman 1
4015751 2030323 2030323 defendant Langley Walter James gent 650538 650538 Langley, Walter James, of Christchurche, gent 0
4015752 2030323 2030323 defendant Powell Thomas husbandman 650538 650538 Powell, Thomas, of Christchurche, husbandman 1
4025655 2033829 2033829 plaintiff Browne Humphrey gent 650538 650538 Browne, Humphrey, of Christchurche, gent 0
4109185 2063539 2063539 defendant Pope Thomas gent 650538 650538 Pope, Thomas, of Christchurche, gent 0
4147636 2077313 2077313 defendant Coldyell Richard vintner 650538 650538 Coldyell, Richard, of Christchurche, vintner 0
4165413 2083406 2083406 defendant James Thomas merchant 650538 650538 James, Thomas, of Christchurche, or of Caerlyon, merchant 0
4165417 2083407 2083407 defendant James Thomas merchant 650538 650538 James, Thomas, of Christchurche, or of Kaerlyon, merchant 0
4193810 2093405 2093405 defendant Gwyllim William yeoman 650538 650538 Gwyllim, William, of Christchurche, yeoman 2
4193811 2093405 2093405 defendant Merick Rawlin husbandman 650538 650538 Merick, Rawlin, of Christchurche, husbandman 3
4194985 2093808 2093808 defendant Pettye Thomas, senior merchant 650538 650538 Pettye, Thomas, senior, of Christchurche, merchant 0
4194986 2093808 2093808 defendant Markendall Richard merchant 650538 650538 Markendall, Richard, of Christchurche, merchant 1
4204672 2097181 2097181 defendant Heward Richard yeoman 650538 650538 Heward, Richard, of Christchurche, yeoman 3
4218841 2102084 2102084 defendant Elmor Richard mariner 650538 650538 Elmor, Richard, of Christchurche, mariner 0
4261759 2116888 2116888 defendant Scotte Allen yeoman 650538 650538 Scotte, Allen, of Christchurche, yeoman 1
4280563 2123109 2123109 defendant Langley Rice yeoman 650538 650538 Langley, Rice, of Christchurche, yeoman 0
4312260 2134424 2134424 defendant Kyche John yeoman 650538 650538 Kyche, John, of Christchurche, yeoman 0
4312261 2134424 2134424 defendant Deane John yeoman 650538 650538 Deane, John, of Christchurche, yeoman 1
4329424 2140149 2140149 defendant Apprice Henry Thomas husbandman 650538 650538 Apprice, Henry Thomas, of Christchurche, husbandman 4
4366533 2153079 2153079 defendant Lider Alexander Rosser yeoman 650538 650538 Lider, Alexander Rosser, of Christchurche, yeoman 0
4366534 2153079 2153079 defendant Treharne Philip John yeoman 650538 650538 Treharne, Philip John, of Christchurche, yeoman 1
4370146 2154384 2154384 defendant Howell John ap John yeoman 650538 650538 Howell, John ap John, of Christchurche, yeoman 0
4370147 2154384 2154384 defendant Morgan George yeoman 650538 650538 Morgan, George, of Christchurche, yeoman 1
4370493 2154497 2154497 defendant Edmond William husbandman 650538 650538 Edmond, William, of Christchurche, husbandman 1
4370494 2154497 2154497 defendant Thomas John husbandman 650538 650538 Thomas, John, of Christchurche, husbandman 2
4379179 2157636 2157636 defendant Rosser Morgan yeoman 650538 650538 Rosser, Morgan, of Christchurche, yeoman 0
4379186 2157638 2157638 defendant Rosser Morgan yeoman 650538 650538 Rosser, Morgan, of Christchurche, yeoman 0
4381464 2158478 2158478 defendant Parker William husbandman 650538 650538 Parker, William, of Christchurche, husbandman 0
4381465 2158478 2158478 defendant powell Giles husbandman 650538 650538 powell, Giles, of Christchurche, husbandman 1
4381466 2158478 2158478 defendant John Morgan husbandman 650538 650538 John, Morgan, of Christchurche, husbandman 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);