names

18 rows where place_id = 591406

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604301 1869009 1869009 defendant Dade Henry chaplain 591406 591406 Dade, Henry, of Corff Castell, chaplain 0
3604302 1869009 1869009 defendant Jely Richard chaplain 591406 591406 Jely, Richard, of Corff Castell, chaplain 1
3923541 1998182 1998182 defendant Symons Thomas tailor 591406 591406 Symons, Thomas, of Corff Castell, tailor 1
3947557 2006214 2006214 defendant Morrys Thomas laborer 591406 591406 Morrys, Thomas, of Corff Castell, laborer 6
3947567 2006215 2006215 defendant Carter Hugh laborer 591406 591406 Carter, Hugh, of Corff Castell, laborer 8
3947568 2006215 2006215 defendant Joyner Anthony laborer 591406 591406 Joyner, Anthony, of Corff Castell, laborer 9
3947569 2006215 2006215 defendant Sedman Thomas husbandman 591406 591406 Sedman, Thomas, of Corff Castell, husbandman 10
3947570 2006215 2006215 defendant Rockeby Willliam laborer 591406 591406 Rockeby, Willliam, of Corff Castell, laborer 11
3947572 2006216 2006216 defendant Haywarde Thomas yeoman 591406 591406 Haywarde, Thomas, of Corff Castell, yeoman 0
3947573 2006216 2006216 defendant Flemmynge Miles yeoman 591406 591406 Flemmynge, Miles, of Corff Castell, yeoman 1
3947574 2006216 2006216 defendant Browne Gerrard yeoman 591406 591406 Browne, Gerrard, of Corff Castell, yeoman 2
3951823 2007699 2007699 defendant Bonvyle Thomas yeoman 591406 591406 Bonvyle, Thomas, of Corff Castell, yeoman 0
3951824 2007699 2007699 defendant Hardyng John husbandman 591406 591406 Hardyng, John, of Corff Castell, husbandman 1
3951825 2007699 2007699 defendant Sewell Brian husbandman 591406 591406 Sewell, Brian, of Corff Castell, husbandman 2
4040497 2039094 2039094 plaintiff Miller John yeoman 591406 591406 Miller, John, of Corff Castell, yeoman 0
4041202 2039342 2039342 plaintiff Myller John yeoman 591406 591406 Myller, John, of Corff Castell, yeoman 0
4334677 2141867 2141867 defendant Pheppard Richard yeoman 591406 591406 Pheppard, Richard, of Corff Castell, or of Alewood, yeoman 2
5455406 2491531 2491531 plaintiff Bonvyle William marbler 591406 591406 Bonvyle, William, of Corff Castell, marbler 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);