names

47 rows where place_id = 609030

✎ 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
3676631 1918728 1918728 defendant Pregell Thomas husbandman 609030 609030 Pregell, Thomas, of Wolhope, husbandman 0
3676632 1918728 1918728 defendant Pregell William laborer 609030 609030 Pregell, William, of Wolhope, laborer 1
3717707 1931835 1931835 defendant Hardyberd Henry husbandman 609030 609030 Hardyberd, Henry, of Wolhope, husbandman 0
3938637 2003264 2003264 defendant Pryor John gent 609030 609030 Pryor, John, of Wolhope, gent 1
3990776 2021458 2021458 defendant Turnor Thomas yeoman 609030 609030 Turnor, Thomas, of Wolhope, yeoman 0
3990778 2021459 2021459 defendant Turnor Thomas yeoman 609030 609030 Turnor, Thomas, of Wolhope, yeoman 0
4012121 2029062 2029062 defendant Tornor James yeoman 609030 609030 Tornor, James, of Wolhope, yeoman 0
4012122 2029063 2029063 plaintiff Pryor William gent 609030 609030 Pryor, William, of Wolhope, gent 0
4012123 2029063 2029063 defendant Wheler Thomas   609030 609030 Wheler, Thomas, of Wolhope, husbandman, son of John Wheler 0
4017805 2031080 2031080 defendant Hyll John husbandman 609030 609030 Hyll, John, of Wolhope, husbandman 0
4026718 2034200 2034200 defendant Tornor Walter yeoman 609030 609030 Tornor, Walter, of Wolhope, yeoman 0
4026719 2034200 2034200 defendant Tornor James yeoman 609030 609030 Tornor, James, of Wolhope, yeoman 1
4035112 2037235 2037235 defendant Gillam John husbandman 609030 609030 Gillam, John, of Wolhope, husbandman 3
4035114 2037236 2037236 defendant Woodward Richard husbandman 609030 609030 Woodward, Richard, of Wolhope, husbandman 0
4036635 2037785 2037785 defendant Turnor James husbandman 609030 609030 Turnor, James, of Wolhope, husbandman 0
4036636 2037785 2037785 defendant Turnor Anthony husbandman 609030 609030 Turnor, Anthony, of Wolhope, husbandman 1
4036637 2037785 2037785 defendant Robert John husbandman 609030 609030 Robert, John, of Wolhope, husbandman 2
4036638 2037785 2037785 defendant Berowe Miles husbandman 609030 609030 Berowe, Miles, of Wolhope, husbandman 3
4037038 2037912 2037912 defendant Taylor Edmund husbandman 609030 609030 Taylor, Edmund, of Wolhope, husbandman 0
4040195 2038995 2038995 defendant Tornor James yeoman 609030 609030 Tornor, James, of Wolhope, yeoman 0
4045169 2040725 2040725 defendant Ravenhill James yeoman 609030 609030 Ravenhill, James, of Wolhope, yeoman 0
4061090 2046373 2046373 defendant Jones Thomas gent 609030 609030 Jones, Thomas, of Wolhope, gent 0
4061291 2046442 2046442 defendant Love or Lone John yeoman 609030 609030 Love or Lone, John, of Wolhope, yeoman 6
4065910 2048097 2048097 defendant Jones Thomas gent 609030 609030 Jones, Thomas, of Wolhope, gent 0
4081221 2053592 2053592 plaintiff Wheler Thomas yeoman 609030 609030 Wheler, Thomas, of Wolhope, yeoman 0
4137274 2073679 2073679 defendant Alforde John husbandman 609030 609030 Alforde, John, of Wolhope, husbandman 2
4137278 2073680 2073680 defendant Alforde John husbandman 609030 609030 Alforde, John, of Wolhope, husbandman 2
4142030 2075385 2075385 defendant Winter Richard husbandman 609030 609030 Winter, Richard, of Wolhope, husbandman 3
4145441 2076564 2076564 defendant Jones Thomas gent 609030 609030 Jones, Thomas, of Wolhope, gent 0
4220637 2102717 2102717 defendant Ravenyll Leonard, senior yeoman 609030 609030 Ravenyll, Leonard, senior, of Wolhope, yeoman 0
4250400 2113116 2113116 defendant Shere Richard yeoman 609030 609030 Shere, Richard, of Wolhope, yeoman 0
4297461 2129194 2129194 defendant Wynslowe William tailor 609030 609030 Wynslowe, William, of Wolhope, tailor 3
4311922 2134306 2134306 defendant Jauncey John yeoman 609030 609030 Jauncey, John, of Wolhope, yeoman 0
4311923 2134306 2134306 defendant Talgate Richard yeoman 609030 609030 Talgate, Richard, of Wolhope, yeoman 1
4330393 2140464 2140464 defendant Wynslowe William tailor 609030 609030 Wynslowe, William, of Wolhope, tailor 3
4398783 2164175 2164175 defendant Sarnell Hugh yeoman 609030 609030 Sarnell, Hugh, of Wolhope, yeoman 0
4398784 2164175 2164175 defendant Whiller Elizabeth yeoman 609030 609030 Whiller, Elizabeth, of Wolhope, yeoman 1
4398785 2164175 2164175 defendant Whiller Mary spinster 609030 609030 Whiller, Mary, of Wolhope, spinster 2
4404668 2166130 2166130 defendant Ravenhill William, senior yeoman 609030 609030 Ravenhill, William, senior, of Wolhope, yeoman 0
4404671 2166131 2166131 defendant Ravenhill William, senior   609030 609030 Ravenhill, William, senior, of Wolhope yeoman 0
4404672 2166131 2166131 defendant Ravenhill William, junior   609030 609030 Ravenhill, William, junior, of Wolhope yeoman 1
4404673 2166131 2166131 defendant Prichard John   609030 609030 Prichard, John, of Wolhope yeoman 2
4404674 2166131 2166131 defendant Tyler William   609030 609030 Tyler, William, of Wolhope yeoman 3
4404675 2166131 2166131 defendant Wynter Alice spinster 609030 609030 Wynter, Alice, of Wolhope, spinster 4
5020918 2363013 2363013 defendant Uphavene John husbandman 609030 609030 Uphavene, John, of Wolhope, husbandman 1
5219511 2421434 2421434 defendant Wheler William husbandman 609030 609030 Wheler, William, of Wolhope, husbandman 0
5222489 2422291 2422291 defendant Churche John husbandman 609030 609030 Churche, John, of Wolhope, husbandman 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);