names

21 rows where place_id = 738966

✎ 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
4333037 2141335 2141335 defendant Cheseman Clement yeoman 738966 738966 Cheseman, Clement, of Romney, Kent, yeoman 1
4717906 2270941 2270941 defendant Gregory Henry   738966 738966 Gregory, Henry, of Romney, Kent, husbandman, formerly of London 1
4734077 2275842 2275842 defendant Holyngbroke William gent 738966 738966 Holyngbroke, William, of Romney, Kent, gent 0
4773563 2287703 2287703 defendant Cliderowe Richard esq 738966 738966 Cliderowe, Richard, of Romney, Kent, esq 0
4821126 2302686 2302686 defendant Clederowe Richard gent 738966 738966 Clederowe, Richard, of Romney, Kent, gent 0
4836724 2307452 2307452 defendant Tartirby John clerk 738966 738966 Tartirby, John, of Romney, Kent, clerk 2
4836730 2307453 2307453 defendant Morterley John clerk 738966 738966 Morterley, John, of Romney, Kent, clerk 2
4916924 2331795 2331795 defendant Brukland John chapman 738966 738966 Brukland, John, of Romney, Kent, chapman 3
4916929 2331796 2331796 defendant Brukland John chapman 738966 738966 Brukland, John, of Romney, Kent, chapman 3
4926186 2334615 2334615 defendant Brokeland John chapman 738966 738966 Brokeland, John, of Romney, Kent, chapman 1
4977548 2350250 2350250 defendant Pocok Stephen chapman 738966 738966 Pocok, Stephen, of Romney, Kent, chapman 3
5041176 2368972 2368972 defendant Forde Richard yeoman 738966 738966 Forde, Richard, of Romney, Kent, yeoman 0
5170809 2407184 2407184 defendant Boxhurst John cooper 738966 738966 Boxhurst, John, of Romney, Kent, cooper 4
5340833 2457333 2457333 defendant Baker Stephen yeoman 738966 738966 Baker, Stephen, of Romney, Kent, yeoman 1
5370014 2466208 2466208 defendant Milhale John mercer 738966 738966 Milhale, John, of Romney, Kent, mercer 2
5370036 2466212 2466212 defendant Mylhale John mercer 738966 738966 Mylhale, John, of Romney, Kent, mercer 1
5403297 2476019 2476019 defendant Melal John chapman 738966 738966 Melal, John, of Romney, Kent, chapman 1
5416316 2479799 2479799 defendant Melall John chapman 738966 738966 Melall, John, of Romney, Kent, chapman 1
5433057 2484852 2484852 defendant Melall John chapman 738966 738966 Melall, John, of Romney, Kent, chapman 1
5433061 2484853 2484853 defendant Molall John chapman 738966 738966 Molall, John, of Romney, Kent, chapman 1
5539662 2516884 2516884 defendant Fynche Vincent gent 738966 738966 Fynche, Vincent, of Romney, Kent, gent 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);