names

39 rows where place_id = 588256

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593854 1865717 1865717 defendant Bysshoppe John husbandman 588256 588256 Bysshoppe, John, of Hadlowe, Kent, husbandman 3
3613376 1871829 1871829 defendant Fyssher John husbandman 588256 588256 Fyssher, John, of Hadlowe, Kent, husbandman 0
3701793 1926810 1926810 defendant Akent Thomas yeoman 588256 588256 Akent, Thomas, of Hadlowe, Kent, yeoman 0
3715972 1931284 1931284 defendant Lewsall John smith 588256 588256 Lewsall, John, of Hadlowe, Kent, smith 0
3769779 1948201 1948201 defendant Style Walter yeoman 588256 588256 Style, Walter, of Hadlowe, Kent, yeoman 0
3790757 1954935 1954935 defendant Fane Henry esq 588256 588256 Fane, Henry, of Hadlowe, Kent, esq 0
3836620 1969356 1969356 defendant Vane Ralph gent 588256 588256 Vane, Ralph, of Hadlowe, Kent, gent 0
3840204 1970503 1970503 defendant Fane Ralph gent 588256 588256 Fane, Ralph, of Hadlowe, Kent, gent 0
3847199 1972681 1972681 defendant Fane Richard gent 588256 588256 Fane, Richard, of Hadlowe, Kent, gent 2
3860212 1976910 1976910 defendant Fane Ralph gent 588256 588256 Fane, Ralph, of Hadlowe, Kent, gent 2
3860219 1976911 1976911 defendant Fane Ralph gent 588256 588256 Fane, Ralph, of Hadlowe, Kent, gent 2
3862500 1977653 1977653 defendant Fane Ralph gent 588256 588256 Fane, Ralph, of Hadlowe, Kent, gent 0
3862502 1977654 1977654 defendant Fane Ralph gent 588256 588256 Fane, Ralph, of Hadlowe, Kent, gent 0
3886771 1985835 1985835 defendant Fane Ralph esq 588256 588256 Fane, Ralph, of Hadlowe, Kent, esq 0
3886773 1985836 1985836 defendant Fane Ralph esq 588256 588256 Fane, Ralph, of Hadlowe, Kent, esq 0
3896593 1989068 1989068 defendant Fane Ralph esq 588256 588256 Fane, Ralph, of Hadlowe, Kent, esq 0
3909001 1993305 1993305 defendant Fane alias Vane Ralph esq 588256 588256 Fane alias Vane, Ralph, of Hadlowe, Kent, esq 0
3910948 1993986 1993986 defendant Fane Ralph esq 588256 588256 Fane, Ralph, of Hadlowe, Kent, esq 0
3936080 2002389 2002389 defendant Walter William butcher 588256 588256 Walter, William, of Hadlowe, Kent, butcher 3
3963356 2011786 2011786 defendant Walter William innholder or butcher 588256 588256 Walter, William, of Hadlowe, Kent, innholder or butcher 0
3970396 2014245 2014245 defendant Vane Henry esq 588256 588256 Vane, Henry, of Hadlowe, Kent, esq 1
3971641 2014644 2014644 plaintiff Fane Thomas   588256 588256 Fane, Thomas, of Hadlowe, Kent 0
3991998 2021902 2021902 defendant Wyllarde David yeoman 588256 588256 Wyllarde, David, of Hadlowe, Kent, yeoman 0
4013981 2029736 2029736 defendant Willard David yeoman 588256 588256 Willard, David, of Hadlowe, Kent, yeoman 1
4061950 2046673 2046673 defendant Fanne Henry gent 588256 588256 Fanne, Henry, of Hadlowe, Kent, gent 1
4108660 2063351 2063351 defendant Rootes Richard butcher 588256 588256 Rootes, Richard, of Hadlowe, Kent, butcher 0
4345220 2145605 2145605 defendant Lampard William gent 588256 588256 Lampard, William, of Hadlowe, Kent, gent 0
4348157 2146602 2146602 defendant Iden John gent 588256 588256 Iden, John, of Hadlowe, Kent, gent 0
4372022 2155056 2155056 defendant Iden John gent 588256 588256 Iden, John, of Hadlowe, Kent, gent 0
4512950 2204483 2204483 defendant Mauware Robert   588256 588256 Mauware, Robert, of Hadlowe, Kent 0
4869810 2317530 2317530 defendant Burdon Richard ripier or fishmonger 588256 588256 Burdon, Richard, of Hadlowe, Kent, ripier or fishmonger 1
4869815 2317531 2317531 defendant Burdon Richard rypyer 588256 588256 Burdon, Richard, of Hadlowe, Kent, rypyer 1
5018513 2362294 2362294 defendant Burdon Thomas ripier or fishmonger 588256 588256 Burdon,Thomas, of Hadlowe, Kent, ripier or fishmonger 3
5118200 2391760 2391760 defendant More John husbandman 588256 588256 More, John, of Hadlowe, Kent, husbandman 0
5118202 2391761 2391761 defendant More John husbandman 588256 588256 More, John, of Hadlowe, Kent, husbandman 0
5217527 2420863 2420863 defendant at Stable John yeoman 588256 588256 at Stable, John, of Hadlowe, Kent, yeoman 1
5257094 2432351 2432351 defendant Nenge John husbandman 588256 588256 Nenge, John, of Hadlowe, Kent, husbandman 1
5336369 2455945 2455945 defendant Gylmyn John gent 588256 588256 Gylmyn, John, of Hadlowe, Kent, gent 0
5356942 2462235 2462235 defendant Benenden or Bevenden John chapman 588256 588256 Benenden or Bevenden, John, of Hadlowe, Kent, chapman 3

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