names

22 rows where place_id = 724777

✎ 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
3695970 1924979 1924979 defendant Chese Thomas   724777 724777 Chese, Thomas, of Cosgrave, mason 1
4257713 2115553 2115553 defendant Watson Robert husbandman 724777 724777 Watson, Robert, of Cosgrave, husbandman 2
4310182 2133717 2133717 defendant Earle John laborer 724777 724777 Earle, John, of Cosgrave, laborer 1
4316595 2135923 2135923 defendant Watson Robert husbandman 724777 724777 Watson, Robert, of Cosgrave, husbandman 0
4318441 2136559 2136559 defendant Emerston William yeoman 724777 724777 Emerston, William, of Cosgrave, yeoman 0
4318442 2136559 2136559 defendant Archer Robert yeoman 724777 724777 Archer, Robert, of Cosgrave, yeoman 1
4328714 2139914 2139914 defendant Emerson William husbandman 724777 724777 Emerson, William, of Cosgrave, husbandman 0
4329716 2140235 2140235 defendant Emerson William yeoman 724777 724777 Emerson, William, of Cosgrave, yeoman 0
4331219 2140738 2140738 defendant Beacham John yeoman 724777 724777 Beacham, John, of Cosgrave, yeoman 0
4331220 2140738 2140738 defendant Emerson William yeoman 724777 724777 Emerson, William, of Cosgrave, yeoman 1
4331223 2140739 2140739 defendant Emerson William yeoman 724777 724777 Emerson, William, of Cosgrave, yeoman 1
4331382 2140795 2140795 defendant Watson Robert husbandman 724777 724777 Watson, Robert, of Cosgrave, husbandman 0
4331383 2140795 2140795 defendant Burton Richard husbandman 724777 724777 Burton, Richard, of Cosgrave, husbandman 1
4334595 2141841 2141841 defendant Borton or Burton Richard husbandman 724777 724777 Borton or Burton, Richard, of Cosgrave, husbandman 0
4337807 2142974 2142974 defendant Beacham Thomas yeoman 724777 724777 Beacham, Thomas, of Cosgrave, yeoman 0
4349880 2147219 2147219 defendant Ludgate Babriel laborer 724777 724777 Ludgate, Babriel, of Cosgrave, laborer 0
4349882 2147220 2147220 defendant Edon Robert tailor 724777 724777 Edon, Robert, of Cosgrave, tailor 0
4355193 2149038 2149038 defendant Walbancke or Wallebancke John yeoman 724777 724777 Walbancke or Wallebancke, John, of Cosgrave, yeoman 0
4514292 2204886 2204886 defendant Barnevyle John   724777 724777 Barnevyle, John, of Cosgrave 0
4552510 2216741 2216741 plaintiff fitz John John   724777 724777 fitz John, John, of Cosgrave 0
4871449 2318034 2318034 defendant Ingrith Thomas   724777 724777 (Ingrith, Thomas, of Cosgrave 1
4924696 2334160 2334160 defendant Kyrkham William husbandman 724777 724777 Kyrkham, William, of Cosgrave, 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);