names

22 rows where place_id = 588938

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596058 1866395 1866395 defendant Coweley John yeoman 588938 588938 Coweley, John, of Longesdon, yeoman 0
3750948 1942221 1942221 defendant Jenkyns Henry laborer 588938 588938 Jenkyns, Henry, of Longesdon, laborer 0
3752331 1942653 1942653 defendant Jenkys Henry husbandman 588938 588938 Jenkys, Henry, of Longesdon, husbandman 3
3752332 1942653 1942653 defendant Roland James husbandman 588938 588938 Roland, James, of Longesdon, husbandman 4
3777473 1950705 1950705 defendant Harvy Robert miner 588938 588938 Harvy, Robert, of Longesdon, miner 3
3777474 1950705 1950705 defendant Hamer Edward miner 588938 588938 Hamer, Edward, of Longesdon, miner 4
3780047 1951485 1951485 defendant Mornesall Thomas husbandman 588938 588938 Mornesall, Thomas, of Longesdon, husbandman 2
3780048 1951485 1951485 defendant Seller Henry husbandman 588938 588938 Seller, Henry, of Longesdon, husbandman 3
3780049 1951485 1951485 defendant Jamys Edward husbandman 588938 588938 Jamys, Edward, of Longesdon, husbandman 4
3881329 1984020 1984020 defendant Hamer Thomas laborer 588938 588938 Hamer, Thomas, of Longesdon, laborer 2
4194961 2093800 2093800 defendant White Robert yeoman 588938 588938 White, Robert, of Longesdon, yeoman 0
4216116 2101127 2101127 defendant Waddington Robert miner 588938 588938 Waddington, Robert, of Longesdon, miner 2
4216117 2101127 2101127 defendant Mosley Robert miner 588938 588938 Mosley, Robert, of Longesdon, miner 3
4294795 2128223 2128223 defendant Stevenson James husbandman 588938 588938 Stevenson, James, of Longesdon, husbandman 1
4681288 2259773 2259773 defendant Broke John yeoman 588938 588938 Broke, John, of Longesdon, yeoman 0
4689124 2262159 2262159 defendant Mosse William husbandman 588938 588938 Mosse, William, of Longesdon, husbandman 3
4689129 2262160 2262160 defendant Mosse William husbandman 588938 588938 Mosse, William, of Longesdon, husbandman 3
4784892 2291282 2291282 defendant Roberdesson Roger husbandman 588938 588938 Roberdesson, Roger, of Longesdon, husbandman 1
4913117 2330596 2330596 defendant Shakirley John gent 588938 588938 Shakirley, John, of Longesdon, gent 4
4960027 2344964 2344964 defendant Wright Henry husbandman 588938 588938 Wright, Henry, of Longesdon, husbandman 1
4960028 2344964 2344964 defendant Wright Thomas husbandman 588938 588938 Wright, Thomas, of Longesdon, husbandman 2
5564337 2524182 2524182 defendant Jenkyns Richard yeoman 588938 588938 Jenkyns, Richard, of Longesdon, yeoman 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);