names

36 rows where place_id = 594775

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617568 1873118 1873118 defendant Wolford John clothman 594775 594775 Wolford, John, of Mellys, Soms, clothman 2
3620644 1874036 1874036 defendant Torre Robert clothier 594775 594775 Torre, Robert, of Mellys, Soms, clothier 0
3621607 1874298 1874298 defendant Torr Robert clothman 594775 594775 Torr, Robert, of Mellys, Soms, clothman 3
3621610 1874299 1874299 defendant Torr Robert clothman 594775 594775 Torr, Robert, of Mellys, Soms, clothman 1
3657073 1912475 1912475 defendant Payne John yeoman 594775 594775 Payne, John, of mellys, Soms, yeoman 0
3831752 1967831 1967831 defendant Arnold William clothier 594775 594775 Arnold, William, of Mellys, Soms, clothier 1
4654605 2247322 2247322 defendant Cornyssh Edward (legal representative) 594775 594775 Cornyssh, Edward, of Mellys, Soms, husbandman, executors of 1
4654610 2247323 2247323 defendant Cornyssh Edward husbandman 594775 594775 Cornyssh, Edward, of Mellys, Soms, husbandman 0
4694622 2263815 2263815 defendant Cornyssh Edward husbandman 594775 594775 Cornyssh, Edward, of Mellys, Soms, husbandman 0
4798535 2295720 2295720 defendant Pilton William husbandman 594775 594775 Pilton, William, of Mellys, Soms, husbandman 0
4798537 2295721 2295721 defendant Pilton William husbandman 594775 594775 Pilton, William, of Mellys, Soms, husbandman 0
4852355 2312159 2312159 defendant Samuell John gent 594775 594775 Samuell, John, of Mellys, Soms, gent 0
5003435 2357901 2357901 defendant Gybbys John chapman 594775 594775 Gybbys, John, of Mellys, Soms, chapman 2
5003857 2358019 2358019 defendant Gybbys John chapman 594775 594775 Gybbys, John, of Mellys, Soms, chapman 2
5045070 2370158 2370158 defendant Rede Lewis clerk 594775 594775 Rede, Lewis, of Mellys, Soms, clerk 0
5045698 2370347 2370347 defendant Rede Lewis clerk 594775 594775 Rede, Lewis, of Mellys, Soms, clerk 1
5171795 2407471 2407471 defendant Torre William clothier 594775 594775 Torre, William, of Mellys, Soms, clothier 0
5354422 2461451 2461451 defendant Torre John clothier 594775 594775 Torre, John, of Mellys, Soms, clothier 3
5354427 2461452 2461452 defendant Torre John clothier 594775 594775 Torre, John, of Mellys, Soms, clothier 3
5392748 2472994 2472994 defendant Torre Robert clothier 594775 594775 Torre, Robert, of Mellys, Soms, clothier 0
5392753 2472996 2472996 defendant Wytkome John clothier 594775 594775 Wytkome, John, of Mellys, Soms, clothier 0
5405831 2476741 2476741 defendant Torre Robert clothier 594775 594775 Torre, Robert, of Mellys, Soms, clothier 0
5405836 2476743 2476743 defendant Wytkome John, senior clothier 594775 594775 Wytkome, John, senior, of Mellys, Soms, clothier 0
5418919 2480582 2480582 defendant Wydcombe John clothier 594775 594775 Wydcombe, John, of Mellys, Soms, clothier 0
5423290 2481927 2481927 defendant Plesans Thomas clothier 594775 594775 Plesans, Thomas, of Mellys, Soms, clothier 1
5437027 2486012 2486012 defendant Wydcombe John clothier 594775 594775 Wydcombe, John, of Mellys, Soms, clothier 0
5459158 2492638 2492638 defendant Dyker John gent 594775 594775 Dyker, John, of Mellys, Soms, gent 0
5470803 2496193 2496193 defendant Dyker John gent 594775 594775 Dyker, John, of Mellys, Soms, gent 0
5470805 2496194 2496194 defendant Dyker John gent 594775 594775 Dyker, John, of Mellys, Soms, gent 0
5489268 2501673 2501673 defendant Horner Robert yeoman 594775 594775 Horner, Robert, of Mellys, Soms, yeoman 0
5504263 2506249 2506249 defendant Horner Robert yeoman 594775 594775 Horner, Robert, of Mellys, Soms, yeoman 0
5519816 2511035 2511035 defendant Torre Robert yeoman 594775 594775 Torre, Robert, of Mellys, Soms, yeoman 0
5521184 2511443 2511443 defendant Dorsett William clothmaker 594775 594775 Dorsett, William, of Mellys, Soms, clothmaker 0
5522566 2511881 2511881 defendant Torre Robert yeoman 594775 594775 Torre, Robert, of Mellys, Soms, yeoman 0
5556733 2521928 2521928 defendant Robyns John clothmaker 594775 594775 (Robyns, John, of Mellys, Soms, clothmaker 1
5604761 2536351 2536351 defendant Parkyns Edward gent 594775 594775 Parkyns, Edward, of Mellys, Soms, gent 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);