names

68 rows where place_id = 644564

✎ 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
3880396 1983699 1983699 defendant Inke John yeoman 644564 644564 Inke, John, of Leominster, Herefs, yeoman 0
3950748 2007332 2007332 defendant Howes Richard tailor 644564 644564 Howes, Richard, of Leominster, Herefs, tailor 11
3964253 2012104 2012104 plaintiff ap Thomas John mercer 644564 644564 ap Thomas, John, of Leominster, Herefs, mercer 0
3975700 2016060 2016060 plaintiff Hyggyns John butcher 644564 644564 Hyggyns, John, of Leominster, Herefs, butcher 0
3980932 2017941 2017941 plaintiff Powle John (legal representative) 644564 644564 Powle, John, of Leominster, Herefs, executors of 0
3986323 2019847 2019847 defendant ap Thomas Samarius walker 644564 644564 ap Thomas, Samarius, of Leominster, Herefs, walker 3
4041184 2039336 2039336 defendant ap Thomas John mercer 644564 644564 ap Thomas, John, of Leominster, Herefs, mercer 1
4041188 2039337 2039337 defendant ap Thomas John mercer 644564 644564 ap Thomas, John, of Leominster, Herefs, mercer 1
4041191 2039338 2039338 defendant Caldwall Richard yeoman 644564 644564 Caldwall, Richard, of Leominster, Herefs, yeoman 0
4041194 2039339 2039339 defendant Caldwall Richard yeoman 644564 644564 Caldwall, Richard, of Leominster, Herefs, yeoman 0
4044929 2040641 2040641 defendant Peryn William yeoman 644564 644564 Peryn, William, of Leominster, Herefs, yeoman 0
4052802 2043437 2043437 defendant ap Thomas John   644564 644564 ap Thomas, John, of Leominster, Herefs 1
4055270 2044284 2044284 plaintiff Bennet Thomas cordewainer 644564 644564 Bennet, Thomas, of Leominster, Herefs, cordewainer 0
4068059 2048882 2048882 defendant Creswell John, senior gent 644564 644564 Creswell, John, senior, of Leominster, Herefs, gent 0
4081233 2053596 2053596 defendant Harrys John hosier 644564 644564 Harrys, John, of Leominster, Herefs, yeoman, or of London, hosier 0
4135315 2072951 2072951 defendant Holland John yeoman 644564 644564 Holland, John, of Leominster, Herefs, yeoman 0
4149597 2077982 2077982 defendant Heayford Philip gent 644564 644564 Heayford, Philip, of Leominster, Herefs, gent 2
4150341 2078251 2078251 defendant Baker Roland chapman 644564 644564 Baker, Roland, of Leominster, Herefs, chapman 0
4153554 2079337 2079337 defendant Wall Humphrey chapman 644564 644564 Wall, Humphrey, of Leominster, Herefs, chapman 1
4154470 2079655 2079655 defendant Evans alias Dallowe John yeoman 644564 644564 Evans alias Dallowe, John, of Leominster, Herefs, yeoman 0
4209010 2098703 2098703 defendant Shoter Thomas chapman 644564 644564 Shoter, Thomas, of Leominster, Herefs, chapman 0
4225194 2104281 2104281 defendant Powle Richard tanner 644564 644564 Powle, Richard, of Leominster, Herefs, tanner 1
4259062 2116002 2116002 defendant Jeffres John yeoman 644564 644564 Jeffres, John, of Leominster, Herefs, yeoman 2
4270846 2119823 2119823 defendant Smyth John butcher 644564 644564 Smyth, John, of Leominster, Herefs, butcher 0
4270851 2119824 2119824 defendant Jeffres John yeoman 644564 644564 Jeffres, John, of Leominster, Herefs, yeoman 2
4271817 2120150 2120150 defendant Addys John mercer 644564 644564 Addys, John, of Leominster, Herefs, mercer 0
4291660 2127094 2127094 defendant Hackluytt Miles gent 644564 644564 Hackluytt, Miles, of Leominster, Herefs, gent 0
4293178 2127621 2127621 defendant Baker John yeoman 644564 644564 Baker, John, of Leominster, Herefs, yeoman 0
4293180 2127622 2127622 defendant Creswell John gent 644564 644564 Creswell, John, of Leominster, Herefs, gent 0
4297594 2129243 2129243 defendant Waucklen John yeoman 644564 644564 Waucklen, John, of Leominster, Herefs, yeoman 0
4299088 2129772 2129772 defendant Adames Thomas yeoman 644564 644564 Adames, Thomas, of Leominster, Herefs, yeoman 1
4301880 2130780 2130780 defendant Creswell John gent 644564 644564 Creswell, John, of Leominster, Herefs, gent 0
4332069 2141024 2141024 defendant Hyett Thomas gent 644564 644564 (Hyett, Thomas, of Leominster, Herefs, gent 1
4332387 2141122 2141122 defendant Adames Thomas yeoman 644564 644564 Adames, Thomas, of Leominster, Herefs, yeoman 1
4340014 2143774 2143774 defendant Blounte Richard gent 644564 644564 Blounte, Richard, of Leominster, Herefs, or of Inner Temple, London, gent 1
4356119 2149363 2149363 defendant Wall Humphrey chapman 644564 644564 Wall, Humphrey, of Leominster, Herefs, chapman 1
4370410 2154469 2154469 defendant Stubbes Maud widow 644564 644564 Stubbes, Maud, of Leominster, Herefs, widow 3
4370417 2154470 2154470 defendant Lane Richard mercer 644564 644564 Lane, Richard, of Leominster, Herefs, mercer 2
4401883 2165225 2165225 defendant ap Thomas Philip chapman 644564 644564 ap Thomas, Philip, of Leominster, Herefs, chapman 2
4692196 2263080 2263080 defendant Bradeford John yeoman 644564 644564 Bradeford, John, of Leominster, Herefs, yeoman 0
4692658 2263217 2263217 defendant Hood Thomas merchant 644564 644564 Hood, Thomas, of Leominster, Herefs, merchant 0
4694809 2263869 2263869 defendant Taverner William chapman 644564 644564 Taverner, William, of Leominster, Herefs, chapman 1
4694811 2263869 2263869 defendant Aston John tanner 644564 644564 Aston, John, of Leominster, Herefs, tanner 3
4697133 2264582 2264582 defendant Burgoyn Walter tanner 644564 644564 Burgoyn, Walter, of Leominster, Herefs, tanner 2
4707789 2267803 2267803 defendant Dyer Robert dyer 644564 644564 Dyer, Robert, of Leominster, Herefs, dyer 0
4709015 2268188 2268188 defendant Turball Thomas chapman 644564 644564 Turball, Thomas, of Leominster, Herefs, chapman 1
4709022 2268189 2268189 defendant Turgall Thomas chapman 644564 644564 Turgall, Thomas, of Leominster, Herefs, chapman 1
4723006 2272506 2272506 defendant Graseley William yeoman 644564 644564 Graseley, William, of Leominster, Herefs, yeoman 1
4760879 2283743 2283743 defendant Yong Thomas barber 644564 644564 Yong, Thomas, of Leominster, Herefs, barber 0
4803329 2297232 2297232 defendant Crewe John yeoman 644564 644564 Crewe, John, of Leominster, Herefs, yeoman 0
4804478 2297586 2297586 defendant Crewe John yeoman 644564 644564 Crewe, John, of Leominster, Herefs, yeoman 0
4828112 2304836 2304836 defendant Tomkyns John chapman 644564 644564 Tomkyns, John, of Leominster, Herefs, chapman 0
4841513 2308876 2308876 defendant Crispe David carrier 644564 644564 Crispe, David, of Leominster, Herefs, carrier 0
4848663 2311052 2311052 defendant Cryspe John yeoman 644564 644564 Cryspe, John, of Leominster, Herefs, yeoman 4
5000622 2357050 2357050 defendant Preston William   644564 644564 Preston, William, of Leominster, Herefs, wax chandler 4
5142573 2398956 2398956 plaintiff Wrothe John mercer 644564 644564 Wrothe, John, of Leominster, Herefs, mercer 0
5163944 2405193 2405193 plaintiff Wrothe John mercer 644564 644564 Wrothe, John, of Leominster, Herefs, mercer 0
5163946 2405194 2405194 plaintiff Wrothe John mercer 644564 644564 Wrothe, John, of Leominster, Herefs, mercer 0
5166971 2406072 2406072 defendant Hode Walter chapman 644564 644564 Hode, Walter, of Leominster, Herefs, chapman 0
5177401 2409087 2409087 plaintiff Wroche John mercer 644564 644564 Wroche, John, of Leominster, Herefs, mercer 0
5180097 2409918 2409918 defendant Taverner John vintner 644564 644564 Taverner, John, of Leominster, Herefs, vintner 0
5180099 2409919 2409919 defendant Taverner John vintner 644564 644564 Taverner, John, of Leominster, Herefs, vintner 0
5180101 2409920 2409920 defendant Taverner John vintner 644564 644564 Taverner, John, of Leominster, Herefs, vintner 0
5200542 2415919 2415919 defendant Spencer William dyer 644564 644564 Spencer, William, of Leominster, Herefs, dyer 3
5211475 2419091 2419091 plaintiff Wroche John mercer 644564 644564 Wroche, John, of Leominster, Herefs, mercer 0
5269305 2436123 2436123 defendant (illegible) William mercer 644564 644564 ---, William, of Leominster, Herefs, mercer 0
5452115 2490511 2490511 defendant Skarlet John mercer 644564 644564 Skarlet, John, of Leominster, Herefs, mercer 2
5464059 2494162 2494162 defendant Skarlet John mercer 644564 644564 Skarlet, John, of Leominster, Herefs, mercer 2

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