names

76 rows where place_id = 589436

✎ 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
3597643 1866887 1866887 defendant Gardener Adam husbandman 589436 589436 Gardener, Adam, of Oxburgh, husbandman 0
3603643 1868807 1868807 defendant Hewer John, senior yeoman 589436 589436 Hewer, John, senior, of Oxburgh, yeoman 0
3616698 1872853 1872853 defendant Hewar John, senior yeoman 589436 589436 Hewar, John, senior, of Oxburgh, yeoman 0
3620379 1873958 1873958 defendant Hewer Thomas yeoman 589436 589436 Hewer, Thomas, of Oxburgh, yeoman 1
3667798 1915869 1915869 defendant Myte Edmund husbandman 589436 589436 Myte, Edmund, of Oxburgh, husbandman 1
3667799 1915869 1915869 defendant Lane Roger husbandman 589436 589436 Lane, Roger, of Oxburgh, husbandman 2
3719990 1932523 1932523 plaintiff Hewer Thomas, senior yeoman 589436 589436 Hewer, Thomas, senior, of Oxburgh, yeoman 0
3729239 1935396 1935396 plaintiff Attemere Thomas   589436 589436 Attemere, Thomas, of Oxburgh 0
3729240 1935396 1935396 plaintiff Halman Thomas   589436 589436 Halman, Thomas, of Oxburgh 1
3755772 1943764 1943764 defendant Hewer Thomas yeoman 589436 589436 Hewer, Thomas, of Oxburgh, yeoman 0
3799372 1957725 1957725 plaintiff Jakson Mathew   589436 589436 Jakson, Mathew, of Oxburgh 0
3799373 1957725 1957725 plaintiff Halman Thomas   589436 589436 Halman, Thomas, of Oxburgh 1
3847602 1972820 1972820 plaintiff Hewer Thomas   589436 589436 Hewer, Thomas, of Oxburgh 0
3862967 1977811 1977811 plaintiff Hewer Thomas   589436 589436 Hewer, Thomas, of Oxburgh 0
3927804 1999639 1999639 defendant Hewer Arthur gent 589436 589436 Hewer, Arthur, of Oxburgh, gent 0
4363034 2151843 2151843 defendant Bretten Thomas gent 589436 589436 Bretten, Thomas, of Oxburgh, gent 0
4476506 2193318 2193318 defendant Coupere John   589436 589436 Coupere, John, of Oxburgh 1
4544073 2214061 2214061 defendant Rodberd Edmund   589436 589436 Rodberd, Edmund, of Oxburgh 0
4739336 2277390 2277390 defendant Hagh John husbandman 589436 589436 Hagh, John, of Oxburgh, husbandman 0
4773619 2287719 2287719 defendant H_bury John tailor 589436 589436 H_bury, John, of Oxburgh, tailor 1
4843923 2309616 2309616 defendant Hagh John yeoman 589436 589436 Hagh, John, of Oxburgh, yeoman 0
4858163 2313922 2313922 defendant Wyot Walter clerk 589436 589436 Wyot, Walter, of Oxburgh, clerk 0
4864366 2315833 2315833 defendant Rede Richard gent 589436 589436 Rede, Richard, of Oxburgh, gent 0
4947264 2341133 2341133 defendant Reed Julia widow 589436 589436 Reed, Julia, of Oxburgh, widow 1
4990331 2354015 2354015 defendant Caton John husbandman 589436 589436 Caton, John, of Oxburgh, husbandman 1
5081281 2380912 2380912 defendant Fraunceys William yeoman 589436 589436 Fraunceys, William, of Oxburgh, yeoman 0
5115304 2390904 2390904 defendant Estgate John husbandman 589436 589436 Estgate, John, of Oxburgh, husbandman 3
5136851 2397300 2397300 defendant Nyxson Robert yeoman 589436 589436 Nyxson, Robert, of Oxburgh, yeoman 1
5142383 2398895 2398895 plaintiff Wigenhale John clerk & Master 589436 589436 Wigenhale, John, of Oxburgh, clerk & Master 0
5157420 2403308 2403308 defendant Nyxson Robert yeoman 589436 589436 Nyxson, Robert, of Oxburgh, yeoman 1
5173339 2407911 2407911 defendant Nyxson Robert yeoman 589436 589436 Nyxson, Robert, of Oxburgh, yeoman 1
5251698 2430636 2430636 defendant Bocher John yeoman 589436 589436 Bocher, John, of Oxburgh, yeoman 1
5279937 2439206 2439206 defendant Swyfte John husbandman 589436 589436 (Swyfte, John, of Oxburgh, husbandman 3
5279943 2439207 2439207 defendant Swyfte John husbandman 589436 589436 (Swyfte, John, of Oxburgh, husbandman 4
5282049 2439822 2439822 defendant Hewer John yeoman 589436 589436 Hewer, John, of Oxburgh, yeoman 0
5283706 2440281 2440281 defendant Chater Thomas roper 589436 589436 Chater, Thomas, of Oxburgh, roper 0
5286371 2441013 2441013 defendant Chater or Chatrys Thomas roper 589436 589436 Chater or Chatrys, Thomas, of Oxburgh, roper 0
5291085 2442395 2442395 defendant Hewer John yeoman 589436 589436 Hewer, John, of Oxburgh, yeoman 0
5323560 2452128 2452128 plaintiff Palmer Richard   589436 589436 Palmer, Richard, of Oxburgh 0
5324006 2452266 2452266 defendant Hewer John butcher 589436 589436 Hewer, John, of Oxburgh, butcher 0
5349899 2460100 2460100 defendant Hewer John yeoman 589436 589436 Hewer, John, of Oxburgh, yeoman 0
5374514 2467633 2467633 defendant Bateman William husbandman 589436 589436 Bateman, William, of Oxburgh, husbandman 0
5394409 2473466 2473466 defendant Bateman William husbandman 589436 589436 Bateman, William, of Oxburgh, husbandman 0
5445833 2488644 2488644 defendant Bateman William yeoman 589436 589436 Bateman, William, of Oxburgh, yeoman 1
5496027 2503704 2503704 defendant Russell Thomas husbandman 589436 589436 Russell, Thomas, of Oxburgh, husbandman 2
5498793 2504578 2504578 defendant Hewer John, senior yeoman 589436 589436 Hewer, John, senior, of Oxburgh, yeoman 0
5498794 2504578 2504578 defendant Hewer Thomas yeoman 589436 589436 Hewer, Thomas, of Oxburgh, yeoman 1
5498795 2504578 2504578 defendant Hewer John, junior yeoman 589436 589436 Hewer, John, junior, of Oxburgh, yeoman 2
5498797 2504579 2504579 defendant Hewer John, senior yeoman 589436 589436 Hewer, John, senior, of Oxburgh, yeoman 0
5498798 2504579 2504579 defendant Hewer Thomas yeoman 589436 589436 Hewer, Thomas, of Oxburgh, yeoman 1
5498799 2504579 2504579 defendant Hewer John, junior yeoman 589436 589436 Hewer, John, junior, of Oxburgh, yeoman 2
5500015 2504957 2504957 defendant Russell Henry husbandman 589436 589436 Russell, Henry, of Oxburgh, husbandman 0
5502342 2505656 2505656 defendant Hewer John yeoman 589436 589436 Hewer, John, of Oxburgh, yeoman 0
5503952 2506146 2506146 defendant Hewer John, senior butcher 589436 589436 Hewer, John, senior, of Oxburgh, butcher 0
5503954 2506147 2506147 defendant Hewer John, senior butcher 589436 589436 Hewer, John, senior, of Oxburgh, butcher 0
5507496 2507239 2507239 defendant Hewer John yeoman 589436 589436 Hewer, John, of Oxburgh, yeoman 0
5507497 2507239 2507239 defendant Hewer Thomas yeoman 589436 589436 Hewer, Thomas, of Oxburgh, yeoman 1
5507499 2507240 2507240 defendant Hewer John yeoman 589436 589436 Hewer, John, of Oxburgh, yeoman 0
5507500 2507240 2507240 defendant Hewer Thomas yeoman 589436 589436 Hewer, Thomas, of Oxburgh, yeoman 1
5507682 2507306 2507306 defendant Hewer Thomas husbandman 589436 589436 Hewer, Thomas, of Oxburgh, husbandman 0
5511804 2508544 2508544 defendant Hewer Thomas yeoman 589436 589436 Hewer, Thomas, of Oxburgh, yeoman 1
5511807 2508545 2508545 defendant Hewer Thomas yeoman 589436 589436 Hewer, Thomas, of Oxburgh, yeoman 1
5512268 2508698 2508698 defendant Hewer Thomas butcher 589436 589436 Hewer, Thomas, of Oxburgh, butcher 0
5513267 2508998 2508998 defendant Hewer John, junior merchant 589436 589436 Hewer, John, junior, of Oxburgh, merchant 0
5513269 2508999 2508999 defendant Hewer John, senior merchant 589436 589436 Hewer, John, senior, of Oxburgh, merchant 0
5514515 2509387 2509387 defendant Russell Thomas yeoman 589436 589436 Russell, Thomas, of Oxburgh, yeoman 0
5516794 2510071 2510071 defendant Hewer Thomas husbandman 589436 589436 Hewer, Thomas, of Oxburgh, husbandman 0
5539244 2516760 2516760 defendant Lacy Roger husbandman 589436 589436 Lacy, Roger, of Oxburgh, husbandman 1
5539245 2516760 2516760 defendant Lacy Agnes widow 589436 589436 Lacy, Agnes, of Oxburgh, widow 2
5545473 2518665 2518665 defendant Dowenyng Robert husbandman 589436 589436 Dowenyng, Robert, of Oxburgh, husbandman 0
5545474 2518665 2518665 defendant Roberd Richard miller 589436 589436 Roberd, Richard, of Oxburgh, miller 1
5546990 2519125 2519125 defendant Holle alias Hewer Thomas yeoman 589436 589436 Holle alias Hewer, Thomas, of Oxburgh, yeoman 0
5564058 2524102 2524102 defendant Holyer Agnes widow 589436 589436 Holyer, Agnes, of Oxburgh, widow 1
5568066 2525210 2525210 defendant Crumme Robert clerk 589436 589436 Crumme, Robert, of Oxburgh, clerk 0
5568069 2525211 2525211 defendant Crumme Robert clerk 589436 589436 Crumme, Robert, of Oxburgh, clerk 0
5630203 2553450 2553450 defendant Pygge Nicholas weaver 589436 589436 Pygge, Nicholas, of Oxburgh, weaver 4

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);