names

12 rows where place_id = 615246

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3707899 1928767 1928767 defendant Longe William yeoman 615246 615246 Longe, William, of Canterbury St Martin, yeoman 1
3742671 1939578 1939578 defendant Sawson John yeoman 615246 615246 Sawson, John, of Canterbury St Martin, yeoman 1
3805762 1959746 1959746 defendant Fynche William   615246 615246 Fynche, William, of Canterbury St Martin, knight 0
3816326 1963014 1963014 defendant Fynche William   615246 615246 Fynche, William, of Canterbury St Martin, knight 0
3993531 2022432 2022432 plaintiff Furner or Furver Francis cordwainer 615246 615246 Furner or Furver, Francis, of Canterbury St Martin, cordwainer 1
4281602 2123472 2123472 defendant Cooke alias Austyn Margaret widow 615246 615246 Cooke alias Austyn, Margaret, of Canterbury St Martin, widow 0
4320254 2137186 2137186 defendant Cooke alias Austeyne Margaret widow 615246 615246 Cooke alias Austeyne, Margaret, of Canterbury St Martin, widow 0
4935678 2337546 2337546 defendant Fairhand Robert husbandman 615246 615246 Fairhand, Robert, of Canterbury St Martin, husbandman 0
4944222 2340164 2340164 defendant Neweman John   615246 615246 Neweman, John, of Canterbury St Martin, cook 1
4961053 2345267 2345267 defendant Fairehand Robert husbandman 615246 615246 Fairehand, Robert, of Canterbury St Martin, husbandman 1
5219132 2421322 2421322 plaintiff Hardys John (legal representative) 615246 615246 Hardys, John, of Canterbury St Martin, executors of 0
5500229 2505019 2505019 plaintiff Roper alias Bochard William (legal representative) 615246 615246 Roper alias Bochard, William, of Canterbury St Martin, executors of 0

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