names

22 rows where place_id = 586800

✎ 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
3587989 1863896 1863896 plaintiff Hays Thomas   586800 586800 (Hays, Thomas, of Bensted, junior 1
3587993 1863897 1863897 plaintiff Hays Thomas   586800 586800 (Hays, Thomas, of Bensted, junior 1
3589648 1864406 1864406 plaintiff Cantelowe Geoffrey gent 586800 586800 Cantelowe, Geoffrey, of Bensted, gent 0
3647459 1909594 1909594 defendant Lock John husbandman 586800 586800 Lock, John, of Bensted, husbandman 0
3649685 1910274 1910274 defendant Ceell Thomas husbandman 586800 586800 Ceell, Thomas, of Bensted, husbandman 0
3728518 1935170 1935170 defendant Lyttelwork John butcher 586800 586800 Lyttelwork, John, of Bensted, butcher 0
3728519 1935170 1935170 defendant Trymmer William husbandman 586800 586800 Trymmer, William, of Bensted, husbandman 1
3770429 1948430 1948430 defendant Deye John husbandman 586800 586800 Deye, John, of Bensted, husbandman 0
3813662 1962187 1962187 defendant Carter Michael tinker 586800 586800 Carter, Michael, of Bensted, tinker 0
3864907 1978467 1978467 plaintiff Marland Edward gent 586800 586800 Marland, Edward, of Bensted, gent 0
3881859 1984186 1984186 defendant Wheler Richard husbandman 586800 586800 Wheler, Richard, of Bensted, husbandman 1
3890646 1987136 1987136 plaintiff Hunte John   586800 586800 Hunte, John, of Bensted 0
3971756 2014686 2014686 plaintiff Felder William yeoman 586800 586800 Felder, William, of Bensted, yeoman 0
4044567 2040508 2040508 plaintiff Rese John yeoman 586800 586800 Rese, John, of Bensted, yeoman 0
4311589 2134194 2134194 defendant Locke Robert yeoman 586800 586800 Locke, Robert, of Bensted, yeoman 0
4348747 2146822 2146822 defendant Field Arthur yeoman 586800 586800 Field, Arthur, of Bensted, yeoman 0
4595642 2229902 2229902 plaintiff Bensted John   586800 586800 Bensted, John, of Bensted, vicar 2
5032356 2366342 2366342 plaintiff Ryvyr John   586800 586800 Ryvyr, John, of Bensted 0
5459313 2492694 2492694 defendant Meye John husbandman 586800 586800 Meye, John, of Bensted, husbandman 0
5459316 2492695 2492695 defendant Meye John husbandman 586800 586800 Meye, John, of Bensted, husbandman 0
5489712 2501806 2501806 plaintiff Hays Thomas, junior   586800 586800 (Hays, Thomas, junior, of Bensted 1
5489716 2501807 2501807 plaintiff Hays Thomas, junior   586800 586800 (Hays, Thomas, junior, of Bensted 1

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