names

15 rows where place_id = 660139

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3947047 2006030 2006030 defendant Bulwer William   660139 660139 Bulwer, William, of Magna Byrcham, shepherd 0
3955273 2008912 2008912 defendant Cantrell Henry gent 660139 660139 Cantrell, Henry, of Magna Byrcham, gent 0
3989119 2020847 2020847 defendant Cantrell Henry gent 660139 660139 Cantrell, Henry, of Magna Byrcham, gent 0
4050054 2042447 2042447 defendant Cantrell Henry gent 660139 660139 Cantrell, Henry, of Magna Byrcham, gent 0
4050216 2042510 2042510 defendant Cantrell Henry gent 660139 660139 Cantrell, Henry, of Magna Byrcham, gent 0
4083188 2054274 2054274 defendant Fuller Thomas husbandman 660139 660139 Fuller, Thomas, of Magna Byrcham, husbandman 0
4119620 2067304 2067304 defendant Southons William gent 660139 660139 Southons, William, of Magna Byrcham, gent 0
4129612 2070896 2070896 defendant Lewes William husbandman 660139 660139 Lewes, William, of Magna Byrcham, husbandman 0
4262916 2117263 2117263 defendant Rawlinge Alexander clerk 660139 660139 Rawlinge, Alexander, of Magna Byrcham, clerk 1
4305558 2132078 2132078 defendant Coppye William blacksmith 660139 660139 Coppye, William, of Magna Byrcham, blacksmith 0
4328550 2139865 2139865 defendant Rawlyns Alexander clerk 660139 660139 Rawlyns, Alexander, of Magna Byrcham, clerk 0
4354806 2148903 2148903 defendant Yonge John yeoman 660139 660139 Yonge, John, of Magna Byrcham, yeoman 0
4382752 2158936 2158936 defendant Younge William husbandman 660139 660139 Younge, William, of Magna Byrcham, husbandman 1
4382753 2158936 2158936 defendant Bastard James husbandman 660139 660139 Bastard, James, of Magna Byrcham, husbandman 2
4382754 2158936 2158936 defendant Wallcur George husbandman 660139 660139 Wallcur, George, of Magna Byrcham, husbandman 3

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