names

21 rows where place_id = 758904

✎ 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
4457733 2187430 2187430 defendant Osbern John   758904 758904 Osbern, John, of Wymborne Mynstre 1
4590236 2228315 2228315 defendant Radeford John   758904 758904 Radeford, John, of Wymborne Mynstre 1
4613043 2235137 2235137 defendant Brode John   758904 758904 Brode, John, of Wymborne Mynstre 0
4654775 2247373 2247373 defendant Manstreych or Maustreych Nicholas butcher 758904 758904 Manstreych or Maustreych, Nicholas, of Wymborne Mynstre, butcher 0
4690202 2262492 2262492 defendant Beyke John yeoman 758904 758904 Beyke, John, of Wymborne Mynstre, yeoman 0
4717746 2270888 2270888 defendant Vyncent William chaplain 758904 758904 together with Vyncent, William, of Wymborne Mynstre, chaplain 1
4739915 2277562 2277562 defendant Badde John shoemaker 758904 758904 Badde, John, of Wymborne Mynstre, shoemaker 0
4793950 2294237 2294237 defendant Poulet Richard   758904 758904 Poulet, Richard, of Wymborne Mynstre husbandman 0
4800367 2296295 2296295 plaintiff Rypon John   758904 758904 Rypon, John, of Wymborne Mynstre 1
4808087 2298704 2298704 defendant Buk John glover 758904 758904 Buk, John, of Wymborne Mynstre, glover 2
4884925 2322182 2322182 defendant Perterych Stephen yeoman 758904 758904 Perterych, Stephen, of Wymborne Mynstre, yeoman 1
4884937 2322185 2322185 defendant Bene Nicholas husbandman 758904 758904 Bene, Nicholas, of Wymborne Mynstre, husbandman 3
5021277 2363124 2363124 defendant Hert Simon husbandman 758904 758904 Hert, Simon, of Wymborne Mynstre, husbandman 0
5083605 2381600 2381600 defendant Hardeware Richard laborer 758904 758904 Hardeware, Richard, of Wymborne Mynstre, laborer 1
5092224 2384106 2384106 plaintiff Overton William grocer 758904 758904 Overton, William, of Wymborne Mynstre, grocer 0
5119982 2392282 2392282 defendant Selwode William chapman 758904 758904 Selwode, William, of Wymborne Mynstre, chapman 0
5204841 2417168 2417168 defendant Denysell John tailor 758904 758904 Denysell, John, of Wymborne Mynstre, tailor 1
5251759 2430659 2430659 defendant Stoborowe William butcher 758904 758904 Stoborowe, William, of Wymborne Mynstre, butcher 0
5251828 2430680 2430680 defendant Fote Thomas butcher 758904 758904 Fote, Thomas, of Wymborne Mynstre, butcher 0
5404692 2476420 2476420 defendant Snell Thomas tanner 758904 758904 Snell, Thomas, of Wymborne Mynstre, tanner 0
5601069 2535221 2535221 defendant Hapgoode Thomas, junior tanner 758904 758904 Hapgoode, Thomas, junior, of Wymborne Mynstre, tanner 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);