names

72 rows where place_id = 629878

✎ 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
3791017 1955026 1955026 defendant Kentyng Robert yeoman 629878 629878 Kentyng, Robert, of Walcott, yeoman 0
3791018 1955026 1955026 defendant Fox Lawrence husbandman 629878 629878 Fox, Lawrence, of Walcott, husbandman 1
3791019 1955026 1955026 defendant Thyrcok Thomas husbandman 629878 629878 Thyrcok, Thomas, of Walcott, husbandman 2
3791020 1955026 1955026 defendant Heygate Thomas husbandman 629878 629878 Heygate, Thomas, of Walcott, husbandman 3
3798393 1957395 1957395 defendant Turnour John gent 629878 629878 Turnour, John, of Walcott, gent 0
3807272 1960172 1960172 defendant Kentyng Robert yeoman 629878 629878 Kentyng, Robert, of Walcott, yeoman 0
3807273 1960172 1960172 defendant Fox Lawrence husbandman 629878 629878 Fox, Lawrence, of Walcott, husbandman 1
3807274 1960172 1960172 defendant Thyrcoke Thomas husbandman 629878 629878 Thyrcoke, Thomas, of Walcott, husbandman 2
3807275 1960172 1960172 defendant Heygate Thomas husbandman 629878 629878 Heygate, Thomas, of Walcott, husbandman 3
3902312 1991005 1991005 defendant Browne John gent 629878 629878 Browne, John,of Walcott, gent 0
3902313 1991005 1991005 defendant Botery Robert   629878 629878 Botery, Robert, of Walcott 1
3902314 1991005 1991005 defendant Capett John   629878 629878 Capett, John, of Walcott 2
3906015 1992298 1992298 defendant Malery Robert husbandman 629878 629878 Malery, Robert, of Walcott, husbandman 0
3906016 1992298 1992298 defendant Hurst Ogerston George husbandman 629878 629878 Hurst Ogerston, George, of Walcott, husbandman 1
4027961 2034649 2034649 defendant Lacye Lawrence yeoman 629878 629878 Lacye, Lawrence, of Walcott, yeoman 0
4033000 2036453 2036453 defendant Cubit Thomas yeoman 629878 629878 Cubit, Thomas, of Walcott, yeoman 0
4056875 2044840 2044840 defendant Walcott Charles gent 629878 629878 Walcott, Charles, of Walcott, gent 0
4063790 2047335 2047335 defendant Watson John husbandman 629878 629878 Watson, John, of Walcott, husbandman 0
4076099 2051744 2051744 defendant Warde John husbandman 629878 629878 Warde, John, of Walcott, husbandman 1
4079537 2052978 2052978 defendant Watson Thomas husbandman 629878 629878 Watson, Thomas, of Walcott, husbandman 3
4087002 2055645 2055645 defendant Walcott Charles gent 629878 629878 Walcott, Charles, of Walcott, gent 0
4145939 2076736 2076736 defendant Warde Robert, junior husbandman 629878 629878 Warde, Robert, junior, of Walcott, husbandman 0
4145940 2076736 2076736 defendant Warde Thomas husbandman 629878 629878 Warde, Thomas, of Walcott, husbandman 1
4145941 2076736 2076736 defendant Warde Christopher tailor 629878 629878 Warde, Christopher, of Walcott, tailor 2
4145942 2076736 2076736 defendant Warde Edmund husbandman 629878 629878 Warde, Edmund, of Walcott, husbandman 3
4145943 2076736 2076736 defendant Marke John tailor 629878 629878 Marke, John, of Walcott, tailor 4
4160185 2081625 2081625 defendant Everyt William husbandman 629878 629878 Everyt, William, of Walcott, husbandman 0
4164902 2083234 2083234 defendant Warde Thomas yeoman 629878 629878 Warde, Thomas, of Walcott, yeoman 0
4164904 2083235 2083235 defendant Warde Thomas yeoman 629878 629878 Warde, Thomas, of Walcott, yeoman 0
4164905 2083235 2083235 defendant Snalwyn Thomas laborer 629878 629878 Snalwyn, Thomas, of Walcott, laborer 1
4164906 2083235 2083235 defendant Crowe John laborer 629878 629878 Crowe, John, of Walcott, laborer 2
4164909 2083236 2083236 defendant Warde Thomas yeoman 629878 629878 Warde, Thomas, of Walcott, yeoman 0
4164910 2083236 2083236 defendant Warde John yeoman 629878 629878 Warde, John, of Walcott, yeoman 1
4164911 2083236 2083236 defendant Powle William laborer 629878 629878 Powle, William, of Walcott, laborer 2
4164924 2083240 2083240 defendant Warde Robert, senior husbandman 629878 629878 Warde, Robert, senior, of Walcott, husbandman 0
4164925 2083240 2083240 defendant Warde Robert, junior husbandman 629878 629878 Warde, Robert, junior, of Walcott, husbandman 1
4164926 2083240 2083240 defendant Warde Edmund husbandman 629878 629878 Warde, Edmund, of Walcott, husbandman 2
4164928 2083241 2083241 defendant Warde Robert, senior husbandman 629878 629878 Warde, Robert, senior, of Walcott, husbandman 0
4164929 2083241 2083241 defendant Warde Robert, junior husbandman 629878 629878 Warde, Robert, junior, of Walcott, husbandman 1
4164930 2083241 2083241 defendant Warde Edmund husbandman 629878 629878 Warde, Edmund, of Walcott, husbandman 2
4164932 2083242 2083242 defendant Warde Robert, senior husbandman 629878 629878 Warde, Robert, senior, of Walcott, husbandman 0
4164933 2083242 2083242 defendant Warde Robert, junior husbandman 629878 629878 Warde, Robert, junior, of Walcott, husbandman 1
4164934 2083242 2083242 defendant Warde Edmund husbandman 629878 629878 Warde, Edmund, of Walcott, husbandman 2
4214000 2100418 2100418 defendant Drake John husbandman 629878 629878 Drake, John, of Walcott, husbandman 2
4214001 2100418 2100418 defendant Shorte Lawrence husbandman 629878 629878 Shorte, Lawrence, of Walcott, husbandman 3
4218494 2101967 2101967 defendant Evans Richard gent 629878 629878 Evans, Richard, of Walcott, gent 0
4221467 2103000 2103000 defendant Warde Thomas yeoman 629878 629878 Warde, Thomas, of Walcott, yeoman 0
4221469 2103001 2103001 defendant Warde Thomas yeoman 629878 629878 Warde, Thomas, of Walcott, yeoman 0
4221470 2103001 2103001 defendant Warde John yeoman 629878 629878 Warde, John, of Walcott, yeoman 1
4231900 2106656 2106656 defendant Quyncye John yeoman 629878 629878 Quyncye, John, of Walcott, yeoman 0
4261217 2116718 2116718 defendant Watson Nicholas husbandman 629878 629878 Watson, Nicholas, of Walcott, husbandman 0
4273039 2120543 2120543 defendant Quynsey John yeoman 629878 629878 Quynsey, John, of Walcott, yeoman 0
4281978 2123597 2123597 defendant Warde Thomas yeoman 629878 629878 Warde, Thomas, of Walcott, yeoman 0
4286123 2125092 2125092 defendant Warde Adam husbandman 629878 629878 Warde, Adam, of Walcott, husbandman 1
4286124 2125092 2125092 defendant Gressham Simon husbandman 629878 629878 Gressham, Simon, of Walcott, husbandman 2
4302649 2131044 2131044 defendant Quynsey John yeoman 629878 629878 Quynsey, John, of Walcott, yeoman 0
4311709 2134237 2134237 defendant Sympson William husbandman 629878 629878 Sympson, William, of Walcott, husbandman 2
4316543 2135903 2135903 defendant Warde Robert, senior yeoman 629878 629878 Warde, Robert, senior, of Walcott, yeoman 0
4320626 2137304 2137304 defendant Warde Thomas yeoman 629878 629878 Warde, Thomas, of Walcott, yeoman 2
4320799 2137368 2137368 defendant Page Thomas yeoman 629878 629878 Page, Thomas, of Walcott, yeoman 0
4320800 2137368 2137368 defendant Warde Robert husbandman 629878 629878 Warde, Robert, of Walcott, husbandman 1
4320801 2137368 2137368 defendant Page Robert husbandman 629878 629878 Page, Robert, of Walcott, husbandman 2
4323501 2138280 2138280 defendant Warde John yeoman 629878 629878 Warde, John, of Walcott, yeoman 0
4332724 2141228 2141228 defendant Warde Thomas yeoman 629878 629878 Warde, Thomas, of Walcott, yeoman 2
4342619 2144691 2144691 defendant Watson John yeoman 629878 629878 Watson, John, of Walcott, yeoman 0
4342621 2144692 2144692 defendant Page Thomas yeoman 629878 629878 Page, Thomas, of Walcott, yeoman 0
4342623 2144693 2144693 defendant Page Robert yeoman 629878 629878 Page, Robert, of Walcott, yeoman 0
4343629 2145049 2145049 defendant Cooke Thomas singleman 629878 629878 Cooke, Thomas, of Walcott, yeoman, singleman 0
4352056 2147955 2147955 defendant Mytt William (legal representative) 629878 629878 Mytt, William, of Walcott, husbandman, executors of 0
4357665 2149915 2149915 defendant Brereley Richard yeoman 629878 629878 Brereley, Richard, of Walcott, yeoman 0
5050309 2371717 2371717 plaintiff Thomson William   629878 629878 Thomson, William, of Walcott 0
5596659 2533876 2533876 defendant Tyrcok Edmund husbandman 629878 629878 Tyrcok, Edmund, of Walcott, 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);