names

29 rows where place_id = 615732

✎ 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
3710424 1929579 1929579 defendant Shenkwyn Henry yeoman 615732 615732 Shenkwyn, Henry, of Weston, Norf, yeoman 0
3748450 1941449 1941449 plaintiff Wegge Thomas   615732 615732 Wegge, Thomas, of Weston, Norf 2
3765925 1947009 1947009 defendant Suliard Andrew esq 615732 615732 Suliard, Andrew, of Weston, Norf, esq 0
3835735 1969104 1969104 defendant Rookwod Firmun gent 615732 615732 Rookwod, Firmun, of Weston, Norf, gent 0
3871403 1980684 1980684 defendant Precle Thomas husbandman 615732 615732 Precle, Thomas, of Weston, Norf, husbandman 1
3945352 2005458 2005458 defendant Aylmer William gent 615732 615732 Aylmer, William, of Weston, Norf, gent 0
3968376 2013572 2013572 defendant Porte John butcher 615732 615732 Porte, John, of Weston, Norf, butcher 1
3970550 2014299 2014299 defendant Aylmer William gent 615732 615732 Aylmer, William, of Weston, Norf, gent 2
4029208 2035091 2035091 defendant Wymer Richard husbandman 615732 615732 Wymer, Richard, of Weston, Norf, husbandman 0
4039298 2038684 2038684 defendant Horseman George gent 615732 615732 Horseman, George, of Weston, Norf, gent 0
4077993 2052434 2052434 defendant Waynforthe John husbandman 615732 615732 Waynforthe, John, of Weston, Norf, husbandman 0
4143768 2075981 2075981 defendant Waynford John husbandman 615732 615732 Waynford, John, of Weston, Norf, husbandman 0
4204951 2097275 2097275 defendant Legatte John gent 615732 615732 Legatte, John, of Weston, Norf, gent 0
4204962 2097279 2097279 defendant Legatte John gent 615732 615732 Legatte, John, of Weston, Norf, gent 0
4385556 2159854 2159854 defendant Rookewoode Margaret widow 615732 615732 Rookewoode, Margaret, of Weston, Norf, widow 1
4674010 2257485 2257485 defendant Boteler Simon husbandman 615732 615732 Boteler, Simon, of Weston, Norf, husbandman 3
4758104 2282908 2282908 defendant Belstede Thomas husbandman 615732 615732 Belstede, Thomas, of Weston, Norf, husbandman 0
4802620 2297006 2297006 defendant Trewthe Richard yeoman 615732 615732 Trewthe, Richard, of Weston, Norf, yeoman 2
4804509 2297598 2297598 defendant Halle John de yeoman 615732 615732 Halle, John de, of Weston, Norf, yeoman 0
4925274 2334335 2334335 defendant Milcent William husbandman 615732 615732 Milcent, William, of Weston, Norf, husbandman 1
5440583 2487089 2487089 defendant Shode Geoffrey husbandman 615732 615732 Shode, Geoffrey, of Weston, Norf, husbandman 1
5453889 2491054 2491054 defendant Shode Geoffrey husbandman 615732 615732 Shode, Geoffrey, of Weston, Norf, husbandman 1
5465775 2494679 2494679 defendant Shode Geoffrey husbandman 615732 615732 Shode, Geoffrey, of Weston, Norf, husbandman 1
5503918 2506138 2506138 defendant Shode Geoffrey husbandman 615732 615732 Shode, Geoffrey, of Weston, Norf, husbandman 0
5503923 2506139 2506139 defendant Shode Geoffrey husbandman 615732 615732 Shode, Geoffrey, of Weston, Norf, husbandman 0
5539380 2516803 2516803 defendant Shenkwyn Henry yeoman 615732 615732 Shenkwyn, Henry, of Weston, Norf, yeoman 1
5565510 2524507 2524507 defendant Sulyard Andrew esq 615732 615732 Sulyard, Andrew, of Weston, Norf, esq 0
5565861 2524612 2524612 defendant Shenkwyn Henry yeoman 615732 615732 Shenkwyn, Henry, of Weston, Norf, yeoman 0
5606780 2537006 2537006 defendant Hervy John laborer 615732 615732 Hervy, John, of Weston, Norf, laborer 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);