names

54 rows where place_id = 600739

✎ 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
3642336 1908050 1908050 defendant Cook William gent 600739 600739 Cook, William, of North Walsham, Norf, gent 0
3735683 1937395 1937395 defendant Holle William   600739 600739 Holle, William, of North Walsham, Norf, worsted weaver 1
3876022 1982235 1982235 defendant Bailey Richard clerk 600739 600739 Bailey, Richard, of North Walsham, Norf, clerk 0
3876217 1982290 1982290 defendant Haylesdon Robert yeoman 600739 600739 Haylesdon, Robert, of North Walsham, Norf, yeoman 2
3915506 1995554 1995554 defendant Mathewe Roger yeoman 600739 600739 Mathewe, Roger, of North Walsham, Norf, yeoman 1
3941406 2004133 2004133 defendant Baxter Thomas carpenter 600739 600739 Baxter, Thomas, of North Walsham, Norf, carpenter 2
3969624 2013982 2013982 defendant Toppe Thomas husbandman 600739 600739 Toppe, Thomas, of North Walsham, Norf, husbandman 1
4010813 2028643 2028643 defendant Clackson Thomas salter 600739 600739 Clackson, Thomas, of North Walsham, Norf, or of London, salter 3
4036456 2037725 2037725 defendant Bacon Henry grocer 600739 600739 Bacon, Henry, of North Walsham, Norf, grocer 0
4036459 2037726 2037726 defendant Bacon Henry grocer 600739 600739 Bacon, Henry, of North Walsham, Norf, grocer 0
4063235 2047144 2047144 defendant Bretton Thomas gent 600739 600739 Bretton, Thomas, of North Walsham, Norf, gent 0
4097108 2059288 2059288 defendant Sutton Nicholas yeoman 600739 600739 Sutton, Nicholas, of North Walsham, Norf, yeoman 0
4117985 2066718 2066718 defendant Rye Thomas butcher 600739 600739 Rye, Thomas, of North Walsham, Norf, butcher 0
4186698 2090837 2090837 defendant Skarboroughe Henry yeoman 600739 600739 Skarboroughe, Henry, of North Walsham, Norf, yeoman 0
4281495 2123430 2123430 defendant Rolff Robert yeoman 600739 600739 Rolff, Robert, of North Walsham, Norf, yeoman 0
4676038 2258117 2258117 defendant Paston William draper 600739 600739 Paston, William, of North Walsham, Norf, draper 0
4676531 2258275 2258275 defendant Paston William yeoman 600739 600739 Paston, William, of North Walsham, Norf, yeoman 0
4689519 2262279 2262279 defendant Pallyng John yeoman 600739 600739 Pallyng, John, of North Walsham, Norf, yeoman 2
4717241 2270721 2270721 defendant Bygot Andrew glasier 600739 600739 Bygot, Andrew, of North Walsham, Norf, glasier 4
4725645 2273306 2273306 defendant Paston William draper 600739 600739 Paston, William, of North Walsham, Norf, draper 1
4728377 2274112 2274112 defendant Paston William draper 600739 600739 Paston, William, of North Walsham, Norf, draper 0
4730191 2274642 2274642 defendant Chapman Robert husbandman 600739 600739 Chapman, Robert, of North Walsham, Norf, husbandman 2
4731419 2275027 2275027 defendant Paston William draper 600739 600739 Paston, William, of North Walsham, Norf, draper 0
4736173 2276449 2276449 defendant Ulf Henry chapman 600739 600739 Ulf, Henry, of North Walsham, Norf, chapman 1
4762959 2284399 2284399 defendant Paston William draper 600739 600739 Paston, William, of North Walsham, Norf, draper 0
4770432 2286723 2286723 defendant Strecche Nicholas clerk 600739 600739 Strecche, Nicholas, of North Walsham, Norf, clerk 0
4792821 2293845 2293845 defendant Paston William draper 600739 600739 Paston, William, of North Walsham, Norf, draper 0
4793327 2294011 2294011 defendant Person Thomas husbandman 600739 600739 Person, Thomas, of North Walsham, Norf, husbandman 1
4802269 2296900 2296900 defendant Geddyng Nicholas clerk 600739 600739 Geddyng, Nicholas, of North Walsham, Norf, clerk 0
4817459 2301548 2301548 defendant Barry John butcher 600739 600739 Barry, John, of North Walsham, Norf, butcher 3
4837946 2307794 2307794 defendant Geddyng Nicholas   600739 600739 Geddyng, Nicholas, of North Walsham, Norf, vicar 2
4882592 2321465 2321465 defendant Rust Robert draper 600739 600739 Rust, Robert, of North Walsham, Norf, draper 0
4912103 2330288 2330288 defendant Pekhare William yeoman 600739 600739 Pekhare, William, of North Walsham, Norf, yeoman 2
4978777 2350603 2350603 plaintiff Rust alias Walsham John chaplain 600739 600739 Rust alias Walsham, John, of North Walsham, Norf, chaplain 0
4978779 2350604 2350604 plaintiff Rust John chaplain 600739 600739 Rust, John, of North Walsham, Norf, chaplain 0
5010152 2359833 2359833 defendant Wylyet Richard yeoman 600739 600739 Wylyet, Richard, of North Walsham, Norf, yeoman 0
5032212 2366302 2366302 plaintiff Rust John chaplain 600739 600739 Rust, John, of North Walsham, Norf, chaplain 0
5038576 2368182 2368182 defendant Plumsted Nicholas husbandman 600739 600739 Plumsted, Nicholas, of North Walsham, Norf, husbandman 0
5039691 2368514 2368514 defendant Plumsted Nicholas husbandman 600739 600739 Plumsted, Nicholas, of North Walsham, Norf, husbandman 0
5046110 2370464 2370464 defendant Hert Nicholas husbandman 600739 600739 Hert, Nicholas, of North Walsham, Norf, husbandman 0
5052027 2372218 2372218 defendant Rust Robert yeoman 600739 600739 Rust, Robert, of North Walsham, Norf, yeoman 2
5069648 2377420 2377420 defendant Roys William gent 600739 600739 Roys, William, of North Walsham, Norf, gent 2
5069654 2377421 2377421 defendant Roys William gent 600739 600739 Roys, William, of North Walsham, Norf, gent 2
5084602 2381908 2381908 defendant Roys William gent 600739 600739 Roys, William, of North Walsham, Norf, gent 0
5091620 2383938 2383938 defendant Glamford Robert husbandman 600739 600739 Glamford, Robert, of North Walsham, Norf, husbandman 0
5178124 2409307 2409307 defendant Albon Henry yeoman 600739 600739 Albon, Henry, of North Walsham, Norf, yeoman 1
5278113 2438693 2438693 defendant Albone Henry husbandman 600739 600739 Albone, Henry, of North Walsham, Norf, husbandman 0
5299619 2444860 2444860 defendant Hert Thomas husbandman 600739 600739 Hert, Thomas, of North Walsham, Norf, husbandman 0
5299934 2444946 2444946 defendant Albon Henry husbandman 600739 600739 Albon, Henry, of North Walsham, Norf, husbandman 0
5529443 2513719 2513719 defendant Bradfeld Robert mercer 600739 600739 Bradfeld, Robert, of North Walsham, Norf, mercer 2
5536937 2516040 2516040 defendant Aleyns Robert chapman 600739 600739 Aleyns, Robert, of North Walsham, Norf, chapman 3
5556232 2521819 2521819 defendant Bradfeld Robert yeoman 600739 600739 Bradfeld, Robert, of North Walsham, Norf, yeoman 1
5597292 2534065 2534065 defendant Hagon John butcher 600739 600739 Hagon, John, of North Walsham, Norf, butcher 0
5599761 2534814 2534814 defendant Hagon John butcher 600739 600739 Hagon, John, of North Walsham, Norf, butcher 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);