names

25 rows where place_id = 764367

✎ 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
4505281 2202181 2202181 plaintiff Smyth Richard   764367 764367 Smyth, Richard, of Tudele 0
4534275 2210986 2210986 defendant Watte Thomas   764367 764367 Watte, Thomas, of Tudele 0
4535643 2211424 2211424 plaintiff Smyth Richard   764367 764367 Smyth, Richard, of Tudele 0
4667732 2255620 2255620 defendant Cardenell Roger shoemaker 764367 764367 Cardenell, Roger, of Tudele, shoemaker 0
4752526 2281197 2281197 defendant Judde Godefrey butcher 764367 764367 Judde, Godefrey, of Tudele, butcher 0
4769099 2286316 2286316 defendant Stolde John laborer 764367 764367 Stolde, John, of Tudele, laborer 5
4769100 2286316 2286316 defendant Godesday Nicholas laborer 764367 764367 Godesday, Nicholas, of Tudele, laborer 6
4793641 2294123 2294123 defendant Godesday Nicholas laborer 764367 764367 Godesday, Nicholas, of Tudele, laborer 3
4900308 2326730 2326730 defendant Bokesell Richard carpenter 764367 764367 Bokesell, Richard, of Tudele, carpenter 1
4906827 2328719 2328719 defendant Bokesell Richard carpenter 764367 764367 Bokesell, Richard, of Tudele, carpenter 1
4912035 2330267 2330267 defendant Byrch Richard thatcher 764367 764367 Byrch, Richard, of Tudele, thatcher 1
4996090 2355688 2355688 defendant Loder John   764367 764367 Loder, John, of Tudele, mason 0
5027532 2364930 2364930 defendant Arnold William husbandman 764367 764367 Arnold, William, of Tudele, husbandman 0
5055736 2373286 2373286 defendant Arnold William butcher 764367 764367 Arnold, William, of Tudele, butcher 0
5058230 2374019 2374019 defendant Arnold William husbandman 764367 764367 Arnold, William, of Tudele, husbandman 0
5078896 2380173 2380173 defendant Arnold William bytrcher 764367 764367 Arnold, William, of Tudele, bytrcher 0
5088606 2383043 2383043 defendant Watte John laborer 764367 764367 Watte, John, of Tudele, laborer 0
5098986 2386133 2386133 defendant Stylde John husbandman 764367 764367 Stylde, John, of Tudele, husbandman 2
5103945 2387579 2387579 defendant Arnold William butcher 764367 764367 Arnold, William, of Tudele, butcher 0
5251875 2430696 2430696 plaintiff Arnold William husbandman 764367 764367 Arnold, William, of Tudele, husbandman 0
5294514 2443372 2443372 defendant Carnell or Carvell Thomas laborer 764367 764367 Carnell or Carvell, Thomas, of Tudele, laborer 1
5326676 2453048 2453048 plaintiff Stydulphe Henry   764367 764367 Stydulphe, Henry, of Tudele 0
5327006 2453155 2453155 defendant Stydolf Henry husbandman 764367 764367 Stydolf, Henry, of Tudele, husbandman 0
5503336 2505954 2505954 plaintiff Watts Henry (legal representative) 764367 764367 Watts, Henry, of Tudele, executors of 0
5527340 2513131 2513131 defendant Dykson Thomas clothier 764367 764367 Dykson, Thomas, of Tudele, clothier 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);