names

29 rows where place_id = 601520

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3645709 1909061 1909061 defendant Gybbys Thomas husbandman 601520 601520 Gybbys, Thomas, of Beerton, husbandman 1
3674949 1918194 1918194 defendant Gybbys Thomas husbandman 601520 601520 Gybbys, Thomas, of Beerton, husbandman 0
3677235 1918926 1918926 defendant Smyth John husbandman 601520 601520 Smyth, John, of Beerton, husbandman 0
3711597 1929936 1929936 defendant Olyff or Clyff Thomas husbandman 601520 601520 Olyff or Clyff, Thomas, of Beerton, husbandman 0
3711598 1929936 1929936 defendant Olyff or Clyff Walter husbandman 601520 601520 Olyff or Clyff, Walter, of Beerton, husbandman 1
3743638 1939886 1939886 defendant Clyff Walter husbandman 601520 601520 Clyff, Walter, of Beerton, husbandman 1
3743639 1939886 1939886 defendant Clyff Robert husbandman 601520 601520 Clyff, Robert, of Beerton, husbandman 2
3743641 1939887 1939887 defendant Olyff or Clyff Walter husbandman 601520 601520 Olyff or Clyff, Walter, of Beerton, husbandman 0
3743642 1939887 1939887 defendant Olyff or Clyff Robert husbandman 601520 601520 Olyff or Clyff, Robert, of Beerton, husbandman 1
3748786 1941555 1941555 defendant Bekke John husbandman 601520 601520 Bekke, John, of Beerton, husbandman 0
3748787 1941555 1941555 defendant Olyff Robert husbandman 601520 601520 Olyff, Robert, of Beerton, husbandman 1
3748788 1941555 1941555 defendant Olyff Richard husbandman 601520 601520 Olyff, Richard, of Beerton, husbandman 2
3748789 1941555 1941555 defendant Nawger Henry husbandman 601520 601520 Nawger, Henry, of Beerton, husbandman 3
3755600 1943709 1943709 defendant Olyff Walter husbandman 601520 601520 Olyff, Walter, of Beerton, husbandman 0
3755601 1943709 1943709 defendant Olyff Robert husbandman 601520 601520 Olyff, Robert, of Beerton, husbandman 1
3901760 1990811 1990811 defendant Wyatt Richard husbandman 601520 601520 Wyatt, Richard, of Beerton, husbandman 3
4125695 2069472 2069472 defendant Hardyng Isabel widow 601520 601520 Hardyng, Isabel, of Beerton, widow 0
4125696 2069472 2069472 defendant Hardyng Henry husbandman 601520 601520 Hardyng, Henry, of Beerton, husbandman 1
4199738 2095455 2095455 defendant Howse John husbandman 601520 601520 Howse, John, of Beerton, husbandman 0
4663522 2250067 2250067 defendant Shayle John   601520 601520 Shayle, John, of Beerton, holy water clerk 0
4663524 2250068 2250068 defendant Shayle John   601520 601520 Shayle, John, of Beerton, holy water clerk 0
4944637 2340305 2340305 defendant Clerk John husbandman 601520 601520 Clerk, John, of Beerton, husbandman 0
4970040 2347989 2347989 defendant Balky Guy husbandman 601520 601520 Balky, Guy, of Beerton, husbandman 0
4970041 2347989 2347989 defendant Phelpot Thomas husbandman 601520 601520 Phelpot, Thomas, of Beerton, husbandman 1
4970042 2347989 2347989 defendant Graunt Thomas husbandman 601520 601520 Graunt, Thomas, of Beerton, husbandman 2
4970050 2347990 2347990 defendant Balky Guy husbandman 601520 601520 together with Balky, Guy, of Beerton, husbandman 2
4970051 2347990 2347990 defendant Phelpot Thomas husbandman 601520 601520 Phelpot, Thomas, of Beerton, husbandman 3
4970052 2347990 2347990 defendant Graunt Thomas husbandman 601520 601520 Graunt, Thomas, of Beerton, husbandman 4
5039128 2368349 2368349 defendant Mille William fuller 601520 601520 Mille, William, of Beerton, fuller 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);