names

31 rows where place_id = 699664

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4129900 2071005 2071005 defendant Forde Richard gent 699664 699664 Forde, Richard, of Axminster, Devon, gent 0
4140010 2074672 2074672 defendant Bewer John plumber 699664 699664 Bewer, John, of Axminster, Devon, plumber 0
4140015 2074674 2074674 defendant Brewer George plumber 699664 699664 Brewer, George, of Axminster, Devon, plumber 0
4147787 2077365 2077365 defendant Wylshere Richard yeoman 699664 699664 Wylshere, Richard, of Axminster, Devon, yeoman 0
4196281 2094243 2094243 defendant Parrys John   699664 699664 Parrys, John, of Axminster, Devon, hat maker 2
4208310 2098453 2098453 defendant Stephens Gregory yeoman 699664 699664 Stephens, Gregory, of Axminster, Devon, yeoman 0
4212338 2099862 2099862 defendant Larstocke Charles gent 699664 699664 Larstocke, Charles, of Axminster, Devon, gent 0
4216155 2101141 2101141 defendant Bragg Robert husbandman 699664 699664 Bragg, Robert, of Axminster, Devon, husbandman 0
4285497 2124862 2124862 defendant Huyshe Anthony gent 699664 699664 Huyshe, Anthony, of Axminster, Devon, gent 0
4303649 2131401 2131401 defendant Everett Richard husbandman 699664 699664 (Everett, Richard, of Axminster, Devon, husbandman 2
4307739 2132846 2132846 defendant Harres alias Tucker Richard merchant 699664 699664 Harres alias Tucker, Richard, of Axminster, Devon, merchant 0
4324541 2138598 2138598 defendant Bowden Christopher yeoman 699664 699664 Bowden, Christopher, of Axminster, Devon, yeoman 2
4379778 2157862 2157862 defendant Herryn Guy weaver 699664 699664 Herryn, Guy, of Axminster, Devon, weaver 0
4397423 2163717 2163717 defendant Harte William clothier 699664 699664 Harte, William, of Axminster, Devon, clothier 0
4397425 2163718 2163718 defendant Harte William clothier 699664 699664 Harte, William, of Axminster, Devon, clothier 0
4398883 2164209 2164209 defendant Bragge Thomas chapman 699664 699664 Bragge, Thomas, of Axminster, Devon, chapman 1
4697766 2264796 2264796 defendant Geraunt Adam husbandman 699664 699664 Geraunt, Adam, of Axminster, Devon, husbandman 1
4698183 2264917 2264917 defendant Smert John husbandman 699664 699664 Smert, John, of Axminster, Devon, husbandman 3
4712569 2269249 2269249 defendant Fleccher Thomas husbandman 699664 699664 Fleccher, Thomas, of Axminster, Devon, husbandman 1
4734069 2275840 2275840 defendant Keche William ostler 699664 699664 Keche, William, of Axminster, Devon, ostler 0
4734073 2275841 2275841 defendant Kethe William ostler 699664 699664 Kethe, William, of Axminster, Devon, ostler 0
4735675 2276305 2276305 defendant Shephirde William husbandman 699664 699664 Shephirde, William, of Axminster, Devon, husbandman 1
4771171 2286966 2286966 defendant Keche William husbandman 699664 699664 Keche, William, of Axminster, Devon, husbandman 0
4806140 2298129 2298129 defendant Stiflegh John husbandman 699664 699664 Stiflegh, John, of Axminster, Devon, husbandman 0
4840155 2308472 2308472 defendant Forde John   699664 699664 Forde, John, of Axminster, Devon, groom 1
4840373 2308533 2308533 defendant More Philip husbandman 699664 699664 More, Philip, of Axminster, Devon, husbandman 0
5182266 2410567 2410567 defendant Holeway John smith 699664 699664 Holeway, John, of Axminster, Devon, smith 0
5203321 2416733 2416733 defendant Holeway John smith 699664 699664 Holeway, John, of Axminster, Devon, smith 0
5203323 2416734 2416734 defendant Holeway John smith 699664 699664 Holeway, John, of Axminster, Devon, smith 0
5408970 2477645 2477645 defendant Muttelbury John yeoman 699664 699664 Muttelbury, John, of Axminster, Devon, yeoman 1
5435604 2485588 2485588 defendant Cok Richard chapman 699664 699664 Cok, Richard, of Axminster, Devon, chapman 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);