names

36 rows where place_id = 604101

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3656852 1912400 1912400 defendant Reche Robert yeoman 604101 604101 Reche, Robert, of Tamerton, yeoman 0
3690020 1923037 1923037 defendant Brusey Thomas husbandman 604101 604101 Brusey, Thomas, of Tamerton, husbandman 0
3715841 1931240 1931240 defendant Escotte John husbandman 604101 604101 Escotte, John, of Tamerton, husbandman 0
3733388 1936678 1936678 defendant Cause Edward husbandman 604101 604101 Cause, Edward, of Tamerton, husbandman 0
3768654 1947843 1947843 defendant Furlong John, junior husbandman 604101 604101 Furlong, John, junior, of Tamerton, husbandman 4
3768655 1947843 1947843 defendant Champyn Walter husbandman 604101 604101 Champyn, Walter, of Tamerton, husbandman 5
3768656 1947843 1947843 defendant Bonde Richard husbandman 604101 604101 Bonde, Richard, of Tamerton, husbandman 6
3793857 1955946 1955946 defendant Upcote Richard husbandman 604101 604101 Upcote, Richard, of Tamerton, husbandman 1
3839311 1970223 1970223 defendant Morgan John gent 604101 604101 Morgan, John, of Tamerton, gent 0
3848029 1972957 1972957 defendant Face William husbandman 604101 604101 Face, William, of Tamerton, husbandman 7
3855079 1975217 1975217 defendant Escott John, senior   604101 604101 Escott, John, senior, of Tamerton, mason 2
3932319 2001113 2001113 defendant Waye alias Crokehorne Thomasina widow 604101 604101 Waye alias Crokehorne, Thomasina, of Tamerton, widow 0
3971991 2014763 2014763 plaintiff Forlonge John, the elder (legal representative) 604101 604101 Forlonge, John, the elder, of Tamerton, executor of 0
4024967 2033593 2033593 plaintiff Bowler Hames husbandman 604101 604101 Bowler, Hames, of Tamerton, husbandman 0
4049707 2042334 2042334 plaintiff Vowler James husbandman 604101 604101 Vowler, James, of Tamerton, husbandman 0
4110765 2064108 2064108 defendant Spetygo Richard, senior husbandman 604101 604101 Spetygo, Richard, senior, of Tamerton, husbandman 1
4200158 2095608 2095608 defendant Crocker Robert gent 604101 604101 Crocker, Robert, of Tamerton, gent 2
4200162 2095609 2095609 defendant Crocker Robert gent 604101 604101 Crocker, Robert, of Tamerton, gent 2
4220416 2102643 2102643 defendant Upcott Richard gent 604101 604101 Upcott, Richard, of Tamerton, gent 3
4365859 2152825 2152825 defendant Upcott Richard gent 604101 604101 Upcott, Richard, of Tamerton, gent 0
4404244 2165991 2165991 defendant Upcott Richard gent 604101 604101 Upcott, Richard, of Tamerton, gent 0
4584690 2226633 2226633 plaintiff Gorges John   604101 604101 Gorges, John, of Tamerton 0
4621665 2237760 2237760 defendant atte Hole John   604101 604101 atte Hole, John, of Tamerton 4
4657908 2248358 2248358 defendant Grenehill John dyer 604101 604101 Grenehill, John, of Tamerton, dyer 0
4666113 2250868 2250868 defendant Fenman Roger husbandman 604101 604101 Fenman, Roger, of Tamerton, husbandman 1
5092302 2384128 2384128 defendant Perys William yeoman 604101 604101 Perys, William, of Tamerton, yeoman 0
5096483 2385403 2385403 defendant Uppehill William husbandman 604101 604101 Uppehill, William, of Tamerton, husbandman 0
5096486 2385404 2385404 defendant Uppehill William husbandman 604101 604101 Uppehill, William, of Tamerton, husbandman 0
5122873 2393123 2393123 defendant Belleworthy William (legal representative) 604101 604101 Belleworthy, William, of Tamerton, executors of 0
5169091 2406697 2406697 defendant Judde Thomas husbandman 604101 604101 Judde, Thomas, of Tamerton, husbandman 0
5169092 2406697 2406697 defendant Estecote Walter husbandman 604101 604101 Estecote, Walter, of Tamerton, husbandman 1
5304453 2446329 2446329 defendant Chapman John chaplain 604101 604101 Chapman, John, of Tamerton, chaplain 2
5304454 2446329 2446329 defendant Upcote Robert husbandman 604101 604101 Upcote, Robert, of Tamerton, husbandman 3
5478513 2498601 2498601 defendant Lange Thomas, junior husbandman 604101 604101 Lange, Thomas, junior, of Tamerton, husbandman 3
5478514 2498601 2498601 defendant Uppecote Robert husbandman 604101 604101 Uppecote, Robert, of Tamerton, husbandman 4
5478515 2498601 2498601 defendant Fraunceys Robert husbandman 604101 604101 Fraunceys, Robert, of Tamerton, husbandman 5

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);