names

107 rows where place_id = 619838

✎ 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
3732174 1936299 1936299 defendant Tenant Richard yeoman 619838 619838 Tenant, Richard, of Killom, yeoman 1
3944587 2005204 2005204 defendant Doble Christopher laborer 619838 619838 Doble, Christopher, of Killom, laborer 5
3944588 2005204 2005204 defendant Doble Thomas laborer 619838 619838 Doble, Thomas, of Killom, laborer 6
3944589 2005204 2005204 defendant Elwood Robert laborer 619838 619838 Elwood, Robert, of Killom, laborer 7
3944590 2005204 2005204 defendant Netherton Gilbert laborer 619838 619838 Netherton, Gilbert, of Killom, laborer 8
3944591 2005204 2005204 defendant Hirde John laborer 619838 619838 Hirde, John, of Killom, laborer 9
4169070 2084679 2084679 defendant Mylner Thomas husbandman 619838 619838 Mylner, Thomas, of Killom, husbandman 0
4178380 2087913 2087913 defendant Farthinge Marmaduke yeoman 619838 619838 Farthinge, Marmaduke, of Killom, yeoman 1
4178381 2087913 2087913 defendant Jackson Edward yeoman 619838 619838 Jackson, Edward, of Killom, yeoman 2
4225268 2104305 2104305 defendant Gryme Christopher chapman 619838 619838 Gryme, Christopher, of Killom, chapman 0
4442489 2182598 2182598 defendant Dautre Robert   619838 619838 Dautre, Robert, of Killom 0
4467098 2190378 2190378 defendant Radstre William   619838 619838 Radstre, William, of Killom 0
4467100 2190378 2190378 defendant Tomlynson William   619838 619838 Tomlynson, William, of Killom 2
4480238 2194479 2194479 plaintiff Kouperstake Richard   619838 619838 Kouperstake, Richard, of Killom 0
4520672 2206814 2206814 defendant Crawe Robert   619838 619838 Crawe, Robert, of Killom, wright 0
4537196 2211906 2211906 defendant Salvyen George   619838 619838 Salvyen, George, of Killom 0
4548130 2215354 2215354 plaintiff Chapman William   619838 619838 Chapman, William, of Killom 0
4548131 2215354 2215354 defendant Drakelowe John   619838 619838 Drakelowe, John, of Killom 0
4600211 2231294 2231294 defendant Crake Elizabeth   619838 619838 Crake, Elizabeth, of Killom 0
4612673 2235028 2235028 defendant Randolf John   619838 619838 Randolf, John, of Killom 0
4619172 2236993 2236993 defendant Burton William shoemaker 619838 619838 Burton, William, of Killom, shoemaker 0
4620598 2237431 2237431 defendant Salvayn William   619838 619838 Salvayn, William, of Killom 0
4635303 2241878 2241878 defendant Salveyn Thomas   619838 619838 Salveyn, Thomas, of Killom 3
4635304 2241878 2241878 defendant Salveyn William   619838 619838 Salveyn, William, of Killom 4
4635305 2241878 2241878 defendant Skiren Robert   619838 619838 Skiren, Robert, of Killom 5
4635306 2241878 2241878 defendant Salveynman Peter   619838 619838 Salveynman, Peter, of Killom 6
4644148 2244384 2244384 defendant Pete Hugh   619838 619838 Pete, Hugh, of Killom, vicar 0
4644150 2244384 2244384 defendant Hall John   619838 619838 Hall, John, of Killom 2
4655500 2247613 2247613 defendant Proktour John yeoman 619838 619838 Proktour, John, of Killom, yeoman 4
4659638 2248868 2248868 defendant Hall John husbandman 619838 619838 Hall, John, of Killom, husbandman 0
4659640 2248868 2248868 defendant Salvayn William husbandman 619838 619838 Salvayn, William, of Killom, husbandman 2
4659642 2248868 2248868 defendant Wapplyngton William husbandman 619838 619838 Wapplyngton, William, of Killom, husbandman 4
4664625 2250415 2250415 defendant Hall John husbandman 619838 619838 Hall, John, of Killom, husbandman 0
4664627 2250415 2250415 defendant Salvayn William husbandman 619838 619838 Salvayn, William, of Killom, husbandman 2
4664629 2250415 2250415 defendant Waplyngton William husbandman 619838 619838 Waplyngton, William, of Killom, husbandman 4
4668163 2255750 2255750 defendant Gyffray John   619838 619838 Gyffray, John, of killom, franklin 0
4677186 2258482 2258482 defendant Pete Robert yeoman 619838 619838 Pete, Robert, of Killom, yeoman 1
4691538 2262880 2262880 defendant Edne Richard husbandman 619838 619838 Edne, Richard, of Killom, husbandman 0
4691539 2262880 2262880 defendant Geffrayson John husbandman 619838 619838 Geffrayson, John, of Killom, husbandman 1
4691540 2262880 2262880 defendant Hall John husbandman 619838 619838 Hall, John, of Killom, husbandman 2
4691541 2262880 2262880 defendant Middelton Thomas husbandman 619838 619838 Middelton, Thomas, of Killom, husbandman 3
4692287 2263103 2263103 defendant Salvayn William chapman 619838 619838 Salvayn, William, of Killom, chapman 1
4709900 2268455 2268455 defendant Proctour John yeoman 619838 619838 Proctour, John, of Killom, yeoman 3
4711501 2268927 2268927 defendant Skiren Robert husbandman 619838 619838 Skiren, Robert, of Killom, husbandman 0
4711503 2268927 2268927 defendant Salveyne William chapman 619838 619838 Salveyne, William, of Killom, chapman 2
4711608 2268959 2268959 plaintiff Salvan William   619838 619838 Salvan, William, of Killom 0
4713997 2269705 2269705 defendant Marsshall William husbandman 619838 619838 Marsshall, William, of Killom, husbandman 0
4713998 2269705 2269705 defendant Shobyf Alan husbandman 619838 619838 Shobyf, Alan, of Killom, husbandman 1
4741791 2278090 2278090 defendant Halle John (legal representative) 619838 619838 Halle, John, of Killom, executrix of 3
4750387 2280595 2280595 defendant Randolf John husbandman 619838 619838 Randolf, John, of Killom, husbandman 0
4750389 2280596 2280596 defendant Randolf John husbandman 619838 619838 Randolf, John, of Killom, husbandman 0
4755018 2281955 2281955 plaintiff Apilgarth Richard in the (legal representative) 619838 619838 Apilgarth, Richard in the, of Killom, executrix of 0
4762320 2284197 2284197 defendant Badby Adam yeoman 619838 619838 Badby, Adam, of Killom, yeoman 0
4763726 2284644 2284644 defendant Redhed Agnes widow 619838 619838 Redhed, Agnes, of Killom, widow 4
4764511 2284885 2284885 defendant Salvan William chapman 619838 619838 Salvan, William, of Killom, chapman 0
4764989 2285025 2285025 defendant Salveyn William chapman 619838 619838 Salveyn, William, of Killom, chapman 0
4769875 2286551 2286551 defendant Proctur John yeoman 619838 619838 Proctur, John, of Killom, yeoman 1
4772504 2287365 2287365 defendant Alanson Thomas husbandman 619838 619838 Alanson, Thomas, of Killom, husbandman 1
4772505 2287365 2287365 defendant Wryght John miller 619838 619838 Wryght, John, of Killom, miller 2
4776078 2288514 2288514 defendant Damyot William husbandman 619838 619838 Damyot, William, of Killom, husbandman 0
4788411 2292436 2292436 defendant Salvayn William chapman 619838 619838 Salvayn, William, of Killom, chapman 0
4794436 2294399 2294399 defendant Proctor John yeoman 619838 619838 Proctor, John, of Killom, yeoman 1
4794755 2294499 2294499 defendant Salvayn William yeoman 619838 619838 Salvayn, William, of Killom, yeoman 0
4799240 2295940 2295940 defendant Salvayn William husbandman 619838 619838 Salvayn, William, of Killom, husbandman 2
4808257 2298761 2298761 defendant Wyghton John yeoman 619838 619838 Wyghton, John, of Killom, yeoman 0
4815637 2300996 2300996 defendant Danyot William husbandman 619838 619838 Danyot, William, of Killom, husbandman 6
4827715 2304717 2304717 defendant crayke John gent 619838 619838 crayke, John, of Killom, gent 0
4827718 2304717 2304717 defendant Menthorpe John   619838 619838 Menthorpe, John, of Killom, blanket or coverlet weaver 3
4847184 2310618 2310618 defendant Boteler William chapman 619838 619838 Boteler, William, of Killom, chapman 0
4875592 2319323 2319323 defendant Norman William husbandman 619838 619838 Norman, William, of Killom, husbandman 0
4880107 2320688 2320688 defendant Carter Thomas husbandman 619838 619838 Carter, Thomas, of Killom, husbandman 0
4885941 2322470 2322470 defendant Crosse Robert husbandman 619838 619838 Crosse, Robert, of Killom, husbandman 3
4887683 2322977 2322977 defendant Skyrn John husbandman 619838 619838 Skyrn, John, of Killom, husbandman 0
4887684 2322977 2322977 defendant Carter Thomas husbandman 619838 619838 Carter, Thomas, of Killom, husbandman 1
4888745 2323267 2323267 defendant Buttiller William husbandman 619838 619838 Buttiller, William, of Killom, husbandman 0
4903061 2327572 2327572 defendant Moldson Thomas husbandman 619838 619838 Moldson, Thomas, of Killom, husbandman 2
4918542 2332316 2332316 defendant Shoffe Alan husbandman 619838 619838 Shoffe, Alan, of Killom, husbandman 1
4940950 2339194 2339194 defendant Lonthorp John husbandman 619838 619838 Lonthorp, John, of Killom, husbandman 0
4940952 2339194 2339194 defendant Swaynthorp Robert husbandman 619838 619838 Swaynthorp, Robert, of Killom, husbandman 2
4940953 2339194 2339194 defendant Chapman William husbandman 619838 619838 Chapman, William, of Killom, husbandman 3
4969257 2347764 2347764 defendant de Medilton John smith 619838 619838 de Medilton, John, of Killom, smith 0
4984152 2352191 2352191 defendant Freman John husbandman 619838 619838 Freman, John, of Killom, husbandman 0
5012052 2360372 2360372 plaintiff Wyghton John   619838 619838 Wyghton, John, of Killom, formerly bailiff 0
5012054 2360373 2360373 plaintiff Wyghton John   619838 619838 Wyghton, John, of Killom, formerly bailiff 0
5032433 2366368 2366368 defendant Chapman William husbandman 619838 619838 Chapman, William, of Killom, husbandman 0
5032435 2366369 2366369 defendant Dryng William yeoman 619838 619838 Dryng, William, of Killom, yeoman 0
5040998 2368931 2368931 defendant Baron John husbandman 619838 619838 Baron, John, of Killom, husbandman 0
5094773 2384884 2384884 defendant Milys John chaplain 619838 619838 Milys, John, of Killom, chaplain 1
5094787 2384888 2384888 defendant Mylys John husbandman 619838 619838 Mylys, John, of Killom, husbandman 0
5094789 2384888 2384888 defendant Brigham Robert husbandman 619838 619838 Brigham, Robert, of Killom, husbandman 2
5094794 2384890 2384890 defendant Mylys John chaplain 619838 619838 Mylys, John, of Killom, chaplain 1
5191451 2413240 2413240 defendant Chapman William yeoman 619838 619838 Chapman, William, of Killom, yeoman 0
5191452 2413240 2413240 defendant Storrour William miller 619838 619838 Storrour, William, of Killom, miller 1
5191454 2413240 2413240 defendant Wighton Joan widow 619838 619838 Wighton, Joan, of Killom, widow 3
5369171 2465959 2465959 defendant Bell Robert yeoman 619838 619838 Bell, Robert, of Killom, yeoman 2
5379801 2469265 2469265 defendant Foster William yeoman 619838 619838 Foster, William, of Killom, yeoman 0
5630465 2553539 2553539 defendant Swathorp John husbandman 619838 619838 Swathorp, John, of Killom, husbandman 0
5630954 2553691 2553691 defendant Randolf John husbandman 619838 619838 Randolf, John, of Killom, husbandman 0
5630955 2553691 2553691 defendant Hardy John husbandman 619838 619838 Hardy, John, of Killom, husbandman 1
5630956 2553691 2553691 defendant Waplynton William husbandman 619838 619838 Waplynton, William, of Killom, husbandman 2

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