names

58 rows where place_id = 588613

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595054 1866086 1866086 plaintiff Lye Richard   588613 588613 Lye, Richard, of West Hamme 0
3595055 1866086 1866086 defendant Chybboll William brewer 588613 588613 Chybboll, William, of West Hamme, brewer 0
3600210 1867713 1867713 defendant Wryght James husbandman 588613 588613 Wryght, James, of West Hamme, husbandman 1
3600211 1867713 1867713 defendant Ache John yeoman 588613 588613 Ache, John, of West Hamme, yeoman 2
3600479 1867797 1867797 defendant Wryght James husbandman 588613 588613 Wryght, James, of West Hamme, husbandman 1
3600480 1867797 1867797 defendant Ache John yeoman 588613 588613 Ache, John, of West Hamme, yeoman 2
4427961 2173586 2173586 plaintiff Sperlyng Nicholas clerk 588613 588613 Sperlyng, Nicholas, of West Hamme, clerk 0
4448979 2184622 2184622 plaintiff Gayay Richard   588613 588613 Gayay, Richard, of West Hamme 0
4476739 2193386 2193386 defendant Godeson John   588613 588613 Godeson, John, of West Hamme 0
4476740 2193386 2193386 defendant Carpenter Robert   588613 588613 Carpenter, Robert, of West Hamme 1
4487889 2196929 2196929 defendant Heyward John   588613 588613 Heyward, John, of West Hamme 0
4550218 2216013 2216013 defendant Mersher John   588613 588613 Mersher, John, of West Hamme 0
4556539 2217980 2217980 defendant Shipman John   588613 588613 Shipman, John, of West Hamme 0
4585461 2226877 2226877 defendant Devenyssh Margaret   588613 588613 Devenyssh, Margaret, of West Hamme 1
4585462 2226877 2226877 defendant Devenysshe William   588613 588613 Devenysshe, William, of West Hamme 2
4686663 2261440 2261440 defendant Baker Richard husbandman 588613 588613 Baker, Richard, of West Hamme, husbandman 0
4686664 2261440 2261440 defendant Theccher Anne widow 588613 588613 Theccher, Anne, of West Hamme, widow 1
4730927 2274870 2274870 defendant Baron John husbandman 588613 588613 Baron, John, of West Hamme, husbandman 0
4750946 2280760 2280760 defendant Rook Richard   588613 588613 Rook, Richard, of West Hamme, corn monger 0
4761174 2283845 2283845 defendant Ruddok John carpenter 588613 588613 Ruddok, John, of West Hamme, carpenter 0
4784541 2291170 2291170 defendant Ruddok John carpenter 588613 588613 together with Ruddok, John, of West Hamme, carpenter 2
4794808 2294520 2294520 defendant Rooke Richard husbandman 588613 588613 Rooke, Richard, of West Hamme, husbandman 0
4794809 2294520 2294520 defendant Sewale John husbandman 588613 588613 together with Sewale, John, of West Hamme, husbandman 1
4908059 2329079 2329079 defendant Wyberd Robert husbandman 588613 588613 Wyberd, Robert, of West Hamme, husbandman 3
4932690 2336613 2336613 defendant Blakelowe Robert   588613 588613 Blakelowe, Robert, of West Hamme, vicar 0
5106954 2388465 2388465 defendant Malmayns John husbandman 588613 588613 Malmayns, John, of West Hamme, husbandman 0
5106955 2388465 2388465 defendant Baldewyn Robert husbandman 588613 588613 Baldewyn, Robert, of West Hamme, husbandman 1
5128315 2394759 2394759 defendant Benet John husbandman 588613 588613 Benet, John, of West Hamme, husbandman 0
5128317 2394760 2394760 defendant Hope William husbandman 588613 588613 Hope, William, of West Hamme, husbandman 0
5128319 2394761 2394761 defendant Newenton John husbandman 588613 588613 Newenton, John, of West Hamme, husbandman 0
5129626 2395156 2395156 defendant Reyfeld (illegible) yeoman 588613 588613 Reyfeld, ---, of West Hamme, yeoman 1
5129627 2395156 2395156 defendant Burgh William yeoman 588613 588613 Burgh, William, of West Hamme, yeoman 2
5144122 2399433 2399433 defendant Bukler John yeoman 588613 588613 Bukler, John, of West Hamme, yeoman 0
5144123 2399433 2399433 defendant Reyfeld Nicholas yeoman 588613 588613 Reyfeld, Nicholas, of West Hamme, yeoman 1
5144124 2399433 2399433 defendant Burgh William yeoman 588613 588613 Burgh, William, of West Hamme, yeoman 2
5161403 2404432 2404432 defendant Kerres Robert gent 588613 588613 Kerres, Robert, of West Hamme, gent 0
5178768 2409513 2409513 defendant Bukler John yeoman 588613 588613 Bukler, John, of West Hamme, yeoman 0
5178769 2409513 2409513 defendant Reyfeld Nicholas yeoman 588613 588613 Reyfeld, Nicholas, of West Hamme, yeoman 1
5178770 2409513 2409513 defendant Burgh William yeoman 588613 588613 Burgh, William, of West Hamme, yeoman 2
5201600 2416233 2416233 defendant Bukker John yeoman 588613 588613 Bukker, John, of West Hamme, yeoman 0
5201601 2416233 2416233 defendant Reyfeld Nicholas yeoman 588613 588613 Reyfeld, Nicholas, of West Hamme, yeoman 1
5201602 2416233 2416233 defendant Burgh William yeoman 588613 588613 Burgh, William, of West Hamme, yeoman 2
5216459 2420546 2420546 defendant Benyngton Henry yeoman 588613 588613 Benyngton, Henry, of West Hamme, yeoman 0
5216460 2420546 2420546 defendant Baldewyn Richard yeoman 588613 588613 Baldewyn, Richard, of West Hamme, yeoman 1
5216461 2420546 2420546 defendant Chapman William yeoman 588613 588613 Chapman, William, of West Hamme, yeoman 2
5216463 2420547 2420547 defendant Benyngton Henry yeoman 588613 588613 Benyngton, Henry, of West Hamme, yeoman 0
5216464 2420547 2420547 defendant Baldewyn Richard yeoman 588613 588613 Baldewyn, Richard, of West Hamme, yeoman 1
5216465 2420547 2420547 defendant Chapman William yeoman 588613 588613 Chapman, William, of West Hamme, yeoman 2
5327891 2453413 2453413 defendant Algore Richard fisher 588613 588613 Algore, Richard, of West Hamme, fisher 0
5370498 2466356 2466356 defendant Waterman Nicholas brewer 588613 588613 Waterman, Nicholas, of West Hamme, brewer 0
5370499 2466356 2466356 defendant Algore John husbandman 588613 588613 Algore, John, of West Hamme, husbandman 1
5370501 2466357 2466357 defendant Chybell William brewer 588613 588613 Chybell, William, of West Hamme, brewer 0
5388325 2471708 2471708 defendant Chyboll William brewer 588613 588613 Chyboll, William, of West Hamme, brewer 0
5388327 2471708 2471708 defendant Algore John brewer 588613 588613 Algore, John, of West Hamme, brewer 2
5388329 2471709 2471709 defendant Chyboll William brewer 588613 588613 Chyboll, William, of West Hamme, brewer 0
5388331 2471709 2471709 defendant Algore John brewer 588613 588613 Algore, John, of West Hamme, brewer 2
5400919 2475324 2475324 defendant Chyboll William brewer 588613 588613 Chyboll, William, of West Hamme, brewer 0
5400921 2475325 2475325 defendant Rotte John brewer 588613 588613 Rotte, John, of West Hamme, brewer 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);