names

15 rows where case_id = 2326979

✎ 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
4901155 2326979 2326979 plaintiff Norwich William     Norwich, William 0
4901156 2326979 2326979 defendant Gynne John husbandman 601983 601983 Gynne, John, of Flordon, husbandman 0
4901157 2326979 2326979 defendant Torald Robert husbandman 601983 601983 Torald, Robert, of Flordon, husbandman 1
4901158 2326979 2326979 defendant Groom John husbandman 618854 618854 Groom, John, of Salthous, husbandman 2
4901159 2326979 2326979 defendant Clerk Alan husbandman 586346 586346 Clerk, Alan, of Langham, husbandman 3
4901160 2326979 2326979 defendant Belsted Thomas husbandman 624981 624981 Belsted, Thomas, of Mulberton, husbandman 4
4901161 2326979 2326979 defendant Here John husbandman 588520 588520 Here, John, of Fylby, husbandman 5
4901162 2326979 2326979 defendant Kyrgate John husbandman 590740 590740 Kyrgate, John, of Rollesby, husbandman 6
4901163 2326979 2326979 defendant Couper Thomas yeoman 588486 588486 Couper, Thomas, of Wynterton, yeoman 7
4901164 2326979 2326979 defendant Fuller Nicholas husbandman 588239 588239 Fuller, Nicholas, of Yelverton, husbandman 8
4901165 2326979 2326979 defendant Hervy John husbandman 598726 598726 Hervy, John, of Wortham, Suff, husbandman 9
4901166 2326979 2326979 defendant Smyth Andrew smith 587387 587387 Smyth, Andrew, of Boton, smith 10
4901167 2326979 2326979 defendant Tytelove Richard husbandman 594961 594961 Tytelove, Richard, of Tunstale, husbandman 11
4901168 2326979 2326979 defendant Roy John butcher 586365 586365 Roy, John, of Wymondham, butcher 12
4901169 2326979 2326979 defendant Colman John husbandman 587414 587414 Colman, John, of Thetford, husbandman 13

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