names

33 rows where place_id = 595259

✎ 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
3619703 1873732 1873732 defendant Broun James clothier 595259 595259 Broun, James, of Benynden, Kent, clothier 0
3670225 1916634 1916634 defendant Fowlle John clothier 595259 595259 Fowlle, John, of Benynden, Kent, clothier 1
3674674 1918128 1918128 defendant Holbard William dyer 595259 595259 Holbard, William, of Benynden, Kent, dyer 5
3726792 1934648 1934648 defendant Morleyn John butcher 595259 595259 Morleyn, John, of Benynden, Kent, butcher 0
3816713 1963133 1963133 defendant Babbe Richard clothier 595259 595259 Babbe, Richard, of Benynden, Kent, clothier 0
3820974 1964455 1964455 defendant Ledys Thomas clothmaker 595259 595259 Ledys, Thomas, of Benynden, Kent, clothmaker 0
3832655 1968138 1968138 defendant Fowle William clothier 595259 595259 Fowle, William, of Benynden, Kent, clothier 2
3838598 1969999 1969999 defendant Lede Edward yeoman 595259 595259 Lede, Edward, of Benynden, Kent, yeoman 0
3864856 1978447 1978447 defendant Wryggar William clothier 595259 595259 Wryggar, William, of Benynden, Kent, clothier 0
3879110 1983263 1983263 defendant Glover Alice widow 595259 595259 Glover, Alice, of Benynden, Kent, widow 4
3891355 1987374 1987374 defendant Merden Joan widow 595259 595259 Merden, Joan, of Benynden, Kent, widow 5
3899268 1989966 1989966 defendant Ramesden John clothier 595259 595259 Ramesden, John, of Benynden, Kent, clothier 1
3910314 1993767 1993767 defendant Ramsden John clothmaker 595259 595259 Ramsden, John, of Benynden, Kent, clothmaker 0
3944952 2005329 2005329 defendant Rade John yeoman 595259 595259 Rade, John, of Benynden, Kent, yeoman 0
4007762 2027560 2027560 defendant Burges John tanner 595259 595259 Burges, John, of Benynden, Kent, tanner 0
4816278 2301175 2301175 defendant Brenchesle John dyer 595259 595259 Brenchesle, John, of Benynden, Kent, dyer 0
4816280 2301176 2301176 defendant Brenchesle John woder or wood man 595259 595259 Brenchesle, John, of Benynden, Kent, woder or wood man 0
4816282 2301177 2301177 defendant Brenchesle John dyer 595259 595259 Brenchesle, John, of Benynden, Kent, dyer 0
5033301 2366618 2366618 defendant Baret William butcher 595259 595259 Baret, William, of Benynden, Kent, butcher 1
5033307 2366619 2366619 defendant Baret William butcher 595259 595259 Baret, William, of Benynden, Kent, butcher 1
5033567 2366702 2366702 defendant Bryncheley Robert gent 595259 595259 Bryncheley, Robert, of Benynden, Kent, gent 0
5102112 2387043 2387043 defendant Brenchesley Walter gent 595259 595259 Brenchesley, Walter, of Benynden, Kent, gent 0
5102114 2387044 2387044 defendant Brynchisle Walter gent 595259 595259 Brynchisle, Walter, of Benynden, Kent, gent 0
5230935 2424656 2424656 defendant Brenchesle Walter (legal representative) 595259 595259 Brenchesle, Walter, of Benynden, Kent, gent, executrix of 0
5249843 2430066 2430066 defendant Willard John, junior yeoman 595259 595259 Willard, John, junior, of Benynden, Kent, yeoman 1
5251201 2430479 2430479 defendant Willard John, junior yeoman 595259 595259 Willard, John, junior, of Benynden, Kent, yeoman 1
5321597 2451547 2451547 defendant Brenchesle John (legal representative) 595259 595259 Brenchesle, John, of Benynden, Kent, gent, executor of 2
5433783 2485072 2485072 defendant Goldyng Edward mercer 595259 595259 Goldyng, Edward, of Benynden, Kent, mercer 1
5462037 2493540 2493540 defendant Lede William husbandman 595259 595259 Lede, William, of Benynden, Kent, husbandman 1
5543302 2518022 2518022 defendant Higges alias Hoggens William clothmaker 595259 595259 Higges alias Hoggens, William, of Benynden, Kent, clothmaker 1
5543307 2518023 2518023 defendant Hogges or Hoggens William clothmaker 595259 595259 Hogges or Hoggens, William, of Benynden, Kent, clothmaker 1
5577740 2528107 2528107 defendant More Thomas gent 595259 595259 More, Thomas, of Benynden, Kent, gent 2
5625672 2551972 2551972 defendant Robyn Robert   595259 595259 Robyn, Robert, of Benynden, Kent 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);