names

27 rows where place_id = 637559

✎ 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
3837250 1969556 1969556 defendant Paycok Richard husbandman 637559 637559 Paycok, Richard, of Bellerby, husbandman 0
4386764 2160245 2160245 defendant Little William cutler 637559 637559 Little, William, of Bellerby, cutler 3
4403144 2165625 2165625 defendant Kirkby Ralph yeoman 637559 637559 Kirkby, Ralph, of Bellerby, yeoman 1
4410393 2168076 2168076 defendant Hodgson Thomas husbandman 637559 637559 Hodgson, Thomas, of Bellerby, husbandman 0
4594193 2229450 2229450 plaintiff Plowes Thomas de   637559 637559 Plowes, Thomas de, of Bellerby 0
4667249 2255489 2255489 defendant Helmeslay Thomas yeoman 637559 637559 Helmeslay, Thomas, of Bellerby, yeoman 3
4690094 2262456 2262456 defendant Dobson John husbandman 637559 637559 Dobson, John, of Bellerby, husbandman 0
4722667 2272405 2272405 defendant Jeffeson Thomas yeoman 637559 637559 Jeffeson, Thomas, of Bellerby, yeoman 2
4780929 2290038 2290038 defendant Grenehode Henry husbandman 637559 637559 Grenehode, Henry, of Bellerby, husbandman 0
4780930 2290038 2290038 defendant Robynson John slater 637559 637559 Robynson, John, of Bellerby, slater 1
4780931 2290038 2290038 defendant Herneby Robert husbandman 637559 637559 Herneby, Robert, of Bellerby, husbandman 2
4888592 2323231 2323231 defendant Turry Richard husbandman 637559 637559 Turry, Richard, of Bellerby, husbandman 3
4929843 2335749 2335749 defendant Peresson Thomas yeoman 637559 637559 Peresson, Thomas, of Bellerby, yeoman 0
4947323 2341156 2341156 defendant Dobson Geoffrey yeoman 637559 637559 Dobson, Geoffrey, of Bellerby, yeoman 0
4947324 2341156 2341156 defendant Dobson Reginald husbandman 637559 637559 Dobson, Reginald, of Bellerby, husbandman 1
4947325 2341156 2341156 defendant Herryson John husbandman 637559 637559 Herryson, John, of Bellerby, husbandman 2
5069591 2377404 2377404 defendant Gayle Thomas husbandman 637559 637559 Gayle, Thomas, of Bellerby, husbandman 0
5069592 2377404 2377404 defendant Herneby John husbandman 637559 637559 Herneby, John, of Bellerby, husbandman 1
5080855 2380765 2380765 defendant Ploughis John husbandman 637559 637559 Ploughis, John, of Bellerby, husbandman 0
5080856 2380765 2380765 defendant Gayll James husbandman 637559 637559 Gayll, James, of Bellerby, husbandman 1
5080857 2380765 2380765 defendant Derwent Thomas husbandman 637559 637559 Derwent, Thomas, of Bellerby, husbandman 2
5321172 2451431 2451431 defendant Turnour William husbandman 637559 637559 Turnour, William, of Bellerby, husbandman 0
5321173 2451431 2451431 defendant Pratte William husbandman 637559 637559 Pratte, William, of Bellerby, husbandman 1
5321174 2451431 2451431 defendant Plugh Thomas husbandman 637559 637559 Plugh, Thomas, of Bellerby, husbandman 2
5321176 2451432 2451432 defendant Turnour William husbandman 637559 637559 Turnour, William, of Bellerby, husbandman 0
5321177 2451432 2451432 defendant Pratte William husbandman 637559 637559 Pratte, William, of Bellerby, husbandman 1
5321178 2451432 2451432 defendant Plugh Thomas husbandman 637559 637559 Plugh, Thomas, of Bellerby, husbandman 2

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