names

23 rows where place_id = 649939

✎ 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
3665380 1915126 1915126 defendant Russell Andrewr (legal representative) 649939 649939 Russell, Andrewr, of Heydon, Norf, husbandman, executrix of 1
3665381 1915126 1915126 defendant Gybson Agnes   649939 649939 Gybson, Agnes, of Heydon, Norf, widow, formerly wife of Andrew 2
3909336 1993418 1993418 defendant Heydon Leonard clerk 649939 649939 Heydon, Leonard, of Heydon, Norf, clerk 2
4742036 2278168 2278168 defendant Reder John   649939 649939 Reder, John, of Heydon, Norf, slay maker 0
4816362 2301206 2301206 defendant Reder John sleymaker or maker of instruments to beat up the weft in weaving 649939 649939 Reder, John, of Heydon, Norf, sleymaker or maker of instruments to beat up the weft in weaving 2
4862992 2315403 2315403 defendant Dynne Martin husbandman 649939 649939 Dynne, Martin, of Heydon, Norf, husbandman 3
4997325 2356050 2356050 defendant Reder John yeoman 649939 649939 Reder, John, of Heydon, Norf, yeoman 4
5181002 2410181 2410181 defendant Baron Robert husbandman 649939 649939 Baron, Robert, of Heydon, Norf, husbandman 3
5202436 2416476 2416476 defendant Baron Robert husbandman 649939 649939 Baron, Robert, of Heydon, Norf, husbandman 3
5240174 2427329 2427329 defendant Sevyar Robert chapman 649939 649939 Sevyar, Robert, of Heydon, Norf, chapman 1
5240998 2427570 2427570 defendant Ayleward Thomas yeoman 649939 649939 Ayleward, Thomas, of Heydon, Norf, yeoman 0
5268359 2435871 2435871 defendant Sevyer John husbandman 649939 649939 Sevyer, John, of Heydon, Norf, husbandman 0
5268361 2435872 2435872 defendant Sevyer John husbandman 649939 649939 Sevyer, John, of Heydon, Norf, husbandman 0
5318140 2450517 2450517 defendant Thayleward Thomas yeoman 649939 649939 Thayleward, Thomas, of Heydon, Norf, yeoman 2
5319962 2451056 2451056 defendant Betty Edmund mercer 649939 649939 Betty, Edmund, of Heydon, Norf, mercer 0
5335186 2455589 2455589 defendant Bulwer Thomas butcher 649939 649939 Bulwer, Thomas, of Heydon, Norf, butcher 3
5422012 2481520 2481520 defendant Hagon John yeoman 649939 649939 Hagon, John, of Heydon, Norf, yeoman 0
5432035 2484550 2484550 defendant Crome Robert   649939 649939 Crome, Robert, of Heydon, Norf, pedlar, son of John Crome 0
5448252 2489369 2489369 defendant Crome Robert   649939 649939 Crome, Robert, of Heydon, Norf, pedlar, son of John 0
5466401 2494888 2494888 defendant Hagon John (legal representative) 649939 649939 Hagon, John, of Heydon, Norf, yeoman, administrator of 0
5466402 2494888 2494888 defendant Mason Robert husbandman 649939 649939 Mason, Robert, of Heydon, Norf, husbandman 1
5472203 2496652 2496652 defendant Crome Robert   649939 649939 Crome, Robert, of Heydon, Norf, pedlar, son of John 0
5627624 2552610 2552610 defendant Den Martin chapman 649939 649939 Den, Martin, of Heydon, Norf, chapman 0

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