names

79 rows where place_id = 611978

✎ 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
3691024 1923357 1923357 defendant Longley Margery widow 611978 611978 Longley, Margery, of Dalton, widow 1
3719584 1932390 1932390 defendant Dalton Richard gent 611978 611978 Dalton, Richard, of Dalton, gent 0
3744544 1940195 1940195 defendant Vaughan David yeoman 611978 611978 Vaughan, David, of Dalton, yeoman 1
3754680 1943423 1943423 defendant Dalby Richard gent 611978 611978 Dalby, Richard, of Dalton, gent 0
3805275 1959595 1959595 defendant Dalton Richard gent 611978 611978 Dalton, Richard, of Dalton, gent 0
3812077 1961688 1961688 defendant Tayliour Nicholas husbandman 611978 611978 Tayliour, Nicholas, of Dalton, husbandman 0
3845247 1972075 1972075 defendant Coplay William laborer 611978 611978 Coplay, William, of Dalton, laborer 0
3995468 2023123 2023123 defendant Huton John yeoman 611978 611978 Huton, John, of Dalton, or of Kyrtlyngton, yeoman 0
4018706 2031425 2031425 defendant Browne Thomas yeoman 611978 611978 Browne, Thomas, of Dalton, yeoman 0
4018707 2031425 2031425 defendant Barker John yeoman 611978 611978 Barker, John, of Dalton, yeoman 1
4018708 2031425 2031425 defendant Francys Thomas yeoman 611978 611978 Francys, Thomas, of Dalton, yeoman 2
4018709 2031425 2031425 defendant Bell John clerk 611978 611978 Bell, John, of Dalton, clerk 3
4018710 2031425 2031425 defendant Mason William yeoman 611978 611978 Mason, William, of Dalton, yeoman 4
4018711 2031425 2031425 defendant Bell Robert yeoman 611978 611978 Bell, Robert, of Dalton, yeoman 5
4069918 2049523 2049523 plaintiff Lynley George (legal representative) 611978 611978 Lynley, George, of Dalton, yeoman, executors of 0
4078853 2052734 2052734 defendant Hurste Arthur clothier 611978 611978 Hurste, Arthur, of Dalton, clothier 0
4096478 2059068 2059068 defendant Hoylande Edward laborer 611978 611978 Hoylande, Edward, of Dalton, laborer 0
4096479 2059068 2059068 defendant Hyrste John husbandman 611978 611978 Hyrste, John, of Dalton, husbandman 1
4117685 2066621 2066621 defendant Nell Thomas, senior yeoman 611978 611978 Nell, Thomas, senior, of Dalton, yeoman 0
4117690 2066622 2066622 defendant Nell Thomas, senior yeoman 611978 611978 Nell, Thomas, senior, of Dalton, yeoman 0
4131930 2071732 2071732 defendant Brouke Agnes widow 611978 611978 Brouke, Agnes, of Dalton, widow 0
4131932 2071732 2071732 defendant Hirste Richard clothier 611978 611978 Hirste, Richard, of Dalton, clothier 2
4138641 2074186 2074186 defendant Deane William tanner and husbandman 611978 611978 Deane, William, of Dalton, wright, tanner and husbandman 3
4141330 2075127 2075127 defendant Nell Thomas, senior husbandman 611978 611978 Nell, Thomas, senior, of Dalton, husbandman 1
4156038 2080185 2080185 defendant Hullande Edward glover 611978 611978 Hullande, Edward, of Dalton, glover 0
4157408 2080662 2080662 defendant Wombewell Ralph gent 611978 611978 Wombewell, Ralph, of Dalton, gent 1
4163252 2082677 2082677 defendant Deane William husbandman 611978 611978 Deane, William, of Dalton, husbandman 3
4168714 2084545 2084545 defendant Holland Edward fellmonger 611978 611978 Holland, Edward, of Dalton, glover, fellmonger 0
4176885 2087385 2087385 defendant Hoyland Edward fellmonger 611978 611978 Hoyland, Edward, of Dalton, fellmonger 0
4179771 2088399 2088399 defendant Bever William   611978 611978 Bever, William, of Dalton, wheelwright 0
4208884 2098654 2098654 defendant Hoyland Edward fellmonger 611978 611978 Hoyland, Edward, of Dalton, fellmonger 0
4218492 2101966 2101966 defendant Dewler John husbandman 611978 611978 Dewler, John, of Dalton, husbandman 1
4271183 2119936 2119936 defendant Richardson Reginald merchant 611978 611978 Richardson, Reginald, of Dalton, merchant 2
4324393 2138554 2138554 defendant Lugge Philip, senior husbandman 611978 611978 Lugge, Philip, senior, of Dalton, husbandman 1
4425610 2172832 2172832 plaintiff Harlot William   611978 611978 Harlot, William, of Dalton 7
4450683 2185173 2185173 defendant Ward John   611978 611978 Ward, John, of Dalton 0
4451326 2185383 2185383 plaintiff Hikkeson Thomas   611978 611978 Hikkeson, Thomas, of Dalton, on his own account 0
4478894 2194068 2194068 defendant Westeby John   611978 611978 Westeby, John, of Dalton 1
4500219 2200697 2200697 defendant Ge--- William   611978 611978 Ge---, William, of Dalton 4
4504432 2201940 2201940 defendant Tagge Robert   611978 611978 Tagge, Robert, of Dalton 0
4517712 2205931 2205931 defendant Longeley William   611978 611978 Longeley, William, of Dalton 0
4517713 2205931 2205931 defendant Longeley Thomas   611978 611978 Longeley, Thomas, of Dalton 1
4517714 2205931 2205931 defendant Wyghton William   611978 611978 Wyghton, William, of Dalton 2
4517715 2205931 2205931 defendant Taillour William   611978 611978 Taillour, William, of Dalton 3
4517723 2205933 2205933 defendant Longeley William   611978 611978 Longeley, William, of Dalton 0
4517724 2205933 2205933 defendant Longeley Thomas   611978 611978 Longeley, Thomas, of Dalton 1
4517725 2205933 2205933 defendant Dyghton William   611978 611978 Dyghton, William, of Dalton 2
4517726 2205933 2205933 defendant Taillour William   611978 611978 Taillour, William, of Dalton 3
4527096 2208757 2208757 defendant Malkynson Thomas   611978 611978 Malkynson, Thomas, of Dalton 2
4527100 2208758 2208758 defendant Malkynson Thomas   611978 611978 Malkynson, Thomas, of Dalton 2
4527102 2208759 2208759 defendant Thorp Robert de   611978 611978 Thorp, Robert de, of Dalton 0
4531485 2210123 2210123 defendant Thorp Robert de   611978 611978 Thorp, Robert de, of Dalton 0
4575177 2223756 2223756 defendant Tyas Thomas   611978 611978 Tyas, Thomas, of Dalton 1
4580822 2225484 2225484 defendant Laweson Robert   611978 611978 Laweson, Robert, of Dalton 2
4622489 2238014 2238014 defendant Hewer Thomas   611978 611978 Hewer, Thomas, of Dalton 2
4623629 2238369 2238369 defendant Stud John   611978 611978 Stud, John, of Dalton 4
4623697 2238386 2238386 defendant Gentil John   611978 611978 Gentil, John, of Dalton 2
4634856 2241754 2241754 defendant Midelton John   611978 611978 Midelton, John, of Dalton 2
4650464 2246153 2246153 defendant Dalton Thomas   611978 611978 Dalton, Thomas, of Dalton 0
4776691 2288698 2288698 defendant Hewere Thomas husbandman 611978 611978 Hewere, Thomas, of Dalton, husbandman 4
4936835 2337900 2337900 defendant Jonson Thomas yeoman 611978 611978 Jonson, Thomas, of Dalton, yeoman 4
4936836 2337900 2337900 defendant Russell John yeoman 611978 611978 Russell, John, of Dalton, yeoman 5
4948661 2341564 2341564 defendant Hepworth John, junior husbandman 611978 611978 Hepworth, John, junior, of Dalton, husbandman 1
4949124 2341717 2341717 defendant Stobbe William yeoman 611978 611978 Stobbe, William, of Dalton, yeoman 0
4992096 2354526 2354526 plaintiff Croft Nicholas esq 611978 611978 Croft, Nicholas, of Dalton, esq 0
4992098 2354527 2354527 plaintiff Croft Nicholas esq 611978 611978 Croft, Nicholas, of Dalton, esq 0
5012284 2360444 2360444 defendant Tagge Thomas husbandman 611978 611978 Tagge, Thomas, of Dalton, husbandman 1
5019988 2362727 2362727 defendant Lovedey John husbandman 611978 611978 Lovedey, John, of Dalton, husbandman 1
5019989 2362727 2362727 defendant Lokkesley Richard husbandman 611978 611978 Lokkesley, Richard, of Dalton, husbandman 2
5047247 2370799 2370799 defendant Gybes William husbandman 611978 611978 Gybes, William, of Dalton, husbandman 1
5047248 2370799 2370799 defendant Gybes Ralph husbandman 611978 611978 Gybes, Ralph, of Dalton, husbandman 2
5074071 2378737 2378737 defendant Whitehede John laborer 611978 611978 Whitehede, John, of Dalton, laborer 0
5295380 2443638 2443638 defendant Atkynson Thomas husbandman 611978 611978 Atkynson, Thomas, of Dalton, husbandman 20
5389828 2472153 2472153 defendant North John yeoman 611978 611978 North, John, of Dalton, yeoman 1
5393874 2473310 2473310 defendant Asser Henry husbandman 611978 611978 Asser, Henry, of Dalton, husbandman 2
5426688 2482928 2482928 defendant Dalton Richard gent 611978 611978 Dalton, Richard, of Dalton, gent 0
5478090 2498472 2498472 defendant Dalton Richard, junior yeoman 611978 611978 Dalton, Richard, junior, of Dalton, yeoman 1
5604873 2536393 2536393 defendant Lonley Thomas gent 611978 611978 Lonley, Thomas, of Dalton, gent 0
5606719 2536980 2536980 defendant Wales William husbandman 611978 611978 Wales, William, of Dalton, husbandman 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);