names

17 rows where place_id = 830016

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4164937 2083243 2083243 defendant Allen Nicholas baker 830016 830016 Allen, Nicholas, of Shypden alias Cromer, baker 1
4164938 2083243 2083243 defendant Newman John   830016 830016 Newman, John, of Shypden alias Cromer, sailor 2
4197359 2094631 2094631 defendant Amys Henry husbandman 830016 830016 Amys, Henry, of Shypden alias Cromer, husbandman 2
4979769 2350904 2350904 defendant Fowlere Roger husbandman 830016 830016 Fowlere, Roger, of Shypden, husbandman 1
5002363 2357599 2357599 defendant Bataly Edmund chaplain 830016 830016 Bataly, Edmund, of Shypden, chaplain 0
5044096 2369860 2369860 defendant Knyght William singleman 830016 830016 Knyght, William, of Shypden, singleman 0
5052621 2372375 2372375 plaintiff Warde William   830016 830016 Warde, William, of Shypden 1
5119662 2392185 2392185 plaintiff Skothowe Roger   830016 830016 Skothowe, Roger, of Shypden 0
5119664 2392185 2392185 defendant Fowler Roger husbandman 830016 830016 Fowler, Roger, of Shypden, husbandman 1
5230929 2424653 2424653 defendant Lente John yeoman 830016 830016 Lente, John, of Shypden alias Crowemer, yeoman 3
5233608 2425419 2425419 defendant Platfote Thomas husbandman 830016 830016 Platfote, Thomas, of Shypden, husbandman 2
5245246 2428764 2428764 defendant Warde William husbandman 830016 830016 Warde, William, of Shypden, husbandman 0
5322132 2451691 2451691 plaintiff Mason John   830016 830016 Mason, John, of Shypden 0
5352390 2460847 2460847 plaintiff Faukener Simon spicer 830016 830016 Faukener, Simon, of Shypden, spicer 0
5352391 2460847 2460847 defendant Mason Agnes widow 830016 830016 Mason, Agnes, of Shypden, widow 0
5422341 2481625 2481625 defendant Hawene Benedict husbandman 830016 830016 Hawene, Benedict, of Shypden, husbandman 0
5472296 2496683 2496683 defendant Gylmyn William husbandman 830016 830016 Gylmyn, William, of Shypden, husbandman 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);