names

67 rows where place_id = 591570

✎ 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
3604864 1869187 1869187 defendant Scardevyle Richard husbandman 591570 591570 Scardevyle, Richard, of Slyndon, husbandman 0
3740215 1938798 1938798 defendant Fawkener John yeoman 591570 591570 Fawkener, John, of Slyndon, yeoman 0
3740217 1938798 1938798 defendant Walle Thomas laborer 591570 591570 Walle, Thomas, of Slyndon, laborer 2
3785083 1953119 1953119 defendant Seyntleger Anthony esq 591570 591570 Seyntleger, Anthony, of Slyndon, esq 0
3818486 1963681 1963681 plaintiff Mason Richard clerk 591570 591570 Mason, Richard, of Slyndon, clerk 0
3895902 1988837 1988837 defendant Wyldblood Thomas husbandman 591570 591570 Wyldblood, Thomas, of Slyndon, husbandman 2
3895903 1988837 1988837 defendant Abbott John husbandman 591570 591570 Abbott, John, of Slyndon, husbandman 3
3895908 1988837 1988837 defendant Glover Thomas husbandman 591570 591570 Glover, Thomas, of Slyndon, husbandman 8
3915050 1995389 1995389 defendant Wynson William smith 591570 591570 Wynson, William, of Slyndon, smith 0
4069587 2049405 2049405 defendant botham James husbandman 591570 591570 botham, James, of Slyndon, husbandman 0
4177462 2087593 2087593 defendant Wyse Henry smith 591570 591570 Wyse, Henry, of Slyndon, smith 0
4181762 2089100 2089100 defendant Trymlett Simon husbandman 591570 591570 Trymlett, Simon, of Slyndon, husbandman 0
4185379 2090398 2090398 defendant Woodall John husbandman 591570 591570 Woodall, John, of Slyndon, husbandman 2
4185380 2090398 2090398 defendant Kyne John yeoman 591570 591570 Kyne, John, of Slyndon, yeoman 3
4366080 2152911 2152911 defendant Michell Simon yeoman 591570 591570 Michell, Simon, of Slyndon, yeoman 0
4371627 2154906 2154906 defendant Heberden Richard yeoman 591570 591570 Heberden, Richard, of Slyndon, yeoman 1
4402292 2165351 2165351 defendant Bothom James husbandman 591570 591570 Bothom, James, of Slyndon, husbandman 3
4413035 2168947 2168947 defendant Venur John le   591570 591570 Venur, John le, of Slyndon, park man 7
4413036 2168947 2168947 defendant Drynkewater Richard   591570 591570 Drynkewater, Richard, of Slyndon 8
4413037 2168947 2168947 defendant Balys John   591570 591570 Balys, John, of Slyndon 9
4422600 2171925 2171925 defendant Reve Arnald le   591570 591570 Reve, Arnald le, of Slyndon 0
4430756 2174377 2174377 defendant Drynkewater Richard   591570 591570 Drynkewater, Richard, of Slyndon 0
4430762 2174377 2174377 defendant Venur John le parker 591570 591570 Venur, John le, of Slyndon, parker 6
4430763 2174377 2174377 defendant Blays John   591570 591570 Blays, John, of Slyndon 7
4480571 2194591 2194591 plaintiff Landesdale William de   591570 591570 Landesdale, William de, of Slyndon, parson 0
4493119 2198550 2198550 defendant Saundres John   591570 591570 Saundres, John, of Slyndon 0
4500772 2200856 2200856 defendant Saundre John   591570 591570 Saundre, John, of Slyndon 0
4509225 2203364 2203364 defendant Burry Stephen   591570 591570 Burry, Stephen, of Slyndon 0
4524946 2208145 2208145 plaintiff Hunte Nicholas (legal representative) 591570 591570 Hunte, Nicholas, of Slyndon, executors of 0
4524956 2208146 2208146 plaintiff Hunte Nicholas (legal representative) 591570 591570 Hunte, Nicholas, of Slyndon, executors of 0
4524964 2208147 2208147 plaintiff Hunte Nicholas (legal representative) 591570 591570 Hunte, Nicholas, of Slyndon, executors of 0
4557075 2218139 2218139 defendant Saundres John   591570 591570 Saundres, John, of Slyndon 0
4620010 2237241 2237241 defendant Saundre John   591570 591570 Saundre, John, of Slyndon 0
4626992 2239390 2239390 defendant Saundyr John   591570 591570 Saundyr, John, of Slyndon 0
4629254 2240086 2240086 plaintiff Smyth Robert   591570 591570 Smyth, Robert, of Slyndon 0
4638074 2242669 2242669 defendant Lane Robert   591570 591570 Lane, Robert, of Slyndon 1
4643171 2244111 2244111 defendant Saundre John   591570 591570 Saundre, John, of Slyndon 0
4682884 2260264 2260264 defendant Burry Nicholas husbandman 591570 591570 Burry, Nicholas, of Slyndon, husbandman 2
4694205 2263688 2263688 defendant Saundres John husbandman 591570 591570 Saundres, John, of Slyndon, husbandman 0
4696749 2264462 2264462 defendant Warde Roger yeoman 591570 591570 Warde, Roger, of Slyndon, yeoman 0
4704273 2266714 2266714 plaintiff Hunte John   591570 591570 Hunte, John, of Slyndon 0
4706567 2267431 2267431 defendant Saundres Thomas chapman 591570 591570 Saundres, Thomas, of Slyndon, chapman 0
4710341 2268589 2268589 defendant Saundre John husbandman 591570 591570 Saundre, John, of Slyndon, husbandman 0
4711392 2268894 2268894 defendant Hunte John husbandman 591570 591570 Hunte, John, of Slyndon, husbandman 1
4715300 2270118 2270118 defendant Oflete John husbandman 591570 591570 Oflete, John, of Slyndon, husbandman 0
4719455 2271429 2271429 defendant Saundres John husbandman 591570 591570 Saundres, John, of Slyndon, husbandman 0
4719458 2271430 2271430 defendant Saundres John husbandman 591570 591570 Saundres, John, of Slyndon, husbandman 0
4762055 2284115 2284115 defendant Saundre Thomas chapman 591570 591570 Saundre, Thomas, of Slyndon, chapman 0
4783212 2290766 2290766 defendant Londe John clerk 591570 591570 Londe, John, of Slyndon, clerk 0
4783213 2290766 2290766 defendant Sabyn Robert husbandman 591570 591570 Sabyn, Robert, of Slyndon, husbandman 1
4790379 2293074 2293074 defendant Saundres John woolman 591570 591570 Saundres, John, of Slyndon, woolman 0
4790382 2293075 2293075 defendant Saundres John woolman 591570 591570 Saundres, John, of Slyndon, woolman 0
4816324 2301192 2301192 defendant Saundres Thomas woolman 591570 591570 (Saundres, Thomas, of Slyndon, woolman 1
4834498 2306798 2306798 defendant Saundrys Thomas husbandman 591570 591570 Saundrys, Thomas, of Slyndon, husbandman 0
4834500 2306799 2306799 defendant Saundyrs Thomas husbandman 591570 591570 Saundyrs, Thomas, of Slyndon, husbandman 0
4913182 2330619 2330619 defendant Philpot John yeoman 591570 591570 Philpot, John, of Slyndon, yeoman 0
4983703 2352054 2352054 defendant Corveser Phaschase shoemaker 591570 591570 Corveser, Phaschase, of Slyndon, shoemaker 0
4984696 2352350 2352350 defendant Morys Philip husbandman 591570 591570 Morys, Philip, of Slyndon, husbandman 0
5008386 2359342 2359342 defendant Fille John husbandman 591570 591570 Fille, John, of Slyndon, husbandman 0
5008387 2359342 2359342 defendant Kyng Lucy   591570 591570 Kyng, Lucy, of Slyndon, widow, formerly wife of John 1
5010317 2359886 2359886 defendant Jay John smith 591570 591570 Jay, John, of Slyndon, smith 0
5036501 2367536 2367536 defendant Dygon John husbandman 591570 591570 Dygon, John, of Slyndon, husbandman 0
5118702 2391899 2391899 defendant Lymere John husbandman 591570 591570 Lymere, John, of Slyndon, husbandman 1
5118703 2391899 2391899 defendant Aylwyn Robert yeoman 591570 591570 Aylwyn, Robert, of Slyndon, yeoman 2
5283803 2440301 2440301 defendant North William   591570 591570 North, William, of Slyndon, "helyer" 13
5283844 2440307 2440307 defendant Dene William husbandman 591570 591570 Dene, William, of Slyndon, husbandman 12
5334561 2455408 2455408 defendant Ryman William gent 591570 591570 Ryman, William, of Slyndon, 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);