names

22 rows where place_id = 615127

✎ 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
3707292 1928570 1928570 defendant Edward Robert husbandman 615127 615127 Edward, Robert, of Warnham, husbandman 0
3707293 1928570 1928570 defendant Tochenor Richard husbandman 615127 615127 Tochenor, Richard, of Warnham, husbandman 1
3801046 1958242 1958242 defendant Busse William husbandman 615127 615127 Busse, William, of Warnham, husbandman 0
3816291 1963002 1963002 defendant Weller William husbandman 615127 615127 Weller, William, of Warnham, husbandman 0
4138373 2074089 2074089 defendant Mychell John gent 615127 615127 Mychell, John, of Warnham, gent 0
4320950 2137424 2137424 defendant Pylfolde Henry yeoman 615127 615127 Pylfolde, Henry, of Warnham, yeoman 0
4321527 2137620 2137620 defendant Pylfolde Henry yeoman 615127 615127 Pylfolde, Henry, of Warnham, yeoman 0
4361917 2151420 2151420 defendant Edward Thomas yeoman 615127 615127 Edward, Thomas, of Warnham, yeoman 0
4419050 2170823 2170823 plaintiff atte Felde Richard   615127 615127 atte Felde, Richard, of Warnham 0
4509538 2203454 2203454 defendant atte Sonde John   615127 615127 atte Sonde, John, of Warnham 0
4509540 2203455 2203455 defendant atte Sonde John   615127 615127 atte Sonde, John, of Warnham 0
4553075 2216904 2216904 defendant Serych William   615127 615127 Serych, William, of Warnham 1
4553076 2216904 2216904 defendant Serych Thomas   615127 615127 Serych, Thomas, of Warnham 2
4614625 2235583 2235583 defendant White John   615127 615127 White, John, of Warnham 1
4874486 2318965 2318965 plaintiff Randolf John   615127 615127 Randolf, John, of Warnham 0
4874488 2318966 2318966 plaintiff Randolf John   615127 615127 Randolf, John, of Warnham 0
4968310 2347483 2347483 defendant Clouser William   615127 615127 Clouser, William, of Warnham 0
5237318 2426498 2426498 defendant Roser John husbandman 615127 615127 Roser, John, of Warnham, husbandman 0
5535767 2515695 2515695 defendant Weller John   615127 615127 Weller, John, of Warnham 0
5560036 2522890 2522890 defendant Polyng Thomas yeoman 615127 615127 Polyng, Thomas, of Warnham, yeoman 0
5597644 2534159 2534159 defendant Busse William husbandman 615127 615127 Busse, William, of Warnham, husbandman 0
5623026 2551137 2551137 defendant Fyst Walter   615127 615127 Fyst, Walter, of Warnham 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);