names

23 rows where place_id = 710426

✎ 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
4183447 2089689 2089689 defendant Borrett Henry yeoman 710426 710426 Borrett, Henry, of Stradbrooke, yeoman 2
4192744 2093022 2093022 defendant Aldous or Aldons John yeoman 710426 710426 Aldous or Aldons, John, of Stradbrooke, yeoman 0
4225641 2104433 2104433 defendant Flatman John yeoman 710426 710426 Flatman, John, of Stradbrooke, yeoman 0
4225642 2104433 2104433 defendant Spere Richard yeoman 710426 710426 Spere, Richard, of Stradbrooke, yeoman 1
4281383 2123394 2123394 defendant Foster Thomas husbandman 710426 710426 Foster, Thomas, of Stradbrooke, husbandman 2
4306269 2132331 2132331 defendant Beamishe John yeoman 710426 710426 Beamishe, John, of Stradbrooke, yeoman 2
4320074 2137129 2137129 defendant Beamyshe John yeoman 710426 710426 Beamyshe, John, of Stradbrooke, yeoman 0
4332298 2141094 2141094 defendant Dey Robert butcher 710426 710426 Dey, Robert, of Stradbrooke, butcher 2
4336555 2142518 2142518 defendant Foster Thomas laborer 710426 710426 Foster, Thomas, of Stradbrooke, laborer 13
4344490 2145352 2145352 defendant Sandcrafte Thomas draper 710426 710426 Sandcrafte, Thomas, of Stradbrooke, draper 2
4344491 2145352 2145352 defendant Gurlinge Esdreas cooper 710426 710426 Gurlinge, Esdreas, of Stradbrooke, cooper 3
4352447 2148095 2148095 defendant Wickham Thomas husbandman 710426 710426 Wickham, Thomas, of Stradbrooke, husbandman 1
4352449 2148095 2148095 defendant Brooke John husbandman 710426 710426 Brooke, John, of Stradbrooke, husbandman 3
4354243 2148715 2148715 defendant Pulham Thomas yeoman 710426 710426 Pulham, Thomas, of Stradbrooke, yeoman 0
4354244 2148715 2148715 defendant Pulham John yeoman 710426 710426 Pulham, John, of Stradbrooke, yeoman 1
4356440 2149481 2149481 defendant Morrys Thomas yeoman 710426 710426 Morrys, Thomas, of Stradbrooke, yeoman 2
4393191 2162330 2162330 defendant Brooke John husbandman 710426 710426 Brooke, John, of Stradbrooke, husbandman 1
4396699 2163461 2163461 defendant Pulham Thomas yeoman 710426 710426 Pulham, Thomas, of Stradbrooke, yeoman 0
4403178 2165634 2165634 defendant Aldous Robert yeoman 710426 710426 Aldous, Robert, of Stradbrooke, yeoman 0
4405620 2166450 2166450 defendant Bert William husbandman 710426 710426 Bert, William, of Stradbrooke, husbandman 2
4408250 2167328 2167328 defendant Handlye William yeoman 710426 710426 Handlye, William, of Stradbrooke, yeoman 1
4411885 2168568 2168568 defendant Wytham Stephen tailor 710426 710426 Wytham, Stephen, of Stradbrooke, tailor 2
4411893 2168570 2168570 defendant Wytham Stephen tailor 710426 710426 Wytham, Stephen, of Stradbrooke, tailor 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);