names

18 rows where case_id = 1911066

✎ 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
3652318 1911066 1911066 plaintiff Underhill William     Underhill, William 0
3652319 1911066 1911066 defendant Horseman John yeoman 602924 602924 Horseman, John, of Compton Wynnyattys, yeoman 0
3652320 1911066 1911066 defendant Coole Benedict yeoman 602924 602924 Coole, Benedict, of Compton Wynnyattys, yeoman 1
3652321 1911066 1911066 defendant Coole John laborer 602924 602924 Coole, John, of Compton Wynnyattys, laborer 2
3652322 1911066 1911066 defendant Johnson George laborer 602924 602924 Johnson, George, of Compton Wynnyattys, laborer 3
3652323 1911066 1911066 defendant Rymyngton Ralph yeoman 602924 602924 Rymyngton, Ralph, of Compton Wynnyattys, yeoman 4
3652324 1911066 1911066 defendant Harryngton Thomas yeoman 602924 602924 Harryngton, Thomas, of Compton Wynnyattys, yeoman 5
3652325 1911066 1911066 defendant Prent Nicholas laborer 602924 602924 Prent, Nicholas, of Compton Wynnyattys, laborer 6
3652326 1911066 1911066 defendant Hampton Thomas yeoman 585869 585869 Hampton, Thomas, of London, yeoman 7
3652327 1911066 1911066 defendant Fychett Richard yeoman 585869 585869 Fychett, Richard, of London, yeoman 8
3652328 1911066 1911066 defendant Cowper Walter yeoman 585869 585869 Cowper, Walter, of London, yeoman 9
3652329 1911066 1911066 defendant Prowde Thomas yeoman 585869 585869 Prowde, Thomas, of London, yeoman 10
3652330 1911066 1911066 defendant Nevyle Christopher laborer 585869 585869 Nevyle, Christopher, of London, laborer 11
3652331 1911066 1911066 defendant Shypston John laborer 602925 602925 Shypston, John, of Shypston on Stowre, Worcs, laborer 12
3652332 1911066 1911066 defendant Remyngton Hugh laborer 602924 602924 Remyngton, Hugh, of Compton Wynnyattys, laborer 13
3652333 1911066 1911066 defendant Lirth Thomas laborer 592125 592125 Lirth, Thomas, of Colbroke, Bucks, laborer 14
3652334 1911066 1911066 defendant Lynnesey Robert yeoman 585869 585869 Lynnesey, Robert, of London, yeoman 15
3652335 1911066 1911066 defendant Trubshawe William laborer 602926 602926 Trubshawe, William, of Wynderton, laborer 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);