names

18 rows where case_id = 2341940

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4949847 2341940 2341940 plaintiff Norwych William     Norwych, William 0
4949848 2341940 2341940 defendant Hare John parson of Saxlyngham   Hare, John, parson of Saxlyngham 0
4949849 2341940 2341940 defendant Hamund Richard husbandman 651021 651021 Hamund, Richard, of Morley juxta Attylburgh, husbandman 1
4949850 2341940 2341940 defendant Wode John, junior husbandman 598445 598445 Wode, John, junior, of Tyteshale, husbandman 2
4949851 2341940 2341940 defendant Purches Richard spicer 587418 587418 Purches, Richard, of Dysse, spicer 3
4949852 2341940 2341940 defendant Belsted John chapman 624981 624981 Belsted, John, of Mulberton, chapman 4
4949853 2341940 2341940 defendant Dowe John, senior butcher 771530 771530 Dowe, John, senior, of Wykylwode, butcher 5
4949854 2341940 2341940 defendant Heed Thomas yeoman 608645 608645 Heed, Thomas, of Dekylburgh, yeoman 6
4949855 2341940 2341940 defendant Hore Edmund carpenter 587418 587418 Hore, Edmund, of Dysse, carpenter 7
4949856 2341940 2341940 defendant Underwode Thomas thatcher 597969 597969 Underwode, Thomas, of Thurgarton, thatcher 8
4949857 2341940 2341940 defendant Buskard Walter husbandman 615362 615362 Buskard, Walter, of Disse, husbandman 9
4949858 2341940 2341940 defendant Lowedale John yeoman 587418 587418 Lowedale, John, of Dysse, yeoman 10
4949859 2341940 2341940 defendant Turnour Roger husbandman 590846 590846 Turnour, Roger, of Shipdam, husbandman 11
4949860 2341940 2341940 defendant Martynes Geoffrey husbandman 593923 593923 Martynes, Geoffrey, of Saxthorp, husbandman 12
4949861 2341940 2341940 defendant Smyth William husbandman 593923 593923 Smyth, William, of Saxthorp, husbandman 13
4949862 2341940 2341940 defendant Hemmyng Geoffrey chapman 585933 585933 Hemmyng, Geoffrey, of Great Yarmouth, chapman 14
4949863 2341940 2341940 defendant Ede William husbandman 826299 826299 Ede, William, of Morley juxta Attulburgh, husbandman 15
4949864 2341940 2341940 defendant Ponyant or Povyant William husbandman 586471 586471 Ponyant or Povyant, William, of Aylesham, husbandman 16

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