names

36 rows where place_id = 586641

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589281 1864288 1864288 plaintiff Bryan Robert   586641 586641 Bryan, Robert, of Aketon 0
3595954 1866365 1866365 plaintiff Neweman John husbandman 586641 586641 Neweman, John, of Aketon, husbandman 0
3595955 1866365 1866365 plaintiff Bryan Robert husbandman 586641 586641 Bryan, Robert, of Aketon, husbandman 1
3595956 1866365 1866365 defendant Sake John husbandman 586641 586641 Sake, John, of Aketon, husbandman 0
3602074 1868310 1868310 defendant Beyn John husbandman 586641 586641 Beyn, John, of Aketon, husbandman 3
3724641 1933988 1933988 defendant Hayward William husbandman 586641 586641 Hayward, William, of Aketon, husbandman 0
3724642 1933988 1933988 defendant Danson Richard husbandman 586641 586641 Danson, Richard, of Aketon, husbandman 1
3740290 1938827 1938827 defendant Heyward William husbandman 586641 586641 Heyward, William, of Aketon, husbandman 0
3740291 1938827 1938827 defendant Danson or Dauson Richard husbandman 586641 586641 Danson or Dauson, Richard, of Aketon, husbandman 1
3752675 1942765 1942765 defendant Heyward William husbandman 586641 586641 Heyward, William, of Aketon, husbandman 0
3752676 1942765 1942765 defendant Danson Richard husbandman 586641 586641 Danson, Richard, of Aketon, husbandman 1
4508074 2202997 2202997 plaintiff Wysman John   586641 586641 Wysman, John, of Aketon 0
4598214 2230680 2230680 defendant Griffyn John   586641 586641 Griffyn, John, of Aketon 3
4726947 2273694 2273694 defendant Mounke Peter husbandman 586641 586641 Mounke, Peter, of Aketon, husbandman 0
4759591 2283343 2283343 plaintiff Clerbek John   586641 586641 Clerbek, John, of Aketon 0
4762380 2284217 2284217 defendant Rokewode William (legal representative) 586641 586641 Rokewode, William, of Aketon, executors of 0
4762381 2284217 2284217 defendant Rookwode Agnes widow 586641 586641 (Rookwode, Agnes, of Aketon, widow 1
4795688 2294805 2294805 plaintiff Rokewode William, senior (legal representative) 586641 586641 Rokewode, William, senior, of Aketon, esq, executors of 0
4795697 2294806 2294806 plaintiff Rokewode William, senior (legal representative) 586641 586641 Rokewode, William, senior, of Aketon, esq, executors of 0
4843490 2309483 2309483 defendant Wareyn William husbandman 586641 586641 Wareyn, William, of Aketon, husbandman 0
4843491 2309483 2309483 defendant Long John, sen husbandman 586641 586641 Long, John, sen, of Aketon, husbandman 1
4865195 2316090 2316090 defendant Clerbek Thomas husbandman 586641 586641 Clerbek, Thomas, of Aketon, husbandman 1
4891888 2324196 2324196 defendant Spynk William husbandman 586641 586641 Spynk, William, of Aketon, husbandman 0
4896819 2325662 2325662 defendant Deye John fuller 586641 586641 Deye, John, of Aketon, fuller 1
4904643 2328061 2328061 defendant Cok Simon husbandman 586641 586641 Cok, Simon, of Aketon, husbandman 0
4909043 2329370 2329370 defendant Stokes William husbandman 586641 586641 Stokes, William, of Aketon, husbandman 0
4909044 2329370 2329370 defendant Parmanter Thomas husbandman 586641 586641 Parmanter, Thomas, of Aketon, husbandman 1
4913344 2330670 2330670 defendant Deye Robert butcher 586641 586641 Deye, Robert, of Aketon, butcher 8
4932815 2336650 2336650 defendant Stoke William laborer 586641 586641 Stoke, William, of Aketon, laborer 2
4974294 2349276 2349276 defendant Pirleston Walter yeoman 586641 586641 Pirleston, Walter, of Aketon, yeoman 0
4988233 2353450 2353450 defendant Pellican John husbandman 586641 586641 Pellican, John, of Aketon, husbandman 2
4998123 2356302 2356302 defendant Deye Robert butcher 586641 586641 Deye, Robert, of Aketon, butcher 0
5003202 2357837 2357837 defendant Tounende John laborer 586641 586641 Tounende, John, of Aketon, laborer 3
5296642 2444004 2444004 defendant Hobyngbryg Richard husbandman 586641 586641 Hobyngbryg, Richard, of Aketon, husbandman 0
5575204 2527333 2527333 defendant Goldyng William husbandman 586641 586641 Goldyng, William, of Aketon, husbandman 0
5629864 2553343 2553343 defendant Tilere William ploughman 586641 586641 Tilere, William, of Aketon, ploughman 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);