names

32 rows where place_id = 720420

✎ 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
4234544 2107627 2107627 defendant Beatinf John yeoman 720420 720420 Beatinf, John, of Alesby, yeoman 1
4240186 2109689 2109689 defendant Johnson George joiner 720420 720420 Johnson, George, of Alesby, joiner 3
4282694 2123851 2123851 defendant Robinsonne Thomas husbandman 720420 720420 Robinsonne, Thomas, of Alesby, husbandman 0
4450702 2185178 2185178 defendant Caburn William de   720420 720420 Caburn, William de, of Alesby 1
4451395 2185407 2185407 defendant Joce John   720420 720420 Joce, John, of Alesby 0
4516759 2205647 2205647 defendant Martyn John   720420 720420 Martyn, John, of Alesby, parson 0
4537580 2212027 2212027 defendant Smyth Robert   720420 720420 Smyth, Robert, of Alesby 2
4588090 2227673 2227673 defendant Alaynson John   720420 720420 Alaynson, John, of Alesby 0
4597658 2230518 2230518 defendant Martyn John   720420 720420 Martyn, John, of Alesby, parson 0
4597659 2230518 2230518 defendant Martyn William   720420 720420 Martyn, William, of Alesby 1
4609685 2234126 2234126 defendant Loweson Henry   720420 720420 Loweson, Henry, of Alesby 0
4624466 2238636 2238636 plaintiff Neweton John   720420 720420 Neweton, John, of Alesby 0
4626923 2239366 2239366 defendant Trewelofe John   720420 720420 Trewelofe, John, of Alesby 2
4644410 2244455 2244455 defendant Loweson Henry   720420 720420 Loweson, Henry, of Alesby 4
4671314 2256677 2256677 defendant Marty William yeoman 720420 720420 Marty, William, of Alesby, yeoman 1
4731668 2275099 2275099 defendant Plummer Robert husbandman 720420 720420 Plummer, Robert, of Alesby, husbandman 0
4756376 2282359 2282359 plaintiff Burett Thomas clerk & parson 720420 720420 Burett, Thomas, of Alesby, clerk & parson 1
4827905 2304783 2304783 defendant Henryson William husbandman 720420 720420 Henryson, William, of Alesby, husbandman 2
4842552 2309208 2309208 defendant Gleston Roger   720420 720420 Gleston, Roger, of Alesby, parson 1
4939299 2338672 2338672 defendant Abbot Thomas husbandman 720420 720420 Abbot, Thomas, of Alesby, husbandman 0
4965007 2346450 2346450 defendant Pylbarowe Robert laborer 720420 720420 Pylbarowe, Robert, of Alesby, laborer 0
5018357 2362255 2362255 defendant Wower John husbandman 720420 720420 Wower, John, of Alesby, husbandman 0
5032106 2366262 2366262 defendant Brewster Walter husbandman 720420 720420 Brewster, Walter, of Alesby, husbandman 0
5091121 2383798 2383798 defendant Strangman Robert merchant 720420 720420 Strangman, Robert, of Alesby, merchant 1
5108752 2388996 2388996 defendant Parke Thomas yeoman 720420 720420 Parke, Thomas, of Alesby, yeoman 1
5128709 2394880 2394880 defendant Ralke William   720420 720420 Ralke, William, of Alesby 1
5147905 2400530 2400530 defendant Rakke William husbandman 720420 720420 Rakke, William, of Alesby, husbandman 1
5187346 2412025 2412025 defendant Whithede Adam husbandman 720420 720420 Whithede, Adam, of Alesby, husbandman 0
5187347 2412025 2412025 defendant Astyn Richard husbandman 720420 720420 Astyn, Richard, of Alesby, husbandman 1
5220839 2421787 2421787 defendant Redesdale Thomas weaver 720420 720420 Redesdale, Thomas, of Alesby, weaver 0
5536131 2515792 2515792 defendant Burton Robert weaver 720420 720420 Burton, Robert, of Alesby, weaver 4
5552143 2520669 2520669 defendant Messynden Robert gent 720420 720420 Messynden, Robert, of Alesby, 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);