names

59 rows where place_id = 587159

✎ 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
3590627 1864710 1864710 defendant Roggers John innholder 587159 587159 Roggers, John, of Hatfeld, innholder 1
3590630 1864711 1864711 defendant Roggers John innholder 587159 587159 Roggers, John, of Hatfeld, innholder 1
3634160 1905485 1905485 defendant Carre James gent 587159 587159 Carre, James, of Hatfeld, gent 1
3657135 1912496 1912496 defendant ap Howell Edward husbandman 587159 587159 ap Howell, Edward, of Hatfeld, husbandman 0
3664456 1914830 1914830 defendant Bakster Thomas laborer 587159 587159 Bakster, Thomas, of Hatfeld, laborer 0
3664457 1914830 1914830 defendant Cales John laborer 587159 587159 Cales, John, of Hatfeld, laborer 1
3697336 1925388 1925388 plaintiff Constable William   587159 587159 Constable, William, of Hatfeld, knight 1
3704894 1927824 1927824 defendant Gryffyth John gent 587159 587159 Gryffyth, John, of Hatfeld, gent 0
3710160 1929492 1929492 defendant Lee Margaret widow 587159 587159 Lee, Margaret, of Hatfeld, widow 1
3711171 1929801 1929801 plaintiff Constable William   587159 587159 Constable, William, of Hatfeld, knight 1
3712722 1930295 1930295 defendant Warde Christopher yeoman 587159 587159 Warde, Christopher, of Hatfeld, yeoman 0
3747535 1941143 1941143 plaintiff Constable William   587159 587159 Constable, William, of Hatfeld 5
3787060 1953747 1953747 plaintiff Churche Stephen   587159 587159 Churche, Stephen, of Hatfeld 1
3803919 1959139 1959139 defendant Nasshe John yeoman 587159 587159 Nasshe, John, of Hatfeld, yeoman 0
3810186 1961077 1961077 defendant Wheler alias Shepey Thomas husbandman 587159 587159 Wheler alias Shepey, Thomas, of Hatfeld, husbandman 1
3826699 1966199 1966199 defendant A Gryffyth John gent 587159 587159 A Gryffyth, John, of Hatfeld, gent 0
3868434 1979681 1979681 defendant Chylde Thomas (legal representative) 587159 587159 Chylde, Thomas, of Hatfeld, administrator of 0
3873389 1981314 1981314 defendant Garard William laborer 587159 587159 Garard, William, of Hatfeld, laborer 3
3885340 1985353 1985353 defendant a Gryffyth John gent 587159 587159 a Gryffyth, John, of Hatfeld, gent 0
3885341 1985353 1985353 defendant Casbroke Elias gent 587159 587159 Casbroke, Elias, of Hatfeld, gent 1
3909248 1993388 1993388 defendant Bayly William husbanman 587159 587159 Bayly, William, of Hatfeld, husbanman 1
3957466 2009675 2009675 defendant Synnyer or Senyer Thomas beer brewer 587159 587159 Synnyer or Senyer, Thomas, of Hatfeld, beer brewer 0
4027211 2034379 2034379 defendant White Nicholas yeoman 587159 587159 White, Nicholas, of Hatfeld, or of Marden, Kent, yeoman 0
4048936 2042061 2042061 defendant Grene William weaver 587159 587159 Grene, William, of Hatfeld, weaver 0
4094535 2058383 2058383 defendant Boxdell or Bodwell Thomas gent 587159 587159 Boxdell or Bodwell, Thomas, of Hatfeld, gent 0
4094536 2058383 2058383 defendant Johnson Christopher yeoman 587159 587159 Johnson, Christopher, of Hatfeld, yeoman 1
4094537 2058383 2058383 defendant Bates James yeoman 587159 587159 Bates, James, of Hatfeld, yeoman 2
4094538 2058383 2058383 defendant Mercer Richard yeoman 587159 587159 Mercer, Richard, of Hatfeld, yeoman 3
4166124 2083659 2083659 defendant Northrop Robert husbandman 587159 587159 Northrop, Robert, of Hatfeld, husbandman 1
4413500 2169108 2169108 defendant Wyther Robert   587159 587159 Wyther, Robert, of Hatfeld, formerly custodian of the victuals in the King's castle of Karsbrok or Carisbrooke, on the Isle of Wight 0
4413502 2169109 2169109 defendant Wyther Robert   587159 587159 Wyther, Robert, of Hatfeld, formerly custodian of the victuals in the King's castle of Karsbrok or Carisbrooke, on the Isle of Wight 0
4415284 2169675 2169675 plaintiff Gyle Adam   587159 587159 Gyle, Adam, of Hatfeld 0
4431727 2174695 2174695 plaintiff Bryan John de   587159 587159 Bryan, John de, of Hatfeld, parson 0
4457016 2187206 2187206 defendant West John   587159 587159 West, John, of Hatfeld 0
4487468 2196795 2196795 defendant Braunde John   587159 587159 Braunde, John, of Hatfeld 2
4494280 2198903 2198903 defendant Baryngton John, junior   587159 587159 Baryngton, John, junior, of Hatfeld 3
4523366 2207629 2207629 defendant Taillour William   587159 587159 Taillour, William, of Hatfeld 3
4533418 2210720 2210720 defendant Derby John butcher 587159 587159 Derby, John, of Hatfeld, butcher 0
4534022 2210911 2210911 defendant Marchall Robert butcher 587159 587159 Marchall, Robert, of Hatfeld, butcher 0
4558743 2218688 2218688 plaintiff Marssch Thomas   587159 587159 Marssch, Thomas, of Hatfeld 2
4567412 2221368 2221368 defendant Brond Thomas   587159 587159 Brond, Thomas, of Hatfeld 1
4588212 2227708 2227708 defendant Gull William   587159 587159 Gull, William, of Hatfeld, prior 0
4591049 2228556 2228556 plaintiff Mere William   587159 587159 Mere, William, of Hatfeld 0
4591065 2228561 2228561 plaintiff Merie William   587159 587159 Merie, William, of Hatfeld 0
4595099 2229723 2229723 defendant Webbe John   587159 587159 Webbe, John, of Hatfeld 1
4640916 2243442 2243442 plaintiff Eppyng John   587159 587159 Eppyng, John, of Hatfeld 0
4776853 2288748 2288748 defendant Mellour John yeoman 587159 587159 Mellour, John, of Hatfeld, yeoman 0
5066106 2376385 2376385 defendant Wyteman John brewer 587159 587159 Wyteman, John, of Hatfeld, brewer 1
5066280 2376441 2376441 defendant Witeman John brewer 587159 587159 Witeman, John, of Hatfeld, brewer 1
5090629 2383642 2383642 defendant Wyteman John brewer 587159 587159 Wyteman, John, of Hatfeld, brewer 1
5106301 2388283 2388283 defendant Grubbe John yeoman 587159 587159 Grubbe, John, of Hatfeld, yeoman 0
5111492 2389756 2389756 defendant Reynold John carpenter 587159 587159 Reynold, John, of Hatfeld, carpenter 0
5111493 2389756 2389756 defendant Iccam Thomas laborer 587159 587159 Iccam, Thomas, of Hatfeld, laborer 1
5111494 2389756 2389756 defendant Coke John laborer 587159 587159 Coke, John, of Hatfeld, laborer 2
5111495 2389756 2389756 defendant Mylner William laborer 587159 587159 Mylner, William, of Hatfeld, laborer 3
5171578 2407407 2407407 defendant May Andrew   587159 587159 May, Andrew, of Hatfeld Regis, prior 0
5268267 2435840 2435840 defendant Marmtyn John laborer 587159 587159 Marmtyn, John, of Hatfeld, laborer 6
5569720 2525716 2525716 defendant Savage Edward   587159 587159 Savage, Edward, of Hatfeld, knight 0
5617101 2549163 2549163 defendant Couhird William   587159 587159 (Couhird, William, of Hatfeld 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);