names

19 rows where place_id = 601748

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3646831 1909410 1909410 defendant Beele William husbandman 601748 601748 Beele, William, of Brynkeworth, husbandman 11
3649245 1910153 1910153 defendant Cosenar William husbandman 601748 601748 Cosenar, William, of Brynkeworth, husbandman 0
3705140 1927897 1927897 defendant Wayet Walter husbandman 601748 601748 Wayet, Walter, of Brynkeworth, husbandman 0
3818504 1963688 1963688 defendant Veyle William husbandman 601748 601748 Veyle, William, of Brynkeworth, husbandman 0
4521315 2207010 2207010 plaintiff Gaag William   601748 601748 Gaag, William, of Brynkeworth 0
4521389 2207033 2207033 plaintiff Gang William   601748 601748 Gang, William, of Brynkeworth 0
4584382 2226531 2226531 defendant Dene Robert   601748 601748 Dene, Robert, of Brynkeworth 1
4679813 2259296 2259296 defendant Trappere John husbandman 601748 601748 Trappere, John, of Brynkeworth, husbandman 0
4697669 2264763 2264763 defendant Pleyer William husbandman 601748 601748 Pleyer, William, of Brynkeworth, husbandman 0
4820699 2302550 2302550 defendant Mey John husbandman 601748 601748 Mey, John, of Brynkeworth, husbandman 0
5065665 2376258 2376258 defendant Breche William yeoman 601748 601748 Breche, William, of Brynkeworth, yeoman 3
5098187 2385900 2385900 defendant Wayte Thomas butcher 601748 601748 (Wayte, Thomas, of Brynkeworth, butcher 4
5140530 2398338 2398338 defendant Bagge Walter clerk 601748 601748 Bagge, Walter, of Brynkeworth, clerk 0
5160310 2404108 2404108 defendant Bagge Walter clerk 601748 601748 Bagge, Walter, of Brynkeworth, clerk 0
5160313 2404109 2404109 defendant Bagge Walter clerk 601748 601748 Bagge, Walter, of Brynkeworth, clerk 0
5175983 2408659 2408659 defendant Bagge Walter clerk 601748 601748 Bagge, Walter, of Brynkeworth, clerk 0
5197723 2415078 2415078 defendant Bagge Walter clerk 601748 601748 Bagge, Walter, of Brynkeworth, clerk 0
5286755 2441135 2441135 defendant Benet William yeoman 601748 601748 Benet, William, of Brynkeworth, yeoman 1
5574869 2527221 2527221 defendant Parker Geoffrey yeoman 601748 601748 Parker, Geoffrey, of Brynkeworth, yeoman 1

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