names

67 rows where place_id = 753366

✎ 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
4412995 2168939 2168939 plaintiff Andreu William   753366 753366 Andreu, William, of Langeford 0
4415686 2169789 2169789 defendant Walkere Simon   753366 753366 Walkere, Simon, of Langeford 0
4436033 2176002 2176002 defendant Godwyne William   753366 753366 Godwyne, William, of Langeford, son of Lawrence 0
4444483 2183254 2183254 defendant Thekkere John   753366 753366 Thekkere, John, of Langeford 0
4447754 2184225 2184225 defendant Boure Henry   753366 753366 Boure, Henry, of Langeford 0
4450119 2184996 2184996 defendant Clerk John   753366 753366 Clerk, John, of Langeford 0
4502331 2201318 2201318 plaintiff Methewold John (legal representative) 753366 753366 Methewold, John, of Langeford, executors of 0
4505273 2202179 2202179 defendant Bailly William   753366 753366 Bailly, William, of Langeford 0
4505275 2202179 2202179 defendant Bocher John   753366 753366 Bocher, John, of Langeford 2
4507544 2202820 2202820 defendant Strech John   753366 753366 Strech, John, of Langeford 1
4512395 2204320 2204320 defendant Revyle Walter   753366 753366 Revyle, Walter, of Langeford 0
4527568 2208901 2208901 defendant Nynge John   753366 753366 Nynge, John, of Langeford 0
4527569 2208901 2208901 defendant Herde Richard   753366 753366 Herde, Richard, of Langeford, servant of Thomas 1
4545949 2214669 2214669 defendant Esse John   753366 753366 Esse, John, of Langeford, bailiff of the manor 0
4549360 2215742 2215742 defendant Boose John   753366 753366 Boose, John, of Langeford 1
4551010 2216255 2216255 defendant Bocher John   753366 753366 Bocher, John, of Langeford 0
4553800 2217114 2217114 defendant Turnour Walter   753366 753366 Turnour, Walter, of Langeford 0
4559061 2218792 2218792 defendant Rede William   753366 753366 Rede, William, of Langeford 3
4564413 2220439 2220439 defendant Alwey John   753366 753366 Alwey, John, of Langeford 0
4567656 2221446 2221446 defendant Fyssher William   753366 753366 Fyssher, William, of Langeford 1
4568167 2221612 2221612 plaintiff Turnour Geoffrey   753366 753366 Turnour, Geoffrey, of Langeford 0
4568169 2221612 2221612 defendant Rede William   753366 753366 Rede, William, of Langeford 1
4590908 2228509 2228509 plaintiff Maynard John   753366 753366 Maynard, John, of Langeford 0
4609199 2233983 2233983 plaintiff Brounyng John   753366 753366 Brounyng, John, of Langeford, vicar 0
4609201 2233984 2233984 plaintiff Brounyng John   753366 753366 Brounyng, John, of Langeford, vicar 0
4609538 2234085 2234085 defendant Skele John   753366 753366 Skele, John, of Langeford 1
4615381 2235819 2235819 plaintiff Faresley Simon   753366 753366 Faresley, Simon, of Langeford, perpetual vicar 0
4654043 2247149 2247149 defendant Skyl John ploughman 753366 753366 Skyl, John, of Langeford, ploughman 0
4654044 2247149 2247149 defendant Skyl William ploughman 753366 753366 Skyl, William, of Langeford, ploughman 1
4656142 2247803 2247803 defendant Marchal John, junior husbandman 753366 753366 Marchal, John, junior, of Langeford, husbandman 0
4658608 2248569 2248569 defendant Mot Richard husbandman 753366 753366 Mot, Richard, of Langeford, husbandman 2
4660129 2249014 2249014 defendant Hierde John yeoman 753366 753366 Hierde, John, of Langeford, yeoman 2
4674070 2257499 2257499 defendant Grilleston William gent 753366 753366 Grilleston, William, of Langeford, gent 0
4676638 2258311 2258311 defendant atte Halle William husbandman 753366 753366 atte Halle, William, of Langeford, husbandman 0
4676639 2258311 2258311 defendant Hampton Richard husbandman 753366 753366 Hampton, Richard, of Langeford, husbandman 1
4676641 2258311 2258311 defendant Mewes John husbandman 753366 753366 Mewes, John, of Langeford, husbandman 3
4676642 2258311 2258311 defendant Smyth John husbandman 753366 753366 Smyth, John, of Langeford, husbandman 4
4677620 2258616 2258616 defendant Taillour John husbandman 753366 753366 Taillour, John, of Langeford, husbandman 2
4686211 2261285 2261285 defendant Ivell Richard husbandman 753366 753366 Ivell, Richard, of Langeford, husbandman 1
4694058 2263644 2263644 defendant Page Walter husbandman 753366 753366 Page, Walter, of Langeford, husbandman 0
4725837 2273368 2273368 defendant Grenehull John ploughman 753366 753366 Grenehull, John, of Langeford, ploughman 0
4743305 2278568 2278568 defendant Bakere Walter husbandman 753366 753366 Bakere, Walter, of Langeford, husbandman 1
4743308 2278569 2278569 defendant Bakere Water husbandman 753366 753366 Bakere, Water, of Langeford, husbandman 1
4765544 2285214 2285214 defendant Grenehill John   753366 753366 Grenehill, John, of Langeford, plough man 2
4782194 2290430 2290430 defendant Deye John, senior husbandman 753366 753366 Deye, John, senior, of Langeford, husbandman 2
4782195 2290430 2290430 defendant Deye John, junior husbandman 753366 753366 Deye, John, junior, of Langeford, husbandman 3
4782196 2290430 2290430 defendant Busshup Robert husbandman 753366 753366 Busshup, Robert, of Langeford, husbandman 4
4788293 2292409 2292409 defendant Compe John husbandman 753366 753366 Compe, John, of Langeford, husbandman 0
4788295 2292410 2292410 defendant Gompe John husbandman 753366 753366 Gompe, John, of Langeford, husbandman 0
4799164 2295916 2295916 defendant Fyssher William   753366 753366 Fyssher, William, of Langeford 1
4816655 2301304 2301304 defendant Couper John husbandman 753366 753366 Couper, John, of Langeford, husbandman 1
4861955 2315118 2315118 defendant Hampton John loader 753366 753366 Hampton, John, of Langeford, loader 0
4909337 2329461 2329461 defendant Lusshe William husbandman 753366 753366 Lusshe, William, of Langeford Lester, husbandman 0
4909389 2329476 2329476 defendant Langeford Henry esq 753366 753366 Langeford, Henry, of Langeford, esq 3
4923728 2333861 2333861 defendant Speryng Simon carpenter 753366 753366 Speryng, Simon, of Langeford, carpenter 0
5078481 2380061 2380061 defendant Chyboll Richard husbandman 753366 753366 Chyboll, Richard, of Langeford, husbandman 3
5078482 2380061 2380061 defendant Chyboll John husbandman 753366 753366 Chyboll, John, of Langeford, husbandman 4
5141181 2398543 2398543 defendant Percivale Thurstan   753366 753366 Percivale, Thurstan, of Langeford, parson 0
5315370 2449655 2449655 defendant Damerell John husbandman 753366 753366 Damerell, John, of Langeford Lester, husbandman 0
5338203 2456515 2456515 defendant Bailly Richard husbandman 753366 753366 Bailly, Richard, of Langeford, husbandman 1
5433238 2484905 2484905 defendant Vowell William gent 753366 753366 Vowell, William, of Langeford Lester, gent 2
5493284 2502900 2502900 defendant Martyn Walter husbandman 753366 753366 Martyn, Walter, of Langeford, husbandman 0
5613440 2547995 2547995 defendant Alesaundre John   753366 753366 (Alesaundre, John, of Langeford 1
5624351 2551561 2551561 defendant Trepe John husbandman 753366 753366 Trepe, John, of Langeford, husbandman 1
5624355 2551562 2551562 defendant Trope John husbandman 753366 753366 Trope, John, of Langeford, husbandman 1
5628666 2552936 2552936 defendant atte Noke John husbandman 753366 753366 atte Noke, John, of Langeford, husbandman 3
5631781 2553953 2553953 defendant Hamoton Richard husbandman 753366 753366 Hamoton, Richard, of Langeford, husbandman 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);