names

25 rows where place_id = 830418

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4951357 2342387 2342387 defendant atte Assh John   830418 830418 atte Assh, John, of Quapplod, flax chapman 0
4982848 2351783 2351783 defendant Randes Robert husbandman 830418 830418 Randes, Robert, of Quapplod, husbandman 1
4982849 2351783 2351783 defendant Scarleyye John yeoman 830418 830418 Scarleyye, John, of Quapplod, yeoman 2
4982853 2351784 2351784 defendant Spendluffe Thomas husbandman 830418 830418 Spendluffe, Thomas, of Quapplod, husbandman 0
5030967 2365931 2365931 defendant Porwet Robert husbandman 830418 830418 Porwet, Robert, of Quapplod, husbandman 0
5054750 2372997 2372997 defendant Cawod William yeoman 830418 830418 Cawod, William, of Quapplod, yeoman 2
5061832 2375136 2375136 defendant Palfrayman John husbandman 830418 830418 Palfrayman, John, of Quapplod, husbandman 3
5061838 2375138 2375138 defendant Leke John   830418 830418 Leke, John, of Quapplod, flax chapman 2
5061961 2375179 2375179 defendant Cawode William (legal representative) 830418 830418 Cawode, William, of Quapplod, executors of 0
5061968 2375180 2375180 defendant Writh or Wryght Henry husbandman 830418 830418 Writh or Wryght, Henry, of Quapplod, husbandman 0
5073118 2378446 2378446 defendant Akke Simon yeoman 830418 830418 Akke, Simon, of Quapplod, yeoman 0
5093593 2384526 2384526 plaintiff Strotte John, senior   830418 830418 Strotte, John, senior, of Quapplod 1
5093594 2384526 2384526 plaintiff Cawode John   830418 830418 Cawode, John, of Quapplod 2
5093602 2384527 2384527 plaintiff Strotte John, senior   830418 830418 Strotte, John, senior, of Quapplod 1
5093603 2384527 2384527 plaintiff Cawode John   830418 830418 Cawode, John, of Quapplod 2
5137710 2397543 2397543 plaintiff Cooke Robert   830418 830418 Cooke, Robert, of Quapplod 1
5174069 2408115 2408115 plaintiff Pynder John vicar 830418 830418 Pynder John, of Quapplod, vicar 0
5194290 2414061 2414061 plaintiff Cooke Robert   830418 830418 Cooke, Robert, of Quapplod 1
5225406 2423107 2423107 defendant Pynchebek Gilbert gent 830418 830418 Pynchebek, Gilbert, of Quapplod, gent 0
5246434 2429122 2429122 defendant Pynchebek Gilbert gent 830418 830418 Pynchebek, Gilbert, of Quapplod, gent 0
5284941 2440616 2440616 defendant Palfrayman Robert husbandman 830418 830418 Palfrayman, Robert, of Quapplod, husbandman 1
5284942 2440616 2440616 defendant Calowe William husbandman 830418 830418 Calowe, William, of Quapplod, husbandman 2
5284943 2440616 2440616 defendant Porter John flaxman 830418 830418 Porter, John, of Quapplod, flaxman 3
5336596 2456012 2456012 plaintiff Haukyn or Hankyn senior (legal representative) 830418 830418 Haukyn or Hankyn, senior, of Quapplod, executor of 0
5336597 2456012 2456012 plaintiff Haukyn or Hankyn junior   830418 830418 Haukyn or Hankyn, junior, of Quapplod 1

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