names

50 rows where place_id = 765097

✎ 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
4513269 2204569 2204569 defendant atte Bothe John   765097 765097 atte Bothe, John, of Hellynglegh 0
4544802 2214291 2214291 defendant Aleyn William   765097 765097 Aleyn, William, of Hellynglegh, vicar 0
4544804 2214292 2214292 defendant Aleyn William   765097 765097 Aleyn, William, of Hellynglegh, vicar 0
4664290 2250314 2250314 plaintiff Hamme William (legal representative) 765097 765097 Hamme, William, of Hellynglegh, executors of 0
4677195 2258485 2258485 defendant Busshop William cheseman 765097 765097 Busshop, William, of Hellynglegh, cheseman 0
4688244 2261891 2261891 defendant Wythgere Robert laborer 765097 765097 Wythgere, Robert, of Hellynglegh, laborer 0
4690927 2262692 2262692 defendant Berd Richard husbandman 765097 765097 Berd, Richard, of Hellynglegh, husbandman 1
4692478 2263164 2263164 defendant Elphegh John husbandman 765097 765097 Elphegh, John, of Hellynglegh, husbandman 0
4700144 2265466 2265466 defendant atte Grove Robert husbandman 765097 765097 atte Grove, Robert, of Hellynglegh, husbandman 0
4702504 2266196 2266196 defendant Reynold William carpenter 765097 765097 Reynold, William, of Hellynglegh, carpenter 0
4702505 2266196 2266196 defendant Reynold John laborer 765097 765097 Reynold, John, of Hellynglegh, laborer 1
4738854 2277242 2277242 defendant Newe John turner 765097 765097 Newe, John, of Hellynglegh, turner 2
4763695 2284635 2284635 defendant Twyt John husbandman 765097 765097 Twyt, John, of Hellynglegh, husbandman 0
4765216 2285103 2285103 defendant Pottere John tanner 765097 765097 Pottere, John, of Hellynglegh, tanner 0
4780411 2289871 2289871 defendant Wyltonherst John husbandman 765097 765097 Wyltonherst, John, of Hellynglegh, husbandman 1
4787353 2292116 2292116 defendant Twyt John husbandman 765097 765097 Twyt, John, of Hellynglegh, husbandman 0
4787359 2292117 2292117 defendant Twyt John husbandman 765097 765097 Twyt, John, of Hellynglegh, husbandman 0
4805511 2297935 2297935 defendant Wethyer Robert husbandman 765097 765097 Wethyer, Robert, of Hellynglegh, husbandman 3
4805514 2297936 2297936 defendant Wethyer Robert husbandman 765097 765097 Wethyer, Robert, of Hellynglegh, husbandman 0
4809931 2299267 2299267 plaintiff Elphegh John   765097 765097 Elphegh, John, of Hellynglegh 0
4809933 2299267 2299267 defendant atte Grove Robert yeoman 765097 765097 atte Grove, Robert, of Hellynglegh, yeoman 0
4812309 2299963 2299963 defendant atte Stone Henery husbandman 765097 765097 atte Stone, Henery, of Hellynglegh, husbandman 1
4825403 2303988 2303988 defendant Twytte John, senior husbandman 765097 765097 Twytte, John, senior, of Hellynglegh, husbandman 0
4829953 2305412 2305412 defendant Braseer John yeoman 765097 765097 Braseer, John, of Hellynglegh, yeoman 1
4830733 2305641 2305641 plaintiff Boole William (legal representative) 765097 765097 Boole, William, of Hellynglegh, vicar, executors of 0
4830735 2305641 2305641 plaintiff Smyth Richard   765097 765097 Smyth, Richard, of Hellynglegh 2
4830737 2305641 2305641 defendant Mortymer Richard husbandman 765097 765097 Mortymer, Richard, of Hellynglegh, husbandman 1
4845339 2310054 2310054 defendant Brasyer John yeoman 765097 765097 Brasyer, John, of Hellynglegh, yeoman 2
4848078 2310866 2310866 defendant Goseler William husbandman 765097 765097 Goseler, William, of Hellynglegh, husbandman 1
4848080 2310867 2310867 defendant Halle John gent 765097 765097 Halle, John, of Hellynglegh, gent 0
4854099 2312691 2312691 plaintiff Wythegar Robert husbandman 765097 765097 Wythegar, Robert, of Hellynglegh, husbandman 0
4854100 2312691 2312691 defendant Twith John, sen husbandman 765097 765097 Twith, John, sen, of Hellynglegh, husbandman 0
4857590 2313763 2313763 plaintiff Smyth Richard   765097 765097 Smyth, Richard, of Hellynglegh 2
4857592 2313763 2313763 defendant Mortymer Richard husbandman 765097 765097 Mortymer, Richard, of Hellynglegh, husbandman 1
4860067 2314519 2314519 defendant atte Walle Richard tanner 765097 765097 atte Walle, Richard, of Hellynglegh, tanner 1
4861087 2314825 2314825 defendant Brasier William laborer 765097 765097 Brasier, William, of Hellynglegh, laborer 0
4915265 2331279 2331279 defendant Fissh William husbandman 765097 765097 Fissh, William, of Hellynglegh, husbandman 0
4935067 2337376 2337376 defendant atte Legh John weaver 765097 765097 atte Legh, John, of Hellynglegh, weaver 0
4958741 2344581 2344581 defendant Fretyngham William laborer 765097 765097 Fretyngham, William, of Hellynglegh, laborer 0
4984383 2352260 2352260 defendant Haynton Robert clerk 765097 765097 Haynton, Robert, of Hellynglegh, clerk 0
5101298 2386788 2386788 defendant atte Lye Richard laborer 765097 765097 atte Lye, Richard, of Hellynglegh, laborer 0
5116950 2391382 2391382 defendant atte Lye Richard laborer 765097 765097 atte Lye, Richard, of Hellynglegh, laborer 0
5147715 2400470 2400470 plaintiff Colcote Robert gent 765097 765097 Colcote, Robert, of Hellynglegh, gent 0
5208271 2418147 2418147 defendant Umbrays Richard husbandman 765097 765097 Umbrays, Richard, of Hellynglegh, husbandman 0
5212192 2419304 2419304 defendant Elfegh Henry husbandman 765097 765097 Elfegh, Henry, of Hellynglegh, husbandman 0
5212194 2419305 2419305 defendant Elsegh Henry husbandman 765097 765097 Elsegh, Henry, of Hellynglegh, husbandman 0
5223973 2422694 2422694 defendant Umbrays Richard husbandman 765097 765097 Umbrays, Richard, of Hellynglegh, husbandman 0
5368843 2465843 2465843 defendant Broun John wheeler 765097 765097 Broun, John, of Hellynglegh, wheeler 0
5636088 2555244 2555244 defendant Berde Nicholas draper 765097 765097 Berde, Nicholas, of Hellynglegh, draper 3
5636633 2555401 2555401 defendant atte Welle John tanner 765097 765097 atte Welle, John, of Hellynglegh, 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);