names

24 rows where place_id = 686097

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4065268 2047859 2047859 defendant Browne Thomas husbandman 686097 686097 Browne, Thomas, of Hicklinge, husbandman 1
4092446 2057600 2057600 defendant Wryght Edmund yeoman 686097 686097 Wryght, Edmund, of Hicklinge, yeoman 1
4173865 2086314 2086314 defendant Porringer William yeoman 686097 686097 Porringer, William, of Hicklinge, yeoman 0
4174313 2086479 2086479 defendant Berre William, senior yeoman 686097 686097 Berre, William, senior, of Hicklinge, yeoman 0
4197111 2094543 2094543 defendant Porringer William yeoman 686097 686097 Porringer, William, of Hicklinge, yeoman 0
4249887 2112943 2112943 defendant Bisshopp William yeoman 686097 686097 Bisshopp, William, of Hicklinge, yeoman 1
4254061 2114357 2114357 defendant Verden Joan widow 686097 686097 Verden, Joan, of Hicklinge, widow 3
4270220 2119623 2119623 defendant Moneyman Richard weaver 686097 686097 Moneyman, Richard, of Hicklinge, weaver 3
4277025 2121897 2121897 defendant Williams Zachary husbandman 686097 686097 Williams, Zachary, of Hicklinge, husbandman 1
4277291 2121987 2121987 defendant Ellis Ambrose gent 686097 686097 Ellis, Ambrose, of Hicklinge, gent 3
4279687 2122814 2122814 defendant Harman William (legal representative) 686097 686097 Harman, William, of Hicklinge, yeoman, executor of 1
4287754 2125670 2125670 defendant Acton John gent 686097 686097 Acton, John, of Hicklinge, gent 0
4287755 2125670 2125670 defendant Wright Thomas yeoman 686097 686097 Wright, Thomas, of Hicklinge, yeoman 1
4310987 2133989 2133989 defendant Monyman Robert yeoman 686097 686097 Monyman, Robert, of Hicklinge, yeoman 0
4314174 2135065 2135065 defendant Skeete Luke husbandman 686097 686097 Skeete, Luke, of Hicklinge, husbandman 0
4314175 2135065 2135065 defendant Lawes Hugh husbandman 686097 686097 Lawes, Hugh, of Hicklinge, husbandman 1
4329057 2140029 2140029 defendant Eshe John husbandman 686097 686097 Eshe, John, of Hicklinge, husbandman 0
4329058 2140029 2140029 defendant Wrighte Edmund yeoman 686097 686097 Wrighte, Edmund, of Hicklinge, yeoman 1
4329059 2140029 2140029 defendant Mighell Edmund yeoman 686097 686097 Mighell, Edmund, of Hicklinge, yeoman 2
4329601 2140200 2140200 defendant Hudson Francis husbandman 686097 686097 Hudson, Francis, of Hicklinge, husbandman 1
4352204 2148006 2148006 defendant Walters John husbandman 686097 686097 Walters, John, of Hicklinge, husbandman 1
4352205 2148006 2148006 defendant Watt John husbandman 686097 686097 Watt, John, of Hicklinge, husbandman 2
4357714 2149932 2149932 defendant Allen Richard   686097 686097 Allen, Richard, of Hicklinge, clerk, verbi minister 0
4395974 2163229 2163229 defendant Fayrebarne William gent 686097 686097 Fayrebarne, William, of Hicklinge, 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);