names

102 rows where place_id = 587702

✎ 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
3592187 1865175 1865175 defendant Fyssher Nicholas carter 587702 587702 Fyssher, Nicholas, of Andever, Hants, carter 2
3608023 1870161 1870161 defendant Hamse Robert spicer 587702 587702 Hamse, Robert, of Andever, Hants, spicer 1
3608651 1870366 1870366 defendant Hance Robert chapman 587702 587702 Hance, Robert, of Andever, Hants, chapman 2
3622262 1874497 1874497 defendant Barell Joan widow 587702 587702 Barell, Joan, of Andever, Hants, widow 1
3624189 1875098 1875098 defendant Lone or Love Thomas innholder 587702 587702 Lone or Love, Thomas, of Andever, Hants, innholder 0
3701119 1926598 1926598 plaintiff Blyssett John baker 587702 587702 Blyssett, John, of Andever, Hants, baker 0
3712612 1930260 1930260 defendant Philip Richard yeoman 587702 587702 Philip, Richard, of Andever, Hants, yeoman 0
3762249 1945838 1945838 defendant Hause or Hanse Robert chapman 587702 587702 Hause or Hanse, Robert, of Andever, Hants, chapman 0
3781554 1951966 1951966 defendant Smythe John baker 587702 587702 Smythe, John, of Andever, Hants, baker 3
3843225 1971413 1971413 defendant Chamber Richard innholder 587702 587702 Chamber, Richard, of Andever, Hants, innholder 1
3843229 1971414 1971414 defendant Chamber Richard innholder 587702 587702 Chamber, Richard, of Andever, Hants, innholder 2
3843334 1971448 1971448 defendant Gylberd Richard yeoman 587702 587702 Gylberd, Richard, of Andever, Hants, yeoman 0
3946022 2005684 2005684 defendant Jarvys John capper 587702 587702 Jarvys, John, of Andever, Hants, capper 2
3946650 2005892 2005892 defendant Kynsfeld Edmund   587702 587702 Kynsfeld, Edmund, of Andever, Hants, freemason 0
3970682 2014335 2014335 defendant Warder Nichols mercer 587702 587702 Warder, Nichols, of Andever, Hants, mercer 0
3973866 2015427 2015427 defendant Martyn Edmund chapman 587702 587702 Martyn, Edmund, of Andever, Hants, chapman 0
3973871 2015429 2015429 defendant Martyn William chapman 587702 587702 Martyn, William, of Andever, Hants, chapman 0
3975397 2015961 2015961 defendant West John chapman 587702 587702 West, John, of Andever, Hants, chapman 0
3976594 2016388 2016388 defendant Marten William mercer 587702 587702 Marten, William, of Andever, Hants, mercer 0
3978143 2016934 2016934 plaintiff Marten William   587702 587702 Marten, William, of Andever, Hants, linen draper 0
4001460 2025301 2025301 plaintiff Hanson John   587702 587702 Hanson, John, of Andever, Hants, administrators of 0
4003584 2026045 2026045 defendant Graunte Richard chapman 587702 587702 Graunte, Richard, of Andever, Hants, chapman 0
4008539 2027818 2027818 defendant Jervys Richard capper 587702 587702 Jervys, Richard, of Andever, Hants, capper 0
4016356 2030547 2030547 defendant Peterson Anthony yeoman 587702 587702 Peterson, Anthony, of Andever, Hants, yeoman 0
4016359 2030548 2030548 defendant Peterson Anthony yeoman 587702 587702 Peterson, Anthony, of Andever, Hants, yeoman 0
4029606 2035225 2035225 defendant Payne Anthony mercer 587702 587702 Payne, Anthony, of Andever, Hants, mercer 0
4029608 2035226 2035226 defendant Payne Anthony mercer 587702 587702 Payne, Anthony, of Andever, Hants, mercer 0
4031616 2035971 2035971 plaintiff Forder alias Butler William   587702 587702 Forder alias Butler, William, of Andever, Hants, linen draper 0
4043001 2039972 2039972 defendant Harte Henry yeoman or innholder 587702 587702 Harte, Henry, of Andever, Hants, yeoman or innholder 0
4047611 2041596 2041596 defendant Rickman Stephen yeoman 587702 587702 Rickman, Stephen, of Andever, Hants, yeoman 0
4047614 2041597 2041597 defendant Ryckman Stephen yeoman 587702 587702 Ryckman, Stephen, of Andever, Hants, yeoman 0
4052475 2043306 2043306 defendant Gunter William gent 587702 587702 Gunter, William, of Andever, Hants, gent 0
4059321 2045727 2045727 defendant Grawntt Richard chapman 587702 587702 Grawntt, Richard, of Andever, Hants, chapman 0
4070577 2049770 2049770 defendant Noyes Thomas gent 587702 587702 Noyes, Thomas, of Andever, Hants, gent 0
4091582 2057280 2057280 defendant Longe Jasper   587702 587702 Longe, Jasper, of Andever, Hants, tallow chandler 0
4111903 2064505 2064505 defendant Hercye John gent 587702 587702 Hercye, John, of Andever, Hants, gent 0
4134348 2072614 2072614 defendant Peaseley Christopher   587702 587702 Peaseley, Christopher, of Andever, Hants, apothecary 1
4142251 2075466 2075466 defendant Childe Thomas, senior chapman 587702 587702 Childe, Thomas, senior, of Andever, Hants, chapman 0
4147237 2077171 2077171 defendant Weste John chapman 587702 587702 Weste, John, of Andever, Hants, chapman 2
4183222 2089613 2089613 defendant Smyth John yeoman 587702 587702 Smyth, John, of Andever, Hants, yeoman 1
4188469 2091439 2091439 defendant Skullerd John gent 587702 587702 Skullerd, John, of Andever, Hants, gent 18
4211688 2099642 2099642 defendant West John chapman 587702 587702 West, John, of Andever, Hants, chapman 0
4215548 2100935 2100935 defendant London Richard hatter 587702 587702 London, Richard, of Andever, Hants, hatter 2
4235061 2107816 2107816 defendant Blake Robert gent 587702 587702 Blake, Robert, of Andever, Hants, or of Bedwyn, Wilts, gent 0
4242126 2110359 2110359 defendant Cowper William clothier 587702 587702 Cowper, William, of Andever, Hants, clothier 0
4251818 2113597 2113597 defendant Cowper William clothier 587702 587702 Cowper, William, of Andever, Hants, clothier 0
4267269 2118689 2118689 defendant Knighte John gent 587702 587702 Knighte, John, of Andever, Hants, gent 0
4271432 2120024 2120024 defendant Smyth William yeoman 587702 587702 Smyth, William, of Andever, Hants, yeoman 0
4295416 2128448 2128448 defendant Knighte John gent 587702 587702 Knighte, John, of Andever, Hants, gent 0
4309902 2133619 2133619 defendant Knyghte John gent 587702 587702 Knyghte, John, of Andever, Hants, gent 0
4319279 2136852 2136852 defendant West John chapman 587702 587702 West, John, of Andever, Hants, chapman 2
4324211 2138500 2138500 defendant Burghe Christopher chapman 587702 587702 Burghe, Christopher, of Andever, Hants, chapman 0
4327643 2139566 2139566 defendant Knyghte John gent 587702 587702 Knyghte, John, of Andever, Hants, gent 0
4329643 2140211 2140211 defendant Noyes Peter gent 587702 587702 Noyes, Peter, of Andever, Hants, gent 1
4333808 2141589 2141589 defendant Jarvys Richard, senior chapman 587702 587702 Jarvys, Richard, senior, of Andever, Hants, chapman 1
4333812 2141590 2141590 defendant Jarvys William chapman 587702 587702 Jarvys, William, of Andever, Hants, chapman 0
4377560 2157050 2157050 defendant Bannester Benjamin tailor 587702 587702 Bannester, Benjamin, of Andever, Hants, tailor 0
4392513 2162117 2162117 defendant Strike Andrew   587702 587702 Strike, Andrew, of Andever, Hants, tallow chandler 1
4401088 2164958 2164958 defendant Peterson Anthony haberdasher 587702 587702 Peterson, Anthony, of Andever, Hants, haberdasher 0
4655317 2247551 2247551 defendant Durdant John gent 587702 587702 Durdant, John, of Andever, Hants, gent 1
4750244 2280548 2280548 defendant Fuge John hostiler 587702 587702 Fuge, John, of Andever, Hants, hostiler 1
4855063 2312934 2312934 defendant Sampson John gent 587702 587702 Sampson, John, of Andever, Hants, gent 0
4874562 2318989 2318989 defendant Knave William, senior husbandman 587702 587702 Knave, William, senior, of Andever, Hants, husbandman 1
4945705 2340638 2340638 defendant Develyn or Denelyn William shoemaker 587702 587702 Develyn or Denelyn, William, of Andever, Hants, shoemaker 0
4948179 2341403 2341403 defendant Latener Thomas husbandman 587702 587702 Latener, Thomas, of Andever, Hants, husbandman 2
4974132 2349223 2349223 defendant Roley John yeoman 587702 587702 Roley, John, of Andever, Hants, yeoman 0
4974134 2349224 2349224 defendant Roley John   587702 587702 Roley, John, of Andever, hants 0
5013351 2360742 2360742 defendant Payn John gent 587702 587702 Payn, John, of Andever, Hants, gent 1
5067989 2376927 2376927 defendant Role John yeoman 587702 587702 Role, John, of Andever, Hants, yeoman 0
5067991 2376928 2376928 defendant Roley John yeoman 587702 587702 Roley, John, of Andever, Hants, yeoman 0
5077613 2379800 2379800 defendant Andrewe John chapman 587702 587702 Andrewe, John, of Andever, Hants, chapman 4
5077619 2379801 2379801 defendant Andrewe John chapman 587702 587702 Andrewe, John, of Andever, Hants, chapman 4
5080959 2380802 2380802 defendant Andrewe John mercer 587702 587702 Andrewe, John, of Andever, Hants, mercer 0
5085774 2382236 2382236 defendant Prykyere Robert yeoman 587702 587702 Prykyere, Robert, of Andever, Hants, yeoman 0
5098553 2386009 2386009 defendant Bye John gent 587702 587702 Bye, John, of Andever, Hants, gent 1
5107497 2388623 2388623 defendant Taylour Richard clothman 587702 587702 Taylour, Richard, of Andever, Hants, clothman 0
5115317 2390907 2390907 plaintiff Moraunt John mercer 587702 587702 Moraunt, John, of Andever, Hants, mercer 0
5124389 2393582 2393582 defendant Galeys Nicholas ostler 587702 587702 Galeys, Nicholas, of Andever, Hants, ostler 2
5213855 2419781 2419781 defendant Gales or Galeys Nicholas ostler 587702 587702 Gales or Galeys, Nicholas, of Andever, Hants, ostler 0
5217413 2420829 2420829 defendant Galys Nicholas ostler 587702 587702 Galys, Nicholas, of Andever, Hants, ostler 0
5221771 2422063 2422063 defendant Nutkyn Richard mercer 587702 587702 Nutkyn, Richard, of Andever, Hants, mercer 0
5233984 2425529 2425529 defendant Toweker John chapman 587702 587702 Toweker, John, of Andever, Hants, chapman 1
5234014 2425537 2425537 defendant Packer John chapman 587702 587702 Packer, John, of Andever, Hants, chapman 0
5234018 2425538 2425538 defendant Packer John chapman 587702 587702 Packer, John, of Andever, Hants, chapman 0
5251309 2430511 2430511 defendant Fewer Thomas yeoman 587702 587702 Fewer, Thomas, of Andever, Hants, yeoman 0
5267623 2435631 2435631 defendant Nutkyn William yeoman 587702 587702 Nutkyn, William, of Andever, Hants, yeoman 0
5312711 2448839 2448839 defendant Jumper Rchard smith 587702 587702 Jumper, Rchard, of Andever, Hants, smith 1
5349185 2459870 2459870 defendant Basyng Henry husbandman 587702 587702 Basyng, Henry, of Andever, Hants, husbandman 0
5361613 2463655 2463655 defendant Houchyns Thomas hosteler 587702 587702 Houchyns, Thomas, of Andever, Hants, hosteler 0
5445265 2488479 2488479 defendant Curteys (illegible) husbandman 587702 587702 Curteys, _, of Andever, Hants, husbandman 0
5453891 2491054 2491054 defendant Nutkyn William yeoman 587702 587702 (Nutkyn, William, of Andever, Hants, yeoman 3
5481086 2499293 2499293 defendant Curteys Richard husbandman 587702 587702 Curteys, Richard, of Andever, Hants, husbandman 0
5490449 2502038 2502038 defendant Nutkyn Richard chapman 587702 587702 Nutkyn, Richard, of Andever, Hants, chapman 0
5503912 2506137 2506137 defendant Nutkyn William yeoman 587702 587702 (Nutkyn, William, of Andever, Hants, yeoman 3
5506209 2506860 2506860 defendant Couper Henry yeoman 587702 587702 Couper, Henry, of Andever, Hants, yeoman 2
5531155 2514260 2514260 defendant Bedicote Thomas chapman 587702 587702 Bedicote, Thomas, of Andever, Hants, chapman 1
5533894 2515143 2515143 defendant Clement John chapman 587702 587702 Clement, John, of Andever, Hants, chapman 2
5551355 2520431 2520431 defendant Fissher Thomas yeoman 587702 587702 Fissher, Thomas, of Andever, Hants, yeoman 2
5561607 2523381 2523381 defendant Broun Edward chapman 587702 587702 Broun, Edward, of Andever, Hants, chapman 0
5572266 2526440 2526440 defendant Bedycote Thomas chapman 587702 587702 Bedycote, Thomas, of Andever, Hants, chapman 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);