names

24 rows where place_id = 622618

✎ 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
3748035 1941306 1941306 defendant Copleston Charles esq 622618 622618 Copleston, Charles, of Bytton, esq 0
3772980 1949251 1949251 defendant Twenesbarowe Walter husbandman 622618 622618 Twenesbarowe, Walter, of Bytton, husbandman 0
3772981 1949251 1949251 defendant Twenesbarowe Rowland husbandman 622618 622618 Twenesbarowe, Rowland, of Bytton, husbandman 1
3869851 1980162 1980162 defendant Lathebury William yeoman 622618 622618 Lathebury, William, of Bytton, yeoman 3
3872845 1981131 1981131 defendant Stowte John husbandman 622618 622618 Stowte, John, of Bytton, husbandman 0
4120594 2067643 2067643 defendant Bateman Stanton yeoman 622618 622618 Bateman, Stanton, of Bytton, yeoman 0
4120595 2067643 2067643 defendant Frauncys Richard husbandman 622618 622618 Frauncys, Richard, of Bytton, husbandman 1
4120596 2067643 2067643 defendant Jeffryes Thomas husbandman 622618 622618 Jeffryes, Thomas, of Bytton, husbandman 2
4125630 2069452 2069452 defendant Seymor John esq 622618 622618 Seymor, John, of Bytton, esq 0
4148842 2077716 2077716 defendant Seymor John esq 622618 622618 Seymor, John, of Bytton, esq 0
4190440 2092201 2092201 defendant Bradey William yeoman 622618 622618 Bradey, William, of Bytton, yeoman 1
4527657 2208932 2208932 defendant Frost William   622618 622618 Frost, William, of Bytton 0
4602726 2232064 2232064 defendant Stevene William   622618 622618 Stevene, William, of Bytton 1
4738848 2277240 2277240 defendant Blunt John gent 622618 622618 Blunt, John, of Bytton, gent 0
4764103 2284761 2284761 defendant Colyn Walter husbandman 622618 622618 Colyn, Walter, of Bytton, husbandman 1
5096377 2385372 2385372 defendant Blount John gent 622618 622618 Blount, John, of Bytton, gent 1
5261863 2433818 2433818 defendant Williams Thomas husbandman 622618 622618 Williams, Thomas, of Bytton, husbandman 0
5296867 2444073 2444073 defendant Rede John husbandman 622618 622618 Rede, John, of Bytton, husbandman 1
5323415 2452081 2452081 defendant Hunt alias Horte William husbandman 622618 622618 Hunt alias Horte, William, of Bytton, husbandman 0
5333184 2454993 2454993 defendant Rede John husbandman 622618 622618 Rede, John, of Bytton, husbandman 0
5375988 2468083 2468083 defendant Williams Richard husbandman 622618 622618 Williams, Richard, of Bytton, husbandman 0
5457885 2492256 2492256 defendant Garland John smith 622618 622618 Garland, John, of Bytton, smith 2
5469690 2495860 2495860 defendant Garland John smith 622618 622618 Garland, John, of Bytton, smith 2
5602446 2535657 2535657 defendant Breten Thomas husbandman 622618 622618 Breten, Thomas, of Bytton, husbandman 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);