names

23 rows where place_id = 890107

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, raw_segment

id ▼ case_id role surname forename occupation place_id raw_segment seq
5450189 2489945 2489945 plaintiff (not given) Christopher rector of Persons 890107 890107 Persons, Christopher, of Slaytburn, rector of the church 0
5462181 2493585 2493585 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn 0
5462183 2493586 2493586 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5462185 2493587 2493587 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5462187 2493588 2493588 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5462189 2493589 2493589 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5462191 2493590 2493590 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5462193 2493591 2493591 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5462195 2493592 2493592 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5462197 2493593 2493593 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5462199 2493594 2493594 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5462201 2493595 2493595 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5473691 2497101 2497101 plaintiff Parson Christopher   890107 890107 Parson, Christopher, of Slaytburn, rector 0
5473693 2497102 2497102 plaintiff Parson Christopher   890107 890107 Parson, Christopher, of Slaytburn, rector 0
5473695 2497103 2497103 plaintiff Parson Christopher   890107 890107 Parson, Christopher, of Slaytburn, rector 0
5473697 2497104 2497104 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5473699 2497105 2497105 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5473701 2497106 2497106 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5473703 2497107 2497107 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5473705 2497108 2497108 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5473707 2497109 2497109 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5473709 2497110 2497110 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0
5473711 2497111 2497111 plaintiff Parsons Christopher   890107 890107 Parsons, Christopher, of Slaytburn, rector 0

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