names

29 rows where place_id = 658754

✎ 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
3949663 2006957 2006957 defendant Kyng Robert gent 658754 658754 Kyng, Robert, of Newberye, Berks, gent 0
3967905 2013402 2013402 defendant Hardinge Lawrence mercer 658754 658754 Hardinge, Lawrence, of Newberye, Berks, mercer 0
4001310 2025247 2025247 defendant Hynde Henry   658754 658754 Hynde, Henry, of Newberye, Berks, linen draper 0
4008538 2027818 2027818 plaintiff Moore John capper 658754 658754 Moore, John, of Newberye, Berks, capper 0
4025809 2033883 2033883 defendant Hynde Henry chapman 658754 658754 Hynde, Henry, of Newberye, Berks, chapman 0
4034096 2036856 2036856 defendant Hynde Giles glover 658754 658754 Hynde, Giles, of Newberye, Berks, glover 0
4034098 2036857 2036857 defendant Hynde Henry glover 658754 658754 Hynde, Henry, of Newberye, Berks, glover 0
4039073 2038600 2038600 defendant Hynde Henry   658754 658754 Hynde, Henry, of Newberye, Berks, kinen draper 0
4064692 2047660 2047660 defendant Hawkyns Walter clothier 658754 658754 Hawkyns, Walter, of Newberye, Berks, clothier 0
4096580 2059104 2059104 defendant Gase alias Taylor John chapman 658754 658754 Gase alias Taylor, John, of Newberye, Berks, chapman 2
4105560 2062271 2062271 defendant Chamberleyne Brian clothier 658754 658754 Chamberleyne, Brian, of Newberye, Berks, clothier 0
4108675 2063357 2063357 defendant Hore Maurice chapman 658754 658754 Hore, Maurice, of Newberye, Berks, chapman 3
4123577 2068734 2068734 defendant Wilkinson Griffin chandler 658754 658754 Wilkinson, Griffin, of Newberye, Berks, chandler 0
4145849 2076702 2076702 defendant Gregorye George vintner 658754 658754 Gregorye, George, of Newberye, Berks, vintner 1
4152761 2079075 2079075 defendant Hynde Henry chapman 658754 658754 Hynde, Henry, of Newberye, Berks, chapman 1
4162646 2082495 2082495 defendant Twyne William clothier 658754 658754 Twyne, William, of Newberye, Berks, clothier 0
4166289 2083703 2083703 defendant Mellys Edward clothier 658754 658754 Mellys, Edward, of Newberye, Berks, clothier 0
4202671 2096477 2096477 defendant Chamberleyn Brian clothier 658754 658754 Chamberleyn, Brian, of Newberye, Berks, clothier 1
4204429 2097095 2097095 defendant Bennett Edward mercer 658754 658754 Bennett, Edward, of Newberye, Berks, mercer 2
4207661 2098237 2098237 defendant Dennys Richard chapman 658754 658754 Dennys, Richard, of Newberye, Berks, chapman 3
4212520 2099922 2099922 defendant Heylocke Mathew yeoman 658754 658754 Heylocke, Mathew, of Newberye, Berks, yeoman 1
4235196 2107871 2107871 defendant Ryppen William chapman 658754 658754 Ryppen, William, of Newberye, Berks, chapman 0
4260762 2116563 2116563 defendant Dolman   chapman 658754 658754 Dolman, , of Newberye, Berks, chapman 0
4263432 2117431 2117431 defendant Coxe Henry mercer 658754 658754 Coxe, Henry, of Newberye, Berks, mercer 0
4278797 2122522 2122522 defendant Skidmore John vintner 658754 658754 Skidmore, John, of Newberye, Berks, vintner 0
4339601 2143618 2143618 defendant Woodleafe alias Woodley Edward tailor 658754 658754 Woodleafe alias Woodley, Edward, of Newberye, Berks, tailor 0
4345814 2145799 2145799 defendant Rigbie William chapman 658754 658754 Rigbie, William, of Newberye, Berks, chapman 2
4367597 2153465 2153465 defendant Smyth John saddler 658754 658754 Smyth, John, of Newberye, Berks, saddler 1
4398029 2163920 2163920 defendant Gough Thomas yeoman 658754 658754 Gough, Thomas, of Newberye, Berks, yeoman 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);