names

69 rows where place_id = 612801

✎ 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
3695097 1924681 1924681 defendant Percy Robbert gent 612801 612801 Percy, Robbert, of Scotton, gent 0
3709043 1929126 1929126 defendant Percy Rpbert gent 612801 612801 Percy, Rpbert, of Scotton, gent 0
3723646 1933670 1933670 defendant Percy Robert gent 612801 612801 Percy, Robert, of Scotton, gent 0
3807078 1960107 1960107 defendant Stodder William husbandman 612801 612801 Stodder, William, of Scotton, husbandman 0
3834718 1968793 1968793 defendant Spunk John barker 612801 612801 Spunk, John, of Scotton, barker 3
3880572 1983762 1983762 defendant Thorpe Edward yeoman 612801 612801 Thorpe, Edward, of Scotton, yeoman 2
4114918 2065624 2065624 defendant Luddyngton Robert gent 612801 612801 Luddyngton, Robert, of Scotton, gent 0
4114919 2065624 2065624 defendant Luddyngton Thomas gent 612801 612801 Luddyngton, Thomas, of Scotton, gent 1
4116685 2066262 2066262 defendant Pearcye John gent 612801 612801 Pearcye, John, of Scotton, gent 1
4161500 2082096 2082096 defendant Hooper Edmund yeoman 612801 612801 Hooper, Edmund, of Scotton, yeoman 1
4191617 2092626 2092626 defendant Pullen John gent 612801 612801 Pullen, John, of Scotton, gent 1
4297171 2129090 2129090 defendant Scoxy Hugh husbandman 612801 612801 Scoxy, Hugh, of Scotton, husbandman 0
4307304 2132693 2132693 defendant Pullen John esq 612801 612801 Pullen, John, of Scotton, esq 0
4367689 2153496 2153496 defendant Lancaster William husbandman 612801 612801 Lancaster, William, of Scotton, husbandman 0
4368679 2153849 2153849 defendant Smyth John yeoman 612801 612801 Smyth, John, of Scotton, yeoman 0
4373553 2155609 2155609 defendant Ryges William yeoman 612801 612801 Ryges, William, of Scotton, yeoman 3
4381403 2158458 2158458 defendant Pulleyn John gent 612801 612801 Pulleyn, John, of Scotton, gent 0
4381405 2158458 2158458 defendant Bannebrigg Denis gent 612801 612801 Bannebrigg, Denis, of Scotton, gent 2
4397652 2163793 2163793 defendant Tennant John gent 612801 612801 Tennant, John, of Scotton, gent 0
4407019 2166905 2166905 defendant Pulleyn John gent 612801 612801 Pulleyn, John, of Scotton, gent 1
4427879 2173559 2173559 defendant Tope John   612801 612801 Tope, John, of Scotton 1
4499604 2200518 2200518 defendant Crappull Walter   612801 612801 (Crappull, Walter, of Scotton 1
4523237 2207591 2207591 defendant Alger Thomas   612801 612801 Alger, Thomas, of Scotton, parson 1
4524796 2208093 2208093 defendant Meson William   612801 612801 Meson, William, of Scotton 3
4554243 2217254 2217254 defendant Sclater John   612801 612801 Sclater, John, of Scotton 0
4554246 2217254 2217254 defendant Warde Thomas   612801 612801 Warde, Thomas, of Scotton 3
4554249 2217255 2217255 defendant Sclater John   612801 612801 Sclater, John, of Scotton 0
4554252 2217255 2217255 defendant Warde Thomas   612801 612801 Warde, Thomas, of Scotton 3
4556319 2217917 2217917 defendant Sclater William   612801 612801 Sclater, William, of Scotton 0
4567574 2221421 2221421 defendant Thornton William   612801 612801 Thornton, William, of Scotton 0
4576646 2224206 2224206 defendant Thornton William   612801 612801 Thornton, William, of Scotton 0
4592099 2228885 2228885 defendant Grethede Robert   612801 612801 Grethede, Robert, of Scotton 0
4622491 2238014 2238014 defendant Couton William de   612801 612801 Couton, William de, of Scotton 4
4628571 2239860 2239860 defendant Herryson John   612801 612801 Herryson, John, of Scotton 2
4640131 2243230 2243230 defendant Flask William   612801 612801 Flask, William, of Scotton 2
4641327 2243557 2243557 plaintiff Floyter Henry   612801 612801 Floyter, Henry, of Scotton 0
4645454 2244738 2244738 defendant Grethevede Robert   612801 612801 Grethevede, Robert, of Scotton 3
4651151 2246364 2246364 defendant Percy Robert esq 612801 612801 Percy, Robert, of Scotton, esq 0
4662366 2249706 2249706 defendant Percy Robert gent 612801 612801 Percy, Robert, of Scotton, gent 1
4676170 2258160 2258160 defendant Percy Robert gent 612801 612801 Percy, Robert, of Scotton, gent 1
4722646 2272398 2272398 defendant Stevenson Alexander husbandman 612801 612801 Stevenson, Alexander, of Scotton, husbandman 2
4734465 2275946 2275946 defendant Hampwyk John husbandman 612801 612801 Hampwyk, John, of Scotton, husbandman 1
4739541 2277447 2277447 defendant Helmesley John husbandman 612801 612801 Helmesley, John, of Scotton, husbandman 0
4744247 2278843 2278843 defendant Colson John   612801 612801 Colson, John, of Scotton, parson 1
4747967 2279913 2279913 defendant Amwyk John roper 612801 612801 Amwyk, John, of Scotton, roper 0
4788067 2292336 2292336 defendant Percy Robert esq 612801 612801 Percy, Robert, of Scotton, esq 0
4796528 2295070 2295070 defendant Alnewyke John laborer 612801 612801 Alnewyke, John, of Scotton, laborer 0
4855777 2313181 2313181 defendant Percy Robert esq 612801 612801 Percy, Robert, of Scotton, esq 0
4869174 2317337 2317337 defendant Scotte William husbandman 612801 612801 Scotte, William, of Scotton, husbandman 2
4872173 2318257 2318257 defendant Sclater John slater 612801 612801 Sclater, John, of Scotton, slater 0
4884324 2322003 2322003 defendant Flaske William (legal representative) 612801 612801 Flaske, William, of Scotton, executors of 0
4903199 2327609 2327609 plaintiff Gretheved Thomas   612801 612801 Gretheved, Thomas, of Scotton 0
4983639 2352030 2352030 defendant Crust John husbandman 612801 612801 Crust, John, of Scotton, husbandman 0
5012548 2360512 2360512 defendant Pullan Ralph gent 612801 612801 Pullan, Ralph, of Scotton, gent 0
5033856 2366780 2366780 defendant Pullan Ralph gent 612801 612801 Pullan, Ralph, of Scotton, gent 2
5052127 2372250 2372250 defendant Pullan Ralph gent 612801 612801 Pullan, Ralph, of Scotton, gent 1
5052141 2372253 2372253 defendant Pullan Ralph gent 612801 612801 Pullan, Ralph, of Scotton, gent 4
5058316 2374033 2374033 defendant Cartwryght Thomas husbandman 612801 612801 Cartwryght, Thomas, of Scotton, husbandman 1
5058317 2374033 2374033 defendant Geferayson Richard husbandman 612801 612801 Geferayson, Richard, of Scotton, husbandman 2
5058318 2374033 2374033 defendant Wase John husbandman 612801 612801 Wase, John, of Scotton, husbandman 3
5376321 2468190 2468190 defendant Bekerdyke Ralph yeoman 612801 612801 Bekerdyke, Ralph, of Scotton, yeoman 0
5382607 2470083 2470083 defendant Bekerdyke Ralph yeoman 612801 612801 Bekerdyke, Ralph, of Scotton, yeoman 0
5585532 2530543 2530543 defendant Spaldyng Robert pardoner 612801 612801 Spaldyng, Robert, of Scotton, pardoner 0
5605278 2536529 2536529 defendant Wilkys William husbandman 612801 612801 Wilkys, William, of Scotton, husbandman 0
5605279 2536529 2536529 defendant Hill Robert husbandman 612801 612801 Hill, Robert, of Scotton, husbandman 1
5605280 2536529 2536529 defendant Stokesley William tinker 612801 612801 Stokesley, William, of Scotton, tinker 2
5611708 2547397 2547397 defendant Warde Thomas   612801 612801 Warde, Thomas, of Scotton 0
5619906 2550086 2550086 plaintiff Abraham William   612801 612801 Abraham, William, of Scotton 3
5633269 2554408 2554408 defendant Percy Robert gent 612801 612801 Percy, Robert, of Scotton, gent 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);