names

70 rows where place_id = 598161

✎ 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
3631406 1904635 1904635 defendant Hante or Haute Thomas husbandman 598161 598161 Hante or Haute, Thomas, of Clyffe, husbandman 0
3631407 1904635 1904635 defendant Kyng William husbandman 598161 598161 Kyng, William, of Clyffe, husbandman 1
3656539 1912298 1912298 defendant Wower Robert husbandman 598161 598161 Wower, Robert, of Clyffe, husbandman 0
3662032 1914059 1914059 defendant Mugge Thomas husbandman 598161 598161 Mugge, Thomas, of Clyffe, husbandman 0
3678331 1919276 1919276 defendant Rolff Richard husbandman 598161 598161 Rolff, Richard, of Clyffe, husbandman 1
3678729 1919414 1919414 defendant Shorte Thomas husbandman 598161 598161 Shorte, Thomas, of Clyffe, husbandman 2
3702750 1927131 1927131 defendant Ussher Thomas husbandman 598161 598161 Ussher, Thomas, of Clyffe, husbandman 1
3702751 1927131 1927131 defendant Rug Richard husbandman 598161 598161 Rug, Richard, of Clyffe, husbandman 2
3702754 1927132 1927132 defendant Ussher Thomas husbandman 598161 598161 Ussher, Thomas, of Clyffe, husbandman 1
3702755 1927132 1927132 defendant Rug Richard husbandman 598161 598161 Rug, Richard, of Clyffe, husbandman 2
3704611 1927731 1927731 defendant Darland William husbandman 598161 598161 Darland, William, of Clyffe, husbandman 0
3707413 1928611 1928611 defendant Bowley Thomas husbandman 598161 598161 Bowley, Thomas, of Clyffe, husbandman 0
3707414 1928611 1928611 defendant Powlyn Richard husbandman 598161 598161 Powlyn, Richard, of Clyffe, husbandman 1
3707990 1928793 1928793 defendant Mugge Thomas husbandman 598161 598161 Mugge, Thomas, of Clyffe, husbandman 2
3707991 1928793 1928793 defendant Darland William husbandman 598161 598161 Darland, William, of Clyffe, husbandman 3
3721556 1933047 1933047 defendant Doley Thomas husbandman 598161 598161 Doley, Thomas, of Clyffe, husbandman 0
3721557 1933047 1933047 defendant Poleyn Richard husbandman 598161 598161 Poleyn, Richard, of Clyffe, husbandman 1
3765405 1946841 1946841 defendant Rocheford John carpenter 598161 598161 Rocheford, John, of Clyffe, carpenter 3
3783449 1952572 1952572 defendant Rocheford John carpenter 598161 598161 Rocheford, John, of Clyffe, carpenter 1
3787429 1953861 1953861 defendant Ryse William husbandman 598161 598161 Ryse, William, of Clyffe, husbandman 0
3787430 1953861 1953861 defendant London Thomas husbandman 598161 598161 London, Thomas, of Clyffe, husbandman 1
3837664 1969691 1969691 defendant Stable Elizabeth widow 598161 598161 Stable, Elizabeth, of Clyffe, widow 1
3837667 1969691 1969691 defendant Thomasson Richard, junior husbandman 598161 598161 Thomasson, Richard, junior, of Clyffe, husbandman 4
3864877 1978454 1978454 defendant Rugge John husbandman 598161 598161 Rugge, John, of Clyffe, husbandman 2
3897232 1989291 1989291 defendant Parkyn Robert husbandman 598161 598161 Parkyn, Robert, of Clyffe, husbandman 3
4018942 2031510 2031510 defendant Borne John husbandman 598161 598161 Borne, John, of Clyffe, husbandman 0
4045355 2040792 2040792 defendant Brasebrydge Anticulus gent 598161 598161 Brasebrydge, Anticulus, of Clyffe, gent 0
4143867 2076018 2076018 defendant Constable Marmaduke esq 598161 598161 Constable, Marmaduke, of Clyffe, esq 1
4144231 2076140 2076140 defendant Constable Marmaduke esq 598161 598161 Constable, Marmaduke, of Clyffe, esq 2
4174307 2086476 2086476 defendant Ashlay William gent 598161 598161 Ashlay, William, of Clyffe, gent 0
4224315 2103989 2103989 defendant Churche Henry husbandman 598161 598161 Churche, Henry, of Clyffe, husbandman 0
4225773 2104479 2104479 defendant Wolnoe Thomas butcher 598161 598161 Wolnoe, Thomas, of Clyffe, butcher 0
4237010 2108525 2108525 defendant James Thomas (legal representative) 598161 598161 James, Thomas, of Clyffe, gent, executor of 1
4237011 2108525 2108525 defendant James Thomas gent 598161 598161 James, Thomas, of Clyffe, gent 2
4308403 2133093 2133093 defendant James Thomas gent 598161 598161 James, Thomas, of Clyffe, gent 1
4309300 2133408 2133408 defendant Blake Thomas smith 598161 598161 Blake, Thomas, of Clyffe, smith 0
4323624 2138317 2138317 defendant Pycknoll Thomas victualer 598161 598161 Pycknoll, Thomas, of Clyffe, victualer 0
4323625 2138317 2138317 defendant Dave John victualer 598161 598161 Dave, John, of Clyffe, victualer 1
4409027 2167623 2167623 defendant Ashley William yeoman 598161 598161 Ashley, William, of Clyffe, yeoman 0
4457961 2187510 2187510 defendant Jesop Michael   598161 598161 Jesop, Michael, of Clyffe, parchment maker 0
4485216 2196080 2196080 plaintiff Pulter William   598161 598161 Pulter, William, of Clyffe 0
4559708 2218991 2218991 defendant Soore Henry   598161 598161 Soore, Henry, of Clyffe 0
4637978 2242641 2242641 defendant Clifford Richard   598161 598161 Clifford, Richard, of Clyffe, parson & formerly prebendary of Keton 0
4771848 2287172 2287172 defendant Barker Thomas husbandman 598161 598161 Barker, Thomas, of Clyffe, husbandman 0
4771849 2287172 2287172 defendant Clerkson John husbandman 598161 598161 Clerkson, John, of Clyffe, husbandman 1
4989455 2353781 2353781 defendant Wardrop Robert   598161 598161 Wardrop, Robert, of Clyffe 4
4995141 2355400 2355400 defendant Wardrop Robert   598161 598161 Wardrop, Robert, of Clyffe 4
5002179 2357541 2357541 defendant Wardrop Robert   598161 598161 Wardrop, Robert, of Clyffe 4
5003790 2357998 2357998 defendant Wardrop Robert   598161 598161 Wardrop, Robert, of Clyffe 4
5004870 2358322 2358322 defendant Wardrop Robert   598161 598161 Wardrop, Robert, of Clyffe 4
5238228 2426764 2426764 defendant Swette John husbandman 598161 598161 Swette, John, of Clyffe, husbandman 0
5271301 2436699 2436699 defendant Godesall Robert laborer 598161 598161 Godesall, Robert, of Clyffe, laborer 4
5274791 2437705 2437705 defendant Baxster John husbandman 598161 598161 Baxster, John, of Clyffe, husbandman 2
5348967 2459810 2459810 defendant Godfray Richard yeoman 598161 598161 Godfray, Richard, of Clyffe, yeoman 3
5369922 2466184 2466184 defendant Paget Robert husbandman 598161 598161 Paget, Robert, of Clyffe, husbandman 0
5456747 2491939 2491939 defendant Hertyll John husbandman 598161 598161 Hertyll, John, of Clyffe, husbandman 6
5468652 2495560 2495560 defendant Hertyll John husbandman 598161 598161 Hertyll, John, of Clyffe, husbandman 6
5472306 2496686 2496686 defendant Hawet William husbandman 598161 598161 Hawet, William, of Clyffe, husbandman 0
5472307 2496686 2496686 defendant Kyng Henry husbandman 598161 598161 Kyng, Henry, of Clyffe, husbandman 1
5501690 2505459 2505459 defendant Hawet William husbandman 598161 598161 Hawet, William, of Clyffe, husbandman 1
5530566 2514077 2514077 defendant Gylle William husbandman 598161 598161 Gylle, William, of Clyffe, husbandman 1
5530568 2514077 2514077 defendant Parmenter John husbandman 598161 598161 Parmenter, John, of Clyffe, husbandman 3
5538611 2516558 2516558 defendant Peryot Thomas husbandman 598161 598161 Peryot, Thomas, of Clyffe, husbandman 1
5538612 2516558 2516558 defendant Smyth John husbandman 598161 598161 Smyth, John, of Clyffe, husbandman 2
5571397 2526189 2526189 defendant Lenger Thomas pulter 598161 598161 Lenger, Thomas, of Clyffe, pulter 0
5571404 2526189 2526189 defendant Elyson Margaret widow 598161 598161 Elyson, Margaret, of Clyffe, widow 7
5575496 2527428 2527428 defendant Ellynson John husbandman 598161 598161 Ellynson, John, of Clyffe, husbandman 2
5595949 2533642 2533642 defendant Baugh Thomas husbandman 598161 598161 Baugh, Thomas, of Clyffe, husbandman 1
5602201 2535587 2535587 defendant Rolf Richard husbandman 598161 598161 Rolf, Richard, of Clyffe, husbandman 3
5602202 2535587 2535587 defendant Broun Richard husbandman 598161 598161 Broun, Richard, of Clyffe, husbandman 4

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