names

22 rows where place_id = 694371

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4104138 2061754 2061754 defendant Pyerde Alexander tucker 694371 694371 Pyerde, Alexander, of Rode, Soms, tucker 1
4520169 2206643 2206643 defendant Hopere William   694371 694371 Hopere, William, of Rode, Soms 2
4696555 2264398 2264398 defendant Payne Thomas weaver 694371 694371 Payne, Thomas, of Rode, Soms, weaver 0
4714241 2269784 2269784 defendant Payne Thomas husbandman 694371 694371 Payne, Thomas, of Rode, Soms, husbandman 1
4715594 2270205 2270205 defendant Berwe John husbandman 694371 694371 Berwe, John, of Rode, Soms, husbandman 2
4715649 2270223 2270223 defendant Berwe John husbandman 694371 694371 Berwe, John, of Rode, Soms, husbandman 2
4725618 2273299 2273299 defendant Torney Walter weaver 694371 694371 Torney, Walter, of Rode, Soms, weaver 0
4732517 2275344 2275344 defendant Payn Thomas   694371 694371 Payn, Thomas, of Rode, Soms, wool man 0
4762681 2284307 2284307 defendant Payn John husbandman 694371 694371 Payn, John, of Rode, Soms, husbandman 0
4772989 2287525 2287525 defendant Sumnour John merchant 694371 694371 Sumnour, John, of Rode, Soms, merchant 0
4786251 2291742 2291742 defendant Payn Thomas husbandman 694371 694371 Payn, Thomas, of Rode, Soms, husbandman 0
4786301 2291759 2291759 defendant Payn Thomas husbandman 694371 694371 Payn, Thomas, of Rode, Soms, husbandman 0
4805555 2297951 2297951 defendant Wodford Thomas weaver 694371 694371 Wodford, Thomas, of Rode, Soms, weaver 1
4917252 2331901 2331901 defendant Wevefeld or Wenefeld John butcher 694371 694371 Wevefeld or Wenefeld, John, of Rode, Soms, butcher 0
4920464 2332916 2332916 plaintiff James Thomas draper 694371 694371 James, Thomas, of Rode, Soms, draper 0
5009643 2359698 2359698 defendant Tropenell Philip fuller 694371 694371 Tropenell, Philip, of Rode, Soms, fuller 0
5133627 2396329 2396329 plaintiff Jamus Thomas (legal representative) 694371 694371 Jamus, Thomas, of Rode, Soms, executors of 0
5168600 2406538 2406538 plaintiff Estmonde John draper 694371 694371 Estmonde, John, of Rode, Soms, draper 0
5184598 2411243 2411243 plaintiff Estmonde John draper 694371 694371 Estmonde, John, of Rode, Soms, draper 0
5217713 2420910 2420910 defendant Estmond John clother 694371 694371 Estmond, John, of Rode, Soms, clother 12
5244430 2428554 2428554 plaintiff Pestell Adam clothmaker 694371 694371 Pestell, Adam, of Rode, Soms, clothmaker 0
5244433 2428555 2428555 plaintiff Pestell Adam clothmaker 694371 694371 Pestell, Adam, of Rode, Soms, clothmaker 0

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