names

63 rows where place_id = 616005

✎ 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
3711965 1930058 1930058 defendant Pachett Thomas   616005 616005 Pachett, Thomas, of Rotheley 0
3727145 1934761 1934761 defendant Pachett Thomas   616005 616005 Pachett, Thomas, of Rotheley 0
3741979 1939360 1939360 defendant Molle James butcher 616005 616005 Molle, James, of Rotheley, butcher 0
3751549 1942400 1942400 defendant Molle James butcher 616005 616005 Molle, James, of Rotheley, butcher 0
3790047 1954706 1954706 defendant Hakyt John laborer 616005 616005 Hakyt, John, of Rotheley, laborer 5
3804426 1959322 1959322 defendant Olyff or Clyff John   616005 616005 Olyff or Clyff, John, of Rotheley 1
3806190 1959862 1959862 defendant Hakytt John laborer 616005 616005 Hakytt, John, of Rotheley, laborer 4
3806209 1959863 1959863 defendant Hakytt John laborer 616005 616005 Hakytt, John, of Rotheley, laborer 4
3883685 1984813 1984813 defendant Babyngton Humphrey esq 616005 616005 Babyngton, Humphrey, of Rotheley, esq 0
4058209 2045318 2045318 defendant Ithell Robert gent 616005 616005 Ithell, Robert, of Rotheley, gent 0
4429532 2174030 2174030 defendant Uttyngsone John   616005 616005 Uttyngsone, John, of Rotheley 0
4473255 2192297 2192297 defendant Godetyde John   616005 616005 Godetyde, John, of Rotheley 1
4473259 2192298 2192298 defendant Goodtyve John   616005 616005 Goodtyve, John, of Rotheley 1
4482530 2195238 2195238 plaintiff Milner William   616005 616005 Milner, William, of Rotheley 0
4482531 2195238 2195238 defendant Housewyk Richard   616005 616005 Housewyk, Richard, of Rotheley 0
4519662 2206510 2206510 plaintiff Erdburgh Robert de   616005 616005 Erdburgh, Robert de, of Rotheley, vicar 0
4619849 2237185 2237185 plaintiff Hosewyff Richard   616005 616005 Hosewyff, Richard, of Rotheley 0
4640925 2243444 2243444 defendant Wryght John   616005 616005 Wryght, John, of Rotheley 0
4642680 2243974 2243974 defendant Smyth John   616005 616005 Smyth, John, of Rotheley 2
4673437 2257329 2257329 defendant Bryggend John de husbandman 616005 616005 Bryggend, John de, of Rotheley, husbandman 2
4715386 2270148 2270148 defendant Milner John miller 616005 616005 Milner, John, of Rotheley, miller 0
4721313 2271997 2271997 defendant Clerk John laborer 616005 616005 Clerk, John, of Rotheley, laborer 0
4724150 2272847 2272847 defendant Colyson William yeoman 616005 616005 Colyson, William, of Rotheley, yeoman 1
4739144 2277334 2277334 defendant Bersham William   616005 616005 Bersham, William, of Rotheley, wright 2
4739146 2277334 2277334 defendant Croft Robert de glover 616005 616005 Croft, Robert de, of Rotheley, glover 4
4754183 2281687 2281687 defendant Bryggende John husbandman 616005 616005 Bryggende, John, of Rotheley, husbandman 0
4754184 2281687 2281687 defendant Wryght John husbandman 616005 616005 Wryght, John, of Rotheley, husbandman 1
4754185 2281687 2281687 defendant Symonde Thomas husbandman 616005 616005 Symonde, Thomas, of Rotheley, husbandman 2
4795887 2294864 2294864 defendant Colynson Richard husbandman 616005 616005 Colynson, Richard, of Rotheley, husbandman 1
4804890 2297733 2297733 defendant Carter Richard butcher 616005 616005 Carter, Richard, of Rotheley, butcher 0
4814224 2300553 2300553 defendant Bygge Roger husbandman 616005 616005 Bygge, Roger, of Rotheley, husbandman 0
4815693 2301012 2301012 defendant Farnham Thomas gent 616005 616005 Farnham, Thomas, of Rotheley, gent 0
4830424 2305550 2305550 defendant Symond Thomas husbandman 616005 616005 Symond, Thomas, of Rotheley, husbandman 2
4836433 2307371 2307371 defendant Smyth John smith 616005 616005 Smyth, John, of Rotheley, smith 1
4851779 2311996 2311996 defendant May John chaplain 616005 616005 May, John, of Rotheley, chaplain 0
4876991 2319775 2319775 defendant Smyth John smith 616005 616005 Smyth, John, of Rotheley, smith 2
4904036 2327878 2327878 defendant Shawe William laborer 616005 616005 Shawe, William, of Rotheley, laborer 0
4970612 2348150 2348150 defendant Fresell Roland yeoman 616005 616005 Fresell, Roland, of Rotheley, yeoman 3
4984985 2352443 2352443 defendant Braunston William   616005 616005 Braunston, William, of Rotheley, wright 1
4985001 2352445 2352445 defendant Braunston William   616005 616005 Braunston, William, of Rotheley, wright 1
5006605 2358830 2358830 defendant Smyth John smith 616005 616005 Smyth, John, of Rotheley, smith 4
5021077 2363058 2363058 defendant Marsshall William yeoman 616005 616005 Marsshall, William, of Rotheley, yeoman 0
5035745 2367310 2367310 defendant Howys John husbandman 616005 616005 Howys, John, of Rotheley, husbandman 3
5035746 2367310 2367310 defendant Moburley Roger husbandman 616005 616005 Moburley, Roger, of Rotheley, husbandman 4
5041027 2368943 2368943 defendant Bayly Robert husbandman 616005 616005 Bayly, Robert, of Rotheley, husbandman 0
5103541 2387461 2387461 defendant Capper Thomas yeoman 616005 616005 Capper, Thomas, of Rotheley, yeoman 0
5112821 2390144 2390144 defendant Howys Thomas husbandman 616005 616005 Howys, Thomas, of Rotheley, husbandman 2
5112826 2390145 2390145 defendant Howys Thomas husbandman 616005 616005 Howys, Thomas, of Rotheley, husbandman 2
5118996 2391992 2391992 defendant Reve Simon husbandman 616005 616005 Reve, Simon, of Rotheley, husbandman 2
5134034 2396451 2396451 plaintiff Kyngeston Ralph esq 616005 616005 Kyngeston, Ralph, of Rotheley, esq 0
5153936 2402310 2402310 plaintiff Kyngeston Ralph esq 616005 616005 Kyngeston, Ralph, of Rotheley, esq 0
5170821 2407187 2407187 defendant Reve Simon husbandman 616005 616005 Reve, Simon, of Rotheley, husbandman 0
5189466 2412659 2412659 plaintiff Kyngeston Ralph esq 616005 616005 Kyngeston, Ralph, of Rotheley, esq 0
5189468 2412660 2412660 plaintiff Kyngeston Ralph esq 616005 616005 Kyngeston, Ralph, of Rotheley, esq 0
5189906 2412790 2412790 defendant Holand John husbandman 616005 616005 Holand, John, of Rotheley, husbandman 0
5189907 2412790 2412790 defendant Reve Simon husbandman 616005 616005 Reve, Simon, of Rotheley, husbandman 1
5247585 2429451 2429451 defendant Were William yeoman 616005 616005 Were, William, of Rotheley, yeoman 2
5289331 2441881 2441881 defendant Kynston Robert gent 616005 616005 Kynston, Robert, of Rotheley, gent 0
5322639 2451851 2451851 defendant Stones John husbandman 616005 616005 Stones, John, of Rotheley, husbandman 0
5345415 2458738 2458738 defendant Stones John yeoman 616005 616005 Stones, John, of Rotheley, yeoman 0
5385305 2470872 2470872 defendant Hillester John yeoman 616005 616005 Hillester, John, of Rotheley, yeoman 4
5397376 2474336 2474336 defendant Hilleston John yeoman 616005 616005 Hilleston, John, of Rotheley, yeoman 4
5488489 2501445 2501445 defendant Kyngston Ralph gent 616005 616005 Kyngston, Ralph, of Rotheley, gent 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);