names

24 rows where place_id = 593127

✎ 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
3610609 1870984 1870984 defendant Fuyster Richard, senior yeoman 593127 593127 Fuyster, Richard, senior, of Kylburn, yeoman 0
3610610 1870984 1870984 defendant Fuyster Robert laborer 593127 593127 Fuyster, Robert, of Kylburn, laborer 1
3611393 1871239 1871239 defendant Fuyster Richard, senior yeoman 593127 593127 Fuyster, Richard, senior, of Kylburn, yeoman 0
3611394 1871239 1871239 defendant Fuyster Robert laborer 593127 593127 Fuyster, Robert, of Kylburn, laborer 1
3617560 1873116 1873116 defendant Grene Thomas   593127 593127 Grene, Thomas, of Kylburn, scythe smith 0
3772675 1949147 1949147 defendant Johnson Thomas   593127 593127 Johnson, Thomas, of Kylburn, scythe smith 0
3829711 1967185 1967185 defendant Sutton Thomas laborer 593127 593127 Sutton, Thomas, of Kylburn, laborer 0
3834715 1968793 1968793 defendant Stokdale Thomas barker 593127 593127 Stokdale, Thomas, of Kylburn, barker 0
3904122 1991622 1991622 defendant Garrett Christopher laborer 593127 593127 Garrett, Christopher, of Kylburn, laborer 0
4588057 2227663 2227663 plaintiff Kaye John   593127 593127 Kaye, John, of Kylburn 0
4763716 2284642 2284642 defendant Bullok Roger   593127 593127 Bullok, Roger, of Kylburn, tile maker 0
4788143 2292365 2292365 defendant Bullok Roger tiler 593127 593127 Bullok, Roger, of Kylburn, tiler 0
4788148 2292366 2292366 defendant Bullok Roger tiler 593127 593127 Bullok, Roger, of Kylburn, tiler 0
4847846 2310813 2310813 defendant Breton William shoemaker 593127 593127 Breton, William, of Kylburn, shoemaker 3
4861070 2314819 2314819 defendant Marshall John yeoman 593127 593127 Marshall, John, of Kylburn, yeoman 0
4951123 2342315 2342315 defendant Bartelet Benedict husbandman 593127 593127 Bartelet, Benedict, of Kylburn, husbandman 2
4986400 2352859 2352859 defendant Mumbray Thomas husbandman 593127 593127 Mumbray, Thomas, of Kylburn, husbandman 0
5002397 2357610 2357610 defendant Bysshop John husbandman 593127 593127 Bysshop, John, of Kylburn, husbandman 4
5034430 2366931 2366931 plaintiff Stokdale William   593127 593127 Stokdale, William, of Kylburn 0
5222010 2422142 2422142 defendant Foxston Thomas yeoman 593127 593127 Foxston, Thomas, of Kylburn, yeoman 1
5327519 2453301 2453301 defendant Fuyster William husbandman 593127 593127 Fuyster, William, of Kylburn, husbandman 1
5327525 2453302 2453302 defendant Fuyster William husbandman 593127 593127 Fuyster, William, of Kylburn, husbandman 1
5602522 2535681 2535681 defendant Hudson Robert   593127 593127 Hudson, Robert, of Kylburn, scythe smith 0
5631053 2553720 2553720 defendant Birchore Robert cooper 593127 593127 Birchore, Robert, of Kylburn, cooper 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);