names

20 rows where place_id = 614507

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3704039 1927551 1927551 defendant Myllys John chaplain 614507 614507 Myllys, John, of Shuffenhale, chaplain 2
4447389 2184094 2184094 defendant Swayn John   614507 614507 Swayn, John, of Shuffenhale 0
4457864 2187480 2187480 plaintiff Porter John   614507 614507 Porter, John, of Shuffenhale, on his own account 0
4465279 2189810 2189810 defendant Gilles Thomas   614507 614507 Gilles, Thomas, of Shuffenhale 2
4485161 2196060 2196060 defendant Barkare William   614507 614507 Barkare, William, of Shuffenhale 1
4490268 2197654 2197654 defendant Clerk Roger   614507 614507 Clerk, Roger, of Shuffenhale 1
4599467 2231049 2231049 defendant Aston Nicholas   614507 614507 Aston, Nicholas, of Shuffenhale 0
4637782 2242590 2242590 defendant Aston Nicholas   614507 614507 Aston, Nicholas, of Shuffenhale 0
4647952 2245469 2245469 defendant Fethereston William   614507 614507 Fethereston, William, of Shuffenhale 0
4657209 2248139 2248139 defendant Shyngelere Thomas   614507 614507 Shyngelere, Thomas, of Shuffenhale, millward 0
4823203 2303346 2303346 defendant Crowe John   614507 614507 Crowe, John, of Shuffenhale, millward 1
4849879 2311433 2311433 plaintiff Styward John   614507 614507 Styward, John, of Shuffenhale 0
5182160 2410535 2410535 defendant Donne or Doune Edmund fishmonger 614507 614507 Donne or Doune, Edmund, of Shuffenhale, fishmonger 0
5182161 2410535 2410535 defendant Baker Thomas shoemaker 614507 614507 Baker, Thomas, of Shuffenhale, shoemaker 1
5182162 2410535 2410535 defendant Loyd Thomas tailor 614507 614507 Loyd, Thomas, of Shuffenhale, tailor 2
5182163 2410535 2410535 defendant Taillour Thomas shoemaker 614507 614507 Taillour, Thomas, of Shuffenhale, shoemaker 3
5270214 2436387 2436387 defendant Jenkys John tanner 614507 614507 Jenkys, John, of Shuffenhale, tanner 0
5614008 2548154 2548154 defendant Eweye John   614507 614507 Eweye, John, of Shuffenhale 0
5614287 2548253 2548253 defendant Swayne John   614507 614507 Swayne, John, of Shuffenhale 0
5633238 2554402 2554402 plaintiff Tallour William   614507 614507 Tallour, William, of Shuffenhale 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);