names

52 rows where place_id = 599030

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634918 1905722 1905722 defendant Pister Robert gent 599030 599030 Pister, Robert, of Mottesfont, gent 2
4235503 2107985 2107985 defendant Griffin Thomas gent 599030 599030 Griffin, Thomas, of Mottesfont, gent 3
4406115 2166609 2166609 defendant Wilton John husbandman 599030 599030 Wilton, John, of Mottesfont, husbandman 0
4406116 2166609 2166609 defendant Foxe William husbandman 599030 599030 Foxe, William, of Mottesfont, husbandman 1
4845576 2310127 2310127 defendant Bailly John husbandman 599030 599030 Bailly, John, of Mottesfont, husbandman 0
4845577 2310127 2310127 defendant Carpenter John clerk 599030 599030 Carpenter, John, of Mottesfont, clerk 1
4851739 2311981 2311981 defendant Hakker John laborer 599030 599030 Hakker, John, of Mottesfont, laborer 0
4865823 2316280 2316280 defendant Escote Richard yeoman 599030 599030 Escote, Richard, of Mottesfont, yeoman 0
4865824 2316280 2316280 defendant Escote William laborer 599030 599030 Escote, William, of Mottesfont, laborer 1
4871764 2318139 2318139 defendant Escote Richard yeoman 599030 599030 Escote, Richard, of Mottesfont, yeoman 0
4871765 2318139 2318139 defendant Escote William laborer 599030 599030 Escote, William, of Mottesfont, laborer 1
4871766 2318139 2318139 defendant Kydell Philip tailor 599030 599030 Kydell, Philip, of Mottesfont, tailor 2
4871767 2318139 2318139 defendant Weybole John tanner 599030 599030 Weybole, John, of Mottesfont, tanner 3
4871768 2318139 2318139 defendant Carpynter Richard husbandman 599030 599030 Carpynter, Richard, of Mottesfont, husbandman 4
4871769 2318139 2318139 defendant Bocher John butcher 599030 599030 Bocher, John, of Mottesfont, butcher 5
4873137 2318551 2318551 defendant Bayly John husbandman 599030 599030 Bayly, John, of Mottesfont, husbandman 0
4873138 2318551 2318551 defendant Carpenter John clerk 599030 599030 Carpenter, John, of Mottesfont, clerk 1
4893025 2324539 2324539 defendant Carpenter John husbandman 599030 599030 Carpenter, John, of Mottesfont, husbandman 1
4893061 2324549 2324549 defendant Graswell John   599030 599030 Graswell, John, of Mottesfont, Hants clerk 0
4893064 2324549 2324549 defendant Sturmy Robert skinner 599030 599030 Sturmy, Robert, of Mottesfont, skinner 3
4918021 2332153 2332153 plaintiff Graswell John   599030 599030 Graswell, John, of Mottesfont, parson & clerk 0
4999690 2356784 2356784 defendant Petrich Peter husbandman 599030 599030 Petrich, Peter, of Mottesfont, husbandman 0
5013304 2360729 2360729 defendant Carpenter Richard yeoman 599030 599030 Carpenter, Richard, of Mottesfont, yeoman 0
5106414 2388312 2388312 defendant Markes Robert yeoman 599030 599030 Markes, Robert, of Mottesfont, yeoman 16
5106415 2388312 2388312 defendant Markes John yeoman 599030 599030 Markes, John, of Mottesfont, yeoman 17
5106416 2388312 2388312 defendant Markes Thomas yeoman 599030 599030 Markes, Thomas, of Mottesfont, yeoman 18
5106417 2388312 2388312 defendant Thornhill William yeoman 599030 599030 Thornhill, William, of Mottesfont, yeoman 19
5106418 2388312 2388312 defendant Langford Thomas yeoman 599030 599030 Langford, Thomas, of Mottesfont, yeoman 20
5106421 2388312 2388312 defendant Mowele Thomas   599030 599030 Mowele, Thomas, of Mottesfont, groom 23
5106422 2388312 2388312 defendant Mowele John   599030 599030 Mowele, John, of Mottesfont, groom 24
5106464 2388323 2388323 defendant Markes Robert yeoman 599030 599030 Markes, Robert, of Mottesfont, yeoman 4
5118252 2391777 2391777 defendant Markes Robert yeoman 599030 599030 Markes, Robert, of Mottesfont, yeoman 3
5118253 2391777 2391777 defendant Markes John yeoman 599030 599030 Markes, John, of Mottesfont, yeoman 4
5118254 2391777 2391777 defendant Markes Thomas yeoman 599030 599030 Markes, Thomas, of Mottesfont, yeoman 5
5118255 2391777 2391777 defendant Thornhill William yeoman 599030 599030 Thornhill, William, of Mottesfont, yeoman 6
5118259 2391777 2391777 defendant Mowele Thomas   599030 599030 Mowele, Thomas, of Mottesfont, groom 10
5118260 2391777 2391777 defendant Mowele John   599030 599030 Mowele, John, of Mottesfont, groom 11
5191864 2413354 2413354 defendant Carpenter John   599030 599030 Carpenter, John, of Mottesfont, holy water clerk 4
5191870 2413355 2413355 defendant Carpenter John   599030 599030 Carpenter, John, of Mottesfont, holy water clerk 4
5207541 2417945 2417945 defendant Carpenter John   599030 599030 Carpenter, John, of Mottesfont, holy water clerk 4
5207547 2417946 2417946 defendant Carpenter John   599030 599030 Carpenter, John, of Mottesfont, holy water clerk 4
5305170 2446552 2446552 plaintiff Lahaye Richard de   599030 599030 Lahaye, Richard de, of Mottesfont, parson 0
5310786 2448264 2448264 plaintiff (not given) William prior of Westarre 599030 599030 Westarre, William, of Mottesfont, prior of the house & church of Holy Trinity 0
5310789 2448265 2448265 plaintiff (not given) William prior of Westarre 599030 599030 Westarre, William, of Mottesfont, prior of the house & church of Holy Trinity 0
5310793 2448266 2448266 plaintiff (not given) William prior of Westarre 599030 599030 Westarre, William, of Mottesfont, prior of the house & church of Holy Trinity 0
5310829 2448275 2448275 plaintiff (not given) William prior of Westcarre 599030 599030 Westcarre, William, of Mottesfont, prior of the house & church of Holy Trinity 0
5365648 2464923 2464923 defendant Chamflour John smith 599030 599030 Chamflour, John, of Mottesfont, smith 1
5365653 2464924 2464924 defendant Chamflour John smith 599030 599030 Chamflour, John, of Mottesfont, smith 2
5394404 2473465 2473465 plaintiff (not given)   prior of Westacre, _ 599030 599030 Westacre, _, of Mottesfont, prior of Holy Trinity house & church 0
5423442 2481971 2481971 defendant Carpenter William husbandman 599030 599030 Carpenter, William, of Mottesfont, husbandman 1
5462751 2493770 2493770 defendant (not given) William prior of Westcarre 599030 599030 Westcarre, William, of Mottesfont, prior of the canons 0
5474282 2497287 2497287 defendant Westcarre William   599030 599030 Westcarre, William, of Mottesfont, prior 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);