names

56 rows where place_id = 592304

✎ 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
3607271 1869937 1869937 defendant Waryn William husbandman 592304 592304 Waryn, William, of Horham, husbandman 3
3623973 1875029 1875029 plaintiff Brood Richard   592304 592304 Brood, Richard, of Horham 1
3623976 1875030 1875030 plaintiff Broodhok Edward   592304 592304 Broodhok, Edward, of Horham 1
3623979 1875031 1875031 plaintiff Broodhook Edward   592304 592304 Broodhook, Edward, of Horham 1
3672840 1917517 1917517 defendant Lyndsey John, junior husbandman 592304 592304 Lyndsey, John, junior, of Horham, husbandman 0
3692804 1923940 1923940 defendant Folkerd John, senior husbandman 592304 592304 Folkerd, John, senior, of Horham, husbandman 1
3762143 1945803 1945803 defendant Lynsey John husbandman 592304 592304 Lynsey, John, of Horham, husbandman 0
3782935 1952408 1952408 defendant Brodooke Simon yeoman 592304 592304 Brodooke, Simon, of Horham, yeoman 0
3782938 1952409 1952409 defendant Brodooke SImon yeoman 592304 592304 Brodooke, SImon, of Horham, yeoman 0
3804840 1959458 1959458 defendant Copyldyke Leonard (legal representative) 592304 592304 Copyldyke, Leonard, of Horham, gent, executors of 0
3822272 1964870 1964870 defendant Copyldyke Leonard gent 592304 592304 (Copyldyke, Leonard, of Horham, gent 1
3855188 1975256 1975256 defendant Alred William yeoman 592304 592304 Alred, William, of Horham, yeoman 0
3891123 1987298 1987298 plaintiff Kent Roger gent 592304 592304 Kent, Roger, of Horham, gent 0
3905453 1992093 1992093 defendant Brodock Simon gent 592304 592304 Brodock, Simon, of Horham, gent 0
3905454 1992093 1992093 defendant Calver Thomas laborer 592304 592304 Calver, Thomas, of Horham, laborer 1
3907118 1992671 1992671 defendant Bradock Simon gent 592304 592304 Bradock, Simon, of Horham, gent 0
3907122 1992673 1992673 defendant Kente Roger gent 592304 592304 Kente, Roger, of Horham, gent 0
3973081 2015155 2015155 defendant Rowse Thomas gent 592304 592304 Rowse, Thomas, of Horham, gent 0
3973355 2015253 2015253 defendant Ryxe John husbandman 592304 592304 Ryxe, John, of Horham, husbandman 0
3977819 2016814 2016814 defendant Gurlyng Thomas tailor 592304 592304 Gurlyng, Thomas, of Horham, tailor 0
3992288 2022008 2022008 defendant Gyrlyng John yeoman 592304 592304 Gyrlyng, John, of Horham, yeoman 1
4216088 2101120 2101120 defendant Lovell James gent 592304 592304 Lovell, James, of Horham, gent 1
4275883 2121513 2121513 defendant Hatch John weaver 592304 592304 Hatch, John, of Horham, weaver 0
4279539 2122762 2122762 defendant Foxe William husbandman 592304 592304 Foxe, William, of Horham, husbandman 2
4279543 2122763 2122763 defendant Clodd John joiner 592304 592304 Clodd, John, of Horham, joiner 1
4327419 2139494 2139494 defendant Wright Robert laborer 592304 592304 Wright, Robert, of Horham, laborer 2
4336546 2142518 2142518 defendant Games or Gaines Robert yeoman 592304 592304 Games or Gaines, Robert, of Horham, yeoman 4
4339858 2143714 2143714 defendant Bemont Henry husbandman 592304 592304 Bemont, Henry, of Horham, husbandman 1
4352441 2148094 2148094 defendant Kente Thomas gent 592304 592304 Kente, Thomas, of Horham, gent 0
4352442 2148094 2148094 defendant Sherman John gent 592304 592304 Sherman, John, of Horham, gent 1
4352446 2148095 2148095 defendant Clubb John yeoman 592304 592304 Clubb, John, of Horham, yeoman 0
4352448 2148095 2148095 defendant Hasell George husbandman 592304 592304 Hasell, George, of Horham, husbandman 2
4376543 2156679 2156679 defendant Clubb John yeoman 592304 592304 Clubb, John, of Horham, yeoman 0
4376545 2156680 2156680 defendant Hasell George husbandman 592304 592304 Hasell, George, of Horham, husbandman 0
4376549 2156681 2156681 defendant Hasell George husbandman 592304 592304 together with Hasell, George, of Horham, husbandman 1
4405624 2166451 2166451 defendant Bemond Henry weaver 592304 592304 Bemond, Henry, of Horham, weaver 1
4405625 2166451 2166451 defendant Wyeth Robert yeoman 592304 592304 Wyeth, Robert, of Horham, yeoman 2
4405626 2166451 2166451 defendant Wyth Thomas yeoman 592304 592304 Wyth, Thomas, of Horham, yeoman 3
4405629 2166452 2166452 defendant Sampson Thomas husbandman 592304 592304 Sampson, Thomas, of Horham, husbandman 1
4409384 2167734 2167734 defendant Hasell George yeoman 592304 592304 Hasell, George, of Horham, yeoman 1
4436741 2176233 2176233 defendant Clerk Robert le   592304 592304 Clerk, Robert le, of Horham 0
4751247 2280840 2280840 defendant Whermond Robert yeoman 592304 592304 Whermond, Robert, of Horham, yeoman 3
4761855 2284052 2284052 plaintiff Esthawe John   592304 592304 Esthawe, John, of Horham 0
4775648 2288379 2288379 defendant Thrower John chaplain 592304 592304 Thrower, John, of Horham, chaplain 0
5032745 2366465 2366465 defendant Folkard Thomas yeoman 592304 592304 Folkard, Thomas, of Horham, yeoman 0
5233848 2425485 2425485 defendant Lewe Adam yeoman 592304 592304 (Lewe, Adam, of Horham, yeoman 1
5233849 2425485 2425485 defendant Page John yeoman 592304 592304 Page, John, of Horham, yeoman 2
5327020 2453159 2453159 defendant Page John carpenter 592304 592304 Page, John, of Horham, carpenter 2
5332457 2454774 2454774 plaintiff Cley John husbandman 592304 592304 Cley, John, of Horham, husbandman 0
5452044 2490492 2490492 plaintiff Starlyng John clerk 592304 592304 Starlyng, John, of Horham, clerk 0
5463982 2494145 2494145 plaintiff Starlyng John clerk 592304 592304 Starlyng, John, of Horham, clerk 0
5483191 2499913 2499913 defendant Garlyng or Earlyng Thomas husbandman 592304 592304 Garlyng or Earlyng, Thomas, of Horham, husbandman 1
5491418 2502319 2502319 defendant Folcard Thomas yeoman 592304 592304 Folcard, Thomas, of Horham, yeoman 7
5554452 2521337 2521337 defendant Alred Richard yeoman 592304 592304 (Alred, Richard, of Horham, yeoman 1
5566688 2524852 2524852 defendant Alred Richard husbandman 592304 592304 Alred, Richard, of Horham, husbandman 3
5571135 2526120 2526120 plaintiff Kyng Richard   592304 592304 Kyng, Richard, of Horham 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);