names

25 rows where place_id = 599084

✎ 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
3635139 1905790 1905790 defendant Thomson Robert husbandman 599084 599084 Thomson, Robert, of Swyne, husbandman 1
3635140 1905790 1905790 defendant Longcastre Robert husbandman 599084 599084 Longcastre, Robert, of Swyne, husbandman 2
3971682 2014658 2014658 defendant Bylett Robert   599084 599084 Bylett, Robert, of Swyne, administrators of 0
4038294 2038333 2038333 defendant Clapham Peter yeoman 599084 599084 Clapham, Peter, of Swyne, yeoman 0
4038296 2038334 2038334 defendant Clapham Peter yeoman 599084 599084 Clapham, Peter, of Swyne, yeoman 0
4396839 2163513 2163513 defendant Curtus Gregory husbandman 599084 599084 Curtus, Gregory, of Swyne, husbandman 0
4396840 2163513 2163513 defendant Curtus John, senior husbandman 599084 599084 Curtus, John, senior, of Swyne, husbandman 1
4396841 2163513 2163513 defendant Curtus John, junior husbandman 599084 599084 Curtus, John, junior, of Swyne, husbandman 2
4396842 2163513 2163513 defendant Hardie Peter yeoman 599084 599084 Hardie, Peter, of Swyne, yeoman 3
4396848 2163515 2163515 defendant Yonge Bartholomew laborer 599084 599084 Yonge, Bartholomew, of Swyne, laborer 2
4396849 2163515 2163515 defendant Surebye Thomas laborer 599084 599084 Surebye, Thomas, of Swyne, laborer 3
4577883 2224588 2224588 defendant Tailliory William   599084 599084 Tailliory, William, of Swyne 0
4642891 2244032 2244032 plaintiff Hilton Robert   599084 599084 Hilton, Robert, of Swyne, knight 0
4666282 2250926 2250926 defendant atte Hall William husbandman 599084 599084 atte Hall, William, of Swyne, husbandman 0
4677791 2258673 2258673 defendant Milner John milner 599084 599084 Milner, John, of Swyne, milner 1
4812924 2300155 2300155 defendant Hilton Robert   599084 599084 Hilton, Robert, of Swyne, knight 0
4825817 2304111 2304111 defendant Alman Thomas skinner 599084 599084 Alman, Thomas, of Swyne, skinner 3
4835641 2307139 2307139 defendant del Chaumber John yeoman 599084 599084 del Chaumber, John, of Swyne, yeoman 1
4851324 2311861 2311861 defendant Wylflete Walter husbandman 599084 599084 Wylflete, Walter, of Swyne, husbandman 1
4948765 2341595 2341595 defendant Warde William husbandman 599084 599084 Warde, William, of Swyne, husbandman 0
4956297 2343845 2343845 defendant Ledes John carpenter 599084 599084 Ledes, John, of Swyne, carpenter 1
5122192 2392913 2392913 defendant Crosse William husbandman 599084 599084 Crosse, William, of Swyne, husbandman 1
5251332 2430517 2430517 defendant Boure John laborer 599084 599084 Boure, John, of Swyne, laborer 1
5327188 2453204 2453204 defendant Wann Thomas chaplain 599084 599084 Wann, Thomas, of Swyne, chaplain 0
5571804 2526292 2526292 defendant Parrot George husbandman 599084 599084 Parrot, George, of Swyne, husbandman 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);