names

95 rows where place_id = 590306

✎ 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
3600573 1867825 1867825 defendant Gybbys John husbandman 590306 590306 Gybbys, John, of Wetyng, husbandman 0
3616679 1872846 1872846 defendant Gybbys John yeoman 590306 590306 Gybbys, John, of Wetyng, yeoman 1
3616682 1872847 1872847 defendant Gybbys John yeoman 590306 590306 Gybbys, John, of Wetyng, yeoman 1
3619958 1873817 1873817 plaintiff Kentyng Henry (legal representative) 590306 590306 Kentyng, Henry, of Wetyng, executor of 0
3619963 1873818 1873818 plaintiff Kentyng Henry (legal representative) 590306 590306 Kentyng, Henry, of Wetyng, executor of 0
3619968 1873819 1873819 plaintiff Kentyng Henry (legal representative) 590306 590306 Kentyng, Henry, of Wetyng, executor of 0
3659980 1913380 1913380 defendant Rous William husbandman 590306 590306 Rous, William, of Wetyng, husbandman 3
3680207 1919882 1919882 defendant Warwyk Edmund mercer 590306 590306 Warwyk, Edmund, of Wetyng, mercer 0
3691351 1923455 1923455 defendant Atkynson Thomas clerk 590306 590306 Atkynson, Thomas, of Wetyng, clerk 0
3695730 1924894 1924894 defendant Warwyk Edmund mercer 590306 590306 Warwyk, Edmund, of Wetyng, mercer 0
3702613 1927083 1927083 defendant Bend Peter husbandman 590306 590306 Bend, Peter, of Wetyng, husbandman 3
3708913 1929079 1929079 defendant Warwick Edmund mercer 590306 590306 Warwick, Edmund, of Wetyng, mercer 0
3709598 1929311 1929311 defendant Warwyke Edmund mercer 590306 590306 Warwyke, Edmund, of Wetyng, mercer 0
3709927 1929419 1929419 defendant Abbott James husbandman 590306 590306 Abbott, James, of Wetyng, husbandman 2
3709928 1929419 1929419 defendant Stalworthy Edmund husbandman 590306 590306 Stalworthy, Edmund, of Wetyng, husbandman 3
3716403 1931422 1931422 defendant Kende Peter husbandman 590306 590306 Kende, Peter, of Wetyng, husbandman 3
3729210 1935385 1935385 defendant Barker William smith 590306 590306 Barker, William, of Wetyng, smith 2
3739572 1938587 1938587 defendant Warwyke Edmund mercer 590306 590306 Warwyke, Edmund, of Wetyng, mercer 1
3756529 1944018 1944018 defendant Wase Robert husbandman 590306 590306 Wase, Robert, of Wetyng, husbandman 2
3758334 1944602 1944602 defendant Blythe John husbandman 590306 590306 Blythe, John, of Wetyng, husbandman 2
3764155 1946439 1946439 defendant Blythe John husbandman 590306 590306 Blythe, John, of Wetyng, husbandman 0
3802252 1958598 1958598 defendant Blythe John husbandman 590306 590306 Blythe, John, of Wetyng, husbandman 0
3809287 1960784 1960784 defendant Abbotte James husbandman 590306 590306 Abbotte, James, of Wetyng, husbandman 0
3845772 1972226 1972226 plaintiff Fowler Richard   590306 590306 Fowler, Richard, of Wetyng 0
3845773 1972226 1972226 defendant Blythe John husbandman 590306 590306 Blythe, John, of Wetyng, husbandman 0
3900280 1990324 1990324 defendant Mays Richard   590306 590306 Mays, Richard, of Wetyng, shepherd 0
4204708 2097193 2097193 defendant Mawlyng James laborer 590306 590306 Mawlyng, James, of Wetyng, laborer 0
4415716 2169801 2169801 defendant Beaumund Thomas   590306 590306 Beaumund, Thomas, of Wetyng, parson of St Mary's church 0
4435096 2175739 2175739 plaintiff Methylwold Thomas de master & parson of All Saints church 590306 590306 Methylwold, Thomas de, of Wetyng, master & parson of All Saints church 0
4443418 2182903 2182903 defendant Strakour John, junior   590306 590306 Strakour, John, junior, of Wetyng 1
4458630 2187747 2187747 plaintiff Ray John   590306 590306 Ray, John, of Wetyng, son of John 0
4556306 2217913 2217913 plaintiff Jacob John   590306 590306 Jacob, John, of Wetyng 1
4591057 2228558 2228558 defendant Bate John   590306 590306 Bate, John, of Wetyng 1
4635038 2241805 2241805 defendant Bate Stephen   590306 590306 Bate, Stephen, of Wetyng 7
4640994 2243461 2243461 defendant Plesaunce Richard   590306 590306 Plesaunce, Richard, of Wetyng 6
4645417 2244727 2244727 defendant Hogge William   590306 590306 Hogge, William, of Wetyng 3
4663899 2250191 2250191 defendant Ray Richard   590306 590306 Ray, Richard, of Wetyng, shepherd 4
4671530 2256741 2256741 plaintiff Smyth John   590306 590306 (Smyth, John, of Wetyng, parson 1
4740933 2277857 2277857 defendant Smyth John   590306 590306 Smyth, John, of Wetyng, parson 0
4758658 2283081 2283081 defendant Barker Simon   590306 590306 Barker, Simon, of Wetyng 25
4758660 2283081 2283081 defendant Barker Simon tanner 590306 590306 Barker, Simon, of Wetyng, tanner 27
4758661 2283081 2283081 defendant Yonge John   590306 590306 Yonge, John, of Wetyng, shepherd 28
4758675 2283082 2283082 defendant Barker Simon   590306 590306 Barker, Simon, of Wetyng 2
4758677 2283082 2283082 defendant Barker Simon tanner 590306 590306 Barker, Simon, of Wetyng, tanner 4
4758678 2283082 2283082 defendant Yonge John   590306 590306 Yonge, John, of Wetyng, shepherd 5
4758714 2283083 2283083 defendant Barker Simon tanner 590306 590306 Barker, Simon, of Wetyng, tanner 24
4758716 2283083 2283083 defendant Yong John   590306 590306 Yong, John, of Wetyng, shepherd 26
4769130 2286321 2286321 defendant Yonge Robert husbandman 590306 590306 Yonge, Robert, of Wetyng, husbandman 3
4876757 2319704 2319704 plaintiff Sparwe or Sparowe John, junior   590306 590306 Sparwe or Sparowe, John, junior, of Wetyng 0
4901186 2326982 2326982 defendant Sparowe John barker 590306 590306 Sparowe, John, of Wetyng, barker 0
4911191 2330008 2330008 defendant Aleyn Thomas yeoman 590306 590306 Aleyn, Thomas, of Wetyng, yeoman 0
4911704 2330162 2330162 defendant Carle John   590306 590306 Carle, John, of Wetyng, parson 1
4912866 2330518 2330518 defendant Aylemere William husbandman 590306 590306 Aylemere, William, of Wetyng, husbandman 0
4928747 2335419 2335419 plaintiff Sparwe John   590306 590306 Sparwe, John, of Wetyng 0
5007241 2359011 2359011 plaintiff Sparowe John   590306 590306 Sparowe, John, of Wetyng 0
5007246 2359012 2359012 plaintiff Sparowe John   590306 590306 Sparowe, John, of Wetyng 0
5033592 2366711 2366711 plaintiff Sparwe or Sparowe John   590306 590306 Sparwe or Sparowe, John, of Wetyng 0
5071236 2377896 2377896 plaintiff Sparwe or Sparowe John   590306 590306 Sparwe or Sparowe, John, of Wetyng 0
5076964 2379608 2379608 defendant Kentyng Henry gent 590306 590306 (Kentyng, Henry, of Wetyng, gent 1
5076966 2379608 2379608 defendant Aleyn Thomas yeoman 590306 590306 Aleyn, Thomas, of Wetyng, yeoman 3
5076967 2379608 2379608 defendant Troys Reginald chaplain 590306 590306 Troys, Reginald, of Wetyng, chaplain 4
5076971 2379609 2379609 defendant Aleyn Thomas yeoman 590306 590306 Aleyn, Thomas, of Wetyng, yeoman 2
5076972 2379609 2379609 defendant Troys Reginald chaplain 590306 590306 Troys, Reginald, of Wetyng, chaplain 3
5095878 2385222 2385222 plaintiff Sparowe John   590306 590306 Sparowe, John, of Wetyng 0
5095888 2385225 2385225 plaintiff Sparwe or Sparowe John   590306 590306 Sparwe or Sparowe, John, of Wetyng 0
5122120 2392890 2392890 defendant Aleyn Thomas yeoman 590306 590306 (Aleyn, Thomas, of Wetyng, yeoman 1
5155049 2402630 2402630 defendant Bevyr Thomas clerk & parson of St Mary's church 590306 590306 Bevyr, Thomas, of Wetyng, clerk & parson of St Mary's church 3
5261016 2433561 2433561 defendant Fykeys Richard husbandman 590306 590306 Fykeys, Richard, of Wetyng, husbandman 3
5291545 2442530 2442530 defendant Aleyn Thomas husbandman 590306 590306 Aleyn, Thomas, of Wetyng, husbandman 0
5303017 2445892 2445892 defendant Hoo Richard husbandman 590306 590306 Hoo, Richard, of Wetyng, husbandman 3
5323561 2452128 2452128 defendant Fekeys Richard yeoman 590306 590306 Fekeys, Richard, of Wetyng, yeoman 0
5323562 2452128 2452128 defendant Styward Robert husbandman 590306 590306 Styward, Robert, of Wetyng, husbandman 1
5355654 2461844 2461844 defendant Neve John   590306 590306 Neve, John, of Wetyng, shepherd 0
5390486 2472341 2472341 defendant Kentyng John gent 590306 590306 Kentyng, John, of Wetyng, gent 0
5394389 2473462 2473462 defendant Kentyng John gent 590306 590306 Kentyng, John, of Wetyng, gent 0
5396160 2473988 2473988 defendant Kentyng John gent 590306 590306 Kentyng, John, of Wetyng, gent 0
5409522 2477812 2477812 defendant Kentyng John gent 590306 590306 Kentyng, John, of Wetyng, gent 0
5423063 2481852 2481852 defendant Kentyng John gent 590306 590306 Kentyng, John, of Wetyng, gent 0
5466060 2494782 2494782 defendant Troys Robert husbandman 590306 590306 Troys, Robert, of Wetyng, husbandman 0
5466061 2494782 2494782 defendant (illegible) Thomas husbandman 590306 590306 _, Thomas, of Wetyng, husbandman 1
5484342 2500237 2500237 defendant Troys Robert husbandman 590306 590306 Troys, Robert, of Wetyng, husbandman 0
5484343 2500237 2500237 defendant Hogge Thomas husbandman 590306 590306 Hogge, Thomas, of Wetyng, husbandman 1
5496026 2503704 2503704 defendant Kentyng John gent 590306 590306 Kentyng, John, of Wetyng, gent 1
5496900 2504003 2504003 defendant Kentyng John gent 590306 590306 Kentyng, John, of Wetyng, gent 0
5497801 2504284 2504284 defendant Hogge or Hegge Tholmas yeoman 590306 590306 Hogge or Hegge, Tholmas, of Wetyng, yeoman 1
5503770 2506096 2506096 plaintiff Miller John   590306 590306 Miller, John, of Wetyng 1
5522465 2511845 2511845 defendant Gybbys John yeoman 590306 590306 Gybbys, John, of Wetyng, yeoman 3
5538041 2516384 2516384 defendant Bole John yeoman 590306 590306 Bole, John, of Wetyng, yeoman 9
5551696 2520538 2520538 defendant Fekes Richard husbandman 590306 590306 Fekes, Richard, of Wetyng, husbandman 1
5552865 2520888 2520888 defendant Craven William clerk 590306 590306 Craven, William, of Wetyng, clerk 0
5599921 2534858 2534858 plaintiff Hanslep Robert (legal representative) 590306 590306 Hanslep, Robert, of Wetyng, executors of 0
5599926 2534859 2534859 plaintiff Hanslep Robert (legal representative) 590306 590306 Hanslep, Robert, of Wetyng, executors of 0
5599929 2534860 2534860 plaintiff Hanslep Robert (legal representative) 590306 590306 Hanslep, Robert, of Wetyng, executors of 0
5599935 2534861 2534861 plaintiff Hanslep Robert (legal representative) 590306 590306 Hanslep, Robert, of Wetyng, executors of 0
5617547 2549309 2549309 defendant Coo John   590306 590306 Coo, John, of Wetyng 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);