names

25 rows where place_id = 606121

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3664088 1914720 1914720 plaintiff Rawson James gent 606121 606121 Rawson, James, of Harlyngton, gent 0
3668923 1916212 1916212 defendant Toky William maltman 606121 606121 Toky, William, of Harlyngton, maltman 1
3681582 1920330 1920330 defendant Cranwell John husbandman 606121 606121 Cranwell, John, of Harlyngton, husbandman 0
3693436 1924162 1924162 defendant James Thomas clerk 606121 606121 James, Thomas, of Harlyngton, clerk 2
3728544 1935178 1935178 defendant Dislyngton Thomas husbandman 606121 606121 Dislyngton, Thomas, of Harlyngton, husbandman 0
3782153 1952170 1952170 defendant Kyrke William yeoman 606121 606121 Kyrke, William, of Harlyngton, yeoman 1
3829519 1967121 1967121 defendant Lovell Gregory esq 606121 606121 Lovell, Gregory, of Harlyngton, esq 0
3876836 1982493 1982493 defendant Hawkys Robert gent 606121 606121 Hawkys, Robert, of Harlyngton, gent 0
3886625 1985778 1985778 defendant Lumley Cuthbert yeoman 606121 606121 Lumley, Cuthbert, of Harlyngton, yeoman 0
3886626 1985778 1985778 defendant Hardyng William yeoman 606121 606121 Hardyng, William, of Harlyngton, yeoman 1
3913855 1994980 1994980 defendant Fensham John laborer 606121 606121 Fensham, John, of Harlyngton, laborer 2
4148804 2077701 2077701 defendant Jones Thomas clerk 606121 606121 Jones, Thomas, of Harlyngton, clerk 0
4307958 2132925 2132925 defendant Bowstred Thomas laborer 606121 606121 Bowstred, Thomas, of Harlyngton, laborer 0
4338144 2143082 2143082 defendant Stevens Henry butcher 606121 606121 Stevens, Henry, of Harlyngton, butcher 0
4338145 2143082 2143082 defendant Stevens John butcher 606121 606121 Stevens, John, of Harlyngton, butcher 1
4338148 2143083 2143083 defendant Bowstred Thomas yeoman 606121 606121 Bowstred, Thomas, of Harlyngton, yeoman 0
4397401 2163709 2163709 defendant Greywood John laborer 606121 606121 Greywood, John, of Harlyngton, laborer 1
4691936 2263012 2263012 defendant Hally William gent [ mentioning the liberty of Olsgoldcrosse ] 606121 606121 Hally, William, of Harlyngton, gent [ mentioning the liberty of Olsgoldcrosse ] 0
4786221 2291731 2291731 defendant Bocher Thomas butcher 606121 606121 Bocher, Thomas, of Harlyngton, butcher 1
4971005 2348268 2348268 defendant Knolles John husbandman 606121 606121 Knolles, John, of Harlyngton, husbandman 0
5099910 2386410 2386410 defendant Dyghton Richard yeoman 606121 606121 Dyghton, Richard, of Harlyngton, yeoman 0
5168737 2406582 2406582 defendant Hewebard Robert husbandman 606121 606121 Hewebard, Robert, of Harlyngton, husbandman 0
5499821 2504895 2504895 defendant Bocher Henry butcher 606121 606121 Bocher, Henry, of Harlyngton, butcher 1
5586822 2530917 2530917 defendant Lincoln John husbandman 606121 606121 Lincoln, John, of Harlyngton, husbandman 3
5596562 2533841 2533841 defendant Lyncolne John husbandman 606121 606121 Lyncolne, John, of Harlyngton, husbandman 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);