names

158 rows where place_id = 588384

✎ 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
3594313 1865853 1865853 defendant Barton Thomas butcher 588384 588384 Barton, Thomas, of Barton on Humber, Lincs, butcher 5
3594892 1866031 1866031 defendant God Robert yeoman 588384 588384 (God, Robert, of Barton on Humber, Lincs, yeoman 1
3594898 1866032 1866032 defendant Ferybe John yeoman 588384 588384 (Ferybe, John, of Barton on Humber, Lincs, yeoman 1
3643152 1908297 1908297 defendant Bryan Walter gent 588384 588384 (Bryan, Walter, of Barton on Humber, Lincs, gent 1
3715380 1931095 1931095 plaintiff Bryon Thomas gent 588384 588384 Bryon, Thomas, of Barton on Humber, Lincs, gent 0
3750930 1942215 1942215 defendant Brian Thomas   588384 588384 Brian, Thomas, of Barton on Humber, Lincs, gent, son of Walter Brian 0
3771351 1948731 1948731 defendant Hynde Edward gent 588384 588384 Hynde, Edward, of Barton on Humber, Lincs, gent 0
3776322 1950341 1950341 defendant Thomas James tanner 588384 588384 (Thomas, James, of Barton on Humber, Lincs, tanner 1
3784685 1952997 1952997 defendant Brian Thomas gent 588384 588384 Brian, Thomas, of Barton on Humber, Lincs, gent 0
3784689 1952998 1952998 defendant Brian Thomas Walter 588384 588384 Brian, Thomas, of Barton on Humber, Lincs, gent, son of Brian, Walter 0
3788979 1954364 1954364 defendant Hynd Edward gent 588384 588384 Hynd, Edward, of Barton on Humber, Lincs, gent 0
3812625 1961837 1961837 defendant Brian Thomas gent 588384 588384 Brian, Thomas, of Barton on Humber, Lincs, gent 0
3827842 1966573 1966573 plaintiff Bryan Thomas gent 588384 588384 Bryan, Thomas, of Barton on Humber, Lincs, gent 0
3851335 1974016 1974016 defendant Bryan Thomas gent 588384 588384 Bryan, Thomas, of Barton on Humber, Lincs, gent 0
3865998 1978862 1978862 defendant Bryan Thomas gent 588384 588384 Bryan, Thomas, of Barton on Humber, Lincs, gent 0
3894635 1988413 1988413 defendant Atkyn William   588384 588384 Atkyn, William, of Barton on Humber, Lincs, administrators of 0
3900169 1990281 1990281 plaintiff Bryan Thomas (legal representative) 588384 588384 Bryan, Thomas, of Barton on Humber, Lincs, gent, executrix of 0
3929121 2000077 2000077 defendant Stevynson Robert butcher 588384 588384 Stevynson, Robert, of Barton upon Humber, Lincs, butcher 1
3947461 2006184 2006184 defendant Well William husbandman 588384 588384 Well, William, of Barton on Humber, Lincs, husbandman 1
3964587 2012217 2012217 plaintiff Atkynson Hugh merchant 588384 588384 Atkynson, Hugh, of Barton on Humber, Lincs, merchant 0
3967935 2013414 2013414 defendant Bradford Robert gent 588384 588384 Bradford, Robert, of Barton on Humber, Lincs, gent 0
4012809 2029302 2029302 defendant Kendaule Brian blacksmith 588384 588384 Kendaule, Brian, of Barton on Humber, Lincs, blacksmith 0
4012817 2029306 2029306 defendant Couke Roland mercer 588384 588384 Couke, Roland, of Barton on Humber, Lincs, mercer 0
4022716 2032847 2032847 defendant Browne George gent 588384 588384 Browne, George, of Barton on Humber, Lincs, gent 0
4022720 2032848 2032848 defendant Browne George gent 588384 588384 Browne, George, of Barton on Humber, Lincs, gent 0
4046727 2041282 2041282 defendant Browne George yeoman 588384 588384 Browne, George, of Barton, Lincs, yeoman 0
4061256 2046432 2046432 defendant Addyson James yeoman 588384 588384 Addyson, James, of Barton on Humber, Lincs, yeoman 0
4064162 2047456 2047456 defendant Clarke William husbandman 588384 588384 Clarke, William, of Barton on Humber, Lincs, husbandman 6
4071747 2050194 2050194 plaintiff Nelson William gent 588384 588384 Nelson, William, of Barton, Lincs, gent 0
4072870 2050592 2050592 defendant Everingham Henry gent 588384 588384 Everingham, Henry, of Barton on Humber, Lincs, gent 1
4073134 2050683 2050683 defendant Clarke William gent 588384 588384 Clarke, William, of Barton on Humber, Lincs, gent 1
4076764 2051977 2051977 defendant Etherington Henry gent 588384 588384 Etherington, Henry, of Barton on Humber, Lincs, gent 1
4167662 2084186 2084186 defendant Everingham Henry gent 588384 588384 Everingham, Henry, of Barton on Humber, Lincs, gent 0
4185479 2090430 2090430 defendant Hopkynson Thomas gent 588384 588384 Hopkynson, Thomas, of Barton on Humber, Lincs, gent 0
4195590 2094007 2094007 defendant Cooke Roland mercer 588384 588384 Cooke, Roland, of Barton on Humber, Lincs, mercer 0
4229256 2105715 2105715 defendant Swan John draper 588384 588384 Swan, John, of Barton on Humber, Lincs, draper 0
4261943 2116946 2116946 defendant Everingham Henry esq 588384 588384 Everingham, Henry, of Barton on Humber, Lincs, esq 0
4262252 2117045 2117045 defendant Fearclough Richard gent 588384 588384 Fearclough, Richard, of Barton on Humber, Lincs, gent 0
4281474 2123423 2123423 defendant Trippe Edward yeoman 588384 588384 Trippe, Edward, of Barton on Humber, Lincs, yeoman 0
4300121 2130141 2130141 defendant Cooke Roland chapman 588384 588384 Cooke, Roland, of Barton on Humber, Lincs, chapman 0
4306216 2132312 2132312 defendant Bossall Robert (legal representative) 588384 588384 Bossall, Robert, of Barton on Humber, Lincs, yeoman, administratrix of 0
4307523 2132769 2132769 defendant Everingham Henry esq 588384 588384 Everingham, Henry, of Barton on Humber, Lincs, esq 0
4310878 2133953 2133953 defendant Anderson Henry gent 588384 588384 Anderson, Henry, of Barton, Lincs, gent 0
4314936 2135334 2135334 defendant Everingham Henry esq 588384 588384 Everingham, Henry, of Barton, Lincs, esq 0
4321057 2137461 2137461 defendant Everingham Henry esq 588384 588384 Everingham, Henry, of Barton on Humber, Lincs, esq 0
4333618 2141526 2141526 defendant Cooke Roland chapman 588384 588384 Cooke, Roland, of Barton on Humber, Lincs, chapman 0
4382085 2158694 2158694 defendant Rocklyffe Philip yeoman 588384 588384 Rocklyffe, Philip, of Barton on Humber, Lincs, yeoman 0
4387899 2160585 2160585 defendant Farclowe or Fayrcloughe Richard clothworker 588384 588384 Farclowe or Fayrcloughe, Richard, of Barton on Humber, Lincs, clothworker 0
4398340 2164026 2164026 defendant Everingham Henry esq 588384 588384 Everingham, Henry, of Barton on Humber, Lincs, esq 0
4406567 2166761 2166761 defendant Rooklif Philip yeoman 588384 588384 Rooklif, Philip, of Barton, Lincs, yeoman 0
4406569 2166762 2166762 defendant Swanne John yeoman 588384 588384 Swanne, John, of Barton, Lincs, yeoman 0
4407034 2166910 2166910 defendant Bossell Hugh yeoman 588384 588384 Bossell, Hugh, of Barton on Humber, Lincs, yeoman 0
4562527 2219839 2219839 defendant Barnabe John esq 588384 588384 Barnabe, John, of Barton on Humber, Lincs, esq 0
4578993 2224911 2224911 defendant Bargan William   588384 588384 Bargan, William, of Barton, Lincs 2
4655114 2247483 2247483 defendant Glover John yeoman 588384 588384 Glover, John, of Barton, Lincs, yeoman 0
4655119 2247484 2247484 defendant Glover John yeoman 588384 588384 Glover, John, of Barton, Lincs, yeoman 0
4657177 2248131 2248131 defendant Keelby Richard goldsmith 588384 588384 Keelby, Richard, of Barton, Lincs, goldsmith 0
4669363 2256126 2256126 defendant Norton William yeoman 588384 588384 Norton, William, of Barton on Humber, Lincs, yeoman 1
4669706 2256226 2256226 defendant Sutton John glover 588384 588384 Sutton, John, of Barton on Humber, Lincs, glover 0
4675101 2257825 2257825 defendant Bernaby John, senior esq 588384 588384 Bernaby, John, senior, of Barton on Humber, Lincs, esq 0
4685832 2261160 2261160 defendant Holme John husbandman 588384 588384 Holme, John, of Barton, Lincs, husbandman 3
4694582 2263801 2263801 defendant Norton William   588384 588384 Norton, William, of Barton on Humber, Lincs, yeoman, formerly of Hoveden 0
4719954 2271587 2271587 defendant Weston Robert dyer 588384 588384 Weston, Robert, of Barton on Humber, Lincs, dyer 2
4721443 2272039 2272039 defendant Holme John de vintner 588384 588384 Holme, John de, of Barton on Humber, Lincs, formerly of Hull, vintner 0
4738198 2277044 2277044 defendant Fulstowe Richard husbandman 588384 588384 Fulstowe, Richard, of Barton, Lincs, husbandman 2
4742534 2278317 2278317 defendant Holme John de vintner 588384 588384 Holme, John de, of Barton upon Humber, Lincs, formerly of Hull, vintner 0
4750112 2280505 2280505 defendant Proktur Robert gent 588384 588384 Proktur, Robert, of Barton, Lincs, gent 0
4755948 2282242 2282242 defendant Feriby Robert gent 588384 588384 Feriby, Robert, of Barton on Humber, Lincs, gent 0
4757516 2282729 2282729 defendant Holme (illegible) chapman alias merchant of Kyngeston upon Hull 588384 588384 Holme, _, of Barton on Humber, Lincs, chapman alias merchant of Kyngeston upon Hull 0
4769197 2286343 2286343 defendant Holme John gent 588384 588384 Holme, John, of Barton, Lincs, gent 0
4778498 2289252 2289252 defendant Coweper Peter chapman 588384 588384 Coweper, Peter, of Barton on Humber, Lincs, chapman 1
4790893 2293242 2293242 defendant Palmer Thomas chapman 588384 588384 Palmer, Thomas, of Barton, Lincs, chapman 0
4802026 2296818 2296818 defendant Sutton John skinner 588384 588384 Sutton, John, of Barton, Lincs, skinner 3
4811867 2299824 2299824 defendant Blakeburn John, senior shipman 588384 588384 Blakeburn, John, senior, of Barton, Lincs, shipman 2
4813206 2300245 2300245 defendant Burdesall Robert husbandman 588384 588384 Burdesall, Robert, of Barton, on Humber, Lincs, husbandman 1
4814998 2300801 2300801 defendant Howet John peweterer 588384 588384 Howet, John, of Barton, Lincs, peweterer 0
4827282 2304582 2304582 defendant Saltmerssh John chaplain 588384 588384 Saltmerssh, John, of Barton on Humber, Lincs, chaplain 0
4827290 2304583 2304583 defendant Saltmerssh John chaplain 588384 588384 Saltmerssh, John, of Barton on Humber, Lincs, chaplain 0
4840222 2308489 2308489 defendant Palmer Thomas ostler 588384 588384 Palmer, Thomas, of Barton, Lincs, ostler 0
4842107 2309066 2309066 defendant Palmer Thomas yeoman 588384 588384 Palmer, Thomas, of Barton, Lincs, yeoman 0
4842112 2309067 2309067 defendant Palmer Thomas yeoman 588384 588384 Palmer, Thomas, of Barton, Lincs, yeoman 0
4846679 2310470 2310470 defendant Faxflete Richard de yeoman 588384 588384 Faxflete, Richard de, of Barton, Lincs, yeoman 0
4854155 2312709 2312709 defendant Hynde Walter merchant 588384 588384 Hynde, Walter, of Barton, Lincs, merchant 0
4854156 2312709 2312709 defendant Bedale Richard merchant 588384 588384 Bedale, Richard, of Barton, Lincs, merchant 1
4867680 2316861 2316861 defendant Sutton John skinner 588384 588384 Sutton, John, of Barton, Lincs, skinner 1
4872293 2318294 2318294 defendant Palmer Thomas ostler 588384 588384 Palmer, Thomas, of Barton, Lincs, ostler 2
4873195 2318568 2318568 defendant Proktour Robert yeoman 588384 588384 Proktour, Robert, of Barton, Lincs, yeoman 0
4874964 2319117 2319117 defendant Ruston Thomas dyer 588384 588384 Ruston, Thomas, of Barton, Lincs, dyer 5
4875513 2319295 2319295 defendant de Welles Henry shoemaker 588384 588384 de Welles, Henry, of Barton on Humber, Lincs, shoemaker 3
4913291 2330657 2330657 defendant Aulaby Richard gent 588384 588384 Aulaby, Richard, of Barton on Humber, Lincs, gent 0
4927693 2335094 2335094 defendant Lorymer William merchant 588384 588384 Lorymer, William, of Barton, on Humber, Lincs, merchant 0
4986824 2352998 2352998 defendant Hykson Richard mercer 588384 588384 Hykson, Richard, of Barton on Humber, Lincs, mercer 0
5008936 2359508 2359508 defendant Barton Thomas merchant 588384 588384 Barton, Thomas, of Barton on Humber, Lincs, merchant 1
5008938 2359509 2359509 defendant Heweson William dyer 588384 588384 Heweson, William, of Barton on Humber, Lincs, dyer 0
5028839 2365310 2365310 defendant Proktour Robert husbandman 588384 588384 Proktour, Robert, of Barton, Lincs, husbandman 0
5030313 2365737 2365737 defendant Lorymer William merchant 588384 588384 Lorymer, William, of Barton on Humber, Lincs, merchant 0
5050307 2371716 2371716 defendant Aulaby Richard gent 588384 588384 Aulaby, Richard, of Barton on Humber, Lincs, gent 0
5054275 2372862 2372862 defendant Wodson William merchant 588384 588384 Wodson, William, of Barton on Humber, Lincs, merchant 1
5055921 2373338 2373338 defendant Wodson William merchant 588384 588384 Wodson, William, of Barton on Humber, Lincs, merchant 2
5062300 2375286 2375286 defendant Heynd Walter merchant 588384 588384 Heynd, Walter, of Barton on Humber, Lincs, merchant 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);