names

33 rows where place_id = 614313

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3703044 1927226 1927226 defendant Waynwryght John husbandman 614313 614313 Waynwryght, John, of Brereley, husbandman 0
3712776 1930313 1930313 defendant Eyre Philip gent 614313 614313 Eyre, Philip, of Brereley, gent 0
3732918 1936518 1936518 defendant Robyns Thomas slater 614313 614313 Robyns, Thomas, of Brereley, slater 3
3735185 1937238 1937238 defendant Parker Edward yeoman 614313 614313 Parker, Edward, of Brereley, yeoman 0
3760697 1945346 1945346 defendant Elyott John yeoman 614313 614313 Elyott, John, of Brereley, yeoman 0
3890781 1987183 1987183 defendant Colthyrst Thomas gent 614313 614313 Colthyrst, Thomas, of Brereley, gent 0
3925459 1998826 1998826 defendant Jenett Bernard husbandman 614313 614313 Jenett, Bernard, of Brereley, husbandman 0
3985129 2019433 2019433 defendant Sysson Thomas yeoman 614313 614313 Sysson, Thomas, of Brereley, yeoman 0
4040008 2038930 2038930 defendant de la Hey Ralph   614313 614313 de la Hey, Ralph, of Brereley, yeoman, administrators of 0
4074769 2051276 2051276 defendant Holeley Richard yeoman 614313 614313 Holeley, Richard, of Brereley, yeoman 0
4268684 2119116 2119116 defendant Lacye John esq 614313 614313 Lacye, John, of Brereley, esq 0
4284403 2124470 2124470 defendant Gybbons Richard yeoman 614313 614313 Gybbons, Richard, of Brereley, yeoman 0
4316628 2135935 2135935 defendant Hardwicke Nicholas yeoman 614313 614313 Hardwicke, Nicholas, of Brereley, yeoman 1
4343940 2145159 2145159 defendant Jevon Richard blacksmith 614313 614313 Jevon, Richard, of Brereley, blacksmith 0
4414382 2169408 2169408 plaintiff del Wode John   614313 614313 del Wode, John, of Brereley 0
4414385 2169409 2169409 plaintiff del Wode Julia   614313 614313 del Wode, Julia, of Brereley, formerly wife of Adam 0
4414387 2169410 2169410 plaintiff del Wode Julia   614313 614313 del Wode, Julia, of Brereley, formerly wife of Adam 0
4573642 2223269 2223269 defendant Nodder John   614313 614313 Nodder, John, of Brereley 1
4621746 2237781 2237781 defendant Best Robert   614313 614313 Best, Robert, of Brereley 1
4621750 2237782 2237782 defendant Best Robert   614313 614313 Best, Robert, of Brereley 1
4649437 2245886 2245886 defendant Vennemore Richard   614313 614313 Vennemore, Richard, of Brereley 0
4687909 2261783 2261783 defendant Turnepeny William laborer 614313 614313 Turnepeny, William, of Brereley, laborer 0
4689159 2262169 2262169 defendant Turnepeny Willia laborer 614313 614313 Turnepeny, Willia, of Brereley, laborer 0
4750468 2280620 2280620 defendant Huntyngdon William milner 614313 614313 Huntyngdon, William, of Brereley, milner 1
4965530 2346609 2346609 defendant Baldewyn Richard husbandman 614313 614313 Baldewyn, Richard, of Brereley, husbandman 2
5363137 2464124 2464124 defendant Haryngton James   614313 614313 Haryngton, James, of Brereley, knight 0
5472214 2496656 2496656 defendant Pytte John yeoman 614313 614313 Pytte, John, of Brereley, yeoman 0
5479425 2498861 2498861 defendant Botfysshe Richard yeoman 614313 614313 Botfysshe, Richard, of Brereley, yeoman 2
5487358 2501113 2501113 defendant Brigge Henry yeoman 614313 614313 Brigge, Henry, of Brereley, yeoman 12
5487359 2501113 2501113 defendant Cuppill William yeoman 614313 614313 Cuppill, William, of Brereley, yeoman 13
5489044 2501598 2501598 defendant Brygge Henry yeoman 614313 614313 Brygge, Henry, of Brereley, yeoman 1
5534742 2515407 2515407 defendant Brig Henry husbandman 614313 614313 Brig, Henry, of Brereley, husbandman 0
5602070 2535543 2535543 defendant Eyre Philip gent 614313 614313 Eyre, Philip, of Brereley, gent 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);