names

27 rows where place_id = 608149

✎ 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
3672391 1917368 1917368 defendant Hersshe Thomas husbandman 608149 608149 Hersshe, Thomas, of Coppedok, husbandman 0
3751178 1942295 1942295 defendant Pellys Thomas carpenter 608149 608149 Pellys, Thomas, of Coppedok, carpenter 0
3751179 1942295 1942295 defendant Pellys John carpenter 608149 608149 Pellys, John, of Coppedok, carpenter 1
4452160 2185660 2185660 defendant Lacy John   608149 608149 Lacy, John, of Coppedok 3
4563444 2220138 2220138 defendant Mayhewe John   608149 608149 Mayhewe, John, of Coppedok 2
4577272 2224411 2224411 defendant Blosse John   608149 608149 Blosse, John, of Coppedok 0
4580462 2225375 2225375 defendant Blosse John   608149 608149 Blosse, John, of Coppedok 1
4610193 2234270 2234270 defendant Blosse John (legal representative) 608149 608149 Blosse, John, of Coppedok, executrix of 0
4610194 2234270 2234270 defendant Blosse Katherine   608149 608149 Blosse, Katherine, of Coppedok, formerly wife of John 1
4614586 2235569 2235569 defendant Warde John   608149 608149 Warde, John, of Coppedok 0
4676532 2258275 2258275 defendant Strount William yeoman 608149 608149 Strount, William, of Coppedok, yeoman 1
4770077 2286612 2286612 plaintiff Predys Thomas   608149 608149 Predys, Thomas, of Coppedok 0
4795469 2294734 2294734 defendant Blosse John husbandman 608149 608149 Blosse, John, of Coppedok, husbandman 2
4835809 2307192 2307192 defendant Mate Wm yeoman 608149 608149 Mate, Wm, of Coppedok, yeoman 10
4835811 2307192 2307192 defendant Predis Thomas husbandman 608149 608149 Predis, Thomas, of Coppedok, husbandman 12
4966220 2346830 2346830 defendant Merveyn John yeoman 608149 608149 Merveyn, John, of Coppedok, yeoman 0
5082440 2381246 2381246 plaintiff Dogeth Richard   608149 608149 Dogeth, Richard, of Coppedok 0
5154931 2402600 2402600 defendant Tastard Richard husbandman 608149 608149 Tastard, Richard, of Coppedok, husbandman 1
5178738 2409500 2409500 defendant Tastard Richard husbandman 608149 608149 Tastard, Richard, of Coppedok, husbandman 3
5198547 2415331 2415331 defendant Tastard Richard yeoman 608149 608149 Tastard, Richard, of Coppedok, yeoman 0
5198548 2415331 2415331 defendant Tastard William   608149 608149 Tastard, William, of Coppedok, yeoman, son & heir of Richard 1
5210599 2418839 2418839 defendant Tastard Richard yeoman 608149 608149 Tastard, Richard, of Coppedok, yeoman 0
5210600 2418839 2418839 defendant Tastard William   608149 608149 Tastard, William, of Coppedok, yeoman, son & heir of Richard Tastard 1
5280274 2439306 2439306 defendant Blosse Thomas husbandman 608149 608149 Blosse, Thomas, of Coppedok, husbandman 1
5309728 2447946 2447946 defendant Tastard William husbandman 608149 608149 Tastard, William, of Coppedok, husbandman 0
5376742 2468323 2468323 defendant Bonpas John clerk 608149 608149 Bonpas, John, of Coppedok, clerk 0
5487411 2501130 2501130 defendant Tastard William husbandman 608149 608149 Tastard, William, of Coppedok, 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);