names

85 rows where place_id = 587076

✎ 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
3590391 1864636 1864636 defendant Dicson William brewer 587076 587076 Dicson, William, of Plumsted, brewer 0
3599864 1867608 1867608 defendant Key Thomas laborer 587076 587076 Key, Thomas, of Plumsted, laborer 1
3637278 1906461 1906461 defendant Garrard William husbandman 587076 587076 Garrard, William, of Plumsted, husbandman 3
3642995 1908257 1908257 defendant Cosworth William husbandman 587076 587076 Cosworth, William, of Plumsted, husbandman 4
3659371 1913191 1913191 defendant Hawkesworth John husbandman 587076 587076 Hawkesworth, John, of Plumsted, husbandman 0
3659373 1913191 1913191 defendant Forest Richard yeoman 587076 587076 Forest, Richard, of Plumsted, yeoman 2
3659374 1913191 1913191 defendant Forest Richard, junior   587076 587076 Forest, Richard, junior, of Plumsted 3
3659375 1913191 1913191 defendant Marten Richard husbandman 587076 587076 Marten, Richard, of Plumsted, husbandman 4
3660254 1913469 1913469 defendant Cukkrowe John husbandman 587076 587076 Cukkrowe, John, of Plumsted, husbandman 3
3660260 1913470 1913470 defendant Cukkrowe John husbandman 587076 587076 Cukkrowe, John, of Plumsted, husbandman 3
3664558 1914869 1914869 defendant Grevis or Grebis Thomas yeoman 587076 587076 Grevis or Grebis, Thomas, of Plumsted, yeoman 0
3665001 1914999 1914999 defendant Gerrard William husbandman 587076 587076 Gerrard, William, of Plumsted, husbandman 1
3669051 1916251 1916251 defendant Hobart Miles gent 587076 587076 Hobart, Miles, of Plumsted, esq, Dade, Richard, of Witton, gent 0
3669725 1916475 1916475 defendant Forest Richard yeoman 587076 587076 Forest, Richard, of Plumsted, yeoman 0
3674388 1918035 1918035 defendant Portyngton George laborer 587076 587076 Portyngton, George, of Plumsted, laborer 2
3675120 1918247 1918247 defendant Forest Richard husbandman 587076 587076 Forest, Richard, of Plumsted, husbandman 3
3730185 1935666 1935666 defendant Forest Richard yeoman 587076 587076 Forest, Richard, of Plumsted, yeoman 2
3754580 1943390 1943390 defendant Reif Robert yeoman 587076 587076 Reif, Robert, of Plumsted, yeoman 4
3771454 1948764 1948764 defendant Bakon John husbandman 587076 587076 Bakon, John, of Plumsted, husbandman 0
3773109 1949292 1949292 defendant Bakon John husbandman 587076 587076 Bakon, John, of Plumsted, husbandman 0
3773110 1949292 1949292 defendant Bakon James husbandman 587076 587076 Bakon, James, of Plumsted, husbandman 1
3815115 1962647 1962647 defendant Downyng Thomas husbandman 587076 587076 Downyng, Thomas, of Plumsted, husbandman 0
3820817 1964402 1964402 defendant Bakon John husbandman 587076 587076 Bakon, John, of Plumsted, husbandman 0
3874233 1981603 1981603 defendant Bakon John yeoman 587076 587076 Bakon, John, of Plumsted, yeoman 0
3882249 1984321 1984321 defendant Skolehouse Richard thatcher 587076 587076 Skolehouse, Richard, of Plumsted, thatcher 0
3916330 1995845 1995845 defendant Dwerehowse Richard gent 587076 587076 Dwerehowse, Richard, of Plumsted, gent 0
3930185 2000441 2000441 defendant Wymbushe William husbandman 587076 587076 Wymbushe, William, of Plumsted, husbandman 1
3934127 2001708 2001708 plaintiff Hawborne John   587076 587076 Hawborne, John, of Plumsted, ship wright 0
3959147 2010284 2010284 defendant Plumsted John gent 587076 587076 Plumsted, John, of Plumsted, gent 5
3965935 2012704 2012704 defendant Chapman Lawrence husbandman 587076 587076 Chapman, Lawrence, of Plumsted, husbandman 1
3988564 2020655 2020655 defendant Paye Edmund   587076 587076 Paye, Edmund, of Plumsted, yeoman, administrators of 2
4005725 2026823 2026823 defendant Barnes Roger yeoman 587076 587076 Barnes, Roger, of Plumsted, yeoman 0
4005727 2026823 2026823 defendant Marmyng Edward husbandman 587076 587076 Marmyng, Edward, of Plumsted, husbandman 2
4021055 2032253 2032253 defendant Clement John yeoman 587076 587076 Clement, John, of Plumsted, yeoman 0
4068650 2049075 2049075 defendant Belton John husbandman 587076 587076 Belton, John, of Plumsted, husbandman 3
4109805 2063764 2063764 defendant Browne John laborer 587076 587076 Browne, John, of Plumsted, laborer 2
4142465 2075536 2075536 defendant Plumsted Thomas gent 587076 587076 Plumsted, Thomas, of Plumsted, gent 0
4253334 2114106 2114106 defendant Lyghtwyn John carpenter 587076 587076 Lyghtwyn, John, of Plumsted, carpenter 2
4349609 2147125 2147125 defendant Buttyvaunte John farrier 587076 587076 Buttyvaunte, John, of Plumsted, farrier 0
4387663 2160510 2160510 defendant Buttyvauntt William yeoman 587076 587076 Buttyvauntt, William, of Plumsted, yeoman 2
4743722 2278694 2278694 defendant Graundysden John yeoman 587076 587076 Graundysden, John, of Plumsted, yeoman 0
4757653 2282769 2282769 defendant Aleyn Adam yeoman 587076 587076 Aleyn, Adam, of Plumsted, yeoman 2
4821548 2302822 2302822 defendant Grantesden John yeoman 587076 587076 Grantesden, John, of Plumsted, yeoman 0
4916700 2331727 2331727 defendant Gryggys John   587076 587076 Gryggys, John, of Plumsted 10
4930878 2336058 2336058 defendant Stoberd John husbandman 587076 587076 Stoberd, John, of Plumsted, husbandman 0
4969298 2347777 2347777 defendant Tedford John laborer 587076 587076 Tedford, John, of Plumsted, laborer 1
4998690 2356493 2356493 defendant Howelot John husbandman 587076 587076 Howelot, John, of Plumsted, husbandman 0
4999470 2356714 2356714 defendant Aynesworth Brian gent 587076 587076 Aynesworth, Brian, of Plumsted, gent 0
5015766 2361496 2361496 defendant Rayner Thomas husbandman 587076 587076 Rayner, Thomas, of Plumsted, husbandman 3
5021136 2363078 2363078 defendant Kyng Roger husbandman 587076 587076 Kyng, Roger, of Plumsted, husbandman 0
5039612 2368495 2368495 defendant (illegible) John husbandman 587076 587076 --, John, of Plumsted, husbandman 0
5039614 2368495 2368495 defendant Robert William husbandman 587076 587076 Robert, William, of Plumsted, husbandman 2
5094353 2384754 2384754 defendant Howelet John husbandman 587076 587076 Howelet, John, of Plumsted, husbandman 0
5094358 2384755 2384755 defendant Howelot John husbandman 587076 587076 Howelot, John, of Plumsted, husbandman 0
5125874 2394055 2394055 plaintiff Benet Nicholas clerk 587076 587076 Benet, Nicholas, of Plumsted, clerk 0
5130395 2395379 2395379 defendant Howelet John husbandman 587076 587076 Howelet, John, of Plumsted, husbandman 0
5149768 2401068 2401068 defendant Howelet John husbandman 587076 587076 Howelet, John, of Plumsted, husbandman 0
5279389 2439056 2439056 defendant Plumsted Geoffrey clerk 587076 587076 Plumsted, Geoffrey, of Plumsted, clerk 6
5358610 2462755 2462755 defendant Morgan Richard yeoman 587076 587076 Morgan, Richard, of Plumsted, yeoman 0
5358612 2462755 2462755 defendant Tailour Thomas tailor 587076 587076 Tailour, Thomas, of Plumsted, tailor 2
5358614 2462756 2462756 defendant Morgan Richard yeoman 587076 587076 Morgan, Richard, of Plumsted, yeoman 0
5358616 2462756 2462756 defendant Tailour Thomas tailor 587076 587076 Tailour, Thomas, of Plumsted, tailor 2
5358618 2462757 2462757 defendant Morgan Richard yeoman 587076 587076 Morgan, Richard, of Plumsted, yeoman 0
5358620 2462757 2462757 defendant Tayllour Thomas tailor 587076 587076 Tayllour, Thomas, of Plumsted, tailor 2
5358622 2462758 2462758 defendant Morgan Richard yeoman 587076 587076 Morgan, Richard, of Plumsted, yeoman 0
5358624 2462758 2462758 defendant Tayllour Thomas tailor 587076 587076 Tayllour, Thomas, of Plumsted, tailor 2
5358626 2462759 2462759 defendant Morgan (illegible) yeoman 587076 587076 Morgan, -, of Plumsted, yeoman 0
5358628 2462759 2462759 defendant Tayllour Thomas tailor 587076 587076 Tayllour, Thomas, of Plumsted, tailor 2
5362969 2464062 2464062 defendant Crabbe Robert husbandman 587076 587076 Crabbe, Robert, of Plumsted, husbandman 4
5364356 2464512 2464512 defendant Caton John yeoman 587076 587076 Caton, John, of Plumsted, yeoman 1
5383662 2470411 2470411 defendant Cok Thomas yeoman 587076 587076 Cok, Thomas, of Plumsted, yeoman 0
5383663 2470411 2470411 defendant Robynson Gilbert laborer 587076 587076 Robynson, Gilbert, of Plumsted, laborer 1
5383664 2470411 2470411 defendant Tolpe Thomas laborer 587076 587076 Tolpe, Thomas, of Plumsted, laborer 2
5383665 2470411 2470411 defendant Grene Thomas laborer 587076 587076 Grene, Thomas, of Plumsted, laborer 3
5383666 2470411 2470411 defendant Chylde William laborer 587076 587076 Chylde, William, of Plumsted, laborer 4
5389156 2471950 2471950 defendant Clytherewe Ralph husbandman 587076 587076 Clytherewe, Ralph, of Plumsted, husbandman 2
5415636 2479619 2479619 defendant Spay_ William husbandman 587076 587076 Spay_, William, of Plumsted, husbandman 0
5435194 2485454 2485454 defendant Court John laborer 587076 587076 Court, John, of Plumsted, laborer 0
5450279 2489966 2489966 defendant Court John laborer 587076 587076 Court, John, of Plumsted, laborer 0
5513639 2509114 2509114 defendant Carter Thomas husbandman 587076 587076 Carter, Thomas, of Plumsted, husbandman 1
5513640 2509114 2509114 defendant Chyske John husbandman 587076 587076 Chyske, John, of Plumsted, husbandman 2
5518654 2510666 2510666 defendant Crabbe Robert husbandman 587076 587076 Crabbe, Robert, of Plumsted, husbandman 0
5579165 2528559 2528559 defendant Clerk William clerk 587076 587076 Clerk, William, of Plumsted, clerk 2
5587792 2531200 2531200 defendant Grey John husbandman 587076 587076 Grey, John, of Plumsted, husbandman 3
5596584 2533850 2533850 defendant Dunmowe Robert husbandman 587076 587076 Dunmowe, Robert, of Plumsted, husbandman 1

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