names

46 rows where place_id = 608584

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3646316 1909239 1909239 defendant Gryffyn John   608584 608584 Gryffyn, John, of Barnyngham, notary 0
3674336 1918018 1918018 defendant Frent John tiler 608584 608584 Frent, John, of Barnyngham, tiler 0
3674337 1918018 1918018 defendant Agas John yeoman 608584 608584 Agas, John, of Barnyngham, yeoman 1
3685140 1921501 1921501 defendant Frent John, junior husbandman 608584 608584 Frent, John, junior, of Barnyngham, husbandman 0
3685141 1921501 1921501 defendant Baldry Robert laborer 608584 608584 Baldry, Robert, of Barnyngham, laborer 1
3708652 1929005 1929005 defendant Frent John husbandman 608584 608584 Frent, John, of Barnyngham, husbandman 0
3708654 1929006 1929006 defendant Frent John husbandman 608584 608584 Frent, John, of Barnyngham, husbandman 0
3732667 1936448 1936448 defendant Frent John yeoman 608584 608584 Frent, John, of Barnyngham, yeoman 4
3732668 1936448 1936448 defendant Hamelyn Clerys widow 608584 608584 Hamelyn, Clerys, of Barnyngham, widow 5
3732942 1936526 1936526 defendant Gyllam Robert husbandman 608584 608584 Gyllam, Robert, of Barnyngham, husbandman 3
3735692 1937398 1937398 defendant Frent John husbandman 608584 608584 Frent, John, of Barnyngham, husbandman 0
3748328 1941407 1941407 defendant Frent John tiler 608584 608584 Frent, John, of Barnyngham, tiler 0
3750973 1942230 1942230 defendant Carter William chaplain 608584 608584 Carter, William, of Barnyngham, chaplain 0
3763106 1946093 1946093 defendant Onge Thomas butcher 608584 608584 Onge, Thomas, of Barnyngham, butcher 0
3767932 1947607 1947607 defendant Frent John, junior yeoman 608584 608584 Frent, John, junior, of Barnyngham, yeoman 0
3770864 1948574 1948574 defendant Onge Walter husbandman 608584 608584 Onge, Walter, of Barnyngham, husbandman 3
3770865 1948574 1948574 defendant Hamlyn Thomas husbandman 608584 608584 Hamlyn, Thomas, of Barnyngham, husbandman 4
3776944 1950532 1950532 defendant Parken Thomas laborer 608584 608584 Parken, Thomas, of Barnyngham, laborer 1
3784301 1952880 1952880 defendant Odyham John clerk 608584 608584 Odyham, John, of Barnyngham, clerk 2
3785648 1953301 1953301 defendant Frent John, junior yeoman 608584 608584 Frent, John, junior, of Barnyngham, yeoman 0
3789235 1954451 1954451 defendant Bakon John husbandman 608584 608584 Bakon, John, of Barnyngham, husbandman 1
3826203 1966041 1966041 defendant Wynter Henry esq 608584 608584 Wynter, Henry, of Barnyngham, esq 0
3828083 1966651 1966651 defendant Couper Thomas husbandman 608584 608584 Couper, Thomas, of Barnyngham, husbandman 1
3873808 1981460 1981460 defendant Walor Richard butcher 608584 608584 Walor, Richard,of Barnyngham, butcher 1
3893965 1988204 1988204 defendant Smyth William husbandman 608584 608584 Smyth, William, of Barnyngham, husbandman 3
3908231 1993051 1993051 defendant Smyth William husbandman 608584 608584 Smyth, William, of Barnyngham, husbandman 2
3916717 1995960 1995960 plaintiff Frent John yeoman 608584 608584 Frent, John, of Barnyngham, yeoman 0
3963483 2011833 2011833 defendant Smyth John husbandman 608584 608584 Smyth, John, of Barnyngham, husbandman 1
3968877 2013743 2013743 plaintiff Coke Richard   608584 608584 Coke, Richard, of Barnyngham, wool chapman 0
4003399 2025978 2025978 defendant Wyggon George husbandman 608584 608584 Wyggon, George, of Barnyngham, husbandman 0
4004909 2026538 2026538 plaintiff Joye John   608584 608584 Joye, John, of Barnyngham 0
4220052 2102513 2102513 defendant Bacon William gent 608584 608584 Bacon, William, of Barnyngham, gent 0
4256596 2115176 2115176 defendant Cooke William yeoman 608584 608584 Cooke, William, of Barnyngham, yeoman 3
4913472 2330710 2330710 defendant atte Gate Elizabeth   608584 608584 atte Gate, Elizabeth, of Barnyngham, gentle woman 0
5112102 2389923 2389923 defendant Ratclyff or Radclyff Robert gent 608584 608584 Ratclyff or Radclyff, Robert, of Barnyngham, gent 1
5373866 2467422 2467422 defendant Messyngere Thomas clerk 608584 608584 Messyngere, Thomas, of Barnyngham, clerk 0
5388498 2471762 2471762 defendant Messynger Thomas clerk 608584 608584 Messynger, Thomas, of Barnyngham, clerk 0
5491080 2502231 2502231 defendant Cook Reginald husbandman 608584 608584 Cook, Reginald, of Barnyngham, husbandman 0
5499033 2504646 2504646 defendant Barny- Thomas gent 608584 608584 Barny-, Thomas, of Barnyngham, gent 1
5499036 2504647 2504647 defendant Barnyngham Thomas gent 608584 608584 Barnyngham, Thomas, of Barnyngham, gent 1
5499039 2504648 2504648 defendant Barnyngham Thomas gent 608584 608584 Barnyngham, Thomas, of Barnyngham, gent 1
5573571 2526836 2526836 defendant Agas John husbandman 608584 608584 Agas, John, of Barnyngham, husbandman 0
5580791 2529071 2529071 defendant Gryffyn Richard yeoman 608584 608584 Gryffyn, Richard, of Barnyngham, yeoman 0
5586141 2530706 2530706 defendant Agas John husbandman 608584 608584 Agas, John, of Barnyngham, husbandman 0
5598204 2534328 2534328 defendant Agas John husbandman 608584 608584 Agas, John, of Barnyngham, husbandman 0
5604220 2536181 2536181 defendant Gryffyn John yeoman 608584 608584 Gryffyn, John, of Barnyngham, yeoman 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);