names

32 rows where place_id = 602022

✎ 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
3648066 1909792 1909792 defendant Shemeld Christopher husbandman 602022 602022 Shemeld, Christopher, of Beghton, husbandman 1
3648077 1909792 1909792 defendant Treton John husbandman 602022 602022 Treton, John, of Beghton, husbandman 12
3666154 1915359 1915359 defendant Boswell John esq 602022 602022 Boswell, John, of Beghton, esq 0
3745036 1940355 1940355 defendant Sheffeld John yeoman 602022 602022 Sheffeld, John, of Beghton, yeoman 0
3745038 1940355 1940355 defendant Sheffeld Henry yeoman 602022 602022 Sheffeld, Henry, of Beghton, yeoman 2
4446401 2183791 2183791 plaintiff del Kirk John   602022 602022 del Kirk, John, of Beghton 0
4466571 2190222 2190222 defendant Syndell John   602022 602022 Syndell, John, of Beghton 1
4792243 2293661 2293661 defendant Chamburleyn Joan widow 602022 602022 Chamburleyn, Joan, of Beghton, widow 0
4792244 2293661 2293661 defendant Chambur John tailor 602022 602022 Chambur, John, of Beghton, tailor 1
4840677 2308625 2308625 defendant Whytyng John yeoman 602022 602022 Whytyng, John, of Beghton, yeoman 2
4963335 2345942 2345942 defendant Childerhous Stephen yeoman 602022 602022 Childerhous, Stephen, of Beghton, yeoman 0
4994556 2355236 2355236 defendant Roukesley Thomas   602022 602022 Roukesley, Thomas, of Beghton, parish clerk 0
5058661 2374152 2374152 defendant Cutte John yeoman 602022 602022 Cutte, John, of Beghton, yeoman 0
5115299 2390903 2390903 defendant Davy John husbandman 602022 602022 Davy, John, of Beghton, husbandman 0
5235378 2425928 2425928 defendant Cutte John yeoman 602022 602022 Cutte, John, of Beghton, yeoman 0
5270944 2436599 2436599 defendant Wylson Thomas yeoman 602022 602022 Wylson, Thomas, of Beghton, yeoman 0
5282390 2439911 2439911 defendant Boswell Richard gent 602022 602022 Boswell, Richard, of Beghton, gent 0
5282393 2439911 2439911 defendant Shemyld John husbandman 602022 602022 Shemyld, John, of Beghton, husbandman 3
5282394 2439911 2439911 defendant Alotte Richard husbandman 602022 602022 Alotte, Richard, of Beghton, husbandman 4
5282395 2439911 2439911 defendant Davy Robert husbandman 602022 602022 Davy, Robert, of Beghton, husbandman 5
5282396 2439911 2439911 defendant Norbern William husbandman 602022 602022 Norbern, William, of Beghton, husbandman 6
5306550 2446951 2446951 defendant Boswell Richard gent 602022 602022 Boswell, Richard, of Beghton, gent 0
5306553 2446951 2446951 defendant Shemyld John husbandman 602022 602022 Shemyld, John, of Beghton, husbandman 3
5306554 2446951 2446951 defendant Alotte Richard husbandman 602022 602022 Alotte, Richard, of Beghton, husbandman 4
5306555 2446951 2446951 defendant Davy Robert husbman 602022 602022 Davy, Robert, of Beghton, husbman 5
5306556 2446951 2446951 defendant Norbern William husbandman 602022 602022 Norbern, William, of Beghton, husbandman 6
5334661 2455434 2455434 defendant Holyne or Holyve John husbandman 602022 602022 Holyne or Holyve, John, of Beghton, husbandman 1
5342013 2457692 2457692 plaintiff Robert John (legal representative) 602022 602022 Robert, John, of Beghton, executor of 0
5342015 2457692 2457692 defendant Raulynson John yeoman 602022 602022 Raulynson, John, of Beghton, yeoman, son of Raulynson, William, of Beghton, yeoman 0
5381089 2469646 2469646 defendant Tynker John clerk 602022 602022 Tynker, John, of Beghton, clerk 0
5381091 2469647 2469647 defendant Tynker John clerk 602022 602022 Tynker, John, of Beghton, clerk 0
5538817 2516628 2516628 defendant Robert William laborer 602022 602022 Robert, William, of Beghton, laborer 4

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