names

159 rows where place_id = 753729

✎ 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
4415443 2169726 2169726 defendant Edenhale William de   753729 753729 Edenhale, William de, of Kirkeby in Kendale 0
4423143 2172095 2172095 defendant Ward John   753729 753729 Ward, John, of Kirkeby in Kendale 1
4423905 2172326 2172326 defendant Edenhale William de   753729 753729 Edenhale, William de, of Kirkeby in Kendale 0
4430421 2174296 2174296 defendant Kypax Henry de (legal representative) 753729 753729 Kypax, Henry de, of Kirkeby in Kendale, vicar, executor of 0
4443582 2182958 2182958 defendant Wryght John   753729 753729 Wryght, John, of Kirkeby in Kendale 0
4448562 2184477 2184477 defendant Williamson Robert   753729 753729 Williamson, Robert, of Kirkeby in Kendale 4
4448566 2184478 2184478 defendant Williamson Robert   753729 753729 Williamson, Robert, of Kirkeby in Kendale 1
4456549 2187070 2187070 defendant Wryght John   753729 753729 Wryght, John, of Kirkeby in Kendale 0
4471280 2191683 2191683 defendant Lister John   753729 753729 Lister, John, of Kirkeby in Kendale 0
4481461 2194895 2194895 plaintiff Lupton John de   753729 753729 Lupton, John de, of Kirkeby in Kendale 0
4487491 2196805 2196805 defendant Leche John   753729 753729 Leche, John, of Kirkeby in Kendale 0
4507327 2202755 2202755 plaintiff Waryner Adam   753729 753729 Waryner, Adam, of Kirkeby in Kendale 0
4526590 2208593 2208593 defendant Clerk Thomas   753729 753729 Clerk, Thomas, of Kirkeby in Kendale 1
4539125 2212498 2212498 defendant Wryght William   753729 753729 Wryght, William, of Kirkeby in Kendale 32
4558419 2218579 2218579 defendant Waryner Adam   753729 753729 Waryner, Adam, of Kirkeby in Kendale 0
4571439 2222652 2222652 plaintiff Alanson William   753729 753729 Alanson, William, of Kirkeby in Kendale 0
4582213 2225875 2225875 defendant Kendale Thomas de   753729 753729 Kendale, Thomas de, of Kirkeby in Kendale 0
4591332 2228646 2228646 defendant Williamson John   753729 753729 Williamson, John, of Kirkeby in Kendale 1
4609623 2234107 2234107 defendant Skynner Robert   753729 753729 Skynner, Robert, of Kirkeby in Kendale 0
4609624 2234107 2234107 defendant Couper Richard   753729 753729 Couper, Richard, of Kirkeby in Kendale 1
4609625 2234107 2234107 defendant Marshall Robert   753729 753729 Marshall, Robert, of Kirkeby in Kendale 2
4612641 2235020 2235020 defendant Esshdale Richard   753729 753729 Esshdale, Richard, of Kirkeby in Kendale 0
4612644 2235020 2235020 defendant Kendale Thomas de   753729 753729 Kendale, Thomas de, of Kirkeby in Kendale 3
4612650 2235022 2235022 defendant Taillour William   753729 753729 Taillour, William, of Kirkeby in Kendale 1
4617094 2236354 2236354 plaintiff Gilpyn John draper 753729 753729 Gilpyn, John, of Kirkeby in Kendale, draper 0
4621075 2237576 2237576 plaintiff Lytster Thomas   753729 753729 Lytster, Thomas, of Kirkeby in Kendale 1
4621078 2237576 2237576 defendant Porter John   753729 753729 Porter, John, of Kirkeby in Kendale 2
4621081 2237577 2237577 plaintiff Lytster Thomas   753729 753729 Lytster, Thomas, of Kirkeby in Kendale 1
4621084 2237577 2237577 defendant Wilson John   753729 753729 Wilson, John, of Kirkeby in Kendale, shoe maker 2
4622656 2238065 2238065 defendant Sleddale Thomas de   753729 753729 Sleddale, Thomas de, of Kirkeby in Kendale 0
4622657 2238065 2238065 defendant Knyghtman Henry   753729 753729 Knyghtman, Henry, of Kirkeby in Kendale 1
4622660 2238065 2238065 defendant Roweson Thomas   753729 753729 Roweson, Thomas, of Kirkeby in Kendale 4
4622661 2238065 2238065 defendant Halhede John   753729 753729 Halhede, John, of Kirkeby in Kendale 5
4622662 2238065 2238065 defendant Hunter John   753729 753729 Hunter John, of Kirkeby in Kendale 6
4622663 2238065 2238065 defendant Colynson William   753729 753729 Colynson, William, of Kirkeby in Kendale 7
4622664 2238066 2238066 plaintiff Lytster Thomas   753729 753729 Lytster, Thomas, of Kirkeby in Kendale 0
4622668 2238067 2238067 plaintiff Lytster Thomas   753729 753729 Lytster, Thomas, of Kirkeby in Kendale 0
4622669 2238067 2238067 defendant Mawenes William   753729 753729 Mawenes, William, of Kirkeby in Kendale 0
4622670 2238067 2238067 defendant Bowere Alexander   753729 753729 Bowere, Alexander, of Kirkeby in Kendale 1
4622675 2238067 2238067 defendant Wryght William   753729 753729 Wryght, William, of Kirkeby in Kendale 6
4622676 2238067 2238067 defendant Alanson John   753729 753729 Alanson, John, of Kirkeby in Kendale 7
4623610 2238364 2238364 defendant Dokwra Robert de   753729 753729 Dokwra, Robert de, of Kirkeby in Kendale 0
4631531 2240753 2240753 defendant Litster Thomas   753729 753729 Litster, Thomas, of Kirkeby in Kendale 0
4647081 2245204 2245204 defendant Knyghtman Henry dyer 753729 753729 Knyghtman, Henry, of Kirkeby in Kendale, dyer 0
4657712 2248298 2248298 defendant de Farlton John yeoman 753729 753729 de Farlton, John, of Kirkeby in Kendale, yeoman 0
4660380 2249074 2249074 defendant de Lamplogh Adam draper 753729 753729 de Lamplogh, Adam, of Kirkeby in Kendale, draper 0
4660381 2249074 2249074 defendant de Burgh Robert gent 753729 753729 de Burgh, Robert, of Kirkeby in Kendale, gent 1
4660382 2249074 2249074 defendant de Thornhowe Henry mercer 753729 753729 de Thornhowe, Henry, of Kirkeby in Kendale, mercer 2
4660383 2249074 2249074 defendant Wilkynson John chapman 753729 753729 Wilkynson, John, of Kirkeby in Kendale, chapman 3
4660384 2249074 2249074 defendant Alanson John cordwainer 753729 753729 Alanson, John, of Kirkeby in Kendale, cordwainer 4
4663294 2249991 2249991 defendant de Pountfreyt Thomas spicer 753729 753729 de Pountfreyt, Thomas, of Kirkeby in Kendale, spicer 0
4663295 2249991 2249991 defendant Bonefaunt Thomas mercer 753729 753729 Bonefaunt, Thomas, of Kirkeby in Kendale, mercer 1
4669360 2256125 2256125 defendant Preston Thomas dyer 753729 753729 Preston, Thomas, of Kirkeby in Kendale, dyer 1
4670521 2256456 2256456 defendant Harpem Magaret widow 753729 753729 Harpem, Magaret, of Kirkeby in Kendale, widow 1
4674453 2257620 2257620 plaintiff Dyconson Thomas   753729 753729 Dyconson, Thomas, of Kirkeby in Kendale 0
4674454 2257620 2257620 defendant Dyssher John yeoman 753729 753729 Dyssher, John, of Kirkeby in Kendale, yeoman 0
4675097 2257823 2257823 defendant Wryght William dyer 753729 753729 Wryght, William, of Kirkeby in Kendale, dyer 0
4690008 2262427 2262427 plaintiff Water Thomas de draper 753729 753729 Water, Thomas de, of Kirkeby in Kendale, draper 0
4712119 2269101 2269101 plaintiff Wilson Thomas cardmaker 753729 753729 Wilson, Thomas, of Kirkeby in Kendale, cardmaker 3
4714124 2269747 2269747 defendant Dokwra Robert   753729 753729 Dokwra, Robert, of Kirkeby in Kendale, franklin 0
4720247 2271675 2271675 defendant Haigarth Thomas tailor 753729 753729 Haigarth, Thomas, of Kirkeby in Kendale, tailor 0
4722929 2272487 2272487 defendant Tomson Robynson William yeoman 753729 753729 Tomson Robynson, William, of Kirkeby in Kendale, yeoman 3
4724142 2272845 2272845 defendant Sleddale Margaret widow 753729 753729 Sleddale, Margaret, of Kirkeby in Kendale, widow 0
4734929 2276083 2276083 defendant Bernecastell John shoemaker 753729 753729 Bernecastell, John, of Kirkeby in Kendale, shoemaker 3
4735013 2276099 2276099 defendant Halhed John yeoman 753729 753729 Halhed, John, of Kirkeby in Kendale, yeoman 0
4736625 2276586 2276586 defendant Dokwra Roger yeoman 753729 753729 Dokwra, Roger, of Kirkeby in Kendale, yeoman 0
4736671 2276598 2276598 plaintiff Threlkeld John   753729 753729 Threlkeld, John, of Kirkeby in Kendale 0
4737776 2276920 2276920 defendant Redemane Thomas de yeoman 753729 753729 Redemane, Thomas de, of Kirkeby in Kendale, yeoman 1
4744763 2278984 2278984 defendant Topclyff John dyer 753729 753729 Topclyff, John, of Kirkeby in Kendale, dyer 1
4744764 2278984 2278984 defendant Preston Thomas (legal representative) 753729 753729 Preston, Thomas, of Kirkeby in Kendale, dyer, executrix of 2
4762041 2284112 2284112 defendant Warynner Adam yeoman 753729 753729 Warynner, Adam, of Kirkeby in Kendale, yeoman 0
4762043 2284112 2284112 defendant Lord Robert yeoman 753729 753729 Lord, Robert, of Kirkeby in Kendale, yeoman 2
4770098 2286618 2286618 defendant Persyvell John dyer 753729 753729 Persyvell, John, of Kirkeby in Kendale, dyer 0
4778845 2289358 2289358 defendant Appelby Robert shoemaker 753729 753729 Appelby, Robert, of Kirkeby in Kendale, shoemaker 0
4779035 2289421 2289421 defendant Ketelwell John mercer 753729 753729 Ketelwell, John, of Kirkeby in Kendale, mercer 1
4779036 2289421 2289421 defendant Litster Robert clerk 753729 753729 Litster, Robert, of Kirkeby in Kendale, clerk 2
4779046 2289424 2289424 defendant Lytster Robert   753729 753729 Lytster, Robert, of Kirkeby in Kendale, chaplain, parson of Herthill 1
4779781 2289669 2289669 defendant Haygarth Thomas tailor 753729 753729 Haygarth, Thomas, of Kirkeby in Kendale, tailor 0
4782372 2290490 2290490 defendant Coke John yeoman 753729 753729 Coke, John, of Kirkeby in Kendale, yeoman 0
4783999 2291006 2291006 defendant Cayrons John husbandman 753729 753729 Cayrons, John, of Kirkeby in Kendale, husbandman 0
4784100 2291027 2291027 plaintiff de Watir Thomas draper 753729 753729 de Watir, Thomas, of Kirkeby in Kendale, draper 0
4784101 2291027 2291027 defendant heir of Wilson John shoemaker 753729 753729 heir of Wilson, John, of Kirkeby in Kendale, shoemaker 0
4784197 2291054 2291054 defendant Wilkynson John chapman 753729 753729 Wilkynson, John, of Kirkeby in Kendale, chapman 0
4788079 2292339 2292339 defendant Cayrons or Cayrous John gent 753729 753729 Cayrons or Cayrous, John, of Kirkeby in Kendale, gent 0
4788211 2292383 2292383 defendant Layburn John yeoman 753729 753729 Layburn, John, of Kirkeby in Kendale, yeoman 4
4794158 2294309 2294309 defendant Brigges Robert yeoman 753729 753729 Brigges, Robert, of Kirkeby in Kendale, yeoman 0
4794734 2294492 2294492 defendant Persyvell John dyer 753729 753729 Persyvell, John, of Kirkeby in Kendale, dyer 0
4805695 2297992 2297992 defendant Wherton William gent 753729 753729 Wherton, William, of Kirkeby in Kendale, gent 0
4807883 2298651 2298651 defendant Syll Thomas yeoman 753729 753729 Syll, Thomas, of Kirkeby in Kendale, yeoman 2
4807885 2298651 2298651 defendant Gibonson John husbandman 753729 753729 Gibonson, John, of Kirkeby in Kendale, husbandman 4
4814529 2300652 2300652 defendant Preston William gent 753729 753729 Preston, William, of Kirkeby in Kendale, gent 0
4816071 2301119 2301119 plaintiff Lord Robert   753729 753729 Lord, Robert, of Kirkeby in Kendale 0
4818694 2301932 2301932 defendant Pullowe Adam chapman 753729 753729 Pullowe, Adam, of Kirkeby in kendale, chapman 1
4822130 2302999 2302999 defendant de Dokwra Thomas de yeoman 753729 753729 de Dokwra, Thomas de, of Kirkeby in Kendale, yeoman 0
4829893 2305393 2305393 defendant Porter John chapman 753729 753729 Porter, John, of Kirkeby in Kendale, chapman 2
4835889 2307207 2307207 defendant Porter John chapman 753729 753729 Porter, John, of Kirkeby in Kendale, chapman 0
4837452 2307649 2307649 defendant Boule William shoemaker 753729 753729 Boule, William, of Kirkeby in Kendale, shoemaker 0
4851930 2312038 2312038 defendant Wilson John yeoman 753729 753729 Wilson, John, of Kirkeby in Kendale, yeoman 1
4853059 2312376 2312376 defendant Makreth William yeoman 753729 753729 Makreth, William, of Kirkeby in Kendale, yeoman 1
4857135 2313613 2313613 defendant Brygges John gent 753729 753729 Brygges, John, of Kirkeby in Kendale, gent 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);