names

18 rows where case_id = 2280222

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4749098 2280222 2280222 plaintiff Neuton Robert   757051 757051 Neuton, Robert, of Seteryngton, parson 0
4749099 2280222 2280222 defendant Redenes Richard     Redenes, Richard 0
4749100 2280222 2280222 defendant Bolom William     Bolom, William 1
4749101 2280222 2280222 defendant Broun Clement     Broun, Clement 2
4749102 2280222 2280222 defendant Broun Robert servant   Broun, Robert, servant 3
4749103 2280222 2280222 defendant Garbot Thomas     Garbot, Thomas 4
4749104 2280222 2280222 defendant Clerk John, senior clerk   Clerk, John, senior, clerk 5
4749105 2280222 2280222 defendant Beleby John     Beleby, John 6
4749106 2280222 2280222 defendant Schephird Thomas Wade, John   Schephird, Thomas, Wade, John 7
4749107 2280222 2280222 defendant Wade Robert     Wade, Robert 8
4749108 2280222 2280222 defendant Curt Thomas     Curt, Thomas 9
4749109 2280222 2280222 defendant Curt John weaver   Curt, John, weaver 10
4749110 2280222 2280222 defendant Carter Robert     Carter, Robert 11
4749111 2280222 2280222 defendant Geffrayson John     Geffrayson, John 12
4749112 2280222 2280222 defendant Barrok Thomas     Barrok, Thomas 13
4749113 2280222 2280222 defendant Swayter Clement laborer   Swayter, Clement, laborer 14
4749114 2280222 2280222 defendant Barker John laborer   Barker, John, laborer 15
4749115 2280222 2280222 defendant each of Scakilthorp or Scagglethorpe   unless other occupation given   each of Scakilthorp or Scagglethorpe, husbandman, unless other occupation given 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);