names

27 rows where place_id = 595155

✎ 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
3619160 1873596 1873596 defendant Nuton Thomas tailor 595155 595155 Nuton, Thomas, of Hellond, tailor 1
3619161 1873596 1873596 defendant Beste John yeoman 595155 595155 Beste, John, of Hellond, yeoman 2
3619162 1873596 1873596 defendant Walke Richard husbandman 595155 595155 Walke, Richard, of Hellond, husbandman 3
3683221 1920871 1920871 defendant Mellenecke John turner 595155 595155 Mellenecke, John, of Hellond, turner 0
3694069 1924349 1924349 defendant Arundell Roger esq 595155 595155 Arundell, Roger, of Hellond, esq 0
3756364 1943960 1943960 plaintiff Arundell Roger esq 595155 595155 Arundell, Roger, of Hellond, esq 0
3756366 1943961 1943961 plaintiff Arundell Roger esq 595155 595155 Arundell, Roger, of Hellond, esq 0
3778427 1950967 1950967 defendant Hopkyn William clerk 595155 595155 Hopkyn, William, of Hellond, clerk 0
3898538 1989721 1989721 defendant Edy Robert husbandman 595155 595155 Edy, Robert, of Hellond, husbandman 0
3941418 2004137 2004137 defendant Lyukye Richard husbandman 595155 595155 Lyukye, Richard, of Hellond, husbandman 0
4235241 2107886 2107886 defendant Best Henry husbandman 595155 595155 Best, Henry, of Hellond, husbandman 1
4398317 2164018 2164018 defendant Opye Thomas gent 595155 595155 Opye, Thomas, of Hellond, or of Penhergard, Cornw, gent 0
4680084 2259381 2259381 defendant Colyn Thomas esq 595155 595155 Colyn, Thomas, of Hellond, esq 0
4732319 2275286 2275286 defendant Colyn Thomas gent 595155 595155 Colyn, Thomas, of Hellond, gent 0
4799532 2296032 2296032 defendant Colyn Thomas (legal representative) 595155 595155 Colyn, Thomas, of Hellond, esq, executors of 0
4799533 2296032 2296032 defendant Colyn Ingreta widow 595155 595155 (Colyn, Ingreta, of Hellond, widow 1
4846980 2310562 2310562 defendant Colyn John   595155 595155 Colyn, John, of Hellond 0
4851888 2312025 2312025 defendant Kytte John husbandman 595155 595155 Kytte, John, of Hellond, husbandman 1
4874676 2319022 2319022 defendant Colyn John   595155 595155 Colyn, John, of Hellond 0
4926742 2334784 2334784 defendant Colyn John   595155 595155 Colyn, John, of Hellond 0
4928760 2335421 2335421 defendant Luby Philip dyer 595155 595155 Luby, Philip, of Hellond, dyer 0
4951892 2342539 2342539 defendant Colyn John   595155 595155 Colyn, John, of Hellond 0
4952228 2342634 2342634 plaintiff Colyn John   595155 595155 Colyn, John, of Hellond 2
5003512 2357923 2357923 defendant Luky John dyer 595155 595155 Luky, John, of Hellond, dyer 0
5047533 2370881 2370881 defendant Luky Philip dyer 595155 595155 Luky, Philip, of Hellond, dyer 0
5069081 2377248 2377248 defendant Boyton Richard husbandman 595155 595155 Boyton, Richard, of Hellond, husbandman 5
5241469 2427705 2427705 defendant Russell John husbandman 595155 595155 Russell, John, of Hellond, husbandman 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);