names

63 rows where place_id = 587689

✎ 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
3592153 1865165 1865165 defendant Okey Thomas husbandman 587689 587689 Okey, Thomas, of Frampton on Severn, husbandman 0
3592154 1865165 1865165 defendant Hill John tucker 587689 587689 Hill, John, of Frampton on Severn, tucker 1
3595051 1866084 1866084 defendant Woran John yeoman 587689 587689 Woran, John, of Frampton on Severn, yeoman 4
3605311 1869326 1869326 defendant Cole alias Taillour James yeoman 587689 587689 Cole alias Taillour, James, of Frampton on Severn, yeoman 0
3605313 1869327 1869327 defendant Cole James yeoman 587689 587689 Cole, James, of Frampton on Severn, yeoman 0
3699695 1926130 1926130 defendant Vaughan Thomas yeoman 587689 587689 Vaughan, Thomas, of Frampton on Severn, yeoman 0
3699696 1926130 1926130 defendant Sutler William yeoman 587689 587689 Sutler, William, of Frampton on Severn, yeoman 1
3713230 1930444 1930444 defendant Vaughan Thomas yeoman 587689 587689 Vaughan, Thomas, of Frampton on Severn, yeoman 0
3713231 1930444 1930444 defendant Sutler William yeoman 587689 587689 Sutler, William, of Frampton on Severn, yeoman 1
3713232 1930444 1930444 defendant Brounyng Thomas yeoman 587689 587689 Brounyng, Thomas, of Frampton on Severn, yeoman 2
3713233 1930444 1930444 defendant Warmot Thomas husbandman 587689 587689 Warmot, Thomas, of Frampton on Severn, husbandman 3
3839904 1970415 1970415 defendant Hyll William tailor 587689 587689 Hyll, William, of Frampton on Severn, tailor 0
3901002 1990562 1990562 defendant Coryett John mercer 587689 587689 Coryett, John, of Frampton on Severn, mercer 0
3910426 1993803 1993803 defendant Pantrige alias Sutteller Richard husbandman 587689 587689 Pantrige alias Sutteller, Richard, of Frampton on Severn, husbandman 0
4173727 2086268 2086268 defendant Addys John gent 587689 587689 Addys, John, of Frampton on Severn, gent 0
4384719 2159575 2159575 defendant Addyes John gent 587689 587689 Addyes, John, of Frampton on Severn, or of Newport, Berkeley, gent 1
4573347 2223195 2223195 defendant I_ Thomas   587689 587689 I_, Thomas, of Frampton on Severn 0
4589062 2227958 2227958 defendant Pynchoun Walter   587689 587689 Pynchoun, Walter, of Frampton on Severn 1
4589066 2227959 2227959 defendant Pynchoun Walter   587689 587689 Pynchoun, Walter, of Frampton on Severn 1
4592423 2228983 2228983 plaintiff Northerne John   587689 587689 Northerne, John, of Frampton on Severn 0
4649031 2245765 2245765 defendant Glastyngbury John   587689 587689 Glastyngbury, John, of Frampton on Severn 0
4664583 2250403 2250403 defendant Northern John husbandman 587689 587689 Northern, John, of Frampton on Severn, husbandman 1
4666873 2255367 2255367 defendant Aleyn Henry husbandman 587689 587689 Aleyn, Henry, of Frampton on Severn, husbandman 0
4666874 2255367 2255367 defendant Doppyng John husbandman 587689 587689 Doppyng, John, of Frampton on Severn, husbandman 1
4679877 2259314 2259314 defendant Test William husbandman 587689 587689 Test, William, of Frampton on Severn, husbandman 0
4691769 2262958 2262958 defendant Aleyn Henry husbandman 587689 587689 Aleyn, Henry, of Frampton on Severn, husbandman 0
4691770 2262958 2262958 defendant Doppyng John, sen husbandman 587689 587689 Doppyng, John, sen, of Frampton on Severn, husbandman 1
4697288 2264632 2264632 plaintiff Clother Walter   587689 587689 Clother, Walter, of Frampton on Severn 0
4725738 2273337 2273337 defendant Northern John yeoman 587689 587689 Northern, John, of Frampton on Severn, yeoman 1
4731901 2275159 2275159 plaintiff Northerne John   587689 587689 Northerne, John, of Frampton on Severn 0
4731903 2275159 2275159 defendant Aleyn Richard chapman 587689 587689 Aleyn, Richard, of Frampton on Severn, chapman 1
4734349 2275914 2275914 defendant Northerne John farmer 587689 587689 Northerne, John, of Frampton on Severn, farmer 0
4745546 2279208 2279208 defendant Northern John husbandman 587689 587689 Northern, John, of Frampton on Severn, husbandman 3
4820114 2302366 2302366 defendant Northorn John husbandman 587689 587689 Northorn, John, of Frampton on Severn, husbandman 0
4833995 2306639 2306639 defendant Pryde Lawrence   587689 587689 Pryde, Lawrence, of Frampton on Severn, bailiff 1
4836994 2307529 2307529 defendant Horener John   587689 587689 Horener, John, of Frampton on Severn 0
4854962 2312908 2312908 defendant Pryde Lawrence husbandman 587689 587689 Pryde, Lawrence, of Frampton on Severn, husbandman 0
4890081 2323676 2323676 defendant Pryde Lawrence yeoman 587689 587689 Pryde, Lawrence, of Frampton on Severn, yeoman 3
4933026 2336718 2336718 defendant Northerne John husbandman 587689 587689 Northerne, John, of Frampton on Severn, husbandman 0
4939853 2338853 2338853 defendant Holford Geoffrey gent 587689 587689 Holford, Geoffrey, of Frampton on Severn, gent 0
5066993 2376653 2376653 defendant Smyth Thomas smith 587689 587689 Smyth, Thomas, of Frampton on Severn, smith 0
5113588 2390364 2390364 defendant Nyter John gent 587689 587689 Nyter, John, of Frampton on Severn, gent 0
5117313 2391496 2391496 defendant Okey Thomas yeoman 587689 587689 Okey, Thomas, of Frampton on Severn, yeoman 2
5159313 2403838 2403838 defendant Karyot John laborer 587689 587689 Karyot, John, of Frampton on Severn, laborer 0
5195217 2414347 2414347 defendant Karyot John laborer 587689 587689 Karyot, John, of Frampton on Severn, laborer 0
5271698 2436823 2436823 defendant Coke William merchant 587689 587689 Coke, William, of Frampton on Severn, merchant 0
5285989 2440915 2440915 defendant Coke William merchant 587689 587689 Coke, William, of Frampton on Severn, merchant 0
5285990 2440915 2440915 defendant Begge Thomas yeoman 587689 587689 Begge, Thomas, of Frampton on Severn, yeoman 1
5285991 2440915 2440915 defendant Coke William yeoman 587689 587689 Coke, William, of Frampton on Severn, yeoman 2
5285992 2440915 2440915 defendant Coke Lawrence yeoman 587689 587689 Coke, Lawrence, of Frampton on Severn, yeoman 3
5310894 2448291 2448291 defendant Pryde John, sen yeoman 587689 587689 Pryde, John, sen, of Frampton on Severn, yeoman 0
5310895 2448291 2448291 defendant Petyte John yeoman 587689 587689 Petyte, John, of Frampton on Severn, yeoman 1
5357913 2462543 2462543 defendant Kyllyng James laborer 587689 587689 Kyllyng, James, of Frampton on Severn, laborer 0
5357914 2462543 2462543 defendant Pryde John butcher 587689 587689 Pryde, John, of Frampton on Severn, butcher 1
5357915 2462543 2462543 defendant Aleyn John butcher 587689 587689 Aleyn, John, of Frampton on Severn, butcher 2
5357916 2462543 2462543 defendant Aleyn Lawrence butcher 587689 587689 Aleyn, Lawrence, of Frampton on Severn, butcher 3
5394297 2473435 2473435 defendant Okey Thomas yeoman 587689 587689 Okey, Thomas, of Frampton on Severn, yeoman 1
5420724 2481123 2481123 defendant Okey Thomas yeoman 587689 587689 Okey, Thomas, of Frampton on Severn, yeoman 0
5421428 2481345 2481345 defendant Godfray Richard husbandman 587689 587689 Godfray, Richard, of Frampton on Severn, husbandman 0
5439618 2486789 2486789 defendant Okey Thomas yeoman 587689 587689 Okey, Thomas, of Frampton on Severn, yeoman 0
5476770 2498054 2498054 defendant Okey Thomas yeoman 587689 587689 Okey, Thomas, of Frampton on Severn, yeoman 0
5523427 2512156 2512156 defendant Alen John husbandman 587689 587689 Alen, John, of Frampton on Severn, husbandman 0
5528430 2513426 2513426 defendant Fyssher Richard spicer 587689 587689 Fyssher, Richard, of Frampton on Severn, spicer 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);