names

20 rows where place_id = 760122

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4467248 2190430 2190430 defendant Lyfffe Robert   760122 760122 Lyfffe, Robert, of Bromle 0
4525087 2208189 2208189 defendant Sadeler John   760122 760122 Sadeler, John, of Bromle 0
4535357 2211329 2211329 defendant Steor Peter   760122 760122 Steor, Peter, of Bromle 0
4535358 2211329 2211329 defendant Steor Alice   760122 760122 Steor, Alice, of Bromle 1
4608483 2233761 2233761 defendant Bolesdon John   760122 760122 Bolesdon, John, of Bromle 0
4626719 2239299 2239299 defendant Gamone Thomas   760122 760122 Gamone, Thomas, of Bromle 0
4641643 2243657 2243657 defendant Alverad Thomas   760122 760122 Alverad, Thomas, of Bromle 0
4667515 2255560 2255560 defendant de la Rever Thomas   760122 760122 de la Rever, Thomas, of Bromle, gent, formerly of Bekenham 1
4753445 2281454 2281454 defendant Cook Richard panyer maker 760122 760122 Cook, Richard, of Bromle, panyer maker 3
4788547 2292479 2292479 defendant Cosyn Richard   760122 760122 Cosyn, Richard, of Bromle chapman 0
4870768 2317837 2317837 defendant Kember Roger weaver 760122 760122 Kember, Roger, of Bromle, weaver 0
4884194 2321964 2321964 defendant Pratte Henry   760122 760122 Pratte, Henry, of Bromle, servant 2
4944820 2340368 2340368 defendant Dene John victualer 760122 760122 Dene, John, of Bromle, victualer 0
5053221 2372565 2372565 defendant Adams John husbandman 760122 760122 Adams, John, of Bromle, husbandman 0
5368396 2465731 2465731 plaintiff Curteys Alexander (legal representative) 760122 760122 Curteys, Alexander, of Bromle, butcher, executors of 0
5368420 2465737 2465737 plaintiff Curtyes Alexander (legal representative) 760122 760122 Curtyes, Alexander, of Bromle, butcher, executor of 0
5403463 2476062 2476062 defendant Polbroke Thomas laborer 760122 760122 Polbroke, Thomas, of Bromle, laborer 0
5501465 2505392 2505392 defendant Wygge William yeoman 760122 760122 Wygge, William, of Bromle, yeoman 2
5558356 2522394 2522394 defendant Hawekyn John husbandman 760122 760122 Hawekyn, John, of Bromle, husbandman 1
5558357 2522394 2522394 defendant Blok John husbandman 760122 760122 Blok, John, of Bromle, husbandman 2

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