names

31 rows where place_id = 623254

✎ 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
3751453 1942372 1942372 plaintiff Niubre alias Newby James yeoman 623254 623254 Niubre alias Newby, James, of Owndell, yeoman 0
3756087 1943860 1943860 defendant Rusheton John butcher 623254 623254 Rusheton, John, of Owndell, butcher 0
3756766 1944088 1944088 defendant Bullok Robert barber 623254 623254 Bullok, Robert, of Owndell, barber 0
3855535 1975373 1975373 defendant Rushton John glover 623254 623254 Rushton, John, of Owndell, glover 0
3872988 1981181 1981181 defendant Emlyn Thomas butcher 623254 623254 Emlyn, Thomas, of Owndell, butcher 0
3881041 1983929 1983929 defendant Newby James yeoman 623254 623254 Newby, James, of Owndell, yeoman 0
3892048 1987592 1987592 defendant Worseley William, junior fishmonger 623254 623254 Worseley, William, junior, of Owndell, fishmonger 0
3914051 1995044 1995044 defendant Loftys William   623254 623254 Loftys, William, of Owndell, tallow chandler 0
3925135 1998719 1998719 defendant Noke John yeoman 623254 623254 Noke, John, of Owndell, yeoman 0
3925136 1998719 1998719 defendant Hewes John shoemaker 623254 623254 Hewes, John, of Owndell, shoemaker 1
3925137 1998719 1998719 defendant Henmarshe Martin baker 623254 623254 Henmarshe, Martin, of Owndell, baker 2
3927802 1999638 1999638 defendant Myller Henry butcher 623254 623254 Myller, Henry, of Owndell, butcher 0
3951967 2007751 2007751 plaintiff Harryson Richard (legal representative) 623254 623254 Harryson, Richard, of Owndell, mercer, executors of 0
4001941 2025471 2025471 defendant Oliffe Jane widow 623254 623254 Oliffe, Jane, of Owndell, widow 1
4002770 2025757 2025757 defendant Olyf Jane widow 623254 623254 Olyf, Jane, of Owndell, widow 3
4015254 2030149 2030149 plaintiff Smyth Edward tanner 623254 623254 Smyth, Edward, of Owndell, tanner 0
4015255 2030149 2030149 defendant Lawe Hugh (legal representative) 623254 623254 Lawe, Hugh, of Owndell, gent, executor of 0
4018001 2031155 2031155 defendant Fraunces John yeoman 623254 623254 Fraunces, John, of Owndell, yeoman 0
4018913 2031499 2031499 plaintiff Walles John, junior (legal representative) 623254 623254 Walles, John, junior, of Owndell, administratrix of 0
4064581 2047613 2047613 defendant Cooke Richard gent 623254 623254 Cooke, Richard, of Owndell, gent 3
4064582 2047613 2047613 defendant Denysse William knnholder 623254 623254 Denysse, William, of Owndell, knnholder 4
4068250 2048945 2048945 defendant Vessye George currier 623254 623254 Vessye, George, of Owndell, currier 0
4120447 2067590 2067590 defendant Pratt Thomas fishmonger 623254 623254 Pratt, Thomas, of Owndell, fishmonger 1
4168316 2084401 2084401 defendant Pratt Thomas   623254 623254 Pratt, Thomas, of Owndell, Nhants fishmonger 1
4229944 2105956 2105956 defendant Prat Thomas fishmonger 623254 623254 Prat, Thomas, of Owndell, fishmonger 0
4339151 2143452 2143452 defendant Bellamye William yeoman 623254 623254 Bellamye, William, of Owndell, yeoman 0
4962313 2345628 2345628 defendant Sutton William yeoman 623254 623254 Sutton, William, of Owndell, yeoman 5
5066194 2376414 2376414 defendant Folkeworth John, junior husbandman 623254 623254 Folkeworth, John, junior, of Owndell, husbandman 0
5521249 2511464 2511464 defendant Rawleyns Richard yeoman 623254 623254 Rawleyns, Richard, of Owndell, yeoman 0
5582704 2529659 2529659 defendant Barton John miller 623254 623254 Barton, John, of Owndell, miller 0
5593658 2533001 2533001 defendant Raynwyk John clerk 623254 623254 Raynwyk, John, of Owndell, clerk 1

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