names

52 rows where place_id = 647956

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3899122 1989915 1989915 defendant Vaughan John gent 647956 647956 Vaughan, John, of Wynforton, gent 0
3899123 1989915 1989915 defendant ap Hoell Walter gent 647956 647956 ap Hoell, Walter, of Wynforton, gent 1
3913248 1994761 1994761 defendant Glover John husbandman 647956 647956 Glover, John, of Wynforton, husbandman 1
3913249 1994761 1994761 defendant Rowler Walter husbandman 647956 647956 Rowler, Walter, of Wynforton, husbandman 2
3913250 1994761 1994761 defendant West John husbandman 647956 647956 West, John, of Wynforton, husbandman 3
3931819 2000945 2000945 defendant Hawlle Thomas tailor 647956 647956 Hawlle, Thomas, of Wynforton, tailor 0
3945319 2005444 2005444 defendant Bolter David husbandman 647956 647956 Bolter, David, of Wynforton, husbandman 0
3945320 2005444 2005444 defendant Bolter Estance laborer 647956 647956 Bolter, Estance, of Wynforton, laborer 1
3950597 2007279 2007279 defendant Hyggyns Jenkin gent 647956 647956 Hyggyns, Jenkin, of Wynforton, gent 1
3969409 2013904 2013904 defendant ap Rees John husbandman 647956 647956 ap Rees, John, of Wynforton, husbandman 0
3987449 2020258 2020258 defendant Pryse John yeoman 647956 647956 Pryse, John, of Wynforton, yeoman 0
4001651 2025370 2025370 defendant Baker Thomas yeoman 647956 647956 Baker, Thomas, of Wynforton, yeoman 0
4024842 2033567 2033567 defendant Baker Thomas husbandman 647956 647956 Baker, Thomas, of Wynforton, husbandman 0
4024843 2033567 2033567 defendant Apowell John ap David tailor 647956 647956 Apowell, John ap David, of Wynforton, tailor 1
4024844 2033567 2033567 defendant Apowell Robert ap David tailor 647956 647956 Apowell, Robert ap David, of Wynforton, tailor 2
4024845 2033567 2033567 defendant Apowell Ellen David widow 647956 647956 Apowell, Ellen David, of Wynforton, widow 3
4066924 2048467 2048467 defendant Vaughan William gent 647956 647956 Vaughan, William, of Wynforton, gent 3
4067337 2048620 2048620 defendant Davys Robert tailor 647956 647956 Davys, Robert, of Wynforton, tailor 2
4166920 2083927 2083927 defendant ap Rychard Walter yeoman 647956 647956 ap Rychard, Walter, of Wynforton, yeoman 3
4214518 2100586 2100586 defendant James Charles gent 647956 647956 James, Charles, of Wynforton, gent 1
4214519 2100586 2100586 defendant Bolter Eustace yeoman 647956 647956 Bolter, Eustace, of Wynforton, yeoman 2
4215130 2100791 2100791 defendant Edmond alias Weaver Robert yeoman 647956 647956 Edmond alias Weaver, Robert, of Wynforton, yeoman 1
4232503 2106872 2106872 defendant Williams alias Wever Roger yeoman 647956 647956 Williams alias Wever, Roger, of Wynforton, yeoman 3
4238154 2108956 2108956 defendant Baker John, junior   647956 647956 Baker, John, junior, of Wynforton, yeoman, his son 1
4243545 2110829 2110829 defendant Vaughan Eustace gent 647956 647956 Vaughan, Eustace, of Wynforton, gent 0
4247982 2112313 2112313 defendant Goundy Richard yeoman 647956 647956 Goundy, Richard, of Wynforton, yeoman 0
4247983 2112313 2112313 defendant Griffith alias Merebache William yeoman 647956 647956 Griffith alias Merebache, William, of Wynforton, yeoman 1
4247984 2112313 2112313 defendant Williams John yeoman 647956 647956 Williams, John, of Wynforton, yeoman 2
4247985 2112313 2112313 defendant ap David Edward yeoman 647956 647956 ap David, Edward, of Wynforton, yeoman 3
4247996 2112316 2112316 defendant Vaughan Walter John gent 647956 647956 Vaughan, Walter John, of Wynforton, gent 0
4247997 2112316 2112316 defendant Vaughan John gent 647956 647956 Vaughan, John, of Wynforton, gent 1
4247998 2112316 2112316 defendant Chambers Thomas yeoman 647956 647956 Chambers, Thomas, of Wynforton, yeoman 2
4247999 2112316 2112316 defendant Lawrence Edward yeoman 647956 647956 Lawrence, Edward, of Wynforton, yeoman 3
4248001 2112317 2112317 defendant West Thomas yeoman 647956 647956 West, Thomas, of Wynforton, yeoman 0
4248002 2112317 2112317 defendant Chambers Thomas yeoman 647956 647956 Chambers, Thomas, of Wynforton, yeoman 1
4248004 2112317 2112317 defendant ap Rees Walter yeoman 647956 647956 ap Rees, Walter, of Wynforton, yeoman 3
4248006 2112318 2112318 defendant Williams alias Butler Roger yeoman 647956 647956 Williams alias Butler, Roger, of Wynforton, yeoman 0
4248007 2112318 2112318 defendant Goundy Richard yeoman 647956 647956 Goundy, Richard, of Wynforton, yeoman 1
4248008 2112318 2112318 defendant ap Rees Walter yeoman 647956 647956 ap Rees, Walter, of Wynforton, yeoman 2
4292551 2127397 2127397 defendant Hopton Thomas gent 647956 647956 Hopton, Thomas, of Wynforton, gent 1
4301288 2130569 2130569 defendant Hopton Thomas gent 647956 647956 Hopton, Thomas, of Wynforton, gent 1
4302005 2130827 2130827 defendant Hopton Thomas gent 647956 647956 Hopton, Thomas, of Wynforton, gent 1
4311945 2134313 2134313 defendant Baker John   647956 647956 Baker, John, of Wynforton, yeoman, his son 1
4311946 2134313 2134313 defendant Bolter Humphrey yeoman 647956 647956 Bolter, Humphrey, of Wynforton, yeoman 2
4314958 2135344 2135344 defendant Aprice Griffin shoemaker 647956 647956 Aprice, Griffin, of Wynforton, shoemaker 0
4383112 2159068 2159068 defendant Vaughan Walter John yeoman 647956 647956 Vaughan, Walter John, of Wynforton, yeoman 1
4405088 2166278 2166278 defendant Vaughan Watkin John yeoman 647956 647956 Vaughan, Watkin John, of Wynforton, yeoman 0
4405089 2166278 2166278 defendant Chambers Thomas yeoman 647956 647956 Chambers, Thomas, of Wynforton, yeoman 1
4405090 2166278 2166278 defendant Williams Roger yeoman 647956 647956 Williams, Roger, of Wynforton, yeoman 2
5505369 2506593 2506593 plaintiff ap John Thomas yeoman of the crown 647956 647956 ap John, Thomas, of Wynforton, yeoman of the crown 1
5592997 2532800 2532800 defendant Saunders Thomas husbandman 647956 647956 Saunders, Thomas, of Wynforton, husbandman 3
5593008 2532803 2532803 defendant Saunders Thomas husbandman 647956 647956 Saunders, Thomas, of Wynforton, husbandman 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);