names

17 rows where place_id = 768592

✎ 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
4550407 2216070 2216070 defendant Couper William   768592 768592 Couper, William, of South Wynfeld 1
4550408 2216070 2216070 defendant Taillour John   768592 768592 Taillour, John, of South Wynfeld 2
4773292 2287620 2287620 defendant Wodhous atte Pirle Robert husbandman 768592 768592 Wodhous atte Pirle, Robert, of South Wynfeld, husbandman 0
4773300 2287624 2287624 defendant Wylkynson John husbandman 768592 768592 Wylkynson, John, of South Wynfeld, husbandman 0
4844669 2309849 2309849 defendant Colman Robert husbandman 768592 768592 Colman, Robert, of South Wynfeld, husbandman 1
4905336 2328261 2328261 defendant Huknall John husbandman 768592 768592 Huknall, John, of South Wynfeld, husbandman 2
4980028 2350980 2350980 defendant Wryght William   768592 768592 Wryght, William, of South Wynfeld, wright 0
5002404 2357612 2357612 defendant Colman William husbandman 768592 768592 Colman, William, of South Wynfeld, husbandman 1
5280833 2439466 2439466 plaintiff Chesshire John   768592 768592 Chesshire, John, of South Wynfeld 0
5300358 2445064 2445064 plaintiff Chesshire John   768592 768592 Chesshire, John, of South Wynfeld 0
5338234 2456526 2456526 defendant Hyll William   768592 768592 Hyll, William, of South Wynfeld, Derbsm yeoman 0
5394904 2473614 2473614 defendant Blake William   768592 768592 Blake, William, of South Wynfeld 0
5408156 2477413 2477413 defendant Blake William yeoman 768592 768592 Blake, William, of South Wynfeld, yeoman 0
5468305 2495463 2495463 defendant Blake William yeoman 768592 768592 Blake, William, of South Wynfeld, yeoman 2
5468306 2495463 2495463 defendant Gyte James yeoman 768592 768592 Gyte, James, of South Wynfeld, yeoman 3
5468307 2495463 2495463 defendant Wolley (illegible) husbandman 768592 768592 Wolley, _, of South Wynfeld, husbandman 4
5468308 2495463 2495463 defendant Stokkys John weaver 768592 768592 Stokkys, John, of South Wynfeld, weaver 5

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