names

17 rows where place_id = 642586

✎ 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
3868829 1979816 1979816 plaintiff Thornherst Stephen   642586 642586 Thornherst, Stephen, of Apledore 0
3969304 2013867 2013867 defendant Coxe John shoemaker 642586 642586 Coxe, John, of Apledore, shoemaker 0
3969306 2013868 2013868 defendant Coxe John shoemaker 642586 642586 Coxe, John, of Apledore, shoemaker 0
4086645 2055512 2055512 defendant Nicolson Nicholas tailor 642586 642586 Nicolson, Nicholas, of Apledore, tailor 0
4119951 2067424 2067424 defendant Lychepoole Francis tailor 642586 642586 Lychepoole, Francis, of Apledore, tailor 1
4155242 2079927 2079927 defendant Northe John husbandman 642586 642586 Northe, John, of Apledore, husbandman 1
4156097 2080208 2080208 defendant Coxe Thomas shoemaker 642586 642586 Coxe, Thomas, of Apledore, shoemaker 1
4168971 2084640 2084640 defendant Byam Henry husbandman 642586 642586 Byam, Henry, of Apledore, husbandman 3
4184665 2090146 2090146 defendant Fenton Robert beer brewer 642586 642586 Fenton, Robert, of Apledore, beer brewer 0
4192977 2093109 2093109 defendant Hounde William laborer 642586 642586 Hounde, William, of Apledore, laborer 1
4273015 2120535 2120535 defendant Bacheler Richard tailor 642586 642586 Bacheler, Richard, of Apledore, tailor 1
4310840 2133938 2133938 defendant Robyns James yeoman 642586 642586 Robyns, James, of Apledore, yeoman 0
4310841 2133938 2133938 defendant Diggons John yeoman 642586 642586 Diggons, John, of Apledore, yeoman 1
4314361 2135133 2135133 defendant Robyns James yeoman 642586 642586 Robyns, James, of Apledore, yeoman 0
4322098 2137809 2137809 defendant Bacheler Richard   642586 642586 Bacheler, Richard, of Apledore, yeoman, administrators of 1
4322099 2137809 2137809 defendant Adams Thomas yeoman 642586 642586 (Adams, Thomas, of Apledore, yeoman 2
4370703 2154575 2154575 defendant Frowde Geoffrey butcher 642586 642586 Frowde, Geoffrey, of Apledore, butcher 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);