names

24 rows where place_id = 604649

✎ 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
3658778 1913001 1913001 defendant Tolyn Robert yeoman 604649 604649 Tolyn, Robert, of Ilfracombe, yeoman 0
4594477 2229535 2229535 defendant Smyth Robert   604649 604649 Smyth, Robert, of Ilfracombe 0
4704007 2266631 2266631 defendant Edward John husbandman 604649 604649 Edward, John, of Ilfracombe, husbandman 0
4704009 2266632 2266632 defendant Edward John husbandman 604649 604649 Edward, John, of Ilfracombe, husbandman 0
4754612 2281824 2281824 defendant Elys Robert yeoman 604649 604649 Elys, Robert, of Ilfracombe, yeoman 2
4756228 2282321 2282321 defendant Elys Robert husbandman 604649 604649 Elys, Robert, of Ilfracombe, husbandman 0
4761104 2283824 2283824 defendant Elys Robert yeoman 604649 604649 Elys, Robert, of Ilfracombe, yeoman 2
4766353 2285467 2285467 defendant Weye Thomas mariner 604649 604649 Weye, Thomas, of Ilfracombe, mariner 5
4766354 2285467 2285467 defendant Hoper John mariner 604649 604649 Hoper, John, of Ilfracombe, mariner 6
4766400 2285482 2285482 defendant James John merchant 604649 604649 James, John, of Ilfracombe, merchant 0
4766402 2285483 2285483 defendant James John merchant 604649 604649 James, John, of Ilfracombe, merchant 0
4768223 2286032 2286032 defendant Morton John clerk 604649 604649 Morton, John, of Ilfracombe, parson, formerly of Exeter, Devon, clerk 0
4775787 2288425 2288425 defendant Michell William mariner 604649 604649 Michell, William, of Ilfracombe, mariner 6
4775788 2288425 2288425 defendant Bowerede Robert mariner 604649 604649 Bowerede, Robert, of Ilfracombe, mariner 7
4775789 2288425 2288425 defendant Lytell John mariner 604649 604649 Lytell, John, of Ilfracombe, mariner 8
4775790 2288425 2288425 defendant Bond Henry mariner 604649 604649 Bond, Henry, of Ilfracombe, mariner 9
4823536 2303450 2303450 defendant Roche David chapman 604649 604649 Roche, David, of Ilfracombe, chapman 1
4831682 2305936 2305936 defendant Lytela John mariner 604649 604649 Lytela, John, of Ilfracombe, mariner 1
4831683 2305936 2305936 defendant Drake John tailor 604649 604649 Drake, John, of Ilfracombe, tailor 2
5004061 2358073 2358073 defendant Gurre Richard (legal representative) 604649 604649 Gurre, Richard, of Ilfracombe, burgess, executors of 2
5010501 2359948 2359948 defendant Kyngeslond Thomas gent 604649 604649 Kyngeslond, Thomas, of Ilfracombe, gent 0
5011401 2360198 2360198 defendant Deryk John shipman 604649 604649 Deryk, John, of Ilfracombe, shipman 0
5199226 2415527 2415527 plaintiff Ware John mariner 604649 604649 Ware, John, of Ilfracombe, mariner 0
5613842 2548105 2548105 defendant Bakere William   604649 604649 Bakere, William, of Ilfracombe 4

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);