names

21 rows where place_id = 586327

✎ 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
3588442 1864034 1864034 defendant Netylton Robert yeoman 586327 586327 Netylton, Robert, of Camberwell, Surrey, yeoman 1
3615458 1872476 1872476 defendant Wylly Walter clerk 586327 586327 Wylly, Walter, of Camberwell, Surrey, clerk 0
3823378 1965226 1965226 defendant Wyld Henry gent 586327 586327 Wyld, Henry, of Camberwell, Surrey, gent 1
3944086 2005040 2005040 defendant Bower or Bowyer John gent 586327 586327 Bower or Bowyer, John, of Camberwell, Surrey, or of Beere, Soms, gent 0
4147467 2077255 2077255 defendant Awberye William gent 586327 586327 Awberye, William, of Camberwell, Surrey, gent 1
4243577 2110838 2110838 defendant Isam Edward   586327 586327 Isam, Edward, of Camberwell, Surrey, gent, son of Henry Isam 0
4253937 2114314 2114314 defendant Isam Edward   586327 586327 Isam, Edward, of Camberwell, Surrey, son of Henry Isam 0
4322077 2137801 2137801 defendant Rogers Andrew esq 586327 586327 Rogers, Andrew, of Camberwell, Surrey, esq 0
4357982 2150034 2150034 defendant Gemyte George brewer 586327 586327 Gemyte, George, of Camberwell, Surrey, brewer 1
4361157 2151154 2151154 defendant Smytheson Elizabeth widow 586327 586327 Elizabeth his wife, alias Elizabeth Daunce, of Camberwell, Surrey, widow 1
4370922 2154655 2154655 defendant Jemmett George yeoman 586327 586327 Jemmett, George, of Camberwell, Surrey, yeoman 2
4372342 2155174 2155174 defendant Mortymer George gent 586327 586327 Mortymer, George, of Camberwell, Surrey, gent 0
4377296 2156955 2156955 defendant Mortymer George gent 586327 586327 Mortymer, George, of Camberwell, Surrey, gent 0
4382375 2158806 2158806 defendant Gemyte George brewer 586327 586327 Gemyte, George, of Camberwell, Surrey, brewer 1
4398725 2164153 2164153 defendant Jemmett George tailor 586327 586327 Jemmett, George, of Camberwell, Surrey, yeoman, tailor 2
4857469 2313724 2313724 defendant Breten John esq 586327 586327 Breten, John, of Camberwell, Surrey, esq 1
5087397 2382695 2382695 defendant Godeston Elias husbandman 586327 586327 Godeston, Elias, of Camberwell, Surrey, husbandman 3
5179249 2409670 2409670 defendant Sutton Robert yeoman 586327 586327 Sutton, Robert, of Camberwell, Surrey, yeoman 1
5242293 2427949 2427949 defendant Clophman Alan husbandman 586327 586327 Clophman, Alan, of Camberwell, Surrey, husbandman 4
5255244 2431756 2431756 defendant Forstall Thomas yeoman 586327 586327 Forstall, Thomas, of Camberwell, Surrey, yeoman 0
5290451 2442212 2442212 defendant Wylson Robert husbandman 586327 586327 Wylson, Robert, of Camberwell, Surrey, husbandman 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);