names

48 rows where place_id = 611156

✎ 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
3687134 1922150 1922150 defendant Beare William merchant 611156 611156 Beare, William, of Kyngeswere, merchant 0
3687140 1922153 1922153 defendant Pyne Thomas merchant 611156 611156 Pyne, Thomas, of Kyngeswere, merchant 0
3702207 1926946 1926946 defendant Beare William merchant 611156 611156 Beare, William, of Kyngeswere, merchant 0
3702211 1926948 1926948 defendant Pyne Thomas merchant 611156 611156 Pyne, Thomas, of Kyngeswere, merchant 0
3882096 1984269 1984269 defendant Peratt Thomas mariner 611156 611156 Peratt, Thomas, of Kyngeswere, mariner 0
4443797 2183033 2183033 defendant Ray John   611156 611156 Ray, John, of Kyngeswere 0
4521638 2207095 2207095 plaintiff Geffrey William   611156 611156 Geffrey, William, of Kyngeswere 0
4538446 2212311 2212311 defendant Kent John   611156 611156 Kent, John, of Kyngeswere 1
4540884 2213055 2213055 defendant Leye Thomas   611156 611156 Leye, Thomas, of Kyngeswere, administrators of 0
4540885 2213055 2213055 defendant Leye Helen   611156 611156 (Leye, Helen, of Kyngeswere, formerly wife of Thomas 1
4620504 2237391 2237391 defendant William John   611156 611156 William, John, of Kyngeswere 2
4677350 2258535 2258535 defendant Hywyssh William shipman 611156 611156 Hywyssh, William, of Kyngeswere, shipman 3
4742447 2278290 2278290 defendant Smyth Richard merchant 611156 611156 Smyth, Richard, of Kyngeswere, merchant 0
4786146 2291705 2291705 defendant William John mariner 611156 611156 William, John, of Kyngeswere, mariner 3
4798204 2295632 2295632 defendant Seyntion John mariner 611156 611156 Seyntion, John, of Kyngeswere, mariner 1
4798205 2295632 2295632 defendant Huwyssh William mariner 611156 611156 Huwyssh, William, of Kyngeswere, mariner 2
4806439 2298225 2298225 defendant Davy John mariner 611156 611156 Davy, John, of Kyngeswere, mariner 0
4819838 2302277 2302277 defendant William John meriner 611156 611156 William, John, of Kyngeswere, meriner 2
4850078 2311484 2311484 defendant Prigge John merchant 611156 611156 Prigge, John, of Kyngeswere, merchant 0
4850079 2311484 2311484 defendant Smyth Richard chapman 611156 611156 Smyth, Richard, of Kyngeswere, chapman 1
4864889 2315995 2315995 defendant Bronde John merchant 611156 611156 Bronde, John, of Kyngeswere, merchant 1
4897532 2325888 2325888 defendant Gore Richard mariner 611156 611156 Gore, Richard, of Kyngeswere, mariner 0
4897533 2325888 2325888 defendant John son of Huchon Walter mariner 611156 611156 John son of Huchon, Walter, of Kyngeswere, mariner 1
4909327 2329459 2329459 defendant Burgeys John   611156 611156 Burgeys, John, of Kyngeswere, administrators of 3
4941241 2339284 2339284 defendant Cobbe Michael merchant 611156 611156 Cobbe, Michael, of Kyngeswere, merchant 0
4958060 2344376 2344376 defendant Bolegh John merchant 611156 611156 Bolegh, John, of Kyngeswere, merchant 0
4986864 2353011 2353011 defendant Kede John (legal representative) 611156 611156 Kede, John, of Kyngeswere, executors of 2
5013948 2360934 2360934 defendant Smyth William merchant 611156 611156 Smyth, William, of Kyngeswere, merchant 0
5013949 2360934 2360934 defendant Bround John merchant 611156 611156 Bround, John, of Kyngeswere, merchant 1
5017911 2362121 2362121 defendant Mason Stephen mariner 611156 611156 Mason, Stephen, of Kyngeswere, mariner 1
5053073 2372517 2372517 defendant Smyth William shipman 611156 611156 Smyth, William, of Kyngeswere, shipman 0
5053075 2372517 2372517 defendant Payn Peter mariner 611156 611156 Payn, Peter, of Kyngeswere, mariner 2
5158224 2403526 2403526 defendant Smyth William merchant 611156 611156 Smyth, William, of Kyngeswere, merchant 1
5173874 2408056 2408056 defendant Smyth William merchant 611156 611156 Smyth, William, of Kyngeswere, merchant 1
5217043 2420725 2420725 defendant Smyth William merchant 611156 611156 Smyth, William, of Kyngeswere, merchant 0
5217048 2420726 2420726 defendant Smyth William merchant 611156 611156 Smyth, William, of Kyngeswere, merchant 0
5302640 2445764 2445764 defendant Prysshe Robert yeoman 611156 611156 Prysshe, Robert, of Kyngeswere, yeoman 1
5333179 2454991 2454991 defendant Peyntour William tailor 611156 611156 Peyntour, William, of Kyngeswere, tailor 0
5336899 2456103 2456103 defendant John Richard yeoman 611156 611156 John, Richard, of Kyngeswere, yeoman 0
5345943 2458864 2458864 defendant Boway Thomas mariner 611156 611156 Boway, Thomas, of Kyngeswere, mariner 0
5345946 2458865 2458865 defendant Boway Thomas mariner 611156 611156 Boway, Thomas, of Kyngeswere, mariner 0
5424317 2482239 2482239 defendant Gylam John yeoman 611156 611156 Gylam, John, of Kyngeswere, yeoman 1
5443199 2487880 2487880 defendant Eylam John yeoman 611156 611156 Eylam, John, of Kyngeswere, yeoman 1
5450360 2489994 2489994 defendant Bowey John merchant 611156 611156 Bowey, John, of Kyngeswere, merchant 1
5455743 2491618 2491618 defendant Eylam John yeoman 611156 611156 Eylam, John, of Kyngeswere, yeoman 0
5455757 2491621 2491621 defendant Wynterbourne John chaplain 611156 611156 Wynterbourne, John, of Kyngeswere, chaplain 2
5467577 2495230 2495230 defendant Wynterbourn John chaplain 611156 611156 Wynterbourn, John, of Kyngeswere, chaplain 1
5615500 2548635 2548635 defendant Kyde Roger   611156 611156 Kyde, Roger, of Kyngeswere 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);