names

43 rows where place_id = 588143

✎ 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
3593503 1865601 1865601 defendant Paryssh John husbandman 588143 588143 Paryssh, John, of Blyburgh, Suff, husbandman 1
3619216 1873611 1873611 defendant Gardener William mercer 588143 588143 Gardener, William, of Blyburgh, Suff, mercer 1
3619219 1873612 1873612 defendant Gardener William mercer 588143 588143 Gardener, William, of Blyburgh, Suff, mercer 1
3655003 1911828 1911828 defendant Sowode John chaplain 588143 588143 Sowode, John, of Blyburgh, Suff, chaplain 1
3711219 1929813 1929813 defendant Botwryght Nicholas tailor 588143 588143 Botwryght, Nicholas, of Blyburgh, Suff, tailor 0
3723745 1933702 1933702 defendant Norton John tailor 588143 588143 Norton, John, of Blyburgh, Suff, tailor 3
3729323 1935423 1935423 defendant Hapton John pointer 588143 588143 Hapton, John, of Blyburgh, Suff, pointer 0
3749417 1941733 1941733 defendant Swane John yeoman 588143 588143 Swane, John, of Blyburgh, Suff, yeoman 0
3793665 1955881 1955881 defendant Dyver Robert husbandman 588143 588143 Dyver, Robert, of Blyburgh, Suff, husbandman 2
3820169 1964187 1964187 defendant Norton John tailor 588143 588143 Norton, John, of Blyburgh, Suff, tailor 0
3821132 1964505 1964505 defendant Swan John painter 588143 588143 Swan, John, of Blyburgh, Suff, painter 2
4782225 2290441 2290441 defendant Lounde Richard husbandman 588143 588143 Lounde, Richard, of Blyburgh, Suff, husbandman 0
4791390 2293400 2293400 defendant Wodecok Thomas yeoman 588143 588143 Wodecok, Thomas, of Blyburgh, Suff, yeoman 0
4791392 2293401 2293401 defendant Wodecok Thomas yeoman 588143 588143 Wodecok, Thomas, of Blyburgh, Suff, yeoman 0
4802291 2296906 2296906 defendant Glovere John husbandman 588143 588143 Glovere, John, of Blyburgh, Suff, husbandman 0
4849878 2311432 2311432 defendant Totay John yeoman 588143 588143 Totay, John, of Blyburgh, Suff, yeoman 6
4900987 2326937 2326937 defendant Lawyer Richard chaplain 588143 588143 Lawyer, Richard, of Blyburgh, Suff, chaplain 0
4928749 2335419 2335419 defendant Bateman John shoemaker 588143 588143 Bateman, John, of Blyburgh, Suff, shoemaker 1
4951607 2342459 2342459 defendant Baker Robert baker 588143 588143 Baker, Robert, of Blyburgh, Suff, baker 1
4968133 2347417 2347417 defendant Baker William baker 588143 588143 Baker, William, of Blyburgh, Suff, baker 1
5028032 2365079 2365079 defendant Sawe Robert baker 588143 588143 Sawe, Robert, of Blyburgh, Suff, baker 0
5091731 2383973 2383973 defendant Wolsy John yeoman 588143 588143 Wolsy, John, of Blyburgh, Suff, yeoman 4
5093219 2384409 2384409 defendant Coteler John mercer 588143 588143 Coteler, John, of Blyburgh, Suff, mercer 2
5098172 2385897 2385897 defendant Wolcy John yeoman 588143 588143 Wolcy, John, of Blyburgh, Suff, yeoman 0
5109502 2389208 2389208 defendant Skuttyng William yeoman 588143 588143 Skuttyng, William, of Blyburgh, Suff, yeoman 0
5123706 2393392 2393392 defendant Wyet alias Hakeney William   588143 588143 Wyet alias Hakeney, William, of Blyburgh, Suff, wright 0
5123708 2393393 2393393 defendant Wyet alias Hakeney William   588143 588143 Wyet alias Hakeney, William, of Blyburgh, Suff, wright or carpenter 0
5134709 2396647 2396647 defendant Butteller Robert chapman 588143 588143 Butteller, Robert, of Blyburgh, Suff, chapman 0
5154643 2402512 2402512 defendant Butteler Robert chapman 588143 588143 Butteler, Robert, of Blyburgh, Suff, chapman 0
5156315 2403000 2403000 defendant Aleyn John   588143 588143 Aleyn, John, of Blyburgh, Suff, glove maker 0
5171625 2407423 2407423 defendant Butteler Robert chapman 588143 588143 Butteler, Robert, of Blyburgh, Suff, chapman 0
5171642 2407427 2407427 defendant Coteler Robert chapman 588143 588143 Coteler, Robert, of Blyburgh, Suff, chapman 1
5171646 2407428 2407428 defendant Coteler Robert chapman 588143 588143 Coteler, Robert, of Blyburgh, Suff, chapman 1
5190297 2412906 2412906 defendant Boteler Robert chapman 588143 588143 Boteler, Robert, of Blyburgh, Suff, chapman 1
5253652 2431254 2431254 defendant Borehede Roger (legal representative) 588143 588143 Borehede, Roger, of Blyburgh, Suff, yeoman, executors of 0
5253656 2431255 2431255 defendant Borhede Roger (legal representative) 588143 588143 Borhede, Roger, of Blyburgh, Suff, yeoman, executors of 0
5253657 2431255 2431255 defendant Borhede Richard clerk 588143 588143 (Borhede, Richard, of Blyburgh, Suff, clerk 1
5283678 2440274 2440274 defendant Hoo John yeoman 588143 588143 (Hoo, John, of Blyburgh, Suff, yeoman 1
5429353 2483715 2483715 plaintiff Grave Thomas yeoman 588143 588143 Grave, Thomas, of Blyburgh, Suff, yeoman 0
5429356 2483716 2483716 plaintiff Grave Thomas yeoman 588143 588143 Grave, Thomas, of Blyburgh, Suff, yeoman 0
5502338 2505654 2505654 defendant Chynche John yeoman 588143 588143 Chynche, John, of Blyburgh, Suff, yeoman 0
5502354 2505661 2505661 defendant Clynche John yeoman 588143 588143 Clynche, John, of Blyburgh, Suff, yeoman 0
5539419 2516817 2516817 defendant Thropnell Robert yeoman 588143 588143 Thropnell, Robert, of Blyburgh, Suff, yeoman 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);