names

44 rows where place_id = 586234

✎ 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
3588227 1863972 1863972 defendant Denman John husbandman 586234 586234 Denman, John, of Est Farlegh, husbandman 0
3588230 1863973 1863973 defendant Denman John   586234 586234 Denman, John, of Est Farlegh, mason 0
3688151 1922444 1922444 defendant Gilys William smith 586234 586234 Gilys, William, of Est Farlegh, smith 1
3746260 1940738 1940738 defendant Kempe William laborer 586234 586234 Kempe, William, of Est Farlegh, laborer 1
3908497 1993140 1993140 defendant Stertout George smith 586234 586234 Stertout, George, of Est Farlegh, smith 0
4651115 2246349 2246349 defendant Poncy or Poucy William   586234 586234 Poncy or Poucy, William, of Est Farlegh, mason 0
4654804 2247381 2247381 defendant Moys Thomas ploughman 586234 586234 Moys, Thomas, of Est Farlegh, ploughman 0
4674148 2257520 2257520 defendant Poney Richard   586234 586234 Poney, Richard, of East Farlegh, mason 1
4709403 2268295 2268295 plaintiff Pende John   586234 586234 Pende, John, of East Farlegh, mason 0
4719466 2271432 2271432 defendant Grenehell Daniel tanner 586234 586234 Grenehell, Daniel, of East Farlegh, tanner 0
4871497 2318052 2318052 defendant Knyght Adam laborer 586234 586234 Knyght, Adam, of Est Farlegh, laborer 1
4906522 2328626 2328626 defendant Colpeper Peter gent 586234 586234 Colpeper, Peter, of Est Farlegh, gent 0
5033570 2366703 2366703 defendant Dodde Peter laborer 586234 586234 Dodde, Peter, of Est Farlegh, laborer 1
5147866 2400519 2400519 defendant Jurdan Thomas   586234 586234 Jurdan, Thomas, of East Farlegh, mason 0
5147867 2400519 2400519 defendant Smyth William   586234 586234 Smyth, William, of East Farlegh, mason 1
5167379 2406195 2406195 defendant Jurdan Thomas   586234 586234 Jurdan, Thomas, of East Farlegh, mason 0
5167380 2406195 2406195 defendant Smyth William   586234 586234 Smyth, William, of East Farlegh, mason 1
5215677 2420309 2420309 defendant Jurdan Thomas   586234 586234 Jurdan, Thomas, of Est Farlegh, mason 2
5215678 2420309 2420309 defendant Smyth Richard mason 586234 586234 Smyth Richard, of Est Farlegh, mason 3
5303128 2445926 2445926 defendant Howard William clerk 586234 586234 Howard, William, of East Farlegh, clerk 0
5341144 2457422 2457422 defendant Aleyn John yeoman 586234 586234 Aleyn, John, of Est Farlegh, yeoman 3
5341149 2457423 2457423 defendant Aleyn Jasper yeoman 586234 586234 Aleyn, Jasper, of East Farlegh, yeoman 3
5342053 2457705 2457705 defendant Chybold William laborer 586234 586234 Chybold, William, of Est Farlegh, laborer 2
5353410 2461146 2461146 defendant Riche William husbandman 586234 586234 Riche, William, of Est Farlegh, husbandman 1
5356567 2462123 2462123 defendant Culter Clement husbandman 586234 586234 Culter, Clement, of Est Farlegh, husbandman 0
5357084 2462275 2462275 defendant Ryche William husbandman 586234 586234 Ryche, William, of Est Farlegh, husbandman 0
5357086 2462276 2462276 defendant Ryche William husbandman 586234 586234 Ryche, William, of Est Farlegh, husbandman 0
5357525 2462420 2462420 plaintiff Netter Geoffrey (legal representative) 586234 586234 Netter, Geoffrey, of Est Farlegh, husbandman, executors of 0
5357527 2462420 2462420 defendant Ryche William husbandman 586234 586234 Ryche, William, of Est Farlegh, or of Hunton, husbandman 0
5372585 2467025 2467025 defendant Hildyche William clerk 586234 586234 Hildyche, William, of East Farlegh, clerk 0
5372586 2467025 2467025 defendant Hobyll or Houyll Edmund fuller 586234 586234 Hobyll or Houyll, Edmund, of East Farlegh, fuller 1
5372587 2467025 2467025 defendant Adam John thatcher 586234 586234 Adam, John, of East Farlegh, thatcher 2
5372588 2467025 2467025 defendant Beket Robert laborer 586234 586234 Beket, Robert, of East Farlegh, laborer 3
5375300 2467861 2467861 defendant Payne Edmund   586234 586234 Payne, Edmund, of East Farlegh 0
5376483 2468242 2468242 defendant Netter Geoffrey   586234 586234 Netter, Geoffrey, of East Farlegh, husbandman, son & heir of Geoffrey Netter, senior 0
5376713 2468314 2468314 defendant Hunte William husbandman 586234 586234 Hunte, William, of East Farlegh, husbandman 1
5412651 2478730 2478730 defendant Reyn John   586234 586234 Reyn, John, of East Farlegh, mason 0
5433175 2484886 2484886 defendant Coveney William husbandman 586234 586234 Coveney, William, of East Farlegh, husbandman 6
5438400 2486418 2486418 defendant Netter Geoffrey husbandman 586234 586234 Netter, Geoffrey, of East Farlegh, husbandman 0
5449001 2489593 2489593 defendant Coveney William husbandman 586234 586234 Coveney, William, of East Farlegh, husbandman 5
5496043 2503707 2503707 defendant Hobyll William husbandman 586234 586234 Hobyll, William, of Est Farlegh, husbandman 4
5511015 2508285 2508285 defendant Hobyll William husbandman 586234 586234 Hobyll, William, of Est Farlegh, husbandman 2
5551502 2520477 2520477 defendant Bend John husbandman 586234 586234 Bend, John, of Est Farlegh, husbandman 2
5628811 2552978 2552978 defendant Bourdon Walter   586234 586234 Bourdon, Walter, of Est Farlegh, mason 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);