names

51 rows where place_id = 627360

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3775796 1950178 1950178 defendant Byrde Robert merchant 627360 627360 Byrde, Robert, of Havant, Hants, merchant 0
3864441 1978305 1978305 defendant Terry John dyer 627360 627360 Terry, John, of Havant, Hants, dyer 0
3864444 1978306 1978306 defendant Tyrry John dyer 627360 627360 Tyrry, John, of Havant, Hants, dyer 0
3886002 1985569 1985569 defendant Ryve Richard mercer 627360 627360 Ryve, Richard, of Havant, Hants, mercer 4
3887995 1986235 1986235 defendant Foster Andrew chapman 627360 627360 Foster, Andrew, of Havant, Hants, chapman 3
3926090 1999046 1999046 defendant Foster Andrew chapman 627360 627360 Foster, Andrew, of Havant, Hants, chapman 1
3926265 1999108 1999108 defendant Mill Richard yeoman 627360 627360 Mill, Richard, of Havant, Hants, yeoman 0
3928717 1999940 1999940 defendant Russell Richard capper 627360 627360 Russell, Richard, of Havant, Hants, capper 3
4004242 2026296 2026296 defendant Cotton Edward gent 627360 627360 Cotton, Edward, of Havant, Hants, gent 0
4059512 2045796 2045796 defendant Goodwyn Humphrey chapman 627360 627360 Goodwyn, Humphrey, of Havant, Hants, chapman 1
4065597 2047986 2047986 defendant Collens William chapman 627360 627360 Collens, William, of Havant, Hants, chapman 1
4065994 2048126 2048126 defendant Myll John tailor 627360 627360 Myll, John, of Havant, Hants, tailor 0
4068575 2049048 2049048 defendant Goodwyn Humphrey chapman 627360 627360 Goodwyn, Humphrey, of Havant, Hants, chapman 0
4079559 2052987 2052987 defendant Goodwyn Humphrey chapman 627360 627360 Goodwyn, Humphrey, of Havant, Hants, chapman 0
4081543 2053708 2053708 defendant Kempe alias Kent John chapman 627360 627360 Kempe alias Kent, John, of Havant, Hants, chapman 0
4137897 2073912 2073912 defendant Cleverley Thomas husbandman 627360 627360 Cleverley, Thomas, of Havant, Hants, husbandman 0
4179365 2088256 2088256 defendant Kempe John, junior mercer 627360 627360 Kempe, John, junior, of Havant, Hants, mercer 0
4194245 2093536 2093536 defendant Wolgar Arthur chapman 627360 627360 Wolgar, Arthur, of Havant, Hants, chapman 4
4209703 2098946 2098946 defendant Cleverley Thomas husbandman 627360 627360 Cleverley, Thomas, of Havant, Hants, husbandman 0
4244721 2111218 2111218 defendant Heynes Thomas yeoman 627360 627360 Heynes, Thomas, of Havant, Hants, yeoman 0
4256824 2115254 2115254 defendant Bates Henry chapman 627360 627360 Bates, Henry, of Havant, Hants, chapman 0
4268613 2119098 2119098 defendant Heynes Thomas yeoman 627360 627360 Heynes, Thomas, of Havant, Hants, yeoman 0
4346460 2146013 2146013 defendant Bates Henry chapman 627360 627360 Bates, Henry, of Havant, Hants, chapman 2
4379715 2157840 2157840 defendant Leake Edward gent 627360 627360 Leake, Edward, of Havant, Hants, gent 1
4649953 2246003 2246003 defendant Culpas Thomas   627360 627360 Culpas, Thomas, of Havant, Hants 3
4716128 2270350 2270350 defendant Marnham John   627360 627360 Marnham, John, of Havant, Hants, parson 1
4812367 2299979 2299979 defendant Robert John butcher 627360 627360 Robert, John, of Havant, Hants, butcher 4
4971374 2348366 2348366 defendant Welles Richard merchant 627360 627360 Welles, Richard, of Havant, Hants, merchant 0
4989352 2353750 2353750 defendant Bocher John butcher 627360 627360 Bocher, John, of Havant, Hants, butcher 1
5125154 2393834 2393834 defendant Baker Thomas   627360 627360 Baker, Thomas, of Havant, Hants, wool monger 0
5130154 2395304 2395304 defendant Folye Peter merchant 627360 627360 Folye, Peter, of Havant, Hants, merchant 2
5135828 2396993 2396993 defendant Baker Thomas mariner 627360 627360 Baker, Thomas, of Havant, Hants, mariner 0
5138408 2397741 2397741 defendant Champernoun Thomas yeoman or bailiff or rent gatherer 627360 627360 Champernoun, Thomas, of Havant, Hants, yeoman or bailiff or rent gatherer 0
5138414 2397742 2397742 defendant Champnoun Thomas yeoman & bailiff & rent gaderer 627360 627360 Champnoun, Thomas, of Havant, Hants, yeoman & bailiff & rent gaderer 0
5140047 2398193 2398193 defendant (illegible) Simon yeoman 627360 627360 ---, Simon, of Havant, Hants, yeoman 0
5143771 2399312 2399312 defendant Baker Thomas   627360 627360 Baker, Thomas, of Havant, Hants, wool monger 0
5149476 2400978 2400978 defendant Bastard John mariner 627360 627360 Bastard, John, of Havant, Hants, mariner 1
5156104 2402945 2402945 defendant Baker Thomas merchant 627360 627360 Baker, Thomas, of Havant, Hants, merchant 0
5172420 2407661 2407661 defendant Baker Thomas merchant 627360 627360 Baker, Thomas, of Havant, Hants, merchant 0
5191878 2413357 2413357 defendant Baker Thomas merchant 627360 627360 Baker, Thomas, of Havant, Hants, merchant 0
5223492 2422562 2422562 defendant Pury William chapman 627360 627360 Pury, William, of Havant, Hants, chapman 0
5226366 2423382 2423382 defendant Champernon Thomas   627360 627360 Champernon, Thomas, of Havant, Hants, yeoman, bailiff of Bedehampton, Hants 0
5246456 2429126 2429126 defendant Blamond Stephen smith 627360 627360 Blamond, Stephen, of Havant, Hants, smith 1
5365684 2464930 2464930 defendant Pery William chapman 627360 627360 Pery, William, of Havant, Hants, chapman 4
5365690 2464931 2464931 defendant Pery William chapman 627360 627360 Pery, William, of Havant, Hants, chapman 4
5409427 2477783 2477783 defendant Weston William gent 627360 627360 Weston, William, of Havant, Hants, gent 1
5423019 2481833 2481833 defendant Doo William gent 627360 627360 Doo, William, of Havant, Hants, gent 1
5423022 2481834 2481834 defendant Westbroke William gent 627360 627360 Westbroke, William, of Havant, Hants, gent 1
5452298 2490562 2490562 defendant Hoskyn Walter weaver 627360 627360 Hoskyn, Walter, of Havant, Hants, weaver 0
5452303 2490563 2490563 defendant Hoskyn Walter weaver 627360 627360 Hoskyn, Walter, of Havant, Hants, weaver 0
5487267 2501088 2501088 defendant Hoskyn Walter weaver 627360 627360 Hoskyn, Walter, of Havant, Hants, weaver 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);