names

56 rows where place_id = 587644

✎ 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
3592030 1865121 1865121 defendant Davy Thomas husbandman 587644 587644 Davy, Thomas, of Whitechurche, husbandman 0
3599900 1867622 1867622 defendant Synyer William merchant 587644 587644 Synyer, William, of Whitechurche, merchant 0
3636449 1906190 1906190 defendant Mayhoo William butcher 587644 587644 Mayhoo, William, of Whitechurche, butcher 0
3653919 1911491 1911491 defendant Power Robert gent 587644 587644 Power, Robert, of Whitechurche, gent 0
3758096 1944517 1944517 defendant Bromley Alice widow 587644 587644 Bromley, Alice, of Whitechurche, widow 0
3766646 1947230 1947230 defendant Gybson John laborer 587644 587644 Gybson, John, of Whitechurche, laborer 0
3766647 1947230 1947230 defendant Wedon Joan widow 587644 587644 Wedon, Joan, of Whitechurche, widow 1
3766648 1947230 1947230 defendant Sutton Thomas husbandman 587644 587644 Sutton, Thomas, of Whitechurche, husbandman 2
3810624 1961220 1961220 defendant Godard Andrew baker 587644 587644 Godard, Andrew, of Whitechurche, baker 1
3862612 1977689 1977689 defendant Wylson John yeoman 587644 587644 Wylson, John, of Whitechurche, yeoman 0
3881073 1983941 1983941 defendant Langisford Walter yeoman 587644 587644 Langisford, Walter, of Whitechurche, yeoman 0
3891503 1987424 1987424 defendant Wylson John yeoman 587644 587644 Wylson, John, of Whitechurche, yeoman 0
3891504 1987424 1987424 defendant Taket John yeoman 587644 587644 Taket, John, of Whitechurche, yeoman 1
3898517 1989717 1989717 defendant Godyng William yeoman 587644 587644 Godyng, William, of Whitechurche, yeoman 1
3901434 1990702 1990702 defendant Wylson John yeoman 587644 587644 Wylson, John, of Whitechurche, yeoman 0
3905511 1992112 1992112 defendant Kender John   587644 587644 Kender, John, of Whitechurche, mason 2
4281526 2123442 2123442 defendant Mollens George husbandman 587644 587644 Mollens, George, of Whitechurche, husbandman 0
4333411 2141457 2141457 defendant Gare John husbandman 587644 587644 Gare, John, of Whitechurche, husbandman 0
4375036 2156132 2156132 defendant Mollyns John yeoman 587644 587644 Mollyns, John, of Whitechurche, yeoman 0
4400722 2164830 2164830 defendant Chapman William   587644 587644 Chapman, William, of Whitechurche, shepherd 0
4400723 2164830 2164830 defendant Poliden John yeoman 587644 587644 together with Poliden, John, of Whitechurche, yeoman 1
4400724 2164830 2164830 defendant Stone Robert   587644 587644 Stone, Robert, of Whitechurche, shepherd 2
4418892 2170776 2170776 defendant Gant Robert   587644 587644 Gant, Robert, of Whitechurche 1
4418893 2170776 2170776 defendant Gant Thomas   587644 587644 Gant, Thomas, of Whitechurche 2
4484163 2195746 2195746 defendant Stonore Hugh   587644 587644 Stonore, Hugh, of Whitechurche, parson 0
4618364 2236755 2236755 defendant Iweyn William   587644 587644 Iweyn, William, of Whitechurche 0
4664808 2250467 2250467 defendant Basset John husbandman 587644 587644 Basset, John, of Whitechurche, husbandman 0
4671154 2256641 2256641 defendant Richard Robert husbandman 587644 587644 Richard, Robert, of Whitechurche, husbandman 3
4725021 2273120 2273120 defendant Serle William   587644 587644 Serle, William, of Whitechurche, franklin 0
4787833 2292259 2292259 defendant Colyn Robert yeoman 587644 587644 Colyn, Robert, of Whitechurche, yeoman 0
4879907 2320629 2320629 defendant Tybenham Alice   587644 587644 Tybenham, Alice, of Whitechurche, widow of Tybenham, William 0
4963010 2345846 2345846 defendant Stenteford Richard   587644 587644 Stenteford, Richard, of Whitechurche, bailiff 9
4977647 2350280 2350280 defendant Power Robert yeoman 587644 587644 Power, Robert, of Whitechurche, yeoman 0
5031157 2365990 2365990 defendant Power Robert yeoman 587644 587644 Power, Robert, of Whitechurche, yeoman 0
5031485 2366068 2366068 defendant Felton Nicholas clerk 587644 587644 Felton, Nicholas, of Whitechurche, clerk 0
5092229 2384108 2384108 defendant Milis John husbandman 587644 587644 Milis, John, of Whitechurche, husbandman 0
5197703 2415071 2415071 defendant Courteys John butcher 587644 587644 Courteys, John, of Whitechurche, butcher 0
5248456 2429676 2429676 defendant Crouchefeld John husbandman 587644 587644 Crouchefeld, John, of Whitechurche, husbandman 0
5248457 2429676 2429676 defendant Lytylfylde John tanner 587644 587644 Lytylfylde, John, of Whitechurche, tanner 1
5248458 2429676 2429676 defendant Slye Thomas husbandman 587644 587644 Slye, Thomas, of Whitechurche, husbandman 2
5248459 2429676 2429676 defendant Harryes John, senior cooper 587644 587644 Harryes, John, senior, of Whitechurche, cooper 3
5248460 2429676 2429676 defendant Harryes John, junior cooper 587644 587644 Harryes, John, junior, of Whitechurche, cooper 4
5262301 2433960 2433960 defendant Kegyll Richard butcer 587644 587644 Kegyll, Richard, of Whitechurche, butcer 0
5285890 2440888 2440888 defendant Codlip Roger husbandman 587644 587644 Codlip, Roger, of Whitechurche, husbandman 7
5294722 2443437 2443437 defendant Scathelok Stephem fuller 587644 587644 Scathelok, Stephem, of Whitechurche, fuller 0
5294726 2443438 2443438 defendant Scathelok Stephen fuller 587644 587644 Scathelok, Stephen, of Whitechurche, fuller 0
5302961 2445875 2445875 defendant Seward John yeoman 587644 587644 Seward, John, of Whitechurche, yeoman 3
5339800 2457022 2457022 defendant Bravan John husbandman 587644 587644 Bravan, John, of Whitechurche, husbandman 0
5357264 2462336 2462336 defendant Bartelot John yeoman 587644 587644 Bartelot, John, of Whitechurche, yeoman 0
5361906 2463749 2463749 plaintiff Syvyer William yeoman or farmer 587644 587644 Syvyer, William, of Whitechurche, yeoman or farmer 0
5389484 2472044 2472044 plaintiff Jele Richard   587644 587644 Jele, Richard, of Whitechurche 0
5463332 2493942 2493942 defendant Sebier William merchant 587644 587644 Sebier, William, of Whitechurche, merchant 0
5482655 2499757 2499757 defendant Soper Richard husbandman 587644 587644 Soper, Richard, of Whitechurche, husbandman 0
5503840 2506117 2506117 defendant Mede Richard husbandman 587644 587644 Mede, Richard, of Whitechurche, husbandman 0
5575904 2527543 2527543 defendant Sargant Thomas husbandman 587644 587644 Sargant, Thomas, of Whitechurche, husbandman 0
5575905 2527543 2527543 defendant Stenteford Thomas husbandman 587644 587644 Stenteford, Thomas, of Whitechurche, 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);