names

19 rows where place_id = 657287

✎ 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
3943760 2004931 2004931 defendant Knyght John chapman 657287 657287 Knyght, John, of Banburye, Oxon, chapman 0
3946782 2005945 2005945 defendant Knyght John chapman 657287 657287 Knyght, John, of Banburye, Oxon, chapman 0
3975142 2015870 2015870 defendant Hancox William draper 657287 657287 Hancox, William, of Banburye, Oxon, draper 0
4017720 2031043 2031043 defendant Wygatt Mathew mercer 657287 657287 (Wygatt, Mathew, of Banburye, Oxon, mercer 1
4052397 2043279 2043279 defendant Benett Reginald innholder 657287 657287 Benett, Reginald, of Banburye, Oxon, innholder 0
4076196 2051774 2051774 defendant Luter Thomas glover 657287 657287 Luter, Thomas, of Banburye, Oxon, glover 0
4076200 2051776 2051776 defendant Shorte Robert glover 657287 657287 Shorte, Robert, of Banburye, Oxon, glover 0
4082553 2054065 2054065 defendant Pytman Stephen dyer 657287 657287 Pytman, Stephen, of Banburye, Oxon, dyer 2
4104698 2061961 2061961 plaintiff Morrett Martin   657287 657287 Morrett, Martin, of Banburye, Oxon 0
4195191 2093873 2093873 defendant Adams George chapman 657287 657287 Adams, George, of Banburye, Oxon, chapman 2
4195194 2093874 2093874 defendant Knyght Mathew chapman 657287 657287 Knyght, Mathew, of Banburye, Oxon, chapman 0
4270183 2119612 2119612 defendant Panter John butcher 657287 657287 Panter, John, of Banburye, Oxon, butcher 1
4270256 2119636 2119636 defendant Panter John butcher 657287 657287 Panter, John, of Banburye, Oxon, butcher 1
4296768 2128944 2128944 defendant Robyns William yeoman 657287 657287 Robyns, William, of Banburye, Oxon, yeoman 0
4327599 2139554 2139554 defendant Vardam Roland whitawer 657287 657287 Vardam, Roland, of Banburye, Oxon, whitawer 0
4328544 2139863 2139863 defendant Nicholl George chapman 657287 657287 Nicholl, George, of Banburye, Oxon, chapman 0
4332743 2141234 2141234 defendant Hastar John innholder 657287 657287 Hastar, John, of Banburye, Oxon, innholder 1
4399738 2164500 2164500 defendant Potter William   657287 657287 Potter, William, of Banburye, Oxon, woollen draper 0
4404405 2166041 2166041 defendant Stronge Bartholomew carpenter 657287 657287 Stronge, Bartholomew, of Banburye, Oxon, carpenter 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);