names

86 rows where place_id = 586857

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589817 1864455 1864455 defendant Thompson William husbandman 586857 586857 Thompson, William, of Estborne, husbandman 3
3589818 1864455 1864455 defendant Rychardson John husbandman 586857 586857 Rychardson, John, of Estborne, husbandman 4
3667887 1915896 1915896 defendant Bacheler John tailor 586857 586857 Bacheler, John, of Estborne, tailor 2
3673605 1917774 1917774 defendant Jonys Andrew beer brewer 586857 586857 Jonys, Andrew, of Estborne, beer brewer 0
3678945 1919483 1919483 defendant Gosden William warrener 586857 586857 Gosden, William, of Estborne, warrener 0
3678957 1919487 1919487 defendant Staple Thomas yeoman 586857 586857 Staple, Thomas, of Estborne, yeoman 0
3708626 1928996 1928996 defendant Staple Thomas yeoman 586857 586857 Staple, Thomas, of Estborne, yeoman 0
3715213 1931051 1931051 defendant Payne James husbandman 586857 586857 Payne, James, of Estborne, husbandman 0
3716552 1931473 1931473 defendant Russell John butcher 586857 586857 Russell, John, of Estborne, butcher 0
3723947 1933770 1933770 defendant Ferall William yeoman 586857 586857 Ferall, William, of Estborne, yeoman 0
3739781 1938655 1938655 defendant Jopson Edward mercer 586857 586857 Jopson, Edward, of Estborne, mercer 0
3739782 1938655 1938655 defendant Stapleton John husbandman 586857 586857 Stapleton, John, of Estborne, husbandman 1
3785904 1953383 1953383 defendant Fesall William husbandman 586857 586857 Fesall, William, of Estborne, husbandman 0
3794011 1955991 1955991 defendant Russell John, senior butcher 586857 586857 Russell, John, senior, of Estborne, butcher 0
3796680 1956844 1956844 defendant Knyght William sherman 586857 586857 Knyght, William, of Estborne, sherman 0
3796681 1956844 1956844 defendant Pylchard Thomas carpenter 586857 586857 Pylchard, Thomas, of Estborne, carpenter 1
3819784 1964068 1964068 defendant Mychelgrove Edward husbandman 586857 586857 Mychelgrove, Edward, of Estborne, husbandman 0
3847195 1972680 1972680 defendant Ferall William husbandman 586857 586857 Ferall, William, of Estborne, husbandman 0
3865447 1978660 1978660 defendant Renne William husbandman 586857 586857 Renne, William, of Estborne, husbandman 1
3874113 1981565 1981565 defendant Russell John butcher 586857 586857 Russell, John, of Estborne, butcher 2
3888741 1986488 1986488 defendant Ferde William husbandman 586857 586857 Ferde, William, of Estborne, husbandman 0
3888742 1986488 1986488 defendant Gyles Henry husbandman 586857 586857 Gyles, Henry, of Estborne, husbandman 1
3889036 1986572 1986572 defendant Russell John, junior butcher 586857 586857 Russell, John, junior, of Estborne, butcher 2
3903140 1991277 1991277 defendant Russell John butcher 586857 586857 Russell, John, of Estborne, butcher 2
3907368 1992754 1992754 defendant Ferall William husbandman 586857 586857 Ferall, William, of Estborne, husbandman 0
3909089 1993339 1993339 defendant Edward Ralph yeoman 586857 586857 Edward, Ralph, of Estborne, yeoman 1
3909090 1993339 1993339 defendant Davy William tailor 586857 586857 Davy, William, of Estborne, tailor 2
3915968 1995721 1995721 defendant Ferall William husbandman 586857 586857 Ferall, William, of Estborne, husbandman 0
3915970 1995722 1995722 defendant Fenell Thomas husbandman 586857 586857 Fenell, Thomas, of Estborne, husbandman 0
3916381 1995860 1995860 defendant Russell John, senior butcher 586857 586857 Russell, John, senior, of Estborne, butcher 0
3916384 1995861 1995861 defendant Russell John, senior butcher 586857 586857 Russell, John, senior, of Estborne, butcher 0
3982155 2018379 2018379 defendant Seale alias Jenner John yeoman 586857 586857 Seale alias Jenner, John, of Estborne, yeoman 0
3982158 2018379 2018379 defendant Edwarde William yeoman 586857 586857 Edwarde, William, of Estborne, yeoman 3
4000738 2025031 2025031 defendant Seale or Selles alias Jenner John yeoman 586857 586857 Seale or Selles alias Jenner, John, of Estborne, yeoman 0
4000739 2025031 2025031 defendant Jurden Geoffrey weaver 586857 586857 Jurden, Geoffrey, of Estborne, weaver 1
4007026 2027289 2027289 defendant Jenner alias Seale John yeoman 586857 586857 Jenner alias Seale, John, of Estborne, yeoman 0
4007028 2027290 2027290 defendant Hudson Robert yeoman 586857 586857 Hudson, Robert, of Estborne, yeoman 0
4007800 2027572 2027572 defendant Seale alias Jenner John yeoman 586857 586857 Seale alias Jenner, John, of Estborne, yeoman 0
4013784 2029660 2029660 defendant Burton William gent 586857 586857 Burton, William, of Estborne, gent 0
4013785 2029660 2029660 defendant Pedelsden John husbandman 586857 586857 Pedelsden, John, of Estborne, husbandman 1
4030517 2035571 2035571 defendant Lobdell William yeoman 586857 586857 Lobdell, William, of Estborne, yeoman 0
4030519 2035572 2035572 defendant Lobdell William yeoman 586857 586857 Lobdell, William, of Estborne, yeoman 0
4041120 2039317 2039317 defendant Seales alias Jenner John yeoman 586857 586857 Seales alias Jenner, John, of Estborne, yeoman 0
4041121 2039317 2039317 defendant Ratlyff John husbandman 586857 586857 Ratlyff, John, of Estborne, husbandman 1
4062254 2046791 2046791 defendant Burton John gent 586857 586857 Burton, John, of Estborne, gent 0
4069581 2049402 2049402 defendant Lopdell John yeoman 586857 586857 Lopdell, John, of Estborne, yeoman 0
4079874 2053101 2053101 defendant Mathye John sherman 586857 586857 Mathye, John, of Estborne, sherman 0
4079875 2053101 2053101 defendant Mathye Thomas sherman 586857 586857 Mathye, Thomas, of Estborne, sherman 1
4079876 2053101 2053101 defendant Payne James yeoman 586857 586857 Payne, James, of Estborne, yeoman 2
4094033 2058195 2058195 defendant Huett Samuel yeoman 586857 586857 Huett, Samuel, of Estborne, yeoman 0
4094034 2058195 2058195 defendant Banyster Edward yeoman 586857 586857 Banyster, Edward, of Estborne, yeoman 1
4098533 2059806 2059806 defendant Huett Samuel yeoman 586857 586857 Huett, Samuel, of Estborne, yeoman 0
4098534 2059806 2059806 defendant Banyster Edward yeoman 586857 586857 Banyster, Edward, of Estborne, yeoman 1
4098535 2059806 2059806 defendant Jornall alias Bretten John yeoman 586857 586857 Jornall alias Bretten, John, of Estborne, yeoman 2
4121307 2067915 2067915 defendant Elfycke John husbandman 586857 586857 (Elfycke, John, of Estborne, husbandman 1
4123035 2068535 2068535 defendant Huett Samuel husbandman 586857 586857 Huett, Samuel, of Estborne, husbandman 0
4123036 2068535 2068535 defendant Wrighte Henry tailor 586857 586857 Wrighte, Henry, of Estborne, tailor 1
4123038 2068536 2068536 defendant Huett Samuel husbandman 586857 586857 Huett, Samuel, of Estborne, husbandman 0
4123039 2068536 2068536 defendant Wrighte Henry tailor 586857 586857 Wrighte, Henry, of Estborne, tailor 1
4125637 2069454 2069454 defendant Hobdaye William husbandman 586857 586857 Hobdaye, William, of Estborne, husbandman 1
4148683 2077663 2077663 defendant Alborne Robert (legal representative) 586857 586857 Alborne, Robert, of Estborne, mercer, executors of 2
4153106 2079185 2079185 defendant Pepper John yeoman 586857 586857 Pepper, John, of Estborne, yeoman 1
4171983 2085662 2085662 defendant Lopdell William yeoman 586857 586857 Lopdell, William, of Estborne, yeoman 0
4200747 2095820 2095820 defendant Mathewe Thomas herman 586857 586857 Mathewe, Thomas, of Estborne, herman 0
4200748 2095820 2095820 defendant Store James husbandman 586857 586857 Store, James, of Estborne, husbandman 1
4202765 2096511 2096511 defendant Jobson John yeoman 586857 586857 Jobson, John, of Estborne, yeoman 0
4202766 2096511 2096511 defendant Smythe Thomas tailor 586857 586857 Smythe, Thomas, of Estborne, tailor 1
4312638 2134554 2134554 defendant Payne John yeoman 586857 586857 Payne, John, of Estborne, yeoman 0
4316173 2135769 2135769 defendant Smythe Thomas blacksmith 586857 586857 Smythe, Thomas, of Estborne, blacksmith 0
4318589 2136614 2136614 defendant Russell Richard butcher 586857 586857 Russell, Richard, of Estborne, butcher 0
4321122 2137480 2137480 defendant Payne John yeoman 586857 586857 Payne, John, of Estborne, or of Telstonne, yeoman 0
4321173 2137499 2137499 defendant Smythe Thomas yeoman 586857 586857 Smythe, Thomas, of Estborne, yeoman 2
4819120 2302057 2302057 defendant Estborne Thomas yeoman 586857 586857 Estborne, Thomas, of Estborne, yeoman 3
4855350 2313027 2313027 defendant Edward Gilbert husbandman 586857 586857 Edward, Gilbert, of Estborne, husbandman 0
4855352 2313028 2313028 defendant Edward Gilbert husbandman 586857 586857 Edward, Gilbert, of Estborne, husbandman 0
5083547 2381580 2381580 defendant Averay John   586857 586857 Averay, John, of Estborne husbandman 3
5284891 2440601 2440601 defendant Michell Thomas husbandman 586857 586857 Michell, Thomas, of Estborne, husbandman 0
5284893 2440602 2440602 defendant Michell Thomas husbandman 586857 586857 Michell, Thomas, of Estborne, husbandman 0
5315704 2449761 2449761 defendant Jowell Alan husbandman 586857 586857 Jowell, Alan, of Estborne, husbandman 2
5380091 2469355 2469355 defendant Rolffe John husbandman 586857 586857 Rolffe, John, of Estborne, husbandman 3
5380096 2469356 2469356 defendant Rolffe John husbandman 586857 586857 Rolffe, John, of Estborne, husbandman 3
5384074 2470533 2470533 defendant Rolffe John husbandman 586857 586857 Rolffe, John, of Estborne, husbandman 1
5515506 2509693 2509693 defendant Frost Nicholas husbandman 586857 586857 Frost, Nicholas, of Estborne, husbandman 2
5575202 2527332 2527332 defendant Barowe John husbandman 586857 586857 Barowe, John, of Estborne, husbandman 4
5582797 2529691 2529691 defendant Crondon James husbandman 586857 586857 Crondon, James, of Estborne, husbandman 5
5636828 2555460 2555460 defendant Eyloff John husbandman 586857 586857 Eyloff, John, of Estborne, husbandman 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);