names

47 rows where place_id = 626736

✎ 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
3771944 1948918 1948918 defendant Langwade John, junior yeoman 626736 626736 Langwade, John, junior, of Briston, yeoman 1
3771945 1948918 1948918 defendant Langwade John, senior yeoman 626736 626736 Langwade, John, senior, of Briston, yeoman 2
4048434 2041886 2041886 defendant Cates John, junior yeoman 626736 626736 Cates, John, junior, of Briston, yeoman 1
4066489 2048307 2048307 defendant Johnsonne John gent 626736 626736 Johnsonne, John, of Briston, gent 0
4080083 2053183 2053183 plaintiff Waddelowe John   626736 626736 Waddelowe, John, of Briston, ploughwright 0
4121043 2067814 2067814 defendant Tolke Richard husbandman 626736 626736 Tolke, Richard, of Briston, husbandman 1
4137667 2073825 2073825 defendant Copher John yeoman 626736 626736 Copher, John, of Briston, yeoman 0
4497993 2200018 2200018 plaintiff Everard Thomas   626736 626736 Everard, Thomas, of Briston, on his own account 0
4497996 2200018 2200018 defendant Paddywade John   626736 626736 Paddywade, John, of Briston 2
4511554 2204063 2204063 defendant Whirlere John   626736 626736 Whirlere, John, of Briston 0
4535396 2211341 2211341 defendant Reynald John   626736 626736 Reynald, John, of Briston 1
4555743 2217731 2217731 defendant Erl John   626736 626736 Erl, John, of Briston 0
4578368 2224724 2224724 plaintiff Clerk Henry   626736 626736 Clerk, Henry, of Briston 0
4578370 2224724 2224724 plaintiff atte Brigge Cecilia   626736 626736 atte Brigge, Cecilia, of Briston 2
4581707 2225727 2225727 defendant Morys Walter   626736 626736 Morys, Walter, of Briston 2
4615157 2235748 2235748 plaintiff Everard John   626736 626736 Everard, John, of Briston 0
4652810 2246812 2246812 defendant Morys Walter yeoman 626736 626736 Morys, Walter, of Briston, yeoman 1
4700307 2265512 2265512 defendant Morys Walter husbandman 626736 626736 Morys, Walter, of Briston, husbandman 0
4707295 2267658 2267658 defendant Dowel William laborer 626736 626736 Dowel, William, of Briston, laborer 3
4717112 2270681 2270681 defendant Clerk Henry yeoman 626736 626736 Clerk, Henry, of Briston, yeoman 0
4721321 2272000 2272000 plaintiff Cartere William   626736 626736 Cartere, William, of Briston 0
4776418 2288619 2288619 defendant Motys Walter yeoman 626736 626736 Motys, Walter, of Briston, yeoman 0
4779672 2289630 2289630 defendant Leveden Robert gent 626736 626736 Leveden, Robert, of Briston, gent 0
4780180 2289800 2289800 defendant Holbeme Reginald husbandman 626736 626736 Holbeme, Reginald, of Briston, husbandman 0
4780182 2289800 2289800 defendant Mortymer Richard husbandman 626736 626736 Mortymer, Richard, of Briston, husbandman 2
4801201 2296560 2296560 defendant Briston John esq 626736 626736 Briston, John, of Briston, esq 0
4801202 2296560 2296560 defendant Clerk Henry husbandman 626736 626736 Clerk, Henry, of Briston, husbandman 1
4801203 2296560 2296560 defendant Dully Roger husbandman 626736 626736 Dully, Roger, of Briston, husbandman 2
4801204 2296560 2296560 defendant Brigge Robert husbandman 626736 626736 Brigge, Robert, of Briston, husbandman 3
4838652 2308014 2308014 defendant Clerk Henry   626736 626736 Clerk, Henry, of Briston 2
4863187 2315462 2315462 defendant Herre William yeoman 626736 626736 Herre, William, of Briston, yeoman 7
5038285 2368090 2368090 defendant Murdy Thomas husbandman 626736 626736 Murdy, Thomas, of Briston, husbandman 0
5095586 2385133 2385133 defendant Cooldham alias Petybone Thomas husbandman 626736 626736 Cooldham alias Petybone, Thomas, of Briston, husbandman 0
5095587 2385133 2385133 defendant Cooldham alias Petybone Simon husbandman 626736 626736 Cooldham alias Petybone, Simon, of Briston, husbandman 1
5134268 2396518 2396518 plaintiff Langwade Thomas   626736 626736 Langwade, Thomas, of Briston 0
5134269 2396518 2396518 defendant Coldam alias Penbowe Henry husbandman 626736 626736 Coldam alias Penbowe, Henry, of Briston, husbandman 0
5134270 2396518 2396518 defendant Coldam alias Penbonde Simon   626736 626736 Coldam alias Penbonde, Simon, of Briston 1
5194838 2414234 2414234 defendant Langewade Thomas yeoman 626736 626736 Langewade, Thomas, of Briston, yeoman 1
5194839 2414234 2414234 defendant Muray Thomas yeoman 626736 626736 Muray, Thomas, of Briston, yeoman 2
5243903 2428408 2428408 defendant Coldham Simon husbandman 626736 626736 Coldham, Simon, of Briston, husbandman 2
5305285 2446584 2446584 defendant More Thomas husbandman 626736 626736 More, Thomas, of Briston, husbandman 4
5356294 2462045 2462045 plaintiff Chamberleyn Thomas   626736 626736 Chamberleyn, Thomas, of Briston 3
5356412 2462073 2462073 plaintiff Chamberleyn Thomas   626736 626736 Chamberleyn, Thomas, of Briston 3
5410020 2477962 2477962 defendant Toly Robert laborer 626736 626736 Toly, Robert, of Briston, laborer 3
5555523 2521616 2521616 defendant Sygo Henry yeoman 626736 626736 Sygo, Henry, of Briston, yeoman 1
5560469 2523019 2523019 defendant Toly Robert yeoman 626736 626736 Toly, Robert, of Briston, yeoman 6
5634847 2554892 2554892 defendant Adekyn Edmund mercer 626736 626736 together with Adekyn, Edmund, of Briston, mercer 4

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);