names

20 rows where case_id = 2451767

✎ 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
5322387 2451767 2451767 plaintiff Middelton William   618087 618087 Middelton, William, of Hardwykwall 0
5322388 2451767 2451767 defendant Lee Robert, senior esq 595442 595442 Lee, Robert, senior, of Adlyngton, Cheshire, esq 0
5322389 2451767 2451767 defendant Crosle Thomas yeoman 873226 873226 Crosle, Thomas, of Blakebroke, yeoman 1
5322390 2451767 2451767 defendant Stones Nicholas yeoman 873226 873226 Stones, Nicholas, of Blakebroke, yeoman 2
5322391 2451767 2451767 defendant Swynstowe William yeoman 873227 873227 Swynstowe, William, of Eynes, yeoman 3
5322392 2451767 2451767 defendant Broun Peter yeoman 615889 615889 Broun, Peter, of Chapel in le Fryth, yeoman 4
5322393 2451767 2451767 defendant Dykson John yeoman 873228 873228 Dykson, John, of Whytehalgh, yeoman 5
5322394 2451767 2451767 defendant Marchyngton Roger yeoman 873229 873229 Marchyngton, Roger, of Bradshawegge, yeoman 6
5322395 2451767 2451767 defendant Chorley Thurstan yeoman 873230 873230 Chorley, Thurstan, of Courses, yeoman 7
5322396 2451767 2451767 defendant Swynstowe William yeoman 615889 615889 Swynstowe, William, of Chapel in le Fryth, yeoman 8
5322397 2451767 2451767 defendant Shore John yeoman 718199 718199 Shore, John, of Gorstelowe, yeoman 9
5322398 2451767 2451767 defendant Redfern William yeoman 873231 873231 Redfern, William, of Brounsyde, yeoman 10
5322399 2451767 2451767 defendant Redfern William yeoman 873232 873232 Redfern, William, of Malcalfe, yeoman 11
5322400 2451767 2451767 defendant Broun Thomas yeoman 873232 873232 Broun, Thomas, of Malcalfe, yeoman 12
5322401 2451767 2451767 defendant Tedryngton William yeoman 873232 873232 Tedryngton, William, of Malcalfe, yeoman 13
5322402 2451767 2451767 defendant Tedryngton Thomas yeoman 615889 615889 Tedryngton, Thomas, of Chapel in le Fryth, yeoman 14
5322403 2451767 2451767 defendant Couper Ralph yeoman 761440 761440 Couper, Ralph, of Glossop, yeoman 15
5322404 2451767 2451767 defendant Halle William yeoman 608951 608951 Halle, William, of Fayrefeld, yeoman 16
5322405 2451767 2451767 defendant Redfern Nicholas yeoman 761440 761440 Redfern, Nicholas, of Glossop, yeoman 17
5322406 2451767 2451767 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);