names

28 rows where place_id = 591744

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605410 1869358 1869358 defendant Byle Peter clerk 591744 591744 Byle, Peter, of Basyng, Hants, clerk 2
3658510 1912913 1912913 defendant Godyer Thomas yeoman 591744 591744 Godyer, Thomas, of Basyng, Hants, yeoman 1
3691038 1923362 1923362 defendant Cowfold John gent 591744 591744 Cowfold, John, of Basyng, Hants, gent 0
4676192 2258166 2258166 defendant Ponynges Hugh de esq 591744 591744 Ponynges, Hugh de, of Basyng, Hants, son & heir of Thomas de Ponynges, esq 0
5045043 2370151 2370151 defendant Waterend Thomas husbandman 591744 591744 Waterend, Thomas, of Basyng, Hants, husbandman 1
5077292 2379710 2379710 defendant Cowfeld John gent 591744 591744 Cowfeld, John, of Basyng, Hants, gent 0
5077296 2379711 2379711 defendant Cowfeld John gent 591744 591744 Cowfeld, John, of Basyng, Hants, gent 0
5077300 2379712 2379712 defendant Cowfeld John gent 591744 591744 Cowfeld, John, of Basyng, Hants, gent 0
5225462 2423122 2423122 defendant Colton Robert skinner 591744 591744 Colton, Robert, of Basyng, Hants, skinner 2
5316583 2450045 2450045 defendant Smyth Nicholas chapman 591744 591744 Smyth, Nicholas, of Basyng, Hants, chapman 1
5316588 2450046 2450046 defendant Smyth John chapman 591744 591744 Smyth, John, of Basyng, Hants, chapman 0
5322068 2451672 2451672 defendant Paulyte John esq 591744 591744 Paulyte, John, of Basyng, Hants, esq 3
5338085 2456481 2456481 defendant Paulet Joh esq 591744 591744 Paulet, Joh, of Basyng, Hants, esq 2
5343207 2458069 2458069 defendant Smyth Nicholas hardwareman 591744 591744 Smyth, Nicholas, of Basyng, Hants, hardwareman 0
5360906 2463438 2463438 defendant A More Thomas husbandman 591744 591744 A More, Thomas, of Basyng, Hants, husbandman 1
5431419 2484349 2484349 defendant Poulet John, sen esq 591744 591744 Poulet, John, sen, of Basyng, Hants, esq 0
5442216 2487593 2487593 defendant Mulford Richard yeoman 591744 591744 Mulford, Richard, of Basyng, Hants, yeoman 3
5447864 2489245 2489245 defendant Poulet John, sen esq 591744 591744 Poulet, John, sen, of Basyng, Hants, esq 0
5447867 2489246 2489246 defendant Poulet John, senior esq 591744 591744 Poulet, John, senior, of Basyng, Hants, esq 0
5454960 2491401 2491401 defendant Mulford Richard yeoman 591744 591744 Mulford, Richard, of Basyng, Hants, yeoman 3
5466700 2494989 2494989 defendant Mulford Richard yeoman 591744 591744 Mulford, Richard, of Basyng, Hants, yeoman 1
5474066 2497221 2497221 defendant More Thomas husbandman 591744 591744 More, Thomas, of Basyng, Hants, husbandman 3
5485504 2500576 2500576 defendant More Thomas yeoman 591744 591744 More, Thomas, of Basyng, Hants, yeoman 3
5485515 2500578 2500578 defendant More Thomas yeoman 591744 591744 More, Thomas, of Basyng, Hants, yeoman 3
5489903 2501866 2501866 defendant Frankelyn John yeoman 591744 591744 Frankelyn, John, of Basyng, Hants, yeoman 4
5491799 2502448 2502448 defendant Frankeleyn John yeoman 591744 591744 Frankeleyn, John, of Basyng, Hants, yeoman 1
5557164 2522056 2522056 defendant Lyde William fuller 591744 591744 Lyde, William, of Basyng, Hants, fuller 0
5567837 2525173 2525173 defendant Lyede William husbandman 591744 591744 Lyede, William, of Basyng, Hants, husbandman 0

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