names

21 rows where place_id = 823307

✎ 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
4927398 2335002 2335002 defendant Buurdon John merchant 823307 823307 Buurdon, John, of Wellys next the sea, merchant 1
4987783 2353310 2353310 defendant Williamson Richard butcher 823307 823307 Williamson, Richard, of Wellys next the sea, butcher 1
5040514 2368773 2368773 defendant Fuller Andrew shipman 823307 823307 Fuller, Andrew, of Wellys next the sea, shipman 0
5040986 2368927 2368927 defendant Elverych Thomas husbandman 823307 823307 Elverych, Thomas, of Wellys next the sea, husbandman 1
5041582 2369086 2369086 plaintiff Colles Simon   823307 823307 Colles, Simon, of Wellys next the sea 0
5041584 2369086 2369086 plaintiff Berde Hugh   823307 823307 Berde, Hugh, of Wellys next the sea 2
5044757 2370067 2370067 defendant Wyllyamson alias Bocher Richard butcher 823307 823307 Wyllyamson alias Bocher, Richard, of Wellys next the sea, butcher 1
5128590 2394842 2394842 plaintiff Collys Simon   823307 823307 Collys, Simon, of Wellys next the sea 0
5142349 2398883 2398883 defendant Dodde John baker 823307 823307 Dodde, John, of Wellys next the sea, baker 0
5366102 2465060 2465060 defendant Burgony John   823307 823307 Burgony, John, of Wellys next the sea, husbandman, administrators of 0
5366103 2465060 2465060 defendant Roper Edmund husbandman 823307 823307 (Roper, Edmund, of Wellys next the Sea, husbandman 1
5373945 2467446 2467446 defendant Rengham Robert   823307 823307 Rengham, Robert, of Wellys next the sea, shoe maker 4
5378444 2468842 2468842 defendant Burgony Hugh husbandman 823307 823307 Burgony, Hugh, of Wellys next the Sea, husbandman 0
5379522 2469184 2469184 defendant Roper Edmund roper 823307 823307 Roper, Edmund, of Wellys next the sea, roper 0
5381270 2469696 2469696 defendant Collys William yeoman 823307 823307 Collys, William, of Wellys next the sea, yeoman 0
5388106 2471657 2471657 defendant Collys William yeoman 823307 823307 Collys, William, of Wellys next the sea, yeoman 0
5400304 2475162 2475162 defendant Johannesson Thomas husbandman 823307 823307 Johannesson, Thomas, of Wellys next the sea, husbandman 0
5414858 2479374 2479374 defendant Mony Robert   823307 823307 Mony, Robert, of Wellys next the Sea 11
5445813 2488636 2488636 defendant Inge Thomas husbandman 823307 823307 Inge, Thomas, of Wellys next the sea, husbandman 0
5454148 2491137 2491137 defendant Johnesson Thomas   823307 823307 Johnesson, Thomas, of Wellys next the Sea 0
5609682 2537924 2537924 defendant Roper Edmund   823307 823307 Roper, Edmund, of Wellys next the sea, rope maker 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);