names

71 rows where place_id = 594452

✎ 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
3616181 1872699 1872699 defendant Scotwell William husbandman 594452 594452 Scotwell, William, of Hilton, husbandman 0
3722256 1933217 1933217 defendant Brigehynd John, senior husbandman 594452 594452 Brigehynd, John, senior, of Hilton, husbandman 0
3752951 1942853 1942853 defendant Bell Thomas husbandman 594452 594452 Bell, Thomas, of Hilton, husbandman 0
3988231 2020539 2020539 plaintiff ap Davye John yeoman 594452 594452 ap Davye, John, of Hilton, yeoman 0
3996409 2023472 2023472 plaintiff Davye John yeoman 594452 594452 Davye, John, of Hilton, yeoman 0
4012538 2029208 2029208 plaintiff Randes Thomas gent 594452 594452 Randes, Thomas, of Hilton, gent 0
4033181 2036519 2036519 defendant Atkys Walter husbandman 594452 594452 Atkys, Walter, of Hilton, husbandman 0
4160539 2081761 2081761 defendant Hodge John yeoman 594452 594452 Hodge, John, of Hilton, yeoman 0
4274296 2120955 2120955 defendant Myller Edward (legal representative) 594452 594452 Myller, Edward, of Hilton, yeoman, administrator of 0
4343248 2144912 2144912 defendant Jenyng Richard yeoman 594452 594452 Jenyng, Richard, of Hilton, yeoman 1
4343249 2144912 2144912 defendant Rignall Marmaduke husbandman 594452 594452 Rignall, Marmaduke, of Hilton, husbandman 2
4343251 2144913 2144913 defendant Jeninge Richard yeoman 594452 594452 Jeninge, Richard, of Hilton, yeoman 0
4348001 2146553 2146553 defendant Frier John husbandman 594452 594452 Frier, John, of Hilton, husbandman 0
4366993 2153249 2153249 defendant Jening Richard yeoman 594452 594452 Jening, Richard, of Hilton, yeoman 0
4372718 2155320 2155320 defendant Walker Leonard clerk 594452 594452 Walker, Leonard, of Hilton, clerk 0
4372720 2155321 2155321 defendant Walker Leonard clerk 594452 594452 Walker, Leonard, of Hilton, clerk 0
4378991 2157565 2157565 defendant Rowsby Thomas yeoman 594452 594452 Rowsby, Thomas, of Hilton, yeoman 1
4391719 2161850 2161850 defendant Shurley John husbandman 594452 594452 Shurley, John, of Hilton, husbandman 0
4455830 2186838 2186838 defendant Zutie Simon   594452 594452 Zutie, Simon, of hilton 0
4456330 2187002 2187002 defendant Yutte Simon   594452 594452 Yutte, Simon, of Hilton 0
4480419 2194545 2194545 defendant Lesset John   594452 594452 Lesset, John, of Hilton 0
4486047 2196339 2196339 defendant Wylcokson William   594452 594452 Wylcokson, William, of Hilton 0
4495109 2199159 2199159 defendant Ive Walter   594452 594452 Ive, Walter, of Hilton 1
4495110 2199159 2199159 defendant Cook Thomas   594452 594452 Cook, Thomas, of Hilton 2
4507903 2202935 2202935 defendant Lesset John   594452 594452 Lesset, John, of Hilton 0
4541942 2213369 2213369 defendant Smyth William   594452 594452 Smyth, William, of Hilton 0
4585181 2226787 2226787 defendant West John   594452 594452 West, John, of Hilton 2
4588737 2227858 2227858 defendant Lesset John   594452 594452 Lesset, John, of Hilton 0
4616301 2236091 2236091 defendant West John   594452 594452 West, John, of Hilton 0
4632007 2240894 2240894 defendant Hilton William   594452 594452 Hilton, William, of Hilton, knight 0
4632156 2240936 2240936 defendant West John   594452 594452 West, John, of Hilton 1
4633572 2241355 2241355 defendant West John   594452 594452 West, John, of Hilton 0
4641449 2243596 2243596 defendant West John   594452 594452 West, John, of Hilton 0
4646260 2244979 2244979 defendant West John   594452 594452 West, John, of Hilton 0
4762644 2284296 2284296 defendant Shirley Henry husbandman 594452 594452 Shirley, Henry, of Hilton, husbandman 0
4797230 2295305 2295305 defendant Batell John butcher 594452 594452 Batell, John, of Hilton, butcher 2
4821993 2302949 2302949 defendant Botiller Robert gent 594452 594452 Botiller, Robert, of Hilton, gent 0
4837633 2307701 2307701 defendant Haryson John yeoman 594452 594452 Haryson, John, of Hilton, yeoman 5
4892354 2324344 2324344 defendant Harryson John husbandman 594452 594452 Harryson, John, of Hilton, husbandman 0
4909419 2329484 2329484 defendant Harrison John shoemaker 594452 594452 Harrison, John, of Hilton, shoemaker 0
4924224 2334021 2334021 defendant Bruggend Robert husbandman 594452 594452 Bruggend, Robert, of Hilton, husbandman 2
4924231 2334022 2334022 defendant Bruggend Robert husbandman 594452 594452 Bruggend, Robert, of Hilton, husbandman 2
4927135 2334921 2334921 defendant Tomlynson William husbandman 594452 594452 Tomlynson, William, of hilton, husbandman 0
4931986 2336392 2336392 defendant Punte Thomas husbandman 594452 594452 Punte, Thomas, of hilton, husbandman 0
4936688 2337858 2337858 plaintiff Bray John   594452 594452 Bray, John, of Hilton 0
4961802 2345492 2345492 defendant Lambeyt or Lambert Nicholas esq 594452 594452 Lambeyt or Lambert, Nicholas, of Hilton, esq 1
4964138 2346185 2346185 plaintiff Webbe John   594452 594452 Webbe, John, of Hilton 1
4964141 2346186 2346186 plaintiff Webbe John   594452 594452 Webbe, John, of Hilton 1
4981134 2351288 2351288 plaintiff Webbe John   594452 594452 Webbe, John, of Hilton 1
4983711 2352057 2352057 plaintiff Webbe John   594452 594452 Webbe, John, of Hilton 0
4983716 2352058 2352058 plaintiff Webbe John   594452 594452 Webbe, John, of Hilton 0
4988377 2353494 2353494 defendant Lambert Nicholas esq 594452 594452 Lambert, Nicholas, of Hilton, esq 1
5040167 2368659 2368659 defendant James William husbandman 594452 594452 James, William, of Hilton, husbandman 0
5101493 2386849 2386849 defendant Asteley Thomas esq 594452 594452 Asteley, Thomas, of Hilton, esq 0
5170110 2406987 2406987 defendant Mason Richard yeoman 594452 594452 Mason, Richard, of Hilton, yeoman 0
5212721 2419468 2419468 defendant Holte Nicholas yeoman 594452 594452 Holte, Nicholas, of Hilton, yeoman 2
5212722 2419468 2419468 defendant Holte John yeoman 594452 594452 Holte, John, of Hilton, yeoman 3
5252655 2430943 2430943 defendant Mitton John gent 594452 594452 Mitton, John, of Hilton, gent 0
5308412 2447551 2447551 defendant Smyth William husbandman 594452 594452 Smyth, William, of Hilton, husbandman 0
5308413 2447551 2447551 defendant Rychardson William husbandman 594452 594452 Rychardson, William, of Hilton, husbandman 1
5308414 2447551 2447551 defendant Prestly John husbandman 594452 594452 Prestly, John, of Hilton, husbandman 2
5342354 2457805 2457805 defendant Bradeney Stephen husbandman 594452 594452 Bradeney, Stephen, of Hilton, husbandman 0
5487307 2501104 2501104 defendant Mitton John esq 594452 594452 Mitton, John, of Hilton, esq 0
5543032 2517938 2517938 defendant Watson Nicholas   594452 594452 Watson, Nicholas, of Hilton, wheelwright 0
5543033 2517938 2517938 defendant Sherley Thomas husbandman 594452 594452 Sherley, Thomas, of Hilton, husbandman 1
5543034 2517938 2517938 defendant Scales William husbandman 594452 594452 Scales, William, of Hilton, husbandman 2
5557470 2522135 2522135 defendant Hilton John gent 594452 594452 Hilton, John, of Hilton, gent 0
5572223 2526428 2526428 defendant Smyth John husbandman 594452 594452 Smyth, John, of Hilton, husbandman 1
5572224 2526428 2526428 defendant Moresby William husbandman 594452 594452 Moresby, William, of Hilton, husbandman 2
5634203 2554680 2554680 defendant Ive Thomas husbandman 594452 594452 Ive, Thomas, of Hilton, husbandman 0
5634204 2554680 2554680 defendant Lucas John husbandman 594452 594452 Lucas, John, of Hilton, husbandman 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);