names

36 rows where place_id = 600979

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3643407 1908362 1908362 defendant Petersfeld Walter yeoman 600979 600979 Petersfeld, Walter, of Plympton St Mary, yeoman 2
3650643 1910566 1910566 defendant Strode William esq 600979 600979 Strode, William, of Plympton St Mary, esq 0
3734017 1936886 1936886 defendant Awton John husbandman 600979 600979 Awton, John, of Plympton St Mary, husbandman 0
3734111 1936917 1936917 defendant Jefferey Thomas laborer 600979 600979 Jefferey, Thomas, of Plympton St Mary, laborer 13
3885887 1985536 1985536 defendant Snellyng Robert yeoman 600979 600979 Snellyng, Robert, of Plympton St Mary, yeoman 2
3885892 1985537 1985537 defendant Snellyng Robert yeoman 600979 600979 Snellyng, Robert, of Plympton St Mary, yeoman 2
3895759 1988791 1988791 defendant Brokyn John husbandman 600979 600979 Brokyn, John, of Plympton St Mary, husbandman 0
3895760 1988791 1988791 defendant Brokyn Edward husbandman 600979 600979 Brokyn, Edward, of Plympton St Mary, husbandman 1
3895761 1988791 1988791 defendant Brokyn Christopher   600979 600979 Brokyn, Christopher, of Plympton St Mary, groom 2
3933782 2001593 2001593 defendant Maye Nicholas husbandman 600979 600979 Maye, Nicholas, of Plympton St Mary, husbandman 0
3975799 2016097 2016097 defendant Helyer Nicholas husbandman 600979 600979 Helyer, Nicholas, of Plympton St Mary, husbandman 0
3997763 2023956 2023956 defendant Ulcombe Baldwin (legal representative) 600979 600979 Ulcombe, Baldwin, of Plympton St Mary, husbandman, executor of 0
4008020 2027632 2027632 defendant Cornyshe John husbandman 600979 600979 Cornyshe, John, of Plympton St Mary, husbandman 0
4008022 2027633 2027633 defendant Marten William glover 600979 600979 Marten, William, of Plympton St Mary, glover 0
4008024 2027634 2027634 defendant Marten William glover 600979 600979 Marten, William, of Plympton St Mary, glover 0
4008025 2027634 2027634 defendant Suntor Thomas   600979 600979 Suntor, Thomas, of Plympton St Mary, groom 1
4008026 2027634 2027634 defendant Cornysshe John husbandman 600979 600979 Cornysshe, John, of Plympton St Mary, husbandman 2
4008028 2027635 2027635 defendant Sunter Thomas   600979 600979 Sunter, Thomas, of Plympton St Mary, groom 0
4015111 2030095 2030095 defendant Dyer Nicholas yeoman 600979 600979 Dyer, Nicholas, of Plympton St Mary, yeoman 0
4015112 2030095 2030095 defendant Pereman Thomas   600979 600979 Pereman, Thomas, of Plympton St Mary, groom 1
4015113 2030095 2030095 defendant Potter John   600979 600979 Potter, John, of Plympton St Mary, groom 2
4020578 2032088 2032088 plaintiff Wolcombe alias Bawden William (legal representative) 600979 600979 Wolcombe alias Bawden, William, of Plympton St Mary, yeoman, executor of 0
4030679 2035634 2035634 defendant Adams Roger tanner 600979 600979 Adams, Roger, of Plympton St mary, tanner 0
4054676 2044062 2044062 defendant Haywood John carpenter 600979 600979 Haywood, John, of Plympton St Mary, carpenter 0
4063990 2047402 2047402 defendant Treble alias Stephen Richard husbandman 600979 600979 Treble alias Stephen, Richard, of Plympton St Mary, husbandman 0
4065924 2048103 2048103 defendant Baron John, senior husbandman 600979 600979 Baron, John, senior, of Plympton St Mary, husbandman 0
4102354 2061131 2061131 defendant Collyns Tobias yeoman 600979 600979 Collyns, Tobias, of Plympton St Mary, yeoman 2
4103983 2061696 2061696 defendant Barrye William yeoman 600979 600979 Barrye, William, of Plympton St Mary, yeoman 0
4103985 2061697 2061697 defendant Coffyn Philip   600979 600979 Coffyn, Philip, of Plympton St Mary, mason 0
4194593 2093667 2093667 defendant Hyngeston William husbandman 600979 600979 Hyngeston, William, of Plympton St Mary, husbandman 0
4217635 2101662 2101662 defendant Tower William husbandman 600979 600979 Tower, William, of Plympton St Mary, husbandman 0
4318401 2136544 2136544 defendant Tower William husbandman 600979 600979 Tower, William, of Plympton St Mary, husbandman 0
4319518 2136939 2136939 defendant Gregory Thomas   600979 600979 Gregory, Thomas, of Plympton St Mary, groom 0
4383694 2159255 2159255 defendant Habs Richard gent 600979 600979 Habs, Richard, of Plympton St Mary, gent 0
4391631 2161817 2161817 defendant Kelley William painter 600979 600979 Kelley, William, of Plympton St Mary, painter 0
4391633 2161818 2161818 defendant Kelley William painter 600979 600979 Kelley, William, of Plympton St Mary, painter 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);