names

68 rows where place_id = 663253

✎ 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
3851796 1974151 1974151 defendant Jermyn Thomas (legal representative) 663253 663253 Jermyn, Thomas, of Portsmouth, Hants, clerk, executors of 0
3935323 2002128 2002128 defendant West Herny   663253 663253 (West, Herny, of Portsmouth, Hants, inn holder 1
3968146 2013485 2013485 defendant Hollowaye John yeoman 663253 663253 Hollowaye, John, of Portsmouth, Hants, yeoman 1
3971066 2014432 2014432 defendant Hollowaye John merchant 663253 663253 Hollowaye, John, of Portsmouth, Hants, merchant 0
3971661 2014651 2014651 defendant Slater Thomas yeoman 663253 663253 Slater, Thomas, of Portsmouth, Hants, yeoman 0
3974825 2015760 2015760 defendant Hollowaye John yeoman 663253 663253 Hollowaye, John, of Portsmouth, Hants, yeoman 0
4020728 2032141 2032141 defendant Robyns Francis husbandman 663253 663253 Robyns, Francis, of Portsmouth, Hants, husbandman 0
4020730 2032142 2032142 defendant Robyns Francis husbandman 663253 663253 Robyns, Francis, of Portsmouth, Hants, husbandman 0
4022889 2032911 2032911 defendant Frobussher David merchant tailor 663253 663253 Frobussher, David, of Portsmouth, Hants, or of London, merchant tailor 0
4024261 2033380 2033380 defendant Poyner Thomas merchant 663253 663253 Poyner, Thomas, of Portsmouth, Hants, merchant 0
4025939 2033927 2033927 defendant Poyner Thomas merchant 663253 663253 Poyner, Thomas, of Portsmouth, Hants, merchant 0
4036670 2037798 2037798 defendant Winter William, junior gent 663253 663253 Winter, William, junior, of Portsmouth, Hants, gent 1
4051225 2042877 2042877 defendant Threder Christopher clerk 663253 663253 Threder, Christopher, of Portsmouth, Hants, clerk 0
4059505 2045793 2045793 defendant Furbussher David chapman 663253 663253 Furbussher, David, of Portsmouth, Hants, chapman 2
4076207 2051779 2051779 defendant Elton Francis merchant 663253 663253 Elton, Francis, of Portsmouth, Hants, merchant 0
4079576 2052993 2052993 defendant Furbussher David mercer 663253 663253 Furbussher, David, of Portsmouth, Hants, mercer 0
4079578 2052994 2052994 defendant Furbussher David mercer 663253 663253 Furbussher, David, of Portsmouth, Hants, mercer 0
4082709 2054123 2054123 defendant Storye John mariner 663253 663253 Storye, John, of Portsmouth, Hants, mariner 1
4088498 2056185 2056185 defendant Robyns Francis widow 663253 663253 Robyns, Francis, of Portsmouth, Hants, widow 2
4093192 2057882 2057882 defendant Ratclyff Henry   663253 663253 Ratclyff, Henry, of Portsmouth, Hants, knight 0
4104644 2061943 2061943 defendant Thorney Thomas merchant 663253 663253 Thorney, Thomas, of Portsmouth, Hants, merchant 0
4166087 2083645 2083645 defendant Elton Francis chapman 663253 663253 Elton, Francis, of Portsmouth, Hants, chapman 0
4203422 2096749 2096749 defendant Wedden John merchant 663253 663253 Wedden, John, of Portsmouth, Hants, or of Sussex, merchant 0
4207314 2098111 2098111 defendant Jarvys Richard vintner 663253 663253 Jarvys, Richard, of Portsmouth, Hants, vintner 0
4207516 2098187 2098187 defendant Segwicke Richard merchant 663253 663253 Segwicke, Richard, of Portsmouth, Hants, merchant 0
4212396 2099884 2099884 defendant Jarvys Richard chapman 663253 663253 Jarvys, Richard, of Portsmouth, Hants, chapman 1
4254483 2114489 2114489 defendant Thorney Thomas chapman 663253 663253 Thorney, Thomas, of Portsmouth, Hants, chapman 0
4254486 2114490 2114490 defendant Thorny Thomas chapman 663253 663253 Thorny, Thomas, of portsmouth, Hants, chapman 0
4262734 2117205 2117205 defendant Ryves Mathew chapman 663253 663253 Ryves, Mathew, of Portsmouth, Hants, chapman 1
4267563 2118784 2118784 defendant Ryves Mathew merchant 663253 663253 Ryves, Mathew, of Portsmouth, Hants, chapman, or of Newporte, Isle of Wight, merchant 1
4268482 2119061 2119061 defendant Jarvis Richard (legal representative) 663253 663253 Jarvis, Richard, of Portsmouth, Hants, merchant, vintner, administratrix of 0
4273437 2120675 2120675 defendant Ryves Mathew chapman 663253 663253 Ryves, Mathew, of Portsmouth, Hants, chapman 1
4276099 2121587 2121587 defendant Genbye Richard merchant 663253 663253 Genbye, Richard, of Portsmouth, Hants, merchant 0
4289549 2126326 2126326 defendant Quarles Jonah gent 663253 663253 Quarles, Jonah, of Portsmouth, Hants, or of London, gent 1
4292301 2127309 2127309 defendant Sedwick Elizabeth widow 663253 663253 Sedwick, Elizabeth, of Portsmouth, Hants, widow 6
4299934 2130070 2130070 defendant Thorney Thomas gent 663253 663253 Thorney, Thomas, of Portsmouth, Hants, gent 0
4302390 2130957 2130957 defendant James Mark mercer 663253 663253 James, Mark, of Portsmouth, Hants, mercer 0
4320396 2137233 2137233 defendant Bruninge   widow 663253 663253 Bruninge, , of Portsmouth, Hants, widow 2
4321827 2137719 2137719 defendant Woodden John merchant 663253 663253 Woodden, John, of Portsmouth, Hants or of Shoreham, Sussex, merchant 3
4346474 2146016 2146016 defendant Elyott John mercer 663253 663253 Elyott, John, of Portsmouth, Hants, mercer 0
4359492 2150553 2150553 defendant Bearde John yeoman 663253 663253 Bearde, John, of Portsmouth, Hants, yeoman 0
4366982 2153244 2153244 defendant Woodden John gent 663253 663253 Woodden, John, of Portsmouth, Hants, gent 0
4370217 2154408 2154408 defendant Elyott John mercer 663253 663253 Elyott, John, of Portsmouth, Hants, mercer 0
4693492 2263465 2263465 defendant Fresey John husbandman 663253 663253 Fresey, John, of Portsmouth, Hants, husbandman 1
4697137 2264583 2264583 defendant Gaye Richard husbandman 663253 663253 Gaye, Richard, of Portsmouth, Hants, husbandman 2
4741954 2278143 2278143 defendant Marnam John clerk 663253 663253 Marnam, John, of Portsmouth, Hants, clerk 0
4755987 2282256 2282256 defendant Wady William yeoman 663253 663253 Wady, William, of Portsmouth, Hants, yeoman 1
4768742 2286201 2286201 defendant Brewer John husbandman 663253 663253 Brewer, John, of Portsmouth, Hants, husbandman 0
4842174 2309087 2309087 defendant Lewen Thomas fuller 663253 663253 Lewen, Thomas, of Portsmouth, Hants, fuller 2
4997795 2356197 2356197 defendant Spy_ John merchant 663253 663253 Spy_, John, of Portsmouth, Hants, merchant 0
5124723 2393706 2393706 defendant Gracy alias Guy John   663253 663253 Gracy alias Guy, John, of Portsmouth, Hants, esq & Constable of Goderych, Herefordshire 2
5124728 2393707 2393707 defendant Gracy alias Guy John esq & Constable of Herefordshire 663253 663253 Gracy alias Guy, John, of Portsmouth, Hants, esq & Constable of Herefordshire 2
5128333 2394765 2394765 defendant Virsy John merchant 663253 663253 Virsy, John, of Portsmouth, Hants, merchant 1
5142237 2398850 2398850 defendant (illegible) Peter merchant 663253 663253 ----, Peter, of Portsmouth, Hants, merchant 0
5147427 2400395 2400395 defendant Virsy John merchant 663253 663253 Virsy, John, of Portsmouth, Hants, merchant 1
5147431 2400396 2400396 defendant Virsy John merchant 663253 663253 Virsy, John, of Portsmouth, Hants, merchant 1
5149254 2400913 2400913 defendant Gracy alias Guy John esq 663253 663253 Gracy alias Guy, John, of Portsmouth, Hants, esq alias constable of Goderych, Herefs, esq 2
5149259 2400914 2400914 defendant Gracy John esq & constable 663253 663253 Gracy, John, of Portsmouth, Hants, esq, alias Guy, John, of Goderych, Herefs, esq & constable 2
5149264 2400915 2400915 defendant Gracy John esq & constable 663253 663253 Gracy, John, of Portsmouth, Hants, esq, alias Guy, John, of Goderych, Herefs, esq & constable 2
5159908 2403995 2403995 defendant Due Stephen merchant 663253 663253 Due, Stephen, of Portsmouth, Hants, merchant 0
5163479 2405051 2405051 defendant Bernys Peter de merchant 663253 663253 Bernys, Peter de, of Portsmouth, Hants, merchant 0
5167139 2406123 2406123 defendant Virsy John   663253 663253 Virsy, John, of Portsmouth, Hants 1
5167140 2406123 2406123 defendant Coleyn John merchant 663253 663253 Coleyn, John, of Portsmouth, Hants, merchant 2
5168239 2406423 2406423 defendant Gracy alias Guy John esq 663253 663253 Gracy alias Guy, John, of Portsmouth, Hants, esq alias constable of Goderych, Herefs, esq 2
5168244 2406424 2406424 defendant Gracy alias Guy John esq 663253 663253 Gracy alias Guy, John, of Portsmouth, Hants, esq alias constable of Goderych, Herefs, esq 2
5174878 2408348 2408348 defendant Due Stephen merchant 663253 663253 Due, Stephen, of Portsmouth, Hants, merchant 0
5195729 2414494 2414494 defendant Due alias Coleyn Stephen merchant 663253 663253 Due alias Coleyn, Stephen, of Portsmouth, Hants, merchant 0
5466488 2494914 2494914 defendant Martyn Peter merchant 663253 663253 Martyn, Peter, of Portsmouth, Hants, merchant 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);