names

27 rows where place_id = 653051

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3927081 1999395 1999395 defendant Mychelson Andrew, junior mariner 653051 653051 Mychelson, Andrew, junior, of Cley next the sea, Norf, mariner 0
3927087 1999396 1999396 defendant Mychelson Andrew, junior mariner 653051 653051 Mychelson, Andrew, junior, of Cley next the sea, Norf, mariner 0
3934257 2001752 2001752 defendant Salter Richard merchant 653051 653051 Salter, Richard, of Cley next the Sea, Norf, merchant 0
4016442 2030585 2030585 defendant Lyttell Robert merchant 653051 653051 Lyttell, Robert, of Cley next the Sea, Norf, merchant 0
5042766 2369442 2369442 defendant Broun William yeoman 653051 653051 (Broun, William, of Cley next the sea, Norf, yeoman 1
5132802 2396089 2396089 defendant Horne William merchant 653051 653051 Horne, William, of Cley next the Sea, Norf, merchant 0
5149647 2401025 2401025 defendant Horn William merchant 653051 653051 Horn, William, of Cley next the sea, Norf, merchant 0
5157300 2403275 2403275 defendant Gyles John yeoman 653051 653051 Gyles, John, of Cley next the sea, Norf, yeoman 1
5160624 2404202 2404202 defendant Broune William merchant 653051 653051 Broune, William, of Cley next the sea, Norf, merchant 0
5168518 2406507 2406507 defendant Horn William merchant 653051 653051 Horn, William, of Cley next the sea, Norf, merchant 0
5175380 2408489 2408489 defendant Broune William merchant 653051 653051 Broune, William, of Cley next the sea, Norf, merchant 0
5184495 2411208 2411208 defendant Horn William merchant 653051 653051 Horn, William, of Cley next the Sea, Norf, merchant 0
5184497 2411209 2411209 defendant Horn William merchant 653051 653051 Horn, William, of Cley next the Sea, Norf, merchant 0
5193094 2413710 2413710 defendant Wyndeler Robert husbandman 653051 653051 Wyndeler, Robert, of Cley next the Sea, Norf, husbandman 0
5202623 2416531 2416531 defendant Overey Roger shipman 653051 653051 Overey, Roger, of Cley next the Sea, Norf, shipman 1
5203898 2416891 2416891 defendant Barton Ralph yeoman 653051 653051 Barton, Ralph, of Cley next the Sea, Norf, yeoman 2
5271775 2436841 2436841 defendant Torald Margaret widow 653051 653051 Torald, Margaret, of Cley next the sea, Norf, widow 3
5303051 2445903 2445903 defendant Baxter Edmund yeoman 653051 653051 Baxter, Edmund, of Cley next the sea, Norf, yeoman 2
5304105 2446236 2446236 defendant Andrewe William   653051 653051 Andrewe, William, of Cley next the sea, Norf, yeoman, formerly fishmonger of London 0
5373013 2467150 2467150 defendant Pyrtte Robert yeoman 653051 653051 Pyrtte, Robert, of Cley next the sea, Norf, yeoman 0
5377628 2468585 2468585 defendant Pyrt Robert   653051 653051 Pyrt, Robert, of Cley next the Sea, Norf, tallow chandler 0
5382811 2470151 2470151 defendant Pyrt Robert   653051 653051 Pyrt, Robert, of Cley next the sea, Norf, tallow chandler 0
5403778 2476155 2476155 defendant Breyg John gent 653051 653051 Breyg, John, of Cley next the sea, Norf, gent 2
5417000 2479995 2479995 defendant Breyg John gent 653051 653051 Breyg, John, of Cley next the Sea, Norf, gent 1
5437609 2486184 2486184 defendant Skendelesby Roger merchant 653051 653051 Skendelesby, Roger, of Cley next the sea, Norf, merchant 0
5437998 2486300 2486300 defendant Pyrte Robert   653051 653051 Pyrte, Robert, of Cley next the sea, Norf, tallow chandler 0
5609555 2537884 2537884 defendant Pyrt Robert   653051 653051 Pyrt, Robert, of Cley next the sea, Norf, tallow chandler 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);