names

84 rows where place_id = 598659

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3633453 1905276 1905276 defendant Lychefeld John husbandman 598659 598659 Lychefeld, John, of Havant, husbandman 0
3635034 1905757 1905757 defendant Levard or Lebard Thomas miller 598659 598659 Levard or Lebard, Thomas, of Havant, miller 0
3646028 1909154 1909154 defendant Chamber William dyer 598659 598659 Chamber, William, of Havant, dyer 0
3658253 1912835 1912835 defendant Chamberleyne William husbandman 598659 598659 Chamberleyne, William, of Havant, husbandman 2
3661976 1914037 1914037 defendant Morgan William yeoman 598659 598659 Morgan, William, of Havant, yeoman 2
3671893 1917206 1917206 defendant Mewes alias Pynnoke Thomas butcher 598659 598659 Mewes alias Pynnoke, Thomas, of Havant, butcher 0
3829272 1967038 1967038 defendant A Downe Thomas miller 598659 598659 A Downe, Thomas, of Havant, miller 0
3863102 1977858 1977858 defendant Westmyll John tanner 598659 598659 Westmyll, John, of Havant, tanner 0
3863104 1977859 1977859 defendant Westmyll John tanner 598659 598659 Westmyll, John, of Havant, tanner 0
3875486 1982043 1982043 defendant Langrige John mercer 598659 598659 Langrige, John, of Havant, mercer 2
3877500 1982711 1982711 defendant Trype Thomas barber 598659 598659 Trype, Thomas, of Havant, barber 0
3885996 1985568 1985568 defendant Foster Andrew chapman 598659 598659 Foster, Andrew, of Havant, chapman 0
3891924 1987552 1987552 defendant Whycher John clothier 598659 598659 Whycher, John, of Havant, clothier 2
3891931 1987553 1987553 defendant Wycher John clothier 598659 598659 Wycher, John, of Havant, clothier 3
3913669 1994911 1994911 defendant Foster Andrew chandler 598659 598659 Foster, Andrew, of Havant, chandler 3
3919388 1996814 1996814 defendant Langerege John yeoman 598659 598659 Langerege, John, of Havant, yeoman 2
3923441 1998145 1998145 plaintiff Smythe Edmund butcher 598659 598659 Smythe, Edmund, of Havant, butcher 0
4068576 2049048 2049048 defendant Wytt John saddler 598659 598659 Wytt, John, of Havant, saddler 1
4117227 2066468 2066468 defendant Myll or Milles John draper 598659 598659 Myll or Milles, John, of Havant, draper 1
4117228 2066468 2066468 defendant Fytsall John yeoman or gent 598659 598659 Fytsall, John, of Havant, yeoman or gent 2
4137898 2073912 2073912 defendant Thecker Thomas wheeler 598659 598659 Thecker, Thomas, of Havant, wheeler 1
4137899 2073912 2073912 defendant Carter Humphrey husbandman 598659 598659 Carter, Humphrey, of Havant, husbandman 2
4209704 2098946 2098946 defendant Thecker Thomas wheeler 598659 598659 Thecker, Thomas, of Havant, wheeler 1
4209705 2098946 2098946 defendant Carter Humphrey husbandman 598659 598659 Carter, Humphrey, of Havant, husbandman 2
4217680 2101677 2101677 defendant Cowper John yeoman 598659 598659 Cowper, John, of Havant, or of Lyminster, Sussex, yeoman 0
4235281 2107900 2107900 defendant Godfrye Nicholas butcher 598659 598659 Godfrye, Nicholas, of Havant, butcher 0
4339782 2143685 2143685 defendant Godfrey Nicholas butcher 598659 598659 Godfrey, Nicholas, of Havant, butcher 0
4339783 2143685 2143685 defendant Whither Edward clothier 598659 598659 Whither, Edward, of Havant, clothier 1
4339784 2143685 2143685 defendant Eton Bartholomew butcher 598659 598659 Eton, Bartholomew, of Havant, butcher 2
4339785 2143685 2143685 defendant Hickley Barnard sherman 598659 598659 Hickley, Barnard, of Havant, sherman 3
4634750 2241720 2241720 plaintiff Ailward Thomas   598659 598659 Ailward, Thomas, of Havant, parson 3
4634755 2241721 2241721 plaintiff Ailward Thomas   598659 598659 Ailward, Thomas, of Havant, parson 3
4634761 2241722 2241722 plaintiff Ailward Thomas   598659 598659 Ailward, Thomas, of Havant, parson 3
4634778 2241728 2241728 plaintiff (not given) Thomas rector of Ailward 598659 598659 Ailward, Thomas, of Havant, rector of the church 3
4644922 2244583 2244583 plaintiff Merser William (legal representative) 598659 598659 Merser, William, of Havant, executors of 0
4676475 2258256 2258256 plaintiff Glovere Alice (legal representative) 598659 598659 Glovere, Alice, of Havant, executors of 0
4676478 2258256 2258256 defendant Chaundeler John husbandman 598659 598659 Chaundeler, John, of Havant, husbandman 0
4692593 2263200 2263200 defendant Blowestok Robert husbandman 598659 598659 Blowestok, Robert, of Havant, husbandman 0
4694222 2263694 2263694 plaintiff Blakeman William   598659 598659 Blakeman, William, of Havant 0
4695056 2263946 2263946 plaintiff Brampton Henry   598659 598659 Brampton, Henry, of Havant 0
4695059 2263947 2263947 plaintiff Brampton Henry   598659 598659 Brampton, Henry, of Havant 0
4700931 2265695 2265695 plaintiff Foto_ William (legal representative) 598659 598659 Foto_, William, of Havant, executors of 0
4703992 2266628 2266628 plaintiff Hore John   598659 598659 Hore, John, of Havant 0
4704317 2266728 2266728 defendant Mersh John shipman 598659 598659 Mersh, John, of Havant, shipman 0
4724659 2273011 2273011 plaintiff Fayrware John   598659 598659 Fayrware, John, of Havant 0
4759822 2283404 2283404 defendant Spenser John tailor 598659 598659 Spenser, John, of Havant, tailor 0
4763325 2284517 2284517 defendant Spencer John hosier 598659 598659 Spencer, John, of Havant, hosier 0
4843349 2309435 2309435 defendant Shotte John laborer 598659 598659 Shotte, John, of Havant, laborer 2
4865870 2316297 2316297 defendant Goode Thomas butcher 598659 598659 Goode, Thomas, of Havant, butcher 0
4865872 2316298 2316298 defendant Goode Thomas butcher 598659 598659 Goode, Thomas, of Havant, butcher 0
4907854 2329018 2329018 defendant Gode Thomas butcher 598659 598659 Gode, Thomas, of Havant, butcher 0
4907855 2329018 2329018 defendant Bromle Thomas butcher 598659 598659 Bromle, Thomas, of Havant, butcher 1
4931439 2336212 2336212 defendant Walkelyn Richard butcher 598659 598659 (Walkelyn, Richard, of Havant, butcher 2
4953138 2342903 2342903 defendant Arnald Thomas   598659 598659 Arnald, Thomas, of Havant, "tryakylmonger" 0
4986614 2352927 2352927 defendant Broun William   598659 598659 Broun, William, of Havant, shoe maker 0
5000298 2356963 2356963 defendant Combe Thomas   598659 598659 Combe, Thomas, of Havant, inland fish seller 0
5008213 2359287 2359287 defendant Bemnond Thomas fuller 598659 598659 Bemnond, Thomas, of Havant, fuller 0
5008214 2359287 2359287 defendant Sengton John   598659 598659 Sengton, John, of Havant, servant 1
5022462 2363471 2363471 defendant Kenteshe Thomas laborer 598659 598659 Kenteshe, Thomas, of Havant, laborer 0
5027070 2364789 2364789 defendant Shotton Thomas tailor 598659 598659 Shotton, Thomas, of Havant, tailor 0
5130155 2395304 2395304 defendant Bastard John mariner 598659 598659 Bastard, John, of Havant, mariner 3
5188470 2412345 2412345 defendant Pe_ William mercer 598659 598659 Pe_, William, of Havant, mercer 0
5189357 2412621 2412621 defendant Stokys John fishmonger 598659 598659 Stokys, John, of Havant, fishmonger 3
5191479 2413249 2413249 defendant Nassheley John shoemaker 598659 598659 Nassheley, John, of Havant, shoemaker 0
5196503 2414729 2414729 defendant Hamond John smith 598659 598659 Hamond, John, of Havant, smith 2
5209673 2418568 2418568 defendant Hamond John smith 598659 598659 Hamond, John, of Havant, smith 2
5223895 2422673 2422673 defendant Cormonger Thomas husbandman 598659 598659 Cormonger, Thomas, of Havant, husbandman 2
5297459 2444259 2444259 defendant Reynold Thomas hosier 598659 598659 Reynold, Thomas, of Havant, hosier 0
5319726 2450994 2450994 defendant Pounde Thomas esq 598659 598659 Pounde, Thomas, of Havant, esq 0
5329581 2453913 2453913 defendant Morell Richard butcher 598659 598659 Morell, Richard, of Havant, butcher 2
5384186 2470564 2470564 defendant Messanger Alice widow 598659 598659 Messanger, Alice, of Havant, widow 3
5397808 2474441 2474441 defendant Symond William cooper 598659 598659 Symond, William, of Havant, cooper 0
5399379 2474897 2474897 defendant Westbroke William yeoman 598659 598659 Westbroke, William, of Havant, yeoman 0
5409282 2477744 2477744 defendant Messanger Alice widow 598659 598659 Messanger, Alice, of Havant, widow 3
5554610 2521381 2521381 defendant Birde Robert mercer 598659 598659 Birde, Robert, of Havant, mercer 1
5554611 2521381 2521381 defendant Colwey Thomas gent 598659 598659 Colwey, Thomas, of Havant, gent 2
5554616 2521382 2521382 defendant Morgan William mercer 598659 598659 Morgan, William, of Havant, mercer 1
5583294 2529848 2529848 defendant Margan William mercer 598659 598659 Margan, William, of Havant, mercer 0
5583295 2529848 2529848 defendant Mewes Thomas butcher 598659 598659 Mewes, Thomas, of Havant, butcher 1
5583296 2529848 2529848 defendant Waller John tailor 598659 598659 Waller, John, of Havant, tailor 2
5583297 2529848 2529848 defendant Stempe Richard tanner 598659 598659 Stempe, Richard, of Havant, tanner 3
5583298 2529848 2529848 defendant Colpas Edward cordwainrer 598659 598659 Colpas, Edward, of Havant, cordwainrer 4
5583299 2529848 2529848 defendant Berneham Richard laborer 598659 598659 Berneham, Richard, of Havant, laborer 5
5583300 2529848 2529848 defendant Mylnes Stephen wheeler 598659 598659 Mylnes, Stephen, of Havant, wheeler 6

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);