names

25 rows where place_id = 655141

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3935096 2002046 2002046 defendant Godson John clothier 655141 655141 Godson, John, of Leedes, Yorks, clothier 0
3946011 2005682 2005682 defendant Jackson Robert yeoman 655141 655141 Jackson, Robert, of Leedes, Yorks, yeoman 0
3966862 2013043 2013043 defendant Cooke Thomas tanner 655141 655141 Cooke, Thomas, of Leedes, Yorks, tanner 0
3966871 2013045 2013045 defendant Wryght John tanner 655141 655141 Wryght, John, of Leedes, Yorks, tanner 2
3972609 2014996 2014996 defendant Gale Thomas tanner 655141 655141 Gale, Thomas, of Leedes, Yorks, tanner 2
3972627 2015000 2015000 defendant Judson Robert tanner 655141 655141 Judson, Robert, of Leedes, Yorks, tanner 0
3978981 2017237 2017237 defendant Netelton Thomas mercer 655141 655141 Netelton, Thomas, of Leedes, Yorks, mercer 0
3984711 2019289 2019289 defendant Grave Adam clothier 655141 655141 Grave, Adam, of Leedes, Yorks, clothier 0
3984714 2019290 2019290 defendant Wylkynson Augustine dyer 655141 655141 Wylkynson, Augustine, of Leedes, Yorks, dyer 0
3987119 2020138 2020138 defendant Yngle Thomas chapman 655141 655141 Yngle, Thomas, of Leedes, Yorks, chapman 0
3998485 2024195 2024195 defendant Scolfelde Martin carrier 655141 655141 Scolfelde, Martin, of Leedes, Yorks, carrier 0
4037722 2038142 2038142 defendant Sympson William clothier 655141 655141 Sympson, William, of Leedes, Yorks, clothier 1
4105048 2062079 2062079 defendant Ambler Thomas, senior yeoman 655141 655141 Ambler, Thomas, senior, of Leedes, Yorks, yeoman 2
4117826 2066665 2066665 defendant Ley Lawrence clothier 655141 655141 Ley, Lawrence, of Leedes, Yorks, clothier 0
4119863 2067394 2067394 defendant Ambler Thomas clothier 655141 655141 Ambler, Thomas, of Leedes, Yorks, clothier 0
4166245 2083691 2083691 defendant Ambler Thomas clothier 655141 655141 Ambler, Thomas, of Leedes, Yorks, clothier 1
4228989 2105622 2105622 defendant Oldred Richard clothier 655141 655141 Oldred, Richard, of Leedes, Yorks, clothier 0
4272691 2120435 2120435 defendant Atkinson Robert yeoman 655141 655141 Atkinson, Robert, of Leedes, Yorks, yeoman 0
4338320 2143146 2143146 defendant Broughe Thomas chapman 655141 655141 Broughe, Thomas, of Leedes, Yorks, chapman 0
4350735 2147511 2147511 defendant Symesone Robert mercer 655141 655141 Symesone, Robert, of Leedes, Yorks, mercer 0
4350743 2147513 2147513 defendant Tenche Randolph dyer 655141 655141 Tenche, Randolph, of Leedes, Yorks, dyer 0
4360479 2150915 2150915 defendant Tenche Randolph clothier 655141 655141 Tenche, Randolph, of Leedes, Yorks, clothier 0
4376961 2156831 2156831 defendant Swallowe William clothier 655141 655141 Swallowe, William, of Leedes, Yorks, clothier 3
4411770 2168533 2168533 defendant Broughe Thomas mercer 655141 655141 Broughe, Thomas, of Leedes, Yorks, mercer 0
4412225 2168681 2168681 defendant Oldrett or Oldrell Richard clothier 655141 655141 Oldrett or Oldrell, Richard, of Leedes, Yorks, clothier 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);