names

22 rows where place_id = 623786

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3754379 1943327 1943327 defendant Lorkyn William yeoman 623786 623786 Lorkyn, William, of Lymmynge, yeoman 2
3849761 1973512 1973512 defendant Clerke Henry chaplain 623786 623786 Clerke, Henry, of Lymmynge, chaplain 2
3849762 1973512 1973512 defendant Rables Nicholas husbandman 623786 623786 Rables, Nicholas, of Lymmynge, husbandman 3
3849764 1973512 1973512 defendant Norton John butcher 623786 623786 (Norton, John, of Lymmynge, butcher 5
4470132 2191312 2191312 defendant Courthope John   623786 623786 Courthope, John, of Lymmynge 0
4527906 2209007 2209007 plaintiff Luns John   623786 623786 Luns, John, of Lymmynge 0
4607656 2233504 2233504 defendant Jankyn Henry   623786 623786 Jankyn, Henry, of Lymmynge 0
4671050 2256614 2256614 defendant Gardyner Henry yeoman 623786 623786 Gardyner, Henry, of Lymmynge, yeoman 0
4680386 2259480 2259480 defendant Gardyner Henry yeoman 623786 623786 Gardyner, Henry, of Lymmynge, yeoman 0
4681522 2259833 2259833 defendant Bysle Simon husbandman 623786 623786 Bysle, Simon, of Lymmynge, husbandman 0
4684450 2260740 2260740 defendant Wodhell William gent 623786 623786 Wodhell, William, of Lymmynge, gent 2
4685775 2261140 2261140 defendant Horn Thomas laborer 623786 623786 Horn, Thomas, of Lymmynge, laborer 1
4707300 2267660 2267660 defendant Bysle Simon husbandman 623786 623786 Bysle, Simon, of Lymmynge, husbandman 0
4747354 2279729 2279729 defendant bysele Simon yeoman 623786 623786 bysele, Simon, of Lymmynge, yeoman 1
4790101 2292980 2292980 defendant Bysle Simon yeoman 623786 623786 Bysle, Simon, of Lymmynge, yeoman 0
4810557 2299448 2299448 defendant Wreghy John laborer 623786 623786 Wreghy, John, of Lymmynge, laborer 0
4930308 2335879 2335879 plaintiff Thurgor John   623786 623786 Thurgor, John, of Lymmynge 0
4954116 2343198 2343198 defendant Bollard Simon laborer 623786 623786 Bollard, Simon, of Lymmynge, laborer 0
5180422 2410016 2410016 defendant William Thomas husbandman 623786 623786 William, Thomas, of Lymmynge, husbandman 0
5180423 2410016 2410016 defendant Clerk Nicholas husbandman 623786 623786 Clerk, Nicholas, of Lymmynge, husbandman 1
5560775 2523120 2523120 defendant Spycer Thomas husbandman 623786 623786 Spycer, Thomas, of Lymmynge, husbandman 0
5604270 2536198 2536198 defendant Spycer John yeoman 623786 623786 Spycer, John, of Lymmynge, yeoman, son of Spycer, Thomas, of Lymmynge, yeoman 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);