names

66 rows where place_id = 592909

✎ 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
3609340 1870581 1870581 defendant Brygger John weaver 592909 592909 Brygger, John, of Cranbroke, Kent, weaver 0
3634920 1905723 1905723 defendant Wynter John dyer 592909 592909 Wynter, John, of Cranbroke, Kent, dyer 0
3644839 1908793 1908793 plaintiff Fowll Edward weaver 592909 592909 Fowll, Edward, of Cranbroke, Kent, weaver 0
3644841 1908794 1908794 plaintiff Fowll Edward weaver 592909 592909 Fowll, Edward, of Cranbroke, Kent, weaver 0
3647352 1909558 1909558 defendant Bereham Thomas gent 592909 592909 Bereham, Thomas, of Cranbroke, Kent, gent 0
3654746 1911742 1911742 defendant Bathurst Lawrence clothier 592909 592909 Bathurst, Lawrence, of Cranbroke, Kent, clothier 1
3660552 1913561 1913561 defendant Eston Julia widow 592909 592909 Eston, Julia, of Cranbroke, Kent, widow 2
3665829 1915250 1915250 defendant Parker Benedicta widow 592909 592909 Parker, Benedicta, of Cranbroke, Kent, widow 1
3691802 1923597 1923597 defendant Pachyng Thomas clothier 592909 592909 Pachyng, Thomas, of Cranbroke, Kent, clothier 0
3694811 1924583 1924583 defendant Andrewe Giles clothman 592909 592909 Andrewe, Giles, of Cranbroke, Kent, clothman 0
3701378 1926677 1926677 defendant Karcagge Gervase clothmaker 592909 592909 Karcagge, Gervase, of Cranbroke, Kent, clothmaker 2
3701382 1926678 1926678 defendant Karcagge Gervase clothmaker 592909 592909 Karcagge, Gervase, of Cranbroke, Kent, clothmaker 1
3709860 1929399 1929399 defendant Page Richard clothier 592909 592909 Page, Richard, of Cranbroke, Kent, clothier 0
3731843 1936188 1936188 defendant Fylpot John clothier 592909 592909 Fylpot, John, of Cranbroke, Kent, clothier 0
3764943 1946698 1946698 defendant Andrewe Giles gent 592909 592909 Andrewe, Giles, of Cranbroke, Kent, gent 0
3780308 1951572 1951572 defendant Scranton Simon yeoman 592909 592909 Scranton, Simon, of Cranbroke, Kent, yeoman 0
3780310 1951573 1951573 defendant Scranton Simon yeoman 592909 592909 Scranton, Simon, of Cranbroke, Kent, yeoman 0
3799109 1957630 1957630 defendant Savay John weaver 592909 592909 Savay, John, of Cranbroke, Kent, weaver 0
3827636 1966501 1966501 defendant Davy Thomas merchant 592909 592909 Davy, Thomas, of Cranbroke, Kent, merchant 1
3842155 1971095 1971095 defendant Olford Roger yeoman 592909 592909 (Olford, Roger, of Cranbroke, Kent, yeoman 1
3865114 1978536 1978536 defendant Davye Thomas clothier 592909 592909 Davye, Thomas, of Cranbroke, Kent, clothier 0
3891477 1987416 1987416 defendant Bysshop Richard yeoman 592909 592909 Bysshop, Richard, of Cranbroke, Kent, yeoman 0
3894609 1988406 1988406 defendant Henley Gervais gent 592909 592909 Henley, Gervais, of Cranbroke, Kent, gent 0
3896089 1988894 1988894 defendant Crier Matthew   592909 592909 Crier, Matthew, of Cranbroke, Kent 3
3904653 1991812 1991812 defendant Atware John yeoman 592909 592909 Atware, John, of Cranbroke, Kent, yeoman 1
3928519 1999877 1999877 defendant Love John gent 592909 592909 Love, John, of Cranbroke, Kent, gent 0
3928886 1999999 1999999 defendant Cowcheman John yeoman 592909 592909 Cowcheman, John, of Cranbroke, Kent, yeoman 2
3935296 2002117 2002117 defendant Love John gent 592909 592909 Love, John, of Cranbroke, Kent, gent 0
3936745 2002616 2002616 defendant Burges Henry yeoman 592909 592909 Burges, Henry, of Cranbroke, Kent, yeoman 1
3965231 2012451 2012451 defendant Cocheford James clothier 592909 592909 Cocheford, James, of Cranbroke, Kent, clothier 0
3965233 2012452 2012452 defendant Cocheford James clothier 592909 592909 Cocheford, James, of Cranbroke, Kent, clothier 0
3965235 2012453 2012453 defendant Cocheford James clothier 592909 592909 Cocheford, James, of Cranbroke, kent, clothier 0
3970511 2014284 2014284 plaintiff Dens Alexander yeoman 592909 592909 Dens, Alexander, of Cranbroke, Kent, yeoman 0
4002404 2025638 2025638 defendant Davye Francis tailor 592909 592909 Davye, Francis, of Cranbroke, Kent, tailor 0
4005600 2026780 2026780 plaintiff Kynge Richard gent 592909 592909 Kynge, Richard, of Cranbroke, Kent, gent 0
4034715 2037097 2037097 defendant Mercer Humphrey clothier 592909 592909 Mercer, Humphrey, of Cranbroke, Kent, clothier 0
4036516 2037743 2037743 defendant Wood William clothier 592909 592909 Wood, William, of Cranbroke, Kent, clothier 0
4046270 2041107 2041107 defendant Denis Alexander gent 592909 592909 Denis, Alexander, of Cranbroke, Kent, gent 0
4048103 2041755 2041755 defendant Dens Alexander gent 592909 592909 Dens, Alexander, of Cranbroke, Kent, gent 0
4051717 2043032 2043032 defendant Thomas John clothier 592909 592909 Thomas, John, of Cranbroke, Kent, clothier 0
4082298 2053980 2053980 defendant Coutchman John clothier 592909 592909 Coutchman, John, of Cranbroke, Kent, clothier 0
4087102 2055681 2055681 defendant Love John gent 592909 592909 Love, John, of Cranbroke, Kent, gent 0
4097966 2059602 2059602 defendant Cowchman John clothier 592909 592909 Cowchman, John, of Cranbroke, Kent, clothier 0
4110051 2063858 2063858 defendant Kelsden Henry clothier 592909 592909 Kelsden, Henry, of Cranbroke, Kent, clothier 0
4128612 2070524 2070524 defendant Peter Thomas clothier 592909 592909 Peter, Thomas, of Cranbroke, Kent, clothier 0
4176541 2087272 2087272 defendant Peter Thomas clothier 592909 592909 Peter, Thomas, of Cranbroke, Kent, clothier 0
4316724 2135966 2135966 defendant Cowcheman John clothier 592909 592909 Cowcheman, John, of Cranbroke, Kent, clothier 3
4379931 2157924 2157924 defendant Modell or Muddle Hugh yeoman 592909 592909 Modell or Muddle, Hugh, of Cranbroke, Kent, yeoman 1
4852561 2312223 2312223 defendant Salt William dyer 592909 592909 Salt, William, of Cranbroke, Kent, dyer 0
4925550 2334424 2334424 defendant Cowpere John smith 592909 592909 Cowpere, John, of Cranbroke, Kent, smith 2
4976956 2350063 2350063 defendant Couper John smith 592909 592909 Couper, John, of Cranbroke, Kent, smith 1
4976960 2350064 2350064 defendant Couper John smith 592909 592909 Couper, John, of Cranbroke, Kent, smith 1
5241259 2427646 2427646 defendant Pette Joan widow 592909 592909 Pette, Joan, of Cranbroke, Kent, widow 0
5263530 2434342 2434342 defendant Broun John dyer 592909 592909 Broun, John, of Cranbroke, Kent, dyer 2
5275378 2437869 2437869 defendant Sendon John dyer 592909 592909 Sendon, John, of Cranbroke, Kent, dyer 1
5289530 2441939 2441939 defendant Bereham Henry esq 592909 592909 Bereham, Henry, of Cranbroke, Kent, esq 0
5406184 2476847 2476847 defendant Gougeman or Gongeman William   592909 592909 Gougeman or Gongeman, William, of Cranbroke, Kent, cloth man 2
5406189 2476848 2476848 defendant Gougeman William   592909 592909 Gougeman, William, of Cranbroke, Kent, cloth man 2
5423601 2482023 2482023 defendant Seynden John clothman 592909 592909 Seynden, John, of Cranbroke, Kent, clothman 1
5455608 2491583 2491583 defendant Swynden John clothmaker 592909 592909 Swynden, John, of Cranbroke, Kent, clothmaker 1
5455612 2491584 2491584 defendant Seynden John clothmaker 592909 592909 Seynden, John, of Cranbroke, Kent, clothmaker 0
5456497 2491869 2491869 defendant Kyngesdowen John carpenter 592909 592909 Kyngesdowen, John, of Cranbroke, Kent, carpenter 0
5460404 2493051 2493051 defendant Taylour Robert dyer 592909 592909 Taylour, Robert, of Cranbroke, Kent, dyer 2
5464115 2494176 2494176 defendant Bogas Robert clothmaker 592909 592909 Bogas, Robert, of Cranbroke, Kent, clothmaker 1
5511068 2508302 2508302 defendant Gyldeford Richard   592909 592909 Gyldeford, Richard, of Cranbroke, Kent, knight 0
5549977 2520030 2520030 defendant Panell Richard clothman 592909 592909 Panell, Richard, of Cranbroke, Kent, clothman 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);