names

17 rows where place_id = 611503

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3688675 1922620 1922620 defendant Barkeby Richard mercer 611503 611503 Barkeby, Richard, of Adderston, Warks, mercer 1
3779126 1951195 1951195 defendant Eyton William   611503 611503 Eyton, William, of Adderston, Warks, surgeon 0
3809194 1960757 1960757 defendant Leos Stephen chapman 611503 611503 Leos, Stephen, of Adderston, Warks, chapman 0
3817888 1963511 1963511 defendant Tottye Richard chapman 611503 611503 Tottye, Richard, of Adderston, Warks, chapman 0
3913570 1994879 1994879 defendant Hewes Thomas tailor 611503 611503 Hewes, Thomas, of Adderston, Warks, tailor 3
3915673 1995614 1995614 defendant Huchynson alias Notyngham John mercer 611503 611503 Huchynson alias Notyngham, John, of Adderston, Warks, mercer 0
3917917 1996355 1996355 defendant Huchynson alias Notyngham John mercer 611503 611503 Huchynson alias Notyngham, John, of Adderston, Warks, mercer 0
3968915 2013752 2013752 defendant Hyll Robert gent 611503 611503 Hyll, Robert, of Adderston, Warks, gent 8
3968953 2013758 2013758 defendant Hyll Robert gent 611503 611503 Hyll, Robert, of Adderston, Warks, gent 13
4323724 2138347 2138347 defendant Rampton Samuel gent 611503 611503 Rampton, Samuel, of Adderston, Warks, or of Edmonton, Middx, gent 0
4400882 2164887 2164887 defendant Curson Cedda yeoman 611503 611503 Curson, Cedda, of Adderston , Warks, yeoman 0
5347010 2459223 2459223 defendant Michell William husbandman 611503 611503 Michell, William, of Adderston, Warks, husbandman 0
5507243 2507165 2507165 defendant Cotton Thomas gent 611503 611503 Cotton, Thomas, of Adderston, Warks, gent 14
5570685 2525983 2525983 defendant Churchyard Richard chapman 611503 611503 Churchyard, Richard, of Adderston, Warks, chapman 0
5589625 2531751 2531751 defendant Page Wiilliam yeoman 611503 611503 Page, Wiilliam, of Adderston, Warks, yeoman 3
5599969 2534871 2534871 defendant Barkby Richard mercer 611503 611503 Barkby, Richard, of Adderston, Warks, mercer 0
5599973 2534872 2534872 defendant Barkly or Barkby Richard mercer 611503 611503 Barkly or Barkby, Richard, of Adderston, Warks, mercer 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);