names

17 rows where place_id = 623683

✎ 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
3753731 1943108 1943108 defendant Garthe John husbandman 623683 623683 Garthe, John, of Bowes, husbandman 0
4008961 2027969 2027969 defendant Dodisworth Christopher yeoman 623683 623683 Dodisworth, Christopher, of Bowes, yeoman 0
4034553 2037031 2037031 defendant Cotes George yeoman 623683 623683 Cotes, George, of Bowes, yeoman 0
4034555 2037032 2037032 defendant Cotes George yeoman 623683 623683 Cotes, George, of Bowes, yeoman 0
4403106 2165617 2165617 defendant Alderson Roger husbandman 623683 623683 Alderson, Roger, of Bowes, husbandman 1
4403107 2165617 2165617 defendant Cotes Thomas husbandman 623683 623683 Cotes, Thomas, of Bowes, husbandman 2
4478491 2193945 2193945 plaintiff Thomson Hugh   623683 623683 (Thomson, Hugh, of Bowes 1
4486661 2196539 2196539 defendant Thomson Hugh   623683 623683 Thomson, Hugh, of Bowes 0
4570180 2222243 2222243 plaintiff Wodecok Thomas   623683 623683 Wodecok, Thomas, of Bowes 0
4570182 2222244 2222244 plaintiff Wodecok Thomas   623683 623683 Wodecok, Thomas, of Bowes 0
4570189 2222245 2222245 plaintiff Wodecok Thomas   623683 623683 Wodecok, Thomas, of Bowes 0
5130767 2395486 2395486 defendant Cartmale William smith 623683 623683 Cartmale, William, of Bowes, smith 0
5327751 2453368 2453368 defendant Spence Thomas gent 623683 623683 Spence, Thomas, of Bowes, gent 1
5406299 2476872 2476872 defendant Cotes Adam yeoman 623683 623683 Cotes, Adam, of Bowes, yeoman 1
5406302 2476873 2476873 defendant Cotes Adam yeoman 623683 623683 Cotes, Adam, of Bowes, yeoman 1
5406305 2476874 2476874 defendant Cotes Adam yeoman 623683 623683 Cotes, Adam, of Bowes, yeoman 1
5609818 2546772 2546772 defendant del Spen Thomas   623683 623683 del Spen, Thomas, of Bowes 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);