names

101 rows where place_id = 586780

✎ 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
3589607 1864390 1864390 defendant Aleyn Robert carpenter 586780 586780 Aleyn, Robert, of Northales, carpenter 0
3611258 1871198 1871198 defendant Ovy Godfrey husbandman 586780 586780 Ovy, Godfrey, of Northales, husbandman 4
3613389 1871833 1871833 defendant Ewyn William clerk 586780 586780 Ewyn, William, of Northales, clerk 0
3617091 1872970 1872970 defendant Weerson Hugh shoemaker 586780 586780 Weerson, Hugh, of Northales, shoemaker 0
3617550 1873112 1873112 defendant Fedyll John husbandman 586780 586780 Fedyll, John, of Northales, husbandman 0
3621692 1874323 1874323 defendant Fydyll John butcher 586780 586780 Fydyll, John, of Northales, butcher 2
3635552 1905923 1905923 plaintiff Payne Thomas gent 586780 586780 Payne, Thomas, of Northales, gent 0
3851581 1974082 1974082 plaintiff Payne Thomas gent 586780 586780 Payne, Thomas, of Northales, gent 0
3866141 1978905 1978905 plaintiff Payn Thomas gent 586780 586780 Payn, Thomas, of Northales, gent 0
3893328 1988002 1988002 plaintiff Payne Thomas gent 586780 586780 Payne, Thomas, of Northales, gent 0
3893330 1988003 1988003 plaintiff Payne Thomas gent 586780 586780 Payne, Thomas, of Northales, gent 0
3909991 1993649 1993649 defendant Holmys Thomas butcher 586780 586780 Holmys, Thomas, of Northales, butcher 0
3921361 1997488 1997488 plaintiff Payne Thomas gent 586780 586780 Payne, Thomas, of Northales, gent 0
3921366 1997488 1997488 defendant Brosche Robert mariner 586780 586780 Brosche, Robert, of Northales, mariner 4
3929134 2000083 2000083 plaintiff Brydgges John   586780 586780 Brydgges, John, of Northales 0
3929135 2000083 2000083 defendant Tompson Wiliam mariner 586780 586780 Tompson, Wiliam, of Northales, mariner 0
3941247 2004077 2004077 plaintiff Tompson William   586780 586780 Tompson, William, of Northales 0
3941248 2004077 2004077 defendant Debden Robert mariner 586780 586780 Debden, Robert, of Northales, mariner 0
3941249 2004077 2004077 defendant Gavell Henry mariner 586780 586780 Gavell, Henry, of Northales, mariner 1
3942078 2004365 2004365 defendant Tompson Wiliam mariner 586780 586780 Tompson, Wiliam, of Northales, mariner 0
3998095 2024076 2024076 defendant Frende Lawrence husbandman 586780 586780 Frende, Lawrence, of Northales, husbandman 0
3998097 2024077 2024077 defendant Frend Lawrence husbandman 586780 586780 Frend, Lawrence, of Northales, husbandman 0
4096182 2058962 2058962 defendant Blomvile Jerome yeoman 586780 586780 Blomvile, Jerome, of Northales, yeoman 2
4104257 2061800 2061800 defendant Payne Gregory (legal representative) 586780 586780 Payne, Gregory, of Northales, gent, executor of 0
4104258 2061800 2061800 defendant Payne Robert gent 586780 586780 Payne, Robert, of Northales, gent 1
4169493 2084833 2084833 defendant Warfor Richard husbandman 586780 586780 Warfor, Richard, of Northales, husbandman 0
4192913 2093086 2093086 defendant Warfor Richard husbandman 586780 586780 Warfor, Richard, of Northales, husbandman 0
4232820 2106985 2106985 defendant Rushe Richard yeoman 586780 586780 Rushe, Richard, of Northales, yeoman 0
4241485 2110135 2110135 defendant Rushe Richard yeoman 586780 586780 Rushe, Richard, of Northales, yeoman 0
4247442 2112126 2112126 defendant Burnell Francis gent 586780 586780 Burnell, Francis, of Northales, gent 0
4275248 2121280 2121280 defendant Bowler Humphrey husbandman 586780 586780 Bowler, Humphrey, of Northales, husbandman 2
4447528 2184141 2184141 plaintiff (not given) William vicar of Elyot 586780 586780 Elyot, William, of Northales, vicar of the church 0
4515726 2205346 2205346 plaintiff Clerk Roger (legal representative) 586780 586780 Clerk, Roger, of Northales, executors of 0
4515728 2205346 2205346 plaintiff Gamyn John   586780 586780 Gamyn, John, of Northales 2
4583841 2226363 2226363 plaintiff Gace Thomas   586780 586780 Gace, Thomas, of Northales 0
4583842 2226363 2226363 defendant Newehous John shipman 586780 586780 Newehous, John, of Northales, shipman 0
4606495 2233142 2233142 plaintiff Bakere Walter   586780 586780 Bakere, Walter, of Northales 0
4672003 2256888 2256888 plaintiff Chinele John   586780 586780 Chinele, John, of Northales 0
4672393 2257018 2257018 defendant Sherewynde Thomas tailor 586780 586780 Sherewynde, Thomas, of Northales, tailor 0
4676501 2258265 2258265 plaintiff Godard John chaplain 586780 586780 Godard, John, of Northales, chaplain 0
4677200 2258487 2258487 plaintiff Halle Laurence   586780 586780 Halle, Laurence, of Northales, on his own account 0
4677202 2258487 2258487 defendant Roughed Joan widow 586780 586780 Roughed, Joan, of Northales, widow 1
4697012 2264544 2264544 plaintiff Chivele John   586780 586780 Chivele, John, of Northales 0
4721395 2272025 2272025 defendant atte Hill John butcher 586780 586780 atte Hill, John, of Northales, butcher 2
4721396 2272025 2272025 defendant Bertram Alexander baker 586780 586780 Bertram, Alexander, of Northales, baker 3
4734840 2276053 2276053 defendant atte Hyll John butcher 586780 586780 atte Hyll, John, of Northales, butcher 0
4757185 2282616 2282616 defendant Durant Henry   586780 586780 Durant, Henry, of Northales, shoe maker 0
4781759 2290309 2290309 defendant Skarlet Thomas cooper 586780 586780 Skarlet, Thomas, of Northales, cooper 0
4787030 2292007 2292007 defendant Brend Robert smith 586780 586780 Brend, Robert, of Northales, smith 0
4810287 2299363 2299363 plaintiff Ewyn John butcher 586780 586780 Ewyn, John, of Northales, butcher 0
4864588 2315897 2315897 plaintiff Forthe Robert   586780 586780 Forthe, Robert, of Northales 0
4923929 2333922 2333922 defendant Hamond John husbandman 586780 586780 Hamond, John, of Northales, husbandman 3
4923930 2333922 2333922 defendant Bigge William husbandman 586780 586780 Bigge, William, of Northales, husbandman 4
4925574 2334434 2334434 defendant Nunne Thomas shipman 586780 586780 Nunne, Thomas, of Northales, shipman 0
4968487 2347543 2347543 defendant Hille William baker 586780 586780 Hille, William, of Northales, baker 0
4969986 2347974 2347974 plaintiff Hamond John   586780 586780 Hamond, John, of Northales 0
4992503 2354641 2354641 defendant Fylby Alexander husbandman 586780 586780 Fylby, Alexander, of Northales, husbandman 0
4995178 2355409 2355409 defendant Hill William baker 586780 586780 Hill, William, of Northales, baker 0
5023054 2363649 2363649 defendant Fylby Alexander butcher 586780 586780 Fylby, Alexander, of Northales, butcher 1
5032088 2366258 2366258 defendant Fuller William fuller 586780 586780 Fuller, William, of Northales, fuller 0
5032089 2366258 2366258 defendant Filby Alexander butcher 586780 586780 Filby, Alexander, of Northales, butcher 1
5032090 2366258 2366258 defendant Gyslam Walter shipman 586780 586780 Gyslam, Walter, of Northales, shipman 2
5032091 2366258 2366258 defendant Broun John painter 586780 586780 Broun, John, of Northales, painter 3
5043336 2369630 2369630 defendant Thetforde alias Blome John clerk 586780 586780 Thetforde alias Blome, John, of Northales, clerk 0
5070048 2377535 2377535 defendant Godryche Thomas shipman 586780 586780 Godryche, Thomas, of Northales, shipman 2
5070570 2377694 2377694 defendant Holme William shoemaker 586780 586780 Holme, William, of Northales, shoemaker 0
5070593 2377699 2377699 defendant Broun John painter 586780 586780 Broun, John, of Northales, painter 0
5099204 2386194 2386194 defendant Skynner William cordwainer 586780 586780 Skynner, William, of Northales, cordwainer 1
5099205 2386194 2386194 defendant Hille William baker 586780 586780 Hille, William, of Northales, baker 2
5101532 2386862 2386862 defendant Hill William baker 586780 586780 Hill, William, of Northales, baker 0
5227227 2423595 2423595 defendant Holme William shoemaker 586780 586780 Holme, William, of Northales, shoemaker 2
5265591 2434992 2434992 defendant Doraunt William husbandman 586780 586780 Doraunt, William, of Northales, husbandman 0
5281927 2439790 2439790 defendant Crosseforth Robert shipman 586780 586780 Crosseforth, Robert, of Northales, shipman 0
5302779 2445814 2445814 defendant Northen Robert mariner 586780 586780 Northen, Robert, of Northales, mariner 0
5302780 2445814 2445814 defendant Broun Richard mariner 586780 586780 Broun, Richard, of Northales, mariner 1
5302781 2445814 2445814 defendant Walette Robert reeder 586780 586780 Walette, Robert, of Northales, reeder 2
5309021 2447737 2447737 defendant Joynt John (legal representative) 586780 586780 Joynt, John, of Northales, yeoman, executors of 0
5309022 2447737 2447737 defendant Joynt Alice widow 586780 586780 (Joynt, Alice, of Northales, widow 1
5309023 2447737 2447737 defendant Yermouth William clerk 586780 586780 Yermouth, William, of Northales, clerk 2
5309024 2447737 2447737 defendant Mason Thomas mercer 586780 586780 Mason, Thomas, of Northales, mercer 3
5381688 2469817 2469817 plaintiff Jermoth alias Yermoth William clerk 586780 586780 Jermoth alias Yermoth, William, of Northales, clerk 0
5389497 2472050 2472050 plaintiff Jermoth William clerk 586780 586780 Jermoth, William, of Northales, clerk 0
5397604 2474382 2474382 defendant Wynne John baker 586780 586780 Wynne, John, of Northales, baker 0
5410711 2478149 2478149 defendant Wynne John baker 586780 586780 Wynne, John, of Northales, baker 0
5424749 2482360 2482360 defendant Wynne John baker 586780 586780 Wynne, John, of Northales, baker 0
5440778 2487153 2487153 plaintiff Mason Thomas   586780 586780 Mason, Thomas, of Northales 2
5447124 2489030 2489030 defendant Tookes John husbandman 586780 586780 Tookes, John, of Northales, husbandman 3
5453994 2491086 2491086 plaintiff Mason Thomas   586780 586780 Mason, Thomas, of Northales 2
5453998 2491087 2491087 plaintiff Mason Thomas   586780 586780 Mason, Thomas, of Northales 2
5459580 2492778 2492778 defendant Tookes John husbandman 586780 586780 Tookes, John, of Northales, husbandman 3
5465882 2494713 2494713 plaintiff Mason Thomas   586780 586780 Mason, Thomas, of Northales 2
5484877 2500401 2500401 plaintiff Nunne Thomas   586780 586780 Nunne, Thomas, of Northales 0
5484878 2500401 2500401 defendant Oldryng Alexander (legal representative) 586780 586780 Oldryng, Alexander, of Northales, yeoman, executor of 0
5517574 2510338 2510338 defendant Broun William carpenter 586780 586780 Broun, William, of Northales, carpenter 0
5548096 2519472 2519472 defendant Grene John   586780 586780 Grene, John, of Northales, shipwright 0
5567768 2525150 2525150 plaintiff Edrich William butcher 586780 586780 Edrich, William, of Northales, butcher 0
5567769 2525150 2525150 defendant Mason William mariner 586780 586780 Mason, William, of Northales, mariner 0
5602196 2535586 2535586 defendant Aleyn Robert carpenter 586780 586780 Aleyn, Robert, of Northales, carpenter 0
5613487 2548009 2548009 defendant Skynnere Gilbert   586780 586780 Skynnere, Gilbert, of Northales 1
5619016 2549794 2549794 defendant Sparhauk William   586780 586780 Sparhauk, William, of Northales 0

Next page

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