names

33 rows where place_id = 641716

✎ 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
3863417 1977957 1977957 defendant Mathewe Peter husbandman 641716 641716 Mathewe, Peter, of Edgefeld, husbandman 3
3877378 1982679 1982679 defendant Saunders John   641716 641716 Saunders, John, of Edgefeld, "hayremaker" 1
3877381 1982680 1982680 defendant Saunders John   641716 641716 Saunders, John, of Edgefeld, "hayremaker" 1
3886978 1985907 1985907 defendant Bacon Henry clerk 641716 641716 Bacon, Henry, of Edgefeld, clerk 0
3941114 2004030 2004030 defendant Feke William, senior yeoman 641716 641716 Feke, William, senior, of Edgefeld, yeoman 0
3965680 2012611 2012611 defendant Feke Thomas husbandman 641716 641716 Feke, Thomas, of Edgefeld, husbandman 0
3967151 2013136 2013136 defendant Barker John weaver 641716 641716 Barker, John, of Edgefeld, weaver 3
3967152 2013136 2013136 defendant Clarke Robert carpenter 641716 641716 Clarke, Robert, of Edgefeld, carpenter 4
3967153 2013136 2013136 defendant Cowper Thomas tailor 641716 641716 Cowper, Thomas, of Edgefeld, tailor 5
3967154 2013136 2013136 defendant Otty Thomas yeoman 641716 641716 Otty, Thomas, of Edgefeld, yeoman 6
3970671 2014330 2014330 defendant Feke Thomas husbandman 641716 641716 Feke, Thomas, of Edgefeld, husbandman 0
3974669 2015708 2015708 defendant Curtes Humphrey husbandman 641716 641716 Curtes, Humphrey, of Edgefeld, husbandman 1
3977078 2016552 2016552 defendant Hamond Thomas husbandman 641716 641716 Hamond, Thomas, of Edgefeld, husbandman 0
3984091 2019076 2019076 defendant Feake Thomas   641716 641716 Feake, Thomas, of Edgefeld, hair weaver 0
4014978 2030071 2030071 defendant Gavell Roger clerk 641716 641716 Gavell, Roger, of Edgefeld, clerk 4
4052029 2043150 2043150 defendant Whight Thomas yeoman 641716 641716 (Whight, Thomas, of Edgefeld, yeoman 1
4083135 2054258 2054258 defendant Woodcock Thomas husbandman 641716 641716 Woodcock, Thomas, of Edgefeld, husbandman 1
4120078 2067468 2067468 defendant Otwey Thomas yeoman 641716 641716 Otwey, Thomas, of Edgefeld, yeoman 3
4147147 2077142 2077142 defendant Hawke Robert sawyer 641716 641716 Hawke, Robert, of Edgefeld, sawyer 3
4155186 2079906 2079906 defendant Hawkes Robert laborer 641716 641716 Hawkes, Robert, of Edgefeld, laborer 2
4161577 2082118 2082118 defendant Hamond James husbandman 641716 641716 Hamond, James, of Edgefeld, husbandman 0
4201642 2096118 2096118 defendant Baker William yeoman 641716 641716 Baker, William, of Edgefeld, yeoman 0
4256593 2115176 2115176 defendant Shepperd William yeoman 641716 641716 Shepperd, William, of Edgefeld, yeoman 0
4318326 2136517 2136517 defendant Dowe John carpenter 641716 641716 Dowe, John, of Edgefeld, carpenter 0
4344252 2145268 2145268 defendant Blackborme Geoffrey husbandman 641716 641716 together with Blackborme, Geoffrey, of Edgefeld, husbandman 1
4352265 2148027 2148027 defendant Buttyvante Roger gent 641716 641716 Buttyvante, Roger, of Edgefeld, gent 0
5225098 2423008 2423008 defendant Colyns John husbandman 641716 641716 Colyns, John, of Edgefeld, husbandman 0
5225099 2423008 2423008 defendant Mathu Thomas glover 641716 641716 Mathu, Thomas, of Edgefeld, glover 1
5274551 2437637 2437637 defendant Mathewe Thomas yeoman 641716 641716 Mathewe, Thomas, of Edgefeld, yeoman 2
5296826 2444062 2444062 defendant Curteys Andrew husbandman 641716 641716 Curteys, Andrew, of Edgefeld, husbandman 0
5370695 2466424 2466424 defendant Lawes William husbandman 641716 641716 Lawes, William, of Edgefeld, husbandman 2
5399494 2474934 2474934 defendant Mathewes Thomas yeoman 641716 641716 Mathewes, Thomas, of Edgefeld, yeoman 0
5499575 2504819 2504819 defendant Sevynpens John pedder 641716 641716 Sevynpens, John, of Edgefeld, pedder 2

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);