names

16 rows where place_id = 609013

✎ 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
3676546 1918708 1918708 defendant Walys William husbandman 609013 609013 Walys, William, of Cowbyt, husbandman 1
3705614 1928037 1928037 defendant Chele Robert husbandman 609013 609013 Chele, Robert, of Cowbyt, husbandman 0
3781587 1951978 1951978 plaintiff Harrys Robert (legal representative) 609013 609013 Harrys, Robert, of Cowbyt, executors of 0
3785871 1953372 1953372 defendant Seton Thomas chaplain 609013 609013 Seton, Thomas, of Cowbyt, chaplain 0
3815633 1962807 1962807 plaintiff Harrys Robert (legal representative) 609013 609013 Harrys, Robert, of Cowbyt, executors of 0
3815637 1962807 1962807 defendant Stanwell William fisher 609013 609013 Stanwell, William, of Cowbyt, fisher 1
3826332 1966084 1966084 defendant Horner Reginald fisher 609013 609013 Horner, Reginald, of Cowbyt, fisher 0
3826333 1966084 1966084 defendant Horner Margaret spinster 609013 609013 Horner, Margaret, of Cowbyt, spinster 1
3832213 1967986 1967986 defendant Stanwell John fisher 609013 609013 Stanwell, John, of Cowbyt, fisher 0
3878031 1982897 1982897 defendant Okey John fisher 609013 609013 Okey, John, of Cowbyt, fisher 0
3947972 2006354 2006354 defendant Taylour Mathew yeoman 609013 609013 Taylour, Mathew, of Cowbyt, yeoman 0
5196641 2414772 2414772 defendant Horner Robert husbandman 609013 609013 Horner, Robert, of Cowbyt, husbandman 0
5209732 2418586 2418586 defendant Horner Robert husbandman 609013 609013 Horner, Robert, of Cowbyt, husbandman 0
5295100 2443555 2443555 defendant Calvard Richard husbandman 609013 609013 Calvard, Richard, of Cowbyt, husbandman 0
5320482 2451210 2451210 plaintiff Josep William   609013 609013 Josep, William, of Cowbyt 0
5320483 2451210 2451210 defendant Horner Robert (legal representative) 609013 609013 Horner, Robert, of Cowbyt, husbandman, executrix of 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);