names

19 rows where place_id = 635552

✎ 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
3826252 1966057 1966057 defendant Bayly Robert yeoman 635552 635552 Bayly, Robert, of Bysshop Burton, yeoman 0
3826287 1966070 1966070 defendant Percy William   635552 635552 Percy, William, of Bysshop Burton, knight 1
4569830 2222135 2222135 defendant Craas Robert   635552 635552 Craas, Robert, of Bysshop Burton 0
4793088 2293930 2293930 defendant Forster Thomas yeoman 635552 635552 Forster, Thomas, of Bysshop Burton, yeoman 3
4793089 2293930 2293930 defendant Jonson Thomas husbandman 635552 635552 Jonson, Thomas, of Bysshop Burton, husbandman 4
4916144 2331549 2331549 defendant Saunder Thomas husbandman 635552 635552 Saunder, Thomas, of Bysshop Burton, husbandman 0
4916146 2331550 2331550 defendant Saunder Thomas husbandman 635552 635552 Saunder, Thomas, of Bysshop Burton, husbandman 0
4987547 2353231 2353231 defendant Siggeston Robert yeoman 635552 635552 Siggeston, Robert, of Bysshop Burton, yeoman 1
5000743 2357093 2357093 defendant Walker John husbandman 635552 635552 Walker, John, of Bysshop Burton, husbandman 1
5029019 2365357 2365357 defendant Johnson William husbandman 635552 635552 Johnson, William, of Bysshop Burton, husbandman 1
5030918 2365914 2365914 defendant Kyng Roger husbandman 635552 635552 Kyng, Roger, of Bysshop Burton, husbandman 0
5117671 2391603 2391603 defendant Kyng Roger husbandman 635552 635552 Kyng, Roger, of Bysshop Burton, husbandman 0
5212865 2419507 2419507 defendant Cotyngham Edmund yeoman 635552 635552 Cotyngham, Edmund, of Bysshop Burton, yeoman 0
5229374 2424203 2424203 defendant Cotyngham Edmund yeoman 635552 635552 Cotyngham, Edmund, of Bysshop Burton, yeoman 0
5229375 2424203 2424203 defendant Ruse William yeoman 635552 635552 Ruse, William, of Bysshop Burton, yeoman 1
5327174 2453200 2453200 defendant Deen John weaver 635552 635552 Deen, John, of Bysshop Burton, weaver 5
5327459 2453282 2453282 defendant Deen John weaver 635552 635552 Deen, John, of Bysshop Burton, weaver 8
5594032 2533119 2533119 defendant Bolser Thomas laborer 635552 635552 Bolser, Thomas, of Bysshop Burton, laborer 14
5594034 2533119 2533119 defendant Blomer John yeoman 635552 635552 Blomer, John, of Bysshop Burton, yeoman 16

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