names

27 rows where place_id = 609369

✎ 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
3678126 1919209 1919209 defendant Maunsey Robert husbandman 609369 609369 Maunsey, Robert, of Russhemer, husbandman 0
3730886 1935887 1935887 defendant Byrd Andrew husbandman 609369 609369 Byrd, Andrew, of Russhemer, husbandman 0
3730887 1935887 1935887 defendant Ussherwood John   609369 609369 Ussherwood, John, of Russhemer 1
3769461 1948109 1948109 defendant Sutton Hugh husbandman 609369 609369 Sutton, Hugh, of Russhemer, husbandman 0
3786709 1953640 1953640 defendant Ussherwoode John yeoman 609369 609369 Ussherwoode, John, of Russhemer, yeoman 0
3800611 1958102 1958102 plaintiff Lyngoode Robert (legal representative) 609369 609369 Lyngoode, Robert, of Russhemer, yeoman, executrix of 0
3810343 1961125 1961125 defendant Nestlyn John husbandman 609369 609369 Nestlyn, John, of Russhemer, husbandman 0
3823564 1965273 1965273 defendant Ussherwode John yeoman 609369 609369 Ussherwode, John, of Russhemer, yeoman 0
3834438 1968718 1968718 defendant Bacon Thomas husbandman 609369 609369 Bacon, Thomas, of Russhemer, husbandman 0
3835073 1968910 1968910 defendant Coke Richard husbandman 609369 609369 Coke, Richard, of Russhemer, husbandman 1
3843947 1971646 1971646 defendant Bacon Edmund husbandman 609369 609369 Bacon, Edmund, of Russhemer, husbandman 0
3843948 1971646 1971646 defendant Bacon Thomas, junior   609369 609369 Bacon, Thomas, junior, of Russhemer, sack weaver 1
3859988 1976842 1976842 defendant Bacon Thomas, junior   609369 609369 Bacon, Thomas, junior, of Russhemer, twill weaver 0
3861859 1977425 1977425 defendant Bakon Thomas husbandman 609369 609369 Bakon, Thomas, of Russhemer, husbandman 1
3876878 1982508 1982508 defendant Bacon Thomas yeoman 609369 609369 Bacon, Thomas, of Russhemer, yeoman 0
3876880 1982509 1982509 defendant Bacon Thomas yeoman 609369 609369 Bacon, Thomas, of Russhemer, yeoman 0
3880308 1983668 1983668 defendant Cooke Edmund husbandman 609369 609369 Cooke, Edmund, of Russhemer, husbandman 0
3909497 1993476 1993476 defendant Bacon Thomas, junior   609369 609369 Bacon, Thomas, junior, of Russhemer, twill weaver 4
3938607 2003255 2003255 defendant Gees Edmund yeoman 609369 609369 Gees, Edmund, of Russhemer, yeoman 0
3985425 2019546 2019546 defendant Ussherwood alias Thurstone John husbandman 609369 609369 Ussherwood alias Thurstone, John, of Russhemer, husbandman 0
5256575 2432176 2432176 defendant Cady William yeoman 609369 609369 Cady, William, of Russhemer, yeoman 1
5373879 2467427 2467427 defendant Shipman Richard yeoman 609369 609369 Shipman, Richard, of Russhemer, yeoman 3
5447121 2489030 2489030 defendant Shipman Richard husbandman 609369 609369 Shipman, Richard, of Russhemer, husbandman 0
5447122 2489030 2489030 defendant Bronster William husbandman 609369 609369 Bronster, William, of Russhemer, husbandman 1
5459577 2492778 2492778 defendant Shipman Richard husbandman 609369 609369 Shipman, Richard, of Russhemer, husbandman 0
5459578 2492778 2492778 defendant Browster William husbandman 609369 609369 Browster, William, of Russhemer, husbandman 1
5559274 2522680 2522680 defendant Bacon Thomas husbandman 609369 609369 Bacon, Thomas, of Russhemer, husbandman 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);