names

21 rows where place_id = 637274

✎ 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
3835462 1969031 1969031 defendant Collen John husbandman 637274 637274 Collen, John, of Kennynghall, husbandman 0
4025670 2033833 2033833 defendant Walker Andrew yeoman 637274 637274 Walker, Andrew, of Kennynghall, yeoman 0
4072562 2050492 2050492 defendant Pers William tailor 637274 637274 Pers, William, of Kennynghall, tailor 1
4082389 2054010 2054010 defendant Eldred Thomas husbandman 637274 637274 Eldred, Thomas, of Kennynghall, husbandman 0
4150707 2078387 2078387 defendant Tanner Henry yeoman 637274 637274 Tanner, Henry, of Kennynghall, yeoman 0
4150708 2078387 2078387 defendant Foister Henry yeoman 637274 637274 Foister, Henry, of Kennynghall, yeoman 1
4190611 2092278 2092278 defendant Taylor Aldram husbandman 637274 637274 Taylor, Aldram, of Kennynghall, husbandman 0
4193755 2093386 2093386 defendant Tanner Henry yeoman 637274 637274 Tanner, Henry, of Kennynghall, yeoman 0
4205760 2097563 2097563 defendant Howlett Edmund carpenter 637274 637274 Howlett, Edmund, of Kennynghall, carpenter 2
4243627 2110854 2110854 defendant Mullyns Ralph yeoman 637274 637274 Mullyns, Ralph, of Kennynghall, yeoman 1
4250870 2113270 2113270 defendant Mullye William yeoman 637274 637274 Mullye, William, of Kennynghall, yeoman 0
4275041 2121223 2121223 defendant Cooke Henry husbandman 637274 637274 Cooke, Henry, of Kennynghall, husbandman 1
4276783 2121813 2121813 defendant Blocke Roger butcher 637274 637274 Blocke, Roger, of Kennynghall, butcher 1
4333401 2141453 2141453 defendant Thompson Thomas yeoman 637274 637274 Thompson, Thomas, of Kennynghall, yeoman 0
4336455 2142485 2142485 defendant Eldred William butcher 637274 637274 Eldred, William, of Kennynghall, butcher 0
4355813 2149251 2149251 defendant Mulley William yeoman 637274 637274 Mulley, William, of Kennynghall, yeoman 2
4393721 2162502 2162502 defendant Dowsyng John glover 637274 637274 Dowsyng, John, of Kennynghall, glover 2
4399577 2164446 2164446 defendant Eldred William butcher 637274 637274 Eldred, William, of Kennynghall, butcher 3
4409864 2167902 2167902 defendant Wyld John clerk 637274 637274 Wyld, John, of Kennynghall, clerk 2
4410752 2168186 2168186 defendant Mortymer William   637274 637274 Mortymer, William, of Kennynghall, mason 2
4411240 2168345 2168345 defendant Wyllyson   widow 637274 637274 Wyllyson, , of Kennynghall, widow 3

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