names

36 rows where place_id = 603729

✎ 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
3655602 1912014 1912014 defendant Mathewe John butcher 603729 603729 Mathewe, John, of Great Shelford, butcher 2
3655603 1912014 1912014 defendant Glover William butcher 603729 603729 Glover, William, of Great Shelford, butcher 3
3655604 1912014 1912014 defendant Apott John hsubandman 603729 603729 Apott, John, of Great Shelford, hsubandman 4
3663489 1914506 1914506 defendant Fenerell or Feverell John butcher 603729 603729 Fenerell or Feverell, John, of Great Shelford, butcher 0
3933724 2001573 2001573 defendant Newman William husbandman 603729 603729 Newman, William, of Great Shelford, husbandman 1
4471708 2191818 2191818 defendant Spode John   603729 603729 Spode, John, of Great Shelford 0
4522269 2207308 2207308 defendant Boteler Richard   603729 603729 Boteler, Richard, of Great Shelford 0
4578980 2224908 2224908 plaintiff Adekyn William   603729 603729 Adekyn, William, of Great Shelford 1
4649635 2245923 2245923 defendant Souneman John   603729 603729 Souneman, John, of Great Shelford 3
4649641 2245924 2245924 defendant Souneman John   603729 603729 Souneman, John, of Great Shelford 3
4674792 2257730 2257730 defendant Dounham Thomas yeoman 603729 603729 Dounham, Thomas, of Great Shelford, yeoman 1
4683357 2260397 2260397 defendant Sped John husbandman 603729 603729 Sped, John, of Great Shelford, husbandman 4
4706588 2267440 2267440 defendant Spede John husbandman 603729 603729 Spede, John, of Great Shelford, husbandman 0
4708259 2267962 2267962 defendant Cornewayle Margaret widow 603729 603729 Cornewayle, Margaret, of Great Shelford, widow 0
4708260 2267962 2267962 defendant Cornewayle Agnes   603729 603729 Cornewayle, Agnes, of Great Shelford, servant 1
4712181 2269121 2269121 defendant Jonn or Joun Thomas   603729 603729 Jonn or Joun, Thomas, of Great Shelford, plough man 0
4712186 2269122 2269122 defendant Made William   603729 603729 Made, William, of Great Shelford, wright 2
4712472 2269217 2269217 defendant Seman John husbandman 603729 603729 Seman, John, of Great Shelford, husbandman 0
4712473 2269217 2269217 defendant Martyn Margaret   603729 603729 Martyn, Margaret, of Great Shelford, servant 1
4719415 2271417 2271417 defendant Bernard John   603729 603729 Bernard, John, of Great Shelford 0
4758233 2282949 2282949 defendant Collard John   603729 603729 Collard, John, of Great Shelford, franklin 1
4759162 2283210 2283210 defendant Collard John   603729 603729 Collard, John, of Great Shelford 0
4769344 2286385 2286385 plaintiff Patesle Thomas (legal representative) 603729 603729 Patesle, Thomas, of Great Shelford, clerk & parson, executors of 0
4769350 2286386 2286386 plaintiff Patesle Thomas (legal representative) 603729 603729 Patesle, Thomas, of Great Shelford, clerk & parson, executors of 0
4819316 2302118 2302118 defendant Haukere John clerk 603729 603729 Haukere, John, of Great Shelford, clerk 0
4852957 2312346 2312346 defendant Bernard John   603729 603729 Bernard, John, of Great Shelford, parson 0
4912932 2330541 2330541 defendant Colard Henry   603729 603729 Colard, Henry, of Great Shelford 0
4917414 2331961 2331961 defendant Porter John miller 603729 603729 Porter, John, of Great Shelford, miller 1
4922417 2333420 2333420 defendant Speed John husbandman 603729 603729 Speed, John, of Great Shelford, husbandman 0
4929578 2335664 2335664 defendant Bernes John, senior husbandman 603729 603729 Bernes, John, senior, of Great Shelford, husbandman 0
4985563 2352595 2352595 defendant Charyte Robert husbandman 603729 603729 Charyte, Robert, of Great Shelford, husbandman 0
5182651 2410680 2410680 defendant Cook Robert husbandman 603729 603729 Cook, Robert, of Great Shelford, husbandman 0
5182692 2410695 2410695 defendant Coke Robert laborer 603729 603729 Coke, Robert, of Great Shelford, laborer 0
5182694 2410696 2410696 defendant Coke Robert laborer 603729 603729 Coke, Robert, of Great Shelford, laborer 0
5187478 2412055 2412055 defendant Suman John husbandman 603729 603729 Suman, John, of Great Shelford, husbandman 2
5205593 2417381 2417381 defendant Suman John husbandman 603729 603729 Suman, John, of Great Shelford, 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);