names

30 rows where place_id = 644458

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3878281 1982983 1982983 defendant Smyth John (legal representative) 644458 644458 Smyth, John, of Walpoole, executors of 0
3879763 1983489 1983489 defendant West Thomas husbandman 644458 644458 West, Thomas, of Walpoole, husbandman 1
4037784 2038166 2038166 plaintiff Knyght John yeoman 644458 644458 Knyght, John, of Walpoole, yeoman 0
4047213 2041452 2041452 defendant Calverley William yeoman 644458 644458 Calverley, William, of Walpoole, yeoman 1
4054775 2044096 2044096 defendant Hunston Henry gent 644458 644458 Hunston, Henry, of Walpoole, gent 0
4061801 2046618 2046618 defendant Watson John husbandman 644458 644458 Watson, John, of Walpoole, husbandman 1
4061806 2046619 2046619 defendant Blomefylde Stephen husbandman 644458 644458 Blomefylde, Stephen, of Walpoole, husbandman 3
4066964 2048481 2048481 defendant Prynce William husbandman 644458 644458 Prynce, William, of Walpoole, husbandman 2
4074765 2051274 2051274 defendant Bonnynge Robert yeoman 644458 644458 Bonnynge, Robert, of Walpoole, yeoman 0
4094500 2058371 2058371 defendant Awstyn Walter yeoman 644458 644458 Awstyn, Walter, of Walpoole, yeoman 3
4094505 2058372 2058372 defendant Awstyn Walter yeoman 644458 644458 Awstyn, Walter, of Walpoole, yeoman 3
4099208 2060043 2060043 defendant Hunston Henry gent 644458 644458 Hunston, Henry, of Walpoole, gent 1
4145020 2076418 2076418 defendant Care John glasier 644458 644458 Care, John, of Walpoole, glasier 1
4158723 2081124 2081124 defendant Hallywell Alexander husbandman 644458 644458 Hallywell, Alexander, of Walpoole, husbandman 0
4169365 2084790 2084790 defendant Skott John husbandman 644458 644458 Skott, John, of Walpoole, husbandman 0
4173895 2086325 2086325 defendant Gylden William husbandman 644458 644458 Gylden, William, of Walpoole, husbandman 2
4178583 2087988 2087988 defendant Godfrey Alice widow 644458 644458 Godfrey, Alice, of Walpoole, widow 0
4197200 2094571 2094571 defendant Neale Robert   644458 644458 Neale, Robert, of Walpoole, husbandman, executrix if 1
4197201 2094571 2094571 defendant Neale Margaret widow 644458 644458 Neale, Margaret, of Walpoole, widow 2
4207481 2098171 2098171 defendant Hallywell Alexander yeoman 644458 644458 Hallywell, Alexander, of Walpoole, yeoman 0
4252819 2113932 2113932 defendant Skottyn John (legal representative) 644458 644458 Skottyn, John, of Walpoole, husbandman, executors of 0
4254808 2114601 2114601 defendant Fretwell George husbandman 644458 644458 Fretwell, George, of Walpoole, husbandman 1
4276752 2121803 2121803 defendant Farthinge Robert yeoman 644458 644458 Farthinge, Robert, of Walpoole, yeoman 0
4277253 2121975 2121975 defendant Warde John yeoman 644458 644458 Warde, John, of Walpoole St Pater, yeoman 0
4283516 2124140 2124140 defendant Hart William gent 644458 644458 Hart, William, of Walpoole, gent 0
4283535 2124148 2124148 defendant Hart William gent 644458 644458 Hart, William, of Walpoole, gent 0
4328175 2139738 2139738 defendant Jones Edward gent 644458 644458 Jones, Edward, of Walpoole, gent 1
4341314 2144236 2144236 defendant Farthyng Robert husbandman 644458 644458 Farthyng, Robert, of Walpoole, husbandman 0
4357520 2149862 2149862 defendant Fretwell George yeoman 644458 644458 Fretwell, George, of Walpoole, yeoman 0
4381905 2158632 2158632 defendant Harte William yeoman 644458 644458 Harte, William, of Walpoole, yeoman 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);