names

20 rows where place_id = 665947

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3979021 2017251 2017251 defendant Frenche Leonard capper 665947 665947 Frenche, Leonard, of Tavistocke, Devon, capper 0
3979023 2017252 2017252 defendant Granger Hugh yeoman 665947 665947 Granger, Hugh, of Tavistocke, Devon, yeoman 0
4037638 2038113 2038113 defendant Poynter Richard merchant 665947 665947 Poynter, Richard, of Tavistocke, Devon, merchant 0
4037640 2038114 2038114 defendant Poynter Richard merchant 665947 665947 Poynter, Richard, of Tavistocke, Devon, merchant 0
4152912 2079125 2079125 defendant Grille Charles gent 665947 665947 Grille, Charles, of Tavistocke, Devon, gent 0
4170287 2085100 2085100 defendant Hawkins John yeoman 665947 665947 Hawkins, John, of Tavistocke, Devon, yeoman 0
4217187 2101506 2101506 defendant Mohun Thomas gent 665947 665947 Mohun, Thomas, of Tavistocke, Devon, gent 0
4217189 2101507 2101507 defendant Williams William (legal representative) 665947 665947 Williams, William, of Tavistocke, Devon, victualer, administrator of 0
4241221 2110051 2110051 defendant Mohun Thomas gent 665947 665947 Mohun, Thomas, of Tavistocke, Devon, gent 1
4244921 2111287 2111287 defendant Masters Walter mercer 665947 665947 Masters, Walter, of Tavistocke, Devon, mercer 0
4244925 2111288 2111288 defendant Masters Walter mercer 665947 665947 Masters, Walter, of Tavistocke, Devon, mercer 0
4246893 2111935 2111935 defendant Masters Walter merchant 665947 665947 Masters, Walter, of Tavistocke, Devon, merchant 0
4268983 2119221 2119221 defendant Nasters Walter merchant 665947 665947 Nasters, Walter, of Tavistocke, Devon, merchant 0
4275577 2121400 2121400 defendant Masters Walter merchant 665947 665947 Masters, Walter, of Tavistocke, Devon, merchant 0
4294098 2127969 2127969 defendant Mone Thomas gent 665947 665947 Mone, Thomas, of Tavistocke, Devon, gent 0
4311840 2134277 2134277 defendant Mohun Thomas gent 665947 665947 Mohun, Thomas, of Tavistocke, Devon, gent 0
4317313 2136169 2136169 defendant Mohun Thomas gent 665947 665947 Mohun, Thomas, of Tavistocke, Devon, gent 0
4339935 2143741 2143741 defendant Prideaux William gent 665947 665947 Prideaux, William, of Tavistocke, Devon, gent 0
4356264 2149415 2149415 defendant Browne John yeoman 665947 665947 Browne, John, of Tavistocke, Devon, yeoman 0
4359155 2150435 2150435 defendant Skyrrett Thomas merchant 665947 665947 Skyrrett, Thomas, of Tavistocke, Devon, merchant 2

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