names

64 rows where place_id = 586041

✎ 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
3587764 1863820 1863820 defendant Crosse Alice widow 586041 586041 Crosse, Alice, of Old Bokenham, widow 0
3593488 1865597 1865597 defendant Nowte Peter husbandman 586041 586041 Nowte, Peter, of Old Bokenham, husbandman 0
3593490 1865597 1865597 defendant Coldrede John husbandman 586041 586041 Coldrede, John, of Old Bokenham, husbandman 2
3662500 1914187 1914187 plaintiff (not given) John prior of Millgate 586041 586041 Millgate, John, of Old Bokenham, prior of the house and church of St James 0
3662502 1914188 1914188 plaintiff (not given) John prior of Millgate 586041 586041 Millgate, John, of Old Bokenham, prior of the house and church of St James 0
3678342 1919280 1919280 defendant Parkyn John   586041 586041 Parkyn, John, of Old Bokenham, wheelwright 0
3710430 1929580 1929580 defendant Cokke John laborer 586041 586041 Cokke, John, of Old Bokenham, laborer 4
3818642 1963734 1963734 defendant Same Robert chaplain 586041 586041 Same, Robert, of Old Bokenham, chaplain 0
3828636 1966834 1966834 defendant Wellys William weaver 586041 586041 Wellys, William, of Old Bokenham, weaver 3
3829222 1967024 1967024 defendant Busshe Richard laborer 586041 586041 Busshe, Richard, of Old Bokenham, laborer 1
3829225 1967024 1967024 defendant Crane George tailor 586041 586041 Crane, George, of Old Bokenham, tailor 4
3886067 1985592 1985592 defendant Wylkynson Hugh gent 586041 586041 Wylkynson, Hugh, of Old Bokenham, gent 0
3952029 2007774 2007774 defendant Amyas Richard husbandman 586041 586041 Amyas, Richard, of Old Bokenham, husbandman 1
3968503 2013616 2013616 defendant Moryell Andrew cooper 586041 586041 Moryell, Andrew, of Old Bokenham, cooper 2
3976259 2016263 2016263 defendant Randoll Thomas husbandman 586041 586041 Randoll, Thomas, of Old Bokenham, husbandman 2
3976621 2016399 2016399 defendant Hyll John husbandman 586041 586041 Hyll, John, of Old Bokenham, husbandman 0
3976622 2016399 2016399 defendant Hawes John yeoman 586041 586041 Hawes, John, of Old Bokenham, yeoman 1
3976623 2016399 2016399 defendant Taylour Stephen yeoman 586041 586041 Taylour, Stephen, of Old Bokenham, yeoman 2
3976625 2016399 2016399 defendant Smyth John gent 586041 586041 Smyth, John, of Old Bokenham, gent 4
4009236 2028069 2028069 defendant Wylkynson John gent 586041 586041 Wylkynson, John, of Old Bokenham, gent 1
4057963 2045227 2045227 defendant Shales William husbandman 586041 586041 Shales, William, of Old Bokenham, husbandman 1
4191214 2092491 2092491 defendant Nonne Francis husbandman 586041 586041 Nonne, Francis, of Old Bokenham, husbandman 3
4416664 2170078 2170078 defendant Warde Richard   586041 586041 Warde, Richard, of Old Bokenham 0
4416665 2170078 2170078 defendant atte Gros Lawrence   586041 586041 atte Gros, Lawrence, of Old Bokenham 1
4416666 2170078 2170078 defendant atte Hirne Richard   586041 586041 atte Hirne, Richard, of Old Bokenham 2
4440970 2182098 2182098 defendant Dynere or Dyvere John   586041 586041 Dynere or Dyvere, John, of Old Bokenham 1
4509707 2203519 2203519 plaintiff Fyn John   586041 586041 Fyn, John, of Old Bokenham 1
4708348 2267984 2267984 defendant Joly John butcher 586041 586041 Joly, John, of Old Bokenham, butcher 0
4709218 2268250 2268250 defendant Jolyf John butcher 586041 586041 Jolyf, John, of Old Bokenham, butcher 3
4714217 2269776 2269776 defendant Jolyf John butcher 586041 586041 Jolyf, John, of Old Bokenham, butcher 0
4718968 2271279 2271279 defendant Jolyf John butcher 586041 586041 Jolyf, John, of Old Bokenham, butcher 1
4732551 2275355 2275355 defendant Barbour John barber 586041 586041 Barbour, John, of Old Bokenham, barber 0
4770000 2286588 2286588 defendant Pytcok Thomas husbandman 586041 586041 Pytcok, Thomas, of Old Bokenham, husbandman 3
4772406 2287336 2287336 defendant Wode Thomas husbandman 586041 586041 Wode, Thomas, of Old Bokenham, husbandman 2
4800545 2296352 2296352 defendant atte Wyke Geoffrey laborer 586041 586041 atte Wyke, Geoffrey, of Old Bokenham, laborer 0
4858479 2314025 2314025 defendant Caston William   586041 586041 Caston, William, of Old Bokenham, wright 0
4892236 2324313 2324313 defendant Smyth Adam yeoman 586041 586041 Smyth, Adam, of Old Bokenham, yeoman 2
4897779 2325970 2325970 defendant Petecok Thomas husbandman 586041 586041 Petecok, Thomas, of Old Bokenham, husbandman 2
4909156 2329407 2329407 defendant Jolyff Adam yeoman 586041 586041 Jolyff, Adam, of Old Bokenham, yeoman 2
4928446 2335319 2335319 defendant Pydcok Thomas husbandman 586041 586041 Pydcok, Thomas, of Old Bokenham, husbandman 3
4930769 2336031 2336031 defendant Wryght Richard husbandman 586041 586041 Wryght, Richard, of Old Bokenham, husbandman 0
4939932 2338875 2338875 defendant Smyth Adam yeoman 586041 586041 Smyth, Adam, of Old Bokenham, yeoman 0
4974974 2349487 2349487 defendant Wake William husbandman 586041 586041 Wake, William, of Old Bokenham, husbandman 0
5037388 2367804 2367804 defendant Wete Thomas yeoman 586041 586041 Wete, Thomas, of Old Bokenham, yeoman 6
5040454 2368749 2368749 defendant Smyth Adam husbandman 586041 586041 Smyth, Adam, of Old Bokenham, husbandman 0
5055198 2373133 2373133 defendant Smyth Adam yeoman 586041 586041 Smyth, Adam, of Old Bokenham, yeoman 0
5095738 2385176 2385176 plaintiff Smyth Robert   586041 586041 Smyth, Robert, of Old Bokenham 0
5118663 2391888 2391888 defendant Smythe Robert yeoman 586041 586041 Smythe, Robert, of Old Bokenham, yeoman 3
5128356 2394770 2394770 defendant Youngys Robert husbandman 586041 586041 Youngys, Robert, of Old Bokenham, husbandman 4
5147444 2400399 2400399 defendant Yongys Robert husbandman 586041 586041 Yongys, Robert, of Old Bokenham, husbandman 4
5158529 2403614 2403614 defendant Smyth Adam husbandman 586041 586041 Smyth, Adam, of Old Bokenham, husbandman 0
5177119 2409000 2409000 defendant Smyth Adam husbandman 586041 586041 Smyth, Adam, of Old Bokenham, husbandman 0
5199868 2415713 2415713 defendant Smyth Adam husbandman 586041 586041 Smyth, Adam, of Old Bokenham, husbandman 0
5214251 2419901 2419901 defendant Smyth Adam husbandman 586041 586041 Smyth, Adam, of Old Bokenham, husbandman 1
5225168 2423032 2423032 defendant Smythe Robert yeoman 586041 586041 Smythe, Robert, of Old Bokenham, yeoman 1
5225995 2423270 2423270 plaintiff Wake Thomas   586041 586041 Wake, Thomas, of Old Bokenham 1
5275842 2438004 2438004 defendant Whytyng Richard thatcher 586041 586041 Whytyng, Richard, of Old Bokenham, thatcher 2
5280663 2439418 2439418 defendant Wake John yeoman 586041 586041 Wake, John, of Old Bokenham, yeoman 1
5298422 2444514 2444514 defendant Torald Seamus chaplain 586041 586041 Torald, Seamus, of Old Bokenham, chaplain 1
5333441 2455075 2455075 defendant Herve or Herne Thomas husbandman 586041 586041 Herve or Herne, Thomas, of Old Bokenham, husbandman 1
5333446 2455076 2455076 defendant Torald Seman chaplain 586041 586041 Torald, Seman, of Old Bokenham, chaplain 2
5500622 2505121 2505121 defendant Wolman Thomas husbandman 586041 586041 Wolman, Thomas, of Old Bokenham, husbandman 1
5507888 2507367 2507367 defendant Plattyng John yeoman 586041 586041 Plattyng, John, of Old Bokenham, yeoman 8
5584435 2530196 2530196 defendant More Michael carpenter 586041 586041 More, Michael, of Old Bokenham, carpenter 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);