names

85 rows where place_id = 592429

✎ 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
3607670 1870053 1870053 defendant Gamlyn Robert clerk 592429 592429 Gamlyn, Robert, of West Bradenham, clerk 0
3667820 1915877 1915877 defendant Munsawe William husbandman 592429 592429 Munsawe, William, of West Bradenham, husbandman 0
3690659 1923243 1923243 defendant Bradenham John yeoman 592429 592429 Bradenham, John, of West Bradenham, yeoman 0
3695745 1924899 1924899 defendant Swyft John husbandman 592429 592429 Swyft, John, of West Bradenham, husbandman 1
3695746 1924899 1924899 defendant Bradenham John husbandman 592429 592429 Bradenham, John, of West Bradenham, husbandman 2
3711996 1930069 1930069 defendant Bradenham John husbandman 592429 592429 Bradenham, John, of West Bradenham, husbandman 2
3715718 1931206 1931206 defendant Bately Thomas husbandman 592429 592429 Bately, Thomas, of West Bradenham, husbandman 0
3719042 1932232 1932232 defendant A Bradenham John husbandman 592429 592429 A Bradenham, John, of West Bradenham, husbandman 0
3720239 1932607 1932607 defendant Batayle Thomas husbandman 592429 592429 Batayle, Thomas, of West Bradenham, husbandman 0
3729230 1935392 1935392 defendant Bateley Thomas husbandman 592429 592429 Bateley, Thomas, of West Bradenham, husbandman 1
3734808 1937133 1937133 defendant Bataley Thomas husbandman 592429 592429 Bataley, Thomas, of West Bradenham, husbandman 0
3734809 1937133 1937133 defendant Abraham John husbandman 592429 592429 Abraham, John, of West Bradenham, husbandman 1
3745634 1940542 1940542 defendant Bataly Thomas husbandman 592429 592429 Bataly, Thomas, of West Bradenham, husbandman 1
3753885 1943162 1943162 defendant Coo Ambrose thatcher 592429 592429 Coo, Ambrose, of West Bradenham, thatcher 2
3762009 1945764 1945764 plaintiff Fulboren Thomas   592429 592429 Fulboren, Thomas, of West Bradenham 0
3762730 1945985 1945985 defendant Abraham John husbandman 592429 592429 Abraham, John, of West Bradenham, husbandman 1
3788400 1954171 1954171 defendant Bayly William butcher 592429 592429 Bayly, William, of West Bradenham, butcher 0
3799374 1957725 1957725 defendant Bateley Thomas husbandman 592429 592429 Bateley, Thomas, of West Bradenham, husbandman 0
3802502 1958678 1958678 defendant Bayly William bucher 592429 592429 Bayly, William, of West Bradenham, bucher 6
3804691 1959409 1959409 defendant Bayly William butcher 592429 592429 Bayly, William, of West Bradenham, butcher 0
3819910 1964106 1964106 defendant Bateley Thomas husbandman 592429 592429 Bateley, Thomas, of West Bradenham, husbandman 2
3829315 1967053 1967053 defendant Yelverton Nicholas gent 592429 592429 Yelverton, Nicholas, of West Bradenham, gent 0
3841023 1970763 1970763 defendant Bayly William butcher 592429 592429 Bayly, William, of West Bradenham, butcher 0
3876412 1982356 1982356 defendant Munshall William yeoman 592429 592429 Munshall, William, of West Bradenham, yeoman 1
3876424 1982359 1982359 defendant Munshall William, senior yeoman 592429 592429 Munshall, William, senior, of West Bradenham, yeoman 0
3881748 1984147 1984147 defendant Rolf Simon husbandman 592429 592429 Rolf, Simon, of West Bradenham, husbandman 0
3881749 1984147 1984147 defendant Warde Robert butcher 592429 592429 Warde, Robert, of West Bradenham, butcher 1
3886366 1985696 1985696 defendant Fyske Thomas glover 592429 592429 Fyske, Thomas, of West Bradenham, glover 0
3886368 1985696 1985696 defendant Tudenham Thomas   592429 592429 Tudenham, Thomas, of West Bradenham, ploughwright 2
3888817 1986513 1986513 defendant Warde Robert butcher 592429 592429 Warde, Robert, of West Bradenham, butcher 0
3888819 1986513 1986513 defendant Sawer Edward glover 592429 592429 Sawer, Edward, of West Bradenham, glover 2
3888820 1986513 1986513 defendant Munshaugh William yeoman 592429 592429 Munshaugh, William, of West Bradenham, yeoman 3
3925004 1998679 1998679 defendant Bateley Thomas esq 592429 592429 Bateley, Thomas, of West Bradenham, husbandman, servant of Hogon, Robert, esq 0
3925005 1998679 1998679 defendant Munsawe William yeoman 592429 592429 Munsawe, William, of West Bradenham, yeoman 1
4041197 2039340 2039340 defendant Munsawe Thomas yeoman 592429 592429 Munsawe, Thomas, of West Bradenham, yeoman 0
4041198 2039340 2039340 defendant Estrowe William butcher 592429 592429 Estrowe, William, of West Bradenham, butcher 1
4222043 2103201 2103201 defendant Estrowe William butcher 592429 592429 Estrowe, William, of West Bradenham, butcher 2
4247678 2112204 2112204 defendant Estrowe William butcher 592429 592429 Estrowe, William, of West Bradenham, butcher 3
4404784 2166165 2166165 defendant Scott Thomas husbandman or laborer 592429 592429 Scott, Thomas, of West Bradenham, husbandman or laborer 0
4409175 2167669 2167669 defendant Pecke Alexander husbandman 592429 592429 Pecke, Alexander, of West Bradenham, or of Shipdham, husbandman 1
4431739 2174699 2174699 plaintiff Brynkalee John   592429 592429 Brynkalee, John, of West Bradenham, parson 0
4431741 2174700 2174700 plaintiff Brynkelee John de master & parson 592429 592429 Brynkelee, John de, of West Bradenham, master & parson 0
4469426 2191100 2191100 defendant Rode Rolland   592429 592429 (Rode, Rolland, of West Bradenham, vicar 1
4581744 2225731 2225731 plaintiff Eble William   592429 592429 Eble, William, of West Bradenham 0
4581860 2225772 2225772 plaintiff Egle William   592429 592429 Egle, William, of West Bradenham 0
4601774 2231776 2231776 defendant atte Goter John   592429 592429 atte Goter, John, of West Bradenham 0
4701919 2266005 2266005 defendant Bagge Thomas   592429 592429 Bagge, Thomas, of West Bradenham 0
4752602 2281223 2281223 defendant Brakke alias Fraunsham Thomas gent 592429 592429 Brakke alias Fraunsham, Thomas, of West Bradenham, gent 0
4820251 2302403 2302403 defendant Brak Thomas husbandman 592429 592429 Brak, Thomas, of West Bradenham, husbandman 1
4820255 2302404 2302404 defendant Brak Thomas husbandman 592429 592429 Brak, Thomas, of West Bradenham, husbandman 1
4824028 2303591 2303591 defendant Allewyn John   592429 592429 Allewyn, John, of West Bradenham, administrators of 0
4893551 2324685 2324685 defendant Freman Roger smith 592429 592429 Freman, Roger, of West Bradenham, smith 0
4917537 2331999 2331999 defendant Marcaunt Robert yeoman 592429 592429 Marcaunt, Robert, of West Bradenham, yeoman 1
4917539 2331999 2331999 defendant Walefeld Thomas yeoman 592429 592429 Walefeld, Thomas, of West Bradenham, yeoman 3
4936074 2337679 2337679 defendant Sterlyng Thomas butcher 592429 592429 Sterlyng, Thomas, of West Bradenham, butcher 1
4988444 2353505 2353505 defendant Iryng Thomas husbandman 592429 592429 Iryng, Thomas, of West Bradenham, husbandman 0
5005876 2358620 2358620 defendant Waynproffe Peter chapman 592429 592429 Waynproffe, Peter, of West Bradenham, chapman 0
5005877 2358620 2358620 defendant Canon Thomas chapman 592429 592429 Canon, Thomas, of West Bradenham, chapman 1
5013824 2360893 2360893 defendant Brakke Thomas yeoman 592429 592429 Brakke, Thomas, of West Bradenham, yeoman 0
5100828 2386657 2386657 defendant Fransham alias Brakke Thomas chaplain or gent 592429 592429 Fransham alias Brakke, Thomas, of West Bradenham, chaplain or gent 1
5227631 2423701 2423701 defendant Wellys William smith 592429 592429 Wellys, William, of West Bradenham, smith 2
5336925 2456112 2456112 defendant Gelyet John husbandman 592429 592429 Gelyet, John, of West Bradenham, husbandman 2
5354929 2461615 2461615 defendant Aldewyn William husbandman 592429 592429 Aldewyn, William, of West Bradenham, husbandman 0
5415361 2479529 2479529 defendant Elyngham Richard husbandman 592429 592429 Elyngham, Richard, of West Bradenham, husbandman 0
5426011 2482733 2482733 defendant Gyliet John carpenter 592429 592429 Gyliet, John, of West Bradenham, carpenter 0
5426012 2482733 2482733 defendant Gilyet Walter husbandman 592429 592429 Gilyet, Walter, of West Bradenham, husbandman 1
5426013 2482733 2482733 defendant Gamelyn Robert clerk 592429 592429 Gamelyn, Robert, of West Bradenham, clerk 2
5431527 2484386 2484386 defendant Elyngham Richard husbandman 592429 592429 Elyngham, Richard, of West Bradenham, husbandman 0
5441037 2487229 2487229 defendant Elyngham Richard   592429 592429 Elyngham, Richard, of West Bradenham 0
5456997 2491998 2491998 defendant Gyliot John carpenter 592429 592429 Gyliot, John, of West Bradenham, carpenter 0
5456998 2491998 2491998 defendant Gyliot Walter husbandman 592429 592429 Gyliot, Walter, of West Bradenham, husbandman 1
5456999 2491998 2491998 defendant Gamelyn Robert clerk 592429 592429 Gamelyn, Robert, of West Bradenham, clerk 2
5465361 2494548 2494548 defendant Gyllyet John husbandman 592429 592429 Gyllyet, John, of West Bradenham, husbandman 0
5465362 2494548 2494548 defendant Gamlyn Robert clerk 592429 592429 Gamlyn, Robert, of West Bradenham, clerk 1
5468881 2495621 2495621 defendant Eyliet or Gyliet John carpenter 592429 592429 Eyliet or Gyliet, John, of West Bradenham, carpenter 0
5468882 2495621 2495621 defendant Gyliet Walter husbandman 592429 592429 Gyliet, Walter, of West Bradenham, husbandman 1
5468883 2495621 2495621 defendant Gamelyn Robert clerk 592429 592429 Gamelyn, Robert, of West Bradenham, clerk 2
5468887 2495622 2495622 defendant Eyliet John carpenter 592429 592429 Eyliet, John, of West Bradenham, carpenter 0
5468888 2495622 2495622 defendant Eyliot Walter husbandman 592429 592429 Eyliot, Walter, of West Bradenham, husbandman 1
5468889 2495622 2495622 defendant Gamelyn Robert clerk 592429 592429 Gamelyn, Robert, of West Bradenham, clerk 2
5552024 2520633 2520633 defendant Bakke John weaver 592429 592429 Bakke, John, of West Bradenham, weaver 2
5552658 2520830 2520830 defendant Munshawe Robert husbandman 592429 592429 Munshawe, Robert, of West Bradenham, husbandman 1
5596014 2533664 2533664 defendant Swyfte John husbandman or "hyrdeler" 592429 592429 Swyfte, John, of West Bradenham, husbandman or "hyrdeler" 0
5600327 2534990 2534990 defendant Bryde Thomas husbandman 592429 592429 Bryde, Thomas, of West Bradenham, husbandman 0
5607089 2537105 2537105 defendant Bryde Thomas husbandman 592429 592429 Bryde, Thomas, of West Bradenham, husbandman 1

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