names

28 rows where place_id = 593011

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610027 1870808 1870808 defendant Coo Richard yeoman 593011 593011 Coo, Richard, of Asshell, yeoman 2
3610031 1870809 1870809 defendant Coo Richard yeoman 593011 593011 Coo, Richard, of Asshell, yeoman 2
3614659 1872238 1872238 plaintiff Bullyngbroke John   593011 593011 Bullyngbroke, John, of Asshell 0
3916493 1995893 1995893 defendant Covyll James laborer 593011 593011 Covyll, James, of Asshell, laborer 2
3929537 2000228 2000228 plaintiff Cannon John   593011 593011 Cannon, John, of Asshell 0
3948001 2006364 2006364 defendant Roper George carpenter 593011 593011 Roper, George, of Asshell, carpenter 0
3948002 2006364 2006364 defendant Barnard Agnes widow 593011 593011 Barnard, Agnes, of Asshell, widow 1
3958663 2010104 2010104 defendant Warde John yeoman 593011 593011 Warde, John, of Asshell, yeoman 4
3967923 2013409 2013409 plaintiff Canon John, senior   593011 593011 Canon, John, senior, of Asshell 0
4123126 2068567 2068567 defendant Cannon John husbandman 593011 593011 Cannon, John, of Asshell, husbandman 0
4247730 2112222 2112222 defendant Crane William yeoman 593011 593011 Crane, William, of Asshell, yeoman 0
4881124 2321004 2321004 defendant Rede Thomas husbandman 593011 593011 Rede, Thomas, of Asshell, husbandman 1
4917526 2331995 2331995 defendant Coo Henry yeoman 593011 593011 Coo, Henry, of Asshell, yeoman 3
5028142 2365102 2365102 defendant Oldman John yeoman 593011 593011 Oldman, John, of Asshell, yeoman 0
5033732 2366744 2366744 defendant Oldman John yeoman 593011 593011 Oldman, John, of Asshell, yeoman 2
5074735 2378948 2378948 defendant Oldeman John husbandman 593011 593011 Oldeman, John, of Asshell, husbandman 0
5074783 2378961 2378961 defendant Bradenham Thomas yeoman 593011 593011 Bradenham, Thomas, of Asshell, yeoman 3
5074784 2378961 2378961 defendant Lpngman Thomas yeoman 593011 593011 Lpngman, Thomas, of Asshell, yeoman 4
5186591 2411827 2411827 defendant Malvern Nicholas yeoman 593011 593011 Malvern, Nicholas, of Asshell, yeoman 0
5234223 2425597 2425597 defendant Malverne Nicholas, senior yeoman 593011 593011 Malverne, Nicholas, senior, of Asshell, yeoman 0
5312953 2448905 2448905 defendant Smyth Robert husbandman 593011 593011 Smyth, Robert, of Asshell, husbandman 0
5373173 2467208 2467208 plaintiff Marchall Margery widow 593011 593011 Marchall, Margery, of Asshell, widow 0
5561848 2523453 2523453 defendant Baldewyn Thomas husbandman 593011 593011 Baldewyn, Thomas, of Asshell, husbandman 0
5603951 2536102 2536102 defendant Legge John gent 593011 593011 Legge, John, of Asshell, gent 2
5625494 2551918 2551918 plaintiff Malwern Nicholas   593011 593011 Malwern, Nicholas, of Asshell 0
5625496 2551918 2551918 defendant Osberne John laborer 593011 593011 Osberne, John, of Asshell, laborer 1
5627968 2552717 2552717 defendant Coo Robert   593011 593011 Coo, Robert, of Asshell, bailiff 2
5627969 2552717 2552717 defendant Coo Richard yeoman 593011 593011 Coo, Richard, of Asshell, yeoman 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);