names

29 rows where place_id = 792783

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4731657 2275094 2275094 defendant Honyter John chaplain 792783 792783 Honyter, John, of Sevenoaks, Kent, chaplain 0
4763898 2284701 2284701 defendant Northwode John husbandman 792783 792783 Northwode, John, of Sevenoaks, Kent, husbandman 0
4842925 2309329 2309329 defendant Smyth John gent 792783 792783 Smyth, John, of Sevenoaks, Kent, gent 0
4844430 2309770 2309770 defendant Brode William sadler 792783 792783 (Brode, William, of Sevenoaks, Kent, sadler 1
4999228 2356642 2356642 defendant Bele John yeoman 792783 792783 Bele, John, of Sevenoaks, Kent, yeoman 0
5000917 2357146 2357146 defendant Berde Robert   792783 792783 Berde, Robert, of Sevenoaks, Kent, parish clerk 3
5134970 2396728 2396728 defendant Sove or Sone Walter yeoman 792783 792783 Sove or Sone, Walter, of Sevenoaks, Kent, yeoman 5
5159160 2403796 2403796 defendant Bele John husbandman 792783 792783 Bele, John, of Sevenoaks, Kent, husbandman 0
5159162 2403796 2403796 defendant Cheseman Thomas tailor 792783 792783 Cheseman, Thomas, of Sevenoaks, Kent, tailor 2
5163235 2404977 2404977 defendant Bele John husbandman 792783 792783 Bele, John, of Sevenoaks, Kent, husbandman 0
5163237 2404978 2404978 defendant Bele John yeoman 792783 792783 Bele, John, of Sevenoaks, Kent, yeoman 0
5163239 2404979 2404979 defendant Bele John yeoman 792783 792783 Bele, John, of Sevenoaks, Kent, yeoman 0
5174399 2408214 2408214 defendant Bele John husbandman 792783 792783 Bele, John, of Sevenoaks, Kent, husbandman 0
5174401 2408214 2408214 defendant Cheseman Thomas tailor 792783 792783 Cheseman, Thomas, of Sevenoaks, Kent, tailor 2
5176974 2408956 2408956 defendant Bele John   792783 792783 Bele, John, of Sevenoaks, Kent 0
5181653 2410376 2410376 defendant Bele John gent 792783 792783 Bele, John, of Sevenoaks, Kent, gent 0
5195015 2414292 2414292 defendant Bele John husbandman 792783 792783 Bele, John, of Sevenoaks, Kent, husbandman 0
5195017 2414292 2414292 defendant Cheseman Thomas tailor 792783 792783 Cheseman, Thomas, of Sevenoaks, Kent, tailor 2
5195024 2414294 2414294 defendant Cheseman Thomas tailor 792783 792783 Cheseman, Thomas, of Sevenoaks, Kent, tailor 1
5199664 2415646 2415646 defendant Bele John yeoman 792783 792783 Bele, John, of Sevenoaks, Kent, yeoman 0
5209067 2418385 2418385 defendant Bele John husbandman 792783 792783 Bele, John, of Sevenoaks, Kent, husbandman 0
5211192 2419001 2419001 defendant Bele John yeoman 792783 792783 Bele, John, of Sevenoaks, Kent, yeoman 0
5404333 2476316 2476316 defendant Walker John   792783 792783 Walker, John, of Sevenoaks, Kent 1
5450106 2489920 2489920 defendant Walter John yeoman 792783 792783 Walter, John, of Sevenoaks, Kent, yeoman 0
5452406 2490593 2490593 defendant (illegible) Thomas yeoman 792783 792783 _, Thomas, of Sevenoaks, Kent, yeoman 0
5455250 2491490 2491490 defendant Yong Richard gent 792783 792783 Yong, Richard, of Sevenoaks, Kent, gent 0
5464957 2494429 2494429 defendant Garth Thomas gent 792783 792783 (Garth, Thomas, of Sevenoaks, Kent, gent 1
5473764 2497128 2497128 defendant Walker John yeoman 792783 792783 Walker, John, of Sevenoaks, Kent, yeoman 0
5473766 2497128 2497128 defendant Broke Thomas yeoman 792783 792783 Broke, Thomas, of Sevenoaks, Kent, yeoman 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);