names

28 rows where place_id = 606859

✎ 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
3621895 1874392 1874392 plaintiff Parson John (legal representative) 606859 606859 Parson, John, of Podyng Norton, executors of 0
3666775 1915552 1915552 defendant Shaa William yeoman 606859 606859 Shaa, William, of Podyng Norton, yeoman 1
3696540 1925147 1925147 plaintiff Shaa William   606859 606859 Shaa, William, of Podyng Norton, 0
3710351 1929556 1929556 plaintiff Shaa William   606859 606859 Shaa, William, of Podyng Norton 0
3747196 1941041 1941041 defendant Roges John chaplain 606859 606859 Roges, John, of Podyng Norton, chaplain 2
3761032 1945453 1945453 defendant Rodes John chaplain 606859 606859 Rodes, John, of Podyng Norton, chaplain 2
3837170 1969527 1969527 plaintiff Sheltram Henry (legal representative) 606859 606859 Sheltram, Henry, of Podyng Norton, executors of 0
3837173 1969527 1969527 defendant Ingeldewe William husbandman 606859 606859 Ingeldewe, William, of Podyng Norton, husbandman 0
3848037 1972959 1972959 defendant Shaa William yeoman 606859 606859 Shaa, William, of Podyng Norton, yeoman 1
3848038 1972959 1972959 defendant Peern John yeoman 606859 606859 Peern, John, of Podyng Norton, yeoman 2
3853135 1974602 1974602 plaintiff Shawe William   606859 606859 Shawe, William, of Podyng Norton 0
3863273 1977913 1977913 defendant Peern John yeoman 606859 606859 Peern, John, of Podyng Norton, yeoman 1
3863275 1977914 1977914 defendant Shaa William yeoman 606859 606859 Shaa, William, of Podyng Norton, yeoman 0
3867623 1979407 1979407 plaintiff Shawe alias Shaa William   606859 606859 Shawe alias Shaa, William, of Podyng Norton 0
3867636 1979412 1979412 plaintiff Shawe William   606859 606859 Shawe, William, of Podyng Norton 0
4638481 2242796 2242796 plaintiff Carman John   606859 606859 Carman, John, of Podyng Norton 0
4722673 2272407 2272407 defendant Lexham Thomas yeoman 606859 606859 Lexham, Thomas, of Podyng Norton, yeoman 0
4795117 2294619 2294619 defendant Lexham Thomas husbandman 606859 606859 Lexham, Thomas, of Podyng Norton, husbandman 0
5482895 2499826 2499826 defendant Beigham John husbandman 606859 606859 Beigham, John, of Podyng Norton, husbandman 9
5535397 2515597 2515597 defendant Perne Thomas (legal representative) 606859 606859 Perne, Thomas, of Podyng Norton, yeoman, executors of 0
5535398 2515597 2515597 defendant Perne Agnes widow 606859 606859 (Perne, Agnes, of Podyng Norton, widow 1
5543604 2518105 2518105 defendant Bonham Thomas husbandman 606859 606859 Bonham, Thomas, of Podyng Norton, husbandman 0
5558461 2522421 2522421 plaintiff Perne Thomas (legal representative) 606859 606859 Perne, Thomas, of Podyng Norton, yeoman, executors of 0
5558468 2522422 2522422 plaintiff Perne Thomas (legal representative) 606859 606859 Perne, Thomas, of Podyng Norton, yeoman, executors of 0
5558472 2522423 2522423 plaintiff Perne Thomas   606859 606859 Perne, Thomas, of Podyng Norton, yeoman, execuutors of 0
5603714 2536029 2536029 defendant Parson John (legal representative) 606859 606859 Parson, John, of Podyng Norton, executor of 0
5603716 2536030 2536030 plaintiff Perne Thomas (legal representative) 606859 606859 Perne, Thomas, of Podyng Norton, executors of 0
5606212 2536836 2536836 defendant Dekon Lawrence husbandman 606859 606859 Dekon, Lawrence, of Podyng Norton, husbandman 2

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