names

55 rows where place_id = 587439

✎ 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
3591423 1864944 1864944 defendant Nest John merchant 587439 587439 Nest, John, of Portesmouth, merchant 0
3595110 1866101 1866101 defendant Elyot William clerk 587439 587439 Elyot, William, of Portesmouth, clerk 0
3647693 1909668 1909668 defendant Turgose Michael (legal representative) 587439 587439 Turgose, Michael, of Portesmouth, tailor, executor of 4
3711331 1929850 1929850 defendant Wytney Osmund butcher 587439 587439 Wytney, Osmund, of Portesmouth, butcher 0
3747796 1941232 1941232 defendant Morfeld John tailor 587439 587439 Morfeld, John, of Portesmouth, tailor 0
3764716 1946628 1946628 plaintiff Hynton John   587439 587439 Hynton, John, of Portesmouth 0
3767842 1947580 1947580 defendant Murvyn John tailor 587439 587439 Murvyn, John, of Portesmouth, tailor 0
3790837 1954962 1954962 defendant Hynton John beer brewer 587439 587439 Hynton, John, of Portesmouth, beer brewer 0
3816578 1963086 1963086 defendant Frye William (legal representative) 587439 587439 Frye, William, of Portesmouth, executors of 0
3816581 1963087 1963087 defendant Frye William (legal representative) 587439 587439 Frye, William, of Portesmouth, executors of 0
4022082 2032628 2032628 defendant Clarke Robert fletcher 587439 587439 Clarke, Robert, of Portesmouth, fletcher 0
4093222 2057893 2057893 defendant Trinell John gent 587439 587439 Trinell, John, of Portesmouth, gent 0
4240220 2109699 2109699 defendant Trennell Henry butcher 587439 587439 Trennell, Henry, of Portesmouth, butcher 0
4361076 2151129 2151129 defendant Reve Robert mercer 587439 587439 Reve, Robert, of Portesmouth, mercer 1
4367392 2153391 2153391 defendant Elliott John merchant 587439 587439 Elliott, John, of Portesmouth, merchant 0
4367394 2153392 2153392 defendant Jenvey Richard merchant 587439 587439 Jenvey, Richard, of Portesmouth, merchant 0
4806621 2298280 2298280 defendant Sampson Richard chapman 587439 587439 Sampson, Richard, of Portesmouth, chapman 1
4826962 2304472 2304472 defendant Foxholte John clerk 587439 587439 Foxholte, John, of Portesmouth, clerk 0
4856023 2313256 2313256 defendant Virsey John merchant 587439 587439 Virsey, John, of Portesmouth, merchant 0
4871602 2318088 2318088 defendant Virsey John merchant 587439 587439 Virsey, John, of Portesmouth, merchant 0
4882459 2321424 2321424 defendant atte Mille Walter   587439 587439 atte Mille, Walter, of Portesmouth 2
4955080 2343471 2343471 defendant Coleyn John yeoman 587439 587439 Coleyn, John, of Portesmouth, yeoman 3
4995687 2355552 2355552 defendant Holmer Thomas carpenter 587439 587439 Holmer, Thomas, of Portesmouth, carpenter 0
5014673 2361158 2361158 plaintiff Berne John   587439 587439 Berne, John, of Portesmouth 0
5018131 2362191 2362191 plaintiff Coleyn John merchant 587439 587439 Coleyn, John, of Portesmouth, merchant 0
5018132 2362191 2362191 defendant Waleys William merchant 587439 587439 Waleys, William, of Portesmouth, merchant 0
5018133 2362191 2362191 defendant Bylbery William merchant 587439 587439 Bylbery, William, of Portesmouth, merchant 1
5020776 2362972 2362972 defendant Sampson Richard merchant 587439 587439 Sampson, Richard, of Portesmouth, merchant 1
5084263 2381802 2381802 defendant Cook William mariner 587439 587439 Cook,William, of Portesmouth, mariner 1
5128334 2394765 2394765 defendant Coleyn John merchant 587439 587439 Coleyn, John, of Portesmouth, merchant 2
5128788 2394903 2394903 defendant Snoryng Richard merchant 587439 587439 Snoryng, Richard, of Portesmouth, merchant 4
5135254 2396809 2396809 defendant Waleys William merchant 587439 587439 Waleys, William, of Portesmouth, merchant 0
5182955 2410760 2410760 defendant Snoryng Richard merchant 587439 587439 Snoryng, Richard, of Portesmouth, merchant 4
5211458 2419085 2419085 plaintiff Worley John esq 587439 587439 Worley, John, of Portesmouth, esq 0
5217759 2420923 2420923 plaintiff Foule Robert   587439 587439 Foule, Robert, of Portesmouth 0
5219762 2421504 2421504 defendant Bounde Margaret widow 587439 587439 Bounde, Margaret, of Portesmouth, widow 2
5219763 2421504 2421504 defendant Bounde John fisher 587439 587439 Bounde, John, of Portesmouth, fisher 3
5223893 2422673 2422673 defendant Botiller Richard husbandman 587439 587439 Botiller, Richard, of Portesmouth, husbandman 0
5223894 2422673 2422673 defendant Berne John, junior chapman 587439 587439 Berne, John, junior, of Portesmouth, chapman 1
5227045 2423567 2423567 defendant Trygoll Walter mariner 587439 587439 Trygoll, Walter, of Portesmouth, mariner 1
5227046 2423567 2423567 defendant Balchyff Thomas husbandman 587439 587439 Balchyff, Thomas, of Portesmouth, husbandman 2
5271761 2436839 2436839 defendant A--- John butcher 587439 587439 A---, John, of Portesmouth, butcher 1
5272786 2437117 2437117 defendant Johnson Geoffrey laborer 587439 587439 Johnson, Geoffrey, of Portesmouth, laborer 0
5272787 2437117 2437117 defendant Johnson Walter laborer 587439 587439 Johnson, Walter, of Portesmouth, laborer 1
5334358 2455347 2455347 defendant Martyn Peter merchant 587439 587439 Martyn, Peter, of Portesmouth, merchant 1
5345242 2458682 2458682 defendant Martyn Peter merchant 587439 587439 Martyn, Peter, of Portesmouth, merchant 0
5363428 2464214 2464214 defendant Torgys Michael tailor 587439 587439 Torgys, Michael, of Portesmouth, tailor 0
5437837 2486248 2486248 defendant Godewyn John brother of Michael Godewyn 587439 587439 Godewyn, John, of Portesmouth, butcher, brother of Michael Godewyn 1
5441635 2487416 2487416 defendant Cheddar John, senior husbandman 587439 587439 Cheddar, John, senior, of Portesmouth, husbandman 0
5490427 2502031 2502031 defendant Harrop Thomas pewterer 587439 587439 Harrop, Thomas, of Portesmouth, pewterer 1
5494176 2503163 2503163 defendant Worley John merchant 587439 587439 Worley, John, of Portesmouth, merchant 0
5494177 2503163 2503163 defendant Gay Richard merchant 587439 587439 Gay, Richard, of Portesmouth, merchant 1
5494178 2503163 2503163 defendant Bern William merchant 587439 587439 Bern, William, of Portesmouth, merchant 2
5509026 2507681 2507681 defendant Bokelond Thomas baker 587439 587439 Bokelond, Thomas, of Portesmouth, baker 1
5528264 2513398 2513398 defendant Harope Thomas baker 587439 587439 Harope, Thomas, of Portesmouth, baker 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);