names

13 rows where place_id = 638263

✎ 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
3841488 1970919 1970919 plaintiff Besonthen Thomas husbandman 638263 638263 Besonthen, Thomas, of Hoggesthorpe, husbandman 0
3919460 1996843 1996843 defendant Cracrofte Leonard esq 638263 638263 Cracrofte, Leonard, of Hoggesthorpe, esq 0
3978060 2016902 2016902 defendant Camell Thomas husbandman 638263 638263 Camell, Thomas, of Hoggesthorpe, husbandman 0
4001456 2025299 2025299 defendant Sharp Peter husbandman 638263 638263 Sharp, Peter, of Hoggesthorpe, husbandman 1
4063920 2047378 2047378 defendant Barker William husbandman 638263 638263 Barker, William, of Hoggesthorpe, husbandman 0
4126453 2069745 2069745 defendant Randesley Thomas miller 638263 638263 Randesley, Thomas, of Hoggesthorpe, miller 0
4135684 2073089 2073089 defendant Lamme William laborer 638263 638263 Lamme, William, of Hoggesthorpe, laborer 0
4135685 2073089 2073089 defendant Kelsey William husbandman 638263 638263 Kelsey, William, of Hoggesthorpe, husbandman 1
5242844 2428112 2428112 defendant Cheles William husbandman 638263 638263 Cheles, William, of Hoggesthorpe, husbandman 0
5505267 2506557 2506557 defendant Ingram Richard husbandman 638263 638263 Ingram, Richard, of Hoggesthorpe, husbandman 1
5505268 2506557 2506557 defendant Broddyng William husbandman 638263 638263 Broddyng, William, of Hoggesthorpe, husbandman 2
5505274 2506558 2506558 defendant Ingram Richard husbandman 638263 638263 Ingram, Richard, of Hoggesthorpe, husbandman 3
5505275 2506558 2506558 defendant Broddyng William husbandman 638263 638263 Broddyng, William, of Hoggesthorpe, husbandman 4

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