names

21 rows where place_id = 637243

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3835275 1968972 1968972 defendant Besant John yeoman 637243 637243 Besant, John, of Bere Regis, yeoman 2
3841545 1970937 1970937 defendant Langford Geoffrey smith 637243 637243 Langford, Geoffrey, of Bere Regis, smith 1
3878327 1982998 1982998 defendant Besant John husbandman 637243 637243 Besant, John, of Bere Regis, husbandman 0
3974502 2015660 2015660 defendant Luckes Richard mercer 637243 637243 Luckes, Richard, of Bere Regis, mercer 0
4018101 2031193 2031193 defendant Spere John mercer 637243 637243 Spere, John, of Bere Regis, mercer 0
4018103 2031194 2031194 defendant Zouche Charles esq 637243 637243 Zouche, Charles, of Bere Regis, esq 0
4018115 2031200 2031200 plaintiff Turbervyle Thomas esq 637243 637243 Turbervyle, Thomas, of Bere Regis, esq 0
4035053 2037220 2037220 defendant Zouche Charles gent 637243 637243 Zouche, Charles, of Bere Regis, gent 0
4035057 2037221 2037221 defendant Zouche Charles gent 637243 637243 Zouche, Charles, of Bere Regis, gent 0
4047901 2041695 2041695 defendant Rogers William yeoman 637243 637243 Rogers, William, of Bere Regis, yeoman 0
4064423 2047556 2047556 defendant Michell Richard yeoman 637243 637243 Michell, Richard, of Bere Regis, yeoman 1
4128573 2070509 2070509 defendant Turbervyle Thomas esq 637243 637243 Turbervyle, Thomas, of Bere Regis, esq 0
4227605 2105141 2105141 defendant Gardener Thomas shoemaker 637243 637243 Gardener, Thomas, of Bere Regis, shoemaker 0
4253432 2114139 2114139 defendant Faulkner Thomas yeoman 637243 637243 Faulkner, Thomas, of Bere Regis, yeoman 0
4269977 2119542 2119542 defendant Banger Richard husbandman 637243 637243 Banger, Richard, of Bere Regis, husbandman 0
4291592 2127071 2127071 defendant Levett John yeoman 637243 637243 Levett, John, of Bere Regis, yeoman 1
4308394 2133090 2133090 defendant Levett John butcher 637243 637243 Levett, John, of Bere Regis, butcher 0
4364161 2152238 2152238 defendant Bastarde Thomas clerk 637243 637243 Bastarde, Thomas, of Bere Regis, clerk 0
4406129 2166614 2166614 defendant Moggaridge Henry yeoman 637243 637243 Moggaridge, Henry, of Bere Regis, yeoman 3
5560703 2523097 2523097 defendant Whyte John yeoman 637243 637243 Whyte, John, of Bere Regis, yeoman 0
5606695 2536973 2536973 defendant Turbervile John esq 637243 637243 Turbervile, John, of Bere Regis, esq 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);