names

60 rows where place_id = 587019

✎ 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
3590255 1864597 1864597 defendant Holstok Robert clothier 587019 587019 Holstok, Robert, of Crambroke, Kent, clothier 0
3608803 1870413 1870413 defendant Carteregge John yeoman 587019 587019 Carteregge, John, of Crambroke, Kent, yeoman 0
3608805 1870414 1870414 defendant Herenden James baker 587019 587019 Herenden, James, of Crambroke, Kent, baker 0
3608807 1870415 1870415 defendant Herenden James baker 587019 587019 Herenden, James, of Crambroke, Kent, baker 0
3608811 1870416 1870416 defendant Holstokke Robert clothier 587019 587019 Holstokke, Robert, of Crambroke, Kent, clothier 0
3630632 1904409 1904409 defendant Colyer Thomas yeoman 587019 587019 Colyer, Thomas, of Crambroke, Kent, yeoman 1
3645837 1909103 1909103 defendant Bassok Ralph yeoman 587019 587019 Bassok, Ralph, of Crambroke, Kent, yeoman 0
3651373 1910795 1910795 defendant Hamlett Thomas clothman 587019 587019 Hamlett, Thomas, of Crambroke, Kent, clothman 1
3654750 1911743 1911743 defendant Bathurst Lawrence clothier 587019 587019 Bathurst, Lawrence, of Crambroke, Kent, clothier 1
3670221 1916633 1916633 defendant Parke Walter clothier 587019 587019 Parke, Walter, of Crambroke, Kent, clothier 0
3670224 1916634 1916634 defendant Parke Walter clothier 587019 587019 Parke, Walter, of Crambroke, Kent, clothier 0
3680032 1919819 1919819 defendant Fowler Thomas clothmaker 587019 587019 Fowler, Thomas, of Crambroke, Kent, clothmaker 0
3680037 1919820 1919820 defendant Fowler Thomas clothmaker 587019 587019 Fowler, Thomas, of Crambroke, Kent, clothmaker 0
3682634 1920677 1920677 defendant Chittenden Richard clothman 587019 587019 Chittenden, Richard, of Crambroke, Kent, clothman 1
3686941 1922082 1922082 defendant Karter Reginald clothmaker 587019 587019 Karter, Reginald, of Crambroke, Kent, clothmaker 0
3726276 1934487 1934487 defendant Langley John clothier 587019 587019 Langley, John, of Crambroke, Kent, clothier 0
3832311 1968022 1968022 defendant Love John clothier 587019 587019 Love, John, of Crambroke, Kent, clothier 0
3843936 1971643 1971643 defendant Morebred Thomas clothmaker 587019 587019 Morebred, Thomas, of Crambroke, Kent, clothmaker 0
3865915 1978830 1978830 defendant Robertys Thomas gent 587019 587019 Robertys, Thomas, of Crambroke, Kent, gent 0
3891692 1987476 1987476 defendant Collyar Richard clothier 587019 587019 Collyar, Richard, of Crambroke, Kent, clothier 1
3904658 1991813 1991813 defendant Attwere John   587019 587019 Attwere, John, of Crambroke, Kent, yeoman, son of Robert Attware 1
3946016 2005683 2005683 defendant Lee Andrew mercer 587019 587019 Lee, Andrew, of Crambroke, Kent, mercer 0
3946992 2006012 2006012 defendant Holden William yeoman 587019 587019 Holden, William, of Crambroke, Kent, yeoman 0
3953721 2008376 2008376 defendant Curtoppe William clothier 587019 587019 Curtoppe, William, of Crambroke, Kent, clothier 0
3966585 2012948 2012948 defendant Scotcheford James clothier 587019 587019 Scotcheford, James, of Crambroke, Kent, clothier 0
3973715 2015380 2015380 defendant Scotchforde or Skottforthe Jame alias Johns clothier 587019 587019 Scotchforde or Skottforthe, Jame alias Johns, of Crambroke, Kent, clothier 0
3973717 2015381 2015381 defendant Scothforde James clothier 587019 587019 Scothforde, James, of Crambroke, Kent, clothier 0
3974953 2015805 2015805 defendant Curtop Richard chapman 587019 587019 Curtop, Richard, of Crambroke, Kent, chapman 2
3986607 2019948 2019948 defendant Davye Gervase mercer 587019 587019 Davye, Gervase, of Crambroke, Kent, mercer 0
3986609 2019949 2019949 defendant Davye Gervase mercer 587019 587019 Davye, Gervase, of Crambroke, Kent, mercer 0
3989233 2020890 2020890 plaintiff Baker Richard esq 587019 587019 Baker, Richard, of Crambroke, Kent, esq 0
3996398 2023467 2023467 defendant Harlam Adam   587019 587019 Harlam, Adam, of Crambroke, Kent, yeoman, servant of Thomas Robert, of Boresyll, Tyseherste, Sussex 0
4013337 2029504 2029504 defendant Wood William chapman 587019 587019 Wood, William, of Crambroke, Kent, chapman 0
4015922 2030384 2030384 defendant Thomas John clothier 587019 587019 Thomas, John, of Crambroke, Kent, clothier 0
4027268 2034399 2034399 defendant Boddenden William yeoman 587019 587019 Boddenden, William, of Crambroke, Kent, yeoman 0
4033988 2036810 2036810 defendant Jervys John clothier 587019 587019 Jervys, John, of Crambroke, Kent, clothier 2
4051387 2042917 2042917 defendant Fowle Richard mercer 587019 587019 Fowle, Richard, of Crambroke, Kent, mercer 0
4057258 2044982 2044982 defendant Thomas John yeoman 587019 587019 Thomas, John, of Crambroke, Kent, yeoman 0
4061770 2046610 2046610 defendant Weller Richard clothier 587019 587019 Weller, Richard, of Crambroke, Kent, clothier 1
4083939 2054533 2054533 plaintiff Baker Thomas esq 587019 587019 Baker, Thomas, of Crambroke, Kent, esq 0
4160823 2081860 2081860 defendant Cooke Richard clothier 587019 587019 Cooke, Richard, of Crambroke, Kent, clothier 0
4191477 2092587 2092587 defendant Blacke Thomas yeoman 587019 587019 Blacke, Thomas, of Crambroke, Kent, yeoman 1
4191482 2092588 2092588 defendant Blacke Thomas yeoman 587019 587019 Blacke, Thomas, of Crambroke, Kent, yeoman 1
4226351 2104691 2104691 defendant Oxenbridge Roger sherman 587019 587019 Oxenbridge, Roger, of Crambroke, Kent, or of Burwashe, Sussex, sherman 0
4286597 2125253 2125253 defendant Pyxe Joseph clothier 587019 587019 Pyxe, Joseph, of Crambroke, Kent, clothier 1
4305254 2131975 2131975 defendant Bearde alias Swynesland John shoemaker 587019 587019 Bearde alias Swynesland, John, of Crambroke, Kent, shoemaker 0
5289433 2441910 2441910 defendant Taylour Robert dyer 587019 587019 Taylour, Robert, of Crambroke, Kent, dyer 0
5324586 2452432 2452432 defendant Sendon John dyer 587019 587019 Sendon, John, of Crambroke, Kent, dyer 0
5324595 2452433 2452433 defendant Tayller Lawrence dyer 587019 587019 Tayller, Lawrence, of Crambroke, Kent, dyer 0
5324602 2452434 2452434 defendant Senden John dyer 587019 587019 Senden, John, of Crambroke, Kent, dyer 0
5340309 2457175 2457175 defendant Saunder John, junior   587019 587019 Saunder, John, junior, of Crambroke, Kent, "repyer" 1
5344181 2458358 2458358 defendant at Hale Thomas fuller 587019 587019 at Hale, Thomas, of Crambroke, Kent, fuller 2
5357571 2462438 2462438 defendant Ricard John yeoman 587019 587019 Ricard, John, of Crambroke, Kent, yeoman 0
5362409 2463898 2463898 defendant Adcok John clothmaker 587019 587019 Adcok, John, of Crambroke, Kent, clothmaker 1
5433784 2485072 2485072 defendant Mapesden John yeoman 587019 587019 Mapesden, John, of Crambroke, Kent, yeoman 2
5478918 2498716 2498716 defendant Lymden John yeoman 587019 587019 Lymden, John, of Crambroke, Kent, yeoman 0
5518009 2510476 2510476 defendant Broun Richard cordwainer 587019 587019 Broun, Richard, of Crambroke, Kent, cordwainer 0
5543257 2518010 2518010 defendant Boorne Richard clothmaker 587019 587019 Boorne, Richard, of Crambroke, Kent, clothmaker 0
5543263 2518011 2518011 defendant Boorne Richard clothmaker 587019 587019 Boorne, Richard, of Crambroke, Kent, clothmaker 0
5584631 2530263 2530263 defendant Spencer Alice widow 587019 587019 (Spencer, Alice, of Crambroke, Kent, widow 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);