names

42 rows where place_id = 599400

✎ 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
3636608 1906241 1906241 defendant Breton John merchant 599400 599400 Breton, John, of Hadlegh, Suff, merchant 0
3713110 1930417 1930417 defendant Quyntyn John clothier 599400 599400 Quyntyn, John, of Hadlegh, Suff, clothier 0
3797667 1957166 1957166 defendant Brett Stephen clothmaker 599400 599400 Brett, Stephen, of Hadlegh, Suff, clothmaker 0
3868065 1979553 1979553 defendant Freman Edward yeoman 599400 599400 Freman, Edward, of Hadlegh, Suff, yeoman 0
3968293 2013539 2013539 defendant Mycklefeld Robert yeoman 599400 599400 Mycklefeld, Robert, of Hadlegh, Suff, yeoman 0
4126056 2069605 2069605 defendant Batley Adam clothier 599400 599400 Batley, Adam, of Hadlegh, Suff, clothier 1
4490170 2197643 2197643 defendant Kempston John   599400 599400 Kempston, John, of Hadlegh, Suff 2
4490197 2197644 2197644 defendant Kempston John   599400 599400 Kempston, John, of Hadlegh, Suff 2
4536372 2211659 2211659 defendant Greyne Thomas   599400 599400 Greyne, Thomas, of Hadlegh, Suff 1
4538217 2212240 2212240 plaintiff Tiryngton Henry   599400 599400 Tiryngton, Henry, of Hadlegh, Suff 0
4655978 2247748 2247748 defendant Dunton Richard chapman 599400 599400 Dunton, Richard, of Hadlegh, Suff, chapman 0
4662185 2249647 2249647 defendant Man John chandler 599400 599400 Man, John, of Hadlegh, Suff, chandler 0
4663440 2250040 2250040 defendant Wrenne Henry yeoman 599400 599400 Wrenne, Henry, of Hadlegh, Suff, yeoman 0
4674401 2257605 2257605 plaintiff Dunton Isabel   599400 599400 Dunton, Isabel, of Hadlegh, Suff 0
4734546 2275972 2275972 defendant Spyllyng John chapman 599400 599400 Spyllyng, John, of Hadlegh, Suff, chapman 3
4751216 2280833 2280833 defendant Cooke Robert chapman 599400 599400 Cooke, Robert, of Hadlegh, Suff, chapman 0
4878175 2320125 2320125 defendant Talbot Roger draper 599400 599400 Talbot, Roger, of Hadlegh, Suff, draper 0
4903458 2327689 2327689 defendant Lyon John chapman 599400 599400 Lyon, John, of Hadlegh, Suff, chapman 2
4919367 2332569 2332569 plaintiff Wade Thomas   599400 599400 Wade, Thomas, of Hadlegh, Suff 1
4924444 2334083 2334083 defendant Richemond Thomas fuller 599400 599400 Richemond, Thomas, of Hadlegh, Suff, fuller 0
4945557 2340588 2340588 defendant Roo William mercer 599400 599400 Roo, William, of Hadlegh, Suff, mercer 0
5017432 2361987 2361987 defendant Forthe William draper 599400 599400 Forthe, William, of Hadlegh, Suff, draper 1
5053214 2372562 2372562 defendant Talbot Roger yeoman 599400 599400 Talbot, Roger, of Hadlegh, Suff, yeoman 0
5095192 2385009 2385009 defendant Bendssh John esq 599400 599400 Bendssh, John, of Hadlegh, Suff, esq 0
5111394 2389724 2389724 defendant Wode Richard husbandman 599400 599400 Wode, Richard, of Hadlegh, Suff, husbandman 0
5138558 2397775 2397775 defendant Dunton William gent 599400 599400 Dunton, William, of Hadlegh, Suff, gent 0
5138562 2397776 2397776 defendant Dunton William gent 599400 599400 Dunton, William, of Hadlegh, Suff, gent 0
5187164 2411971 2411971 defendant Hameryngale Thomas yeoman 599400 599400 Hameryngale, Thomas, of Hadlegh, Suff, yeoman 0
5230238 2424463 2424463 defendant Bolyngton Roger husbandman 599400 599400 Bolyngton, Roger, of Hadlegh, Suff, husbandman 0
5239429 2427113 2427113 defendant Monnyng John clothmaker 599400 599400 Monnyng, John, of Hadlegh, Suff, clothmaker 0
5243065 2428176 2428176 defendant Baron John chapman 599400 599400 Baron, John, of Hadlegh, Suff, chapman 0
5302793 2445818 2445818 defendant Bager Thomas gent 599400 599400 Bager, Thomas, of Hadlegh, Suff, gent 0
5310962 2448316 2448316 defendant Goos Walter chaplain 599400 599400 Goos, Walter, of Hadlegh, Suff, chaplain 1
5352703 2460935 2460935 plaintiff Forde William clothman 599400 599400 Forde, William, of Hadlegh, Suff, clothman 0
5460306 2493020 2493020 defendant Bechom John merchant 599400 599400 Bechom, John, of Hadlegh, Suff, merchant 0
5485875 2500668 2500668 defendant Cokke Richard clothmaker 599400 599400 Cokke, Richard, of Hadlegh, Suff, clothmaker 0
5496139 2503743 2503743 plaintiff Hoxon Richard   599400 599400 Hoxon, Richard, of Hadlegh, Suff, gent, administrators of 0
5496145 2503744 2503744 plaintiff Hoxon Richard   599400 599400 Hoxon, Richard, of Hadlegh, Suff, gent, administrators of 0
5506620 2506983 2506983 defendant Wylymot alias Spycer John husbandman 599400 599400 Wylymot alias Spycer, John, of Hadlegh, Suff, husbandman 2
5528189 2513380 2513380 defendant Baron John yeoman 599400 599400 Baron, John, of Hadlegh, Suff, yeoman 0
5563361 2523880 2523880 defendant Cristmas Thomas clothmaker 599400 599400 Cristmas, Thomas, of Hadlegh, Suff, clothmaker 1
5630864 2553661 2553661 plaintiff Semere Richard   599400 599400 Semere, Richard, of Hadlegh, Suff 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);