names

656 rows where place_id = 588071

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593268 1865528 1865528 defendant Thomson Gilbert rippier 588071 588071 Thomson, Gilbert, of Multon, rippier 0
3593269 1865528 1865528 defendant Gery Thomas husbandman 588071 588071 Gery, Thomas, of Multon, husbandman 1
3593270 1865528 1865528 defendant Haryson Thomas husbandman 588071 588071 Haryson, Thomas, of Multon, husbandman 2
3593500 1865600 1865600 defendant Herryson John yeoman 588071 588071 Herryson, John, of Multon, yeoman 0
3604546 1869086 1869086 defendant Tomson John husbandman 588071 588071 Tomson, John, of Multon, husbandman 3
3608574 1870339 1870339 defendant Davy John husbandman 588071 588071 Davy, John, of Multon, husbandman 0
3608576 1870340 1870340 defendant Davy John husbandman 588071 588071 Davy, John, of Multon, husbandman 0
3608995 1870470 1870470 defendant Hyll Robert husbandman 588071 588071 Hyll, Robert, of Multon, husbandman 1
3611943 1871397 1871397 defendant Lenot Robert   588071 588071 Lenot, Robert, of Multon, shepherd 0
3615303 1872432 1872432 defendant Nycoll Richard yeoman 588071 588071 Nycoll, Richard, of Multon, yeoman 0
3615306 1872432 1872432 defendant Tomson John husbandman 588071 588071 Tomson, John, of Multon, husbandman 3
3616438 1872778 1872778 defendant Hyllyng Roger barker 588071 588071 Hyllyng, Roger, of Multon, barker 0
3618408 1873391 1873391 defendant Kebby William gent 588071 588071 Kebby, William, of Multon, gent 1
3621793 1874355 1874355 defendant Broun William, senior husbandman 588071 588071 Broun, William, senior, of Multon, husbandman 0
3632489 1904981 1904981 defendant Roger Robert, junior laborer 588071 588071 Roger, Robert, junior, of Multon, laborer 0
3632509 1904987 1904987 defendant Gefferey John husbandman 588071 588071 Gefferey, John, of Multon, husbandman 0
3632510 1904987 1904987 defendant Parfey alias Couper Brian husbandman 588071 588071 Parfey alias Couper, Brian, of Multon, husbandman 1
3632511 1904987 1904987 defendant Poley George gent 588071 588071 Poley, George, of Multon, gent 2
3641349 1907747 1907747 defendant Hell William husbandman 588071 588071 Hell, William, of Multon, husbandman 1
3663093 1914367 1914367 defendant Kyndesy John weaver 588071 588071 Kyndesy, John, of Multon, weaver 0
3666723 1915536 1915536 defendant Palmer Henry gent 588071 588071 Palmer, Henry, of Multon, gent 0
3681436 1920282 1920282 defendant Drove or Dove John husbandman 588071 588071 Drove or Dove, John, of Multon, husbandman 0
3687097 1922135 1922135 defendant Goye Thomas husbandman 588071 588071 Goye, Thomas, of Multon, husbandman 0
3690103 1923067 1923067 defendant Kytson Robert chaplain 588071 588071 Kytson, Robert, of Multon, chaplain 2
3695987 1924985 1924985 plaintiff Roo John husbandman 588071 588071 Roo, John, of Multon, husbandman 0
3700295 1926330 1926330 defendant White Robert   588071 588071 White, Robert, of Multon, cartwright 0
3700642 1926448 1926448 defendant Tomson Richard husbandman 588071 588071 Tomson, Richard, of Multon, husbandman 0
3703424 1927346 1927346 defendant Sewall Richard husbandman 588071 588071 Sewall, Richard, of Multon, husbandman 0
3707737 1928715 1928715 defendant Everard William laborer 588071 588071 Everard, William, of Multon, laborer 1
3712399 1930195 1930195 defendant Bonde William clerk 588071 588071 Bonde, William, of Multon, clerk 0
3717258 1931682 1931682 defendant Newdyke Robert husbandman 588071 588071 Newdyke, Robert, of Multon, husbandman 1
3717259 1931682 1931682 defendant Rowold William   588071 588071 Rowold, William, of Multon, salt weller 2
3720375 1932652 1932652 defendant Bonde William clerk 588071 588071 Bonde, William, of Multon, clerk 0
3721093 1932894 1932894 defendant Reve Thomas gent 588071 588071 Reve, Thomas, of Multon, gent 0
3724682 1934004 1934004 defendant Reve Thomas gent 588071 588071 Reve, Thomas, of Multon, gent 0
3725615 1934300 1934300 defendant Smyth John gent 588071 588071 Smyth, John, of Multon, gent 1
3725648 1934311 1934311 defendant Benson John yeoman 588071 588071 Benson, John, of Multon, yeoman 0
3725783 1934351 1934351 defendant Mason John butcher 588071 588071 Mason, John, of Multon, butcher 0
3726414 1934528 1934528 defendant Trace George gent 588071 588071 Trace, George, of Multon, gent 1
3726417 1934529 1934529 defendant Trace George gent 588071 588071 Trace, George, of Multon, gent 1
3731427 1936053 1936053 defendant Dalton William miller 588071 588071 Dalton, William, of Multon, miller 0
3742155 1939412 1939412 defendant Trace George gent 588071 588071 Trace, George, of Multon, gent 1
3748490 1941461 1941461 defendant Reve Thomas courtholder 588071 588071 Reve, Thomas, of Multon, courtholder 0
3760720 1945352 1945352 defendant Symson Robert husbandman 588071 588071 Symson, Robert, of Multon, husbandman 0
3769008 1947955 1947955 defendant Tymberland John husbandman 588071 588071 Tymberland, John, of Multon, husbandman 0
3770747 1948538 1948538 defendant Harbottell Ralph gent 588071 588071 Harbottell, Ralph, of Multon, gent 0
3775602 1950115 1950115 defendant Marshe Geoffrey husbandman 588071 588071 Marshe, Geoffrey, of Multon, husbandman 0
3776946 1950533 1950533 defendant Balke William weaver 588071 588071 Balke, William, of Multon, weaver 0
3777670 1950764 1950764 defendant Appotte alias Potte John yeoman 588071 588071 Appotte alias Potte, John, of Multon, yeoman 0
3777676 1950765 1950765 defendant Apotte alias Potte John yeoman 588071 588071 Apotte alias Potte, John, of Multon, yeoman 2
3778665 1951040 1951040 defendant Wattys Richard husbandman 588071 588071 Wattys, Richard, of Multon, husbandman 0
3780779 1951724 1951724 defendant Button John husbandman 588071 588071 Button, John, of Multon, husbandman 0
3786198 1953477 1953477 defendant White Simon husbandman 588071 588071 White, Simon, of Multon, husbandman 0
3786199 1953477 1953477 defendant Mason John husbandman 588071 588071 Mason, John, of Multon, husbandman 1
3788118 1954077 1954077 defendant Benett Robert tailor 588071 588071 Benett, Robert, of Multon, tailor 0
3797568 1957135 1957135 defendant Button John husbandman 588071 588071 Button, John, of Multon, husbandman 0
3802878 1958797 1958797 defendant Peycoke Richard yeoman 588071 588071 Peycoke, Richard, of Multon, yeoman 0
3807556 1960272 1960272 plaintiff Pott John yeoman 588071 588071 Pott, John, of Multon, yeoman 1
3807561 1960273 1960273 plaintiff Pott John yeoman 588071 588071 Pott, John, of Multon, yeoman 1
3812423 1961776 1961776 defendant Huggen John husbandman 588071 588071 Huggen, John, of Multon, husbandman 0
3824453 1965518 1965518 defendant Smyth John yeoman 588071 588071 Smyth, John, of Multon, yeoman 0
3829351 1967068 1967068 defendant (not given) William rector of Bonde 588071 588071 Bonde, William, of Multon, rector of Ulceby 0
3832228 1967992 1967992 defendant Boll Richard husbandman 588071 588071 Boll, Richard, of Multon, husbandman 0
3835264 1968968 1968968 defendant Holt Thomas yeoman 588071 588071 Holt, Thomas, of Multon, yeoman 0
3837528 1969647 1969647 defendant Lomes John thatcher 588071 588071 Lomes, John, of Multon, thatcher 0
3837529 1969647 1969647 defendant Pykeryng Thomas thatcher 588071 588071 Pykeryng, Thomas, of Multon, thatcher 1
3840497 1970587 1970587 defendant Cutt John husbandman 588071 588071 Cutt, John, of Multon, husbandman 4
3842960 1971334 1971334 defendant White alias Tynyet Simon husbandman 588071 588071 White alias Tynyet, Simon, of Multon, husbandman 3
3843443 1971486 1971486 defendant Reve Thomas gent 588071 588071 Reve, Thomas, of Multon, gent 0
3846104 1972340 1972340 defendant Leche John, senior husbandman 588071 588071 Leche, John, senior, of Multon, husbandman 0
3848184 1972999 1972999 plaintiff Howlett Nicholas (legal representative) 588071 588071 Howlett, Nicholas, of Multon, executors of 0
3852070 1974240 1974240 defendant Coke Robert husbandman 588071 588071 Coke, Robert, of Multon, husbandman 0
3852072 1974241 1974241 defendant Walker John yeoman 588071 588071 Walker, John, of Multon, yeoman 0
3855684 1975415 1975415 defendant Hall Randolph gent 588071 588071 Hall, Randolph, of Multon, gent 1
3859258 1976590 1976590 defendant Clerke John laborer 588071 588071 Clerke, John, of Multon, laborer 0
3862370 1977605 1977605 defendant Broun John carpenter 588071 588071 Broun, John, of Multon, carpenter 0
3862447 1977634 1977634 defendant Leche John husbandman 588071 588071 Leche, John, of Multon, husbandman 3
3863315 1977926 1977926 plaintiff Howlett Nicholas (legal representative) 588071 588071 Howlett, Nicholas, of Multon, executors of 0
3867861 1979483 1979483 defendant Leche John husbandman 588071 588071 Leche, John, of Multon, husbandman 0
3867868 1979486 1979486 defendant Leche John husbandman 588071 588071 Leche, John, of Multon, husbandman 0
3873285 1981282 1981282 defendant Turnour Marion widow 588071 588071 Turnour, Marion, of Multon, widow 1
3873835 1981468 1981468 defendant Broun Robert butcher 588071 588071 Broun, Robert, of Multon, butcher 1
3880741 1983824 1983824 defendant Broun Robert husbandman 588071 588071 Broun, Robert, of Multon, husbandman 1
3881029 1983924 1983924 defendant Colyorde John husbandman 588071 588071 Colyorde, John, of Multon, husbandman 1
3889027 1986569 1986569 defendant Abrey John yeoman 588071 588071 Abrey, John, of Multon, yeoman 0
3893884 1988177 1988177 defendant Nicoll John husbandman 588071 588071 Nicoll, John, of Multon, husbandman 1
3896651 1989090 1989090 defendant Mercer William husbandman 588071 588071 Mercer, William, of of Multon, husbandman 3
3898283 1989635 1989635 defendant Sherwyn Robert   588071 588071 Sherwyn, Robert, of Multon, wheelwright 2
3900410 1990369 1990369 defendant Sherwyn Robert   588071 588071 Sherwyn, Robert, of Multon, wheelwright 1
3908830 1993247 1993247 defendant Browne Adam husbandman 588071 588071 Browne, Adam, of Multon, husbandman 0
3908831 1993247 1993247 defendant Hode William husbandman 588071 588071 Hode, William, of Multon, husbandman 1
3908833 1993248 1993248 defendant Browne Adam husbandman 588071 588071 Browne, Adam, of Multon, husbandman 0
3908834 1993248 1993248 defendant Hoode William husbandman 588071 588071 Hoode, William, of Multon, husbandman 1
3913953 1995013 1995013 defendant Wolsey William yeoman 588071 588071 Wolsey, William, of Multon, yeoman 0
3914826 1995306 1995306 defendant Broun Robert butcher 588071 588071 Broun, Robert, of Multon, butcher 0
3915312 1995488 1995488 defendant Leche John, junior husbandman 588071 588071 Leche, John, junior, of Multon, husbandman 0
3918854 1996628 1996628 plaintiff Irby Thomas   588071 588071 Irby, Thomas, of Multon 0
3920228 1997104 1997104 defendant Martyns alias Wellys Thomas chaplain 588071 588071 Martyns alias Wellys, Thomas, of Multon, chaplain 0
3920230 1997104 1997104 defendant Goche Nicholas carpenter 588071 588071 Goche, Nicholas, of Multon, carpenter 2
3921896 1997669 1997669 defendant Shepard John gent 588071 588071 Shepard, John, of Multon, gent 0

Next page

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