names

39 rows where place_id = 649599

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3907533 1992815 1992815 defendant Martyn Thomas husbandman 649599 649599 Martyn, Thomas, of Fryskenay, husbandman 0
4472383 2192032 2192032 defendant Raunce John   649599 649599 Raunce, John, of Fryskenay 0
4585607 2226923 2226923 plaintiff Michell William   649599 649599 Michell, William, of Fryskenay 1
4598996 2230909 2230909 defendant Randeson John   649599 649599 Randeson, John, of Fryskenay 2
4647654 2245369 2245369 plaintiff Skynner John   649599 649599 Skynner, John, of Fryskenay 0
4680642 2259558 2259558 plaintiff Kyme John   649599 649599 Kyme, John, of Fryskenay 1
4741223 2277932 2277932 defendant Gylyot Simon husbandman 649599 649599 Gylyot, Simon, of Fryskenay, husbandman 0
4761694 2284002 2284002 plaintiff Kyme John   649599 649599 Kyme, John, of Fryskenay 1
4761699 2284003 2284003 plaintiff Kyme John   649599 649599 Kyme, John, of Fryskenay 1
4841489 2308869 2308869 plaintiff Keme John   649599 649599 Keme, John, of Fryskenay 0
4841810 2308972 2308972 plaintiff Kyme John   649599 649599 Kyme, John, of Fryskenay 0
4841812 2308972 2308972 plaintiff Edwarde Richard   649599 649599 Edwarde, Richard, of Fryskenay 2
4851496 2311909 2311909 defendant Busshe Thomas husbandman 649599 649599 Busshe, Thomas, of Fryskenay, husbandman 2
4863538 2315566 2315566 plaintiff Edworth Richard   649599 649599 Edworth, Richard, of Fryskenay 0
4863539 2315566 2315566 plaintiff Ranyne or Ravyne William   649599 649599 Ranyne or Ravyne, William, of Fryskenay 1
4869165 2317335 2317335 plaintiff Kyme John   649599 649599 Kyme, John, of Fryskenay 0
4869167 2317336 2317336 plaintiff Kyme John   649599 649599 Kyme, John, of Fryskenay 0
4912940 2330545 2330545 defendant Edward Richard yeoman 649599 649599 Edward, Richard, of Fryskenay, yeoman 0
4918845 2332406 2332406 defendant Pereson John yeoman 649599 649599 Pereson, John, of Fryskenay, yeoman 0
4918846 2332406 2332406 defendant Coweper John husbandman 649599 649599 Coweper, John, of Fryskenay, husbandman 1
4921402 2333204 2333204 defendant Gaworth Richard yeoman 649599 649599 Gaworth, Richard, of Fryskenay, yeoman 0
4921403 2333204 2333204 defendant Pererson Thomas yeoman 649599 649599 Pererson Thomas, of Fryskenay, yeoman 1
4998853 2356539 2356539 defendant Randson Richard husbandman 649599 649599 Randson, Richard, of Fryskenay, husbandman 7
5057818 2373909 2373909 defendant Ranson or Rauson Richard husbandman 649599 649599 Ranson or Rauson, Richard, of Fryskenay, husbandman 0
5107800 2388714 2388714 plaintiff Dymmok John   649599 649599 Dymmok, John, of Fryskenay 0
5119967 2392277 2392277 defendant Smyth Randolph husbandman 649599 649599 Smyth, Randolph, of Fryskenay, husbandman 0
5119968 2392277 2392277 defendant Hode William husbandman 649599 649599 Hode, William, of Fryskenay, husbandman 1
5119969 2392277 2392277 defendant Randson Richard husbandman 649599 649599 Randson, Richard, of Fryskenay, husbandman 2
5129438 2395096 2395096 defendant Bold- John butcher 649599 649599 Bold-, John, of Fryskenay, butcher 1
5130187 2395314 2395314 plaintiff Dymmok John esq 649599 649599 Dymmok, John, of Fryskenay, esq 1
5130191 2395315 2395315 plaintiff Dymmok John esq 649599 649599 Dymmok, John, of Fryskenay, esq 2
5140119 2398208 2398208 defendant Dandyson or Daudyson John fisher 649599 649599 Dandyson or Daudyson, John, of Fryskenay, fisher 0
5148736 2400753 2400753 defendant Bole John butcher 649599 649599 Bole, John, of Fryskenay, butcher 1
5161157 2404362 2404362 defendant Daudyson John fishmonger 649599 649599 Daudyson, John, of Fryskenay, fishmonger 0
5167935 2406331 2406331 defendant Bold John butcher 649599 649599 Bold, John, of Fryskenay, butcher 1
5240863 2427534 2427534 plaintiff Kyme Thomas esq 649599 649599 Kyme, Thomas, of Fryskenay, esq 0
5247018 2429289 2429289 plaintiff Skypwythe John merchant 649599 649599 Skypwythe, John, of Fryskenay, merchant 0
5355828 2461897 2461897 defendant Daweson Margaret widow 649599 649599 Daweson, Margaret, of Fryskenay, widow 0
5355831 2461897 2461897 defendant Swagge Thomas tailor 649599 649599 Swagge, Thomas, of Fryskenay, tailor 3

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);