names

45 rows where place_id = 612752

✎ 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
3694846 1924595 1924595 defendant Loose Andrew mercer 612752 612752 Loose, Andrew, of Sheringham, mercer 0
3957933 2009838 2009838 plaintiff Pytt John (legal representative) 612752 612752 Pytt, John, of Sheringham, executrix of 0
4015032 2030074 2030074 defendant Ussher Simon   612752 612752 Ussher, Simon, of Sheringham, ship master 8
4104370 2061846 2061846 defendant Wulber or Wolober William mariner 612752 612752 Wulber or Wolober, William, of Sheringham, mariner 0
4150441 2078284 2078284 defendant Sturges Robert gent 612752 612752 Sturges, Robert, of Sheringham, gent 0
4150765 2078406 2078406 defendant Plumsted Thomas gent 612752 612752 Plumsted, Thomas, of Sheringham, gent 1
4162007 2082269 2082269 defendant Hooke John   612752 612752 Hooke, John, of Sheringham, ship master 0
4162009 2082269 2082269 defendant Grene Edmund   612752 612752 Grene, Edmund, of Sheringham, ship master 2
4162020 2082272 2082272 defendant Hooke Nicholas mariner 612752 612752 Hooke, Nicholas, of Sheringham, mariner 2
4167038 2083975 2083975 defendant Espyn George mariner 612752 612752 Espyn, George, of Sheringham, mariner 0
4167040 2083976 2083976 defendant Hooke John mariner 612752 612752 Hooke, John, of Sheringham, mariner 0
4203312 2096705 2096705 defendant Elam John (legal representative) 612752 612752 Elam, John, of Sheringham, ship master, executor of 1
4220602 2102704 2102704 defendant Abbes Thomas husbandman 612752 612752 Abbes, Thomas, of Sheringham, husbandman 0
4226820 2104853 2104853 defendant Maydens Thomas yeoman 612752 612752 Maydens, Thomas, of Sheringham, yeoman 2
4242747 2110564 2110564 defendant Kyrke Robert yeoman 612752 612752 Kyrke, Robert, of Sheringham, yeoman 0
4245200 2111380 2111380 defendant Tye Robert baker 612752 612752 Tye, Robert, of Sheringham, baker 1
4245204 2111381 2111381 defendant Tye Robert baker 612752 612752 Tye, Robert, of Sheringham, baker 1
4247607 2112183 2112183 defendant Swanne Thomas yeoman 612752 612752 Swanne, Thomas, of Sheringham, yeoman 0
4247608 2112183 2112183 defendant Love Simon laborer 612752 612752 Love, Simon, of Sheringham, laborer 1
4247609 2112183 2112183 defendant Dickes William laborer 612752 612752 Dickes, William, of Sheringham,, laborer 2
4249067 2112672 2112672 defendant Heywarde Thomas butcher 612752 612752 Heywarde, Thomas, of Sheringham, butcher 1
4259066 2116003 2116003 defendant Springold John   612752 612752 Springold, John, of Sheringham, mariner, adminstratrix of 0
4259067 2116003 2116003 defendant Springold Joan widow 612752 612752 Springold, Joan, of Sheringham, widow 1
4259885 2116277 2116277 defendant Hillington William mariner 612752 612752 Hillington, William, of Sheringham, mariner 0
4265135 2117978 2117978 defendant Kyrke Robert yeoman 612752 612752 Kyrke, Robert, of Sheringham, yeoman 2
4265137 2117979 2117979 defendant Kyrke Robert yeoman 612752 612752 Kyrke, Robert, of Sheringham, yeoman 0
4265138 2117979 2117979 defendant Bulwer Nicholas mariner 612752 612752 Bulwer, Nicholas, of Sheringham, yeoman, mariner 1
4265140 2117980 2117980 defendant Kyrke Robert yeoman 612752 612752 Kyrke, Robert, of Sheringham, yeoman 0
4265143 2117980 2117980 defendant Buller or Bulwer Nicholas yeoman 612752 612752 Buller or Bulwer, Nicholas, of Sheringham, sailor, yeoman 3
4265145 2117981 2117981 defendant Kyrke Robert yeoman 612752 612752 Kyrke, Robert, of Sheringham, yeoman 0
4276370 2121679 2121679 defendant Rolfe John gent 612752 612752 Rolfe, John, of Sheringham, or of Snoring Magna, gent 0
4279038 2122598 2122598 defendant Rolf John gent 612752 612752 Rolf, John, of Sheringham, gent 0
4280997 2123255 2123255 defendant Lovell Walter vintner 612752 612752 Lovell, Walter, of Sheringham, vintner 1
4281486 2123427 2123427 defendant Rolf John gent 612752 612752 Rolf, John, of Sheringham, gent 1
4283581 2124166 2124166 defendant Beales Thomas yeoman 612752 612752 Beales, Thomas, of Sheringham, yeoman 0
4292194 2127279 2127279 defendant Beales Thomas yeoman 612752 612752 Beales, Thomas, of Sheringham, yeoman 3
4312497 2134505 2134505 defendant Barwick Henry husbandman 612752 612752 Barwick, Henry, of Sheringham, husbandman 3
4313833 2134946 2134946 defendant Prettye John yeoman 612752 612752 Prettye, John, of Sheringham, yeoman 1
4324792 2138680 2138680 defendant Younger John yeoman 612752 612752 Younger, John, of Sheringham, yeoman 3
4326442 2139205 2139205 defendant Kyrke Robert yeoman 612752 612752 Kyrke, Robert, of Sheringham, yeoman 1
4336299 2142430 2142430 defendant Moore William gent 612752 612752 Moore, William, of Sheringham, gent 1
4336301 2142430 2142430 defendant Love Simon husbandman 612752 612752 Love, Simon, of Sheringham, husbandman 3
4346744 2146114 2146114 defendant Hatton William clerk 612752 612752 Hatton, William, of Sheringham, clerk 1
4401291 2165028 2165028 defendant Rolfe John gent 612752 612752 Rolfe, John, of Sheringham, gent 0
4566239 2221003 2221003 defendant Baxtere John   612752 612752 Baxtere, John, of Sheringham 1

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