names

49 rows where place_id = 590382

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601008 1867981 1867981 defendant Clough John yeoman 590382 590382 Clough, John, of Gosberton, yeoman 0
3613000 1871713 1871713 defendant Alger Richard husbandman 590382 590382 Alger, Richard, of Gosberton, husbandman 0
3618980 1873548 1873548 defendant Leman Thomas husbandman 590382 590382 Leman, Thomas, of Gosberton, husbandman 1
3620672 1874043 1874043 defendant Austen John husbandman 590382 590382 Austen, John, of Gosberton, husbandman 0
3676548 1918708 1918708 defendant Dowson George laborer 590382 590382 Dowson, George, of Gosberton, laborer 3
3732829 1936496 1936496 defendant Smyth William, senior husbandman 590382 590382 Smyth, William, senior, of Gosberton, husbandman 0
3736427 1937637 1937637 defendant Cleveland William draper 590382 590382 (Cleveland, William,of Gosberton, draper 3
3782732 1952343 1952343 plaintiff Irby Anthony gent 590382 590382 Irby, Anthony, of Gosberton, gent 0
3783257 1952516 1952516 defendant Harryman Nicholas   590382 590382 Harryman, Nicholas, of Gosberton, salt weller 1
3788281 1954131 1954131 defendant Dethe Robert yeoman 590382 590382 Dethe, Robert, of Gosberton, yeoman 0
3788282 1954131 1954131 defendant Thakker William, junior yeoman 590382 590382 Thakker, William, junior, of Gosberton, yeoman 1
3799306 1957701 1957701 plaintiff Irby Anthony gent 590382 590382 Irby, Anthony, of Gosberton, gent 0
3899261 1989964 1989964 defendant Toft Thomas husbandman 590382 590382 Toft, Thomas, of Gosberton, husbandman 0
3905042 1991949 1991949 defendant Henyngham John, junior husbandman 590382 590382 Henyngham, John, junior, of Gosberton, husbandman 4
3946500 2005844 2005844 defendant Wardell William chapman 590382 590382 Wardell, William, of Gosberton, chapman 1
3957377 2009645 2009645 defendant Deathe John yeoman 590382 590382 Deathe, John, of Gosberton, yeoman 0
3981331 2018091 2018091 plaintiff Radley Robert   590382 590382 Radley, Robert, of Gosberton 0
3981332 2018091 2018091 defendant Hunnyngham Richard yeoman 590382 590382 Hunnyngham, Richard, of Gosberton, yeoman 0
3990960 2021529 2021529 defendant Naler Thomas husbandman 590382 590382 Naler, Thomas, of Gosberton, husbandman 1
3990962 2021529 2021529 defendant Treton Francis tailor 590382 590382 Treton, Francis, of Gosberton, tailor 3
3994729 2022868 2022868 defendant Deth John yeoman 590382 590382 Deth, John, of Gosberton, yeoman 0
3994731 2022869 2022869 defendant Deth John yeoman 590382 590382 Deth, John, of Gosberton, yeoman 0
3996894 2023655 2023655 defendant Deth John yeoman 590382 590382 Deth, John, of Gosberton, yeoman 1
4012371 2029145 2029145 defendant Deth Henry yeoman 590382 590382 Deth, Henry, of Gosberton, yeoman 2
4016972 2030772 2030772 defendant Death John yeoman 590382 590382 Death, John, of Gosberton, yeoman 0
4059108 2045655 2045655 defendant Deathe Roger yeoman 590382 590382 Deathe, Roger, of Gosberton, yeoman 1
4064935 2047744 2047744 defendant Deathe Roger yeoman 590382 590382 Deathe, Roger, of Gosberton, yeoman 0
4070907 2049894 2049894 defendant Deathe John yeoman 590382 590382 Deathe, John, of Gosberton, yeoman 0
4134251 2072575 2072575 defendant Harryson Percival yeoman 590382 590382 Harryson, Percival, of Gosberton, yeoman 1
4139061 2074340 2074340 defendant Pratt Robert husbandman 590382 590382 Pratt, Robert, of Gosberton, husbandman 1
4158199 2080937 2080937 defendant Harryson Percival yeoman 590382 590382 Harryson, Percival, of Gosberton, yeoman 1
4170103 2085037 2085037 defendant Bartell Richard husbandman 590382 590382 Bartell, Richard, of Gosberton, husbandman 0
4175439 2086880 2086880 defendant Cheale William butcher 590382 590382 Cheale, William, of Gosberton, butcher 0
4175440 2086880 2086880 defendant Cheale Thomas butcher 590382 590382 Cheale, Thomas, of Gosberton, butcher 1
4175441 2086880 2086880 defendant Brewster John yeoman 590382 590382 Brewster, John, of Gosberton, yeoman 2
4198708 2095108 2095108 defendant Cheale William butcher 590382 590382 Cheale, William, of Gosberton, butcher 0
4198709 2095108 2095108 defendant Cheale Thomas butcher 590382 590382 Cheale, Thomas, of Gosberton, butcher 1
4198710 2095108 2095108 defendant Brewster John yeoman 590382 590382 Brewster, John, of Gosberton, yeoman 2
4199781 2095473 2095473 defendant Bolles Richard gent 590382 590382 Bolles, Richard, of Gosberton, gent 3
4234231 2107509 2107509 defendant Hunningam George miller 590382 590382 Hunningam, George, of Gosberton, miller 0
4235627 2108029 2108029 defendant Tompson John yeoman 590382 590382 Tompson, John, of Gosberton, yeoman 3
4239533 2109452 2109452 defendant Hunningam George miller 590382 590382 Hunningam, George, of Gosberton, miller 0
5338464 2456602 2456602 defendant Laceband Nicholas tailor 590382 590382 Laceband, Nicholas, of Gosberton, tailor 0
5406276 2476866 2476866 defendant Brunswyn Thomas (legal representative) 590382 590382 Brunswyn, Thomas, of Gosberton, husbandman, executors of 0
5454231 2491172 2491172 defendant Batsbold John   590382 590382 Batsbold, John, of Gosberton 0
5502521 2505707 2505707 defendant Taillour Richard shoemaker 590382 590382 Taillour, Richard, of Gosberton, shoemaker 2
5543047 2517942 2517942 defendant Nutkyn Richard laborer 590382 590382 Nutkyn, Richard, of Gosberton, laborer 0
5558227 2522355 2522355 defendant Reme William husbandman 590382 590382 Reme, William, of Gosberton, husbandman 0
5558228 2522355 2522355 defendant Reme John laborer 590382 590382 Reme, John, of Gosberton, laborer 1

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