names

41 rows where place_id = 759189

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4418088 2170536 2170536 plaintiff (not given) John vicar of Tuk 759189 759189 Tuk, John, of Appelby, vicar of St Michael's church 0
4429107 2173912 2173912 plaintiff (not given) John vicar of Tuk 759189 759189 Tuk, John, of Appelby, vicar of St Michael's church 0
4459730 2188096 2188096 defendant Overdo Robert   759189 759189 Overdo, Robert, of Appelby 0
4459731 2188096 2188096 defendant Overdo John   759189 759189 Overdo, John, of Appelby 1
4459749 2188102 2188102 defendant Overdo Robert   759189 759189 Overdo, Robert, of Appelby 0
4459750 2188102 2188102 defendant Overdo John   759189 759189 Overdo, John, of Appelby 1
4505270 2202178 2202178 plaintiff Smyth Nicholas   759189 759189 Smyth, Nicholas, of Appelby 0
4557474 2218274 2218274 plaintiff Lancastreshire Thomas   759189 759189 Lancastreshire, Thomas, of Appelby 0
4577235 2224398 2224398 plaintiff Campion John   759189 759189 Campion, John, of Appelby 0
4577236 2224398 2224398 defendant Welles John   759189 759189 Welles, John, of Appelby, wright 0
4613247 2235179 2235179 defendant Paryning William   759189 759189 Paryning, William, of Appelby 14
4613249 2235179 2235179 defendant Barker Richard   759189 759189 Barker, Richard, of Appelby 16
4660319 2249057 2249057 defendant Esotson William slater 759189 759189 Esotson, William, of Appelby, slater 4
4685252 2260984 2260984 plaintiff Rorell Nicholas   759189 759189 Rorell, Nicholas, of Appelby 0
4788210 2292383 2292383 defendant de Bakhous Gilbert yeoman 759189 759189 de Bakhous, Gilbert, of Appelby, yeoman 3
4790679 2293171 2293171 defendant Langton John yeoman 759189 759189 Langton, John, of Appelby, yeoman 0
4800384 2296300 2296300 defendant Faynt Robert husbandman 759189 759189 Faynt, Robert, of Appelby, husbandman 0
4862216 2315195 2315195 defendant de Merton Thomas chaplain 759189 759189 de Merton, Thomas, of Appelby, chaplain 0
4862252 2315204 2315204 defendant del Vikers William yeoman 759189 759189 del Vikers, William, of Appelby, yeoman 2
4862254 2315204 2315204 defendant Bernyngham John yeoman 759189 759189 Bernyngham, John, of Appelby, yeoman 4
4871469 2318042 2318042 defendant Borell John, senior husbandman 759189 759189 Borell, John, senior, of Appelby, husbandman 0
4873592 2318682 2318682 defendant Derwentwater Thomas yeoman 759189 759189 Derwentwater, Thomas, of Appelby, yeoman 9
4924943 2334229 2334229 plaintiff Overde Robert   759189 759189 Overde, Robert, of Appelby 0
4924944 2334229 2334229 defendant Overde Robert   759189 759189 Overde, Robert, of Appelby 0
4931320 2336175 2336175 defendant Dey John tanner 759189 759189 Dey, John, of Appelby, tanner 1
4931321 2336175 2336175 defendant Dorell John yeoman 759189 759189 Dorell, John, of Appelby, yeoman 2
4991213 2354256 2354256 defendant Pierson Robert yeoman 759189 759189 Pierson, Robert, of Appelby, yeoman 0
4996738 2355883 2355883 defendant Burell John yeoman 759189 759189 Burell, John, of Appelby, yeoman 0
5044286 2369924 2369924 plaintiff (not given) John vicar of Marchall 759189 759189 Marchall, John, of Appelby, vicar of St Michael's church 2
5137562 2397500 2397500 defendant Chaundelere Ralph yeoman 759189 759189 Chaundelere, Ralph, of Appelby, yeoman 0
5137563 2397500 2397500 defendant Colbe (illegible) husbandman 759189 759189 Colbe, ---, of Appelby, husbandman 1
5137564 2397500 2397500 defendant Reynold Simon husbandman 759189 759189 Reynold, Simon, of Appelby, husbandman 2
5137565 2397500 2397500 defendant Huton William husbandman 759189 759189 Huton, William, of Appelby, husbandman 3
5158216 2403524 2403524 defendant Chaunderler Ralph yeoman 759189 759189 Chaunderler, Ralph, of Appelby, yeoman 0
5158217 2403524 2403524 defendant Cobbe John husbandman 759189 759189 Cobbe, John, of Appelby, husbandman 1
5158218 2403524 2403524 defendant Reynold Simon husbandman 759189 759189 Reynold, Simon, of Appelby, husbandman 2
5158219 2403524 2403524 defendant Huton William husbandman 759189 759189 Huton, William, of Appelby, husbandman 3
5614006 2548153 2548153 defendant Skynner William   759189 759189 Skynner, William, of Appelby 0
5615160 2548535 2548535 defendant Flaker William   759189 759189 Flaker, William, of Appelby 0
5615274 2548576 2548576 defendant Cokeheved Thomas   759189 759189 Cokeheved, Thomas, of Appelby, administrators of 1
5615275 2548576 2548576 defendant Moigne Thomas   759189 759189 (Moigne, Thomas, of Appelby 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);