names

31 rows where place_id = 598741

✎ 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
3633879 1905405 1905405 defendant Benet William husbandman 598741 598741 Benet, William, of Foye, husbandman 3
3963437 2011815 2011815 defendant Trester alias Trystram John merchant 598741 598741 Trester alias Trystram, John, of Foye, merchant 0
3976808 2016458 2016458 defendant Malowe Richard husbandman 598741 598741 Malowe, Richard, of Foye, husbandman 0
3976810 2016459 2016459 defendant Mutlowe Richard husbandman 598741 598741 Mutlowe, Richard, of Foye, husbandman 0
4054843 2044123 2044123 defendant Burghill John clerk 598741 598741 Burghill, John, of Foye, clerk 0
4056017 2044533 2044533 defendant Burghill John clerk 598741 598741 Burghill, John, of Foye, clerk 0
4059416 2045761 2045761 defendant Allen William yeoman 598741 598741 Allen, William, of Foye, yeoman 0
4082215 2053952 2053952 defendant Burghill John clerk 598741 598741 Burghill, John, of Foye, clerk 0
4082637 2054101 2054101 defendant Allyn William merchant 598741 598741 Allyn, William, of Foye, merchant 0
4098206 2059686 2059686 defendant Wylse John husbandman or yeoman 598741 598741 Wylse, John, of Foye, or of Dymocke, Glos, husbandman or yeoman 0
4107876 2063094 2063094 defendant Broke Thomas smith 598741 598741 Broke, Thomas, of Foye, smith 0
4107881 2063095 2063095 defendant Broke Thomas yeoman 598741 598741 Broke, Thomas, of Foye, yeoman 0
4107890 2063097 2063097 defendant Brooke Thomas smith 598741 598741 together with Brooke, Thomas, of Foye, smith 2
4142027 2075385 2075385 defendant Cole Walter butcher 598741 598741 Cole, Walter, of Foye, butcher 0
4166323 2083714 2083714 defendant Wilse John yeoman 598741 598741 Wilse, John, of Foye, yeoman 1
4220146 2102547 2102547 defendant Burghell John clerk 598741 598741 Burghell, John, of Foye, clerk 0
4229107 2105663 2105663 defendant Burghill John clerk 598741 598741 Burghill, John, of Foye, clerk 0
4237611 2108746 2108746 defendant Burghill John clerk 598741 598741 Burghill, John, of Foye, clerk 0
4258794 2115908 2115908 defendant Elston William yeoman 598741 598741 Elston, William, of Foye, or of Sudbery, Suff, yeoman 1
4270625 2119753 2119753 defendant Eliston William yeoman 598741 598741 Eliston, William, of Foye, or of Sudburye, Suff, yeoman 1
4300803 2130384 2130384 defendant Baker Robert yeoman 598741 598741 Baker, Robert, of Foye, or of Magna Dewchurche, yeoman 0
4303426 2131326 2131326 defendant Burghill John clerk 598741 598741 Burghill, John, of Foye, clerk 2
4314068 2135028 2135028 defendant Abrahall John weaver 598741 598741 Abrahall, John, of Foye, weaver 1
4360925 2151078 2151078 defendant Burhull Anthony gent 598741 598741 Burhull, Anthony, of Foye, gent 0
4387227 2160376 2160376 defendant Howchen Peter merchant 598741 598741 Howchen, Peter, of Foye, merchant 0
4389184 2161012 2161012 defendant Peter Thomas, junior merchant 598741 598741 Peter, Thomas, junior, of Foye, merchant 0
4412599 2168803 2168803 defendant Lampen Peter husbandman 598741 598741 Lampen, Peter, of Foye, husbandman 2
4412600 2168803 2168803 defendant James Reginald husbandman 598741 598741 James, Reginald, of Foye, husbandman 3
4701112 2265754 2265754 defendant Moton Thomas yeoman 598741 598741 Moton, Thomas, of Foye, yeoman 0
5388897 2471887 2471887 defendant Bayton John husbandman 598741 598741 Bayton, John, of Foye, husbandman 2
5401574 2475519 2475519 defendant Dayton John husbandman 598741 598741 Dayton, John, of Foye, husbandman 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);