names

14 rows where case_id = 2439052

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5279352 2439052 2439052 plaintiff Brampton Thomas     Brampton, Thomas 0
5279353 2439052 2439052 defendant Basset Roger merchant 585933 585933 Basset, Roger, of Great Yarmouth, merchant 0
5279354 2439052 2439052 defendant Brunston or Brimston Gregory husbandman 588926 588926 Brunston or Brimston, Gregory, of North Elmham, husbandman 1
5279355 2439052 2439052 defendant Yareham John carpenter 608291 608291 Yareham, John, of Hilderston, carpenter 2
5279356 2439052 2439052 defendant Walter Richard butcher 586365 586365 Walter, Richard, of Wymondham, butcher 3
5279357 2439052 2439052 defendant Neyton John husbandman 588845 588845 Neyton, John, of Grymston, husbandman 4
5279358 2439052 2439052 defendant Whytgowne William husbandman 588926 588926 Whytgowne, William, of North Elmham, husbandman 5
5279359 2439052 2439052 defendant Broun Walter husbandman 588849 588849 Broun, Walter, of North Tudenham, husbandman 6
5279360 2439052 2439052 defendant Roo William yeoman 591892 591892 Roo, William, of Brysle, yeoman 7
5279361 2439052 2439052 defendant Hawe Richard yeoman 588926 588926 Hawe, Richard, of North Elmham, yeoman 8
5279362 2439052 2439052 defendant Broun Thomas husbandman 588926 588926 Broun, Thomas, of North Elmham, husbandman 9
5279363 2439052 2439052 defendant Dyce or Dyte William husbandman 588926 588926 Dyce or Dyte, William, of North Elmham, husbandman 10
5279364 2439052 2439052 defendant Fox Simon husbandman 588926 588926 Fox, Simon, of North Elmham, husbandman 11
5279365 2439052 2439052 defendant Dyte John husbandman 588926 588926 Dyte, John, of North Elmham, husbandman 12

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