names

108 rows where place_id = 586675

✎ 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
3589347 1864310 1864310 plaintiff Bukke Thomas   586675 586675 Bukke, Thomas, of Brandon 0
3591070 1864837 1864837 defendant Tullyng Hugh yeoman 586675 586675 Tullyng, Hugh, of Brandon, yeoman 0
3612244 1871464 1871464 defendant Aleyn William husbandman 586675 586675 Aleyn, William, of Brandon, husbandman 3
3617075 1872964 1872964 defendant Norton Andrew husbandman 586675 586675 Norton, Andrew, of Brandon, husbandman 0
3638226 1906777 1906777 defendant Eyre Richard husbandman 586675 586675 Eyre, Richard, of Brandon, husbandman 0
3649900 1910332 1910332 defendant Parker Hugh yeoman 586675 586675 Parker, Hugh, of Brandon, yeoman 2
3666086 1915335 1915335 defendant Thomson John husbandman 586675 586675 Thomson, John, of Brandon, husbandman 0
3666489 1915464 1915464 defendant More Richard yeoman 586675 586675 More, Richard, of Brandon, yeoman 9
3666490 1915464 1915464 defendant More William yeoman 586675 586675 More, William, of Brandon, yeoman 10
3666491 1915464 1915464 defendant Herryson Richard yeoman 586675 586675 Herryson, Richard, of Brandon, yeoman, More, Richard, junior, of Brandon, yeoman 11
3666492 1915464 1915464 defendant Haryson John yeoman 586675 586675 Haryson, John, of Brandon, yeoman 12
3666493 1915464 1915464 defendant Harryson William yeoman 586675 586675 Harryson, William, of Brandon, yeoman 13
3666494 1915464 1915464 defendant Grene Richard yeoman 586675 586675 Grene, Richard, of Brandon, yeoman 14
3682602 1920663 1920663 plaintiff Thomson John   586675 586675 Thomson, John, of Brandon 0
3688409 1922532 1922532 defendant Smyth Thomas husbandman 586675 586675 Smyth, Thomas, of Brandon, husbandman 2
3688411 1922532 1922532 defendant Reynberd John yeoman 586675 586675 Reynberd, John, of Brandon, yeoman 4
3710516 1929611 1929611 defendant Reynberd John husbandman 586675 586675 Reynberd, John, of Brandon, husbandman 2
3714195 1930739 1930739 plaintiff Baron Ralph yeoman 586675 586675 Baron, Ralph, of Brandon, yeoman 0
3729518 1935477 1935477 plaintiff Baron Ralph yeoman 586675 586675 Baron, Ralph, of Brandon, yeoman 0
3729520 1935478 1935478 plaintiff Baron Ralph yeoman 586675 586675 Baron, Ralph, of Brandon, yeoman 0
3786378 1953525 1953525 defendant Baron Ralph innkeeper 586675 586675 Baron, Ralph, of Brandon, innkeeper 0
3854199 1974952 1974952 plaintiff Atmere John   586675 586675 Atmere, John, of Brandon 1
3884479 1985082 1985082 defendant Taverham Robert chaplain 586675 586675 Taverham, Robert, of Brandon, chaplain 0
3935384 2002147 2002147 defendant Brudeheade Alexander husbandman 586675 586675 Brudeheade, Alexander, of Brandon, husbandman 0
3968276 2013534 2013534 plaintiff Chapman Margery widow 586675 586675 Chapman, Margery, of Brandon, widow 0
3993546 2022436 2022436 plaintiff Chapman Margery widow 586675 586675 Chapman, Margery, of Brandon, widow 0
4003846 2026140 2026140 defendant Bcrowe Anne widow 586675 586675 Bcrowe, Anne, of Brandon, widow 1
4008094 2027659 2027659 defendant Barnwell Richard laborer 586675 586675 Barnwell, Richard, of Brandon, laborer 0
4008095 2027659 2027659 defendant Barnewell Peter tailor 586675 586675 Barnewell, Peter, of Brandon, tailor 1
4030234 2035464 2035464 defendant Crowe John (legal representative) 586675 586675 Crowe, John, of Brandon Fere, innholder, administratrix of 0
4038609 2038449 2038449 defendant Kepas William yeoman 586675 586675 Kepas, William, of Brandon, yeoman 0
4070251 2049653 2049653 defendant Capp Richard husbandman 586675 586675 Capp, Richard, of Brandon, husbandman 0
4129377 2070809 2070809 defendant Gryme John yeoman 586675 586675 Gryme, John, of Brandon, yeoman 2
4168781 2084573 2084573 defendant Margott Augustine tailor 586675 586675 Margott, Augustine, of Brandon, tailor 0
4168783 2084574 2084574 defendant Marshall Augustine yeoman 586675 586675 Marshall, Augustine, of Brandon, yeoman 0
4168784 2084574 2084574 defendant Darbye Henry tailor 586675 586675 together with Darbye, Henry, of Brandon, tailor 1
4243808 2110909 2110909 defendant Duffell John husbandman 586675 586675 Duffell, John, of Brandon, husbandman 1
4274279 2120949 2120949 defendant Samuell William butcher 586675 586675 Samuell, William, of Brandon, butcher 1
4274280 2120949 2120949 defendant Archer Anthony yeoman 586675 586675 Archer, Anthony, of Brandon, yeoman 2
4279224 2122665 2122665 defendant Burdhead Hugh yeoman 586675 586675 Burdhead, Hugh, of Brandon, yeoman 1
4283562 2124158 2124158 defendant Marchante Robert butcher 586675 586675 Marchante, Robert, of Brandon, butcher 2
4285273 2124782 2124782 defendant Bate Gabriel yeoman 586675 586675 Bate, Gabriel, of Brandon, yeoman 3
4305845 2132182 2132182 defendant Hopwoode John fishmonger 586675 586675 Hopwoode, John, of Brandon, fishmonger 1
4311743 2134247 2134247 defendant Raynold Francis gent 586675 586675 Raynold, Francis, of Brandon, gent 0
4361972 2151441 2151441 defendant Raynold Francis gent 586675 586675 Raynold, Francis, of Brandon, gent 0
4391855 2161901 2161901 defendant Ashewell Ambrose yeoman 586675 586675 Ashewell, Ambrose, of Brandon, yeoman 0
4405794 2166505 2166505 defendant Duffeild John yeoman 586675 586675 Duffeild, John, of Brandon, yeoman 3
4409909 2167919 2167919 defendant Froste Thomas husbandman 586675 586675 Froste, Thomas, of Brandon, husbandman 0
4441094 2182141 2182141 defendant Bray Thomas   586675 586675 Bray, Thomas, of Brandon 0
4497790 2199952 2199952 defendant Pygas Simon   586675 586675 Pygas, Simon, of Brandon 1
4518513 2206163 2206163 plaintiff Digby Thomas   586675 586675 Digby, Thomas, of Brandon 0
4545678 2214572 2214572 defendant Wolhouse John   586675 586675 Wolhouse, John, of Brandon 1
4553492 2217021 2217021 defendant Myddeby John   586675 586675 Myddeby, John, of Brandon 0
4560970 2219385 2219385 defendant Barnewell John   586675 586675 Barnewell, John, of Brandon 0
4593740 2229314 2229314 defendant Fransham Thomas   586675 586675 Fransham, Thomas, of Brandon 4
4597841 2230579 2230579 plaintiff Smyth Bartholomew   586675 586675 Smyth, Bartholomew, of Brandon 0
4609334 2234019 2234019 defendant Bernewell John   586675 586675 Bernewell, John, of Brandon 3
4640833 2243418 2243418 defendant Mille Henry   586675 586675 Mille, Henry, of Brandon 1
4640837 2243418 2243418 defendant Kyrton Thomas   586675 586675 Kyrton, Thomas, of Brandon 5
4653880 2247122 2247122 plaintiff Bernewell John   586675 586675 Bernewell, John, of Brandon 0
4660583 2249135 2249135 defendant Dounham Thomas yeoman 586675 586675 Dounham, Thomas, of Brandon, yeoman 1
4708848 2268135 2268135 defendant Causton John miller 586675 586675 Causton, John, of Brandon, miller 0
4725184 2273172 2273172 defendant Kirkeby William husbandman 586675 586675 Kirkeby, William, of Brandon, husbandman 0
4739639 2277472 2277472 defendant Jordane Peter husbandman 586675 586675 Jordane, Peter, of Brandon, husbandman 0
4758655 2283081 2283081 defendant Scarlet John   586675 586675 Scarlet, John, of Brandon Ferry, scrivenor 22
4758718 2283083 2283083 defendant Scarlet Ivan   586675 586675 Scarlet, Ivan, of Brandon Ferry, scrivenor 28
4790979 2293270 2293270 defendant Femelyn Adam   586675 586675 Femelyn, Adam, of Brandon myeoman 3
4845767 2310185 2310185 defendant atte Haghe Robert husbandman 586675 586675 atte Haghe, Robert, of Brandon, husbandman 4
4857454 2313720 2313720 defendant Martyn Robert farmer 586675 586675 Martyn, Robert, of Brandon, farmer 0
4864465 2315861 2315861 defendant Burgoyne William husbandman 586675 586675 Burgoyne, William, of Brandon, husbandman 3
4878713 2320282 2320282 defendant Brandon John husbandman 586675 586675 Brandon, John, of Brandon, husbandman 2
4884996 2322206 2322206 defendant Westgate John yeoman 586675 586675 Westgate, John, of Brandon, yeoman 0
4888427 2323179 2323179 defendant Martyn Robert farmer 586675 586675 Martyn, Robert, of Brandon, farmer 0
4889723 2323582 2323582 defendant atte Haghe Robert husbandman 586675 586675 atte Haghe, Robert, of Brandon, husbandman 0
4889724 2323582 2323582 defendant Fundenhale Robert husbandman 586675 586675 Fundenhale, Robert, of Brandon, husbandman 1
4892963 2324525 2324525 defendant Fundenall Robert laborer 586675 586675 Fundenall, Robert, of Brandon, laborer 4
4895735 2325342 2325342 defendant Causton John miller 586675 586675 Causton, John, of Brandon, miller 1
4897065 2325737 2325737 defendant Hillary John, senior laborer 586675 586675 Hillary, John, senior, of Brandon, laborer 1
4906646 2328667 2328667 defendant Hillary John, senior laborer 586675 586675 Hillary, John, senior, of Brandon, laborer 1
4994315 2355173 2355173 defendant Trevy William summoner 586675 586675 Trevy, William, of Brandon, summoner 0
4997886 2356227 2356227 defendant Fyssher William husbandman 586675 586675 Fyssher, William, of Brandon, husbandman 1
5049324 2371431 2371431 plaintiff Smyth John   586675 586675 Smyth, John, of Brandon 0
5086238 2382369 2382369 defendant Barre John laborer 586675 586675 Barre, John, of Brandon, laborer 1
5088296 2382950 2382950 defendant Wherston Thomas husbandman 586675 586675 Wherston, Thomas, of Brandon, husbandman 2
5088300 2382951 2382951 defendant Wherston Thomas quarrier 586675 586675 Wherston, Thomas, of Brandon, quarrier 2
5097610 2385728 2385728 defendant Beverley John yeoman 586675 586675 Beverley, John, of Brandon, yeoman 2
5122080 2392876 2392876 plaintiff Trouth John   586675 586675 Trouth, John, of Brandon 0
5154878 2402586 2402586 defendant Jonson Robert   586675 586675 Jonson, Robert, of Brandon, shepherd 1
5234497 2425678 2425678 defendant Swerston Thomas osteler 586675 586675 Swerston, Thomas, of Brandon, osteler 2
5235547 2425979 2425979 defendant Norton Andrew butcher 586675 586675 Norton, Andrew, of Brandon, butcher 1
5245453 2428825 2428825 defendant Ochehall John husbandman 586675 586675 Ochehall, John, of Brandon, husbandman 0
5256775 2432241 2432241 defendant Swatheston Thomas yeoman 586675 586675 Swatheston, Thomas, of Brandon, yeoman 1
5273656 2437372 2437372 defendant Carre William yeoman 586675 586675 Carre, William, of Brandon, yeoman 1
5321488 2451518 2451518 defendant Smyth William yeoman 586675 586675 Smyth, William, of Brandon, yeoman 3
5331640 2454545 2454545 defendant Marsshall Richard husbandman 586675 586675 Marsshall, Richard, of Brandon, husbandman 1
5390734 2472411 2472411 defendant Myles Thomas   586675 586675 Myles, Thomas, of Brandon 2
5403686 2476124 2476124 defendant Myles John husbandman 586675 586675 Myles, John, of Brandon, husbandman 2
5403687 2476124 2476124 defendant Myles Thomas clerk 586675 586675 Myles, Thomas, of Brandon, clerk 3
5403691 2476125 2476125 defendant Myles John husbandman 586675 586675 Myles, John, of Brandon, husbandman 2
5403692 2476125 2476125 defendant Myles Thomas clerk 586675 586675 Myles, Thomas, of Brandon, clerk 3

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