names

17 rows where place_id = 658492

✎ 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
3948647 2006587 2006587 defendant Eryte or Gryte Thomas husbandman 658492 658492 Eryte or Gryte, Thomas, of Algarkirke, husbandman 0
4036397 2037701 2037701 plaintiff Hunnyng Roger yeoman 658492 658492 Hunnyng, Roger, of Algarkirke, yeoman 0
4236104 2108197 2108197 defendant Knott Robert yeoman 658492 658492 Knott, Robert, of Algarkirke, yeoman 0
4236109 2108199 2108199 defendant Benackle John yeoman 658492 658492 Benackle, John, of Algarkirke, yeoman 0
4317574 2136261 2136261 defendant Hunnynge Roger yeoman 658492 658492 Hunnynge, Roger, of Algarkirke, yeoman 0
4317576 2136262 2136262 defendant Hunnynge Roger yeoman 658492 658492 Hunnynge, Roger, of Algarkirke, yeoman 0
4453152 2185993 2185993 plaintiff Langdan William de   658492 658492 Langdan, William de, of Algarkirke 0
4497583 2199889 2199889 defendant Toup John   658492 658492 Toup, John, of Algarkirke 0
4501935 2201205 2201205 defendant Smyth John   658492 658492 Smyth, John, of Algarkirke 2
4694069 2263647 2263647 plaintiff Betteson John   658492 658492 Betteson, John, of Algarkirke, son of Hugh 0
4824430 2303693 2303693 defendant Adam John, senior husbandman 658492 658492 Adam, John, senior, of Algarkirke, husbandman 0
4904944 2328150 2328150 defendant Toupe Katherine widow 658492 658492 Toupe, Katherine, of Algarkirke, widow 0
4964306 2346236 2346236 defendant Athelyn William husbandman 658492 658492 Athelyn, William, of Algarkirke, husbandman 0
5002687 2357697 2357697 defendant Thosyll Thomas gent 658492 658492 Thosyll, Thomas, of algarkirke, gent 0
5152868 2401980 2401980 defendant Felde Robert yeoman 658492 658492 Felde, Robert, of Algarkirke, yeoman 0
5188582 2412382 2412382 defendant Felde Robert yeoman 658492 658492 Felde, Robert, of Algarkirke, yeoman 0
5612024 2547492 2547492 defendant Abraham Thomas   658492 658492 Abraham, Thomas, of Algarkirke 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);