names

18 rows where case_id = 1915462

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3666459 1915462 1915462 plaintiff Tynemouth John prior of the Monastery of the Blessed Mary & St Oswin, in   Tynemouth, John, prior of the Monastery of the Blessed Mary & St Oswin, in 0
3666460 1915462 1915462 defendant Ogle John gent 606767 606767 Ogle, John, of Shawdon, gent 0
3666461 1915462 1915462 defendant Roose Robert yeoman 588103 588103 Roose, Robert, of Bentley, yeoman 1
3666462 1915462 1915462 defendant Harygold John yeoman 588103 588103 Harygold, John, of Bentley, yeoman 2
3666463 1915462 1915462 defendant Gotherson David yeoman 606768 606768 Gotherson, David, of Bently, yeoman 3
3666464 1915462 1915462 defendant Styrket John yeoman 606769 606769 Styrket, John, of Eglyngeham within the Liberty of Tynmouth, yeoman 4
3666465 1915462 1915462 defendant Herygold Edward yeoman 588103 588103 Herygold, Edward, of Bentley, yeoman 5
3666466 1915462 1915462 defendant Herybold John yeoman 589876 589876 Herybold, John, of Branton, yeoman 6
3666467 1915462 1915462 defendant Gibson Thomas yeoman 606770 606770 Gibson, Thomas, of Aglyngeham within the Liberty of Tynemouth, yeoman 7
3666468 1915462 1915462 defendant Wytte Thomas yeoman 606771 606771 Wytte, Thomas, of Aglyngeham, yeoman 8
3666469 1915462 1915462 defendant Shotton Edward yeoman 606772 606772 Shotton, Edward, of Aylingeham, yeoman 9
3666470 1915462 1915462 defendant Johnson Thomas yeoman 606771 606771 Johnson, Thomas, of Aglyngeham, yeoman 10
3666471 1915462 1915462 defendant Henmarse Thomas yeoman 588103 588103 Henmarse, Thomas, of Bentley, yeoman 11
3666472 1915462 1915462 defendant Bewyk William   606771 606771 Bewyk, William, of Aglyngeham 12
3666473 1915462 1915462 defendant Cawuerd John yeoman 606771 606771 Cawuerd, John, of Aglyngeham, yeoman 13
3666474 1915462 1915462 defendant Bewik Andrew   606771 606771 Bewik, Andrew, of Aglyngeham 14
3666475 1915462 1915462 defendant Archer Edward   606771 606771 Archer, Edward, of Aglyngeham 15
3666476 1915462 1915462 defendant Harebotell Richard yeoman 606771 606771 Harebotell, Richard, of Aglyngeham, yeoman 16

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