names

58 rows where place_id = 592495

✎ 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
3607884 1870114 1870114 defendant Strangwys Thomas chaplain 592495 592495 Strangwys, Thomas, of Wodeham Water, chaplain 0
3673365 1917687 1917687 plaintiff Estwode Hugh   592495 592495 Estwode, Hugh, of Wodeham Water 0
3868103 1979565 1979565 plaintiff Spynsby Robert   592495 592495 Spynsby, Robert, of Wodeham 0
4226456 2104725 2104725 defendant Nicolson William yeoman 592495 592495 Nicolson, William, of Wodeham, yeoman 0
4415957 2169877 2169877 defendant Bande or Baude Stephen   592495 592495 Bande or Baude, Stephen, of Wodeham Water 0
4417808 2170446 2170446 defendant Baude Stephen   592495 592495 Baude, Stephen, of Wodeham Water 0
4422835 2172001 2172001 plaintiff fitz Water John   592495 592495 fitz Water, John, of Wodeham 0
4431473 2174610 2174610 defendant Hamound John   592495 592495 Hamound, John, of Wodeham Water 0
4438924 2181466 2181466 defendant Hamon Roger   592495 592495 Hamon, Roger, of Wodeham Wauter 0
4441579 2182300 2182300 defendant Ive John   592495 592495 Ive, John, of Wodeham Wauter 0
4448259 2184374 2184374 plaintiff fitz Wauter Walter   592495 592495 fitz Wauter, Walter, of Wodeham 0
4530940 2209968 2209968 defendant Haukyn John   592495 592495 Haukyn, John, of Wodeham Water 0
4530941 2209968 2209968 defendant Mason Roger   592495 592495 Mason, Roger, of Wodeham Water 1
4555009 2217496 2217496 defendant fitz Wauter Walter   592495 592495 fitz Wauter, Walter, of Wodeham, knight 0
4586211 2227111 2227111 plaintiff Herde Henry   592495 592495 Herde, Henry, of Wodeham 0
4586213 2227112 2227112 plaintiff Herde Henry   592495 592495 Herde, Henry, of Wodeham Water 0
4592021 2228858 2228858 defendant Ropere John   592495 592495 Ropere, John, of Wodeham Wauter 0
4620904 2237519 2237519 defendant atte Welle William   592495 592495 atte Welle, William, of Wodeham Water 0
4638655 2242841 2242841 defendant atte Welle William   592495 592495 atte Welle, William, of Wodeham Water 0
4654794 2247377 2247377 defendant Lovelych John laborer 592495 592495 Lovelych, John, of Wodeham Water, laborer 0
4655482 2247609 2247609 defendant Herde Henry husbandman 592495 592495 Herde, Henry, of Wodeham Wauter, husbandman 0
4660128 2249014 2249014 defendant Mason Roger yeoman 592495 592495 Mason, Roger, of Wodeham Wauter, yeoman 1
4746459 2279456 2279456 defendant Eliot John husbandman 592495 592495 Eliot, John, of Wodeham, husbandman 1
4749789 2280415 2280415 defendant Burgate John weaver 592495 592495 Burgate, John, of Wodeham Water, weaver 1
4751526 2280930 2280930 defendant Lucas Robert tailor 592495 592495 Lucas, Robert, of Wodeham Water, tailor 1
4782509 2290537 2290537 defendant Saman John fuller 592495 592495 Saman, John, of Wodeham Wauter, fuller 1
4797248 2295312 2295312 defendant FitzWauter Walter   592495 592495 FitzWauter, Walter, of Wodeham, knight 0
4799369 2295980 2295980 defendant Cok John husbandman 592495 592495 Cok, John, of Wodeham Wauter, husbandman 1
4817211 2301474 2301474 defendant Motte Richard laborer 592495 592495 Motte, Richard, of Wodeham Water, laborer 3
4817217 2301475 2301475 defendant Motte Richard laborer 592495 592495 Motte, Richard, of Wodeham Water, laborer 4
4863047 2315420 2315420 defendant Salvage John yeoman 592495 592495 Salvage, John, of Wodeham Water, yeoman 1
4869262 2317354 2317354 defendant Cumberlowe John parker 592495 592495 Cumberlowe, John, of Wodeham Wauter, parker 0
4885558 2322363 2322363 defendant Tunnok John tailor 592495 592495 Tunnok, John, of Wodeham, tailor 1
4900971 2326931 2326931 defendant Strangman Richard husbandman 592495 592495 Strangman, Richard, of Wodeham Wauter, husbandman 0
4900972 2326931 2326931 defendant Cole John husbandman 592495 592495 Cole, John, of Wodeham Wauter, husbandman 1
4950191 2342024 2342024 plaintiff Osebarn John husbandman 592495 592495 Osebarn, John, of Wodeham, husbandman 0
4959483 2344803 2344803 defendant Salvage John yeoman 592495 592495 Salvage, John, of Wodeham Wauter, yeoman 1
4994486 2355217 2355217 defendant fitz Wauter Walter (legal representative) 592495 592495 fitz Wauter, Walter, of Wodeham, knight & lord, executor of 0
4998107 2356297 2356297 defendant fitz Wauter Walter (legal representative) 592495 592495 fitz Wauter, Walter, of Wodeham, executor of 0
4999092 2356606 2356606 defendant fitz Wauter Walter (legal representative) 592495 592495 fitz Wauter, Walter, of Wodeham, executors of 0
5014195 2361002 2361002 defendant Salvage John yeoman 592495 592495 Salvage, John, of Wodeham Water, yeoman 0
5017980 2362141 2362141 defendant Rolfe Thomas smith 592495 592495 Rolfe, Thomas, of Wodeham Mortymer, smith 1
5017982 2362142 2362142 defendant Roulfe John smith 592495 592495 Roulfe, John, of Wodeham Mortymer, smith 0
5023856 2363889 2363889 defendant Smyth John husbandman 592495 592495 Smyth, John, of Wodeham Mortymer, husbandman 0
5093715 2384558 2384558 defendant Rolf Thomas smith 592495 592495 Rolf, Thomas, of Wodeham Mortymer, smith 9
5098530 2386000 2386000 defendant Pers John husbandman 592495 592495 Pers, John, of Wodeham, husbandman 2
5114958 2390790 2390790 defendant Gante Thomas smith 592495 592495 Gante, Thomas, of Wodeham Water, smith 0
5114960 2390790 2390790 defendant Neweman Stephen thatcher 592495 592495 Neweman, Stephen, of Wodeham Water, thatcher 2
5132760 2396076 2396076 defendant Hunt John, junior husbandman 592495 592495 Hunt, John, junior, of Wodeham Water, husbandman 1
5163788 2405144 2405144 defendant Hut John   592495 592495 Hut, John, of Wodeham Water, horse dealer 0
5163791 2405145 2405145 defendant Hunt John   592495 592495 Hunt, John, of Wodeham Water, horse dealer 0
5177280 2409049 2409049 defendant Hunt John   592495 592495 Hunt, John, of Wodeham Water, horse dealer 0
5187818 2412157 2412157 defendant Hunt John husbandman 592495 592495 Hunt, John, of Wodeham, Water, husbandman 1
5200230 2415826 2415826 defendant Hunt John   592495 592495 Hunt, John, of Wodeham Water, horse dealer 0
5211401 2419068 2419068 defendant Hunt John   592495 592495 Hunt, John, of Wodeham Water, horse dealer 0
5382409 2470028 2470028 defendant Bere Robert gent 592495 592495 Bere, Robert, of Wodeham Water, gent 1
5573026 2526664 2526664 plaintiff Onghan or Oughan Thomas   592495 592495 Onghan or Oughan, Thomas, of Wodeham Water 0
5588063 2531278 2531278 plaintiff Owhan Thomas tanner 592495 592495 Owhan, Thomas, of Wodeham Wauter, tanner 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);