names

54 rows where place_id = 598545

✎ 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
3632997 1905140 1905140 defendant Faukener William husbandman 598545 598545 Faukener, William, of Teynton, husbandman 0
3712627 1930266 1930266 defendant Sheaple Geoffrey husbandman 598545 598545 Sheaple, Geoffrey, of Teynton, husbandman 0
3716022 1931298 1931298 plaintiff Chapperleyn Robert chaplain 598545 598545 Chapperleyn, Robert, of Teynton, chaplain 0
3768179 1947688 1947688 defendant Blundell George clerk 598545 598545 Blundell, George, of Teynton, clerk 0
3773612 1949461 1949461 defendant Hylman Edward   598545 598545 Hylman, Edward, of Teynton, franklin 0
3848408 1973078 1973078 defendant Wele William husbandman 598545 598545 Wele, William, of Teynton, husbandman 0
3877639 1982762 1982762 defendant Freman Thomas carpenter 598545 598545 Freman, Thomas, of Teynton, carpenter 0
4033713 2036706 2036706 defendant Knowll Thomas husbandman 598545 598545 Knowll, Thomas, of Teynton, husbandman 0
4154540 2079681 2079681 defendant Rove or Rone Thomas yeoman 598545 598545 Rove or Rone, Thomas, of Teynton, yeoman 0
4169475 2084825 2084825 defendant Wattes William, senior yeoman 598545 598545 Wattes, William, senior, of Teynton, yeoman 0
4169476 2084825 2084825 defendant Wattes William, junior   598545 598545 Wattes, William, junior, of Teynton, yeoman, his son 1
4173106 2086050 2086050 defendant Aylewey Roger husbandman 598545 598545 Aylewey, Roger, of Teynton, husbandman 0
4194376 2093583 2093583 defendant Addys John yeoman 598545 598545 Addys, John, of Teynton, yeoman 0
4214232 2100496 2100496 defendant Watt William, senior yeoman 598545 598545 Watt, William, senior, of Teynton, yeoman 2
4214233 2100496 2100496 defendant Watt William, junior yeoman 598545 598545 Watt, William, junior, of Teynton, yeoman 3
4223886 2103842 2103842 defendant Addys John yeoman 598545 598545 Addys, John, of Teynton, yeoman 0
4223887 2103842 2103842 defendant Dawe Christopher yeoman 598545 598545 Dawe, Christopher, of Teynton, yeoman 1
4228094 2105305 2105305 defendant Wattes William, senior husbandman 598545 598545 Wattes, William, senior, of Teynton, husbandman 0
4228095 2105305 2105305 defendant Wattes William, junior husbandman 598545 598545 Wattes, William, junior, of Teynton, husbandman 1
4228098 2105306 2105306 defendant Dawe Christopher yeoman 598545 598545 Dawe, Christopher, of Teynton, yeoman 0
4236648 2108392 2108392 defendant Wattes William, senior husbandman 598545 598545 Wattes, William, senior, of Teynton, husbandman 0
4236649 2108392 2108392 defendant Wattes William, junior husbandman 598545 598545 Wattes, William, junior, of Teynton, husbandman 1
4236650 2108392 2108392 defendant Wattes Thomas, senior husbandman 598545 598545 Wattes, Thomas, senior, of Teynton, or of Highnam, husbandman 2
4303918 2131504 2131504 defendant Addams John yeoman 598545 598545 Addams, John, of Teynton, or of Aston Ingam, Herefs, yeoman 0
4321081 2137469 2137469 defendant Wattes William, junior yeoman 598545 598545 Wattes, William, junior, of Teynton, yeoman 0
4339132 2143443 2143443 defendant Buge Robert fuller 598545 598545 Buge, Robert, of Teynton, fuller 1
4360908 2151073 2151073 defendant Watt William yeoman 598545 598545 Watt, William, of Teynton, yeoman 0
4371529 2154870 2154870 defendant Watte William, senior husbandman 598545 598545 Watte, William, senior, of Teynton, husbandman 1
4371530 2154870 2154870 defendant Watte William, junior husbandman 598545 598545 Watte, William, junior, of Teynton, husbandman 2
4382470 2158841 2158841 defendant Dawe Christopher yeoman 598545 598545 Dawe, Christopher, of Teynton, yeoman 0
4384898 2159639 2159639 defendant Dawe Christopher yeoman 598545 598545 Dawe, Christopher, of Teynton, yeoman 1
4400273 2164684 2164684 defendant Addames John yeoman 598545 598545 Addames, John, of Teynton, yeoman 0
4589651 2228131 2228131 defendant Carter Robert   598545 598545 Carter, Robert, of Teynton 0
4596944 2230286 2230286 defendant Smyth Roger   598545 598545 Smyth, Roger, of Teynton 0
4606411 2233120 2233120 defendant Cartar John   598545 598545 Cartar, John, of Teynton 3
4629132 2240038 2240038 defendant Thribill Walter   598545 598545 Thribill, Walter, of Teynton 0
4677816 2258678 2258678 defendant Taillour Adam tailor 598545 598545 Taillour, Adam, of Teynton, tailor 0
4693248 2263390 2263390 defendant Aylewy Thomas   598545 598545 Aylewy, Thomas, of Teynton, franklin 0
4838205 2307870 2307870 defendant Hope William (legal representative) 598545 598545 Hope, William, of Teynton, executrix of 1
4846002 2310256 2310256 defendant Phippes John husbandman 598545 598545 Phippes, John, of Teynton, husbandman 0
4853202 2312418 2312418 defendant Kynget John yeoman 598545 598545 Kynget, John, of Teynton, yeoman 0
4862301 2315219 2315219 defendant Gerald Walter husbandman 598545 598545 Gerald, Walter, of Teynton, husbandman 3
4867995 2316958 2316958 plaintiff Howes John   598545 598545 Howes, John, of Teynton 0
4867996 2316958 2316958 defendant Bole John quarrier 598545 598545 Bole, John, of Teynton, quarrier 0
4876829 2319724 2319724 defendant Aylewey Thomas, senior husbandman 598545 598545 Aylewey, Thomas, senior, of Teynton, husbandman 3
4880989 2320966 2320966 defendant Kynget John yeoman 598545 598545 Kynget, John, of Teynton, yeoman 0
4994856 2355313 2355313 defendant Culver John husbandman 598545 598545 Culver, John, of Teynton, husbandman 0
5008910 2359502 2359502 defendant Lloyt Thomas chapman 598545 598545 Lloyt, Thomas, of Teynton, chapman 1
5028987 2365346 2365346 defendant Draper alias Luyde Maurice husbandman 598545 598545 Draper alias Luyde, Maurice, of Teynton, husbandman 3
5174071 2408116 2408116 plaintiff Pynder John   598545 598545 Pynder, John, of Teynton 0
5182595 2410664 2410664 defendant Rawelyns John laborer 598545 598545 Rawelyns, John, of Teynton, laborer 1
5275174 2437814 2437814 defendant House John, junior husbandman 598545 598545 House, John, junior, of Teynton, husbandman 0
5275175 2437814 2437814 defendant House William husbandman 598545 598545 House, William, of Teynton, husbandman 1
5574207 2527020 2527020 defendant Cockes Thomas husbandman 598545 598545 Cockes, Thomas, of Teynton, 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);