names

106 rows where place_id = 596321

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3624191 1875099 1875099 defendant Gartsey Nicholas gent 596321 596321 Gartsey, Nicholas, of Romsey, Hants, gent 0
3632943 1905119 1905119 defendant Baker Thomas draper 596321 596321 Baker, Thomas, of Romsey, Hants, draper 0
3663829 1914621 1914621 defendant Norton Robert   596321 596321 Norton, Robert, of Romsey, Hants, merchnt 0
3684945 1921425 1921425 defendant Calker John yeroman 596321 596321 Calker, John, of Romsey, Hants, yeroman 0
3685364 1921576 1921576 defendant Norton Robert chapman 596321 596321 Norton, Robert, of Romsey, Hants, chapman 0
3685367 1921577 1921577 defendant Norton Robert chapman 596321 596321 Norton, Robert, of Romsey, Hants, chapman 0
3742648 1939569 1939569 defendant Kydford Richard chapman 596321 596321 Kydford, Richard, of Romsey, Hants, chapman 3
3765207 1946783 1946783 defendant Goldyng Richard shoemaker 596321 596321 (Goldyng, Richard, of Romsey, Hants, shoemaker 1
3765210 1946784 1946784 defendant Hall Ralph (legal representative) 596321 596321 Hall, Ralph, of Romsey, Hants, glover, executors of 0
3777034 1950563 1950563 defendant Knyght Nicholas weaver 596321 596321 Knyght, Nicholas, of Romsey, Hants, weaver 1
3797345 1957059 1957059 defendant Knyght Nicholas weaver 596321 596321 Knyght, Nicholas, of Romsey, Hants, weaver 1
3819830 1964084 1964084 defendant Knyght Nicholas clothmaker 596321 596321 Knyght, Nicholas, of Romsey, Hants, clothmaker 0
3945049 2005364 2005364 defendant Syms John miller 596321 596321 Syms, John, of Romsey, Hants, yeoman, or of West Drayton, Middx, miller 0
3962051 2011309 2011309 defendant Adames James mercer 596321 596321 Adames, James, of Romsey, Hants, mercer 1
3968075 2013458 2013458 defendant Good Peter gent 596321 596321 Good, Peter, of Romsey, Hants, gent 2
3978762 2017149 2017149 defendant Raynold John tanner 596321 596321 Raynold, John, of Romsey, Hants, tanner 0
4012412 2029162 2029162 defendant Dowse Richard gent 596321 596321 Dowse, Richard, of Romsey, Hants, gent 0
4031933 2036088 2036088 defendant Wheler Richard yeoman 596321 596321 Wheler, Richard, of Romsey, Hants, yeoman 0
4066839 2048438 2048438 defendant Kerby George chapman 596321 596321 Kerby, George, of Romsey, Hants, chapman 2
4121948 2068148 2068148 defendant Blosse John clothier 596321 596321 Blosse, John, of Romsey, Hants, clothier 0
4129015 2070680 2070680 defendant Parkyns John (legal representative) 596321 596321 Parkyns, John, of Romsey, Hants, felt maker, administratrix of 3
4129021 2070681 2070681 defendant Parkyns John   596321 596321 Parkyns, John, of Romsey, Hants, felt maker, administratrix if 3
4137892 2073910 2073910 defendant Gauntlett John clothier 596321 596321 Gauntlett, John, of Romsey, Hants, clothier 0
4145104 2076448 2076448 defendant Blosse John clothier 596321 596321 Blosse, John, of Romsey, Hants, clothier 0
4211773 2099673 2099673 defendant Wendover William chapman 596321 596321 Wendover, William, of Romsey, Hants, chapman 1
4235511 2107987 2107987 defendant Smythe Anthony yeoman 596321 596321 Smythe, Anthony, of Romsey, Hants, yeoman 0
4291266 2126946 2126946 defendant Persey Richard husbandman 596321 596321 Persey, Richard, of Romsey, Hants, husbandman 1
4295418 2128448 2128448 defendant Nicholas Richard yeoman 596321 596321 Nicholas, Richard, of Romsey, Hants, yeoman 2
4300975 2130452 2130452 defendant Cowse Nicholas chapman 596321 596321 Cowse, Nicholas, of Romsey, Hants, chapman 0
4319440 2136907 2136907 defendant Raynold John, junior yeoman 596321 596321 Raynold, John, junior, of Romsey, Hants, yeoman 0
4319616 2136974 2136974 defendant Mogridge Judith widow 596321 596321 Mogridge, Judith, of Romsey, Hants, widow 0
4325557 2138922 2138922 defendant Gauntlett John clothier 596321 596321 Gauntlett, John, of Romsey, Hants, clothier 0
4327645 2139566 2139566 defendant Nicholas Richard yeoman 596321 596321 Nicholas, Richard, of Romsey, Hants, yeoman 2
4334654 2141859 2141859 defendant Cowse Nicholas chapman 596321 596321 Cowse, Nicholas, of Romsey, Hants, chapman 0
4340577 2143973 2143973 defendant Foundebacke Alexander   596321 596321 Foundebacke, Alexander, of Romsey, Hants, collar maker 0
4347942 2146532 2146532 defendant Blose John merchant 596321 596321 Blose, John, of Romsey, Hants, clothier, merchant 0
4406798 2166840 2166840 defendant Estman John chapman 596321 596321 Estman, John, of Romsey, Hants, chapman 2
4611833 2234765 2234765 defendant Kyrkeby John   596321 596321 Kyrkeby, John, of Romsey, Hants 0
4639358 2243022 2243022 defendant Kyrkeby John   596321 596321 Kyrkeby, John, of Romsey, Hants 0
4680126 2259394 2259394 defendant Hayne alias Goldsmyth John goldsmith 596321 596321 Hayne alias Goldsmyth, John, of Romsey, Hants, & of Stowe St Edward, goldsmith 0
4692608 2263205 2263205 defendant Michell John   596321 596321 Michell, John, of Romsey, Hants 0
4696874 2264502 2264502 defendant Kyrkeby John esq 596321 596321 Kyrkeby, John, of Romsey, Hants, esq 0
4700746 2265633 2265633 defendant Person John dyer 596321 596321 Person, John, of Romsey, Hants, dyer 2
4705040 2266948 2266948 defendant Berard Thomas (legal representative) 596321 596321 Berard, Thomas, of Romsey, Hants, executrix of 0
4726783 2273647 2273647 defendant Mascall Thomas husbandman 596321 596321 (Mascall, Thomas, of Romsey, Hants, husbandman 2
4757415 2282692 2282692 defendant Person John   596321 596321 Person, John, of Romsey, Hants, chopchurch 3
4770133 2286627 2286627 defendant Westbury Thomas weaver 596321 596321 Westbury, Thomas, of Romsey, Hants, weaver 1
4846811 2310510 2310510 defendant Kirkeby Peter merchant 596321 596321 Kirkeby, Peter, of Romsey, Hants, merchant 3
4854059 2312679 2312679 defendant Teffonte John gent 596321 596321 Teffonte, John, of Romsey, Hants, gent 0
4856655 2313459 2313459 defendant Bocher John husbandman 596321 596321 Bocher, John, of Romsey, Hants, husbandman 8
4879245 2320446 2320446 defendant Fitz William weaver 596321 596321 Fitz, William, of Romsey, Hants, weaver 0
4896174 2325462 2325462 defendant North John draper 596321 596321 North, John, of Romsey, Hants, draper 0
4897716 2325954 2325954 defendant Wyllecokke Walter clerk 596321 596321 Wyllecokke, Walter, of Romsey, Hants, clerk 0
4913601 2330750 2330750 defendant Hancok John   596321 596321 Hancok, John, of Romsey, Hants, forbour 3
4938903 2338558 2338558 defendant Hancok John   596321 596321 Hancok, John, of Romsey, Hants, "forbour" 3
4944756 2340346 2340346 defendant Smyth John smith 596321 596321 Smyth, John, of Romsey, Hants, smith 3
4977063 2350093 2350093 defendant Oxcombe William swayer 596321 596321 Oxcombe, William, of Romsey, Hants, swayer 0
4995558 2355511 2355511 defendant Edwardys John shoemaker 596321 596321 Edwardys, John, of Romsey, Hants, shoemaker 0
4996027 2355662 2355662 defendant Brysham Robert fuller 596321 596321 Brysham, Robert, of Romsey, Hants, fuller 0
4997992 2356260 2356260 defendant Fairle John tanner 596321 596321 Fairle, John, of Romsey, Hants, tanner 0
4997995 2356261 2356261 defendant Fayle John tanner 596321 596321 Fayle, John, of Romsey, Hants, tanner 0
5004275 2358143 2358143 defendant Bomden John fuller 596321 596321 Bomden, John, of Romsey, Hants, fuller 0
5010341 2359893 2359893 defendant Farley John tanner 596321 596321 Farley, John, of Romsey, Hants, tanner 0
5044268 2369916 2369916 defendant Viell Richard weaver 596321 596321 Viell, Richard, of Romsey, Hants, weaver 0
5070669 2377726 2377726 defendant Bannyng John fuller 596321 596321 Bannyng, John, of Romsey, Hants, fuller 0
5074268 2378795 2378795 defendant Bursham Robert fuller 596321 596321 Bursham, Robert, of Romsey, Hants, fuller 0
5077452 2379754 2379754 defendant Worship Richard yeoman 596321 596321 (Worship, Richard, of Romsey, Hants, yeoman 1
5082185 2381168 2381168 defendant Whithorne Peter smith 596321 596321 Whithorne, Peter, of Romsey, Hants, smith 0
5090130 2383483 2383483 defendant Kebyll John gent 596321 596321 (Kebyll, John, of Romsey, Hants, gent 1
5117388 2391518 2391518 defendant Gatreg John butcher 596321 596321 Gatreg, John, of Romsey, Hants, butcher 2
5117392 2391519 2391519 defendant Gatreg John butcher 596321 596321 Gatreg, John, of Romsey, Hants, butcher 2
5130144 2395303 2395303 defendant Alr--- Richard carter 596321 596321 Alr---, Richard, of Romsey, Hants, carter 1
5131483 2395692 2395692 defendant Lovenothe John butcher 596321 596321 Lovenothe, John, of Romsey, Hants, butcher 3
5149482 2400979 2400979 defendant Bradewey John carter 596321 596321 Bradewey, John, of Romsey, Hants, carter 1
5168407 2406476 2406476 defendant Bradewey John carter 596321 596321 Bradewey, John, of Romsey, Hants, carter 1
5168768 2406595 2406595 defendant Heywode William dyer 596321 596321 Heywode, William, of Romsey, Hants, dyer 0
5169266 2406747 2406747 defendant Levenothe John butccher 596321 596321 Levenothe, John, of Romsey, Hants, butccher 3
5183754 2410983 2410983 defendant Croucheman Simon gent 596321 596321 Croucheman, Simon, of Romsey, Hants, gent 0
5184310 2411153 2411153 defendant Bradewey John carter 596321 596321 Bradewey, John, of Romsey, Hants, carter 1
5184861 2411321 2411321 defendant Haywode William dyer 596321 596321 Haywode, William, of Romsey, Hants, dyer 0
5184865 2411322 2411322 defendant Heywode William dyer 596321 596321 Heywode, William, of Romsey, Hants, dyer 0
5184869 2411323 2411323 defendant Heywode William dyer 596321 596321 Heywode, William, of Romsey, Hants, dyer 0
5185903 2411624 2411624 defendant Levenothe John butcher 596321 596321 Levenothe, John, of Romsey, Hants, butcher 3
5188684 2412416 2412416 defendant Hawys John fuller 596321 596321 together with Hawys, John, of Romsey, Hants, fuller 1
5199725 2415667 2415667 defendant Kirkeby John gent 596321 596321 Kirkeby, John, of Romsey, Hants, gent 0
5203995 2416917 2416917 defendant Croucheman Simon gent 596321 596321 Croucheman, Simon, of Romsey, Hants, gent 0
5211221 2419011 2419011 defendant Kirkeby John gent 596321 596321 Kirkeby, John, of Romsey, Hants, gent 0
5216425 2420535 2420535 defendant Pyry John   596321 596321 Pyry, John, of Romsey, Hants, dyer, administrators of 0
5235754 2426033 2426033 defendant Brond John dyer 596321 596321 Brond, John, of Romsey, Hants, dyer 0
5235760 2426034 2426034 defendant Pyry John   596321 596321 Pyry, John, of Romsey, Hants, dyer, administrators of 0
5296549 2443979 2443979 defendant Algare William husbandman 596321 596321 Algare, William, of Romsey, Hants, husbandman 0
5299397 2444797 2444797 defendant Gaterigge John butcher 596321 596321 Gaterigge, John, of Romsey, Hants, butcher 0
5301993 2445550 2445550 defendant Estby John tailor 596321 596321 Estby, John, of Romsey, Hants, tailor 4
5313326 2449024 2449024 defendant Cockys Thomas chapman 596321 596321 Cockys, Thomas, of Romsey, Hants, chapman 0
5362586 2463947 2463947 defendant Bowell Simon mercer 596321 596321 Bowell, Simon, of Romsey, Hants, mercer 0
5365659 2464925 2464925 defendant Bowett Simon chapman 596321 596321 Bowett, Simon, of Romsey, Hants, chapman 4
5368112 2465653 2465653 defendant Taillour John   596321 596321 Taillour, John, of Romsey, Hants, cloth maker 3
5391364 2472607 2472607 defendant Bounde Robert mercer 596321 596321 Bounde, Robert, of Romsey, Hants, mercer 1
5404367 2476321 2476321 defendant Bounde Robert mercer 596321 596321 Bounde, Robert, of Romsey, Hants, mercer 1
5498886 2504606 2504606 defendant Estby John draper 596321 596321 Estby, John, of Romsey, Hants, draper 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);