names

14 rows where case_id = 2422818

✎ 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
5224429 2422818 2422818 plaintiff Pullan William     Pullan, William 0
5224430 2422818 2422818 defendant Donwell Robert husbandman 861247 861247 Donwell, Robert, of Staynburn, Forest of Knareburgh, husbandman 0
5224431 2422818 2422818 defendant Colynson William husbandman 756119 756119 Colynson, William, of Lethelay, husbandman 1
5224432 2422818 2422818 defendant Hoggeson John husbandman 861247 861247 Hoggeson, John, of Staynburn, Forest of Knareburgh, husbandman 2
5224433 2422818 2422818 defendant Wylson John husbandman 601143 601143 Wylson, John, of Rygton, husbandman 3
5224434 2422818 2422818 defendant Lowecok John husbandman 861244 861244 Lowecok, John, of Huby juxta Rygton, husbandman 4
5224435 2422818 2422818 defendant Penyston Robert husbandman 861244 861244 Penyston, Robert, of Huby juxta Rygton, husbandman 5
5224436 2422818 2422818 defendant Pullan Robert yeoman 831642 831642 Pullan, Robert, of Thorescrosse, yeoman 6
5224437 2422818 2422818 defendant Gylle Henry husbandman 831642 831642 Gylle, Henry, of Thorescrosse, husbandman 7
5224438 2422818 2422818 defendant Thakwray James husbandman 595849 595849 Thakwray, James, of Cawod, husbandman 8
5224439 2422818 2422818 defendant Benson Richard husbandman 835317 835317 Benson, Richard, of Harowgate, husbandman 9
5224440 2422818 2422818 defendant Forest John husbandman 589888 589888 Forest, John, of Staynburn, husbandman 10
5224441 2422818 2422818 defendant Burnand Robert husbandman 763440 763440 Burnand, Robert, of Mynskyp, husbandman 11
5224442 2422818 2422818 defendant Elys John husbandman 861246 861246 Elys, John, of Ellesworth, Fuston, husbandman 12

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