names

43 rows where place_id = 630750

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3796285 1956704 1956704 defendant Snokyscope Thomas husbandman 630750 630750 Snokyscope, Thomas, of Market Overton, husbandman 1
3944602 2005209 2005209 plaintiff Baxter Henry   630750 630750 Baxter, Henry, of Market Overton 0
4112214 2064625 2064625 defendant Snokestubbes alias Stubbes Henry husbandman 630750 630750 Snokestubbes alias Stubbes, Henry, of Market Overton, husbandman 0
4459632 2188067 2188067 defendant Braunston William   630750 630750 Braunston, William, of Market Overton 0
4459639 2188070 2188070 defendant Braunston William   630750 630750 Braunston, William, of Market Overton 0
4549867 2215892 2215892 defendant Swelyngton John   630750 630750 Swelyngton, John, of Market Overton 3
4584355 2226519 2226519 defendant Chestre John   630750 630750 Chestre, John, of Market Overton, parson 0
4712043 2269078 2269078 defendant Grobbe Clement butcher 630750 630750 Grobbe, Clement, of Market Overton, butcher 1
4722066 2272231 2272231 plaintiff Clerk Robert   630750 630750 Clerk, Robert, of Market Overton 0
4769733 2286505 2286505 defendant Whiteside Richard husbandman 630750 630750 Whiteside, Richard, of Market Overton, husbandman 1
4858173 2313925 2313925 defendant Croxton Henry husbandman 630750 630750 Croxton, Henry, of Market Overton, husbandman 0
4858174 2313925 2313925 defendant Lutte John husbandman 630750 630750 Lutte, John, of Market Overton, husbandman 1
4858175 2313925 2313925 defendant Whytsyde Richard husbandman 630750 630750 Whytsyde, Richard, of Market Overton, husbandman 2
4858176 2313925 2313925 defendant Soussex Henry   630750 630750 Soussex, Henry, of Market Overton, bailiff 3
4948353 2341467 2341467 defendant Margreytson John yeoman 630750 630750 Margreytson, John, of Market Overton, yeoman 0
4952698 2342764 2342764 defendant Sousex Thomas husbandman 630750 630750 Sousex, Thomas, of Market Overton, husbandman 0
4991004 2354200 2354200 defendant Ryvell John yeoman 630750 630750 Ryvell, John, of Market Overton, yeoman 0
4991995 2354493 2354493 defendant Croxton Henry husbandman 630750 630750 Croxton, Henry, of Market Overton, husbandman 0
4998164 2356318 2356318 defendant Margetson John yeoman 630750 630750 Margetson, John, of Market Overton, yeoman 0
4998165 2356318 2356318 defendant Ryvell John yeoman 630750 630750 Ryvell, John, of Market Overton, yeoman 1
5090314 2383549 2383549 defendant Margotson John, senior yeoman 630750 630750 Margotson, John, senior, of Market Overton, or of Gretham, yeoman 0
5188659 2412407 2412407 defendant Lutte John husbandman 630750 630750 Lutte, John, of Market Overton, husbandman 0
5188661 2412408 2412408 defendant Lutte John husbandman 630750 630750 Lutte, John, of Market Overton, husbandman 0
5188663 2412409 2412409 defendant Lutte John husbandman 630750 630750 Lutte, John, of Market Overton, husbandman 0
5197760 2415088 2415088 defendant Bonebroke or Bovebroke John clerk 630750 630750 Bonebroke or Bovebroke, John, of Market Overton, clerk 0
5206168 2417535 2417535 defendant Lutte John husbandman 630750 630750 Lutte, John, of Market Overton, husbandman 0
5206170 2417536 2417536 defendant Lutte John husbandman 630750 630750 Lutte, John, of Market Overton, husbandman 0
5252567 2430916 2430916 defendant Straker John husbandman 630750 630750 Straker, John, of Market Overton, husbandman 1
5387231 2471421 2471421 defendant Worsley Robert husbandman 630750 630750 Worsley, Robert, of Market Overton, husbandman 0
5397167 2474274 2474274 defendant Everey John husbandman 630750 630750 Everey, John, of Market Overton, husbandman 1
5399661 2474989 2474989 defendant Worsley Robert husbandman 630750 630750 Worsley, Robert, of Market Overton, husbandman 0
5410357 2478050 2478050 defendant Emerey John husbandman 630750 630750 Emerey, John, of Market Overton, husbandman 1
5412701 2478747 2478747 defendant Worsley Robert husbandman 630750 630750 Worsley, Robert, of Market Overton, husbandman 0
5412703 2478748 2478748 defendant Worsley Robert husbandman 630750 630750 Worsley, Robert, of Market Overton, husbandman 0
5424196 2482201 2482201 defendant Emerey John husbandman 630750 630750 Emerey, John, of Market Overton, husbandman 1
5427574 2483200 2483200 defendant Worsley Robert husbandman 630750 630750 Worsley, Robert, of Market Overton, husbandman 0
5439478 2486741 2486741 defendant Worsley Robert husbandman 630750 630750 Worsley, Robert, of Market Overton, husbandman 0
5486619 2500894 2500894 defendant Snokestobbe Thomas husbandman 630750 630750 Snokestobbe, Thomas, of Market Overton, husbandman 3
5514005 2509228 2509228 defendant Worsley Robert husbandman 630750 630750 Worsley, Robert, of Market Overton, husbandman 0
5514007 2509229 2509229 defendant Worsley Robert husbandman 630750 630750 Worsley, Robert, of Market Overton, husbandman 0
5518146 2510509 2510509 defendant Kyng Miles husbandman 630750 630750 Kyng, Miles, of Market Overton, husbandman 3
5518151 2510510 2510510 defendant Kyng Miles husbandman 630750 630750 Kyng, Miles, of Market Overton, husbandman 3
5611348 2547279 2547279 defendant Lynden Henry   630750 630750 Lynden, Henry, of Market Overton 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);