names

17 rows where place_id = 691722

✎ 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
4091311 2057183 2057183 defendant Ettee Jane widow 691722 691722 Ettee, Jane, of Foul Sutton, widow 0
4091312 2057183 2057183 defendant Ettee Patrick yeoman 691722 691722 Ettee, Patrick, of Foul Sutton, yeoman 1
4413516 2169114 2169114 defendant Daveryne John   691722 691722 Daveryne, John, of Foul Sutton 3
4552058 2216596 2216596 defendant Bustard Robert   691722 691722 Bustard, Robert, of Foul sutton 0
4582335 2225917 2225917 defendant Bustard Robert   691722 691722 Bustard, Robert, of Foul Sutton 1
4591286 2228632 2228632 plaintiff Middelton William de   691722 691722 Middelton, William de, of Foul Sutton 0
4591340 2228648 2228648 plaintiff Midelton William de   691722 691722 Midelton, William de, of Foul Sutton 0
4591341 2228648 2228648 defendant Bustard Robert   691722 691722 Bustard, Robert, of Foul Sutton 0
5121687 2392772 2392772 defendant Regnell John clerk 691722 691722 Regnell, John, of Foul Sutton, clerk 3
5130527 2395410 2395410 defendant Ragell Roger clerk 691722 691722 Ragell, Roger, of Foul Sutton, clerk 0
5149897 2401101 2401101 defendant Ragell Robert clerk 691722 691722 Ragell, Robert, of Foul Sutton, clerk 0
5149899 2401102 2401102 defendant Ragell Roger clerk 691722 691722 Ragell, Roger, of Foul Sutton, clerk 0
5168651 2406552 2406552 defendant Ragell Roger clerk 691722 691722 Ragell. Roger, of Foul Sutton, clerk 0
5366822 2465278 2465278 defendant Mason Robert husbandman 691722 691722 Mason, Robert, of Foul Sutton, husbandman 0
5366823 2465278 2465278 defendant Sutton John husbandman 691722 691722 Sutton, John, of Foul Sutton, husbandman 1
5366824 2465278 2465278 defendant Sutton Robert husbandman 691722 691722 Sutton, Robert, of Foul Sutton, husbandman 2
5621210 2550518 2550518 defendant Dautry Roger   691722 691722 Dautry, Roger, of Foul Sutton 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);