names

19 rows where place_id = 598003

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3630714 1904432 1904432 defendant Howles Robert tanner 598003 598003 Howles, Robert, of Brerdyng, Isle of Wight, tanner 0
3749075 1941641 1941641 defendant Howles William, senior yeoman 598003 598003 Howles, William, senior, of Brerdyng, Isle of Wight, yeoman 0
3749473 1941746 1941746 plaintiff Howles Robert   598003 598003 Howles, Robert, of Brerdyng, Isle of Wight 0
3749474 1941746 1941746 defendant Howles William yeoman 598003 598003 Howles, William, of Brerdyng, Isle of Wight, yeoman 0
3895731 1988780 1988780 defendant Tanner alias Marchall Thomas husbandman 598003 598003 Tanner alias Marchall, Thomas, of Brerdyng, Isle of Wight, husbandman 0
3909989 1993648 1993648 defendant Tanner alias Marshall Thomas husbandman 598003 598003 Tanner alias Marshall, Thomas, of Brerdyng, Isle of Wight, husbandman 0
4665887 2250806 2250806 defendant Newe John weaver 598003 598003 Newe, John, of Brerdyng, Isle of Wight, weaver 0
4856512 2313418 2313418 defendant Repe John tailor 598003 598003 Repe, John, of Brerdyng, Isle of Wight, tailor 0
4889617 2323552 2323552 defendant Oglonder Alice   598003 598003 Oglonder, Alice, of Brerdyng, Isle of Wight, widow of Oglonder, Reginald 0
5094236 2384720 2384720 defendant Haket John gent 598003 598003 Haket, John, of Brerdyng, Isle of Wight, gent 0
5326519 2453016 2453016 defendant Champeneys William miller 598003 598003 Champeneys, William, of Brerdyng, Isle of Wight, miller 0
5506710 2507017 2507017 defendant Heweles William yeoman 598003 598003 Heweles, William, of Brerdyng, Isle of Wight, yeoman 0
5506712 2507018 2507018 defendant Howeles William yeoman 598003 598003 Howeles, William, of Brerdyng, Isle of Wight, yeoman 0
5551432 2520456 2520456 defendant Holes William yeoman 598003 598003 Holes, William, of Brerdyng, Isle of Wight, yeoman 0
5552784 2520862 2520862 defendant Squyer William mercer 598003 598003 Squyer, William, of Brerdyng, Isle of Wight, mercer 0
5583143 2529801 2529801 defendant Howles Robert tanner 598003 598003 Howles, Robert, of Brerdyng, Isle of Wight, tanner 0
5585257 2530454 2530454 defendant Flemyng John mercer 598003 598003 Flemyng, John, of Brerdyng, Isle of Wight, mercer 0
5585259 2530455 2530455 defendant Sqwyer William, senior husbandman 598003 598003 Sqwyer, William, senior, of Brerdyng, Isle of Wight, husbandman 0
5627644 2552618 2552618 defendant Howeles John   598003 598003 Howeles, John, of Brerdyng, Isle of Wight, millward 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);