names

22 rows where place_id = 604100

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3656847 1912398 1912398 defendant Ley William glover and sadler 604100 604100 Ley, William, of Colshyll, glover and sadler 0
3656850 1912399 1912399 defendant Ley William glover and sadler 604100 604100 Ley, William, of Colshyll, glover and sadler 0
3668505 1916105 1916105 defendant Champeneys Ambrose gent 604100 604100 Champeneys, Ambrose, of Colshyll, gent 0
3679940 1919792 1919792 defendant Bodeley John yeoman 604100 604100 Bodeley, John, of Colshyll, yeoman 0
3701660 1926760 1926760 defendant Boneham alias Skryvener William husbandman 604100 604100 Boneham alias Skryvener, William, of Colshyll, husbandman 0
3705168 1927905 1927905 defendant Ball Nicholas butcher 604100 604100 Ball, Nicholas, of Colshyll, butcher 0
3718814 1932164 1932164 defendant Grendon Hugh tailor 604100 604100 Grendon, Hugh, of Colshyll, tailor 2
3718815 1932164 1932164 defendant Scryvener John husbandman 604100 604100 Scryvener, John, of Colshyll, husbandman 3
3720057 1932548 1932548 defendant Mathewe Thomas clerk 604100 604100 Mathewe, Thomas, of Colshyll, clerk 0
3720058 1932548 1932548 defendant Baveley John yeoman 604100 604100 Baveley, John, of Colshyll, yeoman 1
3725096 1934136 1934136 defendant Lee William yeoman 604100 604100 Lee, William, of Colshyll, yeoman 1
3725097 1934136 1934136 defendant Gylbert William yeoman 604100 604100 Gylbert, William, of Colshyll, yeoman 2
3725098 1934136 1934136 defendant Humfrey Robert yeoman 604100 604100 Humfrey, Robert, of Colshyll, yeoman 3
3769699 1948179 1948179 defendant Gate Thomas husbandman 604100 604100 Gate, Thomas, of Colshyll, husbandman 0
3811422 1961468 1961468 defendant Mason Thomas butcher 604100 604100 Mason, Thomas, of Colshyll, butcher 1
3916843 1995999 1995999 defendant Butler Robert yeoman 604100 604100 Butler, Robert, of Colshyll, yeoman 2
3949275 2006816 2006816 plaintiff Dygbye John (legal representative) 604100 604100 Dygbye, John, of Colshyll, esq, executors of 0
5228467 2423931 2423931 defendant Bater Richard husbandman 604100 604100 Bater, Richard, of Colshyll, husbandman 1
5314414 2449337 2449337 defendant Dey Joan widow 604100 604100 Dey, Joan, of Colshyll, widow 3
5570493 2525942 2525942 defendant Husse William gent 604100 604100 Husse, William, of Colshyll, gent 0
5583581 2529940 2529940 defendant Grene alias Colle Thomas shoemaker 604100 604100 Grene alias Colle, Thomas, of Colshyll, shoemaker 0
5583582 2529940 2529940 defendant Shyngleton James shoemaker 604100 604100 Shyngleton, James, of Colshyll, shoemaker 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);