names

51 rows where place_id = 753502

✎ 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
4413877 2169238 2169238 defendant Arderne Richard tanner 753502 753502 Arderne, Richard, of Henle, tanner 0
4416720 2170095 2170095 defendant Lilly John   753502 753502 Lilly, John, of Henle 4
4418047 2170524 2170524 defendant Burwey John   753502 753502 Burwey, John, of Henle 0
4424355 2172460 2172460 defendant Jory Thomas   753502 753502 Jory, Thomas, of Henle 0
4428991 2173869 2173869 defendant Burwey John   753502 753502 Burwey, John, of Henle 0
4434180 2175454 2175454 defendant Jory Thomas   753502 753502 Jory, Thomas, of Henle 0
4434182 2175455 2175455 defendant Jory Thomas   753502 753502 Jory, Thomas, of Henle 0
4435528 2175871 2175871 defendant Stoke John de   753502 753502 Stoke, John de, of Henle 0
4450261 2185040 2185040 plaintiff Hamulden William   753502 753502 Hamulden, William, of Henle 0
4458813 2187803 2187803 plaintiff Rewyn John   753502 753502 Rewyn, John, of Henle 0
4460480 2188341 2188341 defendant Donoepe John   753502 753502 Donoepe, John, of Henle, senior 2
4460481 2188341 2188341 defendant Maddele Richard   753502 753502 Maddele, Richard, of Henle 3
4460483 2188341 2188341 defendant Beynyn John   753502 753502 Beynyn, John, of Henle 5
4460487 2188342 2188342 defendant Doncepe John   753502 753502 Doncepe, John, of Henle, Oxon, senior 2
4460488 2188342 2188342 defendant Maddele Richard   753502 753502 Maddele, Richard, of Henle 3
4460490 2188342 2188342 defendant Wenyn John   753502 753502 Wenyn, John, of Henle 5
4460494 2188343 2188343 defendant Doncepe John   753502 753502 Doncepe, John, of Henle 2
4460495 2188343 2188343 defendant Maddele Richard   753502 753502 Maddele, Richard, of Henle 3
4460497 2188343 2188343 defendant Bevyn or Benyn John   753502 753502 Bevyn or Benyn, John, of Henle 5
4461172 2188574 2188574 defendant Jory John   753502 753502 Jory, John, of Henle 0
4464419 2189543 2189543 plaintiff Warner Thomas   753502 753502 Warner, Thomas, of Henle, on his own account 0
4464420 2189543 2189543 defendant Wyke Robert   753502 753502 Wyke, Robert, of Henle 0
4485054 2196024 2196024 defendant Barbur Richard   753502 753502 Barbur, Richard, of Henle 0
4502225 2201293 2201293 plaintiff Mercer John   753502 753502 Mercer, John, of Henle, on his own account 0
4502226 2201293 2201293 defendant Botmaker Walter   753502 753502 Botmaker, Walter, of Henle 0
4564192 2220372 2220372 defendant Baker Hugh   753502 753502 Baker, Hugh, of Henle 0
4583831 2226359 2226359 plaintiff Fysshere Walter   753502 753502 Fysshere, Walter, of Henle 0
4614103 2235421 2235421 defendant Cokkes John, sen   753502 753502 Cokkes, John, sen, of Henle 4
4614127 2235430 2235430 plaintiff Douceby John   753502 753502 Douceby, John, of Henle 0
4636993 2242375 2242375 defendant Pekeryngge John   753502 753502 Pekeryngge, John, of Henle 1
4636998 2242376 2242376 defendant Pekerugge John   753502 753502 Pekerugge, John, of Henle 1
4637935 2242632 2242632 defendant Mynchyn John   753502 753502 Mynchyn, John, of Henle 1
4674033 2257489 2257489 defendant Barbour William barber 753502 753502 Barbour, William, of Henle, barber 1
4676012 2258108 2258108 plaintiff Fyssher William   753502 753502 Fyssher, William, of Henle 0
4690692 2262636 2262636 defendant Mersour Richard mercer 753502 753502 Mersour, Richard, of Henle, mercer 6
4697488 2264701 2264701 defendant Pyn John laborer 753502 753502 Pyn, John, of Henle, laborer 1
4750329 2280575 2280575 defendant Devene William husbandman 753502 753502 Devene, William, of Henle, husbandman 0
4911613 2330133 2330133 defendant Hertylpole Peter yeoman 753502 753502 Hertylpole, Peter, of Henle, yeoman 1
4931330 2336178 2336178 defendant Eyneswode Robert butcher 753502 753502 Eyneswode, Robert, of Henle, butcher 1
4967470 2347214 2347214 defendant Clerk Robert gent 753502 753502 (Clerk, Robert, of Henle, gent 1
5251366 2430525 2430525 defendant Curteys alias Coke William yeoman 753502 753502 Curteys alias Coke, William, of Henle, yeoman 0
5443638 2488017 2488017 defendant Chester John laborer 753502 753502 Chester, John, of Henle, laborer 0
5484884 2500403 2500403 defendant Dene John yeoman 753502 753502 Dene, John, of Henle, yeoman 1
5620536 2550281 2550281 defendant Plumtre John clerk 753502 753502 Plumtre, John, of Henle, clerk 0
5627086 2552438 2552438 defendant Pulton Thomas husbandman 753502 753502 Pulton, Thomas, of Henle, husbandman 4
5628005 2552729 2552729 defendant Gratele John ironmonger 753502 753502 Gratele, John, of Henle, ironmonger 3
5630543 2553562 2553562 plaintiff Sare Thomas   753502 753502 Sare, Thomas, of Henle 0
5630544 2553562 2553562 defendant Tanner Philip tanner 753502 753502 Tanner, Philip, of Henle, tanner 0
5630545 2553562 2553562 defendant Holmestre John tanner 753502 753502 Holmestre, John, of Henle, tanner 1
5630546 2553562 2553562 defendant Tanner Richard tanner 753502 753502 Tanner, Richard, of Henle, tanner 2
5631816 2553967 2553967 defendant Myles John husbandman 753502 753502 Myles, John, of Henle, husbandman 2

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