names

14 rows where place_id = 593991

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3614099 1872073 1872073 defendant Garmon John yeoman 593991 593991 Garmon, John, of Gosbak, yeoman 0
3631311 1904602 1904602 defendant Aleyn or Aldyn Nicholas husbandman 593991 593991 Aleyn or Aldyn, Nicholas, of Gosbak, husbandman 19
3796086 1956639 1956639 defendant London John clerk 593991 593991 London, John, of Gosbak, clerk 0
4835397 2307067 2307067 defendant Reynburgh Walter yeoman 593991 593991 Reynburgh, Walter, of Gosbak, yeoman 3
5090070 2383467 2383467 defendant Thorn Thomas   593991 593991 Thorn, Thomas, of Gosbak, wright 1
5323477 2452100 2452100 defendant Rye John laborer 593991 593991 Rye, John, of Gosbak, laborer 4
5398269 2474575 2474575 defendant Byrde Thomas husbandman 593991 593991 Byrde, Thomas, of Gosbak, husbandman 1
5411495 2478395 2478395 defendant Byrde Thomas husbandman 593991 593991 Byrde, Thomas, of Gosbak, husbandman 1
5455349 2491516 2491516 defendant Gouty John husbandman 593991 593991 Gouty, John, of Gosbak, husbandman 0
5455350 2491516 2491516 defendant Garnon John husbandman 593991 593991 Garnon, John, of Gosbak, husbandman 1
5467202 2495134 2495134 defendant Gouty John husbandman 593991 593991 Gouty, John, of Gosbak, husbandman 0
5467203 2495134 2495134 defendant Gard John husbandman 593991 593991 Gard, John, of Gosbak, husbandman 1
5518386 2510578 2510578 defendant Garnon Thomas husbandman 593991 593991 Garnon, Thomas, of Gosbak, husbandman 0
5518387 2510578 2510578 defendant Garnon John husbandman 593991 593991 Garnon, John, of Gosbak, husbandman 1

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);