names

53 rows where place_id = 590080

✎ 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
3599815 1867588 1867588 defendant Godenge John carpenter 590080 590080 Godenge, John, of Ifeld, carpenter 0
3602960 1868590 1868590 defendant Bregger Thomas husbandman 590080 590080 Bregger, Thomas, of Ifeld, husbandman 0
3602961 1868590 1868590 defendant Mershe William husbandman 590080 590080 Mershe, William, of Ifeld, husbandman 1
3612217 1871461 1871461 defendant Mersshe William husbandman 590080 590080 Mersshe, William, of Ifeld, husbandman 0
3612218 1871461 1871461 defendant Bregger Thomas husbandman 590080 590080 Bregger, Thomas, of Ifeld, husbandman 1
3620869 1874089 1874089 defendant Scras John laborer 590080 590080 Scras, John, of Ifeld, laborer 3
3673912 1917876 1917876 defendant Mershe Joan widow 590080 590080 Mershe, Joan, of Ifeld, widow 0
3701605 1926750 1926750 defendant Myles John yeoman 590080 590080 Myles, John, of Ifeld, yeoman 0
3779176 1951209 1951209 defendant Whyte William husbandman 590080 590080 Whyte, William, of Ifeld, husbandman 0
3785436 1953233 1953233 defendant Wright Robert clerk 590080 590080 Wright, Robert, of Ifeld, clerk 1
3819155 1963878 1963878 defendant Waterman John husbandman 590080 590080 Waterman, John, of Ifeld, husbandman 1
3915287 1995479 1995479 defendant Smalham Richard husbandman 590080 590080 Smalham, Richard, of Ifeld, husbandman 0
3937815 2002979 2002979 defendant Mastall Richard gent 590080 590080 Mastall, Richard, of Ifeld, gent 1
3946468 2005833 2005833 defendant Parman Edward husbandman 590080 590080 Parman, Edward, of Ifeld, husbandman 0
3967648 2013320 2013320 defendant Balwyn James laborer 590080 590080 Balwyn, James, of Ifeld, laborer 0
3967649 2013320 2013320 defendant Batcheler William tailor 590080 590080 Batcheler, William, of Ifeld, tailor 1
4001108 2025175 2025175 defendant Dod Peter gent 590080 590080 Dod, Peter, of Ifeld, gent 0
4001110 2025176 2025176 defendant Dod Peter gent 590080 590080 Dod, Peter, of Ifeld, gent 0
4001112 2025177 2025177 defendant Dodd Peter gent 590080 590080 Dodd, Peter, of Ifeld, gent 0
4008866 2027935 2027935 defendant Langley Henry husbandman 590080 590080 Langley, Henry, of Ifeld, husbandman 0
4033974 2036805 2036805 defendant Dodd Peter gent 590080 590080 Dodd, Peter, of Ifeld, gent 0
4083678 2054435 2054435 defendant Bull Stephen husbandman 590080 590080 Bull, Stephen, of Ifeld, husbandman 2
4125796 2069508 2069508 defendant Ellys Eustace husbandman 590080 590080 Ellys, Eustace, of Ifeld, husbandman 0
4130278 2071142 2071142 defendant Swane John yeoman 590080 590080 Swane, John, of Ifeld, yeoman 1
4149800 2078057 2078057 defendant Arthur John yeoman 590080 590080 Arthur, John, of Ifeld, yeoman 0
4317040 2136072 2136072 defendant Woodman John yeoman 590080 590080 Woodman, John, of Ifeld, yeoman 0
4369960 2154311 2154311 defendant Holmewood George yeoman 590080 590080 Holmewood, George, of Ifeld, yeoman 0
4369961 2154311 2154311 defendant Symons William yeoman 590080 590080 Symons, William, of Ifeld, yeoman 1
4490378 2197694 2197694 defendant atte Wode Peter   590080 590080 atte Wode, Peter, of Ifeld 0
4581857 2225771 2225771 defendant Bonewik Walter   590080 590080 Bonewik, Walter, of Ifeld 0
4670633 2256498 2256498 defendant atte Denne Walter husbandman 590080 590080 atte Denne, Walter, of Ifeld, husbandman 0
4789814 2292882 2292882 defendant Blast Isabel widow 590080 590080 Blast, Isabel, of Ifeld, widow 0
5046289 2370521 2370521 defendant atte Wode Richard husbandman 590080 590080 atte Wode, Richard, of Ifeld, husbandman 0
5129880 2395226 2395226 defendant Wody John gent 590080 590080 Wody, John, of Ifeld, gent 0
5183995 2411051 2411051 defendant Wodye John gent 590080 590080 Wodye, John, of Ifeld, gent 0
5253296 2431131 2431131 defendant Wody John, senior gent 590080 590080 together with Wody, John, senior, of Ifeld, gent 2
5253299 2431132 2431132 defendant Wody John, senior gent 590080 590080 (Wody, John, senior, of Ifeld, gent 1
5277843 2438604 2438604 defendant Sherwynd John husbandman 590080 590080 Sherwynd, John, of Ifeld, husbandman 2
5292377 2442770 2442770 defendant Bonewyke William yeoman 590080 590080 Bonewyke, William, of Ifeld, yeoman 0
5292378 2442770 2442770 defendant Attewod Richard husbandman 590080 590080 Attewod, Richard, of Ifeld, husbandman 1
5312080 2448643 2448643 defendant Rogger Thomas drover 590080 590080 Rogger, Thomas, of Ifeld, drover 0
5324858 2452509 2452509 defendant atte Wode Richard husbandman 590080 590080 atte Wode, Richard, of Ifeld, husbandman 0
5338179 2456506 2456506 defendant Roger Thomas yeoman 590080 590080 Roger, Thomas, of Ifeld, yeoman 0
5405291 2476598 2476598 defendant Gater John laborer 590080 590080 Gater, John, of Ifeld, laborer 0
5418370 2480420 2480420 defendant Gater James laborer 590080 590080 Gater, James, of Ifeld, laborer 0
5474696 2497415 2497415 defendant Gater John laborer 590080 590080 Gater, John, of Ifeld, laborer 0
5500882 2505208 2505208 defendant Bryggard Martin husbandman 590080 590080 Bryggard, Martin, of Ifeld, husbandman 0
5517795 2510408 2510408 defendant Whytehed John husbandman 590080 590080 Whytehed, John, of Ifeld, husbandman 2
5546720 2519042 2519042 defendant Wode Elizabeth widow 590080 590080 Wode, Elizabeth, of Ifeld, widow 0
5546721 2519042 2519042 defendant Bridger Thomas yeoman 590080 590080 Bridger, Thomas, of Ifeld, yeoman 1
5562522 2523638 2523638 plaintiff Wody John gent 590080 590080 Wody, John, of Ifeld, gent 0
5583924 2530048 2530048 defendant Hall Thomas husbandman 590080 590080 Hall, Thomas, of Ifeld, husbandman 1
5583925 2530048 2530048 defendant Aleyn John husbandman 590080 590080 Aleyn, John, of Ifeld, husbandman 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);