names

20 rows where place_id = 596890

✎ 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
3626534 1903150 1903150 defendant Potter William husbandman 596890 596890 Potter, William, of White Colne, husbandman 2
3645647 1909038 1909038 defendant Potyer William husbandman 596890 596890 Potyer, William, of White Colne, husbandman 0
3718738 1932139 1932139 defendant Wyndwyll Robert husbandman 596890 596890 Wyndwyll, Robert, of White Colne, husbandman 0
4341263 2144217 2144217 defendant Stevens Francis yeoman 596890 596890 Stevens, Francis, of White Colne, yeoman 0
4341264 2144217 2144217 defendant Smyth Thomas yeoman 596890 596890 Smyth, Thomas, of White Colne, yeoman 1
4485730 2196244 2196244 defendant Soneker or Soveld Thomas   596890 596890 Soneker or Soveld, Thomas, of White Colne 0
4487555 2196825 2196825 defendant Bagerukke John   596890 596890 with Bagerukke, John, of White Colne 1
4666249 2250915 2250915 defendant Harwell Thomas clerk 596890 596890 Harwell, Thomas, of White Colne, clerk 0
4884395 2322021 2322021 defendant Tue Elizabeth widow 596890 596890 (Tue, Elizabeth, of White Colne, widow 1
4884396 2322021 2322021 defendant Tue Roger gent 596890 596890 Tue, Roger, of White Colne, gent 2
4915050 2331211 2331211 defendant Ingesthorp John gent 596890 596890 Ingesthorp, John, of White Colne, gent 0
5016120 2361595 2361595 defendant Laname John gent 596890 596890 Laname, John, of White Colne, gent 0
5016122 2361596 2361596 defendant Laname John gent 596890 596890 Laname, John, of White Colne, gent 0
5264705 2434718 2434718 defendant Potere John husbandman 596890 596890 Potere, John, of White Colne, husbandman 5
5323191 2452016 2452016 defendant Inglysthorpe William gent 596890 596890 Inglysthorpe, William, of White Colne, gent 0
5323193 2452017 2452017 defendant Inglysthorpe William gent 596890 596890 Inglysthorpe, William, of White Colne, gent 0
5573008 2526656 2526656 defendant Potter William yeoman 596890 596890 Potter, William, of White Colne, yeoman 0
5582424 2529574 2529574 defendant Potter William yeoman 596890 596890 Potter, William, of White Colne, yeoman 0
5607240 2537152 2537152 defendant Potyer William husbandman 596890 596890 Potyer, William, of White Colne, husbandman 1
5607259 2537159 2537159 defendant Potyre William husbandman 596890 596890 Potyre, William, of White Colne, 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);