names

16 rows where place_id = 621384

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3741085 1939075 1939075 defendant White Robert chaplain 621384 621384 White, Robert, of Maryng, chaplain 0
4468644 2190865 2190865 plaintiff Beket John   621384 621384 Beket, John, of Maryng 0
4488363 2197078 2197078 defendant Tolkyn John   621384 621384 Tolkyn, John, of Maryng 1
4488364 2197078 2197078 defendant South Ralph   621384 621384 South, Ralph, of Maryng 2
4544904 2214324 2214324 defendant Bosse Simon   621384 621384 Bosse, Simon, of Maryng 1
4555011 2217497 2217497 plaintiff Haryngton Stephen   621384 621384 Haryngton, Stephen, of Maryng 0
4555012 2217497 2217497 defendant Besse Simon   621384 621384 Besse, Simon, of Maryng 0
4555013 2217498 2217498 plaintiff Haryngton Stephen   621384 621384 Haryngton, Stephen, of Maryng 0
4555014 2217498 2217498 defendant Bosse Simon   621384 621384 Bosse, Simon, of Maryng 0
4567001 2221237 2221237 defendant Bosse Simon   621384 621384 Bosse, Simon, of Maryng 3
4572153 2222843 2222843 defendant Ferrour Gilbert   621384 621384 Ferrour, Gilbert, of Maryng 0
4588910 2227905 2227905 defendant Bosse Simon   621384 621384 Bosse, Simon, of Maryng 0
4699619 2265332 2265332 defendant Bayly Thomas husbandman 621384 621384 Bayly, Thomas, of Maryng, husbandman 0
4705783 2267180 2267180 defendant Haryngton Stephen de husbandman 621384 621384 Haryngton, Stephen de, of Maryng, husbandman 0
4788111 2292353 2292353 defendant Childe Thomas   621384 621384 Childe, Thomas, of Maryng, shepherd 0
5631459 2553847 2553847 defendant Bayle Thomas husbandman 621384 621384 Bayle, Thomas, of Maryng, 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);