names

29 rows where place_id = 654594

✎ 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
3933026 2001341 2001341 plaintiff Goche Robert esq 654594 654594 Goche, Robert, of Southwell, Notts, esq 0
3938956 2003362 2003362 plaintiff Robertson Henry mercer 654594 654594 Robertson, Henry, of Southwell, Notts, mercer 0
3951612 2007618 2007618 defendant Lee Richard gent 654594 654594 (Lee, Richard, of Southwell, Notts, gent 1
3989935 2021156 2021156 defendant Beamond Anthony gent 654594 654594 Beamond, Anthony, of Southwell, Notts, gent 0
4015699 2030313 2030313 defendant Troughton Thomas gent 654594 654594 Troughton, Thomas, of Southwell, Notts, gent 0
4019969 2031870 2031870 defendant Lee Geoffrey (legal representative) 654594 654594 Lee, Geoffrey, of Southwell, Notts, esq, executors of 0
4019971 2031870 2031870 defendant Leigh or Lee Reginald gent 654594 654594 Leigh or Lee, Reginald, of Southwell, Notts, gent 2
4156431 2080327 2080327 defendant Wethered Thomas clerk 654594 654594 Wethered, Thomas, of Southwell, Notts, clerk 0
4161490 2082094 2082094 defendant Walker Robert yeoman 654594 654594 Walker, Robert, of Southwell, Notts, yeoman 0
4238325 2109015 2109015 defendant Spittlehowse John, junior mercer 654594 654594 Spittlehowse, John, junior, of Southwell, Notts, mercer 0
4250969 2113304 2113304 defendant Baskafeld John yeoman 654594 654594 Baskafeld, John, of Southwell, Notts, yeoman 2
4332348 2141111 2141111 defendant Lasco Henry yeoman 654594 654594 Lasco, Henry, of Southwell, Notts, or of Est Grensted, Sussex, yeoman 0
4338776 2143315 2143315 defendant Lea Gervase gent 654594 654594 Lea, Gervase, of Southwell, Notts, gent 0
4355531 2149156 2149156 defendant Marckham John gent 654594 654594 Marckham, John, of Southwell, Notts, gent 0
4375491 2156289 2156289 defendant Spittlehowse John yeoman 654594 654594 Spittlehowse, John, of Southwell, Notts, yeoman 0
4407195 2166970 2166970 defendant Palmer Peter gent 654594 654594 Palmer, Peter, of Southwell, Notts, gent 0
4683824 2260551 2260551 defendant Floure William shoemaker 654594 654594 Floure, William, of Southwell, Notts, shoemaker 0
4764340 2284843 2284843 defendant Buntyng John   654594 654594 Buntyng, John, of Southwell, Notts, wool man 1
5242860 2428116 2428116 defendant Chaworth Thomas esq 654594 654594 Chaworth, Thomas, of Southwell, Notts, esq 2
5269664 2436239 2436239 defendant Chaworth Thomas esq 654594 654594 Chaworth, Thomas, of Southwell, Notts, esq 0
5368926 2465872 2465872 defendant Broun John chapman 654594 654594 Broun, John, of Southwell, Notts, chapman 1
5377008 2468403 2468403 defendant Barkley Robert chaplain & parson of Hewardby 654594 654594 Barkley, Robert, of Southwell, Notts, chaplain & parson of Hewardby 0
5399824 2475042 2475042 defendant Vesse Robert smith 654594 654594 Vesse, Robert, of Southwell, Notts, smith 3
5412821 2478783 2478783 defendant Vesse Robert smith 654594 654594 Vesse, Robert, of Southwell, Notts, smith 3
5427797 2483271 2483271 defendant Vesse Robert smith 654594 654594 Vesse, Robert, of Southwell, Notts, smith 3
5427802 2483272 2483272 defendant Vesse Robert smith 654594 654594 Vesse, Robert, of Southwell, Notts, smith 3
5427807 2483273 2483273 defendant Vesse Robert smith 654594 654594 Vesse, Robert, of Southwell, Notts, smith 3
5568177 2525240 2525240 defendant Elys Robert chapman 654594 654594 Elys, Robert, of Southwell, Notts, chapman 2
5568599 2525366 2525366 defendant Sandford Christopher gent 654594 654594 Sandford, Christopher, of Southwell, Notts, gent 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);