names

35 rows where place_id = 588617

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595075 1866093 1866093 defendant Bowedok Roger gent 588617 588617 Bowedok, Roger, of Bromesgrove, Worcs, gent 0
3616089 1872669 1872669 defendant More Humphrey yeoman or gent 588617 588617 More, Humphrey, of Bromesgrove, Worcs, yeoman or gent 0
3616093 1872670 1872670 defendant More Humphrey yeoman or gent 588617 588617 More, Humphrey, of Bromesgrove, Worcs, yeoman or gent 0
3650690 1910583 1910583 defendant Flemmyng Walter yeoman 588617 588617 Flemmyng, Walter, of Bromesgrove, Worcs, yeoman 0
3650735 1910594 1910594 defendant Daffy John husbandman 588617 588617 Daffy, John, of Bromesgrove, Worcs, husbandman 0
3678422 1919305 1919305 defendant Smyth Thomas yeoman 588617 588617 Smyth, Thomas, of Bromesgrove, Worcs, yeoman 0
3819271 1963917 1963917 defendant Bradley John draper 588617 588617 Bradley, John, of Bromesgrove, Worcs, draper 0
3892562 1987754 1987754 defendant Barnesley John gent 588617 588617 Barnesley, John, of Bromesgrove, Worcs, gent 3
3926004 1999017 1999017 defendant Talbott Humfrey gent 588617 588617 Talbott, Humfrey, of Bromesgrove, Worcs, gent 2
3934065 2001687 2001687 defendant Bayley Richard yeoman 588617 588617 Bayley, Richard, of Bromesgrove, Worcs, yeoman 2
3994692 2022853 2022853 defendant Flavell John chapman 588617 588617 Flavell, John, of Bromesgrove, Worcs, chapman 0
4016397 2030565 2030565 defendant Wakman Roger chapman 588617 588617 Wakman, Roger, of Bromesgrove, Worcs, chapman 0
4021218 2032309 2032309 defendant Flavell John mercer 588617 588617 Flavell, John, of Bromesgrove, Worcs, mercer 0
4028133 2034713 2034713 defendant Flavell John chapman 588617 588617 Flavell, John, of Bromesgrove, Worcs, chapman 2
4033976 2036806 2036806 defendant Wakeman Roger yeoman 588617 588617 Wakeman, Roger, of Bromesgrove, Worcs, yeoman 0
4057368 2045016 2045016 defendant Aston Christopher husbandman 588617 588617 (Aston, Christopher, of Bromesgrove, Worcs, husbandman 1
4099648 2060198 2060198 defendant Fearne William yeoman 588617 588617 Fearne, William, of Bromesgrove, Worcs, yeoman 1
4105741 2062342 2062342 defendant Wakeman Roger mercer 588617 588617 Wakeman, Roger, of Bromesgrove, Worcs, mercer 0
4147563 2077290 2077290 defendant Cooke William tailor 588617 588617 Cooke, William, of Bromesgrove, Worcs, tailor 0
4172598 2085875 2085875 defendant Coocke William tailor 588617 588617 Coocke, William, of Bromesgrove, Worcs, tailor 0
4188360 2091432 2091432 defendant Byrde Nicholas baker 588617 588617 Byrde, Nicholas, of Bromesgrove, Worcs, baker 2
4223060 2103555 2103555 defendant Fatenne Richard yeoman 588617 588617 Fatenne, Richard, of Bromesgrove, Worcs, yeoman 2
4358813 2150315 2150315 defendant Barnesley William gent 588617 588617 Barnesley, William, of Bromesgrove, Worcs, gent 0
4362095 2151486 2151486 defendant Myles Henry shoemaker 588617 588617 Myles, Henry, of Bromesgrove, Worcs, shoemaker 0
4383715 2159263 2159263 defendant Rastell John chapman 588617 588617 Rastell, John, of Bromesgrove, Worcs, chapman 0
4758087 2282901 2282901 defendant Horton William butcher 588617 588617 Horton, William, of Bromesgrove, Worcs, butcher 4
4932355 2336516 2336516 defendant Peche Walter sawyer 588617 588617 Peche, Walter, of Bromesgrove, Worcs, sawyer 2
4997608 2356137 2356137 defendant Dypper David yeoman 588617 588617 Dypper, David, of Bromesgrove, Worcs, yeoman 1
5041351 2369022 2369022 defendant Draper Thomas draper 588617 588617 Draper, Thomas, of Bromesgrove, Worcs, draper 0
5331284 2454429 2454429 defendant More Humphrey clerk 588617 588617 More, Humphrey, of Bromesgrove, Worcs, clerk 1
5333194 2454997 2454997 defendant Baylly William chapman 588617 588617 Baylly, William, of Bromesgrove, Worcs, chapman 1
5409741 2477890 2477890 defendant Hiller John yeoman 588617 588617 Hiller, John, of Bromesgrove, Worcs, yeoman 0
5484615 2500323 2500323 defendant More Humphrey gent 588617 588617 More, Humphrey, of Bromesgrove, Worcs, gent 1
5498698 2504556 2504556 defendant Leycetur William gent 588617 588617 Leycetur, William, of Bromesgrove, Worcs, gent 0
5523072 2512041 2512041 defendant Happecotes Richard yeoman 588617 588617 Happecotes, Richard, of Bromesgrove, Worcs, 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);