names

18 rows where place_id = 766147

✎ 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
4455136 2186606 2186606 defendant Kokermouth Adam   766147 766147 Kokermouth, Adam, of Holyngton, vicar 0
4524933 2208142 2208142 plaintiff Hunte John   766147 766147 Hunte, John, of Holyngton 0
4562385 2219795 2219795 defendant Smyth William   766147 766147 Smyth, William, of Holyngton, vicar 0
4702507 2266197 2266197 defendant Piers John butcher 766147 766147 Piers, John, of Holyngton, butcher 0
4702509 2266197 2266197 defendant Hunt Richard husbandman 766147 766147 Hunt, Richard, of Holyngton, husbandman 2
4748789 2280131 2280131 defendant Peche Robert husbandman 766147 766147 Peche, Robert, of Holyngton, husbandman 2
4962764 2345772 2345772 plaintiff Bukholt William   766147 766147 Bukholt, William, of Holyngton 0
4977882 2350342 2350342 defendant Partrych Peter husbandman 766147 766147 Partrych, Peter, of Holyngton, husbandman 0
5009163 2359566 2359566 defendant Peprkyn William butcher 766147 766147 Peprkyn, William, of Holyngton, butcher 0
5040439 2368743 2368743 defendant Salford John husbandman 766147 766147 Salford, John, of Holyngton, husbandman 5
5074683 2378934 2378934 defendant Smyth Robert smith 766147 766147 Smyth, Robert, of Holyngton, smith 1
5074689 2378935 2378935 defendant Smyth Robert smith 766147 766147 Smyth, Robert, of Holyngton, smith 1
5321415 2451497 2451497 defendant Wymond John husbandman 766147 766147 Wymond, John, of Holyngton, husbandman 2
5323481 2452101 2452101 defendant Westborne John yeoman 766147 766147 Westborne, John, of Holyngton, yeoman 0
5354085 2461341 2461341 defendant Westborn John husbandman 766147 766147 Westborn, John, of Holyngton, husbandman 1
5382766 2470137 2470137 defendant Clement John   766147 766147 Clement, John, of Holyngton, Sussex and of Westminster, prebendary clerk 0
5446720 2488916 2488916 defendant Trouth John   766147 766147 Trouth, John, of Holyngton 0
5470954 2496245 2496245 defendant Trouth John   766147 766147 Trouth, John, of Holyngton 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);