names

58 rows where place_id = 602299

✎ 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
3649414 1910209 1910209 defendant Clerk John husbandman 602299 602299 Clerk, John, of Montacute, husbandman 0
4138622 2074180 2074180 defendant Everyarde William butcher 602299 602299 Everyarde, William, of Montacute, butcher 2
4138623 2074180 2074180 defendant Barnarde William husbandman 602299 602299 Barnarde, William, of Montacute, husbandman 3
4426890 2173231 2173231 defendant Baret John   602299 602299 Baret, John, of Montacute 0
4435212 2175770 2175770 defendant Cartere Robert le   602299 602299 Cartere, Robert le, of Montacute 4
4437699 2176548 2176548 plaintiff Yonge Richard le (legal representative) 602299 602299 Yonge, Richard le, of Montacute, executor of 0
4455584 2186754 2186754 defendant Bill Philip   602299 602299 Bill, Philip, of Montacute 0
4529635 2209548 2209548 defendant Dun Philip   602299 602299 Dun, Philip, of Montacute 2
4578529 2224775 2224775 defendant Cole Henry   602299 602299 Cole, Henry, of Montacute 2
4592577 2229030 2229030 defendant Payn William   602299 602299 Payn, William, of Montacute 0
4606944 2233281 2233281 plaintiff Bat Philip   602299 602299 Bat, Philip, of Montacute 0
4622551 2238030 2238030 defendant Touker William   602299 602299 Touker, William, of Montacute 2
4667453 2255542 2255542 plaintiff Benet John   602299 602299 Benet, John, of Montacute, prior 1
4681312 2259782 2259782 defendant Houwes John husbandman 602299 602299 Houwes, John, of Montacute, husbandman 2
4681313 2259782 2259782 defendant Cole John   602299 602299 Cole, John, of Montacute husbandman 3
4682462 2260138 2260138 defendant Attebere John husbandman 602299 602299 Attebere, John, of Montacute, husbandman 1
4683796 2260540 2260540 defendant Hawar John, junior husbandman 602299 602299 Hawar, John, junior, of Montacute, husbandman 0
4693471 2263460 2263460 plaintiff Bate Philip   602299 602299 Bate, Philip, of Montacute 0
4706614 2267448 2267448 defendant Brytell Laurence   602299 602299 Brytell, Laurence, of Montacute, hay ward 0
4706615 2267448 2267448 defendant Pandy William laborer 602299 602299 Pandy, William, of Montacute, laborer 1
4706675 2267470 2267470 defendant Pandy William laborer 602299 602299 Pandy, William, of Montacute, laborer 1
4715656 2270224 2270224 defendant Hugyn John   602299 602299 Hugyn, John, of Montacute, bailiff 2
4718720 2271195 2271195 plaintiff Bat Philip   602299 602299 Bat, Philip, of Montacute 0
4731227 2274964 2274964 defendant Denyas John tailor 602299 602299 Denyas, John, of Montacute, tailor 0
4742445 2278289 2278289 defendant Helyer Richard helyer 602299 602299 Helyer, Richard, of Montacute, helyer 0
4849748 2311392 2311392 defendant Hygon John husbandman 602299 602299 Hygon, John, of Montacute, husbandman 3
4852775 2312286 2312286 defendant Monk John husbandman 602299 602299 Monk, John, of Montacute, husbandman 0
4944920 2340401 2340401 defendant Davy John   602299 602299 Davy, John, of Montacute, freemason 0
4944921 2340401 2340401 defendant Davy Thomas   602299 602299 Davy, Thomas, of Montacute, freemason 1
4989663 2353829 2353829 defendant Bernard Robert husbandman 602299 602299 Bernard, Robert, of Montacute, husbandman 1
4989665 2353829 2353829 defendant Smyth John smith 602299 602299 Smyth, John, of Montacute, smith 3
5030082 2365670 2365670 plaintiff Paw William husbandman 602299 602299 Paw, William, of Montacute, husbandman 0
5030083 2365670 2365670 plaintiff Clerke Edward husbandman 602299 602299 Clerke, Edward, of Montacute, husbandman 1
5030084 2365670 2365670 defendant Carpynter John gent 602299 602299 Carpynter, John, of Montacute, gent 0
5030085 2365670 2365670 defendant Monke John husbandman 602299 602299 Monke, John, of Montacute, husbandman 1
5117039 2391409 2391409 defendant Cadbury John clerk 602299 602299 Cadbury, John, of Montacute, clerk 0
5135813 2396988 2396988 defendant Kyrkby Richard yeoman 602299 602299 Kyrkby, Richard, of Montacute, yeoman 0
5135814 2396988 2396988 defendant Cole William   602299 602299 Cole, William, of Montacute, mason 1
5139097 2397928 2397928 defendant Davy John   602299 602299 Davy, John, of Montacute, mason 0
5139099 2397928 2397928 defendant Soppeley Robert yeoman 602299 602299 Soppeley, Robert, of Montacute, yeoman 2
5156076 2402935 2402935 defendant Kyrkby Richard yeoman 602299 602299 Kyrkby, Richard, of Montacute, yeoman 0
5156077 2402935 2402935 defendant Cole William   602299 602299 Cole, William, of Montacute, mason 1
5162162 2404667 2404667 defendant Hamelyne William tailor 602299 602299 Hamelyne, William, of Montacute, tailor 2
5176351 2408772 2408772 defendant Hamelyne William tailor 602299 602299 Hamelyne, William, of Montacute, tailor 2
5256488 2432153 2432153 defendant Thorne William yeoman 602299 602299 Thorne, William, of Montacute, yeoman 0
5256490 2432154 2432154 defendant Thorne William yeoman 602299 602299 Thorne, William, of Montacute, yeoman 0
5256491 2432154 2432154 defendant Hoper Thomas laborer 602299 602299 Hoper, Thomas, of Montacute, laborer 1
5299776 2444904 2444904 defendant Longe William yeoman 602299 602299 Longe, William, of Montacute, yeoman 0
5309663 2447929 2447929 defendant Monke William husbandman 602299 602299 Monke, William, of Montacute, husbandman 7
5309668 2447929 2447929 defendant Eyot John laborer 602299 602299 Eyot, John, of Montacute, laborer 12
5407344 2477166 2477166 plaintiff (not given) John prior of Walter or Water 602299 602299 Walter or Water, John, of Montacute, prior of the House & Church of BM 0
5407346 2477167 2477167 plaintiff (not given) John prior of Walter or Water 602299 602299 Walter or Water, John, of Montacute, prior of the House & Church of BM 0
5407348 2477168 2477168 plaintiff (not given) John prior of Walter or Water 602299 602299 Walter or Water, John, of Montacute, prior of the House & Church of BM 0
5407352 2477169 2477169 plaintiff (not given) John prior of Walter or Water 602299 602299 Walter or Water, John, of Montacute, prior of the House & Church of BM 0
5476753 2498049 2498049 plaintiff (not given) John prior of Water 602299 602299 Water, John, of Montacute, prior of the house & church of the BM 0
5582295 2529536 2529536 defendant Clerke John husbandman 602299 602299 Clerke, John, of Montacute, husbandman 0
5588672 2531469 2531469 defendant Floyle John baker 602299 602299 Floyle, John, of Montacute, baker 0
5628418 2552855 2552855 defendant atte Bere John husbandman 602299 602299 atte Bere, John, of Montacute, husbandman 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);