names

23 rows where place_id = 604498

✎ 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
3658196 1912817 1912817 defendant Wilkys William husbandman 604498 604498 Wilkys, William, of Botesdale, Suff, husbandman 0
3814982 1962607 1962607 defendant Savage Stephen smith 604498 604498 Savage, Stephen, of Botesdale, Suff, smith 1
4089973 2056698 2056698 defendant Newporte Edmund butcher 604498 604498 Newporte, Edmund, of Botesdale, Suff, butcher 1
4255152 2114712 2114712 defendant Jesuppe Thomas   604498 604498 Jesuppe, Thomas, of Botesdale, Suff, woollen draper 3
4376627 2156709 2156709 defendant Collyn Silvester pedder 604498 604498 Collyn, Silvester, of Botesdale, Suff, pedder 0
4405779 2166502 2166502 defendant Collyn Silvester pedder or peddler 604498 604498 Collyn, Silvester, of Botesdale, Suff, pedder or peddler 0
4668292 2255797 2255797 defendant Breton John yeoman 604498 604498 Breton, John, of Botesdale, Suff, yeoman 0
4736156 2276443 2276443 defendant Lardyner John husbandman 604498 604498 Lardyner, John, of Botesdale, Suff, husbandman 4
4767731 2285887 2285887 defendant Hempman John yeoman 604498 604498 Hempman, John, of Botesdale, Suff, yeoman 0
4893895 2324792 2324792 defendant Fale John yeoman 604498 604498 Fale, John, of Botesdale, Suff, yeoman 0
4902512 2327402 2327402 defendant Fale John yeoman 604498 604498 Fale, John, of Botesdale, Suff, yeoman 0
4979171 2350726 2350726 defendant Norton John chapman 604498 604498 Norton, John, of Botesdale, Suff, chapman 5
5082293 2381195 2381195 defendant Wynter John courser 604498 604498 Wynter, John, of Botesdale, Suff, courser 1
5126248 2394162 2394162 defendant Ireland John husbandman 604498 604498 Ireland, John, of Botesdale, Suff, husbandman 0
5142370 2398890 2398890 defendant Heyrlond John husbandman 604498 604498 Heyrlond, John, of Botesdale, Suff, husbandman 2
5144920 2399663 2399663 defendant Ireland John husbandman 604498 604498 Ireland, John, of Botesdale, Suff, husbandman 0
5163625 2405098 2405098 defendant Heyrlond John husbandman 604498 604498 Heyrlond, John, of Botesdale, Suff, husbandman 2
5214289 2419912 2419912 defendant Anoure or Avoure Robert husbandman 604498 604498 Anoure or Avoure, Robert, of Botesdale, Suff, husbandman 2
5245946 2428976 2428976 defendant Hempman Thomas mercer 604498 604498 Hempman, Thomas, of Botesdale, Suff, mercer 0
5296578 2443987 2443987 defendant Mordok William yeoman 604498 604498 Mordok, William, of Botesdale, Suff, yeoman 3
5335934 2455816 2455816 defendant Crane Richard yeoman 604498 604498 Crane, Richard, of Botesdale, Suff, yeoman 1
5341813 2457633 2457633 defendant Hempnam Thomas yeoman 604498 604498 Hempnam, Thomas, of Botesdale, Suff, yeoman 4
5626431 2552237 2552237 defendant Hempman John mercer 604498 604498 Hempman, John, of Botesdale, Suff, mercer 2

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);