names

29 rows where place_id = 608249

✎ 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
3672839 1917517 1917517 plaintiff Doket Thomas   608249 608249 Doket, Thomas, of Allyngton 0
3788217 1954113 1954113 defendant Sanborowe John husbandman 608249 608249 Sanborowe, John, of Allyngton, husbandman 2
3846822 1972557 1972557 defendant Fallebys Margaret widow 608249 608249 Fallebys, Margaret, of Allyngton, widow 0
3957784 2009781 2009781 plaintiff Punyett John yeoman 608249 608249 Punyett, John, of Allyngton, yeoman 0
3962444 2011454 2011454 defendant Vyney John husbandman 608249 608249 Vyney, John, of Allyngton, husbandman 0
3975471 2015987 2015987 defendant Synett or Syvett John husbandman 608249 608249 Synett or Syvett, John, of Allyngton, husbandman 0
4074515 2051188 2051188 defendant Gale William yeoman 608249 608249 Gale, William, of Allyngton, yeoman 0
4092239 2057525 2057525 defendant Coker Thomas butcher 608249 608249 Coker, Thomas, of Allyngton, butcher 2
4106341 2062558 2062558 defendant Goodwyn William (legal representative) 608249 608249 Goodwyn, William, of Allyngton, yeoman, executor of 0
4127116 2069985 2069985 defendant Franckelyn Robert gent 608249 608249 Franckelyn, Robert, of Allyngton, gent 0
4189771 2091918 2091918 defendant Gombledon William gent 608249 608249 Gombledon, William, of Allyngton, gent 0
4213621 2100285 2100285 defendant Rogers Robert miller 608249 608249 Rogers, Robert, of Allyngton, miller 2
4216761 2101357 2101357 defendant Pirryn alias Perrell Richard husbandman 608249 608249 Pirryn alias Perrell, Richard, of Allyngton, husbandman 0
4236852 2108468 2108468 defendant Wimbleton John widow 608249 608249 Wimbleton, John, of Allyngton, widow 1
4239936 2109604 2109604 defendant Perryn Richard yeoman 608249 608249 Perryn, Richard, of Allyngton, yeoman 0
4283570 2124162 2124162 defendant Edmond John husbandman 608249 608249 Edmond, John, of Allyngton, husbandman 0
4289100 2126158 2126158 defendant Peartree John yeoman 608249 608249 Peartree, John, of Allyngton, yeoman 0
4294412 2128084 2128084 defendant Ackley Richard husbandman 608249 608249 Ackley, Richard, of Allyngton, husbandman 0
4299026 2129747 2129747 defendant Durham John yeoman 608249 608249 Durham, John, of Allyngton, yeoman 0
4402461 2165409 2165409 defendant Hartrapp Richard yeoman 608249 608249 Hartrapp, Richard, of Allyngton, yeoman 2
4412246 2168686 2168686 defendant Hartruppe Richard yeoman 608249 608249 Hartruppe, Richard, of Allyngton, yeoman 1
4607355 2233408 2233408 defendant Boteler Robert   608249 608249 Boteler, Robert, of Allyngton 0
4608085 2233643 2233643 defendant Boteler Robert   608249 608249 Boteler, Robert, of Allyngton 0
5074362 2378831 2378831 defendant Soppe Richard husbandman 608249 608249 Soppe, Richard, of Allyngton, husbandman 0
5080117 2380540 2380540 defendant Couper Nicholas husbandman 608249 608249 Couper, Nicholas, of Allyngton, husbandman 1
5310440 2448158 2448158 defendant Wandeham Robert husbandman 608249 608249 Wandeham, Robert, of Allyngton, husbandman 4
5500141 2504995 2504995 defendant Brekhelle William gent 608249 608249 Brekhelle, William, of Allyngton Gower, gent 0
5580816 2529079 2529079 defendant Broun John, senior yeoman 608249 608249 Broun, John, senior, of Allyngton, yeoman 0
5580817 2529079 2529079 defendant Broun John, junior yeoman 608249 608249 Broun, John, junior, of Allyngton, yeoman 1

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