names

14 rows where place_id = 595205

✎ 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
3619354 1873643 1873643 defendant Hardysshe Thomas gent 595205 595205 Hardysshe, Thomas, of Claworth, Notts, gent 44
3694334 1924433 1924433 defendant Burgon John gent 595205 595205 Burgon, John, of Claworth, Notts, gent 0
3713869 1930640 1930640 defendant Hoton John husbandman 595205 595205 Hoton, John, of Claworth, Notts, husbandman 0
3742294 1939460 1939460 defendant Burgon William husbandman 595205 595205 Burgon, William, of Claworth, Notts, husbandman 1
3767570 1947494 1947494 defendant Burgoyn John gent 595205 595205 Burgoyn, John, of Claworth, Notts, gent 0
3941157 2004046 2004046 defendant FitzWilliams Humphrey esq 595205 595205 FitzWilliams, Humphrey, of Claworth, Notts, esq 0
3957110 2009554 2009554 defendant FitzWilliam William esq 595205 595205 FitzWilliam, William, of Claworth, Notts, esq, son of Humphrey FitzWilliam, of Claworth, esq 0
3965321 2012488 2012488 defendant Spurre Richard husbandman 595205 595205 Spurre, Richard, of Claworth, Notts, husbandman 0
4274780 2121123 2121123 defendant Clarke Dorothy widow 595205 595205 Clarke, Dorothy, of Claworth, Notts, widow 1
5079044 2380219 2380219 defendant Elynson John husbandman 595205 595205 Elynson, John, of Claworth, Notts, husbandman 0
5095267 2385034 2385034 defendant Elynson John husbandman 595205 595205 Elynson, John, of Claworth, Notts, husbandman 0
5111016 2389613 2389613 defendant Stephens Richard clerk 595205 595205 Stephens, Richard, of Claworth, Notts, clerk 0
5224314 2422786 2422786 defendant Ekels John yeoman 595205 595205 Ekels, John, of Claworth, Notts, yeoman 0
5224316 2422787 2422787 defendant Ekels John yeoman 595205 595205 Ekels, John, of Claworth, Notts, 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);