names

43 rows where place_id = 602831

✎ 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
3651973 1910963 1910963 defendant Pepwall William yeoman 602831 602831 Pepwall, William, of Halesowen, yeoman 0
3651974 1910963 1910963 defendant Wodshawe Thomas yeoman 602831 602831 Wodshawe, Thomas, of Halesowen, yeoman 1
3754477 1943357 1943357 defendant Lucas Thomas embroiderer 602831 602831 Lucas, Thomas, of Halesowen, embroiderer 0
3771754 1948869 1948869 defendant Lucas Thomas embroiderer 602831 602831 Lucas, Thomas, of Halesowen, embroiderer 0
3802374 1958642 1958642 defendant Skrevyn John yeoman 602831 602831 Skrevyn, John, of Halesowen, yeoman 0
3806633 1959974 1959974 plaintiff Rowley William yeoman 602831 602831 Rowley, William, of Halesowen, yeoman 4
3806635 1959974 1959974 plaintiff Cokesey Thomas yeoman 602831 602831 Cokesey, Thomas, of Halesowen, yeoman 6
3806645 1959975 1959975 plaintiff Cokeshey Thomas yeoman 602831 602831 Cokeshey, Thomas, of Halesowen, yeoman 2
3835113 1968921 1968921 defendant Persall John nailer 602831 602831 Persall, John, of Halesowen, nailer 0
3865491 1978677 1978677 defendant Lowe Thomas butcher 602831 602831 Lowe, Thomas, of Halesowen, butcher 0
3882022 1984246 1984246 defendant Hay Richard laborer 602831 602831 Hay, Richard, of Halesowen, laborer 4
3882026 1984247 1984247 defendant Hay Richard laborer 602831 602831 Hay, Richard, of Halesowen, laborer 2
3904440 1991731 1991731 defendant Colley John husbandman 602831 602831 Colley, John, of Halesowen, husbandman 1
3980454 2017777 2017777 defendant Berye William cordwainer 602831 602831 Berye, William, of Halesowen, cordwainer 1
4044770 2040578 2040578 defendant Partryge William yeoman 602831 602831 Partryge, William, of Halesowen, yeoman 0
4046448 2041177 2041177 defendant Park Richard yeoman 602831 602831 Park, Richard, of Halesowen, yeoman 0
4097155 2059305 2059305 defendant Persall Humphrey weaver 602831 602831 Persall, Humphrey, of Halesowen, weaver 0
4113832 2065230 2065230 defendant Belie John   602831 602831 Belie, John, of Halesowen, Salopm clerk 0
4146531 2076938 2076938 defendant Roe William yeoman 602831 602831 Roe, William, of Halesowen, yeoman 1
4146532 2076938 2076938 defendant Hypkys George nailer 602831 602831 Hypkys, George, of Halesowen, nailer 2
4205035 2097306 2097306 defendant Graunger Thomas nailer 602831 602831 Graunger, Thomas, of Halesowen, nailer 0
4237805 2108825 2108825 defendant Warley John gent 602831 602831 Warley, John, of Halesowen, or of Warley Hall, Salop, gent 0
4238951 2109242 2109242 defendant Pershall Lawrence yeoman 602831 602831 Pershall, Lawrence, of Halesowen, yeoman 1
4276151 2121603 2121603 defendant Hipkys John nailer 602831 602831 Hipkys, John, of Halesowen, nailer 2
4294371 2128067 2128067 defendant Hipkys John nailer 602831 602831 Hipkys, John, of Halesowen, nailer 2
4356795 2149605 2149605 defendant Persall Lawrence weaver 602831 602831 Persall, Lawrence, of Halesowen, weaver 0
4357000 2149680 2149680 defendant Barkeley alias Manington William gent 602831 602831 Barkeley alias Manington, William, of Halesowen, gent 0
4358902 2150349 2150349 defendant Halton William (legal representative) 602831 602831 Halton, William, of Halesowen, shoemaker, executors of 0
4381304 2158427 2158427 defendant Barkeley alias Manyngton William   602831 602831 Barkeley alias Manyngton, William, of Halesowen, Salop gent 0
4406366 2166694 2166694 defendant Parkes William nailer 602831 602831 Parkes, William, of Halesowen, nailer 1
4411603 2168475 2168475 defendant Piersall Lawrence weaver 602831 602831 Piersall, Lawrence, of Halesowen, weaver 0
4612554 2234994 2234994 defendant Wyllenhale John   602831 602831 Wyllenhale, John, of Halesowen 0
4618118 2236677 2236677 defendant Mylward William   602831 602831 Mylward, William, of Halesowen 0
4626288 2239180 2239180 defendant Willenhale John   602831 602831 Willenhale, John, of Halesowen 0
4784752 2291238 2291238 defendant Baker John baker 602831 602831 Baker, John, of Halesowen, baker 0
5016151 2361608 2361608 defendant Smyth Nicholas   602831 602831 Smyth, Nicholas, of Halesowen, administrators of 0
5216644 2420600 2420600 defendant Colshill John chapman 602831 602831 Colshill, John, of Halesowen, chapman 0
5241702 2427782 2427782 defendant Byssop William gent 602831 602831 Byssop, William, of Halesowen, gent 0
5271622 2436797 2436797 defendant Hawekys William tanner 602831 602831 Hawekys, William, of Halesowen, tanner 0
5271803 2436848 2436848 defendant Hawekys William tanner 602831 602831 Hawekys, William, of Halesowen, tanner 0
5399314 2474876 2474876 plaintiff Derby John   602831 602831 Derby, John, of Halesowen, abbot of the Monastery of BM 0
5399316 2474877 2474877 plaintiff Derby John   602831 602831 Derby, John, of Halesowen, abbot of the Monastery of BM 0
5432193 2484597 2484597 defendant Potte William laborer 602831 602831 Potte, William, of Halesowen, 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);