names

60 rows where place_id = 653177

✎ 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
3662791 1914281 1914281 defendant Johnson Lawrence   653177 653177 Johnson, Lawrence, of Brandon Ferry, inn holder 2
3927068 1999392 1999392 defendant Hooke Hugh   653177 653177 Hooke, Hugh, of Brandon Ferry, inn holder 1
3927529 1999550 1999550 defendant Atmere Edmund yeoman 653177 653177 Atmere, Edmund, of Brandon Ferry, yeoman 0
3932732 2001247 2001247 defendant Hooke Hugh   653177 653177 Hooke, Hugh, of Brandon Ferry, inn holder 1
3937735 2002953 2002953 defendant Hooke Hugo   653177 653177 Hooke, Hugo, of Brandon Ferry, inn holder 1
3941000 2003996 2003996 plaintiff Taverham Robert   653177 653177 Taverham, Robert, of Brandon Ferry 0
4132510 2071943 2071943 defendant Marchant Robert butcher 653177 653177 Marchant, Robert, of Brandon Ferry, butcher 0
4184785 2090187 2090187 defendant Watt Arthur yeoman 653177 653177 Watt, Arthur, of Brandon Ferry, yeoman 0
4239172 2109326 2109326 defendant Dalton Robert yeoman 653177 653177 Dalton, Robert, of Brandon Ferry, or of Bury St Edmunds, yeoman 0
4259416 2116124 2116124 defendant Semys John clerk 653177 653177 Semys, John, of Brandon Ferry, clerk 0
4282984 2123952 2123952 defendant Wade John yeoman 653177 653177 Wade, John, of Brandon Ferry, yeoman 0
4307109 2132622 2132622 defendant Senys John clerk 653177 653177 Senys, John, of Brandon Ferry, clerk 0
4341215 2144198 2144198 defendant Ashwell Ambrose yeoman 653177 653177 Ashwell, Ambrose, of Brandon Ferry, yeoman 0
4408283 2167340 2167340 defendant Legge Simon glover 653177 653177 Legge, Simon, of Brandon Ferry, glover 0
4442233 2182502 2182502 defendant Honyng John   653177 653177 Honyng, John, of Brandon Ferry 0
4444210 2183170 2183170 plaintiff Clerkes Mariota   653177 653177 Clerkes, Mariota, of Brandon Ferry, formerly wife of Stephen 0
4463368 2189233 2189233 plaintiff Tudenham William master & parson 653177 653177 Tudenham, William, of Brandon Ferry, master & parson 0
4463370 2189234 2189234 plaintiff Tudenham William master & parson 653177 653177 Tudenham, William, of Brandon Ferry, master & parson 0
4548111 2215349 2215349 defendant Gebon Alice   653177 653177 Gebon, Alice, of Brandon Ferry 3
4612052 2234834 2234834 defendant Lakynghith Alan   653177 653177 Lakynghith, Alan, of Brandon Ferry 1
4719259 2271370 2271370 defendant Goos Thomas tanner 653177 653177 Goos, Thomas, of Brandon Ferry, tanner 0
4758547 2283052 2283052 defendant Gebon Richard   653177 653177 Gebon, Richard, of Brandon Ferry 0
4758663 2283081 2283081 defendant Noteman Richard   653177 653177 Noteman, Richard, of Brandon Ferry 30
4758680 2283082 2283082 defendant Noteman Richard   653177 653177 Noteman, Richard, of Brandon Ferry 7
4758719 2283083 2283083 defendant Noteman Richard yeoman 653177 653177 Noteman, Richard, of Brandon Ferry, yeoman 29
4768489 2286119 2286119 defendant Lakynghythe Alan husbandman 653177 653177 Lakynghythe, Alan, of Brandon Ferry, husbandman 1
4769817 2286536 2286536 defendant Lakynghithe Alan husbandman 653177 653177 Lakynghithe, Alan, of Brandon Ferry, husbandman 0
4812344 2299975 2299975 defendant Bunt Geoffrey husbandman 653177 653177 Bunt, Geoffrey, of Brandon Ferry, husbandman 0
4826021 2304175 2304175 defendant Bunt Goeffrey ostler 653177 653177 Bunt, Goeffrey, of Brandon Ferry, ostler 0
4837916 2307784 2307784 defendant Archer John husbandman 653177 653177 Archer, John, of Brandon Ferry, husbandman 0
4842632 2309232 2309232 plaintiff Lom Thomas   653177 653177 Lom, Thomas, of Brandon Ferry 0
4922138 2333336 2333336 plaintiff Lem Thomas   653177 653177 Lem, Thomas, of Brandon Ferry 0
4990592 2354097 2354097 plaintiff Chaundeler Richard   653177 653177 Chaundeler, Richard, of Brandon Ferry 0
4990593 2354097 2354097 defendant Lems Thomas baker 653177 653177 Lems, Thomas, of Brandon Ferry, baker 0
4999049 2356595 2356595 plaintiff Lakyng Hythe Joan   653177 653177 Lakyng Hythe, Joan, of Brandon Ferry, formerly wife Alan 0
4999050 2356595 2356595 plaintiff Whetelee Roger   653177 653177 Whetelee, Roger, of Brandon Ferry 1
4999058 2356597 2356597 plaintiff Whetele Robert   653177 653177 Whetele, Robert, of Brandon Ferry 1
5045659 2370335 2370335 defendant Swaston Thomas husbandman 653177 653177 Swaston, Thomas, of Brandon Ferry, husbandman 0
5045660 2370335 2370335 defendant Bryde John butcher 653177 653177 Bryde, John, of Brandon Ferry, butcher 1
5179456 2409726 2409726 defendant Elyngham John husbandman 653177 653177 Elyngham, John, of Brandon Ferry, husbandman 0
5193624 2413861 2413861 plaintiff Pepyr John yeoman 653177 653177 Pepyr, John, of Brandon Ferry, yeoman 0
5193625 2413861 2413861 defendant Bateman Robert butcher 653177 653177 Bateman, Robert, of Brandon Ferry, butcher 0
5199905 2415724 2415724 defendant Bonyfaunt Edmund waterman 653177 653177 Bonyfaunt, Edmund, of Brandon Ferry, waterman 1
5199906 2415724 2415724 defendant Myot Robert weaver 653177 653177 Myot, Robert, of Brandon Ferry, weaver 2
5201892 2416318 2416318 defendant Lewe John yeoman 653177 653177 Lewe, John, of Brandon Ferry, yeoman 1
5364220 2464467 2464467 defendant George Roger   653177 653177 George, Roger, of Brandon Ferry, inn holder 0
5368027 2465623 2465623 defendant Heylok Cornelius yeoman 653177 653177 Heylok, Cornelius, of Brandon Ferry, yeoman 0
5368028 2465623 2465623 defendant Galeon Robert   653177 653177 Galeon, Robert, of Brandon Ferry, shoe maker 1
5369018 2465901 2465901 defendant Jorge Roger   653177 653177 Jorge, Roger, of Brandon Ferry, inn holder 0
5412412 2478659 2478659 defendant George Roger yeoman 653177 653177 George, Roger, of Brandon Ferry, yeoman 0
5427463 2483163 2483163 defendant Saundres John husbandman 653177 653177 Saundres, John, of Brandon Ferry, husbandman 1
5427464 2483163 2483163 defendant George Robert warrener 653177 653177 George, Robert, of Brandon Ferry, warrener 2
5438831 2486534 2486534 plaintiff George Roger   653177 653177 George, Roger, of Brandon Ferry 1
5445204 2488457 2488457 defendant George Robert warrener 653177 653177 George, Robert, of Brandon Ferry, warrener 2
5452455 2490609 2490609 defendant Edward John yeoman 653177 653177 Edward, John, of Brandon Ferry, yeoman 0
5457897 2492260 2492260 defendant Saundres John husbandman 653177 653177 Saundres, John, of Brandon Ferry, husbandman 1
5457898 2492260 2492260 defendant George Robert weaver 653177 653177 George, Robert, of Brandon Ferry, weaver 2
5469700 2495863 2495863 defendant Saundres John husbandman 653177 653177 Saundres, John, of Brandon Ferry, husbandman 1
5573210 2526717 2526717 defendant Martyn Richard husbandman 653177 653177 Martyn, Richard, of Brandon Ferry, husbandman 0
5629292 2553139 2553139 plaintiff Ram or Rain William   653177 653177 Ram or Rain, William, of Brandon Ferry 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);