names

94 rows where place_id = 761327

✎ 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
4478039 2193801 2193801 defendant Dyer William   761327 761327 Dyer, William, of Wytteney 1
4511101 2203923 2203923 defendant Hassebery Michael   761327 761327 Hassebery, Michael, of Wytteney 0
4522930 2207503 2207503 defendant Wodewar Thomas   761327 761327 (Wodewar, Thomas, of Wytteney 1
4532213 2210339 2210339 defendant Hore William   761327 761327 Hore, William, of Wytteney 1
4584268 2226491 2226491 defendant Morys James   761327 761327 Morys, James, of Wytteney 1
4588875 2227895 2227895 defendant Assheby Michael   761327 761327 Assheby, Michael, of Wytteney 0
4590255 2228324 2228324 plaintiff Maior Thomas   761327 761327 Maior, Thomas, of Wytteney 0
4602449 2231987 2231987 defendant Webbe Nicholas   761327 761327 Webbe, Nicholas, of Wytteney 0
4605745 2232914 2232914 defendant Welowe John   761327 761327 Welowe, John, of Wytteney 0
4617170 2236380 2236380 defendant Glover John   761327 761327 Glover, John, of Wytteney 0
4617171 2236380 2236380 defendant Glover Richard   761327 761327 Glover, Richard, of Wytteney 1
4634332 2241583 2241583 defendant Boner William   761327 761327 Boner, William, of Wytteney 0
4634339 2241585 2241585 defendant Rede Edward   761327 761327 Rede, Edward, of Wytteney 3
4662296 2249680 2249680 defendant Whittyngton Thomas chaplain 761327 761327 Whittyngton, Thomas, of Wytteney, chaplain 1
4662299 2249681 2249681 defendant Whytyngton Thomas chaplain 761327 761327 Whytyngton, Thomas, of Wytteney, chaplain 1
4662518 2249745 2249745 defendant Cusson William ostler 761327 761327 Cusson, William, of Wytteney, ostler 1
4662521 2249746 2249746 defendant Cusson William ostler 761327 761327 Cusson, William, of Wytteney, ostler 1
4662841 2249840 2249840 plaintiff Fyssher Thomas   761327 761327 Fyssher, Thomas, of Wytteney 0
4663064 2249911 2249911 plaintiff Cokayn John   761327 761327 Cokayn, John, of Wytteney 1
4663065 2249911 2249911 defendant Gille Nicholas husbandman 761327 761327 Gille, Nicholas, of Wytteney, husbandman 0
4663288 2249988 2249988 defendant Wytteney John weaver 761327 761327 Wytteney, John, of Wytteney, weaver 0
4663990 2250223 2250223 defendant Schifford William butcher 761327 761327 Schifford, William, of Wytteney, butcher 0
4663991 2250223 2250223 defendant Flecchere John fletcher 761327 761327 Flecchere, John, of Wytteney, fletcher 1
4679121 2259077 2259077 defendant Morys James tanner 761327 761327 Morys, James, of Wytteney, tanner 0
4710076 2268506 2268506 defendant Maryote John chapman 761327 761327 Maryote, John, of Wytteney, chapman 1
4720034 2271613 2271613 defendant Cussun Thomas clerk & vicar 761327 761327 Cussun, Thomas, of Wytteney, clerk & vicar 2
4730251 2274665 2274665 defendant Curson Thomas clerk 761327 761327 Curson, Thomas, of Wytteney, clerk 0
4738076 2277012 2277012 defendant Barbour John tanner 761327 761327 Barbour, John, of Wytteney, tanner 0
4738077 2277012 2277012 defendant Bannyng John weaver 761327 761327 Bannyng, John, of Wytteney, weaver 1
4738768 2277214 2277214 defendant Barton John husbandman 761327 761327 Barton, John, of Wytteney, husbandman 0
4778265 2289184 2289184 defendant Osteler John ostler 761327 761327 Osteler, John, of Wytteney, ostler 0
4782284 2290462 2290462 defendant Buntyng Thomas woolman 761327 761327 Buntyng, Thomas, of Wytteney, woolman 0
4803120 2297166 2297166 defendant Warde Richard husbandman 761327 761327 Warde, Richard, of Wytteney, husbandman 0
4803121 2297166 2297166 defendant Webbe John weaver 761327 761327 Webbe, John, of Wytteney, weaver 1
4804771 2297692 2297692 plaintiff Bovere William   761327 761327 Bovere, William, of Wytteney, bailiff of the Liberty of the Bishop of Winchester 0
4804772 2297692 2297692 defendant Hoode John tanner 761327 761327 Hoode, John, of Wytteney, junior, tanner 0
4804773 2297693 2297693 plaintiff Bovere William   761327 761327 Bovere, William, of Wytteney, bailiff of the Liberty of the Bishop of Winchester 0
4804774 2297693 2297693 defendant Martyn John husbandman 761327 761327 Martyn, John, of Wytteney, husbandman 0
4843487 2309482 2309482 defendant Skynner Richard skinner 761327 761327 Skynner, Richard, of Wytteney, skinner 0
4843614 2309525 2309525 defendant Morys James tanner 761327 761327 Morys, James, of Wytteney, tanner 0
4843615 2309525 2309525 defendant Morys John husbandman 761327 761327 Morys, John, of Wytteney, husbandman 1
4855805 2313189 2313189 defendant Halygrene or Halygreve John shoemaker 761327 761327 Halygrene or Halygreve, John, of Wytteney, shoemaker 1
4883457 2321746 2321746 defendant Kykkys John husbandman 761327 761327 Kykkys, John, of Wytteney, husbandman 1
4883458 2321746 2321746 defendant Dustlyng Thomas husbandman 761327 761327 Dustlyng, Thomas, of Wytteney, husbandman 2
4892368 2324350 2324350 defendant Gayt William husbandman 761327 761327 Gayt, William, of Wytteney, husbandman 0
4892369 2324350 2324350 defendant Boner or Bouer William fuller 761327 761327 Boner or Bouer, William, of Wytteney, fuller 1
4893877 2324786 2324786 defendant Skynner Richard skinner 761327 761327 Skynner, Richard, of Wytteney, skinner 0
4898275 2326122 2326122 defendant Martyn John woolman 761327 761327 Martyn, John, of Wytteney, woolman 0
4902611 2327437 2327437 defendant Dyere Henry dyer 761327 761327 Dyere, Henry, of Wytteney, dyer 0
4905292 2328249 2328249 defendant Skynner Richard skinner 761327 761327 Skynner, Richard, of Wytteney, skinner 0
4928420 2335312 2335312 defendant Wydyr Michael chapman 761327 761327 Wydyr, Michael, of Wytteney, chapman 0
4928421 2335312 2335312 defendant Couper John cooper 761327 761327 Couper, John, of Wytteney, cooper 1
4929790 2335729 2335729 defendant Gayte William chapman 761327 761327 Gayte, William, of Wytteney, chapman 0
4934552 2337201 2337201 defendant Mager Thomas gent 761327 761327 Mager, Thomas, of Wytteney, gent 0
4942126 2339521 2339521 defendant Bydde John husbandman 761327 761327 Bydde, John, of Wytteney, husbandman 0
5012251 2360433 2360433 defendant Sclatter William yeoman 761327 761327 Sclatter, William, of Wytteney, yeoman 0
5027564 2364939 2364939 defendant Wrenne Nicholas husbandman 761327 761327 Wrenne, Nicholas, of Wytteney, husbandman 3
5029038 2365364 2365364 defendant Brayn John fuller 761327 761327 Brayn, John, of Wytteney, fuller 0
5029039 2365364 2365364 defendant Staunton John weaver 761327 761327 Staunton, John, of Wytteney, weaver 1
5057409 2373785 2373785 defendant Brokyng alias Tayler Thomas tailor 761327 761327 Brokyng alias Tayler, Thomas, of Wytteney, tailor 1
5057410 2373785 2373785 defendant Felawe William   761327 761327 Felawe, William, of Wytteney courser 2
5112155 2389940 2389940 defendant Tailour alias Norys William tailor 761327 761327 Tailour alias Norys, William, of Wytteney, tailor 1
5117228 2391470 2391470 defendant Martyn Thomas tailor 761327 761327 Martyn, Thomas, of Wytteney, tailor 0
5134846 2396692 2396692 defendant Wever Thomas weaver 761327 761327 Wever, Thomas, of Wytteney, weaver 3
5256849 2432272 2432272 defendant Gammound Thomas yeoman 761327 761327 Gammound, Thomas, of Wytteney, yeoman 0
5313914 2449183 2449183 plaintiff Walker William   761327 761327 (Walker, William, of Wytteney 1
5340599 2457261 2457261 defendant Box Robert fuller 761327 761327 Box, Robert, of Wytteney, fuller 0
5340600 2457261 2457261 defendant Honkyn or Houkyn John baker 761327 761327 Honkyn or Houkyn, John, of Wytteney, baker 1
5340601 2457261 2457261 defendant Box William fuller 761327 761327 Box, William, of Wytteney, fuller 2
5355258 2461717 2461717 defendant Wady William miller 761327 761327 Wady, William, of Wytteney, miller 1
5355259 2461717 2461717 defendant Walker alias Parker William yeoman 761327 761327 Walker alias Parker, William, of Wytteney, yeoman 2
5355260 2461717 2461717 defendant Box William fuller 761327 761327 Box, William, of Wytteney, fuller 3
5355261 2461717 2461717 defendant Foorde Roger chapman 761327 761327 Foorde, Roger, of Wytteney, chapman 4
5399858 2475052 2475052 defendant Fourde Richard chapman 761327 761327 Fourde, Richard, of Wytteney, chapman 1
5399859 2475052 2475052 defendant Hosyer Edward chapman 761327 761327 Hosyer, Edward, of Wytteney, chapman 2
5421511 2481366 2481366 defendant Fourde Richard chapman 761327 761327 Fourde, Richard, of Wytteney, chapman 1
5421512 2481366 2481366 defendant Hosyer Edward chapman 761327 761327 Hosyer, Edward, of Wytteney, chapman 2
5423135 2481879 2481879 defendant Cockyn John yeoman 761327 761327 Cockyn, John, of Wytteney, yeoman 1
5427885 2483293 2483293 defendant Fourde Richard chapman 761327 761327 Fourde, Richard, of Wytteney, chapman 1
5427886 2483293 2483293 defendant Hosyer Edward chapman 761327 761327 Hosyer, Edward, of Wytteney, chapman 2
5429994 2483910 2483910 plaintiff Gyllon Thomas   761327 761327 Gyllon, Thomas, of Wytteney, bailiff 1
5429995 2483910 2483910 defendant Hosyer Edward chapman 761327 761327 Hosyer, Edward, of Wytteney, chapman 0
5429996 2483910 2483910 defendant Derby John yeoman 761327 761327 Derby, John, of Wytteney, yeoman 1
5430366 2484017 2484017 defendant Spycer Edward chapman 761327 761327 Spycer, Edward, of Wytteney, chapman 2
5446810 2488944 2488944 defendant Hosyer Edward chapman 761327 761327 Hosyer, Edward, of Wytteney, chapman 0
5446811 2488944 2488944 defendant Derby John yeoman 761327 761327 Derby, John, of Wytteney, yeoman 1
5446855 2488955 2488955 plaintiff Gyllon Thomas   761327 761327 Gyllon, Thomas, of wytteney, bailiff 1
5446856 2488955 2488955 defendant Hosyer Edward chapman 761327 761327 Hosyer, Edward, of Wytteney, chapman 0
5446857 2488955 2488955 defendant Derby John yeoman 761327 761327 Derby, John, of Wytteney, yeoman 1
5500046 2504969 2504969 plaintiff Ricardes alias Fermour Richard, senior (legal representative) 761327 761327 Ricardes alias Fermour, Richard, senior, of Wytteney, executrix of 0
5547290 2519219 2519219 defendant Kokkys John, senior butcher 761327 761327 Kokkys, John, senior, of Wytteney, butcher 0
5547291 2519219 2519219 defendant Kokkys John, junior butcher 761327 761327 Kokkys, John, junior, of Wytteney, butcher 1
5631637 2553906 2553906 defendant Drake William dyer 761327 761327 Drake, William, of Wytteney, dyer 2
5631645 2553907 2553907 defendant Drake William dyer 761327 761327 Drake, William, of Wytteney, dyer 3

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