names

54 rows where place_id = 613512

✎ 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
3698750 1925826 1925826 defendant Ughtred Anthony gent 613512 613512 Ughtred, Anthony, of Kexby, gent 1
3698755 1925827 1925827 defendant Ughtred Anthony gent 613512 613512 Ughtred, Anthony, of Kexby, gent 1
3704265 1927631 1927631 defendant Hoverend George yeoman 613512 613512 Hoverend, George, of Kexby, yeoman 1
3704266 1927631 1927631 defendant Hoverend Anthony yeoman 613512 613512 Hoverend, Anthony, of Kexby, yeoman 2
3801946 1958507 1958507 defendant Ughtrede Robert esq 613512 613512 Ughtrede, Robert, of Kexby, esq 0
3801947 1958507 1958507 defendant Ughtrede Anthony esq 613512 613512 Ughtrede, Anthony, of Kexby, esq 1
3801948 1958507 1958507 defendant Trewe Richard yeoman 613512 613512 Trewe, Richard, of Kexby, yeoman 2
3801949 1958507 1958507 defendant Overend George yeoman 613512 613512 Overend, George, of Kexby, yeoman 3
3801951 1958507 1958507 defendant Scayff William yeoman 613512 613512 Scayff, William, of Kexby, yeoman 5
3801957 1958508 1958508 defendant Ughtrede Robert esq 613512 613512 Ughtrede, Robert, of Kexby, esq 0
3801958 1958508 1958508 defendant Ughtrede Anthony esq 613512 613512 Ughtrede, Anthony, of Kexby, esq 1
3801959 1958508 1958508 defendant Trewe Richard yeoman 613512 613512 Trewe, Richard, of Kexby, yeoman 2
3801960 1958508 1958508 defendant Overend George yeoman 613512 613512 Overend, George, of Kexby, yeoman 3
3801962 1958508 1958508 defendant Scayff William yeoman 613512 613512 Scayff, William, of Kexby, yeoman 5
3820882 1964425 1964425 defendant Baynton Richard (legal representative) 613512 613512 Baynton, Richard, of Kexby, yeoman, executrix of 0
3825734 1965900 1965900 defendant Trewe Richard yeoman 613512 613512 Trewe, Richard, of Kexby, yeoman 1
3825740 1965901 1965901 defendant Trewe Richard yeoman 613512 613512 Trewe, Richard, of Kexby, yeoman 1
3830481 1967412 1967412 defendant Hoverend George yeoman 613512 613512 Hoverend, George, of Kexby, yeoman 0
3830482 1967412 1967412 defendant Hoverend Anthony yeoman 613512 613512 Hoverend, Anthony, of Kexby, yeoman 1
4091553 2057271 2057271 defendant Constable Dorothy widow 613512 613512 Constable, Dorothy, of Kexby, widow 0
4282480 2123773 2123773 defendant Tanfeyld Thomas husbandman 613512 613512 Tanfeyld, Thomas, of Kexby, husbandman 1
4282481 2123773 2123773 defendant Sykes John yeoman 613512 613512 Sykes, John, of Kexby, yeoman 2
4444453 2183244 2183244 plaintiff Coke William   613512 613512 Coke, William, of Kexby 0
4444454 2183244 2183244 defendant Forester John   613512 613512 Forester, John, of Kexby 0
4475007 2192853 2192853 defendant Coke William   613512 613512 Coke, William, of Kexby 0
4516254 2205494 2205494 plaintiff Coke William   613512 613512 Coke, William, of Kexby 0
4517481 2205863 2205863 plaintiff Cuke William   613512 613512 Cuke, William, of Kexby 0
4579221 2224982 2224982 plaintiff Cook Agnes   613512 613512 Cook, Agnes, of Kexby, formerly wife of William 0
4583374 2226221 2226221 defendant Prestwold Thomas   613512 613512 Prestwold, Thomas, of kexby 0
4685733 2261126 2261126 defendant Squyer William yeoman 613512 613512 Squyer, William, of Kexby, yeoman 3
4685735 2261127 2261127 defendant Squyer William yeoman 613512 613512 Squyer, William, of Kexby, yeoman 0
4695987 2264231 2264231 defendant Swyer William yeoman 613512 613512 Swyer, William, of Kexby, yeoman 2
4793508 2294079 2294079 defendant Topclyff John   613512 613512 Topclyff, John, of Kexby, gent, sergeant at arms 0
4821774 2302888 2302888 defendant Monkman John yeoman 613512 613512 Monkman, John, of Kexby, yeoman 0
4868348 2317078 2317078 defendant Marsshall John chaplain 613512 613512 Marsshall, John, of Kexby, chaplain 0
4868349 2317078 2317078 defendant Gaunton William, junior   613512 613512 Gaunton, William, junior, of Kexby, servant 1
4868622 2317161 2317161 defendant Marsshall John chaplain 613512 613512 Marsshall, John, of Kexby, chaplain 0
4868623 2317161 2317161 defendant Gaunton William, junior   613512 613512 Gaunton, William, junior, of Kexby, servant 1
4870921 2317880 2317880 defendant Foster Alexander yeoman 613512 613512 Foster, Alexander, of Kexby, yeoman 3
4872152 2318249 2318249 defendant Ughtred Thomas gent 613512 613512 Ughtred, Thomas, of Kexby, gent 0
4879789 2320597 2320597 defendant Foster or Forester Alexander yeoman 613512 613512 Foster or Forester, Alexander, of Kexby, yeoman 0
5010429 2359921 2359921 defendant Jakson Thomas husbandman 613512 613512 Jakson, Thomas, of Kexby, husbandman 0
5010431 2359922 2359922 defendant Jakson Thomas   613512 613512 Jakson, Thomas, of Kexby 0
5019407 2362558 2362558 defendant Dobson William yeoman 613512 613512 Dobson, William, of Kexby, yeoman 3
5037312 2367784 2367784 defendant Lokton Thomas chaplain 613512 613512 Lokton, Thomas, of Kexby, chaplain 1
5090589 2383629 2383629 defendant Jakeson Richard husbandman 613512 613512 Jakeson, Richard, of Kexby, husbandman 0
5098151 2385892 2385892 defendant Dobson William yeoman 613512 613512 Dobson, William, of Kexby, yeoman 1
5101273 2386781 2386781 defendant Butler Thomas yeoman 613512 613512 Butler, Thomas, of Kexby, yeoman 3
5331137 2454386 2454386 defendant Ughted Robert   613512 613512 Ughted, Robert, of Kexby, knight 0
5351227 2460476 2460476 defendant Ughtred Robert   613512 613512 Ughtred, Robert, of Kexby, knight 0
5388211 2471677 2471677 defendant Pallyng Richard husbandman 613512 613512 Pallyng, Richard, of Kexby, husbandman 0
5557027 2522013 2522013 defendant Falshed John yeoman 613512 613512 Falshed, John, of Kexby, yeoman 0
5578101 2528221 2528221 defendant Ughttred Henry esq 613512 613512 Ughttred, Henry, of Kexby, esq 0
5630506 2553553 2553553 defendant Baker William husbandman 613512 613512 Baker, William, of Kexby, husbandman 5

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