names

54 rows where place_id = 672834

✎ 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
4007251 2027373 2027373 plaintiff Major William yeoman 672834 672834 Major, William, of Cerne Abbas, yeoman 0
4007255 2027374 2027374 plaintiff Major William yeoman 672834 672834 Major, William, of Cerne Abbas, yeoman 0
4007256 2027374 2027374 defendant Upcote John glover 672834 672834 Upcote, John, of Cerne Abbas, glover 0
4007257 2027374 2027374 defendant Welman Simon butcher 672834 672834 Welman, Simon, of Cerne Abbas, butcher 1
4011057 2028729 2028729 defendant Major William yeoman 672834 672834 Major, William, of Cerne Abbas, yeoman 0
4026736 2034208 2034208 plaintiff Cardrowe William merchant 672834 672834 Cardrowe, William, of Cerne Abbas, merchant 0
4026737 2034208 2034208 defendant Stickland John mercer 672834 672834 Stickland, John, of Cerne Abbas, mercer 0
4026738 2034209 2034209 plaintiff Cardrowe William merchant 672834 672834 Cardrowe, William, of Cerne Abbas, merchant 0
4026739 2034209 2034209 defendant Styckland John merchant 672834 672834 Styckland, John, of Cerne Abbas, merchant 0
4041981 2039620 2039620 defendant Welman Simon butcher 672834 672834 Welman, Simon, of Cerne Abbas, butcher 0
4047979 2041723 2041723 defendant Stickland John mercer 672834 672834 Stickland, John, of Cerne Abbas, mercer 0
4047980 2041723 2041723 defendant Allyn Edward shoemaler 672834 672834 Allyn, Edward, of Cerne Abbas, shoemaler 1
4074660 2051241 2051241 defendant Welman Simon butcher 672834 672834 Welman, Simon, of Cerne Abbas, butcher 0
4079291 2052895 2052895 defendant Welman Simon butcher 672834 672834 Welman, Simon, of Cerne Abbas, butcher 0
4079522 2052974 2052974 defendant Morris Leonard mercer 672834 672834 Morris, Leonard, of Cerne Abbas, mercer 0
4079523 2052974 2052974 defendant Welman Hugh butcher 672834 672834 Welman, Hugh, of Cerne Abbas, butcher 1
4079524 2052974 2052974 defendant Hailes William tailor 672834 672834 Hailes, William, of Cerne Abbas, tailor 2
4138358 2074082 2074082 defendant Moryshe Leonard mercer 672834 672834 Moryshe, Leonard, of Cerne Abbas, mercer 1
4175771 2086999 2086999 defendant Warren alias Mayo John blacksmith 672834 672834 Warren alias Mayo, John, of Cerne Abbas, blacksmith 1
4190061 2092025 2092025 defendant Stycklande John mercer 672834 672834 Stycklande, John, of Cerne Abbas, mercer 0
4190062 2092025 2092025 defendant Mayor William yeoman 672834 672834 Mayor, William, of Cerne Abbas, yeoman 1
4190063 2092025 2092025 defendant Allyn Edward cordwainer 672834 672834 Allyn, Edward, of Cerne Abbas, cordwainer 2
4199086 2095236 2095236 defendant Waston alias Mayo John smith 672834 672834 Waston alias Mayo, John, of Cerne Abbas, smith 2
4212943 2100055 2100055 defendant Strickland John mercer 672834 672834 Strickland, John, of Cerne Abbas, mercer 0
4212944 2100055 2100055 defendant Mayor William yeoman 672834 672834 Mayor, William, of Cerne Abbas, yeoman 1
4212945 2100055 2100055 defendant Allyn Edward cordwainer 672834 672834 Allyn, Edward, of Cerne Abbas, cordwainer 2
4333099 2141357 2141357 defendant Symontes John tailor 672834 672834 Symontes, John, of Cerne Abbas, tailor 2
4340736 2144034 2144034 defendant Gold George butcher 672834 672834 Gold, George, of Cerne Abbas, victualer, butcher 0
4656539 2247941 2247941 defendant Metford John tucker 672834 672834 Metford, John, of Cerne Abbas, tucker 0
4656540 2247941 2247941 defendant Monke Adam carpenter 672834 672834 Monke, Adam, of Cerne Abbas, carpenter 1
4656541 2247941 2247941 defendant Skynner Thomas skinner 672834 672834 Skynner, Thomas, of Cerne Abbas, skinner 2
4656542 2247941 2247941 defendant Maynard John smith 672834 672834 Maynard, John, of Cerne Abbas, smith 3
4656543 2247941 2247941 defendant Goulde John tailor 672834 672834 Goulde, John, of Cerne Abbas, tailor 4
4656544 2247941 2247941 defendant Felpot John tanner 672834 672834 Felpot, John, of Cerne Abbas, tanner 5
4656545 2247941 2247941 defendant Golderne John butcher 672834 672834 Golderne, John, of Cerne Abbas, butcher 6
4814644 2300693 2300693 defendant Gaunt Henry butcher 672834 672834 Gaunt, Henry, of Cerne Abbas, butcher 0
4814646 2300694 2300694 defendant Gaunt Henry butcher 672834 672834 Gaunt, Henry, of Cerne Abbas, butcher 0
4865441 2316157 2316157 defendant Gaunt Henry butcher 672834 672834 Gaunt, Henry, of Cerne Abbas, butcher 4
4865447 2316158 2316158 defendant Gaunt Henry butcher 672834 672834 Gaunt, Henry, of Cerne Abbas, butcher 4
4952310 2342655 2342655 defendant Durneford Robert gent 672834 672834 Durneford, Robert, of Cerne Abbas, gent 2
5080616 2380691 2380691 defendant Sampford Nicholas ostler 672834 672834 Sampford, Nicholas, of Cerne Abbas, ostler 0
5080617 2380691 2380691 defendant Porte Robert husbandman 672834 672834 Porte, Robert, of Cerne Abbas, husbandman 1
5255924 2431975 2431975 defendant Wykes Henry esq 672834 672834 Wykes, Henry, of Cerne Abbas, esq 0
5281309 2439606 2439606 defendant Crulle Richard smith 672834 672834 Crulle, Richard, of Cerne Abbas, smith 0
5296321 2443914 2443914 defendant Neuman John husbandman 672834 672834 Neuman, John, of Cerne Abbas, husbandman 2
5296328 2443915 2443915 defendant Est John (legal representative) 672834 672834 Est, John, of Cerne Abbas, administratrix of 4
5328527 2453609 2453609 defendant Adyn John yeoman 672834 672834 Adyn, John, of Cerne Abbas, yeoman 0
5348796 2459750 2459750 defendant Fowey Thomas draper 672834 672834 Fowey, Thomas, of Cerne Abbas, draper 0
5428157 2483361 2483361 defendant Lokke John hosteler 672834 672834 Lokke, John, of Cerne Abbas, hosteler 0
5433992 2485119 2485119 defendant Fowey Thomas draper 672834 672834 Fowey, Thomas, of Cerne Abbas, draper 0
5434072 2485142 2485142 defendant Whyte John gent 672834 672834 Whyte, John, of Cerne Abbas, gent 0
5434073 2485142 2485142 defendant Ardyn John woolmonger 672834 672834 Ardyn, John, of Cerne Abbas, woolmonger 1
5559658 2522783 2522783 defendant Symmys Margaret widow 672834 672834 Symmys, Margaret, of Cerne Abbas, widow 3
5601786 2535460 2535460 defendant Lok John yeoman 672834 672834 Lok, John, of Cerne Abbas, yeoman 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);