names

48 rows where place_id = 597114

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627343 1903402 1903402 defendant Dunrygge John merchant 597114 597114 Dunrygge, John, of Neuton Ferrers, merchant 2
4733593 2275683 2275683 defendant Hurdelles Henry husbandman 597114 597114 Hurdelles, Henry, of Neuton Ferrers, husbandman 0
4871066 2317924 2317924 defendant Crenbeare John butcher 597114 597114 Crenbeare, John, of Neuton Ferrers, butcher 1
4890173 2323696 2323696 defendant Pyldysshe William yeoman 597114 597114 Pyldysshe, William, of Neuton Ferrers, yeoman 3
4900936 2326921 2326921 defendant Colle Isabel widow 597114 597114 Colle, Isabel, of Neuton Ferrers, widow 2
4942280 2339579 2339579 defendant Damerell John butcher 597114 597114 Damerell, John, of Neuton Ferrers, butcher 1
4950605 2342152 2342152 defendant Sayer Henry tailor 597114 597114 Sayer, Henry, of Neuton Ferrers, tailor 0
4958490 2344509 2344509 defendant Rwite William yeoman 597114 597114 Rwite, William, of Neuton Ferrers, yeoman 0
4965190 2346516 2346516 defendant Strete William husbandman 597114 597114 Strete, William, of Neuton Ferrers, husbandman 0
4970909 2348243 2348243 defendant Wylky Ralph husbandman 597114 597114 Wylky, Ralph, of Neuton Ferrers, husbandman 0
4987301 2353150 2353150 defendant Worthy John laborer 597114 597114 Worthy, John, of Neuton Ferrers, laborer 5
5011463 2360217 2360217 defendant Pennarth Thomas gent 597114 597114 Pennarth, Thomas, of Neuton Ferrers, gent 0
5011464 2360217 2360217 defendant Strete Walter husbandman 597114 597114 Strete, Walter, of Neuton Ferrers, husbandman 1
5011465 2360217 2360217 defendant Moys Walter yeoman 597114 597114 Moys, Walter, of Neuton Ferrers, yeoman 2
5015274 2361348 2361348 defendant Pyldyche William husbandman 597114 597114 (Pyldyche, William, of Neuton Ferrers, husbandman 1
5018592 2362323 2362323 defendant Pennarth Thomas gent 597114 597114 Pennarth, Thomas, of Neuton Ferrers, gent 1
5018593 2362323 2362323 defendant Spenser John   597114 597114 Spenser, John, of Neuton Ferrers, cook 2
5018594 2362323 2362323 defendant Strete Walter laborer 597114 597114 Strete, Walter, of Neuton Ferrers, laborer 3
5018595 2362323 2362323 defendant Strete William husbandman 597114 597114 Strete, William, of Neuton Ferrers, husbandman 4
5018596 2362323 2362323 defendant Strete John   597114 597114 Strete, John, of Neuton Ferrers, servant 5
5018597 2362323 2362323 defendant Grey John   597114 597114 Grey, John, of Neuton Ferrers, groom 6
5030627 2365829 2365829 defendant Danyell Robert husbandman 597114 597114 Danyell, Robert, of Neuton Ferrers, husbandman 0
5055644 2373260 2373260 defendant Clouter Thomas mariner 597114 597114 Clouter, Thomas, of Neuton Ferrers, mariner 3
5219791 2421514 2421514 defendant Mone William gent 597114 597114 Mone, William, of Neuton Ferrers, gent 0
5219792 2421514 2421514 defendant Upton John gent 597114 597114 together with Upton, John, of Neuton Ferrers, gent 1
5219794 2421515 2421515 defendant Upton John gent 597114 597114 Upton, John, of Neuton Ferrers, gent 0
5220426 2421670 2421670 defendant Sayer Henry husbandman 597114 597114 Sayer, Henry, of Neuton Ferrers, husbandman 0
5239476 2427128 2427128 defendant Monn William gent 597114 597114 Monn, William, of Neuton Ferrers, gent 0
5239477 2427128 2427128 defendant Upton John gent 597114 597114 Upton, John, of Neuton Ferrers, gent 1
5241313 2427659 2427659 defendant Holbeton John husbandman 597114 597114 Holbeton, John, of Neuton Ferrers, husbandman 0
5255688 2431897 2431897 defendant Norman Ralph mariner 597114 597114 Norman, Ralph, of Neuton Ferrers, mariner 2
5274883 2437739 2437739 defendant Holbeton John husbandman 597114 597114 Holbeton, John, of Neuton Ferrers, husbandman 2
5322475 2451794 2451794 defendant Pomerey Nicholas gent 597114 597114 Pomerey, Nicholas, of Neuton Ferrers, gent 0
5322476 2451794 2451794 defendant Carkeke William baker 597114 597114 Carkeke, William, of Neuton Ferrers, baker 1
5322477 2451794 2451794 defendant Talle Ralph   597114 597114 Talle, Ralph, of Neuton Ferrers, "fysshiouter" 2
5341181 2457435 2457435 defendant Eye or Gye John husbandman 597114 597114 Eye or Gye, John, of Neuton Ferrers, husbandman 0
5341182 2457435 2457435 defendant Eye or Gye Walter husbandman 597114 597114 Eye or Gye, Walter, of Neuton Ferrers, husbandman 1
5341183 2457435 2457435 defendant Streche Henry husbandman 597114 597114 Streche, Henry, of Neuton Ferrers, husbandman 2
5341184 2457435 2457435 defendant Herke William husbandman 597114 597114 Herke, William, of Neuton Ferrers, husbandman 3
5341185 2457435 2457435 defendant Lange Andrew husbandman 597114 597114 Lange, Andrew, of Neuton Ferrers, husbandman 4
5341186 2457435 2457435 defendant Martyn John husbandman 597114 597114 Martyn, John, of Neuton Ferrers, husbandman 5
5341187 2457435 2457435 defendant Brokyng Thomas husbandman 597114 597114 Brokyng, Thomas, of Neuton Ferrers, husbandman 6
5362755 2463994 2463994 defendant Lyccher Alexander butcher 597114 597114 Lyccher, Alexander, of Neuton Ferrers, butcher 3
5483063 2499876 2499876 defendant Crowebere John merchant 597114 597114 Crowebere, John, of Neuton Ferrers, merchant 0
5483729 2500083 2500083 defendant Denyell John husbandman 597114 597114 Denyell, John, of Neuton Ferrers, husbandman 0
5509055 2507686 2507686 defendant Dellune Nicholas gent 597114 597114 Dellune, Nicholas, of Neuton Ferrers, gent 0
5509056 2507686 2507686 defendant Dellune Anne widow 597114 597114 Dellune, Anne, of Neuton Ferrers, widow 1
5552871 2520890 2520890 defendant Danyell John husbandman 597114 597114 Danyell, John, of Neuton Ferrers, husbandman 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);