names

47 rows where place_id = 588241

✎ 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
3593818 1865706 1865706 defendant Feyth John husbandman 588241 588241 Feyth, John, of Pakefeld, Suff, husbandman 4
3613605 1871901 1871901 defendant Feyth John fisherman 588241 588241 Feyth, John, of Pakefeld, Suff, fisherman 0
3644105 1908586 1908586 defendant Yongys Robert husbandman 588241 588241 Yongys, Robert, of Pakefeld, Suff, husbandman 1
3663112 1914375 1914375 defendant More Nicholas yeoman 588241 588241 More, Nicholas, of Pakefeld, Suff, yeoman 0
3748468 1941454 1941454 defendant Brown Thomas mercer 588241 588241 Brown, Thomas, of Pakefeld, Suff, mercer 0
3794607 1956191 1956191 defendant Horsley George baker 588241 588241 Horsley, George, of Pakefeld, Suff, baker 3
3815014 1962616 1962616 defendant Broun Thomas mariner 588241 588241 Broun, Thomas, of Pakefeld, Suff, mariner 1
3820838 1964409 1964409 defendant Thomson William master of the Julyan of Leystoft 588241 588241 Thomson, William, of Pakefeld, Suff, mariner, master of the Julyan of Leystoft 0
3876198 1982285 1982285 defendant Ibbe John clerk 588241 588241 Ibbe, John, of Pakefeld, Suff, clerk 0
3935346 2002135 2002135 defendant Plowman George husbandman 588241 588241 Plowman, George, of Pakefeld, Suff, husbandman 0
3935966 2002345 2002345 defendant Dey Peter merchant 588241 588241 Dey, Peter, of Pakefeld, Suff, merchant 0
3936377 2002489 2002489 defendant Dey Peter merchant 588241 588241 Dey, Peter, of Pakefeld, Suff, merchant 1
4675160 2257843 2257843 defendant Brunham Hugh husbandman 588241 588241 Brunham, Hugh, of Pakefeld, Suff, husbandman 1
4920021 2332773 2332773 defendant Feyth Thomas shipman 588241 588241 Feyth, Thomas, of Pakefeld, Suff, shipman 0
4968899 2347661 2347661 defendant Neweman William chapman 588241 588241 Neweman, William, of Pakefeld, Suff, chapman 0
5025707 2364422 2364422 defendant Wren Adam mariner 588241 588241 Wren, Adam, of Pakefeld, Suff, mariner 1
5071945 2378098 2378098 defendant Bocher John husbandman 588241 588241 Bocher, John, of Pakefeld, Suff, husbandman 4
5092132 2384075 2384075 defendant Wrenne Adam yeoman 588241 588241 Wrenne, Adam, of Pakefeld, Suff, yeoman 3
5136145 2397084 2397084 plaintiff Neve John husbandman 588241 588241 Neve, John, of Pakefeld, Suff, husbandman 0
5170707 2407154 2407154 defendant Kemster Thomas   588241 588241 Kemster, Thomas, of Pakefeld, Suff, husbandman, administrators of 0
5170708 2407154 2407154 defendant Bonde Warren husbandman 588241 588241 (Bonde, Warren, of Pakefeld, Suff, husbandman 1
5196748 2414797 2414797 defendant Bonde Warren husbandman 588241 588241 (Bonde, Warren, of Pakefeld, Suff, husbandman 1
5276855 2438314 2438314 defendant Coke John mariner 588241 588241 Coke, John, of Pakefeld, Suff, mariner 0
5277702 2438564 2438564 defendant Acoleyn John shipman 588241 588241 Acoleyn, John, of Pakefeld, Suff, shipman 2
5293339 2443034 2443034 defendant Medewe Waren shipman 588241 588241 Medewe, Waren, of Pakefeld, Suff, shipman 0
5298500 2444540 2444540 defendant Colayn John husbandman 588241 588241 Colayn, John, of Pakefeld, Suff, husbandman 0
5299892 2444933 2444933 defendant Nen John yeoman 588241 588241 Nen, John, of Pakefeld, Suff, yeoman 8
5300484 2445107 2445107 defendant Nene John husbandman 588241 588241 Nene, John, of Pakefeld, Suff, husbandman 1
5340684 2457286 2457286 defendant Geddyng Robert husbandman 588241 588241 Geddyng, Robert, of Pakefeld, Suff, husbandman 0
5353724 2461230 2461230 defendant Wrenne Adam merchant 588241 588241 Wrenne, Adam, of Pakefeld, Suff, merchant 0
5375220 2467837 2467837 defendant Geddyng Robert husbandman 588241 588241 Geddyng, Robert, of Pakefeld, Suff, husbandman 1
5378145 2468743 2468743 defendant Skynner Thomas   588241 588241 Skynner, Thomas, of Pakefeld, Suff, ship man 0
5418924 2480584 2480584 defendant Hykkys Richard mariner 588241 588241 Hykkys, Richard, of Pakefeld, Suff, mariner 0
5418925 2480584 2480584 defendant Chylderrowe John mariner 588241 588241 Chylderrowe, John, of Pakefeld, Suff, mariner 1
5437029 2486013 2486013 defendant Chylderowe John mariner 588241 588241 Chylderowe, John, of Pakefeld, Suff, mariner 0
5437031 2486014 2486014 defendant Hykkys Richard mariner 588241 588241 Hykkys, Richard, of Pakefeld, Suff, mariner 0
5459927 2492898 2492898 defendant Nen John mariner 588241 588241 Nen, John, of Pakefeld, Suff, mariner 2
5506726 2507023 2507023 defendant Tomson John shipman 588241 588241 Tomson, John, of Pakefeld, Suff, shipman 2
5541591 2517479 2517479 defendant Brewster Richard (legal representative) 588241 588241 Brewster, Richard, of Pakefeld, Suff, husbandman, executrix of 4
5541598 2517480 2517480 defendant Browster Richard (legal representative) 588241 588241 Browster, Richard, of Pakefeld, Suff, husbandman, executrix of 4
5545239 2518610 2518610 defendant Assby Robert mariner 588241 588241 Assby, Robert, of Pakefeld, Suff, mariner 0
5545246 2518612 2518612 defendant Assby Robert mariner 588241 588241 Assby, Robert, of Pakefeld, Suff, mariner 1
5552565 2520806 2520806 defendant Asshby Robert mariner 588241 588241 Asshby, Robert, of Pakefeld, SUff, mariner 1
5561794 2523434 2523434 defendant Clement William husbandman 588241 588241 Clement, William, of Pakefeld, Suff, husbandman 2
5561800 2523435 2523435 defendant Clement William husbandman 588241 588241 Clement, William, of Pakefeld, Suff, husbandman 2
5567280 2525007 2525007 defendant Frenche John yeoman 588241 588241 Frenche, John, of Pakefeld, Suff, yeoman 2
5590668 2532054 2532054 defendant Grene John husbandman 588241 588241 Grene, John, of Pakefeld, Suff, 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);