names

45 rows where place_id = 662110

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3963817 2011947 2011947 defendant Stevans Gregory yeoman 662110 662110 Stevans, Gregory, of Axminster, yeoman 2
4184818 2090199 2090199 defendant Tucker John gent 662110 662110 Tucker, John, of Axminster, gent 0
4208311 2098453 2098453 defendant Longe William merchant 662110 662110 Longe, William, of Axminster, merchant 1
4303648 2131401 2131401 defendant Forde Richard (legal representative) 662110 662110 Forde, Richard, of Axminster, executors of 1
4305173 2131947 2131947 defendant Strete George yeoman 662110 662110 Strete, George, of Axminster, yeoman 0
4305174 2131947 2131947 defendant Strete Thomas yeoman 662110 662110 Strete, Thomas, of Axminster, yeoman 1
4306957 2132574 2132574 defendant Longe Thomas mercer 662110 662110 Longe, Thomas, of Axminster, mercer 0
4307903 2132906 2132906 defendant Burche alias Sherwoode Richard victualer 662110 662110 Burche alias Sherwoode, Richard, of Axminster, victualer 0
4307904 2132906 2132906 defendant Burche Christopher tailor 662110 662110 Burche, Christopher, of Axminster, tailor 1
4316818 2136000 2136000 defendant Tucker John merchant 662110 662110 Tucker, John, of Axminster, merchant 0
4323159 2138159 2138159 defendant Sadler Thomas husbandman 662110 662110 Sadler, Thomas, of Axminster, husbandman 2
4364256 2152277 2152277 defendant Pynne Wlter yeoman 662110 662110 Pynne, Wlter, of Axminster, yeoman 0
4364257 2152277 2152277 defendant Wyllyams Robert shoemaker 662110 662110 Wyllyams, Robert, of Axminster, shoemaker 1
4364258 2152277 2152277 defendant Tanner William weaver 662110 662110 Tanner, William, of Axminster, weaver 2
4397207 2163641 2163641 defendant Harte John clothier 662110 662110 Harte, John, of Axminster, clothier 0
4476962 2193452 2193452 defendant Skynnere John   662110 662110 Skynnere, John, of Axminster 1
4517314 2205815 2205815 defendant Toukere Adam   662110 662110 Toukere, Adam, of Axminster 1
4537944 2212151 2212151 defendant Skittysshe Walter skinner 662110 662110 Skittysshe, Walter, of Axminster, skinner 2
4576020 2223995 2223995 defendant Soutere Robert   662110 662110 Soutere, Robert, of Axminster 0
4684690 2260813 2260813 defendant Boigher Thomas merchant 662110 662110 Boigher, Thomas, of Axminster, merchant 0
4710391 2268604 2268604 defendant Aryll William laborer 662110 662110 Aryll, William, of Axminster, laborer 0
4710395 2268605 2268605 defendant Tryll William laborer 662110 662110 together with Tryll, William, of Axminster, laborer 1
4712306 2269163 2269163 defendant Helye Walter   662110 662110 Helye, Walter, of Axminster 0
4721346 2272007 2272007 defendant Colmlond Richard husbandman 662110 662110 Colmlond, Richard, of Axminster, husbandman 0
4733278 2275585 2275585 defendant Plommer Walter plumber 662110 662110 Plommer, Walter, of Axminster, plumber 2
4735051 2276112 2276112 plaintiff Smyth John   662110 662110 Smyth, John, of Axminster 0
4735052 2276112 2276112 defendant Mathu John clerk 662110 662110 Mathu, John, of Axminster, clerk 0
4768859 2286239 2286239 defendant Sowey John husbandman 662110 662110 Sowey, John, of Axminster, husbandman 0
4769415 2286408 2286408 defendant Crolle Thomas ostler 662110 662110 Crolle, Thomas, of Axminster, ostler 1
4806141 2298129 2298129 defendant Keche William husbandman 662110 662110 Keche, William, of Axminster, husbandman 1
4821231 2302721 2302721 plaintiff Rogger William   662110 662110 Rogger, William, of Axminster 0
4851812 2312004 2312004 defendant Lederad Roger esq 662110 662110 Lederad, Roger, of Axminster, esq 0
4851814 2312004 2312004 defendant More Philip yeoman 662110 662110 More, Philip, of Axminster, yeoman 2
4851817 2312005 2312005 defendant Lederad Roger esq 662110 662110 Lederad, Roger, of Axminster, esq 0
5005742 2358575 2358575 defendant Lowde William yeoman 662110 662110 Lowde, William, of Axminster, yeoman 0
5006187 2358701 2358701 defendant Bateman John husbandman 662110 662110 Bateman, John, of Axminster, husbandman 0
5108899 2389022 2389022 defendant Parrok William husbandman 662110 662110 together with Parrok, William, of Axminster, husbandman 1
5130944 2395531 2395531 defendant Parrok William husbandman 662110 662110 Parrok, William, of Axminster, husbandman 0
5180377 2410002 2410002 defendant Lokyer John smith 662110 662110 Lokyer, John, of Axminster, smith 0
5194445 2414101 2414101 defendant Tryvet Robert   662110 662110 Tryvet, Robert, of Axminster, Devon tailor 0
5197394 2414982 2414982 defendant Hembury John clerk 662110 662110 Hembury, John, of Axminster, clerk 1
5200816 2415997 2415997 defendant Holeway John smith 662110 662110 Holeway, John, of Axminster, smith 0
5211645 2419143 2419143 defendant Holeway John smith 662110 662110 Holeway, John, of Axminster, smith 0
5408971 2477645 2477645 defendant Chope John chapman 662110 662110 Chope, John, of Axminster, chapman 2
5454731 2491338 2491338 defendant Coppe Thomas chapman 662110 662110 Coppe, Thomas, of Axminster, chapman 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);