names

39 rows where place_id = 602687

✎ 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
3651284 1910769 1910769 defendant Mokeworthy John clerk 602687 602687 Mokeworthy, John, of Blake Toryton, clerk 0
3670087 1916590 1916590 defendant Yorke Walter merchant 602687 602687 Yorke, Walter, of Blake Toryton, merchant 0
3711046 1929766 1929766 defendant Stephen Robert husbandman 602687 602687 Stephen, Robert, of Blake Toryton, husbandman 0
3711047 1929766 1929766 defendant Servys John husbandman 602687 602687 Servys, John, of Blake Toryton, husbandman 1
3734540 1937049 1937049 defendant Lyxmore Thomas husbandman 602687 602687 Lyxmore, Thomas, of Blake Toryton, husbandman 0
3734541 1937049 1937049 defendant Whyte Richard husbandman 602687 602687 Whyte, Richard, of Blake Toryton, husbandman 1
3886758 1985829 1985829 defendant Lovys Humphrey yeoman 602687 602687 Lovys, Humphrey, of Blake Toryton, yeoman 0
3903487 1991393 1991393 defendant Burdon Nicholas yeoman 602687 602687 Burdon, Nicholas, of Blake Toryton, yeoman 0
4757138 2282602 2282602 defendant Pomeroy William   602687 602687 Pomeroy, William, of Blake Toryton 5
4779130 2289447 2289447 defendant Pomerey William   602687 602687 Pomerey, William, of Blake Toryton, bailiff 5
4781009 2290066 2290066 defendant Perrour John husbandman 602687 602687 Perrour, John, of Blake Toryton, husbandman 0
4803537 2297294 2297294 defendant Hamelyn Nicholas husbandman 602687 602687 Hamelyn, Nicholas, of Blake Toryton, husbandman 0
4804372 2297552 2297552 defendant Loveryng David clerk 602687 602687 Loveryng, David, of Blake Toryton, clerk 0
4804373 2297552 2297552 defendant Pydeler John husbandman 602687 602687 Pydeler, John, of Blake Toryton, husbandman 1
4804374 2297552 2297552 defendant Bronde Thomas, senior husbandman 602687 602687 Bronde, Thomas, senior, of Blake Toryton, husbandman 2
4804377 2297553 2297553 defendant Yoldman John husbandman 602687 602687 Yoldman, John, of Blake Toryton, husbandman 0
4804378 2297553 2297553 defendant atte furse Richard husbandman 602687 602687 atte furse, Richard, of Blake Toryton, husbandman 1
4804379 2297553 2297553 defendant Hameleyn Nicholas husbandman 602687 602687 Hameleyn, Nicholas, of Blake Toryton, husbandman 2
4813581 2300354 2300354 defendant Loveryng David   602687 602687 Loveryng, David, of Blake Toryton 1
4962996 2345845 2345845 defendant Webber Thomas   602687 602687 Webber, Thomas, of Blake Toryton, bailiff 8
4984203 2352209 2352209 defendant Squyer Walter laborer 602687 602687 Squyer, Walter, of Blake Toryton, laborer 0
5003459 2357907 2357907 defendant Coham John husbandman 602687 602687 Coham, John, of Blake Toryton, husbandman 1
5003460 2357907 2357907 defendant Coham Walter husbandman 602687 602687 Coham, Walter, of Blake Toryton, husbandman 2
5017283 2361940 2361940 defendant Steven John gent 602687 602687 Steven, John, of Blake Toryton, gent 0
5043337 2369631 2369631 plaintiff Forshe Richard   602687 602687 Forshe, Richard, of Blake Toryton 0
5068406 2377048 2377048 defendant Ballesden Henry   602687 602687 Ballesden, Henry, of Blake Toryton, millward 5
5124279 2393547 2393547 defendant Smale Thomas husbandman 602687 602687 Smale, Thomas, of Blake Toryton, husbandman 3
5133037 2396149 2396149 defendant Allyslond (illegible) husbandman 602687 602687 Allyslond, ---, of Blake Toryton, husbandman 4
5152836 2401968 2401968 defendant Allyslond John husbandman 602687 602687 Allyslond, John, of Blake Toryton, husbandman 4
5158391 2403576 2403576 defendant Brondde Robert husbandman 602687 602687 Brondde, Robert, of Blake Toryton, husbandman 0
5158401 2403578 2403578 defendant Brondde Robert husbandman 602687 602687 Brondde, Robert, of Blake Toryton, husbandman 0
5205922 2417468 2417468 defendant Allyslond John husbandman 602687 602687 Allyslond, John, of Blake Toryton, husbandman 3
5218124 2421037 2421037 defendant Baggebeare William husbandman 602687 602687 Baggebeare, William, of Blake Toryton, husbandman 0
5226513 2423418 2423418 defendant Horndon John husbandman 602687 602687 Horndon, John, of Blake Toryton, husbandman 0
5226514 2423418 2423418 defendant Horndon Thomas laborer 602687 602687 Horndon, Thomas, of Blake Toryton, laborer 1
5244987 2428709 2428709 defendant Bagber William husbandman 602687 602687 Bagber, William, of Blake Toryton, husbandman 0
5244988 2428709 2428709 defendant Lyle Thomas husbandman 602687 602687 Lyle, Thomas, of Blake Toryton, husbandman 1
5264457 2434639 2434639 defendant Brounde Robert husbandman 602687 602687 Brounde, Robert, of Blake Toryton, husbandman 1
5350342 2460228 2460228 defendant Allyslond John husbandman 602687 602687 Allyslond, John, of Blake Toryton, husbandman 3

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