names

148 rows where place_id = 589033

✎ 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
3591774 1865048 1865048 plaintiff Fane John (legal representative) 589033 589033 Fane, John, of Tunbrigge, executors of 0
3596330 1866481 1866481 defendant Legge Thomas husbandman 589033 589033 Legge, Thomas, of Tunbrigge, husbandman 0
3597566 1866862 1866862 defendant Bocher John butcher 589033 589033 Bocher, John, of Tunbrigge, butcher 0
3613667 1871921 1871921 defendant Ryng Thomas yeoman 589033 589033 Ryng, Thomas, of Tunbrigge, yeoman 0
3624154 1875084 1875084 defendant Marden Thomas husbandman 589033 589033 Marden, Thomas, of Tunbrigge, husbandman 0
3637776 1906631 1906631 defendant Alyn Edward yeoman 589033 589033 Alyn, Edward, of Tunbrigge, yeoman 0
3637777 1906631 1906631 defendant Latter Thomas yeoman 589033 589033 Latter, Thomas, of Tunbrigge, yeoman 1
3637789 1906637 1906637 defendant Lattar Thomas yeoman 589033 589033 Lattar, Thomas, of Tunbrigge, yeoman 0
3637794 1906639 1906639 defendant Leukenore Richard gent 589033 589033 Leukenore, Richard, of Tunbrigge, gent 0
3638688 1906914 1906914 defendant Wyllard John butcher 589033 589033 Wyllard, John, of Tunbrigge, butcher 0
3644470 1908687 1908687 defendant Latter Thomas yeoman 589033 589033 Latter, Thomas, of Tunbrigge, yeoman 0
3644472 1908688 1908688 defendant Latter Thomas yeoman 589033 589033 Latter, Thomas, of Tunbrigge, yeoman 0
3658130 1912799 1912799 defendant Harry John butcher 589033 589033 Harry, John, of Tunbrigge, butcher 2
3658162 1912808 1912808 defendant Willard John butcher 589033 589033 Willard, John, of Tunbrigge, butcher 0
3673155 1917614 1917614 plaintiff Edward John husbandman 589033 589033 Edward, John, of Tunbrigge, husbandman 0
3673156 1917614 1917614 defendant Blundell Michael (legal representative) 589033 589033 Blundell, Michael, of Tunbrigge, mercer, administratrix of 0
3673157 1917614 1917614 defendant Blundell Elizabeth widow 589033 589033 Blundell, Elizabeth, of Tunbrigge, widow 1
3678860 1919454 1919454 defendant Gotfrey Richard yeoman 589033 589033 Gotfrey, Richard, of Tunbrigge, yeoman 2
3678861 1919454 1919454 defendant Style John yeoman 589033 589033 Style, John, of Tunbrigge, yeoman 3
3680784 1920070 1920070 defendant Skynner John capper 589033 589033 Skynner, John, of Tunbrigge, capper 3
3681009 1920138 1920138 defendant Bowser William yeoman 589033 589033 Bowser, William, of Tunbrigge, yeoman 0
3684359 1921240 1921240 defendant Tomme William husbandman 589033 589033 Tomme, William, of Tunbrigge, husbandman 0
3694699 1924547 1924547 defendant A Chyldren John, senior yeoman 589033 589033 A Chyldren, John, senior, of Tunbrigge, yeoman 0
3694700 1924547 1924547 defendant A Chyldren John, junior yeoman 589033 589033 A Chyldren, John, junior, of Tunbrigge, yeoman 1
3709306 1929209 1929209 defendant Childern John, senior yeoman 589033 589033 Childern, John, senior, of Tunbrigge, yeoman 0
3709307 1929209 1929209 defendant Childern William husbandman 589033 589033 Childern, William, of Tunbrigge, husbandman 1
3714808 1930933 1930933 defendant Willard Richard yeoman 589033 589033 Willard, Richard, of Tunbrigge, yeoman 0
3717983 1931921 1931921 defendant Crudde Thomas butcher 589033 589033 Crudde, Thomas, of Tunbrigge, butcher 1
3724541 1933962 1933962 defendant Harreys Thomas butcher 589033 589033 Harreys, Thomas, of Tunbrigge, butcher 0
3724542 1933962 1933962 defendant Harreys Roger butcher 589033 589033 Harreys, Roger, of Tunbrigge, butcher 1
3724543 1933962 1933962 defendant Harreys Richard sherman 589033 589033 Harreys, Richard, of Tunbrigge, sherman 2
3740640 1938934 1938934 defendant Neve John husbandman 589033 589033 Neve, John, of Tunbrigge, husbandman 2
3769467 1948110 1948110 defendant Latter Thomas, junior yeoman 589033 589033 Latter, Thomas, junior, of Tunbrigge, yeoman 2
3769882 1948235 1948235 defendant Veyse William husbandman 589033 589033 Veyse, William, of Tunbrigge, husbandman 1
3861866 1977427 1977427 defendant Latter Robert husbandman 589033 589033 Latter, Robert, of Tunbrigge, husbandman 0
3887703 1986141 1986141 defendant Harreys Thomas, junior butcher 589033 589033 Harreys, Thomas, junior, of Tunbrigge, butcher 0
3890313 1987006 1987006 defendant Bysshoppe Richard yeoman 589033 589033 Bysshoppe, Richard, of Tunbrigge, yeoman 0
3907431 1992779 1992779 defendant Oxley Edward clothier 589033 589033 Oxley, Edward, of Tunbrigge, clothier 0
3908003 1992969 1992969 defendant Barnard Stephen brewer 589033 589033 Barnard, Stephen, of Tunbrigge, brewer 0
3922339 1997786 1997786 plaintiff Roberdys Anthony gent 589033 589033 Roberdys, Anthony, of Tunbrigge, gent 0
4642411 2243905 2243905 defendant Bisshop John   589033 589033 Bisshop, John, of Tunbrigge 1
4792014 2293608 2293608 plaintiff Mathewe William   589033 589033 Mathewe, William, of Tunbrigge 0
4862579 2315282 2315282 defendant Glover John carpenter 589033 589033 Glover, John, of Tunbrigge, carpenter 0
4891804 2324178 2324178 defendant Kennane or Kennave John glover 589033 589033 Kennane or Kennave, John, of Tunbrigge, glover 3
4897035 2325726 2325726 defendant Barbour John yeoman 589033 589033 (Barbour, John, of Tunbrigge, yeoman 1
4897036 2325726 2325726 defendant Horys Margery widow 589033 589033 Horys, Margery, of Tunbrigge, widow 2
4900304 2326729 2326729 defendant Barbour John yeoman 589033 589033 (Barbour, John, of Tunbrigge, yeoman 1
4900305 2326729 2326729 defendant Horys Margery widow 589033 589033 Horys, Margery, of Tunbrigge, widow 2
4902234 2327308 2327308 defendant Barbour John yeoman 589033 589033 (Barbour, John, of Tunbrigge, yeoman 1
4902235 2327308 2327308 defendant Horys Margery widow 589033 589033 Horys, Margery, of Tunbrigge, widow 2
4924663 2334151 2334151 plaintiff of Vane Henry   589033 589033 of Vane, Henry, of Tunbrigge 0
4951437 2342411 2342411 defendant Holbeme Thomas tailor 589033 589033 Holbeme, Thomas, of Tunbrigge, tailor 0
4953628 2343051 2343051 defendant Holbeme Thomas tailor 589033 589033 Holbeme, Thomas, of Tunbrigge, tailor 0
4966663 2346963 2346963 defendant Godyng John husbandman 589033 589033 Godyng, John, of Tunbrigge, husbandman 0
4966664 2346963 2346963 defendant Frenssheman Robert   589033 589033 Frenssheman, Robert, of Tunbrigge, servant 1
4977601 2350265 2350265 defendant Holbeme Thomas tailor 589033 589033 Holbeme, Thomas, of Tunbrigge, tailor 0
5005641 2358548 2358548 defendant Tiherst Robert butcher 589033 589033 Tiherst, Robert, of Tunbrigge, butcher 2
5032018 2366237 2366237 defendant Tyherst Robert butcher 589033 589033 Tyherst, Robert, of Tunbrigge, butcher 1
5047736 2370939 2370939 defendant Becherd Thomas   589033 589033 Becherd, Thomas, of Tunbrigge, blade smith 0
5047740 2370939 2370939 defendant Herman Thomas smith 589033 589033 Herman, Thomas, of Tunbrigge, smith 4
5048646 2371234 2371234 defendant Tyherst Robert butcher 589033 589033 Tyherst, Robert, of Tunbrigge, butcher 0
5058146 2373998 2373998 defendant Tygherst John husbandman 589033 589033 Tygherst, John, of Tunbrigge, husbandman 3
5062446 2375333 2375333 defendant Barbour John yeoman 589033 589033 Barbour, John, of Tunbrigge, yeoman 0
5141437 2398610 2398610 defendant Grene John   589033 589033 Grene, John, of Tunbrigge, shoe maker 1
5145196 2399737 2399737 defendant Avane John yeoman 589033 589033 Avane, John, of Tunbrigge, yeoman 0
5145197 2399737 2399737 defendant Laurens Nicholas laborer 589033 589033 Laurens, Nicholas, of Tunbrigge, laborer 1
5145198 2399737 2399737 defendant Creke John laborer 589033 589033 Creke, John, of Tunbrigge, laborer 2
5159342 2403848 2403848 defendant Randolfe William   589033 589033 Randolfe, William, of Tunbrigge, park man 0
5183393 2410883 2410883 defendant Tygherst John husbandman 589033 589033 Tygherst, John, of Tunbrigge, husbandman 1
5183395 2410883 2410883 defendant atte Hale John baker 589033 589033 atte Hale, John, of Tunbrigge, baker 3
5183396 2410883 2410883 defendant Cook William   589033 589033 Cook, William, of Tunbrigge, shoe maker 4
5194203 2414035 2414035 defendant Sprever John butcher 589033 589033 Sprever, John, of Tunbrigge, butcher 1
5213609 2419715 2419715 defendant A Vane John yeoman 589033 589033 A Vane, John, of Tunbrigge, yeoman 0
5213610 2419715 2419715 defendant Laurence Nicholas laborer 589033 589033 Laurence, Nicholas, of Tunbrigge, laborer 1
5213611 2419715 2419715 defendant Creke John laborer 589033 589033 Creke, John, of Tunbrigge, laborer 2
5216792 2420651 2420651 defendant Laurence Nicholas laborer 589033 589033 Laurence, Nicholas, of Tunbrigge, laborer 3
5217528 2420863 2420863 defendant Borner Robert yeoman 589033 589033 Borner, Robert, of Tunbrigge, yeoman 2
5226413 2423389 2423389 defendant Riche Robert   589033 589033 Riche, Robert, of Tunbrigge, bailiff 0
5226414 2423389 2423389 defendant Randolf William husbandman 589033 589033 Randolf, William, of Tunbrigge, husbandman 1
5226415 2423389 2423389 defendant Nutworth Richard parker 589033 589033 Nutworth, Richard, of Tunbrigge, parker 2
5231015 2424671 2424671 defendant Broke John husbandman 589033 589033 Broke, John, of Tunbrigge, husbandman 0
5235857 2426067 2426067 defendant Polly John husbandman 589033 589033 Polly, John, of Tunbrigge, husbandman 0
5238349 2426803 2426803 defendant Goldsmith William skinner 589033 589033 Goldsmith, William, of Tunbrigge, skinner 3
5247714 2429481 2429481 defendant Ryche Robert yeoman 589033 589033 Ryche, Robert, of Tunbrigge, yeoman 2
5247720 2429482 2429482 defendant Randolf William husbandman 589033 589033 Randolf, William, of Tunbrigge, husbandman 0
5249946 2430095 2430095 defendant Avane Thomas butcher 589033 589033 Avane, Thomas, of Tunbrigge, butcher 3
5258135 2432663 2432663 defendant Legge Thomas husbandman 589033 589033 Legge, Thomas, of Tunbrigge, husbandman 2
5258136 2432663 2432663 defendant Holbeme John tailor 589033 589033 Holbeme, John, of Tunbrigge, tailor 3
5262964 2434161 2434161 plaintiff Plane Thomas (legal representative) 589033 589033 Plane, Thomas, of Tunbrigge, executors of 0
5265408 2434937 2434937 defendant Cooke William cordwainer 589033 589033 Cooke, William, of Tunbrigge, cordwainer 1
5282876 2440051 2440051 defendant Carpenter Richard carpenter 589033 589033 Carpenter, Richard, of Tunbrigge, carpenter 2
5291304 2442461 2442461 plaintiff Plane Thomas, senior (legal representative) 589033 589033 Plane, Thomas, senior, of Tunbrigge, executors of 0
5294523 2443374 2443374 plaintiff Stydolf Nicholas   589033 589033 Stydolf, Nicholas, of Tunbrigge 0
5297892 2444391 2444391 defendant West alias a Vane John yeoman 589033 589033 West alias a Vane, John, of Tunbrigge, yeoman 0
5307521 2447263 2447263 plaintiff Plane Thomas, sen (legal representative) 589033 589033 Plane, Thomas, sen, of Tunbrigge, executor of 0
5323015 2451961 2451961 defendant Smyth John yeoman 589033 589033 Smyth, John, of Tunbrigge, yeoman 0
5332334 2454737 2454737 defendant Nutward Richard yeoman 589033 589033 Nutward, Richard, of Tunbrigge, yeoman 0
5344643 2458498 2458498 defendant Rede Thomas husbandman 589033 589033 Rede, Thomas, of Tunbrigge, husbandman 1
5344645 2458498 2458498 defendant Bocher John butcher 589033 589033 Bocher, John, of Tunbrigge, butcher 3
5364388 2464524 2464524 defendant Walter Thomas butcher 589033 589033 Walter, Thomas, of Tunbrigge, butcher 1

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