names

21 rows where place_id = 626173

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3768443 1947778 1947778 defendant Rosse Miles husbandman 626173 626173 Rosse, Miles, of Ofham, husbandman 0
4530618 2209872 2209872 defendant Spryng John   626173 626173 Spryng, John, of Ofham, mason 0
4672897 2257164 2257164 defendant Wymark Thomas butcher 626173 626173 Wymark, Thomas, of Ofham, butcher 1
4702098 2266065 2266065 defendant Palmere Simon husbandman 626173 626173 Palmere, Simon, of Ofham, husbandman 0
4703762 2266557 2266557 defendant Mannyng John clerk 626173 626173 Mannyng, John, of Ofham, clerk 2
4907249 2328831 2328831 defendant atte Hale William butcher 626173 626173 atte Hale, William, of Ofham, butcher 0
4956581 2343923 2343923 defendant Stouperisfeld Robert laborer 626173 626173 Stouperisfeld, Robert, of Ofham, laborer 0
4966607 2346946 2346946 defendant Hale William husbandman 626173 626173 Hale, William, of Ofham, husbandman 0
4966610 2346946 2346946 defendant Palmer John husbandman 626173 626173 Palmer, John, of Ofham, husbandman 3
4966611 2346946 2346946 defendant Palmer Peter husbandman 626173 626173 Palmer, Peter, of Ofham, husbandman 4
4994909 2355330 2355330 defendant atte Hale William husbandman 626173 626173 atte Hale, William, of Ofham, husbandman 0
5025201 2364265 2364265 defendant Parker Henry husbandman 626173 626173 Parker, Henry, of Ofham, husbandman 0
5025202 2364265 2364265 defendant Sprynget John husbandman 626173 626173 Sprynget, John, of Ofham, husbandman 1
5027550 2364936 2364936 defendant Northfolk John husbandman 626173 626173 Northfolk, John, of Ofham, husbandman 1
5047748 2370941 2370941 defendant Knyght John butcher 626173 626173 Knyght, John, of Ofham, butcher 3
5059559 2374429 2374429 defendant Denman Simon chandler 626173 626173 Denman, Simon, of Ofham, chandler 0
5231727 2424848 2424848 defendant Palmer John husbandman 626173 626173 Palmer, John, of Ofham, husbandman 1
5513500 2509068 2509068 defendant Holbeme John tailor 626173 626173 Holbeme, John, of Ofham, tailor 0
5528070 2513344 2513344 defendant Parker John husbandman 626173 626173 Parker, John, of Ofham, husbandman 0
5528071 2513344 2513344 defendant Parker William husbandman 626173 626173 Parker, William, of Ofham, husbandman 1
5528072 2513344 2513344 defendant Bested Edward smith 626173 626173 Bested, Edward, of Ofham, smith 2

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