names

42 rows where place_id = 594777

✎ 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
3617574 1873119 1873119 defendant Byrde John dyer 594777 594777 Byrde, John, of Lynne,Norf, dyer 1
3626232 1903060 1903060 defendant Bulle Richard mercer 594777 594777 Bulle, Richard, of Lynne, Norf, or of London, mercer 0
3641255 1907715 1907715 defendant Alward John chapman 594777 594777 Alward, John, of Lynne, Norf, chapman 2
3651799 1910922 1910922 defendant Senns Edmund goldsmith 594777 594777 Senns, Edmund, of Lynne, Norf, goldsmith 0
3662792 1914281 1914281 defendant Browne John   594777 594777 Browne, John, of Lynne, Norf, inn holder 3
3662808 1914284 1914284 defendant Kems Edmund merchant 594777 594777 Kems, Edmund, of Lynne, Norf, merchant 2
3673009 1917566 1917566 defendant Craycroft Leonard gent 594777 594777 Craycroft, Leonard, of Lynne, Norf, gent 1
3706676 1928372 1928372 defendant Coo Christopher gent 594777 594777 Coo, Christopher, of Lynne, Norf, gent 0
3793604 1955862 1955862 defendant Lyme William mercer 594777 594777 Lyme, William, of Lynne, Norf, mercer 2
3847851 1972903 1972903 defendant Myller Thomas merchant 594777 594777 Myller, Thomas, of Lynne, Norf, merchant 0
3858404 1976289 1976289 defendant Brouon John yeoman 594777 594777 Brouon, John, of Lynne, Norf, yeoman 2
3922753 1997920 1997920 defendant Powlesson Sibrand merchant 594777 594777 Powlesson, Sibrand, of Lynne, Norf, merchant 0
3937734 2002953 2002953 defendant Hooke John merchant 594777 594777 Hooke, John, of Lynne, Norf, merchant 0
3951089 2007447 2007447 plaintiff Grayde George merchant 594777 594777 Grayde, George, of Lynne, Norf, merchant 0
3983966 2019034 2019034 defendant Barwicke Thomas saddler 594777 594777 Barwicke, Thomas, of Lynne, Norf, saddler 0
4000334 2024888 2024888 defendant Woodhowse George gent 594777 594777 Woodhowse, George, of Lynne, Norf, gent 1
4006176 2026981 2026981 plaintiff Layghton Thomas merchant 594777 594777 Layghton, Thomas, of Lynne, Norf, gent, merchant 0
4209996 2099060 2099060 defendant Shaxton Francis gent 594777 594777 Shaxton, Francis, of Lynne, Norf, gent 0
4242858 2110602 2110602 defendant Sharburne Henry gent 594777 594777 Sharburne, Henry, of Lynne, Norf, gent 1
4266327 2118380 2118380 defendant Sherburne Henry gent 594777 594777 Sherburne, Henry, of Lynne, Norf, gent 1
4326751 2139301 2139301 defendant Wilkenson Robert draper 594777 594777 Wilkenson, Robert, of Lynne, Norf, draper 0
4656175 2247816 2247816 defendant Yorom William   594777 594777 Yorom, William, of Lynne, Norf, toll gatherer 0
4681355 2259791 2259791 defendant Sutton Robert draper 594777 594777 Sutton, Robert, of Lynne, Norf, draper 0
4683647 2260487 2260487 defendant Ussher Robert shipman 594777 594777 Ussher, Robert, of Lynne, Norf, shipman 0
4685260 2260986 2260986 defendant Roper John, junior husbandman 594777 594777 Roper, John, junior, of Lynne, Norf, husbandman 1
4740078 2277614 2277614 defendant Burman John chapman 594777 594777 Burman, John, of Lynne, Norf, chapman 0
4755926 2282237 2282237 defendant Kynerton William skinner 594777 594777 Kynerton, William, of Lynne, Norf, skinner 1
4763575 2284593 2284593 defendant Stevenson John butcher 594777 594777 Stevenson, John, of Lynne, Norf, butcher 1
4766335 2285463 2285463 defendant Parfray John butcher 594777 594777 Parfray, John, of Lynne, Norf, butcher 0
4774088 2287879 2287879 defendant Kelowe William merchant 594777 594777 Kelowe, William, of Lynne, Norf, merchant 0
4783628 2290896 2290896 defendant Parfay John butcher 594777 594777 Parfay, John, of Lynne, Norf, butcher 0
4787225 2292072 2292072 defendant Stevenson John butcher 594777 594777 Stevenson, John, of Lynne, Norf, butcher 1
4951059 2342295 2342295 defendant Prise John merchant 594777 594777 Prise, John, of Lynne, Norf, merchant 0
5303471 2446032 2446032 defendant Pygot Simon merchant 594777 594777 Pygot, Simon, of Lynne, Norf, merchant 0
5373497 2467308 2467308 defendant Houshold Robert beer brewer & burgess 594777 594777 Houshold, Robert, of Lynne, Norf, beer brewer & burgess 0
5523281 2512112 2512112 defendant Scole Richard yeoman 594777 594777 Scole, Richard, of Lynne, Norf, yeoman 0
5523283 2512113 2512113 defendant Skole Richard yeoman 594777 594777 Skole, Richard, of Lynne, Norf, yeoman 0
5572735 2526572 2526572 defendant Osse William merchant 594777 594777 Osse, William, of Lynne, Norf, merchant 0
5577838 2528138 2528138 defendant Sherman Simon yeoman 594777 594777 Sherman, Simon, of Lynne, Norf, yeoman 1
5588041 2531269 2531269 defendant Blower William mercer 594777 594777 Blower, William, of Lynne, Norf, mercer 4
5609180 2537775 2537775 defendant Houshold Robert   594777 594777 Houshold, Robert, of Lynne, Norf, burgess & beer brewer 0
5634294 2554713 2554713 defendant Brigge Thomas merchant 594777 594777 Brigge, Thomas, of Lynne, Norf, merchant 0

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