names

15 rows where case_id = 2345846

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4963000 2345846 2345846 plaintiff Burton Robert sheriff   Burton, Robert, sheriff 0
4963001 2345846 2345846 defendant Pontyndon John   827974 827974 Pontyndon, John, of Bykelegh, bailiff 0
4963002 2345846 2345846 defendant Prous John   588557 588557 Prous, John, of Tyverton, bailiff 1
4963003 2345846 2345846 defendant Braddon John   593750 593750 Braddon, John, of Baunton, bailiff 2
4963004 2345846 2345846 defendant Hoy or Hercy John   597014 597014 Hoy or Hercy, John, of Bokerell, bailiff 3
4963005 2345846 2345846 defendant Crosse John   724047 724047 Crosse, John, of Brodhembury, bailiff 4
4963006 2345846 2345846 defendant Boway John   784131 784131 Boway, John, of Lodeswyll, bailiff 5
4963007 2345846 2345846 defendant Rogger Walter   587162 587162 Rogger, Walter, of Ermyngton, bailiff 6
4963008 2345846 2345846 defendant Appetorre John   589807 589807 Appetorre, John, of Plymhome, bailiff 7
4963009 2345846 2345846 defendant Chamberleyn John   587395 587395 Chamberleyn, John, of Tavystoke, bailiff 8
4963010 2345846 2345846 defendant Stenteford Richard   587644 587644 Stenteford, Richard, of Whitechurche, bailiff 9
4963011 2345846 2345846 defendant Foldham John   827979 827979 Foldham, John, of Nymetbowe, bailiff 10
4963012 2345846 2345846 defendant Bailly Baldwin   586397 586397 Bailly, Baldwin, of Morton, bailiff 11
4963013 2345846 2345846 defendant Wyke John   784131 784131 Wyke, John, of Lodeswyll, bailiff 12
4963014 2345846 2345846 defendant Hempston William   827980 827980 Hempston, William, of Cantelowe, bailiff 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);