names

13 rows where case_id = 2441856

✎ 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
5289236 2441856 2441856 plaintiff Markeby John     Markeby, John 0
5289237 2441856 2441856 defendant Cumberton Thomas tailor 756561 756561 Cumberton, Thomas, of Partenay, tailor 0
5289238 2441856 2441856 defendant Brigge William butcher 756561 756561 Brigge, William, of Partenay, butcher 1
5289239 2441856 2441856 defendant Joce William barker 589224 589224 Joce, William, of Dalby, barker 2
5289240 2441856 2441856 defendant Barugh William husbandman 869097 869097 Barugh, William, of Munkthorp, husbandman 3
5289241 2441856 2441856 defendant Canthorn or Cauthorn Thomas yeoman 602593 602593 Canthorn or Cauthorn, Thomas, of Hellowe, yeoman 4
5289242 2441856 2441856 defendant Flete Thomas butcher 598803 598803 Flete, Thomas, of Alford, butcher 5
5289243 2441856 2441856 defendant Freshmare John husbandman 592848 592848 Freshmare, John, of Hotoft, husbandman 6
5289244 2441856 2441856 defendant Arker John mercer 592312 592312 Arker, John, of Saltflethaven, mercer 7
5289245 2441856 2441856 defendant Fermary Thomas husbandman 609585 609585 Fermary, Thomas, of Halton juxta Spyllesby, husbandman 8
5289246 2441856 2441856 defendant Dalby Richard husbandman 590658 590658 togehter with Dalby, Richard, of Parteney, husbandman 9
5289247 2441856 2441856 defendant Warde John husbandman 655030 655030 Warde, John, of Skendilby, husbandman 10
5289248 2441856 2441856 defendant Rose John husbandman 590184 590184 Rose, John, of Stepyng, husbandman 11

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