names

14 rows where place_id = 600753

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642375 1908061 1908061 defendant ap Rychard David husbandman 600753 600753 ap Rychard, David, of Bredwardyne, husbandman 4
3932793 2001272 2001272 defendant Tewe James clerk 600753 600753 Tewe, James, of Bredwardyne, clerk 0
3932794 2001272 2001272 defendant Bocket James husbandman 600753 600753 Bocket, James, of Bredwardyne, husbandman 1
3944823 2005289 2005289 defendant Badkott Thomas husbandman 600753 600753 Badkott, Thomas, of Bredwardyne, husbandman 1
3950565 2007274 2007274 defendant Browne John clerk 600753 600753 Browne, John, of Bredwardyne, clerk 14
3950583 2007275 2007275 defendant Browne Richard clerk 600753 600753 Browne, Richard, of Bredwardyne, clerk 14
4166917 2083927 2083927 defendant ap Rychard Thomas George carpenter 600753 600753 ap Rychard, Thomas George, of Bredwardyne, carpenter 0
4166918 2083927 2083927 defendant ap Rychard John George carpenter 600753 600753 ap Rychard, John George, of Bredwardyne, carpenter 1
4166919 2083927 2083927 defendant ap Richard Richard Arnold husbandman 600753 600753 ap Richard, Richard Arnold, of Bredwardyne, husbandman 2
4167472 2084122 2084122 defendant ap Rychard John David husbandman 600753 600753 ap Rychard, John David, of Bredwardyne, husbandman 0
4176621 2087297 2087297 defendant Phelpott John husbandman 600753 600753 Phelpott, John, of Bredwardyne, husbandman 2
4176622 2087297 2087297 defendant ap Rychard Thomas husbandman 600753 600753 ap Rychard, Thomas, of Bredwardyne, husbandman 3
4176635 2087301 2087301 defendant Phelpott John yeoman 600753 600753 Phelpott, John, of Bredwardyne, yeoman 2
5590590 2532027 2532027 defendant Veyne Philip chaplain 600753 600753 Veyne, Philip, of Bredwardyne, chaplain 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);