names

189 rows where place_id = 591103

✎ 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
3603341 1868719 1868719 defendant Lombe William husbandman 591103 591103 Lombe, William, of Attilburgh, husbandman 0
3638180 1906758 1906758 defendant Reynold Richard tailor 591103 591103 Reynold, Richard, of Attilburgh, tailor 2
3687167 1922163 1922163 defendant Mayes William husbandman 591103 591103 Mayes, William, of Attilburgh, husbandman 1
3687493 1922267 1922267 defendant Drury William, junior gent 591103 591103 Drury, William, junior, of Attilburgh, gent 3
3697096 1925311 1925311 defendant Wellys John husbandman 591103 591103 Wellys, John, of Attilburgh, husbandman 1
3697098 1925311 1925311 defendant Cowper Thomas   591103 591103 Cowper, Thomas, of Attilburgh, ploughwright 3
3697099 1925311 1925311 defendant Burton Thomas husbandman 591103 591103 Burton, Thomas, of Attilburgh, husbandman 4
3717068 1931622 1931622 defendant Lutkyn Thomas tailor 591103 591103 Lutkyn, Thomas, of Attilburgh, tailor 4
3754067 1943217 1943217 defendant Wethyng James   591103 591103 Wethyng, James, of Attilburgh, "gravour" 0
3754068 1943217 1943217 defendant Clerk William yeoman 591103 591103 Clerk, William, of Attilburgh, yeoman 1
3754069 1943217 1943217 defendant Bowe Stephen yeoman 591103 591103 Bowe, Stephen, of Attilburgh, yeoman 2
3754070 1943217 1943217 defendant Forthe William yeoman 591103 591103 Forthe, William, of Attilburgh, yeoman 3
3794703 1956219 1956219 defendant Knyght Thomas shoemaker 591103 591103 Knyght, Thomas, of Attilburgh, shoemaker 0
3811808 1961594 1961594 defendant Knyght Thomas shoemaker 591103 591103 Knyght, Thomas, of Attilburgh, shoemaker 0
4338929 2143370 2143370 defendant Alexander John (legal representative) 591103 591103 Alexander, John, of Attilburgh, yeoman, executor of 0
4488350 2197074 2197074 defendant Foulere Walter   591103 591103 Foulere, Walter, of Attilburgh 2
4512797 2204437 2204437 defendant Cartere John   591103 591103 Cartere, John, of Attilburgh 0
4512798 2204437 2204437 defendant Galle William   591103 591103 Galle, William, of Attilburgh 1
4512801 2204437 2204437 defendant Pyrte Thomas (legal representative) 591103 591103 Pyrte, Thomas, of Attilburgh, executors of 4
4532264 2210358 2210358 defendant Webbe Hugh   591103 591103 Webbe, Hugh, of Attilburgh 3
4543296 2213786 2213786 defendant Burton William   591103 591103 Burton, William, of Attilburgh 1
4546144 2214741 2214741 defendant Thrower William   591103 591103 Thrower, William, of Attilburgh 2
4546198 2214757 2214757 defendant Padegrys John   591103 591103 Padegrys, John, of Attilburgh 3
4560061 2219095 2219095 defendant Burton William   591103 591103 Burton, William, of Attilburgh 3
4566433 2221072 2221072 defendant Burton William   591103 591103 Burton, William, of Attilburgh 1
4568233 2221636 2221636 defendant Padgrys John   591103 591103 Padgrys, John, of Attilburgh 0
4568234 2221636 2221636 defendant Maryan Thomas   591103 591103 Maryan, Thomas, of Attilburgh 1
4568236 2221637 2221637 defendant Padgrys John   591103 591103 Padgrys, John, of Attilburgh 0
4568237 2221637 2221637 defendant Maryon Thomas   591103 591103 Maryon, Thomas, of Attilburgh 1
4577401 2224448 2224448 defendant Padtrys John   591103 591103 Padtrys, John, of Attilburgh 0
4579213 2224980 2224980 defendant Lacy John   591103 591103 Lacy, John, of Attilburgh 3
4579841 2225180 2225180 defendant atte Hill Robert   591103 591103 atte Hill, Robert, of Attilburgh 0
4579847 2225182 2225182 defendant Padgrys John   591103 591103 Padgrys, John, of Attilburgh 0
4579849 2225182 2225182 defendant Torl Richard   591103 591103 Torl, Richard, of Attilburgh 2
4580122 2225271 2225271 defendant Seman Roger   591103 591103 Seman, Roger, of Attilburgh 2
4586539 2227198 2227198 defendant Padgrys John   591103 591103 Padgrys, John, of Attilburgh 3
4589094 2227968 2227968 defendant Neel Richard   591103 591103 Neel, Richard, of Attilburgh 2
4595612 2229893 2229893 defendant Heyne Simon butcher 591103 591103 Heyne, Simon, of Attilburgh, butcher 0
4605462 2232839 2232839 defendant Reynoldyn William   591103 591103 Reynoldyn, William, of Attilburgh 0
4611133 2234546 2234546 defendant Bene John   591103 591103 Bene, John, of Attilburgh 0
4614242 2235466 2235466 defendant Patgrys John   591103 591103 Patgrys, John, of Attilburgh 0
4615806 2235938 2235938 defendant Pirt Thomas   591103 591103 Pirt, Thomas, of Attilburgh, son of Thomas 1
4628772 2239928 2239928 defendant atte Hyll Robert   591103 591103 atte Hyll, Robert, of Attilburgh 0
4628773 2239928 2239928 defendant Launce John smith 591103 591103 Launce, John, of Attilburgh, smith 1
4629756 2240229 2240229 defendant Patgrys John   591103 591103 Patgrys, John, of Attilburgh 0
4652345 2246685 2246685 defendant Turgood John   591103 591103 Turgood, John, of Attilburgh, wheelwright 2
4652348 2246685 2246685 defendant Sely Thomas laborer 591103 591103 Sely, Thomas, of Attilburgh, laborer 5
4653906 2247130 2247130 defendant Schete Thomas yeoman 591103 591103 Schete, Thomas, of Attilburgh, yeoman 0
4662697 2249789 2249789 defendant Patgrys John, senior yeoman 591103 591103 Patgrys, John, senior, of Attilburgh, yeoman 0
4662862 2249845 2249845 defendant Brampton Thomas, junior gent 591103 591103 Brampton, Thomas, junior, of Attilburgh, gent 1
4662866 2249846 2249846 defendant Brampton Thomas, junior gent 591103 591103 Brampton, Thomas, junior, of Attilburgh, gent 1
4674310 2257572 2257572 defendant Maryon Thomas yeoman 591103 591103 Maryon, Thomas, of Attilburgh, yeoman 5
4691514 2262871 2262871 defendant Sende Roger yeoman 591103 591103 Sende, Roger, of Attilburgh, yeoman 1
4699432 2265280 2265280 defendant Smyth Richard yeoman 591103 591103 Smyth, Richard, of Attilburgh, yeoman 4
4704299 2266721 2266721 defendant Pategrys John yeoman 591103 591103 Pategrys, John, of Attilburgh, yeoman 0
4727468 2273834 2273834 defendant Maryon Thomas yeoman 591103 591103 Maryon, Thomas, of Attilburgh, yeoman 0
4752121 2281102 2281102 defendant Knotte Alexander husbandman 591103 591103 Knotte, Alexander, of Attilburgh, husbandman 1
4758882 2283128 2283128 defendant Reginald William gent 591103 591103 Reginald, William, of Attilburgh, gent 0
4759783 2283395 2283395 defendant Knot Alexander   591103 591103 Knot, Alexander, of Attilburgh, bailiff 3
4764588 2284910 2284910 defendant Maryon Thomas husbandman 591103 591103 Maryon, Thomas, of Attilburgh, husbandman 4
4767467 2285804 2285804 defendant Pattegrys John yeoman 591103 591103 Pattegrys, John, of Attilburgh, yeoman 0
4770603 2286787 2286787 defendant Reynald William gent 591103 591103 Reynald, William, of Attilburgh, gent 0
4771408 2287040 2287040 plaintiff Saunfayle or Saunsayle John   591103 591103 Saunfayle or Saunsayle, John, of Attilburgh 0
4771410 2287040 2287040 defendant Pays Simon husbandman 591103 591103 Pays, Simon, of Attilburgh, husbandman 1
4771411 2287040 2287040 defendant Taillour John tailor 591103 591103 Taillour, John, of Attilburgh, tailor 2
4773090 2287553 2287553 defendant Wynter Alexander yeoman 591103 591103 Wynter, Alexander, of Attilburgh, yeoman 3
4776093 2288519 2288519 plaintiff Yong John   591103 591103 Yong, John, of Attilburgh 0
4776095 2288519 2288519 defendant Pytcok Thomas yeoman 591103 591103 Pytcok, Thomas, of Attilburgh, yeoman 1
4777349 2288906 2288906 defendant Heyne John husbandman 591103 591103 Heyne, John, of Attilburgh, husbandman 3
4782571 2290561 2290561 defendant Pyrt Thomas husbandman 591103 591103 Pyrt, Thomas, of Attilburgh, husbandman 0
4788571 2292484 2292484 defendant Marion Thomas husbandman 591103 591103 Marion, Thomas, of Attilburgh, husbandman 1
4791835 2293548 2293548 defendant Pattegys John yeoman 591103 591103 Pattegys, John, of Attilburgh, yeoman 0
4795132 2294623 2294623 defendant Patgrys John husbandman 591103 591103 Patgrys, John, of Attilburgh, husbandman 0
4802034 2296821 2296821 defendant Pittok Thomas yeoman 591103 591103 Pittok, Thomas, of Attilburgh, yeoman 0
4816707 2301323 2301323 defendant Padgrys John yeoman 591103 591103 Padgrys, John, of Attilburgh, yeoman 0
4816708 2301323 2301323 defendant Gelle Thomas clerk 591103 591103 Gelle, Thomas, of Attilburgh, clerk 1
4816709 2301323 2301323 defendant Pirt Thomas yeoman 591103 591103 Pirt, Thomas, of Attilburgh, yeoman 2
4816712 2301324 2301324 defendant Pyrt Thomas yeoman 591103 591103 Pyrt, Thomas, of Attilburgh, yeoman 0
4816713 2301324 2301324 defendant Bret Richard yeoman 591103 591103 Bret, Richard, of Attilburgh, yeoman 1
4816715 2301324 2301324 defendant Padgrys John yeoman 591103 591103 Padgrys, John, of Attilburgh, yeoman 3
4831212 2305793 2305793 defendant Pyrt Thomas yeoman 591103 591103 Pyrt, Thomas, of Attilburgh, yeoman 2
4838843 2308079 2308079 defendant Bryse Geoffrey smith 591103 591103 Bryse, Geoffrey, of Attilburgh, smith 0
4843375 2309443 2309443 defendant Patagrys John yeoman 591103 591103 Patagrys, John, of Attilburgh, yeoman 0
4850958 2311750 2311750 defendant Padgrys John yeoman 591103 591103 Padgrys, John, of Attilburgh, yeoman 0
4851686 2311960 2311960 defendant Patgrys John yeoman 591103 591103 Patgrys, John, of Attilburgh, yeoman 0
4860637 2314686 2314686 defendant Knot Alexander woolman 591103 591103 Knot, Alexander, of Attilburgh, woolman 0
4862586 2315284 2315284 defendant Brampton William gent 591103 591103 (Brampton, William, of Attilburgh, gent 1
4878930 2320345 2320345 defendant Patgrys John yeoman 591103 591103 Patgrys, John, of Attilburgh, yeoman 0
4887226 2322844 2322844 defendant Brampton William gent 591103 591103 Brampton, William, of Attilburgh, gent 0
4888484 2323195 2323195 plaintiff Bradenham John miller 591103 591103 Bradenham, John, of Attilburgh, miller 0
4900868 2326903 2326903 plaintiff Page Roger husbandman 591103 591103 Page, Roger, of Attilburgh, husbandman 0
4900870 2326903 2326903 defendant Ede William husbandman 591103 591103 Ede, William, of Attilburgh, husbandman 1
4900871 2326903 2326903 defendant Litilproud John barker 591103 591103 Litilproud, John, of Attilburgh, barker 2
4900872 2326903 2326903 defendant Byrt Richard turner 591103 591103 Byrt, Richard, of Attilburgh, turner 3
4900874 2326903 2326903 defendant Draper Richard skinner 591103 591103 Draper, Richard, of Attilburgh, skinner 5
4962744 2345765 2345765 defendant South John clerk 591103 591103 South, John, of Attilburgh, clerk 2
4964538 2346302 2346302 defendant Spylman Robert husbandman 591103 591103 Spylman, Robert, of Attilburgh, husbandman 0
4973885 2349150 2349150 plaintiff Ducheman John   591103 591103 Ducheman, John, of Attilburgh 1
4979263 2350755 2350755 defendant Patgryse John yeoman 591103 591103 Patgryse, John, of Attilburgh, yeoman 0
4980377 2351073 2351073 defendant Cove Thomas clerk 591103 591103 Cove, Thomas, of Attilburgh, clerk 2

Next page

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