names

24 rows where place_id = 606259

✎ 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
3588046 1863914 1863914 plaintiff Barbor John   606259 606259 Barbor, John, of Haughton clerk 0
3664632 1914891 1914891 defendant Gretbache Thomas husbandman 606259 606259 Gretbache, Thomas, of Haughton, husbandman 0
3722578 1933322 1933322 defendant Sisson William husbandman 606259 606259 Sisson, William, of Haughton, husbandman 1
3756169 1943889 1943889 defendant Gravener Nicholas clerk 606259 606259 Gravener, Nicholas, of Haughton, clerk 0
3762407 1945884 1945884 defendant Gravenour Nicholas clerk 606259 606259 Gravenour, Nicholas, of Haughton, clerk 0
3827143 1966351 1966351 defendant Symson Matthew clerk 606259 606259 Symson, Matthew, of Haughton, clerk 2
3892449 1987718 1987718 defendant Hyll Thomas smith 606259 606259 Hyll, Thomas, of Haughton, smith 1
3901922 1990870 1990870 defendant Bowdon Richard husbandman 606259 606259 Bowdon, Richard, of Haughton, husbandman 0
4074324 2051118 2051118 defendant Greatbeache William husbandman 606259 606259 Greatbeache, William, of Haughton, husbandman 0
4146243 2076836 2076836 defendant Bould Edward merchant of the staple 606259 606259 Bould, Edward, of Haughton, merchant of the staple 0
4159742 2081475 2081475 defendant Reason Robert husbandman 606259 606259 Reason, Robert, of Haughton, husbandman 0
4177963 2087766 2087766 defendant Bold Edward merchant 606259 606259 Bold, Edward, of Haughton, merchant 0
4229055 2105646 2105646 defendant Leeche Geoffrey yeoman 606259 606259 Leeche, Geoffrey, of Haughton, yeoman 0
4258678 2115865 2115865 defendant Leeche Geoffrey yeoman 606259 606259 Leeche, Geoffrey, of Haughton, yeoman 0
4260395 2116443 2116443 defendant Catlowe Henry clothier 606259 606259 Catlowe, Henry, of Haughton, or of Hunslett, clothier 1
4264511 2117772 2117772 defendant Barnes John (legal representative) 606259 606259 Barnes, John, of Haughton, clerk, executors of 1
4320362 2137221 2137221 defendant Leech Geoffrey yeoman 606259 606259 Leech, Geoffrey, of Haughton, yeoman 0
4341537 2144316 2144316 defendant Walter Humphrey gent 606259 606259 Walter, Humphrey, of Haughton, gent 0
4345667 2145753 2145753 defendant Sharpe Thomas laborer 606259 606259 Sharpe Thomas, of Haughton, laborer 1
4345669 2145753 2145753 defendant Hodgeson Roger shoemaker 606259 606259 Hodgeson, Roger, of Haughton, shoemaker 3
4351416 2147746 2147746 defendant Leche Geoffrey yeoman 606259 606259 Leche, Geoffrey, of Haughton, yeoman 0
4412136 2168652 2168652 defendant Bowld Edward yeoman 606259 606259 Bowld, Edward, of Haughton, yeoman 0
5091717 2383969 2383969 defendant Alsop William husbandman 606259 606259 Alsop, William, of Haughton, husbandman 0
5604820 2536374 2536374 defendant Gretbache John yeoman 606259 606259 Gretbache, John, of Haughton, yeoman 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);