names

24 rows where place_id = 772928

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4427085 2173292 2173292 plaintiff Pyrot Isabel   772928 772928 Pyrot, Isabel, of Herlyngdon, formerly wife of Roger, son of roger 0
4594748 2229615 2229615 defendant Middelstrete Thomas   772928 772928 Middelstrete, Thomas, of Herlyngdon 0
4594749 2229615 2229615 defendant Mathewe John   772928 772928 Mathewe, John, of Herlyngdon 1
4598633 2230812 2230812 defendant Matheu John   772928 772928 Matheu, John, of Herlyngdon 0
4735625 2276293 2276293 defendant Nasshe John yeoman 772928 772928 Nasshe, John, of Herlyngdon, yeoman 0
4781493 2290222 2290222 defendant Person Peter husbandman 772928 772928 Person, Peter, of Herlyngdon, husbandman 1
4794060 2294275 2294275 defendant Bradwey Richard husbandman 772928 772928 Bradwey, Richard, of Herlyngdon, husbandman 0
4863931 2315694 2315694 defendant Nassh John, senior butcher 772928 772928 Nassh, John, senior, of Herlyngdon, butcher 3
4863936 2315695 2315695 defendant Nassh John, senior butcher 772928 772928 Nassh, John, senior, of Herlyngdon, butcher 3
4870271 2317674 2317674 defendant Perot Thomas husbandman 772928 772928 Perot, Thomas, of Herlyngdon, husbandman 2
4898689 2326240 2326240 defendant Flemmyng Giles laborer 772928 772928 Flemmyng, Giles, of Herlyngdon, laborer 0
4907674 2328968 2328968 plaintiff Acle Edmund   772928 772928 Acle, Edmund, of Herlyngdon, 0
4914646 2331098 2331098 defendant Bloundell John   772928 772928 Bloundell, John, of Herlyngdon 1
4933672 2336908 2336908 defendant Bradweye John husbandman 772928 772928 Bradweye, John, of Herlyngdon, husbandman 0
4935191 2337409 2337409 defendant Lyncolne Richard husbandman 772928 772928 Lyncolne, Richard, of Herlyngdon, husbandman 0
4948107 2341381 2341381 plaintiff Lyncolne Richard   772928 772928 Lyncolne, Richard, of Herlyngdon 0
4948110 2341381 2341381 defendant Skynner John husbandman 772928 772928 Skynner, John, of Herlyngdon, husbandman 2
5013354 2360743 2360743 defendant Lyncoln Richard husbandman 772928 772928 Lyncoln, Richard, of Herlyngdon, husbandman 0
5013356 2360744 2360744 defendant Lyncoln Richard husbandman 772928 772928 Lyncoln, Richard, of Herlyngdon, husbandman 0
5025927 2364478 2364478 plaintiff Kyng John   772928 772928 Kyng, John, of Herlyngdon 0
5316558 2450037 2450037 defendant Blundell John husbandman 772928 772928 Blundell, John, of Herlyngdon, husbandman 0
5316560 2450038 2450038 defendant Blundell John husbandman 772928 772928 Blundell, John, of Herlyngdon, husbandman 0
5465798 2494685 2494685 defendant Blundell John husbandman 772928 772928 Blundell, John, of Herlyngdon, husbandman 2
5585698 2530596 2530596 defendant Lyncoln John husbandman 772928 772928 Lyncoln, John, of Herlyngdon, husbandman 2

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