names

17 rows where place_id = 657343

✎ 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
3943951 2004995 2004995 plaintiff Badam John William yeoman 657343 657343 Badam, John William, of Llangattock vibon Avell, yeoman 0
3960912 2010914 2010914 defendant Badam John William yeoman 657343 657343 Badam, John William, of Llangattock Vibon Avell, yeoman 0
3960913 2010914 2010914 defendant Phillipp William yeoman 657343 657343 Phillipp, William, of Llangattock Vibon Avell, yeoman 1
3962181 2011355 2011355 defendant ap Robert Jenetta widow 657343 657343 Jenetta his wife, formerly Jenetta vergh Philpott, of Llangattock Vibon Avell, widow 1
4099965 2060313 2060313 defendant James John yeoman 657343 657343 James, John, of Llangattock Vibon Avell, yeoman 0
4223115 2103574 2103574 defendant Philip Jenkin William yeoman 657343 657343 Philip, Jenkin William, of Llangattock Vibon Avell, yeoman 0
4223116 2103574 2103574 defendant Philip Walter William tailor 657343 657343 Philip, Walter William, of Llangattock Vibon Avell, tailor 1
4223117 2103574 2103574 defendant Philip Robert William weaver 657343 657343 Philip, Robert William, of Llangattock Vibon Avell, weaver 2
4278960 2122574 2122574 defendant Hew William yeoman 657343 657343 Hew,William, of Llangattock Vibon Avell, yeoman 2
4282517 2123788 2123788 defendant Philip Robert William weaver 657343 657343 Philip, Robert William, of Llangattock Vibon Avell, ,weaver 1
4366648 2153119 2153119 defendant Jenkyn Philip William yeoman 657343 657343 Jenkyn, Philip William, of Llangattock Vibon Avell, yeoman 0
4369915 2154293 2154293 defendant Phillippe Thomas William yeoman 657343 657343 Phillippe, Thomas William, of Llangattock Vibon Avell, yeoman 0
4369916 2154293 2154293 defendant Vaughan Thomas William yeoman 657343 657343 Vaughan, Thomas William, of Llangattock Vibon Avell, yeoman 1
4369923 2154296 2154296 defendant Phillippe Thomas William yeoman 657343 657343 Phillippe, Thomas William, of Llangattock Vibon Avell, yeoman 0
4369924 2154296 2154296 defendant Vaughan Thomas William yeoman 657343 657343 Vaughan, Thomas William, of Llangattock Vibon Avell, yeoman 1
4380577 2158162 2158162 defendant ap Morgan Morgan husbandman 657343 657343 ap Morgan, Morgan, of Llangattock Vibon Avell, husbandman 0
4380578 2158162 2158162 defendant Lewes James yeoman 657343 657343 Lewes, James, of Llangattock Vibon Avell, yeoman 1

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);