names

77 rows where place_id = 588988

✎ 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
3596203 1866442 1866442 defendant Waker Edward yeoman 588988 588988 Waker, Edward, of Alton, Hants, yeoman 0
3632875 1905100 1905100 defendant Redyng William yeoman 588988 588988 Redyng, William, of Alton, Hants, yeoman 0
3651902 1910944 1910944 defendant Arnold William clothmaker 588988 588988 Arnold, William, of Alton, Hants, clothmaker 0
3659612 1913265 1913265 defendant Courtmyll Thomas fuller 588988 588988 Courtmyll, Thomas, of Alton, Hants, fuller 2
3664165 1914742 1914742 plaintiff Redynge William (legal representative) 588988 588988 Redynge, William, of Alton, Hants, mercer, executors of 0
3679179 1919556 1919556 defendant Wattys Richard clothman 588988 588988 Wattys, Richard, of Alton, Hants, clothman 1
3768223 1947700 1947700 defendant Fylder Richard clothmaker 588988 588988 Fylder, Richard, of Alton, Hants, clothmaker 0
3788782 1954297 1954297 defendant Redman Lawrence yeoman 588988 588988 Redman, Lawrence, of Alton, Hants, yeoman 0
3790772 1954941 1954941 defendant Redman Lawrence clothman 588988 588988 Redman, Lawrence, of Alton, Hants, clothman 1
3790776 1954942 1954942 defendant Redman Lawrence clothman 588988 588988 Redman, Lawrence, of Alton, Hants, clothman 1
3800310 1958015 1958015 defendant Bene John smith 588988 588988 Bene, John, of Alton, Hants, smith 2
3880202 1983632 1983632 defendant Smythe William clothmaker 588988 588988 Smythe, William, of Alton, Hants, clothmaker 0
3880205 1983633 1983633 defendant Smythe William clothmaker 588988 588988 Smythe, William, of Alton, Hants, clothmaker 0
3884999 1985244 1985244 defendant Turges Thomas mercer 588988 588988 Turges, Thomas, of Alton, Hants, mercer 0
3921911 1997674 1997674 defendant Storges Thomas clothmaker 588988 588988 Storges, Thomas, of Alton, Hants, clothmaker 1
3924923 1998655 1998655 defendant Sturges Thomas merchant 588988 588988 Sturges, Thomas, of Alton, Hants, merchant 0
3931625 2000874 2000874 defendant Tapner or Tarner William smith 588988 588988 Tapner or Tarner, William, of Alton, Hants, smith 0
3931630 2000875 2000875 defendant Tapner William smith 588988 588988 Tapner, William, of Alton, Hants, smith 0
3933606 2001527 2001527 defendant Melton John   588988 588988 Melton, John, of Alton, Hants, shoe maker 0
3962370 2011425 2011425 plaintiff Weller Edward clothier 588988 588988 Weller, Edward, of Alton, Hants, clothier 0
3971256 2014505 2014505 defendant Draper John smith 588988 588988 Draper, John, of Alton, Hants, smith 0
4042297 2039726 2039726 defendant Feelder Richard chapman 588988 588988 Feelder, Richard, of Alton, Hants, chapman 0
4054993 2044180 2044180 defendant Mathewe Roger chapman 588988 588988 Mathewe, Roger, of Alton, Hants, chapman 2
4066827 2048436 2048436 defendant Bull John chapman 588988 588988 Bull, John, of Alton, Hants, chapman 0
4094351 2058320 2058320 defendant Pyncke William shoemaker 588988 588988 Pyncke, William, of Alton, Hants, shoemaker 0
4094353 2058321 2058321 defendant Pyncke William shoemaker 588988 588988 Pyncke, William, of Alton, Hants, shoemaker 0
4102172 2061072 2061072 defendant Upton Jasper chandler 588988 588988 Upton, Jasper, of Alton, Hants, chandler 2
4148155 2077487 2077487 defendant Knight Henry yeoman 588988 588988 Knight, Henry, of Alton, Hants, yeoman 0
4211294 2099503 2099503 defendant Colt Richard yeoman 588988 588988 Colt, Richard, of Alton, Hants, or of Rustington, Sussex, yeoman 0
4268003 2118917 2118917 defendant Butler John brewer 588988 588988 Butler, John, of Alton, Hants, brewer 1
4384726 2159577 2159577 defendant Feldere or Feildar Benjamin clothier 588988 588988 Feldere or Feildar, Benjamin, of Alton, Hants, clothier 0
4384728 2159578 2159578 defendant Feldere or Feilder Benjamin clothier 588988 588988 Feldere or Feilder, Benjamin, of Alton, Hants, clothier 0
4603246 2232218 2232218 defendant Knyght William   588988 588988 Knyght, William, of Alton, Hants 4
4603255 2232220 2232220 defendant Knyght William   588988 588988 Knyght, William, of Alton, Hants 5
4694290 2263713 2263713 defendant Wollane William merchant 588988 588988 Wollane, William, of Alton, Hants, merchant 0
4702667 2266237 2266237 defendant Cranborn Henry dyer 588988 588988 Cranborn, Henry, of Alton, Hants, dyer 4
4702682 2266239 2266239 defendant Cranborne Henry dyer 588988 588988 Cranborne, Henry, of Alton, Hants, dyer 4
4819195 2302083 2302083 defendant Fyssher Walter butcher 588988 588988 (Fyssher, Walter, of Alton, Hants, butcher 1
4837701 2307724 2307724 defendant Smyth John smith 588988 588988 Smyth, John, of Alton, Hants, smith 1
4863388 2315518 2315518 plaintiff Dyer Stephen   588988 588988 Dyer, Stephen, of Alton, Hants 0
5002567 2357664 2357664 defendant Snappe John chapman 588988 588988 Snappe, John, of Alton, Hants, chapman 0
5026490 2364628 2364628 defendant Dyer Joan widow 588988 588988 (Dyer, Joan, of Alton, Hants, widow 1
5040179 2368663 2368663 defendant Esteney Richard ironmonger 588988 588988 Esteney, Richard, of Alton, Hants, ironmonger 0
5040181 2368664 2368664 defendant Esteney Richard ironmonger 588988 588988 Esteney, Richard, of Alton, Hants, ironmonger 0
5059951 2374541 2374541 defendant Norwell John chapman 588988 588988 Norwell, John, of Alton, Hants, chapman 0
5083501 2381567 2381567 defendant Norwell John chapman 588988 588988 Norwell, John, of Alton, Hants, chapman 0
5083686 2381621 2381621 defendant Northwell John chapman 588988 588988 Northwell, John, of Alton, Hants, chapman 1
5093538 2384508 2384508 defendant Tartyngton Bernard spicer 588988 588988 Tartyngton, Bernard, of Alton, Hants, spicer 2
5097997 2385845 2385845 defendant Banecroft John yeoman 588988 588988 Banecroft, John, of Alton, Hants, yeoman 0
5159785 2403964 2403964 defendant Twychener John hosier 588988 588988 Twychener, John, of Alton, Hants, hosier 0
5159787 2403965 2403965 defendant Twytchener John hosier 588988 588988 Twytchener, John, of Alton, Hants, hosier 0
5163577 2405080 2405080 defendant Bele Henry butcher 588988 588988 Bele, Henry, of Alton, Hants, butcher 0
5163579 2405081 2405081 defendant Bele Henry butcher 588988 588988 Bele, Henry, of Alton, Hants, butcher 0
5174759 2408319 2408319 defendant Twychener John hosier 588988 588988 Twychener, John, of Alton, Hants, hosier 0
5200859 2416014 2416014 defendant Chapman John dyer 588988 588988 Chapman, John, of Alton, Hants, dyer 0
5220243 2421619 2421619 defendant Bele Henry chapman 588988 588988 Bele, Henry, of Alton, Hants, chapman 0
5223336 2422520 2422520 defendant Estwayte Robert yeoman 588988 588988 Estwayte, Robert, of Alton, Hants, yeoman 3
5261776 2433793 2433793 defendant Palmer Nicholas husbandman 588988 588988 Palmer, Nicholas, of Alton, Hants, husbandman 0
5265247 2434888 2434888 defendant Bowell John chapman 588988 588988 Bowell, John, of Alton, Hants, chapman 3
5272296 2436969 2436969 defendant Bowell Simon chapman 588988 588988 Bowell, Simon, of Alton, Hants, chapman 0
5275239 2437832 2437832 defendant Poste Robert   588988 588988 Poste, Robert, of Alton, Hants, hostler, dwelling at the sign of the Hert 0
5352318 2460824 2460824 defendant Durewyn Simon yeoman 588988 588988 Durewyn, Simon, of Alton, Hants, or of Est Mersey, Essex, yeoman 7
5357641 2462461 2462461 defendant Breggys Thomas husbandman 588988 588988 Breggys, Thomas, of Alton, Hants, husbandman 1
5377476 2468539 2468539 defendant Draper Stephen skinner 588988 588988 Draper, Stephen, of Alton, Hants, skinner 2
5422679 2481733 2481733 defendant Borrowe Richard chapman 588988 588988 Borrowe, Richard, of Alton, Hants, chapman 2
5442255 2487602 2487602 defendant Borrowe Richard chapman 588988 588988 Borrowe, Richard, of Alton, Hants, chapman 2
5498888 2504606 2504606 defendant Kyng William smith 588988 588988 Kyng, William, of Alton, Hants, smith 3
5523125 2512059 2512059 defendant Molyns Richard butcher 588988 588988 Molyns, Richard, of Alton, Hants, butcher 2
5523131 2512060 2512060 defendant Molyns Richard butcher 588988 588988 Molyns, Richard, of Alton, Hants, butcher 2
5538259 2516451 2516451 defendant Crechelewe Richard yeoman 588988 588988 Crechelewe, Richard, of Alton, Hants, yeoman 1
5545431 2518653 2518653 defendant Clerk Richard clothier 588988 588988 Clerk, Richard, of Alton, Hants, clothier 0
5548664 2519651 2519651 defendant Arnold William clothier 588988 588988 Arnold, William, of Alton, Hants, clothier 0
5551602 2520507 2520507 defendant Holwey Walter yeoman 588988 588988 Holwey, Walter, of Alton, Hants, yeoman 4
5554748 2521396 2521396 defendant Holwey Walter yeoman 588988 588988 Holwey, Walter, of Alton, Hants, yeoman 4
5573785 2526898 2526898 defendant Leman John clothmaker 588988 588988 Leman, John, of Alton, Hants, clothmaker 0
5583618 2529953 2529953 defendant Skynner Nicholas mercer 588988 588988 Skynner, Nicholas, of Alton, Hants, mercer 1
5583621 2529954 2529954 defendant Skynner Nicholas mercer 588988 588988 Skynner, Nicholas, of Alton, Hants, mercer 1

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