names

20 rows where case_id = 2451766

✎ 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
5322367 2451766 2451766 plaintiff Middelton William   618087 618087 Middelton, William, of Hardwykwall 0
5322368 2451766 2451766 defendant Lee Robert, senior esq 595442 595442 Lee, Robert, senior, of Adlyngton, Cheshire, esq 0
5322369 2451766 2451766 defendant Crosle Thomas yeoman 873226 873226 Crosle, Thomas, of Blakebroke, yeoman 1
5322370 2451766 2451766 defendant Stones Nicholas yeoman 873226 873226 Stones, Nicholas, of Blakebroke, yeoman 2
5322371 2451766 2451766 defendant Swynstowe William yeoman 873227 873227 Swynstowe, William, of Eynes, yeoman 3
5322372 2451766 2451766 defendant Broun Peter yeoman 615889 615889 Broun, Peter, of Chapel in le Fryth, yeoman 4
5322373 2451766 2451766 defendant Dykson John yeoman 873228 873228 Dykson, John, of Whytehalgh, yeoman 5
5322374 2451766 2451766 defendant Marchyngton Roger yeoman 873229 873229 Marchyngton, Roger, of Bradshawegge, yeoman 6
5322375 2451766 2451766 defendant Chorley Thurstan yeoman 873230 873230 Chorley, Thurstan, of Courses, yeoman 7
5322376 2451766 2451766 defendant Swynstowe William yeoman 615889 615889 Swynstowe, William, of Chapel in le Fryth, yeoman 8
5322377 2451766 2451766 defendant Shore John yeoman 718199 718199 Shore, John, of Gorstelowe, yeoman 9
5322378 2451766 2451766 defendant Redfern William yeoman 873231 873231 Redfern, William, of Brounsyde, yeoman 10
5322379 2451766 2451766 defendant Redfern William yeoman 873232 873232 Redfern, William, of Malcalfe, yeoman 11
5322380 2451766 2451766 defendant Broun Thomas yeoman 873232 873232 Broun, Thomas, of Malcalfe, yeoman 12
5322381 2451766 2451766 defendant Tedryngton William yeoman 873232 873232 Tedryngton, William, of Malcalfe, yeoman 13
5322382 2451766 2451766 defendant Tedryngton Thomas yeoman 615889 615889 Tedryngton, Thomas, of Chapel in le Fryth, yeoman 14
5322383 2451766 2451766 defendant Couper Ralph yeoman 761440 761440 Couper, Ralph, of Glossop, yeoman 15
5322384 2451766 2451766 defendant Halle William yeoman 608951 608951 Halle, William, of Fayrefeld, yeoman 16
5322385 2451766 2451766 defendant Redfern Nicholas yeoman 761440 761440 Redfern, Nicholas, of Glossop, yeoman 17
5322386 2451766 2451766 defendant Redfern Walter yeoman 761440 761440 Redfern, Walter, of Glossop, yeoman 18

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