names

69 rows where place_id = 604301

✎ 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
3657553 1912624 1912624 defendant Maser Christopher tailor 604301 604301 Maser, Christopher, of Portsmouth, tailor 0
3657554 1912624 1912624 defendant Maser Thomas mariner 604301 604301 Maser, Thomas, of Portsmouth, mariner 1
3657555 1912624 1912624 defendant Maser Robert brewer 604301 604301 Maser, Robert, of Portsmouth, brewer 2
3657556 1912624 1912624 defendant Punton Thomas smith 604301 604301 Punton, Thomas, of Portsmouth, smith 3
3657557 1912624 1912624 defendant Fissher Richard brewer 604301 604301 Fissher, Richard, of Portsmouth, brewer 4
3662207 1914096 1914096 defendant Stowt Arnold beer brewer 604301 604301 Stowt, Arnold, of Portsmouth, beer brewer 1
3767845 1947581 1947581 defendant Murvyn John tailor 604301 604301 Murvyn, John, of Portsmouth, tailor 0
3957939 2009840 2009840 plaintiff Pytter Robert shoemaker 604301 604301 Pytter, Robert, of Portsmouth, shoemaker 0
3968143 2013484 2013484 defendant Legge Thomas yeoman 604301 604301 Legge, Thomas, of Portsmouth, yeoman 2
3968147 2013485 2013485 defendant Legge Thomas yeoman 604301 604301 Legge, Thomas, of Portsmouth, yeoman 2
3998015 2024049 2024049 defendant Robyns Francis merchant 604301 604301 Robyns, Francis, of Portsmouth, merchant 0
4022083 2032628 2032628 defendant Durdall Robert joiner 604301 604301 Durdall Robert, of Portsmouth, joiner 1
4022084 2032628 2032628 defendant Trenell alias Symond John butcher 604301 604301 Trenell alias Symond, John, of Portsmouth, butcher 2
4022114 2032638 2032638 defendant Clarke Robert fletcher 604301 604301 Clarke, Robert, of Portsmouth, fletcher 0
4022116 2032638 2032638 defendant Trenell alias Symond John butcher 604301 604301 Trenell alias Symond, John, of Portsmouth, butcher 2
4024262 2033380 2033380 defendant Russell Walter merchant 604301 604301 Russell, Walter, of Portsmouth, merchant 1
4024265 2033380 2033380 defendant Wayte Honor widow 604301 604301 Wayte, Honor, of Portsmouth, widow 4
4025940 2033927 2033927 defendant Russell Walter merchant 604301 604301 Russell, Walter, of Portsmouth, merchant 1
4025943 2033927 2033927 defendant Wayte Honor widow 604301 604301 Wayte, Honor, of Portsmouth, widow 4
4052714 2043402 2043402 defendant Napper John yeoman 604301 604301 Napper, John, of Portsmouth, yeoman 0
4100018 2060335 2060335 defendant Jervys Richard vintner 604301 604301 Jervys, Richard, of Portsmouth, vintner 0
4114561 2065495 2065495 defendant Thorney Thomas merchant 604301 604301 Thorney, Thomas, of Portsmouth, merchant 0
4180022 2088489 2088489 defendant Woodden John merchant 604301 604301 Woodden, John, of Portsmouth, or of Sussex, merchant 0
4268483 2119061 2119061 defendant Jarvis Jane widow 604301 604301 Jarvis, Jane, of Portsmouth, widow 1
4277860 2122185 2122185 defendant Ellutt John merchant 604301 604301 Ellutt, John, of Portsmouth, merchant 0
4277861 2122185 2122185 defendant Felder Henry merchant 604301 604301 Felder, Henry, of Portsmouth, merchant 1
4295594 2128510 2128510 defendant Thorney Thomas merchant 604301 604301 Thorney, Thomas, of Portsmouth, merchant 0
4303344 2131296 2131296 defendant Winter William gent 604301 604301 Winter, William, of Portsmouth, gent 0
4329694 2140226 2140226 defendant Herringe Andrew merchant 604301 604301 Herringe, Andrew, of Portsmouth, merchant 1
4346475 2146016 2146016 defendant Reeve Robert mercer 604301 604301 Reeve, Robert, of Portsmouth, mercer 1
4370218 2154408 2154408 defendant Reeve Robert mercer 604301 604301 Reeve, Robert, of Portsmouth, mercer 1
4370631 2154548 2154548 defendant John John gunner 604301 604301 John, John, of Portsmouth, gunner 0
4370632 2154548 2154548 defendant Burt alias Paule John baker 604301 604301 Burt alias Paule, John, of Portsmouth, baker 1
4417255 2170279 2170279 defendant Bayon John   604301 604301 Bayon, John, of Portsmouth, burgess 0
4540979 2213085 2213085 plaintiff Wildebregge Richard   604301 604301 Wildebregge, Richard, of Portsmouth, vicar 0
4541711 2213301 2213301 plaintiff Wykeham Nicholas master & warden of St Nicholas' hospital 604301 604301 Wykeham, Nicholas, of Portsmouth, master & warden of St Nicholas' hospital 0
4542615 2213574 2213574 defendant Shapwyk Richard   604301 604301 Shapwyk, Richard, of Portsmouth 6
4603344 2232241 2232241 defendant Holm John   604301 604301 Holm, John, of Portsmouth 4
4723609 2272688 2272688 defendant Hert Richard mariner 604301 604301 Hert, Richard, of Portsmouth, mariner 0
4747404 2279744 2279744 defendant Clerk Nicholas shipman 604301 604301 Clerk, Nicholas, of Portsmouth, shipman 0
4757490 2282720 2282720 defendant Kyng Simon chapman 604301 604301 Kyng, Simon, of Portsmouth, chapman 0
4765090 2285060 2285060 plaintiff Hosier John   604301 604301 Hosier, John, of Portsmouth 0
4767669 2285867 2285867 defendant Dymayn Richard smith 604301 604301 Dymayn, Richard, of Portsmouth, smith 2
4767670 2285867 2285867 defendant Bocher Nicholas butcher 604301 604301 Bocher, Nicholas, of Portsmouth, butcher 3
4775387 2288299 2288299 defendant Virsy John merchant 604301 604301 Virsy, John, of Portsmouth, merchant 0
4994970 2355355 2355355 plaintiff Furssay John   604301 604301 Furssay, John, of Portsmouth, bailiff for the town 0
4997796 2356197 2356197 defendant Copyndale Adam merchant 604301 604301 Copyndale, Adam, of Portsmouth, merchant 1
5009323 2359617 2359617 defendant Bedale Robert yeoman 604301 604301 Bedale, Robert, of Portsmouth, yeoman 0
5009324 2359617 2359617 defendant Copyndale Adam yeoman 604301 604301 together with Copyndale, Adam, of Portsmouth, yeoman 1
5142238 2398850 2398850 defendant Dewe Stephen   604301 604301 Dewe, Stephen, of Portsmouth 1
5147428 2400395 2400395 defendant Coleyn John merchant 604301 604301 Coleyn, John, of Portsmouth, merchant 2
5147432 2400396 2400396 defendant Coleyn John merchant 604301 604301 Coleyn, John, of Portsmouth, merchant 2
5147988 2400556 2400556 defendant Snoryng Richard merchant 604301 604301 Snoryng, Richard, of Portsmouth, merchant 4
5155390 2402727 2402727 defendant Waleys William merchant 604301 604301 Waleys, William, of Portsmouth, merchant 0
5163480 2405051 2405051 defendant Dewe Stephen merchant 604301 604301 Dewe, Stephen, of Portsmouth, merchant 1
5172048 2407540 2407540 defendant Waleys William merchant 604301 604301 Waleys, William, of Portsmouth, merchant 0
5200344 2415861 2415861 plaintiff Worley John merchant 604301 604301 Worley, John, of Portsmouth, merchant 0
5200346 2415862 2415862 plaintiff Worley John merchant 604301 604301 Worley, John, of Portsmouth, merchant 0
5200348 2415863 2415863 plaintiff Worley John merchant 604301 604301 Worley, John, of Portsmouth, merchant 0
5270601 2436499 2436499 plaintiff Elyot William Master or Warden of the Hospital of the House of God 604301 604301 Elyot, William, of Portsmouth, Master or Warden of the Hospital of the House of God 0
5298047 2444442 2444442 defendant Wyrley John merchant 604301 604301 Wyrley, John, of Portsmouth, merchant 0
5298048 2444442 2444442 defendant Calfe Richard merchant 604301 604301 Calfe, Richard, of Portsmouth, merchant 1
5309215 2447791 2447791 defendant Godewyn Michael clerk 604301 604301 Godewyn, Michael, of Portsmouth, clerk 0
5309216 2447791 2447791 defendant Godewyn John brother of Michael 604301 604301 Godewyn, John, of Portsmouth, butcher, brother of Michael 1
5389940 2472186 2472186 defendant Bele John husbandman 604301 604301 Bele, John, of Portsmouth, husbandman 0
5509167 2507726 2507726 defendant Worley John merchant 604301 604301 Worley, John, of Portsmouth, merchant 0
5509168 2507726 2507726 defendant Gay Richard merchant 604301 604301 Gay, Richard, of Portsmouth, merchant 1
5509169 2507726 2507726 defendant Bren William merchant 604301 604301 Bren, William, of Portsmouth, merchant 2
5512954 2508903 2508903 defendant Maser Robert shipman 604301 604301 Maser, Robert, of Portsmouth, shipman 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);