names

27 rows where place_id = 601226

✎ 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
3644384 1908661 1908661 defendant Goldthorp William gent 601226 601226 Goldthorp, William, of Shepley, gent 0
3693723 1924231 1924231 plaintiff Mascall James   601226 601226 Mascall, James, of Shepley 0
3863665 1978032 1978032 defendant Knyght Richard husbandman 601226 601226 Knyght, Richard, of Shepley, husbandman 1
3930707 2000620 2000620 defendant Weller Richard yeoman 601226 601226 Weller, Richard, of Shepley, yeoman 0
3947717 2006264 2006264 defendant Scott Thomas yeoman 601226 601226 Scott, Thomas, of Shepley, yeoman 0
3978598 2017090 2017090 defendant Darkenold William yeoman 601226 601226 Darkenold, William, of Shepley, yeoman 2
4026256 2034040 2034040 defendant Scott Thomas yeoman 601226 601226 Scott, Thomas, of Shepley, yeoman 0
4081893 2053827 2053827 defendant Hepworthe Edward clothier 601226 601226 Hepworthe, Edward, of Shepley, clothier 1
4096503 2059077 2059077 defendant Tempest Robert gent 601226 601226 Tempest, Robert, of Shepley, gent 0
4147442 2077246 2077246 defendant Slyfeld Robert laborer 601226 601226 Slyfeld Robert, of Shepley, laborer 0
4159308 2081325 2081325 defendant Beardsall Edward clothier 601226 601226 Beardsall, Edward, of Shepley, clothier 2
4159969 2081556 2081556 defendant Rawson William gent 601226 601226 Rawson, William, of Shepley, gent 0
4175443 2086881 2086881 defendant Deane Thomas yeoman 601226 601226 Deane, Thomas, of Shepley, yeoman 0
4177467 2087594 2087594 defendant Sarys John yeoman 601226 601226 Sarys, John, of Shepley, yeoman 0
4181729 2089090 2089090 defendant Senyor Thomas husbandman 601226 601226 Senyor, Thomas, of Shepley, husbandman 1
4181730 2089090 2089090 defendant Senyor John husbandman 601226 601226 Senyor, John, of Shepley, husbandman 2
4261541 2116824 2116824 defendant Whittacres Nicholas husbandman 601226 601226 Whittacres, Nicholas, of Shepley, husbandman 0
4309856 2133603 2133603 defendant Castasyde John miller 601226 601226 Castasyde, John, of Shepley, miller 3
4314776 2135279 2135279 defendant Jooppe Richard yeoman 601226 601226 Jooppe, Richard, of Shepley, yeoman 0
4317740 2136317 2136317 defendant Waryne Thomas haberdasher 601226 601226 Waryne, Thomas, of Shepley, haberdasher 0
4325976 2139061 2139061 defendant Wood Henry husbandman 601226 601226 Wood, Henry, of Shepley, husbandman 2
4561352 2219497 2219497 plaintiff Nuthale John   601226 601226 Nuthale, John, of Shepley 1
5330541 2454223 2454223 defendant Lucas Thomas laborer 601226 601226 Lucas, Thomas, of Shepley, laborer 0
5353536 2461180 2461180 defendant Malynson John husbandman 601226 601226 Malynson, John, of Shepley, husbandman 0
5353537 2461180 2461180 defendant Goldthorp William yeoman 601226 601226 Goldthorp, William, of Shepley, yeoman 1
5353538 2461180 2461180 defendant Worteley Thomas yeoman 601226 601226 Worteley, Thomas, of Shepley, yeoman 2
5490393 2502020 2502020 defendant Walker Thomas yeoman 601226 601226 Walker, Thomas, of Shepley, yeoman 2

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