names

193 rows where place_id = 586555

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587656 1863785 1863785 defendant Baker Stephen clothier 586555 586555 Baker, Stephen, of Lye under Menedepe, clothier 0
3589016 1864214 1864214 defendant Garland John waterman 586555 586555 Garland, John, of Lye, waterman 1
3591823 1865064 1865064 defendant Skynner Robert fisher 586555 586555 Skynner, Robert, of Lye, fisher 0
3591824 1865064 1865064 defendant Tryser Roger fisher 586555 586555 Tryser, Roger, of Lye, fisher 1
3591825 1865064 1865064 defendant Salman Robert fisher 586555 586555 Salman, Robert, of Lye, fisher 2
3591826 1865064 1865064 defendant Gylmyn John fisher 586555 586555 Gylmyn, John, of Lye, fisher 3
3591827 1865064 1865064 defendant Seyer William fisher 586555 586555 Seyer, William, of Lye, fisher 4
3591828 1865064 1865064 defendant Salman John fisher 586555 586555 Salman, John, of Lye, fisher 5
3598166 1867057 1867057 plaintiff Skynner Robert shipman 586555 586555 Skynner, Robert, of Lye, shipman 0
3599443 1867465 1867465 plaintiff Trycer Roger shipman 586555 586555 Trycer, Roger, of Lye, shipman 0
3618101 1873284 1873284 defendant Dounton John butcher 586555 586555 Dounton, John, of Lye, butcher 0
3619199 1873605 1873605 defendant Yonge Simon carpenter 586555 586555 Yonge, Simon, of Lye, carpenter 0
3619201 1873606 1873606 defendant Yonge Simon carpenter 586555 586555 Yonge, Simon, of Lye, carpenter 0
3619203 1873607 1873607 defendant Yonge Simon carpenter 586555 586555 Yonge, Simon, of Lye, carpenter 0
3619204 1873607 1873607 defendant Frere Thomas husbandman 586555 586555 Frere, Thomas, of Lye, husbandman 1
3619205 1873607 1873607 defendant White Richard husbandman 586555 586555 White, Richard, of Lye, husbandman 2
3619242 1873620 1873620 defendant Wolford John clothier 586555 586555 Wolford, John, of Lye under Myndepe, clothier 0
3637055 1906388 1906388 defendant White John husbandman 586555 586555 White, John, of Lye, husbandman 0
3637056 1906388 1906388 defendant Wower John husbandman 586555 586555 Wower, John, of Lye, husbandman 1
3676417 1918669 1918669 defendant Walwyn Lucy widow 586555 586555 Walwyn, Lucy, of Lye, widow 0
3680500 1919984 1919984 defendant Chelsham William husbandman 586555 586555 Chelsham, William, of Lye, husbandman 0
3691305 1923440 1923440 defendant Roote Thomas butcher 586555 586555 Roote, Thomas, of Lye, butcher 0
3692928 1923987 1923987 defendant Patryke Henry miller 586555 586555 Patryke, Henry, of Lye, miller 1
3692929 1923987 1923987 defendant Wall Thomas husbandman 586555 586555 Wall, Thomas, of Lye, husbandman 2
3707511 1928643 1928643 defendant Gynons or Gyvons John husbandman 586555 586555 Gynons or Gyvons, John, of Lye, husbandman 0
3718223 1931981 1931981 defendant Totehyll John husbandman 586555 586555 Totehyll, John, of Lye, husbandman 0
3750892 1942202 1942202 defendant Calverley William husbandman 586555 586555 Calverley, William, of Lye, husbandman 0
3750893 1942202 1942202 defendant Cheseman Edward husbandman 586555 586555 Cheseman, Edward, of Lye, husbandman 1
3758480 1944648 1944648 plaintiff Burstowe John   586555 586555 Burstowe, John, of Lye 0
3758481 1944648 1944648 defendant Wower John rippier 586555 586555 Wower, John, of Lye, rippier 0
3765082 1946743 1946743 defendant Bolle John husbandman 586555 586555 Bolle, John, of Lye, Wymbourne Mynster, husbandman 2
3784663 1952989 1952989 defendant White Christopher husbandman 586555 586555 White, Christopher, of Lye, husbandman 0
3794216 1956063 1956063 defendant Cove Margaret widow 586555 586555 Cove, Margaret, of Lye, widow 2
3794957 1956287 1956287 defendant Whetenell Thomas yeoman 586555 586555 Whetenell, Thomas, of Lye, yeoman 1
3817080 1963256 1963256 defendant Bolle John husbandman 586555 586555 Bolle, John, of Lye, Wynborne Mynster, husbandman 2
3820705 1964364 1964364 defendant Brystow John husbandman 586555 586555 Brystow, John, of Lye, husbandman 0
3820707 1964365 1964365 defendant Whyte Christopher husbandman 586555 586555 Whyte, Christopher, of Lye, husbandman 0
3842278 1971129 1971129 defendant Isemonger Thomas laborer 586555 586555 Isemonger, Thomas, of Lye, laborer 1
3861605 1977341 1977341 defendant Brystowe John   586555 586555 Brystowe, John, of Lye 0
3869782 1980136 1980136 defendant Hawker Robert laborer 586555 586555 Hawker, Robert, of Lye, laborer 0
3875685 1982114 1982114 defendant Brystowe John   586555 586555 Brystowe, John, of Lye 0
3920572 1997228 1997228 defendant Revers William husbandman 586555 586555 Revers, William, of Lye, husbandman 1
3942075 2004364 2004364 defendant Maynard Tristram yeoman 586555 586555 Maynard, Tristram, of Lye, yeoman 0
3960682 2010836 2010836 defendant Walrond Thomas gent 586555 586555 Walrond, Thomas, of Lye, gent 0
3966442 2012899 2012899 defendant Bristowe Christopher yeoman 586555 586555 Bristowe, Christopher, of Lye, yeoman 0
3966443 2012899 2012899 defendant Bristowe Edmund yeoman 586555 586555 Bristowe, Edmund, of Lye, yeoman 1
3966444 2012899 2012899 defendant Wheler John husbandman 586555 586555 Wheler, John, of Lye, husbandman 2
3966445 2012899 2012899 defendant Blundell Humphrey husbandman 586555 586555 Blundell, Humphrey, of Lye, husbandman 3
3976288 2016276 2016276 defendant Isted Richard husbandman 586555 586555 Isted, Richard, of Lye, husbandman 0
3981040 2017980 2017980 defendant Parrett Andrew husbandman 586555 586555 Parrett, Andrew, of Lye, husbandman 1
3981041 2017980 2017980 defendant Tawnton William husbandman 586555 586555 Tawnton, William, of Lye, husbandman 2
3984630 2019261 2019261 defendant Bristowe Christopher yeoman 586555 586555 Bristowe, Christopher, of Lye, yeoman 0
3984631 2019261 2019261 defendant Parson Richard husbandman 586555 586555 Parson, Richard, of Lye, husbandman 1
4013162 2029439 2029439 defendant Wake John husbandman 586555 586555 Wake, John, of Lye, husbandman 0
4039400 2038717 2038717 defendant Welles Robert yeoman 586555 586555 Welles, Robert, of Lye, yeoman 2
4039404 2038718 2038718 defendant Welles Robert yeoman 586555 586555 Welles, Robert, of Lye, yeoman 2
4059766 2045886 2045886 defendant Downe John yeoman 586555 586555 Downe, John, of Lye, yeoman 2
4086408 2055418 2055418 defendant Moonter Elizabeth spinster 586555 586555 Moonter, Elizabeth, of Lye, spinster 0
4091675 2057314 2057314 defendant Busshoppe Richard tailor 586555 586555 Busshoppe, Richard, of Lye, tailor 0
4091676 2057314 2057314 defendant Rogers John husbandman 586555 586555 Rogers, John, of Lye, husbandman 1
4117038 2066395 2066395 defendant Aston Anthony esq 586555 586555 Aston, Anthony, of Lye, esq 0
4117040 2066396 2066396 defendant Watson Thomas yeoman 586555 586555 Watson, Thomas, of Lye, yeoman 0
4127193 2070018 2070018 defendant Sampforde William clerk 586555 586555 Sampforde, William, of Lye, clerk 0
4136272 2073318 2073318 defendant Stanforde William clerk 586555 586555 Stanforde, William, of Lye, clerk 0
4157611 2080735 2080735 defendant Gasse Walter butcher 586555 586555 Gasse, Walter, of Lye, butcher 1
4164509 2083103 2083103 defendant Wilkyn Richard yeoman 586555 586555 Wilkyn, Richard, of Lye, or of Albridge, Essex, yeoman 0
4174027 2086368 2086368 defendant Elsey Richard husbandman 586555 586555 Elsey, Richard, of Lye, husbandman 0
4212526 2099923 2099923 defendant Berde Richard husbandman 586555 586555 Berde, Richard, of Lye, husbandman 2
4212730 2099993 2099993 defendant Williams Owen yeoman 586555 586555 Williams, Owen, of Lye, yeoman 2
4212731 2099993 2099993 defendant Wheeler Thomas husbandman 586555 586555 Wheeler, Thomas, of Lye, husbandman 3
4225060 2104234 2104234 defendant Hooker Walsingham yeoman 586555 586555 Hooker, Walsingham, of Lye, yeoman 1
4225062 2104234 2104234 defendant Crust Christopher yeoman 586555 586555 Crust, Christopher, of Lye, yeoman 3
4239130 2109310 2109310 defendant Welles William yeoman 586555 586555 Welles, William, of Lye, yeoman 0
4251392 2113446 2113446 defendant Hooker Walsingham yeoman 586555 586555 Hooker, Walsingham, of Lye, yeoman 1
4251394 2113446 2113446 defendant Crust Christopher yeoman 586555 586555 Crust, Christopher, of Lye, yeoman 3
4252983 2113990 2113990 defendant Rogers John yeoman 586555 586555 Rogers, John, of Lye, or of Tunbridge, yeoman 0
4291711 2127111 2127111 defendant Kynge Richard yeoman 586555 586555 Kynge, Richard, of Lye, Wymborne Mynster, yeoman 1
4301090 2130495 2130495 defendant Batt John baker 586555 586555 Batt, John, of Lye, baker 0
4312780 2134599 2134599 defendant Bonnycke or Bennycke Thomas   586555 586555 Bonnycke or Bennycke, Thomas, of Lye, tile maker 2
4312781 2134599 2134599 defendant Constable Thomas yeoman 586555 586555 Constable, Thomas, of Lye, yeoman 3
4331444 2140813 2140813 defendant Constable Thomas yeoman 586555 586555 Constable, Thomas, of Lye, yeoman 1
4443281 2182859 2182859 defendant Clobbe Thomas   586555 586555 Clobbe, Thomas, of Lye 0
4484426 2195821 2195821 defendant Wytton John de chaplain 586555 586555 Wytton, John de, of Lye, chaplain 4
4504142 2201847 2201847 defendant Souter Philip   586555 586555 Souter, Philip, of Lye 0
4528991 2209348 2209348 defendant Milleward Thomas   586555 586555 Milleward, Thomas, of Lye 0
4529307 2209449 2209449 defendant Emory William   586555 586555 Emory, William, of Lye 0
4544596 2214224 2214224 defendant Gynon John   586555 586555 Gynon, John, of Lye 8
4552218 2216647 2216647 defendant Stoke Robert   586555 586555 Stoke, Robert, of Lye 0
4561604 2219565 2219565 defendant atte Lye Thomas   586555 586555 atte Lye, Thomas, of Lye 0
4568517 2221727 2221727 defendant Robert atte Nasshe John   586555 586555 Robert atte Nasshe, John, of Lye 0
4569940 2222167 2222167 defendant Yonge John   586555 586555 Yonge, John, of Lye 2
4575046 2223717 2223717 defendant Wateson William   586555 586555 Wateson, William, of Lye 2
4615387 2235820 2235820 defendant Pyper John   586555 586555 Pyper, John, of Lye 2
4621821 2237810 2237810 defendant Lye John   586555 586555 Lye, John, of Lye 0
4630836 2240534 2240534 defendant Colyns John   586555 586555 Colyns, John, of Lye 0
4636877 2242350 2242350 defendant Baker Hugh   586555 586555 Baker, Hugh, of Lye 0
4636878 2242350 2242350 defendant Webbe John   586555 586555 Webbe, John, of Lye 1
4636879 2242350 2242350 defendant Merwall William   586555 586555 Merwall, William, of Lye 2
4636880 2242350 2242350 defendant Taillour William   586555 586555 Taillour, William, of Lye 3
4636881 2242350 2242350 defendant Clobbe Richard   586555 586555 Clobbe, Richard, of Lye 4

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