names

49 rows where place_id = 609917

✎ 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
3681033 1920143 1920143 defendant Newe John dyer 609917 609917 Newe, John, of Briggenorth, dyer 2
3765829 1946977 1946977 defendant Hadnall Thomas dyer 609917 609917 Hadnall, Thomas, of Briggenorth, dyer 4
3792659 1955562 1955562 defendant Langley Richard chapman 609917 609917 Langley, Richard, of Briggenorth, chapman 2
3792677 1955565 1955565 defendant Langley Richard chapman 609917 609917 Langley, Richard, of Briggenorth, chapman 2
3928734 1999947 1999947 defendant Capper Thomas water man 609917 609917 Capper, Thomas, of Briggenorth, water man 0
4420291 2171248 2171248 defendant Dod Simon   609917 609917 Dod, Simon, of Briggenorth 0
4460609 2188377 2188377 plaintiff Skynner Thomas (legal representative) 609917 609917 Skynner, Thomas, of Briggenorth, executors of 0
4460614 2188378 2188378 plaintiff Skynner Thomas (legal representative) 609917 609917 Skynner, Thomas, of Briggenorth, executors of 0
4523602 2207706 2207706 defendant Irlond Richard   609917 609917 Irlond, Richard, of Briggenorth 0
4547314 2215092 2215092 plaintiff Bussheley William   609917 609917 Bussheley, William, of Briggenorth 0
4547316 2215092 2215092 defendant Dalycote William   609917 609917 Dalycote, William, of Briggenorth 1
4547317 2215092 2215092 defendant Rokmardon John   609917 609917 Rokmardon, John, of Briggenorth 2
4554312 2217276 2217276 defendant Cardemaker Stephen   609917 609917 Cardemaker, Stephen, of Briggenorth 0
4554333 2217284 2217284 defendant Webbe Robert   609917 609917 Webbe, Robert, of Briggenorth 1
4554334 2217284 2217284 defendant Prikebrond Walter   609917 609917 Prikebrond, Walter, of Briggenorth 2
4554335 2217284 2217284 defendant Willys John   609917 609917 Willys, John, of Briggenorth 3
4554336 2217284 2217284 defendant Fauconer Robert   609917 609917 Fauconer, Robert, of Briggenorth 4
4554337 2217284 2217284 defendant Stretton William   609917 609917 Stretton, William, of Briggenorth 5
4554338 2217284 2217284 defendant Kene John   609917 609917 Kene, John, of Briggenorth 6
4554341 2217285 2217285 defendant Parker John   609917 609917 Parker, John, of Briggenorth 1
4554342 2217285 2217285 defendant Boys Roger   609917 609917 Boys, Roger, of Briggenorth 2
4554343 2217285 2217285 defendant Codyngton Thomas   609917 609917 Codyngton, Thomas, of Briggenorth 3
4564668 2220512 2220512 defendant Bernard Ralph   609917 609917 Bernard, Ralph, of Briggenorth 0
4571555 2222682 2222682 defendant Adamys John   609917 609917 Adamys, John, of Briggenorth 3
4584881 2226703 2226703 plaintiff Grene Hugh   609917 609917 Grene, Hugh, of Briggenorth 0
4628993 2239993 2239993 defendant Baker John   609917 609917 Baker, John, of Briggenorth 3
4734882 2276067 2276067 defendant Adammes John yeoman 609917 609917 Adammes, John, of Briggenorth, yeoman 3
4804014 2297438 2297438 defendant Clerk Thomas yeoman 609917 609917 Clerk, Thomas, of Briggenorth, yeoman 0
4812253 2299948 2299948 defendant Owayn William tanner 609917 609917 Owayn, William, of Briggenorth, tanner 1
4822113 2302995 2302995 defendant Sodyn Geoffrey yeoman 609917 609917 Sodyn, Geoffrey, of Briggenorth, yeoman 1
4822124 2302997 2302997 defendant Sodym Geoffrey yeoman 609917 609917 Sodym, Geoffrey, of Briggenorth, yeoman 1
4932364 2336518 2336518 defendant Lyney or Lyvey Elizabeth widow 609917 609917 Lyney or Lyvey, Elizabeth, of Briggenorth, widow 0
4932365 2336518 2336518 defendant Cronke Nicholas husbandman 609917 609917 Cronke, Nicholas, of Briggenorth, husbandman 1
4932366 2336518 2336518 defendant Wode John cooper 609917 609917 Wode, John, of Briggenorth, cooper 2
4943402 2339907 2339907 defendant Croweke Nicholas husbandman 609917 609917 Croweke, Nicholas, of Briggenorth, husbandman 0
5034702 2367005 2367005 defendant Parsons John yeoman 609917 609917 Parsons, John, of Briggenorth, yeoman 1
5034703 2367005 2367005 defendant Cardmaker John yeoman 609917 609917 Cardmaker, John, of Briggenorth, yeoman 2
5034704 2367005 2367005 defendant Chirke Richard cordwainer 609917 609917 Chirke, Richard, of Briggenorth, cordwainer 3
5040412 2368736 2368736 plaintiff Bruyn John, senior (legal representative) 609917 609917 Bruyn, John, senior, of Briggenorth, administrator of 0
5041907 2369178 2369178 defendant Persons Thomas chapman 609917 609917 Persons, Thomas, of Briggenorth, chapman 0
5041908 2369178 2369178 defendant Persons William chapman 609917 609917 Persons, William, of Briggenorth, chapman 1
5075074 2379047 2379047 defendant Wode John butcher 609917 609917 Wode, John, of Briggenorth, butcher 0
5075075 2379047 2379047 defendant Hullyns William weaver 609917 609917 Hullyns, William, of Briggenorth, weaver 1
5080952 2380799 2380799 defendant Yonge John   609917 609917 Yonge, John, of Briggenorth, yeoman, bailiff of Munslowe hundred 0
5113868 2390445 2390445 defendant Carpenter John carpenter 609917 609917 Carpenter, John, of Briggenorth, carpenter 0
5376147 2468131 2468131 defendant Wryght John   609917 609917 Wryght, John, of Briggenorth, hostel keeper 2
5386518 2471212 2471212 defendant Wyrley Robert draper 609917 609917 Wyrley, Robert, of Briggenorth, draper 1
5405365 2476615 2476615 defendant Wryght John hosteler 609917 609917 Wryght, John, of Briggenorth, hosteler 2
5608611 2537592 2537592 defendant Wyrley Robert draper 609917 609917 Wyrley, Robert, of Briggenorth, draper 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);