names

87 rows where place_id = 607706

✎ 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
3670506 1916737 1916737 defendant Brigge William laborer 607706 607706 Brigge, William, of Upton Bishop, laborer 1
3670510 1916738 1916738 defendant Brygge William laborer 607706 607706 Brygge, William, of Upton Bishop, laborer 2
3756005 1943832 1943832 defendant Grey William gent 607706 607706 Grey, William, of Upton Bishop, gent 0
3770113 1948316 1948316 defendant Gatcome John husbandman 607706 607706 Gatcome, John, of Upton Bishop, husbandman 0
3770116 1948317 1948317 defendant Hardewyke John husbandman 607706 607706 Hardewyke, John, of Upton Bishop, husbandman 0
3770119 1948318 1948318 defendant Gatcome John husbandman 607706 607706 Gatcome, John, of Upton Bishop, husbandman 0
3770120 1948318 1948318 defendant Hardwyke John husbandman 607706 607706 Hardwyke, John, of Upton Bishop, husbandman 1
3870084 1980236 1980236 defendant Flowre Thomas husbandman 607706 607706 Flowre, Thomas, of Upton Bishop, husbandman 0
3870085 1980236 1980236 defendant Purroke Thomas husbandman 607706 607706 Purroke, Thomas, of Upton Bishop, husbandman 1
3885404 1985373 1985373 defendant Marden James alias John husbandman 607706 607706 Marden, James alias John, of Upton Bishop, husbandman 0
3885406 1985373 1985373 defendant Gatcombe Christopher husbandman 607706 607706 Gatcombe, Christopher, of Upton Bishop, husbandman 2
3914626 1995235 1995235 defendant Frechnam John husbandman 607706 607706 Frechnam, John, of Upton Bishop, husbandman 0
3968578 2013646 2013646 defendant Cole John husbandman 607706 607706 Cole, John, of Upton Bishop, husbandman 0
3968580 2013647 2013647 defendant Wylse Richard husbandman 607706 607706 Wylse, Richard, of Upton Bishop, husbandman 0
4056772 2044805 2044805 defendant Perrocke Thomas yeoman 607706 607706 Perrocke, Thomas, of Upton Bishop, yeoman 0
4084110 2054590 2054590 defendant Nurthen Thomas husbandman 607706 607706 Nurthen, Thomas, of Upton Bishop, husbandman 2
4086909 2055610 2055610 defendant Claxton James yeoman 607706 607706 Claxton, James, of Upton Bishop, yeoman 0
4100516 2060511 2060511 defendant Claxton James husbandman or yeoman 607706 607706 Claxton, James, of Upton Bishop, husbandman or yeoman 0
4100517 2060511 2060511 defendant Keyse John husbandman or yeoman 607706 607706 Keyse, John, of Upton Bishop, husbandman or yeoman 1
4100518 2060511 2060511 defendant Gybbons John husbandman 607706 607706 Gybbons, John, of Upton Bishop, husbandman 2
4116073 2066041 2066041 defendant Claxton James yeoman 607706 607706 Claxton, James, of Upton Bishop, yeoman 0
4116075 2066041 2066041 defendant Keyse John husbandman or yeoman 607706 607706 Keyse, John, of Upton Bishop, husbandman or yeoman 2
4123257 2068620 2068620 defendant Flower Christopher husbandman 607706 607706 Flower, Christopher, of Upton Bishop, husbandman 1
4123258 2068620 2068620 defendant Cole James husbandman 607706 607706 Cole, James, of Upton Bishop, husbandman 2
4151512 2078651 2078651 defendant Gybbons John yeoman 607706 607706 Gybbons, John, of Upton Bishop, yeoman 1
4158870 2081171 2081171 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 0
4159442 2081368 2081368 defendant Hullyn Thomas clerk 607706 607706 Hullyn, Thomas, of Upton Bishop, clerk 0
4160145 2081613 2081613 defendant Lovell John husbandman 607706 607706 Lovell, John, of Upton Bishop, husbandman 0
4160222 2081638 2081638 defendant Beale John, senior husbandman 607706 607706 Beale, John, senior, of Upton Bishop, husbandman 0
4160223 2081638 2081638 defendant Beale John, junior husbandman 607706 607706 Beale, John, junior, of Upton Bishop, husbandman 1
4160224 2081638 2081638 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 2
4160225 2081638 2081638 defendant Poycke William husbandman 607706 607706 Poycke, William, of Upton Bishop, husbandman 3
4160226 2081638 2081638 defendant Flower Christopher husbandman 607706 607706 Flower, Christopher, of Upton Bishop, husbandman 4
4161442 2082077 2082077 defendant Gatcombe Christopher husbandman or yeoman 607706 607706 Gatcombe, Christopher, of Upton Bishop, husbandman or yeoman 0
4163489 2082755 2082755 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 2
4163494 2082756 2082756 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 2
4166997 2083959 2083959 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 0
4171027 2085349 2085349 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 0
4180677 2088724 2088724 defendant Lovell John yeoman 607706 607706 Lovell, John, of Upton Bishop, yeoman 0
4184790 2090189 2090189 plaintiff Sergeaunte John   607706 607706 Sergeaunte, John, of Upton Bishop 0
4184792 2090189 2090189 defendant Gatcombe Christopher husbandman 607706 607706 Gatcombe, Christopher, of Upton Bishop, husbandman 1
4200770 2095827 2095827 defendant Brooke John yeoman 607706 607706 Brooke, John, of Upton Bishop, yeoman 1
4201691 2096136 2096136 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 0
4213564 2100262 2100262 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 2
4218220 2101876 2101876 defendant Lovell John husbandman 607706 607706 Lovell, John, of Upton Bishop, husbandman 1
4218773 2102065 2102065 defendant Lovell John husbandman 607706 607706 Lovell, John, of Upton Bishop, husbandman 1
4219800 2102429 2102429 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 0
4220147 2102547 2102547 defendant Abrahall Robert gent 607706 607706 Abrahall, Robert, of Upton Bishop, gent 1
4227461 2105086 2105086 defendant Lovell John husbandman 607706 607706 Lovell, John, of Upton Bishop, husbandman 1
4227884 2105235 2105235 defendant Lovell John husbandman 607706 607706 Lovell, John, of Upton Bishop, butcher, husbandman 1
4237612 2108746 2108746 defendant Abrahall Robert gent 607706 607706 Abrahall, Robert, of Upton Bishop, gent 1
4258173 2115708 2115708 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 0
4292556 2127399 2127399 defendant Lovell John husbandman 607706 607706 Lovell, John, of Upton Bishop, husbandman 1
4292561 2127400 2127400 defendant Farryngton Walter husbandman 607706 607706 Farryngton, Walter, of Upton Bishop, husbandman 1
4297483 2129201 2129201 defendant Nurthen Hugh yeoman 607706 607706 Nurthen, Hugh, of Upton Bishop, yeoman 1
4297484 2129201 2129201 defendant Farrington Walter yeoman 607706 607706 Farrington, Walter, of Upton Bishop, yeoman 2
4316254 2135796 2135796 defendant Underwood William yeoman 607706 607706 Underwood, William, of Upton Bishop, yeoman 1
4318143 2136455 2136455 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 0
4323878 2138398 2138398 defendant Abrahall Robert gent 607706 607706 Abrahall, Robert, of Upton Bishop, gent 3
4328303 2139781 2139781 defendant Browne Helen widow 607706 607706 Browne, Helen, of Upton Bishop, widow 0
4328304 2139781 2139781 defendant Browne John her son 607706 607706 Browne, John, of Upton Bishop, husbandman, her son 1
4365539 2152742 2152742 defendant Dawbye George yeoman 607706 607706 Dawbye, George, of Upton Bishop, yeoman 1
4365540 2152742 2152742 defendant Underwoodde Thomas yeoman 607706 607706 Underwoodde, Thomas, of Upton Bishop, yeoman 2
4377798 2157130 2157130 defendant Lovell John butcher 607706 607706 Lovell, John, of Upton Bishop, butcher 3
4377851 2157148 2157148 defendant Claxton James   607706 607706 Claxton, James, of Upton Bishop, yeoman, administrators of 0
4377852 2157148 2157148 defendant Brooke John yeoman 607706 607706 (Brooke, John, of Upton Bishop, yeoman 1
4392625 2162154 2162154 defendant Dawby George yeoman 607706 607706 Dawby, George, of Upton Bishop, yeoman 1
4392626 2162154 2162154 defendant Underwood Thomas yeoman 607706 607706 Underwood, Thomas, of Upton Bishop, yeoman 2
4396737 2163475 2163475 defendant Mathewe Thomas weaver 607706 607706 Mathewe, Thomas, of Upton Bishop, yeoman, weaver 0
4396739 2163476 2163476 defendant Mathewe Thomas yeoman 607706 607706 Mathewe, Thomas, of Upton Bishop, yeoman 0
4398636 2164123 2164123 defendant Pirrock Thomas yeoman 607706 607706 Pirrock, Thomas, of Upton Bishop, yeoman 3
4407581 2167101 2167101 defendant Nurthen Hugh yeoman 607706 607706 Nurthen, Hugh, of Upton Bishop, yeoman 0
4585289 2226824 2226824 defendant Smyth John   607706 607706 Smyth, John, of Upton Bishop 1
4585291 2226824 2226824 defendant Smyth John   607706 607706 Smyth, John, of Upton Bishop, son of Henry 3
4772005 2287219 2287219 defendant Cole John husbandman 607706 607706 Cole, John, of Upton Bishop, husbandman 0
4794392 2294390 2294390 defendant Herdewyke William husbandman 607706 607706 Herdewyke, William, of Upton Bishop, husbandman 1
4883804 2321841 2321841 defendant Wodehous Richard husbandman 607706 607706 Wodehous, Richard, of Upton Bishop, husbandman 0
5053727 2372715 2372715 defendant Grey John gent 607706 607706 Grey, John, of Upton Bishop, gent 0
5058908 2374230 2374230 defendant Pyrrok Walter husbandman 607706 607706 Pyrrok, Walter, of Upton Bishop, husbandman 2
5058915 2374231 2374231 defendant Pyrrok Walter husbandman 607706 607706 Pyrrok, Walter, of Upton Bishop, husbandman 2
5100071 2386459 2386459 defendant Abrygge William husbandman 607706 607706 Abrygge, William, of Upton Bishop, husbandman 0
5100072 2386459 2386459 defendant Pyrok Nicholas husbandman 607706 607706 Pyrok, Nicholas, of Upton Bishop, husbandman 1
5100073 2386459 2386459 defendant Abayton John husbandman 607706 607706 Abayton, John, of Upton Bishop, husbandman 2
5100074 2386459 2386459 defendant Herdewyke John husbandman 607706 607706 Herdewyke, John, of Upton Bishop, husbandman 3
5152419 2401839 2401839 defendant Purrok Nicholas husbandman 607706 607706 Purrok, Nicholas, of Upton Bishop, husbandman 0
5170210 2407015 2407015 defendant Purrok Nicholas husbandman 607706 607706 Purrok, Nicholas, of Upton Bishop, husbandman 0
5245445 2428822 2428822 defendant Purroke Nicholas husbandman 607706 607706 Purroke, Nicholas, of Upton Bishop, husbandman 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);