names

21 rows where place_id = 609952

✎ 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
3672023 1917250 1917250 defendant Lane Thomas   609952 609952 Lane, Thomas, of Inkebarowe, yeoman, son of Lane, John 0
3681196 1920201 1920201 defendant Dyson Thomas husbandman 609952 609952 Dyson, Thomas, of Inkebarowe, husbandman 0
3690755 1923273 1923273 defendant Dyson Henry yeoman 609952 609952 Dyson, Henry, of Inkebarowe, yeoman 0
3784853 1953055 1953055 defendant Shepey William   609952 609952 Shepey, William, of Inkebarowe 0
3825412 1965799 1965799 defendant Hunte John husbandman 609952 609952 Hunte, John, of Inkebarowe, husbandman 0
3833216 1968320 1968320 defendant Steward John butcher 609952 609952 Steward, John, of Inkebarowe, butcher 1
3833217 1968320 1968320 defendant Smyth William wheeler 609952 609952 Smyth, William, of Inkebarowe, wheeler 2
3861574 1977331 1977331 defendant Chylde Richard laborer 609952 609952 Chylde, Richard, of Inkebarowe, laborer 2
3863471 1977977 1977977 defendant Frauncys Robert husbandman 609952 609952 Frauncys, Robert, of Inkebarowe, husbandman 2
3889509 1986722 1986722 defendant More Richard clerk 609952 609952 More, Richard, of Inkebarowe, clerk 0
3889510 1986722 1986722 defendant Androwes Richard laborer 609952 609952 Androwes, Richard, of Inkebarowe, laborer 1
3892388 1987706 1987706 defendant Harryson Richard husbandman 609952 609952 Harryson, Richard, of Inkebarowe, husbandman 0
3892389 1987706 1987706 defendant Saunders William husbandman 609952 609952 Saunders, William, of Inkebarowe, husbandman 1
3971230 2014496 2014496 defendant Coxse Benjamin yeoman 609952 609952 Coxse, Benjamin, of Inkebarowe, yeoman 0
4051151 2042849 2042849 defendant Dyson Thomas husbandman 609952 609952 Dyson, Thomas, of Inkebarowe, husbandman 2
5226777 2423496 2423496 defendant Bultes William husbandman 609952 609952 Bultes, William, of Inkebarowe, husbandman 8
5498112 2504379 2504379 defendant Renyn or Revyn William smith 609952 609952 Renyn or Revyn, William, of Inkebarowe, smith 1
5500843 2505196 2505196 defendant Bultis Thomas, junior husbandman 609952 609952 Bultis, Thomas, junior, of Inkebarowe, husbandman 2
5515393 2509661 2509661 defendant Bultis Thomas, junior husbandman 609952 609952 Bultis, Thomas, junior, of Inkebarowe, husbandman 0
5555134 2521508 2521508 defendant Egeocke Agnes widow 609952 609952 Egeocke, Agnes, of Inkebarowe, widow 6
5574968 2527251 2527251 defendant Freman John husbandman 609952 609952 Freman, John, of Inkebarowe, 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);