names

42 rows where place_id = 595775

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621842 1874372 1874372 defendant Marketman Thomas husbandman 595775 595775 Marketman, Thomas, of Hedcron, husbandman 0
3632626 1905022 1905022 defendant Boureman Stephen husbandman 595775 595775 Boureman, Stephen, of Hedcron, husbandman 0
3648107 1909801 1909801 defendant Philpott Robert husbandman 595775 595775 Philpott, Robert, of Hedcron, husbandman 2
3651741 1910898 1910898 defendant Ongley William husbandman 595775 595775 Ongley, William, of Hedcron, husbandman 0
3671292 1916996 1916996 defendant Lytyll Roger tanner 595775 595775 Lytyll, Roger, of Hedcron, tanner 0
3697742 1925515 1925515 defendant Gibbon Bartholomew carpenter 595775 595775 Gibbon, Bartholomew, of Hedcron, carpenter 0
3700899 1926527 1926527 defendant (not given) Thomas vicar of Warden 595775 595775 Warden, Thomas, of Hedcron, yeoman, servant of Moren, William, vicar of Hedcron 0
3707338 1928585 1928585 defendant Croche Roger butcher 595775 595775 Croche, Roger, of Hedcron, butcher 0
3711515 1929911 1929911 defendant Gybbon Bartholomew carpenter 595775 595775 Gybbon, Bartholomew, of Hedcron, carpenter 0
3726411 1934527 1934527 defendant Gybbon Bartholomew carpenter 595775 595775 Gybbon, Bartholomew, of Hedcron, carpenter 0
3735948 1937481 1937481 defendant Ford Thomas husbandman 595775 595775 Ford, Thomas, of Hedcron, husbandman 0
3744431 1940160 1940160 defendant Bowers Richard tailor 595775 595775 Bowers, Richard, of Hedcron, tailor 0
3800057 1957944 1957944 defendant Sacre Thomasm yeoman 595775 595775 Sacre, Thomasm, of Hedcron, yeoman 1
3809827 1960961 1960961 defendant Warden Thomas husbandman 595775 595775 Warden, Thomas, of Hedcron, husbandman 0
3832681 1968147 1968147 defendant Bamforthe Thomas yeoman 595775 595775 Bamforthe, Thomas, of Hedcron, yeoman 0
3848376 1973069 1973069 defendant Bamforthe Thomas yeoman 595775 595775 Bamforthe, Thomas, of Hedcron, yeoman 0
3865142 1978544 1978544 defendant Rycards Thomas butcher 595775 595775 Rycards, Thomas, of Hedcron, butcher 0
3877757 1982799 1982799 defendant Bamforthe Thomas yeoman 595775 595775 Bamforthe, Thomas, of Hedcron, yeoman 0
3884378 1985043 1985043 defendant Ongley Thomas butcher 595775 595775 Ongley, Thomas, of Hedcron, butcher 1
3888996 1986561 1986561 defendant Ongley Thomas butcher 595775 595775 Ongley, Thomas, of Hedcron, butcher 0
3896152 1988917 1988917 defendant Fyncle Joan widow 595775 595775 Fyncle, Joan, of Hedcron, widow 0
3913659 1994909 1994909 defendant Borden Edward husbandman 595775 595775 Borden, Edward, of Hedcron, husbandman 0
3915277 1995475 1995475 defendant Dey Richard butcher 595775 595775 Dey, Richard, of Hedcron, butcher 0
3960667 2010831 2010831 defendant Jemmett Anthony yeoman 595775 595775 Jemmett, Anthony, of Hedcron, yeoman, yeoman 1
4008645 2027853 2027853 defendant Robynson Stephen yeoman 595775 595775 Robynson, Stephen, of Hedcron, yeoman 0
4052270 2043235 2043235 defendant Trowell Thomas laborer 595775 595775 Trowell, Thomas, of Hedcron, laborer 0
4052271 2043235 2043235 defendant Pylgryme Henry laborer 595775 595775 Pylgryme, Henry, of Hedcron, laborer 1
4372042 2155065 2155065 defendant Fullagard alias Domyne William yeoman 595775 595775 Fullagard alias Domyne, William, of Hedcron, yeoman 0
5083136 2381462 2381462 defendant Turnoure John weaver 595775 595775 Turnoure, John,of Hedcron, weaver 11
5083137 2381462 2381462 defendant Baille Thomas fletcher 595775 595775 Baille, Thomas, of Hedcron, fletcher 12
5347696 2459432 2459432 defendant Southland John, senior husbandman 595775 595775 Southland, John, senior, of Hedcron, husbandman 0
5354788 2461575 2461575 defendant Borden Robert yeoman 595775 595775 Borden, Robert, of Hedcron, yeoman 0
5489910 2501869 2501869 defendant Borden Robert yeoman 595775 595775 Borden, Robert, of Hedcron, yeoman 0
5504605 2506361 2506361 defendant Cryps Richard weaver 595775 595775 Cryps, Richard, of Hedcron, weaver 0
5527722 2513251 2513251 defendant Turnour John (legal representative) 595775 595775 Turnour, John, of Hedcron, weaver, executors of 0
5527723 2513251 2513251 defendant Turnour Margaret widow 595775 595775 (Turnour, Margaret, of Hedcron, widow 1
5527724 2513251 2513251 defendant Ongle or Ougle William weaver 595775 595775 Ongle or Ougle, William, of Hedcron, weaver 2
5542389 2517740 2517740 defendant A Bregge Margaret widow 595775 595775 A Bregge, Margaret, of Hedcron, widow 0
5564671 2524253 2524253 plaintiff Borden John   595775 595775 Borden, John, of Hedcron 0
5564674 2524253 2524253 defendant Whyttysperhauk Thomas husbandman 595775 595775 Whyttysperhauk, Thomas, of Hedcron, husbandman 2
5598223 2534333 2534333 defendant Frary Richard husbandman 595775 595775 Frary, Richard, of Hedcron, husbandman 4
5602722 2535729 2535729 defendant Park Robert laborer 595775 595775 Park, Robert, of Hedcron, laborer 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);