names

26 rows where place_id = 606837

✎ 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
3666711 1915534 1915534 defendant Ussherwoode Robert yeoman 606837 606837 Ussherwoode, Robert, of Levyngton, yeoman 0
3666712 1915534 1915534 defendant Curteys John yeoman 606837 606837 Curteys, John, of Levyngton, yeoman 1
3769069 1947977 1947977 defendant Warner Thomas husbandman 606837 606837 Warner, Thomas, of Levyngton, husbandman 3
3802708 1958743 1958743 defendant Curtes John yeoman 606837 606837 Curtes, John, of Levyngton, yeoman 0
3836075 1969197 1969197 defendant Warner Thomas husbandman 606837 606837 Warner, Thomas, of Levyngton, husbandman 0
3862286 1977575 1977575 plaintiff Gurnay Katherine (legal representative) 606837 606837 Gurnay, Katherine, of Levyngton, widow, executrix of Gurney, John, of Levyngton, gent, executor of 0
4083743 2054458 2054458 defendant Tylden Thomas yeoman 606837 606837 Tylden, Thomas, of Levyngton, yeoman 0
4491284 2197963 2197963 defendant Keen Richard   606837 606837 Keen, Richard, of Levyngton 1
4498308 2200128 2200128 defendant Genne Richard   606837 606837 Genne, Richard, of Levyngton 2
4549551 2215805 2215805 defendant Gust William   606837 606837 Gust, William, of Levyngton 4
4584536 2226578 2226578 defendant atte Medowe Roger   606837 606837 atte Medowe, Roger, of Levyngton 0
4675719 2258014 2258014 defendant Gray William yeoman 606837 606837 Gray, William, of Levyngton, yeoman 1
4752104 2281097 2281097 defendant Medeweman Walter yeoman 606837 606837 Medeweman, Walter, of Levyngton, yeoman 1
4772677 2287426 2287426 defendant Clerk John   606837 606837 Clerk, John, of Levyngton, holy water clerk 0
4798364 2295676 2295676 defendant Medeweman Walter shipman 606837 606837 Medeweman, Walter, of Levyngton, shipman 1
4829050 2305124 2305124 defendant Croos John yeoman 606837 606837 Croos, John, of Levyngton, yeoman 0
4988551 2353532 2353532 defendant Chacero Robert husbandman 606837 606837 together with Chacero, Robert, of Levyngton, husbandman 1
5074252 2378788 2378788 defendant Reppes Edmund yeoman 606837 606837 Reppes, Edmund, of Levyngton, yeoman 2
5103279 2387390 2387390 defendant Holton John husbandman 606837 606837 Holton, John, of Levyngton, husbandman 0
5140299 2398266 2398266 defendant Holton John farmer 606837 606837 Holton, John, of Levyngton, farmer 0
5210063 2418677 2418677 defendant Holton John farmer 606837 606837 Holton, John, of Levyngton, farmer 0
5424842 2482389 2482389 defendant Lee Walter husbandman 606837 606837 Lee, Walter, of Levyngton, husbandman 0
5491422 2502319 2502319 defendant Sparwe Richard husbandman 606837 606837 Sparwe, Richard, of Levyngton, husbandman 11
5546759 2519055 2519055 defendant Crosby Christopher clerk 606837 606837 Crosby, Christopher, of Levyngton, clerk 1
5560480 2523023 2523023 defendant Curteys John husbandman 606837 606837 Curteys, John, of Levyngton, husbandman 1
5607174 2537133 2537133 defendant Skutt William gent 606837 606837 Skutt, William, of Levyngton, gent 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);