names

30 rows where place_id = 690962

✎ 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
4087661 2055884 2055884 defendant Markynfeld William yeoman 690962 690962 Markynfeld, William, of Markyngton, yeoman 0
4087662 2055884 2055884 defendant Atkynson Thomas yeoman 690962 690962 Atkynson, Thomas, of Markyngton, yeoman 1
4087663 2055884 2055884 defendant Bowland Marmaduke yeoman 690962 690962 Bowland, Marmaduke, of Markyngton, yeoman 2
4087664 2055884 2055884 defendant Smythe James yeoman 690962 690962 Smythe, James, of Markyngton, yeoman 3
4087666 2055884 2055884 defendant Atkynson John yeoman 690962 690962 Atkynson, John, of Markyngton, yeoman 5
4087667 2055884 2055884 defendant Hallydaye Simon yeoman 690962 690962 Hallydaye, Simon, of Markyngton, yeoman 6
4087668 2055884 2055884 defendant Yates Thomas yeoman 690962 690962 Yates, Thomas, of Markyngton, yeoman 7
4087669 2055884 2055884 defendant Kettelsyne Gilbert yeoman 690962 690962 Kettelsyne, Gilbert, of Markyngton, yeoman 8
4087670 2055884 2055884 defendant Hallyday William yeoman 690962 690962 Hallyday, William, of Markyngton, yeoman 9
4087671 2055884 2055884 defendant Wraye William yeoman 690962 690962 Wraye, William, of Markyngton, yeoman 10
4087672 2055884 2055884 defendant Hessell William yeoman 690962 690962 Hessell, William, of Markyngton, yeoman 11
4552811 2216824 2216824 defendant Wryght John   690962 690962 Wryght, John, of Markyngton 8
4552812 2216824 2216824 defendant Wryghtson Robert   690962 690962 Wryghtson, Robert, of Markyngton 9
4552813 2216824 2216824 defendant Wryghtson John   690962 690962 Wryghtson, John, of Markyngton 10
4924255 2334026 2334026 defendant Marton Thomas husbandman 690962 690962 Marton, Thomas, of Markyngton, husbandman 12
5004550 2358230 2358230 defendant Burnet Thomas laborer 690962 690962 Burnet, Thomas, of Markyngton, laborer 1
5343867 2458269 2458269 defendant Maynard John husbandman 690962 690962 Maynard, John, of Markyngton, husbandman 1
5343871 2458270 2458270 defendant Meynard John husbandman 690962 690962 Meynard, John, of Markyngton, husbandman 1
5514903 2509506 2509506 defendant Kendall Emma widow 690962 690962 Kendall, Emma, of Markyngton, widow 5
5514904 2509506 2509506 defendant Walworth John, junior gent 690962 690962 Walworth, John, junior, of Markyngton, gent 6
5514905 2509506 2509506 defendant Frankyssh John gent 690962 690962 Frankyssh, John, of Markyngton, gent 7
5514906 2509506 2509506 defendant Whaller John tailor 690962 690962 Whaller, John, of Markyngton, tailor 8
5514907 2509506 2509506 defendant Halyday Richard yeoman 690962 690962 Halyday, Richard, of Markyngton, yeoman 9
5514908 2509506 2509506 defendant Cotes Richard yeoman 690962 690962 Cotes, Richard, of Markyngton, yeoman 10
5514915 2509507 2509507 defendant Kendall Emma widow 690962 690962 Kendall, Emma, of Markyngton, widow 5
5514916 2509507 2509507 defendant Walworth John, junior gent 690962 690962 Walworth, John, junior, of Markyngton, gent 6
5514917 2509507 2509507 defendant Frankyssh John gent 690962 690962 Frankyssh, John, of Markyngton, gent 7
5514918 2509507 2509507 defendant Whaller John tailor 690962 690962 Whaller, John, of Markyngton, tailor 8
5514919 2509507 2509507 defendant Halyday Richard yeoman 690962 690962 Halyday, Richard, of Markyngton, yeoman 9
5514920 2509507 2509507 defendant Cotes Richard yeoman 690962 690962 Cotes, Richard, of Markyngton, yeoman 10

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