names

58 rows where place_id = 609888

✎ 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
3680911 1920112 1920112 defendant Lichefeld Thomas gent 609888 609888 Lichefeld, Thomas, of Bokenham, gent 0
3691284 1923432 1923432 plaintiff Harvy James   609888 609888 Harvy, James, of Bokenham 0
3693988 1924321 1924321 defendant Parkyn John husbandman 609888 609888 Parkyn, John, of Bokenham, husbandman 2
3793535 1955841 1955841 defendant Agas John husbandman 609888 609888 Agas, John, of Bokenham, husbandman 0
3814437 1962429 1962429 defendant Edwardys Walter weaver 609888 609888 Edwardys, Walter, of Bokenham, weaver 2
3822055 1964792 1964792 defendant Parkyn John   609888 609888 Parkyn, John, of Bokenham, wheel wright 0
3825799 1965915 1965915 defendant Clerk Thomas clerk 609888 609888 Clerk, Thomas, of Bokenham, clerk 2
3847756 1972869 1972869 defendant Yalop John husbandman 609888 609888 Yalop, John, of Bokenham, husbandman 1
3859223 1976576 1976576 defendant Goodwyn William yeoman 609888 609888 Goodwyn, William, of Bokenham, yeoman 0
3879778 1983492 1983492 defendant Daham William yeoman 609888 609888 Daham, William, of Bokenham, yeoman 3
3891496 1987421 1987421 defendant Gutyng Thomas husbandman 609888 609888 Gutyng, Thomas, of Bokenham, husbandman 2
3907951 1992950 1992950 defendant Walter John husbandman 609888 609888 Walter, John, of Bokenham, husbandman 2
3909896 1993617 1993617 defendant Adcok William husbandman 609888 609888 Adcok, William, of Bokenham, husbandman 0
3922060 1997712 1997712 defendant Robard James husbandman 609888 609888 Robard, James, of Bokenham, husbandman 1
3922061 1997712 1997712 defendant Sanderson Robert yeoman 609888 609888 Sanderson, Robert, of Bokenham, yeoman 2
3931433 2000812 2000812 plaintiff Dey Robert   609888 609888 Dey, Robert, of Bokenham beer brewer 0
3941780 2004264 2004264 plaintiff Walter Robert   609888 609888 Walter, Robert, of Bokenham 0
3967431 2013242 2013242 defendant Robardis John yeoman 609888 609888 Robardis, John, of Bokenham, yeoman 1
3968315 2013549 2013549 plaintiff Chase William yeoman 609888 609888 Chase, William, of Bokenham, yeoman 0
4473324 2192316 2192316 defendant Smyth Thomas   609888 609888 Smyth, Thomas, of Bokenham 2
4474692 2192749 2192749 defendant Heryng John   609888 609888 Heryng, John, of Bokenham 0
4481650 2194957 2194957 plaintiff Lytgate Alice   609888 609888 Lytgate, Alice, of Bokenham 0
4510126 2203653 2203653 plaintiff Banham William   609888 609888 Banham, William, of Bokenham 0
4511639 2204090 2204090 defendant Waterman Thomas   609888 609888 Waterman, Thomas, of Bokenham 2
4512034 2204205 2204205 defendant Coteler John   609888 609888 Coteler, John, of Bokenham 0
4536080 2211561 2211561 defendant Sparwe Thomas   609888 609888 Sparwe, Thomas, of Bokenham 0
4579390 2225031 2225031 defendant Bonde William   609888 609888 (Bonde, William, of Bokenham 2
4584794 2226673 2226673 plaintiff Granour Walter   609888 609888 Granour, Walter, of Bokenham 0
4637691 2242568 2242568 defendant Jolyf John   609888 609888 Jolyf, John, of Bokenham 5
4637699 2242569 2242569 defendant Jolyf John   609888 609888 Jolyf, John, of Bokenham 5
4653842 2247108 2247108 plaintiff Bernard David   609888 609888 Bernard, David, of Bokenham 0
4656478 2247923 2247923 defendant Steynolf Thomas yeoman 609888 609888 Steynolf, Thomas, of Bokenham, yeoman 1
4659549 2248837 2248837 defendant Mannyng Henry husbandman 609888 609888 Mannyng, Henry, of Bokenham, husbandman 5
4671008 2256602 2256602 defendant Steynolf Thomas   609888 609888 Steynolf, Thomas, of Bokenham, bailiff 2
4674268 2257560 2257560 plaintiff Drewe John   609888 609888 Drewe, John, of Bokenham, on his own account 0
4674298 2257570 2257570 defendant Carleton Robert   609888 609888 Carleton, Robert, of Bokenham, Norf, prior 0
4738101 2277021 2277021 plaintiff Wederby Thomas   609888 609888 Wederby, Thomas, of Bokenham 0
4738107 2277022 2277022 plaintiff Wederby Thomas   609888 609888 Wederby, Thomas, of Bokenham 0
4798317 2295661 2295661 defendant Hirne Richard laborer 609888 609888 Hirne, Richard, of Bokenham, laborer 2
4807637 2298579 2298579 defendant Carleton Robert   609888 609888 Carleton, Robert, of Bokenham, prior 0
4836491 2307390 2307390 defendant Wodeman John   609888 609888 Wodeman, John, of Bokenham 7
4877856 2320035 2320035 defendant Waryn Thomas pedder 609888 609888 Waryn, Thomas, of Bokenham, pedder 2
4887222 2322843 2322843 defendant Couper Thomas husbandman 609888 609888 Couper, Thomas, of Bokenham, husbandman 2
4895719 2325337 2325337 defendant Bernyngham Richard chapman 609888 609888 Bernyngham, Richard, of Bokenham, chapman 1
4999285 2356660 2356660 defendant Canston Thomas carpenter 609888 609888 Canston, Thomas, of Bokenham, carpenter 0
5075617 2379206 2379206 defendant Page John smith 609888 609888 Page, John, of Bokenham, smith 0
5119748 2392216 2392216 plaintiff Smyth Adam   609888 609888 Smyth, Adam, of Bokenham 0
5137825 2397573 2397573 defendant Smyth Adam husbandman 609888 609888 Smyth, Adam, of Bokenham, husbandman 0
5151999 2401721 2401721 plaintiff Hardy Robert   609888 609888 Hardy, Robert, of Bokenham 0
5177118 2409000 2409000 plaintiff (not given) William prior of Whallay 609888 609888 Whallay, William, of Bokenham, prior of the house of St James 0
5199867 2415713 2415713 plaintiff (not given) William prior of Whallay 609888 609888 Whallay, William, of Bokenham, prior of the house of St James 0
5265838 2435069 2435069 plaintiff Thunder John   609888 609888 Thunder, John, of Bokenham 0
5272482 2437026 2437026 defendant Chapellayn William husbandman 609888 609888 Chapellayn, William, of Bokenham, husbandman 2
5320957 2451357 2451357 defendant Abbat John husbandman 609888 609888 Abbat, John, of Bokenham, husbandman 0
5471514 2496429 2496429 defendant Couper William husbandman 609888 609888 Couper, William, of Bokenham, husbandman 2
5579092 2528533 2528533 defendant Knyvet William   609888 609888 Knyvet, William, of Bokenham, knight 0
5613396 2547979 2547979 defendant Wake John, junior   609888 609888 Wake, John, junior, of Bokenham 0
5636394 2555341 2555341 defendant Sutton Robert tailor 609888 609888 Sutton, Robert, of Bokenham, tailor 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);