names

22 rows where case_id = 2463552

✎ 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
5361269 2463552 2463552 plaintiff Stanhop Thomas esq   Stanhop, Thomas, esq 0
5361270 2463552 2463552 defendant Meryng Thomas gent 595541 595541 Meryng, Thomas, of Ossyngton, gent 0
5361271 2463552 2463552 defendant Meryng Alexander gent 595541 595541 Meryng, Alexander, of Ossyngton, gent 1
5361272 2463552 2463552 defendant Meryng Francis gent 595541 595541 Meryng, Francis, of Ossyngton, gent 2
5361273 2463552 2463552 defendant Derre Thomas smith 613622 613622 Derre, Thomas, of Colyngham, smith 3
5361274 2463552 2463552 defendant Harwode Thomas husbandman 613622 613622 Harwode, Thomas, of Colyngham, husbandman 4
5361275 2463552 2463552 defendant Pygge John husbandman 613622 613622 Pygge, John, of Colyngham, husbandman 5
5361276 2463552 2463552 defendant Faukoner Henry draper 587948 587948 Faukoner, Henry, of Newerk, draper 6
5361277 2463552 2463552 defendant Hune Andrew ostler 587948 587948 Hune, Andrew, of Newerk, ostler 7
5361278 2463552 2463552 defendant Grubbe William husbandman 876092 876092 Grubbe, William, of Thornowe, husbandman 8
5361279 2463552 2463552 defendant Thomson Edward yeoman 876092 876092 Thomson, Edward, of Thornowe, yeoman 9
5361280 2463552 2463552 defendant Brigge John butcher 587948 587948 Brigge, John, of Newerk, butcher 10
5361281 2463552 2463552 defendant Fox Robert yeoman 593592 593592 Fox, Robert, of Thorney, yeoman 11
5361282 2463552 2463552 defendant Banester William clerk 587947 587947 Banester, William, of Kellom, clerk 12
5361283 2463552 2463552 defendant Skrymshyre Robert chaplain 587947 587947 Skrymshyre, Robert, of Kellom, chaplain 13
5361284 2463552 2463552 defendant Bostok William yeoman 587947 587947 Bostok, William, of Kellom, yeoman 14
5361285 2463552 2463552 defendant Taillour Richard yeoman 593049 593049 Taillour, Richard, of North Muskham, yeoman 15
5361286 2463552 2463552 defendant Boyer William boyer 587948 587948 Boyer, William, of Newerk, boyer 16
5361287 2463552 2463552 defendant Gelston William yeoman 587948 587948 Gelston, William, of Newerk, yeoman 17
5361288 2463552 2463552 defendant Broke John cordwainer 587948 587948 Broke, John, of Newerk, cordwainer 18
5361289 2463552 2463552 defendant Gryffyn William yeoman 877576 877576 Gryffyn, William, of Granley, yeoman 19
5361290 2463552 2463552 defendant Unwyn John barker 587948 587948 Unwyn, John, of Newerk, barker 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);