names

22 rows where case_id = 2267964

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4708264 2267964 2267964 plaintiff Neweman Thomas     Neweman, Thomas 0
4708265 2267964 2267964 defendant Baldewyne John   778087 778087 Baldewyne, John, of Saltwode, Kent, wax chandler 0
4708266 2267964 2267964 defendant Carpenter Roger shipman 756301 756301 Carpenter, Roger, of Hethe or Hythe, shipman 1
4708267 2267964 2267964 defendant Alisaundre John shipman   Alisaundre, John, shipman 2
4708268 2267964 2267964 defendant Appelford Richard servant of Alexander Appelford, laborer   Appelford, Richard, servant of Alexander Appelford, laborer 3
4708269 2267964 2267964 defendant Appelford Alexander yeoman   Appelford, Alexander, yeoman 4
4708270 2267964 2267964 defendant Philpot   yeoman   Philpot, yeoman 5
4708271 2267964 2267964 defendant atte Rye Stephen shipman   atte Rye, Stephen, shipman 6
4708272 2267964 2267964 defendant Bannok Robert shipman   Bannok, Robert, shipman 7
4708273 2267964 2267964 defendant Cundy John yeoman   Cundy, John, yeoman 8
4708274 2267964 2267964 defendant atte Mede William yeoman   atte Mede, William, yeoman 9
4708275 2267964 2267964 defendant Sende Thomas shipman   Sende, Thomas, shipman 10
4708276 2267964 2267964 defendant Overhevene John shipman   Overhevene, John, shipman 11
4708277 2267964 2267964 defendant Neston Geoffrey tanner   Neston, Geoffrey, tanner 12
4708278 2267964 2267964 defendant Hendyk Thomas butcher   Hendyk, Thomas, butcher 13
4708279 2267964 2267964 defendant Barbour Thomas barber   Barbour, Thomas, barber 14
4708280 2267964 2267964 defendant Colyn John skinner   Colyn, John, skinner 15
4708281 2267964 2267964 defendant Rollyng Thomas brewer   Rollyng, Thomas, brewer 16
4708282 2267964 2267964 defendant Martyn Nicholas baker   Martyn, Nicholas, baker 17
4708283 2267964 2267964 defendant Tulk Simon fuller 611875 611875 Tulk, Simon, of Saltwode, fuller 18
4708284 2267964 2267964 defendant Byx John drover 788515 788515 Byx, John, of Lymene, drover 19
4708285 2267964 2267964 defendant Skynner John brewer 601312 601312 Skynner, John, of Hythe, 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);