names

19 rows where place_id = 687160

✎ 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
4070053 2049578 2049578 defendant Sturton George merchant 687160 687160 Sturton, George, of Waymouth & Melcombe Regis, merchant 0
4075678 2051605 2051605 defendant Ledoys William merchant 687160 687160 Ledoys, William, of Waymouth & Melcombe Regis, merchant 0
4116522 2066198 2066198 defendant Randall Hugh merchant 687160 687160 Randall, Hugh, of Waymouth & Melcombe Regis, merchant 0
4127866 2070256 2070256 defendant Gregorie Robert merchant 687160 687160 Gregorie, Robert, of Waymouth & Melcombe Regis, merchant 0
4132587 2071973 2071973 defendant Gregorye Robert merchant 687160 687160 Gregorye, Robert, of Waymouth & Melcombe Regis, merchant 0
4140917 2074988 2074988 defendant Ledosse William merchant 687160 687160 Ledosse, William, of Waymouth & Melcombe Regis, merchant 0
4156728 2080431 2080431 defendant James alias Ledose William baker 687160 687160 James alias Ledose, William, of Waymouth & Melcombe Regis, baker 0
4175853 2087029 2087029 defendant Gregorye Robert merchant 687160 687160 Gregorye, Robert, of Waymouth & Melcombe Regis, merchant 0
4177423 2087577 2087577 defendant Samwayes Thomas merchant 687160 687160 Samwayes, Thomas, of Waymouth & Melcombe Regis, merchant 0
4185819 2090534 2090534 defendant Harrys Francis merchant 687160 687160 Harrys, Francis, of Waymouth & Melcombe Regis, merchant 0
4238736 2109169 2109169 defendant Samwayes John yeoman 687160 687160 Samwayes, John, of Waymouth & Melcombe Regis, yeoman 0
4238737 2109169 2109169 defendant Samwayes Anne widow 687160 687160 Samwayes, Anne, of Waymouth & Melcombe Regis, widow 1
4243525 2110824 2110824 defendant Baylye Ralph yeoman 687160 687160 Baylye, Ralph, of Waymouth & Melcombe Regis, yeoman 1
4247181 2112033 2112033 defendant Samwayes John yeoman 687160 687160 Samwayes, John, of Waymouth & Melcombe Regis, yeoman 0
4247182 2112033 2112033 defendant Samwayes Anne widow 687160 687160 Samwayes, Anne, of Waymouth & Melcombe Regis, widow 1
4291862 2127165 2127165 defendant Pitt Henry merchant 687160 687160 Pitt, Henry, of Waymouth & Melcombe Regis, merchant 0
4349021 2146921 2146921 defendant Gilbord Robert   687160 687160 Gilbord, Robert, of Waymouth & Melcombe Regis, Dorset, sailor 1
4375869 2156430 2156430 defendant Lavor Morgan beer brewer 687160 687160 Lavor, Morgan, of Waymouth & Melcombe Regis, beer brewer 0
4378585 2157414 2157414 defendant Smalle John yeoman 687160 687160 Smalle, John, of Waymouth & Melcombe Regis, 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);