names

24 rows where place_id = 662211

✎ 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
3964114 2012055 2012055 defendant ap Meredith alias Glover Lewis yeoman 662211 662211 ap Meredith alias Glover, Lewis, of Cardiff, Glamorgan, yeoman 0
3967272 2013183 2013183 defendant Wrenche John gent 662211 662211 Wrenche, John, of Cardiff, Glamorgan, gent 0
4034296 2036933 2036933 defendant Smythe John alderman 662211 662211 Smythe, John, of Cardiff, Glamorgan, alderman 0
4064963 2047754 2047754 defendant Harbert William gent 662211 662211 Harbert, William, of Cardiff, Glamorgan, gent 1
4066129 2048174 2048174 defendant Mott Thomas yeoman 662211 662211 Mott, Thomas, of Cardiff, Glamorgan, yeoman 0
4090760 2056984 2056984 defendant Thomas Jevan husbandman 662211 662211 Thomas, Jevan, of Cardiff, Glamorgan, husbandman 0
4107927 2063109 2063109 defendant Gibon Llewellen gent 662211 662211 Gibon, Llewellen, of Cardiff, Glamorgan, gent 0
4122777 2068437 2068437 defendant Gebon John gent 662211 662211 Gebon, John, of Cardiff, Glamorgan, gent 2
4162867 2082542 2082542 defendant Williams John gent 662211 662211 Williams, John, of Cardiff, Glamorgan, gent 53
4171839 2085610 2085610 defendant Gaskyn William yeoman 662211 662211 Gaskyn, William, of Cardiff, Glamorgan, yeoman 0
4237620 2108749 2108749 defendant Ranson or Rauson John chapman 662211 662211 Ranson or Rauson, John, of Cardiff, Glamorgan, chapman 0
4256262 2115072 2115072 defendant Johns Roger tailor 662211 662211 Johns, Roger, of Cardiff, Glamorgan, tailor 1
4259189 2116046 2116046 defendant Tanner John chapman 662211 662211 Tanner, John, of Cardiff, Glamorgan, chapman 2
4259194 2116047 2116047 defendant Tanner John chapman 662211 662211 Tanner, John, of Cardiff, Glamorgan, chapman 2
4296614 2128889 2128889 defendant Andrewe William gent 662211 662211 Andrewe, William, of Cardiff, Glamorgan, gent 1
4297083 2129056 2129056 defendant Andrewe William gent 662211 662211 Andrewe, William, of Cardiff, Glamorgan, gent 1
4343480 2144996 2144996 defendant Lewis Gabriel gent 662211 662211 Lewis, Gabriel, of Cardiff, Glamorgan, gent 0
4347541 2146387 2146387 defendant Jones David victualer 662211 662211 Jones, David, of Cardiff, Glamorgan, victualer 0
4352038 2147948 2147948 defendant Tanner John chapman 662211 662211 Tanner, John, of Cardiff, Glamorgan, chapman 1
4355068 2148991 2148991 defendant Dall Denis chapman 662211 662211 Dall, Denis, of Cardiff, Glamorgan, chapman 0
4363682 2152079 2152079 defendant Frowde Charles shoemaker 662211 662211 Frowde, Charles, of Cardiff, Glamorgan, shoemaker 0
4370267 2154424 2154424 defendant Bawdrippe William gent 662211 662211 Bawdrippe, William, of Cardiff, Glamorgan, gent 2
4379069 2157598 2157598 defendant Dall Denis chapman 662211 662211 Dall, Denis, of Cardiff, Glamorgan, chapman 0
4410942 2168251 2168251 defendant Bawle Henry gent 662211 662211 Bawle, Henry, of Cardiff, Glamorgan, 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);