names

16 rows where place_id = 644512

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3880044 1983584 1983584 defendant Grene John yeoman 644512 644512 Grene, John, of Willesdon, Middx, yeoman 0
4019776 2031804 2031804 defendant Lee Richard yeoman 644512 644512 Lee, Richard, of Willesdon, Middx, yeoman 0
4198829 2095147 2095147 defendant Rawlynson William yeoman 644512 644512 Rawlynson, William, of Willesdon, Middx, yeoman 0
4288956 2126105 2126105 defendant Ciampaney Katherione daughter of Edmund Robert, esq 644512 644512 Katherione his wife, daughter of Edmund Robert, of Willesdon, Middx, esq 1
4690513 2262589 2262589 defendant Robardes John husbandman 644512 644512 Robardes, John, of Willesdon, Middx, husbandman 0
4690515 2262590 2262590 defendant Roberd John husbandman 644512 644512 Roberd, John, of Willesdon, Middx, husbandman 0
4764601 2284914 2284914 defendant Bolde Richard husbandman 644512 644512 Bolde, Richard, of Willesdon, Middx, husbandman 0
5017456 2361995 2361995 defendant Abell Henry husbandman 644512 644512 Abell, Henry, of Willesdon, Middx, husbandman 4
5017469 2361996 2361996 defendant Abell Henry husbandman 644512 644512 Abell, Henry, of Willesdon, Middx, husbandman 4
5018259 2362223 2362223 defendant Lewys Robert laborer 644512 644512 Lewys, Robert, of Willesdon, Middx, laborer 0
5080800 2380749 2380749 defendant Broun William laborer 644512 644512 Broun, William, of Willesdon, Middx, laborer 0
5367969 2465606 2465606 defendant Bynford John husbandman 644512 644512 Bynford, John, of Willesdon, Middx, husbandman 0
5377559 2468564 2468564 defendant Frende George husbandman 644512 644512 Frende, George, of Willesdon, Middx, husbandman 0
5377592 2468576 2468576 defendant Wakerell John husbandman 644512 644512 Wakerell, John, of Willesdon, Middx, husbandman 0
5398592 2474657 2474657 defendant Dynford John husbandman 644512 644512 Dynford, John, of Willesdon, Middx, husbandman 0
5500358 2505051 2505051 defendant Chalkhill Thomas yeoman 644512 644512 Chalkhill, Thomas, of Willesdon, Middx, yeoman 7

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