names

16 rows where case_id = 2457532

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5341494 2457532 2457532 plaintiff Pylkyngton Charles esq   Pylkyngton, Charles, esq 0
5341495 2457532 2457532 defendant Blyton William esq 591977 591977 Blyton, William, of Laxton, esq 0
5341496 2457532 2457532 defendant Nevell William gent 875415 875415 Nevell, William, of South Laverton, gent 1
5341497 2457532 2457532 defendant Caxton John yeoman 643605 643605 Caxton, John, of Tukkesforth, yeoman 2
5341498 2457532 2457532 defendant Swallowe Oliver yeoman 599019 599019 Swallowe, Oliver, of Stirton, yeoman 3
5341499 2457532 2457532 defendant Thorysby John yeoman 599019 599019 Thorysby, John, of Stirton, yeoman 4
5341500 2457532 2457532 defendant Webster William yeoman 599019 599019 Webster, William, of Stirton, yeoman 5
5341501 2457532 2457532 defendant Coton John husbandman 875416 875416 Coton, John, of Sonber, husbandman 6
5341502 2457532 2457532 defendant Elsley Robert yeoman 591864 591864 Elsley, Robert, of Hedon, yeoman 7
5341503 2457532 2457532 defendant Scotte Thomas yeoman 586121 586121 Scotte, Thomas, of Carleton, yeoman 8
5341504 2457532 2457532 defendant Heytfeld Lawrence yeoman 594222 594222 Heytfeld, Lawrence, of Egmanton, yeoman 9
5341505 2457532 2457532 defendant Lawe John yeoman 625449 625449 Lawe, John, of Bole, yeoman 10
5341506 2457532 2457532 defendant Stevynson Roger husbandman 592619 592619 Stevynson, Roger, of South Leverton, husbandman 11
5341507 2457532 2457532 defendant Eymer William husbandman 592619 592619 Eymer, William, of South Leverton, husbandman 12
5341508 2457532 2457532 defendant Parker Robert yeoman 607880 607880 Parker, Robert, of Knesall, yeoman 13
5341509 2457532 2457532 defendant Dughty William yeoman 643605 643605 Dughty, William, of Tukkesforth, yeoman 14

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