names

24 rows where place_id = 608268

✎ 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
3633265 1905221 1905221 defendant Turpyn William   608268 608268 Turpyn, William, of Knaptoft, esq, sheriff of Leics 0
3672940 1917549 1917549 defendant Turpyn William gent 608268 608268 Turpyn, William, of Knaptoft, gent 0
3794104 1956023 1956023 defendant Turpyn Mary widow 608268 608268 Turpyn, Mary, of Knaptoft, widow 0
3824475 1965526 1965526 defendant Turpyn Mary widow 608268 608268 Turpyn, Mary, of Knaptoft, widow 0
4457269 2187286 2187286 plaintiff Paynel John   608268 608268 Paynel, John, of Knaptoft, knight 0
4457271 2187287 2187287 plaintiff Paynell John   608268 608268 Paynell, John, of Knaptoft, knight 0
4505323 2202194 2202194 defendant Peynel John   608268 608268 Peynel, John, of Knaptoft 1
4523233 2207590 2207590 defendant Paynell John   608268 608268 Paynell, John, of Knaptoft 4
4642445 2243914 2243914 defendant Paynell John   608268 608268 Paynell, John, of Knaptoft 2
4689947 2262409 2262409 plaintiff Warner William chaplain 608268 608268 Warner, William, of Knaptoft, chaplain 0
4789248 2292696 2292696 defendant Kynnesman Thomas gent 608268 608268 Kynnesman, Thomas, of Knaptoft, gent 0
4868060 2316982 2316982 defendant Kynsman Thomas gent 608268 608268 Kynsman, Thomas, of Knaptoft, gent 0
4894149 2324866 2324866 defendant Kynsman Thomas gent 608268 608268 Kynsman, Thomas, of Knaptoft, gent 0
4933278 2336799 2336799 defendant Hall Richard clerk 608268 608268 Hall, Richard, of Knaptoft, clerk 1
4958618 2344546 2344546 defendant Hall Robert clerk 608268 608268 Hall, Robert, of Knaptoft, clerk 0
5139244 2397968 2397968 defendant Wyn Richard husbandman 608268 608268 Wyn, Richard, of Knaptoft, husbandman 1
5389284 2471979 2471979 defendant Parker Richard yeoman 608268 608268 Parker, Richard, of Knaptoft, yeoman 0
5389285 2471979 2471979 defendant Talbot John yeoman 608268 608268 Talbot, John, of Knaptoft, yeoman 1
5389287 2471980 2471980 defendant Turpyn John gent 608268 608268 Turpyn, John, of Knaptoft, gent 0
5393876 2473311 2473311 defendant Gilbard Richard butcher 608268 608268 Gilbard, Richard, of Knaptoft, butcher 0
5407061 2477081 2477081 defendant Gilbard Richard butcher 608268 608268 Gilbard, Richard, of Knaptoft, butcher 0
5420249 2480979 2480979 defendant Gilbard Richard butcher 608268 608268 Gilbard, Richard, of Knaptoft, butcher 0
5554980 2521459 2521459 defendant Turpyn William esq 608268 608268 Turpyn, William, of Knaptoft, esq 0
5616239 2548872 2548872 plaintiff Herberd William (legal representative) 608268 608268 Herberd, William, of Knaptoft, formerly vicar, executors of 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);