names

35 rows where place_id = 659925

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3954378 2008602 2008602 defendant Willy Thomas husbandman 659925 659925 Willy, Thomas, of Peterston, husbandman 0
3977044 2016539 2016539 defendant Bruer Morgan yeoman 659925 659925 Bruer, Morgan, of Peterston, yeoman 0
3977045 2016539 2016539 defendant William Thomas yeoman 659925 659925 William, Thomas, of Peterston, yeoman 1
3977046 2016539 2016539 defendant Jones Elizabeth widow 659925 659925 Jones, Elizabeth, of Peterston, widow 2
3988847 2020757 2020757 defendant Baty John husbandman 659925 659925 Baty, John, of Peterston, husbandman 0
3988849 2020757 2020757 defendant ap Thomas Thomas husbandman 659925 659925 ap Thomas, Thomas, of Peterston, husbandman 2
3988850 2020757 2020757 defendant Selman John husbandman 659925 659925 Selman, John, of Peterston, husbandman 3
4020428 2032029 2032029 defendant Vawke Thomas husbandman 659925 659925 Vawke, Thomas, of Peterston, husbandman 0
4035081 2037228 2037228 defendant Pylkyngton Andrew gent 659925 659925 Pylkyngton, Andrew, of Peterston, gent 0
4039628 2038784 2038784 defendant Graye James yeoman 659925 659925 Graye, James, of Peterston, yeoman 0
4039629 2038784 2038784 defendant Graye Thomas yeoman 659925 659925 Graye, Thomas, of Peterston, yeoman 1
4048055 2041745 2041745 defendant Gray Firman yeoman 659925 659925 Gray, Firman, of Peterston, yeoman 0
4048059 2041746 2041746 defendant Graye Firman yeoman 659925 659925 Graye, Firman, of Peterston, yeoman 0
4061726 2046594 2046594 defendant Graye Thomas gent 659925 659925 Graye, Thomas, of Peterston, gent 0
4061727 2046594 2046594 defendant Graye James gent 659925 659925 Graye, James, of Peterston, gent 1
4091494 2057249 2057249 defendant Jevan John husbandman 659925 659925 Jevan, John, of Peterston, husbandman 2
4125513 2069407 2069407 defendant Graye Firmun yeoman 659925 659925 Graye, Firmun, of Peterston, yeoman 0
4154564 2079688 2079688 defendant Durban Richard yeoman 659925 659925 Durban, Richard, of Peterston, yeoman 1
4183508 2089713 2089713 defendant Swan Lewis gent 659925 659925 Swan, Lewis, of Peterston, gent 0
4183807 2089828 2089828 defendant Adam Lewis husbandman 659925 659925 Adam, Lewis, of Peterston, husbandman 0
4207158 2098048 2098048 defendant Avan Lewis gent 659925 659925 Avan, Lewis, of Peterston, gent 0
4279991 2122913 2122913 defendant Morgan William gent 659925 659925 Morgan, William, of Peterston, gent 2
4280553 2123107 2123107 defendant Creede Katherine widow 659925 659925 Creede, Katherine, of Peterston, widow 0
4280554 2123107 2123107 defendant Baker James yeoman 659925 659925 Baker, James, of Peterston, yeoman 1
4280555 2123107 2123107 defendant John Henry yeoman 659925 659925 John, Henry, of Peterston, yeoman 2
4280556 2123107 2123107 defendant Creede Abela spinster 659925 659925 Creede, Abela, of Peterston, spinster 3
4282805 2123888 2123888 defendant Durban Henry husbandman 659925 659925 Durban, Henry, of Peterston, husbandman 0
4372984 2155408 2155408 defendant Bruer John yeoman 659925 659925 Bruer, John, of Peterston, yeoman 0
4372985 2155408 2155408 defendant Moris William yeoman 659925 659925 Moris, William, of Peterston, yeoman 1
4372986 2155408 2155408 defendant Creed Francis, junior yeoman 659925 659925 Creed, Francis, junior, of Peterston, yeoman 2
4372991 2155410 2155410 defendant Bruer John yeoman 659925 659925 Bruer, John, of Peterston, yeoman 0
4372992 2155410 2155410 defendant Morris William yeoman 659925 659925 Morris, William, of Peterston, yeoman 1
4372993 2155410 2155410 defendant Creede Francis, junior yeoman 659925 659925 Creede, Francis, junior, of Peterston, yeoman 2
4373056 2155431 2155431 defendant Morgan William gent 659925 659925 Morgan, William, of Peterston, gent 1
4377737 2157110 2157110 defendant Prichard Henry yeoman 659925 659925 Prichard, Henry, of Peterston, yeoman 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);