names

41 rows where place_id = 593520

✎ 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
3612212 1871460 1871460 defendant Gere Thomas sherman 593520 593520 Gere, Thomas, of Lyndfeld, sherman 0
3612213 1871460 1871460 defendant Gere John yeoman 593520 593520 Gere, John, of Lyndfeld, yeoman 1
3612214 1871460 1871460 defendant Gere William yeoman 593520 593520 Gere, William, of Lyndfeld, yeoman 2
3612215 1871460 1871460 defendant Underhyll Thomas laborer 593520 593520 Underhyll, Thomas, of Lyndfeld, laborer 3
3814111 1962316 1962316 defendant Bavys William carpenter 593520 593520 Bavys, William, of Lyndfeld, carpenter 0
3823650 1965295 1965295 defendant Turnour William miller 593520 593520 Turnour, William, of Lyndfeld, miller 0
3838809 1970064 1970064 defendant Barons John laborer 593520 593520 Barons, John, of Lyndfeld, laborer 5
3987935 2020431 2020431 defendant Shepard John husbandman 593520 593520 Shepard, John, of Lyndfeld, husbandman 0
3987937 2020432 2020432 defendant Shepard John husbandman 593520 593520 Shepard, John, of Lyndfeld, husbandman 0
3994766 2022879 2022879 defendant Collman Richard husbandman 593520 593520 Collman, Richard, of Lyndfeld, husbandman 2
4018390 2031310 2031310 defendant Uden Thomas yeoman 593520 593520 Uden, Thomas, of Lyndfeld, yeoman 0
4055705 2044427 2044427 defendant Gavis or Gabis alias Blackett Michael founder 593520 593520 Gavis or Gabis alias Blackett, Michael, of Lyndfeld, founder 1
4055706 2044427 2044427 defendant Ellys Robert shoemaker 593520 593520 Ellys, Robert, of Lyndfeld, shoemaker 2
4079878 2053102 2053102 defendant Verrall John miller 593520 593520 Verrall, John, of Lyndfeld, miller 0
4081201 2053585 2053585 defendant Gaston Martin husbandman 593520 593520 Gaston, Martin, of Lyndfeld, husbandman 0
4081202 2053585 2053585 defendant Gynner William yeoman 593520 593520 Gynner, William, of Lyndfeld, yeoman 1
4081203 2053586 2053586 plaintiff Whatman William (legal representative) 593520 593520 Whatman, William, of Lyndfeld, mercer, executors of 0
4106362 2062567 2062567 plaintiff Parden Gregory husbandman 593520 593520 Parden, Gregory, of Lyndfeld, husbandman 0
4107069 2062821 2062821 defendant Hode William husbandman 593520 593520 Hode, William, of Lyndfeld, husbandman 2
4116837 2066316 2066316 defendant Jenner William yeoman 593520 593520 Jenner, William, of Lyndfeld, yeoman 0
4119131 2067132 2067132 defendant Payne John husbandman 593520 593520 Payne, John, of Lyndfeld, husbandman 0
4123823 2068818 2068818 defendant Payne John yeoman 593520 593520 Payne, John, of Lyndfeld, yeoman 0
4123824 2068818 2068818 defendant Chatfeld John yeoman 593520 593520 Chatfeld, John, of Lyndfeld, yeoman 1
4129430 2070830 2070830 defendant Elgye Martin butcher 593520 593520 Elgye, Martin, of Lyndfeld, butcher 0
4130818 2071332 2071332 defendant Gere Thomas, junior husbandman 593520 593520 Gere, Thomas, junior, of Lyndfeld, husbandman 1
4132620 2071989 2071989 defendant Payne John yeoman 593520 593520 Payne, John, of Lyndfeld, yeoman 0
4132621 2071989 2071989 defendant Burstyre George carpenter 593520 593520 Burstyre, George, of Lyndfeld, carpenter 1
4132622 2071989 2071989 defendant Chrystyan Roland husbandman 593520 593520 Chrystyan, Roland, of Lyndfeld, husbandman 2
4147029 2077105 2077105 defendant Payne John yeoman 593520 593520 Payne, John, of Lyndfeld, yeoman 0
4175252 2086809 2086809 defendant Burstowe George carpenter 593520 593520 Burstowe, George, of Lyndfeld, carpenter 0
4179469 2088295 2088295 defendant Pexdene Stephen husbandman 593520 593520 Pexdene, Stephen, of Lyndfeld, husbandman 2
4184221 2089977 2089977 defendant Goldsmyth Hugh shoemaker 593520 593520 Goldsmyth, Hugh, of Lyndfeld, shoemaker 0
4318049 2136420 2136420 defendant Payne John husbandman 593520 593520 Payne, John, of Lyndfeld, husbandman 0
4361692 2151339 2151339 defendant Elgey Martin butcher 593520 593520 Elgey, Martin, of Lyndfeld, butcher 0
4371850 2154994 2154994 defendant Davyes Thomas   593520 593520 Davyes, Thomas, of Lyndfeld yeoman 2
4385049 2159689 2159689 defendant Stevens John tanner 593520 593520 Stevens, John, of Lyndfeld, tanner 1
5265400 2434935 2434935 defendant Britte Edward husbandman 593520 593520 Britte, Edward, of Lyndfeld, husbandman 1
5397844 2474454 2474454 defendant Marryn John weaver 593520 593520 Marryn, John, of Lyndfeld, weaver 0
5411007 2478246 2478246 defendant Martyn John weaver 593520 593520 Martyn, John, of Lyndfeld, weaver 0
5561042 2523199 2523199 plaintiff Chaloner John gent 593520 593520 Chaloner, John, of Lyndfeld, gent 2
5593080 2532819 2532819 defendant Bakshelf Henry husbandman 593520 593520 Bakshelf, Henry, of Lyndfeld, husbandman 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);