names

239 rows where place_id = 588539

✎ 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
3594871 1866026 1866026 defendant Wryght Robert yeoman 588539 588539 Wryght, Robert, of Est Rudham, yeoman 0
3595599 1866252 1866252 defendant Snasant Robert smith 588539 588539 Snasant, Robert, of Est Rudham, smith 0
3595600 1866252 1866252 defendant Burnham John husbandman 588539 588539 Burnham, John, of Est Rudham, husbandman 1
3595783 1866315 1866315 plaintiff Myotth Robert yeoman 588539 588539 Myotth, Robert, of Est Rudham, yeoman 0
3600051 1867669 1867669 defendant Myot Robert yeoman 588539 588539 Myot, Robert, of Est Rudham, yeoman 0
3606263 1869626 1869626 plaintiff Wade Thomas   588539 588539 Wade, Thomas, of Est Rudham 1
3616689 1872849 1872849 defendant Burnham John husbandman 588539 588539 Burnham, John, of Est Rudham, husbandman 1
3632399 1904951 1904951 defendant Hartyng Edmund yeoman 588539 588539 Hartyng, Edmund, of Est Rudham, yeoman 0
3632400 1904951 1904951 defendant Waryn James yeoman 588539 588539 Waryn, James, of Est Rudham, yeoman 1
3668769 1916168 1916168 defendant Hartyng Edmund husbandman 588539 588539 Hartyng, Edmund, of Est Rudham, husbandman 0
3673575 1917764 1917764 defendant Warn James husbandman 588539 588539 Warn, James, of Est Rudham, husbandman 0
3675109 1918245 1918245 defendant Thomson Robert   588539 588539 Thomson, Robert, of Est Rudham, shepherd 0
3680686 1920039 1920039 defendant Kyng William husbandman 588539 588539 Kyng, William, of Est Rudham, husbandman 1
3680687 1920039 1920039 defendant Gynne John husbandman 588539 588539 Gynne, John, of Est Rudham, husbandman 2
3702579 1927074 1927074 defendant Myllys Richard husbandman 588539 588539 Myllys, Richard, of Est Rudham, husbandman 2
3702580 1927074 1927074 defendant Warn or Warner James husbandman 588539 588539 Warn or Warner, James, of Est Rudham, husbandman 3
3754958 1943500 1943500 defendant Thompson John husbandman 588539 588539 Thompson, John, of Est Rudham, husbandman 0
3754974 1943503 1943503 plaintiff Wade Thomas yeoman 588539 588539 Wade, Thomas, of Est Rudham, yeoman 0
3772489 1949086 1949086 defendant Tomson John husbandman 588539 588539 Tomson, John, of Est Rudham, husbandman 0
3772491 1949087 1949087 plaintiff Wade Thomas yeoman 588539 588539 Wade, Thomas, of Est Rudham, yeoman 0
3775253 1949995 1949995 defendant Kyng Robert husbandman 588539 588539 Kyng, Robert, of Est Rudham, husbandman 2
3783060 1952455 1952455 defendant Wade Thomas yeoman 588539 588539 Wade, Thomas, of Est Rudham, yeoman 0
3823606 1965281 1965281 defendant Watson Thomas   588539 588539 Watson, Thomas, of Est Rudham, shepherd 2
3824070 1965401 1965401 defendant Warner James husbandman 588539 588539 Warner, James, of Est Rudham, husbandman 0
3824071 1965401 1965401 defendant Warner Robert laborer 588539 588539 Warner, Robert, of Est Rudham, laborer 1
3824072 1965401 1965401 defendant Ryche Thomas innkeeper 588539 588539 Ryche, Thomas, of Est Rudham, innkeeper 2
3824073 1965401 1965401 defendant Howlyn Henry husbandman 588539 588539 Howlyn, Henry, of Est Rudham, husbandman 3
3824081 1965405 1965405 defendant Warner James husbandman 588539 588539 Warner, James, of Est Rudham, husbandman 0
3824082 1965405 1965405 defendant Warner Robert laborer 588539 588539 Warner, Robert, of Est Rudham, laborer 1
3824083 1965405 1965405 defendant Ryche Thomas innkeeper 588539 588539 Ryche, Thomas, of Est Rudham, innkeeper 2
3824084 1965405 1965405 defendant Howlyn Henry husbandman 588539 588539 Howlyn, Henry, of Est Rudham, husbandman 3
3824086 1965406 1965406 defendant Warner James husbandman 588539 588539 Warner, James, of Est Rudham, husbandman 0
3824087 1965406 1965406 defendant Warner Robert laborer 588539 588539 Warner, Robert, of Est Rudham, laborer 1
3824088 1965406 1965406 defendant Ryche Thomas innkeeper 588539 588539 Ryche, Thomas, of Est Rudham, innkeeper 2
3824089 1965406 1965406 defendant Howlyn Henry husbandman 588539 588539 Howlyn, Henry, of Est Rudham, husbandman 3
3859580 1976696 1976696 defendant Arnold William thatcher 588539 588539 Arnold, William, of Est Rudham, thatcher 0
3889944 1986873 1986873 defendant Ryche Thomas husbandman 588539 588539 Ryche, Thomas, of Est Rudham, husbandman 2
3893762 1988131 1988131 defendant Ryche Thomas fisherman 588539 588539 Ryche, Thomas, of Est Rudham, fisherman 4
3894576 1988396 1988396 defendant Bokenham Walter husbandman 588539 588539 Bokenham, Walter, of Est Rudham, husbandman 0
3894577 1988396 1988396 defendant Bokenham John husbandman 588539 588539 Bokenham, John, of Est Rudham, husbandman 1
3910723 1993903 1993903 defendant Aunsell William chandler 588539 588539 Aunsell, William, of Est Rudham, chandler 0
3914435 1995172 1995172 defendant Verdon Robert laborer 588539 588539 Verdon, Robert, of Est Rudham, laborer 1
3914437 1995173 1995173 defendant Savery or Salery John   588539 588539 Savery or Salery, John, of Est Rudham, shepherd 0
3933684 2001556 2001556 defendant Saverey John   588539 588539 Saverey, John, of East Rudham, shepherd 0
3935571 2002208 2002208 defendant Sadde Thomas husbandman 588539 588539 Sadde, Thomas, of Est Rudham, husbandman 0
3935572 2002208 2002208 defendant Mylles Thomas yeoman 588539 588539 Mylles, Thomas, of Est Rudham, yeoman 1
3958125 2009913 2009913 plaintiff Reade Edward gent 588539 588539 Reade, Edward, of Est Rudham, gent 0
3989720 2021069 2021069 defendant Holland William   588539 588539 Holland, William, of Est Rudham, shepherd 1
4015296 2030165 2030165 defendant Dawber John husbandman 588539 588539 Dawber, John, of Est Rudham, husbandman 0
4015297 2030165 2030165 defendant Hendrye Richard husbandman 588539 588539 Hendrye, Richard, of Est Rudham, husbandman 1
4015298 2030165 2030165 defendant Cordycke Wilfed husbandman 588539 588539 Cordycke, Wilfed, of Est Rudham, husbandman 2
4039483 2038744 2038744 defendant Holland William   588539 588539 Holland, William, of Est Rudham, shepherd 2
4059700 2045863 2045863 plaintiff Cornewallys Henry esq 588539 588539 Cornewallys, Henry, of Est Rudham, esq 0
4095712 2058799 2058799 defendant Cobbes Richard husbandman 588539 588539 Cobbes, Richard, of Est Rudham, husbandman 0
4113533 2065119 2065119 defendant Mylles Richard yeoman 588539 588539 Mylles, Richard, of Est Rudham, yeoman 1
4128182 2070368 2070368 defendant Rytche Henry yeoman 588539 588539 Rytche, Henry, of East Rudham, yeoman 0
4130579 2071247 2071247 defendant Mylles Richard yeoman 588539 588539 Mylles, Richard, of Est Rudham, yeoman 0
4130580 2071247 2071247 defendant Saverey Edward yeoman 588539 588539 Saverey, Edward, of Est Rudham, yeoman 1
4130581 2071247 2071247 defendant Cobbe Richard husbandman 588539 588539 Cobbe, Richard, of Est Rudham, husbandman 2
4148365 2077560 2077560 defendant Bredhowe Thomas husbandman 588539 588539 Bredhowe, Thomas, of Est Rudham, husbandman 0
4148366 2077560 2077560 defendant Smyth James tailor 588539 588539 Smyth, James, of Est Rudham, tailor 1
4148367 2077560 2077560 defendant Smyth Robert tailor 588539 588539 Smyth, Robert, of Est Rudham, tailor 2
4176191 2087148 2087148 defendant Herbert Richard butcher 588539 588539 Herbert, Richard, of Est Rudham, butcher 0
4176299 2087189 2087189 defendant Mylles Richard yeoman 588539 588539 Mylles, Richard, of Est Rudham, yeoman 0
4180326 2088599 2088599 defendant Mylles Richard yeoman 588539 588539 Mylles, Richard, of Est Rudham, yeoman 0
4183761 2089810 2089810 plaintiff Reade Edward (legal representative) 588539 588539 Reade, Edward, of East Rudham, gent, executors of (Reade, Nicholas 0
4183763 2089810 2089810 defendant Hansell Robert husbandman 588539 588539 Hansell, Robert, of Est Rudham, husbandman 0
4190065 2092026 2092026 defendant Riche Henry yeoman 588539 588539 Riche, Henry, of Est Rudham, yeoman 0
4190066 2092026 2092026 defendant Herberd Richard yeoman 588539 588539 Herberd, Richard, of Est Rudham, yeoman 1
4203963 2096938 2096938 defendant Ryche Henry yeoman 588539 588539 Ryche, Henry, of Est Rudham, yeoman 0
4204216 2097025 2097025 defendant Riche Henry yeoman 588539 588539 Riche, Henry, of Est Rudham, yeoman 0
4204217 2097025 2097025 defendant Herbert Richard yeoman 588539 588539 Herbert, Richard, of Est Rudham, yeoman 1
4225563 2104405 2104405 defendant Tomson Edward yeoman 588539 588539 Tomson, Edward, of Est Rudham, yeoman 0
4245330 2111416 2111416 defendant Armitage Edmund yeoman 588539 588539 Armitage, Edmund, of Est Rudham, yeoman 3
4245335 2111417 2111417 defendant Armitage Edmund yeoman 588539 588539 Armitage, Edmund, of Est Rudham, yeoman 3
4286702 2125294 2125294 defendant Reade Thomas gent 588539 588539 Reade, Thomas, of East Rudham, gent 0
4286704 2125295 2125295 defendant Reade Thomas gent 588539 588539 Reade, Thomas, of East Rudham, gent 0
4351802 2147874 2147874 defendant Saverye John   588539 588539 Saverye, John, of Est Rudham, shepherd 0
4351803 2147874 2147874 defendant Herne John   588539 588539 Herne, John, of Est Rudham, shepherd 1
4351804 2147874 2147874 defendant Burganey William   588539 588539 Burganey, William, of Est Rudham, wheelwright 2
4355413 2149116 2149116 defendant Baulwinge or Bablwinge Henry clerk 588539 588539 Baulwinge or Bablwinge, Henry, of East Rudham, clerk 0
4357847 2149984 2149984 defendant Savery John husbandman 588539 588539 Savery, John, of Est Rudham, husbandman 0
4394272 2162683 2162683 defendant Reade Thomas gent 588539 588539 Reade, Thomas, of East Rudham, gent 0
4404825 2166181 2166181 defendant Sadd Robert yeoman 588539 588539 Sadd, Robert, of Est Rudham, yeoman 0
4409152 2167663 2167663 defendant Reade Thomas gent 588539 588539 Reade, Thomas, of East Rudham, gent 0
4424881 2172619 2172619 defendant Cheyne Thomas   588539 588539 Cheyne, Thomas, of East Rudham 0
4434516 2175551 2175551 defendant Cheyne Thomas   588539 588539 Cheyne, Thomas, of East Rudham 0
4467773 2190598 2190598 defendant Baxter Richard   588539 588539 Baxter, Richard, of East rudham 0
4522672 2207429 2207429 defendant Southgate Roger   588539 588539 Southgate, Roger, of East Rudham 4
4525996 2208431 2208431 defendant Southgate Robert   588539 588539 Southgate, Robert, of East Rudham 8
4558942 2218760 2218760 defendant Barbour Simon   588539 588539 Barbour, Simon, of East Rudham 1
4559264 2218851 2218851 plaintiff Maupas Nicholas (legal representative) 588539 588539 Maupas, Nicholas, of East Rudham, executor of 0
4559267 2218852 2218852 plaintiff Maupas Nicholas (legal representative) 588539 588539 Maupas, Nicholas, of East Rudham, executor of 0
4567130 2221277 2221277 defendant Homan Henry   588539 588539 Homan, Henry, of East Rudham 1
4645908 2244873 2244873 defendant Lamberd John   588539 588539 Lamberd, John, of East Rudham 1
4656463 2247917 2247917 defendant Gilberd William laborer 588539 588539 Gilberd, William, of Est Rudham, laborer 2
4765071 2285052 2285052 defendant Poule John yeoman 588539 588539 Poule, John, of East Rudham, yeoman 1
4765072 2285052 2285052 defendant Smyth John yeoman 588539 588539 Smyth, John, of East Rudham, yeoman 2
4765073 2285052 2285052 defendant Wellys John husbandman 588539 588539 Wellys, John, of East Rudham, husbandman 3
4784743 2291235 2291235 defendant Louthe William husbandman 588539 588539 Louthe, William, of Est Rudham, husbandman 0

Next page

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