names

28 rows where place_id = 592455

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607727 1870069 1870069 defendant Cook John yeoman 592455 592455 Cook, John, of Norton, Derbs, yeoman 3
3607733 1870070 1870070 defendant Cook John yeoman 592455 592455 Cook, John, of Norton, Derbs, yeoman 3
3949964 2007069 2007069 defendant Folyambe Roger gent 592455 592455 Folyambe, Roger, of Norton, Derbs, gent 0
4091539 2057267 2057267 defendant Northe John husbandman 592455 592455 Northe, John, of Norton, Derbs, husbandman 0
4152618 2079030 2079030 defendant Blythe Anthony gent 592455 592455 Blythe, Anthony, of Norton, Derbs, gent 0
4165489 2083430 2083430 defendant Hobson Robert husbandman 592455 592455 Hobson, Robert, of Norton, Derbs, husbandman 2
4541927 2213363 2213363 defendant Selyok William   592455 592455 Selyok, William, of Norton, Derbs 0
4541929 2213364 2213364 defendant Slyck William   592455 592455 Slyck, William, of Norton, Derbs 0
4660981 2249259 2249259 defendant Croxhale John husbandman 592455 592455 Croxhale, John, of Norton, Derbs, husbandman 1
4698799 2265104 2265104 defendant Robert John smith 592455 592455 Robert, John, of Norton, Derbs, smith 3
4734159 2275864 2275864 defendant Mowelyn Wiiliam collier 592455 592455 Mowelyn, Wiiliam, of Norton, Derbs, collier 2
4869485 2317424 2317424 defendant Bullok William gent 592455 592455 Bullok, William, of Norton, Derbs, gent 0
4869489 2317425 2317425 defendant Bullok William gent 592455 592455 Bullok, William, of Norton, Derbs, gent 0
5001729 2357400 2357400 defendant Selyok Richard gent 592455 592455 Selyok, Richard, of Norton, Derbs, gent 0
5183853 2411016 2411016 defendant Bullok William yeoman 592455 592455 Bullok, William, of Norton, Derbs, yeoman, son & heir of John Bullock, of Norton, Derbs, yeoman 0
5183855 2411017 2411017 defendant Bullok William yeoman 592455 592455 Bullok, William, of Norton, Derbs, yeoman, son & heir of John Bullock, of Norton, Derbs, yeoman 0
5183857 2411018 2411018 defendant Bullok William yeoman 592455 592455 Bullok, William, of Norton, Derbs, yeoman, son & heir of John Bullock, of Norton, Derbs, yeoman 0
5184073 2411077 2411077 defendant Bullok John yeoman 592455 592455 Bullok, John, of Norton, Derbs, yeoman 0
5184076 2411078 2411078 defendant Bullok John yeoman 592455 592455 Bullok, John, of Norton, Derbs, yeoman 0
5184079 2411079 2411079 defendant Bullok William yeoman 592455 592455 Bullok, William, of Norton, Derbs, yeoman 0
5228809 2424034 2424034 defendant Bullok Thomas   592455 592455 Bullok, Thomas, of Norton, Derbs, scythe smith 1
5458483 2492428 2492428 defendant Parker John yeoman 592455 592455 Parker, John, of Norton, Derbs, yeoman 0
5470122 2495978 2495978 defendant Parker John yeoman 592455 592455 Parker, John, of Norton, Derbs, yeoman 0
5470124 2495979 2495979 defendant Parker John yeoman 592455 592455 Parker, John, of Norton, Derbs, yeoman 0
5481561 2499412 2499412 defendant Parker John yeoman 592455 592455 Parker, John, of Norton, Derbs, yeoman 0
5481563 2499413 2499413 defendant Parker John yeoman 592455 592455 Parker, John, of Norton, Derbs, yeoman 0
5576453 2527690 2527690 defendant Blande Richard yeoman 592455 592455 Blande, Richard, of Norton, Derbs, yeoman 4
5576459 2527691 2527691 defendant Blande Richard yeoman 592455 592455 Blande, Richard, of Norton, Derbs, yeoman 4

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