names

53 rows where place_id = 586531

✎ 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
3588966 1864198 1864198 defendant Rumpe John husbandman 586531 586531 Rumpe, John, of Est Somerton, husbandman 0
3641866 1907906 1907906 defendant Roper Henry husbandman 586531 586531 Roper, Henry, of Est Somerton, husbandman 1
3691213 1923413 1923413 defendant Botolphe John (legal representative) 586531 586531 Botolphe, John, of Est Somerton, yeoman, executrix of 0
3775683 1950143 1950143 defendant Sewall Robert husbandman 586531 586531 Sewall, Robert, of Est Somerton, husbandman 1
3775685 1950143 1950143 defendant Manere John husbandman 586531 586531 Manere, John, of Est Somerton, husbandman 3
3843942 1971644 1971644 defendant Robynson alias Roper Robert yeoman 586531 586531 Robynson alias Roper, Robert, of Est Somerton, yeoman 0
3875340 1981997 1981997 defendant Robynson Robert yeoman 586531 586531 Robynson, Robert, of Est Somerton, yeoman 0
3914819 1995303 1995303 defendant Butt William butcher 586531 586531 Butt, William, of Est Somerton, butcher 0
4027595 2034517 2034517 defendant Deddam John yeoman 586531 586531 Deddam, John, of Est Somerton, yeoman 0
4047687 2041619 2041619 defendant Pery Edward yeoman 586531 586531 Pery, Edward, of Est Somerton, yeoman 0
4048003 2041729 2041729 defendant Debdam John yeoman 586531 586531 Debdam, John, of East Somerton, yeoman 0
4113892 2065252 2065252 defendant Depden John gent 586531 586531 Depden, John, of Est Somerton, gent 1
4117746 2066640 2066640 defendant Cobbe Edmund gent 586531 586531 Cobbe, Edmund, of Est Somerton, gent 0
4191129 2092462 2092462 defendant Wyll Henry husbandman 586531 586531 Wyll, Henry, of Est Somerton, husbandman 1
4213882 2100376 2100376 defendant Covell Cuppledicus gent 586531 586531 Covell, Cuppledicus, of Est Somerton, gent 0
4242673 2110539 2110539 defendant Covell Cuppledike gent 586531 586531 Covell, Cuppledike, of Est Somerton, gent 3
4261468 2116799 2116799 defendant Clypwell Thomas gent 586531 586531 Clypwell, Thomas, of East Somerton, gent 0
4320238 2137179 2137179 defendant Flower John laborer 586531 586531 Flower, John, of East Somerton, laborer 1
4323752 2138358 2138358 defendant Pyle William husbandman 586531 586531 Pyle, William, of Est Somerton, husbandman 0
4343503 2145005 2145005 defendant Covell Copledike gent 586531 586531 Covell, Copledike, of East Somerton, gent 0
4419738 2171071 2171071 defendant Aleyn John   586531 586531 Aleyn, John, of East Somerton 0
4609819 2234163 2234163 defendant Red Robert   586531 586531 Red, Robert, of East Somerton 0
4657478 2248232 2248232 defendant Empoll Robert   586531 586531 Empoll, Robert, of Est Somerton 0
4657479 2248232 2248232 defendant Empoll Thomas   586531 586531 Empoll, Thomas, of Est Somerton 1
4738897 2277255 2277255 defendant Jullesson Geoffrey husbandman 586531 586531 Jullesson, Geoffrey, of East Somerton, husbandman 4
4744682 2278964 2278964 defendant Leveton John pedder 586531 586531 Leveton, John, of East Somerton, pedder 1
4745473 2279186 2279186 defendant Repere Adam yeoman 586531 586531 Repere, Adam, of East Somerton, yeoman 0
4749258 2280265 2280265 defendant Benet William husbandman 586531 586531 Benet, William, of East Somerton, husbandman 1
4938673 2338482 2338482 defendant Heylot Walter yeoman 586531 586531 Heylot, Walter, of Est Somerton, yeoman 0
4938683 2338482 2338482 defendant Clerk Alexander husbandman 586531 586531 Clerk, Alexander, of Est Somerton, husbandman 10
4948147 2341395 2341395 defendant Osbern Thomas laborer 586531 586531 Osbern, Thomas, of Est Somerton, laborer 2
5004592 2358244 2358244 defendant Heerson Richard husbandman 586531 586531 Heerson, Richard, of East Somerton, husbandman 1
5004593 2358244 2358244 defendant Ropere Thomas   586531 586531 Ropere, Thomas, of East Somerton, skep maker 2
5038176 2368051 2368051 defendant Mundford John husbandman 586531 586531 Mundford, John, of Est Somerton, husbandman 5
5049869 2371587 2371587 plaintiff Stotevyle John   586531 586531 Stotevyle, John, of East Somerton 0
5057073 2373694 2373694 defendant Galys Edmund miller 586531 586531 Galys, Edmund, of Est Somerton, miller 0
5060524 2374727 2374727 defendant Galys Edmund husbandman 586531 586531 Galys, Edmund, of Est Somerton, husbandman 1
5100839 2386660 2386660 defendant Skepper John husbandman 586531 586531 Skepper, John, of Est Somerton, husbandman 0
5116059 2391125 2391125 defendant Beffeys or Besseys Nicholas yeoman 586531 586531 Beffeys or Besseys, Nicholas, of Est Somerton, yeoman 1
5119629 2392174 2392174 defendant Skepper John husbandman 586531 586531 Skepper, John, of Est Somerton, husbandman 0
5144567 2399571 2399571 plaintiff Stotevile John   586531 586531 Stotevile, John, of East Somerton 1
5165352 2405613 2405613 plaintiff Stotevile John   586531 586531 Stotevile, John, of East Somerton 1
5179295 2409682 2409682 plaintiff Stotevile John   586531 586531 Stotevile, John, of East Somerton 1
5223786 2422642 2422642 defendant Beaufitz Nicholas husbandman 586531 586531 Beaufitz, Nicholas, of Est Somerton, husbandman 0
5265296 2434905 2434905 defendant Roper alias Skepper John laborer 586531 586531 Roper alias Skepper, John, of Est Somerton, laborer 2
5290930 2442351 2442351 defendant Bewefitz Nicholas husbandman 586531 586531 Bewefitz, Nicholas, of Est Somerton, husbandman 2
5365293 2464819 2464819 defendant Clerke Roger husbandman 586531 586531 Clerke, Roger, of East Somerton, husbandman 2
5384022 2470515 2470515 defendant Kyng Peter husbandman 586531 586531 Kyng, Peter, of East Somerton, husbandman 3
5506982 2507098 2507098 defendant Stotevyle John gent 586531 586531 Stotevyle, John, of Est Somerton, gent 0
5511404 2508412 2508412 defendant Stotevyle John gent 586531 586531 Stotevyle, John, of Est Somerton, gent 0
5531537 2514396 2514396 plaintiff Sontevyle John (legal representative) 586531 586531 Sontevyle, John, of Est Somerton, executors of 0
5543419 2518060 2518060 defendant Colvyle Robert gent 586531 586531 Colvyle, Robert, of Est Somerton, gent 1
5549922 2520013 2520013 defendant Percy Thomas husbandman 586531 586531 Percy, Thomas, of Est Somerton, 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);