names

22 rows where place_id = 714210

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4202878 2096551 2096551 defendant Rathebond Richard yeoman 714210 714210 Rathebond, Richard, of Chesterfeild, yeoman 1
4203456 2096762 2096762 defendant Heathcott Ralph yeoman 714210 714210 Heathcott, Ralph, of Chesterfeild, yeoman 1
4369969 2154315 2154315 defendant Froggott William husbandman 714210 714210 Froggott, William, of Chesterfeild, husbandman 0
4375735 2156382 2156382 defendant Sclater Edmund gent 714210 714210 Sclater, Edmund, of Chesterfeild, gent 0
4391144 2161657 2161657 defendant Alsopp Lawrence yeoman 714210 714210 Alsopp, Lawrence, of Chesterfeild, yeoman 0
4391145 2161657 2161657 defendant Holland Robert laborer 714210 714210 Holland, Robert, of Chesterfeild, laborer 1
4391146 2161657 2161657 defendant Brigg Edward laborer 714210 714210 Brigg, Edward, of Chesterfeild, laborer 2
4391147 2161657 2161657 defendant Kunton or Knuton William laborer 714210 714210 Kunton or Knuton, William, of Chesterfeild, laborer 3
4391151 2161659 2161659 defendant Holland Robert yeoman 714210 714210 Holland, Robert, of Chesterfeild, yeoman 0
4391152 2161659 2161659 defendant Alsopp William yeoman 714210 714210 Alsopp, William, of Chesterfeild, yeoman 1
4391156 2161660 2161660 defendant Holland Robert yeoman 714210 714210 Holland, Robert, of Chesterfeild, yeoman 1
4391157 2161660 2161660 defendant Alsopp William yeoman 714210 714210 Alsopp, William, of Chesterfeild, yeoman 2
4394794 2162846 2162846 defendant Croft Robert or of Whittington, clerk 714210 714210 Croft Robert, of Chesterfeild, or of Whittington, clerk 0
4407009 2166902 2166902 defendant Leeke Alban gent 714210 714210 Leeke, Alban, of Chesterfeild, gent 0
4407010 2166902 2166902 defendant Clerke Godfrey shoemaker 714210 714210 Clerke, Godfrey, of Chesterfeild, shoemaker 1
4407011 2166902 2166902 defendant Greves Richard yeoman 714210 714210 Greves, Richard, of Chesterfeild, yeoman 2
4407012 2166902 2166902 defendant Barker Edward yeoman 714210 714210 Barker, Edward, of Chesterfeild, yeoman 3
4409683 2167838 2167838 defendant Cowhop Richard husbandman 714210 714210 Cowhop, Richard, of Chesterfeild, husbandman 1
4411231 2168343 2168343 defendant Garde John yeoman 714210 714210 Garde, John, of Chesterfeild, yeoman 0
4597408 2230433 2230433 defendant Broun William   714210 714210 Broun, William, of Chesterfeild 1
4725007 2273115 2273115 defendant Bailly Hugh yeoman 714210 714210 Bailly, Hugh, of Chesterfeild, yeoman 3
5410897 2478211 2478211 defendant Selyok Alice widow 714210 714210 (Selyok, Alice, of Chesterfeild, widow 1

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