names

64 rows where place_id = 589791

✎ 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
3598762 1867242 1867242 defendant Leukenore Edward gent 589791 589791 Leukenore, Edward, of Goryng, gent 0
3604865 1869187 1869187 defendant Pyper Richard husbandman 589791 589791 Pyper, Richard, of Goryng, husbandman 1
3613900 1872001 1872001 defendant Pychard Thomas yeoman 589791 589791 Pychard, Thomas, of Goryng, yeoman 1
3617201 1873003 1873003 defendant Wattes John husbandman 589791 589791 Wattes, John, of Goryng, husbandman 6
3621768 1874347 1874347 defendant Grene John gent 589791 589791 Grene, John, of Goryng, gent 0
3670468 1916722 1916722 defendant Talbott William husbandman 589791 589791 Talbott, William, of Goryng, husbandman 0
3706120 1928207 1928207 defendant Sylkeden Thomas tailor 589791 589791 Sylkeden, Thomas, of Goryng, tailor 0
3720818 1932802 1932802 defendant Talbot William husbandman 589791 589791 Talbot, William, of Goryng, husbandman 0
3759260 1944887 1944887 defendant Whyte Richard husbandman 589791 589791 Whyte, Richard, of Goryng, husbandman 0
3770067 1948300 1948300 defendant Talbott William husbandman 589791 589791 Talbott, William, of Goryng, husbandman 0
3773258 1949344 1949344 defendant Talbott William husbandman 589791 589791 Talbott, William, of Goryng, husbandman 0
3787442 1953865 1953865 defendant Reve Thomas husbandman 589791 589791 Reve, Thomas, of Goryng, husbandman 0
3787443 1953865 1953865 defendant Reve Christopher husbandman 589791 589791 Reve, Christopher, of Goryng, husbandman 1
3893379 1988017 1988017 defendant Coke John husbandman 589791 589791 Coke, John, of Goryng, husbandman 2
3895608 1988733 1988733 defendant Howe William husbandman 589791 589791 Howe, William, of Goryng, husbandman 0
4042900 2039937 2039937 defendant Andrewe John yeoman 589791 589791 Andrewe, John, of Goryng, yeoman 2
4067254 2048587 2048587 defendant Androwes John yeoman 589791 589791 Androwes, John, of Goryng, yeoman 0
4067256 2048588 2048588 defendant Androwes Thomas yeoman 589791 589791 Androwes, Thomas, of Goryng, yeoman 0
4078586 2052642 2052642 defendant Andrewe John, senior yeoman 589791 589791 Andrewe, John, senior, of Goryng, yeoman 1
4078587 2052642 2052642 defendant Payne John husbandman 589791 589791 Payne, John, of Goryng, husbandman 2
4085404 2055055 2055055 defendant Andrewe John, senior yeoman 589791 589791 Andrewe, John, senior, of Goryng, yeoman 0
4085405 2055055 2055055 defendant Andrewe John, junior yeoman 589791 589791 Andrewe, John, junior, of Goryng, yeoman 1
4113251 2065006 2065006 defendant Androwes John yeoman 589791 589791 Androwes, John, of Goryng, yeoman 0
4115736 2065909 2065909 defendant Paynett John husbandman 589791 589791 Paynett, John, of Goryng, husbandman 0
4115737 2065909 2065909 defendant Whyttington John yeoman 589791 589791 Whyttington, John, of Goryng, yeoman 1
4235031 2107804 2107804 defendant Wyseman John tailor 589791 589791 Wyseman, John, of Goryng, tailor 1
4456800 2187134 2187134 defendant Poule Robert   589791 589791 Poule, Robert, of Goryng 0
4477665 2193681 2193681 defendant Kyng William   589791 589791 Kyng, William, of Goryng 0
4626307 2239185 2239185 defendant Dod John   589791 589791 Dod, John, of Goryng 3
4657374 2248198 2248198 plaintiff Clyfton John   589791 589791 Clyfton, John, of Goryng 0
4671692 2256792 2256792 defendant Roberd William husbandman 589791 589791 Roberd, William, of Goryng, husbandman 1
4724605 2272994 2272994 defendant Dodde John   589791 589791 Dodde, John, of Goryng, wool man 1
4733975 2275810 2275810 defendant Horscroft Robert draper 589791 589791 Horscroft, Robert, of Goryng, draper 0
4755182 2282007 2282007 defendant Horscroft Robert husbandman 589791 589791 Horscroft, Robert, of Goryng, husbandman 5
4758300 2282971 2282971 defendant Grene Richard gent 589791 589791 Grene, Richard, of Goryng, gent 0
4813376 2300300 2300300 defendant Passynden John husbandman 589791 589791 Passynden, John, of Goryng, husbandman 0
4915558 2331366 2331366 defendant Dodde John laborer 589791 589791 Dodde, John, of Goryng, laborer 0
4951884 2342536 2342536 defendant Rolle Robert husbandman 589791 589791 Rolle, Robert, of Goryng, husbandman 1
4991542 2354353 2354353 defendant Fygge John husbandman 589791 589791 Fygge, John, of Goryng, husbandman 3
5021910 2363302 2363302 defendant Peryn William husbandman 589791 589791 Peryn, William, of Goryng, husbandman 1
5090819 2383705 2383705 defendant Grene Richard gent 589791 589791 Grene, Richard, of Goryng, gent 0
5106186 2388246 2388246 defendant Wolvyn John merchant 589791 589791 Wolvyn, John, of Goryng, merchant 1
5109908 2389325 2389325 defendant Ellesmere Edward esq 589791 589791 Ellesmere, Edward, of Goryng, esq 0
5109909 2389325 2389325 defendant Whitburn William yeoman 589791 589791 Whitburn, William, of Goryng, yeoman 1
5109910 2389325 2389325 defendant Husbond Lawrence yeoman 589791 589791 Husbond, Lawrence, of Goryng, yeoman 2
5116736 2391329 2391329 defendant Crey Thomas smith 589791 589791 Crey, Thomas, of Goryng, smith 0
5118173 2391752 2391752 defendant Lucas Richard husbandman 589791 589791 Lucas, Richard, of Goryng, husbandman 0
5118174 2391752 2391752 defendant Knyght Robert husbandman 589791 589791 Knyght, Robert, of Goryng, husbandman 1
5159731 2403948 2403948 defendant Robard John husbandman 589791 589791 Robard, John, of Goryng, husbandman 1
5189988 2412813 2412813 defendant Fouller Vincent laborer 589791 589791 Fouller, Vincent, of Goryng, laborer 0
5189999 2412817 2412817 defendant Perot Richard laborer 589791 589791 Perot, Richard, of Goryng, laborer 1
5206718 2417702 2417702 defendant Perot Richard laborer 589791 589791 Perot, Richard, of Goryng, laborer 1
5207329 2417885 2417885 defendant Forde John husbandman 589791 589791 Forde, John, of Goryng, husbandman 1
5248461 2429676 2429676 defendant Wattes William husbandman 589791 589791 Wattes, William, of Goryng, husbandman 5
5307588 2447284 2447284 defendant Perot John laborer 589791 589791 Perot, John, of Goryng, laborer 0
5323148 2452006 2452006 defendant Greynder Thomas husbandman 589791 589791 Greynder, Thomas, of Goryng, husbandman 0
5323150 2452007 2452007 defendant Grynder Thomas husbandman 589791 589791 Grynder, Thomas, of Goryng, husbandman 0
5332545 2454800 2454800 defendant Fyssher William chaplain 589791 589791 Fyssher, William, of Goryng, chaplain 1
5356137 2461996 2461996 defendant Perot Richard husbandman 589791 589791 Perot, Richard, of Goryng, husbandman 1
5371696 2466737 2466737 defendant Grene Thomas, junior gent 589791 589791 Grene, Thomas, junior, of Goryng, gent 2
5414930 2479398 2479398 defendant Grene Thomas yeoman 589791 589791 Grene, Thomas, of Goryng, yeoman 4
5444249 2488186 2488186 defendant Bolde (illegible) husbandman 589791 589791 Bolde, _, of Goryng, husbandman 1
5493538 2502981 2502981 defendant Lovyngcote or Lonyngcote Thomas gent 589791 589791 Lovyngcote or Lonyngcote, Thomas, of Goryng, gent 0
5538251 2516449 2516449 defendant Leukenore Edward gent 589791 589791 Leukenore, Edward, of Goryng, gent 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);