names

52 rows where place_id = 605535

✎ 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
3661998 1914045 1914045 defendant Bell William laborer 605535 605535 Bell, William, of Yerburgh, laborer 0
4481429 2194884 2194884 defendant Barowe Robert de   605535 605535 Barowe, Robert de, of Yerburgh 0
4508639 2203180 2203180 defendant Straunge Thomas   605535 605535 Straunge, Thomas, of Yerburgh 0
4508643 2203181 2203181 defendant Shepherd Roger   605535 605535 Shepherd, Roger, of Yerburgh 0
4530912 2209962 2209962 plaintiff Palmer William   605535 605535 Palmer, William, of Yerburgh 0
4537085 2211869 2211869 plaintiff Stykenay Roger   605535 605535 Stykenay, Roger, of Yerburgh 0
4606695 2233205 2233205 defendant Palmer Richard   605535 605535 Palmer, Richard, of Yerburgh 3
4761695 2284002 2284002 plaintiff Proctour John   605535 605535 Proctour, John, of Yerburgh, parson 2
4761700 2284003 2284003 plaintiff Proctour John   605535 605535 Proctour, John, of Yerburgh, parson 2
4766814 2285614 2285614 defendant Proctour John   605535 605535 Proctour, John, of Yerburgh, parson 3
4793701 2294145 2294145 plaintiff Palmer Thomas   605535 605535 Palmer, Thomas, of Yerburgh 0
4878463 2320208 2320208 defendant Taillour John tailor 605535 605535 Taillour, John, of Yerburgh, tailor 0
4887184 2322836 2322836 plaintiff Yerburgh Richard   605535 605535 Yerburgh, Richard, of Yerburgh 0
4948615 2341546 2341546 defendant Proctour John clerk 605535 605535 Proctour, John, of Yerburgh, clerk 0
4948638 2341557 2341557 defendant Wolf John weaver 605535 605535 Wolf, John, of Yerburgh, weaver 0
4957392 2344177 2344177 defendant Palmer Richard chaplain 605535 605535 Palmer, Richard, of Yerburgh, chaplain 0
4968312 2347484 2347484 defendant Guny or Enny Thomas husbandman 605535 605535 Guny or Enny, Thomas, of Yerburgh, husbandman 0
4983765 2352072 2352072 defendant Palmer Richard chaplain 605535 605535 Palmer, Richard, of Yerburgh, chaplain 0
5003189 2357834 2357834 plaintiff Palmer Richard chaplain 605535 605535 Palmer, Richard, of Yerburgh, chaplain 0
5038194 2368058 2368058 plaintiff Yerburgh Richard   605535 605535 Yerburgh, Richard, of Yerburgh 0
5061613 2375064 2375064 defendant Jankynson Robert husbandman 605535 605535 Jankynson, Robert, of Yerburgh, husbandman 0
5061614 2375064 2375064 defendant Robertson John husbandman 605535 605535 Robertson, John, of Yerburgh, husbandman 1
5066872 2376620 2376620 plaintiff Yerburgh Richard clerk 605535 605535 Yerburgh, Richard, of Yerburgh, clerk 1
5071890 2378087 2378087 defendant Bolyngbroke Thomas husbandman 605535 605535 Bolyngbroke, Thomas, of Yerburgh, husbandman 1
5105118 2387931 2387931 defendant Yerburgh William gent 605535 605535 Yerburgh, William, of Yerburgh, gent 0
5116561 2391276 2391276 plaintiff Palmer Richard chaplain 605535 605535 Palmer, Richard, of Yerburgh, chaplain 0
5139364 2398002 2398002 defendant Wyles Robert husbandman 605535 605535 Wyles, Robert, of Yerburgh, husbandman 0
5140129 2398213 2398213 plaintiff Stepy Robert (legal representative) 605535 605535 Stepy, Robert, of Yerburgh, parson of St Peter's church, executors of 0
5197089 2414895 2414895 plaintiff (not given) Robert vicar of Stepy 605535 605535 Stepy, Robert, of Yerburgh, parson, & vicar of Hotoft, executors of 0
5209917 2418636 2418636 plaintiff Stepyn Robert (legal representative) 605535 605535 Stepyn, Robert, of Yerburgh, parson of St Peter's church, executors of 0
5276948 2438337 2438337 defendant Gummy or Ginny John husbandman 605535 605535 Gummy or Ginny, John, of Yerburgh, husbandman 0
5276951 2438338 2438338 defendant Gunny John husbandman 605535 605535 Gunny, John, of Yerburgh, husbandman 0
5343136 2458044 2458044 defendant Ratheby Thomas gent 605535 605535 Ratheby, Thomas, of Yerburgh, gent 0
5343138 2458044 2458044 defendant Tayllour Thomas husbandman 605535 605535 Tayllour, Thomas, of Yerburgh, husbandman 2
5376897 2468370 2468370 defendant Ratheby Thomas gent 605535 605535 Ratheby, Thomas, of Yerburgh, gent 0
5376899 2468370 2468370 defendant Taillour Thomas husbandman 605535 605535 Taillour, Thomas, of Yerburgh, husbandman 2
5402668 2475838 2475838 defendant Jakelyn Richard husbandman 605535 605535 Jakelyn, Richard, of Yerburgh, husbandman 0
5402669 2475838 2475838 defendant Skynner Beatrix widow 605535 605535 Skynner, Beatrix, of Yerburgh, widow 1
5402670 2475838 2475838 defendant Mathewe Thomas husbandman 605535 605535 Mathewe, Thomas, of Yerburgh, husbandman 2
5415589 2479606 2479606 defendant Jakelyn Richard husbandman 605535 605535 Jakelyn, Richard, of Yerburgh, husbandman 0
5415590 2479606 2479606 defendant Skynner Beatrice widow 605535 605535 Skynner, Beatrice, of Yerburgh, widow 1
5415591 2479606 2479606 defendant Mathewe Thomas husbandman 605535 605535 Mathewe, Thomas, of Yerburgh, husbandman 2
5444624 2488294 2488294 defendant Bratofte William yeoman 605535 605535 Bratofte, William, of Yerburgh, yeoman 0
5457380 2492107 2492107 defendant Bratofte William yeoman 605535 605535 Bratofte, William, of Yerburgh, yeoman 0
5463689 2494055 2494055 defendant Taillour Thomas husbandman 605535 605535 together with Taillour, Thomas, of Yerburgh, husbandman 1
5463690 2494055 2494055 defendant Ratheby Thomas gent 605535 605535 Ratheby, Thomas, of Yerburgh, gent 2
5468838 2495608 2495608 defendant Bratofte William yeoman 605535 605535 Bratofte, William, of Yerburgh, yeoman 0
5480974 2499264 2499264 defendant Western Richard yeoman 605535 605535 Western, Richard, of Yerburgh, yeoman 2
5546258 2518897 2518897 defendant Melton John husbandman 605535 605535 Melton, John, of Yerburgh, husbandman 1
5555589 2521627 2521627 defendant Mathewe Thomas husbandman 605535 605535 Mathewe, Thomas, of Yerburgh, husbandman 3
5555597 2521628 2521628 defendant Mathewe Thomas husbandman 605535 605535 Mathewe, Thomas, of Yerburgh, husbandman 3
5555605 2521629 2521629 defendant Mathewe Thomas husbandman 605535 605535 Mathewe, Thomas, of Yerburgh, husbandman 3

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);