names

44 rows where place_id = 602623

✎ 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
3599597 1867511 1867511 plaintiff Baudewyn John   602623 602623 Baudewyn, John, of Denford, mason 1
3650947 1910666 1910666 defendant Wolrige Henry husbandman 602623 602623 Wolrige, Henry, of Denford, husbandman 3
3670807 1916833 1916833 defendant Byrkyn William husbandman 602623 602623 Byrkyn, William, of Denford, husbandman 1
3683048 1920811 1920811 defendant Salysbury John miller 602623 602623 Salysbury, John, of Denford, miller 0
3861308 1977253 1977253 defendant Cookys William husbandman 602623 602623 Cookys, William, of Denford, husbandman 0
3861310 1977254 1977254 defendant Cookys William husbandman 602623 602623 Cookys, William, of Denford, husbandman 0
3952762 2008040 2008040 plaintiff Hopkyns Thomas yeoman 602623 602623 Hopkyns, Thomas, of Denford, yeoman 0
3952764 2008040 2008040 defendant Ward John gent 602623 602623 Ward, John, of Denford, gent 0
3962003 2011295 2011295 plaintiff Ward John (legal representative) 602623 602623 Ward, John, of Denford, ´ junior, of Staughton Magna, Hunts, gent, son of Thomas Wanton or Wauton, executrix of 0
3996508 2023510 2023510 defendant Newman Henry husbandman 602623 602623 Newman, Henry, of Denford, husbandman 0
4274143 2120898 2120898 defendant Freman Nicholas yeoman 602623 602623 Freman, Nicholas, of Denford, yeoman 0
4274145 2120899 2120899 defendant Good Thomas yeoman 602623 602623 Good, Thomas, of Denford, yeoman 0
4449640 2184836 2184836 plaintiff Goteham William   602623 602623 Goteham, William, of Denford, parson 0
4449643 2184837 2184837 defendant Amcotes Thomas de   602623 602623 Amcotes, Thomas de, of Denford, parson 0
4554271 2217260 2217260 defendant Skyppier Walter   602623 602623 Skyppier, Walter, of Denford 0
4572092 2222829 2222829 defendant Tunne John   602623 602623 Tunne, John, of Denford 2
4584577 2226593 2226593 defendant Wardale John   602623 602623 Wardale, John, of Denford 1
4584580 2226593 2226593 defendant Whitlyng Robert   602623 602623 Whitlyng, Robert, of Denford 4
4584845 2226689 2226689 defendant Skippere Walter   602623 602623 Skippere, Walter, of Denford 0
4584847 2226689 2226689 defendant Whitlyng Robert   602623 602623 Whitlyng, Robert, of Denford 2
4597394 2230428 2230428 defendant Duffyn Robert (legal representative) 602623 602623 Duffyn, Robert, of Denford, executors of 0
4597395 2230428 2230428 defendant Duffyn Robert   602623 602623 (Duffyn, Robert, of Denford, son of Robert 1
4612591 2235004 2235004 plaintiff Coventry William   602623 602623 Coventry, William, of Denford 0
4655024 2247454 2247454 defendant Burre Richard   602623 602623 Burre, Richard, of Denford, mason 0
4658457 2248527 2248527 plaintiff Coventre William   602623 602623 Coventre, William, of Denford 0
4792548 2293759 2293759 defendant Cottee Rpbert husbandman 602623 602623 Cottee, Rpbert, of Denford, husbandman 1
4792549 2293759 2293759 defendant Drayton Thomas husbandman 602623 602623 Drayton, Thomas, of Denford, husbandman 2
4903013 2327556 2327556 defendant Whitlyng John husbandman 602623 602623 Whitlyng, John, of Denford, husbandman 0
4957817 2344309 2344309 defendant Rokby William yeoman 602623 602623 Rokby, William, of Denford, yeoman 0
4959519 2344812 2344812 defendant Gybson Robert husbandman 602623 602623 Gybson, Robert, of Denford, husbandman 0
4959520 2344812 2344812 defendant Cotty Robert husbandman 602623 602623 Cotty, Robert, of Denford, husbandman 1
4959521 2344812 2344812 defendant Denys Thomas husbandman 602623 602623 Denys, Thomas, of Denford, husbandman 2
4959522 2344812 2344812 defendant Drayton Thomas husbandman 602623 602623 Drayton, Thomas, of Denford, husbandman 3
4971071 2348287 2348287 defendant Rokeby William gent 602623 602623 Rokeby, William, of Denford, gent 0
4986204 2352801 2352801 defendant Cost_ Robert husbandman 602623 602623 Cost_, Robert, of Denford, husbandman 1
4986206 2352801 2352801 defendant Denys Thomas husbandman 602623 602623 Denys, Thomas, of Denford, husbandman 3
4988584 2353543 2353543 defendant Duffyn Robert husbandman 602623 602623 Duffyn, Robert, of Denford, husbandman 1
5013277 2360717 2360717 defendant Cotty Robert husbandman 602623 602623 Cotty, Robert, of Denford, husbandman 0
5041942 2369189 2369189 defendant Rokeby William yeoman 602623 602623 Rokeby, William, of Denford, yeoman 0
5065288 2376158 2376158 defendant Mychell John miller 602623 602623 Mychell, John, of Denford, miller 0
5084589 2381903 2381903 defendant Mulkus Thomas   602623 602623 Mulkus, Thomas, of Denford, mason 0
5322093 2451680 2451680 defendant Porter Thomas miller 602623 602623 Porter, Thomas, of Denford, miller 2
5358962 2462852 2462852 defendant Porter Thomas miller 602623 602623 Porter, Thomas, of Denford, miller 1
5521250 2511464 2511464 defendant Ward John husbandman 602623 602623 Ward, John, of Denford, husbandman 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);