names

63 rows where place_id = 755134

✎ 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
4425933 2172912 2172912 defendant Hayward Henry le   755134 755134 Hayward, Henry le, of the Soke of Winchester 4
4461277 2188612 2188612 defendant Swonyld John   755134 755134 Swonyld, John, of the Soke of Winchester 0
4513401 2204609 2204609 plaintiff Bromle Alice   755134 755134 Bromle, Alice, of the Soke of Winchester 0
4556591 2217999 2217999 plaintiff Huwe William dyer 755134 755134 Huwe, William, of the soke of Winchester, dyer 0
4556593 2217999 2217999 plaintiff Caperyg Peter   755134 755134 Caperyg, Peter, of the soke of Winchester 2
4557074 2218139 2218139 plaintiff Kerby Nicholas   755134 755134 Kerby, Nicholas, of the Soke of Winchester 0
4565326 2220720 2220720 defendant Man John   755134 755134 Man, John, of the Soke of Winchester 0
4565328 2220721 2220721 defendant Man John   755134 755134 Man, John, of the Soke of Winchester 0
4565576 2220803 2220803 defendant Denemede Philip   755134 755134 Denemede, Philip, of the soke of Winchester 0
4565578 2220804 2220804 defendant Denemede Philip   755134 755134 Denemede, Philip, of the soke of Winchester 0
4565583 2220806 2220806 plaintiff Snel Roger draper 755134 755134 Snel, Roger, of the soke of Winchester, draper 0
4565588 2220808 2220808 defendant Denemede Philip   755134 755134 Denemede, Philip, of the soke of Winchester 0
4565590 2220809 2220809 defendant Donemede Philip   755134 755134 Donemede, Philip, of the soke of Winchester 0
4575535 2223856 2223856 plaintiff Bour Edmund   755134 755134 Bour, Edmund, of the Soke of Winchester 0
4580354 2225336 2225336 defendant Wollar William   755134 755134 Wollar, William, of the Soke of Winchester 0
4587457 2227482 2227482 defendant Wellare William   755134 755134 Wellare, William, of the Soke of Winchester 0
4589036 2227948 2227948 plaintiff Lavynton Thomas   755134 755134 Lavynton, Thomas, of the soke of Winchester 0
4694629 2263817 2263817 plaintiff Bonour John   755134 755134 Bonour, John, of the Soke of Winchester 0
4696897 2264510 2264510 plaintiff Chese John   755134 755134 Chese, John, of the Soke of Winchester 0
4707656 2267757 2267757 defendant Boure Edmund husbandman 755134 755134 Boure, Edmund, of the Soke of Winchester, husbandman 0
4712219 2269136 2269136 defendant Waleys John dyer 755134 755134 Waleys, John, of the Soke of Winchester, dyer 0
4712221 2269137 2269137 defendant Waleys John dyer 755134 755134 Waleys, John, of the Soke of Winchester, dyer 0
4717783 2270901 2270901 defendant Heryng Edward   755134 755134 Heryng, Edward, of the Soke of Winchester, servant 0
4721729 2272133 2272133 plaintiff Chese John   755134 755134 Chese, John, of the Soke of Winchester 0
4723940 2272787 2272787 defendant Pollard Thomas tanner 755134 755134 Pollard, Thomas, of the soke of Winchester, tanner 0
4737298 2276784 2276784 defendant Swon John tanner 755134 755134 Swon, John, of the Soke of Winchester, tanner 0
4756910 2282528 2282528 plaintiff Polard Thomas   755134 755134 Polard, Thomas, of the Soke of Winchester 2
4832083 2306062 2306062 plaintiff Talton Thomas   755134 755134 Talton, Thomas, of the Soke of Winchester 2
4832889 2306309 2306309 defendant Toky Roger   755134 755134 Toky, Roger, of the Soke of Winchester, lime burner 0
4840052 2308438 2308438 plaintiff Hewe William dyer 755134 755134 Hewe, William, of the Soke of Winchester, dyer 0
4853361 2312462 2312462 defendant Welynowe Philip fuller 755134 755134 Welynowe, Philip, of the Soke of Winchester, fuller 1
4988201 2353440 2353440 defendant Roper John ostler 755134 755134 Roper, John, of the soke of Winchester, ostler 0
4989734 2353845 2353845 defendant Dogger Richard   755134 755134 Dogger, Richard, of the soke of Winchester, mill man 0
4989735 2353845 2353845 defendant Versy John sawyer 755134 755134 Versy, John, of the soke of Winchester, sawyer 1
4994896 2355325 2355325 defendant Sone John tanner 755134 755134 Sone, John, of the soke of Winchester, tanner 0
4997497 2356103 2356103 defendant Dutton Robert smith 755134 755134 Dutton, Robert, of the soke of Winchester, smith 0
5008626 2359420 2359420 defendant Aune William of weaver 755134 755134 Aune, William of, of the soke of Winchester, weaver 0
5148716 2400748 2400748 plaintiff Dalton Richard fuller 755134 755134 Dalton, Richard, of the soke of Winchester, fuller 0
5152639 2401912 2401912 defendant Bonefaunte Philip tailor 755134 755134 Bonefaunte, Philip, of the Soke of Winchester, tailor 0
5152640 2401912 2401912 defendant Huby Peter baker 755134 755134 Huby, Peter, of the Soke of Winchester, baker 1
5202049 2416365 2416365 defendant Bradewey Martin chapman 755134 755134 Bradewey, Martin, of the Soke of Winchester, chapman 1
5298879 2444652 2444652 defendant Mugge Reginald husbandman 755134 755134 Mugge, Reginald, of the Soke of Winchester, husbandman 3
5308846 2447688 2447688 defendant Dregge John yeoman 755134 755134 Dregge, John, of the soke of Winchester, yeoman 0
5308847 2447688 2447688 defendant Strecche John weaver 755134 755134 Strecche, John, of the soke of Winchester, weaver 1
5308848 2447688 2447688 defendant Bokelonde John chapman 755134 755134 Bokelonde, John, of the soke of Winchester, chapman 2
5311069 2448340 2448340 defendant Couper John yeoman 755134 755134 Couper, John, of the Soke of Winchester, yeoman 0
5436041 2485720 2485720 defendant Borough Christopher yeoman 755134 755134 Borough, Christopher, of the Soke of Winchester, yeoman 1
5438206 2486361 2486361 defendant Scharde Oliver yeoman 755134 755134 Scharde, Oliver, of the Soke by Winchester, yeoman 1
5438207 2486361 2486361 defendant Curteys William pewterer 755134 755134 Curteys, William, of the Soke by Winchester, pewterer 2
5438208 2486361 2486361 defendant Vyncent John fuller 755134 755134 Vyncent, John, of the Soke by Winchester, fuller 3
5445266 2488479 2488479 defendant Curteys William   755134 755134 Curteys, William, of the soke of Winchester 1
5447083 2489015 2489015 defendant Vyncent John   755134 755134 Vyncent, John, of the Soke of Winchester 0
5452322 2490567 2490567 defendant Shard Oliver yeoman 755134 755134 Shard, Oliver, of the Soke by Winchester, yeoman 1
5454210 2491161 2491161 defendant Borough Christopher yeoman 755134 755134 Borough, Christopher, of the Soke of Winchester, yeoman 1
5457393 2492112 2492112 defendant Curteys William pewterer 755134 755134 Curteys, William, of the Soke of Winchester, pewterer 0
5462999 2493843 2493843 defendant Borough Christopher yeoman 755134 755134 Borough, Christopher, of the Soke of Winchester, yeoman 0
5469216 2495722 2495722 defendant Curteys William pewterer 755134 755134 Curteys, William, of the Soke of Winchester, pewterer 0
5469252 2495734 2495734 defendant Taillour John fuller 755134 755134 Taillour, John, of the Soke of Winchester, fuller 0
5474547 2497362 2497362 defendant Borough Christopher yeoman 755134 755134 Borough, Christopher, of the Soke of Winchester, yeoman 0
5475780 2497754 2497754 defendant Sherd Oliver yeoman 755134 755134 Sherd, Oliver, of the Soke of Winchester, yeoman 1
5475781 2497754 2497754 defendant Curteys William pewterer 755134 755134 Curteys, William, of the Soke of Winchester, pewterer 2
5475782 2497754 2497754 defendant Vyncent John   755134 755134 Vyncent, John, of the Soke by Winchester 3
5615536 2548649 2548649 defendant Thornere John   755134 755134 Thornere, John, of the Soke of Winchester 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);