names

45 rows where place_id = 630176

✎ 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
3792903 1955633 1955633 defendant Kydwelle Thomas shoemaker 630176 630176 Kydwelle, Thomas, of Wyndesore, shoemaker 2
3839066 1970142 1970142 plaintiff Wyndesore Andrew   630176 630176 Wyndesore, Andrew, of Wyndesore, knight 2
3839073 1970143 1970143 plaintiff Wyndesore Andrew   630176 630176 Wyndesore, Andrew, of Wyndesore, knight 2
3839081 1970144 1970144 plaintiff Wyndesore Andrew   630176 630176 Wyndesore, Andrew, of Wyndesore, knight 2
3856726 1975732 1975732 plaintiff Wyndesore Andrew gent 630176 630176 Wyndesore, Andrew, of Wyndesore, gent 0
3898229 1989615 1989615 defendant Smythe Richard innholder 630176 630176 Smythe, Richard, of Wyndesore, innholder 0
3901266 1990648 1990648 defendant Sterkey Agnes widow 630176 630176 Sterkey, Agnes, of Wyndesore, widow 0
4049888 2042391 2042391 defendant Chapman Richard weaver 630176 630176 Chapman, Richard, of Wyndesore, weaver 0
4071102 2049968 2049968 defendant Radford Thomas yeoman 630176 630176 Radford, Thomas, of Wyndesore, yeoman 0
4115394 2065793 2065793 defendant Trodd William waterman 630176 630176 Trodd, William, of Wyndesore, waterman 0
4459337 2187971 2187971 defendant atte Tree Richard   630176 630176 atte Tree, Richard, of Wyndesore 0
4462541 2188981 2188981 defendant Chapman Walter   630176 630176 Chapman, Walter, of Wyndesore 3
4467923 2190646 2190646 plaintiff Barbour John, senior   630176 630176 Barbour, John, senior, of Wyndesore 0
4467925 2190647 2190647 plaintiff Barbour John, senior   630176 630176 Barbour, John, senior, of Wyndesore 0
4496966 2199718 2199718 defendant Westende William   630176 630176 Westende, William, of Wyndesore 1
4539892 2212739 2212739 defendant Spencer Robert   630176 630176 Spencer, Robert, of Wyndesore 4
4540174 2212829 2212829 defendant Spenser Robert   630176 630176 Spenser, Robert, of Wyndesore 4
4550380 2216061 2216061 defendant Barbur John chaplain 630176 630176 Barbur, John, of Wyndesore, chaplain 0
4565541 2220794 2220794 defendant Norys Walter butcher 630176 630176 Norys, Walter, of Wyndesore, butcher 0
4591402 2228667 2228667 defendant Sy Simon   630176 630176 Sy, Simon, of Wyndesore 0
4617605 2236514 2236514 defendant Braban William   630176 630176 Braban, William, of Wyndesore 2
4619969 2237227 2237227 plaintiff Shepherd Henry   630176 630176 (Shepherd, Henry, of Wyndesore 1
4643084 2244087 2244087 plaintiff Horsley John esq & constable of the Castle 630176 630176 Horsley, John, of Wyndesore, esq & constable of the Castle 0
4656019 2247764 2247764 defendant Somerton Thomas yeoman 630176 630176 Somerton, Thomas, of Wyndesore, yeoman 0
4675695 2258007 2258007 defendant Ridle Richard yeoman 630176 630176 Ridle, Richard, of Wyndesore, yeoman 0
4676183 2258163 2258163 defendant Gowe Robert clerk 630176 630176 Gowe, Robert, of Wyndesore, clerk 0
4701231 2265785 2265785 defendant Caucy Henry husbandman 630176 630176 Caucy, Henry, of Wyndesore, husbandman 1
4710236 2268554 2268554 defendant Mogenhode Thomas   630176 630176 Mogenhode, Thomas, of Wyndesore, mill ward 0
4818236 2301782 2301782 plaintiff Noble Roger (legal representative) 630176 630176 Noble, Roger, of Wyndesore, warden of the King's wardrobe or vestry, executor of 0
4818237 2301782 2301782 plaintiff (not given) Nicholas vicar of Bungeye 630176 630176 Bungeye, Nicholas, of Wyndesore, vicar of the college 1
4881188 2321021 2321021 defendant Brice William husbandman 630176 630176 Brice, William, of Wyndesore, husbandman 8
4883663 2321805 2321805 defendant Coterell Robert husbandman 630176 630176 Coterell, Robert, of Wyndesore, husbandman 0
4896268 2325497 2325497 defendant Sherman Roger fisher 630176 630176 Sherman, Roger, of Wyndesore, fisher 2
4896416 2325546 2325546 defendant Orcherd John husbandman 630176 630176 Orcherd, John, of Wyndesore, husbandman 0
4926633 2334748 2334748 defendant Hunte Roger sheerman 630176 630176 Hunte, Roger, of Wyndesore, sheerman 3
4951615 2342461 2342461 defendant Duryche Thomas clerk 630176 630176 Duryche, Thomas, of Wyndesore, clerk 0
5299772 2444902 2444902 defendant Arter William yeoman 630176 630176 Arter, William, of Wyndesore, yeoman 3
5346815 2459162 2459162 plaintiff Aythorp Henry dyer 630176 630176 Aythorp, Henry, of Wyndesore, dyer 0
5356201 2462018 2462018 defendant Dawe John husbandman 630176 630176 Dawe, John, of Wyndesore, husbandman 0
5356202 2462018 2462018 defendant Dawe Thomas husbandman 630176 630176 Dawe, Thomas, of Wyndesore, husbandman 1
5432726 2484752 2484752 defendant Tanner Henry chapman 630176 630176 Tanner, Henry, of Wyndesore, chapman 0
5448743 2489518 2489518 defendant Tanner Henry chapman 630176 630176 Tanner, Henry, of Wyndesore, chapman 0
5459622 2492794 2492794 defendant Fleccher John   630176 630176 Fleccher, John, of Wyndesore, apothecary 1
5491572 2502365 2502365 plaintiff Canceler Thomas   630176 630176 Canceler, Thomas, of Wyndesore 0
5631493 2553859 2553859 defendant Harneys or Harveys William tailor 630176 630176 Harneys or Harveys, William, of Wyndesore, tailor 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);