names

31 rows where place_id = 588861

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595818 1866328 1866328 defendant Baldwyn William yeoman 588861 588861 Baldwyn, William, of Westham, Essex, yeoman 0
3633409 1905262 1905262 defendant Swyft Thomas yeoman 588861 588861 Swyft, Thomas, of Westham, Essex, yeoman 2
3642178 1908003 1908003 defendant Alen William grasier 588861 588861 Alen, William, of Westham, Essex, grasier 0
3642183 1908004 1908004 defendant Alen William grasier 588861 588861 Alen, William, of Westham, Essex, grasier 0
3651713 1910892 1910892 defendant Marshall William yeoman 588861 588861 Marshall, William, of Westham, Essex, yeoman 0
3651718 1910893 1910893 defendant Marshall William yeoman 588861 588861 Marshall, William, of Westham, Essex, yeoman 1
3651801 1910922 1910922 defendant Senns Anthony laborer 588861 588861 Senns, Anthony, of Westham, Essex, laborer 2
3684560 1921304 1921304 defendant Doon Griffin or Geoffrey   588861 588861 Doon, Griffin or Geoffrey, of Westham, Essex, knight 0
3762158 1945808 1945808 defendant Byggons Lionel husbandman 588861 588861 (Byggons, Lionel, of Westham, Essex, husbandman 2
3762163 1945809 1945809 defendant Byggons Lionel gent 588861 588861 (Byggons, Lionel, of Westham, Essex, gent 2
3822065 1964794 1964794 defendant Clay Richard husbandman 588861 588861 Clay, Richard, of Westham, Essex, husbandman 4
3828607 1966825 1966825 defendant Drynge Thomas yeoman 588861 588861 Drynge, Thomas, of Westham, Essex, yeoman 0
3830502 1967419 1967419 defendant Stanton Richard gent 588861 588861 Stanton, Richard, of Westham, Essex, gent 0
3861761 1977399 1977399 defendant Shawe Hamlet gent 588861 588861 Shawe, Hamlet, of Westham, Essex, gent 0
3891223 1987328 1987328 defendant Collyns John butcher 588861 588861 Collyns, John, of Westham, Essex, butcher 0
3915285 1995478 1995478 defendant Marche John gent 588861 588861 Marche, John, of Westham, Essex, gent 2
5239322 2427088 2427088 defendant Baron Roger husbandman 588861 588861 Baron, Roger, of Westham, Essex, husbandman 1
5239326 2427089 2427089 defendant Baron Roger husbandman 588861 588861 Baron, Roger, of Westham, Essex, husbandman 1
5239331 2427090 2427090 defendant Baron Roger husbandman 588861 588861 Baron, Roger, of Westham, Essex, husbandman 2
5399066 2474805 2474805 defendant Marchall Humphrey carpenter 588861 588861 Marchall, Humphrey, of Westham, Essex, carpenter 0
5518532 2510626 2510626 defendant Baldewyn William husbandman 588861 588861 Baldewyn, William, of Westham, Essex, husbandman 1
5541443 2517436 2517436 defendant Hatton Richard husbandman 588861 588861 Hatton, Richard, of Westham, Essex, husbandman 0
5547502 2519288 2519288 defendant Lenet or Levet Robert, senior tanner 588861 588861 Lenet or Levet, Robert, senior, of Westham, Essex, tanner 0
5587256 2531041 2531041 defendant Alysaundre William yeoman 588861 588861 Alysaundre, William, of Westham, Essex, yeoman 0
5587264 2531044 2531044 defendant Danyell John yeoman 588861 588861 Danyell, John, of Westham, Essex, yeoman 0
5587269 2531045 2531045 defendant Danyell John yeoman 588861 588861 Danyell, John, of Westham, Essex, yeoman 3
5587274 2531046 2531046 defendant Danyell William yeoman 588861 588861 Danyell, William, of Westham, Essex, yeoman 2
5587279 2531048 2531048 defendant Shipman John yeoman 588861 588861 Shipman, John, of Westham, Essex, yeoman 0
5587281 2531049 2531049 defendant Shipman John yeoman 588861 588861 Shipman, John, of Westham, Essex, yeoman 0
5587287 2531050 2531050 defendant Shipman Thomas yeoman 588861 588861 Shipman, Thomas, of Westham, Essex, yeoman 0
5587585 2531133 2531133 defendant Alysaundre William yeoman 588861 588861 Alysaundre, William, of Westham, Essex, yeoman 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);