names

35 rows where place_id = 589195

✎ 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
3596865 1866655 1866655 defendant Botour John, senior husbandman 589195 589195 Botour, John, senior, of South Byrlyngham, husbandman 0
3598280 1867093 1867093 plaintiff Smyth Thomas   589195 589195 Smyth, Thomas, of South Byrlyngham 0
3598282 1867094 1867094 plaintiff Smyth Thomas   589195 589195 Smyth, Thomas, of South Byrlyngham 0
3907264 1992721 1992721 plaintiff Osborn Edward   589195 589195 Osborn, Edward, of South Byrlyngham 0
3927221 1999440 1999440 defendant Towneshend John, senior yeoman 589195 589195 Towneshend, John, senior, of South Byrlyngham, yeoman 2
4404708 2166143 2166143 defendant Yonger Robert gent 589195 589195 Yonger, Robert, of South Byrlyngham, gent 1
4889742 2323586 2323586 defendant Palmere Thomas husbandman 589195 589195 Palmere, Thomas, of South Byrlyngham, husbandman 1
4961045 2345264 2345264 defendant Roo Richard husbandman 589195 589195 Roo, Richard, of South Byrlyngham, husbandman 0
4978560 2350539 2350539 defendant Rithwys Hugh   589195 589195 Rithwys, Hugh, of South Byrlyngham, franklin 0
4978561 2350539 2350539 defendant Botour John yeoman 589195 589195 Botour, John, of South Byrlyngham, yeoman 1
4978562 2350539 2350539 defendant Smyth Henry yeoman 589195 589195 Smyth, Henry, of South Byrlyngham, yeoman 2
4989079 2353672 2353672 defendant Wryte Roger husbandman 589195 589195 Wryte, Roger, of South Byrlyngham, husbandman 0
5318617 2450660 2450660 defendant Roo John husbandman 589195 589195 Roo, John, of South Byrlyngham, husbandman 2
5338125 2456493 2456493 defendant Herle Geoffrey yeoman 589195 589195 Herle, Geoffrey, of South Byrlyngham, yeoman 3
5355454 2461782 2461782 defendant Warner Robert husbandman 589195 589195 Warner, Robert, of South Byrlyngham, husbandman 0
5364794 2464653 2464653 defendant Hardyngham William clerk 589195 589195 Hardyngham, William, of South Byrlyngham, clerk 3
5364800 2464654 2464654 defendant Hardyngham William clerk 589195 589195 Hardyngham, William, of South Byrlyngham, clerk 3
5371863 2466784 2466784 defendant Pye Thomas laborer 589195 589195 Pye, Thomas, of South Byrlyngham, laborer 1
5383527 2470371 2470371 defendant Warner Robert yeoman 589195 589195 Warner, Robert, of South Byrlyngham, yeoman 2
5395286 2473726 2473726 defendant Warner Robert yeoman 589195 589195 Warner, Robert, of South Byrlyngham, yeoman 2
5405322 2476607 2476607 plaintiff Baret Thomas, senior   589195 589195 Baret, Thomas, senior, of South Byrlyngham 1
5405325 2476607 2476607 defendant Warner Robert yeoman 589195 589195 Warner, Robert, of South Byrlyngham, yeoman 0
5405327 2476607 2476607 defendant Roo John yeoman 589195 589195 Roo, John, of South Byrlyngham, yeoman 2
5407447 2477200 2477200 plaintiff Warner Robert yeoman 589195 589195 Warner, Robert, of South Byrlyngham, yeoman 0
5422248 2481603 2481603 defendant Warner Robert yeoman 589195 589195 Warner, Robert, of South Byrlyngham, yeoman 0
5436255 2485780 2485780 defendant Warnere Robert husbandman 589195 589195 Warnere, Robert, of South Byrlyngham, husbandman 0
5474013 2497202 2497202 defendant Warner Robert husbandman 589195 589195 Warner, Robert, of South Byrlyngham, husbandman 3
5489333 2501698 2501698 defendant Barret Thomas yeoman 589195 589195 Barret, Thomas, of South Byrlyngham, yeoman 0
5500181 2505007 2505007 defendant Warner Robert husbandman 589195 589195 Warner, Robert, of South Byrlyngham, husbandman 0
5500182 2505007 2505007 defendant Warner William laborer 589195 589195 Warner, William, of South Byrlyngham, laborer 1
5500183 2505007 2505007 defendant Colman William laborer 589195 589195 Colman, William, of South Byrlyngham, laborer 2
5505057 2506491 2506491 defendant Warner Robert husbandman 589195 589195 Warner, Robert, of South Byrlyngham, husbandman 0
5505058 2506491 2506491 defendant Boton John husbandman 589195 589195 Boton, John, of South Byrlyngham, husbandman 1
5560474 2523021 2523021 defendant Roo John (legal representative) 589195 589195 Roo, John, of South Byrlyngham, yeoman, executrix of 0
5560485 2523025 2523025 defendant Roo John (legal representative) 589195 589195 Roo, John, of South Byrlyngham, yeoman, executrix of 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);