names

23 rows where place_id = 628553

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3782984 1952426 1952426 defendant Whytston William gent 628553 628553 Whytston, William, of Whytston, gent 0
3782986 1952427 1952427 defendant Whytston William gent 628553 628553 Whytston, William, of Whytston, gent 0
3897019 1989220 1989220 defendant Rous John gent 628553 628553 Rous, John, of Whytston, gent 0
3919878 1996981 1996981 defendant Paynter John, senior husbandman 628553 628553 Paynter, John, senior, of Whytston, husbandman 2
3919880 1996982 1996982 defendant Paynter John, senior husbandman 628553 628553 Paynter, John, senior, of Whytston, husbandman 0
3969462 2013926 2013926 plaintiff Cottell John   628553 628553 Cottell, John, of Whytston 0
4011311 2028821 2028821 defendant Paynter John, senior   628553 628553 Paynter, John, senior, of Whytston 0
4041180 2039335 2039335 defendant Offe John, senior husbandman 628553 628553 Offe, John, senior, of Whytston, husbandman 1
4041181 2039335 2039335 defendant Offe John, junior husbandman 628553 628553 Offe, John, junior, of Whytston, husbandman 2
4144153 2076118 2076118 defendant Petyck John, senior husbandman 628553 628553 Petyck, John, senior, of Whytston, husbandman 0
4144154 2076118 2076118 defendant Petick John, junior husbandman 628553 628553 Petick, John, junior, of Whytston, husbandman 1
4192160 2092822 2092822 defendant Chapman John husbandman or yeoman 628553 628553 Chapman, John, of Whytston, husbandman or yeoman 1
4311735 2134245 2134245 defendant Sowdon Henry yeoman 628553 628553 Sowdon, Henry, of Whytston, yeoman 2
4777759 2289037 2289037 defendant Edewyn Philip smith 628553 628553 Edewyn, Philip, of Whytston, smith 1
5128163 2394710 2394710 defendant Burnell William husbandman 628553 628553 Burnell, William, of Whytston, husbandman 3
5128164 2394710 2394710 defendant Storygge John husbandman 628553 628553 Storygge, John, of Whytston, husbandman 4
5211491 2419098 2419098 defendant Pethek William husbandman 628553 628553 Pethek, William, of Whytston, husbandman 0
5426298 2482819 2482819 defendant Tyak John clerk 628553 628553 Tyak, John, of Whytston, clerk 0
5426299 2482819 2482819 defendant Brounescombe William husbandman 628553 628553 Brounescombe, William, of Whytston, husbandman 1
5444445 2488245 2488245 defendant Eyak John clerk 628553 628553 Eyak, John, of Whytston, clerk 0
5457182 2492045 2492045 defendant Tyak John clerk 628553 628553 Tyak, John, of Whytston, clerk 0
5457183 2492045 2492045 defendant Brounscombe William husbandman 628553 628553 Brounscombe, William, of Whytston, husbandman 1
5526098 2512738 2512738 defendant Hebbot John gent 628553 628553 Hebbot, John, of Whytston, gent 7

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