names

46 rows where place_id = 637629

✎ 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
3837581 1969662 1969662 defendant Cryke Henry baker 637629 637629 Cryke, Henry, of Crukerne, baker 0
3853608 1974757 1974757 defendant Cryke Henry baker 637629 637629 Cryke, Henry, of Crukerne, baker 0
3952835 2008066 2008066 defendant Prynce Thomas gent 637629 637629 Prynce, Thomas, of Crukerne, gent 0
3980098 2017643 2017643 defendant Hooper alias Cooke John mercer 637629 637629 Hooper alias Cooke, John, of Crukerne, mercer 1
3980100 2017644 2017644 defendant Baker George husbandman 637629 637629 Baker, George, of Crukerne, husbandman 0
3980115 2017650 2017650 defendant Glover alias Leche William husbandman 637629 637629 Glover alias Leche, William, of Crukerne, husbandman 0
3980117 2017651 2017651 defendant Glover William husbandman 637629 637629 Glover, William, of Crukerne, husbandman 0
4044619 2040527 2040527 defendant Barker Robert yeoman 637629 637629 Barker, Robert, of Crukerne, yeoman 1
4044627 2040528 2040528 defendant Baker Robert yeoman 637629 637629 Baker, Robert, of Crukerne, yeoman 1
4044628 2040528 2040528 defendant Baker George yeoman 637629 637629 Baker, George, of Crukerne, yeoman 2
4479594 2194281 2194281 defendant Bakere Thomas   637629 637629 Bakere, Thomas, of Crukerne 0
4512433 2204330 2204330 defendant Boucher Geoffrey   637629 637629 Boucher, Geoffrey, of Crukerne 4
4515166 2205159 2205159 defendant Bakere Thomas   637629 637629 Bakere, Thomas, of Crukerne 0
4532566 2210451 2210451 defendant Spore John   637629 637629 Spore, John, of Crukerne 1
4548361 2215428 2215428 defendant Bakere Thomas   637629 637629 Bakere, Thomas, of Crukerne 0
4548362 2215428 2215428 defendant Souter William   637629 637629 Souter, William, of Crukerne 1
4553035 2216889 2216889 defendant Spore John merchant 637629 637629 Spore, John, of Crukerne, merchant 0
4553646 2217064 2217064 defendant Quyche John   637629 637629 Quyche, John, of Crukerne 0
4584588 2226597 2226597 defendant Brasietre John   637629 637629 Brasietre, John, of Crukerne 0
4584589 2226597 2226597 defendant Brasietre Richard   637629 637629 Brasietre, Richard, of Crukerne 1
4584593 2226597 2226597 defendant Wychard John   637629 637629 Wychard, John, of Crukerne 5
4597919 2230607 2230607 defendant Broune John taverner 637629 637629 Broune, John, of Crukerne, taverner 0
4598879 2230874 2230874 defendant Baker Thomas   637629 637629 Baker, Thomas, of Crukerne 0
4598881 2230874 2230874 defendant Benet Richard   637629 637629 Benet, Richard, of Crukerne 2
4656201 2247827 2247827 defendant Depe John chapman 637629 637629 Depe, John, of Crukerne, chapman 0
4670326 2256424 2256424 defendant Burnell roobert baker 637629 637629 Burnell, roobert, of Crukerne, baker 1
4670918 2256580 2256580 defendant Davy John laborer 637629 637629 Davy, John, of Crukerne, laborer 0
4676074 2258130 2258130 defendant Freman Richard laborer 637629 637629 Freman, Richard, of Crukerne, laborer 0
4676078 2258130 2258130 defendant James William laborer 637629 637629 James, William, of Crukerne, laborer 4
4688764 2262043 2262043 defendant Harnescombe John laborer 637629 637629 Harnescombe,John, of Crukerne, laborer 1
4723104 2272535 2272535 defendant St Clere Richard husbandman 637629 637629 together with St Clere, Richard, of Crukerne, husbandman 4
4748905 2280172 2280172 defendant Benet Richard ostler 637629 637629 Benet, Richard, of Crukerne, ostler 0
4748906 2280172 2280172 defendant Smert John husbandman 637629 637629 Smert, John, of Crukerne, husbandman 1
4758383 2282996 2282996 defendant Bole alias Colles Thomas husbandman 637629 637629 Bole alias Colles, Thomas, of Crukerne, husbandman 0
4769259 2286364 2286364 defendant Torte Hugh gent 637629 637629 Torte, Hugh, of Crukerne, gent 0
4780672 2289952 2289952 defendant Bele alias Colles Thomas husbandman 637629 637629 Bele alias Colles, Thomas, of Crukerne, husbandman 0
4786758 2291913 2291913 defendant Dygon William butcher 637629 637629 Dygon, William, of Crukerne, butcher 0
4804732 2297681 2297681 plaintiff Boucher Joan   637629 637629 Boucher, Joan, of Crukerne, formerly wife of Geoffrey Boucher 0
4900763 2326875 2326875 defendant Danne Roger tucker 637629 637629 Danne, Roger, of Crukerne, tucker 4
4916963 2331809 2331809 defendant Smert John eyer 637629 637629 Smert, John, of Crukerne, eyer 0
5032243 2366308 2366308 defendant Draper Robert husbandman 637629 637629 Draper, Robert, of Crukerne, husbandman 4
5313041 2448933 2448933 defendant Barbour Robert barber 637629 637629 Barbour, Robert, of Crukerne, barber 0
5313042 2448933 2448933 defendant Barbour Thomas capper 637629 637629 Barbour, Thomas, of Crukerne, capper 1
5318675 2450679 2450679 defendant Frye Agnes widow 637629 637629 (Frye, Agnes, of Crukerne, widow 1
5318676 2450679 2450679 defendant Frye John chaplain 637629 637629 Frye, John, of Crukerne, chaplain 2
5355127 2461672 2461672 defendant Whyte John draper 637629 637629 Whyte, John, of Crukerne, draper 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);