names

47 rows where place_id = 596006

✎ 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
3622746 1874643 1874643 plaintiff Renell or Revell Hugh gent 596006 596006 Renell or Revell, Hugh, of Hegham, gent 0
3622748 1874644 1874644 plaintiff Renell or Revell Hugh gent 596006 596006 Renell or Revell, Hugh, of Hegham, gent 0
3788852 1954318 1954318 defendant Lancastre Thomas husbandman 596006 596006 Lancastre, Thomas, of Hegham, husbandman 0
4421189 2171520 2171520 defendant Colle Geoffrey   596006 596006 Colle, Geoffrey, of Hegham 3
4442635 2182646 2182646 defendant Strout William   596006 596006 Strout, William, of Hegham 0
4442641 2182648 2182648 defendant Strout Walter   596006 596006 Strout, Walter, of Hegham 0
4443879 2183053 2183053 defendant Flesshewer John   596006 596006 Flesshewer, John, of Hegham 12
4443881 2183053 2183053 defendant Haye robert   596006 596006 Haye, robert, of Hegham 14
4452220 2185676 2185676 defendant Souter Ralph   596006 596006 Souter, Ralph, of Hegham 0
4457307 2187299 2187299 plaintiff Peke John   596006 596006 Peke, John, of Hegham 0
4465850 2189986 2189986 defendant Souter John   596006 596006 Souter, John, of Hegham, son of Ralph 4
4490335 2197678 2197678 defendant Carter William   596006 596006 Carter, William, of Hegham 0
4497513 2199865 2199865 defendant Wagstaf John   596006 596006 Wagstaf, John, of Hegham 1
4506316 2202475 2202475 defendant Daweson John   596006 596006 Daweson, John, of Hegham 0
4506318 2202475 2202475 defendant Smyth Simon   596006 596006 (Smyth, Simon, of Hegham 2
4515259 2205187 2205187 defendant Daweson John   596006 596006 Daweson, John, of Hegham 0
4515260 2205187 2205187 defendant Leghe John   596006 596006 Leghe, John, of Hegham 1
4518840 2206257 2206257 defendant Wagstaf John   596006 596006 Wagstaf, John, of Hegham 2
4535032 2211234 2211234 defendant Wagstaf John   596006 596006 Wagstaf, John, of Hegham 0
4535034 2211234 2211234 defendant Daweson John   596006 596006 Daweson, John, of Hegham 2
4545613 2214550 2214550 defendant Chapman John   596006 596006 Chapman, John, of Hegham 0
4549352 2215740 2215740 plaintiff Cook William (legal representative) 596006 596006 Cook, William, of Hegham, clerk, executors of 0
4549355 2215740 2215740 defendant Moys Richard   596006 596006 Moys, Richard, of Hegham 0
4551364 2216365 2216365 defendant Souter John   596006 596006 Souter, John, of Hegham, son of Ralph 0
4552621 2216773 2216773 defendant Wagstaf John   596006 596006 Wagstaf, John, of Hegham 0
4555949 2217798 2217798 defendant Brounyng Ralph   596006 596006 Brounyng, Ralph, of Hegham 0
4570528 2222356 2222356 defendant Stalon Robert   596006 596006 Stalon, Robert, of Hegham 0
4586856 2227288 2227288 defendant Leche John   596006 596006 Leche, John, of Hegham 1
4598812 2230858 2230858 defendant Daweseson John   596006 596006 Daweseson, John, of Hegham 1
4603446 2232269 2232269 defendant Rolf John   596006 596006 Rolf, John, of Hegham 1
4610298 2234306 2234306 defendant Smyth Simon   596006 596006 Smyth, Simon, of Hegham 1
4620235 2237310 2237310 defendant Sutton Richard butcher 596006 596006 Sutton, Richard, of Hegham, butcher 2
4632279 2240984 2240984 defendant Pakeman Richard   596006 596006 Pakeman, Richard, of Hegham 1
4634968 2241783 2241783 defendant Souter John   596006 596006 Souter, John, of Hegham 1
4648713 2245681 2245681 defendant Pakeman William   596006 596006 Pakeman, William, of Hegham 0
4667164 2255464 2255464 defendant Walley Thomas forester 596006 596006 Walley, Thomas, of Hegham, forester 0
4709383 2268287 2268287 defendant Strout William yeoman 596006 596006 Strout, William, of Hegham, yeoman 0
4718579 2271149 2271149 defendant Shoter Robert yeoman 596006 596006 Shoter, Robert, of Hegham, yeoman 0
4863074 2315430 2315430 plaintiff Drake William   596006 596006 Drake, William, of Hegham 0
4943718 2340000 2340000 defendant Tirwhyt William   596006 596006 Tirwhyt, William, of Hegham, knight 0
5030079 2365669 2365669 plaintiff Waleys John   596006 596006 Waleys, John, of Hegham 2
5092580 2384206 2384206 plaintiff Payge John   596006 596006 Payge, John, of Hegham 0
5107103 2388506 2388506 defendant Mille Robert weaver 596006 596006 Mille, Robert, of Hegham, weaver 3
5107104 2388506 2388506 defendant Stroute John weaver 596006 596006 Stroute, John, of Hegham, weaver 4
5300465 2445100 2445100 defendant Revell Hugh yeoman 596006 596006 Revell, Hugh, of Hegham, yeoman 0
5318275 2450563 2450563 defendant Revell or Renell Hugh yeoman 596006 596006 Revell or Renell, Hugh, of Hegham, yeoman 0
5352631 2460918 2460918 defendant Andrewe Robert smithyman 596006 596006 Andrewe, Robert, of Hegham, smithyman 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);