names

20 rows where place_id = 606290

✎ 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
3664717 1914917 1914917 defendant at Naysshe Stephen yeoman 606290 606290 at Naysshe, Stephen, of Ealdyng or Yalding, yeoman 0
4471843 2191857 2191857 defendant Brounyngbery John   606290 606290 Brounyngbery, John, of Ealdyng or Yalding 0
4722194 2272266 2272266 defendant Swychefeld John yeoman 606290 606290 Swychefeld, John, of Ealdyng or Yalding, yeoman 0
4722448 2272340 2272340 defendant Swychefeld John husbandman 606290 606290 Swychefeld, John, of Ealdyng or Yalding, husbandman 0
4821578 2302831 2302831 plaintiff Ryng John, senior (legal representative) 606290 606290 Ryng, John, senior, of Ealdyng or Yalding, executor of 0
4834413 2306771 2306771 defendant Orgare John husbandman 606290 606290 Orgare, John, of Ealdyng or Yalding, husbandman 0
4920678 2332983 2332983 defendant Harbelot John, senior husbandman 606290 606290 Harbelot, John, senior, of Ealdyng or Yalding, husbandman 0
4924762 2334180 2334180 plaintiff Orgar John   606290 606290 Orgar, John, of Ealdyng or Yalding, son of Thomas Orgar 0
5125170 2393839 2393839 defendant Kene Robert smith 606290 606290 Kene, Robert, of Ealdyng or Yalding, smith 0
5127848 2394622 2394622 defendant Myles Robert   606290 606290 Myles, Robert, of Ealdyng or Yalding 0
5201432 2416176 2416176 defendant Kene Robert smith 606290 606290 Kene, Robert, of Ealdyng or Yalding, smith 0
5201434 2416177 2416177 defendant Kene Robert smith 606290 606290 Kene, Robert, of Ealdyng or Yalding, smith 0
5267917 2435729 2435729 defendant Cherleswound John husbandman 606290 606290 Cherleswound, John, of Ealdyng or Yalding, husbandman 0
5401404 2475467 2475467 defendant Jope John yeoman 606290 606290 Jope, John, of Ealdyng or Yalding, yeoman 0
5413847 2479065 2479065 defendant Sharstede Thomas butcher 606290 606290 Sharstede, Thomas, of Ealdyng or Yalding, butcher 2
5441511 2487383 2487383 defendant Gybbys Martin husbandman 606290 606290 Gybbys, Martin, of Ealdyng or Yalding, husbandman 1
5476758 2498050 2498050 defendant Oswester Morris husbandman 606290 606290 (Oswester, Morris, of Ealdyng or Yalding, husbandman 2
5608766 2537641 2537641 defendant Jope John husbandman 606290 606290 Jope, John, of Ealdyng or Yalding, husbandman 0
5609354 2537825 2537825 defendant Eggar William yeoman 606290 606290 Eggar, William, of Ealdyng or Yalding, yeoman 0
5619805 2550059 2550059 defendant Prekfeld Robert   606290 606290 Prekfeld, Robert, of Ealdyng or Yalding 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);