names

35 rows where place_id = 605143

✎ 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
3660546 1913560 1913560 defendant Norton Richard merchant 605143 605143 Norton, Richard, of Bristoll, merchant 0
3706292 1928255 1928255 defendant Arthur Edmund gent 605143 605143 (Arthur, Edmund, of Bristoll, gent 1
4379620 2157804 2157804 defendant Cradocke William yeoman 605143 605143 Cradocke, William, of Bristoll, yeoman 0
4451272 2185360 2185360 defendant Moys Alexander butcher 605143 605143 Moys, Alexander, of Bristoll, butcher 1
4457205 2187265 2187265 defendant Ledbury Richard   605143 605143 Ledbury, Richard, of Bristoll 0
4466404 2190159 2190159 defendant Waleys William (legal representative) 605143 605143 Waleys, William, of Bristoll, executors of 0
4469893 2191247 2191247 defendant Bokelond Edward   605143 605143 Bokelond, Edward, of Bristoll 0
4470328 2191368 2191368 defendant Stanley Richard   605143 605143 Stanley, Richard, of Bristoll 0
4470591 2191449 2191449 plaintiff Bruton John   605143 605143 Bruton, John, of Bristoll 0
4477676 2193685 2193685 plaintiff Haddon John   605143 605143 Haddon, John, of Bristoll 0
4483495 2195524 2195524 plaintiff Norton Thomas   605143 605143 Norton, Thomas, of BRistoll 0
4483497 2195525 2195525 plaintiff Norton Thomas   605143 605143 Norton, Thomas, of Bristoll 0
4485298 2196105 2196105 plaintiff Pyke Thomas   605143 605143 Pyke, Thomas, of Bristoll 0
4485848 2196280 2196280 plaintiff Robert Richard tailor 605143 605143 Robert, Richard, of Bristoll, tailor 0
4539625 2212655 2212655 defendant Bare John   605143 605143 Bare, John, of Bristoll 1
4547430 2215124 2215124 defendant Myn Richard   605143 605143 Myn, Richard, of Bristoll 0
4560251 2219156 2219156 plaintiff Myne Roger   605143 605143 Myne, Roger, of Bristoll 0
4690304 2262523 2262523 plaintiff West John   605143 605143 West, John, of Bristoll 0
4704379 2266745 2266745 defendant Hopere David fuller 605143 605143 Hopere, David, of Bristoll, fuller 0
4709229 2268254 2268254 plaintiff Payn Walter   605143 605143 Payn, Walter, of Bristoll 0
4721560 2272075 2272075 defendant Salle John jeweller 605143 605143 Salle, John, of Bristoll, jeweller 0
4756798 2282490 2282490 defendant Dyllyng John fuller 605143 605143 Dyllyng, John, of Bristoll, fuller 2
4826919 2304457 2304457 defendant Staumford Thomas gent 605143 605143 Staumford, Thomas, of Bristoll, gent 1
5135825 2396992 2396992 defendant Howell William merchant 605143 605143 Howell, William, of Bristoll, merchant 0
5302786 2445816 2445816 plaintiff Fraye John   605143 605143 Fraye, John, of Bristoll 0
5391816 2472735 2472735 defendant Marchall William dyer 605143 605143 Marchall, William, of Bristoll, dyer 0
5412749 2478763 2478763 plaintiff Esterfeld John merchant 605143 605143 Esterfeld, John, of Bristoll, merchant 0
5413987 2479117 2479117 defendant Parys Thomas mercer 605143 605143 Parys, Thomas, of Bristoll, mercer 0
5422700 2481739 2481739 defendant Colman Richard tanner 605143 605143 Colman, Richard, of Bristoll, tanner 4
5423099 2481866 2481866 defendant Rogers John mercer 605143 605143 Rogers, John, of Bristoll, mercer 0
5424686 2482341 2482341 defendant Rogers John mercer 605143 605143 Rogers, John, of Bristoll, mercer 0
5425560 2482621 2482621 defendant Tyler Nicholas weaver 605143 605143 Tyler, Nicholas, of Bristoll, weaver 0
5455135 2491456 2491456 defendant Box James grocer 605143 605143 Box, James, of Bristoll, grocer 2
5610872 2547117 2547117 plaintiff Beaupyne Thomas   605143 605143 Beaupyne, Thomas, of Bristoll 0
5616314 2548896 2548896 defendant Gloucestre John   605143 605143 Gloucestre, John, of Bristoll 3

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