names

22 rows where place_id = 616059

✎ 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
3712309 1930167 1930167 defendant Turnour Robert yeoman 616059 616059 Turnour, Robert, of Hawsted, yeoman 0
3770759 1948542 1948542 plaintiff Sparke John smith 616059 616059 Sparke, John, of Hawsted, smith 0
3784243 1952861 1952861 defendant Goblyn John husbandman 616059 616059 Goblyn, John, of Hawsted, husbandman 3
3837880 1969760 1969760 defendant Woode William gent 616059 616059 Woode, William, of Hawsted, gent 0
3869297 1979972 1979972 defendant Pannell John husbandman 616059 616059 Pannell, John, of Hawsted, husbandman 1
3869301 1979973 1979973 defendant Pannell John husbandman 616059 616059 Pannell, John, of Hawsted, husbandman 1
3869305 1979974 1979974 defendant Pannell John husbandman 616059 616059 Pannell, John, of Hawsted, husbandman 1
3869309 1979975 1979975 defendant Pannell John husbandman 616059 616059 Pannell, John, of Hawsted, husbandman 1
3904023 1991587 1991587 plaintiff Halsted Roger yeoman 616059 616059 Halsted, Roger, of Hawsted, yeoman 0
3906070 1992321 1992321 plaintiff Lownde Richard (legal representative) 616059 616059 Lownde, Richard, of Hawsted, yeoman, executors of 0
3918656 1996566 1996566 defendant Fuller Anne widow 616059 616059 Fuller, Anne, of Hawsted, widow 0
3918658 1996567 1996567 defendant Fuller Anne widow 616059 616059 Fuller, Anne, of Hawsted, widow 0
4009626 2028211 2028211 defendant Drury Robert esq 616059 616059 Drury, Robert, of Hawsted, or of Rowgham, Suff, gent, kinsman of John Drury, of Rowgham, esq 0
4043391 2040099 2040099 defendant Polhyll Robert yeoman 616059 616059 Polhyll, Robert, of Hawsted, yeoman 0
4333712 2141555 2141555 defendant Smythe John schoolmaster 616059 616059 Smythe, John, of Hawsted, schoolmaster 2
4342417 2144621 2144621 defendant Savage John yeoman 616059 616059 Savage, John, of Hawsted, yeoman 0
4342418 2144621 2144621 defendant Savage Richard husbandman 616059 616059 Savage, Richard, of Hawsted, husbandman 1
4346781 2146125 2146125 defendant Clexbrey John gent 616059 616059 Clexbrey, John, of Hawsted, gent 2
4370623 2154545 2154545 defendant Cleybrey John gent 616059 616059 Cleybrey, John, of Hawsted, gent 2
4375807 2156406 2156406 defendant Smale William husbandman 616059 616059 Smale, William, of Hawsted, husbandman 1
5132186 2395906 2395906 defendant Fuller John husbandman 616059 616059 Fuller, John, of Hawsted, husbandman 0
5568687 2525392 2525392 plaintiff Fuller John   616059 616059 Fuller, John, of Hawsted 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);