names

30 rows where place_id = 607492

✎ 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
3669487 1916396 1916396 defendant Leke William husbandman 607492 607492 Leke, William, of Shipmedowe, husbandman 0
3698799 1925842 1925842 defendant Barker Richard husbandman 607492 607492 Barker, Richard, of Shipmedowe, husbandman 0
3968372 2013571 2013571 defendant Hyrd Thomas husbandman 607492 607492 Hyrd, Thomas, of Shipmedowe, husbandman 0
3974607 2015682 2015682 defendant Mowse Richard husbandman 607492 607492 Mowse, Richard, of Shipmedowe, husbandman 0
3974609 2015683 2015683 defendant Mowse Richard husbandman 607492 607492 Mowse, Richard, of Shipmedowe, husbandman 0
3974610 2015684 2015684 plaintiff Herde Thomas yeoman 607492 607492 Herde, Thomas, of Shipmedowe, yeoman 0
3978193 2016954 2016954 defendant Baker alias Wrighte Robert yeoman 607492 607492 Baker alias Wrighte, Robert, of Shipmedowe, yeoman 2
4008447 2027789 2027789 defendant Hyrde Thomas husbandman 607492 607492 Hyrde, Thomas, of Shipmedowe, husbandman 0
4008448 2027789 2027789 defendant Hyrde John husbandman 607492 607492 Hyrde, John, of Shipmedowe, husbandman 1
4017106 2030822 2030822 defendant Wright James husbandman 607492 607492 Wright, James, of Shipmedowe, husbandman 1
4017637 2031017 2031017 defendant Herde Thomas yeoman 607492 607492 Herde, Thomas, of Shipmedowe, yeoman 0
4017639 2031018 2031018 defendant Herde Thomas yeoman 607492 607492 Herde, Thomas, of Shipmedowe, yeoman 0
4017646 2031021 2031021 defendant Mouse Richard husbandman 607492 607492 Mouse, Richard, of Shipmedowe, husbandman 0
4017651 2031022 2031022 defendant Mouse Richard yeoman 607492 607492 Mouse, Richard, of Shipmedowe, yeoman 0
4019598 2031735 2031735 defendant Herde John yeoman 607492 607492 Herde, John, of Shipmedowe, yeoman 0
4019600 2031736 2031736 defendant Herde Thomas yeoman 607492 607492 Herde, Thomas, of Shipmedowe, yeoman 0
4048262 2041820 2041820 defendant Herde Thomas yeoman 607492 607492 Herde, Thomas, of Shipmedowe, yeoman 0
4198835 2095149 2095149 defendant Allard Robert husbandman 607492 607492 Allard, Robert, of Shipmedowe, husbandman 0
4237618 2108748 2108748 defendant Reade Edward yeoman 607492 607492 Reade, Edward, of Shipmedowe, yeoman 1
4246808 2111908 2111908 defendant Athlerd Robert yeoman 607492 607492 Athlerd, Robert, of Shipmedowe, yeoman 1
4281077 2123280 2123280 defendant Oxe Luke tailor 607492 607492 Oxe, Luke, of Shipmedowe, tailor 0
4326993 2139359 2139359 defendant Rombelowe John husbandman 607492 607492 Rombelowe, John, of Shipmedowe, husbandman 1
4389321 2161055 2161055 defendant Lebould George husbandman 607492 607492 Lebould, George, of Shipmedowe, husbandman 1
4405341 2166364 2166364 defendant Payne John yeoman 607492 607492 Payne, John, of Shipmedowe, yeoman 0
4406348 2166688 2166688 defendant Fylbye William yeoman 607492 607492 Fylbye, William, of Shipmedowe, yeoman 2
4412571 2168793 2168793 defendant Wright alias Baker John yeoman 607492 607492 Wright alias Baker, John, of Shipmedowe, yeoman 1
4753286 2281409 2281409 defendant Webster John   607492 607492 Webster, John, of Shipmedowe, parson 1
4898467 2326173 2326173 defendant Thurleton alias Asterne John husbandman 607492 607492 Thurleton alias Asterne, John, of Shipmedowe, husbandman 4
4976071 2349804 2349804 defendant Lorymer John husbandman 607492 607492 Lorymer, John, of Shipmedowe, husbandman 0
4976072 2349804 2349804 defendant Thurton John husbandman 607492 607492 Thurton, John, of Shipmedowe, husbandman 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);