names

40 rows where place_id = 599361

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3636457 1906194 1906194 defendant Word John husbandman 599361 599361 Word, John, of Jevyngton, husbandman 0
3636459 1906194 1906194 defendant Rycheman Richard laborer 599361 599361 Rycheman, Richard, of Jevyngton, laborer 2
3662042 1914063 1914063 defendant Wodwolle John yeoman 599361 599361 Wodwolle, John, of Jevyngton, yeoman 0
3689113 1922757 1922757 defendant Osborn Thomas husbandman 599361 599361 Osborn, Thomas, of Jevyngton, husbandman 0
3775154 1949962 1949962 defendant Wynam Robert tailor 599361 599361 Wynam, Robert, of Jevyngton, tailor 0
3791148 1955063 1955063 defendant Portyngton Anne widow 599361 599361 Portyngton, Anne, of Jevyngton, widow 0
3791315 1955118 1955118 defendant Portyngton Anne widow 599361 599361 Portyngton, Anne, of Jevyngton, widow 0
3878000 1982886 1982886 defendant Renne Richard husbandman 599361 599361 Renne, Richard, of Jevyngton, husbandman 0
4013755 2029651 2029651 defendant Tyseherst John husbandman 599361 599361 Tyseherst, John, of Jevyngton, husbandman 0
4072749 2050554 2050554 defendant Wheler Robert clerk 599361 599361 Wheler, Robert, of Jevyngton, clerk 0
4073649 2050867 2050867 defendant Broke Thomas clerk 599361 599361 Broke, Thomas, of Jevyngton, clerk 0
4077929 2052409 2052409 defendant Hastyng Richard yeoman 599361 599361 Hastyng, Richard, of Jevyngton, yeoman 2
4082200 2053945 2053945 defendant Tyseherst John yeoman 599361 599361 Tyseherst, John, of Jevyngton, yeoman 0
4082202 2053946 2053946 defendant Tyseherst John yeoman 599361 599361 Tyseherst, John, of Jevyngton, yeoman 0
4101075 2060698 2060698 defendant Wheler Robert clerk 599361 599361 Wheler, Robert, of Jevyngton, clerk 1
4108384 2063254 2063254 defendant Tyceherst John husbandman 599361 599361 Tyceherst, John, of Jevyngton, husbandman 0
4108386 2063255 2063255 defendant Tyseherst John yeoman 599361 599361 Tyseherst, John, of Jevyngton, yeoman 0
4133420 2072279 2072279 defendant Renn or Renner Thomas   599361 599361 Renn or Renner, Thomas, of Jevyngton, yeoman, administrators of 0
4133421 2072279 2072279 defendant Tomsett Richard yeoman 599361 599361 (Tomsett, Richard, of Jevyngton, yeoman 1
4134375 2072624 2072624 defendant Wheler Robert clerk 599361 599361 Wheler, Robert, of Jevyngton, clerk 1
4139609 2074528 2074528 defendant Brooke Thomas clerk 599361 599361 Brooke, Thomas, of Jevyngton, clerk 0
4171930 2085644 2085644 defendant Wheler Robert clerk 599361 599361 Wheler, Robert, of Jevyngton, clerk 0
4174007 2086362 2086362 defendant Jenner John singleman 599361 599361 Jenner, John, of Jevyngton, yeoman, singleman 0
4176588 2087288 2087288 defendant Wheler Richard clerk 599361 599361 Wheler, Richard, of Jevyngton, clerk 2
4183436 2089686 2089686 defendant Wheler Robert clerk 599361 599361 Wheler, Robert, of Jevyngton, clerk 1
4183437 2089686 2089686 defendant Wheler John yeoman 599361 599361 Wheler, John, of Jevyngton, yeoman 2
4183438 2089686 2089686 defendant Fynnell John yeoman 599361 599361 Fynnell, John, of Jevyngton, yeoman 3
4188081 2091334 2091334 defendant Sherwyn John tailor 599361 599361 Sherwyn, John, of Jevyngton, tailor 0
4189008 2091640 2091640 defendant Topsett Richard husbandman 599361 599361 Topsett, Richard, of Jevyngton, husbandman 1
4311525 2134172 2134172 defendant Wheeler Robert clerk 599361 599361 Wheeler, Robert, of Jevyngton, or of Chichester, clerk 1
4321432 2137588 2137588 defendant Hemsley James tanner 599361 599361 Hemsley, James, of Jevyngton, tanner 1
4367326 2153369 2153369 defendant Suran Edward husbandman 599361 599361 Suran, Edward, of Jevyngton, husbandman 3
4380673 2158196 2158196 defendant Bredon John husbandman 599361 599361 Bredon, John, of Jevyngton, husbandman 0
4826092 2304192 2304192 defendant atte Dene John weaver 599361 599361 atte Dene, John, of Jevyngton, weaver 0
5038432 2368130 2368130 defendant Hyrry John clerk & parson 599361 599361 Hyrry, John, of Jevyngton, clerk & parson 0
5040779 2368858 2368858 defendant Martyn Thomas shoemaker 599361 599361 Martyn, Thomas, of Jevyngton, shoemaker 1
5173852 2408050 2408050 defendant Comber Simon husbandman 599361 599361 Comber, Simon, of Jevyngton, husbandman 0
5182231 2410555 2410555 defendant Hyrry John   599361 599361 Hyrry, John, of Jevyngton, parson 1
5454406 2491226 2491226 defendant Lee Henry yeoman 599361 599361 Lee, Henry, of Jevyngton, yeoman 0
5477605 2498319 2498319 defendant Lee Henry yeoman 599361 599361 Lee, Henry, of Jevyngton, 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);