names

27 rows where place_id = 656094

✎ 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
3938795 2003313 2003313 defendant Morgatrode William laborer 656094 656094 Morgatrode, William, of Wetherby, laborer 0
3984405 2019180 2019180 plaintiff Sysson William gent 656094 656094 Sysson, William, of Wetherby, gent 0
3984407 2019181 2019181 plaintiff Sysson William gent 656094 656094 Sysson, William, of Wetherby, gent 0
4071971 2050273 2050273 defendant Kaye George gent 656094 656094 Kaye, George, of Wetherby, gent 1
4095099 2058576 2058576 defendant Scysson William gent 656094 656094 Scysson, William, of Wetherby, gent 0
4141983 2075367 2075367 defendant Toppan Thomas   656094 656094 Toppan, Thomas, of Wetherby, Yorks yeoman 0
4149590 2077981 2077981 defendant Toppan Thomas   656094 656094 Toppan, Thomas, of Wetherby, Yorks yeoman 0
4162240 2082352 2082352 defendant Topham Thomas laborer 656094 656094 Topham, Thomas, of Wetherby, laborer 0
4162241 2082352 2082352 defendant Danyell Edward laborer 656094 656094 Danyell, Edward, of Wetherby, laborer 1
4424680 2172558 2172558 defendant Bilton Hugh de   656094 656094 Bilton, Hugh de, of Wetherby 0
4448389 2184426 2184426 plaintiff Forster John   656094 656094 Forster, John, of Wetherby 0
4448391 2184426 2184426 defendant Gulsok Stephen   656094 656094 Gulsok, Stephen, of Wetherby 1
4448392 2184426 2184426 defendant Smyth Thomas   656094 656094 Smyth, Thomas, of Wetherby 2
4448393 2184426 2184426 defendant Kerby John de   656094 656094 Kerby, John de, of Wetherby 3
4466548 2190213 2190213 defendant Kereby John de   656094 656094 Kereby, John de, of Wetherby 0
4493439 2198653 2198653 defendant Nuthawe Richard   656094 656094 Nuthawe, Richard, of Wetherby 3
4607166 2233356 2233356 plaintiff Beche Edmund   656094 656094 Beche, Edmund, of Wetherby 0
4659277 2248769 2248769 defendant Tilly John smith 656094 656094 Tilly, John, of Wetherby, smith 4
4663036 2249904 2249904 defendant Calverlay William dyer 656094 656094 Calverlay, William, of Wetherby, dyer 5
4663037 2249904 2249904 defendant Walker John walker 656094 656094 Walker, John, of Wetherby, walker 6
4790274 2293043 2293043 defendant Benson William fleshewer or butcher 656094 656094 Benson, William, of Wetherby, fleshewer or butcher 0
4790275 2293043 2293043 defendant Bonay or Bovay John husbandman 656094 656094 Bonay or Bovay, John, of Wetherby, husbandman 1
4790276 2293043 2293043 defendant Catton William husbandman 656094 656094 Catton, William, of Wetherby, husbandman 2
4878714 2320282 2320282 defendant Smyth Thomas smith 656094 656094 Smyth, Thomas, of Wetherby, smith 3
5004396 2358182 2358182 defendant Somerset William yeoman 656094 656094 Somerset, William, of Wetherby, yeoman 4
5561477 2523335 2523335 defendant Parke John cooper 656094 656094 Parke, John, of Wetherby, cooper 0
5635895 2555186 2555186 defendant Bell John hosteler 656094 656094 Bell, John, of Wetherby, hosteler 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);