names

34 rows where place_id = 588002

✎ 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
3593071 1865460 1865460 defendant Irelond Robert, junior husbandman 588002 588002 Irelond, Robert, junior, of Lydyngton, husbandman 0
3683531 1920982 1920982 plaintiff Watson Edward   588002 588002 Watson, Edward, of Lydyngton 0
3683534 1920983 1920983 plaintiff Watson Edward   588002 588002 Watson, Edward, of Lydyngton 0
3683536 1920983 1920983 defendant Mariate John baker 588002 588002 Mariate, John, of Lydyngton, baker 1
3897057 1989235 1989235 defendant Bocher alias Baker John butcher 588002 588002 Bocher alias Baker, John, of Lydyngton, butcher 0
4573832 2223334 2223334 plaintiff Baxster Henry (legal representative) 588002 588002 Baxster, Henry, of Lydyngton, executor of 0
4574187 2223452 2223452 defendant Forrider William   588002 588002 Forrider, William, of Lydyngton 0
4771700 2287126 2287126 defendant Wardrop John de yeoman 588002 588002 Wardrop, John de, of Lydyngton, yeoman 0
4771701 2287126 2287126 defendant Parker Richard yeoman 588002 588002 Parker, Richard, of Lydyngton, yeoman 1
4814389 2300610 2300610 defendant Mitford Thomas gent 588002 588002 Mitford, Thomas, of Lydyngton, gent 0
4889978 2323650 2323650 defendant Clendon Philip husbandman 588002 588002 Clendon, Philip, of Lydyngton, husbandman 1
4901578 2327093 2327093 defendant Clendon Philip husbandman 588002 588002 Clendon, Philip, of Lydyngton, husbandman 0
4905800 2328417 2328417 defendant Clondon Philip husbandman 588002 588002 Clondon, Philip, of Lydyngton, husbandman 1
4905802 2328417 2328417 defendant Wardrope John husbandman 588002 588002 Wardrope, John, of Lydyngton, husbandman 3
4924801 2334189 2334189 defendant Tomlyn William husbandman 588002 588002 Tomlyn, William, of Lydyngton, husbandman 2
4933213 2336777 2336777 defendant Ray Thomas husbandman 588002 588002 Ray, Thomas, of Lydyngton, husbandman 3
4958217 2344426 2344426 defendant Godewyn John barber 588002 588002 Godewyn, John, of Lydyngton, barber 0
5018727 2362370 2362370 defendant Glendon Philip husbandman 588002 588002 Glendon, Philip, of Lydyngton, husbandman 0
5043774 2369765 2369765 plaintiff Thorp Henry   588002 588002 Thorp, Henry, of Lydyngton 1
5075523 2379176 2379176 defendant Baster John yeoman 588002 588002 Baster, John, of Lydyngton, yeoman 2
5139893 2398148 2398148 defendant Boyvyll Thomas yeoman 588002 588002 Boyvyll, Thomas, of Lydyngton, yeoman 0
5143403 2399208 2399208 defendant Baxter John yeoman 588002 588002 Baxter, John, of Lydyngton, yeoman 2
5178046 2409280 2409280 defendant Baxter John yeoman 588002 588002 Baxter, John, of Lydyngton, yeoman 2
5201223 2416115 2416115 defendant Baxter John yeoman 588002 588002 Baxter, John, of Lydyngton, yeoman 2
5246439 2429124 2429124 defendant Bothe William yeoman 588002 588002 Bothe, William, of Lydyngton, yeoman 0
5246441 2429124 2429124 defendant Foryder Richard tailor 588002 588002 Foryder, Richard, of Lydyngton, tailor 2
5246442 2429124 2429124 defendant Claye Robert   588002 588002 Claye, Robert, of Lydyngton 3
5282095 2439837 2439837 defendant Irelond Robert husbandman 588002 588002 Irelond, Robert, of Lydyngton, husbandman 1
5282097 2439837 2439837 defendant Ocley John husbandman 588002 588002 Ocley, John, of Lydyngton, husbandman 3
5282098 2439837 2439837 defendant Wassyngton John yeoman 588002 588002 Wassyngton, John, of Lydyngton, yeoman 4
5362008 2463780 2463780 defendant Barwell Simon husbandman 588002 588002 Barwell, Simon, of Lydyngton, husbandman 0
5362010 2463781 2463781 defendant Barwell Simon husbandman 588002 588002 Barwell, Simon, of Lydyngton, husbandman 0
5367575 2465506 2465506 defendant Barwell Simon chapman 588002 588002 Barwell, Simon, of Lydyngton, chapman 0
5576808 2527792 2527792 defendant Slye Robert baker 588002 588002 Slye, Robert, of Lydyngton, baker 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);