names

34 rows where place_id = 590747

✎ 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
3602168 1868344 1868344 defendant Adam Thomas yeoman 590747 590747 Adam, Thomas, of Langham, Rutland, yeoman 0
3681424 1920276 1920276 defendant Bury Robert husbandman 590747 590747 Bury, Robert, of Langham, Rutland, husbandman 2
3685856 1921735 1921735 defendant Wellysford John shoemaker 590747 590747 Wellysford, John, of Langham, Rutland, shoemaker 2
3759348 1944913 1944913 defendant Mychell John yeoman 590747 590747 Mychell, John, of Langham, Rutland, yeoman 2
3796634 1956824 1956824 defendant Michell John husbandman 590747 590747 Michell, John, of Langham, Rutland, husbandman 0
3810959 1961328 1961328 defendant Bromwynd William clerk 590747 590747 Bromwynd, William, of Langham, Rutland, clerk 0
3819649 1964025 1964025 defendant Clerke William yeoman 590747 590747 Clerke, William, of Langham, Rutland, yeoman 0
3828649 1966839 1966839 plaintiff Clerke William yeoman 590747 590747 Clerke, William, of Langham, Rutland, yeoman 0
3834157 1968626 1968626 plaintiff Michell John   590747 590747 Michell, John, of Langham, Rutland 0
3873842 1981470 1981470 plaintiff Clerke William grasier 590747 590747 Clerke, William, of Langham, Rutland, grasier 0
3915430 1995527 1995527 defendant Dyckman William husbandman 590747 590747 Dyckman, William, of Langham, Rutland, husbandman 0
4051105 2042836 2042836 plaintiff Whitfeld John gent 590747 590747 Whitfeld, John, of Langham, Rutland, gent 0
4051108 2042837 2042837 plaintiff Whitfeld John gent 590747 590747 Whitfeld, John, of Langham, Rutland, gent 0
4051218 2042875 2042875 plaintiff Whytfeld John gent 590747 590747 Whytfeld, John, of Langham, Rutland, gent 0
4297253 2129123 2129123 defendant Stevens Andrew yeoman 590747 590747 Stevens, Andrew, of Langham, Rutland, yeoman 0
4364015 2152187 2152187 defendant Clarke Bartholomew yeoman 590747 590747 Clarke, Bartholomew, of Langham, Rutland, yeoman 0
4364018 2152188 2152188 defendant Berry William husbandman 590747 590747 Berry, William, of Langham, Rutland, husbandman 0
4384323 2159448 2159448 defendant Clarke Bartholomew yeoman 590747 590747 Clarke, Bartholomew, of Langham, Rutland, yeoman 1
4849937 2311453 2311453 defendant Raynald John yeoman 590747 590747 Raynald, John, of Langham, Rutland, yeoman 0
4850477 2311607 2311607 defendant Reynold John drover 590747 590747 Reynold, John, of Langham, Rutland, drover 0
4857537 2313744 2313744 defendant Owekham William   590747 590747 Owekham, William, of Langham, Rutland, husbandman, son of Owekham, Robert 3
4876186 2319510 2319510 defendant Raven Thomas chapman 590747 590747 Raven, Thomas, of Langham, Rutland, chapman 4
5076198 2379381 2379381 defendant Smyth Thomas smith 590747 590747 Smyth, Thomas, of Langham, Rutland, smith 2
5347471 2459374 2459374 defendant Adam William merchant 590747 590747 Adam, William, of Langham, Rutland, merchant 0
5359519 2463007 2463007 defendant Adam Thomas yeoman 590747 590747 Adam, Thomas, of Langham, Rutland, yeoman 0
5383992 2470509 2470509 defendant Adam William   590747 590747 Adam, William, of Langham, Rutland 0
5502132 2505589 2505589 defendant Adam William merchant 590747 590747 Adam, William, of Langham, Rutland, merchant 0
5502134 2505590 2505590 defendant Adam William merchant 590747 590747 Adam, William, of Langham, Rutland, merchant 0
5505186 2506529 2506529 defendant Adam Thomas merchant 590747 590747 Adam, Thomas, of Langham, Rutland, merchant 0
5505191 2506530 2506530 defendant Adam Thomas merchant 590747 590747 Adam, Thomas, of Langham, Rutland, merchant 0
5516480 2509980 2509980 defendant Adam William merchant 590747 590747 Adam, William, of Langham, Rutland, merchant 0
5516482 2509981 2509981 defendant Alean William merchant 590747 590747 Alean, William, of Langham, Rutland, merchant 0
5568807 2525427 2525427 defendant Dykman John yeoman 590747 590747 Dykman, John, of Langham, Rutland, yeoman 0
5570491 2525941 2525941 defendant Bykerstaff Robert laborer 590747 590747 Bykerstaff, Robert, of Langham, Rutland, laborer 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);