names

17 rows where place_id = 767028

✎ 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
4534714 2211133 2211133 defendant Bakster Richard (legal representative) 767028 767028 Bakster, Richard, of Carleton by Snayth, executrix of 0
4534715 2211133 2211133 defendant Bakster Isabel   767028 767028 Bakster, Isabel, of Carleton by Snayth 1
4830406 2305544 2305544 defendant Robynson John shipman 767028 767028 Robynson, John, of Carleton by Snayth, shipman 1
4924179 2334006 2334006 defendant Robynson John shipman 767028 767028 Robynson, John, of Carleton by Snayth, shipman 0
5047885 2370983 2370983 defendant Burdon William yeoman 767028 767028 Burdon, William, of Carleton by Snayth, yeoman 1
5143054 2399094 2399094 defendant Burdon William   767028 767028 Burdon, William, of Carleton by Snayth 2
5164461 2405337 2405337 defendant Burdon William yeoman 767028 767028 Burdon, William, of Carleton by Snayth, yeoman 2
5177682 2409166 2409166 defendant Burdon William yeoman 767028 767028 Burdon, William, of Carleton by Snayth, yeoman 2
5201025 2416055 2416055 defendant Burdon William yeoman 767028 767028 Burdon, William, of Carleton by Snayth, yeoman 2
5270382 2436439 2436439 defendant Boteler Margaret widow 767028 767028 Boteler, Margaret, of Carleton by Snayth, widow 0
5270383 2436439 2436439 defendant Nunwyk William weaver 767028 767028 Nunwyk, William, of Carleton by Snayth, weaver 1
5309262 2447807 2447807 defendant Haliwell Robert weaver 767028 767028 Haliwell, Robert, of Carleton by Snayth, weaver 0
5364256 2464479 2464479 defendant Burges Thomas husbandman 767028 767028 Burges, Thomas, of Carleton by Snayth, husbandman 3
5379780 2469257 2469257 defendant Alcok John husbandman 767028 767028 Alcok, John, of Carleton by Snayth, husbandman 0
5395211 2473702 2473702 defendant Burges Thomas husbandman 767028 767028 Burges, Thomas, of Carleton by Snayth, husbandman 3
5408457 2477499 2477499 defendant Burges Thomas husbandman 767028 767028 Burges, Thomas, of Carleton by Snayth, husbandman 3
5441467 2487370 2487370 defendant Burges Thomas husbandman 767028 767028 Burges, Thomas, of Carleton by Snayth, husbandman 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);