names

22 rows where case_id = 2378688

✎ 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
5073906 2378688 2378688 plaintiff Waynflete William Bishop of Winchester   Waynflete, William, Bishop of Winchester 0
5073907 2378688 2378688 defendant Whykeham William esq 586183 586183 Whykeham, William, of Broghton, esq 0
5073908 2378688 2378688 defendant Frebody Henry gent 590892 590892 Frebody, Henry, of Bloxham, gent 1
5073909 2378688 2378688 defendant Averey Thomas gent 590892 590892 Averey, Thomas, of Bloxham, gent 2
5073910 2378688 2378688 defendant Middelton John yeoman 590892 590892 Middelton, John, of Bloxham, yeoman 3
5073911 2378688 2378688 defendant Dene Thomas baker 590892 590892 Dene, Thomas, of Bloxham, baker 4
5073912 2378688 2378688 defendant Knyght William yeoman 590892 590892 Knyght, William, of Bloxham, yeoman 5
5073913 2378688 2378688 defendant Westcote John husbandman 590892 590892 Westcote, John, of Bloxham, husbandman 6
5073914 2378688 2378688 defendant Palmer William husbandman 590892 590892 Palmer, William, of Bloxham, husbandman 7
5073915 2378688 2378688 defendant Shelton John husbandman 590892 590892 Shelton, John, of Bloxham, husbandman 8
5073916 2378688 2378688 defendant Freman Miles weaver 590892 590892 Freman, Miles, of Bloxham, weaver 9
5073917 2378688 2378688 defendant Large Thomas butcher 590892 590892 Large, Thomas, of Bloxham, butcher 10
5073918 2378688 2378688 defendant Draper Thomas   590892 590892 Draper, Thomas, of Bloxham, servant 11
5073919 2378688 2378688 defendant Saron John laborer 590892 590892 Saron, John, of Bloxham, laborer 12
5073920 2378688 2378688 defendant Asshe Richard butcher 590892 590892 Asshe, Richard, of Bloxham, butcher 13
5073921 2378688 2378688 defendant Helmeden John husbandman 590892 590892 Helmeden, John, of Bloxham, husbandman 14
5073922 2378688 2378688 defendant Coke Robert yeoman 599756 599756 Coke, Robert, of Newynton, yeoman 15
5073923 2378688 2378688 defendant Smyth Thomas yeoman 625073 625073 Smyth, Thomas, of Melcombe, yeoman 16
5073924 2378688 2378688 defendant Chase John yeoman 586183 586183 Chase, John, of Broghton, yeoman 17
5073925 2378688 2378688 defendant Archer Richard yeoman 599756 599756 Archer, Richard, of Newynton, yeoman 18
5073926 2378688 2378688 defendant Dolfyn Robert smith 586248 586248 Dolfyn, Robert, of Wygynton, smith 19
5073927 2378688 2378688 defendant Rede Thomas fuller 588978 588978 Rede, Thomas, of Banbury, fuller 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);