names

32 rows where place_id = 638553

✎ 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
3843367 1971459 1971459 defendant Boyes Robert husbandman 638553 638553 Boyes, Robert, of Brigge, husbandman 0
3843368 1971459 1971459 defendant Newman Robert husbandman 638553 638553 Newman, Robert, of Brigge, husbandman 1
4171042 2085354 2085354 defendant Owyn John mercer 638553 638553 Owyn, John, of Brigge, mercer 0
4171047 2085355 2085355 defendant Owyn John mercer 638553 638553 Owyn, John, of Brigge, mercer 0
4188756 2091546 2091546 defendant Southe William yeoman 638553 638553 Southe, William, of Brigge, yeoman 0
4205986 2097640 2097640 defendant Naneby or Naveby John chapman 638553 638553 Naneby or Naveby, John, of Brigge, or of Lamforth, chapman 0
4219386 2102280 2102280 defendant Anderson James yeoman 638553 638553 Anderson, James, of Brigge, or of Caburne, yeoman 0
4221598 2103043 2103043 defendant Townend John draper 638553 638553 Townend, John, of Brigge, draper 1
4282641 2123832 2123832 defendant Watson Francis draper 638553 638553 Watson, Francis, of Brigge, draper 0
4282643 2123833 2123833 defendant Watson Francis draper 638553 638553 Watson, Francis, of Brigge, draper 0
4282645 2123834 2123834 defendant Watson Francis draper 638553 638553 Watson, Francis, of Brigge, draper 0
4282667 2123841 2123841 defendant Wolfoote Ralph yeoman 638553 638553 Wolfoote, Ralph, of Brigge, yeoman 0
4293611 2127779 2127779 defendant Hempsall Edward chandler 638553 638553 Hempsall, Edward, of Brigge, yeoman, chandler 0
4293612 2127779 2127779 defendant Hempsall Alexander turner 638553 638553 Hempsall, Alexander, of Brigge, laborer, turner 1
4299406 2129878 2129878 defendant Hempsall Alexander turner 638553 638553 Hempsall, Alexander, of Brigge, laborer, turner 2
4321771 2137703 2137703 defendant Wolfoote Ralph yeoman 638553 638553 Wolfoote, Ralph, of Brigge, yeoman 0
4357648 2149908 2149908 defendant Codd James chapman 638553 638553 Codd, James, of Brigge, chapman 2
4725017 2273118 2273118 defendant West John husbandman 638553 638553 West, John, of Brigge, husbandman 0
4790917 2293251 2293251 defendant atte Gate William smith 638553 638553 atte Gate, William, of Brigge, smith 0
4842484 2309185 2309185 defendant Machon William fishmonger 638553 638553 Machon, William, of Brigge, fishmonger 2
4846436 2310391 2310391 defendant Lylye Richard fisherman 638553 638553 Lylye, Richard, of Brigge, fisherman 0
4894868 2325058 2325058 defendant Machon William fisher 638553 638553 Machon, William, of Brigge, fisher 5
5017436 2361988 2361988 defendant Gate William husbandman 638553 638553 Gate, William, of Brigge, husbandman 1
5279555 2439096 2439096 defendant Blande William yeoman 638553 638553 Blande, William, of Brigge, yeoman 1
5293106 2442968 2442968 defendant Turney Thomas tanner 638553 638553 Turney, Thomas, of Brigge, tanner 1
5293123 2442971 2442971 defendant Turney Thomas tanner 638553 638553 Turney, Thomas, of Brigge, tanner 1
5372058 2466857 2466857 defendant Wymar John merchant 638553 638553 Wymar, John, of Brigge Water, merchant 0
5396139 2473982 2473982 plaintiff Bertram Ellis Master of the Hospital of St John the Baptist 638553 638553 Bertram, Ellis, of Brigge water, Master of the Hospital of St John the Baptist 0
5396140 2473982 2473982 defendant Smyth Thomas merchant 638553 638553 Smyth, Thomas, of Brigge water, merchant 0
5400513 2475214 2475214 defendant Bette John chaplain 638553 638553 Bette, John, of Brigge water, chaplain 0
5405638 2476686 2476686 defendant Tomson Henry husbandman 638553 638553 Tomson, Henry, of Brigge, husbandman 2
5593277 2532878 2532878 defendant Shepard John, junior husbandman 638553 638553 Shepard, John, junior, of Brigge, husbandman 4

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