names

43 rows where place_id = 591506

✎ 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
3604585 1869097 1869097 defendant Willyham John husbandman 591506 591506 Willyham, John, of Kelshull, husbandman 1
3604586 1869097 1869097 defendant Wyllyham Thomas husbandman 591506 591506 Wyllyham, Thomas, of Kelshull, husbandman 2
3609379 1870593 1870593 defendant Wenham William husbandman 591506 591506 Wenham, William, of Kelshull, husbandman 0
3609381 1870594 1870594 defendant Wyllyham John husbandman 591506 591506 Wyllyham, John, of Kelshull, husbandman 0
3613529 1871880 1871880 defendant Wyllymot Simon husbandman 591506 591506 Wyllymot, Simon, of Kelshull, husbandman 0
3613530 1871880 1871880 defendant Wennam William husbandman 591506 591506 Wennam, William, of Kelshull, husbandman 1
3613531 1871880 1871880 defendant Wylliams William husbandman 591506 591506 Wylliams, William, of Kelshull, husbandman 2
3613532 1871880 1871880 defendant Thomlyn Richard husbandman 591506 591506 Thomlyn, Richard, of Kelshull, husbandman 3
3648521 1909936 1909936 defendant Wyllyams John husbandman 591506 591506 Wyllyams, John, of Kelshull, husbandman 0
3648522 1909936 1909936 defendant Peneke Thomas husbandman 591506 591506 Peneke, Thomas, of Kelshull, husbandman 1
3649866 1910322 1910322 defendant Tomkyn Robert husbandman 591506 591506 Tomkyn, Robert, of Kelshull, husbandman 0
3653695 1911418 1911418 defendant Pynnok Thomas husbandman 591506 591506 Pynnok, Thomas, of Kelshull, husbandman 3
3654427 1911647 1911647 defendant Cormonger Robert gent 591506 591506 Cormonger, Robert, of Kelshull, gent 0
3668456 1916086 1916086 defendant Cormonger Robert yeoman 591506 591506 Cormonger, Robert, of Kelshull, yeoman 0
3670275 1916650 1916650 defendant Cormonger Robert gent 591506 591506 Cormonger, Robert, of Kelshull, gent 0
3695397 1924784 1924784 defendant Tomlyn Robert husbandman 591506 591506 Tomlyn, Robert, of Kelshull, husbandman 0
3729223 1935390 1935390 defendant Willyams Thomas husbandman 591506 591506 Willyams, Thomas, of Kelshull, husbandman 0
3786685 1953630 1953630 plaintiff Preeste John   591506 591506 Preeste, John, of Kelshull 0
3792555 1955529 1955529 defendant Preest John butcher 591506 591506 Preest, John, of Kelshull, butcher 0
3801861 1958478 1958478 defendant Preest John butcher 591506 591506 Preest, John, of Kelshull, butcher 2
3809083 1960725 1960725 defendant Preest John butcher 591506 591506 Preest, John, of Kelshull, butcher 0
4105410 2062214 2062214 defendant Tomlynge Robert yeoman 591506 591506 Tomlynge, Robert, of Kelshull, yeoman 0
4105411 2062214 2062214 defendant Adcock William   591506 591506 Adcock, William, of Kelshull yeoman 1
4686240 2261297 2261297 defendant Cully John clerk 591506 591506 Cully, John, of Kelshull, clerk 0
4988994 2353645 2353645 defendant Catmere William husbandman 591506 591506 Catmere, William, of Kelshull, husbandman 1
5052838 2372438 2372438 plaintiff at Dane Richard   591506 591506 at Dane, Richard, of Kelshull 0
5152425 2401840 2401840 defendant Wyllyam William husbandman 591506 591506 Wyllyam, William, of Kelshull, husbandman 2
5170207 2407014 2407014 defendant Wyllyam William husbandman 591506 591506 Wyllyam, William, of Kelshull, husbandman 2
5187687 2412116 2412116 defendant Willyam William husbandman 591506 591506 Willyam, William, of Kelshull, husbandman 2
5219288 2421364 2421364 defendant Wolmare John husbandman 591506 591506 Wolmare, John, of Kelshull, husbandman 1
5219289 2421364 2421364 defendant Wyne John husbandman 591506 591506 Wyne, John, of Kelshull, husbandman 2
5219290 2421364 2421364 defendant Spycere Geoffrey husbandman 591506 591506 Spycere, Geoffrey, of Kelshull, husbandman 3
5219295 2421365 2421365 defendant Wolmare John husbandman 591506 591506 Wolmare, John, of Kelshull, husbandman 1
5219296 2421365 2421365 defendant Wyne John husbandman 591506 591506 Wyne, John, of Kelshull, husbandman 2
5219297 2421365 2421365 defendant Spycere Geoffrey husbandman 591506 591506 Spycere, Geoffrey, of Kelshull, husbandman 3
5349240 2459892 2459892 defendant Bolnest Waren husbandman 591506 591506 Bolnest, Waren, of Kelshull, husbandman 0
5488847 2501538 2501538 defendant Williams Thomas husbandman 591506 591506 Williams, Thomas, of Kelshull, husbandman 1
5499586 2504822 2504822 defendant William William husbandman 591506 591506 William, William, of Kelshull, husbandman 1
5499589 2504822 2504822 defendant William Thomas laborer 591506 591506 William, Thomas, of Kelshull, laborer 4
5518312 2510555 2510555 plaintiff Wyllymot Simon   591506 591506 Wyllymot, Simon, of Kelshull 0
5518314 2510555 2510555 defendant Bolnesse Waren husbandman 591506 591506 Bolnesse, Waren, of Kelshull, husbandman 1
5591206 2532224 2532224 defendant Gery Richard gent 591506 591506 Gery, Richard, of Kelshull, gent 1
5591212 2532225 2532225 defendant Gery Richard gent 591506 591506 Gery, Richard, of Kelshull, gent 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);