names

68 rows where place_id = 595147

✎ 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
3619131 1873587 1873587 defendant Mustell or Muscell Thomas butcher 595147 595147 Mustell or Muscell, Thomas, of Wilton, Wilts, butcher 0
3734579 1937060 1937060 defendant Semer Walter gent 595147 595147 Semer, Walter, of Wilton, Wilts, gent 3
3906839 1992577 1992577 defendant Grey Walter yeoman 595147 595147 Grey, Walter, of Wilton, Wilts, yeoman 0
3929814 2000310 2000310 defendant Cheffynche John   595147 595147 Cheffynche, John, of Wilton, Wilts, norse corser 0
3950670 2007307 2007307 defendant Potycarye John yeoman 595147 595147 Potycarye, John, of Wilton, Wilts, yeoman 0
4034850 2037140 2037140 plaintiff Hayes Thomas yeoman 595147 595147 Hayes, Thomas, of Wilton, Wilts, clothier, yeoman 0
4061077 2046369 2046369 defendant Holcrofte William butcher 595147 595147 Holcrofte, William, of Wilton, Wilts, butcher 1
4092632 2057674 2057674 defendant Bourne John   595147 595147 Bourne, John, of Wilton, Wilts, clerk, Master of Arts, Oxford University 0
4097146 2059302 2059302 defendant Mathewe Edmund   595147 595147 Mathewe, Edmund, of Wilton, Wilts, gent, servant with Earl of Pembroke 0
4121503 2067985 2067985 defendant Uvedall John esq 595147 595147 Uvedall, John, of Wilton, Wilts, gent, or of London, esq 0
4131472 2071576 2071576 defendant Garth William clerk 595147 595147 Garth, William, of Wilton, Wilts, clerk 1
4162884 2082547 2082547 defendant Hayes Thomas, senior yeoman 595147 595147 Hayes, Thomas, senior, of Wilton, Wilts, yeoman 0
4204541 2097137 2097137 defendant Morrys George clerk 595147 595147 Morrys, George, of Wilton, Wilts, clerk 1
4214204 2100486 2100486 defendant Chatfeld Walter clerk 595147 595147 Chatfeld, Walter, of Wilton, Wilts, or of Petersfeylde, Hants, clerk 0
4231050 2106360 2106360 defendant Hayes Thomas gent 595147 595147 Hayes, Thomas, of Wilton, Wilts, gent 0
4287883 2125715 2125715 defendant Androwes Thomas yeoman 595147 595147 Androwes, Thomas, of Wilton, Wilts, or of Frome, yeoman 0
4287885 2125716 2125716 defendant Barnes Walter yeoman 595147 595147 Barnes, Walter, of Wilton, Wilts, or of Frome, Soms, yeoman 0
4287887 2125717 2125717 defendant Leversedge Edmund esq 595147 595147 Leversedge, Edmund, of Wilton, Wilts, or of Vallis, Frome Selwood, Soms, esq 0
4639345 2243018 2243018 defendant Bakere John   595147 595147 Bakere, John, of Wilton, Wilts 0
4711029 2268807 2268807 defendant Dresser William yeoman 595147 595147 Dresser, William, of Wilton, Wilts, yeoman 0
4712785 2269312 2269312 defendant Scotte John gent 595147 595147 Scotte, John, of Wilton, Wilts, gent 2
4712814 2269317 2269317 defendant Scotte John gent 595147 595147 Scotte, John, of Wilton, Wilts, gent 2
4719907 2271571 2271571 defendant atte Nende John yeoman 595147 595147 atte Nende, John, of Wilton, Wilts, yeoman 2
4721172 2271955 2271955 defendant Harleston John draper 595147 595147 Harleston, John, of Wilton, Wilts, draper 4
4737818 2276931 2276931 defendant Roland Thomas chaplain 595147 595147 Roland, Thomas, of Wilton, Wilts, chaplain 5
4760909 2283753 2283753 defendant Cheny William (legal representative) 595147 595147 Cheny, William, of Wilton, Wilts, knight & lord of Totill, executrix of 0
4767885 2285930 2285930 defendant Swanlond Henry merchant 595147 595147 Swanlond, Henry, of Wilton, Wilts, merchant 2
4793970 2294242 2294242 defendant Swanlond Henry merchant 595147 595147 Swanlond, Henry, of Wilton, Wilts, merchant 4
4814340 2300593 2300593 defendant Lamden Henry dyer 595147 595147 Lamden, Henry, of Wilton, Wilts, dyer 0
4819024 2302030 2302030 defendant Alwyn Thomas   595147 595147 Alwyn, Thomas, of Wilton, Wilts, franklin 0
4821885 2302920 2302920 defendant Whitehorn John gent 595147 595147 Whitehorn, John, of Wilton, Wilts, gent 1
4837598 2307692 2307692 defendant Whithorn John gent 595147 595147 Whithorn, John, of Wilton, Wilts, gent 3
4878434 2320198 2320198 defendant Waleys Henry butcher 595147 595147 Waleys, Henry, of Wilton, Wilts, butcher 0
4929137 2335534 2335534 defendant Fen John   595147 595147 Fen, John, of Wilton, Wilts, franklin 0
4929162 2335540 2335540 defendant Fen John   595147 595147 Fen, John, of Wilton, Wilts, franklin 0
4941831 2339446 2339446 defendant Russell William gent 595147 595147 Russell, William, of Wilton, Wilts, gent 2
4954616 2343336 2343336 defendant Fen John   595147 595147 Fen, John, of Wilton, Wilts, franklin 0
4964751 2346368 2346368 defendant Pyper Robert butcher 595147 595147 Pyper, Robert, of Wilton, Wilts, butcher 1
5037346 2367793 2367793 defendant atte Fenne John husbandman 595147 595147 atte Fenne, John, of Wilton, Wilts, husbandman 4
5038778 2368242 2368242 defendant Mortymer William butcher 595147 595147 Mortymer, William, of Wilton, Wilts, butcher 1
5047821 2370965 2370965 defendant Smyth William smith 595147 595147 Smyth, William, of Wilton, Wilts, smith 0
5094526 2384808 2384808 defendant Harries John merchant 595147 595147 Harries, John, of Wilton, Wilts, merchant 0
5094545 2384816 2384816 defendant Blyke John tucker 595147 595147 Blyke, John, of Wilton, Wilts, tucker 1
5126334 2394183 2394183 defendant Touke John gent 595147 595147 Touke, John, of Wilton, Wilts, gent 0
5131366 2395664 2395664 defendant Lambard Richard gent 595147 595147 Lambard, Richard, of Wilton, Wilts, gent 0
5143126 2399125 2399125 defendant Cole John   595147 595147 Cole, John, of Wilton, Wilts, mason 0
5144982 2399682 2399682 defendant Touke John gent 595147 595147 Touke, John, of Wilton, Wilts, gent 0
5145005 2399685 2399685 defendant Touke John gent 595147 595147 Touke, John, of Wilton, Wilts, gent 0
5145024 2399690 2399690 defendant Cole John   595147 595147 Cole, John, of Wilton, Wilts, mason 0
5150853 2401392 2401392 defendant Lambard Richard gent 595147 595147 Lambard, Richard, of Wilton, Wilts, gent 0
5165672 2405701 2405701 defendant Touke John gent 595147 595147 Touke, John, of Wilton, Wilts, gent 0
5179944 2409866 2409866 defendant Cole John   595147 595147 Cole, John, of Wilton, Wilts, mason 0
5212999 2419539 2419539 defendant Skreven Robert yeoman 595147 595147 Skreven, Robert, of Wilton, Wilts, yeoman 2
5245343 2428796 2428796 defendant Toke John gent 595147 595147 Toke, John, of Wilton, Wilts, gent 4
5245367 2428801 2428801 defendant Toke John gent 595147 595147 Toke, John, of Wilton, Wilts, gent 4
5256767 2432239 2432239 defendant Style William yeoman 595147 595147 Style, William, of Wilton, Wilts, yeoman 1
5265389 2434931 2434931 defendant Toweke John gent 595147 595147 Toweke, John, of Wilton, Wilts, gent 0
5304226 2446272 2446272 defendant Tuoke John   595147 595147 Tuoke, John, of Wilton, Wilts 0
5326504 2453013 2453013 defendant Frye William clothmaker 595147 595147 Frye, William, of Wilton, Wilts, clothmaker 0
5327092 2453180 2453180 defendant Broke William dyer 595147 595147 Broke, William, of Wilton, Wilts, dyer 0
5370178 2466258 2466258 defendant Pole John gent 595147 595147 Pole, John, of Wilton, Wilts, gent 0
5491492 2502338 2502338 defendant Frank Richard butcher 595147 595147 Frank, Richard, of Wilton, Wilts, butcher 1
5513973 2509218 2509218 plaintiff Poole John (legal representative) 595147 595147 Poole, John, of Wilton, Wilts, esq, administrator of 0
5525994 2512724 2512724 defendant Baker Thomas clerk 595147 595147 Baker, Thomas, of Wilton, Wilts, clerk 0
5537290 2516150 2516150 defendant Crede Henry husbandman 595147 595147 Crede, Henry, of Wilton, Wilts, husbandman 2
5542468 2517768 2517768 defendant Hayne William butcher 595147 595147 Hayne, William, of Wilton, Wilts, butcher 1
5549729 2519955 2519955 defendant Wroughton John, junior esq 595147 595147 Wroughton, John, junior, of Wilton, Wilts, esq 7
5573496 2526807 2526807 defendant Willughby Anthony esq 595147 595147 Willughby, Anthony, of Wilton, Wilts, esq 2

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