names

30 rows where place_id = 608761

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3675268 1918304 1918304 defendant Jan Henry laborer or carter 608761 608761 Jan, Henry, of Islyngton, Middx, laborer or carter 0
3731237 1935996 1935996 defendant Pymme Thomas gent 608761 608761 Pymme, Thomas, of Islyngton, Middx, gent 0
3771516 1948784 1948784 defendant Aphowell Lewis yeoman 608761 608761 Aphowell, Lewis, of Islyngton, Middx, yeoman 2
3789175 1954427 1954427 defendant Aphowell Lewis yeoman 608761 608761 Aphowell, Lewis, of Islyngton, Middx, yeoman 0
3796942 1956924 1956924 defendant Rycroft Robert brewer 608761 608761 Rycroft, Robert, of Islyngton, Middx, brewer 0
3801450 1958373 1958373 defendant Aphowell Lewis yeoman of the guard 608761 608761 Aphowell, Lewis, of Islyngton, Middx, yeoman of the guard 1
3808163 1960443 1960443 defendant Aman John yeoman 608761 608761 Aman, John, of Islyngton, Middx, yeoman 0
3813591 1962167 1962167 defendant Sharppe Robert gent 608761 608761 Sharppe, Robert, of Islyngton, Middx, gent 0
3829731 1967191 1967191 defendant Cauntwell William yeoman 608761 608761 Cauntwell, William, of Islyngton, Middx, yeoman 4
3934817 2001945 2001945 plaintiff Hughbott Thomas gent 608761 608761 Hughbott, Thomas, of Islyngton, Middx, gent 0
3941934 2004313 2004313 defendant Burgys Robert barber surgeon 608761 608761 Burgys, Robert, of Islyngton, Middx, barber surgeon 0
3957408 2009655 2009655 defendant Cosyn John yeoman 608761 608761 Cosyn, John, of Islyngton, Middx, yeoman 1
3989162 2020861 2020861 plaintiff Bagnall Thomas (legal representative) 608761 608761 Bagnall, Thomas, of Islyngton, Middx, executors of 0
4005163 2026626 2026626 defendant Wotton Richard tanner 608761 608761 Wotton, Richard, of Islyngton, Middx, tanner 0
4007618 2027511 2027511 plaintiff Martyn Robert innholder 608761 608761 Martyn, Robert, of Islyngton, Middx, yeoman, innholder 0
4049938 2042410 2042410 defendant Cosen John yeoman 608761 608761 Cosen, John, of Islyngton, Middx, yeoman 0
4051975 2043127 2043127 defendant Cosen John yeoman 608761 608761 Cosen, John, of Islyngton, Middx, yeoman 0
4058436 2045404 2045404 defendant Kent Richard vintner 608761 608761 Kent, Richard, of Islyngton, Middx, vintner 1
4063548 2047251 2047251 plaintiff Gobyns Alice   608761 608761 Alice his wife, formerly Alice Tytheryngton, of Islyngton, Middx 1
4070453 2049728 2049728 defendant Peersse Thomas gent 608761 608761 Peersse, Thomas, of Islyngton, Middx, gent 0
4260245 2116390 2116390 defendant Hudde or Hoode Thomas baker 608761 608761 Hudde or Hoode, Thomas, of Islyngton, Middx, baker 0
4260251 2116393 2116393 defendant Hudde or Hoode Thomas baker 608761 608761 Hudde or Hoode, Thomas, of Islyngton, Middx, baker 0
4268630 2119101 2119101 defendant Worrall John yeoman 608761 608761 Worrall, John, of Islyngton, Middx, yeoman 1
4333900 2141622 2141622 defendant Gee Henry brewer 608761 608761 Gee, Henry, of Islyngton, Middx, brewer 2
5027005 2364768 2364768 defendant Parker alias Cartere John yeoman 608761 608761 Parker alias Cartere, John, of Islyngton, Middx, yeoman 1
5533107 2514899 2514899 defendant Sharp Thomas tiler 608761 608761 Sharp, Thomas, of Islyngton, Middx, tiler 0
5533112 2514900 2514900 defendant Sharp Thomas tiler 608761 608761 Sharp, Thomas, of Islyngton, Middx, tiler 0
5533934 2515155 2515155 defendant Gray William husbandman 608761 608761 Gray, William, of Islyngton, Middx, husbandman 3
5581086 2529157 2529157 defendant Oliff John yeoman 608761 608761 Oliff, John, of Islyngton, Middx, yeoman 0
5607490 2537238 2537238 defendant Burton John innholder 608761 608761 Burton, John, of Islyngton, Middx, innholder 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);