names

42 rows where place_id = 597261

✎ 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
3627859 1903573 1903573 defendant Fen Thomas husbandman 597261 597261 Fen, Thomas, of Byrlyngham, husbandman 1
3630887 1904480 1904480 defendant Wodwarde William yeoman 597261 597261 Wodwarde, William, of Byrlyngham, yeoman 0
3635481 1905893 1905893 defendant Fyssher Hugh laborer 597261 597261 Fyssher, Hugh, of Byrlyngham, laborer 1
3701777 1926803 1926803 defendant Hogges Christopher yeoman 597261 597261 Hogges, Christopher, of Byrlyngham, yeoman 0
3702711 1927120 1927120 defendant Hoggys Christopher husbandman 597261 597261 Hoggys, Christopher, of Byrlyngham, husbandman 0
3731991 1936236 1936236 defendant Bacheler Thomas husbandman 597261 597261 Bacheler, Thomas, of Byrlyngham, husbandman 9
3731995 1936236 1936236 defendant Rudyng Thomas gent 597261 597261 Rudyng, Thomas, of Byrlyngham, gent 13
3732146 1936290 1936290 defendant Hoggys Christopher yeoman 597261 597261 Hoggys, Christopher, of Byrlyngham, yeoman 1
3741711 1939271 1939271 defendant Bacheler Thomas husbandman 597261 597261 Bacheler, Thomas, of Byrlyngham, husbandman 6
3741714 1939271 1939271 defendant Rudyng Thomas gent 597261 597261 Rudyng, Thomas, of Byrlyngham, gent 9
3746371 1940782 1940782 defendant Butler William tailor 597261 597261 Butler, William, of Byrlyngham, tailor 5
3759556 1944980 1944980 defendant Butler William tailor 597261 597261 Butler, William, of Byrlyngham, tailor 5
3769590 1948149 1948149 defendant Grene Robert husbandman 597261 597261 Grene, Robert, of Byrlyngham St Peter, husbandman 1
3770277 1948373 1948373 defendant Pace Thomas husbandman 597261 597261 Pace, Thomas, of Byrlyngham, husbandman 5
3812441 1961782 1961782 defendant Pate Thomas, junior husbandman 597261 597261 Pate, Thomas, junior, of Byrlyngham, husbandman 0
3816152 1962955 1962955 defendant Hogges Christopher husbandman 597261 597261 Hogges, Christopher, of Byrlyngham, husbandman 0
3822162 1964828 1964828 defendant Hogges Christopher husbandman 597261 597261 Hogges, Christopher, of Byrlyngham, husbandman 0
3853865 1974841 1974841 defendant Coberley Thomas husbandman 597261 597261 Coberley, Thomas, of Byrlyngham, husbandman 0
3857736 1976056 1976056 defendant Hogges Christopher husbandman 597261 597261 Hogges, Christopher, of Byrlyngham, husbandman 1
3871805 1980807 1980807 defendant Hogges Christopher husbandman 597261 597261 Hogges, Christopher, of Byrlyngham, husbandman 0
3874915 1981836 1981836 plaintiff Deynes John   597261 597261 Deynes, John, of Byrlyngham 0
3874917 1981836 1981836 defendant Wytherley Marcia widow 597261 597261 (Wytherley, Marcia, of Byrlyngham St Peter, widow 1
3874918 1981836 1981836 defendant Wytherley John husbandman 597261 597261 Wytherley, John, of Byrlyngham St Peter, husbandman 2
3889788 1986823 1986823 defendant Grynte Thomas husbandman 597261 597261 Grynte, Thomas, of Byrlyngham, husbandman 0
3889789 1986823 1986823 defendant Blake Thomas husbandman 597261 597261 Blake, Thomas, of Byrlyngham, husbandman 1
3927939 1999683 1999683 defendant Shene Martin fisher 597261 597261 Shene, Martin, of Byrlyngham, fisher 0
3927940 1999683 1999683 defendant Shene John fisher 597261 597261 Shene, John, of Byrlyngham, fisher 1
3981760 2018235 2018235 defendant Mason John yeoman 597261 597261 Mason, John, of Byrlyngham, yeoman 2
3981765 2018236 2018236 defendant Mason John yeoman 597261 597261 Mason, John, of Byrlyngham, yeoman 2
4101013 2060678 2060678 defendant More Christopher yeoman 597261 597261 More, Christopher, of Byrlyngham, yeoman 0
4129252 2070762 2070762 defendant Ryches Richard husbandman 597261 597261 Ryches, Richard, of Byrlyngham, husbandman 0
4169134 2084705 2084705 defendant Bate John gent 597261 597261 (Bate, John, of Byrlyngham St Peter, gent 1
4322829 2138053 2138053 defendant Deaves William blacksmith 597261 597261 Deaves, William, of Byrlyngham, blacksmith 0
4322830 2138053 2138053 defendant Palmer Agnes widow 597261 597261 Palmer, Agnes, of Byrlyngham, widow 1
4390499 2161444 2161444 defendant Horwell Thomas esq 597261 597261 Horwell, Thomas, of Byrlyngham, esq 1
4504795 2202040 2202040 defendant Wodeward Thomas   597261 597261 Wodeward, Thomas, of Byrlyngham 0
4504796 2202040 2202040 defendant Harryes John   597261 597261 Harryes, John, of Byrlyngham 1
4504797 2202040 2202040 defendant Lyttelton Thomas   597261 597261 Lyttelton, Thomas, of Byrlyngham, son of John 2
4765197 2285097 2285097 defendant Frensshe Thomas   597261 597261 Frensshe, Thomas, of Byrlyngham, parson 0
4838844 2308079 2308079 defendant Joseph Robert smith 597261 597261 Joseph, Robert, of Byrlyngham, smith 1
5322949 2451938 2451938 defendant Daunce William husbandman 597261 597261 Daunce, William, of Byrlyngham, husbandman 0
5551218 2520386 2520386 defendant Dabitot Thomas husbandman 597261 597261 Dabitot, Thomas, of Byrlyngham, husbandman 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);