names

40 rows where place_id = 588813

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595679 1866276 1866276 defendant Pescod Richard husbandman 588813 588813 Pescod, Richard, of Themylthorp, husbandman 0
3596351 1866491 1866491 defendant Rydeought Thomas husbandman 588813 588813 Rydeought, Thomas, of Themylthorp, husbandman 0
3596505 1866539 1866539 defendant Mony William yeoman 588813 588813 Mony, William, of Themylthorp, yeoman 0
3603428 1868739 1868739 defendant Mony William (legal representative) 588813 588813 Mony, William, of Themylthorp, yeoman, administrator of 17
3616377 1872759 1872759 defendant Pescod William, junior husbandman 588813 588813 Pescod, William, junior, of Themylthorp, husbandman 7
3664055 1914707 1914707 defendant Pestod Thomas husbandman 588813 588813 Pestod, Thomas, of Themylthorp, husbandman 0
3664056 1914707 1914707 defendant Pestod Richard husbandman 588813 588813 Pestod, Richard, of Themylthorp, husbandman 1
3718545 1932079 1932079 defendant Money Thomas husbandman 588813 588813 Money, Thomas, of Themylthorp, husbandman 0
4639078 2242949 2242949 plaintiff Clerk Robert   588813 588813 Clerk, Robert, of Themylthorp 0
4972321 2348661 2348661 defendant Rydoute John husbandman 588813 588813 Rydoute, John, of Themylthorp, husbandman 1
4978299 2350458 2350458 defendant Dyn John husbandman 588813 588813 Dyn, John, of Themylthorp, husbandman 0
4978300 2350458 2350458 defendant Themylthorp William husbandman 588813 588813 Themylthorp, William, of Themylthorp, husbandman 1
5032262 2366314 2366314 defendant Heyg Thomas husbandman 588813 588813 Heyg, Thomas, of Themylthorp, husbandman 0
5032263 2366314 2366314 defendant Cambrygge John laborer 588813 588813 Cambrygge, John, of Themylthorp, laborer 1
5032264 2366314 2366314 defendant Pescod John husbandman 588813 588813 Pescod, John, of Themylthorp, husbandman 2
5032265 2366314 2366314 defendant Hawne John husbandman 588813 588813 Hawne, John, of Themylthorp, husbandman 3
5064243 2375851 2375851 defendant Themylthorp William yeoman 588813 588813 Themylthorp, William, of Themylthorp, yeoman 0
5064244 2375851 2375851 defendant Rydeout John husbandman 588813 588813 Rydeout, John, of Themylthorp, husbandman 1
5071304 2377912 2377912 defendant Rydoute Robert clerk 588813 588813 Rydoute, Robert, of Themylthorp, clerk 4
5084795 2381957 2381957 defendant Rydowte Thomas clerk 588813 588813 Rydowte, Thomas, of Themylthorp, clerk 0
5087268 2382656 2382656 defendant Rydeout John yeoman 588813 588813 Rydeout, John, of Themylthorp, yeoman 0
5095166 2385001 2385001 defendant Rydowete John husbandman 588813 588813 Rydowete, John, of Themylthorp, husbandman 2
5100008 2386440 2386440 defendant Rydhewte John husbandman 588813 588813 Rydhewte, John, of Themylthorp, husbandman 2
5112060 2389913 2389913 defendant Rydeout John yeoman 588813 588813 Rydeout, John, of Themylthorp, yeoman 0
5139850 2398130 2398130 defendant Rydonte Robert clerk 588813 588813 Rydonte, Robert, of Themylthorp, clerk 3
5160815 2404258 2404258 defendant Rydowte Robert clerk 588813 588813 Rydowte, Robert, of Themylthorp, clerk 1
5166151 2405830 2405830 defendant Rydowt Robert   588813 588813 Rydowt, Robert, of Themylthorp, parson & clerk 4
5359275 2462938 2462938 defendant Mony William butcher 588813 588813 Mony, William, of Themylthorp, butcher 0
5411299 2478338 2478338 defendant Mony Agnes widow 588813 588813 Mony, Agnes, of Themylthorp, widow 0
5450614 2490064 2490064 defendant Mony William husbandman 588813 588813 Mony, William, of Themylthorp, husbandman 3
5461963 2493519 2493519 defendant Mony William husbandman 588813 588813 Mony, William, of Themylthorp, husbandman 3
5465963 2494746 2494746 defendant Mony William husbandman 588813 588813 Mony, William, of Themylthorp, husbandman 3
5491218 2502267 2502267 defendant Haughe Henry husbandman 588813 588813 Haughe, Henry, of Themylthorp, husbandman 3
5499168 2504700 2504700 defendant Mony William yeoman 588813 588813 Mony, William, of Themylthorp, yeoman 0
5512833 2508869 2508869 plaintiff Monde John   588813 588813 Monde, John, of Themylthorp 0
5512834 2508869 2508869 defendant Ridout John, junior yeoman 588813 588813 Ridout, John, junior, of Themylthorp, yeoman 0
5520665 2511286 2511286 defendant Pested John butcher 588813 588813 Pested, John, of Themylthorp, butcher 1
5581182 2529182 2529182 defendant Foxe Robert (legal representative) 588813 588813 Foxe, Robert, of Themylthorp, executors of 0
5591505 2532317 2532317 defendant Brese Reginald husbandman 588813 588813 Brese, Reginald, of Themylthorp, husbandman 0
5603729 2536035 2536035 defendant Brese Roger husbandman 588813 588813 Brese, Roger, of Themylthorp, husbandman 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);