names

16 rows where case_id = 2330000

✎ 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
4911145 2330000 2330000 plaintiff Brese Robert     Brese, Robert, on his own account 0
4911146 2330000 2330000 defendant Whippe Thomas yeoman 596764 596764 Whippe, Thomas, of Rysyng, yeoman 0
4911147 2330000 2330000 defendant Bernewell John laborer 611062 611062 Bernewell, John, of Craneworth, laborer 1
4911148 2330000 2330000 defendant Nicoll John laborer 611062 611062 with Nicoll, John, of Craneworth, laborer 2
4911149 2330000 2330000 defendant Alman William yeoman 611062 611062 Alman, William, of Craneworth, yeoman 3
4911150 2330000 2330000 defendant Cokell Henry clerk 820700 820700 Cokell, Henry, of Bernhame Breme, clerk 4
4911151 2330000 2330000 defendant Colet Nicholas husbandman 585936 585936 Colet, Nicholas, of Norwich, husbandman 5
4911152 2330000 2330000 defendant Dale John reeder 585936 585936 Dale, John, of Norwich, reeder 6
4911153 2330000 2330000 defendant Fouldon Ralph clerk 802763 802763 Fouldon, Ralph, of Brunham Ulp, clerk 7
4911154 2330000 2330000 defendant Kyllyngworth Joce yeoman 682064 682064 Kyllyngworth, Joce, of Wetherden, Suff, yeoman 8
4911155 2330000 2330000 defendant Ravele John butcher 585936 585936 Ravele, John, of Norwich, butcher 9
4911156 2330000 2330000 defendant Bonnys John smith 820701 820701 Bonnys, John, of Irmyngton, smith 10
4911157 2330000 2330000 defendant Haliday Richard clerk 820702 820702 Haliday, Richard, of Ederyngham, clerk 11
4911158 2330000 2330000 defendant Hagh Robert yeoman 820703 820703 Hagh, Robert, of Branodn, by Bernham, Norf, yeoman 12
4911159 2330000 2330000 defendant Pese William sonmer 593923 593923 Pese, William, of Saxthorp, sonmer 13
4911160 2330000 2330000 defendant Hervy Thomas clerk 592559 592559 with Hervy, Thomas, of Testerton, clerk 14

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