names

22 rows where case_id = 2275118

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4731727 2275118 2275118 plaintiff Neweman Thomas     Neweman, Thomas 0
4731728 2275118 2275118 defendant Baldewyne John   611875 611875 Baldewyne, John, of Saltwode, wax chandler 0
4731729 2275118 2275118 defendant Carpenter Roger shipman   Carpenter, Roger, shipman 1
4731730 2275118 2275118 defendant Alisaundre John shipman   Alisaundre, John, shipman 2
4731731 2275118 2275118 defendant Appelford Richard laborer, servant of Alisaunder   Appelford, Richard, laborer, servant of Alisaunder 3
4731732 2275118 2275118 defendant Appelford Alexander yeoman   Appelford, Alexander, yeoman 4
4731733 2275118 2275118 defendant Philpot Henry yeoman   Philpot, Henry, yeoman 5
4731734 2275118 2275118 defendant atte Rye Stephen shipman   atte Rye, Stephen, shipman 6
4731735 2275118 2275118 defendant Bannok Robert shipman   Bannok, Robert, shipman 7
4731736 2275118 2275118 defendant Cundy John yeoman   Cundy, John, yeoman 8
4731737 2275118 2275118 defendant atte Mede Wiliam yeoman   atte Mede, Wiliam, yeoman 9
4731738 2275118 2275118 defendant Sende Thomas shipman   Sende, Thomas, shipman 10
4731739 2275118 2275118 defendant Overhevene John shipman   Overhevene, John, shipman 11
4731740 2275118 2275118 defendant Neston Geoffrey tanner   Neston, Geoffrey, tanner 12
4731741 2275118 2275118 defendant Hendik Thomas butcher   Hendik, Thomas, butcher 13
4731742 2275118 2275118 defendant Barbour Thomas barber   Barbour, Thomas, barber 14
4731743 2275118 2275118 defendant Colyn John skinner   Colyn, John, skinner 15
4731744 2275118 2275118 defendant Rollyng Thomas brewer   Rollyng, Thomas, brewer 16
4731745 2275118 2275118 defendant Martyn Nicholas baker   Martyn, Nicholas, baker 17
4731746 2275118 2275118 defendant Tulk Simon fuller 611875 611875 Tulk, Simon, of Saltwode, fuller 18
4731747 2275118 2275118 defendant Bix John drover 788515 788515 Bix, John, of Lymene, drover 19
4731748 2275118 2275118 defendant Skynner John brewer 612917 612917 Skynner, John, of Hethe, brewer 20

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