names

26 rows where place_id = 623039

✎ 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
3750358 1942031 1942031 plaintiff Lewkenor Humphrey esq 623039 623039 Lewkenor, Humphrey, of Leghe, esq 0
3861817 1977413 1977413 defendant Meycok James miner 623039 623039 Meycok, James, of Leghe, miner 1
4415328 2169689 2169689 defendant Corbert Roger   623039 623039 Corbert, Roger, of Leghe 1
4493134 2198556 2198556 plaintiff atte Leghe Thomas   623039 623039 atte Leghe, Thomas, of Leghe 0
4509482 2203434 2203434 plaintiff atte Leghe Thomas   623039 623039 atte Leghe, Thomas, of Leghe 0
4515071 2205124 2205124 plaintiff Chanewe Thomas   623039 623039 Chanewe, Thomas, of Leghe 0
4515073 2205125 2205125 plaintiff Chanewe Thomas   623039 623039 Chanewe, Thomas, of Leghe 0
4515075 2205126 2205126 plaintiff Chanewe Thomas   623039 623039 Chanewe, Thomas, of Leghe 0
4515077 2205127 2205127 plaintiff Chanewe Thomas   623039 623039 Chanewe, Thomas, of Leghe 0
4515078 2205127 2205127 defendant Wrynge William   623039 623039 Wrynge, William, of Leghe 0
4518712 2206227 2206227 defendant atte Nassh John   623039 623039 atte Nassh, John, of Leghe 0
4553505 2217027 2217027 defendant Wiherst William butcher 623039 623039 Wiherst, William, of Leghe, butcher 0
4571492 2222663 2222663 defendant Wykherst John   623039 623039 Wykherst, John, of Leghe 0
4584611 2226606 2226606 defendant Bechere Walter   623039 623039 Bechere, Walter, of Leghe 0
4624047 2238498 2238498 defendant Petyt Richard   623039 623039 Petyt, Richard, of Leghe 0
4626251 2239170 2239170 defendant Wykherst William   623039 623039 Wykherst, William, of Leghe 0
4642181 2243827 2243827 defendant Claydon Thomas   623039 623039 Claydon, Thomas, of Leghe 0
4651163 2246368 2246368 defendant Wikherst John butcher 623039 623039 Wikherst, John, of Leghe, butcher 1
4674962 2257777 2257777 defendant Roger William smith 623039 623039 Roger, William, of Leghe, smith 0
4689454 2262258 2262258 defendant Wykherst William butcher 623039 623039 Wykherst, William, of Leghe, butcher 0
4750287 2280561 2280561 defendant Dalevache Philip butcher 623039 623039 Dalevache, Philip, of Leghe, butcher 0
4788123 2292358 2292358 defendant Malverne John husbandman 623039 623039 Malverne, John, of Leghe, husbandman 0
5623836 2551398 2551398 defendant Polle John yeoman 623039 623039 Polle, John, of Leghe, yeoman 0
5623837 2551398 2551398 defendant Polle Peter yeoman 623039 623039 together with Polle, Peter, of Leghe, yeoman 1
5623839 2551399 2551399 defendant Polle John   623039 623039 Polle, John, of Leghe 0
5623840 2551399 2551399 defendant Polle Peter yeoman 623039 623039 together with, Polle, Peter, of Leghe, yeoman 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);