names

41 rows where place_id = 625268

✎ 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
3763145 1946105 1946105 defendant Canon George husbandman 625268 625268 Canon, George, of Pynnore, husbandman 0
4544950 2214342 2214342 defendant Merssh William, sen   625268 625268 Merssh, William, sen, of Pynnore 0
4657238 2248150 2248150 defendant Payn John husbandman 625268 625268 Payn, John, of Pynnore, husbandman 0
4657239 2248150 2248150 defendant Strete John husbandman 625268 625268 Strete, John, of Pynnore, husbandman 1
4657240 2248150 2248150 defendant Bouryng John husbandman 625268 625268 Bouryng, John, of Pynnore, husbandman 2
4722049 2272225 2272225 defendant Payn John husbandman 625268 625268 Payn, John, of Pynnore, husbandman 0
4722050 2272225 2272225 defendant atte Strete John husbandman 625268 625268 atte Strete, John, of Pynnore, husbandman 1
4722051 2272225 2272225 defendant Bouryng John husbandman 625268 625268 Bouryng, John, of Pynnore, husbandman 2
4722053 2272226 2272226 defendant Payn John husbandman 625268 625268 Payn, John, of Pynnore, husbandman 0
4722054 2272226 2272226 defendant atte Strete John husbandman 625268 625268 atte Strete, John, of Pynnore, husbandman 1
4722055 2272226 2272226 defendant Bouryng John husbandman 625268 625268 Bouryng, John, of Pynnore, husbandman 2
4743567 2278644 2278644 defendant Godyng John husbandman 625268 625268 Godyng, John, of Pynnore, husbandman 0
4743568 2278644 2278644 defendant Bowryng John husbandman 625268 625268 Bowryng, John, of Pynnore, husbandman 1
4744321 2278861 2278861 defendant Donner John butcher 625268 625268 Donner, John, of Pynnore, butcher 0
4784943 2291302 2291302 defendant Bouryng John husbandman 625268 625268 Bouryng, John, of Pynnore, husbandman 0
4789545 2292802 2292802 defendant Roghed John husbandman 625268 625268 Roghed, John, of Pynnore, husbandman 0
4789796 2292876 2292876 defendant Elfryth John husbandman 625268 625268 Elfryth, John, of Pynnore, husbandman 1
4789797 2292876 2292876 defendant Bouryng John husbandman 625268 625268 Bouryng, John, of Pynnore, husbandman 2
4789798 2292876 2292876 defendant Cornehull Richard husbandman 625268 625268 Cornehull, Richard, of Pynnore, husbandman 3
4792093 2293627 2293627 defendant Ponder or Pouder John (legal representative) 625268 625268 Ponder or Pouder, John, of Pynnore, administratrix of 1
4813264 2300263 2300263 defendant Delle Richard husbandman 625268 625268 Delle, Richard, of Pynnore, husbandman 0
4819446 2302159 2302159 defendant Boweryng Robert husbandman 625268 625268 Boweryng, Robert, of Pynnore, husbandman 0
4819450 2302159 2302159 defendant Waspe Richard husbandman 625268 625268 Waspe, Richard, of Pynnore or Pinner, husbandman 4
4886478 2322634 2322634 defendant Boryng Agnes widow 625268 625268 Boryng, Agnes, of Pynnore, widow 0
4901632 2327113 2327113 defendant Blakewell William husbandman 625268 625268 Blakewell, William, of Pynnore, husbandman 0
4923567 2333804 2333804 defendant Clerk John husbandman 625268 625268 Clerk, John, of Pynnore, husbandman 0
4959064 2344678 2344678 defendant Wight John husbandman 625268 625268 Wight, John, of Pynnore, husbandman 0
4959065 2344678 2344678 defendant Turnour John, senior husbandman 625268 625268 Turnour, John, senior, of Pynnore, husbandman 1
4959066 2344678 2344678 defendant Catelete Joan widow 625268 625268 Catelete, Joan, of Pynnore, widow 2
4974642 2349383 2349383 defendant Aleyn William   625268 625268 Aleyn, William, of Pynnore 0
4993548 2354943 2354943 defendant Newe Richard husbandman 625268 625268 Newe, Richard, of Pynnore, husbandman 0
5001371 2357285 2357285 defendant Bryde Thomas butcher 625268 625268 Bryde, Thomas, of Pynnore, butcher 0
5002256 2357562 2357562 defendant Esdonne Thomas husbandman 625268 625268 Esdonne, Thomas, of Pynnore, husbandman 0
5027922 2365045 2365045 defendant Newe John husbandman 625268 625268 Newe, John, of Pynnore, husbandman 0
5027923 2365045 2365045 defendant Aleyn William husbandman 625268 625268 Aleyn, William, of Pynnore, husbandman 1
5050638 2371819 2371819 plaintiff Turnour John   625268 625268 Turnour, John, of Pynnore 0
5415247 2479500 2479500 defendant Hethe Thomas carpenter 625268 625268 Hethe, Thomas, of Pynnore, carpenter 4
5415253 2479501 2479501 defendant Hethe Thomas carpenter 625268 625268 Hethe, Thomas, of Pynnore, carpenter 4
5415259 2479502 2479502 defendant Hethe Thomas carpenter 625268 625268 Hethe, Thomas, of Pynnore, carpenter 4
5494394 2503225 2503225 defendant Redyng John husbandman 625268 625268 Redyng, John, of Pynnore, husbandman 1
5503039 2505858 2505858 defendant Canon William collier 625268 625268 Canon, William, of Pynnore, collier 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);