names

24 rows where place_id = 624621

✎ 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
3759310 1944901 1944901 defendant Mun Roger husbandman 624621 624621 Mun, Roger, of Lyndryche, husbandman 0
3929140 2000085 2000085 defendant Mun Thomas tanner 624621 624621 Mun, Thomas, of Lyndryche, tanner 0
3929142 2000086 2000086 defendant Mun Thomas tanner 624621 624621 Mun, Thomas, of Lyndryche, tanner 0
3961866 2011247 2011247 defendant Alowe Thomas yeoman 624621 624621 Alowe, Thomas, of Lyndryche, yeoman 0
3961867 2011247 2011247 defendant Hill Roger laborer 624621 624621 Hill, Roger, of Lyndryche, laborer 1
3961868 2011247 2011247 defendant Alowe William laborer 624621 624621 together with Alowe, William, of Lyndryche, laborer 2
3961872 2011248 2011248 defendant Alowe William laborer 624621 624621 Alowe, William, of Lyndryche, laborer 1
3961873 2011248 2011248 defendant Alowe Thomas yeoman 624621 624621 together with Alowe, Thomas, of Lyndryche, yeoman 2
3961874 2011248 2011248 defendant Hill Roger laborer 624621 624621 Hill, Roger, of Lyndryche, laborer 3
3985633 2019625 2019625 defendant Bryan Thomas husbandman 624621 624621 Bryan, Thomas, of Lyndryche, husbandman 0
3996101 2023358 2023358 defendant Penell Thomas yeoman 624621 624621 Penell, Thomas, of Lyndryche, yeoman 0
4009299 2028090 2028090 defendant Pennell Thomas yeoman 624621 624621 Pennell, Thomas, of Lyndryche, yeoman 0
4009302 2028091 2028091 defendant Pennell Thomas yeoman 624621 624621 Pennell, Thomas, of Lyndryche, yeoman 0
4009327 2028101 2028101 defendant Walker Roger yeoman 624621 624621 Walker, Roger, of Lyndryche, yeoman 1
4009328 2028101 2028101 defendant Bodenam Thomas yeoman 624621 624621 Bodenam, Thomas, of Lyndryche, yeoman 2
4009331 2028102 2028102 defendant Pennell Thomas yeoman 624621 624621 Pennell, Thomas, of Lyndryche, yeoman 1
4041338 2039391 2039391 defendant Walker Roger yeoman 624621 624621 Walker, Roger, of Lyndryche, yeoman 0
4041340 2039392 2039392 defendant Bodnam Thomas yeoman 624621 624621 Bodnam, Thomas, of Lyndryche, yeoman 0
4042927 2039947 2039947 plaintiff Pennell William weaver 624621 624621 Pennell, William, of Lyndryche, weaver 0
4049952 2042415 2042415 defendant Robyns John yeoman 624621 624621 Robyns, John, of Lyndryche, yeoman 0
4049953 2042415 2042415 defendant Wythye Richard yeoman 624621 624621 Wythye, Richard, of Lyndryche, yeoman 1
4049959 2042417 2042417 plaintiff Walker Roger yeoman 624621 624621 Walker, Roger, of Lyndryche, yeoman 0
4050601 2042644 2042644 defendant Angell John husbandman 624621 624621 Angell, John, of Lyndryche, husbandman 0
4060571 2046183 2046183 defendant Walker Roger yeoman 624621 624621 Walker, Roger, of Lyndryche, 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);