names

23 rows where place_id = 608075

✎ 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
3672063 1917265 1917265 defendant Lyham Robert husbandman 608075 608075 Lyham, Robert, of Badley, husbandman 0
3683873 1921091 1921091 defendant Grene Robert thatcher 608075 608075 Grene, Robert, of Badley, thatcher 2
3709543 1929292 1929292 defendant Leyham or Lexham Robert husbandman 608075 608075 Leyham or Lexham, Robert, of Badley, husbandman 0
3724785 1934037 1934037 defendant Pedyngton Thomas husbandman 608075 608075 Pedyngton, Thomas, of Badley, husbandman 0
3734617 1937074 1937074 defendant Leyham Robert husbandman 608075 608075 Leyham, Robert, of Badley, husbandman 2
3744389 1940145 1940145 defendant Branston alias Leyham William husbandman 608075 608075 Branston alias Leyham, William, of Badley, husbandman 0
3744390 1940145 1940145 defendant Goodale Robert husbandman 608075 608075 Goodale, Robert, of Badley, husbandman 1
3760475 1945280 1945280 defendant Bough John husbandman 608075 608075 Bough, John, of Badley, husbandman 2
3772923 1949231 1949231 defendant Gooddale Robert husbandman 608075 608075 Gooddale, Robert, of Badley, husbandman 0
3772925 1949232 1949232 defendant Gooddale Robert husbandman 608075 608075 Gooddale, Robert, of Badley, husbandman 0
3795543 1956488 1956488 defendant Layham William husbandman 608075 608075 Layham, William, of Badley, husbandman 0
3797857 1957226 1957226 defendant Garneys Elizabeth widow 608075 608075 (Garneys, Elizabeth, of Badley, widow 1
3797858 1957226 1957226 defendant Poley Edmund gent 608075 608075 Poley, Edmund, of Badley, gent 2
3801670 1958417 1958417 defendant Goodale Robert husbandman 608075 608075 Goodale, Robert, of Badley, husbandman 2
3810717 1961252 1961252 defendant Grene Robert laborer 608075 608075 Grene, Robert, of Badley, laborer 0
3831076 1967604 1967604 defendant Godall Robert husbandman 608075 608075 Godall, Robert, of Badley, husbandman 2
3846767 1972541 1972541 defendant Powley Edmund esq 608075 608075 Powley, Edmund, of Badley, esq 2
3932100 2001041 2001041 defendant Gonne John miller 608075 608075 Gonne, John, of Badley, miller 0
3932101 2001041 2001041 defendant Gonne Roger miller 608075 608075 Gonne, Roger, of Badley, miller 1
5291382 2442481 2442481 defendant Lynton John miller 608075 608075 Lynton, John, of Badley, miller 5
5311558 2448480 2448480 defendant Poley Simon gent 608075 608075 Poley, Simon, of Badley, gent 0
5450491 2490031 2490031 defendant W_d Robert husbandman 608075 608075 W_d, Robert, of Badley, husbandman 3
5560762 2523114 2523114 defendant Tonmere John husbandman 608075 608075 Tonmere, John, of Badley, 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);