names

36 rows where place_id = 595871

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3622194 1874477 1874477 defendant Gukker James husbandman 595871 595871 Gukker, James, of St Meryn, husbandman 0
3711448 1929886 1929886 defendant Davy Stephen husbandman 595871 595871 Davy, Stephen, of St Meryn, husbandman 0
3711449 1929886 1929886 defendant Davy George husbandman 595871 595871 Davy, George, of St Meryn, husbandman 1
3783964 1952763 1952763 defendant Retaleck Richard yeoman 595871 595871 Retaleck, Richard, of St Meryn, yeoman 0
3820909 1964436 1964436 defendant Olyver John yeoman 595871 595871 Olyver, John, of St Meryn, yeoman 0
3820910 1964436 1964436 defendant Payn Thomas husbandman 595871 595871 Payn, Thomas, of St Meryn, husbandman 1
3820911 1964436 1964436 defendant Pollard Thomas husbandman 595871 595871 Pollard, Thomas, of St Meryn, husbandman 2
3863172 1977885 1977885 defendant Remfraye John husbandman 595871 595871 Remfraye, John, of St Meryn, husbandman 0
3870600 1980408 1980408 defendant Harvy Robert husbandman 595871 595871 Harvy, Robert, of St Meryn, husbandman 0
3880161 1983618 1983618 defendant Perkyn John yeoman 595871 595871 Perkyn, John, of St Meryn, yeoman 0
3880162 1983618 1983618 defendant Perkyn Thomasine widow 595871 595871 Perkyn, Thomasine, of St Meryn, widow 1
3892508 1987741 1987741 defendant Alan "Udonem" husbandman 595871 595871 Alan, "Udonem", of St Meryn, husbandman 0
3892516 1987742 1987742 defendant Mychell Benedict husbandman 595871 595871 Mychell, Benedict, of St Meryn, husbandman 0
3967870 2013389 2013389 defendant Carthewe Henry husbandman 595871 595871 Carthewe, Henry, of St Meryn, husbandman 1
3967871 2013389 2013389 defendant Wythyell Roger husbandman 595871 595871 Wythyell, Roger, of St Meryn, husbandman 2
3967872 2013389 2013389 defendant Wythyell Richard husbandman 595871 595871 Wythyell, Richard, of St Meryn, husbandman 3
3980477 2017788 2017788 defendant Baker Stephen husbandman 595871 595871 Baker, Stephen, of St Meryn, husbandman 1
3980478 2017788 2017788 defendant Baker John, junior husbandman 595871 595871 Baker, John, junior, of St Meryn, husbandman 2
4004397 2026352 2026352 defendant Parkyn John husbandman 595871 595871 Parkyn, John, of St Meryn, husbandman 0
4071668 2050163 2050163 defendant Werye William husbandman 595871 595871 Werye, William, of St Meryn, husbandman 0
4081627 2053732 2053732 defendant Baker William husbandman 595871 595871 Baker, William, of St Meryn, husbandman 0
4081628 2053732 2053732 defendant Baker Margaret widow 595871 595871 Baker, Margaret, of St Meryn, widow 1
4081629 2053732 2053732 defendant Harry Philip husbandman 595871 595871 Harry, Philip, of St Meryn, husbandman 2
4085952 2055252 2055252 defendant Glyn Nicholas gent 595871 595871 Glyn, Nicholas, of St Meryn, gent 0
4097582 2059464 2059464 defendant Michell John husbandman 595871 595871 Michell, John, of St Meryn, husbandman 0
4122042 2068186 2068186 defendant Trevethvan Thomas gent 595871 595871 Trevethvan, Thomas, of St Meryn, gent 0
4122043 2068186 2068186 defendant Parkyn William yeoman 595871 595871 Parkyn, William, of St Meryn, yeoman 1
4122044 2068186 2068186 defendant Comb John smith 595871 595871 Comb, John, of St Meryn, smith 2
4126319 2069704 2069704 defendant Carawe Nicholas husbandman 595871 595871 Carawe, Nicholas, of St Meryn, husbandman 0
4145247 2076498 2076498 defendant Trevethvan Thomas gent 595871 595871 Trevethvan, Thomas, of St Meryn, gent 0
4145248 2076498 2076498 defendant Parkyn Thomas husbandman or yeoman 595871 595871 Parkyn, Thomas, of St Meryn, husbandman or yeoman 1
4145249 2076498 2076498 defendant Comb John husbandman 595871 595871 Comb, John, of St Meryn, husbandman 2
4222769 2103453 2103453 defendant Olver Nicholas husbandman 595871 595871 Olver, Nicholas, of St Meryn, husbandman 3
4248143 2112367 2112367 defendant Olver Nicholas husbandman 595871 595871 Olver, Nicholas, of St Meryn, husbandman 3
4322101 2137810 2137810 defendant Lanyon John esq 595871 595871 Lanyon, John, of St Meryn, esq 0
5571435 2526199 2526199 defendant Wyllyam James husbandman 595871 595871 Wyllyam, James, of St Meryn, 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);