names

20 rows where place_id = 744486

✎ 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
4348684 2146798 2146798 defendant Cogger William   744486 744486 Cogger, William, of Tyshurst, "ashgealer" 0
4361256 2151189 2151189 defendant Keene John yeoman 744486 744486 Keene, John, of Tyshurst, yeoman 0
4463004 2189132 2189132 defendant Bakere Adam   744486 744486 Bakere, Adam, of Tyshurst 0
4524928 2208140 2208140 defendant Skynner John   744486 744486 Skynner, John, of Tyshurst 0
4562601 2219861 2219861 defendant Placedewe William chaplain 744486 744486 Placedewe, William, of Tyshurst, chaplain 1
4562602 2219861 2219861 defendant Sexteyn Richard   744486 744486 Sexteyn, Richard, of Tyshurst 2
4562603 2219861 2219861 defendant Cheseman Stephen   744486 744486 Cheseman, Stephen, of Tyshurst 3
4562604 2219861 2219861 defendant Tourmery Stephen   744486 744486 Tourmery, Stephen, of Tyshurst 4
4562607 2219862 2219862 defendant Placedewe William chaplain 744486 744486 Placedewe, William, of Tyshurst, chaplain 1
4562608 2219862 2219862 defendant Sexteyn Richard   744486 744486 Sexteyn, Richard, of Tyshurst 2
4562609 2219862 2219862 defendant Cheseman Stephen   744486 744486 Cheseman, Stephen, of Tyshurst 3
4562610 2219862 2219862 defendant Tournemery Stephen   744486 744486 Tournemery, Stephen, of Tyshurst 4
4798618 2295748 2295748 defendant Bereworthe John tanner 744486 744486 Bereworthe, John, of Tyshurst, tanner 1
4798625 2295749 2295749 defendant Bereworthe John tanner 744486 744486 Bereworthe, John, of Tyshurst, tanner 1
4809396 2299116 2299116 defendant atte Wode Robert husbandman 744486 744486 atte Wode, Robert, of Tyshurst, husbandman 0
4809398 2299116 2299116 defendant Burdon John laborer 744486 744486 Burdon, John, of Tyshurst, laborer 2
4809399 2299116 2299116 defendant Baseden Thomas carpenter 744486 744486 Baseden, Thomas, of Tyshurst, carpenter 3
4834360 2306755 2306755 defendant Yonge Richard laborer 744486 744486 Yonge, Richard, of Tyshurst, laborer 0
4947430 2341192 2341192 defendant Waterer John husbandman 744486 744486 Waterer, John, of Tyshurst, husbandman 0
5630393 2553515 2553515 defendant atte Wode Robert yeoman 744486 744486 atte Wode, Robert, of Tyshurst, 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);