names

73 rows where place_id = 615146

✎ 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
3707400 1928605 1928605 defendant Hampton John yeoman 615146 615146 Hampton, John, of Clee, yeoman 3
3774324 1949691 1949691 defendant Redhed Robert fisher 615146 615146 Redhed, Robert, of Clee, fisher 0
3851298 1974005 1974005 defendant Waltham Robert husbandman 615146 615146 Waltham, Robert, of Clee, husbandman 0
3883636 1984795 1984795 defendant Bekke John husbandman 615146 615146 Bekke, John, of Clee, husbandman 3
3928240 1999780 1999780 defendant Beycknyff Brian fisher man 615146 615146 Beycknyff, Brian, of Clee, fisher man 1
3983015 2018702 2018702 defendant Curtes Thomas gent 615146 615146 Curtes, Thomas, of Clee, gent 0
4003970 2026189 2026189 defendant Gascoigne William gent 615146 615146 Gascoigne, William, of Clee, gent 2
4016716 2030686 2030686 defendant Curtes Robert husbandman 615146 615146 Curtes, Robert, of Clee, husbandman 2
4016717 2030686 2030686 defendant Culston William husbandman 615146 615146 Culston, William, of Clee, husbandman 3
4046647 2041253 2041253 defendant Gascoign Barbara widow 615146 615146 Gascoign, Barbara, of Clee, widow 0
4087061 2055664 2055664 defendant Curteys Richard husbandman 615146 615146 Curteys, Richard, of Clee, husbandman 0
4087062 2055664 2055664 defendant Curteys Thomas husbandman 615146 615146 Curteys, Thomas, of Clee, husbandman 1
4090025 2056715 2056715 defendant Wentworthe Hector gent 615146 615146 Wentworthe, Hector, of Clee, gent 0
4090330 2056826 2056826 defendant Wentworth Hector gent 615146 615146 Wentworth, Hector, of Clee, gent 0
4090332 2056827 2056827 defendant Wentworth Hector gent 615146 615146 Wentworth, Hector, of Clee, gent 0
4098583 2059825 2059825 defendant Curteys Robert husbandman 615146 615146 Curteys, Robert, of Clee, husbandman 0
4098584 2059825 2059825 defendant Curteys Richard husbandman 615146 615146 Curteys, Richard, of Clee, husbandman 1
4129590 2070886 2070886 defendant Curtice Leonard gent 615146 615146 Curtice, Leonard, of Clee, gent 0
4134602 2072706 2072706 defendant Johnson Richard husbandman 615146 615146 Johnson, Richard, of Clee, husbandman 0
4138497 2074134 2074134 defendant Wentworthe Hector gent 615146 615146 Wentworthe, Hector, of Clee, gent 0
4158637 2081095 2081095 defendant Johnson Richard husbandman 615146 615146 Johnson, Richard, of Clee, husbandman 0
4162358 2082391 2082391 defendant Bartilmewe Thomas husbandman 615146 615146 Bartilmewe, Thomas, of Clee, husbandman 0
4168973 2084641 2084641 defendant Holmes Richard yeoman 615146 615146 Holmes, Richard, of Clee, yeoman 0
4169001 2084651 2084651 defendant Holmes Richard yeoman 615146 615146 Holmes, Richard, of Clee, yeoman 0
4185891 2090559 2090559 defendant Bartilmewe Richard husbandman 615146 615146 Bartilmewe, Richard, of Clee, husbandman 0
4188497 2091449 2091449 defendant Freston Mathew yeoman 615146 615146 Freston, Mathew, of Clee, yeoman 0
4214786 2100677 2100677 defendant Eashton John yeoman 615146 615146 Eashton, John, of Clee, yeoman 0
4228620 2105494 2105494 defendant Peacocke Peter yeoman 615146 615146 Peacocke, Peter, of Clee, yeoman 1
4228621 2105494 2105494 defendant Peacocke Francis widow 615146 615146 Francis his wife, alias Francis Holdesworthe, of Clee, widow 2
4228622 2105494 2105494 defendant Holdesworth Luke yeoman 615146 615146 Holdesworth, Luke, of Clee, yeoman 3
4238903 2109229 2109229 defendant Curtes Simon yeoman 615146 615146 Curtes, Simon, of Clee, yeoman 2
4238913 2109231 2109231 defendant Peack Peter yeoman 615146 615146 Peack, Peter, of Clee, yeoman 0
4241841 2110262 2110262 defendant Curteys Leonard gent 615146 615146 Curteys, Leonard, of Clee, gent 0
4241843 2110263 2110263 defendant Holdesworthe Luke yeoman 615146 615146 Holdesworthe, Luke, of Clee, yeoman 0
4241844 2110263 2110263 defendant Curteys Leonard gent 615146 615146 Curteys, Leonard, of Clee, gent 1
4241848 2110265 2110265 defendant Curteys Leonard gent 615146 615146 Curteys, Leonard, of Clee, gent 0
4241852 2110267 2110267 defendant Holdesworthe Luke yeoman 615146 615146 Holdesworthe, Luke, of Clee, yeoman 0
4241853 2110267 2110267 defendant Curteys Leonard gent 615146 615146 Curteys, Leonard, of Clee, gent 1
4251400 2113449 2113449 defendant Curteys Leonard gent 615146 615146 Curteys, Leonard, of Clee, gent 0
4251402 2113450 2113450 defendant Holdesworthe Luke yeoman 615146 615146 Holdesworthe, Luke, of Clee, yeoman 0
4251403 2113450 2113450 defendant Curteys Leonard gent 615146 615146 Curteys, Leonard, of Clee, gent 1
4257944 2115628 2115628 defendant Peacocke Peter yeoman 615146 615146 Peacocke, Peter, of Clee, yeoman 1
4274471 2121017 2121017 defendant Grymelby John husbandman 615146 615146 Grymelby, John, of Clee, husbandman 0
4296089 2128698 2128698 defendant Pell Leonard husbandman 615146 615146 Pell, Leonard, of Clee, husbandman 1
4354678 2148867 2148867 defendant Curteys Leonard yeoman 615146 615146 Curteys, Leonard, of Clee, yeoman 0
4354679 2148867 2148867 defendant Pococke Peter yeoman 615146 615146 Pococke, Peter, of Clee, yeoman 1
4354680 2148867 2148867 defendant Pococke Francis formerley Francis Holesworth, widow 615146 615146 Francis his wife, formerley Francis Holesworth, of Clee, widow 2
4369321 2154091 2154091 defendant Tuplyn John yeoman 615146 615146 Tuplyn, John, of Clee, yeoman 0
4373649 2155646 2155646 defendant Leveracke James yeoman 615146 615146 together with Leveracke, James, of Clee, yeoman 1
4401952 2165246 2165246 defendant Leveracke James yeoman 615146 615146 together with Leveracke, James, of Clee, yeoman 1
4566580 2221119 2221119 defendant Pyngill John   615146 615146 Pyngill, John, of Clee 0
4591462 2228686 2228686 plaintiff Moigne Thomas   615146 615146 Moigne, Thomas, of Clee 0
4633993 2241484 2241484 defendant Barton Robert   615146 615146 Barton, Robert, of Clee 2
4633995 2241485 2241485 defendant Tokke John   615146 615146 Tokke, John, of Clee 0
4680098 2259386 2259386 defendant Waltham Robert husbandman 615146 615146 Waltham, Robert, of Clee, husbandman 1
4705440 2267068 2267068 defendant Laceby Robert husbandman 615146 615146 Laceby, Robert, of Clee, husbandman 0
4708167 2267932 2267932 defendant Curtaysse John, sen husbandman 615146 615146 Curtaysse, John, sen, of Clee, husbandman 1
4886141 2322525 2322525 defendant Smyth John mariner 615146 615146 Smyth, John, of Clee, mariner 0
4887160 2322829 2322829 defendant Croftes William husbandman 615146 615146 Croftes, William, of Clee, husbandman 0
4887162 2322830 2322830 defendant Jopson John husbandman 615146 615146 Jopson, John, of Clee, husbandman 0
4900047 2326645 2326645 defendant Croftes William husbandman 615146 615146 Croftes, William, of Clee, husbandman 0
4903910 2327837 2327837 defendant Smyth William laborer 615146 615146 Smyth, William, of Clee, laborer 2
4913156 2330612 2330612 defendant Curteis Brian husbandman 615146 615146 Curteis, Brian, of Clee, husbandman 0
4929610 2335675 2335675 defendant Laceby Simon husbandman 615146 615146 Laceby, Simon, of Clee, husbandman 0
4955383 2343569 2343569 defendant Dene John husbandman 615146 615146 Dene, John, of Clee, husbandman 0
4966324 2346862 2346862 plaintiff Denne John   615146 615146 Denne, John, of Clee 0
5090487 2383598 2383598 defendant Dene John merchant 615146 615146 Dene, John, of Clee, merchant 0
5129767 2395193 2395193 plaintiff Deen John   615146 615146 Deen, John, of Clee 0
5148914 2400809 2400809 plaintiff Deen John   615146 615146 Deen, John, of Clee 0
5148917 2400810 2400810 plaintiff Deen John   615146 615146 Deen, John, of Clee 0
5168052 2406368 2406368 plaintiff Deen John   615146 615146 Deen, John, of Clee 0
5168055 2406369 2406369 plaintiff Deen John   615146 615146 Deen, John, of Clee 0
5204030 2416930 2416930 plaintiff Deen John   615146 615146 Deen, John, of Clee 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);