names

35 rows where place_id = 599525

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3637138 1906414 1906414 defendant Trendyll Henry yeoman 599525 599525 Trendyll, Henry, of North Elmham, Norf, yeoman 1
3970664 2014327 2014327 defendant Heywarde Henry yeoman 599525 599525 Heywarde, Henry, of North Elmham, Norf, yeoman 0
3974704 2015720 2015720 plaintiff Heyward Henry gent 599525 599525 Heyward, Henry, of North Elmham, Norf, gent 0
3983426 2018847 2018847 defendant Harris William miller 599525 599525 Harris, William, of North Elmham, Norf, miller 5
4015512 2030244 2030244 defendant Stote Thomas tailor 599525 599525 Stote, Thomas, of North Elmham, Norf, tailor 1
4027610 2034523 2034523 defendant Francklinge Richard yeoman 599525 599525 Francklinge, Richard, of North Elmham, Norf, yeoman 0
4085167 2054978 2054978 defendant Ram or Rain John dyer 599525 599525 Ram or Rain, John, of North Elmham, Norf, dyer 1
4085169 2054979 2054979 defendant Ram or Rain John dyer 599525 599525 Ram or Rain, John, of North Elmham, Norf, dyer 0
4129304 2070782 2070782 defendant Heyward Thomas gent 599525 599525 Heyward, Thomas, of North Elmham, Norf, gent 0
4242801 2110583 2110583 defendant Crumwell Henry gent 599525 599525 Crumwell, Henry, of North Elmham, Norf, gent 0
4294653 2128174 2128174 defendant Perse Thomas husbandman 599525 599525 Perse, Thomas, of North Elmham, Norf, husbandman 1
4305587 2132088 2132088 defendant Hawes Stephen yeoman 599525 599525 Hawes, Stephen, of North Elmham, Norf, yeoman 2
4363784 2152107 2152107 defendant Crumwell Edward   599525 599525 Crumwell, Edward, of North Elmham, Norf, or of Lawnd, Leics, Lord Cromwell 0
4883745 2321826 2321826 defendant Weller Robert clerk 599525 599525 Weller, Robert, of North Elmham, Norf, clerk 0
5043880 2369796 2369796 defendant Bron Thomas husbandman & son of John Bron 599525 599525 Bron, Thomas, of North Elmham, Norf, husbandman & son of John Bron 0
5045799 2370379 2370379 defendant Bron Thomas chandler 599525 599525 Bron, Thomas, of North Elmham, Norf, chandler 0
5082124 2381147 2381147 defendant Neve William husbandman 599525 599525 Neve, William, of North Elmham, Norf, husbandman 1
5156712 2403123 2403123 defendant Fyssher William (legal representative) 599525 599525 Fyssher, William, of North Elmham, Norf, yeoman, executor of 0
5259135 2432973 2432973 defendant Trendell William yeoman 599525 599525 Trendell, William, of North Elmham, Norf, yeoman 0
5271017 2436619 2436619 defendant Fuller Thomas yeoman 599525 599525 Fuller, Thomas, of North Elmham, Norf, yeoman 1
5303184 2445944 2445944 defendant Belery Henry husbandman 599525 599525 Belery, Henry, of North Elmham, Norf, husbandman 3
5311590 2448489 2448489 defendant Warner John husbandman 599525 599525 Warner, John, of North Elmham, Norf, husbandman 0
5369966 2466197 2466197 defendant Broun Thomas, senior husbandman 599525 599525 Broun, Thomas, senior, of North Elmham, Norf, husbandman 2
5375691 2467988 2467988 defendant Phyppys Richard yeoman or pardoner 599525 599525 Phyppys, Richard, of North Elmham, Norf, yeoman or pardoner 0
5398038 2474505 2474505 defendant Chamberleyn John smith 599525 599525 Chamberleyn, John, of North Elmham, Norf, smith 5
5402136 2475675 2475675 defendant Taverner John husbandman 599525 599525 Taverner, John, of North Elmham, Norf, husbandman 7
5425339 2482550 2482550 defendant Chamberleyn Robert smith 599525 599525 Chamberleyn, Robert, of North Elmham, Norf, smith 5
5425344 2482551 2482551 defendant Chamberleyn Robert smith 599525 599525 Chamberleyn, Robert, of North Elmham, Norf, smith 3
5431111 2484244 2484244 defendant Langes John (legal representative) 599525 599525 Langes, John, of North Elmham, Norf, smith, executors of 5
5431113 2484244 2484244 defendant Taverner John husbandman 599525 599525 Taverner, John, of North Elmham, Norf, husbandman 7
5435542 2485569 2485569 defendant Basse Richard husbandman 599525 599525 Basse, Richard, of North Elmham, Norf, husbandman 1
5462689 2493748 2493748 defendant Basse Richard husbandman 599525 599525 Basse, Richard, of North Elmham, Norf, husbandman 0
5474218 2497263 2497263 defendant Basse Richard husbandman 599525 599525 Basse, Richard, of North Elmham, Norf, husbandman 0
5573127 2526693 2526693 defendant Dyte John yeoman 599525 599525 Dyte, John, of North Elmham, Norf, yeoman 0
5573131 2526694 2526694 defendant Dyte John yeoman 599525 599525 Dyte, John, of North Elmham, Norf, yeoman 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);