names

13 rows where place_id = 669077

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3991729 2021799 2021799 defendant Jones Thomas clerk 669077 669077 Jones, Thomas, of Maunsell Gamage, clerk 2
3992831 2022189 2022189 defendant Bythell John husbandman 669077 669077 Bythell, John, of Maunsell Gamage, husbandman 0
4032386 2036245 2036245 defendant Davye Thomas husbandman 669077 669077 Davye, Thomas, of Maunsell Gamage, husbandman 15
4093966 2058168 2058168 defendant Eccley William yeoman 669077 669077 Eccley, William, of Maunsell gamage, yeoman 0
4153353 2079271 2079271 defendant Jones Thomas clerk 669077 669077 Jones, Thomas, of Maunsell Gamage, clerk 0
4153772 2079419 2079419 defendant Jones Thomas clerk 669077 669077 Jones, Thomas, of Maunsell Gamage, clerk 0
4190317 2092126 2092126 defendant Pembrydge James gent 669077 669077 Pembrydge, James, of Maunsell Gamage, gent 0
4240639 2109851 2109851 defendant Chabnor Thomas husbandman 669077 669077 Chabnor, Thomas, of Maunsell Gamage, or of Bushopston, husbandman 1
4243283 2110744 2110744 defendant Pennor Thomas yeoman 669077 669077 Pennor, Thomas, of Maunsell Gamage, yeoman 3
4387723 2160530 2160530 defendant Pennor Thomas husbandman 669077 669077 Pennor, Thomas, of Maunsell Gamage, husbandman 2
4387728 2160531 2160531 defendant Pemor Thomas husbandman 669077 669077 Pemor, Thomas, of Maunsell Gamage, husbandman 2
5137067 2397357 2397357 defendant Lewellen William husbandman 669077 669077 Lewellen, William, of Maunsell Gamage, husbandman 0
5137068 2397357 2397357 defendant Unde or Vude Roger husbandman 669077 669077 Unde or Vude, Roger, of Maunsell Gamage, husbandman 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);