names

17 rows where place_id = 617252

✎ 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
3718575 1932085 1932085 defendant Leche Thomas husbandman 617252 617252 Leche, Thomas, of Breynton, husbandman 5
3883263 1984666 1984666 defendant Nevell John husbandman 617252 617252 Nevell, John, of Breynton, husbandman 0
3883264 1984666 1984666 defendant Duberlowe Henry laborer 617252 617252 Duberlowe, Henry, of Breynton, laborer 1
3952433 2007919 2007919 defendant Leche or Lyche Thomas husbandman 617252 617252 Leche or Lyche, Thomas, of Breynton, husbandman 3
3952434 2007919 2007919 defendant Bullock or Bulyott William husbandman 617252 617252 Bullock or Bulyott, William, of Breynton, husbandman 4
4003912 2026167 2026167 defendant Paradye Abraham yeoman 617252 617252 Paradye, Abraham, of Breynton, yeoman 0
4199806 2095483 2095483 defendant Boothe Charles gent 617252 617252 Boothe, Charles, of Breynton, gent 0
4201370 2096029 2096029 defendant Baggotte James husbandman 617252 617252 Baggotte, James, of Breynton, husbandman 10
4292505 2127383 2127383 defendant Waters James yeoman 617252 617252 Waters, James, of Breynton, yeoman 0
4311757 2134251 2134251 defendant Boothe Charles gent 617252 617252 Boothe, Charles, of Breynton, gent 0
4311844 2134279 2134279 defendant Waters James yeoman 617252 617252 Waters, James, of Breynton, yeoman 0
4523870 2207797 2207797 defendant Bakster Richard   617252 617252 Bakster, Richard, of Breynton 0
4828476 2304947 2304947 defendant Croyne John yeoman 617252 617252 Croyne, John, of Breynton, yeoman 0
5143683 2399286 2399286 defendant Wode James husbandman 617252 617252 Wode, James, of Breynton, husbandman 0
5164825 2405443 2405443 defendant Wode James husbandman 617252 617252 Wode, James, of Breynton, husbandman 0
5178305 2409357 2409357 defendant Wode James husbandman 617252 617252 Wode, James, of Breynton, husbandman 0
5178307 2409358 2409358 defendant Wode James husbandman 617252 617252 Wode, James, of Breynton, husbandman 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);