names

31 rows where place_id = 659276

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3951818 2007697 2007697 defendant Barclough Edward clothier 659276 659276 Barclough, Edward, of Hallyfax, clothier 0
3972614 2014997 2014997 defendant Gybson Edward shoemaker 659276 659276 Gybson, Edward, of Hallyfax, shoemaker 2
3972615 2014997 2014997 defendant Gybson William shoemaker 659276 659276 Gybson, William, of Hallyfax, shoemaker 3
3983049 2018714 2018714 defendant Foxe Edward clothier 659276 659276 Foxe, Edward, of Hallyfax, clothier 2
3989316 2020919 2020919 defendant Hyll Edward dyer 659276 659276 Hyll, Edward, of Hallyfax, dyer 0
3990215 2021256 2021256 plaintiff Bentley George (legal representative) 659276 659276 Bentley, George, of Hallyfax, clothier, executors of 0
3998108 2024082 2024082 defendant Nycholson Michael chapman 659276 659276 Nycholson, Michael, of Hallyfax, chapman 0
4010170 2028406 2028406 plaintiff Holdesworth Peter clothier 659276 659276 (Holdesworth, Peter, of Hallyfax, clothier 1
4010171 2028406 2028406 plaintiff Otes Gilbert innholder 659276 659276 Otes, Gilbert, of Hallyfax, innholder 2
4010172 2028406 2028406 plaintiff Otes Robert clothier 659276 659276 Otes, Robert, of Hallyfax, clothier 3
4010173 2028406 2028406 plaintiff Otes George clothier 659276 659276 Otes, George, of Hallyfax, clothier 4
4010174 2028406 2028406 plaintiff Hayley James clothier 659276 659276 Hayley, James, of Hallyfax, clothier 5
4019372 2031662 2031662 plaintiff Watson Ursula widow 659276 659276 Ursula his wife, alias Ursula Farror, of Hallyfax, widow 1
4027706 2034557 2034557 defendant Nicolis or Nicholas Gilbert clothier 659276 659276 Nicolis or Nicholas, Gilbert, of Hallyfax, clothier 3
4043401 2040102 2040102 defendant Horsfall William butcher 659276 659276 Horsfall, William, of Hallyfax, butcher 1
4064160 2047456 2047456 defendant Haldysworth George   659276 659276 Haldysworth, George, of Hallyfax, surgeon 4
4081892 2053827 2053827 defendant Appleyard Thomas yeoman 659276 659276 Appleyard, Thomas, of Hallyfax, yeoman 0
4086826 2055580 2055580 defendant Hayworthe Thomas butcher 659276 659276 Hayworthe, Thomas, of Hallyfax, butcher 0
4092327 2057556 2057556 defendant Hardy Peter yeoman 659276 659276 Hardy, Peter, of Hallyfax, yeoman 1
4099867 2060278 2060278 defendant Brodeley Thomas yeoman 659276 659276 Brodeley, Thomas, of Hallyfax, yeoman 1
4099871 2060279 2060279 defendant Brodley Thomas yeoman 659276 659276 Brodley, Thomas, of Hallyfax, yeoman 1
4144882 2076369 2076369 defendant Hill Edward, senior dyer 659276 659276 Hill, Edward, senior, of Hallyfax, dyer 0
4150901 2078449 2078449 defendant Ramsden Hugh clothier 659276 659276 Ramsden, Hugh, of Hallyfax, clothier 0
4157307 2080621 2080621 defendant Hill Charles dyer 659276 659276 Hill, Charles, of Hallyfax, dyer 0
4171972 2085659 2085659 defendant Woodhead John yeoman 659276 659276 Woodhead, John, of Hallyfax, yeoman 0
4182256 2089271 2089271 defendant Haldsworthe William   659276 659276 Haldsworthe, William, of Hallyfax, yeoman, or of Blakehill, Northowrome, wool driver 1
4184524 2090095 2090095 defendant Bairstowe Richard butcher 659276 659276 Bairstowe, Richard, of Hallyfax, butcher 0
4216729 2101344 2101344 defendant Ledsham Henry   659276 659276 Ledsham, Henry, of Hallyfax, Doctor of Theology 0
4216731 2101344 2101344 defendant Nichols Isaac yeoman 659276 659276 Nichols, Isaac, of Hallyfax, yeoman 2
4386701 2160229 2160229 defendant Gyllatt   weaver 659276 659276 Gyllatt, , of Hallyfax, ,weaver 3
4408740 2167519 2167519 defendant Wilson Thomas carrier 659276 659276 Wilson, Thomas, of Hallyfax, carrier 2

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);