names

30 rows where place_id = 589508

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597821 1866937 1866937 plaintiff Scull William esq 589508 589508 Scull, William, of Magna Cowarn, esq 0
3638313 1906800 1906800 defendant Joldewyn William husbandman 589508 589508 Joldewyn, William, of Magna Cowarn, husbandman 1
3645340 1908952 1908952 defendant Joldewyn William husbandman 589508 589508 Joldewyn, William, of Magna Cowarn, husbandman 0
3645343 1908952 1908952 defendant Clerk John husbandman 589508 589508 Clerk, John, of Magna Cowarn, husbandman 3
3645344 1908952 1908952 defendant Lowes Thomas husbandman 589508 589508 Lowes, Thomas, of Magna Cowarn, husbandman 4
3648987 1910073 1910073 defendant South John laborer 589508 589508 South, John, of Magna Cowarn, laborer 0
3648988 1910073 1910073 defendant South William laborer 589508 589508 South, William, of Magna Cowarn, laborer 1
3686708 1921996 1921996 defendant Pytte Richard tailor 589508 589508 Pytte, Richard, of Magna Cowarn, tailor 0
3686709 1921996 1921996 defendant Syche John weaver 589508 589508 Syche, John, of Magna Cowarn, weaver 1
3699535 1926086 1926086 defendant Grafton Richard husbandman 589508 589508 Grafton, Richard, of Magna Cowarn, husbandman 1
3711446 1929885 1929885 defendant Socur John husbandman 589508 589508 Socur, John, of Magna Cowarn, husbandman 4
3712062 1930092 1930092 defendant Soull Thomas gent 589508 589508 Soull, Thomas, of Magna Cowarn, gent 0
3749746 1941831 1941831 defendant Jeffes Roger husbandman 589508 589508 Jeffes, Roger, of Magna Cowarn, husbandman 0
3749748 1941831 1941831 defendant Jeffes Perena spinster 589508 589508 Jeffes, Perena, of Magna Cowarn, spinster 2
3757117 1944206 1944206 defendant Scull Thomas gent 589508 589508 Scull, Thomas, of Magna Cowarn, gent 0
3757118 1944206 1944206 defendant Jowldwyn Miles husbandman 589508 589508 Jowldwyn, Miles, of Magna Cowarn, husbandman 1
3775083 1949938 1949938 defendant Scull Thomas gent 589508 589508 Scull, Thomas, of Magna Cowarn, gent 0
3781665 1952005 1952005 defendant Jowldwyn Miles husbandman 589508 589508 Jowldwyn, Miles, of Magna Cowarn, husbandman 0
3959087 2010263 2010263 defendant Tomkyns James husbandman 589508 589508 Tomkyns, James, of Magna Cowarn, husbandman 0
3959088 2010263 2010263 defendant Woode alias Willyams Nicholas laborer 589508 589508 Woode alias Willyams, Nicholas, of Magna Cowarn, laborer 1
3959089 2010263 2010263 defendant Woode alias Willyams Oto laborer 589508 589508 Woode alias Willyams, Oto, of Magna Cowarn, laborer 2
3959091 2010264 2010264 defendant Devereux Thomas laborer 589508 589508 Devereux, Thomas, of Magna Cowarn, laborer 0
3959093 2010264 2010264 defendant Taberrer John laborer 589508 589508 Taberrer, John, of Magna Cowarn, laborer 2
4146086 2076781 2076781 defendant Bennett Edward gent 589508 589508 Bennett, Edward, of Magna Cowarn, gent 2
5513609 2509106 2509106 defendant Souch Philip husbandman 589508 589508 Souch, Philip, of Magna Cowarn, husbandman 0
5513610 2509106 2509106 defendant Walter Walter husbandman 589508 589508 Walter, Walter, of Magna Cowarn, husbandman 1
5513614 2509107 2509107 defendant Souch John husbandman 589508 589508 Souch, John, of Magna Cowarn, husbandman 2
5515196 2509598 2509598 defendant Baker John husbandman 589508 589508 Baker, John, of Magna Cowarn, husbandman 0
5519281 2510876 2510876 defendant Pychard Hugh husbandman 589508 589508 Pychard, Hugh, of Magna Cowarn, husbandman 0
5577327 2527966 2527966 defendant Bundy Richard husbandman 589508 589508 Bundy, Richard, of Magna Cowarn, husbandman 1

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