names

22 rows where place_id = 831274

✎ 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
4988898 2353630 2353630 defendant Robbys Henry sawer 831274 831274 Robbys, Henry, of Hakford by Hengham, sawer 7
4988899 2353630 2353630 defendant Gylys William   831274 831274 Gylys, William, of Hakford by Hengham, mason 8
5008122 2359260 2359260 defendant Roslyn Roger laborer 831274 831274 Roslyn, Roger, of Hakford by Hengham, laborer 2
5008127 2359262 2359262 defendant Roslyn Roger laborer 831274 831274 Roslyn, Roger, of Hakford by Hengham, laborer 0
5152591 2401898 2401898 defendant Robbes Henry husbandman & sawyer 831274 831274 Robbes, Henry, of Hakford by Hengham, husbandman & sawyer 0
5203733 2416841 2416841 defendant Giles William yeoman 831274 831274 Giles, William, of Hakford by Hengham, yeoman 0
5274581 2437647 2437647 defendant Blaxhal Robert husbandman 831274 831274 Blaxhal, Robert, of Hakford by Hengham, husbandman 3
5301145 2445299 2445299 defendant Westgate Andrew husbandman 831274 831274 Westgate, Andrew, of Hakford by Hengham, husbandman 0
5310348 2448126 2448126 defendant Wethyr Thomas husbandman 831274 831274 Wethyr, Thomas, of Hakford by Hengham, husbandman 2
5365578 2464906 2464906 defendant Dodde Robert husbandman 831274 831274 Dodde, Robert, of Hakford by Hengham, husbandman 1
5386650 2471245 2471245 defendant Blaksale Robert yeoman 831274 831274 Blaksale, Robert, of Hakford by Hengham, yeoman 3
5386752 2471277 2471277 defendant Blaksale Robert yeoman 831274 831274 Blaksale, Robert, of Hakford by Hengham, yeoman 0
5399061 2474803 2474803 defendant Barksale Robert yeoman 831274 831274 Barksale, Robert, of Hakford by Hengham, yeoman 0
5399064 2474804 2474804 defendant Blaksale Robert yeoman 831274 831274 Blaksale, Robert, of Hakford by Hengham, yeoman 0
5412157 2478591 2478591 defendant Blaksale Robert yeoman 831274 831274 Blaksale, Robert, of Hakford by Hengham, yeoman 0
5426941 2483002 2483002 defendant Blaksale Robert husbandman 831274 831274 Blaksale, Robert, of Hakford by Hengham, husbandman 8
5442497 2487668 2487668 defendant Blaxhale Robert husbandman 831274 831274 Blaxhale, Robert, of Hakford by Hengham, husbandman 3
5444886 2488357 2488357 defendant Blaksale Robert husbandman 831274 831274 Blaksale, Robert, of Hakford by Hengham, husbandman 8
5444897 2488358 2488358 defendant Blaksale Robert husbandman 831274 831274 Blaksale, Robert, of Hakford by Hengham, husbandman 7
5455205 2491477 2491477 defendant Blaxhale Robert husbandman 831274 831274 Blaxhale, Robert, of Hakford by Hengham, husbandman 3
5455212 2491478 2491478 defendant Blaxhale Robert husbandman 831274 831274 Blaxhale, Robert, of Hakford by Hengham, husbandman 3
5467034 2495088 2495088 defendant Blaxhale Robert husbandman 831274 831274 Blaxhale, Robert, of Hakford by Hengham, husbandman 3

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