names

51 rows where place_id = 589295

✎ 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
3597132 1866727 1866727 defendant Tomcokke John tailor 589295 589295 Tomcokke, John, of Tregonyburgh, tailor 0
3610198 1870853 1870853 defendant Dekke Nicholas cordwainer 589295 589295 Dekke, Nicholas, of Tregonyburgh, cordwainer 0
3610823 1871052 1871052 defendant William John chaplain 589295 589295 William, John, of Tregonyburgh, chaplain 0
3613882 1871996 1871996 defendant Tanner Margaret widow 589295 589295 Tanner, Margaret, of Tregonyburgh, widow 1
3613883 1871996 1871996 defendant Trenythyk John gent 589295 589295 Trenythyk, John, of Tregonyburgh, gent 2
3622358 1874529 1874529 defendant Belle Martin laborer 589295 589295 Belle, Martin, of Tregonyburgh, laborer 0
3622359 1874529 1874529 defendant Davy Nicholas cordwainer 589295 589295 Davy, Nicholas, of Tregonyburgh, cordwainer 1
3638631 1906897 1906897 defendant Carwarran Richard cordwainer 589295 589295 Carwarran, Richard, of Tregonyburgh, cordwainer 1
3695026 1924655 1924655 defendant Olner John glover 589295 589295 Olner, John, of Tregonyburgh, glover 2
5068338 2377033 2377033 defendant Richard Henry tailor 589295 589295 Richard, Henry, of Tregonyburgh, tailor 0
5068524 2377078 2377078 defendant Penhesken John husbandman 589295 589295 Penhesken, John, of Tregonyburgh, husbandman 1
5074115 2378747 2378747 defendant Rondell William yeoman 589295 589295 Rondell, William, of Tregonyburgh, yeoman 0
5074116 2378747 2378747 defendant Dobrun John yeoman 589295 589295 Dobrun, John, of Tregonyburgh, yeoman 1
5074117 2378747 2378747 defendant Carathyn Baldwin yeoman 589295 589295 Carathyn, Baldwin, of Tregonyburgh, yeoman 2
5074118 2378747 2378747 defendant Carregeowe Thomas yeoman 589295 589295 Carregeowe, Thomas, of Tregonyburgh, yeoman 3
5074119 2378747 2378747 defendant Clay John yeoman 589295 589295 Clay, John, of Tregonyburgh, yeoman 4
5097907 2385819 2385819 defendant Tanner Richard tanner 589295 589295 Tanner, Richard, of Tregonyburgh, tanner 0
5212548 2419416 2419416 defendant Conlyn John chaplain 589295 589295 Conlyn, John, of Tregonyburgh, chaplain 5
5229829 2424344 2424344 defendant Trevaygnon John, senior gent 589295 589295 Trevaygnon, John, senior, of Tregonyburgh, gent 1
5229884 2424359 2424359 defendant Trevaygnon John gent 589295 589295 Trevaygnon, John, of Tregonyburgh, gent 6
5235814 2426054 2426054 defendant Danburn Walter souter 589295 589295 Danburn, Walter, of Tregonyburgh, souter 2
5235815 2426054 2426054 defendant Harry Peter yeoman 589295 589295 Harry, Peter, of Tregonyburgh, yeoman 3
5244346 2428528 2428528 defendant Tomma Peter chaplain 589295 589295 Tomma, Peter, of Tregonyburgh, chaplain 1
5244347 2428528 2428528 defendant Treveek Andrew saddler 589295 589295 Treveek, Andrew, of Tregonyburgh, saddler 2
5249321 2429922 2429922 defendant Cowelynge Pascas tanner 589295 589295 Cowelynge, Pascas, of Tregonyburgh, tanner 1
5249322 2429922 2429922 defendant Donbron John glover 589295 589295 Donbron, John, of Tregonyburgh, glover 2
5265921 2435094 2435094 defendant Gelard John pewterer 589295 589295 Gelard, John, of Tregonyburgh, pewterer 3
5265995 2435120 2435120 defendant Bruce John mercer 589295 589295 Bruce, John, of Tregonyburgh, mercer 2
5332919 2454911 2454911 defendant Trevanyon John gent 589295 589295 Trevanyon, John, of Tregonyburgh, gent 0
5344461 2458446 2458446 defendant Dier John carpenter 589295 589295 Dier, John, of Tregonyburgh, carpenter 2
5344462 2458446 2458446 defendant Tourner John turner 589295 589295 Tourner, John, of Tregonyburgh, turner 3
5393824 2473292 2473292 defendant Poyle Thomas merchant 589295 589295 Poyle, Thomas, of Tregonyburgh, merchant 0
5464749 2494370 2494370 defendant Wyllyam Peter husbandman 589295 589295 Wyllyam, Peter, of Tregonyburgh, husbandman 1
5464752 2494371 2494371 defendant Wyllyam Peter husbandman 589295 589295 Wyllyam, Peter, of Tregonyburgh, husbandman 1
5478347 2498552 2498552 defendant Masley William gent 589295 589295 Masley, William, of Tregonyburgh, gent 0
5487700 2501209 2501209 defendant Wyllyam Peter yeoman 589295 589295 together with Wyllyam , Peter, of Tregonyburgh, yeoman 1
5487703 2501210 2501210 defendant Wylliam Peter yeoman 589295 589295 Wylliam, Peter, of Tregonyburgh, yeoman 1
5490316 2501993 2501993 defendant Masseby or Massely William gent 589295 589295 Masseby or Massely, William, of Tregonyburgh, gent 0
5499475 2504787 2504787 plaintiff Poyle alias Robart John (legal representative) 589295 589295 Poyle alias Robart, John, of Tregonyburgh, merchant, executors of 0
5503599 2506039 2506039 plaintiff William Peter   589295 589295 William, Peter, of Tregonyburgh 0
5503602 2506040 2506040 plaintiff William Peter   589295 589295 William, Peter, of Tregonyburgh 0
5503604 2506041 2506041 plaintiff William Peter   589295 589295 William, Peter, of Tregonyburgh 0
5503606 2506042 2506042 plaintiff William Peter   589295 589295 William, Peter, of Tregonyburgh 0
5503611 2506043 2506043 plaintiff William Peter merchant 589295 589295 William, Peter, of Tregonyburgh, merchant 0
5517912 2510446 2510446 plaintiff William Peter   589295 589295 William, Peter, of Tregonyburgh 0
5529906 2513858 2513858 plaintiff Poyle John (legal representative) 589295 589295 Poyle, John, of Tregonyburgh, merchant, executors of 0
5529909 2513858 2513858 defendant William alias Bonnak Peter yeoman 589295 589295 William alias Bonnak, Peter, of Tregonyburgh, yeoman 0
5536514 2515904 2515904 defendant Peryn Ralph husbandman 589295 589295 Peryn, Ralph, of Tregonyburgh, husbandman 0
5571439 2526199 2526199 defendant Masley William gent 589295 589295 Masley, William, of Tregonyburgh, gent 4
5606629 2536955 2536955 defendant Quardrue Owen capper 589295 589295 Quardrue, Owen, of Tregonyburgh, capper 0
5606630 2536955 2536955 defendant Thomas Thomas laborer 589295 589295 Thomas, Thomas, of Tregonyburgh, laborer 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);